OPR after Week Three Events

[ahartnet]

Ed,

First off, this is an impressive collection of VBA scripts!

Second - when I try to run the refresh data script, I get an error, something about runtime error ' 13' Type mismatch.

I opened v3.0, go to the Dallas page, as thats the one I'm interested in, and make sure that I enable macros and a data connection. When I hit ctrl-shift-P it starts doing a lot of stuff but then stops at that error. When I run the step into the command and do it line by line, it seems it's because it's going through the teams list (which is blank at the time) until it hits the word "match" in C353.

Any tips? Am I missing a step? I don't see anything else suggested in the instructions page.

Thanks!
Andrew

[Ed Law]

Originally Posted by ahartnet

Ed,

First off, this is an impressive collection of VBA scripts!

Second - when I try to run the refresh data script, I get an error, something about runtime error ' 13' Type mismatch.

I opened v3.0, go to the Dallas page, as thats the one I'm interested in, and make sure that I enable macros and a data connection. When I hit ctrl-shift-P it starts doing a lot of stuff but then stops at that error. When I run the step into the command and do it line by line, it seems it's because it's going through the teams list (which is blank at the time) until it hits the word "match" in C353.

Any tips? Am I missing a step? I don't see anything else suggested in the instructions page.

Thanks!
Andrew

I am not sure what you are trying to do. While this can be used as a predictive tool in terms of match results, projected ranking at the end of qualifying round etc., it needs data to start. It is not that good a predictive tool when the match schedule has not come out yet. Try to run the macro again after each team has at least played 3 matches. Otherwise you may get an error saying insufficient data or something like that due to the ill condition of the matrix. For the OPR numbers to be meaningful, you need at least 4 to 5 matches completed for each team. I think some people have done that study so others please chime in.