if I have an assembly contains sheet metal parts (each one is single body), when insreting BOM table, to get "Bounding Box Area" I have to select "indented" option,

if I need to calculate total area for each thickness, I have to work on excel to move "indented" for ex. 1.1 to the main raw 1 and so on, and this is time consuming, is there is any way or excel macro to solve this issue?

after: