{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Summary Output TOTAL","Summary Output","Summary Output by BU","Supply","Demand","Faethm Data","Attrition_Template","TOP3 Roles Y5","TOP5 BU Y5"],"not_rendered":{"charts":7,"images":1,"macros":1,"external_links":4,"defined_names":121,"comments":1,"pivot_tables":2},"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":41,"n_cols":5,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Supply and Demand Instructions"]
[]
[null,null,null,"All cells in this input template are locked apart from the coloured cells described below."]
[]
[null,1,null,"You have to click in \"Enable Content\" when opening this Model, so it can run some VBA code properly."]
[]
[null,2,null,"Go to Summary Output tab."]
[null,null,null,"Fill all white fields in the INPUT FORM."]
[null,null,"a.","Company Name"]
[null,null,"b.","Role to be analysed"]
[null,null,"c.","Business Units (BU) with the selected role"]
[null,null,null,"* Total FTEs for the role in each BU."]
[null,null,null,"* Up to 3 Growth drivers % projection for each BU"]
[null,null,"d.","Attrition Rate - you can use the Attrition Template as a base to calculate your rate"]
[null,null,"e.","Retirement Rate - you can use the Attrition Template as a base to calculate your rate"]
[null,null,"f.","Faethm data (Automation and Capacity Gain percentages) to be extracted in Faethm plataform."]
[]
[null,3,null,"Optional"]
[null,null,null,"Fill Attrition_Template blank fields to get your Attrition and retirement rates"]
[]
[null,4,null,"Once all inputs have been completed, check that there are no errors in any sheet by reviewing any red cells in the workforce data tab. "]
[null,null,null,"Where possible, source any missing data."]
[]
[null,5,null,"Summary is presented on Summary Output  and Summary Output by BUs tabs."]
[]
[]
[null,null,null,"Input Cells"]
[null,null,null,"Example","Calculated field"]
[null,null,null,null,"Data input requiring manual entry. They are on Summary Output and Attrition_Template(optional) tabs only."]
[]
[]
[null,"Supply and Demand Assumptions - needs to be updated"]
[]
[null,"Data Calculations "]
[]
[null,"Supply has been calculated on current FTE, minus those eligible to retire (65+ years), minus the average attrition rate, plus Capacity Gained FTEs"]
[null,"Demand has been calculated by current amount of FTE mapped to each BU with Growth Drivers% applied along the next 10 years; then, including Automation in the scenarium."]
[]
[null,"Additional Considerations "]
[null,"Attrition rates do not include contractors or temporary employees.  "]

{"sheet":"Summary Output TOTAL","index":1,"n_rows":17,"n_cols":19,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Scenario 1 - Automation and Augmentation"]
[]
[]
[null,"Role A",{"$f":"Role_A","v":{"$error":"#REF!"}},null,null,null,"Current",{"$f":"\"FY\" & RIGHT(YearReference+1,2)","v":{"$error":"#REF!"}},{"$f":"\"FY\" & RIGHT(YearReference+2,2)","v":{"$error":"#REF!"}},{"$f":"\"FY\" & RIGHT(YearReference+3,2)","v":{"$error":"#REF!"}},{"$f":"\"FY\" & RIGHT(YearReference+4,2)","v":{"$error":"#REF!"}},{"$f":"\"FY\" & RIGHT(YearReference+5,2)","v":{"$error":"#REF!"}},{"$f":"\"FY\" & RIGHT(YearReference+6,2)","v":{"$error":"#REF!"}},{"$f":"\"FY\" & RIGHT(YearReference+7,2)","v":{"$error":"#REF!"}},{"$f":"\"FY\" & RIGHT(YearReference+8,2)","v":{"$error":"#REF!"}},{"$f":"\"FY\" & RIGHT(YearReference+9,2)","v":{"$error":"#REF!"}},{"$f":"\"FY\" & RIGHT(YearReference+10,2)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"Supply",{"$f":"Supply!E17","v":264.35034000000002},{"$f":"Supply!F17","v":226.42135321680004},{"$f":"Supply!G17","v":194.22197257583889},{"$f":"Supply!H17","v":166.8599810793547},{"$f":"Supply!I17","v":143.54964172256885},{"$f":"Supply!J17","v":123.61633847297294},{"$f":"Supply!K17","v":106.49300326769674},{"$f":"Supply!L17","v":91.720293854401845},{"$f":"Supply!M17","v":78.933567688159684},{"$f":"Supply!N17","v":67.850505449065167},{"$f":"Supply!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,"calc1",{"$f":"G10","v":264.35034000000002},{"$f":"G7+G7*Demand!E30","v":290.78537400000005},{"$f":"H7+H7*Demand!F30","v":319.86391140000006},{"$f":"I7+I7*Demand!G30","v":351.85030254000009},{"$f":"J7+J7*Demand!H30","v":387.03533279400011},{"$f":"K7+K7*Demand!I30","v":425.73886607340012},{"$f":"L7+L7*Demand!J30","v":468.31275268074012},{"$f":"M7+M7*Demand!K30","v":515.14402794881414},{"$f":"N7+N7*Demand!L30","v":566.65843074369559},{"$f":"O7+O7*Demand!M30","v":623.32427381806519},{"$f":"P7+P7*Demand!N30","v":685.65670119987169}]
[null,null,null,null,null,"calc2",{"$f":"G10","v":264.35034000000002},{"$f":"G8+G8*Demand!E46","v":317.22040800000002},{"$f":"H8+H8*Demand!F46","v":380.66448960000002},{"$f":"I8+I8*Demand!G46","v":456.79738752000003},{"$f":"J8+J8*Demand!H46","v":548.15686502400001},{"$f":"K8+K8*Demand!I46","v":657.78823802880004},{"$f":"L8+L8*Demand!J46","v":789.34588563456009},{"$f":"M8+M8*Demand!K46","v":947.21506276147215},{"$f":"N8+N8*Demand!L46","v":1136.6580753137666},{"$f":"O8+O8*Demand!M46","v":1363.98969037652},{"$f":"P8+P8*Demand!N46","v":1636.787628451824}]
[null,null,null,null,null,"calc3",{"$f":"G10","v":264.35034000000002},{"$f":"G9+G9*Demand!E62","v":296.07238080000002},{"$f":"H9+H9*Demand!F62","v":331.60106649600004},{"$f":"I9+I9*Demand!G62","v":371.39319447552003},{"$f":"J9+J9*Demand!H62","v":415.96037781258246},{"$f":"K9+K9*Demand!I62","v":465.87562315009234},{"$f":"L9+L9*Demand!J62","v":521.78069792810345},{"$f":"M9+M9*Demand!K62","v":584.39438167947583},{"$f":"N9+N9*Demand!L62","v":654.52170748101298},{"$f":"O9+O9*Demand!M62","v":733.06431237873448},{"$f":"P9+P9*Demand!N62","v":821.03202986418262}]
[null,null,null,null,null,"Demand orig",{"$f":"G6","v":264.35034000000002},{"$f":"G10+SUM(H11:H13)","v":375.37748280000005},{"$f":"H10+SUM(I11:I13)","v":503.4287874960001},651.34020453552012,822.45189563058261,1020.7020472522925,1250.7386562434035,1518.0527923897621,1829.1375335384751,2191.6775965733195,2614.7756795158784]
[null,null,null,null,null,"Driver 1",0,{"$f":"H7-G7","v":26.43503400000003},{"$f":"I7-H7","v":29.078537400000016},31.986391140000023,35.185030254000026,38.703533279400006,42.57388660734,46.831275268074023,51.514402794881448,56.665843074369604,62.332427381806497]
[null,null,null,null,null,"Driver 2",0,{"$f":"H8-G8","v":52.870068000000003},{"$f":"I8-H8","v":63.444081600000004},76.132897920000005,91.359477503999983,109.63137300480003,131.55764760576005,157.86917712691206,189.44301255229448,227.33161506275337,272.79793807530405]
[null,null,null,null,null,"Driver 3",0,{"$f":"H9-G9","v":31.722040800000002},{"$f":"I9-H9","v":35.528685696000025},39.792127979519989,44.567183337062431,49.915245337509873,55.905074778011112,62.613683751372378,70.127325801537154,78.542604897721503,87.967717485448134]
[null,null,null,null,null,"Automation",0,{"$f":"Automation","v":0.20200000000000001},0.25600000000000001,0.316,0.377,0.435,0.48699999999999999,0.53100000000000003,0.56599999999999995,0.59399999999999997,0.61599999999999999]
[null,null,null,null,null,"Augmentation",0,{"$f":"Augmentation","v":1.189E-2},1.6410000000000001E-2,2.2200000000000001E-2,2.9319999999999999E-2,3.7620000000000001E-2,4.6760000000000003E-2,5.6239999999999998E-2,6.5519999999999995E-2,7.4109999999999995E-2,8.1699999999999995E-2]
[null,null,null,null,null,"Demand",{"$f":"G10+(G11+G12+G13)-(G14+G15)","v":264.35034000000002},{"$f":"H10+(H11+H12+H13)-(H14+H15)","v":486.1907356000001},{"$f":"I10+(I11+I12+I13)-(I14+I15)","v":631.20768219200011},798.91342157504016,993.15726672564506,1218.4795788740023,1480.2415052345148,1784.7796885361206,2139.5907546871881,2553.5495496081639,3037.1760624584372]
[null,null,null,null,null,"Gap",{"$f":"G6-G16","v":0},-259.76938238320008,-436.98570961616122,-632.05344049568544,-849.60762500307624,-1094.8632404010293,-1373.7485019668179,-1693.0593946817187,-2060.6571869990285,-2485.6990441590988,{"$error":"#REF!"},null,{"$f":"IF(SUM(H17:Q17)<>SUM(#REF!),\"ERROR!\",\"\")","v":{"$error":"#REF!"}}]

{"sheet":"Summary Output","index":2,"n_rows":42,"n_cols":31,"rows_kept":42,"cut":false,"hidden":false,"merged":[[5,4,5,5],[6,4,6,5]]}
[]
[null,"Input Form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Automation and Capacity Gain - All Business Units"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E7","v":"Client Service Representative"},"Current",{"$f":"Supply!E12","v":"Year 1"},{"$f":"Supply!F12","v":"Year 2"},{"$f":"Supply!G12","v":"Year 3"},{"$f":"Supply!H12","v":"Year 4"},{"$f":"Supply!I12","v":"Year 5"},{"$f":"Supply!J12","v":"Year 6"},{"$f":"Supply!K12","v":"Year 7"},{"$f":"Supply!L12","v":"Year 8"},{"$f":"Supply!M12","v":"Year 9"},{"$f":"Supply!N12","v":"Year 10"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FTE affected by attrition",{"$f":"'Summary Output by BU'!C6+'Summary Output by BU'!C20+'Summary Output by BU'!C34+'Summary Output by BU'!C48+'Summary Output by BU'!C62","v":306},{"$f":"U9","v":306},{"$f":"V9","v":264.35034000000002},{"$f":"W9","v":226.42135321680004},{"$f":"X9","v":194.22197257583892},166.85998107935472,143.54964172256885,123.61633847297294,106.49300326769672,91.720293854401831,78.933567688159684]
[null,null,"Company:",null,"Global European Bank",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Predicted Retirement",null,{"$f":"Supply!E14","v":-7.0380000000000003},{"$f":"Supply!F14","v":-6.0800578200000004},{"$f":"Supply!G14","v":-5.2076911239864003},{"$f":"Supply!H14","v":-4.4671053692442948},{"$f":"Supply!I14","v":-3.8377795648251585},{"$f":"Supply!J14","v":-3.3016417596190837},{"$f":"Supply!K14","v":-2.8431757848783779},{"$f":"Supply!L14","v":-2.4493390751570248},{"$f":"Supply!M14","v":-2.1095667586512419},{"$f":"Supply!N14","v":-1.8154720568276723}]
[null,null,"Role:",null,"Client Service Representative",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expected Attrition",null,{"$f":"Supply!E15","v":-38.25},{"$f":"Supply!F15","v":-33.043792500000002},{"$f":"Supply!G15","v":-28.302669152100002},{"$f":"Supply!H15","v":-24.277746571979861},{"$f":"Supply!I15","v":-20.857497634919341},{"$f":"Supply!J15","v":-17.943705215321106},{"$f":"Supply!K15","v":-15.452042309121619},{"$f":"Supply!L15","v":-13.311625408462092},{"$f":"Supply!M15","v":-11.465036731800229},{"$f":"Supply!N15","v":-9.8666959610199587}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Capacity Gain",null,{"$f":"Supply!E16","v":3.6383400000000004},{"$f":"Supply!F16","v":1.1948635368000005},{"$f":"Supply!G16","v":1.3109796351252718},{"$f":"Supply!H16","v":1.3828604447399726},{"$f":"Supply!I16","v":1.3849378429586443},{"$f":"Supply!J16","v":1.3120437253442796},{"$f":"Supply!K16","v":1.1718828887237829},{"$f":"Supply!L16","v":0.98825507032422533},{"$f":"Supply!M16","v":0.78787732420931178},{"$f":"Supply!N16","v":0.59910577875313187}]
[null,null,"Attrition Rate",null,0.125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Supply",{"$f":"SUM(U5:U8)","v":306},{"$f":"SUM(V5:V8)","v":264.35034000000002},{"$f":"SUM(W5:W8)","v":226.42135321680004},{"$f":"SUM(X5:X8)","v":194.22197257583892},166.85998107935472,143.54964172256885,123.61633847297294,106.49300326769672,91.720293854401831,78.933567688159684,67.850505449065182]
[null,null,"Retirement Rate",null,2.3E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Growth Driver 1",null,{"$f":"Demand!E7","v":6.1199999999999992},{"$f":"Demand!F7","v":6.5500139799999992},{"$f":"Demand!G7","v":5.6102179741495997},{"$f":"Demand!H7","v":4.8123888760457856},{"$f":"Demand!I7","v":4.1344195311884553},{"$f":"Demand!J7","v":3.5568411226814276},{"$f":"Demand!K7","v":3.0629381643858857},{"$f":"Demand!L7","v":2.6386599698551523},{"$f":"Demand!M7","v":2.2726250588368453},{"$f":"Demand!N7","v":1.9557983993844006}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Growth Driver 2",null,{"$f":"Demand!E8","v":12.239999999999998},{"$f":"Demand!F8","v":10.574013599999999},{"$f":"Demand!G8","v":9.0568541286719988},{"$f":"Demand!H8","v":7.7688789030335563},{"$f":"Demand!I8","v":6.6743992431741876},{"$f":"Demand!J8","v":5.7419856689027533},{"$f":"Demand!K8","v":4.944653538918919},{"$f":"Demand!L8","v":4.2597201307078691},{"$f":"Demand!M8","v":3.6688117541760734},{"$f":"Demand!N8","v":3.1573427075263867}]
[null,null,"Faethm Data",null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10",null,null,"Growth Driver 3",null,{"$f":"Demand!E9","v":6.8039999999999994},{"$f":"Demand!F9","v":5.8779075599999988},{"$f":"Demand!G9","v":5.0345453832912002},{"$f":"Demand!H9","v":4.318582684333359},{"$f":"Demand!I9","v":3.7101807557644753},{"$f":"Demand!J9","v":3.1918685041841779},{"$f":"Demand!K9","v":2.7486456436931634},{"$f":"Demand!L9","v":2.3679032491287866},{"$f":"Demand!M9","v":2.0394277104096408},{"$f":"Demand!N9","v":1.7551110933014329}]
[null,null,null,null,"Automation",null,null,0.20200000000000001,0.25600000000000001,0.316,0.377,0.435,0.48699999999999999,0.53100000000000003,0.56599999999999995,0.59399999999999997,0.61599999999999999,null,null,"Faethm Automation",null,{"$f":"Demand!E10","v":-61.811999999999998},{"$f":"Demand!F10","v":-14.274918359999997},{"$f":"Demand!G10","v":-13.585281193008001},{"$f":"Demand!H10","v":-11.847540327126172},{"$f":"Demand!I10","v":-9.6778789026025738},{"$f":"Demand!J10","v":-7.4645813695735788},{"$f":"Demand!K10","v":-5.4391188928108143},{"$f":"Demand!L10","v":-3.7272551143693771},{"$f":"Demand!M10","v":-2.5681682279232536},{"$f":"Demand!N10","v":-1.7365384891395144}]
[null,null,null,null,"Capacity Gain",null,null,1.189E-2,1.6410000000000001E-2,2.2200000000000001E-2,2.9319999999999999E-2,3.7620000000000001E-2,4.6760000000000003E-2,5.6239999999999998E-2,6.5519999999999995E-2,7.4109999999999995E-2,8.1699999999999995E-2,null,null,"Total Demand",{"$f":"SUM(U9:U13)","v":306},{"$f":"U14+SUM(V10:V13)","v":269.35199999999998},{"$f":"V14+SUM(W10:W13)","v":278.07901677999996},{"$f":"W14+SUM(X10:X13)","v":284.19535307310474},289.24766320939125,294.08878383691581,299.1148977631106,304.43201621729776,309.97104445262016,315.38374074811946,320.51545445919214]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gap",null,{"$f":"V9-V14","v":-5.0016599999999585},-51.657663563199918,-89.973380497265822,-122.38768213003652,-150.53914211434696,-175.49855929013768,-197.93901294960102,-218.25075059821833,-236.45017305995978,-252.66494901012697]
[null,null,null,null,null,"FTE"]
[null,null,"Bus Unit 1:",null,"Banking",140.6]
[null,null,null,null,"Growth Driver #1",null,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,null,null,null,"Growth Driver #2",null,null,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,null,null,null,"Growth Driver #3",null,null,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[]
[null,null,"Bus Unit 2:",null,"Consulting Services",67.5]
[null,null,null,null,"Growth Driver #1",null,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,null,null,null,"Growth Driver #2",null,null,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,null,null,null,"Growth Driver #3",null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[]
[null,null,"Bus Unit 3:",null,"Retail Banking",39.200000000000003]
[null,null,null,null,"Growth Driver #1",null,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,null,null,null,"Growth Driver #2",null,null,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,null,null,null,"Growth Driver #3",null,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[]
[null,null,"Bus Unit 4:",null,"Financial Services",45.2]
[null,null,null,null,"Growth Driver #1",null,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,null,null,null,"Growth Driver #2",null,null,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,null,null,null,"Growth Driver #3",null,null,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[]
[null,null,"Bus Unit 5:",null,"Insurance",13.5]
[null,null,null,null,"Growth Driver #1",null,null,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,null,null,null,"Growth Driver #2",null,null,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,null,null,null,"Growth Driver #3",null,null,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[]
[null,null,"TOTAL",null,null,{"$f":"SUM(F17:F37)","v":306}]

{"sheet":"Summary Output by BU","index":3,"n_rows":72,"n_cols":13,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Scenario 1 - Automation and Augmentation - All Business Units"]
[]
[]
[null,{"$f":"'Summary Output'!E17","v":"Banking"},"Current",{"$f":"Supply!E12","v":"Year 1"},{"$f":"Supply!F12","v":"Year 2"},{"$f":"Supply!G12","v":"Year 3"},{"$f":"Supply!H12","v":"Year 4"},{"$f":"Supply!I12","v":"Year 5"},{"$f":"Supply!J12","v":"Year 6"},{"$f":"Supply!K12","v":"Year 7"},{"$f":"Supply!L12","v":"Year 8"},{"$f":"Supply!M12","v":"Year 9"},{"$f":"Supply!N12","v":"Year 10"}]
[null,"FTE affected by attrition",{"$f":"'Summary Output'!F17","v":140.6},{"$f":"C10","v":140.6},{"$f":"D10","v":121.46293399999999},{"$f":"E10","v":104.03543222967998},89.240553412297203,76.668344247572776,65.957776556186857,56.798879703594757,48.931098887052812,42.143376849440841,36.268168682860292]
[null,"Predicted Retirement",null,{"$f":"Supply!E21","v":-3.2338},{"$f":"Supply!F21","v":-2.7936474819999999},{"$f":"Supply!G21","v":-2.3928149412826394},{"$f":"Supply!H21","v":-2.0525327284828356},{"$f":"Supply!I21","v":-1.7633719176941738},{"$f":"Supply!J21","v":-1.5170288607922977},{"$f":"Supply!K21","v":-1.3063742331826793},{"$f":"Supply!L21","v":-1.1254152744022146},{"$f":"Supply!M21","v":-0.96929766753713931},{"$f":"Supply!N21","v":-0.83416787970578665}]
[null,"Expected Attrition",null,{"$f":"Supply!E22","v":-17.574999999999999},{"$f":"Supply!F22","v":-15.182866749999999},{"$f":"Supply!G22","v":-13.004429028709998},{"$f":"Supply!H22","v":-11.15506917653715},{"$f":"Supply!I22","v":-9.583543030946597},{"$f":"Supply!J22","v":-8.2447220695233572},{"$f":"Supply!K22","v":-7.0998599629493446},{"$f":"Supply!L22","v":-6.1163873608816015},{"$f":"Supply!M22","v":-5.2679221061801051},{"$f":"Supply!N22","v":-4.5335210853575365}]
[null,"Capacity Gain",null,{"$f":"Supply!E23","v":1.6717339999999998},{"$f":"Supply!F23","v":0.54901246168000017},{"$f":"Supply!G23","v":0.60236515260984713},{"$f":"Supply!H23","v":0.63539274029555592},{"$f":"Supply!I23","v":0.63634725725485419},{"$f":"Supply!J23","v":0.60285407772354804},{"$f":"Supply!K23","v":0.538453379590078},{"$f":"Supply!L23","v":0.45408059767184994},{"$f":"Supply!M23","v":0.36201160713669683},{"$f":"Supply!N23","v":0.27527540030290959}]
[null,"Total Supply",{"$f":"SUM(C6:C9)","v":140.6},{"$f":"SUM(D6:D9)","v":121.46293399999999},{"$f":"SUM(E6:E9)","v":104.03543222967998},{"$f":"SUM(F6:F9)","v":89.240553412297203},76.668344247572776,65.957776556186857,56.798879703594757,48.931098887052812,42.143376849440841,36.268168682860292,31.175755118099879]
[null,"Growth Driver 1",null,{"$f":"Demand!E32","v":2.8119999999999998},{"$f":"Demand!F32","v":2.4292586799999998},{"$f":"Demand!G32","v":2.0807086445935998},{"$f":"Demand!H32","v":1.7848110682459442},{"$f":"Demand!I32","v":1.5333668849514555},{"$f":"Demand!J32","v":1.3191555311237371},{"$f":"Demand!K32","v":1.1359775940718952},{"$f":"Demand!L32","v":0.9786219777410563},{"$f":"Demand!M32","v":0.84286753698881689},{"$f":"Demand!N32","v":0.72536337365720582}]
[null,"Growth Driver 2",null,{"$f":"Demand!E48","v":5.6239999999999997},{"$f":"Demand!F48","v":4.8585173599999996},{"$f":"Demand!G48","v":4.1614172891871997},{"$f":"Demand!H48","v":3.5696221364918883},{"$f":"Demand!I48","v":3.0667337699029109},{"$f":"Demand!J48","v":2.6383110622474741},{"$f":"Demand!K48","v":2.2719551881437905},{"$f":"Demand!L48","v":1.9572439554821126},{"$f":"Demand!M48","v":1.6857350739776338},{"$f":"Demand!N48","v":1.4507267473144116}]
[null,"Growth Driver 3",null,{"$f":"Demand!E64","v":4.218},{"$f":"Demand!F64","v":3.6438880199999995},{"$f":"Demand!G64","v":3.1210629668903995},{"$f":"Demand!H64","v":2.6772166023689161},{"$f":"Demand!I64","v":2.3000503274271833},{"$f":"Demand!J64","v":1.9787332966856057},{"$f":"Demand!K64","v":1.7039663911078426},{"$f":"Demand!L64","v":1.4679329666115843},{"$f":"Demand!M64","v":1.2643013054832253},{"$f":"Demand!N64","v":1.0880450604858087}]
[null,"Faethm Automation",null,{"$f":"Demand!E16","v":-28.401199999999999},{"$f":"Demand!F16","v":-6.5589984359999987},{"$f":"Demand!G16","v":-6.2421259337807991},{"$f":"Demand!H16","v":-5.4436737581501289},{"$f":"Demand!I16","v":-4.4467639663592209},{"$f":"Demand!J16","v":-3.4298043809217158},{"$f":"Demand!K16","v":-2.4991507069581713},{"$f":"Demand!L16","v":-1.7125884610468445},{"$f":"Demand!M16","v":-1.1800145517843446},{"$f":"Demand!N16","v":-0.79789971102292712}]
[null,"Total Demand",{"$f":"SUM(C10:C14)","v":140.6},{"$f":"C15+SUM(D11:D14)","v":124.8528},{"$f":"D15+SUM(E11:E14)","v":129.22546562400001},132.34652859089041,134.93450463984703,137.38789165576935,139.89428716490445,142.50703563126982,145.19824607005773,147.81113543472307,150.27737090515757]
[null,"Gap",{"$f":"C10-C15","v":0},-3.389866000000012,-25.190033394320025,-43.105975178593212,-58.266160392274259,-71.430115099582494,-83.095407461309691,-93.575936744217003,-103.05486922061689,-111.54296675186278,-119.10161578705768]
[]
[]
[null,{"$f":"'Summary Output'!E22","v":"Consulting Services"},{"$f":"$C$5","v":"Current"},{"$f":"$D$5","v":"Year 1"},{"$f":"E$5","v":"Year 2"},{"$f":"$F$5","v":"Year 3"},{"$f":"$G$5","v":"Year 4"},{"$f":"$H$5","v":"Year 5"},{"$f":"$I$5","v":"Year 6"},{"$f":"$J$5","v":"Year 7"},{"$f":"$K$5","v":"Year 8"},{"$f":"$L$5","v":"Year 9"},{"$f":"$M$5","v":"Year 10"}]
[null,"FTE affected by attrition",{"$f":"'Summary Output'!F22","v":67.5},{"$f":"C24","v":67.5},{"$f":"D24","v":58.312575000000002},{"$f":"E24","v":49.945886739000002},42.843082185846818,36.80734876750472,31.665362144684313,27.268309957273448,23.491103661991929,20.232417762000409,17.411816401799932]
[null,"Predicted Retirement",null,{"$f":"Supply!E28","v":-1.5525},{"$f":"Supply!F28","v":-1.3411892249999999},{"$f":"Supply!G28","v":-1.148755394997},{"$f":"Supply!H28","v":-0.98539089027447679},{"$f":"Supply!I28","v":-0.8465690216526085},{"$f":"Supply!J28","v":-0.72830332932773922},{"$f":"Supply!K28","v":-0.62717112901728933},{"$f":"Supply!L28","v":-0.54029538422581436},{"$f":"Supply!M28","v":-0.46534560852600942},{"$f":"Supply!N28","v":-0.40047177724139843}]
[null,"Expected Attrition",null,{"$f":"Supply!E29","v":-8.4375},{"$f":"Supply!F29","v":-7.2890718750000003},{"$f":"Supply!G29","v":-6.2432358423750003},{"$f":"Supply!H29","v":-5.3553852732308522},{"$f":"Supply!I29","v":-4.60091859593809},{"$f":"Supply!J29","v":-3.9581702680855391},{"$f":"Supply!K29","v":-3.4085387446591811},{"$f":"Supply!L29","v":-2.9363879577489911},{"$f":"Supply!M29","v":-2.5290522202500512},{"$f":"Supply!N29","v":-2.1764770502249915}]
[null,"Capacity Gain",null,{"$f":"Supply!E30","v":0.80257499999999993},{"$f":"Supply!F30","v":0.26357283900000011},{"$f":"Supply!G30","v":0.28918668421881},{"$f":"Supply!H30","v":0.30504274516322927},{"$f":"Supply!I30","v":0.30550099477028925},{"$f":"Supply!J30","v":0.28942141000241467},{"$f":"Supply!K30","v":0.25850357839495214},{"$f":"Supply!L30","v":0.21799744198328502},{"$f":"Supply!M30","v":0.17379646857558353},{"$f":"Supply!N30","v":0.13215568648966147}]
[null,"Total Supply",{"$f":"SUM(C20:C23)","v":67.5},{"$f":"SUM(D20:D23)","v":58.312575000000002},{"$f":"SUM(E20:E23)","v":49.945886739000002},{"$f":"SUM(F20:F23)","v":42.843082185846818},{"$f":"SUM(G20:G23)","v":36.80734876750472},{"$f":"SUM(H20:H23)","v":31.665362144684313},{"$f":"SUM(I20:I23)","v":27.268309957273448},{"$f":"SUM(J20:J23)","v":23.491103661991929},{"$f":"SUM(K20:K23)","v":20.232417762000409},{"$f":"SUM(L20:L23)","v":17.411816401799932},{"$f":"SUM(M20:M23)","v":14.967023260823201}]
[null,"Growth Driver 1",null,{"$f":"Demand!E33","v":1.35},{"$f":"Demand!F33","v":2.4292586799999998},{"$f":"Demand!G33","v":2.0807086445935998},{"$f":"Demand!H33","v":1.7848110682459442},{"$f":"Demand!I33","v":1.5333668849514555},{"$f":"Demand!J33","v":1.3191555311237371},{"$f":"Demand!K33","v":1.1359775940718952},{"$f":"Demand!L33","v":0.9786219777410563},{"$f":"Demand!M33","v":0.84286753698881689},{"$f":"Demand!N33","v":0.72536337365720582}]
[null,"Growth Driver 2",null,{"$f":"Demand!E49","v":2.7},{"$f":"Demand!F49","v":2.332503},{"$f":"Demand!G49","v":1.9978354695600002},{"$f":"Demand!H49","v":1.7137232874338728},{"$f":"Demand!I49","v":1.4722939507001889},{"$f":"Demand!J49","v":1.2666144857873725},{"$f":"Demand!K49","v":1.090732398290938},{"$f":"Demand!L49","v":0.9396441464796772},{"$f":"Demand!M49","v":0.80929671048001639},{"$f":"Demand!N49","v":0.69647265607199726}]
[null,"Growth Driver 3",null,{"$f":"Demand!E65","v":0.67500000000000004},{"$f":"Demand!F65","v":0.58312575},{"$f":"Demand!G65","v":0.49945886739000006},{"$f":"Demand!H65","v":0.4284308218584682},{"$f":"Demand!I65","v":0.36807348767504722},{"$f":"Demand!J65","v":0.31665362144684311},{"$f":"Demand!K65","v":0.27268309957273451},{"$f":"Demand!L65","v":0.2349110366199193},{"$f":"Demand!M65","v":0.2023241776200041},{"$f":"Demand!N65","v":0.17411816401799932}]
[null,"Faethm Automation",null,{"$f":"Demand!E17","v":-13.635000000000002},{"$f":"Demand!F17","v":-3.1488790499999997},{"$f":"Demand!G17","v":-2.99675320434},{"$f":"Demand!H17","v":-2.6134280133366556},{"$f":"Demand!I17","v":-2.1348262285152737},{"$f":"Demand!J17","v":-1.646598831523584},{"$f":"Demand!K17","v":-1.1998056381200328},{"$f":"Demand!L17","v":-0.82218862816971561},{"$f":"Demand!M17","v":-0.56650769733601192},{"$f":"Demand!N17","v":-0.38305996083959887}]
[null,"Total Demand",{"$f":"SUM(C24:C28)","v":67.5},{"$f":"C29+SUM(D25:D28)","v":58.59},{"$f":"D29+SUM(E25:E28)","v":60.786008380000006},{"$f":"E29+SUM(F25:F28)","v":62.367258157203608},{"$f":"F29+SUM(G25:G28)","v":63.680795321405235},{"$f":"G29+SUM(H25:H28)","v":64.919703416216649},{"$f":"H29+SUM(I25:I28)","v":66.175528223051018},{"$f":"I29+SUM(J25:J28)","v":67.475115676866551},{"$f":"J29+SUM(K25:K28)","v":68.806104209537494},{"$f":"K29+SUM(L25:L28)","v":70.094084937290319},{"$f":"L29+SUM(M25:M28)","v":71.30697917019792}]
[null,"Gap",{"$f":"C24-C29","v":0},-0.27742500000000092,-10.840121641000003,-19.52417597135679,-26.873446553900514,-33.25434127153234,-38.907218265777573,-43.984012014874622,-48.573686447537085,-52.682268535490387,-56.339955909374723]
[]
[]
[null,{"$f":"'Summary Output'!E27","v":"Retail Banking"},{"$f":"$C$5","v":"Current"},{"$f":"$D$5","v":"Year 1"},{"$f":"E$5","v":"Year 2"},{"$f":"$F$5","v":"Year 3"},{"$f":"$G$5","v":"Year 4"},{"$f":"$H$5","v":"Year 5"},{"$f":"$I$5","v":"Year 6"},{"$f":"$J$5","v":"Year 7"},{"$f":"$K$5","v":"Year 8"},{"$f":"$L$5","v":"Year 9"},{"$f":"$M$5","v":"Year 10"}]
[null,"FTE affected by attrition",{"$f":"'Summary Output'!F27","v":39.200000000000003},{"$f":"C38","v":39.200000000000003},{"$f":"D38","v":33.864488000000001},{"$f":"E38","v":29.005611261760006},24.880723284225116,21.375526987943481,18.389365867727776,15.835818523335098,13.64224094148272,11.749789278080238,10.11175115482307]
[null,"Predicted Retirement",null,{"$f":"Supply!E35","v":-0.90160000000000007},{"$f":"Supply!F35","v":-0.77888322399999999},{"$f":"Supply!G35","v":-0.66712905902048014},{"$f":"Supply!H35","v":-0.57225663553717765},{"$f":"Supply!I35","v":-0.49163712072270005},{"$f":"Supply!J35","v":-0.42295541495773881},{"$f":"Supply!K35","v":-0.36422382603670722},{"$f":"Supply!L35","v":-0.31377154165410254},{"$f":"Supply!M35","v":-0.27024515339584548},{"$f":"Supply!N35","v":-0.2325702765609306}]
[null,"Expected Attrition",null,{"$f":"Supply!E36","v":-4.9000000000000004},{"$f":"Supply!F36","v":-4.2330610000000002},{"$f":"Supply!G36","v":-3.6257014077200007},{"$f":"Supply!H36","v":-3.1100904105281395},{"$f":"Supply!I36","v":-2.6719408734929351},{"$f":"Supply!J36","v":-2.2986707334659719},{"$f":"Supply!K36","v":-1.9794773154168872},{"$f":"Supply!L36","v":-1.70528011768534},{"$f":"Supply!M36","v":-1.4687236597600297},{"$f":"Supply!N36","v":-1.2639688943528837}]
[null,"Capacity Gain",null,{"$f":"Supply!E37","v":0.466088},{"$f":"Supply!F37","v":0.15306748576000007},{"$f":"Supply!G37","v":0.16794248920559043},{"$f":"Supply!H37","v":0.17715074978368278},{"$f":"Supply!I37","v":0.17741687399993092},{"$f":"Supply!J37","v":0.1680788040310319},{"$f":"Supply!K37","v":0.15012355960121665},{"$f":"Supply!L37","v":0.12659999593695959},{"$f":"Supply!M37","v":0.10093068989870925},{"$f":"Supply!N37","v":7.6748191265107096E-2}]
[null,"Total Supply",{"$f":"SUM(C34:C37)","v":39.200000000000003},{"$f":"SUM(D34:D37)","v":33.864488000000001},{"$f":"SUM(E34:E37)","v":29.005611261760006},{"$f":"SUM(F34:F37)","v":24.880723284225116},{"$f":"SUM(G34:G37)","v":21.375526987943481},{"$f":"SUM(H34:H37)","v":18.389365867727776},{"$f":"SUM(I34:I37)","v":15.835818523335098},{"$f":"SUM(J34:J37)","v":13.64224094148272},{"$f":"SUM(K34:K37)","v":11.749789278080238},{"$f":"SUM(L34:L37)","v":10.11175115482307},{"$f":"SUM(M34:M37)","v":8.691960175174362}]
[null,"Growth Driver 1",null,{"$f":"Demand!E34","v":0.78400000000000003},{"$f":"Demand!F34","v":0.67728976000000007},{"$f":"Demand!G34","v":0.58011222523520012},{"$f":"Demand!H34","v":0.49761446568450235},{"$f":"Demand!I34","v":0.4275105397588696},{"$f":"Demand!J34","v":0.3677873173545555},{"$f":"Demand!K34","v":0.31671637046670198},{"$f":"Demand!L34","v":0.27284481882965439},{"$f":"Demand!M34","v":0.23499578556160475},{"$f":"Demand!N34","v":0.20223502309646141}]
[null,"Growth Driver 2",null,{"$f":"Demand!E50","v":1.5680000000000001},{"$f":"Demand!F50","v":1.3545795200000001},{"$f":"Demand!G50","v":1.1602244504704002},{"$f":"Demand!H50","v":0.9952289313690047},{"$f":"Demand!I50","v":0.8550210795177392},{"$f":"Demand!J50","v":0.735574634709111},{"$f":"Demand!K50","v":0.63343274093340396},{"$f":"Demand!L50","v":0.54568963765930878},{"$f":"Demand!M50","v":0.4699915711232095},{"$f":"Demand!N50","v":0.40447004619292282}]
[null,"Growth Driver 3",null,{"$f":"Demand!E66","v":0.78400000000000003},{"$f":"Demand!F66","v":0.67728976000000007},{"$f":"Demand!G66","v":0.58011222523520012},{"$f":"Demand!H66","v":0.49761446568450235},{"$f":"Demand!I66","v":0.4275105397588696},{"$f":"Demand!J66","v":0.3677873173545555},{"$f":"Demand!K66","v":0.31671637046670198},{"$f":"Demand!L66","v":0.27284481882965439},{"$f":"Demand!M66","v":0.23499578556160475},{"$f":"Demand!N66","v":0.20223502309646141}]
[null,"Faethm Automation",null,{"$f":"Demand!E18","v":-7.918400000000001},{"$f":"Demand!F18","v":-1.8286823519999997},{"$f":"Demand!G18","v":-1.7403366757056002},{"$f":"Demand!H18","v":-1.5177241203377321},{"$f":"Demand!I18","v":-1.2397805653007219},{"$f":"Demand!J18","v":-0.95624702512184412},{"$f":"Demand!K18","v":-0.69677601502674491},{"$f":"Demand!L18","v":-0.47747843295189413},{"$f":"Demand!M18","v":-0.32899409978624694},{"$f":"Demand!N18","v":-0.22245852540610772}]
[null,"Total Demand",{"$f":"SUM(C38:C42)","v":39.200000000000003},{"$f":"C43+SUM(D39:D42)","v":34.4176},{"$f":"D43+SUM(E39:E42)","v":35.298076688000002},{"$f":"E43+SUM(F39:F42)","v":35.878188913235199},{"$f":"F43+SUM(G39:G42)","v":36.350922655635479},{"$f":"G43+SUM(H39:H42)","v":36.821184249370233},{"$f":"H43+SUM(I39:I42)","v":37.336086493666613},{"$f":"I43+SUM(J39:J42)","v":37.90617596050668},{"$f":"J43+SUM(K39:K42)","v":38.520076802873405},{"$f":"K43+SUM(L39:L42)","v":39.131065845333573},{"$f":"L43+SUM(M39:M42)","v":39.717547412313309}]
[null,"Gap",{"$f":"C38-C43","v":0},-0.55311199999999872,-6.2924654262399962,-10.997465629010083,-14.975395667691998,-18.431818381642458,-21.500267970331514,-24.263935019023961,-26.770287524793169,-29.019314690510505,-31.025587237138947]
[]
[]
[null,{"$f":"'Summary Output'!E32","v":"Financial Services"},{"$f":"$C$5","v":"Current"},{"$f":"$D$5","v":"Year 1"},{"$f":"E$5","v":"Year 2"},{"$f":"$F$5","v":"Year 3"},{"$f":"$G$5","v":"Year 4"},{"$f":"$H$5","v":"Year 5"},{"$f":"$I$5","v":"Year 6"},{"$f":"$J$5","v":"Year 7"},{"$f":"$K$5","v":"Year 8"},{"$f":"$L$5","v":"Year 9"},{"$f":"$M$5","v":"Year 10"}]
[null,"FTE affected by attrition",{"$f":"'Summary Output'!F32","v":45.2},{"$f":"C52","v":45.2},{"$f":"D52","v":39.047828000000003},{"$f":"E52","v":33.445245638560003},28.688997256300386,24.647291322832789,21.204064725033046,18.259668297314956,15.730339044770886,13.548226412480268,11.659468168316392]
[null,"Predicted Retirement",null,{"$f":"Supply!E42","v":-1.0396000000000001},{"$f":"Supply!F42","v":-0.8981000440000001},{"$f":"Supply!G42","v":-0.76924064968688011},{"$f":"Supply!H42","v":-0.65984693689490881},{"$f":"Supply!I42","v":-0.56688770042515413},{"$f":"Supply!J42","v":-0.48769348867576007},{"$f":"Supply!K42","v":-0.41997237083824401},{"$f":"Supply!L42","v":-0.36179779802973039},{"$f":"Supply!M42","v":-0.31160920748704618},{"$f":"Supply!N42","v":-0.268167767871277}]
[null,"Expected Attrition",null,{"$f":"Supply!E43","v":-5.65},{"$f":"Supply!F43","v":-4.8809785000000003},{"$f":"Supply!G43","v":-4.1806557048200004},{"$f":"Supply!H43","v":-3.5861246570375482},{"$f":"Supply!I43","v":-3.0809114153540986},{"$f":"Supply!J43","v":-2.6505080906291307},{"$f":"Supply!K43","v":-2.2824585371643695},{"$f":"Supply!L43","v":-1.9662923805963608},{"$f":"Supply!M43","v":-1.6935283015600335},{"$f":"Supply!N43","v":-1.457433521039549}]
[null,"Capacity Gain",null,{"$f":"Supply!E44","v":0.53742800000000002},{"$f":"Supply!F44","v":0.17649618256000008},{"$f":"Supply!G44","v":0.19364797224726241},{"$f":"Supply!H44","v":0.20426566046485869},{"$f":"Supply!I44","v":0.2045725179795122},{"$f":"Supply!J44","v":0.19380515158680209},{"$f":"Supply!K44","v":0.17310165545854569},{"$f":"Supply!L44","v":0.14597754633547377},{"$f":"Supply!M44","v":0.1163792648832055},{"$f":"Supply!N44","v":8.8495363397521412E-2}]
[null,"Total Supply",{"$f":"SUM(C48:C51)","v":45.2},{"$f":"SUM(D48:D51)","v":39.047828000000003},{"$f":"SUM(E48:E51)","v":33.445245638560003},{"$f":"SUM(F48:F51)","v":28.688997256300386},{"$f":"SUM(G48:G51)","v":24.647291322832789},{"$f":"SUM(H48:H51)","v":21.204064725033046},{"$f":"SUM(I48:I51)","v":18.259668297314956},{"$f":"SUM(J48:J51)","v":15.730339044770886},{"$f":"SUM(K48:K51)","v":13.548226412480268},{"$f":"SUM(L48:L51)","v":11.659468168316392},{"$f":"SUM(M48:M51)","v":10.022362242803087}]
[null,"Growth Driver 1",null,{"$f":"Demand!E35","v":0.90400000000000003},{"$f":"Demand!F35","v":0.78095656000000002},{"$f":"Demand!G35","v":0.66890491277120012},{"$f":"Demand!H35","v":0.57377994512600772},{"$f":"Demand!I35","v":0.4929458264566558},{"$f":"Demand!J35","v":0.4240812945006609},{"$f":"Demand!K35","v":0.36519336594629914},{"$f":"Demand!L35","v":0.31460678089541771},{"$f":"Demand!M35","v":0.27096452824960537},{"$f":"Demand!N35","v":0.23318936336632784}]
[null,"Growth Driver 2",null,{"$f":"Demand!E51","v":1.8080000000000001},{"$f":"Demand!F51","v":1.56191312},{"$f":"Demand!G51","v":1.3378098255424002},{"$f":"Demand!H51","v":1.1475598902520154},{"$f":"Demand!I51","v":0.9858916529133116},{"$f":"Demand!J51","v":0.8481625890013218},{"$f":"Demand!K51","v":0.73038673189259828},{"$f":"Demand!L51","v":0.62921356179083543},{"$f":"Demand!M51","v":0.54192905649921075},{"$f":"Demand!N51","v":0.46637872673265568}]
[null,"Growth Driver 3",null,{"$f":"Demand!E67","v":0.45200000000000001},{"$f":"Demand!F67","v":0.39047828000000001},{"$f":"Demand!G67","v":0.33445245638560006},{"$f":"Demand!H67","v":0.28688997256300386},{"$f":"Demand!I67","v":0.2464729132283279},{"$f":"Demand!J67","v":0.21204064725033045},{"$f":"Demand!K67","v":0.18259668297314957},{"$f":"Demand!L67","v":0.15730339044770886},{"$f":"Demand!M67","v":0.13548226412480269},{"$f":"Demand!N67","v":0.11659468168316392}]
[null,"Faethm Automation",null,{"$f":"Demand!E19","v":-9.1304000000000016},{"$f":"Demand!F19","v":-2.108582712},{"$f":"Demand!G19","v":-2.0067147383136001},{"$f":"Demand!H19","v":-1.7500288326343234},{"$f":"Demand!I19","v":-1.4295428967243016},{"$f":"Demand!J19","v":-1.1026113657017182},{"$f":"Demand!K19","v":-0.80342540508185878},{"$f":"Demand!L19","v":-0.55056186656697981},{"$f":"Demand!M19","v":-0.37935033954944786},{"$f":"Demand!N19","v":-0.25650829970296085}]
[null,"Total Demand",{"$f":"SUM(C52:C56)","v":45.2},{"$f":"C57+SUM(D53:D56)","v":39.233600000000003},{"$f":"D57+SUM(E53:E56)","v":39.858365248000005},{"$f":"E57+SUM(F53:F56)","v":40.192817704385604},{"$f":"F57+SUM(G53:G56)","v":40.451018679692311},{"$f":"G57+SUM(H53:H56)","v":40.746786175566307},{"$f":"H57+SUM(I53:I56)","v":41.128459340616899},{"$f":"I57+SUM(J53:J56)","v":41.603210716347085},{"$f":"J57+SUM(K53:K56)","v":42.153772582914065},{"$f":"K57+SUM(L53:L56)","v":42.722798092238236},{"$f":"L57+SUM(M53:M56)","v":43.282452564317424}]
[null,"Gap",{"$f":"C52-C57","v":0},-0.18577200000000005,-6.4131196094400025,-11.503820448085218,-15.803727356859522,-19.542721450533261,-22.868791043301943,-25.872871671576199,-28.605546170433797,-31.063329923921842,-33.26009032151434]
[]
[]
[null,{"$f":"'Summary Output'!E37","v":"Insurance"},{"$f":"$C$5","v":"Current"},{"$f":"$D$5","v":"Year 1"},{"$f":"E$5","v":"Year 2"},{"$f":"$F$5","v":"Year 3"},{"$f":"$G$5","v":"Year 4"},{"$f":"$H$5","v":"Year 5"},{"$f":"$I$5","v":"Year 6"},{"$f":"$J$5","v":"Year 7"},{"$f":"$K$5","v":"Year 8"},{"$f":"$L$5","v":"Year 9"},{"$f":"$M$5","v":"Year 10"}]
[null,"FTE affected by attrition",{"$f":"'Summary Output'!F37","v":13.5},{"$f":"C66","v":13.5},{"$f":"D66","v":11.662515000000001},{"$f":"E66","v":9.9891773478000019},8.5686164371693661,7.3614697535009466,6.3330724289368643,5.4536619914546911,4.6982207323983864,4.0464835524000815,3.4823632803599867]
[null,"Predicted Retirement",null,{"$f":"Supply!E49","v":-0.3105},{"$f":"Supply!F49","v":-0.26823784500000003},{"$f":"Supply!G49","v":-0.22975107899940003},{"$f":"Supply!H49","v":-0.19707817805489541},{"$f":"Supply!I49","v":-0.16931380433052176},{"$f":"Supply!J49","v":-0.14566066586554788},{"$f":"Supply!K49","v":-0.12543422580345789},{"$f":"Supply!L49","v":-0.10805907684516289},{"$f":"Supply!M49","v":-9.3069121705201874E-2},{"$f":"Supply!N49","v":-8.0094355448279697E-2}]
[null,"Expected Attrition",null,{"$f":"Supply!E50","v":-1.6875},{"$f":"Supply!F50","v":-1.4578143750000001},{"$f":"Supply!G50","v":-1.2486471684750002},{"$f":"Supply!H50","v":-1.0710770546461708},{"$f":"Supply!I50","v":-0.92018371918761832},{"$f":"Supply!J50","v":-0.79163405361710804},{"$f":"Supply!K50","v":-0.68170774893183639},{"$f":"Supply!L50","v":-0.58727759154979831},{"$f":"Supply!M50","v":-0.50581044405001019},{"$f":"Supply!N50","v":-0.43529541004499833}]
[null,"Capacity Gain",null,{"$f":"Supply!E51","v":0.16051499999999999},{"$f":"Supply!F51","v":5.2714567800000021E-2},{"$f":"Supply!G51","v":5.7837336843762008E-2},{"$f":"Supply!H51","v":6.1008549032645867E-2},{"$f":"Supply!I51","v":6.1100198954057869E-2},{"$f":"Supply!J51","v":5.7884282000482956E-2},{"$f":"Supply!K51","v":5.1700715678990448E-2},{"$f":"Supply!L51","v":4.3599488396657012E-2},{"$f":"Supply!M51","v":3.4759293715116699E-2},{"$f":"Supply!N51","v":2.6431137297932297E-2}]
[null,"Total Supply",{"$f":"SUM(C62:C65)","v":13.5},{"$f":"SUM(D62:D65)","v":11.662515000000001},{"$f":"SUM(E62:E65)","v":9.9891773478000019},{"$f":"SUM(F62:F65)","v":8.5686164371693661},{"$f":"SUM(G62:G65)","v":7.3614697535009466},{"$f":"SUM(H62:H65)","v":6.3330724289368643},{"$f":"SUM(I62:I65)","v":5.4536619914546911},{"$f":"SUM(J62:J65)","v":4.6982207323983864},{"$f":"SUM(K62:K65)","v":4.0464835524000815},{"$f":"SUM(L62:L65)","v":3.4823632803599867},{"$f":"SUM(M62:M65)","v":2.9934046521646409}]
[null,"Growth Driver 1",null,{"$f":"Demand!E36","v":0.27},{"$f":"Demand!F36","v":0.23325030000000002},{"$f":"Demand!G36","v":0.19978354695600004},{"$f":"Demand!H36","v":0.17137232874338731},{"$f":"Demand!I36","v":0.14722939507001895},{"$f":"Demand!J36","v":0.12666144857873729},{"$f":"Demand!K36","v":0.10907323982909382},{"$f":"Demand!L36","v":9.3964414647967731E-2},{"$f":"Demand!M36","v":8.0929671048001625E-2},{"$f":"Demand!N36","v":6.9647265607199735E-2}]
[null,"Growth Driver 2",null,{"$f":"Demand!E52","v":0.54},{"$f":"Demand!F52","v":0.46650060000000004},{"$f":"Demand!G52","v":0.39956709391200007},{"$f":"Demand!H52","v":0.34274465748677463},{"$f":"Demand!I52","v":0.2944587901400379},{"$f":"Demand!J52","v":0.25332289715747458},{"$f":"Demand!K52","v":0.21814647965818765},{"$f":"Demand!L52","v":0.18792882929593546},{"$f":"Demand!M52","v":0.16185934209600325},{"$f":"Demand!N52","v":0.13929453121439947}]
[null,"Growth Driver 3",null,{"$f":"Demand!E68","v":0.67500000000000004},{"$f":"Demand!F68","v":0.58312575000000011},{"$f":"Demand!G68","v":0.49945886739000012},{"$f":"Demand!H68","v":0.42843082185846831},{"$f":"Demand!I68","v":0.36807348767504733},{"$f":"Demand!J68","v":0.31665362144684323},{"$f":"Demand!K68","v":0.27268309957273457},{"$f":"Demand!L68","v":0.23491103661991933},{"$f":"Demand!M68","v":0.2023241776200041},{"$f":"Demand!N68","v":0.17411816401799934}]
[null,"Faethm Automation",null,{"$f":"Demand!E20","v":-2.7270000000000003},{"$f":"Demand!F20","v":-0.62977580999999994},{"$f":"Demand!G20","v":-0.59935064086800005},{"$f":"Demand!H20","v":-0.52268560266733133},{"$f":"Demand!I20","v":-0.42696524570305489},{"$f":"Demand!J20","v":-0.32931976630471688},{"$f":"Demand!K20","v":-0.23996112762400662},{"$f":"Demand!L20","v":-0.16443772563394315},{"$f":"Demand!M20","v":-0.11330153946720238},{"$f":"Demand!N20","v":-7.6611992167919779E-2}]
[null,"Total Demand",{"$f":"SUM(C66:C70)","v":13.5},{"$f":"C71+SUM(D67:D70)","v":12.257999999999999},{"$f":"D71+SUM(E67:E70)","v":12.91110084},{"$f":"E71+SUM(F67:F70)","v":13.41055970739},{"$f":"F71+SUM(G67:G70)","v":13.8304219128113},{"$f":"G71+SUM(H67:H70)","v":14.213218339993348},{"$f":"H71+SUM(I67:I70)","v":14.580536540871687},{"$f":"I71+SUM(J67:J70)","v":14.940478232307697},{"$f":"J71+SUM(K67:K70)","v":15.292844787237577},{"$f":"K71+SUM(L67:L70)","v":15.624656438534384},{"$f":"L71+SUM(M67:M70)","v":15.931104407206062}]
[null,"Gap",{"$f":"C66-C71","v":0},-0.59548499999999827,-2.9219234921999977,-4.841943270220634,-6.4689521593103532,-7.8801459110564842,-9.1268745494169963,-10.242257499909311,-11.246361234837496,-12.142293158174397,-12.937699755041422]

{"sheet":"Supply","index":4,"n_rows":52,"n_cols":14,"rows_kept":52,"cut":false,"hidden":false,"merged":[[4,3,4,4],[3,3,3,4]]}
[]
[null,"Supply Inputs",null,null,null,null,"You can calculate your attrition rate clicking","here"]
[]
[null,{"$f":"Company_Name","v":"Global European Bank"}]
[null,"Critical Role",null,{"$f":"'Summary Output'!E7","v":"Client Service Representative"}]
[null,"Attrition Rate",null,null,{"$f":"'Summary Output'!E9","v":0.125}]
[null,"Retirement Rate",null,null,{"$f":"'Summary Output'!E10","v":2.3E-2}]
[]
[null,null,null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"Faethm Capacity Gain (Cumulative)",null,null,{"$f":"Augmentation","v":1.189E-2},1.6410000000000001E-2,2.2200000000000001E-2,2.9319999999999999E-2,3.7620000000000001E-2,4.6760000000000003E-2,5.6239999999999998E-2,6.5519999999999995E-2,7.4109999999999995E-2,8.1699999999999995E-2]
[]
[null,{"$f":"Company_Name","v":"Global European Bank"},null,"Current","Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"FTE affected by attrition",null,{"$f":"D20+D27+D34+D41+D48","v":306},306,264.35034000000002,226.42135321680001,194.22197257583889,166.85998107935472,143.54964172256885,123.61633847297296,106.49300326769674,91.720293854401831,78.93356768815967]
[null,"Predicted Retirement",null,null,{"$f":"-E13*'Summary Output'!$E$10","v":-7.0380000000000003},{"$f":"-F13*'Summary Output'!$E$10","v":-6.0800578200000004},{"$f":"-G13*'Summary Output'!$E$10","v":-5.2076911239864003},{"$f":"-H13*'Summary Output'!$E$10","v":-4.4671053692442948},{"$f":"-I13*'Summary Output'!$E$10","v":-3.8377795648251585},{"$f":"-J13*'Summary Output'!$E$10","v":-3.3016417596190837},{"$f":"-K13*'Summary Output'!$E$10","v":-2.8431757848783779},{"$f":"-L13*'Summary Output'!$E$10","v":-2.4493390751570248},{"$f":"-M13*'Summary Output'!$E$10","v":-2.1095667586512419},{"$f":"-N13*'Summary Output'!$E$10","v":-1.8154720568276723}]
[null,"Expected Attrition",null,null,{"$f":"-E13*'Summary Output'!$E$9","v":-38.25},{"$f":"-F13*'Summary Output'!$E$9","v":-33.043792500000002},{"$f":"-G13*'Summary Output'!$E$9","v":-28.302669152100002},{"$f":"-H13*'Summary Output'!$E$9","v":-24.277746571979861},{"$f":"-I13*'Summary Output'!$E$9","v":-20.857497634919341},{"$f":"-J13*'Summary Output'!$E$9","v":-17.943705215321106},{"$f":"-K13*'Summary Output'!$E$9","v":-15.452042309121619},{"$f":"-L13*'Summary Output'!$E$9","v":-13.311625408462092},{"$f":"-M13*'Summary Output'!$E$9","v":-11.465036731800229},{"$f":"-N13*'Summary Output'!$E$9","v":-9.8666959610199587}]
[null,"Capacity Gain",null,null,{"$f":"E23+E30+E37+E44+E51","v":3.6383400000000004},{"$f":"F23+F30+F37+F44+F51","v":1.1948635368000005},1.3109796351252718,1.3828604447399726,1.3849378429586443,1.3120437253442796,1.1718828887237829,0.98825507032422533,0.78787732420931178,0.59910577875313187]
[null,"Total supply",null,{"$f":"SUM(D13:D16)","v":306},{"$f":"SUM(E13:E16)","v":264.35034000000002},{"$f":"SUM(F13:F16)","v":226.42135321680004},194.22197257583889,166.8599810793547,143.54964172256885,123.61633847297294,106.49300326769674,91.720293854401845,78.933567688159684,67.850505449065167]
[]
[null,{"$f":"\"BU 1 - \"","v":"BU 1 - "},{"$f":"'Summary Output'!E17","v":"Banking"},{"$f":"D12","v":"Current"},{"$f":"E12","v":"Year 1"},{"$f":"F12","v":"Year 2"},"Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"FTE affected by attrition",null,{"$f":"'Summary Output by BU'!C6","v":140.6},{"$f":"D24","v":140.6},121.46293399999999,104.03543222967998,89.240553412297203,76.668344247572776,65.957776556186857,56.798879703594757,48.931098887052812,42.143376849440841,36.268168682860292]
[null,"Predicted Retirement",null,null,{"$f":"-E20*'Summary Output'!$E$10","v":-3.2338},{"$f":"-F20*'Summary Output'!$E$10","v":-2.7936474819999999},{"$f":"-G20*'Summary Output'!$E$10","v":-2.3928149412826394},{"$f":"-H20*'Summary Output'!$E$10","v":-2.0525327284828356},{"$f":"-I20*'Summary Output'!$E$10","v":-1.7633719176941738},{"$f":"-J20*'Summary Output'!$E$10","v":-1.5170288607922977},{"$f":"-K20*'Summary Output'!$E$10","v":-1.3063742331826793},{"$f":"-L20*'Summary Output'!$E$10","v":-1.1254152744022146},{"$f":"-M20*'Summary Output'!$E$10","v":-0.96929766753713931},{"$f":"-N20*'Summary Output'!$E$10","v":-0.83416787970578665}]
[null,"Expected Attrition",null,null,{"$f":"-E20*'Summary Output'!$E$9","v":-17.574999999999999},{"$f":"-F20*'Summary Output'!$E$9","v":-15.182866749999999},{"$f":"-G20*'Summary Output'!$E$9","v":-13.004429028709998},{"$f":"-H20*'Summary Output'!$E$9","v":-11.15506917653715},{"$f":"-I20*'Summary Output'!$E$9","v":-9.583543030946597},{"$f":"-J20*'Summary Output'!$E$9","v":-8.2447220695233572},{"$f":"-K20*'Summary Output'!$E$9","v":-7.0998599629493446},{"$f":"-L20*'Summary Output'!$E$9","v":-6.1163873608816015},{"$f":"-M20*'Summary Output'!$E$9","v":-5.2679221061801051},{"$f":"-N20*'Summary Output'!$E$9","v":-4.5335210853575365}]
[null,"Capacity Gain",null,null,{"$f":"E20*$E$10","v":1.6717339999999998},{"$f":"F20*(F10-E10)","v":0.54901246168000017},{"$f":"G20*(G10-F10)","v":0.60236515260984713},{"$f":"H20*(H10-G10)","v":0.63539274029555592},0.63634725725485419,0.60285407772354804,0.538453379590078,0.45408059767184994,0.36201160713669683,0.27527540030290959]
[null,"Total Supply",null,{"$f":"SUM(D20:D23)","v":140.6},{"$f":"SUM(E20:E23)","v":121.46293399999999},{"$f":"SUM(F20:F23)","v":104.03543222967998},89.240553412297203,76.668344247572776,65.957776556186857,56.798879703594757,48.931098887052812,42.143376849440841,36.268168682860292,31.175755118099879]
[]
[null,{"$f":"\"BU 2 - \"","v":"BU 2 - "},{"$f":"'Summary Output'!E22","v":"Consulting Services"},{"$f":"D12","v":"Current"},{"$f":"E12","v":"Year 1"},{"$f":"F12","v":"Year 2"},"Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"FTE affected by attrition",null,{"$f":"'Summary Output by BU'!C20","v":67.5},{"$f":"D31","v":67.5},{"$f":"E31","v":58.312575000000002},{"$f":"F31","v":49.945886739000002},42.843082185846818,36.80734876750472,31.665362144684313,27.268309957273448,23.491103661991929,20.232417762000409,17.411816401799932]
[null,"Predicted Retirement",null,null,{"$f":"-E27*'Summary Output'!$E$10","v":-1.5525},{"$f":"-F27*'Summary Output'!$E$10","v":-1.3411892249999999},{"$f":"-G27*'Summary Output'!$E$10","v":-1.148755394997},{"$f":"-H27*'Summary Output'!$E$10","v":-0.98539089027447679},{"$f":"-I27*'Summary Output'!$E$10","v":-0.8465690216526085},{"$f":"-J27*'Summary Output'!$E$10","v":-0.72830332932773922},{"$f":"-K27*'Summary Output'!$E$10","v":-0.62717112901728933},{"$f":"-L27*'Summary Output'!$E$10","v":-0.54029538422581436},{"$f":"-M27*'Summary Output'!$E$10","v":-0.46534560852600942},{"$f":"-N27*'Summary Output'!$E$10","v":-0.40047177724139843}]
[null,"Expected Attrition",null,null,{"$f":"-E27*'Summary Output'!$E$9","v":-8.4375},{"$f":"-F27*'Summary Output'!$E$9","v":-7.2890718750000003},{"$f":"-G27*'Summary Output'!$E$9","v":-6.2432358423750003},{"$f":"-H27*'Summary Output'!$E$9","v":-5.3553852732308522},{"$f":"-I27*'Summary Output'!$E$9","v":-4.60091859593809},{"$f":"-J27*'Summary Output'!$E$9","v":-3.9581702680855391},{"$f":"-K27*'Summary Output'!$E$9","v":-3.4085387446591811},{"$f":"-L27*'Summary Output'!$E$9","v":-2.9363879577489911},{"$f":"-M27*'Summary Output'!$E$9","v":-2.5290522202500512},{"$f":"-N27*'Summary Output'!$E$9","v":-2.1764770502249915}]
[null,"Capacity Gain",null,null,{"$f":"E27*$E$10","v":0.80257499999999993},{"$f":"F27*(F10-E10)","v":0.26357283900000011},{"$f":"G27*(G10-F10)","v":0.28918668421881},0.30504274516322927,0.30550099477028925,0.28942141000241467,0.25850357839495214,0.21799744198328502,0.17379646857558353,0.13215568648966147]
[null,"Total Supply",null,{"$f":"SUM(D27:D30)","v":67.5},{"$f":"SUM(E27:E30)","v":58.312575000000002},{"$f":"SUM(F27:F30)","v":49.945886739000002},{"$f":"SUM(G27:G30)","v":42.843082185846818},{"$f":"SUM(H27:H30)","v":36.80734876750472},{"$f":"SUM(I27:I30)","v":31.665362144684313},{"$f":"SUM(J27:J30)","v":27.268309957273448},{"$f":"SUM(K27:K30)","v":23.491103661991929},{"$f":"SUM(L27:L30)","v":20.232417762000409},{"$f":"SUM(M27:M30)","v":17.411816401799932},{"$f":"SUM(N27:N30)","v":14.967023260823201}]
[]
[null,{"$f":"\"BU 3 - \"","v":"BU 3 - "},{"$f":"'Summary Output'!E27","v":"Retail Banking"},{"$f":"D12","v":"Current"},{"$f":"E12","v":"Year 1"},{"$f":"F12","v":"Year 2"},"Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"FTE affected by attrition",null,{"$f":"'Summary Output'!F27","v":39.200000000000003},{"$f":"D38","v":39.200000000000003},{"$f":"E38","v":33.864488000000001},{"$f":"F38","v":29.005611261760006},24.880723284225116,21.375526987943481,18.389365867727776,15.835818523335098,13.64224094148272,11.749789278080238,10.11175115482307]
[null,"Predicted Retirement",null,null,{"$f":"-E34*'Summary Output'!$E$10","v":-0.90160000000000007},{"$f":"-F34*'Summary Output'!$E$10","v":-0.77888322399999999},{"$f":"-G34*'Summary Output'!$E$10","v":-0.66712905902048014},{"$f":"-H34*'Summary Output'!$E$10","v":-0.57225663553717765},{"$f":"-I34*'Summary Output'!$E$10","v":-0.49163712072270005},{"$f":"-J34*'Summary Output'!$E$10","v":-0.42295541495773881},{"$f":"-K34*'Summary Output'!$E$10","v":-0.36422382603670722},{"$f":"-L34*'Summary Output'!$E$10","v":-0.31377154165410254},{"$f":"-M34*'Summary Output'!$E$10","v":-0.27024515339584548},{"$f":"-N34*'Summary Output'!$E$10","v":-0.2325702765609306}]
[null,"Expected Attrition",null,null,{"$f":"-E34*'Summary Output'!$E$9","v":-4.9000000000000004},{"$f":"-F34*'Summary Output'!$E$9","v":-4.2330610000000002},{"$f":"-G34*'Summary Output'!$E$9","v":-3.6257014077200007},{"$f":"-H34*'Summary Output'!$E$9","v":-3.1100904105281395},{"$f":"-I34*'Summary Output'!$E$9","v":-2.6719408734929351},{"$f":"-J34*'Summary Output'!$E$9","v":-2.2986707334659719},{"$f":"-K34*'Summary Output'!$E$9","v":-1.9794773154168872},{"$f":"-L34*'Summary Output'!$E$9","v":-1.70528011768534},{"$f":"-M34*'Summary Output'!$E$9","v":-1.4687236597600297},{"$f":"-N34*'Summary Output'!$E$9","v":-1.2639688943528837}]
[null,"Capacity Gain",null,null,{"$f":"E34*$E$10","v":0.466088},{"$f":"F34*(F10-E10)","v":0.15306748576000007},{"$f":"G34*(G10-F10)","v":0.16794248920559043},0.17715074978368278,0.17741687399993092,0.1680788040310319,0.15012355960121665,0.12659999593695959,0.10093068989870925,7.6748191265107096E-2]
[null,"Total Supply",null,{"$f":"SUM(D34:D37)","v":39.200000000000003},{"$f":"SUM(E34:E37)","v":33.864488000000001},{"$f":"SUM(F34:F37)","v":29.005611261760006},{"$f":"SUM(G34:G37)","v":24.880723284225116},{"$f":"SUM(H34:H37)","v":21.375526987943481},{"$f":"SUM(I34:I37)","v":18.389365867727776},{"$f":"SUM(J34:J37)","v":15.835818523335098},{"$f":"SUM(K34:K37)","v":13.64224094148272},{"$f":"SUM(L34:L37)","v":11.749789278080238},{"$f":"SUM(M34:M37)","v":10.11175115482307},{"$f":"SUM(N34:N37)","v":8.691960175174362}]
[]
[null,{"$f":"\"BU 4 - \"","v":"BU 4 - "},{"$f":"'Summary Output'!E32","v":"Financial Services"},{"$f":"D12","v":"Current"},{"$f":"E12","v":"Year 1"},{"$f":"F12","v":"Year 2"},"Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"FTE affected by attrition",null,{"$f":"'Summary Output'!F32","v":45.2},{"$f":"D45","v":45.2},{"$f":"E45","v":39.047828000000003},{"$f":"F45","v":33.445245638560003},28.688997256300386,24.647291322832789,21.204064725033046,18.259668297314956,15.730339044770886,13.548226412480268,11.659468168316392]
[null,"Predicted Retirement",null,null,{"$f":"-E41*'Summary Output'!$E$10","v":-1.0396000000000001},{"$f":"-F41*'Summary Output'!$E$10","v":-0.8981000440000001},{"$f":"-G41*'Summary Output'!$E$10","v":-0.76924064968688011},{"$f":"-H41*'Summary Output'!$E$10","v":-0.65984693689490881},{"$f":"-I41*'Summary Output'!$E$10","v":-0.56688770042515413},{"$f":"-J41*'Summary Output'!$E$10","v":-0.48769348867576007},{"$f":"-K41*'Summary Output'!$E$10","v":-0.41997237083824401},{"$f":"-L41*'Summary Output'!$E$10","v":-0.36179779802973039},{"$f":"-M41*'Summary Output'!$E$10","v":-0.31160920748704618},{"$f":"-N41*'Summary Output'!$E$10","v":-0.268167767871277}]
[null,"Expected Attrition",null,null,{"$f":"-E41*'Summary Output'!$E$9","v":-5.65},{"$f":"-F41*'Summary Output'!$E$9","v":-4.8809785000000003},{"$f":"-G41*'Summary Output'!$E$9","v":-4.1806557048200004},{"$f":"-H41*'Summary Output'!$E$9","v":-3.5861246570375482},{"$f":"-I41*'Summary Output'!$E$9","v":-3.0809114153540986},{"$f":"-J41*'Summary Output'!$E$9","v":-2.6505080906291307},{"$f":"-K41*'Summary Output'!$E$9","v":-2.2824585371643695},{"$f":"-L41*'Summary Output'!$E$9","v":-1.9662923805963608},{"$f":"-M41*'Summary Output'!$E$9","v":-1.6935283015600335},{"$f":"-N41*'Summary Output'!$E$9","v":-1.457433521039549}]
[null,"Capacity Gain",null,null,{"$f":"E41*$E$10","v":0.53742800000000002},{"$f":"F41*(F10-E10)","v":0.17649618256000008},{"$f":"G41*(G10-F10)","v":0.19364797224726241},{"$f":"H41*(H10-G10)","v":0.20426566046485869},{"$f":"I41*(I10-H10)","v":0.2045725179795122},0.19380515158680209,0.17310165545854569,0.14597754633547377,0.1163792648832055,8.8495363397521412E-2]
[null,"Total supply",null,{"$f":"SUM(D41:D44)","v":45.2},{"$f":"SUM(E41:E44)","v":39.047828000000003},{"$f":"SUM(F41:F44)","v":33.445245638560003},{"$f":"SUM(G41:G44)","v":28.688997256300386},{"$f":"SUM(H41:H44)","v":24.647291322832789},{"$f":"SUM(I41:I44)","v":21.204064725033046},{"$f":"SUM(J41:J44)","v":18.259668297314956},{"$f":"SUM(K41:K44)","v":15.730339044770886},{"$f":"SUM(L41:L44)","v":13.548226412480268},{"$f":"SUM(M41:M44)","v":11.659468168316392},{"$f":"SUM(N41:N44)","v":10.022362242803087}]
[]
[null,{"$f":"\"BU 5 - \"","v":"BU 5 - "},{"$f":"'Summary Output'!E37","v":"Insurance"},{"$f":"D12","v":"Current"},{"$f":"E12","v":"Year 1"},{"$f":"F12","v":"Year 2"},"Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"FTE affected by attrition",null,{"$f":"'Summary Output'!F37","v":13.5},{"$f":"D52","v":13.5},{"$f":"E52","v":11.662515000000001},{"$f":"F52","v":9.9891773478000019},8.5686164371693661,7.3614697535009466,6.3330724289368643,5.4536619914546911,4.6982207323983864,4.0464835524000815,3.4823632803599867]
[null,"Predicted Retirement",null,null,{"$f":"-E48*'Summary Output'!$E$10","v":-0.3105},{"$f":"-F48*'Summary Output'!$E$10","v":-0.26823784500000003},{"$f":"-G48*'Summary Output'!$E$10","v":-0.22975107899940003},{"$f":"-H48*'Summary Output'!$E$10","v":-0.19707817805489541},{"$f":"-I48*'Summary Output'!$E$10","v":-0.16931380433052176},{"$f":"-J48*'Summary Output'!$E$10","v":-0.14566066586554788},{"$f":"-K48*'Summary Output'!$E$10","v":-0.12543422580345789},{"$f":"-L48*'Summary Output'!$E$10","v":-0.10805907684516289},{"$f":"-M48*'Summary Output'!$E$10","v":-9.3069121705201874E-2},{"$f":"-N48*'Summary Output'!$E$10","v":-8.0094355448279697E-2}]
[null,"Expected Attrition",null,null,{"$f":"-E48*'Summary Output'!$E$9","v":-1.6875},{"$f":"-F48*'Summary Output'!$E$9","v":-1.4578143750000001},{"$f":"-G48*'Summary Output'!$E$9","v":-1.2486471684750002},{"$f":"-H48*'Summary Output'!$E$9","v":-1.0710770546461708},{"$f":"-I48*'Summary Output'!$E$9","v":-0.92018371918761832},{"$f":"-J48*'Summary Output'!$E$9","v":-0.79163405361710804},{"$f":"-K48*'Summary Output'!$E$9","v":-0.68170774893183639},{"$f":"-L48*'Summary Output'!$E$9","v":-0.58727759154979831},{"$f":"-M48*'Summary Output'!$E$9","v":-0.50581044405001019},{"$f":"-N48*'Summary Output'!$E$9","v":-0.43529541004499833}]
[null,"Capacity Gain",null,null,{"$f":"E48*$E$10","v":0.16051499999999999},{"$f":"F48*(F10-E10)","v":5.2714567800000021E-2},{"$f":"G48*(G10-F10)","v":5.7837336843762008E-2},6.1008549032645867E-2,6.1100198954057869E-2,5.7884282000482956E-2,5.1700715678990448E-2,4.3599488396657012E-2,3.4759293715116699E-2,2.6431137297932297E-2]
[null,"Total supply",null,{"$f":"SUM(D48:D51)","v":13.5},{"$f":"SUM(E48:E51)","v":11.662515000000001},{"$f":"SUM(F48:F51)","v":9.9891773478000019},{"$f":"SUM(G48:G51)","v":8.5686164371693661},{"$f":"SUM(H48:H51)","v":7.3614697535009466},{"$f":"SUM(I48:I51)","v":6.3330724289368643},{"$f":"SUM(J48:J51)","v":5.4536619914546911},{"$f":"SUM(K48:K51)","v":4.6982207323983864},{"$f":"SUM(L48:L51)","v":4.0464835524000815},{"$f":"SUM(M48:M51)","v":3.4823632803599867},{"$f":"SUM(N48:N51)","v":2.9934046521646409}]

{"sheet":"Demand","index":5,"n_rows":68,"n_cols":14,"rows_kept":68,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Demand Inputs"]
[]
[]
[null,{"$f":"Company_Name","v":"Global European Bank"},null,"Current",{"$f":"Supply!E12","v":"Year 1"},{"$f":"Supply!F12","v":"Year 2"},{"$f":"Supply!G12","v":"Year 3"},{"$f":"Supply!H12","v":"Year 4"},{"$f":"Supply!I12","v":"Year 5"},{"$f":"Supply!J12","v":"Year 6"},{"$f":"Supply!K12","v":"Year 7"},{"$f":"Supply!L12","v":"Year 8"},{"$f":"Supply!M12","v":"Year 9"},{"$f":"Supply!N12","v":"Year 10"}]
[null,"FTE affected by attrition",null,{"$f":"Supply!D13","v":306},{"$f":"D11","v":306},{"$f":"E11","v":269.35199999999998},{"$f":"F11","v":278.07901677999996},284.19535307310468,289.24766320939119,294.08878383691575,299.11489776311055,304.43201621729776,309.97104445262022,315.38374074811958]
[null,"Growth Driver 1",null,null,{"$f":"SUM(E32:E36)","v":6.1199999999999992},{"$f":"SUM(F32:F36)","v":6.5500139799999992},5.6102179741495997,4.8123888760457856,4.1344195311884553,3.5568411226814276,3.0629381643858857,2.6386599698551523,2.2726250588368453,1.9557983993844006]
[null,"Growth Driver 2",null,null,{"$f":"SUM(E48:E52)","v":12.239999999999998},{"$f":"SUM(F48:F52)","v":10.574013599999999},9.0568541286719988,7.7688789030335563,6.6743992431741876,5.7419856689027533,4.944653538918919,4.2597201307078691,3.6688117541760734,3.1573427075263867]
[null,"Growth Driver 3",null,null,{"$f":"SUM(E64:E68)","v":6.8039999999999994},{"$f":"SUM(F64:F68)","v":5.8779075599999988},5.0345453832912002,4.318582684333359,3.7101807557644753,3.1918685041841779,2.7486456436931634,2.3679032491287866,2.0394277104096408,1.7551110933014329]
[null,"Faethm Automation",null,null,{"$f":"SUM(E16:E20)","v":-61.811999999999998},{"$f":"SUM(F16:F20)","v":-14.274918359999997},-13.585281193008001,-11.847540327126172,-9.6778789026025738,-7.4645813695735788,-5.4391188928108143,-3.7272551143693771,-2.5681682279232536,-1.7365384891395144]
[null,"Total Demand",null,{"$f":"SUM(D6:D10)","v":306},{"$f":"SUM(E6:E10)","v":269.35199999999998},{"$f":"SUM(F6:F10)","v":278.07901677999996},284.19535307310468,289.24766320939119,294.08878383691575,299.11489776311055,304.43201621729776,309.97104445262022,315.38374074811958,320.51545445919226]
[]
[null,"Automation",null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"Faethm Automation Rate (Cumulative)",null,null,{"$f":"Automation","v":0.20200000000000001},0.25600000000000001,0.316,0.377,0.435,0.48699999999999999,0.53100000000000003,0.56599999999999995,0.59399999999999997,0.61599999999999999]
[]
[null,"BU1",{"$f":"'Summary Output'!E17","v":"Banking"},null,{"$f":"-Supply!E20*Demand!E14","v":-28.401199999999999},{"$f":"-Supply!F20*(Demand!$F$14-$E$14)","v":-6.5589984359999987},{"$f":"-Supply!G20*(Demand!G14-F14)","v":-6.2421259337807991},{"$f":"-Supply!H20*(Demand!H14-G14)","v":-5.4436737581501289},{"$f":"-Supply!I20*(Demand!I14-H14)","v":-4.4467639663592209},{"$f":"-Supply!J20*(Demand!J14-I14)","v":-3.4298043809217158},{"$f":"-Supply!K20*(Demand!K14-J14)","v":-2.4991507069581713},{"$f":"-Supply!L20*(Demand!L14-K14)","v":-1.7125884610468445},{"$f":"-Supply!M20*(Demand!M14-L14)","v":-1.1800145517843446},{"$f":"-Supply!N20*(Demand!N14-M14)","v":-0.79789971102292712}]
[null,"BU2",{"$f":"'Summary Output'!E22","v":"Consulting Services"},null,{"$f":"-Supply!E27*Demand!$E$14","v":-13.635000000000002},{"$f":"-Supply!F27*(Demand!F14-E14)","v":-3.1488790499999997},{"$f":"-Supply!G27*(Demand!G14-F14)","v":-2.99675320434},{"$f":"-Supply!H27*(Demand!H14-G14)","v":-2.6134280133366556},{"$f":"-Supply!I27*(Demand!I14-H14)","v":-2.1348262285152737},{"$f":"-Supply!J27*(Demand!J14-I14)","v":-1.646598831523584},{"$f":"-Supply!K27*(Demand!K14-J14)","v":-1.1998056381200328},{"$f":"-Supply!L27*(Demand!L14-K14)","v":-0.82218862816971561},{"$f":"-Supply!M27*(Demand!M14-L14)","v":-0.56650769733601192},{"$f":"-Supply!N27*(Demand!N14-M14)","v":-0.38305996083959887}]
[null,"BU3",{"$f":"'Summary Output'!E27","v":"Retail Banking"},null,{"$f":"-Supply!E34*Demand!$E$14","v":-7.918400000000001},{"$f":"-Supply!F34*(Demand!F14-E14)","v":-1.8286823519999997},{"$f":"-Supply!G34*(Demand!G14-F14)","v":-1.7403366757056002},{"$f":"-Supply!H34*(Demand!H14-G14)","v":-1.5177241203377321},{"$f":"-Supply!I34*(Demand!I14-H14)","v":-1.2397805653007219},{"$f":"-Supply!J34*(Demand!J14-I14)","v":-0.95624702512184412},{"$f":"-Supply!K34*(Demand!K14-J14)","v":-0.69677601502674491},{"$f":"-Supply!L34*(Demand!L14-K14)","v":-0.47747843295189413},{"$f":"-Supply!M34*(Demand!M14-L14)","v":-0.32899409978624694},{"$f":"-Supply!N34*(Demand!N14-M14)","v":-0.22245852540610772}]
[null,"BU4",{"$f":"'Summary Output'!E32","v":"Financial Services"},null,{"$f":"-Supply!E41*Demand!$E$14","v":-9.1304000000000016},{"$f":"-Supply!F41*(Demand!F14-E14)","v":-2.108582712},{"$f":"-Supply!G41*(Demand!G14-F14)","v":-2.0067147383136001},{"$f":"-Supply!H41*(Demand!H14-G14)","v":-1.7500288326343234},{"$f":"-Supply!I41*(Demand!I14-H14)","v":-1.4295428967243016},{"$f":"-Supply!J41*(Demand!J14-I14)","v":-1.1026113657017182},{"$f":"-Supply!K41*(Demand!K14-J14)","v":-0.80342540508185878},{"$f":"-Supply!L41*(Demand!L14-K14)","v":-0.55056186656697981},{"$f":"-Supply!M41*(Demand!M14-L14)","v":-0.37935033954944786},{"$f":"-Supply!N41*(Demand!N14-M14)","v":-0.25650829970296085}]
[null,"BU5",{"$f":"'Summary Output'!E37","v":"Insurance"},null,{"$f":"-Supply!E48*Demand!$E$14","v":-2.7270000000000003},{"$f":"-Supply!F48*(Demand!F14-E14)","v":-0.62977580999999994},{"$f":"-Supply!G48*(Demand!G14-F14)","v":-0.59935064086800005},{"$f":"-Supply!H48*(Demand!H14-G14)","v":-0.52268560266733133},{"$f":"-Supply!I48*(Demand!I14-H14)","v":-0.42696524570305489},{"$f":"-Supply!J48*(Demand!J14-I14)","v":-0.32931976630471688},{"$f":"-Supply!K48*(Demand!K14-J14)","v":-0.23996112762400662},{"$f":"-Supply!L48*(Demand!L14-K14)","v":-0.16443772563394315},{"$f":"-Supply!M48*(Demand!M14-L14)","v":-0.11330153946720238},{"$f":"-Supply!N48*(Demand!N14-M14)","v":-7.6611992167919779E-2}]
[]
[null,"Growth Driver #1"]
[]
[null,"% Change year on year",null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"BU1",{"$f":"$C$16","v":"Banking"},null,{"$f":"GD1_BU1","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"BU2",{"$f":"$C$17","v":"Consulting Services"},null,{"$f":"GD1_BU2","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"BU3",{"$f":"$C$18","v":"Retail Banking"},null,{"$f":"GD1_BU3","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"BU4",{"$f":"$C$19","v":"Financial Services"},null,{"$f":"GD1_BU4","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"BU5",{"$f":"$C$20","v":"Insurance"},null,{"$f":"GD1_BU5","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"Total % Change Year on Year",null,null,{"$f":"SUM(E25:E29)","v":0.1},0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[]
[null,"BU1",{"$f":"$C$16","v":"Banking"},null,{"$f":"Supply!E20*Demand!E25","v":2.8119999999999998},{"$f":"Supply!F20*Demand!F25","v":2.4292586799999998},{"$f":"Supply!G20*Demand!G25","v":2.0807086445935998},{"$f":"Supply!H20*Demand!H25","v":1.7848110682459442},{"$f":"Supply!I20*Demand!I25","v":1.5333668849514555},{"$f":"Supply!J20*Demand!J25","v":1.3191555311237371},{"$f":"Supply!K20*Demand!K25","v":1.1359775940718952},{"$f":"Supply!L20*Demand!L25","v":0.9786219777410563},{"$f":"Supply!M20*Demand!M25","v":0.84286753698881689},{"$f":"Supply!N20*Demand!N25","v":0.72536337365720582}]
[null,"BU2",{"$f":"$C$17","v":"Consulting Services"},null,{"$f":"Supply!E27*Demand!E26","v":1.35},{"$f":"Supply!F20*Demand!F26","v":2.4292586799999998},{"$f":"Supply!G20*Demand!G26","v":2.0807086445935998},{"$f":"Supply!H20*Demand!H26","v":1.7848110682459442},{"$f":"Supply!I20*Demand!I26","v":1.5333668849514555},{"$f":"Supply!J20*Demand!J26","v":1.3191555311237371},{"$f":"Supply!K20*Demand!K26","v":1.1359775940718952},{"$f":"Supply!L20*Demand!L26","v":0.9786219777410563},{"$f":"Supply!M20*Demand!M26","v":0.84286753698881689},{"$f":"Supply!N20*Demand!N26","v":0.72536337365720582}]
[null,"BU3",{"$f":"$C$18","v":"Retail Banking"},null,{"$f":"Supply!E34*Demand!E27","v":0.78400000000000003},{"$f":"Supply!F34*Demand!F27","v":0.67728976000000007},{"$f":"Supply!G34*Demand!G27","v":0.58011222523520012},{"$f":"Supply!H34*Demand!H27","v":0.49761446568450235},{"$f":"Supply!I34*Demand!I27","v":0.4275105397588696},{"$f":"Supply!J34*Demand!J27","v":0.3677873173545555},{"$f":"Supply!K34*Demand!K27","v":0.31671637046670198},{"$f":"Supply!L34*Demand!L27","v":0.27284481882965439},{"$f":"Supply!M34*Demand!M27","v":0.23499578556160475},{"$f":"Supply!N34*Demand!N27","v":0.20223502309646141}]
[null,"BU4",{"$f":"$C$19","v":"Financial Services"},null,{"$f":"Supply!E41*Demand!E28","v":0.90400000000000003},{"$f":"Supply!F41*Demand!F28","v":0.78095656000000002},{"$f":"Supply!G41*Demand!G28","v":0.66890491277120012},{"$f":"Supply!H41*Demand!H28","v":0.57377994512600772},{"$f":"Supply!I41*Demand!I28","v":0.4929458264566558},{"$f":"Supply!J41*Demand!J28","v":0.4240812945006609},{"$f":"Supply!K41*Demand!K28","v":0.36519336594629914},{"$f":"Supply!L41*Demand!L28","v":0.31460678089541771},{"$f":"Supply!M41*Demand!M28","v":0.27096452824960537},{"$f":"Supply!N41*Demand!N28","v":0.23318936336632784}]
[null,"BU5",{"$f":"$C$20","v":"Insurance"},null,{"$f":"Supply!E48*Demand!E29","v":0.27},{"$f":"Supply!F48*Demand!F29","v":0.23325030000000002},{"$f":"Supply!G48*Demand!G29","v":0.19978354695600004},{"$f":"Supply!H48*Demand!H29","v":0.17137232874338731},{"$f":"Supply!I48*Demand!I29","v":0.14722939507001895},{"$f":"Supply!J48*Demand!J29","v":0.12666144857873729},{"$f":"Supply!K48*Demand!K29","v":0.10907323982909382},{"$f":"Supply!L48*Demand!L29","v":9.3964414647967731E-2},{"$f":"Supply!M48*Demand!M29","v":8.0929671048001625E-2},{"$f":"Supply!N48*Demand!N29","v":6.9647265607199735E-2}]
[]
[null,"Growth Driver #2"]
[]
[null,"% Change year on year",null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"BU1",{"$f":"$C$16","v":"Banking"},null,{"$f":"GD2_BU1","v":0.04},0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,"BU2",{"$f":"$C$17","v":"Consulting Services"},null,{"$f":"GD2_BU2","v":0.04},0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,"BU3",{"$f":"$C$18","v":"Retail Banking"},null,{"$f":"GD2_BU3","v":0.04},0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,"BU4",{"$f":"$C$19","v":"Financial Services"},null,{"$f":"GD2_BU4","v":0.04},0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,"BU5",{"$f":"$C$20","v":"Insurance"},null,{"$f":"GD2_BU5","v":0.04},0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04,0.04]
[null,"Total % Change Year on Year",null,null,{"$f":"SUM(E41:E45)","v":0.2},0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2,0.2]
[]
[null,"BU1",{"$f":"$C$16","v":"Banking"},null,{"$f":"Supply!E20*Demand!E41","v":5.6239999999999997},{"$f":"Supply!F20*Demand!F41","v":4.8585173599999996},{"$f":"Supply!G20*Demand!G41","v":4.1614172891871997},{"$f":"Supply!H20*Demand!H41","v":3.5696221364918883},{"$f":"Supply!I20*Demand!I41","v":3.0667337699029109},{"$f":"Supply!J20*Demand!J41","v":2.6383110622474741},{"$f":"Supply!K20*Demand!K41","v":2.2719551881437905},{"$f":"Supply!L20*Demand!L41","v":1.9572439554821126},{"$f":"Supply!M20*Demand!M41","v":1.6857350739776338},{"$f":"Supply!N20*Demand!N41","v":1.4507267473144116}]
[null,"BU2",{"$f":"$C$17","v":"Consulting Services"},null,{"$f":"Supply!E27*Demand!E42","v":2.7},{"$f":"Supply!F27*Demand!F42","v":2.332503},{"$f":"Supply!G27*Demand!G42","v":1.9978354695600002},{"$f":"Supply!H27*Demand!H42","v":1.7137232874338728},{"$f":"Supply!I27*Demand!I42","v":1.4722939507001889},{"$f":"Supply!J27*Demand!J42","v":1.2666144857873725},{"$f":"Supply!K27*Demand!K42","v":1.090732398290938},{"$f":"Supply!L27*Demand!L42","v":0.9396441464796772},{"$f":"Supply!M27*Demand!M42","v":0.80929671048001639},{"$f":"Supply!N27*Demand!N42","v":0.69647265607199726}]
[null,"BU3",{"$f":"$C$18","v":"Retail Banking"},null,{"$f":"Supply!E34*Demand!E43","v":1.5680000000000001},{"$f":"Supply!F34*Demand!F43","v":1.3545795200000001},{"$f":"Supply!G34*Demand!G43","v":1.1602244504704002},{"$f":"Supply!H34*Demand!H43","v":0.9952289313690047},{"$f":"Supply!I34*Demand!I43","v":0.8550210795177392},{"$f":"Supply!J34*Demand!J43","v":0.735574634709111},{"$f":"Supply!K34*Demand!K43","v":0.63343274093340396},{"$f":"Supply!L34*Demand!L43","v":0.54568963765930878},{"$f":"Supply!M34*Demand!M43","v":0.4699915711232095},{"$f":"Supply!N34*Demand!N43","v":0.40447004619292282}]
[null,"BU4",{"$f":"$C$19","v":"Financial Services"},null,{"$f":"Supply!E41*Demand!E44","v":1.8080000000000001},{"$f":"Supply!F41*Demand!F44","v":1.56191312},{"$f":"Supply!G41*Demand!G44","v":1.3378098255424002},{"$f":"Supply!H41*Demand!H44","v":1.1475598902520154},{"$f":"Supply!I41*Demand!I44","v":0.9858916529133116},{"$f":"Supply!J41*Demand!J44","v":0.8481625890013218},{"$f":"Supply!K41*Demand!K44","v":0.73038673189259828},{"$f":"Supply!L41*Demand!L44","v":0.62921356179083543},{"$f":"Supply!M41*Demand!M44","v":0.54192905649921075},{"$f":"Supply!N41*Demand!N44","v":0.46637872673265568}]
[null,"BU5",{"$f":"$C$20","v":"Insurance"},null,{"$f":"Supply!E48*Demand!E45","v":0.54},{"$f":"Supply!F48*Demand!F45","v":0.46650060000000004},{"$f":"Supply!G48*Demand!G45","v":0.39956709391200007},{"$f":"Supply!H48*Demand!H45","v":0.34274465748677463},{"$f":"Supply!I48*Demand!I45","v":0.2944587901400379},{"$f":"Supply!J48*Demand!J45","v":0.25332289715747458},{"$f":"Supply!K48*Demand!K45","v":0.21814647965818765},{"$f":"Supply!L48*Demand!L45","v":0.18792882929593546},{"$f":"Supply!M48*Demand!M45","v":0.16185934209600325},{"$f":"Supply!N48*Demand!N45","v":0.13929453121439947}]
[]
[null,"Growth Driver #3"]
[]
[null,"% Change year on year",null,null,"Year 1","Year 2","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10"]
[null,"BU1",{"$f":"$C$16","v":"Banking"},null,{"$f":"GD3_BU1","v":0.03},0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
[null,"BU2",{"$f":"$C$17","v":"Consulting Services"},null,{"$f":"GD3_BU2","v":0.01},0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"BU3",{"$f":"$C$18","v":"Retail Banking"},null,{"$f":"GD3_BU3","v":0.02},0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02,0.02]
[null,"BU4",{"$f":"$C$19","v":"Financial Services"},null,{"$f":"GD3_BU4","v":0.01},0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01,0.01]
[null,"BU5",{"$f":"$C$20","v":"Insurance"},null,{"$f":"GD3_BU5","v":0.05},0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
[null,"Total % Change Year on Year",null,null,{"$f":"SUM(E57:E61)","v":0.12},0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12]
[]
[null,"BU1",{"$f":"$C$16","v":"Banking"},null,{"$f":"Supply!E20*Demand!E57","v":4.218},{"$f":"Supply!F20*Demand!F57","v":3.6438880199999995},{"$f":"Supply!G20*Demand!G57","v":3.1210629668903995},{"$f":"Supply!H20*Demand!H57","v":2.6772166023689161},{"$f":"Supply!I20*Demand!I57","v":2.3000503274271833},{"$f":"Supply!J20*Demand!J57","v":1.9787332966856057},{"$f":"Supply!K20*Demand!K57","v":1.7039663911078426},{"$f":"Supply!L20*Demand!L57","v":1.4679329666115843},{"$f":"Supply!M20*Demand!M57","v":1.2643013054832253},{"$f":"Supply!N20*Demand!N57","v":1.0880450604858087}]
[null,"BU2",{"$f":"$C$17","v":"Consulting Services"},null,{"$f":"Supply!E27*Demand!E58","v":0.67500000000000004},{"$f":"Supply!F27*Demand!F58","v":0.58312575},{"$f":"Supply!G27*Demand!G58","v":0.49945886739000006},{"$f":"Supply!H27*Demand!H58","v":0.4284308218584682},{"$f":"Supply!I27*Demand!I58","v":0.36807348767504722},{"$f":"Supply!J27*Demand!J58","v":0.31665362144684311},{"$f":"Supply!K27*Demand!K58","v":0.27268309957273451},{"$f":"Supply!L27*Demand!L58","v":0.2349110366199193},{"$f":"Supply!M27*Demand!M58","v":0.2023241776200041},{"$f":"Supply!N27*Demand!N58","v":0.17411816401799932}]
[null,"BU3",{"$f":"$C$18","v":"Retail Banking"},null,{"$f":"Supply!E34*Demand!E59","v":0.78400000000000003},{"$f":"Supply!F34*Demand!F59","v":0.67728976000000007},{"$f":"Supply!G34*Demand!G59","v":0.58011222523520012},{"$f":"Supply!H34*Demand!H59","v":0.49761446568450235},{"$f":"Supply!I34*Demand!I59","v":0.4275105397588696},{"$f":"Supply!J34*Demand!J59","v":0.3677873173545555},{"$f":"Supply!K34*Demand!K59","v":0.31671637046670198},{"$f":"Supply!L34*Demand!L59","v":0.27284481882965439},{"$f":"Supply!M34*Demand!M59","v":0.23499578556160475},{"$f":"Supply!N34*Demand!N59","v":0.20223502309646141}]
[null,"BU4",{"$f":"$C$19","v":"Financial Services"},null,{"$f":"Supply!E41*Demand!E60","v":0.45200000000000001},{"$f":"Supply!F41*Demand!F60","v":0.39047828000000001},{"$f":"Supply!G41*Demand!G60","v":0.33445245638560006},{"$f":"Supply!H41*Demand!H60","v":0.28688997256300386},{"$f":"Supply!I41*Demand!I60","v":0.2464729132283279},{"$f":"Supply!J41*Demand!J60","v":0.21204064725033045},{"$f":"Supply!K41*Demand!K60","v":0.18259668297314957},{"$f":"Supply!L41*Demand!L60","v":0.15730339044770886},{"$f":"Supply!M41*Demand!M60","v":0.13548226412480269},{"$f":"Supply!N41*Demand!N60","v":0.11659468168316392}]
[null,"BU5",{"$f":"$C$20","v":"Insurance"},null,{"$f":"Supply!E48*Demand!E61","v":0.67500000000000004},{"$f":"Supply!F48*Demand!F61","v":0.58312575000000011},{"$f":"Supply!G48*Demand!G61","v":0.49945886739000012},{"$f":"Supply!H48*Demand!H61","v":0.42843082185846831},{"$f":"Supply!I48*Demand!I61","v":0.36807348767504733},{"$f":"Supply!J48*Demand!J61","v":0.31665362144684323},{"$f":"Supply!K48*Demand!K61","v":0.27268309957273457},{"$f":"Supply!L48*Demand!L61","v":0.23491103661991933},{"$f":"Supply!M48*Demand!M61","v":0.2023241776200041},{"$f":"Supply!N48*Demand!N61","v":0.17411816401799934}]

{"sheet":"Faethm Data","index":6,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Faethm Data "]
[null,"Automation and Augmentation data per Role taken from the Faethm Platform",null,null,null,null,null,null,null,null,null,null,null,"Faethm Data"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Instance","AU Census"]
[null,"Automation",1,2,3,4,5,6,7,8,9,10,null,"Job","Business and Systems Analysts, and Programmers"]
[null,"Business Analyst",1.9E-2,2.4E-2,2.9000000000000001E-2,3.5000000000000003E-2,0.04,4.5999999999999999E-2,5.0999999999999997E-2,5.6000000000000001E-2,0.06,6.4000000000000001E-2,null,"Industry","Financial & Insurance Services"]
[]
[]
[]
[]
[]
[]
[null,"Augmentation",1,2,3,4,5,6,7,8,9,10]
[null,{"$f":"B6","v":"Business Analyst"},4.1000000000000002E-2,5.5E-2,7.1999999999999995E-2,9.1999999999999998E-2,0.114,0.13800000000000001,0.16200000000000001,0.185,0.20599999999999999,0.22600000000000001]
[null,{"$f":"B7","v":0}]
[null,{"$f":"B8","v":0}]
[null,{"$f":"B9","v":0}]
[null,{"$f":"B10","v":0}]
[]
[]
[]
[null,"EXAMPLE"]
[null,"Initial FTE"]
[null,1000,{"$f":"$B$24*C$6","v":19},{"$f":"$B$24*D$6","v":24},29,35,40,46,51,56,60,64,"Cumulative Automated FTEs"]
[null,{"$f":"B24","v":1000},{"$f":"$B$24-C24","v":981},{"$f":"$B$24-D24","v":976},971,965,960,954,949,944,940,936]
[null,null,{"$f":"C24","v":19},{"$f":"D24-C26","v":5},{"$f":"E24-D24","v":5},{"$f":"F24-E24","v":6},{"$f":"G24-F24","v":5},6,5,5,4,4]
[null,null,{"$f":"$B$24*C6","v":19},{"$f":"$B$24*D6-SUM(C27)","v":5},{"$f":"$B$24*E6-SUM(C27:D27)","v":5},{"$f":"$B$24*F6-SUM(C27:E27)","v":6},{"$f":"$B$24*G6-SUM(C27:F27)","v":5},{"$f":"$B$24*H6-SUM(C27:G27)","v":6},{"$f":"$B$24*I6-SUM(C27:H27)","v":5},{"$f":"$B$24*J6-SUM(C27:I27)","v":5},{"$f":"$B$24*K6-SUM(C27:J27)","v":4},{"$f":"$B$24*L6-SUM(C27:K27)","v":4},"Old calc Considering a fixed initial supply"]
[null,null,{"$f":"$B$24*C6","v":19},{"$f":"$B$24*(D6-C6)","v":5.0000000000000009},{"$f":"$B$24*(E6-D6)","v":5.0000000000000009},6.0000000000000018,4.9999999999999973,5.9999999999999982,4.9999999999999973,5.0000000000000044,3.9999999999999964,4.0000000000000036,"New calc Considering a fixed Initial Supply number"]
[]
[null,null,{"$f":"B25*C6","v":19},{"$f":"C25*D6","v":23.544},{"$f":"D25*E6","v":28.304000000000002},33.985000000000007,38.6,44.16,48.653999999999996,53.143999999999998,56.64,60.160000000000004]
[null,null,{"$f":"C30","v":19},{"$f":"D30-C30","v":4.5440000000000005},{"$f":"E30-D30","v":4.7600000000000016},{"$f":"F30-E30","v":5.6810000000000045},4.6149999999999949,5.5599999999999952,4.4939999999999998,4.490000000000002,3.4960000000000022,3.5200000000000031,"Considering a variable supply - multiply by actual % and subtract the total FTEs already automated"]
[null,null,{"$f":"B25*C6","v":19},{"$f":"C25*(D6-C6)","v":4.9050000000000011},{"$f":"D25*(E6-D6)","v":4.8800000000000008},5.8260000000000014,4.8249999999999975,5.759999999999998,4.7699999999999978,4.7450000000000045,3.7759999999999967,3.7600000000000033,"New calc considering a variable supply"]
[null,null,{"$f":"B25*C6","v":19},{"$f":"C25*D6-C33","v":4.5440000000000005},{"$f":"D25*E6-SUM(C33:D33)","v":4.7600000000000016},{"$f":"E25*F6-SUM(C33:E33)","v":5.6810000000000045},{"$f":"F25*G6-SUM(C33:F33)","v":4.6149999999999949},{"$f":"G25*H6-SUM(C33:G33)","v":5.5599999999999952},{"$f":"H25*I6-SUM(C33:H33)","v":4.4939999999999998},{"$f":"I25*J6-SUM(C33:I33)","v":4.490000000000002},{"$f":"J25*K6-SUM(C33:J33)","v":3.4960000000000022},{"$f":"K25*L6-SUM(C33:K33)","v":3.5200000000000031},"Old calc considering a variable supply"]
[null,null,null,{"$f":"1-D33/D32","v":7.3598369011213194E-2},{"$f":"1-E33/E32","v":2.4590163934426035E-2},2.4888431170613901E-2,4.3523316062176742E-2,3.4722222222222765E-2,5.786163522012544E-2,5.3740779768177482E-2,7.4152542372879937E-2,6.3829787234042534E-2]

{"sheet":"Attrition_Template","index":7,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Attrition Rates "]
[null,"                               "]
[null,"Role",{"$f":"\"Average Headcount \" & D9","v":"Average Headcount 2018"},{"$f":"\"Number of Voluntary Leavers \" & D9","v":"Number of Voluntary Leavers 2018"},{"$f":"\"Attrition Rate \" & D9","v":"Attrition Rate 2018"},{"$f":"\"Average Headcount \" & E9","v":"Average Headcount 2019"},{"$f":"\"Number of Voluntary Leavers \" & E9","v":"Number of Voluntary Leavers 2019"},{"$f":"\"Attrition Rate \" & E9","v":"Attrition Rate 2019"},{"$f":"\"Average Headcount \" & F9","v":"Average Headcount 2020"},{"$f":"\"Number of Voluntary Leavers \" & F9","v":"Number of Voluntary Leavers 2020"},{"$f":"\"Attrition Rate \" & F9","v":"Attrition Rate 2020"},"3 Year Ave Voluntary Attrition Rate","% of Attrition that is Retirement","Ave Voluntary Attrition excl Retirement"]
[null,{"$f":"B32","v":"Client Service Representative"},{"$f":"D32","v":5791},{"$f":"+D21+D22+D25","v":28},{"$f":"D5/C5","v":4.8350889310999831E-3},{"$f":"E32","v":5767},{"$f":"+E21+E22+E25","v":36},{"$f":"G5/F5","v":6.2424137333102134E-3},{"$f":"F32","v":5747},{"$f":"F21+F22+F25","v":32},{"$f":"J5/I5","v":5.5681224986949716E-3},{"$f":"(D5+G5+J5)/SUM(C5+F5+I5)","v":5.5475296157180007E-3},{"$f":"G21/((C5+F5+I5)/3)","v":1.4562265241259753E-2},{"$f":"((D5+G5+J5)-(D21+E21+F21))/SUM(C5+F5+I5)","v":6.9344120196475009E-4}]
[null," *Excludes Contractors and Fixed Term employees - voluntary turnover rate of Permanent employees only."]
[]
[]
[null,"TEMPLATE","Reason for action",2018,2019,2020,"Total","% Attrition"]
[null,"Voluntary","Resignation",null,null,null,{"$f":"SUM(D10:F10)","v":0},{"$f":"G10/$G$18","v":{"$error":"#DIV/0!"}}]
[null,"Voluntary","Retirement",null,null,null,{"$f":"SUM(D11:F11)","v":0},{"$error":"#DIV/0!"}]
[null,"Voluntary","Redundancy - Voluntary",null,null,null,{"$f":"SUM(D12:F12)","v":0},{"$error":"#DIV/0!"}]
[null,"Involuntary","Redundancy - Involuntary",null,null,null,0,{"$error":"#DIV/0!"}]
[null,"Involuntary","Dismissal",null,null,null,0,{"$error":"#DIV/0!"}]
[null,"Voluntary","Abandonment of Employment",null,null,null,0,{"$error":"#DIV/0!"}]
[null,"Involuntary","Deceased",null,null,null,0,{"$error":"#DIV/0!"}]
[null,"Involuntary","Other",null,null,null,0,{"$error":"#DIV/0!"}]
[null,null,"Total",{"$f":"SUM(D10:D17)","v":0},{"$f":"SUM(E10:E17)","v":0},{"$f":"SUM(F10:F17)","v":0},{"$f":"SUM(G10:G17)","v":0}]
[]
[null,"Role","Reason for action",{"$f":"D9","v":2018},{"$f":"E9","v":2019},2020,"Total","% Attrition"]
[null,null,"Retirement",25,30,29,{"$f":"SUM(D21:F21)","v":84},{"$f":"G21/$G$28","v":0.42639593908629442}]
[null,null,"Redundancy - Voluntary",3,5,3,{"$f":"SUM(D22:F22)","v":11},5.5837563451776651E-2]
[null,null,"Redundancy - Involuntary",35,29,32,{"$f":"SUM(D23:F23)","v":96},0.48730964467005078]
[null,null,"Dismissal",1,3,2,{"$f":"SUM(D24:F24)","v":6},3.0456852791878174E-2]
[null,null,"Abandonment of Employment",null,1,null,null,0]
[null,null,"Deceased",null,null,1,null,0]
[null,null,"Other",null,null,null,null,0]
[null,null,"Total",{"$f":"SUM(D21:D27)","v":64},{"$f":"SUM(E21:E27)","v":68},{"$f":"SUM(F21:F27)","v":67},{"$f":"SUM(G21:G24)","v":197}]
[]
[]
[null,"Average Headcount",null,{"$f":"D9","v":2018},{"$f":"E9","v":2019},2020]
[null,{"$f":"'Summary Output'!E7","v":"Client Service Representative"},null,5791,5767,5747]

{"sheet":"TOP3 Roles Y5","index":8,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Row Labels","Sum of CapFTE5","Sum of AutFTE5","Sum of TOTAL5",null,"Not been used in the new model"]
["Tellers",147.89618916688042,3067.8810461082207,3215.7772352751012]
["Loan Interviewers and Clerks",0,972.24287283198305,972.24287283198305]
["Loan Officers",263.46434541642799,488.13168555600743,751.59603097243541]
["Grand Total",411.36053458330844,4528.2556044962112,4939.616139079526]

{"sheet":"TOP5 BU Y5","index":9,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Row Labels","Sum of CapFTE5","Sum of AutFTE5","Sum of TOTAL5",null,null,"Not been used in the new model"]
["Retail Banking",847.28098052136374,5616.2098321868198,6463.4908127081835]
["New Business",121.61395027699351,877.54896486262169,999.16291513961517]
["Corporate Finance",223.4754289819731,350.23790959290045,573.71333857487355]
["Finance",70.784445350264221,420.85324570071134,491.63769105097555]
["Risk",127.69320115837418,345.88087850012431,473.57407965849848]
["ITBS",34.305859026059018,21.618836069501423,55.924695095560438]
["Transformation",26.506608023412188,21.931290944551115,48.437898967963307]
["Head Office",18.074306162869508,14.843189449592227,32.917495612461735]
["B2B",4.0312055156199182,23.843544069170978,27.874749584790898]
["Human Resources",12.364349044117061,12.914936774443063,25.279285818560126]
["Legal",1.6133093449079756,9.6408573920796812,11.254166736987656]
["0",0,0,0]
["Grand Total",1487.7436434059543,7715.523485542516,9203.2671289484351]