3 ms·
I hope Microsoft gives you a ton of money and hires you to make Excel like this. VBA is so crap. And this looks amazing.
by gigatexal 9y ago
I hope Microsoft gives you a ton of money and hires you to make Excel like this. VBA is so crap. And this looks amazing.
- ThirdFoundation 9y agoYea, reading his description of the Excel data problems his girlfriend had hit very close to home. A large swath of my current job responsibilities often involve automating these type of data aggregations so that non-technical users can do them. Often, this leads me to coding the entire task in VBA so that they can do it with the push of a button within the workbook they are using. At this point I have entire libraries that I have made which I routinely use to accomplish this, but it always feels so dirty and inefficient (see: VBA). In my experience, non-technical users don't want an outside application. They don't want to set up a database. They just want to open Excel, the program they are comfortable with, hit a button, and have their data aggregated. This tool is really cool.
- xeonoex 9y agoI hope so too. I've used QueryStorm for a year or so. I try to avoid Excel as much as possible, but when I have to use it, I can spend 4 hour learning the Excel/VBA way to do something, or 1 minute and write it in SQL. It doesn't make sense how this isn't in Excel already. Seriously. Try to do a join and some simple data manipulation/aggregation in Excel without this. Or try to emulate SQL minus/except. You'll Google for simple answers using the UI, and those probably don't even solve your exact problem, then dig until you find some that seem correct, try to implement them, and then realizes it doesn't work for some unknown reason. Then either give in and write VBA to do it (which also sucks), or pull it out of Excel and put in something that uses a good language.
- anakic 9y agoThanks for writing this!