Hi Everyone,
I currently store golf statistics on a week by week basis on a golfer by golfer basis in Excel. I store things such as Player Name, what the tournament was, course name, then lots of info about the course and then finally the statistics of the golfer for that week.
I'm adding about 250 rows per week and now the spreadsheet is running extremely slowly, because I also have formulas which calculate average stats for each golfer for the last 8 weeks, last 16 weeks etc...
My first question is, is Access better than Excel to store this data, if so I can import the spreadsheet into Access but I'm left with a lot of duplicate values, for instance, golfer name, week number, tournament name, course name etc.... Is there a way round this?
I currently store golf statistics on a week by week basis on a golfer by golfer basis in Excel. I store things such as Player Name, what the tournament was, course name, then lots of info about the course and then finally the statistics of the golfer for that week.
I'm adding about 250 rows per week and now the spreadsheet is running extremely slowly, because I also have formulas which calculate average stats for each golfer for the last 8 weeks, last 16 weeks etc...
My first question is, is Access better than Excel to store this data, if so I can import the spreadsheet into Access but I'm left with a lot of duplicate values, for instance, golfer name, week number, tournament name, course name etc.... Is there a way round this?