Forum Replies Created

Viewing 40 posts - 81 through 120 (of 1,130 total)
  • Fresh Goods Friday 722: The Autumn’s Done Come Edition
  • rogermoore
    Full Member

    I know nothing at all about boxing, so my pinstickers bet is AJ to knock him out within 3. Everyone loves a trilogy payday! 😉
    RM.

    rogermoore
    Full Member
    rogermoore
    Full Member

    I have one of these:

    Which plugs neatly into my dock via. USB-c and works well. There is a newer model but it’s £100 more.
    RM.

    rogermoore
    Full Member

    Emails from external consultants, asking for information they need from you to report back to your own management.
    RM.

    rogermoore
    Full Member

    If money is no object, stay in posh gaffs where you get a hotel dressing gown. Perfect for an hour in the bar! 🤣
    RM.

    rogermoore
    Full Member

    bye election

    Deserves credit.
    RM.

    rogermoore
    Full Member

    MPN? If so, my old man was diagnosed with this just before covid times. He’s been treated with chemo pills and has been ok (bar other existing health issues) since.

    All the best.

    RM.

    rogermoore
    Full Member

    Been through Manchester twice, Dublin and Madrid in the last 10 days. No major issues at Manchester, especially security – breezed through T3 both times. Bigger queues at the bars. Madrid was ok – big queue for passport checks, the EU folk got a fast track queue which made me chuckle. Covid checks were beyond pointless. Dublin Airport was horrible. 1.5 hr queue to get into the security check area which was probably the most half arsed attempt at check I’ve ever seen. Still, meant the terminal was quiet so got a last couple of Guinness in before the flight.
    In a nutshell, unless you really like a good queue – wouldn’t recommend.
    RM.

    rogermoore
    Full Member
    rogermoore
    Full Member

    My own anecdotal research from munching many pizzas from mates who have either one of these is there can’t be much in it! 🙂🍕
    RM.

    rogermoore
    Full Member

    Ta! Been ages since I heard Hoddle commentating – forgot how wonderfully he comes out with such obvious shit with such a natural flow. 😂
    RM.

    rogermoore
    Full Member

    It is! Is away goals still a thing, or do they need another?
    RM.

    rogermoore
    Full Member

    Seems the FA are, predictably, doubling down on their stupidity.
    https://www.bbc.co.uk/sport/football/60873713
    “enhance their journeys” **** morons.
    RM.

    rogermoore
    Full Member

    Worst that could happen is you not get the job, which could happen anyway – so why not. A strong, spicy Bloody Mary gets my vote.
    RM.
    <caveat> not if this for a bus driving job which includes a practical test!!

    rogermoore
    Full Member

    What ^ said. Worth the drive.
    RM.

    rogermoore
    Full Member

    Used it for a few years. Can be hit & miss with auction – bit more miss than hit these days.

    I usually upgrade my evening homeward leg and enjoy a something to eat & few beers. Not sure I could sup £40 worth of coffee! 🤣

    Sometimes (not always) the auction ends and you can still buy a fixed price upgrade but I think it depends on availability.

    RM.

    rogermoore
    Full Member

    Assuming your words are separated by spaces, you can add a custom column in PQ as follows: List.Count(Text.SplitAny([Column1],” “))
    Then filter that column to be greater than 2.
    RM.

    rogermoore
    Full Member

    https://www.theguardian.com/football/2022/feb/21/a-day-with-leeds-and-manchester-united-fans-police

    Article about yesterday’s game. I know it’s not a n individual club, league or even country specific problem but this habit of chucking objects at players needs to stop before something terrible occurs.
    RM.

    rogermoore
    Full Member

    @Cougar will drop you a message tomorrow.
    RM.

    rogermoore
    Full Member

    How come?

    Dunno mate, think that must have been the hack? Uber recognised my mobile number and email when trying to get in to reset my password but the 2FA codes were being sent elsewhere – could tell as the “We’ve sent a code to xxxxxxxx77” wasn’t my number. The backup codes you can screenshot would’ve got round this.
    RM.

    rogermoore
    Full Member

    Yeah, had that setup, but didn’t seem to help and the made it harder to get back in! Trying to explain to their email help line that someone was nicking their dosh was hard work but by late afternoon they figured it out.
    RM.

    rogermoore
    Full Member

    Would have loved some OT drama there! Well done Rams.
    RM.

    rogermoore
    Full Member

    Heart wants Bengals. Head says Rams. Can’t wait for half time show!
    RM.

    rogermoore
    Full Member

    Totally agree, cracking game! You have a great prospect in Ramsey, hope he keeps getting better. Really love to see club grown talent come good!
    RM.

    rogermoore
    Full Member

    It’ll display nicely in a table, but matrix and line graph view will only display summarised numbers, i.e.average of 7 Day Sum, count of 7 Day Sum… Is that just a limitation of PowerBI I’ll have to live with?

    Are you wanting to display the conditiondt as the axis and display each of your results as one value and the Last 7 Day figure as another, but showing one result for the Last 7 days per day?
    RM.

    rogermoore
    Full Member

    I got it to work, not sure it’s 100% correct in the most efficient way of doing this.

    You’ll need a date table (i.e. singular dates) to use the DATEADD function, to do this add a new table using this DAX: DateTable = CALENDAR(min(calctable[collectiondt]),max(calctable[collectiondt]))

    I then created a duplicate of the [collecitondt] column, but without time: LINKDATE = DATE(calctable[collectiondt].[Year],calctable[collectiondt].[MonthNo],calctable[collectiondt].[Day]) and created a relationship to the Date column in the date table.

    I then added a column to the DateTable using this: Last 7 Day Sum = Last 7 Day Sum = CALCULATE(sum(calctable[result]),DATESBETWEEN(DateTable[Date],DATEADD(DateTable[Date],-7,DAY),DateTable[Date])).

    In your display table you’ll need to use the Date from DateTable, but you can add collectiondt in there too, but you’ll see duplicated numbers of the last 7 day sum per time entry.

    Hope this helps.

    RM.

    rogermoore
    Full Member

    No errant blanks or hidden rows?
    RM.

    rogermoore
    Full Member

    As per your request! 😄
    =IF(ISBLANK(K20),”No, or nothing at all”,IF(K20<L20,”YES”,”NO”))
    RM.

    rogermoore
    Full Member

    Ranieri sacked. Big Sam time for Watford?
    RM.

    rogermoore
    Full Member

    2.vaccine passports (I’ve never done one, what events are big enough to require them? Dont think I’ve heard any of my friends mention having them either)

    Been to 2 football games where they were needed, had staff outside the ground (away from turnstiles) where you show your NHS pass and get a wristband to say you had been checked. You then flash the band when going through the turnstile. Both times a 2 min job and completely hassle free IME.
    RM.

    rogermoore
    Full Member

    Long Fingered Night Pigeon. Seldom seen in the day – good spot.
    RM.

    rogermoore
    Full Member

    I suspect fear of further court action.

    Excellent.
    RM.

    rogermoore
    Full Member

    Shaun
    You’re being a bit sheepish there – can you elaborate?

    Underrated.
    RM.

    rogermoore
    Full Member

    Indeed, when the ‘extra ref’ principle is applied inconsistently it really frustrates. In either case the way the on field ref saw things, for me, could have been 2 reds or 2 yellows – whatever he decides as he sees it. The whole game was a fairly physical affair with both teams going at it, the on field ref didn’t miss either challenge. Why the VAR ref felt that Robertson’s needed a further look and Kane’s didn’t just leads to an extra layer of inconsistency.
    RM.

    rogermoore
    Full Member

    2 mins I’ll be with ya.
    RM.

    rogermoore
    Full Member

    Whoop!!!!
    RM.

    rogermoore
    Full Member

    Booster done! Only booked it last Thursday and got done at a local pharmacy rather than the big centre this time. Got given a 3rd dose of Moderna.
    RM.

    rogermoore
    Full Member

    Are you sure? On the front page I’m me, but every thread I go in I’m the person who started the thread!
    RM.

    rogermoore
    Full Member

    Do not have the Recons but have Renegade wide fit. Got them a few years back, after struggling for a year or two with a pair of Meindls which were a touch too thin and never gave. Been great, no rubs, leaks and super comfy. Showing no signs of age really and they are regularly used. I would recommend Lowa based on my few years of use – wide fit has been great for me.
    RM.
    Edit: Had an action man has a kid, if military credentials are required!

    rogermoore
    Full Member

    Paper round from 11-13 and Milk round 13-16. Look back at it fondly now, but remember hating the early mornings in pitch black freezing weather, getting chased by crazy dogs on rough estates and the last Milkman was a raving loony – once turned up so hammered from the previous night a 15 year old had to drive the van. Only in the 90s! Most Saturday’s pay day was blown on fags and a bottle of 20/20. Misspent!
    RM.

Viewing 40 posts - 81 through 120 (of 1,130 total)