[Albion] To Avoid Potter Bashing - the staying up tracker - season 2019-2020 Game 38 UPDATE

[SollysLeftFoot]

Giraffe, I'm really sorry but on the 29th Feb, can you select the cell and then select ignore error.

It's really bothering me..

 

[FatSuperman]

But Giraffe's tracker is utterly pointless in that it doesn't matter how many points we have after 1,5,10,15 games. It's what we have after 38 that is the ONLY sensible measure. If we have 38, then the chances are we will stay up.

Simple.

[MENTION=118]Hiney[/MENTION] Please would you lock [MENTION=118]Hiney[/MENTION] out of this thread until May 17th?

 

[FatSuperman]

Hi all,

So frustrated with Giraffe being LAZY in getting this tracker properly prepared with all of the requests. Please find updated view below. Tracker will be updated every quarter hour until 9th August, at which point it will be left until the start of next season. Regards.

 

[SollysLeftFoot]

Hi all,

So frustrated with Giraffe being LAZY in getting this tracker properly prepared with all of the requests. Please find updated view below. Tracker will be updated every quarter hour until 9th August, at which point it will be left until the start of next season. Regards.

View attachment 111469
View attachment 111470

Spreadsheet porn. Just need some slick VBA skills to automate it to take it the next level.

 

[MattBackHome]

Hark at the newboy getting all ahead of himself.

You've only been on here for 16 years - you need to do your time before you start chipping in with stuff like this.

Oi - I was here when you had to type your username in every time you posted I'll have you know. My 'Ants' thread was quite the revelation back in the last millennium.

My tracker is going to blow your mind..

 

[MattBackHome]

Hi all,

So frustrated with Giraffe being LAZY in getting this tracker properly prepared with all of the requests. Please find updated view below. Tracker will be updated every quarter hour until 9th August, at which point it will be left until the start of next season. Regards.

Finally, someone is taking this seriously.

 

[FatSuperman]

Finally, someone is taking this seriously.

There is room for at least 30 more categories. The more categories, the more complaints we'll have. It needs to be a monster to truly bring them all out of their corners.

 

[MattBackHome]

Here's mine.

I've taken [MENTION=3734]Giraffe[/MENTION]'s idea and tweaked it, by adding in a few more factors to decide which games are '3 pointers' and which are '1 pointers', namely:

- Using 'How many points were won against each team' as the starting barometer of how hard they are to get points off
- Splitting the above by home/away performance
- Looking at how many points are generally achieved H vs A
- Using these to rank the 19/20 fixtures in order of both difficulty & how many points we should be getting

Et voila the below. Feast your eyes on it's magnificence.




I think our start is more forgiving. The main model has us picking up points at Watford and Newcastle (I've modelled nothing here) and a winning start at home to West Ham (I've got a draw). Obviously we all end up at the same 40 point mark, but it will be interesting - for me, at least - to see which line stays closer to the actual truth.

 

[Garry Nelson's Left Foot]

Here's mine.

I've taken [MENTION=3734]Giraffe[/MENTION]'s idea and tweaked it, by adding in a few more factors to decide which games are '3 pointers' and which are '1 pointers', namely:

- Using 'How many points were won against each team' as the starting barometer of how hard they are to get points off
- Splitting the above by home/away performance
- Looking at how many points are generally achieved H vs A
- Using these to rank the 19/20 fixtures in order of both difficulty & how many points we should be getting

Et voila the below. Feast your eyes on it's magnificence.

View attachment 111475
View attachment 111476

I think our start is more forgiving. The main model has us picking up points at Watford and Newcastle (I've modelled nothing here) and a winning start at home to West Ham (I've got a draw). Obviously we all end up at the same 40 point mark, but it will be interesting - for me, at least - to see which line stays closer to the actual truth.

hehe, it says cum. hehehe.

 

[FatSuperman]

hehe, it says cum. hehehe.

"That table has actual cum on it"

 

[Giraffe]

Giraffe, I'm really sorry but on the 29th Feb, can you select the cell and then select ignore error.

It's really bothering me..

Done

 

[Giraffe]

hehe, it says cum. hehehe.

"That table has actual cum on it"

Mine has 3 lots of cum on it. A cum hat trick.

 

[Giraffe]

Here's mine.

I've taken [MENTION=3734]Giraffe[/MENTION]'s idea and tweaked it, by adding in a few more factors to decide which games are '3 pointers' and which are '1 pointers', namely:

- Using 'How many points were won against each team' as the starting barometer of how hard they are to get points off
- Splitting the above by home/away performance
- Looking at how many points are generally achieved H vs A
- Using these to rank the 19/20 fixtures in order of both difficulty & how many points we should be getting

Et voila the below. Feast your eyes on it's magnificence.

View attachment 111475
View attachment 111476

I think our start is more forgiving. The main model has us picking up points at Watford and Newcastle (I've modelled nothing here) and a winning start at home to West Ham (I've got a draw). Obviously we all end up at the same 40 point mark, but it will be interesting - for me, at least - to see which line stays closer to the actual truth.

Looks good, and interesting that it makes little difference to the graphed outcome. What have you done with the promoted teams?

 

[Goldstone1976]

Hi all,

So frustrated with Giraffe being LAZY in getting this tracker properly prepared with all of the requests. Please find updated view below. Tracker will be updated every quarter hour until 9th August, at which point it will be left until the start of next season. Regards.

View attachment 111469
View attachment 111470

Hmm.

11 forecast columns, but only 1 variance column??

Was gibts?

 

[MattBackHome]

Looks good, and interesting that it makes little difference to the graphed outcome. What have you done with the promoted teams?

I just swapped them out on a finishing position basis but appreciate that's a bit crude.

Sent from my STF-L09 using Tapatalk

 

[FatSuperman]

Hmm.

11 forecast columns, but only 1 variance column??

Was gibts?

A shocking omission. I was more concerned with making up measures than anything else. I hang my head in shame.

On the promoted/relegated teams for previous seasons, I replaced them based on proximity, sort of.

 

[super-seagulls]

Hi all,

So frustrated with Giraffe being LAZY in getting this tracker properly prepared with all of the requests. Please find updated view below. Tracker will be updated every quarter hour until 9th August, at which point it will be left until the start of next season. Regards.

View attachment 111469
View attachment 111470

You have been lazy though, haven’t you?
The lines with the lowest ever and highest ever safety target do not follow the respective teams results throughout the seasons.
You have simply ‘thimble flat-lined’ your way to the end of season totals.
Poor.

 

[Westdene Seagull]

A cum hat trick.

In your dreams !

 

[schmunk]

A cum hat trick.

And it was Dry Clean Only.

For shame.

 

[GT49er]

Here we are on Matchday One (or 'Gameday' as Talkshite are trying to get us to call it now! ), so welcome back Giraffe's tracker (and can all the other ones sod off now that the serious stuff is beginning!)