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 TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jabaldauf

    graphical representation of pulses

    I choose to do this without a macro. To do this, I need to follow each of the times with a zero. If you have a large number of data points, you may want to write a small macro to do that. Let's say all these durations and zeros are in column A. Then in column B I calculate the total time by...
  2. jabaldauf

    Roll-Your-Own Protocol for RLC Paradigm

    I am writing my own serial (ASCII) protocol for the Red Lion Paradigm series of operator interface products, using their "Roll your own" protocol driver capability. If anyone has done this before, I would appreciate seeing an example. -Jim B.
  3. jabaldauf

    Can anyone tell me if there is a h

    I saw this just the other day while browsing for something unrelated. I don't know if it will help, but it claims to convert between Modbus and Hart. http://www.miinet.com/products/sg_hart.shtml
  4. jabaldauf

    Pro/Con using PLC for analog input?

    I am not familiar with the specific hardware that you are using. However, the PLC may be limited by any of: sampling speed, resolution (bits), voltage limits, and cost. The PLC might further have memory limitations, whereas these other units appear to have data logging capability. Datalogging...
  5. jabaldauf

    PLC brands comparison

    I design for an OEM to the paper industry worldwide. Back in 1990 I conducted a thorough weighted analysis of the major brands with respect to the types of equipment we supply. Some brands were strong in features we would not use, but weaker in offering the mix of I/O that we would use (e.g. we...
  6. jabaldauf

    Goalseeking to a minimum vlaue

    I don't know why the people who mentioned solver have down-played it. I use solver all the time with excellent results. Load it from the tools/add-ins menu. It is iterative. The solutions are not true minimums in the sense of a mathematical root, but they are very close approximations to a...
  7. jabaldauf

    SUMIF and conditional Question

    Your subject heading is perfect. Use an array function something like this: {=Sum(If(product=40194,If(customertype=bottom70,volume,0),0))} Note the {} braces are not typed in, but appear when the formula is entered as an array formula by pressing ctrl-shft-enter. -JimB
  8. jabaldauf

    Show Username in Cell

    Excel has a function INFO(). Wouldn't it be nice if they added more type_text values to represent things like the user name, filename, last file saved date, etc? JimB
  9. jabaldauf

    how date stamp only when changes occur?

    Excel only updates the spreadsheet when cells on the sheet are changed. The NOW() cell will update when the sheet is first opened, and again anytime any cell is changed. Check the value of this cell as a clue to whether you changed the sheet or not. A more fool proof method (but I haven't...
  10. jabaldauf

    Instant Fraction Formatting

    You can further tune the display of fractions. If you want measurements to the nearest 1/16 inch, use the format code # ??/16. You can create a custom format code with any denominator you require. To restrict to a maximum number of digits in the denominator, use # ??/?? (e.g. for two digits)...

Part and Inventory Search

Back
Top