Environmental Benefits Fact Sheet
The NERC Environmental Benefits Calculator provides you with the opportunity to summarize your accomplishments through an Environmental Benefits Fact Sheet. This Word document summarizes the results of your inputs to NERC's Environmental Benefits Calculator by summarizing the benefits of source reduction, reuse, and recycling. It is intended to be used as a tool for educating the public, legislators, and state and municipal employees about the impact and benefits of sustainable waste management strategies. It is also intended as a reference for developing outreach materials (i.e., press releases, presentation slides, educational curricula, and articles) by waste prevention officials and advocates.
Instructions on filling out the Fact Sheet: In order to use the Fact Sheet you first need to download it. But before you do, read the following instructions. The Fact Sheet relies on a mail merge function that requires you to take certain steps.
Before Opening
the Word Document:
When opening the Fact Sheet in MS Word, you may encounter two dialogue boxes. In the first dialogue box, choose the option to open the document in Microsoft Office Word. The second dialogue box may say, "Opening this document will run the following SQL command.." Do not select either option; instead, close this dialogue box by clicking on the "X" in the upper right corner of the box. |
To create your area’s data-specific Fact Sheet, first download and save the Calculator in Microsoft Excel format and the Fact Sheet in Microsoft Word. The Fact Sheet is automated through Microsoft Word’s Mail Merge Feature.
Complete the Calculator (Excel document) and save it on your computer. Then open the blank Fact Sheet in Word.
In Word, display your Mail Merge toolbar. Depending on which version of Word you are using, there are different ways for this to happen:
A. By selecting "View" and then "Toolbars” or
B. Mailings “Start Mail Merge.”
Depending on whether you used “A” or “B” follow the instructions below.
For A
- From your Mail Merge toolbar, click on "Open Data Source."
a. Select the Calculator Excel file.
b. Select "Wksh 5. Fact Sheet Outputs" worksheet and unclick the box that says the data is in the first row (box should be empty)
- Again from your Mail Merge toolbar, click on "Merge to New Document." Be sure that the "mail merge recipients" button (third button from the left) says that only one row is selected and click ok.
Note that there are other routes to completing the mail merge through the main Word toolbar under "Tools."
- Save the document on your computer with a new name.
- Read through the document and edit it to fit your circumstances and the data you entered. For example, if you did not enter any source reduction or reuse figures, delete these references. Also, we suggest that you do a spell check to be sure all the spacing and grammar is correct (depending on the name of your state, there may be a problem with apostrophes).
For B
- From your Mail Merge toolbar, click on “Start Mail Merge.” Select “Letter.”
- The “Select Recipients.” Open the Excel file you created with your own data.
- Select "Wksh 5. Fact Sheet Outputs" worksheet and unclick the box that says the data is in the first row (box should be empty).
- Still in the toolbar, go to the Preview Results area. Be sure that the number 1 appears in the box above, and click on Preview Results. This will display the merged document.
- Then click on “Finish & Merge.” Select “Edit individual documents,” and then “all records.” Then save as your merged document.
- Read through the document and edit it to fit your circumstances and the data you entered. For example, if you did not enter any source reduction or reuse figures, delete these references. Also, we suggest that you do a spell check to be sure all the spacing and grammar is correct (depending on the name of your state, there may be a problem with apostrophes).
|
