{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["1st Advance Payment","INVOICE 1","INVOICE 2","INVOICE 3","INVOICE 4","INVOICE 5","INVOICE 6","2nd Advance Payment","INVOICE 7","INVOICE 8","MOD 1","INVOICE 9","INVOICE 10","INVOICE 11","INVOICE 12","INVOICE 13","INVOICE 14","INVOICE 15","3rd Advance Payment","MODIFICATION REQUEST"," Project Budget","INVOICE DUE DATES","INSTRUCTIONS "],"not_rendered":{"charts":0,"images":35,"macros":1,"external_links":0,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1st Advance Payment","index":0,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,2,30,4],[29,2,29,4],[0,5,2,7],[12,6,14,11],[22,0,22,3],[22,6,22,10],[26,0,26,3],[17,0,17,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[26,6,26,10],[35,2,35,4],[36,2,36,4],[33,8,33,10],[31,8,31,10],[34,2,34,4],[31,2,31,4],[33,2,33,4]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Advance Payment Invoice: BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,"Grantee:",null,{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,null,null,null,"Address",null,"701 Ocean St. RM 520"]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Santa Cruz, CA 95060"]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #",null,"1 YRG 2019",null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
[null,"Effective Invoice #",null,1]
[]
[]
["Advance Payment Invoice"]
[null,null,null,null,null,null,null,null,null,"Total Grant Award:",1000000]
[null,null,null,null,null,null,null,null,null,"Advance Total:",333333]
[null,null,null,null,null,null,null,null,null,"Grant Award Balance:",{"$f":"K19-K20","v":666667}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,"Approved By:","Kimberly Bushard",null,null,null,null,null,null,"BSCC Supplier Data "]
[null,null,"BSCC Field Representative",null,null,null,null,null,"COUNTYOFSA-022"]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:","2020-02-04",null,null,null,null,null,12081]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"INVOICE 1","index":1,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[51,0,51,1],[39,3,39,10],[40,3,40,10],[41,3,41,10],[12,0,13,0],[12,1,12,3],[12,4,12,6],[26,0,26,12],[32,3,32,10],[31,0,31,2],[42,3,42,10],[43,3,43,10],[37,3,37,10],[12,7,12,9],[41,0,42,0],[52,0,52,2],[47,3,47,10],[48,3,48,10],[35,0,36,0],[33,0,34,0],[38,3,38,10],[49,3,49,10],[50,3,50,10],[44,3,44,10],[45,3,45,10],[46,3,46,10],[49,0,50,0],[37,0,38,0],[39,0,40,0],[47,0,48,0],[43,0,44,0],[45,0,46,0],[35,3,35,10],[36,3,36,10],[12,10,12,12],[66,4,66,9],[54,0,54,2],[56,0,56,2],[58,0,58,2],[57,0,57,2],[35,11,35,13],[36,11,36,13],[59,0,59,2],[55,0,55,2],[53,0,53,2],[56,11,56,14],[57,11,57,14],[47,11,47,13],[48,11,48,13],[49,11,49,13],[50,11,50,13],[68,4,68,9],[52,4,52,9],[51,3,51,13],[52,11,52,13],[62,11,62,13],[63,11,63,13],[53,4,62,9],[63,4,63,9],[54,11,54,14],[55,11,55,14],[58,11,58,14],[59,11,59,14],[42,11,42,13],[43,11,43,13],[44,11,44,13],[45,11,45,13],[46,11,46,13],[72,0,72,7],[72,8,72,11],[70,0,70,12],[60,0,60,2],[61,0,61,2],[71,0,71,1],[71,6,71,7],[71,8,71,11],[67,10,67,12],[65,4,65,9],[67,4,67,9],[64,4,64,9],[68,0,68,2],[68,10,68,12],[60,11,60,14],[61,11,61,14],[4,10,6,13],[12,13,13,13],[32,11,32,13],[33,11,33,13],[34,11,34,13],[33,3,33,10],[34,3,34,10],[37,11,37,13],[38,11,38,13],[39,11,39,13],[40,11,40,13],[41,11,41,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:","Youth Reinvestment Grant",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:","Santa Cruz County",null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:","BSCC 591-19",null,"Term:","2019-07-01","TO","2023-02-28",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",1,null,"Reporting Period:","2019-07-01","TO","2019-09-30","Due:","2019-11-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",42000,251224,{"$f":"SUM(B15:C15)","v":293224},0,0,{"$f":"SUM(E15:F15)","v":0},2161,8262,{"$f":"SUM(H15:I15)","v":10423},{"$f":"B15-E15-H15","v":39839},{"$f":"C15-F15-I15","v":242962},{"$f":"SUM(K15:L15)","v":282801},"1st Advance [10/25/19]"]
["Services & Supplies",0,117,117,0,0,{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",0,0,0,0,0,{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",900000,0,900000,0,0,0,0,0,0,900000,0,900000,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Data Collection",24000,0,24000,0,0,0,0,0,0,24000,0,24000]
["Project Evaluation",34000,0,34000,0,0,0,0,0,0,34000,0,34000,"3rd Advance\n [enter date]"]
["Other",0,804,{"$f":"SUM(B22:C22)","v":804},0,0,0,0,0,0,0,804,804,0]
["Indirect Costs",0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":0},0,0,2161,{"$f":"SUM(I15:I23)","v":8262},10423,997839,243883,1241722,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[0]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":2161},null,null,"Grant funds claimed this period:",{"$f":"H24","v":2161},null,null,null,"Percentage Grant $$ expended to date:","Percentage Grant $$ expended to date:",{"$f":"D28/N24","v":6.4830064830064833E-3}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":8262},null,null,null,null,null,null,null,"% of Total Obligated Match to date:","% of Total Obligated Match to date:",{"$f":"D29/C24","v":3.2766860338297406E-2}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":2161},".08 FTE Deputy Probation Officer $2,161/ 3 months       ",null,null,null,null,null,null,null,"See original application for salary/benefit breakdown"]
[null,"Match",{"$f":"I15","v":8262},".10 FTE Assistant Division Director $4,046/ 3 months       .12 FTE Deputy Probation Officer $3,242/ 3 months       .025 FTE Administrative Services Manager $974/ 3 months",null,null,null,null,null,null,null,"See original application for salary/benefit breakdown"]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Justin Nunes, Accountant III",null,null,null,null,null,null,null,null,null,null,12081]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["831-454-3814",null,null,null,null,null,null,null,null,null,null,"COUNTYOFSA-022"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["justin.nunes@santacruzcounty.us",null,null,null,null,null,null,null,null,null,null,"701 OCEAN ST RM 520"]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2019-11-15",null,null,null,null,null,null,null,null,null,null,"SANTA CRUZ CA 95060"]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Melissa K. Allen, Administrative Services Manager"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(831) 454-3884"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2019-11-15"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2019-11-15",null,null,null,"Approved By:",null,"Kimberly Bushard"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 2","index":2,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[12,10,12,12],[4,10,6,13],[12,13,13,13],[0,5,2,7],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[26,0,26,12],[32,3,32,10],[33,0,34,0],[33,3,33,10],[34,3,34,10],[31,0,31,2],[32,11,32,13],[33,11,33,13],[34,11,34,13],[37,0,38,0],[37,3,37,10],[38,3,38,10],[37,11,37,13],[38,11,38,13],[35,0,36,0],[35,3,35,10],[36,3,36,10],[35,11,35,13],[36,11,36,13],[41,0,42,0],[41,3,41,10],[42,3,42,10],[41,11,41,13],[42,11,42,13],[39,0,40,0],[39,3,39,10],[40,3,40,10],[39,11,39,13],[40,11,40,13],[45,0,46,0],[45,3,45,10],[46,3,46,10],[45,11,45,13],[46,11,46,13],[43,0,44,0],[43,3,43,10],[44,3,44,10],[43,11,43,13],[44,11,44,13],[49,0,50,0],[49,3,49,10],[50,3,50,10],[49,11,49,13],[50,11,50,13],[47,0,48,0],[47,3,47,10],[48,3,48,10],[47,11,47,13],[48,11,48,13],[51,0,51,1],[52,0,52,2],[52,4,52,9],[52,11,52,13],[53,0,53,2],[59,0,59,2],[60,0,60,2],[61,0,61,2],[53,4,62,9],[54,11,54,13],[55,11,55,13],[56,11,56,13],[54,0,54,2],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[57,11,57,13],[58,11,58,13],[59,11,59,13],[60,11,60,13],[72,0,72,7],[72,8,72,11],[68,0,68,2],[68,10,68,12],[70,0,70,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[65,4,65,9],[66,4,66,9],[67,4,67,9],[68,4,68,9],[51,3,51,13],[61,11,61,13],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[67,10,67,12]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",2,null,"Reporting Period:","2019-10-01","TO","2019-12-31","Due:","2020-02-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 1'!B15","v":42000},{"$f":"'INVOICE 1'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 1'!E15+'INVOICE 1'!H15","v":2161},{"$f":"'INVOICE 1'!F15+'INVOICE 1'!I15","v":8262},{"$f":"SUM(E15:F15)","v":10423},2214,9036,{"$f":"SUM(H15:I15)","v":11250},{"$f":"B15-E15-H15","v":37625},233926,{"$f":"SUM(K15:L15)","v":271551},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":117},117,{"$f":"'INVOICE 1'!E16+'INVOICE 1'!H16","v":0},{"$f":"'INVOICE 1'!F16+'INVOICE 1'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 1'!B17","v":0},{"$f":"'INVOICE 1'!C17","v":0},0,{"$f":"'INVOICE 1'!E17+'INVOICE 1'!H17","v":0},{"$f":"'INVOICE 1'!F17+'INVOICE 1'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 1'!B18","v":900000},{"$f":"'INVOICE 1'!C18","v":0},900000,{"$f":"'INVOICE 1'!E18+'INVOICE 1'!H18","v":0},{"$f":"'INVOICE 1'!F18+'INVOICE 1'!I18","v":0},0,0,0,0,900000,0,900000,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 1'!B19","v":0},{"$f":"'INVOICE 1'!C19","v":0},0,{"$f":"'INVOICE 1'!E19+'INVOICE 1'!H19","v":0},{"$f":"'INVOICE 1'!F19+'INVOICE 1'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 1'!B20","v":24000},{"$f":"'INVOICE 1'!C20","v":0},24000,{"$f":"'INVOICE 1'!E20+'INVOICE 1'!H20","v":0},{"$f":"'INVOICE 1'!F20+'INVOICE 1'!I20","v":0},0,0,0,0,24000,0,24000]
["Project Evaluation",{"$f":"'INVOICE 1'!B21","v":34000},{"$f":"'INVOICE 1'!C21","v":0},34000,{"$f":"'INVOICE 1'!E21+'INVOICE 1'!H21","v":0},{"$f":"'INVOICE 1'!F21+'INVOICE 1'!I21","v":0},0,0,0,0,34000,0,34000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 1'!B22","v":0},{"$f":"'INVOICE 1'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 1'!E22+'INVOICE 1'!H22","v":0},{"$f":"'INVOICE 1'!F22+'INVOICE 1'!I22","v":0},0,0,275,275,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":0},{"$f":"'INVOICE 1'!C23","v":0},0,{"$f":"'INVOICE 1'!E23+'INVOICE 1'!H23","v":0},{"$f":"'INVOICE 1'!F23+'INVOICE 1'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":2161},8262,10423,2214,{"$f":"SUM(I15:I23)","v":9311},11525,995625,234572,1230197,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 2'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":4375},null,null,"Grant funds claimed this period:",{"$f":"H24","v":2214},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.3125013125013124E-2}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":17573},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":328958},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":6.9694025263241394E-2}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":2214},".08 FTE Deputy Probation Officer $2,214/ 3 months",null,null,null,null,null,null,null,"See original application for salary/benefit breakdown"]
[null,"Match",{"$f":"I15","v":9036},".10 FTE Assistant Division Director $4,572/ 3 months       .12 FTE Deputy Probation Officer $3,321/ 3 months       .025 FTE Administrative Services Manager $1,143/ 3 months",null,null,null,null,null,null,null,"See original application for salary/benefit breakdown"]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":275},"Travel to YRG Grant Orientation in Sacramento: meal per diem 94.00/ Mileage $175.16 (302 miles @ $0.58/mile)/ $6 Bridge Toll",null,null,null,null,null,null,null,"Travel Expenses for ADD to attend orientation"]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Justin Nunes, Accountant III",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["831-454-3814",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["justin.nunes@santacruzcounty.us",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-02-10",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Melissa Allen, Administrative Services Manager"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(831) 454-3884"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-02-13"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-02-13",null,null,null,"Approved By:",null,"Kimberly Bushard"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 3","index":3,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",3,null,"Reporting Period:","2020-01-01","TO","2020-03-31","Due:","2020-05-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 2'!B15","v":42000},{"$f":"'INVOICE 2'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 2'!E15+'INVOICE 2'!H15","v":4375},{"$f":"'INVOICE 2'!F15+'INVOICE 2'!I15","v":17298},{"$f":"SUM(E15:F15)","v":21673},1650,8731,{"$f":"SUM(H15:I15)","v":10381},{"$f":"B15-E15-H15","v":35975},225195,{"$f":"SUM(K15:L15)","v":261170},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 2'!B16","v":0},{"$f":"'INVOICE 2'!C16","v":117},117,{"$f":"'INVOICE 2'!E16+'INVOICE 2'!H16","v":0},{"$f":"'INVOICE 2'!F16+'INVOICE 2'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 2'!B17","v":0},{"$f":"'INVOICE 2'!C17","v":0},0,{"$f":"'INVOICE 2'!E17+'INVOICE 2'!H17","v":0},{"$f":"'INVOICE 2'!F17+'INVOICE 2'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 2'!B18","v":900000},{"$f":"'INVOICE 2'!C18","v":0},900000,{"$f":"'INVOICE 2'!E18+'INVOICE 2'!H18","v":0},{"$f":"'INVOICE 2'!F18+'INVOICE 2'!I18","v":0},0,0,0,0,900000,0,900000,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 2'!B19","v":0},{"$f":"'INVOICE 2'!C19","v":0},0,{"$f":"'INVOICE 2'!E19+'INVOICE 2'!H19","v":0},{"$f":"'INVOICE 2'!F19+'INVOICE 2'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 2'!B20","v":24000},{"$f":"'INVOICE 2'!C20","v":0},24000,{"$f":"'INVOICE 2'!E20+'INVOICE 2'!H20","v":0},{"$f":"'INVOICE 2'!F20+'INVOICE 2'!I20","v":0},0,0,0,0,24000,0,24000]
["Project Evaluation",{"$f":"'INVOICE 2'!B21","v":34000},{"$f":"'INVOICE 2'!C21","v":0},34000,{"$f":"'INVOICE 2'!E21+'INVOICE 2'!H21","v":0},{"$f":"'INVOICE 2'!F21+'INVOICE 2'!I21","v":0},0,0,0,0,34000,0,34000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 2'!B22","v":0},{"$f":"'INVOICE 2'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 2'!E22+'INVOICE 2'!H22","v":0},{"$f":"'INVOICE 2'!F22+'INVOICE 2'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 2'!B23","v":0},{"$f":"'INVOICE 2'!C23","v":0},0,{"$f":"'INVOICE 2'!E23+'INVOICE 2'!H23","v":0},{"$f":"'INVOICE 2'!F23+'INVOICE 2'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":4375},17573,21948,1650,{"$f":"SUM(I15:I23)","v":8731},10381,993975,225841,1219816,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 3'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":6025},null,null,"Grant funds claimed this period:",{"$f":"H24","v":1650},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.8075018075018073E-2}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":26304},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":327308},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.10432092645105}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":1650},".08 FTE Deputy Probation Officer/2 months (12/14/19-2/21/20)/ $1,650",null,null,null,null,null,null,null,"See original application for salary/benefit breakdown"]
[null,"Match",{"$f":"I15","v":8731},".10 FTE Division Director/3 months (12/14/19-3/20/20)/$5,001\n.12 FTE Deputy Probation Officer/2 months (12/14/19-2/21/20)/ $2,476\n.025 FTE Administrative Services Manager/3 months (12/14/19-3/20/20)/$1,172 & <.01 FTE CAO Senior Admin Analyst/3 months (12/14/19-3/20/20)/ $82",null,null,null,null,null,null,null,"See original application for salary/benefit breakdown"]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Justin Nunes, Administrative Services Officer I",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["831-454-3814",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["justin.nunes@santacruzcounty.us",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-05-15",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Melissa Allen, Administrative Services Manager"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"831-3884"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-05-15"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-05-15",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 4","index":4,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",4,null,"Reporting Period:","2020-04-01","TO","2020-06-30","Due:","2020-08-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 3'!B15","v":42000},{"$f":"'INVOICE 3'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 3'!E15+'INVOICE 3'!H15","v":6025},{"$f":"'INVOICE 3'!F15+'INVOICE 3'!I15","v":26029},{"$f":"SUM(E15:F15)","v":32054},3175,6787,{"$f":"SUM(H15:I15)","v":9962},{"$f":"B15-E15-H15","v":32800},218408,{"$f":"SUM(K15:L15)","v":251208},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 3'!B16","v":0},{"$f":"'INVOICE 3'!C16","v":117},117,{"$f":"'INVOICE 3'!E16+'INVOICE 3'!H16","v":0},{"$f":"'INVOICE 3'!F16+'INVOICE 3'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 3'!B17","v":0},{"$f":"'INVOICE 3'!C17","v":0},0,{"$f":"'INVOICE 3'!E17+'INVOICE 3'!H17","v":0},{"$f":"'INVOICE 3'!F17+'INVOICE 3'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 3'!B18","v":900000},{"$f":"'INVOICE 3'!C18","v":0},900000,{"$f":"'INVOICE 3'!E18+'INVOICE 3'!H18","v":0},{"$f":"'INVOICE 3'!F18+'INVOICE 3'!I18","v":0},0,108699,0,108699,791301,0,791301,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 3'!B19","v":0},{"$f":"'INVOICE 3'!C19","v":0},0,{"$f":"'INVOICE 3'!E19+'INVOICE 3'!H19","v":0},{"$f":"'INVOICE 3'!F19+'INVOICE 3'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 3'!B20","v":24000},{"$f":"'INVOICE 3'!C20","v":0},24000,{"$f":"'INVOICE 3'!E20+'INVOICE 3'!H20","v":0},{"$f":"'INVOICE 3'!F20+'INVOICE 3'!I20","v":0},0,0,0,0,24000,0,24000]
["Project Evaluation",{"$f":"'INVOICE 3'!B21","v":34000},{"$f":"'INVOICE 3'!C21","v":0},34000,{"$f":"'INVOICE 3'!E21+'INVOICE 3'!H21","v":0},{"$f":"'INVOICE 3'!F21+'INVOICE 3'!I21","v":0},0,0,0,0,34000,0,34000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 3'!B22","v":0},{"$f":"'INVOICE 3'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 3'!E22+'INVOICE 3'!H22","v":0},{"$f":"'INVOICE 3'!F22+'INVOICE 3'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 3'!B23","v":0},{"$f":"'INVOICE 3'!C23","v":0},0,{"$f":"'INVOICE 3'!E23+'INVOICE 3'!H23","v":0},{"$f":"'INVOICE 3'!F23+'INVOICE 3'!I23","v":0},0,null,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":6025},26304,32329,111874,{"$f":"SUM(I15:I23)","v":6787},118661,882101,219054,1101155,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 4'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":117899},null,null,"Grant funds claimed this period:",{"$f":"H24","v":111874},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.35369735369735372}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":33091},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":215434},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.13123797814749449}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":3175},".08 FTE Deputy Probation Officer/3 months (2/22/20-6/30/20)/ $3,175",null,null,null,null,null,null,null,"See Salaries & Benefits Worksheet in supporting docs for desk review"]
[null,"Match",{"$f":"I15","v":6787},".08 FTE Division Director/3 months (2/22/20-6/30/20)/$4,396\n.03 FTE Deputy Probation Officer/3 months (2/22/20-6/30/20)/ $1,174\n.025 FTE Administrative Services Manager/3 months (2/22/20-6/30/20)/$1,217",null,null,null,null,null,null,null,"See Salaries & Benefits Worksheet in supporting docs for desk review"]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":108699},"NGO PVPSA 9 months of contracted services (July 2019 thru March 2020): Program Coordinator at $28,144; Case Manager 1 at $23,135; Case Manager 2 at $11,766; Mental Health Clinician at $33,738; Mileage $758; Facilities $471; Indirect $10,687; $108,699 subtotal for NGO PVPSA",null,null,null,null,null,null,null,"See NGO Subcontracts - Docs 1 thru 10 in supporting docs for desk review"]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Justin Nunes, Adminstrative Services Officer I",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["831-454-3814",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["justin.nunes@santacruzcounty.us",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-08-14",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Melissa K. Allen, Administrative Services Manager"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(831) 454-3884"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-08-14"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-08-14",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 5","index":5,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",5,null,"Reporting Period:","2020-07-01","TO","2020-09-30","Due:","2020-11-16",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 4'!B15","v":42000},{"$f":"'INVOICE 4'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 4'!E15+'INVOICE 4'!H15","v":9200},{"$f":"'INVOICE 4'!F15+'INVOICE 4'!I15","v":32816},{"$f":"SUM(E15:F15)","v":42016},1834,7716,{"$f":"SUM(H15:I15)","v":9550},{"$f":"B15-E15-H15","v":30966},210692,{"$f":"SUM(K15:L15)","v":241658},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 4'!B16","v":0},{"$f":"'INVOICE 4'!C16","v":117},117,{"$f":"'INVOICE 4'!E16+'INVOICE 4'!H16","v":0},{"$f":"'INVOICE 4'!F16+'INVOICE 4'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 4'!B17","v":0},{"$f":"'INVOICE 4'!C17","v":0},0,{"$f":"'INVOICE 4'!E17+'INVOICE 4'!H17","v":0},{"$f":"'INVOICE 4'!F17+'INVOICE 4'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 4'!B18","v":900000},{"$f":"'INVOICE 4'!C18","v":0},900000,{"$f":"'INVOICE 4'!E18+'INVOICE 4'!H18","v":108699},{"$f":"'INVOICE 4'!F18+'INVOICE 4'!I18","v":0},108699,43095,0,43095,748206,0,748206,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 4'!B19","v":0},{"$f":"'INVOICE 4'!C19","v":0},0,{"$f":"'INVOICE 4'!E19+'INVOICE 4'!H19","v":0},{"$f":"'INVOICE 4'!F19+'INVOICE 4'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 4'!B20","v":24000},{"$f":"'INVOICE 4'!C20","v":0},24000,{"$f":"'INVOICE 4'!E20+'INVOICE 4'!H20","v":0},{"$f":"'INVOICE 4'!F20+'INVOICE 4'!I20","v":0},0,0,0,0,24000,0,24000]
["Project Evaluation",{"$f":"'INVOICE 4'!B21","v":34000},{"$f":"'INVOICE 4'!C21","v":0},34000,{"$f":"'INVOICE 4'!E21+'INVOICE 4'!H21","v":0},{"$f":"'INVOICE 4'!F21+'INVOICE 4'!I21","v":0},0,0,0,0,34000,0,34000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 4'!B22","v":0},{"$f":"'INVOICE 4'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 4'!E22+'INVOICE 4'!H22","v":0},{"$f":"'INVOICE 4'!F22+'INVOICE 4'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 4'!B23","v":0},{"$f":"'INVOICE 4'!C23","v":0},0,{"$f":"'INVOICE 4'!E23+'INVOICE 4'!H23","v":0},{"$f":"'INVOICE 4'!F23+'INVOICE 4'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":117899},33091,150990,44929,{"$f":"SUM(I15:I23)","v":7716},52645,837172,211338,1048510,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 5'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":162828},null,null,"Grant funds claimed this period:",{"$f":"H24","v":44929},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.4884844884844885}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":40807},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":170505},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.16183941779531619}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":1834},".08 FTE Deputy Probation Officer 3 months (7/1/20-9/18/20)/ $1,834"]
[null,"Match",{"$f":"I15","v":7716},".10 FTE Division Director/ 3 months (7/1/20-9/18/20)/$3,979 ; .12 FTE Deputy Probation Officer 3 months (7/1/20-9/18/20)/$2,761 ; .025 FTE Administrative Services Manager/ 3 months (7/1/20-9/18/20)/ $976"]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":43095},"NGO Pajaro Valley Prevention and Student Assistance, Inc./ 3 months of contracted services for Project CRYJ (April thru June 2020)"]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Justin Nunes, Administrative Services Officer",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["831-454-3814",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["justin.nunes@santacruzcounty.us",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-11-16",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Melissa K. Allen, Administrative Services Manager"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"831-454-3884"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-11-16"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-11-16",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 6","index":6,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",6,null,"Reporting Period:","2020-10-01","TO","2020-12-31","Due:","2021-02-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 5'!B15","v":42000},{"$f":"'INVOICE 5'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 5'!E15+'INVOICE 5'!H15","v":11034},{"$f":"'INVOICE 5'!F15+'INVOICE 5'!I15","v":40532},{"$f":"SUM(E15:F15)","v":51566},2054,8647,{"$f":"SUM(H15:I15)","v":10701},{"$f":"B15-E15-H15","v":28912},202045,{"$f":"SUM(K15:L15)","v":230957},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 5'!B16","v":0},{"$f":"'INVOICE 5'!C16","v":117},117,{"$f":"'INVOICE 5'!E16+'INVOICE 5'!H16","v":0},{"$f":"'INVOICE 5'!F16+'INVOICE 5'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 5'!B17","v":0},{"$f":"'INVOICE 5'!C17","v":0},0,{"$f":"'INVOICE 5'!E17+'INVOICE 5'!H17","v":0},{"$f":"'INVOICE 5'!F17+'INVOICE 5'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 5'!B18","v":900000},{"$f":"'INVOICE 5'!C18","v":0},900000,{"$f":"'INVOICE 5'!E18+'INVOICE 5'!H18","v":151794},{"$f":"'INVOICE 5'!F18+'INVOICE 5'!I18","v":0},151794,85203,0,85203,663003,0,663003,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 5'!B19","v":0},{"$f":"'INVOICE 5'!C19","v":0},0,{"$f":"'INVOICE 5'!E19+'INVOICE 5'!H19","v":0},{"$f":"'INVOICE 5'!F19+'INVOICE 5'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 5'!B20","v":24000},{"$f":"'INVOICE 5'!C20","v":0},24000,{"$f":"'INVOICE 5'!E20+'INVOICE 5'!H20","v":0},{"$f":"'INVOICE 5'!F20+'INVOICE 5'!I20","v":0},0,10000,0,10000,14000,0,14000]
["Project Evaluation",{"$f":"'INVOICE 5'!B21","v":34000},{"$f":"'INVOICE 5'!C21","v":0},34000,{"$f":"'INVOICE 5'!E21+'INVOICE 5'!H21","v":0},{"$f":"'INVOICE 5'!F21+'INVOICE 5'!I21","v":0},0,10000,0,10000,24000,0,24000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 5'!B22","v":0},{"$f":"'INVOICE 5'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 5'!E22+'INVOICE 5'!H22","v":0},{"$f":"'INVOICE 5'!F22+'INVOICE 5'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 5'!B23","v":0},{"$f":"'INVOICE 5'!C23","v":0},0,{"$f":"'INVOICE 5'!E23+'INVOICE 5'!H23","v":0},{"$f":"'INVOICE 5'!F23+'INVOICE 5'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":162828},40807,203635,107257,{"$f":"SUM(I15:I23)","v":8647},115904,729915,202691,932606,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 6'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":270085},null,null,"Grant funds claimed this period:",{"$f":"H24","v":107257},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.81025581025581028}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":49454},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":63248},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.19613317733843622}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":2054},".08 FTE Deputy Probation Officer 3 months (9/19/20-12/25/20)/ $2,054"]
[null,"Match",{"$f":"I15","v":8647},".10 FTE Division Director/ 3 months (9/19/20-12/25/20)/$4,361 ; .12 FTE Deputy Probation Officer 3 months (9/19/20-12/25/20)/$3,081 ; .025 FTE Administrative Services Manager/ 3 months (9/19/20-12/25/20)/ $1,205"]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":85203},"NGO PVPSA 5 months of contracted services (July 2020 thru November 2020): Program Coordinator at $20,363; Case Manager 1 at $15,192; Case Manager 2 at $10,007; Mental Health Clinician at $32,101; Mileage $314; Facilities $3,410; Cell Phone $137; Indirect $3,679; $85,203 subtotal for NGO PVPSA"]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":10000},"Applied Survey Research/ Data Collection services thru June 2020/ $10,000"]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":10000},"Applied Survey Research/ Project Evaluation services thru June 2020/ $10,000"]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Justin Nunes, Administrative Services Officer",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["831-454-3814",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["justin.nunes@santacruzcounty.us",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-02-11",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Melissa K. Allen, Administrative Services Manager"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"831-454-3884"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-02-15"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-02-15",null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"2nd Advance Payment","index":7,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[14,2,14,3],[24,6,24,10],[25,6,33,10],[49,2,49,4],[0,5,2,7],[12,6,14,11],[17,0,17,11],[18,10,18,11],[19,10,19,11],[20,10,20,11],[24,1,24,4],[25,1,25,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[22,0,22,3],[22,6,22,10],[45,0,45,3],[45,6,45,10],[48,2,48,4],[34,6,34,10],[35,6,35,10],[36,6,36,10],[37,6,37,10],[38,6,38,10],[39,6,39,10],[40,6,40,10],[42,6,42,10],[41,6,41,10],[50,2,50,4],[50,8,50,10],[52,2,52,4],[52,8,52,10],[53,2,53,4]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Advance Payment Invoice: BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,"Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,null,null,null,"Address",null,{"$f":"'1st Advance Payment'!J8","v":"701 Ocean St. RM 520"}]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,{"$f":"'1st Advance Payment'!J10","v":"Santa Cruz, CA 95060"}]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #",null,"2 YRG 2019",null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
[null,"Effective Invoice #","7"]
[]
[]
["Advance Payment Invoice"]
[null,null,null,null,null,null,null,null,null,"Total Grant Award:",{"$f":"'1st Advance Payment'!K19:L19","v":1000000}]
[null,null,null,null,null,null,null,null,null,"Advance Total:",333333]
[null,null,null,null,null,null,null,null,null,"Grant Award Balance:",{"$f":"K19-'1st Advance Payment'!K20:L20-'2nd Advance Payment'!K20:L20","v":333334}]
[]
[]
[]
[null,"PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER"]
[null,"Justin Nunes, Administrative Services Officer",null,null,null,null,"I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,"Name, Title"]
[null,"831-454-3814"]
[null,"Phone"]
[null,"justin.nunes@santacruzcounty.us"]
[null,"Email"]
[null,"2021-05-17"]
[null,"Date"]
[]
[null,null,null,null,null,null,"Melissa K. Allen, Administrative Services Manager"]
[null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,"831-454-3884"]
[null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,"melissa.allen@santacruzcounty.us"]
[null,null,null,null,null,null,"Email"]
[null,null,null,null,null,null,"2021-05-18"]
[null,null,null,null,null,null,"Date"]
[]
[null,null,null,null,null,null,"Signature"]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,"Approved By:","Eddie Escobar",null,null,null,null,null,null,"BSCC Supplier Data "]
[null,null,"BSCC Field Representative",null,null,null,null,null,{"$f":"'1st Advance Payment'!I32:K32","v":"COUNTYOFSA-022"}]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:","2021-10-26",null,null,null,null,null,{"$f":"'1st Advance Payment'!I34:K34","v":12081}]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"INVOICE 7","index":8,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",7,null,"Reporting Period:","2021-01-01","TO","2021-03-31","Due:","2021-05-17",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 6'!B15","v":42000},{"$f":"'INVOICE 6'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 6'!E15+'INVOICE 6'!H15","v":13088},{"$f":"'INVOICE 6'!F15+'INVOICE 6'!I15","v":49179},{"$f":"SUM(E15:F15)","v":62267},2016,8410,{"$f":"SUM(H15:I15)","v":10426},{"$f":"B15-E15-H15","v":26896},193635,{"$f":"SUM(K15:L15)","v":220531},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 6'!B16","v":0},{"$f":"'INVOICE 6'!C16","v":117},117,{"$f":"'INVOICE 6'!E16+'INVOICE 6'!H16","v":0},{"$f":"'INVOICE 6'!F16+'INVOICE 6'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 6'!B17","v":0},{"$f":"'INVOICE 6'!C17","v":0},0,{"$f":"'INVOICE 6'!E17+'INVOICE 6'!H17","v":0},{"$f":"'INVOICE 6'!F17+'INVOICE 6'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 6'!B18","v":900000},{"$f":"'INVOICE 6'!C18","v":0},900000,{"$f":"'INVOICE 6'!E18+'INVOICE 6'!H18","v":236997},{"$f":"'INVOICE 6'!F18+'INVOICE 6'!I18","v":0},236997,41678,0,41678,621325,0,621325,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 6'!B19","v":0},{"$f":"'INVOICE 6'!C19","v":0},0,{"$f":"'INVOICE 6'!E19+'INVOICE 6'!H19","v":0},{"$f":"'INVOICE 6'!F19+'INVOICE 6'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 6'!B20","v":24000},{"$f":"'INVOICE 6'!C20","v":0},24000,{"$f":"'INVOICE 6'!E20+'INVOICE 6'!H20","v":10000},{"$f":"'INVOICE 6'!F20+'INVOICE 6'!I20","v":0},10000,0,0,0,14000,0,14000]
["Project Evaluation",{"$f":"'INVOICE 6'!B21","v":34000},{"$f":"'INVOICE 6'!C21","v":0},34000,{"$f":"'INVOICE 6'!E21+'INVOICE 6'!H21","v":10000},{"$f":"'INVOICE 6'!F21+'INVOICE 6'!I21","v":0},10000,0,0,0,24000,0,24000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 6'!B22","v":0},{"$f":"'INVOICE 6'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 6'!E22+'INVOICE 6'!H22","v":0},{"$f":"'INVOICE 6'!F22+'INVOICE 6'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 6'!B23","v":0},{"$f":"'INVOICE 6'!C23","v":0},0,{"$f":"'INVOICE 6'!E23+'INVOICE 6'!H23","v":0},{"$f":"'INVOICE 6'!F23+'INVOICE 6'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":270085},49454,319539,43694,{"$f":"SUM(I15:I23)","v":8410},52104,686221,194281,880502,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 7'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":313779},null,null,"Grant funds claimed this period:",{"$f":"H24","v":43694},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.94133794133794135}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":57864},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":19554},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.22948700152689921}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":2016},".08 FTE Deputy Probation Officer 3 months (12/26/20-03/19/21)/ $2,016"]
[null,"Match",{"$f":"I15","v":8410},".10 FTE Division Director/ 3 months (12/26/20-03/19/21)/$4,377; .12 FTE Deputy Probation Officer 3 months (12/26/20-03/19/21)/$3,024; .025 FTE Administrative Services Manager/ 3 months (12/26/20-03/19/21)/ $1,009"]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":41678},"NGO PVPSA 2 months of contracted services (December 2020 thru January 2021): Program Coordinator at $7,790; Case Manager 1 at $5,978; Case Manager 2 at $4,698; Mental Health Clinician at $12,631; Mileage $277; Facilities $1,726; Cell Phone $60; Indirect $2,590; $35,750 subtotal for PVPSA/ NGO CAB 3 months of contracted services (November 2020 thru January 2021) $5,928. "]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Justin Nunes, Administrative Services Officer",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["831-454-3814",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["justin.nunes@santacruzcounty.us",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-05-17",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Melissa K. Allen, Administrative Services Manager"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"831-454-3884"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-05-18"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-05-18",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 8","index":9,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",8,null,"Reporting Period:","2021-04-01","TO","2021-06-30","Due:","2021-08-16",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 7'!B15","v":42000},{"$f":"'INVOICE 7'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 7'!E15+'INVOICE 7'!H15","v":15104},{"$f":"'INVOICE 7'!F15+'INVOICE 7'!I15","v":57589},{"$f":"SUM(E15:F15)","v":72693},1184,8543,{"$f":"SUM(H15:I15)","v":9727},{"$f":"B15-E15-H15","v":25712},185092,{"$f":"SUM(K15:L15)","v":210804},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 7'!B16","v":0},{"$f":"'INVOICE 7'!C16","v":117},117,{"$f":"'INVOICE 7'!E16+'INVOICE 7'!H16","v":0},{"$f":"'INVOICE 7'!F16+'INVOICE 7'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 7'!B17","v":0},{"$f":"'INVOICE 7'!C17","v":0},0,{"$f":"'INVOICE 7'!E17+'INVOICE 7'!H17","v":0},{"$f":"'INVOICE 7'!F17+'INVOICE 7'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 7'!B18","v":900000},{"$f":"'INVOICE 7'!C18","v":0},900000,{"$f":"'INVOICE 7'!E18+'INVOICE 7'!H18","v":278675},{"$f":"'INVOICE 7'!F18+'INVOICE 7'!I18","v":0},278675,55226,0,55226,566099,0,566099,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 7'!B19","v":0},{"$f":"'INVOICE 7'!C19","v":0},0,{"$f":"'INVOICE 7'!E19+'INVOICE 7'!H19","v":0},{"$f":"'INVOICE 7'!F19+'INVOICE 7'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 7'!B20","v":24000},{"$f":"'INVOICE 7'!C20","v":0},24000,{"$f":"'INVOICE 7'!E20+'INVOICE 7'!H20","v":10000},{"$f":"'INVOICE 7'!F20+'INVOICE 7'!I20","v":0},10000,0,0,0,14000,0,14000]
["Project Evaluation",{"$f":"'INVOICE 7'!B21","v":34000},{"$f":"'INVOICE 7'!C21","v":0},34000,{"$f":"'INVOICE 7'!E21+'INVOICE 7'!H21","v":10000},{"$f":"'INVOICE 7'!F21+'INVOICE 7'!I21","v":0},10000,0,0,0,24000,0,24000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 7'!B22","v":0},{"$f":"'INVOICE 7'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 7'!E22+'INVOICE 7'!H22","v":0},{"$f":"'INVOICE 7'!F22+'INVOICE 7'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 7'!B23","v":0},{"$f":"'INVOICE 7'!C23","v":0},0,{"$f":"'INVOICE 7'!E23+'INVOICE 7'!H23","v":0},{"$f":"'INVOICE 7'!F23+'INVOICE 7'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":313779},57864,371643,56410,{"$f":"SUM(I15:I23)","v":8543},64953,629811,185738,815549,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 8'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":370189},null,null,"Grant funds claimed this period:",{"$f":"H24","v":56410},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.1105681105681107}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":66407},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":-36856},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.2633682999861191}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":1184},".08 FTE Deputy Probation Officer 3 months (3/20/21-06/30/21)/ $1,184."]
[null,"Match",{"$f":"I15","v":8543},".10 FTE Division Director/ 3 months (3/20/21-06/30/21)/$5,539; .12 FTE Deputy Probation Officer 3 months (3/20/21-06/30/21)/$1,776; .025 FTE Administrative Services Manager/ 3 months (3/20/21-06/30/21)/ $1,228."]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":55226},"NGO PVPSA 2 months of contracted services (February thru March 2021): Program Coordinator at $8,147; Case Manager 1 at $6,588; Mental Health Clinician at $13,210; Mileage $95; Facilities $863; Cell Phone $60; Indirect $2,590; $31,553 subtotal for PVPSA/ NGO CRC 5 months of contracted services (November 2020 thru March 2021) $14,562/ NGO CAB 4 months of contracted services (February thru May 2021) $9,111. "]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Justin Nunes, Administrative Services Officer",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["831-454-3814",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["justin.nunes@santacruzcounty.us",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-10-11",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Melissa K. Allen, Administrative Services Manager"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"831-454-3884"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-10-11"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-10-11",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"MOD 1","index":10,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":false,"merged":[[19,0,20,0],[19,1,19,3],[19,4,19,6],[19,7,19,9],[19,10,19,12],[0,5,2,7],[5,1,5,3],[5,5,5,7],[5,9,5,11],[7,0,7,12],[33,0,33,12],[34,0,34,12],[35,0,52,12],[54,0,54,2],[54,8,54,12],[73,0,73,1],[73,8,73,10],[60,0,60,2],[61,0,61,2],[62,0,62,2],[63,0,63,2],[65,8,65,12],[66,8,66,12],[55,8,64,12],[56,0,56,2],[57,0,57,2],[58,0,58,2],[59,0,59,2],[74,8,74,10],[74,15,74,16],[67,8,67,12],[68,8,68,12],[69,8,69,12],[70,8,70,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"STATE OF CALIFORNIA"]
["MODIFICATION REQUEST - (FORM BSCC 223.1 (Revised 04/20)",null,null,null,null,null,null,null,null,null,null,null,"BOARD OF STATE AND COMMUNITY CORRECTIONS"]
[]
[]
[null,"Line-Item Change",null,null,null,"Budget Modification",null,null,null,"Project Income Allocation"]
[null,"Check this box if you are modifying narrative details within a line item (or line items) but not changing the budget.",null,null,null,"Check this box if you are modifying line-item dollar amounts by moving funds from one line-item to another.",null,null,null,"Check this box if you are allocating earned project income."]
[]
["Important Note: You must provide a detailed justification for all modification requests. All modifications require BSCC Field Representative approval.  "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,null,null,null,"Grant Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"}]
[]
["Address",null,null,null,null,null,null,null,"Lead Public Agency:",{"$f":"'INVOICE 1'!G7","v":"N/A"}]
[]
[]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,null,null,null,null,null,null,"Modification Request #",1]
[]
["Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},{"$f":"'INVOICE 1'!F9","v":"TO"},{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,null,"Effective on Invoice #",9]
[]
["Line Items","Current Budget",null,null,"Available Budget",null,null,"Changes (+/-)",null,null,"Modified Budget"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 1'!B15","v":42000},{"$f":"'INVOICE 1'!C15","v":251224},{"$f":"SUM(B22:C22)","v":293224},{"$f":"'INVOICE 2'!K15","v":37625},{"$f":"'INVOICE 2'!L15","v":233926},{"$f":"SUM(E22:F22)","v":271551},0,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":42000},251224,{"$f":"SUM(K22:L22)","v":293224}]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":117},117,{"$f":"'INVOICE 2'!K16","v":0},{"$f":"'INVOICE 2'!L16","v":117},117,0,0,0,0,117,117]
["Professional Services",{"$f":"'INVOICE 1'!B17","v":0},{"$f":"'INVOICE 1'!C17","v":0},0,{"$f":"'INVOICE 2'!K17","v":0},{"$f":"'INVOICE 2'!L17","v":0},0,0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 1'!B18","v":900000},{"$f":"'INVOICE 1'!C18","v":0},900000,{"$f":"'INVOICE 2'!K18","v":900000},{"$f":"'INVOICE 2'!L18","v":0},900000,0,0,0,900000,0,900000]
["Equipment / Fixed Assets",{"$f":"'INVOICE 1'!B19","v":0},{"$f":"'INVOICE 1'!C19","v":0},0,{"$f":"'INVOICE 2'!K19","v":0},{"$f":"'INVOICE 2'!L19","v":0},0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 1'!B20","v":24000},{"$f":"'INVOICE 1'!C20","v":0},24000,{"$f":"'INVOICE 2'!K20","v":24000},{"$f":"'INVOICE 2'!L20","v":0},24000,0,0,0,24000,0,24000]
["Project Evaluation",{"$f":"'INVOICE 1'!B21","v":34000},{"$f":"'INVOICE 1'!C21","v":0},34000,{"$f":"'INVOICE 2'!K21","v":34000},{"$f":"'INVOICE 2'!L21","v":0},34000,0,0,0,34000,0,34000]
["Other",{"$f":"'INVOICE 1'!B22","v":0},{"$f":"'INVOICE 1'!C22","v":804},804,{"$f":"'INVOICE 2'!K22","v":0},{"$f":"'INVOICE 2'!L22","v":529},529,0,0,0,0,804,804]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":0},{"$f":"'INVOICE 1'!C23","v":0},0,{"$f":"'INVOICE 2'!K23","v":0},{"$f":"'INVOICE 2'!L23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B22:B30)","v":1000000},252145,1252145,995625,234572,1230197,0,0,0,1000000,252145,1252145]
[]
["Project Income",null,"Income reported to date",0,null,"Prior allocated income",0,"Allocating",0,null,null,"Unallocated income balance",{"$f":"D33-I33","v":0}]
[]
["JUSTIFICATION FOR MODIFICATION:"]
["Request to modify Budget Narrative Details within the NGO Subcontracts line to:                                                                                                                                                                                                                                                                                                       (1) PVPSA - Program Diversion Coordinator: Salaries & Benefits @ $145,393.                                                                                                                                                                                                                                                                                                                                   (2) PVPSA - Case Managers 1 & 2: Salaries & Benefits @ $210,938.                                                                                                                                                                                                                                                                                                                                                                                                                                                                             (3) PVPSA - Mental Health Clinician: Salaries & Benefits @ $270,949.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    (4) PVPSA - Operating Expenses (mileage, phone, facilities, additional client support services, and other applicable operating expenses) @ $68,085.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   (5) PVPSA - Indirect PVPSA - Indirect costs up to 10% of total direct salaries and wages @ $44,635.                                                                                                                                                                                                                                                                                                                                                          (6) Other CBO(s) - Other Wrap Services: CAB & CRC @$160,000.\\                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           \\                                                                                                                                                                                                                                                                                                                                  Modification Changes/Justification: This grant modification to the NGO Subcontracts line does not result in moving any total grant funding from that line.  It is requested to account for NGO budget modifications within that line to adjust cost savings from NGO PVPSA's Year 1 actual costs largely due to service adjustments in response to the COVID-19 pandemic and to apply that funding (within the NGO line) to increased benefits and annualized salary costs and to additional client supports and services through the remainder of the grant term. These adjustments do not result in a reduction of grant services and actually allow us to expand the target population to a new Probation Cohort (first time probation youth and youth experiencing limited school engagement and other school related challenges).                                                                                                                                                                                                                                                                                                                                  Modification Details: (1) Recognized savings of $23,138 in Program Diversion Coordinator salary & benefits costs; (2) Reduced combined Case Managers 1 & 2 costs by $8,236, adjusted due to increase in CM 1 salary & benefits costs and savings from transition and temporary vacancy of CM 2 staff person; (3) Slight increase of $580 to MH Clinician cost; (4) Used costs savings to add $23,281 in PVPSA Operating Expenses for additional direct client support for Years 2-4 and during the pandemic (including transportation/bus passes, incentives, emergency food and support services) and other related operating expenses (including program supplies, facility maintenance/repairs, staff training costs); (5) Minor adjustment to PVPSA Indirect to decrease it by $2,487; (6) Used cost savings from NGO PVPSA to add $10,000 to Other CBOs for Community Action Board & Conflict Resolution Center to provide additional wrap-around client support services.   "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PERSON PREPARING REPORT",null,null,null,null,null,null,null,"AUTHORIZED FINANCIAL OFFICER"]
[null,null,null,null,null,null,null,null,"I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Justin Nunes, Administrative Services Officer"]
["Name, Title"]
["831-454-3814"]
["Phone"]
["justin.nunes@santacruzcounty.us"]
["Email"]
["2021-10-06"]
["Date"]
[]
[null,null,null,null,null,null,null,null,"Melissa K. Allen, Administrative Services Manager"]
[null,null,null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,null,null,"831-454-3884"]
[null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,"2021-10-06"]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-10-11",null,null,null,null,"Approved By:","Eddie Escobar",null,null,"Date:","2021-10-26"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 9","index":11,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",9,null,"Reporting Period:","2021-07-01","TO","2021-09-30","Due:","2021-11-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 8'!B15","v":42000},{"$f":"'INVOICE 8'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 8'!E15+'INVOICE 8'!H15","v":16288},{"$f":"'INVOICE 8'!F15+'INVOICE 8'!I15","v":66132},{"$f":"SUM(E15:F15)","v":82420},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":25712},185092,{"$f":"SUM(K15:L15)","v":210804},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 8'!B16","v":0},{"$f":"'INVOICE 8'!C16","v":117},117,{"$f":"'INVOICE 8'!E16+'INVOICE 8'!H16","v":0},{"$f":"'INVOICE 8'!F16+'INVOICE 8'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 8'!B17","v":0},{"$f":"'INVOICE 8'!C17","v":0},0,{"$f":"'INVOICE 8'!E17+'INVOICE 8'!H17","v":0},{"$f":"'INVOICE 8'!F17+'INVOICE 8'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 8'!B18","v":900000},{"$f":"'INVOICE 8'!C18","v":0},900000,{"$f":"'INVOICE 8'!E18+'INVOICE 8'!H18","v":333901},{"$f":"'INVOICE 8'!F18+'INVOICE 8'!I18","v":0},333901,0,0,0,566099,0,566099,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 8'!B19","v":0},{"$f":"'INVOICE 8'!C19","v":0},0,{"$f":"'INVOICE 8'!E19+'INVOICE 8'!H19","v":0},{"$f":"'INVOICE 8'!F19+'INVOICE 8'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 8'!B20","v":24000},{"$f":"'INVOICE 8'!C20","v":0},24000,{"$f":"'INVOICE 8'!E20+'INVOICE 8'!H20","v":10000},{"$f":"'INVOICE 8'!F20+'INVOICE 8'!I20","v":0},10000,0,0,0,14000,0,14000]
["Project Evaluation",{"$f":"'INVOICE 8'!B21","v":34000},{"$f":"'INVOICE 8'!C21","v":0},34000,{"$f":"'INVOICE 8'!E21+'INVOICE 8'!H21","v":10000},{"$f":"'INVOICE 8'!F21+'INVOICE 8'!I21","v":0},10000,0,0,0,24000,0,24000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 8'!B22","v":0},{"$f":"'INVOICE 8'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 8'!E22+'INVOICE 8'!H22","v":0},{"$f":"'INVOICE 8'!F22+'INVOICE 8'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 8'!B23","v":0},{"$f":"'INVOICE 8'!C23","v":0},0,{"$f":"'INVOICE 8'!E23+'INVOICE 8'!H23","v":0},{"$f":"'INVOICE 8'!F23+'INVOICE 8'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":370189},66407,436596,0,{"$f":"SUM(I15:I23)","v":0},0,629811,185738,815549,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 9'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":370189},null,null,"Grant funds claimed this period:",{"$f":"H24","v":0},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.1105681105681107}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":66407},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":-36856},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.2633682999861191}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Match",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 10","index":12,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",10,null,"Reporting Period:","2021-10-01","TO","2021-12-31","Due:","2022-02-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 9'!B15","v":42000},{"$f":"'INVOICE 9'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 9'!E15+'INVOICE 9'!H15","v":16288},{"$f":"'INVOICE 9'!F15+'INVOICE 9'!I15","v":66132},{"$f":"SUM(E15:F15)","v":82420},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":25712},185092,{"$f":"SUM(K15:L15)","v":210804},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 9'!B16","v":0},{"$f":"'INVOICE 9'!C16","v":117},117,{"$f":"'INVOICE 9'!E16+'INVOICE 9'!H16","v":0},{"$f":"'INVOICE 9'!F16+'INVOICE 9'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 9'!B17","v":0},{"$f":"'INVOICE 9'!C17","v":0},0,{"$f":"'INVOICE 9'!E17+'INVOICE 9'!H17","v":0},{"$f":"'INVOICE 9'!F17+'INVOICE 9'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 9'!B18","v":900000},{"$f":"'INVOICE 9'!C18","v":0},900000,{"$f":"'INVOICE 9'!E18+'INVOICE 9'!H18","v":333901},{"$f":"'INVOICE 9'!F18+'INVOICE 9'!I18","v":0},333901,0,0,0,566099,0,566099,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 9'!B19","v":0},{"$f":"'INVOICE 9'!C19","v":0},0,{"$f":"'INVOICE 9'!E19+'INVOICE 9'!H19","v":0},{"$f":"'INVOICE 9'!F19+'INVOICE 9'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 9'!B20","v":24000},{"$f":"'INVOICE 9'!C20","v":0},24000,{"$f":"'INVOICE 9'!E20+'INVOICE 9'!H20","v":10000},{"$f":"'INVOICE 9'!F20+'INVOICE 9'!I20","v":0},10000,0,0,0,14000,0,14000]
["Project Evaluation",{"$f":"'INVOICE 9'!B21","v":34000},{"$f":"'INVOICE 9'!C21","v":0},34000,{"$f":"'INVOICE 9'!E21+'INVOICE 9'!H21","v":10000},{"$f":"'INVOICE 9'!F21+'INVOICE 9'!I21","v":0},10000,0,0,0,24000,0,24000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 9'!B22","v":0},{"$f":"'INVOICE 9'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 9'!E22+'INVOICE 9'!H22","v":0},{"$f":"'INVOICE 9'!F22+'INVOICE 9'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 9'!B23","v":0},{"$f":"'INVOICE 9'!C23","v":0},0,{"$f":"'INVOICE 9'!E23+'INVOICE 9'!H23","v":0},{"$f":"'INVOICE 9'!F23+'INVOICE 9'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":370189},66407,436596,0,{"$f":"SUM(I15:I23)","v":0},0,629811,185738,815549,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 10'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":370189},null,null,"Grant funds claimed this period:",{"$f":"H24","v":0},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.1105681105681107}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":66407},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":-36856},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.2633682999861191}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Match",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 11","index":13,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",11,null,"Reporting Period:","2022-01-01","TO","2022-03-31","Due:","2022-05-16",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 10'!B15","v":42000},{"$f":"'INVOICE 10'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 10'!E15+'INVOICE 10'!H15","v":16288},{"$f":"'INVOICE 10'!F15+'INVOICE 10'!I15","v":66132},{"$f":"SUM(E15:F15)","v":82420},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":25712},185092,{"$f":"SUM(K15:L15)","v":210804},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 10'!B16","v":0},{"$f":"'INVOICE 10'!C16","v":117},117,{"$f":"'INVOICE 10'!E16+'INVOICE 10'!H16","v":0},{"$f":"'INVOICE 10'!F16+'INVOICE 10'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 10'!B17","v":0},{"$f":"'INVOICE 10'!C17","v":0},0,{"$f":"'INVOICE 10'!E17+'INVOICE 10'!H17","v":0},{"$f":"'INVOICE 10'!F17+'INVOICE 10'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 10'!B18","v":900000},{"$f":"'INVOICE 10'!C18","v":0},900000,{"$f":"'INVOICE 10'!E18+'INVOICE 10'!H18","v":333901},{"$f":"'INVOICE 10'!F18+'INVOICE 10'!I18","v":0},333901,0,0,0,566099,0,566099,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 10'!B19","v":0},{"$f":"'INVOICE 10'!C19","v":0},0,{"$f":"'INVOICE 10'!E19+'INVOICE 10'!H19","v":0},{"$f":"'INVOICE 10'!F19+'INVOICE 10'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 10'!B20","v":24000},{"$f":"'INVOICE 10'!C20","v":0},24000,{"$f":"'INVOICE 10'!E20+'INVOICE 10'!H20","v":10000},{"$f":"'INVOICE 10'!F20+'INVOICE 10'!I20","v":0},10000,0,0,0,14000,0,14000]
["Project Evaluation",{"$f":"'INVOICE 10'!B21","v":34000},{"$f":"'INVOICE 10'!C21","v":0},34000,{"$f":"'INVOICE 10'!E21+'INVOICE 10'!H21","v":10000},{"$f":"'INVOICE 10'!F21+'INVOICE 10'!I21","v":0},10000,0,0,0,24000,0,24000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 10'!B22","v":0},{"$f":"'INVOICE 10'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 10'!E22+'INVOICE 10'!H22","v":0},{"$f":"'INVOICE 10'!F22+'INVOICE 10'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 10'!B23","v":0},{"$f":"'INVOICE 10'!C23","v":0},0,{"$f":"'INVOICE 10'!E23+'INVOICE 10'!H23","v":0},{"$f":"'INVOICE 10'!F23+'INVOICE 10'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":370189},66407,436596,0,{"$f":"SUM(I15:I23)","v":0},0,629811,185738,815549,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 11'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":370189},null,null,"Grant funds claimed this period:",{"$f":"H24","v":0},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.1105681105681107}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":66407},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":-36856},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.2633682999861191}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Match",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 12","index":14,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",12,null,"Reporting Period:","2022-04-01","TO","2022-06-30","Due:","2022-08-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 11'!B15","v":42000},{"$f":"'INVOICE 11'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 11'!E15+'INVOICE 11'!H15","v":16288},{"$f":"'INVOICE 11'!F15+'INVOICE 11'!I15","v":66132},{"$f":"SUM(E15:F15)","v":82420},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":25712},185092,{"$f":"SUM(K15:L15)","v":210804},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 11'!B16","v":0},{"$f":"'INVOICE 11'!C16","v":117},117,{"$f":"'INVOICE 11'!E16+'INVOICE 11'!H16","v":0},{"$f":"'INVOICE 11'!F16+'INVOICE 11'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 11'!B17","v":0},{"$f":"'INVOICE 11'!C17","v":0},0,{"$f":"'INVOICE 11'!E17+'INVOICE 11'!H17","v":0},{"$f":"'INVOICE 11'!F17+'INVOICE 11'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 11'!B18","v":900000},{"$f":"'INVOICE 11'!C18","v":0},900000,{"$f":"'INVOICE 11'!E18+'INVOICE 11'!H18","v":333901},{"$f":"'INVOICE 11'!F18+'INVOICE 11'!I18","v":0},333901,0,0,0,566099,0,566099,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 11'!B19","v":0},{"$f":"'INVOICE 11'!C19","v":0},0,{"$f":"'INVOICE 11'!E19+'INVOICE 11'!H19","v":0},{"$f":"'INVOICE 11'!F19+'INVOICE 11'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 11'!B20","v":24000},{"$f":"'INVOICE 11'!C20","v":0},24000,{"$f":"'INVOICE 11'!E20+'INVOICE 11'!H20","v":10000},{"$f":"'INVOICE 11'!F20+'INVOICE 11'!I20","v":0},10000,0,0,0,14000,0,14000]
["Project Evaluation",{"$f":"'INVOICE 11'!B21","v":34000},{"$f":"'INVOICE 11'!C21","v":0},34000,{"$f":"'INVOICE 11'!E21+'INVOICE 11'!H21","v":10000},{"$f":"'INVOICE 11'!F21+'INVOICE 11'!I21","v":0},10000,0,0,0,24000,0,24000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 11'!B22","v":0},{"$f":"'INVOICE 11'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 11'!E22+'INVOICE 11'!H22","v":0},{"$f":"'INVOICE 11'!F22+'INVOICE 11'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 11'!B23","v":0},{"$f":"'INVOICE 11'!C23","v":0},0,{"$f":"'INVOICE 11'!E23+'INVOICE 11'!H23","v":0},{"$f":"'INVOICE 11'!F23+'INVOICE 11'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":370189},66407,436596,0,{"$f":"SUM(I15:I23)","v":0},0,629811,185738,815549,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 12'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":370189},null,null,"Grant funds claimed this period:",{"$f":"H24","v":0},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.1105681105681107}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":66407},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":-36856},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.2633682999861191}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Match",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 13","index":15,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",13,null,"Reporting Period:","2022-07-01","TO","2022-09-30","Due:","2022-11-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 12'!B15","v":42000},{"$f":"'INVOICE 12'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 12'!E15+'INVOICE 12'!H15","v":16288},{"$f":"'INVOICE 12'!F15+'INVOICE 12'!I15","v":66132},{"$f":"SUM(E15:F15)","v":82420},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":25712},185092,{"$f":"SUM(K15:L15)","v":210804},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 12'!B16","v":0},{"$f":"'INVOICE 12'!C16","v":117},117,{"$f":"'INVOICE 12'!E16+'INVOICE 12'!H16","v":0},{"$f":"'INVOICE 12'!F16+'INVOICE 12'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 12'!B17","v":0},{"$f":"'INVOICE 12'!C17","v":0},0,{"$f":"'INVOICE 12'!E17+'INVOICE 12'!H17","v":0},{"$f":"'INVOICE 12'!F17+'INVOICE 12'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 12'!B18","v":900000},{"$f":"'INVOICE 12'!C18","v":0},900000,{"$f":"'INVOICE 12'!E18+'INVOICE 12'!H18","v":333901},{"$f":"'INVOICE 12'!F18+'INVOICE 12'!I18","v":0},333901,0,0,0,566099,0,566099,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 12'!B19","v":0},{"$f":"'INVOICE 12'!C19","v":0},0,{"$f":"'INVOICE 12'!E19+'INVOICE 12'!H19","v":0},{"$f":"'INVOICE 12'!F19+'INVOICE 12'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 12'!B20","v":24000},{"$f":"'INVOICE 12'!C20","v":0},24000,{"$f":"'INVOICE 12'!E20+'INVOICE 12'!H20","v":10000},{"$f":"'INVOICE 12'!F20+'INVOICE 12'!I20","v":0},10000,0,0,0,14000,0,14000]
["Project Evaluation",{"$f":"'INVOICE 12'!B21","v":34000},{"$f":"'INVOICE 12'!C21","v":0},34000,{"$f":"'INVOICE 12'!E21+'INVOICE 12'!H21","v":10000},{"$f":"'INVOICE 12'!F21+'INVOICE 12'!I21","v":0},10000,0,0,0,24000,0,24000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 12'!B22","v":0},{"$f":"'INVOICE 12'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 12'!E22+'INVOICE 12'!H22","v":0},{"$f":"'INVOICE 12'!F22+'INVOICE 12'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 12'!B23","v":0},{"$f":"'INVOICE 12'!C23","v":0},0,{"$f":"'INVOICE 12'!E23+'INVOICE 12'!H23","v":0},{"$f":"'INVOICE 12'!F23+'INVOICE 12'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":370189},66407,436596,0,{"$f":"SUM(I15:I23)","v":0},0,629811,185738,815549,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 13'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":370189},null,null,"Grant funds claimed this period:",{"$f":"H24","v":0},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.1105681105681107}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":66407},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":-36856},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.2633682999861191}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Match",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 14","index":16,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",14,null,"Reporting Period:","2022-10-01","TO","2022-12-31","Due:","2023-02-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 13'!B15","v":42000},{"$f":"'INVOICE 13'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 13'!E15+'INVOICE 13'!H15","v":16288},{"$f":"'INVOICE 13'!F15+'INVOICE 13'!I15","v":66132},{"$f":"SUM(E15:F15)","v":82420},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":25712},185092,{"$f":"SUM(K15:L15)","v":210804},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 13'!B16","v":0},{"$f":"'INVOICE 13'!C16","v":117},117,{"$f":"'INVOICE 13'!E16+'INVOICE 13'!H16","v":0},{"$f":"'INVOICE 13'!F16+'INVOICE 13'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 13'!B17","v":0},{"$f":"'INVOICE 13'!C17","v":0},0,{"$f":"'INVOICE 13'!E17+'INVOICE 13'!H17","v":0},{"$f":"'INVOICE 13'!F17+'INVOICE 13'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 13'!B18","v":900000},{"$f":"'INVOICE 13'!C18","v":0},900000,{"$f":"'INVOICE 13'!E18+'INVOICE 13'!H18","v":333901},{"$f":"'INVOICE 13'!F18+'INVOICE 13'!I18","v":0},333901,0,0,0,566099,0,566099,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 13'!B19","v":0},{"$f":"'INVOICE 13'!C19","v":0},0,{"$f":"'INVOICE 13'!E19+'INVOICE 13'!H19","v":0},{"$f":"'INVOICE 13'!F19+'INVOICE 13'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 13'!B20","v":24000},{"$f":"'INVOICE 13'!C20","v":0},24000,{"$f":"'INVOICE 13'!E20+'INVOICE 13'!H20","v":10000},{"$f":"'INVOICE 13'!F20+'INVOICE 13'!I20","v":0},10000,0,0,0,14000,0,14000]
["Project Evaluation",{"$f":"'INVOICE 13'!B21","v":34000},{"$f":"'INVOICE 13'!C21","v":0},34000,{"$f":"'INVOICE 13'!E21+'INVOICE 13'!H21","v":10000},{"$f":"'INVOICE 13'!F21+'INVOICE 13'!I21","v":0},10000,0,0,0,24000,0,24000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 13'!B22","v":0},{"$f":"'INVOICE 13'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 13'!E22+'INVOICE 13'!H22","v":0},{"$f":"'INVOICE 13'!F22+'INVOICE 13'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 13'!B23","v":0},{"$f":"'INVOICE 13'!C23","v":0},0,{"$f":"'INVOICE 13'!E23+'INVOICE 13'!H23","v":0},{"$f":"'INVOICE 13'!F23+'INVOICE 13'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":370189},66407,436596,0,{"$f":"SUM(I15:I23)","v":0},0,629811,185738,815549,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 14'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":370189},null,null,"Grant funds claimed this period:",{"$f":"H24","v":0},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.1105681105681107}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":66407},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":-36856},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.2633682999861191}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Match",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 15","index":17,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[26,0,26,12],[31,0,31,2],[32,3,32,10],[32,11,32,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[53,0,53,2],[53,4,62,9],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,0,56,2],[56,11,56,13],[57,0,57,2],[57,11,57,13],[59,0,59,2],[59,11,59,13],[60,0,60,2],[60,11,60,13],[58,0,58,2],[58,11,58,13],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,13],[61,0,61,2],[61,11,61,13],[70,0,70,12],[62,11,62,13],[63,4,63,9],[63,11,63,13],[64,4,64,9],[65,4,65,9],[66,4,66,9],[67,4,67,9],[67,10,67,12],[68,0,68,2],[68,4,68,9],[68,10,68,12],[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",15,null,"Reporting Period:","2023-01-01","TO","2023-02-28","Due:","2023-04-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 14'!B15","v":42000},{"$f":"'INVOICE 14'!C15","v":251224},{"$f":"SUM(B15:C15)","v":293224},{"$f":"'INVOICE 14'!E15+'INVOICE 14'!H15","v":16288},{"$f":"'INVOICE 14'!F15+'INVOICE 14'!I15","v":66132},{"$f":"SUM(E15:F15)","v":82420},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":25712},185092,{"$f":"SUM(K15:L15)","v":210804},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 14'!B16","v":0},{"$f":"'INVOICE 14'!C16","v":117},117,{"$f":"'INVOICE 14'!E16+'INVOICE 14'!H16","v":0},{"$f":"'INVOICE 14'!F16+'INVOICE 14'!I16","v":0},{"$f":"SUM(E16:F16)","v":0},0,0,0,0,117,117,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 14'!B17","v":0},{"$f":"'INVOICE 14'!C17","v":0},0,{"$f":"'INVOICE 14'!E17+'INVOICE 14'!H17","v":0},{"$f":"'INVOICE 14'!F17+'INVOICE 14'!I17","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 14'!B18","v":900000},{"$f":"'INVOICE 14'!C18","v":0},900000,{"$f":"'INVOICE 14'!E18+'INVOICE 14'!H18","v":333901},{"$f":"'INVOICE 14'!F18+'INVOICE 14'!I18","v":0},333901,0,0,0,566099,0,566099,"2nd Advance \n[enter date]"]
["Equipment / Fixed Assets",{"$f":"'INVOICE 14'!B19","v":0},{"$f":"'INVOICE 14'!C19","v":0},0,{"$f":"'INVOICE 14'!E19+'INVOICE 14'!H19","v":0},{"$f":"'INVOICE 14'!F19+'INVOICE 14'!I19","v":0},0,0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 14'!B20","v":24000},{"$f":"'INVOICE 14'!C20","v":0},24000,{"$f":"'INVOICE 14'!E20+'INVOICE 14'!H20","v":10000},{"$f":"'INVOICE 14'!F20+'INVOICE 14'!I20","v":0},10000,0,0,0,14000,0,14000]
["Project Evaluation",{"$f":"'INVOICE 14'!B21","v":34000},{"$f":"'INVOICE 14'!C21","v":0},34000,{"$f":"'INVOICE 14'!E21+'INVOICE 14'!H21","v":10000},{"$f":"'INVOICE 14'!F21+'INVOICE 14'!I21","v":0},10000,0,0,0,24000,0,24000,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 14'!B22","v":0},{"$f":"'INVOICE 14'!C22","v":804},{"$f":"SUM(B22:C22)","v":804},{"$f":"'INVOICE 14'!E22+'INVOICE 14'!H22","v":0},{"$f":"'INVOICE 14'!F22+'INVOICE 14'!I22","v":275},275,0,0,0,0,529,529,0]
["Indirect Costs",{"$f":"'INVOICE 14'!B23","v":0},{"$f":"'INVOICE 14'!C23","v":0},0,{"$f":"'INVOICE 14'!E23+'INVOICE 14'!H23","v":0},{"$f":"'INVOICE 14'!F23+'INVOICE 14'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":252145},{"$f":"SUM(D15:D23)","v":1252145},{"$f":"SUM(E15:E23)","v":370189},66407,436596,0,{"$f":"SUM(I15:I23)","v":0},0,629811,185738,815549,{"$f":"SUM(N16+N19+N22)","v":333333}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D26+'INVOICE 15'!I26","v":0},null,"Prior allocated income",0,"This Period",0,null,null,"Unallocated income balance",{"$f":"D26-G26","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":370189},null,null,"Grant funds claimed this period:",{"$f":"H24","v":0},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.1105681105681107}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":66407},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":-36856},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.2633682999861191}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Match",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12081}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-022"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"701 OCEAN ST RM 520"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SANTA CRUZ CA 95060"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"3rd Advance Payment","index":18,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[52,2,52,4],[52,8,52,10],[53,2,53,4],[42,6,42,10],[45,0,45,3],[45,6,45,10],[48,2,48,4],[49,2,49,4],[50,2,50,4],[50,8,50,10],[41,6,41,10],[29,1,29,4],[30,1,30,4],[31,1,31,4],[32,1,32,4],[34,6,34,10],[35,6,35,10],[36,6,36,10],[37,6,37,10],[38,6,38,10],[39,6,39,10],[40,6,40,10],[20,10,20,11],[22,0,22,3],[22,6,22,10],[24,1,24,4],[24,6,24,10],[25,1,25,4],[25,6,33,10],[26,1,26,4],[27,1,27,4],[28,1,28,4],[19,10,19,11],[0,5,2,7],[12,6,14,11],[14,2,14,3],[17,0,17,11],[18,10,18,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,"Purchase Order:",null,2456]
["Advance Payment Invoice: BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"},null,null,null,null,"Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,null,null,null,"Address",{"$f":"'2nd Advance Payment'!J8","v":"701 Ocean St. RM 520"}]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,{"$f":"'2nd Advance Payment'!J10","v":"Santa Cruz, CA 95060"}]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #",null,"3 YRG 2019",null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
[null,"Effective Invoice #"]
[]
[]
["Advance Payment Invoice"]
[null,null,null,null,null,null,null,null,null,"Total Grant Award:",{"$f":"'1st Advance Payment'!K19:L19","v":1000000}]
[null,null,null,null,null,null,null,null,null,"Advance Total:",333334]
[null,null,null,null,null,null,null,null,null,"Grant Award Balance:",{"$f":"'1st Advance Payment'!K19:L19-'1st Advance Payment'!K20:L20-'2nd Advance Payment'!K20:L20-'3rd Advance Payment'!K20:L20","v":0}]
[]
[]
[]
[null,"PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER"]
[null,null,null,null,null,null,"I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[null,"Name, Title"]
[]
[null,"Phone"]
[]
[null,"Email"]
[]
[null,"Date"]
[]
[]
[null,null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,null,"Email"]
[]
[null,null,null,null,null,null,"Date"]
[]
[null,null,null,null,null,null,"Signature"]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,"Approved By:",null,null,null,null,null,null,null,"BSCC Supplier Data "]
[null,null,"BSCC Field Representative",null,null,null,null,null,{"$f":"'2nd Advance Payment'!I51:K51","v":"COUNTYOFSA-022"}]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:",null,null,null,null,null,null,{"$f":"'2nd Advance Payment'!I53:K53","v":12081}]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"MODIFICATION REQUEST","index":19,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":false,"merged":[[0,5,2,7],[5,1,5,3],[5,5,5,7],[5,9,5,11],[7,0,7,12],[59,0,59,2],[19,4,19,6],[34,0,34,12],[54,0,54,2],[56,0,56,2],[58,0,58,2],[35,0,52,12],[57,0,57,2],[55,8,64,12],[54,8,54,12],[33,0,33,12],[19,0,20,0],[19,1,19,3],[19,7,19,9],[19,10,19,12],[74,15,74,16],[74,8,74,10],[73,8,73,10],[63,0,63,2],[60,0,60,2],[61,0,61,2],[62,0,62,2],[73,0,73,1],[69,8,69,12],[70,8,70,12],[65,8,65,12],[66,8,66,12],[67,8,67,12],[68,8,68,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"STATE OF CALIFORNIA"]
["MODIFICATION REQUEST - (FORM BSCC 223.1 (Revised 04/20)",null,null,null,null,null,null,null,null,null,null,null,"BOARD OF STATE AND COMMUNITY CORRECTIONS"]
[]
[]
[null,"Line-Item Change",null,null,null,"Budget Modification",null,null,null,"Project Income Allocation"]
[null,"Check this box if you are modifying narrative details within a line item (or line items) but not changing the budget.",null,null,null,"Check this box if you are modifying line-item dollar amounts by moving funds from one line-item to another.",null,null,null,"Check this box if you are allocating earned project income."]
[]
["Important Note: You must provide a detailed justification for all modification requests. All modifications require BSCC Field Representative approval.  "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"Santa Cruz County"},null,null,null,null,null,null,"Grant Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"}]
[]
["Address",null,null,null,null,null,null,null,"Lead Public Agency:",{"$f":"'INVOICE 1'!G7","v":"N/A"}]
[]
[]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 591-19"},null,null,null,null,null,null,null,"Modification Request #",2]
[]
["Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},{"$f":"'INVOICE 1'!F9","v":"TO"},{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,null,"Effective on Invoice #"]
[]
["Line Items","Current Budget",null,null,"Available Budget",null,null,"Changes (+/-)",null,null,"Modified Budget"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 1'!B15","v":42000},{"$f":"'INVOICE 1'!C15","v":251224},{"$f":"SUM(B22:C22)","v":293224},{"$f":"'INVOICE 2'!K15","v":37625},{"$f":"'INVOICE 2'!L15","v":233926},{"$f":"SUM(E22:F22)","v":271551},0,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":42000},{"$f":"SUM(C22,I22)","v":251224},{"$f":"SUM(K22:L22)","v":293224}]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":117},117,{"$f":"'INVOICE 2'!K16","v":0},{"$f":"'INVOICE 2'!L16","v":117},117,0,0,0,0,117,117]
["Professional Services",{"$f":"'INVOICE 1'!B17","v":0},{"$f":"'INVOICE 1'!C17","v":0},0,{"$f":"'INVOICE 2'!K17","v":0},{"$f":"'INVOICE 2'!L17","v":0},0,0,0,0,0,0,0]
["NGO Subcontracts",{"$f":"'INVOICE 1'!B18","v":900000},{"$f":"'INVOICE 1'!C18","v":0},900000,{"$f":"'INVOICE 2'!K18","v":900000},{"$f":"'INVOICE 2'!L18","v":0},900000,0,0,0,900000,0,900000]
["Equipment / Fixed Assets",{"$f":"'INVOICE 1'!B19","v":0},{"$f":"'INVOICE 1'!C19","v":0},0,{"$f":"'INVOICE 2'!K19","v":0},{"$f":"'INVOICE 2'!L19","v":0},0,0,0,0,0,0,0]
["Data Collection",{"$f":"'INVOICE 1'!B20","v":24000},{"$f":"'INVOICE 1'!C20","v":0},24000,{"$f":"'INVOICE 2'!K20","v":24000},{"$f":"'INVOICE 2'!L20","v":0},24000,0,0,0,24000,0,24000]
["Project Evaluation",{"$f":"'INVOICE 1'!B21","v":34000},{"$f":"'INVOICE 1'!C21","v":0},34000,{"$f":"'INVOICE 2'!K21","v":34000},{"$f":"'INVOICE 2'!L21","v":0},34000,0,0,0,34000,0,34000]
["Other",{"$f":"'INVOICE 1'!B22","v":0},{"$f":"'INVOICE 1'!C22","v":804},804,{"$f":"'INVOICE 2'!K22","v":0},{"$f":"'INVOICE 2'!L22","v":529},529,0,0,0,0,804,804]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":0},{"$f":"'INVOICE 1'!C23","v":0},0,{"$f":"'INVOICE 2'!K23","v":0},{"$f":"'INVOICE 2'!L23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B22:B30)","v":1000000},252145,1252145,995625,234572,1230197,0,0,0,1000000,252145,1252145]
[]
["Project Income",null,"Income reported to date",0,null,"Prior allocated income",0,"Allocating",0,null,null,"Unallocated income balance",{"$f":"D33-I33","v":0}]
[]
["JUSTIFICATION FOR MODIFICATION:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PERSON PREPARING REPORT",null,null,null,null,null,null,null,"AUTHORIZED FINANCIAL OFFICER"]
[null,null,null,null,null,null,null,null,"I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[]
["Name, Title"]
[]
["Phone"]
[]
["Email"]
[]
["Date"]
[]
[]
[null,null,null,null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,null,"Approved By:",null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":" Project Budget","index":20,"n_rows":285,"n_cols":8,"rows_kept":285,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7],[2,0,2,2],[2,3,2,7],[3,0,3,7],[4,0,4,4],[11,0,11,4],[12,0,12,4],[14,0,14,4],[17,0,17,7],[18,0,18,1],[18,2,18,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,4],[22,0,22,1],[22,2,22,4],[23,0,23,1],[23,2,23,4],[24,0,24,1],[24,2,24,4],[19,0,19,1],[19,2,19,4],[20,0,20,1],[20,2,20,4],[21,0,21,1],[21,2,21,4],[28,0,28,1],[28,2,28,4],[29,0,29,1],[29,2,29,4],[30,0,30,1],[30,2,30,4],[25,0,25,1],[25,2,25,4],[26,0,26,1],[26,2,26,4],[27,0,27,1],[27,2,27,4],[60,0,60,1],[60,2,60,4],[61,0,61,1],[61,2,61,4],[62,0,62,1],[62,2,62,4],[31,0,31,4],[34,0,55,7],[57,0,57,7],[58,0,58,1],[58,2,58,4],[59,0,59,1],[59,2,59,4],[66,0,66,4],[68,0,68,2],[69,0,81,7],[83,0,83,7],[84,2,84,4],[85,0,85,1],[85,2,85,4],[63,0,63,1],[63,2,63,4],[64,0,64,1],[64,2,64,4],[65,0,65,1],[65,2,65,4],[89,0,89,1],[89,2,89,4],[90,0,90,1],[90,2,90,4],[91,0,91,1],[91,2,91,4],[86,0,86,1],[86,2,86,4],[87,0,87,1],[87,2,87,4],[88,0,88,1],[88,2,88,4],[95,0,95,4],[98,0,117,7],[119,0,119,7],[120,0,120,1],[120,2,120,4],[121,0,121,1],[121,2,121,4],[92,0,92,1],[92,2,92,4],[93,0,93,1],[93,2,93,4],[94,0,94,1],[94,2,94,4],[125,0,125,1],[125,2,125,4],[126,0,126,1],[126,2,126,4],[127,0,127,1],[127,2,127,4],[122,0,122,1],[122,2,122,4],[123,0,123,1],[123,2,123,4],[124,0,124,1],[124,2,124,4],[133,0,152,7],[154,0,154,7],[155,2,155,4],[156,0,156,1],[156,2,156,4],[157,0,157,1],[157,2,157,4],[128,0,128,1],[128,2,128,4],[129,0,129,1],[129,2,129,4],[130,0,130,4],[132,0,132,7],[161,0,161,4],[164,0,181,7],[183,0,183,7],[184,0,184,4],[185,0,185,4],[186,0,186,4],[158,0,158,1],[158,2,158,4],[159,0,159,1],[159,2,159,4],[160,0,160,1],[160,2,160,4],[218,0,218,4],[219,0,219,4],[220,0,220,4],[221,0,221,4],[222,0,222,4],[225,0,247,7],[187,0,187,4],[188,0,188,4],[189,0,189,4],[192,0,214,7],[216,0,216,7],[217,0,217,4],[253,0,253,1],[253,2,253,4],[254,0,254,1],[254,2,254,4],[255,0,255,1],[255,2,255,4],[249,0,249,7],[250,0,250,1],[250,2,250,4],[251,0,251,1],[251,2,251,4],[252,0,252,1],[252,2,252,4],[280,0,280,3],[281,0,281,3],[282,0,282,4],[285,0,302,7],[256,0,256,1],[256,2,256,4],[257,0,257,4],[260,0,276,7],[278,0,278,7],[279,0,279,4]]}
[]
["Youth Reinvestment Grant - Project Budget and Budget Narrative"]
["Name of County or City:",null,null,"County of Santa Cruz"]
["Program Term: July 1, 2019 - February 28, 2023"]
["Budget Line Item",null,null,null,null,"Grant Funds","Match Funds","Total"]
["1. Salaries and Benefits",null,null,null,null,{"$f":"F32","v":42000},{"$f":"G32","v":251224},{"$f":"H32","v":293224}]
["2. Services and Supplies",null,null,null,null,{"$f":"F67","v":0},{"$f":"G67","v":117},{"$f":"H67","v":117}]
["3. Professional Services",null,null,null,null,{"$f":"F96","v":0},{"$f":"G96","v":0},{"$f":"H96","v":0}]
["4. Non-Governmental Organization (NGO) Subcontracts",null,null,null,null,{"$f":"F131","v":900000},{"$f":"G131","v":0},{"$f":"H131","v":900000}]
["5. Equipment/Fixed Assets",null,null,null,null,{"$f":"F162","v":0},{"$f":"G162","v":0},{"$f":"H162","v":0}]
["6. Data Collection ",null,null,null,null,{"$f":"F190","v":24000},{"$f":"G190","v":0},{"$f":"H190","v":24000}]
["7. Project Evaluation",null,null,null,null,{"$f":"F223","v":34000},{"$f":"G223","v":0},{"$f":"H223","v":34000}]
["8. Other (Travel, Training, etc.)",null,null,null,null,{"$f":"F258","v":0},{"$f":"G258","v":804},{"$f":"H258","v":804}]
["9. Indirect Costs",null,null,null,null,{"$f":"F283","v":0},{"$f":"G283","v":0},{"$f":"H283","v":0}]
["TOTAL",null,null,null,null,{"$f":"SUM(F6:F14)","v":1000000},{"$f":"SUM(G6:G14)","v":252145},{"$f":"SUM(F15:G15)","v":1252145}]
["Required match:","10%: no less than:",{"$f":"F15*10%","v":100000},"25%: no less than:",{"$f":"F15*25%","v":250000}]
[]
["1. Salaries and Benefits"]
["Name and Title",null,"(% FTE or Hourly Rate) & Benefits  ",null,null,"Grant Funds","Match Funds","Total"]
["Rob Doty, Juvenile Division Director (Project Manager)",null,"Year 1: 10% FTE @ $132,306 x 1 year = $13,231 + .1 benefits @ $65,954 = $6,595 = $19,826; Year 2: 10% FTE @ $142,748 x  1/yr  =$14,275 + benefits @ 10% : $7,501 = $21,776 (Yrs 2-4 at increased cost of FTE @ $142,748) Year 4: Sal & Bens at 8 mos/yr = x .6667.",null,null,0,77895,{"$f":"SUM(F20:G20)","v":77895}]
["Miguel Ramirez, Deputy Probation Officer II (Program Lead)",null,"Year 1: 20% FTE @ $73,744 x 1 year = $14,749 + .2 benefits @ $49,368 = $9,874 = $14,774; Year 2&3: 20% FTE @$77,865 x 1 yr =$15,573 + 20% benefits=$10,816 = $15,833; Year 4: 20% FTE @ $77,865 x .6667 year = $10,382 + benefits @ 20%: $54,079 = $7,211 = $12,315",null,null,36239,58755,94994]
["Diane Culcasi, Departmental Systems Analyst (Data Collection & Analysis)",null,"10% FTE @ $112,875 x 1 year = $11,288 + .1 benefits @ $49,770 = $4,977 = $14,639; ",null,null,5761,56482,62243]
["Melissa Allen, Administrative Services Manager (Fiscal Manager)",null,"Year 1: 2.5% FTE @ $128,876 x 1 year = $3,222 + .06 benefits @ $55,034 = $1,376 = $4,598; Year 2: 7% FTE @ $136,391 x 1 year = $9,547 + .07 benefits @ $67,050 = $4,694 = $14,241; Year 3: 7.5% FTE @ $136,391 x 1 year = $10,229 + .075 benefits @ $67,050 = $5,029 = $15,258; Year 4: 9% FTE @ $136,391 x .6667 year = $8,183 + .09 benefits @ $67,050 = $4,023 = $12,206",null,null,0,46303,46303]
["Sven Stafford, CAO Senior Administrative Analyst (Applicant/Grantee Project Manager)",null,"Years 1-3: 2% FTE @ $101,400 x 1 year = $2,028 + .02 benefits @ $59,371 = $1,187 = $3,215; Year 4 @ 8 mos = x 0.667.",null,null,0,11789,11789]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,36239,136650,172889]
["TOTAL",null,null,null,null,{"$f":"SUM(F22:F31)","v":42000},{"$f":"SUM(G22:G31)","v":251224},293224]
[]
["Salaries and Benefits"]
["The Probation Department Juvenile Division Director, serving as the Project Manager, will provide coordination of the \"Community Reclaiming Youth Justice\" project activities with oversight for YRG grant compliance.  This includes coordination and oversight of project implementation, the justice referral system, and data collection and evaluation.  He will facilitate collaboration with the NGOs, Watsonville Police Department, County District Attorney's office, and other justice partners as needed.  He will oversee program compliance with the grant guidelines and work to ensure that the program is using approaches that are evidence-based, culturally relevant, trauma-informed and developmentally appropriate.  He will work closely with the Probation Officer and NGO administering the program to provide the locally needed youth services and ensure the goals of the grant are achieved.  \n\nThe lead Deputy Probation Officer assigned to manage the grant program for the Probation Department will be directly involved in administering the services and related operations.  He will help review and evaluate the probation cases who may be served through this program and work with the NGOs and local justice agencies to provide referrals for youth on our caseloads.  He will also work with the project team to help accomplish the reduction of racial and ethnic disparities in the local youth justice system.  This position will help the team to implement a responsive continuum of interventions in the justice system and work toward addressing mental health, behavioral health and educational issues.  \n\nThe County Departmental Systems Analyst will be responsible for technical data extraction from internal systems, data analysis in concert with project partners, and distribution to the external evaluator.  The Administrative Services Manager will serve as the project Fiscal Manager and will oversee the grant financials and reporting requirements for the Probation Department.  Representing the County Administrative Office as the Applicant/Grantee, the Senior Administrative Analyst will work with the Probation Department to administer the Youth Reinvestment Grant project and to oversee grant compliance and adherence to award requirements."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2. Services and Supplies"]
["Description of Services or Supplies",null,"Calculation for Expenditure",null,null,"Grant Funds","Match Funds","Total"]
["Office Supplies",null,"Minimal allocation for basic office supplies to implement program over 4 yrs.  Years 1-3 @ $30/yr and Yr 4 @ $27/yr.",null,null,0,117,{"$f":"SUM(F60:G60)","v":117}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["TOTAL",null,null,null,null,{"$f":"SUM(F60:F66)","v":0},{"$f":"SUM(G60:G66)","v":117},117]
[]
["Services and Supplies Narrative: "]
["Minimal allocation for basic office supplies needed for Lead Agency to implement program referrals, oversight and coordination of services."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3. Professional Services"]
["Description of Professional Service(s)",null,"Calculation for Expenditure",null,null,"Grant Funds ","Match Funds","Total"]
["N/A",null,null,null,null,0,0,{"$f":"SUM(F86:G86)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["TOTAL",null,null,null,null,{"$f":"SUM(F86:F95)","v":0},{"$f":"SUM(G86:G95)","v":0},0]
[]
["Professional Services Narrative"]
["N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4. Non-Governmental Organizations (NGO) Subcontracts"]
["Description of Subcontract",null,"Calculation for Expenditure",null,null,"Grant Funds","Match Funds","Total"]
["PVPSA - Program Diversion Coordinator",null,"0.54 FTE @ $60,373 x 1 year = $32,601 + benefits @ 35% = $11,410.  FTE total cost increases 3% yearly  w/4.4 % inc in Year 4. ",null,null,168531,0,{"$f":"SUM(F122:G122)","v":168531}]
["PVPSA - Case Manager 1",null,".50 FTE @ $42,507 x 1 year = $21,254 + benefites @ 35% = $7,439, w/annual increase after yr 1",null,null,109587,0,109587]
["PVPSA - Case Manager 2",null,".50 FTE @ $42,507 x 1 year = $21,254 + benefites @ 35% = $7,439, w/annual increase after yr 1",null,null,109587,0,109587]
["PVPSA - Mental Health Clinician",null,"1.00 FTE @ $52,436 x 1 year = $52,436 + benefits @ 35% = $18,353, w/annual increase after yr 1",null,null,270369,0,270369]
["PVPSA - Mileage",null,"25 miles per week x 52 weeks x 2.00 FTE x $.535 per mile = $1,391",null,null,5564,0,5564]
["PVPSA - Facilities",null,"3.00 FTE x 150 sq. ft. x $1.75 cost per sq. ft. x 12 months = $9,450",null,null,37800,0,37800]
["PVPSA - Cell Phone for Coordinator",null,"$30 per month x 12 months = $360",null,null,1440,0,1440]
["PVPSA - Indirect",null,"PVPSA - Indirect costs will be charged as 10% of total direct salaries and wages",null,null,47122,0,47122]
["Other CBO(s) - Other Wrap Services",null,"Specifics TBD",null,null,150000,0,150000]
["TOTALS",null,null,null,null,{"$f":"SUM(F122:F130)","v":900000},{"$f":"SUM(G122:G130)","v":0},900000]
[]
["Non-Governmental Organizations (NGO) Subcontracts Narrative"]
["The coordinated locus of the referral process will be overseen by Pajaro Valley Prevention and Student Assistance (PVPSA), a non-governmental organization (NGO).  Criteria and referral processes will be collaboratively enhanced and or developed by PVPSA and a system of stakeholders actively partnering in this project.  A responsive continuum of interventions will be enhanced and or developed to allow for predictable adolescent missteps and setbacks.  Interventions will range from warn and release to evidence-based modalities that are trauma informed, culturally and developmentally responsive and address mental health, behavioral health and educational issues.  PVPSA will focus on the case management, mental health and behavioral health services. Educational services, employment services and other services determined as needed through program assessments after year 1 will be provided by other CBO(s).  Opportunities for pro-social activities will be key. Program integrity will be ensured by the consistent collection of quantitative and qualitative data and by the Program Diversion Coordinator.  Opportunities for pro-social activities will be key. Program integrity will be ensured by the consistent collection of quantitative and qualitative data and by the Program Diversion Coordinator."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["5. Equipment/Fixed Assets"]
["Description of Equipment/Fixed Asset",null,"Calculation for Expense",null,null,"Grant Funds","Match Funds","Total"]
["N/A",null,null,null,null,0,0,{"$f":"SUM(F157:G157)","v":0}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["TOTALS",null,null,null,null,{"$f":"SUM(F157:F161)","v":0},{"$f":"SUM(G157:G161)","v":0},0]
[]
["Equipment/Fixed Assets Narrative "]
["N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["6. Data Collection"]
["Description",null,null,null,null,"Grant Funds","Match Funds","Total"]
["Applied Survey Research (ASR)",null,null,null,null,24000,0,{"$f":"SUM(F186:G186)","v":24000}]
[null,null,null,null,null,null,null,{"$f":"SUM(F187:G187)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(F188:G188)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(F189:G189)","v":0}]
["TOTAL",null,null,null,null,{"$f":"SUM(F186:F189)","v":24000},{"$f":"SUM(G186:G189)","v":0},{"$f":"SUM(F190:G190)","v":24000}]
[]
["Data  Collection"]
["Applied Survey Research will develop, provide and support a local evaluation plan, provide technical assistance to Probation, CBO(s) and other project partners to ensure consistency in data collection, and help provide summaries of key data points and findings for ongoing monitoring and continuous improvements.  ASR will also develop a final report which may be shared with the community.  The County Departmental Systems Analyst will be responsible for technical data extraction from internal systems, data analysis in concert with project partners, and distribution to the external evaluator."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["7. Project Evaluation"]
["Description",null,null,null,null,"Grant Funds","Match Funds","Total"]
["Applied Survey Research (ASR)",null,null,null,null,34000,0,{"$f":"SUM(F219:G219)","v":34000}]
[null,null,null,null,null,null,null,{"$f":"SUM(F220:G220)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(F221:G221)","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(F222:G222)","v":0}]
["TOTAL",null,null,null,null,{"$f":"SUM(F219:F222)","v":34000},{"$f":"SUM(G219:G222)","v":0},{"$f":"SUM(F223:G223)","v":34000}]
[]
["Project Evaluation Narrative:"]
["Applied Survey Research will support project management by developing and providing an annual evaluation report based on collected data from the current and prior year with a final evaluation in year 4 based on all of the grant years, attend partner meetings and provide technical assistance to Probation, the CBO(s) and other program partners, and provide summaries of key data points and findings for ongoing monitoring and continuous improvements."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["8. Other (Travel, Training, etc.)"]
["Description",null,"Calculation for Expense",null,null,"Grant Funds","Match Funds","Total"]
[null,null,null,null,null,0,804,{"$f":"SUM(F252:G252)","v":804}]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,0]
["TOTAL",null,null,null,null,{"$f":"SUM(F252:F257)","v":0},{"$f":"SUM(G252:G257)","v":804},804]
[]
["Other (Travel, Training, etc.) Narrative:"]
["Year 1: Allocation for staff to attend 1-2 meeting(s) in Sacramento from Santa Cruz in Years 1 and 2 @ $0.58/mile and 144 mi ea way = 288 mi x $0.58/mi = $167 x 2 vehs = $334 + lunch per diem at $17 ea x 4 staff = $68 = $402 total each year."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["9. Indirect Costs"]
["Indirect costs may be charged by choosing only one of options 1) or 2) listed below.",null,null,null,null,"Grant Funds","Match Funds","Total"]
["1. Indirect costs will be charged as 10% of total direct salaries and wages, not to exceed:",null,null,null,{"$f":"SUM(G32)*10%","v":25122.400000000001},0,0,{"$f":"SUM(F281:G281)","v":0}]
["2. Indirect costs will be charged as 5% of direct total direct project costs (excluding equipment) not to exceed:",null,null,null,{"$f":"SUM(G258,G223,G190,G131,G96,G67,G32)*5%","v":12607.25},0,0,{"$f":"SUM(F282:G282)","v":0}]
["If the amount entered turns red, adjust it to not exceed the maximum noted above: TOTAL",null,null,null,null,{"$f":"SUM(F281:F282)","v":0},{"$f":"SUM(G281:G282)","v":0},{"$f":"SUM(H281:H282)","v":0}]
[]
["Indirect Costs Narrative:"]

{"sheet":"INVOICE DUE DATES","index":21,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Invoice #","Reporting Period ","Due Date"]
["Invoice 1","July 1, 2019 to September 30, 2019","2019-11-14"]
["Invoice 2","October 1, 2019 to December 31, 2019","2020-02-14"]
["Invoice 3","January 1, 2020 to March 31, 2020","2020-05-15"]
["Invoice 4","April 1, 2020 to June 30, 2020","2020-08-14"]
["Invoice 5","July 1, 2020 to September 30, 2020","2020-11-16"]
["Invoice 6","October 1, 2020 to December 31, 2020","2021-02-15"]
["Invoice 7","January 1, 2021 to March 31, 2021","2021-05-17"]
["Invoice 8","April 1, 2021 to June 30, 2021","2021-08-16"]
["Invoice 9","July 1, 2021 to September 30, 2021","2021-11-15"]
["Invoice 10","October 1, 2021 to December 31, 2021","2022-02-14"]
["Invoice 11","January 1, 2022 to March 31, 2022","2022-05-16"]
["Invoice 12","April 1, 2022 to June 30, 2022","2022-08-15"]
["Invoice 13","July 1, 2022 to September 30, 2022","2022-11-14"]
["Invoice 14","October 1, 2022 to December 31, 2022","2023-02-14"]
["Invoice 15","January 1, 2023 to February 28, 2023","2023-04-14"]

{"sheet":"INSTRUCTIONS ","index":22,"n_rows":103,"n_cols":1,"rows_kept":103,"cut":false,"hidden":false,"merged":[]}
["Invoice Workbook"]
[]
["How to Locate the Invoice Workbook"]
["Invoice workbooks are located on the Board of State and Community Corrections (BSCC) website under the Corrections Planning and Grant Programs Division (CPGP) webpage: http://www.bscc.ca.gov/s_correctionsplanningandprograms/."]
[]
["On the CPGP webpage, locate the CPGP Quick Links and select Grantee Invoicing."]
[]
["Invoice Workbooks are located under the respective grantee program (e.g., California Violence Intervention and Prevention, Edward Byrne Memorial Justice Assistance Grant, Law Enforcement Assisted Diversion, Proposition 47, etc.)."]
[]
["How to Save the Invoice 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 Invoice 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 Invoice Workbook to their local computer. This will ensure the most current budget information is being used in the Invoice Workbook."]
[]
["Forms Included in the Invoice Workbook "]
["The Invoice Workbook is an Excel file arranged by worksheet tabs (located along the bottom). The tabs included in the Invoice workbook are listed below:"]
["\u0097 Invoice (Form BSCC 201) for each reporting period;"]
["\u0097 Advance Payment (Form BSCC 201) for each of three advance disbursements;"]
["\u0097 Modification Request (Form BSCC 223.1 Rev 4/20);"]
["\u0097 Project Budget Narrative"]
["\u0097 Invoice Due Dates"]
["\u0097 Instructions."]
[]
["Passwords and Formulas in the Invoice Workbook"]
["Each time the grantee opens the Invoice workbook, they will be prompted to enter a password. The password is the grant agreement number (e.g. 990-19, include the -, do not include BSCC)."]
[]
["The Invoice Workbook 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."]
[]
[]
["Financial Invoice - Form BSCC 201"]
[]
["How to Complete a Financial Invoice "]
["Each Financial Invoice has a separate workbook tab titled, INVOICE #. The Financial Invoice will allow grantees to enter data into the green-shaded fields; all other fields are locked. "]
[]
["The following instructions are for the green-shaded fields the Invoice to be completed by the Grantee. "]
[]
[" THIS REPORTING PERIOD"]
["The grantee shall enter the line item expenditures and match contributions incurred during the reporting period."]
["All expenditures should be rounded to the nearest whole dollar; do not enter decimals."]
["If an amount entered into a cell is greater than the available balance, an Invalid Dollar error message will appear. If the error is typographical, select Retry and enter the correct amount. If the amount entered is correct, however greater than the available balance, select Cancel and submit a Budget Modification. See, Budget Modification details below. "]
[]
["EXPENDITURE DESCRIPTION"]
["For each dollar amount entered as an expenditure, enter a brief but detailed description. Your expenditures should correlate to Project Budget Narrative, which is listed on its own tab along with approved modification requests. "]
[]
[" PERSON PREPARING REPORT"]
["The grantee will designate an individual to prepare invoices. The Authorized Financial Officer cannot prepare invoices. "]
["The individual who prepares invoices will provide their contact information and the date the invoice was prepared under the PERSON PREPARING REPORT section. Then, forward the Invoice Workbook to the Authorized Financial Officer for review and approval."]
[]
[" AUTHORIZED FINANCIAL OFFICER"]
["The Authorized Financial Officer is the Financial Officer listed in the Grant Agreement, STD 213 and/or Grantee Contact Information Sheet, Form 227."]
["The Authorized Financial Officer cannot be the Project Director or the individual preparing the invoice."]
["The Authorized Financial Officer must review each line item expenditure and description. Then, approve the invoice by checking the certification box and providing their contact information and the date of approval."]
["Once the invoice is approved, the Authorized Financial Officer shall email the Invoice Workbook to the any grant inbox: anygrant@bscc.ca.gov. The Authorized Financial Officer is the only authorized party to submit an Invoice Workbook to the BSCC."]
["Approved Financial Invoice "]
["Once BSCC staff reviews and approves the Financial Invoice, an updated Invoice Workbook will be available on the BSCC website. All approved Financial Invoices will be locked from editing but will be viewable in the Invoice Workbook."]
[]
["Advance Payment Invoice – Form 201A"]
[]
["How to Complete the Advance Payment Invoice "]
["Each Advance Payment Invoice has a separate workbook tab titled, # ADVANCE PAYMENT. The Advance Payment Invoice will allow grantees to enter data into the green shaded fields; all other fields are locked. "]
["To complete the Advance Payment form, grantees must complete the following:"]
["\u0097 Idenitfy the effective invoice"]
["\u0097\u0097\u0097 Idenitfy the person preparing the report"]
["\u0097 Complete the information and signature for the Authorized Financial Officer."]
["Advance Disbursement Details"]
["Grantees will receive three advance payments throughout the life of the grant agreement. Each advance payment will be one-third of the total grant award."]
["Eight percent of the total advance disbursement must be expended prior to requesting the next advance payment."]
["Approved Advance Payment Invoice"]
["Once BSCC staff reviews and approves the Advance Payment Invoice, the updated Invoice Workbook will be emailed to the Authorized Financial Officer and the individual that prepared the report. All approved Advance Payment Invoices will be locked from editing but will be viewable in the Invoice Workbook."]
[]
["Modification Request - Form BSCC 223.1"]
[]
["Modification Request Requirements "]
["It is the grantees responsibility to receive prior approval from the Field Representative for modifications to the budget or budget narrative. Once the Field Representative approves a modification to the budget or budget narrative, the grantee may complete and submit a Modification Request."]
["The Modification Request Form allows the grantee to:\n\u0097 Make a change within a line-item change that modifies the grant project narrative, but does not change the total dollar amount of the line item.\n\u0097 Modify the budget by moving funds from one line item to another; or\n\u0097 Allocate earned project income "]
[]
["The grantee must allow a minimum of 10 working days, for the modification form to be submitted and approved by the BSCC prior to completing the next invoice."]
[]
["How to Complete a Modification Request "]
["Grantees can access the Modification Request form by selecting the tab titled, MODIFICATION REQUEST. For the Modification Request form, grantees can enter data into the yellow-shaded fields; all other fields are locked. First, the grantee must select the purpose of the modification by checking the appropriate box in the yellow section at the top of the form."]
[]
["The following instructions are for the yellow-shaded fields in the Modification Request to be completed by the Grantee. "]
[]
["Modification Request # and Effective on Invoice #"]
["The grantee shall identify the budget modification number by selecting the next number in sequential order (1 if it's the first) and then identify on which invoice the modification becomes effective."]
[]
[" CHANGES (+/-) and JUSTIFICATION FOR MODIFIED BUDGET"]
["Line-item changes -   Complete only the JUSTIFICATION FOR MODIFICATION section below the budget table. The justification must: list the affected line-item(s), detail how the original budget narrative has changed, and explain why the change is necessary. Line-item changes do not change  the budget $$.\n\nBudget modifications - complete the CHANGES (+/-) section by using a + (plus symbol) followed by a whole dollar amount in the line item that is increasing and using a - (minus symbol) followed by a whole dollar amount in the line item that is decreasing. The TOTAL line must show zeros. In addition, complete the JUSTIFICATION FOR MODIFICATION section. The justification must: list the affected line-item(s), detail how the original budget narrative has changed, and explain why the change is necessary\n\nProject Income Allocation - use the Grant Funds column in the CHANGES (+/-) to show how the income will be allocated across line-items. In the Total Allocating box on the Project Income line copy the amount shown in the TOTAL line  of Grant Funds column. In addition, complete the JUSTIFICATION FOR MODIFICATION section. The justification must: list the affected line-item(s) and provide narrative detail about how the project income will be used to advance program objectives. (See Grant Administration Guide, Section 13, Project and Other Income)"]
[]
["PERSON PREPARING REPORT"]
["The grantee will designate an individual to prepare Modification Requests. The Authorized Financial Officer cannot prepare Modification Requests."]
["The individual who prepares the request will provide their contact information and the date the modification was prepared under the PERSON PREPARING REPORT section. Then, forward the Invoice Workbook to the Authorized Financial Officer for review and approval."]
[]
[" AUTHORIZED FINANCIAL OFFICER"]
["The Authorized Financial Officer is the Financial Officer listed in the Grant Agreement, STD 213 and/or Grantee Contact Information Sheet, Form 227."]
["The Authorized Financial Officer cannot be the Project Director or the individual preparing the modification request."]
["The Authorized Financial Officer must review each line item change, narrative change and justifications. Then, approve the modification request by checking the certification box and providing their contact information and the date of approval."]
["Once the modification request is approved, the Authorized Financial Officer shall email the Invoice Workbook to the any grant inbox: anygrant@bscc.ca.gov. The Authorized Financial Officer is the only authorized party to submit it an Invoice Workbook to the BSCC."]
[]
["Approved Modification Request"]
["Once BSCC staff reviews and approves the Modification Request, the updated Invoice Workbook will be emailed to the Authorized Financial Officer and the individual who prepared the re quest. All approved modifications will be locked from editing but will be viewable in the Invoice Workbook."]