{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Калькуляция","спр"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,1,2,4],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[13,1,13,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3]]}
["КАЛЬКУЛЯЦИЯ"]
[]
["Адрес"]
["№","Наименование  затрат","ед.изм.","к-во","Сумма (руб)"]
["п/п"]
[1,"Трудозатраты",null,null,"Х",null,null,null,null,null,null,null,null,{"$f":"B6","v":"Трудозатраты"}]
[2,"Материалы",null,null,{"$f":"SUMIFS(E:E,O:O,\"Материалы\")","v":0},null,null,null,null,null,null,null,null,{"$f":"B7","v":"Материалы"}]
[3,"Заработная плата сотрудников",null,null,{"$f":"SUMIFS(E:E,O:O,\"Заработная плата сотрудников\")","v":0},null,null,null,null,null,null,null,null,"Заработная плата сотрудников"]
[4,"Единый социальный налог",null,null,{"$f":"SumZP*0.302","v":0}]
[5,"Итого затраты",null,null,{"$f":"SumMat+SumZP+ESN","v":0}]
[6,"Рентабельность",null,null,{"$f":"E10*0.1","v":0}]
[7,"Итого",null,null,{"$f":"SUM(E10:E11)","v":0}]
[8,"НДС",null,null,{"$f":"E12*0.2","v":0}]
[9,"Всего выполнено работ на сумму",null,null,{"$f":"SUM(E12:E13)","v":0}]

{"sheet":"спр","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Должность","Часовая ставка","Коэф.","Ставка для калькуляции",null,null,null,"ед.изм."]
["электрик 4р",121.83,{"$f":"1.4*1.1","v":1.54},{"$f":"B2*C2","v":187.6182},null,null,null,"кг."]
["слесарь 4р ",81.22,{"$f":"1.4*1.5*1.1","v":2.3099999999999996},{"$f":"B3*C3","v":187.61819999999997},null,null,null,"м."]
["электрогазосварщик 4 р",null,null,1600,null,null,null,"м2"]
["плотник 3р ",null,null,null,null,null,null,"м3"]
[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,"шт."]