RefinateHome   

The Basics

Examples

Screenshots

One-row-per-part

覧覧覧

Download Refinate

Register

覧覧覧

Revision History

Support

Quick Exercises

HyphenateRanges.XLS

ExpandRanges.XLS

JoinCells.XLS

Assy Versions.XLS

Redundant_Part_Info

Netlist Sorting

Procedures:Compare

 

Company Info

 

  Refinate Screenshots
 
 

 

RefinateToolbar

 
bullet

Click the textbook to bring up the Format display shown in the next figure.

bullet

Click the right arrow to auto-paste either the re-formatted text or the count value into the cell to the right. 

bullet

Click the down arrow to auto-fill the column to the right with re-formatted text or the count value.

bullet

Click the Cnt= button to display the count for the selected cell.

 

Refinate Format Display

 
bullet

Use this display for previewing, for setting the process options, and to apply actions.

bullet

Set Paste_Count or Paste_Format to define what to put in the clipboard so that it's available to be either manually pasted or auto-pasted. Double click the word 'Paste' or the word 'Format' to convert the displayed data from comma delimited to single items which can be pasted one per cell down a column.

bullet

Click Paste > to auto-paste the processed selection into the cell to the right.

bullet

Click Paste V to auto-fill the column to the right with the results (e.g. quantities, or re-formatted text).

bullet

Click Get/Test to gather comma delimited text into the display box -- counting it and searching it for duplicates. In the figure above, the dialog box shows all of the reference designators which were highlighted under "Places" -- sorted in the order of type occurrence -- skips in numbering sequences can be seen -- no duplicates were found.

bullet

Click Subtract to remove items found in the selected cells from those in the display.

bullet

All results displayed can be pasted into Excel or other applications.

bullet

Click QueryM (or Alt+Q when this display box is active, Ctrl+Q when this display box is not active) to bring up the Manual Query dialog for locating items and logging edits.

bullet

Click on the Action List box to choose a new action and then click Apply when you are ready to perform that action on the section of the list you have selected (in the figure above, the One-row-per-part action is visible -- although that would not be applied to the selection shown above ).

bullet

Use the Ignore Ranges mode to sort and check for duplicates in any list.

bullet

Set Sort/ Duplicates to sort and find duplicate comma delimited text when Ignore Ranges is enabled.

bullet

Set GoTo Duplicates to bring to focus on the screen any duplicates found when Ignore Ranges is enabled.

bullet

Use the Count Ranges mode to count and sort indexed items and items represented using hyphenated ranges.

bullet

Set Expand Ranges to output all parts individually without placing them in hyphenated ranges when Count Ranges is enabled.

Get Refinate for Excel 97 or newer.

 
| RefinateHome | The_Basics | Examples | Screenshots | One_row_per_part |
| Register | Support | Revision_History | Download_Refinate |
AnalogDigital Engineering. Revised: 02/19/07.