Forum Discussion
Calculate Occupancy (%)
Hi all, I'm trying to come up with a measure to help measure the occupancy of a particular loading location (A & B). Ships go to these locations and they remain docked for a certain time until loa...
Provide some sample data in usable form.
Hi lbendlin ,
See below:
| Load date | Load end | Duration (hours) | Location | Ship |
| Thu Sep-17 00:00 | Thu 01:17 | 1 | B | SSBBB |
| Wed Sep-16 18:47 | Thu 00:59 | 6 | A | SS444 |
| Sun Sep-13 16:58 | Mon 02:36 | 10 | B | SS999 |
| Fri Sep-11 00:01 | Fri 20:41 | 20 | A | SSQQQ |
| Thu Sep-10 18:24 | Thu 23:59 | 5 | A | SSQQQ |
| Wed Sep-09 22:32 | Thu 14:08 | 16 | A | SS444 |
| Tue Sep-08 16:21 | Tue 22:04 | 6 | B | SS555 |
| Tue Sep-08 05:00 | Tue 17:00 | 12 | A | SSLLL |
| Mon Sep-07 10:06 | Mon 21:40 | 11 | B | SS999 |
| Sun Sep-06 00:00 | Wed 08:00 | 80 | A | SS111 |
| Sun Sep-06 00:00 | Sun 00:38 | 0 | A | SSMMM |
| Wed Sep-02 19:44 | Thu 13:48 | 18 | A | SS444 |
| Tue Sep-01 00:41 | Tue 19:16 | 19 | B | SS555 |
| Tue Sep-01 00:00 | Tue 23:59 | 23 | A | SS123 |
| Sun Aug-30 11:13 | Sun 23:52 | 12 | B | SS999 |
| Sun Aug-30 00:00 | Sun 23:59 | 23 | A | SS987 |
| Wed Aug-26 19:18 | Thu 15:30 | 20 | A | SS444 |
| Tue Aug-25 23:28 | Wed 19:00 | 20 | A | SS111 |
| Tue Aug-25 17:54 | Tue 23:28 | 6 | B | SS555 |
| Mon Aug-24 16:53 | Tue 00:39 | 8 | B | SS555 |
| Mon Aug-24 00:01 | Mon 16:53 | 16 | A | SS547 |
| Sun Aug-23 16:06 | Sun 22:15 | 6 | B | SS999 |
| Sat Aug-22 08:53 | Sat 21:42 | 13 | B | SS999 |
| Sat Aug-22 08:53 | Sun 16:06 | 32 | A | SS222 |
| Sat Aug-22 00:00 | Sat 00:38 | 0 | B | SSBBB |
| Fri Aug-21 14:15 | Sat 03:37 | 13 | A | SSMMM |
| Fri Aug-21 00:01 | Fri 14:07 | 14 | A | SSQQQ |
| Thu Aug-20 14:15 | Thu 23:59 | 9 | A | SSQQQ |
| Wed Aug-19 20:07 | Thu 14:07 | 18 | A | SS444 |
Thanks,
Mohs