{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset-1","Fahrenheit to Celsius","Dataset-2","Area of Circle","Dataset-3","Sum Range","Return Match from InputBox","Average Range","UserForm Multiple Inputs","Store Number Value"],"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":"Dataset-1","index":0,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"List of Temperatures in March"]
[]
[null,"State","City","Average High in °F"]
[null,"Alabama","Birmingham",67]
[null,"Arkansas","Little Rock",64]
[null,"Connecticut","Bridgeport",47]
[null,"Nebraska","Omaha",50]
[null,"New Jersey","Newark",51]
[null,"Illinois","Chicago",46]
[null,"Ohio","Columbus",52]
[null,"Nevada","Silverpeak",62]
[null,"California","Sacramento",65]

{"sheet":"Fahrenheit to Celsius","index":1,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Converting Temperature from Fahrenheit to Celsius"]
[]
[null,"State","City","Average High in °F",null,"City","Average High in °C"]
[null,"Alabama","Birmingham",67,null,"Silverpeak",16.7]
[null,"Arkansas","Little Rock",64]
[null,"Connecticut","Bridgeport",47]
[null,"Nebraska","Omaha",50]
[null,"New Jersey","Newark",51]
[null,"Illinois","Chicago",46]
[null,"Ohio","Columbus",52]
[null,"Nevada","Silverpeak",62]
[null,"California","Sacramento",65]

{"sheet":"Dataset-2","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Radius of Planets"]
[]
[null,"Planet","Radius (km)"]
[null,"Mercury",2439.6999999999998]
[null,"Venus",6051.8]
[null,"Earth",6378.1]
[null,"Mars",3389.5]
[null,"Jupiter",69911]
[null,"Saturn",58232]
[null,"Uranus",25362]
[null,"Neptune",24622]
[null,"Pluto",1188.3]

{"sheet":"Area of Circle","index":3,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Calculating Area of Circle"]
[]
[null,"Planet","Radius (km)",null,"Planet","Area (km2)"]
[null,"Mercury",2439.6999999999998,null,"Earth",127731695.76000001]
[null,"Venus",6051.8]
[null,"Earth",6378.1]
[null,"Mars",3389.5]
[null,"Jupiter",69911]
[null,"Saturn",58232]
[null,"Uranus",25362]
[null,"Neptune",24622]
[null,"Pluto",1188.3]

{"sheet":"Dataset-3","index":4,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Revenue Earned by Top 15 Companies"]
[]
[null,"Rank","Company","Revenue (Billions)"]
[null,1,"Berkshire Hathaway",276.08999999999997]
[null,2,"ICBC",208.13]
[null,3,"Saudi Aramco",400.38]
[null,4,"JPMorgan Chase",124.54]
[null,5,"China Construction Bank",202.07]
[null,6,"Amazon",469.82]
[null,7,"Apple",378.7]
[null,8,"Agricultural Bank of China",181.42]
[null,9,"Bank of America",96.83]
[null,10,"Toyota Motor",281.75]
[null,11,"Alphabet",257.49]
[null,12,"Microsoft",184.9]
[null,13,"Bank of China",152.43]
[null,14,"Samsung Group",244.16]
[null,15,"ExxonMobil",280.51]

{"sheet":"Sum Range","index":5,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,3],[20,1,20,2]]}
[]
[null,"Summing Range by Entering Column Number"]
[]
[null,"Rank","Company","Revenue (Billions)"]
[null,1,"Berkshire Hathaway",276.08999999999997]
[null,2,"ICBC",208.13]
[null,3,"Saudi Aramco",400.38]
[null,4,"JPMorgan Chase",124.54]
[null,5,"China Construction Bank",202.07]
[null,6,"Amazon",469.82]
[null,7,"Apple",378.7]
[null,8,"Agricultural Bank of China",181.42]
[null,9,"Bank of America",96.83]
[null,10,"Toyota Motor",281.75]
[null,11,"Alphabet",257.49]
[null,12,"Microsoft",184.9]
[null,13,"Bank of China",152.43]
[null,14,"Samsung Group",244.16]
[null,15,"ExxonMobil",280.51]
[]
[null,"Sum of Revenue (Billions)",null,3739.2199999999993]

{"sheet":"Return Match from InputBox","index":6,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VLookup Function to Return Match"]
[]
[null,"Rank","Company","Revenue (Billions)"]
[null,1,"Berkshire Hathaway",276.08999999999997]
[null,2,"ICBC",208.13]
[null,3,"Saudi Aramco",400.38]
[null,4,"JPMorgan Chase",124.54]
[null,5,"China Construction Bank",202.07]
[null,6,"Amazon",469.82]
[null,7,"Apple",378.7]
[null,8,"Agricultural Bank of China",181.42]
[null,9,"Bank of America",96.83]
[null,10,"Toyota Motor",281.75]
[null,11,"Alphabet",257.49]
[null,12,"Microsoft",184.9]
[null,13,"Bank of China",152.43]
[null,14,"Samsung Group",244.16]
[null,15,"ExxonMobil",280.51]

{"sheet":"Average Range","index":7,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,3],[20,1,20,2]]}
[]
[null,"Calculating Average of a Range of Numbers"]
[]
[null,"Rank","Company","Revenue (Billions)"]
[null,1,"Berkshire Hathaway",276.08999999999997]
[null,2,"ICBC",208.13]
[null,3,"Saudi Aramco",400.38]
[null,4,"JPMorgan Chase",124.54]
[null,5,"China Construction Bank",202.07]
[null,6,"Amazon",469.82]
[null,7,"Apple",378.7]
[null,8,"Agricultural Bank of China",181.42]
[null,9,"Bank of America",96.83]
[null,10,"Toyota Motor",281.75]
[null,11,"Alphabet",257.49]
[null,12,"Microsoft",184.9]
[null,13,"Bank of China",152.43]
[null,14,"Samsung Group",244.16]
[null,15,"ExxonMobil",280.51]
[]
[null,"Average Revenue (Billions)",null,249.28133333333332]

{"sheet":"UserForm Multiple Inputs","index":8,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Making UserForm with Multiple Inputs"]
[]
[null,"Employee ID","Name","Age","Role","Location"]
[null,"O1001","Jeremy",47,"Operations","New York"]
[null,"C2002","Michelle",32,"Cyber Security","Seattle"]
[null,"S3003","Charlie",25,"Software","California"]
[null,"S3004","Amy",27,"Software","California"]
[null,"I2003","Carlos",28,"IT","Texas"]
[null,"O4005","Cathy",26,"Operations","Texas"]

{"sheet":"Store Number Value","index":9,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Storing Number Value of InputBox to Cell"]
[]
[null,"State","City","Average High in °F"]
[null,"Alabama","Birmingham",67]
[null,"Arkansas","Little Rock",64]
[null,"Connecticut","Bridgeport",47]
[null,"Nebraska","Omaha",50]
[null,"New Jersey","Newark",51]
[null,"Illinois","Chicago",46]
[null,"Ohio","Columbus",52]
[null,"Nevada","Silverpeak",62]
[null,"California","Sacramento",65]