{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["3_15","4_15","СТАТИСТИКА"],"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":"3_15","index":0,"n_rows":50,"n_cols":14,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,8],[0,9,0,11]]}
[null,null,null,null,null,null,null,null,null,3]
[{"$f":"IF(C2>0,1, 0)","v":1},{"$f":"IF(AND(A2=0,C2>1),\"ПОМИЛКА\",IF(AND(F2=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",149,{"$f":"IF(D2=0,\" \",IF(IFERROR((VLOOKUP(D2,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D2,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D2,#REF!,3,0))<90,#REF!-(VLOOKUP(D2,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D2,#REF!,4,0))>0,(VLOOKUP(D2,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"10:09:00","10:20:00",{"$f":"IF(AND(J2>0,K2=0),#REF!-J2,IF((K2-J2)<0,\"ПОМИЛКА\",K2-J2))","v":"00:11:00"},{"$f":"IF(F2=0,0,IF(N2=0,0,IF(N2<0.041666667,0,IF(L2=0,0,IF(H2=\"р\",0,N2-0.041666667)*72-SUMIFS($M1:M$2,$C1:C$2,C2,$D1:D$2,D2)))))","v":0},{"$f":"SUMIFS($L$2:L2,$C$2:C2,C2,$D$2:D2,D2)","v":"00:11:00"}]
[{"$f":"IF(AND(A2=1, C3>0), SUM(A2+1), 0)","v":2},{"$f":"IF(AND(A3=0,C3>1),\"ПОМИЛКА\",IF(AND(F3=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",101,{"$f":"IF(D3=0,\" \",IF(IFERROR((VLOOKUP(D3,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D3,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D3,#REF!,3,0))<90,#REF!-(VLOOKUP(D3,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,null,"10:20:00","11:20:00",{"$f":"IF(AND(J3>0,K3=0),#REF!-J3,IF((K3-J3)<0,\"ПОМИЛКА\",K3-J3))","v":"01:00:00"},{"$f":"IF(F3=0,0,IF(N3=0,0,IF(N3<0.041666667,0,IF(L3=0,0,IF(H3=\"р\",0,N3-0.041666667)*72-SUMIFS($M$2:M2,$C$2:C2,C3,$D$2:D2,D3)))))","v":0},{"$f":"SUMIFS($L$2:L3,$C$2:C3,C3,$D$2:D3,D3)","v":"01:00:00"}]
[{"$f":"IF(AND(A3-A2=1, C4>0), SUM(A3+1), 0)","v":3},{"$f":"IF(AND(A4=0,C4>1),\"ПОМИЛКА\",IF(AND(F4=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",103,{"$f":"IF(D4=0,\" \",IF(IFERROR((VLOOKUP(D4,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D4,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},4,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D4,#REF!,3,0))<90,#REF!-(VLOOKUP(D4,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D4,#REF!,4,0))>0,(VLOOKUP(D4,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"10:20:00","11:20:00",{"$f":"IF(AND(J4>0,K4=0),#REF!-J4,IF((K4-J4)<0,\"ПОМИЛКА\",K4-J4))","v":"01:00:00"},{"$f":"IF(F4=0,0,IF(N4=0,0,IF(N4<0.041666667,0,IF(L4=0,0,IF(H4=\"р\",0,N4-0.041666667)*72-SUMIFS($M$2:M3,$C$2:C3,C4,$D$2:D3,D4)))))","v":0},{"$f":"SUMIFS($L$2:L4,$C$2:C4,C4,$D$2:D4,D4)","v":"01:00:00"}]
[4,{"$f":"IF(AND(A5=0,C5>1),\"ПОМИЛКА\",IF(AND(F5=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",24,{"$f":"IF(D5=0,\" \",IF(IFERROR((VLOOKUP(D5,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D5,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D5,#REF!,3,0))<90,#REF!-(VLOOKUP(D5,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D5,#REF!,4,0))>0,(VLOOKUP(D5,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"10:38:00","11:38:00",{"$f":"IF(AND(J5>0,K5=0),#REF!-J5,IF((K5-J5)<0,\"ПОМИЛКА\",K5-J5))","v":"01:00:00"},{"$f":"IF(F5=0,0,IF(N5=0,0,IF(N5<0.041666667,0,IF(L5=0,0,IF(H5=\"р\",0,N5-0.041666667)*72-SUMIFS($M$2:M4,$C$2:C4,C5,$D$2:D4,D5)))))","v":0},{"$f":"SUMIFS($L$2:L5,$C$2:C5,C5,$D$2:D5,D5)","v":"01:00:00"}]
[5,{"$f":"IF(AND(A6=0,C6>1),\"ПОМИЛКА\",IF(AND(F6=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",135,{"$f":"IF(D6=0,\" \",IF(IFERROR((VLOOKUP(D6,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D6,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D6,#REF!,3,0))<90,#REF!-(VLOOKUP(D6,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D6,#REF!,4,0))>0,(VLOOKUP(D6,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"10:50:00","11:50:00",{"$f":"IF(AND(J6>0,K6=0),#REF!-J6,IF((K6-J6)<0,\"ПОМИЛКА\",K6-J6))","v":"01:00:00"},{"$f":"IF(F6=0,0,IF(N6=0,0,IF(N6<0.041666667,0,IF(L6=0,0,IF(H6=\"р\",0,N6-0.041666667)*72-SUMIFS($M$2:M5,$C$2:C5,C6,$D$2:D5,D6)))))","v":0},{"$f":"SUMIFS($L$2:L6,$C$2:C6,C6,$D$2:D6,D6)","v":"01:00:00"}]
[6,{"$f":"IF(AND(A7=0,C7>1),\"ПОМИЛКА\",IF(AND(F7=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",85,{"$f":"IF(D7=0,\" \",IF(IFERROR((VLOOKUP(D7,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D7,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},2,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D7,#REF!,3,0))<90,#REF!-(VLOOKUP(D7,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D7,#REF!,4,0))>0,(VLOOKUP(D7,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"10:55:00","11:55:00",{"$f":"IF(AND(J7>0,K7=0),#REF!-J7,IF((K7-J7)<0,\"ПОМИЛКА\",K7-J7))","v":"01:00:00"},{"$f":"IF(F7=0,0,IF(N7=0,0,IF(N7<0.041666667,0,IF(L7=0,0,IF(H7=\"р\",0,N7-0.041666667)*72-SUMIFS($M$2:M6,$C$2:C6,C7,$D$2:D6,D7)))))","v":0},{"$f":"SUMIFS($L$2:L7,$C$2:C7,C7,$D$2:D7,D7)","v":"01:00:00"}]
[7,{"$f":"IF(AND(A8=0,C8>1),\"ПОМИЛКА\",IF(AND(F8=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",81,{"$f":"IF(D8=0,\" \",IF(IFERROR((VLOOKUP(D8,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D8,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},6,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D8,#REF!,3,0))<90,#REF!-(VLOOKUP(D8,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D8,#REF!,4,0))>0,(VLOOKUP(D8,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:01:00","12:01:00",{"$f":"IF(AND(J8>0,K8=0),#REF!-J8,IF((K8-J8)<0,\"ПОМИЛКА\",K8-J8))","v":"01:00:00"},{"$f":"IF(F8=0,0,IF(N8=0,0,IF(N8<0.041666667,0,IF(L8=0,0,IF(H8=\"р\",0,N8-0.041666667)*72-SUMIFS($M$2:M7,$C$2:C7,C8,$D$2:D7,D8)))))","v":0},{"$f":"SUMIFS($L$2:L8,$C$2:C8,C8,$D$2:D8,D8)","v":"01:00:00"}]
[8,{"$f":"IF(AND(A9=0,C9>1),\"ПОМИЛКА\",IF(AND(F9=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",26,{"$f":"IF(D9=0,\" \",IF(IFERROR((VLOOKUP(D9,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D9,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D9,#REF!,3,0))<90,#REF!-(VLOOKUP(D9,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D9,#REF!,4,0))>0,(VLOOKUP(D9,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:21:00","12:41:00",{"$f":"IF(AND(J9>0,K9=0),#REF!-J9,IF((K9-J9)<0,\"ПОМИЛКА\",K9-J9))","v":"01:20:00"},{"$f":"IF(F9=0,0,IF(N9=0,0,IF(N9<0.041666667,0,IF(L9=0,0,IF(H9=\"р\",0,N9-0.041666667)*72-SUMIFS($M$2:M8,$C$2:C8,C9,$D$2:D8,D9)))))","v":1},{"$f":"SUMIFS($L$2:L9,$C$2:C9,C9,$D$2:D9,D9)","v":"01:20:00"}]
[9,{"$f":"IF(AND(A10=0,C10>1),\"ПОМИЛКА\",IF(AND(F10=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",24,{"$f":"IF(D10=0,\" \",IF(IFERROR((VLOOKUP(D10,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D10,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},0,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D10,#REF!,3,0))<90,#REF!-(VLOOKUP(D10,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D10,#REF!,4,0))>0,(VLOOKUP(D10,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:45:00","12:09:00",{"$f":"IF(AND(J10>0,K10=0),#REF!-J10,IF((K10-J10)<0,\"ПОМИЛКА\",K10-J10))","v":"00:24:00"},{"$f":"IF(F10=0,0,IF(N10=0,0,IF(N10<0.041666667,0,IF(L10=0,0,IF(H10=\"р\",0,N10-0.041666667)*72-SUMIFS($M$2:M9,$C$2:C9,C10,$D$2:D9,D10)))))","v":0},{"$f":"SUMIFS($L$2:L10,$C$2:C10,C10,$D$2:D10,D10)","v":"01:24:00"}]
[10,{"$f":"IF(AND(A11=0,C11>1),\"ПОМИЛКА\",IF(AND(F11=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",138,{"$f":"IF(D11=0,\" \",IF(IFERROR((VLOOKUP(D11,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D11,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D11,#REF!,3,0))<90,#REF!-(VLOOKUP(D11,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D11,#REF!,4,0))>0,(VLOOKUP(D11,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:52:00","12:23:00",{"$f":"IF(AND(J11>0,K11=0),#REF!-J11,IF((K11-J11)<0,\"ПОМИЛКА\",K11-J11))","v":"00:31:00"},{"$f":"IF(F11=0,0,IF(N11=0,0,IF(N11<0.041666667,0,IF(L11=0,0,IF(H11=\"р\",0,N11-0.041666667)*72-SUMIFS($M$2:M10,$C$2:C10,C11,$D$2:D10,D11)))))","v":0},{"$f":"SUMIFS($L$2:L11,$C$2:C11,C11,$D$2:D11,D11)","v":"00:31:00"}]
[11,{"$f":"IF(AND(A12=0,C12>1),\"ПОМИЛКА\",IF(AND(F12=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",144,{"$f":"IF(D12=0,\" \",IF(IFERROR((VLOOKUP(D12,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D12,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},4,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D12,#REF!,3,0))<90,#REF!-(VLOOKUP(D12,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D12,#REF!,4,0))>0,(VLOOKUP(D12,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:52:00","12:23:00",{"$f":"IF(AND(J12>0,K12=0),#REF!-J12,IF((K12-J12)<0,\"ПОМИЛКА\",K12-J12))","v":"00:31:00"},{"$f":"IF(F12=0,0,IF(N12=0,0,IF(N12<0.041666667,0,IF(L12=0,0,IF(H12=\"р\",0,N12-0.041666667)*72-SUMIFS($M$2:M11,$C$2:C11,C12,$D$2:D11,D12)))))","v":0},{"$f":"SUMIFS($L$2:L12,$C$2:C12,C12,$D$2:D12,D12)","v":"00:31:00"}]
[12,{"$f":"IF(AND(A13=0,C13>1),\"ПОМИЛКА\",IF(AND(F13=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",20,{"$f":"IF(D13=0,\" \",IF(IFERROR((VLOOKUP(D13,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D13,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},3,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D13,#REF!,3,0))<90,#REF!-(VLOOKUP(D13,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D13,#REF!,4,0))>0,(VLOOKUP(D13,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:52:00","12:23:00",{"$f":"IF(AND(J13>0,K13=0),#REF!-J13,IF((K13-J13)<0,\"ПОМИЛКА\",K13-J13))","v":"00:31:00"},{"$f":"IF(F13=0,0,IF(N13=0,0,IF(N13<0.041666667,0,IF(L13=0,0,IF(H13=\"р\",0,N13-0.041666667)*72-SUMIFS($M$2:M12,$C$2:C12,C13,$D$2:D12,D13)))))","v":0},{"$f":"SUMIFS($L$2:L13,$C$2:C13,C13,$D$2:D13,D13)","v":"00:31:00"}]
[13,{"$f":"IF(AND(A14=0,C14>1),\"ПОМИЛКА\",IF(AND(F14=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",273,{"$f":"IF(D14=0,\" \",IF(IFERROR((VLOOKUP(D14,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D14,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},5,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D14,#REF!,3,0))<90,#REF!-(VLOOKUP(D14,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D14,#REF!,4,0))>0,(VLOOKUP(D14,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:54:00","12:23:00",{"$f":"IF(AND(J14>0,K14=0),#REF!-J14,IF((K14-J14)<0,\"ПОМИЛКА\",K14-J14))","v":"00:29:00"},{"$f":"IF(F14=0,0,IF(N14=0,0,IF(N14<0.041666667,0,IF(L14=0,0,IF(H14=\"р\",0,N14-0.041666667)*72-SUMIFS($M$2:M13,$C$2:C13,C14,$D$2:D13,D14)))))","v":0},{"$f":"SUMIFS($L$2:L14,$C$2:C14,C14,$D$2:D14,D14)","v":"00:29:00"}]
[14,{"$f":"IF(AND(A15=0,C15>1),\"ПОМИЛКА\",IF(AND(F15=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",209,{"$f":"IF(D15=0,\" \",IF(IFERROR((VLOOKUP(D15,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D15,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},2,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D15,#REF!,3,0))<90,#REF!-(VLOOKUP(D15,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D15,#REF!,4,0))>0,(VLOOKUP(D15,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:58:00","12:23:00",{"$f":"IF(AND(J15>0,K15=0),#REF!-J15,IF((K15-J15)<0,\"ПОМИЛКА\",K15-J15))","v":"00:25:00"},{"$f":"IF(F15=0,0,IF(N15=0,0,IF(N15<0.041666667,0,IF(L15=0,0,IF(H15=\"р\",0,N15-0.041666667)*72-SUMIFS($M$2:M14,$C$2:C14,C15,$D$2:D14,D15)))))","v":0},{"$f":"SUMIFS($L$2:L15,$C$2:C15,C15,$D$2:D15,D15)","v":"00:25:00"}]
[15,{"$f":"IF(AND(A16=0,C16>1),\"ПОМИЛКА\",IF(AND(F16=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",87,{"$f":"IF(D16=0,\" \",IF(IFERROR((VLOOKUP(D16,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D16,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},0,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D16,#REF!,3,0))<90,#REF!-(VLOOKUP(D16,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D16,#REF!,4,0))>0,(VLOOKUP(D16,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:01:00","13:37:00",{"$f":"IF(AND(J16>0,K16=0),#REF!-J16,IF((K16-J16)<0,\"ПОМИЛКА\",K16-J16))","v":"01:36:00"},{"$f":"IF(F16=0,0,IF(N16=0,0,IF(N16<0.041666667,0,IF(L16=0,0,IF(H16=\"р\",0,N16-0.041666667)*72-SUMIFS($M$2:M15,$C$2:C15,C16,$D$2:D15,D16)))))","v":0},{"$f":"SUMIFS($L$2:L16,$C$2:C16,C16,$D$2:D16,D16)","v":"01:36:00"}]
[16,{"$f":"IF(AND(A17=0,C17>1),\"ПОМИЛКА\",IF(AND(F17=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",86,{"$f":"IF(D17=0,\" \",IF(IFERROR((VLOOKUP(D17,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D17,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},0,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D17,#REF!,3,0))<90,#REF!-(VLOOKUP(D17,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D17,#REF!,4,0))>0,(VLOOKUP(D17,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:02:00","13:37:00",{"$f":"IF(AND(J17>0,K17=0),#REF!-J17,IF((K17-J17)<0,\"ПОМИЛКА\",K17-J17))","v":"01:35:00"},{"$f":"IF(F17=0,0,IF(N17=0,0,IF(N17<0.041666667,0,IF(L17=0,0,IF(H17=\"р\",0,N17-0.041666667)*72-SUMIFS($M$2:M16,$C$2:C16,C17,$D$2:D16,D17)))))","v":0},{"$f":"SUMIFS($L$2:L17,$C$2:C17,C17,$D$2:D17,D17)","v":"01:35:00"}]
[17,{"$f":"IF(AND(A18=0,C18>1),\"ПОМИЛКА\",IF(AND(F18=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",24,{"$f":"IF(D18=0,\" \",IF(IFERROR((VLOOKUP(D18,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D18,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},10,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D18,#REF!,3,0))<90,#REF!-(VLOOKUP(D18,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D18,#REF!,4,0))>0,(VLOOKUP(D18,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:09:00","12:45:00",{"$f":"IF(AND(J18>0,K18=0),#REF!-J18,IF((K18-J18)<0,\"ПОМИЛКА\",K18-J18))","v":"00:36:00"},{"$f":"IF(F18=0,0,IF(N18=0,0,IF(N18<0.041666667,0,IF(L18=0,0,IF(H18=\"р\",0,N18-0.041666667)*72-SUMIFS($M$2:M17,$C$2:C17,C18,$D$2:D17,D18)))))","v":3},{"$f":"SUMIFS($L$2:L18,$C$2:C18,C18,$D$2:D18,D18)","v":"02:00:00"}]
[18,{"$f":"IF(AND(A19=0,C19>1),\"ПОМИЛКА\",IF(AND(F19=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",4,{"$f":"IF(D19=0,\" \",IF(IFERROR((VLOOKUP(D19,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D19,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D19,#REF!,3,0))<90,#REF!-(VLOOKUP(D19,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D19,#REF!,4,0))>0,(VLOOKUP(D19,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:25:00","13:25:00",{"$f":"IF(AND(J19>0,K19=0),#REF!-J19,IF((K19-J19)<0,\"ПОМИЛКА\",K19-J19))","v":"01:00:00"},{"$f":"IF(F19=0,0,IF(N19=0,0,IF(N19<0.041666667,0,IF(L19=0,0,IF(H19=\"р\",0,N19-0.041666667)*72-SUMIFS($M$2:M18,$C$2:C18,C19,$D$2:D18,D19)))))","v":0},{"$f":"SUMIFS($L$2:L19,$C$2:C19,C19,$D$2:D19,D19)","v":"01:00:00"}]
[19,{"$f":"IF(AND(A20=0,C20>1),\"ПОМИЛКА\",IF(AND(F20=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",18,{"$f":"IF(D20=0,\" \",IF(IFERROR((VLOOKUP(D20,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D20,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},5,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D20,#REF!,3,0))<90,#REF!-(VLOOKUP(D20,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D20,#REF!,4,0))>0,(VLOOKUP(D20,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:25:00","13:18:00",{"$f":"IF(AND(J20>0,K20=0),#REF!-J20,IF((K20-J20)<0,\"ПОМИЛКА\",K20-J20))","v":"00:53:00"},{"$f":"IF(F20=0,0,IF(N20=0,0,IF(N20<0.041666667,0,IF(L20=0,0,IF(H20=\"р\",0,N20-0.041666667)*72-SUMIFS($M$2:M19,$C$2:C19,C20,$D$2:D19,D20)))))","v":0},{"$f":"SUMIFS($L$2:L20,$C$2:C20,C20,$D$2:D20,D20)","v":"00:53:00"}]
[20,{"$f":"IF(AND(A21=0,C21>1),\"ПОМИЛКА\",IF(AND(F21=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",22,{"$f":"IF(D21=0,\" \",IF(IFERROR((VLOOKUP(D21,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D21,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},6,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D21,#REF!,3,0))<90,#REF!-(VLOOKUP(D21,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D21,#REF!,4,0))>0,(VLOOKUP(D21,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:26:00","13:18:00",{"$f":"IF(AND(J21>0,K21=0),#REF!-J21,IF((K21-J21)<0,\"ПОМИЛКА\",K21-J21))","v":"00:52:00"},{"$f":"IF(F21=0,0,IF(N21=0,0,IF(N21<0.041666667,0,IF(L21=0,0,IF(H21=\"р\",0,N21-0.041666667)*72-SUMIFS($M$2:M20,$C$2:C20,C21,$D$2:D20,D21)))))","v":0},{"$f":"SUMIFS($L$2:L21,$C$2:C21,C21,$D$2:D21,D21)","v":"00:52:00"}]
[21,{"$f":"IF(AND(A22=0,C22>1),\"ПОМИЛКА\",IF(AND(F22=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",301,{"$f":"IF(D22=0,\" \",IF(IFERROR((VLOOKUP(D22,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D22,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},3,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D22,#REF!,3,0))<90,#REF!-(VLOOKUP(D22,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D22,#REF!,4,0))>0,(VLOOKUP(D22,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},"Н","12:38:00","13:38:00",{"$f":"IF(AND(J22>0,K22=0),#REF!-J22,IF((K22-J22)<0,\"ПОМИЛКА\",K22-J22))","v":"01:00:00"},{"$f":"IF(F22=0,0,IF(N22=0,0,IF(N22<0.041666667,0,IF(L22=0,0,IF(H22=\"р\",0,N22-0.041666667)*72-SUMIFS($M$2:M21,$C$2:C21,C22,$D$2:D21,D22)))))","v":0},{"$f":"SUMIFS($L$2:L22,$C$2:C22,C22,$D$2:D22,D22)","v":"01:00:00"}]
[22,{"$f":"IF(AND(A23=0,C23>1),\"ПОМИЛКА\",IF(AND(F23=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",33,{"$f":"IF(D23=0,\" \",IF(IFERROR((VLOOKUP(D23,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D23,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D23,#REF!,3,0))<90,#REF!-(VLOOKUP(D23,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D23,#REF!,4,0))>0,(VLOOKUP(D23,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:40:00","13:40:00",{"$f":"IF(AND(J23>0,K23=0),#REF!-J23,IF((K23-J23)<0,\"ПОМИЛКА\",K23-J23))","v":"01:00:00"},{"$f":"IF(F23=0,0,IF(N23=0,0,IF(N23<0.041666667,0,IF(L23=0,0,IF(H23=\"р\",0,N23-0.041666667)*72-SUMIFS($M$2:M22,$C$2:C22,C23,$D$2:D22,D23)))))","v":0},{"$f":"SUMIFS($L$2:L23,$C$2:C23,C23,$D$2:D23,D23)","v":"01:00:00"}]
[23,{"$f":"IF(AND(A24=0,C24>1),\"ПОМИЛКА\",IF(AND(F24=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",213,{"$f":"IF(D24=0,\" \",IF(IFERROR((VLOOKUP(D24,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D24,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},4,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D24,#REF!,3,0))<90,#REF!-(VLOOKUP(D24,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D24,#REF!,4,0))>0,(VLOOKUP(D24,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:40:00","13:34:00",{"$f":"IF(AND(J24>0,K24=0),#REF!-J24,IF((K24-J24)<0,\"ПОМИЛКА\",K24-J24))","v":"00:54:00"},{"$f":"IF(F24=0,0,IF(N24=0,0,IF(N24<0.041666667,0,IF(L24=0,0,IF(H24=\"р\",0,N24-0.041666667)*72-SUMIFS($M$2:M23,$C$2:C23,C24,$D$2:D23,D24)))))","v":0},{"$f":"SUMIFS($L$2:L24,$C$2:C24,C24,$D$2:D24,D24)","v":"00:54:00"}]
[24,{"$f":"IF(AND(A25=0,C25>1),\"ПОМИЛКА\",IF(AND(F25=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",32,{"$f":"IF(D25=0,\" \",IF(IFERROR((VLOOKUP(D25,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D25,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},2,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D25,#REF!,3,0))<90,#REF!-(VLOOKUP(D25,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D25,#REF!,4,0))>0,(VLOOKUP(D25,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:50:00","13:50:00",{"$f":"IF(AND(J25>0,K25=0),#REF!-J25,IF((K25-J25)<0,\"ПОМИЛКА\",K25-J25))","v":"01:00:00"},{"$f":"IF(F25=0,0,IF(N25=0,0,IF(N25<0.041666667,0,IF(L25=0,0,IF(H25=\"р\",0,N25-0.041666667)*72-SUMIFS($M$2:M24,$C$2:C24,C25,$D$2:D24,D25)))))","v":0},{"$f":"SUMIFS($L$2:L25,$C$2:C25,C25,$D$2:D25,D25)","v":"01:00:00"}]
[25,{"$f":"IF(AND(A26=0,C26>1),\"ПОМИЛКА\",IF(AND(F26=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",29,{"$f":"IF(D26=0,\" \",IF(IFERROR((VLOOKUP(D26,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D26,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},0,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D26,#REF!,3,0))<90,#REF!-(VLOOKUP(D26,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D26,#REF!,4,0))>0,(VLOOKUP(D26,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:14:00","13:40:00",{"$f":"IF(AND(J26>0,K26=0),#REF!-J26,IF((K26-J26)<0,\"ПОМИЛКА\",K26-J26))","v":"00:26:00"},{"$f":"IF(F26=0,0,IF(N26=0,0,IF(N26<0.041666667,0,IF(L26=0,0,IF(H26=\"р\",0,N26-0.041666667)*72-SUMIFS($M$2:M25,$C$2:C25,C26,$D$2:D25,D26)))))","v":0},{"$f":"SUMIFS($L$2:L26,$C$2:C26,C26,$D$2:D26,D26)","v":"00:26:00"}]
[26,{"$f":"IF(AND(A27=0,C27>1),\"ПОМИЛКА\",IF(AND(F27=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",30,{"$f":"IF(D27=0,\" \",IF(IFERROR((VLOOKUP(D27,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D27,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D27,#REF!,3,0))<90,#REF!-(VLOOKUP(D27,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D27,#REF!,4,0))>0,(VLOOKUP(D27,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:14:00","14:14:00",{"$f":"IF(AND(J27>0,K27=0),#REF!-J27,IF((K27-J27)<0,\"ПОМИЛКА\",K27-J27))","v":"01:00:00"},{"$f":"IF(F27=0,0,IF(N27=0,0,IF(N27<0.041666667,0,IF(L27=0,0,IF(H27=\"р\",0,N27-0.041666667)*72-SUMIFS($M$2:M26,$C$2:C26,C27,$D$2:D26,D27)))))","v":0},{"$f":"SUMIFS($L$2:L27,$C$2:C27,C27,$D$2:D27,D27)","v":"01:00:00"}]
[27,{"$f":"IF(AND(A28=0,C28>1),\"ПОМИЛКА\",IF(AND(F28=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",278,{"$f":"IF(D28=0,\" \",IF(IFERROR((VLOOKUP(D28,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D28,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},0,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D28,#REF!,3,0))<90,#REF!-(VLOOKUP(D28,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D28,#REF!,4,0))>0,(VLOOKUP(D28,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:13:00","14:51:00",{"$f":"IF(AND(J28>0,K28=0),#REF!-J28,IF((K28-J28)<0,\"ПОМИЛКА\",K28-J28))","v":"01:38:00"},{"$f":"IF(F28=0,0,IF(N28=0,0,IF(N28<0.041666667,0,IF(L28=0,0,IF(H28=\"р\",0,N28-0.041666667)*72-SUMIFS($M$2:M27,$C$2:C27,C28,$D$2:D27,D28)))))","v":0},{"$f":"SUMIFS($L$2:L28,$C$2:C28,C28,$D$2:D28,D28)","v":"01:38:00"}]
[28,{"$f":"IF(AND(A29=0,C29>1),\"ПОМИЛКА\",IF(AND(F29=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",89,{"$f":"IF(D29=0,\" \",IF(IFERROR((VLOOKUP(D29,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D29,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},6,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D29,#REF!,3,0))<90,#REF!-(VLOOKUP(D29,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D29,#REF!,4,0))>0,(VLOOKUP(D29,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:22:00","14:22:00",{"$f":"IF(AND(J29>0,K29=0),#REF!-J29,IF((K29-J29)<0,\"ПОМИЛКА\",K29-J29))","v":"01:00:00"},{"$f":"IF(F29=0,0,IF(N29=0,0,IF(N29<0.041666667,0,IF(L29=0,0,IF(H29=\"р\",0,N29-0.041666667)*72-SUMIFS($M$2:M28,$C$2:C28,C29,$D$2:D28,D29)))))","v":0},{"$f":"SUMIFS($L$2:L29,$C$2:C29,C29,$D$2:D29,D29)","v":"01:00:00"}]
[29,{"$f":"IF(AND(A30=0,C30>1),\"ПОМИЛКА\",IF(AND(F30=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",29,{"$f":"IF(D30=0,\" \",IF(IFERROR((VLOOKUP(D30,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D30,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},5,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D30,#REF!,3,0))<90,#REF!-(VLOOKUP(D30,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D30,#REF!,4,0))>0,(VLOOKUP(D30,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:40:00","14:00:00",{"$f":"IF(AND(J30>0,K30=0),#REF!-J30,IF((K30-J30)<0,\"ПОМИЛКА\",K30-J30))","v":"00:20:00"},{"$f":"IF(F30=0,0,IF(N30=0,0,IF(N30<0.041666667,0,IF(L30=0,0,IF(H30=\"р\",0,N30-0.041666667)*72-SUMIFS($M$2:M29,$C$2:C29,C30,$D$2:D29,D30)))))","v":0},{"$f":"SUMIFS($L$2:L30,$C$2:C30,C30,$D$2:D30,D30)","v":"00:46:00"}]
[30,{"$f":"IF(AND(A31=0,C31>1),\"ПОМИЛКА\",IF(AND(F31=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",302,{"$f":"IF(D31=0,\" \",IF(IFERROR((VLOOKUP(D31,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D31,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},4,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D31,#REF!,3,0))<90,#REF!-(VLOOKUP(D31,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D31,#REF!,4,0))>0,(VLOOKUP(D31,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},"П","13:43:00","14:43:00",{"$f":"IF(AND(J31>0,K31=0),#REF!-J31,IF((K31-J31)<0,\"ПОМИЛКА\",K31-J31))","v":"01:00:00"},{"$f":"IF(F31=0,0,IF(N31=0,0,IF(N31<0.041666667,0,IF(L31=0,0,IF(H31=\"р\",0,N31-0.041666667)*72-SUMIFS($M$2:M30,$C$2:C30,C31,$D$2:D30,D31)))))","v":0},{"$f":"SUMIFS($L$2:L31,$C$2:C31,C31,$D$2:D31,D31)","v":"01:00:00"}]
[31,{"$f":"IF(AND(A32=0,C32>1),\"ПОМИЛКА\",IF(AND(F32=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",91,{"$f":"IF(D32=0,\" \",IF(IFERROR((VLOOKUP(D32,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D32,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D32,#REF!,3,0))<90,#REF!-(VLOOKUP(D32,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D32,#REF!,4,0))>0,(VLOOKUP(D32,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:49:00","14:49:00",{"$f":"IF(AND(J32>0,K32=0),#REF!-J32,IF((K32-J32)<0,\"ПОМИЛКА\",K32-J32))","v":"01:00:00"},{"$f":"IF(F32=0,0,IF(N32=0,0,IF(N32<0.041666667,0,IF(L32=0,0,IF(H32=\"р\",0,N32-0.041666667)*72-SUMIFS($M$2:M31,$C$2:C31,C32,$D$2:D31,D32)))))","v":0},{"$f":"SUMIFS($L$2:L32,$C$2:C32,C32,$D$2:D32,D32)","v":"01:00:00"}]
[32,{"$f":"IF(AND(A33=0,C33>1),\"ПОМИЛКА\",IF(AND(F33=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",76,{"$f":"IF(D33=0,\" \",IF(IFERROR((VLOOKUP(D33,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D33,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D33,#REF!,3,0))<90,#REF!-(VLOOKUP(D33,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D33,#REF!,4,0))>0,(VLOOKUP(D33,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:49:00","14:49:00",{"$f":"IF(AND(J33>0,K33=0),#REF!-J33,IF((K33-J33)<0,\"ПОМИЛКА\",K33-J33))","v":"01:00:00"},{"$f":"IF(F33=0,0,IF(N33=0,0,IF(N33<0.041666667,0,IF(L33=0,0,IF(H33=\"р\",0,N33-0.041666667)*72-SUMIFS($M$2:M32,$C$2:C32,C33,$D$2:D32,D33)))))","v":0},{"$f":"SUMIFS($L$2:L33,$C$2:C33,C33,$D$2:D33,D33)","v":"01:00:00"}]
[33,{"$f":"IF(AND(A34=0,C34>1),\"ПОМИЛКА\",IF(AND(F34=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",303,{"$f":"IF(D34=0,\" \",IF(IFERROR((VLOOKUP(D34,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D34,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},2,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D34,#REF!,3,0))<90,#REF!-(VLOOKUP(D34,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D34,#REF!,4,0))>0,(VLOOKUP(D34,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},"Н","14:00:00","15:20:00",{"$f":"IF(AND(J34>0,K34=0),#REF!-J34,IF((K34-J34)<0,\"ПОМИЛКА\",K34-J34))","v":"01:20:00"},{"$f":"IF(F34=0,0,IF(N34=0,0,IF(N34<0.041666667,0,IF(L34=0,0,IF(H34=\"р\",0,N34-0.041666667)*72-SUMIFS($M$2:M33,$C$2:C33,C34,$D$2:D33,D34)))))","v":1},{"$f":"SUMIFS($L$2:L34,$C$2:C34,C34,$D$2:D34,D34)","v":"01:20:00"}]
[34,{"$f":"IF(AND(A35=0,C35>1),\"ПОМИЛКА\",IF(AND(F35=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",266,{"$f":"IF(D35=0,\" \",IF(IFERROR((VLOOKUP(D35,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D35,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},10,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D35,#REF!,3,0))<90,#REF!-(VLOOKUP(D35,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D35,#REF!,4,0))>0,(VLOOKUP(D35,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:11:00","15:11:00",{"$f":"IF(AND(J35>0,K35=0),#REF!-J35,IF((K35-J35)<0,\"ПОМИЛКА\",K35-J35))","v":"01:00:00"},{"$f":"IF(F35=0,0,IF(N35=0,0,IF(N35<0.041666667,0,IF(L35=0,0,IF(H35=\"р\",0,N35-0.041666667)*72-SUMIFS($M$2:M34,$C$2:C34,C35,$D$2:D34,D35)))))","v":0},{"$f":"SUMIFS($L$2:L35,$C$2:C35,C35,$D$2:D35,D35)","v":"01:00:00"}]
[35,{"$f":"IF(AND(A36=0,C36>1),\"ПОМИЛКА\",IF(AND(F36=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",5,{"$f":"IF(D36=0,\" \",IF(IFERROR((VLOOKUP(D36,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D36,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D36,#REF!,3,0))<90,#REF!-(VLOOKUP(D36,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D36,#REF!,4,0))>0,(VLOOKUP(D36,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:19:00","15:19:00",{"$f":"IF(AND(J36>0,K36=0),#REF!-J36,IF((K36-J36)<0,\"ПОМИЛКА\",K36-J36))","v":"01:00:00"},{"$f":"IF(F36=0,0,IF(N36=0,0,IF(N36<0.041666667,0,IF(L36=0,0,IF(H36=\"р\",0,N36-0.041666667)*72-SUMIFS($M$2:M35,$C$2:C35,C36,$D$2:D35,D36)))))","v":0},{"$f":"SUMIFS($L$2:L36,$C$2:C36,C36,$D$2:D36,D36)","v":"01:00:00"}]
[36,{"$f":"IF(AND(A37=0,C37>1),\"ПОМИЛКА\",IF(AND(F37=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",289,{"$f":"IF(D37=0,\" \",IF(IFERROR((VLOOKUP(D37,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D37,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D37,#REF!,3,0))<90,#REF!-(VLOOKUP(D37,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D37,#REF!,4,0))>0,(VLOOKUP(D37,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:20:00","15:08:00",{"$f":"IF(AND(J37>0,K37=0),#REF!-J37,IF((K37-J37)<0,\"ПОМИЛКА\",K37-J37))","v":"00:48:00"},{"$f":"IF(F37=0,0,IF(N37=0,0,IF(N37<0.041666667,0,IF(L37=0,0,IF(H37=\"р\",0,N37-0.041666667)*72-SUMIFS($M$2:M36,$C$2:C36,C37,$D$2:D36,D37)))))","v":0},{"$f":"SUMIFS($L$2:L37,$C$2:C37,C37,$D$2:D37,D37)","v":"00:48:00"}]
[37,{"$f":"IF(AND(A38=0,C38>1),\"ПОМИЛКА\",IF(AND(F38=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",8,{"$f":"IF(D38=0,\" \",IF(IFERROR((VLOOKUP(D38,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D38,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},6,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D38,#REF!,3,0))<90,#REF!-(VLOOKUP(D38,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D38,#REF!,4,0))>0,(VLOOKUP(D38,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:37:00","15:37:00",{"$f":"IF(AND(J38>0,K38=0),#REF!-J38,IF((K38-J38)<0,\"ПОМИЛКА\",K38-J38))","v":"01:00:00"},{"$f":"IF(F38=0,0,IF(N38=0,0,IF(N38<0.041666667,0,IF(L38=0,0,IF(H38=\"р\",0,N38-0.041666667)*72-SUMIFS($M$2:M37,$C$2:C37,C38,$D$2:D37,D38)))))","v":0},{"$f":"SUMIFS($L$2:L38,$C$2:C38,C38,$D$2:D38,D38)","v":"01:00:00"}]
[38,{"$f":"IF(AND(A39=0,C39>1),\"ПОМИЛКА\",IF(AND(F39=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",9,{"$f":"IF(D39=0,\" \",IF(IFERROR((VLOOKUP(D39,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D39,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},3,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D39,#REF!,3,0))<90,#REF!-(VLOOKUP(D39,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D39,#REF!,4,0))>0,(VLOOKUP(D39,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:37:00","15:30:00",{"$f":"IF(AND(J39>0,K39=0),#REF!-J39,IF((K39-J39)<0,\"ПОМИЛКА\",K39-J39))","v":"00:53:00"},{"$f":"IF(F39=0,0,IF(N39=0,0,IF(N39<0.041666667,0,IF(L39=0,0,IF(H39=\"р\",0,N39-0.041666667)*72-SUMIFS($M$2:M38,$C$2:C38,C39,$D$2:D38,D39)))))","v":0},{"$f":"SUMIFS($L$2:L39,$C$2:C39,C39,$D$2:D39,D39)","v":"00:53:00"}]
[39,{"$f":"IF(AND(A40=0,C40>1),\"ПОМИЛКА\",IF(AND(F40=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",89,{"$f":"IF(D40=0,\" \",IF(IFERROR((VLOOKUP(D40,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D40,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D40,#REF!,3,0))<90,#REF!-(VLOOKUP(D40,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D40,#REF!,4,0))>0,(VLOOKUP(D40,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:56:00","15:16:00",{"$f":"IF(AND(J40>0,K40=0),#REF!-J40,IF((K40-J40)<0,\"ПОМИЛКА\",K40-J40))","v":"00:20:00"},{"$f":"IF(F40=0,0,IF(N40=0,0,IF(N40<0.041666667,0,IF(L40=0,0,IF(H40=\"р\",0,N40-0.041666667)*72-SUMIFS($M$2:M39,$C$2:C39,C40,$D$2:D39,D40)))))","v":1},{"$f":"SUMIFS($L$2:L40,$C$2:C40,C40,$D$2:D40,D40)","v":"01:20:00"}]
[40,{"$f":"IF(AND(A41=0,C41>1),\"ПОМИЛКА\",IF(AND(F41=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",95,{"$f":"IF(D41=0,\" \",IF(IFERROR((VLOOKUP(D41,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D41,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D41,#REF!,3,0))<90,#REF!-(VLOOKUP(D41,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D41,#REF!,4,0))>0,(VLOOKUP(D41,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:56:00","15:10:00",{"$f":"IF(AND(J41>0,K41=0),#REF!-J41,IF((K41-J41)<0,\"ПОМИЛКА\",K41-J41))","v":"00:14:00"},{"$f":"IF(F41=0,0,IF(N41=0,0,IF(N41<0.041666667,0,IF(L41=0,0,IF(H41=\"р\",0,N41-0.041666667)*72-SUMIFS($M$2:M40,$C$2:C40,C41,$D$2:D40,D41)))))","v":0},{"$f":"SUMIFS($L$2:L41,$C$2:C41,C41,$D$2:D41,D41)","v":"00:14:00"}]
[41,{"$f":"IF(AND(A42=0,C42>1),\"ПОМИЛКА\",IF(AND(F42=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",10,{"$f":"IF(D42=0,\" \",IF(IFERROR((VLOOKUP(D42,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D42,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},5,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D42,#REF!,3,0))<90,#REF!-(VLOOKUP(D42,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D42,#REF!,4,0))>0,(VLOOKUP(D42,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:02:00","16:02:00",{"$f":"IF(AND(J42>0,K42=0),#REF!-J42,IF((K42-J42)<0,\"ПОМИЛКА\",K42-J42))","v":"01:00:00"},{"$f":"IF(F42=0,0,IF(N42=0,0,IF(N42<0.041666667,0,IF(L42=0,0,IF(H42=\"р\",0,N42-0.041666667)*72-SUMIFS($M$2:M41,$C$2:C41,C42,$D$2:D41,D42)))))","v":0},{"$f":"SUMIFS($L$2:L42,$C$2:C42,C42,$D$2:D42,D42)","v":"01:00:00"}]
[42,{"$f":"IF(AND(A43=0,C43>1),\"ПОМИЛКА\",IF(AND(F43=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",165,{"$f":"IF(D43=0,\" \",IF(IFERROR((VLOOKUP(D43,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D43,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D43,#REF!,3,0))<90,#REF!-(VLOOKUP(D43,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D43,#REF!,4,0))>0,(VLOOKUP(D43,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:13:00","15:30:00",{"$f":"IF(AND(J43>0,K43=0),#REF!-J43,IF((K43-J43)<0,\"ПОМИЛКА\",K43-J43))","v":"00:17:00"},{"$f":"IF(F43=0,0,IF(N43=0,0,IF(N43<0.041666667,0,IF(L43=0,0,IF(H43=\"р\",0,N43-0.041666667)*72-SUMIFS($M$2:M42,$C$2:C42,C43,$D$2:D42,D43)))))","v":0},{"$f":"SUMIFS($L$2:L43,$C$2:C43,C43,$D$2:D43,D43)","v":"00:17:00"}]
[43,{"$f":"IF(AND(A44=0,C44>1),\"ПОМИЛКА\",IF(AND(F44=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",72,{"$f":"IF(D44=0,\" \",IF(IFERROR((VLOOKUP(D44,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D44,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},10,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D44,#REF!,3,0))<90,#REF!-(VLOOKUP(D44,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D44,#REF!,4,0))>0,(VLOOKUP(D44,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:13:00","16:13:00",{"$f":"IF(AND(J44>0,K44=0),#REF!-J44,IF((K44-J44)<0,\"ПОМИЛКА\",K44-J44))","v":"01:00:00"},{"$f":"IF(F44=0,0,IF(N44=0,0,IF(N44<0.041666667,0,IF(L44=0,0,IF(H44=\"р\",0,N44-0.041666667)*72-SUMIFS($M$2:M43,$C$2:C43,C44,$D$2:D43,D44)))))","v":0},{"$f":"SUMIFS($L$2:L44,$C$2:C44,C44,$D$2:D44,D44)","v":"01:00:00"}]
[44,{"$f":"IF(AND(A45=0,C45>1),\"ПОМИЛКА\",IF(AND(F45=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",165,{"$f":"IF(D45=0,\" \",IF(IFERROR((VLOOKUP(D45,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D45,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},3,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D45,#REF!,3,0))<90,#REF!-(VLOOKUP(D45,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D45,#REF!,4,0))>0,(VLOOKUP(D45,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:30:00","16:10:00",{"$f":"IF(AND(J45>0,K45=0),#REF!-J45,IF((K45-J45)<0,\"ПОМИЛКА\",K45-J45))","v":"00:40:00"},{"$f":"IF(F45=0,0,IF(N45=0,0,IF(N45<0.041666667,0,IF(L45=0,0,IF(H45=\"р\",0,N45-0.041666667)*72-SUMIFS($M$2:M44,$C$2:C44,C45,$D$2:D44,D45)))))","v":0},{"$f":"SUMIFS($L$2:L45,$C$2:C45,C45,$D$2:D45,D45)","v":"00:57:00"}]
[45,{"$f":"IF(AND(A46=0,C46>1),\"ПОМИЛКА\",IF(AND(F46=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",277,{"$f":"IF(D46=0,\" \",IF(IFERROR((VLOOKUP(D46,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D46,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},0,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D46,#REF!,3,0))<90,#REF!-(VLOOKUP(D46,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D46,#REF!,4,0))>0,(VLOOKUP(D46,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:43:00","16:48:00",{"$f":"IF(AND(J46>0,K46=0),#REF!-J46,IF((K46-J46)<0,\"ПОМИЛКА\",K46-J46))","v":"01:05:00"},{"$f":"IF(F46=0,0,IF(N46=0,0,IF(N46<0.041666667,0,IF(L46=0,0,IF(H46=\"р\",0,N46-0.041666667)*72-SUMIFS($M$2:M45,$C$2:C45,C46,$D$2:D45,D46)))))","v":0},{"$f":"SUMIFS($L$2:L46,$C$2:C46,C46,$D$2:D46,D46)","v":"01:05:00"}]
[46,{"$f":"IF(AND(A47=0,C47>1),\"ПОМИЛКА\",IF(AND(F47=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",85,{"$f":"IF(D47=0,\" \",IF(IFERROR((VLOOKUP(D47,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D47,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D47,#REF!,3,0))<90,#REF!-(VLOOKUP(D47,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D47,#REF!,4,0))>0,(VLOOKUP(D47,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:20:00","18:00:00",{"$f":"IF(AND(J47>0,K47=0),#REF!-J47,IF((K47-J47)<0,\"ПОМИЛКА\",K47-J47))","v":"01:40:00"},{"$f":"IF(F47=0,0,IF(N47=0,0,IF(N47<0.041666667,0,IF(L47=0,0,IF(H47=\"р\",0,N47-0.041666667)*72-SUMIFS($M$2:M46,$C$2:C46,C47,$D$2:D46,D47)))))","v":5},{"$f":"SUMIFS($L$2:L47,$C$2:C47,C47,$D$2:D47,D47)","v":"02:40:00"}]
[47,{"$f":"IF(AND(A48=0,C48>1),\"ПОМИЛКА\",IF(AND(F48=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",287,{"$f":"IF(D48=0,\" \",IF(IFERROR((VLOOKUP(D48,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D48,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},5,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D48,#REF!,3,0))<90,#REF!-(VLOOKUP(D48,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D48,#REF!,4,0))>0,(VLOOKUP(D48,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:30:00","17:30:00",{"$f":"IF(AND(J48>0,K48=0),#REF!-J48,IF((K48-J48)<0,\"ПОМИЛКА\",K48-J48))","v":"01:00:00"},{"$f":"IF(F48=0,0,IF(N48=0,0,IF(N48<0.041666667,0,IF(L48=0,0,IF(H48=\"р\",0,N48-0.041666667)*72-SUMIFS($M$2:M47,$C$2:C47,C48,$D$2:D47,D48)))))","v":0},{"$f":"SUMIFS($L$2:L48,$C$2:C48,C48,$D$2:D48,D48)","v":"01:00:00"}]
[48,{"$f":"IF(AND(A49=0,C49>1),\"ПОМИЛКА\",IF(AND(F49=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",49,{"$f":"IF(D49=0,\" \",IF(IFERROR((VLOOKUP(D49,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D49,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},10,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D49,#REF!,3,0))<90,#REF!-(VLOOKUP(D49,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D49,#REF!,4,0))>0,(VLOOKUP(D49,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:30:00","17:30:00",{"$f":"IF(AND(J49>0,K49=0),#REF!-J49,IF((K49-J49)<0,\"ПОМИЛКА\",K49-J49))","v":"01:00:00"},{"$f":"IF(F49=0,0,IF(N49=0,0,IF(N49<0.041666667,0,IF(L49=0,0,IF(H49=\"р\",0,N49-0.041666667)*72-SUMIFS($M$2:M48,$C$2:C48,C49,$D$2:D48,D49)))))","v":0},{"$f":"SUMIFS($L$2:L49,$C$2:C49,C49,$D$2:D49,D49)","v":"01:00:00"}]
[49,{"$f":"IF(AND(A50=0,C50>1),\"ПОМИЛКА\",IF(AND(F50=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-03-01",47,{"$f":"IF(D50=0,\" \",IF(IFERROR((VLOOKUP(D50,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D50,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},6,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D50,#REF!,3,0))<90,#REF!-(VLOOKUP(D50,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D50,#REF!,4,0))>0,(VLOOKUP(D50,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"17:25:00","18:00:00",{"$f":"IF(AND(J50>0,K50=0),#REF!-J50,IF((K50-J50)<0,\"ПОМИЛКА\",K50-J50))","v":"00:35:00"},{"$f":"IF(F50=0,0,IF(N50=0,0,IF(N50<0.041666667,0,IF(L50=0,0,IF(H50=\"р\",0,N50-0.041666667)*72-SUMIFS($M$2:M49,$C$2:C49,C50,$D$2:D49,D50)))))","v":0},{"$f":"SUMIFS($L$2:L50,$C$2:C50,C50,$D$2:D50,D50)","v":"00:35:00"}]

{"sheet":"4_15","index":1,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[[0,0,0,8],[0,9,0,11]]}
[]
[{"$f":"IF(C2>0,1, 0)","v":1},{"$f":"IF(AND(A2=0,C2>1),\"ПОМИЛКА\",IF(AND(F2=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",18,{"$f":"IF(D2=0,\" \",IF(IFERROR((VLOOKUP(D2,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D2,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D2,#REF!,3,0))<90,#REF!-(VLOOKUP(D2,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D2,#REF!,4,0))>0,(VLOOKUP(D2,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"09:34:00","10:34:00",{"$f":"IF(AND(J2>0,K2=0),#REF!-J2,IF((K2-J2)<0,\"ПОМИЛКА\",K2-J2))","v":"01:00:00"},{"$f":"IF(F2=0,0,IF(N2=0,0,IF(N2<0.041666667,0,IF(L2=0,0,IF(H2=\"р\",0,N2-0.041666667)*72-SUMIFS($M1:M$2,$C1:C$2,C2,$D1:D$2,D2)))))","v":0},{"$f":"SUMIFS($L$2:L2,$C$2:C2,C2,$D$2:D2,D2)","v":"01:00:00"}]
[{"$f":"IF(AND(A2=1, C3>0), SUM(A2+1), 0)","v":2},{"$f":"IF(AND(A3=0,C3>1),\"ПОМИЛКА\",IF(AND(F3=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",214,{"$f":"IF(D3=0,\" \",IF(IFERROR((VLOOKUP(D3,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D3,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D3,#REF!,3,0))<90,#REF!-(VLOOKUP(D3,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,null,"09:46:00","10:46:00",{"$f":"IF(AND(J3>0,K3=0),#REF!-J3,IF((K3-J3)<0,\"ПОМИЛКА\",K3-J3))","v":"01:00:00"},{"$f":"IF(F3=0,0,IF(N3=0,0,IF(N3<0.041666667,0,IF(L3=0,0,IF(H3=\"р\",0,N3-0.041666667)*72-SUMIFS($M$2:M2,$C$2:C2,C3,$D$2:D2,D3)))))","v":0},{"$f":"SUMIFS($L$2:L3,$C$2:C3,C3,$D$2:D3,D3)","v":"01:00:00"}]
[{"$f":"IF(AND(A3-A2=1, C4>0), SUM(A3+1), 0)","v":3},{"$f":"IF(AND(A4=0,C4>1),\"ПОМИЛКА\",IF(AND(F4=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",369,{"$f":"IF(D4=0,\" \",IF(IFERROR((VLOOKUP(D4,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D4,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},3,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D4,#REF!,3,0))<90,#REF!-(VLOOKUP(D4,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D4,#REF!,4,0))>0,(VLOOKUP(D4,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},"П","09:49:00","10:49:00",{"$f":"IF(AND(J4>0,K4=0),#REF!-J4,IF((K4-J4)<0,\"ПОМИЛКА\",K4-J4))","v":"01:00:00"},{"$f":"IF(F4=0,0,IF(N4=0,0,IF(N4<0.041666667,0,IF(L4=0,0,IF(H4=\"р\",0,N4-0.041666667)*72-SUMIFS($M$2:M3,$C$2:C3,C4,$D$2:D3,D4)))))","v":0},{"$f":"SUMIFS($L$2:L4,$C$2:C4,C4,$D$2:D4,D4)","v":"01:00:00"}]
[4,{"$f":"IF(AND(A5=0,C5>1),\"ПОМИЛКА\",IF(AND(F5=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",370,{"$f":"IF(D5=0,\" \",IF(IFERROR((VLOOKUP(D5,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D5,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},4,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D5,#REF!,3,0))<90,#REF!-(VLOOKUP(D5,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D5,#REF!,4,0))>0,(VLOOKUP(D5,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},"Н","09:52:00","10:52:00",{"$f":"IF(AND(J5>0,K5=0),#REF!-J5,IF((K5-J5)<0,\"ПОМИЛКА\",K5-J5))","v":"01:00:00"},{"$f":"IF(F5=0,0,IF(N5=0,0,IF(N5<0.041666667,0,IF(L5=0,0,IF(H5=\"р\",0,N5-0.041666667)*72-SUMIFS($M$2:M4,$C$2:C4,C5,$D$2:D4,D5)))))","v":0},{"$f":"SUMIFS($L$2:L5,$C$2:C5,C5,$D$2:D5,D5)","v":"01:00:00"}]
[5,{"$f":"IF(AND(A6=0,C6>1),\"ПОМИЛКА\",IF(AND(F6=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",349,{"$f":"IF(D6=0,\" \",IF(IFERROR((VLOOKUP(D6,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D6,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},10,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D6,#REF!,3,0))<90,#REF!-(VLOOKUP(D6,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D6,#REF!,4,0))>0,(VLOOKUP(D6,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"10:45:00","11:45:00",{"$f":"IF(AND(J6>0,K6=0),#REF!-J6,IF((K6-J6)<0,\"ПОМИЛКА\",K6-J6))","v":"01:00:00"},{"$f":"IF(F6=0,0,IF(N6=0,0,IF(N6<0.041666667,0,IF(L6=0,0,IF(H6=\"р\",0,N6-0.041666667)*72-SUMIFS($M$2:M5,$C$2:C5,C6,$D$2:D5,D6)))))","v":0},{"$f":"SUMIFS($L$2:L6,$C$2:C6,C6,$D$2:D6,D6)","v":"01:00:00"}]
[6,{"$f":"IF(AND(A7=0,C7>1),\"ПОМИЛКА\",IF(AND(F7=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",28,{"$f":"IF(D7=0,\" \",IF(IFERROR((VLOOKUP(D7,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D7,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D7,#REF!,3,0))<90,#REF!-(VLOOKUP(D7,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D7,#REF!,4,0))>0,(VLOOKUP(D7,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:00:00","11:44:00",{"$f":"IF(AND(J7>0,K7=0),#REF!-J7,IF((K7-J7)<0,\"ПОМИЛКА\",K7-J7))","v":"00:44:00"},{"$f":"IF(F7=0,0,IF(N7=0,0,IF(N7<0.041666667,0,IF(L7=0,0,IF(H7=\"р\",0,N7-0.041666667)*72-SUMIFS($M$2:M6,$C$2:C6,C7,$D$2:D6,D7)))))","v":0},{"$f":"SUMIFS($L$2:L7,$C$2:C7,C7,$D$2:D7,D7)","v":"00:44:00"}]
[7,{"$f":"IF(AND(A8=0,C8>1),\"ПОМИЛКА\",IF(AND(F8=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",371,{"$f":"IF(D8=0,\" \",IF(IFERROR((VLOOKUP(D8,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D8,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D8,#REF!,3,0))<90,#REF!-(VLOOKUP(D8,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D8,#REF!,4,0))>0,(VLOOKUP(D8,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},"Н","11:34:00","12:26:00",{"$f":"IF(AND(J8>0,K8=0),#REF!-J8,IF((K8-J8)<0,\"ПОМИЛКА\",K8-J8))","v":"00:52:00"},{"$f":"IF(F8=0,0,IF(N8=0,0,IF(N8<0.041666667,0,IF(L8=0,0,IF(H8=\"р\",0,N8-0.041666667)*72-SUMIFS($M$2:M7,$C$2:C7,C8,$D$2:D7,D8)))))","v":0},{"$f":"SUMIFS($L$2:L8,$C$2:C8,C8,$D$2:D8,D8)","v":"00:52:00"}]
[8,{"$f":"IF(AND(A9=0,C9>1),\"ПОМИЛКА\",IF(AND(F9=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",70,{"$f":"IF(D9=0,\" \",IF(IFERROR((VLOOKUP(D9,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D9,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D9,#REF!,3,0))<90,#REF!-(VLOOKUP(D9,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D9,#REF!,4,0))>0,(VLOOKUP(D9,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:41:00","12:40:00",{"$f":"IF(AND(J9>0,K9=0),#REF!-J9,IF((K9-J9)<0,\"ПОМИЛКА\",K9-J9))","v":"00:59:00"},{"$f":"IF(F9=0,0,IF(N9=0,0,IF(N9<0.041666667,0,IF(L9=0,0,IF(H9=\"р\",0,N9-0.041666667)*72-SUMIFS($M$2:M8,$C$2:C8,C9,$D$2:D8,D9)))))","v":0},{"$f":"SUMIFS($L$2:L9,$C$2:C9,C9,$D$2:D9,D9)","v":"00:59:00"}]
[9,{"$f":"IF(AND(A10=0,C10>1),\"ПОМИЛКА\",IF(AND(F10=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",42,{"$f":"IF(D10=0,\" \",IF(IFERROR((VLOOKUP(D10,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D10,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},5,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D10,#REF!,3,0))<90,#REF!-(VLOOKUP(D10,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D10,#REF!,4,0))>0,(VLOOKUP(D10,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:41:00","12:40:00",{"$f":"IF(AND(J10>0,K10=0),#REF!-J10,IF((K10-J10)<0,\"ПОМИЛКА\",K10-J10))","v":"00:59:00"},{"$f":"IF(F10=0,0,IF(N10=0,0,IF(N10<0.041666667,0,IF(L10=0,0,IF(H10=\"р\",0,N10-0.041666667)*72-SUMIFS($M$2:M9,$C$2:C9,C10,$D$2:D9,D10)))))","v":0},{"$f":"SUMIFS($L$2:L10,$C$2:C10,C10,$D$2:D10,D10)","v":"00:59:00"}]
[10,{"$f":"IF(AND(A11=0,C11>1),\"ПОМИЛКА\",IF(AND(F11=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",161,{"$f":"IF(D11=0,\" \",IF(IFERROR((VLOOKUP(D11,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D11,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D11,#REF!,3,0))<90,#REF!-(VLOOKUP(D11,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D11,#REF!,4,0))>0,(VLOOKUP(D11,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:42:00","13:42:00",{"$f":"IF(AND(J11>0,K11=0),#REF!-J11,IF((K11-J11)<0,\"ПОМИЛКА\",K11-J11))","v":"01:00:00"},{"$f":"IF(F11=0,0,IF(N11=0,0,IF(N11<0.041666667,0,IF(L11=0,0,IF(H11=\"р\",0,N11-0.041666667)*72-SUMIFS($M$2:M10,$C$2:C10,C11,$D$2:D10,D11)))))","v":0},{"$f":"SUMIFS($L$2:L11,$C$2:C11,C11,$D$2:D11,D11)","v":"01:00:00"}]
[11,{"$f":"IF(AND(A12=0,C12>1),\"ПОМИЛКА\",IF(AND(F12=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",311,{"$f":"IF(D12=0,\" \",IF(IFERROR((VLOOKUP(D12,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D12,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D12,#REF!,3,0))<90,#REF!-(VLOOKUP(D12,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D12,#REF!,4,0))>0,(VLOOKUP(D12,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:43:00","13:21:00",{"$f":"IF(AND(J12>0,K12=0),#REF!-J12,IF((K12-J12)<0,\"ПОМИЛКА\",K12-J12))","v":"00:38:00"},{"$f":"IF(F12=0,0,IF(N12=0,0,IF(N12<0.041666667,0,IF(L12=0,0,IF(H12=\"р\",0,N12-0.041666667)*72-SUMIFS($M$2:M11,$C$2:C11,C12,$D$2:D11,D12)))))","v":0},{"$f":"SUMIFS($L$2:L12,$C$2:C12,C12,$D$2:D12,D12)","v":"00:38:00"}]
[12,{"$f":"IF(AND(A13=0,C13>1),\"ПОМИЛКА\",IF(AND(F13=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",83,{"$f":"IF(D13=0,\" \",IF(IFERROR((VLOOKUP(D13,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D13,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},5,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D13,#REF!,3,0))<90,#REF!-(VLOOKUP(D13,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D13,#REF!,4,0))>0,(VLOOKUP(D13,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:24:00","13:48:00",{"$f":"IF(AND(J13>0,K13=0),#REF!-J13,IF((K13-J13)<0,\"ПОМИЛКА\",K13-J13))","v":"00:24:00"},{"$f":"IF(F13=0,0,IF(N13=0,0,IF(N13<0.041666667,0,IF(L13=0,0,IF(H13=\"р\",0,N13-0.041666667)*72-SUMIFS($M$2:M12,$C$2:C12,C13,$D$2:D12,D13)))))","v":0},{"$f":"SUMIFS($L$2:L13,$C$2:C13,C13,$D$2:D13,D13)","v":"00:24:00"}]
[13,{"$f":"IF(AND(A14=0,C14>1),\"ПОМИЛКА\",IF(AND(F14=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",41,{"$f":"IF(D14=0,\" \",IF(IFERROR((VLOOKUP(D14,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D14,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},10,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D14,#REF!,3,0))<90,#REF!-(VLOOKUP(D14,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D14,#REF!,4,0))>0,(VLOOKUP(D14,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:00:00","15:00:00",{"$f":"IF(AND(J14>0,K14=0),#REF!-J14,IF((K14-J14)<0,\"ПОМИЛКА\",K14-J14))","v":"01:00:00"},{"$f":"IF(F14=0,0,IF(N14=0,0,IF(N14<0.041666667,0,IF(L14=0,0,IF(H14=\"р\",0,N14-0.041666667)*72-SUMIFS($M$2:M13,$C$2:C13,C14,$D$2:D13,D14)))))","v":0},{"$f":"SUMIFS($L$2:L14,$C$2:C14,C14,$D$2:D14,D14)","v":"01:00:00"}]
[14,{"$f":"IF(AND(A15=0,C15>1),\"ПОМИЛКА\",IF(AND(F15=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",5,{"$f":"IF(D15=0,\" \",IF(IFERROR((VLOOKUP(D15,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D15,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},5,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D15,#REF!,3,0))<90,#REF!-(VLOOKUP(D15,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D15,#REF!,4,0))>0,(VLOOKUP(D15,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:30:00","16:10:00",{"$f":"IF(AND(J15>0,K15=0),#REF!-J15,IF((K15-J15)<0,\"ПОМИЛКА\",K15-J15))","v":"01:40:00"},{"$f":"IF(F15=0,0,IF(N15=0,0,IF(N15<0.041666667,0,IF(L15=0,0,IF(H15=\"р\",0,N15-0.041666667)*72-SUMIFS($M$2:M14,$C$2:C14,C15,$D$2:D14,D15)))))","v":2},{"$f":"SUMIFS($L$2:L15,$C$2:C15,C15,$D$2:D15,D15)","v":"01:40:00"}]
[15,{"$f":"IF(AND(A16=0,C16>1),\"ПОМИЛКА\",IF(AND(F16=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",26,{"$f":"IF(D16=0,\" \",IF(IFERROR((VLOOKUP(D16,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D16,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D16,#REF!,3,0))<90,#REF!-(VLOOKUP(D16,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D16,#REF!,4,0))>0,(VLOOKUP(D16,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:30:00","15:30:00",{"$f":"IF(AND(J16>0,K16=0),#REF!-J16,IF((K16-J16)<0,\"ПОМИЛКА\",K16-J16))","v":"01:00:00"},{"$f":"IF(F16=0,0,IF(N16=0,0,IF(N16<0.041666667,0,IF(L16=0,0,IF(H16=\"р\",0,N16-0.041666667)*72-SUMIFS($M$2:M15,$C$2:C15,C16,$D$2:D15,D16)))))","v":0},{"$f":"SUMIFS($L$2:L16,$C$2:C16,C16,$D$2:D16,D16)","v":"01:00:00"}]
[16,{"$f":"IF(AND(A17=0,C17>1),\"ПОМИЛКА\",IF(AND(F17=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",361,{"$f":"IF(D17=0,\" \",IF(IFERROR((VLOOKUP(D17,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D17,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D17,#REF!,3,0))<90,#REF!-(VLOOKUP(D17,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D17,#REF!,4,0))>0,(VLOOKUP(D17,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:30:00","15:10:00",{"$f":"IF(AND(J17>0,K17=0),#REF!-J17,IF((K17-J17)<0,\"ПОМИЛКА\",K17-J17))","v":"00:40:00"},{"$f":"IF(F17=0,0,IF(N17=0,0,IF(N17<0.041666667,0,IF(L17=0,0,IF(H17=\"р\",0,N17-0.041666667)*72-SUMIFS($M$2:M16,$C$2:C16,C17,$D$2:D16,D17)))))","v":0},{"$f":"SUMIFS($L$2:L17,$C$2:C17,C17,$D$2:D17,D17)","v":"00:40:00"}]
[17,{"$f":"IF(AND(A18=0,C18>1),\"ПОМИЛКА\",IF(AND(F18=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",115,{"$f":"IF(D18=0,\" \",IF(IFERROR((VLOOKUP(D18,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D18,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D18,#REF!,3,0))<90,#REF!-(VLOOKUP(D18,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D18,#REF!,4,0))>0,(VLOOKUP(D18,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:48:00","15:48:00",{"$f":"IF(AND(J18>0,K18=0),#REF!-J18,IF((K18-J18)<0,\"ПОМИЛКА\",K18-J18))","v":"01:00:00"},{"$f":"IF(F18=0,0,IF(N18=0,0,IF(N18<0.041666667,0,IF(L18=0,0,IF(H18=\"р\",0,N18-0.041666667)*72-SUMIFS($M$2:M17,$C$2:C17,C18,$D$2:D17,D18)))))","v":0},{"$f":"SUMIFS($L$2:L18,$C$2:C18,C18,$D$2:D18,D18)","v":"01:00:00"}]
[18,{"$f":"IF(AND(A19=0,C19>1),\"ПОМИЛКА\",IF(AND(F19=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",191,{"$f":"IF(D19=0,\" \",IF(IFERROR((VLOOKUP(D19,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D19,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},6,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D19,#REF!,3,0))<90,#REF!-(VLOOKUP(D19,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D19,#REF!,4,0))>0,(VLOOKUP(D19,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:13:00","16:20:00",{"$f":"IF(AND(J19>0,K19=0),#REF!-J19,IF((K19-J19)<0,\"ПОМИЛКА\",K19-J19))","v":"01:07:00"},{"$f":"IF(F19=0,0,IF(N19=0,0,IF(N19<0.041666667,0,IF(L19=0,0,IF(H19=\"р\",0,N19-0.041666667)*72-SUMIFS($M$2:M18,$C$2:C18,C19,$D$2:D18,D19)))))","v":0.35},{"$f":"SUMIFS($L$2:L19,$C$2:C19,C19,$D$2:D19,D19)","v":"01:07:00"}]
[19,{"$f":"IF(AND(A20=0,C20>1),\"ПОМИЛКА\",IF(AND(F20=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",95,{"$f":"IF(D20=0,\" \",IF(IFERROR((VLOOKUP(D20,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D20,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D20,#REF!,3,0))<90,#REF!-(VLOOKUP(D20,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D20,#REF!,4,0))>0,(VLOOKUP(D20,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:13:00","15:20:00",{"$f":"IF(AND(J20>0,K20=0),#REF!-J20,IF((K20-J20)<0,\"ПОМИЛКА\",K20-J20))","v":"00:07:00"},{"$f":"IF(F20=0,0,IF(N20=0,0,IF(N20<0.041666667,0,IF(L20=0,0,IF(H20=\"р\",0,N20-0.041666667)*72-SUMIFS($M$2:M19,$C$2:C19,C20,$D$2:D19,D20)))))","v":0},{"$f":"SUMIFS($L$2:L20,$C$2:C20,C20,$D$2:D20,D20)","v":"00:07:00"}]
[20,{"$f":"IF(AND(A21=0,C21>1),\"ПОМИЛКА\",IF(AND(F21=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",355,{"$f":"IF(D21=0,\" \",IF(IFERROR((VLOOKUP(D21,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D21,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D21,#REF!,3,0))<90,#REF!-(VLOOKUP(D21,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D21,#REF!,4,0))>0,(VLOOKUP(D21,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:13:00","16:13:00",{"$f":"IF(AND(J21>0,K21=0),#REF!-J21,IF((K21-J21)<0,\"ПОМИЛКА\",K21-J21))","v":"01:00:00"},{"$f":"IF(F21=0,0,IF(N21=0,0,IF(N21<0.041666667,0,IF(L21=0,0,IF(H21=\"р\",0,N21-0.041666667)*72-SUMIFS($M$2:M20,$C$2:C20,C21,$D$2:D20,D21)))))","v":0},{"$f":"SUMIFS($L$2:L21,$C$2:C21,C21,$D$2:D21,D21)","v":"01:00:00"}]
[21,{"$f":"IF(AND(A22=0,C22>1),\"ПОМИЛКА\",IF(AND(F22=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",99,{"$f":"IF(D22=0,\" \",IF(IFERROR((VLOOKUP(D22,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D22,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D22,#REF!,3,0))<90,#REF!-(VLOOKUP(D22,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D22,#REF!,4,0))>0,(VLOOKUP(D22,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:30:00","16:40:00",{"$f":"IF(AND(J22>0,K22=0),#REF!-J22,IF((K22-J22)<0,\"ПОМИЛКА\",K22-J22))","v":"01:10:00"},{"$f":"IF(F22=0,0,IF(N22=0,0,IF(N22<0.041666667,0,IF(L22=0,0,IF(H22=\"р\",0,N22-0.041666667)*72-SUMIFS($M$2:M21,$C$2:C21,C22,$D$2:D21,D22)))))","v":0.5},{"$f":"SUMIFS($L$2:L22,$C$2:C22,C22,$D$2:D22,D22)","v":"01:10:00"}]
[22,{"$f":"IF(AND(A23=0,C23>1),\"ПОМИЛКА\",IF(AND(F23=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",47,{"$f":"IF(D23=0,\" \",IF(IFERROR((VLOOKUP(D23,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D23,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},10,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D23,#REF!,3,0))<90,#REF!-(VLOOKUP(D23,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D23,#REF!,4,0))>0,(VLOOKUP(D23,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:07:00","16:50:00",{"$f":"IF(AND(J23>0,K23=0),#REF!-J23,IF((K23-J23)<0,\"ПОМИЛКА\",K23-J23))","v":"00:43:00"},{"$f":"IF(F23=0,0,IF(N23=0,0,IF(N23<0.041666667,0,IF(L23=0,0,IF(H23=\"р\",0,N23-0.041666667)*72-SUMIFS($M$2:M22,$C$2:C22,C23,$D$2:D22,D23)))))","v":0},{"$f":"SUMIFS($L$2:L23,$C$2:C23,C23,$D$2:D23,D23)","v":"00:43:00"}]
[23,{"$f":"IF(AND(A24=0,C24>1),\"ПОМИЛКА\",IF(AND(F24=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",317,{"$f":"IF(D24=0,\" \",IF(IFERROR((VLOOKUP(D24,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D24,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},4,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D24,#REF!,3,0))<90,#REF!-(VLOOKUP(D24,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D24,#REF!,4,0))>0,(VLOOKUP(D24,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:07:00","17:07:00",{"$f":"IF(AND(J24>0,K24=0),#REF!-J24,IF((K24-J24)<0,\"ПОМИЛКА\",K24-J24))","v":"01:00:00"},{"$f":"IF(F24=0,0,IF(N24=0,0,IF(N24<0.041666667,0,IF(L24=0,0,IF(H24=\"р\",0,N24-0.041666667)*72-SUMIFS($M$2:M23,$C$2:C23,C24,$D$2:D23,D24)))))","v":0},{"$f":"SUMIFS($L$2:L24,$C$2:C24,C24,$D$2:D24,D24)","v":"01:00:00"}]
[24,{"$f":"IF(AND(A25=0,C25>1),\"ПОМИЛКА\",IF(AND(F25=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",372,{"$f":"IF(D25=0,\" \",IF(IFERROR((VLOOKUP(D25,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D25,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},3,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D25,#REF!,3,0))<90,#REF!-(VLOOKUP(D25,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D25,#REF!,4,0))>0,(VLOOKUP(D25,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},"Н","16:08:00","17:30:00",{"$f":"IF(AND(J25>0,K25=0),#REF!-J25,IF((K25-J25)<0,\"ПОМИЛКА\",K25-J25))","v":"01:22:00"},{"$f":"IF(F25=0,0,IF(N25=0,0,IF(N25<0.041666667,0,IF(L25=0,0,IF(H25=\"р\",0,N25-0.041666667)*72-SUMIFS($M$2:M24,$C$2:C24,C25,$D$2:D24,D25)))))","v":1.1000000000000001},{"$f":"SUMIFS($L$2:L25,$C$2:C25,C25,$D$2:D25,D25)","v":"01:22:00"}]
[25,{"$f":"IF(AND(A26=0,C26>1),\"ПОМИЛКА\",IF(AND(F26=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",76,{"$f":"IF(D26=0,\" \",IF(IFERROR((VLOOKUP(D26,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D26,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D26,#REF!,3,0))<90,#REF!-(VLOOKUP(D26,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D26,#REF!,4,0))>0,(VLOOKUP(D26,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:14:00","16:22:00",{"$f":"IF(AND(J26>0,K26=0),#REF!-J26,IF((K26-J26)<0,\"ПОМИЛКА\",K26-J26))","v":"00:08:00"},{"$f":"IF(F26=0,0,IF(N26=0,0,IF(N26<0.041666667,0,IF(L26=0,0,IF(H26=\"р\",0,N26-0.041666667)*72-SUMIFS($M$2:M25,$C$2:C25,C26,$D$2:D25,D26)))))","v":0},{"$f":"SUMIFS($L$2:L26,$C$2:C26,C26,$D$2:D26,D26)","v":"00:08:00"}]
[26,{"$f":"IF(AND(A27=0,C27>1),\"ПОМИЛКА\",IF(AND(F27=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",10,{"$f":"IF(D27=0,\" \",IF(IFERROR((VLOOKUP(D27,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D27,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},6,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D27,#REF!,3,0))<90,#REF!-(VLOOKUP(D27,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D27,#REF!,4,0))>0,(VLOOKUP(D27,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:23:00","17:20:00",{"$f":"IF(AND(J27>0,K27=0),#REF!-J27,IF((K27-J27)<0,\"ПОМИЛКА\",K27-J27))","v":"00:57:00"},{"$f":"IF(F27=0,0,IF(N27=0,0,IF(N27<0.041666667,0,IF(L27=0,0,IF(H27=\"р\",0,N27-0.041666667)*72-SUMIFS($M$2:M26,$C$2:C26,C27,$D$2:D26,D27)))))","v":0},{"$f":"SUMIFS($L$2:L27,$C$2:C27,C27,$D$2:D27,D27)","v":"00:57:00"}]
[27,{"$f":"IF(AND(A28=0,C28>1),\"ПОМИЛКА\",IF(AND(F28=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",76,{"$f":"IF(D28=0,\" \",IF(IFERROR((VLOOKUP(D28,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D28,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D28,#REF!,3,0))<90,#REF!-(VLOOKUP(D28,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D28,#REF!,4,0))>0,(VLOOKUP(D28,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:23:00","17:15:00",{"$f":"IF(AND(J28>0,K28=0),#REF!-J28,IF((K28-J28)<0,\"ПОМИЛКА\",K28-J28))","v":"00:52:00"},{"$f":"IF(F28=0,0,IF(N28=0,0,IF(N28<0.041666667,0,IF(L28=0,0,IF(H28=\"р\",0,N28-0.041666667)*72-SUMIFS($M$2:M27,$C$2:C27,C28,$D$2:D27,D28)))))","v":0},{"$f":"SUMIFS($L$2:L28,$C$2:C28,C28,$D$2:D28,D28)","v":"01:00:00"}]
[28,{"$f":"IF(AND(A29=0,C29>1),\"ПОМИЛКА\",IF(AND(F29=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",274,{"$f":"IF(D29=0,\" \",IF(IFERROR((VLOOKUP(D29,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D29,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},0,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D29,#REF!,3,0))<90,#REF!-(VLOOKUP(D29,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D29,#REF!,4,0))>0,(VLOOKUP(D29,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:24:00","18:00:00",{"$f":"IF(AND(J29>0,K29=0),#REF!-J29,IF((K29-J29)<0,\"ПОМИЛКА\",K29-J29))","v":"01:36:00"},{"$f":"IF(F29=0,0,IF(N29=0,0,IF(N29<0.041666667,0,IF(L29=0,0,IF(H29=\"р\",0,N29-0.041666667)*72-SUMIFS($M$2:M28,$C$2:C28,C29,$D$2:D28,D29)))))","v":0},{"$f":"SUMIFS($L$2:L29,$C$2:C29,C29,$D$2:D29,D29)","v":"01:36:00"}]
[29,{"$f":"IF(AND(A30=0,C30>1),\"ПОМИЛКА\",IF(AND(F30=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",165,{"$f":"IF(D30=0,\" \",IF(IFERROR((VLOOKUP(D30,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D30,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D30,#REF!,3,0))<90,#REF!-(VLOOKUP(D30,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D30,#REF!,4,0))>0,(VLOOKUP(D30,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:28:00","17:28:00",{"$f":"IF(AND(J30>0,K30=0),#REF!-J30,IF((K30-J30)<0,\"ПОМИЛКА\",K30-J30))","v":"01:00:00"},{"$f":"IF(F30=0,0,IF(N30=0,0,IF(N30<0.041666667,0,IF(L30=0,0,IF(H30=\"р\",0,N30-0.041666667)*72-SUMIFS($M$2:M29,$C$2:C29,C30,$D$2:D29,D30)))))","v":0},{"$f":"SUMIFS($L$2:L30,$C$2:C30,C30,$D$2:D30,D30)","v":"01:00:00"}]
[30,{"$f":"IF(AND(A31=0,C31>1),\"ПОМИЛКА\",IF(AND(F31=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",91,{"$f":"IF(D31=0,\" \",IF(IFERROR((VLOOKUP(D31,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D31,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D31,#REF!,3,0))<90,#REF!-(VLOOKUP(D31,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D31,#REF!,4,0))>0,(VLOOKUP(D31,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:49:00","17:49:00",{"$f":"IF(AND(J31>0,K31=0),#REF!-J31,IF((K31-J31)<0,\"ПОМИЛКА\",K31-J31))","v":"01:00:00"},{"$f":"IF(F31=0,0,IF(N31=0,0,IF(N31<0.041666667,0,IF(L31=0,0,IF(H31=\"р\",0,N31-0.041666667)*72-SUMIFS($M$2:M30,$C$2:C30,C31,$D$2:D30,D31)))))","v":0},{"$f":"SUMIFS($L$2:L31,$C$2:C31,C31,$D$2:D31,D31)","v":"01:00:00"}]
[31,{"$f":"IF(AND(A32=0,C32>1),\"ПОМИЛКА\",IF(AND(F32=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",171,{"$f":"IF(D32=0,\" \",IF(IFERROR((VLOOKUP(D32,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D32,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},10,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D32,#REF!,3,0))<90,#REF!-(VLOOKUP(D32,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D32,#REF!,4,0))>0,(VLOOKUP(D32,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:51:00","18:00:00",{"$f":"IF(AND(J32>0,K32=0),#REF!-J32,IF((K32-J32)<0,\"ПОМИЛКА\",K32-J32))","v":"01:09:00"},{"$f":"IF(F32=0,0,IF(N32=0,0,IF(N32<0.041666667,0,IF(L32=0,0,IF(H32=\"р\",0,N32-0.041666667)*72-SUMIFS($M$2:M31,$C$2:C31,C32,$D$2:D31,D32)))))","v":0.45},{"$f":"SUMIFS($L$2:L32,$C$2:C32,C32,$D$2:D32,D32)","v":"01:09:00"}]
[32,{"$f":"IF(AND(A33=0,C33>1),\"ПОМИЛКА\",IF(AND(F33=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",26,{"$f":"IF(D33=0,\" \",IF(IFERROR((VLOOKUP(D33,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D33,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D33,#REF!,3,0))<90,#REF!-(VLOOKUP(D33,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D33,#REF!,4,0))>0,(VLOOKUP(D33,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"17:15:00","17:35:00",{"$f":"IF(AND(J33>0,K33=0),#REF!-J33,IF((K33-J33)<0,\"ПОМИЛКА\",K33-J33))","v":"00:20:00"},{"$f":"IF(F33=0,0,IF(N33=0,0,IF(N33<0.041666667,0,IF(L33=0,0,IF(H33=\"р\",0,N33-0.041666667)*72-SUMIFS($M$2:M32,$C$2:C32,C33,$D$2:D32,D33)))))","v":1},{"$f":"SUMIFS($L$2:L33,$C$2:C33,C33,$D$2:D33,D33)","v":"01:20:00"}]
[33,{"$f":"IF(AND(A34=0,C34>1),\"ПОМИЛКА\",IF(AND(F34=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",194,{"$f":"IF(D34=0,\" \",IF(IFERROR((VLOOKUP(D34,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D34,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},4,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D34,#REF!,3,0))<90,#REF!-(VLOOKUP(D34,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D34,#REF!,4,0))>0,(VLOOKUP(D34,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"17:19:00","18:19:00",{"$f":"IF(AND(J34>0,K34=0),#REF!-J34,IF((K34-J34)<0,\"ПОМИЛКА\",K34-J34))","v":"01:00:00"},{"$f":"IF(F34=0,0,IF(N34=0,0,IF(N34<0.041666667,0,IF(L34=0,0,IF(H34=\"р\",0,N34-0.041666667)*72-SUMIFS($M$2:M33,$C$2:C33,C34,$D$2:D33,D34)))))","v":0},{"$f":"SUMIFS($L$2:L34,$C$2:C34,C34,$D$2:D34,D34)","v":"01:00:00"}]
[34,{"$f":"IF(AND(A35=0,C35>1),\"ПОМИЛКА\",IF(AND(F35=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",12,{"$f":"IF(D35=0,\" \",IF(IFERROR((VLOOKUP(D35,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D35,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D35,#REF!,3,0))<90,#REF!-(VLOOKUP(D35,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D35,#REF!,4,0))>0,(VLOOKUP(D35,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"17:27:00","18:27:00",{"$f":"IF(AND(J35>0,K35=0),#REF!-J35,IF((K35-J35)<0,\"ПОМИЛКА\",K35-J35))","v":"01:00:00"},{"$f":"IF(F35=0,0,IF(N35=0,0,IF(N35<0.041666667,0,IF(L35=0,0,IF(H35=\"р\",0,N35-0.041666667)*72-SUMIFS($M$2:M34,$C$2:C34,C35,$D$2:D34,D35)))))","v":0},{"$f":"SUMIFS($L$2:L35,$C$2:C35,C35,$D$2:D35,D35)","v":"01:00:00"}]
[35,{"$f":"IF(AND(A36=0,C36>1),\"ПОМИЛКА\",IF(AND(F36=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-01",25,{"$f":"IF(D36=0,\" \",IF(IFERROR((VLOOKUP(D36,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D36,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},3,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D36,#REF!,3,0))<90,#REF!-(VLOOKUP(D36,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D36,#REF!,4,0))>0,(VLOOKUP(D36,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"17:35:00","18:20:00",{"$f":"IF(AND(J36>0,K36=0),#REF!-J36,IF((K36-J36)<0,\"ПОМИЛКА\",K36-J36))","v":"00:45:00"},{"$f":"IF(F36=0,0,IF(N36=0,0,IF(N36<0.041666667,0,IF(L36=0,0,IF(H36=\"р\",0,N36-0.041666667)*72-SUMIFS($M$2:M35,$C$2:C35,C36,$D$2:D35,D36)))))","v":0},{"$f":"SUMIFS($L$2:L36,$C$2:C36,C36,$D$2:D36,D36)","v":"00:45:00"}]
[36,{"$f":"IF(AND(A37=0,C37>1),\"ПОМИЛКА\",IF(AND(F37=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",113,{"$f":"IF(D37=0,\" \",IF(IFERROR((VLOOKUP(D37,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D37,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D37,#REF!,3,0))<90,#REF!-(VLOOKUP(D37,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D37,#REF!,4,0))>0,(VLOOKUP(D37,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"09:38:00","10:33:00",{"$f":"IF(AND(J37>0,K37=0),#REF!-J37,IF((K37-J37)<0,\"ПОМИЛКА\",K37-J37))","v":"00:55:00"},{"$f":"IF(F37=0,0,IF(N37=0,0,IF(N37<0.041666667,0,IF(L37=0,0,IF(H37=\"р\",0,N37-0.041666667)*72-SUMIFS($M$2:M36,$C$2:C36,C37,$D$2:D36,D37)))))","v":0},{"$f":"SUMIFS($L$2:L37,$C$2:C37,C37,$D$2:D37,D37)","v":"00:55:00"}]
[37,{"$f":"IF(AND(A38=0,C38>1),\"ПОМИЛКА\",IF(AND(F38=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",169,{"$f":"IF(D38=0,\" \",IF(IFERROR((VLOOKUP(D38,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D38,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D38,#REF!,3,0))<90,#REF!-(VLOOKUP(D38,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D38,#REF!,4,0))>0,(VLOOKUP(D38,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:00:00","12:00:00",{"$f":"IF(AND(J38>0,K38=0),#REF!-J38,IF((K38-J38)<0,\"ПОМИЛКА\",K38-J38))","v":"01:00:00"},{"$f":"IF(F38=0,0,IF(N38=0,0,IF(N38<0.041666667,0,IF(L38=0,0,IF(H38=\"р\",0,N38-0.041666667)*72-SUMIFS($M$2:M37,$C$2:C37,C38,$D$2:D37,D38)))))","v":0},{"$f":"SUMIFS($L$2:L38,$C$2:C38,C38,$D$2:D38,D38)","v":"01:00:00"}]
[38,{"$f":"IF(AND(A39=0,C39>1),\"ПОМИЛКА\",IF(AND(F39=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",109,{"$f":"IF(D39=0,\" \",IF(IFERROR((VLOOKUP(D39,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D39,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D39,#REF!,3,0))<90,#REF!-(VLOOKUP(D39,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D39,#REF!,4,0))>0,(VLOOKUP(D39,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:59:00","12:46:00",{"$f":"IF(AND(J39>0,K39=0),#REF!-J39,IF((K39-J39)<0,\"ПОМИЛКА\",K39-J39))","v":"00:47:00"},{"$f":"IF(F39=0,0,IF(N39=0,0,IF(N39<0.041666667,0,IF(L39=0,0,IF(H39=\"р\",0,N39-0.041666667)*72-SUMIFS($M$2:M38,$C$2:C38,C39,$D$2:D38,D39)))))","v":0},{"$f":"SUMIFS($L$2:L39,$C$2:C39,C39,$D$2:D39,D39)","v":"00:47:00"}]
[39,{"$f":"IF(AND(A40=0,C40>1),\"ПОМИЛКА\",IF(AND(F40=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",28,{"$f":"IF(D40=0,\" \",IF(IFERROR((VLOOKUP(D40,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D40,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D40,#REF!,3,0))<90,#REF!-(VLOOKUP(D40,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D40,#REF!,4,0))>0,(VLOOKUP(D40,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"11:59:00","12:59:00",{"$f":"IF(AND(J40>0,K40=0),#REF!-J40,IF((K40-J40)<0,\"ПОМИЛКА\",K40-J40))","v":"01:00:00"},{"$f":"IF(F40=0,0,IF(N40=0,0,IF(N40<0.041666667,0,IF(L40=0,0,IF(H40=\"р\",0,N40-0.041666667)*72-SUMIFS($M$2:M39,$C$2:C39,C40,$D$2:D39,D40)))))","v":0},{"$f":"SUMIFS($L$2:L40,$C$2:C40,C40,$D$2:D40,D40)","v":"01:00:00"}]
[40,{"$f":"IF(AND(A41=0,C41>1),\"ПОМИЛКА\",IF(AND(F41=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",213,{"$f":"IF(D41=0,\" \",IF(IFERROR((VLOOKUP(D41,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D41,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D41,#REF!,3,0))<90,#REF!-(VLOOKUP(D41,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D41,#REF!,4,0))>0,(VLOOKUP(D41,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:46:00","13:42:00",{"$f":"IF(AND(J41>0,K41=0),#REF!-J41,IF((K41-J41)<0,\"ПОМИЛКА\",K41-J41))","v":"00:56:00"},{"$f":"IF(F41=0,0,IF(N41=0,0,IF(N41<0.041666667,0,IF(L41=0,0,IF(H41=\"р\",0,N41-0.041666667)*72-SUMIFS($M$2:M40,$C$2:C40,C41,$D$2:D40,D41)))))","v":0},{"$f":"SUMIFS($L$2:L41,$C$2:C41,C41,$D$2:D41,D41)","v":"00:56:00"}]
[41,{"$f":"IF(AND(A42=0,C42>1),\"ПОМИЛКА\",IF(AND(F42=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",78,{"$f":"IF(D42=0,\" \",IF(IFERROR((VLOOKUP(D42,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D42,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D42,#REF!,3,0))<90,#REF!-(VLOOKUP(D42,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D42,#REF!,4,0))>0,(VLOOKUP(D42,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"12:51:00","13:10:00",{"$f":"IF(AND(J42>0,K42=0),#REF!-J42,IF((K42-J42)<0,\"ПОМИЛКА\",K42-J42))","v":"00:19:00"},{"$f":"IF(F42=0,0,IF(N42=0,0,IF(N42<0.041666667,0,IF(L42=0,0,IF(H42=\"р\",0,N42-0.041666667)*72-SUMIFS($M$2:M41,$C$2:C41,C42,$D$2:D41,D42)))))","v":0},{"$f":"SUMIFS($L$2:L42,$C$2:C42,C42,$D$2:D42,D42)","v":"00:19:00"}]
[42,{"$f":"IF(AND(A43=0,C43>1),\"ПОМИЛКА\",IF(AND(F43=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",361,{"$f":"IF(D43=0,\" \",IF(IFERROR((VLOOKUP(D43,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D43,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},6,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D43,#REF!,3,0))<90,#REF!-(VLOOKUP(D43,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D43,#REF!,4,0))>0,(VLOOKUP(D43,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:00:00","13:50:00",{"$f":"IF(AND(J43>0,K43=0),#REF!-J43,IF((K43-J43)<0,\"ПОМИЛКА\",K43-J43))","v":"00:50:00"},{"$f":"IF(F43=0,0,IF(N43=0,0,IF(N43<0.041666667,0,IF(L43=0,0,IF(H43=\"р\",0,N43-0.041666667)*72-SUMIFS($M$2:M42,$C$2:C42,C43,$D$2:D42,D43)))))","v":0},{"$f":"SUMIFS($L$2:L43,$C$2:C43,C43,$D$2:D43,D43)","v":"00:50:00"}]
[43,{"$f":"IF(AND(A44=0,C44>1),\"ПОМИЛКА\",IF(AND(F44=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",344,{"$f":"IF(D44=0,\" \",IF(IFERROR((VLOOKUP(D44,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D44,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},4,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D44,#REF!,3,0))<90,#REF!-(VLOOKUP(D44,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D44,#REF!,4,0))>0,(VLOOKUP(D44,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:10:00","14:10:00",{"$f":"IF(AND(J44>0,K44=0),#REF!-J44,IF((K44-J44)<0,\"ПОМИЛКА\",K44-J44))","v":"01:00:00"},{"$f":"IF(F44=0,0,IF(N44=0,0,IF(N44<0.041666667,0,IF(L44=0,0,IF(H44=\"р\",0,N44-0.041666667)*72-SUMIFS($M$2:M43,$C$2:C43,C44,$D$2:D43,D44)))))","v":0},{"$f":"SUMIFS($L$2:L44,$C$2:C44,C44,$D$2:D44,D44)","v":"01:00:00"}]
[44,{"$f":"IF(AND(A45=0,C45>1),\"ПОМИЛКА\",IF(AND(F45=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",260,{"$f":"IF(D45=0,\" \",IF(IFERROR((VLOOKUP(D45,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D45,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D45,#REF!,3,0))<90,#REF!-(VLOOKUP(D45,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D45,#REF!,4,0))>0,(VLOOKUP(D45,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"13:20:00","14:17:00",{"$f":"IF(AND(J45>0,K45=0),#REF!-J45,IF((K45-J45)<0,\"ПОМИЛКА\",K45-J45))","v":"00:57:00"},{"$f":"IF(F45=0,0,IF(N45=0,0,IF(N45<0.041666667,0,IF(L45=0,0,IF(H45=\"р\",0,N45-0.041666667)*72-SUMIFS($M$2:M44,$C$2:C44,C45,$D$2:D44,D45)))))","v":0},{"$f":"SUMIFS($L$2:L45,$C$2:C45,C45,$D$2:D45,D45)","v":"00:57:00"}]
[45,{"$f":"IF(AND(A46=0,C46>1),\"ПОМИЛКА\",IF(AND(F46=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",39,{"$f":"IF(D46=0,\" \",IF(IFERROR((VLOOKUP(D46,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D46,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D46,#REF!,3,0))<90,#REF!-(VLOOKUP(D46,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D46,#REF!,4,0))>0,(VLOOKUP(D46,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:00:00","15:00:00",{"$f":"IF(AND(J46>0,K46=0),#REF!-J46,IF((K46-J46)<0,\"ПОМИЛКА\",K46-J46))","v":"01:00:00"},{"$f":"IF(F46=0,0,IF(N46=0,0,IF(N46<0.041666667,0,IF(L46=0,0,IF(H46=\"р\",0,N46-0.041666667)*72-SUMIFS($M$2:M45,$C$2:C45,C46,$D$2:D45,D46)))))","v":0},{"$f":"SUMIFS($L$2:L46,$C$2:C46,C46,$D$2:D46,D46)","v":"01:00:00"}]
[46,{"$f":"IF(AND(A47=0,C47>1),\"ПОМИЛКА\",IF(AND(F47=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",101,{"$f":"IF(D47=0,\" \",IF(IFERROR((VLOOKUP(D47,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D47,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D47,#REF!,3,0))<90,#REF!-(VLOOKUP(D47,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D47,#REF!,4,0))>0,(VLOOKUP(D47,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:00:00","14:22:00",{"$f":"IF(AND(J47>0,K47=0),#REF!-J47,IF((K47-J47)<0,\"ПОМИЛКА\",K47-J47))","v":"00:22:00"},{"$f":"IF(F47=0,0,IF(N47=0,0,IF(N47<0.041666667,0,IF(L47=0,0,IF(H47=\"р\",0,N47-0.041666667)*72-SUMIFS($M$2:M46,$C$2:C46,C47,$D$2:D46,D47)))))","v":0},{"$f":"SUMIFS($L$2:L47,$C$2:C47,C47,$D$2:D47,D47)","v":"00:22:00"}]
[47,{"$f":"IF(AND(A48=0,C48>1),\"ПОМИЛКА\",IF(AND(F48=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",261,{"$f":"IF(D48=0,\" \",IF(IFERROR((VLOOKUP(D48,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D48,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D48,#REF!,3,0))<90,#REF!-(VLOOKUP(D48,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D48,#REF!,4,0))>0,(VLOOKUP(D48,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:12:00","15:12:00",{"$f":"IF(AND(J48>0,K48=0),#REF!-J48,IF((K48-J48)<0,\"ПОМИЛКА\",K48-J48))","v":"01:00:00"},{"$f":"IF(F48=0,0,IF(N48=0,0,IF(N48<0.041666667,0,IF(L48=0,0,IF(H48=\"р\",0,N48-0.041666667)*72-SUMIFS($M$2:M47,$C$2:C47,C48,$D$2:D47,D48)))))","v":0},{"$f":"SUMIFS($L$2:L48,$C$2:C48,C48,$D$2:D48,D48)","v":"01:00:00"}]
[48,{"$f":"IF(AND(A49=0,C49>1),\"ПОМИЛКА\",IF(AND(F49=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",26,{"$f":"IF(D49=0,\" \",IF(IFERROR((VLOOKUP(D49,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D49,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D49,#REF!,3,0))<90,#REF!-(VLOOKUP(D49,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D49,#REF!,4,0))>0,(VLOOKUP(D49,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:17:00","15:17:00",{"$f":"IF(AND(J49>0,K49=0),#REF!-J49,IF((K49-J49)<0,\"ПОМИЛКА\",K49-J49))","v":"01:00:00"},{"$f":"IF(F49=0,0,IF(N49=0,0,IF(N49<0.041666667,0,IF(L49=0,0,IF(H49=\"р\",0,N49-0.041666667)*72-SUMIFS($M$2:M48,$C$2:C48,C49,$D$2:D48,D49)))))","v":0},{"$f":"SUMIFS($L$2:L49,$C$2:C49,C49,$D$2:D49,D49)","v":"01:00:00"}]
[49,{"$f":"IF(AND(A50=0,C50>1),\"ПОМИЛКА\",IF(AND(F50=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",269,{"$f":"IF(D50=0,\" \",IF(IFERROR((VLOOKUP(D50,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D50,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},4,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D50,#REF!,3,0))<90,#REF!-(VLOOKUP(D50,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D50,#REF!,4,0))>0,(VLOOKUP(D50,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:37:00","15:37:00",{"$f":"IF(AND(J50>0,K50=0),#REF!-J50,IF((K50-J50)<0,\"ПОМИЛКА\",K50-J50))","v":"01:00:00"},{"$f":"IF(F50=0,0,IF(N50=0,0,IF(N50<0.041666667,0,IF(L50=0,0,IF(H50=\"р\",0,N50-0.041666667)*72-SUMIFS($M$2:M49,$C$2:C49,C50,$D$2:D49,D50)))))","v":0},{"$f":"SUMIFS($L$2:L50,$C$2:C50,C50,$D$2:D50,D50)","v":"01:00:00"}]
[50,{"$f":"IF(AND(A51=0,C51>1),\"ПОМИЛКА\",IF(AND(F51=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",344,{"$f":"IF(D51=0,\" \",IF(IFERROR((VLOOKUP(D51,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D51,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},1,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D51,#REF!,3,0))<90,#REF!-(VLOOKUP(D51,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D51,#REF!,4,0))>0,(VLOOKUP(D51,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:37:00","14:45:00",{"$f":"IF(AND(J51>0,K51=0),#REF!-J51,IF((K51-J51)<0,\"ПОМИЛКА\",K51-J51))","v":"00:08:00"},{"$f":"IF(F51=0,0,IF(N51=0,0,IF(N51<0.041666667,0,IF(L51=0,0,IF(H51=\"р\",0,N51-0.041666667)*72-SUMIFS($M$2:M50,$C$2:C50,C51,$D$2:D50,D51)))))","v":0.4},{"$f":"SUMIFS($L$2:L51,$C$2:C51,C51,$D$2:D51,D51)","v":"01:08:00"}]
[51,{"$f":"IF(AND(A52=0,C52>1),\"ПОМИЛКА\",IF(AND(F52=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",115,{"$f":"IF(D52=0,\" \",IF(IFERROR((VLOOKUP(D52,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D52,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},6,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D52,#REF!,3,0))<90,#REF!-(VLOOKUP(D52,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D52,#REF!,4,0))>0,(VLOOKUP(D52,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:39:00","15:39:00",{"$f":"IF(AND(J52>0,K52=0),#REF!-J52,IF((K52-J52)<0,\"ПОМИЛКА\",K52-J52))","v":"01:00:00"},{"$f":"IF(F52=0,0,IF(N52=0,0,IF(N52<0.041666667,0,IF(L52=0,0,IF(H52=\"р\",0,N52-0.041666667)*72-SUMIFS($M$2:M51,$C$2:C51,C52,$D$2:D51,D52)))))","v":0},{"$f":"SUMIFS($L$2:L52,$C$2:C52,C52,$D$2:D52,D52)","v":"01:00:00"}]
[52,{"$f":"IF(AND(A53=0,C53>1),\"ПОМИЛКА\",IF(AND(F53=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",194,{"$f":"IF(D53=0,\" \",IF(IFERROR((VLOOKUP(D53,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D53,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},5,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D53,#REF!,3,0))<90,#REF!-(VLOOKUP(D53,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D53,#REF!,4,0))>0,(VLOOKUP(D53,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"14:47:00","15:47:00",{"$f":"IF(AND(J53>0,K53=0),#REF!-J53,IF((K53-J53)<0,\"ПОМИЛКА\",K53-J53))","v":"01:00:00"},{"$f":"IF(F53=0,0,IF(N53=0,0,IF(N53<0.041666667,0,IF(L53=0,0,IF(H53=\"р\",0,N53-0.041666667)*72-SUMIFS($M$2:M52,$C$2:C52,C53,$D$2:D52,D53)))))","v":0},{"$f":"SUMIFS($L$2:L53,$C$2:C53,C53,$D$2:D53,D53)","v":"01:00:00"}]
[53,{"$f":"IF(AND(A54=0,C54>1),\"ПОМИЛКА\",IF(AND(F54=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",12,{"$f":"IF(D54=0,\" \",IF(IFERROR((VLOOKUP(D54,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D54,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},3,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D54,#REF!,3,0))<90,#REF!-(VLOOKUP(D54,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D54,#REF!,4,0))>0,(VLOOKUP(D54,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:01:00","15:17:00",{"$f":"IF(AND(J54>0,K54=0),#REF!-J54,IF((K54-J54)<0,\"ПОМИЛКА\",K54-J54))","v":"00:16:00"},{"$f":"IF(F54=0,0,IF(N54=0,0,IF(N54<0.041666667,0,IF(L54=0,0,IF(H54=\"р\",0,N54-0.041666667)*72-SUMIFS($M$2:M53,$C$2:C53,C54,$D$2:D53,D54)))))","v":0},{"$f":"SUMIFS($L$2:L54,$C$2:C54,C54,$D$2:D54,D54)","v":"00:16:00"}]
[54,{"$f":"IF(AND(A55=0,C55>1),\"ПОМИЛКА\",IF(AND(F55=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",47,{"$f":"IF(D55=0,\" \",IF(IFERROR((VLOOKUP(D55,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D55,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},10,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D55,#REF!,3,0))<90,#REF!-(VLOOKUP(D55,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D55,#REF!,4,0))>0,(VLOOKUP(D55,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:01:00","16:01:00",{"$f":"IF(AND(J55>0,K55=0),#REF!-J55,IF((K55-J55)<0,\"ПОМИЛКА\",K55-J55))","v":"01:00:00"},{"$f":"IF(F55=0,0,IF(N55=0,0,IF(N55<0.041666667,0,IF(L55=0,0,IF(H55=\"р\",0,N55-0.041666667)*72-SUMIFS($M$2:M54,$C$2:C54,C55,$D$2:D54,D55)))))","v":0},{"$f":"SUMIFS($L$2:L55,$C$2:C55,C55,$D$2:D55,D55)","v":"01:00:00"}]
[55,{"$f":"IF(AND(A56=0,C56>1),\"ПОМИЛКА\",IF(AND(F56=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",373,{"$f":"IF(D56=0,\" \",IF(IFERROR((VLOOKUP(D56,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D56,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D56,#REF!,3,0))<90,#REF!-(VLOOKUP(D56,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D56,#REF!,4,0))>0,(VLOOKUP(D56,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},"П","15:18:00","15:27:00",{"$f":"IF(AND(J56>0,K56=0),#REF!-J56,IF((K56-J56)<0,\"ПОМИЛКА\",K56-J56))","v":"00:09:00"},{"$f":"IF(F56=0,0,IF(N56=0,0,IF(N56<0.041666667,0,IF(L56=0,0,IF(H56=\"р\",0,N56-0.041666667)*72-SUMIFS($M$2:M55,$C$2:C55,C56,$D$2:D55,D56)))))","v":0},{"$f":"SUMIFS($L$2:L56,$C$2:C56,C56,$D$2:D56,D56)","v":"00:09:00"}]
[56,{"$f":"IF(AND(A57=0,C57>1),\"ПОМИЛКА\",IF(AND(F57=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",4,{"$f":"IF(D57=0,\" \",IF(IFERROR((VLOOKUP(D57,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D57,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},3,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D57,#REF!,3,0))<90,#REF!-(VLOOKUP(D57,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D57,#REF!,4,0))>0,(VLOOKUP(D57,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:21:00","16:20:00",{"$f":"IF(AND(J57>0,K57=0),#REF!-J57,IF((K57-J57)<0,\"ПОМИЛКА\",K57-J57))","v":"00:59:00"},{"$f":"IF(F57=0,0,IF(N57=0,0,IF(N57<0.041666667,0,IF(L57=0,0,IF(H57=\"р\",0,N57-0.041666667)*72-SUMIFS($M$2:M56,$C$2:C56,C57,$D$2:D56,D57)))))","v":0},{"$f":"SUMIFS($L$2:L57,$C$2:C57,C57,$D$2:D57,D57)","v":"00:59:00"}]
[57,{"$f":"IF(AND(A58=0,C58>1),\"ПОМИЛКА\",IF(AND(F58=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",12,{"$f":"IF(D58=0,\" \",IF(IFERROR((VLOOKUP(D58,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D58,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D58,#REF!,3,0))<90,#REF!-(VLOOKUP(D58,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D58,#REF!,4,0))>0,(VLOOKUP(D58,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:27:00","16:10:00",{"$f":"IF(AND(J58>0,K58=0),#REF!-J58,IF((K58-J58)<0,\"ПОМИЛКА\",K58-J58))","v":"00:43:00"},{"$f":"IF(F58=0,0,IF(N58=0,0,IF(N58<0.041666667,0,IF(L58=0,0,IF(H58=\"р\",0,N58-0.041666667)*72-SUMIFS($M$2:M57,$C$2:C57,C58,$D$2:D57,D58)))))","v":0},{"$f":"SUMIFS($L$2:L58,$C$2:C58,C58,$D$2:D58,D58)","v":"00:59:00"}]
[58,{"$f":"IF(AND(A59=0,C59>1),\"ПОМИЛКА\",IF(AND(F59=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",26,{"$f":"IF(D59=0,\" \",IF(IFERROR((VLOOKUP(D59,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D59,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},7,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D59,#REF!,3,0))<90,#REF!-(VLOOKUP(D59,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D59,#REF!,4,0))>0,(VLOOKUP(D59,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:30:00","16:30:00",{"$f":"IF(AND(J59>0,K59=0),#REF!-J59,IF((K59-J59)<0,\"ПОМИЛКА\",K59-J59))","v":"01:00:00"},{"$f":"IF(F59=0,0,IF(N59=0,0,IF(N59<0.041666667,0,IF(L59=0,0,IF(H59=\"р\",0,N59-0.041666667)*72-SUMIFS($M$2:M58,$C$2:C58,C59,$D$2:D58,D59)))))","v":3},{"$f":"SUMIFS($L$2:L59,$C$2:C59,C59,$D$2:D59,D59)","v":"02:00:00"}]
[59,{"$f":"IF(AND(A60=0,C60>1),\"ПОМИЛКА\",IF(AND(F60=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",201,{"$f":"IF(D60=0,\" \",IF(IFERROR((VLOOKUP(D60,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D60,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D60,#REF!,3,0))<90,#REF!-(VLOOKUP(D60,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D60,#REF!,4,0))>0,(VLOOKUP(D60,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"15:51:00","16:36:00",{"$f":"IF(AND(J60>0,K60=0),#REF!-J60,IF((K60-J60)<0,\"ПОМИЛКА\",K60-J60))","v":"00:45:00"},{"$f":"IF(F60=0,0,IF(N60=0,0,IF(N60<0.041666667,0,IF(L60=0,0,IF(H60=\"р\",0,N60-0.041666667)*72-SUMIFS($M$2:M59,$C$2:C59,C60,$D$2:D59,D60)))))","v":0},{"$f":"SUMIFS($L$2:L60,$C$2:C60,C60,$D$2:D60,D60)","v":"00:45:00"}]
[60,{"$f":"IF(AND(A61=0,C61>1),\"ПОМИЛКА\",IF(AND(F61=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",341,{"$f":"IF(D61=0,\" \",IF(IFERROR((VLOOKUP(D61,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D61,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},9,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D61,#REF!,3,0))<90,#REF!-(VLOOKUP(D61,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D61,#REF!,4,0))>0,(VLOOKUP(D61,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:37:00","17:37:00",{"$f":"IF(AND(J61>0,K61=0),#REF!-J61,IF((K61-J61)<0,\"ПОМИЛКА\",K61-J61))","v":"01:00:00"},{"$f":"IF(F61=0,0,IF(N61=0,0,IF(N61<0.041666667,0,IF(L61=0,0,IF(H61=\"р\",0,N61-0.041666667)*72-SUMIFS($M$2:M60,$C$2:C60,C61,$D$2:D60,D61)))))","v":0},{"$f":"SUMIFS($L$2:L61,$C$2:C61,C61,$D$2:D61,D61)","v":"01:00:00"}]
[61,{"$f":"IF(AND(A62=0,C62>1),\"ПОМИЛКА\",IF(AND(F62=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",342,{"$f":"IF(D62=0,\" \",IF(IFERROR((VLOOKUP(D62,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D62,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},6,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D62,#REF!,3,0))<90,#REF!-(VLOOKUP(D62,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D62,#REF!,4,0))>0,(VLOOKUP(D62,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:37:00","17:37:00",{"$f":"IF(AND(J62>0,K62=0),#REF!-J62,IF((K62-J62)<0,\"ПОМИЛКА\",K62-J62))","v":"01:00:00"},{"$f":"IF(F62=0,0,IF(N62=0,0,IF(N62<0.041666667,0,IF(L62=0,0,IF(H62=\"р\",0,N62-0.041666667)*72-SUMIFS($M$2:M61,$C$2:C61,C62,$D$2:D61,D62)))))","v":0},{"$f":"SUMIFS($L$2:L62,$C$2:C62,C62,$D$2:D62,D62)","v":"01:00:00"}]
[62,{"$f":"IF(AND(A63=0,C63>1),\"ПОМИЛКА\",IF(AND(F63=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",12,{"$f":"IF(D63=0,\" \",IF(IFERROR((VLOOKUP(D63,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D63,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D63,#REF!,3,0))<90,#REF!-(VLOOKUP(D63,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D63,#REF!,4,0))>0,(VLOOKUP(D63,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:40:00","17:00:00",{"$f":"IF(AND(J63>0,K63=0),#REF!-J63,IF((K63-J63)<0,\"ПОМИЛКА\",K63-J63))","v":"00:20:00"},{"$f":"IF(F63=0,0,IF(N63=0,0,IF(N63<0.041666667,0,IF(L63=0,0,IF(H63=\"р\",0,N63-0.041666667)*72-SUMIFS($M$2:M62,$C$2:C62,C63,$D$2:D62,D63)))))","v":0.95},{"$f":"SUMIFS($L$2:L63,$C$2:C63,C63,$D$2:D63,D63)","v":"01:19:00"}]
[63,{"$f":"IF(AND(A64=0,C64>1),\"ПОМИЛКА\",IF(AND(F64=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",312,{"$f":"IF(D64=0,\" \",IF(IFERROR((VLOOKUP(D64,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D64,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},10,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D64,#REF!,3,0))<90,#REF!-(VLOOKUP(D64,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D64,#REF!,4,0))>0,(VLOOKUP(D64,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:40:00","17:37:00",{"$f":"IF(AND(J64>0,K64=0),#REF!-J64,IF((K64-J64)<0,\"ПОМИЛКА\",K64-J64))","v":"00:57:00"},{"$f":"IF(F64=0,0,IF(N64=0,0,IF(N64<0.041666667,0,IF(L64=0,0,IF(H64=\"р\",0,N64-0.041666667)*72-SUMIFS($M$2:M63,$C$2:C63,C64,$D$2:D63,D64)))))","v":0},{"$f":"SUMIFS($L$2:L64,$C$2:C64,C64,$D$2:D64,D64)","v":"00:57:00"}]
[64,{"$f":"IF(AND(A65=0,C65>1),\"ПОМИЛКА\",IF(AND(F65=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",317,{"$f":"IF(D65=0,\" \",IF(IFERROR((VLOOKUP(D65,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D65,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},5,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D65,#REF!,3,0))<90,#REF!-(VLOOKUP(D65,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D65,#REF!,4,0))>0,(VLOOKUP(D65,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:43:00","17:43:00",{"$f":"IF(AND(J65>0,K65=0),#REF!-J65,IF((K65-J65)<0,\"ПОМИЛКА\",K65-J65))","v":"01:00:00"},{"$f":"IF(F65=0,0,IF(N65=0,0,IF(N65<0.041666667,0,IF(L65=0,0,IF(H65=\"р\",0,N65-0.041666667)*72-SUMIFS($M$2:M64,$C$2:C64,C65,$D$2:D64,D65)))))","v":0},{"$f":"SUMIFS($L$2:L65,$C$2:C65,C65,$D$2:D65,D65)","v":"01:00:00"}]
[65,{"$f":"IF(AND(A66=0,C66>1),\"ПОМИЛКА\",IF(AND(F66=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",338,{"$f":"IF(D66=0,\" \",IF(IFERROR((VLOOKUP(D66,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D66,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},3,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D66,#REF!,3,0))<90,#REF!-(VLOOKUP(D66,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D66,#REF!,4,0))>0,(VLOOKUP(D66,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"16:43:00","17:33:00",{"$f":"IF(AND(J66>0,K66=0),#REF!-J66,IF((K66-J66)<0,\"ПОМИЛКА\",K66-J66))","v":"00:50:00"},{"$f":"IF(F66=0,0,IF(N66=0,0,IF(N66<0.041666667,0,IF(L66=0,0,IF(H66=\"р\",0,N66-0.041666667)*72-SUMIFS($M$2:M65,$C$2:C65,C66,$D$2:D65,D66)))))","v":0},{"$f":"SUMIFS($L$2:L66,$C$2:C66,C66,$D$2:D66,D66)","v":"00:50:00"}]
[66,{"$f":"IF(AND(A67=0,C67>1),\"ПОМИЛКА\",IF(AND(F67=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",76,{"$f":"IF(D67=0,\" \",IF(IFERROR((VLOOKUP(D67,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D67,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},8,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D67,#REF!,3,0))<90,#REF!-(VLOOKUP(D67,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D67,#REF!,4,0))>0,(VLOOKUP(D67,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"17:32:00","18:32:00",{"$f":"IF(AND(J67>0,K67=0),#REF!-J67,IF((K67-J67)<0,\"ПОМИЛКА\",K67-J67))","v":"01:00:00"},{"$f":"IF(F67=0,0,IF(N67=0,0,IF(N67<0.041666667,0,IF(L67=0,0,IF(H67=\"р\",0,N67-0.041666667)*72-SUMIFS($M$2:M66,$C$2:C66,C67,$D$2:D66,D67)))))","v":0},{"$f":"SUMIFS($L$2:L67,$C$2:C67,C67,$D$2:D67,D67)","v":"01:00:00"}]
[{"$f":"IF(AND(A67-A66=1, C68>0), SUM(A67+1), 0)","v":67},{"$f":"IF(AND(A68=0,C68>1),\"ПОМИЛКА\",IF(AND(F68=0,#REF!=\"РОБОТА\"),\"WI-FI\",IF(#REF!=\"РОБОТА\",\"РОБОТА\",\" \")))","v":{"$error":"#REF!"}},"2015-04-02",22,{"$f":"IF(D68=0,\" \",IF(IFERROR((VLOOKUP(D68,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")=0,\"ЗАПОЛНИ БАЗУ\",IFERROR((VLOOKUP(D68,#REF!,2,0)),\"ЗАПОЛНИ БАЗУ\")))","v":"ЗАПОЛНИ БАЗУ"},2,{"$f":"IFERROR(IF(#REF!-(VLOOKUP(D68,#REF!,3,0))<90,#REF!-(VLOOKUP(D68,#REF!,3,0)),\"ПОМИЛКА\"),\" \")","v":" "},{"$f":"IFERROR(IF((VLOOKUP(D68,#REF!,4,0))>0,(VLOOKUP(D68,#REF!,4,0)),\"ПОМИЛКА\"),\" \")","v":" "},null,"17:37:00","18:00:00",{"$f":"IF(AND(J68>0,K68=0),#REF!-J68,IF((K68-J68)<0,\"ПОМИЛКА\",K68-J68))","v":"00:23:00"},{"$f":"IF(F68=0,0,IF(N68=0,0,IF(N68<0.041666667,0,IF(L68=0,0,IF(H68=\"р\",0,N68-0.041666667)*72-SUMIFS($M$2:M67,$C$2:C67,C68,$D$2:D67,D68)))))","v":0},{"$f":"SUMIFS($L$2:L68,$C$2:C68,C68,$D$2:D68,D68)","v":"00:23:00"}]

{"sheet":"СТАТИСТИКА","index":2,"n_rows":9,"n_cols":33,"rows_kept":9,"cut":false,"hidden":false,"merged":[[6,0,6,1],[7,0,7,1],[8,0,8,1],[1,2,1,32],[3,0,3,1],[4,0,4,1],[5,0,5,1]]}
[null,null,null,null,null,null,null,null,null,"ДВССЫЛ(\"'\"B23\"'!$C$19:$C$3001\")"]
["РІК",2015,"СТАТИСТИЧНІ ДАНІ"]
["МІСЯЦЬ",3]
["День неділі",null,{"$f":"WEEKDAY(C5,1)","v":"1900-01-01"},{"$f":"WEEKDAY(D5,1)","v":"1900-01-02"},{"$f":"WEEKDAY(E5,1)","v":"1900-01-03"},{"$f":"WEEKDAY(F5,1)","v":"1900-01-04"},{"$f":"WEEKDAY(G5,1)","v":"1900-01-05"},{"$f":"WEEKDAY(H5,1)","v":"1900-01-06"},{"$f":"WEEKDAY(I5,1)","v":"1900-01-07"},{"$f":"WEEKDAY(J5,1)","v":"1900-01-01"},{"$f":"WEEKDAY(K5,1)","v":"1900-01-02"},{"$f":"WEEKDAY(L5,1)","v":"1900-01-03"},{"$f":"WEEKDAY(M5,1)","v":"1900-01-04"},{"$f":"WEEKDAY(N5,1)","v":"1900-01-05"},{"$f":"WEEKDAY(O5,1)","v":"1900-01-06"},{"$f":"WEEKDAY(P5,1)","v":"1900-01-07"},{"$f":"WEEKDAY(Q5,1)","v":"1900-01-01"},{"$f":"WEEKDAY(R5,1)","v":"1900-01-02"},{"$f":"WEEKDAY(S5,1)","v":"1900-01-03"},{"$f":"WEEKDAY(T5,1)","v":"1900-01-04"},{"$f":"WEEKDAY(U5,1)","v":"1900-01-05"},{"$f":"WEEKDAY(V5,1)","v":"1900-01-06"},{"$f":"WEEKDAY(W5,1)","v":"1900-01-07"},{"$f":"WEEKDAY(X5,1)","v":"1900-01-01"},{"$f":"WEEKDAY(Y5,1)","v":"1900-01-02"},{"$f":"WEEKDAY(Z5,1)","v":"1900-01-03"},{"$f":"WEEKDAY(AA5,1)","v":"1900-01-04"},{"$f":"WEEKDAY(AB5,1)","v":"1900-01-05"},{"$f":"WEEKDAY(AC5,1)","v":"1900-01-06"},{"$f":"WEEKDAY(AD5,1)","v":"1900-01-07"},{"$f":"WEEKDAY(AE5,1)","v":"1900-01-01"},{"$f":"WEEKDAY(AF5,1)","v":"1900-01-02"},{"$f":"WEEKDAY(AG5,1)","v":"1900-01-03"}]
["число місяця",null,{"$f":"(\"1.\"&B3&\".\"&B2)*1","v":"2015-03-01"},{"$f":"C5+1","v":"2015-03-02"},{"$f":"D5+1","v":"2015-03-03"},"2015-03-04","2015-03-05","2015-03-06","2015-03-07","2015-03-08","2015-03-09","2015-03-10","2015-03-11","2015-03-12","2015-03-13","2015-03-14","2015-03-15","2015-03-16","2015-03-17","2015-03-18","2015-03-19","2015-03-20","2015-03-21","2015-03-22","2015-03-23","2015-03-24","2015-03-25","2015-03-26","2015-03-27","2015-03-28","2015-03-29","2015-03-30","2015-03-31"]
["циклов",null,{"$f":"COUNTIF(INDIRECT(\"'\"&$B$3&\"_\"&RIGHTB($B$2,2)&\"'!C3:C68\"),C5)","v":48},{"$f":"COUNTIF('4_15'!$C$3:$C$68,D5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,E5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,F5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,G5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,H5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,I5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,J5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,K5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,L5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,M5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,N5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,O5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,P5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,Q5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,R5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,S5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,T5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,U5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,V5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,W5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,X5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,Y5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,Z5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,AA5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,AB5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,AC5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,AD5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,AE5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,AF5)","v":0},{"$f":"COUNTIF('4_15'!$C$3:$C$68,AG5)","v":0}]
["работников",null,{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=C5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=C5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=D5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=D5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=E5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=E5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=F5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=F5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=G5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=G5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=H5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=H5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=I5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=I5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=J5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=J5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=K5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=K5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=L5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=L5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=M5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=M5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=N5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=N5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=O5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=O5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=P5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=P5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=Q5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=Q5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=R5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=R5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=S5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=S5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=T5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=T5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=U5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=U5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=V5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=V5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=W5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=W5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=X5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=X5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=Y5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=Y5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=Z5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=Z5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AA5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AA5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AB5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AB5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AC5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AC5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AD5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AD5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AE5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AE5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AF5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AF5))>0,1))-1","v":0},{"$f":"SUM(IF(FREQUENCY('4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AG5),'4_15'!$D$3:$D$68*('4_15'!$C$3:$C$68=AG5))>0,1))-1","v":0}]
[" документів",null,{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,C5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,D5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,E5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,F5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,G5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,H5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,I5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,J5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,K5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,L5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,M5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,N5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,O5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,P5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,Q5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,R5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,S5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,T5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,U5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,V5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,W5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,X5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,Y5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,Z5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,AA5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,AB5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,AC5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,AD5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,AE5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,AF5)","v":0},{"$f":"COUNTIFS('4_15'!$I$2:$I$68,\"*\",'4_15'!$C$2:$C$68,AG5)","v":0}]
["Годин всього",null,{"$f":"SUMIF('4_15'!$C$3:$C$68,C5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,D5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,E5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,F5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,G5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,H5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,I5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,J5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,K5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,L5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,M5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,N5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,O5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,P5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,Q5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,R5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,S5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,T5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,U5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,V5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,W5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,X5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,Y5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,Z5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,AA5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,AB5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,AC5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,AD5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,AE5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,AF5,'4_15'!$L$3:$L$68)","v":0},{"$f":"SUMIF('4_15'!$C$3:$C$68,AG5,'4_15'!$L$3:$L$68)","v":0}]