View Single Post
  #38   Spotlight this post!  
Unread 25-03-2013, 08:36
DELurker DELurker is offline
Former Engineering Mentor
AKA: William Lydick
no team (n/a)
 
Join Date: Mar 2011
Rookie Year: 2011
Location: Delaware, US
Posts: 268
DELurker has a brilliant futureDELurker has a brilliant futureDELurker has a brilliant futureDELurker has a brilliant futureDELurker has a brilliant futureDELurker has a brilliant futureDELurker has a brilliant futureDELurker has a brilliant futureDELurker has a brilliant futureDELurker has a brilliant futureDELurker has a brilliant future
Re: OPR after Week Three Events

Quote:
Originally Posted by Ed Law View Post
I put in those conditional formatting back in 2008 and never took it out. Basically, when OPR is bigger than average score, or CCWM is bigger than average winning margin, it will turn green. Green is good. It means those teams contribute more than their partners to get the average score. Somebody with a lucky schedule can have very high average score but OPR/CCWM which are the calculated contribution will tell you the true story in most cases. If you only look at OPR/CCWM and ignore average score and average winning margin, the green color does not add any information.

I am surprised nobody has ever asked this question. I can take it out in the future.
Please don't. If nobody has ever asked, then they weren't using it. Our team, on the other hand, is probably going to use the heck out of it in our upcoming District Event.

Thank you, Ed, for what is looking like a truly wonderful tool.
__________________
----------------------------------------------
With 1370 --
2012 Rutgers District Event Champions with 1676/56
2012 Lenape District Event Finalists with 2191/1691

2013 TCNJ District Event QuarterFinalists with 1143/4750, Gracious Professionalism Award
2013 Bridgewater-Raritan District Event Semi-Finalists with 4285/223
2013 MAR Championship Finalists (Backup) with 222/11/1403; Gracious Professionalism Award
Reply With Quote