RMA
Member
I need to derive the concentration of a caustic soda solution. This is done using a rather complicated polynomial calculation using input and output temperature of the distillation towers. From a cycle time point of view, as well as the fact that I don't have SCL available, I decided the easiest way to handle this would be to use a look-up table using S7Guy's version of FC103 (Search for "CDT FC103" to find the relevant Thread).
The only problem is that to get the required accuracy, I need 500 entries in the table. In itself that's not too much of a problem, I've already worked out the values in Excel, so once I've created the DB, I can export it to Excel and then paste in the values - but how do I create the DB in the first place? I don't fancy creating it a line at a time 500 times!
Does anybody know if there's an easy way to create such large DBs?
The only problem is that to get the required accuracy, I need 500 entries in the table. In itself that's not too much of a problem, I've already worked out the values in Excel, so once I've created the DB, I can export it to Excel and then paste in the values - but how do I create the DB in the first place? I don't fancy creating it a line at a time 500 times!
Does anybody know if there's an easy way to create such large DBs?