Small or Far Away, Father Dougal on Cows
At last we have enough weeks of data to make running the numbers worthwhile!
That’s a lie. You just needed to see them yourself.
Yes, well, if I feel a need to see them, then other people do to. At this point we are short data as far as performance, but we can at least do some projections so we can guess at how may or may not be worth keeping. It is early for trading, but, well, can’t hurt to have the numbers can it?
Assuming anyone can understand all those numbers.
Yes, well, I’m gonna take a shot at explaining.
Week – The weeks the player has played. To avoid the huge pain in the you-know-where from trying to put in blanks when a player misses, I just skip that week. If you look at Hore or Balta you can see how that works.
Score – Scores with a gray background have already happened. Scores without a gray background are the player’s current average which are used for the projections.
Price – The player’s price at the start of that week. Prices with a gray background have already happened. Prices without a gray background are the player’s projected prices based on their past scoring, with future scoring at their current average.
Proj. Change – How much a player’s price is projected to change, week by week. Only show for future weeks.
Total Proj. – All the weekly projected changes added together. How much he “will” make if sold that week.
Time/Cash Value – I need a better name for this. Please feel free to make suggestions in the comments. So, last season I wrote about Cowpound interest.
To sum up, the sooner you spend money the sooner it makes you points. So, it may be worth taking less money sooner, if you can spend it. Time/Cash Value is the Total Proj. * the number of (playing) weeks left in the season. On playing round 22 this is zero, since I am an idiot, and just realized I am a week off in how I made the spreadsheet. It should be 1* the amount of money you get on the last week, not zero. Ok, so I will fix that for next week’s post. The idea is you can tell how much use you get from the money now vs later if you are able to spend it.
Change – The change in the Time/Cash Value week to week. High is good, negative is bad.
Extracted Time/Cash Value – Also off by a week. Obscene-gerund overly-warm-afterlife-place. Anyways, this is (the player’s price – 123,900 ) * the number of weeks left to play. If you are upgrading the player this does not matter. If you are downgrading, the player, then it gives you an idea of what he is worth over time, taking the downgrade target’s cost into account. Assuming the downgrade target costs 123,900. I need a better name for this field too.
Change – The change in the Extracted Time/Cash Value week to week. High is good, negative is bad. And yes, two columns named change. I am sure you can cope. Pro-tip, the change columns apply to the column directly to their left.
So, numbers below, that’s it for…
How about the write-ups?
Um, (looks embarrassed)
Are you going to do player by player write-ups this week? You usually do those every week.
(small voice) No…
And why not?
Because I forgot how long it took to get the first Cow Talk spreadsheet and post of the year up, and I ran out of time.
And why did you forget that?
Hysterical Cow Talk Blindness! It’s like a defense mechanism where my brain can’t handle the horrors of getting all the numbers and stuff together at the start of the season, so it forgets so the memory of it doesn’t stop me from doing it again next season.
Well, I would do it if I remembered, but still. And then I found out the when I cut from Google Docs I can’t paste into an image which I need to upload since the player data overflows the screen. And I had put it all into Open Office and then reformat it all since the paste lost all that, and it took a while.
You could have just used the snip tool to take captures of the Google Docs and saved yourself a lot of time.
….I…NOW you tell me?
Well, that’s all for this week’s Cow Talk. Pardon me while I chase down my Imaginary Interlocutor. He can run but he can’t hide!
Bailey Smith –
Thanks for Reading!
Leave a comment / Scroll to bottom