{"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":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,2,0,10],[2,0,2,1]]}
[null,null,{"$f":"IF(B6=1,\"Add and take away:\",IF(B6=2,\"Add:\",\"Take away:\"))","v":"Add and take away:"}]
[]
["Variables",null,1,"6 • 6  –  1   = ",5.6,11,"8 • 1  –  1   = ",7.1,21,"1 • 5  –  1   = ",0.5]
["Maximum decimal places (1 or 2)",1,2,"9 • 8  –  1   = ",8.8000000000000007,12,"1 • 4  –  1   = ",0.39999999999999991,22,"6 • 6  +  1   = ",7.6]
["Mixed add and take away",null,3,"3 • 0  –  0 • 1 = ",2.9,13,"5 • 4  +  1   = ",6.4,23,"6 • 8  –  1   = ",5.8]
["Add only",1,4,"3 • 3  +  1   = ",4.3,14,"6 • 7  +  1   = ",7.7,24,"4 • 7  –  0 • 1 = ",4.6000000000000005]
["Take away only",null,5,"1 • 9  +  1   = ",2.9,15,"3 • 8  +  1   = ",4.8,25,"4 • 0  –  0 • 1 = ",3.9]
["Allow whole number part to be more than one digit?",false,6,"6 • 2  –  0 • 1 = ",6.1000000000000005,16,"6 • 0  –  0 • 1 = ",5.9,26,"1 • 0  –  0 • 1 = ",0.9]
["SHOW ANSWERS?",{"$f":"N11","v":false},7,"3 • 9  +  0 • 1 = ",4,17,"5 • 1  +  1   = ",6.1,27,"0 • 9  +  0 • 1 = ",1]
[null,null,8,"8 • 9  +  0 • 1 = ",9,18,"7 • 9  +  0 • 1 = ",8,28,"4 • 9  +  0 • 1 = ",5]
[null,null,9,"1 • 3  +  1   = ",2.2999999999999998,19,"2 • 9  –  0 • 1 = ",2.8,29,"2 • 0  –  0 • 1 = ",1.9,null,null,false]
[null,null,10,"1 • 0  –  0 • 1 = ",0.9,20,"5 • 5  +  0 • 1 = ",5.6,30,"0 • 9  +  0 • 1 = ",1]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":13,"n_cols":55,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Percentage of 2dp questions to have no 2dp",null,null,null,null,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.3]
["Percentage of questions to aim for carrying",null,null,null,null,0.5]
["Percentage of numbers to have no tens",null,null,null,null,{"$f":"IF(Worksheet!$B$8,IF(Worksheet!B4=1,20%,60%),100%)","v":1}]
[null,{"$f":"IF(RAND()<$F$3,\"\",RANDBETWEEN(1,9))","v":""},{"$f":"IF(G4=\"+\",RANDBETWEEN(0,9),IF(AND(B4=\"\",I4=1),RANDBETWEEN(1,9),RANDBETWEEN(0,9)))","v":3},{"$f":"IF(AND(E4=\"\",F4=\"\"),\"\",\"•\")","v":"•"},{"$f":"IF(OR(RAND()<1-$F$2,I4=1),RANDBETWEEN(1,9),IF(G4=\"+\",9,0))","v":4},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,C4<>0,E4<>0,G4<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,L4<>1),RANDBETWEEN(1,9),IF(G4=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},{"$f":"IF(AND(K4=\"\",L4=\"\"),\"\",\"•\")","v":""},{"$f":"IF(I4=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(K4=0,1,\"\"))","v":""},null,null,null,null,{"$f":"IF(RAND()<$F$3,\"\",RANDBETWEEN(1,9))","v":""},{"$f":"IF(V4=\"+\",RANDBETWEEN(0,9),IF(AND(Q4=\"\",X4=1),RANDBETWEEN(1,9),RANDBETWEEN(0,9)))","v":0},{"$f":"IF(AND(T4=\"\",U4=\"\"),\"\",\"•\")","v":"•"},{"$f":"IF(OR(RAND()<1-$F$2,X4=1),RANDBETWEEN(1,9),IF(V4=\"+\",9,0))","v":9},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,R4<>0,T4<>0,V4<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AA4<>1),RANDBETWEEN(1,9),IF(V4=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},{"$f":"IF(AND(Z4=\"\",AA4=\"\"),\"\",\"•\")","v":"•"},{"$f":"IF(X4=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(Z4=0,1,\"\"))","v":""},null,null,null,null,{"$f":"IF(RAND()<$F$3,\"\",RANDBETWEEN(1,9))","v":""},{"$f":"IF(AK4=\"+\",RANDBETWEEN(0,9),IF(AND(AF4=\"\",AM4=1),RANDBETWEEN(1,9),RANDBETWEEN(0,9)))","v":9},{"$f":"IF(AND(AI4=\"\",AJ4=\"\"),\"\",\"•\")","v":"•"},{"$f":"IF(OR(RAND()<1-$F$2,AM4=1),RANDBETWEEN(1,9),IF(AK4=\"+\",9,0))","v":0},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,AG4<>0,AI4<>0,AK4<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AP4<>1),RANDBETWEEN(1,9),IF(AK4=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},{"$f":"IF(AND(AO4=\"\",AP4=\"\"),\"\",\"•\")","v":"•"},{"$f":"IF(AM4=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AO4=0,1,\"\"))","v":""},null,null,null,null,1,{"$f":"CONCATENATE(B4,C4,\" \",D4,\" \", E4,F4,\"  \",G4,\"  \",H4,I4,\" \",J4,\" \",K4,L4,\" = \")","v":"3 • 4  +  1   = "},{"$f":"IF($G4=\"+\",IF(B4=\"\",0,B4)*10+IF(C4=\"\",0,C4)+IF(E4=\"\",0,E4)*0.1+IF(F4=\"\",0,F4)*0.01+IF(H4=\"\",0,H4)*10+IF(I4=\"\",0,I4)+IF(K4=\"\",0,K4)*0.1+IF(L4=\"\",0,L4)*0.01,IF(B4=\"\",0,B4)*10+IF(C4=\"\",0,C4)+IF(E4=\"\",0,E4)*0.1+IF(F4=\"\",0,F4)*0.01-IF(H4=\"\",0,H4)*10-IF(I4=\"\",0,I4)-IF(K4=\"\",0,K4)*0.1-IF(L4=\"\",0,L4)*0.01)","v":4.4000000000000004},{"$f":"MAX(AU4:AU48)+1","v":11},{"$f":"CONCATENATE(Q4,R4,\" \",S4,\" \", T4,U4,\"  \",V4,\"  \",W4,X4,\" \",Y4,\" \",Z4,AA4,\" = \")","v":"0 • 9  +  0 • 1 = "},{"$f":"IF($V4=\"+\",IF(Q4=\"\",0,Q4)*10+IF(R4=\"\",0,R4)+IF(T4=\"\",0,T4)*0.1+IF(U4=\"\",0,U4)*0.01+IF(W4=\"\",0,W4)*10+IF(X4=\"\",0,X4)+IF(Z4=\"\",0,Z4)*0.1+IF(AA4=\"\",0,AA4)*0.01,IF(Q4=\"\",0,Q4)*10+IF(R4=\"\",0,R4)+IF(T4=\"\",0,T4)*0.1+IF(U4=\"\",0,U4)*0.01-IF(W4=\"\",0,W4)*10-IF(X4=\"\",0,X4)-IF(Z4=\"\",0,Z4)*0.1-IF(AA4=\"\",0,AA4)*0.01)","v":1},{"$f":"MAX(AX4:AX48)+1","v":21},{"$f":"CONCATENATE(AF4,AG4,\" \",AH4,\" \", AI4,AJ4,\"  \",AK4,\"  \",AL4,AM4,\" \",AN4,\" \",AO4,AP4,\" = \")","v":"9 • 0  –  0 • 1 = "},{"$f":"IF($AK4=\"+\",IF(AF4=\"\",0,AF4)*10+IF(AG4=\"\",0,AG4)+IF(AI4=\"\",0,AI4)*0.1+IF(AJ4=\"\",0,AJ4)*0.01+IF(AL4=\"\",0,AL4)*10+IF(AM4=\"\",0,AM4)+IF(AO4=\"\",0,AO4)*0.1+IF(AP4=\"\",0,AP4)*0.01,IF(AF4=\"\",0,AF4)*10+IF(AG4=\"\",0,AG4)+IF(AI4=\"\",0,AI4)*0.1+IF(AJ4=\"\",0,AJ4)*0.01-IF(AL4=\"\",0,AL4)*10-IF(AM4=\"\",0,AM4)-IF(AO4=\"\",0,AO4)*0.1-IF(AP4=\"\",0,AP4)*0.01)","v":8.9}]
[null,{"$f":"IF(RAND()<$F$3,\"\",RANDBETWEEN(1,9))","v":""},{"$f":"IF(G5=\"+\",RANDBETWEEN(0,9),IF(AND(B5=\"\",I5=1),RANDBETWEEN(1,9),RANDBETWEEN(0,9)))","v":4},{"$f":"IF(AND(E5=\"\",F5=\"\"),\"\",\"•\")","v":"•"},{"$f":"IF(OR(RAND()<1-$F$2,I5=1),RANDBETWEEN(1,9),IF(G5=\"+\",9,0))","v":2},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,C5<>0,E5<>0,G5<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,L5<>1),RANDBETWEEN(1,9),IF(G5=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},{"$f":"IF(AND(K5=\"\",L5=\"\"),\"\",\"•\")","v":"•"},{"$f":"IF(I5=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(K5=0,1,\"\"))","v":""},null,null,null,null,{"$f":"IF(RAND()<$F$3,\"\",RANDBETWEEN(1,9))","v":""},{"$f":"IF(V5=\"+\",RANDBETWEEN(0,9),IF(AND(Q5=\"\",X5=1),RANDBETWEEN(1,9),RANDBETWEEN(0,9)))","v":3},{"$f":"IF(AND(T5=\"\",U5=\"\"),\"\",\"•\")","v":"•"},{"$f":"IF(OR(RAND()<1-$F$2,X5=1),RANDBETWEEN(1,9),IF(V5=\"+\",9,0))","v":5},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,R5<>0,T5<>0,V5<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AA5<>1),RANDBETWEEN(1,9),IF(V5=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},{"$f":"IF(AND(Z5=\"\",AA5=\"\"),\"\",\"•\")","v":"•"},{"$f":"IF(X5=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(Z5=0,1,\"\"))","v":""},null,null,null,null,{"$f":"IF(RAND()<$F$3,\"\",RANDBETWEEN(1,9))","v":""},{"$f":"IF(AK5=\"+\",RANDBETWEEN(0,9),IF(AND(AF5=\"\",AM5=1),RANDBETWEEN(1,9),RANDBETWEEN(0,9)))","v":6},{"$f":"IF(AND(AI5=\"\",AJ5=\"\"),\"\",\"•\")","v":"•"},{"$f":"IF(OR(RAND()<1-$F$2,AM5=1),RANDBETWEEN(1,9),IF(AK5=\"+\",9,0))","v":5},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,AG5<>0,AI5<>0,AK5<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AP5<>1),RANDBETWEEN(1,9),IF(AK5=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},{"$f":"IF(AND(AO5=\"\",AP5=\"\"),\"\",\"•\")","v":""},{"$f":"IF(AM5=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AO5=0,1,\"\"))","v":""},null,null,null,null,{"$f":"AU4+1","v":2},{"$f":"CONCATENATE(B5,C5,\" \",D5,\" \", E5,F5,\"  \",G5,\"  \",H5,I5,\" \",J5,\" \",K5,L5,\" = \")","v":"4 • 2  +  0 • 1 = "},{"$f":"IF($G5=\"+\",IF(B5=\"\",0,B5)*10+IF(C5=\"\",0,C5)+IF(E5=\"\",0,E5)*0.1+IF(F5=\"\",0,F5)*0.01+IF(H5=\"\",0,H5)*10+IF(I5=\"\",0,I5)+IF(K5=\"\",0,K5)*0.1+IF(L5=\"\",0,L5)*0.01,IF(B5=\"\",0,B5)*10+IF(C5=\"\",0,C5)+IF(E5=\"\",0,E5)*0.1+IF(F5=\"\",0,F5)*0.01-IF(H5=\"\",0,H5)*10-IF(I5=\"\",0,I5)-IF(K5=\"\",0,K5)*0.1-IF(L5=\"\",0,L5)*0.01)","v":4.3},{"$f":"AX4+1","v":12},{"$f":"CONCATENATE(Q5,R5,\" \",S5,\" \", T5,U5,\"  \",V5,\"  \",W5,X5,\" \",Y5,\" \",Z5,AA5,\" = \")","v":"3 • 5  +  0 • 1 = "},{"$f":"IF($V5=\"+\",IF(Q5=\"\",0,Q5)*10+IF(R5=\"\",0,R5)+IF(T5=\"\",0,T5)*0.1+IF(U5=\"\",0,U5)*0.01+IF(W5=\"\",0,W5)*10+IF(X5=\"\",0,X5)+IF(Z5=\"\",0,Z5)*0.1+IF(AA5=\"\",0,AA5)*0.01,IF(Q5=\"\",0,Q5)*10+IF(R5=\"\",0,R5)+IF(T5=\"\",0,T5)*0.1+IF(U5=\"\",0,U5)*0.01-IF(W5=\"\",0,W5)*10-IF(X5=\"\",0,X5)-IF(Z5=\"\",0,Z5)*0.1-IF(AA5=\"\",0,AA5)*0.01)","v":3.6},{"$f":"BA4+1","v":22},{"$f":"CONCATENATE(AF5,AG5,\" \",AH5,\" \", AI5,AJ5,\"  \",AK5,\"  \",AL5,AM5,\" \",AN5,\" \",AO5,AP5,\" = \")","v":"6 • 5  –  1   = "},{"$f":"IF($AK5=\"+\",IF(AF5=\"\",0,AF5)*10+IF(AG5=\"\",0,AG5)+IF(AI5=\"\",0,AI5)*0.1+IF(AJ5=\"\",0,AJ5)*0.01+IF(AL5=\"\",0,AL5)*10+IF(AM5=\"\",0,AM5)+IF(AO5=\"\",0,AO5)*0.1+IF(AP5=\"\",0,AP5)*0.01,IF(AF5=\"\",0,AF5)*10+IF(AG5=\"\",0,AG5)+IF(AI5=\"\",0,AI5)*0.1+IF(AJ5=\"\",0,AJ5)*0.01-IF(AL5=\"\",0,AL5)*10-IF(AM5=\"\",0,AM5)-IF(AO5=\"\",0,AO5)*0.1-IF(AP5=\"\",0,AP5)*0.01)","v":5.5}]
[null,"",4,"•",8,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,C6<>0,E6<>0,G6<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,L6<>1),RANDBETWEEN(1,9),IF(G6=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},"",{"$f":"IF(I6=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(K6=0,1,\"\"))","v":""},null,null,null,null,"",5,"•",5,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,R6<>0,T6<>0,V6<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AA6<>1),RANDBETWEEN(1,9),IF(V6=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(X6=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(Z6=0,1,\"\"))","v":""},null,null,null,null,"",0,"•",9,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,AG6<>0,AI6<>0,AK6<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AP6<>1),RANDBETWEEN(1,9),IF(AK6=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(AM6=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AO6=0,1,\"\"))","v":""},null,null,null,null,{"$f":"AU5+1","v":3},"4 • 8  +  1   = ",5.8,{"$f":"AX5+1","v":13},"5 • 5  –  0 • 1 = ",5.4,{"$f":"BA5+1","v":23},"0 • 9  +  0 • 1 = ",1]
[null,"",7,"•",8,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,C7<>0,E7<>0,G7<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,L7<>1),RANDBETWEEN(1,9),IF(G7=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},"",{"$f":"IF(I7=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(K7=0,1,\"\"))","v":""},null,null,null,null,"",8,"•",1,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,R7<>0,T7<>0,V7<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AA7<>1),RANDBETWEEN(1,9),IF(V7=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},"",{"$f":"IF(X7=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(Z7=0,1,\"\"))","v":""},null,null,null,null,"",8,"•",7,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,AG7<>0,AI7<>0,AK7<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AP7<>1),RANDBETWEEN(1,9),IF(AK7=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(AM7=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AO7=0,1,\"\"))","v":""},null,null,null,null,4,"7 • 8  –  1   = ",6.8,14,"8 • 1  –  1   = ",7.1,24,"8 • 7  –  0 • 1 = ",8.6]
[null,"",3,"•",0,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,C8<>0,E8<>0,G8<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,L8<>1),RANDBETWEEN(1,9),IF(G8=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(I8=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(K8=0,1,\"\"))","v":""},null,null,null,null,"",5,"•",9,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,R8<>0,T8<>0,V8<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AA8<>1),RANDBETWEEN(1,9),IF(V8=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(X8=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(Z8=0,1,\"\"))","v":""},null,null,null,null,"",0,"•",0,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,AG8<>0,AI8<>0,AK8<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AP8<>1),RANDBETWEEN(1,9),IF(AK8=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(AM8=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AO8=0,1,\"\"))","v":""},null,null,null,null,5,"3 • 0  –  0 • 1 = ",2.9,15,"5 • 9  +  0 • 1 = ",6,25,"0 • 0  –  0 • 1 = ",-0.1]
[null,"",6,"•",0,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,C9<>0,E9<>0,G9<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,L9<>1),RANDBETWEEN(1,9),IF(G9=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(I9=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(K9=0,1,\"\"))","v":""},null,null,null,null,"",1,"•",2,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,R9<>0,T9<>0,V9<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AA9<>1),RANDBETWEEN(1,9),IF(V9=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},"",{"$f":"IF(X9=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(Z9=0,1,\"\"))","v":""},null,null,null,null,"",4,"•",0,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,AG9<>0,AI9<>0,AK9<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AP9<>1),RANDBETWEEN(1,9),IF(AK9=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(AM9=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AO9=0,1,\"\"))","v":""},null,null,null,null,6,"6 • 0  –  0 • 1 = ",5.9,16,"1 • 2  –  1   = ",0.19999999999999996,26,"4 • 0  –  0 • 1 = ",3.9]
[null,"",3,"•",8,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,C10<>0,E10<>0,G10<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,L10<>1),RANDBETWEEN(1,9),IF(G10=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},"",{"$f":"IF(I10=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(K10=0,1,\"\"))","v":""},null,null,null,null,"",2,"•",8,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,R10<>0,T10<>0,V10<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AA10<>1),RANDBETWEEN(1,9),IF(V10=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},"",{"$f":"IF(X10=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(Z10=0,1,\"\"))","v":""},null,null,null,null,"",4,"•",9,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,AG10<>0,AI10<>0,AK10<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AP10<>1),RANDBETWEEN(1,9),IF(AK10=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(AM10=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AO10=0,1,\"\"))","v":""},null,null,null,null,7,"3 • 8  +  1   = ",4.8,17,"2 • 8  +  1   = ",3.8,27,"4 • 9  –  0 • 1 = ",4.8000000000000007]
[null,"",7,"•",0,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,C11<>0,E11<>0,G11<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,L11<>1),RANDBETWEEN(1,9),IF(G11=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(I11=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(K11=0,1,\"\"))","v":""},null,null,null,null,"",7,"•",9,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,R11<>0,T11<>0,V11<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AA11<>1),RANDBETWEEN(1,9),IF(V11=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(X11=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(Z11=0,1,\"\"))","v":""},null,null,null,null,"",2,"•",6,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,AG11<>0,AI11<>0,AK11<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AP11<>1),RANDBETWEEN(1,9),IF(AK11=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(AM11=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AO11=0,1,\"\"))","v":""},null,null,null,null,8,"7 • 0  –  0 • 1 = ",6.9,18,"7 • 9  +  0 • 1 = ",8,28,"2 • 6  –  0 • 1 = ",2.5]
[null,"",8,"•",6,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,C12<>0,E12<>0,G12<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,L12<>1),RANDBETWEEN(1,9),IF(G12=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(I12=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(K12=0,1,\"\"))","v":""},null,null,null,null,"",2,"•",1,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,R12<>0,T12<>0,V12<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AA12<>1),RANDBETWEEN(1,9),IF(V12=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},"",{"$f":"IF(X12=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(Z12=0,1,\"\"))","v":""},null,null,null,null,"",7,"•",5,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,AG12<>0,AI12<>0,AK12<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AP12<>1),RANDBETWEEN(1,9),IF(AK12=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},"",{"$f":"IF(AM12=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AO12=0,1,\"\"))","v":""},null,null,null,null,9,"8 • 6  –  0 • 1 = ",8.5,19,"2 • 1  –  1   = ",1.1000000000000001,29,"7 • 5  +  1   = ",8.5]
[null,"",5,"•",4,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,C13<>0,E13<>0,G13<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,L13<>1),RANDBETWEEN(1,9),IF(G13=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"–"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},"",{"$f":"IF(I13=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(K13=0,1,\"\"))","v":""},null,null,null,null,"",5,"•",9,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,R13<>0,T13<>0,V13<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AA13<>1),RANDBETWEEN(1,9),IF(V13=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":0},"•",{"$f":"IF(X13=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":1},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(Z13=0,1,\"\"))","v":""},null,null,null,null,"",4,"•",5,{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AND(RAND()<$F$1,AG13<>0,AI13<>0,AK13<>\"–\"),\"\",IF(OR(RAND()<1-$F$2,AP13<>1),RANDBETWEEN(1,9),IF(AK13=\"+\",9,\"\"))))","v":""},{"$f":"IF(Worksheet!$B$6=2,\"+\",IF(Worksheet!$B$6=3,\"–\",CHOOSE(RANDBETWEEN(1,2),\"+\",\"–\")))","v":"+"},null,{"$f":"IF(Worksheet!$B$4=1,CHOOSE(RANDBETWEEN(1,2),1,0),CHOOSE(RANDBETWEEN(1,3),1,0,0))","v":1},"",{"$f":"IF(AM13=1,\"\",IF(Worksheet!$B$4=1,1,CHOOSE(RANDBETWEEN(1,2),0,1)))","v":""},{"$f":"IF(Worksheet!$B$4=1,\"\",IF(AO13=0,1,\"\"))","v":""},null,null,null,null,10,"5 • 4  –  1   = ",4.4000000000000004,20,"5 • 9  +  0 • 1 = ",6,30,"4 • 5  +  1   = ",5.5]