Spreadsheet Professional - Building Tools

Spreadsheet Professional contains five tools to assist you in the building of your spreadsheet models.  Each is described below.

Set up sheet in standard format

This tool enables you to create spreadsheet models in the best practice standard format.  It has been shown that spreadsheets built in this format contain less errors and are easier to understand.

 Build Bar

The build bar is designed to reduce the number of key strokes required to enter a formula, format the formula and copy it across the spreadsheet. The build bar enables you to enter all these details and then simply apply the formula the number of times required - no more dragging and dropping.  As the build bar remembers the last entered details, it is possible to create, format, choose colour, select borders and copy a cell with a single key stroke, thereby encouraging proper formatting and colour coding of cells and saving significant time.

Furthermore, if the automatic colouring option is selected, Spreadsheet Professional will automatically analyse the contents of the cell and select a colour for the cell depending on whether the cell contains a formula or an input.

Translation bar

The translation bar provides a translation of the current formula into English at the bottom of the screen.  This enables you to quickly verify the accuracy of the formulas that you have entered.

We have found that the translation bar is normally best anchored to the bottom of the spreadsheet, and provides a quick and easy way to ensure that the formulas entered make sense.  By providing a visual check in English of the meaning of the formula, it enables you to quickly identify any errors that may have occurred when inputting the formula.

Spreadsheet Painter

The spreadsheet painter colour codes each of the cells of the spreadsheet depending on what is contained within it.  This has two benefits -  It enables the users of the spreadsheet to see what cells require inputs, and it enables you to quickly spot where the pattern of formulas and inputs does not seem correct (for example - when a formula has been inserted into the middle of a row of inputs).

In this example, headings and labels have been coloured light blue, inputs purple and formulas yellow.  You can change the colour scheme to your preferred colours by selecting the options button.

Spreadsheet Formula Tracer

The spreadsheet formula tracer enables you to trace the antecedents of any formula to any depth and so understand how it was derived.  It does this by providing a visual representation of how each formula is calculated.  This visual representation can be altered in a number of different ways in order to suit your particular needs.  The representation can also be saved or printed, thereby providing an easy way to document the relationships between the different formulas within the spreadsheet.

[ Home ] [ Product description ] [ Free download ] [ Purchase product ] [ Sarbanes Oxley ] [ FAQS ] [ Support ] [ About us ] [ Free Download ] [ Contact us ]