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

{"sheet":"1st Advance Payment","index":0,"n_rows":35,"n_cols":12,"rows_kept":35,"cut":false,"hidden":false,"merged":[[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,2469]
["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":"City of Costa Mesa"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-19"},null,null,null,null,"Address",null,"99 Fair Dr."]
[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,"Costa Mesa, CA 92626"]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #",1,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 #",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:",666667]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,"Approved By:","Colleen Stoner",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:","2019-10-25"]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"MOD 1","index":1,"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":"City of Costa Mesa"},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 569-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 #",1]
[]
["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":97000},{"$f":"'INVOICE 1'!C15","v":0},{"$f":"SUM(B22:C22)","v":97000},{"$f":"'INVOICE 2'!K15","v":90860},{"$f":"'INVOICE 2'!L15","v":0},{"$f":"SUM(E22:F22)","v":90860},0,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":97000},0,{"$f":"SUM(K22:L22)","v":97000}]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":25364},25364,{"$f":"'INVOICE 2'!K16","v":0},{"$f":"'INVOICE 2'!L16","v":25364},25364,0,0,0,0,25364,25364]
["Professional Services",{"$f":"'INVOICE 1'!B17","v":0},{"$f":"'INVOICE 1'!C17","v":224637},224637,{"$f":"'INVOICE 2'!K17","v":0},{"$f":"'INVOICE 2'!L17","v":224637},224637,0,0,0,0,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 1'!B18","v":900000},{"$f":"'INVOICE 1'!C18","v":0},900000,{"$f":"'INVOICE 2'!K18","v":809863},{"$f":"'INVOICE 2'!L18","v":0},809863,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":0},{"$f":"'INVOICE 1'!C21","v":0},0,{"$f":"'INVOICE 2'!K21","v":0},{"$f":"'INVOICE 2'!L21","v":0},0,0,0,0,0,0,0]
["Other",{"$f":"'INVOICE 1'!B22","v":3000},{"$f":"'INVOICE 1'!C22","v":0},3000,{"$f":"'INVOICE 2'!K22","v":1396},{"$f":"'INVOICE 2'!L22","v":0},1396,0,0,0,3000,0,3000]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":0},{"$f":"'INVOICE 1'!C23","v":0},0,{"$f":"'INVOICE 2'!K23","v":0},{"$f":"'INVOICE 2'!L23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B22:B30)","v":1000000},250001,1250001,902119,250001,1152120,0,0,0,1000000,250001,1250001]
[]
["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:"]
["The agreement indicates a Police Officer (salary at $54.09 per hour, working 13.75 hours per month for 12 months with benefits at 198.79%) to coordinate the grant. Since this is the first year implementation, a Police Lieutenant (salary at $79.07 per hour, working 23.5  hours per month for 12 months with benefits at 109.86%) has been overseeing the program to ensure compliance with grant requirements. The City will make sure the annual total cost not exceed total budgeted salaries and benefits of the contract."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]
["Jan Wang, Management Analyst"]
["Name, Title"]
["714-754-5074"]
["Phone"]
["jwang@costamesaca.gov"]
["Email"]
["2020-09-14"]
["Date"]
[]
[null,null,null,null,null,null,null,null,"Jennifer King, Assistant Finance Director"]
[null,null,null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,null,null,"714-754-5219"]
[null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,"2020-09-15"]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-09-14",null,null,null,null,"Approved By:","Katrina Jackson",null,null,"Date:","2021-03-19"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 1","index":2,"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,2469]
["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:","City of Costa Mesa",null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:","BSCC 569-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",97000,0,{"$f":"SUM(B15:C15)","v":97000},0,0,{"$f":"SUM(E15:F15)","v":0},3485,0,{"$f":"SUM(H15:I15)","v":3485},{"$f":"B15-E15-H15","v":93515},{"$f":"C15-F15-I15","v":0},{"$f":"SUM(K15:L15)","v":93515},"1st Advance [10/25/19]"]
["Services & Supplies",0,25364,25364,0,0,{"$f":"SUM(E16:F16)","v":0},0,0,0,0,25364,25364,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",0,224637,224637,0,0,{"$f":"SUM(E17:F17)","v":0},0,0,0,0,224637,224637]
["NGO Subcontracts",900000,0,900000,0,0,0,36238,0,36238,863762,0,863762,"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",0,0,0,0,0,0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",3000,0,{"$f":"SUM(B22:C22)","v":3000},0,0,0,0,0,0,3000,0,3000,0]
["Indirect Costs",0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":0},0,0,39723,{"$f":"SUM(I15:I23)","v":0},39723,960277,250001,1210278,{"$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}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E24,H24)","v":39723},null,null,"Grant funds claimed this period:",{"$f":"H24","v":39723},null,null,null,"Percentage Grant $$ expended to date:","Percentage Grant $$ expended to date:",{"$f":"E28/C24","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":"E29/D24","v":0}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":3485},"1 FTE Project Director @ $79.07/hr x 21 hours + 109.86% benefits $1,824.16 = $3,484.63"]
[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":36238},"Total Personnel $25,444.98 - 1) 0.40 FTE Diversion Supervisor 4,500/month x 2months = $3,600,  2) Licensed Clinical Supervisor 35.48/HR x 38.50 Hrs = $1,365.98, 3) Counselor 25.24/HR x 422.40 Hrs = $10,661.36, 4) Diversion Specialist 21.89/HR x 422.40 Hrs = $9,246.36, 5) Mediator/Case Coordinator 22.67/HR x 25.20 Hrs = $571.28,                                                                                                                                             \nTotal Benefits $6,372.06 - (Approximately 25% of Salaries); Health $2,389.63, Dental $225.14, Vision $17.52, Life $24.98 , 401K $1,029.60, Workers Compensation $169.07, Long-Term Disability $31.37, FICA $1,908.18, Waymakers Points $576.57.\nTotal Service and Supply $4,421.04 - Training for Evidence Based Practices $709.74, Office/Supplies Expense $255.71, Travel (Mileages) $152.26, Liability Insurance $121.63 and Indirect Cost $3,181.70.",null,null,null,null,null,null,null,"Supporting Documentation Provided"]
[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."]
["Jan Wang, Management Analyst",null,null,null,null,null,null,null,null,null,null,6990]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["714-754-5074",null,null,null,null,null,null,null,null,null,null,"CITYOFCOST-001"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jwang@costamesaca.gov",null,null,null,null,null,null,null,null,null,null,"99 FAIR DR"]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-05-13",null,null,null,null,null,null,null,null,null,null,"COSTA MESA CA 92626"]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Jennifer King, Assistant Finance Director"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"714-754-5219"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-05-13"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-09-15",null,null,null,"Approved By:",null,"Kimberly Bushard"]
[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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-19"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:",2,null,"Reporting Period:","2019-10-01","TO","2019-12-31","Due:","2020-02-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 1'!B15","v":97000},{"$f":"'INVOICE 1'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 1'!E15+'INVOICE 1'!H15","v":3485},{"$f":"'INVOICE 1'!F15+'INVOICE 1'!I15","v":0},{"$f":"SUM(E15:F15)","v":3485},2655,0,{"$f":"SUM(H15:I15)","v":2655},{"$f":"B15-E15-H15","v":90860},0,{"$f":"SUM(K15:L15)","v":90860},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":25364},25364,{"$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,25364,25364,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 1'!B17","v":0},{"$f":"'INVOICE 1'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 1'!B18","v":900000},{"$f":"'INVOICE 1'!C18","v":0},900000,{"$f":"'INVOICE 1'!E18+'INVOICE 1'!H18","v":36238},{"$f":"'INVOICE 1'!F18+'INVOICE 1'!I18","v":0},36238,53899,0,53899,809863,0,809863,"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":0},{"$f":"'INVOICE 1'!C21","v":0},0,{"$f":"'INVOICE 1'!E21+'INVOICE 1'!H21","v":0},{"$f":"'INVOICE 1'!F21+'INVOICE 1'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 1'!B22","v":3000},{"$f":"'INVOICE 1'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 1'!E22+'INVOICE 1'!H22","v":0},{"$f":"'INVOICE 1'!F22+'INVOICE 1'!I22","v":0},0,1604,0,1604,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":0},{"$f":"'INVOICE 1'!C23","v":0},0,{"$f":"'INVOICE 1'!E23+'INVOICE 1'!H23","v":0},{"$f":"'INVOICE 1'!F23+'INVOICE 1'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":39723},0,39723,58158,{"$f":"SUM(I15:I23)","v":0},58158,902119,250001,1152120,{"$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":97881},null,null,"Grant funds claimed this period:",{"$f":"H24","v":58158},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.29364329364329367}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":0},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":235452},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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":2655},"1 FTE Project Director @ $79.07/hr x 4 hours + 109.86% Benefits $347.47 = $663.75\n1 FTE Project Director @ $79.07/hr x 2 hours + 109.86% Benefits $173.73 = $331.87\n1 FTE Project Director @ $79.07/hr x 10 hours + 109.86% Benefits $868.66 = $1,659.36"]
[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":53899},"Total Personnel $34,803.47 - 1) 0.40 FTE Diversion Supervisor 4,500/month x 3months = $5,400 2) Counselor 25.24/HR x 140.80 Hrs = $3,553.82  3) 1.00 FTE Counselor 4,732/month x 3 months (less adj. 1,055.60)  = $13,140.40, 4) Diversion Specialist 20.67/HR x 528 Hrs = $10,913.79, 5) Mediator/Case Coordinator 22.67/HR x 79.20 Hrs = $1,795.45,                                                                                                                                             \nTotal Benefits $8,479.61 - (Approximately 25% of Salaries); Health $3,193.23, Dental $290.23, Vision $6.57, Life $23.70, 401K $1,406.96, Workers Compensation $146.57, Long-Term Disability $32.09, FICA $2,547.85, Waymakers Points $447.42, SUI $384.99.\nTotal Service and Supply $10,615.89 - Start-Up $4,234.14 (Dell Computers & Travel), Office/Supplies Expense $1,294.25, Travel (Mileages) $569.59, Liability Insurance $189.61 and Indirect Cost $4,328.30.",null,null,null,null,null,null,null,"Supporting Documentation Provided"]
[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":1604},"Travel expense to attend Grant Orientation from Santa Ana to Sacramento"]
[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."]
["Jan Wang, Management Analyst",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["714-754-5074",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"CITYOFCOST-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jwang@costamesaca.gov",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"99 FAIR DR"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-06-25",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Jennifer King, Assistant Finance Director"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"714-754-5219"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-06-25"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-09-15",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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 2'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 2'!E15+'INVOICE 2'!H15","v":6140},{"$f":"'INVOICE 2'!F15+'INVOICE 2'!I15","v":0},{"$f":"SUM(E15:F15)","v":6140},12114,0,{"$f":"SUM(H15:I15)","v":12114},{"$f":"B15-E15-H15","v":78746},0,{"$f":"SUM(K15:L15)","v":78746},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 2'!B16","v":0},{"$f":"'INVOICE 2'!C16","v":25364},25364,{"$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,25364,25364,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 2'!B17","v":0},{"$f":"'INVOICE 2'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 2'!B18","v":900000},{"$f":"'INVOICE 2'!C18","v":0},900000,{"$f":"'INVOICE 2'!E18+'INVOICE 2'!H18","v":90137},{"$f":"'INVOICE 2'!F18+'INVOICE 2'!I18","v":0},90137,62568,0,62568,747295,0,747295,"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":0},{"$f":"'INVOICE 2'!C21","v":0},0,{"$f":"'INVOICE 2'!E21+'INVOICE 2'!H21","v":0},{"$f":"'INVOICE 2'!F21+'INVOICE 2'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 2'!B22","v":3000},{"$f":"'INVOICE 2'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 2'!E22+'INVOICE 2'!H22","v":1604},{"$f":"'INVOICE 2'!F22+'INVOICE 2'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 2'!B23","v":0},{"$f":"'INVOICE 2'!C23","v":0},0,{"$f":"'INVOICE 2'!E23+'INVOICE 2'!H23","v":0},{"$f":"'INVOICE 2'!F23+'INVOICE 2'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":97881},0,97881,74682,{"$f":"SUM(I15:I23)","v":0},74682,827437,250001,1077438,{"$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":172563},null,null,"Grant funds claimed this period:",{"$f":"H24","v":74682},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.51768951768951765}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":0},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":160770},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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":12114},"1 FTE Project Director @ $79.07/hr x 22 hours + 109.86% Benefits $1,911.06 = $3,650.60\n1 FTE Project Director @ $79.07/hr x 31 hours + 109.86% Benefits $2,692.86 = $5,144.03 \n1 FTE Project Director @ $79.07/hr x 20 hours + 109.86% Benefits $1,737.33 = $3,318.73\n"]
[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":62568},"Total Personnel $39,836.45 - 1) 0.40 FTE Diversion Supervisor 4,644/month x 3months = $5,572.81 2) 0.50 FTE Licensed Clinical Supervisor 5,150 x  3months = $7,725 3) 1.00 FTE Counselor  4,842/month x 3 months  = $14,526 4) Diversion Specialist 21.19/HR x 488 Hrs = $10,340.74 5) Mediator/Case Coordinator 21.11/HR x 79.20 Hrs = $1,671.90.                                                                                                                                             \nTotal Benefits $11,597.30 - (Approximately 25% of Salaries); Health $5,695.17, Dental $494.04, Vision $31.23, Life $39.78, 401K $1,458.27, Workers Compensation $163.03, Long-Term Disability $70.62, FICA $2,857.93, Waymakers Points $742.50, SUI $44.73.\nTotal Service and Supply $8,376.24 - Training for Evidence Based Practices $1,458.49, Office/Supplies Expense $1,256.80, Travel (Mileages) $303.65, Liability Insurance $213.92 and Indirect Cost $5,143.38.",null,null,null,null,null,null,null,"Supporting Documentation Provided"]
[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."]
["Jan Wang",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["714-754-5074",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"CITYOFCOST-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jwang@costamesaca.gov",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"99 FAIR DR"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-06-25",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Jennifer King, Assistant Finance Director"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"714-754-5219"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-06-25"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-09-15",null,null,null,"Approved By:",null,"Kimberly Bushard"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 4","index":5,"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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 3'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 3'!E15+'INVOICE 3'!H15","v":18254},{"$f":"'INVOICE 3'!F15+'INVOICE 3'!I15","v":0},{"$f":"SUM(E15:F15)","v":18254},8380,0,{"$f":"SUM(H15:I15)","v":8380},{"$f":"B15-E15-H15","v":70366},0,{"$f":"SUM(K15:L15)","v":70366},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 3'!B16","v":0},{"$f":"'INVOICE 3'!C16","v":25364},25364,{"$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,7615,7615,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 3'!B17","v":0},{"$f":"'INVOICE 3'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 3'!B18","v":900000},{"$f":"'INVOICE 3'!C18","v":0},900000,{"$f":"'INVOICE 3'!E18+'INVOICE 3'!H18","v":152705},{"$f":"'INVOICE 3'!F18+'INVOICE 3'!I18","v":0},152705,65392,0,65392,681903,0,681903,"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":0},{"$f":"'INVOICE 3'!C21","v":0},0,{"$f":"'INVOICE 3'!E21+'INVOICE 3'!H21","v":0},{"$f":"'INVOICE 3'!F21+'INVOICE 3'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 3'!B22","v":3000},{"$f":"'INVOICE 3'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 3'!E22+'INVOICE 3'!H22","v":1604},{"$f":"'INVOICE 3'!F22+'INVOICE 3'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 3'!B23","v":0},{"$f":"'INVOICE 3'!C23","v":0},0,{"$f":"'INVOICE 3'!E23+'INVOICE 3'!H23","v":0},{"$f":"'INVOICE 3'!F23+'INVOICE 3'!I23","v":0},0,null,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":172563},0,172563,73772,{"$f":"SUM(I15:I23)","v":7615},81387,753665,242386,996051,{"$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":246335},null,null,"Grant funds claimed this period:",{"$f":"H24","v":73772},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.73900573900573896}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":86998},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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":8380},"1 FTE Project Director @ $79.07/hr x 15 hours + 109.86% Benefits $1,302.99 = $2,489.04\n1 FTE Project Director @ $79.07/hr x 18.5 hours + 109.86% Benefits $1,607.03 = $3,069.82\n1 FTE Project Director @ $79.07/hr x 17 hours + 109.86% Benefits $1,476.73 = $2,820.92  \n"]
[null,"Match",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":7615},"YRG Office rental July 2019-June 2020 @ $495/ month for 12 Months and Misc. Office Supplies ($1675.00)"]
["Professional Services","Grant Funds",{"$f":"H17","v":0}]
[null,"Match",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":65392},"Total Personnel $39,836.45 - 1) 0.40 FTE Diversion Supervisor 4,644/month x 3months = $5,572.81 2) 0.50 FTE Licensed Clinical Supervisor 5,150 x  3months = $7,725 3) 1.00 FTE Counselor  4,842/month x 3 months  = $14,526 4) Diversion Specialist 21.19/HR x 488 Hrs = $10,340.74 5) Mediator/Case Coordinator 21.11/HR x 79.20 Hrs = $1,671.90.                                                                                                                                             \nTotal Benefits $11,597.30 - (Approximately 25% of Salaries); Health $5,695.17, Dental $494.04, Vision $31.23, Life $39.78, 401K $1,458.27, Workers Compensation $163.03, Long-Term Disability $70.62, FICA $2,857.93, Waymakers Points $742.50, SUI $44.73.\nTotal Service and Supply $8,376.24 - Training for Evidence Based Practices $1,458.49, Office/Supplies Expense $1,256.80, Travel (Mileages) $303.65, Liability Insurance $213.92 and Indirect Cost $5,143.38.",null,null,null,null,null,null,null,"Previously mentioned, additional personnel FTE for Q4 were covered by FTE savings identified in Q1 & Q2. Total YTD FTE for Year 1 at 2.74. Services from (CRF-OC)-$18,918 line item have been cancelled due to COVID-19. Waymakers has requested to roll-over the remaining balance of $6,347 in the Training for Evidence Based Practices line item to Year 2. The projected spend out for this line item is Q2 of Year 2."]
[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."]
["Jan Wang, Management Analyst",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["714-754-5074",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"CITYOFCOST-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jwang@costamesaca.gov",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"99 FAIR DR"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-08-03",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Jennifer King, Assistant Finance Director"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"714-754-5219"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-08-03"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-09-15",null,null,null,"Approved By:",null,"Kimberly Bushard"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"2nd Advance Payment","index":6,"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,2469]
["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":"City of Costa Mesa"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-19"},null,null,null,null,"Address","99 FAIR DRIVE"]
[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,"COSTA MESA, A 92626"]
[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 #","5"]
[]
[]
["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:",333334]
[]
[]
[]
[null,"PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER"]
[null,"Jan Wang, Management Analyst",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,"714-754-5074"]
[null,"Phone"]
[null,"jwang@costamesaca.gov"]
[null,"Email"]
[null,"2020-11-17"]
[null,"Date"]
[]
[null,null,null,null,null,null,"Jennifer King, Assistant Finance Director"]
[null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,"714-754-5219"]
[null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,"jennifer.king@costamesaca.gov"]
[null,null,null,null,null,null,"Email"]
[null,null,null,null,null,null,"2020-12-03"]
[null,null,null,null,null,null,"Date"]
[null,null,null,null,null,null,"Jennifer King  "]
[null,null,null,null,null,null,"Signature"]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,"Approved By:","Eddie Escobar",null,null,null,null,null,null,"BSCC Supplier Data "]
[null,null,"BSCC Field Representative",null,null,null,null,null,"CITYOFCOST-001"]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:","2021-04-21",null,null,null,null,null,6990]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"INVOICE 5","index":7,"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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 4'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 4'!E15+'INVOICE 4'!H15","v":26634},{"$f":"'INVOICE 4'!F15+'INVOICE 4'!I15","v":0},{"$f":"SUM(E15:F15)","v":26634},5321,0,{"$f":"SUM(H15:I15)","v":5321},{"$f":"B15-E15-H15","v":65045},0,{"$f":"SUM(K15:L15)","v":65045},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 4'!B16","v":0},{"$f":"'INVOICE 4'!C16","v":25364},25364,{"$f":"'INVOICE 4'!E16+'INVOICE 4'!H16","v":0},{"$f":"'INVOICE 4'!F16+'INVOICE 4'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 4'!B17","v":0},{"$f":"'INVOICE 4'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 4'!B18","v":900000},{"$f":"'INVOICE 4'!C18","v":0},900000,{"$f":"'INVOICE 4'!E18+'INVOICE 4'!H18","v":218097},{"$f":"'INVOICE 4'!F18+'INVOICE 4'!I18","v":0},218097,59810,0,59810,622093,0,622093,"2nd Advance \n[5/14/21]"]
["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,333333]
["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":0},{"$f":"'INVOICE 4'!C21","v":0},0,{"$f":"'INVOICE 4'!E21+'INVOICE 4'!H21","v":0},{"$f":"'INVOICE 4'!F21+'INVOICE 4'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 4'!B22","v":3000},{"$f":"'INVOICE 4'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 4'!E22+'INVOICE 4'!H22","v":1604},{"$f":"'INVOICE 4'!F22+'INVOICE 4'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 4'!B23","v":0},{"$f":"'INVOICE 4'!C23","v":0},0,{"$f":"'INVOICE 4'!E23+'INVOICE 4'!H23","v":0},{"$f":"'INVOICE 4'!F23+'INVOICE 4'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":246335},7615,253950,65131,{"$f":"SUM(I15:I23)","v":0},65131,688534,242386,930920,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":311466},null,null,"Grant funds claimed this period:",{"$f":"H24","v":65131},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.4671994671994672}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":355200},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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":5321},"1 FTE Project Director @ $81.44/hr x 12 hours + 104.19% Benefits $1,018.28= $1,995.56 [July 2020]\n1 FTE Project Director @  $81.44/hr x 10 hours + 104.19% Benefits $848.56 = $1,662.96 [Aug 2020]\n1 FTE Project Director @ $81.44/hr x 10 hours + 104.19% Benefits $848.56 = $1,662.96 [Sept 2020]",null,null,null,null,null,null,null,"Working with Waymakers and to update other PD angencies (12 hrs); Coordinate CMPD process and training for patrol (10 hrs); working with Waymakers and coordinating MOU with the other angencies (10 hrs) "]
[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":59810},"Total Personnel $39,836.45 - 1) 0.40 FTE Diversion Supervisor 4,644/month x 3months = $5,572.81 2) 0.50 FTE Licensed Clinical Supervisor 5,150 x  3months = $7,725 3) 1.00 FTE Counselor  4,842/month x 3 months  = $14,526 4) Diversion Specialist 21.19/HR x 488 Hrs = $10,340.74 5) Mediator/Case Coordinator 21.11/HR x 79.20 Hrs = $1,671.90.                                                                                                                                             \nTotal Benefits $11,597.30 - (Approximately 25% of Salaries); Health $5,695.17, Dental $494.04, Vision $31.23, Life $39.78, 401K $1,458.27, Workers Compensation $163.03, Long-Term Disability $70.62, FICA $2,857.93, Waymakers Points $742.50, SUI $44.73.\nTotal Service and Supply $8,376.24 - Training for Evidence Based Practices $1,458.49, Office/Supplies Expense $1,256.80, Travel (Mileages) $303.65, Liability Insurance $213.92 and Indirect Cost $5,143.38.",null,null,null,null,null,null,null,"CRF-OC budget line item will continue to be underspent due to COVID-19 restrictions. On-site group services are currently not provided by schools. Alternative services under review."]
[null,"Match",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Match",{"$f":"I19","v":0}]
["Data Collection","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Project Evaluation","Grant Funds",{"$f":"H21","v":0}]
[null,"Match",{"$f":"I21","v":0}]
["Other","Grant Funds",{"$f":"H22","v":0}]
[null,"Match",{"$f":"I22","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H23","v":0}]
[null,"Match",{"$f":"I23","v":0}]
["Project Income",null,{"$f":"I26","v":0}]
["PERSON PREPARING REPORT",null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,null,null,null,"By checking the box below, I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
["Jan Wang, Management Analyst",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["714-754-5074",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"CITYOFCOST-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jwang@costamesaca.gov",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"99 FAIR DR"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2020-11-12",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Jennifer King, Assistant Finance Director"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"714-754-5219"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2020-11-15"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-11-15",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 6","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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 5'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 5'!E15+'INVOICE 5'!H15","v":31955},{"$f":"'INVOICE 5'!F15+'INVOICE 5'!I15","v":0},{"$f":"SUM(E15:F15)","v":31955},5831,0,{"$f":"SUM(H15:I15)","v":5831},{"$f":"B15-E15-H15","v":59214},0,{"$f":"SUM(K15:L15)","v":59214},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 5'!B16","v":0},{"$f":"'INVOICE 5'!C16","v":25364},25364,{"$f":"'INVOICE 5'!E16+'INVOICE 5'!H16","v":0},{"$f":"'INVOICE 5'!F16+'INVOICE 5'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 5'!B17","v":0},{"$f":"'INVOICE 5'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 5'!B18","v":900000},{"$f":"'INVOICE 5'!C18","v":0},900000,{"$f":"'INVOICE 5'!E18+'INVOICE 5'!H18","v":277907},{"$f":"'INVOICE 5'!F18+'INVOICE 5'!I18","v":0},277907,63829,0,63829,558264,0,558264,{"$f":"'INVOICE 5'!N18","v":"2nd Advance \n[5/14/21]"}]
["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,{"$f":"'INVOICE 5'!N19","v":333333}]
["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":0},{"$f":"'INVOICE 5'!C21","v":0},0,{"$f":"'INVOICE 5'!E21+'INVOICE 5'!H21","v":0},{"$f":"'INVOICE 5'!F21+'INVOICE 5'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 5'!B22","v":3000},{"$f":"'INVOICE 5'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 5'!E22+'INVOICE 5'!H22","v":1604},{"$f":"'INVOICE 5'!F22+'INVOICE 5'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 5'!B23","v":0},{"$f":"'INVOICE 5'!C23","v":0},0,{"$f":"'INVOICE 5'!E23+'INVOICE 5'!H23","v":0},{"$f":"'INVOICE 5'!F23+'INVOICE 5'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":311466},7615,319081,69660,{"$f":"SUM(I15:I23)","v":0},69660,618874,242386,861260,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":381126},null,null,"Grant funds claimed this period:",{"$f":"H24","v":69660},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.57168957168957169}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":285540},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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":5831},"1 FTE Project Director @ $81.44/hr x 13 hours + 104.563% Benefits $1,107.03= $2,165.75 (October 2020)\n1 FTE Project Director @  $81.44/hr x 12 hours + 104.563% Benefits $1,021.88 = $1,999.16 (November 2020)\n1 FTE Project Director @ $81.44/hr x 10 hours + 104.563% Benefits $851.56 = $1,665.96 (December 2020)\n",null,null,null,null,null,null,null,"project director call w/BSCC, contact OC Probation and Waymakers"]
[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":63829},"Total Personnel $40,667.35 - 1) 0.40 FTE Diversion Supervisor 4,644/month x 3months (Less $16.68 due to covid related leave EPSL Self)  = $5,556.12 2) 0.50 FTE Licensed Clinical Supervisor 5,150 x  3months = $7,725 3) 1.00 FTE Counselor  4,842/month x 3 months  = $14,526 4) Diversion Specialist 21.19/HR x 528 Hrs = $11,188.34 5) Mediator/Case Coordinator 21.11/HR x 79.20 Hrs = $1,671.89.                                                                                                                                             \nTotal Benefits $12,628.14 - (Approximately 25% of Salaries); Health $6,551.27, Dental $479.28, Vision $31.23, Life $43.48, 401K $1,472.96, Workers Compensation $146.92, Long-Term Disability $70.62, FICA $2,921.35, Waymakers Points $741.64, SUI $169.39.\nTotal Service and Supply $10,533.61 - Training for Evidence Based Practices $3,390, Office/Supplies Expense $1,059.40, Travel (Mileages) $119.36, Liability Insurance $325.05, Subcontract:Constitution Rights Foundation Peer Court $310.25 and Indirect Cost $5,329.55.",null,null,null,null,null,null,null,"Supporting Documents Provided"]
[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."]
["Jan Wang, Management Analyst ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["714-754-5074",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"CITYOFCOST-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jwang@costamesaca.gov ",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"99 FAIR DR"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-02-03",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Jennifer King, Assistant Finance Director"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"714-754-5219"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-02-03"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-02-03",null,null,null,"Approved By:",null,"Eddie Escobar"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 7","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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 6'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 6'!E15+'INVOICE 6'!H15","v":37786},{"$f":"'INVOICE 6'!F15+'INVOICE 6'!I15","v":0},{"$f":"SUM(E15:F15)","v":37786},6497,0,{"$f":"SUM(H15:I15)","v":6497},{"$f":"B15-E15-H15","v":52717},0,{"$f":"SUM(K15:L15)","v":52717},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 6'!B16","v":0},{"$f":"'INVOICE 6'!C16","v":25364},25364,{"$f":"'INVOICE 6'!E16+'INVOICE 6'!H16","v":0},{"$f":"'INVOICE 6'!F16+'INVOICE 6'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 6'!B17","v":0},{"$f":"'INVOICE 6'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 6'!B18","v":900000},{"$f":"'INVOICE 6'!C18","v":0},900000,{"$f":"'INVOICE 6'!E18+'INVOICE 6'!H18","v":341736},{"$f":"'INVOICE 6'!F18+'INVOICE 6'!I18","v":0},341736,59969,0,59969,498295,0,498295,{"$f":"'INVOICE 6'!N18","v":"2nd Advance \n[5/14/21]"}]
["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,{"$f":"'INVOICE 6'!N19","v":333333}]
["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":0},{"$f":"'INVOICE 6'!C21","v":0},0,{"$f":"'INVOICE 6'!E21+'INVOICE 6'!H21","v":0},{"$f":"'INVOICE 6'!F21+'INVOICE 6'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 6'!B22","v":3000},{"$f":"'INVOICE 6'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 6'!E22+'INVOICE 6'!H22","v":1604},{"$f":"'INVOICE 6'!F22+'INVOICE 6'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 6'!B23","v":0},{"$f":"'INVOICE 6'!C23","v":0},0,{"$f":"'INVOICE 6'!E23+'INVOICE 6'!H23","v":0},{"$f":"'INVOICE 6'!F23+'INVOICE 6'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":381126},7615,388741,66466,{"$f":"SUM(I15:I23)","v":0},66466,552408,242386,794794,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":447592},null,null,"Grant funds claimed this period:",{"$f":"H24","v":66466},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.67138867138867142}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":219074},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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":6497},"1 FTE Project Director @ $81.44/hr x 13 hours + 104.563% Benefits $1,107.03= $2,165.75 (January 2021)\n1 FTE Project Director @ $81.44/hr x 13 hours + 104.563% Benefits $1,107.03= $2,165.75 (February 2021)\n1 FTE Project Director @ $81.44/hr x 13 hours + 104.563% Benefits $1,107.03= $2,165.75 (March 2021)\n"]
[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":59969},"Total Personnel $40,320.55 - 1) 0.40 FTE Diversion Supervisor 4,854/month x 3months  = $5824.80 2) 0.50 FTE Licensed Clinical Supervisor 5,150 x  3months = $7,725 3) Counselor  27.93/hHR x 512 Hrs + (rounding 0.01) = $14,300.17  4) Diversion Specialist 21.19/HR x 512 Hrs + (rounding 0.06) = $10,849.34 and 5) Mediator/Case Coordinator 21.11/HR x 76.80 Hrs = $1,621.24.                                                                                                                                             \nTotal Benefits $11,260.81 - (Approximately 30% of Salaries); Health $4,861.71, Dental $442.07, Vision $31.23, Life $39.74 401K $1,462.47, Workers Compensation $131.85, Long-Term Disability $71.45, FICA $2,890.12, Waymakers Points $742.22, SUI $363.95 and Paid leave Payout $224.00.\nTotal Service and Supply $8,387.53 -  Office/Supplies Expense $2,206.75, Travel (Mileages) $335.53, Liability Insurance $294.73, Subcontract:Constitution Rights Foundation Peer Court $392.38 and Indirect Cost $5,158.14."]
[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."]
["Jan Wang, Management Analyst",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["714-754-5074",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"CITYOFCOST-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jwang@costamesaca.gov",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"99 FAIR DR"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-05-24",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Jennifer King, Assistant Finance Director"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"714-754-5219"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2021-05-25"]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2021-05-25",null,null,null,"Approved By:",null,"Eddie Escobar",null,null,null,null,"2021-07-09"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 8","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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 7'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 7'!E15+'INVOICE 7'!H15","v":44283},{"$f":"'INVOICE 7'!F15+'INVOICE 7'!I15","v":0},{"$f":"SUM(E15:F15)","v":44283},6497,0,{"$f":"SUM(H15:I15)","v":6497},{"$f":"B15-E15-H15","v":46220},0,{"$f":"SUM(K15:L15)","v":46220},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 7'!B16","v":0},{"$f":"'INVOICE 7'!C16","v":25364},25364,{"$f":"'INVOICE 7'!E16+'INVOICE 7'!H16","v":0},{"$f":"'INVOICE 7'!F16+'INVOICE 7'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 7'!B17","v":0},{"$f":"'INVOICE 7'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 7'!B18","v":900000},{"$f":"'INVOICE 7'!C18","v":0},900000,{"$f":"'INVOICE 7'!E18+'INVOICE 7'!H18","v":401705},{"$f":"'INVOICE 7'!F18+'INVOICE 7'!I18","v":0},401705,63720,0,63720,434575,0,434575,{"$f":"'INVOICE 7'!N18","v":"2nd Advance \n[5/14/21]"}]
["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,{"$f":"'INVOICE 7'!N19","v":333333}]
["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":0},{"$f":"'INVOICE 7'!C21","v":0},0,{"$f":"'INVOICE 7'!E21+'INVOICE 7'!H21","v":0},{"$f":"'INVOICE 7'!F21+'INVOICE 7'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 7'!B22","v":3000},{"$f":"'INVOICE 7'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 7'!E22+'INVOICE 7'!H22","v":1604},{"$f":"'INVOICE 7'!F22+'INVOICE 7'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 7'!B23","v":0},{"$f":"'INVOICE 7'!C23","v":0},0,{"$f":"'INVOICE 7'!E23+'INVOICE 7'!H23","v":0},{"$f":"'INVOICE 7'!F23+'INVOICE 7'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":447592},7615,455207,70217,{"$f":"SUM(I15:I23)","v":0},70217,482191,242386,724577,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":517809},null,null,"Grant funds claimed this period:",{"$f":"H24","v":70217},null,null,null,null,"% total dispursed fund expended to date:",{"$f":"D28/N24","v":0.77671427671427673}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":148857},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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":6497},"1 FTE Project Director @ $81.44/hr x 13 hours + 104.563% Benefits $1,107.03= $2,165.75 (April 2021)\n1 FTE Project Director @ $81.44/hr x 13 hours + 104.563% Benefits $1,107.03= $2,165.75 (May 2021)\n1 FTE Project Director @ $81.44/hr x 13 hours + 104.563% Benefits $1,107.03= $2,165.75 (June 2021)\n"]
[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":63720},"Total Personnel $40,959.14 - 1) 0.40 FTE Diversion Supervisor 4,854/month x 2.5months  = $4,854 & 0.49077 FTE 4,854/month x 0.5months = $1,191.10 2) 0.50 FTE Licensed Clinical Supervisor 5,150 x  3months = $7,725 3) Counselor  27.93/hHR x 520 Hrs + (rounding 0.03) = $14,523.63  4) Diversion Specialist 21.19/HR x 520 Hrs + (rounding 0.03) = $11,018.83 and 5) Mediator/Case Coordinator 21.11/HR x 78 Hrs = $1,646.58.                                                                                                                                             \nTotal Benefits $11,742.43 - (Approximately 30% of Salaries); Health $5,695.17, Dental $532.44, Vision $31.23, Life $39.78, 401K $1,505.3, Workers Compensation $164.97, Long-Term Disability $73.32, FICA $2,953.18 and Waymakers Points $747.04 .\nTotal Service and Supply $11,018.53 -  Office/Supplies Expense $314.32, Travel (Mileages) $331.31, Liability Insurance $1,497.13, Employee Training $1,200, Staff Recruitment $35, Employee Training Subcontract:Constitution Rights Foundation Peer Court $2,370.61 and Indirect Cost $5,270.16."]
[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 King, Assistant Finance Director",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["714-754-5219",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L57:O57","v":"CITYOFCOST-001"}]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["jennifer.king@costamesaca.gov",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L59:O59","v":"99 FAIR DR"}]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2021-08-11",null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L61:O61","v":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Jennifer King, Assistant Finance Director"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"714-754-5219"]
[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":"INVOICE 9","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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 8'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 8'!E15+'INVOICE 8'!H15","v":50780},{"$f":"'INVOICE 8'!F15+'INVOICE 8'!I15","v":0},{"$f":"SUM(E15:F15)","v":50780},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":46220},0,{"$f":"SUM(K15:L15)","v":46220},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 8'!B16","v":0},{"$f":"'INVOICE 8'!C16","v":25364},25364,{"$f":"'INVOICE 8'!E16+'INVOICE 8'!H16","v":0},{"$f":"'INVOICE 8'!F16+'INVOICE 8'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 8'!B17","v":0},{"$f":"'INVOICE 8'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 8'!B18","v":900000},{"$f":"'INVOICE 8'!C18","v":0},900000,{"$f":"'INVOICE 8'!E18+'INVOICE 8'!H18","v":465425},{"$f":"'INVOICE 8'!F18+'INVOICE 8'!I18","v":0},465425,0,0,0,434575,0,434575,{"$f":"'INVOICE 8'!N18","v":"2nd Advance \n[5/14/21]"}]
["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,{"$f":"'INVOICE 8'!N19","v":333333}]
["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":0},{"$f":"'INVOICE 8'!C21","v":0},0,{"$f":"'INVOICE 8'!E21+'INVOICE 8'!H21","v":0},{"$f":"'INVOICE 8'!F21+'INVOICE 8'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 8'!B22","v":3000},{"$f":"'INVOICE 8'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 8'!E22+'INVOICE 8'!H22","v":1604},{"$f":"'INVOICE 8'!F22+'INVOICE 8'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 8'!B23","v":0},{"$f":"'INVOICE 8'!C23","v":0},0,{"$f":"'INVOICE 8'!E23+'INVOICE 8'!H23","v":0},{"$f":"'INVOICE 8'!F23+'INVOICE 8'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":517809},7615,525424,0,{"$f":"SUM(I15:I23)","v":0},0,482191,242386,724577,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":517809},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.77671427671427673}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":148857},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["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":"CITYOFCOST-001"}]
["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":"99 FAIR DR"}]
["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":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 10","index":12,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 9'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 9'!E15+'INVOICE 9'!H15","v":50780},{"$f":"'INVOICE 9'!F15+'INVOICE 9'!I15","v":0},{"$f":"SUM(E15:F15)","v":50780},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":46220},0,{"$f":"SUM(K15:L15)","v":46220},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 9'!B16","v":0},{"$f":"'INVOICE 9'!C16","v":25364},25364,{"$f":"'INVOICE 9'!E16+'INVOICE 9'!H16","v":0},{"$f":"'INVOICE 9'!F16+'INVOICE 9'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 9'!B17","v":0},{"$f":"'INVOICE 9'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 9'!B18","v":900000},{"$f":"'INVOICE 9'!C18","v":0},900000,{"$f":"'INVOICE 9'!E18+'INVOICE 9'!H18","v":465425},{"$f":"'INVOICE 9'!F18+'INVOICE 9'!I18","v":0},465425,0,0,0,434575,0,434575,{"$f":"'INVOICE 9'!N18","v":"2nd Advance \n[5/14/21]"}]
["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,{"$f":"'INVOICE 9'!N19","v":333333}]
["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":0},{"$f":"'INVOICE 9'!C21","v":0},0,{"$f":"'INVOICE 9'!E21+'INVOICE 9'!H21","v":0},{"$f":"'INVOICE 9'!F21+'INVOICE 9'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 9'!B22","v":3000},{"$f":"'INVOICE 9'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 9'!E22+'INVOICE 9'!H22","v":1604},{"$f":"'INVOICE 9'!F22+'INVOICE 9'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 9'!B23","v":0},{"$f":"'INVOICE 9'!C23","v":0},0,{"$f":"'INVOICE 9'!E23+'INVOICE 9'!H23","v":0},{"$f":"'INVOICE 9'!F23+'INVOICE 9'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":517809},7615,525424,0,{"$f":"SUM(I15:I23)","v":0},0,482191,242386,724577,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":517809},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.77671427671427673}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":148857},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["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":"CITYOFCOST-001"}]
["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":"99 FAIR DR"}]
["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":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 11","index":13,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 10'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 10'!E15+'INVOICE 10'!H15","v":50780},{"$f":"'INVOICE 10'!F15+'INVOICE 10'!I15","v":0},{"$f":"SUM(E15:F15)","v":50780},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":46220},0,{"$f":"SUM(K15:L15)","v":46220},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 10'!B16","v":0},{"$f":"'INVOICE 10'!C16","v":25364},25364,{"$f":"'INVOICE 10'!E16+'INVOICE 10'!H16","v":0},{"$f":"'INVOICE 10'!F16+'INVOICE 10'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 10'!B17","v":0},{"$f":"'INVOICE 10'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 10'!B18","v":900000},{"$f":"'INVOICE 10'!C18","v":0},900000,{"$f":"'INVOICE 10'!E18+'INVOICE 10'!H18","v":465425},{"$f":"'INVOICE 10'!F18+'INVOICE 10'!I18","v":0},465425,0,0,0,434575,0,434575,{"$f":"'INVOICE 10'!N18","v":"2nd Advance \n[5/14/21]"}]
["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,{"$f":"'INVOICE 10'!N19","v":333333}]
["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":0},{"$f":"'INVOICE 10'!C21","v":0},0,{"$f":"'INVOICE 10'!E21+'INVOICE 10'!H21","v":0},{"$f":"'INVOICE 10'!F21+'INVOICE 10'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 10'!B22","v":3000},{"$f":"'INVOICE 10'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 10'!E22+'INVOICE 10'!H22","v":1604},{"$f":"'INVOICE 10'!F22+'INVOICE 10'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 10'!B23","v":0},{"$f":"'INVOICE 10'!C23","v":0},0,{"$f":"'INVOICE 10'!E23+'INVOICE 10'!H23","v":0},{"$f":"'INVOICE 10'!F23+'INVOICE 10'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":517809},7615,525424,0,{"$f":"SUM(I15:I23)","v":0},0,482191,242386,724577,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":517809},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.77671427671427673}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":148857},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["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":"CITYOFCOST-001"}]
["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":"99 FAIR DR"}]
["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":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 12","index":14,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 11'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 11'!E15+'INVOICE 11'!H15","v":50780},{"$f":"'INVOICE 11'!F15+'INVOICE 11'!I15","v":0},{"$f":"SUM(E15:F15)","v":50780},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":46220},0,{"$f":"SUM(K15:L15)","v":46220},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 11'!B16","v":0},{"$f":"'INVOICE 11'!C16","v":25364},25364,{"$f":"'INVOICE 11'!E16+'INVOICE 11'!H16","v":0},{"$f":"'INVOICE 11'!F16+'INVOICE 11'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 11'!B17","v":0},{"$f":"'INVOICE 11'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 11'!B18","v":900000},{"$f":"'INVOICE 11'!C18","v":0},900000,{"$f":"'INVOICE 11'!E18+'INVOICE 11'!H18","v":465425},{"$f":"'INVOICE 11'!F18+'INVOICE 11'!I18","v":0},465425,0,0,0,434575,0,434575,{"$f":"'INVOICE 11'!N18","v":"2nd Advance \n[5/14/21]"}]
["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,{"$f":"'INVOICE 11'!N19","v":333333}]
["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":0},{"$f":"'INVOICE 11'!C21","v":0},0,{"$f":"'INVOICE 11'!E21+'INVOICE 11'!H21","v":0},{"$f":"'INVOICE 11'!F21+'INVOICE 11'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 11'!B22","v":3000},{"$f":"'INVOICE 11'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 11'!E22+'INVOICE 11'!H22","v":1604},{"$f":"'INVOICE 11'!F22+'INVOICE 11'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 11'!B23","v":0},{"$f":"'INVOICE 11'!C23","v":0},0,{"$f":"'INVOICE 11'!E23+'INVOICE 11'!H23","v":0},{"$f":"'INVOICE 11'!F23+'INVOICE 11'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":517809},7615,525424,0,{"$f":"SUM(I15:I23)","v":0},0,482191,242386,724577,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":517809},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.77671427671427673}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":148857},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["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":"CITYOFCOST-001"}]
["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":"99 FAIR DR"}]
["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":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 13","index":15,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 12'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 12'!E15+'INVOICE 12'!H15","v":50780},{"$f":"'INVOICE 12'!F15+'INVOICE 12'!I15","v":0},{"$f":"SUM(E15:F15)","v":50780},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":46220},0,{"$f":"SUM(K15:L15)","v":46220},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 12'!B16","v":0},{"$f":"'INVOICE 12'!C16","v":25364},25364,{"$f":"'INVOICE 12'!E16+'INVOICE 12'!H16","v":0},{"$f":"'INVOICE 12'!F16+'INVOICE 12'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 12'!B17","v":0},{"$f":"'INVOICE 12'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 12'!B18","v":900000},{"$f":"'INVOICE 12'!C18","v":0},900000,{"$f":"'INVOICE 12'!E18+'INVOICE 12'!H18","v":465425},{"$f":"'INVOICE 12'!F18+'INVOICE 12'!I18","v":0},465425,0,0,0,434575,0,434575,{"$f":"'INVOICE 12'!N18","v":"2nd Advance \n[5/14/21]"}]
["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,{"$f":"'INVOICE 12'!N19","v":333333}]
["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":0},{"$f":"'INVOICE 12'!C21","v":0},0,{"$f":"'INVOICE 12'!E21+'INVOICE 12'!H21","v":0},{"$f":"'INVOICE 12'!F21+'INVOICE 12'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 12'!B22","v":3000},{"$f":"'INVOICE 12'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 12'!E22+'INVOICE 12'!H22","v":1604},{"$f":"'INVOICE 12'!F22+'INVOICE 12'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 12'!B23","v":0},{"$f":"'INVOICE 12'!C23","v":0},0,{"$f":"'INVOICE 12'!E23+'INVOICE 12'!H23","v":0},{"$f":"'INVOICE 12'!F23+'INVOICE 12'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":517809},7615,525424,0,{"$f":"SUM(I15:I23)","v":0},0,482191,242386,724577,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":517809},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.77671427671427673}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":148857},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["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":"CITYOFCOST-001"}]
["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":"99 FAIR DR"}]
["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":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 14","index":16,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:","N/A"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 13'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 13'!E15+'INVOICE 13'!H15","v":50780},{"$f":"'INVOICE 13'!F15+'INVOICE 13'!I15","v":0},{"$f":"SUM(E15:F15)","v":50780},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":46220},0,{"$f":"SUM(K15:L15)","v":46220},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 13'!B16","v":0},{"$f":"'INVOICE 13'!C16","v":25364},25364,{"$f":"'INVOICE 13'!E16+'INVOICE 13'!H16","v":0},{"$f":"'INVOICE 13'!F16+'INVOICE 13'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 13'!B17","v":0},{"$f":"'INVOICE 13'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 13'!B18","v":900000},{"$f":"'INVOICE 13'!C18","v":0},900000,{"$f":"'INVOICE 13'!E18+'INVOICE 13'!H18","v":465425},{"$f":"'INVOICE 13'!F18+'INVOICE 13'!I18","v":0},465425,0,0,0,434575,0,434575,{"$f":"'INVOICE 13'!N18","v":"2nd Advance \n[5/14/21]"}]
["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,{"$f":"'INVOICE 13'!N19","v":333333}]
["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":0},{"$f":"'INVOICE 13'!C21","v":0},0,{"$f":"'INVOICE 13'!E21+'INVOICE 13'!H21","v":0},{"$f":"'INVOICE 13'!F21+'INVOICE 13'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 13'!B22","v":3000},{"$f":"'INVOICE 13'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 13'!E22+'INVOICE 13'!H22","v":1604},{"$f":"'INVOICE 13'!F22+'INVOICE 13'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 13'!B23","v":0},{"$f":"'INVOICE 13'!C23","v":0},0,{"$f":"'INVOICE 13'!E23+'INVOICE 13'!H23","v":0},{"$f":"'INVOICE 13'!F23+'INVOICE 13'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":517809},7615,525424,0,{"$f":"SUM(I15:I23)","v":0},0,482191,242386,724577,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":517809},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.77671427671427673}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":148857},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["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":"CITYOFCOST-001"}]
["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":"99 FAIR DR"}]
["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":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 15","index":17,"n_rows":73,"n_cols":14,"rows_kept":73,"cut":false,"hidden":false,"merged":[[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,2469]
["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":"City of Costa Mesa"},null,null,null,"Lead Public Agency:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-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":97000},{"$f":"'INVOICE 14'!C15","v":0},{"$f":"SUM(B15:C15)","v":97000},{"$f":"'INVOICE 14'!E15+'INVOICE 14'!H15","v":50780},{"$f":"'INVOICE 14'!F15+'INVOICE 14'!I15","v":0},{"$f":"SUM(E15:F15)","v":50780},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":46220},0,{"$f":"SUM(K15:L15)","v":46220},"1st Advance [10/25/19]"]
["Services & Supplies",{"$f":"'INVOICE 14'!B16","v":0},{"$f":"'INVOICE 14'!C16","v":25364},25364,{"$f":"'INVOICE 14'!E16+'INVOICE 14'!H16","v":0},{"$f":"'INVOICE 14'!F16+'INVOICE 14'!I16","v":7615},{"$f":"SUM(E16:F16)","v":7615},0,0,0,0,17749,17749,{"$f":"'1st Advance Payment'!K20","v":333333}]
["Professional Services",{"$f":"'INVOICE 14'!B17","v":0},{"$f":"'INVOICE 14'!C17","v":224637},224637,{"$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,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 14'!B18","v":900000},{"$f":"'INVOICE 14'!C18","v":0},900000,{"$f":"'INVOICE 14'!E18+'INVOICE 14'!H18","v":465425},{"$f":"'INVOICE 14'!F18+'INVOICE 14'!I18","v":0},465425,0,0,0,434575,0,434575,{"$f":"'INVOICE 14'!N18","v":"2nd Advance \n[5/14/21]"}]
["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,{"$f":"'INVOICE 14'!N19","v":333333}]
["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":0},{"$f":"'INVOICE 14'!C21","v":0},0,{"$f":"'INVOICE 14'!E21+'INVOICE 14'!H21","v":0},{"$f":"'INVOICE 14'!F21+'INVOICE 14'!I21","v":0},0,0,0,0,0,0,0,"3rd Advance\n [enter date]"]
["Other",{"$f":"'INVOICE 14'!B22","v":3000},{"$f":"'INVOICE 14'!C22","v":0},{"$f":"SUM(B22:C22)","v":3000},{"$f":"'INVOICE 14'!E22+'INVOICE 14'!H22","v":1604},{"$f":"'INVOICE 14'!F22+'INVOICE 14'!I22","v":0},1604,0,0,0,1396,0,1396,0]
["Indirect Costs",{"$f":"'INVOICE 14'!B23","v":0},{"$f":"'INVOICE 14'!C23","v":0},0,{"$f":"'INVOICE 14'!E23+'INVOICE 14'!H23","v":0},{"$f":"'INVOICE 14'!F23+'INVOICE 14'!I23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B15:B23)","v":1000000},{"$f":"SUM(C15:C23)","v":250001},{"$f":"SUM(D15:D23)","v":1250001},{"$f":"SUM(E15:E23)","v":517809},7615,525424,0,{"$f":"SUM(I15:I23)","v":0},0,482191,242386,724577,{"$f":"SUM(N16+N19+N22)","v":666666}]
[]
["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":517809},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.77671427671427673}]
[null,null,"Match funds to date:",{"$f":"SUM(F24,I24)","v":7615},null,null,"Advance disbursments balance:",{"$f":"N24-D28","v":148857},null,null,null,null,"% of Total Obligated Match to date:",{"$f":"E29/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."]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!L55:O55","v":6990}]
["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":"CITYOFCOST-001"}]
["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":"99 FAIR DR"}]
["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":"COSTA MESA CA 92626"}]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[]
[null,null,null,null,"Name, Title"]
[]
[null,null,null,null,"Phone"]
[]
[null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"3rd Advance Payment","index":18,"n_rows":54,"n_cols":12,"rows_kept":54,"cut":false,"hidden":false,"merged":[[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,2469]
["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":"City of Costa Mesa"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 569-19"},null,null,null,null,"Address"]
[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,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #",null,"3 YRG 2019",null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
[null,"Effective Invoice #"]
[]
[]
["Advance Payment Invoice"]
[null,null,null,null,null,null,null,null,null,"Total Grant Award:",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:",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":19,"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":"City of Costa Mesa"},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 569-19"},null,null,null,null,null,null,null,"Modification Request #"]
[]
["Term:",{"$f":"'INVOICE 1'!E9","v":"2019-07-01"},{"$f":"'INVOICE 1'!F9","v":"TO"},{"$f":"'INVOICE 1'!G9","v":"2023-02-28"},null,null,null,null,null,"Effective on Invoice #"]
[]
["Line Items","Current Budget",null,null,"Available Budget",null,null,"Changes (+/-)",null,null,"Modified Budget"]
[null,"Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL","Grant Funds","Match","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 1'!B15","v":97000},{"$f":"'INVOICE 1'!C15","v":0},{"$f":"SUM(B22:C22)","v":97000},{"$f":"'INVOICE 2'!K15","v":90860},{"$f":"'INVOICE 2'!L15","v":0},{"$f":"SUM(E22:F22)","v":90860},0,0,{"$f":"SUM(H22:I22)","v":0},{"$f":"SUM(B22,H22)","v":97000},{"$f":"SUM(C22,I22)","v":0},{"$f":"SUM(K22:L22)","v":97000}]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":0},{"$f":"'INVOICE 1'!C16","v":25364},25364,{"$f":"'INVOICE 2'!K16","v":0},{"$f":"'INVOICE 2'!L16","v":25364},25364,0,0,0,0,25364,25364]
["Professional Services",{"$f":"'INVOICE 1'!B17","v":0},{"$f":"'INVOICE 1'!C17","v":224637},224637,{"$f":"'INVOICE 2'!K17","v":0},{"$f":"'INVOICE 2'!L17","v":224637},224637,0,0,0,0,224637,224637]
["NGO Subcontracts",{"$f":"'INVOICE 1'!B18","v":900000},{"$f":"'INVOICE 1'!C18","v":0},900000,{"$f":"'INVOICE 2'!K18","v":809863},{"$f":"'INVOICE 2'!L18","v":0},809863,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":0},{"$f":"'INVOICE 1'!C21","v":0},0,{"$f":"'INVOICE 2'!K21","v":0},{"$f":"'INVOICE 2'!L21","v":0},0,0,0,0,0,0,0]
["Other",{"$f":"'INVOICE 1'!B22","v":3000},{"$f":"'INVOICE 1'!C22","v":0},3000,{"$f":"'INVOICE 2'!K22","v":1396},{"$f":"'INVOICE 2'!L22","v":0},1396,0,0,0,3000,0,3000]
["Indirect Costs",{"$f":"'INVOICE 1'!B23","v":0},{"$f":"'INVOICE 1'!C23","v":0},0,{"$f":"'INVOICE 2'!K23","v":0},{"$f":"'INVOICE 2'!L23","v":0},0,0,0,0,0,0,0]
["TOTAL",{"$f":"SUM(B22:B30)","v":1000000},250001,1250001,902119,250001,1152120,0,0,0,1000000,250001,1250001]
[]
["Project Income",null,"Income reported to date",0,null,"Prior allocated income",0,"Allocating",0,null,null,"Unallocated income balance",{"$f":"D33-I33","v":0}]
[]
["JUSTIFICATION FOR MODIFICATION:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PERSON PREPARING REPORT",null,null,null,null,null,null,null,"AUTHORIZED FINANCIAL OFFICER"]
[null,null,null,null,null,null,null,null,"I hereby certify that I am the authorized financial officer of the herein named agency. I further certify that I have not violated any of the provisions of Section 1090 of the Government Code in incurring the expenditures reported in this invoice, nor in any other way; that Sections 1090 through 1096 of the Government Code will not be violated in any way in the expenditure of funds pursuant to this invoice; that statement of funds above is true, correct, and in accordance with program provisions in all respects; and that all expenditures submitted after the expiration date of this contract are for the purpose of substantiating obligations legally incurred during the contract period.  Furthermore, by submitting this invoice, I acknowledge that it must adhere to all of the requirements in the BSCC Grant Administration Guide, including any updates to the Guide during the term of the grant agreement."]
[]
["Name, Title"]
[]
["Phone"]
[]
["Email"]
[]
["Date"]
[]
[]
[null,null,null,null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,null,"Approved By:",null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"Project Budget NARRATIVE","index":20,"n_rows":164,"n_cols":8,"rows_kept":164,"cut":false,"hidden":false,"merged":[[164,0,164,7],[158,0,158,4],[161,0,162,7],[27,0,27,7],[44,0,44,7],[45,0,45,7],[65,0,65,7],[66,0,66,7],[106,0,106,7],[107,0,107,7],[145,0,145,4],[148,0,150,7],[154,0,154,7],[155,0,155,4],[156,0,156,3],[157,0,157,3],[151,0,151,7],[152,0,152,7],[144,0,144,1],[144,2,144,4],[134,0,134,4],[137,0,138,7],[142,0,142,7],[143,0,143,1],[143,2,143,4],[139,0,139,7],[140,0,140,7],[163,0,163,7],[123,0,123,4],[126,0,127,7],[131,0,131,7],[132,0,132,4],[133,0,133,4],[128,0,128,7],[129,0,129,7],[120,0,120,7],[121,0,121,4],[122,0,122,4],[112,0,112,4],[115,0,116,7],[117,0,117,7],[118,0,118,7],[110,2,110,4],[111,0,111,1],[111,2,111,4],[83,0,83,4],[85,0,85,7],[86,0,105,7],[109,0,109,7],[79,2,79,4],[80,2,80,4],[81,2,81,4],[82,2,82,4],[76,0,76,1],[76,2,76,4],[77,0,77,1],[77,2,77,4],[78,0,78,1],[78,2,78,4],[72,2,72,4],[73,2,73,4],[74,0,74,1],[74,2,74,4],[75,0,75,1],[75,2,75,4],[68,0,68,7],[69,0,69,1],[69,2,69,4],[70,0,70,1],[70,2,70,4],[71,0,71,1],[71,2,71,4],[52,0,52,4],[55,0,64,7],[50,2,50,4],[51,0,51,1],[51,2,51,4],[37,0,37,4],[39,0,39,2],[40,0,43,7],[47,0,47,7],[48,2,48,4],[49,2,49,4],[19,0,19,1],[19,2,19,4],[11,0,11,4],[12,0,12,4],[14,0,14,4],[17,0,17,7],[18,0,18,1],[18,2,18,4],[36,0,36,1],[36,2,36,4],[20,0,20,4],[23,0,26,7],[33,0,33,7],[34,0,34,1],[34,2,34,4],[35,0,35,1],[35,2,35,4],[28,0,31,7],[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]]}
[]
["Youth Reinvestment Grant - Project Budget and Budget Narrative (UPDATED 6.18.19)"]
["Name of County or City:",null,null,"City of Costa Mesa"]
["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":"F21","v":97000},{"$f":"G21","v":0},{"$f":"H21","v":97000}]
["2. Services and Supplies",null,null,null,null,{"$f":"F38","v":0},{"$f":"G38","v":25364},{"$f":"H38","v":25364}]
["3. Professional Services",null,null,null,null,{"$f":"F53","v":0},{"$f":"G53","v":224637},{"$f":"H53","v":224637}]
["4. Non-Governmental Organization (NGO) Subcontracts",null,null,null,null,{"$f":"F84","v":900000},{"$f":"G84","v":0},{"$f":"H84","v":900000}]
["5. Equipment/Fixed Assets",null,null,null,null,{"$f":"F113","v":0},{"$f":"G113","v":0},{"$f":"H113","v":0}]
["6. Data Collection ",null,null,null,null,{"$f":"F124","v":0},{"$f":"G124","v":0},{"$f":"H124","v":0}]
["7. Project Evaluation",null,null,null,null,{"$f":"F135","v":0},{"$f":"G135","v":0},{"$f":"H135","v":0}]
["8. Other (Travel, Training, etc.)",null,null,null,null,{"$f":"F146","v":3000},{"$f":"G146","v":0},{"$f":"H146","v":3000}]
["9. Indirect Costs",null,null,null,null,{"$f":"F159","v":0},{"$f":"G159","v":0},{"$f":"H159","v":0}]
["TOTAL",null,null,null,null,{"$f":"SUM(F6:F14)","v":1000000},{"$f":"SUM(G6:G14)","v":250001},{"$f":"SUM(F15:G15)","v":1250001}]
["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"]
["TBA, Officer/ Project Coordinator",null,"$54.09/hour x 600.20 hours = $32,465  benefits @ 198.7820%: $ = $64,535",null,null,97000,null,{"$f":"SUM(F20:G20)","v":97000}]
["TOTAL",null,null,null,null,{"$f":"SUM(F20:F20)","v":97000},{"$f":"SUM(G20:G20)","v":0},97000]
[]
["Salaries and Benefits"]
["Salary: Staff salary and benefits are budgeted at an hourly rate of $54.09 plus benefits at 198.7820%. The salary rate is based on the entry level salary rate, and the benefits are based on the maximum allowable benefits for this position. Costa Mesa Officer  will be assigned as the Project Coordinator to assist with start-up of the program and provide oversight and management of the proposed Juvenile Diversion Program.  "]
[]
[]
[]
["MOD 1  APPROVAL DATE: 3/19/21 "]
["The agreement indicates a Police Officer (salary at $54.09 per hour, working 13.75 hours per month for 12 months with benefits at 198.79%) to coordinate the grant. Since this is the first year implementation, a Police Lieutenant (salary at $79.07 per hour, working 23.5  hours per month for 12 months with benefits at 109.86%) has been overseeing the program to ensure compliance with grant requirements. The City will make sure the annual total cost not exceed total budgeted salaries and benefits of the contract."]
[]
[]
[]
[]
["2. Services and Supplies"]
["Description of Services or Supplies",null,"Calculation for Expenditure",null,null,"Grant Funds","Match Funds","Total"]
["Rental Space at Costa Mesa Police Department",null,"180 sqf. x $2.7955 (average cost) per sq. x 44 mos ",null,null,null,{"$f":"+ROUND(180*2.7955*44,0)","v":22140},{"$f":"SUM(F36:G36)","v":22140}]
["Office Supplies",null,"$73.27 x 44 mos",null,null,null,{"$f":"+ROUND(73.27*44,0)","v":3224},{"$f":"SUM(F37:G37)","v":3224}]
["TOTAL",null,null,null,null,{"$f":"SUM(F36:F37)","v":0},{"$f":"SUM(G36:G37)","v":25364},{"$f":"SUM(F38:G38)","v":25364}]
[]
["Services and Supplies Narrative: "]
["Rental Space: In-Kind Match of space for Waymakers Restorative Justice Team to provide Diversion Services on site at the Costa Mesa Police Department.                 Office Supplies: In-Kind Match for items necessary for the start-up of the program and daily operation of the program such as printer toner cartridges, paper, pens, binder, tabs and other office expenses for the program staff. "]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["3. Professional Services"]
["Description of Professional Service(s)",null,"Calculation for Expenditure",null,null,"Grant Funds ","Match Funds","Total"]
["Peer Court (Grants and Fees)",null," Grants/ Contributions: $27,500 + Fees (paid by some school district): $29,333",null,null,null,56833,{"$f":"SUM(F50:G50)","v":56833}]
["Volunteer Attorney Time",null,"41 Attorneys X $300 per hour X 7.3333 hours per volunteer",null,null,null,90200,90200]
["Diversion Support for bilingual services",null,"$1,763.73 per month X 44 months",null,null,null,77604,77604]
["TOTAL",null,null,null,null,{"$f":"SUM(F50:F52)","v":0},{"$f":"SUM(G50:G52)","v":224637},224637]
[]
["Professional Services Narrative"]
["The proposed budget amount  for Peer Court in the amount of $56,833 represents the estimated cost for CRF to manage and implement thirty-three (33) Peer Court sessions per year during the first three FY's of the contract, and (22) twenty- two Peer Court Session during the last FY of the contract at seventeen (17) participating junior high and high schools throughout Orange County each FY, and four (4) Peer Court Sessions at the Central Justice Center in Santa Ana, each FY.                                                                                                                                                                                                              Volunteer Attorney Time: $90,200: the in kind donations represent the estimated hourly rate for volunteer attorneys to advise at thirty three (33) Peer Court Sessions per year during the first three FY's of the contract and  twenty two (22) Peer Court Sessions during the last FY of the contract at seventeen (17) partcipating junior high and high schools throughout Orange County each FY, and four (4) Peer Court sessions at the Central Justice Center in Santa Ana , each FY. This is based on the average number of volunteer attorneys in the past years, each donating two (2) hours of time per session with an average billing rate of $300 per hour.                                                                                                                                                                                                                           Waymakers Juvenile Diversion: $77,604 currently has diversion contracts with 3 cities within Central Orange County.  Resources will be leveraged to provide additional support and service to participants served in the proposal. Support and service include supervisory oversight, group therapy, psycho-educational groups, career and education support, Peer Court advocacy, and translation as needed."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["4. Non-Governmental Organizations (NGO) Subcontracts"]
["Description of Subcontract",null,"Calculation for Expenditure",null,null,"Grant Funds","Match Funds","Total"]
["Diversion Supervisor: 0.40 FTE, TBA",null,"$4,244.715 ( average) X 44 mos. X 0.40 FTE=$74,707 + benefits @ 32.275%: = $24,112",null,null,{"$f":"74707+24112","v":98819},null,{"$f":"SUM(F71:G71)","v":98819}]
["Licensed Clinical Supervisor: 0.50 FTE, TBA",null,"$5,648 ( average) X 43 mos. X 0.50 FTE=$121,432 + benefits @ 23.422%: = $28,442",null,null,{"$f":"121432+28442","v":149874},null,149874]
["Counselor: 1.0 FTE, TBA",null,"$4,339.55 ( average) X 44 mos. X 1.00 FTE=$190,940 + benefits @ 27.355%: = $52,232",null,null,{"$f":"190940+52232","v":243172},null,243172]
["Diversion Specialist: 1.0 FTE, TBA",null,"$3,457.25 ( average) X 44 mos. X 1.00 FTE=$152,119 + benefits @ 28.322%: = $43,083",null,null,{"$f":"152119+43083","v":195202},null,195202]
["Mediator/ Case Coordinator, 0.15 FTE, Jessica Mendez",null,"$3,810.15 ( average) X 44 mos. X 0.15 FTE=$25,147 + benefits @ 27.801%: = $6,991",null,null,{"$f":"25147+6991","v":32138},null,32138]
["Startup",null,"3 Laptops X $1,200 each; 3 Printers X $400 each; Travel: $983.61 per FTE X 3.05 FTE's",null,null,{"$f":"3600+1200+3000","v":7800},null,7800]
["Training for Evidence Based Practices",null,"$3,270.49 per FTE X 3.05 FTE's",null,null,{"$f":"+ROUND(3270.49*3.05,0)","v":9975},null,9975]
["Office/ Supplies Expenses",null,"$156.02 per month X 44 mos.",null,null,{"$f":"ROUND(156.02*44,0)","v":6865},null,6865]
["Travel (Mileages)",null,"$218.96 miles per mo. X 44 mos. X $0.58 per mile",null,null,{"$f":"+ROUND(218.96*44*0.58,0)","v":5588},null,{"$f":"SUM(F79:G79)","v":5588}]
["Liability Insurance",null,"$97.318 per month X 44 months",null,null,4282,null,4282]
["Subcontract: Constitutional Rights Foundation Peer Court",null,"$1,576.455 per month X 44 months",null,null,69364,null,69364]
["Evaluation",null,null,null,null,5000,null,5000]
["Indirect Cost",null,"10% of Total Salaries and Benefits: $719,205 X 10%= $71,921",null,null,71921,null,71921]
["TOTALS",null,null,null,null,{"$f":"SUM(F71:F83)","v":900000},{"$f":"SUM(G71:G83)","v":0},900000]
[]
["Non-Governmental Organizations (NGO) Subcontracts Narrative"]
["The NGO budget of $900,000  is based on a Program structure of 3.05 FTE and includes: Diversion Supervisor: 0.40 FTE, Licensed Clinical Supervisor: 0.50 FTE, Counselor: 1.0 FTE, Diversion Specialist 1.0 FTE and Mediator 0.15 FTE. The NGO salaries are based on the anticipated salary rates for the above mentioned positions during the year contract. The Licensed Clinical Supervisor is anticipated to work during the first year for approximately 11 months. The total proposed salary cost  is $564,345.                                                                                                                                                                                                                                     The Benefits are calculated for each employee based on their individual circumstances. Overall, the total anticipated benefit cost for the NGO is $154,860, or approximately  27.44% of total salaries. The benefits are provided to the staff in accordance with both state and federal requirements, and the Waymakers Employee Benefit Program. The key components are as follows: Social Security/Medicare (7.65% of salary), Worker's Compensation Insurance (0.55% of salary), State Unemployment Insurance is budgeted at 4.5% of the first $7,000 of each employee's annual salary, retirement plan (4% of salaries for eligible employees), Group Insurance benefits including: medical, dental, vision, life insurance and long term disability insurance are provided to eligible employees, paid leave payout (1% of total salaries). Paid Leave includes: vacation, sick leave and personal leave.                                                                                                                                                                                                                                                    The Services and Supply costs are based on estimated costs needed for the operation of the proposed program.  They are based on historical costs incurred in similar projects, adjusted for inflation and other known or anticipated changes.  Start-up cost: $7,800 and includes: 3 laptops ($3,600), 3 printers ($1,200) and Travel ($3,000). The laptops and the printers wil be used by the staff to complete the daily tasks.  Training for Evidenced Based Practices: $9,975: Functional Family Therapy, is a family-based prevention and intervention program for at-risk youths ages 11 to 18. The treatment group had lower recidivism rates. The effective rated program had a positive effect on youth by reducing risky behavior, increasing strengths, and by improving functioning across key life domains.  The benefits of this program, which included benefits to both crime victims and taxpayers, were calculated to be $36,241 per youth. Office Supplies/Expenses: $6,865. These funds will be used for items necessary for the daily operation of the program. Travel/Mileages: $5,588 for mileage reimbursement to program staff for attending meetings and other program activities that involve the use of a personal vehicle based on the IRS rate of $0.58 per mile. Liability Insurance: $4,282. These funds will cover an allocated portion of the Agency’s overall cost for General and Professional Liability Insurance including Owned and Non-Owned Automobile Insurance, Directors and Officers Insurance including Errors and Omissions insurance, Fidelity Bond, and Property Insurance. Sexual misconduct insurance is included as part of the general liability insurance. This allocation is based on this program’s proposed FTEs in proportion to the total agency’s FTEs.                                                                                                                                                                                      Subcontract: Constitutional Rights Foundation Peer Court: $69,364 (CRF-OC) assists with providing Peer Court services to students and qualified youth referred from law enforcement agencies under contract with Waymakers for Juvenile Diversion Services. Peer Court is organized by the Constitutional Rights Foundation Orange County, a non-profit organization dedicated to promoting civic literacy and youth leadership. CRF will coordinate and communicate with school sites, judicial officers, attorney volunteers, and Waymakers regarding Peer Court session schedules and logistics.                                                                                                                                                                                                                    Evaluator: $5,000 California State University Fullerton Social Science Resource Center will provide evaluation service and support to Waymakers Juvenile Diversion Program to identify whether the program is successful in terms of achieving its goals and objectives. The Social Science Research Center provides research services to campus and community organizations. As a university-based center, the SSRC is fundamentally concerned with providing high-quality research services utilizing state-of-the-art hardware, software and methodology. The Center assists non-profit and tax-supported agencies and organizations to conduct methodologically sound studies to answer policy-relevant research questions. The motto of the Center is, \"Applied Research in the Public Interest.\"                                                                                                                         Indirect costs: $71,921 are budgeted based on 10% of total direct program salaries and benefits, and include the following administrative costs needed to support the program: salaries, benefits, office supplies/expenses, rent, etc. \n                                                                             "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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,null,null,{"$f":"SUM(F112:G112)","v":0}]
["TOTALS",null,null,null,null,{"$f":"SUM(F112:F112)","v":0},{"$f":"SUM(G112:G112)","v":0},0]
[]
["Equipment/Fixed Assets Narrative "]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["6. Data Collection"]
["Description",null,null,null,null,"Grant Funds","Match Funds","Total"]
[null,null,null,null,null,null,null,{"$f":"SUM(F123:G123)","v":0}]
["TOTAL",null,null,null,null,{"$f":"SUM(F123:F123)","v":0},{"$f":"SUM(G123:G123)","v":0},{"$f":"SUM(F124:G124)","v":0}]
[]
["Data  Collection"]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["7. Project Evaluation"]
["Description",null,null,null,null,"Grant Funds","Match Funds","Total"]
[null,null,null,null,null,null,null,{"$f":"SUM(F134:G134)","v":0}]
["TOTAL",null,null,null,null,{"$f":"SUM(F134:F134)","v":0},{"$f":"SUM(G134:G134)","v":0},{"$f":"SUM(F135:G135)","v":0}]
[]
["Project Evaluation Narrative:"]
[]
[]
["MOD x  APPROVAL DATE:  "]
[]
[]
["8. Other (Travel, Training, etc.)"]
["Description",null,"Calculation for Expense",null,null,"Grant Funds","Match Funds","Total"]
["BSCC Grant Travel",null,null,null,null,3000,null,{"$f":"SUM(F145:G145)","v":3000}]
["TOTAL",null,null,null,null,{"$f":"SUM(F145:F145)","v":3000},{"$f":"SUM(G145:G145)","v":0},3000]
[]
["Other (Travel, Training, etc.) Narrative:"]
["$3,000 is budgeted in Year one for per diem travel for airline travel, hotel accomodation, food for a BSCC Grantee Orientation to be educated on how to maintain compliance with BSCC Youth Reinvestment Grant program reporting requirements."]
[]
[]
["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(F21)*10%","v":9700},null,null,{"$f":"SUM(F157:G157)","v":0}]
["2. Indirect costs will be charged as 5% of direct total direct project costs (excluding equipment) not to exceed:",null,null,null,{"$f":"SUM(F21,F38,F53,F84,F124,F135,F146,)*5%","v":50000},null,null,{"$f":"SUM(F158:G158)","v":0}]
["If the amount entered turns red, adjust it to not exceed the maximum noted above: TOTAL",null,null,null,null,{"$f":"SUM(F157:F158)","v":0},{"$f":"SUM(G157:G158)","v":0},{"$f":"SUM(H157:H158)","v":0}]
[]
["Indirect Costs Narrative:"]
[]
[]
["MOD x  APPROVAL DATE:  "]

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

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