Job Sheet - What order does the sheet load in?
- Alex Morrisson
This page is designed to explain how the data from your order will populate the tables in a Job Sheet.
When referring to tables I mean the tables that expand when there are more products than the standard table can fit.
These tables don't necessarily contain any particular information, we leave that choice to the designer of the Job Sheet.
There is a few factors that might not be obvious.
Live vs Static
Excel is a live program, and by live I mean that if I have a formula and then change the values, the formula will update “Live”
The formula will add A1 and B1 providing an answer in C1
A | B | C | |
|---|---|---|---|
| 1 | 1 | 1 | =SUM(A1+B1) |
| 2 | 1 | 1 | 2 |
C1 will show the answer 2
If I change the value of a cell, in this example B1 will now be 2
A | B | C | |
|---|---|---|---|
| 1 | 1 | 2 | =SUM(A1+B1) |
| 2 | 1 | 2 | 3 |
C1 will show the answer 3
But this isn't what happens in BUZ, we simply take a snapshot of everything and once loaded to BUZ it is static.
This may seem odd and wouldn't affect most of the formula’s but there is a case that I will explain that can cause a problem if it isn't set correctly.
Why?
Users can create a job sheet using Excel, which is an easy way to set the layout and formula’s.
BUZ uses this information and a program called Aspose to connect the information from the order to the excel sheet, which can then be used to output an excel form or PDF sheet.
What order does BUZ produce the PDF and Excel file?
Most Job Sheets will contain a
Data
Job Sheet tab,
additionally you can also have
Check Measure
Deduction
Labels
Components
Tickets
and many more customised tabs
First - Data Tab
BUZ will populate the Data tab first,
Any information that is available from the order will be loaded to this page in its raw form, meaning that there are no formula’s, just numbers and text.
Second - Job Sheet Tab
The intention of the Job Sheet is to produce the main table of information with any formula’s that may need external data, like deductions.
This table can populate extra rows if the order has more items then the Excel sheet has allocated for - there is a through explanation about this in the Data tab page click here if you want to learn about that.
The following sheets
Once the 2 main tabs (Data and Job sheet) have been populated the sheets will load in sequence from the Most left tab to the right
In this example Data, Job Sheet, Check Measure, Deductions Lookups, Components, Labels, Tickets, Tube Dimensions
It doesn't matter which order the sheets are in in the Data settings
This table is only to tell BUZ that there is a First and last row, where the end of the table is and whether the tab is required to be printed in the PDF Copy