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