Need help with imported data and how to integrate it with dependency
조회 수: 1 (최근 30일)
이전 댓글 표시
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
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!