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 ...
2nd July 2009, 01:07 PM #1
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?
2nd July 2009, 01:23 PM #2
I think a pivot table should do this for you.
Thanks to JOrdan01070 from:
2nd July 2009, 01:29 PM #3
Some nice instructions here - cribbed them for use myself on sorting ours out...
Calling All Excel Gods
Thanks to OutToLunch from:
2nd July 2009, 02:21 PM #4
cheers, yes a pivot table is the solution I wanted and the info in the other thread was helpful.
By SYNACK in forum Coding
Last Post: 3rd March 2011, 10:30 PM
By sidewinder in forum Windows
Last Post: 21st July 2009, 04:46 PM
By EduTech in forum Links
Last Post: 22nd May 2009, 05:22 PM
By broc in forum Office Software
Last Post: 25th April 2008, 02:43 PM
By joeman in forum Windows
Last Post: 25th January 2008, 08:31 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)