{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","1-Narrative Summary","2-Financial Summary","3-Project Details","4-Certification","5-Summary Sheet","Project Data","Grantee Data","Drop Down Box"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":3,"defined_names":109,"comments":2,"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":"Instructions","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,2,7],[3,0,5,7],[6,0,8,7],[9,0,11,7]]}
["Instructions for the Local Housing Trust Fund (LHTF) Program Annual Reporting:"]
["Pursuant to Health and Safety Code (HSC) Section 50843.5(a)\nThe Department is authorized to provide matching grants to Local Housing Trust Funds established by cities and counties, Native American Tribes, and/or incorporated 501(c)(3) nonprofit organizations."]
[]
["Annual Reporting\nSenate Bill 3 (SB3) (Chapter 365, Statutes of 2017) allowed the Department to adopt Guidelines instead of regulations for the LHTF program, establishing requirements for administration of the program.  The Department adopted Guidelines in April 2020.  Per Reporting Section 112 of the LHTF Guidelines, not later than July 31 of each year, a Grantee shall provide to the Department an annual report, in a format specified by the Department, including but not limited to the information requested in this workbook.  Per Cancellation and Termination Section 111(c) of the LHTF Guidelines, failure to meet reporting requirements will result in notice to the Grantee that it must satisfactorily cure any deficiencies within three months of the notice, or it will be ineligible for any additional LHTF award."]
[]
[]
["Completion of the Annual Reporting Workbook\nAll fields in which information is requested must be completed by the Grantee within the tabs of the reporting workbook as applicable. The number of tabs will be dependent on the number of eligible projects awarded LHTF funds. Reporting workbooks which contain blank information will be considered incomplete and will be returned to the Grantee for completion. Any questions pertaining to the reporting requirements should be directed to the Grant Management Representative assigned to the project. If you do not have your Grant Management Representative information, you may submit your inquiry by email at LHTFSGM@hcd.ca.gov."]
[]
[]
["Instructions \nPlease navigate through the form fields (yellow cells) using Tab key and fill in information as prompted.\n\nTab 1 - Narrative Summary \n(Per Reporting Section 112(a) of the LHTF Guidelines, please complete the following fields within Tab 1 beginning on Row 11:\nB12: Enter your HCD Contract Number (Can be found on your executed Standard Agreement)\nF12: Enter the Grantee Name (Name of entity awarded LHTF grant funds).\nB13: Enter the Preparer Name and Title (Person completing this report)\nF13: Enter the Preparer Phone Number\nB14: Enter the Preparer Email Address.\nF14: Use the drop-down menu to select the appropriate reporting period.\nIn Section 1 (beginning in cell A16) answer the questions provided:\n1. Summarize the Activities planned to be undertaken in the next reporting period. §112 (2)\n2. Provide a thorough explanation of problems encountered in program implementation.  Include a description of the solution and when it will be implemented. §112 (3)\n3. Provide a thorough description of how problems may impact the ability to complete or fulfill obligations under the Standard Agreement §112 (4)\n4. Provide information about additional revenue generated from program funding from loan repayments, interest, fees or other during the reporting period. §109 (b)\n5. Provide a thorough description of the public noticing and hearing process. Attach any documentation of the website posting and relevant records. §108 (c) \n6. Optional question: please share any success stories you’ve had from the LHTF program. \n\nTab 2 - Financial Summary \n(Per Reporting Section 12(b) of the LHTF Guidelines, please complete the following fields within Tab 2:\nMost information will automatically populate in Row 5 based on the Financial Summary Table. There are two items which will require manual entry: \nA5: Enter the total amount of program funds awarded. Use copies of Request for Funds forms as reference.\nC5: Enter the Total amount of Program Funds expended on Administrative expenses to date. Use Request for Funds forms as reference.\nTab through to the Table, which begins in cell A9.\n1. Enter your first projects’ name.\n2. Using the drop-down menu, select the project type. Refer to the Guidelines §101 (g) to determine which eligible project type your project falls under.\n3. Select the type of loan from the drop-down menu (permanent financing, construction, or both)\n4. Select the status of the Loan as Open/Pending or Closed from the drop-down menu\n5. Enter the amount of program funds Committed into the Trust Fund for the project\n6. Enter the amount of Matching Funds on deposit for the project. This number should match the amount of program funds committed for the same project per the LHTF Final Guidelines Section 104 (a) and (e ). \n7. Enter the amount of funds expended to date on Extremely Low-Income Households (30% or lower Area Median Income). The first column (G) is for LHTF Program Funds, the second (H) is for Matching Funds. Column I will indicate what percentage of total funds expended on each project have been spent on Extremely Low-Income units and will turn red if it is less than the 30% minimum for this category (see LHTF Final Guidelines Section 105 (c)). \n8. Enter the amount of funds expended to date on Lower-Income Households (between 30% and 80% of Area Median Income). The first column (J) is for LHTF Program Funds, the second (K) is for Matching Funds. Column L will indicate what percentage of total funds expended on each project have been spent on Lower-Income units.  \n9. Enter the amount of funds expended to date on Moderate-Income Households (Between 80% and 120% Area Median Income). The first column (M) is for LHTF Program Funds, the second (N) is for Matching Funds. Column O will indicate what percentage of total funds expended on each project have been spent on Moderate-income household and will turn red if the amount exceeds the 20% maximum for this category (see LHTF Final guidelines 105 (d)).  \n10. Continue in the next row with the next project until you have listed each project that received LHTF funding. All projects should be listed on the Financial Summary, including those Projects that are completed or closed.\n\nTab 3 – Project Details \nBefore filling in any information on this sheet, copy the blank sheet for each active Project that received a commitment of LHTF funds. Enter CTRL-SHIFT-Q to make a copy of the sheet. You will fill out one Project Details sheet per project, using the following steps:\nSection 2 Project Summary: Select the project you are reporting on from the drop-down list. The list will be pulled from the projects named in the Financial Summary table. Tab through and input the address, developer name, developer contact name and title, type of project (selected from drop-down menu), project activity, status of the project and the date of completion (if applicable).\nIf the Project Status is “Construction Completed” or “Permanent Loan Closed”, you will be prompted to select from a drop-down menu in cell F12 the type of documentation included to confirm the completion of the project. Please be sure to attach this document to the report upon submittal. Once a project is completed, the Project Details do not need to be reported again in any subsequent years of the contract term. \na. For construction completed, appropriate evidence includes a Certificate of Completion or Certificate of Occupancy\nb. For Permanent Loan Closed, appropriate evidence includes a recorded Deed of Trust or Recorded Regulatory Agreement.\nIf the project is not yet complete, you may skip E12. \nIf you are unsure what constitutes appropriate documentation for your project activity or have alternative types of documentation to prove the project completion, please contact your Grant Management Representative to confirm.\n\nSection 3: Unit Information. Use the command CTRL-SHIFT-R or click on the button in cell F16 to create the appropriate number of rows. Each row represents one unit within the project being reported. You will be prompted to enter the Unit Number, Unit Size (by bedrooms), Income Level Restriction, and amount of Program Funds expended for each unit. \n\nSection 4: Matching Sources. Input the sources used to provide matching funds expended on the project. Each row represents one source. You will be prompted to enter the source of matching funds (selected from a drop-down menu), Amount of funds on deposit, how much of that source was expended on the project, and whether or not documentation is attached confirming the amount expended and source of matching funds. \n\nSection 5: Additional Comments. Input any additional notes or comments for your State Grant Management Representative and the Department.\n\nTab 4 – Certification\nThe Certification should be signed by the Authorized Representative or designee listed in your authorizing resolution. You may select to either enter a typed electronic signature or input a written signature. "]

{"sheet":"1-Narrative Summary","index":1,"n_rows":79,"n_cols":5,"rows_kept":79,"cut":false,"hidden":false,"merged":[[79,0,79,7],[59,0,59,7],[61,0,61,1],[61,3,61,5],[61,6,61,7],[78,0,78,7],[63,0,63,7],[64,0,77,7],[62,0,62,1],[62,3,62,5],[62,6,62,7],[60,0,60,7],[12,1,12,3],[12,5,12,7],[16,0,16,7],[17,0,28,7],[13,1,13,3],[44,0,44,7],[45,0,58,7],[13,5,13,7],[29,0,29,7],[30,0,43,7],[15,0,15,7],[1,0,6,7],[7,0,7,7],[11,1,11,3],[8,0,8,7],[11,5,11,7],[9,0,9,7]]}
["beginning of sheet 2-Narrative Summary"]
["DEPARTMENT OF HOUSING AND COMMUNITY DEVELOPMENT\nDIVISION OF STATE FINANCIAL ASSISTANCE \nSTATE GRANT MANAGEMENT\n2020 West El Camino, 4th Floor\nSacramento, CA  95833\nLHTFSGM@HCD.CA.GOV "]
[]
[]
[]
[]
[]
["LOCAL HOUSING TRUST FUND (LHTF) PROGRAM"]
["Annual Report"]
["Narrative Summary"]
["Last Revised 6/20/2022"]
["HCD Contract Number:",null,null,null,"Grantee Name:"]
["Preparer Name and Title:",null,null,null,"Preparer Phone Number:"]
["Preparer Email:",null,null,null,"Reporting Period:"]
[]
["The Department reserves the right to request other forms or reports as may be necessary or required to verify the information provided in this Annual Report."]
["1. Please summarize the activities planned to be undertaken in the next reporting period, pursuant to Guidelines §112(a)(2)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["2. Please describe any problems encountered in Program implementation.  Include a description of the solution and when it will be implemented, pursuant to Guidelines §112(a)(3)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["3. Please describe how the problems referenced in question #2 above may impact the ability to complete or fulfill obligations under the Standard Agreement, pursuant to Guidelines §112(a)(4)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["4. Please describe additional revenue generated from program funding (e.g. loan repayments, interest, fees) in this reporting period and how revenue was generated pursuant to Guidelines §109 (b). Please provide a description of how your estimate of households to be assisted was determined. "]
[]
["4a. Program Income Earned this reporting period: ",null,null,"4b. Approximate Number of Households to be assisted with this period's Reuse Revenue: "]
["4c. Current Balance of Reuse Revenue: "]
["5. Please outline the steps for completing your public noticing and hearing process. Attach required documentation of the website posting and any relevant records of the public hearing, pursuant to Guidelines §108(c)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["6. Please share any success stories you've had from HCD LHTF-funded projects."]

{"sheet":"2-Financial Summary","index":2,"n_rows":21,"n_cols":18,"rows_kept":21,"cut":false,"hidden":false,"merged":[[21,0,21,17],[2,1,2,2],[2,5,2,6],[2,9,2,11],[1,0,1,17],[6,8,6,9],[6,11,6,12],[6,14,6,15],[20,0,20,17]]}
["beginning of sheet 3 - Financial Summary"]
["LOCAL HOUSING TRUST FUND (LHTF) PROGRAM\nAnnual Report\nFinancial Summary "]
["Grantee:","",null,null,"HCD Contract Number: ","",null,null,"Reporting Period: ",""]
["Total Amount of Program Funds Awarded:","Maximum Allowable Program Funds for Admin: ","Program Funds Expended on Admin to date:","Percent of Program Funds Expended on Admin:","Total Amount of Program Funds expended to date:","Percent of Program Funds expended to date:","Remaining Balance of Program Funds:","Percent of Program Funds remaining:","Percent of Program Funds Committed:","Total Amount of Match Funds on deposit:","Amount of Match expended to date:","Percent of Match expended to date:"]
[null,{"$f":"0.05*A5","v":0},null,{"$f":"C5/A5","v":{"$error":"#DIV/0!"}},{"$f":"I20+L20+O20+C5","v":0},{"$f":"E5/A5","v":{"$error":"#DIV/0!"}},{"$f":"A5-E5","v":0},{"$f":"G5/A5","v":{"$error":"#DIV/0!"}},{"$f":"E20/A5","v":{"$error":"#DIV/0!"}},{"$f":"G20","v":0},{"$f":"J20+M20+P20","v":0},{"$f":"K5/J5","v":{"$error":"#DIV/0!"}}]
[null,null,5000,null,null,null,null,null,"\\"]
["Project(s) Names\nPlease list all projects awarded from this allocation of LHTF including completed projects","Project Type \n(per Guidelines §101 (g)) ","Type of Loan","Loan Status","Total Amount of Program Funds Committed \n(Excluding Admin)","Amount of Program Funds Committed to Admin","Amount of Matching Funds On Deposit \n(Excluding Admin)","Amount of Matching Funds for Admin","Amount of Funds Expended on Extremely Low-Income (ELI) Households (up to 30% AMI)\nto Date. \nMust be at least 30% of expended funds",null,"Percent of Committed Program Funds Expended on ELI Households (see LHTF Final Guidelines §105 (c)) ","Amount of Funds Expended on Lower-Income Households (up to 80% AMI) \nto Date",null,"Percent of Committed Program Funds Expended on Lower Income Households (see LHTF Final Guidelines §105 (e)) ","Amount of Funds Expended on Moderate-Income Households (up to 120% AMI)\nto Date. \nMust be no more than 20% of expended funds",null,"Percent of Committed Program Funds Expended on Moderate Income Households (see LHTF Final Guidelines §105 (d)) ","Amout Committed but Unexpended"]
[null,null,null,null,null,null,null,null,"LHTF Program Funds","Matching Funds",null,"LHTF Program Funds","Matching Funds",null,"LHTF Program Funds","Matching Funds"]
["Project 1","Select One","Select One",null,null,null,null,null,null,null,{"$f":"I9/E9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"L9/E9","v":{"$error":"#DIV/0!"}},null,null,{"$f":"(O9/E9)","v":{"$error":"#DIV/0!"}},{"$f":"E9-I9-L9-O9","v":0}]
["Project 2","Select One","Select One",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},0]
["Project 3","Select One","Select One",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},0]
["Project 4","Select One","Select One",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},0]
["Project 5","Select One","Select One",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},0]
["Project 6","Select One","Select One",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},0]
["Project 7","Select One","Select One",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},0]
["Project 8","Select One","Select One",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},0]
["Project 9","Select One","Select One",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},0]
["Project 10","Select One","Select One",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},null,null,{"$error":"#DIV/0!"},0]
[]
["Projects Total",null,null,null,{"$f":"SUM(E9:E18)","v":0},{"$f":"SUM(F9:F18)","v":0},0,0,0,0,{"$f":"I20/E20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L9:L18)","v":0},{"$f":"SUM(M9:M18)","v":0},{"$f":"L20/E20","v":{"$error":"#DIV/0!"}},{"$f":"SUM(O9:O18)","v":0},{"$f":"SUM(P9:P18)","v":0},{"$f":"(O20/E20)","v":{"$error":"#DIV/0!"}},{"$f":"E20-I20-L20-O20","v":0}]
["Additional Comments"]

{"sheet":"3-Project Details","index":3,"n_rows":39,"n_cols":13,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,1,0,4],[5,1,5,4],[13,2,13,3],[38,1,38,4],[14,1,14,4],[15,1,15,4],[36,1,36,4],[37,1,37,4],[19,1,19,4],[20,1,20,4],[7,1,7,4],[4,2,4,4],[6,1,6,4],[1,1,1,4],[2,1,2,4]]}
[null,"beginning of project worksheet",null,null,null,null,null,null,"Non-Residential Sources:",{"$f":"C35","v":{"$error":"#DIV/0!"}},{"$f":"D35","v":0},"Match Expended:",{"$f":"D33","v":0}]
[null,"LOCAL HOUSING TRUST FUND (LHTF) PROGRAM",null,null,null,null,null,null,"Residential Sources:",{"$f":"C36","v":{"$error":"#DIV/0!"}},{"$f":"D36","v":0}]
[null,"Annual Report\nProject Worksheet",null,null,null,null,null,null,"Category","Number of Units","Amount Expended"]
[null,"Grantee Name:","","Grantee Number:",0,null,null,null,"Single Family Residences",{"$f":"COUNTIF(Units142[#All],\"Single Family Residence\")","v":0},{"$f":"SUMIF(Units142[#All],\"Single Family Residence\",Units142[[#Headers],[Amount of Program Funds Expended in Reporting Period]])","v":0}]
[null,"Reporting Period:","",null,null,null,null,null,"Emergency Shelters",{"$f":"COUNTIF(Units142[#All],\"Emergency Shelter\")","v":0},{"$f":"SUMIF(Units142[#All],\"Emergency Shelter\",Units142[[#Headers],[Amount of Program Funds Expended in Reporting Period]])","v":0}]
[null,"1. Instructions",null,null,null,null,null,null,"Studios",{"$f":"COUNTIF(Units142[#All],\"Studio\")","v":0},{"$f":"SUMIF(Units142[#All],\"Studio\",Units142[[#Headers],[Amount of Program Funds Expended in Reporting Period]])","v":0}]
[null,"Please Read before you fill out this page:\n1. Please ensure macros are enabled by clicking \"Enable Content\" on the yellow bar above or going to File-Options-Trust Center-Trust Center Settings, select Macro Settings from the left-hand menu and enable macros. \n2. Before entering any information, copy this sheet (enter \"CTRL-SHIFT-Q\") to create a new blank Project Details form for each active LHTF-funded project on which you are reporting. (i.e. if you have five different projects to report, enter CTRL-SHIFT-Q four times to create four additional reporting templates for a total of five sheets). Please note that text input into the cell for Project Name (cell C8) will autofill the tab name at the bottom of each worksheet.\n3. Select your project name from the drop-down menu in Cell C9. Tab through the form and enter information for the individual project as prompted on each sheet. \n4. If you copy this sheet after filling in the information, you may get a \"Runtime Error.\" If you do, click \"end\" and select the name of the next project on the copied sheet (Cell B9) and press \"enter\" or the return key.\n5. When a project is completed or loan closed, attach appropriate documentation with this report as prompted. Once you have certified project completion on an annual report, you do not need to include project details on the completed project on subsequent report forms. You will continue to list all projects, including those completed, on the Financial Summary form (Tab 2). ",null,null,null,null,null,null,"1 BR",{"$f":"COUNTIF(Units142[#All],\"One-bedroom\")","v":0},{"$f":"SUMIF(Units142[#All],\"One-bedroom\",Units142[[#Headers],[Amount of Program Funds Expended in Reporting Period]])","v":0}]
[null,"2. Project Summary ",null,null,null,null,null,null,"2 BR",{"$f":"COUNTIF(Units142[#All],\"Two-bedroom\")","v":0},{"$f":"SUMIF(Units142[#All],\"Two-bedroom\",Units142[[#Headers],[Amount of Program Funds Expended in Reporting Period]])","v":0}]
[null,"Project Name:",null,"Project Address:",null,null,null,null,"3 BR",{"$f":"COUNTIF(Units142[#All],\"Three-bedroom\")","v":0},{"$f":"SUMIF(Units142[#All],\"Three-bedroom\",Units142[[#Headers],[Amount of Program Funds Expended in Reporting Period]])","v":0}]
[null,"Developer Name:",null,"Developer Contact Name and Title:",null,null,null,null,"4 BR",{"$f":"COUNTIF(Units142[#All],\"Four-bedroom\")","v":0},{"$f":"SUMIF(Units142[#All],\"Four-bedroom\",Units142[[#Headers],[Amount of Program Funds Expended in Reporting Period]])","v":0}]
[null,"Project Type:","Select One","Project Activity:","Select One",null,null,null,"ELI",{"$f":"COUNTIF(Units142[Income Level Restriction\n],\"Extremely Low Income\")","v":0},{"$f":"SUMIF(Units142[Income Level Restriction\n],\"Extremely Low Income\",Units142[Amount of Program Funds Expended in Reporting Period])","v":0}]
[null,"Project Status:","Select One","Date of Completion (if applicable):",null,null,null,null,"LI",{"$f":"COUNTIF(Units142[Income Level Restriction\n],\"Lower Income\")","v":0},{"$f":"SUMIF(Units142[Income Level Restriction\n],\"Lower Income\",Units142[Amount of Program Funds Expended in Reporting Period])","v":0}]
[null,"Date of Affordability Covenant Execution",null,"Expiration Date of Affordability Covenant:",null,null,null,null,"Mod",{"$f":"COUNTIF(Units142[Income Level Restriction\n],\"Moderate Income\")","v":0},{"$f":"SUMIF(Units142[Income Level Restriction\n],\"Moderate Income\",Units142[Amount of Program Funds Expended in Reporting Period])","v":0}]
[null,null,{"$f":"_xlfn.IFS(C12=\"Select One\", \"\",C12=\"Under Construction\",\"\",C12=\"Trust Fund Loan Committed\",\"\",C12=\"Construction Completed\",\"Please include a certificate of completion with your submission of this report:\",C12=\"Permanent Loan Closed\",\"Please select which appropriate evidence of completion is attached to this report:\")","v":""},null,null,null,null,null,"Total",{"$f":"SUM(J11:J13)","v":0},{"$f":"SUM(K11:K13)","v":0}]
[null,"3. Unit Information"]
[null,"Please fill out the table with information regarding units in this project, pursuant to §112 (c) of the guidelines. For as many units as are in this project, add the same number of rows by clicking the \"Add Row\" button or using the key command CTRL-SHIFT-R"]
[null,"Unit Number","Unit Size","Income Level Restriction\n","Amount of Program Funds Expended in Reporting Period",null,null,"Mod"]
[null,null,"Select One","Select One",null,"f"]
[null,"Total:",{"$f":"SUBTOTAL(3,Units142[Unit Size])","v":1},"Total Program Funds Expended this reporting period:",{"$f":"SUBTOTAL(9,Units142[Amount of Program Funds Expended in Reporting Period])","v":0}]
[null,"4. Matching Sources"]
[null,"Please input the source of each matching funds used and the amount expended on this project by matching source."]
[null,"Source of Matching Funds","Matching Amount on Deposit","Match Amount Expended in  Reporting Period","Documentation Attached of Matching Funds, including amount by source"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Select One"]
[null,"Total:",{"$f":"SUM(C23:C32)","v":0},{"$f":"SUM(D23:D32)","v":0}]
[null,"Total on Financial Summary:",{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Non-Residential Sources:",{"$f":"SUMIF(B23:B32,\"<>Residential*\",C23:C32)/C33","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(B23:B32,\"<>Residential*\",D23:D32)","v":0}]
[null,"Residential Sources:",{"$f":"SUMIF(B23:B32,\"Residential*\",C23:C32)/C33","v":{"$error":"#DIV/0!"}},{"$f":"SUMIF(B23:B32,\"Residential*\",D23:D32)","v":0}]
[null,"5. Additional Comments"]
[]
[null,"Enter CTRL-SHIFT-Q to Copy this Sheet and fill out next project's details on a new Project Details Form. "]

{"sheet":"4-Certification","index":4,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,0,10,6],[7,0,7,8],[8,0,8,8],[9,0,9,16],[6,0,6,8],[6,9,6,16],[7,9,7,16],[8,9,8,16],[12,14,12,16],[11,14,11,16],[13,14,13,16],[11,7,11,13],[10,7,10,13],[10,14,10,16],[11,0,11,6],[12,0,12,6],[13,0,13,6],[13,7,13,13],[12,7,12,13],[5,9,5,16],[0,0,0,1],[0,2,0,7],[4,0,4,2],[4,3,4,7],[4,8,4,16],[1,0,1,1],[1,2,1,16],[0,8,0,10],[0,11,0,16],[5,0,5,8],[2,0,2,16],[3,0,3,16]]}
["Grantee Name:",null,{"$f":"IF('1-Narrative Summary'!F12=\"\",\"\",'1-Narrative Summary'!F12)","v":""},null,null,null,null,null,"HCD Grant Number:",null,null,{"$f":"IF('1-Narrative Summary'!B12=\"\",\"\",'1-Narrative Summary'!B12)","v":""}]
["Reporting Period:",null,{"$f":"IF('1-Narrative Summary'!F14=\"\",\"\",'1-Narrative Summary'!F14)","v":""}]
["beginning of certification sheet\nCERTIFICATION\n"]
["*Failure to meet reporting requirements will result in notice to the Grantee that it must satisfactorily cure any deficiencies within three months of the notice, or it will be ineligible for any additional LHTF award (LHTF Final Guidelines §111 (c)) \n**The Department may, as it deems appropriate or necessary, request the repayment of funds from a Grantee, or pursue any other remedies available to it by law for failure to comply with these Guidelines and/or the terms and conditions of the Standard Agreement. (LHTF Final Guidelines §111 (d)) \n***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)"]
["Signature Method: "]
["Name of Authorized Person",null,null,null,null,null,null,null,null,"Title of Authorized Person "]
[]
["Signature of Authorized Person ",null,null,null,null,null,null,null,null,"Date"]
[]
["HCD USE ONLY"]
["SGM Representative Printed Name",null,null,null,null,null,null,"SGM Representative Signature    ",null,null,null,null,null,null,"Date"]
[]
["SGM Manager Printed Name",null,null,null,null,null,null,"SGM Manager Signature                 ",null,null,null,null,null,null,"Date"]

{"sheet":"5-Summary Sheet","index":5,"n_rows":60,"n_cols":24,"rows_kept":60,"cut":false,"hidden":true,"merged":[[16,18,16,25],[6,0,6,14],[5,0,5,14],[12,9,12,14],[28,6,28,7],[28,8,28,9],[7,9,7,11],[7,12,7,14],[8,9,8,11],[21,0,21,25],[22,0,22,25],[19,18,19,25],[27,4,27,5],[27,6,27,7],[25,8,25,9],[25,16,25,17],[25,18,25,19],[24,1,24,2],[24,4,24,5],[19,15,19,17],[27,1,27,2],[26,1,26,2],[25,1,25,2],[25,4,25,5],[29,1,29,2],[29,4,29,5],[29,6,29,7],[28,1,28,2],[23,18,23,19],[24,18,24,19],[24,20,24,25],[25,20,25,25],[23,20,23,25],[28,20,28,25],[29,20,29,25],[20,15,20,17],[20,18,20,25],[23,1,23,2],[23,4,23,5],[23,6,23,7],[23,8,23,9],[23,16,23,17],[27,18,27,19],[26,4,26,5],[26,6,26,7],[26,8,26,9],[26,16,26,17],[26,18,26,19],[0,0,0,25],[20,0,20,2],[20,3,20,4],[20,5,20,14],[11,0,14,2],[14,3,14,8],[7,0,8,2],[9,0,10,2],[3,0,3,25],[16,0,16,2],[17,18,18,25],[17,15,18,17],[7,3,7,8],[8,3,8,8],[9,3,9,8],[11,3,11,8],[15,15,15,25],[6,15,14,25],[1,0,2,25],[13,3,13,8],[12,3,12,8],[4,0,4,24],[5,15,5,25],[16,15,16,17],[38,9,38,10],[44,9,44,10],[39,1,39,2],[39,9,39,10],[40,9,40,10],[41,9,41,10],[42,1,42,2],[41,1,41,2],[40,1,40,2],[38,1,38,2],[43,9,43,10],[43,1,43,2],[32,18,32,19],[34,0,34,10],[35,0,35,10],[36,11,36,12],[36,9,36,10],[37,9,37,10],[37,1,37,2],[36,1,36,2],[33,18,33,19],[32,4,32,5],[33,1,33,2],[37,11,37,12],[33,16,33,17],[43,17,43,18],[38,17,38,18],[36,15,36,16],[38,15,38,16],[39,11,39,12],[40,11,40,12],[41,11,41,12],[42,11,42,12],[43,11,43,12],[36,17,36,18],[37,17,37,18],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,16,31,17],[42,9,42,10],[33,6,33,7],[32,6,32,7],[38,11,38,12],[34,11,34,25],[35,11,35,25],[32,8,32,9],[39,15,39,16],[40,15,40,16],[41,15,41,16],[33,8,33,9],[37,15,37,16],[33,4,33,5],[41,13,41,14],[41,19,41,25],[42,19,42,25],[39,17,39,18],[40,17,40,18],[41,17,41,18],[42,17,42,18],[16,5,16,14],[15,5,15,14],[17,0,17,2],[17,3,17,4],[17,5,17,14],[18,5,18,14],[19,5,19,14],[18,3,18,4],[19,3,19,4],[18,0,18,2],[19,0,19,2],[31,1,31,2],[28,4,28,5],[30,1,30,2],[30,4,30,5],[30,6,30,7],[32,1,32,2],[32,16,32,17],[8,12,8,14],[10,9,10,11],[10,12,10,14],[9,9,9,11],[9,12,9,14],[11,9,11,14],[13,9,13,14],[10,3,10,8],[25,6,25,7],[24,6,24,7],[24,8,24,9],[14,10,14,11],[14,13,14,14],[24,16,24,17],[15,0,15,2],[15,3,15,4],[16,3,16,4],[30,20,30,25],[31,20,31,25],[26,20,26,25],[27,20,27,25],[28,18,28,19],[29,8,29,9],[29,16,29,17],[29,18,29,19],[27,8,27,9],[27,16,27,17],[30,18,30,19],[28,16,28,17],[31,18,31,19],[30,8,30,9],[30,16,30,17],[43,19,43,25],[38,19,38,25],[33,20,33,25],[44,19,44,25],[45,19,45,25],[46,19,46,25],[42,13,42,14],[43,13,43,14],[32,20,32,25],[39,19,39,25],[40,19,40,25],[36,13,36,14],[37,13,37,14],[38,13,38,14],[39,13,39,14],[40,13,40,14],[36,19,36,25],[37,19,37,25],[44,13,44,14],[45,13,45,14],[46,13,46,14],[42,15,42,16],[43,15,43,16],[44,15,44,16],[46,15,46,16],[45,15,45,16],[47,0,47,14],[47,15,47,25],[44,17,44,18],[45,17,45,18],[46,17,46,18],[45,11,45,12],[46,11,46,12],[45,1,45,2],[46,1,46,2],[45,9,45,10],[46,9,46,10],[44,1,44,2],[44,11,44,12],[48,0,48,14],[48,15,48,25],[49,1,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[49,15,49,16],[49,17,49,18],[49,19,49,22],[49,23,49,25],[50,19,50,22],[50,23,50,25],[51,1,51,2],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[51,15,51,16],[51,17,51,18],[51,19,51,22],[51,23,51,25],[50,1,50,2],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[50,15,50,16],[50,17,50,18],[52,19,52,22],[52,23,52,25],[53,1,53,2],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14],[53,15,53,16],[53,17,53,18],[53,19,53,22],[53,23,53,25],[52,1,52,2],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[52,15,52,16],[52,17,52,18],[54,19,54,22],[54,23,54,25],[55,1,55,2],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[55,15,55,16],[55,17,55,18],[55,19,55,22],[55,23,55,25],[54,1,54,2],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[54,15,54,16],[54,17,54,18],[56,19,56,22],[56,23,56,25],[57,1,57,2],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[57,15,57,16],[57,17,57,18],[57,19,57,22],[57,23,57,25],[56,1,56,2],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[56,13,56,14],[56,15,56,16],[56,17,56,18],[58,19,58,22],[58,23,58,25],[59,1,59,2],[59,3,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[59,13,59,14],[59,15,59,16],[59,17,59,18],[59,19,59,22],[59,23,59,25],[58,1,58,2],[58,3,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[58,13,58,14],[58,15,58,16],[58,17,58,18]]}
[]
["Local Housing Trust Fund (LHTF)"]
[]
["Review Workbook"]
[]
["Section 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"This box can be used to add additional comments regarding Sections 1-Section 5"]
["General Information "]
["Rep Information",null,null,"Reviewing Rep Name",null,null,null,null,null,"Review Start Date",null,null,"Review End Date"]
[]
["Manager Information",null,null,"Reviewing Manager Name",null,null,null,null,null,"Review Start Date",null,null,"Review End Date"]
[]
["General Applicant Information",null,null,"Grantee Name",null,null,null,null,null,"Contract #"]
[null,null,null,{"$f":"'1-Narrative Summary'!F12","v":0},null,null,null,null,null,{"$f":"'1-Narrative Summary'!B12","v":0}]
[null,null,null,"Preparer Name and Title",null,null,null,null,null,"Preparer Contact Information"]
[null,null,null,{"$f":"'1-Narrative Summary'!B13","v":0},null,null,null,null,null,"Email:",{"$f":"'1-Narrative Summary'!B14","v":0},null,"Phone: ",{"$f":"'1-Narrative Summary'!F14","v":0}]
["General Review Questions:",null,null,"Response",null,"Comments",null,null,null,null,null,null,null,null,null,"Definitions:\n(For all definitions, refer to Guidelines §101)"]
["Are all required fillable form fields (yellow cells) filled out completely and accurately? ",null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,"Regional Housing Trust Fund:",null,null,"a Trust Fund serving two or more jurisdictions if the combined population is more than 1 million people; serving three or more jurisdictions in counties with total populations of 250,000 or less; and serving four or more jurisdictions in counties with total populations of more than 250,000"]
["Are there any cells that turned red that are unresolved? ",null,null,"Select One",null,null,null,null,null,null,null,null,null,null,null,"Local Housing Trust Fund:",null,null,"A public, joint public and private, or charitable nonprofit organization organized under Section 501©(3) of the Internal Revenue Code, which was established by legislation, ordinance, resolution, or a public-private partnership organized to receive specific public, or public and privatge, revenue to address local housing needs. The key characteristic of an LHTF is that it receies Ongoing Revenues from Dedicated Sources of funding sufficient to permit the LHTF to comply with the requirements of the Program."]
["Were any concerns raised from grantee's responses to narrative questions? ",null,null,"Select One"]
["Is this a Regional or a Local housing trust Fund?\n(Note: PLHA may only be used as match for Regional HTFs - §104 (b))",null,null,"Select One"]
["Have at least 40% of program funds been committed? (Cell I5 of Financial Summary. Note: At least 40% of Program Funds must be Committed before applying for future LHTF funding) ",null,null,"Select One"]
["Section 2 "]
["Financial Summary\nCells will turn red if Matching Requirements or Section 105 thresholds are not met. Each project must meet thresholds independently"]
["Project","LHTF Amount Committed",null,"Match Amount Committed","Dollar for Dollar Match Confirmed? \nGuidelines §104(e) ",null,"Program Funds Expended to Date, per Financial Summary",null,"Amount Expended and Previously Expended Confirmed by RFFs/Disbursement Tracker? \nRefer to Columns B and G on the Disbursement Tracker Summary sheet",null,"Amount Expended to date on ELI \nGuidelines §105(c) ","% Expended on ELI\nMust be at least 30% of expended funds","Amount Expended to date on LI \nGuidelines §105(e) ","% Expended on LI","Amount Expended to date on Mod\nGuidelines §105(d)","% Expended on Mod\nMust be no more than 20% of expended funds","Project Balance Remaining",null,"Does Supporting Documentation and/or amounts entered in this report reconcile with amounts recorded on Disbursement Tracker? ",null,"Comments"]
[{"$f":"'2-Financial Summary'!A9","v":"Project 1"},{"$f":"'2-Financial Summary'!E9","v":0},null,{"$f":"'2-Financial Summary'!F9","v":0},"Select One",null,{"$f":"'2-Financial Summary'!G9+'2-Financial Summary'!J9+'2-Financial Summary'!M9","v":0},null,"Select One",null,{"$f":"'2-Financial Summary'!G9","v":0},{"$f":"K25/G25","v":{"$error":"#DIV/0!"}},{"$f":"'2-Financial Summary'!J9","v":0},{"$f":"M25/G25","v":{"$error":"#DIV/0!"}},{"$f":"'2-Financial Summary'!M9","v":0},{"$f":"O25/G25","v":{"$error":"#DIV/0!"}},{"$f":"B25-G25","v":0},null,"Select One"]
[{"$f":"'2-Financial Summary'!A10","v":"Project 2"},{"$f":"'2-Financial Summary'!E10","v":0},null,{"$f":"'2-Financial Summary'!F10","v":0},"Select One",null,{"$f":"'2-Financial Summary'!G10+'2-Financial Summary'!J10+'2-Financial Summary'!M10","v":0},null,"Select One",null,{"$f":"'2-Financial Summary'!G10","v":0},{"$f":"K26/G26","v":{"$error":"#DIV/0!"}},{"$f":"'2-Financial Summary'!J10","v":0},{"$f":"M26/G26","v":{"$error":"#DIV/0!"}},{"$f":"'2-Financial Summary'!M10","v":0},{"$f":"O26/G26","v":{"$error":"#DIV/0!"}},{"$f":"B26-G26","v":0},null,"Select One"]
[{"$f":"'2-Financial Summary'!A11","v":"Project 3"},{"$f":"'2-Financial Summary'!E11","v":0},null,{"$f":"'2-Financial Summary'!F11","v":0},"Select One",null,{"$f":"'2-Financial Summary'!G11+'2-Financial Summary'!J11+'2-Financial Summary'!M11","v":0},null,"Select One",null,{"$f":"'2-Financial Summary'!G11","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!J11","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!M11","v":0},{"$error":"#DIV/0!"},0,null,"Select One"]
[{"$f":"'2-Financial Summary'!A12","v":"Project 4"},{"$f":"'2-Financial Summary'!E12","v":0},null,{"$f":"'2-Financial Summary'!F12","v":0},"Select One",null,{"$f":"'2-Financial Summary'!G12+'2-Financial Summary'!J12+'2-Financial Summary'!M12","v":0},null,"Select One",null,{"$f":"'2-Financial Summary'!G12","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!J12","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!M12","v":0},{"$error":"#DIV/0!"},0,null,"Select One"]
[{"$f":"'2-Financial Summary'!A13","v":"Project 5"},{"$f":"'2-Financial Summary'!E13","v":0},null,{"$f":"'2-Financial Summary'!F13","v":0},"Select One",null,{"$f":"'2-Financial Summary'!G13+'2-Financial Summary'!J13+'2-Financial Summary'!M13","v":0},null,"Select One",null,{"$f":"'2-Financial Summary'!G13","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!J13","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!M13","v":0},{"$error":"#DIV/0!"},0,null,"Select One"]
[{"$f":"'2-Financial Summary'!A14","v":"Project 6"},{"$f":"'2-Financial Summary'!E14","v":0},null,{"$f":"'2-Financial Summary'!F14","v":0},"Select One",null,{"$f":"'2-Financial Summary'!G14+'2-Financial Summary'!J14+'2-Financial Summary'!M14","v":0},null,"Select One",null,{"$f":"'2-Financial Summary'!G14","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!J14","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!M14","v":0},{"$error":"#DIV/0!"},0,null,"Select One"]
[{"$f":"'2-Financial Summary'!A15","v":"Project 7"},{"$f":"'2-Financial Summary'!E15","v":0},null,{"$f":"'2-Financial Summary'!F15","v":0},"Select One",null,{"$f":"'2-Financial Summary'!G15+'2-Financial Summary'!J15+'2-Financial Summary'!M15","v":0},null,"Select One",null,{"$f":"'2-Financial Summary'!G15","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!J15","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!M15","v":0},{"$error":"#DIV/0!"},0,null,"Select One"]
[{"$f":"'2-Financial Summary'!A16","v":"Project 8"},{"$f":"'2-Financial Summary'!E16","v":0},null,{"$f":"'2-Financial Summary'!F16","v":0},"Select One",null,{"$f":"'2-Financial Summary'!G16+'2-Financial Summary'!J16+'2-Financial Summary'!M16","v":0},null,"Select One",null,{"$f":"'2-Financial Summary'!G16","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!J16","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!M16","v":0},{"$error":"#DIV/0!"},0,null,"Select One"]
[{"$f":"'2-Financial Summary'!A17","v":"Project 9"},{"$f":"'2-Financial Summary'!E17","v":0},null,{"$f":"'2-Financial Summary'!F17","v":0},"Select One",null,{"$f":"'2-Financial Summary'!G17+'2-Financial Summary'!J17+'2-Financial Summary'!M17","v":0},null,"Select One",null,{"$f":"'2-Financial Summary'!G17","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!J17","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!M17","v":0},{"$error":"#DIV/0!"},0,null,"Select One"]
[{"$f":"'2-Financial Summary'!A18","v":"Project 10"},{"$f":"'2-Financial Summary'!E18","v":0},null,{"$f":"'2-Financial Summary'!F18","v":0},"Select One",null,{"$f":"'2-Financial Summary'!G18+'2-Financial Summary'!J18+'2-Financial Summary'!M18","v":0},null,"Select One",null,{"$f":"'2-Financial Summary'!G18","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!J18","v":0},{"$error":"#DIV/0!"},{"$f":"'2-Financial Summary'!M18","v":0},{"$error":"#DIV/0!"},0,null,"Select One"]
["Section 3 ",null,null,null,null,null,null,null,null,null,null,"Section 4"]
["Income Restrictions\nCells will turn yellow if Section 105 thresholds are not met. Projects not yet fully drawn down may balance out in future reporting periods.\nProjects completed in a previous reporting period will not appear in this section",null,null,null,null,null,null,null,null,null,null,"Matching Funds"]
["Activity #","Program Funds Spent This Report",null,"Amount Spent on ELI this Report","% Expended on ELI\nMust be at least 30% of expended funds","Amount Spent on LI this Report","% Expended on LI\nGuidelines §105(e) ","Amount Spent on Mod this report ","% Expended on Mod\nMust be no more than 20% of expended funds","Comments",null,"Matching Funds Expended this Report",null,"Type of Supporting documentation submitted?",null,"% Match from Non-Residential Sources\nMay Impact Score For Future Funding - See NOFA Page 4",null,"% Match from Residential Sources",null,"Comments"]
[{"$f":"'2-Financial Summary'!A9","v":"Project 1"},{"$f":"_xlfn.XLOOKUP($A38,INDIRECT(\"'\"&$A38&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A38&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A38,INDIRECT(\"'\"&$A38&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A38&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"D38/B38","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($A38,INDIRECT(\"'\"&$A38&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A38&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"F38/B38","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($A38,INDIRECT(\"'\"&$A38&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A38&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"H38/B38","v":{"$error":"#REF!"}},null,null,{"$f":"_xlfn.XLOOKUP($A38,INDIRECT(\"'\"&$A38&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A38&\"'!\"&\"$M$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xlfn.XLOOKUP($A38,INDIRECT(\"'\"&$A38&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A38&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A38,INDIRECT(\"'\"&$A38&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A38&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}}]
[{"$f":"'2-Financial Summary'!A10","v":"Project 2"},{"$f":"_xlfn.XLOOKUP($A39,INDIRECT(\"'\"&$A39&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A39&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A39,INDIRECT(\"'\"&$A39&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A39&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"D39/B39","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($A39,INDIRECT(\"'\"&$A39&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A39&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"F39/B39","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($A39,INDIRECT(\"'\"&$A39&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A39&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"H39/B39","v":{"$error":"#REF!"}},null,null,{"$f":"_xlfn.XLOOKUP($A39,INDIRECT(\"'\"&$A39&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A39&\"'!\"&\"$M$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xlfn.XLOOKUP($A39,INDIRECT(\"'\"&$A39&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A39&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A39,INDIRECT(\"'\"&$A39&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A39&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}}]
[{"$f":"'2-Financial Summary'!A11","v":"Project 3"},{"$f":"_xlfn.XLOOKUP($A40,INDIRECT(\"'\"&$A40&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A40&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A40,INDIRECT(\"'\"&$A40&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A40&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A40,INDIRECT(\"'\"&$A40&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A40&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A40,INDIRECT(\"'\"&$A40&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A40&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"_xlfn.XLOOKUP($A40,INDIRECT(\"'\"&$A40&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A40&\"'!\"&\"$M$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xlfn.XLOOKUP($A40,INDIRECT(\"'\"&$A40&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A40&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A40,INDIRECT(\"'\"&$A40&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A40&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}}]
[{"$f":"'2-Financial Summary'!A12","v":"Project 4"},{"$f":"_xlfn.XLOOKUP($A41,INDIRECT(\"'\"&$A41&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A41&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A41,INDIRECT(\"'\"&$A41&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A41&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A41,INDIRECT(\"'\"&$A41&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A41&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A41,INDIRECT(\"'\"&$A41&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A41&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"_xlfn.XLOOKUP($A41,INDIRECT(\"'\"&$A41&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A41&\"'!\"&\"$M$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xlfn.XLOOKUP($A41,INDIRECT(\"'\"&$A41&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A41&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A41,INDIRECT(\"'\"&$A41&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A41&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}}]
[{"$f":"'2-Financial Summary'!A13","v":"Project 5"},{"$f":"_xlfn.XLOOKUP($A42,INDIRECT(\"'\"&$A42&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A42&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A42,INDIRECT(\"'\"&$A42&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A42&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A42,INDIRECT(\"'\"&$A42&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A42&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A42,INDIRECT(\"'\"&$A42&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A42&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"_xlfn.XLOOKUP($A42,INDIRECT(\"'\"&$A42&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A42&\"'!\"&\"$M$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xlfn.XLOOKUP($A42,INDIRECT(\"'\"&$A42&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A42&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A42,INDIRECT(\"'\"&$A42&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A42&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}}]
[{"$f":"'2-Financial Summary'!A14","v":"Project 6"},{"$f":"_xlfn.XLOOKUP($A43,INDIRECT(\"'\"&$A43&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A43&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A43,INDIRECT(\"'\"&$A43&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A43&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A43,INDIRECT(\"'\"&$A43&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A43&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A43,INDIRECT(\"'\"&$A43&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A43&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"_xlfn.XLOOKUP($A43,INDIRECT(\"'\"&$A43&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A43&\"'!\"&\"$M$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xlfn.XLOOKUP($A43,INDIRECT(\"'\"&$A43&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A43&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A43,INDIRECT(\"'\"&$A43&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A43&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}}]
[{"$f":"'2-Financial Summary'!A15","v":"Project 7"},{"$f":"_xlfn.XLOOKUP($A44,INDIRECT(\"'\"&$A44&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A44&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A44,INDIRECT(\"'\"&$A44&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A44&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A44,INDIRECT(\"'\"&$A44&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A44&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A44,INDIRECT(\"'\"&$A44&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A44&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"_xlfn.XLOOKUP($A44,INDIRECT(\"'\"&$A44&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A44&\"'!\"&\"$M$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xlfn.XLOOKUP($A44,INDIRECT(\"'\"&$A44&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A44&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A44,INDIRECT(\"'\"&$A44&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A44&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}}]
[{"$f":"'2-Financial Summary'!A16","v":"Project 8"},{"$f":"_xlfn.XLOOKUP($A45,INDIRECT(\"'\"&$A45&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A45&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A45,INDIRECT(\"'\"&$A45&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A45&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A45,INDIRECT(\"'\"&$A45&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A45&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A45,INDIRECT(\"'\"&$A45&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A45&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"_xlfn.XLOOKUP($A45,INDIRECT(\"'\"&$A45&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A45&\"'!\"&\"$M$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xlfn.XLOOKUP($A45,INDIRECT(\"'\"&$A45&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A45&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A45,INDIRECT(\"'\"&$A45&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A45&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}}]
[{"$f":"'2-Financial Summary'!A17","v":"Project 9"},{"$f":"_xlfn.XLOOKUP($A46,INDIRECT(\"'\"&$A46&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A46&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A46,INDIRECT(\"'\"&$A46&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A46&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A46,INDIRECT(\"'\"&$A46&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A46&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"F46/B46","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($A46,INDIRECT(\"'\"&$A46&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A46&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"H46/B46","v":{"$error":"#REF!"}},null,null,{"$f":"_xlfn.XLOOKUP($A46,INDIRECT(\"'\"&$A46&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A46&\"'!\"&\"$M$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xlfn.XLOOKUP($A46,INDIRECT(\"'\"&$A46&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A46&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A46,INDIRECT(\"'\"&$A46&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A46&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}}]
[{"$f":"'2-Financial Summary'!A18","v":"Project 10"},{"$f":"_xlfn.XLOOKUP($A47,INDIRECT(\"'\"&$A47&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A47&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A47,INDIRECT(\"'\"&$A47&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A47&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A47,INDIRECT(\"'\"&$A47&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A47&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($A47,INDIRECT(\"'\"&$A47&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A47&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,null,{"$f":"_xlfn.XLOOKUP($A47,INDIRECT(\"'\"&$A47&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A47&\"'!\"&\"$M$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"_xlfn.XLOOKUP($A47,INDIRECT(\"'\"&$A47&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A47&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A47,INDIRECT(\"'\"&$A47&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A47&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}}]
["Section 5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Section 6"]
["Other Project Details\nNote: Project Details Tabs must be completed for information to show in this section",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Optional: Rep and Manager Review Notes"]
["Project","Loan Status\nIf project is \"Closed\" AND reported 'Closed' on last year's Annual Report, no other Project Details should populate.",null,"Project Type \nper Section 101 (g) ",null,"Project Category",null,"Project Status",null,"Project Activity",null,"Project Completion Date (if applicable)",null,"Was Appropriate Documentation Certifying Completion Submitted?",null,"Date",null,"Issue",null,"Action Taken",null,null,null,"Status \n(resolved, awaiting grantee response, awaiting manager input, etc)"]
[0,0,null,0,null,{"$f":"_xlfn.XLOOKUP($A51,INDIRECT(\"'\"&$A51&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A51&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A51,INDIRECT(\"'\"&$A51&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A51&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A51,INDIRECT(\"'\"&$A51&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A51&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A51,INDIRECT(\"'\"&$A51&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A51&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,"Select One"]
[0,0,null,0,null,{"$f":"_xlfn.XLOOKUP($A52,INDIRECT(\"'\"&$A52&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A52&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A52,INDIRECT(\"'\"&$A52&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A52&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A52,INDIRECT(\"'\"&$A52&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A52&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A52,INDIRECT(\"'\"&$A52&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A52&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,"Select One"]
[0,0,null,0,null,{"$f":"_xlfn.XLOOKUP($A53,INDIRECT(\"'\"&$A53&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A53&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A53,INDIRECT(\"'\"&$A53&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A53&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A53,INDIRECT(\"'\"&$A53&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A53&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A53,INDIRECT(\"'\"&$A53&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A53&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,"Select One"]
[0,0,null,0,null,{"$f":"_xlfn.XLOOKUP($A54,INDIRECT(\"'\"&$A54&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A54&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A54,INDIRECT(\"'\"&$A54&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A54&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A54,INDIRECT(\"'\"&$A54&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A54&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A54,INDIRECT(\"'\"&$A54&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A54&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,"Select One"]
[0,0,null,0,null,{"$f":"_xlfn.XLOOKUP($A55,INDIRECT(\"'\"&$A55&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A55&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A55,INDIRECT(\"'\"&$A55&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A55&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A55,INDIRECT(\"'\"&$A55&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A55&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A55,INDIRECT(\"'\"&$A55&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A55&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,"Select One"]
[0,0,null,0,null,{"$f":"_xlfn.XLOOKUP($A56,INDIRECT(\"'\"&$A56&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A56&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A56,INDIRECT(\"'\"&$A56&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A56&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A56,INDIRECT(\"'\"&$A56&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A56&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A56,INDIRECT(\"'\"&$A56&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A56&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,"Select One"]
[0,0,null,0,null,{"$f":"_xlfn.XLOOKUP($A57,INDIRECT(\"'\"&$A57&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A57&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A57,INDIRECT(\"'\"&$A57&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A57&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A57,INDIRECT(\"'\"&$A57&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A57&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A57,INDIRECT(\"'\"&$A57&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A57&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,"Select One"]
[0,0,null,0,null,{"$f":"_xlfn.XLOOKUP($A58,INDIRECT(\"'\"&$A58&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A58&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A58,INDIRECT(\"'\"&$A58&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A58&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A58,INDIRECT(\"'\"&$A58&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A58&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A58,INDIRECT(\"'\"&$A58&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A58&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,"Select One"]
[0,0,null,0,null,{"$f":"_xlfn.XLOOKUP($A59,INDIRECT(\"'\"&$A59&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A59&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A59,INDIRECT(\"'\"&$A59&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A59&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A59,INDIRECT(\"'\"&$A59&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A59&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A59,INDIRECT(\"'\"&$A59&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A59&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,"Select One"]
[0,0,null,0,null,{"$f":"_xlfn.XLOOKUP($A60,INDIRECT(\"'\"&$A60&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A60&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A60,INDIRECT(\"'\"&$A60&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A60&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A60,INDIRECT(\"'\"&$A60&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A60&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},null,{"$f":"_xlfn.XLOOKUP($A60,INDIRECT(\"'\"&$A60&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$A60&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},null,"Select One"]

{"sheet":"Project Data","index":6,"n_rows":11,"n_cols":47,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Grantee Name","HCD Contract ","HCD Rep","Project Name","Address","Developer","Project Type","Project Category","Project Activity","Project Status","Date of Completion","Date Affordability Covenant Begins","Date of Affordability Covenant Expiration","Expended this Reporting Period","Total Units","ELI Units","Expended on ELI this Report","LI Units","Expended on LI this Report","Mod Units","Expended on Mod Units this Report","# SF Homes","# Emergency Shelters","# Studios","#1 BR","# 2BR","# 3BR","# 4 BR","Non Residential Match Expended this Period","%Non Residential Match Total\nSee NOFA pg 4","Residential Match Expended this Period","%Residential Match Total","Type of Loan","Loan Status","LHTF Funds Committed Project","LHTF Funds Committed Admin","Beginning Amount of Matching Funds On Deposit - PROJECT","Matching Funds on Deposit - ADMIN","Total Program Funds spent on ELI","Total Matching Funds spent on ELI","% All Funds Expended on ELI","Total Program Funds spent on LI","Total Matching Funds spent on LI","% All Funds Spent on LI","Total Program Funds spent on Mod","Total Matching Funds spent on Mod","%All funds spent on Mod"]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'5-Summary Sheet'!$D$9","v":0},{"$f":"'2-Financial Summary'!$A9","v":"Project 1"},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$E$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$C$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,2,FALSE)","v":"Select One"},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$C$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$E$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"SUM(P2+R2+T2)","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$7\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$8\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$K$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$K$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D2,INDIRECT(\"'\"&$D2&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D2&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,3,FALSE)","v":"Select One"},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,4,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,5,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,6,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,7,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,8,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,9,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,10,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,11,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,12,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,13,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$O$19,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$P$19,15,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$P$19,16,FALSE)","v":0},{"$f":"VLOOKUP($D2,'2-Financial Summary'!$A$7:$Q$19,17,FALSE)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'5-Summary Sheet'!$D$9","v":0},{"$f":"'2-Financial Summary'!$A10","v":"Project 2"},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$E$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$C$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,2,FALSE)","v":"Select One"},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$C$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$E$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"SUM(P3+R3+T3)","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$7\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$8\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$K$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$K$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D3,INDIRECT(\"'\"&$D3&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D3&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,3,FALSE)","v":"Select One"},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,4,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,5,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,6,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,7,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,8,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,9,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,10,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,11,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,12,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,13,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$O$19,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$P$19,15,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$P$19,16,FALSE)","v":0},{"$f":"VLOOKUP($D3,'2-Financial Summary'!$A$7:$Q$19,17,FALSE)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'5-Summary Sheet'!$D$9","v":0},{"$f":"'2-Financial Summary'!$A11","v":"Project 3"},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$E$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$C$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,2,FALSE)","v":"Select One"},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$C$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$E$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$7\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$8\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$K$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$K$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D4,INDIRECT(\"'\"&$D4&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D4&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,3,FALSE)","v":"Select One"},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,4,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,5,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,6,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,7,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,8,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,9,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,10,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,11,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,12,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,13,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$O$19,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$P$19,15,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$P$19,16,FALSE)","v":0},{"$f":"VLOOKUP($D4,'2-Financial Summary'!$A$7:$Q$19,17,FALSE)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'5-Summary Sheet'!$D$9","v":0},{"$f":"'2-Financial Summary'!$A12","v":"Project 4"},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$E$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$C$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,2,FALSE)","v":"Select One"},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$C$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$E$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$7\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$8\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$K$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$K$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D5,INDIRECT(\"'\"&$D5&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D5&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,3,FALSE)","v":"Select One"},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,4,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,5,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,6,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,7,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,8,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,9,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,10,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,11,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,12,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,13,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$O$19,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$P$19,15,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$P$19,16,FALSE)","v":0},{"$f":"VLOOKUP($D5,'2-Financial Summary'!$A$7:$Q$19,17,FALSE)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'5-Summary Sheet'!$D$9","v":0},{"$f":"'2-Financial Summary'!$A13","v":"Project 5"},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$E$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$C$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,2,FALSE)","v":"Select One"},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$C$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$E$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$7\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$8\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$K$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$K$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D6,INDIRECT(\"'\"&$D6&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D6&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,3,FALSE)","v":"Select One"},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,4,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,5,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,6,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,7,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,8,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,9,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,10,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,11,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,12,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,13,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$O$19,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$P$19,15,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$P$19,16,FALSE)","v":0},{"$f":"VLOOKUP($D6,'2-Financial Summary'!$A$7:$Q$19,17,FALSE)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'5-Summary Sheet'!$D$9","v":0},{"$f":"'2-Financial Summary'!$A14","v":"Project 6"},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$E$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$C$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,2,FALSE)","v":"Select One"},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$C$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$E$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$7\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$8\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$K$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$K$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D7,INDIRECT(\"'\"&$D7&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D7&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,3,FALSE)","v":"Select One"},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,4,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,5,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,6,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,7,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,8,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,9,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,10,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,11,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,12,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,13,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$O$19,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$P$19,15,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$P$19,16,FALSE)","v":0},{"$f":"VLOOKUP($D7,'2-Financial Summary'!$A$7:$Q$19,17,FALSE)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'5-Summary Sheet'!$D$9","v":0},{"$f":"'2-Financial Summary'!$A15","v":"Project 7"},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$E$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$C$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,2,FALSE)","v":"Select One"},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$C$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$E$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$7\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$8\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$K$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$K$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D8,INDIRECT(\"'\"&$D8&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D8&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,3,FALSE)","v":"Select One"},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,4,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,5,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,6,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,7,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,8,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,9,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,10,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,11,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,12,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,13,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$O$19,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$P$19,15,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$P$19,16,FALSE)","v":0},{"$f":"VLOOKUP($D8,'2-Financial Summary'!$A$7:$Q$19,17,FALSE)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'5-Summary Sheet'!$D$9","v":0},{"$f":"'2-Financial Summary'!$A16","v":"Project 8"},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$E$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$C$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,2,FALSE)","v":"Select One"},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$C$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$E$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$7\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$8\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$K$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$K$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D9,INDIRECT(\"'\"&$D9&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D9&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,3,FALSE)","v":"Select One"},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,4,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,5,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,6,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,7,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,8,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,9,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,10,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,11,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,12,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,13,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$O$19,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$P$19,15,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$P$19,16,FALSE)","v":0},{"$f":"VLOOKUP($D9,'2-Financial Summary'!$A$7:$Q$19,17,FALSE)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'5-Summary Sheet'!$D$9","v":0},{"$f":"'2-Financial Summary'!$A17","v":"Project 9"},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$E$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$C$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,2,FALSE)","v":"Select One"},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$C$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$E$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$7\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$8\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$K$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$K$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D10,INDIRECT(\"'\"&$D10&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D10&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,3,FALSE)","v":"Select One"},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,4,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,5,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,6,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,7,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,8,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,9,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,10,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,11,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,12,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,13,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$O$19,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$P$19,15,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$P$19,16,FALSE)","v":0},{"$f":"VLOOKUP($D10,'2-Financial Summary'!$A$7:$Q$19,17,FALSE)","v":{"$error":"#DIV/0!"}}]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'5-Summary Sheet'!$D$9","v":0},{"$f":"'2-Financial Summary'!$A18","v":"Project 10"},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$E$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$C$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,2,FALSE)","v":"Select One"},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$C$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$E$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$C$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$E$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$C$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$E$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D12,INDIRECT(\"'\"&$D12&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D12&\"'!\"&\"$K$14\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$K$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$K$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$K$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$7\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$8\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$9\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$10\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$11\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$12\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$13\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$K$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$1\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$K$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"_xlfn.XLOOKUP($D11,INDIRECT(\"'\"&$D11&\"'!\"&\"$C$9\"),INDIRECT(\"'\"&$D11&\"'!\"&\"$J$2\"),\"Not Found\")","v":{"$error":"#REF!"}},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,3,FALSE)","v":"Select One"},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,4,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,5,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,6,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,7,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,8,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,9,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,10,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,11,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,12,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,13,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$O$19,14,FALSE)","v":{"$error":"#DIV/0!"}},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$P$19,15,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$P$19,16,FALSE)","v":0},{"$f":"VLOOKUP($D11,'2-Financial Summary'!$A$7:$Q$19,17,FALSE)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Grantee Data","index":7,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Grantee Name","HCD Contract ","Total LHTF Award","Match on Deposit","LHTF Expended to Date","Admin Expended to Date","PI generated this period","Total PI Balance","Appx. Households Assisted w PI","Reporting Period","1. Please summarize the activities planned to be undertaken in the next reporting period","2. Please describe any problems encountered in Program implementation.  Include a description of the solution and when it will be implemented","3. Please describe how the problems described in question #3 above may impact the ability to complete or fulfill obligations under the Standard Agreement","4. Please describe additional revenue generated from program funding (e.g. loan repayments, interest, fees) in this reporting period","5. Please describe your public noticing and hearing process. Attach required documentation of the website posting and any relevant records of the public hearing","6. Optional: Please share any success stories you've had from LHTF-funded projects."]
[{"$f":"'1-Narrative Summary'!$F$12","v":0},{"$f":"'1-Narrative Summary'!$B$12","v":0},{"$f":"'2-Financial Summary'!A5","v":0},{"$f":"'2-Financial Summary'!J5","v":0},{"$f":"'2-Financial Summary'!E5","v":0},{"$f":"'2-Financial Summary'!C5","v":0},{"$f":"'1-Narrative Summary'!C62","v":0},{"$f":"'1-Narrative Summary'!C63","v":0},{"$f":"'1-Narrative Summary'!G62","v":0},{"$f":"'1-Narrative Summary'!F14","v":0},{"$f":"'1-Narrative Summary'!A18","v":0},{"$f":"'1-Narrative Summary'!A31","v":0},{"$f":"'1-Narrative Summary'!A46","v":0},{"$f":"'1-Narrative Summary'!A61","v":0},{"$f":"'1-Narrative Summary'!A65","v":0},{"$f":"'1-Narrative Summary'!A80","v":0}]

{"sheet":"Drop Down Box","index":8,"n_rows":75,"n_cols":2,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
["Reporting Period Due Date"]
["July 1, 2020- June 30, 2021, Due July 31, 2021"]
["July 1, 2021- June 30, 2022, Due July 31, 2022"]
["July 1, 2022- June 30, 2023, Due July 31, 2023"]
["July 1, 2023- June 30, 2024, Due July 31, 2024"]
["July 1, 2024- June 30, 2025, Due July 31, 2025"]
[]
["Number of Bedrooms"]
["Select One"]
["Single Family Residence"]
["Emergency Shelter"]
["Studio"]
["One-bedroom"]
["Two-bedroom"]
["Three-bedroom"]
["Four-bedroom"]
[]
["Restricted Income Level"]
["Select One"]
["Extremely Low Income (max 30% AMI)"]
["Lower Income (30%-80%AMI)"]
["Moderate Income"]
[]
["Documentation Attached of Matching Funds, including amount by source"]
["Yes"]
["No"]
[]
["Project Type"]
["Select One"]
["Rental Housing Projects including Permanent Supportive Housing"]
["Emergency Shelter or Transitional Housing"]
["Homeownership Projects"]
["ADU/JADU"]
[]
["Project Status"]
["Select One"]
["Trust Fund Loan Committed"]
["Under Construction"]
["Construction Completed"]
["Permanent Loan Closed"]
[]
["Type of Loan"]
["Select One"]
["Construction Loan"]
["Permanent Financing Loan"]
["Both Const/Perm"]
[]
[]
["Activity","Evidence of Completion"]
["Select One"," "]
["New Construction","Certificate of Occupancy "]
["Rehabilitation","Certificate of Completion"]
["Conversion","Certificate of Completion"]
["Repair","Certificate of Completion"]
["Reconstruction","Certificate of Completion"]
["Purchase","Recorded Deed of Trust"]
[null," "]
["Match Source"]
["Select One"]
["Residential Impact Fees"]
["Residential In-Lieu Fees"]
["Commercial Impact Fees"]
["Commercial In-lieu Fees"]
["Special Taxes (i.e. Hotel tax)"]
["General Obligation Bond"]
["Public General Fund Contribution"]
["Private Donation"]
["Repayments of HTF Loans"]
["Permanent Local Housing Allocation (PLHA)"]
["Proof of Completion"]
["Certificate of Occupancy"]
["Certificate of Completion"]
["Recorded Deed of Trust"]
["Recorded Regulatory Agreement"]
["Other Evidence of Completion"]