{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Pendenzenliste","Admin"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"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":"Pendenzenliste","index":0,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Team-Pendenzenliste",null,null,null,null,null,null,null,"Email CC:"]
[]
[]
["Nr.","Thema","Erfasst am","Erfasst von","Anfrage von","Fällig am","Priorität","Pendenz","Schritte unternommen","Warten auf Antwort","Status","Erledigt am","Dauer (Tage)"]
[1,"FC","2014-01-08",null,"T.M.",{"$f":"TODAY()+31","v":"2014-10-07"},"A","Beispiel Pendenz 1: Rechnungen kontieren","Sämtliche Rechnungen gesammelt und kontiert. An K.F. gegeben für Visum.","K.F.",{"$f":"IF(AND(Tabelle2[[#This Row],[Erfasst am]]>TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"not started\",IF(AND(Tabelle2[[#This Row],[Erledigt am]]<=TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"open\",\"done\"))","v":"open"},null,{"$f":"IF(AND(L5=\"\",Tabelle2[[#This Row],[Fällig am]]=\"\"),\"n/a\",IF(Tabelle2[[#This Row],[Erledigt am]]=\"\",Tabelle2[[#This Row],[Fällig am]]-Tabelle2[[#This Row],[Erfasst am]],Tabelle2[[#This Row],[Erledigt am]]-Tabelle2[[#This Row],[Erfasst am]]))","v":272}]
[2,"Sales","2014-01-08",null,null,"2014-10-07",1,null,null,null,{"$f":"IF(AND(Tabelle2[[#This Row],[Erfasst am]]>TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"not started\",IF(AND(Tabelle2[[#This Row],[Erledigt am]]<=TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"open\",\"done\"))","v":"open"},null,{"$f":"IF(AND(L6=\"\",Tabelle2[[#This Row],[Fällig am]]=\"\"),\"n/a\",IF(Tabelle2[[#This Row],[Erledigt am]]=\"\",Tabelle2[[#This Row],[Fällig am]]-Tabelle2[[#This Row],[Erfasst am]],Tabelle2[[#This Row],[Erledigt am]]-Tabelle2[[#This Row],[Erfasst am]]))","v":272}]
[3,"IT","2014-01-08",null,null,"2014-10-07",2,null,null,null,{"$f":"IF(AND(Tabelle2[[#This Row],[Erfasst am]]>TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"not started\",IF(AND(Tabelle2[[#This Row],[Erledigt am]]<=TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"open\",\"done\"))","v":"open"},null,{"$f":"IF(AND(L7=\"\",Tabelle2[[#This Row],[Fällig am]]=\"\"),\"n/a\",IF(Tabelle2[[#This Row],[Erledigt am]]=\"\",Tabelle2[[#This Row],[Fällig am]]-Tabelle2[[#This Row],[Erfasst am]],Tabelle2[[#This Row],[Erledigt am]]-Tabelle2[[#This Row],[Erfasst am]]))","v":272}]
[4,"HR","2014-01-08",null,null,"2014-10-07",3,null,null,null,{"$f":"IF(AND(Tabelle2[[#This Row],[Erfasst am]]>TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"not started\",IF(AND(Tabelle2[[#This Row],[Erledigt am]]<=TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"open\",\"done\"))","v":"open"},null,{"$f":"IF(AND(L8=\"\",Tabelle2[[#This Row],[Fällig am]]=\"\"),\"n/a\",IF(Tabelle2[[#This Row],[Erledigt am]]=\"\",Tabelle2[[#This Row],[Fällig am]]-Tabelle2[[#This Row],[Erfasst am]],Tabelle2[[#This Row],[Erledigt am]]-Tabelle2[[#This Row],[Erfasst am]]))","v":272}]
[5,"Excel","2014-01-08","Rohr, Lukas (ExcelNova)",null,"2014-10-07",4,null,null,null,{"$f":"IF(AND(Tabelle2[[#This Row],[Erfasst am]]>TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"not started\",IF(AND(Tabelle2[[#This Row],[Erledigt am]]<=TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"open\",\"done\"))","v":"open"},null,{"$f":"IF(AND(L9=\"\",Tabelle2[[#This Row],[Fällig am]]=\"\"),\"n/a\",IF(Tabelle2[[#This Row],[Erledigt am]]=\"\",Tabelle2[[#This Row],[Fällig am]]-Tabelle2[[#This Row],[Erfasst am]],Tabelle2[[#This Row],[Erledigt am]]-Tabelle2[[#This Row],[Erfasst am]]))","v":272}]
[6,"Excel","2014-01-08","Rohr, Lukas (ExcelNova)",null,"2014-10-07",null,null,null,null,{"$f":"IF(AND(Tabelle2[[#This Row],[Erfasst am]]>TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"not started\",IF(AND(Tabelle2[[#This Row],[Erledigt am]]<=TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"open\",\"done\"))","v":"open"},null,{"$f":"IF(AND(L10=\"\",Tabelle2[[#This Row],[Fällig am]]=\"\"),\"n/a\",IF(Tabelle2[[#This Row],[Erledigt am]]=\"\",Tabelle2[[#This Row],[Fällig am]]-Tabelle2[[#This Row],[Erfasst am]],Tabelle2[[#This Row],[Erledigt am]]-Tabelle2[[#This Row],[Erfasst am]]))","v":272}]
[7,null,"2014-01-08","Rohr, Lukas (Toyota AG)",null,"2014-10-07",null,null,null,null,{"$f":"IF(AND(Tabelle2[[#This Row],[Erfasst am]]>TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"not started\",IF(AND(Tabelle2[[#This Row],[Erledigt am]]<=TODAY(),Tabelle2[[#This Row],[Erledigt am]]=\"\"),\"open\",\"done\"))","v":"open"},null,{"$f":"IF(AND(L11=\"\",Tabelle2[[#This Row],[Fällig am]]=\"\"),\"n/a\",IF(Tabelle2[[#This Row],[Erledigt am]]=\"\",Tabelle2[[#This Row],[Fällig am]]-Tabelle2[[#This Row],[Erfasst am]],Tabelle2[[#This Row],[Erledigt am]]-Tabelle2[[#This Row],[Erfasst am]]))","v":272}]

{"sheet":"Admin","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["LastUpdate",{"$f":"NOW()","v":"2014-09-06T21:06:04.370"}]
[]
["Status","Priority"]
["Open","Low"]
["On Hold","Medium"]
["Done","High"]