I think I'm concluding that I don't know what problem is being solved by this sheet.
This spreadsheet is used to track your times for your various cars in a given class. You would have a workbook for each class, 10 of them alltogether. Where as the leaderboard performs a rollup of
your best times, this sheet performs a roll up for each car in your garage.
As time goes on and you accumulate data - times on the various cars that you build - it becomes feasable to sort the sheet on any of the tracks, or by any of the ranking fields. This can help you make decisions about which car is best for which task, and so on.
The sheet also provides a check/balance against your Hotlap rankings.
And now it provides a simplified (at least I thought so) goal managment system.
Additionally, there is a stat sheet (Stable) where you can accumulate information about each car. Although this data can be entered, the way that I use it is to link to the various cells in my Car Sheet. This creates a WORM (write once, read many) scenario, a sort of ersatz Object Oriented design. Information about a car is maintained in the Car Sheet. It is viewed, sorted and compared in the Stable sheet.
What goes in cells B3-B13?
That is where you enter the car's name, or a link to the cell where the car's name is stored. You can have as many rows here as is needed. For instance, my A Class sheet has around 40 cars in it.
Why the different colors in column A?
That is a cutesy deal I put in place to quickly draw attention to the top 5 cars, or the top 10 cars. It was also me just experimenting with runtime formatting.
What are the abbreviations QR, FR, TR and PR?
This question hilites the main problem here. There are discussions and projects that have been going on for a number of months - this sheet just comprises some of them. QR is Quick Rank, FR = Flowing Rank, Twisty Rank, and Power Rank. The columns associated with those acronyms rollup the times associated with tracks that meet its namesake conditions. The ranking system has been discussed in threads all over this board. In this garage particularly, the ranking system is discussed in the thread
Quick Rank Discussion, and is described in the first post of the thread
Thawts and other Stuff. And while I'm at it, even tho the attachments are no longer there (I am trying to keep the latest and greatest just on the tip), most of the posts in the
Spreadsheets thread have information about dealing with the leaderboard sheets.
What is the "snapshot" line?
The line just below the Snapshot line is a rollup line - actually, it contains the minimum time entered for each of the tracks. The results should be exactly like looking at your times on the actual leaderboard. If the rollup row is row 21, then the cell E21 contains the, or should contain, the exact value as your overall time for each of the track subdivisions... Real World, Original Track, and Reverse Tracks. Note: until you have completed all the tracks, these Overall times will be the same rounded off Hr:Min:ss as the Over All Classes rank.
Now, let us assume that you are starting a project in D class - you are going to be tuning your cars, and practicing, trying to improve. It would be nice to measure how much of an improvement you've made during this project. That is the snapshot line. You would hilite the rollup cells (D21:AN21) and copy them. Then you would right click on the cell D20, select "Paste Special" from the popup menu, then click the option "Values" from the "Paste Special" dialog box. The Improvement line will become all zeros, and now it will total just the improvements that you make during your project.
And the "% Numero Uno %" - what goes in there?
The Number One time for each of the tracks. Numero Uno is Spanish for Number One.
Finally the "percentage goal" - does 95% mean the number one time from the leaderboard divided by my time should be >= 95% (as a goal)?
With a Goal Percentage of 95% you are saying "I want to be within 5% of the very best time. So,
If the Number on time is 100 seconds, then your goal will be 100 / .95 or 105.263 seconds. If your current time is 108 seconds then you need to improve your time by 2.737 seconds. All of this is calculated for you. All you need to do is enter your times when you run them, and enter the number one time (it is right there when you select a track in Free Run - take a couple seconds and update your sheet. Its not that big a hastle.
I think the primary problem is that I didn't doc the thing like the person getting the sheet had never been here before. I sort of assumed that he would have read what has been going on, or may even have the previous versions of the sheet and be pretty well versed in its use. A lot of this stuff has been around quite awhile. Quick Rank was started during the first month of Forza One. There has been too much go by for me to re-hash it from the ground up every time we want to talk about it.
You might want to take some time and read through some of the threads in my garage here. Almost all of them deal in one form or another with the spreadsheets that are stored in the Archive.
$
