Please check the following details and send me the answers to my questions. Please send me a sample afterwards. This can't be done programmatically as content meaning need to be understand in both pdf and factors in excel before putting 0/1. It seams a huge task but when you used to it will be easier. As 7 rows are from same companies most of the times, it will be easy for you than it seams. (Though you have to do it for 7 rows separately, format for 7 pdfs will be same and once you do 1, finding others will be easy)
Skills : Excel, Pdf, Through English reading and understanding capability, research knowledge
Pdf : Each pdf is for company year and it is the annual report. In pdf, Data will be available from the begining (not all data but initially read all data till you understand) until income statement or balance sheet
Excel : Has 83 factors (row 3) from column C under 7 categories (row 1). Details to recognize disclosure (whether details on that is given on annual report) is given on row 4. Each rows first 2 cells has company Id and year so you have to fill remaining 83 cells with 1 or 0
Detail: This is to find the each company years CSR (corporate social responsibility) disclosure (whether details mentioned in annual report). I have to get whether some details about 83 factors belong to 7 categories (Economic, Environmental, Labor Practices & Decent Work, etc.) are mentioned in pdf or not (0/1 according to availability. Just follow the steps below
Initially as sample,
1. Read all factors (all columns in 3rd row) in excel and how to identify whether those details are provided (row 4). I have attached another pdf (GRI 3.1) to get much more details if necessary.
You need to get the full idea of factors before starting the work.
2. Read the relevant pdf (annual report) of the given sample (01BFT_01BFL 2010-2011) and check whether sample data I have given is correct.
You have to read the report from the beginning (not all data but initially read all data till you understand) until income statement or balance sheet. You can ignore Director profiles. Some times, data could be given after financial notes (rarely)
3. Read the annual report of 01BFT_01BFL 2011-2012 and fill in the excel row relevant to that. You should give only 1 and 0 (do not use any other value) to each cell and do not keep any cell empty.
You may read pdf first and then fill the factors availability in excel from memory and recheck the accuracy with pdf again. Otherwise you can enter the values while reading pdf by remembering 83 facts and categories
4. Then fill the next sample of 16SRV_04JKL 2010-2011
Work : You need to fill 250 rows (6 freelancers will be awarded) within 10 days. You have to send 50 rows in every 2 days time. This is necessary as my deadline on this is very tide. According to my budget I will be able to pay 50$ for those 250 rows.
Then data will be validated and rechecked so accuracy is really important. It will be easy when you are used to these factors and annual reports. 7 rows by 7 rows are from same company most of the times so those pdfs will be similar though values can be different according to additions and removal of annual report data year by year.
1. How many hours per day you can work / part time or full time
2. How long you want to do this 250 rows
3. Can you work on my budget
4. send samples for 2 company years 01BFT_01BFL 2011-2012 and 16SRV_04JKL 2010-2011
You can have all the necessary files in [login to view URL]!Ao0GYwz1u7UYmjutVQy4Lc_zsmA0
There is another approach to this using keyword search. But you can't only search for keyword and say yes or no to a factor. You have to read content around found keywords after searching several keywords for one factor before putting 1/0. Sample detail is there on [login to view URL] in link
19 威客就此工作平均出价 $55
Good Day I have read the project description and understand the requirements. I can work more than 7 hours/day. Allow me to complete it with 100% accuracy and perfection. Regards
Hi I read your all description and i accept your terms and budget i'm doing full time 3-4 hours for 250 rows and I doing in your budget Thanks & Regards Quick Solutions