Hi everybody,
I was given a large excel file with 1,000 rows and 7 columns that are arranged in a way to show the total volume of a cylinder at .01' increments ranging from 1' to 10'. The cylinder's floor is sloped, so there was some math done in excel to get the data points. We can assume they are correct.
My question - Is there a way to create a lookup table in Studio5000 (using L8x cpu) that will compare the transmitter's level against a known data point? Problem is, each .01' increment is given a volume, so I would have to add up all the data points before it to get the "total volume". I'm just asking for advice on how to approach this before I waste a bunch of time.
Thanks
I was given a large excel file with 1,000 rows and 7 columns that are arranged in a way to show the total volume of a cylinder at .01' increments ranging from 1' to 10'. The cylinder's floor is sloped, so there was some math done in excel to get the data points. We can assume they are correct.
My question - Is there a way to create a lookup table in Studio5000 (using L8x cpu) that will compare the transmitter's level against a known data point? Problem is, each .01' increment is given a volume, so I would have to add up all the data points before it to get the "total volume". I'm just asking for advice on how to approach this before I waste a bunch of time.
Thanks