FISO News   Admin's Spanish Holiday Apartment Rental Offer     FISO News   Rooney, Balotelli, Torres, RVP   


Post new topic Reply to topic  Page 1 of 1
  [ 14 posts ] 
  Previous topic | Next topic 
Author Message
voodooray
 Post subject: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 13:13 
Offline
Wideboy
User avatar

Joined: Mon Jul 28 2008
Posts: 52
Location: Preston
FS Record: SDT Top 100,SDT Works League Champion 05/06,07/08,08/09
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!!
Top
 Profile  
 
murf
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 13:54 
Offline
FISO Baron
User avatar

Joined: Thu Oct 13 2005
Posts: 61618
Location: Chilling in a Fantasy Football free world
Blog: View Blog (9)
FS Record: Good at something
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!!


Jokering aside, you could just create a minileague in FISO Goals.
Top
 Profile WWW FPL Team Page  
 
Shaggy365
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 15:04 
Offline
Grumpy Old Shaggy
User avatar

Joined: Mon Feb 19 2007
Posts: 4044
Location: Promoting Mrs S cake business (see www button)
... or use IKTS on the fpl website.
Top
 Profile WWW FPL Team Page  
 
voodooray
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 17:19 
Offline
Wideboy
User avatar

Joined: Mon Jul 28 2008
Posts: 52
Location: Preston
FS Record: SDT Top 100,SDT Works League Champion 05/06,07/08,08/09
murf wrote:
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!!


Jokering aside, you could just create a minileague in FISO Goals.



Cheers for the idea ont mini league in Fiso goals,but tbh dont think the lazy buggers 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...
Top
 Profile  
 
murf
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 17:21 
Offline
FISO Baron
User avatar

Joined: Thu Oct 13 2005
Posts: 61618
Location: Chilling in a Fantasy Football free world
Blog: View Blog (9)
FS Record: Good at something
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.
Top
 Profile WWW FPL Team Page  
 
Surprised
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 18:15 
Offline
FISO Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 13414
Location: Location! Location!
Blog: View Blog (2)
FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
You can set the spreadsheet up yourself as a small nested IF+AND statement will calculate the points for you.
Top
 Profile FPL Team Page  
 
barry
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 22:05 
Offline
FISO Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 16722
Location: moving into fisodas towers
Blog: View Blog (1)
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!!


I can rustle up a template for you if you're capable of tweaking it to suit your needs...
Top
 Profile WWW FPL Team Page  
 
DixieDean
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 22:17 
Offline
FISO Jedi Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 20542
Location: You Got To Have Soul... ♪ ♫
FS Record: 2 Top 100 finishes in TFFO; £270 in CYKI since 2008
Didn't realise you were an Excel Rustler Bazza!!! :wink:

A man of many talents... :wink: 8-)
Top
 Profile FPL Team Page  
 
barry
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 22:22 
Offline
FISO Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 16722
Location: moving into fisodas towers
Blog: View Blog (1)
I knew the basics but have learnt shit loads taking on FISODAS!
Top
 Profile WWW FPL Team Page  
 
DixieDean
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 22:33 
Offline
FISO Jedi Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 20542
Location: You Got To Have Soul... ♪ ♫
FS Record: 2 Top 100 finishes in TFFO; £270 in CYKI since 2008
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. 8-) :lol:
Top
 Profile FPL Team Page  
 
barry
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 06 Jul 2010, 22:44 
Offline
FISO Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 16722
Location: moving into fisodas towers
Blog: View Blog (1)
aye, techie stuff is way beyond me :lol:
Top
 Profile WWW FPL Team Page  
 
voodooray
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 08 Jul 2010, 20:53 
Offline
Wideboy
User avatar

Joined: Mon Jul 28 2008
Posts: 52
Location: Preston
FS Record: SDT Top 100,SDT Works League Champion 05/06,07/08,08/09
barry wrote:
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!!


I can rustle up a template for you if you're capable of tweaking it to suit your needs...


Barry,any help is much appreciated bud,gotta work colleague who could have a butchers at it n adapt accordingly me reckons....

Cheers Again...
Top
 Profile  
 
barry
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 08 Jul 2010, 21:05 
Offline
FISO Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 16722
Location: moving into fisodas towers
Blog: View Blog (1)
how many folk are playing? - pm me your email address mate and I'll send you something tonight.
Top
 Profile WWW FPL Team Page  
 
barry
 Post subject: Re: Spreadsheet Help!!!
PostPosted: 09 Jul 2010, 02:27 
Offline
FISO Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 16722
Location: moving into fisodas towers
Blog: View Blog (1)
mailed you a template. give it a go and let me kow if you have any problems
Top
 Profile WWW FPL Team Page  
 
Display posts from previous:  Sort by  
Bookmark and Share
Post new topic Reply to topic  Page 1 of 1
  [ 14 posts ] 

Board index » FISO Games Forums » FISO GOALS (Premiership Predictions)

All times are UTC [ DST ]

Who is online

Users browsing this forum: No registered users and 0 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: