{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Menu","Context Menu ","Shortcut","Blank Cell Hide","Filter","Conditional Formatting","Filter with Formula","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Dataset","index":0,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Formula to Hide Rows in Excel"]
[]
[null,"Date of Purchase","Region","Product","Quantity"]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1911-07-18T08:39:13.693"},"East","Bran",56]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1944-05-01T22:31:01.989"},"East","Oatmeal Raisin",24]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1930-06-28T17:44:02.075"},"West","Butter",32]
[null,"1908-08-11T02:08:27.707","East","Arrowroot",45]
[null,"1986-06-04T19:22:53.223","East","Vanilla Chip",582]
[null,"1922-01-08T21:29:40.430","West","Butter",22]
[null,"1916-03-18T13:22:25.392","East","Arron Bisaka",65]
[null,"1950-11-28T22:00:46.637","East","Vanilla Chip",85]
[null,"1962-12-18T12:23:25.283","East","Whole Wheat",95]
[null,"1990-12-22T00:11:19.796","West","Butter",78]
[null,"1982-04-24T10:55:21.331","West","Oatmeal Raisin",85]
[null,"1901-01-30T09:10:33.057","East","Butter",46]
[null,"1950-10-26T23:02:22.216","East","Whole Wheat",63]
[null,"1968-06-11T20:40:53.165","West","Vanilla Chip",35]

{"sheet":"Menu","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Formula to Hide Rows in Excel"]
[]
[null,"Date of Purchase","Region","Product","Quantity"]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2009-03-30T07:57:50.808"},"East","Bran",{"$f":"RANDBETWEEN(15,80)","v":19}]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1934-07-23T14:45:15.135"},"East","Oatmeal Raisin",{"$f":"RANDBETWEEN(15,80)","v":15}]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2001-12-20T00:25:41.384"},"West","Butter",32]
[null,"1991-11-09T16:50:58.232","East","Arrowroot",63]
[null,"1907-07-24T10:48:00.100","East","Vanilla Chip",52]
[null,"1903-12-19T01:21:51.564","West","Butter",76]
[null,"1961-08-28T15:59:17.364","East","Arron Bisaka",53]
[null,"1990-12-26T17:44:11.810","East","Vanilla Chip",17]
[null,"1935-04-14T15:01:54.235","East","Whole Wheat",64]
[null,"1951-04-28T11:48:34.833","West","Butter",49]
[null,"1950-10-30T18:40:11.424","West","Oatmeal Raisin",71]
[null,"2012-09-30T03:58:35.543","East","Butter",15]
[null,"1927-12-24T02:25:55.313","East","Whole Wheat",50]
[null,"1968-05-27T06:16:57.266","West","Vanilla Chip",34]

{"sheet":"Context Menu ","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Formula to Hide Rows in Excel"]
[]
[null,"Date of Purchase","Region","Product","Quantity"]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2002-04-10T11:22:41.267"},"East","Bran",15]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2011-05-23T05:03:05.395"},"East","Oatmeal Raisin",15]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1942-12-11T14:03:08.276"},"West","Butter",{"$f":"RANDBETWEEN(15,80)","v":54}]
[null,"2003-07-13T23:27:35.233","East","Arrowroot",79]
[null,"1978-12-18T07:59:59.920","East","Vanilla Chip",36]
[null,"1941-03-05T23:44:28.673","West","Butter",35]
[null,"1920-08-13T12:07:46.493","East","Arron Bisaka",59]
[null,"1973-03-28T23:20:40.789","East","Vanilla Chip",64]
[null,"1993-12-08T03:07:24.891","East","Whole Wheat",60]
[null,"1968-01-30T13:06:57.038","West","Butter",29]
[null,"1975-12-23T14:45:27.888","West","Oatmeal Raisin",80]
[null,"1949-03-08T21:32:32.461","East","Butter",29]
[null,"1912-07-10T22:07:47.822","East","Whole Wheat",55]
[null,"1961-05-09T16:35:37.899","West","Vanilla Chip",73]

{"sheet":"Shortcut","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Formula to Hide Rows in Excel"]
[]
[null,"Date of Purchase","Region","Product","Quantity"]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1913-05-18T01:24:36.878"},"East","Bran",56]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2010-04-18T00:05:30.517"},"East","Oatmeal Raisin",24]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2004-03-11T19:31:36.706"},"West","Butter",32]
[null,"1949-06-29T00:16:03.439","East","Arrowroot",45]
[null,"1926-12-09T14:06:53.877","East","Vanilla Chip",582]
[null,"1938-03-18T03:33:50.231","West","Butter",22]
[null,"1938-06-06T03:24:32.586","East","Arron Bisaka",65]
[null,"1930-02-06T12:07:23.754","East","Vanilla Chip",85]
[null,"1949-02-13T22:23:50.780","East","Whole Wheat",95]
[null,"1914-07-09T16:40:54.182","West","Butter",78]
[null,"1972-02-13T04:46:54.466","West","Oatmeal Raisin",85]
[null,"1990-12-10T16:13:52.804","East","Butter",46]
[null,"1962-09-17T13:41:46.120","East","Whole Wheat",63]
[null,"1942-11-19T22:00:32.944","West","Vanilla Chip",35]

{"sheet":"Blank Cell Hide","index":4,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Formula to Hide Rows in Excel"]
[]
[null,"Date of Purchase","Region","Product","Quantity"]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1939-09-10T22:16:06.113"},"East","Bran",{"$f":"RANDBETWEEN(15,80)","v":72}]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2010-05-13T23:05:58.444"},"East","Oatmeal Raisin",{"$f":"RANDBETWEEN(15,80)","v":49}]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1988-01-24T01:04:36.272"},"West","Butter",21]
[null,"1941-09-03T00:49:06.993","East","Arrowroot",47]
[]
[null,"1929-08-31T06:11:25.536","West","Butter",60]
[null,"1935-04-02T03:53:40.725","East","Arron Bisaka",68]
[null,"1996-04-11T10:57:09.137","East","Vanilla Chip",31]
[null,"1935-08-02T19:39:28.438","East","Whole Wheat",15]
[]
[null,"1984-06-20T01:18:02.464","West","Oatmeal Raisin",51]
[null,"1988-06-02T06:29:11.266","East","Butter",31]
[null,"1920-06-13T23:45:34.721","East","Whole Wheat",57]
[null,"1968-10-19T12:58:33.356","West","Vanilla Chip",18]

{"sheet":"Filter","index":5,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Formula to Hide Rows in Excel"]
[]
[null,"Date of Purchase","Region","Product","Quantity"]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2002-11-01T16:04:40.497"},"East","Bran",{"$f":"RANDBETWEEN(15,80)","v":45}]
[null,"1992-10-22T05:05:07.492","East","Oatmeal Raisin",68]
[null,"1948-10-27T14:24:39.628","East","Arrowroot",56]
[null,"1935-09-10T12:00:36.115","East","Vanilla Chip",66]
[null,"1958-12-21T18:29:00.250","East","Arron Bisaka",36]
[null,"1936-01-23T14:46:29.045","East","Vanilla Chip",32]
[null,"1955-07-20T18:50:37.582","East","Whole Wheat",40]
[null,"1997-12-28T22:12:24.211","East","Butter",20]
[null,"2003-10-17T20:59:03.431","East","Whole Wheat",30]
[null,"2001-03-18T17:36:27.392","West","Butter",79]
[null,"1912-06-14T19:18:00.556","West","Butter",53]
[null,"1969-12-29T23:21:45.572","West","Butter",73]
[null,"1907-08-01T21:38:53.524","West","Oatmeal Raisin",20]
[null,"1991-05-14T05:20:02.628","West","Vanilla Chip",36]

{"sheet":"Conditional Formatting","index":6,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Formula to Hide Rows in Excel"]
[]
[null,"Date of Purchase","Region","Product","Quantity"]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1959-12-28T22:17:57.752"},"East","Bran",56]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1940-08-28T08:55:13.725"},"East","Oatmeal Raisin",24]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1953-01-13T22:37:05.974"},"West","Butter",32]
[null,"2008-05-01T00:23:01.309","East","Arrowroot",45]
[null,"1948-11-26T03:30:30.657","East","Vanilla Chip",582]
[null,"1997-02-07T17:40:50.037","West","Butter",22]
[null,"1926-01-12T16:02:14.335","East","Arron Bisaka",65]
[null,"1994-07-05T12:05:36.871","East","Vanilla Chip",85]
[null,"1986-11-19T08:27:05.468","East","Whole Wheat",95]
[null,"1921-04-13T13:04:10.010","West","Butter",78]
[null,"1929-10-25T05:02:35.915","West","Oatmeal Raisin",85]
[null,"1908-05-01T08:05:59.778","East","Butter",46]
[null,"1910-10-27T16:44:01.121","East","Whole Wheat",63]
[null,"2009-03-18T20:16:47.169","West","Vanilla Chip",35]

{"sheet":"Filter with Formula","index":7,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Formula to Hide Rows in Excel"]
[]
[null,"Date of Purchase","Region","Product","Quantity","Formula with Filter"]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2012-09-02T13:00:10.533"},"East","Bran",36,{"$f":"IF(E5<50,\"Hide Row\",E5)","v":"Hide Row"}]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1941-10-29T15:17:11.999"},"East","Oatmeal Raisin",24,{"$f":"IF(E6<50,\"Hide Row\",E6)","v":"Hide Row"}]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2012-11-21T03:11:52.166"},"West","Butter",32,"Hide Row"]
[null,"1941-05-25T16:44:41.407","East","Arrowroot",45,"Hide Row"]
[null,"1963-04-22T07:40:50.023","East","Vanilla Chip",58,58]
[null,"1987-03-20T11:30:48.683","West","Butter",22,"Hide Row"]
[null,"2009-01-17T08:55:31.615","East","Arron Bisaka",65,65]
[null,"2011-04-24T14:16:13.972","East","Vanilla Chip",85,85]
[null,"1938-08-23T14:25:45.437","East","Whole Wheat",95,95]
[null,"1985-01-05T20:17:21.758","West","Butter",78,78]
[null,"1916-07-25T20:35:30.869","West","Oatmeal Raisin",85,85]
[null,"1962-05-27T11:29:07.758","East","Butter",46,"Hide Row"]
[null,"1954-10-27T10:32:50.911","East","Whole Wheat",63,63]
[null,"1937-03-21T01:06:33.934","West","Vanilla Chip",35,"Hide Row"]

{"sheet":"VBA","index":8,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Formula to Hide Rows in Excel"]
[]
[null,"Date of Purchase","Region","Product","Quantity"]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1975-07-29T08:00:46.892"},"East","Bran",56]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"1971-08-28T22:00:39.682"},"East","Oatmeal Raisin",24]
[null,{"$f":"DATE(2000,1,1)+(RAND()*DATE(2013,6,28)-(DATE(2000,1,1)))","v":"2007-09-19T13:15:29.242"},"West","Butter",32]
[null,"1998-04-03T22:51:14.086","East","Arrowroot",45]
[null,"1915-12-05T20:40:48.547","East","Vanilla Chip",58]
[null,"1933-10-08T00:07:41.751","West","Butter",22]
[null,"1983-12-27T23:30:59.307","East","Arron Bisaka",65]
[null,"1996-04-29T10:02:56.465","East","Vanilla Chip",85]
[null,"2007-01-07T09:26:21.374","East","Whole Wheat",95]
[null,"1975-11-30T09:29:09.847","West","Butter",78]
[null,"1933-11-01T23:52:18.063","West","Oatmeal Raisin",85]
[null,"1906-03-24T02:07:16.713","East","Butter",46]
[null,"1985-04-27T09:28:30.351","East","Whole Wheat",63]
[null,"1945-12-05T03:37:37.187","West","Vanilla Chip",35]