# Personal Dungeon Door Tracker **URL:** \ **Category:** Gameplay Chat (General)\ **Created:** [October 12, 2022, 3:46am UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336 "2022-10-12T03:46:29Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [October 12, 2022, 3:46am UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/1 "2022-10-12T03:46:29Z")
Hey all! I’ve created a nice spreadsheet template for everyone to record their personal Dungeon door rates. Feel free to **make a copy** of this Sheet and record your own data! > **[New GoW Dungeon Tracking Template](https://docs.google.com/spreadsheets/d/1q1kercpLK6-e4ykj7J07fBxSNj3tWfaXDn9RK8Lcr7Y/edit?usp=drivesdk)** > > Main > > Door 1,Door 2,Door 3,Door 4,Door 5,Door 6,Perfect?,Door Order,Total Tracked:,0 days,Perfect Rate: > Door 1 Result,Result Percent,Door 2 Result,Result Percent,Door 3 Result,Result Percent > 0%,0%,0% > 0%,0%,0% > 0%,0%,0% > 0%,0%,0% > 0%,0%,0% > 0%,0%,0% > Door... Example: ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/b/1/b18cf71451f79e2c2e191a744efb51e1eb20f7d4.png) ---
**Author:** ![AMT](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/amt/32/56829_2.png) [@AMT](https://community.gemsofwar.com/u/AMT)\ **Post date:** [October 12, 2022, 4:35am UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/2 "2022-10-12T04:35:50Z")
…with a reminder once/if patterns arise that mods may be eager to ‘do their job’ and report to the Devs instead of letting the playerbase have a small non-economy-breaking joy (hopefully this documented fact is not seen as ‘insulting’ by the powers that be 🙄), so bear that in mind when sharing such information on this forum. 😊 🖖 ---
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [October 12, 2022, 1:59pm UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/3 "2022-10-12T13:59:35Z")
Seconded. Please be wary of sharing your data on these forums. Community Discords are likely a better place for them. ---
**Author:** ![gow](https://avatars.discourse-cdn.com/v4/letter/g/e9c0ed/32.png) [@gow](https://community.gemsofwar.com/u/gow)\ **Post date:** [October 12, 2022, 2:54pm UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/4 "2022-10-12T14:54:19Z")
Do NOT post any more data on this forum ever! ---
**Author:** ![Diamond](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/diamond/32/84316_2.png) [@Diamond](https://community.gemsofwar.com/u/Diamond)\ **Post date:** [October 12, 2022, 5:24pm UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/5 "2022-10-12T17:24:07Z")
I cant the excel used! ---
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [October 12, 2022, 6:07pm UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/6 "2022-10-12T18:07:00Z")
You will need to make a copy of the sheet and edit the copy 😄 ---
**Author:** ![Setekh79](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/setekh79/32/101761_2.png) [@Setekh79](https://community.gemsofwar.com/u/Setekh79)\ **Post date:** [October 13, 2022, 12:01pm UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/7 "2022-10-13T12:01:31Z")
Make sure no data is disseminated on this forum if any patterns are found. ---
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [October 23, 2022, 8:05pm UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/8 "2022-10-23T20:05:49Z")
**Update** Added a few QoL things to the template based on improvements by @mitamata ! - The first row now includes a count of total days tracked. - Cells are now color-coded (red = trap; yellow = other; green = boss) - The data tables now create a gradient based on values (see example below) Enjoy! Example: ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/2/6/263a344747216ed77daecc476534c669b1a7fa7c.png) ---
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [October 29, 2022, 10:39pm UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/9 "2022-10-29T22:39:35Z")
**Update** - Labels in data boxes are now color-coded, not just their values. Example: ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/5/0/5046ae12c63c5ec8d93073f7d218ce4efe7f88f6.png) ---
**Author:** ![Jonathan](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/jonathan/32/66724_2.png) [@Jonathan](https://community.gemsofwar.com/u/Jonathan)\ **Post date:** [October 30, 2022, 6:52am UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/10 "2022-10-30T06:52:15Z")
Is there anything to track opening order? I’d be interested to see if any personal trends can be explained/negated by order, or if there are any global order trends 🤔¯⁠\⁠\_⁠(⁠ツ⁠)⁠\_⁠/⁠¯ (e.g. % traps behind 2nd selection, regardless of position). ---
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [October 30, 2022, 5:06pm UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/11 "2022-10-30T17:06:48Z")
If someone makes a simple way to track that, I’m down. I can’t think of an efficient way for it, as I’m not well-versed in spreadsheets. ---
**Author:** ![mitamata](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/mitamata/32/10313_2.png) [@mitamata](https://community.gemsofwar.com/u/mitamata)\ **Post date:** [October 31, 2022, 5:42pm UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/12 "2022-10-31T17:42:41Z")
> [@NerdieBirdie](#): > > If someone makes a simple way to track that, I’m down. The way I did it for me is, I recorded the open order as “123456” for example in a column, then extrapolated what was behind “n-th open door” into a new table. Here’s an example: [GoW Dungeon Tracker Template (with order) - Google Sheets](https://docs.google.com/spreadsheets/d/1Pyx3GtcB-oi-GpXJez9vpznhYr_mwkGcw1hweGqrDRA/edit?usp=sharing) (check new sheet) ---
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [November 1, 2022, 4:05am UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/13 "2022-11-01T04:05:12Z")
Interesting! Hmu on Discord if you’ve found any notable potential patterns by door order. ---
**Author:** ![NerdieBirdie](https://sea1.discourse-cdn.com/flex019/user_avatar/community.gemsofwar.com/nerdiebirdie/32/103793_2.png) [@NerdieBirdie](https://community.gemsofwar.com/u/NerdieBirdie)\ **Post date:** [December 7, 2022, 1:04am UTC](https://community.gemsofwar.com/t/personal-dungeon-door-tracker/77336/14 "2022-12-07T01:04:58Z")
Updated to include tracking for perfect runs. You can enter “1” in the perfect column for perfect runs, otherwise you can leave it blank. Please note that 10% is the theoretical average. If there is any distinguishable pattern, you should hopefully see averages above 10% especially as you gather more data. ![](https://us1.discourse-cdn.com/flex019/uploads/gemsofwar/original/3X/c/4/c4b9b3fd582c45a17d7c0e0bf35622f905b6729a.png)