If there is a contradiction in health, sanitation and the environment in the 21st century, it is that Health areas (especially provincial, municipal and private, in that order) are one of the biggest polluters of the environment.

​

For this reason and understanding the current problems regarding the generation, quantification, and treatment of the same, develop an Excel program to be able to keep track of the Pathological Waste that is generated daily and is withdrawn by the supplier. authorized for further treatment. At the same time, it allows us to control the costs that we incur for your treatment and the invoice that the treater then issues to us.

It allows uploading up to 7 years of information, although it can be extended if required.

The program has 2 Files:

The first is the "Monthly" form where we record daily the Manifest Number and Number of Kilos withdrawn by our supplier, then this information is passed to our "Base" file which I describe below:

The “Base” program has the following sheets:

Generation A table:

The following data is loaded into this table:

* Year and Name of the Laboratories.

* Total Kg Generated by the Laboratories (Maximum 3, being able to expand at the request of the client) and Kg per Laboratory.

* Number of total patients.

* Reports the following information: Average Total Monthly Kg , Total Kg x Branch, Gr x Total Patient, Total Cost of RP treatment, * * Cost of RP treatment x Patient

Generation B table:

The following data is loaded into this table:

* Kg Generated by Laboratories.

* Number of Patients x Laboratory

*  Reports the following information: Grs. x Patient x Laboratory and PR treatment cost x Patient

Graphics:

In this tab are the graphs of "Generation of total pathological waste x Month x Year" (One graph for each year)

Gr x Patient:

In this tab is the Graph of "Generation of Gr. of total pathological residues x Month and its trend line" (A graph)

$ x Patient:

In this tab is the Graph of "Costs x patient x Month and its trend line" (A graph)

Comparative:

In this tab you will find the "Comparison x Month x Year  of the total amount of RP" graph (One graph)

Kg x Branch:

In this tab you can find the Graph of  “Comparison x Month of the RP generated by each branch” (One graph)

Gr x Pac x Branch:

In this tab you can find the Graph of  “Comparison x Month of the Gr. x Patient of RP generated by each branch” (One graph)

 Price list:

This table shows the costs per Kg of RP treated that our supplier charges us monthly.

​

​