+ Post New Thread
Results 1 to 4 of 4
Office Software Thread, processing paper cut print logger logs help in Technical; I have the csv log as produced by papercuts print logger and have imported it into Excel 2003. I have ...
  1. #1

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    processing paper cut print logger logs help

    I have the csv log as produced by papercuts print logger and have imported it into Excel 2003. I have setup the worksheet as a List. I have frozen the top row and used it as the field names.

    Now although I can set the sorts and filters on a per field basis and see who printed what, when and where, I also need to produce usage totals on a user per printer basis. I don't know how to do that with the standard excel tools. Do I need to start doing some VBA or have I just missed something obvious?

  2. #2

    Join Date
    May 2007
    Location
    Birmingham
    Posts
    169
    Thank Post
    9
    Thanked 45 Times in 36 Posts
    Rep Power
    27
    I think a pivot table should do this for you.

  3. Thanks to JOrdan01070 from:

    Geoff (2nd July 2009)

  4. #3

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    65
    Some nice instructions here - cribbed them for use myself on sorting ours out...

    Calling All Excel Gods

  5. Thanks to OutToLunch from:

    Geoff (2nd July 2009)

  6. #4

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,803
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224
    cheers, yes a pivot table is the solution I wanted and the info in the other thread was helpful.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 66
    Last Post: 3rd March 2011, 10:30 PM
  2. Replies: 15
    Last Post: 21st July 2009, 04:46 PM
  3. PaperCut - Print Logger
    By EduTech in forum Links
    Replies: 9
    Last Post: 22nd May 2009, 05:22 PM
  4. Why can't we print from word processing software?
    By broc in forum Office Software
    Replies: 7
    Last Post: 25th April 2008, 02:43 PM
  5. Replies: 14
    Last Post: 25th January 2008, 08:31 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •