{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Лист2","полотно","Алюм коробки Фрист","Деревянные коробки","Лист4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Лист2","index":0,"n_rows":10,"n_cols":23,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,4,1,6]]}
[]
[]
[null,"полотно",null,null,"высота мм",null,"ширина мм","толщина проема мм","площадь м2",null,"Вид отделки",null,"Стоимость","тонировка шпона","стоимость","  Вид пластика",null,"Тип коробки","стоимость","Тип наличников",null,null,"И Т О Г О"]
[null,3,null,null,2100,1,900,90,{"$f":"E4*G4/1000000","v":1.89},null,2,null,{"$f":"I4*INDEX(полотно!$B$3:$F$8,K4,B4)+IF(LEFT(INDEX(полотно!$B$1:$F$1,B4),3)=\"(ПП\",(2*E4+G4)*полотно!B21/1000,0)+CHOOSE(K4,0,0,полотно!B18,полотно!C18,0,0)","v":0},1,{"$f":"INDIRECT(\"полотно!B\" & N4+11)","v":630},null,6,4,{"$f":"INDIRECT(\"Лист4!C\" & R4+307)","v":2479.11},1,null,{"$f":"INDIRECT(\"'Деревянные коробки'!B\" & T4+40)","v":1632},{"$f":"Q4+O4+M4+J4","v":636}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(Лист4!$B$335:$E$340,R4,S4)*IF(AND(ISNUMBER(FIND(\"V\",INDEX(Лист4!$A$335:$A$340,R4))),E4*2+G4>5800),1.5,1)","v":{"$error":"#REF!"}}]

{"sheet":"полотно","index":1,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":false,"merged":[[15,0,15,2]]}
[null,"Сотовое полотно","трубчатое полотно","полнотелое полотно","(ПП IE 30)","(ПП IE 60)"]
["Вид отделки","цена руб/м2","цена руб/м2","цена руб/м2","цена руб/м2","цена руб/м2"]
["шпон эконом"]
["шпон натурал"]
["Пластик белый"]
["Пластик под дерево"]
["эмаль"]
[]
[]
[]
["тонировка шпона","цена руб/м2"]
["ДА",630]
["НЕТ",0]
[]
[]
["Доп опция пластика"]
["вид отделки","белый","дерево"]
["цена руб/лист"]
[]
[]
["Фрезеровка"]
[]
[]
[]
["сотовое"]
["трубчатое"]
["полнотелое"]
["(ПП IE 30)"]
["(ПП IE 60)"]

{"sheet":"Алюм коробки Фрист","index":2,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,7,0,9],[0,11,0,13],[0,15,0,17],[35,0,35,5],[0,0,0,5],[7,0,7,5],[14,0,14,4],[21,0,21,5],[28,0,28,5]]}
["Под глухое полотно RAL 9016",null,null,null,null,null,null,"RAL 9016",null,null,null,"Анодировка",null,null,null,"неокрашено"]
[null,700,900,1200,1500,1800,null,"высота","ширина","стоимость",null,"высота","ширина","стоимость",null,"высота","ширина","стоимость"]
[2100,2860,2860,2940,2960,2975,null,{"$f":"Лист2!E4","v":2100},{"$f":"Лист2!G4","v":900},{"$f":"INDEX(B3:F6,MIN(4,SUMPRODUCT(--(A3:A6<H3))+1),MIN(5,SUMPRODUCT(--(B2:F2<I3))+1))","v":2860},null,{"$f":"H3","v":2100},900,{"$f":"INDEX(B10:F13,MIN(4,SUMPRODUCT(--(A10:A13<L3))+1),MIN(5,SUMPRODUCT(--(B9:F9<M3))+1))","v":3060},null,{"$f":"L3","v":2100},900,{"$f":"INDEX(B17:F20,MIN(4,SUMPRODUCT(--(A17:A20<P3))+1),MIN(5,SUMPRODUCT(--(B16:F16<Q3))+1))","v":2730}]
[2300,2950,2950,2965,2980,2995,null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"INDEX(B3:F6,MIN(4,SUMPRODUCT(--(A3:A6<H4))+1),MIN(5,SUMPRODUCT(--(B2:F2<I4))+1))","v":{"$error":"#REF!"}},null,{"$f":"H4","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"INDEX(B10:F13,MIN(4,SUMPRODUCT(--(A10:A13<L4))+1),MIN(5,SUMPRODUCT(--(B9:F9<M4))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B17:F20,MIN(4,SUMPRODUCT(--(A17:A20<P4))+1),MIN(5,SUMPRODUCT(--(B16:F16<Q4))+1))","v":{"$error":"#REF!"}}]
[2700,2980,2990,3010,3025,3035,null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"INDEX(B3:F6,MIN(4,SUMPRODUCT(--(A3:A6<H5))+1),MIN(5,SUMPRODUCT(--(B2:F2<I5))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B10:F13,MIN(4,SUMPRODUCT(--(A10:A13<L5))+1),MIN(5,SUMPRODUCT(--(B9:F9<M5))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B17:F20,MIN(4,SUMPRODUCT(--(A17:A20<P5))+1),MIN(5,SUMPRODUCT(--(B16:F16<Q5))+1))","v":{"$error":"#REF!"}}]
[3000,3010,3025,3035,3055,3065,null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"INDEX(B3:F6,MIN(4,SUMPRODUCT(--(A3:A6<H6))+1),MIN(5,SUMPRODUCT(--(B2:F2<I6))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B10:F13,MIN(4,SUMPRODUCT(--(A10:A13<L6))+1),MIN(5,SUMPRODUCT(--(B9:F9<M6))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B17:F20,MIN(4,SUMPRODUCT(--(A17:A20<P6))+1),MIN(5,SUMPRODUCT(--(B16:F16<Q6))+1))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"INDEX(B3:F6,MIN(4,SUMPRODUCT(--(A3:A6<H7))+1),MIN(5,SUMPRODUCT(--(B2:F2<I7))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B10:F13,MIN(4,SUMPRODUCT(--(A10:A13<L7))+1),MIN(5,SUMPRODUCT(--(B9:F9<M7))+1))","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"INDEX(B17:F20,MIN(4,SUMPRODUCT(--(A17:A20<P7))+1),MIN(5,SUMPRODUCT(--(B16:F16<Q7))+1))","v":{"$error":"#REF!"}}]
["Под глухое полотно анодировка"]
[null,700,900,1200,1500,1800]
[2100,3060,3060,3075,3095,3105]
[2300,3070,3080,3100,3115,3130]
[2700,3110,3125,3140,3160,3180]
[3000,3145,3160,3175,3190,3210]
[]
["Под глухое полотно неокрашено"]
[null,700,900,1200,1500,1800]
[2100,2730,2730,2740,2760,2770]
[2300,2740,2750,2765,2775,2790]
[2700,2775,2785,2800,2820,2830]
[3000,2810,2820,2830,2845,2860]
[]
["Под цельностеклянное полотно Ral 9016"]
[null,700,900,1200,1500,1800]
[2100,3570,3570,3935,3955,3975]
[2300,3570,3945,3960,3980,4005]
[2700,3980,3995,4015,4035,4055]
[3000,4020,4035,4055,4070,4095]
[]
["Под цельностеклянное полотно анодировка"]
[null,700,900,1200,1500,1800]
[2100,3740,3740,4125,4140,4165]
[2300,3740,4130,4150,4170,4195]
[2700,4170,4185,4205,4230,4250]
[3000,4215,4230,4250,4270,4290]
[]
["Под цельностеклянное полотно неокрашено"]
[null,700,900,1200,1500,1800]
[2100]
[2300]
[2700]
[3000]

{"sheet":"Деревянные коробки","index":3,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[15,0,15,2],[28,0,28,2],[0,0,0,1],[8,0,8,1]]}
["коробка деревянная стандартная"]
["цена за п/м руб","стоимость"]
[430,{"$f":"(Лист2!E4*2+Лист2!G4)*'Деревянные коробки'!A3/1000","v":2193}]
[430,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A4/1000","v":{"$error":"#REF!"}}]
[430,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A5/1000","v":{"$error":"#REF!"}}]
[430,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A6/1000","v":{"$error":"#REF!"}}]
[430,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A7/1000","v":{"$error":"#REF!"}}]
[]
["коробка деревянная усиленная"]
[570,{"$f":"(Лист2!E4*2+Лист2!G4)*'Деревянные коробки'!A10/1000","v":2907}]
[570,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A11/1000","v":{"$error":"#REF!"}}]
[570,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A12/1000","v":{"$error":"#REF!"}}]
[570,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A13/1000","v":{"$error":"#REF!"}}]
[570,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!A14/1000","v":{"$error":"#REF!"}}]
[]
["наличники "]
["наименование","цена за п/м руб","стоимость"]
["плоский",320,{"$f":"(Лист2!E4*2+Лист2!G4)*'Деревянные коробки'!B18/1000","v":1632}]
["плоский",320,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B19/1000","v":{"$error":"#REF!"}}]
["плоский",320,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B20/1000","v":{"$error":"#REF!"}}]
["плоский",320,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B21/1000","v":{"$error":"#REF!"}}]
["плоский",320,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B22/1000","v":{"$error":"#REF!"}}]
["телескопический",380,{"$f":"(Лист2!E4*2+Лист2!G4)*'Деревянные коробки'!B23/1000","v":1938}]
["телескопический",380,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B24/1000","v":{"$error":"#REF!"}}]
["телескопический",380,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B25/1000","v":{"$error":"#REF!"}}]
["телескопический",380,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B26/1000","v":{"$error":"#REF!"}}]
["телескопический",380,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)*'Деревянные коробки'!B27/1000","v":{"$error":"#REF!"}}]
[]
["доборы"]
[null,"стоимость","цена"]
[1,{"$f":"(Лист2!E4*2+Лист2!G4)/1000*(Лист2!H4-100)/1000*C31+(Лист2!E4*2+Лист2!G4)/1000*B37","v":286.10999999999996},2890]
[2,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)/1000*(Лист2!#REF!-100)/1000*C32+(Лист2!#REF!*2+Лист2!#REF!)/1000*B37","v":{"$error":"#REF!"}},2890]
[3,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)/1000*(Лист2!#REF!-90)/1000*C33+(Лист2!#REF!*2+Лист2!#REF!)/1000*B37","v":{"$error":"#REF!"}},2890]
[4,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)/1000*(Лист2!#REF!-90)/1000*C34+(Лист2!#REF!*2+Лист2!#REF!)/1000*B37","v":{"$error":"#REF!"}},2890]
[5,{"$f":"(Лист2!#REF!*2+Лист2!#REF!)/1000*(Лист2!#REF!-90)/1000*C35+(Лист2!#REF!*2+Лист2!#REF!)/1000*B37","v":{"$error":"#REF!"}},2890]
[]
["Фрезеровка",85]
[]
[null,"Сотовое полотно","трубчатое полотно","полнотелое полотно","(ПП IE 30)","(ПП IE 60)"]
[null,"цена руб/м2","цена руб/м2","цена руб/м2","цена руб/м2","цена руб/м2"]
["плоский",{"$f":"C18","v":1632},{"$f":"C19","v":{"$error":"#REF!"}},{"$f":"C20","v":{"$error":"#REF!"}},{"$f":"C21","v":{"$error":"#REF!"}},{"$f":"C22","v":{"$error":"#REF!"}}]
["телескопический",{"$f":"C23","v":1938},{"$f":"C24","v":{"$error":"#REF!"}},{"$f":"C25","v":{"$error":"#REF!"}},{"$f":"C26","v":{"$error":"#REF!"}},{"$f":"C27","v":{"$error":"#REF!"}}]

{"sheet":"Лист4","index":4,"n_rows":345,"n_cols":13,"rows_kept":345,"cut":false,"hidden":false,"merged":[[322,0,326,0],[327,0,331,0],[307,0,311,0],[312,0,316,0],[317,0,321,0],[3,0,3,2],[62,0,62,2],[121,0,121,2],[180,0,180,2],[239,0,239,2]]}
["Тип","Высота","Ширина","Толщина","Цена Коробки","Количество коробок, шт","Сумма","Добор 50мм, шт","Добор 80мм, шт","Цена добор 50мм","Цена добор 80мм","Сумма","ИТОГО"]
[{"$f":"Лист2!R4","v":4},{"$f":"Лист2!E4","v":2100},{"$f":"Лист2!G4","v":900},{"$f":"Лист2!H4","v":90},{"$f":"B15+B28","v":0},1,{"$f":"F2*E2","v":0},{"$f":"B59","v":0},{"$f":"B58","v":0},{"$f":"B37","v":0},{"$f":"B46","v":0},{"$f":"H2*J2+I2*K2","v":0},{"$f":"G2+L2","v":0}]
[]
[]
[null,null,null,null,"Размер по проему: (высота х ширина)"," Ед.изм.","Цена/руб."]
["К3",2150,1000,{"$f":"B6+C6","v":3150},"до  2150х1000","компл.",4830,{"$f":"B2","v":2100},{"$f":"C2","v":900},{"$f":"IF(H6<=B6,1,0)","v":1},{"$f":"IF(I6<=1000,1,0)","v":1},{"$f":"IF(AND(J6=1,K6=1),G6,0)","v":4830}]
["К3",2150,2000,4150,"до  2150х2000","компл.",6040,{"$f":"H6","v":2100},900,{"$f":"IF(H7<=B7,1,0)","v":1},{"$f":"IF(AND(1000<I7,I7<=2000),1,0)","v":0},0]
["К3",2500,1000,3500,"до  2500х1000","компл.",6040,2100,900,{"$f":"IF(AND(2150<H8,H8<=2500),1,0)","v":0},{"$f":"IF(I8<=1000,1,0)","v":1},0]
["К3",2500,2000,4500,"до  2500х2000","компл.",7245,2100,900,{"$f":"IF(AND(2150<H9,H9<=2500),1,0)","v":0},{"$f":"IF(AND(1000<I9,I9<=2000),1,0)","v":0},0]
["К3",2800,1000,3800,"до  2800х1000","компл.",7245,2100,900,{"$f":"IF(AND(2500<H10,H10<=2800),1,0)","v":0},{"$f":"IF(I10<=1000,1,0)","v":1},0]
["К3",2800,2000,4800,"до  2800х2000","компл.",8450,2100,900,{"$f":"IF(AND(2500<H11,H11<=2800),1,G12)","v":0},{"$f":"IF(AND(1000<I11,I11<=2000),1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H11>B11,1,0)","v":0},{"$f":"IF(I10<=1000,1,0)","v":1},{"$f":"IF(AND(J12=1,K12=1),G10,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H11>B11,1,0)","v":0},{"$f":"IF(AND(1000<I11,I11<=2000),1,0)","v":0},{"$f":"IF(AND(J13=1,K13=1),G11,0)","v":0}]
[]
[1,{"$f":"IF(A2=A15,L15,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L14)","v":4830}]
[]
[]
[null,null,null,null,"Размер по проему: (высота х ширина)"," Ед.изм.","Цена/руб."]
["К4",2150,1000,{"$f":"B19+C19","v":3150},"до  2150х1000","компл.",4725,{"$f":"B2","v":2100},{"$f":"C2","v":900},{"$f":"IF(H19<=B19,1,0)","v":1},{"$f":"IF(I19<=1000,1,0)","v":1},{"$f":"IF(AND(J19=1,K19=1),G19,0)","v":4725}]
["К4",2150,2000,4150,"до  2150х2000","компл.",5910,{"$f":"H19","v":2100},900,{"$f":"IF(H20<=B20,1,0)","v":1},{"$f":"IF(AND(1000<I20,I20<=2000),1,0)","v":0},0]
["К4",2500,1000,3500,"до  2500х1000","компл.",5910,2100,900,{"$f":"IF(AND(2150<H21,H21<=2500),1,0)","v":0},{"$f":"IF(I21<=1000,1,0)","v":1},0]
["К4",2500,2000,4500,"до  2500х2000","компл.",7090,2100,900,{"$f":"IF(AND(2150<H22,H22<=2500),1,0)","v":0},{"$f":"IF(AND(1000<I22,I22<=2000),1,0)","v":0},0]
["К4",2800,1000,3800,"до  2800х1000","компл.",7090,2100,900,{"$f":"IF(AND(2500<H23,H23<=2800),1,0)","v":0},{"$f":"IF(I23<=1000,1,0)","v":1},0]
["К4",2800,2000,4800,"до  2800х2000","компл.",8265,2100,900,{"$f":"IF(AND(2500<H24,H24<=2800),1,G25)","v":0},{"$f":"IF(AND(1000<I24,I24<=2000),1,0)","v":0},0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H24>B24,1,0)","v":0},{"$f":"IF(I23<=1000,1,0)","v":1},{"$f":"IF(AND(J25=1,K25=1),G23,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H24>B24,1,0)","v":0},{"$f":"IF(AND(1000<I24,I24<=2000),1,0)","v":0},{"$f":"IF(AND(J26=1,K26=1),G24,0)","v":0}]
[]
[2,{"$f":"IF(A2=A28,L28,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L19:L27)","v":4725}]
[]
["К3",2500,1000,50,"  до   2500х1000","компл.",1500,{"$f":"B2","v":2100},{"$f":"C2","v":900},{"$f":"IF(H30<=B30,1,0)","v":1},{"$f":"IF(I30<=1000,1,0)","v":1},{"$f":"IF(AND(J30=1,K30=1),G30,0)","v":1500}]
["К3",2500,2000,50,"  до   2500х2000","компл.",1790,{"$f":"H30","v":2100},900,{"$f":"IF(H31<=B31,1,0)","v":1},{"$f":"IF(AND(1000<I31,I31<=2000),1,0)","v":0},{"$f":"IF(AND(J31=1,K31=1),G31,0)","v":0}]
["К3",2800,1000,50,"  до   2800х1000","компл.",1790,2100,900,{"$f":"IF(AND(2500<H32,H32<=2800),1,0)","v":0},{"$f":"IF(I32<=1000,1,0)","v":1},{"$f":"IF(AND(J32=1,K32=1),G32,0)","v":0}]
["К3",2800,2000,50,"  до   2800х2000","компл.",2140,2100,900,{"$f":"IF(AND(2500<H33,H33<=2800),1,0)","v":0},{"$f":"IF(AND(1000<I33,I33<=2000),1,0)","v":0},{"$f":"IF(AND(J33=1,K33=1),G33,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H33>B33,1,0)","v":0},{"$f":"IF(I32<=1000,1,0)","v":1},{"$f":"IF(AND(J34=1,K34=1),G33,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H33>B33,1,0)","v":0},{"$f":"IF(AND(1000<I33,I33<=2000),1,0)","v":0},{"$f":"IF(AND(J35=1,K35=1),G33,0)","v":0}]
[]
[1,{"$f":"IF(A2=A37,L37,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L30:L36)","v":1500}]
[]
["К3",2500,1000,80,"  до   2500х1000","компл.",1790,{"$f":"B2","v":2100},{"$f":"C2","v":900},{"$f":"IF(H39<=B39,1,0)","v":1},{"$f":"IF(I39<=1000,1,0)","v":1},{"$f":"IF(AND(J39=1,K39=1),G39,0)","v":1790}]
["К3",2500,2000,80,"  до   2500х2000","компл.",2140,{"$f":"H39","v":2100},900,{"$f":"IF(H40<=B40,1,0)","v":1},{"$f":"IF(AND(1000<I40,I40<=2000),1,0)","v":0},{"$f":"IF(AND(J40=1,K40=1),G40,0)","v":0}]
["К3",2800,1000,80,"  до   2800х1000","компл.",2100,2100,900,{"$f":"IF(AND(2500<H41,H41<=2800),1,0)","v":0},{"$f":"IF(I41<=1000,1,0)","v":1},{"$f":"IF(AND(J41=1,K41=1),G41,0)","v":0}]
["К3",2800,2000,80,"  до   2800х2000","компл.",2520,2100,900,{"$f":"IF(AND(2500<H42,H42<=2800),1,0)","v":0},{"$f":"IF(AND(1000<I42,I42<=2000),1,0)","v":0},{"$f":"IF(AND(J42=1,K42=1),G42,0)","v":0}]
["К3",null,null,null,null,null,null,null,null,{"$f":"IF(H42>B42,1,0)","v":0},{"$f":"IF(I41<=1000,1,0)","v":1},{"$f":"IF(AND(J43=1,K43=1),G42,0)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H42>B42,1,0)","v":0},{"$f":"IF(AND(1000<I42,I42<=2000),1,0)","v":0},{"$f":"IF(AND(J44=1,K44=1),G42,0)","v":0}]
[]
[1,{"$f":"IF(A2=A46,L46,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L39:L45)","v":1790}]
[]
[]
["Толщина дверного проема",{"$f":"D2","v":90}]
["добор 80 мм",{"$f":"INT((B49-120)/80)","v":-1}]
["добор 50 мм",0]
["Остаток",{"$f":"(B49-120)-B50*80","v":50}]
[]
["Необходимое количество"]
["добор 80 мм",{"$f":"IF(B52>50,B50+1,B50)","v":-1}]
["добор 50 мм",{"$f":"IF(AND(1<B52,B52<=50),B51+1,B51)","v":1}]
[]
[1,{"$f":"IF(A2=A58,L58,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"B55","v":-1}]
[1,{"$f":"IF(A2=A59,L59,0)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"B56","v":1}]
[]
[{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"B74+B87","v":{"$error":"#REF!"}},1,{"$f":"F61*E61","v":{"$error":"#REF!"}},{"$f":"B118","v":{"$error":"#REF!"}},{"$f":"B117","v":{"$error":"#REF!"}},{"$f":"B96","v":{"$error":"#REF!"}},{"$f":"B105","v":{"$error":"#REF!"}},{"$f":"H61*J61+I61*K61","v":{"$error":"#REF!"}},{"$f":"G61+L61","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"Размер по проему: (высота х ширина)"," Ед.изм.","Цена/руб."]
["К3",2150,1000,{"$f":"B65+C65","v":3150},"до  2150х1000","компл.",4830,{"$f":"B61","v":{"$error":"#REF!"}},{"$f":"C61","v":{"$error":"#REF!"}},{"$f":"IF(H65<=B65,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I65<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J65=1,K65=1),G65,0)","v":{"$error":"#REF!"}}]
["К3",2150,2000,4150,"до  2150х2000","компл.",6040,{"$f":"H65","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H66<=B66,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I66,I66<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2500,1000,3500,"до  2500х1000","компл.",6040,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H67,H67<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I67<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2500,2000,4500,"до  2500х2000","компл.",7245,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H68,H68<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I68,I68<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2800,1000,3800,"до  2800х1000","компл.",7245,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H69,H69<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I69<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2800,2000,4800,"до  2800х2000","компл.",8450,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H70,H70<=2800),1,G71)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I70,I70<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H70>B70,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I69<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J71=1,K71=1),G69,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H70>B70,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I70,I70<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J72=1,K72=1),G70,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A61=A74,L74,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L65:L73)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"Размер по проему: (высота х ширина)"," Ед.изм.","Цена/руб."]
["К4",2150,1000,{"$f":"B78+C78","v":3150},"до  2150х1000","компл.",4725,{"$f":"B61","v":{"$error":"#REF!"}},{"$f":"C61","v":{"$error":"#REF!"}},{"$f":"IF(H78<=B78,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I78<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J78=1,K78=1),G78,0)","v":{"$error":"#REF!"}}]
["К4",2150,2000,4150,"до  2150х2000","компл.",5910,{"$f":"H78","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H79<=B79,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I79,I79<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2500,1000,3500,"до  2500х1000","компл.",5910,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H80,H80<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I80<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2500,2000,4500,"до  2500х2000","компл.",7090,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H81,H81<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I81,I81<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2800,1000,3800,"до  2800х1000","компл.",7090,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H82,H82<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I82<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2800,2000,4800,"до  2800х2000","компл.",8265,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H83,H83<=2800),1,G84)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I83,I83<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H83>B83,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I82<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J84=1,K84=1),G82,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H83>B83,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I83,I83<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J85=1,K85=1),G83,0)","v":{"$error":"#REF!"}}]
[]
[2,{"$f":"IF(A61=A87,L87,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L78:L86)","v":{"$error":"#REF!"}}]
[]
["К3",2500,1000,50,"  до   2500х1000","компл.",1500,{"$f":"B61","v":{"$error":"#REF!"}},{"$f":"C61","v":{"$error":"#REF!"}},{"$f":"IF(H89<=B89,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I89<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J89=1,K89=1),G89,0)","v":{"$error":"#REF!"}}]
["К3",2500,2000,50,"  до   2500х2000","компл.",1790,{"$f":"H89","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H90<=B90,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I90,I90<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J90=1,K90=1),G90,0)","v":{"$error":"#REF!"}}]
["К3",2800,1000,50,"  до   2800х1000","компл.",1790,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H91,H91<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I91<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J91=1,K91=1),G91,0)","v":{"$error":"#REF!"}}]
["К3",2800,2000,50,"  до   2800х2000","компл.",2140,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H92,H92<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I92,I92<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J92=1,K92=1),G92,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H92>B92,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I91<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J93=1,K93=1),G92,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H92>B92,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I92,I92<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J94=1,K94=1),G92,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A61=A96,L96,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L89:L95)","v":{"$error":"#REF!"}}]
[]
["К3",2500,1000,80,"  до   2500х1000","компл.",1790,{"$f":"B61","v":{"$error":"#REF!"}},{"$f":"C61","v":{"$error":"#REF!"}},{"$f":"IF(H98<=B98,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I98<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J98=1,K98=1),G98,0)","v":{"$error":"#REF!"}}]
["К3",2500,2000,80,"  до   2500х2000","компл.",2140,{"$f":"H98","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H99<=B99,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I99,I99<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J99=1,K99=1),G99,0)","v":{"$error":"#REF!"}}]
["К3",2800,1000,80,"  до   2800х1000","компл.",2100,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H100,H100<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I100<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J100=1,K100=1),G100,0)","v":{"$error":"#REF!"}}]
["К3",2800,2000,80,"  до   2800х2000","компл.",2520,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H101,H101<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I101,I101<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J101=1,K101=1),G101,0)","v":{"$error":"#REF!"}}]
["К3",null,null,null,null,null,null,null,null,{"$f":"IF(H101>B101,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I100<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J102=1,K102=1),G101,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H101>B101,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I101,I101<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J103=1,K103=1),G101,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A61=A105,L105,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L98:L104)","v":{"$error":"#REF!"}}]
[]
[]
["Толщина дверного проема",{"$f":"D61","v":{"$error":"#REF!"}}]
["добор 80 мм",{"$f":"INT((B108-120)/80)","v":{"$error":"#REF!"}}]
["добор 50 мм",0]
["Остаток",{"$f":"(B108-120)-B109*80","v":{"$error":"#REF!"}}]
[]
["Необходимое количество"]
["добор 80 мм",{"$f":"IF(B111>50,B109+1,B109)","v":{"$error":"#REF!"}}]
["добор 50 мм",{"$f":"IF(AND(1<B111,B111<=50),B110+1,B110)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A61=A117,L117,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"B114","v":{"$error":"#REF!"}}]
[1,{"$f":"IF(A61=A118,L118,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"B115","v":{"$error":"#REF!"}}]
[]
[{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"B133+B146","v":{"$error":"#REF!"}},1,{"$f":"F120*E120","v":{"$error":"#REF!"}},{"$f":"B177","v":{"$error":"#REF!"}},{"$f":"B176","v":{"$error":"#REF!"}},{"$f":"B155","v":{"$error":"#REF!"}},{"$f":"B164","v":{"$error":"#REF!"}},{"$f":"H120*J120+I120*K120","v":{"$error":"#REF!"}},{"$f":"G120+L120","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"Размер по проему: (высота х ширина)"," Ед.изм.","Цена/руб."]
["К3",2150,1000,{"$f":"B124+C124","v":3150},"до  2150х1000","компл.",4830,{"$f":"B120","v":{"$error":"#REF!"}},{"$f":"C120","v":{"$error":"#REF!"}},{"$f":"IF(H124<=B124,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I124<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J124=1,K124=1),G124,0)","v":{"$error":"#REF!"}}]
["К3",2150,2000,4150,"до  2150х2000","компл.",6040,{"$f":"H124","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H125<=B125,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I125,I125<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2500,1000,3500,"до  2500х1000","компл.",6040,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H126,H126<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I126<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2500,2000,4500,"до  2500х2000","компл.",7245,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H127,H127<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I127,I127<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2800,1000,3800,"до  2800х1000","компл.",7245,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H128,H128<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I128<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2800,2000,4800,"до  2800х2000","компл.",8450,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H129,H129<=2800),1,G130)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I129,I129<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H129>B129,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I128<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J130=1,K130=1),G128,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H129>B129,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I129,I129<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J131=1,K131=1),G129,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A120=A133,L133,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L124:L132)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"Размер по проему: (высота х ширина)"," Ед.изм.","Цена/руб."]
["К4",2150,1000,{"$f":"B137+C137","v":3150},"до  2150х1000","компл.",4725,{"$f":"B120","v":{"$error":"#REF!"}},{"$f":"C120","v":{"$error":"#REF!"}},{"$f":"IF(H137<=B137,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I137<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J137=1,K137=1),G137,0)","v":{"$error":"#REF!"}}]
["К4",2150,2000,4150,"до  2150х2000","компл.",5910,{"$f":"H137","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H138<=B138,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I138,I138<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2500,1000,3500,"до  2500х1000","компл.",5910,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H139,H139<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I139<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2500,2000,4500,"до  2500х2000","компл.",7090,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H140,H140<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I140,I140<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2800,1000,3800,"до  2800х1000","компл.",7090,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H141,H141<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I141<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2800,2000,4800,"до  2800х2000","компл.",8265,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H142,H142<=2800),1,G143)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I142,I142<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H142>B142,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I141<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J143=1,K143=1),G141,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H142>B142,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I142,I142<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J144=1,K144=1),G142,0)","v":{"$error":"#REF!"}}]
[]
[2,{"$f":"IF(A120=A146,L146,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L137:L145)","v":{"$error":"#REF!"}}]
[]
["К3",2500,1000,50,"  до   2500х1000","компл.",1500,{"$f":"B120","v":{"$error":"#REF!"}},{"$f":"C120","v":{"$error":"#REF!"}},{"$f":"IF(H148<=B148,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I148<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J148=1,K148=1),G148,0)","v":{"$error":"#REF!"}}]
["К3",2500,2000,50,"  до   2500х2000","компл.",1790,{"$f":"H148","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H149<=B149,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I149,I149<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J149=1,K149=1),G149,0)","v":{"$error":"#REF!"}}]
["К3",2800,1000,50,"  до   2800х1000","компл.",1790,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H150,H150<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I150<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J150=1,K150=1),G150,0)","v":{"$error":"#REF!"}}]
["К3",2800,2000,50,"  до   2800х2000","компл.",2140,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H151,H151<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I151,I151<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J151=1,K151=1),G151,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H151>B151,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I150<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J152=1,K152=1),G151,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H151>B151,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I151,I151<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J153=1,K153=1),G151,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A120=A155,L155,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L148:L154)","v":{"$error":"#REF!"}}]
[]
["К3",2500,1000,80,"  до   2500х1000","компл.",1790,{"$f":"B120","v":{"$error":"#REF!"}},{"$f":"C120","v":{"$error":"#REF!"}},{"$f":"IF(H157<=B157,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I157<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J157=1,K157=1),G157,0)","v":{"$error":"#REF!"}}]
["К3",2500,2000,80,"  до   2500х2000","компл.",2140,{"$f":"H157","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H158<=B158,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I158,I158<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J158=1,K158=1),G158,0)","v":{"$error":"#REF!"}}]
["К3",2800,1000,80,"  до   2800х1000","компл.",2100,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H159,H159<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I159<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J159=1,K159=1),G159,0)","v":{"$error":"#REF!"}}]
["К3",2800,2000,80,"  до   2800х2000","компл.",2520,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H160,H160<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I160,I160<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J160=1,K160=1),G160,0)","v":{"$error":"#REF!"}}]
["К3",null,null,null,null,null,null,null,null,{"$f":"IF(H160>B160,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I159<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J161=1,K161=1),G160,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H160>B160,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I160,I160<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J162=1,K162=1),G160,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A120=A164,L164,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L157:L163)","v":{"$error":"#REF!"}}]
[]
[]
["Толщина дверного проема",{"$f":"D120","v":{"$error":"#REF!"}}]
["добор 80 мм",{"$f":"INT((B167-120)/80)","v":{"$error":"#REF!"}}]
["добор 50 мм",0]
["Остаток",{"$f":"(B167-120)-B168*80","v":{"$error":"#REF!"}}]
[]
["Необходимое количество"]
["добор 80 мм",{"$f":"IF(B170>50,B168+1,B168)","v":{"$error":"#REF!"}}]
["добор 50 мм",{"$f":"IF(AND(1<B170,B170<=50),B169+1,B169)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A120=A176,L176,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"B173","v":{"$error":"#REF!"}}]
[1,{"$f":"IF(A120=A177,L177,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"B174","v":{"$error":"#REF!"}}]
[]
[{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"B192+B205","v":{"$error":"#REF!"}},1,{"$f":"F179*E179","v":{"$error":"#REF!"}},{"$f":"B236","v":{"$error":"#REF!"}},{"$f":"B235","v":{"$error":"#REF!"}},{"$f":"B214","v":{"$error":"#REF!"}},{"$f":"B223","v":{"$error":"#REF!"}},{"$f":"H179*J179+I179*K179","v":{"$error":"#REF!"}},{"$f":"G179+L179","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"Размер по проему: (высота х ширина)"," Ед.изм.","Цена/руб."]
["К3",2150,1000,{"$f":"B183+C183","v":3150},"до  2150х1000","компл.",4830,{"$f":"B179","v":{"$error":"#REF!"}},{"$f":"C179","v":{"$error":"#REF!"}},{"$f":"IF(H183<=B183,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I183<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J183=1,K183=1),G183,0)","v":{"$error":"#REF!"}}]
["К3",2150,2000,4150,"до  2150х2000","компл.",6040,{"$f":"H183","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H184<=B184,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I184,I184<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2500,1000,3500,"до  2500х1000","компл.",6040,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H185,H185<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I185<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2500,2000,4500,"до  2500х2000","компл.",7245,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H186,H186<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I186,I186<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2800,1000,3800,"до  2800х1000","компл.",7245,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H187,H187<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I187<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2800,2000,4800,"до  2800х2000","компл.",8450,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H188,H188<=2800),1,G189)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I188,I188<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H188>B188,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I187<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J189=1,K189=1),G187,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H188>B188,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I188,I188<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J190=1,K190=1),G188,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A179=A192,L192,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L183:L191)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"Размер по проему: (высота х ширина)"," Ед.изм.","Цена/руб."]
["К4",2150,1000,{"$f":"B196+C196","v":3150},"до  2150х1000","компл.",4725,{"$f":"B179","v":{"$error":"#REF!"}},{"$f":"C179","v":{"$error":"#REF!"}},{"$f":"IF(H196<=B196,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I196<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J196=1,K196=1),G196,0)","v":{"$error":"#REF!"}}]
["К4",2150,2000,4150,"до  2150х2000","компл.",5910,{"$f":"H196","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H197<=B197,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I197,I197<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2500,1000,3500,"до  2500х1000","компл.",5910,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H198,H198<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I198<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2500,2000,4500,"до  2500х2000","компл.",7090,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H199,H199<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I199,I199<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2800,1000,3800,"до  2800х1000","компл.",7090,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H200,H200<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I200<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2800,2000,4800,"до  2800х2000","компл.",8265,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H201,H201<=2800),1,G202)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I201,I201<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H201>B201,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I200<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J202=1,K202=1),G200,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H201>B201,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I201,I201<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J203=1,K203=1),G201,0)","v":{"$error":"#REF!"}}]
[]
[2,{"$f":"IF(A179=A205,L205,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L196:L204)","v":{"$error":"#REF!"}}]
[]
["К3",2500,1000,50,"  до   2500х1000","компл.",1500,{"$f":"B179","v":{"$error":"#REF!"}},{"$f":"C179","v":{"$error":"#REF!"}},{"$f":"IF(H207<=B207,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I207<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J207=1,K207=1),G207,0)","v":{"$error":"#REF!"}}]
["К3",2500,2000,50,"  до   2500х2000","компл.",1790,{"$f":"H207","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H208<=B208,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I208,I208<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J208=1,K208=1),G208,0)","v":{"$error":"#REF!"}}]
["К3",2800,1000,50,"  до   2800х1000","компл.",1790,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H209,H209<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I209<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J209=1,K209=1),G209,0)","v":{"$error":"#REF!"}}]
["К3",2800,2000,50,"  до   2800х2000","компл.",2140,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H210,H210<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I210,I210<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J210=1,K210=1),G210,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H210>B210,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I209<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J211=1,K211=1),G210,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H210>B210,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I210,I210<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J212=1,K212=1),G210,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A179=A214,L214,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L207:L213)","v":{"$error":"#REF!"}}]
[]
["К3",2500,1000,80,"  до   2500х1000","компл.",1790,{"$f":"B179","v":{"$error":"#REF!"}},{"$f":"C179","v":{"$error":"#REF!"}},{"$f":"IF(H216<=B216,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I216<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J216=1,K216=1),G216,0)","v":{"$error":"#REF!"}}]
["К3",2500,2000,80,"  до   2500х2000","компл.",2140,{"$f":"H216","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H217<=B217,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I217,I217<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J217=1,K217=1),G217,0)","v":{"$error":"#REF!"}}]
["К3",2800,1000,80,"  до   2800х1000","компл.",2100,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H218,H218<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I218<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J218=1,K218=1),G218,0)","v":{"$error":"#REF!"}}]
["К3",2800,2000,80,"  до   2800х2000","компл.",2520,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H219,H219<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I219,I219<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J219=1,K219=1),G219,0)","v":{"$error":"#REF!"}}]
["К3",null,null,null,null,null,null,null,null,{"$f":"IF(H219>B219,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I218<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J220=1,K220=1),G219,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H219>B219,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I219,I219<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J221=1,K221=1),G219,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A179=A223,L223,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L216:L222)","v":{"$error":"#REF!"}}]
[]
[]
["Толщина дверного проема",{"$f":"D179","v":{"$error":"#REF!"}}]
["добор 80 мм",{"$f":"INT((B226-120)/80)","v":{"$error":"#REF!"}}]
["добор 50 мм",0]
["Остаток",{"$f":"(B226-120)-B227*80","v":{"$error":"#REF!"}}]
[]
["Необходимое количество"]
["добор 80 мм",{"$f":"IF(B229>50,B227+1,B227)","v":{"$error":"#REF!"}}]
["добор 50 мм",{"$f":"IF(AND(1<B229,B229<=50),B228+1,B228)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A179=A235,L235,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"B232","v":{"$error":"#REF!"}}]
[1,{"$f":"IF(A179=A236,L236,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"B233","v":{"$error":"#REF!"}}]
[]
[{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"Лист2!#REF!","v":{"$error":"#REF!"}},{"$f":"B251+B264","v":{"$error":"#REF!"}},1,{"$f":"F238*E238","v":{"$error":"#REF!"}},{"$f":"B295","v":{"$error":"#REF!"}},{"$f":"B294","v":{"$error":"#REF!"}},{"$f":"B273","v":{"$error":"#REF!"}},{"$f":"B282","v":{"$error":"#REF!"}},{"$f":"H238*J238+I238*K238","v":{"$error":"#REF!"}},{"$f":"G238+L238","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"Размер по проему: (высота х ширина)"," Ед.изм.","Цена/руб."]
["К3",2150,1000,{"$f":"B242+C242","v":3150},"до  2150х1000","компл.",4830,{"$f":"B238","v":{"$error":"#REF!"}},{"$f":"C238","v":{"$error":"#REF!"}},{"$f":"IF(H242<=B242,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I242<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J242=1,K242=1),G242,0)","v":{"$error":"#REF!"}}]
["К3",2150,2000,4150,"до  2150х2000","компл.",6040,{"$f":"H242","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H243<=B243,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I243,I243<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2500,1000,3500,"до  2500х1000","компл.",6040,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H244,H244<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I244<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2500,2000,4500,"до  2500х2000","компл.",7245,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H245,H245<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I245,I245<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2800,1000,3800,"до  2800х1000","компл.",7245,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H246,H246<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I246<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К3",2800,2000,4800,"до  2800х2000","компл.",8450,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H247,H247<=2800),1,G248)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I247,I247<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H247>B247,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I246<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J248=1,K248=1),G246,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H247>B247,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I247,I247<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J249=1,K249=1),G247,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A238=A251,L251,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L242:L250)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,null,null,"Размер по проему: (высота х ширина)"," Ед.изм.","Цена/руб."]
["К4",2150,1000,{"$f":"B255+C255","v":3150},"до  2150х1000","компл.",4725,{"$f":"B238","v":{"$error":"#REF!"}},{"$f":"C238","v":{"$error":"#REF!"}},{"$f":"IF(H255<=B255,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I255<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J255=1,K255=1),G255,0)","v":{"$error":"#REF!"}}]
["К4",2150,2000,4150,"до  2150х2000","компл.",5910,{"$f":"H255","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H256<=B256,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I256,I256<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2500,1000,3500,"до  2500х1000","компл.",5910,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H257,H257<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I257<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2500,2000,4500,"до  2500х2000","компл.",7090,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2150<H258,H258<=2500),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I258,I258<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2800,1000,3800,"до  2800х1000","компл.",7090,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H259,H259<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I259<=1000,1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["К4",2800,2000,4800,"до  2800х2000","компл.",8265,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H260,H260<=2800),1,G261)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I260,I260<=2000),1,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H260>B260,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I259<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J261=1,K261=1),G259,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H260>B260,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I260,I260<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J262=1,K262=1),G260,0)","v":{"$error":"#REF!"}}]
[]
[2,{"$f":"IF(A238=A264,L264,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L255:L263)","v":{"$error":"#REF!"}}]
[]
["К3",2500,1000,50,"  до   2500х1000","компл.",1500,{"$f":"B238","v":{"$error":"#REF!"}},{"$f":"C238","v":{"$error":"#REF!"}},{"$f":"IF(H266<=B266,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I266<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J266=1,K266=1),G266,0)","v":{"$error":"#REF!"}}]
["К3",2500,2000,50,"  до   2500х2000","компл.",1790,{"$f":"H266","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H267<=B267,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I267,I267<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J267=1,K267=1),G267,0)","v":{"$error":"#REF!"}}]
["К3",2800,1000,50,"  до   2800х1000","компл.",1790,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H268,H268<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I268<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J268=1,K268=1),G268,0)","v":{"$error":"#REF!"}}]
["К3",2800,2000,50,"  до   2800х2000","компл.",2140,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H269,H269<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I269,I269<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J269=1,K269=1),G269,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H269>B269,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I268<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J270=1,K270=1),G269,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H269>B269,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I269,I269<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J271=1,K271=1),G269,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A238=A273,L273,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L266:L272)","v":{"$error":"#REF!"}}]
[]
["К3",2500,1000,80,"  до   2500х1000","компл.",1790,{"$f":"B238","v":{"$error":"#REF!"}},{"$f":"C238","v":{"$error":"#REF!"}},{"$f":"IF(H275<=B275,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I275<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J275=1,K275=1),G275,0)","v":{"$error":"#REF!"}}]
["К3",2500,2000,80,"  до   2500х2000","компл.",2140,{"$f":"H275","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"IF(H276<=B276,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I276,I276<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J276=1,K276=1),G276,0)","v":{"$error":"#REF!"}}]
["К3",2800,1000,80,"  до   2800х1000","компл.",2100,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H277,H277<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I277<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J277=1,K277=1),G277,0)","v":{"$error":"#REF!"}}]
["К3",2800,2000,80,"  до   2800х2000","компл.",2520,{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"IF(AND(2500<H278,H278<=2800),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I278,I278<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J278=1,K278=1),G278,0)","v":{"$error":"#REF!"}}]
["К3",null,null,null,null,null,null,null,null,{"$f":"IF(H278>B278,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(I277<=1000,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J279=1,K279=1),G278,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H278>B278,1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(1000<I278,I278<=2000),1,0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(J280=1,K280=1),G278,0)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A238=A282,L282,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"SUM(L275:L281)","v":{"$error":"#REF!"}}]
[]
[]
["Толщина дверного проема",{"$f":"D238","v":{"$error":"#REF!"}}]
["добор 80 мм",{"$f":"INT((B285-120)/80)","v":{"$error":"#REF!"}}]
["добор 50 мм",0]
["Остаток",{"$f":"(B285-120)-B286*80","v":{"$error":"#REF!"}}]
[]
["Необходимое количество"]
["добор 80 мм",{"$f":"IF(B288>50,B286+1,B286)","v":{"$error":"#REF!"}}]
["добор 50 мм",{"$f":"IF(AND(1<B288,B288<=50),B287+1,B287)","v":{"$error":"#REF!"}}]
[]
[1,{"$f":"IF(A238=A294,L294,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"B291","v":{"$error":"#REF!"}}]
[1,{"$f":"IF(A238=A295,L295,0)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,{"$f":"B292","v":{"$error":"#REF!"}}]
[]
[]
[]
["К3"]
["К4"]
["Фристайл"]
["Деревянная Стандарт"]
["Деревянная Усиленная",null,null,null,null,null,null,"высота"]
[null,null,null,null,null,null,null,1000,2000]
[null,null,null,null,null,"ширина",2150,4830,6040]
[null,null,null,null,null,null,2500,6040,7245]
[null,null,null,null,null,null,2800,7245,8450]
[1,"К3",{"$f":"M2","v":0}]
[null,"К4",{"$f":"M2","v":0},null,null,null,2500,700,{"$f":"INDEX(H305:I307,MIN(3,SUMPRODUCT(--(G305:G307<G309))+1),MIN(2,SUMPRODUCT(--(H304:I304<H309))+1))","v":6040}]
[null,"Фристайл"]
[null,"Деревянная  Стандарт",{"$f":"'Деревянные коробки'!B3+'Деревянные коробки'!B31","v":2479.11}]
[null,"Деревянная  Усиленная",{"$f":"'Деревянные коробки'!B10+'Деревянные коробки'!B31","v":3193.11}]
[2,"К3",{"$f":"M61","v":{"$error":"#REF!"}}]
[null,"К4",{"$f":"M61","v":{"$error":"#REF!"}}]
[null,"Фристайл"]
[null,"Деревянная  Стандарт",{"$f":"'Деревянные коробки'!B4+'Деревянные коробки'!B32","v":{"$error":"#REF!"}}]
[null,"Деревянная  Усиленная",{"$f":"'Деревянные коробки'!B11+'Деревянные коробки'!B32","v":{"$error":"#REF!"}}]
[3,"К3",{"$f":"M120","v":{"$error":"#REF!"}}]
[null,"К4",{"$f":"M120","v":{"$error":"#REF!"}}]
[null,"Фристайл"]
[null,"Деревянная  Стандарт",{"$f":"'Деревянные коробки'!B5+'Деревянные коробки'!B33","v":{"$error":"#REF!"}}]
[null,"Деревянная  Усиленная",{"$f":"'Деревянные коробки'!B12+'Деревянные коробки'!B33","v":{"$error":"#REF!"}}]
[4,"К3",{"$f":"M179","v":{"$error":"#REF!"}}]
[null,"К4",{"$f":"M179","v":{"$error":"#REF!"}}]
[null,"Фристайл"]
[null,"Деревянная  Стандарт",{"$f":"'Деревянные коробки'!B6+'Деревянные коробки'!B34","v":{"$error":"#REF!"}}]
[null,"Деревянная  Усиленная",{"$f":"'Деревянные коробки'!B13+'Деревянные коробки'!B34","v":{"$error":"#REF!"}}]
[5,"К3",{"$f":"M238","v":{"$error":"#REF!"}}]
[null,"К4",{"$f":"M238","v":{"$error":"#REF!"}}]
[null,"Фристайл"]
[null,"Деревянная  Стандарт",{"$f":"'Деревянные коробки'!B7+'Деревянные коробки'!B35","v":{"$error":"#REF!"}}]
[null,"Деревянная  Усиленная",{"$f":"'Деревянные коробки'!B14+'Деревянные коробки'!B35","v":{"$error":"#REF!"}}]
[]
[null,"анодировка","9006/9016","неокрас","-"]
["Торцевая V",null,null,null,null,"Толщина стены"]
["Угловая V",null,null,null,null,125]
["Телескопическая V"]
["Обжимная V"]
["Деревянная  Стандарт"]
["Деревянная  Усиленная"]
[]
["анодировка"]
["9006/9016"]
["неокрас"]
["-"]