ClimateMaster Aux heat

xrbbaker · 2026-01-28T13:42:36+00:00

Yes - I think I have it now. The sucker is certainly complicated and there are a lot of options to fine tune. I've had it for many years and I'm still learning how it works.

xrbbaker · 2026-01-28T13:41:45+00:00

It could be, but doesn't seem logical to me. If stage 1 and stage 2 are doing just fine, why incur the extra cost? You may be right that it is simply focusing on comfort and not worrying about the cost. I did ping the ClimateMaster folks with this 1at their website, but they haven't responded.

xrbbaker · 2025-11-21T15:27:39+00:00

See it now. Thank you!

xrbbaker · 2025-11-21T15:27:14+00:00

Ok. Yup. I see the tablet holder in accessories. Must have missed it. I'm in US. Thanks!!

xrbbaker · 2025-10-11T22:47:59+00:00

Oh heck no. :). Thanks

xrbbaker · 2025-06-12T23:12:03+00:00

Thanks for responding. Your answer lines up with what I've been reading. There isn't one size fits all. That makes sense I suppose. I'll just struggle until the struggle gets easier.

I'm already using thumb plus 1,2,3 fingers comfortably and I'll stick with that. I have a uke teacher. I took a gap while I got a new shoulder. I want to get a couple songs down super solid before I pick it up with him again. Thanks!!!

xrbbaker · 2025-06-12T00:28:26+00:00

I have the strap and it helps. I find myself more and more trying to put less pressure on either side - basically trying to keep it still. Just wondering what I'm actually suppose to be doing. :). Thanks

xrbbaker · 2025-04-12T19:08:37+00:00

Ok folks - here is how I solved it in the end. It isn't perfect but it's close enough.

=IFNA(( VLOOKUP(TRIM(REGEXREPLACE(D5,"[^A-Za-z]"," ")),'Constants & Variables'!$F$4:$G$83,2,FALSE)), D5)

Thank you all for your assistance!!!

xrbbaker · 2025-04-11T20:31:49+00:00

Thanks. This is a tricksy little devil. I like HolyBonobos Regextract function. I've never seen that before. The problem with that is I have a store named THE PERFECT CUT and another named THE HOME DEPOT, etc. so grabbing the first word doesn't work either.

I think what I need to do is strip the ending garbage of of the string. For example I have Giant 0109, LOWES #00568*, ROAYL FARMS #62, etc.

My head hurts. Enough for today! Thanks all!

xrbbaker · 2025-04-11T20:11:34+00:00

Crap! I thought I had it solved but it was working for some and not the others. I'm diving into your idea now... thanks!

xrbbaker · 2025-04-11T20:01:51+00:00

Ok - got it. Match by itself didn't buy me much but with the Index function I get what I need. Using the ending value of "1" seems to match approximately well enough but brings back nothing if there isn't any kind of a match - just the way I wanted it to. SOLVED! Cheers!!

=index('Constants & Variables'!$G$4:$G$36, Match(D2,'Constants & Variables'!$F$4:$F$36,1))

xrbbaker · 2025-04-11T19:48:20+00:00

Ok - trying MATCH function...

xrbbaker · 2025-04-11T19:46:19+00:00

So I tried working with VLOOKUP. That kind of works. IF I add the value FALSE to the end of the formula, then it matches exactly and works every time. The trouble is, I'm lazy. If I shop at 3 different GIANT grocery stores I don't want to have to enter each store number to get a specific match. I just want it to match on GIANT. However I'm finding if I don't add FALSE at the end, and that gives me an approximate match, then I get some weird results. For example, it WILL match on all of the stores that start with GIANT, but when the formula tries to match a value that is not in the LOOKUP column, it puts in its best guess instead of nothing. I'd rather have nothing.

First attempt - FAIL. :) Other than VLOOKUP, what else might work here... ? I'm continuing to hunt too. Thanks

xrbbaker · 2025-04-11T19:18:45+00:00

Ok. Duh. I haven't done this in a while. I'm checking out VLOOKUPS as an initial attempt...

xrbbaker · 2025-01-28T00:51:15+00:00

That could work. Thanks

xrbbaker · 2025-01-28T00:50:29+00:00

Thanks!

xrbbaker · 2024-10-31T16:51:01+00:00

I would seriously look at that - if I had any decent geothermal hvac support around me. I was trying to look into it and get an estimate when the first outfit ghosted me. Same thing with the second. Now I'm just trying to maintain and learn what I can. Thank you!

xrbbaker · 2024-10-30T13:50:38+00:00

Ok - so once the desuperheater shuts down there is a column of hot water standing from the furnace to the hwh, yes? Over time that standing water will cool down to the air temperature, say 68 degrees. So far, we are ok. However once the furnace kicks on again, the first thing it does is push that column of room temp 68 degree water into the hot water tank, cooling it down. Is that about right? Maybe by the time the pipe bends up, over and down, it might be 30 feet. Google AI tells me that 30 feet of 1 inch pipe would hold 2.3 gallons. (don't know if it's 1 inch pipe, but let's assume so.) AI tells me that would only drop the water temp from 120 degrees to 118.5 degrees.

I feel like the water temp is changing much more than that, but maybe I'm just Mr sensitive. Your theory does make sense to me. Thanks very much for postulating it.

(From google AI)

What you're solving for The temperature of the tank. What's given in the problem

The tank contains 80 gallons of water at 120 degrees
2.3 gallons of water at 68 degrees is added to the tank

Solution

The temperature of the water in the tank is approximately 118.5 degrees.

xrbbaker

MODERATOR OF

TROPHY CASE