Portfolio Projects of Sean Morris
Automation with Visual Basic Programming
Interactive Business Intelligence Reports with Microsoft Power BI
Adventureworks Cycles
The Adventureworks Cycles Dataset is a fake dataset produced by Microsoft for demonstration and testing purposes.
State of Vermont Property Valuation Mapping
Click to set custom HTML
Spreadsheet Modeling and Dashboards
Vermont Renter Rebate Reform Proposal Cost Model
This model gives legislators a tool to compare the current renter rebate program with a new proposal. The proposed program would distribute benefits based on the place of residence and the family size instead of simply the annual income and rent amount.
| renter_rebate_reform_sandbox_calculator_v15.xlsb |
Simple 2-Period Economic Consumption Model for Economics Students
|
This is a simple 2-period consumption model designed for intermediate microeconomics students at the University of Vermont to get a dynamic understanding of consumer responses to changes in interest rates, inflation, income streams, and assets on current and future consumption decisions.
|
| ||
National "Doughnut" Accounting Spreadsheet Tool
English Economist Kate Raworth has written extensively about the need for our economy to operate within a safe and just space for humanity - one that meets basic social needs and sustains itself without exceed significant ecological boundaries. She conceives of this safe operating space as a "doughnut", which she describes in her 2017 book, Doughnut Economics.
The National Doughnut Accounting Spreadsheet tool was designed as a group project for Community Development students to gain experience with accessing and evaluating performance data from the World Bank, the United Nations and the Ecological Foodprint Network. Please note that this was designed as a teaching tool - the metrics included are imperfect and by no means exhaustive. |
|
| ||
Database Design and Development
The video below is for a database built for a research lab at Massachusetts General Hospital.
Press Coverage
|
We developed an excel-based tool that was widely used by property owners in the state of Vermont to estimate household property taxes. The tool was covered by local news outlets in the state. See a story and video profiling the tool here.
|
|
