Em Andamento

Fill in a Spreadsheet with Data - task 1 and task 2

ask 1. Copy a table from financial statements to an Excel spreadsheet.

There are 495 documents in file docs_task_1.zip. Each file contains the financial statements of an organization. Task requires to copy one table: the "consolidated operations" statement.

This statement summarizes the revenue and expenses for several years. Each sheet in the Excel spreadsheet should have the name of the file. That is, the final Excel spreadsheet will have around 495 sheets.

I attached a copy of one of the documents (see file [url removed, login to view]) and a rough idea of the expected outcome ([url removed, login to view]). In this sample, the table to be digitized is the one in page 5. Note that some documents are in French. These are to be skipped.

Task 2. Copy a table with information on salaries from a document to an Excel spreadsheet.

There are 495 documents in file docs_task_2.zip. Each file contains a table with the schedule of salaries, honoraria and travel paid to elected officials of an organization. Task requires to copy this table to an Excel spreadsheet Each sheet in the Excel spreadsheet should have the name of the file.

I attached a copy of one of the documents (see file [url removed, login to view]) and a rough idea of the expected outcome ([url removed, login to view]). In this sample, the table to be digitized is the only one in the document. Note that some documents are in French. These are to be skipped.

I will provide to ZIP files at the beginning of the assignment.

Habilidades: Processamento de Dados, Excel

Ver mais: task 1, fill sheet, travel spreadsheet fill, fill statements spreadsheet, idea task, spreadsheet financial, fill data google spreadsheet, consolidated excel, financial statements excel, excel consolidated, attached spreadsheet revenue, spreadsheet file organization, fill data spreadsheet, schedule xls, excel spreadsheet financial data, excel financial statements, fill excel spreadsheet data, excel file operations, financial data excel spreadsheet, excel file pdf fill, french data, fill data html page, travel data excel, task spreadsheet, schedule sheets

Acerca do Empregador:
( 0 comentários ) COQUITLAM, Canada

ID do Projeto: #6790328

Premiar a:

muzammil21

Hired by the Employer

$350 USD em 5 dias
(75 Avaliações)
6.1