{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Template_Inverted","Contents","Overview","VersionControl","I_Settings","I_Processes","C_Scoring","C_Complexity","C_Benefits","C_Ratings","C_Financials","O_Matrix","O_Financials"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":35,"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":"Template_Inverted","index":0,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"Template_Inverted"}]

{"sheet":"Contents","index":1,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"Contents"}]
[null,null,null,null,null,null,null,null,"Use the buttons below to navigate to the respective worksheets"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"// End of sheet"]

{"sheet":"Overview","index":2,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":false,"merged":[[5,2,5,10],[14,2,14,10],[8,2,8,10],[7,2,7,10],[10,2,10,10],[11,2,11,10],[13,2,13,10]]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"Overview"}]
[]
[]
[]
[null,null,"Please refer to the full guidance document located here."]
[]
[null,null,"Purpose"]
[null,null,"The process evaluation tool has been designed to offer guidance to NHS organisations in determining the potential net benefits from using RPA to automate a business process. The tool calculates the potential complexity to automate a process versus its potential benefits."]
[]
[null,null,"How it works"]
[null,null,"The tool centres around two input sheets, I_Settings and I_Processes which ask the user a number of questions about an existing process. From these questions, the tool determines the amount of development time required to achieve automation. This drives a complexity rating. A benefits rating is determined by further questions and uses the scoring in the C_Scoring sheet to weight the outcome."]
[]
[null,null,"Tool outputs"]
[null,null,"The tool uses the answers given by the user in I_Processes to populate the two output sheets, O_Ratings and O_Financials. The two sheets display the matrix of complxity vs benefits and the NPVs of automating the processes, respectively."]
[]
[null,"// End of sheet"]

{"sheet":"VersionControl","index":3,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"VersionControl"}]
[]
[]
[]
[null,null,"VERSION CONTROL TABLE"]
[null,null,"#","Version","Timestamp","Committer","Description"]
[null,null,1,1,"2018-10-04T18:27:33.010","Oli Morris","Finalised first release"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"// End of sheet"]

{"sheet":"I_Settings","index":4,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"I_Settings"}]
[]
[]
[]
[null,"Settings"]
[]
[null,null,"Include the \"Example process\"?"]
[]
[null,null,"Working hours per day",7.5]
[null,null,"Working days per year",{"$f":"(5*52)-8-27","v":225}]
[]
[null,null,"Virtual Worker to human FTE equivalent",8]
[null,null,"Developer cost per day (-ve)",-600]
[]
[null,null,"Data sizes (rows) - Memo","< 500"]
[null,null,null,"500-2,500"]
[null,null,null,"2,500+"]
[]
[null,"// End of sheet"]

{"sheet":"I_Processes","index":5,"n_rows":80,"n_cols":6,"rows_kept":80,"cut":false,"hidden":false,"merged":[[74,1,77,1],[52,1,55,1],[60,1,72,1],[15,1,20,1],[22,1,27,1],[32,1,50,1]]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"I_Processes"}]
[]
[]
[]
[null,2,null,null,1,{"$f":"E6+1","v":2}]
[]
[null,"Process definition"]
[]
[null,null,"Process name",null,"Example process"]
[null,null,"Description",null,"An example process"]
[]
[null,"Process outline"]
[]
[null,null,null,null,{"$f":"IF(E10=\"\",\"Untitled\",E10)","v":"Example process"},{"$f":"IF(F10=\"\",\"Untitled\",F10)","v":"Untitled"}]
[null,"Input","% of process that can be automated",null,0.85]
[null,null,"Time taken to complete single process (hours)",null,{"$f":"5/60","v":8.3333333333333329E-2}]
[null,null,"Times process is completed per year",null,80000]
[null,null,"FTEs involved in process","i",8]
[null,null,"Cost per FTE (per year) (-ve)",null,-30000]
[null,null,"Non pay costs (per year) (-ve)",null,-15000]
[]
[null,"Output","Productivity saved per year (hours)",null,{"$f":"E18*E17*E16","v":5666.6666666666661},{"$f":"F18*F17*F16","v":0}]
[null,null,"Productivity saved per year (cost)",null,{"$f":"ABS(E23*(E20/(Settings_WorkingDays*Settings_WorkingHours)))","v":100740.74074074073},{"$f":"ABS(F23*(F20/(Settings_WorkingDays*Settings_WorkingHours)))","v":0}]
[null,null,"Virtual Worker licences required",null,{"$f":"IFERROR(ROUNDUP(E19/Settings_VirtualWorkerFTE,0),0)","v":1},{"$f":"IFERROR(ROUNDUP(F19/Settings_VirtualWorkerFTE,0),0)","v":0}]
[null,null,"FTE utilisation",null,{"$f":"IFERROR((E17*E18)/(E19*Settings_WorkingHours*Settings_WorkingDays),0)","v":0.49382716049382713},{"$f":"IFERROR((F17*F18)/(F19*Settings_WorkingHours*Settings_WorkingDays),0)","v":0}]
[null,null,"FTEs to retain after automation",null,{"$f":"ROUNDUP((E19-E16*E19)*E26,0)","v":1},{"$f":"ROUNDUP((F19-F16*F19)*F26,0)","v":0}]
[null,null,"FTE costs saved (per year)",null,{"$f":"ABS((E19-E27)*E20)","v":210000},{"$f":"ABS((F19-F27)*F20)","v":0}]
[]
[null,"Process complexity"]
[]
[null,null,null,null,{"$f":"E$15","v":"Example process"},{"$f":"F$15","v":"Untitled"}]
[null,"Input","Number of applications involved"]
[null,null,"Simple application","i",2]
[null,null,"Complex application","i",2]
[null,null,"Citrix application","i",0]
[]
[null,null,"Number of screens involved","i"]
[null,null,"Simple application",null,6]
[null,null,"Complex application",null,1]
[null,null,"Citrix application",null,0]
[]
[null,null,"Data processing","i"]
[null,null,"Simple","i",3]
[null,null,"Complex","i",1]
[]
[null,null,"Business logic","i"]
[null,null,"Simple","i",1]
[null,null,"Complex","i",1]
[]
[null,null,"Data size (records/rows)","i","< 500"]
[]
[null,"Output","Estimated development effort - Low",null,{"$f":"ROUNDUP(C_Complexity!E35,0)","v":25},{"$f":"ROUNDUP(C_Complexity!F35,0)","v":0}]
[null,null,"Estimated development effort - High",null,{"$f":"ROUNDUP(C_Complexity!E36,0)","v":43},{"$f":"ROUNDUP(C_Complexity!F36,0)","v":0}]
[null,null,"Estimated development cost - Low",null,{"$f":"ROUNDUP(E53*Settings_DeveloperCost,-2)","v":-15000},0]
[null,null,"Estimated development cost - High",null,-25800,0]
[]
[null,"Process benefits and costs"]
[]
[null,null,null,null,{"$f":"E$15","v":"Example process"},{"$f":"F$15","v":"Untitled"}]
[null,"Input","Benefits (+ve)",null,{"$f":"E28","v":210000}]
[]
[null,null,"Project costs - Non-recurrent (-ve)"]
[null,null,"RPA development",null,{"$f":"E56","v":-25800}]
[null,null,"PMO",null,-1000]
[null,null,"Training",null,0]
[null,null,"Other",null,0]
[]
[null,null,"Ongoing costs (-ve)"]
[null,null,"RPA licences",null,{"$f":"-8000*E25","v":-8000}]
[null,null,"Cloud hosting",null,-2000]
[null,null,"Maintenance and support",null,{"$f":"-500*5","v":-2500}]
[null,null,"Other"]
[]
[null,"Output","Year One Gain/(Loss)",null,{"$f":"SUM(E61,E64:E67,E70:E73)","v":170700},{"$f":"SUM(F61,F64:F67,F70:F73)","v":0}]
[null,null,"Benefit as % of existing costs",null,{"$f":"IFERROR(E75/-(E19*E20+E21),0)","v":0.66941176470588237},{"$f":"IFERROR(F75/-(F19*F20+F21),0)","v":0}]
[null,null,"Payback period",null,{"$f":"IFERROR(ROUNDUP(-SUM(E64:E67)/((E61+SUM(E70:E73))/12),0),0)","v":2},{"$f":"IFERROR(ROUNDUP(-SUM(F64:F67)/((F61+SUM(F70:F73))/12),0),0)","v":0}]
[null,null,"Ongoing Cost : Benefit ratio",null,{"$f":"IFERROR(E61/-SUM(E70:E73),1)","v":16.8},{"$f":"IFERROR(F61/-SUM(F70:F73),0)","v":0}]
[]
[null,"// End of sheet"]

{"sheet":"C_Scoring","index":6,"n_rows":80,"n_cols":6,"rows_kept":80,"cut":false,"hidden":false,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"C_Scoring"}]
[]
[]
[]
[null,"Weights"]
[]
[null,null,"Input",null,null,"Weight"]
[]
[null,null,"Number of applications involved"]
[null,null,"Simple applications",null,null,1]
[null,null,"Complex applications",null,null,1.5]
[null,null,"Citrix applications",null,null,3]
[]
[null,null,"Data processing"]
[null,null,"Simple",null,null,0.2]
[null,null,"Complex",null,null,1]
[]
[null,null,"Business logic"]
[null,null,"Simple",null,null,0.2]
[null,null,"Complex",null,null,1]
[]
[null,null,"Error handling",null,null,0.2]
[null,null,"Safety multiplier",null,null,1]
[]
[null,null,"Output"]
[]
[null,null,"Benefits as % of existing costs",null,null,2]
[null,null,"Payback period (months)",null,null,5]
[null,null,"Ongoing cost : Benefit ratio",null,null,1]
[]
[null,"Scores"]
[]
[null,null,"Input","Lower Threshold","Upper Threshold","Score"]
[]
[null,null,"Simple screens involved",1,5,0.5]
[null,null,"Simple screens involved",6,10,1]
[null,null,"Simple screens involved",11,10000,3]
[]
[null,null,"Complex screens involved",1,5,1]
[null,null,"Complex screens involved",6,10,2.5]
[null,null,"Complex screens involved",11,10000,5]
[]
[null,null,"Citrix screens involved",1,5,1.5]
[null,null,"Citrix screens involved",6,10,5]
[null,null,"Citrix screens involved",11,10000,10]
[]
[null,null,"Data size",null,{"$f":"INDEX(Settings_DataSizes,1)","v":"< 500"},0.33]
[null,null,"Data size",null,{"$f":"INDEX(Settings_DataSizes,2)","v":"500-2,500"},0.5]
[null,null,"Data size",null,{"$f":"INDEX(Settings_DataSizes,3)","v":"2,500+"},0.7]
[]
[null,"Ratings"]
[]
[null,null,null,"Lower Threshold","Upper Threshold","Rating"]
[]
[null,null,"Development effort (days)",null,7,5]
[null,null,"Development effort (days)",{"$f":"E56+0.1","v":7.1},21,4]
[null,null,"Development effort (days)",{"$f":"E57+0.1","v":21.1},{"$f":"E57+21","v":42},3]
[null,null,"Development effort (days)",{"$f":"E58+0.1","v":42.1},{"$f":"E58+14","v":56},2]
[null,null,"Development effort (days)",{"$f":"E59+0.1","v":56.1},1000000,1]
[]
[null,null,"Benefits as % of existing costs",null,0.1,1]
[null,null,"Benefits as % of existing costs",{"$f":"E62+0.001","v":0.10100000000000001},0.3,2]
[null,null,"Benefits as % of existing costs",{"$f":"E63+0.001","v":0.30099999999999999},0.5,3]
[null,null,"Benefits as % of existing costs",{"$f":"E64+0.001","v":0.501},0.75,4]
[null,null,"Benefits as % of existing costs",{"$f":"E65+0.001","v":0.751},10000,5]
[]
[null,null,"Payback period (months)",0,12,5]
[null,null,"Payback period (months)",{"$f":"E68+0.001","v":12.000999999999999},18,4]
[null,null,"Payback period (months)",{"$f":"E69+0.001","v":18.001000000000001},24,3]
[null,null,"Payback period (months)",{"$f":"E70+0.001","v":24.001000000000001},36,2]
[null,null,"Payback period (months)",{"$f":"E71+0.001","v":36.000999999999998},1000000,1]
[]
[null,null,"Ongoing cost : Benefit ratio",null,1,1]
[null,null,"Ongoing cost : Benefit ratio",{"$f":"E74+0.01","v":1.01},4,2]
[null,null,"Ongoing cost : Benefit ratio",{"$f":"E75+0.1","v":4.0999999999999996},8,3]
[null,null,"Ongoing cost : Benefit ratio",{"$f":"E76+0.1","v":8.1},12,4]
[null,null,"Ongoing cost : Benefit ratio",{"$f":"E77+0.1","v":12.1},1000000,5]
[]
[null,"// End of sheet"]

{"sheet":"C_Complexity","index":7,"n_rows":44,"n_cols":6,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"C_Complexity"}]
[]
[]
[]
[null,"Complexity with automating the process"]
[]
[null,null,"Index",null,{"$f":"I_Processes!E$6","v":1},{"$f":"I_Processes!F$6","v":2}]
[]
[null,null,null,null,{"$f":"I_Processes!E15","v":"Example process"},{"$f":"I_Processes!F15","v":"Untitled"}]
[null,null,"Number of applications involved"]
[null,null,"Simple application",1,{"$f":"IFERROR(INDEX(Process_AppsInvolved,$D12,E$8)*C_Scoring!$F11,0)","v":2},{"$f":"IFERROR(INDEX(Process_AppsInvolved,$D12,F$8)*C_Scoring!$F11,0)","v":0}]
[null,null,"Complex application",2,{"$f":"IFERROR(INDEX(Process_AppsInvolved,$D13,E$8)*C_Scoring!$F12,0)","v":3},{"$f":"IFERROR(INDEX(Process_AppsInvolved,$D13,F$8)*C_Scoring!$F12,0)","v":0}]
[null,null,"Citrix application",3,{"$f":"IFERROR(INDEX(Process_AppsInvolved,$D14,E$8)*C_Scoring!$F13,0)","v":0},{"$f":"IFERROR(INDEX(Process_AppsInvolved,$D14,F$8)*C_Scoring!$F13,0)","v":0}]
[]
[null,null,"Number of screens involved"]
[null,null,"Simple application",1,{"$f":"IFERROR(INDEX(Process_ScreensInvolved,$D17,E$8)*LOOKUP(2,1/((INDEX(Process_ScreensInvolved,$D17,E$8)>=C_Scoring!$D36:$D38)*(INDEX(Process_ScreensInvolved,$D17,E$8)<=C_Scoring!$E36:$E38)),C_Scoring!$F36:$F38),0)","v":6},{"$f":"IFERROR(INDEX(Process_ScreensInvolved,$D17,F$8)*LOOKUP(2,1/((INDEX(Process_ScreensInvolved,$D17,F$8)>=C_Scoring!$D36:$D38)*(INDEX(Process_ScreensInvolved,$D17,F$8)<=C_Scoring!$E36:$E38)),C_Scoring!$F36:$F38),0)","v":0}]
[null,null,"Complex application",2,{"$f":"IFERROR(INDEX(Process_ScreensInvolved,$D18,E$8)*LOOKUP(2,1/((INDEX(Process_ScreensInvolved,$D18,E$8)>=C_Scoring!$D40:$D42)*(INDEX(Process_ScreensInvolved,$D18,E$8)<=C_Scoring!$E40:$E42)),C_Scoring!$F40:$F42),0)","v":1},{"$f":"IFERROR(INDEX(Process_ScreensInvolved,$D18,F$8)*LOOKUP(2,1/((INDEX(Process_ScreensInvolved,$D18,F$8)>=C_Scoring!$D40:$D42)*(INDEX(Process_ScreensInvolved,$D18,F$8)<=C_Scoring!$E40:$E42)),C_Scoring!$F40:$F42),0)","v":0}]
[null,null,"Citrix application",3,{"$f":"IFERROR(INDEX(Process_ScreensInvolved,$D19,E$8)*LOOKUP(2,1/((INDEX(Process_ScreensInvolved,$D19,E$8)>=C_Scoring!$D44:$D46)*(INDEX(Process_ScreensInvolved,$D19,E$8)<=C_Scoring!$E44:$E46)),C_Scoring!$F44:$F46),0)","v":0},{"$f":"IFERROR(INDEX(Process_ScreensInvolved,$D19,F$8)*LOOKUP(2,1/((INDEX(Process_ScreensInvolved,$D19,F$8)>=C_Scoring!$D44:$D46)*(INDEX(Process_ScreensInvolved,$D19,F$8)<=C_Scoring!$E44:$E46)),C_Scoring!$F44:$F46),0)","v":0}]
[]
[null,null,"Data processing"]
[null,null,"Simple",1,{"$f":"IFERROR(INDEX(Process_DataProcessing,$D22,E$8)*C_Scoring!$F16+INDEX(C_Scoring!$F$48:$F$50,MATCH(INDEX(Process_DataSize,,1),C_Scoring!$E$48:$E$50,0))*SUM(E$12:E$14)/SUM(E$12:E$14),0)","v":0.93000000000000016},{"$f":"IFERROR(INDEX(Process_DataProcessing,$D22,F$8)*C_Scoring!$F16+INDEX(C_Scoring!$F$48:$F$50,MATCH(INDEX(Process_DataSize,,1),C_Scoring!$E$48:$E$50,0))*SUM(F$12:F$14)/SUM(F$12:F$14),0)","v":0}]
[null,null,"Complex",2,{"$f":"IFERROR(INDEX(Process_DataProcessing,$D23,E$8)*C_Scoring!$F17+INDEX(C_Scoring!$F$48:$F$50,MATCH(INDEX(Process_DataSize,,1),C_Scoring!$E$48:$E$50,0))*SUM(E$12:E$14)/SUM(E$12:E$14),0)","v":1.33},{"$f":"IFERROR(INDEX(Process_DataProcessing,$D23,F$8)*C_Scoring!$F17+INDEX(C_Scoring!$F$48:$F$50,MATCH(INDEX(Process_DataSize,,1),C_Scoring!$E$48:$E$50,0))*SUM(F$12:F$14)/SUM(F$12:F$14),0)","v":0}]
[]
[null,null,"Business logic"]
[null,null,"Simple",1,{"$f":"IFERROR(INDEX(Process_BusinessLogic,$D26,E$8)*C_Scoring!$F20,0)","v":0.2},{"$f":"IFERROR(INDEX(Process_BusinessLogic,$D26,F$8)*C_Scoring!$F20,0)","v":0}]
[null,null,"Complex",2,{"$f":"IFERROR(INDEX(Process_BusinessLogic,$D27,E$8)*C_Scoring!$F21,0)","v":1},{"$f":"IFERROR(INDEX(Process_BusinessLogic,$D27,F$8)*C_Scoring!$F21,0)","v":0}]
[]
[null,null,"Screen cost",null,{"$f":"IFERROR(SUM(INDEX(Process_ScreensInvolved,,E$8)),0)","v":7},{"$f":"IFERROR(SUM(INDEX(Process_ScreensInvolved,,F$8)),0)","v":0}]
[null,null,"Error handling",null,{"$f":"IFERROR(E29*C_Scoring!$F$23,0)","v":1.4000000000000001},{"$f":"IFERROR(F29*C_Scoring!$F$23,0)","v":0}]
[null,null,"Safety multiplier",null,{"$f":"IFERROR(C_Scoring!$F$24*SUM(E$12:E$14)/SUM(E$12:E$14),0)","v":1},{"$f":"IFERROR(C_Scoring!$F$24*SUM(F$12:F$14)/SUM(F$12:F$14),0)","v":0}]
[]
[null,null,"Data size - impact on testing",null,{"$f":"IFERROR((1+INDEX(C_Scoring!$F$48:$F$50,MATCH(INDEX(Process_DataSize,,E$8),C_Scoring!$E$48:$E$50,0)))*SUM(E22:E23)*SUM(E26:E27)*SUM(E12:E14),0)","v":18.034800000000001},{"$f":"IFERROR((1+INDEX(C_Scoring!$F$48:$F$50,MATCH(INDEX(Process_DataSize,,F$8),C_Scoring!$E$48:$E$50,0)))*SUM(F22:F23)*SUM(F26:F27)*SUM(F12:F14),0)","v":0}]
[]
[null,null,"Estimated development effort - Low",null,{"$f":"SUM(E12:E31)","v":24.86},{"$f":"SUM(F12:F31)","v":0}]
[null,null,"Estimated development effort - High",null,{"$f":"E33+E35","v":42.894800000000004},{"$f":"F33+F35","v":0}]
[]
[null,null,"Estimated development effort - Median",null,{"$f":"IFERROR(MEDIAN(E35:E36),0)","v":33.877400000000002},{"$f":"IFERROR(MEDIAN(F35:F36),0)","v":0}]
[null,null,"Base rating",null,{"$f":"IFERROR(IF(OR(E35=0,E36=0),0,LOOKUP(2,1/((E38>=C_Scoring!$D$56:$D$60)*(E38<=C_Scoring!$E$56:$E$60)),C_Scoring!$F$56:$F$60)),1)","v":3},{"$f":"IFERROR(IF(OR(F35=0,F36=0),0,LOOKUP(2,1/((F38>=C_Scoring!$D$56:$D$60)*(F38<=C_Scoring!$E$56:$E$60)),C_Scoring!$F$56:$F$60)),1)","v":0}]
[null,null,"Lower threshold",null,{"$f":"IFERROR(INDEX(C_Scoring!$D$56:$D$60,MATCH(C_Complexity!E39,C_Scoring!$F$56:$F$60,0)),0)","v":21.1},{"$f":"IFERROR(INDEX(C_Scoring!$D$56:$D$60,MATCH(C_Complexity!F39,C_Scoring!$F$56:$F$60,0)),0)","v":0}]
[null,null,"Max threshold",null,{"$f":"IFERROR(INDEX(C_Scoring!$E$56:$E$60,MATCH(C_Complexity!E39,C_Scoring!$F$56:$F$60,0)),0)","v":42},{"$f":"IFERROR(INDEX(C_Scoring!$E$56:$E$60,MATCH(C_Complexity!F39,C_Scoring!$F$56:$F$60,0)),0)","v":0}]
[null,null,"Complexity/Ease of Automation rating",null,{"$f":"IFERROR(E39+E40/E38,1)","v":3.6228341017905743},{"$f":"IFERROR(F39+F40/F38,1)","v":1}]
[]
[null,"// End of sheet"]

{"sheet":"C_Benefits","index":8,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"C_Benefits"}]
[]
[]
[]
[null,"Benefits from automating the process"]
[]
[null,null,"Index",null,{"$f":"I_Processes!E$6","v":1},{"$f":"I_Processes!F$6","v":2}]
[]
[null,null,null,"Row",{"$f":"I_Processes!E15","v":"Example process"},{"$f":"I_Processes!F15","v":"Untitled"}]
[null,null,"Benefits as % of existing costs"]
[null,null,"Weight",null,{"$f":"C_Scoring!$F$28","v":2},{"$f":"C_Scoring!$F$28","v":2}]
[null,null,"Score",2,{"$f":"IFERROR(LOOKUP(2,1/((INDEX(Process_Benefits,$D13,E$8)>=C_Scoring!$D$62:$D$66)*(INDEX(Process_Benefits,$D13,E$8)<=C_Scoring!$E$62:$E$66)),C_Scoring!$F$62:$F$66),1)","v":4},{"$f":"IFERROR(LOOKUP(2,1/((INDEX(Process_Benefits,$D13,F$8)>=C_Scoring!$D$62:$D$66)*(INDEX(Process_Benefits,$D13,F$8)<=C_Scoring!$E$62:$E$66)),C_Scoring!$F$62:$F$66),1)","v":1}]
[]
[null,null,"Payback period (months)"]
[null,null,"Weight",null,{"$f":"C_Scoring!$F$29","v":5},{"$f":"C_Scoring!$F$29","v":5}]
[null,null,"Score",3,{"$f":"IF(INDEX(Process_Benefits,$D17,E$8)=0,1,IFERROR(LOOKUP(2,1/((INDEX(Process_Benefits,$D17,E$8)>=C_Scoring!$D$68:$D$72)*(INDEX(Process_Benefits,$D17,E$8)<=C_Scoring!$E$68:$E$72)),C_Scoring!$F$68:$F$72),1))","v":5},{"$f":"IF(INDEX(Process_Benefits,$D17,F$8)=0,1,IFERROR(LOOKUP(2,1/((INDEX(Process_Benefits,$D17,F$8)>=C_Scoring!$D$68:$D$72)*(INDEX(Process_Benefits,$D17,F$8)<=C_Scoring!$E$68:$E$72)),C_Scoring!$F$68:$F$72),1))","v":1}]
[]
[null,null,"Ongoing cost : Benefit ratio"]
[null,null,"Weight",null,{"$f":"C_Scoring!$F$30","v":1},{"$f":"C_Scoring!$F$30","v":1}]
[null,null,"Score",4,{"$f":"LOOKUP(2,1/((INDEX(Process_Benefits,$D21,E$8)>=C_Scoring!$D$74:$D$78)*(INDEX(Process_Benefits,$D21,E$8)<=C_Scoring!$E$74:$E$78)),C_Scoring!$F$74:$F$78)","v":5},{"$f":"LOOKUP(2,1/((INDEX(Process_Benefits,$D21,F$8)>=C_Scoring!$D$74:$D$78)*(INDEX(Process_Benefits,$D21,F$8)<=C_Scoring!$E$74:$E$78)),C_Scoring!$F$74:$F$78)","v":1}]
[]
[null,null,"Weight",null,{"$f":"E12+E16+E20","v":8},{"$f":"F12+F16+F20","v":8}]
[null,null,"Total score available",null,{"$f":"E12*E13+E16*E17+E20*E21","v":38},{"$f":"F12*F13+F16*F17+F20*F21","v":8}]
[null,null,"Benefits rating",null,{"$f":"IFERROR(MAX(E24/E23,1),1)","v":4.75},{"$f":"IFERROR(MAX(F24/F23,1),1)","v":1}]
[]
[null,"// End of sheet"]

{"sheet":"C_Ratings","index":9,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"C_Ratings"}]
[]
[]
[]
[null,"Benefits from automating the process"]
[]
[null,null,"#","Process","Complexity","Benefits"]
[null,null,1,{"$f":"INDEX(Process_Processes,1,$C9)","v":"Example process"},{"$f":"INDEX(App_OutputComplexity,,$C9)","v":3.6228341017905743},{"$f":"INDEX(App_OutputBenefits,,$C9)","v":4.75}]
[null,null,{"$f":"C9+1","v":2},{"$f":"INDEX(Process_Processes,1,$C10)","v":"Untitled"},{"$f":"INDEX(App_OutputComplexity,,$C10)","v":1},{"$f":"INDEX(App_OutputBenefits,,$C10)","v":1}]

{"sheet":"C_Financials","index":10,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"C_Financials"}]
[]
[]
[]
[null,"Financial benefits from automation"]
[]
[null,null,"Index",null,{"$f":"I_Processes!E$6","v":1},{"$f":"I_Processes!F$6","v":2}]
[]
[null,null,null,"Row",{"$f":"I_Processes!E15","v":"Example process"},{"$f":"I_Processes!F15","v":"Untitled"}]
[null,null,"RPA development",4,{"$f":"INDEX(Process_Financials,$D11,E$8)","v":-25800},0]
[null,null,"PMO",5,-1000,0]
[null,null,"Training",6,0,0]
[null,null,"Other",7,0,0]
[null,null,"Total project costs",null,{"$f":"SUM(E11:E14)","v":-26800},{"$f":"SUM(F11:F14)","v":0}]
[]
[null,null,"Benefits",1,{"$f":"INDEX(Process_Financials,$D17,E$8)","v":210000},{"$f":"INDEX(Process_Financials,$D17,F$8)","v":0}]
[]
[null,null,"RPA licences",10,{"$f":"INDEX(Process_Financials,$D19,E$8)","v":-8000},0]
[null,null,"Cloud hosting",11,-2000,0]
[null,null,"Maintenance and support",12,-2500,0]
[null,null,"Other",13,0,0]
[null,null,"Total ongoing costs",null,{"$f":"SUM(E19:E22)","v":-12500},{"$f":"SUM(F19:F22)","v":0}]
[]
[null,"// End of sheet"]

{"sheet":"O_Matrix","index":11,"n_rows":35,"n_cols":2,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"O_Matrix"}]
[]
[]
[]
[]
[]
[null,"Ease of automation vs benefits of automation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"// End of sheet"]

{"sheet":"O_Financials","index":12,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[{"$f":"UPPER(MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\"]\",CELL(\"filename\",A1))-FIND(\"[\",CELL(\"filename\",A1))-6))","v":"RPA PROCESS EVALUATION TOOL_V1.0"}]
[{"$f":"MID(CELL(\"filename\",B2),FIND(\"]\",CELL(\"filename\",B2))+1,LEN(CELL(\"filename\",B2)))","v":"O_Financials"}]
[]
[]
[]
[null,"Financial benefits from automation"]
[]
[null,null,"Cost of capital",3.5000000000000003E-2]
[]
[null,null,"All processes"]
[]
[null,null,null,"Year 0","Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Project costs",{"$f":"SUM(Financials_ProjectCosts)","v":-26800}]
[null,null,"Benefits",null,{"$f":"SUM(Financials_Benefits)","v":210000},{"$f":"E14","v":210000},{"$f":"F14","v":210000},210000,210000]
[null,null,"Ongoing costs",null,{"$f":"SUM(Financials_OngoingCosts)","v":-12500},{"$f":"E15","v":-12500},{"$f":"F15","v":-12500},-12500,-12500]
[null,null,"Net impact - Profit/(Loss)",{"$f":"SUM(D13:D15)","v":-26800},{"$f":"SUM(E13:E15)","v":197500},197500,197500,197500,197500]
[]
[null,null,"NPV",null,{"$f":"NPV(CostofCapital,E16)","v":190821.25603864735},{"$f":"NPV(CostofCapital,E16,F16)","v":375189.61936101201},{"$f":"NPV(CostofCapital,E16,F16,G16)","v":553323.30373044638},{"$f":"NPV(CostofCapital,E16,F16,G16,H16)","v":725433.14370091446},{"$f":"NPV(CostofCapital,E16,F16,G16,H16,I16)","v":891722.84415547294}]
[null,null,"ROI %",null,{"$f":"IFERROR(E18/-$D$16,0)","v":7.1201961208450504},{"$f":"IFERROR(F18/-$D$16,0)","v":13.99961266272433},20.646391930240537,27.068400884362479,33.273240453562423]
[]
[null,null,"Single process"]
[]
[null,null,"Process","Example process",{"$f":"IFERROR(MATCH(D23,Process_Processes,0),\"\")","v":1}]
[]
[null,null,null,"Year 0","Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,"Project costs",{"$f":"IFERROR(INDEX(Financials_ProjectCosts,,$E$23),0)","v":-26800}]
[null,null,"Benefits",null,{"$f":"IFERROR(INDEX(Financials_Benefits,,$E$23),0)","v":210000},{"$f":"E27","v":210000},{"$f":"F27","v":210000},210000,210000]
[null,null,"Ongoing costs",null,{"$f":"IFERROR(INDEX(Financials_OngoingCosts,,$E$23),0)","v":-12500},{"$f":"E28","v":-12500},{"$f":"F28","v":-12500},-12500,-12500]
[null,null,"Net impact - Profit/(Loss)",{"$f":"SUM(D26:D28)","v":-26800},{"$f":"SUM(E26:E28)","v":197500},{"$f":"SUM(F26:F28)","v":197500},{"$f":"SUM(G26:G28)","v":197500},{"$f":"SUM(H26:H28)","v":197500},{"$f":"SUM(I26:I28)","v":197500}]
[]
[null,null,"NPV",null,{"$f":"NPV(CostofCapital,(E29+D29))","v":164927.53623188406},{"$f":"NPV(CostofCapital,E29+D29,F29)","v":349295.89955424872},{"$f":"NPV(CostofCapital,E29+D29,F29,G29)","v":527429.58392368315},{"$f":"NPV(CostofCapital,E29+D29,F29,G29,H29)","v":699539.42389415111},{"$f":"NPV(CostofCapital,E29+D29,F29,G29,H29,I29)","v":865829.12434870971}]
[null,null,"ROI %",null,{"$f":"IFERROR(E31/-$D$29,0)","v":6.1540125459658235},{"$f":"IFERROR(F31/-$D$29,0)","v":13.033429087845102},19.680208355361312,26.102217309483251,32.307056878683198]
[]
[null,"// End of sheet"]