{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["PMDT","Q1","Q2","Q3","Q4","Summary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"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":"PMDT","index":0,"n_rows":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[[30,6,32,6],[30,3,32,3],[30,4,32,4],[30,5,32,5],[20,6,22,6],[25,3,27,3],[25,4,27,4],[25,5,27,5],[25,6,27,6],[20,3,22,3],[20,4,22,4],[20,5,22,5],[9,6,11,6],[15,3,17,3],[15,4,17,4],[15,5,17,5],[15,6,17,6],[9,3,11,3],[9,4,11,4],[9,5,11,5]]}
["Agency:",null,null,"Program Start Date:"]
["Program:",null,null,"Program End Date:"]
["Performance Contact:"]
["Telephone:"]
["Contract Manager:"]
["Telephone:"]
[]
["Output:","Unduplicated Clients Served:"]
["Unduplicated Clients Served in 12-Month Period:",null,null,"Calculation Method","Specific Definitions, Inclusions, Exclusions, and Other Notes","Data Source for Measure?","Who is Responsible for Preparing and Reporting the Data?"]
["City Goal:"]
["Other Funding Goal:"]
["Total Program Goal:"]
[]
["Outputs - Supplemental:"]
["Supplemental Output 1:",null,null,"Calculation Method","Specific Definitions, Inclusions, Exclusions, and Other Notes","Data Source for Measure?","Who is Responsible for Preparing and Reporting the Data?"]
["City Goal:"]
["Other Funding Goal:"]
["Total Program Goal:"]
[]
["Supplemental Output 2:",null,null,"Calculation Method","Specific Definitions, Inclusions, Exclusions, and Other Notes","Data Source for Measure?","Who is Responsible for Preparing and Reporting the Data?"]
["City Goal:"]
["Other Funding Goal:"]
["Total Program Goal:"]
[]
["Supplemental Output 3:",null,null,"Calculation Method","Specific Definitions, Inclusions, Exclusions, and Other Notes","Data Source for Measure?","Who is Responsible for Preparing and Reporting the Data?"]
["City Goal:"]
["Other Funding Goal:"]
["Total Program Goal:",{"$f":"SUM(B26:B27)","v":0}]
[]
["Supplemental Output 4:",null,null,"Calculation Method","Specific Definitions, Inclusions, Exclusions, and Other Notes","Data Source for Measure?","Who is Responsible for Preparing and Reporting the Data?"]
["City Goal:"]
["Other Funding Goal:"]
["Total Program Goal:",{"$f":"SUM(B31:B32)","v":0}]
[]
["Productivity Outputs:"]
["Productivity Goal Description:",null,null,"Calculation Method","Specific Definitions, Inclusions, Exclusions, and Other Notes","Data Source for Measure?","Who is Responsible for Preparing and Reporting the Data?"]
["Productivity Goal:"]
[]
["Productivity Goal Description:",null,null,"Calculation Method","Specific Definitions, Inclusions, Exclusions, and Other Notes","Data Source for Measure?","Who is Responsible for Preparing and Reporting the Data?"]
["Productivity Goal:"]
[]
["Outcomes - City Business Plans:"]
["Outcome City Business Plan","Outcomes - City Business Plan","Total Program Goal (As entered into PartnerGrants)","Calculation Method","Specific Definitions, Inclusions, Exclusions, and Other Notes","Data Source for Measure?","Who is Responsible for Preparing and Reporting the Data?"]
["Please Select",{"$f":"IF(A44=\"Please Select\",\"\",VLOOKUP(A44,$A$57:$D$71,2,FALSE))","v":""}]
[{"$f":"A44","v":"Please Select"},{"$f":"IF(A45=\"Please Select\",\"\",VLOOKUP(A45,$A$57:$D$71,3,FALSE))","v":""}]
[{"$f":"A44","v":"Please Select"},{"$f":"IF(A46=\"Please Select\",\"\",VLOOKUP(A46,$A$57:$D$71,4,FALSE))","v":""},{"$f":"IF(C45=0,\"\",SUM(C44/C45))","v":""}]
["Please Select",{"$f":"IF(A47=\"Please Select\",\"\",VLOOKUP(A47,$A$57:$D$71,2,FALSE))","v":""}]
[{"$f":"A47","v":"Please Select"},{"$f":"IF(A48=\"Please Select\",\"\",VLOOKUP(A48,$A$57:$D$71,3,FALSE))","v":""}]
[{"$f":"A47","v":"Please Select"},{"$f":"IF(A49=\"Please Select\",\"\",VLOOKUP(A49,$A$57:$D$71,4,FALSE))","v":""},{"$f":"IF(C48=0,\"\",SUM(C47/C48))","v":""}]
["Please Select",{"$f":"IF(A50=\"Please Select\",\"\",VLOOKUP(A50,$A$57:$D$71,2,FALSE))","v":""}]
[{"$f":"A50","v":"Please Select"},{"$f":"IF(A51=\"Please Select\",\"\",VLOOKUP(A51,$A$57:$D$71,3,FALSE))","v":""}]
[{"$f":"A50","v":"Please Select"},{"$f":"IF(A52=\"Please Select\",\"\",VLOOKUP(A52,$A$57:$D$71,4,FALSE))","v":""},{"$f":"IF(C51=0,\"\",SUM(C50/C51))","v":""}]
["Please Select",{"$f":"IF(A53=\"Please Select\",\"\",VLOOKUP(A53,$A$57:$D$71,2,FALSE))","v":""}]
[{"$f":"A53","v":"Please Select"},{"$f":"IF(A54=\"Please Select\",\"\",VLOOKUP(A54,$A$57:$D$71,3,FALSE))","v":""}]
[{"$f":"A53","v":"Please Select"},{"$f":"IF(A55=\"Please Select\",\"\",VLOOKUP(A55,$A$57:$D$71,4,FALSE))","v":""},{"$f":"IF(C54=0,\"\",SUM(C53/C54))","v":""}]
["City Business Plan Outcomes:","Numerator","Denominator","Rate"]
["1A","Number of households at risk of homelessness that maintain housing","Number of households receiving assistance","Percent of households at risk of homelessness that maintain housing"]
["1B","Number of case-managed households that transition from homelessness into housing","Number of households that exit the program","Percent of case-managed households that transition from homelessness into housing"]
["1C"," Number of households receiving services that maintain housing due to receiving essential services","Number of households receiving essential services","Percent of households that maintain housing due to receiving essential services"]
["1D","Number of Homeless Households residing in shelter programs receiving APH-funding who receive case management services"," Number of Homeless Households residing in shelter programs receiving APH-funding","Percentage of Homeless Households residing in shelter programs receiving APH-funding who receive case management services"]
["2Ai","Number of individuals obtaining employment","Number of individuals exiting the program","Percent of individuals obtaining employment"]
["2Aii","Number of individuals increasing employment income","Number of individuals exiting the program","Percent of individuals increasing employment income"]
["2B","Number of individuals obtaining or maintaining public benefits","Number of individuals in program","Percent of individuals who obtain or maintain public benefits"]
["3A","Number of individuals with improved mental health status as measured on a standardized assessment","Number of individuals “initially” evaluated with a standardized assessment","Percent of individuals whose mental health status as measured on a standardized assessment improves"]
["3B","Number of individuals making progress on their treatment plan goal(s","Number of individuals evaluated for progress on treatment plan goals(s)","Percent of individuals making progress toward their treatment plan goals"]
["4A","Number of young children who demonstrate typical language/communication skills for their age per the Ages and Stages Questionnaire","Number of young children for whom the Ages and Stages Questionnaire is administered","Number of young children for whom the Ages and Stages Questionnaire is administered"]
["4B","Number of youth served who progress to the next academic level","Number of youth who received services","Percent of youth who progress to the next academic level"]
["5A","Number of individuals who complete an educational program that improves their knowledge"," Number of individuals participating in the educational program","Percent of individuals who complete an educational program and demonstrate improved knowledge"]
["5B","Number of individuals demonstrating improved life skill(s)","Number of individuals participating in the activity","Percent of individuals who demonstrate improved life skills"]
["6A","Number of individuals who report improvement in physical, mental, emotional, or social functioning","Number of individuals receiving services through Health Equity Social Service Contracts","Percent of individuals who achieve healthy outcomes as a result of receiving services through Health Equity Social Service Contracts"]
["T1","Number of participants in digital inclusion programs that improved their basic digital skills","Number of participants in digital inclusion programs","Percent of participants in digital inclusion programs that improved their basic digital skills"]

{"sheet":"Q1","index":1,"n_rows":229,"n_cols":6,"rows_kept":229,"cut":false,"hidden":false,"merged":[[122,1,122,5],[0,1,0,5],[4,1,4,5],[8,1,8,5],[14,1,14,5],[39,1,39,5],[25,1,25,3],[19,1,19,3],[12,1,12,3],[65,1,65,3],[56,1,56,3],[46,1,46,3],[42,1,42,3],[37,1,37,3],[31,1,31,3],[48,1,48,5],[74,1,74,3],[120,1,120,3],[111,1,111,3],[102,1,102,3],[93,1,93,3],[83,1,83,3],[85,1,85,5]]}
["General Information:","The Status Report Type is Quarterly Performance"]
["Report Period:"]
[null,"From Date","To Date"]
[]
["Quarterly Performance:","Click Edit at the top of the screen to unlock, after the Unduplicated Clients Served section has been completed and any additional documents uploaded, select Save to return to the  main Status Report page"]
["Quarter Reported:",1]
["Total Possible Quarters:",4]
[]
["Unduplicated Clients Served:"]
["This Quarter:"]
["Carry-Forward/Roll-Over Clients:",null,{"$f":"SUM(PMDT!B12/4)","v":0},"<-Quarterly Goal"]
["Unduplicated Clients YTD:",{"$f":"SUM(B10:B11)","v":0},{"$f":"SUM(C11*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B10=0,\"\",SUM(B12/C12)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E12>=-0.1,E12<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outputs - Supplemental:","Click on the Output Description if applicable and enter information for this quarter and any adjustments for previous quarters or carry-forward clients in Q1, click Save after each is completed and repeat the process until all Supplemental Outputs have been entered"]
[{"$f":"PMDT!A15","v":"Supplemental Output 1:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B18/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B17:B18)","v":0},{"$f":"SUM(C18*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B17=0,\"\",SUM(B19/C19)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E19>=-0.1,E19<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A20","v":"Supplemental Output 2:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B23/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B23:B24)","v":0},{"$f":"SUM(C24*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B23=0,\"\",SUM(B25/C25)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E25>=-0.1,E25<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A25","v":"Supplemental Output 3:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B28/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B29:B30)","v":0},{"$f":"SUM(C30*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B29=0,\"\",SUM(B31/C31)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E31>=-0.1,E31<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A30","v":"Supplemental Output 4:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B33/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B35:B36)","v":0},{"$f":"SUM(C36*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B35=0,\"\",SUM(B37/C37)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E37>=-0.1,E37<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Productivity Outputs:","Click on the Productivity Output Description if applicable and enter information in only for Q4"]
[{"$f":"PMDT!A36","v":"Productivity Goal Description:"}]
["Productivity Actual:",null,{"$f":"PMDT!B37","v":0},"<-YTD Goal","Q4 Only","<-YTD Variance"]
[{"$f":"IF(AND(E42>=-0.1,E42<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A39","v":"Productivity Goal Description:"}]
["Productivity Actual:",null,{"$f":"PMDT!B40","v":0},"<-YTD Goal","Q4 Only","<-YTD Variance"]
[{"$f":"IF(AND(E46>=-0.1,E46<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outcomes City PMRU Plan","Click on the blue Issue Area link at the beginning of the row and then enter the required information and select Save, repeat until all Outcomes have been completed"]
[{"$f":"PMDT!B46","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B51,B53)","v":0},{"$f":"SUM(PMDT!C44/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C56=0,\"\",SUM(C55/C56))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B52,B54)","v":0},{"$f":"SUM(PMDT!C45/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B56=0,\"\",SUM((B55/B56)/E55)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E56>=-0.1,E56<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B49","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B60,B62)","v":0},{"$f":"SUM(PMDT!C47/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C65=0,\"\",SUM(C64/C65))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B61,B63)","v":0},{"$f":"SUM(PMDT!C48/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B65=0,\"\",SUM((B64/B65)/E64)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E65>=-0.1,E65<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B52","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B69,B71)","v":0},{"$f":"SUM(PMDT!C50/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C74=0,\"\",SUM(C73/C74))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B70,B72)","v":0},{"$f":"SUM(PMDT!C51/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B74=0,\"\",SUM((B73/B74)/E73)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E74>=-0.1,E74<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B55","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B78,B80)","v":0},{"$f":"SUM(PMDT!C53/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C83=0,\"\",SUM(C82/C83))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B79,B81)","v":0},{"$f":"SUM(PMDT!C54/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B83=0,\"\",SUM((B82/B83)/E82)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E83>=-0.1,E83<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outcomes - Supplemental:","Click on the blue Issue Area link at the beginning of the row and then enter the required information and select Save, repeat until all Outcomes have been completed"]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B88,B90)","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C93=0,\"\",SUM(C92/C93))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B89,B91)","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B93=0,\"\",SUM((B92/B93)/E92)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E93>=-0.1,E93<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B97,B99)","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C102=0,\"\",SUM(C101/C102))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B98,B100)","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B102=0,\"\",SUM((B101/B102)/E101)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E102>=-0.1,E102<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B106,B108)","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C111=0,\"\",SUM(C110/C111))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B107,B109)","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B111=0,\"\",SUM((B110/B111)/E110)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E111>=-0.1,E111<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B115,B117)","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C120=0,\"\",SUM(C119/C120))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B116,B118)","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B120=0,\"\",SUM((B119/B120)/E119)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E120>=-0.1,E120<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Quarterly Zip-Code and Demographics:","From the Components page, select the Quarterly Demographics link and then select the Edit option to begin entering the Demographics and Zip-Code data for all clients being reported on for the quarter, the number should equal the Unduplicated Clients Served count"]
[]
["Age","This Quarter Actuals","Carry-Forward/Roll-Over Clients","Revised Numbers","YTD:"]
["Under 5",null,null,{"$f":"SUM(B126:C126)","v":0},{"$f":"D126","v":0}]
["5 To 11",null,null,{"$f":"SUM(B127:C127)","v":0},{"$f":"D127","v":0}]
["12 To 14",null,null,0,0]
["15 To 17",null,null,0,0]
["18 To 24",null,null,0,0]
["25 To 39",null,null,0,0]
["40 To 54",null,null,0,0]
["55 To 64",null,null,0,0]
["65 To 74",null,null,0,0]
["75 And Older",null,null,0,0]
["Age - Balance Not Specified",null,null,0,0]
["Total Age",{"$f":"SUM(B126:B136)","v":0},{"$f":"SUM(C126:C136)","v":0},0,0,{"$f":"IF(E137=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Gender","This Quarter Actuals","Carry-Forward/Roll-Over Clients","Revised Numbers"]
["Female",null,null,{"$f":"SUM(B139:C139)","v":0},{"$f":"D139","v":0}]
["Male",null,null,{"$f":"SUM(B140:C140)","v":0},{"$f":"D140","v":0}]
["Transgender Female",null,null,0,0]
["Transgender Male",null,null,0,0]
["Gender - Balance Not Specified",null,null,0,0]
["Total Gender:",{"$f":"SUM(B139:B143)","v":0},{"$f":"SUM(C139:C143)","v":0},0,0,{"$f":"IF(E144=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Ethnicity","This Quarter Actuals","Carry-Forward/Roll-Over Clients","Revised Numbers"]
["Hispanic or Latino",null,null,{"$f":"SUM(B146:C146)","v":0},{"$f":"D146","v":0}]
["Not Hispanic or Latino",null,null,{"$f":"SUM(B147:C147)","v":0},{"$f":"D147","v":0}]
["Ethnicity - Balance Not Specified",null,null,0,0]
["Total Ethnicity:",{"$f":"SUM(B146:B148)","v":0},{"$f":"SUM(C146:C148)","v":0},0,0,{"$f":"IF(E149=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Race:","This Quarter Actuals","Carry-Forward/Roll-Over Clients","Revised Numbers"]
["American Indian or Alaskan Native",null,null,{"$f":"SUM(B151:C151)","v":0},{"$f":"D151","v":0}]
["Asian",null,null,{"$f":"SUM(B152:C152)","v":0},{"$f":"D152","v":0}]
["Black or African American",null,null,0,0]
["Native Hawaiian or Other Pacific Islander",null,null,0,0]
["White",null,null,0,0]
["Some Other Race",null,null,0,0]
["Two or More Races",null,null,0,0]
["Race - Balance Not Specified",null,null,0,0]
["Total Race:",{"$f":"SUM(B151:B158)","v":0},{"$f":"SUM(C151:C158)","v":0},0,0,{"$f":"IF(E159=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Income:","This Quarter Actuals","Carry-Forward/Roll-Over Clients","Revised Numbers"]
["Less than 50% FPIL",null,null,{"$f":"SUM(B161:C161)","v":0},{"$f":"D161","v":0}]
["50% to 100% FPIL",null,null,{"$f":"SUM(B162:C162)","v":0},{"$f":"D162","v":0}]
["101% to 150% FPIL",null,null,0,0]
["151% to 200% FPIL",null,null,0,0]
["More than 200% FPIL",null,null,0,0]
["Income - Balance Not Specified",null,null,0,0]
["Total Income:",{"$f":"SUM(B161:B166)","v":0},{"$f":"SUM(C161:C166)","v":0},0,0,{"$f":"IF(E167=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Zip-Codes:","This Quarter Actuals","Carry-Forward/Roll-Over Clients","Revised Numbers"]
[78610,null,null,{"$f":"SUM(B169:C169)","v":0},{"$f":"D169","v":0}]
[78617,null,null,{"$f":"SUM(B170:C170)","v":0},{"$f":"D170","v":0}]
[78620,null,null,0,0]
[78621,null,null,0,0]
[78641,null,null,0,0]
[78645,null,null,0,0]
[78652,null,null,0,0]
[78653,null,null,0,0]
[78654,null,null,0,0]
[78660,null,null,0,0]
[78664,null,null,0,0]
[78669,null,null,0,0]
[78701,null,null,0,0]
[78702,null,null,0,0]
[78703,null,null,0,0]
[78704,null,null,0,0]
[78705,null,null,0,0]
[78712,null,null,0,0]
[78717,null,null,0,0]
[78719,null,null,0,0]
[78721,null,null,0,0]
[78722,null,null,0,0]
[78723,null,null,0,0]
[78724,null,null,0,0]
[78725,null,null,0,0]
[78726,null,null,0,0]
[78727,null,null,0,0]
[78728,null,null,0,0]
[78729,null,null,0,0]
[78730,null,null,0,0]
[78731,null,null,0,0]
[78732,null,null,0,0]
[78733,null,null,0,0]
[78734,null,null,0,0]
[78735,null,null,0,0]
[78736,null,null,0,0]
[78737,null,null,0,0]
[78738,null,null,0,0]
[78739,null,null,0,0]
[78740,null,null,0,0]
[78741,null,null,0,0]
[78742,null,null,0,0]
[78744,null,null,0,0]
[78745,null,null,0,0]
[78746,null,null,0,0]
[78747,null,null,0,0]
[78748,null,null,0,0]
[78749,null,null,0,0]
[78750,null,null,0,0]
[78751,null,null,0,0]
[78752,null,null,0,0]
[78753,null,null,0,0]
[78754,null,null,0,0]
[78756,null,null,0,0]
[78757,null,null,0,0]
[78758,null,null,0,0]
[78759,null,null,0,0]
["Homeless",null,null,0,0]
["Out of County Zip Count",null,null,0,0]
["Unknown Zip Count",null,null,0,0]
["Total Zip Code",{"$f":"SUM(B169:B228)","v":0},{"$f":"SUM(C169:C228)","v":0},0,0,{"$f":"IF(E229=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]

{"sheet":"Q2","index":2,"n_rows":229,"n_cols":6,"rows_kept":229,"cut":false,"hidden":false,"merged":[[122,1,122,5],[0,1,0,5],[4,1,4,5],[8,1,8,5],[14,1,14,5],[39,1,39,5],[25,1,25,3],[19,1,19,3],[12,1,12,3],[65,1,65,3],[56,1,56,3],[46,1,46,3],[42,1,42,3],[37,1,37,3],[31,1,31,3],[48,1,48,5],[74,1,74,3],[120,1,120,3],[111,1,111,3],[102,1,102,3],[93,1,93,3],[83,1,83,3],[85,1,85,5]]}
["General Information:","The Status Report Type is Quarterly Performance"]
["Report Period:"]
[null,"From Date","To Date"]
[]
["Quarterly Performance:","Click Edit at the top of the screen to unlock, after the Unduplicated Clients Served section has been completed and any additional documents uploaded, select Save to return to the  main Status Report page"]
["Quarter Reported:",2]
["Total Possible Quarters:",4]
[]
["Unduplicated Clients Served:"]
["This Quarter:"]
["Adjusted Number:",null,{"$f":"SUM(PMDT!B12/4)","v":0},"<-Quarterly Goal"]
["Unduplicated Clients YTD:",{"$f":"SUM(B10:B11)+'Q1'!B12","v":0},{"$f":"SUM(C11*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B10=0,\"\",SUM(B12/C12)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E12>=-0.1,E12<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outputs - Supplemental:","Click on the Output Description if applicable and enter information for this quarter and any adjustments for previous quarters or carry-forward clients in Q1, click Save after each is completed and repeat the process until all Supplemental Outputs have been entered"]
[{"$f":"PMDT!A15","v":"Supplemental Output 1:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B18/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B17:B18)+'Q1'!B19","v":0},{"$f":"SUM(C18*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B17=0,\"\",SUM(B19/C19)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E19>=-0.1,E19<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A20","v":"Supplemental Output 2:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B23/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B23:B24)+'Q1'!B25","v":0},{"$f":"SUM(C24*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B23=0,\"\",SUM(B25/C25)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E25>=-0.1,E25<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A25","v":"Supplemental Output 3:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B28/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B29:B30)+'Q1'!B31","v":0},{"$f":"SUM(C30*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B29=0,\"\",SUM(B31/C31)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E31>=-0.1,E31<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A30","v":"Supplemental Output 4:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B33/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B35:B36)+'Q1'!B37","v":0},{"$f":"SUM(C36*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B35=0,\"\",SUM(B37/C37)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E37>=-0.1,E37<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Productivity Outputs:","Click on the Productivity Output Description if applicable and enter information in only for Q4"]
[{"$f":"PMDT!A36","v":"Productivity Goal Description:"}]
["Productivity Actual:",null,{"$f":"PMDT!B37","v":0},"<-YTD Goal","Q4 Only","<-YTD Variance"]
[{"$f":"IF(AND(E42>=-0.1,E42<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A39","v":"Productivity Goal Description:"}]
["Productivity Actual:",null,{"$f":"PMDT!B40","v":0},"<-YTD Goal","Q4 Only","<-YTD Variance"]
[{"$f":"IF(AND(E46>=-0.1,E46<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outcomes City PMRU Plan","Click on the blue Issue Area link at the beginning of the row and then enter the required information and select Save, repeat until all Outcomes have been completed"]
[{"$f":"PMDT!B46","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B51,B53)+'Q1'!B55","v":0},{"$f":"SUM(PMDT!C44/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C56=0,\"\",SUM(C55/C56))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B52,B54)+'Q1'!B56","v":0},{"$f":"SUM(PMDT!C45/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B56=0,\"\",SUM((B55/B56)/E55)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E56>=-0.1,E56<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B49","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B60,B62)+'Q1'!B64","v":0},{"$f":"SUM(PMDT!C47/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C65=0,\"\",SUM(C64/C65))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B61,B63)+'Q1'!B65","v":0},{"$f":"SUM(PMDT!C48/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B65=0,\"\",SUM((B64/B65)/E64)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E65>=-0.1,E65<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B52","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B69,B71)+'Q1'!B73","v":0},{"$f":"SUM(PMDT!C50/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C74=0,\"\",SUM(C73/C74))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B70,B72)+'Q1'!B74","v":0},{"$f":"SUM(PMDT!C51/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B74=0,\"\",SUM((B73/B74)/E73)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E74>=-0.1,E74<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B55","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B78,B80)+'Q1'!B82","v":0},{"$f":"SUM(PMDT!C53/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C83=0,\"\",SUM(C82/C83))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B79,B81)+'Q1'!B83","v":0},{"$f":"SUM(PMDT!C54/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B83=0,\"\",SUM((B82/B83)/E82)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E83>=-0.1,E83<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outcomes - Supplemental:","Click on the blue Issue Area link at the beginning of the row and then enter the required information and select Save, repeat until all Outcomes have been completed"]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B88,B90)+'Q1'!B92","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C93=0,\"\",SUM(C92/C93))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B89,B91)+'Q1'!B93","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B93=0,\"\",SUM((B92/B93)/E92)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E93>=-0.1,E93<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B97,B99)+'Q1'!B101","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C102=0,\"\",SUM(C101/C102))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B98,B100)+'Q1'!B102","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B102=0,\"\",SUM((B101/B102)/E101)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E102>=-0.1,E102<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B106,B108)+'Q1'!B110","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C111=0,\"\",SUM(C110/C111))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B107,B109)+'Q1'!B111","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B111=0,\"\",SUM((B110/B111)/E110)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E111>=-0.1,E111<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B115,B117)+'Q1'!B119","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C120=0,\"\",SUM(C119/C120))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B116,B118)+'Q1'!B120","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B120=0,\"\",SUM((B119/B120)/E119)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E120>=-0.1,E120<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Quarterly Zip-Code and Demographics:","From the Components page, select the Quarterly Demographics link and then select the Edit option to begin entering the Demographics and Zip-Code data for all clients being reported on for the quarter, the number should equal the Unduplicated Clients Served count"]
[]
["Age","This Quarter Actuals","Revisions","Revised Numbers","YTD:"]
["Under 5",null,null,{"$f":"SUM(B126:C126)","v":0},{"$f":"SUM(D126+'Q1'!E126)","v":0}]
["5 To 11",null,null,{"$f":"SUM(B127:C127)","v":0},{"$f":"SUM(D127+'Q1'!E127)","v":0}]
["12 To 14",null,null,0,{"$f":"SUM(D128+'Q1'!E128)","v":0}]
["15 To 17",null,null,0,{"$f":"SUM(D129+'Q1'!E129)","v":0}]
["18 To 24",null,null,0,{"$f":"SUM(D130+'Q1'!E130)","v":0}]
["25 To 39",null,null,0,{"$f":"SUM(D131+'Q1'!E131)","v":0}]
["40 To 54",null,null,0,{"$f":"SUM(D132+'Q1'!E132)","v":0}]
["55 To 64",null,null,0,{"$f":"SUM(D133+'Q1'!E133)","v":0}]
["65 To 74",null,null,0,{"$f":"SUM(D134+'Q1'!E134)","v":0}]
["75 And Older",null,null,0,{"$f":"SUM(D135+'Q1'!E135)","v":0}]
["Age - Balance Not Specified",null,null,0,{"$f":"SUM(D136+'Q1'!E136)","v":0}]
["Total Age",{"$f":"SUM(B126:B136)","v":0},{"$f":"SUM(C126:C136)","v":0},0,0,{"$f":"IF(E137=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Gender","This Quarter Actuals","Revisions","Revised Numbers"]
["Female",null,null,{"$f":"SUM(B139:C139)","v":0},{"$f":"SUM(D139+'Q1'!E139)","v":0}]
["Male",null,null,{"$f":"SUM(B140:C140)","v":0},{"$f":"SUM(D140+'Q1'!E140)","v":0}]
["Transgender Female",null,null,0,{"$f":"SUM(D141+'Q1'!E141)","v":0}]
["Transgender Male",null,null,0,{"$f":"SUM(D142+'Q1'!E142)","v":0}]
["Gender - Balance Not Specified",null,null,0,{"$f":"SUM(D143+'Q1'!E143)","v":0}]
["Total Gender:",{"$f":"SUM(B139:B143)","v":0},{"$f":"SUM(C139:C143)","v":0},0,0,{"$f":"IF(E144=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Ethnicity","This Quarter Actuals","Revisions","Revised Numbers"]
["Hispanic or Latino",null,null,{"$f":"SUM(B146:C146)","v":0},{"$f":"SUM(D146+'Q1'!E146)","v":0}]
["Not Hispanic or Latino",null,null,{"$f":"SUM(B147:C147)","v":0},{"$f":"SUM(D147+'Q1'!E147)","v":0}]
["Ethnicity - Balance Not Specified",null,null,0,{"$f":"SUM(D148+'Q1'!E148)","v":0}]
["Total Ethnicity:",{"$f":"SUM(B146:B148)","v":0},{"$f":"SUM(C146:C148)","v":0},0,0,{"$f":"IF(E149=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Race:","This Quarter Actuals","Revisions","Revised Numbers"]
["American Indian or Alaskan Native",null,null,{"$f":"SUM(B151:C151)","v":0},{"$f":"SUM(D151+'Q1'!E151)","v":0}]
["Asian",null,null,{"$f":"SUM(B152:C152)","v":0},{"$f":"SUM(D152+'Q1'!E152)","v":0}]
["Black or African American",null,null,0,{"$f":"SUM(D153+'Q1'!E153)","v":0}]
["Native Hawaiian or Other Pacific Islander",null,null,0,{"$f":"SUM(D154+'Q1'!E154)","v":0}]
["White",null,null,0,{"$f":"SUM(D155+'Q1'!E155)","v":0}]
["Some Other Race",null,null,0,{"$f":"SUM(D156+'Q1'!E156)","v":0}]
["Two or More Races",null,null,0,{"$f":"SUM(D157+'Q1'!E157)","v":0}]
["Race - Balance Not Specified",null,null,0,{"$f":"SUM(D158+'Q1'!E158)","v":0}]
["Total Race:",{"$f":"SUM(B151:B158)","v":0},{"$f":"SUM(C151:C158)","v":0},0,0,{"$f":"IF(E159=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Income:","This Quarter Actuals","Revisions","Revised Numbers"]
["Less than 50% FPIL",null,null,{"$f":"SUM(B161:C161)","v":0},{"$f":"SUM(D161+'Q1'!E161)","v":0}]
["50% to 100% FPIL",null,null,{"$f":"SUM(B162:C162)","v":0},{"$f":"SUM(D162+'Q1'!E162)","v":0}]
["101% to 150% FPIL",null,null,0,{"$f":"SUM(D163+'Q1'!E163)","v":0}]
["151% to 200% FPIL",null,null,0,{"$f":"SUM(D164+'Q1'!E164)","v":0}]
["More than 200% FPIL",null,null,0,{"$f":"SUM(D165+'Q1'!E165)","v":0}]
["Income - Balance Not Specified",null,null,0,{"$f":"SUM(D166+'Q1'!E166)","v":0}]
["Total Income:",{"$f":"SUM(B161:B166)","v":0},{"$f":"SUM(C161:C166)","v":0},0,0,{"$f":"IF(E167=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Zip-Codes:","This Quarter Actuals","Revisions","Revised Numbers"]
[78610,null,null,{"$f":"SUM(B169:C169)","v":0},{"$f":"SUM(D169+'Q1'!E169)","v":0}]
[78617,null,null,{"$f":"SUM(B170:C170)","v":0},{"$f":"SUM(D170+'Q1'!E170)","v":0}]
[78620,null,null,0,{"$f":"SUM(D171+'Q1'!E171)","v":0}]
[78621,null,null,0,{"$f":"SUM(D172+'Q1'!E172)","v":0}]
[78641,null,null,0,{"$f":"SUM(D173+'Q1'!E173)","v":0}]
[78645,null,null,0,{"$f":"SUM(D174+'Q1'!E174)","v":0}]
[78652,null,null,0,{"$f":"SUM(D175+'Q1'!E175)","v":0}]
[78653,null,null,0,{"$f":"SUM(D176+'Q1'!E176)","v":0}]
[78654,null,null,0,{"$f":"SUM(D177+'Q1'!E177)","v":0}]
[78660,null,null,0,{"$f":"SUM(D178+'Q1'!E178)","v":0}]
[78664,null,null,0,{"$f":"SUM(D179+'Q1'!E179)","v":0}]
[78669,null,null,0,{"$f":"SUM(D180+'Q1'!E180)","v":0}]
[78701,null,null,0,{"$f":"SUM(D181+'Q1'!E181)","v":0}]
[78702,null,null,0,{"$f":"SUM(D182+'Q1'!E182)","v":0}]
[78703,null,null,0,{"$f":"SUM(D183+'Q1'!E183)","v":0}]
[78704,null,null,0,{"$f":"SUM(D184+'Q1'!E184)","v":0}]
[78705,null,null,0,{"$f":"SUM(D185+'Q1'!E185)","v":0}]
[78712,null,null,0,{"$f":"SUM(D186+'Q1'!E186)","v":0}]
[78717,null,null,0,{"$f":"SUM(D187+'Q1'!E187)","v":0}]
[78719,null,null,0,{"$f":"SUM(D188+'Q1'!E188)","v":0}]
[78721,null,null,0,{"$f":"SUM(D189+'Q1'!E189)","v":0}]
[78722,null,null,0,{"$f":"SUM(D190+'Q1'!E190)","v":0}]
[78723,null,null,0,{"$f":"SUM(D191+'Q1'!E191)","v":0}]
[78724,null,null,0,{"$f":"SUM(D192+'Q1'!E192)","v":0}]
[78725,null,null,0,{"$f":"SUM(D193+'Q1'!E193)","v":0}]
[78726,null,null,0,{"$f":"SUM(D194+'Q1'!E194)","v":0}]
[78727,null,null,0,{"$f":"SUM(D195+'Q1'!E195)","v":0}]
[78728,null,null,0,{"$f":"SUM(D196+'Q1'!E196)","v":0}]
[78729,null,null,0,{"$f":"SUM(D197+'Q1'!E197)","v":0}]
[78730,null,null,0,{"$f":"SUM(D198+'Q1'!E198)","v":0}]
[78731,null,null,0,{"$f":"SUM(D199+'Q1'!E199)","v":0}]
[78732,null,null,0,{"$f":"SUM(D200+'Q1'!E200)","v":0}]
[78733,null,null,0,{"$f":"SUM(D201+'Q1'!E201)","v":0}]
[78734,null,null,0,{"$f":"SUM(D202+'Q1'!E202)","v":0}]
[78735,null,null,0,{"$f":"SUM(D203+'Q1'!E203)","v":0}]
[78736,null,null,0,{"$f":"SUM(D204+'Q1'!E204)","v":0}]
[78737,null,null,0,{"$f":"SUM(D205+'Q1'!E205)","v":0}]
[78738,null,null,0,{"$f":"SUM(D206+'Q1'!E206)","v":0}]
[78739,null,null,0,{"$f":"SUM(D207+'Q1'!E207)","v":0}]
[78740,null,null,0,{"$f":"SUM(D208+'Q1'!E208)","v":0}]
[78741,null,null,0,{"$f":"SUM(D209+'Q1'!E209)","v":0}]
[78742,null,null,0,{"$f":"SUM(D210+'Q1'!E210)","v":0}]
[78744,null,null,0,{"$f":"SUM(D211+'Q1'!E211)","v":0}]
[78745,null,null,0,{"$f":"SUM(D212+'Q1'!E212)","v":0}]
[78746,null,null,0,{"$f":"SUM(D213+'Q1'!E213)","v":0}]
[78747,null,null,0,{"$f":"SUM(D214+'Q1'!E214)","v":0}]
[78748,null,null,0,{"$f":"SUM(D215+'Q1'!E215)","v":0}]
[78749,null,null,0,{"$f":"SUM(D216+'Q1'!E216)","v":0}]
[78750,null,null,0,{"$f":"SUM(D217+'Q1'!E217)","v":0}]
[78751,null,null,0,{"$f":"SUM(D218+'Q1'!E218)","v":0}]
[78752,null,null,0,{"$f":"SUM(D219+'Q1'!E219)","v":0}]
[78753,null,null,0,{"$f":"SUM(D220+'Q1'!E220)","v":0}]
[78754,null,null,0,{"$f":"SUM(D221+'Q1'!E221)","v":0}]
[78756,null,null,0,{"$f":"SUM(D222+'Q1'!E222)","v":0}]
[78757,null,null,0,{"$f":"SUM(D223+'Q1'!E223)","v":0}]
[78758,null,null,0,{"$f":"SUM(D224+'Q1'!E224)","v":0}]
[78759,null,null,0,{"$f":"SUM(D225+'Q1'!E225)","v":0}]
["Homeless",null,null,0,{"$f":"SUM(D226+'Q1'!E226)","v":0}]
["Out of County Zip Count",null,null,0,{"$f":"SUM(D227+'Q1'!E227)","v":0}]
["Unknown Zip Count",null,null,0,{"$f":"SUM(D228+'Q1'!E228)","v":0}]
["Total Zip Code",{"$f":"SUM(B169:B228)","v":0},{"$f":"SUM(C169:C228)","v":0},0,0,{"$f":"IF(E229=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]

{"sheet":"Q3","index":3,"n_rows":229,"n_cols":6,"rows_kept":229,"cut":false,"hidden":false,"merged":[[122,1,122,5],[0,1,0,5],[4,1,4,5],[8,1,8,5],[14,1,14,5],[39,1,39,5],[25,1,25,3],[19,1,19,3],[12,1,12,3],[65,1,65,3],[56,1,56,3],[46,1,46,3],[42,1,42,3],[37,1,37,3],[31,1,31,3],[48,1,48,5],[74,1,74,3],[120,1,120,3],[111,1,111,3],[102,1,102,3],[93,1,93,3],[83,1,83,3],[85,1,85,5]]}
["General Information:","The Status Report Type is Quarterly Performance"]
["Report Period:",{"$f":"SUM('Q2'!C2+1)","v":"1900-01-01"},{"$f":"EDATE(B2, 3)-1","v":"1900-03-31"}]
[null,"From Date","To Date"]
[]
["Quarterly Performance:","Click Edit at the top of the screen to unlock, after the Unduplicated Clients Served section has been completed and any additional documents uploaded, select Save to return to the  main Status Report page"]
["Quarter Reported:",3]
["Total Possible Quarters:",4]
[]
["Unduplicated Clients Served:"]
["This Quarter:"]
["Adjusted Number:",null,{"$f":"SUM(PMDT!B12/4)","v":0},"<-Quarterly Goal"]
["Unduplicated Clients YTD:",{"$f":"SUM(B10:B11)+'Q2'!B12","v":0},{"$f":"SUM(C11*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B10=0,\"\",SUM(B12/C12)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E12>=-0.1,E12<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outputs - Supplemental:","Click on the Output Description if applicable and enter information for this quarter and any adjustments for previous quarters or carry-forward clients in Q1, click Save after each is completed and repeat the process until all Supplemental Outputs have been entered"]
[{"$f":"PMDT!A15","v":"Supplemental Output 1:"}]
["Output - This Quarter:",4]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B18/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B17:B18)+'Q2'!B19","v":4},{"$f":"SUM(C18*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B17=0,\"\",SUM(B19/C19)-1)","v":{"$error":"#DIV/0!"}},"<-YTD Variance"]
[{"$f":"IF(AND(E19>=-0.1,E19<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":{"$error":"#DIV/0!"}}]
[]
[{"$f":"PMDT!A20","v":"Supplemental Output 2:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B23/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B23:B24)+'Q2'!B25","v":0},{"$f":"SUM(C24*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B23=0,\"\",SUM(B25/C25)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E25>=-0.1,E25<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A25","v":"Supplemental Output 3:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B28/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B29:B30)+'Q2'!B31","v":0},{"$f":"SUM(C30*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B29=0,\"\",SUM(B31/C31)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E31>=-0.1,E31<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A30","v":"Supplemental Output 4:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B33/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B35:B36)+'Q2'!B37","v":0},{"$f":"SUM(C36*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B35=0,\"\",SUM(B37/C37)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E37>=-0.1,E37<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Productivity Outputs:","Click on the Productivity Output Description if applicable and enter information in only for Q4"]
[{"$f":"PMDT!A36","v":"Productivity Goal Description:"}]
["Productivity Actual:",null,{"$f":"PMDT!B37","v":0},"<-YTD Goal","Q4 Only","<-YTD Variance"]
[{"$f":"IF(AND(E42>=-0.1,E42<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A39","v":"Productivity Goal Description:"}]
["Productivity Actual:",null,{"$f":"PMDT!B40","v":0},"<-YTD Goal","Q4 Only","<-YTD Variance"]
[{"$f":"IF(AND(E46>=-0.1,E46<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outcomes City PMRU Plan","Click on the blue Issue Area link at the beginning of the row and then enter the required information and select Save, repeat until all Outcomes have been completed"]
[{"$f":"PMDT!B46","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B51,B53)+'Q2'!B55","v":0},{"$f":"SUM(PMDT!C44/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C56=0,\"\",SUM(C55/C56))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B52,B54)+'Q2'!B56","v":0},{"$f":"SUM(PMDT!C45/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B56=0,\"\",SUM((B55/B56)/E55)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E56>=-0.1,E56<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B49","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B60,B62)+'Q2'!B64","v":0},{"$f":"SUM(PMDT!C47/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C65=0,\"\",SUM(C64/C65))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B61,B63)+'Q2'!B65","v":0},{"$f":"SUM(PMDT!C48/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B65=0,\"\",SUM((B64/B65)/E64)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E65>=-0.1,E65<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B52","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B69,B71)+'Q2'!B73","v":0},{"$f":"SUM(PMDT!C50/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C74=0,\"\",SUM(C73/C74))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B70,B72)+'Q2'!B74","v":0},{"$f":"SUM(PMDT!C51/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B74=0,\"\",SUM((B73/B74)/E73)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E74>=-0.1,E74<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B55","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B78,B80)+'Q2'!B82","v":0},{"$f":"SUM(PMDT!C53/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C83=0,\"\",SUM(C82/C83))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B79,B81)+'Q2'!B83","v":0},{"$f":"SUM(PMDT!C54/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B83=0,\"\",SUM((B82/B83)/E82)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E83>=-0.1,E83<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outcomes - Supplemental:","Click on the blue Issue Area link at the beginning of the row and then enter the required information and select Save, repeat until all Outcomes have been completed"]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B88,B90)+'Q2'!B92","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C93=0,\"\",SUM(C92/C93))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B89,B91)+'Q2'!B93","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B93=0,\"\",SUM((B92/B93)/E92)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E93>=-0.1,E93<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B97,B99)+'Q2'!B101","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C102=0,\"\",SUM(C101/C102))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B98,B100)+'Q2'!B102","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B102=0,\"\",SUM((B101/B102)/E101)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E102>=-0.1,E102<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B106,B108)+'Q2'!B110","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C111=0,\"\",SUM(C110/C111))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B107,B109)+'Q2'!B111","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B111=0,\"\",SUM((B110/B111)/E110)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E111>=-0.1,E111<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B115,B117)+'Q2'!B119","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C120=0,\"\",SUM(C119/C120))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B116,B118)+'Q2'!B120","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B120=0,\"\",SUM((B119/B120)/E119)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E120>=-0.1,E120<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Quarterly Zip-Code and Demographics:","From the Components page, select the Quarterly Demographics link and then select the Edit option to begin entering the Demographics and Zip-Code data for all clients being reported on for the quarter, the number should equal the Unduplicated Clients Served count"]
[]
["Age","This Quarter Actuals","Revisions","Revised Numbers","YTD:"]
["Under 5",null,null,{"$f":"SUM(B126:C126)","v":0},{"$f":"SUM(D126+'Q2'!E126)","v":0}]
["5 To 11",null,null,{"$f":"SUM(B127:C127)","v":0},{"$f":"SUM(D127+'Q2'!E127)","v":0}]
["12 To 14",null,null,0,{"$f":"SUM(D128+'Q2'!E128)","v":0}]
["15 To 17",null,null,0,{"$f":"SUM(D129+'Q2'!E129)","v":0}]
["18 To 24",null,null,0,{"$f":"SUM(D130+'Q2'!E130)","v":0}]
["25 To 39",null,null,0,{"$f":"SUM(D131+'Q2'!E131)","v":0}]
["40 To 54",null,null,0,{"$f":"SUM(D132+'Q2'!E132)","v":0}]
["55 To 64",null,null,0,{"$f":"SUM(D133+'Q2'!E133)","v":0}]
["65 To 74",null,null,0,{"$f":"SUM(D134+'Q2'!E134)","v":0}]
["75 And Older",null,null,0,{"$f":"SUM(D135+'Q2'!E135)","v":0}]
["Age - Balance Not Specified",null,null,0,{"$f":"SUM(D136+'Q2'!E136)","v":0}]
["Total Age",{"$f":"SUM(B126:B136)","v":0},{"$f":"SUM(C126:C136)","v":0},0,0,{"$f":"IF(E137=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Gender","This Quarter Actuals","Revisions","Revised Numbers"]
["Female",null,null,{"$f":"SUM(B139:C139)","v":0},{"$f":"SUM(D139+'Q2'!E139)","v":0}]
["Male",null,null,{"$f":"SUM(B140:C140)","v":0},{"$f":"SUM(D140+'Q2'!E140)","v":0}]
["Transgender Female",null,null,0,{"$f":"SUM(D141+'Q2'!E141)","v":0}]
["Transgender Male",null,null,0,{"$f":"SUM(D142+'Q2'!E142)","v":0}]
["Gender - Balance Not Specified",null,null,0,{"$f":"SUM(D143+'Q2'!E143)","v":0}]
["Total Gender:",{"$f":"SUM(B139:B143)","v":0},{"$f":"SUM(C139:C143)","v":0},0,0,{"$f":"IF(E144=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Ethnicity","This Quarter Actuals","Revisions","Revised Numbers"]
["Hispanic or Latino",null,null,{"$f":"SUM(B146:C146)","v":0},{"$f":"SUM(D146+'Q2'!E146)","v":0}]
["Not Hispanic or Latino",null,null,{"$f":"SUM(B147:C147)","v":0},{"$f":"SUM(D147+'Q2'!E147)","v":0}]
["Ethnicity - Balance Not Specified",null,null,0,{"$f":"SUM(D148+'Q2'!E148)","v":0}]
["Total Ethnicity:",{"$f":"SUM(B146:B148)","v":0},{"$f":"SUM(C146:C148)","v":0},0,0,{"$f":"IF(E149=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Race:","This Quarter Actuals","Revisions","Revised Numbers"]
["American Indian or Alaskan Native",null,null,{"$f":"SUM(B151:C151)","v":0},{"$f":"SUM(D151+'Q2'!E151)","v":0}]
["Asian",null,null,{"$f":"SUM(B152:C152)","v":0},{"$f":"SUM(D152+'Q2'!E152)","v":0}]
["Black or African American",null,null,0,{"$f":"SUM(D153+'Q2'!E153)","v":0}]
["Native Hawaiian or Other Pacific Islander",null,null,0,{"$f":"SUM(D154+'Q2'!E154)","v":0}]
["White",null,null,0,{"$f":"SUM(D155+'Q2'!E155)","v":0}]
["Some Other Race",null,null,0,{"$f":"SUM(D156+'Q2'!E156)","v":0}]
["Two or More Races",null,null,0,{"$f":"SUM(D157+'Q2'!E157)","v":0}]
["Race - Balance Not Specified",null,null,0,{"$f":"SUM(D158+'Q2'!E158)","v":0}]
["Total Race:",{"$f":"SUM(B151:B158)","v":0},{"$f":"SUM(C151:C158)","v":0},0,0,{"$f":"IF(E159=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Income:","This Quarter Actuals","Revisions","Revised Numbers"]
["Less than 50% FPIL",null,null,{"$f":"SUM(B161:C161)","v":0},{"$f":"SUM(D161+'Q2'!E161)","v":0}]
["50% to 100% FPIL",null,null,{"$f":"SUM(B162:C162)","v":0},{"$f":"SUM(D162+'Q2'!E162)","v":0}]
["101% to 150% FPIL",null,null,0,{"$f":"SUM(D163+'Q2'!E163)","v":0}]
["151% to 200% FPIL",null,null,0,{"$f":"SUM(D164+'Q2'!E164)","v":0}]
["More than 200% FPIL",null,null,0,{"$f":"SUM(D165+'Q2'!E165)","v":0}]
["Income - Balance Not Specified",null,null,0,{"$f":"SUM(D166+'Q2'!E166)","v":0}]
["Total Income:",{"$f":"SUM(B161:B166)","v":0},{"$f":"SUM(C161:C166)","v":0},0,0,{"$f":"IF(E167=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Zip-Codes:","This Quarter Actuals","Revisions","Revised Numbers"]
[78610,null,null,{"$f":"SUM(B169:C169)","v":0},{"$f":"SUM(D169+'Q2'!E169)","v":0}]
[78617,null,null,{"$f":"SUM(B170:C170)","v":0},{"$f":"SUM(D170+'Q2'!E170)","v":0}]
[78620,null,null,0,{"$f":"SUM(D171+'Q2'!E171)","v":0}]
[78621,null,null,0,{"$f":"SUM(D172+'Q2'!E172)","v":0}]
[78641,null,null,0,{"$f":"SUM(D173+'Q2'!E173)","v":0}]
[78645,null,null,0,{"$f":"SUM(D174+'Q2'!E174)","v":0}]
[78652,null,null,0,{"$f":"SUM(D175+'Q2'!E175)","v":0}]
[78653,null,null,0,{"$f":"SUM(D176+'Q2'!E176)","v":0}]
[78654,null,null,0,{"$f":"SUM(D177+'Q2'!E177)","v":0}]
[78660,null,null,0,{"$f":"SUM(D178+'Q2'!E178)","v":0}]
[78664,null,null,0,{"$f":"SUM(D179+'Q2'!E179)","v":0}]
[78669,null,null,0,{"$f":"SUM(D180+'Q2'!E180)","v":0}]
[78701,null,null,0,{"$f":"SUM(D181+'Q2'!E181)","v":0}]
[78702,null,null,0,{"$f":"SUM(D182+'Q2'!E182)","v":0}]
[78703,null,null,0,{"$f":"SUM(D183+'Q2'!E183)","v":0}]
[78704,null,null,0,{"$f":"SUM(D184+'Q2'!E184)","v":0}]
[78705,null,null,0,{"$f":"SUM(D185+'Q2'!E185)","v":0}]
[78712,null,null,0,{"$f":"SUM(D186+'Q2'!E186)","v":0}]
[78717,null,null,0,{"$f":"SUM(D187+'Q2'!E187)","v":0}]
[78719,null,null,0,{"$f":"SUM(D188+'Q2'!E188)","v":0}]
[78721,null,null,0,{"$f":"SUM(D189+'Q2'!E189)","v":0}]
[78722,null,null,0,{"$f":"SUM(D190+'Q2'!E190)","v":0}]
[78723,null,null,0,{"$f":"SUM(D191+'Q2'!E191)","v":0}]
[78724,null,null,0,{"$f":"SUM(D192+'Q2'!E192)","v":0}]
[78725,null,null,0,{"$f":"SUM(D193+'Q2'!E193)","v":0}]
[78726,null,null,0,{"$f":"SUM(D194+'Q2'!E194)","v":0}]
[78727,null,null,0,{"$f":"SUM(D195+'Q2'!E195)","v":0}]
[78728,null,null,0,{"$f":"SUM(D196+'Q2'!E196)","v":0}]
[78729,null,null,0,{"$f":"SUM(D197+'Q2'!E197)","v":0}]
[78730,null,null,0,{"$f":"SUM(D198+'Q2'!E198)","v":0}]
[78731,null,null,0,{"$f":"SUM(D199+'Q2'!E199)","v":0}]
[78732,null,null,0,{"$f":"SUM(D200+'Q2'!E200)","v":0}]
[78733,null,null,0,{"$f":"SUM(D201+'Q2'!E201)","v":0}]
[78734,null,null,0,{"$f":"SUM(D202+'Q2'!E202)","v":0}]
[78735,null,null,0,{"$f":"SUM(D203+'Q2'!E203)","v":0}]
[78736,null,null,0,{"$f":"SUM(D204+'Q2'!E204)","v":0}]
[78737,null,null,0,{"$f":"SUM(D205+'Q2'!E205)","v":0}]
[78738,null,null,0,{"$f":"SUM(D206+'Q2'!E206)","v":0}]
[78739,null,null,0,{"$f":"SUM(D207+'Q2'!E207)","v":0}]
[78740,null,null,0,{"$f":"SUM(D208+'Q2'!E208)","v":0}]
[78741,null,null,0,{"$f":"SUM(D209+'Q2'!E209)","v":0}]
[78742,null,null,0,{"$f":"SUM(D210+'Q2'!E210)","v":0}]
[78744,null,null,0,{"$f":"SUM(D211+'Q2'!E211)","v":0}]
[78745,null,null,0,{"$f":"SUM(D212+'Q2'!E212)","v":0}]
[78746,null,null,0,{"$f":"SUM(D213+'Q2'!E213)","v":0}]
[78747,null,null,0,{"$f":"SUM(D214+'Q2'!E214)","v":0}]
[78748,null,null,0,{"$f":"SUM(D215+'Q2'!E215)","v":0}]
[78749,null,null,0,{"$f":"SUM(D216+'Q2'!E216)","v":0}]
[78750,null,null,0,{"$f":"SUM(D217+'Q2'!E217)","v":0}]
[78751,null,null,0,{"$f":"SUM(D218+'Q2'!E218)","v":0}]
[78752,null,null,0,{"$f":"SUM(D219+'Q2'!E219)","v":0}]
[78753,null,null,0,{"$f":"SUM(D220+'Q2'!E220)","v":0}]
[78754,null,null,0,{"$f":"SUM(D221+'Q2'!E221)","v":0}]
[78756,null,null,0,{"$f":"SUM(D222+'Q2'!E222)","v":0}]
[78757,null,null,0,{"$f":"SUM(D223+'Q2'!E223)","v":0}]
[78758,null,null,0,{"$f":"SUM(D224+'Q2'!E224)","v":0}]
[78759,null,null,0,{"$f":"SUM(D225+'Q2'!E225)","v":0}]
["Homeless",null,null,0,{"$f":"SUM(D226+'Q2'!E226)","v":0}]
["Out of County Zip Count",null,null,0,{"$f":"SUM(D227+'Q2'!E227)","v":0}]
["Unknown Zip Count",null,null,0,{"$f":"SUM(D228+'Q2'!E228)","v":0}]
["Total Zip Code",{"$f":"SUM(B169:B228)","v":0},{"$f":"SUM(C169:C228)","v":0},0,0,{"$f":"IF(E229=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]

{"sheet":"Q4","index":4,"n_rows":229,"n_cols":6,"rows_kept":229,"cut":false,"hidden":false,"merged":[[122,1,122,5],[0,1,0,5],[4,1,4,5],[8,1,8,5],[14,1,14,5],[39,1,39,5],[25,1,25,3],[19,1,19,3],[12,1,12,3],[65,1,65,3],[56,1,56,3],[46,1,46,3],[42,1,42,3],[37,1,37,3],[31,1,31,3],[48,1,48,5],[74,1,74,3],[120,1,120,3],[111,1,111,3],[102,1,102,3],[93,1,93,3],[83,1,83,3],[85,1,85,5]]}
["General Information:","The Status Report Type is Quarterly Performance"]
["Report Period:"]
[null,"From Date","To Date"]
[]
["Quarterly Performance:","Click Edit at the top of the screen to unlock, after the Unduplicated Clients Served section has been completed and any additional documents uploaded, select Save to return to the  main Status Report page"]
["Quarter Reported:",4]
["Total Possible Quarters:",4]
[]
["Unduplicated Clients Served:"]
["This Quarter:"]
["Adjusted Number:",null,{"$f":"SUM(PMDT!B12/4)","v":0},"<-Quarterly Goal"]
["Unduplicated Clients YTD:",{"$f":"SUM(B10:B11)+'Q3'!B12","v":0},{"$f":"SUM(C11*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B10=0,\"\",SUM(B12/C12)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E12>=-0.1,E12<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outputs - Supplemental:","Click on the Output Description if applicable and enter information for this quarter and any adjustments for previous quarters or carry-forward clients in Q1, click Save after each is completed and repeat the process until all Supplemental Outputs have been entered"]
[{"$f":"PMDT!A15","v":"Supplemental Output 1:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B18/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B17:B18)+'Q3'!B19","v":4},{"$f":"SUM(C18*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B17=0,\"\",SUM(B19/C19)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E19>=-0.1,E19<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A20","v":"Supplemental Output 2:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B23/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B23:B24)+'Q3'!B25","v":0},{"$f":"SUM(C24*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B23=0,\"\",SUM(B25/C25)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E25>=-0.1,E25<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A25","v":"Supplemental Output 3:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B28/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B29:B30)+'Q3'!B31","v":0},{"$f":"SUM(C30*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B29=0,\"\",SUM(B31/C31)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E31>=-0.1,E31<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A30","v":"Supplemental Output 4:"}]
["Output - This Quarter:"]
["Output - Adjusted:",null,{"$f":"SUM(PMDT!B33/4)","v":0},"<-Quarterly Goal"]
["YTD Output:",{"$f":"SUM(B35:B36)+'Q3'!B37","v":0},{"$f":"SUM(C36*$B$6)","v":0},"<-YTD Goal",{"$f":"IF(B35=0,\"\",SUM(B37/C37)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E37>=-0.1,E37<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Productivity Outputs:","Click on the Productivity Output Description if applicable and enter information in only for Q4"]
[{"$f":"PMDT!A36","v":"Productivity Goal Description:"}]
["Productivity Actual:",null,{"$f":"PMDT!B37","v":0},"<-YTD Goal",{"$f":"IF(B42=0,\"\",SUM(B42/C42)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E42>=-0.1,E42<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!A39","v":"Productivity Goal Description:"}]
["Productivity Actual:",null,{"$f":"PMDT!B40","v":0},"<-YTD Goal",{"$f":"IF(B46=0,\"\",SUM(B46/C46)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E46>=-0.1,E46<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outcomes City PMRU Plan","Click on the blue Issue Area link at the beginning of the row and then enter the required information and select Save, repeat until all Outcomes have been completed"]
[{"$f":"PMDT!B46","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B51,B53)+'Q3'!B55","v":0},{"$f":"SUM(PMDT!C44/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C56=0,\"\",SUM(C55/C56))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B52,B54)+'Q3'!B56","v":0},{"$f":"SUM(PMDT!C45/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B56=0,\"\",SUM((B55/B56)/E55)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E56>=-0.1,E56<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B49","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B60,B62)+'Q3'!B64","v":0},{"$f":"SUM(PMDT!C47/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C65=0,\"\",SUM(C64/C65))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B61,B63)+'Q3'!B65","v":0},{"$f":"SUM(PMDT!C48/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B65=0,\"\",SUM((B64/B65)/E64)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E65>=-0.1,E65<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B52","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B69,B71)+'Q3'!B73","v":0},{"$f":"SUM(PMDT!C50/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C74=0,\"\",SUM(C73/C74))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B70,B72)+'Q3'!B74","v":0},{"$f":"SUM(PMDT!C51/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B74=0,\"\",SUM((B73/B74)/E73)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E74>=-0.1,E74<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!B55","v":""}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B78,B80)+'Q3'!B82","v":0},{"$f":"SUM(PMDT!C53/4)*$B$6","v":0},"<-YTD Numerator Goal",{"$f":"IF(C83=0,\"\",SUM(C82/C83))","v":""},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B79,B81)+'Q3'!B83","v":0},{"$f":"SUM(PMDT!C54/4)*$B$6","v":0},"<-YTD Denominator Goal",{"$f":"IF(B83=0,\"\",SUM((B82/B83)/E82)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E83>=-0.1,E83<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Outcomes - Supplemental:","Click on the blue Issue Area link at the beginning of the row and then enter the required information and select Save, repeat until all Outcomes have been completed"]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B88,B90)+'Q3'!B92","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C93=0,\"\",SUM(C92/C93))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B89,B91)+'Q3'!B93","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B93=0,\"\",SUM((B92/B93)/E92)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E93>=-0.1,E93<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B97,B99)+'Q3'!B101","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C102=0,\"\",SUM(C101/C102))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B98,B100)+'Q3'!B102","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B102=0,\"\",SUM((B101/B102)/E101)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E102>=-0.1,E102<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B106,B108)+'Q3'!B110","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C111=0,\"\",SUM(C110/C111))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B107,B109)+'Q3'!B111","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B111=0,\"\",SUM((B110/B111)/E110)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E111>=-0.1,E111<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
["Numer - This Quarter:"]
["Denom - This Quarter:"]
["Numer - Adjusted:"]
["Denom - Adjusted:"]
["YTD Numer:",{"$f":"SUM(B115,B117)+'Q3'!B119","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Numerator Goal",{"$f":"IF(C120=0,\"\",SUM(C119/C120))","v":{"$error":"#REF!"}},"<-YTD Goal"]
["YTD Denom:",{"$f":"SUM(B116,B118)+'Q3'!B120","v":0},{"$f":"SUM(PMDT!#REF!/4)*$B$6","v":{"$error":"#REF!"}},"<-YTD Denominator Goal",{"$f":"IF(B120=0,\"\",SUM((B119/B120)/E119)-1)","v":""},"<-YTD Variance"]
[{"$f":"IF(AND(E120>=-0.1,E120<=0.1),\"No Variance Explanation Required\",\"YTD Variance Explanation:\")","v":"YTD Variance Explanation:"}]
[]
["Quarterly Zip-Code and Demographics:","From the Components page, select the Quarterly Demographics link and then select the Edit option to begin entering the Demographics and Zip-Code data for all clients being reported on for the quarter, the number should equal the Unduplicated Clients Served count"]
[]
["Age","This Quarter Actuals","Revisions","Revised Numbers","YTD:"]
["Under 5",null,null,{"$f":"SUM(B126:C126)","v":0},{"$f":"SUM(D126+'Q3'!E126)","v":0}]
["5 To 11",null,null,{"$f":"SUM(B127:C127)","v":0},{"$f":"SUM(D127+'Q3'!E127)","v":0}]
["12 To 14",null,null,0,{"$f":"SUM(D128+'Q3'!E128)","v":0}]
["15 To 17",null,null,0,{"$f":"SUM(D129+'Q3'!E129)","v":0}]
["18 To 24",null,null,0,{"$f":"SUM(D130+'Q3'!E130)","v":0}]
["25 To 39",null,null,0,{"$f":"SUM(D131+'Q3'!E131)","v":0}]
["40 To 54",null,null,0,{"$f":"SUM(D132+'Q3'!E132)","v":0}]
["55 To 64",null,null,0,{"$f":"SUM(D133+'Q3'!E133)","v":0}]
["65 To 74",null,null,0,{"$f":"SUM(D134+'Q3'!E134)","v":0}]
["75 And Older",null,null,0,{"$f":"SUM(D135+'Q3'!E135)","v":0}]
["Age - Balance Not Specified",null,null,0,{"$f":"SUM(D136+'Q3'!E136)","v":0}]
["Total Age",{"$f":"SUM(B126:B136)","v":0},{"$f":"SUM(C126:C136)","v":0},0,0,{"$f":"IF(E137=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Gender","This Quarter Actuals","Revisions","Revised Numbers"]
["Female",null,null,{"$f":"SUM(B139:C139)","v":0},{"$f":"SUM(D139+'Q3'!E139)","v":0}]
["Male",null,null,{"$f":"SUM(B140:C140)","v":0},{"$f":"SUM(D140+'Q3'!E140)","v":0}]
["Transgender Female",null,null,0,{"$f":"SUM(D141+'Q3'!E141)","v":0}]
["Transgender Male",null,null,0,{"$f":"SUM(D142+'Q3'!E142)","v":0}]
["Gender - Balance Not Specified",null,null,0,{"$f":"SUM(D143+'Q3'!E143)","v":0}]
["Total Gender:",{"$f":"SUM(B139:B143)","v":0},{"$f":"SUM(C139:C143)","v":0},0,0,{"$f":"IF(E144=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Ethnicity","This Quarter Actuals","Revisions","Revised Numbers"]
["Hispanic or Latino",null,null,{"$f":"SUM(B146:C146)","v":0},{"$f":"SUM(D146+'Q3'!E146)","v":0}]
["Not Hispanic or Latino",null,null,{"$f":"SUM(B147:C147)","v":0},{"$f":"SUM(D147+'Q3'!E147)","v":0}]
["Ethnicity - Balance Not Specified",null,null,0,{"$f":"SUM(D148+'Q3'!E148)","v":0}]
["Total Ethnicity:",{"$f":"SUM(B146:B148)","v":0},{"$f":"SUM(C146:C148)","v":0},0,0,{"$f":"IF(E149=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Race:","This Quarter Actuals","Revisions","Revised Numbers"]
["American Indian or Alaskan Native",null,null,{"$f":"SUM(B151:C151)","v":0},{"$f":"SUM(D151+'Q3'!E151)","v":0}]
["Asian",null,null,{"$f":"SUM(B152:C152)","v":0},{"$f":"SUM(D152+'Q3'!E152)","v":0}]
["Black or African American",null,null,0,{"$f":"SUM(D153+'Q3'!E153)","v":0}]
["Native Hawaiian or Other Pacific Islander",null,null,0,{"$f":"SUM(D154+'Q3'!E154)","v":0}]
["White",null,null,0,{"$f":"SUM(D155+'Q3'!E155)","v":0}]
["Some Other Race",null,null,0,{"$f":"SUM(D156+'Q3'!E156)","v":0}]
["Two or More Races",null,null,0,{"$f":"SUM(D157+'Q3'!E157)","v":0}]
["Race - Balance Not Specified",null,null,0,{"$f":"SUM(D158+'Q3'!E158)","v":0}]
["Total Race:",{"$f":"SUM(B151:B158)","v":0},{"$f":"SUM(C151:C158)","v":0},0,0,{"$f":"IF(E159=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Income:","This Quarter Actuals","Revisions","Revised Numbers"]
["Less than 50% FPIL",null,null,{"$f":"SUM(B161:C161)","v":0},{"$f":"SUM(D161+'Q3'!E161)","v":0}]
["50% to 100% FPIL",null,null,{"$f":"SUM(B162:C162)","v":0},{"$f":"SUM(D162+'Q3'!E162)","v":0}]
["101% to 150% FPIL",null,null,0,{"$f":"SUM(D163+'Q3'!E163)","v":0}]
["151% to 200% FPIL",null,null,0,{"$f":"SUM(D164+'Q3'!E164)","v":0}]
["More than 200% FPIL",null,null,0,{"$f":"SUM(D165+'Q3'!E165)","v":0}]
["Income - Balance Not Specified",null,null,0,{"$f":"SUM(D166+'Q3'!E166)","v":0}]
["Total Income:",{"$f":"SUM(B161:B166)","v":0},{"$f":"SUM(C161:C166)","v":0},0,0,{"$f":"IF(E167=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]
["Zip-Codes:","This Quarter Actuals","Revisions","Revised Numbers"]
[78610,null,null,{"$f":"SUM(B169:C169)","v":0},{"$f":"SUM(D169+'Q3'!E169)","v":0}]
[78617,null,null,{"$f":"SUM(B170:C170)","v":0},{"$f":"SUM(D170+'Q3'!E170)","v":0}]
[78620,null,null,0,{"$f":"SUM(D171+'Q3'!E171)","v":0}]
[78621,null,null,0,{"$f":"SUM(D172+'Q3'!E172)","v":0}]
[78641,null,null,0,{"$f":"SUM(D173+'Q3'!E173)","v":0}]
[78645,null,null,0,{"$f":"SUM(D174+'Q3'!E174)","v":0}]
[78652,null,null,0,{"$f":"SUM(D175+'Q3'!E175)","v":0}]
[78653,null,null,0,{"$f":"SUM(D176+'Q3'!E176)","v":0}]
[78654,null,null,0,{"$f":"SUM(D177+'Q3'!E177)","v":0}]
[78660,null,null,0,{"$f":"SUM(D178+'Q3'!E178)","v":0}]
[78664,null,null,0,{"$f":"SUM(D179+'Q3'!E179)","v":0}]
[78669,null,null,0,{"$f":"SUM(D180+'Q3'!E180)","v":0}]
[78701,null,null,0,{"$f":"SUM(D181+'Q3'!E181)","v":0}]
[78702,null,null,0,{"$f":"SUM(D182+'Q3'!E182)","v":0}]
[78703,null,null,0,{"$f":"SUM(D183+'Q3'!E183)","v":0}]
[78704,null,null,0,{"$f":"SUM(D184+'Q3'!E184)","v":0}]
[78705,null,null,0,{"$f":"SUM(D185+'Q3'!E185)","v":0}]
[78712,null,null,0,{"$f":"SUM(D186+'Q3'!E186)","v":0}]
[78717,null,null,0,{"$f":"SUM(D187+'Q3'!E187)","v":0}]
[78719,null,null,0,{"$f":"SUM(D188+'Q3'!E188)","v":0}]
[78721,null,null,0,{"$f":"SUM(D189+'Q3'!E189)","v":0}]
[78722,null,null,0,{"$f":"SUM(D190+'Q3'!E190)","v":0}]
[78723,null,null,0,{"$f":"SUM(D191+'Q3'!E191)","v":0}]
[78724,null,null,0,{"$f":"SUM(D192+'Q3'!E192)","v":0}]
[78725,null,null,0,{"$f":"SUM(D193+'Q3'!E193)","v":0}]
[78726,null,null,0,{"$f":"SUM(D194+'Q3'!E194)","v":0}]
[78727,null,null,0,{"$f":"SUM(D195+'Q3'!E195)","v":0}]
[78728,null,null,0,{"$f":"SUM(D196+'Q3'!E196)","v":0}]
[78729,null,null,0,{"$f":"SUM(D197+'Q3'!E197)","v":0}]
[78730,null,null,0,{"$f":"SUM(D198+'Q3'!E198)","v":0}]
[78731,null,null,0,{"$f":"SUM(D199+'Q3'!E199)","v":0}]
[78732,null,null,0,{"$f":"SUM(D200+'Q3'!E200)","v":0}]
[78733,null,null,0,{"$f":"SUM(D201+'Q3'!E201)","v":0}]
[78734,null,null,0,{"$f":"SUM(D202+'Q3'!E202)","v":0}]
[78735,null,null,0,{"$f":"SUM(D203+'Q3'!E203)","v":0}]
[78736,null,null,0,{"$f":"SUM(D204+'Q3'!E204)","v":0}]
[78737,null,null,0,{"$f":"SUM(D205+'Q3'!E205)","v":0}]
[78738,null,null,0,{"$f":"SUM(D206+'Q3'!E206)","v":0}]
[78739,null,null,0,{"$f":"SUM(D207+'Q3'!E207)","v":0}]
[78740,null,null,0,{"$f":"SUM(D208+'Q3'!E208)","v":0}]
[78741,null,null,0,{"$f":"SUM(D209+'Q3'!E209)","v":0}]
[78742,null,null,0,{"$f":"SUM(D210+'Q3'!E210)","v":0}]
[78744,null,null,0,{"$f":"SUM(D211+'Q3'!E211)","v":0}]
[78745,null,null,0,{"$f":"SUM(D212+'Q3'!E212)","v":0}]
[78746,null,null,0,{"$f":"SUM(D213+'Q3'!E213)","v":0}]
[78747,null,null,0,{"$f":"SUM(D214+'Q3'!E214)","v":0}]
[78748,null,null,0,{"$f":"SUM(D215+'Q3'!E215)","v":0}]
[78749,null,null,0,{"$f":"SUM(D216+'Q3'!E216)","v":0}]
[78750,null,null,0,{"$f":"SUM(D217+'Q3'!E217)","v":0}]
[78751,null,null,0,{"$f":"SUM(D218+'Q3'!E218)","v":0}]
[78752,null,null,0,{"$f":"SUM(D219+'Q3'!E219)","v":0}]
[78753,null,null,0,{"$f":"SUM(D220+'Q3'!E220)","v":0}]
[78754,null,null,0,{"$f":"SUM(D221+'Q3'!E221)","v":0}]
[78756,null,null,0,{"$f":"SUM(D222+'Q3'!E222)","v":0}]
[78757,null,null,0,{"$f":"SUM(D223+'Q3'!E223)","v":0}]
[78758,null,null,0,{"$f":"SUM(D224+'Q3'!E224)","v":0}]
[78759,null,null,0,{"$f":"SUM(D225+'Q3'!E225)","v":0}]
["Homeless",null,null,0,{"$f":"SUM(D226+'Q3'!E226)","v":0}]
["Out of County Zip Count",null,null,0,{"$f":"SUM(D227+'Q3'!E227)","v":0}]
["Unknown Zip Count",null,null,0,{"$f":"SUM(D228+'Q3'!E228)","v":0}]
["Total Zip Code",{"$f":"SUM(B169:B228)","v":0},{"$f":"SUM(C169:C228)","v":0},0,0,{"$f":"IF(E229=$B$12,\"Matches YTD\",\"Total does not match unduplicated client count\")","v":"Matches YTD"}]

{"sheet":"Summary","index":5,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[0,2,0,7]]}
["City of Austin Performance Percentage:",{"$f":"IF(PMDT!B12=0,\"\",SUM(PMDT!B10/PMDT!B12))","v":""},"This form will automatically update with information from Q1 through Q4"]
[{"$f":"PMDT!B2","v":0},"Quaterly Goal","Q1","Q2","Q3","Q4","YTD","Yearly Goal"]
["Unduplicated Clients Served:",{"$f":"SUM(H3/4)","v":0},{"$f":"'Q1'!B12","v":0},{"$f":"SUM('Q2'!B10:B11)","v":0},{"$f":"SUM('Q3'!B10:B11)","v":0},{"$f":"SUM('Q4'!B10:B11)","v":0},{"$f":"SUM(C3:F3)","v":0},{"$f":"PMDT!B12","v":0}]
["Supplemental Outputs:"]
[{"$f":"PMDT!A15","v":"Supplemental Output 1:"},{"$f":"SUM(H5/4)","v":0},{"$f":"'Q1'!B19","v":0},{"$f":"SUM('Q2'!B17:B18)","v":0},{"$f":"SUM('Q3'!B17:B18)","v":4},{"$f":"SUM('Q4'!B17:B18)","v":0},{"$f":"SUM(C5:F5)","v":4},{"$f":"PMDT!B18","v":0}]
[{"$f":"PMDT!A20","v":"Supplemental Output 2:"},{"$f":"SUM(H6/4)","v":0},{"$f":"'Q1'!B25","v":0},{"$f":"SUM('Q2'!B23:B24)","v":0},{"$f":"SUM('Q3'!B23:B24)","v":0},{"$f":"SUM('Q4'!B23:B24)","v":0},{"$f":"SUM(C6:F6)","v":0},{"$f":"PMDT!B23","v":0}]
[{"$f":"PMDT!A25","v":"Supplemental Output 3:"},{"$f":"SUM(H7/4)","v":0},{"$f":"'Q1'!B31","v":0},{"$f":"SUM('Q2'!B29:B30)","v":0},{"$f":"SUM('Q3'!B29:B30)","v":0},{"$f":"SUM('Q4'!B29:B30)","v":0},{"$f":"SUM(C7:F7)","v":0},{"$f":"PMDT!B28","v":0}]
[{"$f":"PMDT!A30","v":"Supplemental Output 4:"},{"$f":"SUM(H8/4)","v":0},{"$f":"'Q1'!B37","v":0},{"$f":"SUM('Q2'!B35:B36)","v":0},{"$f":"SUM('Q3'!B35:B36)","v":0},{"$f":"SUM('Q4'!B35:B36)","v":0},{"$f":"SUM(C8:F8)","v":0},{"$f":"PMDT!B33","v":0}]
["Productivity Outputs:"]
[{"$f":"PMDT!A36","v":"Productivity Goal Description:"},"Not Used",null,null,null,{"$f":"'Q4'!B42","v":0},{"$f":"'Q4'!B42","v":0},{"$f":"PMDT!B37","v":0}]
[{"$f":"PMDT!A39","v":"Productivity Goal Description:"},"Not Used",null,null,null,{"$f":"'Q4'!B46","v":0},{"$f":"'Q4'!B46","v":0},{"$f":"PMDT!B40","v":0}]
["City Performance Measures:"]
[{"$f":"PMDT!A44","v":"Please Select"},{"$f":"SUM(H13/4)","v":0},{"$f":"'Q1'!B55","v":0},{"$f":"SUM('Q2'!B51,'Q2'!B53)","v":0},{"$f":"SUM('Q3'!B51,'Q3'!B53)","v":0},{"$f":"SUM('Q4'!B51,'Q4'!B53)","v":0},{"$f":"SUM(C13:F13)","v":0},{"$f":"PMDT!C44","v":0}]
[{"$f":"PMDT!A45","v":"Please Select"},{"$f":"SUM(H14/4)","v":0},{"$f":"'Q1'!B56","v":0},{"$f":"SUM('Q2'!B52,'Q2'!B54)","v":0},{"$f":"SUM('Q3'!B52,'Q3'!B54)","v":0},{"$f":"SUM('Q4'!B52,'Q4'!B54)","v":0},{"$f":"SUM(C14:F14)","v":0},{"$f":"PMDT!C45","v":0}]
[{"$f":"PMDT!A46","v":"Please Select"},{"$f":"IF(B14=0,\"\",SUM(B13/B14))","v":""},{"$f":"IF(C14=0,\"\",SUM(C13/C14))","v":""},"","","","",""]
[{"$f":"PMDT!A47","v":"Please Select"},{"$f":"SUM(H16/4)","v":0},{"$f":"'Q1'!B64","v":0},{"$f":"SUM('Q2'!B60,'Q2'!B62)","v":0},{"$f":"SUM('Q3'!B60,'Q3'!B62)","v":0},{"$f":"SUM('Q4'!B60,'Q4'!B62)","v":0},{"$f":"SUM(C16:F16)","v":0},{"$f":"PMDT!C47","v":0}]
[{"$f":"PMDT!A48","v":"Please Select"},{"$f":"SUM(H17/4)","v":0},{"$f":"'Q1'!B65","v":0},{"$f":"SUM('Q2'!B61,'Q2'!B63)","v":0},{"$f":"SUM('Q3'!B61,'Q3'!B63)","v":0},{"$f":"SUM('Q4'!B61,'Q4'!B63)","v":0},{"$f":"SUM(C17:F17)","v":0},{"$f":"PMDT!C48","v":0}]
[{"$f":"PMDT!A49","v":"Please Select"},{"$f":"IF(B17=0,\"\",SUM(B16/B17))","v":""},{"$f":"IF(C17=0,\"\",SUM(C16/C17))","v":""},{"$f":"IF(D17=0,\"\",SUM(D16/D17))","v":""},{"$f":"IF(E17=0,\"\",SUM(E16/E17))","v":""},{"$f":"IF(F17=0,\"\",SUM(F16/F17))","v":""},{"$f":"IF(G17=0,\"\",SUM(G16/G17))","v":""},{"$f":"IF(H17=0,\"\",SUM(H16/H17))","v":""}]
[{"$f":"PMDT!A50","v":"Please Select"},{"$f":"SUM(H19/4)","v":0},{"$f":"'Q1'!B73","v":0},{"$f":"SUM('Q2'!B69,'Q2'!B71)","v":0},{"$f":"SUM('Q3'!B69,'Q3'!B71)","v":0},{"$f":"SUM('Q4'!B69,'Q4'!B71)","v":0},{"$f":"SUM(C19:F19)","v":0},{"$f":"PMDT!C50","v":0}]
[{"$f":"PMDT!A51","v":"Please Select"},{"$f":"SUM(H20/4)","v":0},{"$f":"'Q1'!B74","v":0},{"$f":"SUM('Q2'!B70,'Q2'!B72)","v":0},{"$f":"SUM('Q3'!B70,'Q3'!B72)","v":0},{"$f":"SUM('Q4'!B70,'Q4'!B72)","v":0},{"$f":"SUM(C20:F20)","v":0},{"$f":"PMDT!C51","v":0}]
[{"$f":"PMDT!A52","v":"Please Select"},{"$f":"IF(B20=0,\"\",SUM(B19/B20))","v":""},{"$f":"IF(C20=0,\"\",SUM(C19/C20))","v":""},{"$f":"IF(D20=0,\"\",SUM(D19/D20))","v":""},{"$f":"IF(E20=0,\"\",SUM(E19/E20))","v":""},{"$f":"IF(F20=0,\"\",SUM(F19/F20))","v":""},{"$f":"IF(G20=0,\"\",SUM(G19/G20))","v":""},{"$f":"IF(H20=0,\"\",SUM(H19/H20))","v":""}]
[{"$f":"PMDT!A53","v":"Please Select"},{"$f":"SUM(H22/4)","v":0},{"$f":"'Q1'!B82","v":0},{"$f":"SUM('Q2'!B78,'Q2'!B80)","v":0},{"$f":"SUM('Q3'!B78,'Q3'!B80)","v":0},{"$f":"SUM('Q4'!B78,'Q4'!B80)","v":0},{"$f":"SUM(C22:F22)","v":0},{"$f":"PMDT!C53","v":0}]
[{"$f":"PMDT!A54","v":"Please Select"},{"$f":"SUM(H23/4)","v":0},{"$f":"'Q1'!B83","v":0},{"$f":"SUM('Q2'!B79,'Q2'!B81)","v":0},{"$f":"SUM('Q3'!B79,'Q3'!B81)","v":0},{"$f":"SUM('Q4'!B79,'Q4'!B81)","v":0},{"$f":"SUM(C23:F23)","v":0},{"$f":"PMDT!C54","v":0}]
[{"$f":"PMDT!A55","v":"Please Select"},{"$f":"IF(B23=0,\"\",SUM(B22/B23))","v":""},{"$f":"IF(C23=0,\"\",SUM(C22/C23))","v":""},{"$f":"IF(D23=0,\"\",SUM(D22/D23))","v":""},{"$f":"IF(E23=0,\"\",SUM(E22/E23))","v":""},{"$f":"IF(F23=0,\"\",SUM(F22/F23))","v":""},{"$f":"IF(G23=0,\"\",SUM(G22/G23))","v":""},{"$f":"IF(H23=0,\"\",SUM(H22/H23))","v":""}]
["Supplemental Outcomes:"]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(H26/4)","v":{"$error":"#REF!"}},{"$f":"'Q1'!B92","v":0},{"$f":"SUM('Q2'!B88,'Q2'!B90)","v":0},{"$f":"SUM('Q3'!B88,'Q3'!B90)","v":0},{"$f":"SUM('Q4'!B88,'Q4'!B90)","v":0},{"$f":"SUM(C26:F26)","v":0},{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(H27/4)","v":{"$error":"#REF!"}},{"$f":"'Q1'!B93","v":0},{"$f":"SUM('Q2'!B89,'Q2'!B91)","v":0},{"$f":"SUM('Q3'!B89,'Q3'!B91)","v":0},{"$f":"SUM('Q4'!B89,'Q4'!B91)","v":0},{"$f":"SUM(C27:F27)","v":0},{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B27=0,\"\",SUM(B26/B27))","v":{"$error":"#REF!"}},{"$f":"IF(C27=0,\"\",SUM(C26/C27))","v":""},{"$f":"IF(D27=0,\"\",SUM(D26/D27))","v":""},{"$f":"IF(E27=0,\"\",SUM(E26/E27))","v":""},{"$f":"IF(F27=0,\"\",SUM(F26/F27))","v":""},{"$f":"IF(G27=0,\"\",SUM(G26/G27))","v":""},{"$f":"IF(H27=0,\"\",SUM(H26/H27))","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(H29/4)","v":{"$error":"#REF!"}},{"$f":"'Q1'!B101","v":0},{"$f":"SUM('Q2'!B97,'Q2'!B99)","v":0},{"$f":"SUM('Q3'!B97,'Q3'!B99)","v":0},{"$f":"SUM('Q4'!B97,'Q4'!B99)","v":0},{"$f":"SUM(C29:F29)","v":0},{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(H30/4)","v":{"$error":"#REF!"}},{"$f":"'Q1'!B102","v":0},{"$f":"SUM('Q2'!B98,'Q2'!B100)","v":0},{"$f":"SUM('Q3'!B98,'Q3'!B100)","v":0},{"$f":"SUM('Q4'!B98,'Q4'!B100)","v":0},{"$f":"SUM(C30:F30)","v":0},{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B30=0,\"\",SUM(B29/B30))","v":{"$error":"#REF!"}},{"$f":"IF(C30=0,\"\",SUM(C29/C30))","v":""},{"$f":"IF(D30=0,\"\",SUM(D29/D30))","v":""},{"$f":"IF(E30=0,\"\",SUM(E29/E30))","v":""},{"$f":"IF(F30=0,\"\",SUM(F29/F30))","v":""},{"$f":"IF(G30=0,\"\",SUM(G29/G30))","v":""},{"$f":"IF(H30=0,\"\",SUM(H29/H30))","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(H32/4)","v":{"$error":"#REF!"}},{"$f":"'Q1'!B110","v":0},{"$f":"SUM('Q2'!B106,'Q2'!B108)","v":0},{"$f":"SUM('Q3'!B106,'Q3'!B108)","v":0},{"$f":"SUM('Q4'!B106,'Q4'!B108)","v":0},{"$f":"SUM(C32:F32)","v":0},{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(H33/4)","v":{"$error":"#REF!"}},{"$f":"'Q1'!B111","v":0},{"$f":"SUM('Q2'!B107,'Q2'!B109)","v":0},{"$f":"SUM('Q3'!B107,'Q3'!B109)","v":0},{"$f":"SUM('Q4'!B107,'Q4'!B109)","v":0},{"$f":"SUM(C33:F33)","v":0},{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B33=0,\"\",SUM(B32/B33))","v":{"$error":"#REF!"}},{"$f":"IF(C33=0,\"\",SUM(C32/C33))","v":""},{"$f":"IF(D33=0,\"\",SUM(D32/D33))","v":""},{"$f":"IF(E33=0,\"\",SUM(E32/E33))","v":""},{"$f":"IF(F33=0,\"\",SUM(F32/F33))","v":""},{"$f":"IF(G33=0,\"\",SUM(G32/G33))","v":""},{"$f":"IF(H33=0,\"\",SUM(H32/H33))","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(H35/4)","v":{"$error":"#REF!"}},{"$f":"'Q1'!B119","v":0},{"$f":"SUM('Q2'!B115,'Q2'!B117)","v":0},{"$f":"SUM('Q3'!B115,'Q3'!B117)","v":0},{"$f":"SUM('Q4'!B115,'Q4'!B117)","v":0},{"$f":"SUM(C35:F35)","v":0},{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(H36/4)","v":{"$error":"#REF!"}},{"$f":"'Q1'!B120","v":0},{"$f":"SUM('Q2'!B116,'Q2'!B118)","v":0},{"$f":"SUM('Q3'!B116,'Q3'!B118)","v":0},{"$f":"SUM('Q4'!B116,'Q4'!B118)","v":0},{"$f":"SUM(C36:F36)","v":0},{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}}]
[{"$f":"PMDT!#REF!","v":{"$error":"#REF!"}},{"$f":"IF(B36=0,\"\",SUM(B35/B36))","v":{"$error":"#REF!"}},{"$f":"IF(C36=0,\"\",SUM(C35/C36))","v":""},{"$f":"IF(D36=0,\"\",SUM(D35/D36))","v":""},{"$f":"IF(E36=0,\"\",SUM(E35/E36))","v":""},{"$f":"IF(F36=0,\"\",SUM(F35/F36))","v":""},{"$f":"IF(G36=0,\"\",SUM(G35/G36))","v":""},{"$f":"IF(H36=0,\"\",SUM(H35/H36))","v":{"$error":"#REF!"}}]