NCLB Consolidated Electronic Budget File
2008 -2009 User Guide
WARNING: prior to opening the Consolidated Electronic Budget file, please close all other M/S Excel files you may have open.
Before downloading the Excel Budget file, open Excel (Start-Programs-Microsoft Excel) to a blank worksheet. Click "Tools" from the toolbar at the top of the screen. Highlight "Macro" from the dropdown list, then double-click on "Security". You will see the screen to the right. Make sure the radio button next to "Medium" is on so that you will be able to use the macro included with the Budget file. If the "Medium" button has not been selected, select it and click on the OK button.
Next go back to the NCLB - No Child Left Behind table of contents under Fiscal Year 2008-2009, Interfund Budget FY09.
Right Click on the "Consolidated Electronic Budget File".
Choose the "Save Target As" option from the pop-up box. The File Download screen will appear. Enter the directory path on your hard drive or network drive where you would like the Budget file stored and click OK.
WARNING: prior to opening this M/S Excel file, please close all other M/S Excel files you may have open.
After downloading and saving the Excel file, open it up by double-clicking on the file name or go into Excel from the Start-Programs-Microsoft Excel route and then open the file (File-Open). Each time you open the file you will see a screen which asks if you want to enable macros. The correct response is Enable Macros. Macros are embedded computer programs which perform tasks for you. In this Excel file, the macro will help you select the budget file options you will need to complete in order to email the file back to CDE after you have finished your data input to the file. You will notice sheets being hidden and unhidden by the macro based on your selections made on the 2a - cover page sheet, this is normal.
For more information, contact:
Robert Hawkins: Grants Fiscal Management Services, (303) 866-6775 hawkins_r@cde.state.co.us
Barb Vassis: Grants Fiscal Management Services, (303) 866-6389 Vassis_B@cde.state.co.us
Debbie Wolfe: Grants Fiscal Management Services, (303) 866-6724 Wolfe_d@cde.state.co.us