Convert Text file to Excel and Extract Data

Cancelled Posted Oct 4, 2011 Paid on delivery
Cancelled Paid on delivery

I need to take a group of text files (attached) and convert it to an Excel spreadsheet that i can extract data from. For example, I want to create a graph of Cumulative Cash Flow through the year 2015, or Economic Limit, or Ultimate Recovery for each case attached.

I envision a visual basic macro that parses the text into columns, then a lookup function that extracts the specific cell i need.

I've attached text, pdf, and excel files that show what I'm currently doing by hand. It would helpful if I could automate this process.

Data Entry Data Processing Excel Visual Basic

Project ID: #1234520

About the project

60 proposals Remote project Active Oct 24, 2011

60 freelancers are bidding on average $110 for this job

gangabass

I can do this for you. See PM for details.

$100 USD in 2 days
(200 Reviews)
6.7
esalem

Hello, please see the PMB for details.

$150 USD in 5 days
(22 Reviews)
6.9
koolsidz

Excel Whiz at your service ;) Please see PMB for more details.

$78 USD in 0 days
(174 Reviews)
6.6
spawar

I am ready to start work on this project, can discuss more through PM.

$100 USD in 2 days
(59 Reviews)
6.1
nagybatonyi

In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are include More

$220 USD in 5 days
(63 Reviews)
5.7
tamrakar81

Hi, I have gone through your requirement and I am glad that We can accomplish this task, Please give us opportunity to work with you. Please check PM . Thanks, TTS Team

$50 USD in 1 day
(98 Reviews)
5.7
vbexcel

Excel / VBA expert - ten years experience.

$50 USD in 1 day
(35 Reviews)
5.7
sikandermandal

Please Seee PMB.

$250 USD in 5 days
(8 Reviews)
4.9
dev3dworx

Please check pmb for details.

$200 USD in 5 days
(21 Reviews)
4.8
immense1

I have the experience to work of Data Entry. Please check your PM. Thank you!

$30 USD in 0 days
(3 Reviews)
4.7
microk

Excel whiz here.. Please see PM for details..

$50 USD in 1 day
(34 Reviews)
4.5
sujonmax

Dear sir, completed work plz chick my fail.Thanks..

$30 USD in 0 days
(12 Reviews)
4.0
shacoim

Hi, I am a computer science graduate and have enough stuff in Excel VBA. Please check PM for demo videos.

$30 USD in 1 day
(13 Reviews)
3.9
mira298

I am interested on your job. Please check your PMB>

$50 USD in 3 days
(11 Reviews)
3.6
cheungkc

Hi Excel can read in text files direct. To create worksheets as in pdf is nice for user reference but not absolutely necessary. It is your choice. Please let us have sample of the rest of the graphs for review.

$150 USD in 3 days
(7 Reviews)
3.2
Aactivelink

dear sir , please check my excel data in pm ... thanks

$90 USD in 3 days
(4 Reviews)
2.7
jewelsaid

Hello Sir, >>>>>>>>>> See My Sample Work File. <<<<<<<<<< & Check PM

$50 USD in 2 days
(2 Reviews)
2.0
djodjifer

Dear Sir, Your list would be converted accurately. For details plese check PM.

$30 USD in 1 day
(2 Reviews)
2.1
amz1484

Hi I am from investment field having more than 6 years of experince in finance. I have a team of 8 members so can do your project very speedily. Plz provide us an opputunity to work with you. I have PDF to excel conver More

$50 USD in 5 days
(1 Review)
2.4
FinanceMike

I am an excel and VBA expert and have been providing customized solutions for over ten years.

$100 USD in 3 days
(1 Review)
1.4