# Wave Spectrums

Discussion in 'Hydrodynamics and Aerodynamics' started by Crowsnest, Aug 23, 2013.

1. Joined: Jun 2012
Posts: 44
Likes: 1, Points: 0, Legacy Rep: 18

### CrowsnestJunior Member

Hi all:
Im stupidly stucked with an Excel Wave Spectrum spreadsheet.

I've correctly got the P-M and the Bretschneider spectrums, but when trying with the Jonswap I got quite odd results.
I get quite big or quite little numbers with this last spectrum that do not agree with the other two.

DATA for S(w):
Fetch 1200 Nm; U= 30 kts

CONSTANTS:
Gamma= 0.3; X= g Fetch/U²
a= 0.076*X^(-0.22)
B= -5/4
wm= 2π*3.5*(g/U)*X^(-0.33)
s --- 0.07 or 0.09 depending on relation "w/wm"

EXPRESION
r= -(w-wm)²/(2 s² wm²)

S(w)= Gamma^r * (ag²/W^5) exp(B (wm/w)^4)

For Fetch=1200 and U=30 kts I get....
S(wm)= 0.014
H(1/3)= 0.4m

None of them looks reasonable.

I've tried with different functions for S(w) and S(f), in all cases results are "stupid".

Cannot find my mistake ¡¡¡¡

Regards

2. Joined: Oct 2008
Posts: 6,640
Likes: 649, Points: 113, Legacy Rep: 2488
Location: Japan

3. Joined: May 2004
Posts: 5,373
Likes: 247, Points: 73, Legacy Rep: 3380
Location: Italy (Garda Lake) and Croatia (Istria)

### daiquiriEngineering and Design

4. Joined: Aug 2004
Posts: 2,799
Likes: 363, Points: 83, Legacy Rep: 2040
Location: Port Orchard, Washington, USA

### jehardimanSenior Member

Gamma constant should be 3.3

Check how you implemented the exponential function and make sure you convereted to constant units, i.e. fetch in meters with wind speed in meters/sec, etc.. You may need to implement the exponential in a different fashion because of precision rounding depending on which version of Excel you are using

5. Joined: Jun 2012
Posts: 44
Likes: 1, Points: 0, Legacy Rep: 18

### CrowsnestJunior Member

Thanks all:
Of course my results (on JONSWAP) make no sence.

Jehardiman: Im for the units-precission affaire. But, before posting here, I've been checking that matter for a few days.
Gamma constant may be 3.3 or 0.33 depending on the formula arrangement.
About Excel: Im running Excel 2007 on 8x64 system.

Regards

6. Joined: Jun 2012
Posts: 44
Likes: 1, Points: 0, Legacy Rep: 18

### CrowsnestJunior Member

Hi again:

Results keep on making no sence.
The curve shape looks correct, but values are out of any common sence.

Time for stopping now. May be a rest will clear my mind up. Cannot understand how can I be stucked in such a simple calculation.

Best regards.

7. Joined: Oct 2008
Posts: 6,640
Likes: 649, Points: 113, Legacy Rep: 2488
Location: Japan

Crowsnest

When faced with such "issues", you can't beat the "old fashioned way". Perform several iterations using hand calculations and a calculator only. Then double check against your excel values, are they the same, if not, why not?

When doing the calc's, work out the 'sum' for each part (product) of the formula, break it down into small lumps so you can see if, or where, you have made an error, or excel has made an error. It is so easy to mistype a value or have an incorrect sign or too many parentheses etc in excel.

8. Joined: Jun 2012
Posts: 44
Likes: 1, Points: 0, Legacy Rep: 18