Calculating Parts Per 13" Reel Reel Size: (OD: 13" ID: 4") View in PDF format. August 2005 Copyright ©2005 OX3 Corporation For 7" GoTo.   For 13" Wide GoTo. Setting Up Your Own Excel Worksheet Using Microsoft Excel® to determine parts per 13" take-up reel is easy. To begin, you will need the pocket depth and pitch of your carrier tape. All numbers are referenced in millimeters. Proceed as follows: Step-by-Step Instructions: Open a new Microsft Excel® worksheet. In cell A1 record the value of your carrier tape pocket depth in mm's. In cell A2 record the value of your carrier tape pitch in mm's. In cell A3 cut and paste the following formula: =ROUNDDOWN(((77.53/($A$1+0.31))-1)*(1000/$A$2),-1) The value supplied in cell A3 will represent the maximum number of parts that can fit on one 13-inch take-up reel that has a 4-inch center core. Keep in mind that this number is the practical maximum. In theory more pockets may be able to fit. It is often best to round down to the nearest 250, 500, or 1000-mark for an optimal selling count. This formula already allows for leader and trailer in setting the final reel count. For other reel sizes, please contact us to request the proper formula by using our contact sheet. Here Is An Example: In cell A1 record 4.90 as the value of your carrier tape pocket depth in mm's. In cell A2 record 16.00 as the value of your carrier tape pitch in mm's. In cell A3 cut and paste the following formula: =ROUNDDOWN(((77.53/($A$1+0.31))-1)*(1000/$A$2),-1) The value supplied in cell A3 should be 860. In this case after rounding down to the nearest 250, we would suggest 750 parts per reel. OX3's semiconductor handling services are supported by three web sites at OX3.com for services, Reelpak.com for carrier tapes, and Reel.biz for reels, cover tapes and miscellaneous supplies."

Go  Back to Technical Guides.

Axial, BQFP, CBGA, CCGA, CERDIP, CERQUAD, Chip Resistors, Chip Capacitors, CLCC, Connectors, CPGA, CQFP, Crystal, CSOJ, DFN, DIP, DPak, DQFN, DSBGA, FBGA, FET, Flatpack, GDIP, Heatsink, HSSOP, KDIP, LDCC, LGA, LLCC, LSOJ, LTCC, MSOP, Oscillator, PBGA, PDIP, PFP, PGA, PKDIP, PLCC, PQFP, QCC, QFN, QVSOP, Radial, SIP, SKPQ, SKSJ, SMCG, SMC, SOD, SOIC, SOJ, SOT, SQFN, SSOP, TBGA, TFSON, TQFN, Transistor, TSOJ, TSOP1, TSOP2, TSSOP, USON, Zip,