Excel Data & Pivot Table Expert Required
Project ID:
761692Project Type:
FixedBudget:
$30-$250 USD
Project Description:
Each month I download a CSV with the same headings. I then correct data with a VB program I have. This corrected data needs to be added to the master sheet on an ongoing basis so I need easy way to do that.I need to have a progressive commission calculated to each sale amount and a few other calcs for each sale.
I then need a pivot table or similar created so I can analize this data as per sales analysis sheet attached.
I need to be able to analize data in as many ways possible from the info attached.
Please submit your excel experience or your bid may not be considered.
Skills required:
Data Processing, Excel, Mathematics, StatisticsAdditional Files:
ZoneSaleAnalysis.xlsx BaseData.xlsx
Public Clarification Board
2 messages
-
nzdownunder
Hi there Murali,
Basically as per the sheets provided if you have viewed these. The only info not shown there is the number of homes per zone however this figure is in the vb sorting sheet which allocates the zones.
I am new to pivot tables but need to be able to manipilate data based on any heading field or multiples of headings and also to be able to filter by date.
Regards Kerryover 1 year ago
-
Murali668899
Hi
I have been working as an anylyst in a leading call center firm from last two years. I have extensively worked on Excel.
I need a few clarifications
1. What kind of calculations have to be done, should these calculations be done in Pivottable itself
2. What kind of analys are you looking for in the pivottable
3. Do you need a single automated Pivottable for all the analysis or multiple pivottables.
Waiting for your revert.
Regards,
Muraliover 1 year ago
Awarded Bids
$30
in 3 days
over 1 year ago
Hi. I have experience designing statistics and anlysis reports in Excel, which include:
- pivot tables to manipulate data
- advanced formulas
- automated calculations/updating as new data is entered
- automated g... more
Hi. I have experience designing statistics and anlysis reports in Excel, which include:
- pivot tables to manipulate data
- advanced formulas
- automated calculations/updating as new data is entered
- automated graphs
- linking a number of data sheets to feed into a master sheet
I can also create macro-assigned buttons that perform complex/lengthy processes or calculations.
Payment can be made upon your satisfactory completion of the project.
Time taken to complete the project is dependent on the scope, but I am generally able to spend 4-6 hours a day.
Looking forward to hearing from you.
Adam less
All Bids ()
dataconsultants
|
|
dataconsultants
From Pakistan
Gold Member
Online
|
$65
in 2 days
$65 Milestone Requested
$65 Milestone Requested
over 1 year ago
Please check PMB for details, Thank you
koolsidz
|
koolsidz
From India
Offline
|
Employer Orientation (85%, 100th percentile)
General Freelancer Orientation (90%, 98th percentile)
$55
in 1 day
$55 Milestone Requested
$55 Milestone Requested
over 1 year ago
Please See PMB
SigmaVisual
|
SigmaVisual
From Pakistan
Gold Member
Offline
|
General Freelancer Orientation (80%, 90th percentile)
Foundation EUFreelance.com Member
$225
in 5 days
over 1 year ago
We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.
Johir08
|
Johir08
From Bangladesh
Offline
|
Foundation EUFreelance.com Member
$140
in 10 days
$140 Milestone Requested
$140 Milestone Requested
over 1 year ago
Interest of your job.
dev3dworx
|
dev3dworx
From Pakistan
Gold Member
Offline
|
General Freelancer Orientation (80%, 90th percentile)
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$150
in 3 days
$150 Milestone Requested
$150 Milestone Requested
over 1 year ago
Please check PMB for details.
I have plenty of experience in Excel and have taken two university courses on the program, please check PMB
Please View the PMB
himanshuhc
|
|
himanshuhc
From India
Offline
|
General Freelancer Orientation (95%, 100th percentile)
$60
in 2 days
over 1 year ago
Please refer PMB.Requesting more details.
ready to go
ITProgramming
|
ITProgramming
From Germany
Offline
|
Freelancer Orientation (90%, 100th percentile)
Employer Orientation (80%, 99th percentile)
Foundation EUFreelance.com Member
$200
in 5 days
$100 Milestone Requested
$100 Milestone Requested
over 1 year ago
Hello! This work I do every day in my job. You can really trust me. If you choose me you will soon be satisfied.
5 days is a realistic duration, as there are often chances to do which are not clear now.
Best wish... more
Hello! This work I do every day in my job. You can really trust me. If you choose me you will soon be satisfied.
5 days is a realistic duration, as there are often chances to do which are not clear now.
Best wishes,
Christian less
hencog
|
|
hencog
From South Africa
Offline
|
SQL Level 1 (85%, 61st percentile)
$150
in 2 days
$15 Milestone Requested
$15 Milestone Requested
over 1 year ago
I have 15 years Excel and Automation/ Pivot tables experience. See PMB
anaoset
|
|
anaoset
From Serbia and Montenegro
Offline
|
Foundation EUFreelance.com Member
$30
in 7 days
$3 Milestone Requested
$3 Milestone Requested
over 1 year ago
Throughout my career I have acquired a very good knowledge with relational database concepts and query tools, knowledge and experience in Windows 2003/2008, Windows network administration, Windows 2003 Server administr... more
Throughout my career I have acquired a very good knowledge with relational database concepts and query tools, knowledge and experience in Windows 2003/2008, Windows network administration, Windows 2003 Server administration and based knowledge of SQL programming. I am expert for all works in Excel sheets
I am looking for full-time job and I prefer to work in small team. I haven't any duties that you need to attend to that may affect my work in any way and I can start with work as you need. less
jkumarcbe
|
jkumarcbe
From India
Offline
|
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$50
in 0 days
$25 Milestone Requested
$25 Milestone Requested
over 1 year ago
Please read my PM
Hi I am intersted in the job. please check the PMB.
I am capable of doing this project....Please see PMB for more details....ThanXs...
jialinlibw
|
|
jialinlibw
From United States
Offline
|
General Freelancer Orientation (80%, 90th percentile)
$40
in 3 days
$40 Milestone Requested
$40 Milestone Requested
over 1 year ago
Please check PM.
Trust me and you will get rewarded.
Hi,
Pls check PM.
Thanks.
dotnet23
|
|
dotnet23
From Philippines
Offline
|
General Freelancer Orientation (75%, 81st percentile)
Foundation LimeExchange Member
$100
in 5 days
over 1 year ago
i can do it. I have try automate excel and powerpoint. please see my blog http://louhygscs.webs.com
Mulkhan
|
|
Mulkhan
From Indonesia
Offline
|
Foundation EUFreelance.com Member
$250
in 2 days
$50 Milestone Requested
$50 Milestone Requested
over 1 year ago
Dear sir,
I am strong in Data Analysis, Excel, and VBA. I work intensively using Ms Excel two years ago and still update my skill. Thank you very much.
Best Regards
Sayed Mulkhan F
Note ########## If you are in... more
Dear sir,
I am strong in Data Analysis, Excel, and VBA. I work intensively using Ms Excel two years ago and still update my skill. Thank you very much.
Best Regards
Sayed Mulkhan F
Note ########## If you are interested, I can submit my latest work less
Jimyz
|
|
Jimyz
From United Arab Emirates
Offline
|
Freelancer Orientation (95%, 100th percentile)
Employer Orientation (90%, 100th percentile)
General Freelancer Orientation (95%, 100th percentile)
$50
in 2 days
$50 Milestone Requested
$50 Milestone Requested
over 1 year ago
Please check your inbox.