An attempt I made with your interpolation function to run the triple interpolation I am looking for. But my function only spits out values of 0...Any ideas?
Function p1p2p3_H2Os(prop1 As String, val1 As Double, prop2 As String, val2 As Double, prop3 As String) As Double
Dim pi As Variant
Dim...
Sorry for such a long reply. I did work your posts from the 26th. I have a question about the interp function you wrote. I got it to work and everything but, I do not quite understand what the function requires for input exactly. The t and v variant is throwing me off, could you explain that...
Didn't not know that about the different file types, thanks for the heads up.
I was thinking about that today actually, pulling the two bounds for val1, and interpolating but how do i do that exactly? Would functions like hlookup and vlookup be useful? My VBA knowledge is very limited sorry if...
I played around with the bounds some more, ended up that I had to place those commands right before the valmin and valmax lines. I didn't know order mattered lol
I haven't saved any of my work for the triple interpolation for the pressure groups, as I really haven't worked all that much on it...
I also have a question about Ubound and Lbound, if you dont mind answering that also. Im trying to make my code error proof as I need to add more tables with more arrays. Some of the arrays have 11 values instead of 12. This is a problem right here valmin = ti(0)
valmax = ti(11)
I attempted...
Hey Doug,
ya I looked at your interp function, It could streamline my code a bit but does not solve my pressure interpolation problem. Or I have not yet figured out how to write it properly. I've been messing with your and looking up other ways to do it. Basically what im trying to do was...
I've been trying to modify your interpolation function to work for pressures in between 6 and 35. My code just spits out errors. For the additional function to work, do you need to call it with something special or is it just as you posted?
The interp function you listed makes sense. I am a little confused though when you say I just need to call my function 3 times, I assume you are referring to the interpolation function you listed or my p1p2p3_H2Os?
But I think, what your saying is I want to nest this interp function 3 times...
Dam that worked, thanks a billion. Sometimes I cannot even spot my own simple errors haha. Do you have any idea how to get the code to interpolate properly between pressures? I have been looking around and it seems I need to write a double interpolation but is it possible to have a function...
Hi all,
Im pretty new to VBA coding in excel. But im trying to code the super heated steam tables and im having a bit of trouble. I only have pressure, temperature, and specific volume in the code right now, but I cannot get the code to spit out a non zero value. If someone could point me in...
