Find Jobs
Hire Freelancers

attendance system in excel

₹1500-12500 INR

Concluído
Publicado há mais de 4 anos

₹1500-12500 INR

Pago na entrega
I want an attendance system to be built in excel but not like traditional attendance system rather its reverse in nature i.e. I will fill number of present and absent days and it will fill P and A randomly in the month. Process flow of my work is as under:- 1. I will specify the month in sheet named 'Firm Details' 2. It should fill the calendar in the cell-range 'C5' to 'AG6' in sheet named 'Attandance' 3. It should fill 'Weekly Rest' for each employee based on 'Weekly Off' 4. I will specify Present Days , Absent Days for each employee 4B. I will Mark multiple holiday's in the month with an 'H' in a row #7 5. You will click a button titled 'calculate attendance' . It will execute an algorithm in a VBA-macro and perform following steps for every employee:- 5A. Mark as 'R' for every weekly-off 5B. Mark as 'H' for every 'Holiday' date(if holidays is on weekly off then it should be holiday) 5C. Randomly mark as many 'A' as are specified in 'Absent Days' (Exclude cells marked in 5A and 5B above) 5D. Mark as many cells as 'P' as specified in 'Present Days' (Exclude cells marked in 5A ,5B and 5C above) 5E. Highlight employee in RED if sufficient cells not found for 'P' in '5D' above (reason: error in data entry) 5F. Highlight employees in RED if any cell of the month is left blank. (reason: error in data entry) Handle half-days (like 21.5), as 21 ‘P’ and 1 ‘P/2’ randomly as specified in step #5 No limit on number of employees
ID do Projeto: 20523003

Sobre o projeto

5 propostas
Projeto remoto
Ativo há 5 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
Hi, My name is Alessio. I am experienced Data Analyst and Macro/Acces Developer. I have done similar jobs . I have read your instructions carefully. I have excellent knowledge and experience of creating User Form, Command Button, Drop Down, Radio Buttons, List Boxes etc. in excel VBA. o, can do this job nicely. I carefully read his requirements and I am clear, I can start working on this project right away. Ready to start, please message me to discuss your project in more details. Thanks, Alessio
₹1.500 INR em 5 dias
5,0 (2 avaliações)
1,8
1,8
5 freelancers estão ofertando em média ₹4.300 INR for esse trabalho
Avatar do Usuário
Hello I am A Full Time Freelancer , I read you project description entry data in excel will be too easy to me. I am Very Fast Speed Writing Text i have more than 5 years experience in MS Word , MS Excel - Accuracy 100% i will help you a lot in your project in very fast time . if you accept i will start work now Thank you for understanding.
₹1.500 INR em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am a Chartered Accountant from India based in New Delhi. I got an experience of more than 7 years both in research and in corporate world. I have done financial accounting, auditing, tax planning, legal research , agreement vetting, financial analysis, transfer pricing and market research for various MNC including Zara, Louis Vuitton and McDonald's etc. I believe in professional excellence , accuracy and relation building. I can also help in business development and further growth.
₹1.500 INR em 1 dia
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I am an experienced person in this field. So, I can deliver your work within the required time. Also I am totally free now a days.
₹10.000 INR em 5 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I have read and have seen what the job entails. my qualifications: I am a web application developer, and i have studied Applied Computer Technology. So I´m a programmer and therefore fast typing is my perk. I am also very well skilled in office applications like microsoft excell,Microsoft word, and powerpoint. I also specialise in writing reports and short essays I beleive I am going to do a great job. Hope to hear from you.
₹7.000 INR em 7 dias
0,0 (0 avaliações)
0,0
0,0

Sobre o cliente

Bandeira do(a) INDIA
Varanasi, India
5,0
1
Membro desde jul. 27, 2019

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos 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)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.