{"text_format":"1","workbook":"xlsx","n_sheets":4,"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,"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":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[55,3,55,4],[56,3,56,4],[55,5,55,6],[56,5,56,6],[51,5,51,6],[52,5,52,6],[53,5,53,6],[54,5,54,6],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[2,1,2,6],[1,1,1,2],[1,3,1,6],[36,1,36,6],[43,1,43,6],[50,1,50,6],[9,1,9,6],[35,1,35,4],[42,1,42,4],[8,1,8,4],[49,1,49,4]]}
[]
[null,"Название продукции:"]
[null,"I. Проектно-расчетные услуги"]
[null,"№","Наименование","Кол-во","Ед. изм.","Цена, руб.","Сумма, руб."]
[null,{"$f":"SUBTOTAL(103,$C$5:C5)","v":1},{"$f":"Калькулятор!C53","v":0},{"$f":"Калькулятор!D53","v":0},{"$f":"VLOOKUP(C5,Справочник!B2:D108,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C5,Справочник!B2:D108,2,0)","v":{"$error":"#N/A"}},{"$f":"F5*D5","v":{"$error":"#N/A"}}]
[null,{"$f":"SUBTOTAL(103,$C$5:C6)","v":2},{"$f":"Калькулятор!C54","v":"Наружная реклама:"},{"$f":"Калькулятор!D54","v":0},{"$f":"VLOOKUP(C6,Справочник!B2:D108,3,0)","v":0},{"$f":"VLOOKUP(C6,Справочник!B2:D108,2,0)","v":0},{"$f":"F6*D6","v":0}]
[null,{"$f":"SUBTOTAL(103,$C$5:C7)","v":3},{"$f":"Калькулятор!C55","v":"3D проект фасада"},{"$f":"Калькулятор!D55","v":0},{"$f":"VLOOKUP(C7,Справочник!B2:D108,3,0)","v":"усл."},{"$f":"VLOOKUP(C7,Справочник!B2:D108,2,0)","v":5000},{"$f":"F7*D7","v":0}]
[null,{"$f":"SUBTOTAL(103,$C$5:C8)","v":4},{"$f":"Калькулятор!C56","v":0},{"$f":"Калькулятор!D56","v":0},{"$f":"VLOOKUP(C8,Справочник!B2:D108,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C8,Справочник!B2:D108,2,0)","v":{"$error":"#N/A"}},{"$f":"F8*D8","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Итого:",{"$f":"SUMIF(G5:G8,\"<>#Н/Д\")","v":0}]
[null,"II. Материалы"]
[null,"№","Наименование","Кол-во","Ед. изм.","Цена, руб.","Сумма, руб."]
[null,1,{"$f":"CONCATENATE(Калькулятор!C3,Калькулятор!C28)","v":""},{"$f":"VLOOKUP(C12,Калькулятор!C1:D50,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C12,Справочник!B2:D108,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C12,Справочник!B2:D108,2,0)","v":{"$error":"#N/A"}},{"$f":"F12*D12","v":{"$error":"#N/A"}}]
[null,2,{"$f":"CONCATENATE(Калькулятор!C4,Калькулятор!C29)","v":""},{"$f":"VLOOKUP(C13,Калькулятор!C2:D51,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C13,Справочник!B3:D109,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C13,Справочник!B3:D109,2,0)","v":{"$error":"#N/A"}},{"$f":"F13*D13","v":{"$error":"#N/A"}}]
[null,3,{"$f":"CONCATENATE(Калькулятор!C5,Калькулятор!C30)","v":""},{"$f":"VLOOKUP(C14,Калькулятор!C3:D52,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C14,Справочник!B4:D110,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C14,Справочник!B4:D110,2,0)","v":{"$error":"#N/A"}},{"$f":"F14*D14","v":{"$error":"#N/A"}}]
[null,4,{"$f":"CONCATENATE(Калькулятор!C6,Калькулятор!C31)","v":""},{"$f":"VLOOKUP(C15,Калькулятор!C4:D53,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C15,Справочник!B5:D111,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C15,Справочник!B5:D111,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,5,{"$f":"CONCATENATE(Калькулятор!C7,Калькулятор!C32)","v":""},{"$f":"VLOOKUP(C16,Калькулятор!C5:D54,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C16,Справочник!B6:D112,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C16,Справочник!B6:D112,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,6,{"$f":"CONCATENATE(Калькулятор!C8,Калькулятор!C33)","v":""},{"$f":"VLOOKUP(C17,Калькулятор!C6:D55,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C17,Справочник!B7:D113,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C17,Справочник!B7:D113,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,7,{"$f":"CONCATENATE(Калькулятор!C9,Калькулятор!C34)","v":""},{"$f":"VLOOKUP(C18,Калькулятор!C7:D56,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C18,Справочник!B8:D114,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C18,Справочник!B8:D114,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,8,{"$f":"CONCATENATE(Калькулятор!C10,Калькулятор!C35)","v":""},{"$f":"VLOOKUP(C19,Калькулятор!C8:D57,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C19,Справочник!B9:D115,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C19,Справочник!B9:D115,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,9,{"$f":"CONCATENATE(Калькулятор!C11,Калькулятор!C36)","v":""},{"$f":"VLOOKUP(C20,Калькулятор!C9:D58,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C20,Справочник!B10:D116,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C20,Справочник!B10:D116,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,10,{"$f":"CONCATENATE(Калькулятор!C12,Калькулятор!C37)","v":""},{"$f":"VLOOKUP(C21,Калькулятор!C10:D59,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C21,Справочник!B11:D117,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C21,Справочник!B11:D117,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,11,{"$f":"CONCATENATE(Калькулятор!C13,Калькулятор!C38)","v":""},{"$f":"VLOOKUP(C22,Калькулятор!C11:D60,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C22,Справочник!B12:D118,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C22,Справочник!B12:D118,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,12,{"$f":"CONCATENATE(Калькулятор!C18,Калькулятор!C43)","v":""},{"$f":"VLOOKUP(C23,Калькулятор!C12:D61,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C23,Справочник!B13:D119,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C23,Справочник!B13:D119,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,13,{"$f":"CONCATENATE(Калькулятор!C15,Калькулятор!C40)","v":""},{"$f":"VLOOKUP(C24,Калькулятор!C13:D62,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C24,Справочник!B14:D120,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C24,Справочник!B14:D120,2,0)","v":{"$error":"#N/A"}},{"$f":"F24*D24","v":{"$error":"#N/A"}}]
[null,14,{"$f":"CONCATENATE(Калькулятор!C16,Калькулятор!C41)","v":""},{"$f":"VLOOKUP(C25,Калькулятор!C14:D63,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C25,Справочник!B15:D121,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C25,Справочник!B15:D121,2,0)","v":{"$error":"#N/A"}},{"$f":"F25*D25","v":{"$error":"#N/A"}}]
[null,15,{"$f":"CONCATENATE(Калькулятор!C17,Калькулятор!C42)","v":""},{"$f":"VLOOKUP(C26,Калькулятор!C15:D64,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C26,Справочник!B16:D122,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C26,Справочник!B16:D122,2,0)","v":{"$error":"#N/A"}},{"$f":"F26*D26","v":{"$error":"#N/A"}}]
[null,16,{"$f":"CONCATENATE(Калькулятор!C43)","v":""},{"$f":"VLOOKUP(C27,Калькулятор!C16:D65,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C27,Справочник!B17:D123,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C27,Справочник!B17:D123,2,0)","v":{"$error":"#N/A"}},{"$f":"F27*D27","v":{"$error":"#N/A"}}]
[null,17,{"$f":"CONCATENATE(Калькулятор!C19,Калькулятор!C44)","v":""},{"$f":"VLOOKUP(C28,Калькулятор!C13:D62,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C28,Справочник!B14:D120,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C28,Справочник!B14:D120,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,18,{"$f":"CONCATENATE(Калькулятор!C20,Калькулятор!C45)","v":""},{"$f":"VLOOKUP(C29,Калькулятор!C18:D63,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C29,Справочник!B15:D121,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C29,Справочник!B15:D121,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,19,{"$f":"CONCATENATE(Калькулятор!C21,Калькулятор!C46)","v":""},{"$f":"VLOOKUP(C30,Калькулятор!C19:D64,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C30,Справочник!B16:D122,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C30,Справочник!B16:D122,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,20,{"$f":"CONCATENATE(Калькулятор!C22,Калькулятор!C47)","v":""},{"$f":"VLOOKUP(C31,Калькулятор!C20:D65,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C31,Справочник!B17:D123,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C31,Справочник!B17:D123,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,21,{"$f":"CONCATENATE(Калькулятор!C23,Калькулятор!C48)","v":""},{"$f":"VLOOKUP(C32,Калькулятор!C2:D51,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C32,Калькулятор!C3:F51,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C32,Калькулятор!C3:F51,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,22,{"$f":"CONCATENATE(Калькулятор!C24,Калькулятор!C49)","v":""},{"$f":"VLOOKUP(C33,Калькулятор!C3:D52,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C33,Калькулятор!C4:F52,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C33,Калькулятор!C4:F52,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,23,{"$f":"CONCATENATE(Калькулятор!C25,Калькулятор!C50)","v":""},{"$f":"VLOOKUP(C34,Калькулятор!C4:D53,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C34,Калькулятор!C5:F53,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C34,Калькулятор!C5:F53,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,24,{"$f":"CONCATENATE(Калькулятор!C26,Калькулятор!C51)","v":""},{"$f":"VLOOKUP(C35,Калькулятор!C5:D54,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C35,Калькулятор!C6:F54,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C35,Калькулятор!C6:F54,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,"Итого:",{"$f":"SUMIF(G12:G35,\"<>#Н/Д\")","v":0}]
[null,"III. Работы"]
[null,"№","Наименование","Кол-во ","Ед. изм.","Цена, руб.","Сумма, руб."]
[null,1,{"$f":"Калькулятор!C63","v":0},{"$f":"Калькулятор!D63","v":0},{"$f":"VLOOKUP(C39,Справочник!B2:D108,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C39,Справочник!B2:D108,2,0)","v":{"$error":"#N/A"}},{"$f":"F39*D39","v":{"$error":"#N/A"}}]
[null,2,{"$f":"Калькулятор!C64","v":0},{"$f":"Калькулятор!D64","v":0},{"$f":"VLOOKUP(C40,Справочник!B3:D109,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C40,Справочник!B3:D109,2,0)","v":{"$error":"#N/A"}},{"$f":"F40*D40","v":{"$error":"#N/A"}}]
[null,3,{"$f":"Калькулятор!C65","v":0},{"$f":"Калькулятор!D65","v":0},{"$f":"VLOOKUP(C41,Справочник!B4:D110,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C41,Справочник!B4:D110,2,0)","v":{"$error":"#N/A"}},{"$f":"F41*D41","v":{"$error":"#N/A"}}]
[null,4,{"$f":"Калькулятор!C66","v":0},{"$f":"Калькулятор!D66","v":0},{"$f":"VLOOKUP(C42,Справочник!B5:D111,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C42,Справочник!B5:D111,2,0)","v":{"$error":"#N/A"}},{"$f":"F42*D42","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Итого:",{"$f":"SUMIF(G39:G42,\"<>#Н/Д\")","v":0}]
[null,"IV. Выездные работы"]
[null,"№","Наименование","Кол-во ","Ед. изм.","Цена, руб.","Сумма, руб."]
[null,1,{"$f":"Калькулятор!C58","v":0},{"$f":"Калькулятор!D58","v":0},{"$f":"VLOOKUP(C46,Справочник!B2:D108,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C46,Справочник!B2:D108,2,0)","v":{"$error":"#N/A"}},{"$f":"F46*D46","v":{"$error":"#N/A"}}]
[null,2,{"$f":"Калькулятор!C59","v":0},{"$f":"Калькулятор!D59","v":0},{"$f":"VLOOKUP(C47,Справочник!B3:D109,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C47,Справочник!B3:D109,2,0)","v":{"$error":"#N/A"}},{"$f":"F47*D47","v":{"$error":"#N/A"}}]
[null,3,{"$f":"Калькулятор!C60","v":0},{"$f":"Калькулятор!D60","v":0},{"$f":"VLOOKUP(C48,Справочник!B4:D110,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C48,Справочник!B4:D110,2,0)","v":{"$error":"#N/A"}},{"$f":"F48*D48","v":{"$error":"#N/A"}}]
[null,4,{"$f":"Калькулятор!C61","v":0},{"$f":"Калькулятор!D61","v":0},{"$f":"VLOOKUP(C49,Справочник!B5:D111,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C49,Справочник!B5:D111,2,0)","v":{"$error":"#N/A"}},{"$f":"F49*D49","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Итого:",{"$f":"SUMIF(G46:G49,\"<>#Н/Д\")","v":0}]
[null,"V. Рентабельность  производства"]
[null,"№","Наименование","Ед. изм.",null,"Сумма, руб."]
[null,1,"Прибыль предприятия","%",null,{"$f":"SUM(G50+G43+G36+G9)*0.2","v":0}]
[null,2,"Налоговые отчисления","%",null,{"$f":"SUM(G50+G43+G36+G9)*0.15","v":0}]
[null,3,"Отчисления во внебюджетные фонды","%",null,{"$f":"SUM(G50+G43+G36+G9)*0.07","v":0}]
[null,null,null,"Итого:",null,{"$f":"SUM(F53+F54+F55)","v":0}]
[null,null,null,"Итого стоимость заказа:",null,{"$f":"SUM(F56+G50+G43+G36+G9)","v":0}]

{"sheet":"Калькулятор","index":1,"n_rows":324,"n_cols":7,"rows_kept":324,"cut":false,"hidden":false,"merged":[[47,6,48,6],[22,6,23,6],[24,6,25,6],[49,6,50,6],[57,1,60,1],[62,1,65,1],[52,1,55,1],[2,1,5,1],[6,1,9,1],[10,1,17,1],[18,1,21,1],[47,1,50,1],[22,1,25,1],[27,1,30,1],[31,1,34,1],[35,1,42,1],[43,1,46,1]]}
[]
[null,"Объемные буквы:","Наименование:","Кол-во:"]
[null,"Листовые материалы:"]
[]
[]
[]
[null,"Светотехника:"]
[]
[]
[]
[null,"Расходные материалы:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Метизы:"]
[]
[]
[]
[null,"Комплектация:",null,null,null,null,"1. Цена:"]
[]
[null,null,null,null,null,null,"2. Ед. изм."]
[]
[null,"Световые/несветовые вывески","Наименование:","Кол-во:"]
[null,"Листовые материалы:"]
[]
[]
[]
[null,"Светотехника:"]
[]
[]
[]
[null,"Расходные материалы:"]
[]
[]
[]
[]
[]
[]
[]
[null,"Метизы:"]
[]
[]
[]
[null,"Комплектация:",null,null,null,null,"1. Цена:"]
[]
[null,null,null,null,null,null,"2. Ед. изм."]
[]
[null,"Дизайн:","Наименование:","Кол-во:"]
[null,"Перечень услуг:"]
[null,null,"Наружная реклама:"]
[null,null,"3D проект фасада"]
[]
[null,"Выездные работы:","Наименование:","Кол-во:"]
[null,"Перечень услуг:"]
[]
[]
[]
[null,"Работы:","Наименование:","Кол-во:"]
[null,"Перечень услуг:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Оргстекло 3000*2000*10 мм"]
[null,"Оргстекло 3000*2000*2 мм "]
[null,"Оргстекло 3000*2000*1.8 мм "]
[null,"Оргстекло 3 мм. 2.05*3.05 м"]
[null,"Вспененный ПВХ-пластик 2030*3050*3 мм"]
[null,"Вспененный ПВХ-пластик 2030*3050*5 мм"]
[null,"Вспененный ПВХ-пластик 2030*3050*8 мм"]
[null,"Вспененный ПВХ-пластик 2030*3050*10 мм"]
[null,"Композитный материал 1.5*4*3 мм "]
[null,"Монолитный ПК 3050*2050*2 мм"]
[null,"Полистирол УПМ. 3 мм. 2000*3000 мм"]
[null,"МДФ, 2440*1830, 16мм для форм"]
[null,"Поликарбонат сотовый 2100*6000*4 мм "]
[null,"Поликарбонат сотовы 2100*6000*6 мм"]
[]
[null,"Блок питания 36 W защитный"]
[null,"Блок питания 100 W защитный"]
[null,"Блок питания 120 W защитный"]
[null,"Блок питания 150 W защитный"]
[null,"Блок питания 150 W"]
[null,"Блок питания 200 W"]
[null,"Диммер"]
[null,"Контроллер динамический"]
[null,"Лента светодиодная"]
[null,"Модуль светодиодный"]
[null,"Фотореле"]
[null,"Флекс неон (светодиодный неон)"]
[]
[null,"Клей цианоакрилатный"]
[null,"Клей PMMA"]
[null,"Термоклей"]
[null,"Термоусадка"]
[null,"Провод ПВС"]
[null,"Герметик акриловый"]
[null,"Грунт, краска"]
[null,"Лак финишный"]
[null,"Лист шлифовальный"]
[null,"Проф. труба 25*25*1.5"]
[null,"Проф. труба 40*20*2"]
[null,"Хомут пластиковый, 100 шт."]
[null,"Пленка Oracal 641"]
[null,"Пленка светопропускающая"]
[null,"Шпатлевка "]
[null,"Гофра"]
[null,"Кабель-канал"]
[null,"Скотч двусторонний"]
[null,"Фреза"]
[]
[null,"Саморез"]
[null,"Крепежная пластина"]
[null,"Крепежный уголок"]
[null,"Дюбель рамный"]
[null,"Болт с гайкой"]
[null,"Сверло по металлу"]
[]
[null,"Наружная реклама:"]
[null,"3D проект фасада"]
[null,"3D проект стела, стойка, пилон "]
[null,"Вывеска с подсветкой (день/ночь), привязка к месту"]
[null,"Вывеска несветовая, привязка к месту"]
[null,"Банер фасадный, привязка к месту"]
[null,"Выставочный стенд (Roll Up)"]
[null,"Оформление витрины (аппликация пленкой)"]
[null,"Штендер"]
[null,"Табличка на дверь"]
[null,"Режим работы"]
[null,"Полиграфия:"]
[null,"Листовка, буклет, каталог"]
[null,"Визитка"]
[null,"Пластиковая карта"]
[null,"Плакаты, постеры А3, А4"]
[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,"Автовышка"]

{"sheet":"Справочник","index":2,"n_rows":108,"n_cols":4,"rows_kept":108,"cut":false,"hidden":false,"merged":[[101,1,101,3],[2,1,2,3],[17,1,17,3],[30,1,30,3],[50,1,50,3],[57,1,57,3],[58,1,58,3],[69,1,69,3],[74,1,74,3],[79,1,79,3],[83,1,83,3],[90,1,90,3]]}
[]
[null,"Наименование:","Цена:","Ед. изм."]
[null,"Листовые материалы:"]
[null,"Оргстекло 3000*2000*10 мм",19000,"лист"]
[null,"Оргстекло 3000*2000*2 мм ",4500,"лист"]
[null,"Оргстекло 3000*2000*1.8 мм ",4350,"лист"]
[null,"Оргстекло 3 мм. 2.05*3.05 м",7000,"лист"]
[null,"Вспененный ПВХ-пластик 2030*3050*3 мм",3000,"лист"]
[null,"Вспененный ПВХ-пластик 2030*3050*5 мм",4000,"лист"]
[null,"Вспененный ПВХ-пластик 2030*3050*8 мм",6500,"лист"]
[null,"Вспененный ПВХ-пластик 2030*3050*10 мм",7000,"лист"]
[null,"Композитный материал 1.5*4*3 мм ",6500,"лист"]
[null,"Монолитный ПК 3050*2050*2 мм",5000,"лист"]
[null,"Полистирол УПМ. 3 мм. 2000*3000 мм",5000,"лист"]
[null,"МДФ, 2440*1830, 16мм для форм",1500,"лист"]
[null,"Поликарбонат сотовый 2100*6000*4 мм ",3000,"лист"]
[null,"Поликарбонат сотовы 2100*6000*6 мм",4500,"лист"]
[null,"Светотехника:"]
[null,"Блок питания 36 W защитный",600,"шт."]
[null,"Диммер",2000,"шт."]
[null,"Блок питания 100 W защитный",2500,"шт."]
[null,"Блок питания 120 W защитный",2600,"шт."]
[null,"Блок питания 150 W защитный",2800,"шт."]
[null,"Блок питания 150 W",3000,"шт."]
[null,"Блок питания 200 W",3500,"шт."]
[null,"Контроллер динамический",5000,"шт."]
[null,"Лента светодиодная",250,"п.м."]
[null,"Модуль светодиодный",60,"шт."]
[null,"Фотореле",2000,"шт."]
[null,"Флекс неон (светодиодный неон)",800,"шт."]
[null,"Расходные материалы:"]
[null,"Клей цианоакрилатный",200,"шт."]
[null,"Клей PMMA",350,"шт."]
[null,"Термоклей",180,"шт."]
[null,"Термоусадка",110,"шт."]
[null,"Провод ПВС",20,"п.м."]
[null,"Герметик акриловый",350,"шт."]
[null,"Грунт, краска",1000,"л."]
[null,"Лак финишный",1000,"л."]
[null,"Лист шлифовальный",50,"шт."]
[null,"Проф. труба 25*25*1.5",59,"п.м."]
[null,"Проф. труба 40*20*2",75,"п.м."]
[null,"Хомут пластиковый, 100 шт.",480,"уп."]
[null,"Пленка Oracal 641",300,"м2"]
[null,"Пленка светопропускающая",650,"м2"]
[null,"Шпатлевка ",250,"кг."]
[null,"Гофра",9,"шт."]
[null,"Кабель-канал",40,"п.м."]
[null,"Скотч двусторонний",150,"шт."]
[null,"Фреза",1000,"шт."]
[null,"Метизы:"]
[null,"Саморез",1,"шт."]
[null,"Крепежная пластина",50,"шт."]
[null,"Крепежный уголок",80,"шт."]
[null,"Дюбель рамный",25,"шт."]
[null,"Болт с гайкой",9,"шт."]
[null,"Сверло по металлу",100,"шт."]
[null,"Дизайн:"]
[null,"Наружная реклама:"]
[null,"3D проект фасада",5000,"усл."]
[null,"3D проект стела, стойка, пилон ",5000,"усл."]
[null,"Вывеска с подсветкой (день/ночь), привязка к месту",2000,"усл."]
[null,"Вывеска несветовая, привязка к месту",1000,"усл."]
[null,"Банер фасадный, привязка к месту",2000,"усл."]
[null,"Выставочный стенд (Roll Up)",1000,"усл."]
[null,"Оформление витрины (аппликация пленкой)",2500,"усл."]
[null,"Штендер",1000,"усл."]
[null,"Табличка на дверь",350,"усл."]
[null,"Режим работы",350,"усл."]
[null,"Полиграфия:"]
[null,"Листовка, буклет, каталог",1500,"усл."]
[null,"Визитка",500,"усл."]
[null,"Пластиковая карта",1000,"усл."]
[null,"Плакаты, постеры А3, А4",2000,"усл."]
[null,"Транспорт:"]
[null,"Брендирование легкового авто",2500,"усл."]
[null,"Брендирование грузового авто",2500,"усл."]
[null,"Наклейка на заднее стекло (текст)",350,"усл."]
[null,"Наклейка на заднее стекло (полноцветное изображение)",1000,"усл."]
[null,"Фирменный стиль:"]
[null,"Разработка логотипа",10000,"усл."]
[null,"Элемент фирменого стиля (бланк, блокнот, открытка)",1500,"усл."]
[null,"Сувенирка (ручки, кружки, флешки)",500,"усл."]
[null,"Разное:"]
[null,"Минимальная работа дизайнера",350,"усл."]
[null,"Замер",200,"усл."]
[null,"Допечатная подготовка",200,"усл."]
[null,"Корректировки готового макета",500,"усл."]
[null,"Набор текста + фон",350,"усл."]
[null,"Покупка картинки",300,"усл."]
[null,"Работы:"]
[null,"Фрезерные работы на станке",2000,"ч. час"]
[null,"Сборка",385,"ч. час"]
[null,"Сборка электрики",400,"ч. час"]
[null,"Резка",385,"ч. час"]
[null,"Сварка",385,"ч. час"]
[null,"Покраска и/или грунтование",385,"ч. час"]
[null,"Проклейка ",385,"ч. час"]
[null,"Люверсовка",385,"ч. час"]
[null,"Подготовка производства",385,"ч. час"]
[null,"Монтаж пленки",250,"ч. час"]
[null,"Выездные работы:"]
[null,"Доставка легковым транспортом в области",20,"км."]
[null,"Доставка грузовым транспортом по области",15,"км."]
[null,"Доставка по городу",500,"усл."]
[null,"Монтаж",{"$f":"SUM(Смета!G43+Смета!G36+Смета!G9)","v":0},"усл."]
[null,"Командировочные",500,"день"]
[null,"Автовышка",1500,"час"]

{"sheet":"Смета с корректировками","index":3,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[[56,3,56,4],[56,5,56,6],[53,3,53,4],[53,5,53,6],[54,3,54,4],[54,5,54,6],[55,3,55,4],[55,5,55,6],[51,3,51,4],[51,5,51,6],[52,3,52,4],[52,5,52,6],[35,1,35,4],[36,1,36,6],[42,1,42,4],[43,1,43,6],[49,1,49,4],[50,1,50,6],[1,1,1,2],[1,3,1,6],[2,1,2,6],[8,1,8,4],[9,1,9,6]]}
[]
[null,"Название продукции:"]
[null,"I. Проектно-расчетные услуги"]
[null,"№","Наименование","Кол-во","Ед. изм.","Цена, руб.","Сумма, руб."]
[null,1,{"$f":"Калькулятор!C53","v":0},{"$f":"Калькулятор!D53","v":0},{"$f":"VLOOKUP(C5,Справочник!B2:D108,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C5,Справочник!B2:D108,2,0)","v":{"$error":"#N/A"}},{"$f":"F5*D5","v":{"$error":"#N/A"}}]
[null,2,{"$f":"Калькулятор!C54","v":"Наружная реклама:"},{"$f":"Калькулятор!D54","v":0},{"$f":"VLOOKUP(C6,Справочник!B2:D108,3,0)","v":0},{"$f":"VLOOKUP(C6,Справочник!B2:D108,2,0)","v":0},{"$f":"F6*D6","v":0}]
[null,3,{"$f":"Калькулятор!C55","v":"3D проект фасада"},{"$f":"Калькулятор!D55","v":0},{"$f":"VLOOKUP(C7,Справочник!B2:D108,3,0)","v":"усл."},{"$f":"VLOOKUP(C7,Справочник!B2:D108,2,0)","v":5000},{"$f":"F7*D7","v":0}]
[null,4,{"$f":"Калькулятор!C56","v":0},{"$f":"Калькулятор!D56","v":0},{"$f":"VLOOKUP(C8,Справочник!B2:D108,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C8,Справочник!B2:D108,2,0)","v":{"$error":"#N/A"}},{"$f":"F8*D8","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Итого:",{"$f":"SUMIF(G5:G8,\"<>#Н/Д\")","v":0}]
[null,"II. Материалы"]
[null,"№","Наименование","Кол-во","Ед. изм.","Цена, руб.","Сумма, руб."]
[null,1,{"$f":"CONCATENATE(Калькулятор!C3,Калькулятор!C28)","v":""},{"$f":"VLOOKUP(C12,Калькулятор!C1:D50,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C12,Справочник!B2:D108,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C12,Справочник!B2:D108,2,0)","v":{"$error":"#N/A"}},{"$f":"F12*D12","v":{"$error":"#N/A"}}]
[null,2,{"$f":"CONCATENATE(Калькулятор!C4,Калькулятор!C29)","v":""},{"$f":"VLOOKUP(C13,Калькулятор!C2:D51,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C13,Справочник!B3:D109,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C13,Справочник!B3:D109,2,0)","v":{"$error":"#N/A"}},{"$f":"F13*D13","v":{"$error":"#N/A"}}]
[null,3,{"$f":"CONCATENATE(Калькулятор!C5,Калькулятор!C30)","v":""},{"$f":"VLOOKUP(C14,Калькулятор!C3:D52,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C14,Справочник!B4:D110,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C14,Справочник!B4:D110,2,0)","v":{"$error":"#N/A"}},{"$f":"F14*D14","v":{"$error":"#N/A"}}]
[null,4,{"$f":"CONCATENATE(Калькулятор!C6,Калькулятор!C31)","v":""},{"$f":"VLOOKUP(C15,Калькулятор!C4:D53,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C15,Справочник!B5:D111,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C15,Справочник!B5:D111,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,5,{"$f":"CONCATENATE(Калькулятор!C7,Калькулятор!C32)","v":""},{"$f":"VLOOKUP(C16,Калькулятор!C5:D54,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C16,Справочник!B6:D112,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C16,Справочник!B6:D112,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,6,{"$f":"CONCATENATE(Калькулятор!C8,Калькулятор!C33)","v":""},{"$f":"VLOOKUP(C17,Калькулятор!C6:D55,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C17,Справочник!B7:D113,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C17,Справочник!B7:D113,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,7,{"$f":"CONCATENATE(Калькулятор!C9,Калькулятор!C34)","v":""},{"$f":"VLOOKUP(C18,Калькулятор!C7:D56,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C18,Справочник!B8:D114,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C18,Справочник!B8:D114,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,8,{"$f":"CONCATENATE(Калькулятор!C10,Калькулятор!C35)","v":""},{"$f":"VLOOKUP(C19,Калькулятор!C8:D57,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C19,Справочник!B9:D115,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C19,Справочник!B9:D115,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,9,{"$f":"CONCATENATE(Калькулятор!C11,Калькулятор!C36)","v":""},{"$f":"VLOOKUP(C20,Калькулятор!C9:D58,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C20,Справочник!B10:D116,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C20,Справочник!B10:D116,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,10,{"$f":"CONCATENATE(Калькулятор!C12,Калькулятор!C37)","v":""},{"$f":"VLOOKUP(C21,Калькулятор!C10:D59,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C21,Справочник!B11:D117,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C21,Справочник!B11:D117,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,11,{"$f":"CONCATENATE(Калькулятор!C13,Калькулятор!C38)","v":""},{"$f":"VLOOKUP(C22,Калькулятор!C11:D60,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C22,Справочник!B12:D118,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C22,Справочник!B12:D118,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,12,{"$f":"CONCATENATE(Калькулятор!C18,Калькулятор!C43)","v":""},{"$f":"VLOOKUP(C23,Калькулятор!C12:D61,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C23,Справочник!B13:D119,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C23,Справочник!B13:D119,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,13,{"$f":"CONCATENATE(Калькулятор!C15,Калькулятор!C40)","v":""},{"$f":"VLOOKUP(C24,Калькулятор!C13:D62,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C24,Справочник!B14:D120,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C24,Справочник!B14:D120,2,0)","v":{"$error":"#N/A"}},{"$f":"F24*D24","v":{"$error":"#N/A"}}]
[null,14,{"$f":"CONCATENATE(Калькулятор!C16,Калькулятор!C41)","v":""},{"$f":"VLOOKUP(C25,Калькулятор!C14:D63,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C25,Справочник!B15:D121,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C25,Справочник!B15:D121,2,0)","v":{"$error":"#N/A"}},{"$f":"F25*D25","v":{"$error":"#N/A"}}]
[null,15,{"$f":"CONCATENATE(Калькулятор!C17,Калькулятор!C42)","v":""},{"$f":"VLOOKUP(C26,Калькулятор!C15:D64,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C26,Справочник!B16:D122,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C26,Справочник!B16:D122,2,0)","v":{"$error":"#N/A"}},{"$f":"F26*D26","v":{"$error":"#N/A"}}]
[null,16,{"$f":"CONCATENATE(Калькулятор!C43)","v":""},{"$f":"VLOOKUP(C27,Калькулятор!C16:D65,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C27,Справочник!B17:D123,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C27,Справочник!B17:D123,2,0)","v":{"$error":"#N/A"}},{"$f":"F27*D27","v":{"$error":"#N/A"}}]
[null,17,{"$f":"CONCATENATE(Калькулятор!C19,Калькулятор!C44)","v":""},{"$f":"VLOOKUP(C28,Калькулятор!C13:D62,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C28,Справочник!B14:D120,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C28,Справочник!B14:D120,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,18,{"$f":"CONCATENATE(Калькулятор!C20,Калькулятор!C45)","v":""},{"$f":"VLOOKUP(C29,Калькулятор!C18:D63,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C29,Справочник!B15:D121,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C29,Справочник!B15:D121,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,19,{"$f":"CONCATENATE(Калькулятор!C21,Калькулятор!C46)","v":""},{"$f":"VLOOKUP(C30,Калькулятор!C19:D64,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C30,Справочник!B16:D122,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C30,Справочник!B16:D122,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,20,{"$f":"CONCATENATE(Калькулятор!C22,Калькулятор!C47)","v":""},{"$f":"VLOOKUP(C31,Калькулятор!C20:D65,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C31,Справочник!B17:D123,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C31,Справочник!B17:D123,2,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,21,{"$f":"CONCATENATE(Калькулятор!C23,Калькулятор!C48)","v":""},{"$f":"VLOOKUP(C32,Калькулятор!C2:D51,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C32,Калькулятор!C3:F51,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C32,Калькулятор!C3:F51,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,22,{"$f":"CONCATENATE(Калькулятор!C24,Калькулятор!C49)","v":""},{"$f":"VLOOKUP(C33,Калькулятор!C3:D52,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C33,Калькулятор!C4:F52,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C33,Калькулятор!C4:F52,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,23,{"$f":"CONCATENATE(Калькулятор!C25,Калькулятор!C50)","v":""},{"$f":"VLOOKUP(C34,Калькулятор!C4:D53,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C34,Калькулятор!C5:F53,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C34,Калькулятор!C5:F53,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,24,{"$f":"CONCATENATE(Калькулятор!C26,Калькулятор!C51)","v":""},{"$f":"VLOOKUP(C35,Калькулятор!C5:D54,2,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C35,Калькулятор!C6:F54,4,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C35,Калькулятор!C6:F54,3,0)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,"Итого:",{"$f":"SUMIF(G12:G35,\"<>#Н/Д\")","v":0}]
[null,"III. Работы"]
[null,"№","Наименование","Кол-во ","Ед. изм.","Цена, руб.","Сумма, руб."]
[null,1,{"$f":"Калькулятор!C63","v":0},{"$f":"Калькулятор!D63","v":0},{"$f":"VLOOKUP(C39,Справочник!B2:D108,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C39,Справочник!B2:D108,2,0)","v":{"$error":"#N/A"}},{"$f":"F39*D39","v":{"$error":"#N/A"}}]
[null,2,{"$f":"Калькулятор!C64","v":0},{"$f":"Калькулятор!D64","v":0},{"$f":"VLOOKUP(C40,Справочник!B3:D109,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C40,Справочник!B3:D109,2,0)","v":{"$error":"#N/A"}},{"$f":"F40*D40","v":{"$error":"#N/A"}}]
[null,3,{"$f":"Калькулятор!C65","v":0},{"$f":"Калькулятор!D65","v":0},{"$f":"VLOOKUP(C41,Справочник!B4:D110,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C41,Справочник!B4:D110,2,0)","v":{"$error":"#N/A"}},{"$f":"F41*D41","v":{"$error":"#N/A"}}]
[null,4,{"$f":"Калькулятор!C66","v":0},{"$f":"Калькулятор!D66","v":0},{"$f":"VLOOKUP(C42,Справочник!B5:D111,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C42,Справочник!B5:D111,2,0)","v":{"$error":"#N/A"}},{"$f":"F42*D42","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Итого:",{"$f":"SUMIF(G39:G42,\"<>#Н/Д\")","v":0}]
[null,"IV. Выездные работы"]
[null,"№","Наименование","Кол-во ","Ед. изм.","Цена, руб.","Сумма, руб."]
[null,1,{"$f":"Калькулятор!C58","v":0},{"$f":"Калькулятор!D58","v":0},{"$f":"VLOOKUP(C46,Справочник!B2:D108,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C46,Справочник!B2:D108,2,0)","v":{"$error":"#N/A"}},{"$f":"F46*D46","v":{"$error":"#N/A"}}]
[null,2,{"$f":"Калькулятор!C59","v":0},{"$f":"Калькулятор!D59","v":0},{"$f":"VLOOKUP(C47,Справочник!B3:D109,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C47,Справочник!B3:D109,2,0)","v":{"$error":"#N/A"}},{"$f":"F47*D47","v":{"$error":"#N/A"}}]
[null,3,{"$f":"Калькулятор!C60","v":0},{"$f":"Калькулятор!D60","v":0},{"$f":"VLOOKUP(C48,Справочник!B4:D110,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C48,Справочник!B4:D110,2,0)","v":{"$error":"#N/A"}},{"$f":"F48*D48","v":{"$error":"#N/A"}}]
[null,4,{"$f":"Калькулятор!C61","v":0},{"$f":"Калькулятор!D61","v":0},{"$f":"VLOOKUP(C49,Справочник!B5:D111,3,0)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(C49,Справочник!B5:D111,2,0)","v":{"$error":"#N/A"}},{"$f":"F49*D49","v":{"$error":"#N/A"}}]
[null,null,null,null,null,"Итого:",{"$f":"SUMIF(G46:G49,\"<>#Н/Д\")","v":0}]
[null,"V. Рентабельность  производства"]
[null,"№","Наименование","Ед. изм.",null,"Сумма, руб."]
[null,1,"Прибыль предприятия","%",null,{"$f":"SUM(G50+G43+G36+G9)*0.2","v":0}]
[null,2,"Налоговые отчисления","%",null,{"$f":"SUM(G50+G43+G36+G9)*0.15","v":0}]
[null,3,"Отчисления во внебюджетные фонды","%",null,{"$f":"SUM(G50+G43+G36+G9)*0.07","v":0}]
[null,null,null,"Итого:",null,{"$f":"SUM(F53+F54+F55)","v":0}]
[null,null,null,"Итого стоимость заказа:",null,{"$f":"SUM(F56+G50+G43+G36+G9)","v":0}]