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.

Taidot: Excel, Visual Basic, PHP, Tietojärjestelmäarkkitehtuuri, C# -ohjelmointi

Tietoa asiakkaasta:
( 0 arvostelua ) Accra, Ghana

Projektin tunnus: #34072860

39 freelanceria on tarjonnut keskimäärin $692 tähän työhön

(608 arvostelua)
(230 arvostelua)
(380 arvostelua)
(497 arvostelua)
(183 arvostelua)

"I am an Excel Expert with Professional experience working with Excel VBA Macro Coding, Formula Generation and Automation/scripting. Developing and designing complicated VBA/Macro programs are part and parcel of my da Lisää

$300 USD 7 päivässä
(266 arvostelua)
(220 arvostelua)
(32 arvostelua)

Hi! I am an expert PHP developer with skills including Software Architecture, Visual Basic, Excel, PHP and C# Programming. I've been developing web applications for more than 5 years, starting back in 2013 with custom Lisää

$750 USD 4 päivässä
(93 arvostelua)

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ää

$500 USD 8 päivässä
(39 arvostelua)

Hello, I am interested in your project. Your task is clear to me and I am ready to solve it. I have a large and successful practical experience of processing and analyzing data in Excel, including the construction of Lisää

$500 USD 7 päivässä
(122 arvostelua)
(44 arvostelua)
(81 arvostelua)

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ää

$500 USD 7 päivässä
(5 arvostelua)
(27 arvostelua)
(11 arvostelua)

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ää

$455 USD 3 päivässä
(143 arvostelua)

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ää

$250 USD 7 päivässä
(42 arvostelua)

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ää

$500 USD 7 päivässä
(4 arvostelua)

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ää

$555 USD 7 päivässä
(6 arvostelua)