Calculating Parts Per 22" Reel Reel Size: (OD: 22" ID: 4") View in PDF format. November 2010 Copyright ©2010 OX3 Corporation For 7" click here. For 13" Standard click here. For 13" Wide click here. For custom sizes click here. Setting Up Your Own Excel Worksheet Using Microsoft Excel® to determine parts per 22" 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(((237.14/($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 22-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(((237.14/($A$1+0.31))-1)*(1000/$A$2),-1) The value supplied in cell A3 should be 2,780. In this case after rounding down to the nearest 250, we would suggest 2,500 parts per reel. OX3's semiconductor handling services are supported by four web sites at OX3.com for services, Reelpak.com for carrier tapes, Reel.biz for reels, and Traymania for JEDEC Trays.

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,