{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Projektportfolio Dashboard","Portfolio Daten"],"not_rendered":{"charts":8,"images":1,"macros":0,"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":"Projektportfolio Dashboard","index":0,"n_rows":146,"n_cols":8,"rows_kept":146,"cut":false,"hidden":false,"merged":[[142,7,142,9],[141,0,141,1],[138,7,138,9],[139,7,139,9],[140,7,140,9],[141,7,141,9],[137,7,137,9],[138,0,138,1],[137,0,137,1],[139,0,139,1],[140,0,140,1],[145,0,150,9],[142,0,142,1],[131,0,131,1],[132,0,132,1],[133,0,133,1],[134,0,134,1],[135,0,135,1],[136,0,136,1],[143,7,143,9],[143,0,143,1],[131,7,131,9],[132,7,132,9],[133,7,133,9],[134,7,134,9],[135,7,135,9],[136,7,136,9],[130,0,130,1],[0,0,0,8],[1,0,1,9],[41,0,41,9],[73,0,73,9],[100,0,100,9],[127,0,127,9],[129,0,129,1],[129,7,129,9],[130,7,130,9]]}
["Projekt PORTFOLIO DASHBOARD"]
["ZEITPLANUNG PROJEKTBEENDIGUNG & RESSOURCEN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PROJEKTFINANZEN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["RISIKOANALYSE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["OFFENE & AUSSTEHENDE AKTIVITÄTEN"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Projekt  BERICHT"]
[]
["Projekt NAME",null,"TERMIN","BUDGET","RESSOURCEN","RISIKEN","PROBLEME","KOMMENTARE"]
["Projekt A"]
["Projekt B"]
["Projekt C"]
["Projekt D"]
["Projekt E"]
["Projekt F"]
["Projekt G"]
["Projekt H"]
["Projekt J"]
["Projekt K"]
["Projekt L"]
["Projekt M"]
["Projekt N"]
["Projekt P"]
[]
["Mehr über Dashboards in Smartsheet"]

{"sheet":"Portfolio Daten","index":1,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,14,2,14],[0,0,0,9],[1,6,1,8],[1,0,2,0],[1,1,1,4],[1,5,2,5],[1,9,1,11]]}
["PROJEKTPORTFOLIO DATEN"]
["PROJEKTNAME","ZEITPLANUNG",null,null,null,"ANZAHL MITARBEITER","BUDGET",null,null,"RISIKO",null,null,"OFFEN",null,"AUSSTEHENDE AKTIVITÄTEN"]
[null,"KALENDER-MONAT","START","ENDE","ANZAHL (TAGE)",null,"GEPLANT","IST","REST","HOCH","MITTEL","NIEDRIG","PROBLEME","REVISIONEN"]
["Projekt A","2016-05-01","2016-05-05","2016-07-01",{"$f":"D4-C4","v":"1900-02-26"},10,1000000,880000,{"$f":"(G4-H4)","v":120000},1,0,4,2,0,4]
["Projekt B","2016-06-01","2016-05-10","2016-08-10",{"$f":"D5-C5","v":"1900-04-01"},5,900000,920000,{"$f":"(G5-H5)","v":-20000},2,3,5,1,2,3]
["Projekt C","2016-07-01","2016-06-10","2017-03-01","1900-09-20",10,860000,850000,10000,3,4,3,2,1,2]
["Projekt D","2016-08-01","2016-06-22","2016-08-04","1900-02-12",5,1000000,998050,1950,5,8,1,1,0,0]
["Projekt E","2016-09-01","2016-07-14","2016-11-01","1900-04-19",10,294000,280000,14000,8,6,4,0,3,1]
["Projekt F","2016-10-01","2016-07-14","2017-01-20","1900-07-08",5,123400,125000,-1600,5,0,0,2,0,2]
["Projekt G","2016-11-01","2016-08-01","2016-10-01","1900-03-01",10,250500,246000,4500,6,4,0,1,2,3]
["Projekt H","2016-12-01","2016-08-14","2016-08-30","1900-01-16",5,127200,126000,1200,7,3,3,0,1,4]
["Projekt J","2017-01-01","2016-09-01","2016-12-10","1900-04-09",10,80000,79900,100,0,2,4,1,3,2]
["Projekt K","2017-02-01","2016-10-01","2016-11-15","1900-02-14",5,77000,77000,0,4,4,5,2,0,0]
["Projekt L","2017-03-01","2016-10-01","2016-12-01","1900-03-01",10,65000,65000,0,3,6,4,3,2,0]
["Projekt M","2017-04-01","2016-11-01","2016-12-01","1900-01-30",5,550000,551000,-1000,2,3,6,0,1,1]
["Projekt N","2017-05-01","2016-11-10","2016-12-10","1900-01-30",10,45000,42000,3000,1,1,7,1,0,2]
["Projekt P","2017-06-01","2016-12-01","2017-02-10","1900-03-11",5,32500,33000,-500,5,0,2,2,1,3]
[null,null,null,null,null,null,{"$f":"SUM(G4:G17)","v":5404600},5272950,{"$f":"SUM(I4:I17)","v":131650},52,44,48,18,16,27]