Event logs are a pain to manipulate (but I also find it fun...).

My office manager is trying to figure out who's utilizing our color printer the most, and has asked me for some info on it. I've gotten pretty far, but now I'm struggling with the more advanced formulas.

So far I've taken a csv of the event viewer, created a function to tell me which print jobs were sent to one specific printer, sorted by that column, and removed the other print jobs. So now I have a spreadsheet with date, time, username, and the print job.

The problem is that the description of the print job ends in the number of pages that were printed. In the column to the left of this description, I'd like to have a simple number representing the number of pages printed in that job. If it helps, the standard formatting of the messaged is, for example: "pages printed: 5" So the number is always the very last word/character in the cell (of course, many print jobs have over 200 pages, so it ranges from one digit to three).

Would someone be so kind as to help me with a formula to extract this information? I'd really like to avoid going through 554 lines and entering them manually This also might be something that needs to be done regularly, so this will save me a lot of time in the future.


Question #2:

This one is simpler, I'm just rusty with the graphing functions. The scenario is that I have a graph like the following:

John 4
Mary 2
Mary 10
Pete 15
John 7
Mary 12

How do I end up with a graph that shows users on the bottom and their total pages printed on the left? For example, going across the X axis we'd have John with 11 pages, Pete with 15 pages, and Mary with 24 pages.

Thanks for your help everyone. I like manipulating spreadsheets, but I'm bad about remembering how to create formulas. Does anyone have a good site for learning this stuff?