{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["1-Instructions","2-Cover Page","3-Budget Detail","4-Equipment","5a-Budget Summary","5b-Match","6a-AFR Expenditure Detail","6b-AFR Equipment Detail","7-Annual Financial Report","8-Error Checking","Other"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":23,"comments":2,"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":22,"n_cols":3,"rows_kept":22,"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"]
["FY2015-16"]
[]
[null,"Grantee Name:"]
[]
[null,"Budget Report:","Original Budget"]
[null,"Revision number:"]
[null,"Date:","2015-10-01"]
[]
[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","Request- Year 6","Approved-Year 6"]
["Total Budgeted",{"$f":"'5a-Budget Summary'!C28","v":0}]

{"sheet":"3-Budget Detail","index":2,"n_rows":5,"n_cols":7,"rows_kept":5,"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":"2015-10-01"}]
[1,2,3,4,5,6,7]
["Budget Object","Project\nNumber/Budget Year","Original Budgeted Cost","Budget Revision #1","Budget Revision #2","Description/Budget Narrative","Expected Date of Completion"]

{"sheet":"4-Equipment","index":3,"n_rows":5,"n_cols":9,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,8],[1,0,1,8]]}
[{"$f":"'2-Cover Page'!A1:G1","v":"Title V State Abstinence Education Grant Program"}]
["EQUIPMENT REQUEST AND INVENTORY"]
[{"$f":"+'2-Cover Page'!C4","v":0},null,null,null,null,null,null,null,{"$f":"'2-Cover Page'!C8","v":"2015-10-01"}]
[1,2,3,4,null,5,6,7]
["Description of item","Serial\nNumber","Date\nAcquired","Budgeted Cost","Budget Revision","Budget Year","Capitalized","Describe Use of Equipment","Expected Date\nof Completion"]

{"sheet":"5a-Budget Summary","index":4,"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 2015-16"]
[null,null,null,null,null,{"$f":"'2-Cover Page'!C8","v":"2015-10-01"}]
["Line","DESCRIPTION","Year 6","Year 7","Year 8","Total"]
["INSTRUCTIONAL PROGRAM"]
[1,"Salaries (0100)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"instructional program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"instructional program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"instructional program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"+SUM(C7:E7)","v":0}]
[2,"Employee Benefits (0200)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"+SUM(C8:E8)","v":0}]
[3,"Purchased Professional & Technical Services (0300)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},0]
[4,"Other Purchased Services (0500)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$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)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},0]
[6,"Supplies (0600)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"Instructional Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},0]
[7,"Subtotal-Instructional Program",{"$f":"SUM(C7:C12)","v":0},0,0,0]
[]
["SUPPORT PROGRAM"]
[8,"Salaries (0100)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support program - salaries (0100)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"+SUM(C16:E16)","v":0}]
[9,"Employee Benefits (0200)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Employee Benefits (0200)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},0]
[10,"Purchased Professional & Technical Services (0300)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Purchased Professional & Technical Services (0300)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},0]
[11,"Other Purchased Services (0500)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Other Purchased Services (0500)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},0]
[12,"Travel, Registration, and Entrance (0580)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Travel, Registration and Entrance (0580)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},0]
[13,"Supplies (0600)",{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$700=\"year 6\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$700=\"year 2\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},{"$f":"SUM(('3-Budget Detail'!$A$6:$A$700=\"support Program - Supplies (0600)\")*('3-Budget Detail'!$B$6:$B$700=\"year 3\")*(IF(ISBLANK('3-Budget Detail'!$E$6:$E$700),IF(ISBLANK('3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$C$6:$C$700,'3-Budget Detail'!$D$6:$D$700),'3-Budget Detail'!$E$6:$E$700)))","v":0},0]
[14,"Subtotal- Support Program",{"$f":"SUM(C16:C21)","v":0},0,0,0]
[15,"Grand Total - Instructional and Support Programs",{"$f":"+C22+C13","v":0},0,0,0]
[16,"Non-Capital Equipment (0735)",{"$f":"+SUM(('4-Equipment'!$F$6:$F$300=\"year 6\")*('4-Equipment'!$G$6:$G$300=\"non-capitalized\")*IF(ISBLANK('4-Equipment'!$E$6:$E$300),'4-Equipment'!$D$6:$D$300,'4-Equipment'!$E$6:$E$300))","v":0},{"$f":"+SUM(('4-Equipment'!$F$6:$F$300=\"year 2\")*('4-Equipment'!$G$6:$G$300=\"non-capitalized\")*IF(ISBLANK('4-Equipment'!$E$6:$E$300),'4-Equipment'!$D$6:$D$300,'4-Equipment'!$E$6:$E$300))","v":0},{"$f":"+SUM(('4-Equipment'!$F$6:$F$300=\"year 3\")*('4-Equipment'!$G$6:$G$300=\"non-capitalized\")*IF(ISBLANK('4-Equipment'!$E$6:$E$300),'4-Equipment'!$D$6:$D$300,'4-Equipment'!$E$6:$E$300))","v":0},{"$f":"+SUM(C24:E24)","v":0}]
[20,"Capital Equipment (0730)",{"$f":"+SUM(('4-Equipment'!$F$6:$F$300=\"year 6\")*('4-Equipment'!$G$6:$G$300=\"capitalized\")*IF(ISBLANK('4-Equipment'!$E$6:$E$300),'4-Equipment'!$D$6:$D$300,'4-Equipment'!$E$6:$E$300))","v":0},{"$f":"+SUM(('4-Equipment'!$F$6:$F$300=\"year 2\")*('4-Equipment'!$G$6:$G$300=\"capitalized\")*IF(ISBLANK('4-Equipment'!$E$6:$E$300),'4-Equipment'!$D$6:$D$300,'4-Equipment'!$E$6:$E$300))","v":0},{"$f":"+SUM(('4-Equipment'!$F$6:$F$300=\"year 3\")*('4-Equipment'!$G$6:$G$300=\"capitalized\")*IF(ISBLANK('4-Equipment'!$E$6:$E$300),'4-Equipment'!$D$6:$D$300,'4-Equipment'!$E$6:$E$300))","v":0},{"$f":"+SUM(C25:E25)","v":0}]
[null,"Indirect Rate"]
[null,"Indirect Calculation",{"$f":"SUM(C7+C16)*C26","v":0},{"$f":"D23*D26","v":0},0,{"$f":"C27","v":0}]
[21,"Total - Lines 15 and 16",{"$f":"+C23+C25+C27","v":0},{"$f":"+D23+D25+D27","v":0},0,0]

{"sheet":"5b-Match","index":5,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[6,1,6,2],[7,1,7,2],[0,0,0,6],[1,0,1,6]]}
[{"$f":"'3-Budget Detail'!A1:G1","v":"Title V State Abstinence Education Grant Program"}]
["FY 2015-2016"]
[]
[]
[" "]
["Identify the sources and amounts/values of your local match:"]
[null,"Dollar Amount/ or Value",null,"(C) A S H   -  Match expenditures paid from other funding sources."]
[null,"or In-Kind",null,"IN-(K)IND   -  Match expenditures, e.g. volunteer sources."]
["Source","Budget","Actual",null,"In - Kind Description"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total Cash (C)",{"$f":"SUMIF($D10:$D26,\"C\",$B$10:$B$26)","v":0},{"$f":"SUMIF($D9:$D26,$D27,C9:C26)","v":0}]
["Total In-Kind (K)",{"$f":"SUMIF($D10:$D26,\"K\",B10:B26)","v":0},{"$f":"SUMIF($D10:$D27,$D28,C10:C27)","v":0}]
["Total Cash and In-Kind Match",{"$f":"+B28+B27","v":0},{"$f":"+C28+C27","v":0}]
["Percentage of Program's Total FY15-16 Budget",{"$f":"B29/'5a-Budget Summary'!C28","v":{"$error":"#DIV/0!"}},0]

{"sheet":"6a-AFR Expenditure Detail","index":6,"n_rows":5,"n_cols":5,"rows_kept":5,"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":"2015-10-01"}]
[1,2,null,3,4]
["Budget Object","Budget Year","Cost","Description/Budget Narrative","Expected Date of Completion"]

{"sheet":"6b-AFR Equipment Detail","index":7,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
[{"$f":"'6a-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":"2015-10-01"}]
[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":"7-Annual Financial Report","index":8,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[13,1,13,2],[22,1,22,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,"Year 6",null,"Year 7",null,"Year 8"]
[null,"Instructional Program",null,"Budget","Actual Expenditures","Budget","Actual Expenditures","Budget","Actual Expenditures"]
[null,1,"Salaries (0100)",{"$f":"+'5a-Budget Summary'!C7","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0100)insyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D7","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0100)insyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E7","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0100)insyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,2,"Employee Benefits (0200)",{"$f":"+'5a-Budget Summary'!C8","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0200)insyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D8","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0200)insyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E8","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0200)insyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,3,"Purchased Professional & Technical Services (0300)",{"$f":"+'5a-Budget Summary'!C9","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0300)insyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D9","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0300)insyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E9","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0300)insyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,4,"Other Purchased Services (0500)",{"$f":"+'5a-Budget Summary'!C10","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0500)insyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D10","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0500)insyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E10","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0500)insyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,5,"Travel, Regristration & Entrance (0580)",{"$f":"+'5a-Budget Summary'!C11","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0580)insyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D11","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0580)insyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E11","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0580)insyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,6,"Supplies (0600)",{"$f":"+'5a-Budget Summary'!C12","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0600)insyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D12","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0600)insyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E12","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0600)insyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,7,"Subtotal Instructional Program",{"$f":"SUM(D15:D20)","v":0},{"$f":"SUM(E15:E20)","v":0},{"$f":"'5a-Budget Summary'!D13","v":0},{"$f":"SUM(G15:G20)","v":0},{"$f":"'5a-Budget Summary'!E13","v":0},{"$f":"SUM(I15:I20)","v":0}]
[]
[null,"Support Program"]
[null,8,"Salaries (0100)",{"$f":"+'5a-Budget Summary'!C16","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0100)supyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D16","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0100)supyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E16","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0100)supyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,9,"Employee Benefits (0200)",{"$f":"+'5a-Budget Summary'!C17","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0200)supyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D17","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0200)supyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E17","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0200)supyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,10,"Purchased Professional & Technical Services (0300)",{"$f":"+'5a-Budget Summary'!C18","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0300)supyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D18","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0300)supyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E18","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0300)supyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,11,"Other Purchased Services (0500)",{"$f":"+'5a-Budget Summary'!C19","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0500)supyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D19","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0500)supyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E19","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0500)supyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,12,"Travel, Regristration & Entrance (0580)",{"$f":"+'5a-Budget Summary'!C20","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0580)supyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D20","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0580)supyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E20","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0580)supyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,13,"Supplies (0600)",{"$f":"+'5a-Budget Summary'!C21","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0600)supyear 1\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!D21","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0600)supyear 2\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0},{"$f":"'5a-Budget Summary'!E21","v":0},{"$f":"SUM(IF(RIGHT('6a-AFR Expenditure Detail'!$A$6:$A$700,5)&LEFT('6a-AFR Expenditure Detail'!$A$6:$A$700,3)&RIGHT('6a-AFR Expenditure Detail'!$B$6:$B$700,6)=\"0600)supyear 3\",'6a-AFR Expenditure Detail'!$C$6:$C$700))","v":0}]
[null,14,"Subtotal Support Program",{"$f":"SUM(D24:D29)","v":0},0,0,0,0,0]
[]
[null,15,"Non-Capital Equipment (0735)",{"$f":"+'5a-Budget Summary'!C24","v":0},{"$f":"+SUM(IF(RIGHT('6b-AFR Equipment Detail'!$E$6:$E$300,6)&'6b-AFR Equipment Detail'!$F$6:$F$300=\"year 1non-capitalized\",'6b-AFR Equipment Detail'!$D$6:$D$300))","v":0},{"$f":"'5a-Budget Summary'!D24","v":0},{"$f":"+SUM(IF(RIGHT('6b-AFR Equipment Detail'!$E$6:$E$300,6)&'6b-AFR Equipment Detail'!$F$6:$F$300=\"year 2non-capitalized\",'6b-AFR Equipment Detail'!$D$6:$D$300))","v":0},{"$f":"'5a-Budget Summary'!E24","v":0},{"$f":"+SUM(IF(RIGHT('6b-AFR Equipment Detail'!$E$6:$E$300,6)&'6b-AFR Equipment Detail'!$F$6:$F$300=\"year 3non-capitalized\",'6b-AFR Equipment Detail'!$D$6:$D$300))","v":0}]
[null,16,"Capital Equipment (0730)",{"$f":"+'5a-Budget Summary'!C25","v":0},{"$f":"+SUM(IF(RIGHT('6b-AFR Equipment Detail'!$E$6:$E$300,6)&'6b-AFR Equipment Detail'!$F$6:$F$300=\"year 1capitalized\",'6b-AFR Equipment Detail'!$D$6:$D$300))","v":0},{"$f":"'5a-Budget Summary'!D25","v":0},{"$f":"+SUM(IF(RIGHT('6b-AFR Equipment Detail'!$E$6:$E$300,6)&'6b-AFR Equipment Detail'!$F$6:$F$300=\"year 2capitalized\",'6b-AFR Equipment Detail'!$D$6:$D$300))","v":0},{"$f":"'5a-Budget Summary'!E25","v":0},{"$f":"+SUM(IF(RIGHT('6b-AFR Equipment Detail'!$E$6:$E$300,6)&'6b-AFR Equipment Detail'!$F$6:$F$300=\"year 3capitalized\",'6b-AFR Equipment Detail'!$D$6:$D$300))","v":0}]
[]
[null,null,"Indirect Cost",0.25]
[null,null,"Indirect Calculation ",{"$f":"SUM(D15+D24)*D35","v":0}]
[]
[null,18,"Budget Total",{"$f":"D21+D30+D32+D33+D36","v":0},{"$f":"E21+E30+E32+E33","v":0},0,0,0,0]
[]
[]
[]
[]
[null,null,"Typed Name of Person Preparing Report","Date",null,"Signature of Grantee's Authorized Representative",null,null,"Date"]

{"sheet":"8-Error Checking","index":9,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"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":"2015-10-01"}]
[]
[]
[]
[null,null,"Detail Sheets","5-Budget Summary"]
[null,"3-Budget Detail",{"$f":"SUM(IF(ISBLANK('3-Budget Detail'!E6:E700),IF(ISBLANK('3-Budget Detail'!D6:D700),'3-Budget Detail'!C6:C700,'3-Budget Detail'!D6:D700),'3-Budget Detail'!E6:E700))","v":0},{"$f":"+'5a-Budget Summary'!C23+'5a-Budget Summary'!D23+'5a-Budget Summary'!E23","v":0},{"$f":"IF(C10=D10,\"equal\",\"not equal!\")","v":"equal"}]
[null,"4-Equipment",{"$f":"+SUM(IF(ISBLANK('4-Equipment'!E6:E300),'4-Equipment'!D6:D300,'4-Equipment'!E6:E300))","v":0},{"$f":"+'5a-Budget Summary'!F24+'5a-Budget Summary'!F25","v":0},{"$f":"IF(C11=D11,\"equal\",\"not equal!\")","v":"equal"}]
[null,"Total",{"$f":"SUM(C10:C11)","v":0},{"$f":"SUM(D10:D11)","v":0},{"$f":"IF(C12=D12,\"equal\",\"not equal!\")","v":"equal"}]
[]
[]
[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":10,"n_rows":19,"n_cols":4,"rows_kept":19,"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","Support Program - Salaries (0100)"]
["Project 4-Year 1",null,"Year 4","Support Program - Employee Benefits (0200)"]
["Project 5-Year 1",null,"Year 5","Support Program - Purchased Professional & Technical Services (0300)"]
["Project 1-Year 2",null,null,"Support Program - Other Purchased Services (0500)"]
["Project 2-Year 2",null,null,"Support Program - Travel, Registration and Entrance (0580)"]
["Project 3-Year 2",null,null,"Support Program - Supplies (0600)"]
["Project 4-Year 2"]
["Project 5-Year 2",null,null,"Non-Capitalized"]
["Project 1-Year 3",null,null,"Capitalized"]
["Project 2-Year 3"]
["Project 3-Year 3"]
["Project 4-Year 3",null,null,"C"]
["Project 5-Year 3",null,null,"K"]