Convert Excel Macro to SQL Server Stored Procedure

I have a excel macro that is about 563 lines total and need it converted to T-SQL to run as a SQL Server 2000 stored procedure. Currently the macro runs and dumps data to a file. The macro performs calculations. I would like for the stored procedure to write the data to a table in the database it is in, and write the output to a file that can be emailed to a distribution list. Feel free to ask questions.