{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["МЕНЮ","МЕСТНЫЕ","МПС","выданный мпс","данные местные","данные мпс","ссылки"],"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":"МЕНЮ","index":0,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,null,"МЕНЮ"]
[]
[null,null,{"$f":"HYPERLINK(\"#Местные!A1\",\"ЛЦ - 1 (Шихтовой)\")","v":"ЛЦ - 1 (Шихтовой)"}]
[null,null,{"$f":"HYPERLINK(\"#Местные!E1\",\"ЛЦ - 1 (БАМ)\")","v":"ЛЦ - 1 (БАМ)"}]
[null,null,{"$f":"HYPERLINK(\"#Местные!I1\",\"ЛЦ - 1 (Выбивки)\")","v":"ЛЦ - 1 (Выбивки)"}]
[null,null,{"$f":"HYPERLINK(\"#Местные!M1\",\"Старый склад\")","v":"Старый склад"}]
[]
[]
[null,null,{"$f":"HYPERLINK(\"#Местные!A226\",\"2я выстовочная\")","v":"2я выстовочная"}]

{"sheet":"МЕСТНЫЕ","index":1,"n_rows":267,"n_cols":20,"rows_kept":267,"cut":false,"hidden":false,"merged":[[235,1,235,3],[238,1,238,3],[239,1,239,3],[235,5,235,7],[232,5,232,7],[177,4,177,7],[106,8,107,11],[123,8,123,11],[108,4,108,7],[163,0,164,3],[164,4,165,7],[161,8,162,11],[159,12,160,15],[170,12,170,15],[177,12,177,15],[107,12,107,15],[47,12,47,15],[89,0,90,3],[33,12,34,15],[49,8,50,11],[57,12,58,15],[36,4,37,7],[36,8,37,11],[69,4,69,7],[77,4,77,7],[63,4,64,7],[42,4,42,7],[50,4,50,7],[87,8,87,11],[69,12,69,15],[79,12,79,15],[63,8,64,11],[63,12,64,15],[86,4,86,7],[65,11,66,11],[65,10,66,10],[69,8,69,11],[78,8,78,11],[72,0,72,3],[42,0,42,3],[11,4,12,7],[19,9,19,11],[17,8,18,11],[18,0,19,3],[39,12,39,15],[0,16,1,19],[6,8,6,11],[9,8,9,11],[2,10,3,11],[21,12,22,15],[0,0,1,3],[0,4,1,7],[0,8,1,11],[0,12,1,15],[13,8,13,11],[15,8,15,11],[13,5,13,6],[20,2,20,3],[21,2,21,3],[24,0,24,3],[80,0,80,3],[66,0,67,3],[51,0,51,3],[27,4,28,7],[36,0,37,3],[31,0,31,3],[154,4,154,7],[93,0,93,3],[137,12,137,15],[141,0,142,3],[137,4,138,7],[148,8,149,11],[150,12,151,15],[121,0,122,3],[131,0,131,3],[121,4,122,7],[132,8,133,11],[123,12,124,15],[95,0,95,3],[98,0,98,3],[98,4,98,7],[94,5,95,5],[94,6,95,6],[99,12,99,15],[92,4,93,7],[93,8,94,11],[93,12,94,15],[111,12,111,15],[117,12,117,15],[188,12,188,15],[194,12,194,15],[181,8,182,11],[225,0,226,3],[225,4,226,7],[225,8,226,11],[225,12,226,15],[179,0,180,3],[173,12,174,15],[179,12,179,15],[183,12,183,15],[201,0,202,3],[201,4,202,7],[206,4,206,7],[210,4,210,7],[219,4,219,7],[222,4,222,7],[201,8,202,11],[170,4,170,7],[214,0,214,3],[201,12,202,15],[253,0,253,3],[262,4,262,7],[262,8,262,11],[249,12,249,15],[257,0,258,3],[231,12,231,15],[229,8,229,11],[229,12,229,15],[243,0,243,3],[250,4,250,7],[250,8,250,11],[238,12,238,15],[229,0,229,3],[229,4,229,7],[231,0,231,3],[231,4,231,7],[231,8,231,11],[207,12,207,15],[213,8,213,11],[232,1,232,3],[233,1,233,3],[234,1,234,3]]}
["ЛЦ - 1 (Шихтовой)",null,null,null,"ЛЦ - 1 (БАМ)",null,null,null,"ЛЦ - 1 (Выбивки)",null,null,null,"Старый склад сбыта"]
[]
["всего","10","9 в зоне крана",null,"всего",3,null,null,"всего","7","экспедиция -2, от экспедиции до выбивок -3, 2я выбивка -1, 1я выбивка -1",null,"всего","13",null,null,"всего"]
["факт",{"$f":"COUNTA(B7:B18)","v":0},null,null,"факт",{"$f":"COUNTA(F7:F11)","v":0},null,null,"факт",{"$f":"COUNTA(J8:J9,J11:J13,J15,J17)","v":0},null,null,"факт",{"$f":"COUNTA(N7:N21)","v":0},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,null,null,"всего","8 от дор-ки до переезда",null,null,"2я выбивка"]
["нет",null,null,null,"факт",{"$f":"COUNTA(F18:F27)","v":0}]
["нет",null,null,null,null,null,null,null,"1я выбивка"]
["нет",null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","нет"]
["нет",null,null,null,null,null,null,null,"ЛЦ - 1 (Земледелка)"]
["6ой путь (по шихтовому)"]
[null,null,null,null,null,null,null,null,"всего","хер знает, но ходит 5, информация Аношко"]
["всего","4 до перезда","2 от ворот ших-го до шлагбаума",null,"нет",null,null,null,"факт",{"$f":"COUNTA(J24:J36)","v":0}]
["факт",{"$f":"COUNTA(B26:B31)","v":0},{"$f":"COUNTA(B33:B36)","v":0},null,null,null,null,null,null,null,null,null,"0й путь"]
[null,null,null,null,null,null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
["ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС",null,null,null,null,null,null,null,null,"всего","4"]
["от прохода до переезда ",null,null,null,null,null,null,null,null,null,null,null,"факт",{"$f":"COUNTA(N28:N33)","v":0}]
["нет",null,null,null,"нет"]
["нет",null,null,null,"нет",null,null,null,null,null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
["нет",null,null,null,"10й тупик (по магазину)"]
[]
[null,null,null,null,"всего","2"]
["нет",null,null,null,"факт",{"$f":"COUNTA(F34:F36)","v":0}]
["от ворот ших-го до шлагбаума"]
[null,null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
[null,null,null,null,null,null,null,null,null,null,null,null,"4ый путь (длинная)"]
[null,null,null,null,"нет"]
["нет",null,null,null,"нет",null,null,null,"нет",null,null,null,"всего","5 до переезда","7 после переезда"]
["7ой путь ",null,null,null,"8ой путь (весовая)",null,null,null,"30 путь",null,null,null,"факт",{"$f":"COUNTA(N41:N47)","v":0},{"$f":"COUNTA(N49:N57)","v":0}]
[]
["всего","за проходом: 5","по трубам 12",null,"всего","до весов 5","за дор-ой 10",null,"всего","5",null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
["факт",{"$f":"COUNTA(B44:B51)","v":0},{"$f":"COUNTA(B53:B66)","v":0},null,"факт",{"$f":"COUNTA(F44:F50)","v":0},{"$f":"COUNTA(F52:F63)","v":0},null,"факт",{"$f":"COUNTA(J43:J49)","v":0},null,null,"до переезда"]
[]
["ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
["за проходом 6ой до переезда",null,null,null,"до весов"]
["нет"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"после переезда"]
[]
[null,null,null,null,null,null,null,null,"4ый путь (короткая)"]
[null,null,null,null,"за дорожкой"]
["по трубам",null,null,null,null,null,null,null,"всего","6"]
[null,null,null,null,null,null,null,null,"факт",{"$f":"COUNTA(J56:J63)","v":0}]
[]
[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,"РИЦ"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"всего","1","факт",{"$f":"COUNTA(N62:N63)","v":0}]
[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","до переезда 5","за канавой 3","всего","до перезда 6 ","от заправки до переезда 6 запад","за канавой за переездом 3","всего","до переезда 7","за переездом 10"]
["Котельная",null,null,null,"факт",{"$f":"COUNTA(F79:F86)","v":0},{"$f":"COUNTA(F71:F77)","v":0},{"$f":"COUNTA(F88:F92)","v":0},null,null,null,null,"факт",{"$f":"COUNTA(N71:N79)","v":0},{"$f":"COUNTA(N81:N93)","v":0}]
[null,null,null,null,null,null,null,null,"факт",{"$f":"COUNTA(J71:J78)","v":0},{"$f":"COUNTA(J80:J87)","v":0},{"$f":"COUNTA(J89:J93)","v":0}]
["всего","до дор-ки 5","за дор-ой 6",null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
["факт",{"$f":"COUNTA(B74:B80)","v":0},{"$f":"COUNTA(B82:B89)","v":0},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,null,null,null,null,null,null,null,null,"за переездом"]
["за дорожкой"]
[]
[]
[]
[]
[]
[null,null,null,null,"за канавой (за переездом)"]
["нет",null,null,null,null,null,null,null,"за переездом западная сторона"]
[]
["Пандус"]
[]
["всего","1","по пандусу 15"]
["факт",{"$f":"COUNTA(B97:B98)","v":0},{"$f":"COUNTA(B100:B116)","v":0},null,"9ый путь",null,null,null,null,null,null,null,"нет"]
["Расстановка единиц указывается с хвоста состава",null,null,null,null,null,null,null,"ЛЦ - 2",null,null,null,"Сушка песка"]
["ВИД  ↑","№ ЕД  ↑","ГРУЗ","ВЕС","всего","от прохода пандуса до переезда 7","по ЛЦ -2 за проходом сушки песка до переезда 10"]
["пандус",null,null,null,null,null,null,null,"всего","5",null,null,"всего","5","3","3"]
[null,null,null,null,"факт",{"$f":"COUNTA(F100:F108)","v":0},{"$f":"COUNTA(F110:F121)","v":0},null,"факт",{"$f":"COUNTA(J100:J106)","v":0},null,null,"факт",{"$f":"COUNTA(N101:N107)","v":0},{"$f":"COUNTA(N109:N111)","v":0},{"$f":"COUNTA(N113:N117)","v":0}]
["нет",null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС",null,null,null,null,"всего ","3","факт",{"$f":"COUNTA(N119:N123)","v":0}]
["по пандусу (от переезда до пандуса)",null,null,null,"от прохода пандуса до переезда",null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
[null,null,null,null,null,null,null,null,null,null,null,null,"правая сушки песка (5)"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Буры "]
[null,null,null,null,null,null,null,null,null,null,null,null,"левая сушки песка (3)"]
[null,null,null,null,"по ЛЦ -2 за проходом сушки песка до переезда ",null,null,null,"всего","9","по бурам 6"]
[null,null,null,null,null,null,null,null,"факт",{"$f":"COUNTA(J113:J123)","v":0},{"$f":"COUNTA(J125:J132)","v":0}]
[]
[null,null,null,null,null,null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","по левой от переезда до ворот (3)"]
[]
[]
[]
[]
["ВИД  ↑","№ ЕД  ↑","ГРУЗ","ВЕС"]
[null,null,null,null,null,null,null,null,null,null,null,null,"по правой от переезда до ворот (3)"]
[]
[]
[]
["5й тупик (гармет)",null,null,null,"3й путь (гармет)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"нет"]
["всего","2","по тупику 7",null,"всего","до переезда 8",null,null,"по бурам ",null,null,null,"Склад металлов"]
["факт",{"$f":"COUNTA(B128:B131)","v":0},{"$f":"COUNTA(B133:B141)","v":0},null,"факт",{"$f":"COUNTA(F128:F137)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"всего","6","по складу 10"]
["ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС",null,null,null,null,"факт",{"$f":"COUNTA(N130:N137)","v":0},{"$f":"COUNTA(N139:N150)","v":0}]
[]
[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,null,null,null,null,null,null,null,"факт",{"$f":"COUNTA(J139:J148)","v":0}]
[]
[null,null,null,null,"НБО - 340 (пресс ножни)",null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","по складу"]
[]
[null,null,null,null,"всего","9","по правой 7"]
[null,null,null,null,"факт",{"$f":"COUNTA(F144:F154)","v":0},{"$f":"COUNTA(F156:F164)","v":0}]
["2ой путь (Гармет)"]
[null,null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
["всего","14"]
["факт",{"$f":"COUNTA(B148:B163)","v":0}]
[]
["ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
[]
[null,null,null,null,null,null,null,null,"Опоки"]
[]
[null,null,null,null,null,null,null,null,"всего","5",null,null,"По канаве чугуна "]
[null,null,null,null,null,null,null,null,"факт",{"$f":"COUNTA(J155:J161)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"всего","1"]
[null,null,null,null,null,null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","факт",{"$f":"COUNTA(N157:N159)","v":0}]
[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,null,null,null,null,null,"Пилорама",null,null,null,"всего","3","по складу 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"факт",{"$f":"COUNTA(N166:N170)","v":0},{"$f":"COUNTA(N172:N173)","v":0}]
["5й путь (длинная - гармет)",null,null,null,null,null,null,null,"всего","12"]
[null,null,null,null,"6ой путь (копровая)",null,null,null,"факт",{"$f":"COUNTA(J168:J181)","v":0},null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
["всего","8"]
["факт",{"$f":"COUNTA(B170:B179)","v":0},null,null,"всего","до тропинки 4","от тропинки 22",null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
[null,null,null,null,"факт",{"$f":"COUNTA(F172:F177)","v":0},{"$f":"COUNTA(F179:F201)","v":0},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,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,"факт",{"$f":"COUNTA(N181:N183,N185:N188,N190:N194,N196:N197)","v":0}]
[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,null,null,null,null,null,null,null,null,null,null,"тупик (2ед)"]
[]
["всего","14",null,null,null,null,null,null,"по мусорной (за проходом склада огнеупроров)"]
["факт",{"$f":"COUNTA(B186:B201)","v":0}]
[null,null,null,null,null,null,null,null,"всего",null,null,null,"1 путь (2ед)"]
["ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС",null,null,null,null,"факт",{"$f":"COUNTA(J188:J201)","v":0}]
[]
[null,null,null,null,null,null,null,null,"ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2 путь (3ед)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"3 путь (1ед)"]
[]
[]
[]
[]
[]
[]
["ЛЦ -1 (западная сторона) Разливочный",null,null,null,"ЛЦ -1 (западная сторона) Склад бентонита",null,null,null,"ЛЦ -1 (западная сторона) Шихтовой (короткая)",null,null,null,"ЛЦ -1 (западная сторона) Шихтовой (длинная)"]
[]
["всего","5","по ЛЦ-1 3",null,"всего","1","по складу 6",null,"всего","4","по шит-му 4",null,"всего","4"]
["факт",{"$f":"COUNTA(B208:B214)","v":0},{"$f":"COUNTA(B216:B220)","v":0},null,"факт",{"$f":"COUNTA(F209:F210)","v":0},{"$f":"COUNTA(F212:F219,F221)","v":0},null,"факт",{"$f":"COUNTA(J208:J213)","v":0},{"$f":"COUNTA(J215:J220)","v":0},null,"факт",{"$f":"COUNTA(N209:N214)","v":0}]
[]
["ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","Расстановка единиц указывается с хвоста состава",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,null,null,null,null,"по шихтовому"]
["по разливочному"]
[]
[]
[]
[]
[null,null,null,null,"цистерна под сливом жидкого стекла"]
[]
[null,null,null,null,"ВИД  ↑","№ ЕД  ↑","ГРУЗ","ВЕС"]
[null,null,null,null,"Расстановка единиц указывается с хвоста состава"]
[]
[]
["2я выстовочная",null,null,null,"3я выстовочная",null,null,null,"4я выстовочная",null,null,null,"Старая весовая"]
[]
["всего","15","до дорожки 9","за дорожкой 6","всего","22","до дорожки 15","за дорожкой 7 ","всего","23","до дорожки 15","за дорожкой 8","всего","12","до дорожки 4","за дорожкой 7"]
["факт",{"$f":"COUNTA(B233:B243,B245:B252)","v":6},{"$f":"COUNTA(B233:B243)","v":6},{"$f":"COUNTA(B245:B252)","v":0},"факт",{"$f":"COUNTA(F233:F250,F252:F261)","v":2},{"$f":"COUNTA(F233:F250)","v":2},{"$f":"COUNTA(F252:F261)","v":0},"факт",{"$f":"COUNTA(J233:J250,J252:J261)","v":0},{"$f":"COUNTA(J233:J250)","v":0},{"$f":"COUNTA(J252:J261)","v":0},"факт",{"$f":"COUNTA(N233:N238,N240:N248)","v":0},{"$f":"COUNTA(N233:N238)","v":0},{"$f":"COUNTA(N240:N248)","v":0}]
["расстановка единиц от выездных ворот",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,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,null,"ВИД  ↑","№ ЕД  ↑","ГРУЗ","ВЕС"]
[null,null,null,null,null,null,null,null,null,null,null,null,"со стороны депо"]
[null,null,null,null,"за дорожкой",null,null,null,"за дорожкой"]
[]
["ВИД  ↑","№ ЕД  ↑","ГРУЗ","ВЕС"]
["со стороны депо"]
[]
[]
[]
["Склад пружин (путь за диспетчерской)"]
[]
["всего","8"]
["факт",{"$f":"COUNTA(B264:B273)","v":0},null,null,"нет"]
[null,null,null,null,"ВИД  ↑","№ ЕД  ↑","ГРУЗ","ВЕС","ВИД  ↑","№ ЕД  ↑","ГРУЗ","ВЕС"]
["ВИД  ↓","№ ЕД  ↓","ГРУЗ","ВЕС","со стороны депо",null,null,null,"со стороны депо"]
[]
[]
[]
["нет"]

{"sheet":"МПС","index":2,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,5,1,9],[4,5,4,9],[6,5,6,9],[25,5,25,9],[0,0,1,4],[4,0,4,4],[6,0,6,4],[18,0,18,4],[28,0,28,4]]}
["2я выстовочная",null,null,null,null,"3я выстовочная"]
[]
["всего","15","до дорожки 9",null,"за дорожкой 6","всего","15","до дорожки 9",null,"за дорожкой 6"]
["факт",{"$f":"COUNTA(B8:B18,B20:B27)","v":4},{"$f":"COUNTA(B8:B18)","v":4},null,{"$f":"COUNTA(B20:B27)","v":0},"факт",{"$f":"COUNTA(G8:G18,G20:G27)","v":4},{"$f":"COUNTA(G8:G18)","v":4},null,{"$f":"COUNTA(G20:G27)","v":0}]
["расстановка единиц от выездных ворот",null,null,null,null,"расстановка единиц от выездных ворот"]
["№ МПС ↓","ГРУЗ","1Е ВЗВ-Е","2Е ВЗВ-Е","ОПЕРАЦИЯ","№ МПС ↓","ГРУЗ","1Е ВЗВ-Е","2Е ВЗВ-Е","ОПЕРАЦИЯ"]
["до дорожки",null,null,null,null,"до дорожки"]
["0019863","Песок","Взвешен ","Старирован","ожидание выгрузки","12378963","Песок","Взвешен ","Взвешен ","под выгрузкой"]
["02698263","Песок",null,null,null,"12385963","Песок"]
["89656321","Песок в мешках",null,null,null,"12385963","Песок"]
["45633999","Песок",null,null,null,"74185369","Песок"]
[]
[]
[]
[]
[]
[]
[]
["за дорожкой"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"за дорожкой"]
[]
["ВИД  ↑","№ ЕД  ↑","ГРУЗ",null,"ВЕС"]
["со стороны депо"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"нет"]

{"sheet":"выданный мпс","index":3,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["№ МПС ↓","ГРУЗ","дата выдачи"]
["09863563","песок","01,01,22"]
["12389633","песок","01,01,22"]

{"sheet":"данные местные","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["нет","платформа","думпкар","полувагон","контующийся","цистерна","МПС",null,null,null,null,"вес","груз"]
[null,"001","505","063","01","001"]
[null,"002","5609",null,null,null,null,null,null,null,null,"старир-н(а)","шихта"]
[null,"003","5612",null,null,null,null,null,null,null,null,"взв-н(а)","плита(ы)"]
[null,null,"13336",null,null,null,null,null,null,null,null,null,"скрап-шлак"]
[null,null,"519"]
[null,null,"893"]
[null,null,"5604"]
[null,null,"1364"]
[null,null,"5607"]

{"sheet":"данные мпс","index":5,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["грузмпс","взвешевание","операции"]
[]
["Песок","Взвешен ","ожидание выгрузки"]
["Песок в мешках","Старирован","под выгрузкой"]
["Бентонит",null,"ожидание зачистки"]
["Бентонит казах",null,"под зачисткой"]
[null,null,"ожидание выдачи"]
[null,null,"выдан"]

{"sheet":"ссылки","index":6,"n_rows":26,"n_cols":8,"rows_kept":26,"cut":false,"hidden":false,"merged":[[10,0,10,1],[13,0,14,1],[17,0,18,2],[4,7,5,8],[0,7,1,8],[7,3,8,5],[2,7,3,8],[3,0,3,1],[6,0,6,1],[21,3,22,5],[23,3,24,5],[25,3,26,5],[0,4,1,5],[2,4,3,5],[9,3,20,6]]}
["=ДВССЫЛ(",null,null,"платформа","Условное форматирование: 2я строчка сверху.",null,null,"поиск повторяющихся значений"]
[null,null,null,"думпкар"]
["вид",null,null,"полувагон","текст - содержит - ссылка на данные",null,null,"Условное форматирование: 5я строчка сверху."]
["=данные!$A$1:$E$1",null,null,"контующийся"]
[null,null,null,"цистерна",null,null,null,"повторяющиеся значения в выделенном диапазоне"]
["груз"]
["=ДВССЫЛ(данные!$M$1)"]
[null,null,null,"макрос обнуления выпадающего списка, по первому столбцу, с значением в ячейки \"нет\""]
[]
["вес",null,null,"Private Sub Worksheet_Change(ByVal Target As Range)\n    On Error Resume Next\n    a = Target.Column\n    b = Target.Row\n    c = Target.Validation.Type\n    If (a = 1 Or a = 5 Or a = 9 Or a = 13) And b > 6 And c = 3 Then\n        u = Target.Value\n        If u = \"нет\" Then Range(Cells(b, a + 1), Cells(b, a + 3)).ClearContents\n    End If\nEnd Sub"]
["=ДВССЫЛ(данные!$L$1)"]
[]
["факт"]
["=СЧЁТЗ( формат ячейки общий"]
[]
[]
[]
["=ГИПЕРССЫЛКА(\"#Местные!A1\";\"ЛЦ - 1 Шихтовой\")"]
[]
[]
[]
[null,null,null,"где: (a = 1 Or a = 5 Or a = 9 Or a = 13) номера столбцов "]
[]
[null,null,null,"где: And b > 6 начиная с 7 строки"]
[]
[null,null,null,"где: Cells(b, a + 3)) количество обнуляемых столбцов"]