Job Sheet - Main Table

How do the tables work and how do they expand when there are multiple products

This page will discuss the Main Table,

• How the table works

• What makes them expand

• Potential formula’s that you can use in the table

• Potential issues that can occur

So what exactly is the Main table

Open

Simply it is a table which will increase in size if there are more products than rows, the job sheet designer can input any formula’s or values as long as they dictate the area of the Table in the Data tab (Shown below)

Adding a Main table to a sheet”

There is no right or wrong amount of rows to start off with, generally we would recommend 10 rows as a nice easy figure to work with.

Generally the table would take up 1 page to minimise waste.

• If there is only 1 product then you wouldn’t want several pages of empty formula’s to be printed, so we make the table expand when there is more products

The Main table is normally located under the Heading table, which consists of information relating to the Customer, job overview and possibly barcode.

Example of a Heading Table

Open

You should also leave a Row for the Table Description Row and “Group Option Headings” although this is not mandatory if you have a different way to setup your sheet.

Next you will need to create the table, If you have a job sheet/order form/work order or something similar to this use it for a template, we can always make changes or add new columns later on.

If you dont have these forms then you could use the Group Options to determine the size of your table,

after all these are where all the answers come from.

In the example below the Main Table first row would be 12, the last row would be 16 and the Right Column would be F

My Data Setting would look like this

Formula’s for the Main table

Once the table has been created you can start allocating the data required, this could be anything from a simple lookback formula to something that uses a few values to do a search or possibly reference a table to do a deduction