5 ms·
I use it as a great way to share data from ad-hoc queries, and often times can drive a quick workflow without having to build out a full set of screens in our l
by bdcravens 6y ago
I use it as a great way to share data from ad-hoc queries, and often times can drive a quick workflow without having to build out a full set of screens in our line of business app.
On a personal level, despite many attempts to find a perfect app, my relatively simple set of budgeting spreadsheets is still the best solution I've ever come up with.
Not Google Sheets, but the president of our company has been able to build out a new line of business app using Excel in a few weeks, something that would have taken use several months or more using our traditional development approaches (it will eventually be moved there for robustness, but using spreadsheets as a prototyping tool and letting those who understand the business hammer out the logic, before handing off to developers, is a great approach. A working spreadsheet is definitely the best requirements doc in the world)
- nickgervasi 6y ago"I use it as a great way to share data from ad-hoc queries" So you run some database queries, copy/paste the results in Google Sheets, then share them with other folks on the team? What do they do with the data? How often are you generating these query results? "A working spreadsheet is definitely the best requirements doc in the world" +1. I had a summer job in high school writing small programs for a local business, one of which was a tool to manage their workplace injury claims. Previously they were calculating everything in Excel, so translating that into a VB6 app was really straight forward.
- yen223 6y agoI use Google Sheets to share ad-hoc queries with other people too. Fun tip for those who use Postgres: psql has a command `\copy` that allows you to write the results of a query out into a local (clientside) CSV file. From there, it's pretty straightforward to import that into a Google Sheet.
- bdcravens 6y agoYeah, I use Datagrip, which lets you easily copy a query's results to TSV data in the clipboard, so you can't quickly paste into Google Sheets.
- jkaptur 6y ago> using spreadsheets as a prototyping tool and letting those who understand the business hammer out the logic, before handing off to developers, is a great approach. A working spreadsheet is definitely the best requirements doc in the world Just FYI, that approach definitely hasn't been my experience. A spreadsheet at a moment in time doesn't encapsulate users' true requirements (and they won't tell you what their real requirements are when you ask). My story: I built a more "robust" version of the spreadsheet, with a normalized database schema, the very hottest UI framework, etc., and exactly the same logic. Some of this got pretty complex, of course: copying and pasting a bunch of cells is easy on a spreadsheet, but a hassle to build in a custom app. So it took some time. I came back and showed the app to the users and found that the spreadsheet had actually changed quite a bit. Columns had been added for a new team, the widget approval process had sprouted some manual overrides, and more (the lack of an effective spreadsheet diff tool or change management prevented me from knowing the complete story). I went off again, updated the app for the new process, came back to a changed spreadsheet, etc. We iterated for quite a while before the developers and the business gave up in frustration. The breaking point was when we were asked to add a calculation engine to the app so that users could add columns of cells with new formulas. (That's when I decided to leave that job and go help build a better spreadsheet). Spreadsheets don't feel robust to developers, but business people do not feel that pain. If robustness is the main selling point of the replacement, I'd make sure that business users are screaming for robustness. I'd want dollar-signed disasters that were the result of too much flexibility.
- brittpart_ 6y agothere's a lot of good personal finance apps out there, mint?
- bdcravens 6y agoLike I said, I've tried a lot of them. They're all good apps, but none seemed to fit the way I like to plan and track what's going on.
- brittpart_ 6y agohow do you do it that's so different?