176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Create Transaction Data in Excel
Sign in to Add to Watch List

Finance & Management > Management Consulting

View Change History

The client has made the following changes to the job.

Description
Date

Job canceled.

Sep 18, 2012

Job opened to all freelancers. Previously: Invite only

Aug 20, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Fri, Aug 17, 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
  • Hourly Rate: $10 - $15 / hr
  • Hrs/wk: Not Sure | Duration: 5 hrs
  • Work View™ Payment Protection
  • W9 Not Required
Sign in to view client's details

I need 3 years of transaction data.

The main sheet there will be 100 customers with the cells that hold
1.First Name
2.Last Name
3.Total Spend ($ purchase amount ranging from $100- $250,000)
4.Frequency (# of reservations)
5.Recency (day of last visit)
6.Average Spend

One the second sheet the cells will hold their respective transaction data.
the data must match from the first to second sheet. i.e

Customer Mike Smith total spend is $18,000 and has 7 reservations with the last reservation a month ago.

His transaction record should indicate 7 transactions all totaling $18,000 with the last transaction be the one that brings the total to $18,000.

We are building an RFM model and need 3 years of transaction data to get a good probability model.

This needs to be submitted as one excel file with the two sheets within them.

Sign in or Register to see more

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

 United States  |  
I am in my last semester as a Finance student at the University of Central Florida. I work very well with organization of financials and numbers as...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33168770  |  Submitted: Aug 31, 2012 12:15 ET 
Proposal SEALED

 India  |  
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33155201  |  Submitted: Aug 31, 2012 00:48 ET 
Proposal SEALED

 Romania  |  
Highly experienced data analyst in the Telco and online payments. If you require both quantitative and qualitative analysis and reporting skills...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33136663  |  Submitted: Aug 30, 2012 08:32 ET 
Proposal SEALED

 United States  |  
MBA from a top US University with over 6 years' corporate experience and with a track record of work in Strategy, Analytics and Operations...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33126622  |  Submitted: Aug 30, 2012 00:25 ET 
Proposal SEALED

 United States  |  
Over 10 years experience in the Financial Services and Real Estate Industries. Specializing in Restricted Stock, Venture Capital Distributions and...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33115819  |  Submitted: Aug 29, 2012 14:01 ET 
Proposal SEALED

 India  |  
Expert in Financial Modelling , MS-excel & Making Quality Business Plans
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33070009  |  Submitted: Aug 28, 2012 04:59 ET 
Proposal SEALED

 Kenya  |  
Accounting, bookkeeping and finance is my profession, passion and vocation. I want to share my full capabilities to the absolute fullest.
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 33038688  |  Submitted: Aug 27, 2012 05:55 ET 
Proposal SEALED

 India  |  
I am commerce graduate with a working experience of more than 2 and a half years with Ernst and Young in audit profile.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 33031008  |  Submitted: Aug 26, 2012 23:42 ET 
Proposal SEALED

 Singapore  |  
Had five year of accounting experience. Currently undertaking CPA program and an expert in Mircosoft Excel, which include designing of input...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32956135  |  Submitted: Aug 23, 2012 11:23 ET 
Proposal SEALED

 Gambia  |  
AAT Technician I am a hardworking, reliable, trustworthy individual with a lot of energy and enthusiastic passion for Accounting. i have five (10)...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32949947  |  Submitted: Aug 23, 2012 07:02 ET 
Proposal SEALED

Saqib I.      
Saqib I.'s identity has been verified.  Learn More
 Pakistan  |  
I am a Chartered Accountant from Institute of Chartered Accountants of Pakistan and having a rich experience with Deloitte, one of big four...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 32946284  |  Submitted: Aug 23, 2012 04:03 ET 
Proposal SEALED

Chris S.      
Chris S.'s identity has been verified.  Learn More
 United States  |  
My name is Chris Scheu and as the owner of Scheu Consulting Company, I have a passion in providing businesses and organizations critical analysis...
1
  |  
 0.0   |  Private   |  0 Jobs   |  2 verified credential(s)
Bid ID: 32927567  |  Submitted: Aug 22, 2012 11:59 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 »