Search results for query: *

Does anyone have data that shows the correlation (or even better, an objective formula) between hours/distance of forklift travel and the injury rate in that area? Intuitively it makes sense that the less you have to drive a forklift the less chance there is for injury, but so far none of the...

If the downtime is true "machine down due to broken tool" time, then the concept of running slower to reduce downtime is absolutely valid. I've seen case studies in the garment industry that support this. What you may want to do is a quick DOE study with feed/speed as your input and downtime...

You could try subtracting 7/24 of a day from each timestamp - this would make 7 am be 12 am, and 6:59 am be 11:59 pm on the day before. Then after you have the "day", add the time back to get the actual time. Hope this helps!

It is something of a gimmick, but has some basis in necessity. The standard accounting rules were set up a few hundred years ago, and don't always lead to the same answer as lean rules. It's always a good idea to know how to talk to the accounting geeks in their language so you can convince...

Try this: Select Count As Count1, Count(User) From Table Group by Count1 Hope this helps!

I'm working on implementing an inventory control system at my plant, and I was wondering if anyone has advice on some basics that I should cover. This does not need to be a fancy system (RFID is probably way too much cost and complexity for this organization). Primarily I'm looking for advice...

One idea is to try to move as much of the maintenance to the regular shop worker or to have none at all. By this I don't mean skip the maintenance, but instead, see if the equipment can be designed to require less maintenance or less skilled maintenance. Good examples would be using sealed...

As much as I hate to bring this up, the architect or structural engineer would have had to seal the documents to indicate they are correct and valid. And since you mention that there were other sheets that carried the wrong scale and were not HVAC related, then it seems that at least some...

If it's convenient to have each part on its own drawing, that's certainly an easy way to go. But many people prefer to use tabulated drawings for similar parts with multiple sizes, so you do have to find a way to relate the two. Depending on what sort of systems you have in place now, this can...

The text cell represents both parts of the imaginary number. You'll have to parse out the real and imaginary parts separately into two different cells, using something like the MID and FIND functions to figure out where each part starts and stops.

Also beware that the typical Excel chart assumes the X values are in buckets - that is, they are discrete and not ordinal. (So X1 is 1, X2 is 2, even if X2 is really 1.5) I've had to specifically tell Excel that the data is time series, then change the number format on the chart. But this...

I've found the best way to prove the measurement precision needed is to show how much money is left on the table. For example, perform a gage R&R study with your current device plus another one that has better resolution. Then compare the two. You should see some examples where the current...

As PSE said, ISO registration doesn't retain your customers (except in the rare event that an existing customer requires you to get it). What I've seen more of is that it's a box to check-off for potential customers during a screening process. But beyond that, being ISO (or QS) 9000 registered...

Is it feasible to modify the MRP system so that it acts as an employee, with its own user id and password for the PDM system? Then when someone on the floor needs to print a drawing, the MRP system sends its info to the PDM system for retrieval. Otherwise just put the drawings on the network...

electricpete, I've used the following on many similar types of spreadsheets. I sort the spreasheet based on the serial number column and then add a column for "Sequence". In that column I put a formula to check if the adjacent cell is the same as the one above it. If it is, the result is the...

billtati - making the revision part of the part number isn't necessarily bad, depending on your circumstances. That particular company didn't have to worry about Mil standards, and they needed to be able to go back and build a previous revision configuration if needed. So for them it made...

My company separates the implementation date into two distinct areas. There is a release date for the drawing, which is the date the revised drawing was completed and checked. Then there is a separate shop floor release date, which controls when the new revision of the part actually makes its...

Melone is correct. Sometimes it's hard to explain to someone that "fixing" an infrequent and low-cost problem isn't the right thing to do. It's also difficult sometimes to get someone to agree to allow you to examine the equipment, because "they have to keep it running." Ultimately, if you...

If you have historical data you can try to fit them to an exponential or Weibull distribution. Then keep updating your curve fit as you get new data. You will likely never know for sure the exact parameters of the distribution, since several values close together will likely yield the same...

I'm wondering if anyone can point me in the right direction, if there is one. I need to make a living hinge that flexes easily but has high shear and tensile strength. This part will be subjected to several hundred cycles, and will need to withstand tear-type loads of at least 650 lb per 12...