{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Start","Formulas","Functions","Autofill","Conditional Formatting","Validation","Modelling"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
["Year 7"]
["Spreadsheets Test"]
[]
[]
[null,"Name:"]
[null,"Form:"]

{"sheet":"Formulas","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4],[6,1,6,4],[11,1,11,4]]}
[]
[null,"Dice"]
[null,"Throw","Dice 1","Dice 2","Total"]
[null,"One",4,6]
[null,"Two",3,3]
[]
[null,"Pocket Money"]
[null,"Name","Pocket Money","Money Spent","Money Left"]
[null,"John",11.5,3.57]
[null,"Tracy",18,14.88]
[]
[null,"Sweets"]
[null,"Sweets","Number of Sweets","Number of Friends","Sweets each"]
[null,"Skittles",72,6]
[null,"Cola Bottles",135,15]
[]
[null,"Bob's Windows"]
[null,"Window","Width (Cm)","Length (Cm)","Area (Cm2)"]
[null,"Small",12,18]
[null,"Large",20,28]

{"sheet":"Functions","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,0,0,10]]}
["Joe's Musix Shop"]
["SALES FOR 2016"]
["PRODUCT","JAN","FEB","MAR","APR","MAY","JUN","TOTAL","AVERAGE","LOWEST","HIGHEST"]
["TICKETS",160,280,400,120,220,340]
["CD",450,550,600,600,720,150]
["T SHIRTS",52,78,54,43,72,83]
["HEADPHONES",34,56,78,66,52,89]
["PHONE CASES",129,143,134,115,126,113]

{"sheet":"Autofill","index":3,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["PRODUCT","JAN","FEB","MAR","APR","MAY","JUN","TOTAL",null,null,null,null,null,null,null,"Type your answer A, B, C or D in the box below"]
["TICKETS",160,280,400,120,220,340,{"$f":"SUM(B4:G4)","v":1520}]
["CD",450,550,600,600,720,150]
["T SHIRTS",52,78,54,43,72,83]
["HEADPHONES",34,56,78,66,52,89]
["PHONE CASES",129,143,134,115,126,113]

{"sheet":"Conditional Formatting","index":4,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Holmfirth High Survey"]
[]
["Name\n(initials)","Age\n(Yrs)","Gender\n(M or F)","Height\n(Cm)","Shoe Size","Favourite Colour","Favourite sport to play"]
["AF",12,"M",155,6,"LIME","FOOTBALL"]
["AJP",13,"F",180,8,"BLUE","BASKETBALL"]
["CY",12,"F",154,5.5,"BLUE","NETBALL"]
["DJB",12,"M",163,6,"RED","FOOTBALL"]
["DG",13,"M",150,8,"RED","SKATING"]
["DK",13,"F",162,6,"BLUE","ROUNDERS"]
["DP",13,"M",165,8,"RED","FOOTBALL"]
["EAW",14,"F",170,5.5,"YELLOW","ROUNDERS"]
["EH",13,"F",150,5,"LIME GREEN","ROUNDERS"]
["FB",11,"F",144,4,"ORANGE","NETBALL"]
["GM",13,"F",151,4,"BLUE","SWIMMING"]
["GS",12,"F",154,4,"GREEN","HORSE RIDING"]
["HW",12,"F",147,3.5,"ORANGE","NETBALL"]
["IB",13,"M",157,8,"RED","CRICKET"]
["JLE",12,"F",160,5,"BLUE","NETBALL"]
["KRG",12,"F",154,4,"ORANGE","GYMNASTICS"]
["KS",11,"F",149,4.5,"BLUE","SWIMMING"]
["LA",13,"F",160,7,"PURPLE","BADMINTON"]
["LP",14,"F",161,7,"YELLOW","HOCKEY"]
["MC",11,"M",150,6,"BLUE ","FOOTBALL"]
["NC",13,"F",170,8,"LILAC","BASKETBALL"]
["PB",11,"M",153,5,"RED","CRICKET"]
["PW",13,"M",149,8,"BLUE","POOL"]
["RA",13,"M",165,7,"PURPLE","TENNIS"]
["RP",13,"M",150,4.5,"PURPLE","ROUNDERS"]
["SA",13,"M",150,6,"BLUE","CRICKET"]
["SSF",14,"M",145,5,"RED","FOOTBALL"]
["TC",14,"M",185,11,"SILVER","BASKETBALL"]
["VW",11,"F",149,6,"BLUE","SWIMMING"]
["ZM",14,"F",152,4,"BLACK","ROUNDERS"]

{"sheet":"Validation","index":5,"n_rows":8,"n_cols":15,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Name","Gender","Shoe Size","Village",null,null,null,null,null,null,null,null,null,null,"Netherthong"]
["Dave",null,null,null,null,null,null,null,null,null,null,null,null,null,"Upperthong"]
["Billy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Thongsbridege"]
["Sue",null,null,null,null,null,null,null,null,null,null,null,null,null,"Honley"]
["Jennifer",null,null,null,null,null,null,null,null,null,null,null,null,null,"Meltham"]
["Amy",null,null,null,null,null,null,null,null,null,null,null,null,null,"Netherton"]

{"sheet":"Modelling","index":6,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Holmfirth Charity Ball"]
[]
["Income"]
["Price per ticket",4.5]
["Number of tickets sold",100]
["Total Income"]
[]
["Costs"]
["Total Food cost",{"$f":"B5*2.5","v":250}]
["DJ hire",75]
["Hall hire",125]
["Band hire",150]
["Staff (waiters and bar staff)",65]
["Total Costs"]
[]
[]
["Profit/Loss"]