Job sheets are used to output processed Orders labels and BOM (Bill of Materials), they are created per Inventory group
Job sheets can have multiple tabs;
• Data
• Job Sheet
• Check Measure
• Labels
• Components
• Powder Coating Order Form
You can have as many tabs as your office or factory require
Jobsheets can be found by following the following steps
Settings → Inventory settings → Groups
It is important to know that Job sheets have a few components that make it work, you dont need to understand how they work, just that they exist
Below is a template of a BASIC Job sheet
Breakdown of the Excel spreadsheet
BUZ Software utilises Excel to create a Job sheet, work order / Order form. The details from an order can be arranged in a way that helps your workflow.
There is a few defined names that are required to allow the "Job sheet" to work with BUZ
Data Sheet - the raw Quote/Order data will populate in this sheet.
Job Sheet - Generally is the main form utilised, this is the base form output to progress and Order so this is a production cutting sheet or a Purchase Order for a buy–in product.
Check Measure - If required can be set up similar to the Jobsheet, you may want extra space for installers to add measurements or other written information
Tickets - if there is a requirement to have a page print per item, rather than a table with all the items.
Labels - If you use a Zebra label machine you can have BUZ print out labels that assist with production.
Components - This tab is designed as a Bill of Materials or recipe for taking components from stock for inventory control and reordering purposes.
Deductions - If there is a deduction or a table of information that is useful for other calculations we would advise putting it here.
There is no limit on the number of additional sheets that are used for production, if the business requires more pages to be printed.
Packing list
Powder Coating Order Form
Fabric cutting tab
Tube cutting tab
For more information on Job sheets click on a link below
Job sheet - How to start a Job sheet from scratch
Job sheet - BUZ 3 to BUZ Cloud
Job Sheet Considerations
Job Sheets are processed left to right and top to bottom. Excel will sometimes compensate for not sticking to this rule but Aspose, the program BUZ uses to generate the PDF's from Excel does not. So this means that a sheet cannot refer to cells on another sheet to the right of the current one because it will not have it values calculated at that point in the process.
Cells in the body of the job sheet (the area that grows when number of line items exceed template) must NOT BE MERGED.
To spread text across multiple cells:
Select the cells value is to spread across on the first row.
Right click, select Format Cells, Alignment and Centre Across Selection and then copy down.
Formating for Inches (Fractions)
Select cell(s) to be formatted.
Right click cell(s), select Format Cells, Number
Select Category: Fraction
Select desired Type
Note: If format doesn't work it is because Excel treats the number as text so type +0 on the end and that forces Excel to treat it as a number.
Using Excel Name Manager
Named Areas are added using Name Manager, in Excel 2013 this is found on the FORMULAS tab near the middle.
Select New
The box opens and Type the Name, in Scope select the sheet being referenced and then click where the red arrow is pointing and select the cell containing the value. Click OK.
Job Sheet Formula Explanations
Formula used to produce a “due date”
for a Supplier / Factory that doesn’t equal a weekend date and is 2 or 3 days prior to your Follow Up date (Install Date)
Step 1: Follow up date -3 for expected complete production date =LEFT(Data!BA5,10)-3
followup-date -3, picking up 10 to the left to only select the date
Step 2: Date Formula; =IF(WEEKDAY(AB2,2)=6,AB2+2,IF(WEEKDAY(AB2,2)=7,AB2+1,AB2))
If follow-up date equals Saturday then follow-up date plus 2 days
If follow-up date equals Sunday then follow-up date plus 1 day
If you cant find what your looking for in the help documentation let us know!
We will point you in the right direction or get something added to the documentation for you.
Email: support@busoftware.com.au
Formulas to use in the Job sheet
If there is no data in the data page the cell with this formula will be blank
=IF(Data!AY11=" "," ",Data!AY11)