PCM.daily banner
10-04-2021 13:17
PCM.daily
Users Online
· Guests Online: 22

· Members Online: 0

· Total Members: 146,477
· Newest Member: wexeleg
Donate
View Thread
PCM.daily » Pro Cycling Manager 2006-2012 » Pro Cycling Manager 2006
 Print Thread
PCM Stat
CrueTrue
Decided to stop for a moment on this and release it to see how it holds up, simply can't see any code anymore and losing my motivation on this so best is to stop on it for a moment and see if users can work with it. I'm not 100% sure if all new/fired riders gets flushed/added at the end of a year, so that's something to keep in mind. Will update that and other little things in time. But probably won't work on this much more since i've heard the new PCM will probably use a different DB. I must stress out that it's not supereasy to use, it needs some familiarization.

What it does:
- Track info/stats on cyclists like moral, form, rankings, stats etc.
- Track team info and finances like, race bonusses, rankings, nationalities etc.
- Calendar where you have a monthly calendar of races and where you can 'match' cyclists to races he's likely to obtain a good result
- Organize your screenshots (cropping can be done too) and exported results of your career.
- Report function wich is able to pull info/screenshots and fill and word template with that info (stage screenshots, results etc.)
- etc. etc. etc.


Some examples/info can be found here: https://www.ppdb.n...php?t=4367
Screenshots of the tool itself: https://www.vennik...creens.gif


Before you start you need to:
- Extract the RAR file and put it in C:\ so it will look like "C:\PCMSTAT_TEMP\" (the actual Excel (.XLS) file you can put anywhere on your HD though, if desirable)
-- Jpgs folder holds all the GUI graphics (flags, minishirts, riderpics and some other files used for the excel userfors(so don't empty this directory, just add you GUI DDS(converted to jpgs) if necessary). In the sub-folders (general graphics in general, charts and date related in a sub-folder for each year you play) you'll find your graphics as created/referenced by the PCMSTAT tool.
-- Templates folder holds all the templates used to push data from PCMstat to Word, if you want to add custom templates, create a .DOT word template, copy it to the templates folder, and create a jpg thumbnail with the same name for each template(necessary else they wont show up, just create a screenshot of the template or sh).
-- Backups folder holds all the backups made of your PCM savegame and the Excel PCMstat file(.XLS), there's a button on the settings/update page to create an backup of either your savegame or excel file automatically.(I recommend doing this at least 3/4 times a year)
-- Programmes folder holds all the contains the software you need to install in next step, the DDS converter for batch converting DDS->JPG and a couple of Word->JPG converters to quickly take a hi-res screenshot of your document to post on the web.(All legal/freeware programs)
-- Reports folder i solely use to store my (end) graphics and stuff, so not important.

- Install Imagemagick and tick the "Install ImagemagickOLE object control for VB, VBSCRIPT....." option (used for handling graphics trough Excel VBA)

- Use the DDS converter to convert all rider pics, team minishirts and country flags to jpgs and put them in the jpgs\ folder (altough most files are already in, if you want the same graphics as your DB do it anyway, also new/custom DB can have teams/riders in them that are currently not in jpgs folder since i used a 'standard' 50 teams DB. )

- In Excel goto -> Tools -> Options then navigate to the "Security" Tab and click "Macro Security", set your "Macro Securty" to "Medium" or lower and on the "Trusted Publishers" tab tick the "Trust access to Visual Basic project" option. (Set this back if necesarry, cause your vulnerability for virus/malware is much bigger when working with 'untrusted' macros/files !)


Now start the PCMstat Excel file
- First click the top most gray button in the upper right corner of the "General" worksheet, fill in your name and select your PCM savegame.

- Now click the gray button under that one and select the team you play with. All necesarry info is now loaded in the excel file, altough you first need an update to let the riders pages be populate with info/stats. After the first time you done it there is no need to touch/click or alter anything else on any sheet (except for "TempG" sheet though if you want to alter the appearance/settings of the charts) everything is done trough the userform/menu.

- Click the "Main Menu" button and go to the settings tab and click "Update" to update the excel file with the most recent data of you PCM savegame. That's it, everything else is done automatically. So all you have to do is click the "Update" button once in a while(Minimum interval is 7 days if it's lower it won't update to limit the ammount of data, so i recommend updating once every 7 days or something)

Some remarks
- If you get some messages like "You need to build an exception rule for Race xxxx" that means that there are some races that did not get there 'properties' like type of race an the weight of the character. To avoid errors if you want to use the "Calendar" page, wich gives you an monthly calendar of the races and can match a cyclist to certain races wich suits his abbilities, goto the "TempR" worksheet. In Column "F" check if all races have a category assigned and NOT a number, if it's a number, change it to a category and check the columns "Q" to "Z" and fill in a weigh for each character if necessary. Altough all of this can also be done on the "Settings" page of the main menu, at the first start/update of a new game i'd prefer to do it this way.

- Some tools are either not fully developed or simply diasbled, f.ex. palmares reader is disabled, some calendar functions are limited, too name a couple. Also the Calendar function can only hold a certain amount of races (4 simultaneous races per day), wich means that DBs with much new added races, where there are more then 4 races for a given day, can't be accessed to lookup the stage details(since the 5th and up race will be combined in the 4th column). Still everything else should work fine.

- The report function is simply a word template in wich keywords are searched, in the main PCMstat folder there is an word doc(bookmarksreference.doc) where all keywords you can use are listed. The bookmarks should contain text, wich means when you create a bookmark, select the text first, then goto add->bookmark. Beceause you can also create a bookmark without selecting text, wich you should NOT do in this case.

-= Download from PCM.daily =-


if you have MS office 2003 you probably have it, but if not and you get an missing DLL error, you need MS common controls DLL, download it here;

https://support.mi.../kb/297381

Probably much more info to add, but either it's too late or i can't come up with it, will add it later if necesary.
 
http://www.pcmdaily.com
Shipley
how do you install imagemagick???


i couldnt work it out, and i havent got an answer
 
gazza
hey...

I had some problems using the PCM Stat program.

when I typed in my name, and found the location of my saved game, this message came.

"Please extract PCMSTATFILES.rar in the following directory:

C:\PCMSTAT_TEMP\

I've downloaded the patch, but it does not work! any ideas??

Thanks!
 
Gaym
Yep, same here... ;(
 
CrueTrue
Well, did you do as the error message told you to do?
 
http://www.pcmdaily.com
fenian_1234
Yep, make sure you've installed PCM stat to C:\PCMSTAT_TEMP\
 
AaB-ern
I get this error when i click the load button for my database Sad


img186.imageshack.us/img186/1431/errorpcmstatcopyof5.jpg
Edited by AaB-ern on 18-02-2007 23:31
pcmdaily.com/images/awards/2014/Admin.png
 
Gaym
CrueTrue wrote:
Well, did you do as the error message told you to do?


Yes I did. BEFORE I got that message... See for yourself... What am I missing here?
Gaym attached the following image:
pcmstat.jpg

Edited by Gaym on 19-02-2007 08:31
 
CrueTrue
Honestly, I haven't tried the program myself, but you could try to post your problem here instead: https://www.cyanid...6&start=15
 
http://www.pcmdaily.com
Ad Bot
Posted on 10-04-2021 13:17
Bot Agent

Posts: Countless
Joined: 23.11.09

IP: None  
fenian_1234
Actually, have you guys with the probs just tried clicking OK?

Gazza and Gaym, thinking about it, if I remember correctly "Please extract PCMSTATFILES in the following directory: C:\PCMSTAT_TEMP\ " might just be a warning message and not an error.

Apologies though if my memory is playing tricks on me.

AaB-ern, are you sure you have the right file. Take a look at the first page here - I had the same prob myself originally.

https://www.cyanid...16&start=0
 
AaB-ern
shimouma wrote:
Actually, have you guys with the probs just tried clicking OK?

Gazza and Gaym, thinking about it, if I remember correctly "Please extract PCMSTATFILES in the following directory: C:\PCMSTAT_TEMP\ " might just be a warning message and not an error.

Apologies though if my memory is playing tricks on me.

AaB-ern, are you sure you have the right file. Take a look at the first page here - I had the same prob myself originally.

https://www.cyanid...16&start=0


Well, i have tried it. But, hmm, maybe you cold give a link from where you downloaded your. Smile
pcmdaily.com/images/awards/2014/Admin.png
 
CrueTrue
As far as I can see you have only downloaded the package - not the fix.

You can download the fix here: https://www.pcmdai...load_id=87

Place it in PCMSTAT_TEMP so it overwrites the original file.
 
http://www.pcmdaily.com
gazza
I get another error message later on: When I select my team (T-Mobile) from the menu, this appears: "Run time error '1004': Can't get the average-abilities to the WorksheetFunction-class.

In norwegian: "Kan ikke hente Average-egenskapen til WorksheetFunction-klassen"
 
CrueTrue
Did you remember to set the macro security? When pressing the button, it will run a macro. Usually, marcos are by default turned off due to security reasons.
 
http://www.pcmdaily.com
gazza
I've set the macro security to low just to see, and the same error message appears...
 
AaB-ern
CrueTrue wrote:
As far as I can see you have only downloaded the package - not the fix.

You can download the fix here: https://www.pcmdai...load_id=87

Place it in PCMSTAT_TEMP so it overwrites the original file.


I still get the error
pcmdaily.com/images/awards/2014/Admin.png
 
gazza
Help, anyone???

I'd like to use the program, but the same message appears every time!!
 
CrueTrue
CrueTrue wrote:
Honestly, I haven't tried the program myself, but you could try to post your problem here instead: https://www.cyanid...6&start=15


I can only refer to the topic above. The guy who made the program created the topic above, and he might be able to help you if you post your problem there.
 
http://www.pcmdaily.com
gazza
they never replies at the cynanide forum, this forum is much better...

With that beeing said, can anyone help me whith the problem written right above this topic. Problem whan using PCM_Stat...
 
fenian_1234
AaB-ern wrote:
Well, i have tried it. But, hmm, maybe you cold give a link from where you downloaded your. Smile


Sorry, I downloaded it from the links Jape posted in the Cyanide thread.

For what's it's worth, I think Jape got bored with the prog and released it before he had finished it. I used it for a while, mainly to help me plan seasons, but after that a couple of very convenient save game editors came out (one by Jape) and I've been using those since.
 
Jump to Forum:
Similar Threads
Thread Forum Replies Last Post
PCM.daily Stat Discussion PCM 20: PCM.daily Projects 507 07-04-2021 21:02
[2020] Stat Gains, XP, Team Info, Wildcards [Man-Game] The Rules and Announcements 21 15-10-2020 00:54
PCM.daily Stat Discussion PCM 19: PCM.daily Projects 57 08-07-2020 19:37
PCM.daily Stat Discussion PCM 18: PCM.daily Projects 610 15-01-2020 01:05
[2019] Stat Gains, XP, Team Info, Wildcards [Man-Game] The Rules and Announcements 49 16-10-2019 14:16
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Di Luca winning
Di Luca winning
PCM06: General PCM-screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet roturn 1,701 PCM$
bullet fintas 1,520 PCM$
bullet df_Trek 1,499 PCM$
bullet Abhish... 1,325 PCM$
bullet jseadog1 1,300 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet df_Trek 1,100 PCM$
bullet valverde321 1,100 PCM$
bullet AbhishekLFC 1,100 PCM$
bullet jseadog1 1,100 PCM$
bullet roturn 1,000 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.20 seconds