Writers of Pro Football Prospectus 2008

25 Aug 2012

Auction inflation BETA

Regarding auction inflation, the Instructions tab says to enter live auction values in Column H, then "re-running the macro whenever you choose." How do I re-run the macro after inputting these values, specifically in Excel 2007?

EDIT: Using the "View Macros" button, I see four macros: calcPosBaseline, importKubiakSettings, printKubiak, and saveKubiakSettings. Do I run one of these macros when using the Auction Inflation feature?

Posted by: abernethyj on 25 Aug 2012

2 replies , Last at 25 Aug 2012, 10:30pm by Zac

Re: Auction inflation BETA
by nibiyabi :: Sat, 08/25/2012 - 8:10pm

I believe those correspond to the 4 buttons found on the scoring tab. "Generate my KUBIAK" most likely corresponds to "calcPosBaseline", but I'd recommend using the button instead, in case you're bypassing something I'm unaware of.

Re: Auction inflation BETA
by Zac :: Sat, 08/25/2012 - 10:30pm

You don't have to rerun the macro. I don't know why the instructions say that. When you enter the prices in column H, column CZ updates with a post-inflation price. Rerunning won't change anything.

Login or register to post comments