Various lights with lumen estimates

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

I can always copy it in excel and apply autofilter and sort ... but I have to do it every time you add a new light. Would be nice to have it online on a user basis ... I certainly don't want to mess up your list. Would be nice to filter for example 1xAA and then sort by output. I am very familiar with excel vba macros, but never worked with that google docs api.

Uh look:

- Sort and filter without modifying underlying data.

http://docs.google.com/support/bin/answer.py?hl=en&answer=139561

I took a look, but it is an editing operation unfortunately. It will not let me save it in that configuration without making it globally writeable.

The Publish HTML I tried didn't work here, it didn't update when I changed it immediately afterwards. And it and Drupal seemed to be fighting over the formatting.

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

is the republished link. Not sure if that'll do any good though.

What I have done is made a copy of the master sheet that it editable by anyone. Since I can revert it in seconds as it is a copy of the main sheet, feel free to play with it.

The link is.

I took a look, but it is an editing operation unfortunately.

It's not. List view is usable in read-only. I did it in http://budgetlightforum.cz.cc/node/505?page=2#comment-9691