OzGrid Free Excel/VBA Help Forum
The best online resource for all your Excel & VBA requirements
Recent Activities
-
Carim
Replied to the thread Calculate Opponents Record and Strength of Schedule.PostDC_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 ? -
Carim
Replied to the thread Oponents win and losses and Strength of Schedule $30.Post -
Carim
Replied to the thread Calculate Opponents Record and Strength of Schedule.PostDC_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 ... -
DC_Indy
Replied to the thread Oponents win and losses and Strength of Schedule $30.Post[…]
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. -
DC_Indy
Replied to the thread Oponents win and losses and Strength of Schedule $30.Post[…]
Did you ever get to figuring out M & N????? I'd love to know the solution. Excel formula would be excellent. -
DC_Indy
Replied to the thread Calculate Opponents Record and Strength of Schedule.Post[…]
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. -
DC_Indy
Reacted withReaction (Post)to pgrickswim’s post in the thread Calculate Opponents Record and Strength of Schedule.
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… -
DC_Indy
Reaction (Post)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… -
DC_Indy
Reaction (Post) -
Carim
Replied to the thread Copy rows from one sheet to another based on match.PostHi,
Revised macro below :
(Code, 18 lines)