The SheetAccessories.csv file contains accessory items for installing roof panels and sheeting, such as clips, screws, butyl tape, and other components.
These accessories are configured via the Setup > Define Panels input dialog:
🧾 CSV File Format
The SheetAccessories.csv file uses the following field structure:
Field | Description | Details |
Field 1 | Accessory name | Maximum 25 characters |
Field 2 | Product Code | Key field that links accessories to specific panels |
Field 3 | Finish | Surface finish or coating specification |
Field 4 | Items per box | Quantity of items in each box or package |
Field 5 | Cost per box | Purchase cost for each box or package |
Field 6 | Number/Distance | Quantity or spacing value used with estimation method |
Field 7 | Estimation Method | Code defining how quantities are calculated (see tables below) |
Field 8 | Material or Labour accessory | 0 = Material accessory, 1 = Labour accessory |
Product Code Linking: The Product Code in Field 2 creates the association between accessories and defined panels. When you set up panels in Setup > Define Panels, accessories with matching product codes are automatically linked to those panels.
🔧 Material Estimation Methods
For Material accessories (Field 8 = 0), use these estimation codes in Field 7:
Code | Estimation Method |
0 | Not estimated |
1 | Per Unit Area |
2 | Spaced along Panel |
3 | Per Join |
4 | Per Panel |
5 | Per Intersection with Batten/Purlin |
6 | Per m in Zone (Field Zone) |
7 | Per m in Zone (Edge Zone) |
8 | Per m in Zone (Corner Zone) |
🔧 Labour Estimation Methods
For Labour accessories (Field 8 = 1), use these estimation codes in Field 7:
Code | Estimation Method |
50 | Not estimated |
51 | Per Unit Area |
52 | Spaced along Panel |
53 | Per Join |
54 | Per Panel |
55 | Per Intersection with Batten/Purlin |
56 | Per m in Zone (Field Zone) |
57 | Per m in Zone (Edge Zone) |
58 | Per m in Zone (Corner Zone) |
💡 Key Points
Some fields have character limits - indicated in brackets (e.g., [25] for accessory name)
The Product Code is the critical field that links accessories to panels
Labour estimation codes start at 50 to distinguish them from material codes
Field 6 (Number/Distance) works with the estimation method to calculate quantities