The International Safety Management Code (ISM) requires records of maintenance activities planned and carried out on board ships. For such maintenance tasks you can purchase maintenance software with powerful functions from well known Manufacturers. But for Shipping Companies owning or managing a limited number of small vessels only, such programs are often to voluminous or expensive.

Furthermore many other ISM related records like Non-Conformity Reports, Training Reports, Master's Review and so on shall be maintained. In consequence an extensive form system, in addition to the Maintenance System, is necessary to fulfil all report requirements. In this connection Marsig can resort to a big pool of form templates which apply to all areas of shipping.

Marsig has developed a simple form and maintenance system which is based on Microsoft's® Excel. This program as a part of Microsoft's® Office Suite is available on board nearly all ships. All required or wished forms and maintenance jobs can be integrated into one Excel file. This form system is proven by different shipping companies in the meantime.

Trial excel files including forms and maintenance solutions for engine and deck department of small vessels are available for free download as follows. We would appreciate your response and comments.

MS Excel ISM Form System - Deck Department     (zip file, 235 kB)

MS Excel ISM Form System Engine Department (MAK Engines)     (zip file, 427 kB)

MS Excel ISM Form System Engine Department (MAN Engines)     (zip file, 290 kB)


FEATURES:

in General
- very cost-effective
- no additional software necessary
- useable as form and maintenance system
- easy handling

Form handling
- MARSIG prepares and integrates all company forms for Excel use
- Excel trained company employees are able to maintain the Excel file by themselves
- Direct link to each integrated Form from an master screen
- both printable and paper-less handling of forms possible
- small filesize of about 1 MB of the zipped excel file including all forms
- simply form analysis at company office by using key words

Maintenance handling
- integration of maintenance forms
- input of running hours
- input of maintenance tasks and job descriptions
- calculation of due dates

optional
All forms delivered to the company office should be analysed by responsible or designated persons. In case the company manages a couple of ships a lot of forms have to be checked every month.
By using the paperless MARSIG Excel Form System the company is able to obtain all regular forms inside one excel file electronically. These Excel files can be searched by a little software tool, which is looking for pre-defined signs agreed on all vessels. If any deviations or incidents occur the responsible person for filling-in the forms on board marks his important comments by this pre-defined signs. Now the company office is able to find any special remarks from board quickly without reading all forms.

Some Screenshots of the Excel Maintenance/Form Administration are shown below. Please click the thumbnails for enlargement.
Engine Form Table

All Engine Form Buttons inside this Cover Sheet are linked to their corresponding Engine Forms. The linked buttons are clearly divided according to their using schedule: monthly, weekly, daily and on demand. Furthermore all Checklists and Maintenance Reports as well as the Maintenance Working Sheets like Due Dates, Running Hours and Daily Input are reachable from this position. Each form takes over fixed general data like 'vessel name' or 'voyage number' from this cover sheet automatically.
Deck Form Table

All Deck Form Buttons inside this Cover Sheet are linked to their corresponding deck forms. The linked buttons are clearly divided according to their using schedule: monthly, weekly, daily and on demand. Furthermore all FAL Forms and Checklists are reachable from this position.
Each form takes over fixed general data like 'vessel name' or 'voyage number' from the cover sheet automatically.
Excel Print View of Forms

All integrated engine and deck forms, checklists and working sheets are printable as usual as an empty template or after filling-in.
Running Hours

The working sheet "Running Hours" is one part of the integrated Maintenance System. Here you can enter the monthly Running Hours of your machineries.
Maintenance other Machinery

At this working sheet all maintenance jobs for machinery other than the main engine are listed. Furthermore all jobs are marked with the last maintenance date, the maintenance interval and the next planned maintenance date. Additional state displays show the jobs which are due or coming up soon. Such working sheets are available for different groups of machinery.
Due Dates

This working sheet covers all maintenance jobs of all machineries and other devices. But unlike the other sheets here you can sort the jobs according their due dates. For example: By pushing the button "Due" only those jobs are listed which are presently due.

The animated picture beside (if enlarged) shows the different views (all jobs / due jobs / soon jobs) of the work sheet "Due Dates".

© 1997-2010 MARSIG mbH