This project developed an energy cost calculation program on Google Sheet by using Google app script. There are two condition. First, the program will calculates six types. It is composed of a residential, small business, medium business, large business, particular business, nonprofit organization. Second, there are calculates two rate. It is time of use rate (TOD) and time of day rate (TOU). Which can be used to help Calculation in real situation.