{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["1-Instructions","2-Cover Page","3-Budget Detail","3a-Budget Summary","6b-AFR Equipment Detail","5-NOTES","8-Error Checking","Other"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":24,"comments":0,"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":"1-Instructions","index":0,"n_rows":82,"n_cols":1,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["Title V State Sexual Risk Avoidance Education (SRAE) Grant Program"]
["COMPUTERIZED/ELECTRONIC BUDGET"]
["(Print a copy of these instructions for easy reference)"]
[]
["All applicants are required to use the electronic version of the budget forms.  "]
["Refer to the Request for Application (RFA) for a list of non-allowable costs."]
[]
["Applicants must complete a one year budget for the grant program.  "]
[]
["The budget detail should include hourly/daily rates, cost per item, or other detail sufficient to explain how the total line item amount was reached.  No single line item should exceed $10,000 without proper justification (i.e., a technology line item should be broken down to the number of systems and the cost per system).   Line items without proper justification will be denied.  Fully describe the budget for the applicable year.   The proposed budget should not exceed the limitation of the amount that can be requested in one year.  "]
[]
["INSTRUCTIONS/FEATURES OF THE ELECTRONIC BUDGET"]
["The following instructions will allow you to complete the computerized/electronic budget section of the SRAE Grant Budget."]
["The computerized budget allows interaction among worksheets, calculates subtotals and totals automatically, links data from detail sheets and checks for errors.  "]
[]
["The computerized file contains the following worksheets:"]
["1-Instructions"]
["2-Cover Page"]
["3-Budget Detail"]
["3a-Budget Summary"]
["5-NOTES"]
[]
["Only enter budget data on the 3-Budget Detail sheet for this RFA.  This data will link to the appropriate sheets."]
["For revisions, enter the amount of the revision under the first available revision column. All revisions should offset; i.e., if you add money to one line you should subtract an equal amount from another."]
["The annual financial report is completed at the end of the first year of the award.  DO not enter information on the 4a Annual Financial Report Expenditure Detail Sheet during the RFA process."]
[]
["General Budget Comments:"]
[]
["1. Enter dollar amounts as whole dollars.   Do not enter cent amounts."]
["2. White cells can be typed in; gray cells cannot or should not be typed in."]
["3. If a cell background turns red, it means something is wrong or incomplete with either the cell or some associated cell.   Do not submit this file if it contains any cells with a red background; call CDE, Patrick Mueller: 303-866-6879 for assistance or e-mail the file with an explanation of the issues encountered to:  mueller_p@cde.state.co.us."]
[]
["General Spreadsheet Comments:"]
[]
["1.      Additional information can be read by clicking in the column headings of the various sheets."]
["2.      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."]
["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 budget detail and equipment page, be aware of the Excel row numbers of 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."]
["5.      Do not erase a cell entry in any worksheet with the space bar, but instead use the delete key on the keyboard."]
["6.      Some cells or rows of cells have a dropdown feature with which to choose from a preselected list.  These cells will display a grey arrow box when the cell is highlighted."]
["7.      Resting your mouse on a cell with a red triangle in the upper right-hand corner of a cell displays an informational comment."]
[]
[]
[]
["LET’S GET STARTED!!"]
[]
["2-Cover Page sheet"]
[]
["Enter the required information in the white boxes only."]
["Agency Name"]
["Budget – Original/Revision/Annual Financial Report  --  SELECT Original"]
["Date – Enter date completed"]
["Name of person completing form – This is typically the fiscal contact for the agency"]
["Name of program director – This is that will be responsible for the day-to-day activity of the program"]
[]
["3-Budget Detail sheet-All expenditures must be in whole dollars."]
[]
["Entries made on the Budget Detail Sheet subtotal on the “3a-Budget Summary”.  "]
[]
["For each activity budgeted, enter the appropriate information as per the following column headings:"]
["(1)   Budget Object, (2) Original Budgeted Cost, (5) Description/Narrative and (6) Expected Date of Completion."]
["It is critical that you enter information on each of these columns as they are required to populate the 3a-Budget Summary sheet."]
[]
["NOTE:  If you are purchasing computer equipment, this can be categorized as Supplies however it must be budgeted separately from other supplies.  Programs are required to keep an Inventory of computers and other small and attractive equipment items purchased with these federal dollars."]
[]
["AFR: For the Annual Financial Report: enter actual expenditures in column 6; this amount will follow through to the summary sheet."]
[]
["3a-Budget Summary sheet"]
[]
["In the Amount Requested (C6) enter the amount you are requested for this grant.  This will total on cell C8."]
[]
["The rest of this sheet is protected as it is populated from your data entry on 3-Budget Detail.  If the amount you entered on 3-Budget Detail does not match the total on the Summary, send the file to Patrick Mueller to get the budget updated."]
[]
["Once the numbers have been confirmed, save the file as follows:"]
[]
["4 digit code_District Name_FY19-20 Title V State SRAE Budget"]
[]
["If you do not know your 4-digit code:"]
[]
["Name of Agency_FY19-20 Title V State SRAE Budget"]
[]
["Submit file to the Competitive Grants."]

{"sheet":"2-Cover Page","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[[23,0,23,6],[0,0,0,6],[1,0,1,6],[22,0,22,6]]}
["Title V State Sexual Risk Avoidance Education Grant Program"]
["October 1, 2022 - September 30, 2023"]
[null,"CFDA:  ",93.234999999999999,"STATE GRANT CODE:",7235]
[null,"Grantee Name:","ABC grantee"]
[]
[null,"Report Type:","Original Budget"]
[null,"Revision number:"]
[null,"Date:","January 23,2003"]
[]
[null,"Name of person completing this information"]
[null,"Name:"]
[null,"Phone No.:"]
[null,"E-mail:"]
[null,"Name of Program Director"]
[null,"Name:"]
[null,"Phone No.:"]
[null,"E-mail:"]
[]
[null,"Submit this excel file to :","CompetitiveGrants@cde.state.co.us"]
[]
[null,"Grants Fiscal Staff Contact :","Patrick Mueller: ‪303.656.9341‬ mueller_p@cde.state.co.us"]
[null,"Program Manager:","Shannon Allen: 720.498.4675 allen_s@cde.state.co.us"]

{"sheet":"3-Budget Detail","index":2,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[0,0,0,9],[1,0,1,9]]}
[{"$f":"'2-Cover Page'!A1:G1","v":"Title V State Sexual Risk Avoidance Education Grant Program"}]
["BUDGET DETAIL"]
[{"$f":"+'2-Cover Page'!C4","v":"ABC grantee"},null,null,null,null,null,null,null,null,{"$f":"'2-Cover Page'!C8","v":"January 23,2003"}]
[1,2,3,4,5,6,7,8,9,10]
["Budget Object","Original Budgeted Cost","1st Revision","2nd Revision","Final Budgeted Cost","AFR actual","Remaining Funds","Description/Budget Narrative","Revision Notes","Expected Date of Completion"]
["Instructional Program - Salaries (0100)",null,null,null,{"$f":"SUM(B6:D6)","v":0},null,{"$f":"E6-F6","v":0}]
[null,null,null,null,{"$f":"SUM(B7:D7)","v":0},null,{"$f":"E7-F7","v":0}]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,{"$f":"SUM(B32:D32)","v":0},null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]
[null,null,null,null,0,null,0]

{"sheet":"3a-Budget Summary","index":3,"n_rows":31,"n_cols":4,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3]]}
[null,"Title V State Sexual Risk Avoidance Education Grant Program"]
[null,{"$f":"'2-Cover Page'!$A$2","v":"October 1, 2022 - September 30, 2023"}]
[]
[null,{"$f":"'2-Cover Page'!$C$4","v":"ABC grantee"},null,{"$f":"'2-Cover Page'!C8","v":"January 23,2003"}]
["Line","DESCRIPTION","Budget","Actual"]
[null,"Amount Awarded",0,0]
[null,"Amount Requested",{"$f":"C31","v":0},{"$f":"D31","v":0}]
[null,"Total Available",{"$f":"C6-C7","v":0},{"$f":"D6-D7","v":0}]
["INSTRUCTIONAL PROGRAM"]
[1,"Instructional Program - Salaries (0100)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B10,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B10,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[2,"Instructional Program - Employee Benefits (0200)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B11,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B11,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[3,"Instructional Program - Purchased Professional & Technical Services (0300)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B12,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B12,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[4,"Instructional Program - Other Purchased Services (0500)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B13,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B13,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[5,"Instructional Program - Travel, Registration and Entrance (0580)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B14,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B14,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[6,"Instructional Program - Supplies (0600)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B15,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B15,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[7,"Instructional Program - Equipment - Non Capitalized (0735)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B16,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B16,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[8,"Subtotal - Instructional Program",{"$f":"SUM(C10:C16)","v":0},{"$f":"SUM(D10:D16)","v":0}]
[]
["SUPPORT PROGRAM"]
[9,"Support Program - Salaries (0100)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B20,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B20,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[10,"Support Program - Employee Benefits (0200)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B21,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B21,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[11,"Support Program - Purchased Professional & Technical Services (0300)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B22,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B22,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[12,"Support Program - Other Purchased Services (0500)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B23,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B23,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[13,"Support Program - Travel, Registration and Entrance (0580)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B24,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B24,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[14,"Support Program - Supplies (0600)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B25,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B25,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[15,"Support Program - Equipment - Non Capitalized (0735)",{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B26,'3-Budget Detail'!$E$6:$E$100)","v":0},{"$f":"SUMIF('3-Budget Detail'!$A$6:$A$100,'3a-Budget Summary'!B26,'3-Budget Detail'!$F$6:$F$100)","v":0}]
[16,"Subtotal - Support Program",{"$f":"SUM(C20:C26)","v":0},{"$f":"SUM(D20:D26)","v":0}]
[17,"Total - Instructional and Support Programs",{"$f":"C17+C27","v":0},{"$f":"D17+D27","v":0}]
[18,"Indirect Rate"]
[19,"Indirect Calculation",{"$f":"SUM(C10+C20)*C29","v":0},{"$f":"C30","v":0}]
[20,"GRAND TOTAL",{"$f":"C28+C30","v":0},{"$f":"D28+D30","v":0}]

{"sheet":"6b-AFR Equipment Detail","index":4,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7]]}
[{"$f":"#REF!","v":{"$error":"#REF!"}}]
["AFR EQUIPMENT REQUEST AND INVENTORY"]
[{"$f":"+'2-Cover Page'!C4","v":"ABC grantee"},null,null,null,null,null,null,{"$f":"'2-Cover Page'!C8","v":"January 23,2003"}]
[1,2,3,4,5,6,7,"1900-01-08"]
["Description of item","Serial\nNumber","Date\nAcquired","Actual Cost","Budget Year","Capitalized","Describe Use of Equipment","Expected Date\nof Completion"]

{"sheet":"5-NOTES","index":5,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Date","Notes"]

{"sheet":"8-Error Checking","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":true,"merged":[[4,2,4,4],[3,2,3,4]]}
[]
[null,{"$f":"+'2-Cover Page'!C4","v":"ABC grantee"}]
[]
[null,null,"Error Checking"]
[null,null,"Title V State Absitnence Grant",null,null,{"$f":"'2-Cover Page'!C8","v":"January 23,2003"}]
[]
[]
[]
[null,null,"Detail Sheets","5-Budget Summary"]
[null,"3-Budget Detail",{"$f":"SUM(IF(ISBLANK('3-Budget Detail'!D6:D700),IF(ISBLANK('3-Budget Detail'!C6:C700),'3-Budget Detail'!B6:B700,'3-Budget Detail'!C6:C700),'3-Budget Detail'!D6:D700))","v":0},{"$f":"+#REF!+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C10=D10,\"equal\",\"not equal!\")","v":{"$error":"#REF!"}}]
[null,"4-Equipment",{"$f":"+SUM(IF(ISBLANK(#REF!),#REF!,#REF!))","v":{"$error":"#REF!"}},{"$f":"+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C11=D11,\"equal\",\"not equal!\")","v":{"$error":"#REF!"}}]
[null,"Total",{"$f":"SUM(C10:C11)","v":{"$error":"#REF!"}},{"$f":"SUM(D10:D11)","v":{"$error":"#REF!"}},{"$f":"IF(C12=D12,\"equal\",\"not equal!\")","v":{"$error":"#REF!"}}]
[]
[]
[null,"If the subtotals do not equal each other, the most likely problem is on the"]
[null,"detail sheet.  All required entries may not have been entered."]

{"sheet":"Other","index":7,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Report Type",null,null,"Budget Object",null,null,null,"Grantee Org Code","Grantee Name","Funds Awarded"]
["Original Budget",null,null,"Instructional Program - Salaries (0100)"]
["Revised Budget",null,null,"Instructional Program - Employee Benefits (0200)"]
["Annual Financial Report",null,null,"Instructional Program - Purchased Professional & Technical Services (0300)"]
["Revised Annual Financial Report",null,null,"Instructional Program - Other Purchased Services (0500)"]
[null,null,null,"Instructional Program - Travel, Registration and Entrance (0580)"]
[null,null,null,"Instructional Program - Supplies (0600)"]
[null,null,null,"Instructional Program - Equipment - Non Capitalized (0735)"]
[null,null,null,"Support Program - Salaries (0100)"]
[null,null,null,"Support Program - Employee Benefits (0200)"]
[null,null,null,"Support Program - Purchased Professional & Technical Services (0300)"]
[null,null,null,"Support Program - Other Purchased Services (0500)"]
[null,null,null,"Support Program - Travel, Registration and Entrance (0580)"]
[null,null,null,"Support Program - Supplies (0600)"]
[null,null,null,"Support Program - Equipment - Non Capitalized (0735)"]
[]
[]
[]
[]
[null,null,null,"C"]
[null,null,null,"K"]