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


Post new topic Reply to topic  [ 24 posts ] 
Author Message
 Post subject: League look and feel - feedback much appreciated please.
PostPosted: 15 Jul 2008, 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
This is going to sound over the top and anal but I really want to get this right because the way I display the respective leagues are based around my screenshots and not the websites that FPL and TFF host. You'll see them anyway because you're taking part but I really want to make what I post some way near to being visually appealing to you. It's the creative idiot with a design background in me that's making this happen. Sorry. :wink: :oops:

Now clearly I have a slight advantage in that I can vary or adjust what I post based on your feedback... Which is nice. So, if I put my thoughts on the table I hope you can take the time to get back to me on here and help me produce a sidegame you want to play this season and hopefully many more seasons after that.

So far I've worked out a colour scheme that seems to work and some of you say looks good so that's cool. This also now includes a key that shows your relative experience in each game.

I've also had an idea to show each league's total score and position overall so we can see if we really are any good as a group!!! :wink:

I'm sure there are opinions you guys might have about how this all looks (I'll attach a screenshot in this post) and , as I said I really would appreciate your thoughts and ideas.

Cheers


Rich


The FPL league as it looks now - The TFF and Combined would look pretty much the same.
Attachment:
feedback.png
feedback.png [ 20.35 KiB | Viewed 985 times ]


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 15 Jul 2008, 23:24 
Offline
FISO Knight
User avatar

Joined: Mon Mar 03 2008
Posts: 11265
Location: Tung Chung
FS Record: Immense.
To be totally honest mate the screenshot looks great, colours and all. Including the league position is a touch aswell, unless of course it's really bad. :lol:

How often are you planning to update the thread with the league table etc. once a week or every set of matches ? Also, will there be a banter thread, seeing as you have your own forum section for the FPL/TFF combined league :?:


Top
 Profile  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 15 Jul 2008, 23:35 
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
TheCharltonFan wrote:
To be totally honest mate the screenshot looks great, colours and all. Including the league position is a touch aswell, unless of course it's really bad. :lol:

How often are you planning to update the thread with the league table etc. once a week or every set of matches ? Also, will there be a banter thread, seeing as you have your own forum section for the FPL/TFF combined league :?:


Thanks for the feedback TCF... There's some quality players that have joined up so I'm hoping the top 5 in each comp will do us proud over the season.

I hadn't really thought about a banter thread but I or someone else can kick that off as the season starts. I'll post the leagues once a week after all matches have been played and TFF and FPL have updated their scores. That's what I'm governed by to be honest - and the reason I wanted 2 dedicated leagues. I'd reckon that on most weeks a Wednesday or Thursday night will be the time I update it all on here.


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 00:08 
Offline
Dumbledore
User avatar

Joined: Thu Oct 13 2005
Posts: 5206
Location: Just about here
Blog: View Blog (2)
FS Record: 116th in TFF 05/06
Like the look of that as it is DD. Glad to see side games have hit TFF - just hoping we get some nice discount codes now too :D


Top
 Profile WWW FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 00:32 
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
Mystery wrote:
Like the look of that as it is DD. Glad to see side games have hit TFF - just hoping we get some nice discount codes now too :D


thelip and his cup of eggs might want to pull you up on the TFF sidegame comment but hey... I agree about some kind of discount. :wink:


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 00:35 
Offline
DWdore
User avatar

Joined: Thu Oct 13 2005
Posts: 7351
Location: Inverness
FS Record: Tiny League Champion 2010/11 TFF: MOTMo March 2012, MOTW in previous 3 seasons, finished 9th in 07/08
...and I'm adding another side game :lol:


DD you're just showing off now! Looks really good.

Need these 8-) though .


Top
 Profile WWW FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 00:40 
Offline
Dumbledore
User avatar

Joined: Thu Oct 13 2005
Posts: 5206
Location: Just about here
Blog: View Blog (2)
FS Record: 116th in TFF 05/06
DixieDean wrote:
Mystery wrote:
Like the look of that as it is DD. Glad to see side games have hit TFF - just hoping we get some nice discount codes now too :D


thelip and his cup of eggs might want to pull you up on the TFF sidegame comment but hey... I agree about some kind of discount. :wink:
Yeah yeah I know - thelip has given us the first and the best. Its just nice to see more.


Top
 Profile WWW FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 01:03 
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
Latic wrote:
...and I'm adding another side game :lol:


You are indeed... 8-) The thing is that your rules amount to some kind of legal document - it's quite a body of work to be quite frank - but my rules are roughly 17 well worded lines of perfected English... :P :P :wink:


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 01:06 
Offline
Dumbledore
User avatar

Joined: Thu Oct 13 2005
Posts: 5206
Location: Just about here
Blog: View Blog (2)
FS Record: 116th in TFF 05/06
Simple rules suit my brain best
ImagePot as many balls as you can :P


Top
 Profile WWW FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 01:08 
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
Exactly!!! :lol: :wink:


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 01:14 
Offline
DWdore
User avatar

Joined: Thu Oct 13 2005
Posts: 7351
Location: Inverness
FS Record: Tiny League Champion 2010/11 TFF: MOTMo March 2012, MOTW in previous 3 seasons, finished 9th in 07/08
DixieDean wrote:
Latic wrote:
...and I'm adding another side game :lol:


You are indeed... 8-) The thing is that your rules amount to some kind of legal document - it's quite a body of work to be quite frank - but my rules are roughly 17 well worded lines of perfected English... :P :P :wink:


:lol:
The Latic supercomputer is translating it into several different languages as we speak


Top
 Profile WWW FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 01: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
Latic wrote:
DixieDean wrote:
Latic wrote:
...and I'm adding another side game :lol:


You are indeed... 8-) The thing is that your rules amount to some kind of legal document - it's quite a body of work to be quite frank - but my rules are roughly 17 well worded lines of perfected English... :P :P :wink:


:lol:
The Latic supercomputer is translating it into several different languages as we speak


That 17 lines figure includes carriage returns BTW... :lol: :wink:


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 01:19 
Offline
DWdore
User avatar

Joined: Thu Oct 13 2005
Posts: 7351
Location: Inverness
FS Record: Tiny League Champion 2010/11 TFF: MOTMo March 2012, MOTW in previous 3 seasons, finished 9th in 07/08
:lol: ....and the blob of tippex


Top
 Profile WWW FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 06:47 
Online
FISO Jedi Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 26984
Location: Any man can make mistakes, but only an idiot persists in his error
FS Record: 2008/9 FPL 172nd, CYKI 13th, 2007/8 TFF 6th
I think we'll need a column for the TFF team name as well won't we?

Maybe centre the value columns and Bold the names.


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 16 Jul 2008, 07:37 
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
Spencer4 wrote:
I think we'll need a column for the TFF team name as well won't we?

Maybe centre the value columns and Bold the names.


There's a separate Table for TFF.
The value column will eventually get to 4 figures so that's fine.
I might try bold names but it may be a bit too much visually.

:D


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 21 Jul 2008, 17:19 
Offline
Grumpy Old Man
User avatar

Joined: Thu Oct 13 2005
Posts: 4307
FS Record: FPL 134 overall 06/07 ... never close since
Not part of this - don't play TFF - but have a bit experience in this area so thought I'd pass on a tip I find useful

Looks good DD - but one thing I would do to make it look even better is to turn off gridlines and just use cell borders if you want them - I'm assuming this is in Excel ?

If so (on a PC) go to Tools - Options and then on the View tab uncheck the Gridlines box in Window Options. Not sure where this would be on a MAC but it should be similar. If you don't like how that then looks you can always turn them back on again :)

Best of luck for the season - great concept.


Top
 Profile WWW FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 21 Jul 2008, 18:30 
Online
FISO Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 13396
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
I'm not in this game as I don't play EPL. My only claim is I helped with the spreadsheet!.
Do you think it would be a nice touch to have a column with a little arrow showing wether people moved up or down that week?

Having said that I'm not too sure how it would be done :oops:


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 21 Jul 2008, 19:25 
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
Cheers for the new feedback guys... much appreciated...

RomynPG
I've tried it with the gridlines off and didn't like it but I might play around a bit with borders as you suggest.

Surprised
If you can find a way to edit your script and make it work then I'm all for that idea!!! :wink:

Thanks again


Rich


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 21 Jul 2008, 22:34 
Offline
FISO Knight
User avatar

Joined: Thu Oct 13 2005
Posts: 16721
Location: moving into fisodas towers
Blog: View Blog (1)
I know you can do conditional formatting, so if a cell is a certain value another cell returns X (or an arrow in your case) forgot how to do it though (and I suppose it would only work if you had a "this week rank" column and "last week's rank" column....


Top
 Profile WWW FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 21 Jul 2008, 23:14 
Offline
Grumpy Old Man
User avatar

Joined: Thu Oct 13 2005
Posts: 4307
FS Record: FPL 134 overall 06/07 ... never close since
barry wrote:
I know you can do conditional formatting, so if a cell is a certain value another cell returns X (or an arrow in your case) forgot how to do it though (and I suppose it would only work if you had a "this week rank" column and "last week's rank" column....

I'm not a Excel expert but have dabbled for the FPL side-game cause and the most complex of those is the H2H stuff which does include rise/fall arrows in the overall league table - and that did require "this week rank" column and "last week's rank" column type of thing (well in principle anyway)

Last years H2H thread shows all the output from that spreadsheet - all of which was completely automated - so it is possible to do - but it's really down to dev time vs manual update as to whether it's worth the time to code it.

DD - how can you like having gridlines on :shock: :wink:


Top
 Profile WWW FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 21 Jul 2008, 23:23 
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
RomynPG wrote:
DD - how can you like having gridlines on :shock: :wink:


I like faint grey lines... :wink:

I played around earlier and reckon i can make it look better without them but I'm off to bed now so will spend more time on it later.

Re. the up/down stuff. I'm not sure it will fit in with how I want to do this... I want it pretty simple to be honest so that I know how it all works. Maybe as I learn more and the league works on a week by week basis, it could be added in during the season?

Cheers


Rich


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 26 Jul 2008, 11:34 
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
OK guys... I've had another play around with how this looks (sad git that I am) and would appreciate any further feedback.

I'm also thinking about adding your overall league position for each game into the screenshots but I will wait until the season starts to see if I can copy and paste the numbers easily.

Thanks in advance

Rich

TFF:
Attachment:
TFF Wk1.png
TFF Wk1.png [ 39.01 KiB | Viewed 611 times ]

FPL:
Attachment:
FPL Wk1.png
FPL Wk1.png [ 28.3 KiB | Viewed 611 times ]

Combined:
Attachment:
Combo Wk1.png
Combo Wk1.png [ 38.18 KiB | Viewed 611 times ]


Top
 Profile FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 26 Jul 2008, 23:06 
Offline
Dumbledore
User avatar

Joined: Thu Oct 13 2005
Posts: 5206
Location: Just about here
Blog: View Blog (2)
FS Record: 116th in TFF 05/06
Very nice, except I should be a bit higher in TFF and much much MUCH lower in FPL :lol:


Top
 Profile WWW FPL Team Page  
 
 Post subject: Re: League look and feel - feedback much appreciated please.
PostPosted: 06 Aug 2008, 00:24 
Offline
Kevin and Perry
User avatar

Joined: Thu Oct 13 2005
Posts: 22
Location: Kings Lynn, Norfolk
FS Record: No major prizes, but good record in Leagues at work
As a veteran of running an office league in the past my advice would be to keep it simple until you get a feel for how much time it takes to update each week.

I got a bit too adventerous a couple of years ago with excel spreadsheets and created extras like a separate head to head league 3pts for a win, 1 for a draw etc, knock out cup and plate competition fortunately with wimbledon style fixed draw as well as other prizes for biggest margin of victory, most points in a week. longest winning streak etc. in an attempt to keep everyone interested over the whole season.

My efforts were appreciated but it took a lot more time than I had anticipated, especially when I came back from 2 weeks holiday abroad!

What you've done so far looks excellent and doesn't appear as though it will be too onerous to maintain either.


Top
 Profile WWW  
 
Display posts from previous:  Sort by  
Bookmark and Share
Post new topic Reply to topic  [ 24 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


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: