{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Worksheet","SYSTEM FORMULAE","Percentages"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":18,"n_cols":27,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,3,0,22],[3,0,3,1],[6,0,6,1],[13,0,13,1],[17,0,17,1]]}
[null,null,null,"Work out these percentages using a calculator"]
[]
[null,null,null,1,0.2,"of",405,"=",81,"cm",17,0.2,"of",950,"=",190,"cm",33,0.25,"of",220,"=",55,""]
["Variables",null,null,2,0.2,"of",2245,"=",449,"g",18,0.1,"of",2240,"=",224,"km",34,0.2,"of",2440,"=",488,"£",null,null,{"$f":"NOT(B5)","v":true}]
["SHOW ANSWERS?",false,null,3,0.25,"of",1704,"=",426,"cm",19,0.2,"of",2130,"=",426,"cm",35,0.25,"of",1496,"=",374,"mm"]
["Number of question   (minimum 15, maximum 48)",48,null,4,0.2,"of",1925,"=",385,"ml",20,0.75,"of",760,"=",570,"mm",36,0.2,"of",2655,"=",531,"m"]
["Which percentages to include:",null,null,5,0.5,"of",144,"=",72,"cm",21,0.5,"of",972,"=",486,"cm",37,0.75,"of",1800,"=",1350,"£"]
[0.5,true,null,6,0.25,"of",1036,"=",259,"km",22,0.25,"of",400,"=",100,"ml",38,0.75,"of",1248,"=",936,"m"]
[0.25,true,null,7,0.1,"of",4770,"=",477,"cm",23,0.25,"of",1264,"=",316,"km",39,0.75,"of",684,"=",513,"£"]
[0.75,true,null,8,0.1,"of",5230,"=",523,"ml",24,0.5,"of",974,"=",487,"£",40,0.5,"of",766,"=",383,"m"]
[0.2,true,null,9,0.1,"of",650,"=",65,"",25,0.75,"of",2208,"=",1656,"kg",41,0.25,"of",656,"=",164,"£"]
[0.1,true,null,10,0.75,"of",424,"=",318,"£",26,0.25,"of",1152,"=",288,"kg",42,0.2,"of",2570,"=",514,""]
[0.01,false,null,11,0.75,"of",1252,"=",939,"",27,0.25,"of",1140,"=",285,"",43,0.1,"of",5440,"=",544,"kg"]
["Units:",null,null,12,0.1,"of",4810,"=",481,"",28,0.25,"of",748,"=",187,"kg",44,0.75,"of",732,"=",549,"kg"]
["£ (for all)",2,null,13,0.25,"of",940,"=",235,"mm",29,0.2,"of",2605,"=",521,"m",45,0.2,"of",1490,"=",298,"kg"]
["A mixture of units",false,null,14,0.75,"of",848,"=",636,"ml",30,0.75,"of",356,"=",267,"m",46,0.2,"of",465,"=",93,""]
["No units",false,null,15,0.25,"of",1172,"=",293,"kg",31,0.25,"of",1756,"=",439,"kg",47,0.75,"of",2036,"=",1527,"g"]
[null,null,null,16,0.25,"of",512,"=",128,"£",32,0.25,"of",1440,"=",360,"cm",48,0.25,"of",520,"=",130,"cm"]

{"sheet":"SYSTEM FORMULAE","index":1,"n_rows":16,"n_cols":28,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":1},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.5},"of",{"$f":"IF(B1=0.5,2*RANDBETWEEN(21,599),IF(B1=0.2,5*RANDBETWEEN(21,599),IF(OR(B1=0.25,B1=0.75),4*RANDBETWEEN(21,599),IF(B1=0.1,10*RANDBETWEEN(21,599),100*RANDBETWEEN(21,99)))))","v":202},"=",{"$f":"B1*D1","v":101},{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":""},{"$f":"MAX(A1:A20)+1","v":17},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",{"$f":"IF(I1=0.5,2*RANDBETWEEN(21,599),IF(I1=0.2,5*RANDBETWEEN(21,599),IF(OR(I1=0.25,I1=0.75),4*RANDBETWEEN(21,599),IF(I1=0.1,10*RANDBETWEEN(21,599),100*RANDBETWEEN(21,99)))))","v":1390},"=",{"$f":"I1*K1","v":278},{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"kg"},{"$f":"MAX(H1:H20)+1","v":33},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.75},"of",{"$f":"IF(P1=0.5,2*RANDBETWEEN(21,599),IF(P1=0.2,5*RANDBETWEEN(21,599),IF(OR(P1=0.25,P1=0.75),4*RANDBETWEEN(21,599),IF(P1=0.1,10*RANDBETWEEN(21,599),100*RANDBETWEEN(21,99)))))","v":2316},"=",{"$f":"P1*R1","v":1737},{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"km"},null,null,null,null,null,{"$f":"IF(Worksheet!B11,\"20%\",\"\")","v":"20%"},"20%"]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":2},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.1},"of",{"$f":"IF(B2=0.5,2*RANDBETWEEN(21,599),IF(B2=0.2,5*RANDBETWEEN(21,599),IF(OR(B2=0.25,B2=0.75),4*RANDBETWEEN(21,599),IF(B2=0.1,10*RANDBETWEEN(21,599),100*RANDBETWEEN(21,99)))))","v":2350},"=",{"$f":"B2*D2","v":235},{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"g"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H1+1,\"\")","v":18},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.1},"of",{"$f":"IF(I2=0.5,2*RANDBETWEEN(21,599),IF(I2=0.2,5*RANDBETWEEN(21,599),IF(OR(I2=0.25,I2=0.75),4*RANDBETWEEN(21,599),IF(I2=0.1,10*RANDBETWEEN(21,599),100*RANDBETWEEN(21,99)))))","v":2320},"=",{"$f":"I2*K2","v":232},{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"kg"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O1+1,\"\")","v":34},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.1},"of",{"$f":"IF(P2=0.5,2*RANDBETWEEN(21,599),IF(P2=0.2,5*RANDBETWEEN(21,599),IF(OR(P2=0.25,P2=0.75),4*RANDBETWEEN(21,599),IF(P2=0.1,10*RANDBETWEEN(21,599),100*RANDBETWEEN(21,99)))))","v":570},"=",{"$f":"P2*R2","v":57},{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"cm"},null,null,null,null,null,{"$f":"IF(Worksheet!B12,\"10%\",\"\")","v":"10%"},"10%"]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":3},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.5},"of",422,"=",211,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"kg"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H2+1,\"\")","v":19},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.1},"of",4000,"=",400,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"£"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O2+1,\"\")","v":35},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",1176,"=",294,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"mm"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":4},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.5},"of",294,"=",147,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"cm"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H3+1,\"\")","v":20},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",1596,"=",399,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"kg"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O3+1,\"\")","v":36},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",2060,"=",412,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"£"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":5},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",2352,"=",588,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"ml"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H4+1,\"\")","v":21},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",2980,"=",596,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":""},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O4+1,\"\")","v":37},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.5},"of",108,"=",54,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"£"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":6},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.1},"of",2670,"=",267,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"£"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H5+1,\"\")","v":22},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.1},"of",600,"=",60,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"kg"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O5+1,\"\")","v":38},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.75},"of",1248,"=",936,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"cm"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":7},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.75},"of",1548,"=",1161,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"g"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H6+1,\"\")","v":23},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.75},"of",1220,"=",915,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"kg"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O6+1,\"\")","v":39},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.75},"of",1668,"=",1251,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"m"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":8},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.75},"of",236,"=",177,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"kg"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H7+1,\"\")","v":24},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.75},"of",1524,"=",1143,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"kg"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O7+1,\"\")","v":40},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.5},"of",146,"=",73,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"km"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":9},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.5},"of",894,"=",447,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"cm"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H8+1,\"\")","v":25},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",276,"=",69,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"cm"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O8+1,\"\")","v":41},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.5},"of",1098,"=",549,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"g"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":10},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",600,"=",120,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"ml"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H9+1,\"\")","v":26},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",1345,"=",269,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"mm"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O9+1,\"\")","v":42},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",2760,"=",552,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"ml"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":11},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.5},"of",44,"=",22,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"ml"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H10+1,\"\")","v":27},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.5},"of",138,"=",69,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"£"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O10+1,\"\")","v":43},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",325,"=",65,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"£"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":12},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.75},"of",2144,"=",1608,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"£"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H11+1,\"\")","v":28},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",1415,"=",283,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"ml"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O11+1,\"\")","v":44},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",164,"=",41,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"cm"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":13},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",1448,"=",362,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":""},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H12+1,\"\")","v":29},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",895,"=",179,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":""},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O12+1,\"\")","v":45},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",2320,"=",464,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"cm"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":14},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.75},"of",2172,"=",1629,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"kg"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H13+1,\"\")","v":30},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.75},"of",1304,"=",978,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":""},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O13+1,\"\")","v":46},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",1064,"=",266,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"m"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":15},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",436,"=",109,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"£"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H14+1,\"\")","v":31},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",460,"=",115,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"km"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O14+1,\"\")","v":47},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",2172,"=",543,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"mm"}]
[{"$f":"IF(ROW()<=Worksheet!$B$6/3,ROW(),\"\")","v":16},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.25},"of",1956,"=",489,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"mm"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,H15+1,\"\")","v":32},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.2},"of",260,"=",52,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"cm"},{"$f":"IF(ROW()<=Worksheet!$B$6/3,O15+1,\"\")","v":48},{"$f":"IF(Percentages!$A$15=0,\"***\",CHOOSE(RANDBETWEEN(1,Percentages!$A$15),Percentages!$A$9,Percentages!$A$10,Percentages!$A$11,Percentages!$A$12,Percentages!$A$13,Percentages!$A$14))","v":0.5},"of",870,"=",435,{"$f":"IF(Worksheet!$B$15=1,\"£\",IF(Worksheet!$B$15=3,\"\",CHOOSE(RANDBETWEEN(1,15),\"£\",\"cm\",\"m\",\"km\",\"mm\",\"g\",\"kg\",\"kg\",\"ml\",\"\",\"\",\"£\",\"£\",\"£\",\"cm\")))","v":"m"}]

{"sheet":"Percentages","index":2,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"THIS SHEET IS NOT PROTECTED - DO NOT MODIFY THIS SHEET!"]
[{"$f":"IF(Worksheet!B8,50%,\"\")","v":0.5}]
[{"$f":"IF(Worksheet!B9,25%,\"\")","v":0.25}]
[{"$f":"IF(Worksheet!B10,75%,\"\")","v":0.75}]
[{"$f":"IF(Worksheet!B11,20%,\"\")","v":0.2}]
[{"$f":"IF(Worksheet!B12,10%,\"\")","v":0.1}]
[{"$f":"IF(Worksheet!B13,1%,\"\")","v":""}]
[]
[0.5]
[0.25]
[0.75]
[0.2]
[0.1]
[]
[{"$f":"COUNTA(A9:A14)","v":5}]