If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




spreadsheet for splitting a utility bill
How would I find or make a spreadsheet for splitting an electric utility bill
among three tenants? The knowns are the total kwh used, the total bill and the number of KWH used by two of the three tenants. Thanks! 
Ads 
#2




Why would you need a spreadsheet for that, paper and a pen would do or a
calculator Sounds like homework to me  Regards, Peo Sjoblom "dmcquil" > wrote in message ... > How would I find or make a spreadsheet for splitting an electric utility > bill > among three tenants? The knowns are the total kwh used, the total bill > and > the number of KWH used by two of the three tenants. > > Thanks! 
#3




Hi!
Subtract from the total kwh, the known kwh used by the 2 tennants. The result you get will be the kwh used by the third tennant. Divide the total kwh by the kwh for each tennant. This will return each tennants percentage of kwh used. Multiply each tennants percentage used by the total bill amount. Biff >Original Message >How would I find or make a spreadsheet for splitting an electric utility bill >among three tenants? The knowns are the total kwh used, the total bill and >the number of KWH used by two of the three tenants. > >Thanks! >. > 
#4




LOL  methinks you are not wrong <g>
 Regards Ken....................... Microsoft MVP  Excel Sys Spec  Win XP Pro / XL 97/00/02/03  It's easier to beg forgiveness than ask permission :)  "Peo Sjoblom" > wrote in message ... > Why would you need a spreadsheet for that, paper and a pen would do or a > calculator > Sounds like homework to me > >  > Regards, > > Peo Sjoblom > > > "dmcquil" > wrote in message > ... > > How would I find or make a spreadsheet for splitting an electric utility > > bill > > among three tenants? The knowns are the total kwh used, the total bill > > and > > the number of KWH used by two of the three tenants. > > > > Thanks! > > 
#5




D1= Total cost
E1= Total KWH E2=KWH used by two tenants =D1(D1*(E2/E1)) Vaya con Dios, Chuck, CABGx3 "dmcquil" > wrote in message ... > How would I find or make a spreadsheet for splitting an electric utility bill > among three tenants? The knowns are the total kwh used, the total bill and > the number of KWH used by two of the three tenants. > > Thanks! 
#6




Hi, ignore that. Set up a spreadsheet with the following headings in col A,
as indicated: A2: Bill, A3 Tenant A, A4 Tenant B, A5 Tenant C. In B1, type in "Jan". Move your cursor to the bottom right hand corner, where it changes to a +, click, hold and drag across to Col M. That will give you the months of the year. In B5, enter the following formula : =B2(B3+B4). Now drag this across to col M as well. You are set up and ready to go. Enter the bill amount in Row 2, below the relevant month, the known costs in row 3 and 4, and see the other tenant's cost in Row 5. Save, and build up a record for the year. "Biff" wrote: > Hi! > > Subtract from the total kwh, the known kwh used by the 2 > tennants. The result you get will be the kwh used by the > third tennant. > > Divide the total kwh by the kwh for each tennant. This > will return each tennants percentage of kwh used. > > Multiply each tennants percentage used by the total bill > amount. > > Biff > > >Original Message > >How would I find or make a spreadsheet for splitting an > electric utility bill > >among three tenants? The knowns are the total kwh used, > the total bill and > >the number of KWH used by two of the three tenants. > > > >Thanks! > >. > > > 
#7




> Hi, ignore that.
And why exactly??  Regards Ken....................... Microsoft MVP  Excel Sys Spec  Win XP Pro / XL 97/00/02/03  It's easier to beg forgiveness than ask permission :)  "Kassie" > wrote in message ... > Hi, ignore that. Set up a spreadsheet with the following headings in col A, > as indicated: A2: Bill, > A3 Tenant A, > A4 Tenant B, > A5 Tenant C. > > In B1, type in "Jan". Move your cursor to the bottom right hand corner, > where it changes to a +, click, hold and drag across to Col M. That will > give you the months of the year. > > In B5, enter the following formula : =B2(B3+B4). Now drag this across to > col M as well. > > You are set up and ready to go. Enter the bill amount in Row 2, below the > relevant month, the known costs in row 3 and 4, and see the other tenant's > cost in Row 5. > > Save, and build up a record for the year. > > "Biff" wrote: > > > Hi! > > > > Subtract from the total kwh, the known kwh used by the 2 > > tennants. The result you get will be the kwh used by the > > third tennant. > > > > Divide the total kwh by the kwh for each tennant. This > > will return each tennants percentage of kwh used. > > > > Multiply each tennants percentage used by the total bill > > amount. > > > > Biff > > > > >Original Message > > >How would I find or make a spreadsheet for splitting an > > electric utility bill > > >among three tenants? The knowns are the total kwh used, > > the total bill and > > >the number of KWH used by two of the three tenants. > > > > > >Thanks! > > >. > > > > > 
#8




>Hi, ignore that.
Ignore what? Biff >Original Message >Hi, ignore that. Set up a spreadsheet with the following headings in col A, >as indicated: A2: Bill, >A3 Tenant A, >A4 Tenant B, >A5 Tenant C. > >In B1, type in "Jan". Move your cursor to the bottom right hand corner, >where it changes to a +, click, hold and drag across to Col M. That will >give you the months of the year. > >In B5, enter the following formula : =B2(B3+B4). Now drag this across to >col M as well. > >You are set up and ready to go. Enter the bill amount in Row 2, below the >relevant month, the known costs in row 3 and 4, and see the other tenant's >cost in Row 5. > >Save, and build up a record for the year. > >"Biff" wrote: > >> Hi! >> >> Subtract from the total kwh, the known kwh used by the 2 >> tennants. The result you get will be the kwh used by the >> third tennant. >> >> Divide the total kwh by the kwh for each tennant. This >> will return each tennants percentage of kwh used. >> >> Multiply each tennants percentage used by the total bill >> amount. >> >> Biff >> >> >Original Message >> >How would I find or make a spreadsheet for splitting an >> electric utility bill >> >among three tenants? The knowns are the total kwh used, >> the total bill and >> >the number of KWH used by two of the three tenants. >> > >> >Thanks! >> >. >> > >> >. > 
#9




Biff
Flip your quotient over. The way you have it results in each person having more than 100% of the total. HTH Otto "Biff" > wrote in message ... > Hi! > > Subtract from the total kwh, the known kwh used by the 2 > tennants. The result you get will be the kwh used by the > third tennant. > > Divide the total kwh by the kwh for each tennant. This > will return each tennants percentage of kwh used. > > Multiply each tennants percentage used by the total bill > amount. > > Biff > >>Original Message >>How would I find or make a spreadsheet for splitting an > electric utility bill >>among three tenants? The knowns are the total kwh used, > the total bill and >>the number of KWH used by two of the three tenants. >> >>Thanks! >>. >> 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Some exported records do not show on spreadsheet  vulcan88  Excel Worksheet Functions  0  March 30th 05 01:11 AM 
paste contents from other spreadsheet  JohnT  Excel Worksheet Functions  3  February 8th 05 03:30 PM 
Applying Existing Password to New Spreadsheet  Vic  Excel Discussion (Misc queries)  1  January 27th 05 12:37 AM 
How do I convert exel spreadsheet to works spreadsheet?  tareco  Excel Discussion (Misc queries)  3  December 27th 04 11:20 PM 
How do I cancel sending a spreadsheet by email?  Cendra  Excel Discussion (Misc queries)  3  December 2nd 04 09:55 PM 