{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Q1_Q6","Q7_Q13","Q14_Q18"],"not_rendered":{"charts":4,"images":18,"macros":1,"external_links":0,"defined_names":3,"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":"Q1_Q6","index":0,"n_rows":109,"n_cols":41,"rows_kept":109,"cut":false,"hidden":false,"merged":[[2,1,3,33],[55,10,55,16],[56,10,56,16],[54,17,54,18],[54,19,54,20],[42,3,47,32],[56,23,56,24],[27,3,32,32],[25,21,25,24],[40,21,40,24],[10,16,10,19],[12,3,17,32],[53,3,53,9],[53,10,53,16],[54,3,54,9],[55,3,55,9],[54,10,54,16],[54,21,54,22],[53,17,53,24],[54,23,54,24],[55,17,55,18],[55,19,55,20],[55,21,55,22],[55,23,55,24],[101,3,105,32],[84,15,84,19],[56,17,56,18],[56,19,56,20],[56,21,56,22],[99,21,99,24],[86,3,91,32],[73,22,74,24],[80,15,80,17],[76,19,77,21],[84,21,84,24],[60,3,65,32],[72,12,72,20],[56,3,56,9]]}
[]
[]
[null,"National 4 Numeracy Practice"]
[]
[]
[null,{"$f":"\"Q1.   Emma-Louise bought a new lamp for her room. The price was £\"&AK6&\" + VAT.\"","v":"Q1.   Emma-Louise bought a new lamp for her room. The price was £40 + VAT."},null,null,null,null,null,null,null,null,null,null,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()*(50-2)+2,0)*10","v":40}]
[]
[null,null,null,"VAT is charged at 20%."]
[]
[]
[null,null,null,"What was the total price?",null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,"Money 1.1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.2*AK6+AK6","v":48}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q2.  An empty tin has a weight of \"&AK21&\" g.\"","v":"Q2.  An empty tin has a weight of 320 g."},null,null,null,null,null,null,null,null,null,null,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()*(50-2)+2,0)*10","v":320}]
[null,null,{"$f":"\"   When \"&AK22&\" marbles are put into it, it has a weight of \"&AK24&\" g.\"","v":"   When 30 marbles are put into it, it has a weight of 1040 g."},null,null,null,null,null,null,null,null,null,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()*(5-2)+2,0)*10","v":30}]
[null,null,null,null,null,null,null,null,null,null,null,null,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()*(30-11)+11,0)","v":24}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK23*AK22+AK21","v":1040}]
[]
[null,null,null,"What is the weight of one marble ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"g",null,"Measure 1.1",null,null,null,null,null,null,null,null,{"$f":"AK23","v":24}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q3.  Daniel is going to \"&AN41&\" on holiday.\"","v":"Q3.  Daniel is going to Holland on holiday."},null,null,null,null,null,null,null,null,null,null,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()*(20-3)+3,0)*50","v":350},{"$f":"ROUND(RAND()*(5-1)+1,0)","v":3},1,"France"]
[null,null,null,null,null,null,null,null,null,null,null,null,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,2)","v":1.97},null,2,"Belgium"]
[null,null,{"$f":"\"   How much currency will he get for £ \"&AK36","v":"   How much currency will he get for £ 350"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Holland"]
[null,null,{"$f":"\"   when the exchange rate is \"&AK37&\" euros to a pound?\"","v":"   when the exchange rate is 1.97 euros to a pound?"},null,null,null,null,null,null,null,null,null,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":"AK36*AK37","v":689.5},null,4,"Germany"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Spain"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"€",null,"Money 1.1",null,null,null,null,null,null,null,null,{"$f":"AK39","v":689.5},null,null,{"$f":"LOOKUP(AL36,AM36:AM40,AN36:AN40)","v":"Holland"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,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(AK55,\":\",AL55)","v":"16:15"},null,{"$f":"CONCATENATE(AM55,\":\",AN55)","v":"21:20"}]
[null,{"$f":"\"Q4.  Complete the following table which shows departure and arrival times\"","v":"Q4.  Complete the following table which shows departure and arrival times"},null,null,null,null,null,null,null,null,null,null,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(AK54,\":\",AL54)","v":"13:20"},null,{"$f":"CONCATENATE(AM54,\":\",AN54)","v":"19:15"}]
[null,null,"   for different bus journeys.",null,null,null,null,null,null,null,null,null,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(\"0\",AK53,\":\",AL53)","v":"01:40"},null,{"$f":"CONCATENATE(\"0\",AM53,\":\",AN53)","v":"04:50"}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"ROUND(RAND()*(11-2)+2,0)*5","v":40},{"$f":"ROUND(RAND()*(5-4)+4,0)","v":4},{"$f":"ROUND(RAND()*(11-2)+2,0)*5","v":50}]
[null,null,null,"Depart",null,null,null,null,null,null,"Arrive",null,null,null,null,null,null,"Time Taken",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(15-13)+13,0)","v":13},{"$f":"ROUND(RAND()*(11-2)+2,0)*5","v":20},{"$f":"ROUND(RAND()*(19-17)+17,0)","v":19},{"$f":"ROUND(RAND()*(11-2)+2,0)*5","v":15}]
[null,null,null,{"$f":"AK56","v":"01:40"},null,null,null,null,null,null,{"$f":"AL56","v":"04:50"},null,null,null,null,null,null,null,null,"hrs",null,null,null,"mins",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(18-13)+13,0)","v":16},{"$f":"ROUND(RAND()*(11-2)+2,0)*5","v":15},{"$f":"ROUND(RAND()*(23-20)+20,0)","v":21},{"$f":"ROUND(RAND()*(11-2)+2,0)*5","v":20}]
[null,null,null,{"$f":"AK57","v":"13:20"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AN57","v":5},null,"hrs",null,{"$f":"AO57","v":55},null,"mins",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK52","v":"01:40"},{"$f":"AM52","v":"04:50"},{"$f":"AL56-AK56","v":"03:10:00"},{"$f":"HOUR(AM56)","v":3},{"$f":"MINUTE(AM56)","v":10}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"AL58","v":"21:20"},null,null,null,null,null,null,{"$f":"AN58","v":5},null,"hrs",null,{"$f":"AO58","v":5},null,"mins",null,null,null,null,"Time 1.1",null,null,null,null,null,null,null,{"$f":"AK51","v":"13:20"},{"$f":"AM51","v":"19:15"},{"$f":"AL57-AK57","v":"05:55:00"},{"$f":"HOUR(AM57)","v":5},{"$f":"MINUTE(AM57)","v":55}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK50","v":"16:15"},{"$f":"AM50","v":"21:20"},{"$f":"AL58-AK58","v":"05:05:00"},5,5]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AM51","v":"19:15"}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK58","v":"16:15"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q5. The diagram shows a room which is made up of two rectangles.\"","v":"Q5. The diagram shows a room which is made up of two rectangles."},null,null,null,null,null,null,null,null,null,null,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()*(5-2)+2,0)","v":4},{"$f":"CONCATENATE(AK69,\" m\")","v":"4 m"}]
[null,null,{"$f":"\"  The owner bought a \"&AK73&\" m roll of decorative border which is to\"","v":"  The owner bought a 59 m roll of decorative border which is to"},null,null,null,null,null,null,null,null,null,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":"AK69*ROUND(RAND()*(4-2)+2,0)","v":8},{"$f":"CONCATENATE(AK70,\" m\")","v":"8 m"}]
[null,null,"   go all round the walls of the room near the ceiling.",null,null,null,null,null,null,null,null,null,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":"2*AK70","v":16},"16 m"]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK69+AK69+AK69+AK70+AK70+AK71+(AK71-AK69)","v":56},{"$f":"ROUND(RAND()*(1-0)+0,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL71","v":"16 m"},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(AL72=1,AK72+ROUND(RAND()*(5-1)+1,0),AK72-ROUND(RAND()*(5-1)+1,0))","v":59}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL69","v":"4 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AL72=0,\"No\",\"Yes\")","v":"Yes"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AL70","v":"8 m"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W74","v":"4 m"}]
[]
[null,null,null,"Is the roll long enough for the room? Justify your answer by calculation."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer :",null,null,null,null,null,null,null,null,null,null,null,null,"Measure 1.1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q6.  A train travels at a constant speed of \"&AK96&\" mph for \"&AK95&\" minutes.\"","v":"Q6.  A train travels at a constant speed of 60 mph for 15 minutes."},null,null,null,null,null,null,null,null,null,null,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)*15","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,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()*(14-3)+3,0)*6","v":60}]
[]
[null,null,{"$f":"\"   How far does the train travel in this time?\"","v":"   How far does the train travel in this time?"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Time /"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"miles",null,null,"Measure 1.1",null,null,null,null,null,null,null,{"$f":"AK96*AK95/60","v":15}]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"Q7_Q13","index":1,"n_rows":137,"n_cols":46,"rows_kept":137,"cut":false,"hidden":false,"merged":[[63,21,63,24],[63,25,63,28],[65,19,65,31],[102,3,107,32],[129,1,134,33],[115,18,115,21],[98,24,98,25],[98,29,98,30],[100,24,100,26],[100,22,100,23],[67,3,72,32],[80,18,80,23],[80,24,80,26],[82,18,82,23],[82,24,82,26],[1,1,2,33],[45,3,50,32],[56,4,56,17],[56,18,56,32],[43,21,43,24],[9,16,9,19],[11,3,16,32],[23,21,23,24],[25,3,30,32],[34,18,34,19],[35,18,35,19]]}
[]
[null,"National 4 Numeracy Practice"]
[null,null,null,null,null,null,null,null,null,null,null,null,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()*(1-0)+0,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,{"$f":"ROUND(RAND()*(8-2)+2,0)","v":3}]
[null,{"$f":"\"Q7.   Jack & Victor split £ \"&AK7&\" in the ratio of  \"&AK4&\" : \"&AK5&\".\"","v":"Q7.   Jack & Victor split £ 165 in the ratio of  3 : 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,{"$f":"IF(AK3=0,AK4+1,AK4-1)","v":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,{"$f":"AK4+AK5","v":5}]
[null,null,null,{"$f":"\"Victor gets £\"&AK10&\" . Is this correct justify your answer by calculation.\"","v":"Victor gets £67 . Is this correct justify your answer by calculation."},null,null,null,null,null,null,null,null,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()*(58-6)+6,0)*AK6","v":165}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK7/AK6","v":33}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK8*AK4","v":99}]
[null,null,null,null,null,null,null,null,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,{"$f":"IF(AK3=0,AK8*AK5,AK8*AK5+1)","v":67}]
[null,null,null,null,null,null,null,null,null,null,null,null,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(AK3=0,\"Yes\",\"No\")","v":"No"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q8.  A gas is cooled from \"&AK20&\" °C to \"&AK21&\" °C.\"","v":"Q8.  A gas is cooled from 15 °C to -8 °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,null,null,{"$f":"ROUND(RAND()*(20-8)+8,0)","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,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()*((-8)-(-25))+(-25),0)","v":-8}]
[null,null,"   By how many degrees has its temperature dropped?"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dropped by =",null,null,null,null,null,null,null,null,null,"oC",null,null,null,null,null,null,null,null,null,null,{"$f":"AK20-AK21","v":23}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q9.  How much more petrol is needed to fill the petrol can to 4 litres ?.\"","v":"Q9.  How much more petrol is needed to fill the petrol can to 4 litres ?."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3.6-0.4)+0.4,1)","v":2.2999999999999998}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"litres",null,null,null,null,null,null,null,null,null,null,{"$f":"4-S35","v":1.7000000000000002}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q10.  Two shops are selling the same model of Laptop. \"","v":"Q10.  Two shops are selling the same model of Laptop. "},null,null,null,null,null,null,null,null,null,null,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-3)+3,0)*50","v":150}]
[null,null,null,"They are offering these for sale with different deals.",null,null,null,null,null,null,null,null,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(AK53=0,AK54-50,AK54+50)","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,null,null,null,{"$f":"ROUND(RAND()*(60-40)+40,1)","v":54.3}]
[null,null,null,null,"Shop A",null,null,null,null,null,null,null,null,null,null,null,null,null,"Shop B",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK56+ROUND(RAND()*(10-7)+7,1)","v":62.099999999999994}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK54+6*AK56","v":475.79999999999995}]
[null,null,null,null,null,{"$f":"\"Deposit £\"&TEXT(AK54,0)","v":"Deposit £150"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Deposit £\"&TEXT(AK55,0)","v":"Deposit £100"},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AK55+6*AK57","v":472.59999999999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,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(AK59>AK58,\"A\",IF(AK59=AK58,\"SAME\",\"B\"))","v":"B"}]
[null,null,null,null,null,{"$f":"\"6 payments of £\"&TEXT(AK56,\"0.00\")","v":"6 payments of £54.30"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"6 payments of £\"&TEXT(AK57,\"0.00\")","v":"6 payments of £62.10"}]
[]
[null,null,null,"Which shop has the cheaper deal?"]
[null,null,null,"Justify your answer by calculation.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Shop"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( Answer A , B or SAME )"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q11. Measure the length of the radius and the size of the minor angle shaded grey.\"","v":"Q11. Measure the length of the radius and the size of the minor angle shaded grey."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",{"$f":"ROUND(RAND()*(34-8)+8,0)*5","v":95}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B",{"$f":"360-AL76","v":265}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length =",null,null,null,null,null,null,null,null,"cm",null,null,null,null,null,null,null,null,1.5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Angle ABC =",null,null,null,null,null,null,null,null,"o"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,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()*(25-14)+14,0)*10","v":190}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK88/2+ROUND(RAND()*(3-1)+1,0)*10","v":115}]
[null,{"$f":"\"Q12. A school group of \"&AK94&\" students are planning to travel to an event using hired buses.\"","v":"Q12. A school group of 419 students are planning to travel to an event using hired buses."},null,null,null,null,null,null,null,null,null,null,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()*(80-70)+70,0)","v":76},{"$f":"ROUND(RAND()*(5-2)+2,0)","v":4},{"$f":"IF(AK97>AK91,AK96+1,AK96)","v":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,{"$f":"ROUND(RAND()*(30-20)+20,0)","v":23},{"$f":"ROUND(RAND()*(5-2)+2,0)","v":5},{"$f":"IF(AK97<=AK91,1,0)","v":0}]
[null,null," A bus company offers two sizes of bus:",null,null,null,null,null,null,null,null,null,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":"AK90*AL90","v":304},null,{"$f":"TEXT(AM91,\"0\")","v":"0"}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK91*AL91","v":115},null,{"$f":"TEXT(AM90,\"0\")","v":"6"}]
[null,null,{"$f":"\"Size A \"&AK90&\" seats Price £ \"&AK88&\".\"","v":"Size A 76 seats Price £ 190."},null,null,null,null,null,null,null,null,null,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":"AK92+AK93","v":419}]
[null,null,{"$f":"\"Size B \"&AK91&\" seats Price £ \"&AK89&\".\"","v":"Size B 23 seats Price £ 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,{"$f":"AK94/AK90","v":5.5131578947368425}]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"TRUNC(AK95)","v":5}]
[null,null,"The group wants to pay the lowest total hire charge available.",null,null,null,null,null,null,null,null,null,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":"AK94-(AK90*AK96)","v":39}]
[]
[null,null,"How many buses of each size should they hire?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,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":"AK88*AM90+AK89*AM91","v":1140}]
[null,null,"How much will this 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(5-1)+1,0)","v":2},null,"Scotland","Italy","Germany","France","Sweden","Total"]
[null,{"$f":"\"Q13.  A survey of a beach resort showed that there were a total of \"&AM111&\" visitors\"","v":"Q13.  A survey of a beach resort showed that there were a total of 2088 visitors"},null,null,null,null,null,null,null,null,null,null,null,null,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":"72*ROUND(RAND()*(50-11)+11,0)","v":2088},1,{"$f":"2*ROUND(RAND()*(9-5)+5,0)/72","v":0.16666666666666666},{"$f":"ROUND(RAND()*(9-5)+5,0)/72","v":8.3333333333333329E-2},{"$f":"2*ROUND(RAND()*(9-5)+5,0)/72","v":0.16666666666666666},{"$f":"2*ROUND(RAND()*(9-5)+5,0)/72","v":0.22222222222222221},{"$f":"1-SUM(AO111:AR111)","v":0.36111111111111116},{"$f":"SUM(AO111:AS111)","v":1}]
[null,null,null,{"$f":"\"from a variety of countries.\"","v":"from a variety of countries."},null,null,null,null,null,null,null,null,null,null,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":"AN137","v":203},2,{"$f":"2*ROUND(RAND()*(9-5)+5,0)/72","v":0.19444444444444445},{"$f":"ROUND(RAND()*(9-5)+5,0)/72","v":9.7222222222222224E-2},{"$f":"2*ROUND(RAND()*(9-5)+5,0)/72","v":0.19444444444444445},0.25,{"$f":"1-SUM(AO112:AR112)","v":0.26388888888888884},{"$f":"SUM(AO112:AS112)","v":1}]
[null,null,null,{"$f":"\"The diagram below shows the proportion (in degrees) of visitors that came from \"","v":"The diagram below shows the proportion (in degrees) of visitors that came from "},null,null,null,null,null,null,null,null,null,null,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":"AN116","v":"Italy"},3,0.25,9.7222222222222224E-2,0.1388888888888889,0.25,0.26388888888888884,1]
[null,null,null,{"$f":"\"each country.\"","v":"each country."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0.19444444444444445,9.7222222222222224E-2,0.16666666666666666,0.19444444444444445,0.34722222222222221,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,5,0.16666666666666666,6.9444444444444448E-2,0.19444444444444445,0.25,0.31944444444444442,1]
[null,null,null,{"$f":"\"How many visitors were there from \"&AM113& \"?\"","v":"How many visitors were there from Italy?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," visitors",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP($AM$110,$AO$109:$AS$109,AO110:AS110)","v":"Italy"},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AO111:AO115)","v":0.19444444444444445},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AP111:AP115)","v":9.7222222222222224E-2},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AQ111:AQ115)","v":0.19444444444444445},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AR111:AR115)","v":0.25},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AS111:AS115)","v":0.26388888888888884},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AT111:AT115)","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,1,2,3,4,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AM110","v":2},null,"Scotland","Italy","Germany","France","Sweden","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AO111/$AT$111*360","v":60},{"$f":"AP111/$AT$111*360","v":30},60,80,130.00000000000003,{"$f":"SUM(AO120:AS120)","v":360}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"AO112/$AT$111*360","v":70},35,70,90,94.999999999999986,{"$f":"SUM(AO121:AS121)","v":360}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"AO113/$AT$111*360","v":90},35,50,90,94.999999999999986,360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"AO114/$AT$111*360","v":70},35,60,70,125,360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"AO115/$AT$111*360","v":60},25,70,90,114.99999999999999,360]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"LOOKUP($AM$110,$AO$109:$AS$109,AO119:AS119)","v":"Italy"},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AO120:AO124)","v":70},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AP120:AP124)","v":35},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AQ120:AQ124)","v":70},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AR120:AR124)","v":90},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AS120:AS124)","v":94.999999999999986},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AT120:AT124)","v":360}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AM110","v":2},null,"Scotland","Italy","Germany","France","Sweden","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"AO111*$AM$111","v":348},{"$f":"AP111*$AM$111","v":174},348,464,754.00000000000011,{"$f":"SUM(AO128:AS128)","v":2088}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"AO112*$AM$111","v":406},203,406,522,550.99999999999989,{"$f":"SUM(AO129:AS129)","v":2088}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,{"$f":"AO113*$AM$111","v":522},203,290,522,550.99999999999989,2088]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,{"$f":"AO114*$AM$111","v":406},203,348,406,725,2088]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,{"$f":"AO115*$AM$111","v":348},145,406,522,667,2088]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"LOOKUP($AM$127,$AO$109:$AS$109,AO127:AS127)","v":"Italy"},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AO128:AO132)","v":406},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AP128:AP132)","v":203},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AQ128:AQ132)","v":406},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AR128:AR132)","v":522},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AS128:AS132)","v":550.99999999999989},{"$f":"LOOKUP($AM$110,$AN$111:$AN$115,AT128:AT132)","v":2088}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AN133","v":"Italy"},{"$f":"AO133","v":406},203,406,522,550.99999999999989,2088]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"LOOKUP($AM$127,$AO$135:$AS$135,AO136:AS136)","v":203}]

{"sheet":"Q14_Q18","index":2,"n_rows":123,"n_cols":47,"rows_kept":123,"cut":false,"hidden":false,"merged":[[63,12,63,16],[63,17,63,21],[63,22,63,26],[63,3,63,11],[64,17,64,21],[65,17,65,21],[66,17,66,21],[17,3,22,32],[9,7,9,11],[10,7,10,11],[11,7,11,11],[15,11,15,15],[15,16,15,19],[11,3,11,6],[64,3,64,11],[65,3,65,11],[66,3,66,11],[64,12,64,16],[65,12,65,16],[66,12,66,16],[64,22,64,26],[8,12,8,22],[9,12,9,22],[10,12,10,22],[11,12,11,22],[1,1,2,33],[7,3,7,6],[7,7,7,11],[7,12,7,22],[7,23,7,27],[8,3,8,6],[8,23,8,27],[9,23,9,27],[10,23,10,27],[11,23,11,27],[9,3,9,6],[10,3,10,6],[8,7,8,11],[115,3,120,32],[96,3,101,32],[110,24,110,26],[110,20,110,23],[47,23,47,25],[52,1,57,35],[94,21,94,24],[94,25,94,28],[61,18,61,19],[68,18,68,19],[75,21,75,24],[77,3,82,32],[75,12,75,19],[65,22,65,26],[66,22,66,26]]}
[]
[null,"National 4 Numeracy Practice"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-0)+0,0)","v":1},null,null,"Under £3000","Between £3000 - £5000","Over £5000"]
[null,{"$f":"\"Q14.   The table below shows the amount of yearly interest a selection of banks \"","v":"Q14.   The table below shows the amount of yearly interest a selection of banks "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4]
[null,null,null,"   will pay to a customer on savings.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"A",{"$f":"ROUND(RAND()*(1.4-1)+1,1)","v":1.4},{"$f":"ROUND(RAND()*(1.8-1.5)+1.5,1)","v":1.8},{"$f":"ROUND(RAND()*(2.2-1.9)+1.9,1)","v":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,2,"B",{"$f":"IF(AN4=0,AQ6+0.1,AQ6-0.1)","v":1.2999999999999998},{"$f":"IF(AN4=0,AR6+0.1,AR6-0.1)","v":1.7},{"$f":"IF(AN4=0,AS6+0.1,AS6-0.1)","v":1.9}]
[null,null,null,"Bank",null,null,null,"< £3000",null,null,null,null,"Between £3000 - £5000",null,null,null,null,null,null,null,null,null,null,"> £5000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"C",{"$f":"IF(AN4=2,AQ7+0.2,AQ7-0.2)","v":1.0999999999999999},{"$f":"IF(AN4=2,AR7+0.2,AR7-0.2)","v":1.5},{"$f":"IF(AN4=2,AS7+0.2,AS7-0.2)","v":1.7}]
[null,null,null,"A",null,null,null,{"$f":"AQ6&\" %\"","v":"1.4 %"},null,null,null,null,{"$f":"AR6&\" %\"","v":"1.8 %"},null,null,null,null,null,null,null,null,null,null,{"$f":"AS6&\" %\"","v":"2 %"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"D",{"$f":"IF(AN4=3,AQ8+0.4,AQ8-0.4)","v":0.69999999999999984},{"$f":"IF(AN4=3,AR8+0.4,AR8-0.4)","v":1.1000000000000001},{"$f":"IF(AN4=3,AS8+0.4,AS8-0.4)","v":1.2999999999999998}]
[null,null,null,"B",null,null,null,{"$f":"AQ7&\" %\"","v":"1.3 %"},null,null,null,null,{"$f":"AR7&\" %\"","v":"1.7 %"},null,null,null,null,null,null,null,null,null,null,{"$f":"AS7&\" %\"","v":"1.9 %"}]
[null,null,null,"C",null,null,null,"1.1 %",null,null,null,null,"1.5 %",null,null,null,null,null,null,null,null,null,null,"1.7 %"]
[null,null,null,"D",null,null,null,"0.7 %",null,null,null,null,"1.1 %",null,null,null,null,null,null,null,null,null,null,"1.3 %"]
[]
[null,null,null,{"$f":"\"For a savings amount of £\"&AK14&\" , which bank would pay the most interest ?\"","v":"For a savings amount of £4010 , which bank would pay the most interest ?"},null,null,null,null,null,null,null,null,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()*(860-250)+250,0)*10","v":4010}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Bank",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(AN4=2,\"C\",IF(AN4=1,\"A\",IF(AN4=0,\"B\",\"D\")))","v":"A"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q15.  A school conducted a survey to establish the number of pupils \"","v":"Q15.  A school conducted a survey to establish the number of pupils "}]
[null,null,null,{"$f":"\"who were wearing ties on one \"&AQ38&\" morning.\"","v":"who were wearing ties on one Tuesday morning."}]
[]
[null,null,null,"The compound bar chart below gives the results of the data collected."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(5-1)+1,0)","v":2},1,"Monday"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Tuesday"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Wednesday"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Thursday"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Friday"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"LOOKUP(AO33,AP33:AP37,AQ33:AQ37)","v":"Tuesday"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Boys","Girls"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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},1,"S1",{"$f":"ROUND(RAND()*(80-60)+60,0)","v":79},{"$f":"ROUND(RAND()*(90-70)+70,0)","v":75}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"S2",{"$f":"ROUND(RAND()*(70-50)+50,0)","v":56},{"$f":"ROUND(RAND()*(90-70)+70,0)","v":81}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"S3",{"$f":"ROUND(RAND()*(55-40)+40,0)","v":52},74]
[null,null,{"$f":"\"(a)  How many \"&AQ51&\" \"&AQ52&\" wore ties that day ?\"","v":"(a)  How many S1 Girls wore ties that day ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\" \"&AQ52","v":" Girls"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"S4",{"$f":"ROUND(RAND()*(80-60)+60,0)","v":73},79]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"S5",66,89]
[null,null,"(b)  Compare the wearing of ties by both boys and girls across the year groups.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"S6",69,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,null,null,null,null,null,null,{"$f":"LOOKUP($AO$45,$AP$45:$AP$50,AQ45:AQ50)","v":"S1"},{"$f":"LOOKUP($AO$45,$AP$45:$AP$50,AR45:AR50)","v":79},75]
[null,"( Remember statement to include valid comparison for BOTH boys and girls )",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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()*(1-0)+0,0)","v":0},null,{"$f":"IF(AO52=1,AR44,AS44)","v":"Girls"},{"$f":"IF(AO52=1,AR51,AS51)","v":75}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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)","v":3},"Calls (minutes)",{"$f":"ROUND(RAND()*(12-9)+9,0)*10","v":100},{"$f":"ROUND(RAND()*(18-16)+16,0)*10","v":160},{"$f":"ROUND(RAND()*(25-20)+20,0)*10","v":220}]
[null,{"$f":"\"Q16.  Three mobile phone companies each have a contract \"","v":"Q16.  Three mobile phone companies each have a contract "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Texts",{"$f":"ROUND(RAND()*(10-8)+8,0)*100","v":900},{"$f":"ROUND(RAND()*(7-5)+5,0)*100","v":500},{"$f":"ROUND(RAND()*(4-3)+3,0)*100","v":300}]
[null,null,null,{"$f":"\"available at the same price.\"","v":"available at the same price."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3.6-0.4)+0.4,1)","v":3.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Internet (Mb)",500,750,1000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"AS60-ROUND(RAND()*(6-1)+1,0)*5","v":70},{"$f":"AT60-ROUND(RAND()*(6-1)+1,0)*5","v":135},200]
[null,null,null,"Company Plan",null,null,null,null,null,null,null,null,"A",null,null,null,null,"B",null,null,null,null,"C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AS61-ROUND(RAND()*(19-1)+1,0)*5","v":825},{"$f":"AT61-ROUND(RAND()*(15-1)+1,0)*5","v":490},{"$f":"AU61-ROUND(RAND()*(20-1)+1,0)*5","v":255}]
[null,null,null,{"$f":"AR60","v":"Calls (minutes)"},null,null,null,null,null,null,null,null,{"$f":"AS60","v":100},null,null,null,null,{"$f":"AT60","v":160},null,null,null,null,{"$f":"AU60","v":220},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AS62-ROUND(RAND()*(40-1)+1,0)*5","v":435},{"$f":"AT62-ROUND(RAND()*(40-1)+1,0)*5","v":560},{"$f":"AU62-ROUND(RAND()*(40-1)+1,0)*5","v":920}]
[null,null,null,{"$f":"AR61","v":"Texts"},null,null,null,null,null,null,null,null,{"$f":"AS61","v":900},null,null,null,null,{"$f":"AT61","v":500},null,null,null,null,{"$f":"AU61","v":300},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Question data",{"$f":"IF(AQ60=1,AS63,IF(AQ60=2,AT63,AU63))","v":200},{"$f":"IF(AQ60=1,AS64,IF(AQ60=2,AT64,AU64))","v":255},{"$f":"IF(AQ60=1,AS65,IF(AQ60=2,AT65,AU65))","v":920}]
[null,null,null,"Internet (Mb)",null,null,null,null,null,null,null,null,500,null,null,null,null,750,null,null,null,null,1000]
[]
[]
[null,null,null,"Ainslie is looking for a mobile phone contract which will give her"]
[null,null,null,{"$f":"AS66&\" minutes of calls, \"&AT66&\" texts, and \"&AU66&\"Mb of internet use.\"","v":"200 minutes of calls, 255 texts, and 920Mb of internet use."}]
[]
[null,null,null,"Which company’s plan would be best for her?"]
[null,null,null,"Remember in exam give a reason for your answer."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Company Plan",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(AQ60=1,\"A\",IF(AQ60=2,\"B\",\"C\"))","v":"C"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q17.  Two drama clubs are to send representatives to a show. \"","v":"Q17.  Two drama clubs are to send representatives to a show. "},null,null,null,null,null,null,null,null,null,null,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":2},null,{"$f":"ROUND(RAND()*(8-3)+3,0)*10","v":40},{"$f":"AM86+10","v":50}]
[null,null,null,"The representatives are chosen at random.",null,null,null,null,null,null,null,null,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(AK86=1,AN86,AM86)","v":40},{"$f":"AK87/10*ROUND(RAND()*(5-2)+2,0)","v":16},{"$f":"AL87*100/AK87","v":40}]
[null,null,null,null,null,null,null,null,null,null,null,null,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(AK86=2,AN86,AM86)","v":50},{"$f":"AK88/10*ROUND(RAND()*(9-6)+6,0)","v":35},{"$f":"AL88*100/AK88","v":70}]
[null,null,null,{"$f":"\"Club A has \"&AL87&\" tickets and has \"&AM87&\" members.\"","v":"Club A has 16 tickets and has 40 members."}]
[null,null,null,{"$f":"\"Club B has \"&AL88&\" tickets and has \"&AM88&\" members.\"","v":"Club B has 35 tickets and has 70 members."}]
[]
[null,null,null,"In which club does any one person have a better chance of being selected?"]
[null,null,null,"Remember Justify your answer by calculation in exam."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Club",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK86=1,\"A\",\"B\")","v":"B"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,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)","v":1},null,{"$f":"ROUND(RAND()*(7-5)+5,0)*10","v":60},{"$f":"AM103+10","v":70},{"$f":"AM103-10","v":50}]
[null,null,null,null,null,null,null,null,null,null,null,null,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($AK$103=1,$AM$103,IF($AK$103=2,$AN$103,$AO$103))","v":60},{"$f":"AK104/10*ROUND(RAND()*(3-1)+1,0)","v":12},{"$f":"AL104*100/AK104","v":20}]
[null,{"$f":"\"Q18. Three football teams play in the same town.\"","v":"Q18. Three football teams play in the same town."},null,null,null,null,null,null,null,null,null,null,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($AK$103=2,$AM$103,IF($AK$103=3,$AN$103,$AO$103))","v":50},{"$f":"AK105/10*ROUND(RAND()*(6-4)+4,0)","v":30},{"$f":"AL105*100/AK105","v":60}]
[null,null,null,null,null,null,null,null,null,null,null,null,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($AK$103=3,$AM$103,IF($AK$103=1,$AN$103,$AO$103))","v":70},{"$f":"AK106/10*ROUND(RAND()*(9-7)+7,0)","v":56},80]
[null,null,{"$f":"\"Team A have won \"&AL104&\" out of their \"&AM104&\" games.\"","v":"Team A have won 12 out of their 20 games."}]
[null,null,{"$f":"\"Team B have won \"&AL105&\" out of their \"&AM105&\" games.\"","v":"Team B have won 30 out of their 60 games."}]
[null,null,{"$f":"\"Team C have won \"&AL106&\" out of their \"&AM106&\" games.\"","v":"Team C have won 56 out of their 80 games."}]
[]
[null,null,"Which team has the best winning record?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Team",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AK103=2,\"A\",IF(AK103=1,\"C\",\"B\"))","v":"C"}]
[]
[null,null,"Remember Justify your answer by calculation in exam."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]