Charge weight is an important consideration when calculating for the blasting crater. The main parameters affecting the blasting crater are the rock type, minimum amount of chemicals consumed, and resistance lines. Although only a few parameters influence the blasting crater, calculating and speadsheeting require a large amount of work and furnish results that are not intuitive. Moreover, the calculation of blasting crater parameters takes time. The current study calculated the parameters using Visual Basic to illustrate a fast spreadsheeting and mapping method using Computer-Aided Design, the design for the charge until the supporting role.