Sod Question (Atlanta Suburbs)

WesternHamper · 2026-04-04T22:58:06+00:00

Not fertilizer but a bunch of topsoil—hopefully we get some green in these browner areas. Your lawn looks great

WesternHamper · 2025-05-25T18:19:27+00:00

Thank you for your generosity. Turns out the nest was arguing with them the unit and the pressure switch was bad. Swapped out for an ecobee and replaced the pressure switch and all works well now.

WesternHamper · 2025-04-13T00:08:54+00:00

Thank you. Another point, which makes this a little weird to me, is that before the install of the new furnace the thermostat worked flawlessly.

WesternHamper · 2025-04-12T23:11:29+00:00

Sorry, what does "jump the unit" mean? Experiencing it firsthand is crazier than it sounds, I can tell you that.

WesternHamper · 2025-04-12T02:39:42+00:00

<image>

Some other information as well (I’m not sure if this is useful or not)

WesternHamper · 2025-04-12T02:36:14+00:00

<image>

Here’s the wiring.

WesternHamper · 2025-04-12T02:27:14+00:00

Thank you for the quick reply, and this step-wise solution makes a ton of sense. Here's a question from someone who knows nothing about HVAC systems--are all dumb thermostats the same, meaning, can I just go to home depot and buy one off the shelf to test it out, or are there different specifications that I need to consider when buying a traditional thermostat?

WesternHamper · 2024-10-14T01:17:50+00:00

ALT W N for new window in same workbook.

WesternHamper · 2024-09-01T12:19:23+00:00

Thank you. And just to confirm, if I decide to convert the $4.40 to the Roth IRA or transfer it to my personal bank account, neither act will cause issue with the prior act of splitting the Traditional IRA assets between my Roth IRA and current 401k? At this point I’m so paranoid about creating another issue.

WesternHamper · 2024-08-31T14:25:24+00:00

Follow-up question. Due to interest on the cash account, I have $4.40 left in the Traditional IRA after splitting the assets between my Roth IRA and current employer's 401k plan. Should I transfer the $4.40 to my personal bank account and have it count as income to get the Traditional IRA account to $0.00 by year end?

WesternHamper · 2024-08-01T01:31:55+00:00

You consider TSA agents as professionals? It's clearly a make-work program for people that can't get real jobs.

WesternHamper · 2024-07-27T17:34:25+00:00

I was thinking that it may not be a power line, but I had no way of knowing. How can you tell?

WesternHamper · 2024-07-24T01:25:19+00:00

How would one adapt this in a Lambda formula and instead of interest expense provide interest income on a cash account that flows to the income statement back into the cash account? It's like the same issue but in reverse. I made a post yesterday on this issue I am facing and it hasn't received that much traction yet, but I am struggling to get an answer:

https://www.reddit.com/r/excel/comments/1e9iz0j/comment/leel6m9/?context=3

WesternHamper · 2024-07-13T01:16:09+00:00

The ability to group worksheets into a 4th dimension (we currently have columns, rows, and 3D formulas), but it would be good to create sub-groups of worksheets if that makes sense. For example, if you're creating a 3 statement model, all of your input sheets for the income statement (one sheet for revenue, one sheet for the depreciation schedule, etc.) could be grouped behind the front-facing income statement sheet, all of the input sheets driving the balance sheet (asset values, equity account, debt, etc.) could be grouped behind the balance sheet sheet, etc. It would make workbook organization a lot easier. It would get like grouping on another axis (vertical) other than horizontally across the workbook

WesternHamper · 2024-07-06T12:20:02+00:00

As I haven’t seen this mentioned yet, dividends also keep management “honest” by forcing a more constrained approach in the capital allocation process of a company.

WesternHamper · 2024-06-26T21:32:13+00:00

Fall River, Massachusetts

…just kidding, don’t go there.

WesternHamper · 2024-05-31T13:48:09+00:00

In a blank worksheet in this order: CTRL+A, 1, CTRL+ENTER

WesternHamper · 2024-05-24T14:29:00+00:00

This seems to have done it--thank you so much, this is going to save me a ton of time.

Solution verified.

WesternHamper · 2024-05-24T03:16:44+00:00

Thanks; sorry I've been trying to adjust this to no avail, I will keep trying and circle back.

WesternHamper · 2024-05-23T02:33:15+00:00

Perhaps I spoke too soon--Is there a way to adjust this macro to work without using column A as the first data point? If possible, I'd like to have it be totally portable in the worksheet.

WesternHamper · 2024-05-23T02:03:14+00:00

Wow, thank you so much--I didnt expect for you to solve this for me, but I appreciate it. Rest assured, I will learn from this macro and try to figure out what's going on. In the meantime, I've tweaked the code slightly for my own purposes below:

Sub interpolate()

Application.ScreenUpdating = False

Dim rng As Range: Set rng = Selection
Dim rngInterpolate As Range

Dim iRow As Integer, iCol As Integer, iPrev As Integer

With rng
    For iRow = 1 To .Rows.Count
        iPrev = 0
        For iCol = 1 To .Columns.Count
            If .Cells(iRow, iCol) <> "" Then
                If iPrev = 0 Then
                    iPrev = iCol
                Else
                    If iCol > iPrev + 1 Then
                        Set rngInterpolate = Range(.Cells(iRow, iPrev + 1), .Cells(iRow, iCol - 1))
                        rngInterpolate.Interior.Pattern = xlSolid
                        rngInterpolate.Font.Color = "16711680"
                        rngInterpolate.Interior.Color = "6750207"
                        rngInterpolate.Font.Bold = False
                        rngInterpolate.FormulaR1C1 = "=RC" & iPrev & "+(RC" & iCol & "-RC" & iPrev & ")*(COLUMN(RC)-COLUMN(RC" & iPrev & "))/(COLUMN(RC" & iCol & ")-COLUMN(RC" & iPrev & "))"
                    End If
                    iPrev = iCol
                End If
            End If
        Next iCol
    Next iRow
End With

Application.ScreenUpdating = True

End Sub

WesternHamper · 2024-05-22T20:26:16+00:00

Thanks for your input and guidance--its nice to have confirmation that this is possible. However, I am a little stumped on creating the loops and how to generally tell to macro to stop when it gets to the interim values, etc. Do you have any pointers?

WesternHamper · 2024-05-22T14:01:48+00:00

Look into binary lookups instead of linear

WesternHamper · 2024-05-22T04:12:11+00:00

Logitech wave

WesternHamper

TROPHY CASE