|
PCM Fitness Planner: 2011 Edition
|
| titleist82 |
Posted on 26-06-2011 21:54
|
Domestique
Posts: 451
Joined: 03.04.07
PCM$: 600.50
|
With courtesy of Eyolfur from the Cyanide Forum, who is the original author of the file, I've updated his useful excel spreadsheet to the 2011 version of PCM and its calendar.
I've added a few more graphs that show the predicted form for classics and grant tours.
For those who aren't familiar with the tool, this excel file is able to read and save fitness .xml files from PCM, allowing to make an accurate planning of the season for each rider.
DOWNLOAD LINK:
http://www.multiu...5589X471Z9 |
| |
|
|
| lluuiiggii |
Posted on 26-06-2011 22:07
|
Team Leader
Posts: 7101
Joined: 30.07.10
Location: Brazil
PCM$: 441.00
|
Nice, but I keep getting the same error I got with the other version: when I click the buttons (evaluate, save and load) I get the following error:
"Compile error in hidden module: Feuil1"
One day I did a lot of research trying to fix it, but without success. It worked fine before my computer was 'formatted' (not sure if this is the word). Once I've even created a thread about it here, but no solution.
|
| |
|
|
| titleist82 |
Posted on 26-06-2011 23:39
|
Domestique
Posts: 451
Joined: 03.04.07
PCM$: 600.50
|
very strange, it works for me on several computers.
you need to enable macros in excel btw (under Tools -> Macro -> Protection select medium or high, then re-open the file and upon request turn macros on) |
| |
|
|
| lluuiiggii |
Posted on 26-06-2011 23:53
|
Team Leader
Posts: 7101
Joined: 30.07.10
Location: Brazil
PCM$: 441.00
|
Yeah, macros are enabled. I once though it could be the fact that it was Excel 2007 (when it worked I had Excel 03), but I've tried it in a computer with Excel 03 without success.
|
| |
|
|
| Diezen |
Posted on 27-06-2011 00:52
|
Amateur
Posts: 19
Joined: 04.06.08
Location: Norway
PCM$: 100.00
|
Same problem here |
| |
|
|
| titleist82 |
Posted on 27-06-2011 10:03
|
Domestique
Posts: 451
Joined: 03.04.07
PCM$: 600.50
|
so strange...
try to rename the "FatigueForme" sheet to "Feuil1" and let me know if that works |
| |
|
|
| lluuiiggii |
Posted on 27-06-2011 17:00
|
Team Leader
Posts: 7101
Joined: 30.07.10
Location: Brazil
PCM$: 441.00
|
No..
If I'm not mistaken, what I got while searching over the internet was that this error happened because the author of the file put some kind of 'code' to protect the content, or something like that.
Now, seeing the file again, if you (or at least I) right-click the "FatigueForme" sheet there will be an option "unprotect sheet" (or something like that, I've translated from Portuguese so might not be exactly that), but if you click the other sheets the option will be "protect sheet". If I click "unprotect sheet" it will ask a password, which is not Feuil1 but I'm quite sure it has something to do with the error.
Probably the best person to answer about this is Eyolfur himself (they also told me this when I created the thread about this problem).
|
| |
|
|
| Lachi |
Posted on 27-06-2011 19:43
|
Grand Tour Specialist
Posts: 5174
Joined: 29.06.07
PCM$: 110.00
|
It is a problem with the latest versions of Excel as far as I know. Excel 2007 and Excel 2010 cannot run the code.
Download Editor for PCM2012 here / Download Season planner here |
| |
|
|
| purepasd |
Posted on 27-06-2011 20:12
|
Stagiare
Posts: 230
Joined: 23.01.10
Location: Denmark
PCM$: 110.00
|
Lachi wrote:
It is a problem with the latest versions of Excel as far as I know. Excel 2007 and Excel 2010 cannot run the code.
Are you gonna make your Season Planner for the 2011 version? I think it's way better 
Ben Swift!! |
| |
|
|
| lluuiiggii |
Posted on 27-06-2011 20:24
|
Team Leader
Posts: 7101
Joined: 30.07.10
Location: Brazil
PCM$: 441.00
|
Lachi wrote:
It is a problem with the latest versions of Excel as far as I know. Excel 2007 and Excel 2010 cannot run the code.
Initially I also thought that. But one day I tested in a computer that had Excel 03 and did not work.
I've just tested it again but again, no success. Although the computer has Excel 2003, its Windows Vista (same as mine, which has Excel 07 - the one it worked was XP with Excel 03). So maybe it also has to do with the fact that it is Windows Vista?
|
| |
|
|
| bugus |
Posted on 16-08-2011 20:04
|
Amateur
Posts: 11
Joined: 18.07.10
PCM$: 110.00
|
I managed to unprotect the sheet and seems to work ok in Excel 2007. At least for me..
Here is the link below.
http://www.multiu...4BPW9UJ3XY
PS: To admin: If I should not post this, please let me now so I remove it... |
| |
|
|
| Ad Bot |
Posted on 26-05-2013 03:55
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| Lachi |
Posted on 16-08-2011 20:14
|
Grand Tour Specialist
Posts: 5174
Joined: 29.06.07
PCM$: 110.00
|
I would not care about that, the tool has no copyright as far as I know.
Download Editor for PCM2012 here / Download Season planner here |
| |
|
|
| cymarel |
Posted on 23-08-2012 15:01
|
Junior Rider
Posts: 37
Joined: 18.06.12
Location: Dominican Republic
PCM$: 100.00
|
The link doesn't work anymore.
got injured playing football, found cycling! |
| |
|
