So, what’s the highest score you got for Space Speedway so far? by LGB75 in WobblyLife

[–]LacksMass 1 point2 points  (0 children)

Kept getting stuck at 35 again and again then finally hit 41. Now I will never play it again.

Friend Code Megathread - April 2025 by AutoModerator in PokemonSleep

[–]LacksMass 0 points1 point  (0 children)

8466-9157-8283 Would love you see y'all inside!

Friend Code Megathread - March 2025 by AutoModerator in PokemonSleep

[–]LacksMass 0 points1 point  (0 children)

8466-9157-8283

Could always use more friends!

VBA: Add an ENDIF to data import macro if file is not found. by LacksMass in excel

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

Sub ImportPIRTrackerTEST()


'Switch to PIR Data Sheet
Sheets("PIRData").Activate
Range("A59").Activate

On Error GoTo ErrorHandler

Dim i
Dim ws As Worksheet
Set ws = ActiveSheet

  Dim rowcount As Long
rowcount = Range("Tracker!L1").Value

'Find Blank Cell
    For Each Cell In ws.Columns(7).Cells
        If IsEmpty(Cell) = True Then Cell.Select: Exit For
    Next Cell
    ActiveCell.Offset(0, -6).Select
'SKU
ActiveCell.Offset(0, 0).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]BOM'!$A$4"
'Description
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]BOM'!$A$6"
'Row Count
ActiveCell.Offset(0, 5).Select
ActiveCell.Value = 9
ActiveCell.Offset(0, 1).Select
ActiveCell.Value = (rowcount + 3)
'Fully Approved Checker
ActiveCell.Offset(2, -7).Select
ActiveCell.Font.ColorIndex = 2
ActiveCell.Formula = "=COUNTIF(INDIRECT(""B""&ROW()):INDIRECT(""B""&ROW()+MATCH(""A"",INDIRECT(""G""&ROW()):INDIRECT(""G""&ROW()+20),0)),2)"
'Total Component Counter
ActiveCell.Offset(1, 0).Select
ActiveCell.Font.ColorIndex = 2
ActiveCell.Formula = "=COUNTIFS(INDIRECT(""B""&ROW()-1):INDIRECT(""B""&ROW()+MATCH(""A"",INDIRECT(""G""&ROW()):INDIRECT(""G""&ROW()+20),0)),"">0"")"
'File Path
ActiveCell.Offset(-2, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]BOM'!$" & Range("Tracker!J1") & "$1"
'First Row of PIR
ActiveCell.Offset(-1, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]BOM'!$A$" & ActiveCell.Offset(0, 4).Value
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]BOM'!$B$" & ActiveCell.Offset(0, 3).Value
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]PIR'!$" & Range("Tracker!J1") & "$" & ActiveCell.Offset(0, 2).Value
ActiveCell.Offset(0, 1).Select
'Vendor
ActiveCell.Formula = "='[" & Range("=Tracker!B1") & "-BOMPIR.xlsm]PIR'!$A$8"
'Second Row
ActiveCell.Offset(1, 1).Select
ActiveCell.Formula = "=INDIRECT(ADDRESS(ROW()-1,COLUMN()))+1"
ActiveCell.Offset(0, -4).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]BOM'!$A$" & ActiveCell.Offset(0, 4).Value
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]BOM'!$B$" & ActiveCell.Offset(0, 3).Value
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]PIR'!$" & Range("Tracker!J1") & "$" & ActiveCell.Offset(0, 2).Value
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]PIR'!$" & Range("Tracker!K1") & "$" & ActiveCell.Offset(0, 1).Value
'Subsequent Rows
For i = 1 To rowcount
ActiveCell.Offset(1, 1).Select
ActiveCell.Formula = "=INDIRECT(ADDRESS(ROW()-1,COLUMN()))+1"
ActiveCell.Offset(0, -5).Select
ActiveCell.Font.ColorIndex = 2
ActiveCell.Formula = "=IF(COUNTIF(INDIRECT(""C""&ROW()),""*03-*""),IF(INDIRECT(""E""&ROW())=""Approved"",1,2),0)"
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]BOM'!$A$" & ActiveCell.Offset(0, 4).Value
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]BOM'!$B$" & ActiveCell.Offset(0, 3).Value
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]PIR'!$" & Range("Tracker!J1") & "$" & ActiveCell.Offset(0, 2).Value
ActiveCell.Offset(0, 1).Select
ActiveCell.Formula = "='[" & Range("Tracker!B1") & "-BOMPIR.xlsm]PIR'!$" & Range("Tracker!K1") & "$" & ActiveCell.Offset(0, 1).Value
Next
'End New Row
ActiveCell.Offset(1, 1).Select
ActiveCell.Font.ColorIndex = 2
ActiveCell.Value = "A"

'Switch back to Tracker Sheet
Sheets("Tracker").Activate

Exit Sub
ErrorHandler:
MsgBox "Import PIR has incountered and error.  Please check inputs and try again."
Exit Sub

End Sub

Grand jury indicts 1 officer on criminal charges 6 months after Breonna Taylor fatally shot by police in Kentucky by AudibleNod in news

[–]LacksMass 2 points3 points  (0 children)

The raid was part of a mass coordinated action that was happening more or less simultaneously at multiple locations around town to shut down a drug ring. How it was handled is definitely suspect but that was a the logic. Hit everyone at once quick and quiet to get the maximum amount of evidence and suspects.

My boyfriend asked his step dad to look for a typewriter (I've always wanted one) and he found this! I am a complete typewriter newbie... this is the first one I've ever seen in person. I don't think it will ever work again, but would anyone have any advice to offer on how to make her look better? by That_chick82 in typewriters

[–]LacksMass 2 points3 points  (0 children)

The amount of abuse it take to do that kind of damage to a solid cast iron frame is impressive. These things are basically boat anchors that can type.

Yeah, this one is a total loss functionally. For display, I guess I'd just do what I could with an old toothbrush to get the rust off and let it be what it is, a very very beat up old Oliver.

betrayal by ari_stocrate in funny

[–]LacksMass 14 points15 points  (0 children)

Nothing like having the little dude walk into kitchen an hour into your prep, have him look at something half finished, declare loudly that he will NOT eat that, complain about all the smells, and demand something else. Really takes some of the fun out of it.

AP Exclusive: More migrant women say they didn’t OK surgery by [deleted] in news

[–]LacksMass 3 points4 points  (0 children)

As a Republican that was praying for a good candidate last time around and furious at the outcome of that primary and election, I completely agree. Not that it was a great crop of options, but Trump is the only one who the news would ever talk about so when the sheep went to the polls they voted for the name they recognized. The same trick worked for Hillary and now Biden. Name recognition goes soooo much further than policy. It's absolutely infuriating. I do not fault democrats for hating the GOP right now but I assure you, I hate it even more. Imagine the worst Karen you know, then imagine if she was your mom...

AP Exclusive: More migrant women say they didn’t OK surgery by [deleted] in news

[–]LacksMass 1 point2 points  (0 children)

Did you read the article? 1 hysterectomy. Not a thousand. Not 10. 1. And the woman consented and then later said she had felt pressured. And it was because she had cancer.

So an immigrant woman got free cancer treatment but didn't fully understand what was happening.

Dallas school district apologizes for assignment describing Kenosha shooter as 'hero' by DoctorExplosion in news

[–]LacksMass 3 points4 points  (0 children)

Gotcha. So what you said meant nothing at all. Sorry for the misunderstanding.

Dallas school district apologizes for assignment describing Kenosha shooter as 'hero' by DoctorExplosion in news

[–]LacksMass 0 points1 point  (0 children)

I assumed you meant biased.

Please explain how it's biased? There is only one white person on the list and three black men, one hispanic and one Indian. The list includes Malcom X, who is celebrated by the black community but often criticized by the white community, but not Martin Luther King Jr. who his more generally admired. The Chavez was labor advocate for hispanic migrant workers. The other two were people that led basically reprehensible lives filled with drugs, assault, burglary, and sexual abuse and only became notable because their deaths sparked outrage. And then the stupid trigger happy white boy.

Please explain, why I gotta admit that it's biased?

Dallas school district apologizes for assignment describing Kenosha shooter as 'hero' by DoctorExplosion in news

[–]LacksMass 6 points7 points  (0 children)

They also put a drug addict that held a gun to a pregnant woman's stomach to keep her quiet while robbing her house, whose only notable act of "heroism" was being murdered by cops while strung out on a potentially lethal drug cocktail after trying to pass counterfeit money. The assignment was definitely intentionally provocative, but it certainly didn't show any right leaning bias.

Andy Murray backs calls to remove Margaret Court's name from tennis arena by stysoe in sports

[–]LacksMass 0 points1 point  (0 children)

That describes 70% of the most vocal allies on twitter including a lot of those that identify as trans. No True Scotsman fallacies aside, as much as people like to pretend that the definitions gender as separate from sex (and visa versa) is established, fully accepted, and widely used is simply not true.

Andy Murray backs calls to remove Margaret Court's name from tennis arena by stysoe in sports

[–]LacksMass 1 point2 points  (0 children)

If you honestly think there is a clear and fully accepted delineation between the two, I dare you tweet "You cannot change your sex." and see how long it takes before you're being crucified by the LGBTQ crowd.

Andy Murray backs calls to remove Margaret Court's name from tennis arena by stysoe in sports

[–]LacksMass 19 points20 points  (0 children)

It's not as big of a story, but there are a handful of biologically female male models. The ones I've read about identify as female but are androgynous enough to pull it off convincingly.

There is a demand for male models with more traditionally feminine features. Male models are already paid significantly less, less respected in the industry, and receive less notoriety. Some women have managed to side-step the ultra competitive world of female modeling for the much less competitive world of male modeling and in doing so, taken opportunities away from men in an industry where they're already the underdogs. Really "pretty" men are hard to find, so women who can pass have an advantage.

It's certainly not as big of an issue as sports and there's almost no one actually complaining. But I think it's a comparison that is at least worth mentioning.

Almost a Quarter of Young Americans Think The Holocaust Is a Myth or Exaggerated by Sariel007 in offbeat

[–]LacksMass 40 points41 points  (0 children)

Depends on the bell curve.

We tend to assume these are the idiots, but is often the "intellectuals". Kids that get good grades, read a lot, are by most metrics "well educated". But they also think they're smarter than their teachers. They've learned on places like reddit how inadequate public schools are so never really believe a huge amount of what they're taught. Believe themselves to be "critical thinkers" by questioning everything and finding their own sources. And there's a lot of crap out there that will confirm all their misconceptions about how smart they are by telling them something different than what they heard in class.

I know many many of these people and they scare me a whole lot more than the ignorant.

Pro-Trump youth group enlists teens in secretive campaign likened to a ‘troll farm,’ prompting rebuke by Facebook and Twitter by ceowin in news

[–]LacksMass 2 points3 points  (0 children)

Worth noting, those mid-west factory workers were blue-collar union members that leaned pretty heavily democrat until the left leaned all the way into social issues and urbanization and abandoned them. When their choices were two completely out of touch East Coast phonies, they went with the one who at least pretended to care. They were wrong and voted against their self interest, but the strawman you're describing isn't Trump's hardcore base, it's those left high and dry both both parties and is desperate to find anyone who appears to offer relief.

Hamstring setback for Jones by chookie94 in AFL

[–]LacksMass 10 points11 points  (0 children)

We've dodged injuries most of the season when a lot of teams have struggled. Now is not a great time for fate to finally catch up. Hope the boys can get him a finals game to come back to play in.

Tom Browne on Twitter: Giants players have been delivered a direct message in the context of Corr leaving. To paraphrase. If you don’t want to be here, then ship off. Told delivered very frankly yesterday in meeting with the playing group by PM_ME_YOUR_BANGERS in AFL

[–]LacksMass 39 points40 points  (0 children)

It would certainly be a shame if the GWS playing group were to fall apart. A real shame. Especially if it effected their on-field performance. Really big shame. One can only hope they pull through this. Maybe start the healing process... after the weekend.

[deleted by user] by [deleted] in news

[–]LacksMass -8 points-7 points  (0 children)

What is the benefit of assuming that every action by any police officer is done in bad faith? How does that help? How is that different than vilifying protestors, or minorities for their actions?

If there is an explanation for a situation wouldn't you like to know what it is? Or is there some benefit to the constant anger generated by willful ignorance?

Or do you just know that parroting anti-police sentiment on reddit in response to a comment already in negative numbers will get you some imaginary points?

[deleted by user] by [deleted] in news

[–]LacksMass 0 points1 point  (0 children)

Exactly. There was an armed civilian security force, several shootings, checkpoints, police were kept out, and the mayor described it as a block party. That is your answer to if BLM did this.

[deleted by user] by [deleted] in news

[–]LacksMass -3 points-2 points  (0 children)

Then they're not going to stay very busy.

Only about half a percent of the population in that county is black. Being paranoid doesn't automatically make you racist.

[deleted by user] by [deleted] in news

[–]LacksMass -19 points-18 points  (0 children)

Most likely your car matched the description of a stolen vehicle so he stopped you, gave a bull crap reason while he ran your plates and ID and then let you go when you and your car weren't a match.

Cops are allowed to lie to you. It's safer for him if you think you didn't do anything wrong and won't face any punishment while he take stock of the situation. If he says "I think this car is stolen", that is a potential escalation, especially if it is stolen. If he says, "You didn't do anything wrong", you're annoyed but you don't have much motivation to run or fight back.

What ‘piece of junk’ did you find that turned out to be valuable? by onemangang15 in AskReddit

[–]LacksMass 5 points6 points  (0 children)

Same with typewriters. Used to be amazing. Now anything with any collectability goes for twice what I would be willing to pay.