Build a Scheduler
Budjetti $250-750 USD
- Freelancer
- Työtehtävät
- Excel
- Build a Scheduler
Lively Minds Scheduler requirements.
The Lively Minds programme consists of a schedule of field and office based activities that run the length of a school term, around 3 months.
The activities are designed in a specific order and timing that allows the programme to be set up and embedded correctly, this order and the timings within the term is crucial to the programmes success.
Currently we painstakingly plot all of these activities per term manually in a GANNT chart in excel, taking into account all of the conditional relationships between tasks. Once done this 3 month schedule, viewed as weeks rather than days, is used to communicate the dates to the wider team.
The format of these activities falls into 3 distinct templates, set-up, ongoing, and sustain.
Every term 6 new districts in Ghana are brought into the programme and have to cycle through these phases.
What we require is a system that can have the rationale, dependencies and conditions for these 3 phases programmed in as templates, so that rather than manually plotting each term we can just select the term start date, and the phase we want to map and it populates.
Every term there will be districts in each of the difference phases, so there needs to either be 3 phase views, or one view that can accommodate all 3 phases, currently we have all mapped on to one GANNT. Happy for have separate views by phase, but as the same teams conduct activities for difference phases the system needs to be alert to clashes between them.
For each activity there are staff roles required, and varying numbers of staff required, this too would be programmed into the system to highlight if not enough staff are assigned to a task, or not enough staff exist to fulfil all the tasks on one occasion.
A key aspect of this is the dependencies, for example each activity knowing that it must happen after the previous task and before the next, and that it must occur, for example, within 2 weeks of the start of term.
The practice we are looking to achieve is that if for example we have plotted all of the activities for the term and then a national holiday is announced in Ghana, we can designate that date as a non working day, and the activity for that day would move to the next working day, and all related tasks would also move, and flag and conflicts that this may cause. An example is below
Attached you can see tasks were plotted, with non working days (weekends) blocked. Once the Monday also is marked as a non working day, all the tasks need to move along, but still factor in the weekend.
This proposed change would populate but only be published for all after admin confirmation. I f for example this knock on effect pushed the activities in this chain after the latest programmed date (end of term) this would flag as an error requiring admin action to fix. Admin would be able to make edits outside of rationale when required, but no one else would.
39 freelanceria on tarjonnut keskimäärin $692 tähän työhön
Hello, Hope you’re fit and fine during this pandemic era! I have gone through the requirements of yours and love to say that we have already created many customized software solutions for my clients. In fact not only Lisää
I am writing to you in reference to the job posting you have made. I believe I would be an excellent fit for this position since I am a software engineer with a wide variety of experience in the field. I tend to view Lisää
Hello Sir , Iam excel expert level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need t Lisää
Hello, Hope you are doing well!! I am a web developer with 8 years of experience in designing and developing web applications for small and medium businesses. I have rich experience in graphic designing too. My skill- Lisää
Hello! I can help you to build such scheduler in Excel. It may be needed to use macros - depends on the details of your requirements. So, you need the program where you can just select the term start date and the pha Lisää
Hello! I consider my self perfect match for this job because project skill sets are very suitable for me. I have a profound experience in programming skills and languages such as Excel, C# Programming, PHP, Visual Bas Lisää