adding in water weight to BOM, or exporting to excel

Hi

I work for an ROV tooling company and I am trying to work how to add a column to a BOM or spreadsheet to show the in water weight for a part/assembly. Is there a simple macro/equation for doing this?

thanks in advance

J

SolidworksBill Of Materials