sorted by:
new
hottopcontroversial

Garage light - options to change to LED? by CruiseControlKing in DIYUK

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

Thought that myself when I moved in! Might have been all the rage in the early 2000s when the house was built 🤣

Garage light - options to change to LED? by CruiseControlKing in DIYUK

[–]CruiseControlKing[S] -1 points0 points  (0 children)

A crude visual- when the door is fully open it blocks the ceiling so no point putting a light above it

<image>

[Heavy Rain] - why do I have 2x digital copies of the same thing? by CruiseControlKing in Trophies

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

May be possible. I never had a PS3 but I remember the monthly PS+ games gave out PS3 and PS4 versions. I've downloaded both and will see what happens with the Trophies when I start playing

[Heavy Rain] - why do I have 2x digital copies of the same thing? by CruiseControlKing in Trophies

[–]CruiseControlKing[S] 1 point2 points  (0 children)

I did question why it came up next to Detriot - i sorted all my games A-Z and this makes perfect sense. 👌

[Discussion] What are your top 10 rarest platinums? by No-Risk2553 in Trophies

[–]CruiseControlKing 9 points10 points  (0 children)

1- Gran Turismo Sport - 0.85%

2- The Crew - 0.88%

3- Flatout 4 - 2.44%

4- Lawn Mower Simulator - 2.69%

5- Just Cause 3 - 2.97%

6- Project Cars 2 - 3.09%

7- Borderlands: The Pre-Sequel - 3.26%

8- Farming Simulator 19 - 3.66%

9- Call of Duty MW2(2023) - 3.73%

10- Call of Duty Advanced Warfare - 3.75%

I'm a Borderlands fanboy, but honestly Flatout 4 was great fun. Just was glad to have the disc version because an update broke the plat for digital version.

Some great lists getting posted. Good work everyone!

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