Rally History (part III)

Yes, it was. If had knew how much time it will take I probably wouldn’t have begun doing it. Only to get cars & drivers in some sort of order I had to make 2*39*3 = 234 sorting (Excel can sort only 3 columns at time) + to get the cars and drivers combined whit each other in the cars and drivers spreadsheets. Begun whit Access but then I remembered that Excel has Pivot tables and it was more easy to do it with the Pivot tables.

But I think I will update the files with the 2011 & 2012 seasons at the end of the year or beginning of next year.

Quote:

---

Originally Posted by OldF

Yes, it was. If had knew how much time it will take I probably wouldn’t have begun doing it. Only to get cars & drivers in some sort of order I had to make 2*39*3 = 234 sorting (Excel can sort only 3 columns at time) + to get the cars and drivers combined whit each other in the cars and drivers spreadsheets. Begun whit Access but then I remembered that Excel has Pivot tables and it was more easy to do it with the Pivot tables.

But I think I will update the files with the 2011 & 2012 seasons at the end of the year or beginning of next year.

---

Great stuff! Does it work fully with Openoffice's Calc?

I have moved these posts into this thread because the regular contributors said they only want to have one Rally History thread.

Duncan (Moderator of the History forum)

Quote:

---

Originally Posted by D-Type

I have moved these posts into this thread because the regular contributors said they only want to have one Rally History thread.

Duncan (Moderator of the History forum)

---

Thanks for the info. Could you please notify a moderator of the WRC sub-forum to either delete the threads “WRC results 1973 – 2010” or change the link to “Rally History (part III) for the first thread and delete the second one. I don’t know how I managed to make a double post of that thread.

Quote:

---

Originally Posted by jrally

Thank You, Janusz and Shacki !

I forgot to mention that was from year 1990 that I was looking for ! Sorry !

Best regards
Jorge

---

I can get you the top 10 of Hellendoorn.

Quote:

---

Originally Posted by stefanvv

Great stuff! Does it work fully with Openoffice's Calc?

---

No. Everything else seems to be working except the buttons choosing the year. Only way I’ve got them working was to go to Tools – Macros – Run a Macro and [+] for WRC drivers 1973 – 2010 or [+] for WRC cars 1973 – 2010 and then [+] for Standard and click on Taul1 (cars) or Taul2 (drivers) and choose a macro to run (CommandButton1_Click = year 1973, CommandButton2_Click = year 1974).

Not the easiest way to choose the year. Maybe faster to go to the spreadsheet and search the year to be browsed. And don’t anything about Open Office and haven’t use it much, but maybe here’s some member that knows more about how to convert Microsoft Visual Basic to the corresponding Open Office “Visual Basic” if it’s even possible.

Thank You, EightGear !
I have the top 10 of each of those rounds but thank You anyway

Best regards
Jorge

I noticed that the command (year) buttons doesn’t work in Excel Viewer either.

The only solution for those who don’t have Excel is to download Open Office from:
Apache OpenOffice Downloads

I found the tools to “reconnect” the buttons to the macros.

The Open Office files can be downloaded from:

WRC drivers 1973-2010.ods download - 2shared

WRC cars 1973-2010.ods download - 2shared

At least the buttons works with my 3.2.1 version of Open Office

Have fun. ;)

Quote:

---

Originally Posted by jrally

Good evening !

Does someone has the complete results of ERC rounds that Could share ?

Arctic, Catalunya-Costa Brava, Boucles de SPA, Sachs Winter, Hellendoorn, Saturnus, Barum, Gunayidin, Hunsruck, Asturias, Cyprus, Semperit and Valeo

Thank You in advance
Best regards
Jorge

---

Results for Rally of Turkey from 1996 to 2000 are available here:
25th International Rally of Turkey
26th Rally of Turkey 1997
Rally of Turkey 1998
28th Rally of Turkey
29th Rally of Turkey

Thank You, Steve Boyd !
But the results I'm looking for are those from 1990

Best regards
Jorge