{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["EST_project_iteration","EST_RISK_SCHEDULE"],"not_rendered":{"images":2,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"EST_project_iteration","index":0,"n_rows":51,"n_cols":11,"rows_kept":51}
["Project Estimation: Customer.ProjectName"]
[]
["Estimation Results Total",{"$nulls":5},"Effort estimated/ Ph","Est. 3rd Party Cost/ CHF","Description"]
[null,"Total",{"$nulls":4},{"$f":"SUM(G7:G42)/2","v":0},{"$f":"SUM(H7:H42)/2","v":0}]
[null,"Total w/o Separate Risks",{"$nulls":4},{"$f":"SUM(G7:G38)/2","v":0},{"$f":"SUM(H7:H38)/2","v":0}]
[]
[{"$nulls":8},"Assumed Project Team: "]
["Estimation Results per Work Item",{"$nulls":7},"Assumed Process Tailoring Level: "]
["Phase","Component (Work Package)","Work Item","Deliverable","Effort normal/\nPh","Effort Worst Case/ Ph","Effort estimated*/ Ph","Est. 3rd Party Cost/ CHF","Description","Assumptions","Remaining Risks"]
["Example Phase: Module Inception/ Framework Design"]
[null,"module1_sw",null,null,{"$f":"SUM(E12:E18)","v":0},{"$f":"SUM(F12:F18)","v":0},{"$f":"MAX(E11+(F11-E11)/3,E11)","v":0},{"$f":"SUM(H12:H18)","v":0}]
[null,null,"specify module","MODSPEC_module",null,null,{"v":0,"d":"0.0"}]
[null,null,"define components/ package diagram/ interfaces/ tests","MODARCH_module",null,null,{"v":0,"d":"0.0"}]
[null,null,"evaluate tools and platforms","MODARCH_module",null,null,{"v":0,"d":"0.0"}]
[null,null,"implement framework","framework source",null,null,{"v":0,"d":"0.0"}]
[null,null,"test framework","framwork TESTLIST",null,null,{"v":0,"d":"0.0"}]
[null,null,"discuss framework","MINUTES",null,null,{"v":0,"d":"0.0"}]
[]
[null,"module2_sw",null,null,{"$f":"SUM(E20:E26)","v":0},{"$f":"SUM(F20:F26)","v":0},{"$f":"MAX(E19+(F19-E19)/3,E19)","v":0},{"$f":"SUM(H20:H26)","v":0}]
[null,null,"specify module","MODSPEC_module",null,null,{"v":0,"d":"0.0"}]
[null,null,"define components/ package diagram/ interfaces/ tests","MODARCH_module",null,null,{"v":0,"d":"0.0"}]
[null,null,"evaluate tools and platforms","MODARCH_module",null,null,{"v":0,"d":"0.0"}]
[null,null,"implement framework","framework source",null,null,{"v":0,"d":"0.0"}]
[null,null,"test framework","framwork TESTLIST",null,null,{"v":0,"d":"0.0"}]
[null,null,"discuss framework","MINUTES",null,null,{"v":0,"d":"0.0"}]
[]
["Example Phase: Project Management"]
[null,"system",null,null,{"$f":"SUM(E29:E38)","v":0},{"$f":"SUM(F29:F38)","v":0},{"$f":"MAX(E28+(F28-E28)/3,E28)","v":0},{"$f":"SUM(H29:H38)","v":0}]
[null,null,"setup project","all tools and plans",null,null,{"v":0,"d":"0.0"},null,"acc. ProjectSetupProcDescr"]
[null,null,"project familiarization","n Ph reading & understanding for y engineers",null,null,{"v":0,"d":"0.0"},null,"all study work to understand the project"]
[null,null,"reporting","n reports",null,null,{"v":0,"d":"0.0"},null,"customer reporting acc. ExecutionTrackingProcDescr"]
[null,null,"sprint planning & tracking","n planning sessions & m tracking sessions",null,null,{"v":0,"d":"0.0"},null,"typically weekly, including execution of correction measures"]
[null,null,"release planning & audits","planning & n reviews",null,null,{"v":0,"d":"0.0"},null,"configuration, planning... audits\nincl. rework after review!"]
[null,null,"general project management",{"$nulls":3},{"v":0,"d":"0.0"},null,"other PM/ QA items"]
[null,null,"risk tracking",{"$nulls":3},{"v":0,"d":"0.0"}]
[null,null,"retrospectives","n retrospectives with m engr's",null,null,{"v":0,"d":"0.0"}]
[null,null,"debrief project",{"$nulls":3},{"v":0,"d":"0.0"},null,"this is the minimum project closure"]
[]
["Separate Risks"]
[null,"system",{"$nulls":4},{"$f":"SUM(G41:G42)","v":0},{"$f":"SUM(H41:H42)","v":0}]
[null,null,"total separate risks",null,"n.a.","n.a.",{"$f":"EST_RISK_SCHEDULE!I8","v":0},{"$f":"EST_RISK_SCHEDULE!J8","v":0},"acc. risk analysis sheet"]
[]
[]
[]
["Legend",{"$nulls":4},"Revision History"]
[{"$nulls":5},"Version","draft/ for review/ released","Date","Responsible","Remarks"]
["Missing Input (or Formula)",{"$nulls":4},"00.01",null,"2009-08-21","a2s"]
["User Input"]
["Formula Entry (& Verification!)"]
["Calculated"]
["End of Sum"]

{"sheet":"EST_RISK_SCHEDULE","index":1,"n_rows":27,"n_cols":13,"rows_kept":27}
[{"$f":"EST_project_iteration!A1","v":"Project Estimation: Customer.ProjectName"}]
["Initial Risk Discovery & Initial Schedule"]
[]
["Separate Risks (apart from estimation risks)",null,null,"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...) "]
["discover acc. RiskChecklist"]
[]
["Type","Name","Description ","Effect","Probability","Effort Damage/ Ph","Cost Damage/ CHF","Additional Schedule Damage/ d","Effort Risk/ Ph","Cost Risk/ CHF","Mitigation","Mitigation Issue (JIRA)","Remarks"]
["Total",{"$nulls":6},{"$f":"SUMPRODUCT(E9:E21,H9:H21)","v":0},{"$f":"SUM(I10:I21)","v":0},{"$f":"SUM(J10:J21)","v":0}]
["Risks Under Project Control"]
[null,"unknown technology",null,"additional effort needed, rework needed",{"$nulls":4},{"$f":"E10*F10","v":0},{"$f":"E10*G10","v":0},null,"XX-"]
[null,"unknown application",null,"additional effort needed, training needed",{"$nulls":4},{"$f":"E11*F11","v":0},{"$f":"E11*G11","v":0},null,"XX-"]
[null,"unknown customer",{"$nulls":6},{"$f":"E12*F12","v":0},{"$f":"E12*G12","v":0},null,"XX-"]
[{"$nulls":8},{"$f":"E13*F13","v":0},{"$f":"E13*G13","v":0},null,"XX-"]
[{"$nulls":8},{"$f":"E14*F14","v":0},{"$f":"E14*G14","v":0},null,"XX-"]
["Risks Outside Project Control"]
[null,"unforeseen changes","additional changes to the project requirememnts","more effort/ more time",{"$nulls":4},{"$f":"E16*F16","v":0},{"$f":"E16*G16","v":0},null,"XX-"]
[{"$nulls":8},{"$f":"E17*F17","v":0},{"$f":"E17*G17","v":0},null,"XX-"]
[{"$nulls":8},{"$f":"E18*F18","v":0},{"$f":"E18*G18","v":0},null,"XX-"]
[{"$nulls":8},{"$f":"E19*F19","v":0},{"$f":"E19*G19","v":0},null,"XX-"]
[{"$nulls":8},{"$f":"E20*F20","v":0},{"$f":"E20*G20","v":0},null,"XX-"]
[]
[]
[]
["Planned Milestones & Releases"]
["Abbreviation","Name","Description ","Milestone/ Release",null,null,"Desired Date"]
[null,"Mechanics Integration","first production PCB untested ready","Milestone",null,null,"2010-04-01"]
[null,"Prototype  ",null,"Release",null,null,"2010-07-01"]