OLD SUBMISSION (DO NOT CONSIDER)

• 

  Startup Page

• 

  Contact Us Page

• 

  Create Account Page

• 

  Login Page

• 

  Login Page (with one-time passcode)

• 

  Decision Page

• 

  Create Budget Page

• 

  Input Spending Page

• 

  See Spending Page

• 

  User Data Example

• 

  Allocated Budget Data Example

• 

  Spent Budget Data Example

• 

  Contact Us Data

Inspiration

We wanted to create an app that is both readily available and practical. We also wanted to help Virginia Tech Students succeed at budgeting their finances while keeping their login and data secure.

What it does

Our app, "HokieWatch", helps Virginia Tech students budget their money for a time period they choose (E.g. monthly). Users will first have to create an account by entering their email address and by creating a PIN code. Once the account has been been created, a confirmation email is sent to the users. From there, users will have to log in with their account credentials. If the credentials are correct, the users must enter a unique one-time passcode (OTP) sent via email. Next, users will input their total budget and their budget for whichever categories they want to allocate for . Whenever the users spend money pertaining to a category, they login and input spending information. Additionally, users can view the budget for each category versus how much was spent for that category through a neat chart visualization.

How we built it

We utilized Mircosoft PowerApps for the application. We also modeled the data for the application through Microsoft Excel.

Challenges we ran into

Modeling the data. Patching data in our Excel database. Creating chart visualizations. Slow data updating with the cloud technology.

Accomplishments that we're proud of

Finishing all the use cases we talked about on Friday. Managing to send a unique access code for two-factor authentication. Patching data to out database.

What we learned

The vast power in cloud development by using Mircosoft PowerApps. How to utilize Virginia Tech technology in services with an application. The difficulty of modeling a database in Excel.

What's next for Clean Sweep

Wait for Hackathon Results and learn more about cloud development in the future.

Built With

• dataconnections
• excelonline
• gmail
• microsoftpowerfx
• outlook
• powerapps