{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Welcome","How To Enable Content","Company Profile","Employee Driver Profile","Employee Benefits","Regions","Responses"],"not_rendered":{"charts":0,"images":134,"macros":1,"external_links":0,"defined_names":5,"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":"Welcome","index":0,"n_rows":3,"n_cols":13,"rows_kept":3,"cut":false,"hidden":false,"merged":[[34,2,34,6],[35,2,35,6],[25,2,25,6],[26,2,26,6],[27,2,27,6],[31,2,31,6],[32,2,32,6],[33,2,33,6],[0,1,0,17],[21,2,21,6],[22,2,22,6],[23,2,23,6],[24,2,24,6],[2,2,2,3],[2,12,2,15]]}
[null,"ATA'S DRIVER COMPENSATION SURVEY: LTL"]
[]
[null,null,"FIRST STEP:",null,null,null,null,null,null,null,null,null,"Please enable all content in this file to assure proper function of this survey."]

{"sheet":"How To Enable Content","index":1,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[23,9,23,11],[24,9,24,11],[2,6,2,13],[4,2,4,4],[4,5,4,15],[20,9,20,10],[21,9,21,10],[22,9,22,11]]}
[]
[]
[null,null,null,null,null,null,"Step by Step Instructions to Enable Macros:"]
[]
[null,null,"IMPORTANT NOTE:",null,null,"Only follow these instructions if you were not prompted with either of these notifications:"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"OR"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,1,"File"]
[null,null,null,null,null,null,null,null,2,"Options"]
[null,null,null,null,null,null,null,null,3,"Trust Center"]
[null,null,null,null,null,null,null,null,4,"Trust Center Settings"]
[null,null,null,null,null,null,null,null,5,"Macro Settings"]
[null,null,null,null,null,null,null,null,6,"Enable All Macros"]

{"sheet":"Company Profile","index":2,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[29,7,29,10],[32,4,32,6],[31,3,31,9],[38,3,38,11],[51,3,51,6],[42,3,42,4],[42,5,42,6],[42,7,42,11],[39,3,39,7],[41,3,41,12],[40,4,40,6],[40,7,40,8],[45,3,45,4],[47,3,47,12],[33,3,33,9],[34,3,34,11],[35,7,35,8],[37,3,37,4],[37,5,37,6],[37,7,37,11],[36,3,36,13],[12,3,12,4],[13,3,13,4],[12,5,12,8],[57,3,57,12],[52,3,55,15],[25,4,25,6],[26,4,26,6],[27,4,27,6],[15,2,15,16],[13,8,13,11],[17,2,17,16],[19,3,19,9],[21,3,21,9],[23,3,23,14],[20,4,20,6],[35,4,35,6],[10,5,10,8],[10,3,10,4],[11,3,11,4],[11,5,11,8],[0,1,2,17],[4,2,4,16],[6,2,6,16],[8,3,8,4],[9,3,9,4],[9,5,9,8],[8,5,8,8]]}
[null,"Company Profile"]
[]
[]
[]
[null,null,"In this tab, you'll provide your contact information. You will then answer a few operations questions to help give a snapshot of your company profile. Please respond to all questions applicable to your company's present operations unless otherwise requested. "]
[]
[null,null,"Company Contact Information"]
[]
[null,null,null,"Company: "]
[null,null,null,"Name:"]
[null,null,null,"Position:"]
[null,null,null,"Phone Number:"]
[null,null,null,"Email Address"]
[]
[]
[null,null,"Carriers that participate in the driver compensation study are eligible to receive special discounts and offers as a gesture of our sincere thanks.  Participants may receive: 1.) an executive summary prior to the official release of the report, 2.) the full 2022 Driver Compensation Study for $100 \n($1,500 for non-participants)"]
[]
[null,null,"Operations"]
[]
[null,null,1,"Approximate gross revenues from motor carrier operations in 2021:"]
[null,null,null,null,null,null,null,"dollars"]
[null,null,2,"Which best describes your company?"]
[]
[null,null,3,"Which best describes your operations type? Choose all that apply."]
[]
[null,null,null,null,"General Freight/Dry Van"]
[null,null,null,null,"Refrigerated Solids"]
[null,null,null,null,"Other *"]
[]
[null,null,null,null,null,"*Please describe:"]
[]
[null,null,4,"What is your overall average length of haul?"]
[null,null,null,null,null,null,null,"miles"]
[null,null,5,"Total number of regular, full-time employees:"]
[null,null,null,"(Include office workers, mechanics/techs, and drivers. Exclude independent contractors.)"]
[null,null,null,null,null,null,null,"employees"]
[null,null,6,"Number of full-time employee drivers (not independent contractors):"]
[null,null,null,null,null,null,null,"drivers"]
[null,null,7,"Number of power units operated by employee drivers:"]
[null,null,null,"(exclude independent contractor units)"]
[null,null,null,null,null,null,null,"power units"]
[null,null,8,"Number of independent contractor (IC) drivers hauling for your company on a regular basis:"]
[null,null,null,null,null,null,null,"drivers"]
[]
[null,null,9,"How many driver applications did your company receive in 2021?"]
[null,null,null,"Applications: "]
[]
[null,null,null,"What percentage of those applications did your company have to turn away due to inadequate quality or lack of required qualifications?"]
[null,null,null,null,null,null,"%"]
[]
[]
[null,null,null,"Additional Comments:"]
[]
[]
[]
[]
[]
[null,null,null,"Please take a moment to save this document. When ready please continue onto the next tab: "]

{"sheet":"Employee Driver Profile","index":3,"n_rows":53,"n_cols":26,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,1,2,17],[4,2,4,16],[7,2,7,16],[10,3,10,4],[29,3,29,12],[27,3,27,13],[9,3,9,13],[10,5,10,6],[10,7,10,11],[28,3,28,11],[14,3,14,9],[18,3,18,11],[12,9,12,10],[52,3,52,12],[30,3,30,8],[31,3,31,6],[16,3,16,6],[26,4,26,8],[26,9,26,14],[34,3,34,6],[32,3,32,9],[47,3,50,15],[46,3,46,6],[33,3,33,9],[31,9,31,11],[31,12,31,15],[20,3,20,16],[37,3,37,6],[43,3,43,9]]}
[null,"Employee Driver Profile"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"months","days per week","weekly","Yes, all drivers",null,null,"hours"]
[null,null,"Give a snapshot of your employee drivers by answering the questions in this tab. Questions relate to age, training and certifications. Please respond to all questions applicable to your company's current operations unless otherwise requested. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"years","days per month","every other week","Yes, some drivers",null,null,"days"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"twice monthly","No",null,null,"weeks"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"monthly"]
[null,null,"Employee Driver Profile",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"other"]
[]
[null,null,1,"Number of full-time employee drivers (not independent contractors):"]
[null,null,null,null,null,{"$f":"'Company Profile'!F38:G38","v":0},null,"(data imported from \"Company Profile\" tab)"]
[]
[null,null,2,"What was your 2021 employee driver turnover rate?",null,null,null,null,null,null,null,"%"]
[]
[null,null,3,"Minimum age required of your employee drivers before hiring:"]
[]
[null,null,4,"Average age of your employee drivers:"]
[]
[null,null,5,"Do you hire drivers directly out of truck driver training school? (i.e. inexperienced drivers)?"]
[]
[null,null,6,"How much OTR driving experience is required, in months or years, in order for a new employee driver to be considered \"experienced\"?"]
[]
[null,null,null,null,"What percentage of your employee drivers are considered \"experienced\"?",null,null,null,null,null,null,null,null,"%"]
[]
[null,null,7,"On average, how many days per week or month are your employee OTR/non-local drivers on the road before returning home?"]
[]
[null,null,null,null,"*Other or not applicable, please describe:"]
[null,null,8,"Do you offer a one-time sign-on bonus to new drivers?"]
[null,null,9,"Do you offer a referral bonus?"]
[null,null,10,"Do you offer a tenure bonus?"]
[null,null,11,"Do you offer a bonus for clean DOT roadside inspections?"]
[null,null,12,"How often are employee drivers paid?",null,null,null,null,null,"If other, please describe:"]
[null,null,13,"Do you require employee drivers to have a hazmat endorsement?"]
[null,null,14,"Do you require employee drivers to have a TWIC?"]
[null,null,15,"Are your employee drivers unionized?"]
[]
[]
[null,null,16,"Did you increase driver pay in 2021?"]
[]
[]
[null,null,17,"Do you plan to increase driver pay before the end of 2022?"]
[]
[]
[null,null,18,"Do you provide guaranteed weekly minimum earnings? "]
[]
[]
[null,null,null,"Additional Comments:"]
[]
[]
[]
[]
[]
[null,null,null,"Please take a moment to save this document. When ready please continue onto the next tab: "]

{"sheet":"Employee Benefits","index":4,"n_rows":63,"n_cols":20,"rows_kept":63,"cut":false,"hidden":false,"merged":[[38,3,38,8],[36,3,36,9],[34,3,34,9],[32,3,32,9],[58,2,58,16],[43,2,43,16],[45,3,45,13],[39,4,39,7],[40,5,40,14],[49,2,49,16],[18,2,18,16],[20,3,20,13],[24,2,24,16],[26,3,26,13],[30,2,30,16],[12,2,12,16],[15,3,15,13],[0,1,2,17],[4,2,4,16],[7,2,7,16],[9,3,9,13],[14,3,14,13],[68,7,68,12],[69,7,69,11],[70,7,70,12],[71,7,71,11],[62,4,62,14],[64,7,64,11],[65,7,65,11],[66,7,66,11],[67,7,67,11]]}
[null,"Employee Benefits"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per mile"]
[null,null,"Please review the questions below, and tell us about your company sponsored benefits for employee drivers. Respond to all questions applicable to your company's current operations unless otherwise requested. ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"other, please describe below"]
[]
[null,null,"Holidays"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Flat Rate"]
[null,null,null,"Does your company offer paid holidays to employee drivers?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Daily Mileage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Daily Income"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hourly Rate"]
[null,null,"Paid Time Off",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other, please describe in the comment box below"]
[null,null,null,"Does your company offer paid vacation or sick days to employee drivers?"]
[null,null,null,"Does your company distinguish between \"sick\" days and \"vacation\" days?"]
[]
[]
[null,null,"Lodging, Meals & Incidentals "]
[]
[null,null,null,"Does your company offer to cover any lodging, meals, or incidental expenses for employee drivers?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes, actual lodging expenses reimbursed. ","Yes, actual expenses reimbursed. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes, lodging per diem.","Yes, per diem."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","No"]
[null,null,"Life Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not Applicable ","Not Applicable "]
[]
[null,null,null,"Does your company pay in full life insurance coverage for your employee drivers?"]
[]
[]
[]
[null,null,"Health Benefits"]
[]
[null,null,1,"Does your company offer medical insurance to employee drivers?"]
[]
[null,null,2,"Does your company offer dental insurance to employee drivers?"]
[]
[null,null,3,"Does your company offer vision insurance to employee drivers?"]
[]
[null,null,4,"Do you offer any other types of health related benefits?"]
[null,null,null,null,"If yes, please describe below."]
[]
[]
[]
[null,null,"Retirement"]
[]
[null,null,null,"Does your company offer a retirement plan for employee drivers?"]
[]
[]
[]
[null,null,"Additional Benefits"]
[]
[null,null,null,"Does you company offer any of the following additional benefits to employee drivers? Check all that apply. "]
[null,null,null,"1.","Profit Sharing Program Plan (Retirement plan that gives employees a share in the profits of a company)"]
[null,null,null,"2.","Discount Program (Discounts on certain affiliated products or brands)"]
[null,null,null,"3.","Passenger Program (Ability to take passengers on the road with the driver)"]
[null,null,null,"4.","Pet Program (Ability to take pets on the road with the driver)"]
[]
[]
[null,null,"Please continue on to provide information on driver compensation as it relates to your company's specific operations/driver types. "]
[]
[]
[]
[null,null,null,null,"Click on your company's operation(s) below as a shortcut to continue filling out the survey:"]

{"sheet":"Regions","index":5,"n_rows":152,"n_cols":25,"rows_kept":152,"cut":false,"hidden":false,"merged":[[44,3,44,8],[43,2,43,16],[40,1,42,17],[51,2,51,16],[52,3,52,10],[6,7,6,10],[28,2,28,3],[29,3,29,13],[30,3,30,13],[31,3,31,10],[32,2,32,16],[21,1,23,17],[24,2,24,16],[26,3,26,13],[12,2,12,11],[13,2,13,11],[14,2,14,11],[18,2,18,11],[11,2,11,6],[15,2,15,11],[0,1,2,17],[4,2,4,16],[16,2,16,10],[17,2,17,11],[117,3,117,8],[119,2,119,3],[120,3,120,13],[46,2,46,3],[47,3,47,13],[48,3,48,13],[49,3,49,10],[67,3,67,13],[68,3,68,10],[91,3,91,13],[92,3,92,10],[95,1,97,17],[80,2,80,16],[81,3,81,8],[83,2,83,3],[84,3,84,13],[33,3,33,10],[35,2,35,3],[36,3,36,13],[37,3,37,10],[54,2,54,3],[55,3,55,13],[56,3,56,10],[59,1,61,17],[88,2,88,16],[89,3,89,10],[90,2,90,3],[95,0,96,0],[106,2,106,16],[107,3,107,10],[108,2,108,3],[109,3,109,13],[110,3,110,10],[59,0,60,0],[70,2,70,16],[86,3,86,10],[62,2,62,16],[63,3,63,8],[71,3,71,10],[72,2,72,3],[73,3,73,13],[74,3,74,10],[77,1,79,17],[85,3,85,13],[77,0,78,0],[65,2,65,3],[66,3,66,13],[103,3,103,13],[104,3,104,10],[98,2,98,16],[99,3,99,8],[101,2,101,3],[102,3,102,13],[151,2,151,16],[131,0,132,0],[142,2,142,16],[143,3,143,10],[144,2,144,3],[145,3,145,13],[140,3,140,10],[135,3,135,8],[137,2,137,3],[138,3,138,13],[139,3,139,13],[146,3,146,10],[131,1,133,17],[116,2,116,16],[113,1,115,17],[113,0,114,0],[122,3,122,10],[134,2,134,16],[121,3,121,13],[124,2,124,16],[125,3,125,10],[150,2,150,16],[126,2,126,3],[127,3,127,13],[128,3,128,10]]}
[null,"Regional Routes"]
[]
[]
[]
[null,null,"This tab is for participants with line-haul and/or local/Pick-up & Delivery employee drivers. If your regional operations do not match the categories below, choose the region(s) with the most states matching your operations. Please respond to all questions applicable to your company's operations as of December 31, 2021 unless otherwise requested. We understand that companies have many different types of drivers. Please use your best guess at the average for all prompts, unless otherwise specified."]
[]
[null,null,null,null,null,null,null,"Contents:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Employee Northeast Region   (CT, DE, DC, ME, MA, MD, NH, NJ, NY, PA, RI, VT)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cents per mile"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"per hour"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fixed annual salary"]
[null,null,"Part 1: Northeast Line-Haul",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"other"]
[]
[null,null,null,"Does your company employ northeast line-haul drivers?"]
[]
[null,null,"Bonuses:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Does your company offer a fuel efficiency bonus to drivers meeting your company's fuel efficiency goals?"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[null,null,"Part 2: Northeast Local/Pick-up & Delivery"]
[null,null,null,"Does your company employ northeast region local/pick-up & delivery drivers?"]
[]
[null,null,"Bonuses:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[]
[null,"Employee South Region  (AL, FL, GA, KY, LA, MS, NC, SC, TN, VA, WV)"]
[" "]
[]
[null,null,"Part 1: South Line-Haul"]
[null,null,null,"Does your company employ southern line-haul drivers?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer a fuel efficiency bonus to drivers meeting your company's fuel efficiency goals?"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Daily Income"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hourly Rate"]
[null,null,"Part 2: South Local/Pick-up & Delivery"]
[null,null,null,"Does your company employ south region local/pick-up & delivery drivers?"]
[]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[]
[null,"Employee North Central Region  (IL, IN, MI, MN, OH, WI area)"]
[]
[]
[null,null,"Part 1: North Central Line-Haul"]
[null,null,null,"Does your company employ north central line-haul drivers?"]
[]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer a fuel efficiency bonus to drivers meeting your company's fuel efficiency goals?"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[null,null,"Part 2: North Central Local/Pick-up & Delivery"]
[null,null,null,"Does your company employ north central region local/pick-up & delivery drivers?"]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[]
[null,"Employee Midwest Region  (AR, IA, KS, MO, NE, OK area)"]
[]
[]
[null,null,"Part 1: Midwest Line-Haul"]
[null,null,null,"Does your company employ midwestern line-haul drivers?"]
[]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer a fuel efficiency bonus to drivers meeting your company's fuel efficiency goals?"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[null,null,"Part 2: Midwest Local/Pick-up & Delivery"]
[null,null,null,"Does your company employ midwest region local/pick-up & delivery drivers?"]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[]
[null,"Employee Southwest Region  (AZ, CO, NM, TX, UT area)"]
[]
[]
[null,null,"Part 1: Southwest Line-Haul"]
[null,null,null,"Does your company employ southwest line-haul drivers?"]
[]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer a fuel efficiency bonus to drivers meeting your company's fuel efficiency goals?"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[null,null,"Part 2: Southwest Local/Pick-up & Delivery"]
[null,null,null,"Does your company employ southwest region local/pick-up & delivery drivers?"]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[]
[null,"Employee Northwest Region  (ID, MT, ND, SD, WY area)"]
[]
[]
[null,null,"Part 1: Northwest Line-Haul"]
[null,null,null,"Does your company employ northwest line-haul drivers?"]
[]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer a fuel efficiency bonus to drivers meeting your company's fuel efficiency goals?"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[null,null,"Part 2: Northwest Local/Pick-up & Delivery"]
[null,null,null,"Does your company employ northwest region local/pick-up & delivery drivers?"]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[]
[null,"Employee West Region  (AK, CA, HI, NV, OR, WA area)"]
[]
[]
[null,null,"Part 1: West Line-Haul"]
[null,null,null,"Does your company employ western line-haul drivers?"]
[]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer a fuel efficiency bonus to drivers meeting your company's fuel efficiency goals?"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[null,null,"Part 2: West Local/Pick-up & Delivery"]
[null,null,null,"Does your company employ west region local/pick-up & delivery drivers?"]
[null,null,"Bonuses:"]
[null,null,null,"Does your company offer bonuses for accident-free miles driven during a specified period of time?"]
[null,null,null,"If there are any additional pay options or bonuses your company offers, please "]
[]
[]
[]
[null,null,"You have reached the end of the LTL Driver Compensation Survey! Thank you for participating! "]
[null,null,"At this time please save this document and attach the file in an email to the Economics Analyst at                            "]

{"sheet":"Responses","index":6,"n_rows":68,"n_cols":106,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
["Company","Name","Position","PhoneNumber","Email","Q1","Q2","Q3A","Q3A","Q3A","Q3A","Q4","Q5","Q6","Q7","Q8","QAC","Q9","Q9B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Options 1"]
[{"$f":"'Company Profile'!$F$9","v":0},{"$f":"'Company Profile'!$F$10","v":0},{"$f":"'Company Profile'!$F$11","v":0},{"$f":"'Company Profile'!$F$12","v":0},{"$f":"'Company Profile'!$F$13","v":0},{"$f":"'Company Profile'!E21","v":0},{"$f":"IF(G3=TRUE,\"1\",IF(G4=TRUE,\"2\",\"NR\"))","v":"NR"},false,false,false,{"$f":"'Company Profile'!H30","v":0},{"$f":"'Company Profile'!E33","v":0},{"$f":"'Company Profile'!E36","v":0},{"$f":"'Company Profile'!F38","v":0},{"$f":"'Company Profile'!E41","v":0},{"$f":"'Company Profile'!F43","v":0},{"$f":"'Company Profile'!D53","v":0},{"$f":"'Company Profile'!F46","v":0},{"$f":"'Company Profile'!F49","v":0}]
[null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Years of Experience"]
[null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accident-Free Miles"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]
[]
[]
["Q1","Q2","Q3","Q4","Q5","Q51","Q51a","Q51A","Q5B1","Q5B2","Q5C1","Q5C2","Q5D1","Q5D2","Q5D3","Q5(AC)","Q6A","Q6B","Q6C","Q7A","Q7B","Q7C","Q8","Q8A","Q9","Q9A","Q10","Q10A","Q10B","Q11","Q11A","Q12A","Q12B","Q13","Q14","Q15","COMM","Pay Increase","%","PayA","PayB","PayC","PayD","PayE","Planned Increase","%","Q18","Q18A","Q18B","Q18C","Q18D"]
[{"$f":"'Employee Driver Profile'!$F$11","v":0},{"$f":"'Employee Driver Profile'!$J$13","v":0},{"$f":"'Employee Driver Profile'!K15","v":0},{"$f":"'Employee Driver Profile'!$H$17","v":0},{"$f":"IF(E10=TRUE,\"1\",IF(E11=TRUE,\"2\",\"NR\"))","v":"NR"},{"$f":"IF(F10=TRUE,\"1\",IF(F11=TRUE,\"2\",\"NR\"))","v":"NR"},{"$f":"IF(G10=TRUE,\"1\",IF(G11=TRUE,\"2\",\"NR\"))","v":"NR"},{"$f":"IF(H10=TRUE,\"1\",IF(H11=TRUE,\"2\",IF(H12=TRUE,\"3\",\"NR\")))","v":"NR"},null,null,{"$f":"IF(K10=TRUE,\"1\",IF(K11=TRUE,\"2\",\"NR\"))","v":"NR"},null,{"$f":"IF(M10=TRUE,\"1\",IF(M11=TRUE,\"2\",\"NR\"))","v":"NR"},null,null,null,{"$f":"'Employee Driver Profile'!F22","v":0},null,{"$f":"'Employee Driver Profile'!M23","v":0},{"$f":"'Employee Driver Profile'!F26","v":0},null,{"$f":"'Employee Driver Profile'!J27","v":0},{"$f":"IF(W10=TRUE,\"1\",IF(W11=TRUE,\"2\",\"NR\"))","v":"NR"},null,{"$f":"IF(Y10=TRUE,\"1\",IF(Y11=TRUE,\"2\",\"NR\"))","v":"NR"},null,{"$f":"IF(AA10=TRUE,\"1\",IF(AA11=TRUE,\"2\",\"NR\"))","v":"NR"},null,null,{"$f":"IF(AD10=TRUE,\"1\",IF(AD11=TRUE,\"2\",\"NR\"))","v":"NR"},null,null,{"$f":"'Employee Driver Profile'!M32","v":0},null,null,null,{"$f":"'Employee Driver Profile'!D48","v":0},{"$f":"IF(AL10=TRUE,\"1\",IF(AL11=TRUE,\"2\",\"NR\"))","v":"NR"},null,{"$f":"IF(AN10=TRUE,\"1\",IF(AN11=TRUE,\"2\",\"NR\"))","v":"NR"},{"$f":"IF(AO10=TRUE,\"1\",IF(AO11=TRUE,\"2\",\"NR\"))","v":"NR"},false,false,false,{"$f":"IF(AS10=TRUE,\"1\",IF(AS11=TRUE,\"2\",IF(AS12=TRUE,\"3\",\"NR\")))","v":"NR"},null,{"$f":"IF(AU10=TRUE,\"1\",IF(AU11=TRUE,\"2\",\"NR\"))","v":"NR"}]
[null,null,null,null,false,false,false,false,null,null,false,null,false,null,null,null,null,null,null,null,null,null,false,null,false,null,false,null,null,false,null,null,null,null,null,null,null,false,null,false,false,null,null,null,false,null,false]
[null,null,null,null,false,false,false,false,null,null,false,null,false,null,null,null,null,null,null,null,null,null,false,null,false,null,false,null,null,false,null,null,null,null,null,null,null,false,null,false,false,null,null,null,false,null,false]
[null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
["Q1","Q1A","Q1B","Q1C","Q1D","Q2","Q3","Q3A","Q3B","Q3C","Q3D","Q3E","Q3F","Q3G","Q4","Q4A","Q4B","Q4C","Q4D","Q4E","Q5","Q5A","Q5B",null,"Q3NA","Q3NB","Q3NC","Q3ND","Q7","Q7A","Q7(Employee Single)","Q7(Employer Single)","Q7(OOPSingle)","Q7(ENROLSingle)","Q7(Employee(w/Spouse))","Q7(Employer(w/Spouse))","Q7(OOPw/Spouse)","Q7(ENROLw/Spouse)","Q7(Employee(w/child))","Q7(Employer(w/child))","Q7(OOPw/child)","Q7(ENROLw/child)","Q7(Employee(w/fam))","Q7(Employer(w/fam))","Q7(OOPw/fam)","Q7(ENROLw/fam)","Q7C","Q7D","Q7E","Q8","Q8A","Q8(Employee Single)","Q8(Employer Single)","Q8(OOPSingle)","Q8(ENROLSingle)","Q8(Employee(w/Spouse))","Q8(Employer(w/Spouse))","Q8(OOPw/Spouse)","Q8(ENROLw/Spouse)","Q8(Employee(w/child))","Q8(Employer(w/child))","Q8(OOPw/child)","Q8(ENROLw/child)","Q8(Employee(w/fam))","Q8(Employer(w/fam))","Q8(OOPw/fam)","Q8(ENROLw/fam)","Q8C","Q8D","Q8 Self-Insured","Q9","Q9A","Q9(Employee Single)","Q9(Employer Single)","Q9(OOPSingle)","Q9(ENROLSingle)","Q9(Employee(w/Spouse))","Q9(Employer(w/Spouse))","Q9(OOPw/Spouse)","Q9(ENROLw/Spouse)","Q9(Employee(w/child))","Q9(Employer(w/child))","Q9(OOPw/child)","Q9(ENROLw/child)","Q9(Employee(w/fam))","Q9(Employer(w/fam))","Q9(OOPw/fam)","Q9(ENROLw/fam)","Q9C","Q9D","Q9 Self-Insured","Q10","Q10A","Q10","Q10A","Q10B","Q10B1","Q10B2","Q10C","Q10C1","Q10E","Q10E1","Q12A","Q12B","Q12C","Q12D"]
[{"$f":"IF(A17=TRUE,\"1\",IF(A18=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,{"$f":"IF(F17=TRUE,\"1\",IF(F18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"IF(G17=TRUE,\"1\",IF(G18=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(O17=TRUE,\"1\",IF(O18=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,{"$f":"IF(U17=TRUE,\"1\",IF(U18=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AC17=TRUE,\"1\",IF(AC18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"IF(AD17=TRUE,\"1\",IF(AD18=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AV17=TRUE,\"1\",IF(AV18=TRUE,\"0\",\"NR\"))","v":"NR"},null,{"$f":"IF(AX17=TRUE,\"1\",IF(AX18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"IF(AY17=TRUE,\"1\",IF(AY18=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BR17=TRUE,\"1\",IF(BR18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"IF(BS17=TRUE,\"1\",IF(BS18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"IF(BT17=TRUE,\"1\",IF(BT18=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CM17=TRUE,\"1\",IF(CM18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"IF(CN17=TRUE,\"1\",IF(CN18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"'Employee Benefits'!$F$41","v":0},{"$f":"IF(CP17=TRUE,\"1\",IF(CP18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"IF(CQ17=TRUE,\"1\",IF(CQ18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"IF(CR17=TRUE,\"1\",IF(CR18=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,{"$f":"IF(CU17=TRUE,\"1\",IF(CU18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"IF(CV17=TRUE,\"1\",IF(CV18=TRUE,\"0\",\"NR\"))","v":"NR"},{"$f":"IF(CW17=TRUE,\"1\",IF(CW18=TRUE,\"0\",\"NR\"))","v":"NR"},null,false,false,false,false]
[false,null,null,null,null,false,false,null,null,null,null,null,null,null,false,null,null,null,null,null,false,null,null,null,null,null,null,null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,false,false,false,null,null,false,false,false]
[false,null,null,null,null,false,false,null,null,null,null,null,null,null,false,null,null,null,null,null,false,null,null,null,null,null,null,null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,null,false,false,false,null,null,false,false,false]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
["NE LINE HAUL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NE LOCAL"]
["Q1","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q2","FUEL1","FUEL2A","FUEL2B","FUEL2C","FUEL3","FUEL4","FUEL(AC)","Q3","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q4","MISC1","MISC2","MISC3","MISC4","Q5","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q6","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q7","MISC1","MISC2","MISC3","MISC4"]
[{"$f":"IF(A25=TRUE,\"1\",IF(A26=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE25=TRUE,\"1\",IF(AE26=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AM25=TRUE,\"1\",IF(AM26=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AU25=TRUE,\"1\",IF(AU25=FALSE,\"0\",\"NR\"))","v":"0"},null,null,null,null,{"$f":"IF(AZ25=TRUE,\"1\",IF(AZ26=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CD25=TRUE,\"1\",IF(CD26=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(CL25=TRUE,\"1\",IF(CL25=FALSE,\"0\",\"NR\"))","v":"0"}]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false," ",null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
["SOUTH LINE HAUL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOUTH LOCAL"]
["Q1","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q2","FUEL1","FUEL2A","FUEL2B","FUEL2C","FUEL3","FUEL4","FUEL(AC)","Q3","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q4","MISC1","MISC2","MISC3","MISC4","Q5","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q6","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q7","MISC1","MISC2","MISC3","MISC4"]
[{"$f":"IF(A32=TRUE,\"1\",IF(A33=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE32=TRUE,\"1\",IF(AE33=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AM32=TRUE,\"1\",IF(AM33=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AU32=TRUE,\"1\",IF(AU32=FALSE,\"0\",\"NR\"))","v":"0"},null,null,null,null,{"$f":"IF(AZ32=TRUE,\"1\",IF(AZ33=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CD32=TRUE,\"1\",IF(CD33=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(CL32=TRUE,\"1\",IF(CL32=FALSE,\"0\",\"NR\"))","v":"0"}]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false," ",null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
["NOCENT LINE HAUL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOCENT LOCAL"]
["Q1","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q2","FUEL1","FUEL2A","FUEL2B","FUEL2C","FUEL3","FUEL4","FUEL(AC)","Q3","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q4","MISC1","MISC2","MISC3","MISC4","Q5","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q6","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q7","MISC1","MISC2","MISC3","MISC4"]
[{"$f":"IF(A39=TRUE,\"1\",IF(A40=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE39=TRUE,\"1\",IF(AE40=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AM39=TRUE,\"1\",IF(AM40=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AU39=TRUE,\"1\",IF(AU39=FALSE,\"0\",\"NR\"))","v":"0"},null,null,null,null,{"$f":"IF(AZ39=TRUE,\"1\",IF(AZ40=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CD39=TRUE,\"1\",IF(CD40=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(CL39=TRUE,\"1\",IF(CL39=FALSE,\"0\",\"NR\"))","v":"0"}]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false," ",null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
["MIDWEST LINE HAUL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MIDWEST LOCAL"]
["Q1","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q2","FUEL1","FUEL2A","FUEL2B","FUEL2C","FUEL3","FUEL4","FUEL(AC)","Q3","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q4","MISC1","MISC2","MISC3","MISC4","Q5","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q6","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q7","MISC1","MISC2","MISC3","MISC4"]
[{"$f":"IF(A46=TRUE,\"1\",IF(A47=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE46=TRUE,\"1\",IF(AE47=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AM46=TRUE,\"1\",IF(AM47=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AU46=TRUE,\"1\",IF(AU46=FALSE,\"0\",\"NR\"))","v":"0"},null,null,null,null,{"$f":"IF(AZ46=TRUE,\"1\",IF(AZ47=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CD46=TRUE,\"1\",IF(CD47=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(CL46=TRUE,\"1\",IF(CL46=FALSE,\"0\",\"NR\"))","v":"0"}]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false," ",null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
["SW LINE HAUL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SW LOCAL"]
["Q1","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q2","FUEL1","FUEL2A","FUEL2B","FUEL2C","FUEL3","FUEL4","FUEL(AC)","Q3","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q4","MISC1","MISC2","MISC3","MISC4","Q5","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q6","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q7","MISC1","MISC2","MISC3","MISC4"]
[{"$f":"IF(A53=TRUE,\"1\",IF(A54=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE53=TRUE,\"1\",IF(AE54=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AM53=TRUE,\"1\",IF(AM54=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AU53=TRUE,\"1\",IF(AU53=FALSE,\"0\",\"NR\"))","v":"0"},null,null,null,null,{"$f":"IF(AZ53=TRUE,\"1\",IF(AZ54=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CD53=TRUE,\"1\",IF(CD54=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(CL53=TRUE,\"1\",IF(CL53=FALSE,\"0\",\"NR\"))","v":"0"}]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false," ",null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
["NW LINE HAUL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NW LOCAL"]
["Q1","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q2","FUEL1","FUEL2A","FUEL2B","FUEL2C","FUEL3","FUEL4","FUEL(AC)","Q3","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q4","MISC1","MISC2","MISC3","MISC4","Q5","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q6","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q7","MISC1","MISC2","MISC3","MISC4"]
[{"$f":"IF(A60=TRUE,\"1\",IF(A61=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE60=TRUE,\"1\",IF(AE61=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AM60=TRUE,\"1\",IF(AM61=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AU60=TRUE,\"1\",IF(AU60=FALSE,\"0\",\"NR\"))","v":"0"},null,null,null,null,{"$f":"IF(AZ60=TRUE,\"1\",IF(AZ61=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CD60=TRUE,\"1\",IF(CD61=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(CL60=TRUE,\"1\",IF(CL60=FALSE,\"0\",\"NR\"))","v":"0"}]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false," ",null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[]
[]
["WEST LINE HAUL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WEST LOCAL"]
["Q1","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q2","FUEL1","FUEL2A","FUEL2B","FUEL2C","FUEL3","FUEL4","FUEL(AC)","Q3","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q4","MISC1","MISC2","MISC3","MISC4","Q5","BP1","BP2","Inexp","Inexp","Inexp","Inexp","Inexp","1Year","1Year","1Year","1Year","1Year","3Year","3Year","3Year","3Year","3Year","MostExp","MostExp","MostExp","MostExp","MostExp","BP7",null,null,null,null,null,"BP(AC)","Q6","SAFE1A","SAFE1B","SAFE1C","SAFE1D","SAFE2","SAFE3","SAFE(AC)","Q7","MISC1","MISC2","MISC3","MISC4"]
[{"$f":"IF(A67=TRUE,\"1\",IF(A68=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AE67=TRUE,\"1\",IF(AE68=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AM67=TRUE,\"1\",IF(AM68=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(AU67=TRUE,\"1\",IF(AU67=FALSE,\"0\",\"NR\"))","v":"0"},null,null,null,null,{"$f":"IF(AZ67=TRUE,\"1\",IF(AZ68=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(CD67=TRUE,\"1\",IF(CD68=TRUE,\"0\",\"NR\"))","v":"NR"},null,null,null,null,null,null,null,{"$f":"IF(CL67=TRUE,\"1\",IF(CL67=FALSE,\"0\",\"NR\"))","v":"0"}]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,false]
[false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false," ",null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]