{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Affordable Units","Rental Budget","Median Costs & Relocation","Pro Forma","Amortization Table","Program","Dev Budget","Program Summary","Verifications"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":1,"comments":1,"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":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[[17,2,17,6],[16,2,16,6],[1,0,1,8],[4,0,4,8],[13,2,13,6],[14,2,14,6],[15,2,15,6],[2,0,2,8],[11,0,11,7]]}
[]
["Exhibit D - EEHDP Excel Template"]
["Introduction to the Workbook"]
["INSTRUCTIONS"]
["This document serves as the Excel portion of the East End Housing Development Program application for both rental and for-sale projects. Fill out the information in the \"Basic Project Information\" section below, then click \"Run\"."]
[]
["Throughout the workbook, please adhere to the following cell color prompts:"]
[]
[null,null,null,"Blue - empty cell to be filled in"]
[null,null,null,"Yellow - formula cell that will autopopulate; do not change"]
[]
["Note: Macros in Excel must be enabled to properly use this workbook. If presented with a \"SECURITY WARNING\" at the top of this screen, click \"Enable Content\""]
["BASIC PROJECT INFORMATION"]
["Date",null,"2021-01-06"]
["Project Name",null,"Project A"]
["Developer/Sponsor",null,"Apex Developers"]
["Select Project Type",null,"For-Sale"]
["Total Project Units",null,6]

{"sheet":"Affordable Units","index":1,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":true,"merged":[[18,0,18,7],[19,0,19,7],[21,0,21,7],[11,0,11,6],[12,0,12,6],[13,0,13,6],[16,0,16,7],[17,0,17,6],[20,0,20,7],[10,0,10,6],[4,0,4,7],[7,0,7,6],[8,0,8,7],[9,0,9,6]]}
[]
["PROJECT NAME",{"$f":"[1]Instructions!$C$15","v":"Project A"}]
["DEVELOPER/SPONSOR",{"$f":"[1]Instructions!$C$17","v":"Apex Developers"}]
[]
["Minimum Affordable Unit Verification - Rental"]
[]
["Verification (MANDATORY)",null,null,null,null,null,null,{"$f":"IF(H13=\"No\",\"Original Proposal\",\"\")","v":""}]
["Total Number of Units (Affordable and Market-Rate)",null,null,null,null,null,null,{"$f":"Instructions!C18","v":6}]
[]
["Proposed Number of Units Affordable to 50% AMI",null,null,null,null,null,null,5]
["Total Number of Affordable Units",null,null,null,null,null,null,{"$f":"SUM(H10:H10)","v":5}]
[]
["MINIMUM REQUIREMENT MET?",null,null,null,null,null,null,{"$f":"_xlfn.SWITCH(TRUE(),AND(H8<20,H10>=ROUND(0.5*H8,0)),\"YES\",AND(H8>=20,H8<=47,H10>=10),\"YES\",AND(H8>=48,H10>=ROUND(0.2*H8,0)),\"YES\",\"NO\")","v":"YES"}]
[]
[]
[]
[{"$f":"IF(H13=\"No\",\"Calculation (for use if original proposal does not meet requiremet)\",\"\")","v":""}]
[]
[{"$f":"IF(H13=\"No\",\"Based on your project size,\",\"\")","v":""}]
[{"$f":"IF(AND(H8>47,H13=\"NO\"),CONCATENATE(\"Total Number of Units Affordable to Households at or Below 50% AMI Must Be At Least \",ROUND(0.2*H8,0)),\"\")","v":""}]
[{"$f":"IF((AND(H8>=20,H8<=47, H13=\"No\")), \"Total Number of Units Affordable to Households at or Below 50% AMI Must Be At Least 10\", \" \")","v":" "}]
[{"$f":"IF(AND(H8<=19,H13=\"NO\"),CONCATENATE(\"Total Number of Units Affordable to Households at or Below 50% AMI Must Be At Least \",ROUND(0.5*H8,0)),\"\")","v":""}]

{"sheet":"Rental Budget","index":2,"n_rows":146,"n_cols":9,"rows_kept":146,"cut":false,"hidden":true,"merged":[[141,1,141,3],[142,1,142,3],[115,1,115,3],[126,1,126,3],[127,1,127,3],[128,1,128,3],[129,1,129,3],[140,1,140,3],[114,1,114,3],[74,1,74,3],[85,1,85,3],[86,1,86,3],[87,1,87,3],[88,1,88,3],[100,1,100,3],[101,1,101,3],[102,1,102,3],[103,1,103,3],[112,1,112,3],[113,1,113,3],[73,1,73,3],[1,2,1,8],[2,2,2,8],[4,0,4,8],[5,0,5,8],[50,1,50,3],[51,1,51,3],[52,1,52,3],[53,1,53,3],[54,2,54,3],[69,1,69,3],[72,1,72,3]]}
[]
["PROJECT NAME",null,{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"}]
["DEVELOPER/SPONSOR",null,{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"}]
[]
["Rental Development Budget with"]
["Permanent Sources"]
[]
[]
["Total Units",null,{"$f":"Instructions!C18","v":6}]
["Total Square Feet",null,10000]
[]
[null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft"]
["Committed Sources of Funds",null,null,"Detail"]
["Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(G14/$C$9,\"\")","v":0},{"$f":"IFERROR(G14/$C$10,\"\")","v":0}]
["Permanent Financing - 2nd Lien",null,null,null,null,null,null,0,0]
["Equity (LIHTC)",null,null,null,null,null,null,0,0]
["Equity (Developer)",null,null,null,null,null,null,0,0]
["Deferred development fee",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other: ",null,null,null,null,null,null,0,0]
["Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(G14:G22)","v":0},{"$f":"SUM(H14:H22)","v":0},{"$f":"SUM(I14:I22)","v":0}]
[]
["Pending/Proposed Sources of Funds",null,null,"Detail"]
["RACP",null,null,null,null,null,null,{"$f":"IFERROR(G26/$C$9,\"\")","v":0},{"$f":"IFERROR(G26/$C$10,\"\")","v":0}]
["FHLB",null,null,null,null,null,null,0,0]
["PHARE",null,null,null,null,null,null,0,0]
["EEHDP Request",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(G26:G33)","v":0},{"$f":"SUM(H26:H33)","v":0},{"$f":"SUM(I26:I33)","v":0}]
[]
["Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(G34,G23)","v":0},{"$f":"SUM(H34,H23)","v":0},{"$f":"SUM(I34,I23)","v":0}]
[]
["Uses of Funds"]
[]
["Hard Costs",null,null,"Detail"]
["General Requirements",null,null,null,null,{"$f":"IFERROR(G41/SUM($G$42:$G$46),\"\")","v":""},null,{"$f":"IFERROR(G41/$C$9,\"\")","v":0},{"$f":"IFERROR(G41/$C$10,\"\")","v":0}]
["Demolition",null,null,null,null,null,null,0,0]
["Site Work",null,null,null,null,null,null,0,0]
["Offsite Improvements",null,null,null,null,null,null,0,0]
["Environmental Remediation",null,null,null,null,null,null,0,0]
["Construction",null,null,null,null,null,null,0,0]
["Builder's Overhead",null,null,null,null,{"$f":"IFERROR(G47/SUM($G$42:$G$46),\"\")","v":""},null,0,0]
["Builder's Profit",null,null,null,null,{"$f":"IFERROR(G48/SUM($G$42:$G$46),\"\")","v":""},null,0,0]
["Bond Premium",null,null,null,null,null,null,0,0]
["Building Permits",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other: ",null,null,null,null,null,null,0,0]
["Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(G55/SUM(G41:G54),\"\")","v":""},null,0,0]
["Total Hard Costs",null,null,null,null,null,{"$f":"SUM(G41:G55)","v":0},{"$f":"SUM(H41:H55)","v":0},{"$f":"SUM(I41:I55)","v":0}]
[]
["Fees",null,null,"Detail"]
["Architectural Fee (Design & Admin)",null,null,null,null,null,null,{"$f":"IFERROR(G59/$C$9,\"\")","v":0},{"$f":"IFERROR(G59/$C$10,\"\")","v":0}]
["Legal",null,null,null,null,null,null,0,0]
["   Civil Engineering & Survey",null,null,null,null,null,null,0,0]
["Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((G61)/SUM(G41:G48),\"\")","v":""},null,0,0]
["Soils/Structural Report",null,null,null,null,null,null,0,0]
["Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,0,0]
["Energy & Green Audits/Consulting",null,null,null,null,null,null,0,0]
["Capital Needs Assessment",null,null,null,null,null,null,0,0]
["Appraisal",null,null,null,null,null,null,0,0]
["Market Study",null,null,null,null,null,null,0,0]
["Cost Certification ",null,null,null,null,null,null,0,0]
["Part 58 Legal Posting","if federal funds are used $1300",null,null,null,null,null,0,0]
["EEHDP Origination Fee (2%)",null,null,null,null,null,{"$f":"0.02*G29","v":0},0,0]
["URA Inspection Fee","$500/unit, max $15,000",null,null,null,null,{"$f":"IF(C9>=30,15000,(500*C9))","v":3000},500,0.3]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other: ",null,null,null,null,null,null,0,0]
["Total Fees",null,null,null,null,null,{"$f":"SUM(G59:G75)","v":3000},{"$f":"SUM(H59:H75)","v":500},{"$f":"SUM(I59:I75)","v":0.3}]
[]
["Miscellaneous Development Expenses",null,null,"Detail"]
["PHFA Application & Legal Fees",null,null,null,null,null,null,{"$f":"IFERROR(G79/$C$9,\"\")","v":0},{"$f":"IFERROR(G79/$C$10,\"\")","v":0}]
["Tax Credit Reservation/Carryover Allocation/Cost Certification Fee",null,null,null,null,null,null,0,0]
["Furnishings (Common Area)",null,null,null,null,null,null,0,0]
["Rent Up Expense",null,null,null,null,null,null,0,0]
["Relocation",null,null,null,null,null,null,0,0]
["Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,0,0]
["Susidy Layering Review Fee",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other: ",null,null,null,null,null,null,0,0]
["Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(G79:G89)","v":0},{"$f":"SUM(H79:H89)","v":0},{"$f":"SUM(I79:I89)","v":0}]
[]
["Construction & Permanent Loan Financing Charges",null,null,"Detail"]
["Construction Loan Interest",null,null,null,null,"month const. period)",null,{"$f":"IFERROR(G93/$C$9,\"\")","v":0},{"$f":"IFERROR(G93/$C$10,\"\")","v":0}]
["Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,0,0]
["Taxes During Construction",null,null,null,null,null,null,0,0]
["Insurance During Construction",null,null,null,null,null,null,0,0]
["Title Insurance",null,null,null,null,null,null,0,0]
["Recording",null,null,null,null,null,null,0,0]
["Construction Monitoring Fee",null,null,null,null,null,null,0,0]
["Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other: ",null,null,null,null,null,null,0,0]
["Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(G105/(G76+G90+SUM(G93:G104)+G144),\"\")","v":0},null,0,0]
["Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(G93:G105)","v":0},{"$f":"SUM(H92:H105)","v":0},{"$f":"SUM(I90:I105)","v":0}]
[]
["Acquisition",null,null,"Detail"]
["Acquisition: Land",null,null,null,null,null,null,{"$f":"IFERROR(G109/$C$9,\"\")","v":0},{"$f":"IFERROR(G109/$C$10,\"\")","v":0}]
["Acquisition: Existing Structures",null,null,null,null,null,null,0,0]
["Acquisition: Legal",null,null,null,null,null,null,0,0]
["Acquisition Closing Costs",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other: ",null,null,null,null,null,null,0,0]
["Total Acquisition",null,null,null,null,null,{"$f":"SUM(G109:G116)","v":0},{"$f":"SUM(H109:H116)","v":0},{"$f":"SUM(I109:I116)","v":0}]
[]
["Reserves and Developer Fee",null,null,"Detail"]
["Operating Reserve",null,null,null,null,null,null,{"$f":"IFERROR(G120/$C$9,\"\")","v":0},{"$f":"IFERROR(G120/$C$10,\"\")","v":0}]
["Prefunded Replacement Reserve",null,null,null,null,null,null,0,0]
["Rental Subsidy Fund",null,null,null,null,null,null,0,0]
["Other Reserves (Transformation, Development Contingency)",null,null,null,null,null,null,0,0]
["Taxes & Insurance Escrow (first year operations escrow)",null,null,null,null,null,null,0,0]
["Supportive Services Escrow",null,null,null,null,null,null,0,0]
["Developer Fee ",null,null,null,null,{"$f":"IFERROR(G126/(G146-G131),\"\")","v":0},null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other:",null,null,null,null,null,null,0,0]
["Other: ",null,null,null,null,null,null,0,0]
["Total Reserves and Developer Fee",null,null,null,null,null,{"$f":"SUM(G120:G130)","v":0},{"$f":"SUM(H120:H130)","v":0},{"$f":"SUM(I120:I130)","v":0}]
[]
["Syndication Fees & Expenses (tax credit projects only)",null,null,"Detail"]
["Organizational",null,null,null,null,null,null,{"$f":"IFERROR(G134/$C$9,\"\")","v":0},{"$f":"IFERROR(G134/$C$10,\"\")","v":0}]
["Bridge Loan Interest",null,null,null,null,null,null,0,0]
["Bridge Loan Fees & Expenses",null,null,null,null,null,null,0,0]
["Legal Fees",null,null,null,null,null,null,0,0]
["Accountant's Fees",null,null,null,null,null,null,0,0]
["Tax Credit Compliance & Asset Monitoring Fee",null,null,null,null,null,null,0,0]
["Other Compliance & Monitoring Fees",null,null,null,null,null,null,0,0]
["Other: ",null,null,null,null,null,null,0,0]
["Other: ",null,null,null,null,null,null,0,0]
["Other: ",null,null,null,null,null,null,0,0]
["Total Syndication Fees & Expenses",null,null,null,null,null,{"$f":"SUM(G132:G143)","v":0},{"$f":"SUM(H132:H143)","v":0},{"$f":"SUM(I132:I143)","v":0}]
[]
["Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(G56,G76,G90,G106,G117,G131,G144)","v":3000},{"$f":"SUM(H56,H76,H90,H106,H117,H131,H144)","v":500},{"$f":"SUM(I56,I76,I90,I106,I117,I131,I144)","v":0.3}]

{"sheet":"Median Costs & Relocation","index":3,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":true,"merged":[[1,2,1,8],[2,2,2,8],[4,0,4,7],[17,0,17,7]]}
[]
["PROJECT NAME",null,{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"}]
["DEVELOPER/SPONSOR",null,{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"}]
[]
["Comparison with PHFA Median Costs"]
[]
[]
["Calculated Project Cost/SF",null,null,null,null,{"$f":"'Rental Budget'!G146/'Rental Budget'!C10","v":0.3}]
[]
[]
["Application Property Type",null,null,"Pennsylvania Median Cost/SF","Over or Under?","Mark Most Relevant Property Type(s) with \"X\""]
["Single Family/Townhouse",null,null,208,{"$f":"IF($F$8>D12,\"Over\",IF($F$8=D12,\"Equal\",IF($F$8<D12,\"Under\",\"\")))","v":"Under"}]
["Multi-Story Elevator Building",null,null,254,{"$f":"IF($F$8>D13,\"Over\",IF($F$8=D13,\"Equal\",IF($F$8<D13,\"Under\",\"\")))","v":"Under"}]
["Adaptive Reuse Building",null,null,214,{"$f":"IF($F$8>D14,\"Over\",IF($F$8=D14,\"Equal\",IF($F$8<D14,\"Under\",\"\")))","v":"Under"}]
["Preservation",null,null,119,{"$f":"IF($F$8>D15,\"Over\",IF($F$8=D15,\"Equal\",IF($F$8<D15,\"Under\",\"\")))","v":"Under"}]
["Pittsburgh",null,null,292.5,{"$f":"IF($F$8>D16,\"Over\",IF($F$8=D16,\"Equal\",IF($F$8<D16,\"Under\",\"\")))","v":"Under"}]
[]
["Temporary Relocation Budget"]
[]
[]
["Number of Units to be Relocated:"]
["Duration of Household Relocation, in months:"]
[]
[null,null,null,null,null,null,"Total Costs","Per Unit","Per Unit Per Month"]
["Relocation Expenses",null,null,null,"Details:"]
["Moving Contractor",null,null,null,null,null,null,{"$f":"IFERROR(G26/$F$21,\"\")","v":""}]
["Moving Supplies (if not included above)",null,null,null,null,null,null,""]
["Temporary Storage",null,null,null,null,null,null,"",{"$f":"IFERROR(G28/$F$22,\"\")","v":""}]
["Temporary Housing",null,null,null,null,null,null,"",{"$f":"IFERROR(G29/$F$22,\"\")","v":""}]
["Coordination Staffing",null,null,null,null,null,null,""]
["Compliance Consulting (if Uniform Relocation Act triggered)",null,null,null,null,null,null,""]
["Other:",null,null,null,null,null,null,""]
["Other:"]
["Other:"]
["Other:",null,null,null,null,null,null,""]
["Total Relocation Expenses",null,null,null,null,null,{"$f":"SUM(G26:G35)","v":0},{"$f":"SUM(H26:H35)","v":0},{"$f":"SUM(I26:I35)","v":0}]

{"sheet":"Pro Forma","index":4,"n_rows":131,"n_cols":29,"rows_kept":131,"cut":false,"hidden":true,"merged":[[2,2,2,14],[3,2,3,14],[5,0,5,14],[89,15,89,18]]}
["0 BR","1 BR","2 BR","3 BR","4 BR","Other"]
[]
["PROJECT NAME",null,{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"},{"$f":"[1]Instructions!$C$15","v":"Project A"}]
["DEVELOPER/SPONSOR",null,{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"},{"$f":"[1]Instructions!$C$17","v":"Apex Developers"}]
[]
["Rental Project Operating Pro Forma"]
[]
[]
["Rental Income"]
["Unit Type","Number of Units","Per Unit Sq Ft","Total Sq Ft","Restriction on % AMI","Per Unit Monthly Gross Rent","Utility Deductions","Per Unit Monthly Net Rent","Per Unit Net Rent Per Sq Ft","Total Monthly Net Income","Total Annual Net Rent"]
["0 BR",null,null,{"$f":"B11*C11","v":0},0.3,null,null,{"$f":"F11-G11","v":0},{"$f":"IFERROR(H11/C11,\"\")","v":""},{"$f":"B11*H11","v":0},{"$f":"J11*12","v":0}]
["0 BR",null,null,{"$f":"B12*C12","v":0},0.5,null,null,{"$f":"F12-G12","v":0},{"$f":"IFERROR(H12/C12,\"\")","v":""},{"$f":"B12*H12","v":0},0]
["0 BR",null,null,0,0.6,null,null,{"$f":"F13-G13","v":0},{"$f":"IFERROR(H13/C13,\"\")","v":""},{"$f":"B13*H13","v":0},0]
["1 BR",null,null,0,0.3,null,null,0,"",0,0]
["1 BR",null,null,0,0.5,null,null,0,"",0,0]
["1 BR",null,null,0,0.6,null,null,0,"",0,0]
["2 BR",null,null,0,0.3,null,null,0,"",0,0]
["2 BR",null,null,0,0.5,null,null,0,"",0,0]
["2 BR",null,null,0,0.6,null,null,0,"",0,0]
["3 BR",null,null,0,0.3,null,null,0,"",0,0]
["3 BR",null,null,0,0.5,null,null,0,"",0,0]
["3 BR",null,null,0,0.6,null,null,0,"",0,0]
["4 BR",null,null,0,0.3,null,null,0,"",0,0]
["4 BR",null,null,0,0.5,null,null,0,"",0,0]
["4 BR",null,null,0,0.6,null,null,0,"",0,0]
["Other",null,null,0,0.3,null,null,0,"",0,0]
["Other",null,null,0,0.5,null,null,0,"",0,0]
["Other",null,null,0,0.6,null,null,0,"",0,0]
["0 BR",null,null,0,"Market",null,null,0,"",0]
["1 BR",null,null,0,"Market",null,null,0,"",0,0]
["2 BR",null,null,0,"Market",null,null,0,"",0,0]
["3 BR",null,null,0,"Market",null,null,0,"",0,0]
["Total:",{"$f":"SUM(B11:B31)","v":0},null,{"$f":"SUM(D11:D31)","v":0},null,null,null,null,null,{"$f":"SUM(J11:J31)","v":0},{"$f":"SUM(K11:K31)","v":0}]
[]
[]
["Operating Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Operating Expenses"]
["Rent Increase Rate",null,null,0.03,null,null,null,null,null,null,null,null,null,null,null,"Rent Increase Rate",null,null,{"$f":"D37","v":0.03}]
["Expenses Increase Rate",null,null,0.03,null,"Note: Year 1 is the first full year of stabilized operations",null,null,null,null,null,null,null,null,null,"Expenses Increase Rate",null,null,{"$f":"D38","v":0.03}]
[]
[null,null,null,null,"Year 1","Year 1/Unit","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10",null,null,null,null,"Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20"]
["Income","Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,"Income"]
["Sch. Gross Income - Residential",null,null,null,{"$f":"K33","v":0},{"$f":"IFERROR(E42/$B$33,\"\")","v":""},{"$f":"E42*(1+$D$37)","v":0},{"$f":"G42*(1+$D$37)","v":0},{"$f":"H42*(1+$D$37)","v":0},0,0,{"$f":"K42*(1+$D$37)","v":0},0,0,{"$f":"N42*(1+$D$37)","v":0},"Sch. Gross Income - Residential",null,null,null,{"$f":"O42*(1+$D$37)","v":0},{"$f":"T42*(1+$D$37)","v":0},0,0,0,0,0,0,0,0]
["   Vacancy Loss",null,null,0.05,{"$f":"-E42*D43","v":0},{"$f":"IFERROR(E43/$B$33,\"\")","v":""},{"$f":"E43*(1+$D$37)","v":0},{"$f":"G43*(1+$D$37)","v":0},0,0,0,0,0,0,{"$f":"N43*(1+$D$37)","v":0},"   Vacancy Loss",null,null,{"$f":"D43","v":0.05},{"$f":"O43*(1+$D$37)","v":0},0,0,0,0,0,0,0,0,0]
["Other income (laundry)",null,null,null,0,{"$f":"IFERROR(E44/$B$33,\"\")","v":""},{"$f":"E44*(1+$D$37)","v":0},{"$f":"G44*(1+$D$37)","v":0},0,0,0,0,0,0,{"$f":"N44*(1+$D$37)","v":0},"Other income (laundry)",null,null,null,{"$f":"O44*(1+$D$37)","v":0},0,0,0,0,0,0,0,0,0]
["Other income  ",null,null,null,0,{"$f":"IFERROR(E45/$B$33,\"\")","v":""},null,null,null,null,null,null,null,null,null,"Supportive Services Funding"]
["Effective Gross Income",null,null,null,{"$f":"SUM(E42:E45)","v":0},{"$f":"SUM(F42:F45)","v":0},{"$f":"SUM(G42:G45)","v":0},{"$f":"SUM(H42:H45)","v":0},0,0,0,0,0,0,0,"Effective Gross Income",null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Administrative","Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,"Administrative"]
["Advertising & Renting",null,null,null,0,{"$f":"IFERROR(E49/$B$33,\"\")","v":""},{"$f":"E49*(1+$D$38)","v":0},{"$f":"G49*(1+$D$38)","v":0},0,0,0,0,0,0,0,{"$f":"A49","v":"Advertising & Renting"},null,null,null,{"$f":"O49*(1+$D$38)","v":0},{"$f":"T49*(1+$D$38)","v":0},0,0,0,0,0,0,0,0]
["Office & Telephone",null,null,null,0,"",0,0,0,0,0,0,0,0,0,{"$f":"A50","v":"Office & Telephone"},null,null,null,0,0,0,0,0,0,0,0,0,0]
["Management Fee",null,null,{"$f":"IF(E51=0,0,E51/E46)","v":0},0,"",0,0,0,0,0,0,0,0,0,"Management Fee",null,null,{"$f":"D51","v":0},0,0,0,0,0,0,0,0,0,0]
["Legal",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Legal",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Audit & Accounting",null,null,null,0,"",0,0,0,0,0,{"$f":"K53*(1+$D$38)","v":0},0,0,0,"Audit & Accounting",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Admin Other",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Admin Other",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Total Administrative",null,null,null,{"$f":"SUM(E49:E54)","v":0},0,0,0,0,0,0,0,0,0,0,"Total Administrative",null,null,null,{"$f":"SUM(T49:T54)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Supportive Services",null,null,null,0,{"$f":"IFERROR(E57/$B$33,\"\")","v":""},{"$f":"E57*(1+$D$38)","v":0},{"$f":"G57*(1+$D$38)","v":0},0,0,0,0,0,0,0,"Supportive Services"]
[]
["Utilities","Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilities"]
["Fuel Oil",null,null,null,0,{"$f":"IFERROR(E60/$B$33,\"\")","v":""},{"$f":"E60*(1+$D$38)","v":0},{"$f":"G60*(1+$D$38)","v":0},0,0,0,0,0,0,{"$f":"N60*(1+$D$38)","v":0},{"$f":"A60","v":"Fuel Oil"},null,null,null,{"$f":"O60*(1+$D$38)","v":0},{"$f":"T60*(1+$D$38)","v":0},0,0,0,0,0,0,0,0]
["   Electricity",null,null,null,0,{"$f":"IFERROR(E61/$B$33,\"\")","v":""},{"$f":"E61*(1+$D$38)","v":0},0,0,0,0,0,0,0,{"$f":"N61*(1+$D$38)","v":0},{"$f":"A61","v":"   Electricity"},null,null,null,{"$f":"O61*(1+$D$38)","v":0},0,0,0,0,0,0,0,0,0]
["Water  ",null,null,null,0,{"$f":"IFERROR(E62/$B$33,\"\")","v":""},{"$f":"E62*(1+$D$38)","v":0},0,0,0,0,0,0,0,{"$f":"N62*(1+$D$38)","v":0},{"$f":"A62","v":"Water  "},null,null,null,{"$f":"O62*(1+$D$38)","v":0},0,0,0,0,0,0,0,0,0]
["Gas",null,null,null,0,{"$f":"IFERROR(E63/$B$33,\"\")","v":""},{"$f":"E63*(1+$D$38)","v":0},0,0,0,0,{"$f":"K63*(1+$D$38)","v":0},0,0,{"$f":"N63*(1+$D$38)","v":0},{"$f":"A63","v":"Gas"},null,null,null,{"$f":"O63*(1+$D$38)","v":0},0,0,0,0,0,0,0,0,0]
["Sewer",null,null,null,0,{"$f":"IFERROR(E64/$B$33,\"\")","v":""},{"$f":"E64*(1+$D$38)","v":0},0,0,0,0,0,0,0,{"$f":"N64*(1+$D$38)","v":0},{"$f":"A64","v":"Sewer"},null,null,null,{"$f":"O64*(1+$D$38)","v":0},0,0,0,0,0,0,0,0,0]
["Total Utilities",null,null,null,0,{"$f":"SUM(F60:F64)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(O60:O64)","v":0},"Total Utilities",null,null,null,{"$f":"SUM(T60:T64)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Maintenance (excluding staff)","Detail",null,null,"Year 1","Year 1/Unit","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Maintenance",null,null,null,"Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20"]
["Janitorial & Maintenance Supplies",null,null,null,0,{"$f":"IFERROR(E68/$B$33,\"\")","v":""},{"$f":"E68*(1+$D$38)","v":0},{"$f":"G68*(1+$D$38)","v":0},{"$f":"H68*(1+$D$38)","v":0},0,0,0,0,0,0,{"$f":"A68","v":"Janitorial & Maintenance Supplies"},null,null,null,{"$f":"O68*(1+$D$38)","v":0},{"$f":"T68*(1+$D$38)","v":0},0,0,0,0,0,0,0,0]
["Operating/Maintenance Contracts",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Operating/Maintenance Contracts",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Trash Removal",null,null,null,0,"",0,0,{"$f":"H70*(1+$D$38)","v":0},0,0,0,0,0,0,"Trash Removal",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Security Payroll/Contract",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Security Payroll/Contract",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Repairs Materials",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Repairs Materials",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Maintenance contracts (HVAC, elevator, etc)",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Maintenance contracts (HVAC, elevator, etc)",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Grounds & Snow Removal",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Grounds & Snow Removal",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Painting & Decorating",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Painting & Decorating",null,null,null,{"$f":"O75*(1+$D$38)","v":0},0,0,0,0,0,0,0,0,0]
["Other",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Other",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Total Maintenance",null,null,null,{"$f":"SUM(E68:E76)","v":0},0,0,0,0,0,0,0,0,0,0,"Total Maintenance",null,null,null,{"$f":"SUM(T68:T76)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Payroll Expense","Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A79","v":"Payroll Expense"}]
["Office Salaries",null,null,null,0,{"$f":"IFERROR(E80/$B$33,\"\")","v":""},{"$f":"E80*(1+$D$38)","v":0},{"$f":"G80*(1+$D$38)","v":0},0,0,0,0,0,0,0,"Office Salaries",null,null,null,{"$f":"O80*(1+$D$38)","v":0},{"$f":"T80*(1+$D$38)","v":0},0,0,0,0,0,0,0,0]
["Manager Salaries",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Manager Salaries",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Employee Rent Free Unit",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Employee Rent Free Unit",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Janitor/Maintenance Salaries",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Janitor/Maintenance Salaries",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Payroll Tax/Workers Comp & Employee Benefits",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Payroll Tax/Workers Comp & Employee Benefits",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Other",null,null,null,0,"",0,0,0,0,0,0,0,0,0,"Other",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Total Payroll Expense",null,null,null,{"$f":"SUM(E80:E85)","v":0},{"$f":"SUM(F80:F85)","v":0},0,0,0,0,0,0,0,0,0,"Total Payroll Expense",null,null,null,{"$f":"SUM(T80:T85)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Taxes & Insurance","Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,"Taxes & Insurance"]
["Real Estate Taxes",null,null,null,0,{"$f":"IFERROR(E89/$B$33,\"\")","v":""},{"$f":"E89*(1+$D$38)","v":0},{"$f":"G89*(1+$D$38)","v":0},0,0,0,0,0,0,{"$f":"N89*(1+$D$38)","v":0},{"$f":"A89","v":"Real Estate Taxes"},null,null,null,{"$f":"O89*(1+$D$38)","v":0},{"$f":"T89*(1+$D$38)","v":0},0,0,0,0,0,0,0,0]
["Insurance (property, liability)",null,null,null,0,{"$f":"IFERROR(E90/$B$33,\"\")","v":""},{"$f":"E90*(1+$D$38)","v":0},0,0,0,0,0,0,0,{"$f":"N90*(1+$D$38)","v":0},{"$f":"A90","v":"Insurance (property, liability)"},null,null,null,{"$f":"O90*(1+$D$38)","v":0},0,0,0,0,0,0,0,0,0]
["   Misc. Taxes, Licenses & Permits",null,null,null,0,{"$f":"IFERROR(E91/$B$33,\"\")","v":""},{"$f":"E91*(1+$D$38)","v":0},0,0,0,0,0,0,0,{"$f":"N91*(1+$D$38)","v":0},{"$f":"A91","v":"   Misc. Taxes, Licenses & Permits"},null,null,null,{"$f":"O91*(1+$D$38)","v":0},0,0,0,0,0,0,0,0,0]
["Other",null,null,null,0,{"$f":"IFERROR(E92/$B$33,\"\")","v":""},{"$f":"E92*(1+$D$38)","v":0},0,0,0,0,0,0,0,{"$f":"N92*(1+$D$38)","v":0},"Other",null,null,null,{"$f":"O92*(1+$D$38)","v":0},0,0,0,0,0,0,0,0,0]
["Total Taxes & Insurance",null,null,null,{"$f":"SUM(E89:E92)","v":0},0,0,0,0,0,0,0,0,0,0,"Total Taxes & Insurance",null,null,null,{"$f":"SUM(T89:T92)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Replacement Reserves",null,null,null,0,{"$f":"IFERROR(E95/$B$33,\"\")","v":""},{"$f":"E95*(1+$D$38)","v":0},{"$f":"G95*(1+$D$38)","v":0},{"$f":"H95*(1+$D$38)","v":0},0,0,0,0,0,{"$f":"N95*(1+$D$38)","v":0},"Replacement Reserves",null,null,null,{"$f":"O95*(1+$D$38)","v":0},{"$f":"T95*(1+$D$38)","v":0},0,0,0,0,0,0,0,0]
["Operating Reserves",null,null,null,0,{"$f":"IFERROR(E96/$B$33,\"\")","v":""},{"$f":"E96*(1+$D$38)","v":0},{"$f":"G96*(1+$D$38)","v":0},0,0,0,0,0,0,{"$f":"N96*(1+$D$38)","v":0},"Operating Reserves",null,null,null,{"$f":"O96*(1+$D$38)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Total Expenses",null,null,null,{"$f":"SUM(E55,E57,E65,E77,E86,E93,E95,E96)","v":0},{"$f":"SUM(F55,F57,F65,F77,F86,F93,F95,F96)","v":0},{"$f":"SUM(G55,G57,G65,G77,G86,G93,G95,G96)","v":0},0,0,0,0,0,0,0,0,"Total Expenses",null,null,null,{"$f":"SUM(T55,T57,T65,T77,T86,T93,T95,T96)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Net Operating Income",null,null,null,{"$f":"E46-E98","v":0},0,0,0,0,0,0,0,0,0,0,"Net Operating Income",null,null,null,{"$f":"T46-T98","v":0},0,0,0,0,0,0,0,0,0]
[]
["Debt Service","Detail",null,null,null,null,null,null,null,null,null,null,null,null,null,"Debt Service"]
["First Lien",null,null,null,0,{"$f":"IFERROR(E103/$B$33,\"\")","v":""},{"$f":"$E103","v":0},{"$f":"$E103","v":0},0,0,0,0,0,0,{"$f":"$E103","v":0},"First Lien",null,null,null,{"$f":"$E103","v":0},0,0,0,0,0,0,0,0,0]
["Second Lien",null,null,null,0,{"$f":"IFERROR(E104/$B$33,\"\")","v":""},{"$f":"$E104","v":0},0,0,0,0,0,0,0,0,"Second Lien",null,null,null,0,0,0,0,0,0,0,0,0,0]
["EEHDP - If Amortizing",null,null,null,{"$f":"'Amortization Table'!D14*12","v":0},{"$f":"IFERROR(E105/$B$33,\"\")","v":""},0,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Other",null,null,null,0,"",0,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Other",null,null,null,0,"",0,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Other",null,null,null,0,{"$f":"IFERROR(E108/$B$33,\"\")","v":""},0,0,0,0,0,0,0,0,0,"Other",null,null,null,0,0,0,0,0,0,0,0,0,0]
["Total Debt Service (Must Pay)",null,null,null,{"$f":"SUM(E103:E108)","v":0},{"$f":"SUM(F103:F108)","v":0},0,0,0,0,0,0,0,0,0,"Total Debt Service (Must Pay)",null,null,null,{"$f":"SUM(T103:T108)","v":0},0,0,0,0,0,0,0,0,0]
["Cash Flow (after Must Pay Debt)",null,null,null,{"$f":"E100-E109","v":0},0,0,0,0,0,0,0,0,0,0,"Cash Flow (after Must Pay Debt)",null,null,null,{"$f":"T100-T109","v":0},0,0,0,0,0,0,0,0,0]
["Debt Service Coverage Ratio",null,null,null,{"$f":"IFERROR(E100/E109,\"\")","v":""},"","","","","","","","","","","Debt Service Coverage Ratio",null,null,null,{"$f":"IFERROR(T100/T109,\"\")","v":""},"","","","","","","","",""]
[]
["Cash Flow Debt Payments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Flow Debt Payments"]
["EEHDP - If Cashflow","(minimum 50%)",null,0,{"$f":"IF(E$110>0,E$110*$D114,0)","v":0},{"$f":"IF(F$110>0,F$110*$D114,0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(O$110>0,O$110*$D114,0)","v":0},"URA",null,null,{"$f":"D114","v":0},{"$f":"IF(T$110>0,T$110*$D114,0)","v":0},0,0,0,0,0,0,0,0,0]
["Other",null,null,0,{"$f":"IF(E$110>0,E$110*$D115,0)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Other",null,null,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Other",null,null,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Other",null,null,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Developer Fee Loan",null,null,0,{"$f":"IF(E$110>0,E$110*$D119,0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"IF(O$110>0,O$110*$D119,0)","v":0},"Developer Fee Loan",null,null,{"$f":"D119","v":0},0,0,0,0,0,0,0,0,0,0]
["Cash Flow Retained by Project",null,null,null,{"$f":"E110-SUM(E114:E119)","v":0},{"$f":"F110-SUM(F114:F119)","v":0},0,0,0,0,0,0,0,0,0,"Cash Flow Retained by Project",null,null,null,{"$f":"T110-SUM(T114:T119)","v":0},{"$f":"U110-SUM(U114:U119)","v":0},0,0,0,0,0,0,0,0]
["Retained Cash Flow %",null,null,{"$f":"IFERROR(E120/E98,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,"Retained Cash Flow %",null,null,{"$f":"D121","v":""}]
[]
[]
[]
[]
[]
[]
[]
[0.3]
[0.5]
[0.8]

{"sheet":"Amortization Table","index":5,"n_rows":800,"n_cols":12,"rows_kept":800,"cut":false,"hidden":true,"merged":[[16,0,16,3]]}
["Simple Interest Loan Calculator"]
["HELP",null,null,null,null,null,null,"© 2008 Vertex42 LLC"]
[null,null,null,null,null,null,null,null,null,"Payment Frequency Options"]
["Loan Information",null,null,null,"[42]","Summary",null,null,null,"Frequency","Payments/yr","Months"]
[null,null,"Loan Amount",0,null,null,"Daily Interest Rate",{"$f":"D6/D11","v":8.219178082191781E-5},null,"Annual",1,12]
[null,null,"Annual Interest Rate",0.03,null,null,"Number of Payments",{"$f":"MAX(A18:A799)","v":1},null,"Semi-Annual",2,6]
[null,null,"Term of Loan in Years",20,null,null,"Total Payments",{"$f":"SUM(C20:C799)","v":0},null,"Quarterly",4,3]
[null,null,"First Day Interest Accrues","2021-01-01",null,null,"Total Interest",{"$f":"SUM(D20:D800)","v":0},null,"Bi-Monthly",6,2]
[null,null,"First Payment Date","2021-02-01",null,null,"Balloon Payment",{"$f":"IF(D12=\"\",0,OFFSET(C18,D12+1,0,1,1))","v":0},null,"Monthly",12,1]
[null,null,"Payment Frequency","Monthly",null,null,null,{"$f":"IF(AND(NOT(H799=\"\"),H799>0.004),\"ERROR: Limit is \"&OFFSET(A800,-1,0,1,1)&\" payments\",\".\")","v":"."},null,"Semi-Monthly",24,0.5]
[null,null,"Days in Year",365,null,null,null,null,null,"Bi-Weekly",26,"n/a"]
[null,null,"Balloon Payment #",null,null,null,null,null,null,"Weekly",52,"n/a"]
[null,null,null,null,null,null,null,null,null,"Chosen:",{"$f":"INDEX(K5:K12,MATCH($D$10,J5:J12,0))","v":12},{"$f":"INDEX(L5:L12,MATCH($D$10,J5:J12,0))","v":1}]
[null,null,{"$f":"\"Est. \"&D10&\" Payment\"","v":"Est. Monthly Payment"},{"$f":"IF(roundOpt,ROUND(-PMT((1+D6/$D$11)^(365/$K$13)-1,$D$7*$K$13,$D$5),2),-PMT((1+D6/$D$11)^(365/$K$13)-1,$D$7*$K$13,$D$5))","v":0},"(estimate)"]
[null,null,{"$f":"\"Actual \"&D10&\" Payment\"","v":"Actual Monthly Payment"},429.86,false]
[]
["Amortization Schedule",null,null,null,null,null,null,true]
["Pmt\nNo.","Date","Payment","Interest\nAccrued",null,"Interest\nBalance","Principal\nBalance","Total\nOwed"]
[null,{"$f":"D8-1","v":"2020-12-31"},null,null,null,null,{"$f":"$D$5","v":0},{"$f":"$D$5","v":0}]
[1,{"$f":"IF(A20=\"\",\"\",IF($K$13=26,(A20-1)*14+$D$9,IF($K$13=52,(A20-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A20-1)*$L$13,IF($K$13=24,IF((MOD(A20-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":"2021-02-01"},{"$f":"IF(A20=\"\",\"\",IF(A20=$D$12,H19+D20,IF(IF($E$15,$D$15,$D$14)>H19+D20,H19+D20,IF($E$15,$D$15,$D$14))))","v":0},{"$f":"IF(B20=\"\",\"\",IF(roundOpt,ROUND((B20-B19)*$H$5*G19,2),(B20-B19)*$H$5*G19))","v":0},null,{"$f":"IF(B20=\"\",\"\",IF(C20>F19+D20,0,F19+D20-C20))","v":0},{"$f":"IF(B20=\"\",\"\",IF(C20>D20+F19,G19+F19+D20-C20,G19))","v":0},{"$f":"IF(B20=\"\",\"\",G20+F20)","v":0}]
[{"$f":"IF(OR(H20<=0,H20=\"\"),\"\",OFFSET(A21,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
[{"$f":"IF(OR(H21<=0,H21=\"\"),\"\",OFFSET(A22,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A84=\"\",\"\",IF($K$13=26,(A84-1)*14+$D$9,IF($K$13=52,(A84-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A84-1)*$L$13,IF($K$13=24,IF((MOD(A84-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A84=\"\",\"\",IF(A84=$D$12,H83+D84,IF(IF($E$15,$D$15,$D$14)>H83+D84,H83+D84,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B84=\"\",\"\",IF(roundOpt,ROUND((B84-B83)*$H$5*G83,2),(B84-B83)*$H$5*G83))","v":""},null,{"$f":"IF(B84=\"\",\"\",IF(C84>F83+D84,0,F83+D84-C84))","v":""},{"$f":"IF(B84=\"\",\"\",IF(C84>D84+F83,G83+F83+D84-C84,G83))","v":""},{"$f":"IF(B84=\"\",\"\",G84+F84)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H85<=0,H85=\"\"),\"\",OFFSET(A86,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A148=\"\",\"\",IF($K$13=26,(A148-1)*14+$D$9,IF($K$13=52,(A148-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A148-1)*$L$13,IF($K$13=24,IF((MOD(A148-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A148=\"\",\"\",IF(A148=$D$12,H147+D148,IF(IF($E$15,$D$15,$D$14)>H147+D148,H147+D148,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B148=\"\",\"\",IF(roundOpt,ROUND((B148-B147)*$H$5*G147,2),(B148-B147)*$H$5*G147))","v":""},null,{"$f":"IF(B148=\"\",\"\",IF(C148>F147+D148,0,F147+D148-C148))","v":""},{"$f":"IF(B148=\"\",\"\",IF(C148>D148+F147,G147+F147+D148-C148,G147))","v":""},{"$f":"IF(B148=\"\",\"\",G148+F148)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H149<=0,H149=\"\"),\"\",OFFSET(A150,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A212=\"\",\"\",IF($K$13=26,(A212-1)*14+$D$9,IF($K$13=52,(A212-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A212-1)*$L$13,IF($K$13=24,IF((MOD(A212-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A212=\"\",\"\",IF(A212=$D$12,H211+D212,IF(IF($E$15,$D$15,$D$14)>H211+D212,H211+D212,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B212=\"\",\"\",IF(roundOpt,ROUND((B212-B211)*$H$5*G211,2),(B212-B211)*$H$5*G211))","v":""},null,{"$f":"IF(B212=\"\",\"\",IF(C212>F211+D212,0,F211+D212-C212))","v":""},{"$f":"IF(B212=\"\",\"\",IF(C212>D212+F211,G211+F211+D212-C212,G211))","v":""},{"$f":"IF(B212=\"\",\"\",G212+F212)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H213<=0,H213=\"\"),\"\",OFFSET(A214,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","","",null,null,null,{"$f":"SUM(D20:D260)","v":0}]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A276=\"\",\"\",IF($K$13=26,(A276-1)*14+$D$9,IF($K$13=52,(A276-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A276-1)*$L$13,IF($K$13=24,IF((MOD(A276-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A276=\"\",\"\",IF(A276=$D$12,H275+D276,IF(IF($E$15,$D$15,$D$14)>H275+D276,H275+D276,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B276=\"\",\"\",IF(roundOpt,ROUND((B276-B275)*$H$5*G275,2),(B276-B275)*$H$5*G275))","v":""},null,{"$f":"IF(B276=\"\",\"\",IF(C276>F275+D276,0,F275+D276-C276))","v":""},{"$f":"IF(B276=\"\",\"\",IF(C276>D276+F275,G275+F275+D276-C276,G275))","v":""},{"$f":"IF(B276=\"\",\"\",G276+F276)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H277<=0,H277=\"\"),\"\",OFFSET(A278,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A340=\"\",\"\",IF($K$13=26,(A340-1)*14+$D$9,IF($K$13=52,(A340-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A340-1)*$L$13,IF($K$13=24,IF((MOD(A340-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A340=\"\",\"\",IF(A340=$D$12,H339+D340,IF(IF($E$15,$D$15,$D$14)>H339+D340,H339+D340,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B340=\"\",\"\",IF(roundOpt,ROUND((B340-B339)*$H$5*G339,2),(B340-B339)*$H$5*G339))","v":""},null,{"$f":"IF(B340=\"\",\"\",IF(C340>F339+D340,0,F339+D340-C340))","v":""},{"$f":"IF(B340=\"\",\"\",IF(C340>D340+F339,G339+F339+D340-C340,G339))","v":""},{"$f":"IF(B340=\"\",\"\",G340+F340)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H341<=0,H341=\"\"),\"\",OFFSET(A342,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A404=\"\",\"\",IF($K$13=26,(A404-1)*14+$D$9,IF($K$13=52,(A404-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A404-1)*$L$13,IF($K$13=24,IF((MOD(A404-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A404=\"\",\"\",IF(A404=$D$12,H403+D404,IF(IF($E$15,$D$15,$D$14)>H403+D404,H403+D404,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B404=\"\",\"\",IF(roundOpt,ROUND((B404-B403)*$H$5*G403,2),(B404-B403)*$H$5*G403))","v":""},null,{"$f":"IF(B404=\"\",\"\",IF(C404>F403+D404,0,F403+D404-C404))","v":""},{"$f":"IF(B404=\"\",\"\",IF(C404>D404+F403,G403+F403+D404-C404,G403))","v":""},{"$f":"IF(B404=\"\",\"\",G404+F404)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H405<=0,H405=\"\"),\"\",OFFSET(A406,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A468=\"\",\"\",IF($K$13=26,(A468-1)*14+$D$9,IF($K$13=52,(A468-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A468-1)*$L$13,IF($K$13=24,IF((MOD(A468-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A468=\"\",\"\",IF(A468=$D$12,H467+D468,IF(IF($E$15,$D$15,$D$14)>H467+D468,H467+D468,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B468=\"\",\"\",IF(roundOpt,ROUND((B468-B467)*$H$5*G467,2),(B468-B467)*$H$5*G467))","v":""},null,{"$f":"IF(B468=\"\",\"\",IF(C468>F467+D468,0,F467+D468-C468))","v":""},{"$f":"IF(B468=\"\",\"\",IF(C468>D468+F467,G467+F467+D468-C468,G467))","v":""},{"$f":"IF(B468=\"\",\"\",G468+F468)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H469<=0,H469=\"\"),\"\",OFFSET(A470,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A532=\"\",\"\",IF($K$13=26,(A532-1)*14+$D$9,IF($K$13=52,(A532-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A532-1)*$L$13,IF($K$13=24,IF((MOD(A532-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A532=\"\",\"\",IF(A532=$D$12,H531+D532,IF(IF($E$15,$D$15,$D$14)>H531+D532,H531+D532,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B532=\"\",\"\",IF(roundOpt,ROUND((B532-B531)*$H$5*G531,2),(B532-B531)*$H$5*G531))","v":""},null,{"$f":"IF(B532=\"\",\"\",IF(C532>F531+D532,0,F531+D532-C532))","v":""},{"$f":"IF(B532=\"\",\"\",IF(C532>D532+F531,G531+F531+D532-C532,G531))","v":""},{"$f":"IF(B532=\"\",\"\",G532+F532)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H533<=0,H533=\"\"),\"\",OFFSET(A534,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A596=\"\",\"\",IF($K$13=26,(A596-1)*14+$D$9,IF($K$13=52,(A596-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A596-1)*$L$13,IF($K$13=24,IF((MOD(A596-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A596=\"\",\"\",IF(A596=$D$12,H595+D596,IF(IF($E$15,$D$15,$D$14)>H595+D596,H595+D596,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B596=\"\",\"\",IF(roundOpt,ROUND((B596-B595)*$H$5*G595,2),(B596-B595)*$H$5*G595))","v":""},null,{"$f":"IF(B596=\"\",\"\",IF(C596>F595+D596,0,F595+D596-C596))","v":""},{"$f":"IF(B596=\"\",\"\",IF(C596>D596+F595,G595+F595+D596-C596,G595))","v":""},{"$f":"IF(B596=\"\",\"\",G596+F596)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H597<=0,H597=\"\"),\"\",OFFSET(A598,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A660=\"\",\"\",IF($K$13=26,(A660-1)*14+$D$9,IF($K$13=52,(A660-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A660-1)*$L$13,IF($K$13=24,IF((MOD(A660-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A660=\"\",\"\",IF(A660=$D$12,H659+D660,IF(IF($E$15,$D$15,$D$14)>H659+D660,H659+D660,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B660=\"\",\"\",IF(roundOpt,ROUND((B660-B659)*$H$5*G659,2),(B660-B659)*$H$5*G659))","v":""},null,{"$f":"IF(B660=\"\",\"\",IF(C660>F659+D660,0,F659+D660-C660))","v":""},{"$f":"IF(B660=\"\",\"\",IF(C660>D660+F659,G659+F659+D660-C660,G659))","v":""},{"$f":"IF(B660=\"\",\"\",G660+F660)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H661<=0,H661=\"\"),\"\",OFFSET(A662,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A724=\"\",\"\",IF($K$13=26,(A724-1)*14+$D$9,IF($K$13=52,(A724-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A724-1)*$L$13,IF($K$13=24,IF((MOD(A724-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A724=\"\",\"\",IF(A724=$D$12,H723+D724,IF(IF($E$15,$D$15,$D$14)>H723+D724,H723+D724,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B724=\"\",\"\",IF(roundOpt,ROUND((B724-B723)*$H$5*G723,2),(B724-B723)*$H$5*G723))","v":""},null,{"$f":"IF(B724=\"\",\"\",IF(C724>F723+D724,0,F723+D724-C724))","v":""},{"$f":"IF(B724=\"\",\"\",IF(C724>D724+F723,G723+F723+D724-C724,G723))","v":""},{"$f":"IF(B724=\"\",\"\",G724+F724)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H725<=0,H725=\"\"),\"\",OFFSET(A726,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["",{"$f":"IF(A788=\"\",\"\",IF($K$13=26,(A788-1)*14+$D$9,IF($K$13=52,(A788-1)*7+$D$9,DATE(YEAR($D$9),MONTH($D$9)+(A788-1)*$L$13,IF($K$13=24,IF((MOD(A788-1,2))=1,DAY($D$9)+14,DAY($D$9)),DAY($D$9))))))","v":""},{"$f":"IF(A788=\"\",\"\",IF(A788=$D$12,H787+D788,IF(IF($E$15,$D$15,$D$14)>H787+D788,H787+D788,IF($E$15,$D$15,$D$14))))","v":""},{"$f":"IF(B788=\"\",\"\",IF(roundOpt,ROUND((B788-B787)*$H$5*G787,2),(B788-B787)*$H$5*G787))","v":""},null,{"$f":"IF(B788=\"\",\"\",IF(C788>F787+D788,0,F787+D788-C788))","v":""},{"$f":"IF(B788=\"\",\"\",IF(C788>D788+F787,G787+F787+D788-C788,G787))","v":""},{"$f":"IF(B788=\"\",\"\",G788+F788)","v":""}]
["","","","",null,"","",""]
[{"$f":"IF(OR(H789<=0,H789=\"\"),\"\",OFFSET(A790,-1,0,1,1)+1)","v":""},"","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
["","","","",null,"","",""]
[null,null,null,""]

{"sheet":"Program","index":6,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[4,0,4,13]]}
[]
["PROJECT NAME",{"$f":"[2]Instructions!$C$15","v":"Project A"}]
["DEVELOPER/SPONSOR",{"$f":"[2]Instructions!$C$16","v":"Apex Developers"}]
[]
["For-Sale Program"]
[]
[null,"Property Address","Project Type","Gross Square Footage","Anticipated Sale Price","Target affordability:",null,null,null,"Letter","Project Type","Number of Projects","Average GSF","Sale Price"]
[1,"1 Main St","2B 2ba, East Liberty",2200,150000,null,null,null,null,"A",{"$f":"IFERROR(INDEX($C$8:$C$17,MATCH(0,COUNTIF($K$7:K7,$C$8:$C$17),0)),0)","v":"2B 2ba, East Liberty"},{"$f":"IF(ISTEXT(K8)=TRUE,COUNTIFS($C$8:$C$17,K8),\"\")","v":2},{"$f":"IFERROR(AVERAGEIFS($D$8:$D$17,$C$8:$C$17,K8),\"\")","v":2200},{"$f":"IFERROR(AVERAGEIFS($E$8:$E$17,$C$8:$C$17,K8),\"\")","v":150000}]
[{"$f":"A8+1","v":2},"2 Main St","2B 2ba, East Liberty",2200,150000,null,null,null,null,"B",{"$f":"IFERROR(INDEX($C$8:$C$17,MATCH(0,COUNTIF($K$7:K8,$C$8:$C$17),0)),0)","v":"3B 2ba, East Liberty"},{"$f":"IF(ISTEXT(K9)=TRUE,COUNTIFS($C$8:$C$17,K9),\"\")","v":1},{"$f":"IFERROR(AVERAGEIFS($D$8:$D$17,$C$8:$C$17,K9),\"\")","v":3000},{"$f":"IFERROR(AVERAGEIFS($E$8:$E$17,$C$8:$C$17,K9),\"\")","v":160000}]
[{"$f":"A9+1","v":3},"3 Main St","3B 2ba, East Liberty",3000,160000,null,null,null,null,"C",{"$f":"IFERROR(INDEX($C$8:$C$17,MATCH(0,COUNTIF($K$7:K9,$C$8:$C$17),0)),0)","v":"2B 2ba, Larimer"},2,2000,200000]
[4,"1 Broadway","2B 2ba, Larimer",2000,200000,null,null,null,null,"D",{"$f":"IFERROR(INDEX($C$8:$C$17,MATCH(0,COUNTIF($K$7:K10,$C$8:$C$17),0)),0)","v":0},"","",""]
[5,"2 Broadway","2B 2ba, Larimer",2000,200000,null,null,null,null,"E",{"$f":"IFERROR(INDEX($C$8:$C$17,MATCH(0,COUNTIF($K$7:K11,$C$8:$C$17),0)),0)","v":0},"","",""]
[6,null,null,null,null,null,null,null,null,"F",{"$f":"IFERROR(INDEX($C$8:$C$17,MATCH(0,COUNTIF($K$7:K12,$C$8:$C$17),0)),0)","v":0},"","",""]
[7,null,null,null,null,null,null,null,null,"G",{"$f":"IFERROR(INDEX($C$8:$C$17,MATCH(0,COUNTIF($K$7:K13,$C$8:$C$17),0)),0)","v":0},"","",""]
[8,null,null,null,null,null,null,null,null,"H",{"$f":"IFERROR(INDEX($C$8:$C$17,MATCH(0,COUNTIF($K$7:K14,$C$8:$C$17),0)),0)","v":0},"","",""]
[9,null,null,null,null,null,null,null,null,"I",{"$f":"IFERROR(INDEX($C$8:$C$17,MATCH(0,COUNTIF($K$7:K15,$C$8:$C$17),0)),0)","v":0},"","",""]
[10,null,null,null,null,null,null,null,null,"J",{"$f":"IFERROR(INDEX($C$8:$C$17,MATCH(0,COUNTIF($K$7:K16,$C$8:$C$17),0)),0)","v":0},"","",""]
[]
[null,"e.g. 1 Main St.","e.g. 2B 2ba, East Liberty","e.g. 2,500","e.g. $150,000","e.g. 4 person HH at or below 80% AMI"]

{"sheet":"Dev Budget","index":7,"n_rows":108,"n_cols":107,"rows_kept":108,"cut":false,"hidden":false,"merged":[[104,99,104,100],[103,89,103,90],[103,99,103,100],[104,9,104,10],[104,19,104,20],[104,29,104,30],[104,39,104,40],[104,49,104,50],[104,59,104,60],[104,69,104,70],[104,79,104,80],[103,9,103,10],[103,19,103,20],[103,29,103,30],[103,39,103,40],[103,49,103,50],[103,59,103,60],[103,69,103,70],[103,79,103,80],[104,89,104,90],[93,99,93,100],[94,9,94,10],[94,19,94,20],[94,29,94,30],[94,39,94,40],[94,49,94,50],[94,59,94,60],[94,69,94,70],[94,79,94,80],[94,89,94,90],[94,99,94,100],[93,9,93,10],[93,19,93,20],[93,29,93,30],[93,39,93,40],[93,49,93,50],[93,59,93,60],[93,69,93,70],[93,79,93,80],[93,89,93,90],[80,99,80,100],[81,9,81,10],[81,19,81,20],[81,29,81,30],[81,39,81,40],[81,49,81,50],[81,59,81,60],[81,69,81,70],[81,79,81,80],[81,89,81,90],[81,99,81,100],[80,9,80,10],[80,19,80,20],[80,29,80,30],[80,39,80,40],[80,49,80,50],[80,59,80,60],[80,69,80,70],[80,79,80,80],[80,89,80,90],[74,99,74,100],[75,9,75,10],[75,19,75,20],[75,29,75,30],[75,39,75,40],[75,49,75,50],[75,59,75,60],[75,69,75,70],[75,79,75,80],[75,89,75,90],[75,99,75,100],[74,9,74,10],[74,19,74,20],[74,29,74,30],[74,39,74,40],[74,49,74,50],[74,59,74,60],[74,69,74,70],[74,79,74,80],[74,89,74,90],[56,99,56,100],[57,9,57,10],[57,19,57,20],[57,29,57,30],[57,39,57,40],[57,49,57,50],[57,59,57,60],[57,69,57,70],[57,79,57,80],[57,89,57,90],[57,99,57,100],[56,9,56,10],[56,19,56,20],[56,29,56,30],[56,39,56,40],[56,49,56,50],[56,59,56,60],[56,69,56,70],[56,79,56,80],[56,89,56,90],[41,99,41,100],[42,9,42,10],[42,19,42,20],[42,29,42,30],[42,39,42,40],[42,49,42,50],[42,59,42,60],[42,69,42,70],[42,79,42,80],[42,89,42,90],[42,99,42,100],[41,9,41,10],[41,19,41,20],[41,29,41,30],[41,39,41,40],[41,49,41,50],[41,59,41,60],[41,69,41,70],[41,79,41,80],[41,89,41,90],[22,99,22,100],[23,9,23,10],[23,19,23,20],[23,29,23,30],[23,39,23,40],[23,49,23,50],[23,59,23,60],[23,69,23,70],[23,79,23,80],[23,89,23,90],[23,99,23,100],[22,9,22,10],[22,19,22,20],[22,29,22,30],[22,39,22,40],[22,49,22,50],[22,59,22,60],[22,69,22,70],[22,79,22,80],[22,89,22,90],[1,2,1,6],[2,2,2,6],[4,0,4,6],[5,0,5,6],[15,9,15,10],[15,19,15,20],[15,89,15,90],[15,99,15,100],[16,9,16,10],[16,19,16,20],[16,29,16,30],[16,39,16,40],[16,49,16,50],[16,59,16,60],[16,69,16,70],[16,79,16,80],[15,29,15,30],[15,39,15,40],[15,49,15,50],[15,59,15,60],[15,69,15,70],[15,79,15,80],[16,89,16,90],[16,99,16,100]]}
[]
["PROJECT NAME",null,{"$f":"[2]Instructions!$C$15","v":"Project A"},{"$f":"[2]Instructions!$C$15","v":"Project A"},{"$f":"[2]Instructions!$C$15","v":"Project A"},{"$f":"[2]Instructions!$C$15","v":"Project A"},{"$f":"[2]Instructions!$C$15","v":"Project A"}]
["DEVELOPER/SPONSOR",null,{"$f":"[2]Instructions!$C$16","v":"Apex Developers"},{"$f":"[2]Instructions!$C$16","v":"Apex Developers"},{"$f":"[2]Instructions!$C$16","v":"Apex Developers"},{"$f":"[2]Instructions!$C$16","v":"Apex Developers"},{"$f":"[2]Instructions!$C$16","v":"Apex Developers"}]
[]
["For-Sale Development Budget with"]
["Permanent Sources"]
[null,null,null,null,null,null,null,null,{"$f":"ROW([2]Program!$K$8)","v":8},null,null,null,null,null,null,null,null,null,{"$f":"I7+1","v":9},null,null,null,null,null,null,null,null,null,{"$f":"S7+1","v":10},null,null,null,null,null,null,null,null,null,{"$f":"AC7+1","v":11},null,null,null,null,null,null,null,null,null,{"$f":"AM7+1","v":12},null,null,null,null,null,null,null,null,null,{"$f":"AW7+1","v":13},null,null,null,null,null,null,null,null,null,{"$f":"BG7+1","v":14},null,null,null,null,null,null,null,null,null,{"$f":"BQ7+1","v":15},null,null,null,null,null,null,null,null,null,{"$f":"CA7+1","v":16},null,null,null,null,null,null,null,null,null,{"$f":"CK7+1","v":17}]
["SUMMARY",null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Type \",INDIRECT(\"program!j\"&I7),\": \",INDIRECT(\"Program!K\"&I7))","v":"Type A: 2B 2ba, East Liberty"},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Type \",INDIRECT(\"program!j\"&S7),\": \",INDIRECT(\"Program!K\"&S7))","v":"Type B: 3B 2ba, East Liberty"},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Type \",INDIRECT(\"program!j\"&AC7),\": \",INDIRECT(\"Program!K\"&AC7))","v":"Type C: 2B 2ba, Larimer"},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Type \",INDIRECT(\"program!j\"&AM7),\": \",INDIRECT(\"Program!K\"&AM7))","v":"Type D: 0"},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Type \",INDIRECT(\"program!j\"&AW7),\": \",INDIRECT(\"Program!K\"&AW7))","v":"Type E: 0"},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Type \",INDIRECT(\"program!j\"&BG7),\": \",INDIRECT(\"Program!K\"&BG7))","v":"Type F: 0"},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Type \",INDIRECT(\"program!j\"&BQ7),\": \",INDIRECT(\"Program!K\"&BQ7))","v":"Type G: 0"},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Type \",INDIRECT(\"program!j\"&CA7),\": \",INDIRECT(\"Program!K\"&CA7))","v":"Type H: 0"},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Type \",INDIRECT(\"program!j\"&CK7),\": \",INDIRECT(\"Program!K\"&CK7))","v":"Type I: 0"},null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT(\"Type \",INDIRECT(\"program!j\"&CU7),\": \",INDIRECT(\"Program!K\"&CU7))","v":"Type J: 0"}]
["Total Units",null,{"$f":"Instructions!C18","v":6},null,null,null,null,null,{"$f":"$A9","v":"Total Units"},null,{"$f":"INDIRECT(\"Program!L\"&I7)","v":2},null,null,null,null,null,null,null,{"$f":"$A9","v":"Total Units"},null,{"$f":"INDIRECT(\"Program!L\"&S7)","v":1},null,null,null,null,null,null,null,{"$f":"$A9","v":"Total Units"},null,{"$f":"INDIRECT(\"Program!L\"&AC7)","v":2},null,null,null,null,null,null,null,{"$f":"$A9","v":"Total Units"},null,{"$f":"INDIRECT(\"Program!L\"&AM7)","v":""},null,null,null,null,null,null,null,{"$f":"$A9","v":"Total Units"},null,{"$f":"INDIRECT(\"Program!L\"&AW7)","v":""},null,null,null,null,null,null,null,{"$f":"$A9","v":"Total Units"},null,{"$f":"INDIRECT(\"Program!L\"&BG7)","v":""},null,null,null,null,null,null,null,{"$f":"$A9","v":"Total Units"},null,{"$f":"INDIRECT(\"Program!L\"&BQ7)","v":""},null,null,null,null,null,null,null,{"$f":"$A9","v":"Total Units"},null,{"$f":"INDIRECT(\"Program!L\"&CA7)","v":""},null,null,null,null,null,null,null,{"$f":"$A9","v":"Total Units"},null,{"$f":"INDIRECT(\"Program!L\"&CK7)","v":""},null,null,null,null,null,null,null,{"$f":"$A9","v":"Total Units"},null,{"$f":"INDIRECT(\"Program!L\"&CU7)","v":""}]
["Total Gross SF",null,{"$f":"SUM(Program!$D$8:$D$17)","v":11400},null,null,null,null,null,{"$f":"$A10","v":"Total Gross SF"},null,{"$f":"IFERROR(INDIRECT(\"Program!M\"&I7)*'Dev Budget'!K9,\"\")","v":4400},null,null,null,null,null,null,null,{"$f":"$A10","v":"Total Gross SF"},null,{"$f":"IFERROR(INDIRECT(\"Program!M\"&S7)*'Dev Budget'!U9,\"\")","v":3000},null,null,null,null,null,null,null,{"$f":"$A10","v":"Total Gross SF"},null,{"$f":"IFERROR(INDIRECT(\"Program!M\"&AC7)*'Dev Budget'!AE9,\"\")","v":4000},null,null,null,null,null,null,null,{"$f":"$A10","v":"Total Gross SF"},null,{"$f":"IFERROR(INDIRECT(\"Program!M\"&AM7)*'Dev Budget'!AO9,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"$A10","v":"Total Gross SF"},null,{"$f":"IFERROR(INDIRECT(\"Program!M\"&AW7)*'Dev Budget'!AY9,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"$A10","v":"Total Gross SF"},null,{"$f":"IFERROR(INDIRECT(\"Program!M\"&BG7)*'Dev Budget'!BI9,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"$A10","v":"Total Gross SF"},null,{"$f":"IFERROR(INDIRECT(\"Program!M\"&BQ7)*'Dev Budget'!BS9,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"$A10","v":"Total Gross SF"},null,{"$f":"IFERROR(INDIRECT(\"Program!M\"&CA7)*'Dev Budget'!CC9,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"$A10","v":"Total Gross SF"},null,{"$f":"IFERROR(INDIRECT(\"Program!M\"&CK7)*'Dev Budget'!CM9,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"$A10","v":"Total Gross SF"},null,{"$f":"IFERROR(INDIRECT(\"Program!M\"&CU7)*'Dev Budget'!CW9,\"\")","v":""}]
[]
[null,null,null,null,"Total","Per Unit","Per Sq Ft",null,null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft",null,null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft",null,null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft",null,null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft",null,null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft",null,null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft",null,null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft",null,null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft",null,null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft",null,null,null,null,null,null,null,"Total","Per Unit","Per Sq Ft"]
["Committed Sources of Funds",null,null,null,null,null,null,null,"Committed Sources of Funds",null,null,"Detail",null,null,null,null,null,null,"Committed Sources of Funds",null,null,"Detail",null,null,null,null,null,null,"Committed Sources of Funds",null,null,"Detail",null,null,null,null,null,null,"Committed Sources of Funds",null,null,"Detail",null,null,null,null,null,null,"Committed Sources of Funds",null,null,"Detail",null,null,null,null,null,null,"Committed Sources of Funds",null,null,"Detail",null,null,null,null,null,null,"Committed Sources of Funds",null,null,"Detail",null,null,null,null,null,null,"Committed Sources of Funds",null,null,"Detail",null,null,null,null,null,null,"Committed Sources of Funds",null,null,"Detail",null,null,null,null,null,null,"Committed Sources of Funds",null,null,"Detail"]
["Permanent Financing - 1st Lien",null,null,null,{"$f":"SUM(O14,Y14,AI14,AS14,BC14,BM14,BW14,CG14,CQ14,DA14)","v":0},{"$f":"IFERROR(E14/$C$9,\"\")","v":0},{"$f":"IFERROR(E14/$C$10,\"\")","v":0},null,"Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(O14/K$9,\"\")","v":0},{"$f":"IFERROR(O14/K$10,\"\")","v":0},null,"Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(Y14/U$9,\"\")","v":0},{"$f":"IFERROR(Y14/U$10,\"\")","v":0},null,"Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(AI14/AE$9,\"\")","v":0},{"$f":"IFERROR(AI14/AE$10,\"\")","v":0},null,"Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(AS14/AO$9,\"\")","v":""},{"$f":"IFERROR(AS14/AO$10,\"\")","v":""},null,"Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(BC14/AY$9,\"\")","v":""},{"$f":"IFERROR(BC14/AY$10,\"\")","v":""},null,"Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(BM14/BI$9,\"\")","v":""},{"$f":"IFERROR(BM14/BI$10,\"\")","v":""},null,"Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(BW14/BS$9,\"\")","v":""},{"$f":"IFERROR(BW14/BS$10,\"\")","v":""},null,"Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(CG14/CC$9,\"\")","v":""},{"$f":"IFERROR(CG14/CC$10,\"\")","v":""},null,"Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(CQ14/CM$9,\"\")","v":""},{"$f":"IFERROR(CQ14/CM$10,\"\")","v":""},null,"Permanent Financing - 1st Lien",null,null,null,null,null,null,{"$f":"IFERROR(DA14/CW$9,\"\")","v":""},{"$f":"IFERROR(DA14/CW$10,\"\")","v":""}]
["Permanent Financing - 2nd Lien",null,null,null,{"$f":"SUM(O15,Y15,AI15,AS15,BC15,BM15,BW15,CG15,CQ15,DA15)","v":0},0,0,null,"Permanent Financing - 2nd Lien",null,null,null,null,null,null,{"$f":"IFERROR(O15/K$9,\"\")","v":0},{"$f":"IFERROR(O15/K$10,\"\")","v":0},null,"Permanent Financing - 2nd Lien",null,null,null,null,null,null,{"$f":"IFERROR(Y15/U$9,\"\")","v":0},{"$f":"IFERROR(Y15/U$10,\"\")","v":0},null,"Permanent Financing - 2nd Lien",null,null,null,null,null,null,{"$f":"IFERROR(AI15/AE$9,\"\")","v":0},{"$f":"IFERROR(AI15/AE$10,\"\")","v":0},null,"Permanent Financing - 2nd Lien",null,null,null,null,null,null,{"$f":"IFERROR(AS15/AO$9,\"\")","v":""},{"$f":"IFERROR(AS15/AO$10,\"\")","v":""},null,"Permanent Financing - 2nd Lien",null,null,null,null,null,null,{"$f":"IFERROR(BC15/AY$9,\"\")","v":""},{"$f":"IFERROR(BC15/AY$10,\"\")","v":""},null,"Permanent Financing - 2nd Lien",null,null,null,null,null,null,{"$f":"IFERROR(BM15/BI$9,\"\")","v":""},{"$f":"IFERROR(BM15/BI$10,\"\")","v":""},null,"Permanent Financing - 2nd Lien",null,null,null,null,null,null,{"$f":"IFERROR(BW15/BS$9,\"\")","v":""},{"$f":"IFERROR(BW15/BS$10,\"\")","v":""},null,"Permanent Financing - 2nd Lien",null,null,null,null,null,null,{"$f":"IFERROR(CG15/CC$9,\"\")","v":""},{"$f":"IFERROR(CG15/CC$10,\"\")","v":""},null,"Permanent Financing - 2nd Lien",null,null,null,null,null,null,{"$f":"IFERROR(CQ15/CM$9,\"\")","v":""},{"$f":"IFERROR(CQ15/CM$10,\"\")","v":""},null,"Permanent Financing - 2nd Lien",null,null,null,null,null,null,{"$f":"IFERROR(DA15/CW$9,\"\")","v":""},{"$f":"IFERROR(DA15/CW$10,\"\")","v":""}]
["Other:",null,null,null,0,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"",""]
["Other: ",null,null,null,0,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"",""]
["Total Committed Sources of Funds",null,null,null,{"$f":"SUM(E14:E17)","v":0},{"$f":"SUM(F14:F17)","v":0},{"$f":"SUM(G14:G17)","v":0},null,"Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(O14:O17)","v":0},{"$f":"SUM(P14:P17)","v":0},{"$f":"SUM(Q14:Q17)","v":0},null,"Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(Y14:Y17)","v":0},{"$f":"SUM(Z14:Z17)","v":0},{"$f":"SUM(AA14:AA17)","v":0},null,"Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(AI14:AI17)","v":0},{"$f":"SUM(AJ14:AJ17)","v":0},{"$f":"SUM(AK14:AK17)","v":0},null,"Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(AS14:AS17)","v":0},{"$f":"SUM(AT14:AT17)","v":0},{"$f":"SUM(AU14:AU17)","v":0},null,"Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(BC14:BC17)","v":0},{"$f":"SUM(BD14:BD17)","v":0},{"$f":"SUM(BE14:BE17)","v":0},null,"Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(BM14:BM17)","v":0},{"$f":"SUM(BN14:BN17)","v":0},{"$f":"SUM(BO14:BO17)","v":0},null,"Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(BW14:BW17)","v":0},{"$f":"SUM(BX14:BX17)","v":0},{"$f":"SUM(BY14:BY17)","v":0},null,"Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(CG14:CG17)","v":0},{"$f":"SUM(CH14:CH17)","v":0},{"$f":"SUM(CI14:CI17)","v":0},null,"Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(CQ14:CQ17)","v":0},{"$f":"SUM(CR14:CR17)","v":0},{"$f":"SUM(CS14:CS17)","v":0},null,"Total Committed Sources of Funds",null,null,null,null,null,{"$f":"SUM(DA14:DA17)","v":0},{"$f":"SUM(DB14:DB17)","v":0},{"$f":"SUM(DC14:DC17)","v":0}]
[]
["Pending/Proposed Sources of Funds",null,null,null,null,null,null,null,"Pending/Proposed Sources of Funds",null,null,null,null,null,null,null,null,null,"Pending/Proposed Sources of Funds",null,null,null,null,null,null,null,null,null,"Pending/Proposed Sources of Funds",null,null,null,null,null,null,null,null,null,"Pending/Proposed Sources of Funds",null,null,null,null,null,null,null,null,null,"Pending/Proposed Sources of Funds",null,null,null,null,null,null,null,null,null,"Pending/Proposed Sources of Funds",null,null,null,null,null,null,null,null,null,"Pending/Proposed Sources of Funds",null,null,null,null,null,null,null,null,null,"Pending/Proposed Sources of Funds",null,null,null,null,null,null,null,null,null,"Pending/Proposed Sources of Funds",null,null,null,null,null,null,null,null,null,"Pending/Proposed Sources of Funds"]
["EEHDP Request",null,null,null,{"$f":"SUM(O21,Y21,AI21,AS21,BC21,BM21,BW21,CG21,CQ21,DA21)","v":0},{"$f":"IFERROR(E21/C9,\"\")","v":0},{"$f":"IFERROR(E21/$C$10,\"\")","v":0},null,"EEHDP Request",null,null,null,null,null,null,{"$f":"IFERROR(O21/K$9,\"\")","v":0},{"$f":"IFERROR(O21/K$10,\"\")","v":0},null,"EEHDP Request",null,null,null,null,null,null,{"$f":"IFERROR(Y21/U$9,\"\")","v":0},{"$f":"IFERROR(Y21/U$10,\"\")","v":0},null,"EEHDP Request",null,null,null,null,null,null,{"$f":"IFERROR(AI21/AE$9,\"\")","v":0},{"$f":"IFERROR(AI21/AE$10,\"\")","v":0},null,"EEHDP Request",null,null,null,null,null,null,{"$f":"IFERROR(AS21/AO$9,\"\")","v":""},{"$f":"IFERROR(AS21/AO$10,\"\")","v":""},null,"EEHDP Request",null,null,null,null,null,null,{"$f":"IFERROR(BC21/AY$9,\"\")","v":""},{"$f":"IFERROR(BC21/AY$10,\"\")","v":""},null,"EEHDP Request",null,null,null,null,null,null,{"$f":"IFERROR(BM21/BI$9,\"\")","v":""},{"$f":"IFERROR(BM21/BI$10,\"\")","v":""},null,"EEHDP Request",null,null,null,null,null,null,{"$f":"IFERROR(BW21/BS$9,\"\")","v":""},{"$f":"IFERROR(BW21/BS$10,\"\")","v":""},null,"EEHDP Request",null,null,null,null,null,null,{"$f":"IFERROR(CG21/CC$9,\"\")","v":""},{"$f":"IFERROR(CG21/CC$10,\"\")","v":""},null,"EEHDP Request",null,null,null,null,null,null,{"$f":"IFERROR(CQ21/CM$9,\"\")","v":""},{"$f":"IFERROR(CQ21/CM$10,\"\")","v":""},null,"EEHDP Request",null,null,null,null,null,null,{"$f":"IFERROR(DA21/CW$9,\"\")","v":""},{"$f":"IFERROR(DA21/CW$10,\"\")","v":""}]
["FHLB",null,null,null,0,{"$f":"IFERROR(E22/$C$9,\"\")","v":0},0,null,"FHLB",null,null,null,null,null,null,0,0,null,"FHLB",null,null,null,null,null,null,0,0,null,"FHLB",null,null,null,null,null,null,0,0,null,"FHLB",null,null,null,null,null,null,"","",null,"FHLB",null,null,null,null,null,null,"","",null,"FHLB",null,null,null,null,null,null,"","",null,"FHLB",null,null,null,null,null,null,"","",null,"FHLB",null,null,null,null,null,null,"","",null,"FHLB",null,null,null,null,null,null,"","",null,"FHLB",null,null,null,null,null,null,"",""]
["Other:",null,null,null,0,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"",""]
["Other:",null,null,null,0,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"",""]
["Total Pending/Proposed Sources of Funds",null,null,null,{"$f":"SUM(E21:E24)","v":0},{"$f":"SUM(F21:F24)","v":0},{"$f":"SUM(G21:G24)","v":0},null,"Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(O21:O24)","v":0},{"$f":"SUM(P21:P24)","v":0},{"$f":"SUM(Q21:Q24)","v":0},null,"Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(Y21:Y24)","v":0},{"$f":"SUM(Z21:Z24)","v":0},{"$f":"SUM(AA21:AA24)","v":0},null,"Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(AI21:AI24)","v":0},{"$f":"SUM(AJ21:AJ24)","v":0},{"$f":"SUM(AK21:AK24)","v":0},null,"Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(AS21:AS24)","v":0},{"$f":"SUM(AT21:AT24)","v":0},{"$f":"SUM(AU21:AU24)","v":0},null,"Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(BC21:BC24)","v":0},{"$f":"SUM(BD21:BD24)","v":0},{"$f":"SUM(BE21:BE24)","v":0},null,"Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(BM21:BM24)","v":0},{"$f":"SUM(BN21:BN24)","v":0},{"$f":"SUM(BO21:BO24)","v":0},null,"Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(BW21:BW24)","v":0},{"$f":"SUM(BX21:BX24)","v":0},{"$f":"SUM(BY21:BY24)","v":0},null,"Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(CG21:CG24)","v":0},{"$f":"SUM(CH21:CH24)","v":0},{"$f":"SUM(CI21:CI24)","v":0},null,"Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(CQ21:CQ24)","v":0},{"$f":"SUM(CR21:CR24)","v":0},{"$f":"SUM(CS21:CS24)","v":0},null,"Total Pending/Proposed Sources of Funds",null,null,null,null,null,{"$f":"SUM(DA21:DA24)","v":0},{"$f":"SUM(DB21:DB24)","v":0},{"$f":"SUM(DC21:DC24)","v":0}]
[]
["Total Sources of Funds",null,null,null,{"$f":"SUM(E25,E18)","v":0},{"$f":"SUM(F25,F18)","v":0},{"$f":"SUM(G25,G18)","v":0},null,"Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(O25,O18)","v":0},{"$f":"SUM(P25,P18)","v":0},{"$f":"SUM(Q25,Q18)","v":0},null,"Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(Y25,Y18)","v":0},{"$f":"SUM(Z25,Z18)","v":0},{"$f":"SUM(AA25,AA18)","v":0},null,"Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(AI25,AI18)","v":0},{"$f":"SUM(AJ25,AJ18)","v":0},{"$f":"SUM(AK25,AK18)","v":0},null,"Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(AS25,AS18)","v":0},{"$f":"SUM(AT25,AT18)","v":0},{"$f":"SUM(AU25,AU18)","v":0},null,"Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(BC25,BC18)","v":0},{"$f":"SUM(BD25,BD18)","v":0},{"$f":"SUM(BE25,BE18)","v":0},null,"Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(BM25,BM18)","v":0},{"$f":"SUM(BN25,BN18)","v":0},{"$f":"SUM(BO25,BO18)","v":0},null,"Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(BW25,BW18)","v":0},{"$f":"SUM(BX25,BX18)","v":0},{"$f":"SUM(BY25,BY18)","v":0},null,"Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(CG25,CG18)","v":0},{"$f":"SUM(CH25,CH18)","v":0},{"$f":"SUM(CI25,CI18)","v":0},null,"Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(CQ25,CQ18)","v":0},{"$f":"SUM(CR25,CR18)","v":0},{"$f":"SUM(CS25,CS18)","v":0},null,"Total Sources of Funds",null,null,null,null,null,{"$f":"SUM(DA25,DA18)","v":0},{"$f":"SUM(DB25,DB18)","v":0},{"$f":"SUM(DC25,DC18)","v":0}]
[]
[]
["Uses of Funds",null,null,null,null,null,null,null,"Uses of Funds",null,null,null,null,null,null,null,null,null,"Uses of Funds",null,null,null,null,null,null,null,null,null,"Uses of Funds",null,null,null,null,null,null,null,null,null,"Uses of Funds",null,null,null,null,null,null,null,null,null,"Uses of Funds",null,null,null,null,null,null,null,null,null,"Uses of Funds",null,null,null,null,null,null,null,null,null,"Uses of Funds",null,null,null,null,null,null,null,null,null,"Uses of Funds",null,null,null,null,null,null,null,null,null,"Uses of Funds",null,null,null,null,null,null,null,null,null,"Uses of Funds"]
[]
["Acquisition",null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,"Acquisition",null,null,null,null,null,null,null,null,null,"Acquisition"]
["Purchase Price",null,null,null,{"$f":"SUM(O33,Y33,AI33,AS33,BC33,BM33,BW33,CG33,CQ33,DA33)","v":0},{"$f":"IFERROR(E33/$C$9,\"\")","v":0},{"$f":"IFERROR(E33/$C$10,\"\")","v":0},null,"Purchase Price",null,null,null,null,null,null,{"$f":"IFERROR(O33/K$9,\"\")","v":0},{"$f":"IFERROR(O33/K$10,\"\")","v":0},null,"Purchase Price",null,null,null,null,null,null,{"$f":"IFERROR(Y33/U$9,\"\")","v":0},{"$f":"IFERROR(Y33/U$10,\"\")","v":0},null,"Purchase Price",null,null,null,null,null,null,{"$f":"IFERROR(AI33/AE$9,\"\")","v":0},{"$f":"IFERROR(AI33/AE$10,\"\")","v":0},null,"Purchase Price",null,null,null,null,null,null,{"$f":"IFERROR(AS33/AO$9,\"\")","v":""},{"$f":"IFERROR(AS33/AO$10,\"\")","v":""},null,"Purchase Price",null,null,null,null,null,null,{"$f":"IFERROR(BC33/AY$9,\"\")","v":""},{"$f":"IFERROR(BC33/AY$10,\"\")","v":""},null,"Purchase Price",null,null,null,null,null,null,{"$f":"IFERROR(BM33/BI$9,\"\")","v":""},{"$f":"IFERROR(BM33/BI$10,\"\")","v":""},null,"Purchase Price",null,null,null,null,null,null,{"$f":"IFERROR(BW33/BS$9,\"\")","v":""},{"$f":"IFERROR(BW33/BS$10,\"\")","v":""},null,"Purchase Price",null,null,null,null,null,null,{"$f":"IFERROR(CG33/CC$9,\"\")","v":""},{"$f":"IFERROR(CG33/CC$10,\"\")","v":""},null,"Purchase Price",null,null,null,null,null,null,{"$f":"IFERROR(CQ33/CM$9,\"\")","v":""},{"$f":"IFERROR(CQ33/CM$10,\"\")","v":""},null,"Purchase Price",null,null,null,null,null,null,{"$f":"IFERROR(DA33/CW$9,\"\")","v":""},{"$f":"IFERROR(DA33/CW$10,\"\")","v":""}]
["Hand Money",null,null,null,0,0,0,null,"Hand Money",null,null,null,null,null,null,0,0,null,"Hand Money",null,null,null,null,null,null,0,0,null,"Hand Money",null,null,null,null,null,null,0,0,null,"Hand Money",null,null,null,null,null,null,"","",null,"Hand Money",null,null,null,null,null,null,"","",null,"Hand Money",null,null,null,null,null,null,"","",null,"Hand Money",null,null,null,null,null,null,"","",null,"Hand Money",null,null,null,null,null,null,"","",null,"Hand Money",null,null,null,null,null,null,"","",null,"Hand Money",null,null,null,null,null,null,"",""]
["Appraisal Costs",null,null,null,0,0,0,null,"Appraisal Costs",null,null,null,null,null,null,0,0,null,"Appraisal Costs",null,null,null,null,null,null,0,0,null,"Appraisal Costs",null,null,null,null,null,null,0,0,null,"Appraisal Costs",null,null,null,null,null,null,"","",null,"Appraisal Costs",null,null,null,null,null,null,"","",null,"Appraisal Costs",null,null,null,null,null,null,"","",null,"Appraisal Costs",null,null,null,null,null,null,"","",null,"Appraisal Costs",null,null,null,null,null,null,"","",null,"Appraisal Costs",null,null,null,null,null,null,"","",null,"Appraisal Costs",null,null,null,null,null,null,"",""]
["Closing Fees",null,null,null,0,0,0,null,"Closing Fees",null,null,null,null,null,null,0,0,null,"Closing Fees",null,null,null,null,null,null,0,0,null,"Closing Fees",null,null,null,null,null,null,0,0,null,"Closing Fees",null,null,null,null,null,null,"","",null,"Closing Fees",null,null,null,null,null,null,"","",null,"Closing Fees",null,null,null,null,null,null,"","",null,"Closing Fees",null,null,null,null,null,null,"","",null,"Closing Fees",null,null,null,null,null,null,"","",null,"Closing Fees",null,null,null,null,null,null,"","",null,"Closing Fees",null,null,null,null,null,null,"",""]
["Title Insurance",null,null,null,0,0,0,null,"Title Insurance",null,null,null,null,null,null,0,0,null,"Title Insurance",null,null,null,null,null,null,0,0,null,"Title Insurance",null,null,null,null,null,null,0,0,null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"",""]
["Title Search",null,null,null,0,0,0,null,"Title Search",null,null,null,null,null,null,0,0,null,"Title Search",null,null,null,null,null,null,0,0,null,"Title Search",null,null,null,null,null,null,0,0,null,"Title Search",null,null,null,null,null,null,"","",null,"Title Search",null,null,null,null,null,null,"","",null,"Title Search",null,null,null,null,null,null,"","",null,"Title Search",null,null,null,null,null,null,"","",null,"Title Search",null,null,null,null,null,null,"","",null,"Title Search",null,null,null,null,null,null,"","",null,"Title Search",null,null,null,null,null,null,"",""]
["Transfer Taxes",null,null,null,0,0,0,null,"Transfer Taxes",null,null,null,null,null,null,0,0,null,"Transfer Taxes",null,null,null,null,null,null,0,0,null,"Transfer Taxes",null,null,null,null,null,null,0,0,null,"Transfer Taxes",null,null,null,null,null,null,"","",null,"Transfer Taxes",null,null,null,null,null,null,"","",null,"Transfer Taxes",null,null,null,null,null,null,"","",null,"Transfer Taxes",null,null,null,null,null,null,"","",null,"Transfer Taxes",null,null,null,null,null,null,"","",null,"Transfer Taxes",null,null,null,null,null,null,"","",null,"Transfer Taxes",null,null,null,null,null,null,"",""]
["Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,0,0,0,null,"Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,null,null,null,0,0,null,"Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,null,null,null,0,0,null,"Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,null,null,null,0,0,null,"Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,null,null,null,"","",null,"Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,null,null,null,"","",null,"Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,null,null,null,"","",null,"Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,null,null,null,"","",null,"Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,null,null,null,"","",null,"Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,null,null,null,"","",null,"Financing Fee - EEHDP (2% of EEHDP funding)",null,null,null,null,null,null,"",""]
["Financing Fee - Bank",null,null,null,0,0,0,null,"Financing Fee - Bank",null,null,null,null,null,null,0,0,null,"Financing Fee - Bank",null,null,null,null,null,null,0,0,null,"Financing Fee - Bank",null,null,null,null,null,null,0,0,null,"Financing Fee - Bank",null,null,null,null,null,null,"","",null,"Financing Fee - Bank",null,null,null,null,null,null,"","",null,"Financing Fee - Bank",null,null,null,null,null,null,"","",null,"Financing Fee - Bank",null,null,null,null,null,null,"","",null,"Financing Fee - Bank",null,null,null,null,null,null,"","",null,"Financing Fee - Bank",null,null,null,null,null,null,"","",null,"Financing Fee - Bank",null,null,null,null,null,null,"",""]
["Other:",null,null,null,0,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"",""]
["Other: ",null,null,null,0,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"",""]
["Total Acquisition",null,null,null,{"$f":"SUM(E33:E43)","v":0},{"$f":"SUM(F33:F43)","v":0},{"$f":"SUM(G33:G43)","v":0},null,"Total Acquisition",null,null,null,null,null,{"$f":"SUM(O33:O43)","v":0},{"$f":"SUM(P33:P43)","v":0},{"$f":"SUM(Q33:Q43)","v":0},null,"Total Acquisition",null,null,null,null,null,{"$f":"SUM(Y33:Y43)","v":0},{"$f":"SUM(Z33:Z43)","v":0},{"$f":"SUM(AA33:AA43)","v":0},null,"Total Acquisition",null,null,null,null,null,{"$f":"SUM(AI33:AI43)","v":0},{"$f":"SUM(AJ33:AJ43)","v":0},{"$f":"SUM(AK33:AK43)","v":0},null,"Total Acquisition",null,null,null,null,null,{"$f":"SUM(AS33:AS43)","v":0},{"$f":"SUM(AT33:AT43)","v":0},{"$f":"SUM(AU33:AU43)","v":0},null,"Total Acquisition",null,null,null,null,null,{"$f":"SUM(BC33:BC43)","v":0},{"$f":"SUM(BD33:BD43)","v":0},{"$f":"SUM(BE33:BE43)","v":0},null,"Total Acquisition",null,null,null,null,null,{"$f":"SUM(BM33:BM43)","v":0},{"$f":"SUM(BN33:BN43)","v":0},{"$f":"SUM(BO33:BO43)","v":0},null,"Total Acquisition",null,null,null,null,null,{"$f":"SUM(BW33:BW43)","v":0},{"$f":"SUM(BX33:BX43)","v":0},{"$f":"SUM(BY33:BY43)","v":0},null,"Total Acquisition",null,null,null,null,null,{"$f":"SUM(CG33:CG43)","v":0},{"$f":"SUM(CH33:CH43)","v":0},{"$f":"SUM(CI33:CI43)","v":0},null,"Total Acquisition",null,null,null,null,null,{"$f":"SUM(CQ33:CQ43)","v":0},{"$f":"SUM(CR33:CR43)","v":0},{"$f":"SUM(CS33:CS43)","v":0},null,"Total Acquisition",null,null,null,null,null,{"$f":"SUM(DA33:DA43)","v":0},{"$f":"SUM(DB33:DB43)","v":0},{"$f":"SUM(DC33:DC43)","v":0}]
[]
["Hard Costs",null,null,null,null,null,null,null,"Hard Costs",null,null,null,null,null,null,null,null,null,"Hard Costs",null,null,null,null,null,null,null,null,null,"Hard Costs",null,null,null,null,null,null,null,null,null,"Hard Costs",null,null,null,null,null,null,null,null,null,"Hard Costs",null,null,null,null,null,null,null,null,null,"Hard Costs",null,null,null,null,null,null,null,null,null,"Hard Costs",null,null,null,null,null,null,null,null,null,"Hard Costs",null,null,null,null,null,null,null,null,null,"Hard Costs",null,null,null,null,null,null,null,null,null,"Hard Costs"]
["General Requirements",null,null,{"$f":"IFERROR(E47/SUM(E$48:E$52),\"\")","v":""},{"$f":"SUM(O47,Y47,AI47,AS47,BC47,BM47,BW47,CG47,CQ47,DA47)","v":0},{"$f":"IFERROR(E47/$C$9,\"\")","v":0},{"$f":"IFERROR(E47/$C$10,\"\")","v":0},null,"General Requirements",null,null,null,null,{"$f":"IFERROR(O47/SUM(O$48:O$52),\"\")","v":""},null,{"$f":"IFERROR(O47/K$9,\"\")","v":0},{"$f":"IFERROR(O47/K$10,\"\")","v":0},null,"General Requirements",null,null,null,null,{"$f":"IFERROR(Y47/SUM(Y$48:Y$52),\"\")","v":""},null,{"$f":"IFERROR(Y47/U$9,\"\")","v":0},{"$f":"IFERROR(Y47/U$10,\"\")","v":0},null,"General Requirements",null,null,null,null,{"$f":"IFERROR(AI47/SUM(AI$48:AI$52),\"\")","v":""},null,{"$f":"IFERROR(AI47/AE$9,\"\")","v":0},{"$f":"IFERROR(AI47/AE$10,\"\")","v":0},null,"General Requirements",null,null,null,null,{"$f":"IFERROR(AS47/SUM(AS$48:AS$52),\"\")","v":""},null,{"$f":"IFERROR(AS47/AO$9,\"\")","v":""},{"$f":"IFERROR(AS47/AO$10,\"\")","v":""},null,"General Requirements",null,null,null,null,{"$f":"IFERROR(BC47/SUM(BC$48:BC$52),\"\")","v":""},null,{"$f":"IFERROR(BC47/AY$9,\"\")","v":""},{"$f":"IFERROR(BC47/AY$10,\"\")","v":""},null,"General Requirements",null,null,null,null,{"$f":"IFERROR(BM47/SUM(BM$48:BM$52),\"\")","v":""},null,{"$f":"IFERROR(BM47/BI$9,\"\")","v":""},{"$f":"IFERROR(BM47/BI$10,\"\")","v":""},null,"General Requirements",null,null,null,null,{"$f":"IFERROR(BW47/SUM(BW$48:BW$52),\"\")","v":""},null,{"$f":"IFERROR(BW47/BS$9,\"\")","v":""},{"$f":"IFERROR(BW47/BS$10,\"\")","v":""},null,"General Requirements",null,null,null,null,{"$f":"IFERROR(CG47/SUM(CG$48:CG$52),\"\")","v":""},null,{"$f":"IFERROR(CG47/CC$9,\"\")","v":""},{"$f":"IFERROR(CG47/CC$10,\"\")","v":""},null,"General Requirements",null,null,null,null,{"$f":"IFERROR(CQ47/SUM(CQ$48:CQ$52),\"\")","v":""},null,{"$f":"IFERROR(CQ47/CM$9,\"\")","v":""},{"$f":"IFERROR(CQ47/CM$10,\"\")","v":""},null,"General Requirements",null,null,null,null,{"$f":"IFERROR(DA47/SUM(DA$48:DA$52),\"\")","v":""},null,{"$f":"IFERROR(DA47/CW$9,\"\")","v":""},{"$f":"IFERROR(DA47/CW$10,\"\")","v":""}]
["Demolition",null,null,null,0,0,0,null,"Demolition",null,null,null,null,null,null,0,0,null,"Demolition",null,null,null,null,null,null,0,0,null,"Demolition",null,null,null,null,null,null,0,0,null,"Demolition",null,null,null,null,null,null,"","",null,"Demolition",null,null,null,null,null,null,"","",null,"Demolition",null,null,null,null,null,null,"","",null,"Demolition",null,null,null,null,null,null,"","",null,"Demolition",null,null,null,null,null,null,"","",null,"Demolition",null,null,null,null,null,null,"","",null,"Demolition",null,null,null,null,null,null,"",""]
["Site Work",null,null,null,0,0,0,null,"Site Work",null,null,null,null,null,null,0,0,null,"Site Work",null,null,null,null,null,null,0,0,null,"Site Work",null,null,null,null,null,null,0,0,null,"Site Work",null,null,null,null,null,null,"","",null,"Site Work",null,null,null,null,null,null,"","",null,"Site Work",null,null,null,null,null,null,"","",null,"Site Work",null,null,null,null,null,null,"","",null,"Site Work",null,null,null,null,null,null,"","",null,"Site Work",null,null,null,null,null,null,"","",null,"Site Work",null,null,null,null,null,null,"",""]
["Offsite Improvements",null,null,null,0,0,0,null,"Offsite Improvements",null,null,null,null,null,null,0,0,null,"Offsite Improvements",null,null,null,null,null,null,0,0,null,"Offsite Improvements",null,null,null,null,null,null,0,0,null,"Offsite Improvements",null,null,null,null,null,null,"","",null,"Offsite Improvements",null,null,null,null,null,null,"","",null,"Offsite Improvements",null,null,null,null,null,null,"","",null,"Offsite Improvements",null,null,null,null,null,null,"","",null,"Offsite Improvements",null,null,null,null,null,null,"","",null,"Offsite Improvements",null,null,null,null,null,null,"","",null,"Offsite Improvements",null,null,null,null,null,null,"",""]
["Environmental Remediation",null,null,null,0,0,0,null,"Environmental Remediation",null,null,null,null,null,null,0,0,null,"Environmental Remediation",null,null,null,null,null,null,0,0,null,"Environmental Remediation",null,null,null,null,null,null,0,0,null,"Environmental Remediation",null,null,null,null,null,null,"","",null,"Environmental Remediation",null,null,null,null,null,null,"","",null,"Environmental Remediation",null,null,null,null,null,null,"","",null,"Environmental Remediation",null,null,null,null,null,null,"","",null,"Environmental Remediation",null,null,null,null,null,null,"","",null,"Environmental Remediation",null,null,null,null,null,null,"","",null,"Environmental Remediation",null,null,null,null,null,null,"",""]
["Construction",null,null,null,0,0,0,null,"Construction",null,null,null,null,null,null,0,0,null,"Construction",null,null,null,null,null,null,0,0,null,"Construction",null,null,null,null,null,null,0,0,null,"Construction",null,null,null,null,null,null,"","",null,"Construction",null,null,null,null,null,null,"","",null,"Construction",null,null,null,null,null,null,"","",null,"Construction",null,null,null,null,null,null,"","",null,"Construction",null,null,null,null,null,null,"","",null,"Construction",null,null,null,null,null,null,"","",null,"Construction",null,null,null,null,null,null,"",""]
["Builder's Overhead",null,null,{"$f":"IFERROR(E53/SUM(E$48:E$52),\"\")","v":""},0,0,0,null,"Builder's Overhead",null,null,null,null,{"$f":"IFERROR(O53/SUM(O$48:O$52),\"\")","v":""},null,0,0,null,"Builder's Overhead",null,null,null,null,{"$f":"IFERROR(Y53/SUM(Y$48:Y$52),\"\")","v":""},null,0,0,null,"Builder's Overhead",null,null,null,null,{"$f":"IFERROR(AI53/SUM(AI$48:AI$52),\"\")","v":""},null,0,0,null,"Builder's Overhead",null,null,null,null,{"$f":"IFERROR(AS53/SUM(AS$48:AS$52),\"\")","v":""},null,"","",null,"Builder's Overhead",null,null,null,null,{"$f":"IFERROR(BC53/SUM(BC$48:BC$52),\"\")","v":""},null,"","",null,"Builder's Overhead",null,null,null,null,{"$f":"IFERROR(BM53/SUM(BM$48:BM$52),\"\")","v":""},null,"","",null,"Builder's Overhead",null,null,null,null,{"$f":"IFERROR(BW53/SUM(BW$48:BW$52),\"\")","v":""},null,"","",null,"Builder's Overhead",null,null,null,null,{"$f":"IFERROR(CG53/SUM(CG$48:CG$52),\"\")","v":""},null,"","",null,"Builder's Overhead",null,null,null,null,{"$f":"IFERROR(CQ53/SUM(CQ$48:CQ$52),\"\")","v":""},null,"","",null,"Builder's Overhead",null,null,null,null,{"$f":"IFERROR(DA53/SUM(DA$48:DA$52),\"\")","v":""},null,"",""]
["Builder's Profit",null,null,{"$f":"IFERROR(E54/SUM(E$48:E$52),\"\")","v":""},0,0,0,null,"Builder's Profit",null,null,null,null,{"$f":"IFERROR(O54/SUM(O$48:O$52),\"\")","v":""},null,0,0,null,"Builder's Profit",null,null,null,null,{"$f":"IFERROR(Y54/SUM(Y$48:Y$52),\"\")","v":""},null,0,0,null,"Builder's Profit",null,null,null,null,{"$f":"IFERROR(AI54/SUM(AI$48:AI$52),\"\")","v":""},null,0,0,null,"Builder's Profit",null,null,null,null,{"$f":"IFERROR(AS54/SUM(AS$48:AS$52),\"\")","v":""},null,"","",null,"Builder's Profit",null,null,null,null,{"$f":"IFERROR(BC54/SUM(BC$48:BC$52),\"\")","v":""},null,"","",null,"Builder's Profit",null,null,null,null,{"$f":"IFERROR(BM54/SUM(BM$48:BM$52),\"\")","v":""},null,"","",null,"Builder's Profit",null,null,null,null,{"$f":"IFERROR(BW54/SUM(BW$48:BW$52),\"\")","v":""},null,"","",null,"Builder's Profit",null,null,null,null,{"$f":"IFERROR(CG54/SUM(CG$48:CG$52),\"\")","v":""},null,"","",null,"Builder's Profit",null,null,null,null,{"$f":"IFERROR(CQ54/SUM(CQ$48:CQ$52),\"\")","v":""},null,"","",null,"Builder's Profit",null,null,null,null,{"$f":"IFERROR(DA54/SUM(DA$48:DA$52),\"\")","v":""},null,"",""]
["Bond Premium",null,null,null,0,0,0,null,"Bond Premium",null,null,null,null,null,null,0,0,null,"Bond Premium",null,null,null,null,null,null,0,0,null,"Bond Premium",null,null,null,null,null,null,0,0,null,"Bond Premium",null,null,null,null,null,null,"","",null,"Bond Premium",null,null,null,null,null,null,"","",null,"Bond Premium",null,null,null,null,null,null,"","",null,"Bond Premium",null,null,null,null,null,null,"","",null,"Bond Premium",null,null,null,null,null,null,"","",null,"Bond Premium",null,null,null,null,null,null,"","",null,"Bond Premium",null,null,null,null,null,null,"",""]
["Building Permits",null,null,null,0,0,0,null,"Building Permits",null,null,null,null,null,null,0,0,null,"Building Permits",null,null,null,null,null,null,0,0,null,"Building Permits",null,null,null,null,null,null,0,0,null,"Building Permits",null,null,null,null,null,null,"","",null,"Building Permits",null,null,null,null,null,null,"","",null,"Building Permits",null,null,null,null,null,null,"","",null,"Building Permits",null,null,null,null,null,null,"","",null,"Building Permits",null,null,null,null,null,null,"","",null,"Building Permits",null,null,null,null,null,null,"","",null,"Building Permits",null,null,null,null,null,null,"",""]
["Other:",null,null,null,0,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"",""]
["Other: ",null,null,null,0,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"",""]
["Hard Cost Contingency (% of hard costs)",null,null,{"$f":"IFERROR(E59/SUM(E47:E58),\"\")","v":""},0,0,0,null,"Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(O59/SUM(O47:O58),\"\")","v":""},null,0,0,null,"Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(Y59/SUM(Y47:Y58),\"\")","v":""},null,0,0,null,"Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(AI59/SUM(AI47:AI58),\"\")","v":""},null,0,0,null,"Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(AS59/SUM(AS47:AS58),\"\")","v":""},null,"","",null,"Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(BC59/SUM(BC47:BC58),\"\")","v":""},null,"","",null,"Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(BM59/SUM(BM47:BM58),\"\")","v":""},null,"","",null,"Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(BW59/SUM(BW47:BW58),\"\")","v":""},null,"","",null,"Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(CG59/SUM(CG47:CG58),\"\")","v":""},null,"","",null,"Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(CQ59/SUM(CQ47:CQ58),\"\")","v":""},null,"","",null,"Hard Cost Contingency (% of hard costs)",null,null,null,null,{"$f":"IFERROR(DA59/SUM(DA47:DA58),\"\")","v":""},null,"",""]
["Total Hard Costs",null,null,null,{"$f":"SUM(E47:E59)","v":0},{"$f":"SUM(F47:F59)","v":0},{"$f":"SUM(G47:G59)","v":0},null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(O47:O59)","v":0},{"$f":"SUM(P47:P59)","v":0},{"$f":"SUM(Q47:Q59)","v":0},null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(Y47:Y59)","v":0},{"$f":"SUM(Z47:Z59)","v":0},{"$f":"SUM(AA47:AA59)","v":0},null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(AI47:AI59)","v":0},{"$f":"SUM(AJ47:AJ59)","v":0},{"$f":"SUM(AK47:AK59)","v":0},null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(AS47:AS59)","v":0},{"$f":"SUM(AT47:AT59)","v":0},{"$f":"SUM(AU47:AU59)","v":0},null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(BC47:BC59)","v":0},{"$f":"SUM(BD47:BD59)","v":0},{"$f":"SUM(BE47:BE59)","v":0},null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(BM47:BM59)","v":0},{"$f":"SUM(BN47:BN59)","v":0},{"$f":"SUM(BO47:BO59)","v":0},null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(BW47:BW59)","v":0},{"$f":"SUM(BX47:BX59)","v":0},{"$f":"SUM(BY47:BY59)","v":0},null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(CG47:CG59)","v":0},{"$f":"SUM(CH47:CH59)","v":0},{"$f":"SUM(CI47:CI59)","v":0},null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(CQ47:CQ59)","v":0},{"$f":"SUM(CR47:CR59)","v":0},{"$f":"SUM(CS47:CS59)","v":0},null,"Total Hard Costs",null,null,null,null,null,{"$f":"SUM(DA47:DA59)","v":0},{"$f":"SUM(DB47:DB59)","v":0},{"$f":"SUM(DC47:DC59)","v":0}]
[]
["Fees",null,null,null,null,null,null,null,"Fees",null,null,null,null,null,null,null,null,null,"Fees",null,null,null,null,null,null,null,null,null,"Fees",null,null,null,null,null,null,null,null,null,"Fees",null,null,null,null,null,null,null,null,null,"Fees",null,null,null,null,null,null,null,null,null,"Fees",null,null,null,null,null,null,null,null,null,"Fees",null,null,null,null,null,null,null,null,null,"Fees",null,null,null,null,null,null,null,null,null,"Fees",null,null,null,null,null,null,null,null,null,"Fees"]
["Developer Fee ",null,null,{"$f":"IFERROR(E63/(E108-E106),\"\")","v":0},{"$f":"SUM(O63,Y63,AI63,AS63,BC63,BM63,BW63,CG63,CQ63,DA63)","v":0},{"$f":"IFERROR(E63/$C$9,\"\")","v":0},{"$f":"IFERROR(E63/$C$10,\"\")","v":0},null,"Developer Fee ",null,null,null,null,{"$f":"IFERROR(O63/(O108-O106),\"\")","v":0},null,{"$f":"IFERROR(O63/K$9,\"\")","v":0},{"$f":"IFERROR(O63/K$10,\"\")","v":0},null,"Developer Fee ",null,null,null,null,{"$f":"IFERROR(Y63/(Y108-Y106),\"\")","v":""},null,{"$f":"IFERROR(Y63/U$9,\"\")","v":0},{"$f":"IFERROR(Y63/U$10,\"\")","v":0},null,"Developer Fee ",null,null,null,null,{"$f":"IFERROR(AI63/(AI108-AI106),\"\")","v":""},null,{"$f":"IFERROR(AI63/AE$9,\"\")","v":0},{"$f":"IFERROR(AI63/AE$10,\"\")","v":0},null,"Developer Fee ",null,null,null,null,{"$f":"IFERROR(AS63/(AS108-AS106),\"\")","v":""},null,{"$f":"IFERROR(AS63/AO$9,\"\")","v":""},{"$f":"IFERROR(AS63/AO$10,\"\")","v":""},null,"Developer Fee ",null,null,null,null,{"$f":"IFERROR(BC63/(BC108-BC106),\"\")","v":""},null,{"$f":"IFERROR(BC63/AY$9,\"\")","v":""},{"$f":"IFERROR(BC63/AY$10,\"\")","v":""},null,"Developer Fee ",null,null,null,null,{"$f":"IFERROR(BM63/(BM108-BM106),\"\")","v":""},null,{"$f":"IFERROR(BM63/BI$9,\"\")","v":""},{"$f":"IFERROR(BM63/BI$10,\"\")","v":""},null,"Developer Fee ",null,null,null,null,{"$f":"IFERROR(BW63/(BW108-BW106),\"\")","v":""},null,{"$f":"IFERROR(BW63/BS$9,\"\")","v":""},{"$f":"IFERROR(BW63/BS$10,\"\")","v":""},null,"Developer Fee ",null,null,null,null,{"$f":"IFERROR(CG63/(CG108-CG106),\"\")","v":""},null,{"$f":"IFERROR(CG63/CC$9,\"\")","v":""},{"$f":"IFERROR(CG63/CC$10,\"\")","v":""},null,"Developer Fee ",null,null,null,null,{"$f":"IFERROR(CQ63/(CQ108-CQ106),\"\")","v":""},null,{"$f":"IFERROR(CQ63/CM$9,\"\")","v":""},{"$f":"IFERROR(CQ63/CM$10,\"\")","v":""},null,"Developer Fee ",null,null,null,null,{"$f":"IFERROR(DA63/(DA108-DA106),\"\")","v":""},null,{"$f":"IFERROR(DA63/CW$9,\"\")","v":""},{"$f":"IFERROR(DA63/CW$10,\"\")","v":""}]
["Architectural Fee (Design & Admin)",null,null,null,0,{"$f":"IFERROR(E64/$C$9,\"\")","v":0},0,null,"Architectural Fee (Design & Admin)",null,null,null,null,null,null,0,0,null,"Architectural Fee (Design & Admin)",null,null,null,null,null,null,0,0,null,"Architectural Fee (Design & Admin)",null,null,null,null,null,null,0,0,null,"Architectural Fee (Design & Admin)",null,null,null,null,null,null,"","",null,"Architectural Fee (Design & Admin)",null,null,null,null,null,null,"","",null,"Architectural Fee (Design & Admin)",null,null,null,null,null,null,"","",null,"Architectural Fee (Design & Admin)",null,null,null,null,null,null,"","",null,"Architectural Fee (Design & Admin)",null,null,null,null,null,null,"","",null,"Architectural Fee (Design & Admin)",null,null,null,null,null,null,"","",null,"Architectural Fee (Design & Admin)",null,null,null,null,null,null,"",""]
["Legal",null,null,null,0,0,0,null,"Legal",null,null,null,null,null,null,0,0,null,"Legal",null,null,null,null,null,null,0,0,null,"Legal",null,null,null,null,null,null,0,0,null,"Legal",null,null,null,null,null,null,"","",null,"Legal",null,null,null,null,null,null,"","",null,"Legal",null,null,null,null,null,null,"","",null,"Legal",null,null,null,null,null,null,"","",null,"Legal",null,null,null,null,null,null,"","",null,"Legal",null,null,null,null,null,null,"","",null,"Legal",null,null,null,null,null,null,"",""]
["   Civil Engineering & Survey",null,null,null,0,0,0,null,"   Civil Engineering & Survey",null,null,null,null,null,null,0,0,null,"   Civil Engineering & Survey",null,null,null,null,null,null,0,0,null,"   Civil Engineering & Survey",null,null,null,null,null,null,0,0,null,"   Civil Engineering & Survey",null,null,null,null,null,null,"","",null,"   Civil Engineering & Survey",null,null,null,null,null,null,"","",null,"   Civil Engineering & Survey",null,null,null,null,null,null,"","",null,"   Civil Engineering & Survey",null,null,null,null,null,null,"","",null,"   Civil Engineering & Survey",null,null,null,null,null,null,"","",null,"   Civil Engineering & Survey",null,null,null,null,null,null,"","",null,"   Civil Engineering & Survey",null,null,null,null,null,null,"",""]
["Design & Permitting (% of const exp)",null,null,{"$f":"IFERROR((E66)/SUM(E47:E54),\"\")","v":""},100000,16666.666666666668,8.7719298245614041,null,"Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((O67)/SUM(O47:O54),\"\")","v":""},100000,50000,22.727272727272727,null,"Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((Y67)/SUM(Y47:Y54),\"\")","v":""},null,0,0,null,"Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((AI67)/SUM(AI47:AI54),\"\")","v":""},null,0,0,null,"Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((AS67)/SUM(AS47:AS54),\"\")","v":""},null,"","",null,"Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((BC67)/SUM(BC47:BC54),\"\")","v":""},null,"","",null,"Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((BM67)/SUM(BM47:BM54),\"\")","v":""},null,"","",null,"Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((BW67)/SUM(BW47:BW54),\"\")","v":""},null,"","",null,"Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((CG67)/SUM(CG47:CG54),\"\")","v":""},null,"","",null,"Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((CQ67)/SUM(CQ47:CQ54),\"\")","v":""},null,"","",null,"Design & Permitting (% of const exp)",null,null,null,null,{"$f":"IFERROR((DA67)/SUM(DA47:DA54),\"\")","v":""},null,"",""]
["Soils/Structural Report",null,null,null,0,0,0,null,"Soils/Structural Report",null,null,null,null,null,null,0,0,null,"Soils/Structural Report",null,null,null,null,null,null,0,0,null,"Soils/Structural Report",null,null,null,null,null,null,0,0,null,"Soils/Structural Report",null,null,null,null,null,null,"","",null,"Soils/Structural Report",null,null,null,null,null,null,"","",null,"Soils/Structural Report",null,null,null,null,null,null,"","",null,"Soils/Structural Report",null,null,null,null,null,null,"","",null,"Soils/Structural Report",null,null,null,null,null,null,"","",null,"Soils/Structural Report",null,null,null,null,null,null,"","",null,"Soils/Structural Report",null,null,null,null,null,null,"",""]
["Environmental Audit (Hazard Assessment) ",null,null,null,0,0,0,null,"Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,0,0,null,"Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,0,0,null,"Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,0,0,null,"Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,"","",null,"Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,"","",null,"Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,"","",null,"Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,"","",null,"Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,"","",null,"Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,"","",null,"Environmental Audit (Hazard Assessment) ",null,null,null,null,null,null,"",""]
["Energy & Green Audits/Consulting",null,null,null,0,0,0,null,"Energy & Green Audits/Consulting",null,null,null,null,null,null,0,0,null,"Energy & Green Audits/Consulting",null,null,null,null,null,null,0,0,null,"Energy & Green Audits/Consulting",null,null,null,null,null,null,0,0,null,"Energy & Green Audits/Consulting",null,null,null,null,null,null,"","",null,"Energy & Green Audits/Consulting",null,null,null,null,null,null,"","",null,"Energy & Green Audits/Consulting",null,null,null,null,null,null,"","",null,"Energy & Green Audits/Consulting",null,null,null,null,null,null,"","",null,"Energy & Green Audits/Consulting",null,null,null,null,null,null,"","",null,"Energy & Green Audits/Consulting",null,null,null,null,null,null,"","",null,"Energy & Green Audits/Consulting",null,null,null,null,null,null,"",""]
["Capital Needs Assessment",null,null,null,0,0,0,null,"Capital Needs Assessment",null,null,null,null,null,null,0,0,null,"Capital Needs Assessment",null,null,null,null,null,null,0,0,null,"Capital Needs Assessment",null,null,null,null,null,null,0,0,null,"Capital Needs Assessment",null,null,null,null,null,null,"","",null,"Capital Needs Assessment",null,null,null,null,null,null,"","",null,"Capital Needs Assessment",null,null,null,null,null,null,"","",null,"Capital Needs Assessment",null,null,null,null,null,null,"","",null,"Capital Needs Assessment",null,null,null,null,null,null,"","",null,"Capital Needs Assessment",null,null,null,null,null,null,"","",null,"Capital Needs Assessment",null,null,null,null,null,null,"",""]
["Appraisal",null,null,null,0,0,0,null,"Appraisal",null,null,null,null,null,null,0,0,null,"Appraisal",null,null,null,null,null,null,0,0,null,"Appraisal",null,null,null,null,null,null,0,0,null,"Appraisal",null,null,null,null,null,null,"","",null,"Appraisal",null,null,null,null,null,null,"","",null,"Appraisal",null,null,null,null,null,null,"","",null,"Appraisal",null,null,null,null,null,null,"","",null,"Appraisal",null,null,null,null,null,null,"","",null,"Appraisal",null,null,null,null,null,null,"","",null,"Appraisal",null,null,null,null,null,null,"",""]
["Market Study",null,null,null,0,0,0,null,{"$f":"$A73","v":"Market Study"},null,null,null,null,null,null,0,0,null,{"$f":"$A73","v":"Market Study"},null,null,null,null,null,null,0,0,null,{"$f":"$A73","v":"Market Study"},null,null,null,null,null,null,0,0,null,{"$f":"$A73","v":"Market Study"},null,null,null,null,null,null,"","",null,{"$f":"$A73","v":"Market Study"},null,null,null,null,null,null,"","",null,{"$f":"$A73","v":"Market Study"},null,null,null,null,null,null,"","",null,{"$f":"$A73","v":"Market Study"},null,null,null,null,null,null,"","",null,{"$f":"$A73","v":"Market Study"},null,null,null,null,null,null,"","",null,{"$f":"$A73","v":"Market Study"},null,null,null,null,null,null,"","",null,{"$f":"$A73","v":"Market Study"},null,null,null,null,null,null,"",""]
["Cost Certification ",null,null,null,0,0,0,null,"Cost Certification ",null,null,null,null,null,null,0,0,null,"Cost Certification ",null,null,null,null,null,null,0,0,null,"Cost Certification ",null,null,null,null,null,null,0,0,null,"Cost Certification ",null,null,null,null,null,null,"","",null,"Cost Certification ",null,null,null,null,null,null,"","",null,"Cost Certification ",null,null,null,null,null,null,"","",null,"Cost Certification ",null,null,null,null,null,null,"","",null,"Cost Certification ",null,null,null,null,null,null,"","",null,"Cost Certification ",null,null,null,null,null,null,"","",null,"Cost Certification ",null,null,null,null,null,null,"",""]
["Other:",null,null,null,0,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"",""]
["Other: ",null,null,null,0,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"",""]
["Total Fees",null,null,null,{"$f":"SUM(E63:E76)","v":100000},{"$f":"SUM(F63:F76)","v":16666.666666666668},{"$f":"SUM(G63:G76)","v":8.7719298245614041},null,"Total Fees",null,null,null,null,null,{"$f":"SUM(O63:O76)","v":100000},{"$f":"SUM(P63:P76)","v":50000},22.727272727272727,null,"Total Fees",null,null,null,null,null,{"$f":"SUM(Y63:Y76)","v":0},{"$f":"SUM(Z63:Z76)","v":0},0,null,"Total Fees",null,null,null,null,null,{"$f":"SUM(AI63:AI76)","v":0},{"$f":"SUM(AJ63:AJ76)","v":0},0,null,"Total Fees",null,null,null,null,null,{"$f":"SUM(AS63:AS76)","v":0},{"$f":"SUM(AT63:AT76)","v":0},0,null,"Total Fees",null,null,null,null,null,{"$f":"SUM(BC63:BC76)","v":0},{"$f":"SUM(BD63:BD76)","v":0},0,null,"Total Fees",null,null,null,null,null,{"$f":"SUM(BM63:BM76)","v":0},{"$f":"SUM(BN63:BN76)","v":0},0,null,"Total Fees",null,null,null,null,null,{"$f":"SUM(BW63:BW76)","v":0},{"$f":"SUM(BX63:BX76)","v":0},0,null,"Total Fees",null,null,null,null,null,{"$f":"SUM(CG63:CG76)","v":0},{"$f":"SUM(CH63:CH76)","v":0},0,null,"Total Fees",null,null,null,null,null,{"$f":"SUM(CQ63:CQ76)","v":0},{"$f":"SUM(CR63:CR76)","v":0},0,null,"Total Fees",null,null,null,null,null,{"$f":"SUM(DA63:DA76)","v":0},{"$f":"SUM(DB63:DB76)","v":0},0]
[]
["Miscellaneous Development Expenses",null,null,null,null,null,null,null,"Miscellaneous Development Expenses",null,null,null,null,null,null,null,null,null,"Miscellaneous Development Expenses",null,null,null,null,null,null,null,null,null,"Miscellaneous Development Expenses",null,null,null,null,null,null,null,null,null,"Miscellaneous Development Expenses",null,null,null,null,null,null,null,null,null,"Miscellaneous Development Expenses",null,null,null,null,null,null,null,null,null,"Miscellaneous Development Expenses",null,null,null,null,null,null,null,null,null,"Miscellaneous Development Expenses",null,null,null,null,null,null,null,null,null,"Miscellaneous Development Expenses",null,null,null,null,null,null,null,null,null,"Miscellaneous Development Expenses",null,null,null,null,null,null,null,null,null,"Miscellaneous Development Expenses"]
["Utility Tap, Hook Up & Municipal Fees",null,null,null,{"$f":"SUM(O80,Y80,AI80,AS80,BC80,BM80,BW80,CG80,CQ80,DA80)","v":0},{"$f":"IFERROR(E80/$C$9,\"\")","v":0},{"$f":"IFERROR(E80/$C$10,\"\")","v":0},null,"Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,{"$f":"IFERROR(O80/K$9,\"\")","v":0},{"$f":"IFERROR(O80/K$10,\"\")","v":0},null,"Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,{"$f":"IFERROR(Y80/U$9,\"\")","v":0},{"$f":"IFERROR(Y80/U$10,\"\")","v":0},null,"Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,{"$f":"IFERROR(AI80/AE$9,\"\")","v":0},{"$f":"IFERROR(AI80/AE$10,\"\")","v":0},null,"Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,{"$f":"IFERROR(AS80/AO$9,\"\")","v":""},{"$f":"IFERROR(AS80/AO$10,\"\")","v":""},null,"Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,{"$f":"IFERROR(BC80/AY$9,\"\")","v":""},{"$f":"IFERROR(BC80/AY$10,\"\")","v":""},null,"Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,{"$f":"IFERROR(BM80/BI$9,\"\")","v":""},{"$f":"IFERROR(BM80/BI$10,\"\")","v":""},null,"Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,{"$f":"IFERROR(BW80/BS$9,\"\")","v":""},{"$f":"IFERROR(BW80/BS$10,\"\")","v":""},null,"Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,{"$f":"IFERROR(CG80/CC$9,\"\")","v":""},{"$f":"IFERROR(CG80/CC$10,\"\")","v":""},null,"Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,{"$f":"IFERROR(CQ80/CM$9,\"\")","v":""},{"$f":"IFERROR(CQ80/CM$10,\"\")","v":""},null,"Utility Tap, Hook Up & Municipal Fees",null,null,null,null,null,null,{"$f":"IFERROR(DA80/CW$9,\"\")","v":""},{"$f":"IFERROR(DA80/CW$10,\"\")","v":""}]
["Other:",null,null,null,0,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"",""]
["Other: ",null,null,null,0,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"",""]
["Total Miscellaneous Development Expense",null,null,null,{"$f":"SUM(E80:E82)","v":0},{"$f":"SUM(F80:F82)","v":0},{"$f":"SUM(G80:G82)","v":0},null,"Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(O80:O82)","v":0},{"$f":"SUM(P80:P82)","v":0},{"$f":"SUM(Q80:Q82)","v":0},null,"Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(Y80:Y82)","v":0},{"$f":"SUM(Z80:Z82)","v":0},{"$f":"SUM(AA80:AA82)","v":0},null,"Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(AI80:AI82)","v":0},{"$f":"SUM(AJ80:AJ82)","v":0},{"$f":"SUM(AK80:AK82)","v":0},null,"Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(AS80:AS82)","v":0},{"$f":"SUM(AT80:AT82)","v":0},{"$f":"SUM(AU80:AU82)","v":0},null,"Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(BC80:BC82)","v":0},{"$f":"SUM(BD80:BD82)","v":0},{"$f":"SUM(BE80:BE82)","v":0},null,"Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(BM80:BM82)","v":0},{"$f":"SUM(BN80:BN82)","v":0},{"$f":"SUM(BO80:BO82)","v":0},null,"Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(BW80:BW82)","v":0},{"$f":"SUM(BX80:BX82)","v":0},{"$f":"SUM(BY80:BY82)","v":0},null,"Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(CG80:CG82)","v":0},{"$f":"SUM(CH80:CH82)","v":0},{"$f":"SUM(CI80:CI82)","v":0},null,"Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(CQ80:CQ82)","v":0},{"$f":"SUM(CR80:CR82)","v":0},{"$f":"SUM(CS80:CS82)","v":0},null,"Total Miscellaneous Development Expense",null,null,null,null,null,{"$f":"SUM(DA80:DA82)","v":0},{"$f":"SUM(DB80:DB82)","v":0},{"$f":"SUM(DC80:DC82)","v":0}]
[]
["Construction & Permanent Loan Financing Charges",null,null,null,null,null,null,null,"Construction & Permanent Loan Financing Charges",null,null,null,null,null,null,null,null,null,"Construction & Permanent Loan Financing Charges",null,null,null,null,null,null,null,null,null,"Construction & Permanent Loan Financing Charges",null,null,null,null,null,null,null,null,null,"Construction & Permanent Loan Financing Charges",null,null,null,null,null,null,null,null,null,"Construction & Permanent Loan Financing Charges",null,null,null,null,null,null,null,null,null,"Construction & Permanent Loan Financing Charges",null,null,null,null,null,null,null,null,null,"Construction & Permanent Loan Financing Charges",null,null,null,null,null,null,null,null,null,"Construction & Permanent Loan Financing Charges",null,null,null,null,null,null,null,null,null,"Construction & Permanent Loan Financing Charges",null,null,null,null,null,null,null,null,null,"Construction & Permanent Loan Financing Charges"]
["Construction Loan Interest",null,null,null,{"$f":"SUM(O86,Y86,AI86,AS86,BC86,BM86,BW86,CG86,CQ86,DA86)","v":0},{"$f":"IFERROR(E86/$C$9,\"\")","v":0},{"$f":"IFERROR(E86/$C$10,\"\")","v":0},null,"Construction Loan Interest",null,null,"(const period:",null,"months)",null,{"$f":"IFERROR(O86/K$9,\"\")","v":0},{"$f":"IFERROR(O86/K$10,\"\")","v":0},null,"Construction Loan Interest",null,null,"(const period:",null,"months)",null,{"$f":"IFERROR(Y86/U$9,\"\")","v":0},{"$f":"IFERROR(Y86/U$10,\"\")","v":0},null,"Construction Loan Interest",null,null,"(const period:",null,"months)",null,{"$f":"IFERROR(AI86/AE$9,\"\")","v":0},{"$f":"IFERROR(AI86/AE$10,\"\")","v":0},null,"Construction Loan Interest",null,null,"(const period:",null,"months)",null,{"$f":"IFERROR(AS86/AO$9,\"\")","v":""},{"$f":"IFERROR(AS86/AO$10,\"\")","v":""},null,"Construction Loan Interest",null,null,"(const period:",null,"months)",null,{"$f":"IFERROR(BC86/AY$9,\"\")","v":""},{"$f":"IFERROR(BC86/AY$10,\"\")","v":""},null,"Construction Loan Interest",null,null,"(const period:",null,"months)",null,{"$f":"IFERROR(BM86/BI$9,\"\")","v":""},{"$f":"IFERROR(BM86/BI$10,\"\")","v":""},null,"Construction Loan Interest",null,null,"(const period:",null,"months)",null,{"$f":"IFERROR(BW86/BS$9,\"\")","v":""},{"$f":"IFERROR(BW86/BS$10,\"\")","v":""},null,"Construction Loan Interest",null,null,"(const period:",null,"months)",null,{"$f":"IFERROR(CG86/CC$9,\"\")","v":""},{"$f":"IFERROR(CG86/CC$10,\"\")","v":""},null,"Construction Loan Interest",null,null,"(const period:",null,"months)",null,{"$f":"IFERROR(CQ86/CM$9,\"\")","v":""},{"$f":"IFERROR(CQ86/CM$10,\"\")","v":""},null,"Construction Loan Interest",null,null,"(const period:",null,"months)",null,{"$f":"IFERROR(DA86/CW$9,\"\")","v":""},{"$f":"IFERROR(DA86/CW$10,\"\")","v":""}]
["Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,0,0,0,null,"Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,0,0,null,"Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,0,0,null,"Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,0,0,null,"Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,"","",null,"Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,"","",null,"Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,"","",null,"Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,"","",null,"Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,"","",null,"Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,"","",null,"Construction Loan Fees (Origination, Credit Enhancement, Application)",null,null,null,null,null,null,"",""]
["Taxes During Construction",null,null,null,0,0,0,null,"Taxes During Construction",null,null,null,null,null,null,0,0,null,"Taxes During Construction",null,null,null,null,null,null,0,0,null,"Taxes During Construction",null,null,null,null,null,null,0,0,null,"Taxes During Construction",null,null,null,null,null,null,"","",null,"Taxes During Construction",null,null,null,null,null,null,"","",null,"Taxes During Construction",null,null,null,null,null,null,"","",null,"Taxes During Construction",null,null,null,null,null,null,"","",null,"Taxes During Construction",null,null,null,null,null,null,"","",null,"Taxes During Construction",null,null,null,null,null,null,"","",null,"Taxes During Construction",null,null,null,null,null,null,"",""]
["Insurance During Construction",null,null,null,0,0,0,null,"Insurance During Construction",null,null,null,null,null,null,0,0,null,"Insurance During Construction",null,null,null,null,null,null,0,0,null,"Insurance During Construction",null,null,null,null,null,null,0,0,null,"Insurance During Construction",null,null,null,null,null,null,"","",null,"Insurance During Construction",null,null,null,null,null,null,"","",null,"Insurance During Construction",null,null,null,null,null,null,"","",null,"Insurance During Construction",null,null,null,null,null,null,"","",null,"Insurance During Construction",null,null,null,null,null,null,"","",null,"Insurance During Construction",null,null,null,null,null,null,"","",null,"Insurance During Construction",null,null,null,null,null,null,"",""]
["Title Insurance",null,null,null,0,0,0,null,"Title Insurance",null,null,null,null,null,null,0,0,null,"Title Insurance",null,null,null,null,null,null,0,0,null,"Title Insurance",null,null,null,null,null,null,0,0,null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"","",null,"Title Insurance",null,null,null,null,null,null,"",""]
["Recording",null,null,null,0,0,0,null,"Recording",null,null,null,null,null,null,0,0,null,"Recording",null,null,null,null,null,null,0,0,null,"Recording",null,null,null,null,null,null,0,0,null,"Recording",null,null,null,null,null,null,"","",null,"Recording",null,null,null,null,null,null,"","",null,"Recording",null,null,null,null,null,null,"","",null,"Recording",null,null,null,null,null,null,"","",null,"Recording",null,null,null,null,null,null,"","",null,"Recording",null,null,null,null,null,null,"","",null,"Recording",null,null,null,null,null,null,"",""]
["Construction Monitoring Fee",null,null,null,0,0,0,null,"Construction Monitoring Fee",null,null,null,null,null,null,0,0,null,"Construction Monitoring Fee",null,null,null,null,null,null,0,0,null,"Construction Monitoring Fee",null,null,null,null,null,null,0,0,null,"Construction Monitoring Fee",null,null,null,null,null,null,"","",null,"Construction Monitoring Fee",null,null,null,null,null,null,"","",null,"Construction Monitoring Fee",null,null,null,null,null,null,"","",null,"Construction Monitoring Fee",null,null,null,null,null,null,"","",null,"Construction Monitoring Fee",null,null,null,null,null,null,"","",null,"Construction Monitoring Fee",null,null,null,null,null,null,"","",null,"Construction Monitoring Fee",null,null,null,null,null,null,"",""]
["Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,0,0,0,null,"Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,0,0,null,"Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,0,0,null,"Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,0,0,null,"Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,"","",null,"Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,"","",null,"Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,"","",null,"Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,"","",null,"Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,"","",null,"Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,"","",null,"Permanent Loan Fees (Origination, Reservation, Credit Enhancement)",null,null,null,null,null,null,"",""]
["Other:",null,null,null,0,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"",""]
["Other: ",null,null,null,0,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"",""]
["Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,{"$f":"IFERROR(E96/(SUM(E64:E76)+E83+SUM(E86:E95)),\"\")","v":0},0,0,0,null,"Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(O96/(SUM(O64:O76)+O83+SUM(O86:O95)),\"\")","v":0},null,0,0,null,"Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(Y96/(SUM(Y64:Y76)+Y83+SUM(Y86:Y95)),\"\")","v":""},null,0,0,null,"Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(AI96/(SUM(AI64:AI76)+AI83+SUM(AI86:AI95)),\"\")","v":""},null,0,0,null,"Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(AS96/(SUM(AS64:AS76)+AS83+SUM(AS86:AS95)),\"\")","v":""},null,"","",null,"Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(BC96/(SUM(BC64:BC76)+BC83+SUM(BC86:BC95)),\"\")","v":""},null,"","",null,"Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(BM96/(SUM(BM64:BM76)+BM83+SUM(BM86:BM95)),\"\")","v":""},null,"","",null,"Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(BW96/(SUM(BW64:BW76)+BW83+SUM(BW86:BW95)),\"\")","v":""},null,"","",null,"Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(CG96/(SUM(CG64:CG76)+CG83+SUM(CG86:CG95)),\"\")","v":""},null,"","",null,"Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(CQ96/(SUM(CQ64:CQ76)+CQ83+SUM(CQ86:CQ95)),\"\")","v":""},null,"","",null,"Soft Cost Contingency (% of soft costs excl Dev Fee)",null,null,null,null,{"$f":"IFERROR(DA96/(SUM(DA64:DA76)+DA83+SUM(DA86:DA95)),\"\")","v":""},null,"",""]
["Total Construction & Financing Charges:",null,null,null,{"$f":"SUM(E86:E96)","v":0},{"$f":"SUM(F86:F96)","v":0},{"$f":"SUM(G86:G96)","v":0},null,"Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(O86:O96)","v":0},{"$f":"SUM(P86:P96)","v":0},{"$f":"SUM(Q86:Q96)","v":0},null,"Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(Y86:Y96)","v":0},{"$f":"SUM(Z86:Z96)","v":0},{"$f":"SUM(AA86:AA96)","v":0},null,"Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(AI86:AI96)","v":0},{"$f":"SUM(AJ86:AJ96)","v":0},{"$f":"SUM(AK86:AK96)","v":0},null,"Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(AS86:AS96)","v":0},{"$f":"SUM(AT86:AT96)","v":0},{"$f":"SUM(AU86:AU96)","v":0},null,"Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(BC86:BC96)","v":0},{"$f":"SUM(BD86:BD96)","v":0},{"$f":"SUM(BE86:BE96)","v":0},null,"Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(BM86:BM96)","v":0},{"$f":"SUM(BN86:BN96)","v":0},{"$f":"SUM(BO86:BO96)","v":0},null,"Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(BW86:BW96)","v":0},{"$f":"SUM(BX86:BX96)","v":0},{"$f":"SUM(BY86:BY96)","v":0},null,"Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(CG86:CG96)","v":0},{"$f":"SUM(CH86:CH96)","v":0},{"$f":"SUM(CI86:CI96)","v":0},null,"Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(CQ86:CQ96)","v":0},{"$f":"SUM(CR86:CR96)","v":0},{"$f":"SUM(CS86:CS96)","v":0},null,"Total Construction & Financing Charges:",null,null,null,null,null,{"$f":"SUM(DA86:DA96)","v":0},{"$f":"SUM(DB86:DB96)","v":0},{"$f":"SUM(DC86:DC96)","v":0}]
[]
["Total Development Costs",null,null,null,{"$f":"SUM(E97,E83,E77,E60,E44)","v":100000},{"$f":"SUM(F97,F83,F77,F60,F44)","v":16666.666666666668},8.7719298245614041,null,"Total Development Costs",null,null,null,null,null,{"$f":"SUM(O97,O83,O77,O60,O44)","v":100000},{"$f":"SUM(P97,P83,P77,P60,P44)","v":50000},22.727272727272727,null,"Total Development Costs",null,null,null,null,null,{"$f":"SUM(Y97,Y83,Y77,Y60,Y44)","v":0},{"$f":"SUM(Z97,Z83,Z77,Z60,Z44)","v":0},0,null,"Total Development Costs",null,null,null,null,null,{"$f":"SUM(AI97,AI83,AI77,AI60,AI44)","v":0},{"$f":"SUM(AJ97,AJ83,AJ77,AJ60,AJ44)","v":0},0,null,"Total Development Costs",null,null,null,null,null,{"$f":"SUM(AS97,AS83,AS77,AS60,AS44)","v":0},{"$f":"SUM(AT97,AT83,AT77,AT60,AT44)","v":0},0,null,"Total Development Costs",null,null,null,null,null,{"$f":"SUM(BC97,BC83,BC77,BC60,BC44)","v":0},{"$f":"SUM(BD97,BD83,BD77,BD60,BD44)","v":0},0,null,"Total Development Costs",null,null,null,null,null,{"$f":"SUM(BM97,BM83,BM77,BM60,BM44)","v":0},{"$f":"SUM(BN97,BN83,BN77,BN60,BN44)","v":0},0,null,"Total Development Costs",null,null,null,null,null,{"$f":"SUM(BW97,BW83,BW77,BW60,BW44)","v":0},{"$f":"SUM(BX97,BX83,BX77,BX60,BX44)","v":0},0,null,"Total Development Costs",null,null,null,null,null,{"$f":"SUM(CG97,CG83,CG77,CG60,CG44)","v":0},{"$f":"SUM(CH97,CH83,CH77,CH60,CH44)","v":0},0,null,"Total Development Costs",null,null,null,null,null,{"$f":"SUM(CQ97,CQ83,CQ77,CQ60,CQ44)","v":0},{"$f":"SUM(CR97,CR83,CR77,CR60,CR44)","v":0},0,null,"Total Development Costs",null,null,null,null,null,{"$f":"SUM(DA97,DA83,DA77,DA60,DA44)","v":0},{"$f":"SUM(DB97,DB83,DB77,DB60,DB44)","v":0},0]
[]
["Transaction Fees",null,null,null,null,null,null,null,"Transaction Fees",null,null,null,null,null,null,null,null,null,"Transaction Fees",null,null,null,null,null,null,null,null,null,"Transaction Fees",null,null,null,null,null,null,null,null,null,"Transaction Fees",null,null,null,null,null,null,null,null,null,"Transaction Fees",null,null,null,null,null,null,null,null,null,"Transaction Fees",null,null,null,null,null,null,null,null,null,"Transaction Fees",null,null,null,null,null,null,null,null,null,"Transaction Fees",null,null,null,null,null,null,null,null,null,"Transaction Fees",null,null,null,null,null,null,null,null,null,"Transaction Fees"]
["Real Estate Agent Fee",null,null,null,{"$f":"SUM(O102,Y102,AI102,AS102,BC102,BM102,BW102,CG102,CQ102,DA102)","v":0},{"$f":"IFERROR(E102/$C$9,\"\")","v":0},{"$f":"IFERROR(E102/$C$10,\"\")","v":0},null,"Real Estate Agent Fee",null,null,null,null,null,null,{"$f":"IFERROR(O102/K$9,\"\")","v":0},{"$f":"IFERROR(O102/K$10,\"\")","v":0},null,"Real Estate Agent Fee",null,null,null,null,null,null,{"$f":"IFERROR(Y102/U$9,\"\")","v":0},{"$f":"IFERROR(Y102/U$10,\"\")","v":0},null,"Real Estate Agent Fee",null,null,null,null,null,null,{"$f":"IFERROR(AI102/AE$9,\"\")","v":0},{"$f":"IFERROR(AI102/AE$10,\"\")","v":0},null,"Real Estate Agent Fee",null,null,null,null,null,null,{"$f":"IFERROR(AS102/AO$9,\"\")","v":""},{"$f":"IFERROR(AS102/AO$10,\"\")","v":""},null,"Real Estate Agent Fee",null,null,null,null,null,null,{"$f":"IFERROR(BC102/AY$9,\"\")","v":""},{"$f":"IFERROR(BC102/AY$10,\"\")","v":""},null,"Real Estate Agent Fee",null,null,null,null,null,null,{"$f":"IFERROR(BM102/BI$9,\"\")","v":""},{"$f":"IFERROR(BM102/BI$10,\"\")","v":""},null,"Real Estate Agent Fee",null,null,null,null,null,null,{"$f":"IFERROR(BW102/BS$9,\"\")","v":""},{"$f":"IFERROR(BW102/BS$10,\"\")","v":""},null,"Real Estate Agent Fee",null,null,null,null,null,null,{"$f":"IFERROR(CG102/CC$9,\"\")","v":""},{"$f":"IFERROR(CG102/CC$10,\"\")","v":""},null,"Real Estate Agent Fee",null,null,null,null,null,null,{"$f":"IFERROR(CQ102/CM$9,\"\")","v":""},{"$f":"IFERROR(CQ102/CM$10,\"\")","v":""},null,"Real Estate Agent Fee",null,null,null,null,null,null,{"$f":"IFERROR(DA102/CW$9,\"\")","v":""},{"$f":"IFERROR(DA102/CW$10,\"\")","v":""}]
["Marketing Fee",null,null,null,0,0,0,null,"Marketing Fee",null,null,null,null,null,null,0,0,null,"Marketing Fee",null,null,null,null,null,null,0,0,null,"Marketing Fee",null,null,null,null,null,null,0,0,null,"Marketing Fee",null,null,null,null,null,null,"","",null,"Marketing Fee",null,null,null,null,null,null,"","",null,"Marketing Fee",null,null,null,null,null,null,"","",null,"Marketing Fee",null,null,null,null,null,null,"","",null,"Marketing Fee",null,null,null,null,null,null,"","",null,"Marketing Fee",null,null,null,null,null,null,"","",null,"Marketing Fee",null,null,null,null,null,null,"",""]
["Other:",null,null,null,0,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,0,0,null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"","",null,"Other:",null,null,null,null,null,null,"",""]
["Other: ",null,null,null,0,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,0,0,null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"","",null,"Other: ",null,null,null,null,null,null,"",""]
["Total Transaction Fee",null,null,null,{"$f":"SUM(E102:E105)","v":0},{"$f":"SUM(F102:F105)","v":0},{"$f":"SUM(G102:G105)","v":0},null,"Total Transaction Fee",null,null,null,null,null,{"$f":"SUM(O102:O105)","v":0},{"$f":"SUM(P102:P105)","v":0},0,null,"Total Transaction Fee",null,null,null,null,null,{"$f":"SUM(Y102:Y105)","v":0},{"$f":"SUM(Z102:Z105)","v":0},0,null,"Total Transaction Fee",null,null,null,null,null,{"$f":"SUM(AI102:AI105)","v":0},{"$f":"SUM(AJ102:AJ105)","v":0},0,null,"Total Transaction Fee",null,null,null,null,null,{"$f":"SUM(AS102:AS105)","v":0},{"$f":"SUM(AT102:AT105)","v":0},0,null,"Total Transaction Fee",null,null,null,null,null,{"$f":"SUM(BC102:BC105)","v":0},{"$f":"SUM(BD102:BD105)","v":0},0,null,"Total Transaction Fee",null,null,null,null,null,{"$f":"SUM(BM102:BM105)","v":0},{"$f":"SUM(BN102:BN105)","v":0},0,null,"Total Transaction Fee",null,null,null,null,null,{"$f":"SUM(BW102:BW105)","v":0},{"$f":"SUM(BX102:BX105)","v":0},0,null,"Total Transaction Fee",null,null,null,null,null,{"$f":"SUM(CG102:CG105)","v":0},{"$f":"SUM(CH102:CH105)","v":0},0,null,"Total Transaction Fee",null,null,null,null,null,{"$f":"SUM(CQ102:CQ105)","v":0},{"$f":"SUM(CR102:CR105)","v":0},0,null,"Total Transaction Fee",null,null,null,null,null,{"$f":"SUM(DA102:DA105)","v":0},{"$f":"SUM(DB102:DB105)","v":0},0]
[]
["Total Uses of Funds",null,null,null,{"$f":"SUM(E60,E77,E83,E97,E44,E106)","v":100000},{"$f":"SUM(F60,F77,F83,F97,F44,F106)","v":16666.666666666668},8.7719298245614041,null,"Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(O60,O77,O83,O97,O44,O106)","v":100000},{"$f":"SUM(P60,P77,P83,P97,P44,P106)","v":50000},22.727272727272727,null,"Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(Y60,Y77,Y83,Y97,Y44,Y106)","v":0},{"$f":"SUM(Z60,Z77,Z83,Z97,Z44,Z106)","v":0},0,null,"Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(AI60,AI77,AI83,AI97,AI44,AI106)","v":0},{"$f":"SUM(AJ60,AJ77,AJ83,AJ97,AJ44,AJ106)","v":0},0,null,"Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(AS60,AS77,AS83,AS97,AS44,AS106)","v":0},{"$f":"SUM(AT60,AT77,AT83,AT97,AT44,AT106)","v":0},0,null,"Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(BC60,BC77,BC83,BC97,BC44,BC106)","v":0},{"$f":"SUM(BD60,BD77,BD83,BD97,BD44,BD106)","v":0},0,null,"Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(BM60,BM77,BM83,BM97,BM44,BM106)","v":0},{"$f":"SUM(BN60,BN77,BN83,BN97,BN44,BN106)","v":0},0,null,"Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(BW60,BW77,BW83,BW97,BW44,BW106)","v":0},{"$f":"SUM(BX60,BX77,BX83,BX97,BX44,BX106)","v":0},0,null,"Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(CG60,CG77,CG83,CG97,CG44,CG106)","v":0},{"$f":"SUM(CH60,CH77,CH83,CH97,CH44,CH106)","v":0},0,null,"Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(CQ60,CQ77,CQ83,CQ97,CQ44,CQ106)","v":0},{"$f":"SUM(CR60,CR77,CR83,CR97,CR44,CR106)","v":0},0,null,"Total Uses of Funds",null,null,null,null,null,{"$f":"SUM(DA60,DA77,DA83,DA97,DA44,DA106)","v":0},{"$f":"SUM(DB60,DB77,DB83,DB97,DB44,DB106)","v":0},0]

{"sheet":"Program Summary","index":8,"n_rows":49,"n_cols":33,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
["PROJECT NAME",{"$f":"[2]Instructions!$C$15","v":"Project A"}]
["DEVELOPER/SPONSOR",{"$f":"[2]Instructions!$C$16","v":"Apex Developers"}]
[]
["For-Sale Program Summary"]
[]
[null,null,null,"p","z","aj","at","bd","bn","bx","ch","cr","db"]
["Project Type",null,"Total or Average","A","B","C","D","E","F","G","H","I","J"]
["Project Type Description",{"$f":"[2]Program!K7","v":"Project Type"},null,{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!D$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":"2B 2ba, East Liberty"},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!E$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":"3B 2ba, East Liberty"},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!F$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":"2B 2ba, Larimer"},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!G$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":0},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!H$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":0},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!I$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":0},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!J$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":0},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!K$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":0},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!L$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":0},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!M$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":0},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!N$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!O$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!P$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!Q$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!R$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!S$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!T$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!U$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!V$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!W$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!X$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!Y$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!Z$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!AA$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B9,Program!$J$7:$N$7,0)),\"\")","v":""}]
["# of Units of this Type",{"$f":"[2]Program!L7","v":"Number of Projects"},{"$f":"SUM(D10:M10)","v":5},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!D$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":2},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!E$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":1},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!F$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":2},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!G$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!H$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!I$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!J$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!K$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!L$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!M$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!N$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!O$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!P$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!Q$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!R$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!S$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!T$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!U$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B10,Program!$J$7:$N$7,0)),\"\")","v":""}]
[]
["Total Development Cost Per Unit",null,{"$f":"'Dev Budget'!F100","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&D$7&ROW('Dev Budget'!$P$100))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&E$7&ROW('Dev Budget'!$P$100))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&F$7&ROW('Dev Budget'!$P$100))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&G$7&ROW('Dev Budget'!$P$100))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&H$7&ROW('Dev Budget'!$P$100))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&I$7&ROW('Dev Budget'!$P$100))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&J$7&ROW('Dev Budget'!$P$100))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&K$7&ROW('Dev Budget'!$P$100))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&L$7&ROW('Dev Budget'!$P$100))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&M$7&ROW('Dev Budget'!$P$100))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&N$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&O$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&P$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&Q$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&R$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&S$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&T$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&U$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&V$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&W$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&X$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&Y$7&ROW('Dev Budget'!$P$100))","v":{"$error":"#REF!"}}]
["Total Transaction Cost Per Unit",null,{"$f":"'Dev Budget'!F107","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&D$7&ROW('Dev Budget'!$P$107))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&E$7&ROW('Dev Budget'!$P$107))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&F$7&ROW('Dev Budget'!$P$107))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&G$7&ROW('Dev Budget'!$P$107))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&H$7&ROW('Dev Budget'!$P$107))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&I$7&ROW('Dev Budget'!$P$107))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&J$7&ROW('Dev Budget'!$P$107))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&K$7&ROW('Dev Budget'!$P$107))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&L$7&ROW('Dev Budget'!$P$107))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&M$7&ROW('Dev Budget'!$P$107))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&N$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&O$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&P$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&Q$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&R$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&S$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&T$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&U$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&V$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&W$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&X$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&Y$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&Z$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AA$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AB$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AC$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AD$7&ROW('Dev Budget'!$P$107))","v":{"$error":"#REF!"}}]
[]
["Development Funding Per Unit",null,{"$f":"IFERROR(SUMPRODUCT(D15:M15,$D$10:$M$10)/SUM($D$10:$M$10),\"\")","v":0},{"$f":"SUM(D16:D17)","v":0},0,0,0,0,0,0,0,0,0]
["EEHDP Funding Component",null,{"$f":"IFERROR(SUMPRODUCT(D16:M16,$D$10:$M$10)/SUM($D$10:$M$10),\"\")","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&D7&ROW('Dev Budget'!$O$21))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&E7&ROW('Dev Budget'!$O$21))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&F7&ROW('Dev Budget'!$O$21))","v":0},{"$f":"INDIRECT(\"'Dev Budget'!\"&G7&ROW('Dev Budget'!$O$21))","v":""},{"$f":"INDIRECT(\"'Dev Budget'!\"&H7&ROW('Dev Budget'!$O$21))","v":""},{"$f":"INDIRECT(\"'Dev Budget'!\"&I7&ROW('Dev Budget'!$O$21))","v":""},{"$f":"INDIRECT(\"'Dev Budget'!\"&J7&ROW('Dev Budget'!$O$21))","v":""},{"$f":"INDIRECT(\"'Dev Budget'!\"&K7&ROW('Dev Budget'!$O$21))","v":""},{"$f":"INDIRECT(\"'Dev Budget'!\"&L7&ROW('Dev Budget'!$O$21))","v":""},{"$f":"INDIRECT(\"'Dev Budget'!\"&M7&ROW('Dev Budget'!$O$21))","v":""},{"$f":"INDIRECT(\"'Dev Budget'!\"&N7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&O7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&P7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&Q7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&R7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&S7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&T7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&U7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&V7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&W7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&X7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&Y7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&Z7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AA7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AB7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AC7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AD7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AE7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AF7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'Dev Budget'!\"&AG7&ROW('Dev Budget'!$O$21))","v":{"$error":"#REF!"}}]
["Other Sources",null,{"$f":"IFERROR(SUMPRODUCT(D17:M17,$D$10:$M$10)/SUM($D$10:$M$10),\"\")","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&D7&ROW('Dev Budget'!$O$28))-SUM(D16:D16)","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&E7&ROW('Dev Budget'!$O$28))-SUM(E16:E16)","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&F7&ROW('Dev Budget'!$O$28))-SUM(F16:F16)","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&G7&ROW('Dev Budget'!$O$28))-SUM(G16:G16)","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&H7&ROW('Dev Budget'!$O$28))-SUM(H16:H16)","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&I7&ROW('Dev Budget'!$O$28))-SUM(I16:I16)","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&J7&ROW('Dev Budget'!$O$28))-SUM(J16:J16)","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&K7&ROW('Dev Budget'!$O$28))-SUM(K16:K16)","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&L7&ROW('Dev Budget'!$O$28))-SUM(L16:L16)","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&M7&ROW('Dev Budget'!$O$28))-SUM(M16:M16)","v":0},{"$f":"INDIRECT(\"'dev budget'!\"&N7&ROW('Dev Budget'!$O$28))-SUM(N16:N16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&O7&ROW('Dev Budget'!$O$28))-SUM(O16:O16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&P7&ROW('Dev Budget'!$O$28))-SUM(P16:P16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&Q7&ROW('Dev Budget'!$O$28))-SUM(Q16:Q16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&R7&ROW('Dev Budget'!$O$28))-SUM(R16:R16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&S7&ROW('Dev Budget'!$O$28))-SUM(S16:S16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&T7&ROW('Dev Budget'!$O$28))-SUM(T16:T16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&U7&ROW('Dev Budget'!$O$28))-SUM(U16:U16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&V7&ROW('Dev Budget'!$O$28))-SUM(V16:V16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&W7&ROW('Dev Budget'!$O$28))-SUM(W16:W16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&X7&ROW('Dev Budget'!$O$28))-SUM(X16:X16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&Y7&ROW('Dev Budget'!$O$28))-SUM(Y16:Y16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&Z7&ROW('Dev Budget'!$O$28))-SUM(Z16:Z16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&AA7&ROW('Dev Budget'!$O$28))-SUM(AA16:AA16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&AB7&ROW('Dev Budget'!$O$28))-SUM(AB16:AB16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&AC7&ROW('Dev Budget'!$O$28))-SUM(AC16:AC16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&AD7&ROW('Dev Budget'!$O$28))-SUM(AD16:AD16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&AE7&ROW('Dev Budget'!$O$28))-SUM(AE16:AE16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&AF7&ROW('Dev Budget'!$O$28))-SUM(AF16:AF16)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"'dev budget'!\"&AG7&ROW('Dev Budget'!$O$28))-SUM(AG16:AG16)","v":{"$error":"#REF!"}}]
[]
["Sale Price Per Unit",{"$f":"[2]Program!N7","v":"Sale Price"},{"$f":"IFERROR(SUMPRODUCT(D19:M19,$D$10:$M$10)/SUM($D$10:$M$10),\"\")","v":172000},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!D$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":150000},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!E$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":160000},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!F$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":200000},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!G$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!H$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!I$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!J$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!K$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!L$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!M$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!N$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!O$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!P$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!Q$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!R$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!S$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!T$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!U$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!V$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!W$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!X$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!Y$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!Z$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!AA$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!AB$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!AC$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!AD$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(Program!$J$7:$N$17,MATCH('Program Summary'!AE$8,Program!$J$7:$J$17,0),MATCH('Program Summary'!$B19,Program!$J$7:$N$7,0)),\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(D26=\"No\",IF(D10<41,D32,IF(D37=\"Alternative Combination\",D32+D40,D32+#REF!)),\"\")","v":""}]
[{"$f":"_xlfn.CONCAT(\"Is this affordable to a \",B41,\"-person household at:\")","v":"Is this affordable to a 4-person household at:"}]
[1,null,null,{"$f":"IFERROR(IF(D$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(D$19*(1+$B$27))-SUM($B$28:$B$28)))+(D$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(D$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A22,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":"Yes"},{"$f":"IFERROR(IF(E$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(E$19*(1+$B$27))-SUM($B$28:$B$28)))+(E$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(E$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A22,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":"Yes"},{"$f":"IFERROR(IF(F$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(F$19*(1+$B$27))-SUM($B$28:$B$28)))+(F$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(F$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A22,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":"No"},{"$f":"IFERROR(IF(G$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(G$19*(1+$B$27))-SUM($B$28:$B$28)))+(G$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(G$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A22,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(H$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(H$19*(1+$B$27))-SUM($B$28:$B$28)))+(H$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(H$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A22,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(I$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(I$19*(1+$B$27))-SUM($B$28:$B$28)))+(I$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(I$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A22,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(J$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(J$19*(1+$B$27))-SUM($B$28:$B$28)))+(J$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(J$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A22,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(K$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(K$19*(1+$B$27))-SUM($B$28:$B$28)))+(K$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(K$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A22,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(L$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(L$19*(1+$B$27))-SUM($B$28:$B$28)))+(L$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(L$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A22,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(M$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(M$19*(1+$B$27))-SUM($B$28:$B$28)))+(M$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(M$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A22,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""}]
[0.8,null,null,{"$f":"IFERROR(IF(D$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(D$19*(1+$B$27))-SUM($B$28:$B$28)))+(D$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(D$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A23,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":"No"},{"$f":"IFERROR(IF(E$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(E$19*(1+$B$27))-SUM($B$28:$B$28)))+(E$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(E$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A23,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":"No"},{"$f":"IFERROR(IF(F$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(F$19*(1+$B$27))-SUM($B$28:$B$28)))+(F$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(F$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A23,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":"No"},{"$f":"IFERROR(IF(G$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(G$19*(1+$B$27))-SUM($B$28:$B$28)))+(G$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(G$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A23,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(H$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(H$19*(1+$B$27))-SUM($B$28:$B$28)))+(H$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(H$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A23,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(I$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(I$19*(1+$B$27))-SUM($B$28:$B$28)))+(I$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(I$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A23,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(J$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(J$19*(1+$B$27))-SUM($B$28:$B$28)))+(J$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(J$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A23,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(K$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(K$19*(1+$B$27))-SUM($B$28:$B$28)))+(K$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(K$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A23,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(L$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(L$19*(1+$B$27))-SUM($B$28:$B$28)))+(L$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(L$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A23,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(M$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(M$19*(1+$B$27))-SUM($B$28:$B$28)))+(M$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(M$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A23,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""}]
[0.5,null,null,{"$f":"IFERROR(IF(D$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(D$19*(1+$B$27))-SUM($B$28:$B$28)))+(D$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(D$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A24,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":"No"},{"$f":"IFERROR(IF(E$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(E$19*(1+$B$27))-SUM($B$28:$B$28)))+(E$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(E$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A24,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":"No"},{"$f":"IFERROR(IF(F$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(F$19*(1+$B$27))-SUM($B$28:$B$28)))+(F$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(F$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A24,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":"No"},{"$f":"IFERROR(IF(G$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(G$19*(1+$B$27))-SUM($B$28:$B$28)))+(G$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(G$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A24,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(H$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(H$19*(1+$B$27))-SUM($B$28:$B$28)))+(H$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(H$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A24,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(I$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(I$19*(1+$B$27))-SUM($B$28:$B$28)))+(I$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(I$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A24,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(J$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(J$19*(1+$B$27))-SUM($B$28:$B$28)))+(J$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(J$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A24,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(K$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(K$19*(1+$B$27))-SUM($B$28:$B$28)))+(K$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(K$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A24,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(L$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(L$19*(1+$B$27))-SUM($B$28:$B$28)))+(L$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(L$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A24,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""},{"$f":"IFERROR(IF(M$19=0,\"\",IF((PMT($B$30/12,$B$31*12,-((1-$B$29)*(M$19*(1+$B$27))-SUM($B$28:$B$28)))+(M$19*0.9/12*SUM($B$33:$B$36))+($B$37*((1-$B$29)*(M$19*(1+$B$27))-SUM($B$28:$B$28)))+$B$38-$B$39)*12/$B$40<INDEX('Program Summary'!$A$43:$E$49,MATCH('Program Summary'!$B$41,'Program Summary'!$A$43:$A$49,0),MATCH('Program Summary'!$A24,'Program Summary'!$A$43:$E$43,0)),\"Yes\",\"No\")),\"\")","v":""}]
[]
["Affordability Assumptions:",null,"Notes"]
["Closing Costs",0.03,"Percentage of Sale Price"]
["Deferred Loans to Buyer",20000]
["Down Payment",0.03,"Percentage of Sale Price + Closing Costs"]
["Mortgage Rate",4.2500000000000003E-2]
["Mortgage Term",30]
["Monthly Taxes"]
["County",4.7299999999999998E-3]
["City",8.0599999999999995E-3]
["School",9.8399999999999998E-3]
["Library",2.5000000000000001E-4]
["Monthly Mortgage Insurance",5.0000000000000001E-3]
["Monthly Insurance",65]
["Other Income",null,"e.g. rental income"]
["Affordability Threshold",0.25,"Percentage of income spent on housing (20% to 30%)"]
["Household Size",4]
[]
["Area Median Income by Household Size (2020)",null,0.5,0.8,1]
[1,0.7,{"$f":"(D44/$D$43)*$C$43","v":29050},{"$f":"$B44*$D$47","v":46480},{"$f":"(D44/$D$43)*$E$43","v":58100}]
[2,0.8,33200,{"$f":"$B45*$D$47","v":53120},66400]
[3,0.9,37350,{"$f":"$B46*$D$47","v":59760},74700]
[4,1,41500,66400,83000]
[5,1.08,44820,{"$f":"$B48*$D$47","v":71712},89640]
[6,1.1599999999999999,48140,{"$f":"$B49*$D$47","v":77024},96280]

{"sheet":"Verifications","index":9,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[36,0,36,6],[21,0,21,6],[22,0,22,6],[23,0,23,6],[24,0,24,9],[26,0,26,9],[30,0,30,6],[31,0,31,6],[32,0,32,6],[33,0,33,6],[34,0,34,6],[35,0,35,6],[16,0,16,9],[19,0,19,6],[13,0,13,7],[4,0,4,9],[7,0,7,6],[9,0,9,6],[10,0,10,6],[12,0,12,6]]}
[]
["PROJECT NAME",{"$f":"[2]Instructions!$C$15","v":"Project A"}]
["DEVELOPER/SPONSOR",{"$f":"[2]Instructions!$C$16","v":"Apex Developers"}]
[]
["Minimum Affordable Unit Verification - For Sale"]
[]
["Verification",null,null,null,null,null,null,"EEHDP Units"]
["Total Number of Units Seeking Funding",null,null,null,null,null,null,{"$f":"'Program Summary'!C10","v":5}]
[]
["Number of Units Affordable to 80% AMI",null,null,null,null,null,null,3]
["Number of Units Affordable to 100% AMI",null,null,null,null,null,null,0]
[]
["AFFORDABILITY REQUIREMENT MET?",null,null,null,null,null,null,{"$f":"IF(H10>=ROUNDUP(0.51*H8,1),\"Yes\",\"No\")","v":"Yes"}]
[{"$f":"IF(AND(H13=\"No\"),CONCATENATE(\"Number of Units Affordable to Households at or Below 80% AMI Must Be At Least \",ROUNDUP(0.51*H8,0)),\"\")","v":""}]
[]
[]
["Funding Request Verification"]
[]
[null,null,null,null,null,null,null,"EEHDP"]
["Funding Request ($)",null,null,null,null,null,null,{"$f":"'Dev Budget'!$E$21","v":0}]
[]
["Per-Unit Funding",null,null,null,null,null,null,{"$f":"IFERROR(H20/H8,\"\")","v":0}]
["Within target level of funding? ($70,000 for Units @ 80% AMI, $60,000 for units @ 100% AMI)",null,null,null,null,null,null,{"$f":"IF(OR(H22=0,H22=\"\"),\"\",IF(H22<=70000,\"Yes\",\"No\"))","v":""}]
[]
[]
[]
["Comparison with PHFA Median Costs"]
[]
["Calculated Project Cost PSF",null,null,null,null,null,null,null,null,{"$f":"'Dev Budget'!G109-'Dev Budget'!G45","v":0}]
[]
["Application Property Type",null,null,null,null,null,null,"Pennsylvania Median Cost PSF","Over or Under?","Mark Most Relevant Property Type(s) with \"X\""]
["Single Family/Townhouse",null,null,null,null,null,null,201,{"$f":"IF($J$29>H32,\"Over\",IF($J$29=H32,\"Equal\",IF($J$29<H32,\"Under\",\"\")))","v":"Under"}]
["Multi-Story Elevator Building",null,null,null,null,null,null,215,{"$f":"IF($J$29>H33,\"Over\",IF($J$29=H33,\"Equal\",IF($J$29<H33,\"Under\",\"\")))","v":"Under"}]
["Adaptive Reuse Building",null,null,null,null,null,null,250.5,{"$f":"IF($J$29>H34,\"Over\",IF($J$29=H34,\"Equal\",IF($J$29<H34,\"Under\",\"\")))","v":"Under"}]
["Preservation",null,null,null,null,null,null,144,{"$f":"IF($J$29>H35,\"Over\",IF($J$29=H35,\"Equal\",IF($J$29<H35,\"Under\",\"\")))","v":"Under"}]
["Pittsburgh",null,null,null,null,null,null,292.5,{"$f":"IF($J$29>H36,\"Over\",IF($J$29=H36,\"Equal\",IF($J$29<H36,\"Under\",\"\")))","v":"Under"}]