Softwiro
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.

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

Example from the “المناولة” tab (Arabic), with the numbers and formulas that are in the file.
التاريخرقم المانيفستالمقاولنوع المخلفاتالكمية (كجم)المسارالمبلغتنبيه
46293MN-1001مدوّرو الدلتا للورق والبلاستيككرتون وورق4,200بيع لمدوّر10,500.00
46293MN-1001مدوّرو الدلتا للورق والبلاستيكبلاستيك (سكراب)1,100بيع لمدوّر6,600.00
46301MN-1002تجار الخردة المتحدونخردة معدنية2,300بيع لمدوّر31,050.00
46307MN-1003شركة النظافة العامةمخلفات عامة2,600مدفن1,170.00
46309MN-1004البيئة الآمنة لمعالجة المخلفاتزيوت مستعملة640تخلص مرخّص768.00
46309MN-1004البيئة الآمنة لمعالجة المخلفاتعبوات كيماويات فارغة380تخلص مرخّص1,064.00
46315MN-1005مدوّرو الدلتا للورق والبلاستيككرتون وورق5,100بيع لمدوّر12,750.00
46321MN-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.

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)Cheat sheet: industrial waste management (2/3)Cheat sheet: industrial waste management (3/3)
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 sheetIn 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 · Ask for a demo

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, 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

All the templates in this group: Factory management sheets: production, cost and quality

More free templates for: Factories and production

More free templates

All templates · Free tools