## Notes *Open Budget* is an open source application that connects a phone app to a spreadsheet in a secure way. ## Tech Stack - UI - Quasar - iOS - Android - Desktop app - API - Something to read a spreadsheet from a file on a computer - Host it on home network so that it can be read - Expose it to the network some how - Generate security at home network-level, like private-public key pair, and that private key can be put in the phone app - Support for Google Sheets using Google Sheet APIs? - Database - Spreadsheet as the single-source of truth - Option to migrate? ## Data ### Config Needs to be stored somewhere else? Another sheet in the spreadsheet? ## Research There are countless spreadsheets out there and they all have core data in common. I think that once the app nails down the core internal data, it would then need to help people map their data to the expected internal data structures. ## Justification ### Desktop-focused There is a group of people that tracks their spending and budgeting in a spreadsheet, but spreadsheets are only good for widescreen displays simply because of the way the data is formatted and laid out. What if there was a way to read in data from spreadsheets into an app? At home that is possible with some app development. However we would need to do more engineering to get the app to read from a spreadsheet over the network. ## Gamification It might be worth trying to gamify this by making personal finance easily digestible. Once the general expense tracking workflow is set up, I can then add in the badges and tutorial. ## Resources - [ELI22: Personal finance tips](https://www.reddit.com/r/personalfinance/comments/4tlqsd/eli22_personal_finance_tips_for_older_young/) - [Reddit /r/personalfinance Wiki](https://www.reddit.com/r/personalfinance/wiki/index/) - [Personal Income Workflow - Imgur](https://imgur.com/1rPEkGQ) - [Spreadsheet for People Who Don't Know How to Budget - Reddit /r/personalfinance](https://www.reddit.com/r/personalfinance/comments/nbijxz/i_made_a_spreadsheet_for_people_who_dont_know_how/) - [Reddit /r/personalfinance spreadsheet v5](https://www.reddit.com/r/personalfinance/comments/umis3h/i_made_a_spreadsheet_for_people_who_dont_know_how/) - [Budget Charts - Imgur](https://imgur.com/a/63LxvUQ) - [Google Docs](https://docs.google.com/spreadsheets/u/0/d/1LNpotbdAGBbh70CPnrC1JzqGDrlSfQt9Y2-7ollL5ck/htmlview) - [How My Wife and I Never Fight Over Money - Reddit /r/personalfinance](https://www.reddit.com/r/personalfinance/comments/6ka7ku/how_my_wife_and_i_never_fight_over_money/) ## Worklog - [[2024-10-15 Ija Money Worklog]] - [[2024-10-14 Open Budget Worklog]] - [[2024-10-12 Open Budget Worklog]]