In the Hypersizer_Spreadsheet_Utilities_6.2.xls, when using the <Report> worksheet, the values extracted when using the weight or unit weight keywords are incorrect.
I believe the weight error is due to the mass factor being divided, rather than multiplied to the component weight...
In PerformActionComponentGroupData under Case KeywordId.Weight, the following line is present:
udtAction.Output = oComponent.Weight / Units.MassFactor
In our workbook, I've changed this to the product and it produces the correct result.
The unit weight is also wrong, but I'm not sure how to correct this problem.
Thanks,
Ruben