Cumulative sum doesn't work.
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Carmela Marie Lingad
el 24 de Mayo de 2021
Comentada: Rik
el 9 de Jun. de 2021
Hi. I uploaded my code and the excel file. I have a concern.
I want to compute for parameter YB1. To compute for the YB1, it should be the product of the corresponding Wt1 and (Db1 - Da1). But there is a condition. The computation of YB1 should start in the value where Da1 = Df1 and should end where Db1 = Df1 + B1. So based on the excel file,
Df1 = 3m, B1 = 1.2m
Since cell B9 is equals to (Df1 = 3m) and cell C10 is equals to (Df1 + B1 = 3m + 1.2m = 4.2m).
Therefore, YB1 = cell E9(cell C9 - cell B9) + cellE10(cell C10 - cell B10).
YB1 = 9(4-3) + 9.133333(4.2 - 4)
So the condition should be this, the cumulative sum of the product of Wt1 and (Db1 - Da1) should start where Da1 = Df1 and should end where Db1 = Df1 + B1.
Then the return value should be the sum of YB1. And it should be written consistently from cell G5 to cell G35. The cumulative sum will be written from cell G5:G35.
I hope someone can help me.
4 comentarios
Respuesta aceptada
David Hill
el 24 de Mayo de 2021
Editada: David Hill
el 24 de Mayo de 2021
t=readmatrix('Terzaghi2.xlsx');%load matrix and look where everything is at
a=t(2,7);
b=t(1,7)+a;
idx1=find(t(:,2)==a);
idx2=find(t(:,3)==b);
Yb=cumsum(t(idx1:idx2,5).*(t(idx1:idx2,3)-t(idx1:idx2,2)));
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Import from MATLAB en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!