1 / 6

Creating Pivot Charts from ClassesSummaryClassCode Files

Creating Pivot Charts from ClassesSummaryClassCode Files. Revised Mar 24, 2011. Drop xlsm and mdb files into the same directory as your ClassesSummaryClassCode.csv file OR Copy summary file into same folder as these files (overwrite sample csv file).

bert
Download Presentation

Creating Pivot Charts from ClassesSummaryClassCode Files

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related