{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["1-Instructions","2-Cover Page","3-Budget Detail","3a-Budget Summary","4-AFR Expenditure Detail","6b-AFR Equipment Detail","4a-Annual Financial Report","5-NOTES","8-Error Checking","Other"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":26,"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":81,"n_cols":1,"rows_kept":81,"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"]
["4-Annual Financial Report Expenditures Detail"]
["4a-Annual Financial Report"]
["5-NOTES"]
[]
["Only enter budget data on the 3-Budget Detail sheet for this RFA.  This data will link to the appropriate sheets."]
["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, Jennifer Austin: 303-866-6689 for assistance or e-mail the file with an explanation of the issues encountered to:  austin_j@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."]
[]
["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 Marti Rodriguez 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":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,0,23,6],[0,0,0,6],[1,0,1,6],[10,2,10,4],[11,2,11,4],[12,2,12,4],[22,0,22,6],[14,2,14,4],[15,2,15,4],[16,2,16,4]]}
["Title V State Sexual Risk Avoidance Education Grant Program"]
["January 1, 2020 - September 30, 2020"]
[null,"CFDA:  ",93.234999999999999,"STATE GRANT CODE:",7235]
[null,"Grantee Name:"]
[]
[null,"Budget Report:","Original Budget"]
[null,"Revision number:"]
[null,"Date:"]
[]
[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 :","Jennifer Austin: 303.866.6689 Austin_J@cde.state.co.us"]
[null,"Program Manager:","Benjie Blase: 303.866.6845 blase_b@cde.state.co.us"]
["CDE use only"]
["Funding Summary"]
["Project","Requested","Approved"]
["Total Budgeted"]

{"sheet":"3-Budget Detail","index":2,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,0,1,5]]}
[{"$f":"'2-Cover Page'!A1:G1","v":"Title V State Sexual Risk Avoidance Education Grant Program"}]
["BUDGET DETAIL"]
[{"$f":"+'2-Cover Page'!C4","v":0},null,null,null,null,{"$f":"'2-Cover Page'!C8","v":"00:00:00"}]
[1,2,3,4,5,6]
["Budget Object","Original Budgeted Cost","Budget Revision #1","Budget Revision #2","Description/Budget Narrative","Expected Date of Completion"]

{"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":"January 1, 2020 - September 30, 2020"}]
[]
[null,{"$f":"'2-Cover Page'!$C$4","v":0},null,{"$f":"'2-Cover Page'!C8","v":"00:00:00"}]
["Line","DESCRIPTION","Budget","Total"]
[null,"Amount Requested",null,{"$f":"SUM(C6)","v":0}]
[null,null,null,{"$f":"SUM(C7)","v":0}]
[null,"Total Available",{"$f":"SUM(C6:C7)","v":0},{"$f":"SUM(C8)","v":0}]
["INSTRUCTIONAL PROGRAM"]
[1,"Salaries (0100)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"instructional program - salaries (0100)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},{"$f":"+SUM(C10:C10)","v":0}]
[2,"Employee Benefits (0200)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Employee Benefits (0200)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[3,"Purchased Professional & Technical Services (0300)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Purchased Professional & Technical Services (0300)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[4,"Other Purchased Services (0500)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Other Purchased Services (0500)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[5,"Travel, Registration, and Entrance (0580)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Travel, Registration and Entrance (0580)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[6,"Supplies (0600)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Supplies (0600)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[7,"Non-Capital Equipment (0735)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"InSTRUCTIONAL program-Equipment - Non Capitalized (0735)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[8,"Subtotal-Instructional Program",{"$f":"SUM(C10:C16)","v":0},{"$f":"SUM(D10:D16)","v":0}]
[]
["SUPPORT PROGRAM"]
[9,"Salaries (0100)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support program - salaries (0100)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},{"$f":"+SUM(C20:C20)","v":0}]
[10,"Employee Benefits (0200)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Employee Benefits (0200)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[11,"Purchased Professional & Technical Services (0300)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Purchased Professional & Technical Services (0300)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[12,"Other Purchased Services (0500)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Other Purchased Services (0500)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[13,"Travel, Registration, and Entrance (0580)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Travel, Registration and Entrance (0580)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[14,"Supplies (0600)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Supplies (0600)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},0]
[15,"Non-Capital Equipment (0735)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Support Program-Equipment - Non Capitalized (0735)\")*(IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),IF(ISBLANK('3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$B$6:$B$700,'3-Budget Detail'!$C$6:$C$700),'3-Budget Detail'!$D$6:$D$700)))","v":0},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":"4-AFR Expenditure Detail","index":4,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,3]]}
[{"$f":"'2-Cover Page'!A1:G1","v":"Title V State Sexual Risk Avoidance Education Grant Program"}]
["AFR EXPENDITURE DETAIL"]
[null,null,null,{"$f":"'2-Cover Page'!C8","v":"00:00:00"}]
[1,2,3,4]
["Budget Object","Cost-Expanded to include cents","Description/Budget Narrative"," Date of Completion"]

{"sheet":"6b-AFR Equipment Detail","index":5,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7]]}
[{"$f":"'4-AFR Expenditure Detail'!A1:D1","v":"Title V State Sexual Risk Avoidance Education Grant Program"}]
["AFR EQUIPMENT REQUEST AND INVENTORY"]
[{"$f":"+'2-Cover Page'!C4","v":0},null,null,null,null,null,null,{"$f":"'2-Cover Page'!C8","v":"00:00:00"}]
[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":"4a-Annual Financial Report","index":6,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[10,1,10,2],[20,1,20,2],[0,0,0,8],[1,0,1,8],[3,0,3,1],[9,1,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[2,0,2,8]]}
[{"$f":"'6b-AFR Equipment Detail'!A1:H1","v":"Title V State Sexual Risk Avoidance Education Grant Program"}]
["ANNUAL FINANCIAL REPORT"]
[{"$f":"'2-Cover Page'!$A$2","v":"January 1, 2020 - September 30, 2020"}]
["Grantee Name:",null,{"$f":"'2-Cover Page'!C4","v":0}]
[]
[null,null,"Due November 1st of each year",null,null,null,null,"Revision #"]
[null,null,"Amount Requested",{"$f":"'3a-Budget Summary'!D6","v":0}]
[null,null,null,{"$f":"'3a-Budget Summary'!D7","v":0}]
[null,null,"Total Available",{"$f":"'3a-Budget Summary'!D8","v":0}]
[null,"Program Categories",null,"AFR",null,"Year 7",null,"Year 8"]
[null,"Instructional Program",null,"Budget","Actual Expenditures","Budget","Actual Expenditures","Budget","Actual Expenditures"]
[null,1,"Salaries (0100)",{"$f":"'3a-Budget Summary'!$C$10","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0100)ins\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0100)insyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0100)insyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,2,"Employee Benefits (0200)",{"$f":"'3a-Budget Summary'!C11","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0200)ins\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0200)insyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0200)insyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,3,"Purchased Professional & Technical Services (0300)",{"$f":"'3a-Budget Summary'!C12","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0300)ins\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0300)insyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0300)insyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,4,"Other Purchased Services (0500)",{"$f":"'3a-Budget Summary'!C13","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0500)ins\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0500)insyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0500)insyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,5,"Travel, Regristration & Entrance (0580)",{"$f":"'3a-Budget Summary'!C14","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0580)ins\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0580)insyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0580)insyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,6,"Supplies (0600)",{"$f":"'3a-Budget Summary'!C15","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0600)ins\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0600)insyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0600)insyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,7,"Instructional Program-Equipment - Non Capitalized (0735)",{"$f":"'3a-Budget Summary'!C16","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0735)ins\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0}]
[null,8,"Subtotal Instructional Program",{"$f":"SUM(D12:D18)","v":0},{"$f":"SUM(E12:E18)","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(G12:G17)","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(I12:I17)","v":{"$error":"#REF!"}}]
[]
[null,"Support Program"]
[null,9,"Salaries (0100)",{"$f":"'3a-Budget Summary'!C20","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0100)sup\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0100)supyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0100)supyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,10,"Employee Benefits (0200)",{"$f":"'3a-Budget Summary'!C21","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0200)sup\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0200)supyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0200)supyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,11,"Purchased Professional & Technical Services (0300)",{"$f":"'3a-Budget Summary'!C22","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0300)sup\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0300)supyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0300)supyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,12,"Other Purchased Services (0500)",{"$f":"'3a-Budget Summary'!C23","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0500)sup\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0500)supyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0500)supyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,13,"Travel, Regristration & Entrance (0580)",{"$f":"'3a-Budget Summary'!C24","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0580)sup\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0580)supyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0580)supyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,14,"Supplies (0600)",{"$f":"'3a-Budget Summary'!C25","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0600)sup\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0600)supyear 2\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('4-AFR Expenditure Detail'!#REF!,6)=\"0600)supyear 3\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":{"$error":"#REF!"}}]
[null,15,"Support Program-Equipment - Non Capitalized (0735)",{"$f":"'3a-Budget Summary'!C26","v":0},{"$f":"SUM(IF(RIGHT('4-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('4-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0735)sup\",'4-AFR Expenditure Detail'!$B$6:$B$700))","v":0}]
[null,16,"Subtotal Support Program",{"$f":"SUM(D22:D28)","v":0},{"$f":"SUM(E22:E28)","v":0},{"$f":"SUM(F22:F27)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,17,"Indirect Cost",{"$f":"'3a-Budget Summary'!C29","v":0}]
[null,18,"Indirect Calculation ",{"$f":"'3a-Budget Summary'!C30","v":0}]
[]
[null,19,"Budget Total/Expenditures",{"$f":"D31+D29+D19","v":0},{"$f":"E31+E29+E19","v":0},{"$f":"F19+F29+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"G19+G29+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"H19+H29+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"I19+I29+#REF!+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Print Name of Person Preparing Report","Date",null,"Signature of Grantee's Authorized Representative",null,null,"Date"]
[]
[]
[]
[null,null,"Signature of Executive Director/President/CEO","Date"]

{"sheet":"5-NOTES","index":7,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'4a-Annual Financial Report'!A1","v":"Title V State Sexual Risk Avoidance Education Grant Program"}]
[]
[]
[{"$f":"'4a-Annual Financial Report'!A4","v":"Grantee Name:"},{"$f":"'4a-Annual Financial Report'!A3","v":"January 1, 2020 - September 30, 2020"}]
[]
[]
["Date","Notes"]

{"sheet":"8-Error Checking","index":8,"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":0}]
[]
[null,null,"Error Checking"]
[null,null,"Title V State Absitnence Grant",null,null,{"$f":"'2-Cover Page'!C8","v":"00:00:00"}]
[]
[]
[]
[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":9,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["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)"]
["Project 1-Year 1",null,"Year 6","Instructional Program - Travel, Registration and Entrance (0580)"]
["Project 2-Year 1",null,"Year 2","Instructional Program - Supplies (0600)"]
["Project 3-Year 1",null,"Year 3","Instructional Program-Equipment - Non Capitalized (0735)"]
["Project 4-Year 1",null,"Year 4","Support Program - Salaries (0100)"]
["Project 5-Year 1",null,"Year 5","Support Program - Employee Benefits (0200)"]
["Project 1-Year 2",null,null,"Support Program - Purchased Professional & Technical Services (0300)"]
["Project 2-Year 2",null,null,"Support Program - Other Purchased Services (0500)"]
["Project 3-Year 2",null,null,"Support Program - Travel, Registration and Entrance (0580)"]
["Project 4-Year 2",null,null,"Support Program - Supplies (0600)"]
["Project 5-Year 2",null,null,"Support Program-Equipment - Non Capitalized (0735)"]
["Project 1-Year 3"]
["Project 2-Year 3"]
["Project 3-Year 3"]
["Project 4-Year 3"]
["Project 5-Year 3",null,null,"C"]
[null,null,null,"K"]