: Enter a name (e.g., CALC_ENERGY ) and your LAMBDA formula in the "Refers to" box. Example Formula : To calculate seismic energy ( ) from magnitude ( ) using the formula : =LAMBDA(mag, 10^(4.8 + 1.5 * mag))
A "helpful feature" for analyzing this data in modern Excel is the function, which allows you to create custom, reusable formulas without using VBA. How to use LAMBDA with Earthquake Data Download EARTHQUAKE MAGNIDUTE DATA with lambda xlsx
: Visit the USGS Search Catalog and set your parameters (date range, minimum magnitude, and geographic region). Select Output : Choose CSV as the output format. : Enter a name (e
: Open the downloaded CSV in Excel. Use Text to Columns under the Data tab if the data is not automatically separated into columns. Select Output : Choose CSV as the output format
: Go to File > Save As and select Excel Workbook (.xlsx) to enable features like LAMBDA and advanced formatting. How to Download Global Earthquake Magnitude Data for Free