Convert Excel files with text, PDFs, and text documents to organized Excel database documents - repost
$30-250 USD
Cancelled
Posted about 11 years ago
$30-250 USD
Paid on delivery
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.
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.
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.
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.
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.
Can you please be frank and let me know the budget that you have as I always like to work under the budget of my clients so that they can be happy.
If you would like to know my bid it would $175 and delivery time will be 2 - 3 days maximum.
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.
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 / SEO / Content upload for eCommerce and Marketing. Understanding how valuable an education is, I am serving Pacific Pharmaceuticals Limited as a Sr. Executive (MIS), toward earning my Masters of Business Administration (MBA) degree and B. Sc Computer Science.
I have completed many web research/data entry/ General Admin and marketing project. I am 100% able to do your project.
Sincerely,
Tarikul Islam