{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Formulas","AGGREGATE","Specific Value","Macros"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"Formulas","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Excel Count Visible Rows"]
[]
["Books","Genre","Author","Price"]
["The Silent Patient","Thriller","Alex Michaelides",13.95]
["Sharp Objects","Mystery","Gillian Flynn",18.989999999999998]
["My Lovely Wife","Psychological Thriller","Samantha Downing",8.99]
["The Outsider","Horror - Mystery","Stephen King",11.99]
["Pet Sematary","Horror","Stephen King",13.49]
["Murder on the Orient Express","Detective","Agatha Christie",6.99]
["Deadly Cross","Detective","James Patterson",14.15]
["3:00 A. M","Thriller","Nick Pirog",8]
["Fair Warning","Crime Fiction","Michael Connelly",14.5]
["Left You Dead","Suspense","Peter James",26.95]
[]
["Formula","Visible Rows"]
["=SUBTOTAL(3,A4:A13)",{"$f":"SUBTOTAL(3,A4:A13)","v":4}]
["=SUBTOTAL(103,A4:A13)",{"$f":"SUBTOTAL(103,A4:A13)","v":4}]
["=SUBTOTAL(2,D4:D13)",{"$f":"SUBTOTAL(2,D4:D13)","v":4}]

{"sheet":"AGGREGATE","index":1,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Excel Count Visible Rows"]
[]
["Books","Genre","Author"]
["The Silent Patient","Thriller","Alex Michaelides"]
["Sharp Objects","Mystery","Gillian Flynn"]
["My Lovely Wife","Psychological Thriller","Samantha Downing"]
["The Outsider","Horror - Mystery","Stephen King"]
["Pet Sematary","Horror","Stephen King"]
["Murder on the Orient Express","Detective","Agatha Christie"]
["Deadly Cross","Detective","James Patterson"]
["3:00 A. M","Thriller","Nick Pirog"]
["Fair Warning","Crime Fiction","Michael Connelly"]
["Left You Dead","Suspense","Peter James"]
[]
["Formula","Visible Rows"]
["=AGGREGATE(3,1,A4:A13)",{"$f":"_xlfn.AGGREGATE(3,1,A4:A13)","v":10}]
["=AGGREGATE(3,3,A4:A13)",{"$f":"_xlfn.AGGREGATE(3,3,A4:A13)","v":10}]
[{"$f":"_xlfn.FORMULATEXT(B18)","v":"=AGGREGATE(3,5,A4:A13)"},{"$f":"_xlfn.AGGREGATE(3,5,A4:A13)","v":10}]
[{"$f":"_xlfn.FORMULATEXT(B19)","v":"=AGGREGATE(3,7,A4:A13)"},{"$f":"_xlfn.AGGREGATE(3,7,A4:A13)","v":10}]

{"sheet":"Specific Value","index":2,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Excel Count Visible Rows"]
[]
["Books","Genre","Author"]
["The Silent Patient","Thriller","Alex Michaelides"]
["Sharp Objects","Mystery","Gillian Flynn"]
["My Lovely Wife","Psychological Thriller","Samantha Downing"]
["The Outsider","Horror - Mystery","Stephen King"]
["Pet Sematary","Horror","Stephen King"]
["Murder on the Orient Express","Detective","Agatha Christie"]
["Deadly Cross","Detective","James Patterson"]
["3:00 A. M","Thriller","Nick Pirog"]
["Fair Warning","Crime Fiction","Michael Connelly"]
["Left You Dead","Suspense","Peter James"]
[]
["Search Key","Detective"]
[]
["Formula","Visible Rows"]
["=SUMPRODUCT(SUBTOTAL(3,OFFSET(B4:B13,ROW(B4:B13)-MIN(ROW(B4:B13)),,1)), --(B4:B13=B15))",{"$f":"SUMPRODUCT(SUBTOTAL(3,OFFSET(B4:B13,ROW(B4:B13)-MIN(ROW(B4:B13)),,1)), --(B4:B13=B15))","v":1}]
["=SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"B\"&ROW(B4:B13))),--(B4:B13=B15))",{"$f":"SUMPRODUCT(SUBTOTAL(103,INDIRECT(\"B\"&ROW(B4:B13))),--(B4:B13=B15))","v":1}]

{"sheet":"Macros","index":3,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Excel Count Visible Rows"]
[]
["Books","Genre","Author"]
["The Silent Patient","Thriller","Alex Michaelides"]
["Sharp Objects","Mystery","Gillian Flynn"]
["My Lovely Wife","Psychological Thriller","Samantha Downing"]
["The Outsider","Horror - Mystery","Stephen King"]
["Pet Sematary","Horror","Stephen King"]
["Murder on the Orient Express","Detective","Agatha Christie"]
["Deadly Cross","Detective","James Patterson"]
["3:00 A. M","Thriller","Nick Pirog"]
["Fair Warning","Crime Fiction","Michael Connelly"]
["Left You Dead","Suspense","Peter James"]
[]
[]
["Visible Rows",{"$f":"COUNTVISIBLE(B4:B13)","v":3}]