Jump to content
DIRT 5 - Chat about the game and get support here. Read more... ×

Archived

This topic is now archived and is closed to further replies.

Dirt Rally 2.0 Timetable spreadsheet (no rallycross)

Recommended Posts

Hey Guys!

I've spent a lot of time creating this worksheet.
If you like it or you spice it up, please let me know.
I hope you like it and thanks for using it.


Choose your class (click on the thumb) (picture 1)

Choose your car with dropdown menu (picture 2)

Then enter the time (picture 3)

 

Download with macro:
http://perci.net/timetable/Dirt_Rally_2.0-Timetable.xlsm

Download without macro:
http://perci.net/timetable/Dirt_Rally_2.0-Timetable.xlsx

Have fun.

Perci

timetable-forum-1.jpg

timetable-forum-2a.jpg

timetable-forum-3.jpg

Share this post


Link to post
Share on other sites

That's super cool @Percilator, thank you for making cool community thing like this! I'm sure many people will find this helpful.

Share this post


Link to post
Share on other sites

Ooh neat.

So if I'm understanding this correctly, it's a spreadsheet that allows you to track your best Stage times?

Share this post


Link to post
Share on other sites

Nice spreadsheet, that’s a lot of time and effort gone into that.

But an easy access, full leaderboard list, with drop down to select class/stage/dry or wet, should really be available in game anyway.

Share this post


Link to post
Share on other sites

Thanks a lot @Percilator for this neat and good looking time sheet!

Something that would be useful to add: the possibility to keep track of times per car/stage/condition. You could do this by creating two other tables (one per track condition) with a Car / Track matrix. When you select a car via the dropdown on the specific stage / condition, it fetches the time in the car / track matrix. Same thing when you update a time per car and stage/condition, but it updates the value in the matrix instead.

Good job!

Share this post


Link to post
Share on other sites

Hello and thanks for the positive feedback.

Since my English is very bad I use the Google translator, so please excuse strange phrases.

The question of what this table has in mind is not so easy to answer.

In the beginning I wanted to do an overview of all stages and vehicles because I have nowhere found anything on the Internet. Something has usually been missing, for example, which stage is the long version and how is the exact subdivision.

Gradually, I redesigned the table and added new possibilities. Of course, the game offers insight into its best times when you drive them over the appropriate mode. But not in other modes. In addition, I lacked an overview, which I have everywhere at hand.

I also wanted to create a way to compare my times with my friends. Unfortunately, Crossplay does not function adequately in this regard. I drive on the PS4 Pro, my friends on the PC.

The attempt to make a table which still times other drivers allowed blew up the frame at work and it would not have been clear.

So yes, the table is basically very special and thanks to my inferior skills with Excel certainly well below their potential. However, since I had already invested so many dozens of hours, I wanted to offer them to other people.
If only one of them is involved, I could have enjoyed sharing them on the internet.

Feel free to reshape the table according to your wishes.

Perci

Share this post


Link to post
Share on other sites
On 11/6/2019 at 2:31 PM, Beefcote852 said:

Nice spreadsheet, that’s a lot of time and effort gone into that.

But an easy access, full leaderboard list, with drop down to select class/stage/dry or wet, should really be available in game anyway.

With a nod to this thread, and the fact that this should be available in game. I have raised a suggestion on the suggestions board, including a made up screenshot of how I'd envisage the Leaderboards to look, and to be available from the Main Menu.

 

Share this post


Link to post
Share on other sites

Hi,

I had an error in the macro. In the "2000s" class wrong vehicles were displayed. I just changed it. Sorry.
The files have just been exchanged on the server.

Share this post


Link to post
Share on other sites

×