Project Detail

Need Excel EXPERT

Need Excel EXPERT is project number 445582
posted at Freelancer.com. Click here to post your own project.

| More

Status:

Selected Providers: northwolves

Budget: $30-250

Created: 06/03/2009 at 18:16 EDT

Bid Count: 30

Average Bid:
$ 47

06/09/2009 at 18:16 EDT

Project Creator: minhpho offline
Employer Rating: 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 (9 reviews)

Description

I get data weekly that I need to reformat and have computations run on. The file "raw data.xls" is how I get the data. The file "final results.xls" is how the end result should be.

Formatting and computations that need to be done:
1) Sort by K (WC Code on final results)
2) Sort by A (Company on final results)
3) Compare line by line the values of A AND K
4) If multiple lines have the same A AND K values then combine to a single line and sum the values of G, H, I and J
5) EXAMPLE NOTE: raw data has 7 lines and final results has 5 lines. Lines 4 and 5 have been combined and summed. Lines 6 and 7 have been combined and summed.
6) Add Headers
7) Bold and underline headers

Thanks

Additional information submitted:

06/07/2009 at 4:34 EDT:
NOTE: I am looking for a script or macro. I am NOT looking for manual data entry workers.

Thank you

Additional files submitted:
final results.xls
raw data.xls

Report Violation

Job Type

Excel

See more: add, code, compare, data, excel, excel expert, expert, file

Messages Posted:2

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

PMB

1 day

06-07-2009 08:54 EDT

9.9951/10
(205 reviews)

Hai please check PMP

MAnkita offline

1 day

06-03-2009 21:43 EDT

9.8698/10
(169 reviews)

Hello,Please refer your PMB.Thank you.

alok007patel offline

0 days

06-03-2009 21:32 EDT

9.9877/10
(81 reviews)

*Hello!Lets start* Check your PMB please,Thanks!

vindhyavart offline

1 day

06-03-2009 18:59 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(66 reviews)

Please have a look at your PMB. Thanks.

lucky2gaf offline

1 day

06-03-2009 18:27 EDT

9.8372/10
(43 reviews)

Hi, please check my PM for details, thanks.

best4best offline

0 days

06-03-2009 23:47 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(35 reviews)

I am an Excel expert. Please see PMB.

skgtechnologies offline

7 days

06-03-2009 22:29 EDT

9.9706/10
(34 reviews)

Dear Sir, We are excel expert and our rates are only 40$ per week. thanks Sachin Gupta

nmppatel offline

0 days

06-03-2009 20:52 EDT

9.6875/10
(32 reviews)

I have very good experience with Excel VBA. I have done many projects in Excel Skill of GAF. I will complete this project in few hours.

FinalDestiny offline

0 days

06-04-2009 06:27 EDT

9.7241/10
(29 reviews)

Check your pm please.....

techservice offline

1 day

06-03-2009 21:11 EDT

9.8214/10
(28 reviews)

Please check PM

prabhueswaran offline

1 day

06-03-2009 20:43 EDT

9.9545/10
(22 reviews)

Hi please see PM for details

ExtraNet offline

100

3 days

06-04-2009 01:54 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(20 reviews)

Solution: Executable that can batch convert many excel files at the same time. You just have to select the files you want converted. See PM for details.

northwolves offline

0 days

06-03-2009 22:40 EDT

9.95/10 9.95/10 9.95/10 9.95/10 9.95/10 9.95/10 9.95/10 9.95/10 9.95/10 9.95/10
(20 reviews)

Hi,sir As a top expert of excel,I'm looking forward to working with you,see PMB please.

TechnoSGIT offline

2 days

06-03-2009 23:58 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(19 reviews)

Hi, Please check my PM for details!!! Regards, Techno

doonsoftwares offline

0 days

06-03-2009 20:30 EDT

9.3889/10
(18 reviews)

I have seen both the files and ready to give the solutions as per detail. Thanks

SergeyPlus offline

1 day

06-04-2009 05:04 EDT

9.9375/10
(16 reviews)

Hello. Look PM please. Sergey S.

pyazlm offline

1 day

06-07-2009 05:35 EDT

9.9375/10
(16 reviews)

You may check PMB for demo.

sujiumesh offline

1 day

06-03-2009 22:56 EDT

9.8571/10
(14 reviews)

please check the pm

rpdammu offline

1 day

06-04-2009 04:31 EDT

9.6364/10
(11 reviews)

Dear sir, Please check the PM Sincerely Rajendra

tusharvv offline

2 days

06-07-2009 13:45 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(10 reviews)

This can certainly be done using Excel VBA. I am ready to start IMMEDIATELY. Please refer to PM.

aniss55 offline

1 day

06-03-2009 23:14 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(5 reviews)

Please see pmb.

jpriyak1023 offline

1 day

06-03-2009 20:11 EDT

9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10 9.5/10
(4 reviews)

Please refer PM for details.

mahfuzmurshed offline

0 days

06-03-2009 23:11 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Please see PM.

LajosArpad offline

2 days

06-04-2009 12:34 EDT

10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10 10/10
(1 reviews)

Hello, I have made an application which is able to handle data in xls format. I can make this soft in a very short time.

Syafaat offline

1 day

06-03-2009 19:15 EDT

(No Feedback Yet)

BID Dear Mr/Mrs. I accepted job vacancy from your company. I can finish this fastly. I will do the best. I am a professional so you can trust me. I hope you receiving my bid. Sincerely, Syafaat Ali Akbar

JonWadsworth offline

0 days

06-03-2009 20:57 EDT

(No Feedback Yet)

Hi! I'm a USA (Illinois)-based Data Wrangler; I've been crunching huge, complicated spreadsheets for years. I can have this completed within a couple of hours of when you send it; plus, if you'd like, the formulas so you can do it again yourself at a later date with new data. I speak fluent English (it's the only language I speak); so if you have further questions or changes later I can accommodate. Enjoy! Jon PM/eMail me for more info,

AB786110000 offline

1 day

06-03-2009 22:21 EDT

(No Feedback Yet)

Would love to be part of your team.

bvictoria offline

1 day

06-03-2009 22:53 EDT

(No Feedback Yet)

I am perfect for you. I have managed data and suppled reports for many large tech companies. My process insures accuracy. I can supply samples of my work.

RaphaelB offline

1 day

06-04-2009 11:41 EDT

(No Feedback Yet)

Easy job, no problem for me. I can be fast, cheap and double check results thoroughly for consistency.

Sshram offline

145

6 days

06-04-2009 18:03 EDT

(No Feedback Yet)

I work with high availability.

Bid on this Project

WHAT IS FREELANCER.COM?

Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.