This Excel spreadsheet calculates solid fuel appliance efficiency and heat output in accordance with the procedure specified in CSA B415.1-09. In general the column headings correspond to the variables used in the Standard. All data from a test run are entered on the "Data" sheet. The cells requiring data entry are highlighted. Please note that input data can be entered in either yard/pound or SI units. Select the units in cells F4 and F5 of the "Data" sheet. Particulate emissions determined using the dilution tunnel method should be entered in cell C13 of the "Data" sheet as total grams of emissions. Since oxygen concentrations are calculated for the efficiency determination, entry of measured oxygen data is optional. However, it might be useful to include the measured oxygen values for comparison to the calculated values for diagnostic purposes. A deviation of more than 1 or 2 percentage points can indicate inaccurate CO, CO 2 , or fuel composition input data. Selection of an appliance type in cell F2 of the "Data" sheet is needed for the air/fuel ratio calculation in accordance with Clause 16.3.5 of the Standard. The "CSA B415.1 Calculations" and "Report" sheets include calculation of efficiencies based on the Lower Heating Value (LHV) of the fuel, which is not required in CSA B415.1-09. The LHV is calculated from the Higher Heating Value (HHV) and fuel composition data in accordance with ASTM E711. The "CSA B415.1 Calculations" sheet is locked and password protected to prevent inadvertent modifications. The "Chart" sheet includes a chart of flue gas composition data and fuel consumption. The range of cells in the "CSA B415.1 Calculations" sheet to be charted or plotted might need to be
adjusted to correspond to the number of data points entered. Please report any errors or problems to Tony Joseph at CSA. Tony Joseph A.L.P. (Tony) Joseph
Project Manager, Energy & Utilities Canadian Standards Association 5060 Spectrum Way, Suite 100 Mississauga, ON L4W 5N6 Tel: 416-747-4035 Direct Fax: 416-401-6807 E-mail: tony.joseph@csa.ca
Spreadsheet created by: Rick Curkeet, PE, Intertek Testing Services, NA Inc. Version 2.2 14 December 2009
Made with FlippingBook - professional solution for displaying marketing and sales documents online