The issue with the spreadsheets<\/p>

1. Accuracy \u2013 in a Forbes article it was estimated that 9 out of 10 spreadsheets contain errors, and this article by Incisive details \u2018Horror Stories\u2019 and the astonishing fact that \u201824% of spreadsheet formulas used by Enron contained mistakes\u2019<\/li>
2. Security and safety \u2013 backing up spreadsheets can be difficult and haphazard<\/li>
3. Spreadsheets are often silos of information and difficult to share<\/li>
4. Having more than one user sharing the same spreadsheet often results in many versions being created and important data being lost<\/li>
5. Other than simple reports getting meaningful data is time-consuming and prone to error<\/li>
6. Managing and consolidating different spreadsheets from multiple users or regions is a headache and hard to maintain consistency of formats, layouts and so on<\/li>
7. Almost impossible to validate data being entered in spreadsheets<\/li>
8. Difficult to integrate with other systems and leads to data already held elsewhere being manually keyed in<\/li><\/ol>

   Unfortunately, it is too easy for individuals to create their own spreadsheets, especially when their existing systems are deficient in some way. Spreadsheets pop up to plug these gaps.<\/p>

   The Alternatives to Spreadsheets<\/p>

   1. Stand-alone laytime calculators \u2013 these programs simply provide the calculation and usually a laytime statement. Unfortunately, being \u2018alone\u2019 they do not offer automatic import of data or integration with accounts, trading, and credit control systems.<\/li>
   2. Voyage Management Systems \u2013 these are large systems primarily directed at Ship Owners who manage Chartering, Operations and Demurrage. These offer features across all these functions and will not cover Demurrage in such depth as a specialist software program does. They may not be able to handle the complexities of multiple charterers and\/or transhipment operations in a way that reflects your business and is aimed at Ship Owners they may not be suitable for Trading companies who have the added problem of recovering demurrage from their FOB sellers and CIF buyers.<\/li>
   3. One System fit for purpose \u2013 Far better to have one place for everything and for it all to be connected. A system such as the Claims Management System (CMS) from HubSE allows users to link with existing systems to avoid manual input of data that already exists in one form. The whole process is contained in one place where you can:<\/li><\/ol>
      • Monitor upcoming time bars<\/li>
      • See all aspect of the claim in one place \u2013 the calculations, the financials<\/li>
      • Place all documents<\/li>
      • There\u2019s more but space prevents further details<\/li><\/ul>

        What can you do Next?<\/p>

        The traditional role of claims departments is to process the claim and get the cash in the door as fast as possible. This is no longer good enough on its own. Switched on managements are seeing that demurrage is a significant cost or piece of income that needs much more attention. Clients want to know how to maximise these opportunities in the future by learning what went wrong in the past such as<\/p>

        1. What sort of delays and duration can I expect at certain ports\/berths?<\/li>
        2. How many cents per tonne is demurrage costing? Is one product costing more than another? If so why?<\/li>
        3. What clauses in the charter party or contract have cost money\/lost income?<\/li>
        4. What operational processes are causing losses?<\/li><\/ol>

           All this information and more is available in a system such as CMS.<\/p>

           The time has come to discard your spreadsheets entirely.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

           This article by Phil Stalley first appeared in Trade Finance Global and you can see the article here. Though you may be familiar with the terms demurrage and detention in the context of the container business, this article will be focusing on the process of laytime and demurrage in those cases where the vessel is […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,50,51,53,60],"tags":[],"class_list":["post-5677","post","type-post","status-publish","format-standard","hentry","category-claims-management-system-from-hubse","category-demurrage","category-european-barges","category-laytime","category-technology"],"_links":{"self":[{"href":"https:\/\/www.hubse.com\/wp-json\/wp\/v2\/posts\/5677","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hubse.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hubse.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hubse.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hubse.com\/wp-json\/wp\/v2\/comments?post=5677"}],"version-history":[{"count":5,"href":"https:\/\/www.hubse.com\/wp-json\/wp\/v2\/posts\/5677\/revisions"}],"predecessor-version":[{"id":5682,"href":"https:\/\/www.hubse.com\/wp-json\/wp\/v2\/posts\/5677\/revisions\/5682"}],"wp:attachment":[{"href":"https:\/\/www.hubse.com\/wp-json\/wp\/v2\/media?parent=5677"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hubse.com\/wp-json\/wp\/v2\/categories?post=5677"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hubse.com\/wp-json\/wp\/v2\/tags?post=5677"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}