176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Data processing tasks using excel + report
Sign in to Add to Watch List

Finance & Management > Other - Finance & Mgmt

View Change History

The client has made the following changes to the job.

Description
Date

Job canceled.

Apr 16, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Apr 11, 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: $100 - $200
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Looking for someone who is good in Excel and business analysis.

You will be doing record keeping/data analysis for a small hotel/cottage. You will be given data sample of 50 customers to work with, to show that the spreadsheet works as intended

Part 1: Design a simple spreadsheet model for the revenue of the business - Input, Processing Output

Part 2: Implement the Spreadsheet Model
Using your IPO chart as a guide, create a workbook, containing separate worksheets for reference data, (cottages, costs and booking details) calculationsand a summary. Create a menu to navigate the workbook.
The first calculation should contain the following:
Columns to record the following transaction details: Booking number,Days booked, Cottage name, Nightly rate, Total standard rate, Number of days at discounted rate (if any), Total discount, Total revenue
Dynamic Linking for the transfer of data from the input sheet to the processing sheet
Calculations for the nightly rate (vlookup formula)...

Sign in or Register to see more

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

Tanuja Rao A.      
Tanuja Rao A.'s identity has been verified.  Learn More
 Canada  |  
I enjoy working on Microsoft Excel and Access projects. I have been ranked among the first 1% of the Excel Experts in Elance. I am a result...
3
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29904351  |  Submitted: Apr 15, 2012 15:27 ET 
Proposal SEALED

Sohail Akhtar      
Sohail Akhtar's identity has been verified.  Learn More
 Pakistan  |  
- Excel,word,Powerpoint-2010 - PDF to Excel,Word,Powerpoint,Image,htlm conversion. - Converting Scanned files to Word Document - Data Entry...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29901868  |  Submitted: Apr 15, 2012 11:55 ET 
Proposal SEALED

 United States  |  
12+ years experience in executive management, data analysis, forecasting, data modeling, strategic planning, finance, operations, business plan...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29876740  |  Submitted: Apr 13, 2012 13:17 ET 
Proposal SEALED

Muhammad javed Iqbal      
Muhammad javed Iqbal's identity has been verified.  Learn More
 Pakistan  |  
ACCA, APA and M.com Finance, More than 7 years of experience in investment bank as financial analyst and internal auditor
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29855163  |  Submitted: Apr 12, 2012 13:49 ET 
Proposal SEALED

 Pakistan  |  
We have professional translator, editor and writer with 20 years of experience ready to deliver quality work at an affordable rate. Creativity,...
1
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29839079  |  Submitted: Apr 11, 2012 21:29 ET 
Proposal SEALED

 Pakistan  |  
I m a Chartered Accountant (Finalist) serving the profession since last 3 years, through quality and commitment. currently working with HLBi...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29830751  |  Submitted: Apr 11, 2012 12:39 ET 
Proposal SEALED

 India  |  
Ranked among the top 1% writers, worked in the field of academics as well as industry. Good at academic writing, proof reading, editing as well as...
5
  |  
 5.0   |  Private   |  4 Jobs
Bid ID: 29827039  |  Submitted: Apr 11, 2012 09:33 ET 
Proposal SEALED

 Australia  |  
I Currently work in Strategy, Mergers and Acquisitions at MIrvac ($4 billion Australian property group). I am a Chartered Accountant and have a...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29826671  |  Submitted: Apr 11, 2012 09:13 ET 
Proposal SEALED

Rodney L.      
Rodney L.'s identity has been verified.  Learn More
 United States  |  
My name is Rodney Lynch, and as principal of Media Financial Consulting I have a passion for what I do: taking incoherent mountains of data and...
10
  |  
 5.0   |  Private   |  24 Jobs   |  2 verified credential(s)
Bid ID: 29826623  |  Submitted: Apr 11, 2012 09:10 ET 
Proposal SEALED

 India  |  
I have over 8 years experience as an accountant and teacher. I am proficient in managing books and accounts of a small to medium size business...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29824768  |  Submitted: Apr 11, 2012 07:36 ET 
Proposal SEALED

 Pakistan  |  
ATAASC About the Company ATAASC We are experts in Bookkeeping, Financial Management,budgeting and forecasting and also in preparation and filing...
2
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29823435  |  Submitted: Apr 11, 2012 06:25 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 »