380 likes | 519 Views
Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration. Designed using “hourglass model” to allow for others to use Increased capabilities, broader constituencies Increased Institutional ownership Legitimate senior leadership tool
E N D
Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Designed using “hourglass model” to allow for others to use Increased capabilities, broader constituencies Increased Institutional ownership Legitimate senior leadership tool Strategic Plan, Budgeting, “What if’s”….all in one Sophisticated reporting Front-end graphic interface and ease of use Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Hourglass Model Spend most of the time developing for the user and the audience User – Graphic interface and maximize functionality. The best model is the one that can be passed off to another department! Audience – turn the data into information. Anticipate the questions…answer them. Identify all potential audiences so you don’t have to cobble together reports later Maximizes the efficiency of formulas from the central point of the hourglass out to the reports and user interface Breaks model up into modules and threads formulas based on relationships It doesn’t just produce the report, it shows the process Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
User Interface Hourglass Model Reports – Audience Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
User Interface – Property Management Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
User Interface – Strategic Financial Planning Model Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Drilling Down A Level – Many Models Within a Model Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Understanding Each Model… Seeing It At High Level Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Followings The Process…Seeing Each Step Along The Way Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Complex Tasks Made Easy Not Only is tuition price a factor, but enrollment expectations. Work closely with the Admissions Office to identify several meaningful enrollment scenarios. Run your scenarios in Budget or GAAP modes. Produces the Budget and projects year-end financial statements Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Taking Another Look - Investments Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Understanding Relationships…Building Formulas An intuitive flow between modules. Allows you to quickly see the impact of one module on another Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
A Final Look…FTE’s Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Taking Another Look - Investments Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration Make Assumptions w/ HOS
Taking Another Look - Investments Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration See the results
A Closer Look At The Property Management Model Start by using Google Earth Pro Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
User Interface – Property Management Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
One Model…Many Purposes Integrating Technology Master Plan With Long-Term Physical Plant Plan Safety/Security Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
High Level Options Allow For Global Changes Price Escalation (COLA) Base Year in Model Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
The Gateway To All Buildings and All Major Mechanical Infrastructure Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
The Lowest Level…Building Infrastructure Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
CEWS (A Quick Way To Change Common Elements) Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Bifurcating Large Projects…Parking Lots Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Bifurcating Large Projects…Parking Lots Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Bifurcating Large Projects…Sidewalks Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Bifurcating Large Projects…Sidewalks Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Property Management – Safety/Security – Utility Shut-offs Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Property Management – Safety/Security (Utility Shut-offs) Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Property Management – Safety/Security - Egress Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Property Management – Integrated Building Plans For Each Building Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Property Management – Safety/Security - Egress Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Property Management – Safety/Security - Egress Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Property Management – Safety/Security - Egress Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Property Management – Go Into Rooms…A Virtual Tour Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Property Management – Reports Report is 81 pages of 8.5”x11” and 7 pages of 8.5”x14” Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Property Management – Types of Reports Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Some Facts About The Models: All images you saw in this PowerPoint were from Excel No macros were used Many logic formulas are used and time was spent testing the inter-relationship of modules Property management module employs over 100,000 formulas flowing through two independent summaries that then allow for a test of errors Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration
Parting Thought… I measure the success of every seminar based on whether I can take at least one thing from it to better my life in some way. My hope is that this seminar will allow you to look at a familiar tool (Excel) in a different way…not as a spreadsheet, but a powerful tool to communicate complex ideas in the simplest ways. Mastering Complexity…Achieving Simplicity Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration