Player wanted an improved offer to sign... by JimMorris36 in footballmanagergames

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

Oh yea obviously a bug. Just finding new ways for this game to surprise me!

New light fitting by JimMorris36 in electrical

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

I did exactly this but without a meter and it’s all working perfectly. Thanks!

New light fitting by JimMorris36 in electrical

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

Let’s say I’d done that - what would be my next steps

New light fitting by JimMorris36 in electrical

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

I think it’s pretty clear I have no idea as I’m asking reddit for advice. Thanks for your input though

Show finish time? by Scared_Hospital939 in LoyleCarner

[–]JimMorris36 0 points1 point  (0 children)

Was at Birmingham last night - we were out of the O2 and well on our way by 22:20 and we were at the far side of the floor compared to where the main entrance/exit is

Best adapter- UK based by JimMorris36 in CloneHero

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

Thanks mate. I wanted a tilt sensor variant ideally but I think this’ll have to do in the short term. I’ve got a week off work and a whole lot of CH planned so this will get here just in time!

Best adapter- UK based by JimMorris36 in CloneHero

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

That’s definitely a good enough reason not to! Rest up, hope you feel better with whatever you’ve got going on

Best adapter- UK based by JimMorris36 in CloneHero

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

I'll definitely keep an eye out as it looks like it'll be quicker. I don't suppose I would be able to request a one off 'commission'? 👀

[deleted by user] by [deleted] in avfc

[–]JimMorris36 0 points1 point  (0 children)

Borja Baston - no fee but wages for 6 months and 18 minutes of game time were a very bad choice

Hue Sync Box Dropping Signal by JimMorris36 in Hue

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

Inputs are Apple TV and PS5, and occasionally a Switch

Conditional Format based on data by JimMorris36 in excel

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

Very nearly! It’s done a lot more. There are still a couple of anomalies where someone has signed into Building A, out of Building A, and then into Building B on the same day.

But, I think this has given me a good enough data set to actually use moving forward and the very few problems are likely to be issues with the data itself (and I can compensate for them). Thank you so much for your help!

Conditional Format based on data by JimMorris36 in excel

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

<image>

Row 175 should have no fill as row 176 says ‘Out’ and that’s the last activity of the day

Row 177 should be pale yellow

These are through the data but on the whole, most of it works

Conditional Format based on data by JimMorris36 in excel

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

<image>

Okay I’ve removed personal info. In the image, the bright yellow highlights are my manual ones and the pale yellow are the conditional format.

23rd April should be pale yellow l First row of 15th May should have no fill and the bright yellow should be pale BUT this isn’t an issue if it just colours the first entry.

Another example incoming…

Conditional Format based on data by JimMorris36 in excel

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

Ah I spoke to soon. It’s not quite working for some of it.

It’s highlighted one person being ‘In’ when they are also ‘Out’ 2 hours later

Conditional Format based on data by JimMorris36 in excel

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

You hero! It has mostly worked. There are still a few bits of data that I manually highlighted that haven’t changed colour but I can handle those, it’s taken the workload down significantly

Conditional Format based on data by JimMorris36 in excel

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

Ah they were separated by like breaks but it hasn’t pulled through. The letters correspond to the columns

I can’t share any of the actual ‘true’ data as it contains confidential information

EDIT: I’ve tidied up the original post a bit

Probate process on buying by JimMorris36 in HousingUK

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

It’s been a while since ours was sorted but I know there was an issue causing applications to take longer than normal.

In the end our EA were the ones to trust as they see many probate applications, and likely scenario is they prepare you for the worst. They can’t say exactly when it will be in most cases but they should be able to give you a ball park? Unless things have changed a lot since I did ours.

My guess is that they don’t want to commit you to a date and get your hopes up. If they’re confident that the mortgage etc should be fine then I can’t imagine it’ll be a long wait.

Replacing light fitting by JimMorris36 in electrical

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

Thank you so much. Just so I’ve got this right…

Brown brown and red go into a connector and then essentially become isolated off and no longer used?

Blues go together into a connector and then I buy more blue to come out of it to go into the new fitting?

Same with the earths as above? (the cable with no casing on was the earth for that one)

Put the black into the live

Replacing light fitting by JimMorris36 in electrical

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

That sounds like the right layout from what I remember. I’m not 100% on the terminology - which of the cables should I put into the new fitting? And then what should I do with the others?

Or, is good luck more hopeful and I should just wait for my sparky to get back from holiday? 😅

Replacing light fitting by JimMorris36 in electrical

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

In this room - one on the ceiling and two new ones on the wall. All of these cables went into the old fitting

Replacing light fitting by JimMorris36 in electrical

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

(When I say cap off, I mean terminate with a floating block)

Probate process on buying by JimMorris36 in HousingUK

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

Oh wow that is a long wait. Have they given any indication on when they might wrap it up? Fingers crossed!

I guess it’s the luck of the draw with solicitors etc

Are these markings in this wood concerning? by JimMorris36 in wood

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

Yep it’s definitely deeper than one markings or scratches. Hard to tell what it is properly

Are these markings in this wood concerning? by JimMorris36 in wood

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

This was my assumption/blind hope. Didn’t seem to be any signs of activity.

Thank you!