{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Worksheet","SYSTEM FORMULAE"],"not_rendered":{"charts":0,"images":1,"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":17,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,2,0,18],[2,0,2,1],[4,0,4,1]]}
[null,null,"Complete the table of values and then draw the graph on the axes below"]
[null,null,1,null,"y = 3x – 5",null,null,null,null,null,2,null,"y = 5x – 1"]
["Variables",null,null,null,"x",2,3,4,5,null,null,null,"x",0,1,2,3]
["SHOW ANSWERS",false,null,null,"y",1,4,7,10,null,null,null,"y","– 1",4,9,14]
["Tables of values"]
["Use x = 0, 1, 2, 3 in all tables of values",false]
["Allow negative values in table of values?",false]
[]
[]
[]
[]
[]
[]
[null,null,3,null,"y = 5x – 4",null,null,null,null,null,4,null,"y = 5x – 3"]
[null,null,null,null,"x",0,1,2,3,null,null,null,"x",0,1,2,3]
[null,null,null,null,"y","– 4",1,6,11,null,null,null,"y","– 3",2,7,12]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"y"," = ",{"$f":"CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(1,5),RANDBETWEEN(-5,-1))","v":-2},"x","+",{"$f":"RANDBETWEEN(-5,5)","v":-1},null,"y"," = ",{"$f":"CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(1,5),RANDBETWEEN(-5,-1))","v":2},"x","+",{"$f":"RANDBETWEEN(-5,5)","v":5}]
[1,null,{"$f":"IF(AND(H1>0,E1<0),CONCATENATE(C1,D1,H1,\" \",IF(E1=1,\"\",IF(E1=-1,\" - \",E1)),F1),IF(H1=0,CONCATENATE(C1,D1,IF(E1=1,\"\",IF(E1=-1,\" - \",E1)),F1),CONCATENATE(C1,D1,IF(E1=1,\"\",IF(E1=-1,\" - \",E1)),F1,IF(H1<0,\"\",\" + \"),\" \",H1)))","v":"y = -2x -1"},null,null,null,null,null,null,{"$f":"IF(AND(O1>0,L1<0),CONCATENATE(J1,K1,O1,\" \",IF(L1=1,\"\",IF(L1=-1,\" - \",L1)),M1),IF(O1=0,CONCATENATE(J1,K1,IF(L1=1,\"\",IF(L1=-1,\" - \",L1)),M1),CONCATENATE(J1,K1,IF(L1=1,\"\",IF(L1=-1,\" - \",L1)),M1,IF(O1<0,\"\",\" + \"),\" \",O1)))","v":"y = 2x +  5"}]
[null,null,"x",{"$f":"IF(Worksheet!$B$6,0,IF(Worksheet!$B$7,RANDBETWEEN(MAX(-10,D6),MIN(-1,F6-3)),IF(F6<=3,0,RANDBETWEEN(MAX(D6,0),F6-3))))","v":0},{"$f":"IF(Worksheet!$B$6,1,IF(Worksheet!$B$7,RANDBETWEEN(D3+1,F6-2),RANDBETWEEN(D3+1,IF((F6-2)<(D3+1),1,F6-2))))","v":2},{"$f":"IF(Worksheet!$B$6,2,IF(Worksheet!$B$7,RANDBETWEEN(E3+1,F6-1),RANDBETWEEN(E3+1,IF((F6-1)<(E3+1),2,F6-1))))","v":3},{"$f":"IF(Worksheet!$B$6,3,IF(Worksheet!$B$7,RANDBETWEEN(F3+1,F6),IF(F6<F3+1,3,RANDBETWEEN(F3+1,F6))))","v":4},null,null,"x",{"$f":"IF(Worksheet!$B$6,0,IF(Worksheet!$B$7,RANDBETWEEN(MAX(-10,K6),MIN(-1,M6-3)),IF(M6<=3,0,RANDBETWEEN(MAX(K6,0),M6-3))))","v":0},{"$f":"IF(Worksheet!$B$6,1,IF(Worksheet!$B$7,RANDBETWEEN(K3+1,M6-2),RANDBETWEEN(K3+1,IF((M6-2)<(K3+1),1,M6-2))))","v":1},{"$f":"IF(Worksheet!$B$6,2,IF(Worksheet!$B$7,RANDBETWEEN(L3+1,M6-1),RANDBETWEEN(L3+1,IF((M6-1)<(L3+1),2,M6-1))))","v":2},{"$f":"IF(Worksheet!$B$6,3,IF(Worksheet!$B$7,RANDBETWEEN(M3+1,M6),IF(M6<M3+1,3,RANDBETWEEN(M3+1,M6))))","v":3}]
[null,null,"y",{"$f":"$E1*D3+$H1","v":-1},{"$f":"$E1*E3+$H1","v":-5},-7,-9,null,null,"y",{"$f":"$L1*K3+$O1","v":5},{"$f":"$L1*L3+$O1","v":7},9,11]
[]
[null,null,null,{"$f":"MIN(INT((-10-$H1)/$E1),INT((10-$H1)/$E1))","v":-6},null,{"$f":"MAX(INT((-10-$H1)/$E1),INT((10-$H1)/$E1))","v":4},null,null,null,null,{"$f":"MIN(INT((-10-$O1)/$L1),INT((10-$O1)/$L1))","v":-8},null,{"$f":"MAX(INT((-10-$O1)/$L1),INT((10-$O1)/$L1))","v":2}]
[]
[null,null,"y"," = ",{"$f":"CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(1,5),RANDBETWEEN(-5,-1))","v":5},"x","+",{"$f":"RANDBETWEEN(-5,5)","v":-2},null,"y"," = ",{"$f":"CHOOSE(RANDBETWEEN(1,2),RANDBETWEEN(1,5),RANDBETWEEN(-5,-1))","v":5},"x","+",{"$f":"RANDBETWEEN(-5,5)","v":-1}]
[1,null,{"$f":"IF(AND(H8>0,E8<0),CONCATENATE(C8,D8,H8,\" \",IF(E8=1,\"\",IF(E8=-1,\" - \",E8)),F8),IF(H8=0,CONCATENATE(C8,D8,IF(E8=1,\"\",IF(E8=-1,\" - \",E8)),F8),CONCATENATE(C8,D8,IF(E8=1,\"\",IF(E8=-1,\" - \",E8)),F8,IF(H8<0,\"\",\" + \"),\" \",H8)))","v":"y = 5x -2"},null,null,null,null,null,null,{"$f":"IF(AND(O8>0,L8<0),CONCATENATE(J8,K8,O8,\" \",IF(L8=1,\"\",IF(L8=-1,\" - \",L8)),M8),IF(O8=0,CONCATENATE(J8,K8,IF(L8=1,\"\",IF(L8=-1,\" - \",L8)),M8),CONCATENATE(J8,K8,IF(L8=1,\"\",IF(L8=-1,\" - \",L8)),M8,IF(O8<0,\"\",\" + \"),\" \",O8)))","v":"y = 5x -1"}]
[null,null,"x",{"$f":"IF(Worksheet!$B$6,0,IF(Worksheet!$B$7,RANDBETWEEN(MAX(-10,D13),MIN(-1,F13-3)),IF(F13<=3,0,RANDBETWEEN(MAX(D13,0),F13-3))))","v":0},{"$f":"IF(Worksheet!$B$6,1,IF(Worksheet!$B$7,RANDBETWEEN(D10+1,F13-2),RANDBETWEEN(D10+1,IF((F13-2)<(D10+1),1,F13-2))))","v":1},{"$f":"IF(Worksheet!$B$6,2,IF(Worksheet!$B$7,RANDBETWEEN(E10+1,F13-1),RANDBETWEEN(E10+1,IF((F13-1)<(E10+1),2,F13-1))))","v":2},{"$f":"IF(Worksheet!$B$6,3,IF(Worksheet!$B$7,RANDBETWEEN(F10+1,F13),IF(F13<F10+1,3,RANDBETWEEN(F10+1,F13))))","v":3},null,null,"x",{"$f":"IF(Worksheet!$B$6,0,IF(Worksheet!$B$7,RANDBETWEEN(MAX(-10,K13),MIN(-1,M13-3)),IF(M13<=3,0,RANDBETWEEN(MAX(K13,0),M13-3))))","v":0},{"$f":"IF(Worksheet!$B$6,1,IF(Worksheet!$B$7,RANDBETWEEN(K10+1,M13-2),RANDBETWEEN(K10+1,IF((M13-2)<(K10+1),1,M13-2))))","v":1},{"$f":"IF(Worksheet!$B$6,2,IF(Worksheet!$B$7,RANDBETWEEN(L10+1,M13-1),RANDBETWEEN(L10+1,IF((M13-1)<(L10+1),2,M13-1))))","v":2},{"$f":"IF(Worksheet!$B$6,3,IF(Worksheet!$B$7,RANDBETWEEN(M10+1,M13),IF(M13<M10+1,3,RANDBETWEEN(M10+1,M13))))","v":3}]
[null,null,"y",{"$f":"$E8*D10+$H8","v":-2},{"$f":"$E8*E10+$H8","v":3},{"$f":"$E8*F10+$H8","v":8},{"$f":"$E8*G10+$H8","v":13},null,null,"y",{"$f":"$L8*K10+$O8","v":-1},{"$f":"$L8*L10+$O8","v":4},{"$f":"$L8*M10+$O8","v":9},{"$f":"$L8*N10+$O8","v":14}]
[]
[null,null,null,{"$f":"MIN(INT((-10-$H8)/$E8),INT((10-$H8)/$E8))","v":-2},null,{"$f":"MAX(INT((-10-$H8)/$E8),INT((10-$H8)/$E8))","v":2},null,null,null,null,{"$f":"MIN(INT((-10-$O8)/$L8),INT((10-$O8)/$L8))","v":-2},null,{"$f":"MAX(INT((-10-$O8)/$L8),INT((10-$O8)/$L8))","v":2}]