{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Rent Bundling Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"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"}

{"sheet":"Instructions","index":0,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,22,9]]}
[]
["INSTRUCTIONS\nAfter reviewing these instructions, navigate to the Rent Bundling Worksheet\n\nStep 1: Enter the Project Name, the Section 8 Conversion Type (i.e. PBV or PBRA) and whether the project will gain or lose subsidy in Rows 5-7 of this worksheet. If you are proposing to include more than 4 projects in a bundle, select columns Q & AP, right-click with your mouse, and select \"Unhide.\"\n\nStep 2: Enter the converting units and the current contract rents. These amounts will be used to calculate the initial Gross Potential Rent of the project as currently funded.\n\nStep 3: Enter the appropriate Reasonable Rents (rows 39-46), Fair Market Rents (rows 48-54), and Utility Allowance (rows 57-63) respectively. These amounts will be used to test the proposed rents against the PBV or PBRA rent caps. For Utility allowances, make sure to enter the current utility allowances in effect for the property.\n\nStep 4: Enter Proposed Rents in Rows 23-29. Make sure that proposed rents do not exceed the applicable rent caps. Use the summary table above to make sure that current and proposed rents match."]

{"sheet":"Rent Bundling Worksheet","index":1,"n_rows":80,"n_cols":51,"rows_kept":80,"cut":false,"hidden":false,"merged":[[4,37,4,38],[7,37,7,39],[32,37,32,39],[33,37,33,39],[17,37,17,39],[18,37,18,39],[19,37,19,39],[29,37,29,39],[30,37,30,39],[32,25,32,27],[32,29,32,31],[32,33,32,35],[33,25,33,27],[33,29,33,31],[33,33,33,35],[29,25,29,27],[29,29,29,31],[29,33,29,35],[30,25,30,27],[30,29,30,31],[30,33,30,35],[18,25,18,27],[18,29,18,31],[18,33,18,35],[33,13,33,15],[33,17,33,19],[4,21,4,22],[7,21,7,23],[17,21,17,23],[18,21,18,23],[19,21,19,23],[29,21,29,23],[30,21,30,23],[32,21,32,23],[33,21,33,23],[29,13,29,15],[29,17,29,19],[30,13,30,15],[30,17,30,19],[32,13,32,15],[32,17,32,19],[19,17,19,19],[4,17,4,18],[7,13,7,15],[7,17,7,19],[7,25,7,27],[7,29,7,31],[7,33,7,35],[17,25,17,27],[17,29,17,31],[17,33,17,35],[4,25,4,26],[4,29,4,30],[4,33,4,34],[37,41,44,46],[32,41,34,46],[0,41,1,46],[0,6,0,7],[1,6,1,7],[0,8,0,9],[1,8,1,9],[0,10,0,11],[1,10,1,11],[9,41,16,46],[20,41,27,46],[29,9,29,11],[30,9,30,11],[32,9,32,11],[33,9,33,11],[4,13,4,14],[4,9,4,10],[7,9,7,11],[17,9,17,11],[18,9,18,11],[30,5,30,7],[17,13,17,15],[17,17,17,19],[19,25,19,27],[32,1,32,3],[33,1,33,3],[32,5,32,7],[33,5,33,7],[30,1,30,3],[4,41,7,46],[4,5,4,6],[4,1,4,2],[18,1,18,3],[29,1,29,3],[17,1,17,3],[29,5,29,7],[17,5,17,7],[19,1,19,3],[7,1,7,3],[7,5,7,7],[18,5,18,7],[19,5,19,7],[19,9,19,11],[18,13,18,15],[18,17,18,19],[19,13,19,15],[19,29,19,31],[19,33,19,35]]}
[null,"RAD RENT BUNDLING WORKSHEET",{"$nulls":4},"Bundled Projects:",null,"Current Rents (Monthly)",null,"Proposed Rents (Monthly)"]
[{"$nulls":5},"TOTALS",{"$f":"COUNTIF(17:17,\">0\")","v":0},null,{"$f":"SUM(19:19)","v":0},null,{"$f":"SUM(31:31)","v":0},null,{"$f":"IF(K2>I2,\"Proposed Rents are Too High\",IF(I2-50>K2,\"Proposed Rents are Too Low\",\"\"))","v":""}]
[]
[{"$nulls":49},"PBV","PBRA"]
[null,"Property Name:",null,null,null,{"$f":"$B$5","v":"Property Name:"},null,null,null,{"$f":"$B$5","v":"Property Name:"},null,null,null,{"$f":"$B$5","v":"Property Name:"},null,null,null,{"$f":"$B$5","v":"Property Name:"},null,null,null,{"$f":"$B$5","v":"Property Name:"},null,null,null,{"$f":"$B$5","v":"Property Name:"},null,null,null,{"$f":"$B$5","v":"Property Name:"},null,null,null,{"$f":"$B$5","v":"Property Name:"},null,null,null,{"$f":"$B$5","v":"Property Name:"},null,null,null,"Enter the Property Name, the Section 8 Conversion Type (i.e. PBV or PBRA) and whether the project will gain or lose subsidy in Rows 5-7 of this worksheet. If you are proposing to include more than 4 projects in a bundle, select columns Q & AP, right-click with your mouse, and select \"Unhide.\"",{"$nulls":7},"PBRA"]
[null,null,"Conversion Type:",null,null,null,{"$f":"$C$6","v":"Conversion Type:"},null,null,null,{"$f":"$C$6","v":"Conversion Type:"},null,null,null,{"$f":"$C$6","v":"Conversion Type:"},null,null,null,{"$f":"$C$6","v":"Conversion Type:"},null,null,null,{"$f":"$C$6","v":"Conversion Type:"},null,null,null,{"$f":"$C$6","v":"Conversion Type:"},null,null,null,{"$f":"$C$6","v":"Conversion Type:"},null,null,null,{"$f":"$C$6","v":"Conversion Type:"},null,null,null,{"$f":"$C$6","v":"Conversion Type:"}]
[null,null,"Gain/Lose:",{"$f":"IF(B19>B31,\"Lose\",IF(B19<B31,\"Gain\",\"-\"))","v":"-"},null,null,{"$f":"$C$7","v":"Gain/Lose:"},{"$f":"IF(F19>F31,\"Lose\",IF(F19<F31,\"Gain\",\"-\"))","v":"-"},null,null,{"$f":"$C$7","v":"Gain/Lose:"},{"$f":"IF(J19>J31,\"Lose\",IF(J19<J31,\"Gain\",\"-\"))","v":"-"},null,null,{"$f":"$C$7","v":"Gain/Lose:"},{"$f":"IF(N19>N31,\"Lose\",IF(N19<N31,\"Gain\",\"-\"))","v":"-"},null,null,{"$f":"$C$7","v":"Gain/Lose:"},{"$f":"IF(R19>R31,\"Lose\",IF(R19<R31,\"Gain\",\"-\"))","v":"-"},null,null,{"$f":"$C$7","v":"Gain/Lose:"},{"$f":"IF(V19>V31,\"Lose\",IF(V19<V31,\"Gain\",\"-\"))","v":"-"},null,null,{"$f":"$C$7","v":"Gain/Lose:"},{"$f":"IF(Z19>Z31,\"Lose\",IF(Z19<Z31,\"Gain\",\"-\"))","v":"-"},null,null,{"$f":"$C$7","v":"Gain/Lose:"},{"$f":"IF(AD19>AD31,\"Lose\",IF(AD19<AD31,\"Gain\",\"-\"))","v":"-"},null,null,{"$f":"$C$7","v":"Gain/Lose:"},{"$f":"IF(AH19>AH31,\"Lose\",IF(AH19<AH31,\"Gain\",\"-\"))","v":"-"},null,null,{"$f":"$C$7","v":"Gain/Lose:"},{"$f":"IF(AL19>AL31,\"Lose\",IF(AL19<AL31,\"Gain\",\"-\"))","v":"-"}]
[null,"Current Rents",null,null,null,{"$f":"$B$8","v":"Current Rents"},null,null,null,{"$f":"$B$8","v":"Current Rents"},null,null,null,{"$f":"$B$8","v":"Current Rents"},null,null,null,{"$f":"$B$8","v":"Current Rents"},null,null,null,{"$f":"$B$8","v":"Current Rents"},null,null,null,{"$f":"$B$8","v":"Current Rents"},null,null,null,{"$f":"$B$8","v":"Current Rents"},null,null,null,{"$f":"$B$8","v":"Current Rents"},null,null,null,{"$f":"$B$8","v":"Current Rents"}]
[null,"BR","Units","Contract Rent",null,"BR",{"$f":"$C$9","v":"Units"},{"$f":"$D$9","v":"Contract Rent"},null,"BR",{"$f":"$C$9","v":"Units"},{"$f":"$D$9","v":"Contract Rent"},null,"BR",{"$f":"$C$9","v":"Units"},{"$f":"$D$9","v":"Contract Rent"},null,"BR",{"$f":"$C$9","v":"Units"},{"$f":"$D$9","v":"Contract Rent"},null,"BR",{"$f":"$C$9","v":"Units"},{"$f":"$D$9","v":"Contract Rent"},null,"BR",{"$f":"$C$9","v":"Units"},{"$f":"$D$9","v":"Contract Rent"},null,"BR",{"$f":"$C$9","v":"Units"},{"$f":"$D$9","v":"Contract Rent"},null,"BR",{"$f":"$C$9","v":"Units"},{"$f":"$D$9","v":"Contract Rent"},null,"BR",{"$f":"$C$9","v":"Units"},{"$f":"$D$9","v":"Contract Rent"}]
[null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,"Enter the converting units and the current contract rents. These amounts will be used to calculate the initial Gross Potential Rent of the project as currently funded."]
[null,1,null,null,null,1,null,null,null,1,null,null,null,1,null,null,null,1,null,null,null,1,null,null,null,1,null,null,null,1,null,null,null,1,null,null,null,1]
[null,2,null,null,null,2,null,null,null,2,null,null,null,2,null,null,null,2,null,null,null,2,null,null,null,2,null,null,null,2,null,null,null,2,null,null,null,2]
[null,3,null,null,null,3,null,null,null,3,null,null,null,3,null,null,null,3,null,null,null,3,null,null,null,3,null,null,null,3,null,null,null,3,null,null,null,3]
[null,4,null,null,null,4,null,null,null,4,null,null,null,4,null,null,null,4,null,null,null,4,null,null,null,4,null,null,null,4,null,null,null,4,null,null,null,4]
[null,5,null,null,null,5,null,null,null,5,null,null,null,5,null,null,null,5,null,null,null,5,null,null,null,5,null,null,null,5,null,null,null,5,null,null,null,5]
[null,6,null,null,null,6,null,null,null,6,null,null,null,6,null,null,null,6,null,null,null,6,null,null,null,6,null,null,null,6,null,null,null,6,null,null,null,6]
[null,null,{"$f":"SUM(C10:C16)","v":0},null,null,null,{"$f":"SUM(G10:G16)","v":0},null,null,null,{"$f":"SUM(K10:K16)","v":0},null,null,null,{"$f":"SUM(O10:O16)","v":0},null,null,null,{"$f":"SUM(S10:S16)","v":0},null,null,null,{"$f":"SUM(W10:W16)","v":0},null,null,null,{"$f":"SUM(AA10:AA16)","v":0},null,null,null,{"$f":"SUM(AE10:AE16)","v":0},null,null,null,{"$f":"SUM(AI10:AI16)","v":0},null,null,null,{"$f":"SUM(AM10:AM16)","v":0}]
[null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)"]
[null,{"$f":"SUMPRODUCT(C10:C16,D10:D16)","v":0},null,null,null,{"$f":"SUMPRODUCT(G10:G16,H10:H16)","v":0},null,null,null,{"$f":"SUMPRODUCT(K10:K16,L10:L16)","v":0},null,null,null,{"$f":"SUMPRODUCT(O10:O16,P10:P16)","v":0},null,null,null,{"$f":"SUMPRODUCT(S10:S16,T10:T16)","v":0},null,null,null,{"$f":"SUMPRODUCT(W10:W16,X10:X16)","v":0},null,null,null,{"$f":"SUMPRODUCT(AA10:AA16,AB10:AB16)","v":0},null,null,null,{"$f":"SUMPRODUCT(AE10:AE16,AF10:AF16)","v":0},null,null,null,{"$f":"SUMPRODUCT(AI10:AI16,AJ10:AJ16)","v":0},null,null,null,{"$f":"SUMPRODUCT(AM10:AM16,AN10:AN16)","v":0}]
[null,"Proposed Rents",null,null,null,"Proposed Rents",null,null,null,"Proposed Rents",null,null,null,"Proposed Rents",null,null,null,"Proposed Rents",null,null,null,"Proposed Rents",null,null,null,"Proposed Rents",null,null,null,"Proposed Rents",null,null,null,"Proposed Rents",null,null,null,"Proposed Rents"]
[null,"BR","Units","Contract Rent\nPost-Bundling",null,"BR","Units","Contract Rent\nPost-Bundling",null,"BR","Units","Contract Rent\nPost-Bundling",null,"BR","Units","Contract Rent\nPost-Bundling",null,"BR","Units","Contract Rent\nPost-Bundling",null,"BR","Units","Contract Rent\nPost-Bundling",null,"BR","Units","Contract Rent\nPost-Bundling",null,"BR","Units","Contract Rent\nPost-Bundling",null,"BR","Units","Contract Rent\nPost-Bundling",null,"BR","Units","Contract Rent\nPost-Bundling",null,"After you have entered Reasonable Rents and FMRs below, enter Proposed Rents in Rows 23-29. Make sure that proposed rents do not exceed the applicable rent caps. Use the summary table above to make sure that current and proposed rents match. "]
[null,0,{"$f":"C10","v":0},null,{"$f":"IF(OR(AND(D$6=$AX$4,D22>D65),AND(D$6=$AY$4,D22>D74)),\"Rent Cap!\",\"\")","v":""},0,{"$f":"G10","v":0},null,{"$f":"IF(OR(AND(H$6=$AX$4,H22>H65),AND(H$6=$AY$4,H22>H74)),\"Rent Cap!\",\"\")","v":""},0,{"$f":"K10","v":0},null,{"$f":"IF(OR(AND(L$6=$AX$4,L22>L65),AND(L$6=$AY$4,L22>L74)),\"Rent Cap!\",\"\")","v":""},0,{"$f":"O10","v":0},null,{"$f":"IF(OR(AND(P$6=$AX$4,P22>P65),AND(P$6=$AY$4,P22>P74)),\"Rent Cap!\",\"\")","v":""},0,{"$f":"S10","v":0},null,{"$f":"IF(OR(AND(T$6=$AX$4,T22>T65),AND(T$6=$AY$4,T22>T74)),\"Rent Cap!\",\"\")","v":""},0,{"$f":"W10","v":0},null,{"$f":"IF(OR(AND(X$6=$AX$4,X22>X65),AND(X$6=$AY$4,X22>X74)),\"Rent Cap!\",\"\")","v":""},0,{"$f":"AA10","v":0},null,{"$f":"IF(OR(AND(AB$6=$AX$4,AB22>AB65),AND(AB$6=$AY$4,AB22>AB74)),\"Rent Cap!\",\"\")","v":""},0,{"$f":"AE10","v":0},null,{"$f":"IF(OR(AND(AF$6=$AX$4,AF22>AF65),AND(AF$6=$AY$4,AF22>AF74)),\"Rent Cap!\",\"\")","v":""},0,{"$f":"AI10","v":0},null,{"$f":"IF(OR(AND(AJ$6=$AX$4,AJ22>AJ65),AND(AJ$6=$AY$4,AJ22>AJ74)),\"Rent Cap!\",\"\")","v":""},0,{"$f":"AM10","v":0},null,{"$f":"IF(OR(AND(AN$6=$AX$4,AN22>AN65),AND(AN$6=$AY$4,AN22>AN74)),\"Rent Cap!\",\"\")","v":""}]
[null,1,{"$f":"C11","v":0},null,"",1,{"$f":"G11","v":0},null,"",1,{"$f":"K11","v":0},null,"",1,{"$f":"O11","v":0},null,"",1,{"$f":"S11","v":0},null,"",1,{"$f":"W11","v":0},null,"",1,{"$f":"AA11","v":0},null,"",1,{"$f":"AE11","v":0},null,"",1,{"$f":"AI11","v":0},null,"",1,{"$f":"AM11","v":0},null,""]
[null,2,0,null,"",2,0,null,"",2,0,null,"",2,0,null,"",2,0,null,"",2,0,null,"",2,0,null,"",2,0,null,"",2,0,null,"",2,0,null,""]
[null,3,0,null,"",3,0,null,"",3,0,null,"",3,0,null,"",3,0,null,"",3,0,null,"",3,0,null,"",3,0,null,"",3,0,null,"",3,0,null,""]
[null,4,0,null,"",4,0,null,"",4,0,null,"",4,0,null,"",4,0,null,"",4,0,null,"",4,0,null,"",4,0,null,"",4,0,null,"",4,0,null,""]
[null,5,0,null,"",5,0,null,"",5,0,null,"",5,0,null,"",5,0,null,"",5,0,null,"",5,0,null,"",5,0,null,"",5,0,null,"",5,0,null,""]
[null,6,0,null,"",6,0,null,"",6,0,null,"",6,0,null,"",6,0,null,"",6,0,null,"",6,0,null,"",6,0,null,"",6,0,null,"",6,0,null,""]
[null,null,{"$f":"SUM(C22:C28)","v":0},null,null,null,{"$f":"SUM(G22:G28)","v":0},null,null,null,{"$f":"SUM(K22:K28)","v":0},null,null,null,{"$f":"SUM(O22:O28)","v":0},null,null,null,{"$f":"SUM(S22:S28)","v":0},null,null,null,{"$f":"SUM(W22:W28)","v":0},null,null,null,{"$f":"SUM(AA22:AA28)","v":0},null,null,null,{"$f":"SUM(AE22:AE28)","v":0},null,null,null,{"$f":"SUM(AI22:AI28)","v":0},null,null,null,{"$f":"SUM(AM22:AM28)","v":0}]
[null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)",null,null,null,"Gross Potential Rent (Monthly)"]
[null,{"$f":"SUMPRODUCT(C22:C28,D22:D28)","v":0},null,null,null,{"$f":"SUMPRODUCT(G22:G28,H22:H28)","v":0},null,null,null,{"$f":"SUMPRODUCT(K22:K28,L22:L28)","v":0},null,null,null,{"$f":"SUMPRODUCT(O22:O28,P22:P28)","v":0},null,null,null,{"$f":"SUMPRODUCT(S22:S28,T22:T28)","v":0},null,null,null,{"$f":"SUMPRODUCT(W22:W28,X22:X28)","v":0},null,null,null,{"$f":"SUMPRODUCT(AA22:AA28,AB22:AB28)","v":0},null,null,null,{"$f":"SUMPRODUCT(AE22:AE28,AF22:AF28)","v":0},null,null,null,{"$f":"SUMPRODUCT(AI22:AI28,AJ22:AJ28)","v":0},null,null,null,{"$f":"SUMPRODUCT(AM22:AM28,AN22:AN28)","v":0}]
[]
[null,"RAD Application \"Other Income\"",null,null,null,"RAD Application \"Other Income\"",null,null,null,"RAD Application \"Other Income\"",null,null,null,"RAD Application \"Other Income\"",null,null,null,"RAD Application \"Other Income\"",null,null,null,"RAD Application \"Other Income\"",null,null,null,"RAD Application \"Other Income\"",null,null,null,"RAD Application \"Other Income\"",null,null,null,"RAD Application \"Other Income\"",null,null,null,"RAD Application \"Other Income\""]
[null,{"$f":"(B31-B19)*12","v":0},null,null,null,{"$f":"(F31-F19)*12","v":0},null,null,null,{"$f":"(J31-J19)*12","v":0},null,null,null,{"$f":"(N31-N19)*12","v":0},null,null,null,{"$f":"(R31-R19)*12","v":0},null,null,null,{"$f":"(V31-V19)*12","v":0},null,null,null,{"$f":"(Z31-Z19)*12","v":0},null,null,null,{"$f":"(AD31-AD19)*12","v":0},null,null,null,{"$f":"(AH31-AH19)*12","v":0},null,null,null,{"$f":"(AL31-AL19)*12","v":0}]
[]
[null,"ENTER RENT CAP INFO",null,null,null,"ENTER RENT CAP INFO",null,null,null,"ENTER RENT CAP INFO",null,null,null,"ENTER RENT CAP INFO",null,null,null,"ENTER RENT CAP INFO",null,null,null,"ENTER RENT CAP INFO",null,null,null,"ENTER RENT CAP INFO",null,null,null,"ENTER RENT CAP INFO",null,null,null,"ENTER RENT CAP INFO",null,null,null,"ENTER RENT CAP INFO"]
[null,"Reasonable Rents",null,null,null,"Reasonable Rents",null,null,null,"Reasonable Rents",null,null,null,"Reasonable Rents",null,null,null,"Reasonable Rents",null,null,null,"Reasonable Rents",null,null,null,"Reasonable Rents",null,null,null,"Reasonable Rents",null,null,null,"Reasonable Rents",null,null,null,"Reasonable Rents"]
[null,"0 Bedroom",null,0,null,"0 Bedroom",null,0,null,"0 Bedroom",null,0,null,"0 Bedroom",null,0,null,"0 Bedroom",null,0,null,"0 Bedroom",null,0,null,"0 Bedroom",null,0,null,"0 Bedroom",null,0,null,"0 Bedroom",null,0,null,"0 Bedroom",null,0,null,"Enter the appropriate Reasonable Rents (rows 39-46), Fair Market Rents (rows 48-54), and Utility Allowance (rows 57-63) respectively. These amounts will be used to test the proposed rents against the PBV or PBRA rent caps. For Utility allowances, make sure to enter the current utility allowances in effect for the property."]
[null,"1 Bedroom",null,0,null,"1 Bedroom",null,0,null,"1 Bedroom",null,0,null,"1 Bedroom",null,0,null,"1 Bedroom",null,0,null,"1 Bedroom",null,0,null,"1 Bedroom",null,0,null,"1 Bedroom",null,0,null,"1 Bedroom",null,0,null,"1 Bedroom",null,0]
[null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0]
[null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0]
[null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0]
[null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0]
[null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0]
[]
[null,"Fair Market Rents",null,null,null,"Fair Market Rents",null,null,null,"Fair Market Rents",null,null,null,"Fair Market Rents",null,null,null,"Fair Market Rents",null,null,null,"Fair Market Rents",null,null,null,"Fair Market Rents",null,null,null,"Fair Market Rents",null,null,null,"Fair Market Rents",null,null,null,"Fair Market Rents"]
[null,"0 Bedroom",null,0,null,"0 Bedroom",null,{"$f":"D47","v":0},null,"0 Bedroom",null,{"$f":"H47","v":0},null,"0 Bedroom",null,{"$f":"L47","v":0},null,"0 Bedroom",null,{"$f":"P47","v":0},null,"0 Bedroom",null,{"$f":"T47","v":0},null,"0 Bedroom",null,{"$f":"X47","v":0},null,"0 Bedroom",null,{"$f":"AB47","v":0},null,"0 Bedroom",null,{"$f":"AF47","v":0},null,"0 Bedroom",null,{"$f":"AJ47","v":0}]
[null,"1 Bedroom",null,0,null,"1 Bedroom",null,{"$f":"D48","v":0},null,"1 Bedroom",null,{"$f":"H48","v":0},null,"1 Bedroom",null,0,null,"1 Bedroom",null,{"$f":"P48","v":0},null,"1 Bedroom",null,{"$f":"T48","v":0},null,"1 Bedroom",null,0,null,"1 Bedroom",null,{"$f":"AB48","v":0},null,"1 Bedroom",null,{"$f":"AF48","v":0},null,"1 Bedroom",null,{"$f":"AJ48","v":0}]
[null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0]
[null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0]
[null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0]
[null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0]
[null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0]
[]
[null,"Utility Allowance (Current)",null,null,null,{"$f":"$B$55","v":"Utility Allowance (Current)"},null,null,null,{"$f":"$B$55","v":"Utility Allowance (Current)"},null,null,null,{"$f":"$B$55","v":"Utility Allowance (Current)"},null,null,null,{"$f":"$B$55","v":"Utility Allowance (Current)"},null,null,null,{"$f":"$B$55","v":"Utility Allowance (Current)"},null,null,null,{"$f":"$B$55","v":"Utility Allowance (Current)"},null,null,null,{"$f":"$B$55","v":"Utility Allowance (Current)"},null,null,null,{"$f":"$B$55","v":"Utility Allowance (Current)"},null,null,null,{"$f":"$B$55","v":"Utility Allowance (Current)"}]
[null,"0 Bedroom",null,0,null,"0 Bedroom",null,{"$f":"D56","v":0},null,"0 Bedroom",null,{"$f":"H56","v":0},null,"0 Bedroom",null,{"$f":"L56","v":0},null,"0 Bedroom",null,{"$f":"P56","v":0},null,"0 Bedroom",null,{"$f":"T56","v":0},null,"0 Bedroom",null,{"$f":"X56","v":0},null,"0 Bedroom",null,{"$f":"AB56","v":0},null,"0 Bedroom",null,{"$f":"AF56","v":0},null,"0 Bedroom",null,{"$f":"AJ56","v":0}]
[null,"1 Bedroom",null,0,null,"1 Bedroom",null,{"$f":"D57","v":0},null,"1 Bedroom",null,{"$f":"H57","v":0},null,"1 Bedroom",null,0,null,"1 Bedroom",null,{"$f":"P57","v":0},null,"1 Bedroom",null,{"$f":"T57","v":0},null,"1 Bedroom",null,0,null,"1 Bedroom",null,{"$f":"AB57","v":0},null,"1 Bedroom",null,{"$f":"AF57","v":0},null,"1 Bedroom",null,{"$f":"AJ57","v":0}]
[null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0]
[null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0]
[null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0]
[null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0]
[null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0]
[]
[null,"PBV Rent Caps",null,null,null,"PBV Rent Caps",null,null,null,"PBV Rent Caps",null,null,null,"PBV Rent Caps",null,null,null,"PBV Rent Caps",null,null,null,"PBV Rent Caps",null,null,null,"PBV Rent Caps",null,null,null,"PBV Rent Caps",null,null,null,"PBV Rent Caps",null,null,null,"PBV Rent Caps"]
[null,"0 Bedroom",null,{"$f":"MIN(D38,D47*1.1-D56)","v":0},null,"0 Bedroom",null,{"$f":"MIN(H38,H47*1.1-H56)","v":0},null,"0 Bedroom",null,{"$f":"MIN(L38,L47*1.1-L56)","v":0},null,"0 Bedroom",null,{"$f":"MIN(P38,P47*1.1-P56)","v":0},null,"0 Bedroom",null,{"$f":"MIN(T38,T47*1.1-T56)","v":0},null,"0 Bedroom",null,{"$f":"MIN(X38,X47*1.1)","v":0},null,"0 Bedroom",null,{"$f":"MIN(AB38,AB47*1.1-AB56)","v":0},null,"0 Bedroom",null,{"$f":"MIN(AF38,AF47*1.1-AF56)","v":0},null,"0 Bedroom",null,{"$f":"MIN(AJ38,AJ47*1.1)","v":0},null,"0 Bedroom",null,{"$f":"MIN(AN38,AN47*1.1)","v":0}]
[null,"1 Bedroom",null,{"$f":"MIN(D39,D48*1.1-D57)","v":0},null,"1 Bedroom",null,{"$f":"MIN(H39,H48*1.1-H57)","v":0},null,"1 Bedroom",null,{"$f":"MIN(L39,L48*1.1-L57)","v":0},null,"1 Bedroom",null,{"$f":"MIN(P39,P48*1.1-P57)","v":0},null,"1 Bedroom",null,{"$f":"MIN(T39,T48*1.1-T57)","v":0},null,"1 Bedroom",null,{"$f":"MIN(X39,X48*1.1)","v":0},null,"1 Bedroom",null,{"$f":"MIN(AB39,AB48*1.1-AB57)","v":0},null,"1 Bedroom",null,{"$f":"MIN(AF39,AF48*1.1-AF57)","v":0},null,"1 Bedroom",null,{"$f":"MIN(AJ39,AJ48*1.1)","v":0},null,"1 Bedroom",null,{"$f":"MIN(AN39,AN48*1.1)","v":0}]
[null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0]
[null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0]
[null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0]
[null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0]
[null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0]
[]
[null,"PBRA Rent Caps",null,null,null,"PBRA Rent Caps",null,null,null,"PBRA Rent Caps",null,null,null,"PBRA Rent Caps",null,null,null,"PBRA Rent Caps",null,null,null,"PBRA Rent Caps",null,null,null,"PBRA Rent Caps",null,null,null,"PBRA Rent Caps",null,null,null,"PBRA Rent Caps",null,null,null,"PBRA Rent Caps"]
[null,"0 Bedroom",null,{"$f":"D47*1.2-D56","v":0},null,"0 Bedroom",null,{"$f":"H47*1.2-H56","v":0},null,"0 Bedroom",null,{"$f":"L47*1.2-L56","v":0},null,"0 Bedroom",null,{"$f":"P47*1.2-P56","v":0},null,"0 Bedroom",null,{"$f":"T47*1.2-T56","v":0},null,"0 Bedroom",null,{"$f":"X47*1.2","v":0},null,"0 Bedroom",null,{"$f":"AB47*1.2-AB56","v":0},null,"0 Bedroom",null,{"$f":"AF47*1.2-AF56","v":0},null,"0 Bedroom",null,{"$f":"AJ47*1.2","v":0},null,"0 Bedroom",null,{"$f":"AN47*1.2","v":0}]
[null,"1 Bedroom",null,{"$f":"D48*1.2-D57","v":0},null,"1 Bedroom",null,{"$f":"H48*1.2-H57","v":0},null,"1 Bedroom",null,{"$f":"L48*1.2-L57","v":0},null,"1 Bedroom",null,{"$f":"P48*1.2-P57","v":0},null,"1 Bedroom",null,{"$f":"T48*1.2-T57","v":0},null,"1 Bedroom",null,{"$f":"X48*1.2","v":0},null,"1 Bedroom",null,{"$f":"AB48*1.2-AB57","v":0},null,"1 Bedroom",null,{"$f":"AF48*1.2-AF57","v":0},null,"1 Bedroom",null,{"$f":"AJ48*1.2","v":0},null,"1 Bedroom",null,{"$f":"AN48*1.2","v":0}]
[null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0,null,"2 Bedroom",null,0]
[null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0,null,"3 Bedroom",null,0]
[null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0,null,"4 Bedroom",null,0]
[null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0,null,"5 Bedroom",null,0]
[null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0,null,"6 Bedroom",null,0]