|
Transfers DB 2019
|
| roturn |
Posted on 17-09-2019 07:37
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
19/09 2:34 PM: Transfers DB (Final_v2) now available. https://www.dropbox.com/s/m95m5wbi6me...2.xls?dl=0
---
- Rider and team names lost any special letters, which could lead to different excel versions to struggle with such as "Ø" or "è" or "Ã" etc. As this was rather annoying coming to race results and rankings, those are gone in the following season.
----
Otherwise, here is the first Post-Renewals DB for the MG 2018 season.
Included are:
- The results of the renewals process - with those who have departed teams now in the free agency; alongside riders from disbanded teams; previous free agents; and newly added riders.
- Wages of renewed riders.
- Updated RD information
- Updated NCs
- Updated training and Avenir eligibility
- Updated xp values as also stat gain/decreases of all riders
- Updated OVL
- OVL Macro (CTRL+SHIFT+O) Row or rows that are wanted to update need to be selected.
Please check your teams to confirm your riders are as-renewed.
Edited by roturn on 19-09-2019 14:34
|
| |
|
|
| roturn |
Posted on 17-09-2019 07:40
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
---
Edited by roturn on 17-09-2019 16:22
|
| |
|
|
| beagle |
Posted on 17-09-2019 08:22
|
Grand Tour Specialist
Posts: 4200
Joined: 06-10-2007
PCM$: 200.00
|
Thanks for DB!
Podium Ambition and Farfetch should be in PT, I guess.
Manager of Polar in Man-Game
|
| |
|
|
| Fabianski |
Posted on 17-09-2019 08:31
|
Grand Tour Specialist
Posts: 4669
Joined: 29-09-2018
PCM$: 185.00
|
Thanks for the DB. Adds quite a lot of interesting riders to the FA market 
The column labelled "Column1" (Column P in the Sheet) means Prologue, I guess? |
| |
|
|
| matt17br |
Posted on 17-09-2019 08:41
|
Directeur Sportif
Posts: 10525
Joined: 28-09-2013
PCM$: 200.00
|
Fabianski wrote:
Thanks for the DB. Adds quite a lot of interesting riders to the FA market
The column labelled "Column1" (Column P in the Sheet) means Prologue, I guess?
Yeah it's prologue.
|
| |
|
|
| jaxika |
Posted on 17-09-2019 08:47
|
Classics Specialist
Posts: 3148
Joined: 16-07-2008
PCM$: 9200.00
|
My team is listed as CT team (ENI-MOL). |
| |
|
|
| Ad Bot |
Posted on 22-11-2024 07:14
|
Bot Agent
Posts: Countless
Joined: 23.11.09
|
|
| IP: None |
|
|
| Gustavovskiy |
Posted on 17-09-2019 08:54
|
Team Leader
Posts: 6036
Joined: 20-07-2008
PCM$: 200.00
|
Diving right in 
|
| |
|
|
| roturn |
Posted on 17-09-2019 09:00
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Whoever has already uploaded, you can do so again and it fixes the late promotion team divisions as also the prologue title.  |
| |
|
|
| the_hoyle |
Posted on 17-09-2019 09:50
|
Grand Tour Champion
Posts: 7651
Joined: 28-05-2009
PCM$: 200.00
|
I don't care if I am at work and my boss shouts at me... downloaded and the shortlisting is on!
.: Manager of :.
.: My Awards :.
 |
| |
|
|
| jandal7 |
Posted on 17-09-2019 10:24
|
World Champion
Posts: 11392
Joined: 17-12-2014
PCM$: 1020.00
|
Me to the Pre-Renewals DB:
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 |
| |
|
|
| roturn |
Posted on 17-09-2019 10:52
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
-
Edited by roturn on 17-09-2019 16:23
|
| |
|
|
| cio93 |
Posted on 17-09-2019 12:39
|
World Champion
Posts: 10845
Joined: 29-10-2007
PCM$: 500.00
|
Usually, running the macro will crash my excel about half the time and give me weird results the other half, fingers crossed it's either better this time or just a problem on my end.
Thank you roturn for taking care of this.
|
| |
|
|
| baseballlover312 |
Posted on 17-09-2019 13:38
|
Tour de France Champion
Posts: 16429
Joined: 27-07-2011
PCM$: 10438.70
|
RIP Exxon Duke, David Veilleux, Double Feature, and Monster Energy |
| |
|
|
| roturn |
Posted on 17-09-2019 14:50
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Thanks to Fabianski the Macro has improved hugely.
Instead of updating the full coloumn, it only updates the row, which is selected by you.
So only takes a second instead of waiting 2-3 minutes or longer.
Still working with CTSL+SHIFT+O with the selected row.
Edited by roturn on 17-09-2019 16:23
|
| |
|
|
| Fabianski |
Posted on 17-09-2019 15:05
|
Grand Tour Specialist
Posts: 4669
Joined: 29-09-2018
PCM$: 185.00
|
Note that this works with multiple selected rows as well. Every row that has at least one cell selected will see the OVL updated. So if you like, you can still update every rider by doing a Ctrl + A first |
| |
|
|
| ryant |
Posted on 17-09-2019 15:08
|
Small Tour Specialist
Posts: 2322
Joined: 15-08-2012
PCM$: 200.00
|
Its here!
Time to make impossible plans that will inevitably fail after a few hours
 John St Ledger in Team Bunzl-Centrica and Team U25Red Bull Driver in RFactor
|
| |
|
|
| roturn |
Posted on 17-09-2019 16:21
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
V3 uploaded: Now most likely the final version with Netia having finished:
https://www.dropb...3.xls?dl=0 |
| |
|
|
| knockout |
Posted on 17-09-2019 16:23
|
Grand Tour Champion
Posts: 7735
Joined: 21-12-2010
PCM$: 400.00
|
Can we move this thread to the rules and announcement thread then? Easier to remember when looking for this thread in the future
A Big Thank You To All MG Reporters! |
| |
|
|
| roturn |
Posted on 17-09-2019 16:26
|
Team Manager
Posts: 22246
Joined: 24-11-2007
PCM$: 3900.00
|
Already done.
Simply wasn`t that fast and you are free to speak according to the rules from now on. |
| |
|
|
| knockout |
Posted on 17-09-2019 16:28
|
Grand Tour Champion
Posts: 7735
Joined: 21-12-2010
PCM$: 400.00
|
Thanks 
A Big Thank You To All MG Reporters! |
| |
|
