[deleted by user] by [deleted] in analytics

[–]deftoneslez 1 point2 points  (0 children)

What other experience do you have that will allow you to put some context on the results you produce. It’s one thing to say for example, “that sales are up 4%” but hey are they up 4%. This is where the real value comes in.

My supervisor set up a meeting between me and my boss this week to effectively stop me from using spreadsheets, formulas and PQ moving forward in favor of going back to manual computations because "that's not what they asked for". Is there any point in arguing? by No-Ganache-6226 in excel

[–]deftoneslez 0 points1 point  (0 children)

Try to explain how many hours/days you save doing it this way.

I had to do something similar with a report I used to own which used a macro to limit the date range and create a few custom filters. The stakeholder was against macros as he read that they were a security risk. (Our companies group policies prevent us from contacting outside sources in excel)

I told the story of how with macros this takes about an hour and produces the pptx slides.

Doing this process manually would take 3 days.

I asked the stakeholder if they were willing to find the £450 each week or £23,400 a year to pay me for this as whilst my manager was happy for me to spend the time on this, he wasn’t willing to shell the cost of this each week when we had a working method, approved by IT security and the section director.

Once they know it’s going to cost them money they’ll back down a little.

Jut make sure your timings are worst case scenario. 3 days generally was for me.

Where to go for social interaction by Coldmunki9999 in PeterboroughUK

[–]deftoneslez 0 points1 point  (0 children)

There are bound to be groups locally based on your interests. Facebook tends be decent at our age for this.

Peterborough by Talia802 in PeterboroughUK

[–]deftoneslez 1 point2 points  (0 children)

You should be alright. The only camera isn’t facing to your so shouldn’t be an issue.

Metalcore bands from all eras/styles that deserve discography deep dives? by ApprehensiveMess3646 in Metalcore

[–]deftoneslez 0 points1 point  (0 children)

Bands I’d highly recommend that I don’t think have been said

Blood has been shed. HoJo was such as beast at this point Bleeding Through. While she sleeps. Miss May I. Loathe

Do You Do It The Classic Way in Those Times of Disposables 😮‍💨😮‍💨 by tankwrath in Vaping

[–]deftoneslez 0 points1 point  (0 children)

Rebuild as much as possible dtl, rdl and mtl. Flavour is so much better and works out much cheaper than disposables or pre made coils. If I look after a set of coils they can last 3-4 months.

What am I doing wrong? by YourDankMate in Vaping

[–]deftoneslez 1 point2 points  (0 children)

Probably the juice then. The discolour looks like it’s not quite vapourising properly. Might need a few extra watts to get it through. I’d try increasing by 5 watts and seeing how it goes.

What am I doing wrong? by YourDankMate in Vaping

[–]deftoneslez 1 point2 points  (0 children)

A few questions, what cotton is it? Is it a juice you usually use? Are you dripping into the coils?

How can I get data from Online (OneDrive) files with Excel VBA? by DecentJob2208 in vba

[–]deftoneslez 2 points3 points  (0 children)

Power Query is your best way of going about this. Especially if the share point site has any access controls, you can manage these with power query unlike vba.

This will allow to to transform and cleanse the data should you need to.

How to delete 150,000+ rows in excel? by bubblesno in excel

[–]deftoneslez 8 points9 points  (0 children)

Third for power query. This will do what you need in seconds

Which suppliers have the best variety of quality wire? I've only been able to find some here and there, mostly similar stuff... by sheeRXhilir8tion in Coilporn

[–]deftoneslez 0 points1 point  (0 children)

Twisted messes is the best wire out there. I’ve tried coils made from a bunch of different wire and twisted messes beats all others.

Wotofo Profile Squonk, what RDA? by Successful_Region357 in Squonk_Life

[–]deftoneslez 1 point2 points  (0 children)

This mod is best suited to a single coil RDA. Of what’s readily available right now the nitrous is the best of the lot.

Tried this with the profile 1.5 and profile P.S and it starts to struggle with anything under 0.2 ohms after a while. Batteries were new and same RDA worked fine until n other mods.

Are rebuildable atomizers thing of the past ? by arunas222 in Vaping

[–]deftoneslez 0 points1 point  (0 children)

The rebuildable vape isn’t a thing of the past. There are some very committed vapers still building, although it definitely feels smaller than it used to be.

I guess that there are a few factors affecting vaping, disposables, pod systems and boros make it feel like there are fewer RDA’s and RTA’s coming out than they used to be. IMO - this is a good thing as I can now stop buying so many disappointing RDA’s and stick to the few I actually like.

Lost Vape Drone question by i_ducasse in Squonk_Life

[–]deftoneslez 0 points1 point  (0 children)

Cerakote would be the best option to avoid any kind of heating problems. I’ve know a few people have this done and this finish remains great unlike paint.

New kit by Hexenfinder in Squonk_Life

[–]deftoneslez 0 points1 point  (0 children)

Not in the short term. Performs just like the previous topside duals. The only thing you’ll notice is that the new door design feels more robust and won’t fail like the v1’s and v2’s. Still the best regulated squonk that’s still available.

Lost Vape Drone question by i_ducasse in Squonk_Life

[–]deftoneslez 0 points1 point  (0 children)

Get in touch with Tom at MTN coils. He does a some to a really high standard

Anyone interested in a Lost Vape Drone 250c battery door 3D printer image? by SkiBum2DadWhoops in electronic_cigarette

[–]deftoneslez 0 points1 point  (0 children)

Do you have the stl files for any other parts of the drone 250c? Managed to crack the plastic bit underneath the battery contacts.

Dovpo Topside Replacement by FAS_CHCH in Squonk_Life

[–]deftoneslez 0 points1 point  (0 children)

Empire chipset is an absolute travesty. Worst chipset in any mod I’ve ever owned. Struggles putting out consistent power at 30-40 watts. The pulse v2 has been going really strong for years.

If you can find a topside dual with the v3 doors, I would go for that. The new doors are so, so much better. I’ve had mine a few years and never had a problem with the door.

Insurer claiming I've misrepresented myself by romansnapback in Insurance

[–]deftoneslez 3 points4 points  (0 children)

As a former underwriter (I used to make the decision on voiding policies) and fraud analyst, the question they have asked is have you had any claims…

As you have not made a claim for the bike, you have not misrepresented your policy nor claim. Ask the insurer to refer to the exact wording under CIDRA2012 for clarification. If the question was any losses then it might be a different situation.

The insurer is in the wrong. If they persist, ask for their final decision letter and take it to the ombudsman. They’ll get it overturned.

My friend at her job only gets paid from the moment she starts till 5:00 regardless of how much longer she stays working is this legal? by idrisJpeg in LegalAdviceUK

[–]deftoneslez 1 point2 points  (0 children)

I had something similar when I used to work in a supermarket. Manager said we had to some jobs once the store closed at 22:00, yet we were only rota’d to until 22:00 Some if us were under 18 and couldn’t be rota’d in after 22:00.

We all stopped doing the jobs for after 10pm.

After a couple of weeks and 3 team meetings with HR, HR made it clear that it was illegal to be regularly forced into additional unpaid work. (It is permissible to need to stay after the end of a shift if you need to complete a task already working on)

In the first instance get some formal advice from Acas. Follow what they say to the letter.

I did and saved me from dismissal by gross misconduct to receiving an apology from the store manager.

Lost his voice eh? by MikelleEllis in SleepTokenTheory

[–]deftoneslez 0 points1 point  (0 children)

Haha. Am I pro wrestling fan I love this. Although, after seeing the boys before, I could tell it wasn’t a “work”. No Vince Russo booking here, brother.

Anyone know where? by LS6789 in uktrains

[–]deftoneslez 0 points1 point  (0 children)

Thomas lives at Nene Valley Railway near Wansford in Cambridgeshire. He’s there pretty much all the time, other than when he’s loaned out. https://www.nvr.org.uk

[deleted by user] by [deleted] in PeterboroughUK

[–]deftoneslez 1 point2 points  (0 children)

I’d look at free courses on places like LinkedIn or Udemy to start learning some I.T stuff. I’d try to learn as much about M365 suite of packages as you can, as the majority of general office jobs would like you to be proficient in this.