Revit has a good capability for adding formulas to values in schedules. However, this is relatively simple when you need to do calculations within a certain type of schedule, such as a window schedule. It's not simple when you need to mix data from different types of entities, such as Windows and Floors, and other things. One possible solution is to extract data to Excel from separate schedules, and continue the calculations in the spreadsheet.
Or, you might be interested in looking at Autodesk Ecotect Analysis, at this link:
http://usa.autodesk.com/adsk/servlet/pc/index?siteID=123112&id=12602821
Alfredo Medina
info@planta1.com
http://www.planta1.com
Online Revit Training
Alfredo Medina _________________________________________________________________ ______
Licensed Architect (Florida) | Freelance Instructor | Profile on Linkedin