Collaborate on Electricity Bill Format in Excel for Technology Industry with Ease Using airSlate SignNow

Electricity bill format in excel for Technology Industry

the students today I will teach you how to create an electricity bill calculator using excel sheet we should have some it's one of the function if another function and one more operate that I am going to you that is and operator it's a logical operator by the way please subscribe to my channel root for m JT B let's begin this is the model for you having many different field names like you should have the name of the customer customer number customer address bill number builded due date previous reading date meter number meter number in the sense your meter that is electricity meter where you can see the readings and then most important is current reading and the previous reading because these two are become the basis for further calculations followed by total number of energy consumption to slab rates I have and total amount of energy outstanding if you have need to pay extra money that you should pay here if it is a late fee that is penalty becomes gross amount and suppose if you have paid already some excess money in the previous time of your bill so that should be put up here and then finding the final total amount okay now where the calculation actually starting his here under total number of energy consumption we've got this formula sum sum of I hate that is this column I and this is row i 8 minus j 8 so the formula for finding energy total energy consumption is equal to current reading - previous reading then you will get the and usually current rating will be higher than the previous readings it's nothing but previously previous month reading - this month reading okay Oh every time electricity board have certain slab rates so for example here some of the countries have like this till 100 units no amount will be charged from what not one on what's some amount will be charged so slap one falls under this category where you have total energy consumption is 100 equal to 100 so it is waved off 0 suppose it's more than 100 you are energy consumption is more than 100 then it should be calculated for two point one three five okay that becomes your total energy amount since it is going to become zero every time so it is not required to include in the energy amount formula okay so I am just capturing only the sum of this particular value m8 so outstanding means you need to pay some money in the previous bill that is added to the current to be so that is comes here and if it is a late fee you have to pay the bill today but you are going to pay after one week so electricity board will be charging certain penalties that should be coming so the formula for gross amount is nothing but energy amount plus outstanding plus penalty pickups your awesome that's why it is a here sum sum of n 8n8 okay n 8 + o 8 plus penalty so it is not required to put plus just automatically you just WP and from here drag till here automatically it will take I think this you know where you go okay excess paid mainly already made some extra money some two rupees three rupees paid already so that should be deducted from this cross amount and then becomes your total net amount let me fill this excel sheet okay the next customer number some number numbers in anything will be billed it let's say three 2019 you can formulate this ing to you as your understanding K due date like 19 okay meter number okay this is important so current reading as I said current reading will always be higher than the previous reading so let's simplify to thousands and previous reading is like maybe 700 and look here automatically changing here it becomes 300 so thousand minus seven and it tastes okay so here it already calculated that's why it becomes zero as the formula says here is look if k-8 that is energy consumption K column and gate is row so this is the cell so this cell is greater than lesser than is equal to hundred that means then k8 x 0 why because this lab is like this till 100 unit no charges so that is the formula so that's why it becomes zero okay how this value is coming 426 how it is coming so here what I am doing is I have included an operator that is called an operator so hand operator when you use both the arguments one argument and second or the argument are this also called as a logic one and logic to both the lodgings are true then it should be calculated at the rate of 2 point 1 3 okay that is the formula ok let me do a normal calculation ok now you have 300 right 300 minus 100 is the slab rate hundred units waved off so 200 in the balance multiplied by 2 point 1 3 so you will get answer 1 4 6 this is the appropriate calculation suppose if you do the calculation the other way 300 multiplied by 2 point 1 3 then minus 100 it becomes wrong why because you are not calculating the total amount actually you are calculating the total units for the slab 1 that is why the formula is mentioned like this first this should become minus that is K 8 minus 100 that is 300 minus 100 becomes 200 then it becomes calculating this but at the same time if you wanted to perform this calculation then this argument becomes true is it true yes of course it is K is greater than K 8 is greater than hundred years it is greater than 100 look 300 now 300 is greater than so it is passing logical is correct so this logical if it is correct then this calculation should execute all right okay now energy consumption has been captured from here automatically so now automatically you are gross amount and your net amount will be available supposing if there is no penalty or outstanding or excess paid suppose if it is then this calculation should be changed so let me say like already I need to pay 50 rupees I need to pay okay it is adding here okay I'm going to pay in the next week may be maybe 20 is a penalty so it's changing okay suppose I paid something extra in the previous maybe 10 rupees I paid already some excess value so 486 is the final amount I should pay for this month right so this is it this how the simple calculation and calculator will work you can apply the formula for one particular cell and you can drag and drop till here or till any automatically the formula will be applying as you can see in any field we click the formula will be available so one time you insert the formula and drag and drop till how many lines automatically it works okay thank you for watching please subscribe to my channel root for m JT B thank you this is Professor Raj see you again good bye