Spreadsheet: 159124d1338504195-trim-formula-az-bud
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 |  |  |  |  |  |  |  |  |  |  |  |  | #Missing | #Missing | #Missing | #Missing
Visit/WRVU or WRVU/Visit(Proc) | #Missing |  |  |  |  |  |  |  |  |  |  |  |  | #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
-Phys Visits-Type % | 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
-Gross Rev Alloc % - OP | 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
-EHR Incentive Revenue | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing
-Other Operating Revenue | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing | #Missing