16th December 2005, 10:52 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,441
|
|
xpt,
Yes the pricing would be quite complicated to do, and I think I know the guy you're talking about. O...c.
There are possibly two ways to automate the pricing.
The major problem is getting the total for each race calculated seperately, the rest is a breeze.
Either he could change the code to have it calculated automatically, by posting each race on a seperate worksheet, but in the workbook, making the odds calculation and then copying and pasting the field and odds to a front summary worksheet, or you could import the workbook to access or similar, and let access do the actual pricing.
It's not easy, you need someone with more advanced skills than this little black duck!
I've tried to do it before, but it's tricky because you have different field sizes.
|