Im going to start by explaining the main points of whole project im working on.
The purpose of the APP is record keeping for a gaming community i belong to that is based on hockey.
Previously record keeping was done all by pictures and manually entering data one at a time by hand. I have created a command line script that uses curl to scrap this data and is returned in the form of a json of the past 5 games played by a team. Through other various tools the json is transformed to a CSV file and uploaded to google drive, followed by importing to a google sheet.
In this google sheets workbook, theres the imported game data, and theres a sheet to select the appropriate game that is ment for the league scheduled games(not every game of those five are league games, so selection is needed). After selecting it is saved and goes through other various manipulations for various types of data.
Currently im having to do this every night for every team. Im trying to have a way that every teams coach can enter this themselves simultaneously.
- I dont want to be doing that every night, especially as the league grows so will rhe number of teams.
- Currently I am making informed educated guess as to what games need to be selected based on times played vs times scheduled. Deviations from this lead to errors, errors that might not be noticed until furth down the road.
- Having the coaches do it will result in less possible errors since they will have on hand information to anything that might effect which games to select.
The reason I need it to be able to run simultaneously.
- having teams wait in line to enter stats just isn't ideal.
- Most likely result in two teams trying to run it at the same time and cause issues.
- alternative is creating a data input workbook for every team individually, then combining them later.
- be tedious to set up and most likely results in the workbook functionality issues
Link to the current system i am using in google sheets.
- GetStats is where team and game selection is done.
- Import is the raw data from google drive.
- master is where all the calculations, sorting, filtering, and other various things.
- summery is where the final result is saved.
Current game selection/input system
also heres a link to the app itself
AppSheet App
LinkedIn
Twitter
