Find Jobs
Hire Freelancers

Data manipulation using excel

$10-30 AUD

Completed
Posted over 10 years ago

$10-30 AUD

Paid on delivery
I need someone proficient in excel to take on to; 1. Merge data in 6 worksheets into 1 worksheet 2. Calculate current age based on date of birth (provided) 3. Calculate expected life expectancy based on data provided 4. Predict number of deaths based on point 2 and 3 per year. For example in 2013, based on data set we expect "x" number of deaths 5. If two people (typically male and female) live in same apartment, use details of youngest of the two 6. When a death occurs, calculate the final sale price by taking info in column i and include an annual price increase of 5%, for example,if occurs this year, final sale price = data in column i, if death occurs in 2015, then final price needs to data in column i with an annual 5% increase 7. Delete any redundant rows. For example, in the first worksheet, there are 2 entries for row 3. The redundant row is the row where there is no date of birth. All this simply means is that the unit has been sold once etc..
Project ID: 4790291

About the project

13 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Lets Start. Having a team of Professionals.
$30 AUD in 3 days
4.9 (185 reviews)
6.3
6.3
13 freelancers are bidding on average $34 AUD for this job
User Avatar
Consider it done. Check your PM for my bid details.
$50 AUD in 0 day
4.9 (321 reviews)
7.6
7.6
User Avatar
Hi John. Being highly proficient in Excel, I can get it done today. Hoping to read from you. Regards
$50 AUD in 0 day
5.0 (67 reviews)
6.7
6.7
User Avatar
Excel Specialist here.....lets do it.
$74 AUD in 1 day
4.9 (188 reviews)
6.5
6.5
User Avatar
hi, I can do this job. Please see PM.
$30 AUD in 2 days
5.0 (14 reviews)
4.4
4.4
User Avatar
John, Interesting assignment. You can have this back today, but to let you judge for yourself whether I can do it I am sending you a worksheet combining the five worksheets you attached (although you referred to six) with two columns added showing the age of the occupants Happy to work under a Confidentiality and Non-Disclosure Agreement if required, starting as soon as you pay the fee into the site. More details on Private Message Board Bob Allen-Turl
$35 AUD in 0 day
4.5 (11 reviews)
4.3
4.3
User Avatar
...LET'S START NOW....
$34 AUD in 1 day
5.0 (11 reviews)
3.7
3.7
User Avatar
I can do this for you immediately ! please check my pm :)
$30 AUD in 1 day
4.6 (1 review)
1.5
1.5
User Avatar
am very good at calculations a business student good at calculations...read ur pmb
$25 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
i have read the data and i am wiling to do it
$25 AUD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is something I can do accurately and in a short time frame.
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
With 8+ yrs of experience in Admin and Excel I can complete the task. Waiting for an opportunity to work with you.
$25 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi! Please let me help you on this.
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Lower Templestowe, Australia
5.0
19
Payment method verified
Member since Apr 26, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.