Medical Excel Rota

[Gurminder Khamba]

Hi

Has anyone successfully done or seen a medical rota app/excel spreadsheet ? Been asked to take over the rota role and the excel 97 spreadsheet is unforgivable on all fronts especially the colour scheme !

Many Thanks

Gurminder Khamba

[Stefan Buttigieg]

Rotas need to be digitised, automated BUT with a capability for manual override. Has this ever been tackled before? Would be interested in being involved in this project. I would be able to help out in terms of user experience as a doctor and would contribute by designing basic low-fidelity wireframes to get started and with WP to promote the project and create a basic landing page for the project.

Stefan

Stefan Buttigieg, M.D(Melit.), P.G Cert(Sheffield)

Medical Graduate | Masters Candidate - Health Informatics - University of Sheffield | Freelance Mobile Developer

stefanbuttigieg.com

ste...@buttigieg.co

(+356) 99509280

Gurminder Khamba

--
You received this message because you are subscribed to the Google Groups "nhshackday" group.
To unsubscribe from this group and stop receiving emails from it, send an email to nhshackday+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Marcus Baw]

Digital rota programs are widely available in the commercial sector. I'm not aware of any opensource ones though, or of anyone providing and affordable Rotas As A Service offering. So there is possibly an opportunity, for the right people with the right approach.

Current systems simply use a formula/algorithm to create a basic rota. Swaps are then handled manually, after the rota is created.

A disruptive alternative might be: allow the users of the rota to make requests using a Doodle like interface, and the rota is created from the data entered.

M

[Jon Shaw]

There was some very good rota software created by A&E doctors in Scotland http://www.rotageek.com. They really struggled to make it commercially sustainable and scalable in the NHS alone so have now branched into other industries with enterprise customers such as O2. Not sure if they ever started as open source or not but worth talking to them. 

Also http://erota.net/ was started by Anaesthetists and is actually self sustaining at the moment, providing their software to anaesthetic and ITU departments across the NHS. Worth approaching both and understanding their offering and their journey!

[Melissa Morris]

We have built this tool at Network Locum.

It's a bespoke tool which enables excel import of rotas onto an online secure platform,

It also has an app for the clinicians to allow them to apply on the move and a billing / payroll platform to enable rota managers to pay them.

We orginially started in Primary care, now 20% of GP practices and out of hours organisations in the UK use it.

We have now started working in Hospitals. We helped North Middlesex fill their entire rota in days, cutting out all agency.

Happy to talk to any of you about this more

Melissa

Phone: 07827233804

Melissa Morris | @meliss_morris | @networklocum | blog

[VJ]

http://bma.org.uk/support-at-work/contracts/juniors-contracts/rotas-and-working-patterns/rota-template-and-riddell-calculator

Any use?
VJ

[Rob Dyke]

dunno .... until you share it here ;-)

[Marcus Baw]

+1 it's behind the BMA paywall, which I resolutely won't cross :-|

M

[Ben Sharif]

+1 for http://erota.net/

My anaesthetic department uses it and I must say it is fantastic. 

Well worth contacting them for info though I have no idea what it costs etc