Baseball Fixtures, Results and League Table

Hello,

I have created a spreadsheet that I am hoping to help support my brothers Baseball team. It includes fixtures for the full season, results so far and a league table for each of the 3 divisions.

So far I have managed to work out the COUNTIFS formulas for some of the league table but after trying everything possible from my own Excel knowledge, I am now asking for some support to finally get this finished at put to use.

Auto sort - I would love a formula, macro, code or whatever is needed to auto sort the league table positions based on the results that are entered onto the Fixtures and Results tab.

GB - Games Behind is a tricky one to explain but it is basically the Baseball version of Points and how you know which team is 1st, 2nd, 3rd etc. For whatever reason, when I tried to use the correct formula to work out the GB it only worked hosting the formula on a separate sheet (References) and then just referencing the cell on the League Table.

L10 - Just a W/L streak from last 10 games e.g. "W10 - L4"

STK - Current streak. This must actuall be a streak so can't be a combination of wins and losses. Must be whatever their current streak is before the chain is broken, i.e. W4, L1, W7, L4 etc.

Last Game - Previous fixture with result.

Next Game - Next fixture.

I have attached the document for any of you experts to have a go and any help would be hugely appreciated! I have also attached an image of the MLB League Table so you can see examples of the missing fields.

Much appreciated!
Craig

Thanks for you help,

I appreciate everyone's input is in kind and I certainly didn't expect someone to just pick it up and finish it for me.

I just thought people would comment with suggestions to try for various parts.

I'm new to this forum as of today so wasn't sure what's usually posted etc.

Cheers again!

Well I like baseball so I was interested in this project

But what does P mean for a score? Postponed game?

Yeh the P means the game was rained off basically. My brother has set a team up in Newcastle and they will be joining the A Division next season. How did you manage to get the auto sort to work?

I know the STK and L10 is going to be a struggle but is the Last Game and Next Game possible do you think? My family are big St. Louis fans but my sport is Ice Hockey. We're basically fake Americans lol...

Thanks again for your help with this

The autosort is implemented in VBA code.

I also added two functions that return the last game results, and next game scheduled. See attached.

Originally Posted by davo3286

...my sport is Ice Hockey.

I will be watching my team, the Washington Capitals, play for the Stanley Cup tonight against Las Vegas. Caps lead 3-1 so they could win the championship tonight.

I really do appreciate your help on this a great deal!.. You will also be glad to hear that I am a HUGE Pens fan so you have well and truly crushed our hopes of a 3rd consecutive title!... I would usually support the team who knocked us out so it doesn't look so bad but Fleury, Neal, Engelland etc. makes it hard for me not to support the Knights!...

I think this update covers everything. I ended up solving everything with macros. It might be possible with formulas.

This code will export a JPG of your standings:

Please Login or Register  to view this content.

Here's the very nearly finished version with the exception of:

JPEG export not working (could be my computer at fault).
The 'Last Game' doesn't appear to be giving correct information because it has a result from AAA vs. A which doesn't happen in this league
I have added some conditional formatting to the 'Fixtures and Results' tab and updated the coding to replicate the new cell layout and everything that was working before I moved the cells around now seems to be back working again.

Really happy with this now, cheers!

I'm looking at the JPEG export, not sure yet what's wrong.

You have a lot of interleague games marked as "IL". For example, in row 124 of Fixtures and Results you have AAA vs A:

6/10/2018 10 IL 2 Manchester A's - - - Robots of Doom


You can't attach files to a PM, just keep using this thread.