derekp1999 help with your spreadsheet odds
- MuleyMadness
- Site Admin
- Posts: 9997
- Joined: Thu Oct 10, 2002 9:34 pm
- Location: St. George, UT
- Contact:
derekp1999 help with your spreadsheet odds
Derek,
Help please, I plugged in my points into your spreadsheet (which is AWESOME) I might by the way.
However I can't get the drop down menus (white boxes) to work? So thus I can't filter any further.
Any ideas why? I'm a MAC user, downloaded your spreadsheet the bonus points all calculate correctly just
can't get any of the other menu features to work. Just wondering if you might know why?
Help please, I plugged in my points into your spreadsheet (which is AWESOME) I might by the way.
However I can't get the drop down menus (white boxes) to work? So thus I can't filter any further.
Any ideas why? I'm a MAC user, downloaded your spreadsheet the bonus points all calculate correctly just
can't get any of the other menu features to work. Just wondering if you might know why?
- derekp1999
- 4 point
- Posts: 646
- Joined: Fri Oct 08, 2010 2:09 pm
- Location: Clinton, UT
- Contact:
Re: derekp1999 help with your spreadsheet odds
I've been having problems with the filter menus not working when I protect the sheet & I haven't been able to figure it out entirely (I'm a spreadsheet nerd... but not big enough to figure this stuff out!). I have unprotected all the spreadsheets and it should be good to go now, go ahead and re-download (I downloaded one myself and all the filtering works).
One addition this year is the red & green "streetlight" icons. If the icon is red it tells me that my prediction for 2012 was low compared to the bonus points groups that actually drew the bonus tags, and if the icon is green my prediction last year was higher than what actually occurred. So if the light is green I'm pretty confident that my prediction for 2013 is good, but if the light is red it may take one additional point to draw.
One addition this year is the red & green "streetlight" icons. If the icon is red it tells me that my prediction for 2012 was low compared to the bonus points groups that actually drew the bonus tags, and if the icon is green my prediction last year was higher than what actually occurred. So if the light is green I'm pretty confident that my prediction for 2013 is good, but if the light is red it may take one additional point to draw.
“The consequences of our actions are always so complicated, so diverse, that predicting the future is a very difficult business indeed.”
-Albus Dumbledore
-Albus Dumbledore
- MuleyMadness
- Site Admin
- Posts: 9997
- Joined: Thu Oct 10, 2002 9:34 pm
- Location: St. George, UT
- Contact:
Re: derekp1999 help with your spreadsheet odds
Many thanks Derek, worked great!
-
- Spike
- Posts: 113
- Joined: Thu Aug 12, 2010 1:47 pm
Re: derekp1999 help with your spreadsheet odds
Where can I find this spread sheet I wanna try it
- derekp1999
- 4 point
- Posts: 646
- Joined: Fri Oct 08, 2010 2:09 pm
- Location: Clinton, UT
- Contact:
Re: derekp1999 help with your spreadsheet odds
Click the litte icon under my profile picture & it'll take you to my Blogspot page. The links to the resident spreadsheets are on the right sidebar of the site. I don't have the non-res stuff updated and likely won't have time before the draw closes to get those up & functional... sorry non-res guys but we'll shoot for next year.
“The consequences of our actions are always so complicated, so diverse, that predicting the future is a very difficult business indeed.”
-Albus Dumbledore
-Albus Dumbledore