You could certainly do it in SQLServer, but you'd need to get a separate front-end for it. I suspect that you'd be much better off using Excel to do this. You can script Excel to do no. 4.
When you've developed the system in Excel for a while, then you can get stuck into writing something slicker in SQL Server, but you would then have to develop a nice front-end for it in the website. That will take quite a bit of work. You could, of course, generate the Excel spreadsheet directly from SQL Server, but you'd have your own inputting of data to consider. For the sort of volumes of data you are thinking of, it isn't a big deal, you could use Access as a front-end, but it is something you need to consider.