Cancelled

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

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

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

About the Employer:
( 26 reviews ) New York, United States

Project ID: #4460858

17 freelancers are bidding on average $209 for this job

weblazer

Good day! After reading the project description, im confident that i can do this job. I hope you will consider me for this job and i can start immediately.

$247 USD in 7 days
(64 Reviews)
7.3
FINGERRPRINT

Thanks for your invitation

$515 USD in 10 days
(115 Reviews)
7.1
Innovative116

Hi. I have few questions. Please check private message for more details. Thank you

$262 USD in 3 days
(85 Reviews)
6.8
hossionsumon

Experts and experiments team here Manual Data Entry Work. can u give me fair price and exact time frame....Awaiting for your response.....Thanks

$257 USD in 7 days
(121 Reviews)
6.6
bdbangla

Hi, I can do this job in a professional manner. I can assure you to provide 100% accurate work. Please contact with me through private message. Thanks.

$210 USD in 4 days
(103 Reviews)
6.0
jeweljitu

Kindly check my comments, past feedback in the following message board, we look forward to your response.

$247 USD in 10 days
(101 Reviews)
5.8
HardWorker1989

Hello dear Sir/Ma'am. I am a highly qualified, certified, talented and highly professional MS Office, Adobe Acrobat, Adobe LiveCycle Form Designer, Adobe Photoshop, Adobe Illustrator expert and Quickbooks. I ha More

$175 USD in 3 days
(23 Reviews)
5.2
wasimsohail

Please see PM for details.

$200 USD in 6 days
(19 Reviews)
4.6
tuhindo82

Dear I have just seen your Job posting and upon reading thoroughly, I felt strongly that I would be the most qualified contractor for your project. I have vast experience in IT / Data Entry / Web Research /Admin / SE More

$253 USD in 10 days
(8 Reviews)
4.5
katepesic

Hi, I can do this job very fast, please contact me

$165 USD in 3 days
(22 Reviews)
4.3
jiashahood

Hello sir I can do this project, Kindly check your Inbox for my resume. Thanks

$149 USD in 5 days
(9 Reviews)
3.3
afua23

I can get this done for you. I have taken a look at the attachment and understood your requirements.

$154 USD in 3 days
(12 Reviews)
2.9
inboxasma

well versed in Excel and can deliver high quality in affordable price...

$136 USD in 5 days
(2 Reviews)
0.6
dipakjet

I can get this done for you. I have taken a look at the attachment and understood your requirements

$154 USD in 3 days
(0 Reviews)
0.0
ldunlap08

I am completely capable of completing this job!

$154 USD in 3 days
(0 Reviews)
0.0
mihaelapopa2

Let's do it!

$262 USD in 7 days
(0 Reviews)
0.0
honeykimky

I'm interested in this project. Willing to work 8-10hrs/day.

$154 USD in 3 days
(0 Reviews)
0.0
andypakilaran

I'm ready to do it for you

$110 USD in 7 days
(0 Reviews)
0.0