Talk amongst yourselves
PDF NOW DISCOUNTED NEARLY 50%
Click here to buy PDF version
Need help on FanDuel or DraftKings? Purchase a subscription from the website that specializes in daily fantasy.
17 Jul 2012
Do they work in Excel 2011 for Mac?
Posted by: flynnr on 17 Jul 2012
3 replies , Last at
17 Jul 2012, 7:23pm by
They are supposed to, as Office for Mac 2011 supports VBScripts (but not Office for Mac 2008). However, Open Office supports them too, and I haven't been able to get KUBIAK to work in Open Office. Anyone out there have experience with this?
Macros seem to work fine for me in Excel for Mac 2011.
They seem to get most of the way in NeoOffice, but fail to update some baseline variables - the "nrFlex" variable on the projections worksheet doesn't get set in my setup, so FPOB doesn't get computed for RB/WR/TE. Last year I was able to get around this by looking at the baselines sheet, figuring out what the values should be and copying them into their own cells on the projections sheet, and then updating the formula in the FPOB sheet to point to those cells. Of course, then it's difficult to know that the macro executed everything it wanted to before crashing, but the results seemed reasonable enough.
Macros worked fine for me until I entered keeper values in. Now it won't work.
© Football Outsiders, Inc. // Site powered by Stein-Wein // Partner of USA TODAY Sports Digital Properties