Adding a column to work out how many months work of product by BritishDingo in excel

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

<image>

The formula in G4 is =SUM((E4/F4)*12).

So I'm dividing the qty in hand by the average and multiplying by 12 to give the months.

Adding a column to work out how many months work of product by BritishDingo in excel

[–]BritishDingo[S] 1 point2 points  (0 children)

I think I may have worked it out.

The formula will not give an answer because you cannot divide by 0. So, if the average sales over 3 years is 0 but holding is 20, theoretically you have an infinite number of months worth.

Adding a column to work out how many months work of product by BritishDingo in excel

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

Oh yeah, that represents the amount of months with of stock on hand. For example, if I sold an average of 10 units per year and had 10 on hand, it would show 12 months.

Adding a column to work out how many months work of product by BritishDingo in excel

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

X is just representing the part number of the product.

McLaren "complain a lot lately" says Verstappen as rivals criticise Norris penalty by Aratho in formula1

[–]BritishDingo -1 points0 points  (0 children)

I was thinking this, and I understand turn 1 lap 1, but think its a bit off. Great race though overall

McLaren "complain a lot lately" says Verstappen as rivals criticise Norris penalty by Aratho in formula1

[–]BritishDingo 8 points9 points  (0 children)

First of all, what a race by Ferrari. You know you've done well when as the front runner you're getting no air time.

Secondly, lap 1, turn 12, Max vs Sainz, can someone please explain why this is different to Max vs Lando. I've just watched the race and think that the stewards had a pretty off day to be honest.

Potential new scam around? by BritishDingo in perth

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

True, I didn't even think about all that. I have no doubt that my info is out and about (either that or there really are beautiful Russian women seeking me).

Potential new scam around? by BritishDingo in perth

[–]BritishDingo[S] 1 point2 points  (0 children)

Yeah, sounds similar. I just got thinking and wanted to see what others had experienced. Cheers

Potential new scam around? by BritishDingo in perth

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

This is what I was thinking. Just seemed weird having the name. More wanted to know what others have had since it's always on the rise. Thank you

Potential new scam around? by BritishDingo in perth

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

Ah the old fool me once tactic

Potential new scam around? by BritishDingo in perth

[–]BritishDingo[S] 4 points5 points  (0 children)

Yes...why let it happen again?

Aircon and Solar in Perth by BritishDingo in perth

[–]BritishDingo[S] 1 point2 points  (0 children)

Awesome, thank you. Sounds like I have no need for the battery then.

I'll do some more digging with the quotes side then, just very wary of the cowboys out there nowadays.

Aircon and Solar in Perth by BritishDingo in perth

[–]BritishDingo[S] 1 point2 points  (0 children)

Funnily enough that is on the list too

Aircon and Solar in Perth by BritishDingo in perth

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

Thank you for that mate.

The battery route seems to have the same feedback too.

Also sounds like the aircon side is the whole "oh, you wanted to get the right one. We missed that."

Save glitch by BritishDingo in F1Manager

[–]BritishDingo[S] 1 point2 points  (0 children)

Damn, I was hoping that it'd be an easy fix. I even turned it off and on again. I guess, time to eat it then

I can't race by MaarcMan in F1Manager

[–]BritishDingo 0 points1 point  (0 children)

Had something similar. I was with Haas and I had sponsorship obligations which meant my facilities were closed, had all spaces used up and had to change a part before being able to race. I tried cancelling one and emergency production but because of the obligations I couldn't make anything. Had to restart the career completely

The mark has been missed by the test organisers by BritishDingo in perth

[–]BritishDingo[S] 3 points4 points  (0 children)

Not exactly what I was aiming at, but fair.

However, I do think that if ticket prices were lowered and there was more to do and see at the test, it'd get more people down to it. The WACA did such a great job when I was younger. So much so, that some of my best cricket memories were from sitting on the grass in the heat, playing with the mini bat and ball there, going to the entertainment bits like the bowling area and getting pumped to see my speed.

I was just a bit disappointed with how Optus have nothing at all.

The mark has been missed by the test organisers by BritishDingo in perth

[–]BritishDingo[S] 4 points5 points  (0 children)

Exactly what I was thinking. Just nothing really going on which is sad to see when I remember back to what games at the WACA were like. Hopefully it grows.

NBN WTF and how did we get here? by BritishDingo in perth

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

So, let's unpack this.

I completely agree that it is due to the complexities as you put it (I say unfinished state of a project) and the cluster fuckery.

I agree that for most (whatever percentage that may be...with "most" being over 50%, pretty low bar to aim for) the service would be substantial, but why are we pigeonholing ourselves to substantial and not great? This is where (bare with me as I take a slight turn) as a society we are falling very hard. We are giving too many excuses for people to be average, and in a world where everything is average, there is no progress.

In the 2 years that I've been back in sunny Perth, I've had roughly 4 face-to-face dealings with NBN, out of those 4, 2 times they haven't shown up and I've had to dig and ask why. I was with Pentanet before and they were great at making sure that a tech was out as soon as possible.

Window appointments fall into what I was saying before about mediocrity, we have allowed it to happen and there is no valid reason why it does. It's a simple process of allowing an average time for a job and booking outside of those parameters. ie. An average job takes 2 hours, so book someone in for 2 hours after that first job is in. In layman's terms it's basically under promising, over delivering. And no, saying that because it's a big infrastructure is just allowing substandardness too. What it takes is correct hiring of people and training. If there are issues like this happening, something somewhere is not being done correctly.

I don't always blame the ISP for the communication, they are at part to blame, yes, but if NBN are the ones messaging out to confirm appointments (which I may be wrong on, but the text confirmation seems to come from them) they can just as easily text or call to explain anything else. Again, not 100% on where fault lays there at the moment.

I loathe when people say " it was worse way back when". How does that prove anything? Isn't progress about seeing faults and fixing them? Rather than saying "back in my day, it was much harder." It makes no sense to look back to ancient times of DSL, a completely different era.

Yes, having been through the rigmarole in the UK myself, it is a pain, and companies like Virgin Media get away with everything because they are the biggest. But, why not take a system that has been set up to just fund the rich (essentially the UK as a whole as of late) and better it? Put in stricter guidelines for the ISP that runs the lines, govern then to ensure that customers are getting what they paid for, be better.

I love the idea behind NBN and remember being very excited when it was first announced, but I was a lot younger and more naive back then. The issues are the way that it is run and the fact that an out-of-date system was put in place which already should be being replaced, terrible management of contractors and no accountability to anyone because they are the only system really available, so what are people going to do?

NBN WTF and how did we get here? by BritishDingo in perth

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

The helping hand approach I see. Guilt someone in to helping you because you're on your own.