{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["zarib tabaghat"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":56,"comments":0,"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":"zarib tabaghat","index":0,"n_rows":62,"n_cols":54,"rows_kept":62,"cut":false,"hidden":false,"merged":[[60,2,60,14],[57,5,57,8],[58,5,58,8],[57,2,57,4],[58,2,58,4],[57,9,57,14],[55,2,55,4],[56,2,56,4],[58,9,58,14],[50,2,50,4],[51,2,51,4],[50,5,50,8],[51,5,51,8],[53,2,53,4],[52,2,52,4],[54,2,54,4],[59,5,59,8],[59,2,59,4],[55,5,55,8],[56,5,56,8],[48,2,48,4],[49,2,49,4],[48,9,48,14],[49,9,49,14],[48,5,48,8],[49,5,49,8],[47,2,47,4],[44,5,44,8],[45,2,45,4],[46,2,46,4],[45,5,45,8],[46,5,46,8],[44,9,44,14],[44,2,44,4],[27,2,27,4],[23,2,23,4],[24,2,24,4],[25,2,25,4],[26,2,26,4],[33,9,33,14],[31,9,31,14],[6,3,6,4],[6,8,6,11],[21,5,22,8],[21,2,22,4],[21,9,22,14],[20,2,20,14],[27,9,27,14],[29,2,29,4],[30,2,30,4],[29,5,29,8],[30,5,30,8],[30,9,30,14],[32,9,32,14],[31,5,31,8],[31,2,31,4],[33,5,33,8],[25,9,25,14],[32,2,32,4],[33,2,33,4],[38,5,38,8],[34,2,34,4],[35,2,35,4],[28,9,28,14],[28,5,28,8],[28,2,28,4],[32,5,32,8],[36,2,36,4],[34,9,34,14],[35,9,35,14],[36,9,36,14],[34,5,34,8],[35,5,35,8],[37,2,37,4],[38,2,38,4],[36,5,36,8],[29,9,29,14],[39,2,39,4],[40,2,40,4],[41,2,41,4],[41,5,41,8],[39,9,39,14],[37,5,37,8],[61,5,61,11],[47,9,47,14],[47,5,47,8],[42,5,42,8],[43,5,43,8],[45,9,45,14],[46,9,46,14],[42,9,42,14],[52,9,52,14],[53,5,53,8],[50,9,50,14],[51,9,51,14],[53,9,53,14],[52,5,52,8],[54,5,54,8],[59,9,59,14],[42,2,42,4],[43,2,43,4],[6,5,6,7],[40,9,40,14],[41,9,41,14],[37,9,37,14],[38,9,38,14],[55,9,55,14],[56,9,56,14],[54,9,54,14],[40,5,40,8],[39,5,39,8],[43,9,43,14],[26,9,26,14],[23,5,23,8],[24,5,24,8],[25,5,25,8],[26,5,26,8],[23,9,23,14],[24,9,24,14],[27,5,27,8]]}
["شماره طبقه",30,{"$f":"B1-1","v":29},28,27,26,25,24,23,22,21,20,19,18,17,16,15,14,13,12,11,10,9,8,7,6,5,4,3,2,1,"همکف",-1,{"$f":"AG1-1","v":-2},{"$f":"AH1-1","v":-3},{"$f":"AI1-1","v":-4},{"$f":"AJ1-1","v":-5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(INT((1+(SUMPRODUCT(B1:AE1,B2:AE2)-SUMPRODUCT(AG1:AJ1,AH2:AK2))/100/SUM(B2:AK2))*100000)/10,0)/10000","v":1.04}]
["مساحت زیربنای هرطبقه",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,200,500,500,500,500,500,500,500,500,500,600,400,400,400,400]
[]
[]
[]
[]
[null,null,null,null,null,1.04,null,null,"ضریب طبقات  ="]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"پیوست دو: ضریب طبقات"]
[null,null,{"$f":"A1","v":"شماره طبقه"},null,null,{"$f":"A2","v":"مساحت زیربنای هرطبقه"},null,null,null," مساحت زیر بنای هر طبقه × شماره طبقه"]
["k","k"]
[1,{"$f":"IF(F24=0,0,1)","v":0},30,null,null,{"$f":"INDEX(B$2:AK$2,1,31-C24)","v":0},null,null,null,{"$f":"F24*C24","v":0}]
[null,0,{"$f":"C24-1","v":29},null,null,0,null,null,null,0]
[null,0,28,null,null,0,null,null,null,0]
[null,0,27,null,null,0,null,null,null,0]
[null,0,26,null,null,0,null,null,null,0]
[null,0,25,null,null,0,null,null,null,0]
[null,0,24,null,null,0,null,null,null,0]
[null,0,23,null,null,0,null,null,null,0]
[null,0,22,null,null,0,null,null,null,0]
[null,0,21,null,null,0,null,null,null,0]
[null,0,20,null,null,0,null,null,null,0]
[null,0,19,null,null,0,null,null,null,0]
[null,0,18,null,null,0,null,null,null,0]
[null,0,17,null,null,0,null,null,null,0]
[null,0,16,null,null,0,null,null,null,0]
[null,0,15,null,null,0,null,null,null,0]
[null,0,14,null,null,0,null,null,null,0]
[null,0,13,null,null,0,null,null,null,0]
[null,0,12,null,null,0,null,null,null,0]
[null,1,11,null,null,100,null,null,null,1100]
[null,1,10,null,null,200,null,null,null,2000]
[null,1,9,null,null,500,null,null,null,4500]
[null,1,8,null,null,500,null,null,null,4000]
[null,1,7,null,null,500,null,null,null,3500]
[null,1,6,null,null,500,null,null,null,3000]
[null,1,5,null,null,500,null,null,null,2500]
[null,1,4,null,null,500,null,null,null,2000]
[null,1,3,null,null,500,null,null,null,1500]
[null,1,2,null,null,500,null,null,null,1000]
[null,1,1,null,null,500,null,null,null,500]
[null,1,"همکف",null,null,{"$f":"AF2","v":600},null,null,null,"-"]
[null,1,{"$f":"C53-2","v":-1},null,null,{"$f":"INDEX(B$2:AK$2,1,31-C55)","v":400},null,null,null,"-"]
[null,1,{"$f":"C55-1","v":-2},null,null,{"$f":"INDEX(B$2:AK$2,1,31-C56)","v":400},null,null,null,{"$f":"-F56*C55","v":400}]
[null,1,{"$f":"C56-1","v":-3},null,null,{"$f":"INDEX(B$2:AK$2,1,31-C57)","v":400},null,null,null,{"$f":"-F57*C56","v":800}]
[null,1,{"$f":"C57-1","v":-4},null,null,{"$f":"INDEX(B$2:AK$2,1,31-C58)","v":400},null,null,null,{"$f":"-F58*C57","v":1200}]
[null,0,{"$f":"C58-1","v":-5},null,null,{"$f":"INDEX(B$2:AK$2,1,31-C59)","v":0},null,null,null,{"$f":"-F59*C58","v":0}]
[null,null,"جمع",null,null,{"$f":"SUM(F24:I59)","v":7000},null,null,null,{"$f":"SUM(J24:N59)","v":28000}]
[null,null,{"$f":"CONCATENATE(\"1 + \",\"[ \",J60,\" / \",\"( 100\",\" × \",F60,\" ) \",\"]\",\" = \",F7)","v":"1 + [ 28000 / ( 100 × 7000 ) ] = 1.04"}]
[null,null,null,null,null,"فرمول محاسبه ضریب طبقات"]