sum of different columns to the desired value in Matlab

Question

jack carter 2022-8-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1774475-sum-of-different-columns-to-the-desired-value-in-matlab

编辑： Bruno Luong 2022-8-5

I have list of numbers from Row 1 to Row 20 say in Column A and I need to have the number of each row distributed in to four different columns (Column B, C, D, E) in Matlab so that:

(i) the sum of values shown in columns B, C, D, E is equal to the value of Column A.

(ii) The values shall only be whole numbers.

(iii) Columns B, C, D, E have maximum limit of 10, 10, 5 and 5 respectively. That is the values generated in these columns should be with in these maximum limit values.

Example:

| A | B | C | D |

| 16 | 6 | 5 | 2 | 3 |

Any way to pick values from Column A and then get the values in different columns (B,C,D,E) with in their respective limits so that the sum is equal to A?

Sample Column A values are as under:

16

17

20

26

18

29

19

20

18

16

21

16

17

16

28

29

20

25

16

Previously for another similar project I tried doing this with limits of 3 and 5. But here I need to get values from A and then do the summation within limits.

clear all
while true
    A=randi([3 5],20,4);
    if((sum(A,2)>=42) | (sum(A,2)<=70));
        break;
    end
end
disp(A);
disp(sum(A,2));

2 个评论
显示无隐藏无

Mohammad Sami 2022-8-5

If the column is not given but is generated. You can just generate the values for BCDE and then sum it up to get the value for A

jack carter 2022-8-5

Column A values are given. And I need to get the sum of BCDE as per the particular Column A value in each row.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Bruno Luong 2022-8-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1774475-sum-of-different-columns-to-the-desired-value-in-matlab#answer_1021545

编辑：Bruno Luong 2022-8-5

在 MATLAB Online 中打开

A=randi([4 30],10,1);
lo = [1 1 1 1];
up = [10 10 5 5];
BCDE=lo+diff(round((cumsum([0, (up-lo)],2)).*(A-sum(lo))./sum(up-lo)),1,2); % EDIT bug fix
if any(BCDE < lo | BCDE > up)
    error('Fail')
end
[A,BCDE]
ans = 10×5
    19     6     6     4     3
    10     3     3     2     2
    26     9     8     5     4
    19     6     6     4     3
    10     3     3     2     2
    16     5     5     3     3
     4     1     1     1     1
    11     3     4     2     2
     8     2     3     1     2
    27     9     9     4     5

2 个评论
显示无隐藏无

jack carter 2022-8-5

Thanks alot !!! Working fine.

Just an optional addition if possible to have a lower limit values of BCDE 5,5,3,3, respectively as well.

Bruno Luong 2022-8-5

编辑：Bruno Luong 2022-8-5

在 MATLAB Online 中打开

Hmm just change it at your will

A=randi([16 30],10,1);
lo = [5 5 3 3];
up = [10 10 5 5];
BCDE=lo+diff(round((cumsum([0, (up-lo)],2)).*(A-sum(lo))./sum(up-lo)),1,2); % EDIT bug fix
if any(BCDE < lo | BCDE > up)
    error('Fail')
end
[A,BCDE]
ans = 10×5
    29    10     9     5     5
    25     8     8     5     4
    29    10     9     5     5
    27     9     9     4     5
    26     9     8     5     4
    29    10     9     5     5
    25     8     8     5     4
    21     7     7     3     4
    17     5     6     3     3
    24     8     8     4     4

请先登录，再进行评论。

Answer 2

Bruno Luong 2022-8-5

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1774475-sum-of-different-columns-to-the-desired-value-in-matlab#answer_1021525

在 MATLAB Online 中打开

If you have the optimization toolbox

A=randi([4 30],10,1);
n = length(A);
lo = [1 1 1 1];
up = [10 10 5 5];
m = length(up);
BCDE = zeros(n,m);
opts = optimoptions('intlinprog','Display','off');
for k=1:n
    BCDE(k,:) = intlinprog(zeros(1,m),1:m,...
        [],[],ones(1,m),A(k),lo,up,[],opts);
end
[A(:) BCDE]
ans = 10×5
     6     3     1     1     1
    19    10     7     1     1
    13    10     1     1     1
    25    10    10     4     1
    13    10     1     1     1
    17    10     5     1     1
    17    10     5     1     1
    25    10    10     4     1
    22    10    10     1     1
    10     7     1     1     1