I hope to be able to get some assistance here, I tried reading through some of the posts, however, they are far above my math abilities..so I apologize if this is a re-post or this is a basic question for this forum..
Also this is much easier to see and understand in Excel
What I am trying to do is re-calculate various values if the total of the sum does not equal the expected total..(some values be increased, others decreased, all while maintaining that any one individaul value does not go below the minimum)
Problem after applying weights, the minimum is not maintained, thus, the desired value is not reached.
DATA:
Expected Total = 18,000
Minimum Value for each value = 700
Total for values entered= 21,400
Sum For each value that is > minimum of 700 = 20,200
Sum for the values that did not meet the minimum of 700 = 2,100
Difference desired to total = 2,200
Values that were entered $500,500,200,4000,6000,1000,5000,1000,700,1000,1500$
The Weight for each number I figured to be value Entered / Sum of the values over the 700 miniumum; 4,000/20,200
Weights: $0,0,0, 0.1980 , 0.2970 , 0.0495 , 0.2475, 0.0495 , 0.0347 , 0.0495 , 0.0743$
if > 700 The New value (weight * (Difference Desired To the sum of the values that were > 700 - Sum of non minimums))
$0.1980 (18,000 - 2,100) = 3,148.51$ Else 700
Any assistance is greatly appreciated, I have this in an excel spreadsheet.
Thanks