PRIVATE PROJECT FOR KRUSCHE
We have an Operational Log for each of our vessels and each month.
From the data stored in these workbooks we would like to create separate reports.
1. Daily Reports.
Every day the user will be required to create a daily report summarising the information in each worksheet. On each worksheet there will be a button called ‘Create DPR’. This should create a separate Excel file that is generated from the information in the active worksheet and the Administration tab. I have attached the current Daily Report that is used. The Daily Reports created from our spreadsheet should follow the same layout as that attached but please feel free to simplify the format, i.e. the number of columns used etc. Any information that cannot be filled using the information in the worksheet or administration tab should be left blank for the user to input once the DPR excel file is created.
Operational Timings section will summarise all Operations from the worksheet. This section will list the Time, Location and Operation of each operation that is listed in the worksheet. A master template should be available that we can adapt. This master template will be the template used to when 'Create DPR' button is pressed.
2. Vessel Summary.
There will be a separate Excel file titled “Vessel Summary”. This will basically rearrange the information in the original workbook into a different layout. I have attached an example Excel file that represents this.
The fields will be Operation, Operation Stage and then each Location in chronological order, as it appears in the worksheet. Under each location the cell should calculate the duration of the Operation Stage. In my attached example, cell C8 will calculate the duration of inward clearing by looking at the worksheet and calculating Inward Clearing (Red) – Inward Clearing (Green). The next record in the Vessel Summary sheet will be the next operation stage to occur, in this case, ‘Jack-up’ and calculate this duration in cell C9. Inward Clearing and Jack-up durations should be calculated in this row for subsequent locations. When a new Operation Stage takes place that is not already listed, a new row should be created. My attached example should correspond to the worksheet in the "new spreadsheet" attachment to give you an idea of how this should be created.
Each vessel should have its own workbook and each worksheet will be a different month.
3. Project Summary.
This will be created in the same way as the Vessel Summary but will summarise each Project. It will list all Operation Stages completed by all vessels working on this project and calculate the durations of each Operation stage at each location. The only difference to the ‘Vessel Summary’ will be an additional field, ‘Vessel’. I have attached an example template titled ‘Project Summary Sheet’. The location columns should run from the start date of the project until the end date of the project which will need to be defined by the user of the Project Summary sheet.
I am not too sure how the creation of reports work. Should we have an Administration tab in the Reports workebook to define the fields and workbooks that the data should be taken from?
5 freelancers are bidding on average £314 for this job
I am an MBA in Finance. In my BBA & MBA Program I had to create so many Excel templates. So, It is an easy task for me. If you give me the chance I'll complete the job successfully and timely.