PDA

View Full Version : Not sure what to do.



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

Bob Phillips
07-15-2010, 07:18 AM
Yep , you confused us all :)

Seriously, work through an example for us, you have just sketched it so far.

austenr
07-15-2010, 08:52 AM
Sounds suspiciously like a homework assignment.

satoshelby
07-15-2010, 09:11 AM
Ok I see why you might think that. lol

What it is is this.

I am trying to put together a spread sheet that will tell me what the chances of a team winning a match are based on the numeric value i attach to them plus home advantage or minus away disadvantage. I also need to be able to change teh numeric value in the case of a team being on a run of form.

Bob Phillips
07-15-2010, 10:40 AM
And that is a worked example?