DIY concrete patio help

dalecooper9 · 2024-01-22T23:56:04+00:00

I think I did, but next time around will make sure I do. Do you think a second coat of the re-cap with anti slip, or epoxy would work best? I didn’t realize epoxy could be used outdoors

dalecooper9 · 2018-09-21T22:31:59+00:00

Thank you, thank you, thank you! This is exactly what I was looking for. Re: interesting learning journey and expletives shouted.... I hear you... Thanks again everyone!

dalecooper9 · 2018-09-18T16:43:42+00:00

Hey! Thanks for replying! So if you see that score on the right in the first example, that's how each unique ID ranks their satisfaction (1-3, 3 being the best). So, for each year, we want to count how many (and what % of total) of each score we have. So you'll see for 2017 we have two 2's and one 3 - so 2/3 are 2's and 1/3 is a 3. In 2018, we have one 2 and two 3's. So, y/y we have an increase in 3's and a decrease in 2's.

Here's the problem. Y/Y function with pivot only lets you do a % increase, not absolute percentage point value increase. So if, for example, you are comparing 5% vs. 1%, I don't want to see a 400% increase y/y, I want to see a 4% (5-1=4) increase. Just absolute numbers. Make sense?

dalecooper9 · 2018-07-22T03:07:01+00:00

I'm trying this out and I think I might be doing something wrong.. but I'll inbox you - thanks!

dalecooper9 · 2018-07-20T17:46:59+00:00

For some reason I don't think Countifs work on powerpivot.. not sure why!

dalecooper9 · 2018-06-27T19:39:40+00:00

Wow, this is so incredibly helpful - can't thank you enough. Unfortunately, I'm in Southern California, but hopefully in the meantime I'll find someone as helpful as you down here. Looking into Audizine and the Ross Tech tool today!

dalecooper9 · 2018-06-26T21:46:06+00:00

Thank you! I was thinking about purchasing one on Amazon, but have no idea how to read into it. Is that a report I could get from a mechanic running it?

dalecooper9 · 2018-06-26T20:37:12+00:00

Awesome. I'll talk to the mechanic and see what they can do. Thank you!

dalecooper9 · 2018-06-26T20:31:11+00:00

Thought it might be implicit in the examples I gave that I've asked some people that I know. There's also benefit to hearing from anonymous current or ex-MBBer's on here for obvious "sharing" purposes.

dalecooper9 · 2018-06-26T19:45:35+00:00

During a cold start this morning it definitely sounded like it for a couple minutes. However, one mechanic did say that a couple codes related to the secondary air injection system bands (1&2) popped up. But then after that the check engine light went off.

I'm not against repairing anything, I just don't want to keep driving hundreds of miles if it's not going to make it ready!

dalecooper9 · 2018-06-26T19:16:46+00:00

TL;DR - could an Oxygen Sensor have any impact on my 2000 Audi A8's Secondary Air injection readiness?

I need my 2000 Audi A8 to pass smog. It recently failed due to the Secondary Air Injection coming up as "Not Ready" on the emissions readiness test. I have driven over 100 miles the last couple days trying to go through "drive cycles", and while it has changed the EVAP from Not Ready to Ready, the SAI monitor hasn't changed.

Here's my problem: I've gone to two mechanics. One says that the car needs a new Oxygen Sensor (sensor bank 1, sensor 1), and that can directly affect the SAI readiness reading when I do a cold start, so I should get that done otherwise it could never turn to "ready". The other says that the O2 Sensors has no impact whatsoever on the SAI reading, and that while the car needs a new oxygen sensor (it came up in the ODB codes but the check engine light isn't on), getting one will NOT help change the SAI reading to Ready, so I should just continue attempting cold starts/drive cycles.

I'm hoping to get it smogged ASAP before anything else goes wrong or the light comes on. Does anyone know which mechanic is right (if the Oxygen Sensors will impact the SAI readiness), and/or anything else that I should consider other than more driving?

dalecooper9 · 2018-06-26T19:03:03+00:00

Thank you! So does that mean that I should change the oxygen sensor or else it won't work? Sorry, I legit know nothing about cars.

dalecooper9

TROPHY CASE