22nd January 2016, 08:05 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 589
|
|
Quote:
|
Originally Posted by walkermac
I'm still around and had a go based on the descriptions of what you wanted (laying otherwise makes very little sense to me).
Brief explanation:
U3:U26 - liability for ranks 1 down to 24
Fill Down columns V & W
Fill Down columns Z through AI
If you're testing combinations of liabilities, use something like this: http://opensolver.org/. It can find the combos that maximise your return/minimise your loss.
No guarantee that it's predictive though. It might just describe the past, rather than forecast the future. |
Thank you Walkermac.
They are better answers than I came up with. I freed up some time and searched for the answers. I had to add extra columns because I could not get multiple equations to work. I knew that there were far easier answers.
Everytime I have started to proceed with excel tuition , I get snowed under elsewhere.
I will download opensolver and see if I can get past the first screen.
__________________
"God made man in his image". He then went to great lengths to ensure that each and every person was unique. God then pondered and said "I will call these human, as very few will rise from the herd to be called individual" http://www.propun.com.au/racing_for...ttons/quote.gif
|