Procedure Manual for Integrated GSSMaker
1.

Download Integrated GSSMaker and the ECETOC TRA Tool

Download both Integrated GSSMaker and the ECETOC TRA Tool and save them in an appropriate
location on your computer.

The versions of Integrated GSSMaker and the ECETOC TRA Tool must match. The file name ofIntegrated GSSMaker contains the compatibility information for TRA Tool. The file naming rule ofIntegrated GSSMaker is as explained below.

GSSMaker_3.1en_v1d_2015XXXX.xls(1) (2)
(1)
(2)
(3)

(3)

The version number of the compatible TRA Tool is shown here. In this example, Integrated GSSMaker iscompatible with TRA 3.1.
The language of Integrated GSSMaker is shown here. The Japanese version is indicated as “jp” and the English
version as “en.” In this example, Integrated GSSMaker is a Japanese version.
The version and the release date of Integrated GSSMaker are shown here.

To download the TRA Tool, first open the download URL below and click the “Download IntegratedTool button” at the right side of the screen (indicated with a red circle in the screenshot image below).
Then, send the user information to start the download.

For detailed instruction on how to download, please refer to “GPS/JIPS Risk Assessment - Use of
ECETOC-TRA-” under “GPS/JIPS Seminar (Practice II)” in the Information Materials page of BIGDr.

[TRA Tool download URL] http://www.ecetoc.org/traFigure 1: TRA Tool download screen

12.

Enter the File Location of the TRA Tool in Integrated GSSMaker

Open Integrated GSSMaker. If a security warning is displayed, click the “Activate the contents” or“Activate macro” button.

Once macro is activated, the following message appears: “Going to website BIGDr To enable linkage
to the Help.Are you sure? (If you are already logged in,select "no")(Either do not affect the normaloperation.)”Please select either “Yes” or “No.”

Select the “Configuration” sheet and enter the file location (path) of the TRA Tool. In the example
below, the path is “C:\Users\1018795\Documents\GSSMaker\TRAv3.1/”. Please do not forget to put “/”at the end of the path.

Figure 2: The Configuration sheet of Integrated GSSMaker2

3.

Run the Tutorials

Integrated GSSMaker is equipped with the tutorial function in the “CheckScenario_English” sheet tohelp the users learn how to use the program.

The tutorial follows the steps described in the table below. By following these steps, you can go
through the general functions of Integrated GSSMaker.

Table 1: The procedure of tutorialStep1)
2)

Actions
Select “toluene” in the Chemical SubstanceName field
Enter the physiochemical properties andhazard assessment values (hazard referencevalues)

Notes
Toluene is selected as a default. If the default has not been changed,
there is no need to select again.
Enter values directly in the User-specified Values column when
specifying the “Human exposure via environment (total dailyintake).”[Calculate using Tier I – simplified mode]3)

Select “Tier I – simplified mode”

4)

Build scenarios

5)
6)

Click the “Run TRA” button
Confirm the results

7)

A GSS cannot be created

The simplified mode is selected as default. If the default has notbeen changed, there is no need to select again.
Scenarios are built as default. If the default has not been changed,
there is no need to build again.
The calculations take about 30 seconds.
 Worker scenarios: No. 1 – No. 4 resulted in RCRs < 1 Risk is controlled Consumer scenarios: No. 1 resulted in RCR ≥ 1
 Risk is of concern (need refinement)
 Environmental scenarios:
No. 1 – No. 2 resulted in RCRs ≥ 1  Need refinement
No. 3 resulted in an RCR < 1  Risk is controlled
Integrated GSSMaker is designed so that a GSS cannot be created if
any scenario has RCR ≥ 1.

[Calculate using the Tier I – normal mode](Refine the scenarios that resulted in RCR > 1 using the Specific Environmental Release Categories (SPERCs) provided by
CEFIC, instead of the environmental release categories (ERCs))
8)
9)

10)
11)

Select the Tier I – normal mode
Add a mixing rate to consumer scenario
No. 1. Select SPERCs for environmental
scenarios.
Click the “Run TRA” button
Confirm the results

12)

A GSS cannot be createdConfirm that the Tier I – normal mode is check-marked.
Change the sections indicated with a red circle in the Confirmation
scenario. (Refer to the “CheckScenario_English” sheet.)
The calculations take about 30 seconds.
 Consumer scenarios: No. 1 resulted in RCR < 1
 Risk is controlled
 Environmental scenarios: No. 1 resulted in RCR ≥ 1
 Risk is of concern (needs refinement)
No. 2 resulted in RCR < 1
 Risk is controlled-[Calculate with the Tier II mode](Refine the scenarios that resulted in RCR > 1 using the actual amounts of releases, such as a PRTR release amount, insteadof using the emission factors set up for the ERCs and SPERCs.)
13)
14)
15)
16)
17)

Select the Tier II mode
Add an amount of release to environmental
scenario No. 1
Click the “Run TRA” button
Confirm the results
Click the Create GSS button  A GSS
sheet is createdConfirm that the Tier II Mode is check-marked.
Change the section indicated with a red circle in the Confirmation
Scenario. (Refer to the “CheckScenario_English” sheet.)
The calculations take about 2-3 minutes.
Environmental scenario: No. 1 resulted in RCR < 1 Risk is controlled
The created GSS will be overwritten the next time you click thebutton. If you wish to save the GSS, move or copy the sheet and saveit as a different file.

34.

Enter the Calculation Mode, Name and Information of the Chemical Substance, andBuild Scenarios

Enter the name and information of a chemical substance and build scenarios in the Main sheet.

(2) Select calculation
mode. Please refer to theother sheet for the detailsof each mode. (SelectTier I if you just wish totry the calculations.
Select Tier II if you wish
to set up the parametersin detail.)(1) Enter substancename. If thesubstance of interest
is available in thechemical DB, selectthe substance namefrom the pull-downlist.

(3) Enter physicochemical
properties and hazard
information of the substance tobe evaluated.
If the substance is selected fromthe pull-down list mentioned in(1), the stored information forthe substance (default values)
appears automatically. If you
wish to use different values,
enter them manually in theUser-specified values column
on the left. (Enter the values for
only the parameters you wish tospecify.)(4) Select and build theuse scenarios for thesubstance from the pulldown list. Four scenarios
are built as default. Delete
the ones that are
unnecessary. If you wishto add more than five
scenarios, click the “Openexpansion area” button tobuild a maximum of tenscenarios.

Figure 3: The “Main” sheet of Integrated GSSMaker4When the “Tier I - normal mode” is selected as the calculation mode, SPERC codes can be selected asparameters for environmental exposure assessment. To see the descriptions of the codes, right click theSPERC code selection cell and choose “GSSMaker: Show Description” from the menu displayed. The
list of selectable codes and their descriptions is opened in a different sheet. Select the applicable codeon the main sheet after confirming the list.
Right click the cell and select“GSSMaker: ShowDescription” form the menu
displayed

The selectable codes andtheir descriptions are
displayed in the“SpercDescription_English”
sheet of GSSMaker.

A button to return to themain sheet

Figure 4: Refer to the code descriptions when selecting the SPERC codes(Only for Tier I - normal mode)

Information of the substances that can be selected in the “Substance Name” field of the “Main” sheet
is available in the “SubstanceDB” sheet.

You can add and save your own substance names, physiochemical properties, and hazard informationin the rows below the Substance ID 20. By selecting an added substance name which appears in the“Substance Name” field of the “Main” sheet, the information added by the user will be enteredautomatically.

5(1) You can add your own
substance names in the“SubstanceDB” sheet in therows below the Substance
ID 20 (indicated by the redframe).

(2) The added substancename will appear in the“Substance Name” field of
the Main sheet. By selecting
the added substance, its
information added by theuser will be enteredautomatically (indicated bythe red frame).

Figure 5: How to save a new substance to the “SubstanceDB”

65.

Perform the TRA Calculations and Confirm the Results(1) Perform the TRA calculations
After entering all the necessary information, press the “Run TRA” button. The TRA tool is launched
and the calculations will be performed.

Figure 6: The Run TRA button on the “Main” sheet of Integrated GSSMaker*How to stop the message about link updates
A message stating “This workbook contains links to other data sources. If you update the links, Excel attempts toretrieve the latest data. If you don't update, Excel uses the previous information” may appear by clicking the “RunTRA” button. This message appears when you open a workbook that contains links to the other workbooks.
To prevent this message from appearing, please follow the steps below. Once you configure this setting, the message will notreappear.
(1) Display a configuration file of the TRA Tool titled “ecetocTRAM.xls.”(2) From the Excel menu, select “Data  Edit Links” to open the Edit Links dialog box.
(3) Click the “Startup Prompt” button to open the Startup Prompt dialog. Select “Don’t display the alert and don’t update
automatic links.”(4) Save the ecetocTRAM.xls file. (Saving other configuration files for the TRA Tool is not necessary.)7

(2) Confirmation and evaluation of the resultsOnce the calculations are completed, the risk characterization ratios (RCRs) are updated.
The RCRs are displayed in blue when RCR < 1 and in red when RCR ≥ 1. For the scenarios that
resulted in RCR ≥ 1, refine the scenario buildings. (GSSMaker is designed so that a GSS cannot becreated if any scenario has RCR ≥ 1.)* The image below shows the results of an assessment performed by the ECETOC TRA 3.1. The
results vary depending on the version of a TRA.

RCR ≥ 1 is displayed inred. Refine the scenario.
(A GSS cannot becreated when RCR
remains above 1.)

Figure 7: The results of an assessment performed by the ECETOC TRA 3.1.

8

 When RCRs exceed 1, display and refer to the “Checkpoint” for considering how to deal
with the results. Choose “Display the Checkpoint when an RCR > 1” to show the points
in popup balloons.

“Checkpoint when RCR>1" appear in popupballoons

Check the checkbox to display“Checkpoint when RCR > 1”

Figure 8: Display of the Checkpoint when RCR > 19

6.

Create and Save a GPS Safety Summary (GSS)

After the TRA calculations, confirm that all RCRs are below 1. Then, click the “Create GSS” button tocreate a GPS Safety Summary (GSS). A GSS is created automatically. (Diagram 10)
A “GSS” sheet appears once the GSS is completed. The contents of the GSS can be edited. Edit and/orcorrect the contents as necessary. In the “Exposure” and the “Risk Management Measures” sections,the phrase options are listed on the right side of a GSS template sheet.

List of phrase options isdisplayed on the right side ofa GSS template sheet createdby Integrated GSSMaker.

Figure 9: List of phrase options on GSS sheet
The GSS and “TRA_Results” sheets will be overwritten. If you wish to keep the created contents,
copy the sheets and save them as a different file. (Figure 11, 12)10Figure 10: GSS Creation Process of Integrated GSSMaker11

(1) Right click the “GSS” sheet taband select “Move or Copy”.

(2) Choose (new book) from the “To book”
drop-down list. In addition, check the“Create a copy” checkbox at the bottom.

(3) After (2), it should look like the image on theleft. Click “OK” to copy the GSS sheet into a
new Excel file. Name and save the file tocomplete the saving process of a GSS.

Figure 11: How to copy a GSS sheet to another file.

12

(1) Right click the “TRA _Results” sheet
tab and select “Move or Copy.”(2) Choose (new book) from the “To book” dropdown list. In addition, check the “Create acopy” checkbox at the bottom.

(3) After (2), it should look like the image on theleft. Click “OK” to copy the TRA Calculation
Results sheet into a new Excel file. Name andsave the file to complete the saving process ofthe TRA calculation results.

Figure 12: How to copy the “TRA_Results” sheet to another file.

13

The language of a GSS (Japanese or English) can be selected with the English
version of Integrated GSSMaker. Choose a language for a GSS and click CreateGSS. A GSS will be created in the selected language.

14