Civil Insight: A Technical Magazine Volume 2 | Page 81

CIVIL INSIGHT 2018
Events
81
Workshop: Advanced Excel and VBA Programming in Civil Engineering
Civil Engineering — be it Surveying, Hydrology, Hydropower Engineering, Structural Engineering or Estimating
and Valuation — involves a huge numerical calculation. As such, data obtained in the fi eld or design data need
to edited, sorted, analyzed, summarized,
formatted, and sometimes even graphed.
While manual calculation could have hit
a snag, MS Excel, fortunately, solves such
problems through its easy interface and
automated computations.
Considering the same, on May 5, 2018 and
May 19, 2018, KUCEC conducted a two-
day workshop on “Advanced Excel and
VBA Programming in Civil Engineering” in
Civil Block, DCGE.
A total of 40 students from Civil 1st, 2nd
and 3rd year participated in the workshop.
Er. Devendra Man Palikhe and Er. Kshitiz Shrestha (both
ME Structural Engineering, Batch 2016) presented in
the workshop with their engaging slides. The workshop
covered the basics of MS Excel to its advanced tools and
commands followed by a VBA programming in Excel
on the second day. It was deemed very fruitful by the
participating undergraduates.
The Advanced Excel-VBA tutorials of the workshop can
be accessed via YouTube at https://www.youtube.com/
watch?v=w_dJRlsXMfI and https://www.youtube.com/
watch?v=grfVa9vd_tYon on the channel ‘Devendra Man
Palikhe’.
Advanced Building Drawing Classes for Batch of 2015
Building Drawing, in fact, is a semester course which civil engineering students learn at undergraduate level.
However, the particular course is not formally taught at DCGE. In order to fulfi ll the course requirements, to
some extent, KUCEC organized a 15-hour building drawing lesson for the batch of 2015 in Civil Block.
Ar. Buddha Shrestha, a faculty member and the Program Coordinator for Bachelor in Architecture program,
instructed the classes. Conducted in off-academic hours, 4:00 pm to 5:30 pm, classes were run from
September 30 to October 9, 2018. Field visits to nearby under-construction buildings further enhanced the
knowledge, skills and ideas grasped from the theory classes.
The program focused on general layouts and elevation of buildings, fl oor plans, municipal drawings and
structural drawings. Moreover, implementation of CAD skills in building drawings also remained a major
highlight of the program.