MONITORI APPLICATION DESIGN BY USING VBA AS A TOOL TO DETERMINE WASTE BANK ADAPTABILITY

Abstract: Waste  banks  are  really  important  for  Indonesian  Government  as  they  help  the  country  to  deal  with household waste issues. And to make sure that the waste banks will continue to exist, the government has done  some  monitoring  regarding  its  adaptability.  Even  so,  the  monitoring  they  had  done  wasn’t comprehensive enough, as it is difficult to do so. The difficulty remains on the rather complex calculation needed,  which  can  be  really  tedious  at  times,  so  it  deemed  as  time  consuming  and  not  worth  the  time. Monitori  is  designed  to  overcome  this  problem,  to  help  the  user  determine  the  adaptability  value  of  a waste  bank.  Using  Microsoft  Excel  and  its  Visual  Basic  for  Application  function  to  design  it,  the application is able to do all the calculation automatically, and by doing so eliminate the calculation error possibility.  The  application  also  has  some  preventive  measure  to  prevent  error  in  the  data  inputting process. Monitori also designed to be flexible, so it can be used on any waste bank.
Keywords:  waste banks; adaptability value; microsoft excel; visual basic for application
Author: Cosmas Andi Wiraatmaja, Helena J Kristina, Ishak
Journal Code: jptindustrigg160003

Artikel Terkait :