Transcript for the KI Tutorial Video This is Karen Irwin with the U.S. EPA’s Pacific Southwest office and I’m going to demonstrate how to use the online table for “Managing and Transforming Waste Streams”. The table has interactive features that can be used to display a subset of the 100 measures, enabling users to customize the list to a particular community’s needs, interests, and capabilities. Each measure has its own number, short title, and description. At the end of the description, you can click on the “Examples and Resources” link to learn about cities or counties that have implemented the measure and access relevant online resources. There’s also a separate link on the tool’s main page that takes you directly to the Community Implementation Examples and Resources. The second column in the table allows you to hide measures. Just click on a check box to remove a measure from view. This can be done for any policies or programs a local government has already implemented. The third column is titled “Highlight”. Checking a box in this column highlights the entire row, as a way to indicate the measure is a priority for the community to further evaluate. The policies and programs are categorized by Sector and by the Material or Product Group they address. Hover your cursor over each of these columns to see the list of terms used. If you’d like to sort the measures alphabetically by Sector, simply click on the cell in the Sector column header that contains the small arrows. To go back to viewing the table numerically, click on the header cell of the number column on the far left. If you’d like the table to display only measures that relate to a particular Sector, use the search bar underneath the header. For example, if I type “GOV” in the search bar, this will display only entries that relate to government operations. To go back to the original display, I simply delete the text in the search bar. To see only measures that relate to Institutional, Commercial, and Industrial sectors, type “ICI” in the search bar. You can also search by Material or Product Group. For example, typing “ORG” in the search bar for this column will display all measures in the table related to food and yard waste organics. Click on the orange question mark to read the full definition for each term and what materials it includes. To see how many measures out of the 100 total are related to organics, scroll to the bottom of the page. The text on the lower left indicates there are 38 out of 100 measures displayed that relate to organics. Scrolling back up to the top, we will next take a look at the last six columns in the table. These enable you to display a subset of measures based on qualitative rankings for various implementation factors. We refer to these six columns as “Filters”. Hover your cursor over the title of each Filter column to view a description of what it addresses and the rankings used in that column, such as High, Medium, and Low. Note that these rankings are qualitative indicators intended to serve as general guidelines and a starting point for further scoping. Clicking on the drop down arrow for one of the filter columns displays a short set of options. For example, if I select “High”, this will display only measures ranked “High” for Diversion Potential. Clicking on “Medium/High”, will display all measures ranked either “High” or “Medium” for Diversion Potential. To go back to the default, select “All”. As another example, to see which measures would likely be relatively easy for a community-based organization to initiate, select “Easy” in the drop down of the Community Led Initiatives column. A tip for applying filters – if you select too many filter rankings at the same time, it can narrow the list of measures quickly so you may want to use only a couple in combination at once. After you have customized the table to display measures of interest, click the Copy/Print button to either print or copy and paste it into another document. From the Print View, left-click and hold to select individual rows, then right-click and copy. Once pasted into another document, you can edit the table to remove or add columns. From the Print View, hit the Escape button to go back to the interactive table. You can also download a PDF or Excel version of the customized table to your computer. To restore the table to its original setting, simply click on the “Reset to Default View” button. This concludes the tutorial. Thank you for listening.