8/20/2019 Excel VBA used for Management of orders.

1/8

 

Management of orders -Anchor BoltManagement of orders -Anchor Bolt

03/05/16Civil/Structural

•1

8/20/2019 Excel VBA used for Management of orders.

2/8

8/20/2019 Excel VBA used for Management of orders.

3/8

 

03/05/16Civil/Structural

•3

Issue Order 

&ac(age 1 -Contractor 

&ac(age - Contractor 

&ac(age 3 - Contractor 

)'*+ ,!'))'*+ ,!')

8/20/2019 Excel VBA used for Management of orders.

4/8

 

M%' "$&% ,*'M *#."'$SM%' "$&% ,*'M *#."'$S

03/05/16Civil/Structural

•

8/20/2019 Excel VBA used for Management of orders.

5/8

 

&roect 2ualit "nduction

,#A%*#S,#A%*#S 

Inputs:

• Input row wise as per drawings

•Input bolt type bolt diameter and bolt pro!ections"

•Input the #ackage type and also $ot to be consider% For Info&

Outputs :

•Trace error’s in Input"%'efer (rror’s )heet&

•)ummary for )td" *nchor +olt with )td" $engths"

•)ummary for )td" *nchor +olt with ,on-)td" $engths"

03/05/16Civil/Structural

•5

8/20/2019 Excel VBA used for Management of orders.

6/8

 

&roect 2ualit "nduction

MA$A.#M#$% ', M%'S A$4 '*4#*SMA$A.#M#$% ', M%'S A$4 '*4#*S

03/05/16Civil/Structural

•6

8/20/2019 Excel VBA used for Management of orders.

7/8

8/20/2019 Excel VBA used for Management of orders.

8/8

  •

 THANK YOUTHANK YOU

•03/05/16Civil/Structural