Skip to Content
0
Former Member
Nov 26, 2009 at 02:34 PM

Selecting a value from Conversion Matrix created as a User Defined Table

12 Views

Hi All,

We need some help in selecting a conversion factor (value) from UDT matrix.

UDT Name = CONVERSIONS

My Matrix looks something like this:

Temp 0.7000 0.7050 0.7100 0.7150 0.7200 (Density)

5 1.0199 1.0197 1.0195 1.0193 1.0191

5.25 1.0196 1.0194 1.0192 1.0189 1.0187

5.5 1.0192 1.0190 1.0188 1.0186 1.0184

5.75 1.0189 1.0187 1.0185 1.0183 1.0181

6 1.0186 1.0184 1.0182 1.0180 1.0178

6.25 1.0182 1.0181 1.0179 1.0177 1.0175

6.5 1.0179 1.0177 1.0175 1.0174 1.0172

6.75 1.0176 1.0174 1.0172 1.0170 1.0169

7 1.0173 1.0171 1.0169 1.0167 1.0165

7.25 1.0169 1.0167 1.0166 1.0164 1.0162

7.5 1.0166 1.0164 1.0162 1.0161 1.0159

7.75 1.0163 1.0161 1.0159 1.0158 1.0156

8 1.0159 1.0158 1.0156 1.0154 1.0153

The user will be capturing the Temp & Density on transaction level and we are then again trying to gather the applicable conversion factor.

Thanks