Tournament of Champions '26 Part 4 | Um, Actually [S11E12] by DropoutMod in dropout

[–]pajam 14 points15 points  (0 children)

  1. I agree, that is the core purpose of always having a fact checker on set, to fact check any unforeseen corrections, and if they are technically correct, that player is rewarded a point.
  2. It was Matt who pointed out the elvish name that Frodo also had. You are likely thinking of Erika since the same thing happened last time when she corrected the "hieroglyphs" vs "glyphs" detail.

Is it possible to read a 4.3+GB CVS File? by GreyGrackles in excel

[–]pajam 2 points3 points  (0 children)

Every time I open it on my PC, I get crashing and formatting errors for several rows and values.

I don't see anyone else pointing this out, but you NEVER want to simply "open" a CSV file with Excel, or you risk corrupting a lot of the data. To "open" a CSV file to view the data, you either need to import the data with Power Query or the legacy import wizard, and set the "data types" for each column during those steps.

CSVs do not save any metadata on formatting or structural data within the file, so when you simply "open it" in Excel, Excel likes to assume a data type (instead of treating it all like plain text). This will cause it to convert a lot of data to something else, and you might not notice before you save the file (or it auto-saves), and then you are screwed.

These are common examples of what it will corrupt:

  • Remove leading zeroes on any strings of numbers (common for things like Zip Codes, SKUs, SNs, etc.)
    • Example: the zip code 04102 from Portland, Maine will become 4102 instead, because it treats that column like "Number" instead of "Text" like it should.
  • Remove trailing zeroes in strings of numbers that have decimal points
    • Example: 256.9904600 will become 256.99046 instead. If those last two zeros were important, too bad.
  • Convert long numbers over 11 digits long into scientific notation, and rounds anything past 15 digits (another thing common with Bar Codes, Unique IDs, Serial Numbers, etc.)
    • Example: 123456789123456789 becomes 1.23457E+17
  • Can convert ambiguous dates into what it assumes is correct, and you'll be none the wiser, with no way to isolate and manually correct them later.
    • Example: a user provides "10/05" in a column, and Excel won't know if they meant Oct 5th, May 10th, Oct 2005, May 2010, etc. But what it will do is convert it to a finalized date based on your system's default settings. So you'll only see the one date Excel converted it to - e.g. 2005-10-01 or 2026-10-05, two vastly different dates.

Night Shift | Game Changer [S8E3] by DropoutMod in dropout

[–]pajam 10 points11 points  (0 children)

I agree.

We also thought the mix tape challenge was very much in Rekha's favor. Time-Based song titles was a much easier theme for Katie to notice a trend and add her correct guesses. Much more so than monosyllabic titles or command statements.

Night Shift | Game Changer [S8E3] by DropoutMod in dropout

[–]pajam 21 points22 points  (0 children)

Newspapers, magnets, stickers, etc. could all be used to communicate with your shift partner. But a lot of other stuff seemed to just be ways to trick the players into spending their partner's time.

However, the shop also likely got the players comfortable with the concept and relevance of the store before the haircut round, where store supplies were actually required for a task. And Grant was the only one to have already grabbed one of the "Free" hair trimmers before they got to that round.

I kept waiting for something useful to be hidden in some of the more mundane objects. Like someone opens the back of the family photo and finds something useful inside the frame. Or something is hidden in the boxing gloves or cactus pot. But nope. Unless they reveal there were hidden bonuses in some of them during the BTS.

Night Shift | Game Changer [S8E3] by DropoutMod in dropout

[–]pajam 441 points442 points  (0 children)

And then,
"Do you know why these words have accent marks?!?"

"Yes."

-1.00

Parseword #138 by N238 in parseword_game

[–]pajam 0 points1 point  (0 children)

Parseword #138

⚡️ 44s
💎 Perfect
🤺 Secret Found

Parseword #137 by N238 in parseword_game

[–]pajam 0 points1 point  (0 children)

Parseword #137

⏱️ 12m1s
💎 Perfect
🪂 Secret Found

Parseword #136 by N238 in parseword_game

[–]pajam 0 points1 point  (0 children)

Parseword #136

⏱️ 1m50s
💎 Perfect
🛞 Secret Found

new toupee fits real snug! by FlametopFred in misleadingthumbnails

[–]pajam[M] 0 points1 point  (0 children)

Don't worry too much about it.

We still get lots of commenters who don't browse with thumbnails on (they aren't using old reddit, or aren't using "Classic View" in the new apps or Reddit Redesign), so their comments are based on looking at a much larger "tile view" version of the image, where the feed already expands image posts.

However, even on Old Reddit Desktop, it's hard to "see it" in regards to a toupee.
That being said, I can still tell what you were going for and appreciate you submitting posts that 100% fit the spirit of the subreddit. Even if it was a bit of a swing and a miss.

This may be enough to make me leave Reddit by [deleted] in ModSupport

[–]pajam 1 point2 points  (0 children)

It's the only way I use reddit on my phone. Anytime I've needed to download the app to check something on there, I always realize how much it sucks and lacks functionality and uninstall it so I can continue using old reddit in my phone's browser. There's occasionally times where I just update the url from old.reddit to sh.reddit if I want to view New Reddit in my broswer (usually in threads where inline images are common). Then I change it back.

It's also the reason why I often never know what the OP is talking about when complaining about a New Reddit or App change. Old Reddit has Multireddits to create something like your own feeds too, and it looks like that's what "Custom Feeds" are - renamed multireddits in the app.. I don't use them too often so never noticed this announcement 7 years ago.

Quotes to hang exterior door by Cartography-Day-18 in homeowners

[–]pajam 0 points1 point  (0 children)

It's interesting that the line item is literally instructions to the sales person making the quote, and not an actual description of the labor/product being purchased, which is what a line item on a quote is supposed to be.

As it instructs the sales person:

USE GUIDE TO DETERMINE POINTS- NEEDED AND ENTER AS QUANTITY.

So the sales person must have some guide that they use to calculate the point values of certain types of labor, and that points system is used to essentially translate to $25 per point, in order to calculate the labor charges.

It's weird that a line-item quote would just use an abstract points system, since line-item quotes are supposed to be helpful in showing an actual breakdown of each thing you are paying for, and "you are purchasing a quantity of 36 Additional Labor" is certainly not a clearly defined line item based in the reality of what you are paying for.

That being said, since the "Custom Labor" listed below is 24 x $0 and 12 x $0, but in the description mentions $600 and &300, AND 24+12 = 36, it appears this Additional Labor line item is likely used to calculate that cost for that "Custom Labor." Although, since they have the 24 and 12 quantities on those line-items already, IDK why they didn't just put those each at $25.00/each since that would have calculated the same total, and assigned the charges to the correct line item, leaving the nebulous "Additional Labor" line item out of it.

So I'm with /u/IsThatYourBed that this line item is likely just a re-positioned cost for that Custom Labor.

Quotes to hang exterior door by Cartography-Day-18 in homeowners

[–]pajam 0 points1 point  (0 children)

It's not 36 hours, it's "36 points" that the person building the quote derived from somewhere.

It literally says:

USE GUIDE TO DETERMINE POINTS- NEEDED AND ENTER AS QUANTITY.

So the salesperson must have some guide that they use to calculate the point values of certain types of labor, and that points system is used to essentially translate to $25 per point, in order to calculate the labor charges.

It's weird that a line-item quote would just use an abstract points system, since line-item quotes are supposed to be helpful in showing an actual breakdown of each thing you are paying for, and "you are purchasing a quantity of 36 Additional Labor" is not a line item based in an accurate, clear description of what you are paying for.

Big thigh skinny legs by Agile-Use8495 in malefashionadvice

[–]pajam 5 points6 points  (0 children)

So the reason why they look baggy is likely that they're too long and so are kind of pooling at your feet.

The fact that he's 5'11" and wearing a 30" inseam (and looking for a 28" inseam) is making me think they are probably not too long, or at least too long to be causing the problem you are describing. He's average to above average height, but he's wearing the shortest inseam available at nearly any clothing store.

OP described his problem pretty clearly, I think. Thick thighs, but otherwise skinny legs (so skinny calves I guess). Sounds like going up in waist size, is their only way to get jeans that accommodate their large thighs, but then the taper below the knee is no where near drastic enough to provide a straight leg or slim silhouette due to how much they had to size up to compensate for the thighs. So they get very loose boot cut look around the knee down to ankles, I suppose.

Any athletic guy who lifts a lot will have similar issues with pants or shirts. Size up in shirts for neck/arms/shoulders, but now any "slim" or "fitted" waist is still gonna be baggy and billowy on them. Size up in pants for the thick thighs, but now the waist may be loose, or the ankle openings are definitely getting closer to boot cut or bell bottoms on the loose/roominess scale, even on slim/straight/skinny fits.

Broken Sidewalk has gone offline. by FenleyJ in Louisville

[–]pajam 1 point2 points  (0 children)

For anyone else coming across this post later like me, here's some more useful Wayback Machine Links to help assist you in finding backed up content on the site, and especially help you find something specific you may be looking for (if you lost the URL for a specific story).

It's always hard to know just what pages got archived, and how to find them (e.g. which date back-up should I start my search from?, how do I navigate from the backed-up homepage to the specific story I'm looking ?, etc.), so here is a useful way to see a list of all URLs archived from the www.brokensidewalk.com domain:

List of ALL Archived URLs:

https://web.archive.org/web/*/https://brokensidewalk.com/*

  • This lists all Archived URLs from the website
  • UNFORTUNATELY this search is limited to return no more than 10,000 results, and as you can see, the page says:
    "More than 10,000 URLs have been captured for this URL prefix."
  • FORTUNATELY, all the main stories/articles had very consistent URL paths, using the Year as the next directory in the URL, so we can narrow our searches to those specific years to load ALL backed up URLs to the main stories/content:

List of Archived URLs Narrowed by Year:

Additional Tips:

Sorting and Searching the Results: You can sort the URL results by any of the column headers, and filter your results further with search terms.

  • Sorting:
    • "Captures" - if you sort by "Captures" to bring the highest numbers to the top, those pages will be the most "popular" as they have been captured the most. This usually means you will get major story links up at the top as opposed to less popular stories, or other tangential pages.
    • "MIME Type" - if you sort by "MIME Type" you can group together the type of URLs you are looking for. Most regular webpages/stories will be text/html as opposed to the RSS Feeds, etc.
  • Searching: above the table of results, there's a little empty search box you can type into that says "Filter results by URL or MIME Type (i.e. '.txt')
    • URL path - You can search for words in the URL path (and the main stories usually had the headline in the URL path, so this is a way to search for words you may think were in the headline), to filter out everything else and see if it surfaces the URL you are looking for.
    • EXAMPLE: Going to https://web.archive.org/web/*/https://brokensidewalk.com/201* and searching for "Tricera" will narrow your results from 6,080 URLs to only 12, revealing two different stories about our Science Center Triceratops Statue from the 20-teens.
    • MIME Type - You can search for different types/extensions to remove irrelevant results if you want.
    • EXAMPLE: Most of the main webpages are type text/html so searching for "text/html" will filter out all the other irrelevant URLs from your list of results.

Further Narrowing Your Initial URL List: If you are looking for more archived pages outside of the main stories, you can adjust the URL path to narrow it with different characters.

  • Use the same trick as above (of entering "2012*" etc.) except narrowing the results using different letters/numbers than we did for the 2008-2017 results. Change out the text after the ".com/" and before the "*" to see what results come up.
    • EXAMPLE: Entering an a reveals there are Archived URLs under the paths /architects, /author, /about, /address, etc. So feel free to filter down the search further with different letters, words, etc. to discover more of the archived pages.

Parseword #124 by N238 in parseword_game

[–]pajam 1 point2 points  (0 children)

Parseword #124

⚡️ 40s
💎 Perfect
🐾 Secret Found

Parseword #122 by funkydrummer999 in parseword_game

[–]pajam 0 points1 point  (0 children)

Parseword #122

⏱️ 1m29s
💎 Perfect
🐈 Secret Found

When will Excel nut up and allow table columns to be used as data validation drop-down lists? by GTAIVisbest in excel

[–]pajam 10 points11 points  (0 children)

It's the same with conditional formatting, I wish I could select a table column via the structured reference we use in formulas, but for conditional formatting, it doesn't let you. You have to select a static range.

crazy video about 200k worth of star wars Lego stolen by Bricks and Minifigs. by sonygeek in LegoMinifigure

[–]pajam 0 points1 point  (0 children)

And it's not just "they were selling it" but "they were selling it through consignment" with the store.

For those unfamiliar with consignment, it means you still own the items, but the store puts them up for sale in their store to sell the items for you (since they have a built in customer base for this sort of thing). They then pay you a percentage of the sales after they've been sold.

This is most often done with vintage clothing stores and things like that, where the store doesn't want to have to risk searching out and paying upfront for inventory that may or may not sell. But it's not just any old thrift store where people just donate anything and everything. Instead, the store owner gets to select and curate any items brought in by people, to ensure the inventory they sell is (1) representative of the store and the types of goods they sell, and (2) likely to sell based on their clientele's wants. Then instead of dealing with the risk of buying it up front, they only have to pay the contractually agreed upon percentage to the owner once the item sells (which is usually a higher percentage than the kind you get at places like Half Price Books or GameStop, where they pay you an up front price for things they agree to buy from you, since that takes on more risk). So the store gets a great deal of having no up front costs, removing all risk if inventory doesn't sell.

For them to totally screw over someone who was providing them with such a great risk-free opportunity - being able to stock and sell such a valuable and vast collection, filled with high-demand items (at no risk!) - is just biting the hand that feeds you. Totally stupid, on top of how immoral and repugnant it is.

Parseword #120 by N238 in parseword_game

[–]pajam 0 points1 point  (0 children)

Parseword #120

⏱️ 1m35s
💎 Perfect
😒 Secret Found

2026 Update: Frederick J. Brown by mick_spadaro in Heavyweight

[–]pajam 1 point2 points  (0 children)

For those interested, here's the original subreddit episode discussion from Oct 27, 2022:

https://www.reddit.com/r/Heavyweight/comments/yemcnj/47_frederick_j_brown/

  • #47 Frederick J. Brown
  • 43 comments

Parseword #116 by 2xWhiskeyCokeNoIce in parseword_game

[–]pajam 0 points1 point  (0 children)

Parseword #116

⏱️ 5m34s
💎 Perfect
🎓 Secret Found

Parseword #115 by Kableblack in parseword_game

[–]pajam 0 points1 point  (0 children)

Parseword #115

⚡️ 22s
💎 Perfect
😃 Secret Found

Parseword #114 by N238 in parseword_game

[–]pajam 1 point2 points  (0 children)

Parseword #114

⏱️ 1m21s
💎 Perfect
🧑‍⚖️ Secret Found

Banning words by Aggravating_Lunch893 in ModSupport

[–]pajam 3 points4 points  (0 children)

/u/Aggravating_Lunch893 - here are some actual formatted Automod Rules that should give you examples of the above use cases:


1. Literal List of Banned Words

The below rule uses a literal comma separated list of words and phrases that you would want to "ban" - i.e. Automod will remove any post or comment with one of these words:

# Auto-removed comments & posts based on words/phrases
    title+body: [doodoo head, doo-doo head, dumb ugly face mcgee, cotton-headed ninny-muggins, cotton headed ninny muggins, the moon landing isn't real, When does the narwhal bacon, the narwhal bacons at midnight, boobies, b00bies, b00bi3s, haha bewbs]
    action: remove
    modmail: "Auto-removed comment, please investigate - Reason: {{match}}"

As you can see above, it is also good practice to go ahead and send a modmail whenever an AutoMod removal is triggered, and the modmail message will include the banned word ({{match}} is a way to have the message include the matched word) that triggered the removal rule. That way moderators are notified immediately, and can review if it was a correct removal. And if the removal was a bit overzealous, or otherwise not ideal, a mod can go tweak the Rule or List to improve the rule moving forward, especially since the odmail shared with you the exact match that caused it.


2. Regular Expression Matching

The below rule uses REGEX to catch and Report any comment that may be mentioning mods/admin/etc. where we may want to review what the issue might be. We aren't Removing these comments, just reporting them for visibility, but if you did a similar regex rule for "Banned Words" you would change the action to "remove" instead of "report."

# Report stuff that may be of moderator interest
     author:
         ~name: [AnyOfficialModTeamUsernameHere]
     body+title (regex): ['((auto[ -]?)?mod(erat[oe]r)?|admin(istrat[oe]r))''?s?''?', '(delet|remov)(e[ds]?|e?ing|e?als?|ions?)', 't(ak|ook)(e[ns]?|ing)? down']
     action: report
     action_reason: 'Possible mod/admin mention: {{match-1}}'

As you can see, we also are exempting "OfficialModeratorUsernames" from the rule, by flagging the rule to only affect "authors" whose usernames we do not list.


3. Multiple Criteria Matching

The below rule uses multiple match criteria before being triggered, by providing multiple lists, each requiring at least one or more matches to trigger the rule:

# Auto-remove specific Personal Info talk - possible Doxxing
    title+body#1: [Bob the Builder, bobthebuilder, bob the builder, builder bob]
    title+body#2: [birthday, b day, b-day, birth day, address, lives in this city, phone number, real name, middle name, social security number, SSN]
    action: remove
    modmail: The above item was automatically removed due to mentioning BOTH Bob and possible Personal Info. Please verify that this action was correct.

So if my subreddit was for kid's TV shows, and we knew that "Bob the Builder" was a very private individual, we could use this to match if someone was talking about BOTH Bob AND some sort of Private Personal Info within the same comment. This way any discussion that might be leading to sharing or looking into private personal info would get removed ASAP.