Project Cost Estimate Form C100 Excel Instructions for 2007-09 Biennium

Important Issues with Version 2.61:

Application errors sometimes occur when the user selects a Building Type on the C100 sheet. This application error will cause Excel to close abruptly and you may lose changes to all open workbooks. If Excel closes abruptly, try to reopen the worksheet to continue working. In some cases you may have to recreate your C100. Users should save often to prevent the loss of data.

See the Instructions worksheet tab in the C100 spreadsheet for Version 2.61 changes.

To download a copy of the Capital Project Cost Estimate C100 form:

  1. Click here to download the C100 form. The File Download screen will be displayed.
  2. Make your selection to either run it or save it and press the OK button.
  3. When you run it or open the saved file - a "Winzip Extractor" screen will be displayed.
  4. Press the Browse button and locate the folder where you want the new C100 form to be stored.
  5. Press the Unzip button to store the new C100 on your machine.
  6. A message saying that "1 file(s) Unzipped Successfully" will be displayed. Press the OK button.
  7. The "Winzip Extractor" screen will be redisplayed. Press the Close button.
  8. You will find a copy of the "2007-09 C100.xls" in the folder you selected in step 4 above. This file requires that you have Excel 97 or later.

Instructions for Using the Excel C100 File

Form C100 contains Excel macros that must be enabled in order for the file to function properly.

If you are running Excel 2000 or newer, make sure your macro security is set to Medium prior to opening the files.

  • From the Tools menu, choose Macro, then select Security from the context-menu.
  • On the Security Level tab, select Medium, press OK.
  • Open the C100 file.
  • You will be notified that the file contains macros. Select Enable Macros.

If you are running Excel 97:

  • Open the C100 file.
  • If you are notified that the file contains macros, select Enable Macros.