|
RTG '17 | General
|
| AbhishekLFC |
Posted on 20-06-2018 11:48
|
Directeur Sportif
Posts: 11675
Joined: 27-07-2015
PCM$: 1861.50
|
TheManxMissile wrote:
Can't put a value greater than 1 into M2 (Training Blocks)
It won't let me put 1 into F7 (Tropicale Bongo race), and i know it's not a clash because i've not put in any other races and it gives the error
Same for F40 (Bretagne Classic)
That's weird because it was working for me. Have re-tested and re-uploaded again. Hopefully it works now.
EDIT: Scratch that. Same problem when I download it. Need to check what's going on!
|
| |
|
|
| AbhishekLFC |
Posted on 20-06-2018 12:12
|
Directeur Sportif
Posts: 11675
Joined: 27-07-2015
PCM$: 1861.50
|
Looks like the validations are only working correctly in Microsoft Office Excel and Google Sheets. I'll see what I can do to change it.
|
| |
|
|
| hillis91 |
Posted on 20-06-2018 12:24
|
Team Leader
Posts: 5896
Joined: 30-11-2006
PCM$: 1500.00
|
I'll be doing this tonight 
|
| |
|
|
| AbhishekLFC |
Posted on 20-06-2018 12:34
|
Directeur Sportif
Posts: 11675
Joined: 27-07-2015
PCM$: 1861.50
|
Validations have been removed and the file re-uploaded. It seems to be working fine on all platforms now. Please take care of the race clashes. I've made it easier to identify clashing races when there are quite a few bunched together. Hope that helps.
Updated instructions...
Link: https://www.dropb....xlsx?dl=0
- Download the file from the above location.
- Enter your rider's ID in cell I2 in 'Calendar' sheet. All cells marked #N/A will be populated. Please check if the populated details are correct. All riders are less than 24 years old and should have 60 RDs available.
- You can look up your rider's ID in 'Custom Riders DB' sheet. You can ignore the stats in this sheet as it still has the base stats.
- Select the number of training blocks you want your rider to attend and enter a value between 1 and 3 in cell M2 (this is not mandatory). Each training block costs 5 RDs but gives guaranteed points as specified in the Points file. A maximum of 15 RDs can be spent on training.
- Clashing races are marked with letters 'A' through 'M' in column E. The races which clash with each other have the same letter against them.
- Enter '1' in cells F2-F47 for the races you want to participate in.
- Cell I10 will tell you the number of RDs you have remaining. It will turn red if you enter more races than your RDs allow. It has to be zero or a positive number.
- Once you are satisfied, copy cells C2-F47 and send them to me in a table via PM. Also send me the value in cell M2 (number of training blocks).
Edited by AbhishekLFC on 20-06-2018 12:59
|
| |
|
|
| Supernutz |
Posted on 22-06-2018 12:06
|
Stagiare
Posts: 156
Joined: 03-09-2015
PCM$: 200.00
|
Can you remind me where the Custom Riders DB is in the various threads? I can't remember where it is stored... |
| |
|
|
| AbhishekLFC |
Posted on 22-06-2018 12:23
|
Directeur Sportif
Posts: 11675
Joined: 27-07-2015
PCM$: 1861.50
|
Supernutz wrote:
Can you remind me where the Custom Riders DB is in the various threads? I can't remember where it is stored...
It is in the excel that I shared for Race Selection (it is also there in the Stat Upgrade sheet shared earlier). Check the second sheet in the excel file.
|
| |
|
|
| Ad Bot |
Posted on 22-11-2024 08:41
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| Ripley |
Posted on 23-06-2018 10:40
|
Classics Specialist
Posts: 3341
Joined: 25-11-2014
PCM$: 300.00
|
Race selection made and sent!
|
| |
|
|
| Tamijo |
Posted on 23-06-2018 13:04
|
Team Leader
Posts: 7406
Joined: 14-07-2015
PCM$: 599.00
|
Done
|
| |
|
|
| Supernutz |
Posted on 24-06-2018 00:15
|
Stagiare
Posts: 156
Joined: 03-09-2015
PCM$: 200.00
|
Done for me as well.
Here's hoping I get in a breakaway or two...
Good luck all! |
| |
|
|
| AbhishekLFC |
Posted on 25-06-2018 10:55
|
Directeur Sportif
Posts: 11675
Joined: 27-07-2015
PCM$: 1861.50
|
I've received a steady stream of race schedules over the weekend. Thank you all for the prompt responses. Still need 10 more to be sent in.
Two riders still to do their stat upgrades - Jensen and Molnar. Please send them in at the earliest.
Still hoping to wrap everything up by Saturday, 30th June. That's the deadline.
EDIT: Sign-ups are also open till then.
|
| |
|
|
| jseadog1 |
Posted on 25-06-2018 12:53
|
Grand Tour Champion
Posts: 9595
Joined: 18-07-2010
PCM$: 13552.00
|
Everything sent in for me, looking forward to the start
PCM.Daily Survivor Season 2 Fan Favorite Winner
PCM.Daily NFL Fantasy Football Champion: 2012
PCM.Daily NHL Prediction Game Champion: 2013
PCM.Daily NFL Prediction Game Champion: 2012, 2013, 2015, 2016, 2021
|
| |
|
|
| AbhishekLFC |
Posted on 27-06-2018 06:18
|
Directeur Sportif
Posts: 11675
Joined: 27-07-2015
PCM$: 1861.50
|
Entries have slowed down over the past couple of days, with only one new race selection that I've received. Let me know if you guys need more time. I know some of you are involved in other things on the site as well (so am I  ).
Hoping that we can get going soon.
|
| |
|
|
| Ollfardh |
Posted on 27-06-2018 09:08
|
World Champion
Posts: 14563
Joined: 08-08-2011
PCM$: 9100.00
|
Punishments!
Changed my sig, this was getting absurd.
|
| |
|
|
| Croatia14 |
Posted on 27-06-2018 09:35
|
Directeur Sportif
Posts: 9099
Joined: 13-03-2013
PCM$: 2100.00
|
Incentives!
|
| |
|
|
| jandal7 |
Posted on 27-06-2018 11:16
|
World Champion
Posts: 11392
Joined: 17-12-2014
PCM$: 1020.00
|
<3
Sorry for not getting it in. Will do it tomorrow probably.
24/02/21 - kandesbunzler said “I don't drink famous people."
15/08/22 - SotD said "Your [jandal's] humour is overrated"
11/06/24 - knockout said "Winning is fine I guess. Truth be told this felt completely unimportant."
[ICL] Santos-Euskadi | [PT]  Xero Racing
5x  x5
2x  x2
2x  x2 |
| |
|
|
| Ripley |
Posted on 27-06-2018 11:37
|
Classics Specialist
Posts: 3341
Joined: 25-11-2014
PCM$: 300.00
|
That reminds me of a famous English verse:
Sticks and stones may break my bones,
but whips and chains excite me
Spoiler Actually, it's a children's rhyme which goes
Sticks and stones may break my bones,
but words will never break me
But I always preferred the more adult version. 
|
| |
|
|
| Aquarius97 |
Posted on 27-06-2018 11:46
|
Grand Tour Specialist
Posts: 4191
Joined: 13-09-2015
PCM$: 300.00
|
I'll do my planning asap
|
| |
|
|
| Aquarius97 |
Posted on 27-06-2018 11:52
|
Grand Tour Specialist
Posts: 4191
Joined: 13-09-2015
PCM$: 300.00
|
How does the training blocks work?
Edit: Nevermind, i found it 
|
| |
|
|
| viking90 |
Posted on 27-06-2018 19:45
|
Grand Tour Specialist
Posts: 4032
Joined: 24-01-2009
PCM$: 200.00
|
I hope you have got them from me, they are in my outbox anyway
But have not got any confirmation from you, (not that I mean that you must replay to every PM) just so it is not me delaying it |
| |
|
|
| Booker |
Posted on 28-06-2018 00:22
|
Breakaway Specialist
Posts: 873
Joined: 03-07-2013
PCM$: 200.00
|
Done
|
| |
|
