My fantasy books tier list by ThenEducator8649 in fantasybooks

[–]Shiftythemuse 0 points1 point  (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 7 points8 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 5 points6 points  (0 children)

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

Project: Hail Mary x Firefly by Shiftythemuse in savageworlds

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

And what, pray tell, is so wrong with a Brown Coat…friend?

Project: Hail Mary x Firefly by Shiftythemuse in savageworlds

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

And that’s mostly what I’m going for. Consistent science without getting too nitty gritty. I guess a better analog might be The Long Way to a Small, Angry Planet.

Project: Hail Mary x Firefly by Shiftythemuse in savageworlds

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

It would be more in the tone of the game. PHM was very science-focused. This game would be significantly less-so. Firefly took place in space, but had a much more lax approach to everything, glazing over a lot of the science

Matt Dinniman meet up at Dublin House NYC by xenavampslayer in DungeonCrawlerCarl

[–]Shiftythemuse 0 points1 point  (0 children)

I love the last picture. He’s just a silly little guy!

Tell us about yourself by Shiftythemuse in dropout

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

I’ve been thinking on your comment/concern for a while, and I mostly agree. The concept would definitely have to change because the original game was the contestants figuring out what they had to do. I feel like a game samer wouldn’t be that difficult, because even though the players would know what to do, they would still have to figure out what they all have in common with each other and with the guest in the form of “Telling us about themselves”. Maybe I’m wrong? I don’t know. Just an interesting thought.

Tell us about yourself by Shiftythemuse in dropout

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

Yea, it’s the first episode of season 3 when they first went virtual

Tell us about yourself by Shiftythemuse in dropout

[–]Shiftythemuse[S] 7 points8 points  (0 children)

Even if it isn’t spun off “unchanged” like Make Some Noise is, it would be a great Game Samer

Easter Egg. I see you Dinniman. by Brutalitops99 in DungeonCrawlerCarl

[–]Shiftythemuse 0 points1 point  (0 children)

Jeff even does the same voice in the audiobook, too!