Timesheet & Project Management Blog

Sometimes in manufacturing you want to collect the quantity of items produced along with the time worked.In other words, you want the hours employees spend on work orders, and you also want the number of things produced during that time. You can use that information for reporting, invoicing and production KPI’s. Turns out, you can get most, or all of that information with a barcode scanner.

This tutorial shows how to collect those quantities in a program named Standard Time.

Let’s see how it works!

For this tutorial I have one simple project called “Electroplating 78102,” not very exciting, there are just three tasks. We’re going to scan the plate task and then collect the quantity of items that were electroplated. So let’s go ahead and press the F4 button on the key board to open up the barcode window. Then press required scans so that we can see the set up required to collect this quantity.

I’ve already go this entered, you can see I’ve named it quantity. I’ve put in a prompt that tells the employee what is expected. This is scan order number 1, you could actually have multiple things that you’re collecting and scan those in certain orders. I’ve also set this up so that we collect the information after the work ends, that’s when the employee knows the number of items that were produced. Or in this case the number of items electroplated. We’re going to choose to type it in instead of scanning.

If you have predefined barcode labels that you could scan; that’s actually a better method than typing. There are no conditions on this, it’s going to all users and the value is going to go into the text 1 field of the time log. Time logs are where we collect the time that has occurred on the tasks. We can also collect other information like this quantity. That’s going to go into the text 1 field.

I’ve got this all set up, we’re ready to scan the barcode window is open. Let’s switch over to MS Word so that you can see the barcode labels that I’ll be scanning. I’ve got my user name, I’ve got the project, I’ve got a task and I’ve got the word “stop.” We’re going to type in the number of items for the quantity instead of scanning it. But if you had barcode labels that were explicit quantities that could be scanned, that’s actually better than typing.

Let’s go back to the barcode window and first of all scan the user name, the project and then the task. Now the timer has started so presumably I’m off working on this right now. Let’s go ahead and close this, go over to the time log. You can see a new item in the list here. I’m sorting these so that the newest ones are at the top. The bold items are scans that are currently timing right now. While that happens I’m going to the View menu choose Columns and I’m going to scroll down here for that text 1 field. That’s the one we’re going to enter the quantity into. I’m going to click add and then move up, click close. You can see some other numbers that were entered earlier. This one is blank because we don’t have anything yet, we still haven’t completed the work and remember that quantity was going to be entered at the end.

Again let’s go ahead and press the F4 key and we’ll go ahead and scan the user name. That tells me the timer is running. I’m going to scan stop and now it’s asking for the quantity. Let’s type in 14, click close and the timer stops.

Go up here, we see the new record, we see 14. That’s a very simple way of setting up required scans. In this case to collect the quantities of items produced.

From http://www.stdtime.com


Download a fully functional timesheet that will remain active for 30 days.
Company Name
Please enter your company name
Full Name
Please type your full name.
Invalid email address.
Number of Employees
How many employees will use this?