Welcome! Here are the website rules, as well as some tips for using this forum.
Need to contact us? Visit https://heatinghelp.com/contactus/.
Click here to Find a Contractor in your area.
Excel Spreadsheet Help
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 "Yaxis" 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
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 "Yaxis" 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
0
Comments

try this..
I had to flip the graph around, but I think it works.
You need a true xy 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.
Tom0 
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 rightclick 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.0 
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...0 
Explaining Outdoor reset
This is the Excel Spreadsheet I use to explain outdoor reset and make sure everything is ontrack.
It is posted beside the boiler.
Doug0 
how about this one
Has the really important characteristic0
This discussion has been closed.
Categories
 All Categories
 85.2K THE MAIN WALL
 3.1K AC, Heat Pumps & Refrigeration
 55 Biomass
 424 Carbon Monoxide Awareness
 73 Chimneys & Flues
 1.9K Domestic Hot Water
 5.2K Gas Heating
 129 Geothermal
 160 IndoorAir Quality
 3.3K Oil Heating
 61 Pipe Deterioration
 884 Plumbing
 5.9K Radiant Heating
 376 Solar
 14.7K Strictly Steam
 3.2K Thermostats and Controls
 58 Water Quality
 49 Industry Classes
 89 Job Opportunities
 28 Recall Announcements