I am trying to develop a website for a babe ruth baseball team. I want to include a page that displays team and player statistics. I have created Excel files for data from each game. I have also created an Excel file that collects data from each game and adds together (for season totals) and averages. I would like to be able to export this data to Access and have it displayed on webpage using ASP. I want to be able to just input data from a game to its sheet and have all the totals and averages updated automatically, so that i don't have to update the game data AND change the webpage. If i am sounding too confusing, I can probably explain it better. Basically, every time we have a game and I input the data from that game, I would like the webpage to display the updated totals and averages, as well as that game's data. Can anyone help, or point me in the direction?

9 Years
Discussion Span
Last Post by MidiMagic

Excel has a "Save as web page" option in the File menu. Do all of your calculations with ranges, so you can insert a column and they still work. Be sure to use the correct cell addressing modes, so inserting a row doesn't change your references. Then, just replace the old page with the new one when another game is played.

I used this function to produced updated statistics for time sheets on a job. If it worked for that, it works for sports stats.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.