**Instructions:** This worksheet calculates Pin-in-Paste stencil metrics if Preforms are used. Cells D25-29 are PWB and component inputs and cell I33 is the stencil thickness. Cells D32-33 and I37 can be used if rectangular pins or stencil apertures are used. Cells D37-40 are the Preform inputs. Cells I34 and I35 are calculations for the dimensions of the stencil's apertures required for the needed solder paste volume. Cells I36 and I37 are for rectangular aperatures and cells I38-I42 are for dogbone apertures. Blue cells are inputs, gray cells are calculations..

Initial work by Gervascio etal^{i} refined by McLenaghan^{ii} was performed to estimate the volume of the fillet in the pin-in-paste process. The assumption was made that the cross section of the fillet could be described by the radius of a circle as shown in Figure 1.

Figure 1. The cross section of a fillet as defined by a circle.

Simple geometry will show that the area of one side of the cross section of the fillet is equal to the 0.215r^{2}, let's call this area A. Pappus of Alexandria circa 300 b.c., developed the concept of a volume of revolution. His work was refined in the 1500s by the Dutchment Guldin. What they showed was that if one takes an areal cross section such as A, it is possible to calculate the volume of the body by mathematically revolving it around the central axis. If one does this by using calculus, it can be shown that the resulting volume is equal to:

V = 2^{Π} A x_{c}

Where x_{c} is called the centroid of that cross sectional area. For our fillet, calculus will show that:

x_{c} = 0.2234r + a, hence the volume of one fillet is: V = 2^{Π}(0.215r^{2})(0.2234r + a)

ii McLenaghan, A. J., private communication