How can i write a stored procedure which will perform a calculation and store the result in a table?
You'll need to put a trigger on the siteArea table so that whenever it's updated or inserted, it'll call a stored procedure with an argument representing the new site area and that procedure will calculate the needed values and insert them in a table.

Your question is too ambiguous for me to describe further.