{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Functions","IF function","Absolute Reference","Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Functions","index":0,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
["Total",{"$f":"Summary!B1","v":0},"Out of ",{"$f":"N1","v":10},null,null,null,null,null,null,{"$f":"SUM(K3:K19)","v":0},null,null,{"$f":"SUM(N3:N20)","v":10}]
[null,"Hours of Sunlight"]
[{"$f":"IF(C3>50,\"Historical Data\",\"\")","v":"Historical Data"},"Brighton",90,null,"Average",null,null,{"$f":"IF(LEFT(FormulaText(G3),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G3=(AVERAGE(C$3:C$22)),\"Correct Value\",\"\")","v":""},null,{"$f":"IF(AND(H3=\"You used Formula\",I3=\"Correct Value\"),1,0)","v":0},{"$f":"FormulaText(G3)","v":""},null,1]
[null,"Eastboune",{"$f":"C3*1.03","v":92.7},null,"Minimum",null,null,{"$f":"IF(LEFT(FormulaText(G4),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G4=(MIN(C$3:C$22)),\"Correct Value\",\"\")","v":""},null,{"$f":"IF(AND(H4=\"You used Formula\",I4=\"Correct Value\"),1,0)","v":0},{"$f":"FormulaText(G4)","v":""},null,1]
[null,"Littlehampton",{"$f":"C4*1.03","v":95.481000000000009},null,"Maximum",null,null,{"$f":"IF(LEFT(FormulaText(G5),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G5=(MAX(C$3:C$22)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G5)","v":""},null,1]
[null,"Bognor",98.345430000000007,null,"No. of Data points",null,null,{"$f":"IF(LEFT(FormulaText(G6),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G6=(COUNT(C$3:C$22)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G6)","v":""},null,1]
[{"$f":"IF(C7>50,\"Historical Data\",\"\")","v":"Historical Data"},"Bournmouth",101.29579290000001,null,null,null,null,null,null,null,null,{"$f":"FormulaText(G7)","v":""}]
[null,"Tynemouth",104.33466668700001,null,"UK Average",null,null,{"$f":"IF(LEFT(FormulaText(G8),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G8=(AVERAGE(C$3:C$19)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G8)","v":""},null,0.5]
[{"$f":"IF(C9>50,\"Historical Data\",\"\")","v":"Historical Data"},"Bridlington",107.46470668761002,null,"UK Minimum",null,null,{"$f":"IF(LEFT(FormulaText(G9),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G9=(MIN(C$3:C$19)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G9)","v":""},null,0.5]
[null,"Scarborough",110.68864788823832,null,"UK Maximum",null,null,{"$f":"IF(LEFT(FormulaText(G10),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G10=(MAX(C$3:C$19)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G10)","v":""},null,1]
[{"$f":"IF(C11>50,\"Historical Data\",\"\")","v":"Historical Data"},"Nuneton",114.00930732488547,null,"UK No. of Data points",null,null,{"$f":"IF(LEFT(FormulaText(G11),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G11=(COUNT(C$3:C$19)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G11)","v":""},null,1]
[null,"Wellingborough",117.42958654463203]
[null,"Market Harborough",120.95247414097099,null,"Int. Average",null,null,{"$f":"IF(LEFT(FormulaText(G13),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G13=(AVERAGE(C$20:C$22)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G13)","v":""},null,0.5]
["Historical Data","London",124.58104836520012,null,"Int. Minimum",null,null,{"$f":"IF(LEFT(FormulaText(G14),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G14=(MIN(C$20:C$22)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G14)","v":""},null,0.5]
["Historical Data","Crawley",128.31847981615613,null,"Int. Maximum",null,null,{"$f":"IF(LEFT(FormulaText(G15),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G15=(MAX(C$20:C$22)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G15)","v":""},null,0.5]
[null,"Canary Warf",132.16803421064083,null,"Int. No. of Data points",null,null,{"$f":"IF(LEFT(FormulaText(G16),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G16=(COUNT(C$20:C$22)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G16)","v":""},null,0.5]
[{"$f":"IF(C17>50,\"Historical Data\",\"\")","v":"Historical Data"},"Southend",136.13307523696005,null,null,null,null,null,null,null,null,{"$f":"FormulaText(G17)","v":""}]
["Historical Data","Hampton Court",100,null,"No Of Historical Data",null,null,{"$f":"IF(LEFT(FormulaText(G18),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G18=(COUNTA(A$3:A$22)),\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G18)","v":""},null,1]
[null,"Ditchling",63]
[null,"Malaga",{"$f":"C5*1.8","v":171.86580000000001}]
[{"$f":"IF(C21>50,\"Historical Data\",\"\")","v":"Historical Data"},"Abudabi",{"$f":"C3*2","v":180}]
[null,"Nantucket",{"$f":"C5*0.05","v":4.7740500000000008}]

{"sheet":"IF function","index":1,"n_rows":21,"n_cols":14,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Total",{"$f":"Summary!B1","v":0},"Out of ",{"$f":"N1","v":10},null,null,null,null,null,null,{"$f":"SUM(K3:K22)","v":0},null,null,{"$f":"SUM(N3:N22)","v":10}]
["Are they eating 5 a day?",null,null,"Name","No. of Fruit & Veg",null,"5 a Day? Yes/No"]
[null,"yes",36,"Sue",{"$f":"ROUND(C$9/10,1)","v":3.6},null,null,{"$f":"IF(LEFT(FormulaText(G3),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},{"$f":"IF(IF(E3<5,\"no\",\"yes\")=G3,\"Correct Value\",\"\")","v":""},null,{"$f":"IF(AND(H3=\"You used Formula\",I3=\"Correct Value\"),N3,0)","v":0},{"$f":"FormulaText(G3)","v":""},null,1]
[null,"no",null,"Sean",{"$f":"ROUND(C$9/20,1)","v":1.8},null,null,{"$f":"IF(LEFT(FormulaText(G4),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},{"$f":"IF(IF(E4<5,\"no\",\"yes\")=G4,\"Correct Value\",\"\")","v":""},null,{"$f":"IF(AND(H4=\"You used Formula\",I4=\"Correct Value\"),N4,0)","v":0},{"$f":"FormulaText(G4)","v":""},null,1]
[null,null,null,"Rebecca",{"$f":"ROUND(C$9/9,1)","v":4},null,null,{"$f":"IF(LEFT(FormulaText(G5),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},"",null,0,{"$f":"FormulaText(G5)","v":""},null,0.5]
[null,null,null,"Steve",{"$f":"ROUND(C$9/12,1)","v":3},null,null,{"$f":"IF(LEFT(FormulaText(G6),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},"",null,0,{"$f":"FormulaText(G6)","v":""},null,0.5]
["Did they pass their exams?",null,null,null,null,null,null,null,{"$f":"IF(G7=$B$3,\"Correct Value\",\"\")","v":""},null,null,{"$f":"FormulaText(G7)","v":""}]
[null,null,"Pass Mark","Name","Exam Marks",null,"Pass/Fail",null,{"$f":"IF(G8=$B$3,\"Correct Value\",\"\")","v":""}]
[null,"Pass",{"$f":"C3","v":36},"Paul",{"$f":"C9+1","v":37},null,null,{"$f":"IF(LEFT(FormulaText(G9),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},{"$f":"IF(IF(E9>C$9,\"Pass\",\"Fail\")=G9,\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G9)","v":""},null,1]
[null,"Fail",null,"John",{"$f":"E9+4","v":41},null,null,{"$f":"IF(LEFT(FormulaText(G10),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},{"$f":"IF(IF(E10>C$9,\"Pass\",\"Fail\")=G10,\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G10)","v":""},null,0.5]
[null,null,null,"George",{"$f":"C$9-6","v":30},null,null,{"$f":"IF(LEFT(FormulaText(G11),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},"",null,0,{"$f":"FormulaText(G11)","v":""},null,0.5]
[null,null,null,"Ringo",{"$f":"E11-6","v":24},null,null,{"$f":"IF(LEFT(FormulaText(G12),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},"",null,0,{"$f":"FormulaText(G12)","v":""},null,0.5]
[]
[]
["Extension Task: (nested IF)"]
["\"Traffic Light\" the following students",null,null,"Name","Exam Marks",null,"Green/ Amber/Red"]
[null,"Red if less than",30,"Paul",{"$f":"E9","v":37},null,null,{"$f":"IF(LEFT(FormulaText(G17),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},{"$f":"IF(IF(E17<C$17,\"Red\",IF(E17<C$18,\"Amber\",\"Green\"))=G17,\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G17)","v":""},null,2]
[null,"Amber if less than",50,"John",{"$f":"E10","v":41},null,null,{"$f":"IF(LEFT(FormulaText(G18),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},{"$f":"IF(IF(E18<C$17,\"Red\",IF(E18<C$18,\"Amber\",\"Green\"))=G18,\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G18)","v":""},null,1]
[null,"Green if more than",50,"George",30,null,null,{"$f":"IF(LEFT(FormulaText(G19),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},"",null,0,{"$f":"FormulaText(G19)","v":""},null,1]
[null,null,null,"Ringo",24,null,null,{"$f":"IF(LEFT(FormulaText(G20),1)=\"=\",\"You used Formula\",\"<- Write a Formula HERE !\")","v":"<- Write a Formula HERE !"},"",null,0,{"$f":"FormulaText(G20)","v":""},null,0.5]
[null,null,null,null,null,null,null,null,{"$f":"IF(G21>=C$9,\"Correct Value\",\"\")","v":""},null,0,{"$f":"FormulaText(G21)","v":""}]

{"sheet":"Absolute Reference","index":2,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Total",{"$f":"Summary!B1","v":0},"Out of ",{"$f":"N1","v":10},null,null,null,null,null,null,{"$f":"SUM(K3:K18)","v":0},null,null,{"$f":"SUM(N3:N19)","v":10}]
["Calculate the Subtotal and VAT for each of the following items",null,null,null,null,null,null,null,"VAT RATE ->",{"$f":"IF(C3>60,0.2,0.175)","v":0.2}]
[null,null,81,"Price","Quantity","Subtotal","VAT"]
[null,"Lentils",null,1.55,{"$f":"E11","v":11},null,null,{"$f":"IF(LEFT(FormulaText(G4),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G4=(D4*E4*J$2),\"Correct Value\",\"\")","v":""},null,{"$f":"IF(AND(H4=\"You used Formula\",I4=\"Correct Value\"),N4,0)","v":0},{"$f":"FormulaText(G4)","v":""},null,1]
[null,"Kidney Beans",null,{"$f":"D4*1.03","v":1.5965},3,null,null,{"$f":"IF(LEFT(FormulaText(G5),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(G5=(D5*E5*J$2),\"Correct Value\",\"\")","v":""},null,{"$f":"IF(AND(H5=\"You used Formula\",I5=\"Correct Value\"),N5,0)","v":0},{"$f":"FormulaText(G5)","v":""},null,2]
[null,"Chick Peas",null,1.6443950000000001,{"$f":"E4-2","v":9},null,null,{"$f":"IF(LEFT(FormulaText(G6),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},"",null,0,{"$f":"FormulaText(G6)","v":""},null,1]
[null,"Rosocco Beans",null,1.69372685,{"$f":"E4*3","v":33},null,null,{"$f":"IF(LEFT(FormulaText(G7),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},"",null,0,{"$f":"FormulaText(G7)","v":""},null,1]
[null,"Magic Beans",null,1.7445386555,4,null,null,{"$f":"IF(LEFT(FormulaText(G8),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},"",null,0,{"$f":"FormulaText(G8)","v":""},null,1]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"FormulaText(G9)","v":""}]
[null,null,"Network",null,"Students on Network",null,"% of Students on Network",null,null,null,null,{"$f":"FormulaText(G10)","v":"% of Students on Network"}]
[null,null,"02",null,{"$f":"MOD(C3,14)","v":11},null,null,{"$f":"IF(LEFT(FormulaText(G11),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(E$17=\"\",\"\",IF(G11=(E11/E$17),\"Correct Value\",\"\"))","v":""},null,{"$f":"IF(AND(H11=\"You used Formula\",I11=\"Correct Value\"),N11,0)","v":0},{"$f":"FormulaText(G11)","v":""},null,1]
[null,null,"Vodafone",null,8,null,null,{"$f":"IF(LEFT(FormulaText(G12),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},"",null,0,{"$f":"FormulaText(G12)","v":""},null,0.5]
[null,null,"Orange",null,3,null,null,{"$f":"IF(LEFT(FormulaText(G13),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},"",null,0,{"$f":"FormulaText(G13)","v":""},null,0.5]
[null,null,"EE",null,5,null,null,{"$f":"IF(LEFT(FormulaText(G14),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},"",null,0,{"$f":"FormulaText(G14)","v":""},null,0.5]
[null,null,"T-Mobile",null,2,null,null,{"$f":"IF(LEFT(FormulaText(G15),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},"",null,0,{"$f":"FormulaText(G15)","v":""},null,0.5]
[null,null,"Other",null,5,null,null,{"$f":"IF(LEFT(FormulaText(G16),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},"",null,0,{"$f":"FormulaText(G16)","v":""},null,0.5]
[null,null,"TOTAL",null,null,null,null,{"$f":"IF(LEFT(FormulaText(E17),1)=\"=\",\"You used Formula\",\"Write a Formula !\")","v":"Write a Formula !"},{"$f":"IF(E17=SUM(E11:E16),\"Correct Value\",\"\")","v":""},null,0,null,null,0.5]

{"sheet":"Summary","index":3,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Total",{"$f":"SUM(B3:B28)","v":0},{"$f":"SUM(C3:C28)","v":30}]
[]
["Vocab"]
["Shopping List"]
["Basic Formula"]
["Functions",{"$f":"Functions!K1","v":0},{"$f":"Functions!N1","v":10}]
["IF Functions",{"$f":"'IF function'!K1","v":0},{"$f":"'IF function'!N1","v":10}]
["Absolute Reference",{"$f":"'Absolute Reference'!K1","v":0},{"$f":"'Absolute Reference'!N1","v":10}]