Google Sheets - Personnel Managment and Shift Planning Woorkbook - Costs Reporting

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]

Habilidades: Google Sheets, Excel, Excel VBA

Acerca do Empregador:
( 0 comentários ) Porto, Portugal

ID do Projeto: #32711978

Concedido a:

(257 Comentários)

18 freelancers estão ofertando em média €117 nesse trabalho

(455 Comentários)
(483 Comentários)
(27 Comentários)
(23 Comentários)

Hi, I see that you need some assistant in Google Sheets - Personnel Managment and Shift Planning Woorkbook - Costs Reporting I’m an experienced analyst information researcher, and science scholastic author. I have com Mais

€100 EUR in 3 dias
(7 Comentários)

"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. "

€30 EUR em 1 dia
(16 Comentários)

--------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

€100 EUR in 2 dias
(19 Comentários)
(9 Comentários)

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

€150 EUR in 4 dias
(1 Comentário)

Hello, I can accomplish all the tasks you want quickly without any mistakes. Please do not hesitate to dm me to discuss details.

€30 EUR in 2 dias
(1 Comentário)

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.

€140 EUR in 7 dias
(0 Comentários)

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.

€140 EUR in 7 dias
(0 Comentários)

I have professional experience in Excel VBA and can help in effective management of the 60 members scheduling

€140 EUR in 7 dias
(0 Comentários)

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 .

€95 EUR in 2 dias
(0 Comentários)

I'm a professional data entry expert I can complete the work within set target time frame I am a very honest person.

€100 EUR in 4 dias
(0 Comentários)

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

€100 EUR in 4 dias
(0 Comentários)

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.

€140 EUR in 7 dias
(0 Comentários)