Operational Log (4)

*Private project for Krusche* Please see below for a detailed description of Operational Log (4): Please make changes to the attached spreadsheet, Master Operational Log. 1) WEATHER LOG You will notice the Operational Log now contains more coloumns that are to be used to record different weather states including Visibility, Air Temp etc. The Daily Report must now contain an extra page ‘Daily Weather Log’ that shows recordings of these weather states. Please see attached Daily Report Template (guide). Page 4 on the DPR is the Weather Log and has columns that corresponds to the columns in the Log. The Macro must populate these columns with the information in the Operations Log at the times when the user has selected either of these two options: Operation: WoW – Adverse Weather (does not matter what Operation Stage is selected after) Operation: Concurrent vessel operations AND Operation Stage: Weather Recording (This is a choice that is available once ‘concurrent vessel operations’ is selected previously) I have detailed in the Daily Report Template (guide) what cells the Weather Log should take from the Operation Log. This should populate when the user pushes the button to create the DPR. As the comments column has changed position in the Ops Log can you please make sure the DPR is picking up the right column. 2) DAILY LEG LOADS We need to create a second separate report like the DPR called ‘Daily Vessel Leg Loads’. The template for this is attached and will be stored in the same place as the DPR templates. It should be saved as yyyymmdd_Vessel Name_Daily Vessel Leg Loads. Columns R, S, T, U and AR must be picked up in the table every hour, starting from 01:00. For example, at 01:00 this will be R12, S12, T12, U12, AR12. For 23:00 this would be R1332, S1332, T1332, U1332, AR1332. For 24:00 you should take R1451, S1451, T1451, U1451, AT1451 (Actual the columns at 23:50) I have labelled in red in the template. 3) FIELD POSITIONS We need to create a third separate report called ‘Field Positioning Report’ as attached. This will take columns at a time specified by the user. When the user clicks this button a form should appear asking for what time the user wants this report to be generated for. The attached template will then be generated by cells with the columns as specified at the row corresponding to the time inputted in the form. For example if the user inputs 00:30 the report will use row 42. 4) WEATHER SHADING Tatyana had previously produced the spreadsheet so that the cells in two particular columns were shaded orange. When the user inputted a value into these cells the shading disappeared and the cells in the same column but 3 hours later became shaded. This is done to remind the user to record the weather every three hours. As we have added columns I think this has become corrupted. We now need this to happen for columns H-P inclusive. As before the time between the shading should correspond to the Project Name and is chosen by the user is columns O and P in the Admin tab.