Ubuntu QA:
BlogBrainstorm
Log in
Ubuntu QA
The Ubuntu community has contributed 12232 ideas, 57574 comments, 1174524 votes

Idea #6312: Football Pool App Idea



up
-30
down
Written by Monkey Talks the 3 Apr 08 at 04:21. Category: Office.
Related to: Nothing/Others. Status: New
Description
I think this probably classifies as an Office type app rather than games even though it is for football.

We have a little football pool for family & friends every year. Up 'til a couple years ago they used to have to fill out a grid in pen with everybody's picks and it took a LONG time and was prone to human error and penmanship problems. I'm not much into football but it seemed to be a good job for a PC so I've been handling the pool for the past couple years.

I found some software that handles it, but it is padded with a bunch of stuff nobody needs, I have to edit (simplify) the reports to suit our purposes and it seems like it would be a relatively easy application to write. If only I was a programmer. Seems like a simple, small database thing. A couple of features would make it extremely nice to use.

Here's the outline.
Beginning of season - enter team names and 2 or 3-letter team abbreviation (for printing in the grid). Enter weekly contests for the season (i.e. week 1 A vs. B, X vs Y - week 2 A vs Y, B vs X, etc.)
Weekly contest data is used to generate a report (pick sheet) for that week.

During season - Enter participants names, enter each participants picks by clicking Home vs Visitor down the list for that week.
After all participants picks are made, it prints a summary report (recap sheet) showing a list of participants and their picks on a grid.
That's pretty much it.

Extra features would be:
Generates a simple "Pick Sheet" web page so folks could make their picks on the net and when they hit "submit" it sends an email to the manager (i.e. me) to enter into the software.
Online picks could be directly imported into the program via email rather than have to enter each pick individually.
After picks are made, the recap sheets can be generated in both HTML (to be uploaded to a web page for viewing) and maybe RTF and/or PDF to be emailed to participants so they can print their own and follow along as the games progress.

That's pretty much it. Long post, but it's a simple idea I hope.

Hopefully this isn't just another hare-brained idea. Seems like more people would use this than an astronomy application, though not nearly as interesting to use or write.

Thanks for any input. If anybody is interested in this, I can reply with more specific info.
Tags: (none)

Attachments
No attachments.


Duplicates


Comments
deadowl wrote on the 3 Apr 08 at 04:23
I could write this if you were willing to pay me.

Monkey Talks wrote on the 3 Apr 08 at 04:35
If I had a dime I'd try to find a programming class and give it a go myself, but here's an idea:
Write the NFL season pool program and get it packaged with Ubuntu (or offer it as a download) to make it popular, then offer a full-featured version with stats, handicapping, tournament tree, handicapping,etc. include NCAA, European Soccer and etc. and charge a fee for that version.

Just a thought. I'm broke and trying to brainstorm here.

Eldmannen wrote on the 3 Apr 08 at 10:48
You could learn PHP and write it yourself with a MySQL backend.
With a website front-end written in PHP.
It is fairly easy...

http://www.php.net/

Eldmannen wrote on the 3 Apr 08 at 10:49
Perhaps you could make some sheets that would be useful for you in OpenOffice.org Calc.

Monkey Talks wrote on the 3 Apr 08 at 21:32
Thanks for the suggestions.
I used to do a minimal amount of programming in the early 80s. Maybe it's time I try learning something about it again.

I haven't heard anything about PHP so I'll look into that and SQL.

I was thinking maybe a spreadsheet might handle this OK too, so I'll check the Open Office stuff and see if I can make any headway.

gaspard.leon wrote on the 7 Apr 08 at 00:25
Use the spreadsheet (open office) for basic grid functionality...

For web-based integration, you'll want to develop some type of web app in PHP + (MySQL or FireBird or PostgreSQL)


Post your comment