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
Hi Bogdan,
Welcome to our forum!
Please upload a sample Excel file. After selecting your file, click the 'start upload' button.
Mynda
In my first post I added the excel files.
I will try again
Bogdan
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
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
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
Hi Mynda,
very very thank you for your help! 🙂
It doesn't matter:) You don't need to know that. It is important, that you know what is the value at the intersection heat curve (thermal power) with a straight line for example orange.
Anyway, thank you again.
Bogdan
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.
