Need help creating formula

mwpreston

New member
Joined
Oct 21, 2011
Messages
2
Basically this is what i have. I have a number (lets say 1800). I have 6 total objects, 4 in pool 1, 2 in pool 2. I want to assign a portion of my total number to each pool. The objects in the pool will then take a portion of the pool complete number. I need the objects in pool 1 to always be 4 x the value of the objects in pool 2. For example, My total number is 1800. I assign 1600 to pool 1, 200 to pool 2. I have 4 objects in pool 1 so they get (1600/4) 400 each. The two objects in pool 2 get (200/2) 100 each. Therefore objects in pool 1 are 400 which is 4 times the amount of objects in pool 2 (100). But, what if I add another object to pool 1, or remove an object from pool 2.....

I need some sort of formula to figure total number for pool 1 and pool 2 out. I will always know the overall number (1800) in the case, as well as I will always know the number of objects in each pool. I just need to figure out how to split the overall number (1800) between the 2 pools in order to have Pool 1 objects have a value that is 4 times the amount of pool 2 objects....

Essentially how would I solve x and y...I always know a,b, and c

x = the portion of overall for pool a
y = the portion of overall for pool b

a = # of objects in pool 1 = 4
b = # of objects in pool 2 = 2
c = x + y = 1800

x/a = 4(y/b)

WHERE x + y = c

Or something like
4:1 = x/a : y/b WHERE x + y = c

As you can tell, I'm not a math genius...

Make sense....thanks for the help.
 
Last edited:
Perfect

That is bang on! Thanks so much...I would of thought about that all day and not come up with it...

Thanks again!
 
Top