{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Лист2","Доп.данные","Магазин №1","Магазин №2","ОБОРОТ","Лист4"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":"Лист2","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Цвета",null,"Их Номера","Их Названия","с 2007 и далее","Ранее2007"]
[null,null,null,{"$f":"НомерЦветаЯчейки(B10)","v":192},"Тёмно-красный",{"$f":"Cell_Color(B10,0)","v":192},{"$f":"Cell_Color(B10,1)","v":3}]
[null,null,null,{"$f":"НомерЦветаЯчейки(B11)","v":255},"Красный",{"$f":"Cell_Color(B11)","v":255},3]
[null,null,null,49407,"Оранжевый",49407,44]
[null,null,null,65535,"Жёлтый",65535,6]
[null,null,null,5296274,"светло-зелёный",5296274,43]
[null,null,null,5287936,"Зелёный",5287936,14]
[null,null,null,15773696,"светло-синий",15773696,33]
[null,null,null,12611584,"Синий",12611584,23]
[null,null,null,6299648,"тёмно-синий",6299648,49]
[null,null,null,10498160,"Лиловый",10498160,47]
[null,null,null,16777215,"Белый - нет заливки",16777215,-4142]
[null,null,null,0,"Черный",0,1]
[null,null,null,16777215]

{"sheet":"Доп.данные","index":1,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"МЕСЯЦ",4,{"$f":"IF(LEN(C2)=1,TEXT(0&C2&\".\"&C3,\"ММММ\"),TEXT(C2&\".\"&C3,\"ММММ\"))","v":"Апрель"}]
[null,"ГОД",2018]
[]
["ФУНКЦИЯ","№","ФИО","ПОДРАЗДЕЛЕНИЕ","ПРЕМИЯ"]
[]
["ТУРИСТ",1,"Пупок Степанов",null,200]
[]
["ДОРОГА",1,"Иванов Иван","Магазин №1",250]
[null,2]
[null,3]
[null,4]
[null,5,null,null,{"$f":"IF(C13>0,250,\"\")","v":""}]
[]
["Бонус",1,"Серджио Соко","Магазин №2",150]
[null,2]
[null,3]
[null,4]
[null,5]

{"sheet":"Магазин №1","index":2,"n_rows":26,"n_cols":42,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,{"$f":"IF(LEN(J6)=1,CONCATENATE(\"0\",J6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(J6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"01.4.2018"},{"$f":"IF(LEN(K6)=1,CONCATENATE(\"0\",K6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(K6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"02.4.2018"},{"$f":"IF(LEN(L6)=1,CONCATENATE(\"0\",L6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(L6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"03.4.2018"},{"$f":"IF(LEN(M6)=1,CONCATENATE(\"0\",M6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(M6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"04.4.2018"},{"$f":"IF(LEN(N6)=1,CONCATENATE(\"0\",N6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(N6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"05.4.2018"},{"$f":"IF(LEN(O6)=1,CONCATENATE(\"0\",O6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(O6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"06.4.2018"},{"$f":"IF(LEN(P6)=1,CONCATENATE(\"0\",P6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(P6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"07.4.2018"},{"$f":"IF(LEN(Q6)=1,CONCATENATE(\"0\",Q6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(Q6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"08.4.2018"},{"$f":"IF(LEN(R6)=1,CONCATENATE(\"0\",R6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(R6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"09.4.2018"},{"$f":"IF(LEN(S6)=1,CONCATENATE(\"0\",S6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(S6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"10.4.2018"},{"$f":"IF(LEN(T6)=1,CONCATENATE(\"0\",T6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(T6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"11.4.2018"},{"$f":"IF(LEN(U6)=1,CONCATENATE(\"0\",U6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(U6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"12.4.2018"},{"$f":"IF(LEN(V6)=1,CONCATENATE(\"0\",V6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(V6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"13.4.2018"},{"$f":"IF(LEN(W6)=1,CONCATENATE(\"0\",W6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(W6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"14.4.2018"},{"$f":"IF(LEN(X6)=1,CONCATENATE(\"0\",X6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(X6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"15.4.2018"},{"$f":"IF(LEN(Y6)=1,CONCATENATE(\"0\",Y6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(Y6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"16.4.2018"},{"$f":"IF(LEN(Z6)=1,CONCATENATE(\"0\",Z6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(Z6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"17.4.2018"},{"$f":"IF(LEN(AA6)=1,CONCATENATE(\"0\",AA6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AA6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"18.4.2018"},{"$f":"IF(LEN(AB6)=1,CONCATENATE(\"0\",AB6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AB6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"19.4.2018"},{"$f":"IF(LEN(AC6)=1,CONCATENATE(\"0\",AC6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AC6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"20.4.2018"},{"$f":"IF(LEN(AD6)=1,CONCATENATE(\"0\",AD6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AD6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"21.4.2018"},{"$f":"IF(LEN(AE6)=1,CONCATENATE(\"0\",AE6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AE6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"22.4.2018"},{"$f":"IF(LEN(AF6)=1,CONCATENATE(\"0\",AF6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AF6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"23.4.2018"},{"$f":"IF(LEN(AG6)=1,CONCATENATE(\"0\",AG6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AG6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"24.4.2018"},{"$f":"IF(LEN(AH6)=1,CONCATENATE(\"0\",AH6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AH6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"25.4.2018"},{"$f":"IF(LEN(AI6)=1,CONCATENATE(\"0\",AI6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AI6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"26.4.2018"},{"$f":"IF(LEN(AJ6)=1,CONCATENATE(\"0\",AJ6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AJ6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"27.4.2018"},{"$f":"IF(LEN(AK6)=1,CONCATENATE(\"0\",AK6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AK6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"28.4.2018"},{"$f":"IF(LEN(AL6)=1,CONCATENATE(\"0\",AL6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AL6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"29.4.2018"},{"$f":"IF(LEN(AM6)=1,CONCATENATE(\"0\",AM6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AM6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"30.4.2018"},{"$f":"IF(LEN(AN6)=1,CONCATENATE(\"0\",AN6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3),CONCATENATE(AN6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3))","v":"31.4.2018"}]
[null,"Отчетный период",null,null,null,null,null,null,"П1",{"$f":"IFERROR(INDEX(ОБОРОТ!C4:C23,MATCH('Магазин №1'!$A$5&J4&'Магазин №1'!J6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!C1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!D4:D23,MATCH('Магазин №1'!$A$5&K4&'Магазин №1'!K6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!D1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!E4:E23,MATCH('Магазин №1'!$A$5&L4&'Магазин №1'!L6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!E1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!F4:F23,MATCH('Магазин №1'!$A$5&M4&'Магазин №1'!M6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!F1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!G4:G23,MATCH('Магазин №1'!$A$5&N4&'Магазин №1'!N6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!G1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!H4:H23,MATCH('Магазин №1'!$A$5&O4&'Магазин №1'!O6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!H1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!I4:I23,MATCH('Магазин №1'!$A$5&P4&'Магазин №1'!P6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!I1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!J4:J23,MATCH('Магазин №1'!$A$5&Q4&'Магазин №1'!Q6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!J1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!K4:K23,MATCH('Магазин №1'!$A$5&R4&'Магазин №1'!R6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!K1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!L4:L23,MATCH('Магазин №1'!$A$5&S4&'Магазин №1'!S6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!L1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!M4:M23,MATCH('Магазин №1'!$A$5&T4&'Магазин №1'!T6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!M1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!N4:N23,MATCH('Магазин №1'!$A$5&U4&'Магазин №1'!U6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!N1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!O4:O23,MATCH('Магазин №1'!$A$5&V4&'Магазин №1'!V6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!O1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!P4:P23,MATCH('Магазин №1'!$A$5&W4&'Магазин №1'!W6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!P1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Q4:Q23,MATCH('Магазин №1'!$A$5&X4&'Магазин №1'!X6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!Q1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!R4:R23,MATCH('Магазин №1'!$A$5&Y4&'Магазин №1'!Y6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!R1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!S4:S23,MATCH('Магазин №1'!$A$5&Z4&'Магазин №1'!Z6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!S1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!T4:T23,MATCH('Магазин №1'!$A$5&AA4&'Магазин №1'!AA6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!T1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!U4:U23,MATCH('Магазин №1'!$A$5&AB4&'Магазин №1'!AB6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!U1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!V4:V23,MATCH('Магазин №1'!$A$5&AC4&'Магазин №1'!AC6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!V1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!W4:W23,MATCH('Магазин №1'!$A$5&AD4&'Магазин №1'!AD6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!W1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!X4:X23,MATCH('Магазин №1'!$A$5&AE4&'Магазин №1'!AE6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!X1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Y4:Y23,MATCH('Магазин №1'!$A$5&AF4&'Магазин №1'!AF6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!Y1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Z4:Z23,MATCH('Магазин №1'!$A$5&AG4&'Магазин №1'!AG6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!Z1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AA4:AA23,MATCH('Магазин №1'!$A$5&AH4&'Магазин №1'!AH6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AA1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AB4:AB23,MATCH('Магазин №1'!$A$5&AI4&'Магазин №1'!AI6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AB1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AC4:AC23,MATCH('Магазин №1'!$A$5&AJ4&'Магазин №1'!AJ6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AC1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AD4:AD23,MATCH('Магазин №1'!$A$5&AK4&'Магазин №1'!AK6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AD1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AE4:AE23,MATCH('Магазин №1'!$A$5&AL4&'Магазин №1'!AL6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AE1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AF4:AF23,MATCH('Магазин №1'!$A$5&AM4&'Магазин №1'!AM6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AF1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AG4:AG23,MATCH('Магазин №1'!$A$5&AN4&'Магазин №1'!AN6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AG1,0)),\"\")","v":""}]
[null,{"$f":"Доп.данные!D2","v":"Апрель"},null,null,null,null,null,null,"П2",{"$f":"IFERROR(INDEX(ОБОРОТ!C29:C38,MATCH('Магазин №1'!$A$5&J4&'Магазин №1'!J6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!C26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!D29:D38,MATCH('Магазин №1'!$A$5&K4&'Магазин №1'!K6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!D26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!E29:E38,MATCH('Магазин №1'!$A$5&L4&'Магазин №1'!L6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!E26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!F29:F38,MATCH('Магазин №1'!$A$5&M4&'Магазин №1'!M6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!F26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!G29:G38,MATCH('Магазин №1'!$A$5&N4&'Магазин №1'!N6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!G26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!H29:H38,MATCH('Магазин №1'!$A$5&O4&'Магазин №1'!O6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!H26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!I29:I38,MATCH('Магазин №1'!$A$5&P4&'Магазин №1'!P6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!I26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!J29:J38,MATCH('Магазин №1'!$A$5&Q4&'Магазин №1'!Q6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!J26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!K29:K38,MATCH('Магазин №1'!$A$5&R4&'Магазин №1'!R6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!K26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!L29:L38,MATCH('Магазин №1'!$A$5&S4&'Магазин №1'!S6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!L26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!M29:M38,MATCH('Магазин №1'!$A$5&T4&'Магазин №1'!T6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!M26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!N29:N38,MATCH('Магазин №1'!$A$5&U4&'Магазин №1'!U6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!N26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!O29:O38,MATCH('Магазин №1'!$A$5&V4&'Магазин №1'!V6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!O26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!P29:P38,MATCH('Магазин №1'!$A$5&W4&'Магазин №1'!W6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!P26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Q29:Q38,MATCH('Магазин №1'!$A$5&X4&'Магазин №1'!X6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!Q26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!R29:R38,MATCH('Магазин №1'!$A$5&Y4&'Магазин №1'!Y6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!R26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!S29:S38,MATCH('Магазин №1'!$A$5&Z4&'Магазин №1'!Z6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!S26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!T29:T38,MATCH('Магазин №1'!$A$5&AA4&'Магазин №1'!AA6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!T26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!U29:U38,MATCH('Магазин №1'!$A$5&AB4&'Магазин №1'!AB6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!U26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!V29:V38,MATCH('Магазин №1'!$A$5&AC4&'Магазин №1'!AC6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!V26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!W29:W38,MATCH('Магазин №1'!$A$5&AD4&'Магазин №1'!AD6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!W26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!X29:X38,MATCH('Магазин №1'!$A$5&AE4&'Магазин №1'!AE6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!X26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Y29:Y38,MATCH('Магазин №1'!$A$5&AF4&'Магазин №1'!AF6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!Y26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Z29:Z38,MATCH('Магазин №1'!$A$5&AG4&'Магазин №1'!AG6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!Z26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AA29:AA38,MATCH('Магазин №1'!$A$5&AH4&'Магазин №1'!AH6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AA26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AB29:AB38,MATCH('Магазин №1'!$A$5&AI4&'Магазин №1'!AI6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AB26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AC29:AC38,MATCH('Магазин №1'!$A$5&AJ4&'Магазин №1'!AJ6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AC26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AD29:AD38,MATCH('Магазин №1'!$A$5&AK4&'Магазин №1'!AK6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AD26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AE29:AE38,MATCH('Магазин №1'!$A$5&AL4&'Магазин №1'!AL6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AE26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AF29:AF38,MATCH('Магазин №1'!$A$5&AM4&'Магазин №1'!AM6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AF26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AG29:AG38,MATCH('Магазин №1'!$A$5&AN4&'Магазин №1'!AN6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AG26,0)),\"\")","v":""}]
[null,{"$f":"Доп.данные!C3","v":2018}]
[{"$f":"INDEX(Лист4!$AB$2:$AB$26,MATCH('Магазин №1'!$B$5,Лист4!$Z$2:$Z$26,0))","v":"ЦБ000048"},"Магазин №1",{"$f":"TEXT(C6,\"ДДД\")","v":"Пн"},"Вт","Ср","Чт","Пт",{"$f":"TEXT(H6,\"ДДД\")","v":"Сб"},null,{"$f":"TEXT(J1,\"ДДД\")","v":"Вс"},{"$f":"TEXT(K1,\"ДДД\")","v":"Пн"},"Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","31.4.2018"]
["№","ФИО",{"$f":"D6-1","v":"2018-03-26"},"2018-03-27","2018-03-28","2018-03-29",{"$f":"H6-1","v":"2018-03-30"},{"$f":"J1-1","v":"2018-03-31"},"Группа",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"ДНИ","ЧАСЫ"]
[1,"Иванов Иван",null,null,null,null,null,null,10,11,null,null,11,11,11,11,11,11,11,11,11,11,11,11,null,11,11,11,11,11,11,null,11,11,11,11,null,11,11,11,{"$f":"IF(COUNT(J7:AN7)>0,COUNT(J7:AN7),\"\")","v":26},{"$f":"IF((SUM(J7:AN7))>0,SUM(J7:AN7),\"\")","v":286}]
[2,"Петров Сергей",null,null,null,null,null,null,10,null,11,11,null,null,null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,11,null,null,null,null,null,11,null,null,5,55]
[3,"Владимир Путин",null,null,null,null,null,null,1,null,11,11,11,11,11,null,null,11,11,11,11,11,null,null,11,11,11,11,11,null,null,11,11,11,11,11,null,null,11,11,22,242]
[4,"Анжелина Джоли",null,null,null,null,null,null,1,11,11,null,null,11,11,6,11,11,6,null,null,null,11,11,11,11,11,11,11,null,null,null,null,null,null,null,null,11,11,11,18,188]
[5,"Митя Фомин",null,null,null,null,null,null,10,null,null,6,11,null,null,11,11,11,11,11,11,11,null,null,null,null,null,null,null,11,11,11,11,11,11,11,null,null,null,null,16,171]
[6,"Джордж Буш",null,null,null,null,null,null,1,null,null,null,null,null,null,11,11,11,11,11,11,11,null,null,null,null,null,null,null,11,11,11,11,11,11,11,null,null,null,null,14,154]
[7,"Киану Ривз",null,null,null,null,null,null,1,11,11,11,11,11,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,66]
[8,"Морген Фриман",null,null,null,null,null,null,10,11,11,11,11,11,11,null,null,null,null,null,null,null,11,11,11,11,11,11,11,null,null,null,null,null,null,null,null,11,11,11,16,176]
[9,"Дмитрий Земин",null,null,null,null,null,null,10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[10,"Томара Грач",null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,11]
[11,"Пупок Степанов",null,null,null,null,null,null,1,11,null,null,null,null,null,11,11,null,null,null,null,null,11,11,null,null,null,null,null,11,11,null,null,null,null,null,null,null,null,null,7,77]
[12,null,null,null,null,null,null,null,{"$f":"IF(B18>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[13,null,null,null,null,null,null,null,{"$f":"IF(B19>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[14,null,null,null,null,null,null,null,{"$f":"IF(B20>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[15,null,null,null,null,null,null,null,{"$f":"IF(B21>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[16,null,null,null,null,null,null,null,{"$f":"IF(B22>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[17,null,null,null,null,null,null,null,{"$f":"IF(B23>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[18,null,null,null,null,null,null,null,{"$f":"IF(B24>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[19,null,null,null,null,null,null,null,{"$f":"IF(B25>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[20,null,null,null,null,null,null,null,{"$f":"IF(B26>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"Магазин №2","index":3,"n_rows":26,"n_cols":36,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[null,null,null,{"$f":"CONCATENATE(D4,D6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"01.04.2018"},{"$f":"CONCATENATE(E4,E6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"02.04.2018"},{"$f":"CONCATENATE(F4,F6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"03.04.2018"},{"$f":"CONCATENATE(G4,G6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"04.04.2018"},{"$f":"CONCATENATE(H4,H6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"05.04.2018"},{"$f":"CONCATENATE(I4,I6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"06.04.2018"},{"$f":"CONCATENATE(J4,J6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"07.04.2018"},{"$f":"CONCATENATE(K4,K6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"08.04.2018"},{"$f":"CONCATENATE(L4,L6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"09.04.2018"},{"$f":"CONCATENATE(M4,M6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"10.04.2018"},{"$f":"CONCATENATE(N4,N6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"11.04.2018"},{"$f":"CONCATENATE(O4,O6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"12.04.2018"},{"$f":"CONCATENATE(P4,P6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"13.04.2018"},{"$f":"CONCATENATE(Q4,Q6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"14.04.2018"},{"$f":"CONCATENATE(R4,R6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"15.04.2018"},{"$f":"CONCATENATE(S4,S6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"16.04.2018"},{"$f":"CONCATENATE(T4,T6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"17.04.2018"},{"$f":"CONCATENATE(U4,U6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"18.04.2018"},{"$f":"CONCATENATE(V4,V6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"19.04.2018"},{"$f":"CONCATENATE(W4,W6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"20.04.2018"},{"$f":"CONCATENATE(X4,X6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"21.04.2018"},{"$f":"CONCATENATE(Y4,Y6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"22.04.2018"},{"$f":"CONCATENATE(Z4,Z6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"23.04.2018"},{"$f":"CONCATENATE(AA4,AA6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"24.04.2018"},{"$f":"CONCATENATE(AB4,AB6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"25.04.2018"},{"$f":"CONCATENATE(AC4,AC6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"26.04.2018"},{"$f":"CONCATENATE(AD4,AD6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"27.04.2018"},{"$f":"CONCATENATE(AE4,AE6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"28.04.2018"},{"$f":"CONCATENATE(AF4,AF6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"29.04.2018"},{"$f":"CONCATENATE(AG4,AG6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":"30.04.2018"},{"$f":"CONCATENATE(AH4,AH6,\".\",$A$3,Доп.данные!$C$2,\".\",Доп.данные!$C$3)","v":".04.2018"}]
[null,"Отчетный период","П1",{"$f":"IFERROR(INDEX(ОБОРОТ!C4:C23,MATCH('Магазин №1'!$A$5&D4&'Магазин №1'!J6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!C1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!D4:D23,MATCH('Магазин №1'!$A$5&E4&'Магазин №1'!K6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!D1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!E4:E23,MATCH('Магазин №1'!$A$5&F4&'Магазин №1'!L6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!E1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!F4:F23,MATCH('Магазин №1'!$A$5&G4&'Магазин №1'!M6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!F1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!G4:G23,MATCH('Магазин №1'!$A$5&H4&'Магазин №1'!N6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!G1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!H4:H23,MATCH('Магазин №1'!$A$5&I4&'Магазин №1'!O6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!H1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!I4:I23,MATCH('Магазин №1'!$A$5&J4&'Магазин №1'!P6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!I1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!J4:J23,MATCH('Магазин №1'!$A$5&K4&'Магазин №1'!Q6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!J1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!K4:K23,MATCH('Магазин №1'!$A$5&L4&'Магазин №1'!R6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!K1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!L4:L23,MATCH('Магазин №1'!$A$5&M4&'Магазин №1'!S6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!L1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!M4:M23,MATCH('Магазин №1'!$A$5&N4&'Магазин №1'!T6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!M1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!N4:N23,MATCH('Магазин №1'!$A$5&O4&'Магазин №1'!U6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!N1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!O4:O23,MATCH('Магазин №1'!$A$5&P4&'Магазин №1'!V6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!O1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!P4:P23,MATCH('Магазин №1'!$A$5&Q4&'Магазин №1'!W6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!P1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Q4:Q23,MATCH('Магазин №1'!$A$5&R4&'Магазин №1'!X6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!Q1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!R4:R23,MATCH('Магазин №1'!$A$5&S4&'Магазин №1'!Y6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!R1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!S4:S23,MATCH('Магазин №1'!$A$5&T4&'Магазин №1'!Z6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!S1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!T4:T23,MATCH('Магазин №1'!$A$5&U4&'Магазин №1'!AA6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!T1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!U4:U23,MATCH('Магазин №1'!$A$5&V4&'Магазин №1'!AB6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!U1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!V4:V23,MATCH('Магазин №1'!$A$5&W4&'Магазин №1'!AC6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!V1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!W4:W23,MATCH('Магазин №1'!$A$5&X4&'Магазин №1'!AD6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!W1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!X4:X23,MATCH('Магазин №1'!$A$5&Y4&'Магазин №1'!AE6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!X1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Y4:Y23,MATCH('Магазин №1'!$A$5&Z4&'Магазин №1'!AF6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!Y1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Z4:Z23,MATCH('Магазин №1'!$A$5&AA4&'Магазин №1'!AG6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!Z1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AA4:AA23,MATCH('Магазин №1'!$A$5&AB4&'Магазин №1'!AH6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AA1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AB4:AB23,MATCH('Магазин №1'!$A$5&AC4&'Магазин №1'!AI6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AB1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AC4:AC23,MATCH('Магазин №1'!$A$5&AD4&'Магазин №1'!AJ6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AC1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AD4:AD23,MATCH('Магазин №1'!$A$5&AE4&'Магазин №1'!AK6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AD1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AE4:AE23,MATCH('Магазин №1'!$A$5&AF4&'Магазин №1'!AL6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AE1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AF4:AF23,MATCH('Магазин №1'!$A$5&AG4&'Магазин №1'!AM6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AF1,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AG4:AG23,MATCH('Магазин №1'!$A$5&AH4&'Магазин №1'!AN6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$4:$B$23&ОБОРОТ!AG1,0)),\"\")","v":""}]
[0,{"$f":"Доп.данные!D2","v":"Апрель"},"П2",{"$f":"IFERROR(INDEX(ОБОРОТ!C29:C38,MATCH('Магазин №1'!$A$5&D4&'Магазин №1'!J6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!C26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!D29:D38,MATCH('Магазин №1'!$A$5&E4&'Магазин №1'!K6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!D26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!E29:E38,MATCH('Магазин №1'!$A$5&F4&'Магазин №1'!L6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!E26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!F29:F38,MATCH('Магазин №1'!$A$5&G4&'Магазин №1'!M6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!F26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!G29:G38,MATCH('Магазин №1'!$A$5&H4&'Магазин №1'!N6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!G26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!H29:H38,MATCH('Магазин №1'!$A$5&I4&'Магазин №1'!O6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!H26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!I29:I38,MATCH('Магазин №1'!$A$5&J4&'Магазин №1'!P6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!I26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!J29:J38,MATCH('Магазин №1'!$A$5&K4&'Магазин №1'!Q6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!J26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!K29:K38,MATCH('Магазин №1'!$A$5&L4&'Магазин №1'!R6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!K26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!L29:L38,MATCH('Магазин №1'!$A$5&M4&'Магазин №1'!S6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!L26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!M29:M38,MATCH('Магазин №1'!$A$5&N4&'Магазин №1'!T6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!M26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!N29:N38,MATCH('Магазин №1'!$A$5&O4&'Магазин №1'!U6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!N26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!O29:O38,MATCH('Магазин №1'!$A$5&P4&'Магазин №1'!V6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!O26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!P29:P38,MATCH('Магазин №1'!$A$5&Q4&'Магазин №1'!W6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!P26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Q29:Q38,MATCH('Магазин №1'!$A$5&R4&'Магазин №1'!X6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!Q26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!R29:R38,MATCH('Магазин №1'!$A$5&S4&'Магазин №1'!Y6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!R26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!S29:S38,MATCH('Магазин №1'!$A$5&T4&'Магазин №1'!Z6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!S26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!T29:T38,MATCH('Магазин №1'!$A$5&U4&'Магазин №1'!AA6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!T26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!U29:U38,MATCH('Магазин №1'!$A$5&V4&'Магазин №1'!AB6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!U26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!V29:V38,MATCH('Магазин №1'!$A$5&W4&'Магазин №1'!AC6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!V26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!W29:W38,MATCH('Магазин №1'!$A$5&X4&'Магазин №1'!AD6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!W26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!X29:X38,MATCH('Магазин №1'!$A$5&Y4&'Магазин №1'!AE6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!X26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Y29:Y38,MATCH('Магазин №1'!$A$5&Z4&'Магазин №1'!AF6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!Y26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!Z29:Z38,MATCH('Магазин №1'!$A$5&AA4&'Магазин №1'!AG6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!Z26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AA29:AA38,MATCH('Магазин №1'!$A$5&AB4&'Магазин №1'!AH6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AA26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AB29:AB38,MATCH('Магазин №1'!$A$5&AC4&'Магазин №1'!AI6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AB26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AC29:AC38,MATCH('Магазин №1'!$A$5&AD4&'Магазин №1'!AJ6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AC26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AD29:AD38,MATCH('Магазин №1'!$A$5&AE4&'Магазин №1'!AK6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AD26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AE29:AE38,MATCH('Магазин №1'!$A$5&AF4&'Магазин №1'!AL6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AE26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AF29:AF38,MATCH('Магазин №1'!$A$5&AG4&'Магазин №1'!AM6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AF26,0)),\"\")","v":""},{"$f":"IFERROR(INDEX(ОБОРОТ!AG29:AG38,MATCH('Магазин №1'!$A$5&AH4&'Магазин №1'!AN6&\".\"&$A$3&Доп.данные!$C$2&\".\"&$B$4,ОБОРОТ!$B$29:$B$38&ОБОРОТ!AG26,0)),\"\")","v":""}]
[null,{"$f":"Доп.данные!C3","v":2018},null,0,0,0,0,0,0,0,0,0]
["ЦБ000046","Магазин №2",null,{"$f":"TEXT(D1,\"ДДД\")","v":"Вс"},{"$f":"TEXT(E1,\"ДДД\")","v":"Пн"},"Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн","Вт","Ср","Чт","Пт","Сб","Вс","Пн"]
["№","ФИО","Группа",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,null,"ДНИ","ЧАСЫ"]
[1,"Степан Разин",{"$f":"IF(B7>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":10},11,11,11,11,11,11,null,null,null,null,null,8,null,11,11,11,11,11,11,11,null,null,null,null,null,8,null,11,11,11,null,{"$f":"IF(COUNT(D7:AH7)>0,COUNT(D7:AH7),\"\")","v":18},{"$f":"IF((SUM(D7:AH7))>0,SUM(D7:AH7),\"\")","v":192}]
[2,"Сергей Рядом",{"$f":"IF(B8>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":10},null,null,null,null,8,null,11,11,11,11,11,11,11,null,null,null,null,null,8,null,11,11,11,11,11,11,11,null,null,null,null,16,{"$f":"IF((SUM(D8:AH8))>0,SUM(D8:AH8),\"\")","v":170}]
[3,"Серджио Соко",{"$f":"IF(B9>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":10},8,8,8,8,null,null,8,8,8,8,8,null,null,8,8,8,8,8,null,null,8,8,8,8,8,null,null,8,8,8,null,22,176]
[4,null,{"$f":"IF(B10>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[5,null,{"$f":"IF(B11>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[6,null,{"$f":"IF(B12>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[7,null,{"$f":"IF(B13>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[8,null,{"$f":"IF(B14>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[9,null,{"$f":"IF(B15>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[10,null,{"$f":"IF(B16>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[11,null,{"$f":"IF(B17>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[12,null,{"$f":"IF(B18>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[13,null,{"$f":"IF(B19>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[14,null,{"$f":"IF(B20>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[15,null,{"$f":"IF(B21>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[16,null,{"$f":"IF(B22>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[17,null,{"$f":"IF(B23>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[18,null,{"$f":"IF(B24>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[19,null,{"$f":"IF(B25>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]
[20,null,{"$f":"IF(B26>0,INDEX(Лист4!$X$2:$X$115,MATCH($B$7:$B$26,Лист4!$V$2:$V$115,0)),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",""]

{"sheet":"ОБОРОТ","index":4,"n_rows":29,"n_cols":32,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Подразделение","Код (Подразделение)","2018-04-01","2018-04-02","2018-04-03","2018-04-04","2018-04-05","2018-04-06","2018-04-07","2018-04-08","2018-04-09","2018-04-10","2018-04-11","2018-04-12","2018-04-13","2018-04-14","2018-04-15","2018-04-16","2018-04-17","2018-04-18","2018-04-19","2018-04-20","2018-04-21","2018-04-22","2018-04-23","2018-04-24","2018-04-25","2018-04-26","2018-04-27","2018-04-28","2018-04-29","2018-04-30"]
[null,null,"Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот"]
[null,null,"Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)"]
["Магазин №1","ЦБ000048",50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
["Магазин №2","ЦБ000046",50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000,50000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Подразделение","Код (Подразделение)","2018-04-01","2018-04-02","2018-04-03","2018-04-04","2018-04-05","2018-04-06","2018-04-07","2018-04-08","2018-04-09","2018-04-10","2018-04-11","2018-04-12","2018-04-13","2018-04-14","2018-04-15","2018-04-16","2018-04-17","2018-04-18","2018-04-19","2018-04-20","2018-04-21","2018-04-22","2018-04-23","2018-04-24","2018-04-25","2018-04-26","2018-04-27","2018-04-28","2018-04-29","2018-04-30"]
[null,null,"Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот","Оборот"]
[null,null,"Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)","Сумма (упр.)"]
["Магазин №1","ЦБ000048",20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000,20000]

{"sheet":"Лист4","index":5,"n_rows":57,"n_cols":28,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Код Магазина","Название Магазина","группа","кол-во персонала(по группам","Должность","строка товарооборота","Процент",null,null,null,null,null,null,null,null,"Должность","Наименование магазина","День недели","Кол-во часов",null,"Подразделение","ФИО","Должность",null,null,"Подразделение","Контрагент","КодК"]
[null,"Магазин №1","П1",2,"СП",1,1.7999999999999999E-2,null,null,null,null,null,null,null,null,"СП","Магазин №1","пн",11,null,null,"Иванов Иван",null,1,null,"Магазин №1",null,"ЦБ000048"]
[null,"Магазин №1","П1",2,"МП",1,1.6E-2,null,null,null,null,null,null,null,null,"СП","Магазин №1","вт",11,null,null,"Петров Сергей",null,10,null,"Магазин №2",null,"ЦБ000036"]
[null,"Магазин №1","П1",3,"СП",1,1.7999999999999999E-2,null,null,null,null,null,null,null,null,"СП","Магазин №1","ср",11,null,null,"Владимир Путин",null,10]
[null,"Магазин №1","П1",3,"МП",1,1.6E-2,null,null,null,null,null,null,null,null,"СП","Магазин №1","чт",11,null,null,"Анжелина Джоли",null,1]
[null,"Магазин №1","П2",1,"ПС",1,0.06,null,null,null,null,null,null,null,null,"СП","Магазин №1","пт",11,null,null,"Митя Фомин",null,10]
[null,"Магазин №1","П2",2,"ПС",1,4.4999999999999998E-2,null,null,null,null,null,null,null,null,"СП","Магазин №1","сб",11,null,null,"Джордж Буш",null,10]
[null,"Магазин №1","П2",2,"ПМ",1,4.4999999999999998E-2,null,null,null,null,null,null,null,null,"СП","Магазин №1","вс",11,null,null,"Киану Ривз",null,1]
[null,"Магазин №2","П1",1,"СП",1,2.9000000000000001E-2,null,null,null,null,null,null,null,null,"МП","Магазин №1","пн",11,null,null,"Морген Фриман",null,1]
[null,"Магазин №2","П1",2,"СП",1,2.1999999999999999E-2,null,null,null,null,null,null,null,null,"МП","Магазин №1","вт",11,null,null,"Дмитрий Земин",null,1]
[null,"Магазин №2","П1",2,"МП",1,1.7999999999999999E-2,null,null,null,null,null,null,null,null,"МП","Магазин №1","ср",11,null,null,"Томара Грач",null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №1","чт",11,null,null,"Пупок Степанов",null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №1","пт",11,null,null,"Степан Разин",null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №1","сб",11,null,null,"Сергей Рядом",null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №1","вс",11,null,null,"Серджио Соко",null,10]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №1","пн",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №1","вт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №1","ср",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №1","чт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №1","пт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №1","сб",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №1","вс",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №1","пн",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №1","вт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №1","ср",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №1","чт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №1","пт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №1","сб",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №1","вс",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СП","Магазин №2","пн",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СП","Магазин №2","вт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СП","Магазин №2","ср",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СП","Магазин №2","чт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СП","Магазин №2","пт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СП","Магазин №2","сб",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"СП","Магазин №2","вс",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №2","пн",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №2","вт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №2","ср",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №2","чт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №2","пт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №2","сб",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"МП","Магазин №2","вс",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №2","пн",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №2","вт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №2","ср",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №2","чт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №2","пт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №2","сб",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПС","Магазин №2","вс",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №2","пн",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №2","вт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №2","ср",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №2","чт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №2","пт",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №2","сб",11]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ПМ","Магазин №2","вс",11]