Spreadsheet: 887010d1737085206-security-and-editing-tables-book1-example
Sheet: Sheet1

Category Tables |  | Parts and linial Table |  |  |  | Parts Inc GP Table
PartsNotIncGPCats |  | PandL_Materials |  |  |  | [NAME]
PartsCategoriesList |  | PartsCatList | PartsAndMatsList |  |  | PartsCatGPList | PartsIncGPList
Parts Categories |  | Parts Category | Parts and Materials | Rate |  | Parts Category GP | Parts Including GP | Rate |  |  | Ranges to be able to be unlocked for editing.
Accessories (Inc Fitting) |  | Accessories (Inc Fitting) | Nikpol Std Bin | 160 |  | Accessories | Nikpol Blind Cnr Baskets | 500 |  |  | A6:A20
[NAME] |  | Accessories (Inc Fitting) | Nikpol [NAME] | 180 |  | [NAME] | Dual Colour | 200 |  |  | A26:A34
Factory Labour |  | Accessories (Inc Fitting) | Nikpol Teramo Bin | 305 |  | [NAME] | [NAME] | 400 |  |  | C6:E150
[NAME] |  | Accessories (Inc Fitting) | NP Laundry hamper | 190 |  | [NAME] | Drafting | 100 |  |  | G6:I30
Handles |  | Accessories (Inc Fitting) | Nikpol 150w slim slide-out | 150 |  | [NAME] | Commission | 100
Hinges_Drawers |  | Accessories (Inc Fitting) | Wire wine rack insert | 170 |  | DrawerUpgrades | DTC Titanium Dampeners | 15 |  |  | The rest of the sheet should remain locked.
Installation Labour |  | Accessories (Inc Fitting) | NP Chrome wire drawer 450 | 95 |  | DrawerUpgrades | [NAME] to PTO | 35
[NAME] |  | Accessories (Inc Fitting) | NP Chrome wire drawer 900 | 105 |  | DrawerUpgrades | [NAME] to PTO | 65
LED Lighting |  | Accessories (Inc Fitting) | Spice Tray | 110 |  | TwoPack | 2 Pack Paint Std | 117
Miscellaneous |  | Accessories (Inc Fitting) | Slide out t-towel rail | 60 |  | TwoPack | 2 Pack Paint Special | 130
Removal / Delivery |  | Accessories (Inc Fitting) | Blum Orga Line cutlery tray >700 | 150 |  | TwoPack | 2 Pack Extra | 10
[NAME] |  | Accessories (Inc Fitting) | [NAME] cutlery tray >600 | 150
 |  | Accessories (Inc Fitting) | Profile Doors | 50
 |  | Accessories (Inc Fitting) | 13mm Compact Lami | 1200
 |  | Accessories (Inc Fitting) | [NAME] | 300
 |  | Accessories (Inc Fitting) | UnderMount Basin | 200
PartsIncGPCats |  | Accessories (Inc Fitting) | Nikpol Magic Corner | 450
PartsIncGPCatsList |  | Accessories (Inc Fitting) | [NAME] 300w Pull out pant | 700
 |  | Accessories (Inc Fitting) | LS Sub slim 150w oil slider | 257
Parts Inc GP Categories |  | Accessories (Inc Fitting) | Plastic cutlery tray 500mm | 25
Accessories |  | Accessories (Inc Fitting) | Plastic cutlery tray 900mm | 45
[NAME] |  | [NAME] | HF | 220
DrawerUpgrades |  | [NAME] | HK | 120
TwoPack |  | Factory Labour | Per cabinet | 50
 |  | Factory Labour | Per hour | 60
 |  | [NAME] | Standard arris /m | 3
 |  | [NAME] | Standard arris Tough /m | 7.2 |  |  | Instructions
 |  | [NAME] | Flat polish /m | 7.25 |  |  | To add data to the [NAME] and [NAME] or Parts Inc GP tables simply type in the row below and the table will automatically expand.
 |  | [NAME] | Flat polish Tough /m | 9.95 |  |  | The category must match a category in the Categories tables otherwise the cell will be highlighted red to warn you.
 |  | Handles | F/Pull Melamine | 40 |  |  | If you need to add a new category simply type it directly below the existing categories in column A, and the table will automatically expand.
 |  | Handles | F/Pull 2 Pack | 30 |  |  | # IMPORTANT: After adding to the tables they must be sorted alphabetically by the "Category" column.
 |  | Handles | High Range | 36 |  |  | This is done through the drop down menu in the headers.
 |  | Handles | Mid Range | 24
 |  | Handles | [NAME] | 12
 |  | Hinges_Drawers | Soft Close Hinges inc plates 110 | 7
 |  | Hinges_Drawers | Soft Close Hinges inc plates 170 | 8.5
 |  | Hinges_Drawers | Soft Close Hinges inc plates blind | 9
 |  | Hinges_Drawers | Soft Close Hinges inc plates cnr | 9
 |  | Hinges_Drawers | Soft Close Hinges inc plates 0-Prot | 13
 |  | Hinges_Drawers | Soft Close Hinges inc plates 45deg | 10
 |  | Hinges_Drawers | DTC Titanium Single ext std kit | 17
 |  | Hinges_Drawers | DTC Titanium Frt Brackets (Pair) | 12
 |  | Hinges_Drawers | DTC soft close mech | 14
 |  | Hinges_Drawers | DTC Smooth Drawer kit (std) | 55
 |  | Hinges_Drawers | DTC Smooth Drawer kit (inner) | 80
 |  | Hinges_Drawers | DTC Dragon-Pro Dr Kit (std) | 80
 |  | Hinges_Drawers | DTC Dragon-Pro Dr Kit (inner) | 120
 |  | Hinges_Drawers | [NAME] Dr Kit (std) | 80
 |  | Hinges_Drawers | [NAME] Dr [NAME] (Inner) | 120
 |  | Hinges_Drawers | Our Dr Kit (std) | 55
 |  | Hinges_Drawers | Our Dr Kit (inner) | 80
 |  | Installation Labour | Per cabinet new | 50
 |  | Installation Labour | Per cabinet reno | 60
 |  | Installation Labour | Per hour special | 80
 |  | Installation Labour | Per hour Re-Face | 80
 |  | Installation Labour | Factory build rate | 60
 |  | [NAME] | 600 W | 125
 |  | [NAME] | 900 W, 2 Sides | 231
 |  | [NAME] | Self edge | 25
 |  | [NAME] | M Mitre | 40
 |  | [NAME] | Rolled End | 57
 |  | [NAME] | [NAME] | 10
 |  | LED Lighting | Profile & Strip ea | 75
 |  | LED Lighting | Transformer ea | 45
 |  | LED Lighting | Sensor ea | 45
 |  | Miscellaneous | Plastic Legs | 2.5
 |  | Miscellaneous | Cosumables | 10
 |  | Miscellaneous | Shark fin handle (Ace) | 20
 |  | Miscellaneous | Horizontal Grain Match per piece (Ace) | 10
 |  | Miscellaneous | Hand edge corner shelves etc (Ace) | 10
 |  | Miscellaneous | Delivery (Ace) | 95
 |  | Removal / Delivery | Deliver Local | 200
 |  | Removal / Delivery | Deliver Noosa/Cabool | 300
 |  | Removal / Delivery | Remove & Dispose | 500
 |  | Removal / Delivery | R&D Splashbacks | 100
 |  | Removal / Delivery | R&D Stone | 100
 |  | Removal / Delivery | R&D Hi-Rise | 100
 |  | [NAME] | Hanging Rail /m | 10
 |  | [NAME] | Cleated shelves /m | 40
 |  | [NAME] | [NAME] 42x19 /m | 9