I'll certainly clean it up - at the moment it is just copied and pasted from a spreadsheet - I hope I can make a much better looking table once I've got all the data together.
The biggie for me is the errors - I got bitten hard by that once in a lab job. If my results had been correct, someone was going to jail - it turned out my results depended only on how long the spectrophotometer had been switched on... :(
I plan to go through the light collection and get numbers for most of them. Since I'm doing instantaneous peak readings they only take a few seconds each - it takes longer to make sure I'm using fully charged cells in everything than it does to take the measurements.
Don't you think it would be more useful to take the reading after at least 30 seconds or so - not going for the highest output, but real-life performance?
Great work, Don! You are a real sport to take everyone's input and re-do the tests. It is kind of neat to see how some of them sag after a couple of minutes. I agree some of the lumens readings seem high, but it's still a great comparison of one light vs. another and, man, you have a lot of lights!
If I were to do all of them, it'd take quite a long time. What would be fun would be a way of collating all the information in one place - probably need a lot of hyperlinking to make it useful or the result would be a monstrous mess. I think I have around 100 lights now - will try to get them all in one place and count them some time soon.
However, have you looked at the inline HTML editor? Try it on data from a table of any size. Better still, don't.
I'm probably going to have to build the table in an external application.
Then I can put in links to my heart's desire.
This is going to take some time.
I've been looking around and I have a lot of reviews I need to finish....
But I do plan to link to good reviews regardless of who did them. This will require a bit of thought and design to prevent the result being an unreadable mess.
Looks like a very worthwhile place to investigate. Ultimately, what I want to do is a website in a table. How far that is possible within the time I have available is another matter.
But if Google Docs prevents me having to fight with M$ Office bugs then it's OK with me. I detest Microsoft software - I have spent too much time fighting it to do what i want. In a Word (95/97/2003) document it is not possible to embed more than 31 live spreadsheets. It will let you embed more than that, but the document will never open again. Got bitten by that one for the woman I love's thesis. The time to find this out is certainly not two days before the deadline when the data was still trickling in.
I will investigate Google Docs. I can do all of this in Excel (spit!) but not as live HTML. Pity I completely loathe Google and prefer not to use their products at all. Frankly, I'd rather use Microsoft than Google. And that is from someone who has been using Macs since 1989 and various Unix variants since about the same time.
Just don't ask me to use Solaris! (Slowlaris!) Despite owning a couple of Sun boxes.
However, exporting a spreadsheet of numbers to them is unlikely to leak data I'd rather it didn't. And by the time I've finished cleaning the data....