Do some Excel Work
$250-750 USD
Pago na entrega
Priors Court School
[url removed, login to view]
Requirements: staff rota planning & recording
Priors Court is a school and supported living establishment (24 x 7) catering for autism: it has some 400 full time staff and 100 flexible workers and it requires an improved tool for managing its staff rota.
Details
• each rota covers a 10 week period
• based on shifts, full time staff have contracted hours, flexible staff do not
• staff are allocated to work locations at the planning stage
• managers identify where planned hours / locations require additional staff and upstaff the plan accordingly
• last minute changes to the plan due to sickness/unavailability are input
• totals and summaries are produced
The current system has an input excel for the 'rota' 2MB and another for the 'schedule' 28MB, the latter being the main reporting and analysis file.
The requirement is to produce a more robust and automated excel based solution which can be run by the staff and maintained by them (adding new locations/ name maintenance etc). The current system does not deal effectively with overtime, either at the planned or the actual stages, and an overtime management aspect is a wish (not an absolute requirement).
ID do Projeto: #6458002
Sobre o projeto
18 freelancers estão ofertando em média $495 nesse trabalho
Hi! I have more than 10 years experience using Ms Excel. Please let me know if the excel file should cover 1 month period or more. Best Regards Khurram Zubair
I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high Mais
Following points, gives me an upper hand to handle this project: * Done a lot similar work in my previous assignments * Very good hands-on & experienced in MS Excel 2003, 2017, 2013 * Deliver on time with high qu Mais
I have a signed certificate as technical in office automation. I work easely with Excel. I have used it for 8 years in my work as accounting clerk. Contact me for details.
