Drag and Drop Calendar Project Management

If you’re running a manufacturing shop… and you got employees… and you got work orders… and you got tasks… and you got schedules… then you probably need a calendar to put them on. And likely more.

Well, that’s Standard Time®

It’s a manufacturer’s project management tool, otherwise knows as ERP/MRP. In other words, it’s for managing jobs and employees at the same time.

This little video demonstrates one way to simplify that management. Take a look!

Rename Custom Database Columns

Here’s an advanced video for you technical project management types. Consider renaming your custom database fields with “pretty names” for use in SQL scripts and reporting.

True, this video is not for everyone. It’s just for those hardcode reporting and scripting techies. This video shows how to rename database fields you are using in your reports and SQL scripts. The “big ugly” database column names you get by default for your custom fields can be renamed to make things easier for IT folks creating reports and writing scripts. Here’s how to rename them

Custom Fields In Reports

Manufacturing reports include everything from employee activity to detailed KPI’s. How do you customize these reports in Standard Time® for your purposes? With custom fields. These fields may contain the results of barcode scans, automated input, or manual entry. However the data arrives, they are included on reports using this method.

Watch the video and try it yourself!

Barcode Scanner and Tablet on Shop Floor

How do you get fat-finger entries in your timesheets? By not using barcode scanners!

And fake entries. And useless information that consumes valuable human effort to obtain. That all comes from traditional keyboard and mouse, on traditional workstations with timesheet software. Or even on paper timesheets.

In fact, those paper timesheets are the worst. Employees fill them out on Friday, but can’t remember what they worked on yesterday. Why would you use them? Because your employees can figure them out pretty easily. Okay, that makes sense. But there are other ways to collect time on the shop floor.

It turns out, there’s a much faster way to collect employee time on the shop floor. With barcode scanners. Watch this video, then give it a try yourself.

Barcode Scan Qty Items Produced

Manufacturing engineers need to know the number of items produced on their assembly lines. They also will know the time spent by employees to produce those items.

So… how do you get that? (watch this video, then scroll down for more)

You get that information with barcodes.

You put a barcode scanner in the hands of every employee, put a tablet on the bench, and have them scan the quantity of items produced when they “clock in” on jobs. Now you have both the time they worked and the number of items produced on the shop floor.

You can now compute:

  1. The time it took to produce each item
  2. The total items produced on a shift
  3. The total items produced for a client
  4. The total items produced per month, or for all time

You also know:

  1. Which employee statistically produces the most
  2. Which jobs are most efficient
  3. Which assembly lines or production techniques are the most efficient
  4. Which steps produce the most product in the shortest amount of time

Try this on the production line: scan your quantities for a month. Make one small change in the technique. Scan for another month and compare. Which production technique is most effective? Keep repeating this, each time looking at the average time per item. When that number goes down, you know you have landed upon an improvement worth keeping.

That is how you shave off 1% manufacturing time. And that is how 1% becomes 10% over time.

Standard Time® is how it is done on the shop floor.

Things You Collect with Barcode Scanners

Ever wonder what things you can scan during the manufacturing process? Here’s a quickie video for you. It’s not a tutorial on barcode scanning, just a survey of things you can scan. Scroll down below the video for a list.

 

Things you can scan on the shop floor:

  1. Employee names
  2. Project names
  3. Task names
  4. Categories
  5. Project status
  6. Task status and completion flag
  7. Expense templates
  8. Inventory items
  9. BOM lists
  10. Tools
  11. Unique items for your business
  12. Scripts

Got another thing you want to scan in your mfg shop? Have you tried the “Required Scans” option? That let’s you craft a custom scan to collect unique values for your manufacturing KPI’s and status. Scripts are another possibility to extend the built-in scanning capabilities of Standard Time. Just scan a script name and let it perform and database, email or web interaction you need. You will need IT support for script writing. They can be complex, but they are also very flexible and wide in their scope. You can do just about anything in scripts.

Click here to download: http://stdtime.com/download.htm

 

Excel Add-in for Timesheets

Have you ever wanted to pull your time and expense data into Excel for analysis? Now you can, with the XLST Excel Add-in. (scroll down for a video)

XLST is a new Excel add-in that pulls timesheet and project management data from your Standard Time® timesheet, and puts the results into Excel spreadsheets. It uses Excel formulas to extract timesheet data, and places the results into a single cell. In fact, the XLST functions act exactly like any other Excel function. They take “parameters” from other cells and use that data to get results.

What kinds of results can you get?

You can query the Standard Time database for all the actual work entered by employees. Or, you could query for all the expenses. Or all time off taken by employees. Or the hours available for time off.

Here is a partial list, which might spark your imagination:

  1. XLSTActualWork
  2. XLSTActualSalaryCost
  3. XLSTActualClientCost
  4. XLSTExpenseTotal
  5. XLSTTimeOffHours
  6. XLSTTimeOffAvailable
  7. XLSTScheduledHours
  8. XLSTExceedDailySchedule
  9. XLSTExceedWeeklySchedule
  10. XLSTProjectTaskScheduledHours
  11. XLSTProjectTaskDuration
  12. XLSTProjectTaskActualWork
  13. XLSTProjectTaskPercentComplete
  14. XLSTProjectTaskModified
  15. XLSTPayPeriodStart
  16. XLSTPayPeriodEnd
  17. XLSTEmployeeTimesheetApproved
  18. XLSTEmployeeTimesheetSubmitted
  19. XLSTEmployeeExpensesApproved
  20. XLSTProjectClientRate
  21. XLSTProjectSalaryRate
  22. XLSTEmployeeClientRate
  23. XLSTEmployeeSalaryRate
  24. XLSTCategoryClientRate
  25. XLSTCategorySalaryRate
  26. XLSTProjectManager

Just click in an empty cell and then click the function icon near the formula line. Then choose XLST as the category. You’ll see all the functions listed above. Each one takes different parameters. Many parameters are optional, so you can quickly get results right away.

You must start by downloading Standard Time from the stdtime.com website, and then connecting it to SQL Server. XLST requires SQL Server or SQL Express. Once ST is connected to SQL, then you can download and install XLST.

Watch the video to get started.

 

How Eversight Vision Uses Standard Time Barcoding

A customer testimony from Eversight Vision!

Watch the video below to learn how Eversight Vision (an eye bank) uses Standard Time® to track the amount of time cornea tissue is being handled by lab technicians. Every second counts!

Essentially, lab techs scan a barcode when cornea tissue is removed from refrigeration, and scan again when returned. The codes record which procedure is performed. They now know how long tissues are out of refrigeration, how long each procedure takes, how long each employee worked on cornea tissues, and which employee “touched” them last. Ahhh! Somebody touched my eye! 🙂

All kidding aside, that’s a lot of great information, just by scanning a barcode label.

This is especially the same process any manufacturing or assembly operation uses. You must measure before you can improve. How long are employees spending on each product? How long are products in each stage? What state is a given product at any time? Where is it? Who handled it last? When will it be finished? Those questions can best be answered by scanning barcode labels and recording time spent on them.

Watch the video and determine if this type of process would benefit you. Then download.

 

Strategies for serial numbers when barcoding

I don’t know how to get those pesky serial numbers to show up while barcoding! I need to track time to serial numbers on my widgets, but how? Where do the serial numbers show up in your time tracking app? Are they projects or tasks? How do I even start?

Start by watching the video! (scroll down)

Then, consider creating projects for serial numbers you’ll be scanning many times over a long period of time. Or, consider creating tasks for serial numbers you’ll only scan for a few days or weeks. It all depends on what the serial numbers and barcode labels represent.

In the end, you’ll get the same employee hours in the timesheet, and time logs in your reports. You’ll see how many hours each employee spends on your projects and tasks. You’ll see how much time was spent on each product. On each kind of work. On each step of the manufacturing process. All that information makes your process more efficient, and cost effective.

Here’s the basic process you will follow:

  1. Scan an employee name
  2. Scan a task name (representing a serial number on one of your widgets)
  3. The timer will start
  4. Perform the task
  5. Scan username again
  6. Scan the word STOP

That basic exchange collects a lot of information:

  1. How long the employee worked
  2. How long the project took to manufacture, assemble, box, and ship
  3. How long each serial number took
  4. How many times you touched the product
  5. Who touched the product
  6. When they touched the product
  7. How much time you’re spending on each kind of work

Barcode Labels Report

Here’s a quick “report” that prints barcode labels for a selected project and all its tasks. Comment on the video below, and let us know what you think!

We use the word report in quotes because its not really a report. Instead, it’s the barcode labels for any given project. That’s not really a report, right?

But you may find this useful if you’re tracking time in manufacturing or assembly. Start by scanning your employee name. Then scan the project name followed by the task. A timer will start to record your employee jobs.

Scan the word STOP to stop the timer. Now you have time logs with start and stop times. Lots of them! You’ll see scans come into the system in real-time. Now you can use them for all your wonderful reasons. Here are some to consider:

  1. Learn how much time each employee works
  2. Learn how long projects actually take to produce (rather than guessing)
  3. Get actual time for each task of a project
  4. Find out how long each product takes to manufacture and ship
  5. Compare manufacturing time to admin time (what percentage is each)