Converting an Excel scheduling program into a cross-platform application. (With Kronos integration)

  • Job typeJob type: Remote
  • Job DurationLess than a month
  • Project LevelExpensive
  • Project deadlineDecember 15, 2021

Project detail

I have created an excel workbook book that automates many processes in shift planning simply by employees updating their availability.

The program works with a form of binary code and “if/then” equations on one sheet which is determined by availabilities on another sheet which then translates and collates all the information on one interactive dashboard on another seperate sheet.

Simply, employees log in, provide availability, all info is shown on dashboard, coordinator selects from dropdown lists, roster is automatically updated, publish to employees. This data is then communicated to Kronos automatically, coordinator simply reviews and confirms, and Kronos does the rest of the payroll side of things

I work in a emergency department and have saved my nursing coordinator 4.5 hrs per monthly roster for our casual orderlies and AINs (This use to be a 5 hour task).

I would like to use the same system I have designed in Excel and convert it into a web/mobile/desktop app that can scale to a larger workforce so that we can use the same system for our nurses.
The only customisable fields for the user will be “shift names”, “shift time/duration, “employee categories”, “employee names”, and shift selection from a dropdown list based on availability.

Ideally this app will integrate with Kronos to automatically input data from my app. Potential integration with Workday might be beneficial but is not necessary.

I am open for input on improvement or better solutions.

I have seen some excel to app conversion software but it doesn’t appear to suit my needs. I have also looked at powerapps but it doesn’t distribute to app stores so that is not a solution either. Hence why I am looking to outsource.

An NDA and contract concerning IP and software ownership will need to be signed prior to the commencement of work.

Industry Categories

Languages required