How to Use the Scenario Reporter
Originally published: 10/10/2018 14:45
Last version published: 16/10/2018 09:17
Publication number: ELQ-35370-2
View all versions & Certificate
certified

How to Use the Scenario Reporter

This effective scenario reporter is accompanied by a clear and easy-to-follow PDF guide and YouTube Tutorial.

Description
This Scenario Reporter is an efficient way of automatizing the recording of multiple scenarios into an Excel sheet.

A scenario is a set of values, that can be saved by Excel, and can be added onto another worksheet. A user can design and then save multiple sets of values as scenarios and then interchange between them to produce different results. This becomes an efficient means of running experiments on a data set as it removes the task of having to rewrite and re-enter the sets of values each time. Many different variables and potential variables can be assessed with a measure of simultaneity.

This scenario reporter is actually rather simple to use. The user does not need to know any VBA (Visual Basic for Applications – which is a programming language used for creating user-defined functions and automating processes/calculations on programmes). The only step required is to download the tool and start a new sheet on Excel. The file must remain open for the scenario reporter to run.

In any case, attached to this download is a helpful PDF guide that will provide a simple step-by-step tutorial on how to get started using the scenario reporter. In addition, there is a 14minute YouTube tutorial which efficiently illustrates the processes.

This Best Practice includes
1 Excel Tool, 1 YouTube Video, 1 PDF

Prof. Ed Bodmer offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.7 / 5 (11 votes)

please wait...