{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Данные","Итог"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Данные","index":0,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["ДОМ","ПЛОЩАДЬ"]
["12/33 ?","47/?/15",12,33,"Панельный",47,null,null,null,{"$f":"LEFT(A2,SEARCH(\"/\",A2)-1)","v":"12"},{"$f":"MID(A2,SEARCH(\"/\",A2)+1,SEARCH(\" \",A2)-SEARCH(\"/\",A2))","v":"33 "},{"$f":"MID(A2,FIND(\" \",A2)+1,LEN(A2)-FIND(\" \",A2))","v":"?"},{"$f":"IF(OR(L2=\"?\",L2=\"П\",L2=\"БП\"),\"Панельный\",IF(OR(L2=\"М\",L2=\"Э\",L2=\"МК\"),\"Монолитный\",IF(OR(L2=\"К\",L2=\"С\"),\"Кирпичный\",IF(L2=\"Б\",\"Блочный\",\"\"))))","v":"Панельный"},{"$f":"MID(B2,1,SEARCH(\"/\",B2)-1)","v":"47"}]
["6/12 ?","37/?/9",6,12,"Панельный",37,null,null,null,{"$f":"LEFT(A3,SEARCH(\"/\",A3)-1)","v":"6"},{"$f":"MID(A3,SEARCH(\"/\",A3)+1,SEARCH(\" \",A3)-SEARCH(\"/\",A3))","v":"12 "},{"$f":"MID(A3,FIND(\" \",A3)+1,LEN(A3)-FIND(\" \",A3))","v":"?"},{"$f":"IF(OR(L3=\"?\",L3=\"П\",L3=\"БП\"),\"Панельный\",IF(OR(L3=\"М\",L3=\"Э\",L3=\"МК\"),\"Монолитный\",IF(OR(L3=\"К\",L3=\"С\"),\"Кирпичный\",IF(L3=\"Б\",\"Блочный\",\"\"))))","v":"Панельный"},{"$f":"MID(B3,1,SEARCH(\"/\",B3)-1)","v":"37"}]
["3/9 П","45/32/7",3,9,"Панельный",45,null,null,null,"3","9 ","П","Панельный","45"]
["6/22 МК","80/?/14",6,22,"Монолитный",80,null,null,null,"6","22 ","МК","Монолитный","80"]
["8/9 П","39/20/7",8,9,"Панельный",39,null,null,null,"8","9 ","П","Панельный","39"]
["8/30 М","49/?/12",8,30,"Монолитный",49,null,null,null,"8","30 ","М","Монолитный","49"]
["2/5 П","36/?/6",2,5,"Панельный",36,null,null,null,"2","5 ","П","Панельный","36"]
["1/5 ?","31/?/6",1,5,"Панельный",31,null,null,null,"1","5 ","?","Панельный","31"]
["5/5 Б","44.4/30/6",5,5,"Блочный",44.4,null,null,null,"5","5 ","Б","Блочный","44.4"]
["2/12 Б","37.9/23/6.5",2,12,"Блочный",37.9,null,null,null,"2","12 ","Б","Блочный","37.9"]
["5/17 М","48/?/?",5,17,"Монолитный",48,null,null,null,"5","17 ","М",{"$f":"IF(OR(MID(A12,FIND(\" \",A12)+1,LEN(A12)-FIND(\" \",A12))=\"?\",MID(A12,FIND(\" \",A12)+1,LEN(A12)-FIND(\" \",A12))=\"П\",MID(A12,FIND(\" \",A12)+1,LEN(A12)-FIND(\" \",A12))=\"БП\"),\"Панельный\",IF(OR(MID(A12,FIND(\" \",A12)+1,LEN(A12)-FIND(\" \",A12))=\"М\",MID(A12,FIND(\" \",A12)+1,LEN(A12)-FIND(\" \",A12))=\"Э\",MID(A12,FIND(\" \",A12)+1,LEN(A12)-FIND(\" \",A12))=\"МК\"),\"Монолитный\",IF(OR(MID(A12,FIND(\" \",A12)+1,LEN(A12)-FIND(\" \",A12))=\"К\",MID(A12,FIND(\" \",A12)+1,LEN(A12)-FIND(\" \",A12))=\"С\"),\"Кирпичный\",IF(MID(A12,FIND(\" \",A12)+1,LEN(A12)-FIND(\" \",A12))=\"Б\",\"Блочный\",\"\"))))","v":"Монолитный"},"48"]
["7/13 П","45/?/8",7,13,"Панельный",45,null,null,null,"7","13 ","П",{"$f":"IF(OR(MID(A13,FIND(\" \",A13)+1,LEN(A13)-FIND(\" \",A13))=\"?\",MID(A13,FIND(\" \",A13)+1,LEN(A13)-FIND(\" \",A13))=\"П\",MID(A13,FIND(\" \",A13)+1,LEN(A13)-FIND(\" \",A13))=\"БП\"),\"Панельный\",IF(OR(MID(A13,FIND(\" \",A13)+1,LEN(A13)-FIND(\" \",A13))=\"М\",MID(A13,FIND(\" \",A13)+1,LEN(A13)-FIND(\" \",A13))=\"Э\",MID(A13,FIND(\" \",A13)+1,LEN(A13)-FIND(\" \",A13))=\"МК\"),\"Монолитный\",IF(OR(MID(A13,FIND(\" \",A13)+1,LEN(A13)-FIND(\" \",A13))=\"К\",MID(A13,FIND(\" \",A13)+1,LEN(A13)-FIND(\" \",A13))=\"С\"),\"Кирпичный\",IF(MID(A13,FIND(\" \",A13)+1,LEN(A13)-FIND(\" \",A13))=\"Б\",\"Блочный\",\"\"))))","v":"Панельный"},"45"]
["12/17 П","38/19/10",12,17,"Панельный",38,null,null,null,"12","17 ","П","Панельный","38"]
["5/5 К","38/20/9",5,5,"Кирпичный",38,null,null,null,"5","5 ","К","Кирпичный","38"]
["14/30 Э","46/22/12",14,30,"Монолитный",46,null,null,null,"14","30 ","Э","Монолитный","46"]
["5/17 П","39/?/10",5,17,"Панельный",39,null,null,null,"5","17 ","П","Панельный","39"]
["14/30 М","46/22/12",14,30,"Монолитный",46,null,null,null,"14","30 ","М","Монолитный","46"]
["4/5 П","30/18/6",4,5,"Панельный",30,null,null,null,"4","5 ","П","Панельный","30"]
["2/9 П","33/20/8",2,9,"Панельный",33,null,null,null,"2","9 ","П","Панельный","33"]
["8/25 МК","60/?/12",8,25,"Монолитный",60,null,null,null,"8","25 ","МК","Монолитный","60"]
["7/9 П","46/29/6",7,9,"Панельный",46,null,null,null,"7","9 ","П","Панельный","46"]
["11/30 М","49/33/10",11,30,"Монолитный",49,null,null,null,"11","30 ","М","Монолитный","49"]

{"sheet":"Итог","index":1,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[12,33,"Панельный",47]
[6,12,"Панельный",37]
[3,9,"Панельный",45]
[6,22,"Монолитный",80]
[8,9,"Панельный",39]
[8,30,"Монолитный",49]
[2,5,"Панельный",36]
[1,5,"Панельный",31]
[5,5,"Блочный",44.4]
[2,12,"Блочный",37.9]
[5,17,"Монолитный",48]
[7,13,"Панельный",45]
[12,17,"Панельный",38]
[5,5,"Кирпичный",38]
[14,30,"Монолитный",46]
[5,17,"Панельный",39]
[14,30,"Монолитный",46]
[4,5,"Панельный",30]
[2,9,"Панельный",33]
[8,25,"Монолитный",60]
[7,9,"Панельный",46]
[11,30,"Монолитный",49]