Prototyping Leaderboard / ChallengeBoard for Lord British's Castle (Invasion) Episode 2

Discussion in 'General Discussion' started by Winston, Mar 29, 2022.

Thread Status:
Not open for further replies.
Page 1 of 2
  1. Winston

    Winston A Data Guy Moderator SOTA Developer

    Messages:
    157
    Likes Received:
    436
    Trophy Points:
    18
    Gender:
    Male
    Location:
    San Antonio, Texas
    I'm doing data analysis on LB Castle in EP2.

    https://sotawiki.net/sota/Lord_British's_Castle_(Invasion)

    Teams (parties) and Solo people go into the Castle to see how far they get, and how fast they can go.
    I've developed scripts to pull data (again locally, not automatically in the game) to see how far people get.

    Here is some sample data.

    GOAL: A good "metric" would be try to have the smallest team reach Room 14 the fastest. I will work on some equations.

    This will allow us to examine which rooms are most challenging.

    People seem to get stuck after Room 5 ... solo and small groups anyway, or they get bored after 5-7 minutes.

    What do you all think of this idea?

    I can pull this data manually for experimentation. The DateTime is in UTC/ZULU. Subtract 5 hours and you have Central US (Austin, TX) time.

    Reach me if you and your teams are interested in doing some Runs through Lord British's Castle and becoming the best team (or solo person) with the best times! I can work on gathering data.


    CASTLE ROOMS (multiple waves to get to some of the rooms)

    Room RoomName
    14 Throne Room
    13 Library
    12 Royal Laboratory
    11 Music Room
    10 Receiving Area
    9 Soldier's Hall
    8 Servant Lounge
    7 Servant Dining
    6 Kitchen
    5 Shipping
    4 Theater
    3 Hedge Maze
    2 Fountain
    1 Garden


    GOOD SAMPLE IN LATE FEBRUARY 2022:

    Room Duration PartySize DateTime
    14 0:18:17 ... 6 ... 23-Feb-2022 at 03:11:49 Z
    14 0:26:44 ... 5 ... 23-Feb-2022 at 02:38:27 Z
    14 0:29:11 ... 7 ... 24-Feb-2022 at 06:20:38 Z
    11 0:29:22 ... 2 ... 24-Feb-2022 at 02:51:44 Z
    11 0:42:28 ... 1 ... 23-Feb-2022 at 06:22:04 Z
    8 0:26:06 ... 1 ... 24-Feb-2022 at 09:18:22 Z
    8 0:34:50 ... 1 ... 25-Feb-2022 at 15:04:21 Z
    7 0:18:27 ... 1 ... 23-Feb-2022 at 04:48:04 Z
    6 0:09:46 ... 1 ... 25-Feb-2022 at 20:05:40 Z
    5 0:04:31 ... 1 ... 23-Feb-2022 at 16:10:43 Z
    5 0:04:36 ... 1 ... 25-Feb-2022 at 14:01:36 Z
    5 0:04:46 ... 1 ... 24-Feb-2022 at 10:50:54 Z
    5 0:04:56 ... 1 ... 23-Feb-2022 at 02:09:49 Z
    5 0:05:04 ... 1 ... 23-Feb-2022 at 01:23:03 Z
    5 0:05:07 ... 1 ... 23-Feb-2022 at 01:55:31 Z
    5 0:05:11 ... 1 ... 23-Feb-2022 at 01:34:12 Z
    5 0:05:13 ... 1 ... 23-Feb-2022 at 02:22:41 Z
    5 0:05:32 ... 1 ... 23-Feb-2022 at 01:45:20 Z
    5 0:06:23 ... 1 ... 24-Feb-2022 at 11:25:13 Z
    5 0:07:02 ... 1 ... 23-Feb-2022 at 14:02:50 Z
    5 0:07:58 ... 1 ... 25-Feb-2022 at 17:15:14 Z
    5 0:08:33 ... 1 ... 25-Feb-2022 at 17:30:40 Z
    3 0:02:10 ... 1 ... 24-Feb-2022 at 02:12:36 Z
    2 0:00:47 ... 2 ... 23-Feb-2022 at 02:59:35 Z
    1 0:00:00 ... 1 ... 25-Feb-2022 at 02:41:23 Z
    1 0:00:00 ... 1 ... 24-Feb-2022 at 02:48:52 Z


    LAST 3 DAYS:

    Room Duration PartySize DateTime
    14 0:28:58 ... 2 ... 27-Mar-2022 at 00:39:53 Z
    12 0:29:16 ... 1 ... 27-Mar-2022 at 14:16:26 Z
    11 0:23:54 ... 1 ... 28-Mar-2022 at 17:33:17 Z
    9 0:19:04 ... 1 ... 28-Mar-2022 at 16:57:14 Z
    9 0:22:53 ... 1 ... 28-Mar-2022 at 01:31:08 Z
    9 0:31:19 ... 1 ... 28-Mar-2022 at 15:56:46 Z
    8 0:16:40 ... 1 ... 29-Mar-2022 at 01:15:11 Z
    7 0:16:17 ... 1 ... 29-Mar-2022 at 15:14:38 Z
    7 0:48:39 ... 1 ... 27-Mar-2022 at 13:22:21 Z
    6 0:08:56 ... 1 ... 29-Mar-2022 at 17:14:04 Z
    6 0:09:33 ... 1 ... 28-Mar-2022 at 08:02:41 Z
    6 0:09:50 ... 1 ... 27-Mar-2022 at 09:36:38 Z
    6 0:13:02 ... 1 ... 28-Mar-2022 at 17:19:42 Z
    5 0:04:49 ... 1 ... 29-Mar-2022 at 16:29:29 Z
    5 0:04:56 ... 1 ... 28-Mar-2022 at 14:31:06 Z
    5 0:05:12 ... 1 ... 27-Mar-2022 at 06:05:24 Z
    5 0:08:05 ... 1 ... 27-Mar-2022 at 11:13:59 Z
    5 0:12:33 ... 1 ... 29-Mar-2022 at 15:49:10 Z
     
    Winston, Mar 29, 2022
    #1
    Time Lord, Violet Ronso, Tirrag and 1 other person like this.
  2. Anpu

    Anpu Avatar

    Messages:
    7,944
    Likes Received:
    9,015
    Trophy Points:
    153
    Location:
    Hemut
    I love data, and I think these are some good metrics to gather. What the data could mean is however subjective, but you can always ask us.
     
    Anpu, Mar 29, 2022
    #2
    Violet Ronso, Tirrag and Winston like this.
  3. Gwendolyn Obscuro

    Gwendolyn Obscuro Bug Hunter

    Messages:
    595
    Likes Received:
    1,144
    Trophy Points:
    63
    While I would find the data interesting to look at I would caution against drawing any conclusions from it as to which rooms are most challenging. Especially if you are only looking at last room completed and not whether or not a further room was attempted.

    For example- at least 90% of the time I run LB Castle I stop after completing the Music Room. Does that mean the Laboratory is too hard for me? No, and looking at data you can see that if I start the Laboratory I complete it, and the same with the Library- I can very consistently clear those rooms solo. Why do I usually stop there? And why do I sometimes not stop there? Well because most of the time I go there I am in a loot collecting mood not a challenge mood. When I want a challenge I see if that is a day I can solo the Throne room (I could when it came out then I couldn't when it was made harder then I could when pet gear came out but then stats on pet gear were reduced, you get the theme but also depends on how many times I am willing to die and how many potions I am willing to use) If I am in a loot mood, especially when something has been added to the loot table recently, I know that by finishing the Music room I usually have all three encoded cards and all three keys to turn in on the way out. (but once in a while I have to do another room or two) And if I want to make potions I know that by finishing the Music room I can loot all that nice glassware in the Laboratory even if I don't fight that wave. And I know I have all the loot in the first two sets of chests but would need to put in a lot of effort and death risk to get to that last set.

    I'm pretty sure other people have their own stopping points not just related to difficulty- repeatedly farming the first set of chests for instance. And I know I'm not going to try to do the final room I don't take the potions that I would need for it, so I might get through the rooms I do slower. Unless I feel like seeing how fast I can go that day.... So yeah looking at the data is interesting but you'd really need to limit the variables to make it meaningful. And sorry for the rambling anyone who made it to the end of that :)
     
    Gwendolyn Obscuro, Mar 29, 2022
    #3
    Garfunkel Humperdinck, Coswald_Dirthmire, Adam Crow and 3 others like this.
  4. Turk Key

    Turk Key Avatar

    Messages:
    2,561
    Likes Received:
    4,012
    Trophy Points:
    153
    Gender:
    Male
    I usually stop at the lab or music room because lately I am only passing through till I get the recipe by then at the latest. But must point out that speed getting to the end is not really relevant because some time is spent between rooms to loot, buff up, take a nature break, get some coffee and etc. There really is no point going to the last room as far as I can see. I would spend more time in this scene if it were not for the petrified zombies. I avoid any place in game with them because the fight is so boring and the loot is so bad.
     
    Turk Key, Mar 30, 2022
    #4
    Anpu likes this.
  5. Winston

    Winston A Data Guy Moderator SOTA Developer

    Messages:
    157
    Likes Received:
    436
    Trophy Points:
    18
    Gender:
    Male
    Location:
    San Antonio, Texas
    Very, very good comments! Exactly what I seek to learn and help others learn as well.
    • Data is typically numbers (quantitative). Data is also observations and feedback (qualitative, like you are offering now).
    • Information is processed data to give relevance and usefulness.
    • Knowledge is where I seek to go: "meaning" from the information.
    • After we have knowledge, we can "draw conclusions, make predictions, and drive change".
    REF: https://seismic.com/blog/data-information-and-knowledge-whats-the-difference/

    So yes, there's quite a ways to go with my Data Analysis efforts, even for a simple case of LB's Castle! I am not at the data science point yet but have to start somewhere. "Data science refers to the process of extracting clean information to formulate actionable insights." Ref: https://builtin.com/data-science

    As you've pointed out, we must take into account players' goals and objectives when interpreting the information into knowledge, especially if we plan to make some data-driven decisions. Perfect! (I can see a SurveyMonkey in the makings here! I've done those before.)

    It's clear that data will tell us when/where people stop, but not why.

    I can gather and aggregate more data.
    • speed to the rooms (already did that)
    • number of items gathered
    • completion of the quest (cards and keys)
    • data from the vault
    My intent is to look at these scenes and develop ideas not just for leaderboards (which is just aggregated and sorted data), but for perhaps competitions and exhibitions (which can bring in humans to make events). Again, people go to LB's Castle for different reasons. Understanding those reason can help us interpret the data into knowledge and perhaps create some fun competitions.

    Perhaps (I'm just generating ideas here to focus the data layer a bit):
    • Throne Room Challenge (fastest to LB's Throne Room)
    • Gather Challenge (most or certain items gathered in a certain amount of time)
    • Solo Challenge (both of the above)
    • Quest Challenge (cards and keys)
    • Player Combat Challenge, er... Gladiator Challenge (includes flagged PVP players in the private party)
    • Vault Challenge (???)
    And this is not always about being the best/fastest. It may also be simple "completing" the Challenge and being recognized anonymously or by name, or you know you did it!

    Thanks! This is fun and quite a journey from Data to Challenges.
     
    Winston, Mar 30, 2022
    #5
    Anpu and Aldo like this.
  6. Winston

    Winston A Data Guy Moderator SOTA Developer

    Messages:
    157
    Likes Received:
    436
    Trophy Points:
    18
    Gender:
    Male
    Location:
    San Antonio, Texas
    Interesting, here are new runs in LB's Castle since I posted the initial data.


    2022-03-29T17:15:00.000Z (timestampStart)
    2022-03-30T12:42:46.000Z (timestampEnd)

    Room Duration PartySize DateTime
    12 0:50:28 ... 1 ... 29-Mar-2022 at 23:49:41 Z
    5 0:04:40 ... 1 ... 30-Mar-2022 at 07:46:18 Z
    5 0:06:01 ... 1 ... 30-Mar-2022 at 12:31:07 Z
    5 0:06:10 ... 1 ... 30-Mar-2022 at 09:10:25 Z
    1 0:00:00 ... 1 ... 29-Mar-2022 at 22:30:39 Z


    One person (solo) made it to the Throne Room in 50 minutes. Others stopped along the way for probably various reasons.

    I almost wish there was an optional query at the end of the scene, when people leave with something like:

    Why did you leave?
    • Completed the quest
    • Died and could not go further
    • Gathered loot that I needed
    • Got bored
    • ... more ...
     
    Winston, Mar 30, 2022
    #6
    Anpu and Aldo like this.
  7. Vaentorian

    Vaentorian Localization Team

    Messages:
    667
    Likes Received:
    1,186
    Trophy Points:
    93
    Location:
    UK
    Maybe by adding dialogue for the guard captain asking why they've abandoned the mission? Could be similar to the Oracle's daily test or when certain NPC's ask for the player's name, with a specific set of response keywords shown for that prompt.

    Edit: I'm assuming when players complete the scene you wouldn't need to ask why they're leaving...

    I don't know whether the existing system lets you tap into the responses but if you plan on doing this for a lot of other situations it might be worth adding that functionality.

    I don't know whether you'd want to force players into conversation as some would find it tedious, maybe better to have the NPC "hail" the avatar and pose the question instead of their usual hello. Some players will want to turn in keys/cards anyway so you'd at least catch a few that way even if they're not specifically looking for the survey.
     
    Vaentorian, Mar 30, 2022
    #7
    Winston likes this.
  8. Bridge Troll

    Bridge Troll Avatar

    Messages:
    441
    Likes Received:
    842
    Trophy Points:
    55
    Location:
    New World
    Be very careful about assuming people are bored. I haven't heard any complaints about the lb castle experience. It is one of my favorites to lead because a pickup group can do it with learning and effort.

    I would be curious to see your analysis of the compendium data, and how you would interpret that. It took me many tries to beat the last three rooms solo, and at times I would have stated they each sucked. The reality was, I needed to learn and revise my approach.
     
    Bridge Troll, Mar 30, 2022
    #8
    Sean Silverfoot, Sara Dreygon, Aldo and 2 others like this.
  9. Sara Dreygon

    Sara Dreygon Avatar

    Messages:
    1,678
    Likes Received:
    5,830
    Trophy Points:
    113
    Gender:
    Male
    @Winston Solo'd today if that helps. I still get turned around a lot and could have probably cut off a few minutes... last room is tough :-O

    Definitely super fun if there was a leaderboard, though. I liked challenging myself and would be fun to keep trying to beat your own - or others - times.
     
    Sara Dreygon, Mar 30, 2022
    #9
    Sean Silverfoot, Coswald_Dirthmire, Winston and 1 other person like this.
  10. Atticus Gryphonheart

    Atticus Gryphonheart Legend of the Hearth

    Messages:
    285
    Likes Received:
    411
    Trophy Points:
    28
    I'll give it a shot. Wish saw it earlier.
     
    Atticus Gryphonheart, Mar 31, 2022
    #10
    Sara Dreygon, Sean Silverfoot and Winston like this.
  11. kaeshiva

    kaeshiva Avatar

    Messages:
    3,054
    Likes Received:
    11,752
    Trophy Points:
    153
    Gender:
    Female
    I think its simply a matter of efficiency in some cases too, or reward not being worth the effort.

    As with the Compendium, fighting your way to the first round of chests and then leaving/resetting/doing something else is a far more efficient way to farm scene specific loot than struggling to finish the whole thing. The way these scenes are set up, with "everyone must be in position at the circle to spawn the next wave" is a neat concept but one that grows more and more impractical the larger your party, as it can take longer for people to get into position which delays the whole thing . Particularly if people are off looking for loot bags with keycards and such.

    This can be an irritating combination of circumstances and I would surmise part of the reason why you see so many solo runs through who probably bail after the first round of chests.

    Be interesting to see the builds of the people who finish it too (even just the specialisation choices would give an idea). I know for example that finishing this is a massively painful exercise for my main character (magic user) but playing it with a tamer is a walk in the park. Might be an informative way to balance some of the content, since crazy magic resistance is making more and more content in the game inaccessible to magic-reliant builds.

    In LB castle, "nuisance mobs" like the obsidian golem pretty much put a hard stop to anyone relying on any sort of magic - this isn't because its challenging, but rather because its nearly impossible for a caster to deal with one of these in a manner that doesn't involve tedious kiting/runabout or relying on changing to a weapon setup or pulling out a pet just for that fight. Unlike most scenes, were troublesome nuisance mobs can be skirted around or avoided, in LB castle you have no choice but to fight these to progress, which is enough to make me completely avoid going unless I'm with teammates I know can deal with it.
     
    kaeshiva, Mar 31, 2022
    #11
    Sara Dreygon and Winston like this.
  12. Winston

    Winston A Data Guy Moderator SOTA Developer

    Messages:
    157
    Likes Received:
    436
    Trophy Points:
    18
    Gender:
    Male
    Location:
    San Antonio, Texas
    -------------
    This is you @Sara Dreygon:
    14 0:27:48 ... 1 ... 30-Mar-2022 at 23:56:08 Z

    -------------
    Another Solo person almost made it to the end, a little slower but not by much
    13 0:38:40 ... 1 ... 31-Mar-2022 at 06:14:31 Z

    -------------
    I shadowed the second party of 4 (I am not counted) and a 5th person joined at the end, but did not show up in the partysize count (examining logs to see why not). We were not running for speed; it was for data discovery.
    14 1:20:07 ... 4 ... 30-Mar-2022 at 21:41:08 Z


    ==============
    timestampStart = 2022-03-30T10:00:00.000Z
    timestampEnd = 2022-03-31T11:15:03.000Z

    Room Duration PartySize DateTimeRoom1
    14 0:27:48 ... 1 ... 30-Mar-2022 at 23:56:08 Z
    14 1:20:07 ... 4 ... 30-Mar-2022 at 21:41:08 Z
    13 0:38:40 ... 1 ... 31-Mar-2022 at 06:14:31 Z
    8 0:15:24 ... 1 ... 31-Mar-2022 at 07:22:42 Z
    7 0:27:05 ... 1 ... 31-Mar-2022 at 05:24:27 Z
    5 0:06:01 ... 1 ... 30-Mar-2022 at 12:31:07 Z
    5 0:09:10 ... 1 ... 31-Mar-2022 at 05:27:46 Z


    Room RoomName
    14 Throne Room
    13 Library
    12 Royal Laboratory
    11 Music Room
    10 Receiving Area
    9 Soldier's Hall
    8 Servant Lounge
    7 Servant Dining
    6 Kitchen
    5 Shipping
    4 Theater
    3 Hedge Maze
    2 Fountain
    1 Garden

    Great points!
    • Choices between Speed, Quest items, and Party Size. Choices on personal goals (speed or loot).
    • Builds on players who can Solo or use small Parties to complete 14 rooms (if they reveal their builds ... would be fun to see a Twitch Livestream someday on this with clues and hints).
    • "nuisance mobs" - I guess to get through these involves player/party tactics (summon a pet, have more people in the party, whatever works best).

    Great information, thanks!
     
    Winston, Mar 31, 2022
    #12
    Sara Dreygon, Anpu, Aldo and 1 other person like this.
  13. Atticus Gryphonheart

    Atticus Gryphonheart Legend of the Hearth

    Messages:
    285
    Likes Received:
    411
    Trophy Points:
    28
    @Winston Guessing that 2nd solo that almost succeeded was me above. Failed the first night I tried which matches that day Was running perfect till I made a mistake to take pet off stay to follow. Then choked the rest of the night. But did it today/ Solo'd though died the first try on last room. Did succeed on the 2nd try.
     
    Last edited: Apr 7, 2022
    Atticus Gryphonheart, Apr 7, 2022
    #13
    Sara Dreygon, Anpu and Winston like this.
  14. Atticus Gryphonheart

    Atticus Gryphonheart Legend of the Hearth

    Messages:
    285
    Likes Received:
    411
    Trophy Points:
    28
    I guess the reason I wanted to do it was see if I still can. It is a challenge to complete.

    If rewards were more substantial, I would probably do this more often.

    Leader board does give me further reason to attempt...as is, I know can improve time (had a death...need to do a perfect run next time)

    After that I need to level up and possibly adjust build to compete with other peeps who can solo .

    Then maybe I can get to the top of the leader board.
     
    Atticus Gryphonheart, Apr 8, 2022
    #14
    Sara Dreygon and Winston like this.
  15. Winston

    Winston A Data Guy Moderator SOTA Developer

    Messages:
    157
    Likes Received:
    436
    Trophy Points:
    18
    Gender:
    Male
    Location:
    San Antonio, Texas
    I am returning to the LB Castle leaderboard more this weekend. I pulled this data since about the last time I ran the query with an hour overlap:

    timestampStart = 2022-03-31T10:00:00.000Z
    timestampEnd = 2022-04-08T12:51:51.000Z

    Room Duration PartySize DateTimeRoom1
    14 0:18:20 ... 2 ... 04-Apr-2022 at 16:11:57 Z
    14 0:33:05 ... 2 ... 01-Apr-2022 at 01:15:50 Z
    14 0:37:48 ... 1 ... 05-Apr-2022 at 12:40:09 Z
    14 0:56:19 ... 1 ... 07-Apr-2022 at 05:06:26 Z
    13 0:34:38 ... 1 ... 05-Apr-2022 at 03:31:15 Z
    13 0:54:17 ... 1 ... 31-Mar-2022 at 18:26:30 Z
    13 1:01:15 ... 1 ... 06-Apr-2022 at 07:18:08 Z
    12 0:52:59 ... 1 ... 07-Apr-2022 at 16:40:35 Z
    12 0:58:18 ... 1 ... 01-Apr-2022 at 15:41:46 Z
    11 0:22:32 ... 1 ... 02-Apr-2022 at 22:52:49 Z
    11 0:23:48 ... 1 ... 04-Apr-2022 at 23:50:10 Z
    10 0:14:52 ... 1 ... 03-Apr-2022 at 16:03:48 Z
    10 0:27:46 ... 1 ... 02-Apr-2022 at 00:22:27 Z
    9 0:18:57 ... 1 ... 31-Mar-2022 at 19:45:36 Z
    9 0:36:34 ... 1 ... 06-Apr-2022 at 13:28:15 Z
    8 0:14:41 ... 1 ... 04-Apr-2022 at 14:44:33 Z
    8 0:19:05 ... 1 ... 03-Apr-2022 at 22:08:31 Z
    6 0:09:22 ... 1 ... 05-Apr-2022 at 17:56:51 Z
    6 0:10:06 ... 1 ... 03-Apr-2022 at 09:49:08 Z
    6 0:12:12 ... 1 ... 03-Apr-2022 at 09:01:26 Z
    6 0:12:43 ... 1 ... 06-Apr-2022 at 20:51:23 Z
    6 0:13:10 ... 1 ... 01-Apr-2022 at 17:15:24 Z
    6 0:13:39 ... 1 ... 02-Apr-2022 at 09:07:31 Z
    6 0:13:40 ... 1 ... 05-Apr-2022 at 18:07:48 Z
    6 0:14:11 ... 1 ... 04-Apr-2022 at 16:33:37 Z
    5 0:04:27 ... 1 ... 04-Apr-2022 at 13:19:13 Z
    5 0:04:29 ... 1 ... 06-Apr-2022 at 09:05:23 Z
    5 0:04:39 ... 1 ... 02-Apr-2022 at 03:45:32 Z
    5 0:04:42 ... 1 ... 03-Apr-2022 at 13:21:49 Z
    5 0:04:46 ... 1 ... 31-Mar-2022 at 13:24:49 Z
    5 0:05:04 ... 1 ... 03-Apr-2022 at 12:12:51 Z
    5 0:05:09 ... 1 ... 04-Apr-2022 at 09:08:04 Z
    5 0:05:12 ... 1 ... 05-Apr-2022 at 06:00:39 Z
    5 0:05:21 ... 1 ... 02-Apr-2022 at 03:23:03 Z
    5 0:05:27 ... 1 ... 06-Apr-2022 at 06:56:18 Z
    5 0:05:28 ... 1 ... 31-Mar-2022 at 12:31:27 Z
    5 0:05:37 ... 1 ... 05-Apr-2022 at 09:06:51 Z
    5 0:05:53 ... 1 ... 06-Apr-2022 at 08:36:06 Z
    5 0:05:56 ... 1 ... 02-Apr-2022 at 19:59:56 Z
    5 0:06:30 ... 1 ... 02-Apr-2022 at 19:14:55 Z
    5 0:06:48 ... 1 ... 01-Apr-2022 at 19:45:33 Z
    5 0:07:01 ... 1 ... 08-Apr-2022 at 00:26:18 Z
    5 0:07:12 ... 1 ... 07-Apr-2022 at 07:28:09 Z
    5 0:07:17 ... 2 ... 04-Apr-2022 at 16:15:05 Z
    5 0:07:45 ... 1 ... 01-Apr-2022 at 17:46:27 Z
    5 0:08:18 ... 1 ... 08-Apr-2022 at 05:28:35 Z
    5 0:08:26 ... 1 ... 02-Apr-2022 at 07:18:34 Z
    5 0:08:30 ... 1 ... 05-Apr-2022 at 05:14:41 Z
    5 0:08:39 ... 1 ... 02-Apr-2022 at 13:16:06 Z
    5 0:08:48 ... 1 ... 06-Apr-2022 at 16:21:39 Z
    5 0:08:49 ... 1 ... 08-Apr-2022 at 06:02:52 Z
    5 0:08:49 ... 1 ... 02-Apr-2022 at 15:34:11 Z
    5 0:08:56 ... 1 ... 06-Apr-2022 at 04:58:42 Z
    5 0:09:02 ... 1 ... 03-Apr-2022 at 05:45:34 Z
    5 0:09:08 ... 1 ... 03-Apr-2022 at 05:15:22 Z
    5 0:09:24 ... 1 ... 05-Apr-2022 at 16:40:13 Z
    5 0:09:24 ... 1 ... 03-Apr-2022 at 15:21:19 Z
    5 0:09:40 ... 1 ... 01-Apr-2022 at 05:18:16 Z
    5 0:10:25 ... 1 ... 07-Apr-2022 at 20:17:21 Z
    5 0:10:30 ... 1 ... 07-Apr-2022 at 20:54:13 Z
    5 0:12:02 ... 1 ... 06-Apr-2022 at 19:08:31 Z
    4 0:05:26 ... 1 ... 08-Apr-2022 at 06:38:25 Z
    4 0:11:25 ... 1 ... 05-Apr-2022 at 20:27:17 Z
    2 0:00:42 ... 1 ... 06-Apr-2022 at 03:21:34 Z
    2 0:00:52 ... 1 ... 07-Apr-2022 at 15:26:02 Z


    Room RoomName
    14 Throne Room
    13 Library
    12 Royal Laboratory
    11 Music Room
    10 Receiving Area
    9 Soldier's Hall
    8 Servant Lounge
    7 Servant Dining
    6 Kitchen
    5 Shipping
    4 Theater
    3 Hedge Maze
    2 Fountain
    1 Garden


    Also, why am I doing this? The data queries to do this are very interesting and processing is a bit complex (I'm programming complex nested loops and looking for edge-cases that cause errors ... so fun ... and frustrating! Better than playing Sudoku for me.).

    I learn by doing, then share results that we can use to have fun! That's my design cycle.

    Keep track of your "run" date time and convert to UTC (lots of online converters from your time zone). Find your best times until I can give everyone some random names for the month, like I do on the Fishing Tournament and Treasure Hunt.

    Is this a data error or reality? Lots of people finish the Shipping area (Room 5), but die in the Kitchen (Room 6). I don't remember if we talked about this before. Monsters too tough? Enough loot found and bail out? Food is too distracting in the kitchen (yum!)?
     
    Winston, Apr 8, 2022
    #15
  16. Gwendolyn Obscuro

    Gwendolyn Obscuro Bug Hunter

    Messages:
    595
    Likes Received:
    1,144
    Trophy Points:
    63
    Are you sure they are dying in the kitchen or just not attempting it. In between those rooms is the first set of chests. Players trying to get the special loot that can appear in any of the three sets of chests will often stop after the first or second set if they can't easily make it to the next set in order to farm that particular loot.
     
    Gwendolyn Obscuro, Apr 8, 2022
    #16
    Sara Dreygon, Winston and Alley Oop like this.
  17. Winston

    Winston A Data Guy Moderator SOTA Developer

    Messages:
    157
    Likes Received:
    436
    Trophy Points:
    18
    Gender:
    Male
    Location:
    San Antonio, Texas
    Good point! That's what I want to look for in the data (another deeper level of query and analytics). Did people LeaveScene after Room 5, or experience DeathByMonster. I think I can aggregate that perhaps for each Room too.

    Thanks!
     
    Winston, Apr 8, 2022
    #17
  18. Vaentorian

    Vaentorian Localization Team

    Messages:
    667
    Likes Received:
    1,186
    Trophy Points:
    93
    Location:
    UK
    Death doesn't force people to leave, I have a few times died and resurrected at the ankh and continued fighting if I believe a room is doable and I just made a mistake... so there may be some correlation between death and leaving the scene but even in those cases dying may not be the sole/main motivator.
     
    Vaentorian, Apr 8, 2022
    #18
    Sara Dreygon, Winston and Anpu like this.
  19. Atticus Gryphonheart

    Atticus Gryphonheart Legend of the Hearth

    Messages:
    285
    Likes Received:
    411
    Trophy Points:
    28
    Are you able to see who goes into the vault afterwards? Can probably associate title based on if they raid the vault or not.

    Nvr gone in...so not sure what is there. Nvr took the virtue hit.
     
    Atticus Gryphonheart, Apr 9, 2022
    #19
    Winston likes this.
  20. Atticus Gryphonheart

    Atticus Gryphonheart Legend of the Hearth

    Messages:
    285
    Likes Received:
    411
    Trophy Points:
    28
    Finally...perfect run. Not sure if I can shave any more time off (besides through leveling up and increasing skill levels). So guess what time you have for me is gonna be my best time for awhile.

    Was fun.
     
    Atticus Gryphonheart, Apr 9, 2022
    #20
    Winston, Sara Dreygon and Enfo like this.
Page 1 of 2
Thread Status:
Not open for further replies.