Spreadsheet Help!!!

[voodooray]

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!!

[murf]

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.

[Shaggy365]

... or use IKTS on the fpl website.

[voodooray]

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 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]

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.

[Surprised]

You can set the spreadsheet up yourself as a small nested IF+AND statement will calculate the points for you.

[barry]

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...

[DixieDean]

Didn't realise you were an Excel Rustler Bazza!!!

A man of many talents...

[barry]

I knew the basics but have learnt shit loads taking on FISODAS!

[DixieDean]

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.

[barry]

aye, techie stuff is way beyond me

[voodooray]

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...

[barry]

how many folk are playing? - pm me your email address mate and I'll send you something tonight.

[barry]

mailed you a template. give it a go and let me kow if you have any problems