Established in 1986, ProMedica is a mission-based, not-for-profit healthcare organization in northwest Ohio and southeast Michigan that includes nearly 15,000 employees with 12 hospitals, post-acute and rehabilitation services, and nearly 1,700 physicians – with nearly 600 healthcare providers employed by ProMedica Physicians, and Paramount Insurance. Its 12 hospitals and more than 306 facilities offer comprehensive diagnostic, medical and surgical specialties in heart and vascular, oncology, orthopaedics, neurology, and women and pediatric services.
Prior to implementing Spreadsheet Server, ProMedica used a combination of methods to transfer financial information from their accounting system into Excel. After years of manually imputing data, they desired the ability to dynamically access accounts payable information, and create ad-hoc and monthly reports quickly.
Spreadsheet Server converts Excel into a tightly integrated analytical tool for any ERP system. Users can leverage the strength of their spreadsheets with seamless dynamic integration to their information, along with powerful drilldown capability to the lowest level of detail. It allows users to build a range of reports from simple ad hoc workbooks to complex dashboard-type views of critical business data.
Distribution Manager automates the distribution of reports from Microsoft® Excel.
For ProMedica, Global’s solutions allow them to leverage a live connection from their Lawson database directly into Excel while avoiding duplication of data. This makes it possible to make last minute changes to any report, by any user, at any time. Spreadsheet Server is currently being used for flash reporting, statistical reporting, audit footnote compilation and 990 reporting.