CNPC replaced spreadsheet pipeline planning with optimization, adding $530M in profit

China's natural gas consumption nearly doubled in five years, and CNPC's pipeline network, the country's largest, was planned annually by hand in spreadsheets. As the network grew, the manual method accumulated large errors, wasting resources and inflating construction plans.

CNPC partnered with researchers at UC Berkeley and Tsinghua University to build software that optimizes the national gas pipeline network, covering both operations and expansion design.

Implemented from the end of 2014, the system raised CNPC's profits by $530 million over 2015–2017 and reduced planned construction budgets by more than $20 billion for the next five years by making better use of existing capacity.

INFORMS credited the project with roughly $330 million in direct savings and said the added efficiency let CNPC delay further pipeline expansions, saving billions more.

Optimize the whole gas network, not line by line

One network-level model replaced thousands of manual spreadsheet cells that could not see interactions.

Better use of existing capacity deferred billion-dollar construction, the biggest single saving.

University partners brought modeling rigor the company's spreadsheets could not match.

The optimizer turned planning from an annual exercise into a continuous, testable process.

When a system outgrows spreadsheets, the failure is the tool, not the planners; network-level optimization finds savings line-by-line judgment cannot see.

The project was named a 2018 Franz Edelman Award finalist, one of the world's most prestigious OR practice awards, and was covered as an international recognition of China's pipeline planning software.