Project Description:
I need help writing a program for my job. We currently use excel spreadsheets to record data and then we have someone who manually goes through and writes down numbers and calculates things at a later point. The data entered is a specific employee tied to a specific batch of documents with numbers that include how many documents were in the batch and how many errors the employee made on the batch. Again, someone goes through each employee's spreadsheet and tallies everything up.
I am wanting a program that writes data like so:
Employee
Batch #
# of docs
# of errors
date
Then saves it somewhere. Whether it's a txt file or a spreadsheet, whatever has the fastest loading times.
The second part of the program, in a different module password protected, will read:
Specific employee
Date range
# of docs
# of errors
Percentage of accuracy