Spreadsheet: 159183d1338540619-trim-formula-azbud-4
Sheet: Revenue Upload

 | Stage_Budget
 | FY13
 | -YearTotal | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | -Q1 | -Q2 | -Q3 | -Q4
[NAME] Driver Choice | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs | WRVUs
[NAME] | #Missing | 568.9547301648041 | 1046.504484245846 | 1804.197083482782 | 1075.654991351215 | 1230.154129285315 | 1043.024482657347 | 1590.984242987432 | 1094.027389786508 | 960.9384540934172 | 1003.097766618213 | 1817.459021696013 | 940.1755917495238 | #Missing | #Missing | #Missing | #Missing
Visit/WRVU or WRVU/Visit(Proc) | #Missing | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677689 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677688 | 0.1810337352677689 | #Missing | #Missing | #Missing | #Missing
[PHONE] Tot WRVUs | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
999580 Total Visits | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Tot Procedures | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME] | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
#N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
OP Revenue Per Stat | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME] | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME] | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME] | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME] Workers Comp | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME]PPO | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME] HMO | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME] % - OP Commercial/Other | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME] (PLUG) | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
#N/A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
[NAME] GR % - Charity | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[NAME] GR % - Unins | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Net Rev PCR % - Medicare | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
Net Rev PCR % - Medicaid | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
Net Rev PCR % - Medicare HMO | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
Net Rev PCR % - Medicaid HMO | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
Net Rev PCR % - Mgd Care HMO/PPO | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
Net Rev PCR % - Commercial Other | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
Net Rev PCR % - Self Pay Charity | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
Net Rev PCR % - Self Pay Unins | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
Net Rev PCR % - Workers Comp | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
828000 Bad Debt % NPR | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
828000 Bad Debt - Manually Input | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE]  [NAME] O/P | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE]  [NAME] O/P ANC Rev-Sr | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
Cash Collections % NPR | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE]  Supp | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] TV Radio Rentals | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Medical Records Transcript | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE]  Med record/abstrt sales | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE]  Med supply sales | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE]  Rental income | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Rental Income: Leased Beds | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Other Property Rentals | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Rental Income: Professional Office | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Pro Fees Collections | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Hotel - Oth Rev | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE]  Oth Serv Rev | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE]  Oth operating Rev | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Oth Rev-Cap Contr Prem | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Cap Contractural WO - Comm - O/P | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Interest Income | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE]  Oth Income | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Cash Over/Short | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Medicare EHR Incentive PMT - MU | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Medicare EHR Incentive Pmt - PQRS | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
[PHONE] Medicare EHR Incentive Pmt - PC | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
#N/A | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
#N/A | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing