Completed

I need a VBA expert -- 2

Case: 1: File to be used: [login to view URL]

1. Consolidate all the three sheets into a database or excel, there might be some misalignment in column names or data within, you will have to take care of that while writing your code/query

2. Prepare a dashboard to show :

a. Number of Employees under each supervisor

b. Count of employees under each level

c. Split of employees by region/country

d. Any movement in employee count by month

e. Any metrics on new or old employees

3. Please add charts or metrics based on its relevance to the dashboard

Case: 2 => File to be used: [login to view URL]

The dataset is a text file with dummy payroll data. Although this is a small datasets sample, assume that it is a big dataset and this is a manual task for the Payroll team for every month.

Taking the size and frequency into consideration please perform the below tasks on the data:

1. Read the data using any of your preferred tool

2. Clean any unwanted columns/rows

3. Map the headers and data in the dummy file to a output template as explained below:

Dummy Txt file Output Template

EE Name EMP Name

RG HRS REG Hours

RG ERN : REG Earnings

OT HRS : OT Hours

OT ERN : OT Earnings

Any HRS code (such as 'HRS 3/4 PH', 'HRS 3/4 P3', 'HRS 3/4 P5', etc) The HRS codes should be mapped to this column: Other Hours Code

Any value in the respective HRS code (such as 'HRS 3/4 PH', 'HRS 3/4 P3', 'HRS 3/4 P5', etc): Other Hours Amount

Any ERN code (such as 'ERN 3/4 N', 'ERN 3/4 PH', 'ERN 3/4 P3', etc) :

Other Earnings Code

Any value in the respective ERN code (such as 'ERN 3/4 N', 'ERN 3/4 PH', 'ERN 3/4 P3', etc):

Other Earnings Amount

4. Exclude the remaining fields in the dummy file from the Output Template

5. As a final step use the output template file to create few meaningful visualization using Excel

Skills: Excel, Visual Basic, Data Processing, Tableau, Excel VBA

See more: i have a book of names and phone numbers of hospital employees that i need entered into an excel spreadsheet, i need an expert in english language that would help to grade my essay test, i need an expert in formatting word documents in australia, i need an expert on whmcs to make a very simple job, i need an expert, i need graphic design 2, i need seo expert for my, i need seo expert, i need to have 2 advertising spot (ads) one in the right sidebar and an other in the bottom left content in each pages, i need to have 2 advertising spot ads one in the right sidebar and an other in the bottom left content in each pages, i need to hire 2 freelancer for data entry work, names and phone numbers of hospital employees that i need entered into an excel spreadsheet, urgent i need an expert on grasshopper, www i need an expert to write my speech com, how do i find an expert in excel development, i need an expert in facebook, i need an expert modeler, i need an expert to build a website, i need an expert to fix my wordpress website quotes, i need an expert to help me with facebook concerns

About the Employer:
( 0 reviews ) Mumbai, India

Project ID: #29472705

Awarded to:

surbhimanocha

I have 5 years of Excel and Data Analytics experience. Data skills come naturally to me, I have gone through the sample files that you have shared and have understood the problem well. My work style also matches your More

₹1050 INR in 3 days
(0 Reviews)
0.0

7 freelancers are bidding on average ₹1336 for this job

jaspune

Hello I have been working in Windows based development for over 2 decades. Can be a god help for the work. Look forward to hear from you Many Thanks

₹2200 INR in 7 days
(1 Review)
3.0
shankabhi

• Having 9+ years of professional experience in software development and database design. • End-to-end experience in designing and deploying data visualizations using Tableau. • Experience in creating Tables, Stored Pr More

₹1050 INR in 7 days
(0 Reviews)
0.0
mayuriprapatil

Hey , I am an expert in Excel VBA , macros , formulae and I will be able to complete the required tasks. Below is the high level proposal. Case: 1: File to be used: [login to view URL] 1. Consolidate all the three sheets int More

₹1250 INR in 2 days
(0 Reviews)
0.0
sujeethalr

My skill set is a perfect match for the job requirements. In particular, during my last job I was developing macros.

₹1500 INR in 7 days
(0 Reviews)
0.0
smaiks1

I have a wide exprience in different project, i can help you quickly. We can discuss details in skype, my nick is Juasid, and what is yours?

₹800 INR in 7 days
(0 Reviews)
0.0
TimSou1

nice to meet you ,I am working as a clerk which required using excel vba programming and Marco usually. And the demo version have been done ,would you give me a chance and check it.

₹1500 INR in 2 days
(0 Reviews)
0.0