{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Report 6","Report 7","Report 8","Report 9","Report Due Dates","INSTRUCTIONS "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"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":"Report 6","index":0,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[46,4,46,6],[47,4,47,6],[48,4,48,6],[49,4,49,6],[50,4,50,6],[45,4,45,6],[32,4,32,5],[32,6,32,7],[37,0,37,3],[37,4,37,5],[37,6,37,7],[40,0,40,5],[40,6,40,7],[32,0,32,3],[42,4,42,6],[43,4,43,6],[44,4,44,6],[32,8,32,9],[34,6,34,7],[34,8,34,9],[37,8,37,9],[35,0,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[36,0,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[57,0,57,7],[57,8,57,9],[51,4,51,6],[54,0,54,2],[54,4,54,8],[28,0,28,9],[55,0,55,9],[56,6,56,7],[56,8,56,9],[29,0,29,9],[33,0,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[34,0,34,3],[34,4,34,5],[30,0,30,9],[31,0,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[17,2,17,3],[19,0,19,9],[17,0,17,1],[21,0,21,6],[21,7,21,8],[17,4,17,5],[17,6,17,7],[17,8,17,9],[25,0,25,6],[25,7,25,8],[26,0,26,9],[22,0,22,9],[27,0,27,6],[27,7,27,8],[23,0,23,6],[23,7,23,8],[24,0,24,9],[15,6,15,7],[16,6,16,7],[15,4,15,5],[16,4,16,5],[14,2,14,3],[14,4,14,5],[15,2,15,3],[16,2,16,3],[14,6,14,7],[13,6,13,7],[7,4,7,6],[0,8,0,9],[1,8,1,9],[4,0,4,3],[6,0,6,3],[13,2,13,3],[13,4,13,5],[8,0,8,9],[10,0,10,9],[12,0,12,1],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[40,8,40,9],[38,0,38,3],[38,4,38,5],[38,6,38,7],[38,8,38,9],[39,0,39,3],[39,4,39,5],[39,6,39,7],[39,8,39,9]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    "]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 "]
["EXPENDITURE AND PROGRESS REPORT (Revised 12/2020)"]
[]
["MENTAL HEALTH TRAINING GRANT",null,null,null,null,"GRANTEE:","Kings County Sheriff"]
[]
["Contract Term: May 1, 2019 to September 30, 2021",null,null,null,null,"AGREEMENT #:","BSCC-0081-18-MH 001"]
[]
["EXPENDITURE AND PROGRESS REPORT #6    REPORTING PERIOD: 10/1/2020- 12/31/2020 DUE: January 15, 2021"]
[]
["EXPENDITURES"]
[]
["Total Grant Funds Disbursed",null,"Allowable Budget Categories",null,"Expenditures this \nReporting Period",null,"Prior Expenditures",null,"Grant Fund Balance"]
[null,null,"Tuition",null,0,null,4234]
[null,null,"Travel",null,0]
[null,null,"Per Diem",null,0]
[null,null,"Replacement",null,0,null,0]
[31590,null,null,null,{"$f":"SUM(E14:E17)","v":0},null,{"$f":"SUM(G14:H17)","v":4234},null,{"$f":"SUM(A18-E18-G18)","v":27356}]
[]
["TRAINING PROGRESS"]
[]
["1.  Total number of staff trained during this reporting period:",null,null,null,null,null,null,{"$f":"I41","v":0}]
[]
["2.  Total number of staff trained to date:",null,null,null,null,null,null,20]
[]
["3.  Total mental health training hours provided this reporting period (Course Hours x # of Staff Trained):",null,null,null,null,null,null,{"$f":"K41","v":0}]
[]
["4.  Total mental health training hours provided to date:",null,null,null,null,null,null,272]
[]
["5.  Training details for this reporting period. List details below for training that occurred during this reporting period"]
[]
[" Course Title",null,null,null,"Certification Number",null,"Course Hours",null,"Number of Staff Trained"]
["N/A",null,null,null,null,null,null,null,null,null,{"$f":"G33*I33","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"G34*I34","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["Totals",null,null,null,null,null,{"$f":"SUM(G33:H40)","v":0},null,{"$f":"SUM(I33:J40)","v":0},null,{"$f":"SUM(K33:K40)","v":0}]
[]
[null,null,null,null,"PERSON PREPARING REPORT"]
[]
[null,null,null,null,"Cassandra Bakker, Fiscal Analyst"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(559) 852-2820"]
[null,null,null,null,"Phone"]
[null,null,null,null,"cassandra.bakker@co.kings.ca.us"]
[null,null,null,null,"Email"]
[null,null,null,null,"2021-01-07"]
[null,null,null,null,"Date"]
[]
[null,null,"Email completed report to:  ",null,"BSCCmentalhealthgrant@bscc.ca.gov"]
[]
[]
[null,null,null,null,"BSCC USE ONLY","Date Received:"]

{"sheet":"Report 7","index":1,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[57,0,57,7],[57,8,57,9],[48,4,48,6],[49,4,49,6],[50,4,50,6],[51,4,51,6],[54,0,54,2],[54,4,54,8],[40,0,40,5],[40,6,40,7],[40,8,40,9],[55,0,55,9],[56,6,56,7],[56,8,56,9],[42,4,42,6],[43,4,43,6],[44,4,44,6],[45,4,45,6],[46,4,46,6],[47,4,47,6],[36,0,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[37,0,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[38,0,38,3],[38,4,38,5],[38,6,38,7],[38,8,38,9],[39,0,39,3],[39,4,39,5],[39,6,39,7],[39,8,39,9],[35,0,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[32,0,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[33,0,33,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[28,0,28,9],[34,0,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[29,0,29,9],[30,0,30,9],[31,0,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[25,0,25,6],[25,7,25,8],[26,0,26,9],[27,0,27,6],[27,7,27,8],[24,0,24,9],[17,0,17,1],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[19,0,19,9],[21,0,21,6],[21,7,21,8],[22,0,22,9],[23,0,23,6],[23,7,23,8],[14,2,14,3],[14,4,14,5],[14,6,14,7],[7,4,7,6],[8,0,8,9],[10,0,10,9],[12,0,12,1],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[0,8,0,9],[1,8,1,9],[4,0,4,3],[6,0,6,3],[13,2,13,3],[13,4,13,5],[13,6,13,7],[15,2,15,3],[15,4,15,5],[15,6,15,7],[16,2,16,3],[16,4,16,5],[16,6,16,7]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    "]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 "]
["EXPENDITURE AND PROGRESS REPORT (Revised 12/2020)"]
[]
["MENTAL HEALTH TRAINING GRANT",null,null,null,null,"GRANTEE:",{"$f":"('Report 6'!G5)","v":"Kings County Sheriff"}]
[]
["Contract Term: May 1, 2019 to September 30, 2021",null,null,null,null,"AGREEMENT #:",{"$f":"('Report 6'!G7)","v":"BSCC-0081-18-MH 001"}]
[]
["EXPENDITURE AND PROGRESS REPORT #7    REPORTING PERIOD: 1/1/2021 - 3/31/2021  DUE: April 15, 2021"]
[]
["EXPENDITURES"]
[]
["Total Grant Funds Disbursed",null,"Allowable Budget Categories",null,"Expenditures this \nReporting Period",null,"Prior Expenditures",null,"Grant Fund Balance"]
[null,null,"Tuition",null,0,null,{"$f":"SUM('Report 6'!E14:H14)","v":4234}]
[null,null,"Travel",null,0,null,{"$f":"SUM('Report 6'!E15:H15)","v":0}]
[null,null,"Per Diem",null,0,null,{"$f":"SUM('Report 6'!E16:H16)","v":0}]
[null,null,"Replacement",null,0,null,{"$f":"SUM('Report 6'!E17:H17)","v":0}]
[{"$f":"'Report 6'!A18:B18","v":31590},null,null,null,{"$f":"SUM(E14:E17)","v":0},null,{"$f":"SUM(G14:H17)","v":4234},null,{"$f":"SUM(A18-E18-G18)","v":27356}]
[]
["TRAINING PROGRESS"]
[]
["1.  Total number of staff trained during this reporting period:",null,null,null,null,null,null,{"$f":"I41","v":0}]
[]
["2.  Total number of staff trained to date:",null,null,null,null,null,null,{"$f":"SUM(H22+'Report 6'!H24:I24)","v":20}]
[]
["3.  Total mental health training hours provided this reporting period (Course Hours x # of Staff Trained):",null,null,null,null,null,null,{"$f":"K41","v":0}]
[]
["4.  Total mental health training hours provided to date:",null,null,null,null,null,null,{"$f":"SUM(H26+'Report 6'!H28:I28)","v":272}]
[]
["5.  Training details for this reporting period. List details below for training that occurred during this reporting period"]
[]
[" Course Title",null,null,null,"Certification Number",null,"Course Hours",null,"Number of Staff Trained"]
["N/A",null,null,null,null,null,null,null,null,null,{"$f":"G33*I33","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"G34*I34","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["Totals",null,null,null,null,null,{"$f":"SUM(G33:H40)","v":0},null,{"$f":"SUM(I33:J40)","v":0},null,{"$f":"SUM(K33:K40)","v":0}]
[]
[null,null,null,null,"PERSON PREPARING REPORT"]
[]
[null,null,null,null,"Cassandra Bakker, Fiscal Analyst"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(559) 852-2820"]
[null,null,null,null,"Phone"]
[null,null,null,null,"cassandra.bakker@co.kings.ca.us"]
[null,null,null,null,"Email"]
[null,null,null,null,"2021-04-07"]
[null,null,null,null,"Date"]
[]
[null,null,"Email completed report to:  ",null,"BSCCmentalhealthgrant@bscc.ca.gov"]
[]
[]
[null,null,null,null,"BSCC USE ONLY","Date Received:","2021-04-07"]

{"sheet":"Report 8","index":2,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[33,4,33,5],[33,6,33,7],[33,8,33,9],[57,0,57,7],[57,8,57,9],[48,4,48,6],[49,4,49,6],[50,4,50,6],[51,4,51,6],[54,0,54,2],[54,4,54,8],[55,0,55,9],[56,6,56,7],[56,8,56,9],[40,0,40,5],[40,6,40,7],[40,8,40,9],[39,8,39,9],[35,0,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[42,4,42,6],[43,4,43,6],[44,4,44,6],[45,4,45,6],[46,4,46,6],[47,4,47,6],[36,0,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[37,0,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[38,0,38,3],[38,4,38,5],[38,6,38,7],[38,8,38,9],[39,0,39,3],[39,4,39,5],[39,6,39,7],[28,0,28,9],[34,0,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[29,0,29,9],[30,0,30,9],[31,0,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[32,0,32,3],[32,4,32,5],[32,6,32,7],[32,8,32,9],[33,0,33,3],[25,0,25,6],[25,7,25,8],[26,0,26,9],[27,0,27,6],[27,7,27,8],[24,0,24,9],[17,0,17,1],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[19,0,19,9],[21,0,21,6],[21,7,21,8],[22,0,22,9],[23,0,23,6],[23,7,23,8],[14,2,14,3],[14,4,14,5],[14,6,14,7],[7,4,7,6],[8,0,8,9],[10,0,10,9],[12,0,12,1],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[0,8,0,9],[1,8,1,9],[4,0,4,3],[6,0,6,3],[13,2,13,3],[13,4,13,5],[13,6,13,7],[15,2,15,3],[15,4,15,5],[15,6,15,7],[16,2,16,3],[16,4,16,5],[16,6,16,7]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    "]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 "]
["EXPENDITURE AND PROGRESS REPORT (Revised 12/2020)"]
[]
["MENTAL HEALTH TRAINING GRANT",null,null,null,null,"GRANTEE:",{"$f":"('Report 6'!G5)","v":"Kings County Sheriff"}]
[]
["Contract Term: May 1, 2019 to September 30, 2021",null,null,null,null,"AGREEMENT #:",{"$f":"('Report 6'!G7)","v":"BSCC-0081-18-MH 001"}]
[]
["EXPENDITURE AND PROGRESS REPORT #8    REPORTING PERIOD: 4/1/2021 - 6/30/2021  DUE: July 15, 2021"]
[]
["EXPENDITURES"]
[]
["Total Grant Funds Disbursed",null,"Allowable Budget Categories",null,"Expenditures this \nReporting Period",null,"Prior Expenditures",null,"Grant Fund Balance"]
[null,null,"Tuition",null,4500,null,{"$f":"SUM('Report 7'!E14:H14)","v":4234}]
[null,null,"Travel",null,0,null,{"$f":"SUM('Report 7'!E15:H15)","v":0}]
[null,null,"Per Diem",null,0,null,{"$f":"SUM('Report 7'!E16:H16)","v":0}]
[null,null,"Replacement",null,0,null,{"$f":"SUM('Report 7'!E17:H17)","v":0}]
[{"$f":"'Report 6'!A18:B18","v":31590},null,null,null,{"$f":"SUM(E14:E17)","v":4500},null,{"$f":"SUM(G14:G17)","v":4234},null,{"$f":"SUM(A18-E18-G18)","v":22856}]
[]
["TRAINING PROGRESS"]
[]
["1.  Total number of staff trained during this reporting period:",null,null,null,null,null,null,{"$f":"I41","v":30}]
[]
["2.  Total number of staff trained to date:",null,null,null,null,null,null,{"$f":"SUM(H22+'Report 7'!H24:I24)","v":50}]
[]
["3.  Total mental health training hours provided this reporting period (Course Hours x # of Staff Trained):",null,null,null,null,null,null,{"$f":"K41","v":240}]
[]
["4.  Total mental health training hours provided to date:",null,null,null,null,null,null,{"$f":"SUM(H26+'Report 7'!H28:I28)","v":512}]
[]
["5.  Training details for this reporting period. List details below for training that occurred during this reporting period"]
[]
[" Course Title",null,null,null,"Certification Number",null,"Course Hours",null,"Number of Staff Trained"]
["Crisis Intervention Behavioral Health & De-Escalation & Tactical Communication Course",null,null,null,"00577473",null,8,null,30,null,{"$f":"G33*I33","v":240}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"G34*I34","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["Totals",null,null,null,null,null,{"$f":"SUM(G33:H40)","v":8},null,{"$f":"SUM(I33:J40)","v":30},null,{"$f":"SUM(K33:K40)","v":240}]
[]
[null,null,null,null,"PERSON PREPARING REPORT"]
[]
[null,null,null,null,"Cassandra Bakker, Fiscal Analyst"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(559) 852-2820"]
[null,null,null,null,"Phone"]
[null,null,null,null,"cassandra.bakker@co.kings.ca.us"]
[null,null,null,null,"Email"]
[null,null,null,null,"2021-07-06"]
[null,null,null,null,"Date"]
[]
[null,null,"Email completed report to:  ",null,"BSCCmentalhealthgrant@bscc.ca.gov"]
[]
[]
[null,null,null,null,"BSCC USE ONLY","Date Received:","2021-07-06"]

{"sheet":"Report 9","index":3,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[[57,0,57,7],[57,8,57,9],[48,4,48,6],[49,4,49,6],[50,4,50,6],[51,4,51,6],[54,0,54,2],[54,4,54,8],[40,0,40,5],[40,6,40,7],[40,8,40,9],[55,0,55,9],[56,6,56,7],[56,8,56,9],[42,4,42,6],[43,4,43,6],[44,4,44,6],[45,4,45,6],[46,4,46,6],[47,4,47,6],[36,0,36,3],[36,4,36,5],[36,6,36,7],[36,8,36,9],[37,0,37,3],[37,4,37,5],[37,6,37,7],[37,8,37,9],[38,0,38,3],[38,4,38,5],[38,6,38,7],[38,8,38,9],[39,0,39,3],[39,4,39,5],[39,6,39,7],[39,8,39,9],[28,0,28,9],[29,0,29,9],[30,0,30,9],[31,0,31,3],[31,4,31,5],[31,6,31,7],[31,8,31,9],[23,7,23,8],[25,0,25,6],[25,7,25,8],[26,0,26,9],[27,0,27,6],[27,7,27,8],[32,8,32,9],[33,8,33,9],[14,2,14,3],[14,4,14,5],[14,6,14,7],[24,0,24,9],[17,0,17,1],[17,2,17,3],[17,4,17,5],[17,6,17,7],[17,8,17,9],[19,0,19,9],[21,0,21,6],[21,7,21,8],[22,0,22,9],[23,0,23,6],[34,8,34,9],[35,0,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[34,0,34,3],[34,4,34,5],[34,6,34,7],[0,8,0,9],[1,8,1,9],[4,0,4,3],[6,0,6,3],[13,2,13,3],[13,4,13,5],[13,6,13,7],[7,4,7,6],[8,0,8,9],[10,0,10,9],[12,0,12,1],[12,2,12,3],[12,4,12,5],[12,6,12,7],[12,8,12,9],[32,0,32,3],[32,4,32,5],[32,6,32,7],[33,0,33,3],[33,4,33,5],[33,6,33,7],[15,2,15,3],[15,4,15,5],[15,6,15,7],[16,2,16,3],[16,4,16,5],[16,6,16,7]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    "]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 "]
["EXPENDITURE AND PROGRESS REPORT (Revised 12/2020)"]
[]
["MENTAL HEALTH TRAINING GRANT",null,null,null,null,"GRANTEE:",{"$f":"('Report 6'!G5)","v":"Kings County Sheriff"}]
[]
["Contract Term: May 1, 2019 to September 30, 2021",null,null,null,null,"AGREEMENT #:",{"$f":"('Report 6'!G7)","v":"BSCC-0081-18-MH 001"}]
[]
["EXPENDITURE AND PROGRESS REPORT #9 REPORTING PERIOD: 7/1/2021- 9/30/2021  DUE: OCTOBER 15, 2021"]
[]
["EXPENDITURES"]
[]
["Total Grant Funds Disbursed",null,"Allowable Budget Categories",null,"Expenditures this \nReporting Period",null,"Prior Expenditures",null,"Grant Fund Balance"]
[null,null,"Tuition",null,0,null,{"$f":"SUM('Report 8'!E14:H14)","v":8734}]
[null,null,"Travel",null,0,null,{"$f":"SUM('Report 8'!E15:H15)","v":0}]
[null,null,"Per Diem",null,0,null,{"$f":"SUM('Report 8'!E16:H16)","v":0}]
[null,null,"Replacement",null,null,null,{"$f":"SUM('Report 8'!E17:H17)","v":0}]
[{"$f":"'Report 6'!A18:B18","v":31590},null,null,null,{"$f":"SUM(E14:E17)","v":0},null,{"$f":"SUM(G14:H17)","v":8734},null,{"$f":"SUM(A18-E18-G18)","v":22856}]
[]
["TRAINING PROGRESS"]
[]
["1.  Total number of staff trained during this reporting period:",null,null,null,null,null,null,{"$f":"I41","v":0}]
[]
["2.  Total number of staff trained to date:",null,null,null,null,null,null,{"$f":"SUM(H22+'Report 8'!H24:I24)","v":50}]
[]
["3.  Total mental health training hours provided this reporting period (Course Hours x # of Staff Trained):",null,null,null,null,null,null,{"$f":"K41","v":0}]
[]
["4.  Total mental health training hours provided to date:",null,null,null,null,null,null,{"$f":"SUM(H26+'Report 8'!H28:I28)","v":512}]
[]
["5.  Training details for this reporting period. List details below for training that occurred during this reporting period"]
[]
[" Course Title",null,null,null,"Certification Number",null,"Course Hours",null,"Number of Staff Trained"]
["N/A",null,null,null,null,null,null,null,null,null,{"$f":"G33*I33","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"G34*I34","v":0}]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0]
["Totals",null,null,null,null,null,{"$f":"SUM(G33:H40)","v":0},null,{"$f":"SUM(I33:J40)","v":0},null,{"$f":"SUM(K33:K40)","v":0}]
[]
[null,null,null,null,"PERSON PREPARING REPORT"]
[]
[null,null,null,null,"Cassandra Bakker, Fiscal Analyst"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(559) 852-2820"]
[null,null,null,null,"Phone"]
[null,null,null,null,"cassandra.bakker@co.kings.ca.us"]
[null,null,null,null,"Email"]
[null,null,null,null,"2021-10-01"]
[null,null,null,null,"Date"]
[]
[null,null,"Email completed report to:  ",null,"BSCCmentalhealthgrant@bscc.ca.gov"]
[]
[]
[null,null,null,null,"BSCC USE ONLY","Date Received:","2021-10-01"]

{"sheet":"Report Due Dates","index":4,"n_rows":6,"n_cols":3,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Report #","Reporting Period ","Due Date"]
[6,"October 1, 2020 to December 31, 2020","2021-01-15"]
[7,"January 1, 2021 to March 31, 2021","2021-04-15"]
[8,"April 1, 2021 to June 30, 2021","2021-07-15"]
[9,"July 1, 2021 to September 30, 2021","2021-10-15"]
[null,"Final Summary Report"]

{"sheet":"INSTRUCTIONS ","index":5,"n_rows":48,"n_cols":1,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Expenditure and Progress Report Workbook - User Instructions"]
[]
["How to Locate the Expenditure and Progress Report Workbook"]
["Workbooks are located on the Board of State and Community Corrections (BSCC) website on the Mental Health Training Grant webpage: https://www.bscc.ca.gov/mental-health-training-grant-jag/."]
[]
["On the Mental Health Training Grant webpage, locate the link for Expenditure and Progress Reports. Click the link and locate the workbook for your agency."]
[]
["How to Save the Expenditure and Progress Report Workbook"]
["Right click on the file and select Save Link as. This will navigate the grantee to their computer files. The grantee shall navigate to a folder where they would like to save their Expenditure and Progress Report Workbook. Do not rename the file. "]
[]
["The grantee should then exit the web browser and work directly from the saved file."]
[]
["Prior to each reporting period, it is the grantee’s responsibility to download and save the Workbook to their local computer. "]
[]
["Forms Included in the Invoice Workbook "]
["The Expenditure and Progress Report Workbook is an Excel file arranged by worksheet tabs (located along the bottom). The tabs included in the Invoice workbook are listed below:"]
["·         An Expenditure and Progress Report for each reporting period, i.e., Report 1, Report 2, etc.; and"]
["·         A schedule of Reporting Due Dates; "]
["·         Instructions"]
[]
["Passwords and Formulas in the Invoice Workbook"]
["Each time the grantee opens the Expenditure and Progress Report workbook, they will be prompted to enter a password. The password is the grant agreement number (e.g. 990-19)."]
[]
[" The Expenditure and Progress ReportWorkbook has specific functions which require macros to be enabled. A macro is a series of commands, such as calculations, that are stored within the document for tasks performed repeatedly. In most cases, Excel will prompt the grantee to enable macros. When this prompt appears, select Enable Editing then Enable Content. Enabling macros for the Invoice Workbook will not compromise the security of the local system nor the security of the agency's network."]
[]
["Expenditure and Progress Report Form"]
[]
["How to Complete an Expenditure and Progress Report"]
["Each Expenditure and Progress Report has a separate workbook tab titled, Report #. The Expenditure and Progress Report will allow grantees to enter data into green shaded cells in the Expenditure Section and in unshaded (white) cells in the Training Progress Section; all other fields are locked. "]
[]
[]
["EXPENDITURE REPORT"]
["a. The grantee shall enter the line item (tuition, travel, per diem, replacement) expenditures incurred during the reporting period."]
["b. All expenditures should be rounded to the nearest whole dollar; do not enter decimals."]
[]
["TRAINING PROGRESS REPORT"]
["a. All cells in Sections 1-4 are locked and will auto-populate based on the details entered in Section 5.\nb. Section 5: List the couse title, certification number, number of course hours and total staff trained for each grant-related training course delivered during the reporting period."]
[]
[" PERSON PREPARING REPORT"]
["a. The grantee will designate an individual to prepare reports. "]
["b. The individual who prepares reports will provide their contact information and the date the report was prepared under the PERSON PREPARING REPORT section. "]
[]
["SUBMITTING THE COMPLETED REPORT"]
["a.  Complete the \"Person Preparing Report\" Section at the bottom of the report"]
["b.  Email completed report to:  BSCCmentalhealthgrant@bscc.ca.gov"]
[]
["Approved Expenditure and Progress Report "]
["Once BSCC staff reviews and approves the Expenditure and Progress Report, an updated workbook will be available on the BSCC website. All approved Expenditure and Progress Reports will be locked from editing but will be viewable in the workbook."]