I am a pilot at a small airline. We have been purchased by another, larger, airline. Each airline is represented by a union. Pilots are listed on a seniority list based on his/her date of hire, the most senior pilot holding seniority number 1 and the most junior pilot holding the last seniority number, numbered sequentially.
The unions (both represented by the same union) wish to merge the lists based on a ratio. For instance, integrate one pilot from the smaller airline into the larger airline once every 5 pilots. For instance, the list would begin with 5 pilots from the larger airline, then one pilot from the smaller list would be inserted, then the next 5 pilots from the larger airline, the next pilot from the smaller airline, and so on. Can this be automated in Excel? Is this a project for Access? I am looking for answers on how to set up and manage the project, not someone who will do it for me - we are likely going to be negotiating and it will take a LOT of hypothetical merged lists to come to an agreement.
7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
I would do this with a macro in Excel. It should be easy. I'm happy to create one that you can reuse, or you can just take the suggestion and design your own.