In Progress

Synthetise Excel spreadsheet

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.

Skills: .NET, Data Entry, Data Processing, Excel, Visual Basic

See more: we excel, looking dealer, service spreadsheet, page layout companies, me excel, make yellow, final specification, excel spreadsheet companies, excel specification, big lot, synthetise excel, project timeframes excel spreadsheet, new excel, n excel, need excel help, find dealer, visual basic form excel, retirement, price excel, name red, final years project, final paper, excel us, excel service, excel form

About the Employer:
( 221 reviews ) vanves, France

Project ID: #217528

Awarded to:

svet63

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.

$80 USD in 5 days
(73 Reviews)
6.5

36 freelancers are bidding on average $90 for this job

$90 USD in 0 days
(128 Reviews)
6.7
vnb400

kindly refer PMB, Thanks

$60 USD in 4 days
(11 Reviews)
4.4
RainbowSearches

Please see PM for details.

$100 USD in 7 days
(8 Reviews)
3.9
swexicorp

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

$80 USD in 5 days
(7 Reviews)
3.4
BarryDawber

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 quic More

$80 USD in 4 days
(6 Reviews)
3.1
azhu

Dear Sir Kindly see your PM for details. Thanks AZHU

$240 USD in 12 days
(1 Review)
2.4
TashaMoor

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

$50 USD in 7 days
(1 Review)
1.4
annamrama

please check PM for details

$200 USD in 10 days
(1 Review)
1.2
kmohan1962

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 'synthe More

$80 USD in 7 days
(3 Reviews)
1.0
jrgracia

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 Qualit More

$100 USD in 7 days
(0 Reviews)
0.0
cmahale

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

$75 USD in 1 day
(0 Reviews)
0.0
kingbill

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 k More

$45 USD in 2 days
(0 Reviews)
0.0
sbinfo

hi check pm for detail

$90 USD in 3 days
(0 Reviews)
0.0
Firdaussda

hi, give me occation for your project ...

$80 USD in 3 days
(0 Reviews)
0.0
bkpower

The time will start after receiving the documents.

$200 USD in 7 days
(0 Reviews)
0.0
maha82

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

$30 USD in 1 day
(0 Reviews)
0.0
Rustem78

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 .

$75 USD in 2 days
(0 Reviews)
0.0
Sharmilarajan

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

$70 USD in 4 days
(0 Reviews)
0.0
ZVI

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 A More

$50 USD in 1 day
(0 Reviews)
0.0
harunfreelancer

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.

$50 USD in 2 days
(0 Reviews)
0.0