Find Jobs
Hire Freelancers

custom excel report

$30-250 USD

Cerrado
Publicado hace alrededor de 9 años

$30-250 USD

Pagado a la entrega
I need to have a report made using the file attached. I can not change the layout of the outputted file from our Pyramid TimeTrax attendance software, so I need the attached file queried or reorganized programmatically on a regular basis. I need to generate a report for each employee that shows their 1. average arrival time in the morning 2. average time they leave for lunch 3. the average duration of their lunch 4. the average departure at end of day The numbers of employees will change along with names, as people are hired on or leave, so it needs to be flexible. I can work with excel or ms access 2010 for this, but prefer it to all be excel based if possible. This needs to be something that I can do each week, very quickly and easily, so I will need its function detailed so I can reproduce consistent results.
ID del proyecto: 7085300

Información sobre el proyecto

40 propuestas
Proyecto remoto
Activo hace 9 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
40 freelancers están ofertando un promedio de $100 USD por este trabajo
Avatar del usuario
Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your project by creating a draft spreadsheet and send it to you for review. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, as well as feedback, take a look at my Freelancer Portfolio (https://www.freelancer.com/u/paris2785.html).
$44 USD en 7 días
5,0 (642 comentarios)
8,7
8,7
Avatar del usuario
Hi, I am good at excel and macros... I can create vba. Please see my experience list in the freelancer. I will create vba to meet your requirement with all the conditions satisfied. Looking forward for your reply to start the work on immediately.
$65 USD en 2 días
5,0 (1212 comentarios)
8,4
8,4
Avatar del usuario
Hello! I'm an Excel expert and I would like to help your report. Please check my profile and contact me to discuss further details. Regards.
$100 USD en 1 día
5,0 (491 comentarios)
8,0
8,0
Avatar del usuario
Dear Sir, I ensure you of completing the project within the specified time. I have a previous experience of Data Modification work in Excel using Macro. Besides I am an Electrical Engineer and currently working in a reputed Power Plant in India. Data Integration and Compilation is my prime job over there. Making reports in Excel and Powerpoint is my routine job, which gives me an edge to carry out the project. I am a new Freelancer so I have the earnest desire to carry out the project successfully. So please consider my proposal and give me a chance to boom in the market of Freelancer. Kindly contact me for further details. Thanks and Regards Tonmoy Roy Electrical Engineer
$30 USD en 3 días
5,0 (496 comentarios)
7,7
7,7
Avatar del usuario
A proposal has not yet been provided
$250 USD en 2 días
4,9 (330 comentarios)
7,7
7,7
Avatar del usuario
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards
$100 USD en 3 días
5,0 (326 comentarios)
7,4
7,4
Avatar del usuario
Dear, I am Access/Excel expert since 11 years. I checked your project description, and I confirm I can develop your Excel reports. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$121 USD en 3 días
4,7 (91 comentarios)
7,4
7,4
Avatar del usuario
Hey, I reviewed the spreadsheet you shared and kind of understand what you are looking for. This seems to be the output of an access control system from which you need to do some analytics and give person level metrics. I think the best way to do this is to write some macros that will take this file as an input, analyze the complete data and present the results on say a 'report' sheet. I can certainly write such a macro. I do have a few questions like for example, I noticed that all the time stamps show only "Out" while "In" is blank throughout the spreadsheet. So, how do we calculate the duration? If you could answer these questions based on your current manual process, I would be able to automate it for you. Once automated, this process could be as simple as clicking a button and getting the results. Does this sound exciting? Do let me know. I am an expert in Excel with more than 400 projects delivered successfully (as you would see in my work history here on freelancer) and can assure you of excellent and accurate work. Look forward to hear from you. Thanks and Regards, Shikha
$277 USD en 5 días
4,9 (101 comentarios)
6,6
6,6
Avatar del usuario
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 220 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$100 USD en 5 días
4,9 (120 comentarios)
6,3
6,3
Avatar del usuario
Hi there....I had a look at the attached excel sheet(6189 rows)...we can generate the reports that you have mentioned (number of employees does not matter)....Please reply...we can discuss further and get this started...thank you...
$64 USD en 2 días
4,8 (168 comentarios)
6,0
6,0
Avatar del usuario
Hi, Approach: I completed similar project for another client. Please have a look at project details and feedback: https://www.freelancer.com/projects/Excel/some-Excel-Work.6649364.html My background: I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on designing, implementing and analyzing ACBC (conjoint) surveys, pricing models, income statements, business analysis etc. Prior that I have completed MBA and bachelors in Engineering. I have worked extensively on excel and VBA in my job and here on freelancer as well. I believe I can help in your work. Please have a look at reviews provided by previous employers. Please contact for further discussion. Regards! Vikas
$122 USD en 3 días
4,9 (38 comentarios)
5,6
5,6
Avatar del usuario
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.
$100 USD en 2 días
4,9 (22 comentarios)
5,8
5,8
Avatar del usuario
Hi! excel automation is my masterpiece in my accounting field. It is my pleasure to help your project. Feel free to message me and to start the project after your reward my bid. Thank you.
$60 USD en 1 día
4,9 (73 comentarios)
5,7
5,7
Avatar del usuario
I have downloaded the attached sheet, i have few questions. I guess we can use VBA programming to achieve the task. 1-average arrival time in the morning The time card are of different dates and of different employees, do you want average arrival time by employee or complete average time of all employees. 2- Will the format of excel sheet remain the same ? Looking forward to clarify more via chat
$130 USD en 7 días
4,8 (43 comentarios)
5,4
5,4
Avatar del usuario
Hi, I am working as software professional in IT industry from last 4 years. I work on VB scripting along with VBA for MS office applications. Also developed various Desktop based application using Visual Studio in VB and C# I have done projects related to VBA and VB in past. I am currently going through all the attachments to have a clear view. If you like my proposal,lets start. Thanks Abhinov
$100 USD en 3 días
4,9 (44 comentarios)
5,2
5,2
Avatar del usuario
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
$98 USD en 5 días
4,6 (45 comentarios)
5,6
5,6
Avatar del usuario
Hi, My name is Dan. I am an expert in excel and all advanced functionalities. I can do this report for each employee and kind of create a template where you can feed the raw output from Time Trax software and the it will give the results automatically on another sheet (one row per employee). Please message me so that we can proceed further. Thanks ! Regards Dan
$111 USD en 3 días
4,9 (10 comentarios)
4,3
4,3
Avatar del usuario
Hi, Your project sounds very interesting and simple enough and I believe that I'll be able to perform the task perfectly. As for my experience, you can see for yourself that I've worked here mainly as a content and article writer; but, I've also done some VA work, which included a lot of both Excel and MS Word work as well as some Acess and VBS tinkering. You're welcome to check my reviews and should you have any questions, I'll be happy to answer. Kindest regards. Milan
$105 USD en 3 días
5,0 (20 comentarios)
4,1
4,1
Avatar del usuario
I have the required expertise for your project. Check my portfolio and reviews, my works have quality and warranty.
$111 USD en 5 días
4,8 (11 comentarios)
3,7
3,7
Avatar del usuario
Dear Sir, I've done similar excel report before and can work on your project immediately. Regards,
$185 USD en 7 días
5,0 (1 comentario)
1,2
1,2

Sobre este cliente

Bandera de UNITED STATES
Jackson, United States
5,0
16
Forma de pago verificada
Miembro desde jul 21, 2012

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.