seakeeper output

hi all professiond

some times i think about the output format of SeaKeeper software.
thats format are text and used of them was a little difficult( only a little )

ok, so i try to fine some VBA code on Excell to change this format to a abular and sorted data for draw some usful graph.

any body....?:!:

 

I try to write a VBA macro for show the acceleration data from seakeeper data file:

data file:
5, 5 kts; 0.00, 0 deg; wh=5 (1 Param. Bretschneider: 11.184 s, 5 m)
Item m0 units RMS units Significant amplitude units
1 Modal period 11.184 s -- --
2 Characteristic wave height 5 m -- --
3 Spectrum type 1 Param. Bretschneider -- --
4 Wave heading 0 deg -- --
5 Vessel Speed 5 kts -- --
6 Vessel displacement 834.62 m^3 -- --
7 Vessel GMt 4.933 m -- --
8 Vessel trim 0 deg -- --
9 Transom method No transom terms -- --
10 Wave force method Arbitrary wave heading -- --
11 Added res. method Salvesen -- --
12 Pitch gyradius 9 m -- --
13 Roll gyradius 3.3 m -- --
14 Wave spectrum 1.569 m^2 1.252 m 2.505 m
15 Encountered wave spectrum 1.568 m^2 1.252 m 2.505 m
16 Added resistance 145.175 kN -- --
17 Heave motion 0.951 m^2 0.975 m 1.95 m
18 Roll motion 0 deg^2 0 deg 0 deg
19 Pitch motion 22.7 deg^2 4.76 deg 9.53 deg
20 Heave velocity 0.265 m^2/s^2 0.514 m/s 1.029 m/s
21 Roll velocity 0 (Hz)^2 0 Hz 0 Hz
22 Pitch velocity 0.00008 (Hz)^2 0.00883 Hz 0.01766 Hz
23 Heave acceleration 0.083 m^2/s^4 0.288 m/s^2 0.577 m/s^2
24 Roll acceleration 0 (Hz/s)^2 0 Hz/s 0 Hz/s)
25 Pitch acceleration 0.00004 (Hz/s)^2 0.00624 Hz/s 0.01248 Hz/s)
26 BRIDGE: Abs. vert. motion 2.366 m^2 1.538 m 3.076 m
27 BRIDGE: Rel. vert. motion 0.31 m^2 0.557 m 1.114 m
28 BRIDGE: Abs. vert. velocity 0.757 m^2/s^2 0.87 m/s 1.741 m/s
29 BRIDGE: Rel. vert. velocity 0.162 m^2/s^2 0.403 m/s 0.805 m/s
30 BRIDGE: Abs. vert. accel 0.28 m^2/s^4 0.529 m/s^2 1.058 m/s^2
31 BRIDGE: Rel. vert. accel 2.182 m^2/s^4 1.477 m/s^2 2.955 m/s^2
32 BRIDGE: Long. (due to pitch) motion 1.081 m^2 1.04 m 2.08 m
33 BRIDGE: Long. (due to pitch) velocity 0.418 m^2/s^2 0.646 m/s 1.293 m/s
34 BRIDGE: Long. (due to pitch) accel 0.186 m^2/s^4 0.431 m/s^2 0.862 m/s^2
35 BRIDGE: Lat. (due to roll) motion 0 m^2 0 m 0 m
36 BRIDGE: Lat. (due to roll) velocity 0 m^2/s^2 0 m/s 0 m/s
37 BRIDGE: Lat. (due to roll) accel 0 m^2/s^4 0 m/s^2 0 m/s^2
38 BRIDGE: MII slide; tip f/a; tip s/s 0 MII/h 0 MII/h 0 MII/h

but i hav'nt the MSI data to compose the MSI curve on the Accel. Graph.
any body can help me???? :?: :?:

 

The MSI tab in the results window can be saved as text or copied and pasted into Excel. That should let you do it.