Worksheets are locked so that most, but not all, formulas are protected from accidental change.
Formulas on the Projection worksheet that may eventually be replaced with year-end actuals are not locked.
Worksheet unlocking does not require a password.
Several intermediate-step columns are hidden on the Projections worksheet to enhance readability.
State tax worksheets are hidden. There is one worksheet for each state.
Formulas
You can download the .txt file
with all formulas and comments. Commenting my formulas is the only way I can keep track of what I intended with each formula. You can change the file extension and
use an editor to display color coding. Color coding will help you follow the formulas. I use Notepad++ and .bat.
Save a new copy of the Excel workbook as an Excel with Macro Enabled
ALT + F11 to open VBA (Visual Basic for Applications)
Select Insert, then Module
Copy and paste both blocks of VBA code from Microsoft's measuring calculation time into the new module;
or, download a .txt file with Microsoft's VBA code and the VBA code I added to average 100 runs on a specific range, then copy
and paste all the VBA code from the .txt file into the new module
Save the Excel workbook with VBA code
On any given worksheet, ALT + F8 to open the macro list window
Conduct one or more of the following timing tests to locate bottlenecks
FullcalcTimer (For worst case timing of whole workbook)
RecalcTimer (Right after FullcalcTimer for best case timing of whole workbook)
SheetTimer (For timing of an individual worksheet)
RangeTimer (Select a range and run for timing on that range)
RangeTimer100 (I added this code to average 100 runs on a specific range; this code can be modified for longer or shorter runs)
