Welcome! Here are the website rules, as well as some tips for using this forum.
Need to contact us? Visit https://heatinghelp.com/contact-us/.
Click here to Find a Contractor in your area.

Excel Spreadsheet Help

Paul Rohrs_4
Paul Rohrs_4 Member Posts: 466
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?




  • Tom S.
    Tom S. Member Posts: 94
    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.

  • Rik
    Rik Member Posts: 10
    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
    Uni R_2 Member Posts: 589
    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.


    Here's how a moron like me would have done it...
  • Doug_7
    Doug_7 Member Posts: 244
    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.

  • realolman
    realolman Member Posts: 513
    how about this one

    Has the really important characteristic
This discussion has been closed.