HELP : selectively retrieving a data from a table

  • Thread starter Thread starter Albert Byun
  • Start date Start date
A

Albert Byun

Basically, what I want to implement is as following:
**********************************************************************
Irms (current) is calculated from a formula and displayed in the following
table.

-----------------------------
| Irms | Requied Width |
-----------------------------
| | |
-----------------------------

Use this Ic value to run down a table and pick out 'Requied Width' that is
sufficient to carry that much Irms value
***********************************************************************

- Example 1 :

if Irms = 4mA

and the data table is

-------------------------
| Irms | Wire Width |
----- -----------------
| 1mA | 1x |
| 3mA | 2x |
| 5mA | 3x |
| 7mA | 4x |
-------------------------

The final table should look like this:

-----------------------------
| Irms | Requied Width |
-----------------------------
| 4 | 3x |
-----------------------------

- Example 2:

if Irms = 6mA

then the final table should look like this

-----------------------------
| Irms | Requied Width |
-----------------------------
| 6 | 4x |
-----------------------------

=>>> I need to implement this just in Excel spreadsheet not using any
external programming such as perl.

Thank you.
 
You can use Vlookup for this but it will give an incorrect answer as i
will lookup the next lowest value in the table.

Thus using it in it's normal form for Ic = 4mA it will give cable siz
2.

To overcome this you will need to ensure the value it looks up i
greater and this can be achieved by adding 1.9 to the entered value
(the more 9's the more accurate it becomes)

So if your table is in cells B10:C13 and your input current is entere
into B2. Enter the following into cell C2 (answer cell)

=VLOOKUP(B2+1.9,B10:C13,2)


The other problem you will encounter is when you reach the upper limi
on cable size. To overcome this enter the next number in sequence i
B14 and in C14 enter a message like 'Over size' amend the formula abov
to include these into the lookup table and everything should work.

hth
Mik
 
Back
Top