PCM.daily banner
21-11-2024 19:47
PCM.daily
Users Online
· Guests Online: 97

· Members Online: 1
jph27

· Total Members: 161,772
· Newest Member: KennethSal
View Thread
PCM.daily » Pro Cycling Manager 2006-2020 » Pro Cycling Manager 2011
Page 1 of 2: 12
 Print Thread
I updated NC's in PCM.daily's DB
TankNL
Top  #1 Print Post
Posted on 14-08-2011 20:46
Dear all,

I modified the PCMDaily2011 database. Wanted to share the work, feel free to ask questions. @Crue, if this isn't allowed, please remove the post. And if you want the more info, of course this is available.

* As stated in the topic header this contains all the current NC's (no riders are added, only the riders that are in the PCMDaily DB. and only the races up until now are taken in account. f.e. Devolder is still the NC ITT because this race is still scheduled.

* Also modified; deleted Ricco from the DB (rider and the connection to the rider_id in the palamares-cyclist table) and removed Mosquera from the Vacansoleil team (personal preference).

* Last thing altered is the popularity attribute. I've created a mapping of the riders in the DB and the CQ Ranking site. I've created an weighted average of the last 3 years and deducted a percentage (weighted in correlation to the ending of the last suspension) 1000 points for dopers. Max popularity = 85

new download link; 15-08-2011
https://www.megaupload.com/?d=9BD9HL6F

example;
Spoiler

IDcyclistgene_sz_lastnamegene_sz_firstnamegene_f_popularity
136GilbertPhilippe85
256ContadorAlberto85
218EvansCadel83
1371RodríguezJoaquím82
431NibaliVincenzo82
868SánchezSamuel81
1430CancellaraFabian80
1008CavendishMark79
423FarrarTyler79
1350SchleckFränk78
924ScarponiMichele78
579GreipelAndré78
97HushovdThor77
264Boasson HagenEdvald77
994GesinkRobert77
146SchleckAndy76
1244VoecklerThomas76
64MartinTony76
682CunegoDamiano76
421ViscontiGiovanni75
697RojasJosé Joaquín75
139SánchezLuis León75
1947SaganPeter74
437FreireÓscar74
1039FeilluRomain74
586Van AvermaetGreg74
443BoonenTom73
469PozzatoFilippo73
524LeipheimerLevi73
90MartinDaniel73
376HesjedalRyder73
968BennatiDaniele73
784MarcatoMarco73
339BassoIvan73
289GossMatthew73
685KreuzigerRoman73
530MenchovDenis73
504PetacchiAlessandro73
483ChavanelSylvain72
686BrajkovičJanez72
105BallanAlessandro72
295McEwenRobbie72
631BreschelMatti72
536FuglsangJakob72
804HornerChris72
823Van DijkStefan72
213AntónIgor72
75MoncoutiéDavid72
576PozzovivoDomenico72
356KlödenAndreas72
470DavisAllan72
418LarssonGustav Erik71
1434RogersMichael71
1336RocheNicolas71
1656MillarDavid71
1901VinokourovAlexandre71
87FédrigoPierrick71
176PinottiMarco71
42MonfortMaxime71
1927MachadoTiago71
1000GavazziFrancesco71
795AlbasiniMichael71
741LeukemansBjörn71
871ZubeldiaHaimar71
260SastreCarlos71
69VelitsPeter71
49VentosoFrancisco José71
32WigginsBradley70
711RoelandtsJürgen70
926SerpaJosé70
238GarzelliStefano70
73CoppelJérôme70
382Van HummelKenny70
467PaoliniLuca70
1932PorteRichie70
1320WegmannFabian69
872DumoulinSamuel69
1879Van den BroeckJurgen69
566UránRigoberto68
825HendersonGreg67
121CasarSandy67
892DevolderStijn66
889FlechaJuan Antonio66
1199BoleGrega65
34FernándezKoldo65
304SørensenChris Anker64
14LastrasPablo64
1369ArroyoDavid62
16MollemaBauke62
178TaaramäeRein61
288BoomLars61
410HausslerHeinrich61
1489ElmigerMartin60
695HoogerlandJohnny60
434DuqueLeonardo60
1935Van GarderenTejay60
1861LöfkvistThomas59
116HutarovichYauheni59
1042Le MévelChristophe59

Edited by TankNL on 17-08-2011 18:16
 
TankNL
Top  #2 Print Post
Posted on 14-08-2011 21:22
Also for those who are using full editor v4 and you want to edit the the gene_i_champion_bit column but you're confused by the notation's; here's the guide.

titlepoints
Current World Champion Road Race 128
Current World Champion Individual Time-trail64
Current National Champion Road Race32
Current National Champion Individual Time-trail16
Former World Champion Road Race 8
Former World Champion Idividual Time-trail4
Former National Champion Road Race2
Former National Champion Individual Time-trail1


But you can only enter 1 value, so add the values if a rider has more titles. so Cancellara as of 01.01.2011 had; WC ITT, former WC ITT, former RR and former ITT; 64 + 4 + 2+ 1 = 71

and now has; WC ITT, NC RR, former WC ITT, former RR and former ITT; 64 + 32 + 4 + 2+ 1 = 103

now for the catch (and no I won't explain you the basics in binary calculations), but if the total sum is above 128, then deduct 256 from the total.

So, for Thor Hushovd who is WC RR, NC RR, former RR and former ITT; so the total would 163, but its higher then 128 so it will be 131 - 256 = -93

in my db; WC RR, former RR and former ITT; 131 - 256 = -125

hope it helps.
Edited by TankNL on 14-08-2011 22:32
 
TankNL
Top  #3 Print Post
Posted on 14-08-2011 22:42
Will try to update it when the're more NC races finished.

15/08/2011 NCT1 National Championships Belgium (Tervuren) I.T.T.
1/09/2011 NCT4 National Championships Finland (postponed) I.T.T.
4/09/2011 NCT2 National Championships Great Britain () I.T.T.
6/09/2011 NCT3 National Championships Colombia (Sopo) I.T.T.
7/09/2011 NC3 National Championships Colombia (Cogua) R.R.
11/09/2011 NCT4 National Championships Austria () I.T.T.
 
michichiel
Top  #4 Print Post
Posted on 14-08-2011 22:48
Boonen is more famous Wink
 
TankNL
Top  #5 Print Post
Posted on 14-08-2011 22:54
Well the game uses popularity as in relation to results. So riders popularity goes up in 2012 if he gets good results. And will decrease if the results are lacking.

That's why I used the cqranking points from the last 3 years 2008, 2009, 2010 and results up until now and calculate an weighted average. The results are used to calculate the attribute.
 
Ad Bot
Posted on 21-11-2024 19:47
Bot Agent

Posts: Countless
Joined: 23.11.09
IP: None  
TankNL
Top  #6 Print Post
Posted on 15-08-2011 08:58
I will update the DB (with the NC of the Belgian ITT) and will post the Excel + Access calculations for the attribute that I used. Hoping to get some feedback on it, in order to improve even further.
 
TankNL
Top  #7 Print Post
Posted on 15-08-2011 14:37
Posted the top100 again, only this time with the original DB value with it. There are some big changes, but I don't know how the original value was created. f.e. Boonen had 84. Also the CQ points are shown, showing a big gap between the top and rest of the top. below the 500 CQ points the intervals decrease.

Spoiler
gene_sz_firstnamegene_sz_lastnameCQ pointsoriginalnew
PhilippeGilbert22398585
AlbertoContador22739085
CadelEvans18127683
JoaquímRodríguez17377482
VincenzoNibali17467482
SamuelSánchez15597581
FabianCancellara15198380
TylerFarrar13996879
MarkCavendish13868279
MicheleScarponi13025578
FränkSchleck12897778
AndréGreipel12706478
ThorHushovd11528277
RobertGesink12476577
EdvaldBoasson Hagen12237377
AndySchleck11228076
DamianoCunego10837676
ThomasVoeckler11456676
TonyMartin10837076
José JoaquínRojas9785275
GiovanniVisconti104136.70000076293945375
Luis LeónSánchez10416875
RomainFeillu9223974
PeterSagan8995674
ÓscarFreire8837774
GregVan Avermaet8975274
MarcoMarcato8002473
RomanKreuziger7856373
DanieleBennati7536873
IvanBasso7737773
FilippoPozzato7537973
LeviLeipheimer7737373
DanielMartin7884373
MatthewGoss7864173
DenisMenchov7877273
AlessandroPetacchi7727673
RyderHesjedal8145773
TomBoonen8158473
MattiBreschel7426072
DavidMoncoutié6636172
DomenicoPozzovivo6924172
AlessandroBallan6537072
JakobFuglsang7334272
IgorAntón7057372
ChrisHorner7145072
SylvainChavanel6857172
StefanVan Dijk65332.04999923706054772
RobbieMcEwen6557572
AllanDavis6585472
JanezBrajkovič6506272
AndreasKlöden7457472
CarlosSastre5957871
HaimarZubeldia5556471
Gustav ErikLarsson6144271
TiagoMachado5593171
MichaelAlbasini5694871
MichaelRogers6366571
PeterVelits5835171
AlexandreVinokourov5888171
MaximeMonfort6124971
NicolasRoche5616371
FrancescoGavazzi5673671
DavidMillar5536771
MarcoPinotti5665471
BjörnLeukemans5944571
Francisco JoséVentoso6345071
PierrickFédrigo5516871
KennyVan Hummel52838.04999923706054770
JürgenRoelandts5145070
StefanoGarzelli5325870
LucaPaolini4994170
JoséSerpa5183370
JérômeCoppel5294270
BradleyWiggins5387570
RichiePorte5015070
SamuelDumoulin4915369
FabianWegmann4936069
JurgenVan den Broeck4936969
RigobertoUrán4883868
SandyCasar4825967
GregHenderson4764867
Juan AntonioFlecha4737166
StijnDevolder4686566
GregaBole4633365
KoldoFernández4635265
Chris AnkerSørensen4574464
PabloLastras4544164
DavidArroyo4466062
BaukeMollema4425262
LarsBoom4336661
HeinrichHaussler4336061
ReinTaaramäe4354961
MartinElmiger4294360
LeonardoDuque4294460
TejayVan Garderen4323960
JohnnyHoogerland4314060
ChristopheLe Mével4186059
YauheniHutarovich4195459
ThomasLöfkvist4245659
LinusGerdemann4126558


average CQ = Round(([CQ2011]*3+[CQ2010]*3+[CQ2009]+[CQ2008])/8)
factor = -1000+Round(Now()-[enddate.doping]) if larger than 0 then 0.

The avg CQ + the dopingfactor go into a formula to calculate the popularity;
Code Download source  



Round(IIf( [points]-500>0  

         ; IIf( [points]-500>1500 

              ; 85

              ; (70+([points]-500)/100)

              )

         ; 70*([points]/500)

         )

      ;0)


hoping to get feedback in order to make the calculations better.
Edited by TankNL on 15-08-2011 14:37
 
TankNL
Top  #8 Print Post
Posted on 15-08-2011 16:30
changed the NC ITT of Belgium (Gilbert = new Champion)
 
TankNL
Top  #9 Print Post
Posted on 17-08-2011 13:10
it's downloaded 4 times, so not that many players are interested in the current national champions. guessed other wise, but OK. For those who did downloaded it. What do you think about the new popularity, is it better or worse than the original?
 
CrueTrue
Top  #10 Print Post
Posted on 17-08-2011 16:20
I think it sounds like a great idea (the thing about popularity), and I had to do the 2011 champions myself sooner or later - so for one, I'm happy Smile
 
http://www.pcmdaily.com
TankNL
Top  #11 Print Post
Posted on 17-08-2011 17:05
Thanks! If you want, I can give you my excel and access files... love your work, so everything to make the community even stronger Smile
Edited by TankNL on 17-08-2011 17:05
 
MrDemus
Top  #12 Print Post
Posted on 17-08-2011 17:18
TankNL wrote:
it's downloaded 4 times, so not that many players are interested in the current national champions. guessed other wise, but OK. For those who did downloaded it. What do you think about the new popularity, is it better or worse than the original?


I think it is because most people have started careers already, but it definitely is good work Smile


ROLF ER REN!
 
TankNL
Top  #13 Print Post
Posted on 17-08-2011 18:15
Thanks, you're probably right. I did it for myself and wanted to share the work. So no harm done when only a couple of people have enjoyed it. (That's more then when I would have kept it to myself)
 
CartofCubic
Top  #14 Print Post
Posted on 17-08-2011 19:44
Can someone tell me how can I modify the Time Trial value of a rider with PCM fast editor(TT and MO), because I tried, I modified the values, I saved, but when I entered in the game there was the same values like before editing. Can someone help me?
 
TankNL
Top  #15 Print Post
Posted on 17-08-2011 19:54
Not something for this thread, but ok.

Did you open the savegame while the game was still running?
Normally, you edit the db, save and done. maybe you edited in the wrong folder?
 
JD317
Top  #16 Print Post
Posted on 17-08-2011 21:48
+1 with mcdemus post. i think it is top work but i have restarted my career too many times already to cater for all the awesome work ppl are doing with db's and graphics etc. a few months in and im not sure i have it in me to do the jan races AGAIN Smile
Flying V
i52.tinypic.com/9ztx8m.jpg
 
DaBobScotts
Top  #17 Print Post
Posted on 17-08-2011 22:24
+1 with JD317... DB is great, and the way the popularity works is pretty good!
 
zed73xX
Top  #18 Print Post
Posted on 18-08-2011 11:56
Good Job
 
TankNL
Top  #19 Print Post
Posted on 18-08-2011 18:19
Thanks, I can see that is downloaded more often now. Anyway thanks for the support.
 
zed73xX
Top  #20 Print Post
Posted on 03-09-2011 10:45
news ?
 
Page 1 of 2: 12
Jump to Forum:
Login
Username

Password



Not a member yet?
Click here to register.

Forgotten your password?
Request a new one here.
Latest content
Screenshots
Domination
Domination
PCM09: Funny Screenshots
Fantasy Betting
Current bets:
No bets available.
Best gamblers:
bullet fighti... 18,376 PCM$
bullet df_Trek 17,374 PCM$
bullet Marcovdw 15,345 PCM$
bullet jseadog1 13,552 PCM$
bullet baseba... 10,439 PCM$

bullet Main Fantasy Betting page
bullet Rankings: Top 100
ManGame Betting
Current bets:
No bets available.
Best gamblers:
bullet Ollfardh 21,890 PCM$
bullet df_Trek 15,520 PCM$
bullet Marcovdw 14,800 PCM$
bullet jseadog1 13,500 PCM$
bullet baseball... 7,332 PCM$

bullet Main MG Betting page
bullet Get weekly MG PCM$
bullet Rankings: Top 100
Render time: 0.26 seconds
Copyright © 2006-2023


Powered by PHP-Fusion Copyright © 2024 PHP-Fusion Inc
Released as free software without warranties under GNU Affero GPL v3