Find Jobs
Hire Freelancers

Design an XLS that will format our payroll report and track employee's time.

$30-250 USD

Concluído
Publicado há mais de 9 anos

$30-250 USD

Pago na entrega
We use 2 different databases to track and pull reports on employee's time. We also have some employees who are Salary and some who are Hourly. When we pull a report for a pay period, our hourly employee's time needs to be broken down to show true overtime (How many hours > 40 worked per WEEK, not per payperiod) and the export puts the time format as "8 hrs 34 mins", and the total shows the entire pay period. For Salary employees, we don't need the OT broken down, but we need their total time in a "88.42" format. The other database that we use only exports data as a CSV or TXT, so currently, we are copying and pasting that data for each employee, because it does break the hours out the way we need it to. So we are looking for someone to manipulate the spreadsheet so that when we export it displays the data the way we want it to, and we can quickly and easily grab the total hours to be entered in to our payroll processing website.
ID do Projeto: 6789536

Sobre o projeto

21 propostas
Projeto remoto
Ativo há 9 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
Hello, I can do this project. I did the first two sheets. Can you see it? [login to view URL] If you have any questions I will be happy to answer. If you are interested then I will be happy to do the entire project. Thank you very much Jan Krzyzak
$100 USD em 3 dias
5,0 (61 avaliações)
5,6
5,6
21 freelancers estão ofertando em média $132 USD for esse trabalho
Avatar do Usuário
Hello, I am top freelancer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
$147 USD em 2 dias
4,9 (331 avaliações)
7,7
7,7
Avatar do Usuário
Question: 1. I need to know if this report is data entry report or just interface to show analyzed results from database. And if its interface he need the database sheet to make the formulas! We can make it easier if the database taken from fingerprint or id checker by copy paste :-) Sir, Ready to work. Let me check the EXCEL, and I will make questions, if any. Ask me questions if you have any. Sincerely, Jubair eSolutions
$100 USD em 3 dias
4,9 (322 avaliações)
7,8
7,8
Avatar do Usuário
Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not disappointed anyone till date. I have done more than 130 projects. In fact, My reviews will speak for myself... One thing I can assure you that if you work with me once, you will always work with me for these kind of projects :) Hope to work with you. Regards Sid
$111 USD em 5 dias
4,9 (149 avaliações)
6,5
6,5
Avatar do Usuário
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have done lots of these kind of projects and will deliver flawless work Looking for further discussions in this regard. with thanks and regards
$144 USD em 5 dias
4,6 (98 avaliações)
6,2
6,2
Avatar do Usuário
Hello, Thank you very much for posting the job. I belong to India. I graduated from India's best university named Indian Institute of Technology (IIT). I have over 7 years of professional work experience and I have been freelancing for over 2 years. But I joined this site just a month ago. Within a month I won two of tough contests held on this site. This says a lot about the quality of my services. I have worked on lot of advance excel dash boarding and VBA coding and delivered them successfully with high quality. Few of my projects are 1) Fully automated end to end business model for 3B $ healthcare company. Scope : Global Forecast for 8 products, cost modelling, product selection and prioritization, scenario analysis 2) Training Management System for an MNC. Scope : Training calender, TL can nominate his associates to relevant trainings, sends reminders, annual training summaries etc 3) BD&L model for an MNC ; Market analysis, geography analysis, opportunity analysis, SWOT, cost benefit analysis 4) Physician segmentation and Targeting ; Physicians of Latin American were segmented in 3 tiers based on several factors, exhaustive call planning strategy was built with additional features like territory alignments, productive call frequency etc I delivered many more projects of high value and quality. I am confident that I can deliver your project with high quality. Looking forward for your response so that I can start working immediately Thanks and Regards.
$200 USD em 3 dias
4,9 (18 avaliações)
5,7
5,7
Avatar do Usuário
Hi Ok. I can do macros which will summarize data and put it in right format. ....................................................................
$80 USD em 2 dias
4,9 (60 avaliações)
5,4
5,4
Avatar do Usuário
Hi, I have Employee Time Tracker to track their work hours, Breaks daily basis. at end of day they will keep their tracker to shared folder. their will master file which you have to run daily basis. which will collect all employees data into master file. in these way you can easily track their time daily, weekly & monthly basis. For snap of time tracker please visit my portfolio https://www.freelancer.com/u/mkhrsunil.html Thanks
$250 USD em 3 dias
5,0 (11 avaliações)
4,7
4,7
Avatar do Usuário
Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can set up the exported payroll report into the format as desired. I have done US payroll reporting as well as calculators and I am aware of the overtime policy of hours over 40 per week for non-exempt employees. We can set this up as an yearly report with running totals, from where weekly totals for hourly employees can be broken off based on your current pay period. Please message me so that we can discuss and proceed further. Thanks ! Regards Dan
$166 USD em 4 dias
4,9 (10 avaliações)
4,3
4,3
Avatar do Usuário
Dear, This is a very interesting project with two clear challenges and I would be pleased to have a closer look at it with you and hopefully get the opportunity to work on it. I am an Excel/VBA expert and have completed already several similar projects, all with top reviews. The last 5 reviews I received: “ Michael is smart and professional. He has won my trust from the very begining by asking me very clear questions about what I wanted. Thanks a lot for being so professional and adaptable. Good job!” “ perfect, thank you! ” “ Did a great job! Exceeded my expectations! ” “ Excellent work yet again- really went far and beyond what was expected. Great communication and very skilled in macros/vba ” “ Fantastic job, i'd certainly use MKL7 again. He had the job already completed and ready to go even before I asked him to do the job so really takes initiative. Thank you very much. ” Good and close communication is very important to me and I believe I have the right knowledge and experience to deliver as per your requirements. Not only will I send you regular updates until completion of the file to your satisfaction, I will also remain available after completion. Don't hesitate and contact me now to discuss further details! Many thanks in advance for your consideration and best regards, Michael
$50 USD em 5 dias
5,0 (18 avaliações)
3,2
3,2
Avatar do Usuário
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.
$30 USD em 3 dias
4,8 (10 avaliações)
3,2
3,2
Avatar do Usuário
Dear Employer, Good morning, I am interested in this job as I have over 18 years of experience in the field of MS excel & VBA programming, data-entry and I am a computer savvy, goals are to make the employer/ customer happy and give better quality of work and I am ready to dedicate time for this project. Please provide the data to be processed, Thank you Kind regards
$155 USD em 15 dias
5,0 (4 avaliações)
2,6
2,6
Avatar do Usuário
Hey I really would like to work on this project, Please share the details like what will be the Input Format for this data (means we are manually updating input or importing from any file), if u can share the input file for this so it will be easy to understand the flow of data to this tracker. About output you want it to be exported to separate file or it should be included into the main file only (means where we are going to put the tracker and logic for the same).. Please confirm the details & let me know if you are ok with my proposal. Surely will give you positive response on this.
$155 USD em 3 dias
5,0 (1 avaliação)
2,3
2,3
Avatar do Usuário
Hi, I'm Mahbub (Data Entry Expert) - ready to start your project at once. I will provide you 100% success work. ''When I start any work then I never think that it is my client's work, rather I always think it is my own work'' So I work with more attentively, accuracy and honesty. You will get me available 8/7 hours. I am excellent mainly on all kinds of marketing such as: 1. Data Entry 2. Internet Marketing 3. E-mail Marketing 4. Internet Research 5. Data Scraping 6. Excel Programing 7. PDF to Word/Excel/HTML 8. SEO (Search Engine Optimization) I have sufficient experience in handling complicated projects and have proven to be successful. If considered for your project, I would put in my best and finish up with the work within the stipulated time frame. I will be also happy if you check my Feedback and reputation. Thanks. For Your Kind Visit.
$155 USD em 3 dias
5,0 (2 avaliações)
0,8
0,8
Avatar do Usuário
i will do this for you may be some one do this with low price rate but do this for in a efficient way because time saving is more impotent this is one time investment for saving money don't compromise on quality
$155 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
A proposal has not yet been provided
$155 USD em 3 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
Hi mate, I have strong experiences in writing program to extract/manipulate data from excel files, EDI files or generate excel reports from database in ERP system. I will do my best to have good review from you. What I can offer you is I will give you an Window application. You put the file in, you get another file out exactly as your requirements. If you are interest, we can discuss more. Just drop me msg to [Contact details removed by Freelancer.com Administrators for breaching the site Terms and Conditions] Regards, Duc
$75 USD em 2 dias
0,0 (0 avaliações)
0,0
0,0
Avatar do Usuário
I feel to be suitable for this role as my work experience in different company, as cost control and planning engineer i handle this kind of things a lot of time andrea
$35 USD em 3 dias
0,0 (0 avaliações)
0,4
0,4

Sobre o cliente

Bandeira do(a) UNITED STATES
Coon Rapids, United States
5,0
39
Método de pagamento verificado
Membro desde ago. 14, 2012

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.