覧覧覧
覧覧覧
 |
Refinate Hypenated_Ranges.XLS |
|
To create hyphenated reference designator ranges: Place cursor at U29, U30, U31, U32 in the All_RefDes column below. Disable Expand Ranges and choose Paste_Format. Then click Auto_Paste. The new list of refdes in the Scratchpad column will contain the same refdes as the All_RefDes column and now the refdes will be shown as hyphenated ranges. You can copy the Scratchpad column and PasteSpecial the Values back into the original cells in the All_RefDes column. |
|||||
|
This is an example of an Excel worksheet after Auto-Pasting hyphenated ranges. |
|||||
| Total | Scratchpad columns | ||||
| Mftr. # | Places | All RefDes | |||
| BT8360-EPJD | 4 | U29, U30, U31, U32 | U29-U32 | 4 | |
| SAF82532H10-V33A | 1 | U28 | U28 | 1 | |
| DS2172TN | 1 | U4 | U4 | 1 | |
| FSM327 | 1 | X1 | X1 | 1 | |
| VF540A-1 | 1 | U23 | U23 | 1 | |
| DS2430AP | 1 | U18 | U18 | 1 | |
| MC74HC4046AD | 2 | U1, U2 | U1, U2 | 2 | |
| DS1306EN | 1 | U41 | U41 | 1 | |
| LTC1345ISW | 2 | U10, U11 | U10, U11 | 2 | |
| LT1134AISW | 2 | U14, U15 | U14, U15 | 2 | |
| LXT360LE | 4 | U33, U34, U35, U36 | U33-U36 | 4 | |
| TLC7733ID | 1 | U42 | U42 | 1 | |
| DS34C86TM | 2 | U12, U13 | U12, U13 | 2 | |
| DS34C87TM | 3 | U7, U8, U9 | U7-U9 | 3 | |
| 553-0121 | 1 | D5 | D5 | 1 | |
| 553-0122 | 2 | D3, D4 | D3, D4 | 2 | |
| 12062R105K7B | 16 | C38, C39, C40, C41, C42, C43, C44, C45, C46, C47, C48, C49, C50, C51, C52, C53 | C38-C53 | 16 | |
| 1210Z474M500NT | 4 | C34, C35, C36, C37 | C34-C37 | 4 | |
| C0805C629J5GAC | 1 | C54 | C54 | 1 | |
| 0603YC104KAT2A | 119 | C7, C9, C13, C14, C15, C19, C20, C21, C60, C61, C62, C63, C64, C65, C66, C67, C68, C69, C70, C71, C72, C73, C74, C75, C76, C77, C78, C79, C80, C81, C82, C83, C84, C85, C86, C87, C88, C89, C90, C91, C92, C93, C94, C95, C96, C97, C98, C99, C100, C101, C102, C103, C104, C105, C106, C107, C108, C109, C110, C111, C112, C113, C114, C115, C116, C117, C118, C119, C120, C121, C122, C123, C124, C125, C126, C127, C128, C129, C130, C131, C132, C133, C134, C135, C136, C137, C138, C139, C140, C141, C142, C143, C144, C145, C146, C147, C150, C151, C152, C153, C154, C155, C156, C157, C158, C159, C160, C161, C162, C163, C164, C165, C166, C167, C168, C169, C170, C171, C172 | C7, C9, C13-C15, C19-C21, C60-C147, C150-C172 | 119 | |