Re: linked tables
Drivers page is called Inputs and the workings page is called Requirements.
Thanks!!
Alastair
Re: linked tables
Drivers page is called Inputs and the workings page is called Requirements.
Thanks!!
Alastair
Re: linked tables
Hi Bill,
I have encountered a problem while integrating this into my worksheet. All my drivers for the original output are in a separate sheet in the same workbook. When these drivers change, the code is not activated. Is there a quick fix for this?
Regards,
Alastair
Re: linked tables
Hi Bill,
That looks perfect. In order to keep things simple in my explanation I adjusted my problem slightly, and hadn't noticed that this would lead to the problem of the third box.
This does look like exactly what I need though, Thanks for all your time and help!
Alastair
Re: linked tables
The capacity changes each year, so in one year the capacity could be above the limit and so the connection would have to change.
Have altered the spreadsheet to demonstrate what I mean. (Not updated the code though)
Many Thanks,
Alastair
Re: linked tables
This looks exactlythe kind of thing I am looking for.
Except...
- Ideally I need Formulas, I want this to run over 10years, and this would mean running 10macros, or running that macro 10times.
- Also the same calculation is repeated in three other parts of the sheet, with different boxes, capacities and connections. This would mean running the code 30times.
- Another requirement that I forgot to mention (apologies!) is that if no connection can be found then it should equal 0.
Is any of this possible?
Again, Many Thanks for the help so far,
Alastair
Re: linked tables
Box 1
Connections Connection capacities
E1 2Mbps
E3 40Mbps
STM-1 150Mbps
Box 2
Connections Capacities
E1 2Mbps
STM-1 150Mbps
STM-4 512Mbps
Box1 feeds box 2 and the output of box 1 is 35Mbps. The lowest connection I would need to send the output is an E3, but since box 2 does not support an E3 I should use an STM-1.
My current formula is
{=MIN(IF(Inputs!$C25:$C30/D25>=1,Inputs!$C25:$C30))}
where inputs!C25:C30 are the connection capacities and D25 is the output. As you can see though this doesn't account for the fact that the connector is not compatible with Box 2.
Many thanks for responding!!
Alastair
Hi All,
I have a problem.
I have a formula that selects the lowest connection pipe possible to two pieces of equipment. I need to extend this formula so that it will pick the lowest connection that is compatible with BOTH boxes. For instance:
box one is compatible with a b and c
box two is compatible with a b and d
The lowest connection possible works out to be c, but since this is not compatible with both boxes I need to select b.
Any help much appreciated!
Alastair