need help with practical use equation with multiple variables

pmjacobs

New member
Joined
Feb 3, 2012
Messages
1
Greetings! Can someone help me figure out an equation? Here's the challenge: I need to mix black and white paint to create a grayscale. When you mix black and white, you get gray, and depending on the amount of each, you get a different value of gray (in between white=0 and black=100). I would like to have an equation that would return the remaining variable if I input the value variable and either black or white. I have a table of actual data:

ValueBlack (grams)White (grams)
895.00.0
1090.02.1
1287.75.7
1685.59.5
2080.314.7
2573.121.9
3065.529.5
3556.838.2
4048.946.1
4541.453.6
5033.461.6
5528.466.6
6022.672.4
6516.978.1
7011.585.0
758.688.0
804.990.1
843.092.0
882.192.9
921.393.7
960.694.6
980.194.9
1000.095.0




Appreciate any help/ideas. You can email me directly at pmjacobs@sbcglobal.net.

Regards,

Peter Jacobs
 
Top