176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Excel Spreadsheet Merging - Ongoing Formula for easy merge
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

May 22, 2012

Job awarded.

May 13, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Thu, May 10, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

Our sales company needs a simple reporting system that can be updated on a daily basis.

We currently receive a daily excel spreadsheet reporting sales and products for our customers from our product company. This excel spreadsheet updates daily with changes to completed dates, order installations, and order cancellations. We want this new data to merge with existing data to provide a complete spreadsheet/database that is fully up to date on a daily basis.

The data we want to analyze (in numerical and graphical form) from this spreadsheet includes:

- Daily/Weekly/Monthly Sales Numbers By Office
- Weekly/Monthly Sales Numbers by Sales Rep
- Office monthly rolling cancellation rate
- Sales rep monthly cancellation rate
- Sales per office by IPTV sales type - column J
- % of Sales that include "CT" - column I
- 6 month disconnect rate per rep / per office
- other data included in our current spreadsheet

We have already created a spreadsheet to start this process and have success...

Sign in or Register to see more

Job ID: 30460676
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 United States  |  
As an Electrical Engineering Student at the New Jersey Institute of Technology, I am able to provide high quality programing with excellent...
3
  |  
 5.0   |  $265 Earnings   |  1 Jobs
Bid ID: 30501651  |  Submitted: May 13, 2012 11:23 ET 
Proposal SEALED

 India  |  
I am a post graduate in Finance and an EXCEL power user with more than 7 years of experience in excel data modelling, reporting and VBA. I am...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30492194  |  Submitted: May 12, 2012 14:42 ET 
Proposal SEALED

 United States  |  
18+ years in VBA, using MS Access and MS Excel. I design robust solutions that are user-maintainable.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30490187  |  Submitted: May 12, 2012 11:50 ET 
Proposal SEALED

 India  |  
High quality service at most reasonable cost. Microsoft Excel- Top 1%, Microsoft Word- Top 5%, MS Office - Top 10%. Developed multiple complex...
8
  |  
 4.9   |  Private   |  16 Jobs
Bid ID: 30489932  |  Submitted: May 12, 2012 11:28 ET 
Proposal SEALED

 Bulgaria  |  
I'm excel professional with rich experience.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30484817  |  Submitted: May 12, 2012 03:46 ET 
Proposal SEALED

Milorad Raic      
Milorad Raic's identity has been verified.  Learn More
 Serbia  |  
I have 10 years of experience working with excel, data entry and analysis. Always trying to exceed expectations and offer clever solutions.
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30484401  |  Submitted: May 12, 2012 03:12 ET 
Proposal SEALED

John R.      
John R.'s identity has been verified.  Learn More
 United States  |  
I design smart and simple to use Excel/VBA applications.
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30482019  |  Submitted: May 11, 2012 22:29 ET 
Proposal SEALED

 Pakistan  |  
Absolute Client Satisfaction - Database applications - Systems programming - ActiveX controls - Websites
1
  |  
 0.0   |  $5 Earnings   |  2 Jobs
Bid ID: 30475452  |  Submitted: May 11, 2012 13:45 ET 
Proposal SEALED

 India  |  
Expert programmer with multiple skills... 1. Office Automation - MS Excel Expert with deep knowledge of VBA/Macros and Formulas. Extensive...
7
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 30474304  |  Submitted: May 11, 2012 12:52 ET 
Proposal SEALED

Ellen S.      
Ellen S.'s identity has been verified.  Learn More
 United States  |  
I have over 10 years of financial modeling, trading and data analysis experience both on the buy side and the sell side. As a previous Chartered...
3
  |  
 0.0   |  Private   |  0 Jobs   |  2 verified credential(s)
Bid ID: 30473552  |  Submitted: May 11, 2012 11:43 ET 
Proposal SEALED

 India  |  
Expert in Database, SQL, RDBMS, ERD Diagram and also Data Extraction,Data mining,Data warehouse analysis
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30473392  |  Submitted: May 11, 2012 11:32 ET 
Proposal SEALED

 United States  |  
I have been using MS Excel for more than 15 years. I can create pivot tables, dashboards, macro's, mail merge documents, etc. I can simple create...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 30470906  |  Submitted: May 11, 2012 09:09 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »