Spreadsheet: 85936d1285933188-a-potential-bug-in-excel-2010-with-tables-and-if-commands-budget
Sheet: Finance

 | Adrian | £ |  | Kayley | £ |  |  | Kayley Debt | £ |  | £ Total
 | Rent (350) | 0 |  | Rent | 0 |  |  | Sainsburys
 | Food (130) | 62.61 |  |  |  |  |  | [NAME]
 | Phone (0) | 0 |  |  |  |  |  |  |  |  | £ [NAME]
 | Internet (11) | 0.01 |  | Internet | 0.01
 | Bills (30) | 30 |  | Bills | 7.32
 | CTAX (50) | 0 |  | CTAX | 0 |  |  |  |  |  | Rent
 | Gym (43.95) | 43.95 |  |  |  |  |  |  |  |  | 2010-10-25 00:00:00
 | Cash
 | Savings | 0 |  |  |  |  |  |  |  |  | Days Left
 | Total |  |  | Total |  |  |  | Total
 | Expenditure 10978868 |  | Available: |  |  |  |  | Student 13838568 |  | Available:
 | Date | Transaction | Paid In | Paid Out | Balance | Code |  | Date | Transaction | Paid In | Paid Out | Balance
 | 2010-07-22 00:00:00 | Balance | 1523.62 |  |  | - |  | 2010-07-22 00:00:00 | MMU | 167.87
 | 2010-07-22 00:00:00 | Transfer from Student | 157.87 |  |  | Transfer / Paid In |  | 2010-07-22 00:00:00 | Transfer to Expenditure |  | 157.87
 | 2010-07-22 00:00:00 | Premium Bonds |  | 100 |  | Savings |  | 2010-07-29 00:00:00 | MMU | 200.27
 | 2010-07-23 00:00:00 | Sainsbury's |  | 73.12 |  | Food |  | 2010-07-29 00:00:00 | Transfer to Expenditure |  | 190.27
 | 2010-07-23 00:00:00 | Cheque |  | 30 |  | General |  | 2010-07-30 00:00:00 | MMU | 450
 | 2010-07-25 00:00:00 | Meal Out |  | 5.29 |  | Meal / Entertainment |  | 2010-07-30 00:00:00 | [NAME] |  | 100
 | 2010-07-25 00:00:00 | Meal Out |  | 46.94 |  | Meal / Entertainment |  | 2010-07-30 00:00:00 | Transfer to Expenditure |  | 350
 | 2010-07-25 00:00:00 | Rent |  | 700 |  | Rent |  | 2010-08-05 00:00:00 | MMU | 192.64
 | 2010-07-25 00:00:00 | Boots |  | 0.75 |  | Food |  | 2010-08-07 00:00:00 | Transfer to Expenditure |  | 200
 | 2010-07-27 00:00:00 | Transfer to Kayley |  | 40 |  | Transfer |  | 2010-08-12 00:00:00 | MMU | 158.85
 | 2010-07-27 00:00:00 | Transfer to Kayley |  | 10 |  | Transfer |  | 2010-08-12 00:00:00 | Transfer to Expenditure |  | 158.85
 | 2010-07-28 00:00:00 | Transfer to Kayley |  | 15 |  | Transfer |  | 2010-08-19 00:00:00 | MMU | 118.35
 | 2010-07-29 00:00:00 | Virgin Media [NAME] |  | 21.99 |  | [NAME] |  | 2010-08-19 00:00:00 | Transfer to Expenditure |  | 118.35
 | 2010-07-29 00:00:00 | Transfer from Kayley | 60 |  |  | Transfer / Paid In |  | 2010-08-20 00:00:00 | NHS Bursary | 223.62
 | 2010-07-29 00:00:00 | Transfer from Student | 190.27 |  |  | Transfer / Paid In |  | 2010-08-20 00:00:00 | Transfer to Expenditure |  | 226.26
 | 2010-07-29 00:00:00 | Council Tax Bill |  | 100 |  | [NAME] |  | 2010-08-23 00:00:00 | Amazon |  | 2.66
 | 2010-07-30 00:00:00 | Transfer from Kayley | 452.56 |  |  | Transfer / Paid In |  | 2010-08-26 00:00:00 | MMU | 192.64
 | 2010-07-30 00:00:00 | Transfer from Student | 350 |  |  | Transfer / Paid In |  | 2010-08-26 00:00:00 | Transfer to Expenditure |  | 189.98
 | 2010-07-30 00:00:00 | Premium Bonds |  | 300 |  | Savings |  | 2010-09-02 00:00:00 | MMU | 181.51
 | 2010-07-30 00:00:00 | Sainsbury's |  | 24.81 |  | Food |  | 2010-09-02 00:00:00 | Transfer to Expenditure |  | 186.51
 | 2010-08-02 00:00:00 | Virgin Active Gym |  | 43.95 |  | Gym |  | 2010-09-05 00:00:00 | Amazon | 2.66
 | 2010-08-02 00:00:00 | British Gas Bill |  | 29.5 |  | [NAME] |  | 2010-09-09 00:00:00 | MMU | 150.03
 | 2010-08-02 00:00:00 | Water Bill |  | 29.22 |  | [NAME] |  | 2010-09-09 00:00:00 | Transfer to Expenditure |  | 155
 | 2010-08-02 00:00:00 | Argos |  | 69.99 |  | General |  | 2010-09-16 00:00:00 | MMU | 176.9
 | 2010-08-02 00:00:00 | Transfer from Kayley | 47.4 |  |  | Transfer / Paid In |  | 2010-09-17 00:00:00 | NHS Bursary | 202.75
 | 2010-08-04 00:00:00 | Transfer from [NAME] | 100 |  |  | Transfer / Paid In |  | 2010-09-17 00:00:00 | Transfer to Expenditure |  | 380
 | 2010-08-04 00:00:00 | Topman |  | 11.9 |  | Clothes
 | 2010-08-05 00:00:00 | Deposit Point | 105 |  |  | Transfer / Paid In
 | 2010-08-05 00:00:00 | All Saints |  | 13.5 |  | Clothes
 | 2010-08-05 00:00:00 | River Island |  | 16.99 |  | Clothes
 | 2010-08-06 00:00:00 | Starbucks |  | 9.35 |  | Meal / Entertainment
 | 2010-08-06 00:00:00 | Topman |  | 52.7 |  | Clothes
 | 2010-08-06 00:00:00 | JD Sports |  | 16.99 |  | Clothes
 | 2010-08-06 00:00:00 | Hard Rock Café |  | 60.25 |  | Meal / Entertainment
 | 2010-08-07 00:00:00 | Transfer from Student | 200 |  |  | Transfer / Paid In
 | 2010-08-07 00:00:00 | Go [NAME] |  | 10 |  | Meal / Entertainment
 | 2010-08-07 00:00:00 | Sainsbury's |  | 82.4 |  | Food
 | 2010-08-09 00:00:00 | Transfer from Kayley | 30.62 |  |  | Transfer / Paid In
 | 2010-08-09 00:00:00 | Comet |  | 30.62 |  | General
 | 2010-08-10 00:00:00 | Transfer from Kayley | 41.2 |  |  | Transfer / Paid In
 | 2010-08-10 00:00:00 | JD Sports |  | 3 |  | Clothes
 | 2010-08-11 00:00:00 | Premium Bonds |  | 100 |  | Savings
 | 2010-08-11 00:00:00 | Nike Store |  | 4 |  | Clothes
 | 2010-08-11 00:00:00 | JD Sports | 10 |  |  | Clothes
 | 2010-08-11 00:00:00 | Tesco |  | 2.08 |  | Food
 | 2010-08-11 00:00:00 | VUE Cinema |  | 5.3 |  | Meal / Entertainment
 | 2010-08-12 00:00:00 | Transfer from Student | 158.85 |  |  | Transfer / Paid In
 | 2010-08-13 00:00:00 | Transfer to Kayley |  | 16 |  | Transfer
 | 2010-08-13 00:00:00 | Sainsbury's |  | 72.72 |  | Food
 | 2010-08-13 00:00:00 | Sainsbury's |  | 4.08 |  | Food
 | 2010-08-13 00:00:00 | Sainsbury's |  | 0.59 |  | Food
 | 2010-08-14 00:00:00 | Paid In | 90 |  |  | Transfer / Paid In |  | Total
 | 2010-08-14 00:00:00 | [NAME] |  | 25 |  | General
 | 2010-08-15 00:00:00 | Boots |  | 2.99 |  | Meal / Entertainment
 | 2010-08-18 00:00:00 | Boots |  | 4.18 |  | General
 | 2010-08-18 00:00:00 | Transfer from Kayley | 38.7 |  |  | Transfer / Paid In
 | 2010-08-18 00:00:00 | National Express |  | 6 |  | General
 | 2010-08-18 00:00:00 | National Lottery |  | 10 |  | General
 | 2010-08-19 00:00:00 | Transfer from Student | 118.35 |  |  | Transfer / Paid In
 | 2010-08-19 00:00:00 | Premium Bonds |  | 150 |  | Savings
 | 2010-08-20 00:00:00 | Sainsbury's |  | 72.62 |  | Food
 | 2010-08-20 00:00:00 | Transfer from Student | 226.26 |  |  | Transfer / Paid In
 | 2010-08-20 00:00:00 | Transfer from Kayley | 36.31 |  |  | Transfer / Paid In
 | 2010-08-21 00:00:00 | Topshop |  | 25.2 |  | Clothes
 | 2010-08-21 00:00:00 | Boots |  | 5.92 |  | Meal / Entertainment
 | 2010-08-21 00:00:00 | Next |  | 32 |  | Clothes
 | 2010-08-21 00:00:00 | House of Fraser |  | 6.25 |  | Clothes
 | 2010-08-21 00:00:00 | River Island |  | 26.99 |  | Clothes
 | 2010-08-21 00:00:00 | Topman |  | 14.4 |  | Clothes
 | 2010-08-22 00:00:00 | Boots |  | 2.99 |  | Meal / Entertainment
 | 2010-08-22 00:00:00 | [NAME] |  | 25 |  | General
 | 2010-08-23 00:00:00 | Council Tax Bill |  | 100 |  | [NAME]
 | 2010-08-23 00:00:00 | Hammicks BMA |  | 45.08 |  | General
 | 2010-08-24 00:00:00 | [NAME] PT | 100 |  |  | Transfer / Paid In
 | 2010-08-26 00:00:00 | Transfer from Student | 189.98 |  |  | Transfer / Paid In
 | 2010-08-26 00:00:00 | Rent |  | 700 |  | Rent
 | 2010-08-26 00:00:00 | Premium Bonds |  | 100 |  | Savings
 | 2010-08-26 00:00:00 | [NAME] |  | 6.7 |  | Meal / Entertainment
 | 2010-08-27 00:00:00 | Cash |  | 10 |  | General
 | 2010-08-27 00:00:00 | Sainsbury's |  | 81.51 |  | Food
 | 2010-08-28 00:00:00 | Transfer from Kayley | 822.76 |  |  | Transfer / Paid In
 | 2010-08-29 00:00:00 | Sports Direct |  | 32.98 |  | Clothes
 | 2010-08-31 00:00:00 | Virgin Media [NAME] |  | 21.99 |  | [NAME]
 | 2010-09-01 00:00:00 | Virgin Active Gym |  | 43.95 |  | Gym
 | 2010-09-01 00:00:00 | British Gas Bill |  | 29.5 |  | [NAME]
 | 2010-09-01 00:00:00 | Water Bill |  | 29.22 |  | [NAME]
 | 2010-09-01 00:00:00 | Homebase Vouchers |  | 31.5 |  | General
 | 2010-09-01 00:00:00 | MMU Student Union |  | 2.3 |  | General
 | 2010-09-02 00:00:00 | Transfer from Student | 186.51 |  |  | Transfer / Paid In
 | 2010-09-03 00:00:00 | [NAME] |  | 30 |  | General
 | 2010-09-03 00:00:00 | Travel Money |  | 699.78 |  | General
 | 2010-09-03 00:00:00 | Sainsbury's |  | 58.47 |  | Food
 | 2010-09-03 00:00:00 | Transfer from Kayley | 44.24 |  |  | Transfer / Paid In
 | 2010-09-05 00:00:00 | Waterstones |  | 12.99 |  | General
 | 2010-09-06 00:00:00 | Coop |  | 3 |  | Meal / Entertainment
 | 2010-09-08 00:00:00 | Sports Direct |  | 39.98 |  | Clothes
 | 2010-09-09 00:00:00 | Transfer from Student | 155 |  |  | Transfer / Paid In
 | 2010-09-13 00:00:00 | Boots |  | 6.98 |  | Meal / Entertainment
 | 2010-09-17 00:00:00 | Cash |  | 30 |  | General
 | 2010-09-17 00:00:00 | Transfer from Student | 380 |  |  | Transfer / Paid In
 | 2010-09-17 00:00:00 | Sainsbury's |  | 87.95 |  | Food
 | 2010-09-17 00:00:00 | ChaoBaby |  | 36 |  | Meal / Entertainment
 | 2010-09-18 00:00:00 | Transfer from Kayley | 61.98 |  |  | Transfer / Paid In
 | 2010-09-20 00:00:00 | WH Smiths |  | 2.55 |  | General
 | 2010-09-22 00:00:00 | Council Tax Bill |  | 100 |  | [NAME]
 | 2010-09-24 00:00:00 | Sainsbury's |  | 91.41 |  | Food
 | 2010-09-25 00:00:00 | Rent |  | 700 |  | Rent
 | 2010-09-27 00:00:00 | Transfer to Kayley |  | 0.91 |  | Clothes
 | 2010-09-29 00:00:00 | Virgin Media [NAME] |  | 21.99 |  | [NAME]
 | 2010-09-29 00:00:00 | Coop |  | 5.5 |  | General
 | Total