Hi Friends
I need a help on how to Capt the set KPI which is provide i have my Tracking Sheet for each offload & Loading Time but due to Change KPI is set as Follow Below,
I will Appreciate if any one could assist with below template.
Thanks
I need a help on how to Capt the set KPI which is provide i have my Tracking Sheet for each offload & Loading Time but due to Change KPI is set as Follow Below,
Average of Vessel time spent (Cargo Volume ≥ 70%) on Jack up rigs & Barges ≤ 20Hrs |
Average of Vessel time spent (Cargo Volume ≤ 69) on Jack up rigs & Barges ≤ 14Hrs |
Vessel time spent in day light operations on Complexes ≤ 12Hrs. |
I will Appreciate if any one could assist with below template.
Thanks
ILSP Vessels Offshore Tracking May-2022.xlsx | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | |||
2 | Voyage | Vessel | Location | Deck % | Location Start Date & Time | Location End Date & Time | Total Hours | |||
3 | 1037 | ADNOC-221 | Ettouk Island | 04/26/22 10:20 | 04/26/22 23:00 | 12:40 | ||||
4 | 1037 | ADNOC-221 | Ettouk Island | 04/27/22 00:20 | 04/27/22 02:20 | 2:0 | ||||
5 | 1037 | ADNOC-221 | Asseifiya Island | 04/27/22 06:55 | 04/27/22 17:00 | 10:5 | ||||
6 | 1038 | ADNOC-811 | UAP | 04/27/22 08:55 | 04/27/22 09:05 | 0:10 | ||||
7 | 1038 | ADNOC-811 | Barge Al Hyleh | 04/27/22 09:50 | 04/27/22 13:10 | 3:20 | ||||
8 | 1038 | ADNOC-811 | UAP | 04/27/22 14:35 | 04/27/22 16:48 | 2:13 | ||||
9 | 1038 | ADNOC-811 | UAP | 04/27/22 16:38 | 04/27/22 17:05 | 0:27 | ||||
10 | 1038 | ADNOC-811 | UAP | 04/27/22 17:55 | 04/27/22 21:00 | 3:5 | ||||
11 | 1038 | ADNOC-811 | Das Island | 04/28/22 11:10 | 04/28/22 13:30 | 2:20 | ||||
12 | 1039 | Z-POWER | Al Ghallan Island | 04/26/22 08:00 | 04/26/22 21:55 | 13:55 | ||||
13 | 1040 | ADNOC-1011 | Umm Al Anbar | 04/26/22 11:35 | 04/26/22 23:55 | 12:20 | ||||
14 | 1040 | ADNOC-1011 | Ettouk Island | 04/27/22 09:20 | 04/27/22 16:30 | 7:10 | ||||
15 | 1040 | ADNOC-1011 | Asseifiya Island | 04/27/22 21:30 | 04/27/22 22:45 | 1:15 | ||||
16 | 1041 | A-RADIANT-7 | ACPT | 04/26/22 07:45 | 04/26/22 11:10 | 3:25 | ||||
17 | 1041 | A-RADIANT-7 | ACPT | 04/27/22 07:20 | 04/27/22 14:20 | 7:0 | ||||
18 | 1041 | A-RADIANT-7 | ZNSAT | 04/27/22 16:00 | 04/27/22 17:20 | 1:20 | ||||
19 | 1041 | A-RADIANT-7 | ACPT | 04/27/22 20:05 | 04/27/22 20:45 | 0:40 | ||||
20 | 1042 | ADNOC-851 | Arzanah Island | 04/27/22 09:05 | 04/27/22 12:00 | 2:55 | ||||
21 | 1043 | ADNOC-950 | Rig Al Bzoom | 04/26/22 01:45 | 04/26/22 03:45 | 2:0 | ||||
22 | 1043 | ADNOC-950 | Rig SMS Faith | 04/26/22 07:30 | 04/26/22 19:45 | 12:15 | ||||
Vessel Tracking |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H3:H22 | H3 | =G3-F3 |