how about this for resistor & capactors with 4mm pitch, all measurements in millimeters. cell A1 "Input inside diameter" answer in cell B1 cell A2 "Input outside diameter"answer in cell B2 cell A3 "Input layer width,(from inner to outside layer) (not used in this example)" cell A4 "Input number of layers" answer in cell B4 cell C1 =PI()*B1 (gives length in first layer) cell C2 =PI()*B2 (gives lenght of last layer) cell D1 =(PI()*B1)/4 (gives components of inside layer) cell D2 =(PI()*B2)/4 (gives components of outside layer)
minus start 48 parts minus end 95 parts
In total cell =(((PI()*B1)/4 )*B4)+((((PI()*B2/4)-(PI()*B1/4))/2)*B4-48-95
sorry I did not finish it fully with the minus start & finsh.
I got very close to 5000 on a full reel of 5000 resistors, then I counted it by 300mm lengths and got 5006, but I could of missed one of two or ...
reply »