{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["School Trip"],"not_rendered":{"charts":0,"images":0,"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":"School Trip","index":0,"n_rows":54,"n_cols":54,"rows_kept":54,"cut":false,"hidden":false,"merged":[[48,22,48,25],[37,27,37,30],[29,30,29,32],[33,27,33,30],[33,33,33,36],[34,27,34,30],[34,33,34,36],[1,1,5,42],[19,4,19,9],[14,4,14,13],[19,10,19,13],[15,4,15,9],[16,4,16,9],[17,4,17,9],[15,10,15,13],[16,10,16,13],[17,10,17,13],[18,4,18,9],[18,10,18,13],[14,23,14,32],[15,23,15,28],[15,29,15,32],[16,23,16,28],[16,29,16,32],[17,23,17,28],[17,29,17,32],[18,23,18,28],[18,29,18,32],[23,28,23,30],[23,38,23,40],[19,23,19,28],[19,29,19,32],[21,23,21,25],[21,33,21,35]]}
[]
[null,"N4 Lifeskills - School Trip Budget                                                                                                                                                                   Created by Mr.Lafferty@mathsrevision.com "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(12-6)+6,0)*4","v":40}]
[]
[]
[null,null,null,{"$f":"\"Twins Jack and Victor want to go on a school trip to New York. Their mum says that they can BUT they need to pay the cost themselves.\"","v":"Twins Jack and Victor want to go on a school trip to New York. Their mum says that they can BUT they need to pay the cost themselves."}]
[null,null,null,{"$f":"\"The cost of the trip is £\"&AZ51&\" per pupil and they have \"&AZ5&\" weeks to save for their trip.\"","v":"The cost of the trip is £650 per pupil and they have 40 weeks to save for their trip."}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AZ21+ROUND(RAND()*(20-8)+8,0)","v":19.5}]
[null,null,null,{"$f":"\"Q1. Jack and Victor both get £\"&TEXT(AZ12,\"0.00\")&\" a week in pocket money. They decide to make up a spreadsheet to see how much they spend each week.\"","v":"Q1. Jack and Victor both get £19.50 a week in pocket money. They decide to make up a spreadsheet to see how much they spend each week."}]
[]
[null,null,null,null,"Jack",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Victor"]
[null,null,null,null,"Sweets",null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(AZ16,\"0.00\"))","v":"£2.00"},null,null,null,null,null,null,null,null,null,null,null,null,"Treats",null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(BA16,\"0.00\"))","v":"£2.50"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-1)+1,0)*0.5","v":2},{"$f":"ROUND(RAND()*(8-1)+1,0)*0.5","v":2.5}]
[null,null,null,null,"Gym membership",null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(AZ17,\"0.00\"))","v":"£3.50"},null,null,null,null,null,null,null,null,null,null,null,null,"Cinema",null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(BA17,\"0.00\"))","v":"£3.50"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-1)+1,0)*0.5","v":3.5},{"$f":"ROUND(RAND()*(8-6)+6,0)*0.5","v":3.5}]
[null,null,null,null,"Running Club",null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(AZ18,\"0.00\"))","v":"£1.00"},null,null,null,null,null,null,null,null,null,null,null,null,"Orienteering Club",null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(BA18,\"0.00\"))","v":"£0.50"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0.5]
[null,null,null,null,"Football Game",null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(AZ19,\"0.00\"))","v":"£0.50"},null,null,null,null,null,null,null,null,null,null,null,null,"Swimming",null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(BA19,\"0.00\"))","v":"£3.00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.5,3]
[null,null,null,null,"Golf ",null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(AZ20,\"0.00\"))","v":"£2.50"},null,null,null,null,null,null,null,null,null,null,null,null,"Basketball Game",null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(BA20,\"0.00\"))","v":"£1.00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2.5,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(AZ16:AZ20)","v":9.5},{"$f":"SUM(BA16:BA20)","v":10.5}]
[null,null,null,"(a)  Calculate the total each spend each week.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jack's Total",null,null,null,null,null,null,null,null,null,"Victor's Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ12-AZ21","v":10},{"$f":"AZ12-BA21","v":9}]
[]
[null,null,null,{"$f":"\"(b) If they save the same each week how much could they save after \"&AZ5&\" weeks.\"","v":"(b) If they save the same each week how much could they save after 40 weeks."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jack's Total",null,null,null,null,null,null,null,null,null,"Victor's Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",{"$f":"AZ22*AZ5","v":400},{"$f":"BA22*AZ5","v":360},"V"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ5/ROUND(RAND()*(2-1)+1,1),0)","v":31}]
[null,null,null,{"$f":"\"Q2. With \"&AZ27&\" weeks to go Jack decides to get a job delivering newspapers to help to pay for the trip.\"","v":"Q2. With 31 weeks to go Jack decides to get a job delivering newspapers to help to pay for the trip."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(2-1)+1,1)*100","v":130},null,{"$f":"ROUND(RAND()*(1-0)+0,0)","v":0}]
[null,null,null,null,{"$f":"\"Jack delivers \"&AZ28&\" papers a week. He gets £\"&TEXT(AZ29,\"0.00\")&\" per paper. How much will he earn towards his trip ?\"","v":"Jack delivers 130 papers a week. He gets £0.07 per paper. How much will he earn towards his trip ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(0.1-0.04)+0.04,2)","v":7.0000000000000007E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",{"$f":"AZ28*AZ29*AZ27","v":282.10000000000002}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(6-1)+1,0)","v":1}]
[null,null,null,{"$f":"\"Q3. With \"&AZ33&\" weeks to go Victor decides to wash cars every weekend.\"","v":"Q3. With 1 weeks to go Victor decides to wash cars every weekend."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wash Only",null,null,null,null,null,"Wash + Polish",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(16-8)+8,0)","v":14},"wash ",{"$f":"ROUND(RAND()*(1.8-1.2)+1.2,1)","v":1.4}]
[null,null,null,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":"CONCATENATE(\"£\",TEXT(BB34,\"0.00\"))","v":"£1.40"},null,null,null,null,null,{"$f":"CONCATENATE(\"£\",TEXT(BB35,\"0.00\"))","v":"£2.60"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(15-4)+4,0)","v":10},"polish",{"$f":"ROUND(RAND()*(3.2-2.5)+2.5,1)","v":2.6}]
[null,null,null,null,{"$f":"\"On average each week he washes \"&AZ34&\" cars and washes + polishes \"&AZ35&\" cars.\"","v":"On average each week he washes 14 cars and washes + polishes 10 cars."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V",{"$f":"(AZ34*BB34+AZ35*BB35)*AZ33","v":45.599999999999994}]
[]
[null,null,null,null,{"$f":"\"How much does he earn towards his trip ?\"","v":"How much does he earn towards his trip ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,282.10000000000002]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jack","Victor"]
[null,null,null,{"$f":"\"Jack and Victor decide to arrange a car boot sale to sell their old stuff they no longer need.\"","v":"Jack and Victor decide to arrange a car boot sale to sell their old stuff they no longer need."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AZ30+AZ24","v":682.1},{"$f":"AZ36+BA24","v":405.6}]
[]
[null,null,null,{"$f":"\"Jack earns £\"&AZ43&\" and Victor earns £\"&AZ44&\".\"","v":"Jack earns £65 and Victor earns £250."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",{"$f":"ROUND(RAND()*(20-10)+10,0)*5","v":65}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V",{"$f":"ROUND(RAND()*(50-21)+21,0)*5","v":250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",{"$f":"AZ41+AZ43","v":747.1}]
[null,null,null,{"$f":"\"Jack has his birthday before the trip and gets £\"&AZ47&\"\"","v":"Jack has his birthday before the trip and gets £115"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V",{"$f":"BA41+AZ44","v":655.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(40-21)+21,0)*5","v":115}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"J",{"$f":"AZ45+AZ47","v":862.1}]
[null,null,null,{"$f":"\"Who has made enough money to go on the trip ?\"","v":"Who has made enough money to go on the trip ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Jack or Victor or Both)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V",{"$f":"AZ46","v":655.6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(2-1)+1,0)","v":1},{"$f":"IF(AZ48<AZ49,AZ48,AZ49)","v":655.6},{"$f":"IF(AZ48>AZ49,AZ48,AZ49)","v":862.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(AZ50=1,ROUNDDOWN(BA50,-1),IF(AZ50=2,ROUNDDOWN(BB50,-1),0))","v":650},{"$f":"IF(AZ49=BA50,\"Victor\",\"Jack\")","v":"Victor"},{"$f":"IF(AZ49=BB50,\"Victor\",\"Jack\")","v":"Jack"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BA50>=AZ51,1,0)","v":1},{"$f":"IF(BB50>=AZ51,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"CONCATENATE(BA52,BB52)","v":"11"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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(BA53=\"11\",\"Both\",BB51)","v":"Both"}]