I want to create a spreadsheet with drop down (preset) options, I want to be able to store this data raw on another sheet and use it to create stats based on the win to loss ratio of a week and a day over the year.
I wanted a 'front' page with an overview of each month win v loss percentage and then breaking down in to days of the month to show if there's a pattern for certain days being more likely to win or lose.
Does that make sense?
How do go about doing this?
Example below:
I wanted a 'front' page with an overview of each month win v loss percentage and then breaking down in to days of the month to show if there's a pattern for certain days being more likely to win or lose.
Does that make sense?
How do go about doing this?
Example below:
