{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Горизонт"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Горизонт","index":0,"n_rows":49,"n_cols":36,"rows_kept":49,"cut":false,"hidden":false,"merged":[[5,1,5,34],[1,7,1,8],[1,9,1,10],[2,7,2,8],[2,9,2,10],[4,1,4,34],[48,2,48,13],[9,2,9,32],[29,2,29,3],[6,1,6,34],[7,1,7,34],[9,1,10,1],[30,1,31,1],[39,1,40,1],[39,6,40,7]]}
[]
[null,"Сегодня",null,null,null,null,null,"Месяц",null,"Год"]
[null,{"$f":"TODAY()","v":"2013-11-16"},null,null,null,null,null,11,null,2013]
[null,{"$f":"WEEKDAY(TODAY())","v":"1900-01-07"}]
[null,"ГРАФИК РАБОТЫ"]
[null,"докеров механизаторов бригад № 19,20"]
[]
[null,{"$f":"DATE($J$3,$H$3,1)","v":"2013-11-01"}]
[]
[null,"Звено"]
[null,null,{"$f":"DATE($J$3,$H$3,1)","v":"2013-11-01"},{"$f":"C11+1","v":"2013-11-02"},{"$f":"D11+1","v":"2013-11-03"},{"$f":"E11+1","v":"2013-11-04"},"2013-11-05","2013-11-06","2013-11-07","2013-11-08","2013-11-09",{"$f":"K11+1","v":"2013-11-10"},{"$f":"L11+1","v":"2013-11-11"},{"$f":"M11+1","v":"2013-11-12"},"2013-11-13","2013-11-14","2013-11-15","2013-11-16","2013-11-17","2013-11-18",{"$f":"T11+1","v":"2013-11-19"},{"$f":"U11+1","v":"2013-11-20"},{"$f":"V11+1","v":"2013-11-21"},"2013-11-22","2013-11-23","2013-11-24","2013-11-25","2013-11-26","2013-11-27",{"$f":"AC11+1","v":"2013-11-28"},{"$f":"AD11+1","v":"2013-11-29"},{"$f":"AE11+1","v":"2013-11-30"},{"$f":"AF11+1","v":"2013-12-01"},"Смен","Часов","В т.ч. Ночн."]
[3,"19/1 звено",{"$f":"CHOOSE(MOD(C$11-$A12,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\")","v":"20-8"},{"$f":"CHOOSE(MOD(D$11-$A12,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\")","v":"20-8"},"/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A12,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\"))","v":"-"},{"$f":"IF(DAY(AF$11)<28,\"\",CHOOSE(MOD(AF$11-$A12,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\"))","v":"8-20"},"",{"$f":"COUNTIF(C12:AG12,\"8-20\")+COUNTIF(C12:AG12,\"20-8\")","v":15},{"$f":"AH12*11.5+OR(MOD(C$11-A12,8)={1;2})*7.5-(LOOKUP(2,1/(AD12:AG12<>\"\"),AD12:AG12)=\"20-8\")*7.5","v":172.5},{"$f":"COUNTIF(C12:AG12,\"20-8\")*7.5+OR(MOD(C$11-A12,8)={1;2})*5.5-(LOOKUP(2,1/(AD12:AG12<>\"\"),AD12:AG12)=\"20-8\")*5.5","v":60}]
[5,"19/2 звено",{"$f":"CHOOSE(MOD(C$11-$A13,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\")","v":"8-20"},"-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A13,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\"))","v":"/8"},"-","",15,{"$f":"AH13*11.5+OR(MOD(C$11-A13,8)={1;2})*7.5-(LOOKUP(2,1/(AD13:AG13<>\"\"),AD13:AG13)=\"20-8\")*7.5","v":172.5},{"$f":"COUNTIF(C13:AG13,\"20-8\")*7.5+OR(MOD(C$11-A13,8)={1;2})*5.5-(LOOKUP(2,1/(AD13:AG13<>\"\"),AD13:AG13)=\"20-8\")*5.5","v":60}]
[7,"19/3 звено",{"$f":"CHOOSE(MOD(C$11-$A14,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\")","v":"-"},"8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A14,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\"))","v":"20-8"},"20-8","",16,{"$f":"AH14*11.5+OR(MOD(C$11-A14,8)={1;2})*7.5-(LOOKUP(2,1/(AD14:AG14<>\"\"),AD14:AG14)=\"20-8\")*7.5","v":176.5},{"$f":"COUNTIF(C14:AG14,\"20-8\")*7.5+OR(MOD(C$11-A14,8)={1;2})*5.5-(LOOKUP(2,1/(AD14:AG14<>\"\"),AD14:AG14)=\"20-8\")*5.5","v":54.5}]
[1,"19/4 звено",{"$f":"CHOOSE(MOD(C$11-$A15,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\")","v":"/8"},"-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A15,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\"))","v":"8-20"},"-","",14,{"$f":"AH15*11.5+OR(MOD(C$11-A15,8)={1;2})*7.5-(LOOKUP(2,1/(AD15:AG15<>\"\"),AD15:AG15)=\"20-8\")*7.5","v":168.5},{"$f":"COUNTIF(C15:AG15,\"20-8\")*7.5+OR(MOD(C$11-A15,8)={1;2})*5.5-(LOOKUP(2,1/(AD15:AG15<>\"\"),AD15:AG15)=\"20-8\")*5.5","v":50.5}]
[1,"19/5 звено",{"$f":"CHOOSE(MOD(C$11-$A16,7)+1,\"-\",\"8\",\"8\",\"8\",\"8\",\"8\",\"-\")","v":"8"},"-","-","8","8","8","8","8","-","-","8","8","8","8","8","-","-","8","8","8","8","8","-","-","8","8","8","8",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A16,7)+1,\"-\",\"8\",\"8\",\"8\",\"8\",\"8\",\"-\"))","v":"8"},{"$f":"IF(DAY(AF$11)<28,\"\",CHOOSE(MOD(AF$11-$A16,7)+1,\"-\",\"8\",\"8\",\"8\",\"8\",\"8\",\"-\"))","v":"-"},{"$f":"IF(DAY(AG$11)<28,\"\",CHOOSE(MOD(AG$11-$A16,7)+1,\"-\",\"8\",\"8\",\"8\",\"8\",\"8\",\"-\"))","v":""},{"$f":"COUNTIF(C16:AG16,\"8\")","v":21},{"$f":"AH16*8","v":168}]
[4,"19/5-1 звено",{"$f":"CHOOSE(MOD(C$11-$A17,8)+1,\"8-20\",\"8-20\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\",\"-\")","v":"-"},{"$f":"CHOOSE(MOD(D$11-$A17,8)+1,\"8-20\",\"8-20\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\",\"-\")","v":"8-20"},"8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A17,8)+1,\"8-20\",\"8-20\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\",\"-\"))","v":"-"},"8-20","",{"$f":"COUNTIF(C17:AG17,\"8-20\")","v":15},{"$f":"AH17*11.5","v":172.5}]
[2,"19/5-2 звено",{"$f":"CHOOSE(MOD(C$11-$A18,8)+1,\"8-20\",\"8-20\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\",\"-\")","v":"8-20"},"-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","",{"$f":"COUNTIF(C18:AG18,\"8-20\")","v":15},{"$f":"AH18*11.5","v":172.5}]
[3,"Ремизов В.А.",{"$f":"CHOOSE(MOD(C$11-$A19,4)+1,\"8-20\",\"8-20\",\"-\",\"-\",)","v":"8-20"},{"$f":"CHOOSE(MOD(D$11-$A19,4)+1,\"8-20\",\"8-20\",\"-\",\"-\",)","v":"8-20"},{"$f":"CHOOSE(MOD(E$11-$A19,4)+1,\"8-20\",\"8-20\",\"-\",\"-\",)","v":"-"},"-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","",16,184]
[1,"Сапрыкин А.И.",{"$f":"CHOOSE(MOD(C$11-$A20,4)+1,\"8-20\",\"8-20\",\"-\",\"-\",)","v":"-"},{"$f":"CHOOSE(MOD(D$11-$A20,4)+1,\"8-20\",\"8-20\",\"-\",\"-\",)","v":"-"},"8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","8-20","8-20","-","-","",14,161]
[3,"20/1 звено",{"$f":"CHOOSE(MOD(C$11-$A21,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\")","v":"20-8"},{"$f":"CHOOSE(MOD(D$11-$A21,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\")","v":"20-8"},"/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A21,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\"))","v":"-"},{"$f":"IF(DAY(AF$11)<28,\"\",CHOOSE(MOD(AF$11-$A21,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\"))","v":"8-20"},"",{"$f":"COUNTIF(C21:AG21,\"8-20\")+COUNTIF(C21:AG21,\"20-8\")","v":15},{"$f":"AH21*11.5+OR(MOD(C$11-A21,8)={1;2})*7.5-(LOOKUP(2,1/(AD21:AG21<>\"\"),AD21:AG21)=\"20-8\")*7.5","v":172.5},{"$f":"COUNTIF(C21:AG21,\"20-8\")*7.5+OR(MOD(C$11-A21,8)={1;2})*5.5-(LOOKUP(2,1/(AD21:AG21<>\"\"),AD21:AG21)=\"20-8\")*5.5","v":60}]
[1,"20/2 звено",{"$f":"CHOOSE(MOD(C$11-$A22,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\")","v":"/8"},"-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A22,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\"))","v":"8-20"},"-","",{"$f":"COUNTIF(C22:AG22,\"8-20\")+COUNTIF(C22:AG22,\"20-8\")","v":14},{"$f":"AH22*11.5+OR(MOD(C$11-A22,8)={1;2})*7.5-(LOOKUP(2,1/(AD22:AG22<>\"\"),AD22:AG22)=\"20-8\")*7.5","v":168.5},{"$f":"COUNTIF(C22:AG22,\"20-8\")*7.5+OR(MOD(C$11-A22,8)={1;2})*5.5-(LOOKUP(2,1/(AD22:AG22<>\"\"),AD22:AG22)=\"20-8\")*5.5","v":50.5}]
[7,"20/3 звено",{"$f":"CHOOSE(MOD(C$11-$A23,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\")","v":"-"},"8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A23,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\"))","v":"20-8"},"20-8","",{"$f":"COUNTIF(C23:AG23,\"8-20\")+COUNTIF(C23:AG23,\"20-8\")","v":16},{"$f":"AH23*11.5+OR(MOD(C$11-A23,8)={1;2})*7.5-(LOOKUP(2,1/(AD23:AG23<>\"\"),AD23:AG23)=\"20-8\")*7.5","v":176.5},{"$f":"COUNTIF(C23:AG23,\"20-8\")*7.5+OR(MOD(C$11-A23,8)={1;2})*5.5-(LOOKUP(2,1/(AD23:AG23<>\"\"),AD23:AG23)=\"20-8\")*5.5","v":54.5}]
[5,"20/4 звено",{"$f":"CHOOSE(MOD(C$11-$A24,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\")","v":"8-20"},"-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8","/8","-","-","8-20","8-20","-","20-8","20-8",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A24,8)+1,\"20-8\",\"20-8\",\"/8\",\"-\",\"-\",\"8-20\",\"8-20\",\"-\"))","v":"/8"},"-","",{"$f":"COUNTIF(C24:AG24,\"8-20\")+COUNTIF(C24:AG24,\"20-8\")","v":15},{"$f":"AH24*11.5+OR(MOD(C$11-A24,8)={1;2})*7.5-(LOOKUP(2,1/(AD24:AG24<>\"\"),AD24:AG24)=\"20-8\")*7.5","v":172.5},{"$f":"COUNTIF(C24:AG24,\"20-8\")*7.5+OR(MOD(C$11-A24,8)={1;2})*5.5-(LOOKUP(2,1/(AD24:AG24<>\"\"),AD24:AG24)=\"20-8\")*5.5","v":60}]
[1,"20/5 звено",{"$f":"CHOOSE(MOD(C$11-$A16,7)+1,\"-\",\"8\",\"8\",\"8\",\"8\",\"8\",\"-\")","v":"8"},{"$f":"CHOOSE(MOD(D$11-$A16,7)+1,\"-\",\"8\",\"8\",\"8\",\"8\",\"8\",\"-\")","v":"-"},"-","8","8","8","8","8","-","-","8","8","8","8","8","-","-","8","8","8","8","8","-","-","8","8","8","8",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A16,7)+1,\"-\",\"8\",\"8\",\"8\",\"8\",\"8\",\"-\"))","v":"8"},{"$f":"IF(DAY(AF$11)<28,\"\",CHOOSE(MOD(AF$11-$A16,7)+1,\"-\",\"8\",\"8\",\"8\",\"8\",\"8\",\"-\"))","v":"-"},{"$f":"IF(DAY(AG$11)<28,\"\",CHOOSE(MOD(AG$11-$A16,7)+1,\"-\",\"8\",\"8\",\"8\",\"8\",\"8\",\"-\"))","v":""},{"$f":"COUNTIF(C25:AG25,\"8\")","v":21},{"$f":"AH25*8","v":168}]
[1,"20/5-1",{"$f":"CHOOSE(MOD(C$11-$A26,4)+1,\"9-21\",\"9-21\",\"-\",\"-\",)","v":"-"},{"$f":"CHOOSE(MOD(D$11-$A26,4)+1,\"9-21\",\"9-21\",\"-\",\"-\",)","v":"-"},"9-21","9-21","-","-","9-21","9-21","-","-","9-21","9-21","-","-","9-21","9-21","-","-","9-21","9-21","-","-","9-21","9-21","-","-","9-21","9-21",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A26,8)+1,\"9-21\",\"9-21\",\"-\",\"-\",\"9-21\",\"9-21\",\"-\",\"-\"))","v":"-"},{"$f":"IF(DAY(AF$11)<28,\"\",CHOOSE(MOD(AF$11-$A26,8)+1,\"9-21\",\"9-21\",\"-\",\"-\",\"9-21\",\"9-21\",\"-\",\"-\"))","v":"-"},{"$f":"IF(DAY(AG$11)<28,\"\",CHOOSE(MOD(AG$11-$A26,8)+1,\"9-21\",\"9-21\",\"-\",\"-\",\"9-210\",\"9-21\",\"-\",\"-\"))","v":""},{"$f":"COUNTIF(C26:AG26,\"9-21\")","v":14},{"$f":"AH26*11.5","v":161}]
[3,"20/5-2",{"$f":"CHOOSE(MOD(C$11-$A27,4)+1,\"9-21\",\"9-21\",\"-\",\"-\",)","v":"9-21"},"9-21","-","-","9-21","9-21","-","-","9-21","9-21","-","-","9-21","9-21","-","-","9-21","9-21","-","-","9-21","9-21","-","-","9-21","9-21","-","-",{"$f":"IF(DAY(AE$11)<28,\"\",CHOOSE(MOD(AE$11-$A27,8)+1,\"9-21\",\"9-21\",\"-\",\"-\",\"9-21\",\"9-21\",\"-\",\"-\"))","v":"9-21"},{"$f":"IF(DAY(AF$11)<28,\"\",CHOOSE(MOD(AF$11-$A27,8)+1,\"9-21\",\"9-21\",\"-\",\"-\",\"9-21\",\"9-21\",\"-\",\"-\"))","v":"9-21"},{"$f":"IF(DAY(AG$11)<28,\"\",CHOOSE(MOD(AG$11-$A27,8)+1,\"9-21\",\"9-21\",\"-\",\"-\",\"9-21\",\"9-21\",\"-\",\"-\"))","v":""},{"$f":"COUNTIF(C27:AG27,\"9-21\")","v":16},{"$f":"AH27*11.5","v":184}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020]
[]
[]
[]
[null,null,"                                                                                                                            "]