{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["MODIFICATION REQUEST","INVOICE 1","INVOICE 2","INVOICE 3","INVOICE 4","INVOICE 5","INVOICE 6","INVOICE 7","INVOICE 8","INVOICE 9","INVOICE 10","INVOICE 11","INVOICE 12","INVOICE 13","INVOICE 14","Project Budget NARRATIVE","INVOICE DUE DATES","INSTRUCTIONS "],"not_rendered":{"charts":0,"images":32,"macros":1,"external_links":0,"defined_names":23,"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":"MODIFICATION REQUEST","index":0,"n_rows":74,"n_cols":17,"rows_kept":74,"cut":false,"hidden":false,"merged":[[60,0,60,3],[73,19,73,20],[73,10,73,13],[72,10,72,13],[62,0,62,2],[72,0,72,1],[68,10,68,16],[69,10,69,16],[64,10,64,16],[65,10,65,16],[66,10,66,16],[67,10,67,16],[61,0,61,3],[19,5,19,8],[33,0,33,16],[53,0,53,2],[34,0,51,16],[54,10,63,16],[53,10,53,16],[32,0,32,16],[19,0,20,0],[19,1,19,4],[19,9,19,12],[19,13,19,16],[55,0,55,3],[56,0,56,3],[57,0,57,3],[58,0,58,3],[59,0,59,3],[17,2,17,3],[0,6,2,9],[5,1,5,4],[5,6,5,9],[5,12,5,14],[7,0,7,16]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STATE OF CALIFORNIA"]
["MODIFICATION REQUEST - (FORM BSCC 223.1 (Revised 04/20)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOARD OF STATE AND COMMUNITY CORRECTIONS"]
[]
[]
[null,"Line-Item Change",null,null,null,null,"Budget Modification",null,null,null,null,null,"Project Income Allocation"]
[null,"Check this box if you are modifying narrative details within a line item (or line items) but not changing the budget.",null,null,null,null,"Check this box if you are modifying line-item dollar amounts by moving funds from one line-item to another.",null,null,null,null,null,"Check this box if you are allocating earned project income."]
[]
["Important Note: You must provide a detailed justification for all modification requests. All modifications require BSCC Field Representative approval.  "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,null,null,null,null,"Grant Program:",null,{"$f":"'INVOICE 1'!B5","v":"Program Name"}]
[null,"14 CALVIP 18",null,null,null,"2021-05-01",null,null,"2021-08-16"]
["Address",null,null,null,null,null,null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
[]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,null,null,null,null,null,null,null,null,"Modification Request #",1]
[]
["Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},{"$f":"'INVOICE 1'!G9","v":"TO"},null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,null,null,null,"Effective on Invoice #",1]
[]
["Line Items","Current Budget",null,null,null,"Available Budget",null,null,null,"Changes (+/-)",null,null,null,"Modified Budget"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
["Salaries & Benefits",89578,0,340797,{"$f":"SUM(B22:D22)","v":430375},89578,0,340797,{"$f":"SUM(F22:H22)","v":430375},70422,270584,-340797,{"$f":"SUM(J22:L22)","v":209},{"$f":"SUM(B22,J22)","v":160000},{"$f":"SUM(C22,K22)","v":270584},0,{"$f":"SUM(N22:P22)","v":430584}]
["Services & Supplies",5325,0,0,5325,5325,0,0,5325,9000,0,0,{"$f":"SUM(J23:L23)","v":9000},14325,0,0,{"$f":"SUM(N23:P23)","v":14325}]
["Professional Services",5000,0,0,5000,5000,0,0,5000,44626,0,0,44626,49626,0,0,49626]
["CBO Subcontracts",117642,0,0,117642,117642,0,0,117642,131089,0,0,131089,248731,0,0,248731]
["Indirect Costs",8958,0,34080,43038,8958,0,34080,43038,7042,27058,-34080,20,16000,27058,0,43058]
["Fixed Assets/Equipment",0,0,0,0,0,0,10000,10000,0,0,0,0,0,0,0,0]
["Project Evaluation ",0,0,10000,10000,0,0,0,0,0,0,0,0,0,0,10000,10000]
["Other",8780,0,96000,104780,8780,0,96000,104780,0,0,101699,101699,8780,0,197699,206479]
["TOTAL",{"$f":"SUM(B22:B29)","v":235283},0,480877,716160,{"$f":"SUM(F22:F29)","v":235283},0,480877,716160,0,0,null,{"$f":"SUM(M22:M29)","v":286643},497462,297642,207699,1002803]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 2'!E25","v":0},null,null,"Prior allocated income",{"$f":"'INVOICE 2'!I25","v":0},null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E32-L32","v":0}]
[]
["JUSTIFICATION FOR MODIFICATION:"]
["The City of Pasadena's original grant project was partially funded with FY 17 grant funds and then amended to add FY 18 grant funds to the fully the project as requester in the original grant proposal. This budget modificaiton augments the City of Pasadena's project budget by $262,179 to a total of $497,462. This budget modification was prepared and approved by BSCC Staff."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PERSON PREPARING REPORT",null,null,null,null,null,null,null,null,null,"AUTHORIZED FINANCIAL OFFICER"]
[null,null,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."]
["Angela Ardisana"]
["Name, Title"]
["(916)323-8580"]
["Phone"]
["angela.ardisana@bscc.ca.gov"]
["Email"]
["2019-05-14"]
["Date"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-05-30",null,null,null,null,null,null,"Approved By:","Colleen Curtin",null,null,null,"Date:","2019-05-22"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 1","index":1,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[39,1,39,2],[56,0,56,2],[49,4,49,13],[50,4,50,13],[56,13,56,16],[56,5,56,10],[54,1,54,2],[55,0,55,2],[52,1,52,2],[41,4,41,13],[64,0,64,3],[58,13,58,17],[59,13,59,17],[60,13,60,17],[61,13,61,17],[62,13,62,17],[63,13,63,17],[64,13,64,17],[45,4,45,13],[53,1,53,2],[52,0,54,0],[49,14,49,16],[50,14,50,16],[52,14,52,16],[43,0,45,0],[46,0,48,0],[49,0,51,0],[55,4,55,13],[43,4,43,13],[46,14,46,16],[76,0,76,9],[74,0,74,16],[69,5,69,10],[65,0,65,2],[70,5,70,10],[75,0,75,1],[75,8,75,9],[65,13,65,16],[67,5,67,10],[57,5,66,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16],[57,0,57,2],[76,10,76,13],[58,0,58,3],[68,5,68,10],[59,0,59,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[53,14,53,16],[52,4,52,13],[53,4,53,13],[46,4,46,13],[47,4,47,13],[48,4,48,13],[51,4,51,13],[49,1,49,2],[50,1,50,2],[51,1,51,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[47,14,47,16],[44,14,44,16],[40,4,40,13],[12,0,13,0],[12,1,12,4],[12,5,12,8],[25,0,25,16],[30,4,30,13],[29,0,29,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[41,14,41,16],[31,0,33,0],[34,0,36,0],[37,0,39,0],[40,0,42,0],[39,14,39,16],[12,9,12,12],[12,13,12,16],[33,14,33,16],[36,4,36,13],[37,4,37,13],[36,14,36,16],[8,6,8,7],[10,6,10,7],[0,6,2,9],[0,14,0,16],[4,12,6,16],[31,4,31,13],[32,4,32,13],[34,4,34,13],[35,4,35,13],[33,4,33,13],[30,14,30,16],[31,14,31,16],[32,14,32,16],[34,14,34,16],[1,14,1,15],[35,14,35,16],[37,14,37,16],[55,14,55,16],[54,4,54,13],[54,14,54,16],[51,14,51,16],[48,14,48,16],[42,14,42,16],[45,14,45,16],[44,4,44,13],[38,14,38,16],[40,14,40,16],[43,14,43,16],[38,4,38,13],[39,4,39,13],[42,4,42,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000001824"]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:","Program Name",null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:","City of Pasadena Public Health Department",null,null,null,null,"Lead Public Agency:",null,"City of Pasadena Public Health Department"]
[]
["Contract #:","853-17",null,null,"Term:","2018-05-01","TO",null,"2021-08-15",null,null,null,null,"Invoicing Frequency","Quarterly"]
[]
["Invoice #:","1 CALVIP 18",null,null,"Reporting Period:","2018-05-01","TO",null,"2018-06-30","Due:","2018-08-15",null,null,"Final Invoice (Y/N):","No"]
[null,null,null,null,null,5]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
["Salaries & Benefits",160000,270584,0,430584,0,0,0,{"$f":"SUM(F15:H15)","v":0},0,3690,0,{"$f":"SUM(J15:L15)","v":3690},{"$f":"B15-F15-J15","v":160000},{"$f":"C15-G15-K15","v":266894},0,{"$f":"SUM(N15:P15)","v":426894}]
["Services & Supplies",14325,0,0,14325,0,0,0,{"$f":"SUM(F16:H16)","v":0},0,0,0,{"$f":"SUM(J16:L16)","v":0},14325,0,0,{"$f":"SUM(N16:P16)","v":14325}]
["Prof Services / Public Agency Subcontracts",49626,0,0,49626,0,0,0,0,0,0,0,0,49626,0,0,49626]
["CBO Subcontracts",248731,0,0,248731,0,0,0,0,0,0,0,0,248731,0,0,248731]
["Indirect Costs",16000,27058,0,43058,0,0,0,{"$f":"SUM(F19:H19)","v":0},0,0,0,{"$f":"SUM(J19:L19)","v":0},{"$f":"B19-F19-J19","v":16000},{"$f":"C19-G19-K19","v":27058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":43058}]
["Fixed Assets/Equipment",0,0,0,10000,0,0,0,0,0,0,0,0,0,0,0,0]
["Project Evaluation",0,0,10000,0,0,0,0,0,0,0,0,0,0,0,10000,10000]
["Other",8780,0,197699,206479,0,0,0,0,0,0,1264,1264,8780,0,196435,205215]
["TOTAL",497462,297642,207699,1002803,{"$f":"SUM(F15:F22)","v":0},0,0,0,0,3690,1264,4954,497462,293952,206435,997849]
[]
["Project Income",null,null,"Income reported to date",{"$f":"L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":0},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":0},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":3690},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":1.2397443909125729E-2}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":0}]
[null,"Cash Match",null,{"$f":"K15","v":3690},"Angelica Palmeros in-kind salaries for time spent on program. $2432.Angelica Palmeros in-kind benefits for time spent on program. $2432."]
[null,"In-kind Match",null,{"$f":"L15","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":0}]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":0}]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":0}]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J20","v":0}]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"L21","v":0}]
["Project Evaluation","Grant Funds",null,{"$f":"J22","v":0}]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match"]
["Other","Grant Funds",null,{"$f":"J19","v":0}]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,1264,"trsvel for training A. Palmeros and I. Olmedo $1,265"]
["Project Income",null,null,{"$f":"Q25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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."]
["Genevieve Chu, Senior Accountant",null,null,null,null,null,null,null,null,null,null,null,null,"0000042790"]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,"Supplier ID"]
["(626) 744-6397",null,null,null,null,null,null,null,null,null,null,null,null,"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,"Supplier Name"]
["gchu@cityofpasadena.net",null,null,null,null,null,null,null,null,null,null,null,null,"1845 N FAIR OAKS AVE"]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,"Address Line 1"]
["2019-04-30",null,null,null,null,null,null,null,null,null,null,null,null,"PASADENA, CA 91103"]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,"Address Line 2"]
[]
[null,null,null,null,null,"Manuel Carmona, Management Analyst V"]
[null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,"(626) 744-6122"]
[null,null,null,null,null,"Phone"]
[null,null,null,null,null,"2019-04-30"]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2019-05-30",null,null,null,null,null,"Approved By:",null,"Colleen Curtin",null,null,null,"Date:","2019-05-31"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 2","index":2,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[1,14,1,15],[76,0,76,9],[72,0,72,2],[72,5,72,10],[72,13,72,16],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,10,76,13],[71,13,71,16],[63,13,63,16],[64,13,64,16],[65,0,65,2],[65,13,65,16],[67,5,67,10],[68,5,68,10],[69,5,69,10],[70,5,70,10],[71,5,71,10],[46,4,46,13],[56,13,56,16],[46,0,48,0],[46,1,46,2],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[50,14,50,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[51,1,51,2],[57,0,57,2],[57,5,66,10],[58,13,58,16],[59,13,59,16],[60,13,60,16],[61,13,61,16],[62,13,62,16],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[58,0,58,3],[59,0,59,3],[60,0,60,3],[56,0,56,2],[56,5,56,10],[43,4,43,13],[43,14,43,16],[44,4,44,13],[44,14,44,16],[43,0,45,0],[43,1,43,2],[44,1,44,2],[45,1,45,2],[41,4,41,13],[41,14,41,16],[42,4,42,13],[42,14,42,16],[45,4,45,13],[45,14,45,16],[39,4,39,13],[39,14,39,16],[40,4,40,13],[40,14,40,16],[37,0,39,0],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,0,42,0],[40,1,40,2],[41,1,41,2],[42,1,42,2],[37,4,37,13],[37,14,37,16],[38,4,38,13],[38,14,38,16],[0,6,2,9],[0,14,0,16],[4,12,6,16],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[25,0,25,16],[8,6,8,7],[10,6,10,7],[36,1,36,2],[33,4,33,13],[33,14,33,16],[34,4,34,13],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,4,31,13],[31,14,31,16],[32,4,32,13],[32,14,32,16],[31,0,33,0],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,14,34,16],[35,4,35,13],[35,14,35,16],[36,4,36,13],[36,14,36,16],[34,0,36,0],[34,1,34,2],[35,1,35,2]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000001824",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:","City of Pasadena Public Health Department",null,null,null,null,"Lead Public Agency:",null,"City of Pasadena Public Health Department"]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","2 CALVIP 18",null,null,"Reporting Period:","2021-07-01","TO",null,"2021-09-30","Due:","2018-11-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 1'!B15","v":160000},{"$f":"'INVOICE 1'!C15","v":270584},{"$f":"'INVOICE 1'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 1'!F15,'INVOICE 1'!J15)","v":0},{"$f":"SUM('INVOICE 1'!G15,'INVOICE 1'!K15)","v":3690},{"$f":"SUM('INVOICE 1'!H15,'INVOICE 1'!L15)","v":0},{"$f":"SUM(F15:H15)","v":3690},0,1748,0,{"$f":"SUM(J15:L15)","v":1748},{"$f":"B15-F15-J15","v":160000},265146,0,{"$f":"SUM(N15:P15)","v":425146}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 1'!B16","v":14325},{"$f":"'INVOICE 1'!C16","v":0},{"$f":"'INVOICE 1'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 1'!F16,'INVOICE 1'!J16)","v":0},{"$f":"SUM('INVOICE 1'!G16,'INVOICE 1'!K16)","v":0},{"$f":"SUM('INVOICE 1'!H16,'INVOICE 1'!L16)","v":0},{"$f":"SUM(F16:H16)","v":0},0,0,0,{"$f":"SUM(J16:L16)","v":0},14325,0,0,{"$f":"SUM(N16:P16)","v":14325}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 1'!B17","v":49626},{"$f":"'INVOICE 1'!C17","v":0},{"$f":"'INVOICE 1'!D17","v":0},49626,{"$f":"SUM('INVOICE 1'!F17,'INVOICE 1'!J17)","v":0},{"$f":"SUM('INVOICE 1'!G17,'INVOICE 1'!K17)","v":0},{"$f":"SUM('INVOICE 1'!H17,'INVOICE 1'!L17)","v":0},0,0,0,0,0,49626,0,0,49626]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 1'!B18","v":248731},{"$f":"'INVOICE 1'!C18","v":0},{"$f":"'INVOICE 1'!D18","v":0},248731,{"$f":"SUM('INVOICE 1'!F18,'INVOICE 1'!J18)","v":0},{"$f":"SUM('INVOICE 1'!G18,'INVOICE 1'!K18)","v":0},{"$f":"SUM('INVOICE 1'!H18,'INVOICE 1'!L18)","v":0},0,0,0,0,0,248731,0,0,248731]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 1'!B19","v":16000},{"$f":"'INVOICE 1'!C19","v":27058},{"$f":"'INVOICE 1'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 1'!F19,'INVOICE 1'!J19)","v":0},{"$f":"SUM('INVOICE 1'!G19,'INVOICE 1'!K19)","v":0},{"$f":"SUM('INVOICE 1'!H19,'INVOICE 1'!L19)","v":0},{"$f":"SUM(F19:H19)","v":0},0,0,0,{"$f":"SUM(J19:L19)","v":0},{"$f":"B19-F19-J19","v":16000},{"$f":"C19-G19-K19","v":27058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":43058}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 1'!B20","v":0},{"$f":"'INVOICE 1'!C20","v":0},{"$f":"'INVOICE 1'!D20","v":0},0,{"$f":"SUM('INVOICE 1'!F20,'INVOICE 1'!J20)","v":0},{"$f":"SUM('INVOICE 1'!G20,'INVOICE 1'!K20)","v":0},{"$f":"SUM('INVOICE 1'!H20,'INVOICE 1'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 1'!B21","v":0},{"$f":"'INVOICE 1'!C21","v":0},{"$f":"'INVOICE 1'!D21","v":10000},10000,{"$f":"SUM('INVOICE 1'!F21,'INVOICE 1'!J21)","v":0},{"$f":"SUM('INVOICE 1'!G21,'INVOICE 1'!K21)","v":0},{"$f":"SUM('INVOICE 1'!H21,'INVOICE 1'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 1'!B22","v":8780},{"$f":"'INVOICE 1'!C22","v":0},{"$f":"'INVOICE 1'!D22","v":197699},206479,{"$f":"SUM('INVOICE 1'!F22,'INVOICE 1'!J22)","v":0},{"$f":"SUM('INVOICE 1'!G22,'INVOICE 1'!K22)","v":0},{"$f":"SUM('INVOICE 1'!H22,'INVOICE 1'!L22)","v":1264},1264,0,0,0,0,8780,0,196435,205215]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,0,3690,1264,4954,0,1748,0,1748,497462,292204,206435,996101]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 2'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":0},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":0},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":5438},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":1.8270270996700734E-2}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":0}]
[null,"Cash Match",null,{"$f":"K15","v":1748},"Angelica Palmeros salaries for time spent on program. $1,152.Angelica Palmeros benefits for time spent on program. $596.."]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":0}]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":0}]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":0}]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J20","v":0}]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,{"$f":"J22","v":0}]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,{"$f":"J19","v":0}]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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."]
["Genevieve Chu, Senior Accountant",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
["(626) 744-6397",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
["gchu@cityofpasadena.net",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
["2019-04-30",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[null,null,null,null,null,"Manuel Carmona, Management Analyst V"]
[null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,"(626) 744-6122"]
[null,null,null,null,null,"Phone"]
[null,null,null,null,null,"2019-04-30"]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2019-05-30",null,null,null,null,null,"Approved By:",null,"Colleen Curtin ",null,null,null,"Date:","2019-05-31"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 3","index":3,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[8,6,8,7],[10,6,10,7],[1,14,1,15],[25,0,25,16],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[56,0,56,2],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,13,58,16],[59,13,59,16],[64,13,64,16],[65,0,65,2],[65,13,65,16],[58,0,58,3],[59,0,59,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,13,61,16],[62,13,62,16],[63,13,63,16],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000001824",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","3 CALVIP 18",null,null,"Reporting Period:","2018-10-01","TO",null,"2018-12-31","Due:","2019-02-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 2'!B15","v":160000},{"$f":"'INVOICE 2'!C15","v":270584},{"$f":"'INVOICE 2'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 2'!F15,'INVOICE 2'!J15)","v":0},{"$f":"SUM('INVOICE 2'!G15,'INVOICE 2'!K15)","v":5438},{"$f":"SUM('INVOICE 2'!H15,'INVOICE 2'!L15)","v":0},{"$f":"SUM(F15:H15)","v":5438},0,2282,0,{"$f":"SUM(J15:L15)","v":2282},{"$f":"B15-F15-J15","v":160000},262864,0,{"$f":"SUM(N15:P15)","v":422864}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 2'!B16","v":14325},{"$f":"'INVOICE 2'!C16","v":0},{"$f":"'INVOICE 2'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 2'!F16,'INVOICE 2'!J16)","v":0},{"$f":"SUM('INVOICE 2'!G16,'INVOICE 2'!K16)","v":0},{"$f":"SUM('INVOICE 2'!H16,'INVOICE 2'!L16)","v":0},{"$f":"SUM(F16:H16)","v":0},0,0,0,{"$f":"SUM(J16:L16)","v":0},14325,0,0,{"$f":"SUM(N16:P16)","v":14325}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 2'!B17","v":49626},{"$f":"'INVOICE 2'!C17","v":0},{"$f":"'INVOICE 2'!D17","v":0},49626,{"$f":"SUM('INVOICE 2'!F17,'INVOICE 2'!J17)","v":0},{"$f":"SUM('INVOICE 2'!G17,'INVOICE 2'!K17)","v":0},{"$f":"SUM('INVOICE 2'!H17,'INVOICE 2'!L17)","v":0},0,0,0,0,0,49626,0,0,49626]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 2'!B18","v":248731},{"$f":"'INVOICE 2'!C18","v":0},{"$f":"'INVOICE 2'!D18","v":0},248731,{"$f":"SUM('INVOICE 2'!F18,'INVOICE 2'!J18)","v":0},{"$f":"SUM('INVOICE 2'!G18,'INVOICE 2'!K18)","v":0},{"$f":"SUM('INVOICE 2'!H18,'INVOICE 2'!L18)","v":0},0,0,0,0,0,248731,0,0,248731]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 2'!B19","v":16000},{"$f":"'INVOICE 2'!C19","v":27058},{"$f":"'INVOICE 2'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 2'!F19,'INVOICE 2'!J19)","v":0},{"$f":"SUM('INVOICE 2'!G19,'INVOICE 2'!K19)","v":0},{"$f":"SUM('INVOICE 2'!H19,'INVOICE 2'!L19)","v":0},{"$f":"SUM(F19:H19)","v":0},0,0,0,{"$f":"SUM(J19:L19)","v":0},{"$f":"B19-F19-J19","v":16000},{"$f":"C19-G19-K19","v":27058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":43058}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 2'!B20","v":0},{"$f":"'INVOICE 2'!C20","v":0},{"$f":"'INVOICE 2'!D20","v":0},0,{"$f":"SUM('INVOICE 2'!F20,'INVOICE 2'!J20)","v":0},{"$f":"SUM('INVOICE 2'!G20,'INVOICE 2'!K20)","v":0},{"$f":"SUM('INVOICE 2'!H20,'INVOICE 2'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 2'!B21","v":0},{"$f":"'INVOICE 2'!C21","v":0},{"$f":"'INVOICE 2'!D21","v":10000},10000,{"$f":"SUM('INVOICE 2'!F21,'INVOICE 2'!J21)","v":0},{"$f":"SUM('INVOICE 2'!G21,'INVOICE 2'!K21)","v":0},{"$f":"SUM('INVOICE 2'!H21,'INVOICE 2'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 2'!B22","v":8780},{"$f":"'INVOICE 2'!C22","v":0},{"$f":"'INVOICE 2'!D22","v":197699},206479,{"$f":"SUM('INVOICE 2'!F22,'INVOICE 2'!J22)","v":0},{"$f":"SUM('INVOICE 2'!G22,'INVOICE 2'!K22)","v":0},{"$f":"SUM('INVOICE 2'!H22,'INVOICE 2'!L22)","v":1264},1264,0,0,0,0,8780,0,196435,205215]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,0,5438,1264,6702,0,2282,0,2282,497462,289922,206435,993819]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 3'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":0},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":0},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":7720},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":2.5937199723157351E-2}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":0}]
[null,"Cash Match",null,{"$f":"K15","v":2282},"Angelica Palmeros in-kind salaries for time spent on program. $1,504. Angelica Palmeros in-kind benefits for time spent on program. $778.."]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":0}]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":0}]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":0}]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J20","v":0}]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,{"$f":"J22","v":0}]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,{"$f":"J19","v":0}]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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."]
["Genevieve Chu, Senior Accountant",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
["(626) 744-6397",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
["gchu@cityofpasadena.net",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
["2019-04-30",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 2'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[null,null,null,null,null,"Manuel Carmona, Management Analyst V"]
[null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,"(626) 744-6122"]
[null,null,null,null,null,"Phone"]
[null,null,null,null,null,"2019-04-30"]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2019-05-30",null,null,null,null,null,"Approved By:",null,"Colleen Curtin",null,null,null,"Date:","2019-05-31"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 4","index":4,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[25,0,25,16],[1,14,1,15],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,13,58,16],[59,13,59,16],[58,0,58,3],[59,0,59,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[8,6,8,7],[10,6,10,7],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16],[64,13,64,16],[65,0,65,2],[65,13,65,16],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,13,61,16],[62,13,62,16],[63,13,63,16],[56,0,56,2]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000001824",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","4 CALVIP 18",null,null,"Reporting Period:","2019-01-01","TO",null,"2019-03-31","Due:","2019-08-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 3'!B15","v":160000},{"$f":"'INVOICE 3'!C15","v":270584},{"$f":"'INVOICE 3'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 3'!F15,'INVOICE 3'!J15)","v":0},{"$f":"SUM('INVOICE 3'!G15,'INVOICE 3'!K15)","v":7720},{"$f":"SUM('INVOICE 3'!H15,'INVOICE 3'!L15)","v":0},{"$f":"SUM(F15:H15)","v":7720},2350,20331,0,{"$f":"SUM(J15:L15)","v":22681},{"$f":"B15-F15-J15","v":157650},242533,0,{"$f":"SUM(N15:P15)","v":400183}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 3'!B16","v":14325},{"$f":"'INVOICE 3'!C16","v":0},{"$f":"'INVOICE 3'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 3'!F16,'INVOICE 3'!J16)","v":0},{"$f":"SUM('INVOICE 3'!G16,'INVOICE 3'!K16)","v":0},{"$f":"SUM('INVOICE 3'!H16,'INVOICE 3'!L16)","v":0},{"$f":"SUM(F16:H16)","v":0},0,0,0,{"$f":"SUM(J16:L16)","v":0},14325,0,0,{"$f":"SUM(N16:P16)","v":14325}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 3'!B17","v":49626},{"$f":"'INVOICE 3'!C17","v":0},{"$f":"'INVOICE 3'!D17","v":0},49626,{"$f":"SUM('INVOICE 3'!F17,'INVOICE 3'!J17)","v":0},{"$f":"SUM('INVOICE 3'!G17,'INVOICE 3'!K17)","v":0},{"$f":"SUM('INVOICE 3'!H17,'INVOICE 3'!L17)","v":0},0,15000,0,0,15000,34626,0,0,34626]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 3'!B18","v":248731},{"$f":"'INVOICE 3'!C18","v":0},{"$f":"'INVOICE 3'!D18","v":0},248731,{"$f":"SUM('INVOICE 3'!F18,'INVOICE 3'!J18)","v":0},{"$f":"SUM('INVOICE 3'!G18,'INVOICE 3'!K18)","v":0},{"$f":"SUM('INVOICE 3'!H18,'INVOICE 3'!L18)","v":0},0,0,0,0,0,248731,0,0,248731]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 3'!B19","v":16000},{"$f":"'INVOICE 3'!C19","v":27058},{"$f":"'INVOICE 3'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 3'!F19,'INVOICE 3'!J19)","v":0},{"$f":"SUM('INVOICE 3'!G19,'INVOICE 3'!K19)","v":0},{"$f":"SUM('INVOICE 3'!H19,'INVOICE 3'!L19)","v":0},{"$f":"SUM(F19:H19)","v":0},235,0,0,{"$f":"SUM(J19:L19)","v":235},{"$f":"B19-F19-J19","v":15765},{"$f":"C19-G19-K19","v":27058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":42823}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 3'!B20","v":0},{"$f":"'INVOICE 3'!C20","v":0},{"$f":"'INVOICE 3'!D20","v":0},0,{"$f":"SUM('INVOICE 3'!F20,'INVOICE 3'!J20)","v":0},{"$f":"SUM('INVOICE 3'!G20,'INVOICE 3'!K20)","v":0},{"$f":"SUM('INVOICE 3'!H20,'INVOICE 3'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 3'!B21","v":0},{"$f":"'INVOICE 3'!C21","v":0},{"$f":"'INVOICE 3'!D21","v":10000},10000,{"$f":"SUM('INVOICE 3'!F21,'INVOICE 3'!J21)","v":0},{"$f":"SUM('INVOICE 3'!G21,'INVOICE 3'!K21)","v":0},{"$f":"SUM('INVOICE 3'!H21,'INVOICE 3'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 3'!B22","v":8780},{"$f":"'INVOICE 3'!C22","v":0},{"$f":"'INVOICE 3'!D22","v":197699},206479,{"$f":"SUM('INVOICE 3'!F22,'INVOICE 3'!J22)","v":0},{"$f":"SUM('INVOICE 3'!G22,'INVOICE 3'!K22)","v":0},{"$f":"SUM('INVOICE 3'!H22,'INVOICE 3'!L22)","v":1264},1264,1311,0,0,1311,7469,0,196435,203904]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,0,7720,1264,8984,18896,20331,0,39227,478566,269591,206435,954592]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 4'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":18896},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":18896},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":3.7984810900129055E-2}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":28051},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":9.4244091895633014E-2}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,".",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":2350},"Grant Administrator's .05 FTE for 3 months= $2,350"]
[null,"Cash Match",null,{"$f":"K15","v":20331},"Division Manager salaries and benefits for time spent on program $1,812 for Q4..2 Social workers A 161 hrs x 29.74 = $4,788 one month and B three months    496 hrs x $29.74 = $14,751.Correction Division Manager cash-match salaries & benefits for time spent on program for Q1 - Q3, incorrect hourly rate ($1,021).."]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":0}]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":15000},"Five days of Police Department Staff training.  Why'd You Stop Me? $15,000.."]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":0}]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,235,"10% of salaries and benefits"]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,0]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,1311,"2019 Gang Prevention & Intervention Conference, Long Beach, CA 7 tickets"]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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."]
["Genevieve Chu, Senior Accountant",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
["(626) 744-6397",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
["gchu@cityofpasadena.net",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
["2019-06-27",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 3'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[null,null,null,null,null,"Manuel Carmona, Management Analyst V"]
[null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,"(626) 744-6122"]
[null,null,null,null,null,"Phone"]
[null,null,null,null,null,"2019-06-27"]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2019-07-03",null,null,null,null,null,"Approved By:",null,"Colleen Curtin",null,null,null,"Date:","2019-07-17"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 5","index":5,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[25,0,25,16],[1,14,1,15],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,13,58,16],[59,13,59,16],[58,0,58,3],[59,0,59,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[8,6,8,7],[10,6,10,7],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16],[64,13,64,16],[65,0,65,2],[65,13,65,16],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,13,61,16],[62,13,62,16],[63,13,63,16],[56,0,56,2]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000001824",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","5 CALVIP 18",null,null,"Reporting Period:","2019-04-01","TO",null,"2019-06-30","Due:","2020-08-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 4'!B15","v":160000},{"$f":"'INVOICE 4'!C15","v":270584},{"$f":"'INVOICE 4'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 4'!F15,'INVOICE 4'!J15)","v":2350},{"$f":"SUM('INVOICE 4'!G15,'INVOICE 4'!K15)","v":28051},{"$f":"SUM('INVOICE 4'!H15,'INVOICE 4'!L15)","v":0},{"$f":"SUM(F15:H15)","v":30401},2025,26785,0,{"$f":"SUM(J15:L15)","v":28810},{"$f":"B15-F15-J15","v":155625},215748,0,{"$f":"SUM(N15:P15)","v":371373}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 4'!B16","v":14325},{"$f":"'INVOICE 4'!C16","v":0},{"$f":"'INVOICE 4'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 4'!F16,'INVOICE 4'!J16)","v":0},{"$f":"SUM('INVOICE 4'!G16,'INVOICE 4'!K16)","v":0},{"$f":"SUM('INVOICE 4'!H16,'INVOICE 4'!L16)","v":0},{"$f":"SUM(F16:H16)","v":0},0,0,0,{"$f":"SUM(J16:L16)","v":0},14325,0,0,{"$f":"SUM(N16:P16)","v":14325}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 4'!B17","v":49626},{"$f":"'INVOICE 4'!C17","v":0},{"$f":"'INVOICE 4'!D17","v":0},49626,{"$f":"SUM('INVOICE 4'!F17,'INVOICE 4'!J17)","v":15000},{"$f":"SUM('INVOICE 4'!G17,'INVOICE 4'!K17)","v":0},{"$f":"SUM('INVOICE 4'!H17,'INVOICE 4'!L17)","v":0},15000,0,0,0,0,34626,0,0,34626]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 4'!B18","v":248731},{"$f":"'INVOICE 4'!C18","v":0},{"$f":"'INVOICE 4'!D18","v":0},248731,{"$f":"SUM('INVOICE 4'!F18,'INVOICE 4'!J18)","v":0},{"$f":"SUM('INVOICE 4'!G18,'INVOICE 4'!K18)","v":0},{"$f":"SUM('INVOICE 4'!H18,'INVOICE 4'!L18)","v":0},0,4748,0,0,4748,243983,0,0,243983]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 4'!B19","v":16000},{"$f":"'INVOICE 4'!C19","v":27058},{"$f":"'INVOICE 4'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 4'!F19,'INVOICE 4'!J19)","v":235},{"$f":"SUM('INVOICE 4'!G19,'INVOICE 4'!K19)","v":0},{"$f":"SUM('INVOICE 4'!H19,'INVOICE 4'!L19)","v":0},{"$f":"SUM(F19:H19)","v":235},203,0,0,{"$f":"SUM(J19:L19)","v":203},{"$f":"B19-F19-J19","v":15562},{"$f":"C19-G19-K19","v":27058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":42620}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 4'!B20","v":0},{"$f":"'INVOICE 4'!C20","v":0},{"$f":"'INVOICE 4'!D20","v":0},0,{"$f":"SUM('INVOICE 4'!F20,'INVOICE 4'!J20)","v":0},{"$f":"SUM('INVOICE 4'!G20,'INVOICE 4'!K20)","v":0},{"$f":"SUM('INVOICE 4'!H20,'INVOICE 4'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 4'!B21","v":0},{"$f":"'INVOICE 4'!C21","v":0},{"$f":"'INVOICE 4'!D21","v":10000},10000,{"$f":"SUM('INVOICE 4'!F21,'INVOICE 4'!J21)","v":0},{"$f":"SUM('INVOICE 4'!G21,'INVOICE 4'!K21)","v":0},{"$f":"SUM('INVOICE 4'!H21,'INVOICE 4'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 4'!B22","v":8780},{"$f":"'INVOICE 4'!C22","v":0},{"$f":"'INVOICE 4'!D22","v":197699},206479,{"$f":"SUM('INVOICE 4'!F22,'INVOICE 4'!J22)","v":1311},{"$f":"SUM('INVOICE 4'!G22,'INVOICE 4'!K22)","v":0},{"$f":"SUM('INVOICE 4'!H22,'INVOICE 4'!L22)","v":1264},2575,1049,0,0,1049,6420,0,196435,202855]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,18896,28051,1264,48211,8025,26785,0,34810,470541,242806,206435,919782]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 5'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":26921},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":8025},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":5.4116696350676029E-2}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":54836},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":0.18423475181593996}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":2025},"Grant Administrator's .05 FTE for 3 months - 54.4hrs x 24.46 = $1,331 + $694.14 benefits = $2,.025."]
[null,"Cash Match",null,{"$f":"K15","v":26785},"Division Mngr sal & ben for time spent on program $11,798.70 for Q5.  140 hrs x 55.54 = $7,776.60 + $4,023.10 ben = $11,798.70., Dir/Hlth Offcr sal & ben for time spent on prog $4,661.13 for Q5. 31 hrs x 99.09= $3,071.79+$1,589.34 ben =$4,661.13..CSR III sal & ben spent for time spent on prog $3,247.92 for Q5. 156 hrs x 20.82 = 3,247.92 - 2 Social Wrkr @ $2,141.28 ea. (72hrs x 29.74 = 2,141).Admin Specialist sal and benefits for time spent on program $2,794.81 for Q5. 77hrs x 23.92 =$1,841.84 + 952.97 ben = 2,794.81 "]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":0}]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":0}]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":4748},"Harvest Ministries community exp period 6/11-6/30/19 - CALVIP community based advocacy = 4,747.71"]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J19","v":203},"10% of salaries and benefits - 10% of 2,025 = 202.50"]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds"]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,1049,"Staff training lunch - Subway Catering meal = 1,048.50 - Invoice #18149749-39 PAID"]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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."]
["Genevieve Chu, Senior Accountant",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
["(626) 744-6397",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
["gchu@cityofpasadena.net",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
["2019-08-03",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 4'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[null,null,null,null,null,"Manuel Carmona, Management Analyst V"]
[null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,"(626) 744-6122"]
[null,null,null,null,null,"Phone"]
[null,null,null,null,null,"2019-08-09"]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2019-08-12",null,null,null,null,null,"Approved By:",null,"Colleen Curtin",null,null,null,"Date:","2019-08-14"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 6","index":6,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[8,6,8,7],[10,6,10,7],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[1,14,1,15],[25,0,25,16],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[56,0,56,2],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,13,58,16],[59,13,59,16],[64,13,64,16],[65,0,65,2],[65,13,65,16],[58,0,58,3],[59,0,59,3],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,13,61,16],[62,13,62,16],[63,13,63,16],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000001824",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:","CalVIP -17",null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","6 CALVIP 18",null,null,"Reporting Period:","2019-07-01","TO",null,"2019-09-30","Due:","2019-09-30",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 5'!B15","v":160000},{"$f":"'INVOICE 5'!C15","v":270584},{"$f":"'INVOICE 5'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 5'!F15,'INVOICE 5'!J15)","v":4375},{"$f":"SUM('INVOICE 5'!G15,'INVOICE 5'!K15)","v":54836},{"$f":"SUM('INVOICE 5'!H15,'INVOICE 5'!L15)","v":0},{"$f":"SUM(F15:H15)","v":59211},15246,24478,0,{"$f":"SUM(J15:L15)","v":39724},{"$f":"B15-F15-J15","v":140379},191270,0,{"$f":"SUM(N15:P15)","v":331649}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 5'!B16","v":14325},{"$f":"'INVOICE 5'!C16","v":0},{"$f":"'INVOICE 5'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 5'!F16,'INVOICE 5'!J16)","v":0},{"$f":"SUM('INVOICE 5'!G16,'INVOICE 5'!K16)","v":0},{"$f":"SUM('INVOICE 5'!H16,'INVOICE 5'!L16)","v":0},{"$f":"SUM(F16:H16)","v":0},164,0,0,{"$f":"SUM(J16:L16)","v":164},14161,0,0,{"$f":"SUM(N16:P16)","v":14161}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 5'!B17","v":49626},{"$f":"'INVOICE 5'!C17","v":0},{"$f":"'INVOICE 5'!D17","v":0},49626,{"$f":"SUM('INVOICE 5'!F17,'INVOICE 5'!J17)","v":15000},{"$f":"SUM('INVOICE 5'!G17,'INVOICE 5'!K17)","v":0},{"$f":"SUM('INVOICE 5'!H17,'INVOICE 5'!L17)","v":0},15000,24278,0,0,24278,10348,0,0,10348]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 5'!B18","v":248731},{"$f":"'INVOICE 5'!C18","v":0},{"$f":"'INVOICE 5'!D18","v":0},248731,{"$f":"SUM('INVOICE 5'!F18,'INVOICE 5'!J18)","v":4748},{"$f":"SUM('INVOICE 5'!G18,'INVOICE 5'!K18)","v":0},{"$f":"SUM('INVOICE 5'!H18,'INVOICE 5'!L18)","v":0},4748,36805,0,0,36805,207178,0,0,207178]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 5'!B19","v":16000},{"$f":"'INVOICE 5'!C19","v":27058},{"$f":"'INVOICE 5'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 5'!F19,'INVOICE 5'!J19)","v":438},{"$f":"SUM('INVOICE 5'!G19,'INVOICE 5'!K19)","v":0},{"$f":"SUM('INVOICE 5'!H19,'INVOICE 5'!L19)","v":0},{"$f":"SUM(F19:H19)","v":438},1552,0,0,{"$f":"SUM(J19:L19)","v":1552},{"$f":"B19-F19-J19","v":14010},{"$f":"C19-G19-K19","v":27058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":41068}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 5'!B20","v":0},{"$f":"'INVOICE 5'!C20","v":0},{"$f":"'INVOICE 5'!D20","v":0},0,{"$f":"SUM('INVOICE 5'!F20,'INVOICE 5'!J20)","v":0},{"$f":"SUM('INVOICE 5'!G20,'INVOICE 5'!K20)","v":0},{"$f":"SUM('INVOICE 5'!H20,'INVOICE 5'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 5'!B21","v":0},{"$f":"'INVOICE 5'!C21","v":0},{"$f":"'INVOICE 5'!D21","v":10000},10000,{"$f":"SUM('INVOICE 5'!F21,'INVOICE 5'!J21)","v":0},{"$f":"SUM('INVOICE 5'!G21,'INVOICE 5'!K21)","v":0},{"$f":"SUM('INVOICE 5'!H21,'INVOICE 5'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 5'!B22","v":8780},{"$f":"'INVOICE 5'!C22","v":0},{"$f":"'INVOICE 5'!D22","v":197699},206479,{"$f":"SUM('INVOICE 5'!F22,'INVOICE 5'!J22)","v":2360},{"$f":"SUM('INVOICE 5'!G22,'INVOICE 5'!K22)","v":0},{"$f":"SUM('INVOICE 5'!H22,'INVOICE 5'!L22)","v":1264},3624,445,0,0,445,5975,0,196435,202410]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,26921,54836,1264,83021,78490,24478,0,102968,392051,218328,206435,816814]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 6'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":105411},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":78490},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0.211897592177895}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":79314},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":0.26647448948737074}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":15246},"Grant Administrator $2,589 - $1,717 in salaries and $872 in benefits.Program Manager $4,638 - $3,312 in salaries and $1,326 in benefits..Social Worker $5,065 - $3,298 in salaries and $1,767 in benefits.Administrative support 1)  $952.88 - $646.98 salaries and $305.90 benefits 2) $2,000.71 - $1,402.61 salaries and $598.10 benefits"]
[null,"Cash Match",null,{"$f":"K15","v":24478},"Division Mngr sal & ben for time spent on program $12,660.33 for Q6.  146 hrs x 55.54 = $8,108.84 + $4,551.49 ben = $12,660.33.CSR III sal & ben spent for time spent on prog $5,798.37 for Q6. 278.5 hrs x 20.82 = 5,798.37 - 1 Social Wrkr @ $1,933.10 (65 hrs x 29.74 = 1,933.10).Admin Specialist sal and ben for time spent on prog. $4,085.91 for Q6. 107 hrs x 23.92 =$2,617 + 1,468.92 ben = $4,085.91 "]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":164},"Printer Copies for July and August."]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":24278},"$24,090.00 (2) Police Officer (Gang) training,  $187.53 Copier maintenance"]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":36805},"Harvest Ministries community exp period 7/1/19-9/30/19 - CALVIP community based advocacy = 36,805.17"]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J19","v":1552},"10% of salaries and benefits - includes YTD adjustment"]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,0]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,445,"EMDR training for Vanessa Gonzalez 9/20-9/22/19 - 445.00"]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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."]
["Genevieve Chu, Senior Accountant",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
["(626) 744-6397",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
["gchu@cityofpasadena.net",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
["2019-11-06",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 5'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[null,null,null,null,null,"Manuel Carmona, Management Analyst V"]
[null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,"(626) 744-6122"]
[null,null,null,null,null,"Phone"]
[null,null,null,null,null,"2019-11-06"]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2019-11-14",null,null,null,null,null,"Approved By:",null,"Colleen Curtin",null,null,null,"Date:","2019-11-15"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 7","index":7,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[8,6,8,7],[10,6,10,7],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[1,14,1,15],[25,0,25,16],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[56,0,56,2],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,13,58,16],[59,13,59,16],[64,13,64,16],[65,0,65,2],[65,13,65,16],[58,0,58,3],[59,0,59,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,13,61,16],[62,13,62,16],[63,13,63,16],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000001824",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","7 CALVIP 18",null,null,"Reporting Period:","2019-07-01","TO",null,"2019-12-31","Due:","2020-02-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 6'!B15","v":160000},{"$f":"'INVOICE 6'!C15","v":270584},{"$f":"'INVOICE 6'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 6'!F15,'INVOICE 6'!J15)","v":19621},{"$f":"SUM('INVOICE 6'!G15,'INVOICE 6'!K15)","v":79314},{"$f":"SUM('INVOICE 6'!H15,'INVOICE 6'!L15)","v":0},{"$f":"SUM(F15:H15)","v":98935},4913,7494,0,{"$f":"SUM(J15:L15)","v":12407},{"$f":"B15-F15-J15","v":135466},183776,0,{"$f":"SUM(N15:P15)","v":319242}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 6'!B16","v":14325},{"$f":"'INVOICE 6'!C16","v":0},{"$f":"'INVOICE 6'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 6'!F16,'INVOICE 6'!J16)","v":164},{"$f":"SUM('INVOICE 6'!G16,'INVOICE 6'!K16)","v":0},{"$f":"SUM('INVOICE 6'!H16,'INVOICE 6'!L16)","v":0},{"$f":"SUM(F16:H16)","v":164},2769,0,0,{"$f":"SUM(J16:L16)","v":2769},11392,0,0,{"$f":"SUM(N16:P16)","v":11392}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 6'!B17","v":49626},{"$f":"'INVOICE 6'!C17","v":0},{"$f":"'INVOICE 6'!D17","v":0},49626,{"$f":"SUM('INVOICE 6'!F17,'INVOICE 6'!J17)","v":39278},{"$f":"SUM('INVOICE 6'!G17,'INVOICE 6'!K17)","v":0},{"$f":"SUM('INVOICE 6'!H17,'INVOICE 6'!L17)","v":0},39278,188,0,0,188,10160,0,0,10160]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 6'!B18","v":248731},{"$f":"'INVOICE 6'!C18","v":0},{"$f":"'INVOICE 6'!D18","v":0},248731,{"$f":"SUM('INVOICE 6'!F18,'INVOICE 6'!J18)","v":41553},{"$f":"SUM('INVOICE 6'!G18,'INVOICE 6'!K18)","v":0},{"$f":"SUM('INVOICE 6'!H18,'INVOICE 6'!L18)","v":0},41553,60293,0,0,60293,146885,0,0,146885]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 6'!B19","v":16000},{"$f":"'INVOICE 6'!C19","v":27058},{"$f":"'INVOICE 6'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 6'!F19,'INVOICE 6'!J19)","v":1990},{"$f":"SUM('INVOICE 6'!G19,'INVOICE 6'!K19)","v":0},{"$f":"SUM('INVOICE 6'!H19,'INVOICE 6'!L19)","v":0},{"$f":"SUM(F19:H19)","v":1990},491,0,0,{"$f":"SUM(J19:L19)","v":491},{"$f":"B19-F19-J19","v":13519},{"$f":"C19-G19-K19","v":27058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":40577}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 6'!B20","v":0},{"$f":"'INVOICE 6'!C20","v":0},{"$f":"'INVOICE 6'!D20","v":0},0,{"$f":"SUM('INVOICE 6'!F20,'INVOICE 6'!J20)","v":0},{"$f":"SUM('INVOICE 6'!G20,'INVOICE 6'!K20)","v":0},{"$f":"SUM('INVOICE 6'!H20,'INVOICE 6'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 6'!B21","v":0},{"$f":"'INVOICE 6'!C21","v":0},{"$f":"'INVOICE 6'!D21","v":10000},10000,{"$f":"SUM('INVOICE 6'!F21,'INVOICE 6'!J21)","v":0},{"$f":"SUM('INVOICE 6'!G21,'INVOICE 6'!K21)","v":0},{"$f":"SUM('INVOICE 6'!H21,'INVOICE 6'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 6'!B22","v":8780},{"$f":"'INVOICE 6'!C22","v":0},{"$f":"'INVOICE 6'!D22","v":197699},206479,{"$f":"SUM('INVOICE 6'!F22,'INVOICE 6'!J22)","v":2805},{"$f":"SUM('INVOICE 6'!G22,'INVOICE 6'!K22)","v":0},{"$f":"SUM('INVOICE 6'!H22,'INVOICE 6'!L22)","v":1264},4069,820,0,0,820,5155,0,196435,201590]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,105411,79314,1264,185989,69474,7494,0,76968,322577,210834,206435,739846]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 7'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":174885},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":69474},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0.35155449059425642}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":86808},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":0.29165238776785535}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":4913},"Grant Administrator $1,943.13 - $1,300.16 and $642.97 in benefits.Admin support $945.13 - $646.98 in salaries and $298.15 in benefits. Accounting support - $2,025.17 - $1,435.80 in salaries and $$589.37 in benefits"]
[null,"Cash Match",null,{"$f":"K15","v":7494},"Division Mngr sal & ben for time spent on program $5,202.88 for Q7.  60 hrs x 55.54 = $3,332.40 +  ben = $1,870.48.Admin Specialist sal and ben for time spent on program $2,291.17 for Q7.  60 hrs x 24.46 = 1,467.47 + ben = $823.69 ."]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":2769},"printer copies for Q7 - Office Corp - $170.11. Impressions - shirts and bags for program with logos -$2,246.58 + $352.73 =  2,599.31"]
[null,"Cash Match",null,{"$f":"K16","v":0},". "]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":188},"Copier maintenance for Q7 - $188.03 - Oct $62.51 - Nov $62.51 - Dec $63.01"]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":60293},"Harvest Ministries, Inc. - community exp period 10/1/19-12/31/19 -   CalVIP community based advocacy - $60,292.61- Oct - $18,830.65 - Nov - $17,572.83 - Dec - $23,889.13"]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J19","v":491},"%10 of salaries and benefits - includes YTD adjustments"]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,0]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,820,"EMDR IItraining for Vanessa Gonzalez - $445.00 - 11/21/19, CalVIP training - $375.00 - www.calcitiesvpn.org."]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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."]
["Genevieve Chu, Senior Accountant",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 6'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
["(626) 744-6397",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 6'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
["gchu@cityofpasadena.net",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 6'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
["2020-02-10",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 6'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[null,null,null,null,null,"Manuel Carmona, Management Analyst V"]
[null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,"(626) 744-6122"]
[null,null,null,null,null,"Phone"]
[null,null,null,null,null,"2020-02-10"]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-02-13",null,null,null,null,null,"Approved By:",null,"Colleen Curtin",null,null,null,"Date:","2020-02-18"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 8","index":8,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[8,6,8,7],[10,6,10,7],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[1,14,1,15],[25,0,25,16],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[56,0,56,2],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,13,58,16],[59,13,59,16],[64,13,64,16],[65,0,65,2],[65,13,65,16],[58,0,58,3],[59,0,59,3],[60,0,60,3],[61,0,61,3],[62,0,62,3],[63,0,63,3],[64,0,64,3],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,13,61,16],[62,13,62,16],[63,13,63,16],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000001824/2335",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","8 CALVIP 18",null,null,"Reporting Period:","2020-01-01","TO",null,"2020-03-31","Due:","2020-04-30",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 7'!B15","v":160000},{"$f":"'INVOICE 7'!C15","v":270584},{"$f":"'INVOICE 7'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 7'!F15,'INVOICE 7'!J15)","v":24534},{"$f":"SUM('INVOICE 7'!G15,'INVOICE 7'!K15)","v":86808},{"$f":"SUM('INVOICE 7'!H15,'INVOICE 7'!L15)","v":0},{"$f":"SUM(F15:H15)","v":111342},12282,3504,0,{"$f":"SUM(J15:L15)","v":15786},{"$f":"B15-F15-J15","v":123184},180272,0,{"$f":"SUM(N15:P15)","v":303456}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 7'!B16","v":14325},{"$f":"'INVOICE 7'!C16","v":0},{"$f":"'INVOICE 7'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 7'!F16,'INVOICE 7'!J16)","v":2933},{"$f":"SUM('INVOICE 7'!G16,'INVOICE 7'!K16)","v":0},{"$f":"SUM('INVOICE 7'!H16,'INVOICE 7'!L16)","v":0},{"$f":"SUM(F16:H16)","v":2933},1512,0,0,{"$f":"SUM(J16:L16)","v":1512},9880,0,0,{"$f":"SUM(N16:P16)","v":9880}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 7'!B17","v":49626},{"$f":"'INVOICE 7'!C17","v":0},{"$f":"'INVOICE 7'!D17","v":0},49626,{"$f":"SUM('INVOICE 7'!F17,'INVOICE 7'!J17)","v":39466},{"$f":"SUM('INVOICE 7'!G17,'INVOICE 7'!K17)","v":0},{"$f":"SUM('INVOICE 7'!H17,'INVOICE 7'!L17)","v":0},39466,189,0,0,189,9971,0,0,9971]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 7'!B18","v":248731},{"$f":"'INVOICE 7'!C18","v":0},{"$f":"'INVOICE 7'!D18","v":0},248731,{"$f":"SUM('INVOICE 7'!F18,'INVOICE 7'!J18)","v":101846},{"$f":"SUM('INVOICE 7'!G18,'INVOICE 7'!K18)","v":0},{"$f":"SUM('INVOICE 7'!H18,'INVOICE 7'!L18)","v":0},101846,64931,0,0,64931,81954,0,0,81954]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 7'!B19","v":16000},{"$f":"'INVOICE 7'!C19","v":27058},{"$f":"'INVOICE 7'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 7'!F19,'INVOICE 7'!J19)","v":2481},{"$f":"SUM('INVOICE 7'!G19,'INVOICE 7'!K19)","v":0},{"$f":"SUM('INVOICE 7'!H19,'INVOICE 7'!L19)","v":0},{"$f":"SUM(F19:H19)","v":2481},1228,0,0,{"$f":"SUM(J19:L19)","v":1228},{"$f":"B19-F19-J19","v":12291},{"$f":"C19-G19-K19","v":27058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":39349}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 7'!B20","v":0},{"$f":"'INVOICE 7'!C20","v":0},{"$f":"'INVOICE 7'!D20","v":0},0,{"$f":"SUM('INVOICE 7'!F20,'INVOICE 7'!J20)","v":0},{"$f":"SUM('INVOICE 7'!G20,'INVOICE 7'!K20)","v":0},{"$f":"SUM('INVOICE 7'!H20,'INVOICE 7'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 7'!B21","v":0},{"$f":"'INVOICE 7'!C21","v":0},{"$f":"'INVOICE 7'!D21","v":10000},10000,{"$f":"SUM('INVOICE 7'!F21,'INVOICE 7'!J21)","v":0},{"$f":"SUM('INVOICE 7'!G21,'INVOICE 7'!K21)","v":0},{"$f":"SUM('INVOICE 7'!H21,'INVOICE 7'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 7'!B22","v":8780},{"$f":"'INVOICE 7'!C22","v":0},{"$f":"'INVOICE 7'!D22","v":197699},206479,{"$f":"SUM('INVOICE 7'!F22,'INVOICE 7'!J22)","v":3625},{"$f":"SUM('INVOICE 7'!G22,'INVOICE 7'!K22)","v":0},{"$f":"SUM('INVOICE 7'!H22,'INVOICE 7'!L22)","v":1264},4889,0,0,null,0,5155,0,196435,201590]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,174885,86808,1264,262957,80142,3504,0,83646,242435,207330,206435,656200]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 8'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":255027},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":80142},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0.51265624308992441}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":90312},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":0.30342491987017961}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":12282},"Grant Admin - $1,756.71 = $1,137.70 sal and $619.01 benefits. Social worker - $4,838.88 = $4,516.24 sal and $322.64 benefits. Accounting support - $2,025.17 - $1,435.80 in salaries and $$589.37 in benefits"]
[null,"Cash Match",null,{"$f":"K15","v":3504},"Division Mngr sal & ben for time spent on program $5,202.88 for Q7.  60 hrs x 55.54 = $3,332.40 +  ben = $1,870.48. Admin Specialist sal and ben for time spent on program $2,291.17 for Q7.  60 hrs x 24.46 = 1,467.47 + ben = $823.69  "]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":1512},"printer copies for Q7 - Office Corp - $170.11. Impressions - shirts and bags for program with logos -$2,246.58 + $352.73 =  2,599.31"]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":189},"Copier maintenance for Q7 - $188.03 - Oct $62.51 - Nov $62.51 - Dec $63.01"]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":64931},"Harvest Ministries, Inc. - community exp period 10/1/19-12/31/19 -   CalVIP community based advocacy - $60,292.61- Oct - $18,830.65 - Nov - $17,572.83 - Dec - $23,889.13"]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J19","v":1228},"%10 of salaries and benefits - includes YTD adjustments"]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,{"$f":"J22","v":0}]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,{"$f":"J24","v":0}]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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."]
["Genevieve Chu, Senior Accountant",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 7'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
["626-744-6397",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 7'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
["gchu@cityofpasadena.net",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 7'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
["2020-05-01",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 7'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[null,null,null,null,null,"Susan Kim, Administration & Finance Manager"]
["PO#1824 $60,353",null,null,null,null,"Name, Title"]
["PO#2335 $19,789",null,null,null,null,"626-744-6166"]
[null,null,null,null,null,"Phone"]
[null,null,null,null,null,"2020-05-01"]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-05-12",null,null,null,null,null,"Approved By:",null,"Colleen Curtin",null,null,null,"Date:","2020-05-18"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 9","index":9,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[8,6,8,7],[10,6,10,7],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[1,14,1,15],[25,0,25,16],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,14,31,16],[32,1,32,2],[32,14,32,16],[33,1,33,2],[33,14,33,16],[31,4,31,13],[32,4,32,13],[33,4,33,13],[34,0,36,0],[34,1,34,2],[34,14,34,16],[35,1,35,2],[35,14,35,16],[36,1,36,2],[36,14,36,16],[34,4,34,13],[35,4,35,13],[36,4,36,13],[37,0,39,0],[37,1,37,2],[37,14,37,16],[38,1,38,2],[38,14,38,16],[39,1,39,2],[39,14,39,16],[37,4,37,13],[38,4,38,13],[39,4,39,13],[40,0,42,0],[40,1,40,2],[40,14,40,16],[41,1,41,2],[41,14,41,16],[42,1,42,2],[42,14,42,16],[40,4,40,13],[41,4,41,13],[42,4,42,13],[49,4,49,13],[50,4,50,13],[54,4,54,13],[43,0,45,0],[43,1,43,2],[43,14,43,16],[44,1,44,2],[44,14,44,16],[45,1,45,2],[45,14,45,16],[43,4,43,13],[44,4,44,13],[45,4,45,13],[46,0,48,0],[46,1,46,2],[46,14,46,16],[47,1,47,2],[47,14,47,16],[48,1,48,2],[48,14,48,16],[46,4,46,13],[47,4,47,13],[48,4,48,13],[69,5,69,10],[70,5,70,10],[71,5,71,10],[60,13,60,16],[61,13,61,16],[62,13,62,16],[63,13,63,16],[64,0,64,2],[61,0,61,2],[62,0,62,2],[63,0,63,2],[67,5,67,10],[68,5,68,10],[57,5,66,10],[58,13,58,16],[59,13,59,16],[64,13,64,16],[65,0,65,2],[65,13,65,16],[58,0,58,2],[59,0,59,2],[60,0,60,2],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16],[56,0,56,2],[56,5,56,10],[56,13,56,16],[57,0,57,2],[55,0,55,2],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,14,52,16],[53,1,53,2],[49,0,51,0],[49,1,49,2],[49,14,49,16],[50,1,50,2],[53,14,53,16],[54,1,54,2],[54,14,54,16],[55,4,55,13],[51,4,51,13],[52,4,52,13],[53,4,53,13]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000002335",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","9 CALVIP 18",null,null,"Reporting Period:","2020-04-01","TO",null,"2020-06-30","Due:","2020-08-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 8'!B15","v":160000},{"$f":"'INVOICE 8'!C15","v":270584},{"$f":"'INVOICE 8'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 8'!F15,'INVOICE 8'!J15)","v":36816},{"$f":"SUM('INVOICE 8'!G15,'INVOICE 8'!K15)","v":90312},{"$f":"SUM('INVOICE 8'!H15,'INVOICE 8'!L15)","v":0},{"$f":"SUM(F15:H15)","v":127128},12411,6849,0,{"$f":"SUM(J15:L15)","v":19260},{"$f":"B15-F15-J15","v":110773},173423,0,{"$f":"SUM(N15:P15)","v":284196}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 8'!B16","v":14325},{"$f":"'INVOICE 8'!C16","v":0},{"$f":"'INVOICE 8'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 8'!F16,'INVOICE 8'!J16)","v":4445},{"$f":"SUM('INVOICE 8'!G16,'INVOICE 8'!K16)","v":0},{"$f":"SUM('INVOICE 8'!H16,'INVOICE 8'!L16)","v":0},{"$f":"SUM(F16:H16)","v":4445},92,0,0,{"$f":"SUM(J16:L16)","v":92},9788,0,0,{"$f":"SUM(N16:P16)","v":9788}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 8'!B17","v":49626},{"$f":"'INVOICE 8'!C17","v":0},{"$f":"'INVOICE 8'!D17","v":0},49626,{"$f":"SUM('INVOICE 8'!F17,'INVOICE 8'!J17)","v":39655},{"$f":"SUM('INVOICE 8'!G17,'INVOICE 8'!K17)","v":0},{"$f":"SUM('INVOICE 8'!H17,'INVOICE 8'!L17)","v":0},39655,189,0,0,189,9782,0,0,9782]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 8'!B18","v":248731},{"$f":"'INVOICE 8'!C18","v":0},{"$f":"'INVOICE 8'!D18","v":0},248731,{"$f":"SUM('INVOICE 8'!F18,'INVOICE 8'!J18)","v":166777},{"$f":"SUM('INVOICE 8'!G18,'INVOICE 8'!K18)","v":0},{"$f":"SUM('INVOICE 8'!H18,'INVOICE 8'!L18)","v":0},166777,54820,0,0,54820,27134,0,0,27134]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 8'!B19","v":16000},{"$f":"'INVOICE 8'!C19","v":27058},{"$f":"'INVOICE 8'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 8'!F19,'INVOICE 8'!J19)","v":3709},{"$f":"SUM('INVOICE 8'!G19,'INVOICE 8'!K19)","v":0},{"$f":"SUM('INVOICE 8'!H19,'INVOICE 8'!L19)","v":0},{"$f":"SUM(F19:H19)","v":3709},1241,21000,0,{"$f":"SUM(J19:L19)","v":22241},{"$f":"B19-F19-J19","v":11050},{"$f":"C19-G19-K19","v":6058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":17108}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 8'!B20","v":0},{"$f":"'INVOICE 8'!C20","v":0},{"$f":"'INVOICE 8'!D20","v":0},0,{"$f":"SUM('INVOICE 8'!F20,'INVOICE 8'!J20)","v":0},{"$f":"SUM('INVOICE 8'!G20,'INVOICE 8'!K20)","v":0},{"$f":"SUM('INVOICE 8'!H20,'INVOICE 8'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 8'!B21","v":0},{"$f":"'INVOICE 8'!C21","v":0},{"$f":"'INVOICE 8'!D21","v":10000},10000,{"$f":"SUM('INVOICE 8'!F21,'INVOICE 8'!J21)","v":0},{"$f":"SUM('INVOICE 8'!G21,'INVOICE 8'!K21)","v":0},{"$f":"SUM('INVOICE 8'!H21,'INVOICE 8'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 8'!B22","v":8780},{"$f":"'INVOICE 8'!C22","v":0},{"$f":"'INVOICE 8'!D22","v":197699},206479,{"$f":"SUM('INVOICE 8'!F22,'INVOICE 8'!J22)","v":3625},{"$f":"SUM('INVOICE 8'!G22,'INVOICE 8'!K22)","v":0},{"$f":"SUM('INVOICE 8'!H22,'INVOICE 8'!L22)","v":1264},4889,0,0,0,0,5155,0,196435,201590]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,255027,90312,1264,346603,68753,27849,0,96602,173682,179481,206435,559598]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 9'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":323780},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":68753},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0.65086378457047978}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":118161},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":0.39699034410466266}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":12411},"1.  Grant Admin - $2,106.79 = $1,357.17 Sal and $749.62 Benefits.  2.  Social Worker - $6,536.13 = $6,035.21 Sal and $500.92 Benefits.  3.  Accounting Support - $2,248.49 = 1,553.02 Sal and 695.47 Benefits  4.  Admin Support - $818.90 = $539.15 Sal and $279.75 Benefits.  5.  Admin Support - $699.94 = $494.91 Sak and $205.03 Benefits."]
[null,"Cash Match",null,{"$f":"K15","v":6849},"1.  Acting Division Manager - Salary and Benefits for time spent on program - $3,450.86 for Q9 (75 hrs x $29.47 = $2,210.25 + ben = 1,240.61.  2.  Admin Specialist - Salary and Benefits for time spent on program - $3,398.56 for Q9 (89 hrs x 24.46 = 2,176.75 + ben = 1,221.81).  "]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":92},"Printer copies for Q9 - Office Corp - $92.50"]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":189},"Copy Maintenance for Q9 - $188.98 - Apr = $62.99 = May = $62.99 - June = $63.00"]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":54820},"Harvest Ministries, Inc.  - Community exp period 4/1/20-6/30-20 - $54,820.17 - Apr = $19,348.04 - May = $17,623.55 - June = $17,848.58"]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,1241,"10% of salaries and benefits - includes YTD adjustments - $12,541.25 x 10% = $1,241.02"]
[null,"Cash Match",null,21000,"21.614% of match amount adjustment from previous quarters:  Q1 = $3,690.00 x 21.614% = 797.56 - Q2 = $1748.00 x 21.614% = $377.81 - Q3 = $2,282.00 x 21.614% = $493.23 - Q4 = $20,331.00 x 21.614% = $4,394.34 - Q5 = $26,785.00 x 21.614% = $5,789.31 - Q6 = $24,478.00 x 21.614% = $5,290.67 - Q7 - $7,494.00 x 21.614% = $1,619.75 - Q8 = $3,504.00 x 21.614% = $757.35 - Q9 = $6,849.43 x 21.614% = $1,480.44    Total Q1-Q9 = $21,000.46"]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,{"$f":"J22","v":0}]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,{"$f":"J25","v":0}]
[null,"Cash Match",null,{"$f":"K27","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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."]
["Genevieve Chu, Senior Accountant",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 8'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
["626-744-6397",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 8'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
["gchu@cityofpasadena.net",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 8'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
["2020-08-10",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 8'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[null,null,null,null,null,"Susan Kim, Administration & Finance Manager"]
[null,null,null,null,null,"Name, Title"]
[null,null,null,null,null,"626-744-6166"]
[null,null,null,null,null,"Phone"]
[null,null,null,null,null,"2020-08-10"]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,"2020-08-13",null,null,null,null,null,"Approved By:",null,"Katrina Jackson",null,null,null,"Date:","2020-08-21"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 10","index":10,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[8,6,8,7],[10,6,10,7],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[1,14,1,15],[25,0,25,16],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[56,0,56,2],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,0,58,2],[58,13,58,16],[59,0,59,2],[59,13,59,16],[60,0,60,2],[64,0,64,2],[64,13,64,16],[65,0,65,2],[65,13,65,16],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,0,61,2],[61,13,61,16],[62,0,62,2],[62,13,62,16],[63,0,63,2],[63,13,63,16],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000002335",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","10 CALVIP 18",null,null,"Reporting Period:","2020-07-01","TO",null,"2020-09-30","Due:","2020-11-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 9'!B15","v":160000},{"$f":"'INVOICE 9'!C15","v":270584},{"$f":"'INVOICE 9'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 9'!F15,'INVOICE 9'!J15)","v":49227},{"$f":"SUM('INVOICE 9'!G15,'INVOICE 9'!K15)","v":97161},{"$f":"SUM('INVOICE 9'!H15,'INVOICE 9'!L15)","v":0},{"$f":"SUM(F15:H15)","v":146388},0,0,0,{"$f":"SUM(J15:L15)","v":0},{"$f":"B15-F15-J15","v":110773},173423,0,{"$f":"SUM(N15:P15)","v":284196}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 9'!B16","v":14325},{"$f":"'INVOICE 9'!C16","v":0},{"$f":"'INVOICE 9'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 9'!F16,'INVOICE 9'!J16)","v":4537},{"$f":"SUM('INVOICE 9'!G16,'INVOICE 9'!K16)","v":0},{"$f":"SUM('INVOICE 9'!H16,'INVOICE 9'!L16)","v":0},{"$f":"SUM(F16:H16)","v":4537},0,0,0,{"$f":"SUM(J16:L16)","v":0},9788,0,0,{"$f":"SUM(N16:P16)","v":9788}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 9'!B17","v":49626},{"$f":"'INVOICE 9'!C17","v":0},{"$f":"'INVOICE 9'!D17","v":0},49626,{"$f":"SUM('INVOICE 9'!F17,'INVOICE 9'!J17)","v":39844},{"$f":"SUM('INVOICE 9'!G17,'INVOICE 9'!K17)","v":0},{"$f":"SUM('INVOICE 9'!H17,'INVOICE 9'!L17)","v":0},39844,0,0,0,0,9782,0,0,9782]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 9'!B18","v":248731},{"$f":"'INVOICE 9'!C18","v":0},{"$f":"'INVOICE 9'!D18","v":0},248731,{"$f":"SUM('INVOICE 9'!F18,'INVOICE 9'!J18)","v":221597},{"$f":"SUM('INVOICE 9'!G18,'INVOICE 9'!K18)","v":0},{"$f":"SUM('INVOICE 9'!H18,'INVOICE 9'!L18)","v":0},221597,0,0,0,0,27134,0,0,27134]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 9'!B19","v":16000},{"$f":"'INVOICE 9'!C19","v":27058},{"$f":"'INVOICE 9'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 9'!F19,'INVOICE 9'!J19)","v":4950},{"$f":"SUM('INVOICE 9'!G19,'INVOICE 9'!K19)","v":21000},{"$f":"SUM('INVOICE 9'!H19,'INVOICE 9'!L19)","v":0},{"$f":"SUM(F19:H19)","v":25950},0,0,0,{"$f":"SUM(J19:L19)","v":0},{"$f":"B19-F19-J19","v":11050},{"$f":"C19-G19-K19","v":6058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":17108}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 9'!B20","v":0},{"$f":"'INVOICE 9'!C20","v":0},{"$f":"'INVOICE 9'!D20","v":0},0,{"$f":"SUM('INVOICE 9'!F20,'INVOICE 9'!J20)","v":0},{"$f":"SUM('INVOICE 9'!G20,'INVOICE 9'!K20)","v":0},{"$f":"SUM('INVOICE 9'!H20,'INVOICE 9'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 9'!B21","v":0},{"$f":"'INVOICE 9'!C21","v":0},{"$f":"'INVOICE 9'!D21","v":10000},10000,{"$f":"SUM('INVOICE 9'!F21,'INVOICE 9'!J21)","v":0},{"$f":"SUM('INVOICE 9'!G21,'INVOICE 9'!K21)","v":0},{"$f":"SUM('INVOICE 9'!H21,'INVOICE 9'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 9'!B22","v":8780},{"$f":"'INVOICE 9'!C22","v":0},{"$f":"'INVOICE 9'!D22","v":197699},206479,{"$f":"SUM('INVOICE 9'!F22,'INVOICE 9'!J22)","v":3625},{"$f":"SUM('INVOICE 9'!G22,'INVOICE 9'!K22)","v":0},{"$f":"SUM('INVOICE 9'!H22,'INVOICE 9'!L22)","v":1264},4889,0,0,0,0,5155,0,196435,201590]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,323780,118161,1264,443205,0,0,0,0,173682,179481,206435,559598]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 10'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":323780},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":0},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0.65086378457047978}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":118161},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":0.39699034410466266}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":0}]
[null,"Cash Match",null,{"$f":"K15","v":0}]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":0}]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":0}]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":0}]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J20","v":0}]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,{"$f":"J22","v":0}]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,{"$f":"J19","v":0}]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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,null,null,{"$f":"'INVOICE 9'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 9'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 9'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 9'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[]
[null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 11","index":11,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[8,6,8,7],[10,6,10,7],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[1,14,1,15],[25,0,25,16],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[56,0,56,2],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,0,58,2],[58,13,58,16],[59,0,59,2],[59,13,59,16],[60,0,60,2],[64,0,64,2],[64,13,64,16],[65,0,65,2],[65,13,65,16],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,0,61,2],[61,13,61,16],[62,0,62,2],[62,13,62,16],[63,0,63,2],[63,13,63,16],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000002335",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","11 CALVIP 18",null,null,"Reporting Period:","2020-10-01","TO",null,"2020-12-31","Due:","2021-02-15",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 10'!B15","v":160000},{"$f":"'INVOICE 10'!C15","v":270584},{"$f":"'INVOICE 10'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 10'!F15,'INVOICE 10'!J15)","v":49227},{"$f":"SUM('INVOICE 10'!G15,'INVOICE 10'!K15)","v":97161},{"$f":"SUM('INVOICE 10'!H15,'INVOICE 10'!L15)","v":0},{"$f":"SUM(F15:H15)","v":146388},0,0,0,{"$f":"SUM(J15:L15)","v":0},{"$f":"B15-F15-J15","v":110773},173423,0,{"$f":"SUM(N15:P15)","v":284196}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 10'!B16","v":14325},{"$f":"'INVOICE 10'!C16","v":0},{"$f":"'INVOICE 10'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 10'!F16,'INVOICE 10'!J16)","v":4537},{"$f":"SUM('INVOICE 10'!G16,'INVOICE 10'!K16)","v":0},{"$f":"SUM('INVOICE 10'!H16,'INVOICE 10'!L16)","v":0},{"$f":"SUM(F16:H16)","v":4537},0,0,0,{"$f":"SUM(J16:L16)","v":0},9788,0,0,{"$f":"SUM(N16:P16)","v":9788}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 10'!B17","v":49626},{"$f":"'INVOICE 10'!C17","v":0},{"$f":"'INVOICE 10'!D17","v":0},49626,{"$f":"SUM('INVOICE 10'!F17,'INVOICE 10'!J17)","v":39844},{"$f":"SUM('INVOICE 10'!G17,'INVOICE 10'!K17)","v":0},{"$f":"SUM('INVOICE 10'!H17,'INVOICE 10'!L17)","v":0},39844,0,0,0,0,9782,0,0,9782]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 10'!B18","v":248731},{"$f":"'INVOICE 10'!C18","v":0},{"$f":"'INVOICE 10'!D18","v":0},248731,{"$f":"SUM('INVOICE 10'!F18,'INVOICE 10'!J18)","v":221597},{"$f":"SUM('INVOICE 10'!G18,'INVOICE 10'!K18)","v":0},{"$f":"SUM('INVOICE 10'!H18,'INVOICE 10'!L18)","v":0},221597,0,0,0,0,27134,0,0,27134]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 10'!B19","v":16000},{"$f":"'INVOICE 10'!C19","v":27058},{"$f":"'INVOICE 10'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 10'!F19,'INVOICE 10'!J19)","v":4950},{"$f":"SUM('INVOICE 10'!G19,'INVOICE 10'!K19)","v":21000},{"$f":"SUM('INVOICE 10'!H19,'INVOICE 10'!L19)","v":0},{"$f":"SUM(F19:H19)","v":25950},0,0,0,{"$f":"SUM(J19:L19)","v":0},{"$f":"B19-F19-J19","v":11050},{"$f":"C19-G19-K19","v":6058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":17108}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 10'!B20","v":0},{"$f":"'INVOICE 10'!C20","v":0},{"$f":"'INVOICE 10'!D20","v":0},0,{"$f":"SUM('INVOICE 10'!F20,'INVOICE 10'!J20)","v":0},{"$f":"SUM('INVOICE 10'!G20,'INVOICE 10'!K20)","v":0},{"$f":"SUM('INVOICE 10'!H20,'INVOICE 10'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 10'!B21","v":0},{"$f":"'INVOICE 10'!C21","v":0},{"$f":"'INVOICE 10'!D21","v":10000},10000,{"$f":"SUM('INVOICE 10'!F21,'INVOICE 10'!J21)","v":0},{"$f":"SUM('INVOICE 10'!G21,'INVOICE 10'!K21)","v":0},{"$f":"SUM('INVOICE 10'!H21,'INVOICE 10'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 10'!B22","v":8780},{"$f":"'INVOICE 10'!C22","v":0},{"$f":"'INVOICE 10'!D22","v":197699},206479,{"$f":"SUM('INVOICE 10'!F22,'INVOICE 10'!J22)","v":3625},{"$f":"SUM('INVOICE 10'!G22,'INVOICE 10'!K22)","v":0},{"$f":"SUM('INVOICE 10'!H22,'INVOICE 10'!L22)","v":1264},4889,0,0,0,0,5155,0,196435,201590]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,323780,118161,1264,443205,0,0,0,0,173682,179481,206435,559598]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 11'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":323780},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":0},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0.65086378457047978}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":118161},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":0.39699034410466266}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":0}]
[null,"Cash Match",null,{"$f":"K15","v":0}]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":0}]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":0}]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":0}]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J20","v":0}]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,{"$f":"J22","v":0}]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,{"$f":"J19","v":0}]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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,null,null,{"$f":"'INVOICE 10'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 10'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 10'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 10'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[]
[null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 12","index":12,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[8,6,8,7],[10,6,10,7],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[1,14,1,15],[25,0,25,16],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[56,0,56,2],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,0,58,2],[58,13,58,16],[59,0,59,2],[59,13,59,16],[60,0,60,2],[64,0,64,2],[64,13,64,16],[65,0,65,2],[65,13,65,16],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,0,61,2],[61,13,61,16],[62,0,62,2],[62,13,62,16],[63,0,63,2],[63,13,63,16],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000002335",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","12 CALVIP 18",null,null,"Reporting Period:","2021-01-01","TO",null,"2021-03-31","Due:","2021-05-14",null,null,"Final Invoice (Y/N):","No"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 11'!B15","v":160000},{"$f":"'INVOICE 11'!C15","v":270584},{"$f":"'INVOICE 11'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 11'!F15,'INVOICE 11'!J15)","v":49227},{"$f":"SUM('INVOICE 11'!G15,'INVOICE 11'!K15)","v":97161},{"$f":"SUM('INVOICE 11'!H15,'INVOICE 11'!L15)","v":0},{"$f":"SUM(F15:H15)","v":146388},0,0,0,{"$f":"SUM(J15:L15)","v":0},{"$f":"B15-F15-J15","v":110773},173423,0,{"$f":"SUM(N15:P15)","v":284196}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 11'!B16","v":14325},{"$f":"'INVOICE 11'!C16","v":0},{"$f":"'INVOICE 11'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 11'!F16,'INVOICE 11'!J16)","v":4537},{"$f":"SUM('INVOICE 11'!G16,'INVOICE 11'!K16)","v":0},{"$f":"SUM('INVOICE 11'!H16,'INVOICE 11'!L16)","v":0},{"$f":"SUM(F16:H16)","v":4537},0,0,0,{"$f":"SUM(J16:L16)","v":0},9788,0,0,{"$f":"SUM(N16:P16)","v":9788}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 11'!B17","v":49626},{"$f":"'INVOICE 11'!C17","v":0},{"$f":"'INVOICE 11'!D17","v":0},49626,{"$f":"SUM('INVOICE 11'!F17,'INVOICE 11'!J17)","v":39844},{"$f":"SUM('INVOICE 11'!G17,'INVOICE 11'!K17)","v":0},{"$f":"SUM('INVOICE 11'!H17,'INVOICE 11'!L17)","v":0},39844,0,0,0,0,9782,0,0,9782]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 11'!B18","v":248731},{"$f":"'INVOICE 11'!C18","v":0},{"$f":"'INVOICE 11'!D18","v":0},248731,{"$f":"SUM('INVOICE 11'!F18,'INVOICE 11'!J18)","v":221597},{"$f":"SUM('INVOICE 11'!G18,'INVOICE 11'!K18)","v":0},{"$f":"SUM('INVOICE 11'!H18,'INVOICE 11'!L18)","v":0},221597,0,0,0,0,27134,0,0,27134]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 11'!B19","v":16000},{"$f":"'INVOICE 11'!C19","v":27058},{"$f":"'INVOICE 11'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 11'!F19,'INVOICE 11'!J19)","v":4950},{"$f":"SUM('INVOICE 11'!G19,'INVOICE 11'!K19)","v":21000},{"$f":"SUM('INVOICE 11'!H19,'INVOICE 11'!L19)","v":0},{"$f":"SUM(F19:H19)","v":25950},0,0,0,{"$f":"SUM(J19:L19)","v":0},{"$f":"B19-F19-J19","v":11050},{"$f":"C19-G19-K19","v":6058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":17108}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 11'!B20","v":0},{"$f":"'INVOICE 11'!C20","v":0},{"$f":"'INVOICE 11'!D20","v":0},0,{"$f":"SUM('INVOICE 11'!F20,'INVOICE 11'!J20)","v":0},{"$f":"SUM('INVOICE 11'!G20,'INVOICE 11'!K20)","v":0},{"$f":"SUM('INVOICE 11'!H20,'INVOICE 11'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 11'!B21","v":0},{"$f":"'INVOICE 11'!C21","v":0},{"$f":"'INVOICE 11'!D21","v":10000},10000,{"$f":"SUM('INVOICE 11'!F21,'INVOICE 11'!J21)","v":0},{"$f":"SUM('INVOICE 11'!G21,'INVOICE 11'!K21)","v":0},{"$f":"SUM('INVOICE 11'!H21,'INVOICE 11'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 11'!B22","v":8780},{"$f":"'INVOICE 11'!C22","v":0},{"$f":"'INVOICE 11'!D22","v":197699},206479,{"$f":"SUM('INVOICE 11'!F22,'INVOICE 11'!J22)","v":3625},{"$f":"SUM('INVOICE 11'!G22,'INVOICE 11'!K22)","v":0},{"$f":"SUM('INVOICE 11'!H22,'INVOICE 11'!L22)","v":1264},4889,0,0,0,0,5155,0,196435,201590]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,323780,118161,1264,443205,0,0,0,0,173682,179481,206435,559598]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 12'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":323780},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":0},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0.65086378457047978}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":118161},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":0.39699034410466266}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":0}]
[null,"Cash Match",null,{"$f":"K15","v":0}]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":0}]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":0}]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":0}]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J20","v":0}]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,{"$f":"J22","v":0}]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,{"$f":"J19","v":0}]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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,null,null,{"$f":"'INVOICE 11'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 11'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 11'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 11'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[]
[null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 13","index":13,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[0,6,2,9],[0,14,0,16],[4,12,6,16],[8,6,8,7],[10,6,10,7],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[1,14,1,15],[25,0,25,16],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[50,14,50,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[53,14,53,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[56,0,56,2],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,0,58,2],[58,13,58,16],[59,0,59,2],[59,13,59,16],[60,0,60,2],[64,0,64,2],[64,13,64,16],[65,0,65,2],[65,13,65,16],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,0,61,2],[61,13,61,16],[62,0,62,2],[62,13,62,16],[63,0,63,2],[63,13,63,16],[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000002335",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","13 CALVIP 18",null,null,"Reporting Period:","2021-04-01","TO",null,"2021-04-30","Due:","2021-06-15",null,null,"Final Invoice (Y/N):","Yes"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 12'!B15","v":160000},{"$f":"'INVOICE 12'!C15","v":270584},{"$f":"'INVOICE 12'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 12'!F15,'INVOICE 12'!J15)","v":49227},{"$f":"SUM('INVOICE 12'!G15,'INVOICE 12'!K15)","v":97161},{"$f":"SUM('INVOICE 12'!H15,'INVOICE 12'!L15)","v":0},{"$f":"SUM(F15:H15)","v":146388},0,0,0,{"$f":"SUM(J15:L15)","v":0},{"$f":"B15-F15-J15","v":110773},173423,0,{"$f":"SUM(N15:P15)","v":284196}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 12'!B16","v":14325},{"$f":"'INVOICE 12'!C16","v":0},{"$f":"'INVOICE 12'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 12'!F16,'INVOICE 12'!J16)","v":4537},{"$f":"SUM('INVOICE 12'!G16,'INVOICE 12'!K16)","v":0},{"$f":"SUM('INVOICE 12'!H16,'INVOICE 12'!L16)","v":0},{"$f":"SUM(F16:H16)","v":4537},0,0,0,{"$f":"SUM(J16:L16)","v":0},9788,0,0,{"$f":"SUM(N16:P16)","v":9788}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 12'!B17","v":49626},{"$f":"'INVOICE 12'!C17","v":0},{"$f":"'INVOICE 12'!D17","v":0},49626,{"$f":"SUM('INVOICE 12'!F17,'INVOICE 12'!J17)","v":39844},{"$f":"SUM('INVOICE 12'!G17,'INVOICE 12'!K17)","v":0},{"$f":"SUM('INVOICE 12'!H17,'INVOICE 12'!L17)","v":0},39844,0,0,0,0,9782,0,0,9782]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 12'!B18","v":248731},{"$f":"'INVOICE 12'!C18","v":0},{"$f":"'INVOICE 12'!D18","v":0},248731,{"$f":"SUM('INVOICE 12'!F18,'INVOICE 12'!J18)","v":221597},{"$f":"SUM('INVOICE 12'!G18,'INVOICE 12'!K18)","v":0},{"$f":"SUM('INVOICE 12'!H18,'INVOICE 12'!L18)","v":0},221597,0,0,0,0,27134,0,0,27134]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 12'!B19","v":16000},{"$f":"'INVOICE 12'!C19","v":27058},{"$f":"'INVOICE 12'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 12'!F19,'INVOICE 12'!J19)","v":4950},{"$f":"SUM('INVOICE 12'!G19,'INVOICE 12'!K19)","v":21000},{"$f":"SUM('INVOICE 12'!H19,'INVOICE 12'!L19)","v":0},{"$f":"SUM(F19:H19)","v":25950},0,0,0,{"$f":"SUM(J19:L19)","v":0},{"$f":"B19-F19-J19","v":11050},{"$f":"C19-G19-K19","v":6058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":17108}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 12'!B20","v":0},{"$f":"'INVOICE 12'!C20","v":0},{"$f":"'INVOICE 12'!D20","v":0},0,{"$f":"SUM('INVOICE 12'!F20,'INVOICE 12'!J20)","v":0},{"$f":"SUM('INVOICE 12'!G20,'INVOICE 12'!K20)","v":0},{"$f":"SUM('INVOICE 12'!H20,'INVOICE 12'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 12'!B21","v":0},{"$f":"'INVOICE 12'!C21","v":0},{"$f":"'INVOICE 12'!D21","v":10000},10000,{"$f":"SUM('INVOICE 12'!F21,'INVOICE 12'!J21)","v":0},{"$f":"SUM('INVOICE 12'!G21,'INVOICE 12'!K21)","v":0},{"$f":"SUM('INVOICE 12'!H21,'INVOICE 12'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 12'!B22","v":8780},{"$f":"'INVOICE 12'!C22","v":0},{"$f":"'INVOICE 12'!D22","v":197699},206479,{"$f":"SUM('INVOICE 12'!F22,'INVOICE 12'!J22)","v":3625},{"$f":"SUM('INVOICE 12'!G22,'INVOICE 12'!K22)","v":0},{"$f":"SUM('INVOICE 12'!H22,'INVOICE 12'!L22)","v":1264},4889,0,0,0,0,5155,0,196435,201590]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,323780,118161,1264,443205,0,0,0,0,173682,179481,206435,559598]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 13'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":323780},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":0},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0.65086378457047978}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":118161},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":0.39699034410466266}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":0}]
[null,"Cash Match",null,{"$f":"K15","v":0}]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":0}]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":0}]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":0}]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J20","v":0}]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,{"$f":"J22","v":0}]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,{"$f":"J19","v":0}]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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,null,null,{"$f":"'INVOICE 12'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[]
[null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"INVOICE 14","index":14,"n_rows":77,"n_cols":17,"rows_kept":77,"cut":false,"hidden":false,"merged":[[74,0,74,16],[75,0,75,1],[75,8,75,9],[76,0,76,9],[76,10,76,13],[69,5,69,10],[70,5,70,10],[71,5,71,10],[71,13,71,16],[72,0,72,2],[72,5,72,10],[72,13,72,16],[67,5,67,10],[68,5,68,10],[60,13,60,16],[61,0,61,2],[61,13,61,16],[62,0,62,2],[62,13,62,16],[63,0,63,2],[63,13,63,16],[56,0,56,2],[56,5,56,10],[56,13,56,16],[57,0,57,2],[57,5,66,10],[58,0,58,2],[58,13,58,16],[59,0,59,2],[59,13,59,16],[60,0,60,2],[64,0,64,2],[64,13,64,16],[65,0,65,2],[65,13,65,16],[55,0,55,2],[55,4,55,13],[55,14,55,16],[51,1,51,2],[51,4,51,13],[51,14,51,16],[52,0,54,0],[52,1,52,2],[52,4,52,13],[52,14,52,16],[53,1,53,2],[53,4,53,13],[53,14,53,16],[49,0,51,0],[49,1,49,2],[49,4,49,13],[49,14,49,16],[50,1,50,2],[50,4,50,13],[50,14,50,16],[54,1,54,2],[54,4,54,13],[54,14,54,16],[46,0,48,0],[46,1,46,2],[46,4,46,13],[46,14,46,16],[47,1,47,2],[47,4,47,13],[47,14,47,16],[48,1,48,2],[48,4,48,13],[48,14,48,16],[43,0,45,0],[43,1,43,2],[43,4,43,13],[43,14,43,16],[44,1,44,2],[44,4,44,13],[44,14,44,16],[45,1,45,2],[45,4,45,13],[45,14,45,16],[40,0,42,0],[40,1,40,2],[40,4,40,13],[40,14,40,16],[41,1,41,2],[41,4,41,13],[41,14,41,16],[42,1,42,2],[42,4,42,13],[42,14,42,16],[37,0,39,0],[37,1,37,2],[37,4,37,13],[37,14,37,16],[38,1,38,2],[38,4,38,13],[38,14,38,16],[39,1,39,2],[39,4,39,13],[39,14,39,16],[34,0,36,0],[34,1,34,2],[34,4,34,13],[34,14,34,16],[35,1,35,2],[35,4,35,13],[35,14,35,16],[36,1,36,2],[36,4,36,13],[36,14,36,16],[29,0,29,2],[30,4,30,13],[30,14,30,16],[31,0,33,0],[31,1,31,2],[31,4,31,13],[31,14,31,16],[32,1,32,2],[32,4,32,13],[32,14,32,16],[33,1,33,2],[33,4,33,13],[33,14,33,16],[12,0,13,0],[12,1,12,4],[12,5,12,8],[12,9,12,12],[12,13,12,16],[25,0,25,16],[0,6,2,9],[0,14,0,16],[1,14,1,15],[4,12,6,16],[8,6,8,7],[10,6,10,7]]}
["STATE OF CALIFORNIA                                                                                                                                                                                                                                                                                    ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Authority","BSCC 5227"]
["BOARD OF STATE AND COMMUNITY CORRECTIONS                                                                                                                                                                                                                 ",null,null,null,null,null,null,null,null,null,null,null,null,"Purchase Order:","5227-0000002335",null,{"$f":"'INVOICE 1'!Q2","v":0}]
["Financial Invoice Form: BSCC 201 (Revised 04/2020)"]
[]
["Program:",{"$f":"'INVOICE 1'!B5","v":"Program Name"},null,null,null,null,null,null,null,null,null,null,"Please Note: The California State Controller's Office will send all checks directly to the address listed in the \"BSCC Vendor Data\" section at the bottom of this invoice. "]
[]
["Grantee:",{"$f":"'INVOICE 1'!B7","v":"City of Pasadena Public Health Department"},null,null,null,null,"Lead Public Agency:",null,{"$f":"'INVOICE 1'!I7","v":"City of Pasadena Public Health Department"}]
[]
["Contract #:",{"$f":"'INVOICE 1'!B9","v":"853-17"},null,null,"Term:",{"$f":"'INVOICE 1'!F9","v":"2018-05-01"},"TO",null,{"$f":"'INVOICE 1'!I9","v":"2021-08-15"},null,null,null,null,"Invoicing Frequency",{"$f":"'INVOICE 1'!O9","v":"Quarterly"}]
[]
["Invoice #:","14 CALVIP 18",null,null,"Reporting Period:","2021-05-01","TO",null,"2021-08-16","Due:","2021-06-15",null,null,"Final Invoice (Y/N):","Yes"]
[]
["Line Items","Budget",null,null,null,"Prior Expenditures",null,null,null,"This Reporting Period",null,null,null,"Balance"]
[null,"Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL","Grant Funds","Cash Match","In-kind Match","TOTAL"]
[{"$f":"'INVOICE 1'!A15","v":"Salaries & Benefits"},{"$f":"'INVOICE 12'!B15","v":160000},{"$f":"'INVOICE 12'!C15","v":270584},{"$f":"'INVOICE 12'!D15","v":0},{"$f":"SUM(B15:D15)","v":430584},{"$f":"SUM('INVOICE 12'!F15,'INVOICE 12'!J15)","v":49227},{"$f":"SUM('INVOICE 12'!G15,'INVOICE 12'!K15)","v":97161},{"$f":"SUM('INVOICE 12'!H15,'INVOICE 12'!L15)","v":0},{"$f":"SUM(F15:H15)","v":146388},0,0,0,{"$f":"SUM(J15:L15)","v":0},{"$f":"B15-F15-J15","v":110773},173423,0,{"$f":"SUM(N15:P15)","v":284196}]
[{"$f":"'INVOICE 1'!A16","v":"Services & Supplies"},{"$f":"'INVOICE 12'!B16","v":14325},{"$f":"'INVOICE 12'!C16","v":0},{"$f":"'INVOICE 12'!D16","v":0},{"$f":"SUM(B16:D16)","v":14325},{"$f":"SUM('INVOICE 12'!F16,'INVOICE 12'!J16)","v":4537},{"$f":"SUM('INVOICE 12'!G16,'INVOICE 12'!K16)","v":0},{"$f":"SUM('INVOICE 12'!H16,'INVOICE 12'!L16)","v":0},{"$f":"SUM(F16:H16)","v":4537},0,0,0,{"$f":"SUM(J16:L16)","v":0},9788,0,0,{"$f":"SUM(N16:P16)","v":9788}]
[{"$f":"'INVOICE 1'!A17","v":"Prof Services / Public Agency Subcontracts"},{"$f":"'INVOICE 12'!B17","v":49626},{"$f":"'INVOICE 12'!C17","v":0},{"$f":"'INVOICE 12'!D17","v":0},49626,{"$f":"SUM('INVOICE 12'!F17,'INVOICE 12'!J17)","v":39844},{"$f":"SUM('INVOICE 12'!G17,'INVOICE 12'!K17)","v":0},{"$f":"SUM('INVOICE 12'!H17,'INVOICE 12'!L17)","v":0},39844,0,0,0,0,9782,0,0,9782]
[{"$f":"'INVOICE 1'!A18","v":"CBO Subcontracts"},{"$f":"'INVOICE 12'!B18","v":248731},{"$f":"'INVOICE 12'!C18","v":0},{"$f":"'INVOICE 12'!D18","v":0},248731,{"$f":"SUM('INVOICE 12'!F18,'INVOICE 12'!J18)","v":221597},{"$f":"SUM('INVOICE 12'!G18,'INVOICE 12'!K18)","v":0},{"$f":"SUM('INVOICE 12'!H18,'INVOICE 12'!L18)","v":0},221597,0,0,0,0,27134,0,0,27134]
[{"$f":"'INVOICE 1'!A19","v":"Indirect Costs"},{"$f":"'INVOICE 12'!B19","v":16000},{"$f":"'INVOICE 12'!C19","v":27058},{"$f":"'INVOICE 12'!D19","v":0},{"$f":"SUM(B19:D19)","v":43058},{"$f":"SUM('INVOICE 12'!F19,'INVOICE 12'!J19)","v":4950},{"$f":"SUM('INVOICE 12'!G19,'INVOICE 12'!K19)","v":21000},{"$f":"SUM('INVOICE 12'!H19,'INVOICE 12'!L19)","v":0},{"$f":"SUM(F19:H19)","v":25950},0,0,0,{"$f":"SUM(J19:L19)","v":0},{"$f":"B19-F19-J19","v":11050},{"$f":"C19-G19-K19","v":6058},{"$f":"D19-H19-L19","v":0},{"$f":"SUM(N19:P19)","v":17108}]
[{"$f":"'INVOICE 1'!A20","v":"Fixed Assets/Equipment"},{"$f":"'INVOICE 12'!B20","v":0},{"$f":"'INVOICE 12'!C20","v":0},{"$f":"'INVOICE 12'!D20","v":0},0,{"$f":"SUM('INVOICE 12'!F20,'INVOICE 12'!J20)","v":0},{"$f":"SUM('INVOICE 12'!G20,'INVOICE 12'!K20)","v":0},{"$f":"SUM('INVOICE 12'!H20,'INVOICE 12'!L20)","v":0},0,0,0,0,0,0,0,0,0]
[{"$f":"'INVOICE 1'!A21","v":"Project Evaluation"},{"$f":"'INVOICE 12'!B21","v":0},{"$f":"'INVOICE 12'!C21","v":0},{"$f":"'INVOICE 12'!D21","v":10000},10000,{"$f":"SUM('INVOICE 12'!F21,'INVOICE 12'!J21)","v":0},{"$f":"SUM('INVOICE 12'!G21,'INVOICE 12'!K21)","v":0},{"$f":"SUM('INVOICE 12'!H21,'INVOICE 12'!L21)","v":0},0,0,0,0,0,0,0,10000,10000]
[{"$f":"'INVOICE 1'!A22","v":"Other"},{"$f":"'INVOICE 12'!B22","v":8780},{"$f":"'INVOICE 12'!C22","v":0},{"$f":"'INVOICE 12'!D22","v":197699},206479,{"$f":"SUM('INVOICE 12'!F22,'INVOICE 12'!J22)","v":3625},{"$f":"SUM('INVOICE 12'!G22,'INVOICE 12'!K22)","v":0},{"$f":"SUM('INVOICE 12'!H22,'INVOICE 12'!L22)","v":1264},4889,0,0,0,0,5155,0,196435,201590]
["TOTAL",{"$f":"SUM(B15:B22)","v":497462},297642,207699,1002803,323780,118161,1264,443205,0,0,0,0,173682,179481,206435,559598]
[]
["Project Income",null,null,"Income reported to date",{"$f":"'INVOICE 1'!E25+'INVOICE 14'!L25","v":0},null,null,"Prior allocated income",0,null,"This Period",0,null,null,null,"Unallocated income balance",{"$f":"E25-I25","v":0}]
[]
[null,null,"Grant funds expended to date:",null,{"$f":"SUM(F23,J23)","v":323780},null,null,null,"Grant funds claimed this period:",{"$f":"J23","v":0},null,null,null,null,"Percentage Grant $$ expended to date:",null,{"$f":"E27/B23","v":0.65086378457047978}]
[null,null,"Cash match to date:",null,{"$f":"SUM(G23,K23)","v":118161},null,null,null,null,null,null,null,null,null,"% of Total Obligated Cash Match to date:",null,{"$f":"E28/C23","v":0.39699034410466266}]
[null,null,"In-kind match to date:",null,{"$f":"SUM(H23,L23)","v":1264},null,null,null,null,null,null,null,null,null,"% of Total Obligated In-kind Match to date:",null,{"$f":"E29/D23","v":6.0857298301869528E-3}]
[]
[null,null,null,null,"Expenditure Descriptions - Units / $ Amounts",null,null,null,null,null,null,null,null,null,"Comments"]
["Salaries & Benefits","Grant Funds",null,{"$f":"J15","v":0}]
[null,"Cash Match",null,{"$f":"K15","v":0}]
[null,"In-kind Match",null,{"$f":"K16","v":0}]
["Services & Supplies","Grant Funds",null,{"$f":"J16","v":0}]
[null,"Cash Match",null,{"$f":"K16","v":0}]
[null,"In-kind Match",null,{"$f":"L16","v":0}]
["Prof Services / Public Agency Subcontracts","Grant Funds",null,{"$f":"J17","v":0}]
[null,"Cash Match",null,{"$f":"K17","v":0}]
[null,"In-kind Match",null,{"$f":"L17","v":0}]
["CBO Subcontracts","Grant Funds",null,{"$f":"J18","v":0}]
[null,"Cash Match",null,{"$f":"K18","v":0}]
[null,"In-kind Match",null,{"$f":"L18","v":0}]
["Indirect Costs","Grant Funds",null,{"$f":"J20","v":0}]
[null,"Cash Match",null,{"$f":"K20","v":0}]
[null,"In-kind Match",null,{"$f":"L20","v":0}]
["Equip/Fixed Assets","Grant Funds",null,{"$f":"J21","v":0}]
[null,"Cash Match",null,{"$f":"K21","v":0}]
[null,"In-kind Match",null,{"$f":"-L21","v":0}]
["Project Evaluation","Grant Funds",null,{"$f":"J22","v":0}]
[null,"Cash Match",null,{"$f":"K22","v":0}]
[null,"In-kind Match",null,{"$f":"L22","v":0}]
["Other","Grant Funds",null,{"$f":"J19","v":0}]
[null,"Cash Match",null,{"$f":"K19","v":0}]
[null,"In-kind Match",null,{"$f":"L19","v":0}]
["Project Income",null,null,{"$f":"M25","v":0}]
["PERSON PREPARING REPORT",null,null,null,null,"AUTHORIZED FINANCIAL OFFICER",null,null,null,null,null,null,null,"BSCC Supplier Data - Internal Use Only"]
[null,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,null,null,{"$f":"'INVOICE 12'!N59:Q59","v":"0000042790"}]
["Name, Title",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N60:Q60","v":"Supplier ID"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!N61:Q61","v":"CITY OF PASADENA PUBLIC HEALTH DEPARTMENT"}]
["Phone",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N62:Q62","v":"Supplier Name"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!N63:Q63","v":"1845 N FAIR OAKS AVE"}]
["Email",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N64:Q64","v":"Address Line 1"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 12'!N65:Q65","v":"PASADENA, CA 91103"}]
["Date",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'INVOICE 1'!N66:Q66","v":"Address Line 2"}]
[]
[]
[null,null,null,null,null,"Name, Title"]
[]
[null,null,null,null,null,"Phone"]
[]
[null,null,null,null,null,"Date"]
[]
["BSCC USE ONLY"]
["Date Received:",null,null,null,null,null,null,null,"Approved By:",null,null,null,null,null,"Date:"]
[null,null,null,null,null,null,null,null,null,null,"BSCC Field Representative"]

{"sheet":"Project Budget NARRATIVE","index":15,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[[25,0,25,7],[26,0,26,7],[27,0,27,7],[31,0,31,7],[32,0,32,7],[36,0,36,7],[35,0,35,7],[30,0,30,7],[33,0,33,7],[28,0,28,7],[10,0,10,7],[15,0,15,7],[20,0,20,7],[23,0,23,7],[18,0,18,7],[19,0,19,7],[12,0,12,7],[22,0,22,7],[17,0,17,7],[16,0,16,7],[13,0,13,7],[14,0,14,7],[0,0,0,7],[8,0,8,7],[9,0,9,7],[6,0,6,2],[7,0,7,7],[4,0,4,7],[5,0,5,7],[3,0,3,7],[2,0,2,7]]}
["PROJECT BUDGET NARRATIVE & MODIFICATIONS"]
["Salaries and Benefits"]
["1. SALARIES AND BENEFITS\n\na. Grant Funds Requested: $160,000\n\nNarrative Detail:\n(see also Grantee Salaries and Benefits Worksheet for back-up)\n\nProgram Coordinator I: Will provide administrative oversight for the grant and staff.\n0.50 FTE in Year 1 (5 months) = $25,589\n0.50 FTE in Year 2 (12 months) = $61,414\nTotal (Years 1 and 2) = $87,003\n\nSocial Worker: Responsible for the budget, work plan, and project schedule, assist with implementing project activities, oversee the Community Advocate contractor, coordinate with the project’s Executive Advisors, and coordinate the activities of the Advisory Council.\n0.50 FTE in Year 1 (5 months) = $22,587\n0.35 FTE in Year 2 (12 months) = $37,947\nTotal (Years 1 and 2) = $60,534\n\nCase Manager (CSR III): Responsible for providing intensive case management to program youth and families, and connecting them to existing services.\n0.20 in Year 1 only (6 months) = $6,453\n\nGrant Administrator: Administrative support for the grant. \n0.05 FTE in Year 1 (6 months) = $1,933\n0.05 FTE in Year 2 (12 months) = $3,837\nTotal (Years 1 and 2) = $5,770\n\nb. Cash Match: $270,584\n\nNarrative Detail:\n(see also Grantee Salaries and Benefits Worksheet for back-up)\n\nCase Manager (CSR III): Responsible for providing intensive case management to program youth and families, and connecting them to existing services.\n0.80 FTE in Year 1 (6 months) = $25,813\n0.80 FTE  in Year 2 (6 months) = $25,813\nTotal Match (Years 1 and 2) = $51,626\n\nGrant Administrator: Administrative support for the grant. \n0.10 FTE in Year 1 (6 months) = $3,867\n0.05 FTE in Year 2 (12 months) = $3,867\nTotal Match (Years 1 and 2) = $7,734\n\nOffice Assistant: Responsible for ensuring all grant requirements are met, and managing billing to the BSCC and contractor invoicing.\n0.05 FTE in Year 1 (12 months) = $3,234\n0.05 FTE in Year 2 (12 months) = $3,234\nTotal Match (Years 1 and 2) = $6,468\n\nPPHD Division Manager: Will provide executive level project monitoring, assist staff with the community outreach component, and assist with overseeing the CBO and project consultants.  \n0.20 FTE in Year 1 = $40,175\n0.20 FTE in Year 2 = $40,175\nTotal Match (Years 1 and 2) = $80,350\n\nVarious Social Work Interns:\n1.00 FTE Equivalent in Year 1 = $62,203\n1.00 FTE Equivalent in Year 2 = $62,203\nTotal Match (Years 1 and 2) = $124,406\n\nBenefits (already included in calculations above):  The City’s benefits rate of 51.74% covers: vacation and sick leave, Public Employee Retirement System, health and dental insurance, life insurance, Medicare, long-term disability, general liability insurance, workmen’s compensation insurance, and costs for benefits administration.\n"]
["MOD x  APPROVAL DATE:  5/22/19"]
[]
[]
["Services and Supplies Narrative: "]
["2. SERVICES AND SUPPLIES\n\na. Grant Funds Requested: $14,325\n\nNarrative Detail:   \n\nGeneral Office Supplies (paper, printer toner/ink, etc.): $2,325\n\nSupplies for Community Events (tents, marketing, logistics, etc.):\n$1,000/per event x 4 events per year x 2 years = $8,000\n\nReproduction for the Proposed Violence Intervention and Prevention Campaign (posters, leaflets, handouts, etc.):  $2,000 per year x 2 years = $4,000\n\nb. Match: $0    Narrative Detail: Not Applicable\n"]
["MOD x  APPROVAL DATE:  5/22/19"]
[]
[null,null,null,null,null,null,null,null,"2021-08-16"]
["Professional Services / Public Agency Subcontracts Narrative"]
["3. PROFESSIONAL SERVICES\n\na. Grant Funds Requested: $49,626\n\nNarrative Detail:  Police Training Consultant to conduct training for City police to improve community-police relations; based on national models such as the U.S. Department of Justice’s “National Initiative for Building Community Trust and Justice” (Why’d You Stop Me?) or other similar programs:\n$49,626 to conduct multiple trainings for all City officers in Years 1-2.  \n\nb. Match: $0     Narrative Detail: Not applicable\n"]
["MOD x  APPROVAL DATE:  5/22/19"]
[]
[]
["Community-Based Organizations (CBO) Subcontracts Narrative"]
["4. COMMUNITY-BASED ORGANIZATION (CBO) SUBCONTRACTS\n\na. Grant Funds Requested: $248,731 (50% of the Grant Funds)\n\nNarrative Detail:  \n\n1) The PPHD will develop and issue a Request for Qualifications to hire a CBO/FBO that will provide experienced Community Advocates/Violence Interventionists to implement the Credible Messenger Program. Plan is to hire one 1.0 FTE Lead Interventionist and two 0.75 FTE Community Advocates/ Interventionists at approximately $17-20 per hour. Total = $224,731\n\n2) The PPHD will issue a sole source consulting agreement to Live Above the Hype, a program that offers training to police and youth.  Year 1:  $12,000 (0.60 FTE); Year 2:  $12,000 (0.60 FTE) = $24,000.  Costs include limited benefits and overhead.    \n\nb. Match: $0    Narrative Detail: Not applicable\n\n"]
["MOD x  APPROVAL DATE:  5/22/19"]
[]
[]
["Equipment/Fixed Assets Narrative "]
[]
[]
["Project Evaluation Narrative:"]
["7. PROJECT EVALUATION\n\na. Grant Funds Requested: $0     Narrative Detail: Not applicable\n\nb. Match: $10,000\n\nNarrative Detail:  $100/hour x 250 hours/year x 1.4 years = $35,000 total cost (only $10,000 claimed against the grant)\n\nA local university will serve as the project evaluator, and their services will be provided in-kind.  The college is seeking to engage in local partnerships and build their standing and impact in the community.  The evaluator will be responsible for developing the Evaluation Plan, developing all data collection instruments, training staff on data collection methods, conducting the project’s needs assessment (including focus groups and community surveys), and developing Final Evaluation Report.  \n\n"]
["MOD x  APPROVAL DATE:  5/22/19"]
[]
[]
["Other (Travel, Training, etc.) Narrative:"]
["a. Grant Funds Requested: $8,780\n\nNarrative Detail:\n\nBSCC Orientation and Training:  Travel to Sacramento in Year 1 for Orientation.  Costs per person = $878:  $300/airfare, $300 lodging for two nights, $150 for ground transportation, and $128 for meals and incidentals.  $878/person x 5 persons x 1 trip = $4,390\n\n\n\nStaff Training: $1,120. Held in reserve for other staff development and training opportunities.\n\nMileage: 3,000 miles/year x$0.545 x 2 years = $3,270\n\nb. Match: $197,699\n\nNarrative Detail:  Leveraged costs and the value of existing programs that will be used by program youth and their families:  \n\n1) Project Wraparound: $3,905/family x 20 families/year = $78,100 (based on annual program cost and number of youth currently being served)\n\n2) Mental Health Services & Substance Use Outpatient: estimated value $4,015.94 x 20 youth clients = $80,319\n\n3) Cost to Use the Jackie Robinson Community Center as the Project’s Community-Based Office:  $1,220/month (based on square footage for one office) x 24 months = $29,280\n\n4) Design the Violence Intervention and Prevention Campaign:  The PPHD’s Youth Advisory Board will develop the campaign brand and multiple designs for posters, leaflets, banners, etc. Valued at $10,000 if contracted to a design firm.  \n"]
["MOD x  APPROVAL DATE:  5/22/19"]
[]
[]
["Indirect Costs Narrative:"]
["5. INDIRECT COSTS\na. Grant Funds Requested: $16,000\n\nNarrative Detail:  The City of Pasadena’s current indirect rate is 19.449%. The PPHD is proposing a 10% indirect rate (based on salaries and benefits) to stay within the parameters of the CalVIP program’s requirements.  A copy of the City’s Cost Allocation Plan is available upon request.\n\nb. Cash Match: $27,058   Narrative Detail: See description above.\n"]

{"sheet":"INVOICE DUE DATES","index":16,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Invoice #","Reporting Period ","Due Date"]
["Invoice 1","May 1, 2018 to June 30, 2018","2018-08-15"]
["Invoice 2","July 1, 2018 to September 30, 2018","2018-11-15"]
["Invoice 3","October 1, 2018 to December 31, 2018","2018-02-15"]
["Invoice 4","January 1, 2019 to March 31, 2019","May 15/2019"]
["Invoice 5","April 1, 2019 to June 30, 2019","2019-08-15"]
["Invoice 6","July 1, 2019 to September 30, 2019","2020-11-15"]
["Invoice 7","October 1, 2019 to December 31, 2019","2020-02-15"]
["Invoice 8","January 1, 2020 to March 31, 2020","2020-05-15"]
["Invoice 9","April 1, 2020 to June 30, 2020","2020-08-15"]
["Invoice 10","July 1, 2020 to September 30, 2020","2020-11-15"]
["Invoice 11","October 1, 2020 to December 31, 2020","2021-02-15"]
["Invoice 12","January 1, 2021 to March 31, 2021","2021-05-14"]
["Invoice 13","April 1, 2021 to April 30, 2021","2021-06-15"]
["Invoice 14","May 1, 2021 to August 16, 2021*","2021-06-15"]
["*Note: Only expenditures associated with completion of the Final Local Evaluation Report may be included on this last invoice."]

{"sheet":"INSTRUCTIONS ","index":17,"n_rows":88,"n_cols":9,"rows_kept":88,"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. ","14 CALVIP 18",null,null,null,"2021-05-01",null,null,"2021-08-16"]
[]
["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:"]
[" -  Invoice (Form BSCC 201) for each reporting period;"]
[" -  Modification Request (Form BSCC 223.1 Rev 4/20);"]
[" -  Project Budget Narrative"]
[" -  Invoice Due Dates"]
[" -  Instructions."]
[]
["Passwords and Formulas in the Invoice Workbook"]
["Each time the grantee opens the Invoice workbook, they will be prompted to enter a password. The password is the grant agreement number (e.g. 990-19, include the -, do not include BSCC)."]
[]
["The Invoice Workbook has specific functions which require macros to be enabled. A macro is a series of commands, such as calculations, that are stored within the document for tasks performed repeatedly. In most cases, Excel will prompt the grantee to enable macros. When this prompt appears, select Enable Editing then Enable Content. Enabling macros for the Invoice Workbook will not compromise the security of the local system nor the security of the agency's network."]
[]
[]
["Financial Invoice - Form BSCC 201"]
[]
["How to Complete a Financial Invoice "]
["Each Financial Invoice has a separate workbook tab titled, INVOICE #. The Financial Invoice will allow grantees to enter data into the green-shaded fields; all other fields are locked. "]
[]
["The following instructions are for the green-shaded fields the Invoice to be completed by the Grantee. "]
[]
[" THIS REPORTING PERIOD"]
["The grantee shall enter the line item expenditures and match contributions incurred during the reporting period."]
["All expenditures should be rounded to the nearest whole dollar; do not enter decimals."]
["If an amount entered into a cell is greater than the available balance, an Invalid Dollar error message will appear. If the error is typographical, select Retry and enter the correct amount. If the amount entered is correct, however greater than the available balance, select Cancel and submit a Budget Modification. See, Budget Modification details below. "]
[]
["EXPENDITURE DESCRIPTION"]
["For each dollar amount entered as an expenditure, enter a brief but detailed description. Your expenditures should correlate to Project Budget Narrative, which is listed on its own tab along with approved modification requests. "]
[]
[" PERSON PREPARING REPORT"]
["The grantee will designate an individual to prepare invoices. The Authorized Financial Officer cannot prepare invoices. "]
["The individual who prepares invoices will provide their contact information and the date the invoice was prepared under the PERSON PREPARING REPORT section. Then, forward the Invoice Workbook to the Authorized Financial Officer for review and approval."]
[]
[" AUTHORIZED FINANCIAL OFFICER"]
["The Authorized Financial Officer is the Financial Officer listed in the Grant Agreement, STD 213 and/or Grantee Contact Information Sheet, Form 227."]
["The Authorized Financial Officer cannot be the Project Director or the individual preparing the invoice."]
["The Authorized Financial Officer must review each line item expenditure and description. Then, approve the invoice by checking the certification box and providing their contact information and the date of approval."]
["Once the invoice is approved, the Authorized Financial Officer shall email the Invoice Workbook to the any grant inbox: anygrant@bscc.ca.gov. The Authorized Financial Officer is the only authorized party to submit an Invoice Workbook to the BSCC."]
["Approved Financial Invoice "]
["Once BSCC staff reviews and approves the Financial Invoice, an updated Invoice Workbook will be available on the BSCC website. All approved Financial Invoices will be locked from editing but will be viewable in the Invoice Workbook."]
[]
["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-  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-  Modify the budget by moving funds from one line item to another; or\n-  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."]