[Site] LWP : Leslie wheels profitability | Tools & Userscripts…
[Site] LWP : Leslie wheels profitability
    • TDup [2660552]
    • Role: Civilian
    • Level: 78
    • Posts: 2073
    • Karma: 1114
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Thread created on 20:29:09 - 08/10/21 (10 months ago)
    |
    Last replied 22:09:20 - 27/07/22 (15 days ago)
    [UPDATE 2022-05-24]
    We have now gathered 382,973 spins (!) from 684 players
    Wheel of Awesome is barely profitable,
    Mediocrity is a free $80k every day.

    [UPDATE 2021-12-06]
    We have now gathered 138,000 spins from 269 players.
    I've done probably the last update on this website (except for future bug fix) :
    From now on, API key is not necessary to see all the global data + profitability. (I fetch market prices server side with my own key)
    You can just go on the website and check the full wheels spins data.
    I'd like to thank everyone who contributed. I had fun making this, and I'm super glad you are using it

    [ORIGINAL POST]
    Hey fellow criminals,

    I've built up a website, Leslie Wheels Profitability (LWP) to gather the wheel spins data. I've seen a couple of personal attempts but no global one, which I believe is essential to have a big enough dataset for precise stats.
    This year, Ched & his team have released some additional logs, some related to casino history, which enabled this kind of project.
    Note that the API key needs to have been reset since 27/04/2021 to access this data (see this patch note)

    Some friends & players from my current factions alpha tested it, so there's already 5103 spins in total (from 6 players)
    We... got one PI! :)

    Feel free to use it to see your own stats (are you lucky?) and to help build up the relevance of this dataset.
    You can resubmit whenever you want, only new spins will be added to the database.

    Thanks !!

    If you have any idea, or question, feel free to share/ask here, or poke me in game!

    Misc
    Here's some info you can find on LWP:






    ps : Today I'm 227 day old, and I have 227 merits. Yeah, it has nothing to do with this thread I know
    Last edited by TDup on 19:23:52 - 24/05/22
    • MrRightSA [2652679]
    • Role: Civilian
    • Level: 50
    • Posts: 537
    • Karma: 524
    • Last Action: 4 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 20:42:58 - 08/10/21 (10 months ago)
    Post link copied to clipboard Copy post link
    Had to input twice as the first time it did not show my wheels so not sure if you now have my results twice in the list.  

    Very nice! I done this in Excel Power Query but didn't put it into a wheel. It showed I was VERY lucky on 50k spins, in profit in 1k spins and slight loss on 1mil spin. Overall... spin!
    • TDup [2660552]
    • Role: Civilian
    • Level: 78
    • Posts: 2073
    • Karma: 1114
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 20:46:17 - 08/10/21 (10 months ago)
    Post link copied to clipboard Copy post link

    MrRightSA [2652679]

    Had to input twice as the first time it did not show my wheels so not sure if you now have my results twice in the list.

    Very nice! I done this in Excel Power Query but didn't put it into a wheel. It showed I was VERY lucky on 50k spins, in profit in 1k spins and slight loss on 1mil spin. Overall... spin!
    Thanks for trying it! 

    You have to wait a couple of seconds for the wheels to appear.
    Don't worry about the duplicate data, events have an id, so there's no problem with that.
    • DuckOfDestiny [2663371]
    • Role: Civilian
    • Level: 62
    • Posts: 57
    • Karma: 30
    • Last Action: 11 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 00:02:40 - 10/10/21 (10 months ago)
    Post link copied to clipboard Copy post link
    my stats

    Fun
    Last edited by DuckOfDestiny on 00:03:10 - 10/10/21
    • Caio [2488372]
    • Role: Civilian
    • Level: 90
    • Posts: 885
    • Karma: 671
    • Last Action: 7 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 01:31:55 - 10/10/21 (10 months ago)
    Post link copied to clipboard Copy post link
    Nice site, looks like I'm somehow positive even at the 1m one... at least is the confirmation I needed to keep doing it... thank you!

    PEdLgmb.gifGood day,aa4xml5.gif

    • TDup [2660552]
    • Role: Civilian
    • Level: 78
    • Posts: 2073
    • Karma: 1114
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 03:49:26 - 10/10/21 (10 months ago)
    Post link copied to clipboard Copy post link

    Caio [2488372]

    Nice site, looks like I'm somehow positive even at the 1m one... at least is the confirmation I needed to keep doing it... thank you!
    Well, the best confirmation is the global data.
    Positive on the 3 wheels so far (as expected)

    Thanks for the good words!
    • TDup [2660552]
    • Role: Civilian
    • Level: 78
    • Posts: 2073
    • Karma: 1114
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 01:09:45 - 12/10/21 (10 months ago)
    Post link copied to clipboard Copy post link
    Bump! 

    Current facts:
    - 16481 spins now (from 25 players, thanks a lot y'all)
    - All wheels profitable
    - 4 PIs (With the current data : 0.08% chance to get a PI while spinning the Wheel of Awesome)
    - Spinning all 3 Leslie wheels give you $362k daily - on average -, almost the same than the daily beers (current beer price around $4k/unit)


    More infos:






    • DeKleineKobini [2114440]
    • Role: Committee
    • Level: 98
    • Posts: 3089
    • Karma: 4296
    • Last Action: 5 days
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:11:51 - 12/10/21 (9 months ago)
    Post link copied to clipboard Copy post link
    I quite like it. It's some great usage of the log api.

    All present bugs are only minor:
    - table sorting isn't correct when switching between wheels
    - first time it didn't show any result (already in your post, but who reads anyway? xD)

    I can confirm only the actual logs are send to the server. Fetching the data from the api is done locally, so the api key never is seen by the author or his server.
    • TDup [2660552]
    • Role: Civilian
    • Level: 78
    • Posts: 2073
    • Karma: 1114
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 15:39:00 - 12/10/21 (9 months ago)
    Post link copied to clipboard Copy post link

    DeKleineKobini [2114440]

    I quite like it. It's some great usage of the log api.

    All present bugs are only minor:
    - table sorting isn't correct when switching between wheels
    - first time it didn't show any result (already in your post, but who reads anyway? xD)

    I can confirm only the actual logs are send to the server. Fetching the data from the api is done locally, so the api key never is seen by the author or his server.
    Thanks a lot for the great feedback! 
    I'll fix those 2 bugs asap.

    Yeah, I went from a very tedious shared google spreadsheet method to this simpler way. (Really awesome to expose more & more stuff in API!)
    Last edited by TDup on 15:43:15 - 12/10/21
    • Awesome-O [2356036]
    • Role: Civilian
    • Level: 45
    • Posts: 393
    • Karma: 138
    • Last Action: 6 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 23:18:49 - 12/10/21 (9 months ago)
    Post link copied to clipboard Copy post link
    Just added my spins to the chart
    • bOydOSbEm [2246920]
    • Role: Civilian
    • Level: 92
    • Posts: 77
    • Karma: 31
    • Last Action: 1 minute
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 18:07:46 - 14/10/21 (9 months ago)
    Post link copied to clipboard Copy post link
    good stuff
    • TDup [2660552]
    • Role: Civilian
    • Level: 78
    • Posts: 2073
    • Karma: 1114
    • Last Action: 1 hour
      • 1
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 20:21:35 - 16/10/21 (9 months ago)
    Post link copied to clipboard Copy post link
    Updated with the following fix/changes:

    - Fixed data which was not always displayed after the very first login.
    - Fixed total spin count display (at the top) which was not up to date until using the toggle
    - Fixed item array sorting which used to get reset when switching views (also it's sorted by Total value desc by default now)
    - Fixed some currency format (and removed cents for better readability)
    - Added color formatting : Green when profitable, Red when not profitable
    - Display number of players who submitted their spins (currently 45, thank you all!)

    29190 spins collected!
    All wheels still profitable. 0.075% chance to get a PI
    Last edited by TDup on 20:25:23 - 16/10/21
    • 12112 [2678266]
    • Role: Civilian
    • Level: 29
    • Posts: 459
    • Karma: 921
    • Last Action: 4 months
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 22:51:42 - 16/10/21 (9 months ago)
    Post link copied to clipboard Copy post link
    This is an awesome tool!

    I put in my key to find I’m currently -2.5m on the Wheel of Not-So-Awesome, with profits of $500k on both of the other wheels… seems I’m due a PI
    • TDup [2660552]
    • Role: Civilian
    • Level: 78
    • Posts: 2073
    • Karma: 1114
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 18:33:41 - 17/10/21 (9 months ago)
    Post link copied to clipboard Copy post link
    Updated with the following :

    - Added Loss/Hosp/Honor in array, below wheels, as suggested here by Kaladin [2712913]
    Last edited by TDup on 18:34:19 - 17/10/21
    • TDup [2660552]
    • Role: Civilian
    • Level: 78
    • Posts: 2073
    • Karma: 1114
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 14:15:55 - 29/10/21 (9 months ago)
    Post link copied to clipboard Copy post link
    Updated with the following:

    - Added an offset on PI / Donator pack slices on the pie chart, so there are a bit more visible:

    • xanakin [2669088]
    • Role: Civilian
    • Level: 47
    • Posts: 117
    • Karma: 122
    • Last Action: 5 hours
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 17:34:36 - 30/10/21 (9 months ago)
    Post link copied to clipboard Copy post link
    This is AWESOME! Great job - thanks for creating this!
    • TDup [2660552]
    • Role: Civilian
    • Level: 78
    • Posts: 2073
    • Karma: 1114
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 00:44:44 - 05/11/21 (9 months ago)
    Post link copied to clipboard Copy post link
    Disabled the tool temporarily. 

    You can still see wheels, but can't type your API key to get your data.

    I've disabled it because I faced issues those past 2 days (I suspect related to the new API key system?) where logs events would not be retrieved properly using the "to" parameter.

    Busy life, no time to investigate for now. Will update/test again when I have the chance.
    • Caio [2488372]
    • Role: Civilian
    • Level: 90
    • Posts: 885
    • Karma: 671
    • Last Action: 7 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 06:16:15 - 08/11/21 (9 months ago)
    Post link copied to clipboard Copy post link
    was a great feature, hope you manage to figure out how to surpass the API new system problem;

    PEdLgmb.gifGood day,aa4xml5.gif

    • TDup [2660552]
    • Role: Civilian
    • Level: 78
    • Posts: 2073
    • Karma: 1114
    • Last Action: 1 hour
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 02:28:25 - 09/11/21 (9 months ago)
    Post link copied to clipboard Copy post link

    Caio [2488372]

    was a great feature, hope you manage to figure out how to surpass the API new system problem;
    Thanks a lot for this kind message.
    It gave me the motivation to look into it after work + kids XD

    I've re-enabled the tool, and addressed the issue.

    Updated with the following :

    - Added error handling for the new API changes.(I've added a one-click API key creation for a custom access needed - see Ched posts [1] [2])
    - Fixed vertical alignment issue that could happen with the arrow used to go from one wheel to the other
    • TogaHimiko [2720412]
    • Role: Civilian
    • Level: 50
    • Posts: 56
    • Karma: 54
    • Last Action: 15 minutes
      • 0
    • Reason:
      Are you sure you want to report this post to staff?
      Cancel
    Posted on 06:19:19 - 09/11/21 (9 months ago)
    Post link copied to clipboard Copy post link
    Great to see this working again!
Reply
Thread Title: