#1
|
|||
|
|||
Report template automation
We provide measurement services, which are conducted according to different standards, such as US EPA, ISO, or EN, as per customer requirements. Each standard has different accredited methods, for various analytes, their sample collection, and analyses. The technical report specifies the standard and itemises and describes the methods as well as site conditions. The numerical results are produced in Excel and attached as addendums. The report body is a mix of paragraphs and tables.
The current report template has all options in it and the report writer deletes the bits that are not applicable. The template is approximately 8,000 words and a simple final report is typically under 3,000 words. A typical section will consist of paragraphs describing the method together with a table of site conditions and whether they satisfy the standard. For different standards, there will be different words and tables. Furthermore, if measurements are conducted at more than one source, it is not just a copy and paste for the extra source/s, because they can be conducted to different standard/s. I am looking for a system in which I can enter the items below into the Scope of Work section, using dropdown lists, which will then appropriately populate the rest of the template. 1. Number of sources. 2. Standard for each source. 3. Methods and analytes for each source. • The tables can then be filled in. • The paragraphs should allow for minor editing. In addition, some information, such as plant name and project title, has to be repeatedly entered in different sections, such as the title page, header, executive summary, etc. For this, I am looking for a system that if I enter this information in one section, and it automatically copies it to the other sections. I there an application that will do all this for me, or do I have to develop my template requirements using VBA? |
#2
|
|||
|
|||
There is no application exactly.
Look into Boiler - Insert a selection of documents by Graham Mayor, MVP. Look into AutoText: Automated Boilerplate Using Microsoft Word You can use conditional text with an IF Field that will test for a condition you set. If you go the vba route you may still use some of these techniques to hold the parts to be inserted. I would recommend a UserForm. Create a Simple Userform by Graham Mayor, MVP Create & Employ a Userform by Greg Maxey, MVP |
#3
|
|||
|
|||
Thank you, Charles
Dear Charles,
Thank you for a most informative response. I have browsed through the links and at first glance it looks like just what I need. As an engineer, I didn’t realise that the lawyers had a solution and name for it. To me, boiler plate is what you use to make a boiler. I will work through it and see how I get on, before asking more questions, which I am sure will come. Thanks again. Frans |
Tags |
automation, input, template |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Advice/help with a template for a report | mitworray | Publisher | 2 | 04-29-2019 10:07 AM |
Report Template with numbered lists | gincity5 | Word | 2 | 04-25-2017 10:49 AM |
Automation Process of Schedule Report Output and Report Check Score Card ! | ozman86 | Word VBA | 1 | 11-19-2014 11:52 PM |
Excel to Access to Excel for report automation | Nicholaspoe | Excel Programming | 10 | 10-08-2013 08:13 PM |
Building a customisable report template | razberri | Word | 1 | 01-12-2012 11:36 AM |