{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["bar chart","macro sample","macro move and delete columns","macro move and delete 2","vLookup example","vlookup sales","running schedule macro"],"not_rendered":{"charts":2,"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":"bar chart","index":0,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["item","day 1","day 2","total\nschool trip"]
["groceries",50,60,{"$f":"SUM(B2:C2)","v":110}]
["shirt",75,80,{"$f":"SUM(B3:C3)","v":155}]
["gas",25,30,55]
["pen",0,5,5]
["scooter",70,70,140]
["shoes",290,100,390]
["groceries",35,45,80]

{"sheet":"macro sample","index":1,"n_rows":39,"n_cols":7,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2014-03-25T20:37:43.140"},"We recorded a macro with relative references on!"]

{"sheet":"macro move and delete columns","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]

{"sheet":"macro move and delete 2","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]
["a","b","c","f"]

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

{"sheet":"vlookup sales","index":5,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Data"]
[]
[null,"model number","shoes","retail price","wholesale price"]
[null,"1234a","nike",119,29]
[null,"456B","new balance",149,39]
[null,"789c","adidas",129,49]
[]
["Sales"]
["model","make","retail price","wholesale"]
["1234a",{"$f":"VLOOKUP(A10,ShoeSales,2,FALSE)","v":"nike"},{"$f":"VLOOKUP(A10,ShoeSales,3,0)","v":119},{"$f":"VLOOKUP(A10,ShoeSales,4,0)","v":29}]
["1234a",{"$f":"VLOOKUP(A11,ShoeSales,2,FALSE)","v":"nike"},{"$f":"VLOOKUP(A11,ShoeSales,3,0)","v":119},{"$f":"VLOOKUP(A11,ShoeSales,4,0)","v":29}]
["789c",{"$f":"VLOOKUP(A12,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A12,ShoeSales,3,0)","v":129},{"$f":"VLOOKUP(A12,ShoeSales,4,0)","v":49}]
["1234a",{"$f":"VLOOKUP(A13,ShoeSales,2,FALSE)","v":"nike"},{"$f":"VLOOKUP(A13,ShoeSales,3,0)","v":119},{"$f":"VLOOKUP(A13,ShoeSales,4,0)","v":29}]
["1234a",{"$f":"VLOOKUP(A14,ShoeSales,2,FALSE)","v":"nike"},{"$f":"VLOOKUP(A14,ShoeSales,3,0)","v":119},{"$f":"VLOOKUP(A14,ShoeSales,4,0)","v":29}]
["789c",{"$f":"VLOOKUP(A15,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A15,ShoeSales,3,0)","v":129},{"$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":149},{"$f":"VLOOKUP(A16,ShoeSales,4,0)","v":39}]
["456b",{"$f":"VLOOKUP(A17,ShoeSales,2,FALSE)","v":"new balance"},{"$f":"VLOOKUP(A17,ShoeSales,3,0)","v":149},{"$f":"VLOOKUP(A17,ShoeSales,4,0)","v":39}]
["789c",{"$f":"VLOOKUP(A18,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A18,ShoeSales,3,0)","v":129},{"$f":"VLOOKUP(A18,ShoeSales,4,0)","v":49}]
["789c",{"$f":"VLOOKUP(A19,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A19,ShoeSales,3,0)","v":129},{"$f":"VLOOKUP(A19,ShoeSales,4,0)","v":49}]
["789c",{"$f":"VLOOKUP(A20,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A20,ShoeSales,3,0)","v":129},{"$f":"VLOOKUP(A20,ShoeSales,4,0)","v":49}]
["789c",{"$f":"VLOOKUP(A21,ShoeSales,2,FALSE)","v":"adidas"},{"$f":"VLOOKUP(A21,ShoeSales,3,0)","v":129},{"$f":"VLOOKUP(A21,ShoeSales,4,0)","v":49}]
[]
[null,null,{"$f":"SUM(C10:C22)","v":1548},{"$f":"SUM(D10:D22)","v":488},{"$f":"C23-D23","v":1060}]

{"sheet":"running schedule macro","index":6,"n_rows":203,"n_cols":8,"rows_kept":203,"cut":false,"hidden":false,"merged":[]}
[null,"2014-03-23",{"$f":"B1+1","v":"2014-03-24"},{"$f":"C1+1","v":"2014-03-25"},{"$f":"D1+1","v":"2014-03-26"},{"$f":"E1+1","v":"2014-03-27"},{"$f":"F1+1","v":"2014-03-28"},{"$f":"G1+1","v":"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"},{"$f":"D11+1","v":"2014-03-26"},{"$f":"E11+1","v":"2014-03-27"},{"$f":"F11+1","v":"2014-03-28"},{"$f":"G11+1","v":"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"},{"$f":"D30+1","v":"2014-03-26"},{"$f":"E30+1","v":"2014-03-27"},{"$f":"F30+1","v":"2014-03-28"},{"$f":"G30+1","v":"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"},{"$f":"D50+1","v":"2014-03-26"},{"$f":"E50+1","v":"2014-03-27"},{"$f":"F50+1","v":"2014-03-28"},{"$f":"G50+1","v":"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"},{"$f":"D64+1","v":"2014-03-26"},{"$f":"E64+1","v":"2014-03-27"},{"$f":"F64+1","v":"2014-03-28"},{"$f":"G64+1","v":"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"},{"$f":"D80+1","v":"2014-03-26"},{"$f":"E80+1","v":"2014-03-27"},{"$f":"F80+1","v":"2014-03-28"},{"$f":"G80+1","v":"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":"B100+1","v":"2014-03-24"},{"$f":"C100+1","v":"2014-03-25"},{"$f":"D100+1","v":"2014-03-26"},{"$f":"E100+1","v":"2014-03-27"},{"$f":"F100+1","v":"2014-03-28"},{"$f":"G100+1","v":"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":"B120+1","v":"2014-03-24"},{"$f":"C120+1","v":"2014-03-25"},{"$f":"D120+1","v":"2014-03-26"},{"$f":"E120+1","v":"2014-03-27"},{"$f":"F120+1","v":"2014-03-28"},{"$f":"G120+1","v":"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":"B138+1","v":"2014-03-24"},{"$f":"C138+1","v":"2014-03-25"},{"$f":"D138+1","v":"2014-03-26"},{"$f":"E138+1","v":"2014-03-27"},{"$f":"F138+1","v":"2014-03-28"},{"$f":"G138+1","v":"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":"B156+1","v":"2014-03-24"},{"$f":"C156+1","v":"2014-03-25"},{"$f":"D156+1","v":"2014-03-26"},{"$f":"E156+1","v":"2014-03-27"},{"$f":"F156+1","v":"2014-03-28"},{"$f":"G156+1","v":"2014-03-29"}]
[null,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["running"]
["elliptical"]
["treadmill"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"weight"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2014-03-30",{"$f":"B180+1","v":"2014-03-31"},{"$f":"C180+1","v":"2014-04-01"},{"$f":"D180+1","v":"2014-04-02"},{"$f":"E180+1","v":"2014-04-03"},{"$f":"F180+1","v":"2014-04-04"},{"$f":"G180+1","v":"2014-04-05"}]
[null,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["running"]
["elliptical"]
["treadmill"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"weight"]
[]
[]
[null,"2014-04-06",{"$f":"B193+1","v":"2014-04-07"},{"$f":"C193+1","v":"2014-04-08"},{"$f":"D193+1","v":"2014-04-09"},{"$f":"E193+1","v":"2014-04-10"},{"$f":"F193+1","v":"2014-04-11"},{"$f":"G193+1","v":"2014-04-12"}]
[null,"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"]
["running"]
["elliptical"]
["treadmill"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"weight"]