{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Startseite","Blanko"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":1,"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":"Startseite","index":0,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,1,0,5],[26,1,26,7],[27,1,27,7],[28,1,28,7],[10,4,22,7]]}
[null,"Stechuhr\n\nby M. K.                                                                             www.koeginator.de                                                                       Version 8.0"]
[]
["Die Berechnung der Feiertage (Gauß'sche Osterformel) funktioniert nur bis zum Jahr 8202 (Da gibt's Dich schon lange nicht mehr).","Jahr  ",2014]
[]
[{"$f":"CONCATENATE(\"Seit wann hat ein Jahr \",C5,\" Monate?\")","v":"Seit wann hat ein Jahr 1 Monate?"},"Monat  ",1,null,"Neues Blatt erstellen für: ",{"$f":"CHOOSE(C5,\"Januar\",\"Februar\",\"März\",\"April\",\"Mai\",\"Juni\",\"Juli\",\"August\",\"September\",\"Oktober\",\"November\",\"Dezember\")","v":"Januar"},"mit"]
[]
["Da gibt's Arbeitsschutzgesetze, die sagen , dass maximal 10 Stunden täglich gearbeitet werden dürfen.","Wöchentliche Arbeitszeit: ",37.5,"(Dezimal)      = >",{"$f":"C7/24","v":1.5625},"  Std : Min"]
[]
["Wie viele Tage hat die Woche ?","Arbeitstage je Woche: ",5,"entspricht (regelm.)",{"$f":"E7/C9","v":"07:30:00"},"Std. je Tag"]
[]
["Wenn Du 24 Stunden an 7 Tagen arbeitest solltest Du die Nacht dazunehmen um so viele Stunden in der Woche zu schuften.","Verteilung der Arbeitszeit:                  am  Montag   ",0.3125,"  Std : Min",{"$f":"IF(C7>168,A11,IF(C3>8202,A3,IF(C5 > 12,A5,IF(C9>7,A9,IF(C7/C9>10,A7,\"\")))))","v":""}]
[]
[null,"am  Dienstag   ",0.3125,"  Std : Min"]
[]
[null,"am  Mittwoch   ",0.3125,"  Std : Min"]
[]
[null,"am  Donnerstag   ",0.3125,"  Std : Min"]
[]
[null,"am  Freitag   ",0.3125,"  Std : Min"]
[]
[null,"…und der Vollständigkeit halber       am  Samstag   ",0,"  Std : Min"]
[]
[null,"am  Sonntag   ",0,"  Std : Min"]
[]
[null,"Wochensumme:   ",{"$f":"SUM(C11:C23)","v":1.5625},"  Std : Min",{"$f":"IF(E7=C25,\"\",IF(C25>E7,\"Stimmt nicht > zu viel\",\"Stimmt nicht > zu wenig\"))","v":""}]
[]
["Installations-\nhinweise:","Diese EXCEL-Liste ist als Vorlage mit Makros erstellt. (Version: Office  2010   .XLTM)\nSie ist in den Vorlagenordner von Microsoft zu speichern (Templates).\nSomit kann man man in EXCEL unter \"DATEI NEU\" eine neue EXCEL-Tabelle (für ein neues Jahr / andere Person) erstellen.\nDie wöchentliche Arbeitszeit (DEZIMAL) und die Arbeitstage je Woche sind ebenfalls anzugeben. \nDie individuelle Arbeitszeit für jeden Wochentag (Format: h:mm) ist einzutragen. \n(Die Wochensumme sollte dann mit der wöchentlichen Arbeitszeit übereinstimmen.)\n"]
["Ausfüllhinweise:","Nach dem Erstellen eines neuen Tabellenblattes empfiehlt es sich mit Doppelklick in den \"Reiter\" >Tabelle ??< zu wechseln und \ndiesen Namen gegen den Monatsnamen für dieses Tabellenblat auszutauschen.\nIm Tabellenblatt sind die Zeiten für Arbeitsbeginn und Arbeitsende, \nevtl. Pausen (u.U. mit Privatzeiten für Arztbesuch, Einkäufe...) einzutragen.\nBemerkungen hierzu können im Feld Bemerkungen angegeben werden.\nBei freien Tagen ist im Feld Bemerkung exakt das Wort Frei einzugeben.\nBei Urlaub ist im Feld Bemerkung exakt das Wort Urlaub einzugeben.\nBei Krankheit ist im Feld Bemerkung exakt das Wort Krankheit einzugeben.\nDamit wird die tägliche Arbeitszeit um den Tagesstundenanteil verringert.\n"]
["Lizezvereinbarung:","Soll dieses Tool nutzen wer will.\nKostet nichts.\nDaher interessieren mich Reklamationen auch nicht.\nIch übernehme keine Garantie für irgendwas.\nSollten Hard- oder Softwarefehler auf dem Rechner auftreten, liegt das bestimmt nicht an dieser EXCEL-Datei.\nNochmal: Keine Gewährleistung.\nDie Garantie erlischt mit der Installation."]

{"sheet":"Blanko","index":1,"n_rows":60,"n_cols":14,"rows_kept":60,"cut":false,"hidden":true,"merged":[[41,8,52,8],[0,0,1,0],[0,1,1,1],[0,9,1,9],[0,2,0,3],[0,4,1,4]]}
["Tag","Datum","Arbeits-",null,"Pause / Fehlzeit","Bemerkung","Arb-Zeit","SOLL - IST","Schluss um","Sollstd.\n je Tag","Arbeits","WochenSOLL","WochenIST","FUK-FI"]
[null,null,"Beginn","Ende",null,"( Frei, Urlaub, Krankheit, o.ä.)","Täglich","je Woche",{"$f":"MAX(K3:K33)","v":0},null,"Ende"]
[{"$f":"CHOOSE(WEEKDAY(B3),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\")","v":"Mi"},{"$f":"DATEVALUE(CONCATENATE(\"01.\",B42,\".\",B40))","v":"2014-01-01"},null,null,null,null,{"$f":"IF(D3<>0,D3-C3-E3,0)","v":0},{"$f":"IF(G3=0,\"\",IF(L3=M3,0,IF(L3>=M3,L3-M3,M3-L3)))","v":""},{"$f":"IF(B3=\"\",\"\",IFERROR(VLOOKUP(B3,$E$43:$F$58,2,FALSE),\"\"))","v":"Neujahr"},{"$f":"IF(B3=\"\",\"\",IF(N3=\"X\",0,CHOOSE(WEEKDAY(B3),$B$60,$B$48,$B$50,$B$52,$B$54,$B$56,$B$58)))","v":0},{"$f":"IF(AND(C3>0,D3=0,L3>L2,L3=L4),C3+L3-M3+E3,\"\")","v":""},{"$f":"IF(B3=\"\",L2,IF(WEEKDAY(B3)=2,J3,J3+L2))","v":0},{"$f":"IF(B3=\"\",\"\",IF(WEEKDAY(B3)=2,G3,G3+M2))","v":0},{"$f":"IF(B3=\"\",\"\",IF(I3<>\"\",\"X\",IF(F3=\"Frei\",\"X\",IF(F3=\"Urlaub\",\"X\",IF(F3=\"Krankheit\",\"X\",\"\")))))","v":"X"}]
[{"$f":"IF(B4=\"\",\"\",CHOOSE(WEEKDAY(B4),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Do"},{"$f":"IF(B3=\"\",\"\",IF(MONTH(B3+1)=MONTH($B$3),B3+1,\"\"))","v":"2014-01-02"},null,null,null,null,0,{"$f":"IF(G4=0,\"\",IF(L4=M4,0,IF(L4>=M4,L4-M4,M4-L4)))","v":""},{"$f":"IF(B4=\"\",\"\",IFERROR(VLOOKUP(B4,$E$43:$F$58,2,FALSE),\"\"))","v":""},0.3125,"",0.3125,0,""]
["Fr","2014-01-03",null,null,null,null,0,{"$f":"IF(G5=0,\"\",IF(L5=M5,0,IF(L5>=M5,L5-M5,M5-L5)))","v":""},"",0.3125,"",0.625,0,""]
["Sa","2014-01-04",null,null,null,null,0,"","",0,"",0.625,0,""]
["So","2014-01-05",null,null,null,null,0,"","",0,"",0.625,0,""]
["Mo","2014-01-06",null,null,null,null,0,"","Hl. 3 Könige",0,"",0,0,"X"]
["Di","2014-01-07",null,null,null,null,0,"",{"$f":"IF(B9=\"\",\"\",IFERROR(VLOOKUP(B9,$E$43:$F$58,2,FALSE),\"\"))","v":""},0.3125,"",0.3125,0,""]
["Mi","2014-01-08",null,null,null,null,0,"","",0.3125,"",0.625,0,""]
["Do","2014-01-09",null,null,null,null,0,"","",0.3125,"",0.9375,0,""]
["Fr","2014-01-10",null,null,null,null,0,"","",0.3125,"",1.25,0,""]
["Sa","2014-01-11",null,null,null,null,0,"","",0,{"$f":"IF(AND(C13>0,D13=0,L13>L12,L13=L14),C13+L13-M13+E13,\"\")","v":""},1.25,0,""]
["So","2014-01-12",null,null,null,null,0,"","",0,{"$f":"IF(AND(C14>0,D14=0,L14>L13,L14=L15),C14+L14-M14+E14,\"\")","v":""},1.25,0,""]
["Mo","2014-01-13",null,null,null,null,0,"","",0.3125,"",0.3125,0,""]
["Di","2014-01-14",null,null,null,null,0,"","",0.3125,"",0.625,0,""]
["Mi","2014-01-15",null,null,null,null,0,"","",0.3125,"",0.9375,0,""]
["Do","2014-01-16",null,null,null,null,0,"","",0.3125,"",1.25,0,""]
["Fr","2014-01-17",null,null,null,null,0,"","",0.3125,"",1.5625,0,""]
["Sa","2014-01-18",null,null,null,null,0,"","",0,"",1.5625,0,""]
["So","2014-01-19",null,null,null,null,0,"","",0,"",1.5625,0,""]
["Mo","2014-01-20",null,null,null,null,0,"","",0.3125,"",0.3125,0,""]
["Di","2014-01-21",null,null,null,null,0,"","",0.3125,"",0.625,0,""]
["Mi","2014-01-22",null,null,null,null,0,"","",0.3125,"",0.9375,0,""]
["Do","2014-01-23",null,null,null,null,0,"","",0.3125,"",1.25,0,""]
["Fr","2014-01-24",null,null,null,null,0,"","",0.3125,"",1.5625,0,""]
["Sa","2014-01-25",null,null,null,null,0,"","",0,"",1.5625,0,""]
["So","2014-01-26",null,null,null,null,0,"","",0,"",1.5625,0,""]
["Mo","2014-01-27",null,null,null,null,0,"","",0.3125,"",0.3125,0,""]
["Di","2014-01-28",null,null,null,null,0,"","",0.3125,"",0.625,{"$f":"IF(B30=\"\",0,IF(WEEKDAY(B30)=2,G30,G30+M29))","v":0},""]
[{"$f":"IF(B31=\"\",\"\",CHOOSE(WEEKDAY(B31),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Mi"},"2014-01-29",null,null,null,null,0,"","",0.3125,"",0.9375,{"$f":"IF(B31=\"\",0,IF(WEEKDAY(B31)=2,G31,G31+M30))","v":0},""]
[{"$f":"IF(B32=\"\",\"\",CHOOSE(WEEKDAY(B32),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Do"},{"$f":"IF(B31=\"\",\"\",IF(MONTH(B31+1)=MONTH($B$3),B31+1,\"\"))","v":"2014-01-30"},null,null,null,null,{"$f":"IF(D32<>0,D32-C32-E32,0)","v":0},"","",0.3125,"",1.25,{"$f":"IF(B32=\"\",0,IF(WEEKDAY(B32)=2,G32,G32+M31))","v":0},""]
[{"$f":"IF(B33=\"\",\"\",CHOOSE(WEEKDAY(B33),\"So\",\"Mo\",\"Di\",\"Mi\",\"Do\",\"Fr\",\"Sa\"))","v":"Fr"},{"$f":"IF(B32=\"\",\"\",IF(MONTH(B32+1)=MONTH($B$3),B32+1,\"\"))","v":"2014-01-31"},null,null,null,null,{"$f":"IF(D33<>0,D33-C33-E33,0)","v":0},"","",0.3125,"",1.5625,{"$f":"IF(B33=\"\",0,IF(WEEKDAY(B33)=2,G33,G33+M32))","v":0},""]
[null,null,null,null,null,"Monatliche Summen (Std:Min):",{"$f":"SUM(G3:G33)","v":0},{"$f":"IF(J34-G34>=0,J34-G34,G34-J34)","v":6.5625},null,{"$f":"SUM(J3:J33)","v":6.5625},null,{"$f":"L33","v":1.5625}]
[null,null,null,null,null,"Frei"]
[null,null,null,null,null,"Urlaub"]
[null,null,null,null,null,"Krankheit"]
[]
[]
[null,2014]
[null,null,null,null,null,"Feiertage:","Datum",null,"Jahr",{"$f":"B40","v":2014}]
[null,1,null,null,null,null,null,null,"Gausssche Osterformel",{"$f":"MOD(J41,19)","v":0}]
[null,null,null,null,{"$f":"DATEVALUE(CONCATENATE(\"01.01.\",$B$40))","v":41640},"Neujahr",{"$f":"E43","v":"2014-01-01"},null,null,{"$f":"MOD(J41,4)","v":2}]
[null,37.5,null,null,{"$f":"DATEVALUE(CONCATENATE(\"06.01.\",$B$40))","v":41645},"Hl. 3 Könige","2014-01-06",null,null,{"$f":"MOD(J41,7)","v":5}]
[null,null,null,null,{"$f":"DATEVALUE(J$58)-2","v":41747},"Karfreitag","2014-04-18",null,null,{"$f":"TRUNC((8*(TRUNC(J41/100))+13)/25)-2","v":4}]
[null,5,null,null,{"$f":"DATEVALUE(J$58)","v":41749},"Ostersonntag","2014-04-20",null,null,{"$f":"TRUNC(J41/100)-TRUNC(J41/400)-2","v":13}]
[null,null,null,null,{"$f":"DATEVALUE(J$58)+1","v":41750},"Ostermontag","2014-04-21",null,null,{"$f":"MOD(15+J46-J45,30)","v":24}]
[null,0.3125,null,null,{"$f":"DATEVALUE(CONCATENATE(\"01.05.\",$B$40))","v":41760},"Tag der Arbeit","2014-05-01",null,null,{"$f":"MOD(6+J46,7)","v":5}]
[null,null,null,null,{"$f":"DATEVALUE(J$58)+39","v":41788},"Ch. Himmelfahrt","2014-05-29",null,null,{"$f":"MOD(J47+19*J42,30)","v":24}]
[null,0.3125,null,null,{"$f":"DATEVALUE(J$58)+49","v":41798},"Pfingstsonntag","2014-06-08",null,null,{"$f":"IF(J49=29,28,IF(AND(J49=28,J42>=11),27,IF(AND(J49<28,J49>29),,J49)))","v":24}]
[null,null,null,null,{"$f":"DATEVALUE(J$58)+50","v":41799},"Pfingstmontag","2014-06-09",null,null,{"$f":"MOD(2*J43+4*J44+6*J50+J48,7)","v":5}]
[null,0.3125,null,null,{"$f":"DATEVALUE(J$58)+60","v":41809},"Fronleichnam","2014-06-19",null,null,{"$f":"J50+J51+1","v":30}]
[null,null,null,null,{"$f":"DATEVALUE(CONCATENATE(\"15.08.\",$B$40))","v":41866},"Maria Himmelfahrt","2014-08-15",null,null,{"$f":"DATEVALUE(CONCATENATE(\"21.märz\",J41))","v":41719}]
[null,0.3125,null,null,{"$f":"DATEVALUE(CONCATENATE(\"03.10.\",$B$40))","v":41915},"Tag d. DT. Einheit","2014-10-03",null,"Ostersonntag",{"$f":"J52+J53","v":"2014-04-20"}]
[null,null,null,null,{"$f":"DATEVALUE(CONCATENATE(\"01.11.\",$B$40))","v":41944},"Allerheiligen","2014-11-01",null,"Tag",{"$f":"DAY(J54)","v":20}]
[null,0.3125,null,null,{"$f":"DATEVALUE(CONCATENATE(\"24.12.\",$B$40))","v":41997},"Hl. Abend","2014-12-24",null,"Monat",{"$f":"MONTH(J54)","v":4}]
[null,null,null,null,{"$f":"DATEVALUE(CONCATENATE(\"25.12.\",$B$40))","v":41998},"1. Weihnachtsfeiertag","2014-12-25",null,"Jahr",{"$f":"YEAR(J54)","v":2014}]
[null,0,null,null,{"$f":"DATEVALUE(CONCATENATE(\"26.12.\",$B$40))","v":41999},"2. Weihnachtsfeiertag","2014-12-26",null,null,{"$f":"CONCATENATE(J55,\".\",J56,\".\",J57)","v":"20.4.2014"}]
[]
[null,0]