Hotspot Analysis: Stage Totals with SUMIFS, Shares, a Chart & Highlights
This lesson is part of the course
In this lesson
You sum a line-item inventory into five life-cycle stages, calculate the share of each stage, chart the stages and highlight every stage above 10% of the footprint: the hotspots where redesign pays off.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Functional Unit & Reference Flow: Comparing Products Fairly Locked
- Materials Stage: Bill of Materials × Emission Factors with Scrap Locked
- Manufacturing: Plant Energy, Allocation by Machine Hours vs Mass Locked
- Distribution: Tonne-Kilometres, Transport Modes & the Air-Freight Trap Locked
- Use Phase: Electricity per Year, a Falling Grid Factor & Overfilling Locked
- End of Life: Recycling, Incineration, Landfill & Avoided-Burden Credits Locked
- Hotspot Analysis: Stage Totals with SUMIFS, Shares, a Chart & Highlights Locked
- Eco-Design Comparison: Baseline vs Redesign per Functional Unit Locked