{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Vehicle Hire Prices","Conditional formating","Booking form ","Additional Costs (1)","Additional Costs (2)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":15,"comments":1,"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":"Vehicle Hire Prices","index":0,"n_rows":56,"n_cols":20,"rows_kept":56,"cut":false,"hidden":true,"merged":[[2,11,2,19],[34,11,34,19],[43,11,43,19],[50,11,50,19],[0,1,0,3],[0,11,0,19],[0,4,0,5],[0,7,0,8],[0,9,0,10]]}
[null,"Appendix 7",null,null,"Example Vehicle ",null,null,"Vehicle Description",null,"For Completion by the Supplier",null,"Price of Hire Per Day and Weighted Score"]
[null,"Category","Vehicle Type ","ACRISS Car Classification Code ","Manufacturer","Make","Engine Size","Number of Seats","Number of Doors ","Proposed Manufacturer","Proposed Model","1 Day Hire Price","2 Days Hire Price","3 Days Hire Price","4 Days Hire Price","5 Days Hire Price","6 Days Hire Price","7 Days Hire Price","8 Days - 28 Days Hire Price","28 Days Plus Hire Price"]
[null,"CARS & PEOPLE CARRIERS "]
[null,"Mini","Car","MBMN/Q","Toyota ","Aygo",1,4,"3","Toyota ","Aygo",22.99,22.99,16.97,16.97,16.97,16.97,13.31,13.31,10.25]
[null,"Mini ","Car","MBAN/Q","Toyota ","Aygo",1,4,3,"Toyota ","Aygo",22.99,22.99,16.97,16.97,16.97,16.97,13.31,13.31,10.25]
[null,"Mini","Car","MDMN/Q","Toyota ","Aygo",1,4,"5","Toyota ","Aygo",22.99,22.99,16.97,16.97,16.97,16.97,13.31,13.31,10.25]
[null,"Mini ","Car","MDAN/Q","Toyota ","Aygo",1,4,5,"Toyota ","Aygo",22.99,22.99,16.97,16.97,16.97,16.97,13.31,13.31,10.25]
[null,"Economy","Car","EBMN/Q","Ford","Fiesta",1.4,5,3,"Vauxhall","Corsa",22.99,22.99,16.97,16.97,16.97,16.97,13.31,13.31,10.25]
[null,"Economy","Car","EBAN/Q","Ford","Fiesta",1.4,5,3,"Vauxhall","Corsa",22.99,22.99,16.97,16.97,16.97,16.97,13.31,13.31,10.25]
[null,"Economy","Car","EDMN/Q","Ford","Fiesta",1.4,5,5,"Ford","Fiesta",23.88,23.88,17.420000000000002,17.420000000000002,17.420000000000002,17.420000000000002,13.42,13.42,10.41]
[null,"Economy","Car","EDAN/Q","Ford","Fiesta",1.4,5,5,"Ford","Fiesta",23.88,23.88,17.420000000000002,17.420000000000002,17.420000000000002,17.420000000000002,13.42,13.42,10.41]
[null,"Compact","Car","CBMN/Q","Vauxhall","Astra ",1.6,5,3,"Vauxhall","Astra ",24.29,24.29,18.900000000000002,18.900000000000002,18.900000000000002,18.900000000000002,15.98,15.98,12.25]
[null,"Compact","Car","CBAN/Q","Vauxhall","Astra ",1.6,5,3,"Vauxhall","Astra ",26.29,26.29,20.900000000000002,20.900000000000002,20.900000000000002,20.900000000000002,17.98,17.98,14.14]
[null,"Compact","Car","CDMN/Q","Vauxhall","Astra ",1.6,5,5,"Vauxhall","Astra ",24.29,24.29,18.900000000000002,18.900000000000002,18.900000000000002,18.900000000000002,15.98,15.98,12.25]
[null,"Compact","Car","CDAN/Q","Vauxhall","Astra ",1.6,5,5,"Vauxhall","Astra ",26.29,26.29,20.900000000000002,20.900000000000002,20.900000000000002,20.900000000000002,17.98,17.98,14.14]
[null,"Estate","Car","SDMN/Q","Vauxhall","Insignia Estate",1.8,5,5,"Vauxhall","Insignia Estate",28.25,28.25,23.54,23.54,23.54,23.54,19.07,19.07,15.5]
[null,"Estate","Car","SDAN/Q","Vauxhall","Insignia Estate",1.8,5,5,"Vauxhall","Insignia Estate",28.25,28.25,23.54,23.54,23.54,23.54,19.07,19.07,15.5]
[null,"Intermediate","Car","SDMN/Q","Vauxhall","Insignia",2,5,5,"Vauxhall","Insignia",27.65,27.65,22.5,22.5,22.5,22.5,18.010000000000002,18.010000000000002,14.94]
[null,"Intermediate","Car","SDAN/Q","Vauxhall","Insignia",2,5,5,"Vauxhall","Insignia",31.23,31.23,25.17,25.17,25.17,25.17,21.24,21.24,16.82]
[null,"Large ","Car","CMMN/Q","Citroen","Picasso",1.6,5,5,"Vauxhall","Zafira",31.88,31.88,26.900000000000002,26.900000000000002,26.900000000000002,26.900000000000002,21.66,21.66,20]
[null,"Large ","Car","CMAN/Q","Citroen","Picasso",1.6,5,5,"Vauxhall","Zafira",31.88,31.88,26.900000000000002,26.900000000000002,26.900000000000002,26.900000000000002,21.66,21.66,20]
[null,"4x4 vehicle (for the potential use off road)","Car","SFMN/Q","Land rover","Freelander",2.2000000000000002,5,5,"Nissan","Xtrail",54.56,54.56,45.029999999999994,45.029999999999994,45.029999999999994,45.029999999999994,39.82,39.82,37.19]
[null,"4x4 vehicle (for the potential use off road)","Car","SFAN/Q","Land rover","Freelander",2.2000000000000002,5,5,"Nissan","Xtrail",54.56,54.56,45.029999999999994,45.029999999999994,45.029999999999994,45.029999999999994,39.82,39.82,37.19]
[null,"People Carrier","Car","SVMN/Q","Vauxhall","Zafira",1.8,7,5,"Vauxhall","Zafira",31.88,31.88,26.900000000000002,26.900000000000002,26.900000000000002,26.900000000000002,21.66,21.66,20]
[null,"People Carrier","Car","SVAN/Q","Vauxhall","Zafira",1.8,7,5,"Vauxhall","Zafira",31.88,31.88,26.900000000000002,26.900000000000002,26.900000000000002,26.900000000000002,21.66,21.66,20]
[null,"People Carrier","Car","SVMN/Q","Citroen","Grand C4 Picasso ",2,8,5,"Seat","Alhambra",45,45,38.49,38.49,38.49,38.49,33.19,33.19,27]
[null,"People Carrier","Car","SVAN/Q","Citroen","Grand C4 Picasso ",2,8,5,"Seat","Alhambra",45,45,38.49,38.49,38.49,38.49,33.19,33.19,27]
[null,"People Carrier","Car","LVMN/Q","VW","Transporter",2,9,5,"Renault","Traffic",47,43,35,35,35,35,29,21,29]
[null,"People Carrier","Car","LVAN/Q","VW","Transporter",2,9,5,"Renault","Traffic",47,43,35,35,35,35,29,21,29]
[null,"Luxury","Car","LBMN/Q","Mercedes","E Class",2.1,5,3,"Mercedes","E Class",67.77,67.77,61.98,61.98,61.98,61.98,54.98,54.98,45]
[null,"Luxury","Car","LBAN/Q","Mercedes","E Class",2.1,5,3,"Mercedes","E Class",67.77,67.77,61.98,61.98,61.98,61.98,54.98,54.98,45]
[null,"Luxury","Car","LDMN/Q","Mercedes","E Class",2.1,5,5,"Mercedes","E Class",67.77,67.77,61.98,61.98,61.98,61.98,54.98,54.98,45]
[null,"Luxury","Car","LDAN/Q","Mercedes","E Class",2.1,5,5,"Mercedes","E Class",67.77,67.77,61.98,61.98,61.98,61.98,54.98,54.98,45]
[]
[null,"MINI BUSES"]
[null,"Mini Bus 9 Seater","Mini Bus","XVMN/Q","Ford","Torneo",1.6,9,5,"Renault","Traffic",49,43,35,35,35,35,29,21,21]
[null,"Mini Bus 12 Seater","Mini Bus","XVMN/Q","Ford ","Transit   ",2.2000000000000002,12,5,"Ford ","Transit",90,90,82,82,82,82,72,64,49]
[null,"Mini Bus 14 Seater","Mini Bus","XVMN/Q","Ford ","Transit   ",2.4,14,5,"Ford ","Transit",90,90,82,82,82,82,72,72,66]
[null,"Mini Bus 15 Seater","Mini Bus","XVMN/Q","Ford ","Transit   ",2.4,15,5,"Ford ","Transit",90,90,82,82,82,82,72,72,66]
[null,"Mini Bus 16 Seater","Mini Bus","XVMN/Q","Ford ","Transit   ",2.4,16,5,"Ford ","Transit",90,90,82,82,82,82,72,72,66]
[null,"Mini Bus 17 Seater","Mini Bus","XVMN/Q","Ford ","Transit   ",2.4,17,5,"Ford ","Transit",90,90,82,82,82,82,72,72,66]
[null,"Mini Bus 19 Seater","Mini Bus","XVMN/Q","Ford ","Transit   ",2.4,19,5,"Ford ","Transit",90,90,82,82,82,82,72,72,66]
[]
[null,"VANS"]
[null,"Luton Tail lift","Van","N/A","Ford","Transit Luton with Tail Lift",2.4,3,3,"Ford ","Transit",66.150000000000006,66.150000000000006,59.68,59.68,59.68,59.98,45.36,28.57,25.71]
[null,"Pick Up Truck","Van","N/A","Toyota","Hilux",2.5,5,4,"Ford ","Ranger",35,35,23,23,23,23,18,18,18]
[null,"Van (Small)","Van","N/A","Citroen ","Berlingo",1.6,2,4,"Fiat","Doblo",23.62,23.62,17.32,17.32,17.32,17.32,13.65,12,10.3]
[null,"Van (Medium)","Van","N/A","Vauxhall","Vivaro",2,3,4,"Vauxhall","Vivaro",27.86,27.86,20.6,20.6,20.6,20.6,15.38,15.38,12.65]
[null,"Van (Large)","Van","N/A","Renault ","Master",2.2999999999999998,3,4,"Renault ","Master",32.72,32.72,24.43,24.43,24.43,24.43,20.3,20.3,17]
[]
[null,"LOW EMISSION VEHICLES"]
[null,"Electric/Hybrid Car Mini","Low Emissions","MDAN/I/C","Volkswagen","e-up!","18.7 kWh",4,5,"Toyota ","Aygo",59.95,59.95,55,55,55,55,42.5,42.5,37]
[null,"Electric/Hybrid Car Economy","Low Emissions","EDAN/I/C","Renault","Zoe","45 kWH",5,5,"Toyota ","Aygo",59.95,59.95,55,55,55,55,42.5,42.5,37]
[null,"Electric/Hybrid Car Compact","Low Emissions","CDAN/I/C","Toyota","Prius Plug-In",1.8,5,5,"Honda","Jazz",59.95,59.95,55,55,55,55,42.5,42.5,37]
[null,"Electric/Hybrid Car Intermediate","Low Emissions","IDAN/I/C","Nissan","Leaf","24kWh",5,5,"Nissan","Leaf",59.95,59.95,55,55,55,55,42.5,42.5,37]
[null,"Electric/Hybrid Car Small Van","Low Emissions","N/A","Renault","Kangoo Z.E.","22 kWh",2,5]

{"sheet":"Conditional formating","index":1,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"1 day"]
["Mini, Automatic",22.99,22.99,16.97,16.97,16.97,16.97,13.31,13.31,10.25]
["Mini, Manual ",22.99,22.99,16.97,16.97,16.97,16.97,13.31,13.31,10.25]
["Economy, Automatic",23.88,23.88,17.420000000000002,17.420000000000002,17.420000000000002,17.420000000000002,13.42,13.42,10.41]
["Economy, Manual ",23.88,23.88,17.420000000000002,17.420000000000002,17.420000000000002,17.420000000000002,13.42,13.42,10.41]
["Comact, Automatic",26.29,26.29,20.900000000000002,20.900000000000002,20.900000000000002,20.900000000000002,17.98,17.98,14.14]
["Compact, Manual",24.29,24.29,18.900000000000002,18.900000000000002,18.900000000000002,18.900000000000002,15.98,15.98,12.25]
["Intermediate, Automatic",31.23,31.23,25.17,25.17,25.17,25.17,21.24,21.24,16.82]
["Intermediate, Manual ",27.65,27.65,22.5,22.5,22.5,22.5,18.010000000000002,18.010000000000002,14.94]
["Estate, Automatic",28.25,28.25,23.54,23.54,23.54,23.54,19.07,19.07,15.5]
["Estate, Manual ",28.25,28.25,23.54,23.54,23.54,23.54,19.07,19.07,15.5]
["4x4, Automatic",54.56,54.56,45.029999999999994,45.029999999999994,45.029999999999994,45.029999999999994,39.82,39.82,37.19]
["4x4 Manual ",54.56,54.56,45.029999999999994,45.029999999999994,45.029999999999994,45.029999999999994,39.82,39.82,37.19]
[]
[]
[null,null,null,"00:00:00"]
["Yes","Aberdeen Airport",null,"00:30:00","1.0 litre, Manual, 3 door, 4 seats",22.99]
["No","Belfast City Airport",null,"01:00:00","1.0 litre, Automatic, 3 door, 4 seats",22.99]
[null,"Belfast Int'l Airport",null,"01:30:00","1.4 litre, Manual, 3 door, 5 seats",22.99]
[null,"Birmingham Airport",null,"02:00:00","1.4 litre, Automatic, 3 door, 5 seats",22.99]
[null,"Bristol Airport",null,"02:30:00","1.4 litre, Manual, 5 door, 5 seats",23.88]
[null,"Cardiff Airport",null,"03:00:00","1.4 litre, Automatic, 5 door, 5 seats",23.88]
[null,"East Midlands Airport",null,"03:30:00","1.6 litre, Manual, 5 door, 5 seats",24.29]
[null,"Edinburgh Airport",null,"04:00:00","1.6 litre, Automatic, 5 door, 5 seats",26.29]
[null,"Glasgow Airport",null,"04:30:00","1.8 litre, Estate, Manual, 5 door, 5 seats",28.25]
[null,"Inverness Airport",null,"05:00:00","1.8 litre, Estate, Automatic, 5 door, 5 seats",28.25]
[null,"Leeds Bradford",null,"05:30:00","2.0 litre, Manual, 5 door, 5 seats",27.65]
[null,"Liverpool Airport",null,"06:00:00","2.0 litre, Automatic, 5 door, 5 seats",31.23]
[null,"London Gatwick",null,"06:30:00","2.2 litre, 4x4, Manual, 5 door, 5 seats",54.56]
[null,"London Heathrow",null,"07:00:00","2.2 litre, 4x4, Automatic, 5 door, 5 seats",54.56]
[null,"London Luton",null,"07:30:00","V6, Luton Tail Lift ",66.150000000000006]
[null,"London Stansted ",null,"08:00:00","V1, Small Van, Citroen Berlingo or similar",23.62]
[null,"Manchester Airport",null,"08:30:00","V2, Medium Van, Vauxhall Vivaro or similar",27.86]
[null,"Newcastle Airport",null,"09:00:00","V3, Large Van, Renault Master or similar",32.72]
[null,"Southampton Airport",null,"09:30:00","7 Seats, Manual",31.88]
[null,null,null,"10:00:00","7 Seats, Automatic",31.88]
[null,null,null,"10:30:00","8 Seats, Manual",45]
[null,null,null,"11:00:00","8 Seats, Automatic",45]
[null,null,null,"11:30:00"]
[null,null,null,"12:00:00"]
[null,null,null,"12:30:00","Car"]
[null,null,null,"13:00:00","Van"]
[null,null,null,"13:30:00","MPV"]
[null,null,null,"14:00:00"]
[null,null,null,"14:30:00"]
[null,null,null,"15:00:00"]
[null,null,null,"15:30:00"]
[null,null,null,"16:00:00"]
[null,null,null,"16:30:00"]
[null,null,null,"17:00:00"]
[null,null,null,"17:30:00"]
[null,null,null,"18:00:00"]
[null,null,null,"18:30:00"]
[null,null,null,"19:00:00"]
[null,null,null,"19:30:00"]
[null,null,null,"20:00:00"]
[null,null,null,"20:30:00"]
[null,null,null,"21:00:00"]
[null,null,null,"21:30:00"]
[null,null,null,"22:00:00"]
[null,null,null,"22:30:00"]
[null,null,null,"23:00:00"]
[null,null,null,"23:30:00"]

{"sheet":"Booking form ","index":2,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,0,3,8],[42,0,42,1],[43,0,43,1],[44,0,44,1],[36,0,36,1],[4,5,4,6],[14,2,14,3],[4,0,4,1],[4,7,4,8],[5,0,5,1],[5,2,5,8],[6,2,6,8],[7,0,7,1],[7,3,7,5],[7,6,7,8],[10,0,10,1],[0,0,0,8],[1,0,1,8],[2,0,2,8],[39,0,39,1],[40,0,40,1],[34,0,34,5],[34,6,34,8],[35,6,35,8],[35,0,35,1],[29,5,29,8],[30,0,30,1],[31,0,31,1],[33,6,33,8],[32,6,32,8],[31,6,31,8],[4,2,4,4],[15,4,15,5],[15,0,15,1],[15,2,15,3],[15,6,15,7],[9,0,9,1],[11,0,11,1],[12,0,12,1],[12,2,12,3],[11,2,11,8],[13,0,13,1],[14,0,14,1],[13,2,13,3],[24,0,24,1],[24,2,24,3],[24,4,24,5],[24,6,24,7],[16,0,16,1],[16,2,16,8],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[20,2,20,8],[21,2,21,3],[22,2,22,3],[23,2,23,3],[18,0,18,1],[26,0,26,1],[27,0,27,1],[27,3,27,4],[27,5,27,8],[28,3,28,4],[28,5,28,7]]}
["Car Hire Form "]
["Please complete all sections and return to the Procurement office, forms must be received a minimum of 3 working days before hire start."]
["This form must contain a valid purchase order number and must be signed by at least one of the drivers and the budget holder. Drivers must have completed the Work Related Driving Questionnaire and provided evidence of a valid driving licence within the last 12 months. Hired vehicles must not be used for personal mileage under any circumstance. By signing this form hirers (including any additional drivers) confirm they have read the appropriate sections of the Work Related Driving policy and agree to all terms therein. It is the hirers responsibility to ensure they check the policy for any updates. ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2019-04-16"}]
["http://worcester.ac.uk/finance/752.htm "]
["Name of Main Driver",null,null,null,null,"Driver contact number"]
["Additional Drivers "]
[]
["Number of Passengers",null,null,"Purchase order number "]
[]
["Hire Start"]
["Hire from an Airport?",null,"Yes"]
["Delivery Address "]
["Delivery Postcode"]
["Airport"]
["Flight number"]
["Date",null,null,null,"Time "]
["Destination"]
[]
["Hire End"]
["Return to an Airport",null,"No"]
["Return address"]
["Return Postcode"]
["Airport"]
["Flight number"]
["Date",null,null,null,"Time"]
[]
["Car type",null,"Select vehicle type first "]
["Vehicle Type",null,"Van","Vehicle class",null,"V1, Small Van, Citroen Berlingo or similar"]
[null,null,null,"Cost per 24hr period",null,{"$f":"IFERROR(VLOOKUP(F28,'Conditional formating'!E19:F40,2,FALSE),\" \")","v":23.62}]
[null,null,null,null,null,"Rate discounted for 3+ day hires, see price list"]
["Additional costs"]
["One way surcharge",null,"If vehicle is being returned to a different branch ",null,null,null,10]
[null,null,"If vehicle is being returned to an Airport/Dock",null,null,null,35]
["Airport/Dock supplement",null,"If vehicle is being hired from an Airport/Dock",null,null,null,"+17.5% to overall cost"]
["Abortive delivery collection/late return charge ",null,null,null,null,null,20]
["Refuelling charge",null,"Charged if car is returned without a full tank of fuel",null,null,null,"Pump price +20%"]
["Fines",null,"Any parking/traffic violations will be paid by the driver",null,null,null,null,"£25.00 admin fee + fine"]
["Driver's declaration: I have read and agree to all terms contained within the Work Related Driving Policy"]
[]
["Signed by driver: "]
["Date:"]
[]
["Signed by budget holder"]
["Print name"]
["Date"]

{"sheet":"Additional Costs (1)","index":3,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":true,"merged":[[1,0,1,1],[0,0,0,1]]}
["Additional Charges to be Implemented Under the Vehicle Hire Framework Agreement ",null,"Appendix 7"]
["Fully Comprehensive Insurance Cover (Named  Driver Only) Per Day as Per XXXXXXX Section X"]
["Category","Excess","Cost Per Day"]
["Mini",350,10]
["Economy ",350,10]
["Compact ",350,10]
["Estate",350,10]
["Intermediate",350,10]
["Large",350,10]
["4x4 vehicle (for the potential use off road)",500,15]
["People Carrier (7 Seats)",350,10]
["People Carrier (8 Seats)",350,10]
["People Carrier (9 Seats)",500,15]
["Luxury",500,15]
["Mini Bus (9 Seats)",500,15]
["Mini Bus (12 Seats)",2500,40]
["Mini Bus (14 Seats)",2500,40]
["Mini Bus (15 Seats)",2500,40]
["Mini Bus (17 Seats)",2500,40]
["Mini Bus (19 Seats)",2500,40]
["Luton Taillift",500,15]
["Pick Up Truck",1500,30]
["Van (Small)",350,10]
["Van (Medium)",350,10]
["Van (Large)",500,15]
["Insurance Basket Price ",null,{"$f":"SUM(C4:C25)","v":420}]
["Administrative Charge Description ","Cost Per Notice ","Maximum Amount of Occurrences "]
["Fixed Penalty Notice",25,"Can only be applied once per notice."]
["Penalty Charge Notice ",25,"Can only be applied once per notice."]
["Administrative Charge Description ","Percentage Administrative Charge per Hire Vehicle ","Maximum Amount of Occurrences "]
["Refuelling Charge ","Pump + 20%","Can only be applied once per hire vehicle."]
["Administrative Charge Description ","Cost Per Hire Vehicle ","Maximum Amount of Occurrences "]
["One Way Surcharge (Cars)",10,"Can only be applied once per hire vehicle."]
["One Way Surcharge (Vans) ",10,"Can only be applied once per hire vehicle."]
["One Way Surcharge to Airports/Stations/Docks (Cars)",35,"Can only be applied once per hire vehicle."]
["One Way Surcharge to Airports/Stations/Docks (Vans)",35,"Can only be applied once per hire vehicle."]
["Airport Supplement (Cars)",0.17499999999999999,"Can only be applied once per hire vehicle."]
["Airport Supplement (Vans)",0.17499999999999999,"Can only be applied once per hire vehicle."]
["Station Supplement (Cars)",0.17499999999999999,"Can only be applied once per hire vehicle."]
["Station Supplement (Vans) ",0.17499999999999999,"Can only be applied once per hire vehicle."]
["Dock Supplement (Cars)",0.17499999999999999,"Can only be applied once per hire vehicle."]
["Dock Supplement (Vans)",0.17499999999999999,"Can only be applied once per hire vehicle."]
["Abortive Delivery/Collection Charge ",20,"Can only be applied once per hire vehicle."]
["Late Return Charge",20,"Can only be applied once per hire vehicle."]
["Administrative Charge Description ","Cost Per Claim","Maximum Amount of Occurrences "]
["Insurance Claims Under £1000",25,"Can only be applied once per claim."]
["Insurance Claims Over £1001 - £5000",25,"Can only be applied once per claim."]
["Insurance Claims Over £5000 +",25,"Can only be applied once per claim."]

{"sheet":"Additional Costs (2)","index":4,"n_rows":59,"n_cols":43,"rows_kept":59,"cut":false,"hidden":true,"merged":[[31,14,31,42],[24,0,24,12],[25,0,25,12],[28,14,28,42],[7,0,7,13],[8,0,8,13],[9,0,9,13],[10,0,10,13],[31,0,31,12],[26,0,26,12],[28,0,28,13],[29,0,29,13],[30,0,30,13],[27,0,27,12],[2,0,2,13],[3,0,3,13],[4,0,4,13],[5,0,5,13],[6,0,6,13],[0,14,1,14],[23,0,23,13],[12,0,12,13],[22,0,22,13],[17,0,17,13],[18,0,18,13],[19,0,19,13],[20,0,20,13],[21,0,21,13],[11,0,11,13],[13,0,13,13],[14,0,14,13],[15,0,15,13],[16,0,16,13],[0,0,0,13],[1,0,1,13]]}
["Additional Charges to be Implemented Under the Vehicle Hire Framework Agreement  (appendix 7)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Additional Cost Per Day (Including Roadside and Assistance Cover"]
["Additional Cost for Taking Hire Vehicles Outside of the UK (but within Europe) (This cost is in addition to the Vehicle Hire Day Rates in tab Hire)"]
["Mini",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Economy ",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Compact ",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Estate",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Intermediate",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Large",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["4x4 vehicle (for the potential use off road)",null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["People Carrier (7 Seats)",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["People Carrier (8 Seats)",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["People Carrier (9 Seats)",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Luxury",null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["Mini Bus (9 Seats)",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
["Mini Bus (12 Seats)",null,null,null,null,null,null,null,null,null,null,null,null,null,25]
["Mini Bus (14 Seats)",null,null,null,null,null,null,null,null,null,null,null,null,null,25]
["Mini Bus (15 Seats)",null,null,null,null,null,null,null,null,null,null,null,null,null,25]
["Mini Bus (17 Seats)",null,null,null,null,null,null,null,null,null,null,null,null,null,25]
["Mini Bus (19 Seats)",null,null,null,null,null,null,null,null,null,null,null,null,null,25]
["Luton Taillift",null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["Pick Up Truck",null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["Van (Small)",null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["Van (Medium)",null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["Van (Large)",null,null,null,null,null,null,null,null,null,null,null,null,null,15]
["Discounts",null,null,null,null,null,null,null,null,null,null,null,null,"Discount %"]
["Discount for End User Collecting the Hire Vehicle from Branch Within The Need To Be Collected in a Vehicle by the Supplier ",null,null,null,null,null,null,null,null,null,null,null,null,"5 (Subject to agreed Volumes)"]
["Discount for End User Returning the Hire Vehicle to the Branch without the Need To Be Dropped Off in a Vehicle by the Supplier ",null,null,null,null,null,null,null,null,null,null,null,null,"5 (Subject to agreed Volumes)","1 Day","2 Days ","3 Days ","4 Days ","5 Days ","6 Days ","7 Days ","8 Days ","9 Days ","10 Days ","11 Days ","12 Days ","13 Days ","14 Days ","15 Days ","16 Days ","17 Days ","18 Days ","19 Days ","20 Days ","21 Days ","22 Days ","23 Days ","24 Days ","25 Days ","26 Days ","27 Days ","28 Days ","28 + Days "]
["Discount for using the Suppliers Online Booking Tool",null,null,null,null,null,null,null,null,null,null,null,null,0]
[" Additional Equipment Charges"]
["Sat Nav Per Day",null,null,null,null,null,null,null,null,null,null,null,null,null,10,10,10,10,10,10,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Air Conditioning Per Day",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Additional Vehicles Available for Hire ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Price per Vehicle Per Day"]
["Category","Group","SIPP","Transmission","Fuel","Example Manufacturer","Example Make","Engine Size","Number of Seats","Number of Doors ","Number of Adult Passengers ","Number of Child Passengers ","Average Size Suitcase","Average Size Travel Bag","1 Day","2 Days ","3 Days ","4 Days ","5 Days ","6 Days ","7 Days ","8 Days ","9 Days ","10 Days ","11 Days ","12 Days ","13 Days ","14 Days ","15 Days ","16 Days ","17 Days ","18 Days ","19 Days ","20 Days ","21 Days ","22 Days ","23 Days ","24 Days ","25 Days ","26 Days ","27 Days ","28 Days ","28 + Days "]
["17t Flatbed",null,null,null,null,null,null,null,null,null,null,null,null,null,85,85,65,65,65,65,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55]
["17t Curtainsider",null,null,null,null,null,null,null,null,null,null,null,null,null,85,85,65,65,65,65,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55]
["17t Curtainsider with Tail Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,87,87,67,65,65,65,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57]
["17t Box Van",null,null,null,null,null,null,null,null,null,null,null,null,null,85,85,65,65,65,65,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55]
["17t Box Van with Tail Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,87,87,67,65,65,65,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57,57]
["17t Dropside 4x2",null,null,null,null,null,null,null,null,null,null,null,null,null,85,85,65,65,65,65,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55,55]
["38t Tractor Unit",null,null,null,null,null,null,null,null,null,null,null,null,null,95,95,75,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65]
["38t Tractor Unit with Sleeper Cab",null,null,null,null,null,null,null,null,null,null,null,null,null,95,95,75,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65]
["44t 6x2 Tractor Unit with Sleeper -cab",null,null,null,null,null,null,null,null,null,null,null,null,null,95,95,75,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65]
["48t 6x4 Tractor Unit with Sleeper - cab",null,null,null,null,null,null,null,null,null,null,null,null,null,95,95,75,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65]
["Tandem Axle 40ft Box van Trailer",null,null,null,null,null,null,null,null,null,null,null,null,null,90,90,90,65,65,65,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
["Tri Axle 40ft Box Van Trailer",null,null,null,null,null,null,null,null,null,null,null,null,null,90,90,90,65,65,65,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
["Tandem Axle 40ft Curtainsider Trailer",null,null,null,null,null,null,null,null,null,null,null,null,null,90,90,90,65,65,65,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
["Tri-Axle 40ft Curtainsider Trail",null,null,null,null,null,null,null,null,null,null,null,null,null,90,90,90,65,65,65,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
["Tandem Axle 40ft Flatbed Trailer with ISO Twistlocks",null,null,null,null,null,null,null,null,null,null,null,null,null,90,90,90,65,65,65,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
["Tri Axle 40ft Flatbed Trailer with ISO Twistlocks",null,null,null,null,null,null,null,null,null,null,null,null,null,90,90,90,65,65,65,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
["Tandem Axle 40ft Flatbed Trailer ",null,null,null,null,null,null,null,null,null,null,null,null,null,90,90,90,65,65,65,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
["Tri Axle 40ft Flatbed Trailer",null,null,null,null,null,null,null,null,null,null,null,null,null,90,90,90,65,65,65,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90,90]
["3.5t Refrigerated Van ",null,null,null,null,null,null,null,null,null,null,null,null,null,105,105,60,65,65,65,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,40,40]
["7.5t Refrigerated Box Van",null,null,null,null,null,null,null,null,null,null,null,null,null,145,145,85,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,65,55,55]
["7.5t GVW 4x2 Chassis cab with Box Van Body",null,null,null,null,null,null,null,null,null,null,null,null,null,75,75,55,65,65,65,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45]
["7.5t GVW 4x2 Chassis cab with Dropside Body",null,null,null,null,null,null,null,null,null,null,null,null,null,72,72,52,65,65,65,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42,42]
["7.5t GVW 4x2 Chassis cab with Curtainsided Body",null,null,null,null,null,null,null,null,null,null,null,null,null,75,75,55,65,65,65,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45]
["7.5t GVW 4x2 Chassis cab with Box van Body with Tail Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,77,77,57,65,65,65,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47]
["7.5t GVW 4x2 Chassis cab with Dropside Body with Tail Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,75,75,55,65,65,65,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45,45]
["7.5t GVW 4x2 Chassis cab with Curtainsided Body with tail Lift",null,null,null,null,null,null,null,null,null,null,null,null,null,77,77,57,65,65,65,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47,47]