In need of expertise: Google Sheets

The war between wetware and hardware.
User avatar
Rob Lister
Posts: 22732
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
Abdul Alhazred
Posts: 83938
Joined: Mon Jun 07, 2004 1:33 pm
Title: Yes, that one.
Location: Chicago

Re: In need of expertise: Google Sheets

Post by Abdul Alhazred »

Best bet: Do your spreadsheet in Open Office and then import it to Google, but only if there's really really a good reason for it to be there.
Image "If I turn in a sicko, will I get a reward?"

"Yes! A BIG REWARD!" ====> Click here to turn in a sicko
The arc of the moral universe bends towards chaos.
People who believe God or History are on their side provide the chaos.

User avatar
Rob Lister
Posts: 22732
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
Abdul Alhazred
Posts: 83938
Joined: Mon Jun 07, 2004 1:33 pm
Title: Yes, that one.
Location: Chicago

Re: In need of expertise: Google Sheets

Post by Abdul Alhazred »

Hey smart guy! :p

You wanted "helpful" but you posted here. :lmao:
Image "If I turn in a sicko, will I get a reward?"

"Yes! A BIG REWARD!" ====> Click here to turn in a sicko
The arc of the moral universe bends towards chaos.
People who believe God or History are on their side provide the chaos.

User avatar
Witness
Posts: 28501
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: 22732
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: 28501
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 pm
I 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: 22732
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 pm
I 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
Abdul Alhazred
Posts: 83938
Joined: Mon Jun 07, 2004 1:33 pm
Title: Yes, that one.
Location: Chicago

Re: In need of expertise: Google Sheets

Post by Abdul Alhazred »

Abdul Alhazred wrote:
Tue Feb 25, 2020 1:54 pm
Best bet: Do your spreadsheet in Open Office and then import it to Google, but only if there's really really a good reason for it to be there.
I amend this advice to note that if you're the kind of sap who paid for Microsoft Excel, that product will do instead of Open Office.

But you aren't that kind of sap, are you Lister? :8b:
Image "If I turn in a sicko, will I get a reward?"

"Yes! A BIG REWARD!" ====> Click here to turn in a sicko
The arc of the moral universe bends towards chaos.
People who believe God or History are on their side provide the chaos.

User avatar
Rob Lister
Posts: 22732
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
Abdul Alhazred
Posts: 83938
Joined: Mon Jun 07, 2004 1:33 pm
Title: Yes, that one.
Location: Chicago

Re: In need of expertise: Google Sheets

Post by Abdul Alhazred »

If your boss adopts MS Office, you just go with the flow. Especially if your boss is the government. I get that.

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.
Image "If I turn in a sicko, will I get a reward?"

"Yes! A BIG REWARD!" ====> Click here to turn in a sicko
The arc of the moral universe bends towards chaos.
People who believe God or History are on their side provide the chaos.

User avatar
Rob Lister
Posts: 22732
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
Abdul Alhazred
Posts: 83938
Joined: Mon Jun 07, 2004 1:33 pm
Title: Yes, that one.
Location: Chicago

Re: In need of expertise: Google Sheets

Post by Abdul Alhazred »

Rob Lister wrote:
Thu Feb 27, 2020 2:41 pm
Were you abused as a child? I find it incomprehensible either of your parents could resist beating your ass on a regular basis.
Gotta admit that's a good burn. :lmao:

Original, or from some TV I don't watch? :P
Image "If I turn in a sicko, will I get a reward?"

"Yes! A BIG REWARD!" ====> Click here to turn in a sicko
The arc of the moral universe bends towards chaos.
People who believe God or History are on their side provide the chaos.

User avatar
Rob Lister
Posts: 22732
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: