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...
Unfortunately I haven't yet resolved this issue. Suggestions would be appreciated!
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