Find Jobs
Hire Freelancers

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

$2-8 USD / hour

In Progress
Posted almost 11 years ago

$2-8 USD / hour

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.
Project ID: 4460900

About the project

33 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi. I have few questions. Please check private message for more details. Thank you
$5 USD in 80 days
4.8 (96 reviews)
6.9
6.9
33 freelancers are bidding on average $5 USD/hour for this job
User Avatar
Please have a look to PM. Thanks
$4 USD in 50 days
5.0 (239 reviews)
7.0
7.0
User Avatar
Dear wwwzzz, Greetings!Please refer to your PM For Bid details. Thanks Dhruvika
$4 USD in 25 days
4.5 (121 reviews)
7.0
7.0
User Avatar
Expert here, highly skilled team with expert operator, please see our details am sure it will touch your requirement, ready to start now.
$2 USD in 20 days
4.9 (79 reviews)
6.5
6.5
User Avatar
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.
$4 USD in 21 days
4.8 (104 reviews)
6.0
6.0
User Avatar
Such jobs are my daily practice. My bid includes also the macro doing the job for the case you need it for repetitive use. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards!
$14 USD in 10 days
4.9 (40 reviews)
5.6
5.6
User Avatar
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 have seen all the examples and amount of data to be completed. My bid is $8 / hour and I am sure it will take 10 - 12 hours for me to complete it. Why the high amount because I can complete it more quickly then others. I can perform this job with profound efficiency and with high attention to small details within the specified timeline in order to perform above expectations. I always provide high quality services with maximum revisions in order to give core satisfaction to my clients. Please have a look on my profile for reviews regarding my quality of service. I am a 5 star rated worker and I always provide high quality services which is proven by the reviews from my clients on my profile. I have never received an incomplete report or a RED review. I have 100% completion rate. Please consider my bid and profile accordingly. Thank you very much.
$8 USD in 10 days
4.9 (29 reviews)
5.3
5.3
User Avatar
Hi, I am highly interested and the private message shows what I can do to help you along the way. Please check. Thank you very much. Best! Kalpana
$4 USD in 50 days
4.8 (32 reviews)
5.3
5.3
User Avatar
HI, I can do it with 100% accuracy. Please send some sample files. There is no sample files attached. Best regards, Cuong NH
$8 USD in 8 days
4.7 (22 reviews)
4.9
4.9
User Avatar
I am able to deliver data as per your need with excellent quality of work within given time frame. Please check your inbox for further details. Thank you
$4 USD in 45 days
5.0 (17 reviews)
4.5
4.5
User Avatar
Ready to start !!
$3 USD in 30 days
4.8 (29 reviews)
4.5
4.5
User Avatar
Hi I am very much interested in this project. Ready to take up immediately. Please check pmb.
$3 USD in 28 days
5.0 (29 reviews)
4.4
4.4
User Avatar
Hi, I can do this job very fast, please contact me
$5 USD in 20 days
4.8 (24 reviews)
4.3
4.3
User Avatar
I am willing to start the project immediately.
$4 USD in 10 days
5.0 (7 reviews)
4.1
4.1
User Avatar
Hi, I believe you prefer to go ahead with a top-rated freelancer here. I am expert in excel and vba coding. kindly check my profile first. regards,
$5 USD in 30 days
5.0 (20 reviews)
4.1
4.1
User Avatar
look my finish product if you interested:
$5 USD in 3 days
5.0 (6 reviews)
3.6
3.6
User Avatar
I can get this done for you. I have taken a look at the attachment and understood your requirements. I
$5 USD in 3 days
4.6 (17 reviews)
3.5
3.5
User Avatar
Greetings from Prologic Web Services! I have read through the job details extremely carefully and I am absolutely sure that I can do the project very well, on time and within your budget. Please check PMB for more details.
$4 USD in 6 days
5.0 (4 reviews)
3.5
3.5
User Avatar
Hi, I'm interested for your job. Please check PM
$3 USD in 10 days
5.0 (7 reviews)
3.0
3.0
User Avatar
Dear Sir, I am extremly interested for your project so please see my private massage. Thanks you. Danu
$4 USD in 3 days
5.0 (2 reviews)
2.9
2.9
User Avatar
Hi, I've read and understood your project description. I've 10 year experience of data entry and typing work. Typing speed 60 WPM. Expertise in MS Excel 2007, 2010, Acrobat Reader, Internet Research and Web Scraping. Able to complete your project in time with 100% accuracy and outstanding performance. I give updates timely and regularly. Ready to start right now. Please reply soon. Regards, Virendra
$4 USD in 20 days
5.0 (1 review)
2.4
2.4

About the client

Flag of UNITED STATES
New York, United States
5.0
26
Payment method verified
Member since Jan 20, 2007

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.