|
List of Races 2012 List in Excel
|
| cymarel |
Posted on 30-07-2012 13:31
|
Under 23
Posts: 54
Joined: 18-06-2012
PCM$: 200.00
|
An excel sheet with the most common races in PCM 2012 with its rules and a stage by stage analysis.
This is a document I made to help you plan a season or make your own planning tool. I decided not to use the editor or planning tools around cause my game keep crashing and I was frustrated so I'm working on an excel sheet that helps me plan but doesn't alter my save game. Hope you like it.
NOTES:
**This is just a document with information. It won't extract anything from the game or change anything in the game. You can edited at your will.
If you used to created something or post it somewhere else, please credit.
cymarel attached the following file:
Edited by cymarel on 30-07-2012 13:35
|
| |
|
|
| Chooney |
Posted on 30-07-2012 14:09
|
Junior Rider
Posts: 32
Joined: 14-07-2007
PCM$: 200.00
|
cymarel wrote:
An excel sheet with the most common races in PCM 2012 with its rules and a stage by stage analysis.
This is a document I made to help you plan a season or make your own planning tool. I decided not to use the editor or planning tools around cause my game keep crashing and I was frustrated so I'm working on an excel sheet that helps me plan but doesn't alter my save game. Hope you like it.
NOTES:
**This is just a document with information. It won't extract anything from the game or change anything in the game. You can edited at your will.
If you used to created something or post it somewhere else, please credit.
Nice overview!!
However could you please explain what the different colors and letters mean. From what i see f = flat, mm = hills, AM = mountains. Is this correct? What is P (prologue??), mtt (mountain tt??), cc (cobbles??), hf (hills/flat??)...
And finaly some of the boxes have colors:
Yellow = time trial?
Orange = hills
Blue = ???
Dark red = Cobbles?
White/no filling = flat and/or Mountains?
If we could get a legend (explain the different colors, abbreviations) this tool is VERY useful i guess! |
| |
|
|
| cymarel |
Posted on 30-07-2012 14:24
|
Under 23
Posts: 54
Joined: 18-06-2012
PCM$: 200.00
|
You got almost everything right! (Blue is for TTT Team Time Trial).
I'll make the legend and upload the filed again. Thanks for your input! |
| |
|
|
| Ad Bot |
Posted on 23-11-2024 17:13
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| PCM rulezz |
Posted on 30-07-2012 15:04
|
Protected Rider
Posts: 1467
Joined: 21-05-2011
PCM$: 200.00
|
This is awesome, I will definitely use it. 
But I think one thing is incorrect, the second stage of Qatar is itt in the excel file but I thought it was a ttt.
Winners never quit, quitters never win.
It's difficult not to be happy when you're surrounded by Belgians. - Mark Cavendish
|
| |
|
|
| cymarel |
Posted on 30-07-2012 15:47
|
Under 23
Posts: 54
Joined: 18-06-2012
PCM$: 200.00
|
Your right PCM Rulezz... is an TTT. My bad. Hope is the only mistake made. |
| |
|
|
| cymarel |
Posted on 30-07-2012 16:00
|
Under 23
Posts: 54
Joined: 18-06-2012
PCM$: 200.00
|
I've made the legend and update the file. But I had to send the sheet in a xlms extension. Meaning you have to open it with excel 2010 or higher, because the previous ones don't recognize conditional formatting.
I've included a JPG for those that don't have excel and would like to see it, hens not edit it.
cymarel attached the following file:
|
| |
|
|
| jsh312mufc |
Posted on 30-07-2012 16:04
|
Breakaway Specialist
Posts: 794
Joined: 05-02-2012
PCM$: 300.00
|
really good and useful, thanks  |
| |
|
|
| emre99 |
Posted on 30-07-2012 16:08
|
Classics Specialist
Posts: 3332
Joined: 19-07-2012
PCM$: 200.00
|
very useful , i need a race calender like this too!
Thanks cymarel!
#FREELANDA #FREELIA MISSION ACCOMPLISHED
emre99's stages
Thread of the Week : Tour of California 2014
-Official PCM World Cup 2016, 10th best keirin player in the world 
PCM.daily Awards : 2 Nominee 0 Award 
Daily Song Contest WINNER! With Foals - Mountain at my Gates with Greece!
1 like 1 girlfriend
''I call you the stage god. You are the stage god.'' -baseballover312, 15.07.2016
|
| |
|
|
| Chooney |
Posted on 30-07-2012 16:13
|
Junior Rider
Posts: 32
Joined: 14-07-2007
PCM$: 200.00
|
cymarel wrote:
I've made the legend and update the file. But I had to send the sheet in a xlms extension. Meaning you have to open it with excel 2010 or higher, because the previous ones don't recognize conditional formatting.
I've included a JPG for those that don't have excel and would like to see it, hens not edit it.
Great work Cymarel.
I had something similar but this is way better. I will add my own information regarding type of riders (main attributes) needed to compete for general classification in the big classics and the important stage races. Ex. for tour of denmark a good sprinter is needed for top 5 classification. TdF important stats are tt and mountain and recovery. For paris robaix COB etc...
but some are not that obvious. For example paris-nice. What type of rider is needed for top 5 general classification? Mountain, hills?
would be cool if you add that as you go along. maybe even with percantages. ex. Paris nice: 75% Hill, 15% mountain and 10% TT.
does it makes sence? |
| |
|
|
| cymarel |
Posted on 30-07-2012 16:18
|
Under 23
Posts: 54
Joined: 18-06-2012
PCM$: 200.00
|
Yeah, of couse it makes sense, this sheet is just a part of a bigger workbook I'm making to help me plan the season. I have a sheet with me team riders profiles where you can choose the races they participate and the update automatically in a calendar so that you know wich races the team is racing at a given week. Is like a planner but it it won't alter your save game and it extremely editable. I have to finish it the uploaded.
I'll take your comments into account. |
| |
|
