I have finished the spreadsheet
It is a work of art! Well, it is quite clever anyway. I spent ages rummaging around the OpenOffice help files looking for the keywords to make my formulas work.
There are probably easier ways of doing it but it works. Basically there are two worksheets. One has all the data for the CPUs plus the average PPD. Each CPU has a number [the row number].
In the second work sheet there are a few headings:
Username, CPU ID, CPU description, Points, Result
The formula in the Result column takes the value in Points and also finds the correct PPD value in the first worksheet from the number in CPU ID and does its jiggery pokery to work out the result. Clever eh
There is also a formula in the CPU Description field that automatically finds the description based on the CPU ID. Saves me a lot of typing
So the only information required from the entrants is their CPU.
Once I know it is rock solid [and works in Excel for those not using OO] I can give it to the points master or whatever. Although I am happy to get the numbers myself and just send rich/whoever the results.
The only thing that is of any concern now is someone joining with a CPU not covered in my spreadsheet. There aren't likely to be any AMD or Intel Desktop CPUs I am missing but I am just wondering about mobile CPUs and people with IBM Macs.
SiriusB