Excel Population from New Database

We are trying to automate a specific billing process. With our invoices, we attach an Excel spreadsheet that shows which jobs we have done during the month. The problem is that we display this information for many clients in different ways.

Currently, we run one process that gives us the raw information needed to bill clients. Then, we manually copy that information into the clients' Excel templates following the unique instructions for each. This can be automated.

The application you create would have available to it the raw information and a template for each client. Your application would populate a database with the raw information and then populate those templates.

See the attached Spec file for instructions.

The plan is to build automation that will handle the vast majority of our clients. Then we will need to work with you to do some additional customization for the clients with the most unusual Excel templates.

When we start working, I will show you an example of the raw information. It comes in an excel file with 3 columns: a file name (which must be parsed for information stored in it), a character count, and a line count. This is all the information required to populate the database described above.

This is a fairly straightforward project. After you spend an hour to get up to speed on everything, the solution will be readily apparent to you.

## Deliverables

Read the attached [url removed, login to view] file first. This will run you through the Fields and [url removed, login to view] file attached.

Habilidades: Engenharia, Microsoft, Microsoft Access, MySQL, Gestão de projetos, Arquitetura de software, Teste de Software, SQL, Área de trabalho do Windows

Ver mais: unusual jobs, one hour jobs, jobs working from, jobs available on line, application template excel, 12 month spreadsheet, project plan templates, it project plan template, windows automation, invoices/month, excel templates, excel speed, excel automate, database required in excel, database population, client database billing, populate excel spreadsheet spreadsheet, excel unique, excel additional, excel template database, excel count, read file specific line, automation excel spreadsheet, populate database, excel line work

Acerca do Empregador:
( 18 comentários ) United States

ID do Projeto: #2971368

4 freelancers are bidding on average $200 for this job


See private message.

$212.5 USD in 14 dias
(145 Comentários)

See private message.

$153 USD in 14 dias
(38 Comentários)

See private message.

$340 USD in 14 dias
(9 Comentários)

See private message.

$93.5 USD in 14 dias
(4 Comentários)

See private message.

$425 USD in 14 dias
(1 Comentário)