{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sheet1","сверхурочка","база","расчет"],"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":"Sheet1","index":0,"n_rows":63,"n_cols":27,"rows_kept":63,"cut":false,"hidden":true,"merged":[[0,6,0,11],[21,6,21,11],[32,6,32,11]]}
[null,null,null,null,null,null,"технологическая карта",null,null,null,null,null,null,"изд",1,null,null,"партия","4-21"]
[null,null,null,null,null,null,null,null,null,"август",null,2021]
[null,"коэф","Ф. И. О.","р/р",2,3,4,5,6,9,10,11,12,13,16,17,18,19,20,23,24,25,26,27,30,31]
[null,null,"работник6","3/16",null,null,null,null,1,null,null,1,4,3.2,2,1.2,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E4:Z4)","v":12.399999999999999}]
[null,null,"работник7",null,null,null,null,null,null,null,7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2]
[null,null,"работник1",null,6.7,null,null,null,4.7,null,null,null,null,null,6.7,2,null,null,null,null,null,null,null,null,null,null,20.100000000000001]
[null,null,"работник8",null,7.2,null,7.2,5,4.2,7.2,7.2,6.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44.2]
[null,null,"работник9",null,7.2,7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.4]
[null,null,"работник3",null,null,2.6,null,7.2,null,null,7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,"работник10",null,null,null,null,7.2,7.2,4,4,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24.4]
[null,null,"работник10",null,null,null,null,null,null,null,null,7.2,7.2,7.2,7.2,null,null,null,null,null,null,null,null,null,null,null,28.8]
[null,null,"работник5",null,null,null,null,null,null,null,4,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[null,null,"работник11",null,null,null,null,null,null,7.2,7.2,null,7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,21.6]
[null,null,"работник2",null,null,null,null,2.2000000000000002,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.2000000000000002]
[null,null,"работник4",null,7.2,7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.4]
[]
[null,1.1000000000000001,"работник5","3/16",7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2]
[null,1.1000000000000001,"работник2",null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,{"$f":"SUM(E4:E18)","v":35.5},17,9.1999999999999993,21.599999999999998,17.100000000000001,18.399999999999999,36.800000000000004,16.399999999999999,22.4,10.4,15.899999999999999,3.2,0,0,0,0,0,0,0,0,0,0,223.9]
[]
[]
[null,null,null,null,null,null,"технологическая карта",null,null,null,null,null,null,"изд",2,null,null,"партия","33-21"]
[null,null,null,null,null,null,null,null,null,"август",null,2021]
[null,"коэф","Ф. И. О.","р/р",2,3,4,5,6,9,10,11,12,13,16,17,18,19,20,23,24,25,26,27,30,31]
[null,null,"работник6","3/16",null,null,null,null,null,null,null,null,2,4,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:Z25)","v":6}]
[null,null,"работник10",null,null,null,null,null,null,null,null,null,null,7.2,7.2,null,null,null,null,null,null,null,null,null,null,null,14.4]
[null,null,"работник11",null,null,null,null,null,null,null,null,7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2]
[null,null,"работник3",null,3.2,4.5999999999999996,2.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E28:Z28)","v":10.6}]
[null,null,"работник8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2,null,null,null,null,null,null,null,7.2]
[null,null,"работник9",null,null,null,7.2,7.2,7.2,7.2,7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,{"$f":"SUM(E25:E30)","v":3.2},4.5999999999999996,10,7.2,7.2,7.2,7.2,7.2,2,11.2,7.2,0,0,0,7.2,0,0,0,0,0,0,0,{"$f":"SUM(AA25:AA30)","v":81.400000000000006}]
[]
[null,null,null,null,null,null,"технологическая карта",null,null,null,null,null,null,"изд",3,null,null,"партия","27-21"]
[null,null,null,null,null,null,null,null,null,"август",null,2021]
[null,"коэф","Ф. И. О.","р/р",2,3,4,5,6,9,10,11,12,13,16,17,18,19,20,23,24,25,26,27,30,31]
[null,null,"работник3","2/4",null,null,null,null,2.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E36:Z36)","v":2.8}]
[null,null,"работник7",null,null,null,null,null,null,null,null,null,null,null,null,null,7.2,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E37:Z37)","v":7.2}]
[]
[null,null,"работник7","3/4",3.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E39:Z39)","v":3.2}]
[null,null,"работник12",null,4,4,4,4,null,null,null,null,null,7,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E40:Z40)","v":23}]
[null,null,"работник2",null,null,null,null,null,null,4.2,null,null,null,null,null,null,2.2000000000000002,null,7.2,null,7.2,null,3.6,null,null,null,{"$f":"SUM(E41:Z41)","v":24.400000000000002}]
[null,null,"работник13",null,null,null,null,null,null,null,null,null,null,null,null,1.2,null,null,null,null,null,null,null,null,null,null,1.2]
[]
[null,null,"работник2","3/16",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.8,null,null,3.6,7.2,null,null,12.600000000000001]
[null,null,"работник1",null,null,null,null,null,null,null,null,null,null,null,null,4.7,6.7,2,null,null,3,null,null,5.7,6.7,6.7,35.5]
[null,null,"работник10",null,7.2,7.2,7.2,null,null,null,null,null,null,null,null,7.2,7.2,null,null,null,null,null,null,null,null,null,36]
[null,null,"работник11",null,null,7.2,null,7.2,7.2,null,null,null,null,null,7.2,7.2,null,null,null,null,7.2,7.2,null,null,null,null,50.400000000000006]
[null,null,"работник9",null,null,null,null,null,null,null,null,7.2,7.2,7.2,7.2,7.2,7.2,7.2,7.2,null,null,null,null,null,null,null,57.600000000000009]
[null,null,"работник3",null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,null,"работник12",null,3,3,3,3,null,null,3,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,"работник5",null,null,null,null,null,null,null,2.2000000000000002,null,2.2000000000000002,null,4.2,null,null,null,3.2,null,null,null,null,null,null,null,11.8]
[null,null,"работник13",null,null,null,null,null,null,null,null,null,null,7.2,7.2,6,null,null,null,null,null,null,null,null,null,null,20.399999999999999]
[null,null,"работник14",null,null,null,null,null,null,null,null,null,null,null,null,null,null,6.7,6.7,null,null,null,null,null,null,null,13.4]
[null,null,"работник15",null,7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2]
[null,null,"работник6",null,null,7.2,null,7.2,2,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,null,18.399999999999999]
[null,null,"работник4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2,7.2,14.4]
[]
[null,1.5,"работник7","4/8",4,7.2,7.2,7.2,7.2,null,null,null,null,null,null,null,null,7.2,7.2,null,null,null,null,null,null,null,47.2]
[]
[null,1.1000000000000001,"работник5","3/16",null,null,null,null,null,4.2,null,4.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.4]
[null,1.1000000000000001,"работник2",null,null,null,5.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.2,null,null,null,null,12.4]
[null,1.1000000000000001,"работник11",null,7.2,null,7.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.4]
[null,null,null,null,{"$f":"SUM(E36:E62)","v":39.799999999999997},{"$f":"SUM(F36:F62)","v":35.799999999999997},33.799999999999997,28.599999999999998,19.2,8.4,5.2,14.399999999999999,9.4,21.4,25.8,33.5,32.5,23.099999999999998,31.5,1.8,17.399999999999999,14.4,7.2,12.9,13.9,13.9,{"$f":"SUM(AA36:AA62)","v":443.89999999999986}]

{"sheet":"сверхурочка","index":1,"n_rows":16,"n_cols":39,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["месяц","год","изд","партия","коэф","Ф. И. О.","р/р","1","2","3","4","5","6","7","8","9","10","11","12","13","14","15","16","17","18","19","20","21","22","23","24","25","26","27","28","29","30","31","сумма"]
["Декабрь",2021,8,"4-21",1,"работник1","3/16",null,null,null,null,null,null,null,3,2,null,null,null,4,null,null,4,3.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":16.8}]
["Декабрь",2021,61,"42-21",1,"работник3","3/16",null,null,null,null,null,null,null,null,3,null,null,null,4,null,4,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":15}]
["Декабрь",2021,61,"42-21",1,"работник4","3/16",null,null,null,null,null,null,null,4,3,4,null,null,4,null,4,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":23}]
["Декабрь",2021,1,"10-21","1.5","работник6","4/8",null,null,null,null,null,null,null,2,null,4,null,null,null,null,4,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":14}]
["Декабрь",2021,6,"45-21",1,"работник7","3/16",null,null,null,null,null,null,null,2,null,2,null,null,null,null,4,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":11}]
["Декабрь",2021,8,"4-21",1,"работник8","3/24",null,null,null,null,null,null,null,2,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":6}]
["Декабрь",2021,61,"42-21",1,"работник9","3/16",null,null,null,null,null,null,null,2,null,null,null,null,null,4,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":10}]
["Декабрь",2021,61,"42-21",1,"работник10","3/16",null,null,null,null,null,null,null,2,4,null,null,null,null,4,2,null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":13.5}]
["Декабрь",2021,61,"42-21","1.1","работник11","3/24",null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,4,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":12}]
["Декабрь",2021,61,"43-21",1,"работник12","3/16",null,null,null,null,null,null,null,2,4,null,null,null,null,4,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":14}]
["Декабрь",2021,61,"43-21",1,"работник13","3/16",null,null,null,null,null,null,null,2,4,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":10}]
["Декабрь",2021,61,"45-21",1,"работник14","3/4",null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":8}]
["Декабрь",2021,61,"43-22",1,"работник6","3/16",null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":8}]
["Декабрь",2021,61,"45-22",1,"работник6","3/4",null,null,null,null,null,null,null,null,null,null,null,null,4,null,null,null,null,null,null,4,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":8}]
["Декабрь",2021,61,"45-22","1.1","работник6","3/24",null,null,null,null,null,null,null,null,null,null,null,null,null,3.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Таблица18[[#This Row],[1]:[30]])","v":3.5}]

{"sheet":"база","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
["партия","Ф. И. О.","р/р","разряд","Таб №",null,"Разряд работы","Стоимость","4%","8%","12%","16%","24%"]
["41-21","работник1","3/16",3,15118,null,1,5,25.49,30.31,35.14,39.97,49.62]
["42-21","работник2","2/4",3,15791,null,2,10,36.78,42.04,47.3,52.56,63.08]
["43-21","работник3","3/4",3,15117,null,3,20,51.84,57.68,63.52,69.36,81.040000000000006]
["44-21","работник4","4/8",3,15043,null,4,30,66.900000000000006,73.319999999999993,79.739999999999995,86.16,99]
["45-21","работник5","3/24",3,15001,null,5,40,88.24,95.48,2.72,9.9600000000000009,24.44]
["1-22","работник6","4/24",3,15894,null,6,50,14.58,22.84,31.09,39.340000000000003,55.85]
["4-21","работник7","4/16",3,15590]
["9-21","работник8",null,3,15340]
["10-21","работник9",null,3,15608]
["п/ф-21","работник10",null,4,13676]
[null,"работник11",null,3,15575]
[null,"работник12",null,3,14883]
[null,"работник13",null,3,15041]
[null,"работник14",null,3,15556]
[null,"работник15",null,3,15589]
[null,"работник16",null,3,15098]
[null,"работник17",null,3,15237]
[null,"работник18",null,3,14693]
[null,"работник19",null,3,14988]
[null,"работник20",null,4,15889]
[null,"работник21",null,3,"16889"]
[null,"работник22",null,3,13897]
[null,"Джеймс Бонд",null,2,"007"]

{"sheet":"расчет","index":3,"n_rows":12,"n_cols":27,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,26],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,3,7],[3,8,3,11],[3,12,3,15],[3,16,3,19],[3,20,3,23],[3,24,4,24],[3,25,4,25],[3,26,4,26],[5,26,8,26],[5,0,8,0],[5,2,8,2],[5,3,8,3],[5,24,8,24],[5,25,8,25]]}
["производств уч. № 1"]
[null,null,null,null,null,null,null,null,null,"ЗП",null,"декабрь",null,null,null,null,null,null,null,2021]
[null,null,null,null,null,null,null,null,null,null,"СВЕРХУРОЧНАЯ РАБОТА"]
[null,"ФИО","Табельный номер","разряд работника",0.04,null,null,null,0.08,null,null,null,0.12,null,null,null,0.16,null,null,null,0.24,null,null,null,"итого часы","итого сумма, руб ","подпись работник "]
[null,null,null,null,"тариф","коэффициент","часы","сумма","тариф","коэффициент","часы","сумма","тариф","коэффициент","часы","сумма","тариф","коэффициент","часы","сумма","тариф","коэффициент","часы","сумма"]
[1,null,{"$f":"INDEX(база!E2:E24, MATCH(B7,база!B2:B24,0))","v":15894},{"$f":"INDEX(база!D2:D24, MATCH(B7,база!B2:B24,0))","v":3},{"$f":"IF(D6<=3,база!I4,база!I5)","v":51.84},1,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1\",Таблица18[р/р],\"2/4\",Таблица18[Ф. И. О.],B7)","v":0},{"$f":"SUM(IFERROR(--TEXT(MMULT(TRANSPOSE(Таблица18[[1]:[30]]*(Таблица18[Ф. И. О.]=$B7)*(Таблица18[р/р]=расчет!$D6&\"/\"&TRUNC(расчет!E4*100))),Таблица18[год]^0*2)-1,\"0;\\0;\\0\"),))*E6*F6","v":725.76},{"$f":"IF(D6<=3,база!J4,база!J5)","v":57.68},1,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1\",Таблица18[р/р],\"2/8\",Таблица18[Ф. И. О.],B7)","v":0},{"$f":"SUM(IFERROR(--TEXT(MMULT(TRANSPOSE(Таблица18[[1]:[30]]*(Таблица18[Ф. И. О.]=$B7)*(Таблица18[р/р]=расчет!$D6&\"/\"&TRUNC(расчет!I4*100))),Таблица18[год]^0*2)-1,\"0;\\0;\\0\"),))*I6*J6","v":0},null,1,{"$f":"SUMIFS(#REF!,#REF!,\"1\",#REF!,\"3/12\",#REF!,B7)","v":{"$error":"#REF!"}},{"$f":"ROUND(M6*N6*O6,2)","v":{"$error":"#REF!"}},{"$f":"IF(D6<=3,база!L4,база!L5)","v":69.36},1,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1\",Таблица18[р/р],\"3/16\",Таблица18[Ф. И. О.],B7)","v":8},{"$f":"SUM(IFERROR(--TEXT(MMULT(TRANSPOSE(Таблица18[[1]:[30]]*(Таблица18[Ф. И. О.]=$B7)*(Таблица18[р/р]=расчет!$D6&\"/\"&TRUNC(расчет!Q4*100))),Таблица18[год]^0*2)-1,\"0;\\0;\\0\"),))*Q6*R6","v":971.04},{"$f":"IF(D6<=3,база!M4,база!M5)","v":81.040000000000006},1,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1\",Таблица18[р/р],\"3/24\",Таблица18[Ф. И. О.],B7)","v":0},{"$f":"SUM(IFERROR(--TEXT(MMULT(TRANSPOSE(Таблица18[[1]:[30]]*(Таблица18[Ф. И. О.]=$B7)*(Таблица18[р/р]=расчет!$D6&\"/\"&TRUNC(расчет!U4*100))),Таблица18[год]^0*2)-1,\"0;\\0;\\0\"),))*U6*V6","v":486.24},{"$f":"SUM(W6:W9,S6:S9,K6:K9,G6:G9)","v":33.5},{"$f":"SUM(H6:H9,L6:L9,T6:T9,X6:X9)","v":4709.04}]
[null,"работник6",null,null,{"$f":"IF(D6<=3,база!I4,база!I5)","v":51.84},1,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1\",Таблица18[р/р],\"3/4\",Таблица18[Ф. И. О.],B7)","v":8},{"$f":"SUM(IFERROR(--TEXT(MMULT(TRANSPOSE(Таблица18[[1]:[30]]*(Таблица18[Ф. И. О.]=$B7)*(Таблица18[р/р]=расчет!$D6&\"/\"&TRUNC(расчет!E4*100))),Таблица18[год]^0*2)-1,\"0;\\0;\\0\"),))*E7*F7","v":725.76},{"$f":"IF(D6<=3,база!J4,база!J5)","v":57.68},1,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1\",Таблица18[р/р],\"3/8\",Таблица18[Ф. И. О.],B7)","v":0},{"$f":"SUM(IFERROR(--TEXT(MMULT(TRANSPOSE(Таблица18[[1]:[30]]*(Таблица18[Ф. И. О.]=$B7)*(Таблица18[р/р]=расчет!$D6&\"/\"&TRUNC(расчет!I4*100))),Таблица18[год]^0*2)-1,\"0;\\0;\\0\"),))*I7*J7","v":0},null,1,{"$f":"SUMIFS(#REF!,#REF!,\"1\",#REF!,\"4/12\",#REF!,B7)","v":{"$error":"#REF!"}},{"$f":"ROUND(M7*O7,2)","v":{"$error":"#REF!"}},{"$f":"база!L5","v":86.16},1,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[р/р],\"4/16\",Таблица18[коэф],\"1\",Таблица18[Ф. И. О.],B7)","v":0},{"$f":"SUM(IFERROR(--TEXT(MMULT(TRANSPOSE(Таблица18[[1]:[30]]*(Таблица18[Ф. И. О.]=$B7)*(Таблица18[р/р]=расчет!$D6&\"/\"&TRUNC(расчет!Q4*100))),Таблица18[год]^0*2)-1,\"0;\\0;\\0\"),))*Q7*R7","v":1206.24},{"$f":"база!M5","v":99},1,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1\",Таблица18[р/р],\"4/24\",Таблица18[Ф. И. О.],B7)","v":0},{"$f":"SUM(IFERROR(--TEXT(MMULT(TRANSPOSE(Таблица18[[1]:[30]]*(Таблица18[Ф. И. О.]=$B7)*(Таблица18[р/р]=расчет!$D6&\"/\"&TRUNC(расчет!U4*100))),Таблица18[год]^0*2)-1,\"0;\\0;\\0\"),))*U7*V7","v":594}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,{"$f":"SUMIFS(#REF!,#REF!,\"1.1\",#REF!,\"3/12\",#REF!,B7)","v":{"$error":"#REF!"}},{"$f":"ROUND(M8*N8*O8,2)","v":{"$error":"#REF!"}},{"$f":"база!L4","v":69.36},1.1000000000000001,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[р/р],\"3/16\",Таблица18[коэф],\"1.1\",Таблица18[Ф. И. О.],B7)","v":0},{"$f":"ROUND(Q8*R8*S8,2)","v":0},{"$f":"база!M4","v":81.040000000000006},1.1000000000000001,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1.1\",Таблица18[р/р],\"3/24\",Таблица18[Ф. И. О.],B7)","v":3.5}]
[null,null,null,null,null,1.5,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1.5\",Таблица18[р/р],\"2/4\",Таблица18[Ф. И. О.],B7)","v":0},null,{"$f":"база!J5","v":73.319999999999993},1.5,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1.5\",Таблица18[р/р],\"4/8\",Таблица18[Ф. И. О.],B7)","v":14},null,null,1.5,{"$f":"SUMIFS(#REF!,#REF!,\"1.5\",#REF!,\"3/12\",#REF!,B7)","v":{"$error":"#REF!"}},{"$f":"ROUND(M9*N9*O9,2)","v":{"$error":"#REF!"}},{"$f":"база!L4","v":69.36},1.5,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[р/р],\"3/16\",Таблица18[коэф],\"1.5\",Таблица18[Ф. И. О.],B7)","v":0},0,{"$f":"база!M4","v":81.040000000000006},1.5,{"$f":"SUMIFS(Таблица18[сумма],Таблица18[коэф],\"1.5\",Таблица18[р/р],\"3/24\",Таблица18[Ф. И. О.],B7)","v":0}]
[]
[null,"значение в ячейке \"СУММА\" =сумма первых двух часов одного дня, помноженная*1.5 *на тариф *на коэф (Q*R*2 часа*1.5)+ сумма оставшегося времени в этот же день,умноженная на два  на тариф и коэф(Q*R*оставшееся время*2)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"+ второй день+третий день…и так далее\""]