Is it possible to track how much printing each teacher does for a Ricoh MFD?

[TwistedHelixis]

I have been asked to see if we can have a list of how much colour or black & white printing each teacher does for our Ricoh MFD?

 

This is a small primary school and whatever gets put in place we do not want to cause issues for the pupils printing, even the reception class print.

 

I know it is possible to setup some kind of pin number system but seem to remember this blocks the printing for everyone without a pin number, although I could be wrong.

 

So is there a way to easily track how much the staff are printing without impacting on their ease to print or block anyone?

[Rob_D]

If it's just printing (and not copying) and you're using a print server then something like this would do the job.

https://www.papercut.com/products/free-software/print-logger/

[LeMarchand]

If it's leased, speak to the supplier. One of my sites uses RICOH machines, and it's possible to get that info on their MFD.

 

Otherwise https://www.papercut.com/products/free-software/print-logger/ . Someone here did write something that made it easier to manipulate the info; not sure if it still works.

[jmak]

AFAIK there's no built in method to do it without setting up accounts for every user and setting it on every computer the user prints from. I am aware that people have created customised drivers which use the Windows credentials, but I failed with that. We use Hold Print, but to make that work, you have to go in to Printing Preferences and set it to use the windows ID and then manually set the printer code. Otherwise print jobs disappear into the ether(net) with no error message.

 

Causes annoyance here, but less annoyance than searching through the thousands of sheets of printing that used to happen. Plus you can easily log in to the printer's management control and run the reports you're after.

[AJB123]

I user the FREE PaperCut Print Logger software, it creates a CSV file every day and every month which you can then copy and add a few formula to to get totals for each username.

[localzuk]

The PaperCut Free solution will work telling you about printing, but it won't tell you about copying (which we find is the majority of the work teachers do using MFDs).

 

For that, you'll need a paid product like PaperCut MF.

[TwistedHelixis]

I user the FREE PaperCut Print Logger software, it creates a CSV file every day and every month which you can then copy and add a few formula to to get totals for each username.

 

So I have got my CSV file with a long list of print jobs.

 

I am not a heavy user of excel and hope someone help me with a formula to get the totals for each user.

[TwistedHelixis]

BTW - theses are the columns

 

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

[Rob_D]

So I have got my CSV file with a long list of print jobs.I am not a heavy user of excel and hope someone help me with a formula to get the totals for each user.

 

When I did this I used COUNTIF and SUMIF.

 

=COUNTIF(A:A, "username")

Counts the number of rows where "username" is in column A - number of print jobs for a given user.

 

=SUMIF(A:A, "username",C:C)

Adds together the number in column C (page count) of rows where "username" is in column A - total number of pages per user.

[blueday]

Or create a pivot table. Click anywhere in the data and on the Insert ribbon choose Pivot Table. Then in the Field list, drag 'User' down to the Row area, and then 'Pages' into the Values area. It will default to Sum of, but if you want to know the count instead, right click on any of the numbers in the table and choose 'Summarise Values by' and then Count. You can sort by user name by clicking on the drop down arrow on Row Labels.

[mikeprice]

I did this at my last school. It did need everyone to have a pin but we made sure that every teacher had a pin - but had a separate pin for the kids to use for their work.

 

This did involve some discipline from the staff to make sure that the used their pin properly and did not just use the kids one all the time. however it did allow us to use the integral systems on the Ricoh printer (you can connect to the controller with a web browser - you just need the ip address) to extract the numbers.

 

We did find that initially some teacher were worried about being 'blamed' for printing too much so I had to be very careful how I spoke to them - but it did work.

 

In reality it turned out that the main user by miles was the school office - printing off letters to send home that the Head insisted HAD to be sent!