How to import data and use it in a formula?

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?

[dpb]

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.