Need help with imported data and how to integrate it with dependency
1 view (last 30 days)
Show older comments
hei i am wondering how to solve this problam. i have an excel file with 100 data of velocity depending on depth where depth is a variable z for the equation used below. i am going to use this data in Morison equation to find loads of a wave. then integrate with z (depth) to summarize all the load on the column used. the problame here is that i dont know how to make the velocity data depending on z (depth)
here are the 10 first numbers for the excel file so you know the formate.
Depth Velocity
-100 0
-98.83 0.0117
-97.67 0.0233
-96.5 0.035
-95.33 0.0467
-94.17 0.0583
-93 0.07
-91.83 0.0817
-90.67 0.0933
-89.5 0.105
and the script and formula used are
clear all
clear variables
clc
%--------------------------------------------------------------------------
d = 100; % water depth
a = 15; % wave amplitude
g = 9.81; % acceleration of gravity
% Morison equation data
D = 1; % column diameter
p = 1025; % water density
Cm = 2;
Cd = 1.1;
%--------------------------------------------------------------------------
BC = xlsread('Velocity for stokes 5th order','A:B') % excel file with data shown above
syms z
Fd = ((p*Cd*D)/2)*V.*(abs(V)); % Morison equation used. where V is velocity that are
% depending on depth z
F = int(Fd,z,-d,a) % integrate with depth dependency z from surface botum d to wave top a
thanks for any advice and help
0 Comments
Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!