Summation of table imported from excel
2 views (last 30 days)
Show older comments
Luis Eloy García-Mauriño Rey
on 26 Apr 2020
Commented: Luis Eloy García-Mauriño Rey
on 27 Apr 2020
So I have a table which was imported to matlab from an excel document. The table has 3 columns: Crankshaft angle, Volume, Pressure. I need to do a summation following this formula

The table has 720 rows of data.
0 Comments
Accepted Answer
Mrutyunjaya Hiremath
on 27 Apr 2020
% Assuming xls data strored in variabl 'data'
% colum 1 is Angle, colum 2 is Volume, colum 3 is Pressure
Win = 0;
for i = 2:720
Win0 = ((data(i,3) + data(i-1,3)) * (data(i,2) - data(i-1,2)))/2;
Win = Win + Win0;
end
disp(Win)
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!