
This method can be applied for LEED NC Energy & Atmosphere Credit 2. This credit requires a calculation for the energy generated by a renewable source.
For example, a typical wind turbine model can be selected and the proper values put in according to the manufacturer’s specifications. To make the example more flexible, data was added for seven types of turbine models from one manufacturer (ROPATEC 2011): Easy Vertical (1), Simply Vertical (2), Simply Vertical HE (3), Maxi Vertical (4), Maxi Vertical HE (5), Big Star Vertical HE (6), and Giga Star (7). Then an if/then statement was set up to determine the “Surface” for each model.
if(Turbine Model = 1, 2.07, if(Turbine Model = 2, 6.6, if(Turbine Model = 3, 9.9, if(Turbine Model = 4, 11.5, if(Turbine Model = 5, 16.1, if(Turbine Model = 6, 34.4, if(Turbine Model = 7, 46.4, 0)))))))
This statement will help Revit automatically generate the value of “Surface” according to the different turbine models. Using the same method, the parameter of “Wind Power,” which varies for different wind speeds, uses a similar conditional statement as shown below:
if(Wind Speed = 4, 697, if(Wind Speed = 5, 1508, if(Wind Speed = 6, 2774, if(Wind Speed = 7, 4672, if(Wind Speed = 8, 7173, if(Wind Speed = 9, 10213, if(Wind Speed = 10, 14010, if(Wind Speed = 11, 18648, if(Wind Speed = 12, 24438, if(Wind Speed > 12, 24438, 0))))))))))
The formulas can get more complex. The statement below is part of the calculation formula; it will let Revit automatically select values according to different situations.
(if ( and (Wind Speed = 4 , Turbine Model = 7), 713.44 , if ( and (Wind Speed = 4 , Turbine Model = 6), 241 , if ( and (Wind Speed = 4 , Turbine Model = 5), 157 , if ( and (Wind Speed = 4 , Turbine Model = 4), 112 , if ( and (Wind Speed = 4 , Turbine Model = 3), 96 , if ( and (Wind Speed = 4 , Turbine Model = 2), 64 , if ( and (Wind Speed = 4 , Turbine Model = 1), 17 , if ( and (Wind Speed = 5 , Turbine Model = 7), 1542.734 , if ( and (Wind Speed = 5 , Turbine Model = 6), 500 , if ( and (Wind Speed = 5 , Turbine Model = 5), 314 , if ( and (Wind Speed = 5 , Turbine Model = 4), 224 , if ( and (Wind Speed = 5 , Turbine Model = 3), 191 , if ( and (Wind Speed = 5 , Turbine Model = 2), 127 , if ( and (Wind Speed = 5 , Turbine Model = 1), 33 , 0))))))))))))))/Surface)/ (Wind Speed ^3*1.225*0.5)

Other parameters and calculations are shown in figure above. The final schedule of this credit is shown in figure below.
Similar methods can be apply to other products. As shown in the figures below.
