
Active Member

April 22, 2021

At the beginning I greet all forum members.
It was the first time that I made an ordered diagram of thermal power.
The horizontal lines are the power of the cogeneration engine.
I am asking for help and a hint, how to calculate the engine power intersection (horizontal line)
with the heat curve.
I would like to read on the "X" axis, how many hours a given engine will work.
I don't know how to go about it.
If anyone would like to help and guide, I would be grateful.
Kind regards,
Bogdan


July 16, 2010

Hi Bogdan,
Thanks for uploading your file. You can use INDEX and MATCH to find the hours at which the thermal power meets the MW limit. First you must sort the table on the data tab in descending order by hour.
=INDEX(A2:A8785,MATCH(C2,B2:B8785,1))
=6680
Hope that points you in the right direction.
Mynda

Active Member

April 22, 2021

Hi Mynda,
did someone tell you, that you are amazing women, who knows excel better than Gates? 🙂
Thank you for your help.
I'm a bit surprised that I have to sort the columns"hour" from the smallest.
Is it a possible, that your solution could be as similar "IF(MAX(E2:E8785)=E2;E2;NA())" and copy to all range, so only at the point with column A will be 6680, others #N/A. Then i can add on the chart, I think.
Bests,
Bogdan


July 16, 2010

Hi Bogdan,
I probably do know Excel better than Gates these days 😀 Only because he's not so involved in its development anymore.
The reason you need to sort the data is because you're looking for the hour at which point the thermal power is still below the threshold. The formula I gave you will only return one value, which is what I thought you wanted.
If you want to plot a point in the chart, then you can't use your formula because there's no exact match between the values in column B and the thresholds. However, you could use this formula in cell L2, then copy down (no need to sort the data):
=(INDEX($A$2:$A$8785,MATCH(C2,$B$2:$B$8785,-1))=A2)*A2
This will return hour 6679, which in hindsight is probably the correct answer. I'm guessing of course because I have no knowledge of thermal power 🙂
Mynda


July 16, 2010

You're welcome. The reason I mentioned not knowing the topic is because there's no exact match at the intersection as it's between hours, so you have to choose either the hour before or after it exceeds the threshold. Anyway, I'm sure you can figure it out from here. Glad I could help.
1 Guest(s)
