Chief Delphi
Page 2 of 2 < 1 2
Show 100 post(s) from this thread on one page

Chief Delphi (http://www.chiefdelphi.com/forums/index.php)
-   General Forum (http://www.chiefdelphi.com/forums/forumdisplay.php?f=16)
-   -   2013 Championship OPR/CCWM spreadsheet (http://www.chiefdelphi.com/forums/showthread.php?t=116243)

Ed Law 28-04-2013 16:44
Re: 2013 Championship OPR/CCWM spreadsheet
 
I transferred the wrong data into the database and messed up the whole thing. It took a while to regenerate everything. Version 4 is now posted. If you find any other problem, please let me know.

AllenGregoryIV 21-05-2013 04:14
Re: 2013 Championship OPR/CCWM spreadsheet
 
Ed, I was messing the spreadsheet and your macro for calculating OPR results wasn't allowing championship results as a Max event for a team even though they were listed on that page.

The macro was starting the range at M4 instead of I4.

It should read "Range("I4").Select", to allow for the 4 division OPRs to be included. I'm not sure if it was a choice or an error but I just found it odd.

Ed Law 21-05-2013 11:32
Re: 2013 Championship OPR/CCWM spreadsheet
 
Quote:
Originally Posted by AllenGregoryIV (Post 1276361)
Ed, I was messing the spreadsheet and your macro for calculating OPR results wasn't allowing championship results as a Max event for a team even though they were listed on that page.

The macro was starting the range at M4 instead of I4.

It should read "Range("I4").Select", to allow for the 4 division OPRs to be included. I'm not sure if it was a choice or an error but I just found it odd.
It was by choice for a number of reasons. That's how I did it the previous years also. However you are welcome to change the formula to fit your need.


All times are GMT -5. The time now is 04:51.
Page 2 of 2 < 1 2
Show 100 post(s) from this thread on one page

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright © Chief Delphi