{"text_format":"3","workbook":"xlsx","n_sheets":16,"sheets":["Start","1","2","3","4","5","6","7","8","9","10","11","12","13","14","Learn More"],"not_rendered":{"images":13,"defined_names":47},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":5,"n_cols":1,"rows_kept":5}
[]
[]
["Work with stocks"]
["Learn how to use the Stocks data type, which\nlets you get stock prices and other useful information."]
["Go back to top by pressing CTRL+HOME. To start the tour, press CTRL+PAGE DOWN."]

{"sheet":"1","index":1,"n_rows":13,"n_cols":7,"rows_kept":13}
{"$rows_empty":8}
[null,"Company name","Price","Change","Last trade time","52 week high","52 week low"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Price\")","v":{"v":289.79,"d":"$289.79"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Change\")","v":{"v":-0.94,"d":"$(0.94)"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:36.452"},{"$f":"_FV(Table3[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":349.67,"d":"$349.67"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":224.26,"d":"$224.26"}}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Price\")","v":{"v":142.63,"d":"$142.63"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Change\")","v":{"v":-0.17,"d":"$(0.17)"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:35.702"},{"$f":"_FV(Table3[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":179.1,"d":"$179.10"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":125.44,"d":"$125.44"}}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Price\")","v":{"v":210.01,"d":"$210.01"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Change\")","v":{"v":-3.57,"d":"$(3.57)"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:32.622"},{"$f":"_FV(Table3[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":278.5671,"d":"$278.57"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":183.77,"d":"$183.77"}}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Price\")","v":{"v":92.97,"d":"$92.97"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Change\")","v":{"v":-0.08,"d":"$(0.08)"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:36.420"},{"$f":"_FV(Table3[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":126.32,"d":"$126.32"}},{"$f":"_FV(Table3[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":92.42,"d":"$92.42"}}]

{"sheet":"2","index":2,"n_rows":12,"n_cols":7,"rows_kept":12}
{"$rows_empty":7}
[null,"Company name","Price","Change","Last trade time","52 week high","52 week low"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Price\")","v":{"v":289.79,"d":"$289.79"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Change\")","v":{"v":-0.94,"d":"$(0.94)"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:36.452"},{"$f":"_FV(Table319[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":349.67,"d":"$349.67"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":224.26,"d":"$224.26"}}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Price\")","v":{"v":142.63,"d":"$142.63"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Change\")","v":{"v":-0.17,"d":"$(0.17)"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:35.702"},{"$f":"_FV(Table319[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":179.1,"d":"$179.10"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":125.44,"d":"$125.44"}}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Price\")","v":{"v":210.01,"d":"$210.01"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Change\")","v":{"v":-3.57,"d":"$(3.57)"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:32.622"},{"$f":"_FV(Table319[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":278.5671,"d":"$278.57"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":183.77,"d":"$183.77"}}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Price\")","v":{"v":92.97,"d":"$92.97"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Change\")","v":{"v":-0.08,"d":"$(0.08)"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:36.420"},{"$f":"_FV(Table319[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":126.32,"d":"$126.32"}},{"$f":"_FV(Table319[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":92.42,"d":"$92.42"}}]

{"sheet":"3","index":3,"n_rows":16,"n_cols":7,"rows_kept":16}
{"$rows_empty":11}
[null,"Company name","Price","Change","Last trade time","52 week high","52 week low"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Price\")","v":{"v":289.79,"d":"$289.79"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Change\")","v":{"v":-0.94,"d":"$(0.94)"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:36.452"},{"$f":"_FV(Table311[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":349.67,"d":"$349.67"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":224.26,"d":"$224.26"}}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Price\")","v":{"v":142.63,"d":"$142.63"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Change\")","v":{"v":-0.17,"d":"$(0.17)"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:35.702"},{"$f":"_FV(Table311[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":179.1,"d":"$179.10"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":125.44,"d":"$125.44"}}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Price\")","v":{"v":210.01,"d":"$210.01"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Change\")","v":{"v":-3.57,"d":"$(3.57)"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:32.622"},{"$f":"_FV(Table311[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":278.5671,"d":"$278.57"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":183.77,"d":"$183.77"}}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Price\")","v":{"v":92.97,"d":"$92.97"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Change\")","v":{"v":-0.08,"d":"$(0.08)"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:36.420"},{"$f":"_FV(Table311[[#This Row],[Company name]],\"52 week high\",TRUE)","v":{"v":126.32,"d":"$126.32"}},{"$f":"_FV(Table311[[#This Row],[Company name]],\"52 week low\",TRUE)","v":{"v":92.42,"d":"$92.42"}}]

{"sheet":"4","index":4,"n_rows":13,"n_cols":2,"rows_kept":13}
{"$rows_empty":8}
[null,"Company name"]
[null,"MSFT"]
[null,"NKE"]
[null,"BA"]
[null,"SBUX"]

{"sheet":"5","index":5,"n_rows":15,"n_cols":2,"rows_kept":15}
{"$rows_empty":8}
[null,"Company name"]
[null,"MSFT"]
[null,"NKE"]
[null,"BA"]
[null,"SBUX"]
[]
[null,{"$f":"IFERROR(IF(AND(_FV($B$10,\"Name\")=\"Microsoft Corp\",_FV($B$13,\"Name\")=\"Starbucks Corp\"),\"Good job!\",\" \"),\" \")","v":" "}]

{"sheet":"6","index":6,"n_rows":15,"n_cols":6,"rows_kept":15}
{"$rows_empty":8}
[{"$nulls":4},"Company name"]
[{"$nulls":4},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"}]
[]
[{"$nulls":5},{"$f":"IFERROR(IF(AND(F9=\"Price\",F13>0.01),\"Good!\",\" \"),\" \")","v":" "}]

{"sheet":"7","index":7,"n_rows":15,"n_cols":8,"rows_kept":15}
{"$rows_empty":8}
[{"$nulls":4},"Company name","Price"]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"_FV(Table79126[[#This Row],[Company name]],\"Price\")","v":{"v":289.79,"d":"$289.79"}}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"_FV(Table79126[[#This Row],[Company name]],\"Price\")","v":{"v":142.63,"d":"$142.63"}}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"_FV(Table79126[[#This Row],[Company name]],\"Price\")","v":{"v":210.01,"d":"$210.01"}}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"_FV(Table79126[[#This Row],[Company name]],\"Price\")","v":{"v":92.97,"d":"$92.97"}}]
[]
[{"$nulls":6},{"$f":"IFERROR(IF(G9=\"Change\",\"Nice!\",\" \"),\" \")","v":" "},{"$f":"IFERROR(IF(H9=\"Last trade time\",\"Great!\",\" \"),\" \")","v":" "}]

{"sheet":"8","index":8,"n_rows":13,"n_cols":7,"rows_kept":13}
{"$rows_empty":8}
[{"$nulls":4},"Company name","Price","Change"]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"_FV(Table7912613[[#This Row],[Company name]],\"Price\")","v":{"v":289.79,"d":"$289.79"}},{"$f":"_FV(Table7912613[[#This Row],[Company name]],\"Change\")","v":{"v":-0.94,"d":"$(0.94)"}}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"_FV(Table7912613[[#This Row],[Company name]],\"Price\")","v":{"v":142.63,"d":"$142.63"}},{"$f":"_FV(Table7912613[[#This Row],[Company name]],\"Change\")","v":{"v":-0.17,"d":"$(0.17)"}}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"_FV(Table7912613[[#This Row],[Company name]],\"Price\")","v":{"v":210.01,"d":"$210.01"}},{"$f":"_FV(Table7912613[[#This Row],[Company name]],\"Change\")","v":{"v":-3.57,"d":"$(3.57)"}}]
[{"$nulls":4},{"$error":"#VALUE!"},{"$f":"_FV(Table7912613[[#This Row],[Company name]],\"Price\")","v":{"v":92.97,"d":"$92.97"}},{"$f":"_FV(Table7912613[[#This Row],[Company name]],\"Change\")","v":{"v":-0.08,"d":"$(0.08)"}}]

{"sheet":"9","index":9,"n_rows":98,"n_cols":6,"rows_kept":98}
{"$rows_empty":9}
[{"$nulls":5},{"$f":"IFERROR(_xlfn.IFS(_xlfn.FORMULATEXT($F$12)=\"=B12.[52 week high]\",\"Nice!\",_xlfn.FORMULATEXT($F$12)=\"=B12.52 week high\",\"Good!\"),\" \")","v":" "}]
[null,"Company name","Price","Change","Last trade time","52 week high"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Price\")","v":{"v":289.79,"d":"$289.79"}},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Change\")","v":{"v":-0.94,"d":"$(0.94)"}},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:36.452"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Price\")","v":{"v":142.63,"d":"$142.63"}},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Change\")","v":{"v":-0.17,"d":"$(0.17)"}},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:35.702"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Price\")","v":{"v":210.01,"d":"$210.01"}},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Change\")","v":{"v":-3.57,"d":"$(3.57)"}},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:32.622"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Price\")","v":{"v":92.97,"d":"$92.97"}},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Change\")","v":{"v":-0.08,"d":"$(0.08)"}},{"$f":"_FV(Table31118[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:36.420"}]
{"$rows_empty":82}
[{"$nulls":5},{"$f":"_xlfn.FORMULATEXT(F12)","v":{"$error":"#N/A"}}]

{"sheet":"10","index":10,"n_rows":100,"n_cols":6,"rows_kept":100}
{"$rows_empty":10}
[{"$nulls":5},{"$f":"IFERROR(_xlfn.IFS(_xlfn.FORMULATEXT($F$13)=\"=B13.[Employees]\",\"Nice!\",_xlfn.FORMULATEXT($F$13)=\"=B13.Employees\",\"Good!\"),\" \")","v":" "}]
[null,"Company name","Price","Change","Last trade time","Employees"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Price\")","v":{"v":289.79,"d":"$289.79"}},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Change\")","v":{"v":-0.94,"d":"$(0.94)"}},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:36.452"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Price\")","v":{"v":142.63,"d":"$142.63"}},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Change\")","v":{"v":-0.17,"d":"$(0.17)"}},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:35.702"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Price\")","v":{"v":210.01,"d":"$210.01"}},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Change\")","v":{"v":-3.57,"d":"$(3.57)"}},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:32.622"}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Price\")","v":{"v":92.97,"d":"$92.97"}},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Change\")","v":{"v":-0.08,"d":"$(0.08)"}},{"$f":"_FV(Table3111815[[#This Row],[Company name]],\"Last trade time\",TRUE)","v":"2022-02-18T17:13:36.420"}]
{"$rows_empty":83}
[{"$nulls":5},{"$f":"_xlfn.FORMULATEXT(F13)","v":{"$error":"#N/A"}}]

{"sheet":"11","index":11,"n_rows":13,"n_cols":6,"rows_kept":13}
[]
[]
[]
[]
[]
[]
[{"$nulls":5},{"$f":"IFERROR(IF(AND(F9=\"Price\",F13>0.01),\"Good!\",\" \"),\" \")","v":" "}]
[]
[{"$nulls":4},"Company name"]
[{"$nulls":4},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"}]
[{"$nulls":4},{"$error":"#VALUE!"}]

{"sheet":"12","index":12,"n_rows":17,"n_cols":5,"rows_kept":17}
{"$rows_empty":12}
[null,null,{"$f":"IFERROR(IF(C14=\"Price\",\"Good!\",\" \"),\" \")","v":" "},{"$f":"IFERROR(IF(D14=\"Change\",\"Great!\",\" \"),\" \")","v":" "},{"$f":"IFERROR(IF(E14=\"Last trade time\",\"Nice job!\",\" \"),\" \")","v":" "}]
[null,"Name"]
[null,"MSFT"]
[null,"NKE"]
[null,"BA"]

{"sheet":"13","index":13,"n_rows":18,"n_cols":4,"rows_kept":18}
{"$rows_empty":11}
[null,null,{"$f":"IFERROR(IF(C13=\"Instrument type\",\"Nice work!\",\" \"),\" \")","v":" "},{"$f":"IFERROR(IF(D13=\"Expense Ratio\",\"Nice work!\",\" \"),\" \")","v":" "}]
[null,"Name"]
[null,"SBUX"]
[null,"VBMFX"]
[null,"VTSMX"]
[null,"VGTSX"]
[null,"MSFT"]

{"sheet":"14","index":14,"n_rows":100,"n_cols":7,"rows_kept":100}
{"$rows_empty":13}
[{"$nulls":3},{"$f":"IFERROR(_xlfn.IFS($D$100=\"=B16.Change\",\"Good!\",$D$100=\"=B16.[Change]\",\"Good!\"),\" \")","v":" "},{"$f":"IFERROR(_xlfn.IFS($E$100=\"=B16.Last Trade Time\",\"Good!\",$E$100=\"=B16.[Last Trade Time]\",\"Nice!\"),\" \")","v":" "}]
[null,"Company name","Price","Change","Last trade time","GMT difference","Local time"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B16,\"Price\")","v":{"v":289.79,"d":"$289.79"}},{"$nulls":3},{"$f":"E16+(F16/24)","v":"00:00:00"}]
[]
[{"$nulls":4},{"$f":"IF($D$18=TRUE,\"Good!\",\" \")","v":" "}]
{"$rows_empty":81}
[{"$nulls":3},{"$f":"_xlfn.FORMULATEXT(Table202223[Change])","v":{"$error":"#N/A"}},{"$f":"_xlfn.FORMULATEXT(E16)","v":{"$error":"#N/A"}}]

{"sheet":"Learn More","index":15,"n_rows":14,"n_cols":6,"rows_kept":14}
{"$rows_empty":9}
[null,"Related articles",null,"Other helpful information",null,"More resources"]
[null,"Get a stock quote",null,"About the geography data type",null,"Training courses"]
[null,"Write formulas against data types",{"$nulls":3},"Tech community"]
[null,"FIELDVALUE function",{"$nulls":3},"Excel blog"]
[null,"#FIELD! error"]