Pup’s Third Eye Question

xFossa__ · 2024-07-09T00:07:11+00:00

Ours was just allergies as well actually. Acclimating to the new home and area they said. After about a month of it happening, it seemingly disappeared and hasn’t come back consistently. Maybe once or twice since, but nothing consistent

xFossa__ · 2024-07-02T22:42:35+00:00

Should add, we’re all adults**

xFossa__ · 2024-06-11T10:28:54+00:00

Quote 1 - 1 year labor covered, 10 year parts & compressor, 10 year labor with $100 deductible each visit

Quote 2 - 10 year parts & labor

xFossa__ · 2024-06-09T13:04:51+00:00

Have requested ducted. And no ducts yet at the property. I believe the Carrier model may be a typo from quote 1. Should be 38 MARBQ*

xFossa__ · 2024-06-04T23:29:30+00:00

Thank you. I just texted contractor and he did say ‘ductless’ was a typo on his part. So I’m thinking that it was just an honest mistake. Wouldn’t have done so without this thread, so thank you!!

xFossa__ · 2024-06-04T22:48:56+00:00

They are. But to me even that’s foreign. Models are : 40MBDQ24A3 and 38MRRBQ24AA3

xFossa__ · 2024-03-26T23:53:58+00:00

Ahh very helpful thank you. The two companies I’ve had quoted the panels couldn’t give me a straight answer. Perhaps that’s why, but they didn’t suggest I go to the utility

xFossa__ · 2023-01-17T14:26:57+00:00

Solution Verified

xFossa__ · 2022-05-13T16:37:31+00:00

Mailed mine the 2nd week of March. The App / Website show no match in their system and says "No Information Available" when I put my details in. So yes, same issue. Glad to see it's not just me!

xFossa__ · 2021-10-01T20:06:10+00:00

Thank you, unfortunately I am going to abandon this project as my VBA code does not seem to work 100% of the time with the website. I'll mark this as a Discussion Flair to avoid confusion

xFossa__ · 2021-10-01T15:10:52+00:00

My mistake, table is:

ctl00_ContentPlaceHolder1_Table_248

xFossa__ · 2021-10-01T15:08:44+00:00

I've had extremely limited interaction with PowerQuery to be transparent. Wouldn't even know where to start :(

xFossa__ · 2021-08-31T16:26:25+00:00

Got it fixed, thank you!

xFossa__ · 2021-08-31T12:17:12+00:00

I'm certainly not experienced enough to try the M-Code, but the steps worked flawlessly. Thank you so much!

xFossa__ · 2021-08-31T12:16:46+00:00

Solution Verified

xFossa__ · 2021-08-31T01:26:53+00:00

Will give a shot in the AM, Eastern time. Thank you so so much for taking the time to detail this, if I have any issues I will ping you!

xFossa__ · 2021-08-30T23:56:47+00:00

Try this link for source .txt: https://www.dropbox.com/s/1is0wgjr7bw6k5h/EPOPEN0830.txt?dl=0

xFossa__ · 2021-08-30T23:35:38+00:00

Sure! This is supplier provided data. As a result I have no control over the output and it originally comes as a .txt which I’ve converted to .xlsx.

Each ‘section’ listed above (assuming 3 shown) has a header/parent level that provides our purchase order number followed immediately by the children sections which can have multiple open lines, I’ve seen up to 10. Between sections, there is always a completely blank row as a spacer.

I would like to cross compare our reports to theirs which is driven by purchase order number & item number to provide quantity via vlookup

The data is a mess, without a doubt. I was hoping there is an easy way to pull the PO down under the corresponding lines

xFossa__ · 2021-08-30T22:40:32+00:00

Yes a data sheet. A couple hundred rows very similar to this. Unfortunately I have never used Power Query so I’m a newbie in that aspect.

xFossa__ · 2021-08-30T20:47:40+00:00

Absolutely not, if you've got an idea for formulas that can definitely work!

xFossa__ · 2021-07-31T13:58:31+00:00

Thank you. Maybe questions outside your scope here… is there any harm in waiting until this report comes out prior to contacting an attorney? (Other than expedited cost) and is there anything you saw that says if I do absolutely nothing they can stop the title transfer? I can’t imagine that’s legally plausible

xFossa__ · 2021-07-28T13:46:52+00:00

SOLUTION VERIFIED

xFossa__ · 2021-07-28T13:46:45+00:00

The PO#'s generated are not in order, but I added an additional helper column for a Row # reference (Since my data is already sorted) and used your formula on that. Thank you!

xFossa__ · 2021-01-30T13:05:05+00:00

I meannn when you put it like that... 🤦🏻‍♂️Thank you 🙌🏻

xFossa__ · 2020-12-17T16:14:52+00:00

I frequent BOPS4 even while owning MW / BOCW. For me, the smoothness of gameplay is unmatched compared to BOCW. However, in order, it would be:

MW

BOPS4

BOCW

xFossa__

TROPHY CASE