Custom Excel BOM

HI,

I am for the 1st time trying to set up an Excel based BOM as opposed to the standard SolidWorks BOM.

I have fount the Excel BOM templates and thought I could just edit one to suit.

While some properties now appear on the BOM some are taking the wrong information.

Attached are some screen shots.

I have an assembly with multiple part all with custom properties.

I want the BOM to take the information from these custom properties,

I cannot figure out how to link the Evaluated Value to the BOM, these would be in this screen shot, Length (500) and Section Size. (Plt 30*165)

This is what appears on the BOM, which are Value / text expression for length and nothing for the Section Size.

I guess it could be how I have set the Excel file up but not sure what I have done wrong.

Also attached is the edited excel file.

Could some one please explain what I need to do.

Thanks

Mark (SolidWorks 2015 sp2.1)

SolidworksDrawings And Detailing