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

01 |  |  |  | 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 |  | QUOTE |  | QUOTE |  | QUOTE |  | QUOTE |  | QUOTE | QUOTE |  |  | Qty | Qty | Qty | Qty | Qty | Qty | Qty |  | COST | Discount | COST | DISCOUNT | COST | DISCOUNT | COST | DISCOUNT | COST | DISCOUNT | COST | COST |  |  | Discount |  | DISCOUNT |  | DISCOUNT |  | DISCOUNT |  | DISCOUNT | USD | USD |  | Price not given - Estimate as per highest cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Quantity not known - Estimated quantity
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Attention Required
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Automatic formula
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments
1.01 |  | Docking
 | a | First day costs in dock
 | b | Subsequent days in dock
 | c | Additional costs for OOH docking
 | d | Any other additional costs
 |  | Dock preparation
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.01 | T | TOTAL
1.02 |  | Wharfage
 | a | Wharfage per day
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.02 | T | TOTAL
1.03 |  | [NAME]
 | a | Per line per day
 | b | Connection  & disconnection per line
 |  | No of Lines
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.03 | T | TOTAL
1.04 |  | Fire Main
 | a | Per line per day (@ 10 bar)
 | b | Connection  & disconnection per line
 |  | No of Lines
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.04 | T | TOTAL
1.05 |  | Fire Watch
 | a | Watchman per day (24hrs)
 | b | Number of men required
 | c | Additional cost for
 |  | Saturday
 |  | Sunday
 |  | Holidays
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.05 | T | TOTAL
1.06 |  | Gas Free Certificates
 | a | Initial visit incl transport
 | b | Subsequent visits incl transport
 | c | Any additional cert cost
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.06 | T | TOTAL
1.07 |  | Hotwork Certificates
 | a | Provision of permits
 | b | Length of validity
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.07 | T | TOTAL
1.08 |  | Gangways
 | a | First gangway per day
 | b | Installation & removal of first gangway
 | c | Additional gangway per day
 | d | Installation & removal of additional gangway
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.08 | T | TOTAL
1.09 |  | Shore Power
 |  | Option 1
 | a | Per kWh
 | b | Connection & disconnection per time
 |  | Option 2
 | a | Supply of Genset per day (24hrs)
 | b | Supply, installation & removal of cable run
 | c | Supply of fuel per m³
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.09 | T | TOTAL
1.1 |  | Garbage Disposal
 | a | Per skip per day
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.1 | T | TOTAL
1.11 |  | Heating [NAME]
 | a | Per day per lamp / batch
 | b | Connection & disconnectionper lamp / batch
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.11 | T | TOTAL
1.12 |  | Telephones
 | a | Connection & disconenction of line
 | b | Local calls
 | c | International calls
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.12 | T | TOTAL
1.13 |  | Crane services
 | a | Per hour
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.13 | T | TOTAL
1.14 |  | Scuppers
 | a | A/C overboard
 | b | Reefer plant overboard
 | c | Sewage tank overboard
 | d | Galley scupper and drain discharge
 | e | Deck suppers
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.14 | T | TOTAL
1.15 |  | Fresh & Distilled Water Supply
 | a | Fresh water per ton
 | b | Connection & disconnection of FW line
 | c | Distilled water per ton
 | d | Connection & disconnection of distilled water line
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.15 | T | TOTAL
1.16 |  | Towage
 | a | Tugs per move
 | b | Linesmen / riggers per move
 | c | Pilot per move
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.16 | T | TOTAL
1.17 |  | Cleaning
 | a | Wash down of entire vessel to main deck
 | b | Wash down & cleaning of ER bilges
 | c | Wipe down of accom decks & bulkheads
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.17 | T | TOTAL
1.18 |  | Ballast Water
 | a | Ballast water per ton
 | b | Connection & disconnection per line
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.18 | T | TOTAL
1.19 |  | [NAME]
 | a | Removal & refitting per plug
 | b | Vacuum test per plug
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.19 | T | TOTAL
1.2 |  | Compressed Air Supply
 | a | Supply per day (24hrs)
 | b | Connection & disconnection per line
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.2 | T | TOTAL
1.21 |  | IGG Supply
 | a | Hire of IGG per hr / day
 | b | Connection & disconnection
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.21 | T | TOTAL
1.22 |  | Ventilation
 | a | Per fan per day
 | b | Connection & disconnection per fan incl ducting
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.22 | T | TOTAL
1.23 |  | Technical Assistance
 | a | Welder
 |  | Normal hour
 |  | Overtime hour
 | b | Fitter
 |  | Normal hour
 |  | Overtime hour
 | c | Electrician
 |  | Normal hour
 |  | Overtime hour
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.23 | T | TOTAL
1.24 |  | Pumping Bilges
 | a | Portable pump per hr / day
 | b | Connection & disconnection of pump
 | c | Disposal of bilge water per m³
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.24 | T | TOTAL
1.25 |  | Security Watch
 | a | Watchman per day (24hrs)
 | b | Number of men required
 | c | Additional costs for
 |  | Saturday
 |  | Sunday
 |  | Holiday
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.25 | T | TOTAL
1.26 |  | Sewage Disposal
 | a | Disposal per m³ incl holding tank
 | b | Additional for environmental legislation
 |  | Connection & disconnection
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.26 | T | TOTAL
1.27 |  | Access Hatches
 | a | Engine room
 | b | Pump room
 | c | Steering gear
 | d | [NAME]
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.27 | T | TOTAL
1.28 |  | Safety Rails
 | a | Per manhole
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.28 | T | TOTAL
1.29 |  | Alleyway Protection
 | a | Protect following areas:
 |  | Upper Deck Cross Alley Way
 |  | 1st [NAME]
 |  | Central Office
 |  | CCR
 |  | ECR
 |  | Ships Office
 |  | Offciers Mess
 |  | Officers [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | Bridge
 | b | Protect following stairs:
 |  | Upper deck to 1st Poop Deck
 | c | Additional Protection
 | i | 4mm Ply
 | ii | 4mm Hard Board
 | iii | Heavy Duty Kraft Bitumen Paper
 |  | [NAME]
 |  | Click to add Job Line
 |  | Click to add New Job
1.29 | T | TOTAL
 |  | Total for Code 01 (Excluding Nett)
 |  | Total for Code 01 Nett Costs