{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Select City & State","TDC Limit Calculation","Maximum Grant Calculation"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Select City & State","index":0,"n_rows":82,"n_cols":9,"rows_kept":82,"cut":false,"hidden":false,"merged":[[10,3,10,8],[54,3,60,3],[7,3,7,7],[8,3,8,8],[11,3,11,8],[16,3,18,8],[61,3,67,3],[68,3,74,3],[75,3,81,3],[54,2,67,2],[68,2,81,2],[40,2,53,2],[40,3,46,3],[47,3,53,3],[1,1,1,9],[2,1,2,9],[26,3,32,3],[33,3,39,3],[26,2,39,2],[19,3,20,8],[13,3,15,8]],"flags":["formulas_cached_only"]}
[{"$nulls":7},"OMB Approval No. 2577-0208 (exp. 4/30/2008)"]
[null,"Attachment 9:"]
[null,"TDC/Grant Limitations Worksheet"]
[]
[null,null,"FOLLOW THE STEP-BY-STEP INSTRUCTIONS",{"$nulls":5},"Page 1"]
[null,null,"Note: If completing Attachment 9 manually, rather than using the Excel workbook, start at Step 4 (page 2)."]
[]
[null,null,"Step 1.","Select your City from the menu below."]
[null,null,null,"Click as indicated to see the lists of cities, scroll through the list, click on your City, and click \"OK.\""]
[]
[null,null,"Step 2.","Repeat Step 1 to select your State from the menu below."]
[null,null,null,"Click as indicated to see the lists of states, scroll through the list, click on your State, and click \"OK.\""]
[]
[null,null,null,"This table includes all Total Development Cost (TDC) dollar limits published in HUD Notice PIH 2007-19.  If your City is not shown, contact the HUD Office of Public Housing Investments, (202) 401-8812."]
[]
[]
[null,null,null,"If you have selected a valid City/State combination, a table will be created that extends down to row 82.  The TDC limits for each unit type shown on this table will be transferred automatically to the table on the next worksheet, \"TDC Limit Calculation.\""]
[]
[]
[null,null,"Step 3.","After selecting the appropriate City and State, go to Step 4, page 2.  (If using the Excel file, \nclick on the worksheet tab entitled \"TDC Limit Calculation\" at the bottom of this window.)"]
[]
[]
[{"$nulls":5},"City","ABILENE","<-- Select your City from list here"]
[{"$nulls":5},"StateName","TEXAS","<-- Select your State from list here"]
[]
[{"$nulls":4},"Bedrooms","Type","Data","Total"]
[null,null,"Detached / Semi-Detached","TDC Limit \nper Unit",0,"Detached/Semi-Detached","Sum of 0 Bedrooms, TDC",92058.67825]
[{"$nulls":4},1,null,"Sum of 1 Bedrooms, TDC",121789.2795]
[{"$nulls":4},2,null,"Sum of 2 Bedrooms, TDC",158672.6568]
[{"$nulls":4},3,null,"Sum of 3 Bedrooms, TDC",191455.5888]
[{"$nulls":4},4,null,"Sum of 4 Bedrooms, TDC",226156.98525]
[{"$nulls":4},5,null,"Sum of 5 Bedrooms, TDC",248319.29919999998]
[{"$nulls":4},6,null,"Sum of 6 Bedrooms, TDC",269021.42085]
[null,null,null,"HCC Limit \nper Unit",0,null,"Sum of 0 Bedrooms, HCC",52604.959]
[{"$nulls":4},1,null,"Sum of 1 Bedrooms, HCC",69593.87400000001]
[{"$nulls":4},2,null,"Sum of 2 Bedrooms, HCC",90670.0896]
[{"$nulls":4},3,null,"Sum of 3 Bedrooms, HCC",109403.1936]
[{"$nulls":4},4,null,"Sum of 4 Bedrooms, HCC",129232.563]
[{"$nulls":4},5,null,"Sum of 5 Bedrooms, HCC",141896.7424]
[{"$nulls":4},6,null,"Sum of 6 Bedrooms, HCC",153726.5262]
[null,null,"Elevator","TDC Limit \nper Unit",0,"Elevator","Sum of 0 Bedrooms, TDC",72383.24639999999]
[{"$nulls":4},1,null,"Sum of 1 Bedrooms, TDC",101335.61200000001]
[{"$nulls":4},2,null,"Sum of 2 Bedrooms, TDC",130288.644]
[{"$nulls":4},3,null,"Sum of 3 Bedrooms, TDC",173718.192]
[{"$nulls":4},4,null,"Sum of 4 Bedrooms, TDC",217147.74]
[{"$nulls":4},5,null,"Sum of 5 Bedrooms, TDC",246100.772]
[{"$nulls":4},6,null,"Sum of 6 Bedrooms, TDC",275053.804]
[null,null,null,"HCC Limit \nper Unit",0,null,"Sum of 0 Bedrooms, HCC",45239.528999999995]
[{"$nulls":4},1,null,"Sum of 1 Bedrooms, HCC",63334.7575]
[{"$nulls":4},2,null,"Sum of 2 Bedrooms, HCC",81430.4025]
[{"$nulls":4},3,null,"Sum of 3 Bedrooms, HCC",108573.87]
[{"$nulls":4},4,null,"Sum of 4 Bedrooms, HCC",135717.3375]
[{"$nulls":4},5,null,"Sum of 5 Bedrooms, HCC",153812.98249999998]
[{"$nulls":4},6,null,"Sum of 6 Bedrooms, HCC",171908.6275]
[null,null,"Row House","TDC Limit\nper Unit",0,"Row House","Sum of 0 Bedrooms, TDC",82695.94265625]
[{"$nulls":4},1,null,"Sum of 1 Bedrooms, TDC",108721.47501250001]
[{"$nulls":4},2,null,"Sum of 2 Bedrooms, TDC",140985.02604375]
[{"$nulls":4},3,null,"Sum of 3 Bedrooms, TDC",169792.80675]
[{"$nulls":4},4,null,"Sum of 4 Bedrooms, TDC",199740.82996875]
[{"$nulls":4},5,null,"Sum of 5 Bedrooms, TDC",218737.18142500002]
[{"$nulls":4},6,null,"Sum of 6 Bedrooms, TDC",236323.05081875]
[null,null,null,"HCC Limit \nper Unit",0,null,"Sum of 0 Bedrooms, HCC",47254.824375]
[{"$nulls":4},1,null,"Sum of 1 Bedrooms, HCC",62126.55715000001]
[{"$nulls":4},2,null,"Sum of 2 Bedrooms, HCC",80562.872025]
[{"$nulls":4},3,null,"Sum of 3 Bedrooms, HCC",97024.46100000001]
[{"$nulls":4},4,null,"Sum of 4 Bedrooms, HCC",114137.617125]
[{"$nulls":4},5,null,"Sum of 5 Bedrooms, HCC",124992.6751]
[{"$nulls":4},6,null,"Sum of 6 Bedrooms, HCC",135041.743325]
[null,null,"Walkup","TDC Limit \nper Unit",0,"Walkup","Sum of 0 Bedrooms, TDC",66351.77937499998]
[{"$nulls":4},1,null,"Sum of 1 Bedrooms, TDC",92035.33412499998]
[{"$nulls":4},2,null,"Sum of 2 Bedrooms, TDC",117229.084875]
[{"$nulls":4},3,null,"Sum of 3 Bedrooms, TDC",155658.20549999998]
[{"$nulls":4},4,null,"Sum of 4 Bedrooms, TDC",192845.32312499997]
[{"$nulls":4},5,null,"Sum of 5 Bedrooms, TDC",217455.24499999997]
[{"$nulls":4},6,null,"Sum of 6 Bedrooms, TDC",241127.10474999997]
[null,null,null,"HCC Limit \nper Unit",0,null,"Sum of 0 Bedrooms, HCC",37915.3025]
[{"$nulls":4},1,null,"Sum of 1 Bedrooms, HCC",52591.619499999986]
[{"$nulls":4},2,null,"Sum of 2 Bedrooms, HCC",66988.04849999999]
[{"$nulls":4},3,null,"Sum of 3 Bedrooms, HCC",88947.54599999997]
[{"$nulls":4},4,null,"Sum of 4 Bedrooms, HCC",110197.32749999998]
[{"$nulls":4},5,null,"Sum of 5 Bedrooms, HCC",124260.14]
[{"$nulls":4},6,null,"Sum of 6 Bedrooms, HCC",137786.917]

{"sheet":"TDC Limit Calculation","index":1,"n_rows":89,"n_cols":10,"rows_kept":89,"cut":false,"hidden":false,"merged":[[88,2,89,9],[12,2,13,9],[14,2,14,9],[21,2,22,9],[26,2,26,9],[18,2,20,9],[25,2,25,9],[28,2,29,9],[15,2,15,9],[34,2,38,2],[1,1,1,10],[2,1,2,10],[30,2,30,9],[5,6,5,9],[7,6,7,9],[9,7,10,9],[9,2,9,5],[10,2,10,5],[27,2,27,9],[79,2,83,2],[3,9,4,9],[61,2,65,2],[67,2,71,2],[73,2,77,2],[40,2,44,2],[46,2,50,2],[52,2,56,2]],"flags":["formulas_cached_only"]}
[]
[null,"Attachment 9:"]
[null,"TDC/Grant Limitations Worksheet"]
[{"$nulls":9},"Page 2"]
[]
[null,"Step 4.","Enter name of the Applicant PHA:"]
[]
[null,"Step 5.","(a) Enter name of proposed HOPE VI project: "]
[]
[null,null,"(b) Confirm correct City (selected in Step 1):",null,null,null,"ABILENE","Note:  If the selected City or State is wrong, return to Page 1, Steps 1 and 2, to correct your selections (navigate back to Step 1 by clicking on \"Select City & State\" tab below)."]
[null,null,"(c) Confirm correct State (selected in Step 2):",null,null,null,"TEXAS"]
[]
[null,"Step 6.","In the appropriate \"BUILDING TYPE' and bedroom (\"BR\") categories below, enter the number of \n\"NEW UNITS\" (use Table 6(a)), and/or \"REHABILITATION UNITS\" (use Table 6(b)), proposed for funding under this application.  "]
[]
[null,null,"The Excel form will calculate TDC limit subtotals for each unit type, and overal TDC limit totals, based on City and State selected at Steps 1 and 2. "]
[null,null,"If you are completing this Attachment 9 manually, use the applicable TDC limits for each unit type found in HUD Notice PIH 2007-19."]
[]
[null,null,"Definitions  "]
[null,null,"NEW UNITS (Table 6(a)):  include all on-site and off-site rental units that will receive public housing operating subsidy.  Also include any homeownership units (including lease-purchase), that will be newly-constructed or acquired (with or without rehabilitation) utilizing any HOPE VI grant funds or other public housing capital assistance for development."]
[]
[]
[null,null,"REHABILITATION UNITS (Table 6(b)):  include only existing public housing units that are proposed for rehabilitation utilizing HOPE VI grant funds or other public housing capital assistance."]
[]
[]
[null,null,"Building Types"]
[null,null,"Detached buildings are single-family dwellings."]
[null,null,"Semi-Detached buildings, also referred to as \"duplex\" units, are structures that include only two units.  "]
[null,null,"Elevator buildings include only those structures with an elevator and four or more floors above ground."]
[null,null,"Row House refers to any structure with three or more units that has only vertical common walls. \n  If a building with three or more units has upper/lower units (and is not an elevator building), it is classified as a Walkup."]
[]
[null,null,"Walkup buildings include all structures with three or more units that are not classified as Elevator or Row House."]
[null,null,"  "]
[null,null,null,"Table 6(a):  NEW UNITS (new construction, and units to be acquired and rehabilitated)"]
[null,null,"BUILDING\nTYPE","BR's","Number \nof Units","HCC Limit \nper Unit","HCC \nTotals","Community Renewal \nAllowance Total","TDC Limit per Unit\nfor New Const.","TDC Limit \nTotals"]
[null,null,"Detached / Semi-Detached","1BR",{"$nulls":4},121789.2795,0]
[null,null,null,"2BR",{"$nulls":4},158672.6568,0]
[null,null,null,"3BR",{"$nulls":4},191455.5888,0]
[null,null,null,"4BR",{"$nulls":4},226156.98525,0]
[null,null,null,"5BR",{"$nulls":4},248319.29919999998,0]
[]
[null,null,"Elevator","1BR",{"$nulls":4},101335.61200000001,0]
[null,null,null,"2BR",{"$nulls":4},130288.644,0]
[null,null,null,"3BR",{"$nulls":4},173718.192,0]
[null,null,null,"4BR",{"$nulls":4},217147.74,0]
[null,null,null,"5BR",{"$nulls":4},246100.772,0]
[]
[null,null,"Row House","1BR",{"$nulls":4},108721.47501250001,0]
[null,null,null,"2BR",{"$nulls":4},140985.02604375,0]
[null,null,null,"3BR",{"$nulls":4},169792.80675,0]
[null,null,null,"4BR",{"$nulls":4},199740.82996875,0]
[null,null,null,"5BR",{"$nulls":4},218737.18142500002,0]
[]
[null,null,"Walkup","1BR",{"$nulls":4},92035.33412499998,0]
[null,null,null,"2BR",{"$nulls":4},117229.084875,0]
[null,null,null,"3BR",{"$nulls":4},155658.20549999998,0]
[null,null,null,"4BR",{"$nulls":4},192845.32312499997,0]
[null,null,null,"5BR",{"$nulls":4},217455.24499999997,0]
[null,null,null,"Subtotal New Units: ",0]
[]
[null,null,null,"Table 6(b):  REHABILITATION UNITS (existing pubic housing units to be rehabilitated)*"]
[null,null,"BUILDING\nTYPE","BR's","Number \nof Units","HCC Limit \nper Unit","HCC Totals","Comm Renewal \nAllowance Total","TDC Limit per Unit\nfor Rehab*","TDC Limit \nTotals"]
[null,null,"Detached / Semi-Detached","1BR",{"$nulls":4},109610.35155,0]
[null,null,null,"2BR",{"$nulls":4},142805.39112000001,0]
[null,null,null,"3BR",{"$nulls":4},172310.02992,0]
[null,null,null,"4BR",{"$nulls":4},203541.286725,0]
[null,null,null,"5BR",{"$nulls":4},223487.36927999998,0]
[]
[null,null,"Elevator","1BR",{"$nulls":4},91202.05080000001,0]
[null,null,null,"2BR",{"$nulls":4},117259.77960000001,0]
[null,null,null,"3BR",{"$nulls":4},156346.3728,0]
[null,null,null,"4BR",{"$nulls":4},195432.966,0]
[null,null,null,"5BR",{"$nulls":4},221490.6948,0]
[]
[null,null,"Row House","1BR",{"$nulls":4},97849.32751125001,0]
[null,null,null,"2BR",{"$nulls":4},126886.523439375,0]
[null,null,null,"3BR",{"$nulls":4},152813.526075,0]
[null,null,null,"4BR",{"$nulls":4},179766.74697187502,0]
[null,null,null,"5BR",{"$nulls":4},196863.46328250002,0]
[]
[null,null,"Walkup","1BR",{"$nulls":4},82831.80071249999,0]
[null,null,null,"2BR",{"$nulls":4},105506.1763875,0]
[null,null,null,"3BR",{"$nulls":4},140092.38494999998,0]
[null,null,null,"4BR",{"$nulls":4},173560.79081249997,0]
[null,null,null,"5BR",{"$nulls":4},195709.72049999997,0]
[null,null,null,"Subtotal Rehab Units:",0]
[]
[null,"6(c)","Totals for all New and Rehabilitation Units",null,0,{"$nulls":4},0]
[]
[null,null,"* TDC limits shown for Rehabilitation Units are 90% of the TDC limit for New Construction Units.  If rehabilitation activity will change the number of units or the unit configuration (Building Types or number of Bedrooms) at the original project site, enter the number and configuration of units that will exist after rehabilitation, not the number of units and unit configuration before rehabilitation."]

{"sheet":"Maximum Grant Calculation","index":2,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,11,1,13],[35,4,36,9],[39,4,39,8],[15,4,15,10],[11,3,12,12],[33,3,33,9],[31,4,31,8],[34,4,34,8],[18,4,18,10],[60,4,60,10],[29,4,29,8],[4,1,4,13],[5,1,5,13],[26,3,26,9],[28,3,28,8],[9,3,10,12],[14,3,14,10],[19,4,20,10],[17,3,17,11],[47,4,49,10],[22,3,22,10],[23,4,24,10],[46,3,46,10],[43,3,43,10],[30,3,30,9],[38,3,38,9],[45,4,45,10],[44,4,44,8],[41,3,41,11],[57,4,57,10],[56,3,56,10],[54,4,54,10],[53,3,53,8]],"flags":["formulas_cached_only"]}
[{"$nulls":6}," OMB Approval No. 2577-0208  (exp. 4/30/2008)",{"$nulls":4},"\n"]
[]
[]
[]
[null,"Attachment 9:"]
[null,"TDC/Grant Limitations Worksheet"]
[]
[null,null,"COMPLETE THIS WORKSHEET LAST",{"$nulls":9},"Page 3"]
[]
[null,null,null,"To determine the maximum grant amount that may be requested in this HOPE VI revitalization application, enter the requested information.  If you are using the Excel form, totals are calculated automatically."]
[]
[null,null,null,"If you are manually calculating the maximum grant amount that may be requested on this Attachment 9, follow the calculation instructions provided below on this worksheet."]
[]
[]
[null,null,"6(d)","TDC limit, unadjusted (entered automatically from \"TDC Limit Calculation\")",{"$nulls":8},0]
[{"$nulls":4},"(To calculate manually, enter the TDC Limit Total for all New and Rehabilitation Units from line 6(c), page 2)"]
[]
[null,null,"Step 7.","Enter HOPE VI request for CSS funding.",{"$nulls":8},0]
[{"$nulls":4},"(from Attachment 7, Sources and Uses Budget)",{"$nulls":7},""]
[null,null,"",null,"(Note: request for HOPE VI Community and Supportive Services (CSS) funding may not exceed 15% of total grant requested. Any amount requested above 5% of grant must be matched by other sources.)",{"$nulls":7},""]
[]
[]
[null,null,"Step 8.","Enter HOPE VI funds requested for demolition and remediation of dwelling units.",{"$nulls":7},0]
[{"$nulls":4},"(Enter the combined total of the dwelling unit remediation and dwelling unit demolition line items from \nAttachment 7, Sources and Uses Budget)"]
[]
[]
[null,null,"Step 9.","Enter number of PH units to be demolished (after date of application only)."]
[]
[null,null,"Step 10.","Enter number of PH units to be built back on the original site.",{"$nulls":5},"(",null,")"]
[{"$nulls":4},"(Do not include existing public housing units to be rehabilitated)"]
[null,null,"10(a)","Number of PH units to be demolished and not replaced back on original site",{"$nulls":6},0]
[{"$nulls":4},"(Number of units identified in Step 9, minus the number of units identified in Step 10)"]
[]
[null,null,"10(b)","Percent of original PH units to be demolished and not replaced back on original site",{"$nulls":6},0,"%"]
[{"$nulls":4},"(Number of units identified in 10(a), divided by number of units identified in Step 9)"]
[{"$nulls":4},"Example: Step 9 = 100 units to be demolished.  Step 10 = 40 PH units to be built back on original site. 10(a) = 60 units demolished and not built back on original site.  10(b) = 60/100 = 60%"]
[]
[]
[null,null,"10(c)","Demo/abatement costs attributable to units to be demolished and not replaced on orig. site",{"$nulls":8},0]
[{"$nulls":4},"(Dollar amount identified in Step 8, multiplied by percentage identified in 10(b))"]
[]
[null,null,"Step 11.","Enter HOPE VI request for \"extraordinary site costs\" (certified by architect or engineer).",{"$nulls":8},0]
[]
[null,null,"11(a)","Subtotal: TDC limit, adjusted (for CSS, abatement/demolition, and extraordinary site costs)",{"$nulls":8},0]
[{"$nulls":4},"(Total of amounts above: 6(d) + Step 7 + 10(c) + Step 11)"]
[]
[null,null,"Step 12.","Enter all other HUD PH capital assistance proposed for HOPE VI development.",{"$nulls":7},"(",0,")"]
[{"$nulls":4},"(Include any project funds from the following sources: Public Housing Capital Funds or Mod funds (e.g., CIAP or CGP funds); Public Housing Development grants; previously-awarded HOPE VI demolition-only grants; and any borrowed funds secured by Capital Funds (from Attachment 7, Sources and Uses Budget))"]
[]
[]
[null,null,"12(a)","Subtotal: Adjusted maximum allowable grant, after accounting for additional capital assistance",{"$nulls":8},0]
[{"$nulls":4},"(Total of Subtotal in 11(a), minus amount identified in Step 12)"]
[]
[null,null,"12(b)","Maximum allowable HOPE VI Revitalization Grant",{"$nulls":7},20000000]
[{"$nulls":4},"(In accordance with provisions of the HUD HOPE VI Notice of Funding Availability)"]
[]
[null,null,"12(c)","Maximum allowable HOPE VI Revitalization Grant request",{"$nulls":8},0]
[{"$nulls":4},"(The lesser of 12(a) (adjusted max. possible grant), and 12(b) ($20,000,000))"]
[]
[null,null,"Step 13.","Enter the amount of your HOPE VI Revitalization Grant request",{"$nulls":8},0]
[{"$nulls":4},"(If less than maximum allowable grant request, above)",{"$nulls":7},""]
[{"$nulls":12},""]
[{"$nulls":13},"form HUD-52799 (2/2003)"]
[]
[]
[null,null,null,""]
[null,null,null,""]
[null,null,null,""]