{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Monat"],"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":"Monat","index":0,"n_rows":32,"n_cols":26,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["2016-09-01","2016-09-01",1424.4,0.20555555555555557,"-",0.53402777777777777,"","TH",0.32083333333333336,"-",0.35625000000000001,null,"K",0,"",0,null,{"$f":"A1","v":"2016-09-01"},"Datum","Betrifft","Ganztägig","Beginntam","Beginntum","Endetam","Endetum","Text"]
["2016-09-02","2016-09-02",1428.5,0.16041666666666668,"-",0.46666666666666662,"▼",0,0,"",0,null,"Nichts",0,"",0,null,null,{"$f":"IF(A1=\"\",\"\",A1)","v":"2016-09-01"},{"$f":"IF(C1=\"?\",\"Blank\",IF(C1=\"-\",\"Ausgleichstag\",IF(C1=\"=\",\"Rasttag\",IF(C1=\"T\",\"Treueprämie\",IF(C1=\"F\",\"Ferien\",IF(C1=\"\",\"\",TEXT(C1,\"0000.0\")))))))","v":"1424.4"},{"$f":"IF(OR(T2=\"Ausgleichstag\",T2=\"Rasttag\",T2=\"Blank\",T2=\"Ferien\")=TRUE,\"Ja\",\"\")","v":""},{"$f":"S2","v":"2016-09-01"},{"$f":"IF(D1=\"\",VALUE(0),D1)","v":0.20555555555555557},{"$f":"IF(U2=\"Ja\",V2+1,IF(W2>Y2,V2+1,V2))","v":"2016-09-01"},{"$f":"IF(F1=\"\",VALUE(0),F1)","v":0.53402777777777777},{"$f":"IF(G1=\"▼\",\"Kurzpause\",\"\")&IF(OR(G1=\"▼\",F1=\"\"),\"\",\"Pause: \"&H1)&\" \"&IF(G1<>\"▼\",TEXT(I1,\"hh:mm\"),\"\")&J1&IF(G1<>\"▼\",TEXT(K1,\"hh:mm\"),\"\")&IF(L1>0,\"\\nMahlzeit: \"&L1&IF(OR(F1=\"\",M1=\"\"),\"\",IF(AND(N1=0,P1=0)=TRUE,\"\\nMahlzeit: \"&M1,\"\\nPause2: \"&M1))&\" \"&IF(AND(N1=0,P1=0)=FALSE,TEXT(N1,\"hh:mm\"),\"\")&O1&IF(AND(N1=0,P1=0)=FALSE,TEXT(P1,\"hh:mm\"),\"\"),IF(OR(F1=\"\",M1=\"\"),\"\",IF(AND(N1=0,P1=0)=TRUE,\"\\nMahlzeit: \"&M1,\"\\nPause2: \"&M1))&\" \"&IF(AND(N1=0,P1=0)=FALSE,TEXT(N1,\"hh:mm\"),\"\")&O1&IF(AND(N1=0,P1=0)=FALSE,TEXT(P1,\"hh:mm\"),\"\"))","v":"Pause: TH 07:42-08:33\\nMahlzeit: K "}]
["2016-09-03","2016-09-03",1422.6,0.19166666666666665,"-",0.50763888888888886,"▼",0,0,"",0,null,"Nichts",0,"",0,null,null,{"$f":"IF(A2=\"\",\"\",A2)","v":"2016-09-02"},{"$f":"IF(C2=\"?\",\"Blank\",IF(C2=\"-\",\"Ausgleichstag\",IF(C2=\"=\",\"Rasttag\",IF(C2=\"T\",\"Treueprämie\",IF(C2=\"F\",\"Ferien\",IF(C2=\"\",\"\",TEXT(C2,\"0000.0\")))))))","v":"1428.5"},{"$f":"IF(OR(T3=\"Ausgleichstag\",T3=\"Rasttag\",T3=\"Blank\",T3=\"Ferien\")=TRUE,\"Ja\",\"\")","v":""},{"$f":"S3","v":"2016-09-02"},0.16041666666666668,{"$f":"IF(U3=\"Ja\",V3+1,IF(W3>Y3,V3+1,V3))","v":"2016-09-02"},0.46666666666666662,"Kurzpause \\nMahlzeit: Nichts "]
["2016-09-04","2016-09-04",1422.7,0.18819444444444444,"-",0.51041666666666663,"▼",0,0,"",0,null,"Nichts",0,"",0,null,null,"2016-09-03","1422.6","","2016-09-03",0.19166666666666665,"2016-09-03",0.50763888888888886,"Kurzpause \\nMahlzeit: Nichts "]
["2016-09-05","2016-09-05",1491.1,0.11319444444444444,"-",0.42638888888888887,"▼",0,0,"",0,null,"Nichts",0,"",0,null,null,"2016-09-04","1422.7","","2016-09-04",0.18819444444444444,"2016-09-04",0.51041666666666663,"Kurzpause \\nMahlzeit: Nichts "]
["2016-09-06","2016-09-06",1430.2,0.1986111111111111,"-",0.47916666666666669,"▼",0,0,"",0,null,"Nichts",0,"",0,null,null,"2016-09-05","1491.1","","2016-09-05",0.11319444444444444,"2016-09-05",0.42638888888888887,"Kurzpause \\nMahlzeit: Nichts "]
["2016-09-07","2016-09-07","-","","","","","","","","",null,"","","","",null,null,"2016-09-06","1430.2","","2016-09-06",0.1986111111111111,"2016-09-06",0.47916666666666669,{"$f":"IF(G6=\"▼\",\"Kurzpause\",\"\")&IF(OR(G6=\"▼\",F6=\"\"),\"\",\"Pause: \"&H6)&\" \"&IF(G6<>\"▼\",TEXT(I6,\"hh:mm\"),\"\")&J6&IF(G6<>\"▼\",TEXT(K6,\"hh:mm\"),\"\")&IF(L6>0,\"\\nMahlzeit: \"&L6&IF(OR(F6=\"\",M6=\"\"),\"\",IF(AND(N6=0,P6=0)=TRUE,\"\\nMahlzeit: \"&M6,\"\\nPause2: \"&M6))&\" \"&IF(AND(N6=0,P6=0)=FALSE,TEXT(N6,\"hh:mm\"),\"\")&O6&IF(AND(N6=0,P6=0)=FALSE,TEXT(P6,\"hh:mm\"),\"\"),IF(OR(F6=\"\",M6=\"\"),\"\",IF(AND(N6=0,P6=0)=TRUE,\"\\nMahlzeit: \"&M6,\"\\nPause2: \"&M6))&\" \"&IF(AND(N6=0,P6=0)=FALSE,TEXT(N6,\"hh:mm\"),\"\")&O6&IF(AND(N6=0,P6=0)=FALSE,TEXT(P6,\"hh:mm\"),\"\"))","v":"Kurzpause \\nMahlzeit: Nichts "}]
["2016-09-08","2016-09-08","=","","","","","","","","",null,"","","","",null,null,"2016-09-07","Ausgleichstag","Ja","2016-09-07",0,"2016-09-08",0,"  "]
["2016-09-09","2016-09-09",1405.5,0.73958333333333337,"-",5.4166666666666669E-2,"▼",0,0,"",0,null,"Sand",0,"",0,null,null,"2016-09-08","Rasttag","Ja","2016-09-08",0,"2016-09-09",0,"  "]
["2016-09-10","2016-09-10",1405.6,0.69027777777777777,"-",3.9583333333333331E-2,"▼",0,0,"",0,null,"K",0,"",0,null,null,"2016-09-09","1405.5","","2016-09-09",0.73958333333333337,"2016-09-10",5.4166666666666669E-2,"Kurzpause \\nMahlzeit: Sand "]
["2016-09-11","2016-09-11",1404.7,0.71250000000000002,"-",6.25E-2,"▼",0,0,"",0,null,"K",0,"",0,null,null,"2016-09-10","1405.6","","2016-09-10",0.69027777777777777,"2016-09-11",3.9583333333333331E-2,"Kurzpause \\nMahlzeit: K "]
["2016-09-12","2016-09-12",1409.1,0.58750000000000002,"-",0.91041666666666676,"","BDF",0.76041666666666663,"-",0.79583333333333339,null,"W",0,"",0,null,null,"2016-09-11","1404.7","","2016-09-11",0.71250000000000002,"2016-09-12",6.25E-2,"Kurzpause \\nMahlzeit: K "]
["2016-09-13","2016-09-13",1413.2,0.54583333333333328,"-",0.84583333333333333,"▼",0,0,"",0,null,"K",0,"",0,null,null,"2016-09-12","1409.1","","2016-09-12",0.58750000000000002,"2016-09-12",0.91041666666666676,"Pause: BDF 18:15-19:06\\nMahlzeit: W "]
["2016-09-14","2016-09-14",1417.3,0.375,"-",0.72916666666666663,"▼",0,0,"",0,null,"W",0,"",0,null,null,"2016-09-13","1413.2","","2016-09-13",0.54583333333333328,"2016-09-13",0.84583333333333333,"Kurzpause \\nMahlzeit: K "]
["2016-09-15","2016-09-15","-","","","","","","","","",null,"","","","",null,null,"2016-09-14","1417.3","","2016-09-14",0.375,"2016-09-14",0.72916666666666663,"Kurzpause \\nMahlzeit: W "]
["2016-09-16","2016-09-16","=","","","","","","","","",null,"","","","",null,null,"2016-09-15","Ausgleichstag","Ja","2016-09-15",0,"2016-09-16",0,"  "]
["2016-09-17","2016-09-17","=","","","","","","","","",null,"","","","",null,null,"2016-09-16","Rasttag","Ja","2016-09-16",0,"2016-09-17",0,"  "]
["2016-09-18","2016-09-18","=","","","","","","","","",null,"","","","",null,null,"2016-09-17","Rasttag","Ja","2016-09-17",0,"2016-09-18",0,"  "]
["2016-09-19","2016-09-19",1411.1,0.53402777777777777,"-",0.8833333333333333,"","LZ",0.72152777777777777,"-",0.7597222222222223,null,"W",0,"",0,null,null,"2016-09-18","Rasttag","Ja","2016-09-18",0,"2016-09-19",0,"  "]
["2016-09-20","2016-09-20",1416.2,0.4201388888888889,"-",0.74652777777777779,"▼",0,0,"",0,null,"K",0,"",0,null,null,"2016-09-19","1411.1","","2016-09-19",0.53402777777777777,"2016-09-19",0.8833333333333333,"Pause: LZ 17:19-18:14\\nMahlzeit: W "]
["2016-09-21","2016-09-21",1419.3,0.2388888888888889,"-",0.62083333333333335,"","BN",0.4069444444444445,"-",0.45277777777777778,null,"K",0,"",0,null,null,"2016-09-20","1416.2","","2016-09-20",0.4201388888888889,"2016-09-20",0.74652777777777779,"Kurzpause \\nMahlzeit: K "]
["2016-09-22","2016-09-22",1428.4,0.16041666666666668,"-",0.46666666666666662,"▼",0,0,"",0,null,"Nichts",0,"",0,null,null,"2016-09-21","1419.3","","2016-09-21",0.2388888888888889,"2016-09-21",0.62083333333333335,"Pause: BN 09:46-10:52\\nMahlzeit: K "]
["2016-09-23","2016-09-23","-","","","","","","","","",null,"","","","",null,null,"2016-09-22","1428.4","","2016-09-22",0.16041666666666668,"2016-09-22",0.46666666666666662,"Kurzpause \\nMahlzeit: Nichts "]
["2016-09-24","2016-09-24","=","","","","","","","","",null,"","","","",null,null,"2016-09-23","Ausgleichstag","Ja","2016-09-23",0,"2016-09-24",0,"  "]
["2016-09-25","2016-09-25",1402.7,0.6777777777777777,"-",4.8611111111111112E-2,"▼",0,0,"",0,null,"W",0,"",0,null,null,"2016-09-24","Rasttag","Ja","2016-09-24",0,"2016-09-25",0,"  "]
["2016-09-26","2016-09-26",1401.1,0.71319444444444446,"-",5.7638888888888885E-2,"▼",0,0,"",0,null,"K",0,"",0,null,null,"2016-09-25","1402.7","","2016-09-25",0.6777777777777777,"2016-09-26",4.8611111111111112E-2,"Kurzpause \\nMahlzeit: W "]
["2016-09-27","2016-09-27",1403.2,0.69027777777777777,"-",6.25E-2,"▼",0,0,"",0,null,"Sand",0,"",0,null,null,"2016-09-26","1401.1","","2016-09-26",0.71319444444444446,"2016-09-27",5.7638888888888885E-2,"Kurzpause \\nMahlzeit: K "]
["2016-09-28","2016-09-28",1407.3,0.62916666666666665,"-",0.99236111111111114,"","TH",0.82916666666666661,"-",0.86736111111111114,null,"K",0,"",0,null,null,"2016-09-27","1403.2","","2016-09-27",0.69027777777777777,"2016-09-28",6.25E-2,"Kurzpause \\nMahlzeit: Sand "]
["2016-09-29","2016-09-29",1412.4,0.58611111111111114,"-",0.8833333333333333,"▼",0,0,"",0,null,"K",0,"",0,null,null,"2016-09-28","1407.3","","2016-09-28",0.62916666666666665,"2016-09-28",0.99236111111111114,"Pause: TH 19:54-20:49\\nMahlzeit: K "]
["2016-09-30","2016-09-30",1413.5,0.54583333333333328,"-",0.87291666666666667,"▼",0,0,"",0,null,"K",0,"",0,null,null,"2016-09-29","1412.4","","2016-09-29",0.58611111111111114,"2016-09-29",0.8833333333333333,"Kurzpause \\nMahlzeit: K "]
["","","","","","","","","","","",null,"","","","",null,null,"2016-09-30","1413.5","","2016-09-30",{"$f":"IF(S31=\"\",\"\",IF(D30=\"\",VALUE(0),D30))","v":0.54583333333333328},"2016-09-30",{"$f":"IF(F30=\"\",VALUE(0),F30)","v":0.87291666666666667},"Kurzpause \\nMahlzeit: K "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","",{"$f":"IF(S32=\"\",\"\",IF(D31=\"\",VALUE(0),D31))","v":""},"",{"$f":"IF(S32=\"\",\"\",F31)","v":""},"  "]