 |
|
Rotation of Parts in Pocket
October 2005
Copyright ©2005 OX3 Corporation
|
Setting Up Your Own Excel Worksheet
Using Microsoft Excel® to determine the acceptable part rotation in any given pocket is easy. To begin, you will need the following data:
- Carrier width.
- Pocket width, length, and depth.
- Part width, length, and depth.
- All numbers must be referenced in millimeters.
When you are instructed to cut and paste, it is important that you utilize the "Edit | Paste | Special | Text" procedure in Excel, rather than the simple Paste routine. Proceed as follows:
Step-by-Step Instructions:
- Open a new Microsft Excel® worksheet.
- In cell A1 record the value of your carrier tape width.
- In cell A2 record the Ao value of your carrier tape, (pocket width).
- In cell A3 record the Bo value of your carrier tape, (pocket length).
- In cell A4 record the Ko value of your carrier tape, (pocket depth).
- In cell A5 record the A value of your part, (device width).
- In cell A6 record the B value of your part, (device length).
- In cell A7 record the K value of your part, (device depth).
- In cell A8 cut and "paste special" the following formula:
- =IF(A1<13,IF(DEGREES(ATAN(A6/A5))-DEGREES(ACOS(A2/SQRT((A5^2)+(A6)^2)))<20,"Okay","STOP!"),IF(DEGREES(ATAN(A6/A5))-DEGREES(ACOS(A2/SQRT((A5^2)+(A6)^2)))<10,"Okay","STOP!"))
- In cell A9 cut and "paste special" the following formula:
- =IF(A1<13,IF(DEGREES(ATAN(A6/A5))-DEGREES(ASIN(A3/SQRT((A5^2)+(A6)^2)))<20,"Okay","STOP!"),IF(DEGREES(ATAN(A6/A5))-DEGREES(ASIN(A3/SQRT((A5^2)+(A6)^2)))<10,"Okay","STOP!"))
- In cell A10 cut and "paste special" the following formula:
- =IF(A1<13,IF(DEGREES(ATAN((A4-A7)/A5))<20,"Okay","STOP!"),IF(DEGREES(ATAN((A4-A7)/A5))<10,"Okay","STOP!"))
The values supplied in cells A8 through A10 will indicate whether or not this tape is adequate for the part you wish to place in it. If the pocket is tight enough, it will read: "Okay," but if the pocket is too sloppy (and will allow the part to rotate), then it will read: "STOP!" Remember to change your carrier width in Cell A1 every time you try a different tape because you want to reject the tape if any of the three angles exceed 20.00 for 8 & 12mm tapes, and 10.00 for 16mm and up carrier tapes. For other questions, please contact us by using our contact sheet.
Here Is An Example:
- In cell A1 record the value of 12 in mm's for your carrier tape width.
- In cell A2 record the Ao value of 6.90 for your carrier tape pocket width.
- In cell A3 record the Bo value of 6.90 for your carrier tape pocket length.
- In cell A4 record the Ko value of 12.70 for your carrier tape pocket depth.
- In cell A5 record the A value of 6.35 for your device width.
- In cell A6 record the B value of 6.35 for your device length.
- In cell A7 record the K value of 11.43 for your device depth.
- In cell A8 the value should read: "Okay"
- In cell A9 the value should read: "Okay"
- In cell A10 the value should read: "Okay"
Now, change cell A1 by entering the value 16 in mm's for your carrier tape width. You should notice that Cell A10 now changes to read: "STOP!" This would indicate that the carrier tape you selected for this device is too deep and will allow component rotation. You may then proceed to try a new carrier tape accordingly. Remember to visit Reelpak.com if you want to sell any carrier tape that you can no longer use. Visit our REELpak® Exchange. Details are available at the site. Feel free to contact us for assistance.
OX3's semiconductor handling services are supported by three web sites: This one at OX3.com for services, Reelpak.com for carrier tapes, and Reel.biz for reels, cover tapes and miscellaneous supplies." |
