Clear Filters
Clear Filters

Need help with imported data and how to integrate it with dependency

1 view (last 30 days)
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

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!