username_rand
New Member
- Joined
- Jan 27, 2019
- Messages
- 20
Hello,
I need to make a sort of weights calculator that i could just put in the number of projects i have, rate them from most to least important, and the percentage of increase and it would automatically give me the required weights.
For example, right now I have four projects:
Pro. A
Pro. B
Pro. C
Pro. D
rated from most to least important with project A being most important. With 20% increase between each project, I figured out the math on paper as follows:
x (pro. D) + 1.2x (pro. C) + 1.4x (pro. B) + 1.6x (pro. A) = 100%
i solved for x and figured out the weight of each project depending on its value.
Is there a formula that would help in figuring out the weights as i did on paper for other projects? (even if i changed the number of projects and/or the percentage of increase)
I need to make a sort of weights calculator that i could just put in the number of projects i have, rate them from most to least important, and the percentage of increase and it would automatically give me the required weights.
For example, right now I have four projects:
Pro. A
Pro. B
Pro. C
Pro. D
rated from most to least important with project A being most important. With 20% increase between each project, I figured out the math on paper as follows:
x (pro. D) + 1.2x (pro. C) + 1.4x (pro. B) + 1.6x (pro. A) = 100%
i solved for x and figured out the weight of each project depending on its value.
Is there a formula that would help in figuring out the weights as i did on paper for other projects? (even if i changed the number of projects and/or the percentage of increase)