{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Qualitative","Quantitative","Residual","Plot Matrix","Metrics","Risk Occurued"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":4,"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":"Qualitative","index":0,"n_rows":54,"n_cols":17,"rows_kept":54,"cut":false,"hidden":false,"merged":[[47,14,47,16],[12,0,12,2]]}
["Risk Register for Project Digital Repository"]
["Team Members: Project Manager: Performing all tasks"]
["ID#","WBS Task Affected","Risk Name","Description of Risk","Likelihood","Impact","Risk Level","Response Type","Specific actions to be taken for Response","Level After","Priority","Owner","Formula"]
["R1","3.2.2","Data Bandwidth","There is a Cap Allocated for bandwidth weekly for IIS App Pool it can cap its maximum",3,2,{"$f":"SUM(RiskData[[#This Row],[Likelihood]]*RiskData[[#This Row],[Impact]])","v":6},"Mitigate","Clear out cache from site to restart after max cap",{"$f":"IF(ISNUMBER(SEARCH(\"Transfer\",H4)),G4*0.6,IF(ISNUMBER(SEARCH(\"Mitigate\",H4)),G4*0.7,IF(ISNUMBER(SEARCH(\"Accept\",H4)),G4*1)))","v":4.1999999999999993},"1","Joel Jacobson (Project Manager)",{"$f":"SUM(RiskData[[#This Row],[Likelihood]]^4+RiskData[[#This Row],[Impact]])","v":83}]
["R2","3.2.2","Hosting Site Maintenance","Web Application will be hosted by a 3rd party organization, this organization can go sometimes under maintenance mode.",2,1,{"$f":"SUM(RiskData[[#This Row],[Likelihood]]*RiskData[[#This Row],[Impact]])","v":2},"Accept","Wait for Owners of hosting control to come back online",{"$f":"IF(ISNUMBER(SEARCH(\"Transfer\",H5)),G5*0.6,IF(ISNUMBER(SEARCH(\"Mitigate\",H5)),G5*0.7,IF(ISNUMBER(SEARCH(\"Accept\",H5)),G5*1)))","v":2},"3","Joel Jacobson (Project Manager)",{"$f":"SUM(RiskData[[#This Row],[Likelihood]]^4+RiskData[[#This Row],[Impact]])","v":17}]
["R3","2.1.2","Unlicensed Software","Because we don’t have a procurrement planning management person we might run into high monetary cost on buying softwares to develop",4,3,{"$f":"SUM(RiskData[[#This Row],[Likelihood]]*RiskData[[#This Row],[Impact]])","v":12},"Transfer","get annual license for the completion of the project lifetime",{"$f":"IF(ISNUMBER(SEARCH(\"Transfer\",H6)),G6*0.6,IF(ISNUMBER(SEARCH(\"Mitigate\",H6)),G6*0.7,IF(ISNUMBER(SEARCH(\"Accept\",H6)),G6*1)))","v":7.1999999999999993},"4","Joel Jacobson (Project Manager)",{"$f":"SUM(RiskData[[#This Row],[Likelihood]]^4+RiskData[[#This Row],[Impact]])","v":259}]
["R4","3.1.2","Hardware Performance","Because using personal computer with average performance, developing phase can slow down machine",4,4,{"$f":"SUM(RiskData[[#This Row],[Likelihood]]*RiskData[[#This Row],[Impact]])","v":16},"Mitigate","upgrade machine compnents",{"$f":"IF(ISNUMBER(SEARCH(\"Transfer\",H7)),G7*0.6,IF(ISNUMBER(SEARCH(\"Mitigate\",H7)),G7*0.7,IF(ISNUMBER(SEARCH(\"Accept\",H7)),G7*1)))","v":11.2},"2","Joel Jacobson (Project Manager)",{"$f":"SUM(RiskData[[#This Row],[Likelihood]]^4+RiskData[[#This Row],[Impact]])","v":260}]
["R5",{"$f":"(Qualitative!B8)","v":"1.4"},"Insufficient Data Collection ","Surveys will be sent out to personnel, don't collect enough data to analyze",3,5,{"$f":"SUM(RiskData[[#This Row],[Likelihood]]*RiskData[[#This Row],[Impact]])","v":15},"Mitigate","publish and promote site surveys to the social media",{"$f":"IF(ISNUMBER(SEARCH(\"Transfer\",H8)),G8*0.6,IF(ISNUMBER(SEARCH(\"Mitigate\",H8)),G8*0.7,IF(ISNUMBER(SEARCH(\"Accept\",H8)),G8*1)))","v":10.5},"5","Joel Jacobson (Project Manager)",{"$f":"SUM(RiskData[[#This Row],[Likelihood]]^4+RiskData[[#This Row],[Impact]])","v":86}]
["O1","2.1.4","Services Low cost","Found online hosting/domain sites with better cost efficiency compare to copmpetitors",1,3,{"$f":"SUM(RiskData[[#This Row],[Likelihood]]*RiskData[[#This Row],[Impact]])","v":3},"Accept","Did research base on analysis feedback of other buyers",{"$f":"IF(ISNUMBER(SEARCH(\"Transfer\",H9)),G9*0.6,IF(ISNUMBER(SEARCH(\"Mitigate\",H9)),G9*0.7,IF(ISNUMBER(SEARCH(\"Accept\",H9)),G9*1)))","v":3},"6","Joel Jacobson (Project Manager)",{"$f":"SUM(RiskData[[#This Row],[Likelihood]]^4+RiskData[[#This Row],[Impact]])","v":4}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Collection"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Response","Likelihood","Impact"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mitigate",1,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accept",2,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transfer",3,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5]

{"sheet":"Quantitative","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Risk Register for Project Digital Repository"]
["Team Members: Project Manager: Performing all tasks"]
["ID#","WBS Task Affected","Risk Name","Description of Risk","Original est Duration","Original Cost","Est Impact on Duration","Est Additional Cost","Risk Occurred?","New Duration","Final Cost"]
[{"$f":"(Qualitative!A4)","v":"R1"},"3.2.2",{"$f":"(Qualitative!C4)","v":"Data Bandwidth"},{"$f":"(Qualitative!D4)","v":"There is a Cap Allocated for bandwidth weekly for IIS App Pool it can cap its maximum"},5.33,0,1.67,60,"No",{"$f":"SUM(G4+E4)","v":7},{"$f":"SUM(F4,H4)","v":60}]
[{"$f":"(Qualitative!A5)","v":"R2"},"3.2.2",{"$f":"(Qualitative!C5)","v":"Hosting Site Maintenance"},{"$f":"(Qualitative!D5)","v":"Web Application will be hosted by a 3rd party organization, this organization can go sometimes under maintenance mode."},5.33,0,"1.67",0,"No",7,0]
[{"$f":"(Qualitative!A6)","v":"R3"},"2.1.2",{"$f":"(Qualitative!C6)","v":"Unlicensed Software"},{"$f":"(Qualitative!D6)","v":"Because we don’t have a procurrement planning management person we might run into high monetary cost on buying softwares to develop"},0,0,"0",200,"No",0,200]
[{"$f":"(Qualitative!A7)","v":"R4"},"3.1.2",{"$f":"(Qualitative!C7)","v":"Hardware Performance"},{"$f":"(Qualitative!D7)","v":"Because using personal computer with average performance, developing phase can slow down machine"},58.67,0,"1.33",500,"No",{"$f":"SUM(G7+E7)","v":60},500]
[{"$f":"(Qualitative!A8)","v":"R5"},"2.1.1",{"$f":"(Qualitative!C8)","v":"Insufficient Data Collection "},{"$f":"(Qualitative!D8)","v":"Surveys will be sent out to personnel, don't collect enough data to analyze"},7,0,"7",0,"No",14,0]
[{"$f":"(Qualitative!A9)","v":"O1"},"2.1.4",{"$f":"(Qualitative!C9)","v":"Services Low cost"},{"$f":"(Qualitative!D9)","v":"Found online hosting/domain sites with better cost efficiency compare to copmpetitors"},0,147,"0",-17,"No",0,{"$f":"SUM(F9,H9)","v":130}]

{"sheet":"Residual","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Risk Register for Project Digital Repository"]
["Team Members: Project Manager, IT Manager, Microcomputer Technician, System/Programmer, Analyst/Programmer, Infrastructure Technician"]
["ID#","WBS Task Affected","Risk Name","Description of Risk","Risk Associated","Residual","Secondary Risk Associate"]
[{"$f":"(Qualitative!A4)","v":"R1"},{"$f":"(Qualitative!B4)","v":"3.2.2"},{"$f":"(Qualitative!C4)","v":"Data Bandwidth"},{"$f":"(Qualitative!D4)","v":"There is a Cap Allocated for bandwidth weekly for IIS App Pool it can cap its maximum"},"Cost / Time","None","None"]
[{"$f":"(Qualitative!A5)","v":"R2"},{"$f":"(Qualitative!B5)","v":"3.2.2"},{"$f":"(Qualitative!C5)","v":"Hosting Site Maintenance"},{"$f":"(Qualitative!D5)","v":"Web Application will be hosted by a 3rd party organization, this organization can go sometimes under maintenance mode."},"Time","Delay Acceptance","None"]
[{"$f":"(Qualitative!A6)","v":"R3"},{"$f":"(Qualitative!B6)","v":"2.1.2"},{"$f":"(Qualitative!C6)","v":"Unlicensed Software"},{"$f":"(Qualitative!D6)","v":"Because we don’t have a procurrement planning management person we might run into high monetary cost on buying softwares to develop"},"Cost","None","None"]
[{"$f":"(Qualitative!A7)","v":"R4"},{"$f":"(Qualitative!B7)","v":"3.1.2"},{"$f":"(Qualitative!C7)","v":"Hardware Performance"},{"$f":"(Qualitative!D7)","v":"Because using personal computer with average performance, developing phase can slow down machine"},"Cost / Time","Hardware compatibility","None"]
[{"$f":"(Qualitative!A8)","v":"R5"},{"$f":"(Qualitative!B8)","v":"1.4"},{"$f":"(Qualitative!C8)","v":"Insufficient Data Collection "},{"$f":"(Qualitative!D8)","v":"Surveys will be sent out to personnel, don't collect enough data to analyze"},"Time","Reflect on Execution","None"]
[{"$f":"(Qualitative!A9)","v":"O1"},{"$f":"(Qualitative!B9)","v":"2.1.4"},{"$f":"(Qualitative!C9)","v":"Services Low cost"},{"$f":"(Qualitative!D9)","v":"Found online hosting/domain sites with better cost efficiency compare to copmpetitors"},"Cost","Saving Cost","Underperfoermace services"]

{"sheet":"Plot Matrix","index":3,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,8],[2,1,6,1],[8,4,8,8]]}
[]
[null,"Risk Map"]
[null,"Likelihood",5,"High Chance",{"$f":"showriskmap(RiskData[[#All],[Formula]],\"626\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"627\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"628\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"629\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"630\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""}]
[null,null,4,"Almost certain",{"$f":"showriskmap(RiskData[[#All],[Formula]],\"257\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"258\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"259\",RiskData[[#All],[Risk Name]],CHAR(10))","v":"Unlicensed Software\n"},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"260\",RiskData[[#All],[Risk Name]],CHAR(10))","v":"Hardware Performance\n"},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"261\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""}]
[null,null,3,"Certain",{"$f":"showriskmap(RiskData[[#All],[Formula]],\"82\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"83\",RiskData[[#All],[Risk Name]],CHAR(10))","v":"Data Bandwidth\n"},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"84\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"85\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"86\",RiskData[[#All],[Risk Name]],CHAR(10))","v":"Insufficient Data Collection \n"}]
[null,null,2,"Likely",{"$f":"showriskmap(RiskData[[#All],[Formula]],\"17\",RiskData[[#All],[Risk Name]],CHAR(10))","v":"Hosting Site Maintenance\n"},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"18\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"19\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"20\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"21\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""}]
[null,null,1,"Not Likely",{"$f":"showriskmap(RiskData[[#All],[Formula]],\"x2\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"3\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"4\",RiskData[[#All],[Risk Name]],CHAR(10))","v":"Services Low cost\n"},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"5\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""},{"$f":"showriskmap(RiskData[[#All],[Formula]],\"6\",RiskData[[#All],[Risk Name]],CHAR(10))","v":""}]
[null,null,null,null,"1- Insignificant","2 - Low","3 - Medium","4 - High","5 - High"]
[null,null,null,null,"Impact"]

{"sheet":"Metrics","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Qualitative Risk Analysis Metrics"]
["Rating","Probability","Description"]
[1,"Very Low","High unlikely to occur."]
[2,"Low","Most likely will not occur"]
[3,"Moderate","Possible to occur."]
[4,"High","Likely to occur."]
[5,"Very High","Highly likely to occur."]
["Rating","Impact","Project Duration"]
[1,"Very Low","No change in project timeline"]
[2,"Low","< 5% Increase in project timeline"]
[3,"Moderate","11-15% Increase in project timeline"]
[4,"High","16-20% Increase in project timeline"]
[5,"Very High","> 20% Increase in project t imeline"]

{"sheet":"Risk Occurued","index":5,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["ID#","WBS Task Affected","Risk Name","Description of Risk","Risk Associated","Residual","Secondary Risk Associate"]
["R5","1.4  3.1.8","Insufficient Data Collection ","Surveys will be sent out to personnel, do not collect enough data to analyze","Time","Reflect on Execution"," None "]
[]
["Likelihood","Impact","Risk Level","Specific actions to be taken for Response","Response Type","Level After","Priority","Owner"]
[3,5,15,"publish and promote site surveys to the social media Republish Survey to target audience","Mitigate Accepted",11,5,"Joel Jacobson (Project Manager)"]
[]
["Original est Duration","Original Cost","Est Impact on Duration","Est Additional Cost","Risk Occurred?","New Duration","Final Cost"]
[7," $        -   ",7," $                -   ","No Yes",10," $           -   "]
[]
["R5 Changes and updates after occurrence:"]
[]
["WBS Affected: WBS 3.1.8 Layout Creation"]
["No Secondary Risk occurred."]
["Response Type: changed to Accepted"]
["Action Taken: same re-send to the remaining target person to be completed."]
["Impact Duration: from 7 days changed to 10 days. (based on 4 hrs. per day)"]
["Tasks Remaining: All remaining task on Execution became on a critical trend path."]
["System Change Request: 1 occurrence, new Request to make adjustment to Project Scope/Schedule and sent to stakeholder for approval Additional 10 minutes were added to 4 hrs. per day to the resource to keep project back on track."]
["Risk Register: Risk Updated on risk register and other supporting documents as schedule, scope, PMP"]