{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Sum","1901","1902"],"not_rendered":{"charts":1,"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Sum","index":0,"n_rows":44,"n_cols":7,"rows_kept":44}
["Risk Tracking ProjectName"]
[]
[]
["Risk Sum Tracking"]
[]
["Sheet","Date","Effort Risk/ Ph","Cost Risk/ kEUR","Schedule Risk/ d"]
["1901",{"$f":"INDIRECT(\"'\"&$A7&\"'!$c$2\")","v":"2019-01-30"},{"$f":"INDIRECT(\"'\"&$A7&\"'!$J$6\")","v":0},{"$f":"INDIRECT(\"'\"&$A7&\"'!$k$6\")/1000","v":{"v":0,"d":"0.0"}},{"$f":"INDIRECT(\"'\"&$A7&\"'!$i$6\")","v":0}]
["1902",{"$f":"INDIRECT(\"'\"&$A8&\"'!$c$2\")","v":"2019-02-28"},{"$f":"INDIRECT(\"'\"&$A8&\"'!$J$6\")","v":0},{"$f":"INDIRECT(\"'\"&$A8&\"'!$k$6\")/1000","v":{"v":0,"d":"0.0"}},{"$f":"INDIRECT(\"'\"&$A8&\"'!$i$6\")","v":0}]
["1903"]
["1904"]
["1905"]
["1906"]
["1907"]
["1908"]
["1909","2019-12-23"]
[null,"^enter here planned end date of the project"]
{"$rows_empty":7}
[{"$nulls":6},"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...) "]
{"$rows_empty":15}
["Legend:"]
["Missing Input (or Formula)"]
["User Input"]
["Calculated"]
["End of Sum"]

{"sheet":"1901","index":1,"n_rows":70,"n_cols":15,"rows_kept":70}
["Project Risk Tracking: Customer.ProjectName"]
[null,null,"2019-01-30"]
[{"$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":3},"Number","of Priority","Lower Threshold/ Ph","Lower Threshold/ EUR",null,"Additional Schedule Risk/ d","Effort Risk/ Ph","Cost Risk/ EUR","Total Cost Risk/ EUR"]
[null,null,"Sums",{"$f":"SUM(D7:D9)","v":0},"Total",null,null,"Sums",{"$f":"SUMPRODUCT(F9:F51,I9:I51)","v":0},{"$f":"SUM(J13:J51)","v":0},{"$f":"SUM(K13:K51)","v":0},{"$f":"SUM(L13:L51)","v":0}]
[{"$nulls":3},{"$f":"COUNTIF(D12:D51,E7)","v":0},{"$f":"J54","v":"Program"},{"$f":"MAX(L54,C$54*K54)/C$55","v":{"v":90.00000000000001,"d":"90"}},{"$f":"MAX(L54,C$54*K54)","v":{"v":9000.000000000002,"d":"9,000"}}]
[{"$nulls":3},{"$f":"COUNTIF(D12:D51,E8)","v":0},{"$f":"J55","v":"Project"},{"$f":"MAX(L55,C$54*K55)/C$55","v":40},{"$f":"MAX(L55,C$54*K55)","v":{"v":4000,"d":"4,000"}}]
[{"$nulls":3},{"$f":"COUNTIF(D12:D51,E9)","v":0},{"$f":"J56","v":"Task"},{"$f":"MAX(L56,C$54*K56)/C$55","v":0},{"$f":"MAX(L56,C$54*K56)","v":0}]
[{"$nulls":3},{"$f":"COUNTIF(D13:D52,E10)","v":0},"Closed","n.a.","n.a."]
[]
["Category","Name","Description ","Priority","Effect","Probability","Effort Damage/ Ph","Cost Damage/ EUR","Additional Schedule Damage/ d","Effort Risk/ Ph","Cost Risk/ EUR","Total Cost Risk/ EUR","Mitigation* (or Reason Not to Mitigate)","Mitigation Issue (JIRA)","Remarks"]
["Project Type","technology","technology problems, more complexity than thought",null,"additional effort needed, rework needed, external consulting needed",{"$nulls":4},{"$f":"F13*G13","v":0},{"$f":"F13*H13","v":0},{"$f":"J13*$C$55+K13","v":0},null,null,"cost: cost for external expert"]
["Project Type","application complexity","application is more complex than anticipated",null,"additional effort needed, more familiarization needed",{"$nulls":4},0,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,0]
["Project Type",{"$nulls":8},0,0,0]
["Safety","auditor","auditor/ external consultant wants additional evidence/ paperwork",null,"more effort than planned, new templates required",{"$nulls":4},0,0,0]
["Safety","tool qualification","more tool qualification requested than planned",null,"more tool qualification effort or external cost",{"$nulls":4},0,0,0]
["Safety",{"$nulls":8},0,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,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,0]
["Project Management","lead times","under-estimated lead times for  releases, production, certification",null,"more delay ",{"$nulls":4},0,0,0]
["Project Management",{"$nulls":8},0,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,0]
["System Development","architecture failure","wrong architecture/ tool/ technology used",{"$nulls":6},0,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,0]
["System Development",{"$nulls":8},0,0,0]
["Software Development","interfaces/ protocols","interfaces not specified in enough detail",{"$nulls":6},0,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,0]
["Software Development","architecture failure","wrong architecture/ tool/ technology used",{"$nulls":6},0,0,0]
["Software Development",{"$nulls":8},0,0,0]
["Hardware Development","component errors ","components have bugs, misunderstood datasheets",null,"redesign to replace component and production of additional prototypes",{"$nulls":4},0,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,0]
["Hardware Development",{"$nulls":8},0,0,0]
["Validation/ Production","production test underestiamted","manufacturer wants additional tests, test setups...",null,"more effort needed",{"$nulls":4},0,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,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,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,0,"rapid prototypes"]
["Validation/ Production",{"$nulls":8},0,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,0]
["General",{"$nulls":8},0,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,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,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,0]
["Customer","customer/ 3rd party deliverables","artifacts not on time/ not in the required quality",null,"delay, more effort due to rework",{"$nulls":4},{"$f":"F45*G45","v":0},{"$f":"F45*H45","v":0},0]
["Customer","customer clearances and releases","delays in internal clearances of customer (like components engineering, test engineering...)",null,"delays",{"$nulls":4},0,0,0]
["Customer",{"$nulls":8},0,0,0]
["Supplier","quality problems","general quality problems",null,"repair or respin needed",{"$nulls":4},0,0,0]
["Supplier","delays","late delivery",null,"project delays",{"$nulls":4},0,0,0]
["Supplier",{"$nulls":8},0,0,0]
[]
[]
["Project Data",{"$nulls":8},"Priority","Lower Limit\nRel. Total Cost Risk","Lower Limit \nAbs. Total Cost Risk/ EUR","Mitigation Requirements","Mitigation Documentation Requirements"]
["Total project cost/ EUR",null,{"v":500000,"d":"500,000"},{"$nulls":6},"Program",{"v":0.018000000000000002,"d":"0.02"},{"v":4000,"d":"4,000"},"mitigation decided by company mgmt","document in RISK sheet above"]
["Project Hour Rate/ EUR/Ph",null,100,{"$nulls":6},"Project",{"v":0.008,"d":"0.01"},{"v":2000,"d":"2,000"},"mitigation decided by project magmt.","document in RISK sheet above"]
[{"$nulls":9},"Task",{"v":0,"d":"0.00"},0,"mitigation decided by engineer","during normal development work"]
[{"$nulls":9},"Closed","n.a.","n.a.","no mitigation needed: is mitigated or has not occurred or has occurred","n.a."]
[]
[]
[{"$nulls":12},"*Mitigation Strategies"]
[{"$nulls":12},"Requirements risks:"]
[{"$nulls":12},"mitigate by offering only well-specified parts for fixed, rest acc. effort"]
[{"$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"]
[{"$nulls":12},"Political risks:"]
[{"$nulls":12},"mitigate by communication with all stakeholders at customer"]
[{"$nulls":12},"Time risks:"]
[{"$nulls":12},"mitigate by adding buffers to the project schedule"]

{"sheet":"1902","index":2,"n_rows":70,"n_cols":15,"rows_kept":70}
["Project Risk Tracking: Customer.ProjectName"]
[null,null,"2019-02-28"]
[{"$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":3},"Number","of Priority","Lower Threshold/ Ph","Lower Threshold/ EUR",null,"Additional Schedule Risk/ d","Effort Risk/ Ph","Cost Risk/ EUR","Total Cost Risk/ EUR"]
[null,null,"Sums",{"$f":"SUM(D7:D9)","v":0},"Total",null,null,"Sums",{"$f":"SUMPRODUCT(F9:F51,I9:I51)","v":0},{"$f":"SUM(J13:J51)","v":0},{"$f":"SUM(K13:K51)","v":0},{"$f":"SUM(L13:L51)","v":0}]
[{"$nulls":3},{"$f":"COUNTIF(D12:D51,E7)","v":0},{"$f":"J54","v":"Program"},{"$f":"MAX(L54,C$54*K54)/C$55","v":{"v":90.00000000000001,"d":"90"}},{"$f":"MAX(L54,C$54*K54)","v":{"v":9000.000000000002,"d":"9,000"}}]
[{"$nulls":3},{"$f":"COUNTIF(D12:D51,E8)","v":0},{"$f":"J55","v":"Project"},{"$f":"MAX(L55,C$54*K55)/C$55","v":40},{"$f":"MAX(L55,C$54*K55)","v":{"v":4000,"d":"4,000"}}]
[{"$nulls":3},{"$f":"COUNTIF(D12:D51,E9)","v":0},{"$f":"J56","v":"Task"},{"$f":"MAX(L56,C$54*K56)/C$55","v":0},{"$f":"MAX(L56,C$54*K56)","v":0}]
[{"$nulls":3},{"$f":"COUNTIF(D13:D52,E10)","v":0},"Closed","n.a.","n.a."]
[]
["Category","Name","Description ","Priority","Effect","Probability","Effort Damage/ Ph","Cost Damage/ EUR","Additional Schedule Damage/ d","Effort Risk/ Ph","Cost Risk/ EUR","Total Cost Risk/ EUR","Mitigation* (or Reason Not to Mitigate)","Mitigation Issue (JIRA)","Remarks"]
["Project Type","technology","technology problems, more complexity than thought",null,"additional effort needed, rework needed, external consulting needed",{"$nulls":4},{"$f":"F13*G13","v":0},{"$f":"F13*H13","v":0},{"$f":"J13*$C$55+K13","v":0},null,null,"cost: cost for external expert"]
["Project Type","application complexity","application is more complex than anticipated",null,"additional effort needed, more familiarization needed",{"$nulls":4},0,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,0]
["Project Type",{"$nulls":8},0,0,0]
["Safety","auditor","auditor/ external consultant wants additional evidence/ paperwork",null,"more effort than planned, new templates required",{"$nulls":4},0,0,0]
["Safety","tool qualification","more tool qualification requested than planned",null,"more tool qualification effort or external cost",{"$nulls":4},0,0,0]
["Safety",{"$nulls":8},0,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,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,0]
["Project Management","lead times","under-estimated lead times for  releases, production, certification",null,"more delay ",{"$nulls":4},0,0,0]
["Project Management",{"$nulls":8},0,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,0]
["System Development","architecture failure","wrong architecture/ tool/ technology used",{"$nulls":6},0,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,0]
["System Development",{"$nulls":8},0,0,0]
["Software Development","interfaces/ protocols","interfaces not specified in enough detail",{"$nulls":6},0,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,0]
["Software Development","architecture failure","wrong architecture/ tool/ technology used",{"$nulls":6},0,0,0]
["Software Development",{"$nulls":8},0,0,0]
["Hardware Development","component errors ","components have bugs, misunderstood datasheets",null,"redesign to replace component and production of additional prototypes",{"$nulls":4},0,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,0]
["Hardware Development",{"$nulls":8},0,0,0]
["Validation/ Production","production test underestiamted","manufacturer wants additional tests, test setups...",null,"more effort needed",{"$nulls":4},0,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,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,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,0,"rapid prototypes"]
["Validation/ Production",{"$nulls":8},0,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,0]
["General",{"$nulls":8},0,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,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,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,0]
["Customer","customer/ 3rd party deliverables","artifacts not on time/ not in the required quality",null,"delay, more effort due to rework",{"$nulls":4},{"$f":"F45*G45","v":0},{"$f":"F45*H45","v":0},0]
["Customer","customer clearances and releases","delays in internal clearances of customer (like components engineering, test engineering...)",null,"delays",{"$nulls":4},0,0,0]
["Customer",{"$nulls":8},0,0,0]
["Supplier","quality problems","general quality problems",null,"repair or respin needed",{"$nulls":4},0,0,0]
["Supplier","delays","late delivery",null,"project delays",{"$nulls":4},0,0,0]
["Supplier",{"$nulls":8},0,0,0]
[]
[]
["Project Data",{"$nulls":8},"Priority","Lower Limit\nRel. Total Cost Risk","Lower Limit \nAbs. Total Cost Risk/ EUR","Mitigation Requirements","Mitigation Documentation Requirements"]
["Total project cost/ EUR",null,{"v":500000,"d":"500,000"},{"$nulls":6},"Program",{"v":0.018000000000000002,"d":"0.02"},{"v":4000,"d":"4,000"},"mitigation decided by company mgmt","document in RISK sheet above"]
["Project Hour Rate/ EUR/Ph",null,100,{"$nulls":6},"Project",{"v":0.008,"d":"0.01"},{"v":2000,"d":"2,000"},"mitigation decided by project magmt.","document in RISK sheet above"]
[{"$nulls":9},"Task",{"v":0,"d":"0.00"},0,"mitigation decided by engineer","during normal development work"]
[{"$nulls":9},"Closed","n.a.","n.a.","no mitigation needed: is mitigated or has not occurred or has occurred","n.a."]
[]
[]
[{"$nulls":12},"*Mitigation Strategies"]
[{"$nulls":12},"Requirements risks:"]
[{"$nulls":12},"mitigate by offering only well-specified parts for fixed, rest acc. effort"]
[{"$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"]
[{"$nulls":12},"Political risks:"]
[{"$nulls":12},"mitigate by communication with all stakeholders at customer"]
[{"$nulls":12},"Time risks:"]
[{"$nulls":12},"mitigate by adding buffers to the project schedule"]