Playoff formula calculations

[STLFTBL]

Does anyone have a program that can calculate what the final playoff seedings are going to be? I tried to do it on Excel but I can not get it to match the score from the MSHSAA site? Trying to see if Blue Springs South can catch Francis Howell for the top seed.

 

[HoldMyTrophy]

Does anyone have a program that can calculate what the final playoff seedings are going to be? I tried to do it on Excel but I can not get it to match the score from the MSHSAA site? Trying to see if Blue Springs South can catch Francis Howell for the top seed.

I have this built in a spreadsheet. I plugged in the two teams you are asking about. You could be struggling to get the numbers to match MSHSAA because two opponents of BSS have lost in overtime this year, which actually adds fractions of a point to the Strength of Schedule portion of the formula.

Yes, BSS could pass Francis Howell this week. Francis Howell has a bye from what I see on the MSHSAA website. They are currently at 47.00 but they could finish between 46.49 (if all 8 of their opponents lose in week 9) to a high of 47.76 (if all 8 of their 2015 opponents win in week 9). And, their overall total points could shift slightly if one of their opponents loses in overtime, not just in regulation.

BSS in the meantime, currently at 46.54, could finish as high as 50.47 if they beat Lee’s Summit by 13 or more and Park Hill, Liberty North, Rockhurst and Raytown all win this week. What would it take for BSS to finish over 47.76 that is more reasonable perhaps? Well, even if Park Hill, Liberty North, Rockhurst and Raytown all lost this week, and if BSS wins by only 1 point, they still would have a 48.42.

In summary, it appears to me if BSS wins, they get the first seed over Francis Howell.

(all according to my calculations)

 

[STLFTBL]

I have this built in a spreadsheet. I plugged in the two teams you are asking about. You could be struggling to get the numbers to match MSHSAA because two opponents of BSS have lost in overtime this year, which actually adds fractions of a point to the Strength of Schedule portion of the formula.

Yes, BSS could pass Francis Howell this week. Francis Howell has a bye from what I see on the MSHSAA website. They are currently at 47.00 but they could finish between 46.49 (if all 8 of their opponents lose in week 9) to a high of 47.76 (if all 8 of their 2015 opponents win in week 9). And, their overall total points could shift slightly if one of their opponents loses in overtime, not just in regulation.

BSS in the meantime, currently at 46.54, could finish as high as 50.47 if they beat Lee’s Summit by 13 or more and Park Hill, Liberty North, Rockhurst and Raytown all win this week. What would it take for BSS to finish over 47.76 that is more reasonable perhaps? Well, even if Park Hill, Liberty North, Rockhurst and Raytown all lost this week, and if BSS wins by only 1 point, they still would have a 48.42.

In summary, it appears to me if BSS wins, they get the first seed over Francis Howell.

(all according to my calculations)

I have this built in a spreadsheet. I plugged in the two teams you are asking about. You could be struggling to get the numbers to match MSHSAA because two opponents of BSS have lost in overtime this year, which actually adds fractions of a point to the Strength of Schedule portion of the formula.

Yes, BSS could pass Francis Howell this week. Francis Howell has a bye from what I see on the MSHSAA website. They are currently at 47.00 but they could finish between 46.49 (if all 8 of their opponents lose in week 9) to a high of 47.76 (if all 8 of their 2015 opponents win in week 9). And, their overall total points could shift slightly if one of their opponents loses in overtime, not just in regulation.

BSS in the meantime, currently at 46.54, could finish as high as 50.47 if they beat Lee’s Summit by 13 or more and Park Hill, Liberty North, Rockhurst and Raytown all win this week. What would it take for BSS to finish over 47.76 that is more reasonable perhaps? Well, even if Park Hill, Liberty North, Rockhurst and Raytown all lost this week, and if BSS wins by only 1 point, they still would have a 48.42.

In summary, it appears to me if BSS wins, they get the first seed over Francis Howell.

(all according to my calculations)

 

[STLFTBL]

Can I get a copy of this spreadsheet?

 

[HoldMyTrophy]

If you want to provide an email I would share it. You could see how it works but you still have to plug in results of course. I haven't asked mshsaa if they would provide an interface to their database for us to use. (Haha). So I have to update records/results manually. But then it's fun to plug in the what ifs.

 

[STLFTBL]

My email: galmus12@sbcglobal.net. Thanks!!!

 

[Coach_33]

Can you send me that spreadsheet too! ljackson2351@gmail.com

 

[greenergrass]

Thanks for doing all that work. It helps a lot. We are thinking that we still have the possibility of playing three different schools. This could really help and not waste time and travel.

Thanks again

dkjmarshall@yahoo.com

 

[HoldMyTrophy]

I've sent the three of you the spreadsheet via email.

 

[field_general]

I've sent the three of you the spreadsheet via email.

 

[field_general]

gengem@grandviewr2.org If you don't mind.

 

[O line wins games]

toiletguy77@yahoo.com please. Id appreciate it

 

[HoldMyTrophy]

Have tried to get this to all of you today, but toiletguy77 was rejected and went straight to the crapper it appears.

 

[eastbucdawgs]

I wouldn't mind a copy as well. bstallard@gmail.com

 

[O line wins games]

Oh ya that's right.. falconsbulldogs37@yahoo.com please