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
Macro (Bplookup)
Job Sheet Parts and Purposes
- First sheet should be the Data sheet this where the raw Quote/Order data is place starting at column AV and the Data Setting table is that controls the adding of rows to each sheet that requires it when the Quote/ Order lines exceed the template. The template should be designed to fit on one page initially.
- The Job Sheet 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.
- There is no limit on the number of additional sheets that are used for production.
- Labels sheet controls the format of the labels to be printed for this product type. This requires the installation of BUZ Labels Windows program to print to a Label Printer.
- Check Measure sheet is a form that can be output to best suit the Check Measure process with space provided for updated measurements etc.
- Components sheet is the Bill of Materials or recipe for taking components from stock for inventory control and reordering purposes.
Set up Job Sheets
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
- Packing list
- Deductions
- Powder Coating Order Form
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
For help relating to othe pages that can be added to a job sheet click on one of the links below
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)