{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["A. Request for Funds","B. Funds Reconciliation","C. TA Self Help","D. TA Shared Housing"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"A. Request for Funds","index":0,"n_rows":74,"n_cols":25,"rows_kept":74,"cut":false,"hidden":false,"merged":[[46,0,46,1],[46,2,46,4],[39,5,39,6],[49,5,49,6],[45,5,45,6],[44,5,44,6],[43,5,43,6],[42,5,42,6],[41,5,41,6],[48,2,48,4],[48,5,48,6],[47,5,47,6],[46,5,46,6],[31,0,31,15],[32,0,32,15],[44,10,44,15],[45,10,45,15],[46,10,46,15],[47,10,47,15],[43,8,43,9],[42,8,42,9],[41,8,41,9],[40,8,40,9],[39,10,39,15],[40,10,40,15],[41,10,41,15],[42,10,42,15],[43,10,43,15],[44,8,44,9],[44,0,44,1],[44,2,44,4],[40,2,40,4],[40,0,40,1],[41,0,41,1],[41,2,41,4],[42,0,42,1],[42,2,42,4],[38,0,38,15],[37,0,37,14],[39,2,39,4],[39,0,39,1],[40,5,40,6],[64,0,64,8],[64,9,64,15],[65,0,65,8],[65,9,65,15],[48,10,48,15],[49,10,49,15],[39,8,39,9],[49,8,49,9],[48,8,48,9],[47,8,47,9],[46,8,46,9],[45,8,45,9],[49,0,49,1],[49,2,49,4],[47,0,47,1],[47,2,47,4],[48,0,48,1],[45,0,45,1],[45,2,45,4],[66,0,66,15],[67,0,67,5],[67,6,67,12],[67,13,67,15],[60,0,60,15],[61,0,61,15],[62,0,62,8],[70,0,70,5],[70,6,70,12],[70,13,70,15],[68,0,68,5],[68,6,68,12],[68,13,68,15],[69,0,69,5],[69,6,69,12],[69,13,69,15],[36,0,36,14],[35,0,35,15],[33,0,33,15],[62,9,62,15],[63,0,63,8],[63,9,63,15],[58,0,59,15],[50,0,50,15],[53,14,53,15],[54,14,54,15],[56,0,56,15],[57,0,57,15],[53,0,53,10],[54,0,54,10],[55,0,55,10],[53,11,53,13],[54,11,54,13],[55,11,55,13],[55,14,55,15],[52,14,52,15],[51,0,51,15],[52,11,52,13],[43,0,43,1],[43,2,43,4],[8,0,8,15],[30,0,30,5],[30,12,30,13],[30,10,30,11],[30,8,30,9],[30,6,30,7],[28,6,28,7],[28,8,28,9],[28,10,28,11],[28,12,28,13],[29,0,29,5],[29,6,29,7],[29,8,29,9],[29,10,29,11],[29,12,29,13],[26,8,26,9],[26,10,26,11],[26,12,26,13],[27,6,27,7],[27,8,27,9],[28,0,28,5],[27,0,27,5],[26,0,26,5],[25,0,25,5],[24,0,24,5],[26,6,26,7],[27,10,27,11],[27,12,27,13],[24,12,24,13],[24,10,24,11],[24,8,24,9],[24,6,24,7],[25,6,25,7],[25,8,25,9],[25,10,25,11],[25,12,25,13],[21,0,21,15],[20,0,20,2],[20,3,20,7],[20,8,20,10],[20,11,20,15],[23,0,23,5],[23,12,23,13],[18,0,18,2],[18,3,18,7],[18,8,18,10],[18,11,18,15],[23,10,23,11],[23,8,23,9],[23,6,23,7],[22,0,22,15],[13,0,13,15],[14,0,14,2],[14,3,14,7],[14,8,14,10],[14,11,14,15],[11,0,11,2],[11,3,11,7],[11,8,11,10],[11,11,11,15],[12,0,12,2],[12,8,12,10],[34,0,34,15],[73,6,73,8],[72,6,72,8],[71,0,71,15],[72,9,72,12],[73,9,73,12],[72,0,73,5],[52,0,52,10],[4,0,4,4],[6,0,6,15],[10,0,10,15],[9,0,9,15],[19,0,19,15],[15,0,15,2],[15,3,15,7],[15,8,15,10],[15,11,15,15],[16,0,16,15],[17,0,17,2],[17,3,17,7],[17,8,17,10],[17,11,17,15],[12,3,12,7],[12,11,12,15]]}
["DEPARTMENT OF HOUSING AND COMMUNITY DEVELOPMENT"]
["DIVISION OF STATE FINANCIAL ASSISTANCE"]
["STATE GRANT MANAGEMENT "]
["2020 West El Camino, 4th Floor "]
["Sacramento, CA  95833"]
["calhomereports@hcd.ca.gov",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Will be Hidden"]
["CalHome Request for Funds",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
["Last Revised 05/17/2022",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Owner-Occupied Rehab"]
["Instructions: Complete sections 1-4 and and any applicable worksheets (tabs B-D) . Once completed, use section 5 to certify the information is true and correct.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"First Time Homebuyer Mortgage Assistance"]
["Section 1: Contact Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ADU/JADU Assistance"]
["General Information:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Homeowner Project Development Loan"]
["HCD Contract #:",null,null,null,null,null,null,null,"Total CalHome Award Amount:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Technical Assistance for Self Help Housing Projects"]
["Draw Request Date:",null,null,null,null,null,null,null,"HCD Representative Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Technical Assistance for Shared Housing Programs"]
["Contractor Information:"]
["Contractor Contact:",null,null,null,null,null,null,null,"Contact Title:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
["Phone Number:",null,null,null,null,null,null,null,"Email Address:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Make Warrant Payable to:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["Contractor Name:",null,null,null,null,null,null,null,"City Name:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N/A"]
["Street Address:",null,null,null,null,null,null,null,"State and Zip Code:"]
["Section 2: Budget and Financial "]
["Draw Request #:",null,null,"Select One",null,null,null,null,"Request Type:",null,null,"Select One"]
["Instructions: Complete the table below, making sure to enter cumulative previously drawn amount in the \"Previously Drawn Amount\" column. The \"HCD Approved Amount This Draw\" column is used only by HCD staff. If requesting funds for Owner-Occupied Rehab, First Time Homebuyer Mortgage Assistance, ADU/JADU Assistance or Homeowner Project Development Loan, you must complete tab \"B. Funds Reconciliation.\" If requesting funds for Technical Assistance for Self Help Housing Projects and/or Technical Assistance for Shared Housing Programs, you must complete Tab \"C. TA Self Help\" and/or \"D. TA Shared Housing.\" "]
["Note For Advanced Funds: A list of Borrowers and closing dates must accompany this request.  If Advanced funds are not fully expended within 90 days, the remaining funds must be returned to the State and credited back to the contract balance."]
["Approved Activities",null,null,null,null,null,"Grant/Loan Award Amount",null,"Previously Drawn Amount",null,"Amount Requested this Draw",null,"Total Requested to Date",null,"Balance of Grant/Loan Remaining","HCD Approved Amount This Draw\n(HCD ONLY)"]
["Owner-Occupied Rehab",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((I25+K25),0)","v":0},null,{"$f":"ROUND((G25-M25),0)","v":0}]
["First Time Homebuyer Mortgage Assistance",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND((I26+K26),0)","v":0},null,0]
["ADU/JADU Assistance",null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Homeowner Project Development Loan",null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Technical Assistance for Self Help Housing Projects",null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Technical Assistance for Shared Housing Programs",null,null,null,null,null,null,null,null,null,null,null,0,null,0]
["Totals:",null,null,null,null,null,{"$f":"SUM(G25:H30)","v":0},null,{"$f":"SUM(I25:J30)","v":0},null,{"$f":"SUM(K25:L30)","v":0},null,{"$f":"SUM(M25:N30)","v":0},null,{"$f":"SUM(O25:O30)","v":0},{"$f":"SUM(P25:P30)","v":0}]
[{"$f":"IF(K29>0, \"IF YOU ARE REQUESTING FUNDS FOR TECHNICAL ASSISTANCE FOR SELF HELP HOUSING PROJECTS, YOU MUST COMPLETE TAB C OF THE WORKBOOK\", \"\")","v":""}]
[{"$f":"IF(K30>0, \"IF YOU ARE REQUESTING FUNDS FOR TECHNICAL ASSISTANCE FOR SHARED HOUSING PROGRAMS, YOU MUST COMPLETE TAB D OF THE WORKBOOK\",\"\")","v":""}]
["Section 3: Unit Activity "]
["Instructions: Complete the section below. If any Borrower Names, Closing Dates, Activity Delivery Fees, Home Buyer Educaiton Fees or Loan Amounts have been modified since last reported, please use the section below to provide information on those modifications. If modifications have been made, you will select how many loans have been affected and additional form fields will populate. "]
["Unit Activity"]
["Have previously reported Borrower Names, Closing Dates, Activity Delivery Fees, Home Buyer Education Fees or Loan Amounts been modified since last reported? (Select N/A if this is the first RFF)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
["If you Selected \"Yes\" above, how many loans have been modified? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
["Using the table below, please provide the updated information that has changed since time of last reporting."]
["First Name",null,"Last Name",null,null,"Activity Delivery Fee ",null,"Home Buyer Education Fee ","CalHome Loan Amount",null,"What changed?"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Section 4: Report Compliance"]
["Instructions: All reports due must be on file before requests for funds will be approved. Please confirm that the required reports have been received by HCD."]
[null,null,null,null,null,null,null,null,null,null,null,"Confirm Report Submission",null,null,"HCD USE ONLY\nConfirm Report Submission"]
["1. Have all required Quarterly Reports been submitted and approved by HCD staff?..............................................................",null,null,null,null,null,null,null,null,null,null,"Select One",null,null,"Select One"]
["2. Have all required Annual Status Reports been submitted and approved by HCD staff?......................................................",null,null,null,null,null,null,null,null,null,null,"Select One",null,null,"Select One"]
["3. If Applicable: Have all required Annual Reuse Reports been submitted and approved by HCD staff?.................................",null,null,null,null,null,null,null,null,null,null,"Select One",null,null,"Select One"]
["Additional Notes or Comments"]
[]
["Note: Complete applicable worksheets (tabs B-D) before completing the Certification section below. "]
[]
["Section 5: Certification"]
["***By signing this request, I certify to the best of my knowledge and belief that the request is true, complete, and accurate, and the expenditures, disbursements and cash receipts will be for the purposes and objectives set forth in the terms and conditions of the State award. I am aware that any false, fictitious, or fraudulent information, or the omission of any material fact, may subject me to criminal, civil or administrative penalties for fraud, false statements, false claims or otherwise. (U.S. Code Title 18, Section 1001 and Title 31, Sections 3729-3730 and 3801-3812)"]
["Name of Authorized Representative",null,null,null,null,null,null,null,null,"Title of Authorized Representative"]
[]
["Signature of Authorized Representative",null,null,null,null,null,null,null,null,"Date"]
[]
["HCD USE ONLY"]
["SGM Representative Printed Name",null,null,null,null,null,"Representative Signature",null,null,null,null,null,null,"Date"]
[]
["SGM Manager Printed Name",null,null,null,null,null,"Manager Signature ",null,null,null,null,null,null,"Date"]
[]
["FOR FMO PURPOSES ONLY"]
[null,null,null,null,null,null,"Total Advance:",null,null,{"$f":"'B. Funds Reconciliation'!G29+'C. TA Self Help'!E28+'D. TA Shared Housing'!E29","v":0}]
[null,null,null,null,null,null,"Total Reimbursement:",null,null,{"$f":"'B. Funds Reconciliation'!G31+'C. TA Self Help'!E30+'D. TA Shared Housing'!E31","v":0}]

{"sheet":"B. Funds Reconciliation","index":1,"n_rows":36,"n_cols":35,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,23,2,29],[3,23,3,29],[0,17,2,22],[4,28,5,28],[4,29,5,29],[4,23,5,23],[4,27,5,27],[4,25,5,25],[4,26,5,26],[4,24,5,24],[4,18,5,18],[30,11,30,12],[27,13,27,14],[27,15,27,16],[25,20,25,22],[26,8,26,9],[28,8,29,8],[28,9,29,9],[27,11,27,12],[28,15,28,16],[28,10,29,10],[28,11,29,12],[26,10,26,12],[26,14,26,16],[26,5,26,7],[27,6,27,7],[28,6,28,7],[29,6,29,7],[30,6,30,7],[32,17,33,17],[28,13,28,14],[29,13,29,14],[30,13,30,14],[31,13,33,14],[30,15,30,16],[29,15,29,16],[31,15,33,16],[13,20,13,22],[12,20,12,22],[16,20,16,22],[32,19,33,19],[32,18,33,18],[0,0,0,4],[3,0,3,7],[4,2,5,2],[11,20,11,22],[4,1,5,1],[10,20,10,22],[9,20,9,22],[8,20,8,22],[7,20,7,22],[6,20,6,22],[3,17,3,22],[1,0,1,16],[2,0,2,16],[3,9,3,16],[4,20,5,22],[4,13,5,13],[4,0,5,0],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,9,5,9],[4,8,5,8],[4,10,5,10],[4,12,5,12],[4,11,5,11],[4,14,5,14],[4,15,5,15],[32,21,33,21],[32,20,33,20],[19,20,19,22],[18,20,18,22],[17,20,17,22],[28,22,33,22],[24,20,24,22],[23,20,23,22],[22,20,22,22],[21,20,21,22],[20,20,20,22],[4,16,5,16],[15,20,15,22],[14,20,14,22]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HCD Use Only"]
["CalHome Request For Funds Reconciliation                                                                                                                                      "]
["Instructions: If requesting funds for Owner-Occupied Rehab, First Time Homebuyer Mortgage Assistance, ADU/JADU Assistance or Homeowner Project Development Loan,  please complete the following Financial Summary fields. \nUse the drop-down below to select the number of unique costs this RFF and complete all yellow fields (as applicable). "]
["Select the Number of Loans or Advances Requested on this RFF:",null,null,null,null,null,null,null,"Select One"]
["Draw #","Request Date","Program Activity ","Request Type","First Name Primary Borrower","Last Name Primary Borrower","Property Street Address","City","Zip","Loan or Advance Status","Estimated Closing Date (if applicable)","Actual Closing Date\n(if applicable)","Work Completion Date\n (OOR ONLY)","General or Disaster Client","Activity Delivery Fee ($)","Home Buyer Education Fee ($)","CalHome Loan Amount ($)","Amount Requested This RFF ($)","HCD Approved amount \n(HCD USE ONLY)","Contract Funds Available this Draw ($)","HCD Comments",null,null,"Advanced Funds","Advanced Funds Reconciled","Drawn Total","Verified Usage","Verified Total","Total % Drawn","Verified Total % Drawn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM('A. Request for Funds'!K25, 'A. Request for Funds'!K26, 'A. Request for Funds'!K27, 'A. Request for Funds'!K28)","v":0},null,{"$f":"'A. Request for Funds'!K25+'A. Request for Funds'!K26+'A. Request for Funds'!K27+'A. Request for Funds'!K28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,{"$f":"ROUND(O7+P7+Q7,0)","v":0},null,{"$f":"T6-S7","v":0},null,null,null,{"$f":"IF(OR($D7=\"Advance\",$D7=\"Advance-PDL or ADF\"),R7,\"$0\")","v":"$0"},{"$f":"IF(AND(J7=\"Closed\",OR(D7=\"Advance\",D7=\"Advance-PDL or ADF\")),\"YES\",\"NO\")","v":"NO"},{"$f":"X7","v":"$0"},{"$f":"IF($J7=\"Closed\", $R7,\"$0\")","v":"$0"},{"$f":"AA7","v":"$0"},{"$f":"Z7/$T$6","v":{"$error":"#DIV/0!"}},{"$f":"AB7/$T$6","v":{"$error":"#DIV/0!"}},null,null,null,null,"Open/Pending"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,{"$f":"ROUND(O8+P8+Q8,0)","v":0},null,0,null,null,null,"$0","NO",{"$f":"X8+X7","v":0},"$0",{"$f":"AA8+AA7","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Closed"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,{"$f":"ROUND(O9+P9+Q9,0)","v":0},null,0,null,null,null,"$0","NO",{"$f":"X9+Z8","v":0},"$0",{"$f":"AA9+AB8","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Select One"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,{"$f":"ROUND(O10+P10+Q10,0)","v":0},null,0,null,null,null,"$0","NO",0,"$0",{"$f":"AA10+AB9","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Reimbursement"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,{"$f":"ROUND(O11+P11+Q11,0)","v":0},null,0,null,null,null,"$0","NO",0,"$0",{"$f":"AA11+AB10","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Advance"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,{"$f":"ROUND(O12+P12+Q12,0)","v":0},null,0,null,null,null,"$0","NO",0,"$0",{"$f":"AA12+AB11","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Advance-PDL or ADF"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",{"$f":"AA13+AB12","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",{"$f":"AA14+AB13","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Select One"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"MA"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"OOR"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"PDL-MA"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,0,null,null,null,"$0","NO",0,"$0",0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"ADU/JADU"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"Select One","Select One",null,null,null,null,null,"Select One",null,null,null,"Select One",null,null,null,0,null,{"$f":"T25-S26","v":0},null,null,null,"$0","NO",{"$f":"X26+Z25","v":0},"$0",{"$f":"AA26+AB25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,"Advance and Reimbursement Totals (counts and totals)",null,null,"Open and Pending Totals",null,"General and Disaster  Totals",null,null,null,"Activity Counts",null,null,"Activity Delivery Fees","Home Buyer Education Fees","CalHome Loan Amounts","Total Requested","HCD Approved Totals","Contract Funds Available this Draw ($)"]
[null,null,null,null,null,"Advance Count",{"$f":"COUNTIF(D6:D26, \"Advance\")","v":0},null,"Open/Pending",{"$f":"COUNTIF($J$7:$J$26, \"Open/Pending\")","v":0},"General Clients",{"$f":"COUNTIF($N$7:$N$26, \"General\")","v":0},null,"MA",null,{"$f":"COUNTIF($C$7:$C$26, \"MA\")","v":0},null,{"$f":"SUMIF($C$7:$C$26,\"MA\",$O$7:$O$26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"MA\",P7:P26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"MA\",Q7:Q26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"MA\",R7:R26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"MA\",S7:S26)","v":0},{"$f":"T26","v":0}]
[null,null,null,null,null,"Advance Total",{"$f":"SUMIF(D7:D26,\"Advance\",O7:O26)+SUMIF(D7:D26, \"Advance\", P7:P26)+SUMIF(D7:D26, \"Advance\", Q7:Q26)","v":0},null,"Closed",{"$f":"COUNTIF($J$7:$J$26, \"Closed\")","v":0},"Disaster Clients",{"$f":"COUNTIF($N$7:$N$26, \"Disaster\")","v":0},null,"OOR",null,{"$f":"COUNTIF($C$7:$C$26, \"OOR\")","v":0},null,{"$f":"SUMIF($C$7:$C$26,\"OOR\",O7:O26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"OOR\",P7:P26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"OOR\",Q7:Q26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"OOR\",R7:R26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"OOR\",S7:S26)","v":0}]
[null,null,null,null,null,"Reimbursement Count",{"$f":"COUNTIF(D6:D26, \"Reimbursement\")","v":0},null,null,null,null,null,null,"PDL",null,{"$f":"COUNTIF($C$7:$C$26, \"PDL-MA\")","v":0},null,{"$f":"SUMIF($C$7:$C$26,\"PDL-MA\",O7:O26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"PDL-MA\",P7:P26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"PDL-MA\",Q7:Q26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"PDL-MA\",R7:R26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"PDL-MA\",S7:S26)","v":0}]
[null,null,null,null,null,"Reimbursement Total",{"$f":"SUMIF(D7:D26,\"Reimbursement\", O7:O26)+SUMIF(D7:D26, \"Reimbursement\", P7:P26)+SUMIF(D7:D26, \"Reimbursement\", Q7:Q26)","v":0},null,"Totals",{"$f":"SUM(J28:J30)","v":0},"Totals",{"$f":"SUM(L28:M30)","v":0},null,"ADU-JADU",null,{"$f":"COUNTIF($C$7:$C$26, \"ADU/JADU\")","v":0},null,{"$f":"SUMIF($C$7:$C$26,\"ADU/JADU\",O7:O26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"ADU/JADU\",P7:P26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"ADU/JADU\",Q7:Q26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"ADU/JADU\",R7:R26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"ADU/JADU\",S7:S26)","v":0}]
[null,null,null,null,null,"Totals (Count/Dollar)",{"$f":"SUM(G28,G30)","v":0},{"$f":"SUM(G29,G31)","v":0},null,null,null,null,null,"Totals",null,{"$f":"SUM(P28:Q31)","v":0},null,{"$f":"SUMIF($C$7:$C$26,\"TA-SELF-HELP\",O7:O26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"TA-SELF-HELP\",P7:P26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"TA-SELF-HELP\",Q7:Q26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"TA-SELF-HELP\",R7:R26)","v":0},{"$f":"SUMIF($C$7:$C$26,\"TA-SELF-HELP\",S6:S26)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(O5:O26),0)","v":0},{"$f":"ROUND(SUM(P5:P26),0)","v":0},{"$f":"ROUND(SUM(Q7:Q26),0)","v":0},{"$f":"ROUND(SUM(R7:R26),0)","v":0},{"$f":"SUM(S7:S26)","v":0}]
[]
[null,null,null,null,null,"Advanced Approved",{"$f":"SUMIF(D7:D26, \"Advance\", S7:S26)","v":0}]
[null,null,null,null,null,"Reimbursement Approved",{"$f":"SUMIF(D7:D26, \"Reimbursement\", S7:S26)","v":0}]

{"sheet":"C. TA Self Help","index":2,"n_rows":34,"n_cols":26,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,17],[1,0,1,17],[3,2,4,2],[0,18,2,35],[2,0,2,8],[2,9,2,11],[2,12,2,17],[25,3,25,5],[26,4,26,5],[6,15,6,17],[6,21,6,24],[5,4,5,11],[5,12,5,14],[5,15,5,17],[8,4,8,11],[9,12,9,14],[9,15,9,17],[7,18,7,20],[5,21,5,24],[6,4,6,11],[6,12,6,14],[25,15,25,17],[25,18,25,20],[25,21,25,24],[26,15,26,17],[26,18,26,20],[26,21,26,24],[11,4,11,11],[11,12,11,14],[11,15,11,17],[27,4,27,5],[28,4,28,5],[29,4,29,5],[20,4,20,11],[20,12,20,14],[20,18,20,20],[21,18,21,20],[20,15,20,17],[20,21,20,24],[22,4,22,11],[22,12,22,14],[22,15,22,17],[22,18,22,20],[22,21,22,24],[21,4,21,11],[21,12,21,14],[21,15,21,17],[21,21,21,24],[3,3,4,3],[8,21,8,24],[3,0,4,0],[3,15,3,17],[3,21,3,24],[19,4,19,11],[19,12,19,14],[19,15,19,17],[19,21,19,24],[17,4,17,11],[18,4,18,11],[18,12,18,14],[10,4,10,11],[10,12,10,14],[10,15,10,17],[16,18,16,20],[18,21,18,24],[3,1,4,1],[17,12,17,14],[17,15,17,17],[17,21,17,24],[19,18,19,20],[18,15,18,17],[15,21,15,24],[24,21,24,24],[24,18,24,20],[24,4,24,11],[24,12,24,14],[24,15,24,17],[23,4,23,11],[23,12,23,14],[23,15,23,17],[23,21,23,24],[23,18,23,20],[16,15,16,17],[16,21,16,24],[15,18,15,20],[15,15,15,17],[13,21,13,24],[14,15,14,17],[14,21,14,24],[13,18,13,20],[14,18,14,20],[13,15,13,17],[5,18,5,20],[6,18,6,20],[3,18,4,20],[9,21,9,24],[7,21,7,24],[13,4,13,11],[10,21,10,24],[9,18,9,20],[10,18,10,20],[9,4,9,11],[8,18,8,20],[7,4,7,11],[7,12,7,14],[7,15,7,17],[8,12,8,14],[8,15,8,17],[13,12,13,14],[11,21,11,24],[12,4,12,11],[12,12,12,14],[12,15,12,17],[12,21,12,24],[11,18,11,20],[12,18,12,20],[22,25,22,35],[23,25,23,35],[24,25,24,35],[13,25,13,35],[14,25,14,35],[15,25,15,35],[16,25,16,35],[17,25,17,35],[18,25,18,35],[16,12,16,14],[15,4,15,11],[15,12,15,14],[14,12,14,14],[3,12,4,14],[3,4,4,11],[19,25,19,35],[20,25,20,35],[21,25,21,35],[7,25,7,35],[10,25,10,35],[11,25,11,35],[12,25,12,35],[3,25,4,35],[5,25,5,35],[6,25,6,35],[17,18,17,20],[18,18,18,20],[16,4,16,11],[14,4,14,11],[8,25,8,35],[9,25,9,35],[4,15,4,17],[4,21,4,24]]}
["Technical Assistance Self Help Funds Reconciliation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HCD USE ONLY"]
["Instructions: If requesting funds for Technical Assistance Self Help, please complete the following Financial Summary fields. Use drop-down below to select the number of unique technical assistance costs for self help this RFF and complete all yellow fields (as applicable). "]
["Select the Number of Unique Technical Assistance Costs for Self Help This RFF:",null,null,null,null,null,null,null,null,"Select One"]
["Draw #","Request Date","Program Activity","Request Type","Eligible Costs",null,null,null,null,null,null,null,"Cost Type\n(Refer to Section 7737 of CalHome Guidelines)",null,null,"Amount Requested This RFF ($)",null,null,"HCD Approved Amount\n(HCD Use Only)",null,null,"Contract Funds Available This Draw ($)",null,null,null,"HCD Comments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Request for Funds'!$K$29","v":0},null,null,null,null,null,{"$f":"'A. Request for Funds'!G29-'A. Request for Funds'!I29","v":0}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V5-S6","v":0}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V6-S7","v":0}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SELF HELP","Select One",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,"Advance and Reimbursement Totals (counts and totals)",null,null,null,null,null,null,null,null,null,null,null,"Total Requested",null,null,"Total HCD Approved",null,null,"Contract Funds Available This Draw ($)"]
[null,null,null,"Advance Count",{"$f":"COUNTIF(D6:D25, \"Advance\")","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P6:R25)","v":0},null,null,{"$f":"SUM(S6:U25)","v":0},null,null,{"$f":"V25","v":0}]
[null,null,null,"Advance Total",{"$f":"SUMIF(D6:D25,\"Advance\",P6:R25)","v":0}]
[null,null,null,"Reimbursement Count",{"$f":"COUNTIF(D6:D25, \"Reimbursement\")","v":0}]
[null,null,null,"Reimbursement Total",{"$f":"SUMIF(D6:D25,\"Reimbursement\", P6:R25)","v":0}]
[null,null,null,"Totals (Count/Dollar)",{"$f":"SUM(E27,E29)","v":0},{"$f":"SUM(E28,E30)","v":0}]
[]
[null,null,null,"Advanced Approved",{"$f":"SUMIF(D6:D25, \"Advance\", S6:U25)","v":0}]
[null,null,null,"Reimbursement Approved",{"$f":"SUMIF(D6:D25, \"Reimbursement\", S6:U25)","v":0}]

{"sheet":"D. TA Shared Housing","index":3,"n_rows":36,"n_cols":31,"rows_kept":36,"cut":false,"hidden":false,"merged":[[31,7,31,8],[27,12,28,12],[29,12,30,12],[27,13,28,13],[26,12,26,13],[26,14,27,14],[26,15,27,15],[26,6,26,8],[27,7,27,8],[28,7,29,8],[28,6,29,6],[29,11,30,11],[27,11,28,11],[4,25,5,25],[26,10,26,11],[26,3,26,5],[27,4,27,5],[4,19,5,19],[4,20,5,20],[4,21,5,21],[4,22,5,22],[4,23,5,23],[4,24,5,24],[4,11,5,11],[4,12,5,12],[4,13,5,13],[4,15,5,15],[26,16,27,16],[4,3,5,3],[28,4,28,5],[29,4,29,5],[27,10,28,10],[29,10,30,10],[30,4,30,5],[30,7,30,8],[25,17,25,18],[24,17,24,18],[23,17,23,18],[22,17,22,18],[21,17,21,18],[4,8,5,8],[4,9,5,9],[4,10,5,10],[4,17,5,18],[20,17,20,18],[19,17,19,18],[18,17,18,18],[17,17,17,18],[16,17,16,18],[15,17,15,18],[14,17,14,18],[13,17,13,18],[12,17,12,18],[11,17,11,18],[0,15,3,18],[1,0,1,14],[2,0,2,14],[10,17,10,18],[9,17,9,18],[8,17,8,18],[7,17,7,18],[6,17,6,18],[3,0,3,5],[4,0,5,0],[4,1,5,1],[4,4,5,4],[4,5,5,5],[4,2,5,2],[4,6,5,6],[4,7,5,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HCD Use Only"]
["Technical Assistance for Shared Housing Funds Reconciliation                                                                                                                                      "]
["Instructions: If requesting funds for Technical Assistance for Shared Housing, please complete the following Financial Summary fields. Use the drop-down below to select the number of unique technical assistance costs for shared housing this RFF and complete all yellow fields (as applicable). "]
["Select the Number of Unique Technical Assistance Costs for Shared Housing This RFF:",null,null,null,null,null,"Select One"]
["Draw #","Request Date","Program Activity ","Request Type","Provider First Name","Provider Last Name","Property Street Address","City","Zip","Match Status","Date","General or Disaster Client","First and Last Name Seeker","Returning Client?","Amount Requested This RFF ($)","HCD Approved amount \n(HCD USE ONLY)","Contract Funds Available this Draw ($)","HCD Comments",null,"Advanced Funds","Advanced Funds Reconciled","Drawn Total","Verified Usage","Verified Total","Total % Drawn","Verified Total % Drawn"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A. Request for Funds'!K30","v":0},null,{"$f":"'A. Request for Funds'!G30-'A. Request for Funds'!I30","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Select One"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,{"$f":"Q6-P7","v":0},null,null,{"$f":"IF(OR($D7=\"Advance\",$D7=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},{"$f":"IF(AND(J7=\"Closed\",OR(D7=\"Advance\",D7=\"Advance-PDL or ADF\")),\"YES\",\"NO\")","v":"NO"},{"$f":"T7","v":"$0"},{"$f":"IF($J7=\"Closed\",#REF!, \"$0\")","v":"$0"},{"$f":"W7","v":"$0"},{"$f":"V7/$Q$6","v":{"$error":"#DIV/0!"}},{"$f":"X7/$Q$6","v":{"$error":"#DIV/0!"}},null,null,null,null,"Open/Pending"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D8=\"Advance\",$D8=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",{"$f":"T8+T7","v":0},{"$f":"IF($J8=\"Closed\",#REF!, \"$0\")","v":"$0"},{"$f":"W8+W7","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Closed"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D9=\"Advance\",$D9=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",{"$f":"T9+V8","v":0},{"$f":"IF($J9=\"Closed\",#REF!, \"$0\")","v":"$0"},{"$f":"W9+X8","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Select One"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D10=\"Advance\",$D10=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J10=\"Closed\",#REF!, \"$0\")","v":"$0"},{"$f":"W10+X9","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Reimbursement"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D11=\"Advance\",$D11=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J11=\"Closed\",#REF!, \"$0\")","v":"$0"},{"$f":"W11+X10","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Advance"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D12=\"Advance\",$D12=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J12=\"Closed\",#REF!, \"$0\")","v":"$0"},{"$f":"W12+X11","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Advance-PDL or ADF"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D13=\"Advance\",$D13=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J13=\"Closed\",#REF!, \"$0\")","v":"$0"},{"$f":"W13+X12","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D14=\"Advance\",$D14=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J14=\"Closed\",#REF!, \"$0\")","v":"$0"},{"$f":"W14+X13","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D15=\"Advance\",$D15=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J15=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D16=\"Advance\",$D16=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J16=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D17=\"Advance\",$D17=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J17=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D18=\"Advance\",$D18=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J18=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D19=\"Advance\",$D19=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J19=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D20=\"Advance\",$D20=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J20=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D21=\"Advance\",$D21=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J21=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"Select One"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D22=\"Advance\",$D22=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J22=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"MA"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D23=\"Advance\",$D23=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J23=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"OOR"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D24=\"Advance\",$D24=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J24=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"PDL-MA"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,0,null,null,{"$f":"IF(OR($D25=\"Advance\",$D25=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J25=\"Closed\",#REF!, \"$0\")","v":"$0"},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,null,"ADU/JADU"]
[{"$f":"'A. Request for Funds'!$D$21","v":"Select One"},{"$f":"IF('A. Request for Funds'!$D$13=\"\",\"\",'A. Request for Funds'!$D$13)","v":""},"TA-SHARED","Select One",null,null,null,null,null,"Select One",null,"Select One",null,"Select One",null,null,{"$f":"Q25-P26","v":0},null,null,{"$f":"IF(OR($D26=\"Advance\",$D26=\"Advance-PDL or ADF\"),#REF!,\"$0\")","v":"$0"},"NO",0,{"$f":"IF($J26=\"Closed\",#REF!, \"$0\")","v":"$0"},{"$f":"W26+X25","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,"Advance and Reimbursement Totals (counts and totals)",null,null,"Open/Matched/Hold Totals",null,null,null,"General and Disaster  Totals",null,"Returning Client Counts",null,"Total Requested","Total HCD Approved","Contract Funds Available this Draw ($)"]
[null,null,null,"Advance Count",{"$f":"COUNTIF(D7:D26, \"Advance\")","v":0},null,"Open/Pending",{"$f":"COUNTIF($J$7:$J$26, \"Open/Pending\")","v":0},null,null,"General Clients",0,"Returning Clients",{"$f":"COUNTIF(N7:N26, \"Yes\")","v":0}]
[null,null,null,"Advance Total",{"$f":"SUMIF(D7:D26,\"Advance\",O7:O26)","v":0},null,"Matched",{"$f":"COUNTIF($J$7:$J$26, \"Matched\")","v":0},null,null,null,null,null,null,{"$f":"SUM(O7:O26)","v":0},{"$f":"SUM(P7:P26)","v":0},{"$f":"Q26","v":0}]
[null,null,null,"Reimbursement Count",{"$f":"COUNTIF(D7:D26, \"Reimbursement\")","v":0},null,null,null,null,null,"Disaster Clients",0,"Non-Returning Clients"]
[null,null,null,"Reimbursement Total",{"$f":"SUMIF(D7:D26,\"Reimbursement\",O7:O26)","v":0},null,"Hold",{"$f":"COUNTIF($J$7:$J$26, \"Hold\")","v":0},null,null,null,null,null,{"$f":"COUNTIF(N7:N26, \"No\")","v":0}]
[null,null,null,"Totals (Count/Dollar)",{"$f":"SUM(E28,E30)","v":0},{"$f":"SUM(E29,E31)","v":0},"Totals",{"$f":"SUM(H28:I31)","v":0},null,null,"Totals",{"$f":"SUM(L28:M31)","v":0},"Totals",{"$f":"SUM(N28,N31)","v":0}]
[]
[]
[null,null,null,"Advanced Approved",{"$f":"SUMIF(D7:D26, \"Advance\", P7:P26)","v":0}]
[null,null,null,"Reimbursement Approved",{"$f":"SUMIF(D7:D26, \"Reimbursement\", P7:P26)","v":0}]