Hi Everyone, I've found the file I'd like to merge with my Fantasy Football programme. Unfortunatly this one is password locked so I can't read the formulas to try and do it myself. I'd like to be able to add this to my programme, so when you put in the result it automatically adds the number of wins, draws and goals to the results tab.
Hope you can help. If memory serves one of you guys did this for a previous world cup. But it no longer appears to be on here. I know it's a big ask, butI'm hoping you can help. Kind Regards Gary Hunt. http://soccerwallcharts.com/
Posts by Garyhunt6809
-
-
Hi Everyone, I'm back after a long absence. I've done another World Cup Fantasy Football program for this summers world cup. With my program you ask all your friends to rank all the 32 Countries from 32 to 1pt giving 32pts to the Country you think will win the world cup, 31pts to the runner up and so on down to the Country you consider the weakest on just 1pt. Enter everyone's selections into the 'Data' Tab, and the add in after each match the number of Wins, Draws and Goals into the 'Results' tab. Now go to the 'Results tab and my program has added up everyone's score. Now here's my CHEEKY request. I've love to be able to enter the results into the 'Match Order' tab, and the program adds up all the sores and updates the tables, score and wallchart. There used to be a wallchart on this forum that did all of this from a previous World Cup but I can't find in on here. Maybe it's been removed ? Iknow it's a lot to ask but I'm hoping you'll all be able to help. You can all still use my program as it is, as it still works, but I'd love to get the 'Match Order' tab to work. Kind regards Gary Hunt
Attached Files -
Hi Everyone, I'm back after a long absence. I've done another World Cup Fantasy Football program for this summers world cup. With my program you ask all your friends to rank all the 32 Countries from 32 to 1pt giving 32pts to the Country you think will win the world cup, 31pts to the runner up and so on down to the Country you consider the weakest on just 1pt. Enter everyone's selections into the 'Data' Tab, and the add in after each match the number of Wins, Draws and Goals into the 'Results' tab. Now go to the 'Results tab and my program has added up everyone's score. Now here's my CHEEKY request. I've love to be able to enter the results into the 'Match Order' tab, and the program adds up all the sores and updates the tables, score and wallchart. There used to be a wallchart on this forum that did all of this from a previous World Cup but I can't find in on here. Maybe it's been removed ? Iknow it's a lot to ask but I'm hoping you'll all be able to help. You can all still use my program as it is, as it still works, but I'd love to get the 'Match Order' tab to work. Kind regards Gary Hunt
-
Re: World Cup Fantasy Football
Hi there Barry, I've been too bust to even look at it. Given how little time is left, I think I just stick with the basic one I wrote, and you streamlined. Thanks for all the help and advice, but I don't think there's time to iron out all the bugs this type of thing can generate. For example what if two or more Countries have the same wins, draws, goals scored and goal difference. Now FIFA have a very complicated count back system to the qualifiers, now you can imagine how complex that would be to implement.
Thanks Again
Gary Hunt -
Re: World Cup Fantasy Football
Hi there, I get the error as soon as the programme runs. I've tried running straight away and saving it first, and the running it. Still I get the same error.
Thanks for getting back to me.
Gary
-
Re: World Cup Fantasy Football
Hi there, I seem to have problems with the download. it always returns a "Run-Time Error 1004" I don't know if this is a fault with my pc or a corrupt file. can you please check your file.
Thanks
Gary -
Re: World Cup Fantasy Football
Well done Marcus, this is very similar to the one I sent a link to. Do you think it is possible to add in my programme to yours ? copying the No. of Wins, Draws, and Goals to the 'Results' tab of my programme, so that automatically updates the league table on my programme.
Many thanks for this programme
Gary Hunt -
Re: World Cup Fantasy Football
[ATTACH=CONFIG]60618[/ATTACH]
Hi there, It appears that this file no longer exists on this forum. Attached is what I would like to add to this programme. I've added a new tab called 'Match Order' and I would like the data from this tab to copy the results to the 'Results' tab.
Also how do you make the programme copy the correct Country to the correct cell after the first round matches are all done ? There must be 100's of either or permatations.
Is it also possible to make the mini tables on the 'Match Order' tab to work after the results have been added to this tab ?
I realise I'm asking an awful lot here, but if you guys can crack this it would make this programme complete. If this can't be done automatically, it can still be done manually.
Even if this can't be done I still feel that this is a good little programme that you could run in your work place, local pub, or amongst your friends and family.Many Thanks
Gary Hunt -
Re: World Cup Fantasy Football
Hi All, I know this a bit cheeky but I'd love to merge my programme with this old electronic wallchart from another members post back in 2006. (see attached link)
http://www.ozgrid.com/forum/sh…orld+cup+fantasy+football
Hope someone can help.
Many Thanks
Gary Hunt
-
Re: World Cup Fantasy Football
Hi There, Thanks for that it does the trick.
-
Hi There, Here's a little programme I wrote for the upcoming World Cup
I run this at my workplace and usually get about 80-100 people entering.Here's how it works:
1. Ask everyone to make their selections based on the following criteria: Give 32 pts to the Country you think will win the world cup, 31 pts to the runner up, and so on down to the Country you consider the weakest on just 1 pt.
2. Enter everybody's selections
3. Enter the number of wins draws and goals after every game.
4. Sort & share the results.That's all there is to it.
How much you charge to enter and how you split the prize money is up to you.
If anybody wants to add any improvements then they would be welcomed.
All the best Gary Hunt
-
Re: 'if' cell matches another
Hi there, I've recently added a Fantasy Football programme on this forum. Have a look at it, it may be useful to you. just search euro 2012
-
I wrote this fantasy football programme some years ago. I just want to share it with you guys.
This programmes works, and requires no help. feel free to share it, or improve it if you want.Gary Hunt
-
Before I explain what help I need I suppose i best explain what the programme does.
I've created this fantasy football programe to calculate all the scores from all matches in this years European Championships.
Basically everybody ranks each team from 1 to 16, giving 16 points to the country you think will win the european championship, 15 points to the runner up, and so on down to the country, you think is the weakest on just 1 point.
Everytime I try and change one of the values in the 'Results' tab I get an "Compile Error/Syntax Error".
What this macro should do is sort all the data in the "League Table" tab into a highscore table list.
Many Thanks for any help or advise offered.
Gary Hunt
CodePrivate Sub Worksheet_Calculate() Application.EnableEvents = False Range("b1").CurrentRegion.Sort _ Key1:=Range("h2"), Order1:=xldescending, Key2:=Range("c2"), Order2:=xldescending, key3:=Range("e2"), order3:=x1descending, Header:=xlYes Application.EnableEvents = True End Sub
I hope this is something simple, I've look at the past questions but none of them quite match what i'm trying to do.
-
Re: Count Lottery Rollovers
Quote from DomenicTo count the number of times that 3 consecutive draws have no winner, try the following...
=SUM(IF(FREQUENCY(IF($J$2:$J$30<>"",IF($J$2:$J$30=0,ROW($J$2:$J$30))),IF($J$2:$J$30<>0,ROW($J$2:$J$30)))=3,1))
...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.
Have a look at the attached file. You'll notice that the data for Column J is only entered once the draw has taken place.
Hope this helps!
Thanks for that. you guys are great !!!!!
-
I'm trying to get excel to count the number of single double and treble lottery rollovers. I can get the single count to work but have no idea how to count double and treble rollovers, (i.e. two or three draws that have no winners in sucessive draws.) I also need it to ignore draws that have yet to be drawn. I've added a sample peice of code to show what I mean.
Many Thanks for any help offered.
Gary Hunt
-
Re: Days Since
Thanks for that, sorry about not replying sonner, I've been busy.
Thank You
Gary Hunt
-
I'm having trouble getting the days since count to work correcty. It works fine when only counting the number of days that have elpases between a number being drawn in a lottery draw (Main numbers Only), and it being drawn again as a main number. However if I try to include the bonus ball into this count, it just returns an error. I've tried altering the old code, but I can't get it right. I've included 2 old codes as an example. Sorry I can't include the full programme as it's huge, way to big for this forum.
Many Thanks for any help or advise offered.
-
Re: Count Range Of Numbers
Thank you
-
Re: Count Range Of Numbers
Thanks for the reply, Can you just confirm that you can put spaces into formulas and don't effect the operation or the result? Does that effect the 256 charater formula limit?
Thanks
Gary Hunt