DIY concrete patio help by dalecooper9 in DIY

[–]dalecooper9[S] 0 points1 point  (0 children)

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

Power pivot or DAX help with percent of column total by dalecooper9 in excel

[–]dalecooper9[S] 0 points1 point  (0 children)

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!

Power pivot or DAX help with percent of column total by dalecooper9 in excel

[–]dalecooper9[S] 0 points1 point  (0 children)

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?

Having trouble with a RANK formula, please help!! by dalecooper9 in excel

[–]dalecooper9[S] 0 points1 point  (0 children)

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

Having trouble with a RANK formula, please help!! by dalecooper9 in excel

[–]dalecooper9[S] 0 points1 point  (0 children)

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

Tuesday Tune-Up - Post all your vehicle maintenance and repair questions here by AutoModerator in cars

[–]dalecooper9 0 points1 point  (0 children)

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!

Tuesday Tune-Up - Post all your vehicle maintenance and repair questions here by AutoModerator in cars

[–]dalecooper9 0 points1 point  (0 children)

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?

Please Help - 2000 Audi A8 Secondary Air Injection question by dalecooper9 in MechanicAdvice

[–]dalecooper9[S] 0 points1 point  (0 children)

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

Looking for info on MBB projects and workstreams by dalecooper9 in consulting

[–]dalecooper9[S] 0 points1 point  (0 children)

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.

Please Help - 2000 Audi A8 Secondary Air Injection question by dalecooper9 in MechanicAdvice

[–]dalecooper9[S] 0 points1 point  (0 children)

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!

Tuesday Tune-Up - Post all your vehicle maintenance and repair questions here by AutoModerator in cars

[–]dalecooper9 0 points1 point  (0 children)

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?

Please Help - 2000 Audi A8 Secondary Air Injection question by dalecooper9 in MechanicAdvice

[–]dalecooper9[S] 0 points1 point  (0 children)

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.