{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Заказ","Данные","Прайс"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":0,"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":"Заказ","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[3,6,3,9],[2,6,2,9],[1,6,1,9],[0,6,0,9],[6,6,6,9],[4,2,4,5],[0,4,0,5],[1,4,1,5],[0,1,0,2],[2,4,2,5]]}
["Дата:",{"$f":"TODAY()","v":"2024-03-10"},null,null,"Покрытие",null,"Линолеум"]
[null,null,null,null,"Серия",null,"Лачуга"]
[null,null,null,null,"Толщина",null,"50 мм"]
[null,null,null,null,null,"Тип покрытия","Матовая"]
[null,"Заказчик","Поросёнок 1"]
[]
["№","Длина","Ширина","Кол-во","Площадь","Тип","Примечание"]
[1,759,637,1,{"$f":"((B8*C8)/1000000)*D8","v":0.483483}]
[2,297,1227,1,{"$f":"((B9*C9)/1000000)*D9","v":0.36441899999999999}]
[3,297,958,1,0.284526]
[4,617,369,1,0.22767299999999999]
[5,759,297,1,0.22542300000000001]
[6,759,297,1,0.22542300000000001]
[7,617,327,1,0.20175899999999999]
[8,612,327,1,0.200124]
[9,617,297,1,0.183249]
[10,617,286,1,0.17646200000000001]
[11,682,160,1,0.10911999999999999]
[12,593,156,1,9.2508000000000007E-2]
[13,623,143,1,8.9089000000000002E-2]
[14,null,null,null,0]
[15,null,null,null,0]
[16,null,null,null,0]
[17,null,null,null,0]
[18,null,null,null,0]
[19,null,null,null,0]
[20,null,null,null,0]
[21,null,null,null,0]
[22,null,null,null,0]
[23,null,null,null,0]
[24,null,null,null,0]
[25,null,null,null,0]
[26,null,null,null,0]
[27,null,null,null,0]
[28,null,null,null,0]
[29,null,null,null,0]
[30,null,null,null,0]
[31,null,null,null,0]
[32,null,null,null,0]
[33,null,null,null,0]
[34,null,null,null,0]
[35,null,null,null,0]
[null,"Стоимость м²",null,{"$f":"SUM(D8:D42)","v":13},{"$f":"[1]Данные!K4","v":2.8632579999999996},null,"Стоимость заказа:",{"$f":"C43*E43","v":0}]

{"sheet":"Данные","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,9,0,11]]}
["Толщина","Серия","Покрытие","Линолеум","Ламинат","Заказчики","Тип",null,null,"Условие округления площади до 1 м2"]
["50 мм","Лачуга","Линолеум","Коричневый","Коричневый","Поросёнок 1","Клетка",null,null,"Общая площадь",{"$f":"SUM(Заказ!#REF!)","v":{"$error":"#REF!"}}]
["100 мм","Стандарт","Ламинат","Зеленый","Зелёный","Поросёнок 2","Волна"]
["150 мм","Престиж",null,"Красный","Красный","Поросёнок 3","Полоски",null,null,"Площадь округлённая",{"$f":"IF(K2<1, ROUND(1, K2), K2)","v":{"$error":"#REF!"}}]
["200 мм","Дворец",null,"Синий","Синий","Поросёнок 4","Ромб"]
[null,null,null,"Чёрный","Чёрный","Поросёнок 5"]
[null,null,null,null,"Гранит","Поросёнок 6"]
[null,null,null,null,"Металл","Поросёнок 7"]
[null,null,null,null,null,"Поросёнок 8"]

{"sheet":"Прайс","index":2,"n_rows":7,"n_cols":55,"rows_kept":7,"cut":false,"hidden":false,"merged":[[0,0,0,23],[0,24,0,54],[1,0,1,5],[1,6,1,11],[1,12,1,17],[1,18,1,23],[1,24,1,30],[1,31,1,38],[1,39,1,46],[1,47,1,54]]}
["Линолеум",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ламинат"]
["Лачуга",null,null,null,null,null,"Стандарт",null,null,null,null,null,"Престиж",null,null,null,null,null,"Дворец",null,null,null,null,null,"Лачуга",null,null,null,null,null,null,"Стандарт",null,null,null,null,null,null,null,"Престиж",null,null,null,null,null,null,null,"Дворец"]
["Толщина","Коричневый","Зелёный","Красный","Синий","Чёрный","Толщина","Коричневый","Зелёный","Красный","Синий","Чёрный","Толщина","Коричневый","Зелёный","Красный","Синий","Чёрный","Толщина","Коричневый","Зелёный","Красный","Синий","Чёрный","Толщина","Коричневый","Зелёный","Красный","Синий","Чёрный","Гранит","Толщина","Коричневый","Зелёный","Красный","Синий","Чёрный","Гранит","Металл","Толщина","Коричневый","Зелёный","Красный","Синий","Чёрный","Гранит","Металл","Толщина","Коричневый","Зелёный","Красный","Синий","Чёрный","Гранит","Металл"]
["50 мм",4000,5100,4300,4300,4400,"50 мм",4800,6300,5200,5200,5300,"50 мм",5100,6600,5500,5500,5600,"50 мм",5800,"-",6200,6200,6200,"50 мм",6600,7800,7000,8200,7000,7800,"50 мм",7300,8800,7700,9200,8200,8200,9100,"50 мм",7800,9300,8200,9700,8700,8700,9600,"50 мм",8500,"-",8900,"-",9400,9400,10300]
["100 мм",4200,5400,4500,4500,4600,"100 мм",5000,6500,5400,5400,5500,"100 мм",5400,6900,5800,5800,5900,"100 мм",6100,"-",6500,6500,6500,"100 мм",6800,8100,7200,8500,7300,8100,"100 мм",7600,9100,8000,9500,8500,8500,9400,"100 мм",8100,9600,8500,10000,9000,9000,9900,"100 мм",9000,"-",9400,"-",9900,9900,10800]
["150 мм",4500,5700,4800,4800,4900,"150 мм",5200,6800,5700,5700,5800,"150 мм",5700,7200,6100,6100,6200,"150 мм",6400,"-",6800,6800,6800,"150 мм",7100,8600,7500,9000,7800,8600,"150 мм",8100,9600,8500,10000,9000,9000,9900,"150 мм",8600,10100,9000,10500,9500,9500,10400,"150 мм",9500,"-",9900,"-",10400,10400,11300]
[null,null,null,null,null,null,null,null,null,null,null,null,"200 мм",6000,7500,6400,6400,6500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"200 мм",9100,10600,9500,11000,10000,10000,10900]