{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Worksheet","SYSTEM FORMULAE","Sheet1"],"not_rendered":{"charts":0,"images":0,"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":"Worksheet","index":0,"n_rows":52,"n_cols":5,"rows_kept":52,"cut":false,"hidden":false,"merged":[[2,0,2,1],[6,0,6,1],[0,2,0,4],[1,2,1,4]]}
[{"$f":"$B$5*COUNTIF($B$8:$B$12,TRUE)","v":10},null,"National 4 Mathematics - Paper 1 Practice Questions"]
[null,null,"Answer each question without a calculator.  Show all your working"]
["Variables",null,{"$f":"IF(ROW()-2<=$A$1,ROW()-2,\"\")","v":1},"Isobel  has 1200 cm of .  5% of these are ","60 cm"]
["SHOW ANSWERS",false,2,"six numbers are:                                                                                                                                                                                                                                                  3         13         4         5         6         6                                                                                                                                                                                Calculate the mean.  Round your answer to 2 decimal places.","6.167… = 6.17"]
["Number of examples of each type of question (minimum 1, maximum 9)                         Note: 12 questions fit on one page",2,3,"Find 5/7 of 1750.",1250]
["Mix order",false,4,"7.68 is added to 3.9.   Then 1.6 is taken away.   What is left?",9.98]
["Types of question in include",null,5,"9 is multiplied by 4.92.   What is the answer?",44.28]
["Use of Whole Number Percentages",true,6,"Patrick  has 580 kg of .  40% of these are ","232 kg"]
["Mean of a Data Set followed by Rounding",true,7,"six numbers are:                                                                                                                                                                                                                                                  5         14         11         11         7         10                                                                                                                                                                                Calculate the mean.  Round your answer to 2 decimal places.","9.667… = 9.67"]
["Non-unitary fraction",true,8,"Find 3/4 of 480.",360]
["Adding and then subtracting decimals",true,9,"1.53 is added to 6.7.   Then 4.7 is taken away.   What is left?",3.5300000000000002]
["Multiplying a decimal by a whole number",true,10,"7 is multiplied by 4.63.   What is the answer?",32.409999999999997]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":51,"n_cols":31,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Worksheet!A1","v":10},null,null,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":"Worksheet!B6","v":false}]
[1,{"$f":"IF(D2,5*A2-4,99)","v":1},{"$f":"IF(D2,RAND(),1)","v":0.55143203479610059},{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E2,2)),Worksheet!$B$8),TRUE)","v":true},"01perc",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(RAND()<0.5,RANDBETWEEN(3,9),CHOOSE(RANDBETWEEN(1,6),30,40,60,70,80,90))","v":3},{"$f":"IF(P2<10,100*RANDBETWEEN(4,15),(10*RANDBETWEEN(2,9)+RANDBETWEEN(1,9))*10)","v":800},null,null,null,null,null,null,null,{"$f":"CONCATENATE(IF(AA2>7,\"£\",\"\"),Q2/100*P2,\" \",IF(AA2>7,\"\",CHOOSE(AA2,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\")))","v":"24 m"},null,{"$f":"RANDBETWEEN(1,9)","v":1},{"$f":"IF(D2,CONCATENATE(INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200)),\" has \",IF(AA2>7,\"£\",\"\"),Q2,\" \",CHOOSE(AA2,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\",\"\",\"\"),\" of \",\".\",\"  \",P2,\"% of these are \"),\"\")","v":"Alice  has 800 m of .  3% of these are "},{"$f":"IF(D2,Y2,\"\")","v":"24 m"}]
[2,6,0.48896861486154264,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E3,2)),Worksheet!$B$8),TRUE)","v":true},"02perc",null,null,null,null,null,null,null,null,null,null,8,1400,null,null,null,null,null,null,null,"112 ml",null,6,{"$f":"IF(D3,CONCATENATE(INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200)),\" has \",IF(AA3>7,\"£\",\"\"),Q3,\" \",CHOOSE(AA3,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\",\"\",\"\"),\" of \",\".\",\"  \",P3,\"% of these are \"),\"\")","v":"Charlie  has 1400 ml of .  8% of these are "},"112 ml"]
[3,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E4,2)),Worksheet!$B$8),TRUE)","v":false},"03perc",null,null,null,null,null,null,null,null,null,null,7,1300,null,null,null,null,null,null,null,"91 kg",null,4,{"$f":"IF(D4,CONCATENATE(INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200)),\" has \",IF(AA4>7,\"£\",\"\"),Q4,\" \",CHOOSE(AA4,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\",\"\",\"\"),\" of \",\".\",\"  \",P4,\"% of these are \"),\"\")","v":""},""]
[4,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E5,2)),Worksheet!$B$8),TRUE)","v":false},"04perc",null,null,null,null,null,null,null,null,null,null,70,580,null,null,null,null,null,null,null,"406 kg",null,4,{"$f":"IF(D5,CONCATENATE(INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200)),\" has \",IF(AA5>7,\"£\",\"\"),Q5,\" \",CHOOSE(AA5,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\",\"\",\"\"),\" of \",\".\",\"  \",P5,\"% of these are \"),\"\")","v":""},""]
[5,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E6,2)),Worksheet!$B$8),TRUE)","v":false},"05perc",null,null,null,null,null,null,null,null,null,null,4,1500,null,null,null,null,null,null,null,"£60 ",null,9,{"$f":"IF(D6,CONCATENATE(INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200)),\" has \",IF(AA6>7,\"£\",\"\"),Q6,\" \",CHOOSE(AA6,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\",\"\",\"\"),\" of \",\".\",\"  \",P6,\"% of these are \"),\"\")","v":""},"",null,{"$f":"INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200))","v":"Rhys "}]
[6,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E7,2)),Worksheet!$B$8),TRUE)","v":false},"06perc",null,null,null,null,null,null,null,null,null,null,7,1100,null,null,null,null,null,null,null,"77 cm",null,2,{"$f":"IF(D7,CONCATENATE(INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200)),\" has \",IF(AA7>7,\"£\",\"\"),Q7,\" \",CHOOSE(AA7,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\",\"\",\"\"),\" of \",\".\",\"  \",P7,\"% of these are \"),\"\")","v":""},""]
[7,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E8,2)),Worksheet!$B$8),TRUE)","v":false},"07perc",null,null,null,null,null,null,null,null,null,null,5,1500,null,null,null,null,null,null,null,"75 tonnes",null,5,{"$f":"IF(D8,CONCATENATE(INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200)),\" has \",IF(AA8>7,\"£\",\"\"),Q8,\" \",CHOOSE(AA8,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\",\"\",\"\"),\" of \",\".\",\"  \",P8,\"% of these are \"),\"\")","v":""},""]
[8,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E9,2)),Worksheet!$B$8),TRUE)","v":false},"08perc",null,null,null,null,null,null,null,null,null,null,60,260,null,null,null,null,null,null,null,"156 m",null,1,{"$f":"IF(D9,CONCATENATE(INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200)),\" has \",IF(AA9>7,\"£\",\"\"),Q9,\" \",CHOOSE(AA9,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\",\"\",\"\"),\" of \",\".\",\"  \",P9,\"% of these are \"),\"\")","v":""},""]
[9,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E10,2)),Worksheet!$B$8),TRUE)","v":false},"09perc",null,null,null,null,null,null,null,null,null,null,7,1300,null,null,null,null,null,null,null,"£91 ",null,9,{"$f":"IF(D10,CONCATENATE(INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200)),\" has \",IF(AA10>7,\"£\",\"\"),Q10,\" \",CHOOSE(AA10,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\",\"\",\"\"),\" of \",\".\",\"  \",P10,\"% of these are \"),\"\")","v":""},""]
[10,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E11,2)),Worksheet!$B$8),TRUE)","v":false},"10perc",null,null,null,null,null,null,null,null,null,null,9,800,null,null,null,null,null,null,null,"£72 ",null,9,{"$f":"IF(D11,CONCATENATE(INDEX(Sheet1!A$2:A$201,RANDBETWEEN(1,200)),\" has \",IF(AA11>7,\"£\",\"\"),Q11,\" \",CHOOSE(AA11,\"m\",\"cm\",\"g\",\"kg\",\"tonnes\",\"ml\",\"litres\",\"\",\"\"),\" of \",\".\",\"  \",P11,\"% of these are \"),\"\")","v":""},""]
[11,{"$f":"IF(D12,5*A12-53,99)","v":2},0.32159752620426152,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E12,2)),Worksheet!$B$9),TRUE)","v":true},"01mean",{"$f":"CHOOSE(RANDBETWEEN(1,3),6,7,9)","v":6},{"$f":"RANDBETWEEN(5,10)","v":6},{"$f":"IF(F12=6,CHOOSE(RANDBETWEEN(1,3),1,4,5),IF(F12=7,RANDBETWEEN(1,6),RANDBETWEEN(3,8)))","v":5},{"$f":"G12*F12+H12","v":41},null,null,null,null,null,{"$f":"I12-SUM(R12:X12)","v":22},{"$f":"O12-Q12","v":9},{"$f":"RANDBETWEEN(O12/2,O12-1)","v":13},{"$f":"$G12+RANDBETWEEN(0,2)*(-1)^RANDBETWEEN(1,2)","v":5},4,4,6,{"$f":"IF(NOT($F12=6),$G12+RANDBETWEEN(0,2)*(-1)^RANDBETWEEN(1,2),\"\")","v":""},{"$f":"IF($F12=9,$G12+RANDBETWEEN(0,2)*(-1)^RANDBETWEEN(1,2),\"\")","v":""},"",{"$f":"AVERAGE(P12:X12)","v":6.833333333333333},{"$f":"AVERAGE(P12:X12)","v":6.833333333333333},null,{"$f":"IF(D12,CONCATENATE(IF(F12=6,\"six\",IF(F12=7,\"seven\",\"nine\")),\" numbers are:                                                                                                                                                                                                                                                  \",P12,\"         \",Q12,\"         \",R12,\"         \",S12,\"         \",T12,\"         \",U12,\"         \",V12,\"        \",W12,\"         \",X12,\"                                                                                                                                                      \",\"Calculate the mean\",\".  Round your answer to 2 decimal places.\"),\"\")","v":"six numbers are:                                                                                                                                                                                                                                                  9         13         5         4         4         6                                                                                                                                                                                Calculate the mean.  Round your answer to 2 decimal places."},{"$f":"IF(D12,CONCATENATE(TEXT(Y12,\"0.000…\"),\" = \",TEXT(Z12,\"0.00\")),\"\")","v":"6.833… = 6.83"}]
[12,7,0.71349034943000067,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E13,2)),Worksheet!$B$9),TRUE)","v":true},"02mean",7,8,4,60,null,null,null,null,null,22,9,13,6,9,8,6,9,"","",8.5714285714285712,8.5714285714285712,null,"seven numbers are:                                                                                                                                                                                                                                                  9         13         6         9         8         6         9                                                                                                                                                                       Calculate the mean.  Round your answer to 2 decimal places.","8.571… = 8.57"]
[13,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E14,2)),Worksheet!$B$9),TRUE)","v":false},"03mean",9,9,6,87,null,null,null,null,null,23,8,15,9,11,10,9,9,9,7,9.6666666666666661,9.6666666666666661,null,"",""]
[14,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E15,2)),Worksheet!$B$9),TRUE)","v":false},"04mean",9,8,6,78,null,null,null,null,null,22,3,19,10,6,8,6,8,10,8,8.6666666666666661,8.6666666666666661,null,"",""]
[15,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E16,2)),Worksheet!$B$9),TRUE)","v":false},"05mean",6,8,4,52,null,null,null,null,null,21,10,11,9,8,6,8,"","","",8.6666666666666661,8.6666666666666661,null,"",""]
[16,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E17,2)),Worksheet!$B$9),TRUE)","v":false},"06mean",7,7,3,52,null,null,null,null,null,19,3,16,5,8,8,6,6,"","",7.4285714285714288,7.4285714285714288,null,"",""]
[17,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E18,2)),Worksheet!$B$9),TRUE)","v":false},"07mean",7,6,1,43,null,null,null,null,null,19,9,10,6,4,4,4,6,"","",6.1428571428571432,6.1428571428571432,null,"",""]
[18,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E19,2)),Worksheet!$B$9),TRUE)","v":false},"08mean",9,7,3,66,null,null,null,null,null,16,5,11,7,7,8,7,8,6,7,7.333333333333333,7.333333333333333,null,"",""]
[19,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E20,2)),Worksheet!$B$9),TRUE)","v":false},"09mean",9,8,6,78,null,null,null,null,null,23,7,16,9,8,8,9,7,6,8,8.6666666666666661,8.6666666666666661,null,"",""]
[20,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E21,2)),Worksheet!$B$9),TRUE)","v":false},"10mean",6,7,4,46,null,null,null,null,null,20,1,19,5,7,5,9,"","","",7.666666666666667,7.666666666666667,null,"",""]
[21,{"$f":"IF(D22,5*A22-102,99)","v":3},0.17358483475681152,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E22,2)),Worksheet!$B$10),TRUE)","v":true},"01frac",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q22=4,3,IF(Q22=6,5,IF(Q22=7,RANDBETWEEN(2,6),IF(Q22=5,RANDBETWEEN(2,3),CHOOSE(RANDBETWEEN(1,3),3,5,7)))))","v":5},{"$f":"RANDBETWEEN(4,8)","v":6},{"$f":"Q22*10*RANDBETWEEN(10,30)","v":1740},null,null,null,null,null,null,{"$f":"R22/Q22*P22","v":1450},null,null,{"$f":"IF(D22,CONCATENATE(\"Find \",P22,\"/\",Q22,\" of \",R22,\".\"),\"\")","v":"Find 5/6 of 1740."},{"$f":"IF(D22,Y22,\"\")","v":1450}]
[22,8,0.60663112580655243,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E23,2)),Worksheet!$B$10),TRUE)","v":true},"02frac",null,null,null,null,null,null,null,null,null,null,5,8,880,null,null,null,null,null,null,550,null,null,"Find 5/8 of 880.",550]
[23,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E24,2)),Worksheet!$B$10),TRUE)","v":false},"03frac",null,null,null,null,null,null,null,null,null,null,3,4,520,null,null,null,null,null,null,390,null,null,"",""]
[24,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E25,2)),Worksheet!$B$10),TRUE)","v":false},"04frac",null,null,null,null,null,null,null,null,null,null,3,4,760,null,null,null,null,null,null,570,null,null,"",""]
[25,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E26,2)),Worksheet!$B$10),TRUE)","v":false},"05frac",null,null,null,null,null,null,null,null,null,null,5,6,1140,null,null,null,null,null,null,950,null,null,"",""]
[26,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E27,2)),Worksheet!$B$10),TRUE)","v":false},"06frac",null,null,null,null,null,null,null,null,null,null,5,7,1120,null,null,null,null,null,null,800,null,null,"",""]
[27,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E28,2)),Worksheet!$B$10),TRUE)","v":false},"07frac",null,null,null,null,null,null,null,null,null,null,3,4,1120,null,null,null,null,null,null,840,null,null,"",""]
[28,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E29,2)),Worksheet!$B$10),TRUE)","v":false},"08frac",null,null,null,null,null,null,null,null,null,null,7,8,1840,null,null,null,null,null,null,1610,null,null,"",""]
[29,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E30,2)),Worksheet!$B$10),TRUE)","v":false},"09frac",null,null,null,null,null,null,null,null,null,null,5,6,1620,null,null,null,null,null,null,1350,null,null,"",""]
[30,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E31,2)),Worksheet!$B$10),TRUE)","v":false},"10frac",null,null,null,null,null,null,null,null,null,null,3,4,560,null,null,null,null,null,null,420,null,null,"",""]
[31,{"$f":"IF(D32,5*A32-151,99)","v":4},0.80887429522466137,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E32,2)),Worksheet!$B$11),TRUE)","v":true},"01dec",{"$f":"RANDBETWEEN(1,2)","v":2},{"$f":"RANDBETWEEN(1,7)","v":1},{"$f":"RANDBETWEEN(4,9)","v":5},{"$f":"IF(F32=1,RANDBETWEEN(1,9),0)","v":0},{"$f":"RANDBETWEEN(1,6)","v":1},{"$f":"RANDBETWEEN(12-H32,9)","v":9},{"$f":"IF(F32=2,RANDBETWEEN(1,9),0)","v":1},{"$f":"RANDBETWEEN(1,F32+J32-1)","v":2},{"$f":"RANDBETWEEN(H32+K32-9,9)","v":8},null,{"$f":"G32+H32/10+I32/100","v":1.5},{"$f":"J32+K32/10+L32/100","v":1.91},{"$f":"N32/10+M32","v":2.8},null,null,null,null,null,null,{"$f":"P32+Q32-R32","v":0.61000000000000032},null,null,{"$f":"IF(D32,CONCATENATE(P32,\" is added to \",Q32,\".   Then \",R32,\" is taken away.   What is left?\"),\"\")","v":"1.5 is added to 1.91.   Then 2.8 is taken away.   What is left?"},0.61000000000000032]
[32,9,0.59025239434650933,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E33,2)),Worksheet!$B$11),TRUE)","v":true},"02dec",2,4,5,0,4,7,5,1,9,null,4.5,4.75,1.9,null,null,null,null,null,null,7.35,null,null,"4.5 is added to 4.75.   Then 1.9 is taken away.   What is left?",7.35]
[33,99,{"$f":"IF(D34,RAND(),1)","v":1},{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E34,2)),Worksheet!$B$11),TRUE)","v":false},"03dec",1,1,4,5,1,9,0,1,7,null,1.45,1.9,1.7,null,null,null,null,null,null,1.6499999999999997,null,null,"",""]
[34,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E35,2)),Worksheet!$B$11),TRUE)","v":false},"04dec",1,3,6,7,6,6,0,5,5,null,3.67,6.6,5.5,null,null,null,null,null,null,4.7699999999999996,null,null,"",""]
[35,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E36,2)),Worksheet!$B$11),TRUE)","v":false},"05dec",2,3,6,0,1,9,1,1,9,null,3.6,1.91,1.9,null,null,null,null,null,null,3.61,null,null,"",""]
[36,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E37,2)),Worksheet!$B$11),TRUE)","v":false},"06dec",2,7,5,0,6,8,8,4,6,null,7.5,6.88,4.5999999999999996,null,null,null,null,null,null,9.7799999999999994,null,null,"",""]
[37,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E38,2)),Worksheet!$B$11),TRUE)","v":false},"07dec",2,6,6,0,2,8,3,2,5,null,6.6,2.8299999999999996,2.5,null,null,null,null,null,null,6.93,null,null,"",""]
[38,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E39,2)),Worksheet!$B$11),TRUE)","v":false},"08dec",2,6,6,0,1,6,3,2,3,null,6.6,1.6300000000000001,2.2999999999999998,null,null,null,null,null,null,5.9300000000000006,null,null,"",""]
[39,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E40,2)),Worksheet!$B$11),TRUE)","v":false},"09dec",2,4,9,0,1,6,8,2,9,null,4.9000000000000004,1.6800000000000002,2.9,null,null,null,null,null,null,3.68,null,null,"",""]
[40,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E41,2)),Worksheet!$B$11),TRUE)","v":false},"10dec",1,7,4,1,5,9,0,2,5,null,7.41,5.9,2.5,null,null,null,null,null,null,10.81,null,null,"",""]
[41,{"$f":"IF(D42,5*A42-200,99)","v":5},7.3334958492595415E-2,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E42,2)),Worksheet!$B$12),TRUE)","v":true},"01mult",null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(6,9)","v":8},{"$f":"RANDBETWEEN(2,12)+(RANDBETWEEN(1,9)*10+RANDBETWEEN(1,9))/100","v":9.5500000000000007},null,null,null,null,null,null,null,{"$f":"P42*Q42","v":76.400000000000006},null,null,{"$f":"IF(D42,CONCATENATE(P42,\" is multiplied by \",Q42,\".   What is the answer?\"),\"\")","v":"8 is multiplied by 9.55.   What is the answer?"},76.400000000000006]
[42,10,3.9155343461316328E-2,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E43,2)),Worksheet!$B$12),TRUE)","v":true},"02mult",null,null,null,null,null,null,null,null,null,null,8,3.2800000000000002,null,null,null,null,null,null,null,26.240000000000002,null,null,"8 is multiplied by 3.28.   What is the answer?",26.240000000000002]
[43,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E44,2)),Worksheet!$B$12),TRUE)","v":false},"03mult",null,null,null,null,null,null,null,null,null,null,8,3.18,null,null,null,null,null,null,null,25.44,null,null,"",""]
[44,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E45,2)),Worksheet!$B$12),TRUE)","v":false},"04mult",null,null,null,null,null,null,null,null,null,null,6,11.77,null,null,null,null,null,null,null,70.62,null,null,"",""]
[45,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E46,2)),Worksheet!$B$12),TRUE)","v":false},"05mult",null,null,null,null,null,null,null,null,null,null,8,9.7200000000000006,null,null,null,null,null,null,null,77.760000000000005,null,null,"",""]
[46,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E47,2)),Worksheet!$B$12),TRUE)","v":false},"06mult",null,null,null,null,null,null,null,null,null,null,8,2.4900000000000002,null,null,null,null,null,null,null,19.920000000000002,null,null,"",""]
[47,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E48,2)),Worksheet!$B$12),TRUE)","v":false},"07mult",null,null,null,null,null,null,null,null,null,null,6,10.67,null,null,null,null,null,null,null,64.02,null,null,"",""]
[48,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E49,2)),Worksheet!$B$12),TRUE)","v":false},"08mult",null,null,null,null,null,null,null,null,null,null,7,2.68,null,null,null,null,null,null,null,18.760000000000002,null,null,"",""]
[49,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E50,2)),Worksheet!$B$12),TRUE)","v":false},"09mult",null,null,null,null,null,null,null,null,null,null,9,2.36,null,null,null,null,null,null,null,21.24,null,null,"",""]
[50,99,1,{"$f":"IF(AND(Worksheet!$B$5>=VALUE(LEFT(E51,2)),Worksheet!$B$12),TRUE)","v":false},"10mult",null,null,null,null,null,null,null,null,null,null,7,11.29,null,null,null,null,null,null,null,79.03,null,null,"",""]

{"sheet":"Sheet1","index":2,"n_rows":201,"n_cols":2,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["Names","1998 baby names - http://www.statistics.gov.uk/statbase/Product.asp?vlnk=15282"]
["Jack "]
["Thomas "]
["James "]
["Daniel "]
["Josh "]
["Matthew "]
["Samuel "]
["Callum "]
["Joseph "]
["Jordan "]
["Connor "]
["Ryan "]
["Luke "]
["William "]
["Harry "]
["Ben "]
["George "]
["Lewis "]
["Alexander "]
["Oliver "]
["Adam "]
["Jake "]
["Michael "]
["Liam "]
["Nathan "]
["Kieran "]
["Jacob "]
["Cameron "]
["Ben "]
["Mohammed "]
["Aaron "]
["Christopher "]
["Bradley "]
["Jamie "]
["Charlie "]
["Brandon "]
["Robert "]
["Kyle "]
["David "]
["Owen "]
["Charles "]
["Andrew "]
["Reece "]
["Edward "]
["Dylan "]
["Alex "]
["Ethan "]
["Jonathan "]
["Sam "]
["Louis "]
["Max "]
["Dominic "]
["John "]
["Ashley "]
["Rhys "]
["Henry "]
["Conor "]
["Joe "]
["Tyler "]
["Scott "]
["Sean "]
["Nick "]
["Ross "]
["Morgan "]
["Elliot "]
["Patrick "]
["Peter "]
["Billy "]
["Mark "]
["Stephen "]
["Alfie "]
["Harrison "]
["Lee "]
["Anthony "]
["Mitchell "]
["Joel "]
["Toby "]
["Paul "]
["Jay "]
["Jason "]
["Aidan "]
["Richard "]
["Mohammad "]
["Isaac "]
["Declan "]
["Josh "]
["Steven "]
["Marcus "]
["Muhammad "]
["Elliott "]
["Harvey "]
["Tom "]
["Christian "]
["Kane "]
["Shane "]
["Leon "]
["Shaun "]
["Corey "]
["Ellis "]
["Kai "]
["Natalie "]
["Abbie "]
["Francesca "]
["Melissa "]
["Katherine "]
["Harriet "]
["Imogen "]
["Jodie "]
["Gemma "]
["Kayleigh "]
["Lily "]
["Jennifer "]
["Kate "]
["Stephanie "]
["Daisy "]
["Niamh "]
["Millie "]
["Aimee "]
["Kirsty "]
["Hollie "]
["Rosie "]
["Jordan "]
["Mollie "]
["Alisha "]
["Mia "]
["Isobel "]
["Tia "]
["Ellen "]
["Erin "]
["Bethan "]
["Sian "]
["Alicia "]
["Rhiannon "]
["Ashleigh "]
["Catherine "]
["Madeleine "]
["Isabelle "]
["Kelsey "]
["Sophia "]
["Isabella "]
["Naomi "]
["Yasmin "]
["Freya "]
["Morgan "]
["Robyn "]
["Isabel "]
["Maisie "]
["Poppy "]
["Rachael "]
["Chantelle "]
["Chloe "]
["Emily "]
["Megan "]
["Jessica "]
["Sophie "]
["Charlotte "]
["Hannah "]
["Lauren "]
["Rebecca "]
["Lucy "]
["Amy "]
["Georgia "]
["Katie "]
["Bethany "]
["Emma "]
["Olivia "]
["Courtney "]
["Shannon "]
["Eleanor "]
["Jade "]
["Ellie "]
["Abigail "]
["Holly "]
["Molly "]
["Laura "]
["Alice "]
["Sarah "]
["Caitlin "]
["Rachel "]
["Elizabeth "]
["Amber "]
["Paige "]
["Georgina "]
["Danielle "]
["Grace "]
["Nicole "]
["Natasha "]
["Ella "]
["Chelsea "]
["Leah "]
["Victoria "]
["Anna "]
["Phoebe "]
["Samantha "]
["Zoe "]
["Alexandra "]
["Jasmine "]
["Amelia "]
["Louise "]
["Lydia "]