My latest creation is a simple bill of materials generation tool ... and you can download the BoM template here (.XLSM file) and the corresponding stock file there (.XLSM file).