In need of expertise: Google Sheets

The war between wetware and hardware.
User avatar
Rob Lister
Posts: 23526
Joined: Sun Jul 18, 2004 7:15 pm
Title: Incipient toppler
Location: Swimming in Lake Ed

In need of expertise: Google Sheets

Post by Rob Lister »

Is anyone here have more than a passing familiarity with Google Sheets, or other spreadsheet software?

Background: Back in my younger days I worked for a government contractor as a technical writer for a enterprise software development project they led. As the only 'non-programmer' in the group, they put me in charge of getting, spending, and otherwise tracking the money; most of my time was spent washing the color off money we absconded from other related contracts to keep the team paid and to feed our hardware needs*. I had no experience in such matters but I was the only sane person there so ... I got 'picked'. I used MS Excel pretty heavily but I've never found much use in it since; I've pretty much forgotten utterly how to use it.

I posted some charts here in another thread that I created in Google Sheets but it's more kludge than proper architecture. I was only tracking three variables over time and I made it work in spite of my incompetence.

I'd like to track a few more variables for other charting but I'm a bit clueless on the best way to build my data-sets, much less chart them. Google support docs only seem to work for people that don't need them; it's very ... compendious, for lack of a better word. Stack exchange appears to appeal only to people that hate other people, and even getting a question posted means jumping through numerous 'mother-may-I' hoops.

PM me if you're one with a clue'. I'll try not to take up too much of your time.





* Never get in bed with Oracle. Of course, if you don't you have to get in bed with Microsoft. But if you do get in bed with Oracle, don't use their consultants. But if you must use their consultants, just pack up your bags and leave because they'll drain you of all your discretionary funds and not accomplish jack shit. No, we can't afford second monitors or a new server because you insisted that getting help from Oracle on the data migration would save us money in the long run.
Last edited by Rob Lister on Tue Feb 25, 2020 2:07 pm, edited 3 times in total.
User avatar
Rob Lister
Posts: 23526
Joined: Sun Jul 18, 2004 7:15 pm
Title: Incipient toppler
Location: Swimming in Lake Ed

Re: In need of expertise: Google Sheets

Post by Rob Lister »

So you're sayin' learn a third platform from scratch in order to [imperfectly] import into a second platform I can at least kludge. :lol: :x

Yea, that'll work.
User avatar
Witness
Posts: 34372
Joined: Thu Sep 19, 2013 5:50 pm

Re: In need of expertise: Google Sheets

Post by Witness »

What do you mean by "tracking" data? Sources on the Net changing with time?
User avatar
Rob Lister
Posts: 23526
Joined: Sun Jul 18, 2004 7:15 pm
Title: Incipient toppler
Location: Swimming in Lake Ed

Re: In need of expertise: Google Sheets

Post by Rob Lister »

???
User avatar
Witness
Posts: 34372
Joined: Thu Sep 19, 2013 5:50 pm

Re: In need of expertise: Google Sheets

Post by Witness »

Rob Lister wrote: Tue Feb 25, 2020 1:49 pmI was only tracking three variables over time

I'd like to track a few more variables for other charting
Best is you give us a toy example of data & what you want to do with it.
User avatar
Rob Lister
Posts: 23526
Joined: Sun Jul 18, 2004 7:15 pm
Title: Incipient toppler
Location: Swimming in Lake Ed

Re: In need of expertise: Google Sheets

Post by Rob Lister »

Witness wrote: Thu Feb 27, 2020 2:28 am
Rob Lister wrote: Tue Feb 25, 2020 1:49 pmI was only tracking three variables over time

I'd like to track a few more variables for other charting
Best is you give us a toy example of data & what you want to do with it.
That's like ... public school. Do you want me to pray too? Are you going to paddle me if I don't learn right? Can I smoke in the boys bathroom?

Fuck that, I have a tutor.
User avatar
Rob Lister
Posts: 23526
Joined: Sun Jul 18, 2004 7:15 pm
Title: Incipient toppler
Location: Swimming in Lake Ed

Re: In need of expertise: Google Sheets

Post by Rob Lister »

I've used MS Office products since Word was officially adopted by Naval Training Command halfway through my first Navy Instructor tour, mid-'90's or so. I've also used other suits like Perfect Writer, Corel, Open Office, Word Perfect, etc.

While sometimes clunky and riddled with Gateisms, MS products vary from being at least as good as to far more betterstlyer than its competitors; everything is tweekable, even if sometimes weirdly and illogically so.

So while there is some love/hate relationship issues, MS easily the cleanest whore out there. The one exception is IE and one really can't call that an Office product.

Besides, nobody ever got fired for choosing M$.

So yea, I think they're swell. I just don't do enough writing or development to justify its cost.

OTOH, in terms of 'clean' (and you can't beat free), I think Google products are superior. Google suffers from some degree of untweekableness, but it is generally very easy to use, globally available through the Chrome interface, and I personally like Sundar looking over my shoulder to read my oh.so.private writings.

Image

So yea, I am that kind of sap.
User avatar
Rob Lister
Posts: 23526
Joined: Sun Jul 18, 2004 7:15 pm
Title: Incipient toppler
Location: Swimming in Lake Ed

Re: In need of expertise: Google Sheets

Post by Rob Lister »

Abdul Alhazred wrote: Thu Feb 27, 2020 2:28 pm If your boss adopts MS Office, you just go with the flow. Especially if your boss is the government. I get that.
I think you just like to argue. I'm cool with that. It's also a little telling that every boss I've ever had, with the exception of one, has mandated the use of MS. The one that didn't is long out-of-business (though not for that reason, necessarily).
pooh-head wrote:But if you pay for it yourself for home use, you're a sap. And if you pirate it (especially when Open Office is free), you are a schmuck.
This coming from the guy that still uses Netscape.

Were you abused as a child? I find it incomprehensible either of your parents could resist beating your ass on a regular basis.

So I hear you, Abdul, now leave me alone. Don't make me stop this car.
User avatar
Rob Lister
Posts: 23526
Joined: Sun Jul 18, 2004 7:15 pm
Title: Incipient toppler
Location: Swimming in Lake Ed

Re: In need of expertise: Google Sheets

Post by Rob Lister »

:rub:
Spoiler:
:De_Bunk: