About the PlotIT Worksheet

The PlotIT Worksheet document is a full-featured worksheet, with many spreadsheet-like capabilities. It can handle data files up to 32700 rows and 254 columns.

Gsguide00000005.gif Immediate access to all data analysis capabilities

Gsguide00000005.gif Transformation, Recode (use of conditional compares, complete Math Library of intrinsic functions)

Gsguide00000005.gif Range Copy, Insert, Delete, Erase, Swap, Move, Compress, Multi-key Sort, Print, Reverse, Transpose, Stack, Unstack, Cleave, Concatenate, Conditional operations

Gsguide00000005.gif Search and Replace (use wildcards, case sensitivity, substrings, within block/entire document)

Gsguide00000005.gif Block Fill (Sequential, Stepwise, Random Distribution)

Gsguide00000005.gif Drag-and-Drop highlighted blocks

Gsguide00000005.gif Multiple range support, with user-selectable colors

Gsguide00000005.gif Import/Export of selected data ranges

Gsguide00000005.gif Goto cell

Gsguide00000005.gif Insert and constrained data range input modes

Gsguide00000005.gif Direct links to graph documents

Gsguide00000005.gif Range Mapper for assigning data ranges to graph elements

Gsguide00000005.gif Undo to correct mistakes or try “what if” scenarios

Gsguide00000005.gif Read native Excel, Lotus 1-2-3, Quattro Pro, dBASE, and ASCII data files

Gsguide00000005.gif 64-bit accuracy

Gsguide00000005.gif Live demonstrations of most commands