{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Input","1-Instructions","2-Cover Page","3a-Budget Detail","3b- Equipment Detail","3c-Budget Summary","4a-AFR Detail","4b- AFR Equipment","4c-Annual Financial Report","5-District Code Table","6-Error Checking","Indirects 09-10","List Data","Sheet1","Sheet2","Notes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":12,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["Input the following information and click the button:"]
["Grant name (\"grant\" will be added to end of name)","RTTT Ready Schools"]
["Grant manager","Marti Rodriguez"]
["Grant manager phone #","303-866-6769"]
["Grant manager e-mail","rodriguez_m@cde.state.co.us"]
["Prgram manager"]
["Project manager e-mail"]
["Program manager phone #"]
["Funding period","FY 2016-17"]
["Budget objects not allowed"]
["Budget objects not allowed"]
["State/Federal funds"]
[]
[]
[null,"**Protect workbook after clicking button**"]

{"sheet":"1-Instructions","index":1,"n_rows":79,"n_cols":2,"rows_kept":79,"cut":false,"hidden":false,"merged":[[73,0,73,1]]}
[null,{"$f":"+Input!B2&\" Grant\"","v":"RTTT Ready Schools Grant"}]
[null,"COMPUTERIZED/ELECTRONIC INTERFUND BUDGET"]
[]
[null,"IMPORTANT, PRINT THIS WORKSHEET BEFORE BEGINNING"]
[]
[null,"All applicants are required to use the electronic version of the budget forms.   There are no blank \"hard copies\" of the budget forms included as part of the application packet."]
[]
[null,"PLEASE REFER TO THE RFP FOR ALLOWABLE AND NON-ALLOWABLE EXPENSES COVERED UNDER THIS GRANT"]
[]
["INSTRUCTIONS/FEATURES OF THE ELECTRONIC BUDGET"]
[null,{"$f":"\"The following instructions will allow you to complete the computerized/electronic budget section of the \"&Input!B2& \" Grant.\"","v":"The following instructions will allow you to complete the computerized/electronic budget section of the RTTT Ready Schools Grant."}]
[]
[null,"The computerized application allows interaction among worksheets, calculates subtotals and totals automatically, links data from detail sheets, and calculates indirect costs automatically."]
[]
[null,{"$f":"\"The computerized electronic \"&Input!B2&\" Grant application budget contains the following 7 worksheets (notice the tabs near the bottom of the screen):\"","v":"The computerized electronic RTTT Ready Schools Grant application budget contains the following 7 worksheets (notice the tabs near the bottom of the screen):"}]
[]
[null,"1-Instructions, 2-Cover Page, 3-Budget Detail, 4-Budget Summary, 4c-Annual Financial Report, Notes"]
[]
[]
["General Budget Comments:"]
["1 -","Enter dollar amounts as whole dollars.  Do not enter cents."]
[]
["2 -","White cells can be typed in; gray cells cannot or should not be typed in."]
[]
["3 -",{"$f":"\"If a cell background turns red, it means something is wrong or incomplete - either the cell itself or some associated cell.  Do not submit this file if it contains any cells with a red background, call CDE, Grants Fiscal Management Services Unit, \" &Input!B3& \", \"&Input!B4&\" for assistance.\"","v":"If a cell background turns red, it means something is wrong or incomplete - either the cell itself or some associated cell.  Do not submit this file if it contains any cells with a red background, call CDE, Grants Fiscal Management Services Unit, Marti Rodriguez, 303-866-6769 for assistance."}]
[]
["General Spreadsheet Comments:"]
["1-","Do not cut and paste cells.  If you need to move cell contents, (1) copy and paste, then (2) delete the original content.  If you cut and paste you will invalidate the program, and you will have to re-enter all your data on a new file."]
["2-","Do not erase a cell entry in any worksheet with the space bar, instead use the delete key on the keyboard."]
["3-","Use the Zoom feature to change the size of the information on screen.   This will have no effect on the printout size."]
["4-","When working on the detail sheet, be aware of the Excel row numbers on the left.  Because the title rows at the top are frozen, sometimes users are working in rows much farther down in the spreadsheet than they realize."]
[]
[]
["Terminology:"]
[null,"\"Object\" or \"Budget Object\" refers to:"]
[null,"Salaries (0100)"]
[null,"Employee Benefits (0200)"]
[null,"Purchased Professional & Technical Services (0300)"]
[null,"Purchased Property Services (0400) - **This is available under Support Program only**"]
[null,"Other Purchased Services (0500)"]
[null,"Supplies (0600)"]
[null,"Property (0700)"]
[null,"Other (0800)"]
[null,"Administration"]
[]
["Note:","Inclusion of an object item does not mean that the category is allowable per the grant."]
[]
["2-Cover Page sheet"]
["1-","After you have printed the instructions, begin with this page.  The information on this page is used to generate school specific worksheets.  Go to the 5-Code Table sheet to find your district 4-digit code."]
["2-","By entering the 4-digit code, your school district name appears here."]
[]
["3a-Budget Detail sheet"]
["1-","For each activity budgeted, enter the appropriate information as per the following column headings: (1) Program,  (2) Budget Object, (3) Cost, and (4) Description.   Provide a detailed description of the activity budgeted in the (4) description column."]
[null,"EQUIPMENT IS NOT ALLOWED ON THIS GRANT"]
[]
["3c-Budget Summary sheet"]
["1-","Indicate if this is a budget revision, and what submission number this is in cells G6 and G7."]
["2-","Enter the restricted indirect cost rate on D37."]
["3-","if you wish to elect less than 100% of indirects, enter the amount elected in cell D38."]
[]
["4a-AFR Detail"]
["1-","Enter actual expenditures for the funding period in this sheet.  This sheet is identical to 3-Budget Detail sheet.\""]
[]
[]
["4c-Annual Financial Report"]
["1-","Date is pulled from 4a and 4b.  Enter actual indirect costs in cell E37, and pupil counts in cells D41 & E41.  You will need to send this to us electronically, as well as provide a signed copy for our records."]
["2-","Please enter the date AFR is completed.  This is due by September 30, 2017."]
[]
["5-District Code Table sheet"]
[null,"This sheet contains your school district 4-digit code.  Reference this sheet when completing the Cover Page sheet.  "]
[]
["6-Error Checking sheet"]
["1 - ","Use this page to check whether or not your file is in balance. The 3-Budget Detail sheet is compared to the 4-Budget Summary sheet to ensure that the two pages are equal.   If equal, the word \"equal\" is displayed.  If not equal, the words \"not equal\" are displayed with a red background.  This sheet also verifies you have entered the # of Pupils Served on sheet 4-Budget Summary."]
["NOTES:  Include any notes on this sheet that will assist in the review of the budget."]
[]
[null,"Printing Instructions:  To print the entire file, select File, then select print, then select Entire workbook.  The entire file with page numbers will print."]
[]
[]
[null,"E-mail the electronic excel spreadsheet to the e-mail address listed on the 2-Cover Page."]

{"sheet":"2-Cover Page","index":2,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[15,2,15,3],[0,0,0,5],[1,0,1,5],[13,2,13,3],[14,2,14,3],[5,2,5,3],[4,2,4,3],[2,2,2,4],[6,2,6,3]]}
[{"$f":"+Input!B2&\" Grant\"","v":"RTTT Ready Schools Grant"}]
[{"$f":"+Input!B9","v":"FY 2016-17"}]
[null,null,"Grant Period -November 1, 2016  through June 30, 2017"]
[null,"CFDA:  84-412",null,null,"STATE GRANT CODE: 5412"]
[null,"Enter District Code"]
[null,"District Name:",{"$f":"VLOOKUP(C5,'Indirects 09-10'!B4:D201,3,FALSE)","v":{"$error":"#N/A"}}]
[null,"Name of Charter School:"]
[]
[null,"Report:"]
[null,"Revision number:"]
[null,"Date:"]
[]
[null,"Name of person completing this information"]
[null,"Name:"]
[null,"Phone No.:"]
[null,"E-mail:"]
[]
[null,"SUBMIT FILE AND COMPLETED RFP TO:","competitive_grants@cde.state.co.us"]
[null,"Submit updated budget files after RFP Process to:","grants_fiscal@cde.state.co.us"]
[]
[]
[null,"Grants Fiscal Staff Contact ","Phone No.      E-mail Address"]
[null,"Marti Rodriguez","303-866-6769   rodriguez_m@cde.state.co.us"]
[]
[]
[null,null,{"$f":"+Input!B8&\"  \"&Input!B7","v":"  "}]

{"sheet":"3a-Budget Detail","index":3,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[3,0,3,1],[0,0,0,3],[2,0,2,3],[1,0,1,3]]}
[{"$f":"+Input!B2&\" Grant\"","v":"RTTT Ready Schools Grant"}]
["Budget Detail"]
[{"$f":"+Input!B9","v":"FY 2016-17"}]
[{"$f":"'2-Cover Page'!$C$6","v":{"$error":"#N/A"}},null,null,{"$f":"'2-Cover Page'!C11","v":"00:00:00"}]
[1,2,3,4]
["Program","Budget Object","Cost","Description"]

{"sheet":"3b- Equipment Detail","index":4,"n_rows":5,"n_cols":7,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,6],[1,0,1,6]]}
[{"$f":"+Input!B2&\" Grant\"","v":"RTTT Ready Schools Grant"}]
["EQUIPMENT REQUEST AND INVENTORY"]
[{"$f":"'2-Cover Page'!$C$6","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"+'2-Cover Page'!C11","v":"00:00:00"}]
[1,2,3,"4b","4c",null,"6"]
["Description of item","Serial\nNumber","Date\nAcquired","Actual Cost","Capitalized/Non-Capitalized","Describe Use of Equipment","Expected Date\nof Completion"]

{"sheet":"3c-Budget Summary","index":5,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,0,0,7],[1,0,1,7],[42,5,42,7],[2,1,2,7],[4,0,4,1],[5,0,5,1],[12,1,12,2],[21,1,21,2]]}
[{"$f":"+Input!B2&\" Grant\"","v":"RTTT Ready Schools Grant"}]
[{"$f":"+Input!B9","v":"FY 2016-17"}]
[]
[null,null,null,null,null,null,null," Date"]
["District:",null,{"$f":"'2-Cover Page'!C6","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"'2-Cover Page'!C11","v":"00:00:00"}]
[null,null,null,null,null,"Revision","            "]
[null,null,null,null,null,"Budget Submission #:","            "]
[]
[null,null,"ALLOCATION FY 2016-17"]
[null,null,null,0]
[null,null,"TOTAL AVAILABLE",{"$f":"SUM(D9:D10)","v":0}]
[null,null,"PROGRAM CATEGORIES","Budget"]
[null,"Instructional Program"]
[null,1," Salaries (0100)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0100)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0100)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,2," Employee Benefits (0200)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0200)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0200)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,3," Purchased Professional & Technical Services (0300)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0300)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0300)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,4,"Purchased Property Services (0400)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0400)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0400)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,5," Other Purchased Services (0500)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0500)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0500)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,6," Supplies (0600)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0600)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0600)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,7," Other (0800)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0800)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"inst0800)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,8," Subtotal Instructional Program",{"$f":"SUM(D14:D20)","v":0}]
[null,"Support Program"]
[null,9," Salaries (0100)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0100)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0100)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,10," Employee Benefits (0200)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0200)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0200)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,11," Purchased Professional & Technical Services (0300)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0300)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0300)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,12," Purchased Property Services (0400)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0400)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0400)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,13," Other Purchased Services (0500)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0500)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0500)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,14," Supplies (0600)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0600)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0600)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,17," Property (0700)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0700)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0700)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,15," Other (0800)",{"$f":"+SUM(IF(ISERROR(IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0800)\",'3a-Budget Detail'!$C$7:$C$501)),0,IF(LEFT('3a-Budget Detail'!$A$7:$A$501,4)&RIGHT('3a-Budget Detail'!$B$7:$B$501,5)=\"supp0800)\",'3a-Budget Detail'!$C$7:$C$501)))","v":0}]
[null,16," Subtotal Support Program ",{"$f":"SUM(D23:D30)","v":0}]
[null,17,"Subtotal Direct Costs",{"$f":"D31+D21","v":0}]
[null,18,"Indirect Cost Rate (Restricted Rate)",1.9E-2]
[null,19,"Indirect Costs",{"$f":"D33*D32","v":0}]
[null,20,"Total Budget",{"$f":"D32+D34","v":0}]
[]
[null,28,"Pupils Served By Program"]
[null,null,"BUDGET CHECK - SHOULD = 0",{"$f":"D11-D35","v":0}]

{"sheet":"4a-AFR Detail","index":6,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,1]]}
[{"$f":"+Input!B2&\" Grant\"","v":"RTTT Ready Schools Grant"}]
["AFR Expenditure Detail"]
[{"$f":"+Input!B9","v":"FY 2016-17"}]
[{"$f":"'2-Cover Page'!$C$6","v":{"$error":"#N/A"}},null,null,{"$f":"'2-Cover Page'!C11","v":"00:00:00"}]
[1,2,3,4]
["Program","Budget Object","Cost","Description"]

{"sheet":"4b- AFR Equipment","index":7,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,5],[1,0,1,5]]}
[{"$f":"+Input!B2& \" Grant\"","v":"RTTT Ready Schools Grant"}]
["AFR Equipment Expenditure Detail"]
[{"$f":"'2-Cover Page'!$C$6","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"+'2-Cover Page'!C11","v":"00:00:00"}]
[1,2,3,"4b","4c"]
["Description of item","Serial\nNumber","Date\nAcquired","Actual Cost","Capitalized/Non-Capitalized","Describe Use of Equipment"]

{"sheet":"4c-Annual Financial Report","index":8,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[1,0,1,8],[0,0,0,8],[2,0,2,8],[39,5,39,8],[3,1,3,8],[23,1,23,2],[5,0,5,1],[6,0,6,1],[14,1,14,2],[7,0,7,1]]}
[{"$f":"+Input!B2&\" Grant\"","v":"RTTT Ready Schools Grant"}]
["ANNUAL FINANCIAL REPORT"]
[{"$f":"+Input!B9","v":"FY 2016-17"}]
[]
[null,null,null,null,null,null,null,null,"Date"]
["District:",null,{"$f":"'2-Cover Page'!C6","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"Revision","            "]
[null,null,"Due September 30, 2017",null,null,null,"Budget Submission #:","            "]
[]
[]
[]
[]
[]
[null,null,"PROGRAM CATEGORIES","Budget","Actual Expenditures"]
[null,"Instructional Program"]
[null,1," Salaries (0100)",{"$f":"'3c-Budget Summary'!$D14","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"inst0100)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,2," Employee Benefits (0200)",{"$f":"'3c-Budget Summary'!$D15","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"inst0200)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,3," Purchased Professional & Technical Services (0300)",{"$f":"'3c-Budget Summary'!$D16","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"inst0300)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,4,"Purchased Property Services (0400)",{"$f":"'3c-Budget Summary'!$D17","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"inst0400)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,5," Other Purchased Services (0500)",{"$f":"'3c-Budget Summary'!$D18","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"inst0500)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,6," Supplies (0600)",{"$f":"'3c-Budget Summary'!$D19","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"inst0600)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,7," Other (0800)",{"$f":"'3c-Budget Summary'!$D20","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"inst0800)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,8," Subtotal Instructional Program  ",{"$f":"SUM(D16:D22)","v":0},{"$f":"SUM(E16:E22)","v":0}]
[null,"Support Program"]
[null,9," Salaries (0100)",{"$f":"'3c-Budget Summary'!$D23","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"supp0100)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,10," Employee Benefits (0200)",{"$f":"'3c-Budget Summary'!$D24","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"supp0200)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,11," Purchased Professional & Technical Services (0300)",{"$f":"'3c-Budget Summary'!$D25","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"supp0300)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,12," Purchased Property Services (0400)",{"$f":"'3c-Budget Summary'!$D26","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"supp0400)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,13," Other Purchased Services (0500)",{"$f":"'3c-Budget Summary'!$D27","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"supp0500)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,14," Supplies (0600)",{"$f":"'3c-Budget Summary'!$D28","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"supp0600)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,15," Other (0800)",{"$f":"'3c-Budget Summary'!$D30","v":0},{"$f":"+SUM(IFERROR((IF(LEFT('4a-AFR Detail'!$A$7:$A$500,4)&RIGHT('4a-AFR Detail'!$B$7:$B$500,5)=\"supp0800)\",'4a-AFR Detail'!$C$7:$C$500)),0))","v":0}]
[null,16," Subtotal Support Program ",{"$f":"+SUM(D25:D31)","v":0},{"$f":"+SUM(E25:E31)","v":0}]
[null,17,"Subtotal Direct Costs",{"$f":"+D32+D23","v":0},{"$f":"+E32+E23","v":0}]
[null,19,"Approved Indirect Cost Rate (Restricted Rate)",{"$f":"'3c-Budget Summary'!$D33","v":1.9E-2},{"$f":"+D34","v":1.9E-2}]
[null,20,"Indirect Costs",null,{"$f":"E33*E34","v":0}]
[null,22,"Total Budget ",{"$f":"'3c-Budget Summary'!$D35","v":0},{"$f":"+E33+E35","v":0}]
[]
[]
[]
[null,null,"Typed Name of Person Preparing Report                 Date",null,null,"Signature of School District Authorized Representative*"]
[]
[null,null,"*Check with your school district budget office for the signature of the school district authorized representative."]

{"sheet":"5-District Code Table","index":9,"n_rows":201,"n_cols":3,"rows_kept":201,"cut":false,"hidden":true,"merged":[[0,0,0,2]]}
["District Codes Table"]
["District Code","County","District Name"]
["0010","Adams","Mapleton 1"]
["0020","Adams","Adams 12 Five Star Schools"]
["0030","Adams","Adams County 14"]
["0040","Adams","Brighton 27J"]
["0050","Adams","Bennett 29J"]
["0060","Adams","Strasburg 31J"]
["0070","Adams","Westminster 50"]
["0100","Alamosa","Alamosa RE 11J"]
["0110","Alamosa","Sangre De Cristo RE-22J"]
["0120","Arapahoe","Englewood 1"]
["0123","Arapahoe","Sheridan 2"]
["0130","Arapahoe","Cherry Creek 5"]
["0140","Arapahoe","Littleton 6"]
["0170","Arapahoe","Deer Trail 26J"]
["0180","Arapahoe","Adams-Arapahoe 28 J"]
["0190","Arapahoe","Byers 32J"]
["0220","Archuleta","Archuleta County 50 JT"]
["0230","Baca","Walsh RE-1"]
["0240","Baca","Pritchett Re-3"]
["0250","Baca","Springfield RE-4"]
["0260","Baca","Vilas School District RE-5"]
["0270","Baca","Campo RE-6"]
["0290","Bent","Las Animas RE-1"]
["0310","Bent","McClave RE-2"]
["0470","Boulder","St Vrain Valley RE-1J"]
["0480","Boulder","Boulder Valley RE 2"]
["0490","Chaffee","Buena Vista R-31"]
["0500","Chaffee","Salida R 32 (J)"]
["0510","Cheyenne","Kit Carson R-1"]
["0520","Cheyenne","Cheyenne RE-5"]
["0540","Clear Creek","Clear Creek RE-1"]
["0550","Conejos","North Conejos RE-1J"]
["0560","Conejos","Sanford 6J"]
["0580","Conejos","South Conejos RE-10"]
["0640","Costilla","Centennial R-1"]
["0740","Costilla","Sierra Grande R-30"]
["0770","Crowley","Crowley County RE-1-J"]
["0860","Custer","Custer County C-1"]
["0870","Delta","Delta County 50 (J)"]
["0880","Denver","Denver County 1"]
["0890","Dolores","Dolores RE NO 2"]
["0900","Douglas","Douglas County RE-1"]
["0910","Eagle","Eagle County RE-50"]
["0920","Elbert","Elizabeth C-1"]
["0930","Elbert","Kiowa C-2"]
["0940","Elbert","Big Sandy 100J"]
["0950","Elbert","Elbert 200"]
["0960","Elbert","Agate 300"]
["0970","El Paso","Calhan RJ1"]
["0980","El Paso","Harrison 2"]
["0990","El Paso","Widefield 3"]
["1000","El Paso","Fountain 8"]
["1010","El Paso","Colorado Springs 11"]
["1020","El Paso","Cheyenne Mountain 12"]
["1030","El Paso","Manitou Springs 14"]
["1040","El Paso","Academy 20"]
["1050","El Paso","Ellicott SD #22"]
["1060","El Paso","Peyton 23 JT"]
["1070","El Paso","Hanover 28"]
["1080","El Paso","Lewis Palmer 38"]
["1110","El Paso","Falcon 49"]
["1120","El Paso","Edison 54 JT"]
["1130","El Paso","Miami-Yoder 60"]
["1140","Fremont","Canon City RE-1"]
["1150","Fremont","Florence RE 2"]
["1160","Fremont","Cotopaxi RE-3"]
["1180","Garfield","Roaring Fork RE-1"]
["1195","Garfield","Garfield RE-2"]
["1220","Garfield","Garfield 16"]
["1330","Gilpin","Gilpin County Re-1"]
["1340","Grand","West Grand School 1-JT"]
["1350","Grand","East Grand No 2"]
["1360","Gunnison","Gunnison Watershed RE-1J"]
["1380","Hinsdale","Hinsdale County RE-1"]
["1390","Huerfano","Huerfano RE-1"]
["1400","Huerfano","La Veta RE-2"]
["1410","Jackson","North Park R-1"]
["1420","Jefferson","Jefferson R-1"]
["1430","Kiowa","Eads RE-1"]
["1440","Kiowa","Plainview RE-2"]
["1450","Kit Carson","Arriba-Flagler C-20"]
["1460","Kit Carson","Hi Plains R-23"]
["1480","Kit Carson","Stratton R-4"]
["1490","Kit Carson","Bethune R-5"]
["1500","Kit Carson","Burlington RE-6J"]
["1510","Lake","Lake County R-1"]
["1520","La Plata","Durango 9-R"]
["1530","La Plata","Bayfield"]
["1540","La Plata","Ignacio 11 JT"]
["1550","Larimer","Poudre R-1"]
["1560","Larimer","Thompson R-2J"]
["1570","Larimer","Park (Estes Park) R-3"]
["1580","Las Animas","Trinidad 1"]
["1590","Las Animas","Primero Reorganized RE-2"]
["1600","Las Animas","Hoehne Reorganized 3"]
["1620","Las Animas","Aguilar Reorganized 6"]
["1750","Las Animas","Branson Reorganized 82"]
["1760","Las Animas","Kim Reorganized 88"]
["1780","Lincoln","Genoa-Hugo C-113"]
["1790","Lincoln","Limon RE 4J"]
["1810","Lincoln","Karval RE-23"]
["1828","Logan","Valley RE-1"]
["1850","Logan","Frenchman RE-3"]
["1860","Logan","Buffalo RE-4"]
["1870","Logan","Plateau RE-5"]
["1980","Mesa","De Beque 49JT"]
["1990","Mesa","Plateau Valley 50"]
["2000","Mesa","Mesa County Valley 51"]
["2010","Mineral","Creede Consolidated 1"]
["2020","Moffat","Moffat County RE-NO 1"]
["2035","Montezuma","Montezuma-Cortez RE-1"]
["2055","Montezuma","Dolores RE-4A"]
["2070","Montezuma","Mancos RE-6"]
["2180","Montrose","Montrose RE-1J"]
["2190","Montrose","West End RE-2"]
["2395","Morgan","Brush RE-2 (J)"]
[2405,"Morgan","Fort Morgan RE-3"]
["2505","Morgan","Weldon Valley School RE 20J"]
["2515","Morgan","Wiggins RE-50 (J)"]
["2520","Otero","East Otero R-1"]
["2530","Otero","Rocky Ford R-2"]
["2535","Otero","Manzanola 3J"]
["2540","Otero","Fowler R 4J"]
["2560","Otero","Cheraw 31"]
["2570","Otero","Swink 33"]
["2580","Ouray","Ouray School District R-1"]
["2590","Ouray","Ridgway R-2"]
["2600","Park","Platte Canyon 1"]
["2610","Park","Park County RE-2"]
["2620","Phillips","Holyoke RE-1J"]
["2630","Philllips","Haxtun RE-2J"]
["2640","Pitkin","Aspen 1"]
["2650","Prowers ","Granada RE-1"]
["2660","Prowers","Lamar RE-2"]
["2670","Prowers","Holly RE-3"]
["2680","Prowers","Wiley Re-13 JT"]
["2690","Pueblo","Pueblo City 60"]
["2700","Pueblo","Pueblo County Rural 70"]
["2710","Rio Blanco","Meeker RE1"]
["2720","Rio Blanco","Rangely Re-4"]
["2730","Rio Grande","Del Norte C-7"]
["2740","Rio Grande","Monte Vista C-8"]
["2750","Rio Grande","Sargent RE-33J"]
["2760","Routt","Hayden RE-1"]
["2770","Routt","Steamboat Springs RE-2"]
["2780","Routt","South Routt"]
["2790","Saguache","Mountain Valley RE-1"]
["2800","Saguache","Moffat 2"]
["2810","Saguache","Center 26 JT"]
["2820","San Juan ","Silverton 1"]
["2830","San Miguel","Telluride R-1"]
["2840","San Miguel","Norwood R-2J"]
["2862","Sedgwick","Julesburg RE 1"]
["2865","Sedgwick","Platte Valley Re-3"]
["3000","Summit","Summit RE-1"]
["3010","Teller","Cripple Creek Victor Re-1"]
["3020","Teller","Woodland Park Re-2"]
["3030","Washington","Akron R-1"]
["3040","Washington","Arickaree R-2"]
["3050","Washington","Otis R-3"]
["3060","Washington","Lone Star 101"]
["3070","Washington","Woodlin R-104"]
["3080","Weld","Weld RE-1"]
["3085","Weld","Eaton RE-2"]
["3090","Weld","Keenesburg RE3-J"]
["3100","Weld","Windsor RE-4"]
["3110","Weld","Johnstown-Milliken Re-5J"]
["3120","Weld","Greeley R-6"]
["3130","Weld","Platte Valley RE-7"]
["3140","Weld","Fort Lupton RE-8"]
["3145","Weld","Ault-Highland RE-9"]
["3146","Weld","Briggsdale RE10"]
["3147","Weld","Prairie RE-11"]
["3148","Weld","Pawnee SD RE-12"]
["3200","Yuma ","Yuma 1"]
["3210","Yuma ","Wray RD-2"]
["3220","Yuma ","Idalia RJ-3"]
["3230","Yuma ","Liberty J-4"]
["8001",null,"Charter School Institute"]
["9025",null,"East Central BOCES"]
["9030",null,"Mountain BOCES"]
["9035",null,"Centennial BOCES"]
["9040",null,"Northeast BOCES"]
["9045",null,"Pikes Peak BOCES"]
["9050",null,"San Juan BOCES"]
["9055",null,"San Luis Valley BOCES"]
["9060",null,"South Central BOCES"]
["9075",null,"Southeastern BOCES"]
["9080",null,"Southwest BOCES"]
["9095",null,"Northwest Colorado BOCES"]
["9120",null,"Adams County BOCES"]
["9125",null,"Rio Blanco BOCES RE-1 & RE-4"]
["9130",null,"Expeditionary BOCES"]
["9135",null,"Grand Valley BOCES"]
["9140",null,"Mt Evans BOCES"]
["9145",null,"Uncompahgre BOCES"]
["9150",null,"Santa Fe Trail BOCES"]
["9160",null,"Front Range BOCES"]
["9165",null,"Ute Pass BOCES"]

{"sheet":"6-Error Checking","index":10,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,4,0,5],[0,6,0,10],[12,0,14,2],[0,0,0,2],[1,0,1,2],[3,0,3,2],[6,0,6,2],[4,0,4,2],[5,0,5,2],[9,0,9,2]]}
["ERROR CHECKING",null,null,null,"District:",null,{"$f":"'2-Cover Page'!C6","v":{"$error":"#N/A"}}]
[{"$f":"+Input!B2&\" Grant\"","v":"RTTT Ready Schools Grant"}]
[null,null,{"$f":"+'2-Cover Page'!C11","v":"00:00:00"}]
["Pupils Served"]
[{"$f":"'3c-Budget Summary'!D37","v":0}]
[{"$f":"IF(A5>1, \"\", \"Must Enter # of Pupils Served on 4-Budget Summary Sheet.\")","v":"Must Enter # of Pupils Served on 4-Budget Summary Sheet."}]
["Budget"]
["3a-Budget Detail","3c-Budget Summary"]
[{"$f":"SUM('3a-Budget Detail'!C7:C501)","v":0},{"$f":"'3c-Budget Summary'!D32","v":0},{"$f":"IF(A9=B9,\"Equal\",\"Not Equal\")","v":"Equal"}]
["Equipment"]
["3b-Equipment Detail","3c-Budget Summary"]
[{"$f":"+SUM('3b- Equipment Detail'!D10:D103)","v":0},{"$f":"+'3c-Budget Summary'!#REF!+'3c-Budget Summary'!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(A12=B12,\"Equal\",\"Not Equal\")","v":{"$error":"#REF!"}}]
["If the subtotals do not equal each other, the most likely problem is on the detail sheet.  All required entries may not have been entered."]

{"sheet":"Indirects 09-10","index":11,"n_rows":201,"n_cols":8,"rows_kept":201,"cut":false,"hidden":true,"merged":[]}
["For Use In","Org Code","County","District Name",null,null,null,"Restricted "]
["School Year",null,null,null,null,null,null,"Rate"]
[]
[20092010,"0010","Adams","Mapleton Public Schools",null,5.7299999999999997E-2,0.21160000000000001,8.7900000000000009]
[20092010,"0020","Adams","Adams 12 Five Star Schools",null,6.1199999999999997E-2,0.17560000000000001,5.2299999999999995]
[20092010,"0030","Adams","Adams County 14",null,4.6899999999999997E-2,0.14460000000000001,6.34]
[20092010,"0040","Adams","Brighton 27J",null,7.4999999999999997E-2,0.23100000000000001,6.1400000000000006]
[20092010,"0050","Adams","Bennett 29J",null,5.1200000000000002E-2,0.22320000000000001,6.65]
[20092010,"0060","Adams","Strasburg 31J",null,2.1399999999999999E-2,0.30859999999999999,0.08]
[20092010,"0070","Adams","Westminster 50",null,9.0999999999999998E-2,0.22209999999999999,5.9700000000000006]
[20092010,"0100","Alamosa","Alamosa RE 11J",null,4.6600000000000003E-2,0.21360000000000001,2.6500000000000004]
[20092010,"0110","Alamosa","Sangre De Cristo RE-22J",null,6.6199999999999995E-2,0.29470000000000002,8.6199999999999992]
[20092010,"0120","Arapahoe","Englewood 1",null,7.0300000000000001E-2,0.23250000000000001,4.46]
[20092010,"0123","Arapahoe","Sheridan 2",null,9.0999999999999998E-2,0.20949999999999999,6.03]
[20092010,"0130","Arapahoe","Cherry Creek 5",null,4.6899999999999997E-2,0.15,3.0500000000000003]
[20092010,"0140","Arapahoe","Littleton 6",null,8.2699999999999996E-2,0.1988,6.79]
[20092010,"0170","Arapahoe","Deer Trail 26J",null,9.0999999999999998E-2,0.37430000000000002,10.500000000000002]
[20092010,"0180","Arapahoe","Adams-Arapahoe 28 J",null,8.7499999999999994E-2,0.2097,6.8900000000000006]
[20092010,"0190","Arapahoe","Byers 32J",null,7.6200000000000004E-2,0.25440000000000002,7.37]
[20092010,"0220","Archuleta","Archuleta County 50 JT",null,6.7299999999999999E-2,0.2324,10.500000000000002]
[20092010,"0230","Baca","Walsh RE-1",null,4.4299999999999999E-2,0.32569999999999999,2.06]
[20092010,"0240","Baca","Pritchett Re-3",null,9.0999999999999998E-2,0.45700000000000002,9.4499999999999993]
[20092010,"0250","Baca","Springfield RE-4",null,5.4699999999999999E-2,0.32400000000000001,2.7600000000000002]
[20092010,"0260","Baca","Vilas School District RE-5",null,1.14E-2,3.78E-2,10.500000000000002]
[20092010,"0270","Baca","Campo RE-6",null,1.2999999999999999E-2,0.5716,1.6400000000000001]
[20092010,"0290","Bent","Las Animas RE-1",null,3.5900000000000001E-2,0.187,5.65]
[20092010,"0310","Bent","McClave RE-2",null,4.4299999999999999E-2,0.27160000000000001,5.29]
[20092010,"0470","Boulder","St Vrain Valley RE-1J",null,2.4500000000000001E-2,0.1222,4.3900000000000006]
[20092010,"0480","Boulder","Boulder Valley RE 2",null,8.6900000000000005E-2,0.20599999999999999,2.2500000000000004]
[20092010,"0490","Chaffee","Buena Vista R-31",null,9.0999999999999998E-2,0.25430000000000003,2.89]
[20092010,"0500","Chaffee","Salida R 32 (J)",null,5.45E-2,0.29759999999999998,2.0500000000000003]
[20092010,"0510","Cheyenne","Kit Carson R-1",null,6.7000000000000002E-3,0.27310000000000001,0.33]
[20092010,"0520","Cheyenne","Cheyenne RE-5",null,1.26E-2,0.30549999999999999,0.36000000000000004]
[20092010,"0540","Clear Creek","Clear Creek RE-1",null,7.7799999999999994E-2,0.23849999999999999,3.8600000000000003]
[20092010,"0550","Conejos","North Conejos RE-1J",null,4.5100000000000001E-2,0.22600000000000001,0.87000000000000011]
[20092010,"0560","Conejos","Sanford 6J",null,2.9600000000000001E-2,0.22220000000000001,3.2600000000000002]
[20092010,"0580","Conejos","South Conejos RE-10",null,4.8000000000000001E-2,0.2787,5.86]
[20092010,"0640","Costilla","Centennial R-1",null,2.6499999999999999E-2,0.2666,4.88]
[20092010,"0740","Costilla","Sierra Grande R-30",null,3.8800000000000001E-2,0.42459999999999998,4.7900000000000009]
[20092010,"0770","Crowley","Crowley County RE-1-J",null,9.0999999999999998E-2,0.39589999999999997,7.04]
[20092010,"0860","Custer","Custer County C-1",null,2.86E-2,0.34279999999999999,2.7800000000000002]
[20092010,"0870","Delta","Delta County 50 (J)",null,4.5199999999999997E-2,0.17369999999999999,3.42]
[20092010,"0880","Denver","Denver County 1",null,6.1400000000000003E-2,0.14960000000000001,8.1]
[20092010,"0890","Dolores","Dolores RE NO 2",null,7.0300000000000001E-2,0.33389999999999997,6.59]
[20092010,"0900","Douglas","Douglas County RE-1",null,9.0999999999999998E-2,0.19450000000000001,10.500000000000002]
[20092010,"0910","Eagle","Eagle County RE-50",null,8.1000000000000003E-2,0.2145,8.58]
[20092010,"0920","Elbert","Elizabeth C-1",null,0.06,0.23780000000000001,10.500000000000002]
[20092010,"0930","Elbert","Kiowa C-2",null,1.9699999999999999E-2,0.18440000000000001,7.42]
[20092010,"0940","Elbert","Big Sandy 100J",null,3.0499999999999999E-2,0.18279999999999999,2.31]
[20092010,"0950","Elbert","Elbert 200",null,3.5000000000000003E-2,0.25580000000000003,4.2300000000000004]
[20092010,"0960","Elbert","Agate 300",null,5.8599999999999999E-2,0.30480000000000002,9.1300000000000008]
[20092010,"0970","El Paso","Calhan RJ1",null,9.0999999999999998E-2,0.29039999999999999,9.9600000000000009]
[20092010,"0980","El Paso","Harrison 2",null,2.5899999999999999E-2,0.1308,5.24]
[20092010,"0990","El Paso","Widefield 3",null,8.5699999999999998E-2,0.24759999999999999,6.54]
[20092010,"1000","El Paso","Fountain 8",null,6.5100000000000005E-2,0.20300000000000001,5.08]
[20092010,"1010","El Paso","Colorado Springs 11",null,9.0999999999999998E-2,0.31840000000000002,10.500000000000002]
[20092010,"1020","El Paso","Cheyenne Mountain 12",null,3.56E-2,0.16650000000000001,2.6500000000000004]
[20092010,"1030","El Paso","Manitou Springs 14",null,2.1299999999999999E-2,0.16869999999999999,5.28]
[20092010,"1040","El Paso","Academy 20",null,4.4900000000000002E-2,0.12470000000000001,5.2500000000000009]
[20092010,"1050","El Paso","Ellicott SD #22",null,5.3199999999999997E-2,0.26640000000000003,7.4700000000000006]
[20092010,"1060","El Paso","Peyton 23 JT",null,9.0999999999999998E-2,0.31879999999999997,7.12]
[20092010,"1070","El Paso","Hanover 28",null,1.4500000000000001E-2,0.33710000000000001,8.33]
[20092010,"1080","El Paso","Lewis Palmer 38",null,4.2200000000000001E-2,0.2157,5.86]
[20092010,"1110","El Paso","Falcon 49",null,7.0999999999999994E-2,0.2321,10.500000000000002]
[20092010,"1120","El Paso","Edison 54 JT",null,9.0999999999999998E-2,0.32990000000000003,5.0100000000000007]
[20092010,"1130","El Paso","Miami-Yoder 60",null,3.56E-2,0.29580000000000001,2.27]
[20092010,"1140","Fremont","Canon City RE-1",null,-7.9399999999999998E-2,6.1499999999999999E-2,10.280000000000001]
[20092010,"1150","Fremont","Florence RE 2",null,4.3900000000000002E-2,0.28249999999999997,4.71]
[20092010,"1160","Fremont","Cotopaxi RE-3",null,1.8800000000000001E-2,0.1507,2.69]
[20092010,"1180","Garfield","Roaring Fork RE-1 (Parachute)",null,5.3699999999999998E-2,0.20930000000000001,3.73]
[20092010,"1195","Garfield","Garfield RE-2 (Rifle)",null,7.2599999999999998E-2,0.20669999999999999,7.76]
[20092010,"1220","Garfield","Garfield 16",null,5.9900000000000002E-2,0.28970000000000001,6.330000000000001]
[20092010,"1330","Gilpin","Gilpin County Re-1",null,6.9000000000000006E-2,0.42320000000000002,5.87]
[20092010,"1340","Grand","West Grand School 1-JT",null,7.1499999999999994E-2,0.39129999999999998,5.1100000000000003]
[20092010,"1350","Grand","East Grand No 2",null,3.2199999999999999E-2,0.21840000000000001,4.0199999999999996]
[20092010,"1360","Gunnison","Gunnison Watershed RE-1J",null,3.6900000000000002E-2,0.1618,3.56]
[20092010,"1380","Hinsdale","Hinsdale County RE-1",null,5.1700000000000003E-2,0.37069999999999997,4.45]
[20092010,"1390","Huerfano","Huerfano RE-1",null,9.0999999999999998E-2,0.35360000000000003,6.5200000000000005]
[20092010,"1400","Huerfano","La Veta RE-2",null,4.6899999999999997E-2,0.25040000000000001,9.84]
[20092010,"1410","Jackson","North Park R-1",null,8.6999999999999994E-2,0.37480000000000002,6.99]
[20092010,"1420","Jefferson","Jefferson R-1",null,3.9199999999999999E-2,0.1464,5.17]
[20092010,"1430","Kiowa","Eads RE-1",null,5.1299999999999998E-2,0.3584,6.3100000000000005]
[20092010,"1440","Kiowa","Plainview RE-2",null,9.0999999999999998E-2,0.32500000000000001,6.74]
[20092010,"1450","Kit Carson","Arriba-Flagler C-20",null,9.0999999999999998E-2,0.3453,6.04]
[20092010,"1460","Kit Carson","Hi Plains R-23",null,0.02,0.316,6.8600000000000012]
[20092010,"1480","Kit Carson","Stratton R-4",null,1.8100000000000002E-2,0.31040000000000001,1.58]
[20092010,"1490","Kit Carson","Bethune R-5",null,1.09E-2,0.38240000000000002,10.500000000000002]
[20092010,"1500","Kit Carson","Burlington RE-6J",null,2.4199999999999999E-2,0.18329999999999999,2.21]
[20092010,"1510","Lake","Lake County R-1",null,2.6499999999999999E-2,0.18179999999999999,2.6]
[20092010,"1520","La Plata","Durango 9-R",null,8.8499999999999995E-2,0.24429999999999999,3.49]
[20092010,"1530","La Plata","Bayfield",null,8.7800000000000003E-2,0.3236,6.4399999999999995]
[20092010,"1540","La Plata","Ignacio 11 JT",null,9.0999999999999998E-2,0.23219999999999999,8.9700000000000006]
[20092010,"1550","Larimer","Poudre R-1",null,4.36E-2,0.1744,3.3800000000000003]
[20092010,"1560","Larimer","Thompson R-2J",null,5.2400000000000002E-2,0.16070000000000001,4.0400000000000009]
[20092010,"1570","Larimer","Park (Estes Park) R-3",null,5.4100000000000002E-2,0.2157,7.16]
[20092010,"1580","Las Animas","Trinidad 1",null,5.9799999999999999E-2,0.21609999999999999,6.1400000000000006]
[20092010,"1590","Las Animas","Primero Reorganized RE-2",null,5.8400000000000001E-2,0.39679999999999999,6.18]
[20092010,"1600","Las Animas","Hoehne Reorganized 3",null,9.0999999999999998E-2,0.33939999999999998,4.97]
[20092010,"1620","Las Animas","Aguilar Reorganized 6",null,9.0999999999999998E-2,0.85799999999999998,6.2200000000000006]
[20092010,"1750","Las Animas","Branson Reorganized 82",null,9.0999999999999998E-2,0.27460000000000001,10.500000000000002]
[20092010,"1760","Las Animas","Kim Reorganized 88",null,3.95E-2,0.41799999999999998,2.79]
[20092010,"1780","Lincoln","Genoa-Hugo C-113",null,4.9700000000000001E-2,0.30599999999999999,8.5400000000000009]
[20092010,"1790","Lincoln","Limon RE 4J",null,2.6599999999999999E-2,0.2198,5.66]
[20092010,"1810","Lincoln","Karval RE-23",null,3.7499999999999999E-2,0.24229999999999999,1.58]
[20092010,"1828","Logan","Valley RE-1",null,3.9699999999999999E-2,0.26269999999999999,3.02]
[20092010,"1850","Logan","Frenchman RE-3",null,3.09E-2,0.2487,3.54]
[20092010,"1860","Logan","Buffalo RE-4",null,4.7100000000000003E-2,0.25009999999999999,2.4500000000000002]
[20092010,"1870","Logan","Plateau RE-5",null,2.69E-2,0.28820000000000001,10.500000000000002]
[20092010,"1980","Mesa","De Beque 49JT",null,9.0999999999999998E-2,0.36259999999999998,6.12]
[20092010,"1990","Mesa","Plateau Valley 50",null,7.1999999999999995E-2,0.2576,4.99]
[20092010,"2000","Mesa","Mesa County Valley 51",null,2.76E-2,0.15820000000000001,2.7700000000000005]
[20092010,"2010","Mineral","Creede Consolidated 1",null,9.0999999999999998E-2,0.34439999999999998,10.500000000000002]
[20092010,"2020","Moffat","Moffat County RE-NO 1",null,4.7199999999999999E-2,0.1951,9.76]
[20092010,"2035","Montezuma","Montezuma-Cortez RE-1",null,4.5499999999999999E-2,0.1782,7.19]
[20092010,"2055","Montezuma","Dolores RE-4A",null,8.7499999999999994E-2,0.26219999999999999,3.37]
[20092010,"2070","Montezuma","Mancos RE-6",null,7.3200000000000001E-2,0.37359999999999999,4.68]
[20092010,"2180","Montrose","Montrose RE-1J",null,8.3299999999999999E-2,0.21990000000000001,5.99]
[20092010,"2190","Montrose","West End RE-2",null,7.2800000000000004E-2,0.35560000000000003,6.4700000000000006]
[20092010,"2395","Morgan","Brush RE-2 (J)",null,4.48E-2,0.21759999999999999,4.62]
[20092010,"2405","Morgan","Fort Morgan RE-3",null,9.0999999999999998E-2,0.2681,10.500000000000002]
[20092010,"2505","Morgan","Weldon Valley School RE 20J",null,2.98E-2,0.2833,2.99]
[20092010,"2515","Morgan","Wiggins RE-50 (J)",null,5.0299999999999997E-2,0.2802,2.96]
[20092010,"2520","Otero","East Otero R-1",null,5.5899999999999998E-2,0.28399999999999997,3.5700000000000003]
[20092010,"2530","Otero","Rocky Ford R-2",null,4.6399999999999997E-2,0.2351,1.3800000000000001]
[20092010,"2535","Otero","Manzanola 3J",null,4.4699999999999997E-2,0.26419999999999999,3.2600000000000002]
[20092010,"2540","Otero","Fowler R 4J",null,5.9700000000000003E-2,0.25080000000000002,4.07]
[20092010,"2560","Otero","Cheraw 31",null,2.8000000000000001E-2,0.31319999999999998,4.08]
[20092010,"2570","Otero","Swink 33",null,2.5899999999999999E-2,0.27189999999999998,4.1100000000000003]
[20092010,"2580","Ouray","Ouray School District R-1",null,2.3300000000000001E-2,0.1419,0.71000000000000008]
[20092010,"2590","Ouray","Ridgway R-2",null,6.25E-2,0.24490000000000001,7.7700000000000005]
[20092010,"2600","Park","Platte Canyon 1",null,6.7500000000000004E-2,0.20749999999999999,4.82]
[20092010,"2610","Park","Park County RE-2",null,7.0099999999999996E-2,0.3493,3.75]
[20092010,"2620","Phillips","Holyoke RE-1J",null,3.95E-2,0.2238,5]
[20092010,"2630","Philllips","Haxtun RE-2J",null,5.6300000000000003E-2,0.3054,3.95]
[20092010,"2640","Pitkin","Aspen 1",null,6.1800000000000001E-2,0.2079,4.87]
[20092010,"2650","Prowers ","Granada RE-1",null,2.3800000000000002E-2,0.2432,2.5299999999999998]
[20092010,"2660","Prowers","Lamar RE-2",null,1.9300000000000001E-2,0.1593,2.4699999999999998]
[20092010,"2670","Prowers","Holly RE-3",null,7.3000000000000001E-3,0.29449999999999998,3.66]
[20092010,"2680","Prowers","Wiley Re-13 JT",null,9.0999999999999998E-2,0.26390000000000002,8.98]
[20092010,"2690","Pueblo","Pueblo City 60",null,5.5E-2,0.19600000000000001,6.5299999999999994]
[20092010,"2700","Pueblo","Pueblo No. 70",null,9.0999999999999998E-2,0.27129999999999999,8.86]
[20092010,"2710","Rio Blanco","Meeker RE1",null,4.1300000000000003E-2,0.1968,3.35]
[20092010,"2720","Rio Blanco","Rangely Re-4",null,5.8099999999999999E-2,0.39939999999999998,6.3]
[20092010,"2730","Rio Grande","Del Norte C-7",null,3.27E-2,0.2737,2.81]
[20092010,"2740","Rio Grande","Monte Vista C-8",null,4.3499999999999997E-2,0.26019999999999999,4.09]
[20092010,"2750","Rio Grande","Sargent RE-33J",null,5.4300000000000001E-2,0.27439999999999998,4.34]
[20092010,"2760","Routt","Hayden RE-1",null,2.64E-2,0.19370000000000001,2.8000000000000003]
[20092010,"2770","Routt","Steamboat Springs RE-2",null,2.8199999999999999E-2,0.22850000000000001,5.37]
[20092010,"2780","Routt","South Routt",null,2.12E-2,0.21149999999999999,1.9100000000000001]
[20092010,"2790","Saguache","Mountain Valley RE-1",null,6.3100000000000003E-2,0.3659,5.8100000000000005]
[20092010,"2800","Saguache","Moffat 2",null,9.0999999999999998E-2,0.33939999999999998,4.22]
[20092010,"2810","Saguache","Center 26 JT",null,5.8999999999999997E-2,0.31509999999999999,2.5299999999999998]
[20092010,"2820","San Juan ","Silverton 1",null,7.8299999999999995E-2,0.54369999999999996,6.99]
[20092010,"2830","San Miguel","Telluride R-1",null,6.7900000000000002E-2,0.18410000000000001,10.14]
[20092010,"2840","San Miguel","Norwood R-2J",null,9.0999999999999998E-2,0.1918,6.23]
[20092010,"2862","Sedgwick","Julesburg RE 1",null,3.9300000000000002E-2,0.23280000000000001,0.64]
[20092010,"2865","Sedgwick","Platte Valley Re-3",null,0.01,0.28120000000000001,0.98]
[20092010,"3000","Summit","Summit RE-1",null,8.3799999999999999E-2,0.17510000000000001,10.500000000000002]
[20092010,"3010","Teller","Cripple Creek Victor Re-1",null,4.7800000000000002E-2,0.14990000000000001,5.75]
[20092010,"3020","Teller","Woodland Park Re-2",null,4.99E-2,0.16639999999999999,3.4000000000000004]
[20092010,"3030","Washington","Akron R-1",null,3.7400000000000003E-2,0.2298,5.2299999999999995]
[20092010,"3040","Washington","Arickaree R-2",null,9.0999999999999998E-2,0.34100000000000003,5.2500000000000009]
[20092010,"3050","Washington","Otis R-3",null,4.2000000000000003E-2,0.33150000000000002,5.15]
[20092010,"3060","Washington","Lone Star 101",null,9.0999999999999998E-2,0.36280000000000001,5.86]
[20092010,"3070","Washington","Woodlin R-104",null,7.8200000000000006E-2,0.62529999999999997,9.1800000000000015]
[20092010,"3080","Weld","Weld RE-1",null,4.6800000000000001E-2,0.183,5.46]
[20092010,"3085","Weld","Eaton RE-2",null,4.8599999999999997E-2,0.2079,5.16]
[20092010,"3090","Weld","Keenesburg RE3-J",null,7.2300000000000003E-2,0.28589999999999999,5.2200000000000006]
[20092010,"3100","Weld","Windsor RE-4",null,6.88E-2,0.20979999999999999,2.9400000000000004]
[20092010,"3110","Weld","Johnstown-Milliken Re-5J",null,4.4699999999999997E-2,0.29959999999999998,4.1000000000000005]
[20092010,"3120","Weld","Greeley R-6",null,7.8799999999999995E-2,0.19739999999999999,7.66]
[20092010,"3130","Weld","Platte Valley RE-7",null,8.3400000000000002E-2,0.27450000000000002,6.39]
[20092010,"3140","Weld","Fort Lupton RE-8",null,7.9100000000000004E-2,0.30049999999999999,5.95]
[20092010,"3145","Weld","Ault-Highland RE-9",null,5.96E-2,0.25580000000000003,3.3800000000000003]
[20092010,"3146","Weld","Briggsdale RE10",null,-1.2999999999999999E-3,0.5575,0.84000000000000008]
[20092010,"3147","Weld","Prairie RE-11",null,7.3999999999999996E-2,0.2409,5.0200000000000005]
[20092010,"3148","Weld","Pawnee SD RE-12",null,2.1299999999999999E-2,0.32450000000000001,1.4100000000000001]
[20092010,"3200","Yuma ","Yuma 1",null,3.7199999999999997E-2,0.2326,2.6]
[20092010,"3210","Yuma ","Wray RD-2",null,6.9400000000000003E-2,0.253,10.500000000000002]
[20092010,"3220","Yuma ","Idalia RJ-3",null,3.3700000000000001E-2,0.3342,3.8]
[20092010,"3230","Yuma ","Liberty J-4",null,7.4899999999999994E-2,0.2306,5.28]
[20092010,"9025",null,"East Central BOCES",null,9.0999999999999998E-2,0.11509999999999999,5.19]
[20092010,"9030",null,"Mountain BOCES",null,5.6300000000000003E-2,6.9800000000000001E-2,3.9400000000000004]
[20092010,"9035",null,"Centennial BOCES",null,9.0999999999999998E-2,0.54100000000000004,10.500000000000002]
[20092010,"9040",null,"Northeast BOCES",null,9.0999999999999998E-2,0.13830000000000001,6.69]
[20092010,"9045",null,"Pikes Peak BOCES",null,9.0999999999999998E-2,0.24410000000000001,10.500000000000002]
[20092010,"9050",null,"San Juan BOCES",null,9.0999999999999998E-2,8.8800000000000004E-2,0.17]
[20092010,"9055",null,"San Luis Valley BOCES",null,6.1499999999999999E-2,7.7499999999999999E-2,10.500000000000002]
[20092010,"9060",null,"South Central BOCES",null,4.6800000000000001E-2,6.3299999999999995E-2,10.500000000000002]
[20092010,"9075",null,"Southeastern BOCES",null,9.0999999999999998E-2,0.42409999999999998,10.500000000000002]
[20092010,"9080",null,"Southwest BOCES",null,2.52E-2,4.5900000000000003E-2,10.500000000000002]
[20092010,"9095",null,"Northwest Colorado BOCES",null,5.7599999999999998E-2,0.10780000000000001,0]
[20092010,"9120",null,"Adams County BOCES",null,0,0,0]
[20092010,"9125",null,"Rio Blanco BOCES RE-1 & RE-4",null,9.0999999999999998E-2,7.2300000000000003E-2,5.4200000000000008]
[20092010,"9130",null,"Expeditionary BOCES",null,6.5000000000000002E-2,8.8300000000000003E-2,10.500000000000002]
[20092010,"9135",null,"Grand Valley BOCES",null,9.0999999999999998E-2,0.5907,6.9999999999999993E-2]
[20092010,"9140",null,"Mt Evans BOCES",null,9.0999999999999998E-2,-2.8E-3,0]
[20092010,"9145",null,"Uncompahgre BOCES",null,9.0999999999999998E-2,2.0000000000000001E-4,0.69000000000000006]
[20092010,"9150",null,"Santa Fe Trail BOCES",null,2.0400000000000001E-2,0.05,0]
[20092010,"9160",null,"Front Range BOCES",null,9.0999999999999998E-2,0.99990000000000001,{"$f":"F200*100","v":9.1}]
[20092010,"9165",null,"Ute Pass BOCES",null,0,0,{"$f":"F201*100","v":0}]

{"sheet":"List Data","index":12,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["Original Budget",null,{"$f":"IF(OR(Input!$B$11=\"Salaries (0100)\",Input!$B$10=\"Salaries (0100)\"),\"\",\"Salaries (0100)\")","v":"Salaries (0100)"},null,null,null,"Salaries (0100)"]
["Revised Budget",null,{"$f":"IF(OR(Input!$B$11=\"Employee Benefits (0200)\",Input!$B$10=\"Employee Benefits (0200)\"),\"\",\"Employee Benefits (0200)\")","v":"Employee Benefits (0200)"},null,null,null,"Employee Benefits (0200)"]
["Original AFR",null,{"$f":"IF(OR(Input!$B$11=\"Purchased Professional & Technical Services (0300)\",Input!$B$10=\"Purchased Professional & Technical Services (0300)\"),\"\",\"Purchased Professional & Technical Services (0300)\")","v":"Purchased Professional & Technical Services (0300)"},null,null,null,"Purchased Professional & Technical Services (0300)"]
["Revised AFR",null,{"$f":"IF(OR(Input!$B$11=\"Purchased Property Services (0400)\",Input!$B$10=\"Purchased Property Services (0400)\"),\"\",\"Purchased Property Services (0400)\")","v":"Purchased Property Services (0400)"},null,null,null,"Purchased Property Services (0400)"]
[null,null,{"$f":"IF(OR(Input!$B$11=\"Other Purchased Services (0500)\",Input!$B$10=\"Other Purchased Services (0500)\"),\"\",\"Other Purchased Services (0500)\")","v":"Other Purchased Services (0500)"},null,null,null,"Other Purchased Services (0500)"]
[null,null,{"$f":"IF(OR(Input!$B$11=\"Supplies (0600)\",Input!$B$10=\"Supplies (0600)\"),\"\",\"Supplies (0600)\")","v":"Supplies (0600)"},null,null,null,"Other (0800)"]
[null,null,"Other (0800)",null,null,null,"Supplies (0600)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Instructional Program"]
[null,null,"Support Program"]

{"sheet":"Sheet1","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Notes","index":15,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[[5,0,5,1],[0,0,0,1],[1,0,1,1],[2,0,2,1]]}
[{"$f":"+Input!B2&\" Grant\"","v":"RTTT Ready Schools Grant"}]
["NOTES "]
[{"$f":"+Input!B9","v":"FY 2016-17"}]
[]
[null,{"$f":"'2-Cover Page'!$C$6","v":{"$error":"#N/A"}}]
[]
["Date","Comments"]