N Gumley

Well, I ended up starting from scratch with the zip files, and all is well now. I have no idea what I did wrong, as the inputs are identical, but the error did not replicate. However, even on the new Compiler spreadsheet, Excel displays hundreds of warnings (the little green arrows) about unlocked cells. No big deal, just FYI.

I'm getting errors throughout the compiler concerning the defense. Specifically on the DEF tab under FF Point Calculations (columns N, O) all of the calcuations show as #REF!. I've got some excel knowledge, and tried to trek through the formulas, and it seems that way down in column DH there's a formula that actually has #REF! in it. So, did I somehow cause this when I modified the inputs / settings? Or...? Any thoughts? My draft is tomorrow night, so the sooner the better with any help!