Maybe someday this can be relocated to an add-on or reworked, but that's not something I plan to review in the immediate future. This can make things like the Configuration page harder because all those inputs are restricted by length. In most cases, the UI elements in sheets have to be bound to a certain range. 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! 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. Google docs budget spreadsheet excel template. 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. Maintaining budget sheet is crucial for long-term financial planning & management. 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.
Beyond basic function uses and technical knowledge, these are some of the standout things I've learned.
0 kommentar(er)
