The Sustainability Perils of E-commerce (II): Fast and Furious (Fuming)?
In an early post, I talked about the upsides and downsides of e-commerce logistics on the environment. The main idea there is that e-commerce can potentially reduce CO2...
Excel Pivot Table Trick: Drawing Charts Using Only Part of the Pivot Table
As I showed in a previous post about dash-boarding with Pivot Table, generating multiple charts with a Pivot Table can be very useful. But the problem is that Excel will...
The Carbon-reducing Effect of E-commerce Delivery
In an early article I discussed the perils of higher carbon print in online grocery shopping (mainly from a paper by Van Loon et al (2015). However, let’s not forget...
The sustainability peril of E-commerce (I): Small batches lead to more emissions
Recently I have been discussing with David Steven of Boston Strategy International, a world expert on sustainable supply chains, on the topic of carbon foot printing. One of...
Two-way Data Table in Excel is a great tool for sensitivity analysis
In an earlier post, I have introduced Data Table as a “secret weapon” to conduct sensitivity analysis. Now let’s go one step further and look at a more...
The Dawn of the Modern Power Grid Started Right Here in Massachusetts (and It was Clean Energy!)
Electrification is indeed the single great achievement of our society. And yet, I was delighted to find out the modern power grid actually started in Massachusetts, a state I...
Measuring the Carbon Footprint of a Supply Chain: 3 Scopes
The Greenhouse Gas Protocol has established a set of standards to measure and manage GHG emissions. To me it seems to be the dominant framework in measuring the carbon...
Zero-Carbon Economy: A Grand -and Necessary – Vision
I just watched a video produced by Cambridge University called “The Climate Crisis: Towards Zero Carbon”: Well done, Cambridge! The video first shows that data on...
More power lines, or rooftop solar panels? There is no easy answer (but here is a way to think about it)
New York Times recently had an article by Ivan Penn titled “More power lines, or rooftop solar panels?” which poses an important question: Should we rely on...