Dear Sirs,
I work for a public school. We have 60+ employees who can print and copy on two different machines. I need to get a yearly summary (with views per month) of the usage per employee.
Each month I get a xls dumps of each machine. On it is per employee a total number of prints, scans and copies. An employee can make use of either machine, so per month I have two xls files with per employee a different number. These numbers need to be SUM()-ed. The listed employees can vary however: due to pregnacies an employee may leave, while another may take their place.
example
copier 1, month 1:
Employee Copies Prints
x 1 2
y 0 0
copier 2, month 1:
Employee Copies Prints
x 0 2
y 1 0
copier 1, month 2:
Employee Copies Prints
x 4 2
y 0 3
z 0 0
copier 2, month 2:
Employee Copies Prints
x 0 8
y 1 0
z 1 1
etc
total number of prints/scans/copies this year:
Employee month1 month2 etc
x 5 14
y 1 4
z 0 2
How can this be done? I can put the monthly-files into tabs (into one file). I can import them into access and try doing it with SQL.
Thanks in advance for any help!
kind regards, Koen
Bookmarks