{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Introduction FM Standards","Basic ","Advanced","Professional","Self Assessment Score Sheet","Gap analysis graphs"],"not_rendered":{"charts":8,"images":1,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Introduction FM Standards","index":0,"n_rows":30,"n_cols":2,"rows_kept":30,"merged":[[26,0,26,11],[27,0,27,4],[28,0,28,4],[29,0,29,4]]}
[]
[]
[]
[]
[]
[]
["Introduction"]
["The Fleet Management Standards are developed to support Aid and Development Organisations to manage and operate their vehicle fleet in the safest, most cost efficient and effective way with the least impact on the environment. "]
["The standards are developed based on good business practice from corporate organisations and with the input from various aid and development organisations"]
["The standards are divided in three levels: Basic, Advanced and Professional standards"]
["Basic Standards: describe the minimum quality standards that any organisation should have in place to be compliant with good practice"]
["Advanced Standards: describe a commitment to become safer, greener, cost efficient and effective."]
["Professional Standards: describe standards that aim to a high quality of fleet management and continious improvement. "]
[]
["A description of the standards can be found in the tabs Basic, Advanced and Professional, including the purpose of the standard and how the standard can be demonstrated (evidence)"]
["Organisations can use the Self Assessment to rate themselves at organisational level and practical implementation level, based on the scoring a gap analysis will be build (Gap analysis graphs) which provides guidance for the areas of improvement. "]
[]
["Using the Self Assessment"]
[1,"Select the Self Assessment Score sheet"]
[2,"For each statement apply a rating in the Rating columns. Rate the organisation first (column C to G), then rate how well the statement is implemented (column I to M) "]
[3,"Based on the ratings, graphs will build in the Gap Analysis Graphs sheet. This will give you the areas of improvement. "]
[]
["Important"]
["It is your perception that counts when filling the self assessment. "]
[]
["Definitions"]
["Drivers: Please note that the term drivers refers to employees driving an organisation owned, leased or hired vehicle as well as to riders of 2 wheeled means of transportation.  This includes also employees who drive their private vehicle for business purposes"]
["Strategy: a plan for achieving a particular goal usually over a long period of time"]
["Policy: A policy is a principle or protocol to guide decisions and achieve rational outcomes. A policy is a statement of intent, and is implemented as a procedure or protocol."]
["Procedure: A procedure is a document written to support a policy. A Procedure is designed to describe Who, What, Where, When, and Why by means of establishing corporate accountability in support of the implementation of a \"policy\". "]

{"sheet":"Basic ","index":1,"n_rows":37,"n_cols":4,"rows_kept":37}
["N","STANDARD","PURPOSE","DEMONSTRATION"]
[1,"Requirement: Organisations should have a fleet management strategy in place that describes how vehicle fleets support the mandate / programme objectives of the organisation.","To ensure that fleets support organisational / programme objectives","Written strategy document"]
[2,"Requirement: Appointment of a senior manager who will be accountable and responsible for managing and executing of the  fleet strategy. ","To ensure that the principles of cost effectiveness and value for money are applied and anchored within the organisation's culture at the highest level and to provide line authority to ensure resources are used effectively and that due weight is given to cost effectiveness","Documented evidence of organisational structure and responsibilities"]
[3,"Requirement: A senior manager is accountable and responsible for fleet and road safety. ","To ensure that fleet and road safety is on the organisations' agenda at the highest level and provides the appropriate executive line authority to allocation of resources and for the approval of plans to enable the organisation to act","Documented evidence of organisational structure and responsibilities"]
[4,"Requirement: Organisations should have a framework for accountability and responsibility in place, which specifies for each member of staff what the fleet management responsibilities are. ","To ensure that there are tangible links between staff responsibility and fleet performance","Documented evidence of organisational structure and responsibilities"]
[5,"Requirement: Organisations should have a framework for accountability and responsibility in place, which specifies for each member of staff what the fleet safety and sustainability  responsibilities are. ","To ensure that there are tangible links between staff responsibility and fleet and road safety performance","Documented evidence of organisational structure and responsibilities"]
[6,"Requirement: Organisations should demonstrate that policies, procedures and responsibilities are communicated to staff. ","To ensure that staff understands the policies, procedures and responsibilities and that they can work to them","Documented evidence can include organisations' policies, procedures and responsibilities being distributed to staff, staff training and/or policies being posted in areas where staff can view them"]
[7,"Requirement: Organisations shall set key performance indicators and initiate active monitoring.","To ensure that fleet performance can be objectively measured and that improvement actions take place when needed and that will allow continious improvement","Documented evidence of the KPIs as well as evidence  that the KPI has been communicated to relevant staff"]
[8,"Requirement: Organisations should monitor whether the staff is compliant to the policy and procedures.","To enable actions been taken place in case of non-compliance","A review schedule should be documented as well as the review meeting minutes"]
[9,"Requirement: Organisations shall put in place clear, transparent, robust procurement procedures and processes with specific, measurable, appropriate, relevant specifications. ","To ensure balance between vehicle capabilities, environmental impact, health and safety and cost considerations","Documented evidence of procedures as well as evidence that the procedures have been communicated to relevant staff"]
[10,"Requirement: Organisations should have procedures in place that support selection and specification of vehicles that are suitable for the types of trips undertaken, safe for staff and other road users and with the lowest impact on the environment.","To ensure better understandingof the types of vehicles that are required and to inform the final decision making process ","Documented evidence of fleet safety and sustainability selection and specification procedures"]
[11,"Requirement: Organisations should have effective policies and procedures to control how fleet vehicles are used.","To ensure adequate controls are in place to ensure that vehicles are used for legitimate purposes associated with organisational / programme objectives","Documented evidence of policies and procedures about vehicle use and evidence that the policies and procedures are communicated to staff"]
[12,"Requirement: Organisations shall ensure policies, procedures and systems are in place to capture financial spend data. ","To ensure the organisation has accurate data defining the Whole Life cost of each vehicle to facilitate fact based decision making to optimise fleet costs and balance these costs with programme objectives","A database with comprehensive and accurate financial data allocated vehicle by vehicle"]
[13,"Requirement: Organisations hold a minimum of third party insurance or self-insurance for the fleet and any other insurance necessary to provide financial protection to the operation.","To ensure the organisation is compliant with local laws and has the resources to cover the costs of a potential road traffic crash","Documented evidence of the insurance policy"]
[14,"Requirement: organisations have a clear fuel policy in place including targets for fuel consumption ","To ensure that the fuel(s) used suits the fleet requirements taking into account fuel consumption, environmental performance, fuel costs, refuelling infrastructure and residual values","A written policy document"]
[15,"Requirement: Organisations shall ensure accurate base data is collected for every vehicle in the fleet including vehicle type, make, model, registration, engine and VIN number, geographical location, allocated driver, service & accident history, km driven.","To ensure the organisation maintains accurate information about the size, composition and disposition of its fleet to enable fact based decision making on both deployment and optimisation of the fleet","A database with comprehensive and accurate fleet data. The database should lend itself for statistical analysis. "]
[16,"Requirement: Organisations shall have a fleet safety policy including organisational design, selection of people and drivers, vehicles and equipment. ","To ensure that the organisations ambition and staff responsibilities are defined and can be communicated","Written policy document"]
[17,"Requirement: Organisations should define a driving policy, which covers driver responsibilities, speed limits, vulnerable road users, safety equipment, use of seatbelts, use of mobile phones, alcohol and drugs, and fatigue.","To ensure that staff responsibilities are defined and communicated","The driving policy should be shared with all staff driving for official purposes. Drivers should be re-briefed after updates and minutes of re-briefing should be documented"]
[18,"Requirement: Organisations should have policies and procedures to manage both driving hours and total working time. ","To ensure that drivers are suffiently alert so that they drive in a safe manner","Documented evidence of planning shifts for drivers to ensure that drivers' hours and working time regulations are respected"]
[19,"Requirement: Organisations should integrate necessary safe driving criteria into the overall Terms of Reference for professional drivers and of staff that drives for official purposes. ","To ensure that employees are capable and safe drivers.","Evidence could include Terms of Reference in which safe driving criteria is included, copies of valid drivers licences, documented reference checks, documented past accident and prosecution history, documented 'fit to drive' certificates, documented 'on-road-assessments, documented results of rules and regulations tests"]
[20,"Requirement: Organisations should have a procedure for recruiting and selecting drivers. ","To ensure that recruited drivers are capable and safe drivers","Documented evidence of the driver selection procedure. Organisations should also have documented evidence that the drivers are selected against the driver requirements"]
[21,"Requirement: Organisations should have initial induction training, coupled with on-going training and development for all staff related to fleet functions throughout their time in the organisation. ","To ensure that all staff have the appropriate regulatory knowledge and skills to competently conduct their duties","Documented evidence of the induction training and driver training plans"]
[22,"Requirement: Organisations should conduct driver medical checks once every 12 months. ","To ensure the safety of drivers, passengers and the public from occupational and life style related health issues","Documented evidence of the yearly fitness checks in the personal file of all staff that drive for business / official purposes"]
[23,"Requirement: Organisations should provide drivers with handbooks in which driving rules and regulations are stated. ","To ensure that drivers know what is expected of them from a safety perspective and to help explain to drivers the importance of safe driving","Documented evidence that the handbooks are handed out to the drivers. Organisations should also keep documented evidence that the drivers are tested on their comprehension of the handbook"]
[24,"Requirement: Organisations should have a planned approach to vehicle maintenance, including daily and weekly checks as well as planned maintenance programmes with clear standards and minimum periods between services. ","To reduce the risks of being a danger on the road and a vehicle breakdown","Records of the maintenance plan"]
[25,"Requirement: Organisations should ensure that pre-defined safety equipment is available in all vehicles and that the safety equipment is inspected and serviced to manufacturer’s requirements. ","To ensure that safety equipment is in good working order to comply with safety requirements","Documented evidence of inspection and service records"]
[26,"Requirement: Organisations shall ensure that vehicles are safely loaded.","To ensure that vehicle loads in normal and emergency situations do not cause a hazard","Documented evidence of the risk assessment of the type of load carried by each vehicle (dimensions, weight and movement), providing proper loading equipment, and keep records of safe loading to staff"]
[27,"Requirement: Organisations shall have a policy in place to manage specific journey related risks such as night driving, use of higher-risk routes and areas, weather conditions etc.","To mitigate risks to staff and other road users","Documented evidence of the journey scheduling policy and that the policy has been communicated to staff"]
[28,"Requirement: Organisations have a robust system in place setting out what checks and inspections need to be carried out, with what frequency and by whom. This includes pre-trip checks, inter-trip check and post-trip check. ","To ensure that vehicles are inspected for safety and defects are rectified to ensure safety","Documented records of the vehicle checks and (internal) auditors may witness such checks being undertaken by randomly selected drivers"]
[29,"Requirement: Organisations should have a system in place that ensures that journeys are properly authorised and that in the event of an incident or delay appropriate response can be put into effect. ","To reduce risks to staff and other road users","The organisation should keep records of the authorized journey schedules. The organisations should keep documented evidence of the response mechanism in the event of an incident or delay"]
[30,"Requirement: Organisations should have defined disposal policies and procedures in place to remarket vehicles, whether because the vehicle is at the end of its economic life or because of changes in the programme transport requirements. ","To ensure that the organisation has transparent, auditable and efective procedures in place to maximise revenues from the sale of disposed vehicles and to demonstrate effective use of donor funding","Documented plans with transparent, auditable processes and clear tracking mechanisms to maximise resale values including roles, responsibilities, reporting lines, performance management and management information reporting"]
[31,"Requirement: Organisations shall ensure that there is a crash and incident response system in place, which lays out roles and responsibilities as well as response times","To establish guidelines for responding to a crash and to ensure accurate and consistent reporting of information concerning the crash","Documented evidence of the guidelines as well as evidence of the guidelines being communicated to staff"]
[32,"Requirement: Organisations that choose to outsource transportation, consider clear safety and environmental criteria in the selection procedure. ","To ensure all transport suppliers providing services to the organisation have safety standards in place and to reduce the organisational risk to damage the reputation","Recorded evidence of transport tender documents"]
[33,"Requirement: Organisations shall ensure that crashes and incidents are recorded.","To ensure that all crashes and incidents are managed in a consistent manner, that evidence is captured ","Evidence of recorded crashes and incidents"]
[34,"Requirement: Organisations shall carry out a Whole Life Cost Analysis on every vehicle in the fleet and regularly review these analyses focussing on the Total Holding Cost of each vehicle in terms of $/km and $/unit time. ","To ensure informed decision making about when to retire aging vehicles from the fleet enabling the fleet manager to optimise costs and ensure optimal operational readiness","Documented evidence of historical costs per vehicle and mapping likely future costs "]
[35,"Requirement: Organisations measure the fleet safety performance at least once a year.","To ensure that senior management are engaged in reviewing fleet safety system that performance is measured against targets and take appropriate measures when needed","A review schedule should be documented as well as the review meeting minutes"]
[36,"Requirement: Organisations should measure the environmental impact of their fleet (coming from fuel consumption and emissions) of all vehicles at least annually","To ensure that fuel consumption and reduction in emissions is measured against targets and take appropriate measures when needed","A documented review schedule as well as the review meeting minutes"]

{"sheet":"Advanced","index":2,"n_rows":14,"n_cols":4,"rows_kept":14}
["N","STANDARD","PURPOSE","DEMONSTRATION"]
[1,"Requirement: A full and comprehensive hazard identification and risk assessment will be carried out and should be reviewed at least annually as part of the management review. ","To ensure that organisations identify risks and are able to take measures to mitigate the fleet and road safety risks","A review schedule should be documented as well as the review meeting minutes"]
[2,"Requirement: Procedures need to be in place to select, evaluate and implement measures that eliminate or control risks. Measures should include actions that prevent the escalation of any incidents that do occur through an effective emergency response plan. ","To ensure that organisations identify risks and are able to take measures to mitigate the fleet and road safety risks","A review schedule should be documented as well as the review meeting minutes"]
[3,"Requirement: organisations should have policy in place for workshops regarding disposal of fluids, waste (incl. old spare parts)","To ensure that the environmental impact of workshops will be minimised","A written policy document"]
[4,"Requirement: The organisation should inform their transport suppliers about the road and fleet safety policy and how transporters are expected to behave when driving on behalf of the organisation.","To ensure that transport suppliers know what is expected of them","Documented evidence can include the organisations' policies, procedures and responsibilities being distributed to staff of transport suppliers"]
[5,"Requirement: Organisations should have a policy in place that  highlights the requirements for employees to use the most economic and efficient method of travel, taking into account the cost of travel, environmental impact and timing factors","To ensure that the vehicles are fit for purpose and at the same time minimise fuel consumption and safety risks","A written policy document"]
[6,"Requirement: Organisations should have route plans in place that identify hazards along a road and provide guidance for each hazard identified.  ","To reduce the risk to staff and other road users","Documented evidence of the route plans and evidence that the plans are communicated to drivers and staff"]
[7,"Requirement: Organisations must demonstrate a credible plan to maintain the fleet throughout its life considering availability of spare parts, tyres, trained technicians, special tools and diagnostic equipment.","To ensure balance between vehicle capabilities, the environmental impact, health and safety and cost considerations","Documented evidence of service plans including roles and responsibilities, use of outsourcing, quality assurance measures, controls on maintenance spend and addressing access to spare parts, trained technicians, special equipment, diagnostic tools and technical support"]
[8,"Requirement: Organisations should do a market assessment at a minimum every 2 years to identify and work with the most appropriate service providers","To ensure that the organisation works with (transport) service providers that provide best value for money in terms of costs, safety and environmental sustainability","Documented records of the market research"]
[9,"Requirement: Organisations should establish eco-driving training for all staff that drive for business purposes","To reduce the fuel consumption and emissions by improving drivers skills","Documented evidence of eco-driving training and driver training plans including performance in personal file"]
[10,"Requirement: Organisations shall ensure that privately owned vehicles that are used for official purpose are fit for purpose, insured for official use, comply with local regulatory requirements, have a servicing record, and are roadworthy. ","To mitigate organisational liaibility risk when privately owned vehicles are involved in accidents","Documented records of vehicle checks, insurance and servicing records"]
[11,"Requirement: Organisations should review driver performance at least once a year. ","To ensure drivers compliance with policies, procedures and standards and to identify training and development needs of drivers","A review schedule should be documented as well as the individual performance appraisal reports"]
[12,"Requirement: Organisations shall ensure that the reported road traffic crashes and incidents are analysed and that root causes are identified, and that lessons learned and corrective actions are implemented.","To avoid road traffic crashes in the future","Evidence of recorded crashes and incidents and evidence of the root cause analysis being reviewed and reacted on"]
[13,"Requirement: Organisations should conduct emergency transport needs asssessments annually and ensure that the fleet function is prepared to  respond to an emergency if needed","To ensure that during emergency and disaster response activities the fleet function can provide appropriate support to the organisation","A documented emergency transported needs assessment"]

{"sheet":"Professional","index":3,"n_rows":12,"n_cols":4,"rows_kept":12}
["N","STANDARD","PURPOSE","DEMONSTRATION"]
[1,"Requirement: Organisations should have a structured approach in place to finance their fleet ","To ensure that the average age of the fleet in line with its disposal policy and to ensure that the organisation meets the criteria in its safety and environmental policies. ","A written policy document"]
[2,"Requirement: Organisations shall ensure that costs of fleet are 100% recordable and traceable. ","To ensure that fleet related decisions can be made using accurate, complete and timley data","A documented internal audit report should be available"]
[3,"Requirement: Organisations should have an approach in place that limits the chance of data capture errors","To ensure that fleet related decisions can be made using accurate data and to ensure transparancy of the fleet costs","Evidence of spot checks conducted on fleet data, including observations and recommendations (if any)"]
[4,"Requirement: Organisations should have a travel hierarchy, that encourages remote working and car sharing","To minimise the environmental impact of the fleet ","A written policy document"]
[5," Requirement: Organisations should have an appropriate driver reward and recognition scheme in place.","To motivate drivers to the desired level of performance and to recognise significant achievements from staff","Documented evidence that the reward and recognition scheme is communicated to all staff. Results of the award and recognition scheme should be visible displayed in the organisation"]
[6,"Requirement: Organisations should purchase fuel that is the least harmful for the environment or health.","To ensure that the fuel used has the lowest possible impact on the global and local environment","Documented evidence that fuel that has been bought is less harmful. "]
[7,"Requirement: Organisations shall ensure that near misses are recorded, analysed and that corrective actions are implemented.","To avoid accidents and incidents from happening in the future","Evidence of recorded near misses and evidence of the content of the records being reviewed and reacted on"]
[8," Requirement: The organisation should review the contractors’ safety and environmental performance at least once every 12 months","To ensure transporters compliance with policies, procedures and standards and to identify areas for improvement","A review schedule should be documented as well as the transporters performance reports. This can also include self-assessments, driver performance etc. "]
[9,"Requirement: Organisations should audit their fleet management system at least once a year by external auditors.  ","To ensure that the fleet management system is effective","A documented audit report including recommendations should be available"]
[10,"Requirement: Organisations have a talent management strategy that supports promotes a gender-balanced fleet workforce","To ensure the organisation's fufills its commitment to human rights and that the fleet workforce reflects communities in which the organisation operates","Documented evidence of the talet management strategy as well as statistics on the diversity of the workforce"]
[11,"Requirement: Organsations should publicly report its road safety and environmental performance","To be transparant and accountable for the negative consequences that arise from operating fleet","Documented evidence, for example in the form of annual Safety, Health and Environment report"]

{"sheet":"Self Assessment Score Sheet","index":4,"n_rows":75,"n_cols":31,"rows_kept":75,"merged":[[2,2,2,6],[2,7,2,12],[3,2,3,6],[3,7,3,12],[4,0,4,1],[4,2,4,6],[4,8,4,12],[5,0,6,1],[5,14,6,14],[44,8,44,12],[59,8,59,12],[72,8,72,12]]}
[]
[]
[null,null,"Name organisation & location"]
[null,null,"Date Self Assessment"]
["Self-Evaluation against VFM standards. Please fill out the appropriate cell for each of the two scoring dimensions with \"x\"",null,"The statement agrees with the policy, procedure or structure in my organisation",{"$nulls":5},"The statement is practical implemented by my office",{"$nulls":4},"Total Score"]
["How good do YOU rate your organisation at the repective level of your position (HQ or country office) for the following topics?",null,"weakly","reasonably","strongly","vey strongly","Do not know",null,"weakly","reasonably","strongly","vey strongly","Do not know",null,"Comments / Observations"]
[null,null,1,2,3,4,"?",null,1,2,3,4,"?"]
[null,"BASIC",{"$nulls":13},"Theoretical","Practical",{"$nulls":10},"total ","theoretical ","practical"]
[1,"My organisation has a clear fleet management strategy in place that describes how vehicle fleets support the mandate / programme objectives of the organisation, the safety of staff and other road users and the environmental sustainability.",{"$nulls":11},{"$f":"IF(V9=1,0,R9+S9*2+T9*3+U9*4+W9+X9*2+Y9*3+Z9*4)","v":0},null,{"$f":"IF(V9=1,0,R9+S9*2+T9*3+U9*4)","v":0},{"$f":"IF(V9=1,0,W9+X9*2+Y9*3+Z9*4)","v":0},{"$f":"IF(C9=0,0,1)","v":0},{"$f":"IF(D9=0,0,1)","v":0},{"$f":"IF(E9=0,0,1)","v":0},{"$f":"IF(F9=0,0,1)","v":0},{"$f":"IF(G9=0,0,1)","v":0},{"$f":"IF(I9=0,0,1)","v":0},{"$f":"IF(J9=0,0,1)","v":0},{"$f":"IF(K9=0,0,1)","v":0},{"$f":"IF(L9=0,0,1)","v":0},null,{"$f":"SUM(N9:N14)","v":0},{"$f":"SUM(P9:P14)","v":0},{"$f":"SUM(Q9:Q14)","v":0},"Strategic Fleet Management"]
[2,"In the safety and sustainability stategies of my organisation, consideration has been given to vehicle fleets and fleet management.",{"$nulls":11},{"$f":"IF(V10=1,0,R10+S10*2+T10*3+U10*4+W10+X10*2+Y10*3+Z10*4)","v":0},{"$nulls":13},{"$f":"SUM(N15:N40)","v":0},{"$f":"SUM(P15:P40)","v":0},{"$f":"SUM(Q15:Q40)","v":0},"Operational policies and procedures"]
[3,"In my organisation an appointed senior manager is accountable and responsible for managing and executing of the fleet strategy. ",{"$nulls":11},0,null,{"$f":"IF(V11=1,0,R11+S11*2+T11*3+U11*4)","v":0},{"$f":"IF(V11=1,0,W11+X11*2+Y11*3+Z11*4)","v":0},{"$f":"IF(C11=0,0,1)","v":0},{"$f":"IF(D11=0,0,1)","v":0},{"$f":"IF(E11=0,0,1)","v":0},0,0,{"$f":"IF(I11=0,0,1)","v":0},{"$f":"IF(J11=0,0,1)","v":0},{"$f":"IF(K11=0,0,1)","v":0},{"$f":"IF(L11=0,0,1)","v":0},null,{"$f":"SUM(N41:N44)","v":0},{"$f":"SUM(P41:P44)","v":0},{"$f":"SUM(Q41:Q44)","v":0},"Reviewing: Collecting data & measuring performance"]
[4,"In my organisations there is a clear framework for accountability and responsibility in place, which specifies for each member of staff what the fleet management responsibilities are. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[5,"My organisation has a clear framework for accountability and responsibility in place, which specifies for each member of staff what the fleet safety and sustainability responsibilities are. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[6,"My organisation has set appropriate key performance indicators and initiate active monitoring.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[7,"My organisation communicates effectively policies, procedures and responsibilities to staff. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[8,"My organisation monitors regularly staff compliance to the policies and procedures.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[9,"My organisation has put in place clear, transparent, robust procurement procedures and processes with specific, measurable, appropriate, relevant specifications. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[10,"My organisation has clear procedures in place that support selection and specification of vehicles that are suitable for the types of trips undertaken, safe for staff and other road users and with the lowest impact on the environment.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[11,"My organisation has effective policies and procedures to control how fleet vehicles are used.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[12,"In my organisation there are effective policies, procedures and systems in place to capture financial data. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[13,"My organisation holds a minimum of third party insurance or self-insurance for the fleet and any other insurance necessary to provide financial protection to the operation.",{"$nulls":11},0,null,{"$f":"IF(V21=1,0,R21+S21*2+T21*3+U21*4)","v":0},{"$f":"IF(V21=1,0,W21+X21*2+Y21*3+Z21*4)","v":0},{"$f":"IF(C21=0,0,1)","v":0},{"$f":"IF(D21=0,0,1)","v":0},{"$f":"IF(E21=0,0,1)","v":0},{"$f":"IF(F21=0,0,1)","v":0},{"$f":"IF(G21=0,0,1)","v":0},{"$f":"IF(I21=0,0,1)","v":0},{"$f":"IF(J21=0,0,1)","v":0},{"$f":"IF(K21=0,0,1)","v":0},{"$f":"IF(L21=0,0,1)","v":0}]
[14,"My organisation has a clear fuel policy in place including targets for fuel consumption ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[15,"In my organisation an up to date and accurate database exists in which base data is collected for every vehicle in the fleet including vehicle type, make, model, registration, engine and VIN number, geographical location, allocated driver, service & accident history, km driven.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[16,"In my organisation a clear road safety policy is in place, which covers organisational structure, risk assesments and road safety performance.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[17,"My organisation has defined a clear driving policy in place, which covers driver responsibilities, speed limits, vulnerable road users, safety equipment, use of seatbelts, use of mobile phones, alcohol and drugs, and fatigue.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[18,"My organisation has effective policies and procedures in place to manage both driving hours and total working time. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[19,"In my organisation the necessary safe driving criteria are integrated into the overall Terms of Reference for professional drivers and of staff that drives for official purposes.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[20,"My organisation has a standard procedure in place for recruiting and selecting drivers.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[21,"My organisation has an initial induction training, coupled with on-going training and development for all staff related to fleet functions throughout their time in the organisation. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[22,"My organisation conducts driver medical checks once every 12 months. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[23,"My organisation provides drivers with up to date information in which driving rules and regulations are stated. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[24,"My organisation has a planned approach to vehicle maintenance, including daily and weekly checks as well as planned maintenance programmes with clear standards and minimum periods between services. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[25,"My organisation has a policy in place to ensure that pre-defined safety equipment is available in all vehicles and that the safety equipment is inspected and serviced to manufacturer’s requirements. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[26,"My organisation has a policy in place to ensure that vehicles are safely loaded.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[27,"In my organisation specific journey related risks such as night driving, use of higher-risk routes and areas, weather conditions etc, are managed in a systematic way.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[28,"My organisation has a robust system in place setting out what checks and inspections need to be carried out, with what frequency and by whom. This includes pre-trip checks, inter-trip check and post-trip check. ",{"$nulls":11},0,null,{"$f":"IF(V36=1,0,R36+S36*2+T36*3+U36*4)","v":0},{"$f":"IF(V36=1,0,W36+X36*2+Y36*3+Z36*4)","v":0},{"$f":"IF(C36=0,0,1)","v":0},{"$f":"IF(D36=0,0,1)","v":0},{"$f":"IF(E36=0,0,1)","v":0},{"$f":"IF(F36=0,0,1)","v":0},{"$f":"IF(G36=0,0,1)","v":0},{"$f":"IF(I36=0,0,1)","v":0},{"$f":"IF(J36=0,0,1)","v":0},{"$f":"IF(K36=0,0,1)","v":0},{"$f":"IF(L36=0,0,1)","v":0}]
[29,"My organisation has a system in place that ensures that journeys are properly authorised and that in the event of a delay, appropriate response can be put into effect. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[30,"My organisation has effective disposal policies and procedures in place to remarket vehicles, whether because the vehicle is at the end of its economic life or because of changes in the programme transport requirements. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[31,"In my organisation there is an effective incident and crash response system in place, which lays out roles and responsibilities as well as response times.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[32,"When my organisation outsources transportation, clear safety and environmental criteria are considered in the selection procedure. ",{"$nulls":11},0,null,0,0,{"$f":"IF(C40=0,0,1)","v":0},{"$f":"IF(D40=0,0,1)","v":0},{"$f":"IF(E40=0,0,1)","v":0},0,0,{"$f":"IF(I40=0,0,1)","v":0},{"$f":"IF(J40=0,0,1)","v":0},{"$f":"IF(K40=0,0,1)","v":0},{"$f":"IF(L40=0,0,1)","v":0}]
[33,"In my organisation crashes and incidents are recorded in a standardised way.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[34,"My organisation carries out a Life Cycle Analysis on every vehicle in the fleet and regularly reviews these analyses focussing on the Total Cost of Ownership of each vehicle. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[35,"My organisation measures the fleet safety performance at least once a year.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[36,"My organisation measures the environmental impact (emissions) of the fleet of all vehicles at least annually.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"Total Score Basic",{"$nulls":4},{"$f":"IF(V45=1,0,R45+S45*2+T45*3+U45*4+W45+X45*2+Y45*3+Z45*4)","v":0},null,{"$f":"SUM(P9:P44)","v":0},{"$f":"SUM(Q9:Q44)","v":0},{"$f":"SUM(R9:R44)","v":0},0,0,0,0,0,0,0,0]
[null,"ADVANCED",{"$nulls":11},0]
[1,"In my organisation full and comprehensive hazard identification and risk assessments are carried out and reviewed at least annually as part of the management review. ",{"$nulls":11},0,null,0,0,0,0,0,{"$f":"IF(F47=0,0,1)","v":0},{"$f":"IF(G47=0,0,1)","v":0},0,0,0,0,null,{"$f":"SUM(N49:N51,N53:N56)","v":0},{"$f":"SUM(P49:P51,P53:P56)","v":0},{"$f":"SUM(Q49:Q51,Q53:Q56)","v":0},"Ongoing improvement of performance"]
[2,"My organisation has effective procedures in place to select, evaluate and implement measures that eliminate or control risks. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(N47:N48,N52,N59)","v":0},{"$f":"SUM(P47:P48,P52,P59)","v":0},{"$f":"SUM(Q47:Q48,Q52,Q59)","v":0},"Controlling / Mitigating business risks"]
[3,"My organisation has a policy in place for workshops regarding disposal of fluids, waste (incl. old spare parts)",{"$nulls":11},{"$f":"IF(V49=1,0,R49+S49*2+T49*3+U49*4+W49+X49*2+Y49*3+Z49*4)","v":0},null,{"$f":"IF(V49=1,0,R49+S49*2+T49*3+U49*4)","v":0},{"$f":"IF(V49=1,0,W49+X49*2+Y49*3+Z49*4)","v":0},{"$f":"IF(C49=0,0,1)","v":0},{"$f":"IF(D49=0,0,1)","v":0},{"$f":"IF(E49=0,0,1)","v":0},{"$f":"IF(F49=0,0,1)","v":0},{"$f":"IF(G49=0,0,1)","v":0},{"$f":"IF(I49=0,0,1)","v":0},{"$f":"IF(J49=0,0,1)","v":0},{"$f":"IF(K49=0,0,1)","v":0},{"$f":"IF(L49=0,0,1)","v":0},null,{"$f":"SUM(N57:N58)","v":0},{"$f":"SUM(P57:P58)","v":0},{"$f":"SUM(Q57:Q58)","v":0},"Analysing data and identifying corrective actions"]
[4,"My organisation informs the transport suppliers about the road and fleet safety policy and how transporters are expected to behave when driving on behalf of the organisation.",{"$nulls":11},0,null,0,0,{"$f":"IF(C49=0,0,1)","v":0},{"$f":"IF(D49=0,0,1)","v":0},{"$f":"IF(E49=0,0,1)","v":0},{"$f":"IF(F49=0,0,1)","v":0},{"$f":"IF(G49=0,0,1)","v":0},{"$f":"IF(I49=0,0,1)","v":0},{"$f":"IF(J49=0,0,1)","v":0},{"$f":"IF(K49=0,0,1)","v":0},{"$f":"IF(L49=0,0,1)","v":0}]
[5,"My organisation has a policy that highlights the requirements for employees to use the most economic and efficient method of travel, taking into account the cost of travel, environmental impact and timing factors.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[6,"In my organisation up to date and well-documented route plans exist that identify hazards along a road and provide guidance for each hazard identified.  ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[7,"My organisation has a credible plan in place to maintain the fleet throughout its life considering availability of spare parts, tyres, trained technicians, special tools and diagnostic equipment.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[8,"Every two years, my organisation does a market assessment to identify and work with the most appropriate service providers",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[9,"My organisation provides regular eco-driving training for all staff that drive for business purposes",{"$nulls":11},0,null,{"$f":"IF(V55=1,0,R55+S55*2+T55*3+U55*4)","v":0},{"$f":"IF(V55=1,0,W55+X55*2+Y55*3+Z55*4)","v":0},0,0,0,0,0,0,0,0,0]
[10,"My organisation has a policy in place that ensures that privately owned vehicles that are used for official purpose are fit for purpose, insured for official use, comply with local regulatory requirements, have a servicing record, and are roadworthy. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[11,"My organisations reviews drivers' performance at least once a year. ",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[12,"My organisation ensures that the reported incidents and crashes are analysed, that root causes are identified, and that lessons learned and corrective actions are implemented.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[13,"My organisation annually conducts an emergency transport needs assessment and is prepared to respond to an emergency if needed",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"Total Score Advanced",{"$nulls":4},{"$f":"IF(V60=1,0,R60+S60*2+T60*3+U60*4+W60+X60*2+Y60*3+Z60*4)","v":0},null,{"$f":"SUM(P47:P59)","v":0},{"$f":"SUM(Q47:Q59)","v":0}]
[null,"PROFESSIONAL"]
[1,"In my organisation, financing of the fleet follows a structured approach. ",{"$nulls":13},{"$f":"IF(V62=1,0,R62+S62*2+T62*3+U62*4)","v":0},{"$f":"IF(V62=1,0,W62+X62*2+Y62*3+Z62*4)","v":0},{"$f":"IF(C62=0,0,1)","v":0},{"$f":"IF(D62=0,0,1)","v":0},{"$f":"IF(E62=0,0,1)","v":0},{"$f":"IF(F62=0,0,1)","v":0},{"$f":"IF(G62=0,0,1)","v":0},{"$f":"IF(I62=0,0,1)","v":0},{"$f":"IF(J62=0,0,1)","v":0},{"$f":"IF(K62=0,0,1)","v":0},{"$f":"IF(L62=0,0,1)","v":0},null,{"$f":"SUM(N65:N67)","v":0},{"$f":"SUM(P65:P67)","v":0},{"$f":"SUM(Q65:Q67)","v":0},"Professionalism in & outside the organisation"]
[2,"In my organisation, costs of fleet are 100% recorded and traceable",{"$nulls":13},{"$f":"IF(V63=1,0,R63+S63*2+T63*3+U63*4)","v":0},{"$f":"IF(V63=1,0,W63+X63*2+Y63*3+Z63*4)","v":0},{"$f":"IF(C63=0,0,1)","v":0},{"$f":"IF(D63=0,0,1)","v":0},{"$f":"IF(E63=0,0,1)","v":0},{"$f":"IF(F63=0,0,1)","v":0},{"$f":"IF(G63=0,0,1)","v":0},{"$f":"IF(I63=0,0,1)","v":0},{"$f":"IF(J63=0,0,1)","v":0},{"$f":"IF(K63=0,0,1)","v":0},{"$f":"IF(L63=0,0,1)","v":0},null,{"$f":"SUM(N68:N72)","v":0},{"$f":"SUM(P68:P72)","v":0},{"$f":"SUM(Q68:Q72)","v":0},"Professional review and analysis "]
[3,"In my organisation, we have an approach to data collection that limits the chance of data capture errors. ",{"$nulls":13},0,0,0,0,0,0,0,0,0,0,0]
[4,"My organisation has a travel hierarchy, that encourages remote working and car sharing, to minimise the environmental impact.",{"$nulls":11},0,null,{"$f":"IF(V65=1,0,R65+S65*2+T65*3+U65*4)","v":0},{"$f":"IF(V65=1,0,W65+X65*2+Y65*3+Z65*4)","v":0},{"$f":"IF(C65=0,0,1)","v":0},{"$f":"IF(D65=0,0,1)","v":0},{"$f":"IF(E65=0,0,1)","v":0},{"$f":"IF(F65=0,0,1)","v":0},{"$f":"IF(G65=0,0,1)","v":0},{"$f":"IF(I65=0,0,1)","v":0},{"$f":"IF(J65=0,0,1)","v":0},{"$f":"IF(K65=0,0,1)","v":0},{"$f":"IF(L65=0,0,1)","v":0}]
[5,"My organisation has an appropriate driver reward and recognition scheme in place.",{"$nulls":11},0,null,0,{"$f":"IF(V66=1,0,W66+X66*2+Y66*3+Z66*4)","v":0},{"$f":"IF(C66=0,0,1)","v":0},{"$f":"IF(D66=0,0,1)","v":0},{"$f":"IF(E66=0,0,1)","v":0},{"$f":"IF(F66=0,0,1)","v":0},{"$f":"IF(G66=0,0,1)","v":0},{"$f":"IF(I66=0,0,1)","v":0},{"$f":"IF(J66=0,0,1)","v":0},{"$f":"IF(K66=0,0,1)","v":0},{"$f":"IF(L66=0,0,1)","v":0}]
[6,"My organisation purchases fuel that is the least harmful for the environment or health.",{"$nulls":11},0,null,{"$f":"IF(V67=1,0,R67+S67*2+T67*3+U67*4)","v":0},{"$f":"IF(V67=1,0,W67+X67*2+Y67*3+Z67*4)","v":0},0,0,0,0,0,0,0,0,0]
[7,"My organisation ensures that near misses are recorded, analysed and that lessons learned and corrective actions are implemented.",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[8,"My organisation reviews the contractors’ safety and environmental performance at least once every 12 months",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[9,"In my organisation the fleet management system is audited at least once a year by external auditors.  ",{"$nulls":11},{"$f":"IF(V70=1,0,R70+S70*2+T70*3+U70*4+W70+X70*2+Y70*3+Z70*4)","v":0},null,{"$f":"IF(V70=1,0,R70+S70*2+T70*3+U70*4)","v":0},{"$f":"IF(V70=1,0,W70+X70*2+Y70*3+Z70*4)","v":0},{"$f":"IF(C70=0,0,1)","v":0},{"$f":"IF(D70=0,0,1)","v":0},{"$f":"IF(E70=0,0,1)","v":0},{"$f":"IF(F70=0,0,1)","v":0},{"$f":"IF(G70=0,0,1)","v":0},{"$f":"IF(I70=0,0,1)","v":0},{"$f":"IF(J70=0,0,1)","v":0},{"$f":"IF(K70=0,0,1)","v":0},{"$f":"IF(L70=0,0,1)","v":0}]
[10,"Requirement: Organsations should publicly report its road safety and environmental performance",{"$nulls":11},0,null,0,0,0,0,0,0,0,0,0,0,0]
[11," In my organisation, we have a talent management strategy that supports promotes a gender-balanced fleet workforce",{"$nulls":13},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},"Total Score Professional",{"$nulls":4},{"$f":"SUM(N65:N72)","v":0},null,{"$f":"SUM(P65:P72)","v":0},{"$f":"SUM(Q65:Q72)","v":0}]
[]
[{"$nulls":8},"Total Score",{"$nulls":4},{"$f":"N73+N60+N45","v":0}]

{"sheet":"Gap analysis graphs","index":5,"n_rows":15,"n_cols":7,"rows_kept":15}
[]
[null,"Maximum",{"$f":"'Self Assessment Score Sheet'!H3","v":0},null,"Max Theor. ","Policies in place","Practical implementation"]
["Basic",{"$f":"36*8","v":288},{"$f":"'Self Assessment Score Sheet'!N45","v":0},null,{"$f":"B3/2","v":144},{"$f":"'Self Assessment Score Sheet'!P45","v":0},{"$f":"'Self Assessment Score Sheet'!Q45","v":0}]
["Advanced",{"$f":"8*13","v":104},{"$f":"'Self Assessment Score Sheet'!N60","v":0},null,{"$f":"B4/2","v":52},{"$f":"'Self Assessment Score Sheet'!P60","v":0},{"$f":"'Self Assessment Score Sheet'!Q60","v":0}]
["Professional",{"$f":"11*8","v":88},{"$f":"'Self Assessment Score Sheet'!N73","v":0},null,{"$f":"B5/2","v":44},{"$f":"'Self Assessment Score Sheet'!P73","v":0},{"$f":"'Self Assessment Score Sheet'!Q73","v":0}]
[]
["Basic Standards","Maximum",{"$f":"'Self Assessment Score Sheet'!H3","v":0},null,"Max Theor. ","Policies in place","Practical implementation"]
["Strategic Fleet Management",{"$f":"6*8","v":48},{"$f":"'Self Assessment Score Sheet'!AB9","v":0},null,{"$f":"B8/2","v":24},{"$f":"'Self Assessment Score Sheet'!AC9","v":0},{"$f":"'Self Assessment Score Sheet'!AD9","v":0}]
["Operational policies and procedures",{"$f":"26*8","v":208},{"$f":"'Self Assessment Score Sheet'!AB10","v":0},null,{"$f":"B9/2","v":104},{"$f":"'Self Assessment Score Sheet'!AC10","v":0},{"$f":"'Self Assessment Score Sheet'!AD10","v":0}]
["Reviewing: Collecting data & measuring performance",{"$f":"4*8","v":32},{"$f":"'Self Assessment Score Sheet'!AB11","v":0},null,16,{"$f":"'Self Assessment Score Sheet'!AC11","v":0},{"$f":"'Self Assessment Score Sheet'!AD11","v":0}]
[]
["Advanced Standards","Maximum",{"$f":"'Self Assessment Score Sheet'!H3","v":0},null,"Max Theor. ","Policies in place","Practical implementation"]
["Ongoing improvement of performance",{"$f":"7*8","v":56},{"$f":"'Self Assessment Score Sheet'!AB47","v":0},null,{"$f":"B13/2","v":28},{"$f":"'Self Assessment Score Sheet'!AC47","v":0},{"$f":"'Self Assessment Score Sheet'!AD47","v":0}]
["Controlling / Mitigating business risks",{"$f":"4*8","v":32},{"$f":"'Self Assessment Score Sheet'!AB48","v":0},null,{"$f":"B14/2","v":16},{"$f":"'Self Assessment Score Sheet'!AC48","v":0},{"$f":"'Self Assessment Score Sheet'!AD48","v":0}]
["Analysing data and identifying corrective actions",{"$f":"2*8","v":16},{"$f":"'Self Assessment Score Sheet'!AB49","v":0},null,8,{"$f":"'Self Assessment Score Sheet'!AC49","v":0},{"$f":"'Self Assessment Score Sheet'!AD49","v":0}]