jb
Member
Hello Helpers,
I have an excel sheet jb rank testing.xlsx. This excel sheet is a solution given by one member in this forum long back.
I have any 6 values entered in cells b2 to g2. I want to add a value say 16 (cell h1) to values b2 to g2.
Sum of vales added to b2 to g2 should be exactly 16.
Total 16 points is to be added in such a way that new value of cell after adding portion of value 16 to that cell should not exceed to any cell which has original value greater. For example, two cells having value 9 and 5 should not be increased like 9+4=13 and 5+9=14 because originally 9 is greater than 5, so final value of 9 (i.e. 13) can not be less than final value of 5 (i.e. 14). 9+4=13 and 5+8=13 is valid. This rule is to be checked against all cells.
For example: 26,23,25,26,28,27 is balanced with value 16 but the final values are
28,29,29,29,28,28 does not follow rules.
Because 26 becomes 28 and 23 becomes 29 and 25 becomes 29 which is wrong. Because 26 is greater than 23 and 25. so final value of 26 (i.e 28) can not be less than final value of 23 and 25 (i.e. 29). They can be equal.
And the distribution is to be done in such a way that all cells must get balanced values.
For example: 11, 6 , 9 , 15 , 8 ,17 will be balanced like 13, 12, 13, 15, 12, 17
Given solution gives correct output for some set of data. But when I enter following data 12 23 25 26 28 27 in B2 to G2 then it adjusts the cells with values 18 instead of 16.
Please help.
I have an excel sheet jb rank testing.xlsx. This excel sheet is a solution given by one member in this forum long back.
I have any 6 values entered in cells b2 to g2. I want to add a value say 16 (cell h1) to values b2 to g2.
Sum of vales added to b2 to g2 should be exactly 16.
Total 16 points is to be added in such a way that new value of cell after adding portion of value 16 to that cell should not exceed to any cell which has original value greater. For example, two cells having value 9 and 5 should not be increased like 9+4=13 and 5+9=14 because originally 9 is greater than 5, so final value of 9 (i.e. 13) can not be less than final value of 5 (i.e. 14). 9+4=13 and 5+8=13 is valid. This rule is to be checked against all cells.
For example: 26,23,25,26,28,27 is balanced with value 16 but the final values are
28,29,29,29,28,28 does not follow rules.
Because 26 becomes 28 and 23 becomes 29 and 25 becomes 29 which is wrong. Because 26 is greater than 23 and 25. so final value of 26 (i.e 28) can not be less than final value of 23 and 25 (i.e. 29). They can be equal.
And the distribution is to be done in such a way that all cells must get balanced values.
For example: 11, 6 , 9 , 15 , 8 ,17 will be balanced like 13, 12, 13, 15, 12, 17
Given solution gives correct output for some set of data. But when I enter following data 12 23 25 26 28 27 in B2 to G2 then it adjusts the cells with values 18 instead of 16.
Please help.