20th November update:
Ok guys, spreadsheet is actually almost done (aside from copying the formluae to the AMD/nVidia/ATi sheets, and making it look a bit nicer).
What I need now are some numbers... but Intel only.
So, please use the form below to enter some values (the PPD can be made up if you want, but the Project numbers need to be valid).
Try and mix it up; one entry, try entering 4 WUs at once, then try 9 WUs at once. Again, Intel info only, and Project #s must be valid. The remaining info can be made up if you want.
Thank you. :)
Old stuff we don't need anymore. (Click to show)
6th October update:
Ok, I'd rather give the Folders a chance to help me out here than go elsewhere, so posting here.
I've been trying to find some way of combining the CPU/GPU PPD Databases together, to make it easier for both Folders to enter their data, and easier for me to add new WUs as they come. I think I've got the entry method fine; any GPU/CPU's PPD can be added for any WU from one form. However, splitting up those entries into separate sheets requires using some formulas that I'm not too familiar with.
This is where a helpful member can come in. In the post below is the "Master Sheet"; the page where all entries come in. Under that is the "AMD GPU" page (since it has the smallest number of WUs available to it, so is the easiest to start with).
In my mind, it's split in four parts:
1) Using the =IF command on the "CPU or GPU" column to find out which sheet it needs to be directed to.
2) Using the =CELL command to fill the OS/OCN Name columns.
3) Use the =IF command for GPU Model/Core/Driver (differentiating between AMD and nVidia).
4) The hardest part, and what I need most help with. Once the GPU type (nVidia/AMD) has been extablished, it takes the "Credit" value from the Master sheet (column T), then compares it to all available WUs (E1:J1 in the AMD GPU Sheet).
When it finds a matching WU, it enters all the info in the first available free row.
Lemme know if anyone's up for it.
Edited by zodac - 11/20/11 at 11:25am