Detailed DataFerrett Features

Features Feature Code
code key
Feature - Introduction Tab IT1
IT Introduction Tab
File Open by Icon MN1
MN Menu
File Open from Menu MN2
ST Step 1 Tab



BV Browse Variables
Relogin as Embargo User MN3
S2T Step 2 Tab
Change Password MN4
RC Recode



SS Spreadsheet
Ferret Tabulation Examples IT2
GF Graphframe
Ferret Help MN5
MF Mapframe
Help Request MN6
CB CodeBook
Know Bugs MN7
GCB GeoCodeBook
Release Notes MN8


Users Guide MN9


About Ferrett MN10







Feature Step 1 Tab ST1


Search variable label ST2


Search variable Name ST3


Search Variable Topics ST4


Search Dataset Name ST5


Search DataSet Topic ST6







Feature Search All DataSets ST13


Double click to open (a dataset) File Open by ( ACS 3-yr 2006-2008)--View Variables ST14


Select All Topic--Search ST7


Sort by Topic ST8


Sort by Name ST9


Sort by Availability ST10


Sort by Variable Label ST11







Drag and move columns to the left or right ST12







Select first 5 variables (from Variable Label Sort)--Browse Select Highlighted Variables BV1


Select - Select All Variables--OK--Add to DataBasket BV2







Feature Go to Step 2 S2T1







Select Feature Download--Display 50 Variables S2T2


Select Feature Make A Table S2T3







Drag variable to rows SS1


Drag variable to column 2 SS2


Select Feature Go Get Data SS3







Select Feature Merge DataSets S2T4







Select Feature Save Selected Variable(s) CodeBook S2T5







Select Feature Create Multi-Variable Data Step S2T6


aggregate data multi-variable recode S2T7


View /change Advanced SQL statement S2T8







Select Feature File Save Icon MN11







Select Feature File Save As MN12







Select Feature Empty DataBasket S2T6







Select Feature File Open Saved DataBasket MN13







Highlight an age variable to recode RC1


Select Feature Recode -- Age variable to 5 subgroups (change max age to 18) RC2


Recode Age variable to 10 subgroups of remaining values RC3


Select Select Feature OK RC4


Select Feature Make A Table S2T7


Drag Age Recode onto spreadsheet SS4


Drag variable onto spreadsheet SS5


Select Feature Go Get Data SS6


Select Select Feature Percent column button SS7


Select Select Feature Percent Row button SS8


Select Select Feature Percent Cell button SS9







File Open .ftf SS10


File Save As comma delimited SS11


File Save As tab delimited SS12


File Save As html SS13


Use Get Data from File menu SS14


Edit Table Properties SS15


Generate PDF SS16


File Save As ftf SS68







perform undo dropping SS17


select and cut SS18


select and copy SS19


paste SS20


perform hide column or row SS21


perform unhide column or row SS22







Clear entire spreadsheet SS23


Clear all rows from spreadsheet SS24


Clear all columns from spreadsheet SS25


Clear all pivots from spreadsheet SS26







deleted highlighted/selected cell / column or row SS27







Insert Column SS28


Insert Row SS29







Sort ascending SS30


Sort descending SS31


Unsort all SS32







create two column table spanner SS33


create three column table spanner SS34







Change Font SS35


Change Font type SS36


Change Font size SS37


Change Font Style SS38







Change decimal SS39







Hide/Show Toolbar SS40


Hide / Show Formula Bar SS41







Hide/Show Spreadsheet Only SS42


Hide/Show animation SS43


Show Hidden/rows/columns SS44







Use (check) Automatic Totals SS45


Use (check) Automatic Cross variable Explosion SS46


Create Thematic Map drop-down menu SS47


List Mode SS48


Create Average across time SS49


Create Cumulative SS50


Create a Percent of Numbers SS51


Create a Percent of first data column SS52


Create a Percent of first data row SS53


Create a Percent of first data cell SS54


Specify Sequence SS55


Select Weighting SS56


Select Unweighted SS57


Select Help Contents SS58


Create Pivot SS59


Change Pivot data SS60


Create column formula SS61


Create row forumla SS62


Clear spreadsheet button SS63


create sum calculation (formula) SS64


create If conditions formula SS65


create Rank formula SS66


create Comp formula SS67


Viewing underlying records SS73


Clearing one dimension SS69


Changing universe from spreadsheet SS70


creating a table that averages across time SS71


nesting vs. not nesting variables SS72







Create graph GF1


Saved a jpeg GF2


Saved a .graph GF3


Changed graph size GF4


Changed graph labels GF5


Changed to a Horizontal Stacked Bar Graph GF6


Changed to a Line Graph GF7


Changed to a Smooth Curve Graph GF8


Changed to a Scatter Graph GF9


Changed to a Pyramid Graph GF10


Changed to a Pyramid Percent Graph GF11


Changed to a Pie Graph GF12


Changed to an Area Graph GF13


Changed to a Dynamic Area Graph GF14


Changed to a Vertical Bar Graph GF15


Changed to a Vertical Stacked Bar Graph GF16


Changed to a Horizontal Bar Graph GF17


Reversed Graph Axis GF18


Opened a .graph GF19


Edit legend GF20


Create a time series graph GF21







Create a thematic Map MF1


Create a point data Map MF2