|
List of Races 2012 List in Excel
|
| cymarel |
Posted on 30-07-2012 13:31
|
Junior Rider
Posts: 37
Joined: 18.06.12
Location: Dominican Republic
PCM$: 100.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:
racesinpcm2012.zip
Edited by cymarel on 30-07-2012 13:35
got injured playing football, found cycling! |
| |
|
|
| Chooney |
Posted on 30-07-2012 14:09
|
Junior Rider
Posts: 28
Joined: 14.07.07
PCM$: 100.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
|
Junior Rider
Posts: 37
Joined: 18.06.12
Location: Dominican Republic
PCM$: 100.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!
got injured playing football, found cycling! |
| |
|
|
| PCM rulezz |
Posted on 30-07-2012 15:04
|
Protected Rider
Posts: 1247
Joined: 21.05.11
Location: Belgium
PCM$: 60.50
|
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
|
Junior Rider
Posts: 37
Joined: 18.06.12
Location: Dominican Republic
PCM$: 100.00
|
Your right PCM Rulezz... is an TTT. My bad. Hope is the only mistake made.
got injured playing football, found cycling! |
| |
|
|
| cymarel |
Posted on 30-07-2012 16:00
|
Junior Rider
Posts: 37
Joined: 18.06.12
Location: Dominican Republic
PCM$: 100.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:
racechart2012.zip
got injured playing football, found cycling! |
| |
|
|
| jsh312mufc |
Posted on 30-07-2012 16:04
|
Domestique
Posts: 443
Joined: 05.02.12
Location: The Woods
PCM$: 34.05
|
really good and useful, thanks 
There's a difference between an all-rounder and someone who is just equally bad at everything
RIGOBERTO URAN OLYMPIC CHAMPION |
| |
|
|
| emre99 |
Posted on 30-07-2012 16:08
|
Domestique
Posts: 418
Joined: 19.07.12
Location: Liberty Stadium
PCM$: 207.05
|
very useful , i need a race calender like this too!
Thanks cymarel!
SWANS IN ALL THE SEAS!
PCMDAILYS FAVORITE (POLL)
http://pcmdaily.c...d_id=28886 |
| |
|
|
| Chooney |
Posted on 30-07-2012 16:13
|
Junior Rider
Posts: 28
Joined: 14.07.07
PCM$: 100.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
|
Junior Rider
Posts: 37
Joined: 18.06.12
Location: Dominican Republic
PCM$: 100.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.
got injured playing football, found cycling! |
| |
|
