TU Rob

quote:

---

I’ve heard of people doing that with the newer 100% aluminum evaporator coils, including HVAC techs, how effective it might be I don’t know, but I don’t see any significant downside in trying.

---

Think I'm going to try it. My air handler is in my basement garage, so I have a PVC tube that drains into a pump, which pumps it up and out in some clear tubing. I've been using a liquid cleaner to keep the lines clean, and haven't had any issues with them getting clogged since I started doing that, but every so often I'll hit the pan with a shop vac. It is fairly small, and only really happens in the hot humid months. I check it when I change my filters and last week noticed the gunk in there. It was thin, maybe only a half inch thick, and in one corner of the pan about 2-3 inches across. I've got some copper pipe fittings I'm going to put in each corner and see how it does the rest of the summer.

quote:

---

CrawDude

---

Interesting. So I did a little reading, and should probably switch up what I'm using to flush the lines out. Would a small piece of copper in the drain pan help?

I love my Honeywell thermostat. It doesn't have any of these features, it just has timers you can set for temps, and you can set the fan to auto so it only runs when the A/C is running, circulate so that it will also blow while it is off, or on so that it runs continuously.

That being said, since we're talking A/C issues, what would cause a slimy gunk to accumulate in my condensation drain pump? I've been using a drain line cleaner liquid in there about once a month, but once or twice a year I have to take the lid off and shop vac out some gunk.

I've got an old corded Wahl haircut clipper set. Use a guard for the trimming, take it off to line up the neck, then shave with a Mach 3 old razor. No clippers get it close enough, but I do have a Braun electric razor I sometimes use on my neck and cheeks if I don't feel like using the bladed razor.

It has to be the old glass bottles. Just isn't the same with a 20 oz plastic bottle. I think they were 8 oz glass bottles back in the day. The closest thing you can get today are the Mexican Cokes with cane sugar.

I've got three big spreadsheets with around 80 tabs each. Two of them have identical workbook names, the only difference being the year. The tab names are also identical, and are all a 3 digit number that corresponds to a department code in our accounting software.

What I am trying to do is in my main file, use a vlookup formula to reference those two other files and pull in actual revenue and expenses. My lookup will be the same column set in the identical workbooks. B through H columns. They also all start at row 10. So my current formula looks like:

=vlookup(A10,'[BudgetExport 2025 Actuals.xlsx]359'!$B1$12;$H$106,7,false)

Is there a way to embed a formula to replace the '[BudgetExport 2025 Actuals.xlsx]359' with something that reads two cells in my current workbook and put the year and tab name in there where it has 2025 and 359'. I've tried concatenate, but that doesn't seem to work.

In Summary, starting at row 10 in each of my tabs I want a formula that references A10 down through A105 or so, and is looking up values from each of the other two workbooks that can quickly read the year and tab name. Not sure if this is possible, but if I could write one formula and copy/paste that down my rows of data instead of manually typing a vlookup and clicking over to the other two workbooks it would save a ton of time.

quote:

---

its still not quite right. shite should be flowing down hill and without backing up and out of a cleanout (cap or not). Might have a bit of a restriction down the line.

---

Yeah I get that. I think it is due to the hilly area I live in. Our driveway is downhill, and rain water washes down the driveway and into my backyard. It slopes gently down for about 2/3 of the yard, then flattens out near the back of my property. The cleanout sits right there where the yard begins to flatten out, so sometimes there is standing water in that area right after a rain. I think it is just a perfect storm of the yard not having time to dry out between the daily rain we've been getting, the cap being broken off, and whenever we do laundry or take a bath you're getting more constant flow than just a toilet flushing or a shower running. We've got a freestanding tub that holds probably 35 gallons and if my wife takes a bath, when it drains out it goes fast. It wasn't a ton of TP that I saw, probably from one sitting, and there hasn't been any more come out that I can tell in the last couple of days. She probably got out of the tub and let it drain, then went to use the toilet, and all of that flow together the TP would be floating along and get pushed out the top of the broken cleanout cap. I'm going to get my plumber to come run his camera and check for any other cracks and replace the cap for me. I wouldn't mind just getting the cap and replacing it, but peace of mind to know that is all that is broken is worth it.

quote:

---

You do mean sewage and not septic?


Rain shouldn't do anything to your end of a sewage to city. Rain can absolutely mess with a septic that is starting to experience problems.

---

Yes, we're the last house on our street connected to sewer. There is a storm drain that runs under my driveway, and the sewer pipe exits the rear of my house, takes a 45 degree turn and connects into that drain at the edge of my yard. The 4 or 5 to my left all have septic tanks.

I guess my question was more if the cap is loose or if there's a crack underground, would all the sopping wet soil have some TP come out. It isn't a ton, I just noticed a small spot maybe 2-3 feet around with a thin layer of mushy TP on the ground around the cleanout. It hasn't rained today so I'm hoping the sun and heat dry it out some this afternoon, and when I get home tonight I'm going to go see if the lid on the cleanout has come loose.

We've gotten a ton of rain in the Birmingham area lately. No really bad storms that knock out power and down trees where I live, and no real bad dumping inches of rain in a short amount of time type storms, but we've had measurable rain for what seems like every day for a couple of weeks.

Yesterday afternoon it was finally sunny, and I was out in the yard doing some cleanup I've been waiting on a dry day for. I noticed mushy toilet paper on the ground around the cleanout by my fence. I'm thinking either a cracked pipe, a loose cap, or a broken connection. Anyone ever experienced this? I'm not getting any backup into the house, which is good, but I'm going to need to tackle this soon. It was so swampy and smelly that I didn't feel like exploring the cause yesterday, but just curious if large amounts of rain would cause something like this or if I have something broken.

In the 90s, Miami won one and played for another. FSU in 1993. Nebraska had the next two then Florida got theirs. Then Tennessee and FSU again. So two teams in their state, one in their division, and another from their conference won it all during his time. Throw in Frazier and Nebraska in the middle of it all.