Find Jobs
Hire Freelancers

Hire an Excel Expert

R210-1750 ZAR

Completed
Posted over 6 years ago

R210-1750 ZAR

Paid on delivery
Our HR Director wants a summary of employee clocking data. He wants to see who is in shortfall of 8 hour schedule or who is in surplus of 8 hour schedule. thus shortage = negative / absentism or positve /overtime . our clocking system can export raw data to excel , but we need some formula or app that can calculate/intake this hours from excel , process and calculate an individual's hours for period X . X can be days , weeks or 6 months. Please advise. Formula or APP
Project ID: 15207563

About the project

18 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, an Excel App (VBA button). But I need to see your source Excel file. Thanks Expérience et Compétences appropriées Excel coder Étapes proposées R1088 ZAR - m
R1,088 ZAR in 1 day
4.9 (159 reviews)
7.1
7.1
18 freelancers are bidding on average R1,058 ZAR for this job
User Avatar
Expert Excel Programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-story) Relevant Skills and Experience I am an Engineering Graduate with an MBA degree. If you see I have 0 failed projects and 100% completion rate since I do not bid on projects which I am not certain of. Proposed Milestones R1578 ZAR - Please pay me once the job is 100% complete
R1,578 ZAR in 2 days
5.0 (493 reviews)
8.0
8.0
User Avatar
Greetings sir, i can help you and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have more than 5 years of experience with excellent knowledge in Data Processing, Excel. please give me a chance to work on your project Proposed Milestones R1500 ZAR - Once the project is complete
R1,500 ZAR in 3 days
4.9 (194 reviews)
7.1
7.1
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia relevante VBA/Formulas Htos propuestos R1500 ZAR - final delivery SO: Win or Mac?
R1,500 ZAR in 2 days
5.0 (172 reviews)
6.7
6.7
User Avatar
HI, I have looked at structure and can develop a macro for you to process data and show report in days, week and months. I can deliver final macro within 2-4 hours. Relevant Skills and Experience I have completed over 100 excel vba related projects here. Proposed Milestones R1000 ZAR - Project Fee
R1,000 ZAR in 1 day
4.9 (191 reviews)
6.5
6.5
User Avatar
Pleasure to help you. Excel automation is my masterpiece in my accounting field. Feel free to message me to start the job. Thank you so much. Relevant Skills and Experience Excel automation Proposed Milestones R1088 ZAR - 100% milestone and release upon completion
R1,088 ZAR in 1 day
4.8 (49 reviews)
5.0
5.0
User Avatar
I have 7 years of experience on developing model on excel and VBA. I can also favor you taking money in South Africa via Standard Bank. See my profile for client reviews. Relevant Skills and Experience Excel VBA Proposed Milestones R1220 ZAR - only Looking for your response.
R1,222 ZAR in 1 day
4.8 (20 reviews)
5.2
5.2
User Avatar
Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. As you could see on my reviews I have experience with excel and I can help you to solve your issue. Please contact me by chat and then we could discuss better your project! Luis Romero
R350 ZAR in 1 day
4.9 (55 reviews)
4.7
4.7
User Avatar
Dear I will do your project as per your requirements by applying advanced excel formulas with conditional formatting Relevant Skills and Experience Excel
R557 ZAR in 1 day
4.7 (8 reviews)
3.9
3.9
User Avatar
Hi there, my name is Victoria and I am a UK based freelancer. I have extensive admin skills and have spent the majority of my career working within the medical sector where I am used to dealing with high expectations. I am more that happy to provide you with a sample to prove the quality of my work. It would be great to chat with you further about your requirements. Have a great day. Available to start immediately
R1,944 ZAR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
i already have some predefined macros to populate this data. i can use that and complete your requirement in quick time. Relevant Skills and Experience MS Office expert (Word,Excel and PowerPoint), Software TEsting Proposed Milestones R1088 ZAR - 1 day
R1,088 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have good command over Ms excel especially pivot table, charts, Advance formulas etc. Do let me know more detail in PM Relevant Skills and Experience Ms Excel Proposed Milestones R555 ZAR - upon completion
R555 ZAR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
For the short term I could build you a excel sheet with formulas that allows you to copy and paste fresh data and select a date range and summarize the data according to your spec. Long term = App. Relevant Skills and Experience Data Analysis using SQL and Excel 10+ years Systems development and Architecture 10+ years I am South African :) Proposed Milestones R50 ZAR - Analysis R50 ZAR - Design R150 ZAR - Build R100 ZAR - Test R200 ZAR - Client sign-off Additional Services Offered R1 ZAR - Build an ETL to consume the data and provide reports and keep history Can your application export data to .csv or text? This will make initial manipulation easier.
R500 ZAR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience writing a payroll system taking time clock imports such as these. The output was a CSV file that was used for import to Microsoft Dynamics GP. Relevant Skills and Experience Wrote payroll system for manufacturer in Wisconsin, USA using time clock inputs. Excel experience in legal, social service, and manufacturing industries. Visual Basic for Applications experience. Proposed Milestones R875 ZAR - Analysis and first draft of output R875 ZAR - Testing, debugging, final draft Additional Services Offered R1500 ZAR - Database integration R1500 ZAR - VBA forms for front end Stay tuned, I'm still working on this proposal.
R1,750 ZAR in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SOUTH AFRICA
South Africa
0.0
0
Payment method verified
Member since Sep 19, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.