{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["HYPERLINK Function","Name Box","Reference in a Formula","Paste Link","Excel VBA Internal","Excel VBA External","Reference in a Formula External","New York","Boston","Los Angeles"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"HYPERLINK Function","index":0,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of HYPERLINK Function",null,null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sheet Name","Link",null,null,null,null,null,null,null,null,null,null,null,null,"Sheet Name","Link"]
[null,"New York",{"$f":"HYPERLINK(\"#'\"&B5&\"'!A1\",B5)","v":"New York"},null,null,null,null,null,null,null,null,null,null,null,null,"New York","New York"]
[null,"Boston",{"$f":"HYPERLINK(\"#'\"&B6&\"'!A1\",B6)","v":"Boston"},null,null,null,null,null,null,null,null,null,null,null,null,"Boston","Boston"]
[null,"Los Angeles","Los Angeles",null,null,null,null,null,null,null,null,null,null,null,null,"Los Angeles","Los Angeles"]

{"sheet":"Name Box","index":1,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of Name Box",null,null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"City Name","Total Sale",null,null,null,null,null,null,null,null,null,null,null,null,"City Name","Total Sale"]
[null,"New York",{"$f":"NY_Total_Sale","v":1591.97},"=NY_Total_Sale",null,null,null,null,null,null,null,null,null,null,null,"New York"]
[null,"Boston",{"$f":"BT_Total_Sale","v":1307.56},"=BT_Total_Sale",null,null,null,null,null,null,null,null,null,null,null,"Boston"]
[null,"Los Angeles",{"$f":"LA_Total_Sale","v":1380.8600000000001},"=LA_Total_Sale",null,null,null,null,null,null,null,null,null,null,null,"Los Angeles"]

{"sheet":"Reference in a Formula","index":2,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of Cell Reference",null,null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"City Name","Total Sale",null,null,null,null,null,null,null,null,null,null,null,null,"City Name","Total Sale"]
[null,"New York Sale",{"$f":"'New York'!F13","v":1591.97},null,null,null,null,null,null,null,null,null,null,null,null,"New York"]
[null,"Boston Sale",{"$f":"Boston!F13","v":1307.56},null,null,null,null,null,null,null,null,null,null,null,null,"Boston"]
[null,"Los Angeles Sale",{"$f":"'Los Angeles'!F13","v":1380.8600000000001},null,null,null,null,null,null,null,null,null,null,null,null,"Los Angeles"]

{"sheet":"Paste Link","index":3,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of Paste Link Feature",null,null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"City Name","Link",null,null,null,null,null,null,null,null,null,null,null,null,"City Name","Link"]
[null,"New York","Go to sheet New York",null,null,null,null,null,null,null,null,null,null,null,null,"New York","Go to sheet New York"]
[null,"Boston","Go to sheet Boston",null,null,null,null,null,null,null,null,null,null,null,null,"Boston","Go to sheet Boston"]
[null,"Los Angeles","Go to sheet Los Angeles",null,null,null,null,null,null,null,null,null,null,null,null,"Los Angeles","Go to sheet Los Angeles"]

{"sheet":"Excel VBA Internal","index":4,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sheet Name","Link",null,null,null,null,null,null,null,null,null,null,null,null,"Sheet Name","Link"]
[null,"New York","New York",null,null,null,null,null,null,null,null,null,null,null,null,"New York","New York"]
[null,"Boston","Boston",null,null,null,null,null,null,null,null,null,null,null,null,"Boston","Boston"]
[null,"Los Angeles","Los Angeles",null,null,null,null,null,null,null,null,null,null,null,null,"Los Angeles","Los Angeles"]

{"sheet":"Excel VBA External","index":5,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of Excel VBA",null,null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"City Name","Link",null,null,null,null,null,null,null,null,null,null,null,null,"Sheet Name","Link"]
[null,"New York","New York",null,null,null,null,null,null,null,null,null,null,null,null,"New York","New York"]
[null,"Boston","Boston",null,null,null,null,null,null,null,null,null,null,null,null,"Boston","Boston"]
[null,"Los Angeles","Los Angeles",null,null,null,null,null,null,null,null,null,null,null,null,"Los Angeles","Los Angeles"]

{"sheet":"Reference in a Formula External","index":6,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of Cell Reference",null,null,null,null,null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Sheet Name","Total Sale",null,null,null,null,null,null,null,null,null,null,null,null,"City Name","Total Sale"]
[null,"New York",{"$f":"INDIRECT(CONCATENATE(\n\"'[Source Workbook.xlsx]\",B5,\"'!$F$13\"))","v":1589.1000000000001},null,null,null,null,null,null,null,null,null,null,null,null,"New York"]
[null,"Boston",{"$f":"INDIRECT(CONCATENATE(\n\"'[Source Workbook.xlsx]\",B6,\"'!$F$13\"))","v":1307.56},null,null,null,null,null,null,null,null,null,null,null,null,"Boston"]
[null,"Los Angeles",{"$f":"INDIRECT(CONCATENATE(\n\"'[Source Workbook.xlsx]\",B7,\"'!$F$13\"))","v":1380.8600000000001},null,null,null,null,null,null,null,null,null,null,null,null,"Los Angeles"]

{"sheet":"New York","index":7,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"New York City Sale Dec'21"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Sale"]
[null,"2021-12-06","Bran",51,1.87,{"$f":"PRODUCT(D5,E5)","v":95.37}]
[null,"2021-12-07","Oatmeal Raisin",100,2.85,{"$f":"PRODUCT(D6,E6)","v":285}]
[null,"2021-12-13","Whole Wheat",90,3.49,314.10000000000002]
[null,"2021-12-15","Arrowroot",75,2.1800000000000002,163.5]
[null,"2021-12-16","Chocolate Chip",200,1.8699999999999999,374]
[null,"2021-12-17","Whole Wheat",45,3.49,157.05000000000001]
[null,"2021-12-18","Bran",25,1.87,46.75]
[null,"2021-12-19","Salt",55,2.84,156.19999999999999]
[null,null,null,null,"Total Sale",{"$f":"SUM(F5:F12)","v":1591.97}]

{"sheet":"Boston","index":8,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Boston City Sale Dec'21"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Sale"]
[null,"2021-12-06","Bran",70,1.87,{"$f":"PRODUCT(D5,E5)","v":130.9}]
[null,"2021-12-07","Oatmeal Raisin",100,2.8400000000000003,{"$f":"PRODUCT(D6,E6)","v":284.00000000000006}]
[null,"2021-12-13","Whole Wheat",76,3.49,265.24]
[null,"2021-12-14","Chocolate Chip",98,1.87,183.26000000000002]
[null,"2021-12-15","Arrowroot",37,2.1800000000000002,80.660000000000011]
[null,"2021-12-16","Chocolate Chip",275,1.8699999999999999,514.25]
[null,"2021-12-17","Whole Wheat",35,3.49,122.15]
[null,"2021-12-19","Salt",50,2.84,142]
[null,null,null,null,"Total Sale",{"$f":"SUM(F7:F12)","v":1307.56}]

{"sheet":"Los Angeles","index":9,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Los Angeles City Sale Dec'21"]
[]
[null,"Order Date","Product","Quantity","Unit Price","Total Sale"]
[null,"2021-12-06","Bran",83,1.87,{"$f":"PRODUCT(D5,E5)","v":155.21}]
[null,"2021-12-07","Oatmeal Raisin",124,2.8400000000000003,{"$f":"PRODUCT(D6,E6)","v":352.16}]
[null,"2021-12-13","Whole Wheat",25,3.49,87.25]
[null,"2021-12-14","Chocolate Chip",96,1.87,179.52]
[null,"2021-12-15","Arrowroot",34,2.1800000000000002,74.12]
[null,"2021-12-16","Chocolate Chip",245,1.8699999999999999,458.15]
[null,"2021-12-17","Whole Wheat",30,3.49,104.7]
[null,"2021-12-19","Salt",44,2.84,124.96]
[null,null,null,null,"Total Sale",{"$f":"SUM(F6:F12)","v":1380.8600000000001}]