{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Projektzeitachse","calcs"],"not_rendered":{"charts":1,"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"Projektzeitachse","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"merged":[[0,2,0,6],[1,2,1,6]]}
[null,null,"PROJEKTZEITACHSE"]
[null,null,"In dieser Zelle befindet sich ein Diagramm mit Projektaktivitäten mit einer scrollbaren Zeitachse."]
[null,null,"STARTDATUM EINGEBEN: ",{"$f":"TODAY()","v":"2019-08-20"}]
[null,"ID","AKTIVITÄT","START","ENDE","ANMERKUNGEN"]
[null,{"$f":"ROW(B5)-calcs!$D$5","v":-7},"Projektanfang",{"$f":"$D$3+3","v":"2019-08-23"}]
[null,{"$f":"ROW(B6)-calcs!$D$5","v":-6},"Meilenstein 1",{"$f":"D5+10","v":"2019-09-02"},{"$f":"Aktivitäten[[#This Row],[START]]+3","v":"2019-09-05"}]
[null,{"$f":"ROW(B7)-calcs!$D$5","v":-5},"Meilenstein 2",{"$f":"D6+1","v":"2019-09-03"},{"$f":"Aktivitäten[[#This Row],[START]]+3","v":"2019-09-06"}]
[null,{"$f":"ROW(B8)-calcs!$D$5","v":-4},"Meilenstein 3",{"$f":"D7+5","v":"2019-09-08"}]
[null,{"$f":"ROW(B9)-calcs!$D$5","v":-3},"Meilenstein 4",{"$f":"D8+10","v":"2019-09-18"},{"$f":"Aktivitäten[[#This Row],[START]]+2","v":"2019-09-20"}]
[null,{"$f":"ROW(B10)-calcs!$D$5","v":-2},"Meilenstein 5","2019-09-28",{"$f":"Aktivitäten[[#This Row],[START]]+2","v":"2019-09-30"}]
[null,{"$f":"ROW(B11)-calcs!$D$5","v":-1},"Meilenstein 6",{"$f":"D10+10","v":"2019-10-08"},{"$f":"Aktivitäten[[#This Row],[START]]+2","v":"2019-10-10"}]
[null,{"$f":"ROW(B12)-calcs!$D$5","v":0},"Meilenstein 7","2019-10-18"]
[null,{"$f":"ROW(B13)-calcs!$D$5","v":1},"Meilenstein 8",{"$f":"D12+10","v":"2019-10-28"},{"$f":"Aktivitäten[[#This Row],[START]]+2","v":"2019-10-30"}]
[null,{"$f":"ROW(B14)-calcs!$D$5","v":2},"Meilenstein 9","2019-11-07",{"$f":"Aktivitäten[[#This Row],[START]]+2","v":"2019-11-09"}]
[null,{"$f":"ROW(B15)-calcs!$D$5","v":3},"Meilenstein 10","2019-11-17",{"$f":"Aktivitäten[[#This Row],[START]]+2","v":"2019-11-19"}]
[null,{"$f":"ROW(B16)-calcs!$D$5","v":4},"Projektende",{"$f":"D15+10","v":"2019-11-27"}]

{"sheet":"calcs","index":1,"n_rows":72,"n_cols":35,"rows_kept":72,"hidden":true}
["*** Dieses Blatt sollte nicht angezeigt werden ***"]
[]
[null,null,"Heute:",{"$f":"TODAY()","v":"2019-08-20"}]
[{"$nulls":3},5]
[null,null,"Anz. von Zeilen",{"$f":"ROWS(Aktivitäten[])","v":12}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[null,null,"Aktivitäten im Fenster:",{"$f":"SUMPRODUCT( ((Aktivitäten[START]>=StartDateWindow)+(Aktivitäten[ENDE]>=StartDateWindow)>0)*(Aktivitäten[START]<=(StartDateWindow+WindowDays-1)) )","v":5},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":3},9,{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":3},{"$f":"D10-MIN(D10,D9)","v":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"NA()","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"INDEX(Aktivitäten[ID],MATCH(1, ((Aktivitäten[START]>=StartDateWindow)+(Aktivitäten[ENDE]>=StartDateWindow)>0)*(Aktivitäten[START]<=(StartDateWindow+WindowDays-1)), 0))","v":-7},{"$f":"OFFSET(E15,-$D$11,)","v":{"$error":"#N/A"}}]
[{"$nulls":4},{"$f":"INDEX(Aktivitäten[ID],MATCH(1, (Aktivitäten[ID]>E15)*((Aktivitäten[START]>=StartDateWindow)+(Aktivitäten[ENDE]>=StartDateWindow)>0)*(Aktivitäten[START]<=(StartDateWindow+WindowDays-1)), 0))","v":-6},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(Aktivitäten[ID],MATCH(1, (Aktivitäten[ID]>E16)*((Aktivitäten[START]>=StartDateWindow)+(Aktivitäten[ENDE]>=StartDateWindow)>0)*(Aktivitäten[START]<=(StartDateWindow+WindowDays-1)), 0))","v":-5},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(Aktivitäten[ID],MATCH(1, (Aktivitäten[ID]>E17)*((Aktivitäten[START]>=StartDateWindow)+(Aktivitäten[ENDE]>=StartDateWindow)>0)*(Aktivitäten[START]<=(StartDateWindow+WindowDays-1)), 0))","v":-4},{"$error":"#N/A"}]
[{"$nulls":4},{"$f":"INDEX(Aktivitäten[ID],MATCH(1, (Aktivitäten[ID]>E18)*((Aktivitäten[START]>=StartDateWindow)+(Aktivitäten[ENDE]>=StartDateWindow)>0)*(Aktivitäten[START]<=(StartDateWindow+WindowDays-1)), 0))","v":-3},-7]
[{"$nulls":4},{"$f":"INDEX(Aktivitäten[ID],MATCH(1, (Aktivitäten[ID]>E19)*((Aktivitäten[START]>=StartDateWindow)+(Aktivitäten[ENDE]>=StartDateWindow)>0)*(Aktivitäten[START]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-6]
[{"$nulls":4},{"$f":"INDEX(Aktivitäten[ID],MATCH(1, (Aktivitäten[ID]>E20)*((Aktivitäten[START]>=StartDateWindow)+(Aktivitäten[ENDE]>=StartDateWindow)>0)*(Aktivitäten[START]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-5]
[{"$nulls":4},{"$f":"INDEX(Aktivitäten[ID],MATCH(1, (Aktivitäten[ID]>E21)*((Aktivitäten[START]>=StartDateWindow)+(Aktivitäten[ENDE]>=StartDateWindow)>0)*(Aktivitäten[START]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-4]
[{"$nulls":4},{"$f":"INDEX(Aktivitäten[ID],MATCH(1, (Aktivitäten[ID]>E22)*((Aktivitäten[START]>=StartDateWindow)+(Aktivitäten[ENDE]>=StartDateWindow)>0)*(Aktivitäten[START]<=(StartDateWindow+WindowDays-1)), 0))","v":{"$error":"#N/A"}},-3]
[]
[null,null,"Fensteranfang berechnen",{"$f":"StartDate+WindowOffset","v":"2019-08-20"}]
[null,null,"Offset",0]
[]
[null,null,"Start",{"$f":"Projektzeitachse!D3","v":"2019-08-20"}]
[null,null,"Fenster",30]
[]
["Position","Datenreihe","Aktivitäts-ID","Aktivität",{"$f":"StartDateWindow","v":"2019-08-20"},{"$f":"E31+1","v":"2019-08-21"},"2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18","2019-09-19"]
[11.3,1,{"$f":"F15","v":{"$error":"#N/A"}},{"$f":"INDEX(Aktivitäten[AKTIVITÄT],MATCH($C32,Aktivitäten[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[{"$f":"A32-1","v":10.3},2,{"$error":"#N/A"},{"$f":"INDEX(Aktivitäten[AKTIVITÄT],MATCH($C33,Aktivitäten[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[{"$f":"A33-1","v":9.3},3,{"$error":"#N/A"},{"$f":"INDEX(Aktivitäten[AKTIVITÄT],MATCH($C34,Aktivitäten[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[8.3,4,{"$error":"#N/A"},{"$f":"INDEX(Aktivitäten[AKTIVITÄT],MATCH($C35,Aktivitäten[ID],0))","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[7.300000000000001,5,-7,{"$f":"INDEX(Aktivitäten[AKTIVITÄT],MATCH($C36,Aktivitäten[ID],0))","v":"Projektanfang"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":7.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[6.300000000000001,6,-6,{"$f":"INDEX(Aktivitäten[AKTIVITÄT],MATCH($C37,Aktivitäten[ID],0))","v":"Meilenstein 1"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":6.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[5.300000000000001,7,-5,{"$f":"INDEX(Aktivitäten[AKTIVITÄT],MATCH($C38,Aktivitäten[ID],0))","v":"Meilenstein 2"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":5.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[4.300000000000001,8,-4,{"$f":"INDEX(Aktivitäten[AKTIVITÄT],MATCH($C39,Aktivitäten[ID],0))","v":"Meilenstein 3"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":4.300000000000001},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}}]
[3.3000000000000007,9,-3,{"$f":"INDEX(Aktivitäten[AKTIVITÄT],MATCH($C40,Aktivitäten[ID],0))","v":"Meilenstein 4"},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":{"$error":"#N/A"}},{"$f":"GridCalc","v":3.3000000000000007},{"$f":"GridCalc","v":3.3000000000000007}]
[]
[]
[{"$nulls":4},{"$f":"E31","v":"2019-08-20"},{"$f":"F31","v":"2019-08-21"},"2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18"]
[null,null,{"$f":"C32","v":{"$error":"#N/A"}},{"$f":"UPPER(INDEX(Aktivitäten[AKTIVITÄT],MATCH($C44,Aktivitäten[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F32),E32,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$f":"C33","v":{"$error":"#N/A"}},{"$f":"UPPER(INDEX(Aktivitäten[AKTIVITÄT],MATCH($C45,Aktivitäten[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F33),E33,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"},{"$f":"UPPER(INDEX(Aktivitäten[AKTIVITÄT],MATCH($C46,Aktivitäten[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F34),E34,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,{"$error":"#N/A"},{"$f":"UPPER(INDEX(Aktivitäten[AKTIVITÄT],MATCH($C47,Aktivitäten[ID],0)))","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR(F35),E35,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-7,{"$f":"UPPER(INDEX(Aktivitäten[AKTIVITÄT],MATCH($C48,Aktivitäten[ID],0)))","v":"PROJEKTANFANG"},{"$f":"IF(ISERROR(F36),E36,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},7.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-6,{"$f":"UPPER(INDEX(Aktivitäten[AKTIVITÄT],MATCH($C49,Aktivitäten[ID],0)))","v":"MEILENSTEIN 1"},{"$f":"IF(ISERROR(F37),E37,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},6.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-5,{"$f":"UPPER(INDEX(Aktivitäten[AKTIVITÄT],MATCH($C50,Aktivitäten[ID],0)))","v":"MEILENSTEIN 2"},{"$f":"IF(ISERROR(F38),E38,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},5.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-4,{"$f":"UPPER(INDEX(Aktivitäten[AKTIVITÄT],MATCH($C51,Aktivitäten[ID],0)))","v":"MEILENSTEIN 3"},{"$f":"IF(ISERROR(F39),E39,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},4.300000000000001,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,-3,{"$f":"UPPER(INDEX(Aktivitäten[AKTIVITÄT],MATCH($C52,Aktivitäten[ID],0)))","v":"MEILENSTEIN 4"},{"$f":"IF(ISERROR(F40),E40,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[{"$nulls":4},{"$f":"E31","v":"2019-08-20"},{"$f":"F31","v":"2019-08-21"},"2019-08-22","2019-08-23","2019-08-24","2019-08-25","2019-08-26","2019-08-27","2019-08-28","2019-08-29","2019-08-30","2019-08-31","2019-09-01","2019-09-02","2019-09-03","2019-09-04","2019-09-05","2019-09-06","2019-09-07","2019-09-08","2019-09-09","2019-09-10","2019-09-11","2019-09-12","2019-09-13","2019-09-14","2019-09-15","2019-09-16","2019-09-17","2019-09-18"]
[{"$nulls":3},"Aktueller Tag",{"$f":"IF(E55=$D$3,5,NA())","v":5},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":3},{"$f":"DATE(YEAR(MIN(E55:AH55)),MONTH(MIN(E55:AH55)),1)","v":"2019-08-01"},{"$f":"IF(MEDIAN($D58,E$55,EOMONTH($D58,0))=E$55,0.5,NA())","v":0.5},{"$f":"IF(MEDIAN($D58,F$55,EOMONTH($D58,0))=F$55,0.5,NA())","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":3},{"$f":"TEXT(D58,\"MMM JJJJ\") & \" - Oberes Band\"","v":"Aug JJJJ - Oberes Band"},{"$f":"E58+12.5","v":13},{"$f":"F58+12.5","v":13},13,13,13,13,13,13,13,13,13,13,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[{"$nulls":3},{"$f":"EOMONTH(D58,0)+1","v":"2019-09-01"},{"$f":"IF(MEDIAN($D61,E$55,EOMONTH($D61,0))=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(MEDIAN($D61,F$55,EOMONTH($D61,0))=F$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[{"$nulls":3},{"$f":"TEXT(D61,\"MMM JJJJ\") & \" - Oberes Band\"","v":"Sep JJJJ - Oberes Band"},{"$f":"E61+12.5","v":{"$error":"#N/A"}},{"$f":"F61+12.5","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13,13]
[]
[]
[{"$nulls":3},{"$f":"D58+1","v":"2019-08-02"},{"$f":"IF(MEDIAN($D65,E$55)=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$f":"IF(MEDIAN($D65,F$55)=F$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[{"$nulls":3},{"$f":"D61+1","v":"2019-09-02"},{"$f":"IF(MEDIAN($D66,E$55)=E$55,0.5,NA())","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0.5,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[{"$nulls":4},2.3,{"$f":"E69","v":2.3},{"$f":"F69","v":2.3},2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3,2.3]
[{"$nulls":3},3,{"$f":"LEFT(UPPER(TEXT(E55,\"TTTT\")),$D70)","v":"TTT"},"TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT","TTT"]
[{"$nulls":4},1.3,{"$f":"E71","v":1.3},1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3,1.3]
[{"$nulls":4},{"$f":"TEXT(E55,\"TT\")","v":"TT"},"TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT","TT"]