{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["2019","2018","2017","2020","2021","Consolidate Tool","Power Query Outout"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"2019","index":0,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Name","Jan","Feb","Mar"]
[null,"Jack",1350,1145,3421]
[null,"Oliver",1620,2314,1543]
[null,"Leo",1350,2543,2543]
[null,"Anne",1500,2000,2500]
[null,"David",1700,1200,1700]

{"sheet":"2018","index":1,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Name","Jan","Feb","Mar"]
[null,"Jack",1144,1145,3421]
[null,"Oliver",1267,1268,3544]
[null,"Leo",1390,1391,3667]
[null,"Anne",1513,1514,3790]
[null,"David",1636,1637,3913]

{"sheet":"2017","index":2,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Name","Jan","Feb","Mar"]
[null,"Jack",1350,1145,3421]
[null,"Oliver",1620,2314,1543]
[null,"Leo",1350,2543,2543]
[null,"Anne",1500,2000,2500]
[null,"David",1700,1200,1700]

{"sheet":"2020","index":3,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Name","Jan","Feb","Mar"]
[null,"Jack",1144,1145,3421]
[null,"Oliver",1267,1268,3544]
[null,"Leo",1390,1391,3667]
[null,"Anne",1513,1514,3790]
[null,"David",1636,1637,3913]

{"sheet":"2021","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Name","Jan","Feb","Mar"]
[null,"Jack",2312,3214,1664]
[null,"Oliver",2535,3437,1887]
[null,"Leo",2758,3660,2110]
[null,"Anne",2981,3883,2333]
[null,"David",3204,4106,2556]

{"sheet":"Consolidate Tool","index":5,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using Consolidate Tool"]
[]
[null,null,"Jan","Feb","Mar"]
[null,null,{"$f":"'2019'!$C$3","v":1350},{"$f":"'2019'!$D$3","v":1145},{"$f":"'2019'!$E$3","v":3421}]
[null,null,{"$f":"'2020'!$C$3","v":1144},{"$f":"'2020'!$D$3","v":1145},{"$f":"'2020'!$E$3","v":3421}]
[null,null,{"$f":"'2021'!$C$3","v":2312},{"$f":"'2021'!$D$3","v":3214},{"$f":"'2021'!$E$3","v":1664}]
[null,"Jack",{"$f":"SUM(C5:C7)","v":4806},{"$f":"SUM(D5:D7)","v":5504},{"$f":"SUM(E5:E7)","v":8506}]
[null,null,{"$f":"'2019'!$C$4","v":1620},{"$f":"'2019'!$D$4","v":2314},{"$f":"'2019'!$E$4","v":1543}]
[null,null,{"$f":"'2020'!$C$4","v":1267},{"$f":"'2020'!$D$4","v":1268},{"$f":"'2020'!$E$4","v":3544}]
[null,null,{"$f":"'2021'!$C$4","v":2535},{"$f":"'2021'!$D$4","v":3437},{"$f":"'2021'!$E$4","v":1887}]
[null,"Oliver",{"$f":"SUM(C9:C11)","v":5422},{"$f":"SUM(D9:D11)","v":7019},{"$f":"SUM(E9:E11)","v":6974}]
[null,null,{"$f":"'2019'!$C$5","v":1350},{"$f":"'2019'!$D$5","v":2543},{"$f":"'2019'!$E$5","v":2543}]
[null,null,{"$f":"'2020'!$C$5","v":1390},{"$f":"'2020'!$D$5","v":1391},{"$f":"'2020'!$E$5","v":3667}]
[null,null,{"$f":"'2021'!$C$5","v":2758},{"$f":"'2021'!$D$5","v":3660},{"$f":"'2021'!$E$5","v":2110}]
[null,"Leo",{"$f":"SUM(C13:C15)","v":5498},{"$f":"SUM(D13:D15)","v":7594},{"$f":"SUM(E13:E15)","v":8320}]
[null,null,{"$f":"'2019'!$C$6","v":1500},{"$f":"'2019'!$D$6","v":2000},{"$f":"'2019'!$E$6","v":2500}]
[null,null,{"$f":"'2020'!$C$6","v":1513},{"$f":"'2020'!$D$6","v":1514},{"$f":"'2020'!$E$6","v":3790}]
[null,null,{"$f":"'2021'!$C$6","v":2981},{"$f":"'2021'!$D$6","v":3883},{"$f":"'2021'!$E$6","v":2333}]
[null,"Anne",{"$f":"SUM(C17:C19)","v":5994},{"$f":"SUM(D17:D19)","v":7397},{"$f":"SUM(E17:E19)","v":8623}]
[null,null,{"$f":"'2019'!$C$7","v":1700},{"$f":"'2019'!$D$7","v":1200},{"$f":"'2019'!$E$7","v":1700}]
[null,null,{"$f":"'2020'!$C$7","v":1636},{"$f":"'2020'!$D$7","v":1637},{"$f":"'2020'!$E$7","v":3913}]
[null,null,{"$f":"'2021'!$C$7","v":3204},{"$f":"'2021'!$D$7","v":4106},{"$f":"'2021'!$E$7","v":2556}]
[null,"David",{"$f":"SUM(C21:C23)","v":6540},{"$f":"SUM(D21:D23)","v":6943},{"$f":"SUM(E21:E23)","v":8169}]

{"sheet":"Power Query Outout","index":6,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Name","Data.Column1","Data.Column2","Data.Column3","Data.Column4"]
["2019","Name","Jan","Feb","Mar"]
["2019","Jack",1350,1145,3421]
["2019","Oliver",1620,2314,1543]
["2019","Leo",1350,2543,2543]
["2019","Anne",1500,2000,2500]
["2019","David",1700,1200,1700]
["2020","Name","Jan","Feb","Mar"]
["2020","Jack",1144,1145,3421]
["2020","Oliver",1267,1268,3544]
["2020","Leo",1390,1391,3667]
["2020","Anne",1513,1514,3790]
["2020","David",1636,1637,3913]
["2021","Name","Jan","Feb","Mar"]
["2021","Jack",2312,3214,1664]
["2021","Oliver",2535,3437,1887]
["2021","Leo",2758,3660,2110]
["2021","Anne",2981,3883,2333]
["2021","David",3204,4106,2556]