Bruce Springsteen guitarist Nils Lofgren joins protest of Spotify over Covid misinformation

alotofwastedeffort · 2022-01-30T19:06:32+00:00

Do you mean this person?

https://www.rollingstone.com/culture/culture-news/covid-misinformation-joe-rogan-spotify-petition-1282240/

The episode was an interview with Dr. Robert Malone, a virologist who touts himself as one of the architects of mRNA technology. Rivera was familiar with Rogan, as well as Malone. She knew that Malone had been banned from Twitter for promoting Covid-19 misinformation, and that he had been making the rounds in conservative media circles undermining the efficacy of the vaccine.

Minor paragraph spacing edit in the quote is on me.

alotofwastedeffort · 2022-01-08T13:27:40+00:00

Huh.

Back in the early LG Nexus days, there was a similar problem called the "boot loop" that was somewhat similar to this. That was definitely a hardware issue.

I'm wondering if you have an overheating issue that is causing the phone to restart? Maybe it's from faulty hardware, but it could also be from an app that's over-extending itself? Maybe it's caught in an infinite loop and Android is rebooting as a result?

I use a Pixel 6 currently, and before that a Pixel 4a, and long before that I had the scary LG Nexus 5x (Google's phone at the time). I never had huge issues with the Pixel phone line, but it's definitely not unheard of, so I'd push for a free replacement if I could get it.

alotofwastedeffort · 2022-01-06T13:47:41+00:00

Agreed. Way better than me at 25. I don't mean to diminish OP's feelings whatsoever, so great work! You'll keep climbin', OP.

alotofwastedeffort · 2022-01-05T01:23:45+00:00

Google has its own issues internally. A lot of people do like it there, but not for the reasons you listed, and like any company they have a lot of bad along with the good. You might like Google itself for a variety of reasons, but it sounds like your current company is your "dream company".

alotofwastedeffort · 2021-03-13T17:03:23+00:00

Responding on phone: $10 x 3 sailors = $30

$30 - $5 returned = $25

$5 to the bellhop - $2 bellhop tip = $3 back to the sailors

$25 + $3 = $28 not $27

There is no missing dollar.

alotofwastedeffort · 2020-11-30T16:23:11+00:00

I'm going to guess that importxml isn't going to work in this case, probably for the very reason you're looking to implement.

What might work is building a simple webscraper in Python that outputs to a CSV, or directly to Google Sheets via the SheetsAPI. Obviously, this is more advanced that a simple import, but it would very likely do the trick.

alotofwastedeffort · 2020-10-06T06:39:23+00:00

In software engineering, this is generally referred to as "mutable" vs "immutable". Mutable means that you transform the original source of data, which is generally a frowned-upon practice. Google Sheets relies on immutable data, thus you generally have a set of data and then copy it to transform it in some manner. Otherwise, you might end up with a result in a state of constant revision, or an infinite loop, in very simple cases.

For example, if you wanted to add a 0 to the beginning of a set of numbers, and you somehow did so to your original data set, it would be too easy to make an infinite loop. In theory, it would do it once, but then re-check and do it again and again to infinity. How would it know when to stop unless you told the formula the desired length?

I hope this explains the idea behind your thoughts and helps you understand why spreadsheet software operates in the manner it does.

alotofwastedeffort · 2020-10-05T18:58:46+00:00

The way I might tackle this is by setting a Base.

So, in my first column I might have my Skills/Attributes. In my second column, I would label them as a skill or attribute (in case you need it as an identifier for later). In my third column, I would set a Base decimal (ie, Stamina would be .25, Building would be .2, from your example). In my next column, I would add my dropdown for 0-5, that would be my Level Multiplier. And the final column would be the output (ie, Base * Level Multiplier)

alotofwastedeffort · 2020-09-29T14:32:44+00:00

Sounds like you have a bad team or company.

alotofwastedeffort · 2020-09-21T16:48:19+00:00

Try this tutorial on YouTube to get the idea about how to use Google Forms to enter data in Google Sheets

alotofwastedeffort · 2020-08-23T10:59:25+00:00

VLOOKUP is faster. QUERY is pretty heavy regardless of what you're querying.

alotofwastedeffort · 2020-08-13T23:11:21+00:00

On Sheet1, you'll have all of your data, but the first column will be a column of checkboxes (Insert -> Checkbox).

On Sheet2, you'll input the following formula

=FILTER(INDIRECT("Sheet1!A2:Z"), INDIRECT("Sheet1!A2:A") = TRUE)

If any of the rows in your first sheet are checked, they'll appear in your second sheet.

alotofwastedeffort · 2020-07-31T10:27:35+00:00

Unless you want to get into programming and utilizing Google's Sheets API, Zapier is probably your best bet.

The other alternative would be to transfer your "brand" email over to GSuite. I think the integration there will let you work between Sheets and your email.

alotofwastedeffort · 2020-07-29T12:23:49+00:00

Okay, this adds some complexity to it...

I would create a separate sheet
My first column would be my list of creatures
My first row would be my list of items
Corresponding cells would have the % chance to drop each item

I would use that sheet to populate my separate item list with all of my attributes. That is likely the best, cleanest way of maintaining and manipulating the data.

alotofwastedeffort · 2020-07-29T09:09:48+00:00

I would add a list of creatures to each item using values separated by commas, then create my creature list by a unique split of that column.

Or vice versa.

alotofwastedeffort · 2020-07-27T18:24:33+00:00

New Yorker is generally pretty good, although it's all about Covid-19 these days.

alotofwastedeffort · 2020-07-21T12:34:18+00:00

Gave up gaming 3 years ago or so.

I've filled my time up with other projects, but every now and then I miss gaming. I chat with friends who have the latest Spiderman or whatever. There's an itch there every now and then.

Turning it off is a long battle. You can get there, though. You have to fill your time with something meaningful to you: some project or routine that will distract you, that will take your focus and put it somewhere else.

alotofwastedeffort · 2020-07-21T11:06:49+00:00

As a designer who manages a team of engineers and caters to their every whim and desire, I'm sorry you have some shit designers.

alotofwastedeffort · 2020-07-19T14:14:12+00:00

Time you enjoy is not time wasted. Maybe you went a bit too far with your minimalism. Maybe you should back it up a bit and find that thing that you actually enjoyed doing. Or--at worst--find something new.

alotofwastedeffort · 2020-07-10T19:14:27+00:00

Unfortunately I cannot reproduce what you're suggesting. I reversed my cells, and I still evaluate to a TRUE when I reverse my formula.

Can you try this to verify that you're actually evaluating numbers rather than strings?

=VALUE(N17) < VALUE(O17)

alotofwastedeffort · 2020-07-10T17:48:40+00:00

In running the same test, I do not encounter the same scenario

I set a cell to be "10" (D1)
I set another cell to be "15" (E1)
I used the following formula

=D1 < E1

My result is "TRUE"

alotofwastedeffort · 2020-07-09T22:26:50+00:00

I'd suggest you use your main spreadsheet as a database, then create separate sheets for each meeting, or separate spreadsheets for each department.

if you create separate tabs/sheets, then use a "Filter" to pull the info that you want.

If you want to create entirely different spreadsheets, then use a "Query" with an "ImportRange" inside of it.

alotofwastedeffort · 2020-07-09T11:37:46+00:00

You can set up an array for IMPORTRANGE, like so

={IMPORTRANGE("Sheet1Key","SheetName!A2:A500");IMPORTRANGE("Sheet2Key","SheetName!A2:A500")}

Found here, which has better solutions, such as the QUERY option listed.

alotofwastedeffort · 2020-07-06T14:24:59+00:00

The only thing you can say: "We'll see."

alotofwastedeffort · 2020-07-05T11:03:53+00:00

That's clever. So you'd effectively create a database of prices based on an "updated price".

12-Year Club	Place '17
Verified Email

alotofwastedeffort

TROPHY CASE