+ Reply to Thread
Results 1 to 2 of 2

Tracking internal rejections with multiple operators on single machine

  1. #1
    Registered User
    Join Date
    09-27-2012
    Location
    Torrance, CA
    MS-Off Ver
    Excel 2013
    Posts
    75

    Tracking internal rejections with multiple operators on single machine

    I'm trying to decide between Access and Excel on this one. I don't have any Access experience, but I'm having trouble building this in Excel.

    Essentially, my department needs to track rejections.
    This includes:
    Rejection Number
    Rejection Type/Description
    Part Number
    Lot ID
    Engineering Disposition
    Work Center/Area
    Operator(s)
    Machine Asset Number

    The problem is that there multiple instances of more than one operator running a machine for a part that has a rejection, as we have two shifts and a weekend shift at our facility. When I attempted to build this in Excel originally and filter results with a pivot table, it would work but showed multiple rejections per machine (due to there being several operators running that machine). I've since tried separating the operators by shift, but that still won't work, owing to the fact that there can be different operators running that machine/job from day to day.
    Is Access the right tool for this job, or will I run into the same issues when entering data.
    Attached Files Attached Files

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Tracking internal rejections with multiple operators on single machine

    Hi Greg,

    See if a different Pivot Table gets you closer to an answer. If you need all the data besides the count then Advanced Filters in Excel or Access is the way to go. If you only need a number then stay in Excel.
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1