Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
3
Newest
 Tumbleweed
Impact
~98 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Jan
30
awarded  Tumbleweed
Jan
23
revised formula for choosing best investment option?
added 88 characters in body
Jan
23
asked formula for choosing best investment option?
Jan
31
comment calculate value/price with multiple uncomparable values
So could I have y and z have a tenth the weight of x by having i=1/3 j=1/30 k=1/30?
Jan
31
revised calculate value/price with multiple uncomparable values
added 55 characters in body
Jan
28
revised calculate value/price with multiple uncomparable values
deleted 208 characters in body
Jan
28
comment calculate value/price with multiple uncomparable values
forget my last comment (at least for now) the thing is using K=1/3 will give me the total value just like Calvin Lins answer, without the *100; although the *100 is irrelevant, can be to give percentage. but the just dividing that by the price I thought would give me the value/price ratio but as I tried it in the spreadsheet on the real problem I'm trying to solve I run into a inconsistency or flaw. check the my original question if your interested. this seems to me essential to calculate the value of a product with various components yet I haven't managed to find a solution anywhere.
Jan
28
revised calculate value/price with multiple uncomparable values
added 129 characters in body
Jan
28
revised calculate value/price with multiple uncomparable values
added 63 characters in body
Jan
28
comment calculate value/price with multiple uncomparable values
thx but your answer would work if all x, y, z have same "weight" on value, by using k=1/3. but I want to be able to calculate at different "weights" or "importance" of x, y, z. IE: x is 2 times as important as y, or z. I'll edit the question again to make it clearer
Jan
28
revised calculate value/price with multiple uncomparable values
edited title
Jan
28
revised calculate value/price with multiple uncomparable values
deleted 74 characters in body
Jan
28
revised calculate value/price with multiple uncomparable values
deleted 35 characters in body; edited title
Jan
28
awarded  Student
Jan
28
comment calculate value/price with multiple uncomparable values
no, definitely not x100. 100 is the price so it should be the value divided by price. but I don't know how to calculate the value. sorry for my phrasing. althuogh now I realise the price thing is unimportant I'll edit the question to make it simpler.
Jan
28
asked calculate value/price with multiple uncomparable values
Jan
28
awarded  Editor