{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["1st Advance Payment","INVOICE 1","MOD 1","INVOICE 2","INVOICE 3","MOD 2","INVOICE 4","MOD 3","INVOICE 5","INVOICE 6","INVOICE 7","INVOICE 8","MOD 4","INVOICE 9","INVOICE 10","INVOICE 11","INVOICE 12","INVOICE 13","INVOICE 14","INVOICE 15","2nd Advance Payment","3rd Advance Payment","MODIFICATION REQUEST","PROJECT BUDGET NARRATIVE","INVOICE DUE DATES","INSTRUCTIONS "],"not_rendered":{"charts":0,"images":43,"macros":1,"external_links":0,"defined_names":29,"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":[[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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-19"},null,null,null,null,"Address",null,"2314 N 1st St."]
[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,"San Jose, CA 95131"]
[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 Busgard",null,null,null,null,null,null,"BSCC Supplier Data "]
[null,null,"BSCC Field Representative",null,null,null,null,null,"COUNTYOFSA-020"]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:","2019-09-09",null,null,null,null,null,12077]
[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":[[37,11,37,13],[38,11,38,13],[39,11,39,13],[40,11,40,13],[41,11,41,13],[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],[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],[42,11,42,13],[43,11,43,13],[44,11,44,13],[45,11,45,13],[46,11,46,13],[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],[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],[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],[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]]}
["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,2455]
["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:","COUNTY OF SANTA CLARA",null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:","BSCC 590-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",54221,249371,{"$f":"SUM(B15:C15)","v":303592},0,0,{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":54221},{"$f":"C15-F15-I15","v":249371},{"$f":"SUM(K15:L15)","v":303592},"1st Advance [10/25/19]"]
["Services & Supplies",0,0,0,0,0,{"$f":"SUM(E16:F16)","v":0},0,0,0,0,0,0,{"$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",0,0,0,0,0,0,0,0,0,0,0,0]
["Project Evaluation",33733,0,33733,0,0,0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",6625,629,{"$f":"SUM(B22:C22)","v":7254},0,0,0,0,0,0,6625,629,7254,0]
["Indirect Costs",5421,0,5421,0,0,0,0,0,0,5421,0,5421]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":0},0,0,0,{"$f":"SUM(I15:I23)","v":0},0,1000000,250000,1250000,{"$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":0},null,null,"Grant funds claimed this period:",{"$f":"H24","v":0},null,null,null,"Percentage Grant $$ expended to date:","Percentage Grant $$ expended to date:",{"$f":"D28/N24","v":0}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":0},null,null,null,null,null,null,null,"% of Total Obligated Match to date:","% of Total Obligated Match to date:",{"$f":"D29/C24","v":0}]
[]
[]
[]
[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."]
["Jennifer Del Bono, Director, SCCOE",null,null,null,null,null,null,null,null,null,null,12077]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["408-453-6784",null,null,null,null,null,null,null,null,null,null,"COUNTYOFSA-020"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jennifer_delbono@sccoe.org",null,null,null,null,null,null,null,null,null,null,"2314 N 1ST ST"]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2019-11-13",null,null,null,null,null,null,null,null,null,null,"SAN JOSE CA 95131"]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"ThuyTrang Nguyen, Department Fiscal Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(408)468-1646"]
[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":"MOD 1","index":2,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":false,"merged":[[74,8,74,10],[74,15,74,16],[67,8,67,12],[68,8,68,12],[69,8,69,12],[70,8,70,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],[33,0,33,12],[34,0,34,12],[35,0,52,12],[54,0,54,2],[54,8,54,12],[0,5,2,7],[5,1,5,3],[5,5,5,7],[5,9,5,11],[7,0,7,12],[19,0,20,0],[19,1,19,3],[19,4,19,6],[19,7,19,9],[19,10,19,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":"COUNTY OF SANTA CLARA"},null,null,null,null,null,null,"Grant Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"}]
[]
["Address",{"$f":"'1st Advance Payment'!J8","v":"2314 N 1st St."},null,null,null,null,null,null,"Lead Public Agency:",{"$f":"'INVOICE 1'!G7","v":"N/A"}]
[]
[null,{"$f":"'1st Advance Payment'!J10","v":"San Jose, CA 95131"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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 #",2]
[]
["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",54221,249371,{"$f":"SUM(B22:C22)","v":303592},{"$f":"'INVOICE 1'!K15","v":54221},{"$f":"'INVOICE 1'!L15","v":249371},{"$f":"SUM(E22:F22)","v":303592},0,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":54221},249371,{"$f":"SUM(K22:L22)","v":303592}]
["Services & Supplies",0,0,0,{"$f":"'INVOICE 1'!K16","v":0},{"$f":"'INVOICE 1'!L16","v":0},0,0,0,0,0,0,0]
["Professional Services",0,0,0,{"$f":"'INVOICE 1'!K17","v":0},{"$f":"'INVOICE 1'!L17","v":0},0,0,0,0,0,0,0]
["NGO Subcontracts",900000,0,900000,{"$f":"'INVOICE 1'!K18","v":900000},{"$f":"'INVOICE 1'!L18","v":0},900000,0,0,0,900000,0,900000]
["Equipment / Fixed Assets",0,0,0,{"$f":"'INVOICE 1'!K19","v":0},{"$f":"'INVOICE 1'!L19","v":0},0,0,0,0,0,0,0]
["Data Collection",0,0,0,{"$f":"'INVOICE 1'!K20","v":0},{"$f":"'INVOICE 1'!L20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",33733,0,33733,{"$f":"'INVOICE 1'!K21","v":33733},{"$f":"'INVOICE 1'!L21","v":0},33733,0,0,0,33733,0,33733]
["Other",6625,629,7254,{"$f":"'INVOICE 1'!K22","v":6625},{"$f":"'INVOICE 1'!L22","v":629},7254,0,0,0,6625,629,7254]
["Indirect Costs",5421,0,5421,{"$f":"'INVOICE 1'!K23","v":5421},{"$f":"'INVOICE 1'!L23","v":0},5421,0,0,0,5421,0,5421]
["TOTAL",{"$f":"SUM(B22:B30)","v":1000000},250000,1250000,{"$f":"'INVOICE 1'!K24","v":1000000},{"$f":"'INVOICE 1'!L24","v":250000},1250000,0,0,0,1000000,250000,1250000]
[]
["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:"]
["Alex Coronel will be added as personnel supporting the grant with administrative duties.  She will be paid through June 30th, 2020 to support the grant yet the payments will not exceed $10,000.  Funds will be shifted from Stephanie Tague and Jennifer Del Bono grant funds to cover the costs.   Alex will support the grant process by ensuring the MOUs with the CBOs are fully executed, communicate to CBOs regarding the grant reporting requirements, schedule meetings with the oversight committee and grant partners, and support the invoice and grant reporting deadlines.  Hourly rate = $54.24.   Alex Coronel will be preparing the reports and invoices.  `"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]
["Jennifer Del Bono, Director, SCCOE"]
["Name, Title"]
["408-453-6784"]
["Phone"]
["jennifer_delbono@sccoe.org"]
["Email"]
["2019-11-13"]
["Date"]
[]
[null,null,null,null,null,null,null,null,"ThuyTrang Nguyen, Department Fiscal Officer"]
[null,null,null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,null,null,"(408)468-1646"]
[null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,"2019-11-15"]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2019-11-15",null,null,null,null,"Approved By:","Kimberly Bushard",null,null,"Date:","2019-11-20"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 2","index":3,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[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],[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],[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],[51,0,51,1],[52,0,52,2],[52,4,52,9],[52,11,52,13],[53,0,53,2],[47,0,48,0],[47,3,47,10],[48,3,48,10],[47,11,47,13],[48,11,48,13],[49,0,50,0],[49,3,49,10],[50,3,50,10],[49,11,49,13],[50,11,50,13],[43,0,44,0],[43,3,43,10],[44,3,44,10],[43,11,43,13],[44,11,44,13],[45,0,46,0],[45,3,45,10],[46,3,46,10],[45,11,45,13],[46,11,46,13],[39,0,40,0],[39,3,39,10],[40,3,40,10],[39,11,39,13],[40,11,40,13],[41,0,42,0],[41,3,41,10],[42,3,42,10],[41,11,41,13],[42,11,42,13],[35,0,36,0],[35,3,35,10],[36,3,36,10],[35,11,35,13],[36,11,36,13],[37,0,38,0],[37,3,37,10],[38,3,38,10],[37,11,37,13],[38,11,38,13],[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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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:","0/14/2020",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":54221},{"$f":"'INVOICE 1'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 1'!E15+'INVOICE 1'!H15","v":0},{"$f":"'INVOICE 1'!F15+'INVOICE 1'!I15","v":0},{"$f":"SUM(E15:F15)","v":0},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":54221},249371,{"$f":"SUM(K15:L15)","v":303592},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":0},0,{"$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,0,0,{"$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":0},{"$f":"'INVOICE 1'!C20","v":0},0,{"$f":"'INVOICE 1'!E20+'INVOICE 1'!H20","v":0},{"$f":"'INVOICE 1'!F20+'INVOICE 1'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 1'!B21","v":33733},{"$f":"'INVOICE 1'!C21","v":0},33733,{"$f":"'INVOICE 1'!E21+'INVOICE 1'!H21","v":0},{"$f":"'INVOICE 1'!F21+'INVOICE 1'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 1'!B22","v":6625},{"$f":"'INVOICE 1'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 1'!E22+'INVOICE 1'!H22","v":0},{"$f":"'INVOICE 1'!F22+'INVOICE 1'!I22","v":0},0,0,0,0,6625,629,7254,0]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":5421},{"$f":"'INVOICE 1'!C23","v":0},5421,{"$f":"'INVOICE 1'!E23+'INVOICE 1'!H23","v":0},{"$f":"'INVOICE 1'!F23+'INVOICE 1'!I23","v":0},0,0,0,0,5421,0,5421]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":0},0,0,0,{"$f":"SUM(I15:I23)","v":0},0,1000000,250000,1250000,{"$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":0},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":0}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":0},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":333333},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0}]
[]
[]
[]
[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."]
["KimThu Nguyen - Accountant II",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12077}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["408-435-2156",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["kimthu.nguyen@pro.scc.gov",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"2314 N 1ST ST"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-02-18",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SAN JOSE CA 95131"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Roseanne Rodarte, Executive Admin. Services Manager"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(408)468-1658"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-02-18"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-02-18",null,null,null,"Approved By:",null,"Kimberly Bushard"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 3","index":4,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 2'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 2'!E15+'INVOICE 2'!H15","v":0},{"$f":"'INVOICE 2'!F15+'INVOICE 2'!I15","v":0},{"$f":"SUM(E15:F15)","v":0},3240,550,{"$f":"SUM(H15:I15)","v":3790},{"$f":"B15-E15-H15","v":50981},248821,{"$f":"SUM(K15:L15)","v":299802},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 2'!B16","v":0},{"$f":"'INVOICE 2'!C16","v":0},0,{"$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,0,0,{"$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,2500,0,2500,897500,0,897500,"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":0},{"$f":"'INVOICE 2'!C20","v":0},0,{"$f":"'INVOICE 2'!E20+'INVOICE 2'!H20","v":0},{"$f":"'INVOICE 2'!F20+'INVOICE 2'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 2'!B21","v":33733},{"$f":"'INVOICE 2'!C21","v":0},33733,{"$f":"'INVOICE 2'!E21+'INVOICE 2'!H21","v":0},{"$f":"'INVOICE 2'!F21+'INVOICE 2'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 2'!B22","v":6625},{"$f":"'INVOICE 2'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 2'!E22+'INVOICE 2'!H22","v":0},{"$f":"'INVOICE 2'!F22+'INVOICE 2'!I22","v":0},0,156,0,156,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 2'!B23","v":5421},{"$f":"'INVOICE 2'!C23","v":0},5421,{"$f":"'INVOICE 2'!E23+'INVOICE 2'!H23","v":0},{"$f":"'INVOICE 2'!F23+'INVOICE 2'!I23","v":0},0,135,0,135,5286,0,5286]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":0},0,0,6031,{"$f":"SUM(I15:I23)","v":550},6581,993969,249450,1243419,{"$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":6031},null,null,"Grant funds claimed this period:",{"$f":"H24","v":6031},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":1.8093018093018092E-2}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":550},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":327302},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":2.2000000000000001E-3}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":3240},"I project personnel (Alex Coronel*): 12h @ 46.77 + benefits = 608.13, 41h @ 50.60 + benefits = 2300.87, and 5.75h @ 53.00 + benefits = 330.71, total = 3,239.71   *Alex Coronel added as project personnnel with a budget modification.",null,null,null,null,null,null,null,"see attached document #1,2,3 for salary & beneifts breakdown, documents attached"]
[null,"Match",{"$f":"I15","v":550},"Stephanie Tague - Brief Intervention Facilitation, 6hrs @ 91.67 (benefits included) = 550.02",null,null,null,null,null,null,null,"see attached document # 4 for salary & beneifts breakdown, documents attached"]
["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":2500},"NGO Subcontract Invoice - Community Agency for Resources, Advocacy and Services (CARAS), $2500 in Salary + Benefits for case management",null,null,null,null,null,null,null,"see attached document # 3"]
[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":156},"Travel to BSCC Orientation Meeting",null,null,null,null,null,null,null,"see attached document # 5"]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":135},"Indirect cost fee at 9.74%",null,null,null,null,null,null,null,"see attached documents # 1, 2"]
[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."]
["Alex Coronel, Administrative Data Technician",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12077}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["(408) 453-4347",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["acoronel@sccoe.org",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"2314 N 1ST ST"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-05-28",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SAN JOSE CA 95131"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"ThuyTrang Nguyen - Department Fiscal Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"408-468-1658"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-09-11"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-10-13",null,null,null,"Approved By:",null,"Kimberly Bushard"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"MOD 2","index":5,"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:","COUNTY OF SANTA CLARA",null,null,null,null,null,null,"Grant Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"}]
[]
["Address","2314 N 1ST ST",null,null,null,null,null,null,"Lead Public Agency:",{"$f":"'INVOICE 1'!G7","v":"N/A"}]
[]
[null,"SAN JOSE CA 95131"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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 #",4]
[]
["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":54221},{"$f":"'INVOICE 1'!C15","v":249371},{"$f":"SUM(B22:C22)","v":303592},{"$f":"'INVOICE 2'!K15","v":54221},{"$f":"'INVOICE 2'!L15","v":249371},{"$f":"SUM(E22:F22)","v":303592},null,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":54221},249371,{"$f":"SUM(K22:L22)","v":303592}]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":0},0,{"$f":"'INVOICE 2'!K16","v":0},{"$f":"'INVOICE 2'!L16","v":0},0,0,0,0,0,0,0]
["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":0},{"$f":"'INVOICE 1'!C20","v":0},0,{"$f":"'INVOICE 2'!K20","v":0},{"$f":"'INVOICE 2'!L20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 1'!B21","v":33733},{"$f":"'INVOICE 1'!C21","v":0},33733,{"$f":"'INVOICE 2'!K21","v":33733},{"$f":"'INVOICE 2'!L21","v":0},33733,0,0,0,33733,0,33733]
["Other",{"$f":"'INVOICE 1'!B22","v":6625},{"$f":"'INVOICE 1'!C22","v":629},7254,{"$f":"'INVOICE 2'!K22","v":6625},{"$f":"'INVOICE 2'!L22","v":629},7254,0,0,0,6625,629,7254]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":5421},{"$f":"'INVOICE 1'!C23","v":0},5421,{"$f":"'INVOICE 2'!K23","v":5421},{"$f":"'INVOICE 2'!L23","v":0},5421,0,0,0,5421,0,5421]
["TOTAL",{"$f":"SUM(B22:B30)","v":1000000},250000,1250000,1000000,250000,1250000,0,0,0,1000000,250000,1250000]
[]
["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:"]
["Due to Corona Virus relief efforts, the Santa Clara County Office of Education's Safe and Healthy Schools Director, Jennifer Del Bono, has requested that we are approved to calculate her hours as match hours under the grant.The request was to identify the hours/funding that Christina Arpante was originally allocated in the budget for match dollars, to Jennifer Del Bono, as Christina is designated to COVID-19 relief. The request has been submitted to BSCC. The amount of Match funding that is being adjusted is 7.44% of the total match funding ($249,371), and 1.48% of the overall grant dollars (State + Match funding). Once the budet modification is approved via BSCC the Match hours Jennifer is contributing will be requested in the Q4 submission. Jennifer's Match Contribution: .1163 FTE @ $159,463 =$18,555"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]
["Alex Coronel, Administrative Data Technician"]
["Name, Title"]
["(408) 453-4347"]
["Phone"]
["acoronel@sccoe.org"]
["Email"]
["2020-05-28"]
["Date"]
[]
[null,null,null,null,null,null,null,null,"ThuyTrang Nguyen, Department  Fiscal Officer"]
[null,null,null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,null,null,"(408)468-1646"]
[null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,"2020-06-10"]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-06-10",null,null,null,null,"Approved By:","Kimberly Bushard",null,null,"Date:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 4","index":6,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 3'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 3'!E15+'INVOICE 3'!H15","v":3240},{"$f":"'INVOICE 3'!F15+'INVOICE 3'!I15","v":550},{"$f":"SUM(E15:F15)","v":3790},1926,{"$f":"64.5*99.8","v":6437.0999999999995},{"$f":"SUM(H15:I15)","v":8363.0999999999985},{"$f":"B15-E15-H15","v":49055},242383.9,{"$f":"SUM(K15:L15)","v":291438.90000000002},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 3'!B16","v":0},{"$f":"'INVOICE 3'!C16","v":0},0,{"$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,0,0,{"$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":2500},{"$f":"'INVOICE 3'!F18+'INVOICE 3'!I18","v":0},2500,86580,0,86580,810920,0,810920,"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":0},{"$f":"'INVOICE 3'!C20","v":0},0,{"$f":"'INVOICE 3'!E20+'INVOICE 3'!H20","v":0},{"$f":"'INVOICE 3'!F20+'INVOICE 3'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 3'!B21","v":33733},{"$f":"'INVOICE 3'!C21","v":0},33733,{"$f":"'INVOICE 3'!E21+'INVOICE 3'!H21","v":0},{"$f":"'INVOICE 3'!F21+'INVOICE 3'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 3'!B22","v":6625},{"$f":"'INVOICE 3'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 3'!E22+'INVOICE 3'!H22","v":156},{"$f":"'INVOICE 3'!F22+'INVOICE 3'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 3'!B23","v":5421},{"$f":"'INVOICE 3'!C23","v":0},5421,{"$f":"'INVOICE 3'!E23+'INVOICE 3'!H23","v":135},{"$f":"'INVOICE 3'!F23+'INVOICE 3'!I23","v":0},135,368,0,368,4918,0,4918]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":6031},550,6581,88874,{"$f":"SUM(I15:I23)","v":6437.0999999999995},95311.1,905095,243012.9,1148107.8999999999,{"$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":94905},null,null,"Grant funds claimed this period:",{"$f":"H24","v":88874},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.28471528471528473}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":6987.0999999999995},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":238428},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":2.7948399999999998E-2}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":1926},"1 project personnel: 33.5 hours X$53/hr=$1,775.50 + benefits 8.5%= $1,926"]
[null,"Match",{"$f":"I15","v":6437.0999999999995},"Jennifer Del Bono -  Q3  & Q4, totalling 64.5 hours X 99.80/hr =$6,437.10 (benefits included in the hourly rate) "]
["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":86580},"NGO Subcontracts: 3 partnering NGOs staff salary + benefits; ConXion ($18,734.43); Living Above the Influence ($48,800); Community Agency for Resources, Advocacy, and Services ($19,046.30)"]
[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":368},"9.74% of Salaries & Bendfits of March, May , and June 2020  invoices"]
[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."]
["Alex Coronel, Admin Data Tech",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12077}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["408-453-4347",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["acoronel@sccoe.org",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"2314 N 1ST ST"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-08-21",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SAN JOSE CA 95131"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"ThuyTrang Nguyen  -  Department Fiscal Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(408)468-1646"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-08-21"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-10-13",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"MOD 3","index":7,"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":"COUNTY OF SANTA CLARA"},null,null,null,null,null,null,"Grant Program:",{"$f":"'INVOICE 1'!B5","v":"Youth Reinvestment Grant"}]
[]
["Address","2314 N 1ST ST",null,null,null,null,null,null,"Lead Public Agency:",{"$f":"'INVOICE 1'!G7","v":"N/A"}]
[]
[null,"SAN JOSE CA 95131"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-19"},null,null,null,null,null,null,null,"Modification Request #",3]
[]
["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 #",5]
[]
["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":54221},{"$f":"'INVOICE 1'!C15","v":249371},{"$f":"SUM(B22:C22)","v":303592},{"$f":"'INVOICE 2'!K15","v":54221},{"$f":"'INVOICE 2'!L15","v":249371},{"$f":"SUM(E22:F22)","v":303592},0,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":54221},249371,{"$f":"SUM(K22:L22)","v":303592}]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":0},0,{"$f":"'INVOICE 2'!K16","v":0},{"$f":"'INVOICE 2'!L16","v":0},0,0,0,0,0,0,0]
["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":0},{"$f":"'INVOICE 1'!C20","v":0},0,{"$f":"'INVOICE 2'!K20","v":0},{"$f":"'INVOICE 2'!L20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 1'!B21","v":33733},{"$f":"'INVOICE 1'!C21","v":0},33733,{"$f":"'INVOICE 2'!K21","v":33733},{"$f":"'INVOICE 2'!L21","v":0},33733,0,0,0,33733,0,33733]
["Other",{"$f":"'INVOICE 1'!B22","v":6625},{"$f":"'INVOICE 1'!C22","v":629},7254,{"$f":"'INVOICE 2'!K22","v":6625},{"$f":"'INVOICE 2'!L22","v":629},7254,0,0,0,6625,629,7254]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":5421},{"$f":"'INVOICE 1'!C23","v":0},5421,{"$f":"'INVOICE 2'!K23","v":5421},{"$f":"'INVOICE 2'!L23","v":0},5421,0,0,0,5421,0,5421]
["TOTAL",{"$f":"SUM(B22:B30)","v":1000000},250000,1250000,1000000,250000,1250000,0,0,0,1000000,250000,1250000]
[]
["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:"]
["Alex Coronel will be added as personnel supporting the grant with Administrative Duties. She will be paid through June 30, 2023 to support the grant yet the salary payments will not exceed $10,000 annually. Funds will be shifted from Stephanie Tague and Jennifer Del Bono (David Putney (see below)) grant funds to cover the costs (7,729+7,076=$14,805.00). Alex will support the grant process by ensuring the MOUs with the CBOs are fully executed, communicate to CBOs regarding the grant reporting requirements, schedule meetings with the oversight committee and grant partners, and support the invoice with grant reporting deadlines. Hourly rate = $53.53. Alex Coronel will be preparing the reports and invoices.    ||   In the 2019-20 grant year, we submitted a budget modification to move the Match funds allocated to Christina Arpante under Jennifer Del Bono as Dr. Arpante was delegated to Emergency Command for COVID. At the end of Fiscal Year 20, Jennifer Del Bono's employment with the SCCOE ended, and the grant has since been moved to a new director, David Putney. All Match dollars ($18,555) initially allocated to Christina Arpante, will now be moved under David Putney (.0753% FTE @ $191,171 = $14,395.18 + benefits at 28.91%= $4,161.65 = $18,556.83). Both Budget Modification requests do not change any amounts in any line item - rather the names attached to those amounts are what is changed. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]
["Alex Coronel"]
["Name, Title"]
["408-453-4347"]
["Phone"]
["acoronel@sccoe.org"]
["Email"]
["2020-09-14"]
["Date"]
[]
[null,null,null,null,null,null,null,null," ThuyTrang Nguyen, Department Fiscal Officer"]
[null,null,null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,null,null,"(408) 468-1646"]
[null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,"2020-09-16"]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-09-17",null,null,null,null,"Approved By:","Kimberly Bushard",null,null,"Date:","2020-12-08"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 5","index":8,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 4'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 4'!E15+'INVOICE 4'!H15","v":5166},{"$f":"'INVOICE 4'!F15+'INVOICE 4'!I15","v":6987.0999999999995},{"$f":"SUM(E15:F15)","v":12153.099999999999},2410,0,{"$f":"SUM(H15:I15)","v":2410},{"$f":"B15-E15-H15","v":46645},242383.9,{"$f":"SUM(K15:L15)","v":289028.90000000002},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 4'!B16","v":0},{"$f":"'INVOICE 4'!C16","v":0},0,{"$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,0,0,{"$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":89080},{"$f":"'INVOICE 4'!F18+'INVOICE 4'!I18","v":0},89080,0,0,0,810920,0,810920,"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":0},{"$f":"'INVOICE 4'!C20","v":0},0,{"$f":"'INVOICE 4'!E20+'INVOICE 4'!H20","v":0},{"$f":"'INVOICE 4'!F20+'INVOICE 4'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 4'!B21","v":33733},{"$f":"'INVOICE 4'!C21","v":0},33733,{"$f":"'INVOICE 4'!E21+'INVOICE 4'!H21","v":0},{"$f":"'INVOICE 4'!F21+'INVOICE 4'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 4'!B22","v":6625},{"$f":"'INVOICE 4'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 4'!E22+'INVOICE 4'!H22","v":156},{"$f":"'INVOICE 4'!F22+'INVOICE 4'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 4'!B23","v":5421},{"$f":"'INVOICE 4'!C23","v":0},5421,{"$f":"'INVOICE 4'!E23+'INVOICE 4'!H23","v":503},{"$f":"'INVOICE 4'!F23+'INVOICE 4'!I23","v":0},503,241,0,241,4677,0,4677]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":94905},6987.0999999999995,101892.1,2651,{"$f":"SUM(I15:I23)","v":0},2651,902444,243012.9,1145456.8999999999,{"$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":97556},null,null,"Grant funds claimed this period:",{"$f":"H24","v":2651},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.2926682926682927}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":6987.0999999999995},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":235777},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":2.7948399999999998E-2}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":2410},"Alex Coronel: 5.5hrs @ $53/hr + benefits = $316.26, 30.5hrs @ $50.48/hr + benefits = $1670.40, 7.5hrs @ 51.99 + benefits = $423.04"]
[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":241},"10% of Salaries and Benefits (2409.70*.10=240.97)"]
[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."]
["Alex Coronel, Admin Data Tech",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12077}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["408-453-4347",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["acoronel@sccoe.org",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"2314 N 1ST ST"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-11-05",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SAN JOSE CA 95131"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"ThuyTrang Nguyen - Department Fiscal Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"(408)468-1646"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-11-13"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"11/131/20",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 6","index":9,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 5'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 5'!E15+'INVOICE 5'!H15","v":7576},{"$f":"'INVOICE 5'!F15+'INVOICE 5'!I15","v":6987.0999999999995},{"$f":"SUM(E15:F15)","v":14563.099999999999},2416,1327.84,{"$f":"SUM(H15:I15)","v":3743.84},{"$f":"B15-E15-H15","v":44229},241056.06,{"$f":"SUM(K15:L15)","v":285285.06},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 5'!B16","v":0},{"$f":"'INVOICE 5'!C16","v":0},0,{"$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,0,0,{"$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":89080},{"$f":"'INVOICE 5'!F18+'INVOICE 5'!I18","v":0},89080,70637,0,70637,740283,0,740283,"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":0},{"$f":"'INVOICE 5'!C20","v":0},0,{"$f":"'INVOICE 5'!E20+'INVOICE 5'!H20","v":0},{"$f":"'INVOICE 5'!F20+'INVOICE 5'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 5'!B21","v":33733},{"$f":"'INVOICE 5'!C21","v":0},33733,{"$f":"'INVOICE 5'!E21+'INVOICE 5'!H21","v":0},{"$f":"'INVOICE 5'!F21+'INVOICE 5'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 5'!B22","v":6625},{"$f":"'INVOICE 5'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 5'!E22+'INVOICE 5'!H22","v":156},{"$f":"'INVOICE 5'!F22+'INVOICE 5'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 5'!B23","v":5421},{"$f":"'INVOICE 5'!C23","v":0},5421,{"$f":"'INVOICE 5'!E23+'INVOICE 5'!H23","v":744},{"$f":"'INVOICE 5'!F23+'INVOICE 5'!I23","v":0},744,242,0,242,4435,0,4435]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":97556},6987.0999999999995,104543.1,73295,{"$f":"SUM(I15:I23)","v":1327.84},74622.84,829149,241685.06,1070834.06,{"$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":170851},null,null,"Grant funds claimed this period:",{"$f":"H24","v":73295},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.51255351255351256}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":8314.9399999999987},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":162482},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":3.3259759999999992E-2}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":2416},"Grant Staff: Alex Coronel; 17h @ $51.99 + benefits = $959.70, 30.50h @ $2.52 + benefits = $83.46, 9.5h @ $54.59 + benefits = $563.12, 24.50h @ $2.60 + benefits = $69.18, 12.5h @ $54.59 + benefits = $740.95   |   $959.70 + $83.46 + $563.12 + $69.18 + $740.95= $2416.40 ",null,null,null,null,null,null,null,"Smaller hourly amounts are to correct Q1 invoice in which hourly was paid at a lower, incorrect rate"]
[null,"Match",{"$f":"I15","v":1327.84},"Grant Staff: David Putney; 11.25 hrs @ 118.03 (salary + benefits) = $1327.84"]
["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":70637},"NOG Subcontracts: Community Agency for Resources, Advocacy, and Services (CARAS) staff salary + benefits = $22,414.62, Living Above the Influence (LATI) staff salary + benefits = $39,205, ConXion to Community staff salary + beneftis = $9,017.41"]
[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":242},"10% of Salaries and Benefits (2416.40*.10=241.65)"]
[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."]
["Alex Coronel, Administrative Data Tech",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12077}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["408-453-4347",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["acoronel@sccoe.org",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"2314 N 1ST ST"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-02-01",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SAN JOSE CA 95131"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"ThuyTrang Nguyen _ Department Fiscal Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"408-468-1646"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-02-11"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-02-11",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 7","index":10,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 6'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 6'!E15+'INVOICE 6'!H15","v":9992},{"$f":"'INVOICE 6'!F15+'INVOICE 6'!I15","v":8314.9399999999987},{"$f":"SUM(E15:F15)","v":18306.939999999999},2212,7549,{"$f":"SUM(H15:I15)","v":9761},{"$f":"B15-E15-H15","v":42017},233507.06,{"$f":"SUM(K15:L15)","v":275524.06},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 6'!B16","v":0},{"$f":"'INVOICE 6'!C16","v":0},0,{"$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,0,0,{"$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":159717},{"$f":"'INVOICE 6'!F18+'INVOICE 6'!I18","v":0},159717,43426,0,43426,696857,0,696857,"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":0},{"$f":"'INVOICE 6'!C20","v":0},0,{"$f":"'INVOICE 6'!E20+'INVOICE 6'!H20","v":0},{"$f":"'INVOICE 6'!F20+'INVOICE 6'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 6'!B21","v":33733},{"$f":"'INVOICE 6'!C21","v":0},33733,{"$f":"'INVOICE 6'!E21+'INVOICE 6'!H21","v":0},{"$f":"'INVOICE 6'!F21+'INVOICE 6'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 6'!B22","v":6625},{"$f":"'INVOICE 6'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 6'!E22+'INVOICE 6'!H22","v":156},{"$f":"'INVOICE 6'!F22+'INVOICE 6'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 6'!B23","v":5421},{"$f":"'INVOICE 6'!C23","v":0},5421,{"$f":"'INVOICE 6'!E23+'INVOICE 6'!H23","v":986},{"$f":"'INVOICE 6'!F23+'INVOICE 6'!I23","v":0},986,221,0,221,4214,0,4214]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":170851},8314.9399999999987,179165.94,45859,{"$f":"SUM(I15:I23)","v":7549},53408,783290,234136.06,1017426.06,{"$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":216710},null,null,"Grant funds claimed this period:",{"$f":"H24","v":45859},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.65013065013065008}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":15863.939999999999},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":116623},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":6.345576E-2}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":2212},"Grant Staff: Alex Coronel; 30.5h @ $554.59 + benefits = $1807.88, 6.50h @ $57.31 + benefits = $404.49   |   $1807.88 + $404.49 = $2212.37"]
[null,"Match",{"$f":"I15","v":7549},"Project Director: David Putney- 5.50 Hrs @$118.03 (salary+benefits)=$649.17.  Project Director/Asst. Superintendent: Anisha Munshi -49.25 Hrs @140.10 (salary + benefits)= $6,899.93.  Total Match =$649.17+6,899.93= $7,549.09"]
["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":43426},"NOG Subcontracts: Community Agency for Resources, Advocacy, and Services (CARAS) staff salary + benefits = $28,330.55, Living Above the Influence (LATI) staff salary + benefits = $11,778.00, ConXion to Community staff salary + benefits = $3,317.40"]
[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":221},"10% of Salaries and Benefits (2212.37*.10=221.24)"]
[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."]
["Alex Coronel, Administrative Data Technician",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12077}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["408-453-4347",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["acoronel@sccoe.org",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"2314 N 1ST ST"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-05-04",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SAN JOSE CA 95131"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"ThuyTrang Nguyen _ Department Fiscal Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"408-468-1646"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-05-04"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-05-14",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 8","index":11,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 7'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 7'!E15+'INVOICE 7'!H15","v":12204},{"$f":"'INVOICE 7'!F15+'INVOICE 7'!I15","v":15863.939999999999},{"$f":"SUM(E15:F15)","v":28067.94},2763,12282,{"$f":"SUM(H15:I15)","v":15045},{"$f":"B15-E15-H15","v":39254},221225.06,{"$f":"SUM(K15:L15)","v":260479.06},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 7'!B16","v":0},{"$f":"'INVOICE 7'!C16","v":0},0,{"$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,0,0,{"$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":203143},{"$f":"'INVOICE 7'!F18+'INVOICE 7'!I18","v":0},203143,44492,0,44492,652365,0,652365,"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":0},{"$f":"'INVOICE 7'!C20","v":0},0,{"$f":"'INVOICE 7'!E20+'INVOICE 7'!H20","v":0},{"$f":"'INVOICE 7'!F20+'INVOICE 7'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 7'!B21","v":33733},{"$f":"'INVOICE 7'!C21","v":0},33733,{"$f":"'INVOICE 7'!E21+'INVOICE 7'!H21","v":0},{"$f":"'INVOICE 7'!F21+'INVOICE 7'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 7'!B22","v":6625},{"$f":"'INVOICE 7'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 7'!E22+'INVOICE 7'!H22","v":156},{"$f":"'INVOICE 7'!F22+'INVOICE 7'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 7'!B23","v":5421},{"$f":"'INVOICE 7'!C23","v":0},5421,{"$f":"'INVOICE 7'!E23+'INVOICE 7'!H23","v":1207},{"$f":"'INVOICE 7'!F23+'INVOICE 7'!I23","v":0},1207,276,0,276,3938,0,3938]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":216710},15863.939999999999,232573.94,47531,{"$f":"SUM(I15:I23)","v":12282},59813,735759,221854.06,957613.06,{"$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":264241},null,null,"Grant funds claimed this period:",{"$f":"H24","v":47531},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.79272379272379268}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":28145.94},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":69092},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.11258375999999999}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":2763},"Grant Staff: Alex Coronel (Admin Data Tech) 11h @ $57.31 + benefits = $684.65, 29h @ $65.98 + benefits = $2,078.11   |   $684.65 + $2,078.11 = $2,762.76"]
[null,"Match",{"$f":"I15","v":12282},"David Putney (Project Director) Salary + Benefits = 118.03/hr, 86.25hrs @ 118.03=$10,180.09, Anisha Munshi (Asst. Superintendent, Project Manager) Salary + Benefits = $140.10/hr, 15hrs @ $140.10=$2,101.50 ---- $10,180.09 (DPutney) + $2,101.50 (AMunshi) = $12,281.59"]
["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":44492},"Community Agency for Resources, Advocacy, and Services (CARAS): Richard Duran (Project Accountant) salary + benefits = $4,968.00, Leanna Rivera (Case Manager) salary + benefits = $4,572.37, Reymundo Armendariz (Project Director) salary + benefits = $9,254.00, Jesus Ibanez (Project Coordinator) salary + benefits = $18,631.48; CARAS Total: $4,968 + $4,572.37 + $9,254.00 + $18,631.48 = $37,425.85 --- Living Above the Influence (LATI): Dori Prado (Project Coordinator) salary + benefits = $7,066.00 --- $37,425.85 (CARAS) + $7,066.00 (LATI) = $44,491.85"]
[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":276},"10% of Q4 Salaries and Benefits (2762.76*.10=276.28)"]
[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."]
["Alex Coronel, Administrative Data Technician",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":12077}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["408-453-4347",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"COUNTYOFSA-020"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["acoronel@sccoe.org",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"2314 N 1ST ST"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-08-12",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"SAN JOSE CA 95131"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"ThuyTrang Nguyen - Department Fiscal Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"408-468-1646"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-08-12"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-08-12",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"MOD 4","index":12,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":false,"merged":[[74,8,74,10],[74,15,74,16],[67,8,67,12],[68,8,68,12],[69,8,69,12],[70,8,70,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],[33,0,33,12],[34,0,34,12],[35,0,52,12],[54,0,54,2],[54,8,54,12],[0,5,2,7],[5,1,5,3],[5,5,5,7],[5,9,5,11],[7,0,7,12],[19,0,20,0],[19,1,19,3],[19,4,19,6],[19,7,19,9],[19,10,19,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":"COUNTY OF SANTA CLARA"},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 590-19"},null,null,null,null,null,null,null,"Modification Request #",4]
[]
["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":54221},{"$f":"'INVOICE 1'!C15","v":249371},{"$f":"SUM(B22:C22)","v":303592},{"$f":"'INVOICE 2'!K15","v":54221},{"$f":"'INVOICE 2'!L15","v":249371},{"$f":"SUM(E22:F22)","v":303592},0,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":54221},249371,{"$f":"SUM(K22:L22)","v":303592}]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":0},0,{"$f":"'INVOICE 2'!K16","v":0},{"$f":"'INVOICE 2'!L16","v":0},0,0,0,0,0,0,0]
["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":0},{"$f":"'INVOICE 1'!C20","v":0},0,{"$f":"'INVOICE 2'!K20","v":0},{"$f":"'INVOICE 2'!L20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 1'!B21","v":33733},{"$f":"'INVOICE 1'!C21","v":0},33733,{"$f":"'INVOICE 2'!K21","v":33733},{"$f":"'INVOICE 2'!L21","v":0},33733,0,0,0,33733,0,33733]
["Other",{"$f":"'INVOICE 1'!B22","v":6625},{"$f":"'INVOICE 1'!C22","v":629},7254,{"$f":"'INVOICE 2'!K22","v":6625},{"$f":"'INVOICE 2'!L22","v":629},7254,0,0,0,6625,629,7254]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":5421},{"$f":"'INVOICE 1'!C23","v":0},5421,{"$f":"'INVOICE 2'!K23","v":5421},{"$f":"'INVOICE 2'!L23","v":0},5421,0,0,0,5421,0,5421]
["TOTAL",{"$f":"SUM(B22:B30)","v":1000000},250000,1250000,1000000,250000,1250000,0,0,0,1000000,250000,1250000]
[]
["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:"]
["One of our Community Business Organizations, ConXion, has left the grant due to limited staff capacity to ensure proper use of funding and project implementation. Our other two CBO’s, CARAS and LATI, have both submitted a project proposal to absorb the funding once allocated to ConXion. The intention would be to split ConXion’s funding between both LATI and CARAS to fulfill their attached project proposals. The total amount allocated overall will not be adjusted - rather the amounts within the CBOs will be shifted to support expansion of the other two programs with funding previously allocated to ConXion. This Budget Modification is requested for FY22 as the two additional CBOs provided program proposals for the funding for this year."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]
["Alex Coronel, Admin Data Tech"]
["Name, Title"]
["408-453-4347"]
["Phone"]
["acoronel@sccoe.org"]
["Email"]
["2021-10-01"]
["Date"]
[]
[null,null,null,null,null,null,null,null,"Thuy Trang Nguyen - Department Fiscal Officer"]
[null,null,null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,null,null,"(408)468-1646"]
[null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,"2021-10-01"]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-10-01",null,null,null,null,"Approved By:",null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 9","index":13,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 8'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 8'!E15+'INVOICE 8'!H15","v":14967},{"$f":"'INVOICE 8'!F15+'INVOICE 8'!I15","v":28145.94},{"$f":"SUM(E15:F15)","v":43112.94},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":39254},221225.06,{"$f":"SUM(K15:L15)","v":260479.06},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 8'!B16","v":0},{"$f":"'INVOICE 8'!C16","v":0},0,{"$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,0,0,{"$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":247635},{"$f":"'INVOICE 8'!F18+'INVOICE 8'!I18","v":0},247635,0,0,0,652365,0,652365,"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":0},{"$f":"'INVOICE 8'!C20","v":0},0,{"$f":"'INVOICE 8'!E20+'INVOICE 8'!H20","v":0},{"$f":"'INVOICE 8'!F20+'INVOICE 8'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 8'!B21","v":33733},{"$f":"'INVOICE 8'!C21","v":0},33733,{"$f":"'INVOICE 8'!E21+'INVOICE 8'!H21","v":0},{"$f":"'INVOICE 8'!F21+'INVOICE 8'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 8'!B22","v":6625},{"$f":"'INVOICE 8'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 8'!E22+'INVOICE 8'!H22","v":156},{"$f":"'INVOICE 8'!F22+'INVOICE 8'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 8'!B23","v":5421},{"$f":"'INVOICE 8'!C23","v":0},5421,{"$f":"'INVOICE 8'!E23+'INVOICE 8'!H23","v":1483},{"$f":"'INVOICE 8'!F23+'INVOICE 8'!I23","v":0},1483,0,0,0,3938,0,3938]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":264241},28145.94,292386.94,0,{"$f":"SUM(I15:I23)","v":0},0,735759,221854.06,957613.06,{"$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":264241},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":0.79272379272379268}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":28145.94},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":69092},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.11258375999999999}]
[]
[]
[]
[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":12077}]
["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-020"}]
["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":"2314 N 1ST ST"}]
["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":"SAN JOSE CA 95131"}]
["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":14,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 9'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 9'!E15+'INVOICE 9'!H15","v":14967},{"$f":"'INVOICE 9'!F15+'INVOICE 9'!I15","v":28145.94},{"$f":"SUM(E15:F15)","v":43112.94},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":39254},221225.06,{"$f":"SUM(K15:L15)","v":260479.06},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 9'!B16","v":0},{"$f":"'INVOICE 9'!C16","v":0},0,{"$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,0,0,{"$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":247635},{"$f":"'INVOICE 9'!F18+'INVOICE 9'!I18","v":0},247635,0,0,0,652365,0,652365,"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":0},{"$f":"'INVOICE 9'!C20","v":0},0,{"$f":"'INVOICE 9'!E20+'INVOICE 9'!H20","v":0},{"$f":"'INVOICE 9'!F20+'INVOICE 9'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 9'!B21","v":33733},{"$f":"'INVOICE 9'!C21","v":0},33733,{"$f":"'INVOICE 9'!E21+'INVOICE 9'!H21","v":0},{"$f":"'INVOICE 9'!F21+'INVOICE 9'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 9'!B22","v":6625},{"$f":"'INVOICE 9'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 9'!E22+'INVOICE 9'!H22","v":156},{"$f":"'INVOICE 9'!F22+'INVOICE 9'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 9'!B23","v":5421},{"$f":"'INVOICE 9'!C23","v":0},5421,{"$f":"'INVOICE 9'!E23+'INVOICE 9'!H23","v":1483},{"$f":"'INVOICE 9'!F23+'INVOICE 9'!I23","v":0},1483,0,0,0,3938,0,3938]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":264241},28145.94,292386.94,0,{"$f":"SUM(I15:I23)","v":0},0,735759,221854.06,957613.06,{"$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":264241},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":0.79272379272379268}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":28145.94},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":69092},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.11258375999999999}]
[]
[]
[]
[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":12077}]
["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-020"}]
["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":"2314 N 1ST ST"}]
["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":"SAN JOSE CA 95131"}]
["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":15,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 10'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 10'!E15+'INVOICE 10'!H15","v":14967},{"$f":"'INVOICE 10'!F15+'INVOICE 10'!I15","v":28145.94},{"$f":"SUM(E15:F15)","v":43112.94},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":39254},221225.06,{"$f":"SUM(K15:L15)","v":260479.06},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 10'!B16","v":0},{"$f":"'INVOICE 10'!C16","v":0},0,{"$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,0,0,{"$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":247635},{"$f":"'INVOICE 10'!F18+'INVOICE 10'!I18","v":0},247635,0,0,0,652365,0,652365,"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":0},{"$f":"'INVOICE 10'!C20","v":0},0,{"$f":"'INVOICE 10'!E20+'INVOICE 10'!H20","v":0},{"$f":"'INVOICE 10'!F20+'INVOICE 10'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 10'!B21","v":33733},{"$f":"'INVOICE 10'!C21","v":0},33733,{"$f":"'INVOICE 10'!E21+'INVOICE 10'!H21","v":0},{"$f":"'INVOICE 10'!F21+'INVOICE 10'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 10'!B22","v":6625},{"$f":"'INVOICE 10'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 10'!E22+'INVOICE 10'!H22","v":156},{"$f":"'INVOICE 10'!F22+'INVOICE 10'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 10'!B23","v":5421},{"$f":"'INVOICE 10'!C23","v":0},5421,{"$f":"'INVOICE 10'!E23+'INVOICE 10'!H23","v":1483},{"$f":"'INVOICE 10'!F23+'INVOICE 10'!I23","v":0},1483,0,0,0,3938,0,3938]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":264241},28145.94,292386.94,0,{"$f":"SUM(I15:I23)","v":0},0,735759,221854.06,957613.06,{"$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":264241},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":0.79272379272379268}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":28145.94},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":69092},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.11258375999999999}]
[]
[]
[]
[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":12077}]
["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-020"}]
["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":"2314 N 1ST ST"}]
["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":"SAN JOSE CA 95131"}]
["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":16,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 11'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 11'!E15+'INVOICE 11'!H15","v":14967},{"$f":"'INVOICE 11'!F15+'INVOICE 11'!I15","v":28145.94},{"$f":"SUM(E15:F15)","v":43112.94},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":39254},221225.06,{"$f":"SUM(K15:L15)","v":260479.06},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 11'!B16","v":0},{"$f":"'INVOICE 11'!C16","v":0},0,{"$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,0,0,{"$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":247635},{"$f":"'INVOICE 11'!F18+'INVOICE 11'!I18","v":0},247635,0,0,0,652365,0,652365,"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":0},{"$f":"'INVOICE 11'!C20","v":0},0,{"$f":"'INVOICE 11'!E20+'INVOICE 11'!H20","v":0},{"$f":"'INVOICE 11'!F20+'INVOICE 11'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 11'!B21","v":33733},{"$f":"'INVOICE 11'!C21","v":0},33733,{"$f":"'INVOICE 11'!E21+'INVOICE 11'!H21","v":0},{"$f":"'INVOICE 11'!F21+'INVOICE 11'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 11'!B22","v":6625},{"$f":"'INVOICE 11'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 11'!E22+'INVOICE 11'!H22","v":156},{"$f":"'INVOICE 11'!F22+'INVOICE 11'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 11'!B23","v":5421},{"$f":"'INVOICE 11'!C23","v":0},5421,{"$f":"'INVOICE 11'!E23+'INVOICE 11'!H23","v":1483},{"$f":"'INVOICE 11'!F23+'INVOICE 11'!I23","v":0},1483,0,0,0,3938,0,3938]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":264241},28145.94,292386.94,0,{"$f":"SUM(I15:I23)","v":0},0,735759,221854.06,957613.06,{"$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":264241},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":0.79272379272379268}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":28145.94},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":69092},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.11258375999999999}]
[]
[]
[]
[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":12077}]
["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-020"}]
["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":"2314 N 1ST ST"}]
["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":"SAN JOSE CA 95131"}]
["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":17,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 12'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 12'!E15+'INVOICE 12'!H15","v":14967},{"$f":"'INVOICE 12'!F15+'INVOICE 12'!I15","v":28145.94},{"$f":"SUM(E15:F15)","v":43112.94},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":39254},221225.06,{"$f":"SUM(K15:L15)","v":260479.06},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 12'!B16","v":0},{"$f":"'INVOICE 12'!C16","v":0},0,{"$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,0,0,{"$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":247635},{"$f":"'INVOICE 12'!F18+'INVOICE 12'!I18","v":0},247635,0,0,0,652365,0,652365,"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":0},{"$f":"'INVOICE 12'!C20","v":0},0,{"$f":"'INVOICE 12'!E20+'INVOICE 12'!H20","v":0},{"$f":"'INVOICE 12'!F20+'INVOICE 12'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 12'!B21","v":33733},{"$f":"'INVOICE 12'!C21","v":0},33733,{"$f":"'INVOICE 12'!E21+'INVOICE 12'!H21","v":0},{"$f":"'INVOICE 12'!F21+'INVOICE 12'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 12'!B22","v":6625},{"$f":"'INVOICE 12'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 12'!E22+'INVOICE 12'!H22","v":156},{"$f":"'INVOICE 12'!F22+'INVOICE 12'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 12'!B23","v":5421},{"$f":"'INVOICE 12'!C23","v":0},5421,{"$f":"'INVOICE 12'!E23+'INVOICE 12'!H23","v":1483},{"$f":"'INVOICE 12'!F23+'INVOICE 12'!I23","v":0},1483,0,0,0,3938,0,3938]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":264241},28145.94,292386.94,0,{"$f":"SUM(I15:I23)","v":0},0,735759,221854.06,957613.06,{"$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":264241},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":0.79272379272379268}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":28145.94},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":69092},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.11258375999999999}]
[]
[]
[]
[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":12077}]
["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-020"}]
["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":"2314 N 1ST ST"}]
["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":"SAN JOSE CA 95131"}]
["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":18,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 13'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 13'!E15+'INVOICE 13'!H15","v":14967},{"$f":"'INVOICE 13'!F15+'INVOICE 13'!I15","v":28145.94},{"$f":"SUM(E15:F15)","v":43112.94},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":39254},221225.06,{"$f":"SUM(K15:L15)","v":260479.06},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 13'!B16","v":0},{"$f":"'INVOICE 13'!C16","v":0},0,{"$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,0,0,{"$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":247635},{"$f":"'INVOICE 13'!F18+'INVOICE 13'!I18","v":0},247635,0,0,0,652365,0,652365,"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":0},{"$f":"'INVOICE 13'!C20","v":0},0,{"$f":"'INVOICE 13'!E20+'INVOICE 13'!H20","v":0},{"$f":"'INVOICE 13'!F20+'INVOICE 13'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 13'!B21","v":33733},{"$f":"'INVOICE 13'!C21","v":0},33733,{"$f":"'INVOICE 13'!E21+'INVOICE 13'!H21","v":0},{"$f":"'INVOICE 13'!F21+'INVOICE 13'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 13'!B22","v":6625},{"$f":"'INVOICE 13'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 13'!E22+'INVOICE 13'!H22","v":156},{"$f":"'INVOICE 13'!F22+'INVOICE 13'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 13'!B23","v":5421},{"$f":"'INVOICE 13'!C23","v":0},5421,{"$f":"'INVOICE 13'!E23+'INVOICE 13'!H23","v":1483},{"$f":"'INVOICE 13'!F23+'INVOICE 13'!I23","v":0},1483,0,0,0,3938,0,3938]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":264241},28145.94,292386.94,0,{"$f":"SUM(I15:I23)","v":0},0,735759,221854.06,957613.06,{"$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":264241},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":0.79272379272379268}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":28145.94},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":69092},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.11258375999999999}]
[]
[]
[]
[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":12077}]
["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-020"}]
["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":"2314 N 1ST ST"}]
["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":"SAN JOSE CA 95131"}]
["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":19,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[71,0,71,1],[71,6,71,7],[71,8,71,11],[72,0,72,7],[72,8,72,11],[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],[51,0,51,1],[51,3,51,13],[52,0,52,2],[52,4,52,9],[52,11,52,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],[47,0,48,0],[47,3,47,10],[47,11,47,13],[48,3,48,10],[48,11,48,13],[49,0,50,0],[49,3,49,10],[49,11,49,13],[50,3,50,10],[50,11,50,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[45,0,46,0],[45,3,45,10],[45,11,45,13],[46,3,46,10],[46,11,46,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-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":54221},{"$f":"'INVOICE 14'!C15","v":249371},{"$f":"SUM(B15:C15)","v":303592},{"$f":"'INVOICE 14'!E15+'INVOICE 14'!H15","v":14967},{"$f":"'INVOICE 14'!F15+'INVOICE 14'!I15","v":28145.94},{"$f":"SUM(E15:F15)","v":43112.94},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":39254},221225.06,{"$f":"SUM(K15:L15)","v":260479.06},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 14'!B16","v":0},{"$f":"'INVOICE 14'!C16","v":0},0,{"$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,0,0,{"$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":247635},{"$f":"'INVOICE 14'!F18+'INVOICE 14'!I18","v":0},247635,0,0,0,652365,0,652365,"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":0},{"$f":"'INVOICE 14'!C20","v":0},0,{"$f":"'INVOICE 14'!E20+'INVOICE 14'!H20","v":0},{"$f":"'INVOICE 14'!F20+'INVOICE 14'!I20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 14'!B21","v":33733},{"$f":"'INVOICE 14'!C21","v":0},33733,{"$f":"'INVOICE 14'!E21+'INVOICE 14'!H21","v":0},{"$f":"'INVOICE 14'!F21+'INVOICE 14'!I21","v":0},0,0,0,0,33733,0,33733,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 14'!B22","v":6625},{"$f":"'INVOICE 14'!C22","v":629},{"$f":"SUM(B22:C22)","v":7254},{"$f":"'INVOICE 14'!E22+'INVOICE 14'!H22","v":156},{"$f":"'INVOICE 14'!F22+'INVOICE 14'!I22","v":0},156,0,0,0,6469,629,7098,0]
["Indirect Costs",{"$f":"'INVOICE 14'!B23","v":5421},{"$f":"'INVOICE 14'!C23","v":0},5421,{"$f":"'INVOICE 14'!E23+'INVOICE 14'!H23","v":1483},{"$f":"'INVOICE 14'!F23+'INVOICE 14'!I23","v":0},1483,0,0,0,3938,0,3938]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250000},{"$f":"SUM(D15:D23)","v":1250000},{"$f":"SUM(E15:E23)","v":264241},28145.94,292386.94,0,{"$f":"SUM(I15:I23)","v":0},0,735759,221854.06,957613.06,{"$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":264241},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":0.79272379272379268}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":28145.94},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":69092},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"D29/C24","v":0.11258375999999999}]
[]
[]
[]
[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":12077}]
["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-020"}]
["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":"2314 N 1ST ST"}]
["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":"SAN JOSE CA 95131"}]
["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":"2nd Advance Payment","index":20,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[50,2,50,4],[50,8,50,10],[52,2,52,4],[52,8,52,10],[53,2,53,4],[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],[30,1,30,4],[31,1,31,4],[32,1,32,4],[22,0,22,3],[22,6,22,10],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-19"},null,null,null,null,"Address",{"$f":"'1st Advance Payment'!J8","v":"2314 N 1st St."}]
[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":"'1st Advance Payment'!J10","v":"San Jose, CA 95131"}]
[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 #"]
[]
[]
["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-'1st Advance Payment'!K20:L20-'2nd Advance Payment'!K20:L20","v":333334}]
[]
[]
[]
[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":"'1st Advance Payment'!I32:K32","v":"COUNTYOFSA-020"}]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:",null,null,null,null,null,null,{"$f":"'1st Advance Payment'!I34:K34","v":12077}]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"3rd Advance Payment","index":21,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[19,10,19,11],[0,5,2,7],[12,6,14,11],[14,2,14,3],[17,0,17,11],[18,10,18,11],[25,1,25,4],[25,6,33,10],[26,1,26,4],[27,1,27,4],[28,1,28,4],[20,10,20,11],[22,0,22,3],[22,6,22,10],[24,1,24,4],[24,6,24,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],[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]]}
["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,2455]
["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":"COUNTY OF SANTA CLARA"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 590-19"},null,null,null,null,"Address",{"$f":"'2nd Advance Payment'!I8","v":"2314 N 1st St."}]
[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'!I10","v":"San Jose, CA 95131"}]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #",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. "]
[]
[null,"Effective Invoice #"]
[]
[]
["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:",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,null,null,null,null,"Supplier Name"]
[null,"Date:"]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"MODIFICATION REQUEST","index":22,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":false,"merged":[[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],[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],[0,5,2,7],[5,1,5,3],[5,5,5,7],[5,9,5,11],[7,0,7,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":"COUNTY OF SANTA CLARA"},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 590-19"},null,null,null,null,null,null,null,"Modification Request #",4]
[]
["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 #",4]
[]
["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":54221},{"$f":"'INVOICE 1'!C15","v":249371},{"$f":"SUM(B22:C22)","v":303592},{"$f":"'INVOICE 2'!K15","v":54221},{"$f":"'INVOICE 2'!L15","v":249371},{"$f":"SUM(E22:F22)","v":303592},0,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":54221},{"$f":"SUM(C22,I22)","v":249371},{"$f":"SUM(K22:L22)","v":303592}]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":0},0,{"$f":"'INVOICE 2'!K16","v":0},{"$f":"'INVOICE 2'!L16","v":0},0,0,0,0,0,0,0]
["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":0},{"$f":"'INVOICE 1'!C20","v":0},0,{"$f":"'INVOICE 2'!K20","v":0},{"$f":"'INVOICE 2'!L20","v":0},0,0,0,0,0,0,0]
["Project Evaluation",{"$f":"'INVOICE 1'!B21","v":33733},{"$f":"'INVOICE 1'!C21","v":0},33733,{"$f":"'INVOICE 2'!K21","v":33733},{"$f":"'INVOICE 2'!L21","v":0},33733,0,0,0,33733,0,33733]
["Other",{"$f":"'INVOICE 1'!B22","v":6625},{"$f":"'INVOICE 1'!C22","v":629},7254,{"$f":"'INVOICE 2'!K22","v":6625},{"$f":"'INVOICE 2'!L22","v":629},7254,0,0,0,6625,629,7254]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":5421},{"$f":"'INVOICE 1'!C23","v":0},5421,{"$f":"'INVOICE 2'!K23","v":5421},{"$f":"'INVOICE 2'!L23","v":0},5421,0,0,0,5421,0,5421]
["TOTAL",{"$f":"SUM(B22:B30)","v":1000000},250000,1250000,1000000,250000,1250000,0,0,0,1000000,250000,1250000]
[]
["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:"]
["One of our Community Business Organizations, ConXion, has left the grant due to limited staff capacity to ensure proper use of funding and project implementation. Our other two CBO’s, CARAS and LATI, have both submitted a project proposal to absorb the funding once allocated to ConXion. The intention would be to split ConXion’s funding between both LATI and CARAS to fulfill their attached project proposals. The total amount allocated overall will not be adjusted - rather the amounts within the CBOs will be shifted to support expansion of the other two programs with funding previously allocated to ConXion. This Budget Modification is requested for FY22 as the two additional CBOs provided program proposals for the funding for this year."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]
["Alex Coronel, Admin Data Tech"]
["Name, Title"]
["408-453-4347"]
["Phone"]
["acoronel@sccoe.org"]
["Email"]
["2021-10-01"]
["Date"]
[]
[null,null,null,null,null,null,null,null,"Thuy Trang Nguyen - Department Fiscal Officer"]
[null,null,null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,null,null,"(408)468-1646"]
[null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,"2021-10-01"]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-10-01",null,null,null,null,"Approved By:",null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"PROJECT BUDGET NARRATIVE","index":23,"n_rows":155,"n_cols":8,"rows_kept":155,"cut":false,"hidden":false,"merged":[[117,0,117,7],[118,0,118,7],[129,0,129,7],[130,0,130,7],[142,0,142,7],[143,0,143,7],[145,0,145,7],[146,0,146,4],[147,0,147,3],[123,0,123,4],[126,0,128,7],[132,0,132,7],[133,0,133,1],[133,2,133,4],[134,0,134,1],[134,2,134,4],[120,0,120,7],[121,0,121,4],[122,0,122,4],[148,0,148,3],[149,0,149,4],[152,0,153,7],[137,0,137,4],[140,0,141,7],[154,0,154,7],[155,0,155,7],[135,0,135,1],[135,2,135,4],[136,0,136,1],[136,2,136,4],[111,0,111,4],[112,0,112,4],[115,0,116,7],[101,0,101,4],[104,0,105,7],[109,0,109,7],[110,0,110,4],[95,0,95,7],[96,0,96,7],[106,0,106,7],[107,0,107,7],[82,0,82,4],[84,0,84,7],[85,0,94,7],[98,0,98,7],[99,2,99,4],[100,0,100,1],[100,2,100,4],[79,2,79,4],[80,0,80,1],[80,2,80,4],[81,0,81,1],[81,2,81,4],[75,0,75,7],[76,0,76,1],[76,2,76,4],[77,0,77,1],[77,2,77,4],[78,0,78,1],[78,2,78,4],[67,0,67,4],[70,0,71,7],[72,0,72,7],[73,0,73,7],[59,0,60,7],[64,0,64,7],[65,2,65,4],[66,0,66,1],[66,2,66,4],[61,0,61,7],[62,0,62,7],[56,0,56,4],[58,0,58,2],[24,0,24,4],[27,0,31,7],[53,0,53,7],[54,0,54,1],[54,2,54,4],[55,0,55,1],[55,2,55,4],[32,0,32,7],[33,0,33,7],[34,0,34,7],[35,0,39,7],[40,0,40,7],[41,0,49,7],[50,0,50,7],[51,0,51,7],[23,0,23,1],[23,2,23,4],[20,0,20,1],[20,2,20,4],[21,0,21,1],[21,2,21,4],[22,0,22,1],[22,2,22,4],[19,0,19,1],[19,2,19,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],[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]]}
[]
["Youth Reinvestment Grant - Project Budget and Budget Narrative"]
["Name of County or City:",null,null,"County of Santa Clara (Probation Dept.)"]
["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":"F25","v":54221},{"$f":"G25","v":249371},{"$f":"H25","v":303592}]
["2. Services and Supplies",null,null,null,null,{"$f":"F57","v":0},{"$f":"G57","v":0},{"$f":"H57","v":0}]
["3. Professional Services",null,null,null,null,{"$f":"F68","v":0},{"$f":"G68","v":0},{"$f":"H68","v":0}]
["4. Non-Governmental Organization (NGO) Subcontracts",null,null,null,null,{"$f":"F83","v":900000},{"$f":"G83","v":0},{"$f":"H83","v":900000}]
["5. Equipment/Fixed Assets",null,null,null,null,{"$f":"F102","v":0},{"$f":"G102","v":0},{"$f":"H102","v":0}]
["6. Data Collection ",null,null,null,null,{"$f":"F113","v":0},{"$f":"G113","v":0},{"$f":"H113","v":0}]
["7. Project Evaluation",null,null,null,null,{"$f":"F124","v":33733},{"$f":"G124","v":0},{"$f":"H124","v":33733}]
["8. Other (Travel, Training, etc.)",null,null,null,null,{"$f":"F138","v":6625},{"$f":"G138","v":629},{"$f":"H138","v":7254}]
["9. Indirect Costs",null,null,null,null,{"$f":"F150","v":5421},{"$f":"G150","v":0},{"$f":"H150","v":5421}]
["TOTAL",null,null,null,null,{"$f":"SUM(F6:F14)","v":1000000},{"$f":"SUM(G6:G14)","v":250000},{"$f":"SUM(F15:G15)","v":1250000}]
["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"]
["Jennifer Del Bono, Director",null,"Year 1: .037FTE @ $159,463 =$5,900 + benefits @ 29.91%: $1,765\nYear 2: .037FTE @ $160,919 =$5,954 + benefits @ 30.08%: $1,775\nYear 3: .037FTE @ $160,919 =$5,900 + benefits @ 30.08%: $1,775\nYear 4: .037FTE @ $159,463 =$3,969 + benefits @ 30.08%: $1,183 ",null,null,28276,0,{"$f":"SUM(F20:G20)","v":28276}]
["Stephanie Tague, Coordinator",null,"Year 1: .037FTE @ $146,172  = $5,408 + benefits @ 28.26%: $1,667\nYear 2: .037FTE @ $146,172  = $5,408 + benefits @ 28.26%: $1,667\nYear 3: .037FTE @ $146,172  = $5,408 + benefits @ 28.26%: $1,667 \nYear 4: .037FTE @ $146,172  = $3,606 + benefits @ 28.26%: $1,112",null,null,25945,0,25945]
["Rhonda Beasley, Coordinator",null,"Year 1: .1385 FTE @ $146,172  = $20,239 + benefits @ 28.27%: $6,242\nYear 2: .1385 FTE @ $146,172  = $20,239 + benefits @ 28.27%: $6,242\nYear 3: .1385 FTE @ $146,172  = $20,239 + benefits @ 28.27%: $6,242\nYear 4: .1385 FTE @ $146,172  = $13,497 + benefits @ 28.27%: $6,242",null,null,0,97102,97102]
["Stephanie Tague, Coordinator",null,"Year 1: .01385 FTE @ $146,172  = $20,245 + benefits @ 28.27%: $6,243\nYear 2: .01385 FTE @ $146,172  = $20,245 + benefits @ 28.27%: $6,243\nYear 3: .01385 FTE @ $146,172  = $20,245 + benefits @ 28.27%: $6,243\nYear 4: .01385 FTE @ $146,172  = $9,651 + benefits @ 28.27%: $2,976",null,null,0,83963,83963]
["Christina Arpante, Coordinator",null,"Year 1: .0.960 FTE @ $147,872  = $14,196 + benefits @ 28.48%: $4,360\nYear 2: .0.960 FTE @ $147,872  = $14,196 + benefits @ 28.48%: $4,360 \nYear 3: .0.960 FTE @ $147,872  = $14,196 + benefits @ 28.48%: $4,360\nYear 4: .0.960 FTE @ $147,872  = $9,671 + benefits @ 28.48%: $2,970",null,null,0,68306,68306]
["TOTAL",null,null,null,null,{"$f":"SUM(F20:F24)","v":54221},{"$f":"SUM(G20:G24)","v":249371},303592]
[]
["Salaries and Benefits"]
["Santa Clara County Office of Education staff members will direct the project as well as provide necessary training and technical support to the CBOs.  Jennifer Del Bono will oversee the project.  Stephanie Tague will provide facilitation as well as consultation to the CBOs regarding integration of systems to support students. She will also provide advisemnent on the in-take process and case-management processes of the CBOs.  Matching dollars will involve training and technical assistance provided by Stephanie Tague, Rhonda Beasley, and Christina Arpante on Multi tiered Systems of Support, Positive Behavior Interventions and Support, Youth Mental Health First Aide, Trauma-Informed Care, Function of Behavior,and Social - Emotional Learning."]
[]
[]
[]
[]
["MOD 1  APPROVAL DATE: 11/15/2019  "]
["Alex Coronel will be added as personnel supporting the grant with administrative duties.  She will be paid through June 30th, 2020 to support the grant yet the payments will not exceed $10,000.  Funds will be shifted from Stephanie Tague and Jennifer Del Bono grant funds to cover the costs.   Alex will support the grant process by ensuring the MOUs with the CBOs are fully executed, communicate to CBOs regarding the grant reporting requirements, schedule meetings with the oversight committee and grant partners, and support the invoice and grant reporting deadlines.  Hourly rate = $54.24.   Alex Coronel will be preparing the reports and invoices.  `"]
["MOD 2  APPROVAL DATE:  "]
["Due to Corona Virus relief efforts, the Santa Clara County Office of Education's Safe and Healthy Schools Director, Jennifer Del Bono, has requested that we are approved to calculate her hours as match hours under the grant.The request was to identify the hours/funding that Christina Arpante was originally allocated in the budget for match dollars, to Jennifer Del Bono, as Christina is designated to COVID-19 relief. The request has been submitted to BSCC. The amount of Match funding that is being adjusted is 7.44% of the total match funding ($249,371), and 1.48% of the overall grant dollars (State + Match funding). Once the budet modification is approved via BSCC the Match hours Jennifer is contributing will be requested in the Q4 submission. Jennifer's Match Contribution: .1163 FTE @ $159,463 =$18,555"]
[]
[]
[]
[]
["MOD 3  APPROVAL DATE: 12/8/20 "]
["Alex Coronel will be added as personnel supporting the grant with Administrative Duties. She will be paid through June 30, 2023 to support the grant yet the salary payments will not exceed $10,000 annually. Funds will be shifted from Stephanie Tague and Jennifer Del Bono (David Putney (see below)) grant funds to cover the costs (7,729+7,076=$14,805.00). Alex will support the grant process by ensuring the MOUs with the CBOs are fully executed, communicate to CBOs regarding the grant reporting requirements, schedule meetings with the oversight committee and grant partners, and support the invoice with grant reporting deadlines. Hourly rate = $53.53. Alex Coronel will be preparing the reports and invoices.    ||   In the 2019-20 grant year, we submitted a budget modification to move the Match funds allocated to Christina Arpante under Jennifer Del Bono as Dr. Arpante was delegated to Emergency Command for COVID. At the end of Fiscal Year 20, Jennifer Del Bono's employment with the SCCOE ended, and the grant has since been moved to a new director, David Putney. All Match dollars ($18,555) initially allocated to Christina Arpante, will now be moved under David Putney (.0753% FTE @ $191,171 = $14,395.18 + benefits at 28.91%= $4,161.65 = $18,556.83). Both Budget Modification requests do not change any amounts in any line item - rather the names attached to those amounts are what is changed. "]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD X  APPROVAL DATE:  "]
[]
[]
["2. Services and Supplies"]
["Description of Services or Supplies",null,"Calculation for Expenditure",null,null,"Grant Funds","Match Funds","Total"]
[null,null,null,null,null,0,0,{"$f":"SUM(F56:G56)","v":0}]
["TOTAL",null,null,null,null,{"$f":"SUM(F56:F56)","v":0},{"$f":"SUM(G56:G56)","v":0},0]
[]
["Services and Supplies Narrative: "]
["N/A"]
[]
["MOD X  APPROVAL DATE:  "]
[]
[]
["3. Professional Services"]
["Description of Professional Service(s)",null,"Calculation for Expenditure",null,null,"Grant Funds ","Match Funds","Total"]
[null,null,null,null,null,0,0,{"$f":"SUM(F67:G67)","v":0}]
["TOTAL",null,null,null,null,{"$f":"SUM(F67:F67)","v":0},{"$f":"SUM(G67:G67)","v":0},0]
[]
["Professional Services Narrative"]
["N/A"]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["4. Non-Governmental Organizations (NGO) Subcontracts"]
["Description of Subcontract",null,"Calculation for Expenditure",null,null,"Grant Funds","Match Funds","Total"]
["ConXion - Salaries and Benefits",null,null,null,null,189800,0,{"$f":"SUM(F78:G78)","v":189800}]
["CARAS Salaries and Benefits",null,null,null,null,473401,0,473401]
["EOCS & LATI Salaries and Benefits",null,null,null,null,189614,0,189614]
["External Evaluator - SCCOE",null,null,null,null,28185,0,28185]
["Travel - Project Evolve",null,"Travel/Mileage reimbursement",null,null,19000,0,19000]
["TOTALS",null,null,null,null,{"$f":"SUM(F78:F82)","v":900000},{"$f":"SUM(G78:G82)","v":0},900000]
[]
["Non-Governmental Organizations (NGO) Subcontracts Narrative"]
["The contracted NGOs will provide a Program Coordinator, two Case Managers, and two Administrative Assistants/Interns.  The Program Coordinator will oversee the case managers and administrative assistants. Staff will conduct outreach and recruitment, needs assessments, set goals, do house visits, coordinate prosocial activities, facilitate workshops and trainings and coordinate events. CARAS will provide the facilities and necessary office equipment for all Gilroy activities. Special events will include career fairs in both Gilroy and Morgan Hill, Cultural Awareness & Identity workshops, and the LATI Youth Matter leadership forum once a year. Pro-social activities will include group classes in art, music, archery, dance, bike repair and customizing, graphic design and vocals. Individual athletics classes will include boxing, mixed martial arts and martial arts in partnership with local gyms. After completing the Joven Noble/Xinaxtli curriculum or EOCS Life Skills and Gang Awareness classes, youth will be invited to participate in a Graduation Ceremony which will include their families and support network. Post graduation youth can then be part of the Youth Leadership Council, which will engage in civics, community service and leadership.Year 1 planning and setup including co-development of the evaluation plan, less involved planning and setup in years 2 and 3, annual summative and formative evaluation efforts, annual BSCC quarterly reports, meeting attendance, and drafting of the evaluation section of the final report. Grant funds will be used to compensate for partial cell phone stipends, materials for training, and mileage reimbursement for CBOs."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["5. Equipment/Fixed Assets"]
["Description of Equipment/Fixed Asset",null,"Calculation for Expense",null,null,"Grant Funds","Match Funds","Total"]
[null,null,null,null,null,0,0,{"$f":"SUM(F101:G101)","v":0}]
["TOTALS",null,null,null,null,{"$f":"SUM(F101:F101)","v":0},{"$f":"SUM(G101:G101)","v":0},0]
[]
["Equipment/Fixed Assets Narrative "]
["N/A"]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["6. Data Collection"]
["Description",null,null,null,null,"Grant Funds","Match Funds","Total"]
[null,null,null,null,null,0,0,{"$f":"SUM(F112:G112)","v":0}]
["TOTAL",null,null,null,null,{"$f":"SUM(F112:F112)","v":0},{"$f":"SUM(G112:G112)","v":0},{"$f":"SUM(F113:G113)","v":0}]
[]
["Data  Collection"]
["N/A"]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["7. Project Evaluation"]
["Description",null,null,null,null,"Grant Funds","Match Funds","Total"]
["Evaluation Fee's",null,null,null,null,33733,0,{"$f":"SUM(F123:G123)","v":33733}]
["TOTAL",null,null,null,null,{"$f":"SUM(F123:F123)","v":33733},{"$f":"SUM(G123:G123)","v":0},{"$f":"SUM(F124:G124)","v":33733}]
[]
["Project Evaluation Narrative:"]
["Year 1 planning and setup including co-development of the evaluation plan, less involved planning and setup in years 2 and 3, annual summative and formative evaluation efforts, annual BSCC quarterly reports, meeting attendance, and drafting of the evaluation section of the final report.   "]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["8. Other (Travel, Training, etc.)"]
["Description",null,"Calculation for Expense",null,null,"Grant Funds","Match Funds","Total"]
["Cell phone stipend ",null,"Stephanie & Jennifer",null,null,239,0,{"$f":"SUM(F135:G135)","v":239}]
["Cell phone stipend ",null,"Average (Rhonda, Stephanie & Christina)",null,null,0,629,629]
["Other Operational",null,"Materials",null,null,6386,0,6386]
["TOTAL",null,null,null,null,{"$f":"SUM(F135:F137)","v":6625},{"$f":"SUM(G135:G137)","v":629},7254]
[]
["Other (Travel, Training, etc.) Narrative:"]
["Grant funds will be used to compensate for partial cell phone stipends, materials for training, and mileage reimbursement for CBOs."]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["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(G25)*10%","v":24937.100000000002},5421,0,{"$f":"SUM(F148:G148)","v":5421}]
["2. Indirect costs will be charged as 5% of direct total direct project costs (excluding equipment) not to exceed:",null,null,null,{"$f":"SUM(G138,G124,G113,G83,G68,G57,G25)*5%","v":12500},0,0,{"$f":"SUM(F149:G149)","v":0}]
["If the amount entered turns red, adjust it to not exceed the maximum noted above: TOTAL",null,null,null,null,{"$f":"SUM(F148:F149)","v":5421},{"$f":"SUM(G148:G149)","v":0},{"$f":"SUM(H148:H149)","v":5421}]
[]
["Indirect Costs Narrative:"]
[]
[]
["MOD x  APPROVAL DATE:  "]

{"sheet":"INVOICE DUE DATES","index":24,"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":25,"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."]