Spreadsheet: 550838d1512573131-auto-generate-data-in-multiple-cells-example-workbook
Sheet: CODE 03

03 |  |  |  |  | Discount |  |  | Discount |  |  | Discount |  |  | Discount |  |  | Discount | Running Costs |  | Final Invoice |  |  |  |  |  |  |  | Running Costs | Final Invoice |  |  |  |  |  |  |  |  |  |  |  | Running Costs | Final Invoice |  |  |  |  |  |  |  |  |  |  |  | Running Costs | Final Invoice | Legend
Code |  | Description | Quote | Work Area |  | Quote | Work Area |  | Quote | Work Area |  | Quote | Work Area |  | Quote | Work Area |  | Quote | Work Area | Quote | Work Area |  | Total Area / Qty | Total Area / Qty | Total Area / Qty | Total Area / Qty | Total Area / Qty | Total Area / Qty | Total Area / Qty |  | COST | DISCOUNT | COST | DISCOUNT | COST | DISCOUNT | COST | DISCOUNT | COST | DISCOUNT | COST | COST |  |  | DISCOUNT |  | DISCOUNT |  | DISCOUNT |  | DISCOUNT |  | DISCOUNT | COST | COST |  | Price not given - Estimate as per highest cost
 |  | Before filling out this section please click here and read the guide on Code 03! |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quantity not given - Estimated quantity
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attention Required
 |  | Days at repair berth |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automatic formula
 |  | Days in dry-dock
 |  | Total running days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
3.01 |  | Vessel Areas & Paint Supplier Details
 |  | No costing required. For info only
 |  | Click to add Job Line
 |  | Click to add New Job
3.01 | T | TOTAL
3.02 |  | Hull Coating Preperation
 |  | No costing required. For info only
 |  | Click to add Job Line
 |  | Click to add New Job
3.02 | T | TOTAL
3.03 |  | Hull Coating Protection Tariff Rates
 |  | Click here for Definition of Areas
 | a | High Pressure  water washing per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | b | Ultra high pressure water washing per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | c | Fresh water flushing per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | d | Oil stain removal w/ yard supply chemicals per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | e | Oil stain removal w/ owners supply chemicals per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | f | Hand scraping per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | g | Disc sanding per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | h | Rotary wire brushing per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | i | Feathering edges per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | j | Spot blasting to SA 2.0 per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | k | Spot blasting to SA 2.5 per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Bulk blasting to SA 2.0 per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | l | Bulk blasting to SA 2.5 per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | m | Sweep blasting per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | n | Touch up coats of Anticorrosive coating per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | o | Touch up coast of Tie coat per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | p | Full coats of Anticorrosive coating per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | q | Full coats of Tie coat per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | r | Full coats of conventional coating per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | s | Full coats of Antifouling per m² |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Top sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Boot top |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Vertical sides |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Flat bottom |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Min area to be blasted
 |  | Paint Drum Disposal
 |  | [NAME] |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | Click to add Job Line
 |  | Click to add New Job
3.03 | T | TOTAL
3.04 |  | Hull Prep & Coating Specification
 |  | Click here for Definition of Areas
 |  | Item 1 Hull Washing
 | Area (m2): | 0
 | a | High pressure washing |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | b | Fresh water flushing |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  | Item 2 Top Sides
 | Area (m2): | 0
 | a | Chemical cleaning |  | 0.01 |  |  | 0.01 |  |  | 0.01 |  |  | 0.01 |  |  | 0.01
 | b | Full blast to SA 2.5 |  | 0.0331 |  |  | 0.0331 |  |  | 0.0331 |  |  | 0.0331 |  |  | 0.0331
 | c | Spot blast to SA 2.0 |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1
 | e | Fresh water flushing |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | f | Application of
 |  | Full coat of anti abrasive to area (b) |  | 0.0331 |  |  | 0.0331 |  |  | 0.0331 |  |  | 0.0331 |  |  | 0.0331
 |  | T/U coat of anti corrosive to area (c) |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1
 |  | Full coat of top coat |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  | Item 3 Boot Top
 | Area (m2): | 0
 | a | Hard scraping of barnacle growth |  | 0.01 |  |  | 0.01 |  |  | 0.01 |  |  | 0.01 |  |  | 0.01
 | b | Full blast to SA 2.5 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | c | Spot blast to SA 2.0 |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1
 | d | Fresh water flushing |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | e | Application of
 |  | Full coat of anti abrasive to area (b) |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | T/U coat of anti corrosive to area (c) |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1
 |  | Full coat of Tie coat |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  | Full coat of anti fouling |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  | Item 4 Vertical Sides
 | Area (m2): | 0
 | a | Hard scraping of barnacle growth |  | 0.01 |  |  | 0.01 |  |  | 0.01 |  |  | 0.01 |  |  | 0.01
 | b | Full blast to SA 2.5 |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 | c | Spot blast to SA 2.0 |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1
 | d | Fresh water flushing |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | e | Application of
 |  | Full coat of anti abrasive to area (b) |  | 0 |  |  | 0 |  |  | 0 |  |  | 0 |  |  | 0
 |  | T/U coat of anti corrosive to area (c) |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1
 |  | F/C of anti corrosive to area (c) & (d) |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  | Full coat of Tie coat |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  | Full coat of anti fouling |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  | Item 5 Flat Bottom
 | Area (m2): | 0
 | a | Hard scraping of barnacle growth |  | 0.03 |  |  | 0.03 |  |  | 0.03 |  |  | 0.03 |  |  | 0.03
 | b | Spot blast to SA 2.0 |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1
 | c | Fresh water flushing |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 | d | Application of
 |  | T/U coat of anti corrosive to area (b) |  |  |  |  | 0.1 |  |  | 0.1 |  |  | 0.1 |  |  | 0.1
 |  | Full coat of Tie coat |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  | Full coat of anti fouling |  | 1 |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 1
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
3.04 | T | TOTAL
3.05 |  | Hull Distinguishing Marks
 | a | Name fwd in 2 positions
 | b | Name & port of registry aft in 1 position
 | c | Draft  marks in 6 positions
 | d | Plimsoll marks in 2 positions
 | e | Tug marks
 | f | Pilot ladders marks
 | g | Manifold marks port & stbd
 | h | Bulbous bow & tank boundaries
 | i | IMO number aft in 1 position
 | j | Sea grids, echo sounder, speed logs etc positions
 | k | Thruster markings
 | l | Installation or painting of corporate logos
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
3.05 | T | TOTAL
3.06 |  | Funnel Painting
 | a | High Pressure Wash
 | b | Chemical Degreasing
 | c | Spot blast to ST.2.0
 | d | FW Flush
 | e | Application of:-
 |  | 2* T/U to area (d)
 |  | 1*FC Topcoat
 |  | 2*FC Heat Resistant Paint
 |  | Staging
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
3.06 | T | TOTAL
3.07 |  | Sea Chests & Grids
 | a | Removal of protective grids per chest
 | b | Thorough cleaning per chest
 | c | HP washing per chest
 | d | Blasting to SA 2.0 per chest
 | e | Fresh water flushing per chest
 | f | Application of coatings per chest
 | g | Replacement of grids per chest
 |  | Staging per chest
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
3.07 | T | TOTAL
3.08 |  | Sea Chest Anodes
 | a | Removal & disposal of old anodes each
 | b | Making good attachment arrangements per chest
 | c | Fitting of new anodes each
 | d | Protection of new anodes each
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
3.08 | T | TOTAL
3.09 |  | Hull Sacrificial Anodes
 | a | Removal & disposal of old anodes each
 | b | Making good attachment arrangements
 | c | Fitting of new anodes each
 | d | Protection of new anodes each
 | e | Making good any damaged coatings
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
3.09 | T | TOTAL
3.1 |  | ICCP System
 | a | Electrician assistance per man hour
 | b | Cherry picker per hour
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
3.1 | T | TOTAL
3.11 |  | MGPS Anodes
 | a | Fitter assistance per man hour
 | b | Cherry picker per hour
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
3.11 | T | TOTAL
 |  | Total for Code 03 (Excluding Nett)
 |  | Total for Code 03 Nett Costs