{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Калькулятор","Вспомогательный"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,7,2,7],[8,0,8,4],[21,0,21,5],[19,6,20,6],[19,7,20,7],[9,0,9,1],[14,0,14,1],[1,3,1,4],[1,0,2,0],[1,1,2,1],[1,2,2,2],[0,5,2,5],[0,6,2,6],[0,0,0,4]]}
["Стекло",null,null,null,null,"Площадь (м²)","Стоимость с печатью","Стоимость без печати"]
["Деталь","Ширина (м)","Высота (м)","Тип"]
[null,null,null,"БЦ","OptiWhite"]
["№1",null,null,null,null,{"$f":"B4*C4","v":0},{"$f":"IF(F4=0,0,IF(Вспомогательный!B1=2,IF(AND($F4<0.2,NOT(F4=0)),582.2,$F4*2936),IF(AND($F4<0.2,NOT(F4=0)),998,$F4*4990)))","v":0},{"$f":"IF(F4=0,0,IF(Вспомогательный!B1=2,IF(AND($F4<0.2,NOT(F4=0)),387.2,$F4*1936),IF(AND($F4<0.2,NOT(F4=0)),798,$F4*3990)))","v":0},null,2]
["№2",null,null,null,null,{"$f":"B5*C5","v":0},{"$f":"IF(F5=0,0,IF(Вспомогательный!B2=2,IF(AND($F5<0.2,NOT(F5=0)),582.2,$F5*2936),IF(AND($F5<0.2,NOT(F5=0)),998,$F5*4990)))","v":0},{"$f":"IF(F5=0,0,IF(Вспомогательный!B2=2,IF(AND($F5<0.2,NOT(F5=0)),387.2,$F5*1936),IF(AND($F5<0.2,NOT(F5=0)),798,$F5*3990)))","v":0},null,1]
["№3",null,null,null,null,{"$f":"B6*C6","v":0},{"$f":"IF(F6=0,0,IF(Вспомогательный!B3=2,IF(AND($F6<0.2,NOT(F6=0)),582.2,$F6*2936),IF(AND($F6<0.2,NOT(F6=0)),998,$F6*4990)))","v":0},{"$f":"IF(F6=0,0,IF(Вспомогательный!B3=2,IF(AND($F6<0.2,NOT(F6=0)),387.2,$F6*1936),IF(AND($F6<0.2,NOT(F6=0)),798,$F6*3990)))","v":0},null,2]
["№4",null,null,null,null,{"$f":"B7*C7","v":0},{"$f":"IF(F7=0,0,IF(Вспомогательный!B4=2,IF(AND($F7<0.2,NOT(F7=0)),582.2,$F7*2936),IF(AND($F7<0.2,NOT(F7=0)),998,$F7*4990)))","v":0},{"$f":"IF(F7=0,0,IF(Вспомогательный!B4=2,IF(AND($F7<0.2,NOT(F7=0)),387.2,$F7*1936),IF(AND($F7<0.2,NOT(F7=0)),798,$F7*3990)))","v":0},null,2]
["№5",null,null,null,null,{"$f":"B8*C8","v":0},{"$f":"IF(F8=0,0,IF(Вспомогательный!B5=2,IF(AND($F8<0.2,NOT(F8=0)),582.2,$F8*2936),IF(AND($F8<0.2,NOT(F8=0)),998,$F8*4990)))","v":0},{"$f":"IF(F8=0,0,IF(Вспомогательный!B5=2,IF(AND($F8<0.2,NOT(F8=0)),387.2,$F8*1936),IF(AND($F8<0.2,NOT(F8=0)),798,$F8*3990)))","v":0},null,1]
["ИТОГО СТЕКЛО",null,null,null,null,{"$f":"SUM(F4:F8)","v":0},{"$f":"SUM(IF(AND(F9<0.36,NOT(F9=0)),IF(Вспомогательный!B1=2,1057,1797),SUM(G4:G8)),C11:C13)","v":0},{"$f":"SUM(IF(AND(F9<0.36,NOT(F9=0)),IF(Вспомогательный!B1=2,697,1437),SUM(H4:H8)),C11:C13)","v":0}]
["Вырезы",null,"Стоимость"]
["Розетки",null,{"$f":"500*B11","v":0}]
["Вырез под вытяжку",null,{"$f":"1000*B12","v":0}]
["Крепежи (факт) / Клей",null,{"$f":"IF(Вспомогательный!A5=TRUE,1000,IF(B13=0,B14*150,B13*150))","v":0},"На клей"]
["Крепежи (авто)",{"$f":"SUM(IF(B4=0,0,IF(B4>2,6,4)),IF(B5=0,0,IF(B5>2,6,4)),IF(B6=0,0,IF(B6>2,6,4)),IF(B7=0,0,IF(B7>2,6,4)),IF(B8=0,0,IF(B8>2,6,4)))","v":0}]
["Услуги",null,"Стоимость"]
["Замер",null,{"$f":"IF(Вспомогательный!A1=TRUE,1000+35*B20,0)","v":0}]
["Монтаж",null,{"$f":"IF(Вспомогательный!$A$2=TRUE,F9*1850,0)","v":0}]
["Доставка",null,{"$f":"IF(Вспомогательный!$A$3=TRUE,2000+35*B20,0)","v":0}]
["Услуги дизайнера",null,{"$f":"IF(Вспомогательный!$A$4=TRUE,1000,0)","v":0}]
["Расстояние от КАД (км)",null,null,null,null,null,"Стоимость с печатью","Стоимость без печати"]
[]
["ИТОГО",null,null,null,null,null,{"$f":"SUM(G9,C16:C19)","v":0},{"$f":"SUM(H9,C16:C18)","v":0}]

{"sheet":"Вспомогательный","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}