1 / 38

Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

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

tangia
Download Presentation

Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  2. 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

  3. 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

  4. User Interface Hourglass Model Reports – Audience Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  5. User Interface – Property Management Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  6. User Interface – Strategic Financial Planning Model Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  7. Drilling Down A Level – Many Models Within a Model Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  8. Understanding Each Model… Seeing It At High Level Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  9. Followings The Process…Seeing Each Step Along The Way Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  10. 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

  11. Taking Another Look - Investments Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  12. 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

  13. A Final Look…FTE’s Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  14. Taking Another Look - Investments Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration Make Assumptions w/ HOS

  15. Taking Another Look - Investments Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration See the results

  16. A Closer Look At The Property Management Model Start by using Google Earth Pro Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  17. User Interface – Property Management Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  18. 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

  19. High Level Options Allow For Global Changes Price Escalation (COLA) Base Year in Model Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  20. The Gateway To All Buildings and All Major Mechanical Infrastructure Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  21. The Lowest Level…Building Infrastructure Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  22. CEWS (A Quick Way To Change Common Elements) Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  23. Bifurcating Large Projects…Parking Lots Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  24. Bifurcating Large Projects…Parking Lots Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  25. Bifurcating Large Projects…Sidewalks Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  26. Bifurcating Large Projects…Sidewalks Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  27. Property Management – Safety/Security – Utility Shut-offs Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  28. Property Management – Safety/Security (Utility Shut-offs) Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  29. Property Management – Safety/Security - Egress Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  30. Property Management – Integrated Building Plans For Each Building Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  31. Property Management – Safety/Security - Egress Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  32. Property Management – Safety/Security - Egress Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  33. Property Management – Safety/Security - Egress Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  34. Property Management – Go Into Rooms…A Virtual Tour Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  35. 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

  36. Property Management – Types of Reports Next Generation Modeling Ease of Use. Sophistication. Integration. Collaboration

  37. 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

  38. 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

More Related