Spreadsheet: 740443d1626343385-increasing-the-reference-row-in-a-series-of-random-formulas-by-one-demo
Sheet: All Measures 2020-21

 | Ref | Objective | Frequency | Measure | Data Provider | Owner | Is Quarter | P&C | Category | Target 2020-21
 | 0002a | Down | Quarterly | Total number of primary fires | [NAME] | [NAME] | Q1-4 | Prevention | SDMT | 970
 | 13 | Down | Quarterly | Number of (primary) fire fatalities | [NAME] | [NAME] | Q1-4 | Prevention | SDMT | 4
 | 0014a | Down | Quarterly | Number of (primary) fire injuries where victim went to hospital | [NAME] | [NAME] | Q1-4 | Prevention | SDMT | 26
 | 0003a | Down | Quarterly | No. of Deliberate (Arson) Fires | [NAME] | [NAME] | Q1-4 | Prevention | SDMT | 715
 | 0002ai-i | Down | Quarterly | Total number of primary fires - dwellings - accidental | [NAME] | [NAME] | Q1-4 | Prevention | SDMT | 347
 | 0002ai-ii | Down | Quarterly | Total number of primary fires - dwellings - deliberate | [NAME] | [NAME] | Q1-4 | Prevention | SDMT | 30
 | 0002aiii-ii | Down | Quarterly | Total number of primary fires - other buildings - deliberate | [NAME] | [NAME] | Q1-4 | Prevention | SDMT | 47
 | 15 | Up | Quarterly | Number of delivered Safe and Well visits | [NAME] | [NAME] | Q1-4 | Prevention | SDMT | 10000
 | 0002b | Down | Quarterly | Total number of secondary fires | [NAME] | [NAME] | Q1-4 | Prevention | SDMT | 970
 | Pi15 | Up | Quarterly | % of Building Regulations consultations completed on time | [NAME] | [NAME] | Q1-4 | Protection | SDMT | 0.95
 | Pi16 | Up | Quarterly | Total Fire Safety Audits/inspections completed | [NAME] | [NAME] | Q1-4 | Protection | SDMT | 1800
 | 39 | Down | Quarterly | Total number of primary fires in non-domestic buildings | [NAME] | [NAME] | Q1-4 | Protection | SDMT | 133
 | 0011a | Down | Quarterly | The number of automatic fire detector false alarms in non-domestic properties | [NAME] | [NAME] | Q1-4 | Protection | SDMT | 550
 | 28 | Down | Quarterly | Total Emergency Calls received | [NAME] | [NAME] | Q1-4 | Responding | SDMT | Monitor Only
 | 1 | Down | Quarterly | Total Incidents | [NAME] | [NAME] | Q1-4 | Responding | SDMT | Monitor Only
 | 0001a | Down | Quarterly | Total Fires | [NAME] | [NAME] | Q1-4 | Responding | SDMT | Monitor Only
 | 0001bi | Down | Quarterly | Total Special Services | [NAME] | [NAME] | Q1-4 | Responding | SDMT | Monitor Only
 | 0001c | Down | Quarterly | Total False Alarms attended | [NAME] | [NAME] | Q1-4 | Responding | SDMT | Monitor Only
 | 0028a | Up | Quarterly | % of emergency calls answered within 7 seconds | [NAME] | [NAME] | Q1-4 | Responding | SDMT | n/a
 | 29 | Down | Quarterly | Average Call Handling Time (Bedfordshire incidents) | [NAME] | [NAME] | Q1-4 | Responding | SDMT | n/a
 | 0030a | Down | Quarterly | Average response time to primary fires (Sec) | [NAME] | [NAME] | Q1-4 | Responding | SDMT | 600
 | 0030b | Down | Quarterly | Average response time to secondary fires (Sec) | [NAME] | [NAME] | Q1-4 | Responding | SDMT | 1200
 | 0030d | Down | Quarterly | Average response time to RTCs (Sec) | [NAME] | [NAME] | Q1-4 | Responding | SDMT | 780
 | 34 | Up | Quarterly | RDS availability of 1st pump - primary available or alternate available | [NAME] | [NAME] | Q1-4 | Responding | SDMT | 0.9
 | 40 | Up | Quarterly | % of time whole-time global crewing availability enabled 9 riders on 2 pump responses | [NAME] | [NAME] | Q1-4 | Responding | SDMT | 0.9
 | EQ1a | Up | Annual | Percentage of new entrants to the RDS/On-Call operational staff to be women | [NAME] | Head HR | Q4 | Empowering | Equality & Diversity | 0.125
 | EQ1b | Up | Annual | Percentage of new entrants to the [NAME] operational staff to be women | [NAME] | Head HR | Q4 | Empowering | Equality & Diversity | 0.0946
 | EQ1c | Up | Annual | Percentage of RDS/On-Call operational staff who are women | [NAME] | Head HR | Q4 | Empowering | Equality & Diversity | 0.101
 | EQ1d | Up | Annual | Percentage of Whole time operational staff who are women | [NAME] | Head HR | Q4 | Empowering | Equality & Diversity | 0.072
 | EQ2a | Up | Annual | Recruitment of Black, Asian and Minority Ethnic (BAME) staff across the whole organisation | [NAME] | Head HR | Q4 | Empowering | Equality & Diversity | 0.089
 | EQ2b | Up | Annual | Recruitment of Black, Asian and Minority Ethnic (BAME) staff across operational roles | [NAME] | Head HR | Q4 | Empowering | Equality & Diversity | 0.071
 | EQ2c | Up | Annual | Percentage of RDS/On-Call operational staff who declare as BAME | [NAME] | Head HR | Q4 | Empowering | Equality & Diversity | 0.069
 | EQ2d | Up | Annual | Percentage of Wholetime operational staff who declare as BAME | [NAME] | Head HR | Q4 | Empowering | Equality & Diversity | 0.076
 | HR1 | Down | Quarterly | The percentage of working time lost due to sickness (excludes RDS/On-Call) | HR Ops | Head HR | Q1-4 | Empowering | Human Resources | 0.042
 | HR1c | Down | Quarterly | The percentage of the RDS/On-Call workforce with 4 or more incidences of sickness in a 12 month period | HR Ops | Head HR | Q1-4 | Empowering | Human Resources | 0.05
 | HR2a | Down | Annual | Turnover excluding retirement or dismissals - Excluding RDS/On-Call | HR Ops | Head HR | Q4 | Empowering | Human Resources | 0.05
 | HR2b | Down | Annual | Turnover excluding retirement or dismissals -RDS/On-Call only | HR Ops | Head HR | Q4 | Empowering | Human Resources | 0.14
 | HR3a | Up | Quarter 3 & 4 | Percentage of returned appraisal documents to HR within 3 months of reporting year (end September) All Staff | HR Ops | Head HR | Q3&4 | Empowering | Human Resources | 0.8
 | OH1 | Up | Annual | Percentage of personnel in operational [NAME] who have completed an annual fitness assessment in the past 12 months (excluding secondments, career breaks and modified and LTS). | [NAME] | Head HR | Q4 | Empowering | Occupational Health | 0.98
 | OH2 | Up | Annual | Percentage of operational personnel achieving a pass category in their annual fitness test | [NAME] | Head HR | Q4 | Empowering | Occupational Health | 0.96
 | OH3 | Up | Annual | Percentage of 3 yearly  medicals due in year completed | [NAME] | Head HR | Q4 | Empowering | Occupational Health | 0.85
 | T1 | Up | Quarterly | Percentage of station based operational BA wearers that have attended an assessed BA course within the last 2 years | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.98
 | T2 | Up | Quarterly | Percentage of EFAD qualified LGV drivers that have attended an EFAD course within the last 3 years | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.98
 | T3 | Up | Quarterly | Percentage of station based operational staff that have attended WFR course within the last 3 years | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.98
 | T4 | Up | Quarterly | Percentage of station based operational BA wearers that have attended Compartment Fire Behaviour course within the last 2 years | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.98
 | T5 | Up | Quarterly | Percentage of watches/sections at BFRS stations that have at least 60% of operational personnel qualified in [NAME] | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.98
 | T6 | Up | Quarterly | Percentage of station based operational staff that have attended a Working at Height Operator or Supervisor Revalidation course within the last 3 years | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.98
 | T7 | Up | Quarterly | Percentage of Flexible Duty Officers that have attended an Incident Command Assessment within the required frequency for their role | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.98
 | T8a | Up | Quarterly | Percentage of Safety Critical Maintenance training programmes completed by Whole-time Operational Personnel via PDR Pro within the last 12 months | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.92
 | T8b | Up | Quarterly | Percentage of Safety Critical Maintenance training programmes completed by [NAME] via PDR Pro within the last 12 months | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.9
 | T8c | Up | Quarterly | Percentage of Safety Critical Maintenance training programmes completed by Control Personnel/WM Control via PDR Pro within the last 12 months. | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.9
 | T8d | Up | Quarterly | Percentage of Safety Critical Maintenance training programmes completed by Senior Management roles (SC to SOC)  via PDR Pro within the last 12 months. | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.92
 | T8e | Up | Quarterly | Percentage of Safety Critical Maintenance training programme completed by Watch Commander - Day Duty via PDR Pro within last 12 months | [NAME] | [NAME] | Q1-4 | Empowering | Organisational Development | 0.92
 | H1 | Down | Quarterly | Number of serious accidents (over 28 days) per 1000 employees | [NAME] | [NAME] | Q1-4 | Empowering | Health And Safety | 3.78
 | H2 | Down | Quarterly | Number of working days/shifts lost to accidents per 1000 employees (excluding RDS//On-Call employees) | [NAME] | [NAME] | Q1-4 | Empowering | Health And Safety | 291.5
 | H3 | Down | Quarterly | Number of 24 hour cover periods lost to accidents per 1000 RDS/On-Call employees. | [NAME] | [NAME] | Q1-4 | Empowering | Health And Safety | 703.62
 | WS1a | Up | Quarterly | Grade A Defect Response Time (within 1 hour) | [NAME] | [NAME] | Q1-4 | Utilising | Fleet & Workshops | 0.9
 | WS1b | Up | Quarterly | Grade A Defect Response Time  (within 2 hours) | [NAME] | [NAME] | Q1-4 | Utilising | Fleet & Workshops | 0.95
 | WS2a | Down | Quarterly | The percentage of time when Rescue Pumping Appliances were unavailable for operational use due to an annual service, defect or other works. (Turnaround Time) | [NAME] | [NAME] | Q1-4 | Utilising | Fleet & Workshops | 0.05
 | WS2b | Down | Quarterly | The percentage of time when Aerial Appliances and SRU were unavailable for operational use due to an annual service defect or other works. (Turnaround Time) | [NAME] | [NAME] | Q1-4 | Utilising | Fleet & Workshops | 0.05
 | WS2c | Down | Quarterly | The percentage of time when other operational appliances were unavailable for operational use due to an annual service, defect or other works. (Turnaround Time) | [NAME] | [NAME] | Q1-4 | Utilising | Fleet & Workshops | 0.03
 | WS4 | Down | Quarterly | The number of hours as a percentage the appliance is unavailable for operational response in the reporting period, other than for the time measured under the turn-a-round time. (Idle time) | [NAME] | [NAME] | Q1-4 | Utilising | Fleet & Workshops | 0.02
 | WS5 | Up | Quarterly | The total time expressed as a % when ALL Appliances were available for operational use after the turn-a-round time and idle time are removed from the total time in the reporting period | [NAME] | [NAME] | Q1-4 | Utilising | Fleet & Workshops | 0.93
 | WS6 | Up | Quarterly | Annual Services undertaken | [NAME] | [NAME] | Q1-4 | Utilising | Fleet & Workshops | 0.97
 | FNP1 | Down | Annual | Budget requirement of Fire and Rescue Service (£ per 1,000 population). Performance Indicator to be used for information only | [NAME] | [NAME] | Q4 | Maximising | Finance | n/a
 | FNP2a | Down | Annual | Accuracy of net budget forecast outturn for period 6 (September) against actual outturn -  variance between forecast and actual outturn | [NAME] | [NAME] | Q4 | Maximising | Finance | 600000
 | FNP3 | Up | Quarterly | Percentage of routine financial reports distributed within 6 working days of period-end closure | [NAME] | [NAME] | Q1-4 | Maximising | Finance | 0.9
 | FNP4 | Up | Quarter 3 & 4 | Compliance of annual statement of accounts processes with statutory timescales and quality criteria | [NAME] | [NAME] | Q3&4 | Maximising | Finance | 1
 | [NAME] | Up | Quarterly | Percentage of uncontested invoices paid within 30 days | [NAME] | [NAME] | Q1-4 | Maximising | Finance | 0.96
 | FNP6 | Down | Quarterly | Percentage of outstanding debt over 90 days old | [NAME] | [NAME] | Q1-4 | Maximising | Finance | 0.015
 | [NAME] | Up | Annual | Percentage of annual planned efficiency savings achieved by year end | [NAME] | [NAME] | Q4 | Maximising | Finance | 1
 | FNP8 | Up | Annual | Return on investment | [NAME] | [NAME] | Q4 | Maximising | Finance | 0.01075
 | IM1 | Up | Quarterly | The Number of Incidents on Mission Critical services resolved within 1 Hour | [NAME] | [NAME] | Q1-4 | Maximising | Information and Communications Technology | 0.92
 | IM2 | Up | Quarterly | The Number of Incidents on Business Critical services resolved within 2 Hours | [NAME] | [NAME] | Q1-4 | Maximising | Information and Communications Technology | 0.97
 | IM3 | Up | Quarterly | The Number of Incidents on Business Operational services resolved within 4 Hours | [NAME] | [NAME] | Q1-4 | Maximising | Information and Communications Technology | 0.95
 | IM4 | Up | Quarterly | The Number of Incidents on Administration Services resolved within 8 Hour | [NAME] | [NAME] | Q1-4 | Maximising | Information and Communications Technology | 0.93
 | AV1 | Up | Quarterly | Core ICT services availability | [NAME] | [NAME] | Q1-4 | Maximising | Information and Communications Technology | 0.98
 | AV2 | Up | Quarterly | Business Applications Availability | [NAME] | [NAME] | Q1-4 | Maximising | Information and Communications Technology | 0.98
 | FNP2b | Down | Annual | Accuracy of net budget forecast outturn for period 9 (December) against actual outturn -  variance between forecast and actual outturn | [NAME] | [NAME] | Q4 | Maximising | Finance | 600000