{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["from web","sale-data","pivot table","VBA","pivot_table_VBA","source_table","database"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":"from web","index":0,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Day","Conditions Temperature","Conditions Weather","Comfort Feels Like","Sun Sunrise","Sun Sunset"]
["2022-05-11","20 / 11 °C","Afternoon clouds.","20 °C","05:43:00","20:02:00"]
["2022-05-12","20 / 14 °C","Light rain. Morning clouds.","20 °C","05:41:00","20:03:00"]
["2022-05-13","20 / 15 °C","Light showers. Overcast.","19 °C","05:40:00","20:04:00"]
["2022-05-14","20 / 16 °C","Light showers. Overcast.","19 °C","05:39:00","20:05:00"]
["2022-05-15","23 / 16 °C","Light showers. Cloudy.","24 °C","05:39:00","20:06:00"]
["2022-05-16","28 / 18 °C","Light rain. Clearing skies.","27 °C","05:38:00","20:07:00"]
["2022-05-17","25 / 18 °C","Sunny.","25 °C","05:37:00","20:08:00"]
["2022-05-18","23 / 14 °C","Sunny.","24 °C","05:36:00","20:09:00"]
["2022-05-19","25 / 15 °C","Mostly cloudy.","25 °C","05:35:00","20:10:00"]
["2022-05-20","26 / 16 °C","Light showers. Cloudy.","27 °C","05:34:00","20:11:00"]
["2022-05-21","27 / 16 °C","Rain. Cloudy.","28 °C","05:33:00","20:12:00"]
["2022-05-22","25 / 17 °C","Rain early. Overcast.","26 °C","05:33:00","20:12:00"]
["2022-05-23","25 / 17 °C","Broken clouds.","26 °C","05:32:00","20:13:00"]
["2022-05-24","25 / 17 °C","Breaks of sun late.","25 °C","05:31:00","20:14:00"]
["2022-05-25","26 / 17 °C","Cloudy.","26 °C","05:30:00","20:15:00"]

{"sheet":"sale-data","index":1,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"OrderDate","Product","Category","Quantity","UnitPrice","TotalPrice"]
[null,"2020-01-04","Apple","Fruit",50,1.5,{"$f":"E3*F3","v":75}]
[null,"2020-01-04","Orange","Fruit",87,3.49,{"$f":"E4*F4","v":303.63}]
[null,"2020-01-04","Potato","Vegetable",58,1.87,108.46000000000001]
[null,"2020-01-04","Tomato","Vegetable",82,2.1800000000000002,178.76000000000002]
[null,"2020-01-04","Cabbage","Vegetable",38,1.42,53.959999999999994]
[null,"2020-01-04","Pineapple","Fruit",51,3.1,158.1]
[null,"2020-01-04","Strawberry","Fruit",100,2.95,295]

{"sheet":"pivot table","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sum of Quantity","Column Labels"]
[null,"Row Labels","Fruit","Vegetable","Grand Total"]
[null,"Apple",50,null,50]
[null,"Cabbage",null,38,38]
[null,"Orange",87,null,87]
[null,"Potato",null,58,58]
[null,"Strawberry",100,null,100]
[null,"Tomato",null,82,82]
[null,"Pineapple",51,null,51]
[null,"Grand Total",288,178,466]

{"sheet":"VBA","index":3,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"OrderDate","Product","Category","Quantity","UnitPrice","TotalPrice"]
[null,"2020-01-04","Apple","Fruit",30,1.5,{"$f":"E3*F3","v":45}]
[null,"2020-01-04","Orange","Fruit",87,3.49,{"$f":"E4*F4","v":303.63}]
[null,"2020-01-04","Potato","Vegetable",58,1.87,108.46000000000001]
[null,"2020-01-04","Tomato","Vegetable",82,2.1800000000000002,178.76000000000002]
[null,"2020-01-04","Cabbage","Vegetable",38,1.42,53.959999999999994]
[null,"2020-01-04","Pineapple","Fruit",51,3.1,158.1]
[null,"2020-01-04","Strawberry","Fruit",100,2.95,295]

{"sheet":"pivot_table_VBA","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Sum of Quantity","Column Labels"]
["Row Labels","Fruit","Vegetable","Grand Total"]
["Apple",30,null,30]
["Cabbage",null,38,38]
["Orange",87,null,87]
["Pineapple",51,null,51]
["Potato",null,58,58]
["Strawberry",100,null,100]
["Tomato",null,82,82]
["Grand Total",268,178,446]

{"sheet":"source_table","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Product","UnitPrice"]
[null,"Apple",1.8]
[null,"Orange",3.49]
[null,"Potato",1.87]
[null,"Tomato",2.1800000000000002]
[null,"Cabbage",1.42]
[null,"Pineapple",3.1]
[null,"Strawberry",2.95]

{"sheet":"database","index":6,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"OrderDate","Product","Category","Quantity","UnitPrice","TotalPrice"]
[null,"2020-01-04","Apple","Fruit",50,{"$f":"source_table!C3","v":1.8},{"$f":"E3*F3","v":90},null,null,null," "]
[null,"2020-01-04","Orange","Fruit",87,{"$f":"source_table!C4","v":3.49},{"$f":"E4*F4","v":303.63}]
[null,"2020-01-04","Potato","Vegetable",58,{"$f":"source_table!C5","v":1.87},108.46000000000001]
[null,"2020-01-04","Tomato","Vegetable",82,{"$f":"source_table!C6","v":2.1800000000000002},178.76000000000002]
[null,"2020-01-04","Cabbage","Vegetable",38,{"$f":"source_table!C7","v":1.42},53.959999999999994]
[null,"2020-01-04","Pineapple","Fruit",51,{"$f":"source_table!C8","v":3.1},158.1]
[null,"2020-01-04","Strawberry","Fruit",100,{"$f":"source_table!C9","v":2.95},295]