Skip to content

Utilize Google Sheet as input to interact with python flask for efficient input platform for team managers.

Notifications You must be signed in to change notification settings

yundk7/Bowling_Team_Heroku

Repository files navigation

Bowling Team Management

http://dq-27.herokuapp.com/bowling_team |

In an attempt to create a platform to utilize python to efficiently managage a sport team,

I found out that it is difficult to come up with a input system easy enough to attract new users.

As plan B, utilizing google sheet online available for users with ID and password made things straight forward and still manipulatable by python.

Utilizes google sheet as input and data management to efficiently manage scores and random team generation for small competitions within the club.

To take a look around:

  1. Visit first two pages "members" and "scores" to see what the platform utilizes as front end user's input. members.png scores.png

  2. Visit "recent" page and input 15 and submit, and page will result in table sorted by average score of members and highlited according to scores and gender. recent.png

  3. "random" page will return table below when input following:

    Number of games: 30

    Number of teams 4

    Players: 김상훈,김승용,김연정,김영석,김유진,김윤성,김재훈,김정은,김주희,김지훈,김태훈,김한샘,김현숙,김효진,노은주,박민정,박연수,박지혜

    Allowable Difference: 50

    Which will return:

team 1 2 3 4
1 김상훈/158.75 김지훈/145.4 김승용/178.36666666666667 김효진/174.13333333333333
2 박지혜/137.5 김주희/142.75 김윤성/163.83333333333334 김영석/166.2
3 김재훈/126.66666666666667 박민정/120.66666666666667 박연수/157.6 김태훈/150.9
4 노은주/125.03333333333333 김정은/112.43333333333334 김현숙/139.83333333333334 김연정/132.76666666666668
5 김한샘/115.42857142857143 김유진/99.66666666666667
total 663.379 620.917 639.633 624

Result is random team up of 18 people entered into 4 teams with respect to team total of recent 30 game average. Notice the total values do not differ by more than 50 which was entered allowable difference value

About

Utilize Google Sheet as input to interact with python flask for efficient input platform for team managers.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages