Turnover Metrics

Can you create a Web App in less than 72 hours, based on an existing excel tool that calculates the Cost of Employees Turnover? Are you a full-stack team who enjoys taking part in energetic and fast-paced Hackathons?

If yes, submit your ideas for the Web App now and join us between 16^th-18^th November at the Greek Campus to develop the prototype, for a chance to win Smart Watches for your team and up to 30,000 EGP fund to develop the Web App further!

Background:

Due to the high importance of promoting the awareness of job quality and employees retention in the Egyptian blue collar labour market, the Labour Market Access Project (LMAP) of the GIZ have developed a "Cost of Turnover" Tool in collaboration with the International Labour Organization (ILO), to calculate the cost of employee turnover in the workplace. This tool enables companies to better assess the value of retaining employees and the loss resulting from high employee turnover. Yet, this excel tool needs to be turned into a Web Application for easier access by various companies all over Egypt.

The Web Application will be used by financial officers, HR officers, operational managers, and business owners of SMEs in Egypt to assist them in understanding the financial impact of employee turnover. 

Tool Description:

The Cost of Turnover Tool is a pure Excel Spreadsheet with one Input and one Output sheet. It is based on basic formulas (e.g. addition, multiplication, division etc.) and does not include Macros or advanced algorithms. 

The produced Web App should fulfil the following:

1. Having both English & Arabic Interface;

2. Capability of creating user accounts with different privileges;

3. Auto generation of the Cost of Turnover based on the input data;

4. Being technically robust, e.g. application is stable and bugs-free, data entered is secure etc.;

5. Usability and Friendly User Experience. 

Participation Conditions and Process:

1. Application must be done as a team of 4 members maximum, including all required expertise, e.g. Frontend, Backend etc.

2. Submitting an application form including ideas on how to turn the Excel Tool into a Web App, with Minimum Cost, Highest Flexibiliy, and Friendly User Interface.

3. The team should be capable of developing the tool completely on their own, without technical support from the hackathon organizers.

Rewards:

All Hackathon attendees will be given Participation Certificates in appreciation of their contribution.

The first winning team shall receive the following prizes provided by the GIZ:

1. Smart Watches

2. Design Thinking training by GIZ

3. Winners Certificates

4. Fund up to 30,000 EGP to develop the prototype into a fully-funcational Web Application (based on Timeline and Budget to be submitted after the Hackathon) 

Two Runner Up Teams will receive: 

1. Basic VR Sets

2. Runner Up Certificates

---

---

Brainstorming

Share your ideas and get help