{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Данные","Лист1"],"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":27,"n_cols":25,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,17,2,29],[3,17,4,29],[5,17,6,29],[7,17,7,29],[26,11,26,12],[13,11,13,12],[14,11,14,12],[15,11,15,12],[23,11,23,12],[24,11,24,12],[20,11,20,12],[21,11,21,12],[22,11,22,12],[25,11,25,12],[16,11,16,12],[17,11,17,12],[0,0,0,3],[1,0,1,3],[2,0,2,3],[3,0,3,3],[4,0,4,3],[0,4,0,7],[1,4,1,7],[2,4,2,7],[3,4,3,7],[4,4,4,7],[6,10,6,11],[6,8,6,9],[10,15,10,24],[5,0,5,3],[6,0,6,3],[7,0,7,3],[7,4,7,5],[6,12,6,13],[8,0,8,5],[5,7,5,13],[11,15,11,17],[11,18,11,20],[11,21,11,24],[11,13,12,13],[11,11,12,12],[11,0,12,0],[11,1,12,1],[11,2,11,4],[11,5,11,7],[11,8,11,10],[18,11,18,12],[19,11,19,12]]}
[]
[]
[]
[]
[null,null,null,null,{"$f":"\"с \"&TEXT(MIN(B14:B193),\"ДД.ММ.ГГГГ\")&\" по \"&TEXT(MAX(B14:B193),\"ДД.ММ.ГГГГ\")&\" гг.\"","v":"с 12.01.2018 по 12.01.2018 гг."}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(1.128*$B$10,2)","v":0},"R ср = ",{"$f":"ROUND(0.84*1.128*$D$10,2)","v":0},"K ср = ",0]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(2.834*$B$10,2)","v":0},"R пр = ",{"$f":"ROUND(0.84*2.834*$D$10,2)","v":0},"K пр =",{"$f":"ROUND(0.84*$F$10,2)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(3.686*$B$10,2)","v":0},"R д =",{"$f":"ROUND(0.84*3.686*$D$10,2)","v":0},"K д =",{"$f":"ROUND(0.84*1.5*$F$10,2)","v":0}]
["."]
["№ ","Дата","Результаты ",null,null,null,null,null,null,null,null,null,null,"Оператор"]
[null,null,"Х1","Х2","Хср"]
[1,null,null,null,{"$f":"ROUND(AVERAGE(C14:D14),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C14:D14)-MIN(C14:D14)","v":0},0,{"$f":"E14-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F14>$J$10,\"сверх ПД\",IF(F14>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G14>$L$10,\"сверх ПД\",IF(G14>$L$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(H14>$N$10,\"сверх ПД\",IF(H14>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[2,null,null,null,{"$f":"ROUND(AVERAGE(C15:D15),2)","v":{"$error":"#DIV/0!"}},0,{"$f":"ABS(E15-E14)","v":{"$error":"#DIV/0!"}},{"$f":"E15-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F15>$J$10,\"сверх ПД\",IF(F15>$J$9,\"сверх ПП\",\"\"))","v":""},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3,null,null,null,{"$f":"ROUND(AVERAGE(C16:D16),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C16:D16)-MIN(C16:D16)","v":0},{"$f":"ABS(E16-E15)","v":{"$error":"#DIV/0!"}},{"$f":"E16-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F16>$J$10,\"сверх ПД\",IF(F16>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G16>$L$10,\"сверх ПД\",IF(G16>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H16>$N$10,\"сверх ПД\",IF(H16>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[4,null,null,null,{"$f":"ROUND(AVERAGE(C17:D17),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C17:D17)-MIN(C17:D17)","v":0},{"$f":"ABS(E17-E16)","v":{"$error":"#DIV/0!"}},{"$f":"E17-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F17>$J$10,\"сверх ПД\",IF(F17>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G17>$L$10,\"сверх ПД\",IF(G17>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H17>$N$10,\"сверх ПД\",IF(H17>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[5,"2018-01-12",123,654,{"$f":"ROUND(AVERAGE(C18:D18),2)","v":388.5},{"$f":"MAX(C18:D18)-MIN(C18:D18)","v":531},{"$f":"ABS(E18-E17)","v":{"$error":"#DIV/0!"}},{"$f":"E18-$F$6","v":388.5},{"$f":"IF(F18>$J$10,\"сверх ПД\",IF(F18>$J$9,\"сверх ПП\",\"\"))","v":"сверх ПД"},{"$f":"IF(G18>$L$10,\"сверх ПД\",IF(G18>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H18>$N$10,\"сверх ПД\",IF(H18>$N$9,\"сверх ПП\",\"\"))","v":"сверх ПД"}]
[6,null,null,null,{"$f":"ROUND(AVERAGE(C19:D19),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C19:D19)-MIN(C19:D19)","v":0},{"$f":"ABS(E19-E18)","v":{"$error":"#DIV/0!"}},{"$f":"E19-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F19>$J$10,\"сверх ПД\",IF(F19>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G19>$L$10,\"сверх ПД\",IF(G19>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H19>$N$10,\"сверх ПД\",IF(H19>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[7,null,null,null,{"$f":"ROUND(AVERAGE(C20:D20),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C20:D20)-MIN(C20:D20)","v":0},{"$f":"ABS(E20-E19)","v":{"$error":"#DIV/0!"}},{"$f":"E20-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F20>$J$10,\"сверх ПД\",IF(F20>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G20>$L$10,\"сверх ПД\",IF(G20>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H20>$N$10,\"сверх ПД\",IF(H20>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[8,null,null,null,{"$f":"ROUND(AVERAGE(C21:D21),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C21:D21)-MIN(C21:D21)","v":0},{"$f":"ABS(E21-E20)","v":{"$error":"#DIV/0!"}},{"$f":"E21-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F21>$J$10,\"сверх ПД\",IF(F21>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G21>$L$10,\"сверх ПД\",IF(G21>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H21>$N$10,\"сверх ПД\",IF(H21>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[9,null,null,null,{"$f":"ROUND(AVERAGE(C22:D22),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C22:D22)-MIN(C22:D22)","v":0},{"$f":"ABS(E22-E21)","v":{"$error":"#DIV/0!"}},{"$f":"E22-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F22>$J$10,\"сверх ПД\",IF(F22>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G22>$L$10,\"сверх ПД\",IF(G22>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H22>$N$10,\"сверх ПД\",IF(H22>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[10,null,null,null,{"$f":"ROUND(AVERAGE(C23:D23),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C23:D23)-MIN(C23:D23)","v":0},{"$f":"ABS(E23-E22)","v":{"$error":"#DIV/0!"}},{"$f":"E23-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F23>$J$10,\"сверх ПД\",IF(F23>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G23>$L$10,\"сверх ПД\",IF(G23>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H23>$N$10,\"сверх ПД\",IF(H23>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[11,null,null,null,{"$f":"ROUND(AVERAGE(C24:D24),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C24:D24)-MIN(C24:D24)","v":0},{"$f":"ABS(E24-E23)","v":{"$error":"#DIV/0!"}},{"$f":"E24-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F24>$J$10,\"сверх ПД\",IF(F24>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G24>$L$10,\"сверх ПД\",IF(G24>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H24>$N$10,\"сверх ПД\",IF(H24>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[12,null,null,null,{"$f":"ROUND(AVERAGE(C25:D25),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C25:D25)-MIN(C25:D25)","v":0},{"$f":"ABS(E25-E24)","v":{"$error":"#DIV/0!"}},{"$f":"E25-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F25>$J$10,\"сверх ПД\",IF(F25>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G25>$L$10,\"сверх ПД\",IF(G25>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H25>$N$10,\"сверх ПД\",IF(H25>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[13,null,null,null,{"$f":"ROUND(AVERAGE(C26:D26),2)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(C26:D26)-MIN(C26:D26)","v":0},{"$f":"ABS(E26-E25)","v":{"$error":"#DIV/0!"}},{"$f":"E26-$F$6","v":{"$error":"#DIV/0!"}},{"$f":"IF(F26>$J$10,\"сверх ПД\",IF(F26>$J$9,\"сверх ПП\",\"\"))","v":""},{"$f":"IF(G26>$L$10,\"сверх ПД\",IF(G26>$L$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H26>$N$10,\"сверх ПД\",IF(H26>$N$9,\"сверх ПП\",\"\"))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$J$8","v":0},{"$f":"$J$9","v":0},{"$f":"$J$10","v":0},{"$f":"$L$8","v":0},{"$f":"$L$9","v":0},{"$f":"$L$10","v":0},{"$f":"$N$9","v":0},{"$f":"0-V27","v":0},{"$f":"$N$10","v":0},{"$f":"0-X27","v":0}]

{"sheet":"Лист1","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,0.5,0.6]
[null,null,0.65,0.55000000000000004]
[]
[null,null,123,654]