Code some excel formulas in Matlab, in a smart way
조회 수: 1 (최근 30일)
이전 댓글 표시
Hey
I have a quick question, I have this excel ark where there is a column that has the following code:
q1 = 1/2 * x1 * y1
q2 = 1/2 * x2 * y2 + x1 * y1
q3 = 1/2 * x3 * y3 + x2 * y2 + x1 * y1
q4 = 1/2.............
and so on and so on.
How do I program this smart? I've tried to make a for loop, but I can't figure out how the make the 1/2 only stick to the new x-y values and not the others.
댓글 수: 0
채택된 답변
Steven Lord
2017년 9월 11일
This sounds vaguely homework-like so I'm not going to give the answer just a hint. I assume x1, x2, etc. refer to elements of a vector x and similarly for y1, y2, etc. Let xy be x.*y. Take a look at the cumsum function applied to xy. It doesn't get you all the way to your answer, but it gets you most of the way there.
추가 답변 (1개)
KL
2017년 9월 11일
x = 1:5;
y = 6:10;
xy = arrayfun(@(a,b) [x(1):a;y(1):b],x,y,'UniformOutput',false);
q = cellfun(@(c) sum([0.5 ones(size(c)-1)].*prod(c)),xy,'UniformOutput',false)
댓글 수: 2
Image Analyst
2017년 9월 11일
There is a mat2cell() function. See the FAQ http://matlab.wikia.com/wiki/FAQ#What_is_a_cell_array.3F for an explanation of cells. However I think Steven's answer/hint is the more straightforward, less cryptic approach.
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!