{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["invoice  with drop down menu","category","vLookup","pivot table and grouping","data","typing macro","reorder column macro","nested if function"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":1},"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":"invoice  with drop down menu","index":0,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[[12,6,12,7],[12,1,12,4]]}
["Glen Cove Company"]
["1 First Drive",null,null,null,null,null,null,"INVOICE NUMBER:",455]
["Glen Cove NY 11542",null,null,null,null,null,null,"Date:","2014-03-15T10:53:00"]
[]
[]
["sold to:",null,null,null,null,null,"ship to:"]
["Company Name:",null,"Merrick Company",null,null,null,"Company Name:",null,{"$f":"C7","v":"Merrick Company"}]
["Address:",null,"Ten Education Drive",null,null,null,"Address:",null,{"$f":"C8","v":"Ten Education Drive"}]
["Telephone:",null,"516-123-4567",null,null,null,"Telephone:",null,{"$f":"C9","v":"516-123-4567"}]
["E-mail Address:",null,"sample e-mail@yahoo.com",null,null,null,"E-mail Address:",null,{"$f":"C10","v":"sample e-mail@yahoo.com"}]
[]
[]
["Qty.","Item Description",null,null,null,"category","Unit Price",null,"Amount"]
[200,"Widgets",null,null,null,"Produce",10,null,{"$f":"A14*G14","v":2000}]
[200,"Cupcakes",null,null,null,"Snacks",4,null,{"$f":"A15*G15","v":800}]
[200,"Gallons of milk",null,null,null,"Dairy",5.59,null,1118]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,"Subtotal",null,{"$f":"SUM(I14:I35)","v":3918}]
[null,null,null,null,null,null,"Sales Tax",8.2500000000000004E-2,{"$f":"I37*H38","v":323.23500000000001}]
[null,null,null,null,null,null,"Shipping and Handling",null,35]
[null,null,null,null,null,null,"Total Due",null,{"$f":"SUM(I37:I39)","v":4276.2349999999997}]

{"sheet":"category","index":1,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Dairy"]
["Produce"]
["Meat"]
["Bakery"]
["Deli"]
["Supplies"]
["Pet food"]
["Snacks"]

{"sheet":"vLookup","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"Traffic Light","Action"]
[null,null,"red","stop"]
[null,null,"yellow","slow down"]
[null,null,"green","go"]
[]
[]
[]
[null,null,"red",{"$f":"VLOOKUP(C8,TrafficLightTable,2,0)","v":"stop"}]
[null,null,"green",{"$f":"VLOOKUP(C9,TrafficLightTable,2,0)","v":"go"}]
[null,null,"green",{"$f":"VLOOKUP(C10,TrafficLightTable,2,0)","v":"go"}]
[]
[]
[null,null,null,{"$f":"Totaldue","v":4276.2349999999997}]

{"sheet":"pivot table and grouping","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Day1","Column Labels"]
["Row Labels","0-59","60-119","240-299","Grand Total"]
["clothing",null,75,290,365]
["food",85,null,null,85]
["supplies",0,null,null,0]
["transportation",25,70,null,95]
["Grand Total",110,145,290,545]

{"sheet":"data","index":4,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Item","categories","Day1","Day 2"]
["groceries","food",50,{"$f":"C2*2","v":100}]
["shirt","clothing",75,{"$f":"C3*2","v":150}]
["gas","transportation",25,50]
["pen","supplies",0,0]
["scooter","transportation",70,140]
["shoes","clothing",290,580]
["groceries","food",35,70]

{"sheet":"typing macro","index":5,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,1,2,3,4,{"$f":"NOW()","v":"2014-03-21T10:08:56"},"we recorded a macro with relative references on!"]
[null,null,null,1,2,3,4,{"$f":"NOW()","v":"2014-03-21T10:08:56"},"we recorded a macro with relative references on!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,1,2,3,4,{"$f":"NOW()","v":"2014-03-21T10:08:56"},"we recorded a macro with relative references on!"]

{"sheet":"reorder column macro","index":6,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["a","b","c","d","e"]

{"sheet":"nested if function","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Player","Home Runs","Batting Average","Result"]
["John",4,0.2,{"$f":"IF(B2>=15,IF(C2>0.3,\"Home Run Batter and Good Batting Average\",\"Good home run batter\"),IF(C2>0.3,\"Good batting average\",\"Needs improvement\"))","v":"Needs improvement"}]
["Jim",16,0.25,{"$f":"IF(B3>=15,IF(C3>0.3,\"Home Run Batter and Good Batting Average\",\"Good home run batter\"),IF(C3>0.3,\"Good batting average\",\"Needs improvement\"))","v":"Good home run batter"}]
["Pat",5,0.35,"Good batting average"]
["Greg",25,0.35,"Home Run Batter and Good Batting Average"]
["Mike",30,0.4,"Home Run Batter and Good Batting Average"]
["Chris",10,0.2,"Needs improvement"]
["Frank",15,0.25,"Good home run batter"]
["Andrew",20,0.3,"Good home run batter"]
["Jim",25,0.35,"Home Run Batter and Good Batting Average"]
["Alberto",30,0.4,"Home Run Batter and Good Batting Average"]