# How to Calculate Electrical Bills Using Excel 2007

### Using your computer you can calculate your electrical bills using the power of the Microsoft Office Excel 2007. Installed in your computer system unit(CPU). In this application to calculate this electrical bills, you need first to create a worksheet’s table then input your worksheet data to be calculated.

This application of the Microsoft excel 2007, this is better if in your area, your are using a solar panels that you officially own or you’re the property owner. And there are plenty of your customers connected to your electricity using the solar system as your source of electrical power. You can calculate its of power consumption and how much they will pay every month.

To begin with this application, open up your Microsoft Excel 2007 or higher versions and follow the instruction below to create this electrical bills:

Create your worksheets table with worksheet’s title above and input this following worksheet’s label: House No., House Owner, Previous Unit, Current Units, Unit Consumes, Electrical Charges, Surcharge, Bill Payable, Status.

CALCULATE THE FOLLOWING DATA
• Unit consumes- it is the current units minus the previous unit.
use this formula: =D5-C5
• It is calculated base of the unit consumes equals the electrical charges.
LECTRICAL CHARGES:

Unit consume is less than or equal to 100 rate per unit is equal to 11
unit comsume between 101 to 200, rate per unit is equal to 13
unit consume above 200, rate per unit is equal to 17

=ROUNDUP(IF(E5>200,E5*17,IF(E5>100,1000+(E5-100)*13,E5*11)),4)
• SURCHARGE CALCULATION-it is the electrical charges multiply to the percentage of the electrical additional charges.
=ROUNDUP(IF(F5>5000,F5*0.15,IF(F5>1000,F6*0.07,0)),1)

HOW TO APPLY COLOR CODE AS STATUS
you need to create status like what I use in my worksheets
Status Percentile Using Conditional Format

green- haft pay
50%
red- not pay
10%
blue- paid
100%

Follow this instruction using the conditional format:
1. Highlight the bill payable
2. Then click home and then conditional formatting
3. Then click the new rule under the drop menu list
4. Under the window select “Format all cells base on their values”
5. Then under the format style, click drop bar then select 3 color scale
6. Then under the minimum click/select percent, then input the percentage given above.
7. Repeat the procedure 6 for the midpoint and maximum
8. Then click ok

Review your worksheets if the calculation is all correct and the status if the color is applied to the exact payment if it is paid, haft paid, and full paid. See the post picture above. If you have any questions regarding this application kindly leave it in the comment bar. See you next post.

#### Arnel Cartoneros

I'm a husband, a blogger and Biomedical Machines Specialist, also a computer instructor and technician and a crazy writer, I like to write and build blogs and avid fan of social media. I have built this blog just to help others through information. Follow us on Facebook and Twitter.

Blogger Comment

Your post on excel advanced training is really useful. I agree with your thoughts, knowledge on excel is mandatory for everyone. Excel Training in Chennai | Advanced Excel Training in Chennai

2. The Post seems to be good i really gather lot of information from the post thanks for sharing this awesome post...http://www.staffcontrol.com/

3. This is especially imperative in case you're an apprentice, since you can not be prepared to get on alternate signs which show that the stocks are in threat of tipping over their pinnacle. As opposed to hazard losing money on a terrible venture, stocks and prospects exchanging programming may help you to assess this even at the early phases of your profession in the share trading system. this page

4. The strategy you have posted on this technology helped me to get into the next level and had lot of information in it. The python programming language is very popular and most widely used.
Python Training in Chennai | Python Course in Chennai

5. Updating with the latest technology and implementing it is the only way to survive in our niche. Thanks for making me this article.
Node JS training in chennai | Node JS training institute in chennai

6. Thank you for this valuable information. I have got some important suggestions from it.
best erp software in chennai | leading erp solutions in chennai

7. There was very wonderful information and that's great one. I really appreciate the kind words, thanks for sharing that valuable information.
Web designing course in chennai

8. Very interesting and Helpful Tips…..Thanks For Sharing.
Bulk SMS Chennai

9. Very good article. I like this article too much and really impressed with this article. I was looking the same post here. I am very impressed with this post. Thanks for this nicely sharing. Electrical Repair