|
|
Post by malcolmnl on Aug 16, 2010 20:45:42 GMT
Are there any mathmatical and Excel experts here? I need help with a (for me) complex calculation in Excel. If you feel up to a challange please PM me for more information.
Its basically about awarding points for correct forecasting of a match score and/or result. e.g. exact correct score forecast = 3 points and correct home, away or draw but wrong score = 1 point. Any suggestions?
|
|
|
|
Post by 'Beav' on Aug 16, 2010 20:49:31 GMT
I was going to do what you're doing but I couldn't be bothered.
If you have a 'team statistic' area with 'wins - draws - loses - goals' and what not. Then you would do an 'IF forumula'
|
|
|
|
Post by edgecam on Aug 16, 2010 20:51:32 GMT
Are there any mathmatical and Excel experts here? I need help with a (for me) complex calculation in Excel. If you feel up to a challange please PM me for more information. Its basically about awarding points for correct forecasting of a match score and/or result. e.g. exact correct score forecast = 3 points and correct home, away or draw but wrong score = 1 point. Any suggestions? I have some time tomorrow, drop me via my e-mail address your current spread sheet. My address is visible. I will ping you back tomorrow evening. |
|
|
|
Post by malcolmnl on Aug 16, 2010 21:19:10 GMT
Cheers mate. Email on the way.  |
|
|
|
Post by edgecam on Aug 16, 2010 21:24:43 GMT
Cheers mate. Email on the way. Mal. Got it leave it with me. I will ping it back tomorrow evening. |
|
|
|
Post by oxymoron on Aug 16, 2010 23:32:47 GMT
Malc, your Email is not visible; edgecam has the ball but feel free to drop me a line if you need any further help....
|
|
|
|
Post by Pogue Mahone on Aug 17, 2010 7:31:04 GMT
This is what I use for the prediction league in N&I section....
|
|
|
|
Post by malcolmnl on Aug 17, 2010 14:14:56 GMT
Thanks folks. I'll await edgecam's reply and come back if I need any more help.
Pogue, nothing visible? Do you use invisible man tactics?
Oh, and my email is now visible for you folks. For a short while anyway.
|
|
|
|
Post by Pogue Mahone on Aug 18, 2010 9:04:42 GMT
Thanks folks. I'll await edgecam's reply and come back if I need any more help. Pogue, nothing visible? Do you use invisible man tactics? Oh, and my email is now visible for you folks. For a short while anyway. Je ne comprendez pas. |
|
|
|
Post by malcolmnl on Aug 18, 2010 18:07:26 GMT
Que?
|
|
|
|
Post by 'Beav' on Aug 18, 2010 18:09:30 GMT
Do you not understand? (i believe)
|
|
|
|
Post by edgecam on Aug 18, 2010 18:40:11 GMT
Mal. Check your in box. I sent you a mail this afternoon. You can call me on my mobile if you need me to talk you through it. My mobile numbers in the email.
|
|
|
|
Post by malcolmnl on Aug 18, 2010 19:52:18 GMT
Yes got it now. Its great. Thanks. Email should have arrived at your address, I was away all day driving a busload of old coggers to the Open Air museum in Arnhem.
|
|
|
|
Post by edgecam on Aug 18, 2010 20:11:46 GMT
Yes got it now. Its great. Thanks. Email should have arrived at your address, I was away all day driving a busload of old coggers to the Open Air museum in Arnhem. Mal. Got it thanks very much when you over drop me a line. I'm in holland now and again as I have friends in Spikeneese (sorry about the spelling) just outside Rhoon. Speak soon. |
|
