필터 지우기
필터 지우기

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

조회 수: 1 (최근 30일)
ekko ekkosen
ekko ekkosen 2015년 3월 26일
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개)

카테고리

Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by