{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Start","Inventory List","Inventory Pick List","Lookup","Navigation Links","Conditional Formatting","Icon Sets","Learn More"],"not_rendered":{"charts":0,"images":9,"macros":1,"external_links":0,"defined_names":8,"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":"Start","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Learn how to create an accessible template in this worksheet using an Inventory List as an example. Each worksheet has accessible descriptions in column A, except Inventory List, Inventory Pick List and Lookup worksheets. These accessible instructions help users navigate the tutorial, but are not commonly used when creating templates. Columns B and C contain non-accessible descriptions. Column E contains images or data relevant to the worksheet topic. This worksheet has a title, subtitle and table of contents for all tabs in this workbook. Cell B11 has the Excel logo, cells C3 through C11 has an image of the accessible Invoice template and cell C11 has a navigation button that links to the Invoice worksheet to get started.\n\nPress UP or DOWN ARROW in column A to read through the document. Press CTRL+PG DOWN to go to the next worksheet."]
["Title: Sample Inventory List accessible template.  Descriptions for how this invoice was made accessible are outlined beneath the Contents, in this column."]
["Contents. Navigate through each item listed below to learn how this sample Inventory List was made accessible, starting with the accessible Inventory List in the Inventory List worksheet. Inventory list template has 3 worksheets: Inventory List, Inventory Pick List and Lookup. The other worksheets describe how the template was made accessible. "]
["Inventory List worksheet"]
["Inventory Pick List worksheet"]
["Lookup worksheet"]
["Navigation Links"]
["Conditional Formatting"]
["Icon Sets"]
["Learn More"]
["Excel logo is in cell B12, Inventory List image and navigation button to Inventory List worksheet is in cell C12."]

{"sheet":"Inventory List","index":1,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"INVENTORY LIST"]
[null,"TOTAL INVENTORY VALUE:","INVENTORY ITEMS:","BIN COUNT:","INVENTORY PICK LIST","LOOKUP"]
[null,{"$f":"SUM(InventoryList[INVENTORY VALUE])","v":4649},{"$f":"COUNTA(InventoryList[DESCRIPTION])","v":11},{"$f":"SUMPRODUCT((1/COUNTIF(InventoryList[BIN '#],InventoryList[BIN '#]&\"\")))","v":6}]
[null,"SKU","DESCRIPTION","BIN #","LOCATION","UNIT","QTY","REORDER QTY","COST","INVENTORY VALUE","REORDER"]
[null,"SP7875","Item 1","T345",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 2, slot 1"},"Each",20,10,30,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":600},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"TR87680","Item 2","T345",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 2, slot 1"},"Each",30,15,40,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":1200},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"MK676554","Item 3","T5789",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 1, slot 1"},"Each",10,5,5,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":50},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"YE98767","Item 4","T9876",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 3, slot 2"},"Box (10 ct)",40,10,15,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":600},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"XR23423","Item 5","T098",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 3, slot 1"},"Each",12,10,26,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":312},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"PW98762","Item 6","T345",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 2, slot 1"},"Each",7,10,50,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":350},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":1}]
[null,"BM87684","Item 7","T349",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 1, slot 2"},"Each",10,5,10,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":100},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"BH67655","Item 8","T5789",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 1, slot 1"},"Each",19,10,3,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":57},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"WT98768","Item 9","T9875",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 2, slot 2"},"Package (5 ct)",20,30,14,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":280},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":1}]
[null,"TS3456","Item 10","T349",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 1, slot 2"},"Each",15,8,60,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":900},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]
[null,"WDG123","Item 11","T349",{"$f":"IFERROR(VLOOKUP(InventoryList[[#This Row],[BIN '#]],BinLookup[],3,FALSE),\"\")","v":"Row 1, slot 2"},"Each",25,15,8,{"$f":"InventoryList[[#This Row],[QTY]]*InventoryList[[#This Row],[COST]]","v":200},{"$f":"IFERROR(IF(InventoryList[[#This Row],[QTY]]<=InventoryList[[#This Row],[REORDER QTY]],1,0),0)","v":0}]

{"sheet":"Inventory Pick List","index":2,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"INVENTORY PICK LIST"]
[null,null,"INVENTORY LIST"]
[]
[null,"ORDER #","SKU","PICK QTY","QTY AVAILABLE","ITEM DESCRIPTION","UNIT","BIN #","LOCATION"]
[null,"TP001-1","SP7875",3,{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],6,FALSE),\"\")","v":20},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],2,FALSE),\"\")","v":"Item 1"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],5,FALSE),\"\")","v":"Each"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],3,FALSE),\"\")","v":"T345"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],4,FALSE),\"\")","v":"Row 2, slot 1"}]
[null,"TP001-1","YE98767",1,{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],6,FALSE),\"\")","v":40},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],2,FALSE),\"\")","v":"Item 4"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],5,FALSE),\"\")","v":"Box (10 ct)"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],3,FALSE),\"\")","v":"T9876"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],4,FALSE),\"\")","v":"Row 3, slot 2"}]
[null,"TP001-1","BM87684",2,{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],6,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],2,FALSE),\"\")","v":"Item 7"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],5,FALSE),\"\")","v":"Each"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],3,FALSE),\"\")","v":"T349"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],4,FALSE),\"\")","v":"Row 1, slot 2"}]
[null,"TP001-1","TS3456",6,{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],6,FALSE),\"\")","v":15},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],2,FALSE),\"\")","v":"Item 10"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],5,FALSE),\"\")","v":"Each"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],3,FALSE),\"\")","v":"T349"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],4,FALSE),\"\")","v":"Row 1, slot 2"}]
[null,"TP001-1","MK676554",3,{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],6,FALSE),\"\")","v":10},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],2,FALSE),\"\")","v":"Item 3"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],5,FALSE),\"\")","v":"Each"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],3,FALSE),\"\")","v":"T5789"},{"$f":"IFERROR(VLOOKUP(InventoryPickList[[#This Row],[SKU]],InventoryList[],4,FALSE),\"\")","v":"Row 1, slot 1"}]

{"sheet":"Lookup","index":3,"n_rows":11,"n_cols":7,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"BIN LOOKUP"]
[null,"INVENTORY LIST"]
[]
[null,"BIN #","DESCRIPTION","LOCATION","WIDTH","HEIGHT","LENGTH"]
[null,"T345","Large bin","Row 2, slot 1",50,10,10]
[null,"T5789","Small bin","Row 1, slot 1",25,5,5]
[null,"T9876","Large bin","Row 3, slot 2",50,10,10]
[null,"T098","Medium bin","Row 3, slot 1",30,7,10]
[null,"T349","Small bin","Row 1, slot 2",25,5,5]
[null,"T5789","Large bin","Row 4, slot 5",50,10,10]
[null,"T9875","Large bin","Row 2, slot 2",50,10,10]

{"sheet":"Navigation Links","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
["Learn how to use navigation links in an accessible template. Accessible instructions continue in column A. Press UP or DOWN ARROW in column A to read through the document. Press CTRL+PG DOWN to go to the next worksheet."]
["Title: Navigation Links","Navigation Links"]
["Overview: Navigation links help users get to information within a workbook, quickly. People who use screen readers sometimes scan a list of links. Links should convey clear and accurate information about the destination. ","\nNavigation links help users get to information within a workbook, quickly. People who use screen readers sometimes scan a list of links. Links should convey clear and accurate information about the destination. ",null,null,null,"Image of 2 navigation links"]
["1. Give links meaningful names. Inventory List worksheet uses 2 navigation links: \"Inventory Pick List\" and \"Lookup\". See navigation link sample image in cell F3.",1,"Give links meaningful names. Inventory List worksheet uses 2 navigation links: \"Inventory Pick List\" and \"Lookup\". See navigation link sample image in cell F3."]
["2. Add screen tip text that describes, in brief, what will happen when that link is selected. See screen text sample image in cell F5.",2,"Add screen tip text that describes, in brief, what will happen when that link is selected. See screen text sample image in cell F5."]
["3. Accessible users find it helpful to call out important shapes like this in the worksheet. For instance, the A1 summary input message  indicates a navigation button exists and tells the user where it directs them to. See the A1 input message in Inventory List worksheet.",3,"Accessible users find it helpful to call out important shapes like this in the worksheet. For instance, the A1 summary input message  indicates a navigation button exists and tells the user where it directs them to. See the A1 input message in Inventory List worksheet."]
["4. It takes several steps for accessible users to access a shape with a link. There are a few ways we make that easier for them.",4,"It takes several steps for accessible users to access a shape with a link. There are a few ways we make that easier for them."]
["4.1 Make sure the shape fits entirely within a cell block (e.g. cell E2 of Inventory List worksheet). ",null,"4.1 Make sure the shape fits entirely within a cell block (e.g. cell E2 of Inventory List worksheet). "]
["4.2 Add text to the cell with the shape that mirrors the text in the shape.",null,"4.2 Add text to the cell with the shape that mirrors the text in the shape. "]
["4.3 Make the text hyperlinked and align entirely behind shape.",null,"4.3 Make the text hyperlinked and align entirely behind shape."]
["4.4 Add an input message that says there is a navigation link in this cell",null,"4.4 Add an input message that says there is a navigation link in this cell."]
["4.5 Add the exact same link and screen tip text to the cell as in the shape.",null,"4.5 Add the exact same link and screen tip text to the cell as in the shape."]
["4.6 Hide the text by modifying the Hyperlink cell style or creating a custom style such that the font color is the same as the background color. Make sure both Hyperlink and Followed Hyperlink cell styles match.",null,"4.6 Hide the text by modifying the Hyperlink cell style or creating a custom style such that the font color is the same as the background color. Make sure both Hyperlink and Followed Hyperlink cell styles match."]

{"sheet":"Conditional Formatting","index":5,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
["Learn how to use conditional formatting in an accessible template. Accessible instructions continue in column A. Press UP or DOWN ARROW in column A to read through the document. Press CTRL+PG DOWN to go to the next worksheet."]
["Title: Conditional Formatting","Conditional Formatting"]
["Overview: Conditional formatting is useful to highlight data that matches a defined set of criteria. ","\nConditional formatting is useful to highlight data that matches a defined set of criteria. ",null,null,null,"Items for reordering are highlighted using conditional format in the image below. Two arrows indicate the rows highlighted in the image"]
["1. Conditional formatting is not an accessible feature but is highly leveraged when developing visually appealing templates. To help accessible users understand when conditional formats have been used, more annotations must be made. ",1,"Conditional formatting is not an accessible feature but is highly leveraged when developing visually appealing templates. To help accessible users understand when conditional formats have been used, more annotations must be made. "]
["3. Cell F3 adds more context for the highlighting done within the table image.",3,"Cell F3 adds more context for the highlighting done within the table image."]
["4. To help accessible users understand when conditional formats have been used, use annotations.",4,"To help accessible users understand when conditional formats have been used, use annotations."]
["5. Do not refer to colors when indicating items that are highlighted. If you must mention a color, include the RGB values with the color reference.",5,"Do not refer to colors when indicating items that are highlighted. If you must mention a color, include the RGB values with the color reference."]

{"sheet":"Icon Sets","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
["Learn how to use icon sets in an accessible template. Accessible instructions continue in column A. Press UP or DOWN ARROW in column A to read through the document. Press CTRL+PG DOWN to go to the next worksheet."]
["Title: Icon Sets","Icon Sets"]
["Overview:  Icon sets as a part of conditional formatting are not an accessible feature but are highly leveraged when developing visually appealing templates. To help accessible users understand when icon sets have been used, use annotations.","\n Icon sets as a part of conditional formatting are not an accessible feature but are highly leveraged when developing visually appealing templates. To help accessible users understand when icon sets have been used, use annotations.",null,null,null,"Image of column K from Inventory List"]
["1. Icon sets are useful to highlight data that matches a defined set of criteria but whenever possible must be accompanied by text as in the Reorder example image in cell F3.",1,"Icon sets are useful to highlight data that matches a defined set of criteria but whenever possible must be accompanied by text as in the Reorder example image in cell F3."]
["2. An input message in table headings with icon sets within the row or column of the heading, help accessible users understand when an icon set is within a cell. See input message example in cell F7.",2,"An input message in table headings with icon sets within the row or column of the heading, help accessible users understand when an icon set is within a cell. See input message example in cell F7."]
["The input message for column K from Inventory List worksheet in cell F7 has the following text: \"A flag icon in this column indicates items in inventory ready for reordering\".",null,"The input message for column K from Inventory List worksheet in cell F7 has the following text: \"A flag icon in this column indicates items in inventory ready for reordering\"."]
["3. Heading cell of column K of Inventory List adds more context for the highlighting done within the table. For a visual user, a blank heading with icons only within the column is usable. However, to make this accessible, there must be text added.",3,"Heading cell of column K of Inventory List adds more context for the highlighting done within the table. For a visual user, a blank heading with icons only within the column is usable. However, to make this accessible, there must be text added.",null,null,"A sample input message of column K from Inventory List"]
["Tip: Sometimes decreasing the width of a column or making the heading text the same color as the background will hide the text to retain visual appeal.",null,"Tip: Sometimes decreasing the width of a column or making the heading text the same color as the background will hide the text to retain visual appeal."]
["4. When making accessible templates that contain icon sets, be sure to deselect to show icon only within the conditional formatting options.",4,"When making accessible templates that contain icon sets, be sure to deselect to Show Icon Only within the conditional formatting options."]
["5. After applying the conditional formatting, create a custom style called Icon Set. For the number setting, create a custom number format: \"Reorder\";\"\";\"\".",5,"After applying the conditional formatting, create a custom style called Icon Set. For the number setting, create a custom number format: \"Reorder\";\"\";\"\"."]
["Note this custom style has been applied to column K or Inventory worksheet.",null,"Note this custom style has been applied to column K or Inventory worksheet."]
["The text \"Reorder\" appears, along with the icon as in the sample image in cell F3. ",null,"The text \"Reorder\" appears, along with the icon as in the sample image in cell F3. "]
["Tip: Sometimes the additional text isn't visual appealing. Similar to hiding heading text, a custom style can be created and applied to the column to hide the text in the data cells.",null,"Tip: Sometimes the additional text isn't visual appealing. Similar to hiding heading text, a custom style can be created and applied to the column to hide the text in the data cells."]

{"sheet":"Learn More","index":7,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Learn more about how to create an accessible template through the links on this worksheet. Accessible instructions continue in column A.  Press UP or DOWN ARROW in column A to read through the document. "]
["Title: More questions about accessibility?"]
["How to make Excel spreadsheets accessible"]