{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover","Entwicklung","Fortschrittsbericht"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":2,"defined_names":5,"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",11]
[null,"Thema","Operatives Projekt-Controlling"]
[]
[null,"Inhalt","Projekt-Tracking"]
[]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2019-01-01"]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Entwicklung","index":1,"n_rows":9,"n_cols":43,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,12,0,15],[0,37,0,38],[0,39,0,40],[0,41,0,42]]}
["Projekt spezifisch",null,"Info","Template","Review \nTemplate","Einstufung","Bereich","FSM \nBeurteilung","Ziel-\nMeilenstein","an \nKunden","Verantwortl.\nRollenname","Plan","Aufwand Schätzung [h]",null,null,null,"Kommentar\nzum Aufwand","Zeitplan","Reife","Projektspezifischer\nDokumentname","Dokument\nReife","Dokument\nStatus","Reviewer","Review\nReife","Review\nStatus","Verwendet\nAnstrengung [h]",null,null,null,null,null,null,null,null,null,null,"Kommentare","Kommentar\nSIM / SOM",null,"Kommentar\nReviewer",null,"Kommentar\nAssesor"]
["Arbeitsprodukt","Beschreibung",null,null,null,null,null,null,null,null,"Link to Review",null,"SIM","SOM","FS Reviewer","FS Assesor",null,null,null,"Link zum Dokument",null,null,"Rolle, Name","in %",null,"mit Kommentar","SIM [h]","SIM Kommentar","SOM [h]","SOM Kommentar","Reviewer [h]","Kommentar","Assesor [h]","Kommentar","delegierte Jobs","Kommentar",null,null,"Rating",null,"Rating",null,"Rating"]
["Funktionale\nSicherheit (FS)\nMeilenstein\nKunde","ISO 26262 Teil 3 \"Konzeptphase\".\nBasis für die Entwicklung: FS mit den Ergebnissen der XY-Analyse: Wenn eine \"Lastenheft\" Kundenspezifikation die Grundlage für die Entwicklung sein soll, sind die Artikeldefinition und der FSC aus der LH nach FSI-12-Richtlinie zu erarbeiten.\nHinweis: Für Produktänderungen sollte der FS-Meilenstein \"Kunde\" mit dem FS-Meilenstein \"Planung\" kombiniert werden",null,"XY100","RE223","ASIL A","SYS",1,"M6",null,null,{"$f":"SUM(M3:P3)","v":20},10,1,6,3,null,"2019-06-30",0.7,null,0.82,"in Arbeit",null,0.7,null,{"$f":"SUM(AA3:AG3)","v":79},25,null,32,null,12,null,10]
["Artikel Definition","Jetzt Teil der Systemanforderungs-Spezifikation SS420.dcx. Die Systemdomäne ist für die Elementdefinition verantwortlich, auf die im Handbuch verwiesen werden soll. SIM (Safety Manager) ist verantwortlich für die Überprüfung und den FS-relevanten Erweiterungen der Artikeldefinition",null,"XY101","RE225","ASIL A","all",1,"M6","OK","SIM",24,16,2,4,2,null,"2019-03-15",1,"Pflichtenheft: V100_System_Requirements-Spezifikation.docx\nPfad: C:\\Projekte\\V100\\Dku\\SRS",1,"fertig","PM",1,null,{"$f":"SUM(AA4:AG4)","v":31},12,null,4,null,6,null,9,null,null,null,null,"C:\\Projekte\\V100\\Dku\\SRS\\ProjektMgmFusi.pdf",3,"C:\\Projekte\\V100\\Dku\\SRS\\ProjektMgmFusi.pdf",2]
["Gefahrenanalyse und Risikobewertung","Die Klaasifizierung muss genehmigt werden vom Leiter des Sicherheitsmanagements. Stand der Technik muss verifiziert werden. Kann durch Plausibilitätsanalyse ersetzt werden, wenn die Ergebnisse aus der XY stammen.",null,"XY810","RE511","ASIL A","SYS",1,"M6","OK","SIM",{"$f":"SUM(M5:P5)","v":39},20,5,6,8,null,"n/a",1,"Siehe Kap. 3.2 in Safety.doc",1,"fertig","PM",1,null,15,3,null,4,null,6,null,2]
["Funktionales Sicherheitskonzept","Das FSK sollte vom Kunden kommen. Das FSK muss für jedes Sicherheitsziel die Zuweisung und die Anforderungen an die beteiligten Subsysteme und Schnittstellen angeben. Die Zuordnung der Sicherheitsfunktionen soll durch ein Blockdiagramm visualisiert werden.",null,"XY852","RE521","ASIL A","SYS",1,"M7","OK","SIM",{"$f":"SUM(M6:P6)","v":65},40,12,8,5,null,"2019-06-29",1,null,1,"fertig","PM",1,null,34,14,null,6,null,9,null,5]
["FS Assessment Kunde","Der Standard erfordert die Bestätigungsüberprüfung der Gefahrenanalyse und Risikobewertung.",null,"AB333 oder Ab336","RE921","ASIL A","Mgmt",2,"M7","Mit Registrierung","Assesor\nPM",101,60,21,12,8,null,"2019-02-25",0.7,"Gespeichert unter C:\\Projekte\\V100\\Doku\\Ass",0.75,null,"SIM",0.8,null,36,6,null,12,null,8,null,10]
["FS-Meilenstein Planung","ISO 26262 Teil4 Produktentwicklung. Planung für \nSichereheitplan\nTSC SYS\nSYS-FMEA\nUnter Beachtung von ASIL C und D, wenn für diesen Meilenstein ein unabhängiges Assessment durchgeführt werden soll.",null,null,null,"ASIL A",null,2,"M7",null,null,57,25,16,8,8,null,"2019-06-27",0.6,null,0.68,null,null,0.7,null,20,4,null,4,null,6,null,6]
["Sicherheitsplan \n(SP)","Die Entwicklung des Sicherheitsplan bezieht sich auf zusätzliche Dokumente, wenn z. B. Wirkungsanalyse, projektspezifische Anpassungen, Nutzung gemeinsamer Teile, Änderung des projektspezifischen Verhaltens (Team), Terminplanung, Aspekte projektspezifischer Lieferanten, ...",null,"AB745","RE955","ASIL A","Mgmt",2,"M7","Mit Registrierung","SIM",60,40,4,12,4,null,"2019-03-31",0.75,"Gespeichert unter C:\\Projekte\\V100\\Doku\\Ass",0.75,null,"PM",0.75,null,24,6,null,4,null,8,null,6]

{"sheet":"Fortschrittsbericht","index":2,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"Sicherheits-Fortschrittsbericht","Verantwortlich\nRolle / Name","Ziel-Meilenstein-Plan","Falligkeitsdatum nach Zeitplan","Dokument-Reife","Review Status","Kommentar zu Erwartungen","Kosten Plan","Kosten Ist"]
[null,"Datum der letzten Aktualisierung",null,null,"2019-06-28"]
[null,"FS-Meilenstein Kunde",null,"M6","2019-06-29",0.82,0.7,null,null,null,null,null,null,"according SPICE"]
[null,"Artikel Definition","SIM","M6","2019-01-20",1,1,null,null,null,null,null,null,"F: 85-100%   (Fully)"]
[null,"Gefahrenanalyse und Risikobewertung","SIM","M6","n/a",1,1,null,null,null,null,null,null,"L:  51-85 %   (Largely)"]
[null,"Funktionales Sicherheitskonzept","SIM","M6","2019-01-27",1,1,null,null,null,null,null,null,"N =: 0-15%    (None)\nP: 16-50%     (Partely)"]
[null,"FS Assessment Kunde","Assesor / PM","M6","2019-06-29",0.5,0,"angefordert"]
[null,"FS-Meilenstein Planung",null,"M7","2019-07-27",0.68,0.7]
[null,"Sicherheitplan","SIM","M7","2019-01-31",0.75,0.75]
[null,"Sicherheitsplan und Aufgabenplan","PM","M7","2019-05-20",1,1]
[null,"Systemanforderungen Spezifikation","SYS","M7","2019-06-29",0.6,0.7]
[null,"Sicherheitsanalyse System","SYS","M7","2019-04-01",1,1]
[null,"Technisches Sicherheitskonzept","SIM","M7","2019-04-01",0.75,0.75]
[null,"FS Assessment Planung","Assesor / PM","M7","2019-07-27",0,0]
[null,"FS-Meilenstein Entwicklung",null,"M8","2019-07-27",0.15,0.12]
[null,"System",null,null,"2019-07-27",0.38,0.3]
[null,"Anforderungsspezifikation Sicherheit HW",{"$f":"[1]Development!L16","v":0},"M8","2019-06-01",0.75,0.6]
[null,"Anforderungsspezifikation Sicherheit SW",{"$f":"[1]Development!L18","v":"SIM"},"M8",{"$f":"[1]Development!S18","v":"n/a"},0,0]
[null,"Anforderungsspezifikation SYS",{"$f":"[1]Development!L19","v":"SYS"},"M8",{"$f":"[1]Development!S19","v":"n/a"},0,0]
[null,"System Architektur / System Design",{"$f":"[1]Development!L20","v":"SYS"},"M8",{"$f":"[1]Development!S20","v":"n/a"},0,0]
[null,{"$f":"[1]Development!A21","v":"Master Testplan"},{"$f":"[1]Development!L21","v":"Testmanager"},"M8","2019-07-01",0,0]
[null,"HW Entwicklung","HW","M8","2019-07-01",0.82,0.62]
[null,"HW Design",{"$f":"[1]Development!L23","v":"HW"},"M8","2019-07-01",0.75,0.5]