Nothing I try gets the result I'm looking for. Tried typing it, and the forum just ignores extra spaces, so you end up with lines looking like this:
1 Jenson Button 34:15.8 90 Jenson Button 90 Jenson Button 10
2 Rubens Barrichello +0.8 secs 80 Rubens Barrichello 80 Rubens Barrichello 8
3 Jarno Trulli +1.6 secs 70 Jarno Trulli 70 Jarno Trulli 6
4 Timo Glock +4.4 secs 36 Timo Glock 36 Timo Glock 5
5 Fernando Alonso +4.8 secs 31 Fernando Alonso 31 Fernando Alonso 4
6 Nico Rosberg +5.7 secs 20 Nico Rosberg 20 Nico Rosberg 3
7 Sebastien Buemi +6.0 secs 16 Sebastien Buemi 16 Sebastien Buemi 2
8 Sebastien Bourdais +6.2 secs 14 Sebastien Bourdais 14 Sebastien Bourdais 1
9 Adrian Sutil +6.3 secs 12 Adrian Sutil 12 Adrian Sutil 0
10 Nick Heidfeld +7.0 secs 4 Nick Heidfeld 4 Nick Heidfeld 0
11 Giancarlo Fisichella +7.3 secs 0 Giancarlo Fisichella 0 Giancarlo Fisichella 0
12 Mark Webber +1 Lap 0 Mark Webber 0 Mark Webber 0
13 Sebastian Vettel Accident 0 Sebastian Vettel 0 Sebastian Vettel 0
14 Robert Kubica Accident 0 Robert Kubica 0 Robert Kubica 0
15 Kimi Räikkönen Differential 0 Kimi Räikkönen 0 Kimi Räikkönen 0
Ret Felipe Massa Suspension 0 Felipe Massa 0 Felipe Massa 0
Ret Nelsinho Piquet Spin 0 Nelsinho Piquet 0 Nelsinho Piquet 0
Ret Kazuki Nakajima Accident 0 Kazuki Nakajima 0 Kazuki Nakajima 0
Ret Heikki Kovalainen Accident damage 0 Heikki Kovalainen 0 Heikki Kovalainen 0
DSQ Lewis Hamilton +2.9 secs 0 Lewis Hamilton 0 Lewis Hamilton 0
In Excel, this is 3 columns. Putting spaces inbetween the columns still ends up with this result
Make it 1 Excel column.
Driver, Race Time
then Driver, Decaothlon Points
then Driver, Original Points
like this:
1 Jenson Button 34:15.8 90
(...)
DSQ Lewis Hamilton +2.9 secs 0
Jenson Button 90
(...)
Lewis Hamilton 0
Jenson Button 10
(...)
Lewis Hamilton 0
not the best to compare results, but it's the easiest solution
