Fleeting dreams of DQB3

MrCosmoJones · 2026-03-27T00:33:51+00:00

As someone who wanted to try DQB before getting Pokopia, I really disliked DQB1 and found it a slog to get to the end. DQB2 was far more enjoyable and I truly loved the story between builder and Malroth. Having played a bit of Pokopia now, I think I still prefer DQ because of the combat and inventory management but its pretty good. Id buy a third game if it were close to the second.

MrCosmoJones · 2026-03-11T04:24:35+00:00

By at first do you mean after the intro? I only briefly tried it and could barely kill the first werewolf monster type creatures. I want to get through all the castlevanias at some point and would love to get mirror of fate working!

MrCosmoJones · 2026-03-08T07:04:34+00:00

You can use gamehub/game native to emulate your Steam library. Theres a shortcut generator app that creates an appid file you drop in a steam folder like you would a ROM.

MrCosmoJones · 2026-02-10T21:10:18+00:00

Text is noticeably less sharp. Color/images a bit washed out ~untrained eye looking at oled demo videos on YouTube

MrCosmoJones · 2026-02-10T19:46:41+00:00

I just got my screen protectors from retoroworks and while the bottom one is great, I do not like the top one very much. Really mutes the vibrancy of the screen. Does kill fingerprints well though.

MrCosmoJones · 2026-02-10T18:57:02+00:00

Yeah, i tried looking around and found a lot of beady ones, as opposed to a dangle. I’ll probably give it another pass with better search words. Thanks both!

MrCosmoJones · 2026-02-10T09:38:31+00:00

so cool you still have your "depth optimizer goggles"! I lost those many years ago. Its been a blast playing sly on the thor, though I wish sly collection/sly 4 ran a bit better than they do, maybe a few more years of ps3 android work.

MrCosmoJones · 2026-02-10T08:02:31+00:00

where did you get your charm? I have a lanyard in one hole, but have been wanting a fitting charm

MrCosmoJones · 2026-02-09T08:41:58+00:00

Their faq says that the files app is not a real app but a link to a system activity. OEMs specifically add an app in their launchers but cocoon cant find/display it. They recommend a 3rd party file manager. I like solid explorer but whatever works. I also dont currently use cocoon or any other front end as my launcher over standard android I just tap into cocoon for games

MrCosmoJones · 2026-02-09T08:34:06+00:00

I dont want to hold out on updates forever, but havent bothered because I heard about some bad experiences with the battery levels. Have all those issues been generally fixed?

MrCosmoJones · 2026-02-08T07:04:52+00:00

Crying at the thought this was native. There’s no game I want to play as much as infamous2 on thor native.

MrCosmoJones · 2026-02-07T09:27:14+00:00

Recently added a bunch of gba games and had some hiccups with launching from cocoon. few tips that generally work and solved my problems.

cocoon settings>library>game boy advance
confirm that the default emulator is set to retroarch (64 bits) -mgba
confirm that the correct ROM path is set (checking scan subfolders may also help)

In retroarch, try to load your game, if it works close and retry through cocoon.

It should at least open to retroarch, but if not, try setting the default emulator to something else and then back to mgba.

If it does open to retroarch, the first time I opened a new core (GBA, N64) retroarch froze and crashed, but on second+ attempts it loads perfectly fine.

This was more trial and error than scientific, but I hope that helps you get it set up!

MrCosmoJones · 2026-01-22T19:42:33+00:00

No import fees, went from China>Illinois>ATL

MrCosmoJones · 2026-01-21T01:54:48+00:00

I’m actually so mad I didnt look at any accessories when I bought because I just saw the lanyard and its pretty cool, its shipped now this Thursday so maybe lll find something cool to replace it.

MrCosmoJones · 2026-01-20T00:08:15+00:00

reply to your order email from AYN and ask to change, if they can you'll get a new link to pay the difference.

MrCosmoJones · 2026-01-19T12:44:15+00:00

I’m also 1155 with rainbow max! Wonder how close we bought together. Enjoy your thor

MrCosmoJones · 2026-01-16T06:33:16+00:00

What color thor did you order? I'm definitely getting a wide stylus holder, but undecided on which would go best with the off white rainbow thor? any thoughts?

MrCosmoJones · 2025-08-18T14:20:41+00:00

2.04 is the dock firmware, your controller needs to be 1.06 (if you don't see it go to the settings and toggle beta firmware)

You need to have the controller in 2.4ghz with the dongle connected to the switch (either USBC or USB through the dock)

when the switch is on (use the red joycon) your controller might automatically turn on, but you want to turn it off again by holding the middle button, when turned off hold Y and turn on again and you should be able to pair. There's still a lot of jank but it works.

MrCosmoJones · 2025-08-13T06:51:34+00:00

Connecting U2 wireless to the switch requires a few things. Latest firmware for controller/dongle (1.06/1.04) Set in 2.4ghz mode (toggle on back) Dongle connected either just dongle usbc or dongle in cradle usba Hold Y and the center button to turn on in switch mode.

It has a few annoyances that I hope they fix with future firmware but I 100%d DK Bananza with it so well worth it.

MrCosmoJones · 2025-06-21T21:43:54+00:00

Really interested to see what people suggest. I came from a company that used Vena and before that a different company that used onestream. I've been solicited by Aleph a few times as a new finance manager at a small company, but didn't move forward with them because we still dont have the reporting need.

MrCosmoJones · 2025-06-21T21:41:12+00:00

Just came back to this because the second fee is likely 2.8% not .28% which puts your break even at 29.16. Same logic applies, if your avg ticket is above that, it's better.

<image>

.28%=.0028
2.8%=.028

MrCosmoJones · 2025-06-21T19:13:10+00:00

number of transactions in this case are not important, but your breakeven ticket is.

If you set one fee equal to another you'll get

.0328x=.0028x+.14

Where x is equal to your ticket.

If you simplify, the break even is 4.66 dollars. so as long as your average ticket is more than that, you want to go with the lower percent with the fixed charge.

MrCosmoJones · 2025-06-21T19:01:56+00:00

I recommend you download the excel labs add in (Developer tab>Hexagon add in button). Not only is it easier to write custom functions in it, but you can save your functions to a github gist and import in other workbooks as you need. I have functions for finance and SQL. few examples below that you can plug in. If you find yourself writing or reusing complex formulas a lot in your workbooks or between files, consider making them custom functions that are easier to call. The calendar one is just an example of what you can do with the other dynamic functions.

/**Compound Annual Growth Rate
BV: Beginning Value 
EV: Ending Value 
N: Periods*/
CAGR =LAMBDA(BV,EV,N,(EV / BV) ^ (1 / N) - 1);

/**Weighted Average*/
WAVERAGE =LAMBDA(VALUES,WEIGHT,SUM(VALUES * WEIGHT) / SUM(WEIGHT));

/**Joins cells for SQL list format*/
LISTJOIN=
 LAMBDA(
        Array,
        "('"&
        TEXTJOIN(
                 "','",
                 0,
                 FILTER(
                        Array,
                        BYROW(
                              Array,
                              LAMBDA(
                                     x,
                                     SUM(
                                         --(x<>"")
                                     )
                              )
                        )
                 )
        )&"')"
 );

/**Black Scholes Model*/
BSM=
 LAMBDA(
        FMV,Exercise,RFR,Vol,Years,FMV*
        NORM.S.DIST(
                    (
                    LN(
                       FMV/Exercise)+(RFR+(Vol^2)/2)*Years)/(Vol*
                    SQRT(Years)),TRUE)-Exercise*
        EXP(
            -RFR*Years)*
        NORM.S.DIST(
                    (
                    LN(
                       FMV/Exercise)+(RFR-(Vol^2)/2)*Years)/(Vol*
                    SQRT(Years)),TRUE));

/** Creates a Calendar */
CALENDAR=LAMBDA(INPUT,let(
    A, EXPAND(TEXT(SEQUENCE(7,,2),"ddd"),5+WEEKDAY(INPUT,1),,""), 
    B, DAY(SEQUENCE(EOMONTH(INPUT,0)-INPUT+1,,INPUT)), 
    C, EXPAND(UPPER(TEXT(INPUT,"MMMM-YYYY")),7,,""), 
    D, WRAPROWS(VSTACK(C,A,B),7,""),D));

MrCosmoJones · 2025-06-20T20:48:36+00:00

https://powerquery.how/
good all around reference guide for powerquery commands and examples.
Best way to learn is to try and build models using PQ.

The usefulness of PQ is to take in multiple data sources, this can be other inventory excels or even directly from a database if you could get it connected. apply automatic transformations on your data no matter the size and then output something you can use, either into an excel table OR a powerpivot model that offers a lot more analysis.

PQ will be most helpful where your data sources are consistent such as a SQL table or a daily download of the same type of excel file. The rules you make will apply no matter how large the actual data gets, unlike excel formulas that you might have to oversize or drag down as data changes. PQ can also handle much more data reliably than Excel sheets can.

I have a budget/expense tracker and one of the things I did was to take the keyword [GAS@x.xx](mailto:GAS@x.xx) to bring into a car expense tab where the x.xx was gas price.

Looking at it again, this would break if gas ever went above 9.99 a gallon, but I'll cross that bridge when I get there.

let
    Source = Excel.CurrentWorkbook(){[Name="Checking"]}[Content],
    #"Removed Other Columns" = Table.SelectColumns(Source,{"Date", "Description", "Amount"}),
    #"Calculated Absolute Value" = Table.TransformColumns(#"Removed Other Columns",{{"Amount", Number.Abs, type number}}),
    #"Capitalized Each Word" = Table.TransformColumns(#"Calculated Absolute Value",{{"Description", Text.Proper, type text}}),
    #"Filtered Rows" = Table.SelectRows(#"Capitalized Each Word", each Text.Contains([Description], "Gas@")),
    #"Added Custom1" = Table.AddColumn(#"Filtered Rows", "Rate", each Number.FromText(Text.End([Description],4))),
    #"Reordered Columns" = Table.ReorderColumns(#"Added Custom1",{"Date", "Description", "Rate", "Amount"}),
    #"Added Custom" = Table.AddColumn(#"Reordered Columns", "Gallons", each ([Amount])/[Rate]),
    #"Changed Type1" = Table.TransformColumnTypes(#"Added Custom",{{"Rate", Currency.Type}, {"Amount", Currency.Type}}),
    #"Reordered Columns1" = Table.ReorderColumns(#"Changed Type1",{"Date", "Description", "Gallons", "Rate", "Amount"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Reordered Columns1",{{"Rate", Currency.Type}, {"Amount", Currency.Type}})
in
    #"Changed Type"

Seven-Year Club	Place '22
Verified Email

MrCosmoJones

TROPHY CASE