The spreadsheets

Layout provides a variety of spreadsheets that you can use to view and edit board information. To display most of the spreadsheets, choose the spreadsheet toolbar button, then choose a spreadsheet. Or, choose Database Spreadsheets from the View menu and choose a spreadsheet.

Because the routing-related spreadsheets are used in setting routing strategies, you can display them by choosing the spreadsheet toolbar button, choosing Strategy, then choosing a spreadsheet. Alternatively, from the Options menu, choose Route Strategies, then choose a spreadsheet. From the Options menu, choose Global Spacing to display the Route Spacing spreadsheet.

Because the placement-related spreadsheet is used to set autoplacement strategy, you can display it by choosing the spreadsheet toolbar button, choosing Strategy, then choosing Place Pass. Alternatively, from the Options menu, choose Placement Strategy.

From the Options menu, choose Colors to display the Color spreadsheet, or choose Post Process Settings to display the Post Process spreadsheet.

Route Sweep

Use the Route Sweep spreadsheet to view the settings (routing window size, overlap percent, and sweep direction) for the six main routing sweeps Layout uses to try to route a board to 100%.

Route Pass

Use the Route Pass spreadsheet to view the routing strategies (via cost, retry cost, route limit, and attempts) and routing algorithms (heuristics, maze, Auto DFM, fanout, via reduce, and Auto CDE) Layout uses in its routing passes.

Route Layer

Use the Route Layer spreadsheet to view whether a layer is enabled for routing, the primary direction of a layer, its layer cost (a low cost for a layer indicates that the layer is preferred for routing), and its between pins cost (the cost of routing between pins on 0.100 (or less) centers).

Route Spacing

Use the Route Spacing spreadsheet to view the settings for the various spacing criteria (track to track, track to via, track to pad, via to via, via to pad, and pad to pad) Layout uses when routing and when checking for DRC violations.

Statistics

Use the Statistics spreadsheet to view general information about the board, including placement and routing data. The Enabled column reports the components and nets that are active. The Total column reports the enabled components and nets plus any disabled components and nets.

Layers

Use the Layers spreadsheet to view, add, disable, or modify the board layers.

Padstacks

Use the Padstacks spreadsheet to view and edit the location, type, and size of pads. Each padstack has a name, slightly offset from the layer definitions, and a size defined for each layer. Plane layer padstack sizes define clearance.

Footprints

Use the Footprints spreadsheet to view, access, and edit the library of physical parts used in the board.

Packages

Use the Packages spreadsheet to view and edit the logical gate and pin information for gate and pin swapping.

Components

Use the Components spreadsheet to view and edit the component footprint, package name, location, rotation, routing status, and group.