Hi all,
In case you need to determine the estimated weight of reinforcement of RC beams and Rc Columns from your model and you calculated their required reinforcement you can easily do this by pressing a button in the macro created by @marcinrakus (thank you Marcin).
This is how it works:
Hi @Refaat
But I would like to ask you if possible to develop this macro to be more practical. On the other hand to provide us the quantity of each reinforcement diameter separately
Unfortunately there is no access to bar diameters used for given beam or column via COM so this cannot be done until this information is available in RSA API 
and the final results present in the tabular format.
I'm sure somebody with Excel skills will be able to edit the macro and give it a better look 
hi @2022pcs5311
Sometimes, column indexes are provided on the forum; other times, you may need to search for them yourself or create a bot.
It's best to ask here if you can't find them.
Best Regards
| 737 | Reinforcement type |
| 921 | Minimum reinforcement ratio (%) |
| 922 | Required reinforcement ratio (%) |
| 923 | Maximum reinforcement ratio (%) |
| 1142 | Provided reinforcement ratio (%) |
| 1143 | Max. reinforcement area (cm2) |
| 1144 | Min. reinforcement area (cm2) |
| 1156 | Reinforcement parameters |
| 1169 | Max. code-defined reinforcement ratio (%) |
| 1170 | Min. code-defined reinforcement ratio (%) |
| 1171 | Average reinforcement ratio (%) |
| 1173 | Top required reinforcement (My) (cm2) |
| 1174 | Bottom required reinforcement (My) (cm2) |
| 1175 | Top provided reinforcement (My) (cm2) |
| 1176 | Bottom provided reinforcement (My) (cm2) |
| 1177 | Required reinforcement along b (cm2) |
| 1178 | Required reinforcement along h (cm2) |
| 1179 | Provided reinforcement along b (cm2) |
| 1180 | Provided reinforcement along h (cm2) |
| 1181 | Top reinforcement - distribution (My) |
| 1182 | Bottom reinforcement - distribution (My) |
| 1183 | Reinforcement along b - distribution |
| 1184 | Reinforcement along h - distribution |
| 1185 | Transversal reinforcement - type/distribution |
| 1202 | Top required reinforcement (Mz) (cm2) |
| 1203 | Bottom required reinforcement (Mz) (cm2) |
| 1204 | Top provided reinforcement (Mz) (cm2) |
| 1205 | Bottom provided reinforcement (Mz) (cm2) |
| 1206 | Top reinforcement - distribution (Mz) |
| 1207 | Bottom reinforcement - distribution (Mz) |
| 1947 | Transverse reinforcement density (cm2/m) |
| 6733 | Transversal reinforcement - type/distribution NN |
| 8106 | Reinforcement type NN |
| 9201 | Reinforcement Areas NN |
Stéphane Kapetanovic
The provided code is for bars, specifically beams and columns. it's a topic worth considering for future development.
Stéphane Kapetanovic
