{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"external_links":1,"defined_names":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":85,"n_cols":10,"rows_kept":85,"merged":[[1,0,1,9],[3,0,3,8],[4,0,4,8],[12,0,12,7],[44,0,44,1],[44,3,44,4],[44,6,44,7],[45,0,45,1],[45,3,45,4],[45,6,45,7],[47,3,47,4],[48,3,48,4],[52,0,52,1],[52,3,52,4],[52,6,52,7],[53,0,53,1],[53,3,53,4],[53,6,53,7],[55,3,55,4],[56,3,56,4],[58,4,58,5],[68,2,68,4],[70,2,70,4],[71,0,71,9],[75,0,75,1],[75,3,75,4],[75,6,75,7],[76,0,76,1],[76,3,76,4],[76,6,76,7],[81,0,81,1],[81,2,81,3]],"flags":["formulas_cached_only"]}
[{"$nulls":5},"SHCC CALCULATIONS          "]
["PART 2 ADJUSTMENTS WORKSHEET"]
[]
["FIELD OFFICE WORKSHEET FOR PROCESSING RENT INCREASES FOR AAF RENTS FOR NEW CONSTRUCTION AND SUBSTANTIAL REHABILITATION UNIT TYPES WHICH DO NOT EXCEED THE EXISTING HOUSING FAIR MARKET RENTS AND FOR ALL LMSA AND PD SECTION 8 CONTRACT TYPES."]
["(NOT FOR USE ON BUDGET BASED RENT INCREASES)"]
[]
["Property Name:",{"$nulls":4},"Unit Type:"]
[]
[]
["Contract #:"]
[]
[]
["ESSENTIAL INFORMATION"]
[]
["Existing FMR Level",null,null,">","Current Gross"]
["For Unit Type $",{"$nulls":3},"Rent for Unit Type $"]
[]
[]
["STEP 1:  If this contract is a New Construction or Substantial Rehab contract, then is the current"]
[" rent for this unit type (before application of the AAF) below the Existing Housing FMR?;"]
[]
[{"$nulls":4},"OR"]
[]
["If this contract is a LMSA or PD contract, is the method of adjustment for contract rent the "]
["application of the AAF (as opposed to budget-based)?  (NOTE:  Budget-based rents are NOT "]
["processed under this Notice.  See Chapter 7, Handbook 4350.1)"]
[]
[null,"If the answer to the applicable question is YES, then proceed to Step 2."]
[null,"If the answer to the applicable question is NO, and the first question is applicable, then "]
[null,"this unit type should be adjusted under Part 1 of this Notice. This worksheet does not "]
[null,"apply.  Please find Part 1 Adjustments Worksheet at the beginning of Appendix 2."]
[]
["If the second question is applicable and the answer is NO, then this Notice is not applicable "]
["and the rents should be adjusted under Chapter 7, Handbook 4350.1"]
[]
["STEP 2:  For units in which turnover occurred in the last year, use AAF Table 1 to calculate the "]
["rents.  For units in which no turnover occurred in the last year use AAF Table 2 to calculate the "]
["rents.  (NOTE:  Throughout this Worksheet when applying the published AAF, the factor of 1.000 "]
["should be used in all cases where the published factor is below 1.000.)"]
[]
[]
[]
["Turnover  units"]
[]
[null,null,"X",null,null,"=",{"v":0,"d":"$0.00"}]
["(Current Rent)",null,null,"(Table 1 Factor)",null,null,"(New Rent Level)"]
["   ",null,null,"  "]
[]
[null,null,"      ","(Factor Area )"]
["               "]
["Units with no Turnover"]
[]
[null,null,"X",null,null,"=",{"v":0,"d":"$0.00"}]
["(Current Rent)",null,null,"(Table 2 Factor)",null,null,"(New Rent Level)"]
[]
[]
[null,null,"      ","(Factor Area )"]
[]
["STEP 3:                 ","      The new rent level (s) for ",{"$nulls":4}," unit type is:"]
[]
[null,null,{"v":0,"d":"$0.00"},"for units with turnover    (  #   of   Units",{"$nulls":4},")"]
[]
[null,null,{"v":0,"d":"$0.00"},"for units with no turnover   (  #  of  Units",{"$nulls":4},")."]
[]
["STEP 4:  Since the calculation in Step 3 resulted in different rent levels for the same unit type, "]
["then a common rent level for this unit type must be derived.  Use the rent levels listed in Step 3 "]
["above to derive a new monthly Gross Rent Potential (GRP)."]
[]
[null,{"v":0,"d":"$0.00"},"for units with turnover  ",null,null,"X",0,"(# of units)","=",{"v":0,"d":"$0.00"}]
[]
[null,{"v":0,"d":"$0.00"},"for units with no turnover ",null,null,"X",0,"(# of units)","=",{"v":0,"d":"$0.00"}]
["(Add the two numbers which you just calculated to derive total)"]
[]
["GRP:"]
[]
[{"v":0,"d":"$0.00"},null,"+",{"v":0,"d":"$0.00"},null,"=",{"v":0,"d":"$0.00"}]
["Turnover GRP",null,null,"No Turnover GRP",null,null,"Total GRP"]
[]
["Divide Total GRP by the number of units for this unit type to obtain the new rent level for "]
["all",0,"BR Units."]
[]
[{"v":0,"d":"$0.00"},null,"Total GRP divide by",null,0,"units","=",{"$error":"#DIV/0!"}]
[]
["STEP 5:       The new rent level for all",{"$nulls":3},0,"   BR units is apporoved at",null,null,{"$error":"#DIV/0!"}]
["                               "]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}