{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Audit Form","SCAR","vehicle checksheet level 1","vehicle checksheet level 2","vehicle checksheet level 3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":3,"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":"Audit Form","index":0,"n_rows":199,"n_cols":14,"rows_kept":199,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
["Company",null,null,null,null,"Explanatory note:"]
["Location",null,null,null,null,"Please note that all relevant requirements must be adhered to, to successfully obtain a TSR 2014 certification. "]
["Contact Name",null,null,null,null,"The following three options are available when conducting your audit  "]
["AUDITOR(s)"]
["Audit Date",null,null,null,null,"Yes = Requirements fully in place with no discrepancies"]
["Phone No.",null,null,null,null,"No = Not all the Requirements in place and does not meet the requirements"]
["Fax No.",null,null,null,null,"Not Applicable (N/A) = this can be due to either the option choice or based on the risk assessment"]
["Email"]
["Certification ",null,null,null,null,"In all cases evidence must be shown or given especially if considering a N/A item or requesting a Waiver "]
["Result"]
[]
[]
[]
[]
[null,"TAPA TSR 2014 POLICY AND PROTOCOLS REQUIRED FOR ALL 3 LEVELS",null,null,null,null,null,null,null,null,null,null,"Yes","PASS: Meets or Exceeds Overall Requirements"]
["SECTION A"," 'MANAGEMENT SUPPORT AND RESPONSIBILITIES' PROTOCOLS","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation",null,null,null,null,null,"No","FAIL: Does not meet Overall Requirements"]
["A.1","Security Management",null,null,null,null,null,null,null,null,null,null,"Not Applicable"]
[null,"The LSP (Logistics Service Provider) must have a formally appointed person responsible for supply chain security who is also responsible for monitoring the TSR programme.","P","P","P"]
["A.2","Security Policy"]
[null,"The LSP must have a written corporate supply chain security policy (Security Policy) in place and adopted by management","P","P","P"]
["A.3","Security Procedures"]
[null,"Specific procedures for the handling of high value theft targeted (HVTT) cargo must be in place, and in alignment with TSR procedures","P","P","P"]
["A.4","Sub contracting"]
[null,"The specific HVTT and TSR procedures are also applicable to the LSP's subcontractors and must be reflected in a formal agreement between all parties. ","P","P","P"]
["A.5","Investigations"]
[null,"The LSP must document a written and implemented policy, which is shared with Buyers, for ensuring that all freight losses are investigated.  This shall include, but not be limited to, notifying Buyer of losses and starting investigations on losses where theft is suspected or known to be the cause within 24 hours.  The Buyer, or appointed agent, will receive full cooperation in the investigation.","P","P","P"]
["A.6","LEA contacts"]
[null,"The LSP must maintain a listing of critical law enforcement (LEA) contacts within its routes and must document a procedure, both for its main office and for drivers, for how to contact and coordinate with law enforcement when a theft event occurs.  ","P","P","P"]
["A.7","Collection and Delivery Records"]
[null,"The LSP must maintain records of all collections and proof of deliveries, for a period of not less than two years that can be accessed when investigation of loss is necessary.  ","P","P","P"]
["A.8","Risk Analyses"]
[null,"The LSP must have a programme in place to perform security risk analyses of routes and stops at least once a year, to assure that the safest routes are chosen to minimize passage and stops, in areas at high risk for crime, for cargo carried under the TSR requirements.   This information must be provided to the Buyer if requested. ","P","P","P"]
["A.9","Secure locations to park"]
[null,"The LSP must have a policy in place to identify and implement the use of secure locations for parking as specified in TSR 1, 2 and 3","P","P","P"]
["SECTION B ","VETTING AND TERMINATION PROTOCOLS","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
["B.1","Screening/vetting own employees"]
[null,"Applicants required to disclose previous employment history, gaps in employment, criminal convictions, job terminations in similar/same industry, job related qualifications. (within constraints of local law) ","P","P","P"]
[null,"Procedure for dealing with applicant/employee's false declaration pre & post hiring. ","P","P","P"]
[null,"The procedure must identify the person / resources responsible for conducting the vetting / screening process, which includes, but is not limited to, criminal history and employment checks and verification of information provided by the applicant.","P","P","P"]
[null,"Denial criteria must be documented. Procedures shall be within constraints of local law","P","P","P"]
["B.2","Screening/vetting  (TAS) Temporary Agency Staff  "]
[null,"The LSP will have agreements in place to have the required vetting/ screening information supplied by the agency and/or subcontractor providing TAS workers, or shall conduct such screening themselves. The vetting/ screening must cover criminal history and employment checks of each TAS worker.","P","P","P"]
[null,"TAS worker required to sign declaration that they have no current criminal convictions or pending cases and will comply with the LSP's security procedures","P","P","P"]
[null,"Procedure for dealing with TAS worker's false declaration. ","P","P","P"]
[null,"TAS worker denial criteria documented. Procedures shall be within constraints of local law","P","P","P"]
["B.3","Termination of Workforce "]
[null,"The LSP has robust documented procedures in place for termination of workforce. Termination procedures for workforce to include return of ID's, access cards, keys and other sensitive information and/or equipment.","P","P","P"]
["B.4","Protection of Buyer's data and records"]
[null,"Procedures are in place to prevent terminated workforce from having access to Buyer's data and records.  ","P","P","P"]
["B.5","Procedures for re-hiring of Workforce"]
[null,"Procedures are in place to prevent LSP from re-hiring any person if denial/termination criteria are still valid.  ","P","P","P"]
["B.6","Timing of Protocols"]
[null,"Hiring and termination procedures are audited, at least annually, and gaps addressed.  ","P","P","P"]
["SECTION C ","TRAINING PROTOCOLS","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
["C.1","Security Training "]
[null,"The LSP must have a programme in place to train their workforce in security which, as a minimum, shall include threat awareness , robbery response, vehicle checking, recognition of developing threats, use of secure parking, appropriate responses to threatening events and  communication with police and management","P","P","P"]
["C.2","Monitoring Centre Staff Training"]
[null,"The LSP must have a programme in place for staff to include training, appropriate use of tracking devices and other security equipment, and alarm protocols as mentioned in section D","P","P","P"]
[null,"OR"]
[null,"have a contract in place with a recognized service provider requiring same","P","P","P"]
["SECTION D","TRACKING AND TRACING PROTOCOLS","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
["D.1","Response to alerts and systems failure"]
[null,"Response protocols for alerts must be reviewed at least annually and contact details kept current. Protocols must include specific responses, including protocols for responding to tracking system failure","P","P","P"]
["D.2","Response protocols"]
[null,"Response protocols must include communications with law enforcement, advice for driver, allocations of resources to the site of the event as needed, and protection of any cargo that remains and is vulnerable.","P","P","P"]
["SECTION E","ON ROUTE  PROTOCOLS","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
["E.1","Escalation procedures"]
[null,"The LSP must have documented procedures in place to protect HVTT cargo in case of security incidents, driver illness, vehicle breakdown, strikes, detours, accidents, bad weather or refusal to accept delivery.","P","P","P"]
[]
[null,"TAPA TSR 2014 REQUIREMENTS PRACTICE LEVEL "]
["SECTION 1","1 PHYSICAL SECURITY","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[1.1000000000000001,"Truck Security"]
["1.1.1","Driver procedures require that truck doors are locked during transit","P","P","P"]
["1.1.2","Truck door keys restricted to driver and carrier management ","P","P","P"]
["1.1.3","Auditory alarm if unauthorized entry to tractor cab occurs ","P"]
[1.2,"Trailer Security"]
["1.2.1","High quality stainless steel security locking devices such as built-in locks OR mobile heavy weight locking devices with integral locks fixed to all truck/trailer doors (no chains, cables, light-weight bars, removable bolts, etc.) and utilized during the entire journey. Locks can be electronically or manually operated, must be unique and must be designed to resist defeat for not less than ten minutes with hand tools.","P"]
["1.2.2","High quality stainless steel security locks either firmly fixed to all truck/trailer doors OR use of high quality chains, bars, padlocks etc. and utilized during the entire journey. Locks can be electronically or manually operated, must be unique and must be designed to resist defeat with hand tools. ",null,"P"]
["1.2.3","Doors secured in line with LSP's own internal policy ",null,null,"P"]
["1.2.4","Only hard sided trailers utilized","P","P"]
["1.2.5","Soft sided trailers as a minimum ",null,null,"P"]
["1.2.6","Tamper evident security seals for FTL (full truckload and indicates that the cargo is dedicated for one Buyer) electronic or manual that meet the ISO 17712 standard","P","P"]
["1.2.7","Trailer immobilization device in place when trailer is dropped (kingpin, landing gear lock or brake line lock)",null,"P","P"]
["SECTION 2","2 TRACKING TECHNOLOGY","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[2.1,"Two Way Communication Systems"]
["2.1.1","Two way communication system present during entire journey ","P","P","P"]
["2.1.2","Two way communication system monitored 24/7 by carrier's office or 3rd party monitoring centre","P","P"]
[2.2000000000000002,"Tracking And Tracing Systems"]
["2.2.1","Carrier must have detailed and documented protocol in place to track trailers and tractors, both tethered and as separate vehicles, including 24/7 monitoring, the ability to geofence routes and parking locations and documented response protocols for handling emergencies","P"]
["2.2.2","Carrier must have detailed and documented protocol in place to track tractors, the ability to geofence routes and parking locations and documented response protocols for handling emergencies",null," P "]
["2.2.3","Carrier must have detailed and documented protocol in place to check, prior to departure, the function and battery life of all tracking devices to be utilized","P"]
["2.2.4","A tracking device must be installed in a covert location in the tractor and, where available, must be capable of utilizing at least two methods of signalling such as 3G, or SMS/GPRS using GSM or CDMA and must be equipped with at least one covert antenna.","P","      P"]
["2.2.5","A tracking device must be installed in a covert location in the trailer and, where available, must be capable of utilizing at least two methods of signalling such as 3G, or SMS/GPRS using GSM or CDMA and must be equipped with at least one covert antenna ","P"]
["2.2.6","Monitoring centre must be able to control, over the air, the \"reporting\" rate for devices in both tractor and trailer","P"]
["2.2.7","Standard \"reporting rate\" for tracking units in both the tractor and the trailer must be not less than one report every five minutes.  (Note:  If the tractor and trailer are tethered and an effective untethered alert system is in place, only one of the units must meet this \"reporting\" rate standard.) ","P"]
["2.2.8","Standard \"reporting rate\" for tracking unit in the tractor must be not less than one report every thirty minutes.         ",null," P"]
["2.2.9","The tracking devices in the trailer and the tractor must report events to include untethering (unhooking) of the trailer, device tampering, truck stoppage, tracker battery status and trailer door opening.       ","P"]
["2.2.10","The trailer and tractor tracking devices must be equipped with a battery back-up capable of maintaining the signalling capacity of the tracker for not less than 24 hours at a \"reporting\" rate of not less than one \"reporting\" every five minutes while the trailer is untethered.","P"]
["2.2.11","A tracking device is installed providing remotely stored archival information relating to the position of all FTL (full truckload, Supplier dedicated) trucks.",null,null,"P"]
[2.2999999999999998,"Satelite Navigation Systems (route planner)"]
[" 2.3.1"," Satellite navigation system installed (route planner) recognizing detours, traffic jams, etc. to avoid unnecessary stops or delays. Carrier's dispatch must confirm all route changes.","P","P","P"]
[2.4," Silent Alarm System"]
["2.4.1","Manually activated silent alarm (panic button) present in reach of driver and able to send signal to the LSP's home base or third party monitoring centre","P","P"]
["2.4.2","Procedures in place, tested and reviewed at least every six months, for responses to activation of silent alarm by driver.","P","P"]
[2.5," Trailer Door Alarms"]
["2.5.1","Unauthorized opening of trailer doors sends signal to monitoring centre","P"]
["2.5.2","Procedures in place, tested and reviewed at least every six months, for responses to activation of alarm signal indicating unauthorized opening of trailer doors","P"]
[2.6,"Tamper Alarms"]
["2.6.1","The tracking system must alert if the tracking device fails or GPS signal is lost","P"]
["2.6.2","Procedures in place, tested and reviewed at least every six months, for responses to failure of tracking device.  ","P"]
[2.7,"Track And Trace Coverage"]
["2.7.1"," 2.7.1 - Coverage maps of the tracking technology to be utilized must be validated at least every six months to avoid or minimize travel through known \"black spots”","P"]
["2.7.2"," 2.7.2 - Coverage maps to be consulted and documented as part of route planning risk assessment","P"]
["2.7.3"," 2.7.3 - Route planners must develop responses to events which occur within \"black spots”","P"]
["SECTION 3","3 SECURITY PROCEDURES","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[3.1,"Scheduled Routing"]
["3.1.1","The LSP has planned routes ","P","P","P"]
["3.1.2","The LSP has planned stops","P","P"]
["3.1.3","Ad Hoc changes to routes and stops or delays due to unexpected events reported, if requested, to Buyer","P"]
[3.2,"Vehicle Maintenance Programme"]
["3.2.1","Exceptions noted during the pre-departure check must be reported to LSP's home base and any delay or diversion resulting from the exceptions must be consistent with TSR standards. Procedures must be part of driver's manual/written instructions.  ","P","P","P"]
["3.2.2","The LSP must document vehicle maintenance programmes in accordance with manufacturer's specifications","P","P","P"]
[3.3,"Comfort breaks"]
["3.3.1","In case of an event requiring a non-scheduled stop, such as a medical emergency, accident or breakdown that requires that the driver leave the vehicle, driver must notify dispatch, lock all doors and engage all security devices.  The tracking monitoring centre must also be notified and the truck and/or shipment live monitored constantly until it is able to return to transit.  In case of an extended unplanned stop, the carrier must have a protocol in place to provide protection for the shipment.","P"]
["3.3.2","If driver must leave truck and trailer , all doors must be locked and alarms (where fitted) must be activated",null,"P","P"]
[3.4," Secure Parking"]
["3.4.1","Listed approved parking facilities, stopping places and prohibited parking/stopping places part of driver's manual/instructions","P","P","P"]
["3.4.2","Trucks in use under TSR 1 must never be left unattended unless at a pre-approved (with Buyer) defined secure parking area with fences, lights, guards, access control and CCTV. ","P"]
[3.5," Unauthorized Persons"]
["3.5.1","No unauthorized parties allowed in truck or trailer. The LSP must have policies and procedures in place to prevent unauthorized parties from being present in truck or trailer (like hitchhikers, friends, non-driving relatives, children, etc)","P","P","P"]
[3.6,"Management Of Security Equipment"]
["3.6.1","The LSP must have documented and implemented procedures in place for management and control of seals, trailer (container) door locks, pin locks, and other security equipment.","P","P","P"]
[3.7," Key Management"]
["3.7.1","The LSP must have documented and implemented procedures in place for the secure management of keys for trucks, pad-locks, kingpin locks etc.","P","P","P"]
[3.8,"Collection And Delivery Training"]
["3.8.1","The LSP to provide training on collection and delivery procedures for the drivers to prevent deception and fraud","P","P","P"]
[3.9,"Pre-Departure Checks Vehicle"]
["3.9.1","The LSP must document pre-departure checks that ensure road worthiness of the vehicle in accordance with local regulations. For LTL (multiple stops) routes, these checks are required only at first departure, or daily for multiple-day trips","P","P","P"]
["3.10","Pre-Departure Checks Driver"]
["3.10.1","The LSP must document procedures to assure provision of drivers and equipment capable of moving the load to its first scheduled stop without preventable interruption (e.g. fuel, meal stops, planned repairs, regulated driving times, etc)","P","P","P"]
[3.11,"TSR Vehicle Logs"]
["3.11.1","Vehicles to be utilized under the TSR must be listed in the LSP's TSR vehicle log. There is no specific format for the log, however, it must include at least the following information: Tractor identification information, trailer identification information, TSR level, date(s) of audits and self-assessments, any exceptions, corrections, date of correction","P","P","P"]
["SECTION 4","4 EMPLOYMENT CRITERIA","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[4.0999999999999996,"Screening/vetting own employees"]
["4.1.1","Applicants required to disclose previous employment history, gaps in employment, criminal convictions, job terminations in similar/same industry, job related qualifications. (within constraints of local law) ","P","P","P"]
["4.1.2","Procedure for dealing with applicant/employee's false declaration pre & post hiring. ","P","P","P"]
["4.1.3","The procedure must identify the person / resources responsible for conducting the vetting / screening process, which includes, but is not limited to, criminal history and employment checks and verification of information provided by the applicant.","P","P","P"]
["4.1.4","Denial criteria must be documented. Procedures shall be within constraints of local law","P","P","P"]
[4.2,"Screening/vetting  (TAS) Temporary Agency Staff  "]
["4.2.1","The LSP will have agreements in place to have the required vetting/ screening information supplied by the agency and/or subcontractor providing TAS workers, or shall conduct such screening themselves. The vetting/ screening must cover criminal history and employment checks of each TAS worker.","P","P","P"]
["4.2.2","TAS worker required to sign declaration that they have no current criminal convictions or pending cases and will comply with the LSP's security procedures","P","P","P"]
["4.2.3","Procedure for dealing with TAS worker's false declaration. ","P","P","P"]
["4.2.4","TAS worker denial criteria documented. Procedures shall be within constraints of local law","P","P","P"]
[4.3,"Termination of Workforce "]
["4.3.1","The LSP has robust documented procedures in place for termination of workforce. Termination procedures for workforce to include return of ID's, access cards, keys and other sensitive information and/or equipment.","P","P","P"]
[4.4000000000000004,"Protection of Buyer's data and records"]
["4.4.1","Procedures are in place to prevent terminated workforce from having access to Buyer's data and records.  ","P","P","P"]
[4.5,"Procedures for re-hiring of Workforce"]
["4.5.1","Procedures are in place to prevent LSP from re-hiring any person if denial/termination criteria are still valid.  ","P","P","P"]
[4.5999999999999996,"Timing of Protocols"]
["4.6.1","Hiring and termination procedures are audited, at least annually, and gaps addressed.  ","P","P","P"]
["SECTION 5","5 DRIVERS/SECURITY TRAINING","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[5.0999999999999996,"Security Training"]
["5.1.1","Security Threat Awareness training programme conducted annually with drivers and documented in driver records. This training, as a minimum, shall include threat awareness, robbery response, vehicle checking, recognition of developing threats, use of secure parking, appropriate responses to threatening events and communication with police and management.","P","P","P"]
["SECTION 6","6 FREIGHT HANDOVER PROCESS","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[6.1,"Box and pallet integrity verified upon receipt & delivery"]
["6.1.1","The LSP must have documented procedures verifying box and pallet counts before loading and after discharge.  Documentation verifying these procedures must be retained for not less than two years.  ","P","P","P"]
[6.2,"Proof of shipping and receiving records "]
["6.2.1","All cargo must be verified against shipping documents and manifests to ensure proper marking, weights, counts, and specific handling instructions (as applicable).","P","P","P"]
["6.2.2","Documents must be legible, complete and accurate, including (where appropriate) time, date, driver signature and printed name, signatures of shipping and receiving personnel, shipment details, and any special instructions.","P","P","P"]
["6.2.3","The LSP must maintain records of all collections and proofs of delivery for a period of not less than two years that can be accessed if investigation of loss is required.  ","P","P","P"]
[6.3,"Driver to be present for loading and unloading"]
["6.3.1","Unless prohibited by shipper or receiver policies, the LSP's policy must document that drivers must be present for loading and unloading to confirm piece count.  If shipper or receiver policies prohibit this practice, those policies must be available for audit","P","P","P"]
[6.4," Pre-alert in place"]
["6.4.1","Unless on Buyers exemption; pre-alert details must be agreed to by Buyer and LSP.  Suggested details include: departure time, expected arrival time, trucking company, driver name, licence plate details, shipment info (pc count, weight, bill-of-lading number, etc.) and trailer seal numbers","P"]
[6.5,"Pre-alert capability in place"]
["6.5.1","Pre-alert capability procedures must be in place and documented for both pick-up and delivery, and must include, at a minimum, planned departure time, expected arrival time, trucking company name, driver name, licence plate pulling unit, generic shipment description to include piece count, weight, and (for delivery), trailer seal numbers",null,"P","P"]
["SECTION 7","7 LSP SELF ASSESSMENT","Level 1","Level 2","Level 3","Requirements fully in place with no deficiencies?","Evidence Documentation"]
[7.1," Self-Assessment of vehicle before being added to the TSR Vehicle log"]
["7.1.1","The LSP must have documented evidence that all vehicles (trucks & trailers) in the TSR Vehicle LOG have been assessed and are meeting the requirements of the TAPA TSR 2014 (Section 7 - Specifications for TSR Certification or Recognition (Practice)","P","P","P"]
[7.2,"On Going Assessment to ensure compliance to the TSR section 7"]
["7.2.1","The LSP must have documented evidence that all subsequent self-assessments  by the carrier (fixed or rolling programme - covering all vehicle in the TSR Vehicle Log) are self re-assessed at least once every 12 months by the carrier and associated records retained for audit purposes.  ","P","P","P"]
["SECTION 8 OPTIONAL - NOT MANDATORY","BUYER OPTIONAL (NOT MANDATORY) CARGO TRACK AND TRACE REQUIREMENTS. These are Buyer requested and/or the LSP provided enhancements that can be incorporated into TSR 1-3 levels as an optional extra. This option does not exclude use of any mandatory requirements (sections 1-7) that are needed to meet TSR Certification requirements.” "]
[8.1,"Buyer Option for Portable Tracking of Cargo"]
["8.1.1","Portable Tracking Devices must be capable of sending tracking information to a monitoring centre"]
["8.1.2","A protocol must be in place to place the  Portable Tracking Device  and the device must be tested before leaving to assure its function and battery status"]
["8.1.3","The location of the Portable Tracking Device may be placed embedded in cargo or placed internally or externally on the trailer depending upon the type of cargo. A protocol must be in place to define this practice"]
["8.1.4","Portable Tracking Devices can be monitored \"live \" or \"alarm\" driven. Which option to utilize is to be decided between the Buyer or LSP."]
["8.1.5","The monitoring centre must demonstrate a comprehensive response protocol for any and all alerts generated by the Portable Tracking Device, including route deviations, unapproved or unexpected movement, loss of signal due to location or jamming, reduced or lost battery power, or a theft notification from the carrier.  "]
["8.1.6","Response protocols must include a documented process for the engagement of law enforcement, a clear understanding of the law enforcement resources available and how to work with them, and a follow-up protocol to assist law enforcement throughout the investigation of any loss, including the sharing of tracking information.  Simply notifying law enforcement of the loss is not acceptable"]
["8.1.7","The Portable Tracking Device must demonstrate at least two of the following: geofencing, start-stop monitoring, alerts for no-stop zones, and critical waypoints.   "]
["8.1.8","The frequency of signal from the Portable Tracking Device should be determined by the Buyer, but with a minimum of 1 report per hour."]

{"sheet":"SCAR","index":1,"n_rows":72,"n_cols":2,"rows_kept":72,"cut":false,"hidden":false,"merged":[[71,1,71,8],[60,1,60,8],[61,1,61,8],[62,1,62,8],[63,1,63,8],[64,1,64,8],[65,1,65,8],[66,1,66,8],[67,1,67,8],[68,1,68,8],[69,1,69,8],[70,1,70,8],[59,1,59,8],[48,1,48,8],[49,1,49,8],[50,1,50,8],[51,1,51,8],[52,1,52,8],[53,1,53,8],[54,1,54,8],[55,1,55,8],[56,1,56,8],[57,1,57,8],[58,1,58,8],[47,1,47,8],[36,1,36,8],[37,1,37,8],[38,1,38,8],[39,1,39,8],[40,1,40,8],[41,1,41,8],[42,1,42,8],[43,1,43,8],[44,1,44,8],[45,1,45,8],[46,1,46,8],[35,1,35,8],[24,1,24,8],[25,1,25,8],[26,1,26,8],[27,1,27,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,8],[23,1,23,8],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[22,1,22,8],[11,1,11,8],[0,0,0,8],[1,0,1,8],[2,2,2,8],[3,2,3,8],[4,2,4,8],[5,2,5,8],[6,2,6,8],[7,0,7,8],[8,1,8,8],[9,1,9,8],[10,1,10,8]]}
["Security Corrective Action Requirements"]
[]
[null,"SCAR #"]
[null,"AUDITORS:"]
[null,"ADDRESS:"]
[null,"LOCATION AUDITED:"]
[null,"DATE:"]
["MAJOR FINDINGS"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]
["Finding:"]
["Significance:"]
["Corrective Action:"]
["Disposition:"]

{"sheet":"vehicle checksheet level 1","index":2,"n_rows":31,"n_cols":19,"rows_kept":31,"cut":false,"hidden":false,"merged":[[6,2,6,3],[30,1,30,2],[0,0,0,18],[1,0,1,18],[7,5,14,7],[3,8,14,18],[2,2,2,18],[10,1,10,4],[11,1,11,4],[5,4,5,7],[6,4,6,7],[3,4,3,7],[4,4,4,7],[20,0,21,0],[3,2,3,3],[12,1,12,4],[13,1,13,4],[4,2,4,3],[5,2,5,3],[28,1,28,2],[9,1,9,4],[18,1,18,2],[16,3,17,3],[18,4,18,18],[19,1,19,2],[16,0,17,2],[14,1,14,4],[27,1,27,2],[26,1,26,2],[20,1,20,2],[21,1,21,2],[15,0,15,18],[29,1,29,2],[22,1,22,2],[22,4,22,18],[23,1,23,2],[24,1,24,2],[25,1,25,2],[24,0,27,0]]}
[]
[" TSR 2014 VEHICLE AUDIT SCORING FORM LEVEL 1"]
[]
["Company",null,"Date of Audit"]
["Location",null,"Phone Number"]
["Contact Name",null,"Fax Number"]
["AUDITOR(s)",null,"Email"]
[]
["Audit Rating Score"]
["Point Value","                                   Description of Measurement Criteria"]
["N","Not present/utilized - No plans to adopt/implement"]
["Y","Firmly in place and adopted as best practice"]
["X","Requirement does not apply"]
["W","Waiver required"]
[]
["All requirements mentioned below are Mandatory in order to pass the audit"]
["TAPA TSR 2014 REQUIREMENTS PRACTICE LEVEL 1",null,null,"Level #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #"]
[]
["SECTION 1","1 PHYSICAL SECURITY",null,"Level\n 1","Point Value"]
["1.1 Truck Security"," 1.1.3. - Auditory alarm if unauthorised entry to tractor cab occurs ",null,"x"]
["1.2.Trailer Security"," 1.2.1. - High quality stainless steel security locking devices such as built-in locks OR mobile heavy weight locking devices with integral locks fixed to all truck/trailer doors (no chains, cables, light weight bars, removable bolts, etc) and utilized during entire journey. Locks can be electronically or manually operated, must be unique and must be designed to resist defeat for not less than ten minutes with hand tools.",null,"x"]
[null," 1.2.4. - Only hard sided trailers utilized",null,"x"]
["SECTION 2","2 TRACKING AND TECHNOLOGY",null,"Level 1","Point Value"]
["2.1. Two Way Communication Systems"," 2.1.1. - Two way communication system present during entire journey ",null,"x"]
["2.2 Tracking and Tracing Systems"," 2.2.4. - A tracking device must be installed in a covert location in the tractor and, where available, must be capable of utilizing at least two methods of signaling such as 3G, or SMS/GPRS using GSM or CDMA and should be equipped with at least one covert antenna.",null,"x"]
[null," 2.2.5. - A tracking device must be installed in a covert location in the trailer and, where available, must be capable of utilizing at least two methods of signaling such as 3G, or SMS/GPRS using GSM or CDMA and should be equipped with at least one covert antenna ",null,"x"]
[null," 2.2.9. - The tracking devices in the trailer and the tractor must report events to include untethering (unhooking) of the trailer, device tampering, truck stoppage, tracker battery status and trailer door opening.       ",null,"x"]
[null,"2.2.10. - The trailer and tractor devices must be equipped with a battery back-up capable of maintaining the signalling capacity of the tracker for not less than 24 hours at a reporting rate of not less than one reporting every five miutes while the trailer is untethered.",null,"x"]
["2.3.Satelite Navigation Systems (route planner)"," 2.3.1. - Satellite navigation system installed(route planner) recognizing detours, traffic jams,etc..to avoid unnecessary stops or delays. Carrier's dispatch must confirm all route changes.",null,"x"]
["2.4. Silent Alarm System"," 2.4.1. - Manually activated silent alarm (panic button) present in reach of driver and able to send signal to Supplier's home base or third party monitoring center",null,"x"]
["2.5. Trailer Door Alarms"," 2.5.1. - Unauthorized opening of trailer doors sends signal to monitoring center",null,"x"]

{"sheet":"vehicle checksheet level 2","index":3,"n_rows":26,"n_cols":19,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,1,25,2],[1,0,1,18],[0,0,0,18],[2,1,2,18],[7,5,13,6],[3,7,13,18],[21,4,21,18],[14,0,14,18],[3,3,3,6],[4,3,4,6],[5,3,5,6],[6,3,6,6],[15,0,16,2],[15,3,16,3],[18,0,20,0],[17,1,17,2],[13,1,13,4],[17,4,17,18],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[20,1,20,2],[21,1,21,2],[24,1,24,2],[18,1,18,2],[23,1,23,2],[22,1,22,2],[19,1,19,2]]}
[]
[" TSR 2014 VEHICLE AUDIT SCORING FORM LEVEL 2"]
[]
["Company",null,"Date of Audit"]
["Location",null,"Phone Number"]
["Contact Name",null,"Fax Number"]
["AUDITOR(s)",null,"Email"]
[]
["Audit Rating Score"]
["Point Value","                                   Description of Measurement Criteria"]
["N","Not present/utilized - No plans to adopt/implement"]
["Y","Firmly in place and adopted as best practice"]
["X","Requirement does not apply"]
["W","Waiver required"]
["All requirements mentioned below are Mandatory in order to pass the audit"]
["TAPA TSR 2014 REQUIREMENTS PRACTICE LEVEL 2",null,null,"Level #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #"]
[]
["SECTION 1","1 PHYSICAL SECURITY",null,"Level\n 2","Point Value"]
["1.2. Trailer Security"," 1.2.2. - High quality stainless steel security locks either firmly fixed to all truck/trailer doors OR use of high quality chains, bars, padlocks etc. and utilized during the entire journey. Locks can be electronically or manually operated, must be unique and must be designed to resist defeat with hand tools.",null,"x"]
[null," 1.2.4. - Only hard sided trailers utilized",null,"x"]
[null," 1.2.7. - Trailer immobilization device in place when trailer is dropped (kingpin, landing gear lock or brake line lock)",null,"x"]
["SECTION 2","2 TRACKING AND TECHNOLOGY",null,"Level \n2","Point Value"]
["2.1. Two Way Communication Systems"," 2.1.1. - Two way communication system present during entire journey ",null,"x"]
["2.2. Tracking Systems"," 2.2.4 - A tracking device must be installed in a covert location in the tractor and, where available, must be capable of utilzing at least two methods of signalling such as 3G, or SMS/GPRS using GSM or CDMA and must be equipped with at least one covert antenna.",null,"x"]
["2.3.Satelite Navigation Systems (route planner)"," 2.3.1. - Satellite navigation system installed(route planner) recognizing detours, traffic jams,etc..to avoid unnecessary stops or delays. Carrier's dispatch must confirm all route changes.",null,"x"]
["2.4.1. Silent alarm System","2.4.1. - Manually activated silent alarm (panic button) present in reach of driver and able to send signal to the LSP's home base or third party monitoring centre.",null,"x"]

{"sheet":"vehicle checksheet level 3","index":4,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[6,3,6,6],[7,0,7,6],[0,0,0,18],[1,0,1,18],[2,3,2,18],[3,3,3,6],[20,1,20,2],[19,1,19,2],[18,1,18,2],[17,1,17,2],[15,0,16,2],[15,3,16,3],[17,4,17,18],[8,1,8,6],[9,5,13,6],[3,7,13,18],[4,3,4,6],[5,3,5,6],[21,1,21,2],[22,1,22,2],[14,0,14,18],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[19,4,19,18]]}
[]
[" TSR 2014 AUDIT SCORING FORM (Practice Section) Level 3"]
[]
["Company",null,"Date of Audit"]
["Location",null,"Phone Number"]
["Contact Name",null,"Fax Number"]
["AUDITOR(s)",null,"Email"]
[]
["Audit Rating Score"]
["Point Value","                                   Description of Measurement Criteria"]
["N","Not present/utilized - No plans to adopt/implement"]
["Y","Firmly in place and adopted as best practice"]
["X","Requirement does not apply"]
["W","Waiver required"]
["All requirements mentioned below are Mandatory in order to pass the audit"]
["TAPA TSR 2014 REQUIREMENTS PRACTICE LEVEL 3",null,null,"Level #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #","Vehicle log #"]
[]
["SECTION 1","1 PHYSICAL SECURITY",null,"Level\n 3","Point Value"]
[null," 1.2.5. - Soft sided trailers as minimum",null,"x"]
["SECTION 2","2 TRACKING AND TECHNOLOGY",null,"Level 3","Point Value"]
["2.1. Two Way Communication Systems"," 2.1.1. - Two way communication system present during entire journey ",null,"x"]
["2.2 Tracking Systems"," 2.2.11. - A tracking device is installed providing remotely stored archival information relating to the position of all FTL (full truckload, Supplier dedicated) trucks",null,"x"]
["2.3.Satelite Navigation Systems (route planner)"," 2.3.1. - Satellite navigation system installed(route planner) recognizing detours, traffic jams,etc..to avoid unnecessary stops or delays. Carrier's dispatch must confirm all route changes.",null,"x"]