Search results for:

He said he was using Waze, but also said he was headed from his parent's house to his girlfriend's house 🤔

I use sat nav for a route I've driven/cycled thousands of times. There's always roads closed, delays, etc

Didn’t get details, but the crossing is a death trap (literally, I think an old guy was killed by a bus there recently) and should be light controlled. So who do I get in touch with about that?

The relevant local councillor is probably your best bet.

It's been going on along that stretch of the A10 for a good few years. Not sure why there, seems to be a combination of the big retail centre car parks and the dual carriageway (although it's a 30mph limit and loads of speed cameras now).

When I first joined them I was meant to get some £100 referral bonus. Never happened despite multiple calls/emails with them where they assured me it was sorted.

Now my contract has expired and the price increased. Called them and agreed a new contract at a reduced price (nothing complicated, just the price on the website).

Again, multiple calls and emails where they have no idea what is going on, assure me it's sorted and then next call starts from square one again.

I remember the manual for our aeg was explicit that it shouldn't be siliconed.

I'd definitely get one where every zone can be full power at once.

That's probably because people used to have a weird hard-on for that method Vs vlookup as it was slightly more efficient in certain edge cases.

Just use xlookup.

Fucking Community Fibre.

Their product may be good value but their customer support is so incompetent that it makes me think maybe Virgin wasn't all that bad.

Every query I've raised with them, phone or email, just disappears into a black hole. They're completely incompetent at best, deliberately screwing customers over at worst.

Any suggestions for smallish (20l maybe) clamshell backpacks without a laptop sleeve?

Something to use for a weekend away where it's easy to get clothes in/out.

You've got errors in your source data. You need to sort that out before progressing because you'll just keep carrying the errors through.

Click on the 1,790 errors, work out what is causing the errors, change types or fix some other way on the source, refresh and see if it imports with no errors. If you are still getting errors then repeat. Getting rid of them all can take a few goes. Then do the same for the other source. Get it clean before doing anything else.

Likewise, I could be paranoid but I think they've reduced the number or processors(?) or something on my VM. My ram is the same but I'm routinely maxing out my machine using xls.

I made a file a while back to benchmark Excel. Runs a macro to generate some random numbers and do some lookups, sumif, etc a number of times and times it.

5 iterations takes about 45 seconds on my work laptop (which is a couple of years old)

Looking at the cost of a double skin garden wall compared to single. About 7m long and 4' high. Difference in the quotes is about £1,600.

Seems quite a bit to me but must admit I don't have much idea whether or not it is. Any thoughts?

Text.From should fix it. Unless you've got the result column formatted as a number in which case you'll get an error.

I'm pretty sure the version of Excel with a Power Query tab is old. It got brought into Data tab a year or two ago.

Helper columns are the way to go in Power Query as you can strip them out later but things can still depend on them. Also (and this can be a frustating biggie if you're not aware) formulas are case sensitive, that one made me swear a lot originally.

There's a nice list of functions here under Functions if you weren't aware
https://learn.microsoft.com/en-us/powerquery-m/

If you follow Training Ground Guru on twitter loads of these come up. Man City seems at the forefront of it all
https://x.com/ground_guru

I looked at those too and pondered how waterproof they would be for using outside. My guess was probably not waterproof enough.

As others have said, work out what you can afford (taking into account a good estimate of work needed) and offer that.

Don't worry about getting an amazing deal, if you're going to live there for a few years then over/underpaying by a few grand is pretty irrelevant compared to a bit of extra rent or just owning your own place. Pay what you're happy with.

But if you can't afford to get the work done after buying you can't afford it. I spent a fair chunk of time convincing my estate agent that my budget was my budget and if they wanted to make the sale then that was all the money that was there.

Don't stretch yourself, you'll regret it. But don't give up due to a few grand if it is realistic. Work out what you can afford, maybe knock a small contingency off, and tell the agent they need to make the deal at that or you're done.

Are you trying to concatenate a number and a text column in PQ?

What's recommended for cleaning windscreens? Mine always seem a bit grubby even after cleaning and wiping down the wipers and it is a bit more obvious now it's dark.

It's pretty new so I doubt there would be much second hand apart from happening on it by coincidence. Plenty of stuff at the cheaper end of the market though
https://www.freely.co.uk/products/televisions
Probably some of those would be available as refurbs on ebay or similar

It might also be worth looking at this
https://www.freely.co.uk/
Freeview through broadband rather than TV.

My MIL has a couple of aerial sockets in the living room. One doesn't get anything, the other gets HD Freeview so assume parts of it must be relatively recent.

It won't be anything she did herself so must be some kind of communal thing.

I have found some 1st class Queen (the band, not the person) stamps so I reckon a couple of those should see me right.

But it's all legal and above board. If they don't want presidential pardons then they should get rid of them, not wring their hands when they are used.

Be aware that quotes from tradesmen can take fucking ages (if they even get round to it at all). I've had people who have come round to quote and then just never reply to you.

Yep, the same experience. The cheap ones are harder to fly, particularly if there's any type of wind. Holystone ones seem to have better reviews at the cheaper end of the market but I haven't tried one.

Also bear in mind you don't get that much flying time per battery and they take a while to charge.

Cheers all, looks like paying to post online could be the easiest (if I can get my printer to work of course)