Support Page for Waste Transfer Note
The information provided in this section is a detailed description of the features within the Waste Transfer Note. Please choose a topic category from below:
- Installation instructions and requirements
- General overview of the Waste Transfer Note
- Features within Section B: Current holder of the waste
- Features within Section C: Person collecting the waste
- Features within Section D: The transfer
1. Installation instructions and requirements
This electronic copy of the Waste Transfer Note is based on Microsoft Excel® and therefore requires no installation as such. It requires that a copy of Microsoft Excel® is installed on your computer, and that this spreadsheet is also on your computer.
This spreadsheet has been successfully tested on Excel versions from 97 to 2007.
The features within this Waste Transfer Note are written using Visual Basic for Applications (VBA) and require that you allow macros to be run. If you haven’t already enabled macros to run, it is recommended that you do so by choosing Macro Security in the drop down Tools menu within Excel, and set the protection to Medium. In the 2007 version of Excel, the macro protection option can be found within the Security Centre.
To open the Waste Transfer Note, simply double click on the file name as you would with any spreadsheet and select ‘Enable Macros’ in the pop up box that appears.
2. General overview of the Waste Transfer Note
This Excel based version of the Environment Agency Waste Transfer Note (WTN) is designed to be as similar to the original as possible. The Environment Agency provide their WTN in PDF or paper format only, forcing them to be hand-written. By basing the WTN on Excel, you can save, copy and amend your Transfer Notes, and then print them when needed.
In addition to the standard Excel functionality, this version also contains a series of save and recall buttons that make completing the WTN even easier and faster, particularly where you have regular customers, carriers and waste depots that you use.
It is important to remember not to email your spreadsheet to anyone, as all the information that you have saved within it, as well as the added functionality will be given away!
3. Features within Section B: Current holder of the waste
| Button Name | Action |
|---|---|
| Clear Section B | This button clears the contents of all the cells highlighted in yellow above. |
| Retrieve Section B Data | A drop-down list within a pop-up menu will appear and you will be able to select previously saved Section B details. All cells highlighted in yellow will be replaced with the newly selected details. |
| Save Details to Database | A pop-up menu will ask you to provide a save name for all of the details contained in the yellow highlighted cells. |
4. Features within Section C: Person collecting the waste
| Button Name | Action |
|---|---|
| Clear Section C | This button clears the contents of all the cells highlighted in yellow above. |
| Retrieve Section C Data | A drop-down list within a pop-up menu will appear and you will be able to select previously saved Section C details. All cells highlighted in yellow will be replaced with the newly selected details. |
| Save Details to Database | A pop-up menu will ask you to provide a save name for all of the details contained in the yellow highlighted cells. |
5. Features within Section D: The transfer
| Button Name | Action |
|---|---|
| D1 = B1 | The company name and address from Section B1 at the top of the form will be copied into the yellow highlighted cells. |
| Retrieve Collection Address | A drop-down list within a pop-up menu will appear and you will be able to select previously saved Section D1 details. All cells highlighted in yellow will be replaced with the newly selected details. |
| Save Collection Address | A pop-up menu will ask you to provide a save name for all of the details contained in the yellow highlighted cells. |
| Clear D1 | All contents of the cells highlighted in yellow, and the content of the cell ‘Date of Transfer’ will be cleared. |
| D2 = N/A | Where no broker has been used, the first cell highlighted in purple will have N/A (i.e. not applicable) written into it. |
| Retrieve Broker Details | A drop-down list within a pop-up menu will appear and you will be able to select previously saved Section D2 details. All cells highlighted in purple will be replaced with the newly selected details. |
| Save Broker Details | A pop-up menu will ask you to provide a save name for all of the details contained in the purple highlighted cells. |
| Clear D2 | All contents of the cells highlighted in purple, and the content of the cell ‘Time(s)’ will be cleared. |