Power
Billing Solution in Microsoft Excel


Home  
Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 





A
question from
one of our website visitors: Hello Sir/Madam, This is Rajkamal. Am in the beginning stage or we can say as fresher also. Sir I want to use the cell values (Which use to be enter in that particular cells) in “for and If conditions” in VBA programming. Sir Actually I have Contract Demand, Billing Demand & Maximum Demand. So my payment as to do according to the billing demand but in case my maximum demand is higher than billing demand then I have to pay the maximum demand charges. In that case if the maximum demand exceeds the contract demand then I have to pay penalty for that. Here I can explain by giving the sample values. Case1: Contract Demand = 100 kW Billing Demand = 75 kW Maximum Demand = 110 kW In this case I have to pay for that 110 kW charges, up to 100kW no penalty charges. Rest of 10 kW I have to pay penalty. Case 2: Contract Demand = 100 kW Billing Demand = 75 kW Maximum Demand = 90 kW In this case I have to pay for that 90 kW charges, no penalty charges. Case 3: Contract Demand = 100 kW Billing Demand = 75 kW Maximum Demand = 50 kW In this case I have to pay for that 75 kW charges, no penalty charges. In this second problem is, in EB they have the classifications like, First 30kW charges Rs.80 Then next 20 kW charges Rs.100 Then next 15 kW Charges Rs. 120 Then rest of kW charges Rs.150 Penalty Charges Rs.180/kW In this the split up some time it will change. Like sometimes it may only two split ups First 50kW charges Rs.90 Rest of kW charges Rs.130 Penalty Charges Rs.180/kW So I want whenever we are giving split up according that, it has to calculate. With this mail I have attached the excel sheet in which I tried little bit but I couldn’t able to complete please help me to resolve this one. Thanks in advance. Anymore clarifications please ask me. Solution:




Home  
Excel 2007  Excel 2003  Macros Excel 2007  Macros Excel 2003  Excel 2010 
