The TileAccess.csv file defines accessories for tiles listed in the Tiles_V6.csv file. Products are linked to their parent tile by product codes, with the first item in each group being the parent tile, followed by its accessory items.
🧾 File Structure
The file uses a specific column structure where each tile and its accessories are grouped together:
Column | Description |
Code | Product code identifier |
Name | Product name/description |
Tile Code | Code of the parent tile this accessory belongs to |
Finish | Finish specification |
Items per Box | Quantity per packaging unit |
Cost per Item | Individual item cost |
Number per Estimate | Quantity factor for estimation |
Estimation Mode | How the item is quantified (see modes below) |
Mat = 0 / Lab = 1 | Item type: 0 = Material, 1 = Labour |
🛠 File Format Example
The CSV uses semicolons as delimiters and groups items by tile type:
;Code,Name,Tile Code,Finish,Items per Box,Cost per Item,Number per Estimate,Estimation Mode,Mat = 0 / Lab = 1 BOND,,,,,,,, Bond-RT,Ridge Tile,Bond,Bond,1,0,370,3,0 Bond-HT,Hip Tile,Bond,Bond,1,0,370,4,0 Bond-BT,Gable Tile,Bond,Bond,1,0,370,7,0 ;,,,,,,,, CONCRETE TILE,,,,,,,, Concrete Tile-RT,Ridge Tile,Concrete Tile,Concrete Tile,1,0,350,3,0 Concrete Tile-HT,Hip Tile,Concrete Tile,Concrete Tile,1,0,350,4,0 Concrete Tile-BT,Gable Tile,Concrete Tile,Concrete Tile,1,0,350,7,0 SC12,Spring Clip,Concrete Tile,,1,0,1,2,0
🔧 Estimation Modes
The estimation mode determines how accessories are quantified during estimation:
Mode | Description |
0 | Not Estimated - Item is listed but not estimated |
1 | Per Unit Area - Item quantified based on roof area where panel is installed |
2 | Per Tile - Adds accessory item(s) per tile |
3 | Spaced Along the Ridge - Adds accessory based on ridge length |
4 | Spaced Along the Hip - Adds accessory based on hip length |
5 | Spaced Along the Valley - Adds accessory based on valley length |
6 | Spaced Along the Gable - Adds accessory based on gable length |
7 | Spaced Along the Roof to Wall (Apron) - Adds accessory based on apron length |
8 | Spaced Along the SideWall (Step) - Adds accessory based on sidewall (step) length |
9 | Spaced Along the Monoridge - Adds accessory based on monoridge length |
10 | Automatic Flashing Category - Software automatically adds accessories based on defined flashing line types |
11 | Per Apex - Adds accessory based on each ridge/hip apex |
12 | Per Shell End - Adds accessory per hip end (shell-end piece) |
13 | Per Wind Zone - Additional accessories required based on structure's wind zone (set in JobInfo dialog) |
⚠️ Important Notes
Always backup the original file before making changes
Maintain the semicolon delimiter structure
Group accessories under their parent tile codes
Use consistent spacing and formatting for proper file parsing