Writers of Pro Football Prospectus 2008

17 Jul 2012

Kubiak macros

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 ChrisW

Re: Kubiak macros
by MatMan :: Tue, 07/17/2012 - 3:54pm

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?

Re: Kubiak macros
by ChrisW :: Tue, 07/17/2012 - 7:23pm

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.

Re: Kubiak macros
by fb29 :: Tue, 07/17/2012 - 6:28pm

Macros worked fine for me until I entered keeper values in. Now it won't work.

Login or register to post comments