{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["1st Advance Payment","Bud. Mod. 1","INVOICE 1","INVOICE 2","INVOICE 3","INVOICE 4","2nd Advance Payment","Year 2 Augment Budget","INVOICE 5","INVOICE 6","INVOICE 7","INVOICE 8","3rd Advance Payment","INVOICE 9","INVOICE 10","INVOICE 11","INVOICE 12","MODIFICATION REQUEST","Project Budget NARRATIVE","INVOICE DUE DATES ","INSTRUCTIONS "],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":22,"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],[12,2,12,3]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5229"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,"Purchase Order:",null,"5227-0000003918"]
["Advance Payment Invoice: BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:","Public Defense Pilot Program Grant",null,null,null,null,"Grantee:","County of Fresno"]
[]
[null,"Contract #:","BSCC 323-21",null,null,null,null,"Address","2281 Tulare Street, Room 304"]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:","2022-03-01","TO","2025-03-01",null,null,null,"Fresno, CA 93721"]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #","1 PDPP 21 - ADV PMT",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 #","2022-05-23"]
[]
[]
["Advance Payment Invoice"]
[null,null,null,null,null,null,null,null,null,"Total Grant Award:",1204165]
[null,null,null,null,null,null,null,null,null,"Advance Total:",1204165]
[null,null,null,null,null,null,null,null,null,"Grant Award Balance:",0]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,"Approved By:","Dameion Renault, 5/24/2022",null,null,null,null,null,null,"BSCC Supplier Data "]
[null,null,"BSCC Field Representative",null,null,null,null,null,{"$f":"'[1]INVOICE 12'!L54","v":"COUNTYOFFR-006"}]
[null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,"Date:","2022-05-24",null,null,null,null,null,{"$f":"'[1]INVOICE 12'!L52","v":"00000014996"}]
[null,null,null,null,null,null,null,null,null,"Supplier Number"]

{"sheet":"Bud. Mod. 1","index":1,"n_rows":75,"n_cols":13,"rows_kept":75,"cut":false,"hidden":false,"merged":[[73,0,73,1],[73,8,73,10],[74,8,74,10],[74,15,74,16],[61,0,61,2],[62,0,62,2],[63,0,63,2],[65,8,65,12],[67,8,67,12],[68,8,68,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],[60,0,60,2],[69,8,69,12],[70,8,70,12],[33,0,33,12],[34,0,34,12],[35,0,52,12],[54,0,54,2],[54,8,54,12],[21,0,22,0],[21,1,21,3],[21,4,21,6],[21,7,21,9],[21,10,21,12],[0,5,2,7],[7,1,7,3],[7,5,7,7],[7,9,7,11],[9,0,9,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"STATE OF CALIFORNIA"]
["MODIFICATION REQUEST - (FORM BSCC 223.1 (Revised 1/23)",null,null,null,null,null,null,null,null,null,null,null,"BOARD OF STATE AND COMMUNITY CORRECTIONS"]
[]
[]
["Please mark an \"X\" in the green cell to indicate which type of budget modification you want to select."]
[]
["X","Line-Item Change",null,null,null,"Budget Modification",null,null,null,"Project Income Allocation"]
[null,"Select this option if you are modifying narrative details within a line item (or line items) but not changing the budget.",null,null,null,"Select ths option if you are modifying line-item dollar amounts by moving funds from one line-item to another.",null,null,null,"Select this option 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":"'[1]INVOICE 12'!B7","v":"County of Fresno"},null,null,null,null,null,null,"Program:",{"$f":"'[1]INVOICE 1'!B5","v":"Public Defense Pilot Program"}]
[]
["Address",{"$f":"'[1]INVOICE 1'!L56","v":"2281 Tulare Street, Room 304"},null,null,null,null,null,null,"Project Title:"]
[]
[null,{"$f":"'[1]INVOICE 1'!L58","v":"Fresno, CA 93721"}]
[]
["Contract #:",{"$f":"'[1]INVOICE 12'!B9","v":"BSCC 323-21"},null,null,null,null,null,null,null,"Modification Request #",1]
[]
["Term:",{"$f":"'[1]INVOICE 1'!E9","v":"2022-03-01"},{"$f":"'[1]INVOICE 1'!F9","v":"TO"},{"$f":"'[1]INVOICE 1'!G9","v":"2025-03-01"},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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",959060,0,959060,959060,0,959060,null,0,0,959060,0,959060]
["Services & Supplies",17470.38,0,17470.38,17470.38,0,17470.38,null,0,0,17470.38,0,17470.38]
["Professional Services or Public Agency Subcontracts",126282.28,0,126282.28,126282.28,0,126282.28,0,0,0,126282.28,0,126282.28]
["NGO Subcontracts",0,0,0,0,0,0,0,0,0,0,0,0]
["Equipment / Fixed Assets",0,0,0,0,0,0,0,0,0,0,0,0]
["Other (Travel, Training, etc.)",3200,0,3200,3200,0,3200,0,0,0,3200,0,3200]
["Indirect Costs",98152.34,0,98152.34,98152.34,0,98152.34,0,0,0,98152.34,0,98152.34]
["TOTAL",1204165,0,1204165,{"$f":"SUM(E24:E30)","v":1204165},0,{"$f":"SUM(G24:G30)","v":1204165},0,0,0,1204165,0,1204165]
[]
["Project Income",null,"Income reported to date",{"$f":"'[1]INVOICE 12'!D25","v":0},null,"Prior allocated income",{"$f":"'[1]INVOICE 12'!G25","v":0},"Allocating",{"$f":"I31","v":0},null,null,"Unallocated income balance",{"$f":"D33-I33","v":0}]
[]
["JUSTIFICATION FOR MODIFICATION:"]
["The Public Defender requests to modify 1a. Salaries and Benefits Name and Title regarding the Defense Attorney positions. Previously the positions were budgeted for  (2) Defense Attorney IV and (1) Defense Attorney III. After several months of active recruiting, the Public Defender was unable to hire any new employees and has reassigned existing staff into the grant positions. The existing attorneys with the requisite knowledge to best address the given statutes are (2) Senior Defense Attorney and (1) Defense Attorney III that is eligible for promotion to Defense Attorney IV in January 2023. We request a modification to the original budget to list 3 FTE Defense Attorneys, given that the budgeted amounts are unchanged. Due to the length of vacancies, additional funding is not needed to account for the higher salaries.  Please make all requested modifications effective beginning on Invoice #1.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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."]
["Salvador Espino, Senior Administrative Analyst"]
["Name, Title"]
["559-600-1228"]
["Phone"]
["sespino@fresnocountyca.gov"]
["Email"]
["2022-12-23"]
["Date"]
[]
[null,null,null,null,null,null,null,null,"Greg Reinke, Assistant County Administrative Officer"]
[null,null,null,null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,null,null,null,"559-600-1225"]
[null,null,null,null,null,null,null,null,"Phone"]
[null,null,null,null,null,null,null,null,"2022-12-23"]
[null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2022-12-23",null,null,null,null,"Approved By:","Dameion Renault",null,null,"Date:","2023-01-12"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 1","index":2,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[35,11,35,13],[36,11,36,13],[37,11,37,13],[62,4,62,9],[46,4,46,9],[48,11,48,13],[46,11,46,13],[56,11,56,13],[45,3,45,13],[51,11,51,13],[60,4,60,9],[40,11,40,13],[43,3,43,10],[4,10,6,13],[12,13,13,13],[30,11,30,13],[31,11,31,13],[32,11,32,13],[31,3,31,10],[32,3,32,10],[12,10,12,12],[8,12,8,13],[62,0,62,2],[62,10,62,12],[44,3,44,10],[61,4,61,9],[58,4,58,9],[61,10,61,12],[59,4,59,9],[53,11,53,13],[57,11,57,13],[47,4,56,9],[57,4,57,9],[50,11,50,13],[52,11,52,13],[54,11,54,13],[55,11,55,13],[49,11,49,13],[50,0,50,2],[52,0,52,2],[51,0,51,2],[53,0,53,2],[49,0,49,2],[54,0,54,2],[55,0,55,2],[33,11,33,13],[34,11,34,13],[47,0,47,2],[46,0,46,2],[41,3,41,10],[42,3,42,10],[33,0,34,0],[41,11,41,13],[42,11,42,13],[43,11,43,13],[44,11,44,13],[38,11,38,13],[39,11,39,13],[48,0,48,2],[35,0,36,0],[37,0,38,0],[41,0,42,0],[31,0,32,0],[36,3,36,10],[33,3,33,10],[34,3,34,10],[0,5,2,7],[45,0,45,1],[37,3,37,10],[38,3,38,10],[39,3,39,10],[12,0,13,0],[12,1,12,3],[12,4,12,6],[24,0,24,12],[30,3,30,10],[29,0,29,2],[40,3,40,10],[35,3,35,10],[12,7,12,9],[39,0,40,0],[43,0,44,0],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[67,0,67,7],[67,8,67,11],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,"5227-0000003918"]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:","Public Defense Pilot Program",null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:","County of Fresno",null,null,null,"Project Title:"]
[]
["Contract #:","BSCC 323-21",null,"Term:","2022-03-01","TO","2025-03-01",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","1 PDPP 21",null,"Reporting Period:","2022-03-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",959060,0,{"$f":"SUM(B15:C15)","v":959060},null,0,{"$f":"SUM(E15:F15)","v":0},27220,0,{"$f":"SUM(H15:I15)","v":27220},{"$f":"B15-E15-H15","v":931840},{"$f":"C15-F15-I15","v":0},{"$f":"SUM(K15:L15)","v":931840},"1st Advance \n5/23/2022"]
["Services & Supplies",17470.38,0,17470.38,0,0,{"$f":"SUM(E16:F16)","v":0},0,0,0,17470.38,0,17470.38,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",126282.28,0,126282.28,0,0,{"$f":"SUM(E17:F17)","v":0},0,0,0,126282.28,0,126282.28]
["NGO Subcontracts",0,0,0,0,0,0,0,0,0,0,0,0]
["Equipment / Fixed Assets",0,0,0,0,0,0,0,0,0,0,0,0]
["Other",3200,0,{"$f":"SUM(B20:C20)","v":3200},0,0,0,0,0,0,3200,0,3200]
["Indirect Costs",98152.34,0,98152.34,0,0,0,2722,0,2722,95430.34,0,95430.34]
["TOTAL",{"$f":"SUM(B15:B21)","v":1204165},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":1204165},{"$f":"SUM(E15:E21)","v":0},0,0,29942,{"$f":"SUM(I15:I21)","v":0},29942,1174223,0,1174223,{"$f":"SUM(N16+N19+N20)","v":1204165}]
[]
["Project Income",null,"Income reported to date",0,null,"Prior allocated income",0,"This Period",null,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[0]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":29942},null,null,"Grant funds claimed this period:",{"$f":"H22","v":29942},null,null,null,"Percentage Grant $$ expended to date:","Percentage Grant $$ expended to date:",{"$f":"E26/C22","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":27220},"Defense Attorney III FTE = $46.5625/hour x 200 hours =$9312.50+ $6402.34 benefits = $15,714.84; Senior Defense Attorney 0.2 FTE $67.2125/hr x 99 hours = $6,654.04 + $4851 benefits = $11,505.04"]
[null,"Match",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Match",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","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}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Match",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":2722},"Minimum given by grant allowance to cover indirect costs such as administrative time, office space, etc."]
[null,"Match",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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."]
["Salvador Espino, Senior Administrative Analyst",null,null,null,null,null,null,null,null,null,null,"00000014996"]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["559-600-1228",null,null,null,null,null,null,null,null,null,null,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["sespino@fresnocountyca.gov",null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2023-06-29",null,null,null,null,null,null,null,null,null,null,"Fresno, CA 93721"]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Greg Reinke, Assistant County Administrative Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"559-600-1225"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2023-06-29"]
[null,null,null,null,"Date"]
[null,null,null,null,"Certified in old invoice workbook","Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2023-06-29",null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"INVOICE 2","index":3,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11],[67,0,67,7],[67,8,67,11],[55,0,55,2],[55,11,55,13],[63,5,63,8],[56,11,56,13],[57,4,57,9],[57,11,57,13],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[45,0,45,1],[45,3,45,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[50,11,50,13],[51,0,51,2],[51,11,51,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[52,0,52,2],[52,11,52,13],[41,0,42,0],[41,3,41,10],[41,11,41,13],[42,3,42,10],[42,11,42,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[44,3,44,10],[44,11,44,13],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,13],[39,0,40,0],[39,3,39,10],[39,11,39,13],[40,3,40,10],[40,11,40,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,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,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 1'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","2 PDPP 21",null,"Reporting Period:","2022-07-01","TO","2022-09-30","Due:","2022-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 1'!B15","v":959060},{"$f":"'INVOICE 1'!C15","v":0},{"$f":"SUM(B15:C15)","v":959060},{"$f":"SUM('INVOICE 1'!E15,'INVOICE 1'!H15)","v":27220},{"$f":"SUM('INVOICE 1'!F15,'INVOICE 1'!I15)","v":0},{"$f":"SUM(E15:F15)","v":27220},63275,0,{"$f":"SUM(H15:I15)","v":63275},{"$f":"B15-E15-H15","v":868565},0,{"$f":"SUM(K15:L15)","v":868565},"1st Advance \n5/23/2022"]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":17470.38},{"$f":"'INVOICE 1'!C16","v":0},17470.38,{"$f":"SUM('INVOICE 1'!E16,'INVOICE 1'!H16)","v":0},{"$f":"SUM('INVOICE 1'!F16,'INVOICE 1'!I16)","v":0},{"$f":"SUM(E16:F16)","v":0},6729,0,6729,10741.380000000001,0,10741.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",{"$f":"'INVOICE 1'!B17","v":126282.28},{"$f":"'INVOICE 1'!C17","v":0},126282.28,{"$f":"SUM('INVOICE 1'!E17,'INVOICE 1'!H17)","v":0},{"$f":"SUM('INVOICE 1'!F17,'INVOICE 1'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},0,0,0,126282.28,0,126282.28]
["NGO Subcontracts",{"$f":"'INVOICE 1'!B18","v":0},{"$f":"'INVOICE 1'!C18","v":0},0,{"$f":"SUM('INVOICE 1'!E18,'INVOICE 1'!H18)","v":0},{"$f":"SUM('INVOICE 1'!F18,'INVOICE 1'!I18)","v":0},0,0,0,0,0,0,0]
["Equipment / Fixed Assets",{"$f":"'INVOICE 1'!B19","v":0},{"$f":"'INVOICE 1'!C19","v":0},0,{"$f":"SUM('INVOICE 1'!E19,'INVOICE 1'!H19)","v":0},{"$f":"SUM('INVOICE 1'!F19,'INVOICE 1'!I19)","v":0},0,0,0,0,0,0,0]
["Other",{"$f":"'INVOICE 1'!B20","v":3200},{"$f":"'INVOICE 1'!C20","v":0},{"$f":"SUM(B20:C20)","v":3200},{"$f":"SUM('INVOICE 1'!E20,'INVOICE 1'!H20)","v":0},{"$f":"SUM('INVOICE 1'!F20,'INVOICE 1'!I20)","v":0},0,0,0,0,3200,0,3200]
["Indirect Costs",{"$f":"'INVOICE 1'!B21","v":98152.34},{"$f":"'INVOICE 1'!C21","v":0},98152.34,{"$f":"SUM('INVOICE 1'!E21,'INVOICE 1'!H21)","v":2722},{"$f":"SUM('INVOICE 1'!F21,'INVOICE 1'!I21)","v":0},2722,7000,0,7000,88430.34,0,88430.34]
["TOTAL",{"$f":"SUM(B15:B21)","v":1204165},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":1204165},{"$f":"SUM(E15:E21)","v":29942},0,29942,77004,{"$f":"SUM(I15:I21)","v":0},77004,1097219,0,1097219,{"$f":"SUM(N16+N19+N20)","v":1204165}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":106946},null,null,"Grant funds claimed this period:",{"$f":"H22","v":77004},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":1097219},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":8.8813410122366945E-2}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":63275},"Defense Attorney III FTE $49.4309/hour x 472 hours =$23,331.4 + $15080.32 benefits= $38,411.72; Senior Defense Attorney 0.4 FTE $68.4625/hr x 193 hours = $13213.27+ $9198.17 benefits = $22,411.44; Senior Defense Attorney $76.9175/hr x 14.3 hours = $1099.92 + $834.22 benefits = $1,934.14; Defense Investigator II  $37.75/hr x 7.4 hours = $279.35 + $238.64 benefits = $517.99"]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":6729},"3 Dell Laptops, 1 Surface Pro Tablet"]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":7000},"Minimum given by grant allowance to cover indirect costs such as administrative time, office space, etc."]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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."]
["Salvador Espino, Senior Administrative Analyst",null,null,null,null,null,null,null,null,null,null,"00000014996"]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["559-600-1228",null,null,null,null,null,null,null,null,null,null,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["sespino@fresnocountyca.gov",null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2022-12-23",null,null,null,null,null,null,null,null,null,null,"Fresno, CA 93721"]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Greg Reinke, Assistant County Administrative Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"559-600-1225"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2022-12-23"]
[null,null,null,null,"Date"]
[null,null,null,null,"Certified in old invoice workbook","Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2022-12-23",null,null,null,"Approved By:",null,"Dameion Renault"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"INVOICE 3","index":4,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[44,3,44,10],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[44,11,44,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[45,0,45,1],[45,3,45,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[57,4,57,9],[57,11,57,13],[50,11,50,13],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,11,56,13],[67,0,67,7],[67,8,67,11],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 2'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","3 PDPP 21",null,"Reporting Period:","2022-10-01","TO","2022-12-31","Due:","2023-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 2'!B15","v":959060},{"$f":"'INVOICE 2'!C15","v":0},{"$f":"SUM(B15:C15)","v":959060},{"$f":"SUM('INVOICE 2'!E15,'INVOICE 2'!H15)","v":90495},{"$f":"SUM('INVOICE 2'!F15,'INVOICE 2'!I15)","v":0},{"$f":"SUM(E15:F15)","v":90495},112839,0,{"$f":"SUM(H15:I15)","v":112839},{"$f":"B15-E15-H15","v":755726},0,{"$f":"SUM(K15:L15)","v":755726},"1st Advance \n5/23/2022"]
["Services & Supplies",{"$f":"'INVOICE 2'!B16","v":17470.38},{"$f":"'INVOICE 2'!C16","v":0},17470.38,{"$f":"SUM('INVOICE 2'!E16,'INVOICE 2'!H16)","v":6729},{"$f":"SUM('INVOICE 2'!F16,'INVOICE 2'!I16)","v":0},{"$f":"SUM(E16:F16)","v":6729},null,0,0,10741.380000000001,0,10741.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",{"$f":"'INVOICE 2'!B17","v":126282.28},{"$f":"'INVOICE 2'!C17","v":0},126282.28,{"$f":"SUM('INVOICE 2'!E17,'INVOICE 2'!H17)","v":0},{"$f":"SUM('INVOICE 2'!F17,'INVOICE 2'!I17)","v":0},{"$f":"SUM(E17:F17)","v":0},32210.57,0,32210.57,94071.709999999992,0,94071.709999999992]
["NGO Subcontracts",{"$f":"'INVOICE 2'!B18","v":0},{"$f":"'INVOICE 2'!C18","v":0},0,{"$f":"SUM('INVOICE 2'!E18,'INVOICE 2'!H18)","v":0},{"$f":"SUM('INVOICE 2'!F18,'INVOICE 2'!I18)","v":0},0,0,0,0,0,0,0]
["Equipment / Fixed Assets",{"$f":"'INVOICE 2'!B19","v":0},{"$f":"'INVOICE 2'!C19","v":0},0,{"$f":"SUM('INVOICE 2'!E19,'INVOICE 2'!H19)","v":0},{"$f":"SUM('INVOICE 2'!F19,'INVOICE 2'!I19)","v":0},0,0,0,0,0,0,0]
["Other",{"$f":"'INVOICE 2'!B20","v":3200},{"$f":"'INVOICE 2'!C20","v":0},{"$f":"SUM(B20:C20)","v":3200},{"$f":"SUM('INVOICE 2'!E20,'INVOICE 2'!H20)","v":0},{"$f":"SUM('INVOICE 2'!F20,'INVOICE 2'!I20)","v":0},0,0,0,0,3200,0,3200]
["Indirect Costs",{"$f":"'INVOICE 2'!B21","v":98152.34},{"$f":"'INVOICE 2'!C21","v":0},98152.34,{"$f":"SUM('INVOICE 2'!E21,'INVOICE 2'!H21)","v":9722},{"$f":"SUM('INVOICE 2'!F21,'INVOICE 2'!I21)","v":0},9722,11284,0,11284,77146.34,0,77146.34]
["TOTAL",{"$f":"SUM(B15:B21)","v":1204165},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":1204165},{"$f":"SUM(E15:E21)","v":106946},0,106946,156333.57,{"$f":"SUM(I15:I21)","v":0},156333.57,940885.42999999993,0,940885.42999999993,{"$f":"SUM(N16+N19+N20)","v":1204165}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":263279.57},null,null,"Grant funds claimed this period:",{"$f":"H22","v":156333.57},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":940885.42999999993},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":0.21864077597339235}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":112839},"Defense Attorney IV 34.9 hours x $54.8/hr = $1912.52 salaries + $146.31 benefits ; \nSenior Defense Attorney 262 hrs x $68.12/hr = $19085.36 salaries + $13011.92 benefits ; \nDefense Attorney III 480 hrs x 49.345/hr = $24016 salaries + $15516.25 benefits ; \nParalegal 320 hrs x $25.45 = $8144 salaries + $ 5070.16 benefits ; \nSenior Defense Attorney 3.7 hrs x $71.7/hr = $284.59 salries + $215.84 benefits ; \nSenior Defense Attorney 182 hrs x $14617.73 salaries + $10436.22 benefits ; \nDefense Social Worker 6 hrs x $33.15/hr = $198.9 salaries + $182.79 benefits. ",null,null,null,null,null,null,null,"Due to step increases and differential pay, salary rates for one employee can vary from one pay period to the next. The given hourly rate is an average during the time logged. Some amounts are off due to rounding. See attached Labor Distribution report for more detail."]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":32210.57},"Attorney 520 hours X $38.46/Hr. = $19,999.98, Paralegal 198 hours X $25/Hr. = $4,950, Attorney 62.5 hours X $60.34/Hr. = $3,771.25, Attorney 8.5 hours X $55.77/Hr. = $474.05, Attorney 5 hours X $45/Hr. = $225, Attorney 4.5 Hours X $38.46/Hr. = $173.07, Attorney 8 hours X $38.65/Hr. = $309.20, Paralegal 78 Hours X $29.59/Hr. = $2,308.02 ",null,null,null,null,null,null,null,"Duties performed include: Attoreny- Court Appearances and Heartings, Review File and offer from DDA Prepare for Hearings, Communitcate with client, Update Case Maanagment, Paralegal-Prepare all court documents for case, Pull file and prior court documents , write letters to all agencies as needed to facilate court hearings, research as needed, and assist attorney with hearing prep"]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":11284},"Minimum given by grant allowance to cover indirect costs such as administrative time, office space, etc."]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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."]
["Salvador Espino, Senior Administrative Analyst",null,null,null,null,null,null,null,null,null,null,"00000014996"]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["559-600-1228",null,null,null,null,null,null,null,null,null,null,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["sespino@fresnocountyca.gov",null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2023-02-15",null,null,null,null,null,null,null,null,null,null,"Fresno, CA 93721"]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Greg Reinke, Assistant County Administrative Officer"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"559-600-1225"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2023-02-15"]
[null,null,null,null,"Date"]
[null,null,null,null,"Certified via checkbox in old invoice workbook","Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2023-02-16",null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"INVOICE 4","index":5,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[44,3,44,10],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[44,11,44,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[45,0,45,1],[45,3,45,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[57,4,57,9],[57,11,57,13],[50,11,50,13],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,11,56,13],[67,0,67,7],[67,8,67,11],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 3'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","4 PDPP 21",null,"Reporting Period:","2023-01-01","TO","2023-03-31","Due:","2023-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 3'!B15","v":959060},{"$f":"'INVOICE 3'!C15","v":0},{"$f":"SUM(B15:C15)","v":959060},{"$f":"SUM('INVOICE 3'!E15,'INVOICE 3'!H15)","v":203334},{"$f":"SUM('INVOICE 3'!F15,'INVOICE 3'!I15)","v":0},{"$f":"SUM(E15:F15)","v":203334},169352,0,{"$f":"SUM(H15:I15)","v":169352},{"$f":"B15-E15-H15","v":586374},0,{"$f":"SUM(K15:L15)","v":586374},"1st Advance \n5/23/2022"]
["Services & Supplies",{"$f":"'INVOICE 3'!B16","v":17470.38},{"$f":"'INVOICE 3'!C16","v":0},17470.38,{"$f":"SUM('INVOICE 3'!E16,'INVOICE 3'!H16)","v":6729},{"$f":"SUM('INVOICE 3'!F16,'INVOICE 3'!I16)","v":0},{"$f":"SUM(E16:F16)","v":6729},0,0,0,10741.380000000001,0,10741.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",{"$f":"'INVOICE 3'!B17","v":126282.28},{"$f":"'INVOICE 3'!C17","v":0},126282.28,{"$f":"SUM('INVOICE 3'!E17,'INVOICE 3'!H17)","v":32210.57},{"$f":"SUM('INVOICE 3'!F17,'INVOICE 3'!I17)","v":0},{"$f":"SUM(E17:F17)","v":32210.57},35702,0,35702,58369.709999999992,0,58369.709999999992]
["NGO Subcontracts",{"$f":"'INVOICE 3'!B18","v":0},{"$f":"'INVOICE 3'!C18","v":0},0,{"$f":"SUM('INVOICE 3'!E18,'INVOICE 3'!H18)","v":0},{"$f":"SUM('INVOICE 3'!F18,'INVOICE 3'!I18)","v":0},0,0,0,0,0,0,0]
["Equipment / Fixed Assets",{"$f":"'INVOICE 3'!B19","v":0},{"$f":"'INVOICE 3'!C19","v":0},0,{"$f":"SUM('INVOICE 3'!E19,'INVOICE 3'!H19)","v":0},{"$f":"SUM('INVOICE 3'!F19,'INVOICE 3'!I19)","v":0},0,0,0,0,0,0,0]
["Other",{"$f":"'INVOICE 3'!B20","v":3200},{"$f":"'INVOICE 3'!C20","v":0},{"$f":"SUM(B20:C20)","v":3200},{"$f":"SUM('INVOICE 3'!E20,'INVOICE 3'!H20)","v":0},{"$f":"SUM('INVOICE 3'!F20,'INVOICE 3'!I20)","v":0},0,365,0,365,2835,0,2835]
["Indirect Costs",{"$f":"'INVOICE 3'!B21","v":98152.34},{"$f":"'INVOICE 3'!C21","v":0},98152.34,{"$f":"SUM('INVOICE 3'!E21,'INVOICE 3'!H21)","v":21006},{"$f":"SUM('INVOICE 3'!F21,'INVOICE 3'!I21)","v":0},21006,16935,0,16935,60211.34,0,60211.34]
["TOTAL",{"$f":"SUM(B15:B21)","v":1204165},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":1204165},{"$f":"SUM(E15:E21)","v":263279.57},0,263279.57,222354,{"$f":"SUM(I15:I21)","v":0},222354,718531.42999999993,0,718531.42999999993,{"$f":"SUM(N16+N19+N20)","v":1204165}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":485633.57},null,null,"Grant funds claimed this period:",{"$f":"H22","v":222354},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":718531.42999999993},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":0.4032948723804462}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":169352},"Senior Defense Attorney 210 hours x 70.34/hr + benefits = $27121.21; \nSenior Defense Attorney 214 hours x $ 73.85/hr + benefits = $30877.21; \nSenior Defense Attorney 34.4 hours x $73.85 + benefits =$4975.21; \nDefense Attorney IV 480 hours x $55.39/hr + benefits = $44,313.76; \nMarcus Lawson 320 hours x $31.69 + benefits = $15,763.26; \nDefense Social Worker 480 hours x $30.46/hr +benefits = $21,175.45; \nParalegal 480 hours x $25.45/hr + benefits = $22125.85"]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":35702},"Attorney 520.02 hours X $38.46/hr + Benefits = $20,117.03; Paralegal 256 hours X $25/Hr. = $6,400; Paralegal 20 hours X $23/Hr. = $460; Attorney 35 Hours X $56.25/Hr. = $1,968.75; Employer Payroll Taxes for FAC Staff (4 staff mentioned previously) = $2,623.92; Attorney 29.65 hours X $60.34/Hr. = $1,789.08; Attorney 2.75 hours X $55.55/Hr. = $153.37; Attorney 3.7 hours X $45/Hr. = $166.50; Attorney 7.5 Hours X $38.46/Hr. = $288.45; Paralegal 47 Hours X $29.59/Hr. = $1,390.73; Employer Payroll Taxes for ADO Staff (5 staff mentioned previously) = $344.72 "]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":365},"$95 California Appellate Defense Counsel membership for Defense Investigator; $125 National Public Defense Conference for Defense Social Worker; $145 National Association of Criminal Defense Lawyers"]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":16935},"Minimum given by grant allowance to cover indirect costs such as administrative time, office space, etc."]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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."]
["Salvador Espino, Principal Admin Analyst",null,null,null,null,null,null,null,null,null,null,"00000014996"]
["Name, Title",null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["559-600-1228",null,null,null,null,null,null,null,null,null,null,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["sespino@fresnocountyca.gov",null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["Email",null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2023-06-29",null,null,null,null,null,null,null,null,null,null,"Fresno, CA 93721"]
["Date",null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,"Greg Reinke, Assistant CAO"]
[null,null,null,null,"Name, Title"]
[null,null,null,null,"559-600-1225"]
[null,null,null,null,"Phone"]
[null,null,null,null,"2023-06-29"]
[null,null,null,null,"Date"]
[null,null,null,null,"GR","Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2023-06-29",null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"2nd Advance Payment","index":6,"n_rows":33,"n_cols":11,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,2,32,4],[33,2,33,4],[34,2,34,4],[27,2,27,4],[28,2,28,4],[29,2,29,4],[29,8,29,10],[31,2,31,4],[31,8,31,10],[19,10,19,11],[20,10,20,11],[21,10,21,11],[23,0,23,3],[23,6,23,10],[24,0,24,3],[24,6,24,10],[18,10,18,11],[0,5,2,7],[0,9,0,11],[1,9,1,11],[5,2,5,4],[5,8,5,11],[7,2,7,4],[7,8,7,11],[9,8,9,11],[12,2,12,3],[12,6,14,11],[14,2,14,3],[17,0,17,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,"Purchase Authority: 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,"Purchase Order: 5227-0000004405"]
["Advance Payment Invoice - Form BSCC 201A (Revised 06/2020)"]
[]
[]
[null,"Program:","Public Defense Pilot Program Grant",null,null,null,null,"Grantee:",{"$f":"'[1]INVOICE 12'!B7","v":"County of Fresno"}]
[]
[null,"Contract #:",{"$f":"'[1]INVOICE 12'!B9","v":"BSCC 323-21"},null,null,null,null,"Address",{"$f":"'[1]INVOICE 12'!L56","v":"2281 Tulare Street, Room 304"}]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:","2022-03-01","TO","2025-03-01",null,null,null,{"$f":"'[1]INVOICE 12'!L58","v":"Fresno, CA 93721"}]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #","2 PDPP 21 - ADV PMT",null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"FI$Cal Supplier Data\" section at the bottom of this invoice. "]
[]
[null,"Payment Request Date:","2023-05-31"]
[]
[]
["Advance Payment Invoice"]
[null,null,null,null,null,null,null,null,null,"Total Grant Award:",2389570.69]
[null,null,null,null,null,null,null,null,null,"2nd Advance Payment Total:",1185405.69]
[null,null,null,null,null,null,null,null,null,"1st Advance Payment Total:",-1204165]
[null,null,null,null,null,null,null,null,null,"Grant Award Balance:",{"$f":"(K19-K20)+K21","v":0}]
[]
[]
[]
[]
[null,null,null,null,null,"BSCC USE ONLY"]
[]
[null,null,null,null,null,null,null,null,null,"FI$Cal Supplier Data "]
[null,null,null,null,null,null,null,null,{"$f":"'[1]INVOICE 12'!L54","v":"COUNTYOFFR-006"}]
[null,null,null,null,null,null,null,null,null,"Supplier "]
[null,"Approved By:",null,null,null,null,null,null,{"$f":"'[1]INVOICE 12'!L52","v":"00000014996"}]
[null,null,"BSCC Field Representative, Date",null,null,null,null,null,null,"Supplier ID"]

{"sheet":"Year 2 Augment Budget","index":7,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,6,0,7]]}
["BUDGET TABLE FOR YEAR 2 - AUGMENTATION OF FUNDS",null,null,null,null,null,"TOTAL BUDGET EFFECTIVE INVOICE 5"]
["BSCC Budget Line Item","Year 1 Grant Funds","Year 1 Project Income","Year 2 Grant Funds","Year 2 Project Income",null,"Grant Funds","Project Income"]
["1. Salaries and Benefits",959060,0,824893,0,null,{"$f":"SUM(B3,D3)","v":1783953},{"$f":"SUM(C3,E3)","v":0}]
["2  Services and Supplies",17470.38,0,4253,0,null,{"$f":"SUM(B4,D4)","v":21723.38},0]
["3. Professional Services or Public Agency Subcontracts",126282.28,0,151556.69,0,null,277838.96999999997,0]
["4. Non-Governmental Organizations (NGO) Contracts",0,0,0,0,null,0,0]
["5. Equipment / Fixed Assets",0,0,0,0,null,0,0]
["6. Other (Travel, Training, etc.)",3200,0,7145,0,null,10345,0]
["7. Indirect Costs",98152.34,0,197558,0,null,295710.33999999997,0]
["TOTAL",{"$f":"SUM(B3:B9)","v":1204165},{"$f":"SUM(C3:C9)","v":0},1185405.69,0,null,{"$f":"SUM(G3:G9)","v":2389570.69},{"$f":"SUM(H3:H9)","v":0}]

{"sheet":"INVOICE 5","index":8,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[44,3,44,10],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[44,11,44,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[45,0,45,1],[45,3,45,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[57,4,57,9],[57,11,57,13],[50,11,50,13],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,11,56,13],[67,0,67,7],[67,8,67,11],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 1'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","5 PDPP 21",null,"Reporting Period:","2023-04-01","TO","2023-06-30","Due:","2023-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",1783953,{"$f":"'INVOICE 4'!C15","v":0},{"$f":"SUM(B15:C15)","v":1783953},{"$f":"SUM('INVOICE 4'!E15,'INVOICE 4'!H15)","v":372686},{"$f":"SUM('INVOICE 4'!F15,'INVOICE 4'!I15)","v":0},{"$f":"SUM(E15:F15)","v":372686},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":1411267},0,{"$f":"SUM(K15:L15)","v":1411267},"1st Advance \n5/23/2022"]
["Services & Supplies",21723.38,{"$f":"'INVOICE 4'!C16","v":0},21723.38,{"$f":"SUM('INVOICE 4'!E16,'INVOICE 4'!H16)","v":6729},{"$f":"SUM('INVOICE 4'!F16,'INVOICE 4'!I16)","v":0},{"$f":"SUM(E16:F16)","v":6729},0,0,0,14994.380000000001,0,14994.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",277838.96999999997,{"$f":"'INVOICE 4'!C17","v":0},277838.96999999997,{"$f":"SUM('INVOICE 4'!E17,'INVOICE 4'!H17)","v":67912.570000000007},{"$f":"SUM('INVOICE 4'!F17,'INVOICE 4'!I17)","v":0},{"$f":"SUM(E17:F17)","v":67912.570000000007},0,0,0,209926.39999999997,0,209926.39999999997,"2nd Advance \n[enter date]"]
["NGO Subcontracts",0,{"$f":"'INVOICE 4'!C18","v":0},0,{"$f":"SUM('INVOICE 4'!E18,'INVOICE 4'!H18)","v":0},{"$f":"SUM('INVOICE 4'!F18,'INVOICE 4'!I18)","v":0},0,0,0,0,0,0,0,1185405.69]
["Equipment / Fixed Assets",0,{"$f":"'INVOICE 4'!C19","v":0},0,{"$f":"SUM('INVOICE 4'!E19,'INVOICE 4'!H19)","v":0},{"$f":"SUM('INVOICE 4'!F19,'INVOICE 4'!I19)","v":0},0,0,0,0,0,0,0]
["Other",10345,{"$f":"'INVOICE 4'!C20","v":0},{"$f":"SUM(B20:C20)","v":10345},{"$f":"SUM('INVOICE 4'!E20,'INVOICE 4'!H20)","v":365},{"$f":"SUM('INVOICE 4'!F20,'INVOICE 4'!I20)","v":0},365,0,0,0,9980,0,9980]
["Indirect Costs",295710.33999999997,{"$f":"'INVOICE 4'!C21","v":0},295710.33999999997,{"$f":"SUM('INVOICE 4'!E21,'INVOICE 4'!H21)","v":37941},{"$f":"SUM('INVOICE 4'!F21,'INVOICE 4'!I21)","v":0},37941,0,0,0,257769.33999999997,0,257769.33999999997]
["TOTAL",{"$f":"SUM(B15:B21)","v":2389570.69},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":2389570.69},{"$f":"SUM(E15:E21)","v":485633.57},0,485633.57,0,{"$f":"SUM(I15:I21)","v":0},0,1903937.1199999996,0,1903937.1199999996,{"$f":"SUM(N16+N18+N20)","v":2389570.69}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":485633.57},null,null,"Grant funds claimed this period:",{"$f":"H22","v":0},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":1903937.1199999999},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":0.20323046814739765}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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,"00000014996"]
["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,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["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,"Fresno, CA 93721"]
["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"]
[null,null,null,null,null,"Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"INVOICE 6","index":9,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[44,3,44,10],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[44,11,44,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[45,0,45,1],[45,3,45,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[57,4,57,9],[57,11,57,13],[50,11,50,13],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,11,56,13],[67,0,67,7],[67,8,67,11],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 1'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","6 PDPP 21",null,"Reporting Period:","2023-07-01","TO","2023-09-30","Due:","2023-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 5'!B15","v":1783953},{"$f":"'INVOICE 5'!C15","v":0},{"$f":"SUM(B15:C15)","v":1783953},{"$f":"SUM('INVOICE 5'!E15,'INVOICE 5'!H15)","v":372686},{"$f":"SUM('INVOICE 5'!F15,'INVOICE 5'!I15)","v":0},{"$f":"SUM(E15:F15)","v":372686},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":1411267},0,{"$f":"SUM(K15:L15)","v":1411267},"1st Advance \n5/23/2022"]
["Services & Supplies",{"$f":"'INVOICE 5'!B16","v":21723.38},{"$f":"'INVOICE 5'!C16","v":0},21723.38,{"$f":"SUM('INVOICE 5'!E16,'INVOICE 5'!H16)","v":6729},{"$f":"SUM('INVOICE 5'!F16,'INVOICE 5'!I16)","v":0},{"$f":"SUM(E16:F16)","v":6729},0,0,0,14994.380000000001,0,14994.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",{"$f":"'INVOICE 5'!B17","v":277838.96999999997},{"$f":"'INVOICE 5'!C17","v":0},277838.96999999997,{"$f":"SUM('INVOICE 5'!E17,'INVOICE 5'!H17)","v":67912.570000000007},{"$f":"SUM('INVOICE 5'!F17,'INVOICE 5'!I17)","v":0},{"$f":"SUM(E17:F17)","v":67912.570000000007},0,0,0,209926.39999999997,0,209926.39999999997,{"$f":"'INVOICE 5'!N17","v":"2nd Advance \n[enter date]"}]
["NGO Subcontracts",{"$f":"'INVOICE 5'!B18","v":0},{"$f":"'INVOICE 5'!C18","v":0},0,{"$f":"SUM('INVOICE 5'!E18,'INVOICE 5'!H18)","v":0},{"$f":"SUM('INVOICE 5'!F18,'INVOICE 5'!I18)","v":0},0,0,0,0,0,0,0,1185405.69]
["Equipment / Fixed Assets",{"$f":"'INVOICE 5'!B19","v":0},{"$f":"'INVOICE 5'!C19","v":0},0,{"$f":"SUM('INVOICE 5'!E19,'INVOICE 5'!H19)","v":0},{"$f":"SUM('INVOICE 5'!F19,'INVOICE 5'!I19)","v":0},0,0,0,0,0,0,0]
["Other",{"$f":"'INVOICE 5'!B20","v":10345},{"$f":"'INVOICE 5'!C20","v":0},{"$f":"SUM(B20:C20)","v":10345},{"$f":"SUM('INVOICE 5'!E20,'INVOICE 5'!H20)","v":365},{"$f":"SUM('INVOICE 5'!F20,'INVOICE 5'!I20)","v":0},365,0,0,0,9980,0,9980]
["Indirect Costs",{"$f":"'INVOICE 5'!B21","v":295710.33999999997},{"$f":"'INVOICE 5'!C21","v":0},295710.33999999997,{"$f":"SUM('INVOICE 5'!E21,'INVOICE 5'!H21)","v":37941},{"$f":"SUM('INVOICE 5'!F21,'INVOICE 5'!I21)","v":0},37941,0,0,0,257769.33999999997,0,257769.33999999997]
["TOTAL",{"$f":"SUM(B15:B21)","v":2389570.69},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":2389570.69},{"$f":"SUM(E15:E21)","v":485633.57},0,485633.57,0,{"$f":"SUM(I15:I21)","v":0},0,1903937.1199999996,0,1903937.1199999996,{"$f":"SUM(N16+N18+N20)","v":2389570.69}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":485633.57},null,null,"Grant funds claimed this period:",{"$f":"H22","v":0},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":1903937.1199999999},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":0.20323046814739765}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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,"00000014996"]
["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,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["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,"Fresno, CA 93721"]
["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"]
[null,null,null,null,null,"Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"INVOICE 7","index":10,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[44,3,44,10],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[44,11,44,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[45,0,45,1],[45,3,45,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[57,4,57,9],[57,11,57,13],[50,11,50,13],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,11,56,13],[67,0,67,7],[67,8,67,11],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 1'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","7 PDPP 21",null,"Reporting Period:","2023-10-01","TO","2023-12-31","Due:","2024-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 6'!B15","v":1783953},{"$f":"'INVOICE 6'!C15","v":0},{"$f":"SUM(B15:C15)","v":1783953},{"$f":"SUM('INVOICE 6'!E15,'INVOICE 6'!H15)","v":372686},{"$f":"SUM('INVOICE 6'!F15,'INVOICE 6'!I15)","v":0},{"$f":"SUM(E15:F15)","v":372686},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":1411267},0,{"$f":"SUM(K15:L15)","v":1411267},"1st Advance \n5/23/2022"]
["Services & Supplies",{"$f":"'INVOICE 6'!B16","v":21723.38},{"$f":"'INVOICE 6'!C16","v":0},21723.38,{"$f":"SUM('INVOICE 6'!E16,'INVOICE 6'!H16)","v":6729},{"$f":"SUM('INVOICE 6'!F16,'INVOICE 6'!I16)","v":0},{"$f":"SUM(E16:F16)","v":6729},0,0,0,14994.380000000001,0,14994.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",{"$f":"'INVOICE 6'!B17","v":277838.96999999997},{"$f":"'INVOICE 6'!C17","v":0},277838.96999999997,{"$f":"SUM('INVOICE 6'!E17,'INVOICE 6'!H17)","v":67912.570000000007},{"$f":"SUM('INVOICE 6'!F17,'INVOICE 6'!I17)","v":0},{"$f":"SUM(E17:F17)","v":67912.570000000007},0,0,0,209926.39999999997,0,209926.39999999997,{"$f":"'INVOICE 5'!N17","v":"2nd Advance \n[enter date]"}]
["NGO Subcontracts",{"$f":"'INVOICE 6'!B18","v":0},{"$f":"'INVOICE 6'!C18","v":0},0,{"$f":"SUM('INVOICE 6'!E18,'INVOICE 6'!H18)","v":0},{"$f":"SUM('INVOICE 6'!F18,'INVOICE 6'!I18)","v":0},0,0,0,0,0,0,0,1185405.69]
["Equipment / Fixed Assets",{"$f":"'INVOICE 6'!B19","v":0},{"$f":"'INVOICE 6'!C19","v":0},0,{"$f":"SUM('INVOICE 6'!E19,'INVOICE 6'!H19)","v":0},{"$f":"SUM('INVOICE 6'!F19,'INVOICE 6'!I19)","v":0},0,0,0,0,0,0,0]
["Other",{"$f":"'INVOICE 6'!B20","v":10345},{"$f":"'INVOICE 6'!C20","v":0},{"$f":"SUM(B20:C20)","v":10345},{"$f":"SUM('INVOICE 6'!E20,'INVOICE 6'!H20)","v":365},{"$f":"SUM('INVOICE 6'!F20,'INVOICE 6'!I20)","v":0},365,0,0,0,9980,0,9980]
["Indirect Costs",{"$f":"'INVOICE 6'!B21","v":295710.33999999997},{"$f":"'INVOICE 6'!C21","v":0},295710.33999999997,{"$f":"SUM('INVOICE 6'!E21,'INVOICE 6'!H21)","v":37941},{"$f":"SUM('INVOICE 6'!F21,'INVOICE 6'!I21)","v":0},37941,0,0,0,257769.33999999997,0,257769.33999999997]
["TOTAL",{"$f":"SUM(B15:B21)","v":2389570.69},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":2389570.69},{"$f":"SUM(E15:E21)","v":485633.57},0,485633.57,0,{"$f":"SUM(I15:I21)","v":0},0,1903937.1199999996,0,1903937.1199999996,{"$f":"SUM(N16+N18+N20)","v":2389570.69}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":485633.57},null,null,"Grant funds claimed this period:",{"$f":"H22","v":0},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":1903937.1199999999},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":0.20323046814739765}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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,"00000014996"]
["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,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["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,"Fresno, CA 93721"]
["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"]
[null,null,null,null,null,"Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"INVOICE 8","index":11,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[44,3,44,10],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[44,11,44,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[45,0,45,1],[45,3,45,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[57,4,57,9],[57,11,57,13],[50,11,50,13],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,11,56,13],[67,0,67,7],[67,8,67,11],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 1'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","8 PDPP 21",null,"Reporting Period:","2024-01-01","TO","2024-03-31","Due:","2024-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 7'!B15","v":1783953},{"$f":"'INVOICE 7'!C15","v":0},{"$f":"SUM(B15:C15)","v":1783953},{"$f":"SUM('INVOICE 7'!E15,'INVOICE 7'!H15)","v":372686},{"$f":"SUM('INVOICE 7'!F15,'INVOICE 7'!I15)","v":0},{"$f":"SUM(E15:F15)","v":372686},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":1411267},0,{"$f":"SUM(K15:L15)","v":1411267},"1st Advance \n5/23/2022"]
["Services & Supplies",{"$f":"'INVOICE 7'!B16","v":21723.38},{"$f":"'INVOICE 7'!C16","v":0},21723.38,{"$f":"SUM('INVOICE 7'!E16,'INVOICE 7'!H16)","v":6729},{"$f":"SUM('INVOICE 7'!F16,'INVOICE 7'!I16)","v":0},{"$f":"SUM(E16:F16)","v":6729},0,0,0,14994.380000000001,0,14994.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",{"$f":"'INVOICE 7'!B17","v":277838.96999999997},{"$f":"'INVOICE 7'!C17","v":0},277838.96999999997,{"$f":"SUM('INVOICE 7'!E17,'INVOICE 7'!H17)","v":67912.570000000007},{"$f":"SUM('INVOICE 7'!F17,'INVOICE 7'!I17)","v":0},{"$f":"SUM(E17:F17)","v":67912.570000000007},0,0,0,209926.39999999997,0,209926.39999999997,{"$f":"'INVOICE 5'!N17","v":"2nd Advance \n[enter date]"}]
["NGO Subcontracts",{"$f":"'INVOICE 7'!B18","v":0},{"$f":"'INVOICE 7'!C18","v":0},0,{"$f":"SUM('INVOICE 7'!E18,'INVOICE 7'!H18)","v":0},{"$f":"SUM('INVOICE 7'!F18,'INVOICE 7'!I18)","v":0},0,0,0,0,0,0,0,1185405.69]
["Equipment / Fixed Assets",{"$f":"'INVOICE 7'!B19","v":0},{"$f":"'INVOICE 7'!C19","v":0},0,{"$f":"SUM('INVOICE 7'!E19,'INVOICE 7'!H19)","v":0},{"$f":"SUM('INVOICE 7'!F19,'INVOICE 7'!I19)","v":0},0,0,0,0,0,0,0]
["Other",{"$f":"'INVOICE 7'!B20","v":10345},{"$f":"'INVOICE 7'!C20","v":0},{"$f":"SUM(B20:C20)","v":10345},{"$f":"SUM('INVOICE 7'!E20,'INVOICE 7'!H20)","v":365},{"$f":"SUM('INVOICE 7'!F20,'INVOICE 7'!I20)","v":0},365,0,0,0,9980,0,9980]
["Indirect Costs",{"$f":"'INVOICE 7'!B21","v":295710.33999999997},{"$f":"'INVOICE 7'!C21","v":0},295710.33999999997,{"$f":"SUM('INVOICE 7'!E21,'INVOICE 7'!H21)","v":37941},{"$f":"SUM('INVOICE 7'!F21,'INVOICE 7'!I21)","v":0},37941,0,0,0,257769.33999999997,0,257769.33999999997]
["TOTAL",{"$f":"SUM(B15:B21)","v":2389570.69},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":2389570.69},{"$f":"SUM(E15:E21)","v":485633.57},0,485633.57,0,{"$f":"SUM(I15:I21)","v":0},0,1903937.1199999996,0,1903937.1199999996,{"$f":"SUM(N16+N18+N20)","v":2389570.69}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":485633.57},null,null,"Grant funds claimed this period:",{"$f":"H22","v":0},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":1903937.1199999999},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":0.20323046814739765}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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,"00000014996"]
["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,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["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,"Fresno, CA 93721"]
["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"]
[null,null,null,null,null,"Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"3rd Advance Payment","index":12,"n_rows":49,"n_cols":12,"rows_kept":49,"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],[42,6,42,10],[44,7,44,10],[47,0,47,1],[48,7,48,10],[43,6,43,10]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,"Purchase Authority",null,"BSCC 5229"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,"Purchase Order:",null,"TBD"]
["Advance Payment Invoice: BSCC 201A (Revised 01/2023)"]
[]
[]
[null,"Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,"Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"}]
[]
[null,"Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,null,null,null,"Address"]
[null,null,null,null,null,null,null,null,null,"Address Line 1"]
[null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"}]
[null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,"Advance Payment #",null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
[null,"Effective Invoice #"]
[]
[]
["Advance Payment Invoice"]
[null,null,null,null,null,null,null,null,null,"Total Grant Award:",0]
[null,null,null,null,null,null,null,null,null,"Advance Total:",0]
[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,null,null,"Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"INVOICE 9","index":13,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[44,3,44,10],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[44,11,44,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[45,0,45,1],[45,3,45,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[57,4,57,9],[57,11,57,13],[50,11,50,13],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,11,56,13],[67,0,67,7],[67,8,67,11],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 1'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","9 PDPP 21",null,"Reporting Period:","2024-04-01","TO","2024-06-30","Due:","2024-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 8'!B15","v":1783953},{"$f":"'INVOICE 8'!C15","v":0},{"$f":"SUM(B15:C15)","v":1783953},{"$f":"SUM('INVOICE 8'!E15,'INVOICE 8'!H15)","v":372686},{"$f":"SUM('INVOICE 8'!F15,'INVOICE 8'!I15)","v":0},{"$f":"SUM(E15:F15)","v":372686},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":1411267},0,{"$f":"SUM(K15:L15)","v":1411267},"1st Advance \n5/23/2022"]
["Services & Supplies",{"$f":"'INVOICE 8'!B16","v":21723.38},{"$f":"'INVOICE 8'!C16","v":0},21723.38,{"$f":"SUM('INVOICE 8'!E16,'INVOICE 8'!H16)","v":6729},{"$f":"SUM('INVOICE 8'!F16,'INVOICE 8'!I16)","v":0},{"$f":"SUM(E16:F16)","v":6729},0,0,0,14994.380000000001,0,14994.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",{"$f":"'INVOICE 8'!B17","v":277838.96999999997},{"$f":"'INVOICE 8'!C17","v":0},277838.96999999997,{"$f":"SUM('INVOICE 8'!E17,'INVOICE 8'!H17)","v":67912.570000000007},{"$f":"SUM('INVOICE 8'!F17,'INVOICE 8'!I17)","v":0},{"$f":"SUM(E17:F17)","v":67912.570000000007},0,0,0,209926.39999999997,0,209926.39999999997,{"$f":"'INVOICE 5'!N17","v":"2nd Advance \n[enter date]"}]
["NGO Subcontracts",{"$f":"'INVOICE 8'!B18","v":0},{"$f":"'INVOICE 8'!C18","v":0},0,{"$f":"SUM('INVOICE 8'!E18,'INVOICE 8'!H18)","v":0},{"$f":"SUM('INVOICE 8'!F18,'INVOICE 8'!I18)","v":0},0,0,0,0,0,0,0,1185405.69]
["Equipment / Fixed Assets",{"$f":"'INVOICE 8'!B19","v":0},{"$f":"'INVOICE 8'!C19","v":0},0,{"$f":"SUM('INVOICE 8'!E19,'INVOICE 8'!H19)","v":0},{"$f":"SUM('INVOICE 8'!F19,'INVOICE 8'!I19)","v":0},0,0,0,0,0,0,0,"3rd Advance\n[enter date}"]
["Other",{"$f":"'INVOICE 8'!B20","v":10345},{"$f":"'INVOICE 8'!C20","v":0},{"$f":"SUM(B20:C20)","v":10345},{"$f":"SUM('INVOICE 8'!E20,'INVOICE 8'!H20)","v":365},{"$f":"SUM('INVOICE 8'!F20,'INVOICE 8'!I20)","v":0},365,0,0,0,9980,0,9980]
["Indirect Costs",{"$f":"'INVOICE 8'!B21","v":295710.33999999997},{"$f":"'INVOICE 8'!C21","v":0},295710.33999999997,{"$f":"SUM('INVOICE 8'!E21,'INVOICE 8'!H21)","v":37941},{"$f":"SUM('INVOICE 8'!F21,'INVOICE 8'!I21)","v":0},37941,0,0,0,257769.33999999997,0,257769.33999999997]
["TOTAL",{"$f":"SUM(B15:B21)","v":2389570.69},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":2389570.69},{"$f":"SUM(E15:E21)","v":485633.57},0,485633.57,0,{"$f":"SUM(I15:I21)","v":0},0,1903937.1199999996,0,1903937.1199999996,{"$f":"SUM(N16+N18+N20)","v":2389570.69}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":485633.57},null,null,"Grant funds claimed this period:",{"$f":"H22","v":0},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":1903937.1199999999},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":0.20323046814739765}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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,"00000014996"]
["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,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["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,"Fresno, CA 93721"]
["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"]
[null,null,null,null,null,"Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"INVOICE 10","index":14,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[44,3,44,10],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[44,11,44,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[45,0,45,1],[45,3,45,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[57,4,57,9],[57,11,57,13],[50,11,50,13],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,11,56,13],[67,0,67,7],[67,8,67,11],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 1'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","10 PDPP 21",null,"Reporting Period:","2024-07-01","TO","2024-09-30","Due:","2024-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 9'!B15","v":1783953},{"$f":"'INVOICE 9'!C15","v":0},{"$f":"SUM(B15:C15)","v":1783953},{"$f":"SUM('INVOICE 9'!E15,'INVOICE 9'!H15)","v":372686},{"$f":"SUM('INVOICE 9'!F15,'INVOICE 9'!I15)","v":0},{"$f":"SUM(E15:F15)","v":372686},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":1411267},0,{"$f":"SUM(K15:L15)","v":1411267},"1st Advance \n5/23/2022"]
["Services & Supplies",{"$f":"'INVOICE 9'!B16","v":21723.38},{"$f":"'INVOICE 9'!C16","v":0},21723.38,{"$f":"SUM('INVOICE 9'!E16,'INVOICE 9'!H16)","v":6729},{"$f":"SUM('INVOICE 9'!F16,'INVOICE 9'!I16)","v":0},{"$f":"SUM(E16:F16)","v":6729},0,0,0,14994.380000000001,0,14994.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",{"$f":"'INVOICE 9'!B17","v":277838.96999999997},{"$f":"'INVOICE 9'!C17","v":0},277838.96999999997,{"$f":"SUM('INVOICE 9'!E17,'INVOICE 9'!H17)","v":67912.570000000007},{"$f":"SUM('INVOICE 9'!F17,'INVOICE 9'!I17)","v":0},{"$f":"SUM(E17:F17)","v":67912.570000000007},0,0,0,209926.39999999997,0,209926.39999999997,{"$f":"'INVOICE 5'!N17","v":"2nd Advance \n[enter date]"}]
["NGO Subcontracts",{"$f":"'INVOICE 9'!B18","v":0},{"$f":"'INVOICE 9'!C18","v":0},0,{"$f":"SUM('INVOICE 9'!E18,'INVOICE 9'!H18)","v":0},{"$f":"SUM('INVOICE 9'!F18,'INVOICE 9'!I18)","v":0},0,0,0,0,0,0,0,1185405.69]
["Equipment / Fixed Assets",{"$f":"'INVOICE 9'!B19","v":0},{"$f":"'INVOICE 9'!C19","v":0},0,{"$f":"SUM('INVOICE 9'!E19,'INVOICE 9'!H19)","v":0},{"$f":"SUM('INVOICE 9'!F19,'INVOICE 9'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 9'!N19","v":"3rd Advance\n[enter date}"}]
["Other",{"$f":"'INVOICE 9'!B20","v":10345},{"$f":"'INVOICE 9'!C20","v":0},{"$f":"SUM(B20:C20)","v":10345},{"$f":"SUM('INVOICE 9'!E20,'INVOICE 9'!H20)","v":365},{"$f":"SUM('INVOICE 9'!F20,'INVOICE 9'!I20)","v":0},365,0,0,0,9980,0,9980,{"$f":"'INVOICE 9'!N20","v":0}]
["Indirect Costs",{"$f":"'INVOICE 9'!B21","v":295710.33999999997},{"$f":"'INVOICE 9'!C21","v":0},295710.33999999997,{"$f":"SUM('INVOICE 9'!E21,'INVOICE 9'!H21)","v":37941},{"$f":"SUM('INVOICE 9'!F21,'INVOICE 9'!I21)","v":0},37941,0,0,0,257769.33999999997,0,257769.33999999997]
["TOTAL",{"$f":"SUM(B15:B21)","v":2389570.69},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":2389570.69},{"$f":"SUM(E15:E21)","v":485633.57},0,485633.57,0,{"$f":"SUM(I15:I21)","v":0},0,1903937.1199999996,0,1903937.1199999996,{"$f":"SUM(N16+N18+N20)","v":2389570.69}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":485633.57},null,null,"Grant funds claimed this period:",{"$f":"H22","v":0},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":1903937.1199999999},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":0.20323046814739765}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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,"00000014996"]
["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,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["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,"Fresno, CA 93721"]
["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"]
[null,null,null,null,null,"Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"INVOICE 11","index":15,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[44,3,44,10],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[44,11,44,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[45,0,45,1],[45,3,45,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[57,4,57,9],[57,11,57,13],[50,11,50,13],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,11,56,13],[67,0,67,7],[67,8,67,11],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 1'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","11 PDPP 21",null,"Reporting Period:","2024-10-01","TO","2025-01-01","Due:","2025-02-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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 10'!B15","v":1783953},{"$f":"'INVOICE 10'!C15","v":0},{"$f":"SUM(B15:C15)","v":1783953},{"$f":"SUM('INVOICE 10'!E15,'INVOICE 10'!H15)","v":372686},{"$f":"SUM('INVOICE 10'!F15,'INVOICE 10'!I15)","v":0},{"$f":"SUM(E15:F15)","v":372686},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":1411267},0,{"$f":"SUM(K15:L15)","v":1411267},"1st Advance \n5/23/2022"]
["Services & Supplies",{"$f":"'INVOICE 10'!B16","v":21723.38},{"$f":"'INVOICE 10'!C16","v":0},21723.38,{"$f":"SUM('INVOICE 10'!E16,'INVOICE 10'!H16)","v":6729},{"$f":"SUM('INVOICE 10'!F16,'INVOICE 10'!I16)","v":0},{"$f":"SUM(E16:F16)","v":6729},0,0,0,14994.380000000001,0,14994.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",{"$f":"'INVOICE 10'!B17","v":277838.96999999997},{"$f":"'INVOICE 10'!C17","v":0},277838.96999999997,{"$f":"SUM('INVOICE 10'!E17,'INVOICE 10'!H17)","v":67912.570000000007},{"$f":"SUM('INVOICE 10'!F17,'INVOICE 10'!I17)","v":0},{"$f":"SUM(E17:F17)","v":67912.570000000007},0,0,0,209926.39999999997,0,209926.39999999997,{"$f":"'INVOICE 5'!N17","v":"2nd Advance \n[enter date]"}]
["NGO Subcontracts",{"$f":"'INVOICE 10'!B18","v":0},{"$f":"'INVOICE 10'!C18","v":0},0,{"$f":"SUM('INVOICE 10'!E18,'INVOICE 10'!H18)","v":0},{"$f":"SUM('INVOICE 10'!F18,'INVOICE 10'!I18)","v":0},0,0,0,0,0,0,0,1185405.69]
["Equipment / Fixed Assets",{"$f":"'INVOICE 10'!B19","v":0},{"$f":"'INVOICE 10'!C19","v":0},0,{"$f":"SUM('INVOICE 10'!E19,'INVOICE 10'!H19)","v":0},{"$f":"SUM('INVOICE 10'!F19,'INVOICE 10'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 9'!N19","v":"3rd Advance\n[enter date}"}]
["Other",{"$f":"'INVOICE 10'!B20","v":10345},{"$f":"'INVOICE 10'!C20","v":0},{"$f":"SUM(B20:C20)","v":10345},{"$f":"SUM('INVOICE 10'!E20,'INVOICE 10'!H20)","v":365},{"$f":"SUM('INVOICE 10'!F20,'INVOICE 10'!I20)","v":0},365,0,0,0,9980,0,9980,{"$f":"'INVOICE 9'!N20","v":0}]
["Indirect Costs",{"$f":"'INVOICE 10'!B21","v":295710.33999999997},{"$f":"'INVOICE 10'!C21","v":0},295710.33999999997,{"$f":"SUM('INVOICE 10'!E21,'INVOICE 10'!H21)","v":37941},{"$f":"SUM('INVOICE 10'!F21,'INVOICE 10'!I21)","v":0},37941,0,0,0,257769.33999999997,0,257769.33999999997]
["TOTAL",{"$f":"SUM(B15:B21)","v":2389570.69},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":2389570.69},{"$f":"SUM(E15:E21)","v":485633.57},0,485633.57,0,{"$f":"SUM(I15:I21)","v":0},0,1903937.1199999996,0,1903937.1199999996,{"$f":"SUM(N16+N18+N20)","v":2389570.69}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":485633.57},null,null,"Grant funds claimed this period:",{"$f":"H22","v":0},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":1903937.1199999999},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":0.20323046814739765}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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,"00000014996"]
["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,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["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,"Fresno, CA 93721"]
["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"]
[null,null,null,null,null,"Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"INVOICE 12","index":16,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,5,2,7],[4,10,6,13],[12,0,13,0],[12,1,12,3],[12,4,12,6],[12,7,12,9],[12,10,12,12],[12,13,13,13],[24,0,24,12],[29,0,29,2],[30,3,30,10],[30,11,30,13],[31,0,32,0],[31,3,31,10],[31,11,31,13],[32,3,32,10],[32,11,32,13],[35,0,36,0],[35,3,35,10],[35,11,35,13],[36,3,36,10],[36,11,36,13],[33,0,34,0],[33,3,33,10],[33,11,33,13],[34,3,34,10],[34,11,34,13],[44,3,44,10],[37,0,38,0],[37,3,37,10],[37,11,37,13],[38,3,38,10],[38,11,38,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],[44,11,44,13],[46,0,46,2],[46,4,46,9],[46,11,46,13],[47,0,47,2],[47,4,56,9],[48,0,48,2],[48,11,48,13],[49,0,49,2],[49,11,49,13],[50,0,50,2],[45,0,45,1],[45,3,45,13],[43,0,44,0],[43,3,43,10],[43,11,43,13],[57,4,57,9],[57,11,57,13],[50,11,50,13],[51,0,51,2],[51,11,51,13],[52,0,52,2],[52,11,52,13],[53,0,53,2],[53,11,53,13],[54,0,54,2],[54,11,54,13],[55,0,55,2],[55,11,55,13],[56,11,56,13],[67,0,67,7],[67,8,67,11],[58,4,58,9],[59,4,59,9],[60,4,60,9],[61,4,61,9],[61,10,61,12],[62,0,62,2],[62,4,62,9],[62,10,62,12],[63,5,63,8],[65,0,65,12],[66,0,66,1],[66,6,66,7],[66,8,66,11]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,"Purchase Authority",null,{"$f":"'INVOICE 1'!N1","v":"BSCC 5227"}]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,"Purchase Order:",null,{"$f":"'INVOICE 1'!N2","v":"5227-0000003918"}]
["Financial Invoice Form: BSCC 201 (Revised 01/2023)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"},null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,"Project Title:"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,"Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},"TO",{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","12 PDPP 21",null,"Reporting Period:","2025-01-02","TO","2025-03-01","Due:","2025-04-16",null,null,"Final Invoice (Y/N):","Yes"]
[]
["Line Items","Budget",null,null,"Prior Expenditures",null,null,"This Reporting Period",null,null,"Balance",null,null,"Advance Disbursements"]
[null,"Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 11'!B15","v":1783953},{"$f":"'INVOICE 11'!C15","v":0},{"$f":"SUM(B15:C15)","v":1783953},{"$f":"SUM('INVOICE 11'!E15,'INVOICE 11'!H15)","v":372686},{"$f":"SUM('INVOICE 11'!F15,'INVOICE 11'!I15)","v":0},{"$f":"SUM(E15:F15)","v":372686},0,0,{"$f":"SUM(H15:I15)","v":0},{"$f":"B15-E15-H15","v":1411267},0,{"$f":"SUM(K15:L15)","v":1411267},"1st Advance \n5/23/2022"]
["Services & Supplies",{"$f":"'INVOICE 11'!B16","v":21723.38},{"$f":"'INVOICE 11'!C16","v":0},21723.38,{"$f":"SUM('INVOICE 11'!E16,'INVOICE 11'!H16)","v":6729},{"$f":"SUM('INVOICE 11'!F16,'INVOICE 11'!I16)","v":0},{"$f":"SUM(E16:F16)","v":6729},0,0,0,14994.380000000001,0,14994.380000000001,{"$f":"'1st Advance Payment'!K20","v":1204165}]
["Professional Services or Public Agency Subcontract",{"$f":"'INVOICE 11'!B17","v":277838.96999999997},{"$f":"'INVOICE 11'!C17","v":0},277838.96999999997,{"$f":"SUM('INVOICE 11'!E17,'INVOICE 11'!H17)","v":67912.570000000007},{"$f":"SUM('INVOICE 11'!F17,'INVOICE 11'!I17)","v":0},{"$f":"SUM(E17:F17)","v":67912.570000000007},0,0,0,209926.39999999997,0,209926.39999999997,{"$f":"'INVOICE 5'!N17","v":"2nd Advance \n[enter date]"}]
["NGO Subcontracts",{"$f":"'INVOICE 11'!B18","v":0},{"$f":"'INVOICE 11'!C18","v":0},0,{"$f":"SUM('INVOICE 11'!E18,'INVOICE 11'!H18)","v":0},{"$f":"SUM('INVOICE 11'!F18,'INVOICE 11'!I18)","v":0},0,0,0,0,0,0,0,1185405.69]
["Equipment / Fixed Assets",{"$f":"'INVOICE 11'!B19","v":0},{"$f":"'INVOICE 11'!C19","v":0},0,{"$f":"SUM('INVOICE 11'!E19,'INVOICE 11'!H19)","v":0},{"$f":"SUM('INVOICE 11'!F19,'INVOICE 11'!I19)","v":0},0,0,0,0,0,0,0,{"$f":"'INVOICE 9'!N19","v":"3rd Advance\n[enter date}"}]
["Other",{"$f":"'INVOICE 11'!B20","v":10345},{"$f":"'INVOICE 11'!C20","v":0},{"$f":"SUM(B20:C20)","v":10345},{"$f":"SUM('INVOICE 11'!E20,'INVOICE 11'!H20)","v":365},{"$f":"SUM('INVOICE 11'!F20,'INVOICE 11'!I20)","v":0},365,0,0,0,9980,0,9980,{"$f":"'INVOICE 9'!N20","v":0}]
["Indirect Costs",{"$f":"'INVOICE 11'!B21","v":295710.33999999997},{"$f":"'INVOICE 11'!C21","v":0},295710.33999999997,{"$f":"SUM('INVOICE 11'!E21,'INVOICE 11'!H21)","v":37941},{"$f":"SUM('INVOICE 11'!F21,'INVOICE 11'!I21)","v":0},37941,0,0,0,257769.33999999997,0,257769.33999999997]
["TOTAL",{"$f":"SUM(B15:B21)","v":2389570.69},{"$f":"SUM(C15:C21)","v":0},{"$f":"SUM(D15:D21)","v":2389570.69},{"$f":"SUM(E15:E21)","v":485633.57},0,485633.57,0,{"$f":"SUM(I15:I21)","v":0},0,1903937.1199999996,0,1903937.1199999996,{"$f":"SUM(N16+N18+N20)","v":2389570.69}]
[]
["Project Income",null,"Income reported to date",{"$f":"'INVOICE 1'!D24+'INVOICE 1'!I24","v":0},null,"Prior allocated income",{"$f":"'INVOICE 1'!I24","v":0},"This Period",0,null,null,"Unallocated income balance",{"$f":"D24-G24","v":0}]
[]
[null,null,"Grant funds expended to date:",{"$f":"SUM(E22,H22)","v":485633.57},null,null,"Grant funds claimed this period:",{"$f":"H22","v":0},null,null,null,"Percent of total disbursed"]
[null,null,"Project Income to date:",{"$f":"SUM(F22,I22)","v":0},null,"Advance Disbursement Balance",null,{"$f":"N22-D26","v":1903937.1199999999},null,null,null,"funds expended to date:",null,{"$f":"D26/N22","v":0.20323046814739765}]
[]
[]
[]
[null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",{"$f":"H15","v":0}]
[null,"Project Income",{"$f":"I15","v":0}]
["Services & Supplies","Grant Funds",{"$f":"H16","v":0}]
[null,"Project Income",{"$f":"I16","v":0}]
["Professional Services or Public Agency Subcontracts","Grant Funds",{"$f":"H17","v":0}]
[null,"Project Income",{"$f":"I17","v":0}]
["NGO Subcontracts","Grant Funds",{"$f":"H18","v":0}]
[null,"Project Income",{"$f":"I18","v":0}]
["Equipment / Fixed Assets","Grant Funds",{"$f":"H19","v":0}]
[null,"Project Income",{"$f":"I19","v":0}]
["Other","Grant Funds",{"$f":"H20","v":0}]
[null,"Project Income",{"$f":"I20","v":0}]
["Indirect Costs","Grant Funds",{"$f":"H21","v":0}]
[null,"Project Income",{"$f":"I21","v":0}]
["Project Income",null,{"$f":"I24","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,"00000014996"]
["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,"COUNTYOFFR-006"]
["Phone",null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
[null,null,null,null,null,null,null,null,null,null,null,"2281 Tulare Street, Room 304"]
["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,"Fresno, CA 93721"]
["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"]
[null,null,null,null,null,"Please initial here to certify the submission of this invoice."]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,"Approved By:"]
[null,null,null,null,null,null,null,null,"BSCC Field Representative, Date"]

{"sheet":"MODIFICATION REQUEST","index":17,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[[21,4,21,6],[33,0,33,12],[21,0,22,0],[21,1,21,3],[21,7,21,9],[21,10,21,12],[35,0,35,1],[35,2,35,12],[36,0,36,1],[36,2,36,12],[34,0,34,12],[39,0,39,1],[39,2,39,12],[40,0,40,1],[40,2,40,12],[37,0,37,1],[37,2,37,12],[38,0,38,1],[38,2,38,12],[43,0,43,1],[43,2,43,12],[44,0,44,1],[44,2,44,12],[41,0,41,1],[41,2,41,12],[42,0,42,1],[42,2,42,12],[47,0,47,1],[47,2,47,12],[48,0,48,1],[48,2,48,12],[45,0,45,1],[45,2,45,12],[46,0,46,1],[46,2,46,12],[50,0,50,2],[50,8,50,12],[51,8,60,12],[52,0,52,2],[53,0,53,2],[54,0,54,2],[55,0,55,2],[56,0,56,2],[57,0,57,2],[58,0,58,2],[59,0,59,2],[71,15,71,16],[0,5,2,7],[7,1,7,3],[7,5,7,7],[7,9,7,11],[9,0,9,12],[66,8,66,12],[67,9,67,12],[70,0,70,1],[70,8,70,10],[71,8,71,10],[61,8,61,12],[62,8,62,12],[63,8,63,12],[64,8,64,12],[65,8,65,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"STATE OF CALIFORNIA"]
["MODIFICATION REQUEST - (FORM BSCC 223.1 (Revised 1/23)",null,null,null,null,null,null,null,null,null,null,null,"BOARD OF STATE AND COMMUNITY CORRECTIONS"]
[]
[]
["Please mark an \"X\" in the green cell to indicate which type of budget modification you want to select."]
[]
[null,"Line-Item Change",null,null,null,"Budget Modification",null,null,null,"Project Income Allocation"]
[null,"Select this option if you are modifying narrative details within a line item (or line items) but not changing the budget.",null,null,null,"Select ths option if you are modifying line-item dollar amounts by moving funds from one line-item to another.",null,null,null,"Select this option if you are allocating earned project income."]
[]
["Important Note: You must provide a detailed justification for all modification requests. All modifications require BSCC Field Representative approval.  "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"County of Fresno"},null,null,null,null,null,null,"Grant Program:",{"$f":"'INVOICE 1'!B5","v":"Public Defense Pilot Program"}]
[]
["Address","2281 Tulare Street, Room 304",null,null,null,null,null,null,"Project Title",{"$f":"'INVOICE 1'!G7","v":0}]
[]
[null,"Fresno, CA 93721"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"BSCC 323-21"},null,null,null,null,null,null,null,"Modification Request #",2]
[]
["Term:",{"$f":"'INVOICE 1'!E9","v":"2022-03-01"},{"$f":"'INVOICE 1'!F9","v":"TO"},{"$f":"'INVOICE 1'!G9","v":"2025-03-01"},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","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL","Grant Funds","Project Income","TOTAL"]
["Salaries & Benefits",{"$f":"'INVOICE 1'!B15","v":959060},{"$f":"'INVOICE 1'!C15","v":0},{"$f":"SUM(B24:C24)","v":959060},{"$f":"'INVOICE 12'!K15","v":1411267},{"$f":"'INVOICE 12'!L15","v":0},{"$f":"SUM(E24:F24)","v":1411267},0,0,{"$f":"SUM(H24:I24)","v":0},{"$f":"SUM(B24,H24)","v":959060},{"$f":"SUM(C24,I24)","v":0},{"$f":"SUM(K24:L24)","v":959060}]
["Services & Supplies",{"$f":"'INVOICE 1'!B16","v":17470.38},{"$f":"'INVOICE 1'!C16","v":0},17470.38,{"$f":"'INVOICE 12'!K16","v":14994.380000000001},{"$f":"'INVOICE 12'!L16","v":0},14994.380000000001,0,0,0,17470.38,0,17470.38]
["Professional Services",{"$f":"'INVOICE 1'!B17","v":126282.28},{"$f":"'INVOICE 1'!C17","v":0},126282.28,{"$f":"'INVOICE 12'!K17","v":209926.39999999997},{"$f":"'INVOICE 12'!L17","v":0},209926.39999999997,0,0,0,126282.28,0,126282.28]
["NGO Subcontracts",{"$f":"'INVOICE 1'!B18","v":0},{"$f":"'INVOICE 1'!C18","v":0},0,{"$f":"'INVOICE 12'!K18","v":0},{"$f":"'INVOICE 12'!L18","v":0},0,0,0,0,0,0,0]
["Equipment / Fixed Assets",{"$f":"'INVOICE 1'!B19","v":0},{"$f":"'INVOICE 1'!C19","v":0},0,{"$f":"'INVOICE 12'!K19","v":0},{"$f":"'INVOICE 12'!L19","v":0},0,0,0,0,0,0,0]
["Other",{"$f":"'INVOICE 1'!B20","v":3200},{"$f":"'INVOICE 1'!C20","v":0},3200,{"$f":"'INVOICE 12'!K20","v":9980},{"$f":"'INVOICE 12'!L20","v":0},9980,0,0,0,3200,0,3200]
["Indirect Costs",{"$f":"'INVOICE 1'!B21","v":98152.34},{"$f":"'INVOICE 1'!C21","v":0},98152.34,{"$f":"'INVOICE 12'!K21","v":257769.33999999997},{"$f":"'INVOICE 12'!L21","v":0},257769.33999999997,0,0,0,98152.34,0,98152.34]
["TOTAL",{"$f":"SUM(B24:B30)","v":1204165},0,1204165,1903937.1199999996,0,1903937.1199999996,0,0,0,1204165,0,1204165]
[]
["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 (leave field blank if no changes to that line item)"]
["1. Salaries & Benefits"]
["Grant Funds:",null,"Enter new narrative and justification for grant funds here..."]
["2. Services  & Supplies"]
["Grant Funds:",null,"Enter new narrative and justification for grant funds here..."]
["3. Professional Services:"]
["Grant Funds:",null,"Enter new narrative and justification for grant funds here..."]
["4. NGO Subcontracts:"]
["Grant Funds:",null,"Enter new narrative and justification for grant funds here..."]
["5. Equipment / Fixed Assets:"]
["Grant Funds:",null,"Enter new narrative and justification for grant funds here..."]
["6. Other:"]
["Grant Funds:",null,"Enter new narrative and justification for grant funds here..."]
["7. Indirect Costs:"]
["Grant Funds:",null,"Enter new narrative and justification for grant funds here..."]
[]
["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"]
[null,null,null,null,null,null,null,null,null,"Please initial here to certify the submissionthis budget modification."]
[]
["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":18,"n_rows":129,"n_cols":6,"rows_kept":129,"cut":false,"hidden":false,"merged":[[11,0,11,4],[0,0,0,5],[1,0,1,5],[2,0,2,2],[2,3,2,5],[3,0,3,5],[5,0,5,5],[6,0,6,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,4],[12,0,12,4],[13,0,13,4],[15,0,15,4],[17,0,17,5],[18,0,18,1],[18,2,18,4],[51,2,51,4],[29,0,29,4],[32,0,32,5],[34,0,34,5],[35,0,35,5],[36,0,36,1],[36,2,36,4],[45,0,45,4],[47,0,47,2],[48,0,48,5],[49,0,49,5],[50,0,50,5],[33,0,33,5],[80,0,80,5],[52,0,52,1],[52,2,52,3],[60,0,60,4],[63,0,63,5],[64,0,64,5],[65,0,65,5],[66,0,66,1],[66,2,66,4],[75,0,75,4],[77,0,77,5],[79,0,79,5],[81,2,81,4],[88,0,88,4],[92,0,92,5],[93,0,93,5],[94,0,94,1],[94,2,94,4],[101,0,101,4],[104,0,104,5],[105,0,105,5],[106,0,106,5],[107,0,107,1],[107,2,107,4],[123,0,123,4],[126,0,126,5],[128,0,128,5],[114,0,114,4],[118,0,118,5],[119,0,119,5],[120,0,120,4],[121,0,121,3],[122,0,122,4],[127,0,127,5]]}
[]
["2020 Indigent Defense Grant Program - Project Budget and Budget Narrative"]
["Name of Applicant:",null,null,{"$f":"'[1]INVOICE 1'!B7","v":"County of Fresno"}]
["Contract Term: March 1, 2022 to March 1, 2025"]
["The total amount of funding each county is eligible to receive is provided on the Funding Allocation tab.  Please request the full amount of funding next to your county name."]
["Note: Rows 8-15 will auto-populate based on the information entered in the budget line items (Salaries and Benefits, Services and Supplies, etc.)"]
["Budget Line Item",null,null,null,null,"Total"]
["1. Salaries and Benefits",null,null,null,null,{"$f":"'[1]INVOICE 1'!B15","v":959060}]
["2. Services and Supplies",null,null,null,null,{"$f":"'[1]INVOICE 1'!B16","v":17470.38}]
["3. Professional Services or Public Agency Subcontracts",null,null,null,null,{"$f":"'[1]INVOICE 1'!B17","v":126282.28}]
["4. Non-Governmental Organization (NGO) Subcontracts",null,null,null,null,{"$f":"'[1]INVOICE 1'!B18","v":0}]
["5. Equipment/Fixed Assets",null,null,null,null,{"$f":"'[1]INVOICE 1'!B19","v":0}]
["6. Project Evaluation",null,null,null,null,{"$f":"'[1]INVOICE 1'!B20","v":0}]
["7. Other (Travel, Training, etc.)",null,null,null,null,{"$f":"'[1]INVOICE 1'!B21","v":3200}]
["8. Indirect Costs",null,null,null,null,{"$f":"'[1]INVOICE 1'!B22","v":98152.34}]
["TOTAL",null,null,null,null,{"$f":"SUM(F8:F15)","v":1204165}]
[]
["1a. Salaries and Benefits"]
["Name and Title",null,"(Show as either % FTE or Hourly Rate) & Benefits  ",null,null,"Total"]
["Defense Attorney III",null,"100% FTE $112,762 + Benefits $89,792",null,null,202554]
["Defense Attorney IV",null,"100% FTE $131,950 + Benefits $105,071",null,null,237021]
["Defense Attorney IV",null,"100% FTE $131,950 + Benefits $105,071",null,null,237021]
["Paralegal III",null,"100% FTE $46,488 + Benefits $37,018",null,null,83506]
["Defense Investigator II",null,"100% FTE $60,190 + Benefits $47,929",null,null,108119]
["Social Worker III",null,"100% FTE $50,570 + Benefits $40,269",null,null,90839]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["TOTAL",null,null,null,null,{"$f":"SUM(F20:F29)","v":959060}]
[]
["1b. Salaries and Benefits Narrative:"]
["The Public Defender will create a Post-Conviction team comprised of one immigration attorney, 2 re-sentencing attorneys, and 3 support staff. All attorneys would provide professional legal services requiring interaction with Public Defender clients and staff, the public, and other governmental agencies and members of the legal profession. The support staff would assist the re-sentencing attorneys with investigating mitigation evidence, researching client records, interviewing and locating witnesses, assisting mitigation experts, subpoena preparation, and preparing mitigation reports. These are all new positions being created to work solely on the Public Defense Pilot Program."]
["Bud Mod #1 - The Public Defender requests to modify 1a. Salaries and Benefits Name and Title regarding the Defense Attorney positions. Previously the positions were budgeted for  (2) Defense Attorney IV and (1) Defense Attorney III. After several months of active recruiting, the Public Defender was unable to hire any new employees and has reassigned existing staff into the grant positions. The existing attorneys with the requisite knowledge to best address the given statutes are (2) Senior Defense Attorney and (1) Defense Attorney III that is eligible for promotion to Defense Attorney IV in January 2023. We request a modification to the original budget to list 3 FTE Defense Attorneys, given that the budgeted amounts are unchanged. Due to the length of vacancies, additional funding is not needed to account for the higher salaries.  Please make all requested modifications effective beginning on Invoice #1.  "]
["3/29/23 - Year 2 funds added ($824,893.00)"]
["2a. Services and Supplies"]
["Description of Services or Supplies",null,"Calculation for Expenditure",null,null,"Total"]
["(6) Laptops + Accessories",null,"6 x $2500",null,null,15000]
["6) Case Management System Licenses",null,"6 x $411.73",null,null,2470.38]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["TOTAL",null,null,null,null,{"$f":"SUM(F38:F45)","v":17470.38}]
[]
["2b. Services and Supplies Narrative: "]
["Each new employee will require a new workstation which includes a laptop and accessories, and a license for the department's case management system."]
["3/29/23 - Year 2 funds added ($4,253.00)"]
["3a. Professional Services"]
["Description of Professional Service(s)",null,"Calculation for Expenditure",null,null,"Total"]
["Alternate Indigent Defense Services",null,"Services rendered on a per case basis not to exceed $126,282.28",null,null,126282.28]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["TOTAL",null,null,null,null,{"$f":"SUM(F53:F60)","v":126282.28}]
[]
["3b. Professional Services Narrative"]
["The County of Fresno currently contracts with a private defense firm for conflict cases and ancilliary/expert reimbursable services."]
["3/29/23 - Year 2 funds added ($151,556.69)"]
["4a. Non-Governmental Organizations (NGO) Subcontracts"]
["Description of Subcontract",null,"Calculation for Expenditure",null,null,"Total"]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["TOTALS",null,null,null,null,{"$f":"SUM(F68:F75)","v":0}]
[]
["4b. Non-Governmental Organizations (NGO) Subcontracts Narrative"]
["Enter narrative here. You may expand cell height if needed."]
["Enter Budget Mod narrative here. You may expand cell hight if needed."]
["5a. Equipment/Fixed Assets"]
["Description of Equipment/Fixed Asset",null,"Calculation for Expense",null,null,"Total"]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["TOTALS",null,null,null,null,{"$f":"SUM(F83:F88)","v":0}]
[]
["5b. Equipment/Fixed Assets Narrative "]
["Enter narrative here. You may expand cell height if needed."]
["Enter Budget Mod narrative here. You may expand cell hight if needed."]
["6a. Project Evaluation"]
["Description",null,"Calculation for Expense",null,null,"Total"]
["Training stipends for employees",null,"3 x $700; 2 x $500; 1 x $100",null,null,3200]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["TOTAL",null,null,null,null,{"$f":"SUM(F96:F101)","v":3200}]
[]
["6b. Project Evaluation Narrative "]
["Each Public Defender employee is allotted a stipend to use for MCLEs, training materials, and/or associated travel. Attorneys are allotted $700/year, Defense Investigators and Social Workers\n$500/year, and Paralegals $100/year."]
["Enter Budget Mod narrative here. You may expand cell hight if needed."]
["7a. Other (Travel, Training, etc.)"]
["Description",null,"Calculation for Expense",null,null,"Total"]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
["TOTAL",null,null,null,null,{"$f":"SUM(F109:F114)","v":0}]
[]
["7b. Other (Travel, Training, etc.) Narrative:"]
["Enter narrative here. You may expand cell height if needed."]
["3/29/23 - Year 2 funds added ($7,145.00)"]
["8a. Indirect Costs"]
["Indirect costs may be charged to grant funds by choosing either Option 1) or 2) listed below:",null,null,null,null,"Total"]
["1) Indirect costs will be charged as Grantee's federally approved Negotiated Indirect Cost Rate (NICR):                                                                   Enter NICR Percentage and Amount:",null,null,null,0]
["2) Indirect costs will be charged as the Federal De Minimis (10% of Modified Total Direct Cost):",null,null,null,null,98152.34]
[" TOTAL",null,null,null,null,{"$f":"SUM(F122,F123)","v":98152.34}]
[]
["8b. Indirect Costs Narrative:"]
["Indirect Costs include administrative personnel hours, security, office supplies, facility operations, and utilities."]
["3/29/23 - Year 2 funds added ($197,558.00)"]
["Before submission, please verify that you have requested the full amount of funding your county is eligible to receive."]

{"sheet":"INVOICE DUE DATES ","index":19,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,0,12,2],[14,0,14,2]]}
["Invoice #","Reporting Period ","Due Date"]
["Invoice 1","March 1, 2022 to June 30, 2022","2022-08-15"]
["Invoice 2","July 1, 2022 to September 30, 2022","2022-11-15"]
["Invoice 3","October 1, 2022 to December 31, 2022","2023-02-15"]
["Invoice 4","January 1, 2023 to March 31, 2023","2023-05-15"]
["Invoice 5","April 1, 2023 to June 30, 2023","2023-08-15"]
["Invoice 6","July 1, 2023 to September 30, 2023","2023-11-15"]
["Invoice 7","October 1, 2023 to December 31, 2023","2024-02-15"]
["Invoice 8","January 1, 2024 to March 31, 2024","2024-05-15"]
["Invoice 9","April 1, 2024 to June 30, 2024","2024-08-15"]
["Invoice 10","July 1, 2024 to September 30, 2024","2024-11-15"]
["Invoice 11","October 1, 2024 to January 1, 2025","2025-02-16"]
["Final Invoicing Periods"]
["Invoice 12*","January 2, 2025 to March 1, 2025*","2025-04-16"]
["*Note: Only expenditures associated with completion of a Final Local Evaluation Report may be included on Invoice 12."]

{"sheet":"INSTRUCTIONS ","index":20,"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 paid out 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."]