New Penultimate 2005 SNG Spreadsheet

[AleoMagus]

You might be amazed how little I actually know about excel. Actually, excel experts might look at this sheet and not be amazed [img]/images/graemlins/smirk.gif[/img].

Still, Thanks.

Brad S

[eastbay]

[ QUOTE ]
I sent this off to eastbay

[/ QUOTE ]

Hmm. No email. Maybe it's taking awhile due to size...

eastbay

[eastbay]

Cool new UI features:

http://rwa.homelinux.net/poker/SUPERSNGwUI.zip

Faster server copies appreciated...

eastbay

[spentrent]

Marcotte -- if you agree it's useful -- how complex would it be to:

- Have a start button for each tournament

- Have a dropdown menu for the buy-in for each

- Have a "placed?" text input and an end button for each started tourney

So we'd have:

Tourn 1...$10+1...STARTED 10:30...PLACED [____]...[END]
Tourn 2...[$10+1]...[START]
Tourn 3...[$10+1]...[START]

(the square brackets represent buttons/menus/input)

(also note that I don't suggest a dropdown for "placed?" since it's probably more convenient for a user to simply type a number)

I am of course VERY GRATEFUL for yours and Aleo's work; just thought I'd add my two cents as a fellow designer/coder, sadly, without VBA experience. I find the pop-up dialogs a bit clunky, considering that poker windows will be popping up all over the place as we enter information.

If you think it's a good idea and decide to add it, I shall offer my Perl/PHP services to a project of your choosing. [img]/images/graemlins/cool.gif[/img]

[Etaipo]

[ QUOTE ]
Cool new UI features:

http://rwa.homelinux.net/poker/SUPERSNGwUI.zip

Faster server copies appreciated...

eastbay

[/ QUOTE ]

High speed (300kb/s + download speeds) mirror.

Download here

[MelchyBeau]

Star Office compatibility and this spreadsheet.

I really like the spreadsheets that you have posted, thank you thank you thank you. However, there are a few compatibility issues with it and star office, namely the graphics. I am going to take some time out later on and fix this for myself, just so I can use it on my main machine. The issue is the actual graphs. Would I have your permission to post it if I made it work for star office as well?

Melch

[vindikation]

I have a lot of space so if you guys want me to host files permanently (well at least the next 3 years of my domain registration) I'd be more than happy to do it, just let me know.

http://vindikation.com/poker/SUPERSNGwUI.zip

[SuitedSixes]

Brad-
This really is too neat to just be given away. For those of us who would like to thank you ($) for your hard work, do you have a PayPal account, or something like that? What is your Party name so we can transfer some thanks your way?

[zephyr]

I use excel on a daily basis, although I'm definitely no expert. Nevertheless, I think your spreadsheet is an example of expert usuage of the program. Sure your calculations aren't the most graceful, but with computers that can do 2 billion + calculations per second, why would you waste your time streamlining. Then again, I'm from Saskatchewan and we tend to be a touch on the pragmatic side.

Again thank you.

Zephyr

[Marcotte]

Spent,
Good suggestions. It would definately be more user friendly to have everything encapsulated in one window. The pop-up diaglog boxes (where you enter tourny # and place finished) are the built-in Excel InputBox() function, which is a lot easier to code than the UserForms. I wanted to get something out there quick that worked so that you and others could both use it and tell me how to make it better.

It shouldn't be too hard to make the changes you suggest. Eastbay's got me thinking about loading tourny histories too, so I'll have to budget my time.