{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Worksheet","SYSTEM FORMULAE","System DO NOT OPEN"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,5,0,6],[1,5,1,6],[0,0,0,3]]}
["Variables"]
[null,null,null,null,null,"National 4: Non-calculator practice",null,"Answers  (this column does not print by default)"]
[null,null,null,{"$f":"IF(K3=1,\"Easier\",IF(K3=2,\"Medium\",\"Harder\"))","v":"Easier"},null,1,"Multiply:           5.5 × 900","4950",null,null,1]
[null,null,null,{"$f":"IF(K4=1,\"Easier\",IF(K4=2,\"Medium\",\"Harder\"))","v":"Easier"},null,2,"Divide:           (-90) ÷ (-9)","810",null,null,1]
[null,null,null,"Easier",null,3,"Divide:           8000 ÷ 40","200",null,null,1]
[null,null,null,"Easier",null,4,"25% of 2000","500",null,null,1]
[null,null,null,"Medium",null,5,"490 – 10 × 13","360",null,null,2]
[null,null,null,"Medium",null,6,"182 + 12 × 15","362",null,null,2]
[null,null,null,"Medium",null,7,"4 × 2.5 × 4.9","49",null,null,2]
[null,null,null,"Medium",null,8,"8 + 2 × (-10)","-12",null,null,2]
[null,null,null,"Medium",null,9,"4 × (-4) × 5","-80",null,null,2]
[null,null,null,"Medium",null,10,"8 × (2  1/3)","18 2/3",null,null,2]
[null,null,null,"Medium",null,11,"(-9) × 0  + 1","1",null,null,2]
[null,null,null,"Medium",null,12,"15 × 17 + 36","291",null,null,2]
[null,null,null,"Medium",null,13,"(-8) × 9 –7","-79",null,null,2]
[null,null,null,"Medium",null,14,"(-2) × 0 –3","-3",null,null,2]
[null,null,null,"Harder",null,15,"30 – 8 × (-7)","86",null,null,3]
[null,null,null,"Harder",null,16,"5 × (-2) × (-5) – (-14)","64",null,null,3]
[null,null,null,"Harder",null,17,"11 – 10 × 5²","-239",null,null,3]
[null,null,null,"Harder",null,18,"0.3 × 470","141",null,null,3]
[null,null,null,"Harder",null,19,"1/2 × 6 + 8","11",null,null,3]
[null,null,null,"Harder",null,20,"3.5 × (-6) + 4","-17",null,null,3]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":20,"n_cols":21,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Worksheet!D3","v":"Easier"},{"$f":"IF($A1=\"Easier\",RANDBETWEEN(1,Easy),IF($A1=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A1=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard))))","v":9},{"$f":"IF(COUNTIF(B$1:B1,B1)<>1,IF($A1=\"Easier\",RANDBETWEEN(1,Easy),IF($A1=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A1=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B1)","v":9},{"$f":"IF(COUNTIF(C$1:C1,C1)<>1,IF($A1=\"Easier\",RANDBETWEEN(1,Easy),IF($A1=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A1=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C1)","v":9},{"$f":"IF(COUNTIF(D$1:D1,D1)<>1,IF($A1=\"Easier\",RANDBETWEEN(1,Easy),IF($A1=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A1=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D1)","v":9},{"$f":"IF(COUNTIF(E$1:E1,E1)<>1,IF($A1=\"Easier\",RANDBETWEEN(1,Easy),IF($A1=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A1=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E1)","v":9},1,{"$f":"VLOOKUP($F1,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"75% of 2800"},{"$f":"VLOOKUP($F1,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"2100"},null,null,null,null,null,null,null,null,null,null,null,"shading shapes"]
[{"$f":"Worksheet!D4","v":"Easier"},18,{"$f":"IF(COUNTIF(B$1:B2,B2)<>1,IF($A2=\"Easier\",RANDBETWEEN(1,Easy),IF($A2=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A2=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B2)","v":18},{"$f":"IF(COUNTIF(C$1:C2,C2)<>1,IF($A2=\"Easier\",RANDBETWEEN(1,Easy),IF($A2=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A2=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C2)","v":18},{"$f":"IF(COUNTIF(D$1:D2,D2)<>1,IF($A2=\"Easier\",RANDBETWEEN(1,Easy),IF($A2=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A2=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D2)","v":18},{"$f":"IF(COUNTIF(E$1:E2,E2)<>1,IF($A2=\"Easier\",RANDBETWEEN(1,Easy),IF($A2=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A2=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E2)","v":18},2,{"$f":"VLOOKUP($F2,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"Divide:           320000 ÷ 400"},{"$f":"VLOOKUP($F2,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"800"},null,null,null,null,null,null,null,null,null,null,null,"how many 4p grapes for 28p"]
[{"$f":"Worksheet!D5","v":"Easier"},19,{"$f":"IF(COUNTIF(B$1:B3,B3)<>1,IF($A3=\"Easier\",RANDBETWEEN(1,Easy),IF($A3=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A3=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B3)","v":19},{"$f":"IF(COUNTIF(C$1:C3,C3)<>1,IF($A3=\"Easier\",RANDBETWEEN(1,Easy),IF($A3=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A3=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C3)","v":19},{"$f":"IF(COUNTIF(D$1:D3,D3)<>1,IF($A3=\"Easier\",RANDBETWEEN(1,Easy),IF($A3=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A3=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D3)","v":19},{"$f":"IF(COUNTIF(E$1:E3,E3)<>1,IF($A3=\"Easier\",RANDBETWEEN(1,Easy),IF($A3=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A3=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E3)","v":19},3,{"$f":"VLOOKUP($F3,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"Divide:              140 ÷ 4"},{"$f":"VLOOKUP($F3,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"35"},null,null,null,null,null,null,null,null,null,null,null,"what do 9 pencils cost at 10p each"]
[{"$f":"Worksheet!D6","v":"Easier"},22,{"$f":"IF(COUNTIF(B$1:B4,B4)<>1,IF($A4=\"Easier\",RANDBETWEEN(1,Easy),IF($A4=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A4=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B4)","v":22},{"$f":"IF(COUNTIF(C$1:C4,C4)<>1,IF($A4=\"Easier\",RANDBETWEEN(1,Easy),IF($A4=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A4=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C4)","v":22},{"$f":"IF(COUNTIF(D$1:D4,D4)<>1,IF($A4=\"Easier\",RANDBETWEEN(1,Easy),IF($A4=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A4=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D4)","v":22},{"$f":"IF(COUNTIF(E$1:E4,E4)<>1,IF($A4=\"Easier\",RANDBETWEEN(1,Easy),IF($A4=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A4=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E4)","v":22},4,{"$f":"VLOOKUP($F4,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"5% of 14200"},{"$f":"VLOOKUP($F4,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"710"},null,null,null,null,null,null,null,null,null,null,null,"pounds/pence"]
[{"$f":"Worksheet!D7","v":"Medium"},45,{"$f":"IF(COUNTIF(B$1:B5,B5)<>1,IF($A5=\"Easier\",RANDBETWEEN(1,Easy),IF($A5=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A5=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B5)","v":45},{"$f":"IF(COUNTIF(C$1:C5,C5)<>1,IF($A5=\"Easier\",RANDBETWEEN(1,Easy),IF($A5=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A5=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C5)","v":45},{"$f":"IF(COUNTIF(D$1:D5,D5)<>1,IF($A5=\"Easier\",RANDBETWEEN(1,Easy),IF($A5=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A5=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D5)","v":45},{"$f":"IF(COUNTIF(E$1:E5,E5)<>1,IF($A5=\"Easier\",RANDBETWEEN(1,Easy),IF($A5=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A5=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E5)","v":45},5,{"$f":"VLOOKUP($F5,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"4 × 2.5 × 6.8"},{"$f":"VLOOKUP($F5,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"68"}]
[{"$f":"Worksheet!D8","v":"Medium"},32,{"$f":"IF(COUNTIF(B$1:B6,B6)<>1,IF($A6=\"Easier\",RANDBETWEEN(1,Easy),IF($A6=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A6=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B6)","v":32},{"$f":"IF(COUNTIF(C$1:C6,C6)<>1,IF($A6=\"Easier\",RANDBETWEEN(1,Easy),IF($A6=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A6=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C6)","v":32},{"$f":"IF(COUNTIF(D$1:D6,D6)<>1,IF($A6=\"Easier\",RANDBETWEEN(1,Easy),IF($A6=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A6=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D6)","v":32},{"$f":"IF(COUNTIF(E$1:E6,E6)<>1,IF($A6=\"Easier\",RANDBETWEEN(1,Easy),IF($A6=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A6=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E6)","v":32},6,{"$f":"VLOOKUP($F6,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"(-4) × (-9)  + 1"},{"$f":"VLOOKUP($F6,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"37"}]
[{"$f":"Worksheet!D9","v":"Medium"},47,{"$f":"IF(COUNTIF(B$1:B7,B7)<>1,IF($A7=\"Easier\",RANDBETWEEN(1,Easy),IF($A7=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A7=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B7)","v":47},{"$f":"IF(COUNTIF(C$1:C7,C7)<>1,IF($A7=\"Easier\",RANDBETWEEN(1,Easy),IF($A7=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A7=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C7)","v":47},{"$f":"IF(COUNTIF(D$1:D7,D7)<>1,IF($A7=\"Easier\",RANDBETWEEN(1,Easy),IF($A7=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A7=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D7)","v":47},{"$f":"IF(COUNTIF(E$1:E7,E7)<>1,IF($A7=\"Easier\",RANDBETWEEN(1,Easy),IF($A7=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A7=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E7)","v":47},7,{"$f":"VLOOKUP($F7,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"280 – (45 ÷ 9)"},{"$f":"VLOOKUP($F7,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"275"}]
[{"$f":"Worksheet!D10","v":"Medium"},42,{"$f":"IF(COUNTIF(B$1:B8,B8)<>1,IF($A8=\"Easier\",RANDBETWEEN(1,Easy),IF($A8=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A8=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B8)","v":42},{"$f":"IF(COUNTIF(C$1:C8,C8)<>1,IF($A8=\"Easier\",RANDBETWEEN(1,Easy),IF($A8=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A8=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C8)","v":42},{"$f":"IF(COUNTIF(D$1:D8,D8)<>1,IF($A8=\"Easier\",RANDBETWEEN(1,Easy),IF($A8=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A8=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D8)","v":42},{"$f":"IF(COUNTIF(E$1:E8,E8)<>1,IF($A8=\"Easier\",RANDBETWEEN(1,Easy),IF($A8=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A8=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E8)","v":42},8,{"$f":"VLOOKUP($F8,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"85 + 14 × 15"},{"$f":"VLOOKUP($F8,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"295"}]
[{"$f":"Worksheet!D11","v":"Medium"},36,{"$f":"IF(COUNTIF(B$1:B9,B9)<>1,IF($A9=\"Easier\",RANDBETWEEN(1,Easy),IF($A9=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A9=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B9)","v":36},{"$f":"IF(COUNTIF(C$1:C9,C9)<>1,IF($A9=\"Easier\",RANDBETWEEN(1,Easy),IF($A9=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A9=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C9)","v":36},{"$f":"IF(COUNTIF(D$1:D9,D9)<>1,IF($A9=\"Easier\",RANDBETWEEN(1,Easy),IF($A9=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A9=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D9)","v":36},{"$f":"IF(COUNTIF(E$1:E9,E9)<>1,IF($A9=\"Easier\",RANDBETWEEN(1,Easy),IF($A9=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A9=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E9)","v":36},9,{"$f":"VLOOKUP($F9,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"£1.65 × 300"},{"$f":"VLOOKUP($F9,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"£495.00"}]
[{"$f":"Worksheet!D12","v":"Medium"},44,{"$f":"IF(COUNTIF(B$1:B10,B10)<>1,IF($A10=\"Easier\",RANDBETWEEN(1,Easy),IF($A10=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A10=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B10)","v":44},{"$f":"IF(COUNTIF(C$1:C10,C10)<>1,IF($A10=\"Easier\",RANDBETWEEN(1,Easy),IF($A10=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A10=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C10)","v":44},{"$f":"IF(COUNTIF(D$1:D10,D10)<>1,IF($A10=\"Easier\",RANDBETWEEN(1,Easy),IF($A10=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A10=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D10)","v":44},{"$f":"IF(COUNTIF(E$1:E10,E10)<>1,IF($A10=\"Easier\",RANDBETWEEN(1,Easy),IF($A10=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A10=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E10)","v":44},10,{"$f":"VLOOKUP($F10,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"180 ÷ 4 ÷ 5"},{"$f":"VLOOKUP($F10,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"9"}]
[{"$f":"Worksheet!D13","v":"Medium"},31,{"$f":"IF(COUNTIF(B$1:B11,B11)<>1,IF($A11=\"Easier\",RANDBETWEEN(1,Easy),IF($A11=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A11=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B11)","v":31},{"$f":"IF(COUNTIF(C$1:C11,C11)<>1,IF($A11=\"Easier\",RANDBETWEEN(1,Easy),IF($A11=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A11=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C11)","v":31},{"$f":"IF(COUNTIF(D$1:D11,D11)<>1,IF($A11=\"Easier\",RANDBETWEEN(1,Easy),IF($A11=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A11=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D11)","v":31},{"$f":"IF(COUNTIF(E$1:E11,E11)<>1,IF($A11=\"Easier\",RANDBETWEEN(1,Easy),IF($A11=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A11=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E11)","v":31},11,{"$f":"VLOOKUP($F11,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"(-1) × 2 + 2"},{"$f":"VLOOKUP($F11,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"0"}]
[{"$f":"Worksheet!D14","v":"Medium"},34,{"$f":"IF(COUNTIF(B$1:B12,B12)<>1,IF($A12=\"Easier\",RANDBETWEEN(1,Easy),IF($A12=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A12=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B12)","v":34},{"$f":"IF(COUNTIF(C$1:C12,C12)<>1,IF($A12=\"Easier\",RANDBETWEEN(1,Easy),IF($A12=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A12=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C12)","v":34},{"$f":"IF(COUNTIF(D$1:D12,D12)<>1,IF($A12=\"Easier\",RANDBETWEEN(1,Easy),IF($A12=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A12=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D12)","v":34},{"$f":"IF(COUNTIF(E$1:E12,E12)<>1,IF($A12=\"Easier\",RANDBETWEEN(1,Easy),IF($A12=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A12=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E12)","v":34},12,{"$f":"VLOOKUP($F12,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"9 + 6 × (-10)"},{"$f":"VLOOKUP($F12,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"-51"}]
[{"$f":"Worksheet!D15","v":"Medium"},45,{"$f":"IF(COUNTIF(B$1:B13,B13)<>1,IF($A13=\"Easier\",RANDBETWEEN(1,Easy),IF($A13=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A13=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B13)","v":44},{"$f":"IF(COUNTIF(C$1:C13,C13)<>1,IF($A13=\"Easier\",RANDBETWEEN(1,Easy),IF($A13=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A13=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C13)","v":37},{"$f":"IF(COUNTIF(D$1:D13,D13)<>1,IF($A13=\"Easier\",RANDBETWEEN(1,Easy),IF($A13=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A13=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D13)","v":37},{"$f":"IF(COUNTIF(E$1:E13,E13)<>1,IF($A13=\"Easier\",RANDBETWEEN(1,Easy),IF($A13=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A13=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E13)","v":37},13,{"$f":"VLOOKUP($F13,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"Divide:           180 ÷ 40"},{"$f":"VLOOKUP($F13,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"4.5"}]
[{"$f":"Worksheet!D16","v":"Medium"},39,{"$f":"IF(COUNTIF(B$1:B14,B14)<>1,IF($A14=\"Easier\",RANDBETWEEN(1,Easy),IF($A14=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A14=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B14)","v":39},{"$f":"IF(COUNTIF(C$1:C14,C14)<>1,IF($A14=\"Easier\",RANDBETWEEN(1,Easy),IF($A14=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A14=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C14)","v":39},{"$f":"IF(COUNTIF(D$1:D14,D14)<>1,IF($A14=\"Easier\",RANDBETWEEN(1,Easy),IF($A14=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A14=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D14)","v":39},{"$f":"IF(COUNTIF(E$1:E14,E14)<>1,IF($A14=\"Easier\",RANDBETWEEN(1,Easy),IF($A14=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A14=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E14)","v":39},14,{"$f":"VLOOKUP($F14,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"Divide:           -8000 ÷ 50"},{"$f":"VLOOKUP($F14,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"80"}]
[{"$f":"Worksheet!D17","v":"Harder"},57,{"$f":"IF(COUNTIF(B$1:B15,B15)<>1,IF($A15=\"Easier\",RANDBETWEEN(1,Easy),IF($A15=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A15=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B15)","v":57},{"$f":"IF(COUNTIF(C$1:C15,C15)<>1,IF($A15=\"Easier\",RANDBETWEEN(1,Easy),IF($A15=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A15=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C15)","v":57},{"$f":"IF(COUNTIF(D$1:D15,D15)<>1,IF($A15=\"Easier\",RANDBETWEEN(1,Easy),IF($A15=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A15=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D15)","v":57},{"$f":"IF(COUNTIF(E$1:E15,E15)<>1,IF($A15=\"Easier\",RANDBETWEEN(1,Easy),IF($A15=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A15=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E15)","v":57},15,{"$f":"VLOOKUP($F15,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"0.9 × 3300"},{"$f":"VLOOKUP($F15,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"2970"}]
[{"$f":"Worksheet!D18","v":"Harder"},57,{"$f":"IF(COUNTIF(B$1:B16,B16)<>1,IF($A16=\"Easier\",RANDBETWEEN(1,Easy),IF($A16=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A16=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B16)","v":50},{"$f":"IF(COUNTIF(C$1:C16,C16)<>1,IF($A16=\"Easier\",RANDBETWEEN(1,Easy),IF($A16=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A16=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C16)","v":50},{"$f":"IF(COUNTIF(D$1:D16,D16)<>1,IF($A16=\"Easier\",RANDBETWEEN(1,Easy),IF($A16=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A16=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D16)","v":50},{"$f":"IF(COUNTIF(E$1:E16,E16)<>1,IF($A16=\"Easier\",RANDBETWEEN(1,Easy),IF($A16=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A16=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E16)","v":50},16,{"$f":"VLOOKUP($F16,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"Divide:           3115 ÷ 500"},{"$f":"VLOOKUP($F16,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"6.23"}]
[{"$f":"Worksheet!D19","v":"Harder"},56,{"$f":"IF(COUNTIF(B$1:B17,B17)<>1,IF($A17=\"Easier\",RANDBETWEEN(1,Easy),IF($A17=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A17=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B17)","v":56},{"$f":"IF(COUNTIF(C$1:C17,C17)<>1,IF($A17=\"Easier\",RANDBETWEEN(1,Easy),IF($A17=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A17=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C17)","v":56},{"$f":"IF(COUNTIF(D$1:D17,D17)<>1,IF($A17=\"Easier\",RANDBETWEEN(1,Easy),IF($A17=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A17=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D17)","v":56},{"$f":"IF(COUNTIF(E$1:E17,E17)<>1,IF($A17=\"Easier\",RANDBETWEEN(1,Easy),IF($A17=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A17=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E17)","v":56},17,{"$f":"VLOOKUP($F17,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"17 – 10 × 2²"},{"$f":"VLOOKUP($F17,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"-23"}]
[{"$f":"Worksheet!D20","v":"Harder"},53,{"$f":"IF(COUNTIF(B$1:B18,B18)<>1,IF($A18=\"Easier\",RANDBETWEEN(1,Easy),IF($A18=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A18=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B18)","v":53},{"$f":"IF(COUNTIF(C$1:C18,C18)<>1,IF($A18=\"Easier\",RANDBETWEEN(1,Easy),IF($A18=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A18=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C18)","v":53},{"$f":"IF(COUNTIF(D$1:D18,D18)<>1,IF($A18=\"Easier\",RANDBETWEEN(1,Easy),IF($A18=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A18=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D18)","v":53},{"$f":"IF(COUNTIF(E$1:E18,E18)<>1,IF($A18=\"Easier\",RANDBETWEEN(1,Easy),IF($A18=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A18=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E18)","v":53},18,{"$f":"VLOOKUP($F18,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"47 – 8 × (-4)"},{"$f":"VLOOKUP($F18,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"79"}]
[{"$f":"Worksheet!D21","v":"Harder"},55,{"$f":"IF(COUNTIF(B$1:B19,B19)<>1,IF($A19=\"Easier\",RANDBETWEEN(1,Easy),IF($A19=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A19=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B19)","v":55},{"$f":"IF(COUNTIF(C$1:C19,C19)<>1,IF($A19=\"Easier\",RANDBETWEEN(1,Easy),IF($A19=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A19=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C19)","v":55},{"$f":"IF(COUNTIF(D$1:D19,D19)<>1,IF($A19=\"Easier\",RANDBETWEEN(1,Easy),IF($A19=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A19=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D19)","v":55},{"$f":"IF(COUNTIF(E$1:E19,E19)<>1,IF($A19=\"Easier\",RANDBETWEEN(1,Easy),IF($A19=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A19=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E19)","v":55},19,{"$f":"VLOOKUP($F19,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"1/2 × (-8) + 7"},{"$f":"VLOOKUP($F19,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"3"}]
[{"$f":"Worksheet!D22","v":"Harder"},56,{"$f":"IF(COUNTIF(B$1:B20,B20)<>1,IF($A20=\"Easier\",RANDBETWEEN(1,Easy),IF($A20=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A20=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),B20)","v":51},{"$f":"IF(COUNTIF(C$1:C20,C20)<>1,IF($A20=\"Easier\",RANDBETWEEN(1,Easy),IF($A20=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A20=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),C20)","v":51},{"$f":"IF(COUNTIF(D$1:D20,D20)<>1,IF($A20=\"Easier\",RANDBETWEEN(1,Easy),IF($A20=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A20=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),D20)","v":51},{"$f":"IF(COUNTIF(E$1:E20,E20)<>1,IF($A20=\"Easier\",RANDBETWEEN(1,Easy),IF($A20=\"Medium\",RANDBETWEEN(Easy+1,Easy+Medium),IF($A20=\"Harder\",RANDBETWEEN(Easy+Medium+1,Easy+Medium+Hard),RANDBETWEEN(1,Easy+Medium+Hard)))),E20)","v":51},20,{"$f":"VLOOKUP($F20,'System DO NOT OPEN'!$A$8:$P$200,11)","v":"(-3)² – (-46)"},{"$f":"VLOOKUP($F20,'System DO NOT OPEN'!$A$8:$P$200,16)","v":"55"}]

{"sheet":"System DO NOT OPEN","index":2,"n_rows":110,"n_cols":17,"rows_kept":110,"cut":false,"hidden":false,"merged":[]}
["Must be sorted by column B"]
["Number of easy questions",{"$f":"COUNTIF(ABC,\"A\")","v":28},null,null,null,null,"A = basic"]
["Number of medium questions",{"$f":"COUNTIF(ABC,\"B\")","v":21},null,null,null,null,"B = routine"]
["Number of hard questions",{"$f":"COUNTIF(ABC,\"C\")","v":9},null,null,null,null,"C = A/B"]
["TOTAL",{"$f":"COUNT(Numbers)","v":58}]
[null,{"$f":"B2+B3+B4=B5","v":true}]
["Question number","Difficulty",null,null,null,null,null,null,null,null,null,null,null,null,null,"Answer","# occurences"]
[{"$f":"IF(ISBLANK(C8),\" \",ROW(B8)-7)","v":1},"A","Take away:     ",{"$f":"RANDBETWEEN(4,9)+RANDBETWEEN(0,9)/10+RANDBETWEEN(1,9)/100","v":7.7700000000000005}," – ",{"$f":"RANDBETWEEN(1,3)+RANDBETWEEN(1,9)/10","v":2.6},null,null,null,null,{"$f":"CONCATENATE(\"\",C8,\"\",D8,\"\",E8,\"\",F8,\"\",G8,\"\",H8,\"\",I8,\"\",J8,\"\")","v":"Take away:     7.77 – 2.6"},{"$f":"D8-F8","v":5.17},null,null,null,{"$f":"CONCATENATE(\"\",L8,\"\",M8,\"\",N8,\"\",O8,\"\")","v":"5.17"},4]
[2,"A","Add:           ",{"$f":"RANDBETWEEN(2,9)+RANDBETWEEN(0,9)/10+RANDBETWEEN(1,9)/100","v":6.17}," + ",{"$f":"RANDBETWEEN(11,29)+RANDBETWEEN(1,9)/10","v":18.2},null,null,null,null,"Add:           6.17 + 18.2",{"$f":"D9+F9","v":24.369999999999997},null,null,null,"24.37",3]
[3,"A","Multiply:           ",{"$f":"RANDBETWEEN(2,9)+RANDBETWEEN(0,9)/10+RANDBETWEEN(1,9)/100","v":3.18}," × ",{"$f":"RANDBETWEEN(6,9)","v":9},null,null,null,null,"Multiply:           3.18 × 9",{"$f":"D10*F10","v":28.62},null,null,null,"28.62",3]
[4,"A","Divide:           ",{"$f":"(RANDBETWEEN(2,9)+RANDBETWEEN(0,9)/10+RANDBETWEEN(1,9)/100)*F11","v":36.18}," ÷ ",{"$f":"RANDBETWEEN(6,9)","v":6},null,null,null,null,"Divide:           36.18 ÷ 6",{"$f":"D11/F11","v":6.03},null,null,null,"6.03",4]
[5,"A","Take away:     ",{"$f":"RANDBETWEEN(2,19)","v":19}," –  (",{"$f":"RANDBETWEEN(-15,-1)","v":-10},")",null,null,null,"Take away:     19 –  (-10)",{"$f":"D12-F12","v":29},null,null,null,"29",5]
[6,"A","Multiply:           ",{"$f":"RANDBETWEEN(2,10)","v":6}," × (",{"$f":"RANDBETWEEN(-10,-3)","v":-8},")",null,null,null,"Multiply:           6 × (-8)",{"$f":"D13*F13","v":-48},null,null,null,"-48"]
[7,"A","Multiply:           (",{"$f":"RANDBETWEEN(-9,-3)","v":-3},") × (",{"$f":"RANDBETWEEN(-10,-3)","v":-6},")",null,null,null,"Multiply:           (-3) × (-6)",{"$f":"D14*F14","v":18},null,null,null,"18",1]
[8,"A","Add:           ",{"$f":"RANDBETWEEN(2,20)","v":16}," +  (",{"$f":"RANDBETWEEN(-30,-1*D15)","v":-24},")",null,null,null,"Add:           16 +  (-24)",{"$f":"D15+F15","v":-8},null,null,null,"-8",2]
[9,"A",{"$f":"CHOOSE(RANDBETWEEN(1,2),\"25%\",\"75%\")","v":"75%"}," of ",{"$f":"4*RANDBETWEEN(2,9)*10^RANDBETWEEN(1,3)","v":2800},null,null,null,null,null,"75% of 2800",{"$f":"IF(C16=\"25%\",E16/4,E16/4*3)","v":2100},null,null,null,"2100",3]
[10,"A",{"$f":"RANDBETWEEN(2,4)*10","v":40},"% of ",{"$f":"10^RANDBETWEEN(1,3)*RANDBETWEEN(5,99)","v":5600},null,null,null,null,null,"40% of 5600",{"$f":"E17/100*C17","v":2240},null,null,null,"2240",3]
[11,"A",{"$f":"RANDBETWEEN(6,9)*10","v":90},"% of ",{"$f":"10^RANDBETWEEN(1,3)*RANDBETWEEN(5,99)","v":710},null,null,null,null,null,"90% of 710",{"$f":"E18/100*C18","v":639},null,null,null,"639",3]
[12,"A","Divide:           ",{"$f":"-1*F19*RANDBETWEEN(2,10)","v":36}," ÷ (",{"$f":"RANDBETWEEN(-10,-2)","v":-4},")",null,null,null,"Divide:           36 ÷ (-4)",{"$f":"D19*F19","v":-144},null,null,null,"-144"]
[13,"A","Divide:           (",{"$f":"F20*RANDBETWEEN(2,10)","v":-35},") ÷ (",{"$f":"RANDBETWEEN(-10,-2)","v":-7},")",null,null,null,"Divide:           (-35) ÷ (-7)",{"$f":"D20*F20","v":245},null,null,null,"245",2]
[14,"A","Multiply:        ",{"$f":"RANDBETWEEN(12,15)","v":12}," × ",{"$f":"RANDBETWEEN(12,19)","v":16},null,null,null,null,"Multiply:        12 × 16",{"$f":"D21*F21","v":192},null,null,null,"192",2]
[15,"A","Multiply:        ",{"$f":"RANDBETWEEN(11,19)","v":12}," × ",{"$f":"RANDBETWEEN(2,9)*10^RANDBETWEEN(2,3)","v":7000},null,null,null,null,"Multiply:        12 × 7000",{"$f":"D22*F22","v":84000},null,null,null,"84000",2]
[16,"A","Take away:     ",{"$f":"RANDBETWEEN(4,9)+RANDBETWEEN(0,9)/10+RANDBETWEEN(0,9)/100+RANDBETWEEN(1,9)/1000","v":7.0839999999999996}," – ",{"$f":"RANDBETWEEN(1,3)+RANDBETWEEN(1,9)/10","v":2.8},null,null,null,null,"Take away:     7.084 – 2.8",{"$f":"D23-F23","v":4.2839999999999998},null,null,null,"4.284",6]
[17,"A","Multiply:           ",{"$f":"RANDBETWEEN(1,5)+0.5","v":2.5}," × ",{"$f":"RANDBETWEEN(2,9)*10^RANDBETWEEN(0,2)","v":8},null,null,null,null,"Multiply:           2.5 × 8",{"$f":"D24*F24","v":20},null,null,null,"20",1]
[18,"A","Divide:           ",{"$f":"F25*L25","v":320000}," ÷ ",{"$f":"RANDBETWEEN(2,5)*10^RANDBETWEEN(1,2)","v":400},null,null,null,null,"Divide:           320000 ÷ 400",{"$f":"RANDBETWEEN(2,9)*10^RANDBETWEEN(1,2)","v":800},null,null,null,"800",6]
[19,"A","Divide:              ",{"$f":"RANDBETWEEN(21,99)*F26","v":140}," ÷ ",{"$f":"RANDBETWEEN(4,9)","v":4},null,null,null,null,"Divide:              140 ÷ 4",{"$f":"D26/F26","v":35},null,null,null,"35",3]
[20,"A","Calculate:     ",{"$f":"RANDBETWEEN(2,F27-1)","v":5},"/",{"$f":"RANDBETWEEN(5,9)","v":6}," of ",{"$f":"F27*RANDBETWEEN(5,90)","v":126},null,null,"Calculate:     5/6 of 126",{"$f":"H27/F27*D27","v":105},null,null,null,"105",3]
[21,"A","(",{"$f":"RANDBETWEEN(-10,-2)","v":-8},")²",null,null,null,null,null,"(-8)²",{"$f":"D28^2","v":64},null,null,null,"64",3]
[22,"A",5,"% of ",{"$f":"2*10^RANDBETWEEN(1,3)*RANDBETWEEN(5,99)","v":14200},null,null,null,null,null,"5% of 14200",{"$f":"E29/100*C29","v":710},null,null,null,"710",3]
[23,"A",{"$f":"RANDBETWEEN(101,999)","v":209},{"$f":"RANDBETWEEN(1001,9999)","v":1653},{"$f":"RANDBETWEEN(1001,9999)","v":2836},{"$f":"RANDBETWEEN(101,999)","v":311},{"$f":"RANDBETWEEN(1001,9999)","v":1545},{"$f":"RANDBETWEEN(101,999)","v":865},{"$f":"RANDBETWEEN(101,999)","v":906},null,{"$f":"CONCATENATE(\"\",C30,\" + \",D30,\"+ \",E30,\" + \",F30,\" + \",G30,\" + \",H30,\" + \",I30,\"\",J30,\"\")","v":"209 + 1653+ 2836 + 311 + 1545 + 865 + 906"},{"$f":"SUM(C30:I30)","v":8325},null,null,null,"8325",1]
[24,"A","Calculate:     ",{"$f":"RANDBETWEEN(2,F31-1)","v":3},"/",{"$f":"RANDBETWEEN(5,9)","v":5}," of £",{"$f":"TEXT(F31*(RANDBETWEEN(1,5)+RANDBETWEEN(1,99)/100),\"##.00\")","v":"13.80"},null,null,{"$f":"CONCATENATE(\"\",C31,\"\",D31,\"\",E31,\"\",F31,\"\",G31,\"\",H31,\"\",I31,\"\",J31,\"\")","v":"Calculate:     3/5 of £13.80"},"£",{"$f":"H31/F31*D31","v":8.2800000000000011},null,null,"£8.28",4]
[25,"A","What is the square root of ",{"$f":"RANDBETWEEN(3,12)^2","v":121},"?",null,null,null,null,null,{"$f":"CONCATENATE(\"\",C32,\"\",D32,\"\",E32,\"\",F32,\"\",G32,\"\",H32,\"\",I32,\"\",J32,\"\")","v":"What is the square root of 121?"},{"$f":"SQRT(D32)","v":11},null,null,null,"11",1]
[26,"A","Add:           (",{"$f":"RANDBETWEEN(-50,-20)","v":-48},") + ",{"$f":"RANDBETWEEN(10,-1*D33)","v":36},null,null,null,null,{"$f":"CONCATENATE(\"\",C33,\"\",D33,\"\",E33,\"\",F33,\"\",G33,\"\",H33,\"\",I33,\"\",J33,\"\")","v":"Add:           (-48) + 36"},{"$f":"D33+F33","v":-12},null,null,null,"-12",7]
[27,"A","Write down the number ",{"$f":"RANDBETWEEN(2,20)","v":19},{"$f":"CHOOSE(RANDBETWEEN(1,2),\"million\",\"billion\")","v":"million"}," in full",null,null,null,null,{"$f":"CONCATENATE(\"\",C34,\"\",D34,\" \",E34,\"\",F34,\"\",G34,\"\",H34,\"\",I34,\"\",J34,\"\")","v":"Write down the number 19 million in full"},{"$f":"D34","v":19},",000,000",{"$f":"IF(E34=\"billion\",\",000\",\"\")","v":""},null,"19,000,000",2]
[28,"A","Write down the number ","half a ",{"$f":"CHOOSE(RANDBETWEEN(1,2),\"million\",\"billion\")","v":"million"}," in full",null,null,null,null,{"$f":"CONCATENATE(\"\",C35,\"\",D35,\" \",E35,\"\",F35,\"\",G35,\"\",H35,\"\",I35,\"\",J35,\"\")","v":"Write down the number half a  million in full"},5,"00,000",{"$f":"IF(E35=\"billion\",\",000\",\"\")","v":""},null,"500,000",2]
[29,"B","(",{"$f":" RANDBETWEEN(-10,-1)","v":-8},") × ",{"$f":"RANDBETWEEN(2,9)","v":7}," –",{"$f":"RANDBETWEEN(2,10)","v":2},null,null,{"$f":"CONCATENATE(\"\",C36,\"\",D36,\"\",E36,\"\",F36,\"\",G36,\"\",H36,\"\",I36,\"\",J36,\"\")","v":"(-8) × 7 –2"},{"$f":"D36*F36-H36","v":-58},null,null,null,"-58",2]
[30,"B","(",{"$f":" RANDBETWEEN(-10,-1)","v":-9},") × ",0," –",{"$f":"RANDBETWEEN(2,10)","v":3},null,null,"(-9) × 0 –3",{"$f":"D37*F37-H37","v":-3},null,null,null,"-3",4]
[31,"B","(",{"$f":" RANDBETWEEN(-10,-1)","v":-1},") × ",{"$f":"RANDBETWEEN(2,9)","v":2}," + ",{"$f":"RANDBETWEEN(1,5)","v":2},null,null,"(-1) × 2 + 2",{"$f":"D38*F38+H38","v":0},null,null,null,"0",3]
[32,"B","(",{"$f":" RANDBETWEEN(-10,-1)","v":-4},") × (",{"$f":"RANDBETWEEN(-10,-2)","v":-9},")  + ",{"$f":"RANDBETWEEN(1,5)","v":1},null,null,"(-4) × (-9)  + 1",{"$f":"D39*F39+H39","v":37},null,null,null,"37",10]
[{"$f":"IF(ISBLANK(C40),\" \",ROW(B40)-7)","v":33},"B","(",{"$f":" RANDBETWEEN(-10,-1)","v":-3},") × ",0,"  + ",{"$f":"RANDBETWEEN(1,5)","v":3},null,null,"(-3) × 0  + 3",{"$f":"D40*F40+H40","v":3},null,null,null,{"$f":"CONCATENATE(\"\",L40,\"\",M40,\"\",N40,\"\",O40,\"\")","v":"3"},7]
[34,"B",{"$f":"RANDBETWEEN(1,10)","v":9}," + ",{"$f":"RANDBETWEEN(2,10)","v":6}," × (",{"$f":"RANDBETWEEN(-10,-1)","v":-10},")",null,null,"9 + 6 × (-10)",{"$f":"C41+E41*G41","v":-51},null,null,null,"-51",2]
[35,"B",{"$f":"RANDBETWEEN(2,5)","v":3}," × (",{"$f":"RANDBETWEEN(-5,-2)","v":-2},") × ",{"$f":"RANDBETWEEN(2,5)","v":3},null,null,null,"3 × (-2) × 3",{"$f":"C42*E42*G42","v":-18},null,null,null,"-18",2]
[36,"B","£",{"$f":"RANDBETWEEN(1,3)+RANDBETWEEN(1,99)/100","v":1.65}," × ",{"$f":"RANDBETWEEN(2,9)*10^RANDBETWEEN(1,3)","v":300},null,null,null,null,"£1.65 × 300","£",{"$f":"TEXT(D43*F43,\"##.00\")","v":"495.00"},null,null,"£495.00",2]
[37,"B","Divide:           ",{"$f":"F44*L44","v":180}," ÷ ",{"$f":"RANDBETWEEN(2,5)*10^RANDBETWEEN(1,2)","v":40},null,null,null,null,"Divide:           180 ÷ 40",{"$f":"RANDBETWEEN(2,6)+0.5","v":4.5},null,null,null,"4.5",1]
[38,"B","Divide:           ",{"$f":"F45*L45","v":930}," ÷ ",{"$f":"RANDBETWEEN(2,5)*10^RANDBETWEEN(1,2)","v":300},null,null,null,null,"Divide:           930 ÷ 300",{"$f":"RANDBETWEEN(2,6)+RANDBETWEEN(1,9)/10","v":3.1},null,null,null,"3.1",1]
[39,"B","Divide:           ",{"$f":"F46*L46*(-1)*RANDBETWEEN(1,2)","v":-8000}," ÷ ",{"$f":"RANDBETWEEN(2,5)*10^RANDBETWEEN(1,2)*RANDBETWEEN(1,2)","v":50},null,null,null,null,"Divide:           -8000 ÷ 50",{"$f":"RANDBETWEEN(2,9)*10^RANDBETWEEN(1,2)","v":80},null,null,null,"80",2]
[40,"B","Divide:              ",{"$f":"RANDBETWEEN(1,999)","v":855}," ÷ ",{"$f":"10^RANDBETWEEN(2,3)","v":1000},null,null,null,null,"Divide:              855 ÷ 1000",{"$f":"D47/F47","v":0.85499999999999998},null,null,null,"0.855",1]
[41,"B",{"$f":"RANDBETWEEN(12,15)","v":12}," × ",{"$f":"RANDBETWEEN(12,19)","v":14}," + ",{"$f":"RANDBETWEEN(20,199)","v":193},null,null,null,"12 × 14 + 193",{"$f":"C48*E48+G48","v":361},null,null,null,"361",2]
[42,"B",{"$f":"RANDBETWEEN(20,199)","v":85}," + ",{"$f":"RANDBETWEEN(12,15)","v":14}," × ",{"$f":"RANDBETWEEN(12,19)","v":15},null,null,null,"85 + 14 × 15",{"$f":"C49+E49*G49","v":295},null,null,null,"295",2]
[43,"B",{"$f":"RANDBETWEEN(20,49)*10","v":420}," – ",{"$f":"RANDBETWEEN(1,2)*10","v":10}," × ",{"$f":"RANDBETWEEN(6,15)","v":11},null,null,null,"420 – 10 × 11",{"$f":"C50-E50*G50","v":310},null,null,null,"310",2]
[44,"B",{"$f":"L51*G51*E51","v":180}," ÷ ",{"$f":"RANDBETWEEN(2,10)","v":4}," ÷ ",{"$f":"RANDBETWEEN(5,10)","v":5},null,null,null,"180 ÷ 4 ÷ 5",{"$f":"RANDBETWEEN(3,9)","v":9},null,null,null,"9",7]
[45,"B",{"$f":"4*RANDBETWEEN(1,3)","v":4}," × ","2.5 × ",{"$f":"RANDBETWEEN(1,9)+RANDBETWEEN(1,9)/10","v":6.8},null,null,null,null,"4 × 2.5 × 6.8",{"$f":"C52*2.5*F52","v":68},null,null,null,"68",3]
[46,"B",{"$f":"RANDBETWEEN(4,9)","v":6}," × ","(",{"$f":"RANDBETWEEN(1,4)","v":1},"  ",{"$f":"TEXT(CHOOSE(RANDBETWEEN(1,2),1/3,2/3),\"#/#\")","v":"2/3"},")",null,"6 × (1  2/3)",{"$f":"TEXT((F53+(IF(H53=\"1/3\",0.33333333,0.66666666)))*C53,\"## ##/##\")","v":"10"},null,null,null,"10",5]
[47,"B",{"$f":"RANDBETWEEN(11,99)*10","v":280}," – (",{"$f":"G54*RANDBETWEEN(2,9)*10^RANDBETWEEN(0,1)","v":45}," ÷ ",{"$f":"RANDBETWEEN(2,9)","v":9},")",null,null,"280 – (45 ÷ 9)",{"$f":"C54-(E54/G54)","v":275},null,null,null,"275",1]
[48,"B","Multiply:         ",{"$f":"RANDBETWEEN(11,19)","v":11}," × ",{"$f":"RANDBETWEEN(4,9)","v":6}," × ",{"$f":"RANDBETWEEN(4,9)","v":4},null,null,"Multiply:         11 × 6 × 4",{"$f":"D55*F55*H55","v":264},null,null,null,"264",1]
[49,"B",{"$f":"RANDBETWEEN(2,9)","v":5},"% of £",{"$f":"RANDBETWEEN(2,99)*10^RANDBETWEEN(2,3)","v":7000},null,null,null,null,null,"5% of £7000","£",{"$f":"E56/100*C56","v":350},null,null,"£350",5]
[50,"C","Divide:           ",{"$f":"F57*L57","v":3115}," ÷ ",{"$f":"RANDBETWEEN(2,5)*10^RANDBETWEEN(1,2)","v":500},null,null,null,null,"Divide:           3115 ÷ 500",{"$f":"RANDBETWEEN(2,6)+RANDBETWEEN(1,99)/100","v":6.23},null,null,null,"6.23",2]
[51,"C","(",{"$f":"RANDBETWEEN(-10,-2)","v":-3},")²"," – (",{"$f":"RANDBETWEEN(-99,-20)","v":-46},")",null,null,"(-3)² – (-46)",{"$f":"D58^2-G58","v":55},null,null,null,"55",1]
[52,"C",{"$f":"RANDBETWEEN(2,5)","v":4}," × (",{"$f":"RANDBETWEEN(-5,-2)","v":-5},") × (",{"$f":"RANDBETWEEN(-5,-1)","v":-4},") – (",{"$f":"RANDBETWEEN(-30,-10)","v":-21},")","4 × (-5) × (-4) – (-21)",{"$f":"C59*E59*G59-I59","v":101},null,null,null,"101",1]
[53,"C",{"$f":"RANDBETWEEN(10,80)","v":47}," – ",{"$f":"RANDBETWEEN(2,10)","v":8}," × (",{"$f":"RANDBETWEEN(-9,-1)","v":-4},")",null,null,"47 – 8 × (-4)",{"$f":"C60-E60*G60","v":79},null,null,null,"79",2]
[54,"C",{"$f":"RANDBETWEEN(1,4)+0.5","v":1.5},{"$f":"CONCATENATE(\" × \",IF(E61<0,\"(\",\"\"))","v":" × ("},{"$f":"RANDBETWEEN(1,5)*2*(-1)^RANDBETWEEN(1,2)","v":-2},{"$f":"CONCATENATE(IF(E61<0,\")\",\"\"),\" + \")","v":") + "},{"$f":"RANDBETWEEN(2,10)","v":3},null,null,null,"1.5 × (-2) + 3",{"$f":"C61*E61+G61","v":0},null,null,null,"0",2]
[55,"C","1/2",{"$f":"CONCATENATE(\" × \",IF(E62<0,\"(\",\"\"))","v":" × ("},{"$f":"RANDBETWEEN(1,5)*2*(-1)^RANDBETWEEN(1,2)","v":-8},{"$f":"CONCATENATE(IF(E62<0,\")\",\"\"),\" + \")","v":") + "},{"$f":"RANDBETWEEN(2,10)","v":7},null,null,null,"1/2 × (-8) + 7",{"$f":"E62/2+G62","v":3},null,null,null,"3",1]
[56,"C",{"$f":"RANDBETWEEN(10,30)","v":17}," – ",{"$f":"RANDBETWEEN(3,10)","v":10}," × ",{"$f":"RANDBETWEEN(2,5)","v":2},"²",null,null,"17 – 10 × 2²",{"$f":"C63-E63*G63^2","v":-23},null,null,null,"-23",1]
[57,"C",{"$f":"RANDBETWEEN(2,9)/10","v":0.9}," × ",{"$f":"RANDBETWEEN(1,99)*10^RANDBETWEEN(1,2)","v":3300},null,null,null,null,null,"0.9 × 3300",{"$f":"C64*E64","v":2970},null,null,null,"2970",1]
[58,"C",{"$f":"RANDBETWEEN(2,9)/100","v":0.03}," × ",{"$f":"RANDBETWEEN(1,99)*10^RANDBETWEEN(2,3)","v":1800},null,null,null,null,null,"0.03 × 1800",{"$f":"C65*E65","v":54},null,null,null,"54",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,""]
[" "]
[" "]
[" "]
[" "]
[{"$f":"IF(ISBLANK(C72),\" \",ROW(B72)-7)","v":" "}]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]
[{"$f":"IF(ISBLANK(C104),\" \",ROW(B104)-7)","v":" "}]
[" "]
[" "]
[" "]
[" "]
[" "]
[" "]