Đã hoàn thành

Operations Log in Excel - 2


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?

Kĩ năng: Excel, Visual Basic

Xem nhiều hơn: operations log template, daily operations log excel, excel operational log template, daily vessel log excel, work log in, log into, 12 month spreadsheet, vessel daily report excel, vessel operation log sheet, operational log, operations log, log time, how to master excel, master excel, vessel, separate data in spreadsheet cell, reports in excel, report from excel, operations, master e work, log in, jack will, it operations, into the clearing, excel reports

Về Bên Thuê:
( 7 nhận xét ) Great Yarmouth, United Kingdom

ID dự án: #1691357

Được trao cho:


Here is our bid on the project. High quality and promptness are guaranteed.

£550 GBP trong 28 ngày
(28 Đánh Giá)

5 freelancer đang chào giá trung bình £314 cho công việc này


Hi, I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I am interested to work for your project. I will make sure that I deliver you the best with 100% ac Thêm

£250 GBP trong 3 ngày
(43 Nhận xét)

Greetings! I am interested in this project. Let me know if i can help you.

£250 GBP trong 7 ngày
(4 Nhận xét)

Hi, I would love to work on your project as it seems very interesting and worth challenging. I've worked on many Word (Reports type) projects like yours and received numerous positive feedbacks. If you'd like, I can sh Thêm

£260 GBP trong 7 ngày
(0 Nhận xét)

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.

£260 GBP trong 7 ngày
(0 Nhận xét)