RotaTrack2 Fully automated rotas, with a proven record of 8 years uninterrupted use
More information
LiteSQL provides a powerful diary with ‘Away Groups’ to aid manning levels. Then automates rotas for
Consultant fixed sessions & float free, through drop-down lists of qualified and available Trainees.
Weighing in at just $16,000 (introductory offer of $8,000) with nothing more to pay, Lite SQL outperforms any comparable rota product auto-allocating fixed sessions & ‘free’ Consultants.
LiteSQL is a rota solution for hospital departments on tighter budgets (or those needing only the basics). It is not a spreadsheet driven by a diary. It is a powerful SQL database. Lite draws on 8 years continuous use & experience.
We leave you in peace to set-up LiteSQL and run it for yourself. We provide a simple manual and video - but if you need help it ’s just a phone call away. LiteSQL uses the RotaTrack engine making a future move up to the full version simple. Lite provides a diary to track events. It automates the allocation of staff to Fixed
Sessions and then does the same for ‘Free’ Consultants. Next a drop down list of suitable and available candidates is  provided so that the user can ‘click and allocate’ other staff to fill gaps. Users can print out  lists of who is available and unavailable for confirmation.
When allocating trainees hard copy reports are provided with background information so that trainees can be allocated according to their modules with a degree of certainty. And the formidable RotaTrack Diary with ‘Away Groups’  - a major feature of the full RotaTrack is available to exert control and  interactive feedback and continues to do so after the trial.
Lite does not operate over the internet nor does personal information leave the hospitalt. (More).
Total time for the full RotaTrack to complete a 40+ theatre installation just over 20 minutes.
LiteSQL will do the white
Book1_5257_image001.gif
and yellow slice in around five minutes. Other systems will only do the white automatically. The full RotaTrack does the following:
a) Fixed sessions
b) ‘Free’ staff
c) Trainees to run lists
d) Training modules
e) On-calls
f) Shifts and rolling shifts
LATEST NEWS...
Australian trials save $150,000
Meanwhile, RotaTrack has been utilised at a major Australian Teaching Hospital &  has provided huge cost savings in excess of $AU150,000 pa.(More)
Rotarack family of products
The new range of rota products provides a solution for every need in every department and every budget no matter how big or small. Users can upgrade from one to another at minimal cost.
Resource Manager ($850) Diary and simple shifts. It also lists available and unavailable staff by day etc.
Shift Manager ($3250) As above but provides more detailed shifts and On Calls.
Lite ($9500) Auto generates fixed sessions & float free. provides drop down lists of available and qualified staff for manual allocation.
RotaTrack SQL (£TBA)


_Main entrance.jpg
That includes all fixed sessions including ITU and Obstetric and pain clinics and other outpatient sessions, float sessions and Trainee allocations. Administration staff are freed up for other tasks and RotaTrack ’s extensive record keeping provides a valuable tool. RotaTrack enables reports to be developed showing each anaesthetist their annual work programme as well as individual leave records and trainee supervision and EWTD compliance. An up to the minute rota is now available on our Intranet to all individual users and departments such as the theatre suites. ”Whilst being re-written RotaTrack has been split into three parts. A low cost Lite version provides semi-automation in that it autoflows fixed sessions and float-free sessions (that is the easy part addressed by other semi-automatic solutions ‘plug in your own expert’ - if available and away you go). An intermediate version goes where no-one else can with the flowing of trainees in accordance with service needs and training modules. It also includes shifts and on-calls. Finally a customised version such as Derby ’s is available for multi-site and larger hospitals, so you can pick by budget or needs.  
Following a move to a faster SQL version of our database engine we were anxious to exploit the benefits. Taking the new installation at the Royal Derby, we ran RotaTrack up to full speed and left the system to bed-in and provide accurate automation over a number of months before replacing old workarounds to tap into the new features.
Dr Richard Elliott (Lead Clinician) commented ... “RotaTrack has been considerably enhanced to provide
further reports and to provide extra facilities that we were unable to define until the system was initially up and running and we were able to properly appreciate its power and versatility. Every time we have seen and requested further opportunities Studio Box have delivered, enhancing the product for others as well as for ourselves.
The rewrite enabled us to achieve speeds of less than five minutes to assign over 300 sessions in a rota.
Dr Peter Mulrooney Studio Box (Australia) 19 Plumosa Mews Duncraig WA 6023 Email:  pete@rotatrack.com.au
Telephone: 0422 367 600. For background information on Studio Box click here
aus.gif
Demonstration videos: Part One (Eight Minutes): Part Two (Nine Minutes)
RotaTrack is a management tool with more than 2500 fields and tables for efficient reporting, projecting & recording all departmental activities in any industry.
Royal Derby Hospital anaesthetic department creates rotas four times faster