31–40 of 112 posts
does anyone know how this kind of stuff gets built ? I'm considering a spreadsheet-y internal admin dashboard for my startup. I was looking at https://github.com/JoshData/jot to be able to sync stuff on the client side to the server. has anyone worked on something like this ? the big challenge is synchronization - between server and multiple clients - while being able to offload a lot of computations on to the client…
When I worked for SAP back in 2007 (I was a fresh grad at the time), I was working in the business intelligence (reporting, analytics, and data warehousing) group and noticed how cumbersome it was for organizations to simply create and view reports (we're talking millions of dollars). I once said to my boss "you realize that in the future we'll simply just write 'show me a line graph for sales in the northeast'". And…
How about we just 'say' it ? At one hackathon, I had the idea of making an Alexa skill that would translate simple voice commands like 'graph column A' into matplotlib functions and then show the graphs. Teammates weren't too excited about spreadsheets though.
I'm wondering how Microsoft is responding to this. Do they expect their current Excel dominance to continue despite competitors constantly catching up to feature parity and even extra goodies, like this one?
When I worked for SAP back in 2007 (I was a fresh grad at the time), I was working in the business intelligence (reporting, analytics, and data warehousing) group and noticed how cumbersome it was for organizations to simply create and view reports (we're talking millions of dollars). I once said to my boss "you realize that in the future we'll simply just write 'show me a line graph for sales in the northeast'". And…
But the best, still-mostly-hidden feature I've found recently is App Scripting and especially the ability to do a UrlFetch.
I use it as an "API Runner" to run various batch jobs against APIs.
https://developers.google.com/apps-script/reference/url-fetc...
I don't understand the example, what's the difference between typing "Show me a line graph" and clicking a button in excel that does the same thing.
Earlier quoted context omitted.
The big challenge is implementing the spreadsheet UI.
There's a React component for that. React-datasheet or something like that.
We use HOT, but have been considering aggrid. Because of these tools, that's not the hard part any more..It's the synchronization and computation logic.
Oh, wow. I love where this is headed. Spreadsheets are one of the most abused products in a normal business--used for everything , and then some poor excel jockey ends up being forced to create a semblance of order from the chaos.
Someone needs to create Spreadsheets Anonymous and share the crazy stuff people do in Excel, the best one I've seen is a full GUI wizard (back, next etc.) in VBA.
I'm wondering how Microsoft is responding to this. Do they expect their current Excel dominance to continue despite competitors constantly catching up to feature parity and even extra goodies, like this one?
It's fairly trivial to get this to work with well-formatted data.
I'm currently evaluating BI solutions for my company and just about every single one has something like this.