How to import data and use it in a formula?
1 次查看(过去 30 天)
显示 更早的评论
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
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!