{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Improvement Matrix","Ratings","Example","Sheet4","Sheet6","Sheet7","Sheet8","Sheet9","Sheet10","Sheet11","Sheet12","Sheet13","Sheet14","Sheet15","Sheet16"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"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":"Instructions","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions"]
[]
[null,"1)","Check the page Headers, Footers & Title to make sure your name and other information are correct."]
[]
[null,"2)","Enter into the Root Cause row the verified root causes."]
[]
[null,"3)","In the Root Cause row, input the relative importance of the X to the business."]
[]
[null,"4)","List your potential improvements in the Potential Improvements column."]
[]
[null,"5)","Using the Ratings sheet, select appropriate ratings for Impact, Cost & Risk columns."]
[]
[null,"6)","Finally, press the Rank button. This sorts the data by order of rank, and updates the"]
[null,null,"process date in the footer & sheet"]
[]
[null,"6)","Hide rows & columns that are empty."]

{"sheet":"Improvement Matrix","index":1,"n_rows":58,"n_cols":23,"rows_kept":58,"cut":false,"hidden":false,"merged":[[5,18,7,18],[5,19,7,19],[5,20,7,20],[2,21,2,22],[2,1,2,20]]}
[]
[]
[null,"Solution Selection Matrix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-11-11"}]
[]
[null,null,1,2,3,4,5,6,null,null,null,null,null,null,null,null,null,7,8,9,10]
[null,"Root Causes (Xs)▼",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall Impact Rating","Risk Rating","Cost To Implement Rating"]
[null,"Root Cause Significance Rating ► "]
[null,"Potential Improvements ▼","Impact Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall","Rank"]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C9:R9)","v":0},null,null,{"$f":"S9*T9*U9","v":0},{"$f":"IF(V9=0,\"\",RANK(V9,$V$9:$V$58,0))","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C10:R10)","v":0},null,null,0,""]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C11:R11)","v":0},null,null,0,""]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C12:R12)","v":0},null,null,0,""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C13:R13)","v":0},null,null,0,""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C14:R14)","v":0},null,null,0,""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C15:R15)","v":0},null,null,0,""]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C16:R16)","v":0},null,null,0,""]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C17:R17)","v":0},null,null,0,""]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C18:R18)","v":0},null,null,0,""]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C19:R19)","v":0},null,null,0,""]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C20:R20)","v":0},null,null,0,""]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C21:R21)","v":0},null,null,0,""]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C22:R22)","v":0},null,null,0,""]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C23:R23)","v":0},null,null,0,""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C24:R24)","v":0},null,null,0,""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C25:R25)","v":0},null,null,0,""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C26:R26)","v":0},null,null,0,""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C27:R27)","v":0},null,null,0,""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C28:R28)","v":0},null,null,0,""]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"Ratings","index":2,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2]]}
["IMPACT RATING"]
[7,"Improvement permanently removes the X from the process","Elimination of Step / Input"]
[6,"Improvement will permanently monitor the condition that negatively impacts X","Monitoring / Flagging"]
[5,"Improvement will prevent defects caused by variation of X in process","Automation / Standardization / Performance Metrics"]
[4,"Improvement will prevent defects produced by X from being passed on but will not prevent occurrence","Inspection"]
[3,"Improvement will move the impact of X to area with better control the impact of the X","Movement of Work"]
[2,"Improvement will have a temporary positive impact on the defects produced by X but success dependent on people","Training"]
[1,"Impact will make those responsible for X aware of the defects resulting from X ","Send a Letter"]
[0,"Improvement has no effect on  X"]
[]
["COST TO IMPLEMENT RATINGS"]
[7,"Cost of improvement is negligible- there are no incremental recurring expenses, no capital investment"]
[6,"Cost of improvement is comprised completely of one time expenses - no capital investment, no incremental recurring expenses"]
[5,"Cost of improvement is comprised of one time expenses and some incremental recurring expenses, no capital investment"]
[4,"Cost of improvement is comprised of one time expenses, some incremental expenses, small amount of capital investment"]
[3,"Cost of improvement involves moderate capital investment, and is in alignment with strategic goals of business"]
[2,"Cost of improvement involves significant capital investment, and is in alignment with strategic goals of business"]
[1,"Cost of improvement involves moderate capital investment, and is not in alignment with strategic goals of business"]
[0,"Cost of improvement involves significant capital investment,  and is not in alignment with strategic goals of business"]
[]
["RISK RATINGS"]
[7,"No new technology, Implementation time < 1 month- few timing/political/ cultural constraints"]
[6,"No new technology, Implementation time is between 1-3 months - few timing/political/ cultural constraints"]
[5,"No new technology, Implementation time > 3 months - few timing/political/ cultural constraints"]
[4,"No new technology, Implementation time < 3 months - moderate amount of timing/political/ cultural constraints"]
[3,"No new technology, Implementation time > 3 months - moderate amount of timing/political/ cultural constraints"]
[2,"New technology, Implementation time < 3 months - many timing/political/cultural constraints"]
[1,"New technology, Implementation time is between 3-6 months - many timing/political/ cultural constraints"]
[0,"New technology, Technical Time greater than 6 months - many timing, political and cultural constraints"]

{"sheet":"Example","index":3,"n_rows":58,"n_cols":23,"rows_kept":58,"cut":false,"hidden":false,"merged":[[5,18,7,18],[5,19,7,19],[5,20,7,20],[2,21,2,22]]}
[null,"Bechtel Six Sigma"]
[]
[null,"Solution Selection Matrix",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2006-09-06"]
[]
[null,null,1,2,3,4,5,6,null,null,null,null,null,null,null,null,null,7,8,9,10]
[null,"Root Causes (Xs)▼","Time to Issue Invoice","Complete","Accuracy","Presentation","Per Commercial Terms","Level of Effort",null,null,null,null,null,null,null,null,null,null,"Overall Impact Rating","Risk Rating","Cost To Implement Rating"]
[null,"Root Cause Significance Rating ► ",10,10,10,10,10,10]
[null,"Potential Improvements ▼","Impact Rating",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Overall","Rank"]
[1,"Offshore Costs",7,1,5,8,1,10,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C9:R9)","v":320},8,6,{"$f":"S9*T9*U9","v":15360},{"$f":"IF(V9=0,\"\",RANK(V9,$V$9:$V$58,0))","v":1}]
[2,"Commercial Terms",8,4,2,5,10,7,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C10:R10)","v":360},7,5,12600,2]
[3,"Quantity of Source Data",8,5,7,7,1,10,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C11:R11)","v":380},6,4,9120,3]
[4,"Reconciliation",10,10,10,1,10,10,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C12:R12)","v":510},6,2,6120,4]
[5,"Quality of Source Data",7,7,7,7,7,7,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C13:R13)","v":420},7,2,5880,5]
[6,"Training",8,7,10,5,8,10,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C14:R14)","v":480},6,2,5760,6]
[7,"Client (eg RCTI)",6,2,2,10,8,8,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C15:R15)","v":360},5,3,5400,7]
[8,"Job Setup",10,4,10,6,10,10,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C16:R16)","v":500},5,2,5000,8]
[9,"Payroll Close Date",8,10,1,1,1,8,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C17:R17)","v":290},8,2,4640,9]
[10,"Pre-Billing",10,8,6,8,2,10,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C18:R18)","v":440},5,2,4400,10]
[11,"Client Reporting Requirements",7,9,4,10,10,10,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C19:R19)","v":500},4,2,4000,11]
[12,"Delivery Method",9,1,1,5,5,7,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C20:R20)","v":280},9,1,2520,12]
[13,"Job Completion",7,10,1,7,5,10,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C21:R21)","v":400},3,2,2400,13]
[14,"Job Manager Requirements",9,7,5,4,8,9,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C22:R22)","v":420},2,1,840,14]
[15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C23:R23)","v":0},null,null,0,""]
[16,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C24:R24)","v":0},null,null,0,""]
[17,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C25:R25)","v":0},null,null,0,""]
[18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C26:R26)","v":0},null,null,0,""]
[19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C27:R27)","v":0},null,null,0,""]
[20,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM($C$7:$R$7*C28:R28)","v":0},null,null,0,""]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"Sheet4","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet6","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet7","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet8","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet9","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet10","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet11","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet12","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet13","index":12,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet14","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet15","index":14,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet16","index":15,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}