Find Jobs
Hire Freelancers

Automated excel task - repost1

$2 USD / hour

Cancelado
Publicado hace alrededor de 10 años

$2 USD / hour

Hi, This excercise may not even be able be possible but I am trying to prevent a very very time consuming manual task! I have a spreadsheet (attached). The sheet covers 72 people (U7:CN7) and the timeframe of 2014(Q8:Q372). Each day needs a certain demand ( Column R) and this means that column R needs an equal number of days shifts (D12) and night shifts(N12). For example 01/01/14 requires 7 made up of 7 D12 and 7 N12 etc etc throughout the year. Other criteria, each person needs to do roughly the same amount of D12 and equally the same amount of N12. So i wouldn't want to see one person doing 30 N12 and another doing 50 N12 etc. The stats panal at the top of theshift automatically how many D12 and N12 have been inputted into the sheet. Column S and T automatically counts the number of D12 and N12 shifts have been inputted into the orange cells. D12's should not be mixed in with N12 and hence a person should have a min of 2 N12 and a maximum of 2 D12 ina "block". What is filled in tab 1 should sort of explain. Also, wherever possible D12 blocks should be. followed by N12 blocks and then followed by D12 etc. Each person should have at leat 2 days off between each block of D12 or N12. Tab 2 is blank canvas. Macro maybe?
ID del proyecto: 5336259

Información sobre el proyecto

4 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
4 freelancers están ofertando un promedio de $2 USD /hora por este trabajo
Avatar del usuario
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 quality.
$2 USD en 1 día
5,0 (9 comentarios)
3,2
3,2
Avatar del usuario
A proposal has not yet been provided
$2 USD en 10 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I am qualified chartered accountant from India with more than 10 years of experience in financial planning, financial reporting & financial analysis. I have good knowledge of advanced excel. Can you please attach excel sheet in project. If you assign this project to me, I will assure you best services from my side. Thanks & Regards CA Shilpa
$2 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de INDIA
AURANGABAD, India
5,0
83
Forma de pago verificada
Miembro desde oct 24, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.