{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["COUNTIFS()","SUMPRODUCT()","PivotTable","COUNTIF()","Macros","SUMPRODUCT()-2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"COUNTIFS()","index":0,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["List of Works by H. Rider Haggard"]
[]
[null,"Book Title","Date of Publication",null,{"$f":"COUNTIFS(C4:C23,\">1-Jan-81\",C4:C23,\"<=31-Dec-90\")","v":14}]
[null,"The Transvaal","1977-05-02"]
[null,"A Zulu War-Dance","1977-07-17"]
[null,"A Visit to the Chief Secocoeni","1977-07-17"]
[null,"Hydrophobia","1978-11-03"]
[null,"The Land Question","1985-04-28"]
[null,"About Fiction","1986-02-02"]
[null,"Mr Rider Haggard and His Critics","1987-04-27"]
[null,"American Copyright","1989-05-12"]
[null,"Delagoa Bay","1987-01-18"]
[null,"Mr. Meeson's Will","1988-08-18"]
[null,"The Wreck of the Copeland","1988-07-17"]
[null,"Cleopatra","1977-11-03"]
[null,"Virgin of the Sun","1985-06-12"]
[null,"The Fate of Swaziland","1992-06-12"]
[null,"Alan and the Holy Flower","1988-04-27"]
[null,"Nada the Lily","1985-11-03"]
[null,"She","1987-02-13"]
[null,"And Return of She","1988-02-13"]
[null,"The People of the Mist","1988-08-18"]
[null,"Heart of the World","1988-08-18"]

{"sheet":"SUMPRODUCT()","index":1,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["List of Works by H. Rider Haggard"]
[]
[null,"Book Title","Date of Publication",null,{"$f":"SUMPRODUCT(((C4:C23)>=DATE(80,1,1))*((C4:C23)<=DATE(90,12,31)))","v":14}]
[null,"The Transvaal","1977-05-02"]
[null,"A Zulu War-Dance","1977-07-17"]
[null,"A Visit to the Chief Secocoeni","1977-07-17"]
[null,"Hydrophobia","1978-11-03"]
[null,"The Land Question","1985-04-28"]
[null,"About Fiction","1986-02-02"]
[null,"Mr Rider Haggard and His Critics","1987-04-27"]
[null,"American Copyright","1989-05-12"]
[null,"Delagoa Bay","1987-01-18"]
[null,"Mr. Meeson's Will","1988-08-18"]
[null,"The Wreck of the Copeland","1988-07-17"]
[null,"Cleopatra","1977-11-03"]
[null,"Virgin of the Sun","1985-06-12"]
[null,"The Fate of Swaziland","1992-06-12"]
[null,"Alan and the Holy Flower","1988-04-27"]
[null,"Nada the Lily","1985-11-03"]
[null,"She","1987-02-13"]
[null,"And Return of She","1988-02-13"]
[null,"The People of the Mist","1988-08-18"]
[null,"Heart of the World","1988-08-18"]

{"sheet":"PivotTable","index":2,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["List of Works by H. Rider Haggard"]
[]
[null,"Book Title","Date of Publication",null,"Date of Publication","Count of Date of Publication"]
[null,"The Transvaal","1977-05-02",null,"1977-05-02",1]
[null,"A Zulu War-Dance","1977-07-17",null,"1977-07-17",2]
[null,"A Visit to the Chief Secocoeni","1977-07-17",null,"1977-11-03",1]
[null,"Hydrophobia","1978-11-03",null,"1978-11-03",1]
[null,"The Land Question","1985-04-28",null,"1985-04-28",1]
[null,"About Fiction","1986-02-02",null,"1985-06-12",1]
[null,"Mr Rider Haggard and His Critics","1987-04-27",null,"1985-11-03",1]
[null,"American Copyright","1989-05-12",null,"1986-02-02",1]
[null,"Delagoa Bay","1987-01-18",null,"1987-01-18",1]
[null,"Mr. Meeson's Will","1988-08-18",null,"1987-02-13",1]
[null,"The Wreck of the Copeland","1988-07-17",null,"1987-04-27",1]
[null,"Cleopatra","1977-11-03",null,"1988-02-13",1]
[null,"Virgin of the Sun","1985-06-12",null,"1988-04-27",1]
[null,"The Fate of Swaziland","1992-06-12",null,"1988-07-17",1]
[null,"Alan and the Holy Flower","1988-04-27",null,"1988-08-18",3]
[null,"Nada the Lily","1985-11-03",null,"1989-05-12",1]
[null,"She","1987-02-13",null,"1992-06-12",1]
[null,"And Return of She","1988-02-13",null,"Grand Total",20]
[null,"The People of the Mist","1988-08-18"]
[null,"Heart of the World","1988-08-18"]

{"sheet":"COUNTIF()","index":3,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["List of Works by H. Rider Haggard"]
[]
[null,"Book Title","Date of Publication"]
[null,"The Transvaal","02-May-1877",null,{"$f":"COUNTIF(C4:C23,\"18-Aug-1888\")","v":3}]
[null,"A Zulu War-Dance","17-Jul-1877"]
[null,"A Visit to the Chief Secocoeni","17-Jul-1878"]
[null,"Hydrophobia","3-Nov-1885"]
[null,"The Land Question","28-Apr-1886"]
[null,"About Fiction","02-Feb-1887"]
[null,"Mr Rider Haggard and His Critics","27-Apr-1887"]
[null,"American Copyright","27-Apr-1888"]
[null,"Delagoa Bay","17-Dec-1887"]
[null,"Mr. Meeson's Will","18-Jan-1888"]
[null,"The Wreck of the Copeland","18-Aug-1888"]
[null,"Cleopatra","17-Jul-1877"]
[null,"Virgin of the Sun","3-Nov-1885"]
[null,"The Fate of Swaziland","12-Jun-1892"]
[null,"Alan and the Holy Flower","27-Apr-1888"]
[null,"Nada the Lily","3-Nov-1885"]
[null,"She","13-Feb-1887"]
[null,"And Return of She","13-Feb-1888"]
[null,"The People of the Mist","18-Aug-1888"]
[null,"Heart of the World","18-Aug-1888"]

{"sheet":"Macros","index":4,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["List of Works by H. Rider Haggard"]
[]
[null,"Book Title","Starting Date","Finishing Date",null,{"$f":"CountFor(DATE(90,1,1),C4:D23)","v":7}]
[null,"The Transvaal","1977-05-02",{"$f":"DATE(78,2,3)","v":"1978-02-03"}]
[null,"A Zulu War-Dance","1977-07-17",{"$f":"DATE(79,5,11)","v":"1979-05-11"}]
[null,"A Visit to the Chief Secocoeni","1977-07-17",{"$f":"DATE(86,7,3)","v":"1986-07-03"}]
[null,"Hydrophobia","1978-11-03",{"$f":"DATE(81,9,11)","v":"1981-09-11"}]
[null,"The Land Question","1985-04-28",{"$f":"DATE(87,2,3)","v":"1987-02-03"}]
[null,"About Fiction","1986-02-02",{"$f":"DATE(87,5,11)","v":"1987-05-11"}]
[null,"Mr Rider Haggard and His Critics","1987-04-27",{"$f":"DATE(90,2,7)","v":"1990-02-07"}]
[null,"American Copyright","1989-05-12",{"$f":"DATE(89,5,12)","v":"1989-05-12"}]
[null,"Delagoa Bay","1987-01-18",{"$f":"DATE(93,2,3)","v":"1993-02-03"}]
[null,"Mr. Meeson's Will","1988-08-18",{"$f":"DATE(89,5,11)","v":"1989-05-11"}]
[null,"The Wreck of the Copeland","1988-07-17",{"$f":"DATE(88,12,11)","v":"1988-12-11"}]
[null,"Cleopatra","1977-11-03",{"$f":"DATE(79,10,11)","v":"1979-10-11"}]
[null,"Virgin of the Sun","1985-06-12",{"$f":"DATE(90,3,3)","v":"1990-03-03"}]
[null,"The Fate of Swaziland","1992-06-12",{"$f":"DATE(96,5,11)","v":"1996-05-11"}]
[null,"Alan and the Holy Flower","1988-04-27",{"$f":"DATE(98,5,11)","v":"1998-05-11"}]
[null,"Nada the Lily","1985-11-03",{"$f":"DATE(89,5,11)","v":"1989-05-11"}]
[null,"She","1987-02-13",{"$f":"DATE(90,5,11)","v":"1990-05-11"}]
[null,"And Return of She","1988-02-13",{"$f":"DATE(89,5,F2011)","v":"1989-04-30"}]
[null,"The People of the Mist","1988-08-18",{"$f":"DATE(91,5,11)","v":"1991-05-11"}]
[null,"Heart of the World","1988-08-18",{"$f":"DATE(90,5,11)","v":"1990-05-11"}]

{"sheet":"SUMPRODUCT()-2","index":5,"n_rows":23,"n_cols":5,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["List of Works by H. Rider Haggard"]
[]
[null,"Book Title","Date of Publication"]
[null,"The Transvaal","02-May-1877",null,{"$f":"SUMPRODUCT(--(C4:C23=\"18-Aug-1888\"))","v":3}]
[null,"A Zulu War-Dance","17-Jul-1877"]
[null,"A Visit to the Chief Secocoeni","17-Jul-1878"]
[null,"Hydrophobia","3-Nov-1885"]
[null,"The Land Question","28-Apr-1886"]
[null,"About Fiction","02-Feb-1887"]
[null,"Mr Rider Haggard and His Critics","27-Apr-1887"]
[null,"American Copyright","27-Apr-1888"]
[null,"Delagoa Bay","17-Dec-1887"]
[null,"Mr. Meeson's Will","18-Jan-1888"]
[null,"The Wreck of the Copeland","18-Aug-1888"]
[null,"Cleopatra","17-Jul-1877"]
[null,"Virgin of the Sun","3-Nov-1885"]
[null,"The Fate of Swaziland","12-Jun-1892"]
[null,"Alan and the Holy Flower","27-Apr-1888"]
[null,"Nada the Lily","3-Nov-1885"]
[null,"She","13-Feb-1887"]
[null,"And Return of She","13-Feb-1888"]
[null,"The People of the Mist","18-Aug-1888"]
[null,"Heart of the World","18-Aug-1888"]