Jump to content


Photo

NEW GAME! Atlas Shareholders


  • Please log in to reply
70 replies to this topic

#1 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 20 February 2008 - 10:06

Hello! I came up with a new game concept! Don't hit me!

Concept of the game
The players will be owning "shares" of the drivers participating in the F1 WDC!

A player will score points when a driver he/she holds an interest in scores points in a race.

Key to winning the game is finding best "value for money" (although no real money is involved) by investing in drivers that give good "value for money" at the moment. The "value" of each driver is decided by the collective investments of the players. This could mean that a backmarker that manages to score even just the odd point can make a rather big difference in this game.

Some pros for the game:
+ Easy entry format.
+ Editing entry for each round is optional, as the old entry carries over as it is otherwise.
+ Exciting scoring system making even backmarkers interesting for the game.

Some cons for the game:
- You initially won't know what value a driver will provide; I will however continually provide updates before Melbourne with the values for the drivers as entries (hopefully) roll in.
- Player needs to keep track of own share portfolio. Writing down for yourself what your current portfolio looks like is recommended, so you know what you've got.

I will provide data after each round that will help you analyze which drivers are worth investing in.

Submitting an initial entry

The first time you play this game, you shall submit an entry where you place 100 shares among the drivers, fulfilling these conditions:

* You may only hold 100 shares (or less, which doesn't help you) in total at a time.
* You can not own fractions of a share, just integer shares.
* You can place no more than 50 shares on any one driver.
* You must own shares in at least three drivers.
* You may not own shares in more than ten drivers.
* You may edit your first entry as much as you like until the edit deadline (first free practice) for the coming race.

Note that there is no limit to the number of shares available for each driver.
Also note that your initial entry is the basis for the following rounds too! You'll be allowed to change no more than 20 shares before each race, so make sure your initial entry looks at least 80% respectable...

Since nobody initially knows what the playing field looks like before the first race, I will give several updates on what the total share distribution looks like among the entries submitted so far.

Entry Example A:
Massa 37
Hamilton 22
Kovalainen 16
Webber 12
Coulthard 10
Button 3

Editing your entry after the first round it takes part in
* After the first race your entry took part in, you may only change 20 of your shares at a time (for the next race).
* You do not have to edit your entry at all! If you so wish, you can leave your entry as it is from race one and not make a single change throughout the season.
* If a driver is replaced -temporarily or permanently- during the season, the shares placed on him will automatically be transferred to the replacing driver. So you could say that the shares actually are attached to the car number.
* You may edit your changes as much as you like until the edit deadline for the coming race.
* Edit deadline for changes is the beginning of first free practice for each race.

Example B:
After the first race, the shareholder who submitted the entry in Example A realizes that Red Bull stink infinitely, and submits an edit to her entry as follows:

Sell:
Webber -10
Coulthard -10

Buy:
Alonso +10
Hamilton +5
Kovalainen +5

Her new "portfolio" will after the entry look like this:
Massa 37
Hamilton 27
Kovalainen 21
Alonso 10
Button 3
Webber 2

An edit doesn't have to look just like above, any way is fine as long as it's easy to understand which driver shares are to be sold and which to be bought.

NOTE: I won't automatically be posting updates on what each player's portfolio looks like, so remember to keep track of what you own!
The reason you're only allowed to change just 20 shares each round is that it adds some stability to the whole system: I hopefully won't get a nervous breakdown before every round, and the values for each driver won't move around all over the place from one round to the other. It will also force the players to think more long term with their investments.
Keep in mind that when there are shares removed from a driver, the potential return from the shares that remain will increase and vice versa.

Points Scoring, barely intelligible

*The score a player receives from a driver is calculated like this:

[DScore] = 25.7*[TShares]*[DRace]*[PDShares]/[DShares]

where
[TShares] = The total number of shares in the entire game at the moment
[DRace] = The number of points the driver in question scored in the race.
[PDShares] = The number of shares the player owns in a driver
[DShares] = The total number of shares owned in the driver in question by ALL players.

In order to only mess around with integer scores, the 25.7*[TShares]/[DShares] factor will be rounded off down to the nearest integer. This factor equals the amount of points a share will give per point scored by the driver in question.

*The total player score of the round is simply the sum of the [DScore] values from all drivers.

Thanks to the 25.7 factor, and the [TShares] factor scaling scores up with the amount of players, an average total score for a round will always be around 100,000 points or 1000 points per share, regardless of the number of players. At least if there are shares owned in all scoring drivers.

Example C:
Felipe Massa finishes 2nd in a race; there are 30 players in the game all with 100 shares each; 400 of all shares are placed on Massa. The entry in example B will then score approxrimately

25.7*3000*8*37/400 points, which with the rounding off will amount to exactly 56832 points. A good result from 37 shares. 400/3000 shares would mean a driver is valued at 5.2 points per race, and second place obviously is better than that.

Random incoherent strategy thoughts
The typical F1 season in this era sees most of the points in a season scored by just a handful of the drivers, driving the very best cars. It is therefore logical and strategically sound to have plenty of shares among these drivers, but due to the scoring system of this game it is likely that owning the odd share in the right backmarker driver can make a very big difference to the final outcome. Top team drivers could thus be considered safe bets, whereas shares in someone like Sato would be considered high risk ventures...

The total distribution of shares among the drivers is interesting; proportion wise it should end up somewhere along the lines of a PTPC entry, with 1/7th of all shares in the game representing approximately 100 points in the WDC.
But the scoring in a GP never will look like the average score per race over a full season!

As an example, the 2007 season:
[b]

Dri  Pts [/b]

Räik 110

Alon 109

Hami 109

Mass  94

Heid  61

Kubi  39

Kova  30

Fisi  21

Rosb  20

Coul  14

Wurz  13

Webb  10

Trul   8

Butt   6

Vett   6

Schu   5

Sato   4

Liuz   3

Suti   1

Albe   0

Barr   0

Davi   0

Spee   0
The top three drivers scored 328 out of the total 663 points last season: almost 50%! At an average, the three drivers scored almost 6.5 points each per race, about 1/6th of the points available in a race. If there had been shares distributed among the drivers in such proportions, it would then have taken a win or a second place for the shares to have given an above average return. Then again, they would usually at least finish in the points and give something to their investors, which would be more unusual for backmarker drivers like Sutil... You could imagine the jackpot it would have been from the precious few hypothetical shares held in Sato at the Canadian GP, where he scored three points. You could also imagine what a waste of effort those shares would have felt like for most of the rest of the season.

As a driver can only score a maximum of 10/39 = 25.64% of the points in a race, it is rather silly if more than 25.64% of the total shares (for all players) were placed on any one driver; there would be better value per share elsewhere. But as an individual player, placing 50 shares at one driver might still be a smart thing to do.

Particularly for backmarker drivers, there is a chance that there's only one player interested in owning shares in the driver. In this case, it's rather pointless for the player to have more than one single share placed on the driver, as more shares won't give a higher score anyway ([PDShares]/[DShares] = 2/2 = 1/1 = 100% of the shares in the driver). The probability for such a driver to score a point would logically be very low, but if he would do so, that single share would be extremely valuable! I will report how many shareholders there are for each driver, so a player having a monopoly gets to know it. Removing shares from the driver will however make him a more interesting investment object for other players.

Advertisement

#2 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 20 February 2008 - 10:07

And my initial entry to the game, extremely likely to be edited later on:
Hamilton 30
Alonso 20
Räikkönen 20
Massa 10
Kubica 10
Webber 5
Vettel 2
Trulli 2
Fisichella 1

#3 Orin

Orin
  • Member

  • 8,444 posts
  • Joined: October 04

Posted 20 February 2008 - 11:11

Sounds interesting :D

Raikkonen 50
Kovalainen 20
Kubica 10
Rosberg 10
Coulthard 10

#4 howardt

howardt
  • Member

  • 2,102 posts
  • Joined: February 02

Posted 20 February 2008 - 12:23

Okay then ...

Raikkonen 50
Hamilton 20
Massa 20
Kovaleinen 10

#5 LB

LB
  • Member

  • 13,575 posts
  • Joined: February 01

Posted 20 February 2008 - 12:45

25 Heidfeld
25 Coulthard
25 Webber
25 Kubica

#6 noikeee

noikeee
  • Member

  • 23,218 posts
  • Joined: February 06

Posted 20 February 2008 - 14:43

I suck at this kind of games, but anyway:

Raikkonen 20
Hamilton 20
Kovalainen 13
Massa 10
Alonso 10
Webber 10
Rosberg 8
Nakajima 4
Glock 3
Bourdais 2

A thing that I think is going to be a bit of a problem is that the sooner you post/edit your changes before first practice, the better, since you're going to get a more accurate perception of how drivers are valued.

#7 Apex

Apex
  • Member

  • 2,419 posts
  • Joined: March 00

Posted 20 February 2008 - 23:54

Piquet 10
Vettel 10
Button 10
Barrichello 10
Alonso 10
Kovalainen 10
Glock 10
Trulli 10
Bourdais 10
Sutil 10

#8 Costaz

Costaz
  • Member

  • 3,226 posts
  • Joined: December 03

Posted 21 February 2008 - 17:54

Sounds like a fun game (and also very complicated, good luck with running it!). Let's see.

Raikkonen 24
Hamilton 24
Massa 23
Kovalainen 20
Nakajima 9

#9 Estwald

Estwald
  • Member

  • 4,442 posts
  • Joined: March 02

Posted 22 February 2008 - 22:29


Raikkonen	20

Massa		20

Hamilton	20

Alonso		 8

Rosberg		 8

Kovalainen	 7

Heidfeld	 5

Nakajima	 4

Trulli		 4

Webber		 4


#10 dnbn

dnbn
  • Member

  • 2,033 posts
  • Joined: January 04

Posted 23 February 2008 - 13:11

Raikkonen 20
Kovalainen 15
Webber 15
Hamilton 10
Massa 10
Bourdais 10
Kubica 10
Rosberg 5
Fisichella 5

#11 coyoteBR

coyoteBR
  • Member

  • 4,085 posts
  • Joined: January 99

Posted 25 February 2008 - 11:23

Right, I'll give it a shot

Massa 45
Raikkonen 25
Nelsinho Piquet 12
Hamilton 5
Nakajima 5
Rosberg 5
Kubica 3

#12 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 27 February 2008 - 11:08

Here's some initial stats when the game has amassed ten players.
If you feel there's some important information that should be added, tell me:

The table below shows how many shares have been placed on each driver. 

The first four columns pretty much present the same figures in four different ways: 

* The second column is the amount of drivers scaled down so the total sum reflects the number of points in a race (39) 

* The third one is the second column multiplied by 18, for a view on a full season rating. 

* The fourth column is the rounded off   25.7*[TShares]/[DShares]	

  factor that I use for scoring (see opening post), which I call the "Value Per Point" factor. 

  [b]Multiply the VPP factor with a driver's race result and you'll get the number of points one share in the driver 

  will give you[/b]. A share will on average give about 1,000 points, so it's useful to try to beat that value.



The last column is the number of shareholders in each driver. Most notable here is that

* Apex so far has a monopoly on the Honda drivers and 

* Three drivers haven't got any owners yet. Considering the shaky condition Super Aguri seems to

  be in, it seems fairly sensible in their cases. Sutil surely is worth a shot though?



[b]

DRIVER	  DShares   Race Season	VPP Owners[/b]

Räikkönen	   229   8.93 160.75	112	  8

Massa		   148   5.77 103.89	173	  8

Hamilton		129   5.03  90.55	199	  7

Kovalainen	   95   3.70  66.69	270	  7

Webber		   59   2.30  41.41	435	  5

Kubica		   58   2.26  40.71	443	  5

Alonso		   48   1.87  33.69	535	  4

Rosberg		  36   1.40  25.27	713	  5

Coulthard		35   1.36  24.57	734	  2

Heidfeld		 30   1.17  21.06	856	  2

Bourdais		 22   0.85  15.44   1168	  3

Nakajima		 22   0.85  15.44   1168	  4

Piquet		   22   0.85  15.44   1168	  2

Trulli		   16   0.62  11.23   1606	  3

Glock			13   0.50   9.12   1976	  2

Vettel		   12   0.46   8.42   2141	  2

Barrichello	  10   0.39   7.02   2570	  1

Button		   10   0.39   7.02   2570	  1

Fisichella		6   0.23   4.21   4283	  2

Davidson		  0   0.00   0.00	N/A	  0

Sato			  0   0.00   0.00	N/A	  0

Sutil			 0   0.00   0.00	N/A	  0





Numbers in this table show how the VPP for a driver changes If an already playing player 

decides to add/remove shares from the driver:



[b]			   - - - - - - - - - - - - - - - - SHARE CHANGE + + + + + + + + + + + + + + +

DRIVER		  -50	-20	-10	 -3	 -1	[b]VPP[/b]	  1	  3	 10	 20	 50[/b]

Räikkönen	   143	122	117	113	112	[b]112[/b]	111	110	107	103	 92

Massa		   262	200	186	177	174	[b]173[/b]	172	170	162	152	129

Hamilton		325	235	215	203	200	[b]199[/b]	197	194	184	172	143

Kovalainen	  571	342	302	279	273	[b]270[/b]	267	262	244	223	177

Webber		 2855	658	524	458	443	[b]435[/b]	428	414	372	325	235

Kubica		 3212	676	535	467	450	[b]443[/b]	435	421	377	329	237

Alonso		  N/A	917	676	571	546	[b]535[/b]	524	503	443	377	262

Rosberg		 N/A   1606	988	778	734	[b]713[/b]	694	658	558	458	298

Coulthard	   N/A   1713   1028	803	755	[b]734[/b]	713	676	571	467	302

Heidfeld		N/A   2570   1285	951	886	[b]856[/b]	829	778	642	514	321

Bourdais		N/A  12850   2141   1352   1223   [b]1168[/b]   1117   1028	803	611	356

Nakajima		N/A  12850   2141   1352   1223   [b]1168[/b]   1117   1028	803	611	356

Piquet		  N/A  12850   2141   1352   1223   [b]1168[/b]   1117   1028	803	611	356

Trulli		  N/A	N/A   4283   1976   1713   [b]1606[/b]   1511   1352	988	713	389

Glock		   N/A	N/A   8566   2570   2141   [b]1976[/b]   1835   1606   1117	778	407

Vettel		  N/A	N/A  12850   2855   2336   [b]2141[/b]   1976   1713   1168	803	414

Barrichello	 N/A	N/A	N/A   3671   2855   [b]2570[/b]   2336   1976   1285	856	428

Button		  N/A	N/A	N/A   3671   2855   [b]2570[/b]   2336   1976   1285	856	428

Fisichella	  N/A	N/A	N/A   8566   5140   [b]4283[/b]   3671   2855   1606	988	458

Davidson		N/A	N/A	N/A	N/A	N/A	[b]N/A[/b]  25700   8566   2570   1285	514

Sato			N/A	N/A	N/A	N/A	N/A	[b]N/A[/b]  25700   8566   2570   1285	514

Sutil		   N/A	N/A	N/A	N/A	N/A	[b]N/A[/b]  25700   8566   2570   1285	514





The table below reflects VPP changes if one all new player adds 100 shares to the game 

and X to whichever driver:



[b]			NEW PLAYER ADDITION + + + + + + + + + + + + + + +

DRIVER			1	  2	  3	  5	 10	 20	 30	 50[/b]

Räikkönen	   122	122	121	120	118	113	109	101

Massa		   189	188	187	184	178	168	158	142

Hamilton		217	215	214	210	203	189	177	157

Kovalainen	  294	291	288	282	269	245	226	194

Webber		  471	463	455	441	409	357	317	259

Kubica		  479	471	463	448	415	362	321	261

Alonso		  576	565	554	533	487	415	362	288

Rosberg		 764	743	724	689	614	504	428	328

Coulthard	   785	764	743	706	628	514	434	332

Heidfeld		911	883	856	807	706	565	471	353

Bourdais	   1229   1177   1130   1047	883	673	543	392

Nakajima	   1229   1177   1130   1047	883	673	543	392

Piquet		 1229   1177   1130   1047	883	673	543	392

Trulli		 1662   1570   1487   1346   1087	785	614	428

Glock		  2019   1884   1766   1570   1229	856	657	448

Vettel		 2174   2019   1884   1662   1285	883	673	455

Barrichello	2570   2355   2174   1884   1413	942	706	471

Button		 2570   2355   2174   1884   1413	942	706	471

Fisichella	 4038   3533   3141   2570   1766   1087	785	504

Davidson	  28270  14135   9423   5654   2827   1413	942	565

Sato		  28270  14135   9423   5654   2827   1413	942	565

Sutil		 28270  14135   9423   5654   2827   1413	942	565





Finally, I calculated what the results had been for the 2007 Brazilian GP with these figures a few times:



The first seven players:

Name				  Score  1 Räik  2 Mass  3 Alon  4 Rosb  5 Kubi  6 Heid  7 Hami  8 Trul  

Makarias			 125778   21800   19680   53880	   0   15960	   0   11460	2998

Orin				 120410   54500	   0	   0   49950   15960	   0	   0	   0

paranoik0			116020   21800   19680   26940   39960	   0	   0	7640	   0

howardt			  101500   54500   39360	   0	   0	   0	   0	7640	   0

LB					93825	   0	   0	   0	   0   39900   53925	   0	   0

Costaz				80592   26160   45264	   0	   0	   0	   0	9168	   0

Apex				  61610	   0   19680   26940	   0	   0	   0	   0   14990



Add Estwald, a good score that changes the values for the initial seven, mostly to the negative

although LB gains as his big Kubica investment doesn't get "diluted" by Estwald:

Name				  Score  1 Räik  2 Mass  3 Alon  4 Rosb  5 Kubi  6 Heid  7 Hami  8 Trul  

Estwald			  132319   22200   35360   20544   31600	   0   10275	7200	5140

Makarias			 122850   22200   17680   51360	   0   18240	   0   10800	2570

Orin				 113240   55500	   0	   0   39500   18240	   0	   0	   0

paranoik0			104360   22200   17680   25680   31600	   0	   0	7200	   0

howardt			   98060   55500   35360	   0	   0	   0	   0	7200	   0

LB					96975	   0	   0	   0	   0   45600   51375	   0	   0

Costaz				75944   26640   40664	   0	   0	   0	   0	8640	   0

Apex				  56210	   0   17680   25680	   0	   0	   0	   0   12850



Then I added dnbn and coyoteBR... Suddenly my entry is better than Estwald's, as neither one 

added shares to Alonso, which helps me greatly:

Name				  Score  1 Räik  2 Mass  3 Alon  4 Rosb  5 Kubi  6 Heid  7 Hami  8 Trul  

Makarias			 133312   22400   13840   64200	   0   17720	   0   11940	3212

Estwald			  131504   22400   27680   25680   28520	   0   12840	7960	6424

coyoteBR			 115411   28000   62280	   0   17825	5316	   0	1990	   0

Orin				 109370   56000	   0	   0   35650   17720	   0	   0	   0

LB				   108500	   0	   0	   0	   0   44300   64200	   0	   0

paranoik0			104820   22400   13840   32100   28520	   0	   0	7960	   0

howardt			   91640   56000   27680	   0	   0	   0	   0	7960	   0

dnbn				  75765   22400   13840	   0   17825   17720	   0	3980	   0

Costaz				68264   26880   31832	   0	   0	   0	   0	9552	   0

Apex				  62000	   0   13840   32100	   0	   0	   0	   0   16060



Hopefully we'll have plenty more players before the deadline. That will mean that a single player's doings will

ultimately affect the other player's values a bit less drastically.


#13 Orin

Orin
  • Member

  • 8,444 posts
  • Joined: October 04

Posted 27 February 2008 - 12:23

Makarias, I wish to update my entry as follows:-

Raikkonen 50 - 20 = 30
Hamilton 0 + 20 = 20
Kovalainen 20 + 10 = 30
Kubica 10 (no change)
Rosberg 10 (no change)
Coulthard 10 - 10 = 0

#14 KWSN - DSM

KWSN - DSM
  • Member

  • 36,361 posts
  • Joined: January 03

Posted 27 February 2008 - 13:57

Raikkonen - 15
Hamilton - 15
Massa - 15
Kovalainen - 15
Rosberg - 15
Vettel - 15
Fisichella - 10

:cool:

#15 Moanaman

Moanaman
  • Member

  • 6,035 posts
  • Joined: July 01

Posted 27 February 2008 - 20:00

Raikkonen - 15
Massa - 15
Heidfeld - 15
Kovalainen - 14
Kubica - 10
Alonso - 10
Rosberg - 9
Coultard - 7
Bourdais - 5

#16 noikeee

noikeee
  • Member

  • 23,218 posts
  • Joined: February 06

Posted 27 February 2008 - 21:23

Small excel sheet I made to help keeping track of the changes in shares, and to simulate a race result:

http://rapidshare.co...olders.xls.html

To use it, just type into the grey cells, or choose the drivers from the dropdown menus.

#17 Jason

Jason
  • Member

  • 4,095 posts
  • Joined: September 99

Posted 27 February 2008 - 21:52

Räikkönen 18
Hamilton 15
Massa 13
Kovalainen 12
Rosberg 11
Nakajima 10
Alonso 9
Trulli 7
Heidfeld 5

#18 fisichella_2001

fisichella_2001
  • Member

  • 2,952 posts
  • Joined: February 01

Posted 02 March 2008 - 13:17

Raikkonen - 27
Hamilton - 18
Massa - 16
Alonso - 13
Rosberg - 11
Webber - 8
Bourdais - 5
Fisichella - 2

#19 estoril85

estoril85
  • Member

  • 1,380 posts
  • Joined: January 03

Posted 04 March 2008 - 09:14

Hamilton 15
Raikkonen 15
Rosberg 15
Kovalainen 10
Massa 10
Alonso 10
Trulli 8
Piquet 7
Coulthard 5
Sutil 5

Advertisement

#20 maxie

maxie
  • Member

  • 1,537 posts
  • Joined: February 01

Posted 04 March 2008 - 16:46

Hamilton 30
Raikkonen 30
Massa 20
Kovalainen 20

#21 V8 Fireworks

V8 Fireworks
  • Member

  • 10,824 posts
  • Joined: June 06

Posted 06 March 2008 - 02:25

Heidfeld 30
Rosberg 30
Raikkonen 20
Heidfeld 20

#22 Kooper

Kooper
  • Member

  • 2,189 posts
  • Joined: May 04

Posted 06 March 2008 - 04:42

Raikkonen - 45
Hamilton - 25
Massa - 10
Kovalainen - 10
Alonso - 10

#23 Alapan

Alapan
  • Member

  • 6,243 posts
  • Joined: October 00

Posted 07 March 2008 - 07:02

Raik 20
Hami 20
Mass 20
Kova 20
Naka 10
Sutil 10

#24 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 07 March 2008 - 09:39

Up to 19 players now!
*V8 Fireworks entered Heidfeld twice, for 30 and 20 shares. Perhaps intended otherwise, but it adds up to 50 shares on Heidi and is a valid entry.

[b]DRIVER	  DShares   Race Season	VPP Owners[/b]

Räikkönen	   414   8.49 152.96	117	 17

Hamilton		287   5.89 106.03	170	 15

Massa		   257   5.27  94.95	190	 15

Kovalainen	  206   4.22  76.11	237	 14

Rosberg		 127   2.60  46.92	384	 11

Alonso		  100   2.05  36.94	488	  9

Heidfeld		100   2.05  36.94	488	  5

Kubica		   68   1.39  25.12	718	  6

Webber		   67   1.37  24.75	728	  6

Nakajima		 42   0.86  15.51   1162	  6

Coulthard		37   0.75  13.67   1319	  3

Bourdais		 32   0.65  11.82   1525	  5

Trulli		   31   0.63  11.45   1575	  5

Piquet		   29   0.59  10.71   1683	  3

Vettel		   27   0.55   9.97   1808	  3

Sutil			25   0.51   9.23   1953	  3

Fisichella	   18   0.36   6.65   2712	  4

Glock			13   0.26   4.80   3756	  2

Barrichello	  10   0.20   3.69   4883	  1

Button		   10   0.20   3.69   4883	  1

Davidson		  0   0.00   0.00	N/A	  0

Sato			  0   0.00   0.00	N/A	  0



* Apex still has a Honda monopoly...

* Zero interest in Super Aguri so far...

* Kimi won't provide good value for money at this rate...



[b]			   - - - - - - - - - - - - - - - - SHARE CHANGE + + + + + + + + + + + + + + +

DRIVER		  -50	-20	-10	 -3	 -1	[b]VPP[/b]	  1	  3	 10	 20	 50[/b]

Räikkönen	   134	123	120	118	118	[b]117[/b]	117	117	115	112	105

Hamilton		206	182	176	171	170	[b]170[/b]	169	168	164	159	144

Massa		   235	206	197	192	190	[b]190[/b]	189	187	182	176	159

Kovalainen	  313	262	249	240	238	[b]237[/b]	235	233	226	216	190

Rosberg		 634	456	417	393	387	[b]384[/b]	381	375	356	332	275

Alonso		  976	610	542	503	493	[b]488[/b]	483	474	443	406	325

Heidfeld		976	610	542	503	493	[b]488[/b]	483	474	443	406	325

Kubica		 2712   1017	841	751	728	[b]718[/b]	707	687	626	554	413

Webber		 2872   1038	856	762	739	[b]728[/b]	718	697	634	561	417

Nakajima		N/A   2219   1525   1252   1190   [b]1162[/b]   1135   1085	939	787	530

Coulthard	   N/A   2872   1808   1436   1356   [b]1319[/b]   1285   1220   1038	856	561

Bourdais		N/A   4069   2219   1683   1575   [b]1525[/b]   1479   1395   1162	939	595

Trulli		  N/A   4439   2325   1743   1627   [b]1575[/b]   1525   1436   1190	957	602

Piquet		  N/A   5425   2570   1878   1743   [b]1683[/b]   1627   1525   1252	996	618

Vettel		  N/A   6975   2872   2034   1878   [b]1808[/b]   1743   1627   1319   1038	634

Sutil		   N/A   9766   3255   2219   2034   [b]1953[/b]   1878   1743   1395   1085	651

Fisichella	  N/A	N/A   6103   3255   2872   [b]2712[/b]   2570   2325   1743   1285	718

Glock		   N/A	N/A  16276   4883   4069   [b]3756[/b]   3487   3051   2123   1479	775

Barrichello	 N/A	N/A	N/A   6975   5425   [b]4883[/b]   4439   3756   2441   1627	813

Button		  N/A	N/A	N/A   6975   5425   [b]4883[/b]   4439   3756   2441   1627	813

Davidson		N/A	N/A	N/A	N/A	N/A	[b]N/A[/b]  48830  16276   4883   2441	976

Sato			N/A	N/A	N/A	N/A	N/A	[b]N/A[/b]  48830  16276   4883   2441	976



[b]			NEW PLAYER ADDITION + + + + + + + + + + + + + + +

DRIVER			1	  2	  3	  5	 10	 20	 30	 50[/b]

Räikkönen	   123	123	123	122	121	118	115	110

Hamilton		178	177	177	176	173	167	162	152

Massa		   199	198	197	196	192	185	179	167

Kovalainen	  248	247	245	243	237	227	217	200

Rosberg		 401	398	395	389	375	349	327	290

Alonso		  508	503	499	489	467	428	395	342

Heidfeld		508	503	499	489	467	428	395	342

Kubica		  744	734	723	704	658	584	524	435

Webber		  755	744	734	713	667	590	529	439

Nakajima	   1195   1168   1142   1093	988	829	713	558

Coulthard	  1352   1317   1285   1223   1093	901	767	590

Bourdais	   1557   1511   1468   1389   1223	988	829	626

Trulli		 1606   1557   1511   1427   1253   1007	842	634

Piquet		 1713   1658   1606   1511   1317   1048	871	650

Vettel		 1835   1772   1713   1606   1389   1093	901	667

Sutil		  1976   1903   1835   1713   1468   1142	934	685

Fisichella	 2705   2570   2447   2234   1835   1352   1070	755

Glock		  3671   3426   3212   2855   2234   1557   1195	815

Barrichello	4672   4283   3953   3426   2570   1713   1285	856

Button		 4672   4283   3953   3426   2570   1713   1285	856

Davidson	  51400  25700  17133  10280   5140   2570   1713   1028

Sato		  51400  25700  17133  10280   5140   2570   1713   1028


#25 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 10 March 2008 - 23:46

*bump*

#26 Czesc

Czesc
  • Member

  • 959 posts
  • Joined: August 99

Posted 11 March 2008 - 09:43

Rosberg - 50
Kubica - 25
Heidfeld - 25

#27 1george

1george
  • Member

  • 1,517 posts
  • Joined: June 01

Posted 11 March 2008 - 10:09

Rosberg 20
Kubica 20
Massa 15
Raikkonen 15
Heidfeld 10
Alonso 10
Kovalainen 10

#28 Alapan

Alapan
  • Member

  • 6,243 posts
  • Joined: October 00

Posted 11 March 2008 - 10:36

Makarias, I would like to change one of my entries:

Raik -20
Sato +10
Butt +10

#29 Frank Booth

Frank Booth
  • Member

  • 796 posts
  • Joined: February 08

Posted 11 March 2008 - 14:47

Hopefully this portfolio will do better than my stocks are doing right now ;)


Räikkönen	   = 20

Hamilton		= 10

Massa		   = 20

Kovalainen	  = 10

Rosberg		 = 2

Alonso		  = 10

Heidfeld		= 10

Kubica		  = 10

Webber		  = 2

Nakajima		= 0

Coulthard	   = 2

Bourdais		= 2

Trulli		  = 0

Piquet		  = 0

Vettel		  = 2

Sutil		   = 0

Fisichella	  = 0

Glock		   = 0

Barrichello	 = 0

Button		  = 0

Davidson		= 0 

Sato			= 0



#30 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 11 March 2008 - 14:50

I change my entry a little too:
Raik -10
Mass +5
Alon +5

Driver data after the new entries and changes (including 96 shares for Frank Booth) :

[b]

DRIVER	  DShares   Race Season	VPP Owners[/b]

Räikkönen	   419   7.44 133.94	134	 18

Hamilton		297   5.27  94.94	190	 16

Massa		   297   5.27  94.94	190	 17

Kovalainen	  226   4.01  72.24	249	 16

Rosberg		 199   3.53  63.61	283	 14

Heidfeld		145   2.57  46.35	389	  8

Alonso		  125   2.21  39.95	451	 11

Kubica		  123   2.18  39.31	458	  9

Webber		   69   1.22  22.05	817	  7

Nakajima		 42   0.74  13.42   1343	  6

Coulthard		39   0.69  12.46   1447	  4

Bourdais		 32   0.56  10.22   1763	  5

Trulli		   31   0.55   9.90   1820	  5

Piquet		   29   0.51   9.27   1946	  3

Vettel		   27   0.47   8.63   2090	  3

Sutil			25   0.44   7.99   2257	  3

Button		   20   0.35   6.39   2821	  2

Fisichella	   18   0.31   5.75   3135	  4

Glock			13   0.23   4.15   4341	  2

Barrichello	  10   0.17   3.19   5643	  1

Sato			 10   0.17   3.19   5643	  1

Davidson		  0   0.00   0.00	N/A	  0
More entries are welcome!

#31 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 11 March 2008 - 14:54

Frank Booth, welcome to the game! Do note however that you can only have shares in no more than TEN drivers at a time! :)

Until you edit your entry (currently at 12 names), I'll not register the shares on Bourdais and Vettel as they are the last mentioned ones with the lowest number of shares.

#32 Frank Booth

Frank Booth
  • Member

  • 796 posts
  • Joined: February 08

Posted 11 March 2008 - 15:08

Changes made, sorry about that


Räikkönen	   = 20

Hamilton		= 10

Massa		   = 20

Kovalainen	  = 10

[b]Rosberg		 = 0[/b]

Alonso		  = 10

Heidfeld		= 10

Kubica		  = 10

[b]Webber		  = 0[/b]

Nakajima		= 0

[b]Coulthard	   = 0[/b]

[b]Bourdais		= 5[/b]

Trulli		  = 0

Piquet		  = 0

[b]Vettel		  = 5[/b]

Sutil		   = 0

Fisichella	  = 0

Glock		   = 0

Barrichello	 = 0

Button		  = 0

Davidson		= 0 

Sato			= 0



#33 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 11 March 2008 - 15:10

:up:

#34 an1res

an1res
  • Member

  • 508 posts
  • Joined: August 04

Posted 11 March 2008 - 16:55

Alonso 25
Raikkonen 5
Kubica 20
Kovalainen 5
Heidfeld 10
Webber 10
Nakajima 10
Trulli 5
Rosberg 5
Coulthard 5

#35 Crazy Canuck

Crazy Canuck
  • Member

  • 2,817 posts
  • Joined: December 00

Posted 11 March 2008 - 17:07

Coulthard 30
Webber 20
Alonso 20
Raikkonen 10
Hamilton 10
Vettle 10

#36 D82

D82
  • Member

  • 1,392 posts
  • Joined: April 01

Posted 11 March 2008 - 17:08

Hamilton		19

Raikkonen		14

Massa		14

Kovalainen		14

Kubica			11

Heidfeld		7

Vettel			6

Bourdais		5

Alonso			5

Piquet			5


#37 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 11 March 2008 - 18:34

That's eleven drivers, D82!

#38 D82

D82
  • Member

  • 1,392 posts
  • Joined: April 01

Posted 11 March 2008 - 19:42

Fixed now, thanks.

#39 Apex

Apex
  • Member

  • 2,419 posts
  • Joined: March 00

Posted 11 March 2008 - 19:58

Ok, time for a slight change:

Sutil -10
Alonso +5
Piquet +5

Which leads to:

Piquet 15
Vettel 10
Button 10
Barrichello 10
Alonso 15
Kovalainen 10
Glock 10
Trulli 10
Bourdais 10

Advertisement

#40 Crazy Canuck

Crazy Canuck
  • Member

  • 2,817 posts
  • Joined: December 00

Posted 11 March 2008 - 21:34

Originally posted by paranoik0
Small excel sheet I made to help keeping track of the changes in shares, and to simulate a race result:

http://rapidshare.co...olders.xls.html

To use it, just type into the grey cells, or choose the drivers from the dropdown menus.



Some of the formulas were jacked up....I've fixed it...can I email it to you or something?!?!

Also, I could not get the rounding to match with Makarias' numbers....I think he might round down or is formula is carying more decimals...

CC

#41 scheivlak

scheivlak
  • Member

  • 16,488 posts
  • Joined: August 01

Posted 11 March 2008 - 23:00

Hamilton 20
Alonso 20
Raikkonen 16
Kovalainen 14
Vettel 10
Webber 8
Nakajima 8
Fisichella 4

#42 Frank Booth

Frank Booth
  • Member

  • 796 posts
  • Joined: February 08

Posted 12 March 2008 - 11:21

Originally posted by Crazy Canuck



Some of the formulas were jacked up....I've fixed it...can I email it to you or something?!?!

Also, I could not get the rounding to match with Makarias' numbers....I think he might round down or is formula is carying more decimals...

CC


Could you e-mail it to me please

#43 noikeee

noikeee
  • Member

  • 23,218 posts
  • Joined: February 06

Posted 12 March 2008 - 13:43

Originally posted by Crazy Canuck



Some of the formulas were jacked up....I've fixed it...can I email it to you or something?!?!

Also, I could not get the rounding to match with Makarias' numbers....I think he might round down or is formula is carying more decimals...

CC


Yeah, I eventually noticed it as well and fixed it too - but getting the same problem as you, slight differences in rounding compared to Makarias' "official" table.

Here's my fix: http://rapidshare.co...olders.xls.html

#44 kNt

kNt
  • Member

  • 1,695 posts
  • Joined: February 05

Posted 12 March 2008 - 17:29

Kovalainen 40
Trulli 7
Heidfeld 15
Piquet 7
Nakajima 7
Vettel 6
Coulthard 6
Glock 6
Barrichello 6

Not really sure how the system will turn out, but it sounds nice.

#45 anandn

anandn
  • New Member

  • 8 posts
  • Joined: October 05

Posted 12 March 2008 - 17:58

Neat idea, here's what my portfolio reads:

ALO 20
HEI 20
KOV 15
MAS 15
KUB 10
RAI 10
WEB 5
ROS 2
VET 2
BUT 1

:up:

#46 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 12 March 2008 - 18:53

I've made another change to my entry, it is now:

Hamilton 30
Massa 21 (+6)
Alonso 20 (-5)
Räikkönen 10
Kubica 10
Webber 5
Trulli 2
Davidson 1 (+1)
Fisichella 1
Vettel 0 (-2)

I felt it worthwhile to get a share in Davidson as it right now gives me a monopoly on him...

#47 Makarias

Makarias
  • Member

  • 12,641 posts
  • Joined: December 98

Posted 12 March 2008 - 19:02

28 players now! Driver data after my entry changes:


[b]

DRIVER	  DShares   Race Season	VPP Owners[/b]

Räikkönen	   474   6.60 118.83	151	 23

Hamilton		346   4.81  86.74	207	 19

Massa		   332   4.62  83.23	216	 19

Kovalainen	  314   4.37  78.72	229	 21

Alonso		  215   2.99  53.90	334	 16

Rosberg		 204   2.84  51.14	352	 15

Heidfeld		197   2.74  49.39	365	 12

Kubica		  164   2.28  41.11	438	 12

Webber		  110   1.53  27.57	654	 10

Coulthard		78   1.08  19.55	922	  6

Nakajima		 67   0.93  16.79   1074	  9

Vettel		   64   0.89  16.04   1124	  8

Piquet		   46   0.64  11.53   1564	  5

Trulli		   43   0.59  10.78   1673	  7

Bourdais		 42   0.58  10.53   1713	  7

Fisichella	   22   0.30   5.51   3270	  5

Button		   21   0.29   5.26   3426	  3

Glock			19   0.26   4.76   3787	  3

Barrichello	  16   0.22   4.01   4497	  2

Sutil			15   0.20   3.76   4797	  2

Sato			 10   0.13   2.50   7196	  1

Davidson		  1   0.01   0.25  71960	  1
As for the VPP factor: it is strictly rounded off DOWNWARDS.

Note that Alapan has a monopoly on Sato so far, and the ten shares could just as well be just one (as I have on Ant!) and still deliver the same return as those ten would now in case Sato scores points.

#48 Barty

Barty
  • Member

  • 2,092 posts
  • Joined: August 03

Posted 12 March 2008 - 22:23

Sounds like fun, here is my bet:

Räikkönen 25
Hamilton 25
Kovalainen 20
Kubica 15
Vettel 10
Barrichello 3
Sato 2

#49 Crazy Canuck

Crazy Canuck
  • Member

  • 2,817 posts
  • Joined: December 00

Posted 13 March 2008 - 00:56

Originally posted by Makarias

As for the VPP factor: it is strictly rounded off DOWNWARDS.



Ok then, that means using round down function on excel cheat sheet! Thanks!

CC

#50 Crazy Canuck

Crazy Canuck
  • Member

  • 2,817 posts
  • Joined: December 00

Posted 13 March 2008 - 01:15

Sell
Webber (-10)
Vettle (-10)
Hamilton (-10)
Alonso (-10)
Raikkonen (-1)


Buy
Fisichella (+10)
Trulli (+10)
Massa (+10)
Heidfeld (+10)
Davidson (+1)


Current Portfolio
Coulthard 30
Alonso 10
Heidfeld 10
Webber 10
Massa 10
Fisichella 10
Trulli 10
Raikkonen 9
Davidson 1