OzGrid Free Excel/VBA Help Forum

DC_Indy

Just had a quick look for you at the file ...

1. Do you have a definition for Strength of Schedule and Opponent's Strength of Schedule ?

2. More importantly, do you have a Formula and a Calculation Method ?

See other thread :

RE: Calculate Opponents Record and Strength of Schedule

DC_Indy

For sure, you have noticed this thread is well over 10 Year Old ....

Would be much safer to consider starting all over from scratch ...

[…]

How much to figure out a Formula to calculate M& N????? I've come to a halt. Creator did a great job and been using the spreadsheet for a while. Still trying to figure out those two columns though.

[…]

Did you ever get to figuring out M & N????? I'd love to know the solution. Excel formula would be excellent.

[…]

This URL seems to be broken. Could you possibly send it again. I am using the spreadsheet from above and the OS and SS columns are my problem spot right now.

Re: Calculate Opponents Record and Strength of Schedule

Hey frisbie17, I run a league on excel and have found that the best way to get opponent's SOS is to work with a cross-referenced worksheet that aggregates the data. Have the wins and losses posted to…

I am not sure the best way to approach this. I was thinking of doing it through functions but a VBA script may work best. Any guidence on how to accomplish these two tasks are greatly appreaciated.

I have a spreadsheet I have created to calculate…

Re: Calculate Opponents Record and Strength of Schedule

Posted here

Hi,

Revised macro below :
(Code, 18 lines)