清空筛选条件
清空筛选条件

How to import data and use it in a formula?

1 次查看（过去 30 天）
ekko ekkosen
ekko ekkosen 2015-3-19
评论： dpb 2015-3-19
hei the problem here is that i have a formula for obtaining the loads that wave cases on a column but i am not going to hava formula for velocity or acceleration that is one part of the formula used. those are gathered from an excel file with depth variations. so i have this:
d = 100; depth
a = 31; amplitude
D = 20; diameter
p = 1025; water density
Cm = 2; factor
Cd = 1.1; factor
V1 = Velocity data from excel where it changes with depth Z
A1 = Acceleration data from excel where it changes with depth Z
Fm = (pi*p*Cm*A1*D.^2)/4;
Fd = ((p*Cd*D)/2)*V1.*(abs(V1));
F = int(Fm,z,-d,a)+int(Fd,z,-d,a) formula for force vil give a constante
so how do i introduce the V1 velocity data and the A1 acceleration data to this formula?
  1 个评论
dpb
dpb 2015-3-19
Basically read the Excel file(s). See
doc xlsread
for details on the function; precisely for your case would depend on how the spreadsheets are built.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（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!

Translated by