Comuna Management Systems
  • Portfolio
  • Contact
  • About

Portfolio Projects of Sean Morris

  • Automation with Visual Basic Programming
  • Interactive Business Intelligence Reports with Microsoft Power BI
    • Adventureworks Cycles Sales Dashboard
    • State of Vermont Property Valuation Mapping​
  • Spreadsheet Modeling and Dashboards
    • Vermont Renter Rebate Reform Proposal Cost Model
    • Simple 2-Period Economic Consumption Model for Economics Students
    • National "Doughnut" Accounting Spreadsheet Tool
  • Database Design and Development
  • Press Coverage

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. 
Picture
renter_rebate_reform_sandbox_calculator_v15.xlsb
File Size: 353 kb
File Type: xlsb
Download File

 

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. 
2_period_consumption_model_comuna_v7.xlsb
File Size: 69 kb
File Type: xlsb
Download File

Picture
 

National "Doughnut" Accounting Spreadsheet Tool

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

Picture
national_doughnut_accounting_spreadsheet_v16.xlsx
File Size: 606 kb
File Type: xlsx
Download File


Picture

 

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.
Picture
Powered by Create your own unique website with customizable templates.