Reinforcement Schedule in a building

[deependra]

Hiii dear readers,


I am trying to prepare a bar bending schedule which basically calculates length weights of various shapes of bent reinforced bars .

I will input dia of bar, no of elements , bars and cutting length which I will calculate from the drawing.

Now the slightly tricky part..


Now when I enter the code I should be able to automatically get the shape of corresponding code and entering A,B,C as 100,500 , 100 etc. should help me to write the same in the placeholders adjacent to the shape as shown.

I will then calculate the total length based on the entries made.


Now I move to other row and similiarly second shape, second length and so on and so fourth.


Any ideas please??



Regards,

DV