Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Visualize data instantly with machine learning in Google Sheets

blog.google

Post reply on HN
Print view View original

61–70 of 112 posts

Re: Visualize data instantly with machine learning in Google Sheets

#61

Post by fiatjaf »

TomMarius wrote: post #23
fiatjaf wrote: post #19

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.

I know there's a React component. There are many. They don't come even closer to the functionalities of an actual Excel-like spreadsheet.

Implementing 70% of the most basic of all functionality of Excel is easy. Implementing 90% is insanely difficulty.

I would say Handsontable reaches the mark of 78%.

I've tried twice, one with React + Mori[0] and one in Cyclejs[1]. In the first I may have reached 82%, in the second probably 85%. But in both cases the latest features I added started to conflict with the oldest ones and I abandoned everything.

[0]: https://github.com/fiatjaf/react-microspreadsheet [1]: http://sheets.alhur.es/

Re: Visualize data instantly with machine learning in Google Sheets

#62

Post by teej »

Can we talk about getting data into Google Sheets? Is there a standard way to build a pipe from, say, a reporting database to dump aggregates into Google Sheets?

I built a private Add-on for my company that surfaces specific aggregates as Sheets functions (i.e. getSalesByDay(...)) and I have found so many bugs with that whole ecosystem. Deploys are completely manual and require copy-paste, you can't reliably tell what version is being invoked in a sheet, invisible cell-level caching that caches error state, concurrency limits that are too low and impossible to work around, and more. It all kinda sorta works but Google doesn't make it easy.

Re: Visualize data instantly with machine learning in Google Sheets

#63

Post by jboggan »

teej wrote: post #62

Can we talk about getting data into Google Sheets? Is there a standard way to build a pipe from, say, a reporting database to dump aggregates into Google Sheets? I built a private Add-on for my company that surfaces specific aggregates as Sheets functions (i.e. getSalesByDay(...)) and I have found so many bugs with that whole ecosystem. Deploys are completely manual and require copy-paste, you can't reliably tell wha…

I never had a problem with the Sheets V4 API that came out last May, how big of a database are you talking here?

Re: Visualize data instantly with machine learning in Google Sheets

#64

Post by teej »

jboggan wrote: post #63
teej wrote: post #62

Can we talk about getting data into Google Sheets? Is there a standard way to build a pipe from, say, a reporting database to dump aggregates into Google Sheets? I built a private Add-on for my company that surfaces specific aggregates as Sheets functions (i.e. getSalesByDay(...)) and I have found so many bugs with that whole ecosystem. Deploys are completely manual and require copy-paste, you can't reliably tell wha…

I never had a problem with the Sheets V4 API that came out last May, how big of a database are you talking here?

The add on doesn't talk to the reporting database directly, Google's Apps Script JDBC service doesn't support Postgres/Redshift. The add on gets data from a REST API. I then have an etl job that precalculates the aggregates and stashes them in Redis that the API then reads from.

Re: Visualize data instantly with machine learning in Google Sheets

#66

Post by vgt »

Mandatory shameless plug - Google Sheets integrates with Google BigQuery.

You can:

- Query data in Google Sheets from BigQuery

- Create virtual views in BigQuery that are powered by Google Sheets

- One-click export data from BigQuery to Google Sheets (- Using AppScript, build dashboards and reports in Sheets that query BigQuery for results.

(work at G)

Re: Visualize data instantly with machine learning in Google Sheets

#67

Post by Spooky23 »

oaktowner wrote: post #20
cube00 wrote: post #6

Earlier quoted context omitted.

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 once worked at a large company (70K employees) in which the check request software (that is, if you needed to pay a vendor with a written check) was written in VBA embedded in Excel, using Outlook (the client, not Exchange) as Workflow. You opened the "spreadsheet", which hid Excel itself and showed a form. You filled it out, clicked Send and it used your local Outlook client to email a copy of itself to your boss,…

In the late 90s I worked for a company that ran their manufacturing logistics using Lotus Notes.

An excel form / outlook workflow would have been an improvement.

Re: Visualize data instantly with machine learning in Google Sheets

#68

Post by Spooky23 »

darwhy wrote: post #30

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?

You don't shop for Excel, you shop for Office. The contracts around O365 are pretty onerous to get out of if you're an EA customer, and the process of going away is full of pitfalls and surprises.

Google used to say that everyone who did an RFP chose Google Apps/GSuite. The problem is that nobody does that!

Re: Visualize data instantly with machine learning in Google Sheets

#69

Post by aeorgnoieang »

gsvclass wrote: post #55

There's a lot of basic stuff like column titles, moving columns about, filtering, search that I found had a quite a learning curve with sheets. I built and use this instead. Bell+Cat https://bellpluscat.com

I love your "Made with and ️ on the 3rd rock from the sun." tag.

Re: Visualize data instantly with machine learning in Google Sheets

#70

Post by reitanqild »

hacker_9 wrote: post #56
reitanqild wrote: post #44

Earlier quoted context omitted.

Wouldn't that make "mechanical keyboards for everyone in the open floorplan" seem like a smart decision?

Just need to bypass the mouth and jack-in directly to the speech center in the brain.

At that point it would be tempting to bypass the screen, the eyes and the brain as well ;-)
Post reply on HN