{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tester Guidelines","Driver Test"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"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":"Tester Guidelines","index":0,"n_rows":38,"n_cols":13,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,0,28,13],[19,0,19,13],[17,0,17,13],[20,0,20,13],[18,0,18,13],[21,9,21,11],[27,0,27,8],[26,0,26,13],[23,9,23,11],[21,0,21,8],[23,0,23,8],[22,0,22,13],[0,0,0,5],[0,6,1,13],[1,0,1,2],[1,3,1,5],[16,0,16,13],[5,0,5,13],[6,0,6,13],[15,0,15,13],[4,0,4,13],[10,0,10,13],[2,0,2,13],[3,0,3,13],[8,0,8,13],[13,0,13,13],[9,0,9,13],[11,0,11,13],[37,0,37,13],[39,0,39,13],[36,0,36,13],[34,0,34,13],[7,9,7,13],[7,0,7,8],[12,0,12,13],[14,0,14,13],[29,9,29,11],[31,9,31,11],[29,0,29,8],[31,0,31,8],[24,0,24,13],[25,9,25,11],[27,9,27,11],[25,0,25,8],[35,10,35,11],[30,0,30,13],[32,0,32,13],[33,9,33,11],[35,0,35,9],[33,0,33,8]]}
["DRIVER TEST SCORECARD",null,null,null,null,null,"Please contact me at the e-mail address to the left if you have problems with this workbook.  The Excel workbooks and worksheets I design are protected, but no passwords are assigned.  This avoids inadvertent deletion of formulas and links, but allows users to modify worksheets as necessary.  To unprotect a worksheet, click \"Tools / Protection / Unprotect Sheet\".  I recommend that once any given sheet is modified the user reprotect the sheet by clicking \"Tools / Protection / Protect Sheet\".  Do not enter a password when reprotecting the worksheet."]
["Workbook created in 2006 by: ",null,null,"Dave Coddington\nEmergency Operations TA\nEmergency Response Team\nNairobi, Kenya\ndcoddington@earo.crs.org"]
["Macros and Formulas"]
["This file contains Macros written in Visual Basic (VBA) code and complex formulas.  It automatically calculates driving scores through various links and macro commands.  In order for the macros to work properly, your computer's security settings must be set to medium or low (medium is recommended).  Click \"Tools / Macro / Security\" and select either the Medium or Low option.\nIf the High Security option is selected: the macros will not work.\nIf the Medium Security option is selected: each time you open files that contain VBA macros, you will be asked if you want to enable or disable them.\nIf the Low Security option is selected: the macros will work and you will not receive any warning messages.  However, this may put your computer at risk from macros in programs imported from unknown sources and is therefore NOT recommended."]
["Use of the Testing Form"]
["This form may be printed out for manual use, or used electronically to enter and calculate scores from driving tests administered in the field, and to document the files.  All individuals who seek to drive CRS vehicles must pass this series of tests.  Basic guidelines are as follows:"]
["Driving tests should be conducted in a comprehensive manner, i.e., they should be carried out at several times and at various locations.  At least two (2) and preferably three (3) separate tests should be conducted by different CRS staff members, including at least one (1) senior manager.  All testers should fill out this scorecard as a basis for justifying the hiring of a professional Driver or authorizing a staff member to drive CRS vehicles.  Once completed, all forms should be compared to determine the driver's overall skill level and make a decision to hire and authorize to drive, or determine that additional training is required."]
["              TEST 1 assess the driver's basic abilities and driving under city conditions.\n              TEST 2 gauges the driver's abilities under highway conditions.  This \n                              can be done on a trip to the field with CRS staff.\n              TEST 3 validates the driver's abilities under off-road conditions.  This can also be \n                              done on a trip to the field with CRS staff.",null,null,null,null,null,null,null,null,"EACH TEST MUST BE CARRIED OUT AND SCORED BY A DIFFERENT STAFF MEMBER OR GROUP OF STAFF."]
["Under normal circumstances, CRS should only hire Drivers who consistently score EXCELLENT on all tests.  In emergency situations, where demand for drivers is high and the pool of candidates is limited, senior managers may decide to also hire Drivers who score GOOD."]
["CRS staff who wish to drive CRS vehicles must score EXCELLENT or GOOD on all driving tests to receive authorization."]
["The sections of the scorecard may be weighted from 0 - 3 with 3 representing high importance.  Abilities driving the vehicle (sections 5-8) should normally be weighted more heavily than abilities to perform tasks when not moving (section 2-4 and 9); good driving skills are hard to teach or modify, but other tasks and responsibilities can be taught.  The weights can and should be modified by the tester (see General Guidance below)."]
["Place copies of all scorecards in the driver's file (photocopies in the Transportation Office, and the originals in Administration/HR)."]
["General Guidance:"]
["Call and verify the references for each Driver candidate: do not assume that because the candidate provided references they must be positive.  If certificates of service are submitted with an application, call the company / organization to verify past performance."]
["Assign weights for each section below: from 0-3.  Depending on the type of test to be given, the test sections listed below will vary in importance and must be weighted as such.  The more important the testing area, the higher the weight.  If no testing of the specific section will be done, enter zero (0).  For example, if the test will be conducted for city driving only, enter a weight of \"0\" in section 8 (Off-Road Driving)."]
["Print out a copy of this worksheet and the scorecard: prior to each test.  Enter manually all relevant information from the top of the form  through section 1."]
["Tester's should review this guidance prior to conducting the test: and refer to it as necessary during the test."]
["Explain the test to the Driver candidate or CRS staff member: CRS is looking for good performance, and is not trying to trick anyone.  A poor driver will not be able to hide inability even if the testing protocols are known."]
["Provide and explain all tools the Driver would normally be expected to use: such as Vehicle Logs and the Daily Inspection Checklist.  The goal is to verify, for example, that the operator can easily understand and use the Vehicle Inspection Checklist and Vehicle Log."]
["Enter scores (3 = Excellent, 2 = Good, 1 = Passable, and 0 or blank = Poor) into the relevant cells under SCORE in each section of the Test Sheet: upon return from the driving test, enter the information electronically, then print out and sign the form.  The overall rating will calculate automatically in the cells on row 93."]
["Guidance on Sections:  assign weights to each section as appropriate (from 0 to 3)"]
["Section 2 - Driver's Language Skills: ",null,null,null,null,null,null,null,null,"Weight Assigned:",null,null,1]
["The working language is that most often used in the office (e.g., English, French, Spanish, Portuguese).  Other languages include local languages, or national languages (e.g., Bahasa, Swahili, Lingala)."]
["Sections 3 - Vehicle Pre-Start Inspection - est. 15-20 minutes:",null,null,null,null,null,null,null,null,"Weight Assigned:",null,null,2]
["Give the candidate a copy of the Vehicle Daily Inspection Checklist, and observe ability to conduct the inspection.  The candidate should, for example:\n\n   check engine oil, radiator fluid, battery water, brake and other fluid levels;\n   clearly identify damage to or potential problems with the vehicle;\n   verify tire pressure and tire tread conditions;\n   inspect the spare tire, making sure it is inflated and securely attached;\n   look underneath the vehicle to locate any leaking fluids;\n   clearly identify the main engine elements (e.g., where to add oil, fill the radiator, battery water, brake fluid, windshield wiper fluid, etc)."]
["Section 4 - Knowledge of Vehicle Equipment - est. 10 minutes:",null,null,null,null,null,null,null,null,"Weight Assigned:",null,null,2]
["Test to see if the driver can identify the various control and monitoring elements of the vehicle such as the speedometer, odometer, tachometer, \"idiot lights,\" jack and equipment to change tire, winch, first aid kit, etc.  Have the driver set up the jack and change a tire in the parking lot."]
["Section 5 - Starting Vehicle and Leaving Parking Lot: ",null,null,null,null,null,null,null,null,"Weight Assigned:",null,null,3]
["  Observe driver behavior while preparing to start the vehicle, starting the vehicle and beginning to move inside the parking area.\n\n   Does the driver adjust his / her seat and mirrors prior to starting the vehicle? \n   Is his / her seat belt buckled prior to starting? Does s/he ensure passenger seat belts are buckled?\n   Does s/he pre-heat the engine every time it is started (whether warmed up or not)?\n   Does s/he verify the surrounding area prior to putting the vehicle in gear?\n   Does s/he engage the gears smoothly?\n   Does the driver disengage the hand brake prior to moving?  keep his/her foot on the brakes until ready to move?\n   Does s/he maneuver carefully within the parking area?"]
["Sections 6 - Maneuvering and Driving Techniques - est. 30-45 minutes:",null,null,null,null,null,null,null,null,"Weight Assigned:",null,null,3]
["See guidance in Section 7 below (sections 6 and 7 will be assessed simultaneously)."]
["Sections 7 - Defensive Driving and Road Safety Consciousness:",null,null,null,null,null,null,null,null,"Weight Assigned:",null,null,3]
["The tester will need to spend adequate time with the candidate to monitor and evaluate driving skills and competencies.  It is important to take the candidate through a variety of situations that can indicate skill level, abilities and behavior.  Have the candidate drive near a school area (to gauge reactions around child pedestrians).  Go into a congested area.  Drive on major and secondary roads in the city limits.  Ask the driver to travel to a specific but well known location (e.g., UN building or the airport) to see how routes are determined.  Question the candidate about route selection to judge decision-making skills.\n\n   Is the driver aware of his/her surroundings? potential obstacles or problems?\n   Is the driver respectful of other road users, particularly pedestrians and 2-wheel users?\n   Can the driver maneuver easily in traffic?  does s/he use the mirrors?  how are lane changes performed?\n   Does the driver ride the clutch or brakes? drive with only one hand?\n   Is the ride smooth or rough?  what speeds are maintained?  how does the driver accelerate and brake?\n   Is an appropriate distance maintained between vehicles?  does the driver tailgate?\n   How is the driver's passing / overtaking technique? does s/he cut people off?\n   Are the rules of the road and speed limits obeyed?  does the driver come to a complete stop at stop signs?\n   Does the driver use turn signals?  does s/he know the international driver hand signals?"]
["Section 8 - Driving Off-Road (4WD) - est. 30-45 minutes:",null,null,null,null,null,null,null,null,"Weight Assigned:",null,null,3]
["Find a road nearby with terrain conditions that are not extremely rough.  If possible, find a dirt road with some sand, bumps, small rocks, pot holes, etc. to check whether s/he slows down and is aware of obstacles, and how they are handled.\n\n  Is the driver aware of obstacles and dangers? does s/he avoid obstacles?\n  How is the rate of speed? does s/he drive cautiously and with respect?\n  Can the driver easily control the vehicle?\n  Can the driver put the vehicle into 4WD (e.g., lock the hubs, shift into 4W low an 4W high)? take it out of 4WD?\n  Can s/he explain the uses of 4W low and 4W high.\n  Can s/he explain operation of the winch?"]
["Section 9 - Post-Drive Action and Tester Considerations - est. 10 minutes:",null,null,null,null,null,null,null,null,null,"Weight Assigned:",null,2]
["Observe and rate the actions of the driver when entering the parking lot, parking, setting the hand brake (leaving vehicle in gear), turning off the engine and removing keys, filling out the log, rolling up windows, setting the Multi-Lock, and locking all doors.  Go over the Scoresheet with the driver so there are no surprises later on.  Inform the driver of the comfort felt during the drive."]
["Section 10 - Tester Recommendations (not weighted): the tester shall provide his / her recommendation on whether or not a Driver candidate should be hired or if a staff member should be approved to drive CRS vehicles.  This is a subjective opinion.  Mark the appropriate cell with an \"X.\""]

{"sheet":"Driver Test","index":1,"n_rows":96,"n_cols":27,"rows_kept":96,"cut":false,"hidden":false,"merged":[[92,5,92,10],[94,0,95,2],[94,11,95,12],[95,3,95,10],[95,13,95,29],[39,0,69,1],[56,2,62,2],[47,2,53,2],[39,2,44,2],[47,13,47,14],[41,13,41,14],[43,13,43,14],[44,4,44,10],[44,13,44,14],[58,4,58,10],[56,4,56,10],[56,13,56,14],[56,11,62,12],[59,4,59,10],[62,4,62,10],[60,13,60,14],[73,4,73,10],[73,13,73,14],[66,13,66,14],[23,0,35,1],[93,13,93,25],[90,11,90,25],[87,0,87,29],[89,0,90,2],[91,0,91,12],[92,0,92,2],[89,20,89,29],[85,2,85,29],[73,0,83,1],[34,2,36,2],[25,2,25,29],[37,2,37,29],[27,2,31,2],[29,13,29,14],[29,4,29,10],[33,3,33,10],[33,13,33,15],[34,4,34,10],[36,4,36,10],[23,2,24,2],[38,3,38,10],[38,13,38,15],[55,16,55,18],[0,2,0,3],[0,4,0,10],[0,11,0,14],[2,2,2,29],[0,22,0,24],[0,25,0,29],[1,0,1,29],[23,15,24,18],[20,13,20,18],[24,4,24,10],[22,20,24,29],[24,13,24,14],[22,13,22,15],[22,16,22,18],[22,3,22,10],[23,4,23,10],[23,13,23,14],[23,11,24,12],[4,21,4,24],[4,25,4,29],[4,4,4,10],[5,2,6,4],[4,2,4,3],[4,11,4,14],[6,5,6,10],[20,2,20,10],[20,20,20,29],[21,1,21,29],[6,11,6,14],[11,2,11,29],[6,15,6,20],[6,21,6,24],[6,25,6,29],[10,0,10,29],[9,2,9,29],[7,2,7,29],[8,0,8,29],[12,0,12,29],[17,0,17,29],[13,11,16,11],[13,12,13,29],[13,3,13,10],[14,4,14,10],[15,4,15,10],[18,2,18,29],[14,12,14,29],[15,12,15,29],[16,12,16,29],[16,4,16,10],[47,11,53,12],[47,15,53,18],[48,4,48,10],[51,13,51,14],[19,0,19,29],[38,16,38,18],[33,16,33,18],[34,11,36,12],[33,20,36,29],[34,13,34,14],[36,13,36,14],[38,19,44,19],[40,13,40,14],[26,3,26,10],[26,13,26,15],[30,4,30,10],[28,4,28,10],[30,13,30,14],[31,13,31,14],[42,4,42,10],[42,13,42,14],[41,4,41,10],[40,4,40,10],[0,15,0,20],[4,15,4,20],[46,3,46,10],[46,13,46,15],[46,16,46,18],[46,20,53,29],[47,4,47,10],[48,13,48,14],[43,4,43,10],[3,0,3,29],[35,4,35,10],[35,13,35,14],[49,4,49,10],[26,19,31,19],[33,19,36,19],[26,16,26,18],[27,13,27,14],[28,13,28,14],[27,4,27,10],[31,4,31,10],[49,13,49,14],[26,20,31,29],[39,11,44,12],[39,15,44,18],[91,16,91,18],[88,13,88,14],[83,4,83,10],[81,4,81,10],[57,13,57,14],[58,13,58,14],[62,13,62,14],[64,19,70,19],[70,4,70,10],[70,13,70,14],[68,4,68,10],[69,4,69,10],[67,13,67,14],[65,4,65,10],[64,16,64,18],[69,13,69,14],[67,4,67,10],[68,13,68,14],[64,3,64,10],[64,13,64,15],[61,4,61,10],[94,13,94,29],[94,3,94,10],[72,20,76,29],[72,3,72,10],[72,13,72,15],[92,13,92,15],[92,19,92,22],[92,23,92,25],[92,16,92,18],[80,13,80,14],[83,13,83,14],[82,13,82,14],[91,13,91,15],[86,2,86,29],[81,13,81,14],[91,26,93,29],[91,19,91,22],[91,23,91,25],[89,16,89,18],[84,4,84,10],[82,4,82,10],[84,13,84,14],[73,15,76,18],[89,8,90,10],[50,4,50,10],[51,4,51,10],[52,4,52,10],[52,13,52,14],[53,4,53,10],[53,13,53,14],[57,4,57,10],[75,4,75,10],[50,13,50,14],[74,4,74,10],[55,3,55,10],[55,13,55,15],[65,13,65,14],[66,4,66,10],[60,4,60,10],[61,13,61,14],[65,11,70,12],[65,15,70,18],[71,2,71,29],[65,2,70,2],[55,20,62,29],[64,20,70,29],[56,15,62,18],[55,19,62,19],[32,2,32,29],[34,15,36,18],[38,20,44,29],[39,4,39,10],[39,13,39,14],[59,13,59,14],[79,13,79,14],[77,2,77,29],[73,2,76,2],[79,2,84,2],[72,19,76,19],[76,13,76,14],[74,13,74,14],[76,4,76,10],[72,16,72,18],[75,13,75,14],[78,20,84,29],[79,4,79,10],[73,11,76,12],[78,13,78,19],[78,11,84,12],[79,15,84,19],[78,3,78,10],[80,4,80,10]]}
[null,null,"TESTER:",null,null,null,null,null,null,null,null,"TESTING DATE:",null,null,null,null,null,null,null,null,null,null,"LOCATION:"]
[]
[null,null,"CANDIDATE / STAFF DETAILS"]
[]
[null,null,"NAME:",null,null,null,null,null,null,null,null,"DATE OF BIRTH:",null,null,null,null,null,null,null,null,null,"PLACE OF BIRTH:"]
[null,null,"DRIVER LICENSE No.:"]
[null,null,null,null,null,null,null,null,null,null,null,"ISSUE DATE:",null,null,null,null,null,null,null,null,null,"EXPIRATION DATE:"]
[null,null,"Attach copy of driver licenses to this scoresheet;  file documents in Driver's dossier (copies in Transportation Office & Administration / HR Office)."]
[]
[]
[]
[null,null,"CANDIDATE PROFILE"]
[]
[null,null,"1.","DRIVING EXPERIENCE"]
[null,null,null,"1.1","Years of driving experience / fines or arrests"]
[null,null,null,"1.2","Make & models of vehicles driven"]
[null,null,null,"1.3","Mechanical training & experience"]
[]
[null,null,"GENERAL APTITUDE, MECHANICAL KNOWLEDGE AND DRIVING SKILLS"]
[]
[null,null,"TESTING / EVALUATION CRITERIA",null,null,null,null,null,null,null,null,"WEIGHT",null,"EXCELLENT (enter  3)\nGOOD (enter 2)\nPASSABLE (enter 1)\nPOOR (enter 0)",null,null,null,null,null,null,"COMMENTS & REMARKS"]
[]
[null,null,"2.","LANGUAGE SKILLS",null,null,null,null,null,null,null,{"$f":"'Tester Guidelines'!$M$22","v":1},null,"SCORE:",null,null,{"$f":"IF(N24+N25=0,0,(N24+N25)*L23)","v":0}]
["BEFORE DRIVING",null,null,"2.1","Working language (specify): "]
[null,null,null,"2.2","Others (specify): "]
[]
[null,null,"3.","VEHICLE PRE-START INSPECTION",null,null,null,null,null,null,null,{"$f":"'Tester Guidelines'!$M$24","v":2},null,"SCORE:",null,null,{"$f":"IF(SUM(N28:N32)=0,0,SUM(N28:N32)*L27)","v":0}]
[null,null,null,"3.1","Verifies damage to and cleanliness of vehicle"]
[null,null,null,"3.2","Verifies tools, lug wrench, spare tire, jack"]
[null,null,null,"3.3","Checks wheels, tires, lugs, and lights"]
[null,null,null,"3.4","Looks under vehicle for fluid leaks"]
[null,null,null,"3.5","Checks engine oil & other engine elements"]
[]
[null,null,"4.","KNOWLEDGE OF VEHICLE EQUIPMENT",null,null,null,null,null,null,null,{"$f":"'Tester Guidelines'!$M$26","v":2},null,"SCORE:",null,null,{"$f":"IF(SUM(N35:N37)=0,0,SUM(N35:N37)*L34)","v":0}]
[null,null,null,"4.1","Identifies odometer, tach, other instruments"]
[null,null,null,"4.2","Locates & sets up jack / changes tire"]
[null,null,null,"4.3","Knowledge of basic first aid"]
[]
[null,null,"5.","STARTING VEHICLE & LEAVING PARKING LOT",null,null,null,null,null,null,null,{"$f":"'Tester Guidelines'!$M$28","v":3},null,"SCORE:",null,null,{"$f":"IF(SUM(N40:N45)=0,0,SUM(N40:N45)*L39)","v":0}]
["DRIVING",null,null,"5.1","Checks instruments / interior before starting engine"]
[null,null,null,"5.2","Preheats engine"]
[null,null,null,"5.3","Buckles seat belt / verifies passenger seat belts"]
[null,null,null,"5.4","Checks mirrors before moving / hand brake release"]
[null,null,null,"5.5","Shifts gears smoothly"]
[null,null,null,"5.6","Drives well within & while exiting parking lot"]
[]
[null,null,"6.","MANEUVERING / DRIVING TECHNIQUES",null,null,null,null,null,null,null,{"$f":"'Tester Guidelines'!$M$30","v":3},null,"SCORE:",null,null,{"$f":"IF(SUM(N48:N54)=0,0,SUM(N48:N54)*L47)","v":0}]
[null,null,null,"6.1","Signals before making turns / turns smoothly"]
[null,null,null,"6.2","Stops & starts appropriately (\"eco-driving\")"]
[null,null,null,"6.3","Shifts gears smoothly / uses appropriate gears"]
[null,null,null,"6.4","Doesn't ride clutch or brakes"]
[null,null,null,"6.5","Obeys speed limits & traffic rules"]
[null,null,null,"6.6","Operates headlights & wipers while moving"]
[null,null,null,"6.7","Parks correctly (drive-in and parallel)"]
[]
[null,null,"7.","DEFENSIVE DRIVING / ROAD SAFETY CONSCIOUSNESS",null,null,null,null,null,null,null,{"$f":"'Tester Guidelines'!$M$32","v":3},null,"SCORE:",null,null,{"$f":"IF(SUM(N57:N63)=0,0,SUM(N57:N63)*L56)","v":0}]
[null,null,null,"7.1","Is aware of and considerate of other vehicles"]
[null,null,null,"7.2","Identifies & avoids potential hazards"]
[null,null,null,"7.3","Passes vehicles & bicycles with care"]
[null,null,null,"7.4","Uses mirrors effectively"]
[null,null,null,"7.5","Is aware and considerate of pedestrians & animals"]
[null,null,null,"7.6","Keeps within lane / uses appropriate lanes"]
[null,null,null,"7.7","Doesn't tailgate / maintains appropriate distance"]
[]
[null,null,"8.","DRIVING OFF-ROAD (4WD)",null,null,null,null,null,null,null,{"$f":"'Tester Guidelines'!$M$34","v":3},null,"SCORE:",null,null,{"$f":"IF(SUM(N66:N71)=0,0,SUM(N66:N71)*L65)","v":0}]
[null,null,null,"8.1","Drives at an appropriate speed"]
[null,null,null,"8.2","Identifies & avoids potential hazards & obstacles"]
[null,null,null,"8.3","Aware and considerate of pedestrians & animals"]
[null,null,null,"8.4","Can lock & unlock vehicle hubs"]
[null,null,null,"8.5","Places vehicle in 4WD & back to 2WD"]
[null,null,null,"8.6","Uses appropriate gears & speeds while in 4WD"]
[]
[null,null,"9.","POST DRIVE ACTIONS / TESTER CONSIDERATIONS",null,null,null,null,null,null,null,{"$f":"'Tester Guidelines'!$M$36","v":2},null,"SCORE:",null,null,{"$f":"IF(SUM(N74:N77)=0,0,SUM(N74:N77)*L73)","v":0}]
["POST DRIVING",null,null,"9.1","Enters parking lot, parks with care, leaves vehicle in gear"]
[null,null,null,"9.2","Sets hand brake, turns off lights and other equipment"]
[null,null,null,"9.3","Fills out vehicle log, locks Multi-Lock & doors"]
[null,null,null,"9.4","Tester feels safe & comfortable with driver"]
[]
[null,null,"10.","TESTER RECOMMENDATIONS"]
[null,null,null,"10.1","Hire as Driver"]
[null,null,null,"10.2","Hire as Head Driver"]
[null,null,null,"10.3","Hire as Driver / Mechanic"]
[null,null,null,"10.4","Do not hire"]
[null,null,null,"10.5","Authorize staff to drive CRS vehicles"]
[null,null,null,"10.6","Do not authorize staff to drive CRS vehicles"]
[]
[null,null,"PERFORMANCE AND SCORING"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(3*((L23*ROWS(N24:O25))+(L27*ROWS(N28:O32))+(L34*ROWS(N35:O37))+(L39*ROWS(N40:O45))+(L47*ROWS(N48:O54))+(L56*ROWS(N57:O63))+(L65*ROWS(N66:O71))+(L73*ROWS(N74:O77))))","v":312}]
[null,null,null,null,null,null,null,null,"TOTAL SCORE:",null,null,null,null,null,null,null,{"$f":"Q23+Q27+Q34+Q39+Q47+Q56+Q65+Q73","v":0},null,null,null,{"$f":"\"Maximum score is \"&N89","v":"Maximum score is 312"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Excellent\n(\"&(ROUNDUP((N89*0.75)+1,0))& \" - \"&N89&\")\"","v":"Excellent\n(235 - 312)"},null,null,{"$f":"\"Good\n(\"&ROUND((N89*0.5)+1,0)& \" - \"&ROUNDUP(((N89*0.75)),0)&\")\"","v":"Good\n(157 - 234)"},null,null,{"$f":"\"Passable\n(\"&ROUND((N89*0.25)+1,0)& \" - \"&ROUNDUP(((N89*0.5)),0)&\")\"","v":"Passable\n(79 - 156)"},null,null,null,{"$f":"\"Poor\n(0 - \"&ROUNDUP(((N89*0.25)),0)&\")\"","v":"Poor\n(0 - 78)"},null,null,"* See criteria for hiring below"]
[null,null,null,null,null,"OVERALL PERFORMANCE RATING:",null,null,null,null,null,null,null,{"$f":"IF(Q90>(N89*0.75),\"X X\",0)","v":0},null,null,{"$f":"IF(AND(Q90<=((N89*0.75)),Q90>N89*0.5),\"X X\",0)","v":0},null,null,{"$f":"IF(AND(Q90<=(((N89*0.5))),Q90>(N89*0.25)),\"X X\",0)","v":0},null,null,null,{"$f":"IF(Q90=0,0,(IF(Q90<=(((N89*0.25))),\"X X\",0)))","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"* Driver candidates rated Excellent and Good may be hired; Drivers rated Passable may be hired provisionally under special circumstances but shall be trained and re-tested prior to approving them for field responsibilities.  Staff may be approved to drive if a score of Excellent or Good is achieved."]
[null,null,null,"SIGNATURE - TESTER"]