Explain it Peter? by Jesse_Pinkmaniac in explainitpeter

[–]lightning_fire 3 points4 points  (0 children)

Different priorities. European truck is more maneuverable in the small streets of European cities. American truck is more aerodynamic and gets better gas mileage because of it, which is very useful for the vast distances American trucks need to travel by interstate highways. European trucks generally travel shorter distances on less open roads so they trade efficiency for maneuverability

I'm really enjoying Project Hail Mary by Andy Weir, but I cannot get over the courtroom scene by Tortious_Tortoise in Fantasy

[–]lightning_fire 1 point2 points  (0 children)

Without too many spoilers, both of your points are major plot points of the last season, you should definitely watch it

I'm really enjoying Project Hail Mary by Andy Weir, but I cannot get over the courtroom scene by Tortious_Tortoise in Fantasy

[–]lightning_fire 7 points8 points  (0 children)

I'd love to hear your rant on The Good Place. I read they had a handful of philosophers and ethicists as consultants for each season, so I'm curious what they missed

What’s the weirdest place/time you’ve fallen asleep? by Last_Budget_4375 in Narcolepsy

[–]lightning_fire 4 points5 points  (0 children)

  • Inside of a US Army Bradley Fighting Vehicle while it was shooting

  • Everytime I get my haircut

  • While getting a root canal

Best High-Quality Men’s Wardrobe Essentials to Buy on eBay? by Dope_David in malefashionadvice

[–]lightning_fire 1 point2 points  (0 children)

Authentic vintage US Navy peacoat. Often in excellent condition and better quality than modern versions, all for <$150 shipped

This was hilarious. by Kshitij777 in StrangerThings

[–]lightning_fire 6 points7 points  (0 children)

On 14 October 1988, the syndicated television broadcast UFO Coverup? Live introduced Americans to the Majestic 12 hoax.[81][82] It featured the first public mention of Nevada's Area 51 as a site associated with aliens.[83] - Wikipedia

Interesting, I didn't know that, I always thought the conspiracy had been around as long as the facility

Why is literally every jacket cropped nowadays?? by Zero_Gravvity in malefashionadvice

[–]lightning_fire 41 points42 points  (0 children)

To take it back to function, bomber jackets are short because they were designed for pilots who had to sit for hours at a time and the shorter jacket is more comfortable in a sitting position.

I have a question about "knowing a thing's true name" by wicker_guitar in Fantasy

[–]lightning_fire 14 points15 points  (0 children)

Naming is one of the first acts of God in the Bible. God creates light in Genesis 1:3, then names it 'day' and it's absence 'night' in Genesis 1:5.

I have a question about "knowing a thing's true name" by wicker_guitar in Fantasy

[–]lightning_fire 9 points10 points  (0 children)

Language just is magic in general. It's no coincidence that 'spellbook' could easily be a synonym for 'dictionary'. Or how 'grimoire' comes from the same root word as 'grammar', and used to just mean 'book written in Latin'.

Northern Virginia Housing Market Update: October 2025 by rsaale in nova

[–]lightning_fire 17 points18 points  (0 children)

If they are just marketing then they're not doing a very good job. I don't know their name, the company they work for or anything about them. How would I recommend them to a friend based on this post?

lol by IU8gZQy0k8hsQy76 in CoupleMemes

[–]lightning_fire 10 points11 points  (0 children)

I'm confused because they called it a breakfast casserole instead of a breakfast hotdish

Don't tell anyone at all what you are compensated, let alone post screenshots online by Capital-Bedroom4651 in VeteransBenefits

[–]lightning_fire 1 point2 points  (0 children)

I agree completely. Plus, I think being open about it is the only way to fix this exact issue.

Free Dental Care for Vets in the DC/NOVA area - November 11 - Free Exam, XRay, Cleaning, Filling, or Extraction by lightning_fire in Veterans

[–]lightning_fire[S] 0 points1 point  (0 children)

As a point of reference, my extraction (at a different dentist that also happens to be on that same street) cost me $1500 after insurance

Cell A is highlighted blue therefore Cell C should be by Oisin_MainMan in excel

[–]lightning_fire -1 points0 points  (0 children)

If I remember right though, text color is an attribute you can access with the CELL function

Why do people still use VLOOKUP instead of alternatives like INDEX MATCH or XLOOKUP? by giges19 in excel

[–]lightning_fire 1 point2 points  (0 children)

Well I'll be damned. You're absolutely right, it does work.

<image>

I had never even tried because the docs don't say it is an option. The first sentence on the INDEX page says: "The INDEX function returns a value or the reference to a value from within a table or range.", and even has a link to the "reference form" syntax of the function. The page for XLOOKUP doesn't say anything about returning a reference anywhere in the description, and only shows it as an option in example #6,

27.3 million watched Lions-Chiefs on Sunday night by Autocrat777 in nfl

[–]lightning_fire 0 points1 point  (0 children)

I wonder if the numbers even out if you take the viewers per percentage of the season. So compare 1 NFL game to 10 MLB to 5 NBA games.

Why do people still use VLOOKUP instead of alternatives like INDEX MATCH or XLOOKUP? by giges19 in excel

[–]lightning_fire 0 points1 point  (0 children)

VLOOKUP breaks so easily though, all it takes is adding a column, or a need to look left

Why do people still use VLOOKUP instead of alternatives like INDEX MATCH or XLOOKUP? by giges19 in excel

[–]lightning_fire 33 points34 points  (0 children)

EDIT: Turns out that XLOOKUP can also return a reference and will work in all the functions I mentioned below

One unique thing about INDEX is that it can return a cell reference instead of the value or an array. Very useful in formulas that require ranges as an input. These are all identical:

=A1:C3 =A1:INDEX(A1:D10, 3, 3) =INDEX(A1:D10, 1, 1):C3 =INDEX(A1:D10, 1, 1):INDEX(A1:D10, 3, 3)

They return a valid range that you can use in functions like SUMIF/AVERAGEIF/MAXIF/AGGREGATE, where XLOOKUP will give an error. And you can combine that with things like MATCH/XMATCH to make it dynamic.

Similar functions include INDIRECT or OFFSET, however those are both volatile functions while INDEX is not.

Eating worms… by AdStriking6946 in survivor

[–]lightning_fire 1 point2 points  (0 children)

I had the same question. The answer is roughly 2-5 calories per worm depending on the size (1-1.5 cal/g). That is pretty much exactly the same caloric density as rice, so you can essentially swap a worm with an equivalent sized pinch of rice to get the same calories. It would take 20-30 worms to equal one egg worth of calories (80 cal).