In Progress

Read/Write (Multiple) Excel File Data Organization

This project is to use a programming language (C# or other) to read an excel file and then organize the data and write

additional excel files from it.

The file to be read is called [url removed, login to view]

It contains 42523 lines.

[url removed, login to view] FORMAT:

Column A is a Zipcode.

Columb B is a State abbreviation.

Column C is a City.

Column D is an Area Code. (sometimes multiple Area Codes seperated by commas)

Column E is the Population.

FIRST STEP: Delete all rows from [url removed, login to view] where Population is less than 10000.

What I want delivered is one excel file for each Area Code. For example, the first 5 excel files created will be named...

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

[url removed, login to view]

And so on, for each Area Code.

The format for the delivered excel files will populate the excel columns A, B, and C.

Column A in the delivered excel files will contain a Zipcode, Column B will contain the corresponding City to the Zipcode,

and Column C will contain the population corresponding to the Zipcode and City from the original [url removed, login to view] file. The rows in

the created excel files should be ordered from highest population (C column) to lowest population.

Zipcodes with multiple Area Codes will be included in each Area Code *.xls file.

That's it.

A sample of 10 excel files for 10 different (random, your choice) Area Codes is required before a winning bidder is chosen

and full payment is released. This is to verify that freelancer is capable of performing the task.

Please Open PMB and attach example excel files and you will be awarded the project and paid immediately. Thank you.

Attached to this project description is [url removed, login to view]!

Good luck!

Skills: .NET, C# Programming, Excel, Project Management, Software Architecture

See more: read multiple data excel, read write excel file, write multiple excel file, excel file population, write to freelancer, what write in freelancer, what to write on freelancer, programming in excel 2013, net code freelancer, is net a programming language, highest paid programming language, highest paid freelancer, freelancer zip file, freelancer write, freelancer with excel, freelancer in it area, freelancer delete project, delete project on freelancer, data management freelancer, c read example, c# programming task freelancer, area code excel, programming with excel, less than excel, excel less than

About the Employer:
( 28 reviews ) niles, United States

Project ID: #4365101

Awarded to:

xeancaile

Hello nervus... consider it done.. please see PMB... regards..

$30 USD in 0 days
(4 Reviews)
1.7

32 freelancers are bidding on average $75 for this job

ehsankayani

HI, I am an expert in making parsing tools such as yours, you can see my profile for my work reviews. Thank you

$100 USD in 2 days
(168 Reviews)
7.7
cheapexcell

Ready to start.

$75 USD in 1 day
(247 Reviews)
7.1
MMaghawry

I have finished the program in C# , I will send you in PM the samples of the generated files.

$85 USD in 0 days
(167 Reviews)
7.1
kalpesh2804

Hello, I can provide you this solution. Please check PMB

$80 USD in 3 days
(99 Reviews)
7.2
sumon355

Hello, I am very much interested to do this work.

$30 USD in 1 day
(203 Reviews)
7.0
ITservice

Hi Pls. check PMB for complete proposal detail. Regards

$100 USD in 2 days
(83 Reviews)
7.1
mrbrave

I can do this within half an hour....i have started now..

$35 USD in 0 days
(207 Reviews)
6.5
omaralieissa

Hi, i have done a project like this before, check my reviews, can start now and finish in about 1-2 hours, thanks

$30 USD in 1 day
(47 Reviews)
5.9
youtekdotcom

Dear Sir, Let me give you a great solution. Production has been already to delivered, detail in pmb. Thanks and Best Regards.

$45 USD in 0 days
(74 Reviews)
6.2
vnb400sl

i can develop an app to split the xls file(s)

$100 USD in 5 days
(125 Reviews)
6.1
manhpham

I am ready to help [url removed, login to view] contact me

$140 USD in 3 days
(73 Reviews)
5.8
DMediaDesign

Hi, Please refer PM for details and a demo program. Regards.

$65 USD in 1 day
(23 Reviews)
5.0
proauthor

Hi, Ready to start your work. Eagerly awaiting for your positive reply. Please check your inbox for further details. Thanks, Shaik.

$30 USD in 1 day
(36 Reviews)
5.0
murtaza1981

Hi....., I (Myself a senior ASP.NET programmer using C# and VB) have a team having experience of more than 5 years in developing web and mobile applications. I have a team of expert programmers who write robust and bu More

$175 USD in 3 days
(12 Reviews)
4.7
chithanh

Hello, I have 5 years experiences in .NET framework. It is easy for me to do this work.

$100 USD in 1 day
(16 Reviews)
4.5
adim

More than 10 years experience in VBA and Excel.

$75 USD in 1 day
(13 Reviews)
4.2
timvn

Hello, sir. I'd like to offer my help with this project. Regards, Tim

$50 USD in 2 days
(5 Reviews)
3.9
vikashgadia

we will create the macro that will take input of the *.xls and complete the desired result and save the csv in the current directory

$70 USD in 1 day
(15 Reviews)
3.8
ranjeetbtp25

I can do this project...........

$60 USD in 3 days
(1 Review)
1.9
DesktopDev

Expert in excel manipulations. Can sort this and give it in one day using my excel tools

$35 USD in 1 day
(0 Reviews)
0.0