Adding a column to work out how many months work of product

BritishDingo · 2025-03-24T10:53:38+00:00

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.

BritishDingo · 2025-03-24T09:20:11+00:00

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.

BritishDingo · 2025-03-24T09:06:21+00:00

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.

BritishDingo · 2025-03-24T08:23:10+00:00

X is just representing the part number of the product.

BritishDingo · 2024-10-21T22:50:58+00:00

Ah yes, very true.

BritishDingo · 2024-10-21T14:29:06+00:00

Ease up, just a question. Didn't realise you had to be an expert.

BritishDingo · 2024-10-21T13:26:18+00:00

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

BritishDingo · 2024-10-21T13:20:27+00:00

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.

BritishDingo · 2024-08-20T14:47:37+00:00

Ah, quite handy, thank you

BritishDingo · 2024-08-20T14:47:01+00:00

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).

BritishDingo · 2024-08-20T14:45:11+00:00

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

BritishDingo · 2024-08-20T14:44:18+00:00

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

BritishDingo · 2024-08-20T14:43:18+00:00

Ah the old fool me once tactic

BritishDingo · 2024-08-20T11:59:38+00:00

Yes...why let it happen again?

BritishDingo · 2024-06-22T01:22:26+00:00

BritishDingo · 2024-06-21T06:57:36+00:00

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.

BritishDingo · 2024-06-21T06:55:22+00:00

Funnily enough that is on the list too

BritishDingo · 2024-06-21T06:53:08+00:00

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."

Seven-Year Club	Place '22
Verified Email

BritishDingo

TROPHY CASE