Spreadsheet: 181123d1347934110-struggling-with-vlookups-capex-report-aug-2012-1-final-dp
Sheet: 123

 |  |  |  |  |  |  |  |  |  |  |  |  | Actual plus
 |  | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 |  |  | Actual plus | Forecast | 2012
 |  | January | February | March | April | May | June | July | August | 2012 | 2012 Forecast | Forecast | [NAME] | Annual | Actual vs.
 | Description | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual YTD | to be Spent | to be Spent | to Budget | Budget | Budget Variance
 | Planned CapEx - Recurring:
 | Seasonal Decorations | 103 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 103 | 0 | 103 | -103 | 0 | -103
 | Pendants | 444 | 0 | 444 | 444 | 444 | 367 | 0 | 0 | 2143 | 1500 | 3643 | -3643 | 0 | -2143
 | Mixing Valves & Parts | 0 | 0 | 0 | 0 | 290 | 0 | 0 | 0 | 290 | 0 | 290 | -290 | 0 | -290
 | Other | 0 | 0 | 0 | 372 | 0 | 0 | 0 | 1290 | 1662 | 0 | 1662 | -1662 | 0 | -1662
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned CapEx - Recurring | 547 | 0 | 444 | 816 | 734 | 367 | 0 | 1290 | 4198 | 1500 | 5698 | -5698 | 0 | -4198
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Planned CapEx - Non-Recurring:
 |  | - | - | - | - | - | - | - | - | - |  | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total - Planned CapEx | 547 | 0 | 444 | 816 | 734 | 367 | 0 | 1290 | 4198 | 1500 | 5698 | -5698 | 0 | -4198
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | Carillon Assisted Living, LLC |  |  |  |  |  |  |  |  |  |  |  |  | 09/14/12
 |  | Replacement Capital Expenditure Budgets by Facility |  |  |  |  |  |  |  |  |  |  |  |  | 04:48 PM
 |  | As Of  09/14/12
 |  | Knightdale
 |  |  |  |  |  |  |  |  |  |  |  |  | Actual plus
 |  | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 | 2012 |  |  | Actual plus | Forecast | 2012
 |  | January | February | March | April | May | June | July | August | 2012 | 2012 Forecast | Forecast | [NAME] | Annual | Actual vs.
 | Description | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual YTD | to be Spent | to be Spent | to Budget | Budget | Budget Variance
 | Emergency CapEx:
 | Mag Locks & Key Pads | 0 | 0 | 0 | 0 | 916 | 0 | 0 | 0 | 916 | 0 | 916 | -916 | 0 | -916
 | Other | 0 | 0 | 0 | 0 | 0 | 213 | 0 | 425 | 638 | 0 | 638 | -638 | 0 | -638
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Emergency CapEx | 0 | 0 | 0 | 0 | 916 | 213 | 0 | 425 | 1554 | 0 | 1554 | -1554 | 0 | -1554
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Planned, [NAME]. and Emergency Capex | 547 | 0 | 444 | 816 | 1650 | 580 | 0 | 1715 | 5752 | 1500 | 7252 | -7252 | 0 | -5752
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Discretionary CapEx:
 | E-MAR Systems | 0 | 0 | 0 | 0 | 0 | 100 | 0 | 0 | 100 | 0 | 100 | -100 | 0 | -100
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total Discretionary CapEx | 0 | 0 | 0 | 0 | 0 | 100 | 0 | 0 | 100 | 0 | 100 | -100 | 0 | -100
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Grand Total | 547 | 0 | 444 | 816 | 1650 | 680 | 0 | 1715 | 5852 | 1500 | 7352 | -7352 | 0 | -5852
 |  | = | = | = | = | = | = | = | = | = | = | = | = | = | =
 | Percentage of Budget | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A