Google Sheets - Personnel Managment and Shift Planning Woorkbook - Costs Reporting
Orçamento €30-250 EUR
Develop and make adjustments on a Google Sheet that is used to retail team management and shift planning.
Sheets should be work for:
- Schedule and Management of a team of around 60 people.
- Ajust Daily working schedule to a location;
- State place to work (Location);
- Control and report No. Hours of working by location;
- Control and report No. hours of working by Employee;
- Control and report No. of hour of working by day / week / month;
Number of employees between 40 and 60 (each has a internal code and name)
Number of working locations (9):
- Alegria
- Matosinhos
- Flores
- Campo Lindo
- Rodrigues
- Costa Cabral
- Boavista
- Gondomar
- Armazem
Woorkbook Comprises:
- Costs Report Sheet;
- Monthly Schedule and Planning Sheet (Shift and Location sheet). January, February, March…;
- Shifts Config (Sheet used to config working times)
- HR Config (Sheet used to list total number of workers and hourly cost of each)
Locations could be identified by Color.
Calculations of costs and total hour month and day by location could be done by any script or Valuesbycolor functions.
Google Sheets URL that needs to be adjusted:
[login to view URL]
Concedido a:
18 freelancers estão ofertando em média €117 nesse trabalho
"I am ready to start now. I have read the deatails that u attched on the project I am certified at data entry exam on freelancer. Let us discuss in chat. "
--------I CAN DO IT RIGHT AWAY-------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VB, building an excel file, excel dashboard, pivot tables, charts, v Mais
Hi, Good day Cutting long story you will have to read multiples proposal for your project but have a look here too you may be hire the best financial expert for your project. I can start now and ready for your proje Mais
Hello, I can accomplish all the tasks you want quickly without any mistakes. Please do not hesitate to dm me to discuss details.
Hi I read your description and understand about work that needs to migrate the website to other server. I will be able to do this quickly as required.
I read it carefully I am interested in this project please give a chance to me i have an experience of office work i am doing a lots of work in excel , word , searching on internet etc.
I have professional experience in Excel VBA and can help in effective management of the 60 members scheduling
Dear sir, i can do this work with perfection. You can trust me on this .I will thankful to you if you give me a chance to do this .
I'm a professional data entry expert I can complete the work within set target time frame I am a very honest person.
Dear prospective client, I've read through the job description and understood your needs. I'll assist you to create the best template for your shift planning workbook. You can expect the best result from my work since Mais
Hi, I can make the necessary adjustments to the sheet as per your requirement. Please check my portfolio for a few other similar projects on Google Sheets. Let's chat over this.
