Various lights with lumen estimates

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.

https://spreadsheets.google.com/pub?key=0ApkFM37n_QnRdDU5MDNzOURjYllmZHI4M3JYMUVwM0E&hl=en&single=true&gid=1&output=html

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

.

Lightbox lux Lightbox lux Lightbox lux Est. Lumens Est. Lumens Est. Lumens Throw at 1 metre lux

.

Light Battery Turn-on 30 secs 2 Minutes Switch-on 30 secs 2 Minutes Purchase Link

.

4Sevens Preon 2 High 2AAA NiMH 1074 944 912 193 169 164 1308 http://www.4sevens.com/product_info.php?cPath=297_332_367&products_id=2085

.

4Sevens Preon 2 Low 2AAA NiMH 18 18 18 3 3 3 22 http://www.4sevens.com/product_info.php?cPath=297_332_367&products_id=2085

.

4Sevens Preon 2 Low 2Alk. AAA 18 18 18 3 3 3 http://www.4sevens.com/product_info.php?cPath=297_332_367&products_id=2085

.

4Sevens Preon 2 Med 2AAA NiMH 187 182 182 34 33 33 251 http://www.4sevens.com/product_info.php?cPath=297_332_367&products_id=2085

.

4Sevens Preon 2 Med 2Alk. AAA 195 188 183 35 34 33 http://www.4sevens.com/product_info.php?cPath=297_332_367&products_id=2085

.

Akoray K-103 AAA NiMH 197 164 151 35 29 27 639 http://www.dealextreme.com/details.dx/sku.23994

.

Akoray K-103 10440 697 681 682 125 122 122 http://www.dealextreme.com/details.dx/sku.23994

.

Akoray K-106 AA NiMH 189 198 198 34 36 36 http://www.dealextreme.com/details.dx/sku.16607

.

Akoray K-106 14500 1055 1019 1004 189 183 180 http://www.dealextreme.com/details.dx/sku.16607

.

Aurora AK-P7 High 18650 2420 2140 2120 434 384 380 http://www.dealextreme.com/details.dx/sku.12588

.

Aurora AK-P7 Low 18650 266 269 272 48 48 49 http://www.dealextreme.com/details.dx/sku.12588

.

Aurora SH-032 High 18650 802 751 712 144 135 128 http://www.dealextreme.com/details.dx/sku.32563

.

Aurora SH-032 Low 18650 567 575 566 102 103 102 http://www.dealextreme.com/details.dx/sku.32563

.

Aurora SH-035 AA NiMH 644 116 0 0 http://www.dealextreme.com/details.dx/sku.36024

.

Aurora SH-035 High 14500 898 856 817 161 154 147 http://www.dealextreme.com/details.dx/sku.36024

.

Aurora SH-035 Low 14500 36 36 36 6 6 6 http://www.dealextreme.com/details.dx/sku.36024

.

Aurora SH-035 Med 14500 269 266 265 48 48 48 http://www.dealextreme.com/details.dx/sku.36024

.

Aurora SH0031 Alk. AAA 142 99 100 25 18 18 http://www.dealextreme.com/details.dx/sku.26244

.

BLF DeLight 1 AA NiMH 135 144 128 24 26 23 eBay

.

Elektrolumens triple K2 4C NiMH 1351 1284 1199 242 230 215 http://www.elektrolumens.com/

.

Elektrolumens triple K2 Old cells 4C NiMH 679 452 494 122 81 89 (No longer made)

.

Fenix E0 AAA NiMH 20 20 20 4 4 4

.

Fenix E0 * Near dead Alk. AAA 12 12 12 2 2 2 22

.

Fenix E01 AAA NiMH 31 31 31 6 6 6 http://www.4sevens.com/product_info.php?cPath=22&products_id=443

.

Fenix E01 Alk. AAA 37 33 32 7 6 6 60 http://www.4sevens.com/product_info.php?cPath=22&products_id=443

.

Fenix P3D High 2xCR123 469 462 465 84 83 83 2510

.

Fenix P3D Low 2xCR123 30 30 31 5 5 6 138

.

Fenix P3D Medium 2xCR123 197 198 203 35 36 36 1019

.

Fenix P3D Turbo 2xCR123 894 858 844 160 154 151 4170

.

Fusion 36 dropin 3D NiMH 1399 1382 1348 251 248 242 2430 http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=110561734403&ssPageName=STRK:MESINDXX:IT#ht_1405wt_913

.

Fusion 36 dropin 6D NiCd 1937 1868 1790 347 335 321 http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=110561734403&ssPageName=STRK:MESINDXX:IT#ht_1405wt_913

.

Fusion 36 dropin 5C Alkaline 1998 1913 1750 358 343 314 http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=110561734403&ssPageName=STRK:MESINDXX:IT#ht_1405wt_913

.

Fusion 36 dropin 6D NiMH 2220 2150 2050 398 386 368 http://cgi.ebay.co.uk/ws/eBayISAPI.dll?ViewItem&item=110561734403&ssPageName=STRK:MESINDXX:IT#ht_1405wt_913

.

Golston "7W" 2xRCR123 425 327 311 76 59 56 Quality China Goods (No longer on sale)

.

Hugsby P31 with P32 Gold driver 14500 1176 1084 1064 211 194 191 http://www.kaidomain.com/ProductDetails.aspx?ProductId=10741

.

Hugsby P32 High Li Primary 527 472 461 95 85 83 http://www.kaidomain.com/ProductDetails.aspx?ProductId=10739

.

Hugsby P32 High AA NiMH 650 597 554 117 107 99 http://www.kaidomain.com/ProductDetails.aspx?ProductId=10739

.

Hugsby P32 Low Li Primary 201 197 197 36 35 35 http://www.kaidomain.com/ProductDetails.aspx?ProductId=10739

.

Hugsby P32 Low AA NiMH 214 199 195 38 36 35 http://www.kaidomain.com/ProductDetails.aspx?ProductId=10739

.

ITP A3 EOS Upgrade High AAA NiMH 496 421 388 89 76 70 653

.

ITP A3 EOS Upgrade High 10440 1259 1040 226 187 0

.

ITP A3 EOS Upgrade Low AAA NiMH 11 11 11 2 2 2 18

.

ITP A3 EOS Upgrade Medium AAA NiMH 123 116 113 22 21 20 192

.

ITP A3 EOS Upgrade Medium 10440 459 82

.

Lumahunter MRV SE High 18650 1462 1380 1323 262 248 237

.

Lumapower MRV SE Low 18650 110 110 110 20 20 20

.

Lumapower MRV SE Medium 18650 630 634 633 113 114 114

.

Maglite Solitaire w. Lambda LED Alk AAA 34 33 33 6 6 6 76

.

MDXL "3W" AA NiMH 69 72 73 12 13 13

.

MDXL AAA Clicky AAA NiMH 109 103 96 20 18 17

.

MDXL AAA Twisty AAA NiMH 102 95 91 18 17 16

.

MDXL AAA Twisty 10440 267 150 0 48 27 0

.

MrLite KC-05 High AAA NiMH 341 328 310 61 59 56

.

MrLite KC-05 Low AAA NiMH 42 41 41 8 7 7

.

MrLite KC-05 Mode 2 AAA NiMH 76 74 74 14 13 13

.

MrLite KC-05 Mode 3 AAA NiMH 210 198 185 38 36 33

.

MrLite KC-05 Mode 4 AAA NiMH 38 36 35

.

Mrlite Lipstick AAA NiMH 214 201 194 38 36 35

.

MX Power ML-310 High 14500 900 798 739 161 143 133

.

MX Power ML-310 Low 14500 216 211 208 39 38 37

.

Nuwai Luxeon V 3 CR123 462 405 387 83 73 69

.

Nuwai Luxeon V 2 17500 462 418 402 83 75 72

.

Piritlight SG-L8 MC-E High 18650 2400 2280 2120 430 409 380 http://www.dealextreme.com/details.dx/sku.19466

.

Piritlight SG-L8 MC-E Low 18650 282 286 288 51 51 52 http://www.dealextreme.com/details.dx/sku.19466

.

Piritlight SG-L8 MC-E Med 18650 800 816 824 143 146 148 http://www.dealextreme.com/details.dx/sku.19466

.

Powerlight 1 AA NiMH 64 64 62 11 11 11

.

Romisen RC-C6 high wide RCR123 697 732 751 125 131 135 http://www.dinodirect.com/focusing-flashlight-150lumens-cree-q3-led.html

.

Romisen RC-C6 High Zoom RCR123 333 335 349 60 60 63 http://www.dinodirect.com/focusing-flashlight-150lumens-cree-q3-led.html

.

Romisen RC-C6 Low wide RCR123 181 189 192 32 34 34 http://www.dinodirect.com/focusing-flashlight-150lumens-cree-q3-led.html

.

Romisen RC-C6 Low Zoom RCR123 95 97 99 17 17 18 http://www.dinodirect.com/focusing-flashlight-150lumens-cree-q3-led.html

.

Romisen RC-F4 2xRCR123 901 731 661 162 131 119

.

Romisen RC-T5 High 2 18650 2490 2290 2200 447 411 395 http://www.dealextreme.com/details.dx/sku.10452

.

Romisen RC-T5 Low 2 18650 990 989 986 178 177 177 http://www.dealextreme.com/details.dx/sku.10452

.

Romisen RC-T6 High 2 18650 3760 3620 3450 674 649 619 http://www.dealextreme.com/details.dx/sku.15686

.

Romisen RC-T6 Low 2 18650 1615 1535 1494 290 275 268 http://www.dealextreme.com/details.dx/sku.15686

.

Romisen RC-T6 Medium 2 18650 2490 2390 2340 447 429 420 http://www.dealextreme.com/details.dx/sku.15686

.

ROP High 2x32600 3760 3600 3080 674 646 552 http://www.lighthound.com/Pelican-Big-D-Rechargeable-Lamp-Set-FL-3854_p_1506.html

.

ROP Low 6D NiMH 1670 1568 1422 300 281 255 http://www.lighthound.com/Pelican-Big-D-Rechargeable-Lamp-Set-FL-3854_p_1506.html

.

Sinounion eBay penlight 2 AAA NiMH 53 53 52 10 10 9 http://cgi.ebay.co.uk/15-lumens-LED-Penlight-/120621014068?pt=LH_DefaultDomain_0&hash=item1c15929c34#ht_828wt_913

.

Sinounion eBay penlight 2 Alk. AAA 61 11 0 0 http://cgi.ebay.co.uk/15-lumens-LED-Penlight-/120621014068?pt=LH_DefaultDomain_0&hash=item1c15929c34#ht_828wt_913

.

Smallsun ZY-C85 14500 867 766 735 156 137 132 http://www.dealextreme.com/details.dx/sku.33708

.

Smallsun ZY-C85 full zoom 14500 581 542 498 104 97 89 http://www.dealextreme.com/details.dx/sku.33708

.

Solarforce L2M DX P7 18650 1956 351 0 0 http://cgi.ebay.co.uk/Solarforce-L2M-CR123A-18650-BK-Flashlight-Body-/270633104631?pt=AU_Sport_Camping_Hiking_Lamps_Torches&hash=item3f02fd74f7#ht_2768wt_955

.

Solarforce L2R Solarforce low voltage R2 2xNiMH 779 140 0 0 http://cgi.ebay.co.uk/Solarforce-L2r-BLACK-AA-Battery-flashlight-Body-/280428612537?pt=US_Flashlights&hash=item414ad90bb9#ht_2682wt_913

.

Solarforce L2R Solarforce low voltage R2 2AA NiMH 679 646 634 122 116 114

.

Solarforce Skyline 1 2 CR123 880 158 0 0

.

Tank007 E07 (1) AA NiMH 423 372 343 76 67 62 http://www.dealextreme.com/details.dx/sku.24125

.

Tank007 E07 (2) AA NiMH 310 385 384 56 69 69 http://www.dealextreme.com/details.dx/sku.24125

.

Tank007 TK-703 Alk. AAA 237 181 160 43 32 29 http://www.dealextreme.com/details.dx/sku.26989

.

Tank007 TK-703 AAA NiMH 445 395 333 80 71 60 http://www.dealextreme.com/details.dx/sku.26989

.

TiKey 3xLR44 81 71 64 15 13 11 177

.

Trustfire F22 AA NiMH 586 105 0 0 http://www.dealextreme.com/details.dx/sku.31731

.

Trustfire F22 14500 1254 1128 1030 225 202 185 http://www.dealextreme.com/details.dx/sku.31731

.

Trustfire F22 High Li Primary 325 324 375 58 58 67 http://www.dealextreme.com/details.dx/sku.31731

.

Trustfire F22 Low Li primary 41 43 41 7 8 7 http://www.dealextreme.com/details.dx/sku.31731

.

Trustfire F22 Med Li Primary 177 178 179 32 32 32 http://www.dealextreme.com/details.dx/sku.31731

.

Trustfire R5-A3 High AA NiMH 650 117 0 0 1750 http://www.dealextreme.com/details.dx/sku.39062

.

Trustfire R5-A3 14500 1630 1482 1416 292 266 254 4580 http://www.dealextreme.com/details.dx/sku.39062

.

Trustfire XP-E F23 High AAA NiMH 383 334 312 69 60 56 http://www.dealextreme.com/details.dx/sku.24291

.

Trustfire XP-E F23 High 10440 957 785 702 172 141 126 http://www.dealextreme.com/details.dx/sku.24291

.

Trustfire XP-E F23 Low 10440 90 88 87 16 16 16 http://www.dealextreme.com/details.dx/sku.24291

.

Trustfire XP-E F23 Low ** AAA NiMH 33 34 6 6 0 http://www.dealextreme.com/details.dx/sku.24291

.

Trustfire Z1 High RCR123 919 875 833 165 157 149

.

Trustfire Z1 low RCR123 87 90 84 16 16 15

.

Ultra-budget C3 clone 2xNiMH 144 111 83 26 20 15

.

Ultrafire A1 High RCR123 813 771 717 146 138 129 http://www.dealextreme.com/details.dx/sku.16844

.

Ultrafire A1 Low RCR123 45 45 44 8 8 8 http://www.dealextreme.com/details.dx/sku.16844

.

Ultrafire A1 Medium RCR123 274 272 268 49 49 48 http://www.dealextreme.com/details.dx/sku.16844

.

Ultrafire A30B RCR123 909 163 0 0 http://www.dealextreme.com/details.dx/sku.21478

.

Ultrafire C3 (P4) AA NiMH 229 234 233 41 42 42 http://www.dealextreme.com/details.dx/sku.4452

.

Ultrafire C3 (P4) 14500 457 438 444 82 79 80 http://www.dealextreme.com/details.dx/sku.4452

.

Ultrafire C3 (P4) 2AA NiMH 781 455 452 140 82 81 1750 http://www.dealextreme.com/details.dx/sku.4452

.

Ultrafire C3 (P4) No. 2 14500 1347 1118 1089 242 201 195 http://www.dealextreme.com/details.dx/sku.18305

.

Ultrafire C3 (P4) No. 3 14500 1176 1099 977 211 197 175 http://www.dealextreme.com/details.dx/sku.18305

.

Ultrafire C3 (P4) No. 4 14500 865 819 740 155 147 133 http://www.dealextreme.com/details.dx/sku.18305

.

Ultrafire C3 Grey Q5 AA NiMH 664 629 596 119 113 107 http://www.dealextreme.com/details.dx/sku.44254

.

Ultrafire C3 Grey Q5 2AA NiMH 986 954 924 177 171 166 5080 http://www.dealextreme.com/details.dx/sku.44254

.

Ultrafire C3 Grey Q5 14500 1359 1205 1149 244 216 206 http://www.dealextreme.com/details.dx/sku.44254

.

Ultrafire C3 Grey Q5 3AA NiMH 1304 1163 1081 234 209 194 http://www.dealextreme.com/details.dx/sku.44254

.

Ultrafire C3 Grey Q5 Li primary 678 572 544 122 103 98 http://www.dealextreme.com/details.dx/sku.44254

.

Ultrafire C3 SS Q5 AA NiMH 718 620 574 129 111 103 http://www.dealextreme.com/details.dx/sku.26122

.

Ultrafire C3 SS Q5 14500 1391 1259 1122 250 226 201 http://www.dealextreme.com/details.dx/sku.26122

.

Ultrafire RL-118 RCR123 1260 226 0 0 http://www.dealextreme.com/details.dx/sku.26992

.

Ultrafire WF-500 2 18650 2300 2040 1507 413 366 270 http://www.dealextreme.com/details.dx/sku.1317

.

Ultrafire WF-501B M bin MC-E 18650 3240 2990 2720 581 536 488 http://www.dealextreme.com/details.dx/sku.39359

.

Ultrafire WF-502B R2 single mode 18650 940 169 0 0 http://www.dealextreme.com/details.dx/sku.16178

.

Ultrafire WF-503B DX MC-E High 18650 1508 1407 1355 270 252 243

.

Ultrafire WF-503B DX MC-E Low 18650 540 550 544 97 99 98

.

Ultrafire WF-504B - 5 mode R2 High 18650 1148 1092 1023 206 196 183

.

Ultrafire WF-504B - 5 mode R2 Low 18650 155 155 155 28 28 28

.

Ultrafire WF-504B - 5 mode R2 Med 18650 445 442 440 80 79 79

.

Ultrafire WF-504B KD MC-E High 18650 2400 2360 2170 430 423 389

.

Ultrafire WF-504B KD MC-E Low 18650 75 75 73 13 13 13

.

Ultrafire WF-504B KD MC-E Med 18650 1819 1733 1640 326 311 294

.

Ultrafire WF-602C 10440 210 190 185 38 34 33

.

Uniquefire AA-S1 Li Primary 502 446 459 90 80 82 http://www.dealextreme.com/details.dx/sku.24220

.

Uniquefire AA-S1 AA NiMH 565 557 531 101 100 95 http://www.dealextreme.com/details.dx/sku.24220

.

Uniquefire AA-S1 14500 1255 1183 1162 225 212 208 http://www.dealextreme.com/details.dx/sku.24220

.

Uniquefire L2 w DX 5 mode R5 dropin 2 RCR123 1437 258 0 0 http://www.dealextreme.com/details.dx/sku.33549

.

Uniquefire L2 w DX 5 mode R5 dropin 18650 1578 283 0 0 http://www.dealextreme.com/details.dx/sku.33549

.

Uniquefire R5 5 mode XP-G R5 High 2 IMR16340 1477 1320 1220 265 237 219 http://www.dealextreme.com/details.dx/sku.32721

.

Uniquefire R5 5 mode XP-G R5 High 18650 1599 1409 1318 287 253 236 http://www.dealextreme.com/details.dx/sku.32721

.

Uniquefire R5 5 mode XP-G R5 Low 18650 73 73 73 13 13 13 http://www.dealextreme.com/details.dx/sku.32721

.

Uniquefire R5 5 mode XP-G R5 Med 18650 144 143 144 26 26 26 http://www.dealextreme.com/details.dx/sku.32721

.

Uniquefire S10 AA NiMH 575 103 0 0 http://www.dealextreme.com/details.dx/sku.30987

.

Uniquefire S10 14500 1112 1017 962 199 182 173 http://www.dealextreme.com/details.dx/sku.30987

.

Varapower prototype 4C NiMH 8650 8330 6260 1552 1494 1123 21500 http://www.lambdalights.com/varaorders.html

.

Aurora SH-034 High IMR 16340 937 856 806 168 154 145 9160 http://www.dealextreme.com/details.dx/sku.33813

.

Aurora SH-034 Low IMR 16340 35 35 35 6 6 6 325 http://www.dealextreme.com/details.dx/sku.33813

.

Aurora SH-034 Medium IMR 16340 281 277 273 50 50 49 2800 http://www.dealextreme.com/details.dx/sku.33813

.

Poundland button cell thing 4 AG4 23

.

MDXL "3W" AAA clickie AAA NiMH 91

.

Trustfire R5-A3 Low AA NiMH 999

.

Aurora SH0031 AAA NiMH 607

.

Aurora SH-033 High RCR2 744 133 0 0 2920 http://www.dealextreme.com/details.dx/sku.36025

.

Aurora SH-033 Med RCR2 873 http://www.dealextreme.com/details.dx/sku.36025

.

Aurora SH-033 Low RCR2 122 http://www.dealextreme.com/details.dx/sku.36025

Published by Google Docs



Well it sorta kinda worked - not pretty though. Time for a think and some coffee

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"

I also was wondering the same thing in here:

http://budgetlightforum.cz.cc/node/361#comment-7708

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.

Have you seen THIS?

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).

Instead of trying to understand that POS ajax app, I should've just tried out the spreadsheet UI.

Everyone, instead of being dumb like me use this:

In menu, View->List View

In list view, you can do what that crappy filter app does, plus sort on column.

Can I do that on Don's list without having the password? It asks for a login....

I hope you can't. I don't want it vandalised you see. See the PM I just sent though. You are welcome to copy it and do what you like with it for any non-commercial use. I may make it more open once I've got all the data collated and in one place - and backed up...