There are 4 methods to upload your demurrage data from your Excel spreadsheet into our 'Demurrage Claims' table. Please note that this function is currently supported by Google Chrome browser only.
To access the 'Demurrage Claims' page, click 'Demurrage' from the navigation sidebar on the left.
| Table of Contents | ||||
|---|---|---|---|---|
|
...
3. You will be able to see all the uploaded data in the ‘Demurrage Claims’ table. Click 'Save Claims' to save your data in the table. Please note that values in red are invalid and have to be resolved before saving your data. Otherwise, clicking 'Save Claims' will save all the other data successfully but will only save the values in red as empty values.
4. In your Excel spreadsheet, if you have any items that are not named exactly as those in the drop down list in the 'Demurrage Claims' table, you may use the 'Find and Replace' function in Excel. For example, you may change ‘Payment/Receipt’ (listed in your Excel) to ‘Payable/Receivable’ (listed in the 'Demurrage Claims' table). Use Ctrl + F and click on the 'Replace' tab. Type 'Payment' under 'Find what' and type 'Payable' under 'Replace with' and click ‘Replace All’. Do the same for 'Receipt'. You may then upload the data into the table successfully.
...
1. To ensure that the header names of the columns in your Excel spreadsheet match exactly with those in the 'Demurrage Claims' table without changing the former, you may download the standard table layout as an Excel or CSV file from the 'Demurrage Claims' table and input your data before uploading the file.
2. You may use any table layout (reset or customised). Right-click anywhere in the table and click 'Export', and choose the format of the file (CSV or Excel) to be downloaded into your device for your usage.
Please note that this function will export any existing data in your 'Demurrage Claims' table into the Excel spreadsheet. Otherwise, you may delete any existing data first before exporting the table for use as the standard table layout.
3. Open the newly exported file (standard table layout) and fill in your data. You are now ready to upload your file.
...
4. You will be able to see all the uploaded data in the ‘Demurrage Claims’ table. Click 'Save Claims' to save your data in the table. Please note that values in red are invalid and have to be resolved before saving your data. Otherwise, clicking 'Save Claims' will save all the other data successfully but will only save the values in red as empty values.
5. In your Excel spreadsheet, if you have any items that are not named exactly as those in the drop down list in the 'Demurrage Claims' table, you may use the 'Find and Replace' function in Excel. For example, you may change ‘Payment/Receipt’ (listed in your Excel) to ‘Payable/Receivable’ (listed in the 'Demurrage Claims' table). Use Ctrl + F and click on the 'Replace' tab. Type 'Payment' under 'Find what' and type 'Payable' under 'Replace with' and click ‘Replace All’. Do the same for 'Receipt'. You may then upload the data into the table successfully.
...
3. You will be able to see all the uploaded data in the ‘Demurrage Claims’ table. Click 'Save Claims' to save your data in the table. Please note that values in red are invalid and have to be resolved before saving your data. Otherwise, clicking 'Save Claims' will save all the other data successfully but will only save the values in red as empty values.
4. In your Excel spreadsheet, if you have any items that are not named exactly as those in the drop down list in the 'Demurrage Claims' table, you may use the 'Find and Replace' function in Excel. For example, you may change ‘Payment/Receipt’ (listed in your Excel) to ‘Payable/Receivable’ (listed in the 'Demurrage Claims' table). Use Ctrl + F and click on the 'Replace' tab. Type 'Payment' under 'Find what' and type 'Payable' under 'Replace with' and click ‘Replace All’. Do the same for 'Receipt'. You may then upload the data into the table successfully.
...
3. You will be able to see all the uploaded data in the ‘Demurrage Claims’ table. Click 'Save Claims' to save your data in the table. Please note that values in red are invalid and have to be resolved before saving your data. Otherwise, clicking 'Save Claims' will save all the other data successfully but will only save the values in red as empty values.
4. In your Excel spreadsheet, if you have any items that are not named exactly as those in the drop down list in the 'Demurrage Claims' table, you may use the 'Find and Replace' function in Excel. For example, you may change ‘Payment/Receipt’ (listed in your Excel) to ‘Payable/Receivable’ (listed in the 'Demurrage Claims' table). Use Ctrl + F and click on the 'Replace' tab. Type 'Payment' under 'Find what' and type 'Payable' under 'Replace with' and click ‘Replace All’. Do the same for 'Receipt'. You may then upload the data into the table successfully.
...
| Multimedia | ||
|---|---|---|
|
(00:01) Upload Data into Demurrage Table
(00:15) Download Data from Demurrage Table