{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Info","Guide","Summary V1","Summary","Sheet1","Nursing, Midwifery & Health","Admin & Estates","Nursing, Midwifery & Health Vis","Nursing, Midwifery & Health (2)","Scientific, Therapeutic & Tech","Healthcare Assistant & Others","Healthcare Assistant & Others ","Healthcare Science","Others","Medical & Dental","Specific Retention Initiative","AfC"],"not_rendered":{"charts":9,"images":7,"macros":1,"external_links":0,"defined_names":15,"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":"Info","index":0,"n_rows":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Background"]
[]
[null,"We have created a simple Cost Calculator to help organisations identify potential cost savings from improving access to Flexible working."]
[]
[null,"Access to flexible working by default and from day one is a key commitment in the People Plan. Flexible working is an increasingly important aspect of any organisation’s retention strategy; a recent report by the Behavioural Insights Team found that access to flexible working was one of the top three benefits that retained staff within the NHS. Access to high-quality flexible working can therefore increase an organisation’s ability to attract and retain diverse talent."]
[]
[null,"The cost calculator can be used as part of data gathering to support flexible working implementation, to help you make the case for change."]
[]
[null,"The calculator has sheets for different staff groups.  You will need workforce data and to identify a target estimate for improving staff retention for each staff group, potential savings will then be generated with all information feeding into an organisational summary.  You will also need worforce data from ESR which captures reasons for leaving - if you want to focus specifically on improving  retention due to flexible working, you may want to focus only on the number of leavers who say they left due to flexibility or work life balance. Or if you have a high number of leavers with no reason for leaving recorded, you may want to use an estimate of the number leaving for this reason.  "]
[]
[null,"A blank sheet is also included, for organisations to use to calculate potential cost savings from different retention initiatives. It contains the same formula but does not link into the summary."]
[]
[null,"Data required"]
[]
[null,"As well as headcount and leaver numbers for each staff group,  to focus on flexible working you will need to consider the ESR data for the number of leavers due to flexibility or work life balance. The sheet asks for an average bank and agency cost by AfC pay grade for one staff member. The costs for these have been built into the calculator. The calculator uses an estimate of a 12 week period for a replacement to be recruited and start and a two week period for their induction. As bank and agency costs vary they will need to be inserted at a local level for each staff group."]
[]
[null,"The sheet also asks for any additional costs to administer each leaver and starter, for example the cost of your HR recruitment administrative team divided by the number of staff recruited would give a recruitment cost per person.  This is referred to as a non-cash releasing cost.  "]
[]
[null,"Project costs associated with improving flexible working are also taken into account, giving overall potential target savings after the investment in these costs. So for example if you have a change team working on flexible working you could enter a cost for their time, using their salary cost for the time they are speding on the project.  This figure is included on each sheet and so you will need to divide the total cost, by the number of areas you are working on / sheets you complete. "]
[]
[null,"Pay bill costs associated with AfC pay grades such as geographical enhancements, top/middle/bottom salary values and on costs (circa 30%) can also been included by selecting the relevent drop down lists on each tab."]
[]
[null,"A step by step guide to what to insert into each cell is given on the next page."]

{"sheet":"Guide","index":1,"n_rows":65,"n_cols":2,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[null,"Calculator user guide with examples"]
[]
[]
[null,"This sheet gives further guidance on how to use the calculator and the information needed in each cell. The sheet is colour coded in the following way to make it easy to see where you need to add data and where data has aleady been added or will be calculated automatically."]
[null,"Calculated Field"]
[null,"Prepopulated Cell"]
[null,"Enter Data in Cell"]
[]
[null,"Step 1 The first box to complete is organisational investment, the cost that your organisation might have for the project team working on this retention initiative - such as the Flexible Working Change Team. This box is optional and is particularly relevant if you recruit people to work on this area as it takes the cost of their time from any savings generated. If it is helpful to calculate this figure, then take the hourly cost of the people involved and multipy this by the hours spent on the project, and then insert that figure."]
[null,"Please divide this by the number of sheets you are completing and areas of work you are focusing on - for example if you are focusing on just trained nursing staff and medical staff divide your project costs between these sheets.  This is to ensure you don't double count these costs.  The total on the summary page should be the total of the project costs."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 2"]
[null,"In this section for Agenda for Change costings, use the drop-down list in each cell to select the relevent geographical weighting, salary pay point and on costs. The figures you choose relate to the budget that managers have for each post - usually your finance team can tell you if they budget at bottom, mid or top salary pay point.  Choose the relevant geographical allowance for your organisation. You can also choose to include or excluse on cost (on costs are the costs the employer pays on top of the salary and usually are made up of the cost of pension and NI) We have used a figure of 30% for on-costs but this may vary between organisations and your finance team can advise you of your actual figure.  In phase 2 of development we hope to offer a cell where you can add your organisation's actual on cost percentage. The AfC pay costs will automatically update when these drop-down menus are changed.   At the moment Medical and Dental salaries are not prepopulated - in phase 2 which will be released in December, drop down payscales for medical staff will be included."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 3"]
[null,"Insert: Headcount and number of leavers for each staff group, by payband on the separate sheets. This should be available from your workforce reports or from your workforce analyst by interrogating ESR.  If you are calculating opportunities for cost savings due to flexible working please just include the number of leavers due to work life balance and flexibility (these are options on ESR).  If you have a large number of leavers with the reason for leaving as 'unknown' you may also want to include an estimated % of the 'unknowns' on the assumption that a proportion will be due to work / life balance and flexibility. You may also want to look at the complete list of reasons for leaving and decide to include other categories such as leaving due to caring for adults / children as it may have been able to retain these staff with greater access to flexible working. The turnover rate % due to reasons likley to be related to flexible working will be calculated automatically."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Step 4"]
[null,"Insert the average bank and agency cost that your organisation is currently incurring for one whole time equivalent for each payband for a period of 12 weeks. Some organisations have obtained this from the financial ledger, some from the bank and agency team.  If the costs you have are an average hourly rate then this needs to be muliplied by 37.5 hours to give the weekly rate and then by 12 to give the amount for 12 weeks. We have chosen 12 weeks as an estimated time period that it would take to replace one person leaving.  An average 2 week bank and agency cost will then be automatically calculated from these fiigures. We have chosen the additional 2 weeks as an approximate length of time it would take to induct and train a new recruit.  Average budgets per WTE are prepopulated in the calculator - these are calculated on the basis of selections from step 2. The difference between the bank and agency costs and the budget costs will then be calculated automtically, showing the additional costs to the oragnisation for each leaver in that payband, if they are covered by bank and agency staff. In some cases if only bank staff are used and are paid at an hourly rate less than the budget, additional costs may not be incurred, but in most cases there will be extra costs from using temporary staff."]
[]
[]
[null,"Insert a picture to show"]
[]
[]
[null,"Step 5"]
[null,"You can also add costs that are fixed (which we have described as non-cash releasing) so that these are included in potential savings from improving retention.  This step is also optional and sometimes these costs are difficult to calculate. The boxes include administration of the resignation - this could be costed by a calculation of any HR admin costs that are used to administer leavers divided by the total number of leavers per year. Recruitment and selection costs could be calculated in a similar way by a calculation of HR admin costs for your recruitment team divided by the number of starters per year. If you incur costs from advertising posts, an avergae cost per new recruit could be calcuated and included. Induction costs can be included if you can calculate these on the basis of training team time or cost of mandatory training per recruit. Finally there is an 'other' section for any other costs."]
[]
[]
[]
[]
[null,"Step 6"]
[null,"There is a cost saving prediction cell.  Please put in a target percentage point amount that you predict you can reduce turnover by for this staff group, through your work on improving access to flexible working.  The potential cost saving will automatically calculate and will be recorded, as will the other information, on the summary sheet."]
[]
[null,"Insert a picture"]

{"sheet":"Summary V1","index":2,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":true,"merged":[]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[]
[null,"Summary"]
[]
[]
[]
[]
[]
[null," Staff groups","Organisational investment in the retention programm","Turnover rate","Headcount","Number of staff leaving ","Bank and Agency cost -12 weeks - per WTE    ","Bank and Agency cost for handover -2 weeks - per WTE","Average budget for substantive post -12 weeks - per WTE    ","Average budget for substantive post -2 weeks      - per WTE","Administration of the resignation   - per leaver","Recruitment and selection costs - per recruit","Induction training for the new employee   - per employee","Others  costs- per employee","Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[null,"Nursing, Midwifery & Health Visiting",{"$f":"'Nursing, Midwifery & Health Vis'!B8","v":150000},{"$f":"'Nursing, Midwifery & Health Vis'!B13","v":0.15},{"$f":"'Nursing, Midwifery & Health Vis'!D13","v":12000},{"$f":"D11*E11","v":1800},{"$f":"'Nursing, Midwifery & Health Vis'!B20","v":11000},{"$f":"'Nursing, Midwifery & Health Vis'!B24","v":3000},{"$f":"'Nursing, Midwifery & Health Vis'!D20","v":10573.826826923076},{"$f":"'Nursing, Midwifery & Health Vis'!D24","v":713.30769230769226},{"$f":"'Nursing, Midwifery & Health Vis'!B29","v":500},{"$f":"'Nursing, Midwifery & Health Vis'!D29","v":400},{"$f":"'Nursing, Midwifery & Health Vis'!B33","v":300},{"$f":"'Nursing, Midwifery & Health Vis'!D33","v":100},{"$f":"'Nursing, Midwifery & Health Vis'!H20","v":4883157.8653846178},{"$f":"'Nursing, Midwifery & Health Vis'!I20","v":2340000}]
[null,"Medical & Dental",{"$f":"'Medical & Dental'!B8","v":0},{"$f":"'Medical & Dental'!B13","v":0},{"$f":"'Medical & Dental'!D13","v":0},{"$f":"D12*E12","v":0},{"$f":"'Medical & Dental'!B20","v":0},{"$f":"'Medical & Dental'!B24","v":0},{"$f":"'Medical & Dental'!D20","v":0},{"$f":"'Medical & Dental'!D24","v":0},{"$f":"'Medical & Dental'!B29","v":0},{"$f":"'Medical & Dental'!D29","v":0},{"$f":"'Medical & Dental'!B33","v":0},{"$f":"'Medical & Dental'!D33","v":0},{"$f":"'Medical & Dental'!H20","v":0},{"$f":"'Medical & Dental'!I20","v":0}]
[null,"Admin & Estates",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Scientific, Therapeutic & Technical (AHPS)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Healthcare Assistant & Others",{"$f":"'Healthcare Assistant & Others'!B8","v":150000},{"$f":"'Healthcare Assistant & Others'!B13","v":0.15},{"$f":"'Healthcare Assistant & Others'!D13","v":8000},1200,{"$f":"'Healthcare Assistant & Others'!B20","v":10992},{"$f":"'Healthcare Assistant & Others'!B24","v":1832},{"$f":"'Healthcare Assistant & Others'!D20","v":9993},{"$f":"'Healthcare Assistant & Others'!D24","v":1665},{"$f":"'Healthcare Assistant & Others'!B29","v":500},{"$f":"'Healthcare Assistant & Others'!D29","v":400},{"$f":"'Healthcare Assistant & Others'!B33","v":300},{"$f":"'Healthcare Assistant & Others'!D33","v":100},{"$f":"'Healthcare Assistant & Others'!H20","v":1399200},{"$f":"'Healthcare Assistant & Others'!I20","v":1560000}]
[null,"Healthcare Science",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Others",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Total",{"$f":"SUM(C11:C17)","v":{"$error":"#REF!"}},{"$f":"SUM(D11:D17)","v":{"$error":"#REF!"}},{"$f":"SUM(E11:E17)","v":{"$error":"#REF!"}},{"$f":"SUM(F11:F17)","v":{"$error":"#REF!"}},{"$f":"SUM(G11:G17)","v":{"$error":"#REF!"}},{"$f":"SUM(H11:H17)","v":{"$error":"#REF!"}},{"$f":"SUM(I11:I17)","v":{"$error":"#REF!"}},{"$f":"SUM(J11:J17)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(O11:O17)","v":{"$error":"#REF!"}},{"$f":"SUM(P11:P17)","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Costs saving by staff groups \n            (Prediction)","If turnover reduced by  this percentage","Cash releasing saving","Non-cash releasing saving","Total cash & non-cash releasing savings","Total saving after Organisation investment is included"]
[null,{"$f":"B11","v":"Nursing, Midwifery & Health Visiting"},{"$f":"'Nursing, Midwifery & Health Vis'!C40","v":0.01},{"$f":"'Nursing, Midwifery & Health Vis'!C41","v":325543.85769230872},{"$f":"'Nursing, Midwifery & Health Vis'!C42","v":156000.00000000047},{"$f":"D41+E41","v":481543.85769230919},{"$f":"'Nursing, Midwifery & Health Vis'!C44","v":331543.85769230919}]
[null,"Medical & Dental",{"$f":"'Medical & Dental'!C40","v":0},{"$f":"'Medical & Dental'!C41","v":0},{"$f":"'Medical & Dental'!C42","v":0},{"$f":"D42+E42","v":0},{"$f":"'Medical & Dental'!C44","v":0}]
[null,"Admin & Estates",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Scientific, Therapeutic & Technical (AHPS)",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Healthcare Assistant & Others",{"$f":"'Healthcare Assistant & Others'!C40","v":1E-3},{"$f":"'Healthcare Assistant & Others'!C41","v":9328},{"$f":"'Healthcare Assistant & Others'!C42","v":10400},19728,{"$f":"'Healthcare Assistant & Others'!C44","v":-130272}]
[null,"Healthcare Science",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Others",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,"Total",{"$f":"SUM(C41:C47)","v":{"$error":"#REF!"}},{"$f":"SUM(D41:D47)","v":{"$error":"#REF!"}},{"$f":"SUM(E41:E47)","v":{"$error":"#REF!"}},{"$f":"SUM(F41:F47)","v":{"$error":"#REF!"}},{"$f":"SUM(G41:G47)","v":{"$error":"#REF!"}}]

{"sheet":"Summary","index":3,"n_rows":48,"n_cols":16,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[]
[null,"Summary"]
[]
[]
[]
[]
[]
[null," Staff groups","Organisational investment in the retention programm","Turnover rate","Headcount","Number of staff leaving ","Bank and Agency cost -12 weeks - per WTE    ","Bank and Agency cost for handover -2 weeks - per WTE","Average budget for substantive post -12 weeks - per WTE    ","Average budget for substantive post -2 weeks      - per WTE","Administration of the resignation   - per leaver","Recruitment and selection costs - per recruit","Induction training for the new employee   - per employee","Others  costs- per employee","Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[null,"Nursing, Midwifery & Health Visiting",{"$f":"'Nursing, Midwifery & Health'!B10","v":0},{"$f":"'Nursing, Midwifery & Health'!F31","v":0},{"$f":"'Nursing, Midwifery & Health'!B31","v":0},{"$f":"'Nursing, Midwifery & Health'!D31","v":0},{"$f":"'Nursing, Midwifery & Health'!B54","v":0},{"$f":"'Nursing, Midwifery & Health'!B58","v":0},{"$f":"'Nursing, Midwifery & Health'!D54","v":0},{"$f":"'Nursing, Midwifery & Health'!D58","v":0},{"$f":"'Nursing, Midwifery & Health'!B63","v":0},{"$f":"'Nursing, Midwifery & Health'!D63","v":0},{"$f":"'Nursing, Midwifery & Health'!B67","v":0},{"$f":"'Nursing, Midwifery & Health'!D67","v":0},{"$f":"'Nursing, Midwifery & Health'!H54","v":0},{"$f":"'Nursing, Midwifery & Health'!I54","v":0}]
[null,"Admin & Estates",{"$f":"'Admin & Estates'!B10","v":0},{"$f":"'Admin & Estates'!F39","v":0},{"$f":"'Admin & Estates'!B39","v":0},{"$f":"'Admin & Estates'!D39","v":0},{"$f":"'Admin & Estates'!B70","v":0},{"$f":"'Admin & Estates'!B74","v":0},{"$f":"'Admin & Estates'!D70","v":0},{"$f":"'Admin & Estates'!D74","v":0},{"$f":"'Admin & Estates'!B79","v":0},{"$f":"'Admin & Estates'!D79","v":0},{"$f":"'Admin & Estates'!B83","v":0},{"$f":"'Admin & Estates'!D83","v":0},{"$f":"'Admin & Estates'!H70","v":0},{"$f":"'Admin & Estates'!I70","v":0}]
[null,"Scientific, Therapeutic & Technical (AHPS)",{"$f":"'Scientific, Therapeutic & Tech'!B10","v":0},{"$f":"'Scientific, Therapeutic & Tech'!F31","v":0},{"$f":"'Scientific, Therapeutic & Tech'!B31","v":0},{"$f":"D13*E13","v":0},{"$f":"'Scientific, Therapeutic & Tech'!B54","v":0},{"$f":"'Scientific, Therapeutic & Tech'!B58","v":0},{"$f":"'Scientific, Therapeutic & Tech'!D54","v":0},{"$f":"'Scientific, Therapeutic & Tech'!D58","v":0},{"$f":"'Scientific, Therapeutic & Tech'!B63","v":0},{"$f":"'Scientific, Therapeutic & Tech'!D63","v":0},{"$f":"'Scientific, Therapeutic & Tech'!B67","v":0},{"$f":"'Scientific, Therapeutic & Tech'!D67","v":0},{"$f":"'Scientific, Therapeutic & Tech'!H54","v":0},{"$f":"'Scientific, Therapeutic & Tech'!I54","v":0}]
[null,"Healthcare Assistant & Others",{"$f":"'Healthcare Assistant & Others '!B10","v":0},{"$f":"'Healthcare Assistant & Others '!F23","v":0},{"$f":"'Healthcare Assistant & Others '!B23","v":0},{"$f":"'Healthcare Assistant & Others '!D23","v":0},{"$f":"'Healthcare Assistant & Others '!B38","v":0},{"$f":"'Healthcare Assistant & Others '!B42","v":0},{"$f":"'Healthcare Assistant & Others '!D38","v":0},{"$f":"'Healthcare Assistant & Others '!D42","v":0},{"$f":"'Healthcare Assistant & Others '!B47","v":0},{"$f":"'Healthcare Assistant & Others '!D47","v":0},{"$f":"'Healthcare Assistant & Others '!B51","v":0},{"$f":"'Healthcare Assistant & Others '!D51","v":0},{"$f":"'Healthcare Assistant & Others '!H38","v":0},{"$f":"'Healthcare Assistant & Others '!I38","v":0}]
[null,"Healthcare Science",{"$f":"'Healthcare Science'!B10","v":0},{"$f":"'Healthcare Science'!F31","v":0},{"$f":"'Healthcare Science'!B31","v":0},{"$f":"'Healthcare Science'!D31","v":0},{"$f":"'Healthcare Science'!B54","v":0},{"$f":"'Healthcare Science'!B58","v":0},{"$f":"'Healthcare Science'!D54","v":0},{"$f":"'Healthcare Science'!D58","v":0},{"$f":"'Healthcare Science'!B63","v":0},{"$f":"'Healthcare Science'!D63","v":0},{"$f":"'Healthcare Science'!B67","v":0},{"$f":"'Healthcare Science'!D67","v":0},{"$f":"'Healthcare Science'!H54","v":0},{"$f":"'Healthcare Science'!I54","v":0}]
[null,"Others",{"$f":"Others!B10","v":0},{"$f":"Others!F39","v":0},{"$f":"Others!B39","v":0},{"$f":"Others!D39","v":0},{"$f":"Others!B70","v":0},{"$f":"Others!B74","v":0},{"$f":"Others!D70","v":0},{"$f":"Others!D74","v":0},{"$f":"Others!B79","v":0},{"$f":"Others!D79","v":0},{"$f":"Others!B83","v":0},{"$f":"Others!D83","v":0},{"$f":"Others!H70","v":0},{"$f":"Others!I70","v":0}]
[null,"Medical & Dental",{"$f":"'Medical & Dental'!B8","v":0},{"$f":"'Medical & Dental'!B13","v":0},{"$f":"'Medical & Dental'!D13","v":0},{"$f":"'Medical & Dental'!F13","v":0},{"$f":"'Medical & Dental'!B20","v":0},{"$f":"'Medical & Dental'!B24","v":0},{"$f":"'Medical & Dental'!D20","v":0},{"$f":"'Medical & Dental'!D24","v":0},{"$f":"'Medical & Dental'!B29","v":0},{"$f":"'Medical & Dental'!D29","v":0},{"$f":"'Medical & Dental'!B33","v":0},{"$f":"'Medical & Dental'!D33","v":0},{"$f":"'Medical & Dental'!H20","v":0},{"$f":"'Medical & Dental'!I20","v":0}]
[null,"Total",{"$f":"SUM(C11:C17)","v":0},{"$f":"IFERROR(F18/E18,0)","v":0},{"$f":"SUM(E11:E17)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Costs saving by staff groups \n            (Prediction)","If turnover reduced by  this percentage","Cash releasing saving","Non-cash releasing saving","Total cash & non-cash releasing savings","Total saving after Organisation investment is included"]
[null,{"$f":"B11","v":"Nursing, Midwifery & Health Visiting"},{"$f":"'Nursing, Midwifery & Health'!C74","v":0},{"$f":"'Nursing, Midwifery & Health'!C75","v":0},{"$f":"'Nursing, Midwifery & Health'!C76","v":0},{"$f":"'Nursing, Midwifery & Health'!C77","v":0},{"$f":"'Nursing, Midwifery & Health'!C78","v":0}]
[null,"Admin & Estates",{"$f":"'Admin & Estates'!C90","v":0},{"$f":"'Admin & Estates'!C91","v":0},{"$f":"'Admin & Estates'!C92","v":0},{"$f":"'Admin & Estates'!C93","v":0},{"$f":"'Admin & Estates'!C94","v":0}]
[null,"Scientific, Therapeutic & Technical (AHPS)",{"$f":"'Scientific, Therapeutic & Tech'!C74","v":0},{"$f":"'Scientific, Therapeutic & Tech'!C75","v":0},{"$f":"'Scientific, Therapeutic & Tech'!C76","v":0},{"$f":"'Scientific, Therapeutic & Tech'!C77","v":0},{"$f":"'Scientific, Therapeutic & Tech'!C78","v":0}]
[null,"Healthcare Assistant & Others",{"$f":"'Healthcare Assistant & Others '!C58","v":0},{"$f":"'Healthcare Assistant & Others '!C59","v":0},{"$f":"'Healthcare Assistant & Others '!C60","v":0},{"$f":"'Healthcare Assistant & Others '!C61","v":0},{"$f":"'Healthcare Assistant & Others '!C62","v":0}]
[null,"Healthcare Science",{"$f":"'Healthcare Science'!C74","v":0},{"$f":"'Healthcare Science'!C75","v":0},{"$f":"'Healthcare Science'!C76","v":0},{"$f":"'Healthcare Science'!C77","v":0},{"$f":"'Healthcare Science'!C78","v":0}]
[null,"Others",{"$f":"Others!C90","v":0},{"$f":"Others!C91","v":0},{"$f":"Others!C92","v":0},{"$f":"Others!C93","v":0},{"$f":"Others!C94","v":0}]
[null,"Medical & Dental",{"$f":"'Medical & Dental'!C40","v":0},{"$f":"'Medical & Dental'!C41","v":0},{"$f":"'Medical & Dental'!C42","v":0},{"$f":"D47+E47","v":0},{"$f":"'Medical & Dental'!C44","v":0}]
[null,"Total",{"$f":"SUM(C41:C46)","v":0},{"$f":"SUM(D41:D46)","v":0},{"$f":"SUM(E41:E46)","v":0},{"$f":"SUM(F41:F46)","v":0},{"$f":"SUM(G41:G46)","v":0}]

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

{"sheet":"Nursing, Midwifery & Health","index":5,"n_rows":157,"n_cols":9,"rows_kept":157,"cut":false,"hidden":false,"merged":[[5,3,7,3],[108,4,114,4],[108,5,114,5],[109,6,114,6],[109,8,114,8],[33,2,33,8],[35,4,58,4],[60,4,66,4],[55,5,67,8],[70,1,70,3],[70,8,75,8]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Nursing, Midwifery & Health Visiting"]
[]
[null,"Calculated Field",null,"Agenda for Change costings"]
[null,"Prepopulated Cell",null,"Basic Pay"]
[null,"Enter Data in Cell"]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     \n(Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)",null,"Bottom pay point"]
[null,0,null,"\"Include on costs\""]
[]
[null,"Workforce data - headcounts and leavers"]
[null,"Headcount                                                                             (Insert)","X","Total number of staff leaving the organisation                                          (Insert)",">>>>>>>","Average turnover rate %"]
[]
[null,null,"Band 5",null,">>>>>>>",{"$f":"IFERROR(D15/B15,0)","v":0},null,{"$f":"D54*D15","v":0}]
[]
[null,null,"Band 6",null,">>>>>>>",{"$f":"IFERROR(D17/B17,0)","v":0}]
[]
[null,null,"Band 7",null,">>>>>>>",{"$f":"IFERROR(D19/B19,0)","v":0}]
[]
[null,null,"Band 8a",null,">>>>>>>",{"$f":"IFERROR(D21/B21,0)","v":0}]
[]
[null,null,"Band 8b",null,">>>>>>>",{"$f":"IFERROR(D23/B23,0)","v":0}]
[]
[null,null,"Band 8c",null,">>>>>>>",{"$f":"IFERROR(D25/B25,0)","v":0}]
[]
[null,null,"Band 8d",null,">>>>>>>",{"$f":"IFERROR(D27/B27,0)","v":0}]
[]
[null,null,"Band 9",null,">>>>>>>",{"$f":"IFERROR(D29/B29,0)","v":0}]
[]
[null,{"$f":"SUM(B15:B29)","v":0},"Total",{"$f":"SUM(D15:D29)","v":0},">>>>>>>",{"$f":"IFERROR(D31/B31,0)","v":0}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                       ","X","Total number of staff  leaving the organisation",null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[]
[null,null,"Band 5",{"$f":"(IF($D$9=$G$145,G150,IF($D$9=$F$145,F150,IF($D$9=$H$145,H150)))/52)*12","v":7696.5630000000001},null,{"$f":"D15","v":0},">>>>>>>",{"$f":"IF(B38<D38,0,(((B38/12)*14)-((D38/12)*14))*F38)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F38","v":0}]
[]
[null,null,"Band 6",{"$f":"(IF($D$9=$G$145,G151,IF($D$9=$F$145,F151,IF($D$9=$H$145,H151)))/52)*12","v":9691.7849999999999},null,{"$f":"D17","v":0},">>>>>>>",{"$f":"IF(B40<D40,0,(((B40/12)*14)-((D40/12)*14))*F40)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F40","v":0}]
[]
[null,null,"Band 7",{"$f":"(IF($D$9=$G$145,G152,IF($D$9=$F$145,F152,IF($D$9=$H$145,H152)))/52)*12","v":12017.01},null,{"$f":"D19","v":0},">>>>>>>",{"$f":"IF(B42<D42,0,(((B42/12)*14)-((D42/12)*14))*F42)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F42","v":0}]
[]
[null,null,"Band 8a",{"$f":"(IF($D$9=$G$145,G153,IF($D$9=$F$145,F153,IF($D$9=$H$145,H153)))/52)*12","v":14137.677},null,{"$f":"D21","v":0},">>>>>>>",{"$f":"IF(B44<D44,0,(((B44/12)*14)-((D44/12)*14))*F44)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F44","v":0}]
[]
[null,null,"Band 8b",{"$f":"(IF($D$9=$G$145,G154,IF($D$9=$F$145,F154,IF($D$9=$H$145,H154)))/52)*12","v":16429.212},null,{"$f":"D23","v":0},">>>>>>>",{"$f":"IF(B46<D46,0,(((B46/12)*14)-((D46/12)*14))*F46)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F46","v":0}]
[]
[null,null,"Band 8c",{"$f":"(IF($D$9=$G$145,G155,IF($D$9=$F$145,F155,IF($D$9=$H$145,H155)))/52)*12","v":19699.059000000001},null,{"$f":"D25","v":0},">>>>>>>",{"$f":"IF(B48<D48,0,(((B48/12)*14)-((D48/12)*14))*F48)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F48","v":0}]
[]
[null,null,"Band 8d",{"$f":"(IF($D$9=$G$145,G156,IF($D$9=$F$145,F156,IF($D$9=$H$145,H156)))/52)*12","v":23457.726000000002},null,{"$f":"D27","v":0},">>>>>>>",{"$f":"IF(B50<D50,0,(((B50/12)*14)-((D50/12)*14))*F50)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F50","v":0}]
[]
[null,null,"Band 9",{"$f":"(IF($D$9=$G$145,G157,IF($D$9=$F$145,F157,IF($D$9=$H$145,H157)))/52)*12","v":28120.536},null,{"$f":"D29","v":0},">>>>>>>",{"$f":"IF(B52<D52,0,(((B52/12)*14)-((D52/12)*14))*F52)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F52","v":0}]
[]
[null,{"$f":"IFERROR((((B38*F38)+(B40*F40)+(B42*F42)+(B44*F44)+(B46*F46)+(B48*F48)+(B50*F50)+(B52*F52))/F54),0)","v":0},"Total",{"$f":"IFERROR((((D38*F38)+(D40*F40)+(D42*F42)+(D44*F44)+(D46*F46)+(D48*F48)+(D50*F50)+(D52*F52))/F54),0)","v":0},null,{"$f":"SUM(F38:F52)","v":0},">>>>>>>",{"$f":"SUM(H38:H52)","v":0},{"$f":"SUM(I38:I52)","v":0}]
[]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                       ",null,"Average budget for substantive post -2 weeks - per WTE               "]
[]
[null,{"$f":"(B54/12)*2","v":0},"-",{"$f":"(D54/12)*2","v":0}]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)"]
[]
[null,null,"+"]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,null,"+"]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",0,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"IF(C74>0,IF(H54<1,0,H54-H109),0)","v":0}]
[null,"Non-cash releasing saving",{"$f":"I54-I109","v":0}]
[null,"Total cash & non-cash releasing savings",{"$f":"C75+C76","v":0}]
[null,"Total saving after organisational investment is included",{"$f":"C77-B10","v":0}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"F31-C74","v":0},"X",{"$f":"B31","v":0},">>>>>>>",{"$f":"B84*D84","v":0}]
[]
[]
[]
[null,null,null,null,null,{"$f":"B15*$B$84","v":0},{"$f":"F88/B15","v":{"$error":"#DIV/0!"}},{"$f":"(((B38/12)*14)-((D38/12)*14))*F88","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F88","v":0}]
[]
[null,null,null,null,null,{"$f":"B17*$B$84","v":0},{"$f":"F90/B17","v":{"$error":"#DIV/0!"}},{"$f":"(((B40/12)*14)-((D40/12)*14))*F90","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F90","v":0}]
[]
[null,null,null,null,null,{"$f":"B19*$B$84","v":0},{"$f":"F92/B19","v":{"$error":"#DIV/0!"}},{"$f":"(((B42/12)*14)-((D42/12)*14))*F92","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F92","v":0}]
[]
[null,null,null,null,null,{"$f":"B21*$B$84","v":0},{"$f":"F94/B21","v":{"$error":"#DIV/0!"}},{"$f":"(((B44/12)*14)-((D44/12)*14))*F94","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F94","v":0}]
[]
[null,null,null,null,null,{"$f":"B23*$B$84","v":0},{"$f":"F96/B23","v":{"$error":"#DIV/0!"}},{"$f":"(((B46/12)*14)-((D46/12)*14))*F96","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F96","v":0}]
[]
[null,null,null,null,null,{"$f":"B25*$B$84","v":0},{"$f":"F98/B25","v":{"$error":"#DIV/0!"}},{"$f":"(((B48/12)*14)-((D48/12)*14))*F98","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F98","v":0}]
[]
[null,null,null,null,null,{"$f":"B27*$B$84","v":0},{"$f":"F100/B27","v":{"$error":"#DIV/0!"}},{"$f":"(((B50/12)*14)-((D50/12)*14))*F100","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F100","v":0}]
[]
[null,null,null,null,null,{"$f":"B29*$B$84","v":0},{"$f":"F102/B29","v":{"$error":"#DIV/0!"}},{"$f":"(((B52/12)*14)-((D52/12)*14))*F102","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F102","v":0}]
[]
[null,null,null,null,null,{"$f":"B31*$B$84","v":0},{"$f":"F104/B31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H88:H102)","v":0},{"$f":"SUM(I88:I102)","v":0}]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B54","v":0},"+",{"$f":"D54","v":0},"X",{"$f":"F84","v":0},">>>>>>>",{"$f":"H104","v":0},{"$f":"I104","v":0}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B58","v":0},null,{"$f":"D58","v":0}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B63","v":0},"+",{"$f":"D63","v":0}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B67","v":0},"+",{"$f":"D67","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$6=$I$133,AfC!AA2*1.2,IF($D$6=$I$134,AfC!AA2*1.15,IF($D$6=$I$135,AfC!AA2*1.05,AfC!AA2)))","v":18546},{"$f":"IF($D$6=$I$133,AfC!AB2*1.2,IF($D$6=$J$134,AfC!AB2*1.15,IF($D$6=$I$135,AfC!AB2*1.05,AfC!AB2)))","v":18546},{"$f":"IF($D$6=$I$133,AfC!AC2*1.2,IF($D$6=$K$134,AfC!AC2*1.15,IF($D$6=$I$135,AfC!AC2*1.05,AfC!AC2)))","v":18546},"Basic Pay"]
[null,null,null,null,"Band 2",{"$f":"IF($D$6=$I$133,AfC!AA3*1.2,IF($D$6=$I$134,AfC!AA3*1.15,IF($D$6=$I$135,AfC!AA3*1.05,AfC!AA3)))","v":18546},{"$f":"IF($D$6=$I$133,AfC!AB3*1.2,IF($D$6=$J$134,AfC!AB3*1.15,IF($D$6=$I$135,AfC!AB3*1.05,AfC!AB3)))","v":19918},{"$f":"IF($D$6=$I$133,AfC!AC3*1.2,IF($D$6=$K$134,AfC!AC3*1.15,IF($D$6=$I$135,AfC!AC3*1.05,AfC!AC3)))","v":19918},"London (inner)"]
[null,null,null,null,"Band 3",{"$f":"IF($D$6=$I$133,AfC!AA4*1.2,IF($D$6=$I$134,AfC!AA4*1.15,IF($D$6=$I$135,AfC!AA4*1.05,AfC!AA4)))","v":20330},{"$f":"IF($D$6=$I$133,AfC!AB4*1.2,IF($D$6=$J$134,AfC!AB4*1.15,IF($D$6=$I$135,AfC!AB4*1.05,AfC!AB4)))","v":21777.26},{"$f":"IF($D$6=$I$133,AfC!AC4*1.2,IF($D$6=$K$134,AfC!AC4*1.15,IF($D$6=$I$135,AfC!AC4*1.05,AfC!AC4)))","v":21777.26},"London (outer)"]
[null,null,null,null,"Band 4",{"$f":"IF($D$6=$I$133,AfC!AA5*1.2,IF($D$6=$I$134,AfC!AA5*1.15,IF($D$6=$I$135,AfC!AA5*1.05,AfC!AA5)))","v":22548.76},{"$f":"IF($D$6=$I$133,AfC!AB5*1.2,IF($D$6=$J$134,AfC!AB5*1.15,IF($D$6=$I$135,AfC!AB5*1.05,AfC!AB5)))","v":24881.71},{"$f":"IF($D$6=$I$133,AfC!AC5*1.2,IF($D$6=$K$134,AfC!AC5*1.15,IF($D$6=$I$135,AfC!AC5*1.05,AfC!AC5)))","v":24881.71},"London (fringe)"]
[null,null,null,null,"Band 5",{"$f":"IF($D$6=$I$133,AfC!AA6*1.2,IF($D$6=$I$134,AfC!AA6*1.15,IF($D$6=$I$135,AfC!AA6*1.05,AfC!AA6)))","v":25655.21},{"$f":"IF($D$6=$I$133,AfC!AB6*1.2,IF($D$6=$J$134,AfC!AB6*1.15,IF($D$6=$I$135,AfC!AB6*1.05,AfC!AB6)))","v":29657.274999999998},{"$f":"IF($D$6=$I$133,AfC!AC6*1.2,IF($D$6=$K$134,AfC!AC6*1.15,IF($D$6=$I$135,AfC!AC6*1.05,AfC!AC6)))","v":31534.449999999997},"\"Include on costs\""]
[null,null,null,null,"Band 6",{"$f":"IF($D$6=$I$133,AfC!AA7*1.2,IF($D$6=$I$134,AfC!AA7*1.15,IF($D$6=$I$135,AfC!AA7*1.05,AfC!AA7)))","v":32305.949999999997},{"$f":"IF($D$6=$I$133,AfC!AB7*1.2,IF($D$6=$J$134,AfC!AB7*1.15,IF($D$6=$I$135,AfC!AB7*1.05,AfC!AB7)))","v":34172.28},{"$f":"IF($D$6=$I$133,AfC!AC7*1.2,IF($D$6=$K$134,AfC!AC7*1.15,IF($D$6=$I$135,AfC!AC7*1.05,AfC!AC7)))","v":39026.699999999997}]
[null,null,null,null,"Band 7",{"$f":"IF($D$6=$I$133,AfC!AA8*1.2,IF($D$6=$I$134,AfC!AA8*1.15,IF($D$6=$I$135,AfC!AA8*1.05,AfC!AA8)))","v":40056.699999999997},{"$f":"IF($D$6=$I$133,AfC!AB8*1.2,IF($D$6=$J$134,AfC!AB8*1.15,IF($D$6=$I$135,AfC!AB8*1.05,AfC!AB8)))","v":42120.82},{"$f":"IF($D$6=$I$133,AfC!AC8*1.2,IF($D$6=$K$134,AfC!AC8*1.15,IF($D$6=$I$135,AfC!AC8*1.05,AfC!AC8)))","v":45839.09}]
[null,null,null,null,"Band 8A",{"$f":"IF($D$6=$I$133,AfC!AA9*1.2,IF($D$6=$I$134,AfC!AA9*1.15,IF($D$6=$I$135,AfC!AA9*1.05,AfC!AA9)))","v":47125.59},{"$f":"IF($D$6=$I$133,AfC!AB9*1.2,IF($D$6=$J$134,AfC!AB9*1.15,IF($D$6=$I$135,AfC!AB9*1.05,AfC!AB9)))","v":47125.59},{"$f":"IF($D$6=$I$133,AfC!AC9*1.2,IF($D$6=$K$134,AfC!AC9*1.15,IF($D$6=$I$135,AfC!AC9*1.05,AfC!AC9)))","v":53219.039999999994}]
[null,null,null,null,"Band 8B",{"$f":"IF($D$6=$I$133,AfC!AA10*1.2,IF($D$6=$I$134,AfC!AA10*1.15,IF($D$6=$I$135,AfC!AA10*1.05,AfC!AA10)))","v":54764.039999999994},{"$f":"IF($D$6=$I$133,AfC!AB10*1.2,IF($D$6=$J$134,AfC!AB10*1.15,IF($D$6=$I$135,AfC!AB10*1.05,AfC!AB10)))","v":54764.039999999994},{"$f":"IF($D$6=$I$133,AfC!AC10*1.2,IF($D$6=$K$134,AfC!AC10*1.15,IF($D$6=$I$135,AfC!AC10*1.05,AfC!AC10)))","v":63862.03}]
[null,null,null,null,"Band 8C",{"$f":"IF($D$6=$I$133,AfC!AA11*1.2,IF($D$6=$I$134,AfC!AA11*1.15,IF($D$6=$I$135,AfC!AA11*1.05,AfC!AA11)))","v":65663.53},{"$f":"IF($D$6=$I$133,AfC!AB11*1.2,IF($D$6=$J$134,AfC!AB11*1.15,IF($D$6=$I$135,AfC!AB11*1.05,AfC!AB11)))","v":65663.53},{"$f":"IF($D$6=$I$133,AfC!AC11*1.2,IF($D$6=$K$134,AfC!AC11*1.15,IF($D$6=$I$135,AfC!AC11*1.05,AfC!AC11)))","v":75873.919999999998}]
[null,null,null,null,"Band 8D",{"$f":"IF($D$6=$I$133,AfC!AA12*1.2,IF($D$6=$I$134,AfC!AA12*1.15,IF($D$6=$I$135,AfC!AA12*1.05,AfC!AA12)))","v":78192.42},{"$f":"IF($D$6=$I$133,AfC!AB12*1.2,IF($D$6=$J$134,AfC!AB12*1.15,IF($D$6=$I$135,AfC!AB12*1.05,AfC!AB12)))","v":78192.42},{"$f":"IF($D$6=$I$133,AfC!AC12*1.2,IF($D$6=$K$134,AfC!AC12*1.15,IF($D$6=$I$135,AfC!AC12*1.05,AfC!AC12)))","v":90387.62}]
[null,null,null,null,"Band 9",{"$f":"IF($D$6=$I$133,AfC!AA13*1.2,IF($D$6=$I$134,AfC!AA13*1.15,IF($D$6=$I$135,AfC!AA13*1.05,AfC!AA13)))","v":93735.12},{"$f":"IF($D$6=$I$133,AfC!AB13*1.2,IF($D$6=$J$134,AfC!AB13*1.15,IF($D$6=$I$135,AfC!AB13*1.05,AfC!AB13)))","v":93735.12},{"$f":"IF($D$6=$I$133,AfC!AC13*1.2,IF($D$6=$K$134,AfC!AC13*1.15,IF($D$6=$I$135,AfC!AC13*1.05,AfC!AC13)))","v":108074.81}]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$10=$I$136,F132*1.3,F132)","v":24109.8},24109.8,24109.8]
[null,null,null,null,"Band 2",24109.8,25893.4,25893.4]
[null,null,null,null,"Band 3",26429,28310.437999999998,28310.437999999998]
[null,null,null,null,"Band 4",29313.387999999999,32346.223000000002,32346.223000000002]
[null,null,null,null,"Band 5",33351.773000000001,38554.457499999997,40994.784999999996]
[null,null,null,null,"Band 6",41997.735000000001,44423.964,50734.71]
[null,null,null,null,"Band 7",52073.71,54757.065999999999,59590.816999999995]
[null,null,null,null,"Band 8A",61263.267,61263.267,69184.751999999993]
[null,null,null,null,"Band 8B",71193.251999999993,71193.251999999993,83020.638999999996]
[null,null,null,null,"Band 8C",85362.589000000007,85362.589000000007,98636.096000000005]
[null,null,null,null,"Band 8D",101650.14600000001,101650.14600000001,117503.906]
[null,null,null,null,"Band 9",121855.656,121855.656,140497.253]

{"sheet":"Admin & Estates","index":6,"n_rows":182,"n_cols":19,"rows_kept":182,"cut":false,"hidden":false,"merged":[[133,4,139,4],[133,5,139,5],[134,6,139,6],[134,8,139,8],[5,3,7,3],[41,2,41,8],[43,4,74,4],[71,5,83,8],[76,4,82,4],[86,1,86,3],[86,8,91,8]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Admin & Estates"]
[]
[null,"Calculated Field",null,"Agenda for Change costings"]
[null,"Prepopulated Cell",null,"London (inner)"]
[null,"Enter Data in Cell"]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     \n(Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)",null,"Top pay point"]
[null,0,null,"\"Include on costs\""]
[]
[null,"Workforce data - headcounts and leavers"]
[null,"Headcount                                                                             (Insert)","X","Total number of staff leaving the organisation                                          (Insert)",">>>>>>>","Average turnover rate %"]
[]
[null,null,"Band 1",null,">>>>>>>",{"$f":"IFERROR(D15/B15,0)","v":0}]
[]
[null,null,"Band 2",null,">>>>>>>",{"$f":"IFERROR(D17/B17,0)","v":0}]
[]
[null,null,"Band 3",null,">>>>>>>",{"$f":"IFERROR(D19/B19,0)","v":0}]
[]
[null,null,"Band 4",null,">>>>>>>",{"$f":"IFERROR(D21/B21,0)","v":0}]
[]
[null,null,"Band 5",null,">>>>>>>",{"$f":"IFERROR(D23/B23,0)","v":0}]
[]
[null,null,"Band 6",null,">>>>>>>",{"$f":"IFERROR(D25/B25,0)","v":0}]
[]
[null,null,"Band 7",null,">>>>>>>",{"$f":"IFERROR(D27/B27,0)","v":0}]
[]
[null,null,"Band 8a",null,">>>>>>>",{"$f":"IFERROR(D29/B29,0)","v":0}]
[]
[null,null,"Band 8b",null,">>>>>>>",{"$f":"IFERROR(D31/B31,0)","v":0}]
[]
[null,null,"Band 8c",null,">>>>>>>",{"$f":"IFERROR(D33/B33,0)","v":0}]
[]
[null,null,"Band 8d",null,">>>>>>>",{"$f":"IFERROR(D35/B35,0)","v":0}]
[]
[null,null,"Band 9",null,">>>>>>>",{"$f":"IFERROR(D37/B37,0)","v":0}]
[]
[null,{"$f":"SUM(B15:B37)","v":0},"Total",{"$f":"SUM(D15:D37)","v":0},">>>>>>>",{"$f":"IFERROR(D39/B39,0)","v":0}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                       ","X","Total number of staff  leaving the organisation",null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[]
[null,null,"Band 1",{"$f":"(IF($D$9=$G$170,G171,IF($D$9=$F$170,F171,IF($D$9=$H$170,H171)))/52)*12","v":6676.5599999999995},null,{"$f":"D15","v":0},">>>>>>>",{"$f":"IF(B46<D46,0,(((B46/12)*14)-((D46/12)*14))*F46)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F46","v":0}]
[]
[null,null,"Band 2",{"$f":"(IF($D$9=$G$170,G172,IF($D$9=$F$170,F172,IF($D$9=$H$170,H172)))/52)*12","v":7170.48},null,{"$f":"D17","v":0},">>>>>>>",{"$f":"IF(B48<D48,0,(((B48/12)*14)-((D48/12)*14))*F48)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F48","v":0}]
[]
[null,null,"Band 3",{"$f":"(IF($D$9=$G$170,G173,IF($D$9=$F$170,F173,IF($D$9=$H$170,H173)))/52)*12","v":7839.8135999999995},null,{"$f":"D19","v":0},">>>>>>>",{"$f":"IF(B50<D50,0,(((B50/12)*14)-((D50/12)*14))*F50)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F50","v":0}]
[]
[null,null,"Band 4",{"$f":"(IF($D$9=$G$170,G174,IF($D$9=$F$170,F174,IF($D$9=$H$170,H174)))/52)*12","v":8957.4156000000003},null,{"$f":"D21","v":0},">>>>>>>",{"$f":"IF(B52<D52,0,(((B52/12)*14)-((D52/12)*14))*F52)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F52","v":0}]
[]
[null,null,"Band 5",{"$f":"(IF($D$9=$G$170,G175,IF($D$9=$F$170,F175,IF($D$9=$H$170,H175)))/52)*12","v":11352.402},null,{"$f":"D23","v":0},">>>>>>>",{"$f":"IF(B54<D54,0,(((B54/12)*14)-((D54/12)*14))*F54)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F54","v":0}]
[]
[null,null,"Band 6",{"$f":"(IF($D$9=$G$170,G176,IF($D$9=$F$170,F176,IF($D$9=$H$170,H176)))/52)*12","v":14049.611999999999},null,{"$f":"D25","v":0},">>>>>>>",{"$f":"IF(B56<D56,0,(((B56/12)*14)-((D56/12)*14))*F56)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F56","v":0}]
[]
[null,null,"Band 7",{"$f":"(IF($D$9=$G$170,G177,IF($D$9=$F$170,F177,IF($D$9=$H$170,H177)))/52)*12","v":16502.072400000001},null,{"$f":"D27","v":0},">>>>>>>",{"$f":"IF(B58<D58,0,(((B58/12)*14)-((D58/12)*14))*F58)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"H44","v":"Additional bank and agency costs of current total turnover"},{"$f":"I44","v":"Non-cash releasing costs of current total turnover "}]
[null,null,"Band 8a",{"$f":"(IF($D$9=$G$170,G178,IF($D$9=$F$170,F178,IF($D$9=$H$170,H178)))/52)*12","v":19158.854399999997},null,{"$f":"D29","v":0},">>>>>>>",{"$f":"IF(B60<D60,0,(((B60/12)*14)-((D60/12)*14))*F60)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F60","v":0},null,null,null,null,null,null,null,{"$f":"C46","v":"Band 1"},{"$f":"H46","v":0},{"$f":"I46","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C48","v":"Band 2"},{"$f":"H48","v":0},{"$f":"I48","v":0}]
[null,null,"Band 8b",{"$f":"(IF($D$9=$G$170,G179,IF($D$9=$F$170,F179,IF($D$9=$H$170,H179)))/52)*12","v":22990.330800000003},null,{"$f":"D31","v":0},">>>>>>>",{"$f":"IF(B62<D62,0,(((B62/12)*14)-((D62/12)*14))*F62)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F62","v":0},null,null,null,null,null,null,null,{"$f":"C50","v":"Band 3"},{"$f":"H50","v":0},{"$f":"I50","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C52","v":"Band 4"},{"$f":"H52","v":0},{"$f":"I52","v":0}]
[null,null,"Band 8c",{"$f":"(IF($D$9=$G$170,G180,IF($D$9=$F$170,F180,IF($D$9=$H$170,H180)))/52)*12","v":27314.611199999999},null,{"$f":"D33","v":0},">>>>>>>",{"$f":"IF(B64<D64,0,(((B64/12)*14)-((D64/12)*14))*F64)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F64","v":0},null,null,null,null,null,null,null,{"$f":"C54","v":"Band 5"},{"$f":"H54","v":0},{"$f":"I54","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C56","v":"Band 6"},{"$f":"H56","v":0},{"$f":"I56","v":0}]
[null,null,"Band 8d",{"$f":"(IF($D$9=$G$170,G181,IF($D$9=$F$170,F181,IF($D$9=$H$170,H181)))/52)*12","v":32539.543199999993},null,{"$f":"D35","v":0},">>>>>>>",{"$f":"IF(B66<D66,0,(((B66/12)*14)-((D66/12)*14))*F66)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F66","v":0},null,null,null,null,null,null,null,{"$f":"C58","v":"Band 7"},{"$f":"H58","v":0},{"$f":"I58","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C60","v":"Band 8a"},{"$f":"H60","v":0},{"$f":"I60","v":0}]
[null,null,"Band 9",{"$f":"(IF($D$9=$G$170,G182,IF($D$9=$F$170,F182,IF($D$9=$H$170,H182)))/52)*12","v":38906.931600000004},null,{"$f":"D37","v":0},">>>>>>>",{"$f":"IF(B68<D68,0,(((B68/12)*14)-((D68/12)*14))*F68)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F68","v":0},null,null,null,null,null,null,null,{"$f":"C62","v":"Band 8b"},{"$f":"H62","v":0},{"$f":"I62","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C64","v":"Band 8c"},{"$f":"H64","v":0},{"$f":"I64","v":0}]
[null,{"$f":"IFERROR((((B46*F46)+(B48*F48)+(B50*F50)+(B52*F52)+(B54*F54)+(B56*F56)+(B58*F58)+(B60*F60)+(B62*F62)+(B64*F64)+(B66*F66)+(B68*F68))/F70),)","v":0},"Total",{"$f":"IFERROR((((D46*F46)+(D48*F48)+(D50*F50)+(D52*F52)+(D54*F54)+(D56*F56)+(D58*F58)+(D60*F60)+(D62*F62)+(D64*F64)+(D66*F66)+(D68*F68))/F70),0)","v":0},null,{"$f":"SUM(F46:F68)","v":0},">>>>>>>",{"$f":"SUM(H46:H68)","v":0},{"$f":"SUM(I46:I68)","v":0},null,null,null,null,null,null,null,{"$f":"C66","v":"Band 8d"},{"$f":"H66","v":0},{"$f":"I66","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C68","v":"Band 9"},{"$f":"H68","v":0},{"$f":"I68","v":0}]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                       ",null,"Average budget for substantive post -2 weeks - per WTE               "]
[]
[null,{"$f":"(B70/12)*2","v":0},"-",{"$f":"(D70/12)*2","v":0}]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)"]
[]
[null,null,"+"]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,null,"+"]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",0,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"IF(C90>0,IF(H70<1,0,H70-H134),0)","v":0}]
[null,"Non-cash releasing saving",{"$f":"I70-I134","v":0}]
[null,"Total cash & non-cash releasing savings",{"$f":"C91+C92","v":0}]
[null,"Total saving after organisational investment is included",{"$f":"C93-B10","v":0}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"F39-C90","v":0},"X",{"$f":"B39","v":0},">>>>>>>",{"$f":"B100*D100","v":0}]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C15","v":"Band 1"},{"$f":"B15*$B$100","v":0},{"$f":"F105/B15","v":{"$error":"#DIV/0!"}},{"$f":"(((B46/12)*14)-((D46/12)*14))*F105","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F105","v":0}]
[]
[null,null,null,null,{"$f":"C17","v":"Band 2"},{"$f":"B17*$B$100","v":0},{"$f":"F107/B17","v":{"$error":"#DIV/0!"}},{"$f":"(((B48/12)*14)-((D48/12)*14))*F107","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F107","v":0}]
[]
[null,null,null,null,{"$f":"C19","v":"Band 3"},{"$f":"B19*$B$100","v":0},{"$f":"F109/B19","v":{"$error":"#DIV/0!"}},{"$f":"(((B50/12)*14)-((D50/12)*14))*F109","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F109","v":0}]
[]
[null,null,null,null,{"$f":"C21","v":"Band 4"},{"$f":"B21*$B$100","v":0},{"$f":"F111/B21","v":{"$error":"#DIV/0!"}},{"$f":"(((B52/12)*14)-((D52/12)*14))*F111","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F111","v":0}]
[]
[null,null,null,null,{"$f":"C23","v":"Band 5"},{"$f":"B23*$B$100","v":0},{"$f":"F113/B23","v":{"$error":"#DIV/0!"}},{"$f":"(((B54/12)*14)-((D54/12)*14))*F113","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F113","v":0}]
[]
[null,null,null,null,{"$f":"C25","v":"Band 6"},{"$f":"B25*$B$100","v":0},{"$f":"F115/B25","v":{"$error":"#DIV/0!"}},{"$f":"(((B56/12)*14)-((D56/12)*14))*F115","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F115","v":0}]
[]
[null,null,null,null,{"$f":"C27","v":"Band 7"},{"$f":"B27*$B$100","v":0},{"$f":"F117/B27","v":{"$error":"#DIV/0!"}},{"$f":"(((B58/12)*14)-((D58/12)*14))*F117","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F117","v":0}]
[]
[null,null,null,null,{"$f":"C29","v":"Band 8a"},{"$f":"B29*$B$100","v":0},{"$f":"F119/B29","v":{"$error":"#DIV/0!"}},{"$f":"(((B60/12)*14)-((D60/12)*14))*F119","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F119","v":0}]
[]
[null,null,null,null,{"$f":"C31","v":"Band 8b"},{"$f":"B31*$B$100","v":0},{"$f":"F121/B31","v":{"$error":"#DIV/0!"}},{"$f":"(((B62/12)*14)-((D62/12)*14))*F121","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F121","v":0}]
[]
[null,null,null,null,{"$f":"C33","v":"Band 8c"},{"$f":"B33*$B$100","v":0},{"$f":"F123/B33","v":{"$error":"#DIV/0!"}},{"$f":"(((B64/12)*14)-((D64/12)*14))*F123","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F123","v":0}]
[]
[null,null,null,null,{"$f":"C35","v":"Band 8d"},{"$f":"B35*$B$100","v":0},{"$f":"F125/B35","v":{"$error":"#DIV/0!"}},{"$f":"(((B66/12)*14)-((D66/12)*14))*F125","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F125","v":0}]
[]
[null,null,null,null,{"$f":"C37","v":"Band 9"},{"$f":"B37*$B$100","v":0},{"$f":"F127/B37","v":{"$error":"#DIV/0!"}},{"$f":"(((B68/12)*14)-((D68/12)*14))*F127","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F127","v":0}]
[]
[null,null,null,null,null,{"$f":"B39*$B$100","v":0},{"$f":"F129/B39","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H105:H127)","v":0},{"$f":"SUM(I105:I127)","v":0}]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B70","v":0},"+",{"$f":"D70","v":0},"X",{"$f":"F100","v":0},">>>>>>>",{"$f":"H129","v":0},{"$f":"I129","v":0}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B74","v":0},null,{"$f":"D74","v":0}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B79","v":0},"+",{"$f":"D79","v":0}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B83","v":0},"+",{"$f":"D83","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$6=$I$158,AfC!AA2*1.2,IF($D$6=$I$159,AfC!AA2*1.15,IF($D$6=$I$160,AfC!AA2*1.05,AfC!AA2)))","v":22255.200000000001},{"$f":"IF($D$6=$I$158,AfC!AB2*1.2,IF($D$6=$J$159,AfC!AB2*1.15,IF($D$6=$I$160,AfC!AB2*1.05,AfC!AB2)))","v":22255.200000000001},{"$f":"IF($D$6=$I$158,AfC!AC2*1.2,IF($D$6=$K$159,AfC!AC2*1.15,IF($D$6=$I$160,AfC!AC2*1.05,AfC!AC2)))","v":22255.200000000001},"Basic Pay"]
[null,null,null,null,"Band 2",{"$f":"IF($D$6=$I$158,AfC!AA3*1.2,IF($D$6=$I$159,AfC!AA3*1.15,IF($D$6=$I$160,AfC!AA3*1.05,AfC!AA3)))","v":22255.200000000001},{"$f":"IF($D$6=$I$158,AfC!AB3*1.2,IF($D$6=$J$159,AfC!AB3*1.15,IF($D$6=$I$160,AfC!AB3*1.05,AfC!AB3)))","v":23901.599999999999},{"$f":"IF($D$6=$I$158,AfC!AC3*1.2,IF($D$6=$K$159,AfC!AC3*1.15,IF($D$6=$I$160,AfC!AC3*1.05,AfC!AC3)))","v":23901.599999999999},"London (inner)"]
[null,null,null,null,"Band 3",{"$f":"IF($D$6=$I$158,AfC!AA4*1.2,IF($D$6=$I$159,AfC!AA4*1.15,IF($D$6=$I$160,AfC!AA4*1.05,AfC!AA4)))","v":24396},{"$f":"IF($D$6=$I$158,AfC!AB4*1.2,IF($D$6=$J$159,AfC!AB4*1.15,IF($D$6=$I$160,AfC!AB4*1.05,AfC!AB4)))","v":26132.711999999996},{"$f":"IF($D$6=$I$158,AfC!AC4*1.2,IF($D$6=$K$159,AfC!AC4*1.15,IF($D$6=$I$160,AfC!AC4*1.05,AfC!AC4)))","v":26132.711999999996},"London (outer)"]
[null,null,null,null,"Band 4",{"$f":"IF($D$6=$I$158,AfC!AA5*1.2,IF($D$6=$I$159,AfC!AA5*1.15,IF($D$6=$I$160,AfC!AA5*1.05,AfC!AA5)))","v":27058.511999999999},{"$f":"IF($D$6=$I$158,AfC!AB5*1.2,IF($D$6=$J$159,AfC!AB5*1.15,IF($D$6=$I$160,AfC!AB5*1.05,AfC!AB5)))","v":29858.051999999996},{"$f":"IF($D$6=$I$158,AfC!AC5*1.2,IF($D$6=$K$159,AfC!AC5*1.15,IF($D$6=$I$160,AfC!AC5*1.05,AfC!AC5)))","v":29858.051999999996},"London (fringe)"]
[null,null,null,null,"Band 5",{"$f":"IF($D$6=$I$158,AfC!AA6*1.2,IF($D$6=$I$159,AfC!AA6*1.15,IF($D$6=$I$160,AfC!AA6*1.05,AfC!AA6)))","v":30786.251999999997},{"$f":"IF($D$6=$I$158,AfC!AB6*1.2,IF($D$6=$J$159,AfC!AB6*1.15,IF($D$6=$I$160,AfC!AB6*1.05,AfC!AB6)))","v":35588.729999999996},{"$f":"IF($D$6=$I$158,AfC!AC6*1.2,IF($D$6=$K$159,AfC!AC6*1.15,IF($D$6=$I$160,AfC!AC6*1.05,AfC!AC6)))","v":37841.339999999997},"\"Include on costs\""]
[null,null,null,null,"Band 6",{"$f":"IF($D$6=$I$158,AfC!AA7*1.2,IF($D$6=$I$159,AfC!AA7*1.15,IF($D$6=$I$160,AfC!AA7*1.05,AfC!AA7)))","v":38767.139999999992},{"$f":"IF($D$6=$I$158,AfC!AB7*1.2,IF($D$6=$J$159,AfC!AB7*1.15,IF($D$6=$I$160,AfC!AB7*1.05,AfC!AB7)))","v":41006.735999999997},{"$f":"IF($D$6=$I$158,AfC!AC7*1.2,IF($D$6=$K$159,AfC!AC7*1.15,IF($D$6=$I$160,AfC!AC7*1.05,AfC!AC7)))","v":46832.039999999994}]
[null,null,null,null,"Band 7",{"$f":"IF($D$6=$I$158,AfC!AA8*1.2,IF($D$6=$I$159,AfC!AA8*1.15,IF($D$6=$I$160,AfC!AA8*1.05,AfC!AA8)))","v":48068.039999999994},{"$f":"IF($D$6=$I$158,AfC!AB8*1.2,IF($D$6=$J$159,AfC!AB8*1.15,IF($D$6=$I$160,AfC!AB8*1.05,AfC!AB8)))","v":50544.983999999997},{"$f":"IF($D$6=$I$158,AfC!AC8*1.2,IF($D$6=$K$159,AfC!AC8*1.15,IF($D$6=$I$160,AfC!AC8*1.05,AfC!AC8)))","v":55006.907999999996}]
[null,null,null,null,"Band 8A",{"$f":"IF($D$6=$I$158,AfC!AA9*1.2,IF($D$6=$I$159,AfC!AA9*1.15,IF($D$6=$I$160,AfC!AA9*1.05,AfC!AA9)))","v":56550.707999999991},{"$f":"IF($D$6=$I$158,AfC!AB9*1.2,IF($D$6=$J$159,AfC!AB9*1.15,IF($D$6=$I$160,AfC!AB9*1.05,AfC!AB9)))","v":56550.707999999991},{"$f":"IF($D$6=$I$158,AfC!AC9*1.2,IF($D$6=$K$159,AfC!AC9*1.15,IF($D$6=$I$160,AfC!AC9*1.05,AfC!AC9)))","v":63862.847999999991}]
[null,null,null,null,"Band 8B",{"$f":"IF($D$6=$I$158,AfC!AA10*1.2,IF($D$6=$I$159,AfC!AA10*1.15,IF($D$6=$I$160,AfC!AA10*1.05,AfC!AA10)))","v":65716.847999999984},{"$f":"IF($D$6=$I$158,AfC!AB10*1.2,IF($D$6=$J$159,AfC!AB10*1.15,IF($D$6=$I$160,AfC!AB10*1.05,AfC!AB10)))","v":65716.847999999984},{"$f":"IF($D$6=$I$158,AfC!AC10*1.2,IF($D$6=$K$159,AfC!AC10*1.15,IF($D$6=$I$160,AfC!AC10*1.05,AfC!AC10)))","v":76634.436000000002}]
[null,null,null,null,"Band 8C",{"$f":"IF($D$6=$I$158,AfC!AA11*1.2,IF($D$6=$I$159,AfC!AA11*1.15,IF($D$6=$I$160,AfC!AA11*1.05,AfC!AA11)))","v":78796.23599999999},{"$f":"IF($D$6=$I$158,AfC!AB11*1.2,IF($D$6=$J$159,AfC!AB11*1.15,IF($D$6=$I$160,AfC!AB11*1.05,AfC!AB11)))","v":78796.23599999999},{"$f":"IF($D$6=$I$158,AfC!AC11*1.2,IF($D$6=$K$159,AfC!AC11*1.15,IF($D$6=$I$160,AfC!AC11*1.05,AfC!AC11)))","v":91048.703999999998}]
[null,null,null,null,"Band 8D",{"$f":"IF($D$6=$I$158,AfC!AA12*1.2,IF($D$6=$I$159,AfC!AA12*1.15,IF($D$6=$I$160,AfC!AA12*1.05,AfC!AA12)))","v":93830.903999999995},{"$f":"IF($D$6=$I$158,AfC!AB12*1.2,IF($D$6=$J$159,AfC!AB12*1.15,IF($D$6=$I$160,AfC!AB12*1.05,AfC!AB12)))","v":93830.903999999995},{"$f":"IF($D$6=$I$158,AfC!AC12*1.2,IF($D$6=$K$159,AfC!AC12*1.15,IF($D$6=$I$160,AfC!AC12*1.05,AfC!AC12)))","v":108465.14399999999}]
[null,null,null,null,"Band 9",{"$f":"IF($D$6=$I$158,AfC!AA13*1.2,IF($D$6=$I$159,AfC!AA13*1.15,IF($D$6=$I$160,AfC!AA13*1.05,AfC!AA13)))","v":112482.14399999999},{"$f":"IF($D$6=$I$158,AfC!AB13*1.2,IF($D$6=$J$159,AfC!AB13*1.15,IF($D$6=$I$160,AfC!AB13*1.05,AfC!AB13)))","v":112482.14399999999},{"$f":"IF($D$6=$I$158,AfC!AC13*1.2,IF($D$6=$K$159,AfC!AC13*1.15,IF($D$6=$I$160,AfC!AC13*1.05,AfC!AC13)))","v":129689.772}]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$10=$I$161,F157*1.3,F157)","v":28931.760000000002},28931.760000000002,28931.760000000002]
[null,null,null,null,"Band 2",28931.760000000002,31072.079999999998,31072.079999999998]
[null,null,null,null,"Band 3",31714.799999999999,33972.525599999994,33972.525599999994]
[null,null,null,null,"Band 4",35176.065600000002,38815.467599999996,38815.467599999996]
[null,null,null,null,"Band 5",40022.1276,46265.348999999995,49193.741999999998]
[null,null,null,null,"Band 6",50397.281999999992,53308.756799999996,60881.651999999995]
[null,null,null,null,"Band 7",62488.45199999999,65708.479200000002,71508.9804]
[null,null,null,null,"Band 8A",73515.920399999988,73515.920399999988,83021.702399999995]
[null,null,null,null,"Band 8B",85431.902399999977,85431.902399999977,99624.766800000012]
[null,null,null,null,"Band 8C",102435.10679999999,102435.10679999999,118363.3152]
[null,null,null,null,"Band 8D",121980.1752,121980.1752,141004.68719999999]
[null,null,null,null,"Band 9",146226.78719999999,146226.78719999999,168596.70360000001]

{"sheet":"Nursing, Midwifery & Health Vis","index":7,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":true,"merged":[[15,2,15,8],[17,4,24,4],[19,5,33,5],[19,6,33,6],[19,7,33,7],[19,8,33,8],[26,4,32,4],[36,1,36,3],[36,8,41,8],[56,4,62,4],[56,5,62,5],[57,6,62,6],[57,8,62,8]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Nursing, Midwifery & Health Visiting"]
[]
[]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     (Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)"]
[null,150000]
[]
[null,"Number of staff leaving the organisation - last 12 months "]
[null,"Average staff turnover rate                                           (Insert)","X","Headcount                                                                         (Insert)",">>>>>>>","Total number of staff  leaving the organisation"]
[]
[null,0.15,"X",12000,">>>>>>>",{"$f":"B13*D13","v":1800}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                        (Insert)","X",{"$f":"F11","v":"Total number of staff  leaving the organisation"},null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[]
[null,11000,"-",10573.826826923076,null,{"$f":"F13","v":1800},">>>>>>>",{"$f":"((B20-D20)+(B24-D24))*F20","v":4883157.8653846178},{"$f":"(B29+D29+B33+D33)*F20","v":2340000}]
[]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                        (Insert)",null,"Average budget for substantive post -2 weeks - per WTE                      (Insert)"]
[]
[null,3000,"-",713.30769230769226]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)","X"]
[]
[null,500,"+",400]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,300,"+",100]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",0.01,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"H20-H57","v":325543.85769230872}]
[null,"Non-cash releasing saving",{"$f":"I20-I57","v":156000.00000000047}]
[null,"Total cash & non-cash releasing savings",{"$f":"C41+C42","v":481543.85769230919}]
[null,"Total saving after organisational investment is included",{"$f":"C43-B8","v":331543.85769230919}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"B13-C40","v":0.13999999999999999},"X",{"$f":"D13","v":12000},">>>>>>>",{"$f":"B50*D50","v":1679.9999999999998}]
[]
[]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B20","v":11000},"+",{"$f":"D20","v":10573.826826923076},"X",{"$f":"F50","v":1679.9999999999998},">>>>>>>",{"$f":"((B57-D57)+(B59-D59))*F57","v":4557614.0076923091},{"$f":"(B61+D61+B63+D63)*F57","v":2183999.9999999995}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B24","v":3000},null,{"$f":"D24","v":713.30769230769226}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B29","v":500},"+",{"$f":"D29","v":400}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B33","v":300},"+",{"$f":"D33","v":100}]

{"sheet":"Nursing, Midwifery & Health (2)","index":8,"n_rows":97,"n_cols":9,"rows_kept":97,"cut":false,"hidden":true,"merged":[[90,4,96,4],[90,5,96,5],[91,6,96,6],[91,8,96,8],[5,3,7,3],[33,2,33,8],[35,4,58,4],[55,5,67,8],[60,4,66,4],[70,1,70,3],[70,8,75,8]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Nursing, Midwifery & Health Visiting"]
[]
[null,"Calculated Field"]
[null,"Prepopulated Cell",null,"Basic Pay"]
[null,"Enter Data in Cell"]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     (Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)",null,"Band 1 (< 1 year service)"]
[null,150000,null,{"$f":"IF(D6=AfC!I1,VLOOKUP(D9,AfC!A1:L80,9),IF(D6=AfC!J1,VLOOKUP(D9,AfC!A1:L80,10),IF(D6=AfC!K1,VLOOKUP(D9,AfC!A1:L80,11),VLOOKUP(D9,AfC!A1:L80,7))))","v":18546}]
[]
[null,"Number of staff leaving the organisation - last 12 months "]
[null,"Headcount                                                                             (Insert)","X","Total number of staff leaving the organisation                                          (Insert)",">>>>>>>","Average turnover rate %"]
[]
[null,3000,"Band 5",450,">>>>>>>",{"$f":"D15/B15","v":0.15}]
[]
[null,2000,"Band 6",300,">>>>>>>",{"$f":"D17/B17","v":0.15}]
[]
[null,2000,"Band 7",300,">>>>>>>",{"$f":"D19/B19","v":0.15}]
[]
[null,1000,"Band 8a",150,">>>>>>>",{"$f":"D21/B21","v":0.15}]
[]
[null,2000,"Band 8b",300,">>>>>>>",{"$f":"D23/B23","v":0.15}]
[]
[null,1000,"Band 8c",150,">>>>>>>",{"$f":"D25/B25","v":0.15}]
[]
[null,500,"Band 8d",75,">>>>>>>",{"$f":"D27/B27","v":0.15}]
[]
[null,500,"Band 9",75,">>>>>>>",{"$f":"D29/B29","v":0.15}]
[]
[null,{"$f":"SUM(B15:B29)","v":12000},"Total",{"$f":"SUM(D15:D29)","v":1800},">>>>>>>",{"$f":"D31/B31","v":0.15}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                       ","X","Total number of staff  leaving the organisation",null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[]
[null,{"$f":"D38*1.1","v":9786.9007499999989},"Band 5",{"$f":"((AfC!AB6+AfC!AD6)/52)*12","v":8897.182499999999},null,{"$f":"D15","v":450},">>>>>>>",{"$f":"(((B38/12)*14)-((D38/12)*14))*F38","v":467102.08125000063},{"$f":"(B$63+D$63+B$67+D$67)*F38","v":585000}]
[]
[null,{"$f":"D40*1.1","v":11276.852400000002},"Band 6",{"$f":"((AfC!AB7+AfC!AD7)/52)*12","v":10251.684000000001},null,{"$f":"D17","v":300},">>>>>>>",{"$f":"(((B40/12)*14)-((D40/12)*14))*F40","v":358808.94000000006},{"$f":"(B$63+D$63+B$67+D$67)*F40","v":390000}]
[]
[null,{"$f":"D42*1.1","v":13899.870600000002},"Band 7",{"$f":"((AfC!AB8+AfC!AD8)/52)*12","v":12636.246000000001},null,{"$f":"D19","v":300},">>>>>>>",{"$f":"(((B42/12)*14)-((D42/12)*14))*F42","v":442268.61000000045},{"$f":"(B$63+D$63+B$67+D$67)*F42","v":390000}]
[]
[null,{"$f":"D44*1.1","v":15551.444699999998},"Band 8a",{"$f":"((AfC!AB9+AfC!AD9)/52)*12","v":14137.676999999998},null,{"$f":"D21","v":150},">>>>>>>",{"$f":"(((B44/12)*14)-((D44/12)*14))*F44","v":247409.34750000032},{"$f":"(B$63+D$63+B$67+D$67)*F44","v":195000}]
[]
[null,{"$f":"D46*1.1","v":18072.1332},"Band 8b",{"$f":"((AfC!AB10+AfC!AD10)/52)*12","v":16429.212},null,{"$f":"D23","v":300},">>>>>>>",{"$f":"(((B46/12)*14)-((D46/12)*14))*F46","v":575022.42000000074},{"$f":"(B$63+D$63+B$67+D$67)*F46","v":390000}]
[]
[null,{"$f":"D48*1.1","v":21668.964900000003},"Band 8c",{"$f":"((AfC!AB11+AfC!AD11)/52)*12","v":19699.059000000001},null,{"$f":"D25","v":150},">>>>>>>",{"$f":"(((B48/12)*14)-((D48/12)*14))*F48","v":344733.5325000009},{"$f":"(B$63+D$63+B$67+D$67)*F48","v":195000}]
[]
[null,{"$f":"D50*1.1","v":25803.498599999999},"Band 8d",{"$f":"((AfC!AB12+AfC!AD12)/52)*12","v":23457.725999999999},null,{"$f":"D27","v":75},">>>>>>>",{"$f":"(((B50/12)*14)-((D50/12)*14))*F50","v":205255.10250000007},{"$f":"(B$63+D$63+B$67+D$67)*F50","v":97500}]
[]
[null,{"$f":"D52*1.1","v":30932.589599999999},"Band 9",{"$f":"((AfC!AB13+AfC!AD13)/52)*12","v":28120.535999999996},null,{"$f":"D29","v":75},">>>>>>>",{"$f":"(((B52/12)*14)-((D52/12)*14))*F52","v":246054.69000000067},{"$f":"(B$63+D$63+B$67+D$67)*F52","v":97500}]
[]
[null,{"$f":"D54*1.1","v":15120.572362500001},"Total",{"$f":"((D38*F38)+(D40*F40)+(D42*F42)+(D44*F44)+(D46*F46)+(D48*F48)+(D50*F50)+(D52*F52))/F54","v":13745.974875},null,{"$f":"SUM(F38:F52)","v":1800},">>>>>>>",{"$f":"SUM(H38:H52)","v":2886654.7237500041},{"$f":"SUM(I38:I52)","v":2340000}]
[]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                       ",null,"Average budget for substantive post -2 weeks - per WTE               "]
[]
[null,{"$f":"(B54/12)*2","v":2520.0953937500003},"-",{"$f":"(D54/12)*2","v":2290.9958124999998}]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)"]
[]
[null,500,"+",400]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,300,"+",100]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",1E-3,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"H54-H91","v":19244.364825001452}]
[null,"Non-cash releasing saving",{"$f":"I54-I91","v":15600}]
[null,"Total cash & non-cash releasing savings",{"$f":"C75+C76","v":34844.364825001452}]
[null,"Total saving after organisational investment is included",{"$f":"C77-B10","v":-115155.63517499855}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"F31-C74","v":0.14899999999999999},"X",{"$f":"B31","v":12000},">>>>>>>",{"$f":"B84*D84","v":1788}]
[]
[]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B54","v":15120.572362500001},"+",{"$f":"D54","v":13745.974875},"X",{"$f":"F84","v":1788},">>>>>>>",{"$f":"((B91-D91)+(B93-D93))*F91","v":2867410.3589250026},{"$f":"(B95+D95+B97+D97)*F91","v":2324400}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B58","v":2520.0953937500003},null,{"$f":"D58","v":2290.9958124999998}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B63","v":500},"+",{"$f":"D63","v":400}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B67","v":300},"+",{"$f":"D67","v":100}]

{"sheet":"Scientific, Therapeutic & Tech","index":9,"n_rows":157,"n_cols":9,"rows_kept":157,"cut":false,"hidden":false,"merged":[[108,4,114,4],[108,5,114,5],[109,6,114,6],[109,8,114,8],[5,3,7,3],[33,2,33,8],[35,4,58,4],[55,5,67,8],[60,4,66,4],[70,1,70,3],[70,8,75,8]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Scientific, Therapeutic & Tech"]
[]
[null,"Calculated Field",null,"Agenda for Change costings"]
[null,"Prepopulated Cell",null,"London (inner)"]
[null,"Enter Data in Cell"]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     \n(Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)",null,"Top pay point"]
[null,0,null,"\"Include on costs\""]
[]
[null,"Workforce data - headcounts and leavers"]
[null,"Headcount                                                                             (Insert)","X","Total number of staff leaving the organisation                                          (Insert)",">>>>>>>","Average turnover rate %"]
[]
[null,null,"Band 5",null,">>>>>>>",{"$f":"IFERROR(D15/B15,0)","v":0}]
[]
[null,null,"Band 6",null,">>>>>>>",{"$f":"IFERROR(D17/B17,0)","v":0}]
[]
[null,null,"Band 7",null,">>>>>>>",{"$f":"IFERROR(D19/B19,0)","v":0}]
[]
[null,null,"Band 8a",null,">>>>>>>",{"$f":"IFERROR(D21/B21,0)","v":0}]
[]
[null,null,"Band 8b",null,">>>>>>>",{"$f":"IFERROR(D23/B23,0)","v":0}]
[]
[null,null,"Band 8c",null,">>>>>>>",{"$f":"IFERROR(D25/B25,0)","v":0}]
[]
[null,null,"Band 8d",null,">>>>>>>",{"$f":"IFERROR(D27/B27,0)","v":0}]
[]
[null,null,"Band 9",null,">>>>>>>",{"$f":"IFERROR(D29/B29,0)","v":0}]
[]
[null,{"$f":"SUM(B15:B29)","v":0},"Total",{"$f":"SUM(D15:D29)","v":0},">>>>>>>",{"$f":"IFERROR(D31/B31,0)","v":0}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                       ","X","Total number of staff  leaving the organisation",null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[]
[null,null,"Band 5",{"$f":"(IF($D$9=$G$145,G150,IF($D$9=$F$145,F150,IF($D$9=$H$145,H150)))/52)*12","v":11352.402},null,{"$f":"D15","v":0},">>>>>>>",{"$f":"IF(B38<D38,0,(((B38/12)*14)-((D38/12)*14))*F38)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F38","v":0}]
[]
[null,null,"Band 6",{"$f":"(IF($D$9=$G$145,G151,IF($D$9=$F$145,F151,IF($D$9=$H$145,H151)))/52)*12","v":14049.611999999999},null,{"$f":"D17","v":0},">>>>>>>",{"$f":"IF(B40<D40,0,(((B40/12)*14)-((D40/12)*14))*F40)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F40","v":0}]
[]
[null,null,"Band 7",{"$f":"(IF($D$9=$G$145,G152,IF($D$9=$F$145,F152,IF($D$9=$H$145,H152)))/52)*12","v":16502.072400000001},null,{"$f":"D19","v":0},">>>>>>>",{"$f":"IF(B42<D42,0,(((B42/12)*14)-((D42/12)*14))*F42)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F42","v":0}]
[]
[null,null,"Band 8a",{"$f":"(IF($D$9=$G$145,G153,IF($D$9=$F$145,F153,IF($D$9=$H$145,H153)))/52)*12","v":19158.854399999997},null,{"$f":"D21","v":0},">>>>>>>",{"$f":"IF(B44<D44,0,(((B44/12)*14)-((D44/12)*14))*F44)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F44","v":0}]
[]
[null,null,"Band 8b",{"$f":"(IF($D$9=$G$145,G154,IF($D$9=$F$145,F154,IF($D$9=$H$145,H154)))/52)*12","v":22990.330800000003},null,{"$f":"D23","v":0},">>>>>>>",{"$f":"IF(B46<D46,0,(((B46/12)*14)-((D46/12)*14))*F46)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F46","v":0}]
[]
[null,null,"Band 8c",{"$f":"(IF($D$9=$G$145,G155,IF($D$9=$F$145,F155,IF($D$9=$H$145,H155)))/52)*12","v":27314.611199999999},null,{"$f":"D25","v":0},">>>>>>>",{"$f":"IF(B48<D48,0,(((B48/12)*14)-((D48/12)*14))*F48)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F48","v":0}]
[]
[null,null,"Band 8d",{"$f":"(IF($D$9=$G$145,G156,IF($D$9=$F$145,F156,IF($D$9=$H$145,H156)))/52)*12","v":32539.543199999993},null,{"$f":"D27","v":0},">>>>>>>",{"$f":"IF(B50<D50,0,(((B50/12)*14)-((D50/12)*14))*F50)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F50","v":0}]
[]
[null,null,"Band 9",{"$f":"(IF($D$9=$G$145,G157,IF($D$9=$F$145,F157,IF($D$9=$H$145,H157)))/52)*12","v":38906.931600000004},null,{"$f":"D29","v":0},">>>>>>>",{"$f":"IF(B52<D52,0,(((B52/12)*14)-((D52/12)*14))*F52)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F52","v":0}]
[]
[null,{"$f":"IFERROR((((B38*F38)+(B40*F40)+(B42*F42)+(B44*F44)+(B46*F46)+(B48*F48)+(B50*F50)+(B52*F52))/F54),0)","v":0},"Total",{"$f":"IFERROR((((D38*F38)+(D40*F40)+(D42*F42)+(D44*F44)+(D46*F46)+(D48*F48)+(D50*F50)+(D52*F52))/F54),0)","v":0},null,{"$f":"SUM(F38:F52)","v":0},">>>>>>>",{"$f":"SUM(H38:H52)","v":0},{"$f":"SUM(I38:I52)","v":0}]
[]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                       ",null,"Average budget for substantive post -2 weeks - per WTE               "]
[]
[null,{"$f":"(B54/12)*2","v":0},"-",{"$f":"(D54/12)*2","v":0}]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)"]
[]
[null,null,"+"]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,null,"+"]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",0,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"IF(C74>0,IF(H54<1,0,H54-H109),0)","v":0}]
[null,"Non-cash releasing saving",{"$f":"I54-I109","v":0}]
[null,"Total cash & non-cash releasing savings",{"$f":"C75+C76","v":0}]
[null,"Total saving after organisational investment is included",{"$f":"C77-B10","v":0}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"F31-C74","v":0},"X",{"$f":"B31","v":0},">>>>>>>",{"$f":"B84*D84","v":0}]
[]
[]
[]
[null,null,null,null,null,{"$f":"B15*$B$84","v":0},{"$f":"F88/B15","v":{"$error":"#DIV/0!"}},{"$f":"(((B38/12)*14)-((D38/12)*14))*F88","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F88","v":0}]
[]
[null,null,null,null,null,{"$f":"B17*$B$84","v":0},{"$f":"F90/B17","v":{"$error":"#DIV/0!"}},{"$f":"(((B40/12)*14)-((D40/12)*14))*F90","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F90","v":0}]
[]
[null,null,null,null,null,{"$f":"B19*$B$84","v":0},{"$f":"F92/B19","v":{"$error":"#DIV/0!"}},{"$f":"(((B42/12)*14)-((D42/12)*14))*F92","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F92","v":0}]
[]
[null,null,null,null,null,{"$f":"B21*$B$84","v":0},{"$f":"F94/B21","v":{"$error":"#DIV/0!"}},{"$f":"(((B44/12)*14)-((D44/12)*14))*F94","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F94","v":0}]
[]
[null,null,null,null,null,{"$f":"B23*$B$84","v":0},{"$f":"F96/B23","v":{"$error":"#DIV/0!"}},{"$f":"(((B46/12)*14)-((D46/12)*14))*F96","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F96","v":0}]
[]
[null,null,null,null,null,{"$f":"B25*$B$84","v":0},{"$f":"F98/B25","v":{"$error":"#DIV/0!"}},{"$f":"(((B48/12)*14)-((D48/12)*14))*F98","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F98","v":0}]
[]
[null,null,null,null,null,{"$f":"B27*$B$84","v":0},{"$f":"F100/B27","v":{"$error":"#DIV/0!"}},{"$f":"(((B50/12)*14)-((D50/12)*14))*F100","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F100","v":0}]
[]
[null,null,null,null,null,{"$f":"B29*$B$84","v":0},{"$f":"F102/B29","v":{"$error":"#DIV/0!"}},{"$f":"(((B52/12)*14)-((D52/12)*14))*F102","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F102","v":0}]
[]
[null,null,null,null,null,{"$f":"B31*$B$84","v":0},{"$f":"F104/B31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H88:H102)","v":0},{"$f":"SUM(I88:I102)","v":0}]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B54","v":0},"+",{"$f":"D54","v":0},"X",{"$f":"F84","v":0},">>>>>>>",{"$f":"H104","v":0},{"$f":"I104","v":0}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B58","v":0},null,{"$f":"D58","v":0}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B63","v":0},"+",{"$f":"D63","v":0}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B67","v":0},"+",{"$f":"D67","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$6=$I$133,AfC!AA2*1.2,IF($D$6=$I$134,AfC!AA2*1.15,IF($D$6=$I$135,AfC!AA2*1.05,AfC!AA2)))","v":22255.200000000001},{"$f":"IF($D$6=$I$133,AfC!AB2*1.2,IF($D$6=$J$134,AfC!AB2*1.15,IF($D$6=$I$135,AfC!AB2*1.05,AfC!AB2)))","v":22255.200000000001},{"$f":"IF($D$6=$I$133,AfC!AC2*1.2,IF($D$6=$K$134,AfC!AC2*1.15,IF($D$6=$I$135,AfC!AC2*1.05,AfC!AC2)))","v":22255.200000000001},"Basic Pay"]
[null,null,null,null,"Band 2",{"$f":"IF($D$6=$I$133,AfC!AA3*1.2,IF($D$6=$I$134,AfC!AA3*1.15,IF($D$6=$I$135,AfC!AA3*1.05,AfC!AA3)))","v":22255.200000000001},{"$f":"IF($D$6=$I$133,AfC!AB3*1.2,IF($D$6=$J$134,AfC!AB3*1.15,IF($D$6=$I$135,AfC!AB3*1.05,AfC!AB3)))","v":23901.599999999999},{"$f":"IF($D$6=$I$133,AfC!AC3*1.2,IF($D$6=$K$134,AfC!AC3*1.15,IF($D$6=$I$135,AfC!AC3*1.05,AfC!AC3)))","v":23901.599999999999},"London (inner)"]
[null,null,null,null,"Band 3",{"$f":"IF($D$6=$I$133,AfC!AA4*1.2,IF($D$6=$I$134,AfC!AA4*1.15,IF($D$6=$I$135,AfC!AA4*1.05,AfC!AA4)))","v":24396},{"$f":"IF($D$6=$I$133,AfC!AB4*1.2,IF($D$6=$J$134,AfC!AB4*1.15,IF($D$6=$I$135,AfC!AB4*1.05,AfC!AB4)))","v":26132.711999999996},{"$f":"IF($D$6=$I$133,AfC!AC4*1.2,IF($D$6=$K$134,AfC!AC4*1.15,IF($D$6=$I$135,AfC!AC4*1.05,AfC!AC4)))","v":26132.711999999996},"London (outer)"]
[null,null,null,null,"Band 4",{"$f":"IF($D$6=$I$133,AfC!AA5*1.2,IF($D$6=$I$134,AfC!AA5*1.15,IF($D$6=$I$135,AfC!AA5*1.05,AfC!AA5)))","v":27058.511999999999},{"$f":"IF($D$6=$I$133,AfC!AB5*1.2,IF($D$6=$J$134,AfC!AB5*1.15,IF($D$6=$I$135,AfC!AB5*1.05,AfC!AB5)))","v":29858.051999999996},{"$f":"IF($D$6=$I$133,AfC!AC5*1.2,IF($D$6=$K$134,AfC!AC5*1.15,IF($D$6=$I$135,AfC!AC5*1.05,AfC!AC5)))","v":29858.051999999996},"London (fringe)"]
[null,null,null,null,"Band 5",{"$f":"IF($D$6=$I$133,AfC!AA6*1.2,IF($D$6=$I$134,AfC!AA6*1.15,IF($D$6=$I$135,AfC!AA6*1.05,AfC!AA6)))","v":30786.251999999997},{"$f":"IF($D$6=$I$133,AfC!AB6*1.2,IF($D$6=$J$134,AfC!AB6*1.15,IF($D$6=$I$135,AfC!AB6*1.05,AfC!AB6)))","v":35588.729999999996},{"$f":"IF($D$6=$I$133,AfC!AC6*1.2,IF($D$6=$K$134,AfC!AC6*1.15,IF($D$6=$I$135,AfC!AC6*1.05,AfC!AC6)))","v":37841.339999999997},"\"Include on costs\""]
[null,null,null,null,"Band 6",{"$f":"IF($D$6=$I$133,AfC!AA7*1.2,IF($D$6=$I$134,AfC!AA7*1.15,IF($D$6=$I$135,AfC!AA7*1.05,AfC!AA7)))","v":38767.139999999992},{"$f":"IF($D$6=$I$133,AfC!AB7*1.2,IF($D$6=$J$134,AfC!AB7*1.15,IF($D$6=$I$135,AfC!AB7*1.05,AfC!AB7)))","v":41006.735999999997},{"$f":"IF($D$6=$I$133,AfC!AC7*1.2,IF($D$6=$K$134,AfC!AC7*1.15,IF($D$6=$I$135,AfC!AC7*1.05,AfC!AC7)))","v":46832.039999999994}]
[null,null,null,null,"Band 7",{"$f":"IF($D$6=$I$133,AfC!AA8*1.2,IF($D$6=$I$134,AfC!AA8*1.15,IF($D$6=$I$135,AfC!AA8*1.05,AfC!AA8)))","v":48068.039999999994},{"$f":"IF($D$6=$I$133,AfC!AB8*1.2,IF($D$6=$J$134,AfC!AB8*1.15,IF($D$6=$I$135,AfC!AB8*1.05,AfC!AB8)))","v":50544.983999999997},{"$f":"IF($D$6=$I$133,AfC!AC8*1.2,IF($D$6=$K$134,AfC!AC8*1.15,IF($D$6=$I$135,AfC!AC8*1.05,AfC!AC8)))","v":55006.907999999996}]
[null,null,null,null,"Band 8A",{"$f":"IF($D$6=$I$133,AfC!AA9*1.2,IF($D$6=$I$134,AfC!AA9*1.15,IF($D$6=$I$135,AfC!AA9*1.05,AfC!AA9)))","v":56550.707999999991},{"$f":"IF($D$6=$I$133,AfC!AB9*1.2,IF($D$6=$J$134,AfC!AB9*1.15,IF($D$6=$I$135,AfC!AB9*1.05,AfC!AB9)))","v":56550.707999999991},{"$f":"IF($D$6=$I$133,AfC!AC9*1.2,IF($D$6=$K$134,AfC!AC9*1.15,IF($D$6=$I$135,AfC!AC9*1.05,AfC!AC9)))","v":63862.847999999991}]
[null,null,null,null,"Band 8B",{"$f":"IF($D$6=$I$133,AfC!AA10*1.2,IF($D$6=$I$134,AfC!AA10*1.15,IF($D$6=$I$135,AfC!AA10*1.05,AfC!AA10)))","v":65716.847999999984},{"$f":"IF($D$6=$I$133,AfC!AB10*1.2,IF($D$6=$J$134,AfC!AB10*1.15,IF($D$6=$I$135,AfC!AB10*1.05,AfC!AB10)))","v":65716.847999999984},{"$f":"IF($D$6=$I$133,AfC!AC10*1.2,IF($D$6=$K$134,AfC!AC10*1.15,IF($D$6=$I$135,AfC!AC10*1.05,AfC!AC10)))","v":76634.436000000002}]
[null,null,null,null,"Band 8C",{"$f":"IF($D$6=$I$133,AfC!AA11*1.2,IF($D$6=$I$134,AfC!AA11*1.15,IF($D$6=$I$135,AfC!AA11*1.05,AfC!AA11)))","v":78796.23599999999},{"$f":"IF($D$6=$I$133,AfC!AB11*1.2,IF($D$6=$J$134,AfC!AB11*1.15,IF($D$6=$I$135,AfC!AB11*1.05,AfC!AB11)))","v":78796.23599999999},{"$f":"IF($D$6=$I$133,AfC!AC11*1.2,IF($D$6=$K$134,AfC!AC11*1.15,IF($D$6=$I$135,AfC!AC11*1.05,AfC!AC11)))","v":91048.703999999998}]
[null,null,null,null,"Band 8D",{"$f":"IF($D$6=$I$133,AfC!AA12*1.2,IF($D$6=$I$134,AfC!AA12*1.15,IF($D$6=$I$135,AfC!AA12*1.05,AfC!AA12)))","v":93830.903999999995},{"$f":"IF($D$6=$I$133,AfC!AB12*1.2,IF($D$6=$J$134,AfC!AB12*1.15,IF($D$6=$I$135,AfC!AB12*1.05,AfC!AB12)))","v":93830.903999999995},{"$f":"IF($D$6=$I$133,AfC!AC12*1.2,IF($D$6=$K$134,AfC!AC12*1.15,IF($D$6=$I$135,AfC!AC12*1.05,AfC!AC12)))","v":108465.14399999999}]
[null,null,null,null,"Band 9",{"$f":"IF($D$6=$I$133,AfC!AA13*1.2,IF($D$6=$I$134,AfC!AA13*1.15,IF($D$6=$I$135,AfC!AA13*1.05,AfC!AA13)))","v":112482.14399999999},{"$f":"IF($D$6=$I$133,AfC!AB13*1.2,IF($D$6=$J$134,AfC!AB13*1.15,IF($D$6=$I$135,AfC!AB13*1.05,AfC!AB13)))","v":112482.14399999999},{"$f":"IF($D$6=$I$133,AfC!AC13*1.2,IF($D$6=$K$134,AfC!AC13*1.15,IF($D$6=$I$135,AfC!AC13*1.05,AfC!AC13)))","v":129689.772}]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$10=$I$136,F132*1.3,F132)","v":28931.760000000002},28931.760000000002,28931.760000000002]
[null,null,null,null,"Band 2",28931.760000000002,31072.079999999998,31072.079999999998]
[null,null,null,null,"Band 3",31714.799999999999,33972.525599999994,33972.525599999994]
[null,null,null,null,"Band 4",35176.065600000002,38815.467599999996,38815.467599999996]
[null,null,null,null,"Band 5",40022.1276,46265.348999999995,49193.741999999998]
[null,null,null,null,"Band 6",50397.281999999992,53308.756799999996,60881.651999999995]
[null,null,null,null,"Band 7",62488.45199999999,65708.479200000002,71508.9804]
[null,null,null,null,"Band 8A",73515.920399999988,73515.920399999988,83021.702399999995]
[null,null,null,null,"Band 8B",85431.902399999977,85431.902399999977,99624.766800000012]
[null,null,null,null,"Band 8C",102435.10679999999,102435.10679999999,118363.3152]
[null,null,null,null,"Band 8D",121980.1752,121980.1752,141004.68719999999]
[null,null,null,null,"Band 9",146226.78719999999,146226.78719999999,168596.70360000001]

{"sheet":"Healthcare Assistant & Others","index":10,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":true,"merged":[[36,1,36,3],[36,8,41,8],[56,4,62,4],[56,5,62,5],[57,6,62,6],[57,8,62,8],[15,2,15,8],[17,4,24,4],[19,5,33,5],[19,6,33,6],[19,7,33,7],[19,8,33,8],[26,4,32,4]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Healthcare Assistant & Others"]
[]
[]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     (Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)"]
[null,150000]
[]
[null,"Number of staff leaving the organisation - last 12 months "]
[null,"Average staff turnover rate                                           (Insert)","X","Headcount                                                                         (Insert)",">>>>>>>","Total number of staff  leaving the organisation"]
[]
[null,0.15,"X",8000,">>>>>>>",{"$f":"B13*D13","v":1200}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                        (Insert)","X",{"$f":"F11","v":"Total number of staff  leaving the organisation"},null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[]
[null,10992,"-",9993,null,{"$f":"F13","v":1200},">>>>>>>",{"$f":"((B20-D20)+(B24-D24))*F20","v":1399200},{"$f":"(B29+D29+B33+D33)*F20","v":1560000}]
[]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                        (Insert)",null,"Average budget for substantive post -2 weeks - per WTE                      (Insert)"]
[]
[null,1832,"-",1665]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)","X"]
[]
[null,500,"+",400]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,300,"+",100]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",1E-3,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"H20-H57","v":9328}]
[null,"Non-cash releasing saving",{"$f":"I20-I57","v":10400}]
[null,"Total cash & non-cash releasing savings",{"$f":"C41+C42","v":19728}]
[null,"Total saving after organisational investment is included",{"$f":"C43-B8","v":-130272}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"B13-C40","v":0.14899999999999999},"X",{"$f":"D13","v":8000},">>>>>>>",{"$f":"B50*D50","v":1192}]
[]
[]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B20","v":10992},"+",{"$f":"D20","v":9993},"X",{"$f":"F50","v":1192},">>>>>>>",{"$f":"((B57-D57)+(B59-D59))*F57","v":1389872},{"$f":"(B61+D61+B63+D63)*F57","v":1549600}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B24","v":1832},null,{"$f":"D24","v":1665}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B29","v":500},"+",{"$f":"D29","v":400}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B33","v":300},"+",{"$f":"D33","v":100}]

{"sheet":"Healthcare Assistant & Others ","index":11,"n_rows":152,"n_cols":9,"rows_kept":152,"cut":false,"hidden":false,"merged":[[5,3,7,3],[87,4,93,4],[87,5,93,5],[88,6,93,6],[88,8,93,8],[25,2,25,8],[27,4,42,4],[39,5,51,8],[44,4,50,4],[54,1,54,3],[54,8,59,8]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Healthcare Assistants & Others"]
[]
[null,"Calculated Field"]
[null,"Prepopulated Cell",null,"Basic Pay"]
[null,"Enter Data in Cell"]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     \n(Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)",null,"Bottom pay point"]
[null,0,null,"\"Exclude on costs\""]
[]
[null,"Workforce data - headcounts and leavers"]
[null,"Headcount                                                                             (Insert)","X","Total number of staff leaving the organisation                                          (Insert)",">>>>>>>","Average turnover rate %"]
[]
[null,null,"Band 1",null,">>>>>>>",{"$f":"IFERROR(D15/B15,0)","v":0}]
[]
[null,null,"Band 2",null,">>>>>>>",{"$f":"IFERROR(D17/B17,0)","v":0}]
[]
[null,null,"Band 3",null,">>>>>>>",{"$f":"IFERROR(D19/B19,0)","v":0}]
[]
[null,null,"Band 4",null,">>>>>>>",{"$f":"IFERROR(D21/B21,0)","v":0}]
[]
[null,{"$f":"SUM(B15:B21)","v":0},"Total",{"$f":"SUM(D15:D21)","v":0},">>>>>>>",{"$f":"IFERROR(D23/B23,0)","v":0}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                       ","X","Total number of staff  leaving the organisation",null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[]
[null,null,"Band 1",{"$f":"(IF($D$9=$G$140,G141,IF($D$9=$F$140,F141,IF($D$9=$H$140,H141)))/52)*12","v":4279.8461538461534},null,{"$f":"D15","v":0},">>>>>>>",{"$f":"IF(B30<D30,0,(((B30/12)*14)-((D30/12)*14))*F30)","v":0},{"$f":"(B$47+D$47+B$51+D$51)*F30","v":0}]
[]
[null,null,"Band 2",{"$f":"(IF($D$9=$G$140,G142,IF($D$9=$F$140,F142,IF($D$9=$H$140,H142)))/52)*12","v":4279.8461538461534},null,{"$f":"D17","v":0},">>>>>>>",{"$f":"IF(B32<D32,0,(((B32/12)*14)-((D32/12)*14))*F32)","v":0},{"$f":"(B$47+D$47+B$51+D$51)*F32","v":0}]
[]
[null,null,"Band 3",{"$f":"(IF($D$9=$G$140,G143,IF($D$9=$F$140,F143,IF($D$9=$H$140,H143)))/52)*12","v":4691.538461538461},null,{"$f":"D19","v":0},">>>>>>>",{"$f":"IF(B34<D34,0,(((B34/12)*14)-((D34/12)*14))*F34)","v":0},{"$f":"(B$47+D$47+B$51+D$51)*F34","v":0}]
[]
[null,null,"Band 4",{"$f":"(IF($D$9=$G$140,G144,IF($D$9=$F$140,F144,IF($D$9=$H$140,H144)))/52)*12","v":5203.5599999999995},null,{"$f":"D21","v":0},">>>>>>>",{"$f":"IF(B36<D36,0,(((B36/12)*14)-((D36/12)*14))*F36)","v":0},{"$f":"(B$47+D$47+B$51+D$51)*F36","v":0}]
[]
[null,{"$f":"IFERROR((((B30*F30)+(B32*F32)+(B34*F34)+(B36*F36))/F38),0)","v":0},"Total",{"$f":"IFERROR((((D30*F30)+(D32*F32)+(D34*F34)+(D36*F36))/F38),0)","v":0},null,{"$f":"SUM(F30:F36)","v":0},">>>>>>>",{"$f":"SUM(H30:H36)","v":0},{"$f":"SUM(I30:I36)","v":0}]
[]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                       ",null,"Average budget for substantive post -2 weeks - per WTE               "]
[]
[null,{"$f":"(B38/12)*2","v":0},"-",{"$f":"(D38/12)*2","v":0}]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)"]
[]
[null,null,"+"]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,null,"+"]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",0,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"IF(C58>0,IF(H38<1,0,H38-H88),0)","v":0}]
[null,"Non-cash releasing saving",{"$f":"I38-I88","v":0}]
[null,"Total cash & non-cash releasing savings",{"$f":"C59+C60","v":0}]
[null,"Total saving after organisational investment is included",{"$f":"C61-B10","v":0}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"F23-C58","v":0},"X",{"$f":"B23","v":0},">>>>>>>",{"$f":"B68*D68","v":0}]
[]
[]
[null,null,null,null,null,{"$f":"B15*$B$68","v":0},{"$f":"F71/B15","v":{"$error":"#DIV/0!"}},{"$f":"(((B30/12)*14)-((D30/12)*14))*F71","v":0},{"$f":"(B$47+D$47+B$51+D$51)*F71","v":0}]
[]
[null,null,null,null,null,{"$f":"B17*$B$68","v":0},{"$f":"F73/B17","v":{"$error":"#DIV/0!"}},{"$f":"(((B32/12)*14)-((D32/12)*14))*F73","v":0},{"$f":"(B$47+D$47+B$51+D$51)*F73","v":0}]
[]
[null,null,null,null,null,{"$f":"B19*$B$68","v":0},{"$f":"F75/B19","v":{"$error":"#DIV/0!"}},{"$f":"(((B34/12)*14)-((D34/12)*14))*F75","v":0},{"$f":"(B$47+D$47+B$51+D$51)*F75","v":0}]
[]
[null,null,null,null,null,{"$f":"B21*$B$68","v":0},{"$f":"F77/B21","v":{"$error":"#DIV/0!"}},{"$f":"(((B36/12)*14)-((D36/12)*14))*F77","v":0},{"$f":"(B$47+D$47+B$51+D$51)*F77","v":0}]
[]
[null,null,null,null,null,{"$f":"B23*$B$68","v":0},{"$f":"F79/B23","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H71:H78)","v":0},{"$f":"SUM(I71:I78)","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B38","v":0},"+",{"$f":"D38","v":0},"X",{"$f":"F68","v":0},">>>>>>>",{"$f":"H79","v":0},{"$f":"I79","v":0}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B42","v":0},null,{"$f":"D42","v":0}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B47","v":0},"+",{"$f":"D47","v":0}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B51","v":0},"+",{"$f":"D51","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$6=$I$128,AfC!AA2*1.2,IF($D$6=$I$129,AfC!AA2*1.15,IF($D$6=$I$130,AfC!AA2*1.05,AfC!AA2)))","v":18546},{"$f":"IF($D$6=$I$128,AfC!AB2*1.2,IF($D$6=$J$129,AfC!AB2*1.15,IF($D$6=$I$130,AfC!AB2*1.05,AfC!AB2)))","v":18546},{"$f":"IF($D$6=$I$128,AfC!AC2*1.2,IF($D$6=$K$129,AfC!AC2*1.15,IF($D$6=$I$130,AfC!AC2*1.05,AfC!AC2)))","v":18546},"Basic Pay"]
[null,null,null,null,"Band 2",{"$f":"IF($D$6=$I$128,AfC!AA3*1.2,IF($D$6=$I$129,AfC!AA3*1.15,IF($D$6=$I$130,AfC!AA3*1.05,AfC!AA3)))","v":18546},{"$f":"IF($D$6=$I$128,AfC!AB3*1.2,IF($D$6=$J$129,AfC!AB3*1.15,IF($D$6=$I$130,AfC!AB3*1.05,AfC!AB3)))","v":19918},{"$f":"IF($D$6=$I$128,AfC!AC3*1.2,IF($D$6=$K$129,AfC!AC3*1.15,IF($D$6=$I$130,AfC!AC3*1.05,AfC!AC3)))","v":19918},"London (inner)"]
[null,null,null,null,"Band 3",{"$f":"IF($D$6=$I$128,AfC!AA4*1.2,IF($D$6=$I$129,AfC!AA4*1.15,IF($D$6=$I$130,AfC!AA4*1.05,AfC!AA4)))","v":20330},{"$f":"IF($D$6=$I$128,AfC!AB4*1.2,IF($D$6=$J$129,AfC!AB4*1.15,IF($D$6=$I$130,AfC!AB4*1.05,AfC!AB4)))","v":21777.26},{"$f":"IF($D$6=$I$128,AfC!AC4*1.2,IF($D$6=$K$129,AfC!AC4*1.15,IF($D$6=$I$130,AfC!AC4*1.05,AfC!AC4)))","v":21777.26},"London (outer)"]
[null,null,null,null,"Band 4",{"$f":"IF($D$6=$I$128,AfC!AA5*1.2,IF($D$6=$I$129,AfC!AA5*1.15,IF($D$6=$I$130,AfC!AA5*1.05,AfC!AA5)))","v":22548.76},{"$f":"IF($D$6=$I$128,AfC!AB5*1.2,IF($D$6=$J$129,AfC!AB5*1.15,IF($D$6=$I$130,AfC!AB5*1.05,AfC!AB5)))","v":24881.71},{"$f":"IF($D$6=$I$128,AfC!AC5*1.2,IF($D$6=$K$129,AfC!AC5*1.15,IF($D$6=$I$130,AfC!AC5*1.05,AfC!AC5)))","v":24881.71},"London (fringe)"]
[null,null,null,null,"Band 5",{"$f":"IF($D$6=$I$128,AfC!AA6*1.2,IF($D$6=$I$129,AfC!AA6*1.15,IF($D$6=$I$130,AfC!AA6*1.05,AfC!AA6)))","v":25655.21},{"$f":"IF($D$6=$I$128,AfC!AB6*1.2,IF($D$6=$J$129,AfC!AB6*1.15,IF($D$6=$I$130,AfC!AB6*1.05,AfC!AB6)))","v":29657.274999999998},{"$f":"IF($D$6=$I$128,AfC!AC6*1.2,IF($D$6=$K$129,AfC!AC6*1.15,IF($D$6=$I$130,AfC!AC6*1.05,AfC!AC6)))","v":31534.449999999997},"\"Include on costs\""]
[null,null,null,null,"Band 6",{"$f":"IF($D$6=$I$128,AfC!AA7*1.2,IF($D$6=$I$129,AfC!AA7*1.15,IF($D$6=$I$130,AfC!AA7*1.05,AfC!AA7)))","v":32305.949999999997},{"$f":"IF($D$6=$I$128,AfC!AB7*1.2,IF($D$6=$J$129,AfC!AB7*1.15,IF($D$6=$I$130,AfC!AB7*1.05,AfC!AB7)))","v":34172.28},{"$f":"IF($D$6=$I$128,AfC!AC7*1.2,IF($D$6=$K$129,AfC!AC7*1.15,IF($D$6=$I$130,AfC!AC7*1.05,AfC!AC7)))","v":39026.699999999997}]
[null,null,null,null,"Band 7",{"$f":"IF($D$6=$I$128,AfC!AA8*1.2,IF($D$6=$I$129,AfC!AA8*1.15,IF($D$6=$I$130,AfC!AA8*1.05,AfC!AA8)))","v":40056.699999999997},{"$f":"IF($D$6=$I$128,AfC!AB8*1.2,IF($D$6=$J$129,AfC!AB8*1.15,IF($D$6=$I$130,AfC!AB8*1.05,AfC!AB8)))","v":42120.82},{"$f":"IF($D$6=$I$128,AfC!AC8*1.2,IF($D$6=$K$129,AfC!AC8*1.15,IF($D$6=$I$130,AfC!AC8*1.05,AfC!AC8)))","v":45839.09}]
[null,null,null,null,"Band 8A",{"$f":"IF($D$6=$I$128,AfC!AA9*1.2,IF($D$6=$I$129,AfC!AA9*1.15,IF($D$6=$I$130,AfC!AA9*1.05,AfC!AA9)))","v":47125.59},{"$f":"IF($D$6=$I$128,AfC!AB9*1.2,IF($D$6=$J$129,AfC!AB9*1.15,IF($D$6=$I$130,AfC!AB9*1.05,AfC!AB9)))","v":47125.59},{"$f":"IF($D$6=$I$128,AfC!AC9*1.2,IF($D$6=$K$129,AfC!AC9*1.15,IF($D$6=$I$130,AfC!AC9*1.05,AfC!AC9)))","v":53219.039999999994}]
[null,null,null,null,"Band 8B",{"$f":"IF($D$6=$I$128,AfC!AA10*1.2,IF($D$6=$I$129,AfC!AA10*1.15,IF($D$6=$I$130,AfC!AA10*1.05,AfC!AA10)))","v":54764.039999999994},{"$f":"IF($D$6=$I$128,AfC!AB10*1.2,IF($D$6=$J$129,AfC!AB10*1.15,IF($D$6=$I$130,AfC!AB10*1.05,AfC!AB10)))","v":54764.039999999994},{"$f":"IF($D$6=$I$128,AfC!AC10*1.2,IF($D$6=$K$129,AfC!AC10*1.15,IF($D$6=$I$130,AfC!AC10*1.05,AfC!AC10)))","v":63862.03}]
[null,null,null,null,"Band 8C",{"$f":"IF($D$6=$I$128,AfC!AA11*1.2,IF($D$6=$I$129,AfC!AA11*1.15,IF($D$6=$I$130,AfC!AA11*1.05,AfC!AA11)))","v":65663.53},{"$f":"IF($D$6=$I$128,AfC!AB11*1.2,IF($D$6=$J$129,AfC!AB11*1.15,IF($D$6=$I$130,AfC!AB11*1.05,AfC!AB11)))","v":65663.53},{"$f":"IF($D$6=$I$128,AfC!AC11*1.2,IF($D$6=$K$129,AfC!AC11*1.15,IF($D$6=$I$130,AfC!AC11*1.05,AfC!AC11)))","v":75873.919999999998}]
[null,null,null,null,"Band 8D",{"$f":"IF($D$6=$I$128,AfC!AA12*1.2,IF($D$6=$I$129,AfC!AA12*1.15,IF($D$6=$I$130,AfC!AA12*1.05,AfC!AA12)))","v":78192.42},{"$f":"IF($D$6=$I$128,AfC!AB12*1.2,IF($D$6=$J$129,AfC!AB12*1.15,IF($D$6=$I$130,AfC!AB12*1.05,AfC!AB12)))","v":78192.42},{"$f":"IF($D$6=$I$128,AfC!AC12*1.2,IF($D$6=$K$129,AfC!AC12*1.15,IF($D$6=$I$130,AfC!AC12*1.05,AfC!AC12)))","v":90387.62}]
[null,null,null,null,"Band 9",{"$f":"IF($D$6=$I$128,AfC!AA13*1.2,IF($D$6=$I$129,AfC!AA13*1.15,IF($D$6=$I$130,AfC!AA13*1.05,AfC!AA13)))","v":93735.12},{"$f":"IF($D$6=$I$128,AfC!AB13*1.2,IF($D$6=$J$129,AfC!AB13*1.15,IF($D$6=$I$130,AfC!AB13*1.05,AfC!AB13)))","v":93735.12},{"$f":"IF($D$6=$I$128,AfC!AC13*1.2,IF($D$6=$K$129,AfC!AC13*1.15,IF($D$6=$I$130,AfC!AC13*1.05,AfC!AC13)))","v":108074.81}]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$10=$I$131,F127*1.3,F127)","v":18546},18546,18546]
[null,null,null,null,"Band 2",18546,19918,19918]
[null,null,null,null,"Band 3",20330,21777.26,21777.26]
[null,null,null,null,"Band 4",22548.76,24881.71,24881.71]
[null,null,null,null,"Band 5",25655.21,29657.274999999998,31534.449999999997]
[null,null,null,null,"Band 6",32305.949999999997,34172.28,39026.699999999997]
[null,null,null,null,"Band 7",40056.699999999997,42120.82,45839.09]
[null,null,null,null,"Band 8A",47125.59,47125.59,53219.039999999994]
[null,null,null,null,"Band 8B",54764.039999999994,54764.039999999994,63862.03]
[null,null,null,null,"Band 8C",65663.53,65663.53,75873.919999999998]
[null,null,null,null,"Band 8D",78192.42,78192.42,90387.62]
[null,null,null,null,"Band 9",93735.12,93735.12,108074.81]

{"sheet":"Healthcare Science","index":12,"n_rows":157,"n_cols":9,"rows_kept":157,"cut":false,"hidden":false,"merged":[[108,4,114,4],[108,5,114,5],[109,6,114,6],[109,8,114,8],[5,3,7,3],[33,2,33,8],[35,4,58,4],[55,5,67,8],[60,4,66,4],[70,1,70,3],[70,8,75,8]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Healthcare Science"]
[]
[null,"Calculated Field",null,"Agenda for Change costings"]
[null,"Prepopulated Cell",null,"London (inner)"]
[null,"Enter Data in Cell"]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     \n(Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)",null,"Top pay point"]
[null,0,null,"\"Include on costs\""]
[]
[null,"Workforce data - headcounts and leavers"]
[null,"Headcount                                                                             (Insert)","X","Total number of staff leaving the organisation                                          (Insert)",">>>>>>>","Average turnover rate %"]
[]
[null,null,"Band 5",null,">>>>>>>",{"$f":"IFERROR(D15/B15,0)","v":0}]
[]
[null,null,"Band 6",null,">>>>>>>",{"$f":"IFERROR(D17/B17,0)","v":0}]
[]
[null,null,"Band 7",null,">>>>>>>",{"$f":"IFERROR(D19/B19,0)","v":0}]
[]
[null,null,"Band 8a",null,">>>>>>>",{"$f":"IFERROR(D21/B21,0)","v":0}]
[]
[null,null,"Band 8b",null,">>>>>>>",{"$f":"IFERROR(D23/B23,0)","v":0}]
[]
[null,null,"Band 8c",null,">>>>>>>",{"$f":"IFERROR(D25/B25,0)","v":0}]
[]
[null,null,"Band 8d",null,">>>>>>>",{"$f":"IFERROR(D27/B27,0)","v":0}]
[]
[null,null,"Band 9",null,">>>>>>>",{"$f":"IFERROR(D29/B29,0)","v":0}]
[]
[null,{"$f":"SUM(B15:B29)","v":0},"Total",{"$f":"SUM(D15:D29)","v":0},">>>>>>>",{"$f":"IFERROR(D31/B31,0)","v":0}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                       ","X","Total number of staff  leaving the organisation",null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[]
[null,null,"Band 5",{"$f":"(IF($D$9=$G$145,G150,IF($D$9=$F$145,F150,IF($D$9=$H$145,H150)))/52)*12","v":11352.402},null,{"$f":"D15","v":0},">>>>>>>",{"$f":"IF(B38<D38,0,(((B38/12)*14)-((D38/12)*14))*F38)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F38","v":0}]
[]
[null,null,"Band 6",{"$f":"(IF($D$9=$G$145,G151,IF($D$9=$F$145,F151,IF($D$9=$H$145,H151)))/52)*12","v":14049.611999999999},null,{"$f":"D17","v":0},">>>>>>>",{"$f":"IF(B40<D40,0,(((B40/12)*14)-((D40/12)*14))*F40)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F40","v":0}]
[]
[null,null,"Band 7",{"$f":"(IF($D$9=$G$145,G152,IF($D$9=$F$145,F152,IF($D$9=$H$145,H152)))/52)*12","v":16502.072400000001},null,{"$f":"D19","v":0},">>>>>>>",{"$f":"IF(B42<D42,0,(((B42/12)*14)-((D42/12)*14))*F42)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F42","v":0}]
[]
[null,null,"Band 8a",{"$f":"(IF($D$9=$G$145,G153,IF($D$9=$F$145,F153,IF($D$9=$H$145,H153)))/52)*12","v":19158.854399999997},null,{"$f":"D21","v":0},">>>>>>>",{"$f":"IF(B44<D44,0,(((B44/12)*14)-((D44/12)*14))*F44)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F44","v":0}]
[]
[null,null,"Band 8b",{"$f":"(IF($D$9=$G$145,G154,IF($D$9=$F$145,F154,IF($D$9=$H$145,H154)))/52)*12","v":22990.330800000003},null,{"$f":"D23","v":0},">>>>>>>",{"$f":"IF(B46<D46,0,(((B46/12)*14)-((D46/12)*14))*F46)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F46","v":0}]
[]
[null,null,"Band 8c",{"$f":"(IF($D$9=$G$145,G155,IF($D$9=$F$145,F155,IF($D$9=$H$145,H155)))/52)*12","v":27314.611199999999},null,{"$f":"D25","v":0},">>>>>>>",{"$f":"IF(B48<D48,0,(((B48/12)*14)-((D48/12)*14))*F48)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F48","v":0}]
[]
[null,null,"Band 8d",{"$f":"(IF($D$9=$G$145,G156,IF($D$9=$F$145,F156,IF($D$9=$H$145,H156)))/52)*12","v":32539.543199999993},null,{"$f":"D27","v":0},">>>>>>>",{"$f":"IF(B50<D50,0,(((B50/12)*14)-((D50/12)*14))*F50)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F50","v":0}]
[]
[null,null,"Band 9",{"$f":"(IF($D$9=$G$145,G157,IF($D$9=$F$145,F157,IF($D$9=$H$145,H157)))/52)*12","v":38906.931600000004},null,{"$f":"D29","v":0},">>>>>>>",{"$f":"IF(B52<D52,0,(((B52/12)*14)-((D52/12)*14))*F52)","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F52","v":0}]
[]
[null,{"$f":"IFERROR((((B38*F38)+(B40*F40)+(B42*F42)+(B44*F44)+(B46*F46)+(B48*F48)+(B50*F50)+(B52*F52))/F54),)","v":0},"Total",{"$f":"IFERROR((((D38*F38)+(D40*F40)+(D42*F42)+(D44*F44)+(D46*F46)+(D48*F48)+(D50*F50)+(D52*F52))/F54),0)","v":0},null,{"$f":"SUM(F38:F52)","v":0},">>>>>>>",{"$f":"SUM(H38:H52)","v":0},{"$f":"SUM(I38:I52)","v":0}]
[]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                       ",null,"Average budget for substantive post -2 weeks - per WTE               "]
[]
[null,{"$f":"(B54/12)*2","v":0},"-",{"$f":"(D54/12)*2","v":0}]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)"]
[]
[null,null,"+"]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,null,"+"]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",0,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"IF(C74>0,IF(H54<1,0,H54-H109),0)","v":0}]
[null,"Non-cash releasing saving",{"$f":"I54-I109","v":0}]
[null,"Total cash & non-cash releasing savings",{"$f":"C75+C76","v":0}]
[null,"Total saving after organisational investment is included",{"$f":"C77-B10","v":0}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"F31-C74","v":0},"X",{"$f":"B31","v":0},">>>>>>>",{"$f":"B84*D84","v":0}]
[]
[]
[]
[null,null,null,null,null,{"$f":"B15*$B$84","v":0},{"$f":"F88/B15","v":{"$error":"#DIV/0!"}},{"$f":"(((B38/12)*14)-((D38/12)*14))*F88","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F88","v":0}]
[]
[null,null,null,null,null,{"$f":"B17*$B$84","v":0},{"$f":"F90/B17","v":{"$error":"#DIV/0!"}},{"$f":"(((B40/12)*14)-((D40/12)*14))*F90","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F90","v":0}]
[]
[null,null,null,null,null,{"$f":"B19*$B$84","v":0},{"$f":"F92/B19","v":{"$error":"#DIV/0!"}},{"$f":"(((B42/12)*14)-((D42/12)*14))*F92","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F92","v":0}]
[]
[null,null,null,null,null,{"$f":"B21*$B$84","v":0},{"$f":"F94/B21","v":{"$error":"#DIV/0!"}},{"$f":"(((B44/12)*14)-((D44/12)*14))*F94","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F94","v":0}]
[]
[null,null,null,null,null,{"$f":"B23*$B$84","v":0},{"$f":"F96/B23","v":{"$error":"#DIV/0!"}},{"$f":"(((B46/12)*14)-((D46/12)*14))*F96","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F96","v":0}]
[]
[null,null,null,null,null,{"$f":"B25*$B$84","v":0},{"$f":"F98/B25","v":{"$error":"#DIV/0!"}},{"$f":"(((B48/12)*14)-((D48/12)*14))*F98","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F98","v":0}]
[]
[null,null,null,null,null,{"$f":"B27*$B$84","v":0},{"$f":"F100/B27","v":{"$error":"#DIV/0!"}},{"$f":"(((B50/12)*14)-((D50/12)*14))*F100","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F100","v":0}]
[]
[null,null,null,null,null,{"$f":"B29*$B$84","v":0},{"$f":"F102/B29","v":{"$error":"#DIV/0!"}},{"$f":"(((B52/12)*14)-((D52/12)*14))*F102","v":0},{"$f":"(B$63+D$63+B$67+D$67)*F102","v":0}]
[]
[null,null,null,null,null,{"$f":"B31*$B$84","v":0},{"$f":"F104/B31","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H88:H102)","v":0},{"$f":"SUM(I88:I102)","v":0}]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B54","v":0},"+",{"$f":"D54","v":0},"X",{"$f":"F84","v":0},">>>>>>>",{"$f":"H104","v":0},{"$f":"I104","v":0}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B58","v":0},null,{"$f":"D58","v":0}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B63","v":0},"+",{"$f":"D63","v":0}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B67","v":0},"+",{"$f":"D67","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$6=$I$133,AfC!AA2*1.2,IF($D$6=$I$134,AfC!AA2*1.15,IF($D$6=$I$135,AfC!AA2*1.05,AfC!AA2)))","v":22255.200000000001},{"$f":"IF($D$6=$I$133,AfC!AB2*1.2,IF($D$6=$J$134,AfC!AB2*1.15,IF($D$6=$I$135,AfC!AB2*1.05,AfC!AB2)))","v":22255.200000000001},{"$f":"IF($D$6=$I$133,AfC!AC2*1.2,IF($D$6=$K$134,AfC!AC2*1.15,IF($D$6=$I$135,AfC!AC2*1.05,AfC!AC2)))","v":22255.200000000001},"Basic Pay"]
[null,null,null,null,"Band 2",{"$f":"IF($D$6=$I$133,AfC!AA3*1.2,IF($D$6=$I$134,AfC!AA3*1.15,IF($D$6=$I$135,AfC!AA3*1.05,AfC!AA3)))","v":22255.200000000001},{"$f":"IF($D$6=$I$133,AfC!AB3*1.2,IF($D$6=$J$134,AfC!AB3*1.15,IF($D$6=$I$135,AfC!AB3*1.05,AfC!AB3)))","v":23901.599999999999},{"$f":"IF($D$6=$I$133,AfC!AC3*1.2,IF($D$6=$K$134,AfC!AC3*1.15,IF($D$6=$I$135,AfC!AC3*1.05,AfC!AC3)))","v":23901.599999999999},"London (inner)"]
[null,null,null,null,"Band 3",{"$f":"IF($D$6=$I$133,AfC!AA4*1.2,IF($D$6=$I$134,AfC!AA4*1.15,IF($D$6=$I$135,AfC!AA4*1.05,AfC!AA4)))","v":24396},{"$f":"IF($D$6=$I$133,AfC!AB4*1.2,IF($D$6=$J$134,AfC!AB4*1.15,IF($D$6=$I$135,AfC!AB4*1.05,AfC!AB4)))","v":26132.711999999996},{"$f":"IF($D$6=$I$133,AfC!AC4*1.2,IF($D$6=$K$134,AfC!AC4*1.15,IF($D$6=$I$135,AfC!AC4*1.05,AfC!AC4)))","v":26132.711999999996},"London (outer)"]
[null,null,null,null,"Band 4",{"$f":"IF($D$6=$I$133,AfC!AA5*1.2,IF($D$6=$I$134,AfC!AA5*1.15,IF($D$6=$I$135,AfC!AA5*1.05,AfC!AA5)))","v":27058.511999999999},{"$f":"IF($D$6=$I$133,AfC!AB5*1.2,IF($D$6=$J$134,AfC!AB5*1.15,IF($D$6=$I$135,AfC!AB5*1.05,AfC!AB5)))","v":29858.051999999996},{"$f":"IF($D$6=$I$133,AfC!AC5*1.2,IF($D$6=$K$134,AfC!AC5*1.15,IF($D$6=$I$135,AfC!AC5*1.05,AfC!AC5)))","v":29858.051999999996},"London (fringe)"]
[null,null,null,null,"Band 5",{"$f":"IF($D$6=$I$133,AfC!AA6*1.2,IF($D$6=$I$134,AfC!AA6*1.15,IF($D$6=$I$135,AfC!AA6*1.05,AfC!AA6)))","v":30786.251999999997},{"$f":"IF($D$6=$I$133,AfC!AB6*1.2,IF($D$6=$J$134,AfC!AB6*1.15,IF($D$6=$I$135,AfC!AB6*1.05,AfC!AB6)))","v":35588.729999999996},{"$f":"IF($D$6=$I$133,AfC!AC6*1.2,IF($D$6=$K$134,AfC!AC6*1.15,IF($D$6=$I$135,AfC!AC6*1.05,AfC!AC6)))","v":37841.339999999997},"\"Include on costs\""]
[null,null,null,null,"Band 6",{"$f":"IF($D$6=$I$133,AfC!AA7*1.2,IF($D$6=$I$134,AfC!AA7*1.15,IF($D$6=$I$135,AfC!AA7*1.05,AfC!AA7)))","v":38767.139999999992},{"$f":"IF($D$6=$I$133,AfC!AB7*1.2,IF($D$6=$J$134,AfC!AB7*1.15,IF($D$6=$I$135,AfC!AB7*1.05,AfC!AB7)))","v":41006.735999999997},{"$f":"IF($D$6=$I$133,AfC!AC7*1.2,IF($D$6=$K$134,AfC!AC7*1.15,IF($D$6=$I$135,AfC!AC7*1.05,AfC!AC7)))","v":46832.039999999994}]
[null,null,null,null,"Band 7",{"$f":"IF($D$6=$I$133,AfC!AA8*1.2,IF($D$6=$I$134,AfC!AA8*1.15,IF($D$6=$I$135,AfC!AA8*1.05,AfC!AA8)))","v":48068.039999999994},{"$f":"IF($D$6=$I$133,AfC!AB8*1.2,IF($D$6=$J$134,AfC!AB8*1.15,IF($D$6=$I$135,AfC!AB8*1.05,AfC!AB8)))","v":50544.983999999997},{"$f":"IF($D$6=$I$133,AfC!AC8*1.2,IF($D$6=$K$134,AfC!AC8*1.15,IF($D$6=$I$135,AfC!AC8*1.05,AfC!AC8)))","v":55006.907999999996}]
[null,null,null,null,"Band 8A",{"$f":"IF($D$6=$I$133,AfC!AA9*1.2,IF($D$6=$I$134,AfC!AA9*1.15,IF($D$6=$I$135,AfC!AA9*1.05,AfC!AA9)))","v":56550.707999999991},{"$f":"IF($D$6=$I$133,AfC!AB9*1.2,IF($D$6=$J$134,AfC!AB9*1.15,IF($D$6=$I$135,AfC!AB9*1.05,AfC!AB9)))","v":56550.707999999991},{"$f":"IF($D$6=$I$133,AfC!AC9*1.2,IF($D$6=$K$134,AfC!AC9*1.15,IF($D$6=$I$135,AfC!AC9*1.05,AfC!AC9)))","v":63862.847999999991}]
[null,null,null,null,"Band 8B",{"$f":"IF($D$6=$I$133,AfC!AA10*1.2,IF($D$6=$I$134,AfC!AA10*1.15,IF($D$6=$I$135,AfC!AA10*1.05,AfC!AA10)))","v":65716.847999999984},{"$f":"IF($D$6=$I$133,AfC!AB10*1.2,IF($D$6=$J$134,AfC!AB10*1.15,IF($D$6=$I$135,AfC!AB10*1.05,AfC!AB10)))","v":65716.847999999984},{"$f":"IF($D$6=$I$133,AfC!AC10*1.2,IF($D$6=$K$134,AfC!AC10*1.15,IF($D$6=$I$135,AfC!AC10*1.05,AfC!AC10)))","v":76634.436000000002}]
[null,null,null,null,"Band 8C",{"$f":"IF($D$6=$I$133,AfC!AA11*1.2,IF($D$6=$I$134,AfC!AA11*1.15,IF($D$6=$I$135,AfC!AA11*1.05,AfC!AA11)))","v":78796.23599999999},{"$f":"IF($D$6=$I$133,AfC!AB11*1.2,IF($D$6=$J$134,AfC!AB11*1.15,IF($D$6=$I$135,AfC!AB11*1.05,AfC!AB11)))","v":78796.23599999999},{"$f":"IF($D$6=$I$133,AfC!AC11*1.2,IF($D$6=$K$134,AfC!AC11*1.15,IF($D$6=$I$135,AfC!AC11*1.05,AfC!AC11)))","v":91048.703999999998}]
[null,null,null,null,"Band 8D",{"$f":"IF($D$6=$I$133,AfC!AA12*1.2,IF($D$6=$I$134,AfC!AA12*1.15,IF($D$6=$I$135,AfC!AA12*1.05,AfC!AA12)))","v":93830.903999999995},{"$f":"IF($D$6=$I$133,AfC!AB12*1.2,IF($D$6=$J$134,AfC!AB12*1.15,IF($D$6=$I$135,AfC!AB12*1.05,AfC!AB12)))","v":93830.903999999995},{"$f":"IF($D$6=$I$133,AfC!AC12*1.2,IF($D$6=$K$134,AfC!AC12*1.15,IF($D$6=$I$135,AfC!AC12*1.05,AfC!AC12)))","v":108465.14399999999}]
[null,null,null,null,"Band 9",{"$f":"IF($D$6=$I$133,AfC!AA13*1.2,IF($D$6=$I$134,AfC!AA13*1.15,IF($D$6=$I$135,AfC!AA13*1.05,AfC!AA13)))","v":112482.14399999999},{"$f":"IF($D$6=$I$133,AfC!AB13*1.2,IF($D$6=$J$134,AfC!AB13*1.15,IF($D$6=$I$135,AfC!AB13*1.05,AfC!AB13)))","v":112482.14399999999},{"$f":"IF($D$6=$I$133,AfC!AC13*1.2,IF($D$6=$K$134,AfC!AC13*1.15,IF($D$6=$I$135,AfC!AC13*1.05,AfC!AC13)))","v":129689.772}]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$10=$I$136,F132*1.3,F132)","v":28931.760000000002},28931.760000000002,28931.760000000002]
[null,null,null,null,"Band 2",28931.760000000002,31072.079999999998,31072.079999999998]
[null,null,null,null,"Band 3",31714.799999999999,33972.525599999994,33972.525599999994]
[null,null,null,null,"Band 4",35176.065600000002,38815.467599999996,38815.467599999996]
[null,null,null,null,"Band 5",40022.1276,46265.348999999995,49193.741999999998]
[null,null,null,null,"Band 6",50397.281999999992,53308.756799999996,60881.651999999995]
[null,null,null,null,"Band 7",62488.45199999999,65708.479200000002,71508.9804]
[null,null,null,null,"Band 8A",73515.920399999988,73515.920399999988,83021.702399999995]
[null,null,null,null,"Band 8B",85431.902399999977,85431.902399999977,99624.766800000012]
[null,null,null,null,"Band 8C",102435.10679999999,102435.10679999999,118363.3152]
[null,null,null,null,"Band 8D",121980.1752,121980.1752,141004.68719999999]
[null,null,null,null,"Band 9",146226.78719999999,146226.78719999999,168596.70360000001]

{"sheet":"Others","index":13,"n_rows":186,"n_cols":21,"rows_kept":186,"cut":false,"hidden":false,"merged":[[137,4,143,4],[137,5,143,5],[138,6,143,6],[138,8,143,8],[5,3,7,3],[41,2,41,8],[43,4,74,4],[71,5,83,8],[76,4,82,4],[86,1,86,3],[86,8,91,8]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Others"]
[]
[null,"Calculated Field",null,"Agenda for Change costings"]
[null,"Prepopulated Cell",null,"London (inner)"]
[null,"Enter Data in Cell"]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     \n(Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)",null,"Top pay point"]
[null,0,null,"\"Include on costs\""]
[]
[null,"Workforce data - headcounts and leavers"]
[null,"Headcount                                                                             (Insert)","X","Total number of staff leaving the organisation                                          (Insert)",">>>>>>>","Average turnover rate %"]
[]
[null,null,"Band 1",null,">>>>>>>",{"$f":"IFERROR(D15/B15,0)","v":0}]
[]
[null,null,"Band 2",null,">>>>>>>",{"$f":"IFERROR(D17/B17,0)","v":0}]
[]
[null,null,"Band 3",null,">>>>>>>",{"$f":"IFERROR(D19/B19,0)","v":0}]
[]
[null,null,"Band 4",null,">>>>>>>",{"$f":"IFERROR(D21/B21,0)","v":0}]
[]
[null,null,"Band 5",null,">>>>>>>",{"$f":"IFERROR(D23/B23,0)","v":0}]
[]
[null,null,"Band 6",null,">>>>>>>",{"$f":"IFERROR(D25/B25,0)","v":0}]
[]
[null,null,"Band 7",null,">>>>>>>",{"$f":"IFERROR(D27/B27,0)","v":0}]
[]
[null,null,"Band 8a",null,">>>>>>>",{"$f":"IFERROR(D29/B29,0)","v":0}]
[]
[null,null,"Band 8b",null,">>>>>>>",{"$f":"IFERROR(D31/B31,0)","v":0}]
[]
[null,null,"Band 8c",null,">>>>>>>",{"$f":"IFERROR(D33/B33,0)","v":0}]
[]
[null,null,"Band 8d",null,">>>>>>>",{"$f":"IFERROR(D35/B35,0)","v":0}]
[]
[null,null,"Band 9",null,">>>>>>>",{"$f":"IFERROR(D37/B37,0)","v":0}]
[]
[null,{"$f":"SUM(B15:B37)","v":0},"Total",{"$f":"SUM(D15:D37)","v":0},">>>>>>>",{"$f":"IFERROR(D39/B39,0)","v":0}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                       ","X","Total number of staff  leaving the organisation",null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover ",null,null,null,null,null,null,null,null,null,null,{"$f":"H44","v":"Additional bank and agency costs of current total turnover"},{"$f":"I44","v":"Non-cash releasing costs of current total turnover "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C46","v":"Band 1"},{"$f":"H46","v":0},{"$f":"I46","v":0}]
[null,null,"Band 1",{"$f":"(IF($D$9=$G$174,G175,IF($D$9=$F$174,F175,IF($D$9=$H$174,H175)))/52)*12","v":6676.5599999999995},null,{"$f":"D15","v":0},">>>>>>>",{"$f":"IF(B46<D46,0,(((B46/12)*14)-((D46/12)*14))*F46)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F46","v":0},null,null,null,null,null,null,null,null,null,{"$f":"C48","v":"Band 2"},{"$f":"H48","v":0},{"$f":"I48","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C50","v":"Band 3"},{"$f":"H50","v":0},{"$f":"I50","v":0}]
[null,null,"Band 2",{"$f":"(IF($D$9=$G$174,G176,IF($D$9=$F$174,F176,IF($D$9=$H$174,H176)))/52)*12","v":7170.48},null,{"$f":"D17","v":0},">>>>>>>",{"$f":"IF(B48<D48,0,(((B48/12)*14)-((D48/12)*14))*F48)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F48","v":0},null,null,null,null,null,null,null,null,null,{"$f":"C52","v":"Band 4"},{"$f":"H52","v":0},{"$f":"I52","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C54","v":"Band 5"},{"$f":"H54","v":0},{"$f":"I54","v":0}]
[null,null,"Band 3",{"$f":"(IF($D$9=$G$174,G177,IF($D$9=$F$174,F177,IF($D$9=$H$174,H177)))/52)*12","v":7839.8135999999995},null,{"$f":"D19","v":0},">>>>>>>",{"$f":"IF(B50<D50,0,(((B50/12)*14)-((D50/12)*14))*F50)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F50","v":0},null,null,null,null,null,null,null,null,null,{"$f":"C56","v":"Band 6"},{"$f":"H56","v":0},{"$f":"I56","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C58","v":"Band 7"},{"$f":"H58","v":0},{"$f":"I58","v":0}]
[null,null,"Band 4",{"$f":"(IF($D$9=$G$174,G178,IF($D$9=$F$174,F178,IF($D$9=$H$174,H178)))/52)*12","v":8957.4156000000003},null,{"$f":"D21","v":0},">>>>>>>",{"$f":"IF(B52<D52,0,(((B52/12)*14)-((D52/12)*14))*F52)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F52","v":0},null,null,null,null,null,null,null,null,null,{"$f":"C60","v":"Band 8a"},{"$f":"H60","v":0},{"$f":"I60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C62","v":"Band 8b"},{"$f":"H62","v":0},{"$f":"I62","v":0}]
[null,null,"Band 5",{"$f":"(IF($D$9=$G$174,G179,IF($D$9=$F$174,F179,IF($D$9=$H$174,H179)))/52)*12","v":11352.402},null,{"$f":"D23","v":0},">>>>>>>",{"$f":"IF(B54<D54,0,(((B54/12)*14)-((D54/12)*14))*F54)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F54","v":0},null,null,null,null,null,null,null,null,null,{"$f":"C64","v":"Band 8c"},{"$f":"H64","v":0},{"$f":"I64","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C66","v":"Band 8d"},{"$f":"H66","v":0},{"$f":"I66","v":0}]
[null,null,"Band 6",{"$f":"(IF($D$9=$G$174,G180,IF($D$9=$F$174,F180,IF($D$9=$H$174,H180)))/52)*12","v":14049.611999999999},null,{"$f":"D25","v":0},">>>>>>>",{"$f":"IF(B56<D56,0,(((B56/12)*14)-((D56/12)*14))*F56)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F56","v":0},null,null,null,null,null,null,null,null,null,{"$f":"C68","v":"Band 9"},{"$f":"H68","v":0},{"$f":"I68","v":0}]
[]
[null,null,"Band 7",{"$f":"(IF($D$9=$G$174,G181,IF($D$9=$F$174,F181,IF($D$9=$H$174,H181)))/52)*12","v":16502.072400000001},null,{"$f":"D27","v":0},">>>>>>>",{"$f":"IF(B58<D58,0,(((B58/12)*14)-((D58/12)*14))*F58)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F58","v":0}]
[]
[null,null,"Band 8a",{"$f":"(IF($D$9=$G$174,G182,IF($D$9=$F$174,F182,IF($D$9=$H$174,H182)))/52)*12","v":19158.854399999997},null,{"$f":"D29","v":0},">>>>>>>",{"$f":"IF(B60<D60,0,(((B60/12)*14)-((D60/12)*14))*F60)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F60","v":0}]
[]
[null,null,"Band 8b",{"$f":"(IF($D$9=$G$174,G183,IF($D$9=$F$174,F183,IF($D$9=$H$174,H183)))/52)*12","v":22990.330800000003},null,{"$f":"D31","v":0},">>>>>>>",{"$f":"IF(B62<D62,0,(((B62/12)*14)-((D62/12)*14))*F62)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F62","v":0}]
[]
[null,null,"Band 8c",{"$f":"(IF($D$9=$G$174,G184,IF($D$9=$F$174,F184,IF($D$9=$H$174,H184)))/52)*12","v":27314.611199999999},null,{"$f":"D33","v":0},">>>>>>>",{"$f":"IF(B64<D64,0,(((B64/12)*14)-((D64/12)*14))*F64)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F64","v":0}]
[]
[null,null,"Band 8d",{"$f":"(IF($D$9=$G$174,G185,IF($D$9=$F$174,F185,IF($D$9=$H$174,H185)))/52)*12","v":32539.543199999993},null,{"$f":"D35","v":0},">>>>>>>",{"$f":"IF(B66<D66,0,(((B66/12)*14)-((D66/12)*14))*F66)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F66","v":0}]
[]
[null,null,"Band 9",{"$f":"(IF($D$9=$G$174,G186,IF($D$9=$F$174,F186,IF($D$9=$H$174,H186)))/52)*12","v":38906.931600000004},null,{"$f":"D37","v":0},">>>>>>>",{"$f":"IF(B68<D68,0,(((B68/12)*14)-((D68/12)*14))*F68)","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F68","v":0}]
[]
[null,{"$f":"IFERROR((((B46*F46)+(B48*F48)+(B50*F50)+(B52*F52)+(B54*F54)+(B56*F56)+(B58*F58)+(B60*F60)+(B62*F62)+(B64*F64)+(B66*F66)+(B68*F68))/F70),0)","v":0},"Total",{"$f":"IFERROR((((D46*F46)+(D48*F48)+(D50*F50)+(D52*F52)+(D54*F54)+(D56*F56)+(D58*F58)+(D60*F60)+(D62*F62)+(D64*F64)+(D66*F66)+(D68*F68))/F70),0)","v":0},null,{"$f":"SUM(F46:F68)","v":0},">>>>>>>",{"$f":"SUM(H46:H68)","v":0},{"$f":"SUM(I46:I68)","v":0}]
[]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                       ",null,"Average budget for substantive post -2 weeks - per WTE               "]
[]
[null,{"$f":"(B70/12)*2","v":0},"-",{"$f":"(D70/12)*2","v":0}]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)"]
[]
[null,null,"+"]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,null,"+"]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",0,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"IF(C90>0,IF(H70<1,0,H70-H138),0)","v":0}]
[null,"Non-cash releasing saving",{"$f":"I70-I138","v":0}]
[null,"Total cash & non-cash releasing savings",{"$f":"C91+C92","v":0}]
[null,"Total saving after organisational investment is included",{"$f":"C93-B10","v":0}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"F39-C90","v":0},"X",{"$f":"B39","v":0},">>>>>>>",{"$f":"B100*D100","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"C15","v":"Band 1"},{"$f":"B15*$B$100","v":0},{"$f":"F109/B15","v":{"$error":"#DIV/0!"}},{"$f":"(((B46/12)*14)-((D46/12)*14))*F109","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F109","v":0}]
[]
[null,null,null,null,{"$f":"C17","v":"Band 2"},{"$f":"B17*$B$100","v":0},{"$f":"F111/B17","v":{"$error":"#DIV/0!"}},{"$f":"(((B48/12)*14)-((D48/12)*14))*F111","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F111","v":0}]
[]
[null,null,null,null,{"$f":"C19","v":"Band 3"},{"$f":"B19*$B$100","v":0},{"$f":"F113/B19","v":{"$error":"#DIV/0!"}},{"$f":"(((B50/12)*14)-((D50/12)*14))*F113","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F113","v":0}]
[]
[null,null,null,null,{"$f":"C21","v":"Band 4"},{"$f":"B21*$B$100","v":0},{"$f":"F115/B21","v":{"$error":"#DIV/0!"}},{"$f":"(((B52/12)*14)-((D52/12)*14))*F115","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F115","v":0}]
[]
[null,null,null,null,{"$f":"C23","v":"Band 5"},{"$f":"B23*$B$100","v":0},{"$f":"F117/B23","v":{"$error":"#DIV/0!"}},{"$f":"(((B54/12)*14)-((D54/12)*14))*F117","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F117","v":0}]
[]
[null,null,null,null,{"$f":"C25","v":"Band 6"},{"$f":"B25*$B$100","v":0},{"$f":"F119/B25","v":{"$error":"#DIV/0!"}},{"$f":"(((B56/12)*14)-((D56/12)*14))*F119","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F119","v":0}]
[]
[null,null,null,null,{"$f":"C27","v":"Band 7"},{"$f":"B27*$B$100","v":0},{"$f":"F121/B27","v":{"$error":"#DIV/0!"}},{"$f":"(((B58/12)*14)-((D58/12)*14))*F121","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F121","v":0}]
[]
[null,null,null,null,{"$f":"C29","v":"Band 8a"},{"$f":"B29*$B$100","v":0},{"$f":"F123/B29","v":{"$error":"#DIV/0!"}},{"$f":"(((B60/12)*14)-((D60/12)*14))*F123","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F123","v":0}]
[]
[null,null,null,null,{"$f":"C31","v":"Band 8b"},{"$f":"B31*$B$100","v":0},{"$f":"F125/B31","v":{"$error":"#DIV/0!"}},{"$f":"(((B62/12)*14)-((D62/12)*14))*F125","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F125","v":0}]
[]
[null,null,null,null,{"$f":"C33","v":"Band 8c"},{"$f":"B33*$B$100","v":0},{"$f":"F127/B33","v":{"$error":"#DIV/0!"}},{"$f":"(((B64/12)*14)-((D64/12)*14))*F127","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F127","v":0}]
[]
[null,null,null,null,{"$f":"C35","v":"Band 8d"},{"$f":"B35*$B$100","v":0},{"$f":"F129/B35","v":{"$error":"#DIV/0!"}},{"$f":"(((B66/12)*14)-((D66/12)*14))*F129","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F129","v":0}]
[]
[null,null,null,null,{"$f":"C37","v":"Band 9"},{"$f":"B37*$B$100","v":0},{"$f":"F131/B37","v":{"$error":"#DIV/0!"}},{"$f":"(((B68/12)*14)-((D68/12)*14))*F131","v":0},{"$f":"(B$79+D$79+B$83+D$83)*F131","v":0}]
[]
[null,null,null,null,null,{"$f":"B39*$B$100","v":0},{"$f":"F133/B39","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H109:H131)","v":0},{"$f":"SUM(I109:I131)","v":0}]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B70","v":0},"+",{"$f":"D70","v":0},"X",{"$f":"F100","v":0},">>>>>>>",{"$f":"H133","v":0},{"$f":"I133","v":0}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B74","v":0},null,{"$f":"D74","v":0}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B79","v":0},"+",{"$f":"D79","v":0}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B83","v":0},"+",{"$f":"D83","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$6=$I$162,AfC!AA2*1.2,IF($D$6=$I$163,AfC!AA2*1.15,IF($D$6=$I$164,AfC!AA2*1.05,AfC!AA2)))","v":22255.200000000001},{"$f":"IF($D$6=$I$162,AfC!AB2*1.2,IF($D$6=$J$163,AfC!AB2*1.15,IF($D$6=$I$164,AfC!AB2*1.05,AfC!AB2)))","v":22255.200000000001},{"$f":"IF($D$6=$I$162,AfC!AC2*1.2,IF($D$6=$K$163,AfC!AC2*1.15,IF($D$6=$I$164,AfC!AC2*1.05,AfC!AC2)))","v":22255.200000000001},"Basic Pay"]
[null,null,null,null,"Band 2",{"$f":"IF($D$6=$I$162,AfC!AA3*1.2,IF($D$6=$I$163,AfC!AA3*1.15,IF($D$6=$I$164,AfC!AA3*1.05,AfC!AA3)))","v":22255.200000000001},{"$f":"IF($D$6=$I$162,AfC!AB3*1.2,IF($D$6=$J$163,AfC!AB3*1.15,IF($D$6=$I$164,AfC!AB3*1.05,AfC!AB3)))","v":23901.599999999999},{"$f":"IF($D$6=$I$162,AfC!AC3*1.2,IF($D$6=$K$163,AfC!AC3*1.15,IF($D$6=$I$164,AfC!AC3*1.05,AfC!AC3)))","v":23901.599999999999},"London (inner)"]
[null,null,null,null,"Band 3",{"$f":"IF($D$6=$I$162,AfC!AA4*1.2,IF($D$6=$I$163,AfC!AA4*1.15,IF($D$6=$I$164,AfC!AA4*1.05,AfC!AA4)))","v":24396},{"$f":"IF($D$6=$I$162,AfC!AB4*1.2,IF($D$6=$J$163,AfC!AB4*1.15,IF($D$6=$I$164,AfC!AB4*1.05,AfC!AB4)))","v":26132.711999999996},{"$f":"IF($D$6=$I$162,AfC!AC4*1.2,IF($D$6=$K$163,AfC!AC4*1.15,IF($D$6=$I$164,AfC!AC4*1.05,AfC!AC4)))","v":26132.711999999996},"London (outer)"]
[null,null,null,null,"Band 4",{"$f":"IF($D$6=$I$162,AfC!AA5*1.2,IF($D$6=$I$163,AfC!AA5*1.15,IF($D$6=$I$164,AfC!AA5*1.05,AfC!AA5)))","v":27058.511999999999},{"$f":"IF($D$6=$I$162,AfC!AB5*1.2,IF($D$6=$J$163,AfC!AB5*1.15,IF($D$6=$I$164,AfC!AB5*1.05,AfC!AB5)))","v":29858.051999999996},{"$f":"IF($D$6=$I$162,AfC!AC5*1.2,IF($D$6=$K$163,AfC!AC5*1.15,IF($D$6=$I$164,AfC!AC5*1.05,AfC!AC5)))","v":29858.051999999996},"London (fringe)"]
[null,null,null,null,"Band 5",{"$f":"IF($D$6=$I$162,AfC!AA6*1.2,IF($D$6=$I$163,AfC!AA6*1.15,IF($D$6=$I$164,AfC!AA6*1.05,AfC!AA6)))","v":30786.251999999997},{"$f":"IF($D$6=$I$162,AfC!AB6*1.2,IF($D$6=$J$163,AfC!AB6*1.15,IF($D$6=$I$164,AfC!AB6*1.05,AfC!AB6)))","v":35588.729999999996},{"$f":"IF($D$6=$I$162,AfC!AC6*1.2,IF($D$6=$K$163,AfC!AC6*1.15,IF($D$6=$I$164,AfC!AC6*1.05,AfC!AC6)))","v":37841.339999999997},"\"Include on costs\""]
[null,null,null,null,"Band 6",{"$f":"IF($D$6=$I$162,AfC!AA7*1.2,IF($D$6=$I$163,AfC!AA7*1.15,IF($D$6=$I$164,AfC!AA7*1.05,AfC!AA7)))","v":38767.139999999992},{"$f":"IF($D$6=$I$162,AfC!AB7*1.2,IF($D$6=$J$163,AfC!AB7*1.15,IF($D$6=$I$164,AfC!AB7*1.05,AfC!AB7)))","v":41006.735999999997},{"$f":"IF($D$6=$I$162,AfC!AC7*1.2,IF($D$6=$K$163,AfC!AC7*1.15,IF($D$6=$I$164,AfC!AC7*1.05,AfC!AC7)))","v":46832.039999999994}]
[null,null,null,null,"Band 7",{"$f":"IF($D$6=$I$162,AfC!AA8*1.2,IF($D$6=$I$163,AfC!AA8*1.15,IF($D$6=$I$164,AfC!AA8*1.05,AfC!AA8)))","v":48068.039999999994},{"$f":"IF($D$6=$I$162,AfC!AB8*1.2,IF($D$6=$J$163,AfC!AB8*1.15,IF($D$6=$I$164,AfC!AB8*1.05,AfC!AB8)))","v":50544.983999999997},{"$f":"IF($D$6=$I$162,AfC!AC8*1.2,IF($D$6=$K$163,AfC!AC8*1.15,IF($D$6=$I$164,AfC!AC8*1.05,AfC!AC8)))","v":55006.907999999996}]
[null,null,null,null,"Band 8A",{"$f":"IF($D$6=$I$162,AfC!AA9*1.2,IF($D$6=$I$163,AfC!AA9*1.15,IF($D$6=$I$164,AfC!AA9*1.05,AfC!AA9)))","v":56550.707999999991},{"$f":"IF($D$6=$I$162,AfC!AB9*1.2,IF($D$6=$J$163,AfC!AB9*1.15,IF($D$6=$I$164,AfC!AB9*1.05,AfC!AB9)))","v":56550.707999999991},{"$f":"IF($D$6=$I$162,AfC!AC9*1.2,IF($D$6=$K$163,AfC!AC9*1.15,IF($D$6=$I$164,AfC!AC9*1.05,AfC!AC9)))","v":63862.847999999991}]
[null,null,null,null,"Band 8B",{"$f":"IF($D$6=$I$162,AfC!AA10*1.2,IF($D$6=$I$163,AfC!AA10*1.15,IF($D$6=$I$164,AfC!AA10*1.05,AfC!AA10)))","v":65716.847999999984},{"$f":"IF($D$6=$I$162,AfC!AB10*1.2,IF($D$6=$J$163,AfC!AB10*1.15,IF($D$6=$I$164,AfC!AB10*1.05,AfC!AB10)))","v":65716.847999999984},{"$f":"IF($D$6=$I$162,AfC!AC10*1.2,IF($D$6=$K$163,AfC!AC10*1.15,IF($D$6=$I$164,AfC!AC10*1.05,AfC!AC10)))","v":76634.436000000002}]
[null,null,null,null,"Band 8C",{"$f":"IF($D$6=$I$162,AfC!AA11*1.2,IF($D$6=$I$163,AfC!AA11*1.15,IF($D$6=$I$164,AfC!AA11*1.05,AfC!AA11)))","v":78796.23599999999},{"$f":"IF($D$6=$I$162,AfC!AB11*1.2,IF($D$6=$J$163,AfC!AB11*1.15,IF($D$6=$I$164,AfC!AB11*1.05,AfC!AB11)))","v":78796.23599999999},{"$f":"IF($D$6=$I$162,AfC!AC11*1.2,IF($D$6=$K$163,AfC!AC11*1.15,IF($D$6=$I$164,AfC!AC11*1.05,AfC!AC11)))","v":91048.703999999998}]
[null,null,null,null,"Band 8D",{"$f":"IF($D$6=$I$162,AfC!AA12*1.2,IF($D$6=$I$163,AfC!AA12*1.15,IF($D$6=$I$164,AfC!AA12*1.05,AfC!AA12)))","v":93830.903999999995},{"$f":"IF($D$6=$I$162,AfC!AB12*1.2,IF($D$6=$J$163,AfC!AB12*1.15,IF($D$6=$I$164,AfC!AB12*1.05,AfC!AB12)))","v":93830.903999999995},{"$f":"IF($D$6=$I$162,AfC!AC12*1.2,IF($D$6=$K$163,AfC!AC12*1.15,IF($D$6=$I$164,AfC!AC12*1.05,AfC!AC12)))","v":108465.14399999999}]
[null,null,null,null,"Band 9",{"$f":"IF($D$6=$I$162,AfC!AA13*1.2,IF($D$6=$I$163,AfC!AA13*1.15,IF($D$6=$I$164,AfC!AA13*1.05,AfC!AA13)))","v":112482.14399999999},{"$f":"IF($D$6=$I$162,AfC!AB13*1.2,IF($D$6=$J$163,AfC!AB13*1.15,IF($D$6=$I$164,AfC!AB13*1.05,AfC!AB13)))","v":112482.14399999999},{"$f":"IF($D$6=$I$162,AfC!AC13*1.2,IF($D$6=$K$163,AfC!AC13*1.15,IF($D$6=$I$164,AfC!AC13*1.05,AfC!AC13)))","v":129689.772}]
[]
[null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point"]
[null,null,null,null,"Band 1",{"$f":"IF($D$10=$I$165,F161*1.3,F161)","v":28931.760000000002},28931.760000000002,28931.760000000002]
[null,null,null,null,"Band 2",28931.760000000002,31072.079999999998,31072.079999999998]
[null,null,null,null,"Band 3",31714.799999999999,33972.525599999994,33972.525599999994]
[null,null,null,null,"Band 4",35176.065600000002,38815.467599999996,38815.467599999996]
[null,null,null,null,"Band 5",40022.1276,46265.348999999995,49193.741999999998]
[null,null,null,null,"Band 6",50397.281999999992,53308.756799999996,60881.651999999995]
[null,null,null,null,"Band 7",62488.45199999999,65708.479200000002,71508.9804]
[null,null,null,null,"Band 8A",73515.920399999988,73515.920399999988,83021.702399999995]
[null,null,null,null,"Band 8B",85431.902399999977,85431.902399999977,99624.766800000012]
[null,null,null,null,"Band 8C",102435.10679999999,102435.10679999999,118363.3152]
[null,null,null,null,"Band 8D",121980.1752,121980.1752,141004.68719999999]
[null,null,null,null,"Band 9",146226.78719999999,146226.78719999999,168596.70360000001]

{"sheet":"Medical & Dental","index":14,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[36,1,36,3],[36,8,41,8],[56,4,62,4],[56,5,62,5],[57,6,62,6],[57,8,62,8],[15,2,15,8],[17,4,24,4],[19,5,33,5],[19,6,33,6],[19,7,33,7],[19,8,33,8],[26,4,32,4]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Medical & Dental"]
[]
[]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     (Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)"]
[null,0]
[]
[null,"Workforce data - headcounts and leavers"]
[null,"Average staff turnover rate                                           (Insert)","X","Headcount                                                                         (Insert)",">>>>>>>","Total number of staff  leaving the organisation"]
[]
[null,0,"X",0,">>>>>>>",{"$f":"B13*D13","v":0}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                        (Insert)","X",{"$f":"F11","v":"Total number of staff  leaving the organisation"},null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[]
[null,null,"-",0,null,{"$f":"F13","v":0},">>>>>>>",{"$f":"((B20-D20)+(B24-D24))*F20","v":0},{"$f":"(B29+D29+B33+D33)*F20","v":0}]
[]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                        (Insert)",null,"Average budget for substantive post -2 weeks - per WTE                      (Insert)"]
[]
[null,0,"-",0]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)","X"]
[]
[null,0,"+",0]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,0,"+",0]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",0,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"IF(C40>0,H20-H57,0)","v":0}]
[null,"Non-cash releasing saving",{"$f":"I20-I57","v":0}]
[null,"Total cash & non-cash releasing savings",{"$f":"C41+C42","v":0}]
[null,"Total saving after organisational investment is included",{"$f":"C43-B8","v":0}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"B13-C40","v":0},"X",{"$f":"D13","v":0},">>>>>>>",{"$f":"B50*D50","v":0}]
[]
[]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B20","v":0},"+",{"$f":"D20","v":0},"X",{"$f":"F50","v":0},">>>>>>>",{"$f":"((B57-D57)+(B59-D59))*F57","v":0},{"$f":"(B61+D61+B63+D63)*F57","v":0}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B24","v":0},null,{"$f":"D24","v":0}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B29","v":0},"+",{"$f":"D29","v":0}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B33","v":0},"+",{"$f":"D33","v":0}]

{"sheet":"Specific Retention Initiative","index":15,"n_rows":63,"n_cols":9,"rows_kept":63,"cut":false,"hidden":false,"merged":[[36,1,36,3],[36,8,41,8],[56,4,62,4],[56,5,62,5],[57,6,62,6],[57,8,62,8],[15,2,15,8],[17,4,24,4],[19,5,33,5],[19,6,33,6],[19,7,33,7],[19,8,33,8],[26,4,32,4]]}
[null,"Potential Cost Savings from improvement to retention due to flexible working or other initiatives"]
[]
[null,"Specific Retention Initiative"]
[]
[]
[]
[null,"Organisational investment in the retention programm (EG flexible working team cost)                                                                                     (Insert any organisation costs invested in this work programme, this will be deducted from potential savings to give actual in year saving)"]
[null,0]
[]
[null,"Workforce data - headcounts and leavers"]
[null,"Average staff turnover rate                                           (Insert)","X","Headcount                                                                         (Insert)",">>>>>>>","Total number of staff  leaving the organisation"]
[]
[null,0,"X",0,">>>>>>>",{"$f":"B13*D13","v":0}]
[]
[]
[]
[null,"Cash releasing costs"]
[null,"Bank and Agency cost -12 weeks - per WTE                                              (Insert)",null,"Average budget for substantive post -12 weeks - per WTE                                        (Insert)","X",{"$f":"F11","v":"Total number of staff  leaving the organisation"},null,"Additional bank and agency costs of current total turnover","Non-cash releasing costs of current total turnover "]
[]
[null,0,"-",0,null,{"$f":"F13","v":0},">>>>>>>",{"$f":"((B20-D20)+(B24-D24))*F20","v":0},{"$f":"(B29+D29+B33+D33)*F20","v":0}]
[]
[null,"Bank and Agency cost for handover -2 weeks - per WTE                        (Insert)",null,"Average budget for substantive post -2 weeks - per WTE                      (Insert)"]
[]
[null,0,"-",0]
[]
[null,"Non-cash releasing costs"]
[null,"Administration of the resignation   - per leaver                                      (Insert)",null,"Recruitment and selection costs - per recruit                                      (Insert)","X"]
[]
[null,0,"+",0]
[]
[null,"Induction training for the new employee   - per employee                         (Insert)",null,"Others  costs- leaver / new recruit                                                            (Insert)"]
[]
[null,0,"+",0]
[]
[]
[]
[null,"Costs saving-Prediction",null,null,null,null,null,null,{"$f":"ROUND(#REF!/1000000,2)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Target reduction in turnover",0,">>>Change/Insert the turnover reduction rate"]
[null,"Cash releasing saving",{"$f":"IF(C40>0,H20-H57,0)","v":0}]
[null,"Non-cash releasing saving",{"$f":"I20-I57","v":0}]
[null,"Total cash & non-cash releasing savings",{"$f":"C41+C42","v":0}]
[null,"Total saving after organisational investment is included",{"$f":"C43-B8","v":0}]
[]
[]
[]
[null,"Number of taff leave the organisation"]
[null,"Average staff turnovere rate for all reasons in 2020/21","X","Headcount of Organisation       ↓↓↓ (Insert)",">>>>>>>"]
[null,{"$f":"B13-C40","v":0},"X",{"$f":"D13","v":0},">>>>>>>",{"$f":"B50*D50","v":0}]
[]
[]
[]
[]
[null,"Avg cost of temporary (Nursing, Midwifery & Health Visiting) staff replacement                           "]
[null,"Bank and Agency cost -12 weeks                                       (Per staff-Insert)↓↓↓",null,"Average budget for substantive post","X","Total Number of ( Nursing, Midwifery & Health Visiting) staff  leaving the organisation",">>>>>>>","Cash releasing                   (Bank and Agency costs) ","Non-cash releasing"]
[null,{"$f":"B20","v":0},"+",{"$f":"D20","v":0},"X",{"$f":"F50","v":0},">>>>>>>",{"$f":"((B57-D57)+(B59-D59))*F57","v":0},{"$f":"(B61+D61+B63+D63)*F57","v":0}]
[null,"Bank and Agency cost for handover -2 weeks                          (Per staff-Insert)↓↓↓",null,"Average budget for substantive post"]
[null,{"$f":"B24","v":0},null,{"$f":"D24","v":0}]
[null," Administration of the resignation                                          (Per staff-Insert)↓↓↓",null,"Recruitment and selection costs                                       (Per staff-Insert)↓↓↓"]
[null,{"$f":"B29","v":0},"+",{"$f":"D29","v":0}]
[null,"Induction training for the new employee                                  (Per staff-Insert)↓↓↓",null,"Other  Costs (cost of initiative/ investment)                                                                           (Per staff-Insert)↓↓↓"]
[null,{"$f":"B33","v":0},"+",{"$f":"D33","v":0}]

{"sheet":"AfC","index":16,"n_rows":80,"n_cols":36,"rows_kept":80,"cut":false,"hidden":true,"merged":[]}
["List_value","Band","Years of Experience","2018/19","2019/20","2020/21","2021/22","Basic Pay","London (inner)","London (outer)","London (fringe)","On costs","Basic Pay","Basic Pay",null,null,"London (inner)1","London (outer)1","London (fringe)1",null,null,null,null,null,null,"Band","Bottom pay point","Middle pay point","Top pay point","On costs","Average",null,null,"Employer National Insurance 2021/22","Employer Pension contribution"]
[{"$f":"B2&\" (\"&C2&\" service\"&\")\"","v":"Band 1 (< 1 year service)"},"Band 1","< 1 year",17460,17652,18005,18546,{"$f":"G2","v":18546},{"$f":"(($G2/100)*20)+G2","v":22255.200000000001},{"$f":"(($G2/100)*15)+G2","v":21327.9},{"$f":"(($G2/100)*5)+G2","v":19473.3},{"$f":"(G2/100)*30","v":5563.8},null,{"$f":"$H2*0.2","v":3709.2000000000003},{"$f":"$H2*0.15","v":2781.9},{"$f":"$H2*0.05","v":927.30000000000007},{"$f":"IF(N2<$AC$48,($H2+$AC$48),IF(N2>$AD$48,($H2+$AD$48),(N2+$H2)))","v":23154},{"$f":"IF(O2<$AC$48,($H2+$AC$48),IF(O2>$AD$48,($H2+$AD$48),(O2+$H2)))","v":23154},{"$f":"IF(P2<$AC$48,($H2+$AC$48),IF(P2>$AD$48,($H2+$AD$48),(P2+$H2)))","v":23154},null,null,null,null,null,null,{"$f":"_xlfn.UNIQUE(B2:B80,FALSE,FALSE)","v":"Band 1"},{"$f":"MIN(G2:G3)","v":18546},{"$f":"MEDIAN(G2:G3)","v":18546},{"$f":"MAX(G2:G3)","v":18546},{"$f":"MEDIAN(L2:L3)","v":5563.8},{"$f":"AVERAGE(G2:G3)","v":18546},null,"Basic Pay","Greater than 9,500","Providers pay 14.38%"]
[{"$f":"B3&\" (\"&C3&\" service\"&\")\"","v":"Band 1 (1+ years service)"},"Band 1","1+ years",17460,17652,18005,18546,{"$f":"G3","v":18546},{"$f":"(($G3/100)*20)+G3","v":22255.200000000001},{"$f":"(($G3/100)*15)+G3","v":21327.9},{"$f":"(($G3/100)*5)+G3","v":19473.3},5563.8,null,{"$f":"$H3*0.2","v":3709.2000000000003},{"$f":"$H3*0.15","v":2781.9},{"$f":"$H3*0.05","v":927.30000000000007},{"$f":"IF(N3<$AC$48,($H3+$AC$48),IF(N3>$AD$48,($H3+$AD$48),(N3+$H3)))","v":23154},{"$f":"IF(O3<$AC$48,($H3+$AC$48),IF(O3>$AD$48,($H3+$AD$48),(O3+$H3)))","v":23154},{"$f":"IF(P3<$AC$48,($H3+$AC$48),IF(P3>$AD$48,($H3+$AD$48),(P3+$H3)))","v":23154},null,null,null,null,null,null,"Band 2",{"$f":"MIN(G4:G10)","v":18546},{"$f":"MEDIAN(G4:G10)","v":19918},{"$f":"MAX(G4:G10)","v":19918},{"$f":"MEDIAN(L4:L10)","v":5975.4000000000005},{"$f":"AVERAGE(G4:G10)","v":19526},null,"London (inner)","13.8% (total pay)","Increased extra 6% to BSA. Total 20.68%"]
["Band 2 (< 1 year service)","Band 2","< 1 year",17460,17652,18005,18546,18546,22255.200000000001,21327.9,19473.3,5563.8,null,3709.2000000000003,2781.9,927.30000000000007,23154,23154,23154,null,null,null,null,null,null,"Band 3",{"$f":"MIN(G11:G17)","v":20330},{"$f":"MEDIAN(G11:G17)","v":21777.26},{"$f":"MAX(G11:G17)","v":21777.26},{"$f":"MEDIAN(L11:L17)","v":6533.1779999999999},{"$f":"AVERAGE(G11:G17)","v":21363.757142857143},null,"London (outer)","Just base this on basic pay?","Apprentice levy 0.5%"]
["Band 2 (1-2 years service)","Band 2","1-2 years",17460,17652,18005,18546,18546,22255.200000000001,21327.9,19473.3,5563.8,null,3709.2000000000003,2781.9,927.30000000000007,23154,23154,23154,null,null,null,null,null,null,"Band 4",{"$f":"MIN(G18:G24)","v":22548.76},{"$f":"MEDIAN(G18:G24)","v":24881.71},{"$f":"MAX(G18:G24)","v":24881.71},{"$f":"MEDIAN(L18:L24)","v":7464.512999999999},{"$f":"AVERAGE(G18:G24)","v":23881.874285714282},null,"London (fringe)","Not OT or additional earnings.",null,"Entry point or top point?"]
["Band 2 (2-3 years service)","Band 2","2-3 years",17460,17652,19337,19918,19918,23901.599999999999,22905.7,20913.900000000001,5975.4000000000005,null,3983.6000000000004,2987.7,995.90000000000009,24526,24526,24526,null,null,null,null,null,null,"Band 5",{"$f":"MIN(G25:G32)","v":25655.21},{"$f":"MEDIAN(G25:G32)","v":29657.274999999998},{"$f":"MAX(G25:G32)","v":31534.449999999997},{"$f":"MEDIAN(L25:L32)","v":8897.182499999999},{"$f":"AVERAGE(G25:G32)","v":29126.052500000005},null,null,null,null,"Incremental drift?"]
["Band 2 (3-4 years service)","Band 2","3-4 years",17460,17652,19337,19918,19918,23901.599999999999,22905.7,20913.900000000001,5975.4000000000005,null,3983.6000000000004,2987.7,995.90000000000009,24526,24526,24526,null,null,null,null,null,null,"Band 6",{"$f":"MIN(G33:G41)","v":32305.949999999997},{"$f":"MEDIAN(G33:G41)","v":34172.28},{"$f":"MAX(G33:G41)","v":39026.699999999997},{"$f":"MEDIAN(L33:L41)","v":10251.684000000001},{"$f":"AVERAGE(G33:G41)","v":35915.060000000005}]
["Band 2 (4-5 years service)","Band 2","4-5 years",17460,17652,19337,19918,19918,23901.599999999999,22905.7,20913.900000000001,5975.4000000000005,null,3983.6000000000004,2987.7,995.90000000000009,24526,24526,24526,null,null,null,null,null,null,"Band 7",{"$f":"MIN(G42:G50)","v":40056.699999999997},{"$f":"MEDIAN(G42:G50)","v":42120.82},{"$f":"MAX(G42:G50)","v":45839.09},{"$f":"MEDIAN(L42:L50)","v":12636.245999999999},{"$f":"AVERAGE(G42:G50)","v":43314.691111111111}]
["Band 2 (5-6 years service)","Band 2","5-6 years",17787,17983,19337,19918,19918,23901.599999999999,22905.7,20913.900000000001,5975.4000000000005,null,3983.6000000000004,2987.7,995.90000000000009,24526,24526,24526,null,null,null,null,null,null,"Band 8A",{"$f":"MIN(G51:G56)","v":47125.59},{"$f":"MEDIAN(G51:G56)","v":47125.59},{"$f":"MAX(G51:G56)","v":53219.039999999994},{"$f":"MEDIAN(L51:L56)","v":14137.676999999998},{"$f":"AVERAGE(G51:G56)","v":48141.165000000001}]
["Band 2 (6+ years service)","Band 2","6+ years",18702,19020,19337,19918,19918,23901.599999999999,22905.7,20913.900000000001,5975.4000000000005,null,3983.6000000000004,2987.7,995.90000000000009,24526,24526,24526,null,null,null,null,null,null,"Band 8B",{"$f":"MIN(G57:G62)","v":54764.039999999994},{"$f":"MEDIAN(G57:G62)","v":54764.039999999994},{"$f":"MAX(G57:G62)","v":63862.03},{"$f":"MEDIAN(L57:L62)","v":16429.211999999996},{"$f":"AVERAGE(G57:G62)","v":56280.371666666666}]
["Band 3 (< 1 year service)","Band 3","< 1 year",17787,18813,19737,20330,20330,24396,23379.5,21346.5,6099,null,4066,3049.5,1016.5,24938,24938,24938,null,null,null,null,null,null,"Band 8C",{"$f":"MIN(G63:G68)","v":65663.53},{"$f":"MEDIAN(G63:G68)","v":65663.53},{"$f":"MAX(G63:G68)","v":75873.919999999998},{"$f":"MEDIAN(L63:L68)","v":19699.059000000001},{"$f":"AVERAGE(G63:G68)","v":67365.261666666673}]
["Band 3 (1-2 years service)","Band 3","1-2 years",17787,18813,19737,20330,20330,24396,23379.5,21346.5,6099,null,4066,3049.5,1016.5,24938,24938,24938,null,null,null,null,null,null,"Band 8D",{"$f":"MIN(G69:G74)","v":78192.42},{"$f":"MEDIAN(G69:G74)","v":78192.42},{"$f":"MAX(G69:G74)","v":90387.62},{"$f":"MEDIAN(L69:L74)","v":23457.725999999999},{"$f":"AVERAGE(G69:G74)","v":80224.953333333324}]
["Band 3 (2-3 years service)","Band 3","2-3 years",18429,18813,21142,21777.26,21777.26,26132.712,25043.848999999998,22866.123,6533.1779999999999,null,4355.4520000000002,3266.5889999999995,1088.8630000000001,26385.26,26385.26,26385.26,null,null,null,null,null,null,"Band 9",{"$f":"MIN(G75:G80)","v":93735.12},{"$f":"MEDIAN(G75:G80)","v":93735.12},{"$f":"MAX(G75:G80)","v":108074.81},{"$f":"MEDIAN(L75:L80)","v":28120.536},{"$f":"AVERAGE(G75:G80)","v":96125.068333333315}]
["Band 3 (3-4 years service)","Band 3","3-4 years",18608,18813,21142,21777.26,21777.26,26132.712,25043.848999999998,22866.123,6533.1779999999999,null,4355.4520000000002,3266.5889999999995,1088.8630000000001,26385.26,26385.26,26385.26]
["Band 3 (4-5 years service)","Band 3","4-5 years",19122,19332,21142,21777.26,21777.26,26132.712,25043.848999999998,22866.123,6533.1779999999999,null,4355.4520000000002,3266.5889999999995,1088.8630000000001,26385.26,26385.26,26385.26]
["Band 3 (5-6 years service)","Band 3","5-6 years",19700,19917,21142,21777.26,21777.26,26132.712,25043.848999999998,22866.123,6533.1779999999999,null,4355.4520000000002,3266.5889999999995,1088.8630000000001,26385.26,26385.26,26385.26]
["Band 3 (6+ years service)","Band 3","6+ years",20448,20795,21142,21777.26,21777.26,26132.712,25043.848999999998,22866.123,6533.1779999999999,null,4355.4520000000002,3266.5889999999995,1088.8630000000001,26385.26,26385.26,26385.26]
["Band 4 (< 1 year service)","Band 4","< 1 year",20150,21089,21892,22548.76,22548.76,27058.511999999999,25931.073999999997,23676.197999999997,6764.6279999999997,null,4509.7519999999995,3382.3139999999999,1127.4379999999999,27156.76,27156.76,27156.76]
["Band 4 (1-2 years service)","Band 4","1-2 years",20150,21089,21892,22548.76,22548.76,27058.511999999999,25931.073999999997,23676.197999999997,6764.6279999999997,null,4509.7519999999995,3382.3139999999999,1127.4379999999999,27156.76,27156.76,27156.76]
["Band 4 (2-3 years service)","Band 4","2-3 years",20859,21089,21892,22548.76,22548.76,27058.511999999999,25931.073999999997,23676.197999999997,6764.6279999999997,null,4509.7519999999995,3382.3139999999999,1127.4379999999999,27156.76,27156.76,27156.76]
["Band 4 (3-4 years service)","Band 4","3-4 years",21582,21819,24157,24881.71,24881.71,29858.052,28613.966499999999,26125.7955,7464.512999999999,null,4976.3420000000006,3732.2564999999995,1244.0855000000001,29858.052,29489.71,29489.71,null,null,null,null,null,null,"Agenda for change - pay rates | Health Careers"]
["Band 4 (4-5 years service)","Band 4","4-5 years",22238,22482,24157,24881.71,24881.71,29858.052,28613.966499999999,26125.7955,7464.512999999999,null,4976.3420000000006,3732.2564999999995,1244.0855000000001,29858.052,29489.71,29489.71]
["Band 4 (5-6 years service)","Band 4","5-6 years",22460,22707,24157,24881.71,24881.71,29858.052,28613.966499999999,26125.7955,7464.512999999999,null,4976.3420000000006,3732.2564999999995,1244.0855000000001,29858.052,29489.71,29489.71]
["Band 4 (6+ years service)","Band 4","6+ years",23363,23761,24157,24881.71,24881.71,29858.052,28613.966499999999,26125.7955,7464.512999999999,null,4976.3420000000006,3732.2564999999995,1244.0855000000001,29858.052,29489.71,29489.71]
["Band 5 (< 1 year service)","Band 5","< 1 year",23023,24214,24907,25655.21,25655.21,30786.252,29503.4915,26937.970499999999,7696.5630000000001,null,5131.0420000000004,3848.2814999999996,1282.7605000000001,30786.252,30263.21,30263.21]
["Band 5 (1-2 years service)","Band 5","1-2 years",23023,24214,24907,25655.21,25655.21,30786.252,29503.4915,26937.970499999999,7696.5630000000001,null,5131.0420000000004,3848.2814999999996,1282.7605000000001,30786.252,30263.21,30263.21]
["Band 5 (2-3 years service)","Band 5","2-3 years",23951,24214,26970,27780.1,27780.1,33336.119999999995,31947.114999999998,29169.105,8334.0299999999988,null,5556.02,4167.0149999999994,1389.0050000000001,33336.119999999995,32388.1,32388.1]
["Band 5 (3-4 years service)","Band 5","3-4 years",24915,26220,26970,27780.1,27780.1,33336.119999999995,31947.114999999998,29169.105,8334.0299999999988,null,5556.02,4167.0149999999994,1389.0050000000001,33336.119999999995,32388.1,32388.1]
["Band 5 (4-5 years service)","Band 5","4-5 years",25934,26220,27416,31534.449999999997,31534.449999999997,37841.339999999997,36264.617499999993,33111.172500000001,9460.3349999999991,null,6306.8899999999994,4730.1674999999996,1576.7224999999999,37841.339999999997,36264.617499999993,36142.449999999997]
["Band 5 (5-6 years service)","Band 5","5-6 years",26963,27260,27416,31534.449999999997,31534.449999999997,37841.339999999997,36264.617499999993,33111.172500000001,9460.3349999999991,null,6306.8899999999994,4730.1674999999996,1576.7224999999999,37841.339999999997,36264.617499999993,36142.449999999997]
["Band 5 (6-7 years service)","Band 5","6-7 years",28050,28358,30615,31534.449999999997,31534.449999999997,37841.339999999997,36264.617499999993,33111.172500000001,9460.3349999999991,null,6306.8899999999994,4730.1674999999996,1576.7224999999999,37841.339999999997,36264.617499999993,36142.449999999997]
["Band 5 (7+ years service)","Band 5","7+ years",29608,30112,30615,31534.449999999997,31534.449999999997,37841.339999999997,36264.617499999993,33111.172500000001,9460.3349999999991,null,6306.8899999999994,4730.1674999999996,1576.7224999999999,37841.339999999997,36264.617499999993,36142.449999999997]
["Band 6 (< 1 year service)","Band 6","< 1 year",28050,30401,31365,32305.949999999997,32305.949999999997,38767.14,37151.842499999999,33921.247499999998,9691.784999999998,null,6461.19,4845.892499999999,1615.2974999999999,38767.14,37151.842499999999,36913.949999999997]
["Band 6 (1-2 years service)","Band 6","1-2 years",28050,30401,31365,32305.949999999997,32305.949999999997,38767.14,37151.842499999999,33921.247499999998,{"$f":"(G34/100)*30","v":9691.784999999998},null,6461.19,4845.892499999999,1615.2974999999999,38767.14,37151.842499999999,36913.949999999997]
["Band 6 (2-3 years service)","Band 6","2-3 years",29177,30401,33176,34172.28,34172.28,41006.735999999997,39298.122000000003,35880.894,10251.684000000001,null,6834.4560000000001,5125.8419999999996,1708.614,41006.735999999997,39298.121999999996,38780.28]
["Band 6 (3-4 years service)","Band 6","3-4 years",30070,32525,33176,34172.28,34172.28,41006.735999999997,39298.122000000003,35880.894,10251.684000000001,null,6834.4560000000001,5125.8419999999996,1708.614,41006.735999999997,39298.121999999996,38780.28]
["Band 6 (4-5 years service)","Band 6","4-5 years",31121,32525,33176,34172.28,34172.28,41006.735999999997,39298.122000000003,35880.894,10251.684000000001,null,6834.4560000000001,5125.8419999999996,1708.614,41006.735999999997,39298.121999999996,38780.28]
["Band 6 (5-6 years service)","Band 6","5-6 years",32171,32525,33779,39026.699999999997,39026.699999999997,46832.039999999994,44880.704999999994,40978.034999999996,11708.01,null,7805.34,5854.0049999999992,1951.335,46123.7,44880.704999999994,43634.7]
["Band 6 (6-7 years service)","Band 6","6-7 years",33222,33587,33779,39026.699999999997,39026.699999999997,46832.039999999994,44880.704999999994,40978.034999999996,11708.01,null,7805.34,5854.0049999999992,1951.335,46123.7,44880.704999999994,43634.7]
["Band 6 (7-8 years service)","Band 6","7-8 years",34403,34782,37890,39026.699999999997,39026.699999999997,46832.039999999994,44880.704999999994,40978.034999999996,11708.01,null,7805.34,5854.0049999999992,1951.335,46123.7,44880.704999999994,43634.7]
["Band 6 (8+ years service)","Band 6","8+ years",36644,37267,37890,39026.699999999997,39026.699999999997,46832.039999999994,44880.704999999994,40978.034999999996,11708.01,null,7805.34,5854.0049999999992,1951.335,46123.7,44880.704999999994,43634.7]
["Band 7 (< 1 year service)","Band 7","< 1 year",33222,37570,38890,40056.699999999997,40056.699999999997,48068.039999999994,46065.204999999994,42059.534999999996,12017.009999999998,null,8011.34,6008.5049999999992,2002.835,47153.7,46065.204999999994,44664.7]
["Band 7 (1-2 years service)","Band 7","1-2 years",33222,37570,38890,40056.699999999997,40056.699999999997,48068.039999999994,46065.204999999994,42059.534999999996,12017.009999999998,null,8011.34,6008.5049999999992,2002.835,47153.7,46065.204999999994,44664.7]
["Band 7 (2-3 years service)","Band 7","2-3 years",34403,37570,40894,42120.82,42120.82,50544.983999999997,48438.942999999999,44226.860999999997,12636.245999999999,null,8424.1640000000007,6318.1229999999996,2106.0410000000002,49217.82,48438.942999999999,46728.82]
["Band 7 (3-4 years service)","Band 7","3-4 years",36111,37570,40894,42120.82,42120.82,50544.983999999997,48438.942999999999,44226.860999999997,12636.245999999999,null,8424.1640000000007,6318.1229999999996,2106.0410000000002,49217.82,48438.942999999999,46728.82]
["Band 7 (4-5 years service)","Band 7","4-5 years",37161,38765,40894,42120.82,42120.82,50544.983999999997,48438.942999999999,44226.860999999997,12636.245999999999,null,8424.1640000000007,6318.1229999999996,2106.0410000000002,49217.82,48438.942999999999,46728.82]
["Band 7 (5-6 years service)","Band 7","5-6 years",38344,38765,41723,45839.09,45839.09,55006.907999999996,52714.953499999996,48131.044499999996,13751.726999999999,null,9167.8179999999993,6875.8634999999995,2291.9544999999998,52936.09,52714.953499999996,50447.09]
["Band 7 (6-7 years service)","Band 7","6-7 years",39656,40092,41723,45839.09,45839.09,55006.907999999996,52714.953499999996,48131.044499999996,13751.726999999999,null,9167.8179999999993,6875.8634999999995,2291.9544999999998,52936.09,52714.953499999996,50447.09,null,null,null,null,null,null,null,null,null,4608,7097]
["Band 7 (7-8 years service)","Band 7","7-8 years",41034,41486,44503,45839.09,45839.09,55006.907999999996,52714.953499999996,48131.044499999996,13751.726999999999,null,9167.8179999999993,6875.8634999999995,2291.9544999999998,52936.09,52714.953499999996,50447.09]
["Band 7 (8+ years service)","Band 7","8+ years",43041,43772,44503,45839.09,45839.09,55006.907999999996,52714.953499999996,48131.044499999996,13751.726999999999,null,9167.8179999999993,6875.8634999999995,2291.9544999999998,52936.09,52714.953499999996,50447.09]
["Band 8A (< 1 year service)","Band 8A","< 1 year",42414,44606,45753,47125.59,47125.59,56550.707999999999,54194.428499999995,49481.869499999993,14137.676999999998,null,9425.1180000000004,7068.8384999999989,2356.2795000000001,54222.59,54194.428499999995,51733.59]
["Band 8A (1-2 years service)","Band 8A","1-2 years",42414,44606,45753,47125.59,47125.59,56550.707999999999,54194.428499999995,49481.869499999993,14137.676999999998,null,9425.1180000000004,7068.8384999999989,2356.2795000000001,54222.59,54194.428499999995,51733.59]
["Band 8A (2-3 years service)","Band 8A","2-3 years",44121,44606,45753,47125.59,47125.59,56550.707999999999,54194.428499999995,49481.869499999993,14137.676999999998,null,9425.1180000000004,7068.8384999999989,2356.2795000000001,54222.59,54194.428499999995,51733.59]
["Band 8A (3-4 years service)","Band 8A","3-4 years",45827,46331,45753,47125.59,47125.59,56550.707999999999,54194.428499999995,49481.869499999993,14137.676999999998,null,9425.1180000000004,7068.8384999999989,2356.2795000000001,54222.59,54194.428499999995,51733.59]
["Band 8A (4-5 years service)","Band 8A","4-5 years",47798,48324,45753,47125.59,47125.59,56550.707999999999,54194.428499999995,49481.869499999993,14137.676999999998,null,9425.1180000000004,7068.8384999999989,2356.2795000000001,54222.59,54194.428499999995,51733.59]
["Band 8A (5+ years service)","Band 8A","5+ years",49969,50819,51668,53219.039999999994,53219.039999999994,63862.847999999991,61201.895999999993,55879.991999999991,15965.712,null,10643.807999999999,7982.8559999999989,2660.9519999999998,60316.039999999994,60316.039999999994,57827.039999999994]
["Band 8B (< 1 year service)","Band 8B","< 1 year",49242,52306,53168,54764.039999999994,54764.039999999994,65716.847999999998,62978.645999999993,57502.241999999991,16429.211999999996,null,10952.807999999999,8214.6059999999979,2738.2019999999998,61861.039999999994,61861.039999999994,59372.039999999994]
["Band 8B (1-2 years service)","Band 8B","1-2 years",49242,52306,53168,54764.039999999994,54764.039999999994,65716.847999999998,62978.645999999993,57502.241999999991,16429.211999999996,null,10952.807999999999,8214.6059999999979,2738.2019999999998,61861.039999999994,61861.039999999994,59372.039999999994]
["Band 8B (2-3 years service)","Band 8B","2-3 years",51737,52306,53168,54764.039999999994,54764.039999999994,65716.847999999998,62978.645999999993,57502.241999999991,16429.211999999996,null,10952.807999999999,8214.6059999999979,2738.2019999999998,61861.039999999994,61861.039999999994,59372.039999999994]
["Band 8B (3-4 years service)","Band 8B","3-4 years",54625,55226,53168,54764.039999999994,54764.039999999994,65716.847999999998,62978.645999999993,57502.241999999991,16429.211999999996,null,10952.807999999999,8214.6059999999979,2738.2019999999998,61861.039999999994,61861.039999999994,59372.039999999994]
["Band 8B (4-5 years service)","Band 8B","4-5 years",57515,58148,53168,54764.039999999994,54764.039999999994,65716.847999999998,62978.645999999993,57502.241999999991,16429.211999999996,null,10952.807999999999,8214.6059999999979,2738.2019999999998,61861.039999999994,61861.039999999994,59372.039999999994]
["Band 8B (5+ years service)","Band 8B","5+ years",59964,60983,62001,63862.03,63862.03,76634.436000000002,73441.334499999997,67055.131500000003,19158.609,null,12772.406000000001,9579.3045000000002,3193.1015000000002,70959.03,70959.03,68470.03]
["Band 8C (< 1 year service)","Band 8C","< 1 year",59090,61777,63751,65663.53,65663.53,78796.236000000004,75513.059500000003,68946.7065,19699.059000000001,null,13132.706,9849.5294999999987,3283.1765,72760.53,72760.53,70271.53]
["Band 8C (1-2 years service)","Band 8C","1-2 years",59090,61777,63751,65663.53,65663.53,78796.236000000004,75513.059500000003,68946.7065,19699.059000000001,null,13132.706,9849.5294999999987,3283.1765,72760.53,72760.53,70271.53]
["Band 8C (2-3 years service)","Band 8C","2-3 years",61105,61777,63751,65663.53,65663.53,78796.236000000004,75513.059500000003,68946.7065,19699.059000000001,null,13132.706,9849.5294999999987,3283.1765,72760.53,72760.53,70271.53]
["Band 8C (3-4 years service)","Band 8C","3-4 years",63966,64670,63751,65663.53,65663.53,78796.236000000004,75513.059500000003,68946.7065,{"$f":"(G66/100)*30","v":19699.059000000001},null,13132.706,9849.5294999999987,3283.1765,72760.53,72760.53,70271.53]
[{"$f":"B67&\" (\"&C67&\" service\"&\")\"","v":"Band 8C (4-5 years service)"},"Band 8C","4-5 years",68256,69007,63751,65663.53,{"$f":"G67","v":65663.53},{"$f":"(($G67/100)*20)+G67","v":78796.236000000004},{"$f":"(($G67/100)*15)+G67","v":75513.059500000003},{"$f":"(($G67/100)*5)+G67","v":68946.7065},19699.059000000001,null,{"$f":"$H67*0.2","v":13132.706},{"$f":"$H67*0.15","v":9849.5294999999987},{"$f":"$H67*0.05","v":3283.1765},{"$f":"IF(N67<$AC$48,($H67+$AC$48),IF(N67>$AD$48,($H67+$AD$48),(N67+$H67)))","v":72760.53},{"$f":"IF(O67<$AC$48,($H67+$AC$48),IF(O67>$AD$48,($H67+$AD$48),(O67+$H67)))","v":72760.53},{"$f":"IF(P67<$AC$48,($H67+$AC$48),IF(P67>$AD$48,($H67+$AD$48),(P67+$H67)))","v":70271.53}]
["Band 8C (5+ years service)","Band 8C","5+ years",71243,72597,73664,75873.919999999998,75873.919999999998,91048.703999999998,87255.008000000002,79667.615999999995,22762.175999999999,null,15174.784,11381.088,3793.6959999999999,82970.92,82970.92,80481.919999999998]
["Band 8D (< 1 year service)","Band 8D","< 1 year",70206,73936,75914,78192.42,78192.42,93830.903999999995,89921.282999999996,82102.040999999997,23457.725999999999,null,15638.484,11728.862999999999,3909.6210000000001,85289.42,85289.42,82800.42]
["Band 8D (1-2 years service)","Band 8D","1-2 years",70206,73936,75914,78192.42,78192.42,93830.903999999995,89921.282999999996,82102.040999999997,23457.725999999999,null,15638.484,11728.862999999999,3909.6210000000001,85289.42,85289.42,82800.42]
["Band 8D (2-3 years service)","Band 8D","2-3 years",73132,73936,75914,78192.42,78192.42,93830.903999999995,89921.282999999996,82102.040999999997,23457.725999999999,null,15638.484,11728.862999999999,3909.6210000000001,85289.42,85289.42,82800.42]
["Band 8D (3-4 years service)","Band 8D","3-4 years",76707,77550,75914,78192.42,78192.42,93830.903999999995,89921.282999999996,82102.040999999997,23457.725999999999,null,15638.484,11728.862999999999,3909.6210000000001,85289.42,85289.42,82800.42]
["Band 8D (4-5 years service)","Band 8D","4-5 years",80606,81493,75914,78192.42,78192.42,93830.903999999995,89921.282999999996,82102.040999999997,23457.725999999999,null,15638.484,11728.862999999999,3909.6210000000001,85289.42,85289.42,82800.42]
["Band 8D (5+ years service)","Band 8D","5+ years",85333,86687,87754,90387.62,90387.62,108465.144,103945.76299999999,94907.000999999989,27116.285999999996,null,18077.524000000001,13558.142999999998,4519.3810000000003,97484.62,97484.62,94995.62]
["Band 9 (< 1 year service)","Band 9","< 1 year",84507,89537,91004,93735.12,93735.12,112482.144,107795.38799999999,98421.875999999989,28120.536,null,18747.024000000001,14060.267999999998,4686.7560000000003,100832.12,100832.12,98421.875999999989]
["Band 9 (1-2 years service)","Band 9","1-2 years",84507,89537,91004,93735.12,93735.12,112482.144,107795.38799999999,98421.875999999989,28120.536,null,18747.024000000001,14060.267999999998,4686.7560000000003,100832.12,100832.12,98421.875999999989]
["Band 9 (2-3 years service)","Band 9","2-3 years",88563,89537,91004,93735.12,93735.12,112482.144,107795.38799999999,98421.875999999989,28120.536,null,18747.024000000001,14060.267999999998,4686.7560000000003,100832.12,100832.12,98421.875999999989]
["Band 9 (3-4 years service)","Band 9","3-4 years",92814,93835,91004,93735.12,93735.12,112482.144,107795.38799999999,98421.875999999989,28120.536,null,18747.024000000001,14060.267999999998,4686.7560000000003,100832.12,100832.12,98421.875999999989]
["Band 9 (4-5 years service)","Band 9","4-5 years",97269,98339,91004,93735.12,93735.12,112482.144,107795.38799999999,98421.875999999989,28120.536,null,18747.024000000001,14060.267999999998,4686.7560000000003,100832.12,100832.12,98421.875999999989]
["Band 9 (5+ years service)","Band 9","5+ years",102506,103860,104927,108074.81,108074.81,129689.772,124286.0315,113478.5505,32422.442999999999,null,21614.962,16211.2215,5403.7404999999999,115171.81,115171.81,113478.5505]