Hi, I have a Crew Roster that controls the crew changes of a certain vessel and I would like to automate it to avoid wasting time with manual copy and paste.
Anybody willing to help me?
Some of the actions I need:
- Create a Pax list and a Flight Manifest based on the personnel assigned to embark and disembark;
- Generate a Daily POB based on the names that are onboard (Including the dates of embark and a counter to count how many days the person is onboard);
- Compare the Daily POB to a criteria to see if the safe manning is compliant or not;
- Create a PAX LIST for the next 7 days automatically so that I can see who is crew change and who is not - this should be triggered based on the dates;
- Auto generate Flight Manifest when I click a button and input the date of any given date.
There other features but I have to explain better for the person that takes the job.
Delivery ASAP or before 07JUL2017.
File for reference: forum.ozgrid.com/index.php?attachment/72875/