@Guido,
The code doesn't work with the last speed value (i.e, 2000)...
harish85
Last Activity: Jun 4 '12, 07:39 AM
Joined: Mar 5 '12
Location:
-
@Guido,
To make it clear..
I am looking for a subroutine\func tion which takes temperature and speed as arguments and returns me the mass value (interpolated or extrapolated value).
Sorry for troubling you.
Thanks a lot.Leave a comment:
-
Thanks for all your replies.
@ Rabbit, The table was framed with my own sample values and does not replicate the actual data. I was at the moment looking for linear interpolation only.
@ Guido - It was an excellent effort from you. I'm mesmerised indeed. Thanks a million.
I have few more questions on this.
1. Does it work well with extrapolation also? for example,the mass value @ 265 temp...Leave a comment:
-
Hi Guido,
I might not have been clear in my earlier post. I have attached an image of the table.
The sample table represents the mass values for various speed and temperature.
For example, 40 is the mass for temperature 285 K and 1600 rpm
What if i need to find the mass for a temperature of 277 K at 1500 rpm?
Also, i need to know how to extrapolate the data.
...Leave a comment:
-
Hi Guido,
I have the sample table in excel file but not sure how to attach the file to this post. Please help me.
Thanks..Leave a comment:
-
Table interpolation..
Hello all,
I'm very new to visual basic and would like to have your help.
I have a two dimensional table with the values representing the mass. Each row representing a speed and each column represents a temperature. So that for a particular speed and temperature, you have a unique mass value.
The speed and temperature values are entered by the user. The code should give me the mass value for that particular...
No activity results to display
Leave a comment: