{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Aufgabenliste Projekt 1","Einstellungen und Berechnungen"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Aufgabenliste Projekt 1","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[7,1,7,2]]}
[{"$nulls":7}," "]
[{"$nulls":7}," "]
[null,"Projektaufgabenliste"]
[]
[null,"Zu erledigen von:",null,null,"Termin:",null,"Aktivitäten hervorheben"]
[null,"Elisabeth Krenthaller",null,null,{"$f":"TODAY()+95","v":"2012-12-03"},null,"     Diese Woche [18 Jun - 24 Jun]"]
[]
[null,"Projekt 1"]
[null,"Aktivität","Fällig am","Budget","% erledigt","Fortschritt","Notizen"," "]
[null,"Planung",{"$f":"TODAY()-90","v":"2012-06-01"},{"v":476,"d":"476.00 €"},{"v":0.25,"d":"25%"},{"$f":"tblAufgabenliste[[#This Row],[% erledigt]]","v":{"v":0.25,"d":"25%"}}]
[null,"Vorbereitung",{"$f":"TODAY()-2","v":"2012-08-28"},{"v":301,"d":"301.00 €"},{"v":0.1,"d":"10%"},{"$f":"tblAufgabenliste[[#This Row],[% erledigt]]","v":{"v":0.1,"d":"10%"}}]
[null,"Vorgang A",{"$f":"TODAY()-7","v":"2012-08-23"},{"v":429,"d":"429.00 €"},{"v":0,"d":"0%"},{"$f":"tblAufgabenliste[[#This Row],[% erledigt]]","v":{"v":0,"d":"0%"}}]
[null,"Vorgang B",{"$f":"TODAY()+20","v":"2012-09-19"},{"v":332,"d":"332.00 €"},{"v":0.7,"d":"70%"},{"$f":"tblAufgabenliste[[#This Row],[% erledigt]]","v":{"v":0.7,"d":"70%"}}]
[null,"Vorgang C",{"$f":"TODAY()+40","v":"2012-10-09"},{"v":471,"d":"471.00 €"},{"v":0.1,"d":"10%"},{"$f":"tblAufgabenliste[[#This Row],[% erledigt]]","v":{"v":0.1,"d":"10%"}}]
[null,"Vorgang D",{"$f":"TODAY()+45","v":"2012-10-14"},{"v":418,"d":"418.00 €"},{"v":1,"d":"100%"},{"$f":"tblAufgabenliste[[#This Row],[% erledigt]]","v":{"v":1,"d":"100%"}}]
[null,"Schreibarbeiten",{"$f":"TODAY()+55","v":"2012-10-24"},{"v":150,"d":"150.00 €"},{"v":0,"d":"0%"},{"$f":"tblAufgabenliste[[#This Row],[% erledigt]]","v":{"v":0,"d":"0%"}},"Start nach Abschluss von Vorgang B"]
[null,"Übergabe",{"$f":"TODAY()+70","v":"2012-11-08"},{"v":330,"d":"330.00 €"},{"v":0.25,"d":"25%"},{"$f":"tblAufgabenliste[[#This Row],[% erledigt]]","v":{"v":0.25,"d":"25%"}}]
[null,"Nachverfolgung",{"$f":"TODAY()+90","v":"2012-11-28"},{"v":353,"d":"353.00 €"},{"v":0.5,"d":"50%"},{"$f":"tblAufgabenliste[[#This Row],[% erledigt]]","v":{"v":0.5,"d":"50%"}}]

{"sheet":"Einstellungen und Berechnungen","index":1,"n_rows":19,"n_cols":6,"rows_kept":19,"merged":[[3,1,3,4]]}
[]
[{"$nulls":5}," "]
[null,"Hervorhebungseinstellungen"]
[null,"In der nachstehenden Tabelle werden die Einstellungen und Berechnungen für die Dropdownliste 'Aktivitäten hervorheben' gespeichert.\nÄnderungen können zu Fehlern oder Funktionalitätsverlust führen."]
[null,"Keine Hervorhebung",null,null,{"$f":"B5","v":"Keine Hervorhebung"}]
[null,"Intervall:","Start:","Ende:","Fällig:"]
[null,"     Diese Woche",{"$f":"TODAY()-WEEKDAY(TODAY(),2)+1","v":"2012-08-27"},{"$f":"C7+6","v":"2012-09-02"},{"$f":"B7&\" [\"&TEXT(C7,\"T MMM\")&\" - \"&TEXT(D7,\"T MMM\")&\"]\"","v":"     Diese Woche [27 Aug - 2 Sep]"}]
[null,"     Dieser Monat",{"$f":"EOMONTH(TODAY(),-1)+1","v":"2012-08-01"},{"$f":"EDATE(C8,1)-1","v":"2012-08-31"},{"$f":"B8&\" [\"&TEXT(C8,\"T\")&\" - \"&TEXT(D8,\"T, MMM\")&\"]\"","v":"     Dieser Monat [1 - 31, Aug]"}]
[null,"     Dieses Quartal",{"$f":"DATE(YEAR(TODAY()),INT(MONTH(TODAY())/3)+1,1)","v":"2012-03-01"},{"$f":"EDATE(C9,4)-1","v":"2012-06-30"},{"$f":"B9&\" [\"&TEXT(C9,\"T MMM\")&\" - \"&TEXT(D9,\"T MMM\")&\"]\"","v":"     Dieses Quartal [1 Mrz - 30 Jun]"}]
[null,"     Dieses Jahr",{"$f":"DATE(YEAR(TODAY()),1,1)","v":"2012-01-01"},{"$f":"EDATE(C10,12)-1","v":"2012-12-31"},{"$f":"B10&\" [\"&TEXT(C10,\"JJJJ\")&\"]\"","v":"     Dieses Jahr [2012]"}]
[null,"Intervall:",null,null,{"$f":"B11","v":"Intervall:"}]
[null,"     Letzte Woche",{"$f":"C7-7","v":"2012-08-20"},{"$f":"C12+6","v":"2012-08-26"},{"$f":"B12&\" [\"&TEXT(C12,\"T MMM\")&\" - \"&TEXT(D12,\"T MMM\")&\"]\"","v":"     Letzte Woche [20 Aug - 26 Aug]"}]
[null,"     Letzter Monat",{"$f":"EDATE(C8,-1)","v":"2012-07-01"},{"$f":"EDATE(C13,1)-1","v":"2012-07-31"},{"$f":"B13&\" [\"&TEXT(C13,\"T\")&\" - \"&TEXT(D13,\"T, MMM\")&\"]\"","v":"     Letzter Monat [1 - 31, Jul]"}]
[null,"     Letztes Quartal",{"$f":"EDATE(C9,-3)","v":"2011-12-01"},{"$f":"EDATE(C14,3)-1","v":"2012-02-29"},{"$f":"B14&\" [\"&TEXT(C14,\"T MMM\")&\" - \"&TEXT(D14,\"T MMM\")&\"]\"","v":"     Letztes Quartal [1 Dez - 29 Feb]"}]
[null,"     Letztes Jahr",{"$f":"EDATE(C10,-12)","v":"2011-01-01"},{"$f":"EDATE(C15,12)-1","v":"2011-12-31"},{"$f":"B15","v":"     Letztes Jahr"}]
[]
[null,"Ausgewählte Hervorhebung:",{"$f":"IFERROR(MATCH(AktivitätenHervorheben,lstAufgabenlisteHervorhebungen,0),\"\")","v":""},{"$f":"AktivitätenHervorheben","v":"     Diese Woche [18 Jun - 24 Jun]"},{"$f":"ISNUMBER(INDEX($C$6:$C$15,C17))","v":false}]
[null,"Hervorhebung Start",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($C$6:$C$15,$C$17),\"\")),\"\")","v":""}]
[null,"Hervorhebung Ende",{"$f":"IFERROR(IF(C17=1,\"\",IF(E17,INDEX($D$6:$D$15,$C$17),\"\")),\"\")","v":""}]