Tabs

Top  Previous  Next

FormCalc SST Spreadsheet Tabs

FormCalc SST is essentially a spreadsheet connected to some powerful behind-the-scenes software which controls both the spreadsheet and its interaction with QuickBooks. The spreadsheet consists of five tabs or "pages", described below.

QuickBooks tabs and their purposes

Snapshot

This is the main tab (page) you will work with in FormCalc SST. It is where FormCalc SST puts a (spreadsheet-representation) copy of your QuickBooks form when it takes a snapshot of the form. It is also where you will enter spreadsheet formulas for performing calculations when your QuickBooks forms are processed.

Notes

This page is for your own use, such as for keeping notes on your calculations, sample formulas, etc. Whatever is on this page is preserved when you save the FormCalc SST file, and is never overwritten (unlike the Snapshot page, which is erased whenever you take a new snapshot).

Defaults

This page contains default data which FormCalc SST uses to create a new file when you choose File > New.

The Defaults tab is not user editable.

OLD Snapshot

When FormCalc SST is preparing to take a snapshot of a QuickBooks form, it first copies the Snapshot page to the OLD Snapshot page. This preserves a copy of formulas from the prior snapshot—all of which are erased by taking a new snapshot—so that you may recover them by Copying individual formulas to the Windows clipboard from the OLD Snapshot page, then Pasting them into cells on the Snapshot page.

Workspace

This page is for FormCalc SST's use in processing a QuickBooks form. It holds the formulas used in the most recent form processing run. For that reason, it can sometimes be useful to technical support for debugging purposes.

Changes to the Workspace page do not cause a "File has changed...Save the file?" prompt to be displayed as you exit FormCalc SST. So instructions from technical support may specifically ask you to save the file after a processing run—to be sure the Workspace page's changes is included—before sending the file to us for analysis of a problem.