# Industrial waste management sheet

> Industrial waste log in Excel: waste types, generation, storage areas, contractor pickups, licence expiry alerts, diversion rate and net cost by month.

Source: https://softwiro.com/templates/industrial-waste-management
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Industrial waste management sheet: quantities, classification, recycling and cost

A free Excel sheet for an environmental officer or factory owner. You enter your waste types (hazardous or not, recyclable or not, and the treatment route: sale to a recycler, reuse, licensed disposal or landfill) with the selling price per ton or the disposal cost. Then you record what each department generates and each handover to a contractor with a manifest number. The sheet calculates the stock left in each storage area and how long it has been there against your limit. It warns you when a contractor's licence has expired or is about to, and works out waste per 1,000 units produced, the diversion rate, and revenue, cost and net by month. Prices, periods, capacities and licence numbers in the example are illustrative. Classification, storage, transport and licensing follow local law and the requirements of the Egyptian Environmental Affairs Agency (EEAA), and the sheet is for records and accounts only.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-industrial-waste-management.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-industrial-waste-management-blank.xlsx)

Excel file (.xlsx) · 133 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

## Example from the sheet

| التاريخ | رقم المانيفست | المقاول | نوع المخلفات | الكمية (كجم) | المسار | المبلغ | تنبيه |
| --- | --- | --- | --- | --- | --- | --- | --- |
| 46293 | MN-1001 | مدوّرو الدلتا للورق والبلاستيك | كرتون وورق | 4,200 | بيع لمدوّر | 10,500.00 |  |
| 46293 | MN-1001 | مدوّرو الدلتا للورق والبلاستيك | بلاستيك (سكراب) | 1,100 | بيع لمدوّر | 6,600.00 |  |
| 46301 | MN-1002 | تجار الخردة المتحدون | خردة معدنية | 2,300 | بيع لمدوّر | 31,050.00 |  |
| 46307 | MN-1003 | شركة النظافة العامة | مخلفات عامة | 2,600 | مدفن | 1,170.00 |  |
| 46309 | MN-1004 | البيئة الآمنة لمعالجة المخلفات | زيوت مستعملة | 640 | تخلص مرخّص | 768.00 |  |
| 46309 | MN-1004 | البيئة الآمنة لمعالجة المخلفات | عبوات كيماويات فارغة | 380 | تخلص مرخّص | 1,064.00 |  |
| 46315 | MN-1005 | مدوّرو الدلتا للورق والبلاستيك | كرتون وورق | 5,100 | بيع لمدوّر | 12,750.00 |  |
| 46321 | MN-1006 | إعادة استخدام داخل المصنع | أخشاب وبالتات | 1,800 | إعادة استخدام | 0.00 |  |

Example from the “المناولة” tab (Arabic), with the numbers and formulas that are in the file.

## What is inside

- الإعدادات (Settings): Today's date, the first month of the indicators, the date you started recording waste, the number of days of warning before a licence expires, and the list of factory departments and lines that feeds the generation log.
- مناطق التخزين (Storage areas): Each area with its maximum storage period and capacity in kilograms. Beside it: current stock, fill percentage, the number of types that exceeded the period, and an alert for period or capacity. It holds 10 areas.
- المقاولون (Contractors): Each party that takes the waste, with its licence number (as text), scope and expiry date. Beside it: days remaining, licence status, number of handovers, quantity, revenue and cost. It holds 30 contractors.
- أنواع المخلفات (Waste types): Each type with its classification, recyclability, treatment route, selling price per ton, disposal cost and storage area. Beside it: generated, handed over, stock, last handover, storage days and an alert. It holds 50 types.
- سجل التوليد (Generation log): Everything generated, by date, department or line, type and kilograms, with an alert for an unknown type or a missing quantity. It holds 500 rows.
- المناولة (Handovers): Each pickup with its date, manifest number, contractor, type and quantity. It shows the licence number and date, route, price per ton and the amount as revenue or cost, with an alert if the licence had expired at the time of handover or the type is outside its scope. It holds 300 rows.
- المؤشرات الشهرية (Monthly indicators): You enter each month's production in units, and the sheet calculates for each month the waste per 1,000 units, hazardous share, diversion rate, revenue, cost, net and net cost per unit.
- الملخص (Summary): Quantities in tons, diversion rate, cost and net, storage and licence alerts, monthly tables and tables by type and by department, with five charts.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

## What makes it different

The sheet links what is generated to what is handed over. It shows how much is left in each area and for how many days, exposes a contractor whose licence had expired when they collected, and calculates how many kilograms of waste leave with every 1,000 units you produce and how much of it was diverted from disposal.

## How to use it

1. In the «الإعدادات» (Settings) tab, enter today's date, the date you started recording waste, the days of warning before a licence expires, and the factory departments and lines.
2. In «مناطق التخزين» (Storage areas), enter each area with its maximum storage period and capacity in kilograms (as you determine and as the competent environmental authority requires).
3. In «أنواع المخلفات» (Waste types), enter each type with its classification, treatment route, selling price or disposal cost per ton, and storage area (the numbers in the example are illustrative).
4. In «المقاولون» (Contractors), enter each party that collects waste from you with its licence number (as text), scope and expiry date.
5. Record everything generated in «سجل التوليد» (Generation log) with date, department, type and kilograms, and every pickup in «المناولة» (Handovers) with manifest number, contractor, type and quantity.
6. In «المؤشرات الشهرية» (Monthly indicators), enter each month's production in units, then review «الملخص» (Summary) and the alerts.

**Before you start:**

- The sheet is for records and accounts only. Classification, storage, transport, licensing and required documents follow local law and the requirements of the Egyptian Environmental Affairs Agency (EEAA) and other competent authorities, and the sheet does not replace them.
- Selling prices, disposal costs, maximum storage periods and capacities in the example are illustrative numbers that you replace with your own and with what the competent authorities decide. The licence numbers written in the sheet are fictional.
- Storage days = today's date - date of the type's last handover (or the recording start date if there has been no handover), calculated for a type that still has stock. This is an estimate of the age of the stock, not tracking of each shipment.
- Diversion rate = quantity sold to a recycler or reused / total waste handed over in the period. Revenue and cost are by handover date.
- Amount = kilograms / 1000 x price per ton. The price per ton comes from the Waste types tab (the selling price if the route is "sale to a recycler", otherwise the disposal cost), or the actual price if you enter it on the handover row.
- The sheet holds 50 types, 10 storage areas, 30 contractors, 500 generation rows and 300 handover rows, and the Summary shows 6 months, 10 types and 8 departments.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-industrial-waste-management.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-industrial-waste-management-blank.xlsx)

Excel file (.xlsx) · 133 KB · 10 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

[![Cheat sheet: industrial waste management (1/3)](https://softwiro.com/uploads/cheatsheets/industrial-waste-management/en-1.jpg)](https://softwiro.com/uploads/cheatsheets/industrial-waste-management/en-1.jpg)[![Cheat sheet: industrial waste management (2/3)](https://softwiro.com/uploads/cheatsheets/industrial-waste-management/en-2.jpg)](https://softwiro.com/uploads/cheatsheets/industrial-waste-management/en-2.jpg)[![Cheat sheet: industrial waste management (3/3)](https://softwiro.com/uploads/cheatsheets/industrial-waste-management/en-3.jpg)](https://softwiro.com/uploads/cheatsheets/industrial-waste-management/en-3.jpg)

0 downloads · 3 pages

## Still running this on Excel?

This sheet suits a start and a limited amount of data. If your way of working grows, or you need more than one person working on it at the same time, Softwiro can build you a program that fits the way you work.

| In this sheet | In Custom Software from Softwiro |
| --- | --- |
| One file that one person edits at a time, and copies reach you on WhatsApp. | A program with a login for each user and permissions you define, and everyone sees the same data. |
| You type everything and check the numbers by hand. | We design the screens around your work steps, so each person records only what concerns them. |
| Columns and formulas are fixed as the sheet was designed. | We build what you need: reports, alerts and screens your way. |
| Backups and security are your own responsibility. | The program runs on a secured server with regular backups. |

[See Custom Software from Softwiro](https://softwiro.com/contact) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| One file that one person edits at a time, and copies travel by WhatsApp. | A program with a login for each user and permissions you set; everyone sees the same data live. |
| You type and check every number by hand, and one wrong cell breaks the result. | Screens built around your steps: each person records only their part, and the calculations run on their own. |
| Limited size; the file slows down as the data grows. | Holds years of data without slowing down, with instant search and filters. |
| Fixed columns and reports, as the sheet was designed. | Reports, alerts, printing and WhatsApp built around how you work. |
| Backups and security are your own responsibility. | A secured server with automatic backups and a log of who changed what and when. |

### Extra features in the app

- A login for each user with permissions, and a log of who changed what and when
- Automatic reminders and alerts by WhatsApp and email
- Photos, files and documents kept with each record
- Instant search and filters, with reports exported to PDF and Excel
- Works from a phone anywhere, with automatic backups

[Ask for your custom system](https://softwiro.com/contact)

## Frequently asked questions

### Does the sheet decide how waste is classified or what its storage and transport conditions are?

No. The sheet is for records and accounts only. You enter the classification, storage periods and capacities from your own documents. Classification, storage, transport and licensing follow local law and the requirements of the Egyptian Environmental Affairs Agency (EEAA) and other competent authorities.

### How is the diversion rate calculated?

Diversion rate = quantity sold to a recycler or reused / total waste handed over in the period. It is calculated by handover date, not generation date.

### How are storage days calculated?

For each type with stock remaining: today's date - date of its last handover, or the recording start date if there has been no handover. It is an estimate of the age of the stock, not tracking of each shipment, and it is compared with the maximum period you entered for the storage area.

### How does the sheet know a contractor's licence has expired?

You enter the licence expiry date in «المقاولون» (Contractors). The sheet warns you the number of days before expiry that you set, and flags any handover dated after the licence expired. The licence number and scope are text you copy from the licence itself.

### Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

### Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

### What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

### Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL [https://softwiro.com/api/mcp](https://softwiro.com/api/mcp), no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: [https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html](https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html)

All the templates in this group: [Factory management sheets: production, cost and quality](https://softwiro.com/templates/for-factories)

More free templates for: Factories and production

## More free templates

- Electronics factory sheet: BOM, production and quality
- Food factory sheet in Excel: recipes, batches, cost and shelf life
- Biscuit factory sheet: dough, lines, packing and scrap
- Detergent factory sheet: formulas, batches, cost and filling
- Detergent ingredients and their names: function, chemical name and use
- Pharma factory sheet: batch records, materials, QC and release
- Algebra rules summary sheet: laws, identities and solving equations with examples
- Solid geometry formulas sheet: areas and volumes with examples and a calculator
- Livestock and dairy farm sheet
- Complete farm management sheet in Excel: plots, workers, crops and sales
- Agricultural waste management sheet: rice straw, residues, compost and recycling
- Trip organizer sheet: participants, instalments, costs and itinerary
- Building maintenance sheet: flat fees, expenses, elevator and pump
- Canteen management sheet

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
