Convert Excel files with text, PDFs, and text documents to organized Excel database documents

Closed

Create condensed Excel files that organize and include files from multiple time periods. There are 4 different folders in the attached documents. The first 3 folders are to be condensed into one Excel document each. The fourth folder is to be condensed into a total of 9 Excel documents.

## Deliverables

Folder 1) There are 43 excel files + 1 PDF that need to be condensed into one excel file. Each excel file is for a different calendar quarter and the PDF contains quarterly data for the years 1995-2001. This data needs to be captured in the larger file by adding Year and Quarter columns. (Quarters are listed at 1-4) Also there is a "Circuit and District" column that needs to be divided out into 3 columns of "Circuit", "State", and "District". There is an example file included.

Folder 2) There are 13 excel files that needs to be condensed into one excel file. Exactly the same as Folder 1) except instead of a "Quarter" column it will be a "Month" column numbered 1-12. There is an example file is included.

Folder 3) There are 11 yearly excel files, 1 yearly pdf file, and 1 pdf file for 1990-2002. The files that need to be condensed into one excel file. Like Folder 1) and Folder 2) a "Year" column needs to be created and the filled in based on which year of data is being condensed. In addition, there is "Circ/Dist and County" Column that needs to be separated into "Circuit" "State", "District" columns.

Folder 4) There are 3 yearly excel files. The files that need to be condensed into one excel file. Like Folder 1) and Folder 2) a "Year" column needs to be created and the filled in based on which year of data is being condensed. In addition, there is "Circ/Dist and County" Column that needs to be separated into "Circuit" "State", "District", and "County" county columns.

Folder 5) There are 1 year that contain 17 PDFs which need to condensed into a 9 excel files. The PDF files are labeled Table1-Table9 and each Table number should have it's own condensed Excel file with data. Tables 1,2,8,9 each have three separate PDF tables labeled 1A, 1B, and 1D. Tables with the same number labeled A,B,D should be included in the same Excel file and a column "Chapter" needs to be created and filled with "Chapter 7" for table A, "Chapter 11" for table B, and "Chapter 13" for table D. A "Year" column needs to be added and "Circuit and District" needs to be divided into "Circuit", "State", and "District" for each file. The TOTAL rows should NOT be included in the final Excel file. An example form a previous year has been included.

Skills: Data Entry, Data Processing

See more: create excel form for data entry, create data entry form in excel, pdf table to excel, pdf convert excel, convert a pdf form file, convert columns text files, excel contains, excel file convert, convert pdf database file, convert excel excel pdf, column text, excel file columns, text table, create database multiple excel files, excel text rows, create files folders, excel text column, convert pdf table excel table, excel text columns, quarter excel, pdf file database, excel data tables, pdfs, convert excel file database file, database create calendar

Project ID: #4466103

20 freelancers are bidding on average $28973 for this job

ideadezigner

Sir, I can do this job for you. Please check PMB

$294 USD in 3 days
(6 Reviews)
3.5
ebudihar

I have experiences to do this kind of projects.

$385 USD in 3 days
(6 Reviews)
3.4
BagratDan

Ready to start right now!!!

$330 USD in 3 days
(4 Reviews)
3.4
tomkus

Hi! I am interested in your project. Please check your PM. Thanks!

$550825 USD in 12 days
(2 Reviews)
2.4
empebepl

Welcome, please look at my feedback on my profile and check my private message. Regards.

$275 USD in 3 days
(1 Review)
2.2
sajidmahmud

Dear Sir, I am extremely interested to your project and ready to start immediately. More details in PMB. Thanks

$275 USD in 10 days
(4 Reviews)
2.2
svr888

I am very good in Excel Work. This work will be easily done by me. Hope to get a chance to work with you.

$770 USD in 15 days
(0 Reviews)
0.0
cmoon721

Hello! I work with excel sheets daily and organize them, add multiple sheets to one file. This is exactly what I do on a daily basis! I love doing it and have a lot of experience doing it.

$550 USD in 3 days
(0 Reviews)
0.0
rwijeweera

I am ready to start the work immediately. I have successfully completed data entry projects. Please send more details regarding the reports, I will provide a sample work for you to review. Let's start. Thank you very m More

$275 USD in 3 days
(0 Reviews)
0.0
dragomirristic

Ready to take this job asap.

$269 USD in 3 days
(0 Reviews)
0.0
zealant

Zealant Technologies, LLP has highly energetic and passionate professional driven to make an impact; people who constantly challenge boundaries, explore new frontiers and deliver success to clients. Zealant Technol More

$22000 USD in 3 days
(0 Reviews)
0.0
pravinreddy

My skills with Excel are pretty good. And I expect to complete this project in a smooth and efficient manner.

$550 USD in 3 days
(0 Reviews)
0.0
XcelforU

I would like the opportunity to complete your project. I have many years of experience using Excel to its full potential. Will send you PM for more information. Can start immediately on your project!!! Thanks and welc More

$550 USD in 6 days
(0 Reviews)
0.0
dimitrijevic1

Experienced and ready

$440 USD in 7 days
(0 Reviews)
0.0
fattahaabdul

I am expert in excel, data processing and macros. Will do some work for free to show you my skills.

$275 USD in 10 days
(0 Reviews)
0.0
zoransimicic

If you are looking for good and industrious worker, then you have just found right person! I am Zoran, economy student on EDUCONS University from Serbia, with a lot of experience in Data Entry, Web Research, Photo E More

$275 USD in 3 days
(0 Reviews)
0.0
suyadi24

I can use office application.

$275 USD in 3 days
(0 Reviews)
0.0
ashvernon

I work with Excel and PDF's on a daily basis. I have years of experience in data entry and can condense the data into the format required accurately and on time.

$302 USD in 4 days
(0 Reviews)
0.0
Asad10428

Yes I can do this Project.

$275 USD in 5 days
(0 Reviews)
0.0
mihaelapopa2

Let's do it!

$262 USD in 3 days
(0 Reviews)
0.0