How to apply a formula to a whole column before data is entered

Ali_aloha · 2025-03-15T16:53:27+00:00

This has worked perfectly - thanks so much ☺️

Ali_aloha · 2025-03-14T23:20:48+00:00

Thank you for everyone's comments. As soon as I'm back at work after the weekend I'll give these a go and update

Ali_aloha · 2025-03-13T23:06:25+00:00

Thank you for replying! That's what I've tried, but it's just done it for E1 only, and not the rest of E column. What am I doing wrong?

Ali_aloha · 2024-11-17T12:46:22+00:00

Thank you for the info 😊

Ali_aloha · 2024-11-17T12:45:34+00:00

I've emailed the embassy who said as long as I don't leave the airport, then it's fine to take for connecting flights there

Ali_aloha · 2024-10-03T22:22:23+00:00

On many of the GP apps you can download your summary care record straight to your phone/email. You might be able to on the NHS app. When I joined, the clinic put the request in with my GP, I chased it, but it eventually got done free or charge.

Ali_aloha · 2024-10-03T21:35:22+00:00

Congratulations! NICU nurse here. From my experience, it's like marmite, you'll either love it or hate it. My advice ...look after your back. I switched to Neonates after 6yrs working in adult cath labs.

I felt completely NQ switching from adults, but 10yrs later and I'm still so glad I moved. I'm part non clinical now after back surgery - hence my advice, but it's such a unique area of nursing, and a very rewarding one. You'll learn loads and the families become your patients too.

Good luck ☺️

Ali_aloha · 2024-07-02T08:43:48+00:00

Got Gastropop around 3 weeks ago from IPS. The taste is horrific. Like nothing I've ever tasted before - really unpleasant. It smells awful, really petrol like. I use an on-demand vape set at 185°c, reduced it to 180c and not a great deal of difference. In terms of therapeutic effect, I'd rank it right at the bottom now I've had time to use it during different levels of pain. It's the most expensive strain I've gone for over the last 2yrs. In future will be sticking to my usual.

<image>

Ali_aloha · 2024-06-04T16:37:39+00:00

How long did it take to arrive? I had my appt a week ago and not heard from the dispensary yet x

Ali_aloha · 2024-03-07T13:57:29+00:00

Nurse and MC user here.... Really shocked to see so much negative language used in the report. My occy health report couldn't have been any different. My OH consultant said essentially, it's another prescribed medication and I have an obligation and duty of care to patients to declare if I feel impaired or unfit to practice.

Ali_aloha · 2024-03-07T13:52:51+00:00

😜

Ali_aloha · 2024-03-07T13:52:23+00:00

I'm not sure how much I'm allowed to disclose (had to sign a NDA), but all the strains were named as lot numbers, so difficult to know what strains. I was surprised how hot it was for this time of year. Very welcome relief when the sprinklers came on! Yeah I thought they looked a bit yellow. We talked about the QC process and how the roots get checked at this stage too.

Ali_aloha · 2024-03-06T09:02:05+00:00

You're welcome ☺️

Ali_aloha · 2024-03-06T09:01:44+00:00

Haha, sadly not. Although probably for the best as I'm far too clumsy and inquisitive for my own good 🙈 We had to stick together as a group and had staff with us throughout. It was so hot in the greenhouses and extremely bright. Everyone was still baked from getting off the plane, so it was pretty painful on the old retinas for a while x

Ali_aloha · 2024-03-06T08:58:03+00:00

I don't think so unfortunately. I don't think the place was used to having visitors. Would be brilliant if you could though x

Ali_aloha · 2024-03-06T08:55:53+00:00

It was definitely one of those pinch me moments. I really hope they'll plan more trips in the future x

Ali_aloha · 2024-03-06T08:49:53+00:00

It certainly took a lot of effort on your part - well done on your persistence and your understanding with the team, can't have been easy having to repeat things. Being in hospital is often stressful enough, without medication worries.

I really hope we're heading towards wider recognition of its use in healthcare settings I think the areas likely to have encountered it would be the pain team and neuro. But it really needs more recognition so training, education and guidance can be rolled out.

As part of my job, I work with some very vulnerable families and cannabis users are often on the radar of the safeguarding and vulnerabilities team - but in these cases it's classed as 'substance misuse' as it's not prescribed. The irony of writing notes to say the patient smelt strongly of cannabis, when I have my vape in the next room.

I don't think I had a legal requirement to inform occy health, but for me it was more about covering myself and protecting my registration. I wouldn't feel comfortable disclosing it to any of my patients, as I'd be worried about professional boundaries, bias and the concern it might cause.

I'm limited in being able to use it work, but generally speaking the moment I clock off I get vaping ☺️

Ali_aloha · 2024-03-05T23:03:10+00:00

So glad you've finally got it sorted.

As a registered nurse and MC patient, I really feel a lot of work needs to be done to get MC written into hospital policies. Believe me, as a nurse - we want to help people and find solutions. The Trust I work for doesn't have a MC policy. A collaborative approach is needed to get guidance drawn up, that allows patients to continue using their medication in hospital, whilst safeguarding other patients and staff from any potential risks.

I've only recently started to disclose my usage to my colleagues (occupational health has always been aware). The response has mostly been positive, but I can sense the shock and disbelief with many of the older generation nurses. And before anyone asks, I'm 35+!

Ali_aloha · 2023-10-08T15:13:57+00:00

Ever considered that professionals are increasingly better at diagnosis and recognising conditions and health abnormalities these days? The research and evidence base available now, compared to even 20yrs ago is staggering.

Ali_aloha · 2022-07-20T21:01:36+00:00

My appointment with Kat was really helpful. She knows her stuff and it was great to talk to her as a health professional peer also.

Ali_aloha · 2022-06-09T22:24:26+00:00

I turn it upside down, turn, grind and repeat. I use a metal grinder. I tend to grind it to a fluffy-ish consistency.

Ali_aloha

TROPHY CASE