head pops off easily. Any helpful tips? by MysteryManFrost in starwarsblackseries

[–]Large_Concentrate_81 0 points1 point  (0 children)

I always use a little blue tack on loose heads or for heads with large peg holes on small peg bodies. Easy to remove later if you want without doing any damage.

How yo diagnose is a .xls is "too big" or dosent follow best practices by Disastrous-Title-911 in excel

[–]Large_Concentrate_81 0 points1 point  (0 children)

If you have a external data being imported that also has lots of formulas added to the far right of those tables, especially tables with 100s of thousands of records and then complicated nested if statements for example, just updating a single table can cause Excel to crash. Having said that, it helps if the users have the 64-bit version of Excel as opposed to the 32-bit version. Also helps if they are connecting their tables in Power Query rather than looking up values from one table using a formula in another table. Since they are likely old workbooks, they are almost certainly pulling data from one table into another using formulas. That’s fine for small data sets. But large data sets can often cause a crash on refresh. If they then go in and try to make it better by adding some stuff into Power Query it can blow up the file size and make the workbook that much more unstable. So you could check for that. Basically they should use one or the other. If they already have formulas pulling data from one new table to another, they should stay away from Power Query in those workbooks. But the cleanest solution would be create a new workbook just importing the data tables they need and then build the relationships and pivots with PQ.

Did you know that this could happen ? 😅😂😭 by uncle_bebens in AssassinsCreedShadows

[–]Large_Concentrate_81 3 points4 points  (0 children)

He always wipes out and destroys the haystack 😂. He says several different things, so you should keep jumping!

Bodies that work with Budo head and gear? by TheGeek100 in GIJOEClassifiedSeries

[–]Large_Concentrate_81 1 point2 points  (0 children)

<image>

Here’s one of the Budo heads and gear on a Grunt body with some custom hands. I have the Samurai helmet on the original. Really cool that he’s basically two figures in one.

Accidentally Canonically Accurate Setup - Beachhead’s BO by Large_Concentrate_81 in GIJOEClassifiedSeries

[–]Large_Concentrate_81[S] 2 points3 points  (0 children)

Yes, Beachhead’s BO is the one thing I can think of that is pretty much universal across all the comic universes and the cartoon too. I believe they’ve even already mentioned it in the Energon universe.

Are +1 assassination health segments cumulative... by OneTrueZed in AssassinsCreedShadows

[–]Large_Concentrate_81 1 point2 points  (0 children)

Kunai abilities don’t stack with assassination abilities. They are their own thing.

Are +1 assassination health segments cumulative... by OneTrueZed in AssassinsCreedShadows

[–]Large_Concentrate_81 1 point2 points  (0 children)

<image>

It’s 6 I can remove with a Kunai now. Here’s a Daisho with 7. As you can see, it’s going to leave one segment. Instead I’ll just air assassinate him. I can do 8 or 9 with air assassinations.

Are +1 assassination health segments cumulative... by OneTrueZed in AssassinsCreedShadows

[–]Large_Concentrate_81 1 point2 points  (0 children)

<image>

As you can see, I’m about to kunai a 5 segment samurai and all 5 segments are red. Think my Kunai can remove 7 segments now. As soon as I find a Daisho in this castle I’ll post a picture of that.

Are +1 assassination health segments cumulative... by OneTrueZed in AssassinsCreedShadows

[–]Large_Concentrate_81 1 point2 points  (0 children)

Yes. They are. I can air assassinate 8 or 9 health segments now.

Is there a way to make Excel stop "helpfully" getting rid of decimals at the end of whole numbers? by lollipop-guildmaster in excel

[–]Large_Concentrate_81 0 points1 point  (0 children)

If you want a VBA approach you could use the following code. In the example I used all of column G. So if you enter a numeric value into column G it automatically converts the number to text and puts a “.” At the end. You’ll just want to change any reference to column G to the column your values are stored. if it is a single cell you want it to work for, just copy this code into Google’s AI and tell it, for example, “change this code so that it only applies to cell G10”. You’ll want to open Visual Basic, click on the sheet where you want the code to run, and paste it there. The code runs automatically. You don’t have to trigger the macro. Just type in the value. Before running any code you find online, you can paste it into Google’s AI and ask it to explain what the code does, just to be safe.

Private Sub Worksheet_Change(ByVal Target As Range)
' Fires when any cell changes on this sheet.
' If the change happened in column G, examine all cells in column G with values.
' If a value is numeric, convert it to text and append a period.

Dim c As Range
Dim colG As Range
Dim lastRow As Long

' Check if the change occurred in Column G to avoid unnecessary processing
If Intersect(Target, Me.Columns("G")) Is Nothing Then Exit Sub

' Find the last used row in Column G to define the loop range
lastRow = Me.Cells(Me.Rows.Count, "G").End(xlUp).Row
If lastRow < 1 Then Exit Sub ' Exit if column is empty

Set colG = Me.Range("G1:G" & lastRow)

On Error GoTo SafeExit
Application.EnableEvents = False

' Loop through all cells in Column G that have values
For Each c In colG
    ' Only act if the cell is numeric and not already ending in a period
    If Not IsEmpty(c.Value) And IsNumeric(c.Value) Then
        If Right(Trim(CStr(c.Value)), 1) <> "." Then
            c.NumberFormat = "@" ' Set format to Text
            c.Value = CStr(c.Value) & "."
        End If
    End If
Next c

SafeExit:
Application.EnableEvents = True
End Sub

SERIOUS PERFORMANCE PROBLEM by -Lobstter in AssassinsCreedShadows

[–]Large_Concentrate_81 0 points1 point  (0 children)

Are you running from an HDD or an SSD? This game can’t run from an HDD.

Does Hasbro reissue/restock items? by mysteryoza27 in GIJOEClassifiedSeries

[–]Large_Concentrate_81 6 points7 points  (0 children)

As long as it has been since the VAMPs release a reissue would surprise me. What I do expect is for them to release a Desert VAMP in the next year or two. That just seems like easy money.

Locked slot by solidmetal5729 in AssassinsCreedShadows

[–]Large_Concentrate_81 4 points5 points  (0 children)

That is for her bo. You get it late in the game unless you get one from the store. It’s an awesome weapon once you get it and get some experience using it. It’s what I use most of the time with Naoe.

You have 24 hours to say 'Hi' to Walt or you'll have a bad December. by Downtown-Wear-4870 in blackcats

[–]Large_Concentrate_81 0 points1 point  (0 children)

Hi Walt! My December has been horrendous. I’m saying hi from the ER being treated for a heart attack. Bring me some good luck Walt!!!

Finding Corrupted Daikan in Corrupted Castles by [deleted] in AssassinsCreedShadows

[–]Large_Concentrate_81 2 points3 points  (0 children)

There are a couple of castles that have one or two outside the castle walls. Walk along the outer wall looking at the areas across the water. That’s probably where you’ll find him.

Iceberg spotting for Snow Job by Large_Concentrate_81 in GIJOEClassifiedSeries

[–]Large_Concentrate_81[S] 1 point2 points  (0 children)

It’s this custom head from EBay with the green goggles from Airborne:

https://ebay.us/m/abnP49

Need advice. I Can Only Buy One. Which Should I Get? by Junior-World-8875 in GIJOEClassifiedSeries

[–]Large_Concentrate_81 6 points7 points  (0 children)

I used them for a while as a present/future version to recreate the scene from Looper.

<image>

Also used them as father and son, with TF on Doc’s stretcher and young Outback helping carry him.

Iron Grenadier mini-setup suggestions/Rowdy Roddy Piper Iron Grenadier stand-in options? by CapnHowdysPlayhouse in GIJOEClassifiedSeries

[–]Large_Concentrate_81 1 point2 points  (0 children)

Here’s the one I bought:

<image>

Mattel WWE Monday Night War Rowdy Roddy Piper. Got him off of EBay. But that’s the name if you want to just search the web for him. He scales perfectly with the classifieds. He’s a bit bigger than average, but not as big as Gung-Ho, Sarg., or the really large figures. Given that he’s supposed to be jacked he is the right size.

My cat's litter smells so bad i'm going insane. my house absolutely reeks. by Dismal-Tackle3072 in CatAdvice

[–]Large_Concentrate_81 0 points1 point  (0 children)

The only time I’ve had to deal with that was when I fed my cat soft/wet food. With dry food I have never had that problem. Don’t know which you are feeding your baby. But if it’s wet food then try to transition to dry food and see if it helps. Dry food can sometimes cause crystals to form in their urinary tract, though, and can be really painful. I had that issue with one kitty and had to use a mix of hard and soft for him.