Page Comparison

...

• Save the file:
  • use the .xlsx format
  • format name: pickupcounts201310 - replace with correct year and month 
  • save it to the admin server: Work-Groups/Architecture/Statistics/stats_fy1213/pick up counts
• Delete the following columns:

  • response_set_id

  • parent_response_set_id

  • page
  • user
  • branch
  • desk
  • library
  this will leave only the following columns:
  • date
  • time
  • Pick up Count
  • Your Initial

Image Removed

• On the Data tab, select Pivot Table

Image Added

• On Pivot Table Builder, do the following:
  • Select all Field names
  • drag date to Column Labels
  • drag time and Your Initials to Row Labels
  • drag Sum of Pick up Count to Values

...