- #1
jlkamikaze
- 3
- 0
i have an excel file containing 2 graphs [R & V], and their x & y coordinates in 4 separate lists [the X coordinates of R, the X coordinates of V, the Y coordinates of R, the Y coordinates of V]
i need to calculate the X & Y coordinates of a 3rd graph through a weighted formula that takes 55% of the R coordinates into account + 45% of the V coordinates into account
the tricky part is that R & V start and end at different X coordinates...
for example R starts at x=0 and ends at x=10
while V starts at x=5 and ends at x=15
can anyone help define a better formula for this?
here is what i have so far:
X = (Xr+Xv)/2
Y = (Yr)*0.55 + (Yv)*0.45
the problem with these equations is they don't take into account the different start and end positions of the two graphs
thank you for any help in advance! best regards!
i need to calculate the X & Y coordinates of a 3rd graph through a weighted formula that takes 55% of the R coordinates into account + 45% of the V coordinates into account
the tricky part is that R & V start and end at different X coordinates...
for example R starts at x=0 and ends at x=10
while V starts at x=5 and ends at x=15
can anyone help define a better formula for this?
here is what i have so far:
X = (Xr+Xv)/2
Y = (Yr)*0.55 + (Yv)*0.45
the problem with these equations is they don't take into account the different start and end positions of the two graphs
thank you for any help in advance! best regards!