Project Detail

Synthetise Excel spreadsheet  

Synthetise Excel spreadsheet is project number 217528
posted at Freelancer.com. Click here to post your own project.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: svet63

Budget: $30-250

Created: 01/24/2008 at 14:19 EST

Bid Count: 36

Average Bid:
$ 90

01/27/2008 at 14:19 EST

Project Creator: modena
Employer Rating: 9.95/109.95/109.95/109.95/109.95/109.95/109.95/109.95/109.95/109.95/10 (40 reviews)

Bid On This Project
 

Description

Hi,
i'm looking for someone to gather informations from Excel files.
There is 2400 pages with a lot of data on them. I don't need them all, I only need few infromations from them to be sum up into a new excel spreadsheet.
PLease find enclosed 4 examples of the pages, but also the layout that I want for the final excel spreadshirt.
Please note that this pages have been scanned form original paper. So the layout of the pages may be different, from one to an other.

Explanation:

All A4 pages is scanned into one page.

But I don’t need all the informations from the page…I only need the text that is highlighted in yellow.

So I created a layout spreadsheet to show you how I would like it.

There is one specification.

If you look at the the file called “Untitled2 – 0004” you will see that I have highlighted “1963” in bigger size and in red.

It’s the date of birth of the owner of the company. And that a variable really important for us.

To explain you everything this documents are financial sum up of companies. So we have the name of the company, the phone number, the address, how many money they make per year…but we also have the name of the owner of the company and his/her date of birth (in that case 1963)

Our company is a “company dealer”…so basicly with the date of birth we can know if the owner if old or not, and if he is going to go in retirement soon.

If he is pretty old, then we will call him and offer our service, to help him selling his company. That’s why the date of birth is important and that’s why we would like to rank the final excel spreadshirt by date of birth.

Tell me if the date of birth can be something automatised, because as you see we don’t have all the date of birth.

Also for exemple for the “chiffre d’affaire net 2005/2006….” The informations are not really really important. So for example if that’s too much complicated to have the data of all the years, that’s not such a big deal to have only the last year.

Please give me your price and timeframe.

I need you to tell me how you're gonna process that all in details, in your bid.
PLease keep in mind that I paid $80 for a similar project.


Additional files submitted:
Untitled2 - 0001.xls
Untitled2 - 0002.xls
Untitled2 - 0003.xls
Untitled2 - 0004.xls
Synthetic.xls

Messages Posted:4 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

 

90

0 days

01-25-2008 00:59 EST

help

 

80

5 days

01-25-2008 14:37 EST

VBA developer since 1997. I will automate it using VBA macro. FYI my wife is a french interpreter, so I don't expect troubles with the French text in xls files. Merci.

help

 

80

5 days

01-25-2008 18:33 EST

Hello, I am very interested in this project. Please refer to PM.

help

 

60

4 days

01-26-2008 03:29 EST

kindly refer PMB, Thanks

help

 

80

4 days

01-24-2008 15:16 EST

Hi, I will do the job for you at the same price that you paid previously. I estimate that it will take 4 days but I will be able to make a more accurate assessment once I start. Obviously it also depends on how quickly you can get the 2400 pages to me. I don't think there is a way to automatise the date of birth but when you have them all I will enter them onto the sheet for you included in this price. I wasn't too sure about the CA columns - for example, in your 1st entry it looks like there should be 412 for CA2002 but you have x. Can you clarify please? Looking forward to working for you. Regards Barry

help

 

240

12 days

01-24-2008 15:28 EST

Dear Sir Kindly see your PM for details. Thanks AZHU

help

 

100

7 days

01-24-2008 15:38 EST

Please see PM for details.

help

 

50

7 days

01-25-2008 03:10 EST

Hello, I am interested in taking up this project. Please see PM for details. Thank you.

help

 

200

10 days

01-25-2008 08:49 EST

please check PM for details

help

 

30

2 days

01-25-2008 09:04 EST

Yup two days...from the time all the clarifications made or from the time you'll hire me Believe me... You can have it all ONE CLICK... I know how how to use SQL in excel ... JUST ONE CLICK... ONE CLICK.. plus EXCEL VBA.. I know where the heart of people like us is... EXCEL. We don't blame ourselves... EXCEL is the friendliest .. see my attachment.

help

 

45

2 days

01-25-2008 13:15 EST

Sir, I could see your requirement in GAF.com. I 'm interested in the offer. I possess 13+ years experience in office works, especially in finance industry at different levels. Please see my profile and let me know any further information regarding my qualification and background need to be provided. I'm available for 40 hours a week . I look forward to hear from you and thank you for your consideration. Regards Billy Francis.

help

 

100

7 days

01-24-2008 15:12 EST

(No Feedback Yet)

Data structure analysis and interpretation from the .xls originals VBA procedure to capture specific data from the originals VBA procedure to generate a new sheet Synthetic.xls with the required data Quality and result guaranteed, wide offer for other excel solutions for your company.

help

 

49

10 days

01-24-2008 23:20 EST

(No Feedback Yet)

Your work done reliably, without error and on time, hoping to do business with u.

help

 

70

6 days

01-24-2008 19:05 EST

(No Feedback Yet)

Dear Sir, I am an accountant working in London. The project is straightforward and will be completed in 6 days. Being bilingual french-english, I foresee no problem in completing the project on time. I think $70 for the project is fair given I'm new to this website and i want ot build my reputation. If I'm awarded the project and you are happy with the outcome, we could work together on future work you may have. I have access to additional resources if you need delivery of projects in short-time period.

help

 

80

7 days

01-24-2008 20:23 EST

(No Feedback Yet)

Hello; I've gone through all your files and the requirements. If all the worksheets are in a similar format, there'll not be much difficulty to populate the data. Pl. explain why there are many sheets in the 'synthetise' file you provided. I believe all the 2400 records can be populated in a single worksheet. Regards.

help

 

100

2 days

01-24-2008 22:10 EST

(No Feedback Yet)

I am a teacher and a part time writer in online essays. I am knowledgeable in MS Excel. I done lots of research paper, thesis and dissertation using excel because I am statistician. I am also knowledgeable in Business and Corporate finance, Econometric.

help

 

60

5 days

01-24-2008 23:05 EST

(No Feedback Yet)

I can develop the new sheet by sorting the data from the untitled sheet and bring all the company names with date of birth of the owner together once I populate all the data in the synthetic sheet and like to change the format of the sheet so that it becomes easier to browse through the data. I presume it can be finished in 5 days but I can give you a exact time frame once I have started working on it.

help

 

150

5 days

01-25-2008 01:00 EST

(No Feedback Yet)

To deliver Error Free product i just need 5 days.

help

 

80

5 days

01-25-2008 01:11 EST

(No Feedback Yet)

Dear sir/madam, i am interested to work with this project as you mentioned Thank you

help

 

80

3 days

01-25-2008 03:01 EST

(No Feedback Yet)

Hi, I have gone thru all the files, and can create an excel sheet containing all the required info. I am a post graduate in Statistics with a diploma in computer applications. I am very confident working in Excel. I can create a macro to automate the process, and can do it manually too. As per the project description, the date of birth is necessary, but in some of the worksheets, the figure is missing. Cud u pls clarify on that and wud appreciate if considered for the project. Pls see PM for my bid. Rgds

help

 

80

7 days

01-25-2008 03:07 EST

(No Feedback Yet)

I am interested to do this job. Please give me a chance.

help

 

80

3 days

01-25-2008 03:22 EST

(No Feedback Yet)

I can do it in 3 days by automating + verifiying the data. Pas d'erreur possible en recuperant les donnees, je suis française. Cdt.

help

 

75

7 days

01-25-2008 05:03 EST

(No Feedback Yet)

I'm new to Getafreelancer, but not to data entry. Been doing data entry for four years mostly doing copy / paste of data from system to an excel spreadsheet. I hope this merits your approval..

help

 

100

5 days

01-25-2008 05:26 EST

(No Feedback Yet)

Hi ......i can do this project. Please send me the details. Regards.

help

 

200

4 days

01-25-2008 07:34 EST

(No Feedback Yet)

Hi sir. I surely can do it, I've already worked the method to be used in my mind. My bid is 200 USD, timeframe 4 days.

help

 

100

5 days

01-25-2008 07:58 EST

(No Feedback Yet)

Dear Sir/Madam : I am very confident that I can make this project very well. I am very well-versed in Microsoft ACCESS a database program wherein I can make a simple program so I can get/encode all the data that you need. Since you want it in EXCEL (spreadsheet) form the ACCESS database can be easily convert into it. But you know I can give you the simple program in Microsoft Access wherein you can just type the name or date and you can browse it easily much better than EXCEL... free of charge since that would be the process I will do. If you just trust me and give me the opportunity to serve you. Thank You.

help

 

50

2 days

01-26-2008 07:55 EST

(No Feedback Yet)

Hi, I propose to do this project manually. Can deliver it well within 2 days for sure, provided all of the 2400 pages are similarly laid out.

help

 

75

1 day

01-25-2008 11:42 EST

(No Feedback Yet)

Intrested to doing this job, I've done more than 10 jobs of this types.

help

 

90

3 days

01-25-2008 15:12 EST

(No Feedback Yet)

hi check pm for detail

help

 

200

7 days

01-26-2008 02:08 EST

(No Feedback Yet)

The time will start after receiving the documents.

help

 

80

3 days

01-26-2008 07:42 EST

(No Feedback Yet)

hi, give me occation for your project ...

help

 

30

1 day

01-26-2008 08:28 EST

(No Feedback Yet)

I'm ready for the work plz check my profile thanks

help

 

75

2 days

01-26-2008 17:10 EST

(No Feedback Yet)

I just begin to work on this site. So I decided to show you at once that I can do. Your program not complex. See PM .

help

 

70

4 days

01-26-2008 19:28 EST

(No Feedback Yet)

Hi, I am interested to work on your project. I assure you high quality output within stipulated timeframe. Looking forward to hear from you. Thanks for your time. Regards, Sharmilarajan

help

ZVI

 

50

1 day

01-27-2008 00:44 EST

(No Feedback Yet)

Hello: I have already developed VBA Add-Ins for Excel which automatically carries out everything that is specified in your very precisely formulated requirements. Let me describe algorithm. 'Name' value always is on A1 cell. For other fields the exact and preliminary pattern searching are used. For example, firstly 'Téléphone:' is searched, if not exist then 'Téléphone' pattern is used. If not found then error message is appeared (manual check is required). If found then the string array with additional separator is created from shifted cells at the left or/and below relative to the found key cell. It is because the cells can be joined and/or formatted with or without usage of spaces. After that array from string is created and analyzed. As a result the date of birth is successfully extracted from 'Gérant:' as well as all years from 'Date de clôture de l'ex.' and its corresponding values of 'Chiffres d'affaires nets' row. The result is written in Synthetic.xls One click of the button is now required for me for all described above. Please, let me do this work for you. Regards, Vladimir.

help

 

50

1 day

01-27-2008 01:51 EST

(No Feedback Yet)

hi there, i've worked in C, C++, VB and macro coding all you need just a macro and i can build it thanks Farness

help


    Bid on this Project