How to enter Fuel bills when there are multiple fuel types

EDIT: OptiMiser now offers direct support for multiple fuel types.  On the Utilities tab, select “Multiple Fuels” in the Fuel Type control and then open the Multiple Fuel Entry popup. You can choose Start and End dates (preferably spanning at least one year) and then enter total usage for each fuel.  The instructions below are still useful, if you feel that you can accurately describe multiple periods of combined usage.

OptiMiser’s utility analysis currently handles only one Fuel type.   For multiple heating fuels, you can work around this limitation by converting usage for a second fuel to the same energy units as the primary fuel and combining the usages.  The tricky thing about doing this is that the delivery schedules will probably be different.  You will probably have to combine multiple bills to achieve a period with known total usage.  You may even need to combine all of them into one period covering the entire heating season.  It would be helpful to read the section on “delivered” fuels in the Utilities help for a better understanding of unusual periods.  Here are the Btu equivalents for a selection of heating fuels for use in conversions:

Natural Gas (MCF) – 1,025,000
Natural Gas (Therm) – 100,000
Natural Gas (MBtu) – 1,000,000
Electricity (kWh) – 3,412
Propane (CF) – 2,539
Propane (Gallon) – 91,330
Fuel Oil (Gallon) – 140,000
Wood (Cord) – 20,000,000
Wood (Pound) – 8,000
Pellets (Ton) – 16,500,000
Pellets (Pound) – 8,250
Kerosene (Gallon) – 135,000
Coal (Ton) – 28,000,000}