yogi_Compute Game Stats In Terms Of Win Loss and Tie

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #543    May 17, 2012     www.energyefficientbuild.com.

user teacher coach said:
Using Form to create league stats
Hi Yogi,

I've read many of your replies to other people's questions and I'm starting get some understanding but it's still over my head at this time.

here's a link to a copy of the form/spreadsheet that I have created so far

bball example

I initially created it with only win or loss options and it wasn't too hard to figure out.  Now I'm trying to retrofit it to allow for possible tie game situations.  That's where I'm stuck.  I also need the form to be very simple and easy so that coaches will be able to enter the game scores quickly and simply, otherwise they won't bother and this will all be a waste of time.

Also, i'm using Junior Girls Basketball as an example to work with here but if I figure that out I'll replicate the form and spreadsheet for all of the other sports and age groups we have.

Thanks for your help.

-------------------------------------------------------------------------------------

following is a solution to the problem