spreadsheet question

[jaydoggie]

Earlier today I was curious to find out how much I netted yesterday, and how much NET i had today.
I thought the best way to do this would be to go into the stats tab, scroll below the "average user should feel content to disregard" line to the date by date stats. I scroll to Feb 7th, and in the "NET" coloumn it tells me I netted 90.00. This number seemed inaccurate to me, so I did the calculations by hand.
10+1 SNGs on 'stars.
30 tournaments 30*11=330
4 1sts 4*45=180
4 2nds 4*27=108
5 3rds 5*18=90

378-330= 48 is the correct profit.

however my overall stats are correct, and overall profits are correct. am i missing something? am i reading this wrong?

[jaydoggie]

no one?

[bookish]

Its because the spreadsheet assumes there are 10 people at the table, and stars play with 9. Consequently the calculation made assumes 1/2/3 prizes of 50/30/20 not 45/27/18.

The rest of the spreadsheet seems to be OK (look at the stats below row 457 ...)

[sofere]

I also had problems with that...In addition to assuming there were 10 people. Check the payout calculation in the "disregard" section...If i remember correctly it took your 1st place finishes *5, 2nd place *3, 3rd place *2, instead of multiplying it by the gross payout.

Should be linked to payout for 1st (buy-in*players*%payout), payout for 2nd, payout for 3rd.

[jaydoggie]

I did set the players to 9 the payout does calculate 45/27/18. however that isnt what im talking about

[bookish]

The part of the spreadsheet the you complained about, does not alter its calculations according to the number of players at the table. Other parts do.