Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Combinations
Hi,
I have a set of engine run data for 4 engines. Different engines are on at different times and I want to know a common value, say the blended oil temp if they all share a common oil loop. I've figured there are 15 non repeating combinations and for each combination there is a different oil temp. How could I go about determining what my oil temp will be based on which engines are on for the data given? Thanks -- S. Casey |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Variable Combinations
So you have 4 motors. That gives you 15 combinations (assuming that at least
1 is running). The combinations a 1 12 123 1234 124 13 134 14 2 23 234 24 3 34 4 Assuming that you have tempratures for all of the different combinations then it should just be a matter of assigning the temprature to the above combinations. At that point a simple VLookup (or similar) will get you the correct value. -- HTH... Jim Thomlinson "S. Casey" wrote: Hi, I have a set of engine run data for 4 engines. Different engines are on at different times and I want to know a common value, say the blended oil temp if they all share a common oil loop. I've figured there are 15 non repeating combinations and for each combination there is a different oil temp. How could I go about determining what my oil temp will be based on which engines are on for the data given? Thanks -- S. Casey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to graph x-variable versus y-variable in Excel ? | New Users to Excel | |||
can i link a variable cost code with a variable sum | Excel Discussion (Misc queries) | |||
variable height variable width stacked bar charts | Charts and Charting in Excel | |||
Sum cells based on a row variable and seperate column variable | Excel Worksheet Functions | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions |