bastislack / highline-freestyle

Webapp for Highline Freestyle
GNU General Public License v3.0
10 stars 9 forks source link

Add predefined Combos to Spreadsheet #253

Closed WaldemarLehner closed 1 year ago

WaldemarLehner commented 1 year ago

The predefined tricks are currently defined at https://docs.google.com/spreadsheets/d/1amLK2b6BQkJ10I3LcbUe-D-wgQpHkcgoIrL10TPkHPo/edit#gid=429137275. This allows use to get the data at compile time from the sheet in TSV Format via https://docs.google.com/spreadsheets/d/${sheetId}/export?format=tsv&id=${sheetId}&gid=${sheetGid}, so https://docs.google.com/spreadsheets/d/1amLK2b6BQkJ10I3LcbUe-D-wgQpHkcgoIrL10TPkHPo/export?format=tsv&id=1amLK2b6BQkJ10I3LcbUe-D-wgQpHkcgoIrL10TPkHPo&gid=429137275.

I propose adding a new Table to that sheet which defines the predefined combos so we can also get predefined combo data at compile time.

bastislack commented 1 year ago

Alright! I will take care of this!

bastislack commented 1 year ago

Btw, last time I calculated all the stats manually I think :D Maybe for future combos we can automate this ^^

bastislack commented 1 year ago

I added a sheet 'combo_list' with the combos that are currently also predefined in the code ('predefinedTricksCombos.js'). Note: I deleted the stickFrequency column as I assumed that it is not needed in the new database design.

WaldemarLehner commented 1 year ago

Btw, last time I calculated all the stats manually I think :D Maybe for future combos we can automate this ^^

Yeah. I would say that minDiff | maxDiff | avgDiff | totalDiff | numberOfTricks
can be removed from the sheet as they can be directly inferred from the other values. They would then be computed by the Database during insertion.