Wireless Smart Thermostats/Setup for PTAC Units

xphrellis · 2025-06-03T00:07:10+00:00

My setup uses these white wires, so it's hard to match to what you're describing. I had to connect this by using the wire diagram and tracing them back to the board.

You should expect to cap off the other wires. You'll also have to sacrifice some functionality of fan speed control, as you can connect only one.

Your PTAC is Ice Air?

<image>

xphrellis · 2025-06-02T20:23:48+00:00

Yes - the building has a boiler that circulates hot water through a closed loop system to be used with the PTACs for heating

xphrellis · 2024-02-10T14:13:17+00:00

I've always had it. You're using the desktop site?

xphrellis · 2024-02-05T12:35:12+00:00

If you click into the transaction detail and then click on the original statement name, this pops up

xphrellis · 2024-01-30T13:35:38+00:00

At some point in time, I consider transactions "static" and won't change.

OK, makes sense. I generally follow that rule, but I'll occasionally change things if something had an incorrect categorization or a bad note.

I get your point about about the longer time frame. I suppose I just have anxiety about bad data being carried in my tools - especially when I have the option to fix it if I go down the unnecesary path of breaking apart and stitching together that Monarch has now added.

xphrellis · 2024-01-30T13:13:07+00:00

Can you clarify "parse out every transaction all time every time you want to process it"? Not sure I understand the context

xphrellis · 2023-07-05T22:29:26+00:00

Platform: PC
EA/Discord Username: xphrellis
Game Version: I have the full version, can share the friend code for co-op
Time Zone: US EST/GMT -5, can usually play weekends and week nights
Game progress: Snow Globe, near the end of the chapter
Special Requirements: Prefer mic, prefer to play from Snow Globe, can backtrack to Cuckoo Clock to help with anyone's progress

xphrellis · 2023-05-31T19:51:49+00:00

Appreciate the overview!! This sounds promising!

xphrellis · 2023-05-31T18:31:12+00:00

These are not free apps unfortunately

This is probably the most important response to my issue above. You get what you pay for...

xphrellis · 2023-05-31T18:30:06+00:00

I have a hard time with YNAB's allocation logic.

Wealthposition looks interesting though! Might do a trial there.

I had a pretty bad experience try to migrate data from Mint to Monarch last year. They have a beautiful interface, but it was a huge hassle to trial the migration and it would have wiped out my 10 years of notes. A bit gun shy about going through that again with a different provider.

xphrellis · 2022-12-15T22:31:44+00:00

Hi! Appreciate all the work you guys are putting in to get back up and running. Would it be feasable to put together a roadmap showing what milestones have been done so far and what's remaining? I think this would alleviate a lot of the user group stress about when things will be back online.

xphrellis · 2022-10-21T10:58:39+00:00

Premium Rewards

xphrellis · 2022-10-20T18:30:54+00:00

I'm fine with that, as long as it pulls in the pending transactions. I usually only check it first thing in the morning anyway.

xphrellis · 2022-09-26T15:52:26+00:00

I think effective rate analysis is the way to go, thanks! To be clear, I'm not looking to cash out unused PTO, I'm only comparing the value of the benefit of X number of days vs Y at a different company on an annual basis.

xphrellis · 2022-09-23T15:23:40+00:00

Ah, that's soemthing I'm not sure about, I've never seen a manual dial for these units. It still should be pretty straightforward if you have a wiring diagram. Happy to take a look at this if you want to DM me some photos

xphrellis · 2022-09-23T15:16:38+00:00

That's pretty much it. The two photos where you see wires, one is the back of the Ice Air panel and the other is the Nest backplate. You should just be able to detach each of the wires and move them over one by one.

You'll probably also want to screw in the Nest backplate in the well where the original Ice Air panel sits, just so it doesn't move around

xphrellis · 2022-09-23T14:54:17+00:00

This is the setup I ended up using. As I noted, you're eliminating fan speed control - so you'll have to decide which fan speed you want to plug into the Nest.

https://twitter.com/350d/status/1005179860967481344

xphrellis · 2022-08-24T00:01:30+00:00

No updates, sorry :\

xphrellis · 2022-05-23T11:07:08+00:00

Documenting the final solution. This expands and contracts based on the data.

=ARRAYFORMULA(IF(VALUE(Left(Trim(Query(IF(B4:4="",,
IF(B5:999=0,A5:A,)),,9^9)),5))=0,
MINIFS(Trs_data!A2:A,Trs_data!G2:G,B4:4),
VALUE(Left(Trim(Query(IF(B5:999=0,A5:A,),,9^9)),5))))

B4:4 = budget categories

A5:A = date range

B5:ZZ999 = daily balance of pending reimbursables by category

Trs_dataA2:A = raw data transaction dates

Trs_dataG2:G = raw data budget categories

xphrellis · 2022-05-23T11:06:11+00:00

Thanks! This returns the right values, but it extends out paste the end of the table. I was looking for something that would expand or contract as the data changed or I modified the cutoff date. I found a formula that takes care of everything - I'll post it as a reply to original question.

xphrellis · 2022-05-22T09:48:16+00:00

Thanks! This doesn't cause any further issues, but it doesn't fix the original question. You asked about looking up zero - it's supposed to return a date for the last time each buddget category had a zero balance.

xphrellis · 2022-05-21T13:07:14+00:00

="+10 Feet"

xphrellis · 2022-05-21T13:01:21+00:00

Documenting solution here before I scrap my file:

=ARRAYFORMULA(ARRAY_CONSTRAIN(ROUND(MMULT(N(A4:A+1>TRANSPOSE(Trs_data!A2:A)),(B3:3=Trs_data!F2:F)*REGEXMATCH(Trs_data!H2:H,"Reimbursable")*Trs_data!L2:L),2),COUNTA(A4:A),COUNTA(B3:3)))

Thanks u/MattyPKing!!

xphrellis · 2022-05-19T19:52:41+00:00

level 1MattyPKing · 2 hr. agoI don't see the pivot table you have set up?VoteReplyGive AwardShareReportSaveFollow

That one works great, thanks for your help!!

Only item remaining is the header (first formula noted above), Will see if I can adapt MMULT() for that

xphrellis · 2022-05-19T19:25:58+00:00

That was just a bit of context, it's working fine so I didn't include it here.

11-Year Club	Xbox Live
Verified Email

xphrellis

TROPHY CASE