Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations MintJulep on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by BML

  1. BML

    Injury Rate vs Forklift Hours

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

    Production Standards - Machines

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

    Summing by 24hr period - 7am to 7am

    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!
    • BML
    • Post #2
    • Forum: SQL
  4. BML

    Lean Accounting?

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

    Need help with this sql grouping/aggregate query

    Try this: Select Count As Count1, Count(User) From Table Group by Count1 Hope this helps!
    • BML
    • Post #3
    • Forum: SQL
  6. BML

    Need a Simple Inventory Solution

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

    What is "Lean Maintenance"?

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

    Change Order Request

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

    Part Numbering System Modifications HELP ???

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

    Taking the natural log of a negative number is Excel.

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

    What is the trap in excel Chart Trendline(Regression)?

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

    Instrument Validation

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

    ISO 9000

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

    MRP & PDM

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

    conditional formatting to format first-of-a-kind within a column

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

Part and Inventory Search

Back
Top