1. Creating Pivot Charts from ClassesSummaryClassCode Files Revised Mar 24, 2011

2. Drop xlsm and mdb files into the same directory as your ClassesSummaryClassCode.csv fileORCopy summary file into same folder as these files (overwrite sample csv file) Need to name your ClassesSummaryClassCode.csv file exactly as such (i.e. no dates, region names, etc.)

3. Manually update the link to linked table (ClassesSummaryClasscode.csv)in Access (R6_Forest_PivotChart_LUT.mdb) -Select both -click OK -Browse for location of file Right-click on linked table and choose LT manager

4. Run the Excel file (.xlsm) to begin making pivot tables and charts

5. This form (Arid Lands version) opens automatically when you open Excel Minimize window to view/play with results 1. Select a region -Can select only 1 region at a time 2b. Dropdown boxes become active on selection of AOI option Currently shows all units in a region regardless of whether there is data in the summary file 2. Area selection: Limits query to HUCs that intersect counties or National Forest 3. Timestep Groups: Helps limit # records for Excel pivot table -Averages results within a time group step 5. Click to create pivot table and draft chart -This may take up to 5 min per pivot table depending on csv size (about 5 min for OEC) 4. Select a grouping -Output is written to a specific sheet, “PivotSheet” -Need to delete this before you can run new results -If you want to save existing results, copy sheet to a new sheet or workbook

6. Example Results Minimize window to view/play with results