|
Random cyclist generator
|
| haasje33 |
Posted on 10-03-2013 11:48
|
Sprinter
Posts: 1679
Joined: 08-08-2009
PCM$: 200.00
|
While creating my fantasy database for PCM2012, I developed an Excel-worksheet that generates 200 random riders that can be pasted directly into the DYN_cyclist-table of a PCM2012-database.
Thanks to the formula "RANDBETWEEN" I used, everytime you change the values on the first sheet, the generator will generate 200 new riders, while the possibility that a rider will come in twice is nearly 0.
I made the stats as realistic as possible. For example:
- a rider with 75+ climbing won't be able to get 75+ for cobbles or sprint and the other way around.
- riders with 75+ sprint will be able to get 75+ for cobbles and the other way around.
- the values SPR and ACC won't have more than 5 points difference, as well as TT and PRL.
I'd like to share this tool with this community to make it easier for you guys to create fantasy databases or add more riders to an existing database.
If you will create a new database and use my tool to generate riders, then publish it to any community, I'd appreciate it if you'd mention me and my tool in the credits.
Download it here
Edited by haasje33 on 26-03-2013 20:46
Inactive due to personal reasons.
|
| |
|
|
| TTspecialist |
Posted on 10-03-2013 12:30
|
Breakaway Specialist
Posts: 796
Joined: 17-02-2013
PCM$: 200.00
|
Can i edit columns with max and min attributes? And about years? Its awesome , but it would be nice feature if we can edit it  |
| |
|
|
| haasje33 |
Posted on 10-03-2013 15:56
|
Sprinter
Posts: 1679
Joined: 08-08-2009
PCM$: 200.00
|
TTspecialist wrote:
Can i edit columns with max and min attributes? And about years? Its awesome , but it would be nice feature if we can edit it
You are able to give your own max. and min. attributes and the birth year of the youngest and oldest generated players.
Maybe in a next version I'll add the possibility to fill in the max. and min. attributes per skill.
Inactive due to personal reasons.
|
| |
|
|
| Ad Bot |
Posted on 24-11-2024 04:56
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| fickman |
Posted on 10-03-2013 16:28
|
Sprinter
Posts: 1627
Joined: 25-07-2011
PCM$: 200.00
|
Great Job. Its a very susefull Tool. |
| |
|
|
| Elch |
Posted on 12-03-2013 20:52
|
Junior Rider
Posts: 46
Joined: 03-07-2010
PCM$: 200.00
|
Very nice tool!
Just some little feedback after my first experiments.
Created 3x 200 riders between 55 and 82:
- no rider had worse recuperation than 66
- no rider had worse resistance than 68
- no rider had worse endurance than 72
- the hill stats droped down to 46
- sprinters > 75 had hill-stats < 60
- cobbles > 75 equals hill-stat < 60
- loads of climbers > 77 had cobble stats > 70
- loads of climbers > 77 had sprint stats > 70, some even up to 79 in sprints and 78 mountains
but appart from these kind of "weired" stats a great tool for fantasy DBs!
|
| |
|
|
| NTTHRASH |
Posted on 12-03-2013 21:23
|
Classics Specialist
Posts: 3192
Joined: 09-09-2012
PCM$: 3540.00
|
How do I put these in my editor? The values jumble themselves.
"America. Show a nipple on television and the whole country goes ape-shit." -DubbelDekker
|
| |
|
|
| NTTHRASH |
Posted on 12-03-2013 21:25
|
Classics Specialist
Posts: 3192
Joined: 09-09-2012
PCM$: 3540.00
|
It's asking for an "unprotect sheets" passkey. What is that key?
"America. Show a nipple on television and the whole country goes ape-shit." -DubbelDekker
|
| |
|
|
| TTspecialist |
Posted on 12-03-2013 21:33
|
Breakaway Specialist
Posts: 796
Joined: 17-02-2013
PCM$: 200.00
|
I can't edit columns but i can generate o.O |
| |
|
|
| haasje33 |
Posted on 12-03-2013 21:44
|
Sprinter
Posts: 1679
Joined: 08-08-2009
PCM$: 200.00
|
Elch wrote:
Very nice tool!
Just some little feedback after my first experiments.
Created 3x 200 riders between 55 and 82:
- no rider had worse recuperation than 66
- no rider had worse resistance than 68
- no rider had worse endurance than 72
- the hill stats droped down to 46
- sprinters > 75 had hill-stats < 60
- cobbles > 75 equals hill-stat < 60
- loads of climbers > 77 had cobble stats > 70
- loads of climbers > 77 had sprint stats > 70, some even up to 79 in sprints and 78 mountains
but appart from these kind of "weired" stats a great tool for fantasy DBs!
I'm working on this, but at the moment I'm quite busy with my fantasy database. Probably I'll find some time to work on the tool this weekend.
@NTTRASH and TTspecialist: That's what it's for: creating a lot of riders in little time.
You can't edit the columns, because they are generated using formulas. When I allow you to edit them, they won't be generated the next time you use the tool. If you copy and paste the columns into your DB using Excel Editor, you can edit the columns there if you like.
Edited by haasje33 on 12-03-2013 21:45
Inactive due to personal reasons.
|
| |
|
|
| NTTHRASH |
Posted on 12-03-2013 21:47
|
Classics Specialist
Posts: 3192
Joined: 09-09-2012
PCM$: 3540.00
|
haasje33 wrote:
Elch wrote:
Very nice tool!
Just some little feedback after my first experiments.
Created 3x 200 riders between 55 and 82:
- no rider had worse recuperation than 66
- no rider had worse resistance than 68
- no rider had worse endurance than 72
- the hill stats droped down to 46
- sprinters > 75 had hill-stats < 60
- cobbles > 75 equals hill-stat < 60
- loads of climbers > 77 had cobble stats > 70
- loads of climbers > 77 had sprint stats > 70, some even up to 79 in sprints and 78 mountains
but appart from these kind of "weired" stats a great tool for fantasy DBs!
I'm working on this, but at the moment I'm quite busy with my fantasy database. Probably I'll find some time to work on the tool this weekend.
@NTTRASH and TTspecialist: That's what it's for: creating a lot of riders in little time.
You can't edit the columns, because they are generated using formulas. When I allow you to edit them, they won't be generated the next time you use the tool. If you copy and paste the columns into your DB using Excel Editor, you can edit the columns there if you like.
You can't copy/paste...
"America. Show a nipple on television and the whole country goes ape-shit." -DubbelDekker
|
| |
|
|
| NTTHRASH |
Posted on 12-03-2013 22:00
|
Classics Specialist
Posts: 3192
Joined: 09-09-2012
PCM$: 3540.00
|
How to unprotect the file?
"America. Show a nipple on television and the whole country goes ape-shit." -DubbelDekker
|
| |
|
|
| TTspecialist |
Posted on 12-03-2013 22:23
|
Breakaway Specialist
Posts: 796
Joined: 17-02-2013
PCM$: 200.00
|
I opened it,made min years 1997,max 1980,max stats 83 ,min 55 but now i can't press Generate.What to do? |
| |
|
|
| haasje33 |
Posted on 12-03-2013 22:23
|
Sprinter
Posts: 1679
Joined: 08-08-2009
PCM$: 200.00
|
NTTHRASH wrote:
How to unprotect the file?
I won't give you the password, but I'll try to solve it asap.
Inactive due to personal reasons.
|
| |
|
|
| haasje33 |
Posted on 12-03-2013 22:26
|
Sprinter
Posts: 1679
Joined: 08-08-2009
PCM$: 200.00
|
TTspecialist wrote:
I opened it,made min years 1997,max 1980,max stats 83 ,min 55 but now i can't press Generate.What to do?
Make sure you activate activex (in Excel 2010 a line is shown above the workmap).
Inactive due to personal reasons.
|
| |
|
|
| TTspecialist |
Posted on 12-03-2013 22:26
|
Breakaway Specialist
Posts: 796
Joined: 17-02-2013
PCM$: 200.00
|
Ss please,i'm not microsoft guy. |
| |
|
|
| haasje33 |
Posted on 12-03-2013 22:27
|
Sprinter
Posts: 1679
Joined: 08-08-2009
PCM$: 200.00
|
You can also click in the next tab manually in excel.
Inactive due to personal reasons.
|
| |
|
|
| haasje33 |
Posted on 12-03-2013 22:27
|
Sprinter
Posts: 1679
Joined: 08-08-2009
PCM$: 200.00
|
You can also click in the next tab manually in excel.
Inactive due to personal reasons.
|
| |
|
|
| haasje33 |
Posted on 12-03-2013 22:29
|
Sprinter
Posts: 1679
Joined: 08-08-2009
PCM$: 200.00
|
TTspecialist wrote:
Ss please,i'm not microsoft guy.
For OS X I have no clue (sadly; wish I had a Mac)
Inactive due to personal reasons.
|
| |
|
|
| TTspecialist |
Posted on 12-03-2013 22:32
|
Breakaway Specialist
Posts: 796
Joined: 17-02-2013
PCM$: 200.00
|
Naaah,no way,anyone who can explain it to me? Btw ,how can i generate and dont get "Nakamura" as first one,i mean,to get new set of cyclists? |
| |
|
|
| NTTHRASH |
Posted on 12-03-2013 22:36
|
Classics Specialist
Posts: 3192
Joined: 09-09-2012
PCM$: 3540.00
|
haasje33 wrote:
NTTHRASH wrote:
How to unprotect the file?
I won't give you the password, but I'll try to solve it asap.
:/
"America. Show a nipple on television and the whole country goes ape-shit." -DubbelDekker
|
| |
|
