{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["МЕНЮ","Местные","МПС","выданный мпс","данные","ссылки"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"МЕНЮ","index":0,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,1,1],[2,0,2,1],[0,3,1,4],[2,3,2,4],[4,3,4,4]]}
["МЕНЮ",null,null,"МЕНЮ"]
[]
[null,null,null,"МПС"]
[]
[{"$f":"HYPERLINK(\"#Местные!A1:D18\",\"ЛЦ - 1 (Шихтовой)\")","v":"ЛЦ - 1 (Шихтовой)"},{"$f":"HYPERLINK(\"#Местные!I107:l132\",\"Буры\")","v":"Буры"},null,"Форма добавления МПС в базу"]
[{"$f":"HYPERLINK(\"#Местные!E1:h11\",\"ЛЦ - 1 (БАМ)\")","v":"ЛЦ - 1 (БАМ)"},{"$f":"HYPERLINK(\"#Местные!E122:h137\",\"3й путь (гармет)\")","v":"3й путь (гармет)"}]
[{"$f":"HYPERLINK(\"#Местные!I1:l17\",\"ЛЦ - 1 (Выбивки)\")","v":"ЛЦ - 1 (Выбивки)"},{"$f":"HYPERLINK(\"#Местные!M124:p150\",\"Склад металлов\")","v":"Склад металлов"},null,"Введите № МПС"]
[{"$f":"HYPERLINK(\"#Местные!M1:p21\",\"Старый склад\")","v":"Старый склад"},{"$f":"HYPERLINK(\"#Местные!I149:l161\",\"Опоки\")","v":"Опоки"}]
[{"$f":"HYPERLINK(\"#Местные!A19:d36\",\"6ой путь (по шихтовому)\")","v":"6ой путь (по шихтовому)"},{"$f":"HYPERLINK(\"#Местные!E138:h164\",\"НБО - 340 (пресс ножни)\")","v":"НБО - 340 (пресс ножни)"}]
[{"$f":"HYPERLINK(\"#Местные!E12:h27\",\"5й путь (по БАМу)\")","v":"5й путь (по БАМу)"},{"$f":"HYPERLINK(\"#Местные!M151:p159\",\"По канаве чугуна \")","v":"По канаве чугуна "}]
[{"$f":"HYPERLINK(\"#Местные!E28:h32\",\"10й тупик (по магазину)\")","v":"10й тупик (по магазину)"},{"$f":"HYPERLINK(\"#Местные!I133:l148\",\"Склад сбыта\")","v":"Склад сбыта"}]
[{"$f":"HYPERLINK(\"#Местные!A37:d66\",\"7ой путь\")","v":"7ой путь"},{"$f":"HYPERLINK(\"#Местные!A164:d179\",\"5й путь (длинная - гармет)\")","v":"5й путь (длинная - гармет)"}]
[{"$f":"HYPERLINK(\"#Местные!E37h63\",\"8ой путь (весовая)\")","v":"8ой путь (весовая)"},{"$f":"HYPERLINK(\"#Местные!E165:h201\",\"6ой путь (копровая)\")","v":"6ой путь (копровая)"}]
[{"$f":"HYPERLINK(\"#Местные!I18:l36\",\"ЛЦ - 1 (Земледелка)\")","v":"ЛЦ - 1 (Земледелка)"},{"$f":"HYPERLINK(\"#Местные!i162:l181\",\"Пилорама\")","v":"Пилорама"}]
[{"$f":"HYPERLINK(\"#Местные!M22:p33\",\"0й путь\")","v":"0й путь"},{"$f":"HYPERLINK(\"#Местные!M160:p173\",\"Склад огнеупоров\")","v":"Склад огнеупоров"}]
[{"$f":"HYPERLINK(\"#Местные!M34:p57\",\"4ый путь (длинная)\")","v":"4ый путь (длинная)"},{"$f":"HYPERLINK(\"#Местные!I182:l201\",\"по мусорной (за проходом склада огнеупроров)\")","v":"по мусорной (за проходом склада огнеупроров)"}]
[{"$f":"HYPERLINK(\"#Местные!I37:l49\",\"30 путь\")","v":"30 путь"},{"$f":"HYPERLINK(\"#Местные!M174:p197\",\"Депо\")","v":"Депо"}]
[{"$f":"HYPERLINK(\"#Местные!I50:l63\",\"4ый путь (короткая)\")","v":"4ый путь (короткая)"},{"$f":"HYPERLINK(\"#Местные!A180:d201\",\"5й путь (со стороны мусорки)\")","v":"5й путь (со стороны мусорки)"}]
[{"$f":"HYPERLINK(\"#Местные!M58:p63\",\"РИЦ\")","v":"РИЦ"},{"$f":"HYPERLINK(\"#Местные!A202:d220\",\"ЛЦ -1 (западная сторона) Разливочный\")","v":"ЛЦ -1 (западная сторона) Разливочный"}]
[{"$f":"HYPERLINK(\"#Местные!A67:d89\",\"Котельная\")","v":"Котельная"},{"$f":"HYPERLINK(\"#Местные!E202:h223\",\"ЛЦ -1 (западная сторона) Склад бентонита\")","v":"ЛЦ -1 (западная сторона) Склад бентонита"}]
[{"$f":"HYPERLINK(\"#Местные!E64:h92\",\"Канава известника\")","v":"Канава известника"},{"$f":"HYPERLINK(\"#Местные!I202:l220\",\"ЛЦ -1 (западная сторона) Шихтовой (короткая)\")","v":"ЛЦ -1 (западная сторона) Шихтовой (короткая)"}]
[{"$f":"HYPERLINK(\"#Местные!I64:l93\",\"Объезд канавы известника\")","v":"Объезд канавы известника"},{"$f":"HYPERLINK(\"#Местные!M202:p214\",\"ЛЦ -1 (западная сторона) Шихтовой (длинная)\")","v":"ЛЦ -1 (западная сторона) Шихтовой (длинная)"}]
[{"$f":"HYPERLINK(\"#Местные!M64:p93\",\"Старый нефтеслив\")","v":"Старый нефтеслив"},{"$f":"HYPERLINK(\"#Местные!A226:d254\",\"2я выстовочная\")","v":"2я выстовочная"}]
[{"$f":"HYPERLINK(\"#Местные!A90:d116\",\"Пандус\")","v":"Пандус"},{"$f":"HYPERLINK(\"#Местные!E226:h263\",\"3я выстовочная\")","v":"3я выстовочная"}]
[{"$f":"HYPERLINK(\"#Местные!E93:h121\",\"9й путь\")","v":"9й путь"},{"$f":"HYPERLINK(\"#Местные!I226:l263\",\"4я выстовочная\")","v":"4я выстовочная"}]
[{"$f":"HYPERLINK(\"#Местные!i94:l106\",\"ЛЦ - 2\")","v":"ЛЦ - 2"},{"$f":"HYPERLINK(\"#Местные!M226:p250\",\"Старая весовая\")","v":"Старая весовая"}]
[{"$f":"HYPERLINK(\"#Местные!M94:p123\",\"Сушка песка\")","v":"Сушка песка"},{"$f":"HYPERLINK(\"#Местные!M253:p268\",\"Склад пружин (путь за диспетчерской)\")","v":"Склад пружин (путь за диспетчерской)"}]

{"sheet":"Местные","index":1,"n_rows":268,"n_cols":20,"rows_kept":268,"cut":false,"hidden":false,"merged":[[214,0,214,3],[201,12,202,15],[253,0,253,3],[262,4,262,7],[262,8,262,11],[249,12,249,15],[252,12,253,15],[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],[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],[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],[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],[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],[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]]}
["ЛЦ - 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,"от экспедиции до выбивок"]
["нет",null,null,null,"нет",null,null,null,"нет"]
["нет",null,null,null,"5й путь (по БАМу)",null,null,null,"нет"]
["нет",null,null,null,null,null,null,null,"нет"]
["нет",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,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,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":0},{"$f":"COUNTA(B233:B243)","v":0},{"$f":"COUNTA(B245:B252)","v":0},"факт",{"$f":"COUNTA(F233:F250,F252:F261)","v":0},{"$f":"COUNTA(F233:F250)","v":0},{"$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,"всего","8"]
[null,null,null,null,null,null,null,null,null,null,null,null,"факт",{"$f":"COUNTA(N259:N268)","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,"нет"]

{"sheet":"МПС","index":2,"n_rows":185,"n_cols":15,"rows_kept":185,"cut":false,"hidden":false,"merged":[[6,0,6,4],[6,5,6,9],[6,10,6,14],[0,0,1,4],[0,5,1,9],[0,10,1,14],[4,5,4,9],[4,10,4,14],[51,5,51,9],[14,0,14,4],[18,5,18,9],[25,10,25,14],[28,5,28,9],[37,10,37,14],[38,0,39,4],[38,5,39,9],[38,10,39,14],[42,0,42,4],[42,5,42,9],[44,0,44,4],[44,5,44,9],[44,10,44,14],[90,0,90,4],[52,10,52,14],[62,5,62,9],[63,0,63,4],[75,0,75,4],[76,0,77,4],[76,5,77,9],[76,10,77,14],[78,7,79,7],[78,8,79,8],[82,0,82,4],[82,5,82,9],[82,10,82,14],[91,5,91,9],[92,10,92,14],[99,0,99,4],[100,5,100,9],[106,0,107,4],[106,5,107,9],[106,10,107,14],[136,10,137,14],[108,11,109,11],[108,12,109,12],[112,5,112,9],[112,10,112,14],[120,5,120,9],[122,10,122,14],[123,0,123,4],[124,5,124,9],[130,5,130,9],[136,0,137,4],[136,5,137,9],[184,0,184,4],[142,10,142,14],[149,10,149,14],[150,5,150,9],[155,0,156,4],[173,0,174,4],[173,5,174,9]]}
["8ой путь (весовая)",null,null,null,null,"2я выстовочная",null,null,null,null,"3я выстовочная"]
[]
["всего","до весов 5","за дор-ой 10",null,null,"всего","15","до дорожки 9","за дорожкой 6",null,"всего","22","до дорожки 15","за дорожкой 7 "]
["факт",{"$f":"COUNTA(B8:B14)","v":1},{"$f":"COUNTA(B16:B27)","v":0},null,null,"факт",{"$f":"COUNTA(G8:G18,G20:G27)","v":0},{"$f":"COUNTA(G8:G18)","v":0},{"$f":"COUNTA(G20:G27)","v":0},null,"факт",{"$f":"COUNTA(L8:L25,L27:L36)","v":0},{"$f":"COUNTA(L8:L25)","v":0},{"$f":"COUNTA(L27:L36)","v":0}]
[null,null,null,null,null,"расстановка единиц от выездных ворот",null,null,null,null,"расстановка единиц от выездных ворот"]
["№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
["до весов",null,null,null,null,"до дорожки",null,null,null,null,"до дорожки"]
["5555",null,null,null,null,null,null,null,null,null,null,null,null,null,"выдан"]
["5555"]
["5555","порожний","взвешен","старирован","ожидание выдачи"]
[]
[]
[]
[]
["за дорожкой"]
[]
[]
[]
[null,null,null,null,null,"за дорожкой"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"за дорожкой"]
[]
[null,null,null,null,null,"№ МПС  ↑","ГРУЗ  ↑","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
[null,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ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
[null,null,null,null,null,null,null,null,null,null,"со стороны депо"]
["4я выстовочная",null,null,null,null,"Старая весовая",null,null,null,null,"Котельная"]
[]
["всего","23","до дорожки 15","за дорожкой 8",null,"всего","12","до дорожки 4","за дорожкой 7",null,"всего","до дор-ки 5","за дор-ой 6"]
["факт",{"$f":"COUNTA(B46:B63,B65:B74)","v":0},{"$f":"COUNTA(B46:B63)","v":0},{"$f":"COUNTA(B65:B74)","v":0},null,"факт",{"$f":"COUNTA(G46:G51,G53:G61)","v":0},{"$f":"COUNTA(G46:G51)","v":0},{"$f":"COUNTA(G53:G61)","v":0},null,"факт",{"$f":"COUNTA(L46:L52)","v":0},{"$f":"COUNTA(L54:L61)","v":0}]
["расстановка единиц от выездных ворот",null,null,null,null,"расстановка единиц от выездных ворот"]
["№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
["до дорожки",null,null,null,null,"до дорожки",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ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
[null,null,null,null,null,"со стороны депо"]
["за дорожкой"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["№ МПС  ↑","ГРУЗ  ↑","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
["со стороны депо"]
["Канава известника",null,null,null,null,"Объезд канавы известника",null,null,null,null,"Старый нефтеслив"]
[]
["всего","в зоне крана 6","до переезда 5","за канавой 3",null,"всего","до перезда 6 ","от заправки до переезда 6 запад","за канавой за переездом 3",null,"всего","до переезда 7","за переездом 10"]
["факт",{"$f":"COUNTA(B92:B99)","v":0},{"$f":"COUNTA(B84:B90)","v":0},{"$f":"COUNTA(B101:B105)","v":0},null,null,null,null,null,null,"факт",{"$f":"COUNTA(L84:L92)","v":0},{"$f":"COUNTA(L94:L106)","v":0}]
[null,null,null,null,null,"факт",{"$f":"COUNTA(G84:G91)","v":0},{"$f":"COUNTA(G93:G100)","v":0},{"$f":"COUNTA(G102:G106)","v":0}]
["№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
["до переезда",null,null,null,null,"до переезда",null,null,null,null,"до переезда"]
[]
[]
[]
[]
[]
[]
[]
[" канава (в зоне крана)"]
[null,null,null,null,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ый путь"]
[]
["всего","9","по бурам 6",null,null,"всего","5","3","3",null,"всего","от прохода пандуса до переезда 7","по ЛЦ -2 за проходом сушки песка до переезда 10"]
["факт",{"$f":"COUNTA(B113:B123)","v":0},{"$f":"COUNTA(B125:B132)","v":0},null,null,"факт",{"$f":"COUNTA(G114:G120)","v":0},{"$f":"COUNTA(G122:G124)","v":0},{"$f":"COUNTA(G126:G130)","v":0}]
[null,null,null,null,null,"всего ","3","факт",{"$f":"COUNTA(G132:G136)","v":0},null,"факт",{"$f":"COUNTA(L114:L122)","v":0},{"$f":"COUNTA(L124:L135)","v":0}]
["№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
[null,null,null,null,null,"правая сушки песка (5)",null,null,null,null,"от прохода пандуса до переезда"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"левая сушки песка (3)"]
[]
[null,null,null,null,null,null,null,null,null,null,"по ЛЦ -2 за проходом сушки песка до переезда "]
["по бурам "]
[null,null,null,null,null,"по левой от переезда до ворот (3)"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"по правой от переезда до ворот (3)"]
[]
[]
[]
[]
[]
["Склад сбыта",null,null,null,null,"Склад металлов",null,null,null,null,"6ой путь (копровая)"]
[]
["всего","8",null,null,null,"всего","6","по складу 10",null,null,"всего","до тропинки 4","от тропинки 22"]
["факт",{"$f":"COUNTA(B143:B152)","v":0},null,null,null,"факт",{"$f":"COUNTA(G143:G150)","v":0},{"$f":"COUNTA(G152:G163)","v":0},null,null,"факт",{"$f":"COUNTA(L144:L149)","v":0},{"$f":"COUNTA(L151:L173)","v":0}]
[]
["№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
[null,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 (Шихтовой)"]
[]
["всего","10","9 в зоне крана"]
["факт",{"$f":"COUNTA(B162:B173)","v":0}]
[]
["№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Склад огнеупоров",null,null,null,null,"по мусорной (за проходом склада огнеупроров)"]
[]
["всего","3","по складу 1",null,null,"всего"]
["факт",{"$f":"COUNTA(B180:B184)","v":0},{"$f":"COUNTA(B186:B187)","v":0},null,null,"факт",{"$f":"COUNTA(G180:G193)","v":0}]
[]
["№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ","№ МПС  ↓","ГРУЗ  ↓","1ое ВЗВ-Е","2ое ВЗВ-Е","ОПЕРАЦИЯ"]
[]
[]
[]
[]
[]
["по складу "]

{"sheet":"выданный мпс","index":3,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["№ МПС ","ГРУЗ","ДАТА и время выдачи"]

{"sheet":"данные","index":4,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["нет","платформа","думпкар","полувагон","контующийся","цистерна",null,null,null,null,null,"вес","груз",null,"грузмпс","взвешивание","операции",null,"№МПС"]
[null,"001","505","063","5607 не конт","004"]
[null,"002","5609",null,"001 под из-к",null,null,null,null,null,null,"старир-н(а)","шихта",null,"порожний","взвешен","ожидание погрузки",null,"5555"]
[null,"003","5612",null,"514 под из-к",null,null,null,null,null,null,"взв-н(а)","плита(ы)",null,"песок","старирован","погрузка"]
[null,null,"13336",null,null,null,null,null,null,null,null,null,"скрап-шлак",null,"песок в мешках",null,"ожидание выгрузки"]
[null,null,"519",null,null,null,null,null,null,null,null,null,null,null,"бентонит",null,"выгрузка"]
[null,null,"893",null,null,null,null,null,null,null,null,null,null,null,null,null,"ожидание зачистки"]
[null,null,"5604",null,null,null,null,null,null,null,null,null,null,null,null,null,"зачистка"]
[null,null,"1364",null,null,null,null,null,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":5,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[22,7,22,9],[23,7,31,10],[9,7,20,9],[4,7,5,8],[0,7,1,8],[7,3,8,5],[2,7,3,8],[3,0,3,1],[6,0,6,1],[0,4,1,5],[2,4,3,5],[7,7,8,9],[30,3,33,5],[34,3,35,5],[27,3,29,5],[10,0,10,1],[13,0,14,1],[9,3,20,5],[17,0,18,2],[21,3,22,5],[23,3,24,5],[25,3,26,5]]}
["=ДВССЫЛ(",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,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",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 = 10 Or a = 15) And b > 6 Then\n        u = Target.Value\n        If u = \"выдан\" Then Range(Cells(b, a), Cells(b, a - 4)).ClearContents\n    End If\nEnd Sub"]
["=ДВССЫЛ(данные!$L$1)"]
[]
["факт"]
["=СЧЁТЗ( формат ячейки общий"]
[]
[]
[]
["=ГИПЕРССЫЛКА(\"#Местные!A1:D14\";\"ЛЦ - 1 Шихтовой\")"]
[]
[]
[]
[null,null,null,"где: (a = 1 Or a = 5 Or a = 9 Or a = 13) номера столбцов "]
[null,null,null,null,null,null,null,"Макрос для быза мпс"]
[null,null,null,"где: And b > 6 начиная с 7 строки",null,null,null,"Sub Add_Sell()\n    Worksheets(\"МЕНЮ\").Range(\"E7\").Copy\n n=Worksheets(\"данные\").Range(\"S2\").Range(\"A100000\").End(xlUp).Row\n    Worksheets(\"данные\").Range(\"S1\").Cells(n + 1, 1).PasteSpecial Paste:=xlPasteValues\n    Worksheets(\"МЕНЮ\").Range(\"E7\").ClearContents\nEnd Sub"]
[]
[null,null,null,"где: Cells(b, a + 3)) количество обнуляемых столбцов"]
[]
[null,null,null," If (a = 1 Or a = 5 Or a = 9 Or a = 13) And b > 6 And c = 3 Then где: And c = 3 - проверка наличия выпадающего списка"]
[]
[]
[null,null,null,"If (a = 1 Or a = 5 Or a = 9 Or a = 13) And b > 6 And Then удалить строчку c = Target.Validation.Type тогда без проверки выпадающего списка сносит все данные в строке"]
[]
[]
[]
[null,null,null,"Cells(b, a + 1) удалить +1 будет очищать так же ячейку со словом \"нет\""]