In Progress

Data Manipulation in Excel

I have a very simple job of data transformation. Master Data file in Excel contains all data. From this, you need to create 2 separate transformations into First Job Data and Second Job Data as described in the Job Description:

All data is contained in the Master Data file.

From this data, you should create 2 separate files. Each of these files will have a transformation of the Master Data.

The Master Data has 4 excel worksheets numbered by years -2007, 2006, 2005 and 2004. Each worksheet contains one year of data for several hundred internet companies. However, the number of companies is different in each year. For example, 2007 (latest year) and 2006 has data on 500 companies, one in each row. But 2005 has data on 400 companies while 2004 has only data for 300 companies. This means that the latest year (2007) contains data on companies not listed in the 2004 worksheet. Therefore between worksheets, some companies are common and some are unique.

Each worksheet has the same number of variables.

FIRST JOB

1. Start with the latest year 2007. Create 4 rows for each company where each row indicates a specific year – 2003, 2004, 2005 and 2006 (see Sample First Job Data).

2. Then go to previous year’s worksheets and match the company name, and fill the data for each variable (that is, each column) for each of the years for this company. So, for example, [url removed, login to view] had sales of $10,710,000,000.00 in 2006, in 2005 it was $8,490,000,000.00, in 2004 it was $6,921,124,000.00, and so on.

3. Do this for each variable or column.

4. Leave blank for missing data.

SECOND JOB

1. Start with the latest year 2007.

2. Create 4 years for each variable – each year in one column. For example, 2006 Sales, 2005 Sales, 2004 Sales, 2003 Sales. Go to other worksheets and fill these numbers (see Sample Second Job Data).

3. Then create 3 columns of DIFFERENCES. For example, Sales Difference 2006-2005, Sales Difference 2005-2004, Sales Difference 2004-2003.

4. Then go to other worksheets and match the company name.

5. Fill them is as follows: Subtract 2005 data from 2006 data for the variable Sales Difference 2006-2005; Subtract 2004 data from 2005 data for the variable Sales Difference 2005-2004; and so on.

6. Leave blank for missing data.

This is a very straightforward job. I can pay only $50.

Do NOT bid if you want more than $50.

Skills: Data Processing

See more: data manipulation excel, excel data manipulation job description, processing of data, pay data, excel &, data processing job description, data processing com, data job description, data 3, excel data manipulation sigma, excel assignment data manipulation, n excel, amazon.com job, master excel, data processing companies, sales excel, need sales data, master data, manipulation, fill in excel, fill data, excel\ , excel, excel job, excel c#

About the Employer:
( 15 reviews ) Norman, United States

Project ID: #233990

Awarded to:

arvindtechno

Hello, Please check PM for my sample file. Thank you

$50 USD in 2 days
(52 Reviews)
5.5

52 freelancers are bidding on average $46 for this job

$40 USD in 0 days
(70 Reviews)
6.1
weblazer

Good day im very interested to do this project PM sent. Thank you

$45 USD in 2 days
(21 Reviews)
5.7
svet63

VBA developer since 1997. Can do. Regards, Svet.

$45 USD in 1 day
(18 Reviews)
5.6
fastwork

Hi, Please check pmb for further details.. Thanks.. Shakeel...

$50 USD in 2 days
(7 Reviews)
5.4
best4best

Please see PMB.

$40 USD in 1 day
(23 Reviews)
4.1
wsh2

Greetings Florida from the "Keystone State" of Pennsylvania.. {smile} Report creation and data transformations are a specialty of mine. Hello my name is Bill.. I am a MsExcel, MsAccess, VB.Net, VB6, VBA, VBSc More

$49.95 USD in 1 day
(5 Reviews)
3.6
RainbowSearches

I can do this for you.

$50 USD in 2 days
(3 Reviews)
3.4
iasmumbai

Take advantage of my strong and proven data parsing and entry skills. Combine this with prompt communication, a friendly manner and an adherence to job descriptions and deadlines, and you have the perfect candidate for More

$32 USD in 2 days
(7 Reviews)
3.4
sureshiyengar

Quality assured

$40 USD in 1 day
(4 Reviews)
3.0
FenchakV

It's a matter of couple of hours job. Can do it this afternoon.

$30 USD in 0 days
(1 Review)
2.6
ijmg

I can do it let's get started.

$35 USD in 1 day
(1 Review)
2.4
TMG

Would be happy to work with you on this.. Should be quite easy with no payment gaurantee if you find any error. We would use appropriate excel tools to produce desired output sheets from the master data file which you More

$40 USD in 1 day
(1 Review)
2.5
freelancercms

hi, we can do , let's start. best regards. srinivas.

$80 USD in 1 day
(2 Reviews)
2.0
tindz99

please see pm for details

$35 USD in 3 days
(2 Reviews)
1.8
khalid1352

Hi, Check PM Please.

$40 USD in 2 days
(1 Review)
1.8
vnb400

kindly refer PMB, Thanks

$35 USD in 3 days
(2 Reviews)
1.6
carlestops

Hello if it's purely excel... I am your provider. See pm.

$50 USD in 4 days
(0 Reviews)
0.0
deesteen

Hello, please refer to my profile as I have extensive computer experience and knowledge covering a 20 year time span. Hard work, persistence, dedication and accuracy are personal traits that I offer, as well, to get an More

$40 USD in 2 days
(0 Reviews)
0.0
nicoLesmana

i can do it in 5 hour sir. so please PM me. thanks

$35 USD in 1 day
(0 Reviews)
0.0
veeksha

Hi, Yes, quite straightforward job. Thanks for your consideration. Veeksha.

$50 USD in 1 day
(0 Reviews)
0.0