{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["pivot table grouping","T Rates","Library","Sports","Car Maintenance","Pivot table before group","Movies","GE Stock","Vehicle Data","BBQ List","Commission","sample macro","move column macro before","move column macro before copy","move column macro"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":4},"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":"pivot table grouping","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Average of Interest Rates"]
["4/1/1971 - 3/28/1981",9.5408333333333353]
["3/29/1981 - 3/26/1991",12.199416666666675]
["3/27/1991 - 3/23/2001",7.850583333333331]
["3/24/2001 - 3/21/2011",5.9025833333333315]
["3/22/2011 - 4/2/2012",4.2007692307692306]
["Grand Total",8.7501419878296183]

{"sheet":"T Rates","index":1,"n_rows":494,"n_cols":6,"rows_kept":494,"cut":false,"hidden":false,"merged":[]}
["Month","month","year","date","Interest Rates","Year"]
["1971-04",{"$f":"RIGHT(A2,2)+0","v":4},{"$f":"LEFT(A2,4)+0","v":1971},{"$f":"DATE(C2,B2,1)","v":"1971-04-01"},7.31,1971]
["1971-05",5,1971,"1971-05-01",7.43,1971]
["1971-06",6,1971,"1971-06-01",7.53,1971]
["1971-07",7,1971,"1971-07-01",7.6,1971]
["1971-08",8,1971,"1971-08-01",7.7,1971]
["1971-09",9,1971,"1971-09-01",7.69,1971]
["1971-10",10,1971,"1971-10-01",7.63,1971]
["1971-11",11,1971,"1971-11-01",7.55,1971]
["1971-12",12,1971,"1971-12-01",7.48,1971]
["1972-01",1,1972,"1972-01-01",7.44,1972]
["1972-02",2,1972,"1972-02-01",7.33,1972]
["1972-03",3,1972,"1972-03-01",7.3,1972]
["1972-04",4,1972,"1972-04-01",7.29,1972]
["1972-05",5,1972,"1972-05-01",7.37,1972]
["1972-06",6,1972,"1972-06-01",7.37,1972]
["1972-07",7,1972,"1972-07-01",7.4,1972]
["1972-08",8,1972,"1972-08-01",7.4,1972]
["1972-09",9,1972,"1972-09-01",7.42,1972]
["1972-10",10,1972,"1972-10-01",7.42,1972]
["1972-11",11,1972,"1972-11-01",7.43,1972]
["1972-12",12,1972,"1972-12-01",7.44,1972]
["1973-01",1,1973,"1973-01-01",7.44,1973]
["1973-02",2,1973,"1973-02-01",7.44,1973]
["1973-03",3,1973,"1973-03-01",7.46,1973]
["1973-04",4,1973,"1973-04-01",7.54,1973]
["1973-05",5,1973,"1973-05-01",7.65,1973]
["1973-06",6,1973,"1973-06-01",7.73,1973]
["1973-07",7,1973,"1973-07-01",8.0500000000000007,1973]
["1973-08",8,1973,"1973-08-01",8.5,1973]
["1973-09",9,1973,"1973-09-01",8.82,1973]
["1973-10",10,1973,"1973-10-01",8.77,1973]
["1973-11",11,1973,"1973-11-01",8.58,1973]
["1973-12",12,1973,"1973-12-01",8.5399999999999991,1973]
["1974-01",1,1974,"1974-01-01",8.5399999999999991,1974]
["1974-02",2,1974,"1974-02-01",8.4600000000000009,1974]
["1974-03",3,1974,"1974-03-01",8.41,1974]
["1974-04",4,1974,"1974-04-01",8.58,1974]
["1974-05",5,1974,"1974-05-01",8.9700000000000006,1974]
["1974-06",6,1974,"1974-06-01",9.09,1974]
["1974-07",7,1974,"1974-07-01",9.2799999999999994,1974]
["1974-08",8,1974,"1974-08-01",9.59,1974]
["1974-09",9,1974,"1974-09-01",9.9600000000000009,1974]
["1974-10",10,1974,"1974-10-01",9.98,1974]
["1974-11",11,1974,"1974-11-01",9.7899999999999991,1974]
["1974-12",12,1974,"1974-12-01",9.6199999999999992,1974]
["1975-01",1,1975,"1975-01-01",9.43,1975]
["1975-02",2,1975,"1975-02-01",9.11,1975]
["1975-03",3,1975,"1975-03-01",8.9,1975]
["1975-04",4,1975,"1975-04-01",8.82,1975]
["1975-05",5,1975,"1975-05-01",8.91,1975]
["1975-06",6,1975,"1975-06-01",8.89,1975]
["1975-07",7,1975,"1975-07-01",8.89,1975]
["1975-08",8,1975,"1975-08-01",8.94,1975]
["1975-09",9,1975,"1975-09-01",9.1300000000000008,1975]
["1975-10",10,1975,"1975-10-01",9.2200000000000006,1975]
["1975-11",11,1975,"1975-11-01",9.15,1975]
["1975-12",12,1975,"1975-12-01",9.1,1975]
["1976-01",1,1976,"1976-01-01",9.02,1976]
["1976-02",2,1976,"1976-02-01",8.81,1976]
["1976-03",3,1976,"1976-03-01",8.76,1976]
["1976-04",4,1976,"1976-04-01",8.73,1976]
["1976-05",5,1976,"1976-05-01",8.77,1976]
["1976-06",6,1976,"1976-06-01",8.85,1976]
["1976-07",7,1976,"1976-07-01",8.93,1976]
["1976-08",{"$f":"RIGHT(A66,2)+0","v":8},{"$f":"LEFT(A66,4)+0","v":1976},{"$f":"DATE(C66,B66,1)","v":"1976-08-01"},9,1976]
["1976-09",9,1976,"1976-09-01",8.98,1976]
["1976-10",10,1976,"1976-10-01",8.93,1976]
["1976-11",11,1976,"1976-11-01",8.81,1976]
["1976-12",12,1976,"1976-12-01",8.7899999999999991,1976]
["1977-01",1,1977,"1977-01-01",8.7200000000000006,1977]
["1977-02",2,1977,"1977-02-01",8.67,1977]
["1977-03",3,1977,"1977-03-01",8.69,1977]
["1977-04",4,1977,"1977-04-01",8.75,1977]
["1977-05",5,1977,"1977-05-01",8.82,1977]
["1977-06",6,1977,"1977-06-01",8.86,1977]
["1977-07",7,1977,"1977-07-01",8.94,1977]
["1977-08",8,1977,"1977-08-01",8.94,1977]
["1977-09",9,1977,"1977-09-01",8.9,1977]
["1977-10",10,1977,"1977-10-01",8.92,1977]
["1977-11",11,1977,"1977-11-01",8.92,1977]
["1977-12",12,1977,"1977-12-01",8.9600000000000009,1977]
["1978-01",1,1978,"1978-01-01",9.02,1978]
["1978-02",2,1978,"1978-02-01",9.16,1978]
["1978-03",3,1978,"1978-03-01",9.1999999999999993,1978]
["1978-04",4,1978,"1978-04-01",9.36,1978]
["1978-05",5,1978,"1978-05-01",9.58,1978]
["1978-06",6,1978,"1978-06-01",9.7100000000000009,1978]
["1978-07",7,1978,"1978-07-01",9.74,1978]
["1978-08",8,1978,"1978-08-01",9.7899999999999991,1978]
["1978-09",9,1978,"1978-09-01",9.76,1978]
["1978-10",10,1978,"1978-10-01",9.86,1978]
["1978-11",11,1978,"1978-11-01",10.11,1978]
["1978-12",12,1978,"1978-12-01",10.35,1978]
["1979-01",1,1979,"1979-01-01",10.39,1979]
["1979-02",2,1979,"1979-02-01",10.41,1979]
["1979-03",3,1979,"1979-03-01",10.43,1979]
["1979-04",4,1979,"1979-04-01",10.5,1979]
["1979-05",5,1979,"1979-05-01",10.69,1979]
["1979-06",6,1979,"1979-06-01",11.04,1979]
["1979-07",7,1979,"1979-07-01",11.09,1979]
["1979-08",8,1979,"1979-08-01",11.09,1979]
["1979-09",9,1979,"1979-09-01",11.3,1979]
["1979-10",10,1979,"1979-10-01",11.64,1979]
["1979-11",11,1979,"1979-11-01",12.83,1979]
["1979-12",12,1979,"1979-12-01",12.9,1979]
["1980-01",1,1980,"1980-01-01",12.88,1980]
["1980-02",2,1980,"1980-02-01",13.04,1980]
["1980-03",3,1980,"1980-03-01",15.28,1980]
["1980-04",4,1980,"1980-04-01",16.329999999999998,1980]
["1980-05",5,1980,"1980-05-01",14.26,1980]
["1980-06",6,1980,"1980-06-01",12.71,1980]
["1980-07",7,1980,"1980-07-01",12.19,1980]
["1980-08",8,1980,"1980-08-01",12.56,1980]
["1980-09",9,1980,"1980-09-01",13.2,1980]
["1980-10",10,1980,"1980-10-01",13.79,1980]
["1980-11",11,1980,"1980-11-01",14.21,1980]
["1980-12",12,1980,"1980-12-01",14.79,1980]
["1981-01",1,1981,"1981-01-01",14.9,1981]
["1981-02",2,1981,"1981-02-01",15.13,1981]
["1981-03",3,1981,"1981-03-01",15.4,1981]
["1981-04",4,1981,"1981-04-01",15.58,1981]
["1981-05",5,1981,"1981-05-01",16.399999999999999,1981]
["1981-06",6,1981,"1981-06-01",16.7,1981]
["1981-07",7,1981,"1981-07-01",16.829999999999998,1981]
["1981-08",8,1981,"1981-08-01",17.29,1981]
["1981-09",9,1981,"1981-09-01",18.16,1981]
["1981-10",10,1981,"1981-10-01",18.45,1981]
["1981-11",11,1981,"1981-11-01",17.829999999999998,1981]
["1981-12",{"$f":"RIGHT(A130,2)+0","v":12},{"$f":"LEFT(A130,4)+0","v":1981},{"$f":"DATE(C130,B130,1)","v":"1981-12-01"},16.920000000000002,1981]
["1982-01",1,1982,"1982-01-01",17.399999999999999,1982]
["1982-02",2,1982,"1982-02-01",17.600000000000001,1982]
["1982-03",3,1982,"1982-03-01",17.16,1982]
["1982-04",4,1982,"1982-04-01",16.89,1982]
["1982-05",5,1982,"1982-05-01",16.68,1982]
["1982-06",6,1982,"1982-06-01",16.7,1982]
["1982-07",7,1982,"1982-07-01",16.82,1982]
["1982-08",8,1982,"1982-08-01",16.27,1982]
["1982-09",9,1982,"1982-09-01",15.43,1982]
["1982-10",10,1982,"1982-10-01",14.61,1982]
["1982-11",11,1982,"1982-11-01",13.83,1982]
["1982-12",12,1982,"1982-12-01",13.62,1982]
["1983-01",1,1983,"1983-01-01",13.25,1983]
["1983-02",2,1983,"1983-02-01",13.04,1983]
["1983-03",3,1983,"1983-03-01",12.8,1983]
["1983-04",4,1983,"1983-04-01",12.78,1983]
["1983-05",5,1983,"1983-05-01",12.63,1983]
["1983-06",6,1983,"1983-06-01",12.87,1983]
["1983-07",7,1983,"1983-07-01",13.42,1983]
["1983-08",8,1983,"1983-08-01",13.81,1983]
["1983-09",9,1983,"1983-09-01",13.73,1983]
["1983-10",10,1983,"1983-10-01",13.54,1983]
["1983-11",11,1983,"1983-11-01",13.44,1983]
["1983-12",12,1983,"1983-12-01",13.42,1983]
["1984-01",1,1984,"1984-01-01",13.37,1984]
["1984-02",2,1984,"1984-02-01",13.23,1984]
["1984-03",3,1984,"1984-03-01",13.39,1984]
["1984-04",4,1984,"1984-04-01",13.65,1984]
["1984-05",5,1984,"1984-05-01",13.94,1984]
["1984-06",6,1984,"1984-06-01",14.42,1984]
["1984-07",7,1984,"1984-07-01",14.67,1984]
["1984-08",8,1984,"1984-08-01",14.47,1984]
["1984-09",9,1984,"1984-09-01",14.35,1984]
["1984-10",10,1984,"1984-10-01",14.13,1984]
["1984-11",11,1984,"1984-11-01",13.64,1984]
["1984-12",12,1984,"1984-12-01",13.18,1984]
["1985-01",1,1985,"1985-01-01",13.08,1985]
["1985-02",2,1985,"1985-02-01",12.92,1985]
["1985-03",3,1985,"1985-03-01",13.17,1985]
["1985-04",4,1985,"1985-04-01",13.2,1985]
["1985-05",5,1985,"1985-05-01",12.91,1985]
["1985-06",6,1985,"1985-06-01",12.22,1985]
["1985-07",7,1985,"1985-07-01",12.03,1985]
["1985-08",8,1985,"1985-08-01",12.19,1985]
["1985-09",9,1985,"1985-09-01",12.19,1985]
["1985-10",10,1985,"1985-10-01",12.14,1985]
["1985-11",11,1985,"1985-11-01",11.78,1985]
["1985-12",12,1985,"1985-12-01",11.26,1985]
["1986-01",1,1986,"1986-01-01",10.88,1986]
["1986-02",2,1986,"1986-02-01",10.71,1986]
["1986-03",3,1986,"1986-03-01",10.08,1986]
["1986-04",4,1986,"1986-04-01",9.94,1986]
["1986-05",5,1986,"1986-05-01",10.14,1986]
["1986-06",6,1986,"1986-06-01",10.68,1986]
["1986-07",7,1986,"1986-07-01",10.51,1986]
["1986-08",8,1986,"1986-08-01",10.199999999999999,1986]
["1986-09",9,1986,"1986-09-01",10.01,1986]
["1986-10",10,1986,"1986-10-01",9.9700000000000006,1986]
["1986-11",11,1986,"1986-11-01",9.6999999999999993,1986]
["1986-12",12,1986,"1986-12-01",9.31,1986]
["1987-01",1,1987,"1987-01-01",9.1999999999999993,1987]
["1987-02",2,1987,"1987-02-01",9.08,1987]
["1987-03",3,1987,"1987-03-01",9.0399999999999991,1987]
["1987-04",{"$f":"RIGHT(A194,2)+0","v":4},{"$f":"LEFT(A194,4)+0","v":1987},{"$f":"DATE(C194,B194,1)","v":"1987-04-01"},9.83,1987]
["1987-05",5,1987,"1987-05-01",10.6,1987]
["1987-06",6,1987,"1987-06-01",10.54,1987]
["1987-07",7,1987,"1987-07-01",10.28,1987]
["1987-08",8,1987,"1987-08-01",10.33,1987]
["1987-09",9,1987,"1987-09-01",10.89,1987]
["1987-10",10,1987,"1987-10-01",11.26,1987]
["1987-11",11,1987,"1987-11-01",10.65,1987]
["1987-12",12,1987,"1987-12-01",10.65,1987]
["1988-01",1,1988,"1988-01-01",10.43,1988]
["1988-02",2,1988,"1988-02-01",9.89,1988]
["1988-03",3,1988,"1988-03-01",9.93,1988]
["1988-04",4,1988,"1988-04-01",10.199999999999999,1988]
["1988-05",5,1988,"1988-05-01",10.46,1988]
["1988-06",6,1988,"1988-06-01",10.46,1988]
["1988-07",7,1988,"1988-07-01",10.43,1988]
["1988-08",8,1988,"1988-08-01",10.6,1988]
["1988-09",9,1988,"1988-09-01",10.48,1988]
["1988-10",10,1988,"1988-10-01",10.3,1988]
["1988-11",11,1988,"1988-11-01",10.27,1988]
["1988-12",12,1988,"1988-12-01",10.61,1988]
["1989-01",1,1989,"1989-01-01",10.73,1989]
["1989-02",2,1989,"1989-02-01",10.65,1989]
["1989-03",3,1989,"1989-03-01",11.03,1989]
["1989-04",4,1989,"1989-04-01",11.05,1989]
["1989-05",5,1989,"1989-05-01",10.77,1989]
["1989-06",6,1989,"1989-06-01",10.199999999999999,1989]
["1989-07",7,1989,"1989-07-01",9.8800000000000008,1989]
["1989-08",8,1989,"1989-08-01",9.99,1989]
["1989-09",9,1989,"1989-09-01",10.130000000000001,1989]
["1989-10",10,1989,"1989-10-01",9.9499999999999993,1989]
["1989-11",11,1989,"1989-11-01",9.77,1989]
["1989-12",12,1989,"1989-12-01",9.74,1989]
["1990-01",1,1990,"1990-01-01",9.9,1990]
["1990-02",2,1990,"1990-02-01",10.199999999999999,1990]
["1990-03",3,1990,"1990-03-01",10.27,1990]
["1990-04",4,1990,"1990-04-01",10.37,1990]
["1990-05",5,1990,"1990-05-01",10.48,1990]
["1990-06",6,1990,"1990-06-01",10.16,1990]
["1990-07",7,1990,"1990-07-01",10.039999999999999,1990]
["1990-08",8,1990,"1990-08-01",10.1,1990]
["1990-09",9,1990,"1990-09-01",10.18,1990]
["1990-10",10,1990,"1990-10-01",10.18,1990]
["1990-11",11,1990,"1990-11-01",10.01,1990]
["1990-12",12,1990,"1990-12-01",9.67,1990]
["1991-01",1,1991,"1991-01-01",9.64,1991]
["1991-02",2,1991,"1991-02-01",9.3699999999999992,1991]
["1991-03",3,1991,"1991-03-01",9.5,1991]
["1991-04",4,1991,"1991-04-01",9.49,1991]
["1991-05",5,1991,"1991-05-01",9.4700000000000006,1991]
["1991-06",6,1991,"1991-06-01",9.6199999999999992,1991]
["1991-07",7,1991,"1991-07-01",9.58,1991]
["1991-08",8,1991,"1991-08-01",9.24,1991]
["1991-09",9,1991,"1991-09-01",9.01,1991]
["1991-10",10,1991,"1991-10-01",8.86,1991]
["1991-11",11,1991,"1991-11-01",8.7100000000000009,1991]
["1991-12",12,1991,"1991-12-01",8.5,1991]
["1992-01",1,1992,"1992-01-01",8.43,1992]
["1992-02",2,1992,"1992-02-01",8.76,1992]
["1992-03",3,1992,"1992-03-01",8.94,1992]
["1992-04",4,1992,"1992-04-01",8.85,1992]
["1992-05",5,1992,"1992-05-01",8.67,1992]
["1992-06",6,1992,"1992-06-01",8.51,1992]
["1992-07",7,1992,"1992-07-01",8.1300000000000008,1992]
["1992-08",{"$f":"RIGHT(A258,2)+0","v":8},{"$f":"LEFT(A258,4)+0","v":1992},{"$f":"DATE(C258,B258,1)","v":"1992-08-01"},7.98,1992]
["1992-09",9,1992,"1992-09-01",7.92,1992]
["1992-10",10,1992,"1992-10-01",8.09,1992]
["1992-11",11,1992,"1992-11-01",8.31,1992]
["1992-12",12,1992,"1992-12-01",8.2200000000000006,1992]
["1993-01",1,1993,"1993-01-01",8.02,1993]
["1993-02",2,1993,"1993-02-01",7.68,1993]
["1993-03",3,1993,"1993-03-01",7.5,1993]
["1993-04",4,1993,"1993-04-01",7.47,1993]
["1993-05",5,1993,"1993-05-01",7.47,1993]
["1993-06",6,1993,"1993-06-01",7.42,1993]
["1993-07",7,1993,"1993-07-01",7.21,1993]
["1993-08",8,1993,"1993-08-01",7.11,1993]
["1993-09",9,1993,"1993-09-01",6.92,1993]
["1993-10",10,1993,"1993-10-01",6.83,1993]
["1993-11",11,1993,"1993-11-01",7.16,1993]
["1993-12",12,1993,"1993-12-01",7.17,1993]
["1994-01",1,1994,"1994-01-01",7.06,1994]
["1994-02",2,1994,"1994-02-01",7.15,1994]
["1994-03",3,1994,"1994-03-01",7.68,1994]
["1994-04",4,1994,"1994-04-01",8.32,1994]
["1994-05",5,1994,"1994-05-01",8.6,1994]
["1994-06",6,1994,"1994-06-01",8.4,1994]
["1994-07",7,1994,"1994-07-01",8.61,1994]
["1994-08",8,1994,"1994-08-01",8.51,1994]
["1994-09",9,1994,"1994-09-01",8.64,1994]
["1994-10",10,1994,"1994-10-01",8.93,1994]
["1994-11",11,1994,"1994-11-01",9.17,1994]
["1994-12",12,1994,"1994-12-01",9.1999999999999993,1994]
["1995-01",1,1995,"1995-01-01",9.15,1995]
["1995-02",2,1995,"1995-02-01",8.83,1995]
["1995-03",3,1995,"1995-03-01",8.4600000000000009,1995]
["1995-04",4,1995,"1995-04-01",8.32,1995]
["1995-05",5,1995,"1995-05-01",7.96,1995]
["1995-06",6,1995,"1995-06-01",7.57,1995]
["1995-07",7,1995,"1995-07-01",7.61,1995]
["1995-08",8,1995,"1995-08-01",7.86,1995]
["1995-09",9,1995,"1995-09-01",7.64,1995]
["1995-10",10,1995,"1995-10-01",7.48,1995]
["1995-11",11,1995,"1995-11-01",7.38,1995]
["1995-12",12,1995,"1995-12-01",7.2,1995]
["1996-01",1,1996,"1996-01-01",7.03,1996]
["1996-02",2,1996,"1996-02-01",7.08,1996]
["1996-03",3,1996,"1996-03-01",7.62,1996]
["1996-04",4,1996,"1996-04-01",7.93,1996]
["1996-05",5,1996,"1996-05-01",8.07,1996]
["1996-06",6,1996,"1996-06-01",8.32,1996]
["1996-07",7,1996,"1996-07-01",8.25,1996]
["1996-08",8,1996,"1996-08-01",8,1996]
["1996-09",9,1996,"1996-09-01",8.23,1996]
["1996-10",10,1996,"1996-10-01",7.92,1996]
["1996-11",11,1996,"1996-11-01",7.62,1996]
["1996-12",12,1996,"1996-12-01",7.6,1996]
["1997-01",1,1997,"1997-01-01",7.82,1997]
["1997-02",2,1997,"1997-02-01",7.65,1997]
["1997-03",3,1997,"1997-03-01",7.9,1997]
["1997-04",4,1997,"1997-04-01",8.14,1997]
["1997-05",5,1997,"1997-05-01",7.94,1997]
["1997-06",6,1997,"1997-06-01",7.69,1997]
["1997-07",7,1997,"1997-07-01",7.5,1997]
["1997-08",8,1997,"1997-08-01",7.48,1997]
["1997-09",9,1997,"1997-09-01",7.43,1997]
["1997-10",10,1997,"1997-10-01",7.29,1997]
["1997-11",11,1997,"1997-11-01",7.21,1997]
["1997-12",{"$f":"RIGHT(A322,2)+0","v":12},{"$f":"LEFT(A322,4)+0","v":1997},{"$f":"DATE(C322,B322,1)","v":"1997-12-01"},7.1,1997]
["1998-01",1,1998,"1998-01-01",6.99,1998]
["1998-02",2,1998,"1998-02-01",7.04,1998]
["1998-03",3,1998,"1998-03-01",7.13,1998]
["1998-04",4,1998,"1998-04-01",7.14,1998]
["1998-05",5,1998,"1998-05-01",7.14,1998]
["1998-06",6,1998,"1998-06-01",7,1998]
["1998-07",7,1998,"1998-07-01",6.95,1998]
["1998-08",8,1998,"1998-08-01",6.92,1998]
["1998-09",9,1998,"1998-09-01",6.72,1998]
["1998-10",10,1998,"1998-10-01",6.71,1998]
["1998-11",11,1998,"1998-11-01",6.87,1998]
["1998-12",12,1998,"1998-12-01",6.72,1998]
["1999-01",1,1999,"1999-01-01",6.79,1999]
["1999-02",2,1999,"1999-02-01",6.81,1999]
["1999-03",3,1999,"1999-03-01",7.04,1999]
["1999-04",4,1999,"1999-04-01",6.92,1999]
["1999-05",5,1999,"1999-05-01",7.15,1999]
["1999-06",6,1999,"1999-06-01",7.55,1999]
["1999-07",7,1999,"1999-07-01",7.63,1999]
["1999-08",8,1999,"1999-08-01",7.94,1999]
["1999-09",9,1999,"1999-09-01",7.82,1999]
["1999-10",10,1999,"1999-10-01",7.85,1999]
["1999-11",11,1999,"1999-11-01",7.74,1999]
["1999-12",12,1999,"1999-12-01",7.91,1999]
["2000-01",1,2000,"2000-01-01",8.2100000000000009,2000]
["2000-02",2,2000,"2000-02-01",8.33,2000]
["2000-03",3,2000,"2000-03-01",8.24,2000]
["2000-04",4,2000,"2000-04-01",8.15,2000]
["2000-05",5,2000,"2000-05-01",8.52,2000]
["2000-06",6,2000,"2000-06-01",8.2899999999999991,2000]
["2000-07",7,2000,"2000-07-01",8.15,2000]
["2000-08",8,2000,"2000-08-01",8.0299999999999994,2000]
["2000-09",9,2000,"2000-09-01",7.91,2000]
["2000-10",10,2000,"2000-10-01",7.8,2000]
["2000-11",11,2000,"2000-11-01",7.75,2000]
["2000-12",12,2000,"2000-12-01",7.38,2000]
["2001-01",1,2001,"2001-01-01",7.03,2001]
["2001-02",2,2001,"2001-02-01",7.05,2001]
["2001-03",3,2001,"2001-03-01",6.95,2001]
["2001-04",4,2001,"2001-04-01",7.08,2001]
["2001-05",5,2001,"2001-05-01",7.15,2001]
["2001-06",6,2001,"2001-06-01",7.16,2001]
["2001-07",7,2001,"2001-07-01",7.13,2001]
["2001-08",8,2001,"2001-08-01",6.95,2001]
["2001-09",9,2001,"2001-09-01",6.82,2001]
["2001-10",10,2001,"2001-10-01",6.62,2001]
["2001-11",11,2001,"2001-11-01",6.66,2001]
["2001-12",12,2001,"2001-12-01",7.07,2001]
["2002-01",1,2002,"2002-01-01",7,2002]
["2002-02",2,2002,"2002-02-01",6.89,2002]
["2002-03",3,2002,"2002-03-01",7.01,2002]
["2002-04",4,2002,"2002-04-01",6.99,2002]
["2002-05",5,2002,"2002-05-01",6.81,2002]
["2002-06",6,2002,"2002-06-01",6.65,2002]
["2002-07",7,2002,"2002-07-01",6.49,2002]
["2002-08",8,2002,"2002-08-01",6.29,2002]
["2002-09",9,2002,"2002-09-01",6.09,2002]
["2002-10",10,2002,"2002-10-01",6.11,2002]
["2002-11",11,2002,"2002-11-01",6.07,2002]
["2002-12",12,2002,"2002-12-01",6.05,2002]
["2003-01",1,2003,"2003-01-01",5.92,2003]
["2003-02",2,2003,"2003-02-01",5.84,2003]
["2003-03",3,2003,"2003-03-01",5.75,2003]
["2003-04",{"$f":"RIGHT(A386,2)+0","v":4},{"$f":"LEFT(A386,4)+0","v":2003},{"$f":"DATE(C386,B386,1)","v":"2003-04-01"},5.81,2003]
["2003-05",5,2003,"2003-05-01",5.48,2003]
["2003-06",6,2003,"2003-06-01",5.23,2003]
["2003-07",7,2003,"2003-07-01",5.63,2003]
["2003-08",8,2003,"2003-08-01",6.26,2003]
["2003-09",9,2003,"2003-09-01",6.15,2003]
["2003-10",10,2003,"2003-10-01",5.95,2003]
["2003-11",11,2003,"2003-11-01",5.93,2003]
["2003-12",12,2003,"2003-12-01",5.88,2003]
["2004-01",1,2004,"2004-01-01",5.74,2004]
["2004-02",2,2004,"2004-02-01",5.64,2004]
["2004-03",3,2004,"2004-03-01",5.45,2004]
["2004-04",4,2004,"2004-04-01",5.83,2004]
["2004-05",5,2004,"2004-05-01",6.27,2004]
["2004-06",6,2004,"2004-06-01",6.29,2004]
["2004-07",7,2004,"2004-07-01",6.06,2004]
["2004-08",8,2004,"2004-08-01",5.87,2004]
["2004-09",9,2004,"2004-09-01",5.75,2004]
["2004-10",10,2004,"2004-10-01",5.72,2004]
["2004-11",11,2004,"2004-11-01",5.73,2004]
["2004-12",12,2004,"2004-12-01",5.75,2004]
["2005-01",1,2005,"2005-01-01",5.71,2005]
["2005-02",2,2005,"2005-02-01",5.63,2005]
["2005-03",3,2005,"2005-03-01",5.93,2005]
["2005-04",4,2005,"2005-04-01",5.86,2005]
["2005-05",5,2005,"2005-05-01",5.72,2005]
["2005-06",6,2005,"2005-06-01",5.58,2005]
["2005-07",7,2005,"2005-07-01",5.7,2005]
["2005-08",8,2005,"2005-08-01",5.82,2005]
["2005-09",9,2005,"2005-09-01",5.77,2005]
["2005-10",10,2005,"2005-10-01",6.07,2005]
["2005-11",11,2005,"2005-11-01",6.33,2005]
["2005-12",12,2005,"2005-12-01",6.27,2005]
["2006-01",1,2006,"2006-01-01",6.15,2006]
["2006-02",2,2006,"2006-02-01",6.25,2006]
["2006-03",3,2006,"2006-03-01",6.32,2006]
["2006-04",4,2006,"2006-04-01",6.51,2006]
["2006-05",5,2006,"2006-05-01",6.6,2006]
["2006-06",6,2006,"2006-06-01",6.68,2006]
["2006-07",7,2006,"2006-07-01",6.76,2006]
["2006-08",8,2006,"2006-08-01",6.52,2006]
["2006-09",9,2006,"2006-09-01",6.4,2006]
["2006-10",10,2006,"2006-10-01",6.36,2006]
["2006-11",11,2006,"2006-11-01",6.24,2006]
["2006-12",12,2006,"2006-12-01",6.14,2006]
["2007-01",1,2007,"2007-01-01",6.22,2007]
["2007-02",2,2007,"2007-02-01",6.29,2007]
["2007-03",3,2007,"2007-03-01",6.16,2007]
["2007-04",4,2007,"2007-04-01",6.18,2007]
["2007-05",5,2007,"2007-05-01",6.26,2007]
["2007-06",6,2007,"2007-06-01",6.66,2007]
["2007-07",7,2007,"2007-07-01",6.7,2007]
["2007-08",8,2007,"2007-08-01",6.57,2007]
["2007-09",9,2007,"2007-09-01",6.38,2007]
["2007-10",10,2007,"2007-10-01",6.38,2007]
["2007-11",11,2007,"2007-11-01",6.21,2007]
["2007-12",12,2007,"2007-12-01",6.1,2007]
["2008-01",1,2008,"2008-01-01",5.76,2008]
["2008-02",2,2008,"2008-02-01",5.92,2008]
["2008-03",3,2008,"2008-03-01",5.97,2008]
["2008-04",4,2008,"2008-04-01",5.92,2008]
["2008-05",5,2008,"2008-05-01",6.04,2008]
["2008-06",6,2008,"2008-06-01",6.32,2008]
["2008-07",7,2008,"2008-07-01",6.43,2008]
["2008-08",{"$f":"RIGHT(A450,2)+0","v":8},{"$f":"LEFT(A450,4)+0","v":2008},{"$f":"DATE(C450,B450,1)","v":"2008-08-01"},6.48,2008]
["2008-09",9,2008,"2008-09-01",6.04,2008]
["2008-10",10,2008,"2008-10-01",6.2,2008]
["2008-11",11,2008,"2008-11-01",6.09,2008]
["2008-12",12,2008,"2008-12-01",5.33,2008]
["2009-01",1,2009,"2009-01-01",5.0599999999999996,2009]
["2009-02",2,2009,"2009-02-01",5.13,2009]
["2009-03",3,2009,"2009-03-01",5,2009]
["2009-04",4,2009,"2009-04-01",4.8099999999999996,2009]
["2009-05",5,2009,"2009-05-01",4.8600000000000003,2009]
["2009-06",6,2009,"2009-06-01",5.42,2009]
["2009-07",7,2009,"2009-07-01",5.22,2009]
["2009-08",8,2009,"2009-08-01",5.19,2009]
["2009-09",9,2009,"2009-09-01",5.0599999999999996,2009]
["2009-10",10,2009,"2009-10-01",4.95,2009]
["2009-11",11,2009,"2009-11-01",4.88,2009]
["2009-12",12,2009,"2009-12-01",4.93,2009]
["2010-01",1,2010,"2010-01-01",5.03,2010]
["2010-02",2,2010,"2010-02-01",4.99,2010]
["2010-03",3,2010,"2010-03-01",4.97,2010]
["2010-04",4,2010,"2010-04-01",5.0999999999999996,2010]
["2010-05",5,2010,"2010-05-01",4.8899999999999997,2010]
["2010-06",6,2010,"2010-06-01",4.74,2010]
["2010-07",7,2010,"2010-07-01",4.5599999999999996,2010]
["2010-08",8,2010,"2010-08-01",4.43,2010]
["2010-09",9,2010,"2010-09-01",4.3499999999999996,2010]
["2010-10",10,2010,"2010-10-01",4.2300000000000004,2010]
["2010-11",11,2010,"2010-11-01",4.3,2010]
["2010-12",12,2010,"2010-12-01",4.71,2010]
["2011-01",1,2011,"2011-01-01",4.76,2011]
["2011-02",2,2011,"2011-02-01",4.95,2011]
["2011-03",3,2011,"2011-03-01",4.84,2011]
["2011-04",4,2011,"2011-04-01",4.84,2011]
["2011-05",5,2011,"2011-05-01",4.6399999999999997,2011]
["2011-06",6,2011,"2011-06-01",4.51,2011]
["2011-07",7,2011,"2011-07-01",4.55,2011]
["2011-08",8,2011,"2011-08-01",4.2699999999999996,2011]
["2011-09",9,2011,"2011-09-01",4.1100000000000003,2011]
["2011-10",10,2011,"2011-10-01",4.07,2011]
["2011-11",11,2011,"2011-11-01",3.99,2011]
["2011-12",12,2011,"2011-12-01",3.96,2011]
["2012-01",1,2012,"2012-01-01",3.92,2012]
["2012-02",2,2012,"2012-02-01",3.89,2012]
["2012-03",3,2012,"2012-03-01",3.95,2012]
["2012-04",4,2012,"2012-04-01",3.91,2012]

{"sheet":"Library","index":2,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Date","fines","unclass rev","book sale","comm","lost book"]
[41730,37,null,2,3,60]
[41731,33,null,4,2]
[41732,50,5,5,10]
[41733,24,2,null,null,18]
[41734,28,2,8,19]
[41735]
[41736,57,2,null,7]
[41737,21,null,2,1,20]
[41738,16,null,0.25,10]
[41739,17,null,4,3]
[41740,35]
[41741,23,null,1,16]
[41742]
[41743,4,null,2,3,51]
[41744,1,2,1,9]
[41745,3,2,0.5,9]
[41746,1,4,2,5,81]
[41747,0,null,null,null,35]
[41748,0,null,1.5,8,12]
[41749]
[41750,48,null,null,10,5]
[41751,29,2,2,10,17]
[41752,73,2,null,4]
[41753,23,6,null,6]
[41754,14,null,null,20]
[41755,61,2,null,null,25]
[41756]
[41757,56,9,null,6,7]
[41758,35,null,null,5,9]
[41759,11,null,null,6]

{"sheet":"Sports","index":3,"n_rows":16,"n_cols":32,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Year","Age","Team","League","G","PA","AB","R","H","2B","3B","HR","Good Year","RBI","SB","CS","BB","SO","BA","OBP","SLG","OPS","OPS+","TB","GDP","HBP","SH","SF","IBB","Pos","Awards Quantity","Awards"]
[2001,18,"NYM-min","Rk",36,138,120,27,36,7,0,4,"",17,9,1,16,30,0.3,0.39100000000000001,0.45800000000000002,0.85,null,55,3,2,0,0,0,null,1,"KPT · APPY"]
[2002,19,"NYM-min","A",135,582,496,85,132,30,2,11,"",93,21,5,76,114,0.26600000000000001,0.36699999999999999,0.40100000000000002,0.76800000000000002,null,199,4,5,1,4,2,null,1,"CLM · SALL"]
[2003,20,"NYM-min","A+",133,549,466,69,126,39,2,15,"",75,19,5,72,98,0.27,0.36899999999999999,0.45900000000000002,0.82799999999999996,null,214,8,4,1,6,5,null,1,"SCE · FLOR"]
[2004,21,"NYM-min","AA,AAA",91,406,337,62,115,35,0,18,"Good Year",57,22,10,55,60,0.34100000000000003,0.441,0.60499999999999998,1.046,null,204,8,9,0,5,4,null,3,"BNG,NFK · EL,IL"]
[2004,21,"NYM","NL",69,283,263,41,77,17,1,14,"",40,6,0,14,40,0.29299999999999998,0.33200000000000002,0.52500000000000002,0.85699999999999998,119,138,7,3,0,3,0,5]
[2005,22,"NYM","NL",160,657,575,99,176,42,1,27,"Good Year",102,17,7,72,113,0.30599999999999999,0.38800000000000001,0.52300000000000002,0.91200000000000003,140,301,16,7,0,3,2,"*5",1,"MVP-19"]
[2006,23,"NYM","NL",154,661,582,96,181,40,5,26,"Good Year",116,20,5,66,113,0.311,0.38100000000000001,0.53100000000000003,0.91200000000000003,133,309,15,5,0,8,13,"*5/D",2,"AS,MVP-9"]
[2007,24,"NYM","NL",160,711,604,113,196,42,1,30,"Good Year",107,34,5,94,115,0.32500000000000001,0.41599999999999998,0.54600000000000004,0.96299999999999997,149,330,14,6,0,7,6,"*5",4,"AS,MVP-4,GG,SS"]
[2008,25,"NYM","NL",160,736,626,115,189,42,2,33,"Good Year",124,15,5,94,118,0.30199999999999999,0.39,0.53400000000000003,0.92400000000000004,142,334,15,4,0,11,5,"*5/D",4,"AS,MVP-7,GG,SS"]
[2009,26,"NYM","NL",144,618,535,88,164,39,3,10,"",72,27,9,74,140,0.307,0.39,0.44700000000000001,0.83699999999999997,124,239,16,3,0,6,8,"*5",1,"AS"]
[2010,27,"NYM","NL",157,670,587,87,166,36,3,29,"",103,19,11,69,161,0.28299999999999997,0.35399999999999998,0.503,0.85599999999999998,131,295,12,2,0,12,9,"*5/D",2,"AS,MVP-24"]
[2011,28,"NYM-min","A+",6,27,21,9,10,3,0,0,"",2,1,0,6,3,0.47599999999999998,0.59299999999999997,0.61899999999999999,1.212,null,13,0,0,0,0,0,null,1,"SCE · FLOR"]
[2011,28,"NYM","NL",102,447,389,60,99,23,1,14,"",61,13,2,52,97,0.254,0.34499999999999997,0.42699999999999999,0.77100000000000002,115,166,5,3,0,3,4,41400]
[2012,29,"NYM","NL",156,670,581,91,178,41,2,21,"Good Year",93,15,10,81,112,0.30599999999999999,0.39100000000000001,0.49199999999999999,0.88300000000000001,144,286,15,3,0,5,16,"*5/6",2,"AS,MVP-6"]
[2013,30,"NYM","NL",22,97,78,14,24,4,3,2,"",18,6,1,18,15,0.308,0.433,0.51300000000000001,0.94599999999999995,169,40,1,0,0,1,0,"*5"]

{"sheet":"Car Maintenance","index":4,"n_rows":37,"n_cols":12,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Month","Total Cost","Car Pmt","Insurance for Additional Car","Maintenance","Maintenance","Miles","MPG","Gas Price","Monthly Gas","Date","Total Miles"]
[1,4288.9285714285716,4000,150,null,null,1000,28,3.89,138.92857142857144,41769,1000]
[2,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,41800,2000]
[3,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,41830,3000]
[4,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,41861,4000]
[5,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,41892,5000]
[6,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,41922,6000]
[7,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,41953,7000]
[8,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,41983,8000]
[9,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42014,9000]
[10,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42045,10000]
[11,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42073,11000]
[12,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42104,12000]
[13,717.92857142857144,0,150,29,400,1000,28,3.89,138.92857142857144,42134,13000]
[14,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42165,14000]
[15,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42195,15000]
[16,317.92857142857144,0,150,29,null,1000,28,3.89,138.92857142857144,42226,16000]
[17,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42257,17000]
[18,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42287,18000]
[19,317.92857142857144,0,150,29,null,1000,28,3.89,138.92857142857144,42318,19000]
[20,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42348,20000]
[21,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42379,21000]
[22,317.92857142857144,0,150,29,null,1000,28,3.89,138.92857142857144,42410,22000]
[23,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42439,23000]
[24,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42470,24000]
[25,717.92857142857144,0,150,29,400,1000,28,3.89,138.92857142857144,42500,25000]
[26,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42531,26000]
[27,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42561,27000]
[28,317.92857142857144,0,150,29,null,1000,28,3.89,138.92857142857144,42592,28000]
[29,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42623,29000]
[30,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42653,30000]
[31,317.92857142857144,0,150,29,null,1000,28,3.89,138.92857142857144,42684,31000]
[32,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42714,32000]
[33,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42745,33000]
[34,317.92857142857144,0,150,29,null,1000,28,3.89,138.92857142857144,42776,34000]
[35,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42804,35000]
[36,288.92857142857144,0,150,null,null,1000,28,3.89,138.92857142857144,42835,36000]

{"sheet":"Pivot table before group","index":5,"n_rows":40,"n_cols":2,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Row Labels","Count of Genre"]
[288,1]
[1070,1]
[1926,1]
[2205,1]
[2817,1]
[3198,1]
[3849,1]
[4226,1]
[4865,1]
[5685,1]
[6104,1]
[6456,1]
[8175,1]
[11301,1]
[12537,1]
[12912,1]
[15100,1]
[16201,1]
[27965,1]
[28021,1]
[33317,1]
[68003,1]
[71391,1]
[78956,1]
[185228,1]
[284963,1]
[297901,1]
[372673,1]
[492095,1]
[501563,1]
[625169,1]
[631246,1]
[661310,1]
[865538,1]
[1137316,1]
[1328401,1]
["Grand Total",36]

{"sheet":"Movies","index":6,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Rank","Movie","Distributor","Genre","Gross","Total Gross"]
[1,"Argo","Warner Bros.","Thriller/Suspense",1328401,"  $48,425,288"]
[2,"Paranormal Activity 4","Paramount Pictures","Horror",1137316,"  $33,957,365"]
[3,"Taken 2","20th Century Fox","Thriller/Suspense",865538,"  $109,388,845"]
[4,"Sinister","Summit Entertainment","Thriller/Suspense",661310,"  $34,444,955"]
[5,"Hotel Transylvania","Sony Pictures","Comedy",631246,"  $120,936,341"]
[6,"Alex Cross","Summit Entertainment","Drama",625169,"  $14,318,691"]
[7,"Here Comes the Boom","Sony Pictures","Comedy",501563,"  $25,110,472"]
[8,"Pitch Perfect","Universal","Comedy",492095,"  $47,352,233"]
[9,"Looper","Sony Pictures","Action",372673,"  $59,413,306"]
[10,"Seven Psychopaths","CBS Films","Comedy",297901,"  $10,461,508"]
[11,"Frankenweenie","Walt Disney","Comedy",284963,"  $29,342,407"]
[12,"The Perks of Being a Wallflower","Summit Entertainment","Drama",185228,"  $9,807,679"]
[13,"End of Watch","Open Road","Thriller/Suspense",78956,"  $38,233,511"]
[14,"Trouble with the Curve","Warner Bros.","Drama",71391,"  $34,355,574"]
[15,"Atlas Shrugged: Part II","Atlas Distribution","Drama",68003,"  $3,113,139"]
[16,"The Dark Knight Rises","Warner Bros.","Action",33317,"  $446,894,498"]
[17,"House at the End of the Street","Relativity","Horror",28021,"  $30,880,757"]
[18,"Arbitrage","Roadside Attractions","Thriller/Suspense",27965,"  $7,173,263"]
[19,"To the Arctic","Warner Bros.","Documentary",16201,"  $9,327,070"]
[20,"The Bourne Legacy","Universal","Thriller/Suspense",15100,"  $112,870,105"]
[21,"Dredd","Lionsgate","Action",12912,"  $13,380,022"]
[22,"The Sessions","Fox Searchlight","Thriller/Suspense",12537,"  $159,643"]
[23,"Ice Age: Continental Drift","20th Century Fox","Adventure",11301,"  $160,114,985"]
[24,"Ted","Universal","Comedy",8175,"  $218,665,740"]
[25,"ParaNorman","Focus Features","Comedy",6456,"  $54,689,530"]
[26,"Born to be Wild 3D","Warner Bros.","Documentary",6104,"  $21,113,708"]
[27,"Diary of a Wimpy Kid: Dog Days","20th Century Fox","Comedy",5685,"  $48,594,075"]
[28,"The Expendables 2","Lionsgate","Action",4865,"  $84,592,458"]
[29,"Won't Back Down","20th Century Fox","Drama",4226,"  $5,249,881"]
[30,"The Possession","Lionsgate","Horror",3849,"  $48,846,465"]
[31,"The Campaign","Warner Bros.","Comedy",3198,"  $86,451,277"]
[32,"Beasts of the Southern Wild","Fox Searchlight","Drama",2817,"  $11,194,951"]
[33,"Moonrise Kingdom","Focus Features","Drama",2205,"  $45,498,318"]
[34,"The Best Exotic Marigold Hotel","Fox Searchlight","Comedy",1926,"  $46,383,639"]
[35,"Ruby Sparks","Fox Searchlight","Romantic Comedy",1070,"  $2,540,106"]
[36,"Gayby","The Film Collaborative ","Comedy",288,"  $9,400"]

{"sheet":"GE Stock","index":7,"n_rows":87,"n_cols":10,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["Month","Day","Year","Month","Date","Open","High","Low","Close","Volume"]
["Jun",17,2011,6,40711,18.63,18.899999999999999,18.34,18.489999999999998,56599993]
["Jun",18,2011,6,40712,18.63,18.899999999999999,18.34,18.489999999999998,56599993]
["Jun",19,2011,6,40713,18.63,18.899999999999999,18.34,18.489999999999998,56599993]
["Jun",20,2011,6,40714,18.34,18.559999999999999,18.3,18.48,38905532]
["Jun",21,2011,6,40715,18.600000000000001,18.940000000000001,18.559999999999999,18.809999999999999,58789290]
["Jun",22,2011,6,40716,18.690000000000001,18.809999999999999,18.559999999999999,18.559999999999999,48098834]
["Jun",23,2011,6,40717,18.34,18.39,18.010000000000002,18.38,69354457]
["Jun",24,2011,6,40718,18.420000000000002,18.43,17.97,17.97,80830864]
["Jun",25,2011,6,40719,18.420000000000002,18.43,17.97,17.97,80830864]
["Jun",26,2011,6,40720,18.420000000000002,18.43,17.97,17.97,80830864]
["Jun",27,2011,6,40721,18.010000000000002,18.420000000000002,18,18.28,46446016]
["Jun",28,2011,6,40722,18.329999999999998,18.440000000000001,18.16,18.440000000000001,38701467]
["Jun",29,2011,6,40723,18.54,18.61,18.399999999999999,18.559999999999999,38790857]
["Jun",30,2011,6,40724,18.59,18.899999999999999,18.559999999999999,18.86,45061757]
["Jul",1,2011,7,40725,19.2,19.2,19.2,19.2,0]
["Jul",2,2011,7,40726,19.2,19.2,19.2,19.2,0]
["Jul",3,2011,7,40727,19.2,19.2,19.2,19.2,0]
["Jul",4,2011,7,40728,19.2,19.2,19.2,19.2,0]
["Jul",5,2011,7,40729,19.22,19.25,18.91,19.04,41907174]
["Jul",6,2011,7,40730,18.97,19.100000000000001,18.96,19.05,31582030]
["Jul",7,2011,7,40731,19.23,19.45,19.14,19.3,44971734]
["Jul",8,2011,7,40732,19.079999999999998,19.100000000000001,18.850000000000001,18.989999999999998,54661280]
["Jul",9,2011,7,40733,19.079999999999998,19.100000000000001,18.850000000000001,18.989999999999998,54661280]
["Jul",10,2011,7,40734,19.079999999999998,19.100000000000001,18.850000000000001,18.989999999999998,54661280]
["Jul",11,2011,7,40735,18.72,18.78,18.5,18.63,46560445]
["Jul",12,2011,7,40736,18.43,18.66,18.38,18.38,47154080]
["Jul",13,2011,7,40737,18.53,18.829999999999998,18.5,18.510000000000002,57145838]
["Jul",14,2011,7,40738,18.649999999999999,18.8,18.47,18.53,43748929]
["Jul",15,2011,7,40739,18.55,18.68,18.29,18.41,50543068]
["Jul",16,2011,7,40740,18.55,18.68,18.29,18.41,50543068]
["Jul",17,2011,7,40741,18.55,18.68,18.29,18.41,50543068]
["Jul",18,2011,7,40742,18.329999999999998,18.39,18.16,18.29,39561266]
["Jul",19,2011,7,40743,18.399999999999999,18.64,18.350000000000001,18.579999999999998,45677678]
["Jul",20,2011,7,40744,18.75,18.91,18.600000000000001,18.79,48563407]
["Jul",21,2011,7,40745,18.98,19.28,18.86,19.16,67148168]
["Jul",22,2011,7,40746,19.43,19.53,18.95,19.04,82155363]
["Jul",23,2011,7,40747,19.43,19.53,18.95,19.04,82155363]
["Jul",24,2011,7,40748,19.43,19.53,18.95,19.04,82155363]
["Jul",25,2011,7,40749,18.97,19.14,18.850000000000001,18.96,43822773]
["Jul",26,2011,7,40750,19,19.04,18.5,18.559999999999999,68361605]
["Jul",27,2011,7,40751,18.47,18.510000000000002,18.05,18.11,78142279]
["Jul",28,2011,7,40752,18.14,18.46,18.09,18.11,48679934]
["Jul",29,2011,7,40753,17.989999999999998,18.11,17.78,17.91,70172918]
["Jun",17,2011,6,40711,18.63,18.899999999999999,18.34,18.489999999999998,56599993]
["Jun",18,2011,6,40712,18.63,18.899999999999999,18.34,18.489999999999998,56599993]
["Jun",19,2011,6,40713,18.63,18.899999999999999,18.34,18.489999999999998,56599993]
["Jun",20,2011,6,40714,18.34,18.559999999999999,18.3,18.48,38905532]
["Jun",21,2011,6,40715,18.600000000000001,18.940000000000001,18.559999999999999,18.809999999999999,58789290]
["Jun",22,2011,6,40716,18.690000000000001,18.809999999999999,18.559999999999999,18.559999999999999,48098834]
["Jun",23,2011,6,40717,18.34,18.39,18.010000000000002,18.38,69354457]
["Jun",24,2011,6,40718,18.420000000000002,18.43,17.97,17.97,80830864]
["Jun",25,2011,6,40719,18.420000000000002,18.43,17.97,17.97,80830864]
["Jun",26,2011,6,40720,18.420000000000002,18.43,17.97,17.97,80830864]
["Jun",27,2011,6,40721,18.010000000000002,18.420000000000002,18,18.28,46446016]
["Jun",28,2011,6,40722,18.329999999999998,18.440000000000001,18.16,18.440000000000001,38701467]
["Jun",29,2011,6,40723,18.54,18.61,18.399999999999999,18.559999999999999,38790857]
["Jun",30,2011,6,40724,18.59,18.899999999999999,18.559999999999999,18.86,45061757]
["Jul",1,2011,7,40725,19.2,19.2,19.2,19.2,0]
["Jul",2,2011,7,40726,19.2,19.2,19.2,19.2,0]
["Jul",3,2011,7,40727,19.2,19.2,19.2,19.2,0]
["Jul",4,2011,7,40728,19.2,19.2,19.2,19.2,0]
["Jul",5,2011,7,40729,19.22,19.25,18.91,19.04,41907174]
["Jul",6,2011,7,40730,18.97,19.100000000000001,18.96,19.05,31582030]
["Jul",7,2011,7,40731,19.23,19.45,19.14,19.3,44971734]
["Jul",8,2011,7,40732,19.079999999999998,19.100000000000001,18.850000000000001,18.989999999999998,54661280]
["Jul",9,2011,7,40733,19.079999999999998,19.100000000000001,18.850000000000001,18.989999999999998,54661280]
["Jul",10,2011,7,40734,19.079999999999998,19.100000000000001,18.850000000000001,18.989999999999998,54661280]
["Jul",11,2011,7,40735,18.72,18.78,18.5,18.63,46560445]
["Jul",12,2011,7,40736,18.43,18.66,18.38,18.38,47154080]
["Jul",13,2011,7,40737,18.53,18.829999999999998,18.5,18.510000000000002,57145838]
["Jul",14,2011,7,40738,18.649999999999999,18.8,18.47,18.53,43748929]
["Jul",15,2011,7,40739,18.55,18.68,18.29,18.41,50543068]
["Jul",16,2011,7,40740,18.55,18.68,18.29,18.41,50543068]
["Jul",17,2011,7,40741,18.55,18.68,18.29,18.41,50543068]
["Jul",18,2011,7,40742,18.329999999999998,18.39,18.16,18.29,39561266]
["Jul",19,2011,7,40743,18.399999999999999,18.64,18.350000000000001,18.579999999999998,45677678]
["Jul",20,2011,7,40744,18.75,18.91,18.600000000000001,18.79,48563407]
["Jul",21,2011,7,40745,18.98,19.28,18.86,19.16,67148168]
["Jul",22,2011,7,40746,19.43,19.53,18.95,19.04,82155363]
["Jul",23,2011,7,40747,19.43,19.53,18.95,19.04,82155363]
["Jul",24,2011,7,40748,19.43,19.53,18.95,19.04,82155363]
["Jul",25,2011,7,40749,18.97,19.14,18.850000000000001,18.96,43822773]
["Jul",26,2011,7,40750,19,19.04,18.5,18.559999999999999,68361605]
["Jul",27,2011,7,40751,18.47,18.510000000000002,18.05,18.11,78142279]
["Jul",28,2011,7,40752,18.14,18.46,18.09,18.11,48679934]
["Jul",29,2011,7,40753,17.989999999999998,18.11,17.78,17.91,70172918]

{"sheet":"Vehicle Data","index":8,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Year","Make","Model","Price","Mileage","Color","Body Style","Sunroof"]
[2013,"toyota","prius",20000,1500,"pink","4 doors","Yes"]
[2013,"lexus","rs330",48000,18000,"red","4 doors","Yes"]
[2004,"lexus","rs330",8000,118000,"blue","4 doors","Yes"]
[2009,"cadillac","escalade",45000,17000,"white","4 doors","Yes"]
[2013,"lexus","ls250",40000,5000,"black","4 doors"]
[2012,"chrysler",200,25000,12000,"blue","4 doors"]
[2010,"chevy","aveo",27000,16000,"blue","4 doors"]
[2010,"mazda","protégé",22000,19000,"green","4 doors"]
[2010,"vw","bug",18000,13000,"green","2 doors"]
[2006,"nissan","maxima",30000,14000,"silver","4 doors"]

{"sheet":"BBQ List","index":9,"n_rows":24,"n_cols":17,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Description","Category","Quantity","Unit Price","Subtotal","Tax Rate","Total with Tax","Assigned"]
["cupcakes","snack",45,2.99,134.55000000000001,7.0000000000000007E-2,143.97,"Greg"]
["pounds of chicken","food",16,3.99,63.84,0,63.84,"Brian"]
["pounds of beef","food",10,4.99,49.900000000000006,0,49.9,"Jonathan"]
["soda 6 packs","beverage",6,4.99,29.94,7.0000000000000007E-2,32.04,"Greg",null,null,null,"Sum of Subtotal","Column Labels"]
["large watermelon","food",3,6.99,20.97,0,20.97,"Brian",null,null,null,"Row Labels","beverage","food","snack","supplies","Grand Total"]
["corn by ear","food",30,0.6,18,0,18,"Jonathan",null,null,null,"assorted utensils 100 ct",null,null,null,13.98,13.98]
["paper plates 50 ct","supplies",2,6.99,13.98,7.0000000000000007E-2,14.96,"Jonathan",null,null,null,"buns 12 pack",null,7.96,null,null,7.96]
["assorted utensils 100 ct","supplies",2,6.99,13.98,7.0000000000000007E-2,14.96,"Brian",null,null,null,"corn by ear",null,18,null,null,18]
["tortilla chips large bag","snack",2,5.99,11.98,7.0000000000000007E-2,12.82,"Jonathan",null,null,null,"cupcakes",null,null,134.55000000000001,null,134.55000000000001]
["ketchup 12 oz.","food",3,2.99,8.9700000000000006,0,8.9700000000000006,"Jonathan",null,null,null,"cups 50 ct",null,null,null,7.98,7.98]
["potato chips large bag","snack",2,3.99,7.98,7.0000000000000007E-2,8.5399999999999991,"Brian",null,null,null,"hot dog 12 pack",null,7.98,null,null,7.98]
["cups 50 ct","supplies",2,3.99,7.98,7.0000000000000007E-2,8.5399999999999991,"Jonathan",null,null,null,"ketchup 12 oz.",null,8.9700000000000006,null,null,8.9700000000000006]
["hot dog 12 pack","food",2,3.99,7.98,0,7.98,"Greg",null,null,null,"large watermelon",null,20.97,null,null,20.97]
["buns 12 pack","food",4,1.99,7.96,0,7.96,"Brian",null,null,null,"mustard 12 oz.",null,3.98,null,null,3.98]
["pickles large jar","snack",1,6.99,6.99,7.0000000000000007E-2,7.48,"Jonathan",null,null,null,"napkins 200 ct",null,null,null,5.18,5.18]
["napkins 200 ct","supplies",2,2.59,5.18,7.0000000000000007E-2,5.54,"Greg",null,null,null,"paper plates 50 ct",null,null,null,13.98,13.98]
["mustard 12 oz.","food",2,1.99,3.98,0,3.98,"Brian",null,null,null,"pickles large jar",null,null,6.99,null,6.99]
[null,null,null,null,null,null,null,null,null,null,null,"potato chips large bag",null,null,7.98,null,7.98]
[null,null,null,null,null,null,null,null,null,null,null,"pounds of beef",null,49.900000000000006,null,null,49.900000000000006]
[null,null,null,null,null,null,null,null,null,null,null,"pounds of chicken",null,63.84,null,null,63.84]
[null,null,null,null,null,null,null,null,null,null,null,"soda 6 packs",29.94,null,null,null,29.94]
[null,null,null,null,null,null,null,null,null,null,null,"tortilla chips large bag",null,null,11.98,null,11.98]
[null,null,null,null,null,null,null,null,null,null,null,"Grand Total",29.94,181.60000000000002,161.5,41.120000000000005,414.16]

{"sheet":"Commission","index":10,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"NESTED IF FUNCTION example"]
["Employee","Potential Commission","Date","Sales","Actual Commission"]
["Abe",50,"2012-10-12",100,{"$f":"IF(C3>=DATE(2012,10,12),IF(D3>500,B3,B3/2),0)","v":25}]
["Jim",80,"2012-10-09",200,{"$f":"IF(C4>=DATE(2012,10,12),IF(D4>500,B4,B4/2),0)","v":0}]
["Sal",100,"2012-10-11",300,0,null,null,"Row Labels","Sum of Actual Commission"]
["Abe",50,"2012-10-13",400,25,null,null,"2012-10-09",0]
["Jim",80,"2012-10-13",500,40,null,null,"Jim",0]
["Sal",100,"2012-10-13",600,100,null,null,"2012-10-11",0]
["Abe",50,"2012-10-13",700,50,null,null,"Sal",0]
["Jim",80,"2012-10-13",800,80,null,null,"2012-10-12",25]
["Sal",100,"2012-10-13",900,100,null,null,"Abe",25]
["Abe",50,"2012-10-13",1000,50,null,null,"2012-10-13",625]
["Jim",80,"2012-10-13",1100,80,null,null,"Abe",125]
["Sal",100,"2012-10-13",1200,100,null,null,"Jim",200]
[null,null,null,null,null,null,null,"Sal",300]
[null,null,null,null,null,null,null,"Grand Total",650]

{"sheet":"sample macro","index":11,"n_rows":18,"n_cols":15,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,1,2,3,{"$f":"NOW()","v":"2015-07-27T20:23:20.220"},"we recorded a macro with relative refrences on!"]
[null,null,1,2,3,{"$f":"NOW()","v":"2015-07-27T20:23:20.220"},"we recorded a macro with relative refrences on!"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,1,2,3,{"$f":"NOW()","v":"2015-07-27T20:23:20.220"},"we recorded a macro with relative refrences on!"]
[]
[]
[]
[null,null,1,2,3,{"$f":"NOW()","v":"2015-07-27T20:23:20.220"},"we recorded a macro with relative refrences on!"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,1,2,3,{"$f":"NOW()","v":"2015-07-27T20:23:20.220"},"we recorded a macro with relative refrences on!"]
[]
[1,2,3,{"$f":"NOW()","v":"2015-07-27T20:23:20.220"},"we recorded a macro with relative refrences on!"]

{"sheet":"move column macro before","index":12,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]

{"sheet":"move column macro before copy","index":13,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]
["a","e","b","c",3,2,1,"abc"]

{"sheet":"move column macro","index":14,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]
["a","e","b","c",1,2,3]