Google sheets

We have been using Google sheets a fair bit recently as our spreadsheet of choice. The kids can use their phones for data gathering in the field (eg how many keepy uppyies they do) and then we can fire up the tomputers and do some proper data analysis on it. Again using Google sheets.

This has worked well for trivial stuff but the other day I decided to combine Maths, IT and spreadsheets and it didn’t end well.

In maths we have been doing equations, in IT, programming – so name a couple of variables x and y, create a scary looking equation, loop through a load of numbers and print out x and y, copy and paste into Google sheets and draw a nice chart. Well that’s what happened on the macbook, on the Android tablet the Google sheets app appears so completely hobbled that it does not offer the choice to parse a string into multiple columns. And I could find no way to use the more powerful browser version.

I wouldn’t claim to have done an exhaustive search but initial indications are that the app versions of google apps offer only a fraction of the features of the browser versions (bit weird if you ask me – but hey, I’m old school). And you can’t seem to keep the browser version on android devices. As soon as you click anywhere you are launched into Google drive and its game over, shit versions only. As far as I can tell??

If anyone has a solution to this I would be very interested. I would like to use the more powerful browser versions of google apps on an android tablet please.

ps the Excel app has the same limitation as far as I can tell.

Or if you have a suggestions for a better spreadsheet for Android I’m all ears…

cheers

simon

Advertisements

4 Responses to “Google sheets”

  1. Patrick O'Beirne, spreadsheet auditor Says:

    If I was looking for advice from someone who has tried several spreadsheet apps for a real application, I’d ask Jerzy Sikora or Jerzy Tyszkiewicz who presented on that at SEMS’16

    http://ieeexplore.ieee.org/abstract/document/7283047/?section=abstract

    Check your mail at Codematic Towers :-)

  2. Simon Says:

    Thanks Patrick

  3. methodsinexcel Says:

    but Simon, 2 people can work on the same document at the same time, just like people have always aked for! …

  4. Simon Says:

    Hi Ross, yes 2 people can do utterly trivial shit at the same time. no one can do anything powerful.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s


%d bloggers like this: