Κλειστό

Excel Advanced Formula and/or Macro for Payroll Calculation

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

Ικανότητες: Επεξεργασία Δεδομένων, Excel, Visual Basic, Visual Basic για Εφαρμογές

Περισσότερα: if formula in excel for salary calculation, how to calculate federal income tax rate in excel, list of excel formulas with examples, excel formula if cell contains certain text then, how to calculate federal withholding tax in excel, if formula excel multiple conditions, excel formulas with examples pdf, how to calculate income tax in excel with formulas, excel formula max drawdown calculation, payroll calculation worksheet excel, excel vba paste formula macro, excel paste formula macro, excel top ten macro script visual basic, excel data fill macro, excel making formula, excel ranking formula, excel advanced user job, excel vba repeat macro times, excel lock fields macro, microsoft excel print invoice macro

Σχετικά με τον Εργοδότη:
( 1 αξιολόγηση ) Oakham, United States

Ταυτότητα Εργασίας: #16111713

36 freelancers κάνουν προσφορές κατά μέσο όρο £158 για αυτή τη δουλειά

cgullapalli

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 descriptio Περισσότερα

£100 GBP σε 1 μέρα
(772 Αξιολογήσεις)
7.8
schoudhary1553

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 experi Περισσότερα

£160 GBP σε 3 μέρες
(284 Αξιολογήσεις)
7.6
maverick44000

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 σε 2 μέρες
(88 Αξιολογήσεις)
7.0
P0L

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 σε 3 μέρες
(280 Αξιολογήσεις)
7.2
ksriniravi

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. Wherev Περισσότερα

£100 GBP σε 3 μέρες
(164 Αξιολογήσεις)
6.7
cugamelover

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 u Περισσότερα

£150 GBP σε 3 μέρες
(197 Αξιολογήσεις)
7.1
ponnarasiBabu

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 base Περισσότερα

£250 GBP σε 3 μέρες
(178 Αξιολογήσεις)
6.9
priyal1997

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 a Περισσότερα

£90 GBP σε 1 μέρα
(184 Αξιολογήσεις)
6.7
katilinas

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 σε 4 μέρες
(120 Αξιολογήσεις)
6.4
Tanmoy236

"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 Περισσότερα

£100 GBP σε 3 μέρες
(149 Αξιολογήσεις)
6.4
caabdul

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 Περισσότερα

£250 GBP σε 10 μέρες
(54 Αξιολογήσεις)
5.9
£150 GBP σε 3 μέρες
(54 Αξιολογήσεις)
6.2
diorisaguilar

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 σε 5 μέρες
(46 Αξιολογήσεις)
6.0
£150 GBP σε 3 μέρες
(65 Αξιολογήσεις)
5.7
periyannas

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 c Περισσότερα

£150 GBP σε 3 μέρες
(59 Αξιολογήσεις)
5.5
vaidyag

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 Περισσότερα

£200 GBP σε 8 μέρες
(15 Αξιολογήσεις)
5.2
hardikshah83

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 outp Περισσότερα

£150 GBP σε 3 μέρες
(27 Αξιολογήσεις)
5.5
awaisjahangir25

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 Περισσότερα

£200 GBP σε 2 μέρες
(36 Αξιολογήσεις)
5.3
katiewells3

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. Περισσότερα

£145 GBP σε 7 μέρες
(24 Αξιολογήσεις)
4.9
£150 GBP σε 3 μέρες
(15 Αξιολογήσεις)
4.9