I have big problems with Google (I'd rather deal with Everybuying!) which was the real issue. But it does what I want and they don't want money. In fact the Google Docs spreadsheet now has information I don't have in the parent spreadsheet. This was probably a mistake as version control is going to get complicated. But with a bit of experimenting I may be able to get what I want out of Docs which is essentially to collate all the information I can find about a given light and pull it together in one place.
And in a form that is still usable. Since I am usually using a 2560 pixel wide screen I can get more onscreen than most people and don't want to force people to scroll sideways. I totally hate that. I suppose he way to go is a hyperlinked sheet for each light so that fuller information can be given there.
Battery life needs to be on the front sheet and probably a star rating and build quality assessment so that people only need to dig into the lights that look like they might actually be interesting to them.
Information overload is a problem and I don't want to add to it.
This is all designing at the keyboard which is always a bad idea.
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.
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..
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...
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...