Project Detail

Data Manipulation in Excel  

Data Manipulation in Excel is project number 233990
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: arvindtechno

Budget: $30-250

Created: 03/05/2008 at 22:31 EST

Bid Count: 53

Average Bid:
$ 46

03/12/2008 at 22:31 EDT

Project Creator: sumanbasuroy
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (11 reviews)

Bid On This Project
 

Description

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, amazon.com 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.


Additional files submitted:
Job Description.doc
Master Data 4 Years.xls
Sample First Job Data.xls
Sample Second Job Data.xls

Messages Posted:2 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

40

0 days

03-06-2008 03:02 EST

help

 

50

2 days

03-06-2008 07:27 EST

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

help

 

40

2 days

03-05-2008 22:56 EST

will do it.

help

 

45

1 day

03-06-2008 04:08 EST

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

help

 

45

2 days

03-06-2008 07:54 EST

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

help

 

40

1 day

03-05-2008 23:47 EST

Please see PMB.

help

 

49.95

1 day

03-06-2008 09:49 EST

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, VBScript, SQL, and Windows programming Expert, Leader and Mentor [screenname:wsh2] at www.vbcity.com and www.experts-exchange.com. I have successfully completed quite a few GAF projects, so you can find additional references for me here: http://elance.com/users/feedback_172391.html I have 20+ years of hands-on Programming and Business Information System experience to include Internet interfacing applications. I have a BS in Accounting / Marketing Minor; graduating with the highest of honors. I am located in Easton PA USA (halfway between Philadelphia and New York City). American english is my only language. I look forward to assisting you in achieving ALL of your goals in your every endeavor. Respectfully, Bill.

help

 

40

1 day

03-06-2008 11:46 EST

Quality assured

help

 

35

3 days

03-06-2008 01:52 EST

kindly refer PMB, Thanks

help

 

35

3 days

03-06-2008 12:11 EST

please see pm for details

help

 

50

2 days

03-06-2008 04:53 EST

I can do this for you.

help

 

32

2 days

03-06-2008 06:36 EST

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 your project. Check out Private Message Board for more details. Regards, Sharvan.

help

TMG

 

40

1 day

03-06-2008 09:21 EST

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 submitted. We are confident of delighting you on this. Hope to enter into a long term relationship. Thanks, TMG

help

 

40

2 days

03-06-2008 04:24 EST

Hi, Check PM Please.

help

 

50

2 days

03-06-2008 11:10 EST

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

help

 

80

1 day

03-05-2008 23:54 EST

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

help

 

50

1 day

03-06-2008 00:16 EST

Hi, sumanbasuroy. I can do this project for you. Kindly check PMB for more info. Thanks. Lyza

help

 

30

1 day

03-06-2008 12:04 EST

Hi. I'm a Canadian programmer-analyst specializing in MS Office VBA solutions. I can definitly do this job for you. Payments through GAF's escrow service. Project period starts when money is in escrow and PM is sent to you acknowledging the fact. Thank you.

help

 

30

1 day

03-06-2008 00:51 EST

Hello sir, Please check PMB.. Thank you..

help

 

30

0 days

03-06-2008 03:30 EST

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

help

 

40

2 days

03-06-2008 04:09 EST

I can start on this immediately and complete it in 2 days. Thank you for the opportunity.

help

 

35

1 day

03-06-2008 04:35 EST

I can do it let's get started.

help

 

50

4 days

03-06-2008 09:43 EST

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

help

 

50

1 day

03-05-2008 22:40 EST

(No Feedback Yet)

check the PM.

help

 

30

2 days

03-05-2008 23:45 EST

(No Feedback Yet)

we are team of 4 and are ready to work on it asap ....

help

 

30

1 day

03-05-2008 23:46 EST

(No Feedback Yet)

Hello Please see PM. Thank You.

help

 

50

2 days

03-06-2008 00:12 EST

(No Feedback Yet)

I can do this for you.

help

 

50

1 day

03-06-2008 01:01 EST

(No Feedback Yet)

Simple, let us start!

help

 

45

2 days

03-06-2008 01:35 EST

(No Feedback Yet)

Hi, We are web development and Data Entry experts. We are experienced professional in this field and would be able to provide the required result to ensure this project is completed with high quality and timely results. We would be pleased to offer my services for your data entry work. We have a background in computer engineering and web development experience so we are confident and we would be able to quickly and accurately incorporate your data. Kindly check PMB for more info. Looking forward to build a long and mutually profitable corporate relationship. Regards, Visual Thinkers

help

 

30

2 days

03-06-2008 02:29 EST

(No Feedback Yet)

We can make you project.........

help

 

30

1 day

03-06-2008 02:34 EST

(No Feedback Yet)

Looking forward. Thanks & Regards.

help

 

30

1 day

03-06-2008 02:59 EST

(No Feedback Yet)

hi i am experienced in this field.your job will be done properly.

help

 

30

1 day

03-06-2008 04:42 EST

(No Feedback Yet)

I can handle this project and after getting this project I finshed that on the same day

help

 

30

1 day

03-06-2008 04:51 EST

(No Feedback Yet)

I have 7 years experience in Excel.

help

 

200

7 days

03-06-2008 05:16 EST

(No Feedback Yet)

Hi, I was Excel instructor during my graduation period. Now i am fully involved with data entry job and i have part time office with dedicated broadband service. outputs will be completely professional. Thank you.

help

 

40

1 day

03-06-2008 05:32 EST

(No Feedback Yet)

Hi, i'm interested in your job. Please check pm.

help

 

40

1 day

03-06-2008 06:04 EST

(No Feedback Yet)

Dear Sir, We have gone thro' your project and we have completed your First Job and attached (ref. our PM for attachment) for your reference. Like this we can do second job on comfirmation of our bidding. If you are interested to give the job to us, we have some queries to be clarified. Please review the first job and give your concurrence for the second job. For further details pl refer our pm. regards Hexagon

help

 

35

3 days

03-06-2008 07:42 EST

(No Feedback Yet)

Hi, We have been doing this kind of job & can do it for you as well, given a chance. Regards, PNL

help

 

150

4 days

03-06-2008 07:59 EST

(No Feedback Yet)

I will turn in 100% accurate work. Please select my bid

help

 

50

2 days

03-06-2008 08:20 EST

(No Feedback Yet)

I AM A FINANCE PROFESSIONAL VERY GOOD AND QUICK AT EXCEL I HOPE MY BID IS APPROVED

help

 

30

1 day

03-06-2008 08:29 EST

(No Feedback Yet)

Sir I agree and do the job Thanks Velaytuham

help

 

50

30 days

03-06-2008 08:45 EST

(No Feedback Yet)

I have got expertisation in Excell as a i often delas with Bank Auditing. I can do the job to nad also can meet your requirement. Rate offered is bit low. How ever concentrating on your condition of payment i have submitted bid for the project. KM Brahma

help

 

50

1 day

03-06-2008 09:03 EST

(No Feedback Yet)

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

help

 

40

2 days

03-06-2008 09:15 EST

(No Feedback Yet)

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 any job done in an efficient and timely manner. Thank you for any consideration, as I am very much interested in your project.

help

 

35

1 day

03-06-2008 11:00 EST

(No Feedback Yet)

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

help

 

30

2 days

03-06-2008 11:20 EST

(No Feedback Yet)

I have a team of very good data entry operators with me with high focus on quality of the work delivered. Our quality processes are equal to that of 6-sigma. Looking forward to work with you.thanx.:)

help

 

50

1 day

03-06-2008 11:23 EST

(No Feedback Yet)

Hi i am interested in your job. see the PMB please !

help

 

50

3 days

03-06-2008 11:34 EST

(No Feedback Yet)

Please check PM for details.

help

 

45

2 days

03-06-2008 12:02 EST

(No Feedback Yet)

Hello, Hope you are doing fine, Let me know how can we start... Thanks & Regards Shashank

help

 

50

2 days

03-06-2008 12:16 EST

(No Feedback Yet)

Dear Sir, In relation to your invitation to bid for the above-mentioned subject and in strict compliance to the instructions stipulated in the tender documents, I hereby submit my offer for your kind attention and consideration. I trust my offer meet all your strict requirements and I look forward to a lasting business relationship with you. Thank you with kindest regards. Sreejit369

help

 

45

1 day

03-06-2008 12:31 EST

(No Feedback Yet)

hi there this is Ajay from India. I wanted to do this work for you. And I m interested in long run work relationship & money is not a big deal for me and this will be negotiable, according to our requirements. I have a internet connection which is sufficient to do this type of work. So, if u r interested & wanted to work with me. plz feel free to mail & we have very good work relationship for long time. Bye

help

 

30

2 days

03-06-2008 13:36 EST

(No Feedback Yet)

Hi, you want the best, here I am. I promise to complete your assignment on time and to the expected standard. Hope to hear from you soon.

help

 

30

0 days

03-06-2008 15:38 EST

(No Feedback Yet)

I have a hunderd years using computers. I also have me a Ph.D. and I speak 12 rural dialects of Arkansan fluidly.

help


    Bid on this Project