![]() The biggest probably being that spreadsheets lack "dynamic" capabilities. half of the user base from other parts of the world). In the short term, to keep the product free, auto-importing isn't something I'm looking at (and if I did, it's likely the US would be the only thing I could support which would leave out approx. ![]() I really don't like (our fully trust) those auto importers - from a security standpoint or an accuracy standpoint (I tried YNAB a long time ago and it was absolutely terrible at importing - that was actually when I started creating Aspire). I'm actually in the process of migrating all this over to a Sheets Add-on so future versions of the sheet won't ship with any script code. That work was done a long time ago to support various users wanting to have a way to localize dates and currencies. I agree the script calls could be worked on. Thanks! That's awesome that you're around RDU! (Mods, I've tried to follow all the rules for sharing something I created in Google Sheets - if I missed something, please let me know and I'll get it fixed!) I'm always available through DM or my subreddit /r/AspireBudgeting. If anyone is interested enough to kick the tires on it, I'd love to hear your thoughts. I'm always looking for feedback on Aspire so I can make it the best spreadsheet budgeting resource around. That's a pipe dream at this point though :) More recently, I've thought about Google Sheets as an encore career and possibly having a small consulting business that helps other people/companies with Google Sheets. My end goal with it is primarily to have fun and to create something others can find useful. I don't charge for Aspire, it's a totally free tool (it doesn't collect any data either). If the tool is free, why did you make it? I learned that creating two or three graphs and placing them near one another made a kind of "super graph" - together, these graphs clearly communicated the data I wanted to show. While powerful, the existing graphs and charts sometimes aren't flexible enough to show all the data you want or to convey the whole picture. Sometimes you want to visually show data in a graphical format in a spreadsheet. I think they really elevate the experience.Ĭombining multiple graphs to convey more information I'm really proud of the mini pie charts I'm able to show on the Dashboard. Google's IMAGE function is a huge win in this area because you can use it to add a little color and some surprises to your sheets to make them more enjoyable (not to mention useful). Spreadsheets are notorious for being bland and for being a wall of text. This is a huge win for me, because I wanted to the tool to be easy to understand and approachable for technical and non-technical users. Using some simple front-end skills, it's pretty straightforward to create something that mimics a native web application. I come from a FED/UX background and was surprised at just how flexible the styling and theming tools are. Combining this with date ranges provides another valuable window into the data because you can bound your data by years or months.ĭesigning an interface in Google Sheets is fun I split and slice all kinds of Transactions data using these functions to generate reports and the data on the main Dashboard page. It's amazing what you can do with these two functions. Reflecting back, here are some tricks I've picked up on the way.Ī few screenshots of the current version for reference:īeyond basic function uses and technical knowledge, these are some of the standout things I've learned. Our little community has grown a lot recently and it's been great to help others on their financial journeys. Over time, I ended up creating a spreadsheet and making it available for others to download and use ( ). Discouraged, I decided to try creating a budgeting tool in Sheets with the end goal making something powerful and easy to use (features I thought existing templates severely lacked). I tried various ones and, in the end, none of them were quite what I wanted. About 2 years ago, I was on a mission looking for a new budgeting tool. I've been a heavy user of Google Sheets for a few years now and thought it would be fun to share something I've built with this community. ![]() Points Leaderboard #Ĭlick Here to see the full list. Please be patient, sometimes it takes a couple of minutes. OPs must reply to the best solution with "Solution Verified" to change the flair to 'Solved' and award the user a ClippyPoint. You can use this Google Form link to request a shared google sheet be emailed to you that you can use to provide a sample of your issue. Providing a sample of data will make it easier for others to help you. Google's Function List Provide your data! Submissions Submission Guide Wiki Resources Help and support with your functions, formulas, formatting, and Apps Scripts macros in Google Sheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |