# Perfect Delve Calculator

**URL:** <https://community.gemsofwar.com/t/perfect-delve-calculator/75047>\
**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:** 20\
**Page:** 1

<div class="post-metadata">

**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:** [April 15, 2022, 7:36pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/1 "2022-04-15T19:36:56Z")

</div>

To use the program you need OpenOffice Calc ([https://www.openoffice.org/download/](https://www.openoffice.org/download/)) and a free acoount at [pCloud](https://www.pcloud.com/de/download-free-online-cloud-file-storage.html).

Download the file:

> **[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!

and open it. Afterwards use the pictures to put in the macro at the end of this textbox. Now you can work with the file. If you have questions, feel free to contact me.

Go to Tools\>Options\>OpenOffice\>Security\>Macro security  
Change it to Medium and ok

 ![Bild1](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/4/f/4f3bfce5ad08b8ca13070e9773a030bbbbb1d579.jpeg)

Go to Tools\>Macros\>Organize Macros\>OpenOffice Basic

Select My Macros\>Standard\>Module1\>Main and edit it

Copy the Macro below the following picture and paste it at the spot like in the picture.  
Press F5

 ![Bild2](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/8/4/8455dd1a9754214fcbf43057d16d16a567dddf69.jpeg)

Function get\_annotation\_picture(sCellname)  
on error goto errorhandler  
dim sFillBitmapURL as String  
oSheet = thisComponent.Sheets(0)  
oCell = oSheet.getcellrangebyName(scellname)  
oAnnotationShape = oCell.Annotation.AnnotationShape  
sFillBitmapURL = oAnnotationShape.FillBitmapURL  
oDrawpage = oSheet.drawpage  
for i = 0 to oDrawpage.count -1  
oShape = oDrawpage(i)  
if oShape.Name = “TargetGrafik” then  
oShape.GraphicURL = sFillBitmapURL  
exit for  
endif  
next i  
errorhandler:  
end function

---

<div class="post-metadata">

**Author:** ![igniteice](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/igniteice/32/67904_2.png) [@igniteice](https://community.gemsofwar.com/u/igniteice)\
**Post date:** [April 15, 2022, 8:58pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/2 "2022-04-15T20:58:08Z")

</div>

That’s way too complicated for most people. Here’s the general rule of thumb:

1. Always do higher multipliers first.
2. That’s it.

Every room has a multiplier that is visible. Rarity is NOT the same as the multiplier, but generally speaking a higher rarity does have a higher multiplier, but always double check, because that is definitely not always true.

The order you do the rooms in matters because your multiplier is added together along the way. Here’s an example:

| Level | 80 | | |
| --- | --- | --- | --- |
| Room | Points | Multiplier | Total Multiplier |
| 1 | 840 | 1.10 | 2.1 |
| 2 | 1040 | 1.50 | 2.6 |
| 3 | 1240 | 1.50 | 3.1 |
| 4 | 1380 | 1.35 | 3.45 |
| 5 | 1520 | 1.35 | 3.8 |
| 6 | 1580 | 1.15 | 3.95 |
| 7 | 1640 | 1.15 | 4.1 |
| 8 | 1680 | 1.10 | 4.2 |
| Boss | 7120 | 1.25 | 4.45 |
| Total points: | 18040 | | |

Let’s say we do the 1.35 rooms first though…

| Level | 80 | | |
| --- | --- | --- | --- |
| Room | Points | Multiplier | Total Multiplier |
| 1 | 840 | 1.10 | 2.1 |
| 2 | 980 | 1.35 | 2.45 |
| 3 | 1120 | 1.35 | 2.8 |
| 4 | 1320 | 1.50 | 3.3 |
| 5 | 1520 | 1.50 | 3.8 |
| 6 | 1580 | 1.15 | 3.95 |
| 7 | 1640 | 1.15 | 4.1 |
| 8 | 1680 | 1.10 | 4.2 |
| Boss | 7120 | 1.25 | 4.45 |
| Total points: | 17800 | | |

That’s a loss of 240 points, and if you’ve ever been a couple points off from getting that last reward stage, now you know why! (Always sometimes it really is impossible, and that’s usually in the older delves.)

---

<div class="post-metadata">

**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:** [April 15, 2022, 9:07pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/3 "2022-04-15T21:07:53Z")

</div>

> [@igniteice](#):
>
> - Always do higher multipliers first.
> - That’s it.

> Blockquote

From my experience and month of testing with my file your statement is definetly not true.

Test it out by yourself before you complain about my work.  
My file is for people who want to have the maximum out of their delves. Not more or less.

---

<div class="post-metadata">

**Author:** ![Shadowfeld](https://avatars.discourse-cdn.com/v4/letter/s/3ec8ea/32.png) [@Shadowfeld](https://community.gemsofwar.com/u/Shadowfeld)\
**Post date:** [April 16, 2022, 4:12am UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/4 "2022-04-16T04:12:31Z")

</div>

I will need some kind of 1 page, english walkthru so I can post your link in Library. Easy to see/understand. For reference, here is a 1 page walkthru by dinosuitgirl.

 ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/3/c/3c16c6f82c9c5e8a20aa44accd20b05555f17854.jpeg)

---

<div class="post-metadata">

**Author:** ![Wow](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/wow/32/76075_2.png) [@Wow](https://community.gemsofwar.com/u/Wow)\
**Post date:** [April 16, 2022, 6:17pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/5 "2022-04-16T18:17:45Z")

</div>

Thanks Cap!

---

<div class="post-metadata">

**Author:** ![igniteice](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/igniteice/32/67904_2.png) [@igniteice](https://community.gemsofwar.com/u/igniteice)\
**Post date:** [April 16, 2022, 8:06pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/6 "2022-04-16T20:06:25Z")

</div>

It is 100% true, I used my own spreadsheet from how the game calculates scores and the points match in-game every time.

Whenever you go into a room, you always want your multiplier to be the highest it can be. Sometimes that can mean taking a lower multiplier room first to get a higher one after it, but that is exactly what I said: get the highest multipliers first.

Let’s look at a scenario of two delves. In one, you’d have a straight path from the start to the boss. You can’t change anything about it. In that delve, your score is fixed. In another delve, you can do every single room in whatever order you want. In that scenario, you would ALWAYS want to do the highest multiplier first, then work your way down to the lowest.

Now mix those two delves together and you get delves where you have a few different paths (for instance, Warrens). In those scenarios, you would want to take the path that gets you the highest multiplier faster. So if one direction has a room with 1.1 and then 1.4, and the other direction has 1.2 and whatever after it, it may be beneficial to take the path to get the 1.4 first, then turn around and do the 1.2 path, depending on what’s after it, and what’s after the 1.4.

Let’s look at an example from an actual delve:

 ![image](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/1/a/1ae9e9524b8698c90d28e1d3c6b6ceace10b801f.jpeg)

Here’s the best score you can get:

| Level | 500 | | |
| --- | --- | --- | --- |
| Room | Points | Multiplier | Total Multiplier |
| 1 | 5250 | 1.10 | 2.1 |
| 2 | 5750 | 1.20 | 2.3 |
| 3 | 6500 | 1.30 | 2.6 |
| 4 | 7250 | 1.30 | 2.9 |
| 5 | 7750 | 1.20 | 3.1 |
| 6 | 8250 | 1.20 | 3.3 |
| 7 | 8750 | 1.20 | 3.5 |
| 8 | 9125 | 1.15 | 3.65 |
| Boss | 39000 | 1.25 | 3.9 |
| Total points: | 97625 | | |

And now the worst score:

| Level | 500 | | |
| --- | --- | --- | --- |
| Room | Points | Multiplier | Total Multiplier |
| 1 | 5250 | 1.10 | 2.1 |
| 2 | 5750 | 1.20 | 2.3 |
| 3 | 6250 | 1.20 | 2.5 |
| 4 | 6625 | 1.15 | 2.65 |
| 5 | 7125 | 1.20 | 2.85 |
| 6 | 7625 | 1.20 | 3.05 |
| 7 | 8375 | 1.30 | 3.35 |
| 8 | 9125 | 1.30 | 3.65 |
| Boss | 39000 | 1.25 | 3.9 |
| Total points: | 95125 | | |

Any other combination of room order will give you a score in between the worst and best. The earlier you get the 1.3 rooms, the better your score will be. The later you get the 1.15 room, the better your score will be. It’s really simple.

---

<div class="post-metadata">

**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:** [April 16, 2022, 10:30pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/7 "2022-04-16T22:30:20Z")

</div>

At first I have to say, that my calculator isnt just for events and gettin the highest score.  
It is also for normal delves after you completed all factions. You can use it to get also the highest amount of gold or glory. Whatever you prefer.  
But it also works for events to get the maximum possible score.

> [@igniteice](#):
>
> get the highest multipliers first.

And thats simply wrong!

If you use your method, you wont get the highest score in my example I give you here:

 ![A3](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/4/7/4754169f8418f5073041ab18b40e8de57725e6d3.png)

Calculate it in your way and let me know, when you’re done.

---

<div class="post-metadata">

**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:** [April 17, 2022, 2:41am UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/8 "2022-04-17T02:41:56Z")

</div>

![A1](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/9/3/9371854a476b85b627df6016eb7e1c60d30969b3.png)

As you can see, going for the highest multiplier first doesnt give you the best score 😉

---

<div class="post-metadata">

**Author:** ![igniteice](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/igniteice/32/67904_2.png) [@igniteice](https://community.gemsofwar.com/u/igniteice)\
**Post date:** [April 17, 2022, 3:17am UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/9 "2022-04-17T03:17:18Z")

</div>

Going for highest room first:

| Level | 500 | | |
| --- | --- | --- | --- |
| Room | Points | Multiplier | Total Multiplier |
| S | 5250 | 1.10 | 2.1 |
| 1 | 5500 | 1.10 | 2.2 |
| 2 | 6000 | 1.20 | 2.4 |
| 6 | 7000 | 1.40 | 2.8 |
| 3 | 7750 | 1.30 | 3.1 |
| 4 | 8250 | 1.20 | 3.3 |
| 5 | 8625 | 1.15 | 3.45 |
| 7 | 9000 | 1.15 | 3.6 |
| Boss | 38500 | 1.25 | 3.85 |
| Total points: | 95875 | | |

Going your way:

| Level | 500 | | |
| --- | --- | --- | --- |
| Room | Points | Multiplier | Total Multiplier |
| S | 5250 | 1.10 | 2.1 |
| 1 | 5500 | 1.10 | 2.2 |
| 2 | 6000 | 1.20 | 2.4 |
| 3 | 6750 | 1.30 | 2.7 |
| 4 | 7250 | 1.20 | 2.9 |
| 5 | 7625 | 1.15 | 3.05 |
| 6 | 8625 | 1.40 | 3.45 |
| 7 | 9000 | 1.15 | 3.6 |
| Boss | 38500 | 1.25 | 3.85 |
| Total points: | 94500 | | |

I don’t know what you were trying to prove, but getting the 1.4 room (Room 6 in top left) so late causes your multiplier to take longer to get maxed. They start out the same:

2.1 → 2.2 → 2.4

But then your way drops to 2.7, and my way goes to 2.8, then 3.1, then 3.3. By that time, you’re only at 3.05. You do 3 rooms behind the curve, hence the lower points.

---

<div class="post-metadata">

**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:** [April 17, 2022, 3:03pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/10 "2022-04-17T15:03:01Z")

</div>

You took the wrong route. It seems like you assume that the path I’d recomment would be the numbers in the picture, but thats just for the settings.

My way is

Deep Hive 1,1  
Faery Ring 1,3  
Cedric’s 1,2  
Dark King 1,4  
Bulette 1,2  
Bat Cave 1,15  
Goblin Kitchen 1,15

You can see it under “Best Path”

 ![A1_LI](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/8/1/81b1e39fc5ef9fd36994770ffe1e8f9595b40943.jpeg)

Now make your calculations again with my setting.  
You will see that the score will be the same, but my way will give you more gold or glory (whatever you set up).

I’ll give you a better example which will prove that your method, going always for the highest multiplier first, isn’t the the best way.

 ![A1](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/1/d/1dadf9daf13bc59b5fcafbd686c29b12f24a0707.png)

And here the numbers:

 ![A3](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/8/e/8e02cdd92513ba15906fabb2657cb0f07c7758a7.png)

---

<div class="post-metadata">

**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:** [April 17, 2022, 3:11pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/11 "2022-04-17T15:11:31Z")

</div>

I just wanna make clear that my sheet goes through all possible permutations of all possibilities depending on the faction and on the selections of max score in events, gold or glory and even starting multiplier which effects the outcome as well if you use i.e. city of thieves for farming (which will give you the start multiplier of 0,5).

Your method is good in general and works fine in a lot of cases, but my method grants you the absolute maximum.

---

<div class="post-metadata">

**Author:** ![igniteice](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/igniteice/32/67904_2.png) [@igniteice](https://community.gemsofwar.com/u/igniteice)\
**Post date:** [April 17, 2022, 4:04pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/12 "2022-04-17T16:04:40Z")

</div>

I’m not sure what you’re disagreeing with at this point…

> [@igniteice](#):
>
> Whenever you go into a room, you always want your multiplier to be the highest it can be. Sometimes that can mean taking a lower multiplier room first to get a higher one after it, but that is exactly what I said: get the highest multipliers first.

When I was doing delves, I would always input the numbers until I got the highest point value I could. I never assumed that my first path was the best one. If I did that, I wouldn’t have bothered to make the calculator in the first place.

---

<div class="post-metadata">

**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:** [April 17, 2022, 4:34pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/13 "2022-04-17T16:34:56Z")

</div>

That’s why I created my Calc sheet. It figures out the best possible way for whatever you need.  
Without using a calculator.  
Just input the room names and it calculates automatically which path is the best for your needs.

> [@igniteice](#):
>
> I’m not sure what you’re disagreeing with at this point…

I’m just saying that going always for the highest multiplier is wrong as you can see in my 2nd example.

If you dont believe me, it’s up to you, but my calculator works perfectly, coz it goes through all 5040 possible permutations you can have with 7 different rooms.  
Ofc there are way less permutations in factions like Primal Rift or The Warrens, but I included this in my calculator too.

Give it a try and use it by your own. You will see that I’m not wrong. And you will also see, that going for the highest multiplier first, isn’t the optimal solution.

---

<div class="post-metadata">

**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:** [April 17, 2022, 8:29pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/14 "2022-04-17T20:29:12Z")

</div>

I made some adjustments and changed the description to make it easier to understand 😉

Check top post

---

<div class="post-metadata">

**Author:** ![sylverscale](https://avatars.discourse-cdn.com/v4/letter/s/f17d59/32.png) [@sylverscale](https://community.gemsofwar.com/u/sylverscale)\
**Post date:** [April 17, 2022, 10:33pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/15 "2022-04-17T22:33:50Z")

</div>

Thank you for sharing this. It’s always really awesome when someone puts that much work into something and shares it with the community!

Did you share this on discord as well?

I might not use it myself to be honest as I’ll probably be way too lazy to set that up but it’s still awesome. 😁

---

<div class="post-metadata">

**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:** [April 18, 2022, 1:25am UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/16 "2022-04-18T01:25:57Z")

</div>

Havent shared it yet somewhere  
But you can share this webside if you want to or I can send it on discord  
CaptainAwesome#2384

---

<div class="post-metadata">

**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:** [June 4, 2022, 10:03pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/17 "2022-06-04T22:03:29Z")

</div>

Hey folks  
I made some minor adjustments:

- Added some missing permutations for wyrmrun (sorry about that 😉 )
- Added rarity to room selection  
 ![Unbenannt2](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/d/1/d18f24af52f9a8ff5aec32b7b0276bc50f26d567.png)

---

<div class="post-metadata">

**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:** [June 20, 2022, 9:47pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/18 "2022-06-20T21:47:18Z")

</div>

Fixed Eldrazhor which had wrong permutation

---

<div class="post-metadata">

**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:** [June 28, 2022, 11:11pm UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/19 "2022-06-28T23:11:07Z")

</div>

Fixed Dripping Caverns which had some missing permutations

---

<div class="post-metadata">

**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, 5:26am UTC](https://community.gemsofwar.com/t/perfect-delve-calculator/75047/20 "2022-07-01T05:26:40Z")

</div>

Fixed false image of Depths of Sin

“Dark mode” added 🕶

[Next page](https://community.gemsofwar.com/t/perfect-delve-calculator/75047.md?page=2)