{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["vlookup","vlookup sales","running schedule macro"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"vlookup","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,null,"traffic light","action","fine"]
[null,null,"red","stop",60]
[null,null,"orange","slow down",40]
[null,null,"green","go",0]
[]
[]
[null,null,"value ","vlookup function"]
[null,null,"green",{"$f":"VLOOKUP(C8,TrafficLightTable,3,0)","v":0}]

{"sheet":"vlookup sales","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Data"]
["model number","shoes","retail price","wholesale price"]
["1234a","nike",99,49]
["456B","new balance",89,59]
["789c","adidas",109,49]
[]
[]
["Sales"]
["model","make","retail price","wholesale"]
["789c",{"$f":"VLOOKUP(A10,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A10,ShoeSales,3,0)","v":109},{"$f":"VLOOKUP(A10,ShoeSales,4,0)","v":49}]
["1234a",{"$f":"VLOOKUP(A11,ShoeSales,2,FALSE)","v":"nike"},{"$f":"VLOOKUP(A11,ShoeSales,3,0)","v":99},{"$f":"VLOOKUP(A11,ShoeSales,4,0)","v":49}]
["789c",{"$f":"VLOOKUP(A12,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A12,ShoeSales,3,0)","v":109},{"$f":"VLOOKUP(A12,ShoeSales,4,0)","v":49}]
["1234a",{"$f":"VLOOKUP(A13,ShoeSales,2,FALSE)","v":"nike"},{"$f":"VLOOKUP(A13,ShoeSales,3,0)","v":99},{"$f":"VLOOKUP(A13,ShoeSales,4,0)","v":49}]
["1234a",{"$f":"VLOOKUP(A14,ShoeSales,2,FALSE)","v":"nike"},{"$f":"VLOOKUP(A14,ShoeSales,3,0)","v":99},{"$f":"VLOOKUP(A14,ShoeSales,4,0)","v":49}]
["789c",{"$f":"VLOOKUP(A15,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A15,ShoeSales,3,0)","v":109},{"$f":"VLOOKUP(A15,ShoeSales,4,0)","v":49}]
["456b",{"$f":"VLOOKUP(A16,ShoeSales,2,FALSE)","v":"new balance"},{"$f":"VLOOKUP(A16,ShoeSales,3,0)","v":89},{"$f":"VLOOKUP(A16,ShoeSales,4,0)","v":59}]
["456b",{"$f":"VLOOKUP(A17,ShoeSales,2,FALSE)","v":"new balance"},{"$f":"VLOOKUP(A17,ShoeSales,3,0)","v":89},{"$f":"VLOOKUP(A17,ShoeSales,4,0)","v":59}]
["789c",{"$f":"VLOOKUP(A18,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A18,ShoeSales,3,0)","v":109},{"$f":"VLOOKUP(A18,ShoeSales,4,0)","v":49}]
["789c",{"$f":"VLOOKUP(A19,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A19,ShoeSales,3,0)","v":109},{"$f":"VLOOKUP(A19,ShoeSales,4,0)","v":49}]
["789c",{"$f":"VLOOKUP(A20,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A20,ShoeSales,3,0)","v":109},{"$f":"VLOOKUP(A20,ShoeSales,4,0)","v":49}]
["789c",{"$f":"VLOOKUP(A21,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A21,ShoeSales,3,0)","v":109},{"$f":"VLOOKUP(A21,ShoeSales,4,0)","v":49}]
[]
[null,null,{"$f":"SUM(C10:C22)","v":1238},{"$f":"SUM(D10:D22)","v":608},{"$f":"C23-D23","v":630}]

{"sheet":"running schedule macro","index":2,"n_rows":90,"n_cols":8,"rows_kept":90,"cut":false,"hidden":false,"merged":[]}
[null,"2014-03-23",{"$f":"B1+1","v":"2014-03-24"},{"$f":"C1+1","v":"2014-03-25"},"2014-03-26","2014-03-27","2014-03-28","2014-03-29"]
[null,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["running"]
["elliptical"]
["treadmill"]
[]
[null,null,null,null,null,null,"weight"]
[]
[]
[]
[null,"2014-03-23",{"$f":"B11+1","v":"2014-03-24"},{"$f":"C11+1","v":"2014-03-25"},"2014-03-26","2014-03-27","2014-03-28","2014-03-29"]
[null,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["running"]
["elliptical"]
["treadmill"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"weight"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2014-03-23",{"$f":"B30+1","v":"2014-03-24"},{"$f":"C30+1","v":"2014-03-25"},"2014-03-26","2014-03-27","2014-03-28","2014-03-29"]
[null,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["running"]
["elliptical"]
["treadmill"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"weight"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2014-03-23",{"$f":"B50+1","v":"2014-03-24"},{"$f":"C50+1","v":"2014-03-25"},"2014-03-26","2014-03-27","2014-03-28","2014-03-29"]
[null,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["running"]
["elliptical"]
["treadmill"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"weight"]
[]
[]
[]
[null,"2014-03-23",{"$f":"B64+1","v":"2014-03-24"},{"$f":"C64+1","v":"2014-03-25"},"2014-03-26","2014-03-27","2014-03-28","2014-03-29"]
[null,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["running"]
["elliptical"]
["treadmill"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"weight"]
[]
[]
[]
[]
[]
[null,"2014-03-23",{"$f":"B80+1","v":"2014-03-24"},{"$f":"C80+1","v":"2014-03-25"},"2014-03-26","2014-03-27","2014-03-28","2014-03-29"]
[null,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["running"]
["elliptical"]
["treadmill"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"weight"]