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

{"sheet":"Start","index":0,"n_rows":4,"n_cols":1,"rows_kept":4}
["Welcome\nInstructions for screen readers: After you go through the tip sheets in this tutorial, you'll learn how to work with stocks in Excel. The instructions for each sheet start in cell A1, and each subsequent step is in cell A2, A3, and so on. \nThe instructions will indicate which cells to navigate to for use of a feature, or further reading.\nTo start, press CTRL+PAGE DOWN."]
["Work with linked data types"]
["Learn how to use linked data types powered by Wolfram, which let you \neasily gather and analyze the information you need without ever leaving Excel."]
["Go back to top by pressing CTRL+HOME. To start the learning guide, press CTRL+PAGE DOWN."]

{"sheet":"1","index":1,"n_rows":15,"n_cols":4,"rows_kept":15}
["Ever wanted easy access to data on hundreds of topics directly in Excel? Data types makes this possible. "]
["Below is a table of cells converted to the Locations data type, B11 to D15, with headers: Location Name, Country, and Population. Columns C and D grab info from the data types in column B."]
["A label that points to cells B12 through B15 says, \"Each of these cells have an icon, which means they're data types, specifically Locations data types.\""]
["IMPORTANT: If a cell contains #NAME?, check that you meet the requirements to use linked data types."]
["Check requirements"]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
[]
[]
[]
[]
[null,"Location Name","Country","Population"]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B12,\"country/region\",TRUE)","v":{"$error":"#VALUE!"}},{"$f":"_FV(B12,\"city population\",TRUE)","v":64291}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B13,\"country/region\",TRUE)","v":{"$error":"#VALUE!"}},{"$f":"_FV(B13,\"city population\",TRUE)","v":8622698}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B14,\"country/region\",TRUE)","v":{"$error":"#VALUE!"}},{"$f":"_FV(B14,\"city population\",TRUE)","v":2206488}]
[null,{"$error":"#VALUE!"},{"$f":"_FV(B15,\"country/region\",TRUE)","v":{"$error":"#VALUE!"}},{"$f":"_FV(B15,\"city population\",TRUE)","v":8673713}]

{"sheet":"2","index":2,"n_rows":13,"n_cols":7,"rows_kept":13}
["When you use a data type, you can insert facts in to your workbook and use this data tables, charts, and more. Below is another table in cells D9 to G13, using the Space data type."]
["Cells D9 through G13 contain data. There are column headers titled Planet Name, Gravity, Age in years, and Solar Day in hours."]
["There is a label pointing to cells D10 through C13 that says, \"The cells in this first column use the Space data type.\""]
["There is a bracket label pointing to columns E, F, and G that says, \"Each of these columns extracts info from the cells in the first column, column C.\""]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
[]
[]
[]
[{"$nulls":3},"Planet Name","Gravity","Age (Years)","Solar Day (Hr)"]
[{"$nulls":3},{"$error":"#VALUE!"},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"gravity\")","v":9.8},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"age\")","v":{"v":4540000000,"d":"4.54E+09"}},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"solar day\",TRUE)","v":{"v":24.000000194226203,"d":"24.00"}}]
[{"$nulls":3},{"$error":"#VALUE!"},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"gravity\")","v":3.71},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"age\")","v":{"v":4500000000,"d":"4.50E+09"}},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"solar day\",TRUE)","v":{"v":24.659789940136267,"d":"24.66"}}]
[{"$nulls":3},{"$error":"#VALUE!"},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"gravity\")","v":10.44},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"age\")","v":{"v":4500000000,"d":"4.50E+09"}},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"solar day\",TRUE)","v":{"v":10.656679922371268,"d":"10.66"}}]
[{"$nulls":3},{"$error":"#VALUE!"},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"gravity\")","v":11.15},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"age\")","v":{"v":4500000000,"d":"4500000000.00"}},{"$f":"_FV(Table319[[#This Row],[Planet Name]],\"solar day\",TRUE)","v":{"v":16.110179663611493,"d":"16.11"}}]

{"sheet":"3","index":3,"n_rows":13,"n_cols":2,"rows_kept":13}
["So how do you use these data types? First, enter the text that you want to learn more about in the cells. Here, we'll use the Foods data type."]
["Cells B9 through B13 contain data. There is one column labeled \"Food.\""]
["There is a bracket label pointing to the table of data that says, \"We entered types of foods into these cells.\""]
["BRING INFO IN: Enter text in cells or paste text from somewhere else. You can also convert text in an existing workbook. Here we typed in the food names."]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
[]
[]
[]
[null,"Food"]
[null,"Apple"]
[null,"Banana"]
[null,"Carrot"]
[null,"Rice"]

{"sheet":"4","index":4,"n_rows":15,"n_cols":2,"rows_kept":15}
["After entering foods in a column, you can convert that text into a data type. Try it out below. "]
["Cells B9 through B13 contain data. There is one column titled Food and there are four foods below: Apple, Banana, Carrot, and Rice."]
["TRY THIS: Select B10 through B13. Then, press ALT+A D1 to navigate to the Data Types gallery and select Foods."]
["When you're done, a Food icon will appear next to each Food."]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
[]
[]
[]
[null,"Food"]
[null,"Apple"]
[null,"Banana"]
[null,"Carrot"]
[null,"Rice"]
[]
[null,{"$f":"IFERROR(IF(AND(_FV($B$10,\"Name\")=\"Apple\",_FV($B$12,\"Name\")=\"Peanutbutter\"),\"Good job!\",\" \"),\" \")","v":" "}]

{"sheet":"5","index":5,"n_rows":13,"n_cols":6,"rows_kept":13}
["Now that you have the Foods data type, you can extract data about these foods and add them to the workbook. Give it a shot!"]
["Cells F9 through F13 contain data. There is one column titled Food name and there are four foods below: Apple, Banana, Carrot, and Rice."]
["TRY THIS: Select the four cells from F9 to F13. Then, press Alt+Shift+F10 to Add Column."]
["A drop-down menu will appear. Using your keyboard navigate to Fiber, total and press enter. You'll get the total fiber in a service for each food added as a column."]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
[]
[]
[]
[{"$nulls":5},"Food name"]
[{"$nulls":5},{"$error":"#VALUE!"}]
[{"$nulls":5},{"$error":"#VALUE!"}]
[{"$nulls":5},{"$error":"#VALUE!"}]
[{"$nulls":5},{"$error":"#VALUE!"}]

{"sheet":"6","index":6,"n_rows":13,"n_cols":6,"rows_kept":13}
["Use the data type card to view and add info. The card that displays a nice snapshot of each available field, including values for each. "]
["Cells F9 through F13 contain data. There is one column titled Food name and there are four foods below: Apple, Banana, Carrot, and Rice."]
["TRY THIS: Select cell F10 and press CTRL+Shift+F5 to open the card. Tab through the list of fields and navigate to Calories, then to Calories, total. Tab to the Extract Field to Grid option and press enter to add it to the table."]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
[]
[]
[]
[]
[{"$nulls":5},"Food name"]
[{"$nulls":5},{"$error":"#VALUE!"}]
[{"$nulls":5},{"$error":"#VALUE!"}]
[{"$nulls":5},{"$error":"#VALUE!"}]
[{"$nulls":5},{"$error":"#VALUE!"}]

{"sheet":"7","index":7,"n_rows":100,"n_cols":6,"rows_kept":100}
["You can also use formulas to get info from data types. Just follow the instructions below carefully, and you'll get the hang of it."]
["Cells C12 through F16 contain data. There are four columns: Food name, protien total, common serving description, and calories total. Each column has various values for each row except the last column, calories total, which is empty."]
["TRY THIS: In the yellow cell below (F13), type =C13 and then press the down arrow key until you reach Calories, total. Then press the TAB key to select it and press Enter to insert the total calories for apples into the table. The rows below it should automatically fill out, too."]
["If the formula didn't fill down to F14 to F16 when you pressed Enter, select cells F13 through F16 and then press CTRL + D to fill the formula down."]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
[]
[]
[]
[]
[]
[]
[null,null,"Food name","protien, total","Common serving description","Calories, total"]
[null,null,{"$error":"#VALUE!"},{"$f":"_FV(C13,\"protein, total\",TRUE)","v":0.17200000000000001},{"$f":"_FV(C13,\"common serving description\",TRUE)","v":"1 medium item (172 g)"}]
[null,null,{"$error":"#VALUE!"},{"$f":"_FV(C14,\"protein, total\",TRUE)","v":2.3028153846153847},{"$f":"_FV(C14,\"common serving description\",TRUE)","v":"1 medium item (118 g)"}]
[null,null,{"$error":"#VALUE!"},{"$f":"_FV(C15,\"protein, total\",TRUE)","v":0.9984},{"$f":"_FV(C15,\"common serving description\",TRUE)","v":"3/4 items (117 g)"}]
[null,null,{"$error":"#VALUE!"},{"$f":"_FV(C16,\"protein, total\",TRUE)","v":7.900987499999999},{"$f":"_FV(C16,\"common serving description\",TRUE)","v":"0.625 cups (98.75 g)"}]
{"$rows_empty":83}
[{"$nulls":4},{"$f":"_xlfn.FORMULATEXT(F13)","v":{"$error":"#N/A"}}]

{"sheet":"8","index":8,"n_rows":100,"n_cols":6,"rows_kept":100}
["Quickly add data types in tables. By adding text to the next row of a table, Excel will automatically convert and pull values for that data type. You can even add modifiers!"]
["Cells C12 through F15 contain data. There are four columns: Food name, protien total, common serving description, and calories total. Each row has data for each food in column B. B16 is a yellow cell, followed by an empty row."]
["TRY THIS: In the yellow cell below (B16), type '20 grams of tomatoes' and press Enter. While the info is loading, the cells will say #FIELD!. Once it's loaded, 20 grams of tomatoes will be added to the table as a Food data type, including info for all the fields already in the table."]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
{"$rows_empty":7}
[null,null,"Food name","protien, total","Common serving description","Calories, total"]
[null,null,{"$error":"#VALUE!"},{"$f":"_FV(C13,\"protein, total\",TRUE)","v":0.17200000000000001},{"$f":"_FV(C13,\"common serving description\",TRUE)","v":"1 medium item (172 g)"},{"$f":"_FV(C13,\"calories, total\",TRUE)","v":126.23853211009175}]
[null,null,{"$error":"#VALUE!"},{"$f":"_FV(C14,\"protein, total\",TRUE)","v":2.3028153846153847},{"$f":"_FV(C14,\"common serving description\",TRUE)","v":"1 medium item (118 g)"},{"$f":"_FV(C14,\"calories, total\",TRUE)","v":198.33076923076922}]
[null,null,{"$error":"#VALUE!"},{"$f":"_FV(C15,\"protein, total\",TRUE)","v":0.9984},{"$f":"_FV(C15,\"common serving description\",TRUE)","v":"3/4 items (117 g)"},{"$f":"_FV(C15,\"calories, total\",TRUE)","v":30}]
[{"$nulls":3},{"$f":"_FV(C16,\"protein, total\",TRUE)","v":{"$error":"#VALUE!"}},{"$f":"_FV(C16,\"common serving description\",TRUE)","v":{"$error":"#VALUE!"}},{"$f":"_FV(C16,\"calories, total\",TRUE)","v":{"$error":"#VALUE!"}}]
{"$rows_empty":83}
[{"$nulls":4},{"$f":"_xlfn.FORMULATEXT(F13)","v":"=C13.[calories, total]"}]

{"sheet":"9","index":9,"n_rows":18,"n_cols":5,"rows_kept":18,"merged":[[2,1,3,8],[5,3,5,5],[5,6,5,8]]}
["Practice: Let's use the Universities data type."]
["Cells B15 through B18 contain data. There is one column labeled Univerisities (B15) and listed underneath is University of Washington, The College of New Jersey, and Oxford Unviersity."]
["STEP 1: Select the four cells below (B15 to B18) and insert a table by pressing ALT+N T.  Make sure to check the box for My table has headers (use SPACE to toggle) and then select OK. "]
["2: With those cells still selected (B15 to B18), press ALT+A D1 to navigate to the Data Types gallery, then select University. When your'e done, university icons will appear to the left of the university names. "]
["3: Question mark icons next to data types means they're unresolved. Select the University of Washington (B16) and press CTRL+Shift+F5 to open the Data Selector pane. Tab to the first option, University of Washington Seattle and press Enter to resolve the data type."]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},{"$f":"IFERROR(IF(E14=\"Last trade time\",\"Nice job!\",\" \"),\" \")","v":" "}]
[]
[null,"Universities and Colleges"]
[null,"University of Washington"]
[null,"The College of New Jersey"]
[null,"University of Oxford"]

{"sheet":"10","index":10,"n_rows":18,"n_cols":2,"rows_kept":18,"merged":[[2,1,3,9],[5,2,5,3],[5,4,5,6]]}
["Practice: Use the Space data type."]
["Cell B15 to B18 are in a table and contain data. The column is titled Planet Name (B15) and listed below are the planets Saturn, Jupiter, and Earth."]
["1: Convert B16 to B18 to data typed by selecting B16 to B18, pressing ALT+A to open the data tab, and then D1 to open the Data types drop down. Then select Space."]
["2: Select Saturn (B16) and press Ctrl + Shift + F5 to open its card. Locate the Ring Properties group, find Ring System Width, and press tab to navigate to the Insert Data button. Press Enter to add it to the table."]
["3: To find the units for info from a data type, navigate back to the card by pressing Ctrl + Shift + F5 and tab back to Ring Properties and then Ring System Width. The units are listed in the Ring System Width heading. Edit cell C15 to add the units to the column heading in parentheses."]
["Note: Since Earth doesn't have any rings, Excel returns the #FIELD! error."]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
{"$rows_empty":7}
[null,"Planet Name"]
[null,"Saturn"]
[null,"Jupiter"]
[null,"Earth"]

{"sheet":"11","index":11,"n_rows":100,"n_cols":5,"rows_kept":100}
["Practice: Use the Movies data type."]
["Cells B12 to B16 are in a table and contain data. The column header says Movie Name and below the following movies are listed: Moonlight (2016), Titanic (1997), and The Prestige."]
["1: Select cell B16 and press Alt+Shift+F10 to use the Add Column or Insert Data button. Tab down to Image and press enter to add the image for all the movies. You can adjust the size of the images by adjusting the row height. Adjust row height by selecting a cell in the row, pressing ALT + H + O + H, and entering the new row height, then pressing enter to adjust row height."]
["2: Select B16 again and use the Add Column or Insert Data button again (Alt+Shift+F10) to add Release Date info."]
["3: In cell E15, type Days Since Release. In E16, type the formula =DAYS(TODAY(), D16) and press enter."]
["Now cells E16 through E18 display the number of says since each movie was released based on today's date."]
["If the formula didn't fill down when you pressed Enter, select cells E16 to E18 and then press CTRL + D to fill the formula down."]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]
[]
[]
[]
[]
[]
[]
[null,"Movie name"]
[null,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"}]
{"$rows_empty":81}
[{"$nulls":3},{"$f":"_xlfn.FORMULATEXT(#REF!)","v":{"$error":"#REF!"}},{"$f":"_xlfn.FORMULATEXT(E14)","v":{"$error":"#N/A"}}]

{"sheet":"Explore","index":12,"n_rows":6,"n_cols":1,"rows_kept":6}
["Explore: Use data types in their natural habitat."]
["The next sheet is set up so you can play around with what it would be like to use data types in your workbok."]
["Explore the sample data, practice what you've learned, and discover what other kinds of data types powered by Wolfram are available. Try making tables, converting to data types, and extracting info from data types."]
["Refer back to previous sheets in the workbook if you get stuck, or check out the Learn More sheet for links with more info."]
["Not sure what data type to use? Use the Automatic button and Excel will try the make the best match. Remember to resolve any data types if they have a question mark."]
["To continue with this tutorial, press CTRL + PAGE DOWN. To go to the previous sheet, press CTRL + PAGE UP."]

{"sheet":"12","index":13,"n_rows":24,"n_cols":1,"rows_kept":24,"merged":[[5,0,5,11],[6,0,6,11],[14,0,14,11],[15,0,15,11]]}
[]
[]
[]
["Convert to the Chemistry data type and extract info with the Insert Data button and by opening their cards.  "]
[]
["Elements"]
["Try things like atomic symbol, atomic number, boiling point, discovery year, and image."]
["Name"]
["bismuth"]
["carbon"]
["cobalt"]
["Ne"]
["hydrogen"]
[]
["Compounds"]
["Try things like melting point, isomers, alternate names, and element types."]
["Name"]
["dihydrogen monoxide"]
["1,3,7-trimethylxanthine"]
["CO2"]
["NH3"]
["sodium bicarbonate"]
["potassium hydrogen tartarate"]
["Flourine"]

{"sheet":"13","index":14,"n_rows":22,"n_cols":1,"rows_kept":22,"merged":[[5,0,5,10],[6,0,6,10],[14,0,14,10],[15,0,15,10]]}
[]
[]
[]
["Convert to the Locations data type and extract info with the Insert Data button and by opening their cards.  "]
[]
["Locations"]
["Try things like image, architect, local map, and lattitude."]
["Location name"]
["Yellowstone National Park"]
["Eiffel Tower"]
["Empire State Building"]
["Great Wall of China"]
["Tower of London"]
[]
["Zipcodes"]
["Try things like city, county, local image, and total sales tax."]
["Zipcode / Postal Number"]
[90210]
[20004]
[8601]
[86514]
[96753]

{"sheet":"Learn More","index":15,"n_rows":14,"n_cols":6,"rows_kept":14}
["Learn more - Scroll down to cells B11, D11, and F11 for links to other information"]
["Use CTRL+PAGE UP  to return to the previous worksheet"]
{"$rows_empty":7}
[null,"Related articles",null,"Other helpful information",null,"More resources"]
[null,"How to use linked data types",null,"Try data type smart templates",null,"Training courses"]
[null,"What linked data types are available in Excel?",{"$nulls":3},"Tech community"]
[null,"Linked data types FAQ and tips",{"$nulls":3},"Excel blog"]
[null,"#FIELD! Error"]