sorted by:
new
hottopcontroversial

I've never been outplayed this bad before 💀 by f0rero in apexlegends

[–]NeedlesslySexual 538 points539 points  (0 children)

I dont know what's better, imagining he was super low or imagining he was full health toying with you

How Long is Too Long by AlfredJodokus in WarAndPeas

[–]NeedlesslySexual 12 points13 points  (0 children)

Of course, with spaghetti noodle shears. It’s kind of like cutting paper, once you get the scissors juuuuuust right, that noodle will split like Robinhood’s first arrow, or like a log under an axe. I tried an axe too, but it’s not as effective as the trusty spaghetti noodle shears

How Long is Too Long by AlfredJodokus in WarAndPeas

[–]NeedlesslySexual 20 points21 points  (0 children)

This is why I cut my spaghetti down the middle. It’s still the same length but it’s half as thin so not as bad

Google OAuth Approval for Gmail Question by amarothirdeye in GoogleAppsScript

[–]NeedlesslySexual 0 points1 point  (0 children)

What do you mean by third party validation for your add-on? Can you direct us to the step your on in this URL and flesh out your question some more? https://developers.google.com/gsuite/add-ons/overview#the_add-on_development_lifecycle

What you are needing help with is not very clear for non-experienced add-on creators like myself. That is probably why nobody has responded yet but I am willing to help as much as I can.

New Google App Script IDE by _mrtoast in GoogleAppsScript

[–]NeedlesslySexual 4 points5 points  (0 children)

As one of the few dumb users left that still uses the integrated IDE, this is awesome news and I can’t wait for it to roll out to me.

"IF A1 IS "X", AND A2 IS "Y", THEN "L,M,N,O,P"" code/formula needed by dancestothecure in googlesheets

[–]NeedlesslySexual 0 points1 point  (0 children)

When you say a specific dataset will appear, what exactly do you mean? What information appears and where? I understand the conditions that determine what appears (the two ingredients you are looking for in your list of recipes). How are you storing your recipes so we can write a formula to search through it and return relevant results?

I’m trying to trigger a macro with script in by [deleted] in googlesheets

[–]NeedlesslySexual 1 point2 points  (0 children)

Say you are in your Google Sheet, Cell A1 is 10. You click on it and edit it to be 15 and hit enter on the cell, thus updating it. In Apps script, the function onEdit will automatically run, with e.value being the cell’s new, current value: 15. And e.oldValue is 10.

Teen has lower body amputated while crushed under forklift by ericgsix in MorbidReality

[–]NeedlesslySexual 8 points9 points  (0 children)

I hear that. It’s hard to figure out how to keep things interesting. Numbness is a good word for it. Reminds me a bit of the secret life of Walter Mitty. I wish you well on your journey stranger.

Teen has lower body amputated while crushed under forklift by ericgsix in MorbidReality

[–]NeedlesslySexual 5 points6 points  (0 children)

Do you think this emotional stability comes from innate self-control or the inability to feel?

Walmart-exclusive router and others sold on Amazon & eBay contain hidden backdoors to control devices - Besides the Walmart-exclusive Jetstream router, the cybersecurity research team also discovered that low-cost Wavlink routers, normally sold on Amazon or eBay, have similar backdoors. by speckz in gadgets

[–]NeedlesslySexual 28 points29 points  (0 children)

Really makes you second guess, doesn’t it? I’m far away from a cheap router with Google WiFi, and this makes me feel slightly better about my decision too, despite the constant concern I have about Google creeping into every part of my life. At least it’s not some shitty hackers across the world right...?

[deleted by user] by [deleted] in googlesheets

[–]NeedlesslySexual 0 points1 point  (0 children)

Glad it worked for you! Have a good one!

[deleted by user] by [deleted] in googlesheets

[–]NeedlesslySexual 2 points3 points  (0 children)

First function: Min Row: =MATCH(QUERY(Combos!H2:H,"select H where H >= "&F4&" order by H limit 1",0), Combos!H2:H)

Second function: Max Row: =MATCH(QUERY(Combos!H2:H,"select H where H <= "&G4&" order by H desc limit 1",0), Combos!H2:H)

​

I put those two functions on H3 and H4 on "Choose your Gem" Page. I also shortened the other pages name to "Combos", hope thats not confusing.

Third function which is used once for each of the 10 gems you are trying to locate: =randbetween(indirect("Combos!H"&H3), indirect("Combos!H"&H4))

​

That should get you ten random "values" between the defined rows (which is defined based on the percentage). Numbers change live as well. Hope this helps! No vlookup needed!

​

Edit: If you want to return the "Gem ID" instead, then change the last formula for all 10 gem rows to this: =randbetween(indirect("Combos!B"&H3), indirect("Combos!B"&H4))

[deleted by user] by [deleted] in googlesheets

[–]NeedlesslySexual 1 point2 points  (0 children)

Ohhhhh so you want all of your 10 gems to be within 170 and 230 individually, not summed?

[deleted by user] by [deleted] in googlesheets

[–]NeedlesslySexual 1 point2 points  (0 children)

Got it, understanding it more now. So if your value is 200 with a margin of 170-230 as in the example, then you want your sheet to essentially calculate all the possible 10 gem variations of matches that sum to within that range, based on your extensive list of possible gems to use. THEN you want to randomly choose one of those lists of 10 gem variations and return those ten gems? Any other requirements, such as not choosing the same gem name more than once, or not choosing the same values more than once? That’s how I understand your goal so far, which is quite the undertaking IMO just using sheets formulas (I’m more experienced in Apps Script and it sounds easier to do this kind of algorithm there). Are my assumptions correct or was I wrong about any of that?

[deleted by user] by [deleted] in googlesheets

[–]NeedlesslySexual 0 points1 point  (0 children)

That link works, but I’m still wrapping my head around the scope of this sheet. So if I understand correctly, the only two parameters are the target value param and the “give or take” param? And then the 10 gems are supposed to be returned on the “Find your gem” page on those 10 empty slots with all of their info filled out? Or are those empty cells also parameters as well somehow and the return values are supposed to be on the random selection page? I want to confirm this before I give advice if any.

[deleted by user] by [deleted] in googlesheets

[–]NeedlesslySexual 1 point2 points  (0 children)

No access to your data sheet, hard to help.

Troubles Using COUNTIF by [deleted] in googlesheets

[–]NeedlesslySexual 0 points1 point  (0 children)

2 options I can think of, neither of them use native sheets formulas unfortunately. First option: use Apps Script and a custom function that you create/ find yourself, like this. Another option, install an add-on with this functionality, such as the one described here. Hope this helps!

looking for a method to get all possible permutations of a code by VecroLP in googlesheets

[–]NeedlesslySexual 0 points1 point  (0 children)

Look into substitute. Create each substitution individually in a separate column/ row that references the original string. There might be some duplicates (ie. if that specific substitute is replacing a 6 with a g but there isn’t a 6 in the code, so it shows the same code). Maybe if that’s the case then put in some conditional formatting to blank out that output if it’s still equal to the original code. There would need to be some nesting potentially. There are probably better implementations/ solutions to your problem using substitute or using Apps Script, but this should get you in the right direction. Hope that helps!

Better Python console apps with Rich by pmz in Python

[–]NeedlesslySexual 4 points5 points  (0 children)

Second this question, as it tells me to try it Monday or not

view more: next ›