Hi Everyone, first time poster, so hopefully I get this correct.
I'm receiving a measurement from an ultrasonic sensor or a pressure Transducer. This level will indicate the height of liquid in a vessel. I have formulas in a function node to create a volume from this level based on radius, height etc....but I also have some vessels (earth dams) that are irregular in shape. I can access surveyed data that show a volume for each cm of height. This is in a spreadsheet or table.
Could someone advise the best approach to add or "lookup" this data to pass a volume?
I'm a very novice user, so the simpler the better! Thanks in advance.
You don’t say how large you spreadsheet or table is.
But one way to do it would be to store it in you function as an array or store it as a context variable containing an array.
Or load it into a sqlite database and query it from there
Thanks ukmoose, the table or spreadsheet could potentially get as large as 700 rows, although this would be a bit unusual. I would need to cater for that though. Too many to manually type!
I'll do more reading, if you have any simple references to anything you think would help, that would be appreciated.
Thanks for you time.
