1. Download a new SuperTABLE 4.3 license file from Space-Time Research.
2. Close SuperTABLE if it is running.
3. In Windows Explorer navigate to the SuperTABLE installation folder. The default location is C:\Program Files\STR\SuperTABLE.
4. Find the license.dat file.
5. Rename the license.dat to license.dat.original. This is done to keep a copy of the original file.
6. Save the new version of license.dat downloaded from our web site to the license.dat file location.

1. Start SuperTABLE. The Catalogue dialogue displays.
2. Click the Close button.
3. From the menu, select Help > About… The About SuperSTAR dialog displays the version and license expiry information.
4. Click the OK button to close the About SuperSTAR dialogue.

SuperTABLE is available for download from the Space-Time Research web-site.

The download file is a zip file.  Once the zip file has been downloaded, un-zip the file and run the executable file called setup.exe.

SuperTABLE is the free table reader component of the SuperSTAR suite. SuperTABLE works with SuperSTAR formatted multi- dimensional cubes that are supplied by various organisations such as the Australian Bureau of Statistics and the Office for National Statistics (UK).

It uses a drag-and-drop interface to create tables with any number of dimensions. Tables can be re-arranged, calculations added and then the table can be printed or exported to a number of formats.

SuperTABLE isn't yet 'officially' supported on Vista. 

Although an announcement has not been made yet, we will be endorsing future versions of SuperTABLE for use with Vista.  The focus will be on adopting Vista for new SuperTABLE releases rather than retrospectively endorsing old versions.

Customer experience to date indicates that SuperTABLE does work on Vista.

• Please only use the "7.1" release of SuperTABLE with Vista.

• SuperTABLE must be installed by someone with 'administrator' permissions on the PC.

You can download the 7.1 release of SuperTABLE and the user guide from our website:

www.spacetimeresearch.com/supertable.html

This procedure will allow Web sites to automatically prompt you when downloading files and software (bypassing the Information Bar).

1. Open Internet Explorer.
2. On the Tools menu, click Internet Options.
3. On the Security tab, click Custom Level.
4. Do one or both of the following:

• To turn off the Information Bar for file downloads, in the Downloads section of the list, under Automatic prompting for file downloads, click Enable.
• To turn off the Information Bar for ActiveX controls, in the ActiveX controls and plug-ins section of the list, under Automatic prompting for ActiveX controls, click Enable.

1. Click on this message and select "Download file..."
2. Internet Explorer will then ask you if you want to Save or Run the file.
3. Select Save.
4. Save to a directory on your computer
5. Unzip the download zip file
6. Run the file called setup.exe

Yes, decimal places can be specified for some or all the columns and rows in a table.  Simply:

1.  Click on the column heading (or row label) for the data you wish to format (not the actual numbers).

2.  Once it is selected, right-click the label to bring up the floating menu.

3.  Select 'Format'   ...then 'Decimal Places'.

4.  In the Decimal Places dialogue box, uncheck the tick next to 'standard'.

5.  Enter a number for the decimals places you wish to display (1-9)

6.  Select the 'Extent of Change' to specify how widely this format applies

7.  Press OK.

Note:  You may need to drag your column widths wider to allow the extra digits to be fully displayed.

When attempting to open a database, I get an error: "The database with the same catalogue name already exists in the selected folder"

This error happens with some cubes that are provided by the ABS.

SRD files are actually a bundle of separate files that SuperTABLE uses. When SRDs are used with SuperTABLE, they become unpacked to your hard drive.

Some ABS supplied cube packages contain files that install to your hard drive with a "read only" setting.

That means when you have finished with the cube, SuperTABLE can't clean out all the files ...so if you try to use it a second time you get this conflict of files already existing.

To fix this, instead of doubleclicking on the SRD file, go into SuperTABLE and install the cube to the catalogue.

At the catalogue screen which appears on startup (or File-> New on the menu's), right click the folder named 'Catalogue'.

That will present a floating menu with an option to "Install SuperCUBE (SXV2)"

Select that and then use the 'Browse' button to locate the SRD file you want to open.

Then press OK.

SuperTABLE will warn you that a cube with the same ID already exists.

It should then give you an option to use an "Automatically generated ID", or let you specify one manually (something like 'ab1' would do). Either of these options are ok.

Once you have given the cube an ID that is different, then the earlier cube should appear in the catalogue as an item ready for use.

• Error messages when trying to add a cube to the catalogue.
• Missing or empty folder at "..\STR\SuperTABLE\databases"
• Empty folder at "..\STR\SuperTABLE\catalogue"
• File at "..\STR\SuperTABLE\super.ini" does not have a timestamp close to the last time I used SuperTABLE.

1. Open the SuperTABLE software.
2. Select 'File' and then 'New' from the menu to open the Catalogue.
3. Right-click on 'Catalogue' and select 'Install SuperCUBE' from the menu.
4. Locate the Database that you downloaded (ensure that it has been unzipped if necessary) and select a Destination Path for the Database. Then click 'Install'.
5. The Dataset will be installed to the Catalogue.
6. The Dataset will appear in the Catalogue and can be opened by selecting the Database and then clicking 'OK'

If cubes are no longer required, they can be deleted from the catalogue dialogue by right clicking on the relevant cube, and selecting delete.

If you launch a lot of cubes (SRD files),  particularly by double-clicking them with Windows Explorer, but do not re-use them often, then just turn auto-install off.

You can turn off 'auto-install' of cubes by editing your super.ini file, which can be found in the C:\ProgramData\STR\SuperTABLE directory.

Open super.ini in a text editor such as Notepad, and add or edit the following section:

[InstallSRD]
AutoInstall=0

A value of 0 means cubes will not install into the catalogue automatically.

A value of 1 will enable auto-install of all cubes used.

Note:  You can manually install any cube you wish into the catalogue, regardless of this setting, by opening the catalogue dialogue, right click on 'Catalogue' and selecting "add SuperCUBE (SXV2).

By default, the catalogue (SuperTABLE's file manager) is located on the hard drive on the computer where SuperTABLE is installed. When you use a data set (SRD file), it is generally installed to the hard drive too. It is possible to install your data sets to a central location where others can share them.

Step 1 - Create a central catalogue of data sets

1. Decide on a central location that everyone can access on the network.
2. Create a folder called catalogue and a folder called datasets (these are not compulsory names, but are useful guidelines).

Step 2 - Change your catalogue location

1. Open the SuperTABLE software.
2. From the menu, select File > Change Catalogue.
3. Browse for the catalogue folder you created in Step 1.
4. Click the OK button.

Step 3 - Install the data set to the central location

1. Open the SuperTABLE software.
2. From the menu, select File > New.
3. Right-click on Catalogue.
4. From the menu, select Install SuperCUBE.
5. Locate the database that you downloaded (ensure that it has been unzipped if necessary).
6. In destination path, browse to the datasets folder you created in Step 1.
7. Click the Install button. The data set is installed in the catalogue.
8. In the catalogue, select the data set.
9. Click the OK button.

Everyone who changes their catalogue to the central location can use the data set installed there.

Normally you would use a single instance of SuperTABLE and have many tables opened within it at any one time.

If for some reason you want to run separate SuperTABLE jobs on your desktop then you need to set the SingleInstance switch.

You can add this switch to the [General]  section of super.ini, which can be found in the C:\ProgramData\STR\SuperTABLE directory.  By default, this setting is not included in super.ini, but can be added to the General section as follows:

[General]
SingleInstance=0

(0 = many instances, 1= single instance-default)

Yes, if you have two databases which contain common field items.

A typical example of this would be merging economic data from different years into a single table.

The field and items labels must be the same in each source to make a valid table.

Download the 'Bolting' Tables in SuperTABLE document.

Whilst SuperTABLE does not have the ability to save tables as Word documents, there are a various ways to copy a table to Microsoft Word.

(a)  Copy SuperTABLE table and paste into a Word document

1. From the menu select Edit > Select All.
2. Press Ctrl + C to copy.
3. Open Microsoft Word.
4. Press Ctrl + P to paste the table into the document.

(b)  Save the SuperTABLE table as an Excel document and paste into a Word document

1. From the menu, select File > Save as. The Save As dialog displays.
2. In the File name field, enter the filename.
3. In the Save as type drop-down list, select Excel (.XLS). Note: The table can also be saved as a HTM file.
4. Click the Save button.
5. Open the file in Microsoft Excel.
6. Select the table.
7. Copy and paste the table into Microsoft Word.

(c)  Save the superTABLE table as an image and paste into a Word Document

1. Resize your SuperTABLE window to display the content you want capture in the image.
2. Press the Alt and Print Screen keys at the same time. This takes a graphic snapshot of the SuperTABLE window from the screen.
3. Open Microsoft Word.
4. Press Ctrl + P to paste the image into the document.

Tables can be set up so they can be updated easily every time a particular data set is released.

Create a re-usable table

1. Open the relevant data set.
2. Create a table.
3. Format the table as required.
4. From the menu, select File > Save As.
5. In the Save as type down-list lit, select Textual Table Definition (.TXD).
6. In the Filename field, enter in the name of the file.
7. Click the Save button.

The TXD file contains all of the layout and formatting information to re-create the table. The TXD file can be used to re-create the table using the same data set, or using a dataset that has been updated with new data.

If you want to use the TXD file with an updated data set, make sure that the updated dataset has been installed to the catalogue (either by running the SRD file or installing manually as described below).

Re-run the table

Note: This function is only avaliable from version 6.5.

1. From the SuperTABLE menu, select File > Open With...
   
2. In the Files of type drop-down list, select Textual Table Definition (.TXD).
3. Select the TXD file you want to open.
4. Click the Open button.
   

The data set will open and you can create a table based on the information in the .txd file. You can still manipulate this table if needed. If a new time period has been added to the data, you may need to add this to the table (this will depend on what time periods are included in the table).

Some datasets are updated on a regular basis, generally monthly, quarterly or annually.

When you try to add the new .SRD file to the SuperTABLE catalogue you will get the message: 'A SuperTABLE with this ID already exists. Do you want to overwrite it?'.

If you click 'Yes' the old data will be replaced by the new. This will ensure you are using the newest version of the file.

Alternatively, you can install the new data under a different ID, keeping the old data intact. To do this you must install the new SRD into a different folder than the old data.

1. Right-click on the Catalogue menu level.
2. Select Create Subfolder...
3. Enter in the new folder name.
4. Click the OK button.
5. Right-click on the new folder name.
6. Select Add SuperCUBE (SXV2).
7. Enter or browse to the SRD file to be installed.
8. You get the option to automatically generate a new SuperCUBE ID or manually enter one. Select one option as appropriate.
9. Click the Install button.
10. Click the OK button.

The new data is installed into the new folder, leaving the old data intact.