league table

For Fantasy Football related chat that doesn't come under any of other forum categories.

Moderator: TFF Mods

Post Reply
User avatar
fire olli
Super Star
Super Star
Posts: 1193
Joined: Wed Mar 22, 2006 10:40 am
Location: Chorley, Lancashire

league table

Post by fire olli »

Hi All,

Is there a way of making a league on putting it on a forum like this by using word or excel.

If have tryed a few different ways with and without the of "code" but all it seems to do is bunch the information to the side of the screen.

Any Ideas.

Reason: ''
Image
User avatar
lunchmoney
Legend
Legend
Posts: 9024
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: league table

Post by lunchmoney »

I use Tim's Halfling Scribe CookBook, and after matches are played I use Windows Snipping Tool to copy the table. Then I use Image Shack to post it to my forum. Here's my latest for example.
Image


And at the same time I post a Dropbox link where I keep the Excel spreadsheet so everyone can access it.

Reason: ''
Hired Goon for the NAF (rep for South West England, and UK approval staff)
Image
lunchmoneybb @ gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
voyagers_uk
Da Cynic
Posts: 7462
Joined: Thu Jan 01, 1970 12:00 am
Location: Nice Red Uniforms and Fanatical devotion to the Pope!

Re: league table

Post by voyagers_uk »

nice one Lunch!

Reason: ''
Image
Ikterus wrote: But for the record, play Voyagers_UK if you have the chance. He's cursed! :P
dode74
Ex-Cyanide/Focus toadie
Posts: 2565
Joined: Fri Jul 24, 2009 4:55 pm
Location: Near Reading, UK

Re: league table

Post by dode74 »

You could just save the excel spreadsheet as a web page, could you not?

Reason: ''
User avatar
lunchmoney
Legend
Legend
Posts: 9024
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: league table

Post by lunchmoney »

dode74 wrote:You could just save the excel spreadsheet as a web page, could you not?
Never really thought about doing that. If I were technically inclined and knowledgeable of these things I suppose it could be done.

Reason: ''
Hired Goon for the NAF (rep for South West England, and UK approval staff)
Image
lunchmoneybb @ gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
User avatar
fire olli
Super Star
Super Star
Posts: 1193
Joined: Wed Mar 22, 2006 10:40 am
Location: Chorley, Lancashire

Re: league table

Post by fire olli »

Lunchmoney that all sounds great but I am very bad with computers, any chance you could pm with what to do.

Cheers. Olli

How do you safe a spreadsheet as a web page and what do you do after that.

Reason: ''
Image
User avatar
lunchmoney
Legend
Legend
Posts: 9024
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: league table

Post by lunchmoney »

Subject: league table
fire olli wrote:Lunchmoney that all sounds great but I am very bad with computers, any chance you could pm with what to do.

Cheers. Olli

How do you safe a spreadsheet as a web page and what do you do after that.
Sure. (PM sent also, but posted for anyone else who is curious).

First get hold of MS Excel, one or the other (in no way do I advocate piracy, but it is available if you look around ;)
Tim's webpage with the Cookbook is here http://bbowl.gmxhome.de/scribe/scribe.htm
The download you want is http://bbowl.gmxhome.de/scribe/scribe_league_v4.02.zip
Have a good read of the help page http://bbowl.gmxhome.de/scribe/help.htm and the ReadME tab on the spreadsheet itself.
Set up the league however you want it. I've been playing with it for years and even put in some development ideas in the current version, so I know my way around the workbook, but that's only because I have played around with it. If you save a copy and make back ups it doesnt matter if you break it.

As it stands when first downloaded and not modded, as you enter matches in the Results tab they will appear in the Ranking tab.

Then use Windows Snipping Tool (which comes with Win7, but I'm sure a free version is available somewhere if you are still on xp/vista) to take a snapsnot of the Ranking table.

Create a user name at Image Shack http://imageshack.us/ (there are other image hosting sites, but this one seems to work every where, like here on TFF for example, and is my personally fave) and upload the image created with the Snipping Tool.

Highlight the "forum code" and Copy it. Paste that line into your forum post.


I keep my leagues cookbook in a DropBox folder (dropbox can be downloaded and installed from here https://www.dropbox.com/referrals/NTQ5OTg4MDM5 [if you follow and set up via this referal link we both get more space], follow the really straight forward set up guide to start using it) then when ever I update my league spreadsheet, after a match for example, I copy a new link for my players to download the updated cookbook.


Additional help with the cookbook can be found here on TFF
http://talkfantasyfootball.org/viewtopi ... 20&t=35170
http://talkfantasyfootball.org/viewtopi ... 9278&hilit

Reason: ''
Hired Goon for the NAF (rep for South West England, and UK approval staff)
Image
lunchmoneybb @ gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
User avatar
Darkson
Da Spammer
Posts: 24047
Joined: Mon Aug 12, 2002 9:04 pm
Location: The frozen ruins of Felstad
Contact:

Re: league table

Post by Darkson »

lunchmoney wrote:Then use Windows Snipping Tool (which comes with Win7, but I'm sure a free version is available somewhere if you are still on xp/vista) to take a snapsnot of the Ranking table.
Not sure if there's an easier way on XP, but I use "Print Screen", paste into Paint (or other graphics tool), then crop out the bit I want.

Reason: ''
Currently an ex-Blood Bowl coach, most likely to be found dying to Armoured Skeletons in the frozen ruins of Felstad, or bleeding into the arena sands of Rome or burning rubber for Mars' entertainment.
User avatar
DixonCider
Super Star
Super Star
Posts: 929
Joined: Mon May 14, 2012 5:16 pm
Location: Calgary Canada
Contact:

Re: league table

Post by DixonCider »

Darkson wrote:
lunchmoney wrote:Then use Windows Snipping Tool (which comes with Win7, but I'm sure a free version is available somewhere if you are still on xp/vista) to take a snapsnot of the Ranking table.
Not sure if there's an easier way on XP, but I use "Print Screen", paste into Paint (or other graphics tool), then crop out the bit I want.
adobe print as a pdf is another option

Reason: ''
Image
User avatar
Darkson
Da Spammer
Posts: 24047
Joined: Mon Aug 12, 2002 9:04 pm
Location: The frozen ruins of Felstad
Contact:

Re: league table

Post by Darkson »

That wouldn't help make it readable on the forum.

Reason: ''
Currently an ex-Blood Bowl coach, most likely to be found dying to Armoured Skeletons in the frozen ruins of Felstad, or bleeding into the arena sands of Rome or burning rubber for Mars' entertainment.
dode74
Ex-Cyanide/Focus toadie
Posts: 2565
Joined: Fri Jul 24, 2009 4:55 pm
Location: Near Reading, UK

Re: league table

Post by dode74 »

lunchmoney wrote:
dode74 wrote:You could just save the excel spreadsheet as a web page, could you not?
Never really thought about doing that. If I were technically inclined and knowledgeable of these things I suppose it could be done.
Save as -> use the dropdown to select "Web Page". It saves as HTML.

Reason: ''
User avatar
lunchmoney
Legend
Legend
Posts: 9024
Joined: Wed Dec 10, 2008 2:59 pm
Location: The Dark Future

Re: league table

Post by lunchmoney »

dode74 wrote: Save as -> use the dropdown to select "Web Page". It saves as HTML.
Then I have to do something with it and a website. That's where the trouble starts:)
My method works for me and my small league, I really haven't the patience to teach my self about working with web pages.

Reason: ''
Hired Goon for the NAF (rep for South West England, and UK approval staff)
Image
lunchmoneybb @ gmail.com

TOs! You do not need multiple copies of rosters. It's a waste of paper.
Bribe level: good coffee.
#FlingNation find me on page 95
Post Reply