I have had a look on the forums and couldn't find this question answered in a way i understood. I apologise in advance it is a repeat question.

At work we use reels of wine labels in a production environment. Every reel has a different starting quantity (fresh out of the box) and different labels have different width,height...

The problem we have is estimating the quantity of labels left on each reel once production has used some of them.

I understand the VERY BASICS of what i need to do but have been unable to find a formula that works this far.

SO as i understand it i need to know:

diameter of the core

diameter of the reel

width of the label

width of the space between each label

thickness of the label and backing paper combined

Any help would be greatly appreciated, my math skills are limited so simplicity would be great.

and if the was a formula available that could be used in execl it would make my life a whole lot easier.

Many Thanks