IG Market Ranking
The backbone of the whole game is the IG Market Ranking list. (http://igcycling.com/the-ig-cycling-index/
). The IG World Rankings is a weekly updated list of the best riders in the past year. Unlike the UCI ranking, the IG ranking always goes back one year from today and uses much more races. It also rates traditional races with historical status higher. It reflects the real world of cycling more than the UCI list that wants to push new races worldwide.
The game is programmed in VBA Excel and all results are shown in Excel 2010 Files. If you don’t have Excel 2010 you can view the files on Skydrive or you might to want download the free Excel Viewer from Microsoft: http://www.microsoft.com/en-us/downl...ils.aspx?id=10
The Excel Tables
You start with four tables that contain all the information you need for the game. I will add more tables as we go but they are not essential – just more tools for research and additional reports and graphs to make it more fun.
The four tables get updated after every update of the IG Market Ranking, usually once per week.
The tables can be sorted and filtered by using the arrows below the column header. Play around with it and you will soon find out how it works. It is pretty cool. By combing filters and orders you can squeeze out any possible information you can imagine.
You will have a copy of the original so you can mess around with them as much as you want as you will get a new one every week. You don’t relay or enter any information via the tables. This is done by email. The tables are just for reading and researching.
• Ranking of the Teams in the game
• Which teams belongs to which manager (still to be added)
• Points and Price money earned in the last period
• Your available money (Budget)
• Estimated end of the month earnings (Remember: estimated)
• Team Balance Status (Balance between star riders and domestiques)
“rAllRidersWeb” – this list starts with 200 riders and is identical with the IG Market rider at the start. But each week new riders will make the top 200 and “old” riders will fall out of the IG Market list. But the “old” riders will stay in the “rAllRidersWeb” and contain all the riders who have been in the top 200 this year. So the list will get longer every week. Why I do this is explained further down.
• Rank of riders according to the IG Market Ranking
• Status of riders – current top 200 or “old” top 200
• Name, Team, Current Points, Current Value and Wages of riders
• Amount of Price Money in last period
• Current Rider Sponsor Money (RSM) for each rider (only for top 40 riders)
• Total earned money of each rider for the year and since he is in that particular team
• Number of domestiques needed for that rider (no number means he is a domestiques himself)
A log book for all transfers. I fill that in after players decide to “act” – meaning to buy, sell, or move riders. These actions will be communicated via email between players. No player fills in the Logbook. All the transactions in the Logbook will be executed after each period (see below). You as a player use this Logbook to check if your actions have been logged correctly and to update yourself about who does what.
“Individual Team sheets e.g “Nuts Nuts Nuts.xlsx”
Most of the information is already summed up in the “rTeamSummary”. The Team sheet gives you a detailed record of all financial transactions of your team. More importantly, it shows you the status of the active and inactive rider list. In other words you see if there are available spots in your team and in what list. It also shows you the value and wages from when you bought a rider which is different to the current value and wages.
Points + Money
The team with the most team points at the end of the season will win. There will be several minor competition within that e.g best Classics team, Grand Tours. Ideally, you want to have riders that move up that ranking during the year because lower ranked riders are cheaper to buy, cost less wages and need less domestiques to start with. To win the game you have to optimize the costs and earnings of riders with the points they deliver. It is not necessarily the best tactics to buy a top rider for your team. Price money, for example, is only paid on the increase in points in the rankings after each update. So, if a rider won a race last year and wins it again he does not earn price money as he hasn’t improved in the ranking. However, it might still be beneficial to have top riders in your team because the top riders earn your team a lot of Rider Sponsor Money and bring your team lots of points.
Every team has an initial starting budget of 1 Million Euros. The initial teams consist of seven riders which were distributed to the 20 teams in a way that they have about the same team points to start from. However, to make the game more interesting and interactive, I decided to allow an all-season transfer period . That’s where your skills will come in. Within the given budget you have to slowly improve your team by selling and buying riders. However, you can still win the game without selling any of your riders. You can have a maximum of 15 active and 5 inactive riders in your team.
The team has monthly expenses for financing and administration.
Riders have to be purchased from the market or from other teams. Wages have to be paid to them. Riders can be released to the market (No Income) or sold to other teams (Income).
There will be five different ways of earning money for a team:
• Price Money from increase in the ranking between updates
• Rider Sponsor Money for the top 40 riders in the ranking (200.000 – 1000 Euro per month) – can change during the season according to economic situation.
• Team Sponsor Money for all teams depending on their standings at the end of the month (60.000 – 3.000) – can change during the season according to economic situation.
• Gain through selling a rider for more than you paid for him
• Gain through buying a rider outside the Top 200 (off the ranking list) and capitalising on him when he makes the ranking. This is a very exciting option for the skilled Manager.
1. Price Money (PM in Tables) is earned by your riders in real races. The amount is based on the IG Market Scoring System. Important: Price Money is calculated by the increase in points x 150 Euro between two updates. Example: A rider sits on 600 points on 1st of March. He does a race on the 3rd of March and comes 3rd. If he didn’t do that race the previous season or ranked lower than 3rd his ranking points will increase to, for example, 650 points. He will earn 50 x 150 Euro = 7500 Euro. If, however, he was 3rd or better in the year before in that race his ranking won’t increase and he won’t earn any price money for that period.
2. Rider Sponsor Money (RSM) is paid to your team if a rider enters Top 40. It is paid at the end of each month and the rider has to be in your team at that point of time. Obviously, getting your riders into the Top 40 is one important way to fund your team but not the only one.
3. Team Sponsor Money (TSM) is paid to your team at the end of each month. As higher your team is ranked as more you get.
4. Selling a rider with profit. You can offer a rider to other teams and gain money if you sell them for more than you paid for. This is a difficult decision and will require a lot of skills because you lose the points for this rider and all his future earnings. At the end of the day you win the game with points, not with money. So money is only the means to develop your team in order to gain more points.
5. Off list purchases. This is the most exciting part of the game. Most other games deal with the stars of cycling and they are easy to pick. But to have a star-studded team you need lots of money and the reality is that most teams don’t have lots of money to simply buy the known stars. Therefore you have to buy the future stars. You can buy any professional cyclist for your team – not only the riders on the IG Market Ranking. Any Rider off the list cost 20.000 Euros and has a wage of 2.000 Euros. Cheap. However, as long he is not in the top 200 this rider won’t earn any money for your team. And he will be hard to sell too. However, if he makes the ranking and comes to sudden fame you cash in. As soon he makes the ranking his points will shoot up to around 450 – 500 points. As he starts from 0 points he will earn 500 x 150 Euro = 75.000 Euro. And he might rise further during the year within the ranking. Important: This cash-in works only when a rider enters the Top 200 for the first time in this year. If a rider falls out of the top 200 he becomes an “old” rider (with “old” being entered in the status column of the” rAllRidersWeb” Table.) Therefore, always double check if an off list rider has been in the top 200 previously, before you buy him.