Member-only story
Improve your street cred by putting a dashboard on your spreadsheets
I work for a healthcare facility and must use Excel to prepare statistical figures and charts for the waste that is removed from the facility. You would be amazed just how complex waste management can be because all waste has to be organised into different categories.
Just a few of the categories that waste falls into are:-
- Offensive healthcare waste
- Waste that needs to be incinerated
- Waste that needs to be treated
- Commercial waste
- Confidential waste
- Pharmaceutical waste
- Sharpes
- Card and paper
Each category of waste is put into a different type of bin, and all bins need to be accounted for.
Every month I am required to print off the copious invoices generated for each location that waste is disposed of and compare them to the spreadsheet invoice that is also generated, noting any queries.
In addition, I have to keep track of the cost and weight of the waste that is disposed of each month, specifically focusing on the three major categories of:-
- Offensive healthcare waste
- Waste that needs to be…
