The challenge - should you choose to accept it - is to see if you can figure out how to come up with all the calculations. The colored items are text and data entries. The starting spreadsheet (without the formulas) can be downloaded by Clicking Here (12k). The numbers in white - YOU are suppose to come up with a formula to calculate these. Several of these use an array function - You have to hold down the (Mac - Apple, Shift, and then hit Return keys on the Mac ----- and on the PC -- Control, Shift and then hit the Enter key). When you have correctly entered an array function you will see curly brackets {} around the equation.
The starting spreadsheet (without the formulas) can be downloaded by Clicking Here (12k).
If you Give UP (or need to peek) - the completed spreadsheet (with the formulas) can be downloaded by Clicking Here (13k).
Both of these files are virus free and macro free. 117230