{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","May","June","July","INDIRECT","VLOOKUP","Total sales","get sheet","Jenny"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Dataset","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Sales Unit (May)","Sales Unit (June)","Sales Unit (July)"]
[null,"Jenny","Apple",15600,30000,7500]
[null,"Mike","Banana",19000,25000,16000]
[null,"Ammy","Avocado",30500,18000,21000]
[null,"Ross","Grapes",19750,26000,19500]
[null,"Colin","Strawberry",20040,15000,25000]
[null,"Diego","Water-melon",18900,12500,14000]
[null,"Total"]

{"sheet":"May","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Sales Unit (May)"]
[null,"Jenny","Apple",15600]
[null,"Mike","Banana",19000]
[null,"Ammy","Avocado",30500]
[null,"Ross","Grapes",19750]
[null,"Colin","Strawberry",20040]
[null,"Diego","Water-melon",18900]
[null,"Total"]

{"sheet":"June","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Sales Unit (June)"]
[null,"Jenny","Apple",30000]
[null,"Mike","Banana",25000]
[null,"Ammy","Avocado",18000]
[null,"Ross","Grapes",26000]
[null,"Colin","Strawberry",15000]
[null,"Diego","Water-melon",12500]
[null,"Total"]

{"sheet":"July","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","Product","Sales Unit (July)"]
[null,"Jenny","Apple",7500]
[null,"Mike","Banana",16000]
[null,"Ammy","Avocado",21000]
[null,"Ross","Grapes",19500]
[null,"Colin","Strawberry",25000]
[null,"Diego","Water-melon",14000]
[null,"Total"]

{"sheet":"INDIRECT","index":4,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Month","Jenny","Mike","Ammy"]
[null,"May",{"$f":"INDIRECT(B6&\"!D6\")","v":15600},{"$f":"INDIRECT(B6&\"!D7\")","v":19000},{"$f":"INDIRECT(B6&\"!D8\")","v":30500}]
[null,"June",{"$f":"INDIRECT(B7&\"!D6\")","v":30000},{"$f":"INDIRECT(B7&\"!D7\")","v":25000},{"$f":"INDIRECT(B7&\"!D8\")","v":18000}]
[null,"July",{"$f":"INDIRECT(B8&\"!D6\")","v":7500},{"$f":"INDIRECT(B8&\"!D7\")","v":16000},{"$f":"INDIRECT(B8&\"!D8\")","v":21000}]
[]
[]
[]
[null,"Total"]

{"sheet":"VLOOKUP","index":5,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Sales Person","May","June","July"]
[null,"Jenny",{"$f":"VLOOKUP($B6,INDIRECT($C$5&\"!B6:D11\"),3,0)","v":15600},{"$f":"VLOOKUP($B6,INDIRECT($D$5&\"!B6:D11\"),3,0)","v":30000},{"$f":"VLOOKUP($B6,INDIRECT($E$5&\"!B6:D11\"),3,0)","v":7500}]
[null,"Mike",{"$f":"VLOOKUP($B7,INDIRECT($C$5&\"!B6:D11\"),3,0)","v":19000},{"$f":"VLOOKUP($B7,INDIRECT($D$5&\"!B6:D11\"),3,0)","v":25000},{"$f":"VLOOKUP($B7,INDIRECT($E$5&\"!B6:D11\"),3,0)","v":16000}]
[null,"Ammy",30500,18000,21000]
[null,"Ross",19750,26000,19500]
[null,"Colin",20040,15000,25000]
[null,"Diego",18900,12500,14000]
[null,"Total"]

{"sheet":"Total sales","index":6,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Month","Jenny","Mike","Ammy"]
[null,"May",{"$f":"INDIRECT(B6&\"!D6\")","v":15600},{"$f":"INDIRECT(B6&\"!D7\")","v":19000},{"$f":"INDIRECT(B6&\"!D8\")","v":30500}]
[null,"June",{"$f":"INDIRECT(B7&\"!D6\")","v":30000},{"$f":"INDIRECT(B7&\"!D7\")","v":25000},{"$f":"INDIRECT(B7&\"!D8\")","v":18000}]
[null,"July",{"$f":"INDIRECT(B8&\"!D6\")","v":7500},{"$f":"INDIRECT(B8&\"!D7\")","v":16000},{"$f":"INDIRECT(B8&\"!D8\")","v":21000}]
[null,"Total Sales",{"$f":"SUM(C6:C8)","v":53100},{"$f":"SUM(D6:D8)","v":60000},69500]
[]
[]
[null,"Total",null,null,null,null,null," "]

{"sheet":"get sheet","index":7,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Index","Sheet Name","Link"]
[null,1,{"$f":"INDEX(Sheet_Name,B6)","v":"Dataset"},{"$f":"HYPERLINK(\"#'\"&C6&\"'!B3\",\"Go To Sheet\")","v":"Go To Sheet"}]
[null,2,{"$f":"INDEX(Sheet_Name,B7)","v":"May"},{"$f":"HYPERLINK(\"#'\"&C7&\"'!B3\",\"Go To Sheet\")","v":"Go To Sheet"}]
[null,3,{"$f":"INDEX(Sheet_Name,B8)","v":"June"},"Go To Sheet"]
[null,4,{"$f":"INDEX(Sheet_Name,B9)","v":"July"},"Go To Sheet"]
[null,5,{"$f":"INDEX(Sheet_Name,B10)","v":"INDIRECT"},"Go To Sheet"]
[null,6,{"$f":"INDEX(Sheet_Name,B11)","v":"VLOOKUP"},"Go To Sheet"]
[null,7,{"$f":"INDEX(Sheet_Name,B12)","v":"Total sales"},"Go To Sheet"]
[null,8,{"$f":"INDEX(Sheet_Name,B13)","v":"Sheet7"},"Go To Sheet"]

{"sheet":"Jenny","index":8,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Sales Data of Amigo Super Store"]
[]
[null,"Month","Jenny"]
[null,"June",{"$f":"INDIRECT(B6&\"!D6\")","v":30000}]
[null,"July",{"$f":"INDIRECT(B7&\"!D6\")","v":7500}]
[null,"July",{"$f":"INDIRECT(B8&\"!D6\")","v":7500}]
[]
[]
[]
[null,"Total"]