{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["www","Sales of Jan","Sales of Feb","Pivot_Jan","Pivot_Feb","All Sales","Multiple Sheet"],"not_rendered":{"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"www","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"hidden":true}
["Date","Region","Category","Product","Unit Price","Quantity","Total Price"]
["2024-01-02","East","Fruits","Apple",{"v":2,"d":"$2"},40,{"v":80,"d":"$80"}]
["2024-01-04","West","Bakery","Bread",{"v":3,"d":"$3"},20,{"v":60,"d":"$60"}]
["2024-01-06","North","Dairy","Milk",{"v":4,"d":"$4"},15,{"v":60,"d":"$60"}]
["2024-01-08","East","Fruits","Banana",{"v":1,"d":"$1"},50,{"v":50,"d":"$50"}]
["2024-01-11","South","Bakery","Muffin",{"v":2,"d":"$2"},25,{"v":50,"d":"$50"}]
["2024-01-14","West","Dairy","Cheese",{"v":5,"d":"$5"},10,{"v":50,"d":"$50"}]
["2024-01-18","North","Fruits","Orange",{"v":3,"d":"$3"},30,{"v":90,"d":"$90"}]
["2024-01-21","East","Bakery","Cake",{"v":10,"d":"$10"},5,{"v":50,"d":"$50"}]
["2024-01-25","South","Dairy","Yogurt",{"v":2,"d":"$2"},18,{"v":36,"d":"$36"}]
["2024-01-29","West","Fruits","Apple",{"v":2,"d":"$2"},35,{"v":70,"d":"$70"}]

{"sheet":"Sales of Jan","index":1,"n_rows":11,"n_cols":7,"rows_kept":11}
["Date","Region","Category","Product","Unit Price","Quantity","Total Price"]
["2024-01-02","East","Fruits","Apple",{"v":2,"d":"$2"},40,{"v":80,"d":"$80"}]
["2024-01-04","West","Bakery","Bread",{"v":3,"d":"$3"},20,{"v":60,"d":"$60"}]
["2024-01-06","North","Dairy","Milk",{"v":4,"d":"$4"},15,{"v":60,"d":"$60"}]
["2024-01-08","East","Fruits","Banana",{"v":1,"d":"$1"},50,{"v":50,"d":"$50"}]
["2024-01-11","South","Bakery","Muffin",{"v":2,"d":"$2"},25,{"v":50,"d":"$50"}]
["2024-01-14","West","Dairy","Cheese",{"v":5,"d":"$5"},10,{"v":50,"d":"$50"}]
["2024-01-18","North","Fruits","Orange",{"v":3,"d":"$3"},30,{"v":90,"d":"$90"}]
["2024-01-21","East","Bakery","Cake",{"v":10,"d":"$10"},5,{"v":50,"d":"$50"}]
["2024-01-25","South","Dairy","Yogurt",{"v":2,"d":"$2"},18,{"v":36,"d":"$36"}]
["2024-01-29","West","Fruits","Apple",{"v":2,"d":"$2"},35,{"v":70,"d":"$70"}]

{"sheet":"Sales of Feb","index":2,"n_rows":11,"n_cols":7,"rows_kept":11}
["Date","Region","Category","Product","Unit Price","Quantity","Total Price"]
["2024-02-01","East","Fruits","Banana",{"v":1,"d":"$1"},60,{"v":60,"d":"$60"}]
["2024-02-03","South","Bakery","Muffin",{"v":2,"d":"$2"},22,{"v":44,"d":"$44"}]
["2024-02-05","West","Dairy","Milk",{"v":4,"d":"$4"},18,{"v":72,"d":"$72"}]
["2024-02-09","North","Fruits","Orange",{"v":3,"d":"$3"},28,{"v":84,"d":"$84"}]
["2024-02-12","East","Bakery","Bread",{"v":3,"d":"$3"},24,{"v":72,"d":"$72"}]
["2024-02-15","West","Fruits","Apple",{"v":2,"d":"$2"},45,{"v":90,"d":"$90"}]
["2024-02-18","South","Dairy","Cheese",{"v":6,"d":"$6"},9,{"v":54,"d":"$54"}]
["2024-02-21","East","Dairy","Yogurt",{"v":2,"d":"$2"},25,{"v":50,"d":"$50"}]
["2024-02-24","North","Bakery","Cake",{"v":9,"d":"$9"},6,{"v":54,"d":"$54"}]
["2024-02-27","West","Fruits","Banana",{"v":1,"d":"$1"},55,{"v":55,"d":"$55"}]

{"sheet":"Pivot_Jan","index":3,"n_rows":9,"n_cols":6,"rows_kept":9}
[]
[]
["Sum of Total Price","Column Labels"]
["Row Labels","East","North","South","West","Grand Total"]
["Jan"]
["Bakery",{"v":50,"d":"$50"},null,{"v":50,"d":"$50"},{"v":60,"d":"$60"},{"v":160,"d":"$160"}]
["Dairy",null,{"v":60,"d":"$60"},{"v":36,"d":"$36"},{"v":50,"d":"$50"},{"v":146,"d":"$146"}]
["Fruits",{"v":130,"d":"$130"},{"v":90,"d":"$90"},null,{"v":70,"d":"$70"},{"v":290,"d":"$290"}]
["Grand Total",{"v":180,"d":"$180"},{"v":150,"d":"$150"},{"v":86,"d":"$86"},{"v":180,"d":"$180"},{"v":596,"d":"$596"}]

{"sheet":"Pivot_Feb","index":4,"n_rows":9,"n_cols":6,"rows_kept":9}
[]
[]
["Sum of Total Price","Column Labels"]
["Row Labels","East","North","South","West","Grand Total"]
["Feb"]
["Bakery",{"v":72,"d":"$72"},{"v":54,"d":"$54"},{"v":44,"d":"$44"},null,{"v":170,"d":"$170"}]
["Dairy",{"v":50,"d":"$50"},null,{"v":54,"d":"$54"},{"v":72,"d":"$72"},{"v":176,"d":"$176"}]
["Fruits",{"v":60,"d":"$60"},{"v":84,"d":"$84"},null,{"v":145,"d":"$145"},{"v":289,"d":"$289"}]
["Grand Total",{"v":182,"d":"$182"},{"v":138,"d":"$138"},{"v":98,"d":"$98"},{"v":217,"d":"$217"},{"v":635,"d":"$635"}]

{"sheet":"All Sales","index":5,"n_rows":2,"n_cols":5,"rows_kept":2}
["Sales of Bakery Items in East Region",null,"Region","Category","Sales of Bakery Items in East Region"]
[{"$f":"GETPIVOTDATA(\"Total Price\",Pivot_Jan!$A$3,\"Category\",\"Bakery\",\"Region\",\"East\")","v":{"v":50,"d":"$50"}},null,"North","Fruits",{"$f":"GETPIVOTDATA(\"Total Price\",Pivot_Jan!$A$3,\"Category\",D2,\"Region\",C2)","v":{"v":90,"d":"$90"}}]

{"sheet":"Multiple Sheet","index":6,"n_rows":2,"n_cols":2,"rows_kept":2}
["Month","Grand Total"]
["Feb",{"$f":"GETPIVOTDATA(\"Total Price\",INDIRECT(\"Pivot_\" & A2 & \"!$A$3\"))","v":{"v":635,"d":"$635"}}]