DT Spreadsheet

[nick1408]

I found 2 different ones mate!!

((((Players Total of Last Three Rounds) / 3) x 3660) - Current Players Price) x 3/11) + Current Players Price

and

symbols:
a=player score 2 rounds previous
b=player score 1 round previous
c=breakeven score for current round
p=current player value
*=x (multiplied)

c (breakeven)
=(-1220*(a)-1220*(b)+p)/1220

you can put that formula into excel, change the symbols (except * of course) and calculate the breakeven for any player.

so for Bartel

=SUM(-1220*(114)-1220*(132)+480200)/1220

= 147.6


i don't know if either are right though!

Where does the 1220 come from?

[Prospector_1]

1220 = 3660/3

[Paddy13]

1220 = 3660/3

:P

[nick1408]

and what is the 3360 for?  Is this supposed to be the magic number?  I thought it was 4396

[Prospector_1]

3660 = 3x1220

[nick1408]

why is 3660 important though?  I know it is probably obvious but I cannot see it

[Prospector_1]

It's the magic number.

[Paddy13]

NICK!
ive worked it out!

for our formula to correspond with fanfooty's break evens, we need to change the magic number in the top left corner of 'financial and breakeven' to

4125!!

That makes them all exactly the same as on fanfooty!!

:) :P :)

[Prospector_1]

Well done Paddy!

[Paddy13]

thanks prospector!

[nick1408]

Therrs Paddy.  I sort of considered it as the magic number but just wanted confirmation.

Here's a question: how is the magic number worked out each week?

[Prospector_1]

Here's a question: how is the magic number worked out each week?

Should be fixed for the year now.

[Master Q]

You guys make a great team, so is the sheet finished?

[nick1408]

I know mine is.  There are instructions on the sheet for editing if you wish to

[Master Q]

I mean is there no more faults, everything good to go? ;)