Description
Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz β method, governing standards and output schedule
The Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz calculation characterises the sea state by fitting a standard wave energy spectrum to the significant wave height and peak period, and derives the spectral parameters used in downstream response analysis. It is applied during detailed design, during design verification by a second engineer, and again during in-service assessment when the operating basis changes. Because every intermediate quantity is reported rather than only the final answer, the calculation can be checked line by line against the governing standard without re-deriving it.
This 3D-LABS workbook is built to DNV-RP-C205. You supply 11 inputs and the sheet reports 5 results, with every formula left visible so each figure can be traced to the clause it comes from.
Method of calculation
The spectral density is formed from the selected parameterisation: Pierson-Moskowitz for a fully developed sea, or JONSWAP with the peak enhancement factor and spectral width parameters for a fetch-limited sea. Spectral moments are integrated numerically from the density function, and the characteristic values follow from them: significant wave height from the zeroth moment, mean zero-crossing and peak periods from the moment ratios, and the bandwidth parameter. The resulting spectrum is tabulated for use as the excitation in a response calculation.
Governing standards and references
- DNV-RP-C205 β DNV-RP-C205 Environmental conditions and environmental loads, wave spectra
- ISO 19901-1 β ISO 19901-1 Metocean design and operating considerations
- Hasselmann JONSWAP β Hasselmann et al. (1973), JONSWAP spectral formulation
Each formula cites the clause it comes from on the same row as the result it produces, so a reviewer can check the sheet line by line against the standard.
Acceptance criteria
For the calculation to be reported as acceptable, the fitted spectrum must reproduce the specified significant wave height and peak period within the tolerance adopted, and the peak enhancement factor must lie within the range appropriate to the fetch and duration of the design sea state.
Who uses this calculation
This calculation is used by offshore and marine engineers defining design sea states, naval architects performing motion and fatigue analysis, and metocean specialists reviewing environmental design bases.
What you receive
- Excel calculation file (.xlsx) β fully unlocked formulas and a clear input/output layout
- Worked example β realistic engineering values with expected outputs so you can verify the sheet against a known case
- Code references β every formula cross-referenced to DNV-RP-C205
- Email support β write to info@3d-labs.com with questions about inputs, methodology or results
Delivery and licence
Instant download after payment at βΉ2,599. One payment, lifetime access, no subscription. The workbook is a design aid β results must be verified by a qualified engineer before use.
What Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz β Excel calculates
Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz β Excel is an Excel-native engineering calculation tool built by 3D-LABS for oil & gas, midstream, and pipeline engineers working on process piping, pipelines, and hydrocarbon-service equipment. It is used for sizing pipe wall thickness, evaluating tank shells, verifying process piping stress, and checking corrosion allowance. Every input is labelled and every output is traceable β the sheet is designed to be checkable, not a black box.
Codes and standards followed
Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz β Excel follows industry-standard Oil & Gas Engineering codes including ASME B31.3, ASME B31.4, ASME B31.8, API 650, API 620, API 653, API 579. Each formula is cross-referenced to the applicable code clause so your reviewer can trace calculations back to the standard.
If your project requires a different code base (e.g. converting an IS-code sheet to an ASME basis), we can produce a code-variant edition on request. Contact info@3d-labs.com for a variant quote.
What is included in your download
- The Excel calculation file (.xlsx) β fully unlocked formulas, cell-level comments, and a clear input/output layout.
- A sample worked example β realistic inputs plus expected outputs so you can validate the spreadsheet against a known case.
- User notes (PDF) β assumptions, code clauses referenced, and edge-case guidance.
- Revision history β every update to the spreadsheet is logged so you know what changed and when.
- Email support β reply within 24 hours (Monday to Saturday, IST) for questions about the spreadsheet or its use.
Software requirements
Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz β Excel runs in Microsoft Excel 2016 or later on Windows and Mac. It is also compatible with LibreOffice Calc and can be imported into Google Sheets (some formatting may shift). No macros are required and no external add-ins are needed β every calculation runs in cell formulas, which means every step is auditable.
Pricing and delivery
Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz β Excel is priced at βΉ2,599 (approximate USD equivalent shown in the cart). Delivery is instant β after payment you get a download link immediately and a receipt by email. One-time purchase, lifetime access, no subscriptions or hidden fees.
Payment methods: Cashfree (Indian customers) or PayPal International (customers outside India). Volume discounts are available on bundles of 5 or more spreadsheets from the same discipline β contact sales@3d-labs.com for a bundle quote.
Related tools and services
Engineers who work with Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz β Excel often also need:
- Other Oil & Gas Engineering spreadsheets from our catalogue of 40 tools in this discipline.
- Our Piping Design Services β for projects where the calculation is only part of a larger scope and you want the full engineering deliverable produced by 3D-LABS.
- Our online training courses β instructor-led programmes on Oil & Gas Engineering topics, including software mastery and code walkthroughs.
- Our engineering e-book library β 115+ technical PDF references covering theory, practice, and code interpretation.
Frequently asked questions
What software do I need to run Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz β Excel?
The spreadsheet is delivered as a native Excel (.xlsx) file. It runs in Microsoft Excel 2016 or later on Windows and Mac. It also runs in LibreOffice Calc and Google Sheets (with import), though some formatting may shift. No macros are required β all logic runs in cell formulas so you can audit every step.
Which codes and standards does this spreadsheet follow?
Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz β Excel follows ASME B31.3, ASME B31.4, ASME B31.8, API 650, API 620, API 653, API 579. Every formula is cross-referenced to the code clause it implements, so your reviewer can trace the calculation back to the standard. If your project needs a different code, contact us β many spreadsheets are available in code-variant editions.
Are the formulas locked or editable?
All formulas are unlocked and editable. You can adapt inputs, add your own load combinations, integrate the sheet into your own workflow, and audit the logic. We do not password-protect our worksheets β an engineer should always be able to verify what the tool is doing.
What is included in the download?
The download includes: (1) the Excel calculation file with all formulas, (2) a sample worked example showing typical inputs and expected outputs, (3) a short user notes PDF explaining assumptions and code clauses used, and (4) a revision history so you can see how the sheet has been updated over time.
Do you offer support if I have questions?
Yes. Email support with any 3D-LABS spreadsheet purchase β reply within 24 hours (Mon-Sat, IST). We also offer paid tuning if you need the spreadsheet adapted to a specific project (typically USD 50-200 depending on scope). Contact info@3d-labs.com for details.
About 3D-LABS engineering spreadsheets
Wave Spectrum Analysis: JONSWAP / Pierson-Moskowitz β Excel is one of 680 engineering calculation spreadsheets in the 3D-LABS catalogue β the largest curated collection of code-compliant Excel calculators for practising engineers anywhere. Each sheet is built and reviewed by 3D-LABS engineers who use them daily on real client projects across pressure vessel design, storage tank design, piping stress analysis, structural engineering, heat exchanger design, and FEA services since 2003.
Browse the full SpreadSheet Calculations catalogue or the Oil & Gas Engineering calculations sub-category. Volume discounts apply on 5+ spreadsheets from the same discipline.
