updated spares analysis