Set up
I suggest having the top line for the circuits, but first type in the names of drivers and teams in first two columns, I personally tend to enter drivers who race for multiple teams in seperate rows as it makes calculating team points easier. For example
PATRESE | Benetton
HERBERT | Benetton
.
(other drivers)
.
HERBERT | Lotus
Once you have done this type in the circuits using two letter codes in the top line from column 3.
You can now enter the data in your spreadsheet as you see fit. I suggest using 1 for a win, 2 for second, etc.
Counting things
To count wins you can use
=COUNTIF(start range,range end;1)
(for example to count for 16 races you would use
=COUNTIF(C2:R2;1)
)
you can count 2nds, 3rd, 4th, etc using the same way. Once you have done one, copy it and highlight all the rows below to the last driver and paste it in.
Points
Points are a bit more tricky but are simple with a function like this. (this counts points for the 1980-1991 season)
=(COUNTIF(C47:U47;1)*9)+(COUNTIF(C47:U47;2)*6)+(COUNTIF(C47:U47;3)*4)+(COUNTIF(C47:U47;4)*3)+(COUNTIF(C47:U47;5)*2)+(COUNTIF(C47:U47;6)*1)
If you type
(COUNTIF(range start:range end;)*)+
where range is your range normally C2:U2 (for a 19 race series for the first driver) and then cut it, typing the = first and pasting the above you then type the position after the ; and the points scored after the *, once you have done this, paste again and enter the next position and the points, when finished delete the + sign at the end and press return. You can then copy the formula and paste it for every other drive in the rows above or below.
For seasons where you have drivers driving for different teams then I tend to highlight these drivers in colours and do a calculation in the next column so if scores are in column AA and you have a driver in row 7 and 11 who has scored points for different teams then I make AB blank and in AB11 I enter =AA7+AA11, for drivers that have driven for one team, for example in row 3 then in AB3 you enter =AA3
Team Points
It is possible to use look up but that can be a pain, it is easier to just add the driver points up so if Ferrari are in Rows 2 and 3 and the score is in column AA then you would use
=AA2+AA3
If you have say Lotus with 6 drivers in rows 21, 22, 23, 24, 25 and 26 then you could use
=SUM(AA21:AA26)
Sorting it out.
Highlight and copy the drivers, and goto a seperate sheet, you will see some tabs at the bottom of the screen saying Sheet1, Sheet2, etc so click Sheet2
Type Drivers in the first row of the first column
Paste the drivers in the first column
Got back to sheet 1 and highlight the column (or indeed columns) that you wish to sort, copy this and go to sheet 2
Click the first row of the second column and either press CTRL+SHIFT+V or click Edit and Paster Special.
In the pop up window, make sure only TEXT and NUMBERS are clicked in the selection fields. Then click ok.
This pastes the current numbers across, if you make changes to the first sheet then these will not change but it does make sorting easier.
Highlight the drivers, and numbers you wish to sort.
Click Data and then Sort.
If sort by has a drivers name then click options and unclick Range contains column labels then go back to Sort Criteria
if for example you have points in column b and wins in column c then you would sort by Column B in the first pull down menu then column c in the second, click Descending on both of these.
Click OK and you now have a sorted table.
Once you have this, I tend to copy the sorted columns, go to Notepad (or a basic text editor program) and delete the tabs and replacing them with spaces so they line up. Then use the Code button in the forum editor screen and paste in my results.
Hope this is useful
