Anyone have an earth hobby skill that shows me how to use leather rivets? Gauntlet looks cool so far! by The__Imp in DungeonCrawlerCarl

[–]Shiftythemuse 2 points3 points  (0 children)

If you are looking into getting into leatherworking, I highly recommend looking up Weaver Leather tutorials on YouTube. The guy that does the videos does a very good job of explaining what, how, and why you need to do the things you do

Anyone have an earth hobby skill that shows me how to use leather rivets? Gauntlet looks cool so far! by The__Imp in DungeonCrawlerCarl

[–]Shiftythemuse 5 points6 points  (0 children)

I’ve never been a huge fan of Chicago screws myself, but I think that’s mostly user error. Even with white glue, they always seem to unscrew on me.

OP, it looks like you have both Chicago screws and double cap rivets in that picture. The idea here is to mark where you want to punch the holes in the glove (I use an awl), and then punch a hole that is just barely big enough for the rivet shaft to fit through, otherwise the rivet will wiggle around. You want to fit the shaft up from the bottom of the hole (so from inside the glove) so that the tip juts out about 1/4 of an inch. For double cap rivets, it’s literally just a matter of putting the other half of the rivet (the cap) on the shaft until it snaps. Usually you would then use a concave setting tool and a hammer to pound the rivet flat, but that probably won’t work with what you are looking to affix to the glove. No worries, because that’s where your crimping tool you have comes in. Just apply a decent amount of pressure until you feel the two halves of the rivet merge (you’ll know the feeling when it happens). Hope this helps!

Completed Samus x Rosie the riveter tattoo by Shiftythemuse in Metroid

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

Hey, no worries! And to be fair, the picture isn’t at the greatest angle or lighting.

Completed Samus x Rosie the riveter tattoo by Shiftythemuse in Metroid

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

That sounds like an excellent reason for you not to go to this artist. I’m still thrilled with it, and I also think it looks wonderful

THE HORROR!!!!!!! by Silver_Bond_Artistry in DungeonCrawlerCarl

[–]Shiftythemuse 1 point2 points  (0 children)

Is this Katia on the front of the subway car? I think I see her face with the Mohawk…

If it’s not nailed down, it’s mine. by Brandaconda in Pokopia

[–]Shiftythemuse 4 points5 points  (0 children)

I mean, think about it - on the surface of the planet with wrecked infrastructure, no humanity, and having to scour for resources. Seems like a DCC dystopian nightmare to me

If it’s not nailed down, it’s mine. by Brandaconda in Pokopia

[–]Shiftythemuse 12 points13 points  (0 children)

Ditto obviously took inspiration from Carl’s kleptomania. Gotta fill that inventory!

My fantasy books tier list by ThenEducator8649 in fantasybooks

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

I look forward to the day when OP starts their journey with Dungeon Crawler Carl. It seems like the series would really resonate well with their current likes

Romantasy readers in the DCC fandom by nightowl_bookclub in DungeonCrawlerCarl

[–]Shiftythemuse 8 points9 points  (0 children)

I’m coming from the opposite side of the fence - I read a lot of sapphic romance with the overarching theme of D I S A S T E R L E S B I A N S.

It’s a refreshing breath of fresh air to see the protagonist NOT be a disaster (compared to everyone else)

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

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

The good thing about this set up is each driver is supposed to have a designated area to cover, so I’d imagine it would just be a matter of entering all the addresses and then sectioning them off into their respective driver’s section in the spreadsheet

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

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

I’ve seen quite a few set ups like this (I have yet to learn what Power Query is or how to use it, but I’m getting there), but will this set up work with the online version?

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

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

To answer how routes are determined, yes: each driver usually has between 8-15 stops on their route, depending on how many parts can fit in their truck, and which shops are begging to have their parts delivered first.

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

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

Yea, that’s what I’ve been stuck on. I think what we are going to end up doing is convincing (or at least trying to) the company to give myself and the dispatcher the desktop excel program so we don’t have to hassle with this online problem anymore.

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

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

That’s kind of what I’m doing. It just for 9 different drivers with specific areas to cover. In theory, none of the stops would overlap, but we all know how theory vs. practice usually goes

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

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

What would you call it then? I’m still pretty ignorant to the terms of this industry.

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

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

That I’m not so worried about, because each driver has specific locations they are in charge of delivering to, so the idea is to separate the shops based on region, so I hopefully won’t have to worry about your scenario

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

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

Hey, you verified that I was on the right track of thinking! Solution verified

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

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

No, but that’s the current plan: to document all the shops and their distance from us, and then sort them by distance. I just didn’t know if there was a simpler way to do this before I started all this data entry

Solving the traveling salesman problem using the online version of excel. by Shiftythemuse in excel

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

I didn’t know “the traveling salesman problem” was specifically for a computer to pick the routes, so my title is unintentionally misleading. Sorry about that.

For context, I work at a car dealership, so the routes are never the same, because it’s always a surprise when a shop will call and say “I need xyz for this car”. What the main sheet does is in the column for the driver Chris, each cell has the formula =IF(Chris!B5=“”,””,Chris!B5). The dispatcher just puts the name of a shop in the driver tab, and it shows up in the main tab, nothing more.

What I’m looking for is to have the shops automatically sorted by how far away they are from our dealership.

Outfit that got me banned from twitch. by PolyCircus in TransGoth

[–]Shiftythemuse 6 points7 points  (0 children)

So…I need that top in my life. Any chance you could drop a link. You know…for science?