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...
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...
