i-nth logo


Vertika Rawat


Like any other technology, bioenergy has a spectrum of advantages and disadvantages associated with it. Biofuels, for instance, are expected to reduce the dependence on foreign oil considerably, but the energy balance and carbon emission savings achieved by biofuels is still under question.

However, amidst all this debate, global bioenergy development continues to take place and is being studied and investigated by scientists, engineers and government agencies worldwide. Simulation, modeling and analysis of bioenergy systems is an inherent and critical part of this process.

The first part of this thesis deals with the detection and subcategorization of hard-coding errors (a prominent type of spreadsheet error) in bioenergy-relevant spreadsheets.

The second part of this thesis deals with the life cycle analysis of six kinds of cropping systems for bioenergy production, including conventional and alternate; and their assessment from various standpoints of energy, net productivity, and adverse environmental impacts.


Distribution of formula hard-coding errors
Distribution of formula hard-coding errors

This chart shows the frequencies of each subcategory of hard-coding error for the sample spreadsheets.


2011, Master's thesis, Iowa State University, January

Full article

Analyses of bioenergy systems: Detecting hard-coding errors in spreadsheets, and comparing biofuel cropping systems

Also see

Detecting and categorizing hard-coding errors in Excel spreadsheets using Visual Basic for Applications (VBA)