-
Using an excel sheet prepare an electricity bill fo
customers. Use the following fields.
Dienstes gew
Cust.No
A1001 Raj Kumar Sharma
A1002
A1003
A1004
Name
Hari Shankar
Anita K.C.
Sarita Thapa
Condition:
ament III
Current Previou Consu
Meter
Meter
med
Reading Reading Unit
1250
1320
76-8
1380
chefale erkannt und behoben und die Qualität
1305
599
120
15
169
Bill
Amoun
t
Unit consume-Current unit-previous unit
Calculate Amount as if unit consume following criteria meets:-
810
Bo
1167.7
1816.5
. If unit consumes is less than or equal 20 unit, amount - Rs. 8
if unit consumes is greater than 20 and below than 250 units, the amount is Rs. 7.
13
