CSV's and Excel

[nathan]

Hello,

After a little help with excel, i have a CSV file thats been logging print outs on our server. Each line is like below;

Time,User,Pages,Copies,Printer,Document Name,Client,Paper Size,Language,Height,Width,Duplex,Grayscale,Size

2007-09-03 07:58:16,username,2,1,Colour Laser Foundation,"Microsoft Word - num assessment.doc",10.2.97.99,A4,ZJSTREAM,,,NO

I'd like to create a graph that will add up all total amount of pages per user (remembering there is both a copies and pages column) and produce a simple bar chart with how much people have printed.

Is this possible?

Ta!

 

[nathan]

EDIT: Right, i think ive made it a little easier.

Now i have username and how many pages have been printed off.

So it would be like;

User1, 10

User2, 23

User1, 12

User3, 1

User1, 12

Note that each line is a print job and therefor can be from a previous user. Like User1 has printed 3 times. But those 3 prints consisted of 10, 12 and 12 pages.

 

[Rastalovich]

There`s an auto-graph thingy in excel that would do that for u m8.

The way I used to do it was to go Insert->Chart.. xl sheet, select the style u roughly want etc, select the boundries u want to use (u can tweak it afterwards) - then of course u can copy the graph out to anything like Word or whatever.

There is another way too, some1 spammed our personal outbox thing with it last week, unfortunately I deleted it >.< something about pressing F11... meh.