What are the different documents?

PDF

The PDF will contain all the relevant information on the project, everything that has been specified during the planning phase.

Excel

The Excel sheet is created to allow you as shipyards to provide price quotations to your needs while making it easy for the customer to import it back to their system once they receive it in return. It is highly recommended that you use this field to provide price quotations. The format of this sheet should be kept intact, but you are free to add as many additional sheets as you like. You can also add more cost items than that which is contained in the list, more about this below.

ZIP (optional)

The ZIP file will contain any attachments you have added to the project, such as drawings. This format is not always provided to you (optional).

How to add prices

In the Excel file, there is one line per cost item, and each work order can have several cost items. This is so that you can give detailed prices on the specific things that are cost drivers for you as shipyards - making it easier for both you and your customer to keep track of costs during the project and avoid costly surprises along the way. For each cost item, there are several fields for you to fill out. These are marked in yellow.

A snapshot of a cost item list:

So in the Excel file, the fields you can fill out per cost item are "Unit price", "Discount" and "Remarks". In addition, if you want to, you can change/update the estimated quantity and measurement unit. Please keep in mind that the estimated quantity needs to be in a number format.

It's important that you don't make any changes to the last two columns. The cost ID is particularly important that it is kept untouched, because it's a unique identifier which will later allow the ship manager to automatically import of your quotation to Maindeck. Everything after that, you can change.

If the cost type is a Lump sum price, then you can change it to a Per unit price (although it's not recommended, as the ship manager usually wants the price quoted in a particular way). The column "Estimated quantity" is just that: an estimate. It's important that you try to make it a realistic estimate. If not, the quantity will change during the project execution, which won't lead to a happy customer.

The measurement unit is important if the cost item is a Per unit cost. You need to know what the unit you are measuring it against is. For instance, is it 500 tonnes, or 500 m3?

Adding additional lines (cost items)

You can also add additional cost items if you'd like. To do this, start by adding a new, empty row anywhere below the column headers (the first row). You will then need to copy the "WO ID" of the work order for which you are adding a new cost item. Also add a text under "Cost item" describing what it is, and then add either "Lump sum" or "Per unit" under cost type. If it's a lump sum, also add the number "1" under quantity. You are then ready to fill out the unit price (also for lump sum), discount and yard remarks for that new cost item.

Do not need to copy other fields such as SFI or Cost item Reference. Particularly the latter must be kept blank for additional cost items you want to add - this is how the system will detect it as a new cost item for that specific work order.

⚠️ Things to keep in mind ⚠️

• Add additional lines (cost items) when necessary. If you do, copy the "WO ID" for the work order that you are adding an additional line for.
• Do not merge any cells.
• Do add unit price, do not add prices into the total after discount (unit prices and discounts are imported, the rest are calculated on Maindeck)
• For per-unit costs, add an estimated quantity (If it's an estimate, specify this in the remarks).
• Add a unit price for all per unit cost items. For lump sum cost items, the unit price field is where you also add the lump sum price (for lump sum, the quantity is set to 1).
• Do not add additional rows as headlines on the cost sheet. Only the top row is for column headers.
• Add as many additional sheets as you want, if you want to add more information about your shipyard. This does not interfere with the customer's ability to import the prices to Maindeck later.

If you don't follow the simple guidelines, you might find yourself in a situation where the customer can't upload your quotation. They would see this message when trying to upload your quotation:

Your customer will then have to go through the file and clean it up, which significantly lowers the chances of your yard being selected.