{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["1-Instructions","2-Cover Page","3-Budget Detail","3a-Budget Summary","4-Match Detail","4a-Match Summary","5-AFR Expenditure Detail","6b-AFR Equipment Detail","6-Annual Financial Report","NOTES","8-Error Checking","Other"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":34,"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":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"2-Cover Page","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[19,0,19,6],[0,0,0,6],[1,0,1,6],[10,2,10,4],[11,2,11,4],[12,2,12,4],[18,0,18,6]]}
["Title V State Abstinence Education Grant Program"]
["FY2016-17"]
[null,"CFDA:  ",93.234999999999999,"STATE GRANT CODE:",7235]
[null,"Grantee Name:"]
[]
[null,"Budget Report:"]
[null,"Revision number:"]
[null,"Date:"]
[]
[null,"Name of person completing this information"]
[null,"Name:"]
[null,"Phone No.:"]
[null,"E-mail:"]
[]
[null,"Submit this excel file to :","Benjie Blase: 303.866.6845 blase_b@cde.state.co.us"]
[null,"Grants Fiscal Staff Contact :","Marti Rodriguez: 303-866-6769 rodriguez_m@cde.state.co.us"]
[null,null,"Brittany Shores: 303-866-6911 shores_b@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",{"$f":"'3a-Budget Summary'!$F$28","v":0}]
["Match Budgeted",{"$f":"'4a-Match Summary'!$C$28","v":0}]

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

{"sheet":"3a-Budget Summary","index":3,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[null,"Title V State Abstinence Education Grant Program"]
[null,"BUDGET SUMMARY"]
[null,"FY 2016-17"]
[null,null,null,null,null,{"$f":"'2-Cover Page'!C8","v":"00:00:00"}]
["Line","DESCRIPTION","Budget","Year 7","Year 8","Total"]
["INSTRUCTIONAL PROGRAM"]
[1,"Salaries (0100)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"instructional program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"instructional program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"instructional program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"+SUM(C7:E7)","v":0}]
[2,"Employee Benefits (0200)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"+SUM(C8:E8)","v":0}]
[3,"Purchased Professional & Technical Services (0300)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[4,"Other Purchased Services (0500)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[5,"Travel, Registration, and Entrance (0580)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[6,"Supplies (0600)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[7,"Non-Capital Equipment (0735)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"InSTRUCTIONAL program-Equipment - Non Capitalized (0735)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"+SUM((#REF!=\"year 2\")*(#REF!=\"non-capitalized\")*IF(ISBLANK(#REF!),#REF!,#REF!))","v":{"$error":"#REF!"}},{"$f":"+SUM((#REF!=\"year 3\")*(#REF!=\"non-capitalized\")*IF(ISBLANK(#REF!),#REF!,#REF!))","v":{"$error":"#REF!"}},{"$f":"C23","v":0}]
[8,"Subtotal-Instructional Program",{"$f":"SUM(C7:C13)","v":0},{"$f":"SUM(D7:D12)","v":0},0,{"$f":"SUM(F7:F13)","v":0}]
[]
["SUPPORT PROGRAM"]
[9,"Salaries (0100)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"+SUM(C17:E17)","v":0}]
[10,"Employee Benefits (0200)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[11,"Purchased Professional & Technical Services (0300)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[12,"Other Purchased Services (0500)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[13,"Travel, Registration, and Entrance (0580)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[14,"Supplies (0600)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[15,"Non-Capital Equipment (0735)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Support Program-Equipment - Non Capitalized (0735)\")*('3-Budget Detail'!$B$6:$B$695=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"+SUM((#REF!=\"year 2\")*(#REF!=\"non-capitalized\")*IF(ISBLANK(#REF!),#REF!,#REF!))","v":{"$error":"#REF!"}},{"$f":"+SUM((#REF!=\"year 3\")*(#REF!=\"non-capitalized\")*IF(ISBLANK(#REF!),#REF!,#REF!))","v":{"$error":"#REF!"}},{"$f":"C23","v":0}]
[16,"Subtotal- Support Program",{"$f":"SUM(C17:C23)","v":0},{"$f":"SUM(D17:D22)","v":0},0,{"$f":"SUM(F17:F23)","v":0}]
[17,"Total - Instructional and Support Programs",{"$f":"C14+C24","v":0},{"$f":"+D24+D14","v":0},0,{"$f":"F14+F24","v":0}]
[18,"Indirect Rate"]
[19,"Indirect Calculation",{"$f":"SUM(C7+C17)*C26","v":0},{"$f":"D25*D26","v":0},{"$f":"E25*E26","v":0},{"$f":"C27","v":0}]
[20,"GRAND TOTAL",{"$f":"C25+C27","v":0},{"$f":"+D25+#REF!+D27","v":{"$error":"#REF!"}},{"$f":"+E25+#REF!+E27","v":{"$error":"#REF!"}},{"$f":"F25+F27","v":0}]

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

{"sheet":"4a-Match Summary","index":5,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,1,0,5],[1,1,1,5],[2,1,2,5]]}
[null,"Title V State Abstinence Education Grant Program"]
[null,"MATCH SUMMARY"]
[null,"FY 2016-17"]
[null,null,null,null,null,{"$f":"'2-Cover Page'!C8","v":"00:00:00"}]
["Line","DESCRIPTION","MATCH","Year 7","Year 8","Total"]
["INSTRUCTIONAL PROGRAM"]
[1,"Salaries (0100)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"instructional program - Salaries (0100)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"instructional program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"instructional program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"+SUM(C7:E7)","v":0}]
[2,"Employee Benefits (0200)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"instructional program - Employee Benefits (0200)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"+SUM(C8:E8)","v":0}]
[3,"Purchased Professional & Technical Services (0300)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"instructional program - Purchased Professional & Technical Services (0300)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[4,"Other Purchased Services (0500)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"instructional program - Other Purchased Services (0500)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[5,"Travel, Registration, and Entrance (0580)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"instructional program - Travel, Registration and Entrance (0580)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[6,"Supplies (0600)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"instructional program - Supplies (0600)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[7,"Non-Capital Equipment (0735)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"instructional program-Equipment - Non Capitalized (0735)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"Instructional Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"+SUM(C13:E13)","v":0}]
[8,"Subtotal-Instructional Program",{"$f":"SUM(C7:C13)","v":0},{"$f":"SUM(D7:D12)","v":0},0,{"$f":"SUM(F7:F13)","v":0}]
[]
["SUPPORT PROGRAM"]
[9,"Salaries (0100)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"Support program - salaries (0100)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"+SUM(C17:E17)","v":0}]
[10,"Employee Benefits (0200)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"Support program - Employee Benefits (0200)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[11,"Purchased Professional & Technical Services (0300)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"Support program - Purchased Professional & Technical Services (0300)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[12,"Other Purchased Services (0500)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"Support program - Other Purchased Services (0500)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[13,"Travel, Registration, and Entrance (0580)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"Support program - Travel, Registration and Entrance (0580)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[14,"Supplies (0600)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"Support program - Supplies (0600)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},0]
[15,"Non-Capital Equipment (0735)",{"$f":"SUM(('4-Match Detail'!$A$6:$A$700=\"Support Program - Equipment-Non Capitalized (0735)\")*('4-Match Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('4-Match Detail'!$E$6:$E$700),IF(ISBLANK('4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$C$6:$C$700,'4-Match Detail'!$D$6:$D$700),'4-Match Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$695=\"support Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$695=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$695),IF(ISBLANK('3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$C$6:$C$695,'3-Budget Detail'!$D$6:$D$695),'3-Budget Detail'!$E$6:$E$695)))","v":0},{"$f":"+SUM(C23:E23)","v":0}]
[16,"Subtotal- Support Program",{"$f":"SUM(C17:C23)","v":0},{"$f":"SUM(D17:D22)","v":0},0,{"$f":"SUM(F17:F23)","v":0}]
[17," Total - Instructional and Support Programs",{"$f":"C14+C24","v":0},{"$f":"+D24+D14","v":0},0,0]
[18,"Indirect Rate-Can only be charged if agency has a current approved Indirect Cost Rate with "]
[19,"Indirect Calculation",{"$f":"C25*C26","v":0},{"$f":"D25*D26","v":0},{"$f":"E25*E26","v":0},{"$f":"C27","v":0}]
[20,"Total",{"$f":"C25+C27","v":0},{"$f":"+D25+#REF!+D27","v":{"$error":"#REF!"}},{"$f":"+E25+#REF!+E27","v":{"$error":"#REF!"}},{"$f":"+F25+F27","v":0}]

{"sheet":"5-AFR Expenditure Detail","index":6,"n_rows":700,"n_cols":5,"rows_kept":700,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
[{"$f":"'2-Cover Page'!A1:G1","v":"Title V State Abstinence Education Grant Program"}]
["AFR EXPENDITURE DETAIL"]
[null,null,null,null,{"$f":"'2-Cover Page'!C8","v":"00:00:00"}]
[1,2,null,3,4]
["Budget Object","Budget Year","Cost","Description/Budget Narrative","Expected Date of Completion"]
["Instructional Program - Salaries (0100)","Year 6",55]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]
[null,"Year 6"]

{"sheet":"6b-AFR Equipment Detail","index":7,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[[0,0,0,7],[1,0,1,7]]}
[{"$f":"'5-AFR Expenditure Detail'!A1:E1","v":"Title V State Abstinence 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":"6-Annual Financial Report","index":8,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[[13,1,13,2],[23,1,23,2],[0,0,0,8],[1,0,1,8],[3,0,3,1],[12,1,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8]]}
[{"$f":"'6b-AFR Equipment Detail'!A1:H1","v":"Title V State Abstinence Education Grant Program"}]
["ANNUAL FINANCIAL REPORT"]
[null,null,null,null,null,null,null,null,"Date"]
["Grantee Name:",null,{"$f":"'2-Cover Page'!C4","v":0}]
[]
[null,null,"Due November 1st of each year",null,null,null,null,"Revision #"]
[]
[]
[]
[]
[]
[]
[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$7","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0100)ins\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":55},{"$f":"'4a-Match Summary'!D7","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0100)insyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E7","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0100)insyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,2,"Employee Benefits (0200)",{"$f":"'3a-Budget Summary'!C8","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0200)ins\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D8","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0200)insyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E8","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0200)insyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,3,"Purchased Professional & Technical Services (0300)",{"$f":"'3a-Budget Summary'!C9","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0300)ins\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D9","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0300)insyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E9","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0300)insyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,4,"Other Purchased Services (0500)",{"$f":"'3a-Budget Summary'!C10","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0500)ins\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D10","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0500)insyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E10","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0500)insyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,5,"Travel, Regristration & Entrance (0580)",{"$f":"'3a-Budget Summary'!C11","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0580)ins\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D11","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0580)insyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E11","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0580)insyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,6,"Supplies (0600)",{"$f":"'3a-Budget Summary'!C12","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0600)ins\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D12","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0600)insyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E12","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0600)insyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,7,"Instructional Program-Equipment - Non Capitalized (0735)",{"$f":"'3a-Budget Summary'!C13","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0735)ins\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,8,"Subtotal Instructional Program",{"$f":"SUM(D15:D21)","v":0},{"$f":"SUM(E15:E21)","v":55},{"$f":"'4a-Match Summary'!D14","v":0},{"$f":"SUM(G15:G20)","v":0},{"$f":"'4a-Match Summary'!E14","v":0},{"$f":"SUM(I15:I20)","v":0}]
[]
[null,"Support Program"]
[null,9,"Salaries (0100)",{"$f":"'3a-Budget Summary'!C17","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0100)sup\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D17","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0100)supyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E17","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0100)supyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,10,"Employee Benefits (0200)",{"$f":"'3a-Budget Summary'!C18","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0200)sup\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D18","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0200)supyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E18","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0200)supyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,11,"Purchased Professional & Technical Services (0300)",{"$f":"'3a-Budget Summary'!C19","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0300)sup\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D19","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0300)supyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E19","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0300)supyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,12,"Other Purchased Services (0500)",{"$f":"'3a-Budget Summary'!C20","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0500)sup\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D20","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0500)supyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E20","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0500)supyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,13,"Travel, Regristration & Entrance (0580)",{"$f":"'3a-Budget Summary'!C21","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0580)sup\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D21","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0580)supyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E21","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0580)supyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,14,"Supplies (0600)",{"$f":"'3a-Budget Summary'!C22","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0600)sup\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!D22","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0600)supyear 2\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'4a-Match Summary'!E22","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('5-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0600)supyear 3\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,15,"Support Program-Equipment - Non Capitalized (0735)",{"$f":"'3a-Budget Summary'!C23","v":0},{"$f":"SUM(IF(RIGHT('5-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('5-AFR Expenditure Detail'!$A$6:$A$700,3)=\"0735)sup\",'5-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,16,"Subtotal Support Program",{"$f":"SUM(D25:D31)","v":0},{"$f":"SUM(E25:E31)","v":0},{"$f":"SUM(F25:F30)","v":0},0,0,0]
[null,17,"Indirect Cost",{"$f":"'3a-Budget Summary'!C26","v":0}]
[null,18,"Indirect Calculation ",{"$f":"'3a-Budget Summary'!C27","v":0}]
[]
[null,19,"Budget Total/Expenditures",{"$f":"D34+D32+D22","v":0},{"$f":"E34+E32+E22","v":55},{"$f":"F22+F32+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"G22+G32+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"H22+H32+#REF!+#REF!","v":{"$error":"#REF!"}},{"$f":"I22+I32+#REF!+#REF!","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[null,null,"Typed Name of Person Preparing Report","Date",null,"Signature of Grantee's Authorized Representative",null,null,"Date"]

{"sheet":"NOTES","index":9,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'6-Annual Financial Report'!A1","v":"Title V State Abstinence Education Grant Program"}]
[]
[]
[{"$f":"'6-Annual Financial Report'!A4","v":"Grantee Name:"},{"$f":"'6-Annual Financial Report'!A3","v":0}]
[]
[]
["Date","Notes"]

{"sheet":"8-Error Checking","index":10,"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'!E6:E695),IF(ISBLANK('3-Budget Detail'!D6:D695),'3-Budget Detail'!C6:C695,'3-Budget Detail'!D6:D695),'3-Budget Detail'!E6:E695))","v":0},{"$f":"+'4a-Match Summary'!C25+'4a-Match Summary'!D25+'4a-Match Summary'!E25","v":0},{"$f":"IF(C10=D10,\"equal\",\"not equal!\")","v":"equal"}]
[null,"4-Equipment",{"$f":"+SUM(IF(ISBLANK(#REF!),#REF!,#REF!))","v":{"$error":"#REF!"}},{"$f":"+'4a-Match Summary'!F23+'4a-Match Summary'!#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":11,"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"]