Excel Spreadsheet Help

Paul Rohrs_4

To customers is a simple task. Visual aids always help.

I have an existing spreadsheet that plugs in the numbers for reset, but it seems this spreadsheet could be improved upon a little bit.

I can plug in, Min and max air temps as well as min and max water temps. The addition of "Current Temp" would really help show how the shift in outdoor temp redefines reset temp.

Take a look at the existing spreadsheet and plug in the numbers you want. Now look at the attached PDF. Everything in red is what I would request. Not only the addition of the 2 cells defining current temp, but the red lines illustrating their relationship and the addition of the rest of the temps on the "Y-axis" would be helpful.

I can create and do simple functions with spreadsheets, but reprogramming the spreadsheet to alter the graph is a few steps beyond my abilities.

Can anyone offer any assistance?

Regards,

PR

Tom S.

try this..

I had to flip the graph around, but I think it works.

You need a true x-y graph, not a line graph, and I have calculated the slope/intersect of the line to figure out the extra red dashed lines.

Enter a value in "current temp" field, chart should update and the cell below the current temp reports the corresponding water temp.

You could drag the graph over the calculated cells to hide them (to make it look nice) and of course format the graph more to your liking.

Hope this helps.

Tom

Rik

how's this

Tom is right about using an XY (scatter type) plot rather than a line graph. Here is a version with the X axis flipped. (You can right-click while over the X or Y axis of the graph, select Format Axis..., then under the Scale tab you can change the axis limits, flip the axis, etc. Hope this is useful for you.

Uni R_2

Why do I always do things the hard way? ;-)

Now I have to redo my own ODR curve! ;-)

Tom was very clever using the third range. Rik, you topped that with a solution that was beautifully elegant and simple. The custom number formatting was also a great touch.

Kudos!!!

Here's how a moron like me would have done it...

Doug_7

Explaining Outdoor reset

This is the Excel Spreadsheet I use to explain outdoor reset and make sure everything is on-track.

It is posted beside the boiler.

Doug

realolman

how about this one

Has the really important characteristic