Automatic checklist based publishing report system?

Posted on 2007-03-22
Last Modified: 2012-08-13
I am searching for a method to develop an automated published report process based on a series of yes or no critera.

Our office does program inspections that follow strict policy and instructional guidance and we normally are required to follow a checklist and manually draft up a report.  What we would like to do is utilize our tablet PC's to setup a YES / NO / NA checklist so that based on each selection it will automatically insert a predetermined paragraph in to a document based on the current item number for the checklist.  By the time we complete the entire checklist most of our program review report will already be prepared with minimal manual preperation.

Does anyone know of any specific software that is currently on the market that can be utilized for this and the degree of complexity that is required to operate it effectively?  Or perhaps this sort of task is only avaliable through custom programming.  I am not specialized in programming; however, if that is the only route which type of code is best used to interact with MS office and would be most properly suited for this project?
Question by:Spazalaz
LVL 17

Assisted Solution

RDAdams earned 100 total points
Comment Utility
We use a spreadsheet with our yes/no type criteria.  Once our data is input is directs us to the proper template to use.  So we are using MS Excel and MS Word templates for ours.  

I cannot share ours as it is proprietary data.
LVL 31

Accepted Solution

moorhouselondon earned 400 total points
Comment Utility
You could put the questions in a spreadsheet (as mentioned by RDAdams), then use the macro language in your word processor to look across into the spreadsheet at the value of each Yes/No cell in turn to decide whether to insert a paragraph (from file) into the text (IF cell contents=Yes THEN insert parax).  It might be that "Yes" inserts one para, "No" inserts a different para, which would mean the use of IF THEN ELSE.

What you would do is save the spreadsheet, go into the wordprocessor, and run the macro.

If using Word then you would use VBA (Visual Basic for Applications), which is built into MS Office Apps, but other Office applications also have similar macro languages.

Care has to be taken that the cells in the spreadsheet don't change.  If some bright spark decides to add a fancy heading or similar to the spreadsheet then this may mess up which cell is referenced.  If you give the answer Cells a name this would reduce the effect of that problem.

Author Comment

Comment Utility
Thanks, I understand the concept completely, I just have a faulty grasp of even simple visual basic, until I have the time off of primary projects I will have to find additional assistance.  I will post another question for help with the code specifics.  As for this question, i believe it has been fairly answered.

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

If your app took Google’s lash recently, here are the 5 most likely reasons.
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Viewers will learn how to use the Hootsuite Dashboard.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now