{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Van_Hire","Sheet2","Sheet3"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Van_Hire","index":0,"n_rows":74,"n_cols":38,"rows_kept":74,"cut":false,"hidden":false,"merged":[[1,1,3,30],[75,2,81,28],[70,3,70,6],[70,7,70,8],[56,6,56,10],[56,3,56,5],[59,17,59,19],[59,20,59,21],[65,6,65,7],[16,19,16,20],[16,21,16,22],[16,23,16,24],[16,9,16,10],[16,11,16,12],[16,13,16,14],[16,15,16,16],[16,17,16,18],[19,21,20,22],[19,23,20,24],[17,9,18,10],[19,9,20,10],[17,11,18,12],[17,13,18,14],[17,15,18,16],[17,3,18,8],[19,3,20,8],[15,9,15,24],[9,16,10,20],[9,4,10,8],[11,15,11,21],[11,3,11,9],[17,17,18,18],[17,19,18,20],[17,21,18,22],[17,23,18,24],[19,11,20,12],[19,13,20,14],[19,15,20,16],[19,17,20,18],[19,19,20,20],[27,3,27,5],[27,6,27,7],[27,10,27,11],[31,3,31,5],[31,6,31,7],[31,10,31,11]]}
[]
[null,"Straight Line Modelling"]
[]
[]
[]
[null,null,"John is looking to hire a van. He has decided between to companies Rent-A-Van and Vans are Us.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rent-A-Van",null,null,"Vans-R-Us"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"$AF$10/100*AH7+$AF$9","v":100},null,0,{"$f":"$AF$12/100*AK7+$AF$11","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"$AF$10/100*AH8+$AF$9","v":107},null,20,{"$f":"$AF$12/100*AK8+$AF$11","v":36}]
[null,null,null,null,null,null,null,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":"ROUND(RAND()*(13-8)+8,0)*10","v":100},null,40,114,null,40,52]
[null,null,null,null,"Rent - A - Van",null,null,null,null,null,null,null,null,null,null,null,"Vans R Us",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-4)+4,0)*5","v":35},null,60,121,null,60,68]
[null,null,null,null,null,null,null,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":"ROUND(RAND()*(3-1)+1,0)*10","v":20},null,80,128,null,80,84]
[null,null,null,{"$f":"\"£ \"&AF9&\" plus + \"&AF10&\"p per miles\"","v":"£ 100 plus + 35p per miles"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"£ \"&AF11&\" plus + \"&AF12&\"p per miles\"","v":"£ 20 plus + 80p per miles"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(24-13)+13,0)*5","v":80},null,100,135,null,100,100]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,142,null,120,116]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,149,null,140,132]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,160,156,null,160,148]
[null,null,null,null,null,null,null,null,null,"Miles travelled",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,180,163,null,180,164]
[null,null,null,null,null,null,null,null,null,0,null,{"$f":"AH9","v":40},null,{"$f":"AH11","v":80},null,{"$f":"AH12","v":100},null,{"$f":"AH15","v":160},null,{"$f":"AH17","v":200},null,{"$f":"AH22","v":300},null,{"$f":"AH24","v":340},null,null,null,null,null,null,null,null,null,200,170,null,200,180]
[null,null,null,"Rent - A - Van         Cost £",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,177,null,220,196]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,240,184,null,240,212]
[null,null,null,"Vans R Us              Cost £",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,260,191,null,260,228]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,280,198,null,280,244]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,205,null,300,260]
[null,"(a)   Copy and complete the table above.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,320,212,null,320,276]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,340,219,null,340,292]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,360,226,null,360,308]
[null,"(b)   Find a formula for the cost C of hiring a van from Rent-A-Van for M 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,380,233,null,380,324]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400,240,null,400,340]
[null,null,null,"Answer C =",null,null,null,null,null,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":"AF10/100","v":0.35},"M","+",{"$f":"AF9","v":100}]
[null,null,null,null,null,null,null,null,null,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":"AF12/100","v":0.8},"M","+",{"$f":"AF11","v":20}]
[null,"(c)   Find a formula for the cost C of hiring a van from Van R Us for M 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,{"$f":"(AH29-AH28)","v":0.45000000000000007},null,null,{"$f":"AK28-AK29","v":80}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK30/AH30","v":177.77777777777774}]
[null,null,null,"Answer C =",null,null,null,null,null,null,null,null,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":"ROUND(AK31,0)","v":178}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AH28*AK32+AK28","v":162.30000000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUND(AK33,2)","v":162.30000000000001}]
[null,"(d)   On the graph plot the cost C against the numbers days hire M miles for each company."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"(e)  (i)  John was going to cover a total of \"&AF55&\" miles which company should he use.\"","v":"(e)  (i)  John was going to cover a total of 324 miles which company should he use."},null,null,null,null,null,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(AI55=1,ROUND(RAND()*(400-(AH55+10))+(AH55+10),0),ROUND(RAND()*((AH55-10)-15)+15,0))","v":324},null,{"$f":"AK32","v":178},{"$f":"ROUND(RAND()*(1-0)+0,0)","v":1}]
[]
[null,null,null,"Company =",null,null,null,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(AI57=1,\"Vans-R-Us\",\"Rent-A-Van\")","v":"Rent-A-Van"}]
[null,null,null,null,null,null,null,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":"AF55*AH28+AK28","v":213.39999999999998}]
[null,null,null,null,null,null,null,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":"AF55*AH29+AK29","v":279.2}]
[null,null,"(ii) To the nearest pound, how much will John save.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saving = £ ",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF58<AF59,ROUND(AF59-AF58,0),ROUND(AF58-AF59,0))","v":66}]
[]
[]
[null,"(f)  (i) By solving algebracially, find to the nearest mile the distance were it would make no difference"]
[null,null,"which company John used."]
[]
[null,null,null,"Answer =",null,null,null,null,"miles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK32","v":178}]
[]
[]
[null,null,"(ii) What would the cost be for this mileage to the nearest pound."]
[]
[null,null,null,"Answer =  £  ",null,null,null,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":"ROUND(AK34,0)","v":162}]
[]
[]
[null,"(g)   Looking at your graphs in part (d) write a paragraph to summaries what conclusion John should come to."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}