Find Jobs
Hire Freelancers

Excel Advanced Formula and/or Macro for Payroll Calculation

£20-250 GBP

Mbyllur
Postuar about 6 years ago

£20-250 GBP

Paguhet në dorëzim
Hello, Our company is launching a new time and attendance system that will feed into our payroll software. The output from the time and attendance system gives an excel sheet with raw data. Each line consists of a shift that was worked along with a load of data associated with that shift including length and base payrate. That raw data is pulled into a consolidated shift sheet that pulls in info about the shift and about the staff member that completed that shift. We are at the point now where we need the spreadsheet to aggregate the data for payroll purposes. Typically, I'd approach this with a SUMIFS function, but that doesn't quite go as far as we need. For the import into our payroll software we need to sort and then sum/aggregate the total hours worked for different shift types paid at different rates. These shift types are WEEK, WEEKEND, OVERTIME, ENHANCED OVERTIME. Some people work 2 or 3 different positions, the output needs to identify this and place these shifts into WEEK 2, WEEKEND 2, OVERTIME 2, ENHANCED OVERTIME 2, or 3. Also, if shifts are done on certain dates (bank holidays), the system needs to identify that and allocate to the BH shift type. Once certain criteria are reached, the shift spills into overtime, and then advanced overtime. It will be much easier to explain, I imagine, with the spreadsheet actually in front of you. Not sure whether this can be achieved with simple formulas, array formulas or needs a VBA macro built out. Either way, we would like the simplest approach so we can service and tweak going forward. The excel contains some confidential info so I won't attach directly to the job - let's chat first. In your proposal, please detail how you would approach this project, and mention any similar experience you may have had before / what qualifies you. Many Thanks, Tom
ID e Projektit: 16111713

Rreth projektit

36 propozime
Projekt në distancë
Aktive 6 yrs ago

Po kërkoni të fitoni para?

Përfitimet e ofertës për Freelancer

Vendosni buxhetin dhe afatin tuaj
Paguhuni për punën tuaj
Përshkruani propozimin tuaj
Është falas të regjistrohesh dhe të bësh oferta për punë
36 freelancers are bidding on average £158 GBP for this job
Avatari i Përdoruesit
HI Tom, I am good at Excel and VBA. I have referred the description. You have got the data from a system and it needs to be processed to suit your needs. There will be several criteria as mentioned in the description. Looking forward to discussing further in the chat along with the file. It helps me to analyze better to go with simplistic approach wherever necessary. -Chandra
£100 GBP në 1 ditë
5,0 (772 përshtypje)
7,8
7,8
Avatari i Përdoruesit
Greeting, I have understood your Excel Advanced Formula and/or Macro for Payroll Calculation task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Data Processing, Excel, Visual Basic, Visual Basic for Apps
£160 GBP në 3 ditë
4,9 (284 përshtypje)
7,6
7,6
Avatari i Përdoruesit
Hello, I’m an Excel/VBA expert and I would like to help you with your project. I'm fully available and I can start right away. Please check my profile and contact me to discuss. Regards.
£150 GBP në 3 ditë
4,9 (280 përshtypje)
7,2
7,2
Avatari i Përdoruesit
Hello, I am highly skilled in Excel and VBA and can implement your required payroll within 2 days. Please share sample file and discuss details via chat. Thank you, Usman
£200 GBP në 2 ditë
5,0 (88 përshtypje)
7,0
7,0
Avatari i Përdoruesit
Dear Sir/Madam, I just went trough your project description, and I can perfectly help you to develop this dynamic excel sheet. This job can be done using few formulas and pivot tables without using any macros. I'm an expert in advanced excel skills and have already done lots of such dynamic excel models for different businesses. You can refer my profile to see my reliability and review, and if you are comfortable with all above, lets discuss the project. I assure you that I will go beyond your expectations and look forward to hearing from you Best regards Priyal
£90 GBP në 1 ditë
5,0 (184 përshtypje)
6,7
6,7
Avatari i Përdoruesit
Hi Tom, Read your specs and yes I have done lot of excel related projects, each one would be different. So i would first like to discuss the requirements and see what can be applied to achieve the results. I am based in california and we can fix a time and discuss via teamviewer or by any means that is convenient to you. so kindly open chat ponsi
£250 GBP në 3 ditë
4,9 (178 përshtypje)
6,9
6,9
Avatari i Përdoruesit
Greetings Tom! Thanks for detailed Project Description. I understand your requirements and it is my inference that developing a macro would be the most suited and straightforward approach to your requirement. Wherever possible, we can try and make the variables as configurable parameters in a configuration table in a worksheet to help with maintainability. Being a full time freelancer working exclusively on Excel based projects, I work on developing such solutions every single day. Overall I have 18 years experience in using Excel as part of my daily work life. Over the last 19 MONTHS since I took up full time Freelancing , I have spent at least 250 HOURS on automation in Excel every month. If awarded, I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Have a Great Weekend! Srinivasan Krishnamoorthi
£100 GBP në 3 ditë
5,0 (164 përshtypje)
6,7
6,7
Avatari i Përdoruesit
I've done a lot of similar work. I cannot say how exactly I'd approach this task before I see your file and data I'd have to work with. Maybe a simpler approach using formulas would suffice, maybe it won't, then I'll use VBA. If you plan to tweak or upgrade this solution in the future, then I think it's better to use VBA from the start because VBA is a very flexible tool with almost unlimited capabilities while formulas have a limited scope of applicability. You don't want a situation when you get a quick solution using formulas but then when you decide to improve it you find out that it reached its limits, so you have to scrap it and build a new VBA solution from scratch. Anyway, like I said, please let me see your data and then I'll tell you how I'd solve the problem. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
£150 GBP në 3 ditë
4,8 (197 përshtypje)
7,1
7,1
Avatari i Përdoruesit
"I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. "
£100 GBP në 3 ditë
4,9 (149 përshtypje)
6,4
6,4
Avatari i Përdoruesit
Hello. 30 % of employers hiring me once hired me again. I have 5 years experience in VBA. I CAN do this job, and do it well!
£173 GBP në 4 ditë
5,0 (120 përshtypje)
6,4
6,4
Avatari i Përdoruesit
Hidden columns can be used to run some checks to apply the SUMIFS operations, macros will be the last choice. But having the spreadsheet will give me a better idea of what you need.
£150 GBP në 5 ditë
4,9 (46 përshtypje)
6,0
6,0
Avatari i Përdoruesit
Hi there, you may feed your excel outputs in a folder and my vba tool will do the job for you. It will store data as per any given criteria and then report you for your required criteria. I am accountant and being good with numbers so this is easy for me. Thanks
£250 GBP në 10 ditë
4,9 (54 përshtypje)
5,9
5,9
Avatari i Përdoruesit
Hi Tom, Experienced programmer with more than 10 years of development experience in VBA / Excel here. We can use combination of built-in functions, custom functions and macros (only if required) to achieve the output. Let's discuss and make this project a success. This is a tentative bid, and may change post understanding exact scope.
£150 GBP në 3 ditë
4,9 (27 përshtypje)
5,5
5,5
Avatari i Përdoruesit
HI, Glad to know your requirement. I am an excel vba expert, and have delivered five vba projects in the past 25 days. I have gone through your project posting, still I have to look at the actual data sheet so that I can come up with how I am going to do it. Looking forward to working with you. Thank you. Regards
£150 GBP në 3 ditë
5,0 (59 përshtypje)
5,5
5,5
Avatari i Përdoruesit
Hi, Based on my understanding of the requirement this software needs 1) facility to configure bank holidays etc 2) Definition of various shift types linked to payrates for each employee Once this is done we need to write a macro which will take these parameters and process the raw data andn transform it so that this can be fed into the payroll system. I have worked in Infosys which is one of the top tier companny in India and we have started on our own. So we will bring our experience and quality of work to our customers. I have planned for 8 days as this work needs understanding of your requirement and complete the coding and test it. We will also provide additional support to ensure you are able to test this and accept it.
£200 GBP në 8 ditë
5,0 (15 përshtypje)
5,2
5,2
Avatari i Përdoruesit
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Power BI & Microstrategy Dashboards, MS & Google Office Suites, WordPress, Social Media Marketing and Touch Typing 60wpm Skills.
£200 GBP në 2 ditë
5,0 (24 përshtypje)
5,1
5,1
Avatari i Përdoruesit
I am an Excel Specialist. All of my projects involve data processing, process automation, web scraping using Excel VBA. I am also an Expert in creating complex formulas so I am quite confident that once I get all of your requirements then I can provide you with your desired output. Feel free to chat with me so we can discuss the details of this project.
£150 GBP në 3 ditë
4,7 (45 përshtypje)
5,0
5,0
Avatari i Përdoruesit
Dear Sir, I’ve great experience of MS Excel advance formulas and Visual Basic coding. I’ve worked on compete payroll time sheet for my clients and I am well aware of requirements. I can share a sample file with you as well. Kindly text me for further details. Thanks
£200 GBP në 2 ditë
4,5 (36 përshtypje)
5,3
5,3
Avatari i Përdoruesit
Professional Business Analyst with over 15 years commercial experience building complex business solutions utilising Excel and VBA. I am passionate about Excel and delivering clean, easy-to-use, and stable solutions. I have utlised Excel to create roster / timesheet templates for an Australian retailer which then worked with award conditions from four different states / territories to cost rosters and manage weekly staff wage %. The book managed daily and weekly overtime (with multiple overtime rates a day), bank holidays, allocating meal allowances for shifts of a certain length / time, with all rules different per state. My solution was accurate to within $0.001 of our payroll software. If you wish this to be 'tweakable' going forward I would try to avoid using macros / VBA where possible (or only for the simplest automation) as - while I would provide fully documented code - it increases the learning curve for changes. I would also specify as much as possible is data tables so the user can change values (e.g. overtime cut-offs, pay rates if applicable). In terms of my approach- do the WEEK 2, WEEKEND 2 results need to be on the same line or outputted on separate lines? I would try to stick to built-in array (eg sumifs) + simple formulae where possible, as user defined arrays are a performance killer. I would love the opportunity to work on this project and will deliver a user-friendly, stable, future-proof solution.
£145 GBP në 7 ditë
5,0 (24 përshtypje)
4,9
4,9
Avatari i Përdoruesit
Dear Hiring Manager, I am an expert in excel and have worked on various automation projects. My skills includes, but not limited to: Macros, Web Scraping, User Forms, Dashboards, Pivot Tables, Formulas, Customized Ribbon Buttons, Interaction with external applications for data exchange (Outlook, PDF, Access), etc. Based on the information provided, I would use macros to manage the calculations. Regards Chintu
£201 GBP në 3 ditë
5,0 (9 përshtypje)
4,0
4,0

Rreth klientit

Flamuri i UNITED STATES
Oakham, United States
5,0
1
Mënyra e pagesës u verifikua
Anëtar që nga maj 23, 2013

Verifikimi i klientit

Faleminderit! Ne ju kemi dërguar me email një lidhje për të kërkuar kredinë tuaj falas.
Ndodhi një gabim gjatë dërgimit të email-it tuaj. Ju lutemi provoni përsëri.
Përdorues të regjistruar Punë të postuara
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Po ngarkohet shikimi paraprak
Leja u dha për Geolocation.
Seanca e hyrjes ka skaduar dhe ke dalë. Hyr sërish.