# Perfect Delve Calculator **URL:** \ **Category:** Community Content\ **Created:** [April 15, 2022, 7:36pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047 "2022-04-15T19:36:56Z")\ **Posts on this page:** 17\ **Page:** 2
**Author:** ![CaptainAwesome](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/captainawesome/32/74890_2.png) [@CaptainAwesome](https://community.gemsofwar.com/u/CaptainAwesome)\ **Post date:** [July 1, 2022, 11:35pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/21 "2022-07-01T23:35:45Z")
-Added Deep Delves (marked with # as first letter of the faction in the faction selection dropdown) -Added new gnome room to the table -Added Crypt Keepers Deep Delve (called Crypt Keepers 2) -removed the description (coming back soon, just needed to hurry coz of the current faction event) > **[New Faction Event Calculator.ods - Shared with pCloud](https://e1.pcloud.link/publink/show?code=XZrQVLZfC0IrnlW3rSRV0f6dBO0dkFj6uby)** > > Keep all your documents safe, access them on any device you own and share with just the right people. Create a free pCloud account! -All-Seeing Eye will be added soon -Graphic of Crypt Keepers 2 will be reworked soon, but it’s currently workin as intended ---
**Author:** ![Starlite](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/starlite/32/43018_2.png) [@Starlite](https://community.gemsofwar.com/u/Starlite)\ **Post date:** [July 8, 2022, 9:24am UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/22 "2022-07-08T09:24:41Z")
Are you using a brute-force calculation, or is there a more mathematical way to handle the permutations? I’ve been trying to figure out a good way to handle the complexity for ages! ---
**Author:** ![CaptainAwesome](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/captainawesome/32/74890_2.png) [@CaptainAwesome](https://community.gemsofwar.com/u/CaptainAwesome)\ **Post date:** [July 8, 2022, 9:08pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/23 "2022-07-08T21:08:02Z")
Well it took me a few month and I had to start from scratch two times. What I did in the beginning was gettin all permutations (5040) and insert them in a column. Then I used the MID() function to get every number in 7 seperated columns for each row. That way i got kick off for the rest which took me around 4 month to finish it. The most trouble I had was with the pics. I had to let me create the macro which you see above and had to add comments which are hidden in the A column. There are still a few things that have to be done manually i.e. mark the vaiable permutations for each faction, but thats kinda easy and just takes a like an hour for each faction. Visible from column BU:FE (left some space there for upcomin factions). If you are more interested in that monster, you can also fade in the columns H:FE and the rows 30:5041 to see everything. Just be aware of that every function is in german. ---
**Author:** ![Shivandri](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/shivandri/32/76106_2.png) [@Shivandri](https://community.gemsofwar.com/u/Shivandri)\ **Post date:** [July 8, 2022, 10:05pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/24 "2022-07-08T22:05:15Z")
Hi @CaptainAwesome, Thanks for putting so much time in your spreadsheet and sharing that here! Im real interesting in it but must look if I can use it with my visual disorder and its in German as I understand you right. Now mI delving with highest multipliers theory. Tomorrow Im gonna take a better look on your project! 🤩 ---
**Author:** ![CaptainAwesome](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/captainawesome/32/74890_2.png) [@CaptainAwesome](https://community.gemsofwar.com/u/CaptainAwesome)\ **Post date:** [July 8, 2022, 10:51pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/25 "2022-07-08T22:51:16Z")
It’s in every ingame language Mostly translated by using an online translator > [@Shivandri](#): > > Im real interesting in it but must look if I can use it with my visual disorder and its in German as I understand you right. Just the functions. I used the german wording coz my settings are in german and that sheet is complicated enough so I didnt wanna translate every function when there is no need to do that ---
**Author:** ![Shivandri](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/shivandri/32/76106_2.png) [@Shivandri](https://community.gemsofwar.com/u/Shivandri)\ **Post date:** [July 9, 2022, 11:40am UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/26 "2022-07-09T11:40:24Z")
Hi @CaptainAwesome, I can understand you kept the German language in your sheet for sure if its complicated by itself the language will not be a problem for me Im not unknown with German and otherwise there are enough language tools to understand every language you want 😉 I will look at it for sure, and hopefully it will help me by delving! Have a great weekend! ---
**Author:** ![CaptainAwesome](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/captainawesome/32/74890_2.png) [@CaptainAwesome](https://community.gemsofwar.com/u/CaptainAwesome)\ **Post date:** [July 9, 2022, 12:12pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/27 "2022-07-09T12:12:21Z")
Maybe you overread the point where I said it’s in every ingame language. You can select between english, german, spanish, french, italian, russian and chinese. ![grafik](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/d/7/d7fb867b88b090b45af579ac9a704139a1ac4724.png) Updates for All-Seeing Eye#2 will follow the upcoming week probably ---
**Author:** ![Shivandri](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/shivandri/32/76106_2.png) [@Shivandri](https://community.gemsofwar.com/u/Shivandri)\ **Post date:** [July 9, 2022, 12:26pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/28 "2022-07-09T12:26:06Z")
No I had read that but thanks! Im atm install the programs that are needed for this 😉 Okay, thats a lot to read/see and find out how everything works, this will take a much longer time for me. If I have questions, I will find my way to you 😉 Then you come to the point you realize OMG its far from easy at all 😵‍💫 😜 ---
**Author:** ![CaptainAwesome](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/captainawesome/32/74890_2.png) [@CaptainAwesome](https://community.gemsofwar.com/u/CaptainAwesome)\ **Post date:** [July 11, 2022, 4:53am UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/29 "2022-07-11T04:53:33Z")
-added All-Seeing Eye 2 be aware of the notification in the explanation for All-Seeing Eye 1 & 2 ![grafik](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/a/2/a2a9a4257d1fb7973d7b9bc546a96f474a3c193c.png) ---
**Author:** ![CaptainAwesome](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/captainawesome/32/74890_2.png) [@CaptainAwesome](https://community.gemsofwar.com/u/CaptainAwesome)\ **Post date:** [August 5, 2022, 7:37am UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/30 "2022-08-05T07:37:56Z")
-Obsidian Depths added > **[New Faction Event Calculator.ods - Shared with pCloud](https://e1.pcloud.link/publink/show?code=XZrQVLZfC0IrnlW3rSRV0f6dBO0dkFj6uby)** > > Keep all your documents safe, access them on any device you own and share with just the right people. Create a free pCloud account! ---
**Author:** ![Helvellyn](https://avatars.discourse-cdn.com/v4/letter/h/bbe5ce/32.png) [@Helvellyn](https://community.gemsofwar.com/u/Helvellyn)\ **Post date:** [August 5, 2022, 6:16pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/31 "2022-08-05T18:16:10Z")
This is admirable work but i am a little surprised that people approach delves in this way. I don’t really look at the multipliers at all; I look at the teams. If I am running an AoE deck like QB or tesla then I will leave the tidal room as late as I can, and the same goes for Bulette or Cedric to avoid reshuffle. Rewards for me are irrelevant; I just want the latest rendition of delve done and dusted ASAP, never to be repeated even when the 5th troop lands during deep delve. I will just open portals when it lands and ascend occasionally with an orb. I admire your dedication but my idea of a “perfelt delve” is the one that takes as little time as possible. The rewards don’t even register. ---
**Author:** ![CaptainAwesome](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/captainawesome/32/74890_2.png) [@CaptainAwesome](https://community.gemsofwar.com/u/CaptainAwesome)\ **Post date:** [August 5, 2022, 6:55pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/32 "2022-08-05T18:55:21Z")
I wouldn’t have created this calculator if I wouldn’t be “in this way” 😉 I just wanted to give me the opportunity to get everything be done perfectly. And I wanted to share it with the community. Everyone has his own playtstyle. So it’s up to you to use it or not. And besides I’m some kind of a perfectionist 😛 ---
**Author:** ![ANGI](https://avatars.discourse-cdn.com/v4/letter/a/8dc957/32.png) [@ANGI](https://community.gemsofwar.com/u/ANGI)\ **Post date:** [August 5, 2022, 7:22pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/33 "2022-08-05T19:22:48Z")
typical German 😉 ---
**Author:** ![MadDwarf](https://avatars.discourse-cdn.com/v4/letter/m/eb8c5e/32.png) [@MadDwarf](https://community.gemsofwar.com/u/MadDwarf)\ **Post date:** [August 5, 2022, 8:48pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/34 "2022-08-05T20:48:47Z")
Kudos! I have my own full permutation delve tool I wrote some time back, but it wouldn’t have occurred to me to try putting it in Excel. Recursion in VBA… brrrr. You could probably save some time by pre-computing valid paths for a given faction. Any 9-room faction has a full permutation set of 5,040 paths excluding start/end rooms, as you mentioned, but Obsidian Depths for example only has 10 valid path permutations. Granted, that won’t save you anything in a wide-open delve like City of Thieves, but most are more constrained than that. ---
**Author:** ![CaptainAwesome](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/captainawesome/32/74890_2.png) [@CaptainAwesome](https://community.gemsofwar.com/u/CaptainAwesome)\ **Post date:** [August 5, 2022, 8:58pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/35 "2022-08-05T20:58:20Z")
Don’t you think I’m already aware of this and coded my OO Calc sheet in that way? 😜 Some factions like obsidian depths are probably not worth the effort, but for others it comes in handy 😉 And saving time by “pre-computing valid paths for a given faction” is quiet complicate if you have no idea how it will look like in advance. Or do you want me to make a whole sheet for every single faction if it can be provided by one sheet? ---
**Author:** ![CaptainAwesome](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/captainawesome/32/74890_2.png) [@CaptainAwesome](https://community.gemsofwar.com/u/CaptainAwesome)\ **Post date:** [August 26, 2022, 6:25pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/36 "2022-08-26T18:25:54Z")
Hall of Guardians 2 available now > **[New Faction Event Calculator.ods - Shared with pCloud](https://e1.pcloud.link/publink/show?code=XZrQVLZfC0IrnlW3rSRV0f6dBO0dkFj6uby)** > > Keep all your documents safe, access them on any device you own and share with just the right people. Create a free pCloud account! Sorry for being late XD ---
**Author:** ![hikaru259](https://avatars.discourse-cdn.com/v4/letter/h/f08c70/32.png) [@hikaru259](https://community.gemsofwar.com/u/hikaru259)\ **Post date:** [October 26, 2023, 4:36pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/37 "2023-10-26T16:36:08Z")
Thank Cap for your hard work. I use your code but it say same error ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/a/4/a47b5f9cfb79b8e65dab668ff7db002a60458641.png) Do I need to do anything or just use as normally? Thank you [Previous page](https://community.gemsofwar.com/t/perfect-delve-calculator/75047.md?page=1)