muppet77 Posted May 19, 2011 Share Posted May 19, 2011 ESPN used to but no longer. any links anyone? must be a grid format Quote Link to comment Share on other sites More sharing options...
froment Posted May 19, 2011 Share Posted May 19, 2011 Re: football fixtures in grid format? This is grid, in my understanding? :unsure www.xscores.com/soccer/Results.jsp?sports=soccer&result=6 www.statto.com/football/stats/fixtures Quote Link to comment Share on other sites More sharing options...
davidc Posted May 19, 2011 Share Posted May 19, 2011 Re: football fixtures in grid format? Statto do a results grid but don't seem to do a fixtures grid. The Michael Wray spreadsheets have the fixtures grid but only cover a limited amount of leagues. Not sure if this type of fixture list is available online. GL Quote Link to comment Share on other sites More sharing options...
muppet77 Posted May 19, 2011 Author Share Posted May 19, 2011 Re: football fixtures in grid format? thank mate. a grid is like this format but for FIXTURE dates, not results: http://soccernet.espn.go.com/grid?league=eng.1&cc=5739 so like this one, but NOT an image or jpeg: http://i.dailymail.co.uk/i/pix/2008/06/16/article-0-01A0933D00000578-357_468x256.jpg Quote Link to comment Share on other sites More sharing options...
muppet77 Posted May 19, 2011 Author Share Posted May 19, 2011 Re: football fixtures in grid format? thanks David, i really need an online version that can update an excel sheet easily. Quote Link to comment Share on other sites More sharing options...
Machine Posted May 19, 2011 Share Posted May 19, 2011 Re: football fixtures in grid format? Surely you could make your own grid in excel quite easily,then just extract the downloaded results to the grid and get the set up just how you want it :dude . Quote Link to comment Share on other sites More sharing options...
muppet77 Posted May 19, 2011 Author Share Posted May 19, 2011 Re: football fixtures in grid format? oh yes, that's pipsqueek. perhaps i should explain a little more.. i want to import the fixture list from the net into excel every so often to make sure it is accurate (as dates change due to postponements and cup clashes etc) so i really need a grid that is updated so i can use it for reference. Quote Link to comment Share on other sites More sharing options...
froment Posted May 19, 2011 Share Posted May 19, 2011 Re: football fixtures in grid format? oh yes' date=' that's pipsqueek.[/quote'] :rollin I've just got too much times on my hands sometimes... I was annoyed by not getting what "grid format" meant, so decided to make such a pipsqueek; according to your additional explanation, you probably won't need it, but if you don't find better solution, you may tweak this one: if you can get regular "table format" updated, the grid will update itself; here it is, right click and "Save As"; Excel 2003, 140 kB: www.gubbed.me/fair/excel_files/betting/Fixtures_Grid.xls There are three sheets; fixtures need to be entered in sheet "data"; I entered only two weeks of norwegian league, and it may be freely continued down; sheet "Grid", obviously, gives grid; sheet "intermediary" is there only because fixtures are not complete, so to avoid empty cells display as "0. January 1900"; once all the fixtures are complete, these two sheets will look exactly the same. Grid collects data untill row 2000, i.e., if there is more than 2000 matches (which doesn't happen, but just to let you know), formulas need to be updated, i.e., just range need to be updated. So, as I said, if you can achieve to keep fixtures in table format at sheet "data" updated, grid will be updated, too. Pay attention that all team names, in all three sheets, must be exactly the same, otherwise it won't work; I say this, because in these fixtures (taken from BetVirus) it appeared that Brann has had extra space when playing away (displaying as "Brann "), which, naturaly, didn't work. Also pay attention to cells format as data; if you simply copy/paste from site, it may change formats. Quote Link to comment Share on other sites More sharing options...
muppet77 Posted May 19, 2011 Author Share Posted May 19, 2011 Re: football fixtures in grid format? great thanks for that mate. I think that may be the only way forward...... import a list of fixtures from a site into excel and then reformat automatically myself into a grid. does anyone know of a simple fixture list that imports cleanly into excel, ie without lots of messy ads that keep altering the layout? ideally id like the date on every row too rather than a heading for ten matches. not too picky am I?! Quote Link to comment Share on other sites More sharing options...
davidc Posted May 19, 2011 Share Posted May 19, 2011 Re: football fixtures in grid format? How about getting your fixtures from here? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.