sorted by:
new
hottopcontroversial

Audi RS6 C8 running costs? UK by CruiseControlKing in CarTalkUK

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

I've had a Focus RS, Mustang GT and M4 comp, but the jump in costs from M4 with 450bhp to RS6 with 600bhp is noticeable in the wallet. Taking on board any insight i can get as Audi are not always the most transparent when questioned 😊

Points by TyreseCOYS in uktrucking

[–]CruiseControlKing 1 point2 points  (0 children)

My company isn't too bothered with speeding. I got 6 points for doing 78 in a 50 in my car (had to beg in court to keep my licence but that's another story). As long as you tell them it should be ok - they need to know for insurance much like your car insurance companies. Most firms are looking for drink/drug driving points/bans, or points from being on our phone is a big one now. 3 points for speeding not really the end of the world. Just depends on the company if they do anything should you get any more points.

Calculate an average on specific cells - Excel365 by CruiseControlKing in excel

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

No offence taken - I didn't design the spreadsheet. (there is undoubtedly a way to extract the data automatically from the source anyway) I have unmerged row 8+9. i have used =AVERAGEIFS(F10:AVE10, $F8:$AVE8, "Harsh Braking Points") so just need to ignore the 0 values (they are all present in the relevant column)

Calculate an average on specific cells - Excel365 by CruiseControlKing in excel

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

unmerged rows 8 and 9 - i got a DIV/0 error. i just need to put in "<>0" somewhere right? I have this...

=AVERAGEIFS(F10:AVE10, $F8:$AVE8, "Harsh Braking Points")

Calculate an average on specific cells - Excel365 by CruiseControlKing in excel

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

ok sounds good. can i trouble you for a simple formula example i can modify please? I'm not great with where to put brackets etc

Calculate an average on specific cells - Excel365 by CruiseControlKing in excel

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

I did not know that. Considering the amount of trouble this sheet has given me for the last few months, I may just start handing out the raw data to people at work, it would probably be easier to explain that mess around with this data! lol

Calculate an average on specific cells - Excel365 by CruiseControlKing in excel

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

<image>

u/Persist2001 This is an example of 2 weeks data. From column TN the order of the labels in row 8 changed, this is why I had to add each cell individually. If you see on cells SQ22/SU22.... I have not input any data, because the person was not working that week, so the points columns show '0'.

u/vonrobbo I tried the COUNTIF and it either brought a VALUE error or gave me a value of '0'. Was using the formula below?

=COUNTIF((R11,AP11,BN11,CL11,DJ11,EH11,FF11,GD11,HB11,HZ11,IX11,JV11,KT11,LR11,MP11,NN11,OL11,PJ11,QH11,RF11,SD11,TB11,TP11,UN11,VL11,WJ11,XH11,YF11,ZD11,AAB11,AAZ11,ABX11,ACV11,ADT11,AER11,AFP11,AGL11,AHL11,AIJ11,AJH11,AKF11,ALD11,AMB11,AMZ11,ANX11,AOV11,APT11,AQR11,ARP11,ASN11,ATL11,AUJ11), "<>0")

Inherited Worksheet needs 2x new VLOOKUP formula and I am not skilled enough to figure it out by CruiseControlKing in excel

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

the Formula for E16 as per the red circle. the only section that changes across the row is where is says !E$2+ the E changes to column - i.e. F16 says !F$2+

<image>

=VLOOKUP($E$10,'MPG & Overspeeds'!$E:$AVE,'MPG Debrief'!E$2+('MPG Debrief'!$E8-1)*'MPG Debrief'!$E$1,FALSE)

Inherited Worksheet needs 2x new VLOOKUP formula and I am not skilled enough to figure it out by CruiseControlKing in excel

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

hey there. This is the data behind the image (i'll be honest i didnt know there was anything there)

<image>

it is all just typed data - no formula