twitter linkedinfacebookacp contact us

EIA’s new tool to combine energy and economic data in MS Excel spreadsheets

The US Energy Information Administration (EIA) has launched a free data add-in tool for Microsoft Excel users to help them save energy and economic data in Excel spreadsheets and update them any time by reopening it with a single click

Adam Sieminski, administrator at EIA, said, “This ability to save worksheets and then update the data with a single click to rerun the analysis weeks or months later using the most recent data is an immense saving of time and effort for anyone performing periodic analyses of energy and economic data.”

The tool reflects the functionality of the existing economic-data-only add-in provided by the St. Louis Federal Reserve Bank and builds on the Federal Reserve Economic Data (FRED) add-in. The new EIA add-in also allows users to find, download and update FRED’s economic data and EIA’s economic data directly in any Excel spreadsheet.

Users can browse energy data categories or search keywords to find domestic and international data series, short-term forecasts and long-term projections. A user guide and installation instructions are available to provide further guidance, along with a short video tutorial.

The add-ins from EIA and the St. Louis Federal Reserve Bank are powered by application programming interfaces (APIs), which along with the add-ins themselves are offered free of charge as part of each organisation's commitment to open data.


To register for Big Data Analytics for Oil & Gas, please visit: http://www.oilandgasbigdata.com/register

The oil and gas industry has been increasingly adopting AI technology in recent years, and this trend is expected to continue in the coming years. (Image source: Adobe Stock)

SmartMaster can be used with a range of ABB and third-party instruments. (Image source: ABB)

Comparison of conventional workflow with DUG MP-FWI imaging. (Image source: DUG)

The expansion is expected to increase the plant’s processing capacity from 2.5 to up to 4 billion standard cubic feet per day (bscfd). (Image source: Aramco)

ARO Drilling and IMI announce first Kingdom jack up rig (Image source: ARO)

Oman LNG signed various agreements with Shell Gas to secure its gas supply until 2034. (Image source: Adobe Stock)

GAC Saudi Arabia has extensive operations at major ports in Saudi Arabia. (Image source: GAC Saudi Arabia)

Michael Monica, director sales, marketing and customer care at GPT Industries signs the agreement with Mohamed Altaf, sale manager, Abdulla Fouad Energy Services. (Image source: Alain Charles Publishing)

Amin H. Nasser, CEO of Aramco. (Image source: Aramco)

The system can activate notification and hazard mitigation equipment to notify workers and safeguard facilities. (Image source: MSA Safety)

The use of blockchain in the oil and gas sector is set to increase substantially. (Image source: Adobe Stock)

The new discoveries will bolster Aramco’s strategy to increase gas production by more than half over 2021 levels, through 2030. (Image source: Adobe Stock)

Tethys Oil is currently conducting final preparations ahead of the rig mobilisation for the drilling of the first exploration well on Block 58, Kunooz-1 in Fahd.

Source: SafeStart

The new technology is designed to address the challenging conditions in unconventional wells. (Image source: Adobe Stock)

The Ampelmann A-type enabling safe offshore access in the Middle East. (Image source: Ampelmann)

Aramco has produced the first unconventional tight gas from its South Ghawar operational area ahead of schedule. (Image source: Adobe Stock)

Tethys Oil is currently conducting final preparations ahead of the rig mobilisation for the drilling of the first exploration well on Block 58, Kunooz-1 in Fahd.

TotalEnergies and SONATRACH will develop gas resources in Algeria's north-east Timimoun region, (Image source: Adobe Stock).

By using analytics to augment and empower the workforce, pipeline operators can optimise operations and improve asset availability. (Image source: Adobe Stock)

The oil price is hovering around the US$90/bbl mark. (Image source: Adobe Stock)

The Craig International Qatar team. (Image source: Craig International)

The SuperFill II diverter reduces induced surge pressure. (Image source: Halliburton)

Among other services, KBR will offer proprietary equipment for NCIC's 1,200 metric tonnes per day ammonia plant. (Image source: Adobe Stock)

The expansion is expected to increase the plant’s processing capacity from 2.5 to up to 4 billion standard cubic feet per day (bscfd). (Image source: Aramco)

Comparison of conventional workflow with DUG MP-FWI imaging. (Image source: DUG)

ADNOC Gas recorded robust financial and operational results in 2023. (Image source: Adobe Stock)

Over 4,000 km of SoluForce pipe has been installed around the world. (Image source: SoluForce)

Block 56 is targeted for commercialisation in 2024. (Image source: Canva)

The programme will optimise asset lifecycle, enhance machinery performance and improve overall reliability. (Image source: Adobe Stock)

The use of blockchain in the oil and gas sector is set to increase substantially. (Image source: Adobe Stock)

Source: SafeStart

GAC Saudi Arabia has extensive operations at major ports in Saudi Arabia. (Image source: GAC Saudi Arabia)

The company is well positioned in 2024, with a reshaped and resilient business and a strong balance sheet. (Image source: Adobe Stock)

The vessel addresses the growing demand for accurate hydrographic data. (Image source: Fugro)

The virtual inhouse seismic processing centre will allow each of the decentralised business units of Wintershall Dea globally to collaborate efficiently and directly with DUG. (Image source: Adobe Stock)