Sounds interesting - will need to take some time to see what can be done.
Sounds interesting - will need to take some time to see what can be done.
Here is the latest version.
Must dig out the old C3s and see how they compare.
Light | Battery | Lightbox Immediate | Lightbox 30 seconds |
ITP A3 EOS Upgrade Low | AAA NiMH | 11 | 11 |
Fenix E0 * | Alk. AAA | 12 | 12 |
4Sevens Preon 2 Low | 2AAA NiMH | 18 | 18 |
4Sevens Preon 2 Low | 2Alk. AAA | 18 | 18 |
Fenix E0 | AAA NiMH | 20 | 20 |
Fenix P3D Low | 2xCR123 | 30 | 30 |
Fenix E01 | AAA NiMH | 31 | 31 |
Trustfire XP-E F23 Low ** | AAA NiMH | 33 | 34 |
Maglite Solitaire w. Lambda LED | Alk AAA | 34 | 33 |
Aurora SH-035 Low | 14500 | 36 | 36 |
Fenix E01 | Alk. AAA | 37 | 33 |
MrLite KC-05 Low | AAA NiMH | 42 | 41 |
Ultrafire A1 Low | RCR123 | 45 | 45 |
Sinounion eBay penlight | 2 AAA NiMH | 53 | 53 |
Sinounion eBay penlight | 2 Alk. AAA | 61 | |
Powerlight 1 | AA NiMH | 64 | 64 |
MDXL "3W" | AA NiMH | 69 | 72 |
Uniquefire R5 5 mode XP-G R5 Low | 18650 | 73 | 73 |
Ultrafire WF-504B KD MC-E Low | 18650 | 75 | 75 |
MrLite KC-05 Mode 2 | AAA NiMH | 76 | 74 |
TiKey | 3xLR44 | 81 | 71 |
Trustfire Z1 low | RCR123 | 87 | 90 |
Trustfire XP-E F23 Low | 10440 | 90 | 88 |
Romisen RC-C6 Low Zoom | RCR123 | 95 | 97 |
MDXL AAA Twisty | AAA NiMH | 102 | 95 |
MDXL AAA Clicky | AAA NiMH | 109 | 103 |
Lumapower MRV SE Low | 18650 | 110 | 110 |
ITP A3 EOS Upgrade Medium | AAA NiMH | 123 | 116 |
BLF DeLight 1 | AA NiMH | 135 | 144 |
Aurora SH0031 | Alk. AAA | 142 | 99 |
Ultra-budget C3 clone | 2xNiMH | 144 | 111 |
Uniquefire R5 5 mode XP-G R5 Med | 18650 | 144 | 143 |
Ultrafire WF-504B - 5 mode R2 Low | 18650 | 155 | 155 |
Romisen RC-C6 Low wide | RCR123 | 181 | 189 |
4Sevens Preon 2 Med | 2AAA NiMH | 187 | 182 |
Akoray K-106 | AA NiMH | 189 | 198 |
4Sevens Preon 2 Med | 2Alk. AAA | 195 | 188 |
Akoray K-103 | AAA NiMH | 197 | 164 |
Fenix P3D Medium | 2xCR123 | 197 | 198 |
Hugsby P32 Low | Li Primary | 201 | 197 |
MrLite KC-05 Mode 3 | AAA NiMH | 210 | 198 |
Ultrafire WF-602C | 10440 | 210 | 190 |
Hugsby P32 Low | AA NiMH | 214 | 199 |
Mrlite Lipstick | AAA NiMH | 214 | 201 |
MX Power ML-310 Low | 14500 | 216 | 211 |
Tank007 TK-703 | Alk. AAA | 237 | 181 |
Aurora AK-P7 Low | 18650 | 266 | 269 |
MDXL AAA Twisty | 10440 | 267 | 150 |
Aurora SH-035 Med | 14500 | 269 | 266 |
Ultrafire A1 Medium | RCR123 | 274 | 272 |
Piritlight SG-L8 MC-E Low | 18650 | 282 | 286 |
Tank007 E07 (2) | AA NiMH | 310 | 385 |
Romisen RC-C6 High Zoom | RCR123 | 333 | 335 |
MrLite KC-05 High | AAA NiMH | 341 | 328 |
Trustfire XP-E F23 High | AAA NiMH | 383 | 334 |
Tank007 E07 (1) | AA NiMH | 423 | 372 |
Golston "7W" | 2xRCR123 | 425 | 327 |
Tank007 TK-703 | AAA NiMH | 445 | 395 |
Ultrafire WF-504B - 5 mode R2 Med | 18650 | 445 | 442 |
ITP A3 EOS Upgrade Medium | 10440 | 459 | |
Fenix P3D High | 2xCR123 | 469 | 462 |
ITP A3 EOS Upgrade High | AAA NiMH | 496 | 421 |
Uniquefire AA-S1 | Li Primary | 502 | 446 |
Hugsby P32 High | Li Primary | 527 | 472 |
Ultrafire WF-503B DX MC-E Low | 18650 | 540 | 550 |
Uniquefire AA-S1 | AA NiMH | 565 | 557 |
Uniquefire S10 | AA NiMH | 575 | |
Smallsun ZY-C85 full zoom | 14500 | 581 | 542 |
Trustfire F22 | AA NiMH | 586 | |
Lumapower MRV SE Medium | 18650 | 630 | 634 |
Aurora SH-035 | AA NiMH | 644 | |
Hugsby P32 High | AA NiMH | 650 | 597 |
Trustfire R5-A3 | AA NiMH | 650 | |
Ultrafire C3 Grey Q5 | AA NiMH | 664 | 629 |
Elektrolumens triple K2 Old cells | 4C NiMH | 679 | 452 |
Akoray K-103 | 10440 | 697 | 681 |
Romisen RC-C6 high wide | RCR123 | 697 | 732 |
Ultrafire C3 SS Q5 | AA NiMH | 718 | 620 |
Aurora SH-033 | RCR2 | 744 | |
Solarforce L2R Solarforce low voltage R2 | 2xNiMH | 779 | |
Piritlight SG-L8 MC-E Med | 18650 | 800 | 816 |
Ultrafire A1 High | RCR123 | 813 | 771 |
Smallsun ZY-C85 | 14500 | 867 | 766 |
Solarforce Skyline 1 | 2 CR123 | 880 | |
4Sevens Preon 2 High | 2Alk. AAA | 892 | 823 |
Fenix P3D Turbo | 2xCR123 | 894 | 858 |
Aurora SH-035 High | 14500 | 898 | 856 |
MX Power ML-310 High | 14500 | 900 | 798 |
Romisen RC-F4 | 2xRCR123 | 901 | 731 |
Ultrafire A30B | RCR123 | 909 | |
Trustfire Z1 High | RCR123 | 919 | 875 |
Ultrafire WF-502B R2 single mode | 18650 | 940 | |
Trustfire XP-E F23 High | 10440 | 957 | 785 |
Ultrafire C3 Grey Q5 | 2AA NiMH | 986 | 954 |
Romisen RC-T5 Low | 2 18650 | 990 | 989 |
a first batch Aurora SH-034 | RCR123 | 1016 | |
Akoray K-106 | 14500 | 1055 | 1019 |
4Sevens Preon 2 High | 2AAA NiMH | 1074 | 944 |
Uniquefire S10 | 14500 | 1112 | 1017 |
Ultrafire WF-504B - 5 mode R2 High | 18650 | 1148 | 1092 |
Hugsby P31 with P32 Gold driver | 14500 | 1176 | 1084 |
Trustfire F22 | 14500 | 1254 | 1128 |
Uniquefire AA-S1 | 14500 | 1255 | 1183 |
ITP A3 EOS Upgrade High | 10440 | 1259 | 1040 |
Ultrafire RL-118 | RCR123 | 1260 | |
Elektrolumens triple K2 | 4C NiMH | 1351 | 1284 |
Ultrafire C3 Grey Q5 | 14500 | 1359 | 1205 |
Ultrafire C3 SS Q5 | 14500 | 1391 | 1259 |
Fusion 36 dropin | 3D NiMH | 1399 | 1382 |
Uniquefire L2 w DX 5 mode R5 dropin | 2 RCR123 | 1437 | |
Lumahunter MRV SE High | 18650 | 1462 | 1380 |
Uniquefire R5 5 mode XP-G R5 High | 2 IMR16340 | 1477 | 1320 |
Ultrafire WF-503B DX MC-E High | 18650 | 1508 | 1407 |
Uniquefire L2 w DX 5 mode R5 dropin | 18650 | 1578 | |
Uniquefire R5 5 mode XP-G R5 High | 18650 | 1599 | 1409 |
Romisen RC-T6 Low | 2 18650 | 1615 | 1535 |
Trustfire R5-A3 | 14500 | 1630 | 1482 |
ROP Low | 6D NiMH | 1670 | 1568 |
Ultrafire WF-504B KD MC-E Med | 18650 | 1819 | 1733 |
Fusion 36 dropin | 6D NiCd | 1937 | 1868 |
Solarforce L2M DX P7 | 18650 | 1956 | |
Fusion 36 dropin | 5C Alkaline | 1998 | 1913 |
Fusion 36 dropin | 6D NiMH | 2220 | 2150 |
Ultrafire WF-500 | 2 18650 | 2300 | 2040 |
Piritlight SG-L8 MC-E High | 18650 | 2400 | 2280 |
Ultrafire WF-504B KD MC-E High | 18650 | 2400 | 2360 |
Aurora AK-P7 High | 18650 | 2420 | 2140 |
Romisen RC-T5 High | 2 18650 | 2490 | 2290 |
Romisen RC-T6 Medium | 2 18650 | 2490 | 2390 |
Ultrafire WF-501B M bin MC-E | 18650 | 3240 | 2990 |
Romisen RC-T6 High | 2 18650 | 3760 | 3620 |
ROP High | 2x32600 | 3760 | 3600 |
Varapower prototype | 4C NiMH | 8650 | 8330 |
MrLite KC-05 Mode 4 | AAA NiMH | ||
Ultrafire C3 Grey Q5 | 3AA NiMH | ||
Ultrafire C3 Grey Q5 | Li primary |
Google Docs version also updated.
More numbers added (Aurora SH-034) to the spreadsheet here
This now contains more info than the parent spreadsheet.
Version control issues are going to arise (Hah! Have £%^$^$%&* arisen) soon so don't be surprised if the Google Docs spreadsheet changes radically in the near future while I sort out version control and formatting issues.
Time for some fun - throw numbers for the tiny and dim lights. Should be on the spreadsheet shortly.
What I want to do is conceptually similar to embedding a photo but with a Google Docs spreadsheet.
Now how to embed it? The insert/edit embedded media button isn't helping as it expects video formats.
Suppose I could copy and paste the source for the Google Docs output...
Many lights : Sheet2 |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Published by Google Docs
Seems to work! :D
It doesn't matter for me, as I always have the shortcut to your GoogleDoc in my Docs :)
No praise is too high for the work you have done so far. Thanks very much for your effort.
That's certainly the best bet for now - the formatting above is quite a long way from pretty. I think i have another 40 or so lights to go, several of these duplicates which should give a feel for reliability of the data.
Edit: Especially as the embedded version above is not updating which was the whole point of trying it. Ah well, back to the thinking..
Solarforce L2m with extension and 2 18650.
Solarforce single mode 18V R5 dropin and DX 5 mode 18V R5 dropin.
RQ Raidfire Spear clone. Really good throw.
78 lights now
Apparently SZWholesale/QCC have got themselves an "integrating sphere" and some sort of spectro capable device.
Their results are in line with yours (though about 20% lower for this, about right for the trustfire xp-g a3, 20% higher for z1).
http://www.qualitychinagoods.com/ugsby-cree-3mode-80lumens-flashlightfcp32-p-1749.html
btw, LOL "ugsby"
Don thinks they read low. I think more likely many chinese lights are crap design or bad quality control, but I haven't seen their sphere so who knows. They have p7/mc-e with close to 600lum which is about the OTF limit for these, and I saw 750lum for sst-50.
I seriously doubt many of these sst's are getting much more than 3 amps. The only "sst" driver is on KD and it seems to be a slightly modified p7 driver that someone measured at barely over 3amps.
Here is an idea for logging current draw and output. This is a little tricky to do as I have to read two meters simultaneously. Anyway, here's the link.
Looks good. Might want to put in the units since numbers are similar in magnitude.
btw, I'm guessing that voltage across the batteries is for open circuit? I guess if you always used the same battery it's ok, especially if you can do a V vs A chart for it.
It doesn't work (at least that app doesn't, api probably does). The problem is that it assumes a 23 length key and new keys from goog sheets are longer...
Ok, it's a pretty easy fix:
Search for this:
if(result.length == 23) return result;
return "";
replace with this:
//if(result.length == 23) return result;
return result;
but then the problem is that it cannot load/stream columns without a "header" (ie. something in the first row), and some columns start on the second row, so only columns like lightbox lux are displayed.
Even then, what it does it is only "filter" (display/hide), not sort.
So basically this needs to be rewrite to still use the api, but with different functionality. And it's web development/javascript, blaugh...
The last time I did any coding was 1979. However, I'll take a look and see what I can do with it.
Since it doesn't require write access to the sheet this should be feasible.
It is no big deal to rearrange the sheet appropriately - but some of the data is only available from it as I've just plugged in numbers from all over the place, a lot of my reviews only exist online.
If you're going to do this, the easy way is to make the changes to
constructTable()
_datarows contains the values for the rows. The minimal change is to do a sort on that table structure in the function before the loops that create the html table elements (I would just create another array that parallels _datarows, sort the array[i] entries by the selected column and use that in the loops).
For UI, radio buttons for each column and one more for "none" makes sense.
The alternative is to use the api's built in sort (orderby) function. However this would require more drastic changes to that app, since it uses the cell based feed type from the sheet api, and the sort seems to work on the list (ie. row) based access api.
I'm not a web developer but I'm pretty sure the above is correct (given http://code.google.com/apis/spreadsheets/data/2.0/reference.html#WorksheetFeed).