{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Worksheet","SYSTEM FORMULAE"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":16,"n_cols":37,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,1],[4,0,4,1],[0,2,0,36]]}
[null,null,{"$f":"CONCATENATE(\"Express each expression in the form   \",IF(B6,\"a(x + b)² + c   \",\"(x + a)² + b   \"))","v":"Express each expression in the form   (x + a)² + b   "}]
["Variables",null,1,1,"w","²","–",8,"w","–",2,1,"(","w","–",4,")²","–",18,null,16,1,"b","²","+",16,"b","+",15,1,"(","b","+",8,")²","–",49]
["SHOW ANSWERS",false,2,1,"y","²","+",4,"y","+",14,1,"(","y","+",2,")²","+",10,null,17,1,"x","²","–",12,"x","+",41,1,"(","x","–",6,")²","+",5]
["Number of questions (minimum 10, maximum 30)",30,3,1,"y","²","–",8,"y","+",46,1,"(","y","–",4,")²","+",30,null,18,1,"x","²","–",8,"x","+",1,1,"(","x","–",4,")²","–",15]
[{"$f":"IF(B6,\"Restrictions on px² + qx + r =                 a(x + b)² + c\",\"Restrictions on px² + qx + r =              (x + a)² + b\")","v":"Restrictions on px² + qx + r =              (x + a)² + b"},null,4,1,"y","²","+",10,"y","+",45,1,"(","y","+",5,")²","+",20,null,19,1,"y","²","–",18,"y","–",8,1,"(","y","–",9,")²","–",89]
["a allowed to be ≠1",false,5,1,"a","²","+",18,"a","+",27,1,"(","a","+",9,")²","–",54,null,20,1,"p","²","+",8,"p","+",7,1,"(","p","+",4,")²","–",9]
[{"$f":"IF(B6,\"q chosen so as to give integer values of b\",\"b chosen so as to give integer values of a\")","v":"b chosen so as to give integer values of a"},true,6,1,"y","²","–",2,"y","–",15,1,"(","y","–",1,")²","–",16,null,21,1,"m","²","+",18,"m","+",23,1,"(","m","+",9,")²","–",58]
[null,null,7,1,"b","²","+",8,"b","–",11,1,"(","b","+",4,")²","–",27,null,22,1,"x","²","–",6,"x","+",14,1,"(","x","–",3,")²","+",5]
[null,null,8,1,"y","²","–",6,"y","+",28,1,"(","y","–",3,")²","+",19,null,23,1,"y","²","+",14,"y","–",4,1,"(","y","+",7,")²","–",53]
[null,null,9,1,"x","²","–",8,"x","+",49,1,"(","x","–",4,")²","+",33,null,24,1,"y","²","–",6,"y","+",1,1,"(","y","–",3,")²","–",8]
[null,null,10,1,"y","²","+",16,"y","–",12,1,"(","y","+",8,")²","–",76,null,25,1,"y","²","+",2,"y","+",50,1,"(","y","+",1,")²","+",49]
[null,null,11,1,"m","²","–",10,"m","+",4,1,"(","m","–",5,")²","–",21,null,26,1,"y","²","+",8,"y","–",5,1,"(","y","+",4,")²","–",21]
[null,null,12,1,"n","²","–",2,"n","+",8,1,"(","n","–",1,")²","+",7,null,27,1,"p","²","–",20,"p","+",21,1,"(","p","–",10,")²","–",79]
[null,null,13,1,"y","²","–",14,"y","+",43,1,"(","y","–",7,")²","–",6,null,28,1,"x","²","+",6,"x","+",48,1,"(","x","+",3,")²","+",39]
[null,null,14,1,"m","²","–",20,"m","+",24,1,"(","m","–",10,")²","–",76,null,29,1,"m","²","+",14,"m","+",25,1,"(","m","+",7,")²","–",24]
[null,null,15,1,"a","²","+",14,"a","+",39,1,"(","a","+",7,")²","–",10,null,30,1,"p","²","–",16,"p","+",46,1,"(","p","–",8,")²","–",18]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":15,"n_cols":35,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":1},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},{"$f":"CHOOSE(RANDBETWEEN(1,20),\"a\",\"b\",\"g\",\"x\",\"x\",\"x\",\"x\",\"m\",\"n\",\"y\",\"y\",\"y\",\"y\",\"x\",\"w\",\"m\",\"p\",\"y\",\"k\",\"m\")","v":"y"},"²",{"$f":"IF(F1<0,\"–\",\"+\")","v":"–"},{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B1,1))","v":-10},{"$f":"C1","v":"y"},{"$f":"IF(I1<0,\"–\",\"+\")","v":"+"},{"$f":"RANDBETWEEN(-20,50)","v":17},{"$f":"B1","v":1},"(",{"$f":"C1","v":"y"},{"$f":"IF(N1<0,\"–\",\"+\")","v":"–"},{"$f":"(F1/B1)/2","v":-5},")²",{"$f":"IF(Q1<0,\"–\",\"+\")","v":"–"},{"$f":"I1-N1^2*J1","v":-8},null,{"$f":"MAX(A1:A40)+1","v":16},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},{"$f":"CHOOSE(RANDBETWEEN(1,20),\"a\",\"b\",\"g\",\"x\",\"x\",\"x\",\"x\",\"m\",\"n\",\"y\",\"y\",\"y\",\"y\",\"x\",\"w\",\"m\",\"p\",\"y\",\"k\",\"m\")","v":"y"},"²",{"$f":"IF(X1<0,\"–\",\"+\")","v":"–"},{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T1,1))","v":-20},{"$f":"U1","v":"y"},{"$f":"IF(AA1<0,\"–\",\"+\")","v":"+"},{"$f":"RANDBETWEEN(-20,50)","v":4},{"$f":"T1","v":1},"(",{"$f":"U1","v":"y"},{"$f":"IF(AF1<0,\"–\",\"+\")","v":"–"},{"$f":"(X1/T1)/2","v":-10},")²",{"$f":"IF(AI1<0,\"–\",\"+\")","v":"–"},{"$f":"AA1-AF1^2*AB1","v":-96}]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":2},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},{"$f":"CHOOSE(RANDBETWEEN(1,20),\"a\",\"b\",\"g\",\"x\",\"x\",\"x\",\"x\",\"m\",\"n\",\"y\",\"y\",\"y\",\"y\",\"x\",\"w\",\"m\",\"p\",\"y\",\"k\",\"m\")","v":"y"},"²",{"$f":"IF(F2<0,\"–\",\"+\")","v":"–"},{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B2,1))","v":-8},{"$f":"C2","v":"y"},{"$f":"IF(I2<0,\"–\",\"+\")","v":"+"},{"$f":"RANDBETWEEN(-20,50)","v":27},{"$f":"B2","v":1},"(",{"$f":"C2","v":"y"},{"$f":"IF(N2<0,\"–\",\"+\")","v":"–"},{"$f":"(F2/B2)/2","v":-4},")²",{"$f":"IF(Q2<0,\"–\",\"+\")","v":"+"},{"$f":"I2-N2^2*J2","v":11},null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S1+1,\"\")","v":17},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"y","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T2,1))","v":-20},"y","–",-1,1,"(","y","–",-10,")²","–",-101]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":3},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"p","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B3,1))","v":-20},"p","+",0,1,"(","p","–",-10,")²","–",-100,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S2+1,\"\")","v":18},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"x","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T3,1))","v":-6},"x","+",29,1,"(","x","–",-3,")²","+",20]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":4},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"y","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B4,1))","v":-16},"y","–",-20,1,"(","y","–",-8,")²","–",-84,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S3+1,\"\")","v":19},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"p","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T4,1))","v":-8},"p","–",-17,1,"(","p","–",-4,")²","–",-33]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":5},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"y","²","+",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B5,1))","v":14},"y","+",30,1,"(","y","+",7,")²","–",-19,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S4+1,\"\")","v":20},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"x","²","+",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T5,1))","v":16},"x","+",21,1,"(","x","+",8,")²","–",-43]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":6},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"w","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B6,1))","v":-2},"w","–",-1,1,"(","w","–",-1,")²","–",-2,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S5+1,\"\")","v":21},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"x","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T6,1))","v":-14},"x","–",-14,1,"(","x","–",-7,")²","–",-63]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":7},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"p","²","+",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B7,1))","v":14},"p","+",14,1,"(","p","+",7,")²","–",-35,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S6+1,\"\")","v":22},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"k","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T7,1))","v":-18},"k","+",24,1,"(","k","–",-9,")²","–",-57]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":8},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"m","²","+",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B8,1))","v":14},"m","+",38,1,"(","m","+",7,")²","–",-11,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S7+1,\"\")","v":23},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"m","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T8,1))","v":-8},"m","–",-16,1,"(","m","–",-4,")²","–",-32]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":9},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"x","²","+",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B9,1))","v":8},{"$f":"C9","v":"x"},"–",-17,{"$f":"B9","v":1},"(",{"$f":"C9","v":"x"},"+",{"$f":"(F9/B9)/2","v":4},")²","–",{"$f":"I9-N9^2*J9","v":-33},null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S8+1,\"\")","v":24},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"y","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T9,1))","v":-8},"y","+",40,1,"(","y","–",-4,")²","+",24]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":10},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"x","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B10,1))","v":-12},"x","+",29,1,"(","x","–",-6,")²","–",-7,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S9+1,\"\")","v":25},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"x","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T10,1))","v":-6},"x","–",-13,1,"(","x","–",-3,")²","–",-22]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":11},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"x","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B11,1))","v":-4},"x","–",-5,1,"(","x","–",-2,")²","–",-9,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S10+1,\"\")","v":26},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"y","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T11,1))","v":-8},"y","+",32,1,"(","y","–",-4,")²","+",16]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":12},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"y","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B12,1))","v":-18},"y","–",-6,1,"(","y","–",-9,")²","–",-87,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S11+1,\"\")","v":27},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"g","²","+",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T12,1))","v":12},"g","+",48,1,"(","g","+",6,")²","+",12]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":13},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"m","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B13,1))","v":-4},"m","+",6,1,"(","m","–",-2,")²","+",2,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S12+1,\"\")","v":28},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"y","²","+",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T13,1))","v":20},"y","+",8,1,"(","y","+",10,")²","–",-92]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":14},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"k","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B14,1))","v":-10},"k","+",0,1,"(","k","–",-5,")²","–",-25,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S13+1,\"\")","v":29},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"x","²","–",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T14,1))","v":-6},"x","+",33,1,"(","x","–",-3,")²","+",24]
[{"$f":"IF(ROW()<=Worksheet!$B$4/2,ROW(),\"\")","v":15},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"p","²","+",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!B15,1))","v":4},"p","+",13,1,"(","p","+",2,")²","+",9,null,{"$f":"IF(ROW()<=Worksheet!$B$4/2,S14+1,\"\")","v":30},{"$f":"IF(Worksheet!$B$6,RANDBETWEEN(1,5),1)","v":1},"m","²","+",{"$f":"2*RANDBETWEEN(1,10)*(-1)^RANDBETWEEN(1,2)*(IF(Worksheet!$B$7,'SYSTEM FORMULAE'!T15,1))","v":2},"m","–",-10,1,"(","m","+",1,")²","–",-11]