Changelog

23.0.2

Minor fixes when Excel is set to Automatic Calculation:

The F9 Stat Converter runs faster with automatic calculation turned on.

Changing a Business Segment's Type when not using the Advanced Business Segments wasn't showing the changed segment type on reports with automatic calculation turned on.

23.0.1

Minor fix for converting from base V21 MA.

23.0.0

Major Version Release

Converter Rework:

One converter handles converting from V17, V21, and older or equivalent V23.

It is no longer required to have the old MA open to perform the conversion.

You now have the capability of choosing where the finished file will save. The default is the location of the old MA.

Drill-Down Rework:

The Drill-Down is more focused.

Reports with the Drill-Down button have been enhanced to make use of this utility.

Filter button has been enhanced: Report items containing multiple Types and Sub-Types rolled up can all be filtered for at the same time. Example: Looking at an RN item containing Direct, Contract, and Per Diem labor will show all of those on the Account Lineup after clicking the Filter button.

New Window Enhancement:

Excel has a powerful feature allowing you to create a New Window for multiple views within the same file. It does, however, lose the view settings including the freeze panes when used. That is why we added logic within the MA to apply all the neccessary view settings to any newly created window.

To try it for yourself, go to the View tab at the top of Excel and click the New Window button.

Report Banding:

Banding (alternating color) has been added to the reports to make reading them even easier.

Account Lineup Enhancements:

Deleting accounts has been simplified. Select a cell on the row of the account(s) you wish to delete and click the Delete Selection button. The lineup and allocations for the account(s) will be removed. Make use of the Sort button afterwards to fill in the gaps.

New Add Missing button which will check the Import Tie-Out for any accounts not present on the Account Lineup and add them to the bottom of the Account Lineup.

The Account and Description columns may be resized between two preset widths by clicking <--> (Expand) and >--< (Collapse).

Enhanced F9 Support:

When performing F9 Analyze on the Account Lineup, you can now use the Current Sheet option.

Added what we call Analyze Assistant. After clicking Analyze Now, the MA will obtain the GL Amounts, apply a filter, break the account numbers into their segments, and provides a button to quickly filter for missing accounts.

Detailer Enhancements:

Added more fine control views to see only the Financial Amounts, NPR%, and Patient-Day Amounts.

New Modeling Utility for experimenting with your modeling or clearing out old amounts to start over. You can choose to clear the Allocations, Visit Design, and/or the Cost Engineering.

Allocations:

The Advanced Allocations have been increased from 4 to 15 segments.

Segment Style:

Version 21 introduced the capability to set a custom color to the Business Segments. Version 23 allows you to set the font color.

Upload Buttons:

A new Upload button has been added to the Controls. This "E-Mail Full MA" button will send the entire MA file to us.

The legacy Upload file logic has been reworked to make the uploads much smaller than before.

Business Segment Order Utility:

For those making use of the Advanced Business Segments logic, this utility empowers you to easily move your segments around. Previously you had to manually move the Stats on the Controls, your Allocation and Model amounts on the Detailer, and your amounts on the Visits report. Make use of this utility, choose the order you wish the segments to be in and let it take care of the rest.

Many other

21.9.0

This is anticipated to be the last update to Version 21 as we move towards releasing Version 23.

Report standardization has been applied across all reports to improve clarity of the data.

Minor fix for the Drill-Down being able to crash when trying to double click an account beyond what is currently filtered.

21.8.4

Added a button on the Instructions sheet to fix F9 Stat Formulas on the Controls sheet.

Added code to run when a client performs a F9 Analyze:

• Compatible with F9 Versions 5, 5.5, and 6.

• Automatically adds the GL Formula.

• Adds a Filter.

• Adds a button to filter for only accounts that are missing, duplicated, and have financial amounts. Click again to show all.

• Automatically performs a Text to Columns to break the accounts into their segments.

21.8.3

Enhanced the Period Specifier:

• Extra spaces are trimmed.

• Works with Lower Case

• Year to Date fully typed out

• Three letter abbreviated Month

• For F9 users, Change and Net Change

Reworked the Account Lineup sorter coding for a bug fix.

Reworked events on the Account Lineup and Detailer to allow more actions to not empty the Undo/Redo stack.

Increased the usable range of the Import from Column Q to Z.

Updated the EBITDA comments throughout the system.

Added resiliency logic for the Import sheet to fix its range in the event rows are deleted. Runs at startup.

21.8.2

Minor fixes were making it look as if more major things were taking place. Moved to "Release.Major.Minor" Versioning convention so minor fixes are reflected as such instead of incrementing the "Major" number spot.

Added a field for entering Non-NQF-Endorsed HCI HIS Score for use with Version 22 Benchmarking Application.

Fixed spelling on the Modeling Report.

22.0.5

IP Unit Bed Count Your Rank was inverted.

For the NPR and Patient-Day reports, the line item Triage has been updated to Call Center to reflect with the latest MA version.

Fixed an uncommon issue where trying to access the BA template file, mvi.xlsx, after generating a report with the Query window still open would result in an error that it is locked in a process. This issue only affects those with the BA installed on a machine with multiple users using it at the same time.

22.0.4

Minor fix for the template not showing the criteria used when generating the reports.

22.0.3

Added new area for IP Unit Bed count as well as a re-worked Executive Dashboard Organization section.

Brought further enhancements to the BA template to provide Your Rank alerting to reports that didn't have it yet.

Added Color Alerting for the Model report bringing a comparision of Your Data against Your Model in the same fashion as the DD.

Added report banding (Alternating row colors) with an option to turn it off on the Instructions sheet.

22.0.2

Updated the BA's Template file for much better clarity and standardization of the reports.

22.0.1

Internally found and fixed a minor bug fix for an extremely rare crash.

22.0.0

Major Reworks improving performance, reliability, and ease of use.

Smoother installation process with an installer package 4% Version 21's size.

Report generation up to 4.5x faster.

*New* Queued Queries tab to speedup generation of reports commonly used.

*New* Alerts Results Report for easier to read Alerts and Exclusions.

21.0.2

Minor fix for Version 17 MA DD Uploads.

21.0.1

Minor fix to ensure V21 MA DD Uploads could still process with other code names.

21.0.0

Ported the Flash version of the Decision Dashboard to an Excel based version.

New version now allows current modifications to be saved for when the end of the day comes or historical purposes.