Automation of report creation process.

  • Posted
  • Proposals 2
  • Remote
  • #14603
  • Expired
Muhammad A.Big T. have already sent a proposal.
  • 0

Description

Experience Level: Intermediate
We currently have a procedure which involves the manual combination of a number of processes to produce a single report. We require help in automating the process to provide a single final document. This involves combining Word, Excel, an Excel Macro, and Adobe Acrobat Pro. A simplified out line of process is detailed below:

1: On site number readings are taken on a hand held devise and stored to an SD card.

2: On site details specific to the reading are hand written on to a pre-prepared printed Word document.

3: Remote from site a MS Excel macro using the measurements stored on the SD card is run a number of times to produce part of a report.

4: Additional information from the Word document is added to the report generated by the macro.

5: A summary report from the information in part four is manually created.

6: An additional prepared Word Document template is added.

7: All these docs are merged using Adobe Acrobat 9 Pro to create a secure PDF.

The plan is to use a laptop PC on site to replace the hand written details. All the information required for the final report would be available in electronic formats. Programming to pull all the information is required.

If you are interested I am aware that pricing this with out a full brief will be difficult, therefore I am hoping to get responses from interested parties then discuss the requirement in more detail.

Clarification Board

    There are no clarification messages.