{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["index","order decimals","f of quantity","f of quantity (2)","p of quantity","p of quantity (2)","order fdp","2 part ratio","3 part ratio"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"index","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,0,9,1]]}
[null,"FRACTIONS, DECIMALS, PERCENTAGES RATIO AND PROPORTION"]
[1,"Ordering decimals to 3 decimal places"]
[2,"Find the (unitary) fraction of a quantity"]
[3,"Find the fraction of a quantity - two stage this time!"]
[4,"Finding the percentage of a quantity - no calculators needed"]
[5,"Finding the percentage of a quantity - a calculator is probably needed this time!"]
[6,"Ordering fractions, decimals and percentages"]
[7,"2 part ratio - three parts this time!"]
[8,"3 part ratio - Dividing a quantity into two parts"]
["Note: In activity 6,  encourage pupils to rewrite in original fdp form"]
[null,"© Copyright 2004 S.A.Lomax, M.J.Nixon.  All Rights Reserved."]

{"sheet":"order decimals","index":1,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,2,9,2],[1,0,1,6],[3,3,9,3],[3,4,9,4],[3,5,9,5]]}
[]
["Place the numbers in order from smallest to largest"]
[]
[null,null,{"$f":"ROUND(RAND(),3)","v":0.92800000000000005},{"$f":"ROUND(RAND(),3)","v":0.97599999999999998},{"$f":"ROUND(RAND(),3)","v":0.68},{"$f":"ROUND(RAND(),3)","v":0.63900000000000001}]
[null,null,{"$f":"-10+INT(20*RAND())","v":9},4,-5,4]
[null,null,9,-7,3,-7]
[null,null,3,0,-7,9]
[null,null,-2,-6,2,0]
[null,null,-7,6,3,-9]
[null,null,5,-3,-9,5]
[]
["Order:",null,{"$f":"C17","v":0.63900000000000001},{"$f":"D17","v":0.68},{"$f":"E17","v":0.92800000000000005},{"$f":"F17","v":0.97599999999999998}]
[]
[null,null,{"$f":"MIN(C4,D4)","v":0.92800000000000005},{"$f":"MAX(C4,D4)","v":0.97599999999999998},{"$f":"MIN(E4,F4)","v":0.63900000000000001},{"$f":"MAX(E4,F4)","v":0.68}]
[null,null,{"$f":"C14","v":0.92800000000000005},{"$f":"MIN(D14,E14)","v":0.63900000000000001},{"$f":"MAX(D14,E14)","v":0.97599999999999998},{"$f":"F14","v":0.68}]
[null,null,{"$f":"MIN(C15,D15)","v":0.63900000000000001},{"$f":"MAX(C15,D15)","v":0.92800000000000005},{"$f":"MIN(E15,F15)","v":0.68},{"$f":"MAX(E15,F15)","v":0.97599999999999998}]
[null,null,{"$f":"C16","v":0.63900000000000001},{"$f":"MIN(D16,E16)","v":0.68},{"$f":"MAX(D16,E16)","v":0.92800000000000005},{"$f":"F16","v":0.97599999999999998}]

{"sheet":"f of quantity","index":2,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,2,1,4],[10,0,10,1],[3,4,9,4],[3,2,7,2],[8,2,9,2],[3,3,9,3]]}
[]
[null,null,"Calculate the following:"]
[]
[null,null,1,"of",{"$f":"C9*C19","v":26}]
[null,null,null,null,{"$f":"-10+INT(9*RAND())","v":-10}]
[null,null,null,null,-2]
[null,null,null,null,-6]
[null,null,null,null,-4]
[null,null,{"$f":"2+INT(10*RAND())","v":2},null,-6]
[null,null,null,null,-6]
[]
[null,null,"Answer:",{"$f":"E4/C9","v":13}]
[]
[null,null,{"$f":"MIN(C11:D11)","v":0},{"$f":"MAX(C11:D11)","v":0},{"$f":"E11","v":0}]
[null,null,{"$f":"C14","v":0},{"$f":"MIN(D14:E14)","v":0},{"$f":"MAX(D14:E14)","v":0}]
[null,null,{"$f":"MIN(C15:D15)","v":0},{"$f":"MAX(C15:D15)","v":0},{"$f":"E15","v":0}]
[]
[]
[null,null,{"$f":"ROUND(1+(RAND()*12),0)","v":13}]

{"sheet":"f of quantity (2)","index":3,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,2,1,4],[10,0,10,1],[3,4,9,4],[3,2,7,2],[8,2,9,2],[3,3,9,3]]}
[]
[null,null,"Calculate the following:"]
[]
[null,null,{"$f":"1+INT((C9-1)*RAND())","v":5},"of",{"$f":"C9*C19","v":72}]
[null,null,null,null,{"$f":"-10+INT(9*RAND())","v":-7}]
[null,null,null,null,-9]
[null,null,null,null,-10]
[null,null,null,null,-10]
[null,null,{"$f":"2+INT(10*RAND())","v":6},null,-9]
[null,null,null,null,-6]
[]
[null,null,"Answer:",{"$f":"(E4/C9)*C4","v":60}]
[]
[null,null,{"$f":"MIN(C11:D11)","v":0},{"$f":"MAX(C11:D11)","v":0},{"$f":"E11","v":0}]
[null,null,{"$f":"C14","v":0},{"$f":"MIN(D14:E14)","v":0},{"$f":"MAX(D14:E14)","v":0}]
[null,null,{"$f":"MIN(C15:D15)","v":0},{"$f":"MAX(C15:D15)","v":0},{"$f":"E15","v":0}]
[]
[]
[null,null,{"$f":"ROUND(1+(RAND()*12),0)","v":12}]

{"sheet":"p of quantity","index":4,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,2,1,5],[10,0,10,1],[3,5,9,5],[3,4,9,4],[3,3,9,3],[3,2,9,2]]}
[]
[null,null,"Calculate the following:"]
[]
[null,null,{"$f":"5*ROUND(1+20*RAND(),0)","v":40},"%","of",{"$f":"5*ROUND(1+20*RAND(),0)","v":10}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Answer:",null,{"$f":"(C4*F4)/100","v":4}]
[]
[null,null,{"$f":"MIN(C11:E11)","v":0},null,{"$f":"MAX(C11:E11)","v":0},{"$f":"F11","v":0}]
[null,null,{"$f":"C14","v":0},null,{"$f":"MIN(E14:F14)","v":0},{"$f":"MAX(E14:F14)","v":0}]
[null,null,{"$f":"MIN(C15:E15)","v":0},null,{"$f":"MAX(C15:E15)","v":0},{"$f":"F15","v":0}]
[]
[]
[null,null,{"$f":"ROUND(1+(RAND()*12),0)","v":10}]

{"sheet":"p of quantity (2)","index":5,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,2,1,5],[10,0,10,1],[3,5,9,5],[3,4,9,4],[3,3,9,3],[3,2,9,2]]}
[]
[null,null,"Calculate the following:"]
[]
[null,null,{"$f":"ROUND(1+100*RAND(),0)","v":92},"%","of",{"$f":"5*ROUND(1+20*RAND(),0)","v":35}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Answer:",null,{"$f":"(C4*F4)/100","v":32.200000000000003}]
[]
[null,null,{"$f":"MIN(C11:E11)","v":0},null,{"$f":"MAX(C11:E11)","v":0},{"$f":"F11","v":0}]
[null,null,{"$f":"C14","v":0},null,{"$f":"MIN(E14:F14)","v":0},{"$f":"MAX(E14:F14)","v":0}]
[null,null,{"$f":"MIN(C15:E15)","v":0},null,{"$f":"MAX(C15:E15)","v":0},{"$f":"F15","v":0}]
[]
[]
[null,null,{"$f":"ROUND(1+(RAND()*12),0)","v":5}]

{"sheet":"order fdp","index":6,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,2,1,5],[10,0,10,2],[3,2,9,2],[3,5,9,5],[3,3,9,3],[3,4,7,4],[8,4,9,4]]}
[]
[null,null,"Place the following in order, from smallest to largest:"]
[]
[null,null,{"$f":"1+INT(99*RAND())","v":98},"%",{"$f":"1+INT(2*RAND())","v":2},{"$f":"(1+INT(100*RAND()))/100","v":0.54}]
[null,null,{"$f":"-10+INT(20*RAND())","v":-2},null,null,{"$f":"-10+INT(9*RAND())","v":-9}]
[null,null,-7,null,null,-8]
[null,null,9,null,null,-10]
[null,null,5,null,null,-10]
[null,null,0,null,{"$f":"1+INT(10*RAND())","v":5},-5]
[null,null,-9,null,null,-9]
["As decimals\n(up to 4dp):",null,null,{"$f":"C4/100","v":0.98},{"$f":"E4/E9","v":0.4},{"$f":"F4","v":0.54}]
["Order:",null,null,{"$f":"D16","v":0.4},{"$f":"E16","v":0.54},{"$f":"F16","v":0.98}]
[]
[null,null,null,{"$f":"MIN(D11:E11)","v":0.4},{"$f":"MAX(D11:E11)","v":0.98},{"$f":"F11","v":0.54}]
[null,null,null,{"$f":"D14","v":0.4},{"$f":"MIN(E14:F14)","v":0.54},{"$f":"MAX(E14:F14)","v":0.98}]
[null,null,null,{"$f":"MIN(D15:E15)","v":0.4},{"$f":"MAX(D15:E15)","v":0.54},{"$f":"F15","v":0.98}]

{"sheet":"2 part ratio","index":7,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[[10,0,10,1],[3,4,9,4],[3,3,9,3],[3,2,9,2]]}
[]
[null,null,"Divide",{"$f":"(C4+E4)*D18","v":40},"in the ratio"]
[]
[null,null,{"$f":"1+INT(10*RAND())","v":7},":",{"$f":"1+INT(10*RAND())","v":1}]
[]
[]
[]
[]
[]
[]
[]
[null,"Answer:",null,{"$f":"(D2/(C4+E4))*C4","v":35},"and",{"$f":"(D2/(C4+E4)*E4)","v":5}]
[]
[null,null,{"$f":"MIN(C11:D11)","v":0},{"$f":"MAX(C11:D11)","v":0},{"$f":"E11","v":0}]
[null,null,{"$f":"C14","v":0},{"$f":"MIN(D14:E14)","v":0},{"$f":"MAX(D14:E14)","v":0}]
[null,null,{"$f":"MIN(C15:D15)","v":0},{"$f":"MAX(C15:D15)","v":0},{"$f":"E15","v":0}]
[]
[null,null,null,{"$f":"2+INT(7*RAND())","v":5}]
[null,null,{"$f":"ROUND(1+(RAND()*12),0)","v":2}]

{"sheet":"3 part ratio","index":8,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,5,9,5],[3,6,9,6],[10,0,10,1],[3,4,9,4],[3,3,9,3],[3,2,9,2]]}
[]
[null,null,"Divide",{"$f":"(C4+E4+G4)*D18","v":72},"in the ratio"]
[]
[null,null,{"$f":"1+INT(10*RAND())","v":9},":",{"$f":"1+INT(10*RAND())","v":9},":",{"$f":"1+INT(10*RAND())","v":6}]
[]
[]
[]
[]
[]
[]
[]
["Answer:",null,null,{"$f":"(D2/(C4+E4+G4))*C4","v":27},",",{"$f":"(D2/(C4+E4+G4)*E4)","v":27},",",{"$f":"(D2/(C4+E4+G4)*G4)","v":18}]
[]
[null,null,{"$f":"MIN(C11:D11)","v":0},{"$f":"MAX(C11:D11)","v":0},{"$f":"E11","v":0}]
[null,null,{"$f":"C14","v":0},{"$f":"MIN(D14:E14)","v":0},{"$f":"MAX(D14:E14)","v":0}]
[null,null,{"$f":"MIN(C15:D15)","v":0},{"$f":"MAX(C15:D15)","v":0},{"$f":"E15","v":0}]
[]
[null,null,null,{"$f":"2+INT(7*RAND())","v":3}]
[null,null,{"$f":"ROUND(1+(RAND()*12),0)","v":10}]