Player Value Changes Spreadsheet

[Decipher]

http://www.decipherthis.net/Dreamteam/


Refer to each Round for the Spreadsheet or PDF file.
Files are generally available Monday afternoon.

I take no responsibility for the Excel file, so it may be worthwhile scanning it before you run it to ensure nobody has tampered with the file.

 

[senrulzisback]

Nice work, without FFGenie working atm, this should be great.

EDIT: It isn't working.

 

[Decipher]

Did you right click and "Save target as"?
Did the file open? Care to Explain what isnt working?

 

[Thorgils]

Nice work D

 

[Conan Troutman]

Worked for me no problems. Cheers man, nice job.

 

[tuzz]

some feedback, I'm on office 2003 and it has problems with the nesting in the Rolling Average cells, this is this message I get on opening the file:

"- Some formulas have more levels of nesting than are allowed in this version of Excel. Formulas with more than seven levels of nesting will not be opened and will be converted to #VALUE! errors."

otherwise the spreadsheet is great, good work

 

[Decipher]

Yeah sorry.
To get a rolling average I needing to smash the cell with a fairly sizeable formula.
Im not sure how to do it without such a large formula due to some players not playing specific rounds making it difficult (e.g. rolling average might be round 1,3 and 6).

Office 2007 allows for larger formula's and spreadsheets to be used.
Im considering throwing all the players into the spreadsheet organising it into teams and PDFing it for those without Office 2007

 

[senrulzisback]

Nah sorry I didnt do that.

Cheers, it looks great.

 

[Decipher]

Ok,

I have had a number of PM's and a little motivation.
I realised Freako's Email has come out for the week so it may be less useful now however I will throw it out regardless. As per before I offer you the full spreadsheet with every player who was involved in Round 1. The link is in my first post. Please 'Save target As' on the spreadsheet and also as pointed out you will need Office 2007 as it does contain some large formula's.

For those without Office 2007 I have attached a PDF. I guess it is in a comparable format to that used by Freako but please dont compare them as mine has been put together in just a couple of hours. It does differ in it shows expected peak prices, breakeven scores and expected third round price increases. It does not include TOG %. If you want this you should refer to Freako's Email. All the information on this PDF is available on the Excel spreadsheet.
I have even included the Pivot table I used for the first page. This is sorted by Breakeven so you simply select the area (FWD, MID or DEF) and up comes the players with the lowest breakeven in order.

If you find any problems or have any suggestions please let me know. I have also thrown in my 2c. Cheers everyone for the PM's and support.

 

[Decipher]

Updated again.

Fixed the breakeven formula.

 

[Pure_Ownage]

Thanks mate this is fantastic

 

[Johnson#26]

You're a champ, a big help, much needed. Thank you.

 

[BigVic]

Thanks alot. Where's the SuperCoach version?

 

[1 Million]

Just wondering if you could add in what round the peak prices would be hit Cheers

 

[Dunn - Well Done]

So what is J.Browns BE for this week and how much will he rise if he scores X amount?

 

[Jolldo87]

So what is J.Browns BE for this week and how much will he rise if he scores X amount?

If he scores X points he should rise by Y thousand dollars.

Seriously, if he scores 95 he will go up around $20,000 according to Too Serious.

 

[Decipher]

So what is J.Browns BE for this week and how much will he rise if he scores X amount?

Per the spreadsheet his breakeven is around 36
If he scores around 140 (current avg) he should rise approximately $35k next round.

1 Million - No point trying to work out what round they will 'peak' as its likely to change depending on future scores. I will add a column to let you know what players have reached their peak and leave it at that (When the Breakeven exceeds their average and the average of their last 2 scores, most people consider them peaked). This column will be in next weeks version available Monday night or Mid Tuesday.

Im not planning on creating one for SuperCoach either sorry.

 

[Vigour]

excellent work D, keep it going!

 

[paddy13]

LOVE IT MATE!

just a couple of things,

it wont llet me select r warnock,
and
it lobbe isnt on the list!!

This is AWESOME THOUGH!!

 

[Decipher]

Has Lobbe played a game yet?
If he hasnt theres nothing to report on him and he wont be in the spreadsheet.

I believe Trengove has taken that spot at port.

Also make sure you are getting the Round 2 file. I see R Warnock in both the spreadsheet and the PDF? How can you not 'select' him?

Working fine at home and on my work PC. Even had a mate try next to me and it works fine for him?

 

[Decipher]

Round 3 Spreadsheet is Now Available.
PDF will be up later today

 

[Decipher]

PDF is now uploaded and available.

http://www.decipherthis.net/Dreamteam/Rnd3/

 

[Decipher]

If anyone is having difficultly with the spreadsheet downloading as a 'zip' file.
Please just save the file on your computer and simply rename the file from Dreamteam_Rnd3.zip to Dreamteam_Rnd3.xlsx
I have no idea why my hosting changes the file but it occasionally does.
Do not try and unzip it as it will not work.

 

[paddy13]

what does the P, V etc mean in column D??