{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Prelim_Nov","Fraction_Of_Quantity","Percentages","Mean_Range","Multiplication","Add_Sub","Equations","Composite_Area","DST","Linear_Patterns","Pythagoras","SOHCAHTOA","Coordinates","Final_Exam"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":12,"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":"Prelim_Nov","index":0,"n_rows":84,"n_cols":27,"rows_kept":84,"cut":false,"hidden":false,"merged":[[4,3,4,7],[4,11,4,21],[1,1,1,21],[10,23,11,26],[13,23,14,26],[16,23,17,26],[19,23,20,26],[22,23,23,26],[25,23,26,26],[28,23,29,26],[31,23,32,26],[37,23,38,26],[40,23,41,26],[43,23,44,26],[46,23,47,26],[79,23,80,26],[82,23,83,26],[34,23,35,26],[64,23,65,26],[67,23,68,26],[70,23,71,26],[73,23,74,26],[76,23,77,26],[49,23,50,26],[52,23,53,26],[55,23,56,26],[58,23,59,26],[61,23,62,26]]}
[]
[null,"November Prelim Analysis National 4"]
[]
[]
[null,null,"  ","Paper 1",null,null,null,null,null,null,null,"Paper 2"]
[null,null,null,"Fraction of a Quanitity","Mean and Rounding","Percentage of a Quanitity","Basic Number - Mulitple","Basic Number - Add/ Sub",null,null,null,"Equations","Composite Area","Composite Area","Linear Patterns","Linear Patterns","Time Speed Distance","Pythagoras in Context","Pythagoras in Context","SOHCAHTOA in Context","Coordinates and Shape","Coordinates and Shape"]
[null,null,null,3,4,3,2,3,null,{"$f":"SUM(D7:H7)","v":15},null,3,4,1,4,1,3,4,1,3,3,1,null,{"$f":"SUM(L7:U7)","v":27},null,{"$f":"X7+J7","v":42},3]
[null,null,null,"R","R","R","R","R",null,null,null,"R","R","R","R","R","R","R","R","R","R","R"]
[null,"Firstname","Surname","Q1","Q2","Q3","Q4","Q5",null,"P1",null,"Q1","Q2","#","Q3","#","Q4","Q5","#","Q6","Q7","#",null,"P2","#","P1/P2","T#"]
[1,"Liam","Anderson",3,4,3,1,3,null,14,null,2,1,0,2,0,1,3,0,1,3,null,null,13,0,27,0]
[null,null,"Revision","ü","ü","ü","ü","ü",null,null,null,"ü","ü",null,"ü",null,"ü","ü","ü","ü","ü"]
[null,null,"Number completed",1,1,1,1,1,null,null,null,1,1,null,1,null,1,1,1,1,1]
[2,"Shaun","Bowers",3,2,3,2,3,null,{"$f":"SUM(D13:H13)","v":13},null,3,3,0,4,1,3,4,1,3,3,null,null,{"$f":"SUM(L13:M13,O13,Q13,R13,T13,U13)","v":23},{"$f":"SUM(N13,P13,S13,V13)","v":2},{"$f":"X13+J13","v":36},{"$f":"Y13","v":2}]
[null,null,"Revision"]
[null,null,"Number completed"]
[3,"Jordan","Brownlie",3,2,2,2,3,null,{"$f":"SUM(D16:H16)","v":12},null,3,4,1,4,1,2,3,0,3,1,null,null,{"$f":"SUM(L16:M16,O16,Q16,R16,T16,U16)","v":20},{"$f":"SUM(N16,P16,S16,V16)","v":2},{"$f":"X16+J16","v":32},{"$f":"Y16","v":2}]
[null,null,"Revision"]
[null,null,"Number completed"]
[4,"Joseph","Daly",3,4,3,2,3,null,{"$f":"SUM(D19:H19)","v":15},null,2,0,0,3,1,2,3,0,1,3,null,null,{"$f":"SUM(L19:M19,O19,Q19,R19,T19,U19)","v":14},{"$f":"SUM(N19,P19,S19,V19)","v":1},{"$f":"X19+J19","v":29},{"$f":"Y19","v":1}]
[null,null,"Revision"]
[null,null,"Number completed"]
[5,"Jason","Dickie",2,0,3,1,3,null,{"$f":"SUM(D22:H22)","v":9},null,3,1,0,1,0,0,3,1,0,2,null,null,{"$f":"SUM(L22:M22,O22,Q22,R22,T22,U22)","v":10},{"$f":"SUM(N22,P22,S22,V22)","v":1},{"$f":"X22+J22","v":19},{"$f":"Y22","v":1}]
[null,null,"Revision"]
[null,null,"Number completed"]
[6,"Euan","Docherty",3,3,3,2,3,null,{"$f":"SUM(D25:H25)","v":14},null,3,1,0,4,1,2,1,0,0,3,null,null,{"$f":"SUM(L25:M25,O25,Q25,R25,T25,U25)","v":14},{"$f":"SUM(N25,P25,S25,V25)","v":1},{"$f":"X25+J25","v":28},{"$f":"Y25","v":1}]
[null,null,"Revision"]
[null,null,"Number completed"]
[7,"Lewis","Doherty",3,4,3,2,3,null,{"$f":"SUM(D28:H28)","v":15},null,3,0,0,4,1,2,1,0,0,1,null,null,{"$f":"SUM(L28:M28,O28,Q28,R28,T28,U28)","v":11},{"$f":"SUM(N28,P28,S28,V28)","v":1},{"$f":"X28+J28","v":26},{"$f":"Y28","v":1}]
[null,null,"Revision"]
[null,null,"Number completed"]
[8,"Sophie-Lee","Elliott",2,3,0,1,2,null,{"$f":"SUM(D31:H31)","v":8},null,3,3,1,1,0,0,3,1,2,0,null,null,{"$f":"SUM(L31:M31,O31,Q31,R31,T31,U31)","v":12},{"$f":"SUM(N31,P31,S31,V31)","v":2},{"$f":"X31+J31","v":20},{"$f":"Y31","v":2}]
[null,null,"Revision"]
[null,null,"Number completed"]
[9,"Jordan","Faleu",3,4,3,2,3,null,{"$f":"SUM(D34:H34)","v":15},null,3,4,1,4,1,3,4,1,3,3,null,null,{"$f":"SUM(L34:M34,O34,Q34,R34,T34,U34)","v":24},{"$f":"SUM(N34,P34,S34,V34)","v":3},{"$f":"X34+J34","v":39},{"$f":"Y34","v":3}]
[null,null,"Revision"]
[null,null,"Number completed"]
[10,"Owen","Fyfe",3,2,3,2,3,null,{"$f":"SUM(D37:H37)","v":13},null,3,1,0,4,1,2,3,0,2,3,null,null,{"$f":"SUM(L37:M37,O37,Q37,R37,T37,U37)","v":18},{"$f":"SUM(N37,P37,S37,V37)","v":1},{"$f":"X37+J37","v":31},{"$f":"Y37","v":1}]
[null,null,"Revision"]
[null,null,"Number completed"]
[11,"William","Gill",3,0,3,1,3,null,{"$f":"SUM(D40:H40)","v":10},null,0,1,0,2,0,1,1,0,1,2,null,null,{"$f":"SUM(L40:M40,O40,Q40,R40,T40,U40)","v":8},{"$f":"SUM(N40,P40,S40,V40)","v":0},{"$f":"X40+J40","v":18},{"$f":"Y40","v":0}]
[null,null,"Revision"]
[null,null,"Number completed"]
[12,"Murray","Glen",3,2,3,2,3,null,{"$f":"SUM(D43:H43)","v":13},null,2,3,1,3,1,3,3,0,2,3,null,null,{"$f":"SUM(L43:M43,O43,Q43,R43,T43,U43)","v":19},{"$f":"SUM(N43,P43,S43,V43)","v":2},{"$f":"X43+J43","v":32},{"$f":"Y43","v":2}]
[null,null,"Revision"]
[null,null,"Number completed"]
[13,"Kieron","Hagan",3,4,3,2,3,null,{"$f":"SUM(D46:H46)","v":15},null,3,3,1,4,1,3,2,0,3,3,null,null,{"$f":"SUM(L46:M46,O46,Q46,R46,T46,U46)","v":21},{"$f":"SUM(N46,P46,S46,V46)","v":2},{"$f":"X46+J46","v":36},{"$f":"Y46","v":2}]
[null,null,"Revision"]
[null,null,"Number completed"]
[14,"Thomas","Hamilton",2,3,3,2,3,null,{"$f":"SUM(D49:H49)","v":13},null,3,1,0,1,0,2,0,0,0,2,null,null,{"$f":"SUM(L49:M49,O49,Q49,R49,T49,U49)","v":9},{"$f":"SUM(N49,P49,S49,V49)","v":0},{"$f":"X49+J49","v":22},{"$f":"Y49","v":0}]
[null,null,"Revision"]
[null,null,"Number completed"]
[15,"Mark","Haswell",3,2,3,2,3,null,{"$f":"SUM(D52:H52)","v":13},null,3,0,0,1,0,1,4,1,1,3,null,null,{"$f":"SUM(L52:M52,O52,Q52,R52,T52,U52)","v":13},{"$f":"SUM(N52,P52,S52,V52)","v":1},{"$f":"X52+J52","v":26},{"$f":"Y52","v":1}]
[null,null,"Revision"]
[null,null,"Number completed"]
[16,"Emma-Louise","Jones",3,4,3,2,3,null,{"$f":"SUM(D55:H55)","v":15},null,3,2,0,4,1,1,4,1,3,2,null,null,{"$f":"SUM(L55:M55,O55,Q55,R55,T55,U55)","v":19},{"$f":"SUM(N55,P55,S55,V55)","v":2},{"$f":"X55+J55","v":34},{"$f":"Y55","v":2}]
[null,null,"Revision"]
[null,null,"Number completed"]
[18,"Marina","McDonald",2,1,3,2,3,null,{"$f":"SUM(D58:H58)","v":11},null,3,3,1,4,1,3,4,1,3,3,null,null,{"$f":"SUM(L58:M58,O58,Q58,R58,T58,U58)","v":23},{"$f":"SUM(N58,P58,S58,V58)","v":3},{"$f":"X58+J58","v":34},{"$f":"Y58","v":3}]
[null,null,"Revision"]
[null,null,"Number completed"]
[19,"Ainslie","McLaren",3,4,3,2,2,null,{"$f":"SUM(D61:H61)","v":14},null,2,1,0,3,1,2,4,1,0,3,null,null,{"$f":"SUM(L61:M61,O61,Q61,R61,T61,U61)","v":15},{"$f":"SUM(N61,P61,S61,V61)","v":2},{"$f":"X61+J61","v":29},{"$f":"Y61","v":2}]
[null,null,"Revision"]
[null,null,"Number completed"]
[20,"Megan","McLaren",3,2,3,2,3,null,{"$f":"SUM(D64:H64)","v":13},null,3,4,1,4,1,3,3,0,3,2,null,null,{"$f":"SUM(L64:M64,O64,Q64,R64,T64,U64)","v":22},{"$f":"SUM(N64,P64,S64,V64)","v":2},{"$f":"X64+J64","v":35},{"$f":"Y64","v":2}]
[null,null,"Revision"]
[null,null,"Number completed"]
[21,"Brenden","McNamee",3,2,3,2,3,null,{"$f":"SUM(D67:H67)","v":13},null,3,2,0,4,1,1,4,1,2,0,null,null,{"$f":"SUM(L67:M67,O67,Q67,R67,T67,U67)","v":16},{"$f":"SUM(N67,P67,S67,V67)","v":2},{"$f":"X67+J67","v":29},{"$f":"Y67","v":2}]
[null,null,"Revision"]
[null,null,"Number completed"]
[22,"Jack","McPake",3,4,3,2,3,null,{"$f":"SUM(D70:H70)","v":15},null,3,3,1,4,1,0,3,0,3,3,null,null,{"$f":"SUM(L70:M70,O70,Q70,R70,T70,U70)","v":19},{"$f":"SUM(N70,P70,S70,V70)","v":2},{"$f":"X70+J70","v":34},{"$f":"Y70","v":2}]
[null,null,"Revision"]
[null,null,"Number completed"]
[23,"Emma","Quail",3,4,3,2,3,null,{"$f":"SUM(D73:H73)","v":15},null,3,2,0,3,1,0,2,0,2,2,null,null,{"$f":"SUM(L73:M73,O73,Q73,R73,T73,U73)","v":14},{"$f":"SUM(N73,P73,S73,V73)","v":1},{"$f":"X73+J73","v":29},{"$f":"Y73","v":1}]
[null,null,"Revision"]
[null,null,"Number completed"]
[24,"Daniel","Rodgers",3,3,3,2,2,null,{"$f":"SUM(D76:H76)","v":13},null,2,2,0,2,1,2,0,0,2,3,null,null,{"$f":"SUM(L76:M76,O76,Q76,R76,T76,U76)","v":13},{"$f":"SUM(N76,P76,S76,V76)","v":1},{"$f":"X76+J76","v":26},{"$f":"Y76","v":1}]
[null,null,"Revision"]
[null,null,"Number completed"]
[25,"Bethan","Rowan",3,2,3,2,3,null,{"$f":"SUM(D79:H79)","v":13},null,3,4,1,4,1,2,4,1,3,2,null,null,{"$f":"SUM(L79:M79,O79,Q79,R79,T79,U79)","v":22},{"$f":"SUM(N79,P79,S79,V79)","v":3},{"$f":"X79+J79","v":35},{"$f":"Y79","v":3}]
[null,null,"Revision"]
[null,null,"Number completed"]
[26,"Ryan","Thomson",3,4,3,2,3,null,{"$f":"SUM(D82:H82)","v":15},null,0,0,0,4,1,2,3,0,2,3,null,null,{"$f":"SUM(L82:M82,O82,Q82,R82,T82,U82)","v":14},{"$f":"SUM(N82,P82,S82,V82)","v":1},{"$f":"X82+J82","v":29},{"$f":"Y82","v":1}]
[null,null,"Revision"]
[null,null,"Number completed"]

{"sheet":"Fraction_Of_Quantity","index":1,"n_rows":90,"n_cols":35,"rows_kept":90,"cut":false,"hidden":false,"merged":[[1,1,2,28],[4,25,4,28],[4,5,4,14],[6,5,6,9],[4,21,4,23],[25,18,25,21],[27,1,32,28],[11,6,12,7],[11,8,12,10],[11,20,12,21],[11,22,12,24],[14,4,14,7],[14,18,14,21],[16,2,20,13],[16,17,20,28],[89,1,89,28],[78,18,78,21],[80,1,85,28],[38,18,38,21],[40,1,45,28],[51,18,51,21],[53,1,58,28],[64,18,64,21],[66,1,71,28]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (Fraction of a Quantity)"]
[]
[]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/21"]
[]
[null,"Teacher :",null,null,null,"Mr Lafferty"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":5},{"$f":"ROUND(RAND()*(9-2)+2,0)","v":6}]
[null,"Q1.",null,"Find",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH9+1","v":6},{"$f":"AI9+1","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(200-5)+5,0)*LCM(AH9,AH10)","v":1230},{"$f":"ROUND(RAND()*(200-5)+5,0)*LCM(AI9,AI10)","v":4410}]
[null,null,"(a)",null,null,{"$f":"AH9","v":5},"of",null,{"$f":"AH11","v":1230},null,null,null,null,null,null,null,"(b)",null,null,{"$f":"AI9","v":6},"of",null,{"$f":"AI11","v":4410},null,null,null,null,null,null,null,null,null,null,{"$f":"AH11/AH10*AH9","v":1025},{"$f":"AI11/AI10*AI9","v":3780}]
[null,null,null,null,null,{"$f":"AH10","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI10","v":7}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":5}]
[null,{"$f":" \"Q2.  Megan won £\"&AH25&\" in a raffle.   She put \"&AH23&\"/\"&AH24&\" into the bank.\"","v":"Q2.  Megan won £3540 in a raffle.   She put 5/6 into the bank."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH23+1","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(200-5)+5,0)*LCM(AH23,AH24)","v":3540}]
[null,null,"How much did she put into the bank ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH25/AH24*AH23","v":2950}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":8}]
[null,{"$f":" \"Q3.  Bethan paid £\"&AH38&\" for a holiday.   Marina paid only \"&AH36&\"/\"&AH37&\" of Bethan's price.\"","v":"Q3.  Bethan paid £1296 for a holiday.   Marina paid only 8/9 of Bethan's price."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH36+1","v":9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(99-5)+5,0)*LCM(AH36,AH37)","v":1296}]
[null,null,"How much did Marina pay ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH38/AH37*AH36","v":1152}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":4}]
[null,{"$f":" \"Q4.  The full price for a laptop is £\"&AH51&\".   In the sale you pay \"&AH49&\"/\"&AH50&\" of the full price.\"","v":"Q4.  The full price for a laptop is £1780.   In the sale you pay 4/5 of the full price."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH49+1","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(99-5)+5,0)*LCM(AH49,AH50)","v":1780}]
[null,null,"How much is the laptop in the sale ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH51/AH50*AH49","v":1424}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":2}]
[null,{"$f":" \"Q5.  Joseph won £\"&AH64&\" in the lottery.  He used \"&AH62&\"/\"&AH63&\" of the his winning's to buy motorcycle.\"","v":"Q5.  Joseph won £492 in the lottery.  He used 2/3 of the his winning's to buy motorcycle."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH62+1","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(99-5)+5,0)*LCM(AH62,AH63)","v":492}]
[null,null,"   How much did the motorcycle cost ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH64/AH63*AH62","v":328}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":5}]
[null,{"$f":" \"Q6.  A football stadium contains \"&AH78&\" people.   \"&AH76&\"/\"&AH77&\" are male.\"","v":"Q6.  A football stadium contains 1650 people.   5/6 are male."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH76+1","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(99-5)+5,0)*LCM(AH76,AH77)","v":1650}]
[null,null,"How many male people where there ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH78/AH77*AH76","v":1375}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"Percentages","index":2,"n_rows":90,"n_cols":35,"rows_kept":90,"cut":false,"hidden":false,"merged":[[16,17,20,28],[66,1,71,28],[78,18,78,21],[80,1,85,28],[27,1,32,28],[38,18,38,21],[40,1,45,28],[51,18,51,21],[53,1,58,28],[64,18,64,21],[89,1,89,28],[25,18,25,21],[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9],[11,4,12,5],[11,6,12,7],[11,8,12,10],[11,18,12,19],[11,20,12,21],[11,22,12,24],[14,4,14,7],[14,18,14,21],[16,2,20,13]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (Percentages)"]
[]
[]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/21"]
[]
[null,"Teacher :",null,null,null,"Mr Lafferty"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)*10","v":30},{"$f":"ROUND(RAND()*(9-6)+6,0)*10","v":60}]
[null,"Q1.","Find"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(200-21)+21,0)*10","v":980},{"$f":"ROUND(RAND()*(200-21)+21,0)*10","v":910}]
[null,null,"(a)",null,{"$f":"AH9","v":30},null,"% of",null,{"$f":"AH11","v":980},null,null,null,null,null,null,null,"(b)",null,{"$f":"AI9","v":60},null,"% of",null,{"$f":"AI11","v":910},null,null,null,null,null,null,null,null,null,null,{"$f":"AH9/100*AH11","v":294},{"$f":"AI9/100*AI11","v":546}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)*10","v":20}]
[null,{"$f":" \"Q2.  Daniel printed \"&AH23&\" % of his \"&AH25&\" photos.\"","v":"Q2.  Daniel printed 20 % of his 530 photos."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(200-21)+21,0)*10","v":530}]
[null,null,"How many photos did he print ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"photos",null,null,null,null,null,null,null,null,null,null,{"$f":"AH23/100*AH25","v":106}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-6)+6,0)*10","v":70}]
[null,{"$f":" \"Q3.  Thomas has £\"&AH38&\" in savings.   He spents \"&AH36&\"% of his savings.\"","v":"Q3.  Thomas has £3880 in savings.   He spents 70% of his savings."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(900-200)+200,0)*10","v":3880}]
[null,null,"How much did Thomas spent ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH36/100*AH38","v":2716}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)*10","v":30}]
[null,{"$f":" \"Q4.  The full price of a holiday is £\"&AH51&\".   In the sale you pay only \"&AH49&\"% of the full price.\"","v":"Q4.  The full price of a holiday is £2220.   In the sale you pay only 30% of the full price."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(900-200)+200,0)*10","v":2220}]
[null,null,"How much is the holiday in the sale ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH49/100*AH51","v":666}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)*10","v":30}]
[null,{"$f":" \"Q5.  In a survey of \"&AH64&\" people. \"&AH62&\"% voted  YES.\"","v":"Q5.  In a survey of 5750 people. 30% voted  YES."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(900-200)+200,0)*10","v":5750}]
[null,null,"   How many people voted YES ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"people",null,null,null,null,null,null,null,null,null,null,{"$f":"AH62/100*AH64","v":1725}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-6)+6,0)*10","v":60}]
[null,{"$f":"\"Q6.  \"&AH78&\" people attended a basketball match.   \"&AH76&\"% were female. \"","v":"Q6.  5650 people attended a basketball match.   60% were female. "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(900-200)+200,0)*10","v":5650}]
[null,null,"How many females attended the match ?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"females",null,null,null,null,null,null,null,null,null,null,{"$f":"AH76/100*AH78","v":3390}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"Mean_Range","index":3,"n_rows":95,"n_cols":36,"rows_kept":95,"cut":false,"hidden":false,"merged":[[84,7,84,8],[83,10,89,28],[85,7,85,8],[86,7,86,8],[87,7,87,8],[88,7,88,8],[89,7,89,8],[78,19,78,21],[78,23,78,26],[81,19,81,21],[81,23,81,26],[83,7,83,8],[66,19,66,21],[66,23,66,26],[68,7,68,8],[69,7,69,8],[70,7,70,8],[68,10,74,28],[71,7,71,8],[72,7,72,8],[73,7,73,8],[74,7,74,8],[59,7,59,8],[48,19,48,22],[51,19,51,22],[63,19,63,21],[63,23,63,26],[54,7,54,8],[55,7,55,8],[56,7,56,8],[57,7,57,8],[58,7,58,8],[48,23,48,26],[51,23,51,26],[53,7,53,8],[53,10,59,28],[42,7,42,8],[43,7,43,8],[44,7,44,8],[45,7,45,8],[34,19,34,22],[37,19,37,22],[39,11,45,28],[37,23,37,26],[39,7,39,8],[40,7,40,8],[41,7,41,8],[34,23,34,26],[21,19,21,21],[21,23,21,26],[24,19,24,21],[24,23,24,26],[26,7,26,8],[26,10,30,28],[27,7,27,8],[28,7,28,8],[29,7,29,8],[30,7,30,8],[94,1,94,28],[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[13,13,18,28],[9,19,9,21],[9,23,9,26],[11,19,11,21],[11,23,11,26],[14,7,14,8]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (Mean Rounding & Range)"]
[]
[]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/29"]
[]
[null,"Teacher :",null,null,null,"Mr Lafferty"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-6)+6,0)*10","v":70}]
[null,"Q1.  The table shows the number of pupils walking",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AVERAGE(H15:I19),0)","v":95}]
[null,"      to school each day. Calculate the mean number of"]
[null,"      pupils walking to school per day and the range.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI12-AJ12","v":60},null,{"$f":"MAX(H15:I19)","v":125},{"$f":"MIN(H15:I19)","v":65}]
[]
[null,null,"Days",null,null,null,null,"No. of Pupils"]
[null,null,"Monday",null,null,null,null,{"$f":"ROUND(RAND()*(16-12)+12,0)*5","v":65}]
[null,null,"Tuesday",null,null,null,null,{"$f":"ROUND(RAND()*(25-12)+12,0)*5","v":70}]
[null,null,"Wednesday",null,null,null,null,{"$f":"ROUND(RAND()*(30-12)+12,0)*5","v":110}]
[null,null,"Thursday",null,null,null,null,{"$f":"ROUND(RAND()*(30-12)+12,0)*5","v":105}]
[null,null,"Friday",null,null,null,null,{"$f":"ROUND(RAND()*(35-12)+12,0)*5","v":125}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)*10","v":20}]
[null,"Q2.  The table shows the number of cakes sold in a shop.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AVERAGE(H27:I32),0)","v":18}]
[null,"        Calculate the average cakes sold per day"]
[null,"        to the nearest whole number and the range."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI25-AJ25","v":11},null,{"$f":"MAX(H27:I31)","v":25},{"$f":"MIN(H27:I31)","v":14}]
[null,null,"Days",null,null,null,null,"Cakes"]
[null,null,"Monday",null,null,null,null,{"$f":"ROUND(RAND()*(20-15)+15,0)","v":16}]
[null,null,"Tuesday",null,null,null,null,{"$f":"ROUND(RAND()*(20-10)+10,0)","v":16}]
[null,null,"Wednesday",null,null,null,null,{"$f":"ROUND(RAND()*(15-8)+8,0)","v":14}]
[null,null,"Thursday",null,null,null,null,{"$f":"ROUND(RAND()*(20-12)+12,0)","v":17}]
[null,null,"Friday",null,null,null,null,{"$f":"ROUND(RAND()*(30-20)+20,0)","v":25}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-6)+6,0)*10","v":70}]
[]
[null,"Q3.  The table shows the snowfall in centimetres over a week.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AVERAGE(H40:I46),2)","v":4.8600000000000003}]
[null,"        Calculate the mean snowfall for a day to 2 decimal places and the range."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI38-AJ38","v":6},null,{"$f":"MAX(H40:I46)","v":7},{"$f":"MIN(H40:I46)","v":1}]
[null,null,"Days",null,null,null,null,"Snowfall (cm)"]
[null,null,"Monday",null,null,null,null,{"$f":"ROUND(RAND()*(9-0)+0,0)","v":6}]
[null,null,"Tuesday",null,null,null,null,7]
[null,null,"Wednesday",null,null,null,null,1]
[null,null,"Thursday",null,null,null,null,7]
[null,null,"Friday",null,null,null,null,1]
[null,null,"Saturday",null,null,null,null,6]
[null,null,"Sunday",null,null,null,null,6]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)*10","v":40}]
[null,"Q4.  The table shows the number of books sold in a shop",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AVERAGE(H54:I60),0)","v":24}]
[null,"        Calculate the mean books sold per day to the nearest whole book."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI52-AJ52","v":26},null,{"$f":"MAX(H54:I60)","v":39},{"$f":"MIN(H54:I60)","v":13}]
[null,null,"Days",null,null,null,null,"Books"]
[null,null,"Monday",null,null,null,null,{"$f":"ROUND(RAND()*(20-15)+15,0)","v":19}]
[null,null,"Tuesday",null,null,null,null,{"$f":"ROUND(RAND()*(20-10)+10,0)","v":16}]
[null,null,"Wednesday",null,null,null,null,{"$f":"ROUND(RAND()*(15-8)+8,0)","v":13}]
[null,null,"Thursday",null,null,null,null,{"$f":"ROUND(RAND()*(20-12)+12,0)","v":19}]
[null,null,"Friday",null,null,null,null,{"$f":"ROUND(RAND()*(30-20)+20,0)","v":28}]
[null,null,"Saturday",null,null,null,null,{"$f":"ROUND(RAND()*(40-30)+30,0)","v":39}]
[null,null,"Sunday",null,null,null,null,{"$f":"ROUND(RAND()*(40-30)+30,0)","v":31}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)*10","v":30}]
[null,"Q5.  The table shows hours of sunshine over one week.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AVERAGE(H69:I75),2)","v":4.71}]
[null,"        Calculate the average hours of sunshine per day to 2 decimal places."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI67-AJ67","v":6},null,{"$f":"MAX(H69:I75)","v":8},{"$f":"MIN(H69:I75)","v":2}]
[null,null,"Days",null,null,null,null,"Hours"]
[null,null,"Monday",null,null,null,null,{"$f":"ROUND(RAND()*(9-0)+0,0)","v":2}]
[null,null,"Tuesday",null,null,null,null,8]
[null,null,"Wednesday",null,null,null,null,2]
[null,null,"Thursday",null,null,null,null,4]
[null,null,"Friday",null,null,null,null,7]
[null,null,"Saturday",null,null,null,null,5]
[null,null,"Sunday",null,null,null,null,5]
[]
[]
[]
[null,"Q6.  The table shows the number of shoes sold over one week.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AVERAGE(H84:I90),0)","v":4}]
[null,null,"Calculate the average number of shoes sold per day"]
[null,null,"to the nearest whole number and the range."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Range =",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI82-AJ82","v":9},null,{"$f":"MAX(H84:I90)","v":9},{"$f":"MIN(H84:I90)","v":0}]
[null,null,"Days",null,null,null,null,"Shoes"]
[null,null,"Monday",null,null,null,null,{"$f":"ROUND(RAND()*(9-0)+0,0)","v":4}]
[null,null,"Tuesday",null,null,null,null,1]
[null,null,"Wednesday",null,null,null,null,3]
[null,null,"Thursday",null,null,null,null,1]
[null,null,"Friday",null,null,null,null,7]
[null,null,"Saturday",null,null,null,null,{"$f":"ROUND(RAND()*(9-0)+0,0)","v":0}]
[null,null,"Sunday",null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-6)+6,0)*10","v":70}]
[]
[]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"Multiplication","index":4,"n_rows":90,"n_cols":35,"rows_kept":90,"cut":false,"hidden":false,"merged":[[66,1,71,28],[78,18,78,21],[80,1,85,28],[89,1,89,28],[11,8,11,9],[11,18,11,19],[27,1,32,28],[38,18,38,21],[40,1,45,28],[51,18,51,21],[53,1,58,28],[64,18,64,21],[14,4,14,7],[14,18,14,21],[16,2,20,13],[16,17,20,28],[25,18,25,21],[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (Multiplication)"]
[]
[]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/12"]
[]
[null,"Teacher :",null,null,null,"Mr Lafferty"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,0)","v":7},{"$f":"ROUND(RAND()*(9-3)+3,0)","v":8}]
[null,"Q1.","Calculate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(97-19)+19,0)","v":60},{"$f":"ROUND(RAND()*(999-119)+119,0)","v":751}]
[null,null,"(a)",null,{"$f":"AH9","v":7},null,"x",null,{"$f":"AH11","v":60},null,null,null,null,null,null,null,"(b)",null,{"$f":"AI11","v":751},null,null,"x",null,{"$f":"AI9","v":8},null,null,null,null,null,null,null,null,null,{"$f":"AH9*AH11","v":420},{"$f":"AI9*AI11","v":6008}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,0)","v":7}]
[null,{"$f":" \"Q2.  A full packet of paper contains \"&AH25&\" sheets of paper. \"","v":"Q2.  A full packet of paper contains 228 sheets of paper. "}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(499-168)+168,0)","v":228}]
[null,null,{"$f":" \"How many sheets in \"&AH23&\" packets.\"","v":"How many sheets in 7 packets."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sheets",null,null,null,null,null,null,null,null,null,null,{"$f":"AH23*AH25","v":1596}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,0)","v":8}]
[null,{"$f":"\"Q3.  A large tea box contains \"&AH38&\" tea bags.\"","v":"Q3.  A large tea box contains 661 tea bags."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(900-200)+200,0)","v":661}]
[null,null,{"$f":"\"How many are in \"&AH36&\" boxes\"","v":"How many are in 8 boxes"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"bags",null,null,null,null,null,null,null,null,null,null,{"$f":"AH36*AH38","v":5288}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,0)","v":4}]
[null,{"$f":" \"Q4.  The price of a holiday is \"&TEXT(AH51,\"£0.00\")&\" person.\"","v":"Q4.  The price of a holiday is £416.52 person."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(900-200)+200,2)","v":416.52}]
[null,{"$f":"\"     How much will it cost for \"&AH49&\" people to go on  holiday.\"","v":"     How much will it cost for 4 people to go on  holiday."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH49*AH51","v":1666.08}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,0)","v":6}]
[null,{"$f":" \"Q5.  Shaun gets paid \"&TEXT(AH64,\"£0.00\")&\" a month.\"","v":"Q5.  Shaun gets paid £1555.80 a month."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3213-1225)+1225,2)","v":1555.8}]
[null,null,{"$f":"\"How much does he get paid for \"&AH62&\" weeks.\"","v":"How much does he get paid for 6 weeks."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH62*AH64","v":9334.7999999999993}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-6)+6,0)","v":6}]
[null,{"$f":"\"Q6.    Mr Lafferty burns \"&AH78&\" calories an hour at the gym.\"","v":"Q6.    Mr Lafferty burns 1169.85 calories an hour at the gym."}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(1239-602)+602,2)","v":1169.8499999999999}]
[null,null,{"$f":"\"How many will he burn in \"&AH76&\" hours\"","v":"How many will he burn in 6 hours"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"calories",null,null,null,null,null,null,null,null,null,null,{"$f":"AH76*AH78","v":7019.0999999999995}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"Add_Sub","index":5,"n_rows":95,"n_cols":34,"rows_kept":95,"cut":false,"hidden":false,"merged":[[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9],[94,1,94,28],[16,2,20,28],[28,18,28,21],[30,2,34,28],[14,18,14,21],[42,18,42,21],[44,2,48,28],[56,18,56,21],[58,2,62,28],[70,18,70,21],[72,2,76,28],[84,18,84,21],[86,2,90,28]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (Percentages)"]
[]
[]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/18"]
[]
[null,"Teacher :",null,null,null,"Mr Lafferty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,2)","v":3.21}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,2)","v":3.49}]
[null,"Q1.",{"$f":"\"To make a certain colour of paint \"&AH9&\" litres of red is mixed with \"&AH8&\" litres of blue paint.\"","v":"To make a certain colour of paint 3.49 litres of red is mixed with 3.21 litres of blue paint."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH8+AH9","v":6.7}]
[null,null,{"$f":"\" I use \"&AH11&\" litres to paint my room.\"","v":" I use 1.82 litres to paint my room."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3-1)+1,2)","v":1.82}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH10-AH11","v":4.88}]
[]
[]
[null,null,"How much paint is left over.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"litres"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,2)","v":7.64}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,2)","v":3.34}]
[null,"Q2.",{"$f":"\"I spend \"&TEXT(AH22,\"£0.00\")&\" on sweets and \"&TEXT(AH23,\"£0.00\")&\" on juice.\"","v":"I spend £7.64 on sweets and £3.34 on juice."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH22+AH23","v":10.98}]
[null,null,{"$f":"\"I pay for them using a £20 note.\"","v":"I pay for them using a £20 note."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH25-AH24","v":9.02}]
[]
[]
[null,null,"How much change should I receive.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"£"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,2)","v":6.15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,2)","v":4.45}]
[null,"Q3.",{"$f":"\"I fruit punch is made with \"&AH36&\" litres of orange juice and \"&AH37&\" litres of apple juice.\"","v":"I fruit punch is made with 6.15 litres of orange juice and 4.45 litres of apple juice."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH36+AH37","v":10.600000000000001}]
[null,null,{"$f":"\"At the end of the day \"&AH39&\" litres were left.\"","v":"At the end of the day 4.07 litres were left."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(5-3)+3,2)","v":4.07}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH38-AH39","v":6.5300000000000011}]
[]
[]
[null,null,"How much juice was consumed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"litres"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(12-8)+8,2)","v":10.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(12-7)+7,2)","v":8.91}]
[null,"Q4.",{"$f":"\"John ran \"&AH50&\" km on Monday and \"&AH51&\" km on Tuesday.\"","v":"John ran 10.25 km on Monday and 8.91 km on Tuesday."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH50+AH51","v":19.16}]
[null,null,{"$f":"\"He was trying to run a total of \"&AH53&\" km.\"","v":"He was trying to run a total of 25 km."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(35-25)+25,0)","v":25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH53-AH52","v":5.84}]
[null,null,"How much should he run on Wednesday to make his target."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(120-70)+70,1)","v":103.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(120-80)+80,1)","v":88.9}]
[null,"Q5.",{"$f":"\"On a bus journey, the bus stopped for a morning tea break after \"&AH64&\" km.\"","v":"On a bus journey, the bus stopped for a morning tea break after 103.7 km."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(450-375)+375,0)","v":402}]
[null,null,{"$f":"\"It stopped for afternoon break after a further \"&AH65&\" km.\"","v":"It stopped for afternoon break after a further 88.9 km."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH66-(AH64+AH65)","v":209.39999999999998}]
[null,null,{"$f":"\"The total journey distance was \"&AH66&\" km.\"","v":"The total journey distance was 402 km."}]
[]
[]
[null,null,"How far did they still have to travel.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(60-35)+35,1)","v":56.9}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(50-21)+21,1)","v":21.7}]
[null,"Q6.",{"$f":"\"Stuart cycled \"&AH78&\" km on Thursday and \"&AH79&\" km on Friday.\"","v":"Stuart cycled 56.9 km on Thursday and 21.7 km on Friday."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH78+AH79","v":78.599999999999994}]
[null,null,{"$f":"\"He was trying to run a total of \"&AH81&\" km.\"","v":"He was trying to run a total of 143 km."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(150-130)+130,0)","v":143}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH81-AH80","v":64.400000000000006}]
[null,null,"How much should he run on Wednesday to make his target."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"Equations","index":6,"n_rows":99,"n_cols":35,"rows_kept":99,"cut":false,"hidden":false,"merged":[[54,24,54,25],[88,2,92,13],[88,17,92,28],[69,27,69,28],[74,2,78,13],[74,17,78,28],[83,12,83,13],[86,4,86,5],[98,1,98,28],[11,24,11,25],[25,24,25,25],[30,2,34,13],[30,17,34,28],[25,12,25,13],[57,4,57,5],[59,2,63,13],[59,17,63,28],[16,2,20,13],[16,17,20,28],[28,4,28,5],[40,24,40,25],[45,2,49,13],[45,17,49,28],[54,12,54,13],[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (Equations)"]
[]
[]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/36"]
[]
[null,"Teacher :",null,null,null,"Mr Lafferty"]
[]
[]
[null,"Q1.",null,"Solve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"e"}]
[null,null,"(a)",null,{"$f":"ROUND(RAND()*(10-(5))+(5),0)","v":9},{"$f":"CHAR(RAND()*(122-116)+116)","v":"w"},"+",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":27},"=",{"$f":"ROUND(RAND()*(4-(2))+(2),0)","v":4},{"$f":"F12","v":"w"},"+",{"$f":"AH12*E12+H12-J12*AH12","v":52},null,null,null,"(b)",null,null,{"$f":"ROUND(RAND()*(10-(5))+(5),0)","v":9},{"$f":"CONCATENATE(\"( \",U11)","v":"( e"},"+",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":28},")  =",{"$f":"T12*AH13+T12*W12","v":315},null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(10-(1))+(1),0)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-(1))+(1),0)","v":7}]
[]
[null,null,{"$f":"F12","v":"w"},"=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U11","v":"e"},"="]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)*10","v":40}]
[null,"Q2.",null,"Solve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"i"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(200-21)+21,0)*10","v":500},{"$f":"ROUND(RAND()*(200-21)+21,0)*10","v":820}]
[null,null,"(a)",null,{"$f":"ROUND(RAND()*((-1)-(-10))+(-10),0)","v":-3},{"$f":"CHAR(RAND()*(122-116)+116)","v":"v"},"-",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":26},"=",{"$f":"ROUND(RAND()*((10)-(2))+(2),0)","v":9},{"$f":"F26","v":"v"},"-",{"$f":"-(E26*AH26-H26-(J26*AH26))","v":194},null,null,null,"(b)",null,null,{"$f":"ROUND(RAND()*((-1)-(-10))+(-10),0)","v":-10},{"$f":"CONCATENATE(\"( \",U25)","v":"( i"},"-",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":29},")  =",{"$f":"T26*AH27-T26*W26","v":380},null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(20-(1))+(1),0)","v":14},{"$f":"AI23/100*AI25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*((-1)-(-10))+(-10),0)","v":-9}]
[]
[null,null,{"$f":"F26","v":"v"},"=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U25","v":"i"},"="]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)*10","v":40},{"$f":"ROUND(RAND()*(9-6)+6,0)*10","v":60}]
[null,"Q3.",null,"Solve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"g"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(200-21)+21,0)*10","v":1760},{"$f":"ROUND(RAND()*(200-21)+21,0)*10","v":1860}]
[null,null,"(a)",null,{"$f":"ROUND(RAND()*(10-(5))+(5),0)","v":9},{"$f":"CHAR(RAND()*(122-116)+116)","v":"t"},"+",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":29},"=",{"$f":"ROUND(RAND()*(4-(2))+(2),0)","v":4},{"$f":"F41","v":"t"},"+",{"$f":"AH41*E41+H41-J41*AH41","v":39},null,null,null,"(b)",null,null,{"$f":"ROUND(RAND()*(10-(5))+(5),0)","v":9},{"$f":"CONCATENATE(\"( \",U40)","v":"( g"},"+",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":10},")  =",{"$f":"T41*AH42+T41*W41","v":144},null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(10-(1))+(1),0)","v":2},{"$f":"AI38/100*AI40","v":1116}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-(1))+(1),0)","v":6}]
[]
[null,null,{"$f":"F41","v":"t"},"=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U40","v":"g"},"="]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q4.",null,"Solve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"i"}]
[null,null,"(a)",null,{"$f":"ROUND(RAND()*((-1)-(-10))+(-10),0)","v":-2},{"$f":"CHAR(RAND()*(122-116)+116)","v":"y"},"-",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":26},"=",{"$f":"ROUND(RAND()*((10)-(2))+(2),0)","v":6},{"$f":"F55","v":"y"},"-",{"$f":"-(E55*AH55-H55-(J55*AH55))","v":66},null,null,null,"(b)",null,null,{"$f":"ROUND(RAND()*((-1)-(-10))+(-10),0)","v":-3},{"$f":"CONCATENATE(\"( \",U54)","v":"( i"},"-",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":30},")  =",{"$f":"T55*AH56-T55*W55","v":102},null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(20-(1))+(1),0)","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*((-1)-(-10))+(-10),0)","v":-4}]
[]
[null,null,{"$f":"F55","v":"y"},"=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U54","v":"i"},"="]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q5.",null,"Solve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"c"}]
[null,null,"(a)",null,{"$f":"ROUND(RAND()*(10-(5))+(5),0)","v":8},{"$f":"CHAR(RAND()*(122-116)+116)","v":"y"},"+",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":5},"=",{"$f":"ROUND(RAND()*(4-(2))+(2),0)","v":3},{"$f":"F70","v":"y"},"+",{"$f":"AH70*E70+H70-J70*AH70","v":35},null,null,null,"(b)",null,null,{"$f":"ROUND(RAND()*((9)-(-5))+(-5),0)","v":1},{"$f":"CONCATENATE(\"( \",U69)","v":"( c"},"+",{"$f":"ROUND(RAND()*(15-(1))+(1),0)","v":15},")   ","-",{"$f":"ROUND(RAND()*(20-(5))+(5),0)","v":10},"=",{"$f":"T70*AH71+T70*W70-Z70","v":10},null,null,null,null,null,{"$f":"ROUND(RAND()*(10-(1))+(1),0)","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-(1))+(1),0)","v":5}]
[]
[null,null,{"$f":"F70","v":"y"},"=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U69","v":"c"},"="]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q6.",null,"Solve"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"d"}]
[null,null,"(a)",null,{"$f":"ROUND(RAND()*((-1)-(-10))+(-10),0)","v":-7},{"$f":"CHAR(RAND()*(122-116)+116)","v":"x"},"-",{"$f":"ROUND(RAND()*(30-(5))+(5),0)","v":26},"=",{"$f":"ROUND(RAND()*((10)-(2))+(2),0)","v":8},{"$f":"F84","v":"x"},"-",{"$f":"-(E84*AH84-H84-(J84*AH84))","v":266},null,null,null,"(b)",null,null,{"$f":"ROUND(RAND()*(9-(2))+(2),0)","v":7},{"$f":"CONCATENATE(\"( \",U83)","v":"( d"},"+",{"$f":"ROUND(RAND()*(10-(2))+(2),0)","v":8},")    ","+",{"$f":"ROUND(RAND()*(20-(2))+(2),0)","v":10},"=",{"$f":"T84*AH85+T84*W84+Z84","v":24},null,null,null,null,null,{"$f":"ROUND(RAND()*(20-(1))+(1),0)","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*((-1)-(-10))+(-10),0)","v":-6}]
[]
[null,null,{"$f":"F84","v":"x"},"=",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"U83","v":"d"},"="]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"Composite_Area","index":7,"n_rows":95,"n_cols":35,"rows_kept":95,"cut":false,"hidden":false,"merged":[[81,23,81,26],[83,10,89,28],[81,19,81,22],[39,11,45,28],[21,19,21,21],[21,23,21,26],[25,13,30,28],[51,19,51,22],[51,23,51,26],[56,7,56,8],[57,7,57,8],[58,7,58,8],[59,7,59,8],[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9],[9,19,9,21],[9,23,9,26],[14,2,16,5],[17,2,17,5],[14,1,16,1],[11,7,16,8],[13,13,18,28],[37,6,45,8],[94,1,94,28],[35,1,36,5],[37,19,37,21],[37,22,37,25],[66,19,66,21],[66,23,66,26],[68,10,74,28],[83,8,86,9],[81,1,81,7],[88,1,88,7],[51,1,51,7],[53,7,53,8],[53,10,59,28],[54,7,54,8],[55,7,55,8]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (Composite Area)"]
[]
[]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/30"]
[]
[null,"Teacher :",null,null,null,"Mr Lafferty"]
[]
[]
[null,"Q1.  Calculate the area of the shape below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area =",null,null,null,null,null,null,null,"m2",null,null,null,null,{"$f":"ROUND(RAND()*(1-0)+0,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(50-9)+9,0)","v":25},{"$f":"CONCATENATE(AG11,\" cm\")","v":"25 cm"},{"$f":"ROUND(AG11/2,0)","v":13}]
[null,null,null,null,null,null,null,{"$f":"AH11","v":"25 cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG10=0,AI11-ROUND(RAND()*(3-1)+1,0),AI11+ROUND(RAND()*(3-1)+1,0))","v":10},{"$f":"CONCATENATE(AG12,\" cm\")","v":"10 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG12+ROUND(RAND()*(3-1)+1,0)","v":11},"11 cm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AG12*AG13)+0.5*AG13*(AG11-AG12)","v":192.5}]
[null,{"$f":"AH12","v":"10 cm"}]
[]
[]
[null,null,{"$f":"AH13","v":"11 cm"}]
[]
[]
[]
[null,"Q2.  A square shaped garden has a path around the outside.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area =",null,null,null,null,null,null,null,"m2"]
[null,{"$f":"\"       Calculate the area of the path given the large square has length \"&AH23","v":"       Calculate the area of the path given the large square has length 16 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(30-10)+10,0)","v":16},{"$f":"CONCATENATE(AG23,\" m\")","v":"16 m"},{"$f":"ROUND(AG23/2,0)","v":8}]
[null,{"$f":"\"       and the small has length \"&AH24&\".\"","v":"       and the small has length 14 m."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG23-ROUND(RAND()*(5-1)+1,0)","v":14},{"$f":"CONCATENATE(AG24,\" m\")","v":"14 m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG23*AG23","v":256},{"$f":"AG24*AG24","v":196}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG25-AH25","v":60}]
[]
[]
[]
[]
[]
[]
[]
[null,"Q3.  An old victorian door is made from solid wood and has a circular glass window.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(100-60)+60,0)","v":81},{"$f":"CONCATENATE(AG34,\" cm\")","v":"81 cm"}]
[null,{"$f":"\"       The diameter of the circle is \"&AH34&\".\"","v":"       The diameter of the circle is 81 cm."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(300-230)+230,0)","v":255},{"$f":"CONCATENATE(AG35,\" cm\")","v":"255 cm"}]
[null,{"$f":"AH36","v":"128 cm"},null,null,null,null,null,null,"Calculate the area of the wood used to the nearest whole number.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(140-110)+110,0)","v":128},"128 cm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AG36*AG35-(PI()*POWER(AG34/2,2)),0)","v":27487}]
[null,null,null,null,null,null,{"$f":"AH35","v":"255 cm"},null,null,null,null,null,null,null,null,null,null,null,null,"Area =",null,null,null,null,null,null,"cm2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q4.  A logo for a company is made up of a rectangle with a semi-circle cut out from it.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(60-10)+10,0)","v":55},{"$f":"CONCATENATE(AG49,\" cm\")","v":"55 cm"}]
[null,{"$f":"\" The diameter of the circle is \"&AH49&\". Calculate the area of the logo to the nearest whole number.\"","v":" The diameter of the circle is 55 cm. Calculate the area of the logo to the nearest whole number."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(1.5*AG49,0)","v":83},{"$f":"CONCATENATE(AG50,\" cm\")","v":"83 cm"}]
[]
[null,{"$f":"AH50","v":"83 cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area = ",null,null,null,null,null,null,null,"cm2",null,null,null,null,{"$f":"ROUND(AG50*AG49-0.5*(PI()*POWER(AG49/2,2)),0)","v":3377}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q5.  A circle is encased in a square. \"","v":"Q5.  A circle is encased in a square. "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(60-10)+10,0)","v":46},{"$f":"CONCATENATE(AG64,\" cm\")","v":"46 cm"}]
[null,{"$f":"\"Calculate the shaded area to the nearest whole number  if the length ofthe square is \"&AH64&\".\"","v":"Calculate the shaded area to the nearest whole number  if the length ofthe square is 46 cm."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area",null,null,null,null,null,null,null,"cm2",null,null,null,null,{"$f":"ROUND(AG64*AG64-PI()*POWER(AG64/2,2),0)","v":454}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Q6.  A railway bridge is made from a rectangle and a semi-circle.\"","v":"Q6.  A railway bridge is made from a rectangle and a semi-circle."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(60-30)+30,0)","v":58},{"$f":"CONCATENATE(AG79,\" m\")","v":"58 m"}]
[null,"        Calculate the shaded area to the nearest whole number.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AG79/3,0)","v":19},{"$f":"CONCATENATE(AG80,\" m\")","v":"19 m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AG79/2+ROUND(RAND()*(7-2)+2,0),0)","v":34},"34 m"]
[null,{"$f":"AH79","v":"58 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area = ",null,null,null,null,null,null,null,"m2",null,null,null,null,{"$f":"ROUND(AG79*AG80-0.5*PI()*POWER(AG81/2,2),0)","v":648}]
[]
[null,null,null,null,null,null,null,null,{"$f":"AH80","v":"19 m"}]
[]
[]
[]
[]
[null,{"$f":"AH81","v":"34 m"}]
[]
[]
[]
[]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"DST","index":8,"n_rows":95,"n_cols":39,"rows_kept":95,"cut":false,"hidden":false,"merged":[[14,4,14,7],[16,2,20,13],[16,17,20,28],[14,18,14,21],[25,4,25,5],[25,18,25,19],[30,2,34,13],[30,17,34,28],[70,18,70,21],[72,2,76,28],[58,2,62,28],[86,2,90,28],[94,1,94,28],[42,18,42,21],[44,2,48,28],[56,18,56,21],[84,18,84,21],[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (Distance Speed Time)"]
[]
[]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/16"]
[]
[null,"Teacher :",null,null,null,"Mr Lafferty"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(99-11)+11,0)*6","v":198},{"$f":"AH9/60","v":3.3},{"$f":"MOD(AH9,60)","v":18},{"$f":"TRUNC(AI9,0)","v":3}]
[null,"Q1.","Convert these times to decimal hours",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(99-11)+11,0)*6","v":396},{"$f":"AH10/60","v":6.6},{"$f":"MOD(AH10,60)","v":36},{"$f":"TRUNC(AI10,0)","v":6}]
[]
[null,null,"(a)",null,{"$f":"AK9","v":3},"hours",null,null,{"$f":"AJ9","v":18},"minutes",null,null,null,null,null,null,"(b)",null,{"$f":"AK10","v":6},"hours",null,null,{"$f":"AJ10","v":36},"minutes",null,null,null,null,null,null,null,null,null,{"$f":"AI8","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"hours",null,null,null,null,null,null,null,null,null,null,null,null,null,"hours"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(99-11)+11,0)*6","v":312},{"$f":"AH23/60","v":5.2},{"$f":"MOD(AH23,60)","v":12},{"$f":"TRUNC(AI23,0)","v":5}]
[null,"Q2.","Convert these times to hours and minutes.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(99-11)+11,0)*6","v":108},{"$f":"AH24/60","v":1.8},{"$f":"MOD(AH24,60)","v":48},{"$f":"TRUNC(AI24,0)","v":1}]
[]
[null,null,"(a)",null,{"$f":"AI23","v":5.2},null,"hours",null,null,null,null,null,null,null,null,null,"(b)",null,{"$f":"AI24","v":1.8},null,"hours"]
[]
[]
[null,null,null,null,null,"hours",null,null,null,"minutes",null,null,null,null,null,null,null,null,null,"hours",null,null,null,"minutes"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(180-1)+1,0)*6","v":690},{"$f":"AH37/60","v":11.5},{"$f":"MOD(AH37,60)","v":30},{"$f":"TRUNC(AI37,0)","v":11},{"$f":"IF(AK37<10,CONCATENATE(\"0\",AK37),AK37)","v":11},{"$f":"IF(AJ37<10,CONCATENATE(\"0\",AJ37),AJ37)","v":30}]
[null,"Q3.",{"$f":"\"A bus left Kirkintilloch at \"&AI42&\" and arrived in Whithorn City at \"&AI43&\".\"","v":"A bus left Kirkintilloch at 11:30 and arrived in Whithorn City at 16:18."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(50-30)+30,0)*6","v":288},{"$f":"AH38/60","v":4.8},{"$f":"MOD(AH38,60)","v":48},{"$f":"TRUNC(AI38,0)","v":4},{"$f":"IF(AK38<10,CONCATENATE(\"0\",AK38),AK38)","v":"04"},{"$f":"IF(AJ38<10,CONCATENATE(\"0\",AJ38),AJ38)","v":48}]
[null,null,{"$f":"\"The distance from Kirkintilloch to Whithorn City is \"&AI45&\" km.\"","v":"The distance from Kirkintilloch to Whithorn City is 249.6 km."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ41","v":978},{"$f":"AH39/60","v":16.3},{"$f":"MOD(AH39,60)","v":18},{"$f":"TRUNC(AI39,0)","v":16},{"$f":"IF(AK39<10,CONCATENATE(\"0\",AK39),AK39)","v":16},18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(AK37,AJ37,0)","v":"11:30:00"},{"$f":"TIME(AK38,AJ38,0)","v":"04:48:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI40+AJ40","v":"16:18:00"},{"$f":"60*HOUR(AI41)+MINUTE(AI41)","v":978}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AL37,\":\",AM37)","v":"11:30"}]
[null,null,"What was the average speed of the bus.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km/hr",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AL39,\":\",AM39)","v":"16:18"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(70-50)+50,0)","v":52}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI44*AI38","v":249.6}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(180-1)+1,0)*6","v":258},{"$f":"AH51/60","v":4.3},{"$f":"MOD(AH51,60)","v":18},{"$f":"TRUNC(AI51,0)","v":4},{"$f":"IF(AK51<10,CONCATENATE(\"0\",AK51),AK51)","v":"04"},{"$f":"IF(AJ51<10,CONCATENATE(\"0\",AJ51),AJ51)","v":18}]
[null,"Q4.",{"$f":"\"A bus left Glasgow at \"&AI56&\" and arrived in Blog Town at \"&AI57&\".\"","v":"A bus left Glasgow at 04:18 and arrived in Blog Town at 07:42."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(50-30)+30,0)*6","v":204},{"$f":"AH52/60","v":3.4},{"$f":"MOD(AH52,60)","v":24},{"$f":"TRUNC(AI52,0)","v":3},{"$f":"IF(AK52<10,CONCATENATE(\"0\",AK52),AK52)","v":"03"},{"$f":"IF(AJ52<10,CONCATENATE(\"0\",AJ52),AJ52)","v":24}]
[null,null,{"$f":"\"The bus travelled at an average speed of \"&AI58&\" km/hr.\"","v":"The bus travelled at an average speed of 53 km/hr."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ55","v":462},{"$f":"AH53/60","v":7.7},{"$f":"MOD(AH53,60)","v":42},{"$f":"TRUNC(AI53,0)","v":7},{"$f":"IF(AK53<10,CONCATENATE(\"0\",AK53),AK53)","v":"07"},42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(AK51,AJ51,0)","v":"04:18:00"},{"$f":"TIME(AK52,AJ52,0)","v":"03:24:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI54+AJ54","v":"07:42:00"},{"$f":"60*HOUR(AI55)+MINUTE(AI55)","v":462}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AL51,\":\",AM51)","v":"04:18"}]
[null,null,"How far is it from Glasgow to Blog Town.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AL53,\":\",AM53)","v":"07:42"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(70-50)+50,0)","v":53}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI58*AI52","v":180.2}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(180-1)+1,0)*6","v":150},{"$f":"AH65/60","v":2.5},{"$f":"MOD(AH65,60)","v":30},{"$f":"TRUNC(AI65,0)","v":2},{"$f":"IF(AK65<10,CONCATENATE(\"0\",AK65),AK65)","v":"02"},{"$f":"IF(AJ65<10,CONCATENATE(\"0\",AJ65),AJ65)","v":30}]
[null,"Q5.",{"$f":"\"A train left Edinburgh at \"&AI70&\" and arrived in Kingsbridge at \"&AI71&\".\"","v":"A train left Edinburgh at 02:30 and arrived in Kingsbridge at 07:06."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(50-30)+30,0)*6","v":276},{"$f":"AH66/60","v":4.5999999999999996},{"$f":"MOD(AH66,60)","v":36},{"$f":"TRUNC(AI66,0)","v":4},{"$f":"IF(AK66<10,CONCATENATE(\"0\",AK66),AK66)","v":"04"},{"$f":"IF(AJ66<10,CONCATENATE(\"0\",AJ66),AJ66)","v":36}]
[null,null,{"$f":"\"The train travelled at an average speed of \"&AI72&\" km/hr.\"","v":"The train travelled at an average speed of 76 km/hr."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ69","v":426},{"$f":"AH67/60","v":7.1},{"$f":"MOD(AH67,60)","v":6},{"$f":"TRUNC(AI67,0)","v":7},{"$f":"IF(AK67<10,CONCATENATE(\"0\",AK67),AK67)","v":"07"},"06"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(AK65,AJ65,0)","v":"02:30:00"},{"$f":"TIME(AK66,AJ66,0)","v":"04:36:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI68+AJ68","v":"07:06:00"},{"$f":"60*HOUR(AI69)+MINUTE(AI69)","v":426}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AL65,\":\",AM65)","v":"02:30"}]
[null,null,"How far is it from Edinburgh to Kingsbridge.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AL67,\":\",AM67)","v":"07:06"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(90-50)+50,0)","v":76}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI72*AI66","v":349.59999999999997}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(180-1)+1,0)*6","v":90},{"$f":"AH79/60","v":1.5},{"$f":"MOD(AH79,60)","v":30},{"$f":"TRUNC(AI79,0)","v":1},{"$f":"IF(AK79<10,CONCATENATE(\"0\",AK79),AK79)","v":"01"},{"$f":"IF(AJ79<10,CONCATENATE(\"0\",AJ79),AJ79)","v":30}]
[null,"Q6.",{"$f":"\"A plane left Glasgow Airport at \"&AI84&\" bound for the Venice.\"","v":"A plane left Glasgow Airport at 01:30 bound for the Venice."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(50-30)+30,0)*6","v":246},{"$f":"AH80/60","v":4.0999999999999996},{"$f":"MOD(AH80,60)","v":6},{"$f":"TRUNC(AI80,0)","v":4},{"$f":"IF(AK80<10,CONCATENATE(\"0\",AK80),AK80)","v":"04"},{"$f":"IF(AJ80<10,CONCATENATE(\"0\",AJ80),AJ80)","v":"06"}]
[null,null,{"$f":"\"It arrived at \"&AI85&\". It had travelled a distance of \"&AI87&\" km.\"","v":"It arrived at 05:36. It had travelled a distance of 1963.9 km."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AJ83","v":336},{"$f":"AH81/60","v":5.6},{"$f":"MOD(AH81,60)","v":36},{"$f":"TRUNC(AI81,0)","v":5},{"$f":"IF(AK81<10,CONCATENATE(\"0\",AK81),AK81)","v":"05"},36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TIME(AK79,AJ79,0)","v":"01:30:00"},{"$f":"TIME(AK80,AJ80,0)","v":"04:06:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI82+AJ82","v":"05:36:00"},{"$f":"60*HOUR(AI83)+MINUTE(AI83)","v":336}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AL79,\":\",AM79)","v":"01:30"}]
[null,null,"Calculate the planes average speed.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km/hr",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(AL81,\":\",AM81)","v":"05:36"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(600-400)+400,0)","v":479}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI86*AI80","v":1963.8999999999999}]
[]
[]
[]
[]
[]
[]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"Linear_Patterns","index":9,"n_rows":118,"n_cols":51,"rows_kept":118,"cut":false,"hidden":false,"merged":[[108,22,109,23],[108,24,109,25],[108,26,109,27],[90,16,91,17],[90,18,91,19],[90,20,91,21],[90,22,91,23],[90,24,91,25],[90,26,91,27],[104,19,104,20],[72,22,73,23],[72,24,73,25],[72,26,73,27],[18,22,19,23],[18,24,19,25],[18,26,19,27],[36,16,37,17],[36,18,37,19],[36,20,37,21],[36,22,37,23],[36,24,37,25],[36,26,37,27],[58,11,60,28],[40,11,42,28],[22,11,24,28],[54,22,55,23],[54,24,55,25],[54,26,55,27],[72,16,73,17],[72,18,73,19],[72,20,73,21],[18,18,19,19],[18,20,19,21],[50,13,50,14],[32,13,32,14],[32,15,32,16],[32,19,32,20],[54,16,55,17],[54,18,55,19],[54,20,55,21],[67,13,67,14],[67,15,67,16],[67,17,67,18],[67,19,67,20],[30,17,30,18],[30,19,30,20],[94,11,96,28],[76,11,78,28],[113,3,113,7],[68,13,68,14],[68,15,68,16],[68,19,68,20],[86,13,86,14],[86,15,86,16],[86,19,86,20],[104,13,104,14],[104,15,104,16],[102,15,102,16],[102,17,102,18],[102,19,102,20],[103,1,103,8],[103,9,103,10],[103,11,103,12],[103,13,103,14],[103,15,103,16],[103,17,103,18],[103,19,103,20],[95,3,95,7],[95,8,95,9],[102,1,102,8],[102,9,102,10],[108,16,109,17],[102,11,102,12],[102,13,102,14],[84,19,84,20],[85,1,85,8],[85,9,85,10],[85,11,85,12],[85,13,85,14],[85,15,85,16],[85,17,85,18],[85,19,85,20],[84,1,84,8],[84,9,84,10],[84,11,84,12],[84,13,84,14],[84,15,84,16],[84,17,84,18],[108,18,109,19],[108,20,109,21],[77,3,77,7],[77,8,77,9],[49,17,49,18],[49,19,49,20],[59,3,59,7],[59,8,59,9],[66,1,66,8],[66,9,66,10],[66,11,66,12],[66,13,66,14],[66,15,66,16],[66,17,66,18],[50,15,50,16],[50,19,50,20],[48,11,48,12],[48,13,48,14],[48,15,48,16],[48,17,48,18],[48,19,48,20],[49,1,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[49,15,49,16],[12,17,12,18],[12,19,12,20],[13,1,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[31,1,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[31,15,31,16],[31,17,31,18],[31,19,31,20],[23,8,23,9],[30,1,30,8],[30,9,30,10],[30,11,30,12],[30,13,30,14],[30,15,30,16],[23,3,23,7],[14,13,14,14],[14,15,14,16],[14,19,14,20],[18,16,19,17],[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9],[113,8,113,10],[112,12,114,28],[117,1,117,28],[66,19,66,20],[67,1,67,8],[67,9,67,10],[67,11,67,12],[41,3,41,7],[41,8,41,9],[48,1,48,8],[48,9,48,10],[13,15,13,16],[13,17,13,18],[13,19,13,20],[12,1,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16]]}
[]
[null,"National 4 AVU                                                                                                                                                                                                                                                                                                   Individual Pupil Revision Plan                                                                                                                         (Linear Patterns)"]
[]
[]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/33"]
[]
[null,"Teacher :",null,null,null,"Mr Lafferty"]
[]
[]
[null,"Q1. A metal fence for a garden is made by joining iron bars together."]
[null,"     The table shows the link between the number of sections and the number of iron bars."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":2}]
[null,"Number of sections (S)",null,null,null,null,null,null,null,1,null,2,null,3,null,4,null,null,null,{"$f":"AX14","v":16},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":3}]
[null,"Number of iron bars (B)",null,null,null,null,null,null,null,{"$f":"AT15","v":5},null,{"$f":"AU15","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s",1,2,3,4,{"$f":"ROUND(RAND()*(20-11)+11,0)","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b",{"$f":"AT14*$AT$13+$AT$12","v":5},{"$f":"AU14*$AT$13+$AT$12","v":8},11,14,50]
[null,"(a)  Complete the table above. "]
[]
[null,"(b)   Find a formula for calculating the number of bars (B), when you know the number of sections (S).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"b","=",{"$f":"AT13","v":3},"s","+",{"$f":"AT12","v":2}]
[]
[]
[]
[null,{"$f":"\"(c)   A fence is made up by joining \"&AS22&\" iron bars.  How many sections are in this fence.\"","v":"(c)   A fence is made up by joining 86 iron bars.  How many sections are in this fence."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT13*AT22+AT12","v":86},{"$f":"ROUND(RAND()*(40-25)+25,0)","v":28}]
[]
[null,null,null,"Sections ="]
[]
[]
[]
[null,"Q2. The sides of a bridge are constructed by joining sections. The sections are made of steel girders."]
[null,"     The table shows the link between the number of sections and the number of girders."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-4)+4,0)","v":5}]
[null,"Number of sections (S)",null,null,null,null,null,null,null,1,null,2,null,3,null,4,null,null,null,{"$f":"AX32","v":16},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT30-ROUND(RAND()*(3-1)+1,0)","v":2}]
[null,"Number of girders (G)",null,null,null,null,null,null,null,{"$f":"AT33","v":3},null,{"$f":"AU33","v":8},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"s",1,2,3,4,{"$f":"ROUND(RAND()*(20-11)+11,0)","v":16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"g",{"$f":"AT32*$AT$30-$AT$31","v":3},{"$f":"AU32*$AT$30-$AT$31","v":8},13,18,78]
[null,"(a)  Complete the table above. "]
[]
[null,"(b)   Find a formula for calculating the number of girders (G), when you know the number of sections (S).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"g","=",{"$f":"AT30","v":5},"s","-",{"$f":"AT31","v":2}]
[]
[]
[]
[null,{"$f":"\"(c)   A bridge has \"&AT40&\" sections.  How many girders are there.\"","v":"(c)   A bridge has 28 sections.  How many girders are there."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT30*AT40-AT31","v":138},{"$f":"ROUND(RAND()*(40-25)+25,0)","v":28}]
[]
[null,null,null,"Girders ="]
[]
[]
[]
[null,"Q3. A designer is looking at the table and seating arrangements for a large office block."]
[null,"     The link between the number of tables and the number of chairs is given below."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":4}]
[null,"Number of tables (T)",null,null,null,null,null,null,null,1,null,2,null,3,null,4,null,null,null,{"$f":"AX50","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":9}]
[null,"Number of chairs (C)",null,null,null,null,null,null,null,{"$f":"AT51","v":13},null,{"$f":"AU51","v":17},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"t",1,2,3,4,{"$f":"ROUND(RAND()*(20-11)+11,0)","v":12}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c",{"$f":"AT50*$AT$48+$AT$49","v":13},{"$f":"AU50*$AT$48+$AT$49","v":17},21,25,57]
[null,"(a)  Complete the table above. "]
[]
[null,"(b)   Find a formula for calculating the number of chairs (C), when you know the number of tables (T).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"c","=",{"$f":"AT48","v":4},"t","+",{"$f":"AT49","v":9}]
[]
[]
[]
[null,{"$f":"\"(c)    Given we have \"&AS58&\" chairs.  How many tables are there.\"","v":"(c)    Given we have 109 chairs.  How many tables are there."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT48*AT58+AT49","v":109},{"$f":"ROUND(RAND()*(40-25)+25,0)","v":25}]
[]
[null,null,null,"Tables ="]
[]
[]
[]
[null,"Q4. This table shows the cost of hiring a carpet cleaner for several days."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(20-12)+12,0)","v":19}]
[null,"Number of days (D)",null,null,null,null,null,null,null,1,null,2,null,3,null,4,null,null,null,{"$f":"AX68","v":15},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-1)+1,0)","v":7}]
[null,"Cost £ (C)",null,null,null,null,null,null,null,{"$f":"AT69","v":12},null,{"$f":"AU69","v":31},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",1,2,3,4,{"$f":"ROUND(RAND()*(20-11)+11,0)","v":15}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",{"$f":"AT68*$AT$66-$AT$67","v":12},{"$f":"AU68*$AT$66-$AT$67","v":31},50,69,278]
[null,"(a)  Complete the table above. "]
[]
[null,"(b)   Find a formula for calculating the cost (C), when you know the number of days hire (D).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","=",{"$f":"AT66","v":19},"D","-",{"$f":"AT67","v":7}]
[]
[]
[]
[null,{"$f":"\"(c)   How much will it cost £ to hire for \"&AT76&\" days.\"","v":"(c)   How much will it cost £ to hire for 28 days."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT66*AT76-AT67","v":525},{"$f":"ROUND(RAND()*(40-25)+25,0)","v":28}]
[]
[null,null,null,"Cost £"]
[]
[]
[]
[null,"Q5. A play area is to be fence."]
[null,"     The table shows the link between the number of sections and the number of wooden lengths."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":6}]
[null,"Number of sections (S)",null,null,null,null,null,null,null,1,null,2,null,3,null,4,null,null,null,{"$f":"AX86","v":18},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-2)+2,0)","v":3}]
[null,"Number of lengths of wood (W)",null,null,null,null,null,null,null,{"$f":"AT87","v":9},null,{"$f":"AU87","v":12},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S",1,2,3,4,{"$f":"ROUND(RAND()*(20-11)+11,0)","v":18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W",{"$f":"AT86*$AT$85+$AT$84","v":9},{"$f":"AU86*$AT$85+$AT$84","v":12},15,18,60]
[null,"(a)  Complete the table above. "]
[]
[null,"(b)   Find a formula for calculating the number of lengths of wood (W) , when you know the number of sections (S).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"W","=",{"$f":"AT85","v":3},"S","+",{"$f":"AT84","v":6}]
[]
[]
[]
[null,{"$f":"\"(c)   A fence is made up by joining \"&AS94&\" lengths of wood (W).  How many sections are in this fence.\"","v":"(c)   A fence is made up by joining 120 lengths of wood (W).  How many sections are in this fence."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT85*AT94+AT84","v":120},{"$f":"ROUND(RAND()*(40-25)+25,0)","v":38}]
[]
[null,null,null,"Sections ="]
[]
[]
[]
[null,"Q6. This table shows the cost of hiring a van for several days."]
[null,"     The table shows the link between the cost (C) and the number of days (D)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(40-15)+15,0)","v":30}]
[null,"Number of days (D)",null,null,null,null,null,null,null,1,null,2,null,3,null,4,null,null,null,{"$f":"AX104","v":18},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(10-3)+3,0)","v":5}]
[null,"Cost £ (C)",null,null,null,null,null,null,null,{"$f":"AT105","v":35},null,{"$f":"AU105","v":65},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D",1,2,3,4,{"$f":"ROUND(RAND()*(20-11)+11,0)","v":18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C",{"$f":"AT104*$AT$102+$AT$103","v":35},{"$f":"AU104*$AT$102+$AT$103","v":65},95,125,545]
[null,"(a)  Complete the table above. "]
[]
[null,"(b)   Find a formula for calculating the cost (C) , when you know the number of days (D) hired.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"C","=",{"$f":"AT102","v":30},"D","+",{"$f":"AT103","v":5}]
[]
[]
[]
[null,{"$f":"\"(c)   How much will it cost to hire a van for \"&AT112&\" days.\"","v":"(c)   How much will it cost to hire a van for 40 days."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AT102*AT112+AY108","v":1205},{"$f":"ROUND(RAND()*(40-25)+25,0)","v":40}]
[]
[null,null,null,"Cost £ "]
[]
[]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"Pythagoras","index":10,"n_rows":114,"n_cols":35,"rows_kept":114,"cut":false,"hidden":false,"merged":[[113,1,113,28],[19,2,23,28],[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9],[61,9,62,13],[97,9,98,13],[98,3,103,7],[104,22,104,24],[106,2,110,28],[13,15,14,17],[17,6,17,13],[15,3,15,5],[14,3,14,5],[17,22,17,24],[34,6,34,13],[34,22,34,24],[36,2,40,28],[28,15,32,17],[53,2,57,28],[45,3,50,7],[62,3,67,7],[68,22,68,24],[51,6,51,13],[51,22,51,24],[70,2,74,28],[79,3,84,7],[85,6,85,13],[85,22,85,24],[87,2,91,28]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (Pythagoras Theorem)"]
[]
[]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/36"]
[]
[null,"Teacher :",null,null,null,"Mr Lafferty"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Q1.","An athlete runs round a course which is in the shape of a right - angled triangle.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,"Calculate the full distance he ran.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(900-100)+100,0)","v":884},{"$f":"CONCATENATE(AH11,\"m\")","v":"884m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH8*AH11","v":2652},{"$f":"CONCATENATE(AH12,\" m\")","v":"2652 m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH9*AH11","v":3536},{"$f":"CONCATENATE(AH13,\" m\")","v":"3536 m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI12","v":"2652 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"5*AH11","v":4420}," "]
[null,null,null,"Start /"]
[null,null,null,"Finish"]
[]
[null,null,null,null,null,null,{"$f":"AI13","v":"3536 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m",null,null,null,null,null,null,null,{"$f":"AH14+AH13+AH12","v":10608}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Q2.","Calculate the perimeter of this isosceles triangle.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(99-10)+10,0)","v":83},{"$f":"CONCATENATE(AH28,\"cm\")","v":"83cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI29","v":"249 cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH25*AH28","v":249},{"$f":"CONCATENATE(AH29,\" cm\")","v":"249 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH26*AH28","v":332},{"$f":"CONCATENATE(AH30,\" cm\")","v":"332 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"5*AH28","v":415}," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH30*2","v":664},{"$f":"CONCATENATE(AH32,\" cm\")","v":"664 cm"}]
[]
[]
[null,null,null,null,null,null,{"$f":"AI32","v":"664 cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cm",null,null,null,null,null,null,null,{"$f":"AH32+2*AH31","v":1494}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Q3.",{"$f":"\"In a yachting race a boat travelled East for \"&AH45&\" km. Then travels North for \"&AH46&\" km.\"","v":"In a yachting race a boat travelled East for 11 km. Then travels North for 33 km."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,{"$f":"\" It then turned and followed a direct path home. Calculate the TOTAL distance travelled.\"","v":" It then turned and followed a direct path home. Calculate the TOTAL distance travelled."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(20-1)+1,0)","v":11},{"$f":"CONCATENATE(AH45,\"km\")","v":"11km"}]
[null,null,null,{"$f":"AI47","v":"44 km"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH42*AH45","v":33},{"$f":"CONCATENATE(AH46,\" km\")","v":"33 km"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH43*AH45","v":44},{"$f":"CONCATENATE(AH47,\" km\")","v":"44 km"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"5*AH45","v":55}," "]
[]
[]
[]
[null,null,null,null,null,null,{"$f":"AI46","v":"33 km"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"km",null,null,null,null,null,null,null,{"$f":"AH46+AH47+AH48","v":132}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Q4.","Calculate the perimeter of the isosceles triangle.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,null,null,{"$f":"AI66","v":"18 cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(20-1)+1,0)","v":3},{"$f":"CONCATENATE(AH62,\" cm\")","v":"3 cm"}]
[null,null,null,{"$f":"AI64","v":"12 cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH59*AH62","v":9},{"$f":"CONCATENATE(AH63,\" cm\")","v":"9 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH60*AH62","v":12},{"$f":"CONCATENATE(AH64,\" cm\")","v":"12 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"5*AH62","v":15},{"$f":"CONCATENATE(AH65,\" cm\")","v":"15 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2*AH63","v":18},{"$f":"CONCATENATE(AH66,\" cm\")","v":"18 cm"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"cm",null,null,null,null,null,null,null,{"$f":"AH66+2*AH65","v":48}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Q5.","At Football training the players had to run round a right-angled triangular course.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,{"$f":"\"If they had to complete \"&AH83&\" circuits. How far did they run.\"","v":"If they had to complete 3 circuits. How far did they run."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(30-10)+10,0)","v":25},{"$f":"CONCATENATE(AH79,\"m\")","v":"25m"}]
[null,null,null,{"$f":"AI81","v":"100 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH76*AH79","v":75},{"$f":"CONCATENATE(AH80,\" m\")","v":"75 m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH77*AH79","v":100},{"$f":"CONCATENATE(AH81,\" m\")","v":"100 m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"5*AH79","v":125}," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(5-2)+2,0)","v":3}]
[]
[]
[null,null,null,null,null,null,{"$f":"AI80","v":"75 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m",null,null,null,null,null,null,null,{"$f":"(AH81+AH82+AH80)*AH83","v":900}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[null,"Q6.","A pair of isosceles earings are made from gold wire as shown below.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,"How much gold wire will be needed for the pair."]
[null,null,null,null,null,null,null,null,null,{"$f":"AI102","v":"24 mm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(7-1)+1,0)","v":4},{"$f":"CONCATENATE(AH98,\" mm\")","v":"4 mm"}]
[null,null,null,{"$f":"AI100","v":"16 mm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH94*AH98","v":12},{"$f":"CONCATENATE(AH99,\" mm\")","v":"12 mm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH95*AH98","v":16},{"$f":"CONCATENATE(AH100,\" mm\")","v":"16 mm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"5*AH98","v":20},{"$f":"CONCATENATE(AH101,\" mm\")","v":"20 mm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2*AH99","v":24},{"$f":"CONCATENATE(AH102,\" mm\")","v":"24 mm"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"mm",null,null,null,null,null,null,null,{"$f":"(AH102+2*AH101)*2","v":128}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"SOHCAHTOA","index":11,"n_rows":114,"n_cols":41,"rows_kept":114,"cut":false,"hidden":false,"merged":[[104,13,104,15],[103,15,103,16],[99,6,103,7],[104,22,104,24],[106,2,110,28],[113,1,113,28],[15,5,16,5],[68,22,68,24],[70,2,74,28],[85,6,85,13],[85,22,85,24],[17,6,17,13],[17,22,17,24],[19,2,23,28],[32,5,33,5],[34,22,34,24],[36,2,40,28],[31,9,31,11],[30,3,30,4],[27,8,28,10],[29,10,29,11],[87,2,91,28],[51,22,51,24],[53,2,57,28],[61,9,62,13],[62,3,67,7],[31,6,31,7],[51,12,51,14],[47,8,47,10],[82,17,84,18],[82,12,82,14],[13,15,14,17],[12,7,13,9],[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (SOHCAHTOA)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(106-97)+97,0)","v":106}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(1-0)+0,0)","v":1},{"$f":"ROUND(RAND()*(3-1)+1,0)","v":3},{"$f":"CONCATENATE(AH3,AI3)","v":"13"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH3=1,F16,O12)","v":"J"}]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/36"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(20-5)+5,0)","v":20},{"$f":"IF(AJ3=\"11\",CONCATENATE(AH6,\" m\"),IF(AJ3=\"02\",CONCATENATE(AH6,\" m\"),IF(AJ3=\"03\",CONCATENATE(AH6,\" m\"),IF(AJ3=\"13\",CONCATENATE(AH6,\" m\"),\"\"))))","v":"20 m"}]
[null,"Teacher :",null,null,null,"Mr Lafferty",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AH6*ROUND(RAND()*(3-1.5)+1.5,1),0)","v":52},{"$f":"IF(AJ3=\"12\",CONCATENATE(AH7,\" m\"),IF(AJ3=\"01\",CONCATENATE(AH7,\" m\"),IF(AJ3=\"03\",CONCATENATE(AH7,\" m\"),IF(AJ3=\"13\",CONCATENATE(AH7,\" m\"),\"\"))))","v":"52 m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SQRT((AH6*AH6)+(AH7*AH7)),0)","v":56},{"$f":"IF(AJ3=\"03\",\"\",IF(AJ3=\"13\",\"\",CONCATENATE(AH8,\" m\")))","v":""}]
[]
[null,"Q1.",{"$f":"\"Find the size of the angle at \"&AH4&\" to the nearest degree.\"","v":"Find the size of the angle at J to the nearest degree."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AH2+1))","v":"K"}]
[null,null,null,null,null,null,null,{"$f":"AI8","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI6","v":"20 m"}]
[]
[null,null,null,null,null,{"$f":"UPPER(CHAR(AH2))","v":"J"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AH2+2))","v":"L"}]
[null,null,null,null,null,null,{"$f":"AI7","v":"52 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"o",null,null,null,null,null,null,null,{"$f":"IF(AJ3=\"01\",ROUND(DEGREES(ASIN(AH7/AH8)),0),IF(AJ3=\"02\",ROUND(DEGREES(ACOS(AH6/AH8)),0),IF(AJ3=\"03\",ROUND(DEGREES(ATAN(AH7/AH6)),0),IF(AJ3=\"11\",ROUND(DEGREES(ASIN(AH6/AH8)),0),IF(AJ3=\"12\",ROUND(DEGREES(ACOS(AH7/AH8)),0),IF(AJ3=\"13\",ROUND(DEGREES(ATAN(AH6/AH7)),0),\"\"))))))","v":21}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(106-97)+97,0)","v":105}]
[null,"Q2.",{"$f":"\"Find the length of \"&AH29&\" to the metre.\"","v":"Find the length of KJ to the metre."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(1-0)+0,0)","v":0},{"$f":"ROUND(RAND()*(3-1)+1,0)","v":3},{"$f":"CONCATENATE(AH27,AI27)","v":"03"}]
[null,null,null,null,null,null,null,null,{"$f":"AK31","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH27=1,O29,F33)","v":"I"}]
[null,null,null,null,null,{"$f":"UPPER(CHAR(AH26+2))","v":"K"},null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AH26+1))","v":"J"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AO30=1,CONCATENATE(F33,F29),IF(AO31=1,CONCATENATE(F29,O29),IF(AO32=1,CONCATENATE(O29,F33))))","v":"KJ"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH27=0,AH35,\"\")","v":71},null,"o",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(20-5)+5,0)","v":18},{"$f":"IF(AJ27=\"11\",CONCATENATE(AH30,\" m\"),IF(AJ27=\"02\",CONCATENATE(AH30,\" m\"),IF(AJ27=\"03\",CONCATENATE(AH30,\" m\"),IF(AJ27=\"13\",CONCATENATE(AH30,\" m\"),\"\"))))","v":"18 m"},{"$f":"IF(AI30=\"\",\"\",AH30)","v":18},{"$f":"IF(AJ31=\"\",\"\",AI30)","v":"18 m"},{"$f":"IF(AK30=\"\",0,1)","v":1},{"$f":"IF(AJ30=\"\",\"\",AI30)","v":"18 m"},null,{"$f":"IF(AL30=0,IF(AM30<>\"\",1,\"\"),\"\")","v":""}]
[null,null,null,{"$f":"AK30","v":"18 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AH30*ROUND(RAND()*(3-1.5)+1.5,1),0)","v":52},{"$f":"IF(AJ27=\"12\",CONCATENATE(AH31,\" m\"),IF(AJ27=\"01\",CONCATENATE(AH31,\" m\"),IF(AJ27=\"03\",CONCATENATE(AH31,\" m\"),IF(AJ27=\"13\",CONCATENATE(AH31,\" m\"),\"\"))))","v":"52 m"},{"$f":"IF(AI31=\"\",\"\",AH31)","v":52},{"$f":"IF(AJ30<>\"\",\"\",AI31)","v":""},{"$f":"IF(AK31=\"\",0,1)","v":0},{"$f":"IF(AJ31=\"\",\"\",AI31)","v":"52 m"},null,1]
[null,null,null,null,null,null,{"$f":"IF(AH27=1,AH35,\"\")","v":""},null,"o",{"$f":"AK32","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SQRT((AH30*AH30)+(AH31*AH31)),0)","v":55},{"$f":"IF(AJ27=\"03\",\"\",IF(AJ27=\"13\",\"\",CONCATENATE(AH32,\" m\")))","v":""},"",{"$f":"IF(AJ30=\"\",\"\",AI32)","v":""},0,"",null,{"$f":"IF(AL32=0,IF(AM32<>\"\",1,\"\"),\"\")","v":""}]
[null,null,null,null,null,{"$f":"UPPER(CHAR(AH26))","v":"I"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"m",null,null,null,null,null,null,null,{"$f":"IF(AJ27=\"01\",ROUND(DEGREES(ASIN(AH31/AH32)),0),IF(AJ27=\"02\",ROUND(DEGREES(ACOS(AH30/AH32)),0),IF(AJ27=\"03\",ROUND(DEGREES(ATAN(AH31/AH30)),0),IF(AJ27=\"11\",ROUND(DEGREES(ASIN(AH30/AH32)),0),IF(AJ27=\"12\",ROUND(DEGREES(ACOS(AH31/AH32)),0),IF(AJ27=\"13\",ROUND(DEGREES(ATAN(AH30/AH31)),0),\"\"))))))","v":71},{"$f":"IF(AO30=1,AH30,IF(AO31=1,AH31,IF(AO32=1,AH32,\"\")))","v":52}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q3.","For the isosceles traingle below calculate the size of xo to the nearest degree."]
[]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"AI50","v":"144.6 cm"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2*ROUND(RAND()*(100-10)+10,0)","v":174},{"$f":"CONCATENATE(AH48,\" cm\")","v":"174 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH48/2","v":87},{"$f":"CONCATENATE(AH49,\" cm\")","v":"87 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AH49/COS(AH52*PI()/180),1)","v":144.6},{"$f":"CONCATENATE(AH50,\" cm\")","v":"144.6 cm"}]
[null,null,null,null,null,null,null,null,null,null,"xo"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI48","v":"174 cm"},null,null,null,null,null,null,null,null,null,null,null,null,"o",null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(70-26)+26,0)","v":53}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q4.","Calculate the size of angle yo given the triangle is isosceles."]
[null,null,null,null,null,null,null,null,null,{"$f":"AI65","v":"152 cm"}]
[null,null,null,{"$f":"AI67","v":"179 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"y","o"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2*ROUND(RAND()*(100-10)+10,0)","v":152},{"$f":"CONCATENATE(AH65,\" cm\")","v":"152 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH65/2","v":76},{"$f":"CONCATENATE(AH66,\" cm\")","v":"76 cm"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," to the nearest degree",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AH66*TAN(AH69*PI()/180),1)","v":179},{"$f":"CONCATENATE(AH67,\" cm\")","v":"179 cm"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"o",null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(70-26)+26,0)","v":67}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q5.","The sketch below shows a ramp at the back of a van."]
[null,null,"Given the dimensions calculate size of angle xo to the nearest degree."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI84","v":"4.92 m"},null,null,null,null,{"$f":"AI83","v":"0.6 m"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"2*ROUND(RAND()*(2-0.4)*0.4,1)","v":0.6},{"$f":"CONCATENATE(AH83,\" m\")","v":"0.6 m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AH83/SIN(AH86*PI()/180),2)","v":4.92},{"$f":"CONCATENATE(AH84,\" m\")","v":"4.92 m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"xo"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"o",null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(20-4)+4,0)","v":7}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Q6.",{"$f":"\"The angle of elevation from the ground to the top of a block of flats is \"&AH103&\" degrees.\"","v":"The angle of elevation from the ground to the top of a block of flats is 30 degrees."}]
[null,null,"Calculate the height of the block of flats to the nearest metre."]
[]
[]
[null,null,null,null,null,null,"h"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(200-30)+30,0)","v":34},{"$f":"CONCATENATE(AH102,\" m\")","v":"34 m"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(60-10)+10,0)","v":30}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AH103","v":30},null,"o"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI102","v":"34 m"},null,null,null,null,null,null,null,null,null,null,null,"m",null,null,null,null,null,null,null,{"$f":"ROUND(AH102*TAN(AH103*PI()/180),0)","v":20}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Check that you have shown ALL your working before submitting your work."]

{"sheet":"Coordinates","index":12,"n_rows":99,"n_cols":73,"rows_kept":99,"cut":false,"hidden":false,"merged":[[98,1,98,28],[1,1,2,28],[4,5,4,14],[4,21,4,23],[4,25,4,28],[6,5,6,9]]}
[]
[null,"National 4 AVU                                                                                                                              Individual Pupil Revision Plan                                                                                                      (Coordinates)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(106-97)+97,0)","v":106}]
[null,"Name :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mark :",null,null,null,"/24",null,null,null,null,null,{"$f":"UPPER(CHAR(AF4))","v":"J"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF4+1))","v":"K"}]
[null,"Teacher :",null,null,null,"Mr Lafferty",null,null,null,null,null,"( If doing online you need to use your jotter to plot points)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF4+2))","v":"L"},null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD","S"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF4+3))","v":"M"},null,{"$f":"ROUND(RAND()*(5-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":1},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":1},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":2},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":-4},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(7-(-4))+(-4),0)","v":3},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":-1},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":0},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":-6},null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(6-(-6))+(-6),0)","v":-4},{"$f":"ROUND(RAND()*(7-(-1))+(-1),0)","v":3},{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4"]
[null,"Q1.",null,{"$f":"\"Draw coordinate axes on the grid and plot\"","v":"Draw coordinate axes on the grid and plot"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(5-1)+1,0)","v":4},null,1,1,-1,1,-1,-1,1,-1,2,1,-1,1,-1,-1,2,-1,1,1,-1,1,-2,-1,0,-1,0,1,-2,0,0,-1,2,0,0,1,-1,0,0,-2,1,0]
[null,null,null,{"$f":"\" the points \"&AF5&\" (\"&AH16&\",\"&AI16&\")   \"&AF6&\" (\"&AJ16&\",\"&AK16&\")  \"&AF7&\" (\"&AL16&\",\"&AM16&\")   \"","v":" the points J (0,-3)   K (-6,-6)  L (0,-9)   "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"a"},null,null,null,null,null,null,null,null,null,null,1,"square",{"$f":"$AH$8*AH10+$AI$8","v":3},{"$f":"$AH$8*AI10+$AJ$8","v":3},{"$f":"$AH$8*AJ10+$AI$8","v":-1},{"$f":"$AH$8*AK10+$AJ$8","v":3},{"$f":"$AH$8*AL10+$AI$8","v":-1},{"$f":"$AH$8*AM10+$AJ$8","v":-1},{"$f":"$AH$8*AN10+$AI$8","v":3},{"$f":"$AH$8*AO10+$AJ$8","v":-1},{"$f":"$AP$8*AP10+$AQ$8","v":6},{"$f":"$AP$8*AQ10+$AR$8","v":-2},{"$f":"$AP$8*AR10+$AQ$8","v":0},{"$f":"$AP$8*AS10+$AR$8","v":-2},{"$f":"$AP$8*AT10+$AQ$8","v":0},{"$f":"$AP$8*AU10+$AR$8","v":-6},{"$f":"$AP$8*AV10+$AQ$8","v":6},{"$f":"$AP$8*AW10+$AR$8","v":-6},{"$f":"$AX$8*AX10+$AY$8","v":5},{"$f":"$AX$8*AY10+$AZ$8","v":1},{"$f":"$AX$8*AZ10+$AY$8","v":1},{"$f":"$AX$8*BA10+$AZ$8","v":1},{"$f":"$AX$8*BB10+$AY$8","v":-1},{"$f":"$AX$8*BC10+$AZ$8","v":-3},{"$f":"$AX$8*BD10+$AY$8","v":3},{"$f":"$AX$8*BE10+$AZ$8","v":-3},{"$f":"$BF$8*BF10+$BG$8","v":0},{"$f":"$BF$8*BG10+$BH$8","v":-3},{"$f":"$BF$8*BH10+$BG$8","v":-6},{"$f":"$BF$8*BI10+$BH$8","v":-6},{"$f":"$BF$8*BJ10+$BG$8","v":0},{"$f":"$BF$8*BK10+$BH$8","v":-9},{"$f":"$BF$8*BL10+$BG$8","v":6},{"$f":"$BF$8*BM10+$BH$8","v":-6},{"$f":"$BN$8*BN10+$BO$8","v":-4},{"$f":"$BQ$8*BO10+$BP$8","v":6},{"$f":"$BN$8*BP10+$BO$8","v":-6},{"$f":"$BQ$8*BQ10+$BP$8","v":3},{"$f":"$BN$8*BR10+$BO$8","v":-4},{"$f":"$BQ$8*BS10+$BP$8","v":-3},{"$f":"$BN$8*BT10+$BO$8","v":-2},{"$f":"$BQ$8*BU10+$BP$8","v":3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"rectangle",{"$f":"AP11","v":6},{"$f":"AQ11","v":-2},0,-2,0,-6,6,-6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"parallelogram",{"$f":"AX11","v":5},{"$f":"AY11","v":1},1,1,-1,-3,3,-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"rhombus",{"$f":"BF11","v":0},{"$f":"BG11","v":-3},-6,-6,0,-9,6,-6]
[null,null,null,{"$f":"\"Plot a fourth point \"&AF8&\" to form a \"&AG16&\".\"","v":"Plot a fourth point M to form a rhombus."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"kite",{"$f":"BN11","v":-4},{"$f":"BO11","v":6},-6,3,-4,-3,-2,3]
[null,null,null,{"$f":"\"Join up the points to show the \"&AG16&\" \"&AF5&AF6&AF7&AF8&\".\"","v":"Join up the points to show the rhombus JKLM."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP($AF$10,$AF$11:$AF$15,AG11:AG15)","v":"rhombus"},{"$f":"LOOKUP($AF$10,$AF$11:$AF$15,AH11:AH15)","v":0},-3,-6,-6,0,-9,6,-6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(AN16,\"0\")","v":"6"},{"$f":"TEXT(AO16,\"0\")","v":"-6"}]
[null,null,null,{"$f":"\"Write down the coordinates of the point \"&AF8&\".\"","v":"Write down the coordinates of the point M."}]
[]
[null,null,null,"Coordinates = ",null,"(",null,",",null,")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(112-107)+107,0)","v":111}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF20))","v":"O"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF20+1))","v":"P"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF20+2))","v":"Q"},null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD","S"]
[null,"Q2.",null,{"$f":"\"Draw coordinate axes on the grid and plot\"","v":"Draw coordinate axes on the grid and plot"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF20+3))","v":"R"},null,{"$f":"ROUND(RAND()*(5-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":-1},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":-1},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":4},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":-3},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(7-(-4))+(-4),0)","v":1},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":1},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":2},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":2},null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(6-(-6))+(-6),0)","v":0},{"$f":"ROUND(RAND()*(7-(-1))+(-1),0)","v":5},{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3}]
[null,null,null,{"$f":"\" the points \"&AF21&\" (\"&AH32&\",\"&AI32&\")   \"&AF22&\" (\"&AJ32&\",\"&AK32&\")  \"&AF23&\" (\"&AL32&\",\"&AM32&\")   \"","v":" the points O (4,4)   P (-2,4)  Q (-5,-2)   "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"i"},null,null,null,null,null,null,null,null,null,null,null,null,"x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(5-1)+1,0)","v":3},null,1,1,-1,1,-1,-1,1,-1,2,1,-1,1,-1,-1,2,-1,1,1,-1,1,-2,-1,0,-1,0,1,-2,0,0,-1,2,0,0,1,-1,0,0,-2,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"square",{"$f":"$AH$24*AH26+$AI$24","v":2},{"$f":"$AH$24*AI26+$AJ$24","v":2},{"$f":"$AH$24*AJ26+$AI$24","v":-4},{"$f":"$AH$24*AK26+$AJ$24","v":2},{"$f":"$AH$24*AL26+$AI$24","v":-4},{"$f":"$AH$24*AM26+$AJ$24","v":-4},{"$f":"$AH$24*AN26+$AI$24","v":2},{"$f":"$AH$24*AO26+$AJ$24","v":-4},{"$f":"$AP$24*AP26+$AQ$24","v":10},{"$f":"$AP$24*AQ26+$AR$24","v":0},{"$f":"$AP$24*AR26+$AQ$24","v":1},{"$f":"$AP$24*AS26+$AR$24","v":0},{"$f":"$AP$24*AT26+$AQ$24","v":1},{"$f":"$AP$24*AU26+$AR$24","v":-6},{"$f":"$AP$24*AV26+$AQ$24","v":10},{"$f":"$AP$24*AW26+$AR$24","v":-6},{"$f":"$AX$24*AX26+$AY$24","v":4},{"$f":"$AX$24*AY26+$AZ$24","v":4},{"$f":"$AX$24*AZ26+$AY$24","v":-2},{"$f":"$AX$24*BA26+$AZ$24","v":4},{"$f":"$AX$24*BB26+$AY$24","v":-5},{"$f":"$AX$24*BC26+$AZ$24","v":-2},{"$f":"$AX$24*BD26+$AY$24","v":1},{"$f":"$AX$24*BE26+$AZ$24","v":-2},{"$f":"$BF$24*BF26+$BG$24","v":2},{"$f":"$BF$24*BG26+$BH$24","v":5},{"$f":"$BF$24*BH26+$BG$24","v":-4},{"$f":"$BF$24*BI26+$BH$24","v":2},{"$f":"$BF$24*BJ26+$BG$24","v":2},{"$f":"$BF$24*BK26+$BH$24","v":-1},{"$f":"$BF$24*BL26+$BG$24","v":8},{"$f":"$BF$24*BM26+$BH$24","v":2},{"$f":"$BN$24*BN26+$BO$24","v":0},{"$f":"$BQ$24*BO26+$BP$24","v":8},{"$f":"$BN$24*BP26+$BO$24","v":-2},{"$f":"$BQ$24*BQ26+$BP$24","v":5},{"$f":"$BN$24*BR26+$BO$24","v":0},{"$f":"$BQ$24*BS26+$BP$24","v":-1},{"$f":"$BN$24*BT26+$BO$24","v":2},{"$f":"$BQ$24*BU26+$BP$24","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"rectangle",{"$f":"AP27","v":10},{"$f":"AQ27","v":0},{"$f":"AR27","v":1},{"$f":"AS27","v":0},{"$f":"AT27","v":1},{"$f":"AU27","v":-6},{"$f":"AV27","v":10},{"$f":"AW27","v":-6}]
[null,null,null,{"$f":"\"Plot a fourth point \"&AF24&\" to form a \"&AG32&\".\"","v":"Plot a fourth point R to form a parallelogram."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"parallelogram",{"$f":"AX27","v":4},{"$f":"AY27","v":4},{"$f":"AZ27","v":-2},{"$f":"BA27","v":4},{"$f":"BB27","v":-5},{"$f":"BC27","v":-2},{"$f":"BD27","v":1},{"$f":"BE27","v":-2}]
[null,null,null,{"$f":"\"Join up the points to show the \"&AG32&\" \"&AF21&AF22&AF23&AF24&\".\"","v":"Join up the points to show the parallelogram OPQR."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"rhombus",{"$f":"BF27","v":2},{"$f":"BG27","v":5},{"$f":"BH27","v":-4},{"$f":"BI27","v":2},{"$f":"BJ27","v":2},{"$f":"BK27","v":-1},{"$f":"BL27","v":8},{"$f":"BM27","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"kite",{"$f":"BN27","v":0},{"$f":"BO27","v":8},{"$f":"BP27","v":-2},{"$f":"BQ27","v":5},{"$f":"BR27","v":0},{"$f":"BS27","v":-1},{"$f":"BT27","v":2},{"$f":"BU27","v":5}]
[null,null,null,{"$f":"\"Write down the coordinates of the point \"&AF24&\".\"","v":"Write down the coordinates of the point R."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP($AF$26,$AF$27:$AF$31,AG27:AG31)","v":"parallelogram"},{"$f":"LOOKUP($AF$26,$AF$27:$AF$31,AH27:AH31)","v":4},4,{"$f":"LOOKUP($AF$26,$AF$27:$AF$31,AJ27:AJ31)","v":-2},4,-5,-2,1,-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(AN32,\"0\")","v":"1"},{"$f":"TEXT(AO32,\"0\")","v":"-2"}]
[null,null,null,"Coordinates = ",null,"(",null,",",null,")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(117-113)+113,0)","v":116}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF35))","v":"T"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF35+1))","v":"U"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF35+2))","v":"V"},null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD","S"]
[null,"Q3.",null,{"$f":"\"Draw coordinate axes on the grid and plot\"","v":"Draw coordinate axes on the grid and plot"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF35+3))","v":"W"},null,{"$f":"ROUND(RAND()*(5-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":1},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":-5},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":3},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":-5},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(7-(-4))+(-4),0)","v":2},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":5},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":3},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":7},null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)","v":4},{"$f":"ROUND(RAND()*(6-(-6))+(-6),0)","v":-5},{"$f":"ROUND(RAND()*(7-(-1))+(-1),0)","v":5},{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2}]
[null,null,null,{"$f":"\" the points \"&AF36&\" (\"&AH47&\",\"&AI47&\")   \"&AF37&\" (\"&AJ47&\",\"&AK47&\")  \"&AF38&\" (\"&AL47&\",\"&AM47&\")   \"","v":" the points T (7,-3)   U (1,-3)  V (1,-7)   "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"h"},null,null,null,null,null,null,null,null,null,null,null,null,"x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(5-1)+1,0)","v":2},null,1,1,-1,1,-1,-1,1,-1,2,1,-1,1,-1,-1,2,-1,1,1,-1,1,-2,-1,0,-1,0,1,-2,0,0,-1,2,0,0,1,-1,0,0,-2,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"square",{"$f":"$AH$39*AH41+$AI$39","v":4},{"$f":"$AH$39*AI41+$AJ$39","v":-2},{"$f":"$AH$39*AJ41+$AI$39","v":-2},{"$f":"$AH$39*AK41+$AJ$39","v":-2},{"$f":"$AH$39*AL41+$AI$39","v":-2},{"$f":"$AH$39*AM41+$AJ$39","v":-8},{"$f":"$AH$39*AN41+$AI$39","v":4},{"$f":"$AH$39*AO41+$AJ$39","v":-8},{"$f":"$AP$39*AP41+$AQ$39","v":7},{"$f":"$AP$39*AQ41+$AR$39","v":-3},{"$f":"$AP$39*AR41+$AQ$39","v":1},{"$f":"$AP$39*AS41+$AR$39","v":-3},{"$f":"$AP$39*AT41+$AQ$39","v":1},{"$f":"$AP$39*AU41+$AR$39","v":-7},{"$f":"$AP$39*AV41+$AQ$39","v":7},{"$f":"$AP$39*AW41+$AR$39","v":-7},{"$f":"$AX$39*AX41+$AY$39","v":5},{"$f":"$AX$39*AY41+$AZ$39","v":8},{"$f":"$AX$39*AZ41+$AY$39","v":-1},{"$f":"$AX$39*BA41+$AZ$39","v":8},{"$f":"$AX$39*BB41+$AY$39","v":-4},{"$f":"$AX$39*BC41+$AZ$39","v":2},{"$f":"$AX$39*BD41+$AY$39","v":2},{"$f":"$AX$39*BE41+$AZ$39","v":2},{"$f":"$BF$39*BF41+$BG$39","v":3},{"$f":"$BF$39*BG41+$BH$39","v":10},{"$f":"$BF$39*BH41+$BG$39","v":-3},{"$f":"$BF$39*BI41+$BH$39","v":7},{"$f":"$BF$39*BJ41+$BG$39","v":3},{"$f":"$BF$39*BK41+$BH$39","v":4},{"$f":"$BF$39*BL41+$BG$39","v":9},{"$f":"$BF$39*BM41+$BH$39","v":7},{"$f":"$BN$39*BN41+$BO$39","v":-5},{"$f":"$BQ$39*BO41+$BP$39","v":7},{"$f":"$BN$39*BP41+$BO$39","v":-9},{"$f":"$BQ$39*BQ41+$BP$39","v":5},{"$f":"$BN$39*BR41+$BO$39","v":-5},{"$f":"$BQ$39*BS41+$BP$39","v":1},{"$f":"$BN$39*BT41+$BO$39","v":-1},{"$f":"$BQ$39*BU41+$BP$39","v":5}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"rectangle",{"$f":"AP42","v":7},{"$f":"AQ42","v":-3},{"$f":"AR42","v":1},{"$f":"AS42","v":-3},{"$f":"AT42","v":1},{"$f":"AU42","v":-7},{"$f":"AV42","v":7},{"$f":"AW42","v":-7}]
[null,null,null,{"$f":"\"Plot a fourth point \"&AF39&\" to form a \"&AG47&\".\"","v":"Plot a fourth point W to form a rectangle."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"parallelogram",{"$f":"AX42","v":5},{"$f":"AY42","v":8},{"$f":"AZ42","v":-1},{"$f":"BA42","v":8},{"$f":"BB42","v":-4},{"$f":"BC42","v":2},{"$f":"BD42","v":2},{"$f":"BE42","v":2}]
[null,null,null,{"$f":"\"Join up the points to show the \"&AG47&\" \"&AF36&AF37&AF38&AF39&\".\"","v":"Join up the points to show the rectangle TUVW."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"rhombus",{"$f":"BF42","v":3},{"$f":"BG42","v":10},{"$f":"BH42","v":-3},{"$f":"BI42","v":7},{"$f":"BJ42","v":3},{"$f":"BK42","v":4},{"$f":"BL42","v":9},{"$f":"BM42","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"kite",{"$f":"BN42","v":-5},{"$f":"BO42","v":7},{"$f":"BP42","v":-9},{"$f":"BQ42","v":5},{"$f":"BR42","v":-5},{"$f":"BS42","v":1},{"$f":"BT42","v":-1},{"$f":"BU42","v":5}]
[null,null,null,{"$f":"\"Write down the coordinates of the point \"&AF39&\".\"","v":"Write down the coordinates of the point W."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP($AF$41,$AF$42:$AF$46,AG42:AG46)","v":"rectangle"},{"$f":"LOOKUP($AF$41,$AF$42:$AF$46,AH42:AH46)","v":7},{"$f":"LOOKUP($AF$41,$AF$42:$AF$46,AI42:AI46)","v":-3},1,-3,1,-7,7,-7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(AN47,\"0\")","v":"7"},{"$f":"TEXT(AO47,\"0\")","v":"-7"}]
[null,null,null,"Coordinates = ",null,"(",null,",",null,")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(119-113)+113,0)","v":115}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF49))","v":"S"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF49+1))","v":"T"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF49+2))","v":"U"},null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD","S"]
[null,"Q4.",null,{"$f":"\"Draw coordinate axes on the grid and plot\"","v":"Draw coordinate axes on the grid and plot"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF49+3))","v":"V"},null,{"$f":"ROUND(RAND()*(5-2)+2,0)","v":4},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":-4},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":5},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":1},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":0},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(7-(-4))+(-4),0)","v":2},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":-3},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":-3},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":-6},null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(6-(-6))+(-6),0)","v":3},{"$f":"ROUND(RAND()*(7-(-1))+(-1),0)","v":0},{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3}]
[null,null,null,{"$f":"\" the points \"&AF50&\" (\"&AH61&\",\"&AI61&\")   \"&AF51&\" (\"&AJ61&\",\"&AK61&\")  \"&AF52&\" (\"&AL61&\",\"&AM61&\")   \"","v":" the points S (5,2)   T (-1,2)  U (-1,-2)   "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"d"},null,null,null,null,null,null,null,null,null,null,null,null,"x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(5-1)+1,0)","v":2},null,1,1,-1,1,-1,-1,1,-1,2,1,-1,1,-1,-1,2,-1,1,1,-1,1,-2,-1,0,-1,0,1,-2,0,0,-1,2,0,0,1,-1,0,0,-2,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"square",{"$f":"$AH$53*AH55+$AI$53","v":0},{"$f":"$AH$53*AI55+$AJ$53","v":9},{"$f":"$AH$53*AJ55+$AI$53","v":-8},{"$f":"$AH$53*AK55+$AJ$53","v":9},{"$f":"$AH$53*AL55+$AI$53","v":-8},{"$f":"$AH$53*AM55+$AJ$53","v":1},{"$f":"$AH$53*AN55+$AI$53","v":0},{"$f":"$AH$53*AO55+$AJ$53","v":1},{"$f":"$AP$53*AP55+$AQ$53","v":5},{"$f":"$AP$53*AQ55+$AR$53","v":2},{"$f":"$AP$53*AR55+$AQ$53","v":-1},{"$f":"$AP$53*AS55+$AR$53","v":2},{"$f":"$AP$53*AT55+$AQ$53","v":-1},{"$f":"$AP$53*AU55+$AR$53","v":-2},{"$f":"$AP$53*AV55+$AQ$53","v":5},{"$f":"$AP$53*AW55+$AR$53","v":-2},{"$f":"$AX$53*AX55+$AY$53","v":5},{"$f":"$AX$53*AY55+$AZ$53","v":0},{"$f":"$AX$53*AZ55+$AY$53","v":-1},{"$f":"$AX$53*BA55+$AZ$53","v":0},{"$f":"$AX$53*BB55+$AY$53","v":-4},{"$f":"$AX$53*BC55+$AZ$53","v":-6},{"$f":"$AX$53*BD55+$AY$53","v":2},{"$f":"$AX$53*BE55+$AZ$53","v":-6},{"$f":"$BF$53*BF55+$BG$53","v":-3},{"$f":"$BF$53*BG55+$BH$53","v":-4},{"$f":"$BF$53*BH55+$BG$53","v":-7},{"$f":"$BF$53*BI55+$BH$53","v":-6},{"$f":"$BF$53*BJ55+$BG$53","v":-3},{"$f":"$BF$53*BK55+$BH$53","v":-8},{"$f":"$BF$53*BL55+$BG$53","v":1},{"$f":"$BF$53*BM55+$BH$53","v":-6},{"$f":"$BN$53*BN55+$BO$53","v":3},{"$f":"$BQ$53*BO55+$BP$53","v":3},{"$f":"$BN$53*BP55+$BO$53","v":0},{"$f":"$BQ$53*BQ55+$BP$53","v":0},{"$f":"$BN$53*BR55+$BO$53","v":3},{"$f":"$BQ$53*BS55+$BP$53","v":-6},{"$f":"$BN$53*BT55+$BO$53","v":6},{"$f":"$BQ$53*BU55+$BP$53","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"rectangle",{"$f":"AP56","v":5},{"$f":"AQ56","v":2},{"$f":"AR56","v":-1},{"$f":"AS56","v":2},{"$f":"AT56","v":-1},{"$f":"AU56","v":-2},{"$f":"AV56","v":5},{"$f":"AW56","v":-2}]
[null,null,null,{"$f":"\"Plot a fourth point \"&AF53&\" to form a \"&AG61&\".\"","v":"Plot a fourth point V to form a rectangle."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"parallelogram",{"$f":"AX56","v":5},{"$f":"AY56","v":0},{"$f":"AZ56","v":-1},{"$f":"BA56","v":0},{"$f":"BB56","v":-4},{"$f":"BC56","v":-6},{"$f":"BD56","v":2},{"$f":"BE56","v":-6}]
[null,null,null,{"$f":"\"Join up the points to show the \"&AG61&\" \"&AF50&AF51&AF52&AF53&\".\"","v":"Join up the points to show the rectangle STUV."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"rhombus",{"$f":"BF56","v":-3},{"$f":"BG56","v":-4},{"$f":"BH56","v":-7},{"$f":"BI56","v":-6},{"$f":"BJ56","v":-3},{"$f":"BK56","v":-8},{"$f":"BL56","v":1},{"$f":"BM56","v":-6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"kite",{"$f":"BN56","v":3},{"$f":"BO56","v":3},{"$f":"BP56","v":0},{"$f":"BQ56","v":0},{"$f":"BR56","v":3},{"$f":"BS56","v":-6},{"$f":"BT56","v":6},{"$f":"BU56","v":0}]
[null,null,null,{"$f":"\"Write down the coordinates of the point \"&AF53&\".\"","v":"Write down the coordinates of the point V."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP($AF$55,$AF$56:$AF$60,AG56:AG60)","v":"rectangle"},{"$f":"LOOKUP($AF$55,$AF$56:$AF$60,AH56:AH60)","v":5},{"$f":"LOOKUP($AF$55,$AF$56:$AF$60,AI56:AI60)","v":2},-1,2,-1,-2,5,-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(AN61,\"0\")","v":"5"},{"$f":"TEXT(AO61,\"0\")","v":"-2"}]
[null,null,null,"Coordinates = ",null,"(",null,",",null,")"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(106-97)+97,0)","v":105}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF64))","v":"I"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF64+1))","v":"J"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF64+2))","v":"K"},null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD","S"]
[null,"Q5.",null,{"$f":"\"Draw coordinate axes on the grid and plot\"","v":"Draw coordinate axes on the grid and plot"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF64+3))","v":"L"},null,{"$f":"ROUND(RAND()*(5-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":-3},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":1},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":1},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":2},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(7-(-4))+(-4),0)","v":3},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":-4},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":-4},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":6},null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(6-(-6))+(-6),0)","v":2},{"$f":"ROUND(RAND()*(7-(-1))+(-1),0)","v":7},{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2}]
[null,null,null,{"$f":"\" the points \"&AF65&\" (\"&AH76&\",\"&AI76&\")   \"&AF66&\" (\"&AJ76&\",\"&AK76&\")  \"&AF67&\" (\"&AL76&\",\"&AM76&\")   \"","v":" the points I (7,5)   J (-2,5)  K (-2,-1)   "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"c"},null,null,null,null,null,null,null,null,null,null,null,null,"x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(5-1)+1,0)","v":2},null,1,1,-1,1,-1,-1,1,-1,2,1,-1,1,-1,-1,2,-1,1,1,-1,1,-2,-1,0,-1,0,1,-2,0,0,-1,2,0,0,1,-1,0,0,-2,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"square",{"$f":"$AH$68*AH70+$AI$68","v":0},{"$f":"$AH$68*AI70+$AJ$68","v":4},{"$f":"$AH$68*AJ70+$AI$68","v":-6},{"$f":"$AH$68*AK70+$AJ$68","v":4},{"$f":"$AH$68*AL70+$AI$68","v":-6},{"$f":"$AH$68*AM70+$AJ$68","v":-2},{"$f":"$AH$68*AN70+$AI$68","v":0},{"$f":"$AH$68*AO70+$AJ$68","v":-2},{"$f":"$AP$68*AP70+$AQ$68","v":7},{"$f":"$AP$68*AQ70+$AR$68","v":5},{"$f":"$AP$68*AR70+$AQ$68","v":-2},{"$f":"$AP$68*AS70+$AR$68","v":5},{"$f":"$AP$68*AT70+$AQ$68","v":-2},{"$f":"$AP$68*AU70+$AR$68","v":-1},{"$f":"$AP$68*AV70+$AQ$68","v":7},{"$f":"$AP$68*AW70+$AR$68","v":-1},{"$f":"$AX$68*AX70+$AY$68","v":5},{"$f":"$AX$68*AY70+$AZ$68","v":-2},{"$f":"$AX$68*AZ70+$AY$68","v":1},{"$f":"$AX$68*BA70+$AZ$68","v":-2},{"$f":"$AX$68*BB70+$AY$68","v":-1},{"$f":"$AX$68*BC70+$AZ$68","v":-6},{"$f":"$AX$68*BD70+$AY$68","v":3},{"$f":"$AX$68*BE70+$AZ$68","v":-6},{"$f":"$BF$68*BF70+$BG$68","v":-4},{"$f":"$BF$68*BG70+$BH$68","v":8},{"$f":"$BF$68*BH70+$BG$68","v":-8},{"$f":"$BF$68*BI70+$BH$68","v":6},{"$f":"$BF$68*BJ70+$BG$68","v":-4},{"$f":"$BF$68*BK70+$BH$68","v":4},{"$f":"$BF$68*BL70+$BG$68","v":0},{"$f":"$BF$68*BM70+$BH$68","v":6},{"$f":"$BN$68*BN70+$BO$68","v":2},{"$f":"$BQ$68*BO70+$BP$68","v":9},{"$f":"$BN$68*BP70+$BO$68","v":-1},{"$f":"$BQ$68*BQ70+$BP$68","v":7},{"$f":"$BN$68*BR70+$BO$68","v":2},{"$f":"$BQ$68*BS70+$BP$68","v":3},{"$f":"$BN$68*BT70+$BO$68","v":5},{"$f":"$BQ$68*BU70+$BP$68","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"rectangle",{"$f":"AP71","v":7},{"$f":"AQ71","v":5},{"$f":"AR71","v":-2},{"$f":"AS71","v":5},{"$f":"AT71","v":-2},{"$f":"AU71","v":-1},{"$f":"AV71","v":7},{"$f":"AW71","v":-1}]
[null,null,null,{"$f":"\"Plot a fourth point \"&AF68&\" to form a \"&AG76&\".\"","v":"Plot a fourth point L to form a rectangle."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"parallelogram",{"$f":"AX71","v":5},{"$f":"AY71","v":-2},{"$f":"AZ71","v":1},{"$f":"BA71","v":-2},{"$f":"BB71","v":-1},{"$f":"BC71","v":-6},{"$f":"BD71","v":3},{"$f":"BE71","v":-6}]
[null,null,null,{"$f":"\"Join up the points to show the \"&AG76&\" \"&AF65&AF66&AF67&AF68&\".\"","v":"Join up the points to show the rectangle IJKL."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"rhombus",{"$f":"BF71","v":-4},{"$f":"BG71","v":8},{"$f":"BH71","v":-8},{"$f":"BI71","v":6},{"$f":"BJ71","v":-4},{"$f":"BK71","v":4},{"$f":"BL71","v":0},{"$f":"BM71","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"kite",{"$f":"BN71","v":2},{"$f":"BO71","v":9},{"$f":"BP71","v":-1},{"$f":"BQ71","v":7},{"$f":"BR71","v":2},{"$f":"BS71","v":3},{"$f":"BT71","v":5},{"$f":"BU71","v":7}]
[null,null,null,{"$f":"\"Write down the coordinates of the point \"&AF68&\".\"","v":"Write down the coordinates of the point L."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP($AF$70,$AF71:$AF$75,AG71:AG75)","v":"rectangle"},{"$f":"LOOKUP($AF$70,$AF$71:$AF$75,AH71:AH75)","v":7},{"$f":"LOOKUP($AF$70,$AF$71:$AF$75,AI71:AI75)","v":5},-2,5,-2,-1,7,-1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(AN76,\"0\")","v":"7"},{"$f":"TEXT(AO76,\"0\")","v":"-1"}]
[null,null,null,"Coordinates = ",null,"(",null,null,null,")",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(119-113)+113,0)","v":117}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF78))","v":"U"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF78+1))","v":"V"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF78+2))","v":"W"},null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD",null,null,null,null,null,"S","LR","UD","S"]
[null,"Q6.",null,{"$f":"\"Draw coordinate axes on the grid and plot\"","v":"Draw coordinate axes on the grid and plot"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"UPPER(CHAR(AF78+3))","v":"X"},null,{"$f":"ROUND(RAND()*(5-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":-1},{"$f":"ROUND(RAND()*(5-(-5))+(-5),0)","v":0},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":1},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":5},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(7-(-4))+(-4),0)","v":-4},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":4},null,null,null,null,null,{"$f":"ROUND(RAND()*(3-2)+2,0)","v":2},{"$f":"ROUND(RAND()*(4-(-4))+(-4),0)","v":4},{"$f":"ROUND(RAND()*(7-(-7))+(-7),0)","v":1},null,null,null,null,null,{"$f":"ROUND(RAND()*(4-2)+2,0)","v":3},{"$f":"ROUND(RAND()*(6-(-6))+(-6),0)","v":5},{"$f":"ROUND(RAND()*(7-(-1))+(-1),0)","v":2},{"$f":"ROUND(RAND()*(3-2)+2,0)","v":3}]
[null,null,null,{"$f":"\" the points \"&AF79&\" (\"&AH90&\",\"&AI90&\")   \"&AF80&\" (\"&AJ90&\",\"&AK90&\")  \"&AF81&\" (\"&AL90&\",\"&AM90&\")   \"","v":" the points U (-2,6)   V (-6,6)  W (-8,2)   "},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CHAR(RAND()*(106-97)+97)","v":"a"},null,null,null,null,null,null,null,null,null,null,null,null,"x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4","x1","y1","x2","y2","x3","y3","x4","y4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(5-1)+1,0)","v":3},null,1,1,-1,1,-1,-1,1,-1,2,1,-1,1,-1,-1,2,-1,1,1,-1,1,-2,-1,0,-1,0,1,-2,0,0,-1,2,0,0,1,-1,0,0,-2,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"square",{"$f":"$AH$8*AH84+$AI$8","v":3},{"$f":"$AH$8*AI84+$AJ$8","v":3},{"$f":"$AH$8*AJ84+$AI$8","v":-1},{"$f":"$AH$8*AK84+$AJ$8","v":3},{"$f":"$AH$8*AL84+$AI$8","v":-1},{"$f":"$AH$8*AM84+$AJ$8","v":-1},{"$f":"$AH$8*AN84+$AI$8","v":3},{"$f":"$AH$8*AO84+$AJ$8","v":-1},{"$f":"$AP$82*AP84+$AQ$82","v":5},{"$f":"$AP$82*AQ84+$AR$82","v":7},{"$f":"$AP$82*AR84+$AQ$82","v":-1},{"$f":"$AP$82*AS84+$AR$82","v":7},{"$f":"$AP$82*AT84+$AQ$82","v":-1},{"$f":"$AP$82*AU84+$AR$82","v":3},{"$f":"$AP$82*AV84+$AQ$82","v":5},{"$f":"$AP$82*AW84+$AR$82","v":3},{"$f":"$AX$82*AX84+$AY$82","v":-2},{"$f":"$AX$82*AY84+$AZ$82","v":6},{"$f":"$AX$82*AZ84+$AY$82","v":-6},{"$f":"$AX$82*BA84+$AZ$82","v":6},{"$f":"$AX$82*BB84+$AY$82","v":-8},{"$f":"$AX$82*BC84+$AZ$82","v":2},{"$f":"$AX$82*BD84+$AY$82","v":-4},{"$f":"$AX$82*BE84+$AZ$82","v":2},{"$f":"$BF$82*BF84+$BG$82","v":4},{"$f":"$BF$82*BG84+$BH$82","v":3},{"$f":"$BF$82*BH84+$BG$82","v":0},{"$f":"$BF$82*BI84+$BH$82","v":1},{"$f":"$BF$82*BJ84+$BG$82","v":4},{"$f":"$BF$82*BK84+$BH$82","v":-1},{"$f":"$BF$82*BL84+$BG$82","v":8},{"$f":"$BF$82*BM84+$BH$82","v":1},{"$f":"$BN$82*BN84+$BO$82","v":5},{"$f":"$BQ$82*BO84+$BP$82","v":5},{"$f":"$BN$82*BP84+$BO$82","v":2},{"$f":"$BQ$82*BQ84+$BP$82","v":2},{"$f":"$BN$82*BR84+$BO$82","v":5},{"$f":"$BQ$82*BS84+$BP$82","v":-4},{"$f":"$BN$82*BT84+$BO$82","v":8},{"$f":"$BQ$82*BU84+$BP$82","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"rectangle",{"$f":"AP85","v":5},{"$f":"AQ85","v":7},{"$f":"AR85","v":-1},{"$f":"AS85","v":7},{"$f":"AT85","v":-1},{"$f":"AU85","v":3},{"$f":"AV85","v":5},{"$f":"AW85","v":3}]
[null,null,null,{"$f":"\"Plot a fourth point \"&AF82&\" to form a \"&AG90&\".\"","v":"Plot a fourth point X to form a parallelogram."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"parallelogram",{"$f":"AX85","v":-2},{"$f":"AY85","v":6},{"$f":"AZ85","v":-6},{"$f":"BA85","v":6},{"$f":"BB85","v":-8},{"$f":"BC85","v":2},{"$f":"BD85","v":-4},{"$f":"BE85","v":2}]
[null,null,null,{"$f":"\"Join up the points to show the \"&AG90&\" \"&AF79&AF80&AF81&AF82&\".\"","v":"Join up the points to show the parallelogram UVWX."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"rhombus",{"$f":"BF85","v":4},{"$f":"BG85","v":3},{"$f":"BH85","v":0},{"$f":"BI85","v":1},{"$f":"BJ85","v":4},{"$f":"BK85","v":-1},{"$f":"BL85","v":8},{"$f":"BM85","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"kite",{"$f":"BN85","v":5},{"$f":"BO85","v":5},{"$f":"BP85","v":2},{"$f":"BQ85","v":2},{"$f":"BR85","v":5},{"$f":"BS85","v":-4},{"$f":"BT85","v":8},{"$f":"BU85","v":2}]
[null,null,null,{"$f":"\"Write down the coordinates of the point \"&AF82&\".\"","v":"Write down the coordinates of the point X."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP($AF$84,$AF$85:$AF$89,AG85:AG89)","v":"parallelogram"},{"$f":"LOOKUP($AF$84,$AF$85:$AF$89,AH85:AH89)","v":-2},{"$f":"LOOKUP($AF$84,$AF$85:$AF$89,AI85:AI89)","v":6},-6,6,-8,2,-4,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TEXT(AN90,\"0\")","v":"-4"},{"$f":"TEXT(AO90,\"0\")","v":"2"}]
[null,null,null,"Coordinates = ",null,"(",null,",",null,")"]
[]
[]
[]
[]
[]
[]
[null,"Double check your work before submitting work"]

{"sheet":"Final_Exam","index":13,"n_rows":34,"n_cols":27,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,1,1,21],[4,3,4,7],[4,11,4,21]]}
[]
[null,"FINAL EXAM  National 4"]
[]
[]
[null,null,"  ","Paper 1",null,null,null,null,null,null,null,"Paper 2"]
[null,null,null,"Fraction of a Quanitity","Mean and Rounding","Percentage of a Quanitity","Basic Number - Mulitple","Basic Number - Add/ Sub",null,null,null,"Equations","Composite Area","Composite Area","Linear Patterns","Linear Patterns","Time Speed Distance","Pythagoras in Context","Pythagoras in Context","SOHCAHTOA in Context","Coordinates and Shape","Coordinates and Shape"]
[null,null,null,3,4,3,2,3,null,null,null,3,4,1,4,1,3,4,1,3,3,1]
[null,null,null,"R","R","R","R","R",null,null,null,"R","R","R","R","R","R","R","R","R","R","R"]
[null,"Firstname","Surname","Q1","Q2","Q3","Q4","Q5",null,"P1",null,"Q1","Q2","#","Q3","#","Q4","Q5","#","Q6","Q7","#",null,"P2","#","P1/P2","T#"]
[1,"Liam","Anderson",null,null,null,null,null,null,{"$f":"SUM(D10:H10)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L10:M10,O10,Q10,R10,T10,U10)","v":0},{"$f":"SUM(N10,P10,S10,V10)","v":0},{"$f":"X10+J10","v":0},{"$f":"Y10","v":0}]
[2,"Shaun","Bowers",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[3,"Jordan","Brownlie",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[4,"Joseph","Daly",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[5,"Jason","Dickie",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[6,"Euan","Docherty",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[7,"Lewis","Doherty",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[8,"Sophie-Lee","Elliott",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[9,"Jordan","Faleu",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[10,"Owen","Fyfe",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[11,"William","Gill",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[12,"Murray","Glen",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[13,"Kieron","Hagan",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[14,"Thomas","Hamilton",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[15,"Mark","Haswell",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[16,"Emma-Louise","Jones",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[18,"Marina","McDonald",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[19,"Ainslie","McLaren",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[20,"Megan","McLaren",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[21,"Brenden","McNamee",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[22,"Jack","McPake",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[23,"Emma","Quail",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[24,"Daniel","Rodgers",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[25,"Bethan","Rowan",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
[26,"Ryan","Thomson",null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]