satoshelby
07-15-2010, 04:04 AM
Hi,
I am new to VBA and am trying to put together a code that will do the below. Any help would be great,
I want to be able to give a entry a weighting that can be used to calculate success against another weighting. so for example
CarA = 5 carB = 3.5 therfore carA wins by 1.5
but to make it a little trickyer carB is the home team and as such has home advantage worth .8 while carA has a habbit of doing bad on the road worth -.8 therfore carB wins by .1
Does this make any sense are have i just confused everybody myself in particular.:dunno
I am new to VBA and am trying to put together a code that will do the below. Any help would be great,
I want to be able to give a entry a weighting that can be used to calculate success against another weighting. so for example
CarA = 5 carB = 3.5 therfore carA wins by 1.5
but to make it a little trickyer carB is the home team and as such has home advantage worth .8 while carA has a habbit of doing bad on the road worth -.8 therfore carB wins by .1
Does this make any sense are have i just confused everybody myself in particular.:dunno