Dialy Schedule Excel Sheet
Budget: $30 – $250 USD
I work in a flight school and we are using an excel file to plan the daily activities that include flights, simulators, lessons and administrative duties. In excel is very difficult to identify overlaps of timings between activities with the same personnel. Also whenever we have more or less students, or we plan more or less flights, I need to resize the schedule, cut and insert lines etc. I want someone to take the excel file I attach and use create a friendly. It should highlight conflicts (overlaps in timings) but allow the user to override. It should count the events per person and use this counter to arrange the suggested names from least events to most (in order to select the IP or student with less events and come out with a balance workload). It should also count the events per person from the beginning of each week and show a counter. Drag and drop functionality for the names as an alternative to drop down should be available. The excel should allow to insert/remove new IP and SP. The final schedule should be printable and the format should be adjustable. A calendar with all the IP and SP should be also part of the app. In this calendar I will insert the duties of each person so that the daily schedule can update who is present on each day. The calendar should also show the number of events for each day per ip.
The way I imagined this schedule app is this: I open a new schedule, I add the date on top, the table of flights, sims, lessons and admin is empty of names and times but the boxes are there, the structure is there. I start adding names, times and missions and the app in the background checks that the combination of name and time is valid, no overlap.
I work 12 hours a day, I spent already a lot of time on the schedule as it is, the forms will increase this time, that is not my goal. I want to save some time so I can spent time with my family not spend more time filling infinite windows of forms.
To avoid auto bid, plz place "I am human for excel dev." on the top of your proposal
The way I imagined this schedule app is this: I open a new schedule, I add the date on top, the table of flights, sims, lessons and admin is empty of names and times but the boxes are there, the structure is there. I start adding names, times and missions and the app in the background checks that the combination of name and time is valid, no overlap.
I work 12 hours a day, I spent already a lot of time on the schedule as it is, the forms will increase this time, that is not my goal. I want to save some time so I can spent time with my family not spend more time filling infinite windows of forms.
To avoid auto bid, plz place "I am human for excel dev." on the top of your proposal