Spreadsheet Help!!!
- voodooray
- Wideboy
- Posts: 52
- Joined: 28 Jul 2008, 09:34
- Location: Preston
- FS Record: SDT Top 100,SDT Works League Champion 05/06,07/08,08/09
Spreadsheet Help!!!
Oreet Guys,
Im looking at doing a premier league predictions game at work.
Was hoping that someone may already have a spreadsheet for download!!
The basis is pretty simple,with 1 point being awarded for a correct outcome to the match ( i.e the prediction was a 0-0 draw,but the game ended 1-1,outcome draw) and 3 point being awarded if the result is correct ( predicted 0-0,result 0-0).
Also we intend to have a weekly joker on 1 match,with the joker awarding you double points.
Hope something similar exists as it would save me a loada time...
Nice one in advance!!
Im looking at doing a premier league predictions game at work.
Was hoping that someone may already have a spreadsheet for download!!
The basis is pretty simple,with 1 point being awarded for a correct outcome to the match ( i.e the prediction was a 0-0 draw,but the game ended 1-1,outcome draw) and 3 point being awarded if the result is correct ( predicted 0-0,result 0-0).
Also we intend to have a weekly joker on 1 match,with the joker awarding you double points.
Hope something similar exists as it would save me a loada time...
Nice one in advance!!
- murf
- FISO Viscount
- Posts: 109611
- Joined: 13 Oct 2005, 18:28
- Location: here
- FS Record: Once led TFF. Very briefly.
- FPL:
- Contact:
Re: Spreadsheet Help!!!
Jokering aside, you could just create a minileague in FISO Goals.voodooray wrote:Oreet Guys,
Im looking at doing a premier league predictions game at work.
Was hoping that someone may already have a spreadsheet for download!!
The basis is pretty simple,with 1 point being awarded for a correct outcome to the match ( i.e the prediction was a 0-0 draw,but the game ended 1-1,outcome draw) and 3 point being awarded if the result is correct ( predicted 0-0,result 0-0).
Also we intend to have a weekly joker on 1 match,with the joker awarding you double points.
Hope something similar exists as it would save me a loada time...
Nice one in advance!!
- Shaggy365
- Dumbledore
- Posts: 7488
- Joined: 19 Feb 2007, 15:24
- Location: Promoting choir website
- Contact:
Re: Spreadsheet Help!!!
... or use IKTS on the fpl website.
- voodooray
- Wideboy
- Posts: 52
- Joined: 28 Jul 2008, 09:34
- Location: Preston
- FS Record: SDT Top 100,SDT Works League Champion 05/06,07/08,08/09
Re: Spreadsheet Help!!!
murf wrote:Jokering aside, you could just create a minileague in FISO Goals.voodooray wrote:Oreet Guys,
Im looking at doing a premier league predictions game at work.
Was hoping that someone may already have a spreadsheet for download!!
The basis is pretty simple,with 1 point being awarded for a correct outcome to the match ( i.e the prediction was a 0-0 draw,but the game ended 1-1,outcome draw) and 3 point being awarded if the result is correct ( predicted 0-0,result 0-0).
Also we intend to have a weekly joker on 1 match,with the joker awarding you double points.
Hope something similar exists as it would save me a loada time...
Nice one in advance!!
Cheers for the idea ont mini league in Fiso goals,but tbh dont think the lazy bigger who are gonna be involved will even consider joining on here n then havin to log in etc is just far to much hassle...
The search goes on then...
- murf
- FISO Viscount
- Posts: 109611
- Joined: 13 Oct 2005, 18:28
- Location: here
- FS Record: Once led TFF. Very briefly.
- FPL:
- Contact:
Re: Spreadsheet Help!!!
Try sending a PM to thelip, he ran a scoring spreadsheet for the forerunner of FISO Goals that we ran on here before it was taken and automated.
I don't think he calculated the points from each game though so would only be half your answer.
I don't think he calculated the points from each game though so would only be half your answer.
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
Re: Spreadsheet Help!!!
You can set the spreadsheet up yourself as a small nested IF+AND statement will calculate the points for you.
- barry
- FISO Knight
- Posts: 18877
- Joined: 13 Oct 2005, 18:43
- Location: moving into fisodas towers
- FPL:
- Contact:
Re: Spreadsheet Help!!!
I can rustle up a template for you if you're capable of tweaking it to suit your needs...voodooray wrote:Oreet Guys,
Im looking at doing a premier league predictions game at work.
Was hoping that someone may already have a spreadsheet for download!!
The basis is pretty simple,with 1 point being awarded for a correct outcome to the match ( i.e the prediction was a 0-0 draw,but the game ended 1-1,outcome draw) and 3 point being awarded if the result is correct ( predicted 0-0,result 0-0).
Also we intend to have a weekly joker on 1 match,with the joker awarding you double points.
Hope something similar exists as it would save me a loada time...
Nice one in advance!!
- DixieDean
- FISO Jedi Knight
- Posts: 20944
- Joined: 13 Oct 2005, 18:27
- Location: You Got To Have Soul... ♪ ♫
- FS Record: 2 Top 100 finishes in TFFO; £270 in CYKI since 2008
- FPL:
Re: Spreadsheet Help!!!
Didn't realise you were an Excel Rustler Bazza!!!
A man of many talents...
A man of many talents...
- barry
- FISO Knight
- Posts: 18877
- Joined: 13 Oct 2005, 18:43
- Location: moving into fisodas towers
- FPL:
- Contact:
Re: Spreadsheet Help!!!
I knew the basics but have learnt shit loads taking on FISODAS!
- DixieDean
- FISO Jedi Knight
- Posts: 20944
- Joined: 13 Oct 2005, 18:27
- Location: You Got To Have Soul... ♪ ♫
- FS Record: 2 Top 100 finishes in TFFO; £270 in CYKI since 2008
- FPL:
Re: Spreadsheet Help!!!
Yep... got to agree
I've learned a lot doing my Combo thing... although all the real techie stuff is done by jacksosi.
He very good.
I've learned a lot doing my Combo thing... although all the real techie stuff is done by jacksosi.
He very good.
- barry
- FISO Knight
- Posts: 18877
- Joined: 13 Oct 2005, 18:43
- Location: moving into fisodas towers
- FPL:
- Contact:
Re: Spreadsheet Help!!!
aye, techie stuff is way beyond me
- voodooray
- Wideboy
- Posts: 52
- Joined: 28 Jul 2008, 09:34
- Location: Preston
- FS Record: SDT Top 100,SDT Works League Champion 05/06,07/08,08/09
Re: Spreadsheet Help!!!
Barry,any help is much appreciated bud,gotta work colleague who could have a butchers at it n adapt accordingly me reckons....barry wrote:I can rustle up a template for you if you're capable of tweaking it to suit your needs...voodooray wrote:Oreet Guys,
Im looking at doing a premier league predictions game at work.
Was hoping that someone may already have a spreadsheet for download!!
The basis is pretty simple,with 1 point being awarded for a correct outcome to the match ( i.e the prediction was a 0-0 draw,but the game ended 1-1,outcome draw) and 3 point being awarded if the result is correct ( predicted 0-0,result 0-0).
Also we intend to have a weekly joker on 1 match,with the joker awarding you double points.
Hope something similar exists as it would save me a loada time...
Nice one in advance!!
Cheers Again...
- barry
- FISO Knight
- Posts: 18877
- Joined: 13 Oct 2005, 18:43
- Location: moving into fisodas towers
- FPL:
- Contact:
Re: Spreadsheet Help!!!
how many folk are playing? - pm me your email address mate and I'll send you something tonight.
- barry
- FISO Knight
- Posts: 18877
- Joined: 13 Oct 2005, 18:43
- Location: moving into fisodas towers
- FPL:
- Contact:
Re: Spreadsheet Help!!!
mailed you a template. give it a go and let me kow if you have any problems
View Latest: 1 Day View Your posts