Data in grid table

[carloc]

Hello everybody,
I'd like to have my Cc coefficient varying according to the values (h1-z)/d and angle � as per table below

(h1-z)/d Wingwall angle, �
30� 45� 60� 75� 90�
1,3 0,44 0,44 0,43 0,42 0,39
1,4 0,46 0,46 0,45 0,43 0,41
1,5 0,47 0,47 0,46 0,45 0,42
1,6 0,49 0,49 0,48 0,46 0,43
1,7 0,50 0,50 0,48 0,47 0,44
1,8 0,51 0,51 0,50 0,48 0,45
1,9 0,52 0,52 0,51 0,49 0,46
2,0 0,53 0,53 0,52 0,49 0,46
2,5 0,56 0,56 0,54 0,52 0,49
3,0 0,58 0,58 0,56 0,54 0,50
3,5 0,60 0,60 0,58 0,55 0,52
4,0 0,61 0,61 0,59 0,56 0,53
5,0 0,62 0,62 0,60 0,58 0,54

the value is then used in the formula:

Q=Cc*Ao*RADQ(2g*(h1-Cc*d))

Is this possible?

Thank you.

Carlo

[StuartBruff]

On 6/26/2009 4:49:13 AM, carloc wrote:
== I'd like to have my Cc coefficient varying according to the values (h1-z)/d and angle � as per table below
== Is this possible?

Yes. There's probably a better way, but this is just a top-of-the-head way.

Stuart

[StuartBruff]

On 6/26/2009 6:24:07 AM, stuartafbruff wrote:
On 6/26/2009 4:49:13 AM, carloc wrote:
== I'd like to have my Cc coefficient varying according to the values (h1-z)/d and angle � as per table below
== Is this possible?
>> Yes. There's probably a better way, but this is just a top-of-the-head way.

Oops. Forgot to add header for first entry ...

[ptc-1368288]

"x/y" 30� 45�..60�..75�..90�
1,3 0,44 0,44 0,43 0,42 0,39
1,4 0,46 0,46 0,45 0,43 0,41
1,5 0,47 0,47 0,46 0,45 0,42
1,6 0,49 0,49 0,48 0,46 0,43
1,7 0,50 0,50 0,48 0,47 0,44
1,8 0,51 0,51 0,50 0,48 0,45
1,9 0,52 0,52 0,51 0,49 0,46
2,0 0,53 0,53 0,52 0,49 0,46
2,5 0,56 0,56 0,54 0,52 0,49
3,0 0,58 0,58 0,56 0,54 0,50
3,5 0,60 0,60 0,58 0,55 0,52
4,0 0,61 0,61 0,59 0,56 0,53
5,0 0,62 0,62 0,60 0,58 0,54
__________________________________

Construct on the grid, then what ?



jmG

[TomGutman]

OK, you have a table. To use it in Mathcad, you need to put it into Mathcad. Either include it as data embedded in Mathcad (various forms are possible), or read it from an external file.

But then, what do you want to do with it? There are many ways in which tabular data can be used. A quick glance at your table suggests that a 2D cubic spline interpolation might be appropriate. For that you want to have your data as a matrix with the values and two vectors giving the values of the independent variables for the rows and columns.

Your table is not square, so the built in cspline won't deal with it. But th extended Cspline in my cubic spine routines will.
__________________
� � � � Tom Gutman

[ptc-1368288]

On 6/26/2009 4:49:13 AM, carloc wrote:
>Hello everybody,
>I'd like to have my Cc
>coefficient varying according
>to the values (h1-z)/d and
>angle � as per table below
>
>(h1-z)/d Wingwall angle, �
x/y 30� 45� 60� 75� 90�
1,3 0,44 0,44 0,43 0,42 0,39
1,4 0,46 0,46 0,45 0,43 0,41
1,5 0,47 0,47 0,46 0,45 0,42
1,6 0,49 0,49 0,48 0,46 0,43
1,7 0,50 0,50 0,48 0,47 0,44
1,8 0,51 0,51 0,50 0,48 0,45
1,9 0,52 0,52 0,51 0,49 0,46
2,0 0,53 0,53 0,52 0,49 0,46
2,5 0,56 0,56 0,54 0,52 0,49
3,0 0,58 0,58 0,56 0,54 0,50
3,5 0,60 0,60 0,58 0,55 0,52
4,0 0,61 0,61 0,59 0,56 0,53
5,0 0,62 0,62 0,60 0,58 0,54
>
>the value is then used in the
>formula:
>
>Q=Cc*Ao*RADQ(2g*(h1-Cc*d))
>
>Is this possible?
>
>Thank you.
>
>Carlo
______________________________

You have a data table, that you didn't have first. After that you should be more specific past the 3 collaborations. You have a plot, the rectangular data table ... then what ?

jmG