{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Risk Management"],"not_rendered":{"images":2,"defined_names":26,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Risk Management","index":0,"n_rows":62,"n_cols":15,"rows_kept":62}
["Project Risk Tracking: ProjectName"]
[null,null,"202Y-MM-DD"]
[{"$nulls":4},"Project Risk Management Scope: risk management in projects covers only the risks of the project, not company or general risks (like server crash, fire in the company...) "]
[]
[{"$nulls":8},"Additional Schedule Risk/ d","Effort Risk/ Ph","Cost Risk/ EUR"]
[null,null,"Sums over the Project",null,"Total",null,null,"Sums",{"$f":"SUMPRODUCT(F7:F47,I7:I47)","v":0},{"$f":"SUM(J9:J47)","v":0},{"$f":"SUM(K9:K47)","v":0}]
[]
["Category","Name","Description ",null,"Effect","Probability","Effort Damage/ Ph","Cost Damage/ CHF","Additional Schedule Damage/ d","Effort Risk/ Ph","Cost Risk/ EUR",null,"Mitigation* (or Reason Not to Mitigate)","Mitigation Ticket","Remarks"]
["Project Type","technology","technology problems, more complexity than thought",null,"additional effort needed, rework needed, external consulting needed",{"$nulls":4},{"$f":"F9*G9","v":0},{"$f":"F9*H9","v":0},{"$nulls":3},"cost: cost for external expert"]
["Project Type","application complexity","application is more complex than anticipated",null,"additional effort needed, more familiarization needed",{"$nulls":4},{"$f":"F10*G10","v":0},0]
["Project Type","low-cost design","low cost design (esp. BOM cost) might lead to leave precautions away (more layers, using COTS software, using better CPU's...)",null,"additional work is needed to correct the problems from saving cost",{"$nulls":4},0,0]
["Project Type",{"$nulls":8},0,0]
["Safety","auditor","auditor/ external consultant wants additional evidence/ paperwork",null,"more effort than planned, new templates required",{"$nulls":4},0,0]
["Safety","tool qualification","more tool qualification requested than planned",null,"more tool qualification effort or external cost",{"$nulls":4},0,0]
["Safety",{"$nulls":8},0,0]
["Project Management","feature border cases","additional “features” creep in, especially stemming from unclear specifications (border cases: “Grenzfälle”)",null,"implementation & test effort goes up in many small increments. leading to large overshoot",{"$nulls":4},0,0]
["Project Management","partners","skills/ performance of partners not good enough",null,"search for new partners, more support for partners needed",{"$nulls":4},0,0]
["Project Management","lead times","under-estimated lead times for  releases, production, certification",null,"more delay ",{"$nulls":4},0,0]
["Project Management",{"$nulls":8},0,0]
["System Development","hardware/ software integration","hardware does not work as expected, modules do not integrate as expected",null,"more bring-up effort & time",{"$nulls":4},0,0]
["System Development","architecture failure","wrong architecture/ tool/ technology used",{"$nulls":6},0,0]
["System Development","target unreachable","specifications are unclear, contradictory or technically not reachable",null,"update/ redo specification, re-evaluate technology",{"$nulls":4},0,0,null,"rapid prototypes"]
["System Development",{"$nulls":8},0,0]
["Software Development","interfaces/ protocols","interfaces not specified in enough detail",{"$nulls":6},0,0]
["Software Development","3rd party software","supplied (commercial or open-source) software components have bugs/ errors",null,"effort to debug and implement work around",{"$nulls":4},0,0]
["Software Development","architecture failure","wrong architecture/ tool/ technology used",{"$nulls":6},0,0]
["Software Development",{"$nulls":8},{"$f":"F27*G27","v":0},{"$f":"F27*H27","v":0}]
["Hardware Development","component errors ","components have bugs, misunderstood datasheets",null,"redesign to replace component and production of additional prototypes",{"$nulls":4},0,0]
["Hardware Development","prototype useless","severe design or layout error that cannot be corrected",null,"redesign and production of additional prototypes",{"$nulls":4},0,0]
["Hardware Development",{"$nulls":8},0,0]
["Validation/ Production","production test underestiamted","manufacturer wants additional tests, test setups...",null,"more effort needed",{"$nulls":4},0,0]
["Validation/ Production","production problems","problems show only after a certain number is produced",null,"another layout and software relase is needed",{"$nulls":4},0,0]
["Validation/ Production","fieldtests","missing or too short fieldtests",null,"errors and problems show up only after series start: redesign needed",{"$nulls":4},0,0]
["Validation/ Production","field/ validation test rigor","the test environment is too benign wrt. the real product environment/ use (“positive selection” of test cases)",null,"errors and problems show up only after series start: redesign needed",{"$nulls":4},0,0]
["Validation/ Production",{"$nulls":8},0,0]
["General","tool problems","new release of software tool has bugs or changes that affect the current project",null,"delays (effort for support, workarounds... is on Solcept side (PI))",{"$nulls":4},0,0]
["General",{"$nulls":8},0,0]
["Customer","information not available","information is not provided by customer or third parties",null,"delays, more effort due to rework after wrong assumptions",{"$nulls":4},0,0]
["Customer","decision problems","no responsible stakeholder at customer, no decision power, delayed decision making",null,"delays, more effort due to rework after wrong assumptions",{"$nulls":4},0,0]
["Customer","missing zero-series","production problems show up in the first large batch",null,"delay, more effort due to rework",{"$nulls":4},0,0]
["Customer","customer/ 3rd party deliverables","artifacts not on time/ not in the required quality",null,"delay, more effort due to rework",{"$nulls":4},0,0]
["Customer","customer clearances and releases","delays in internal clearances of customer (like components engineering, test engineering...)",null,"delays",{"$nulls":4},0,0]
["Customer",{"$nulls":8},0,0]
["Supplier","quality problems","general quality problems",null,"repair or respin needed",{"$nulls":4},0,0]
["Supplier","delays","late delivery",null,"project delays",{"$nulls":4},0,0]
["Supplier",{"$nulls":8},0,0]
[]
[]
[]
["Revision History:"]
["Version","draft/ for review/ approved","Date","Respon-sible","Comments/ Change History",{"$nulls":7},"*Mitigation Strategies"]
["00.01","draft","2021-01-20","a2s",{"$nulls":8},"Requirements risks:"]
[{"$nulls":12},"mitigate by clarifyingspecifications"]
[{"$nulls":12},"Technological risks:"]
[{"$nulls":12},"mitigate by prototyping or partnering (as early as possible)"]
[{"$nulls":12},"Skills risks:"]
[{"$nulls":12},"mitigate by training or partnering"]
[null,"The revision history status means:",{"$nulls":10},"Political risks:"]
[null,"Draft: unfinished, quality not assured yet",{"$nulls":10},"mitigate by communication with all stakeholders"]
[null,"For Review: completed and ready for verification",{"$nulls":10},"Time risks:"]
[null,"Approved: verified and ready for use",{"$nulls":10},"mitigate by adding buffers to the project schedule"]
[null,"Checked: checked by independent quality assurance (critical artifacts only)"]