US$20 to Automate Crew Roster

    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/

    Re: US$20 to Automate Crew Roster


    HI, SMC! Any news about my project?

    DiogoCuba
    "Give a man a fish, he'll eat for a day.
    Teach a man to fish, he'll eat for a lifetime.
    Give a man religion, he'll die praying for a fish."

    Re: US$20 to Automate Crew Roster


    My apologies for the delayed response, but I had a detailed look at the requirements, and though it doesn't look complex, I am afraid it will require some time investment, and I have to pass since I am constrained by time. I leave this open to other developers of the community.

    Re: US$20 to Automate Crew Roster


    I can look at this for you

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Re: US$20 to Automate Crew Roster


    Thanks, KjBox! You have done part of the job actually on a free thread. I am sure you can help me to build this automation!

    DiogoCuba
    "Give a man a fish, he'll eat for a day.
    Teach a man to fish, he'll eat for a lifetime.
    Give a man religion, he'll die praying for a fish."

    Re: US$20 to Automate Crew Roster


    Quote

    There other features but I have to explain better for the person that takes the job.


    I did send you a PM with my email address for sending the additional features and details.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Re: US$20 to Automate Crew Roster


    Your code is ready, I will PM you with my PayPal details, then attach the file here upon receipt of payment.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

    Re: US$20 to Automate Crew Roster


    KjBox, I have paid via paypal. Can you please send me the file to revise it?

    DiogoCuba
    "Give a man a fish, he'll eat for a day.
    Teach a man to fish, he'll eat for a lifetime.
    Give a man religion, he'll die praying for a fish."

    File needed structural changes as well as code. A file that worked perfectly for me was sent via e-mail, OP reported "It does not work" and has supplied screen shots.


    Issue would appear to be conflicting Locale settings for Date in various sheets.


    OP has been asked to allow me remote access via TeamViewer so that I can resolve the issue.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login