{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["исходная таблица","таблица","расчет"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":"исходная таблица","index":0,"n_rows":41,"n_cols":15,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Наименование","Наименование_текст","Высота","Ширина","Толщина","Кол-во","Цвет","Площадь",null,"Названия строк","Сумма по полю Площадь",null,null,1,"дсп"]
[4,{"$f":"IFERROR(VLOOKUP(A2,$N$1:$O$4,2,1),\"\")","v":"цоколь"},284,284,16,4,"бук",{"$f":"(C2*D2*E2)/1000000","v":1.2904960000000001},null,"двп",12.159343999999999,null,null,2,"фасад"]
[1,{"$f":"IFERROR(VLOOKUP(A3,$N$1:$O$4,2,1),\"\")","v":"дсп"},316,316,916,1,"дуб",91.468096000000003,null,"бук",10.172143999999999,null,null,3,"двп"]
[1,"дсп",300,616,16,2,"бук",2.9567999999999999,null,"дуб",1.9872000000000001,null,null,4,"цоколь"]
[1,"дсп",920,300,16,5,"дуб",4.4160000000000004,null,"дсп",218.51667200000003]
[4,"цоколь",920,32,16,1,"бук",0.47104000000000001,null,"бук",67.412096000000005]
[1,"дсп",300,568,16,5,"дуб",2.7263999999999999,null,"дуб",151.10457600000004]
[4,"цоколь",920,48,16,1,"бук",0.70655999999999997,null,"фасад",9.1647999999999996]
[1,"дсп",920,452,16,1,"дуб",6.6534399999999998,null,"зеленый",5.132288]
[1,"дсп",300,768,16,4,"бук",3.6863999999999999,null,"красный",4.0325119999999997]
[1,"дсп",616,600,38,1,"дуб",14.0448,null,"цоколь",2.4680960000000001]
[1,"дсп",285,600,16,4,"бук",2.7360000000000002,null,"бук",2.4680960000000001]
[1,"дсп",150,600,16,2,"дуб",1.44,null,"Общий итог",242.30891200000005]
[1,"дсп",680,100,16,1,"бук",1.0880000000000001]
[1,"дсп",720,32,16,1,"дуб",0.36864000000000002]
[1,"дсп",1016,600,38,1,"бук",23.1648]
[1,"дсп",1398,100,16,1,"дуб",2.2368000000000001]
[1,"дсп",600,600,38,1,"бук",13.68]
[1,"дсп",290,268,16,4,"дуб",1.24352]
[1,"дсп",920,300,16,6,"бук",4.4160000000000004]
[1,"дсп",920,284,16,1,"дуб",4.1804800000000002]
[1,"дсп",888,50,16,4,"бук",0.71040000000000003]
[1,"дсп",888,300,16,1,"дуб",4.2624000000000004]
[1,"дсп",704,505,16,4,"бук",5.68832]
[1,"дсп",600,505,16,1,"дуб",4.8479999999999999]
[1,"дсп",508,96,16,4,"бук",0.78028799999999998]
[1,"дсп",500,96,16,4,"дуб",0.76800000000000002]
[1,"дсп",508,196,16,8,"бук",1.5930880000000001]
[1,"дсп",500,196,16,8,"дуб",1.5680000000000001]
[1,"дсп",720,100,16,4,"бук",1.1519999999999999]
[1,"дсп",704,450,16,2,"дуб",5.0688000000000004]
[1,"дсп",800,450,16,1,"бук",5.76]
[1,"дсп",768,80,16,1,"дуб",0.98304000000000002]
[3,"двп",599,505,16,1,"бук",4.8399200000000002]
[1,"дсп",920,328,16,1,"дуб",4.8281599999999996]
[3,"двп",920,290,16,1,"бук",4.2687999999999997]
[3,"двп",920,135,16,1,"дуб",1.9872000000000001]
[2,"фасад",716,352,16,1,"красный",4.0325119999999997]
[2,"фасад",716,48,16,1,"зеленый",0.54988800000000004]
[2,"фасад",716,400,16,1,"зеленый",4.5823999999999998]
[3,"двп",536,496,4,6,"бук",1.0634239999999999]

{"sheet":"таблица","index":1,"n_rows":51,"n_cols":8,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["№","Наименование","Высота","Ширина","Толщина","Кол-во","Площадь","Цвет"]
[1,"двп",400,400,16,4,{"$f":"((C2*D2)*F2)/1000000","v":0.64},"бук"]
[{"$f":"A2+1","v":2},"двп",400,50,16,5,0.1,"бук"]
[{"$f":"A3+1","v":3},"двп",340,500,16,9,1.53,"бук"]
[4,"дсп",800,580,16,4,1.8560000000000001,"бук"]
[5,"дсп",800,900,16,8,5.76,"дуб"]
[6,"дсп",790,800,16,8,5.056,"бук"]
[7,"дсп",800,670,16,6,3.2160000000000002,"дуб"]
[8,"фасад",716,456,16,6,1.9589760000000001,"красный"]
[9,"фасад",716,34,16,1,2.4344000000000001E-2,"красный"]
[10,"цоколь",80,3000,16,2,0.48,"бук"]
[11,"цоколь",90,5000,16,5,2.25,"бук"]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"расчет","index":2,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Наименование","Цвет","Сумма по полю Площадь"]
["двп","бук",2.27]
["двп Итог",null,2.27]
["дсп","бук",6.9119999999999999]
[null,"дуб",8.9759999999999991]
["дсп Итог",null,15.887999999999998]
["фасад",null,1.98332]
["цоколь",null,2.73]