Publicar um Concurso

Automatization of Excel Procedures

Status: Closed
Prêmio: $10
Inscrições Recebidas: 4
Vencedor: mihainovac

Winner

Síntese do concurso

Hello Everyone,

The goal of this contest is to produce a tool to automate a manual process. The process consist in the following steps

1. Input data are billing receipts in PDF, they can be opened in Word because they ar enot images, its text and tables. All the billing receipts are saved in the same folder, the tool must be able to go to the folder and and extract the data needed from each of them.

2. There are close to 40 different providers, each provider have their own receipt template and layout but contains the same information.
3. Each data point from the receipt is currently being manually inputted to an excel file, which then generates a summary box that has to be saved and populates a tables where each row is a billing receipt and in each column it appears each data point retrieved from the receipt.

Thank you for participating!

Cristobal

Attachments:

1. Billing Input, example of the files used a input
2. Data Analysis, how the input information is used to generate the output (row with information and ticker which is pasted on the original bill and saved as PDF)
3. Example of how the billing is merged with the ticker (yellow square) and saved as a new file.

Additional Information: The process must be scalable because there are several bill each month, and a data row must be created for each of them and an output file must be created as well (just at the one attached which includes the yellow square)

Thank you!

Habilidades Recomendadas

Winner

Lance um Concurso Como Este

Principais inscrições deste concurso

mihainovac United States

0
lourdesreynaldo Argentina

0
rollicks Kenya

0
AhmedHassan1122 Pakistan

0

Ver Mais Inscrições

Painel de Comentários

rollicks
- 6 anos atrás
Your price is too low.
- 6 anos atrás
mihainovac
- 6 anos atrás
#increaseprize at least $100
- 6 anos atrás
1. Proprietário do Concurso
  - 6 anos atrás
  Hi Mihai, thank you for your post, I am interested to know more about your comments for this project., could you submit an entry so we can start a private chat
  - 6 anos atrás
2. Proprietário do Concurso
  - 6 anos atrás
  Sorry! I didnt notice you had already submitted one, I will send you a PM
  - 6 anos atrás
lourdesreynaldo
- 6 anos atrás
Hello, you could send a model image.
- 6 anos atrás
1. Proprietário do Concurso
  - 6 anos atrás
  Hello Lourdes, thank you for your interest on this contest, the files had already been uploaded, please submit an entry so we can start a private chat and know ore of how would you solve this task
  - 6 anos atrás
lyehengfoo
- 6 anos atrás
#increaseprize
- 6 anos atrás
1. Proprietário do Concurso
  - 6 anos atrás
  Hi Lye Heng, how are you doing? Please could you submit an entry so we can start a private chat? I am interested to know which will be a fair value for this project
  - 6 anos atrás