*** Please familiarize yourself with the specifications below, and respond with your intended approach as well as any questions or comments you might have. ***
This project will pull data for individual country contributions to various UN organizations from PDFs available from the UN Chief Executives Board for Coordination ([url removed, login to view] The candidate will output the information in a standardized format into a single Excel workbook that includes a tab for each year for which data is available, 1991-2013. Each tab should include the contribution amount from each country (rows) given to the corresponding UN organizations (columns) listed in the PDF.
The PDFs are included in the attached .zip file as well as on the website. The .zip file also contains an Excel that shows an example format for each year and information on the PDF and table that should be the source for each year.
This project requires a high degree of accuracy and includes one benchmark.
- See the “PDF Key” tab in the Excel workbook provided for a concordance table detailing which PDF and table to use for each year
- See the year tabs in the Excel workbook provided for the desired output format
- Data for each year will be put into a separate tab labeled with the year (e.g. 1991, 1992, 1993)
- Countries should be in column A, UN organizations in row 1
- Use the country list in the corresponding PDF or your own country list
- Make the order of the UN organizations in row 1 uniform for each year, regardless of the order in the PDF; this is not true of the current Excel workbook
- See Notes in the "PDF Key" tab for special instructions for a given PDF or table
12 freelance font une offre moyenne de $294 pour ce travail
Good Day to you Dear employer, i have read your brief and understood the serious project. It will be good for me if you kindly respond on following issue. How many days you will allow to accomplish the task? Thanks.