ts1227
Posts: 12,319
Aug 3, 2011 12:50pm
Apologies for derailing this thread with all football talk. Carry on with more ideas, lol
justincredible
Posts: 32,056
Aug 3, 2011 12:52pm
I don't know where to find a master schedule.
LJ
Posts: 16,351
Aug 3, 2011 12:55pm
ts1227
Posts: 12,319
Aug 3, 2011 12:57pm
justincredible;850759 wrote:I don't know where to find a master schedule.
Looks like it can only be viewed week by week (football page on OHSAA, theres a schedule link on the left, then a dropdown for the week).
Gives you names but not the numeric ID, looks to be in a format that could be pasted right into excel
justincredible
Posts: 32,056
Aug 3, 2011 1:00pm
Ahh, I had no idea that existed.
I'd just need to get those games all copied into an excel file. If anyone has any downtime and can do that, that'd be sweet.
15 pages per week, 10 weeks. Unless there is an option to show more than 25 games per page it would be 150 copy-pasta's.
LJ
Posts: 16,351
Aug 3, 2011 1:04pm
I'll do it for $5 per page
justincredible
Posts: 32,056
Aug 3, 2011 1:55pm
LJ;850773 wrote:I'll do it for $5 per page
How 'bout I tell you to fuck off 5 times per page?
justincredible
Posts: 32,056
Aug 3, 2011 4:43pm
Here is a quick, un-styled, no-frills scoreboard. It should be really easy to get this up and running quickly.
[ATTACH]52[/ATTACH]
[ATTACH]52[/ATTACH]
F
fan_from_texas
Posts: 2,693
Aug 3, 2011 5:04pm
I like the scoreboard idea and the blog idea, though it'd be important to keep blogs updated semi-regularly. Is there a way we could do digg-style voting/moderation so that the best blogs rise to the top?
Another option, which had been discussed before, I think, would be to import school data into a database. I'm generally thinking of this along the lines of football, but it wouldn't be too tough to allow users to popup box a school, then query the db and populate a page with name, mascot, stadium location (with google maps link), schedule/results (I believe I have all game scores back to 2000) by year, etc. It wouldn't be too difficult to generate the OHSAA ratings for each region, either, or power ratings/power poll from the OC.
Another option, which had been discussed before, I think, would be to import school data into a database. I'm generally thinking of this along the lines of football, but it wouldn't be too tough to allow users to popup box a school, then query the db and populate a page with name, mascot, stadium location (with google maps link), schedule/results (I believe I have all game scores back to 2000) by year, etc. It wouldn't be too difficult to generate the OHSAA ratings for each region, either, or power ratings/power poll from the OC.
justincredible
Posts: 32,056
Aug 3, 2011 5:09pm
Will you go more into the second option? You personally have the score to all of the games from back 2000 to present? I think the rest of what your saying is something that I sort of had in that brief lived version of the site that had the scoreboard. I wonder if we could come up with a formula to automatically generate an OC power ranking?
As for the blog, yeah, it would definitely have to stay fresh. I'd like to get a stable of 10-15 regular bloggers that focus on a topic to each blog once or twice a week. Also allow anyone else to create a blog entry, too. That would give us a ton of fresh content, hopefully.
As for the blog, yeah, it would definitely have to stay fresh. I'd like to get a stable of 10-15 regular bloggers that focus on a topic to each blog once or twice a week. Also allow anyone else to create a blog entry, too. That would give us a ton of fresh content, hopefully.
ts1227
Posts: 12,319
Aug 3, 2011 5:33pm
FYI I have the master schedule in Excel but had to go to some dumbass family thing. I'll post it later.
As for the database thing ala last year fft referred to, stadium location can be a bitch for anyone who does not play at their HS, as the OHSAA only gives the HS address.
As for the database thing ala last year fft referred to, stadium location can be a bitch for anyone who does not play at their HS, as the OHSAA only gives the HS address.
F
fan_from_texas
Posts: 2,693
Aug 3, 2011 5:57pm
Yeah, I personally have a SQLite DB with scores from every Ohio HS game going back to 2000. I have a number of ELO/Sagarin/Massey-based formulas that automatically generate power rankings, so if the OC wanted to adopt those wholesale, that'd work. See, e.g., this link.justincredible;850975 wrote:Will you go more into the second option? You personally have the score to all of the games from back 2000 to present? I think the rest of what your saying is something that I sort of had in that brief lived version of the site that had the scoreboard. I wonder if we could come up with a formula to automatically generate an OC power ranking?
Or we can tweak it so that our Mike Clark's high school always finishes last.
justincredible
Posts: 32,056
Aug 3, 2011 6:19pm
Sweet.ts1227;850989 wrote:FYI I have the master schedule in Excel but had to go to some dumbass family thing. I'll post it later.
As for the database thing ala last year fft referred to, stadium location can be a bitch for anyone who does not play at their HS, as the OHSAA only gives the HS address.
fan_from_texas;851007 wrote:Yeah, I personally have a SQLite DB with scores from every Ohio HS game going back to 2000. I have a number of ELO/Sagarin/Massey-based formulas that automatically generate power rankings, so if the OC wanted to adopt those wholesale, that'd work. See, e.g., this link.
Or we can tweak it so that our Mike Clark's high school always finishes last.
This sounds awesome. Any chance you can send me a sql dump of that database? This runs on mysql, which I believe is the same structure as sqlite.
sej
Posts: 540
Aug 3, 2011 7:02pm
Tell me what bitch work you need done and I can probably find some free time to do it.
As for blogging, if you need cooking/crafting, general randomness or hilarious mom stories (sorry...I don't think I'll throw in the breast feeding picture) I can probably volunteer even though my blog still only has one post...sigh.
As for blogging, if you need cooking/crafting, general randomness or hilarious mom stories (sorry...I don't think I'll throw in the breast feeding picture) I can probably volunteer even though my blog still only has one post...sigh.
ts1227
Posts: 12,319
Aug 3, 2011 11:49pm
Sent it to your OC email. Too large to post on here (probably due to the fucking links that carried over)
F
fan_from_texas
Posts: 2,693
Aug 4, 2011 10:32am
justincredible;851018 wrote:This sounds awesome. Any chance you can send me a sql dump of that database? This runs on mysql, which I believe is the same structure as sqlite.
Is CSV fine?
justincredible
Posts: 32,056
Aug 4, 2011 11:03am
fan_from_texas;851502 wrote:Is CSV fine?
Yep. It's probably a better format for me anyway.
LJ
Posts: 16,351
Aug 4, 2011 11:28am
I think we definitely need someone to blog about the Ohio music scene.
wes_mantooth
Posts: 17,977
Aug 4, 2011 11:38am
LJ;851558 wrote:I think we definitely need someone to blog about the Ohio music scene.
Damn shame upper doesn't post on here anymore....he would be perfect
justincredible
Posts: 32,056
Aug 4, 2011 11:38am
Just sent out a tweet looking for bloggers. We'll see if that leads to anything.
justincredible
Posts: 32,056
Aug 4, 2011 11:38am
wes_mantooth;851563 wrote:Damn shame upper doesn't post on here anymore....he would be perfect
Yep, I really wish he would come back.
LJ
Posts: 16,351
Aug 4, 2011 11:45am
justincredible;851564 wrote:Just sent out a tweet looking for bloggers. We'll see if that leads to anything.
I've got outdoors on lockdown....
Here's the rundown
NCF- Workouts
CoA-- Pwnage
CC-- Molestation
Lotz & Dynasty-- passive agressiveness and other ways to piss people off
Big Gain & Tiernan-- Inferiority Complexes and other social disorders
Bigdogg and Ender-- Speaking out against "the man"
Heretic
Posts: 18,820
Aug 4, 2011 11:46am
Best. Blogs. Ever.
ts1227
Posts: 12,319
Aug 4, 2011 11:50am
Sleeper has to get an OSU blog
LJ
Posts: 16,351
Aug 4, 2011 12:06pm
LJ;851571 wrote:I've got outdoors on lockdown....
Here's the rundown
NCF- Workouts
CoA-- Pwnage
CC-- Molestation
Lotz & Dynasty-- passive agressiveness and other ways to piss people off
Big Gain & Tiernan-- Inferiority Complexes and other social disorders
Bigdogg and Ender-- Speaking out against "the man"
Sleeper & CBF-- OSU Sports
amended