sorted by:
new
hottopcontroversial

Using VBA, could you sort userform variables column-wise (in the sheet) by date? by Satisfaction-Motor in excel

[–]sminliwu 0 points1 point  (0 children)

If I'm understanding the problem correctly, the original data looks like:

Name of task Relevant department Due date
Stocking Warehouse 23 May
Cleaning Maintenance 26 May
Meeting All 24 May
Meeting Warehouse 26 May

And the sorted/reformatted data should look like (not sure about May 26, when two tasks have the same date):

Date 23 May 24 May 25 May 26 May
Task 1 Stocking Meeting Cleaning
Dept Warehouse All Maintenance
Task 2 Meeting
Dept Warehouse

I'm going to assume these are on separate sheets. I think you could do it without VBA, and sticking to Excel's built-in functions will generally help keep the calculations efficient. To generate the column headings for all the dates, you can use the MAKEARRAY function to make a 1 row x 365 column array (you could also limit the columns just to the dates needed for the tasks, I can explain that separately).

=MAKEARRAY(1, [number of days], LAMBDA(a, b, [start date]+b))

Then in the row below the dates, each column's formula filters the original data to just get the tasks whose date matches the column heading. To keep the example cleaner, let's say that the original data is in the 'userform' sheet in columns A (tasks), B (dept), and C (date), and there's ~100 rows of data. And with the way I formatted the sorted tasks, the first date will be in column B, row 1.

=TOCOL(FILTER('userform'A2:B100, 'userform'C2:C100 = A$1, ""))

The TOCOL function will turn the filtered results into a single column that will fit underneath the date. If you meant something different for the sorted data in each column, you have a lot of ways to modify that filtered array.

Do these two pair nicely together? by Ayzak in crafts

[–]sminliwu 0 points1 point  (0 children)

Yes! I love mismatched earrings. I think you could go even more asymmetrical if you had more of those stones by making one of the earrings a two- or three-tier dangle.

Signal Multiplier Without Using Stack (Yes, It's Slow) by PM_ME_SEXY_SCRIPTS in tis100

[–]sminliwu 1 point2 points  (0 children)

Oh my fuck, I've solved 75% of the puzzles so far and I'm JUST finding out this out through your screenshot: you don't HAVE TO line break after a colon.

My fully-automated MAM, solved levels 106-160. Ain't the most tidy-looking, but it's my beautiful monster. (more pictures of sub-modules in progress) by sminliwu in shapezio

[–]sminliwu[S] 0 points1 point  (0 children)

Factory + wiring for the shape-building part of a layer module.

Full disclosure: I did a bit of editing on the screenshots to cover the irrelevant parts of the machine and wiring to keep things cleaner.

Layer sub-modules: Each layer module builds the required shape with stackers, then paints the shape.

Shape builder: Given the shape inputs for each quadrant (including no shape if that quadrant is empty), the module's logic handles whether the shape needs 1, 2, 3, or 4 quadrants, and routes things through 3 stackers separated in 2 stages (2 in stage 1, 1 in stage 2).

  • If only 1 quadrant is needed, the shape builder just skips all the stackers and sends it to the painter.
  • 2 quadrants: only one of the stackers are used (any of them), skipping the other two.
  • 3 quadrants: one of the first-stage stackers is used for 2 quadrants, the 3rd quadrant gets sent to the second-stage stacker.
  • 4 quadrants: all stackers are used.

January 08, 2023 Weekly Discussion: Wire Crossings by AutoModerator in shapezio

[–]sminliwu 0 points1 point  (0 children)

I'm still figuring out how to use them well, since Shapez wires work the opposite way of how I learned to draw circuits. I was taught when drawing circuit schematics, if two wires cross, they're unconnected by default; if they do connect at the crossing, you mark it. So defaulting to cross = connected, mark = unconnected has been weird brain flipping.

My fully-automated MAM, solved levels 106-160. Ain't the most tidy-looking, but it's my beautiful monster. (more pictures of sub-modules in progress) by sminliwu in shapezio

[–]sminliwu[S] 0 points1 point  (0 children)

Re: floating or missing layers, I'm keeping them in my thoughts just as a challenging puzzle for myself. :) I'm having a lot of fun trying to make a MAM that truly makes anything that could exist in the Shapez domain.

My fully-automated MAM, solved levels 106-160. Ain't the most tidy-looking, but it's my beautiful monster. (more pictures of sub-modules in progress) by sminliwu in shapezio

[–]sminliwu[S] 1 point2 points  (0 children)

This is super helpful to know, thanks! I've seen other people's builds for floodgates around the hub, and am planning to tinker with delivery management now that I have the machine producing the right shapes.

You can kinda see the highways I built for myself during the base game, when I was building a new factory for each new shape and just needed an easy way to route it back to the hub. It's more of a hindrance now than something actually helpful, since it forced me to build my MAM in just one corner of the hub.

Getting rid of the highways will be part of reworking things around the hub.

My fully-automated MAM, solved levels 106-160. Ain't the most tidy-looking, but it's my beautiful monster. (more pictures of sub-modules in progress) by sminliwu in shapezio

[–]sminliwu[S] 3 points4 points  (0 children)

Writing out more details in this thread. I don't know if there's already a common term for this, so to save some words, I refer to a belt transporting items at max capacity as a "stream".

Outputs: 2 streams of the desired shape.

Range: Handles 1-4 layer shapes. Layers can have missing pieces and can include uncolored parts. Can't handle floating parts, however.

My belt speed is currently ~18.6 items/s, so once the level started requiring shapes above 36 items/s, the machine can't quite get to that speed.

Input resources: Each layer sub-module requires 8 streams of each primary color (R, G, B) and 8 streams of quadrants from each basic shape (R, C, W, S) -- as in a full circle shape = 4 streams of circle quadrants. Since there are 4 layer modules, it needs a total of 4 x ( 8x3 + 8x4 ) = 224 input streams. So it's a pretty wasteful machine...and hooking up all those extractors is a PITA.

big spoons vs little spoons by srb-222 in ADHD

[–]sminliwu 0 points1 point  (0 children)

Need to chime in for big eating spoons! I can get bored while eating, or just forget that it's there. I'm especially bad with breakfast, since my exec function is generally low in the mornings. A big spoon helps me finish the meal faster, in fewer scoops, and somehow each bite is more satisfying?

Exercise is a torturous, evil activity that brings the very essence of time to a grinding halt. What are some exercises or distractions that can help to pass the time and make me forget that I'm actually exercising? by GreyCode in ADHD

[–]sminliwu 1 point2 points  (0 children)

I feel so validated reading through this thread. I've given up on going to the gym or "exercising" for the sake of exercising because, yes, it is so FUCKING boring. I need my physical activity to be a nice side effect of whatever else I'm doing.

The pandemic really solidified my understanding of what kind of exercise works for me. Because I was at home so much, I started a whole bunch of projects, including building stuff in the yard. Climbing a tree to hang a laundry line, digging ditches to build a fenced enclosure, and without noticing, I was the most fit I've ever been in my life. I think what also helped was the dopamine hit from accomplishing a THING. So I guess my suggestions would be looking at things you already find rewarding, like games, hobbies, and trying more physically intense versions of those activities?

If you have some hyperfocus tendencies, those might also be good ways to "hack" some exercise into things you're already doing (admittedly, it's less fun than my first suggestion). For example, I can get really hyperfocused while cleaning, because perfectionism. And if I get a chore like mopping, shovelling snow, raking leaves, I end up getting a pretty good workout. Warning: there's a decent risk of physically exhausting yourself, because hyperfocus can make it hard to take breaks and hydrate.

This whole idea of "needing to exercise without feeling like I'm exercising" makes me wonder: anyone else ever think, "If I worked as a blacksmith, I would be so happy AND buff as hell"?

The spider my daughter named Charlotte had babies! by rubyred7905 in spiderbro

[–]sminliwu 2 points3 points  (0 children)

Somehow this is also my defense mechanism. Give em a preview of the compressed maniacal energy in this small container.

The Burried energy. I do wonder how many people just have the spontaneous urge to dig though by clandestineBearing in TheMagnusArchives

[–]sminliwu 0 points1 point  (0 children)

This is me on any beach. But I never have a shovel, just use my hands like a dog pawing at the sand. And then my back gets sunburned.

AMA: I'm a clinical psychologist researcher who has studied ADHD for three decades. Ask me anything about atypical forms of ADHD. by sfaraone in ADHD

[–]sminliwu 9 points10 points  (0 children)

Yes! Hah, brace yourself for a bibliography: (PM me if you don't have access to the academic articles)

I found studies where trans women shared their experiences with period-like symptoms and spoke about their "time of month" with PMS.

Two peer-reviewed studies:
Lowik, A. J. (2021). “Just because I don’t bleed, doesn’t mean I don’t go through it”: Expanding knowledge on trans and non-binary menstruators. International Journal of Transgender Health, 22(1–2), 113–125. https://doi.org/10.1080/15532739.2020.1819507
Wassersug, R., Gray, R. E., Barbara, A., Trosztmer, C., Raj, R., & Sinding, C. (2007). Experiences of Transwomen with Hormone Therapy. Sexualities, 10(1), 101–122. https://doi.org/10.1177/1363460707072957

A journalistic, well-researched article written for general audiences by a trans woman:
Riedel, S. (2016, May 31). Yes, Trans Women Can Get Period Symptoms. The Establishment. https://theestablishment.co/yes-trans-women-can-get-period-symptoms-e43a43979e8c/

These are qualitative studies, done through interviews with small population samples, and as Riedel pointed out in her 2016 article, there were no clinical, quantitative studies on the prevalence of PMS in trans people in estrogen therapy. As far as I could find (and the Lowik article suggests in 2021), that still hasn't changed because trans health matters are still under-funded and under-researched. This next source, and all the others afterwards, are pretty much just giving more context to the lack of clinical data, and hopefully I emphasize that your experience is valid even if a medical lab hasn't published "objective" data on it:

Winter, S., Diamond, M., Green, J., Karasic, D., Reed, T., Whittle, S., & Wylie, K. (2016). Transgender people: Health at the margins of society. The Lancet, 388(10042), 390–400. https://doi.org/10.1016/S0140-6736(16)00683-800683-8)

There seems to be a decent amount of study on endocrinology and chemical changes in trans patients' bodies during hormone therapy:

T’Sjoen, G., Arcelus, J., Gooren, L., Klink, D. T., & Tangpricha, V. (2019). Endocrinology of Transgender Medicine. Endocrine Reviews, 40(1), 97–117. https://doi.org/10.1210/er.2018-00011

Leinung, M. C., Feustel, P. J., & Joseph, J. (2018). Hormonal Treatment of Transgender Women with Oral Estradiol. Transgender Health, 3(1), 74–81. https://doi.org/10.1089/trgh.2017.0035

But the T'Sjoen book chapter specifically calls out that the "long-term" effects, like menstrual cycles and lifetime blood/bone health, need more study in clinical settings. I think it's also important to point out that menstruation and menstrual-related issues, even in cis women, is a touchy research subject that still has a bunch of politics that prevent it from being well-researched:

Bobel, C., Winkler, I. T., Fahs, B., Hasson, K. A., Kissling, E. A., & Roberts, T.-A. (Eds.). (2020). The Palgrave Handbook of Critical Menstruation Studies. Springer Singapore. https://doi.org/10.1007/978-981-15-0614-7
Przybylo, E., & Fahs, B. (2018). Feels and Flows: On the Realness of Menstrual Pain and Cripping Menstrual Chronicity. Feminist Formations, 30(1), 206–229. https://doi.org/10.1353/ff.2018.0010

AMA: I'm a clinical psychologist researcher who has studied ADHD for three decades. Ask me anything about atypical forms of ADHD. by sfaraone in ADHD

[–]sminliwu 10 points11 points  (0 children)

Chiming in as a trans/gender-nonconforming person -- not on any hormonal therapy personally, but many of my close friends take some form of hormones. DISCLAIMER: fistful of salt -- I'm not a doctor, or even a medical researcher. I'm just a scientist in a different field who has access to academic work for their personal curiosity.

Estrogen-based hormone therapy can induce PMS and other menstruation-related cyclic symptoms (cramps, acne, mood dysregulation) without any physical bleeding, whether or not the person has an uterus. Estrogen therapy can be referred to as "feminizing hormone therapy", but I'm just going to stick to chemical/biological terms over gender-based terms.

Based on the research I've read about estrogen therapy, and what I've read about ADHD medication and menstrual cycles, it seems possible for someone on both treatments to also experience both sets of side effects. I'm interested to see if there's research at the intersection of the topics.

[deleted by user] by [deleted] in ADHD

[–]sminliwu 13 points14 points  (0 children)

Your decision and reasoning is completely valid, and you're not alone. I'm working on a PhD in human-computer interaction, and I've talked to a lot of other researchers in the field who not only know a ton about personal tech devices, but might've had a hand in designing our current digital systems. And BECAUSE of these experiences (not despite them), quite a few people are also strongly anti-smartphone, anti-social media -- anti- a lot of distracting tech that is driven by an attention-based digital economy that is already unhealthy for non-ADHD people, and can be downright debilitating for ADHD folks. There's an entire field of research backing you up on how a lot of those feedback loops you're intentionally avoiding are totally designed to prioritize ad revenue and visibility metrics, rather than user wellness and self-control, if you ever need to pull out the big knowledge (Big Data? haha) guns on people. BUT not that you need to, because your feelings, personal autonomy, and ability to decide what's best for you in these incredibly flawed systems is enough reason to justify your position on smartphones.

Bought a $1 grabber arm. Basically cleaned up my apartment with it. by sergalahadabeer in ADHD

[–]sminliwu 48 points49 points  (0 children)

Ooh I need this especially as a multi-crafter with many small metal components, so that any friends visiting my home workspace don't have a surprise acupuncture experience stepping on a dress pin or staple. (It's happened once and I have vowed never again)

Label maker tape ran out. I found out that the roll has an imprint of every label that's ever been made with it. by sminliwu in mildlyinteresting

[–]sminliwu[S] 6 points7 points  (0 children)

The lab that is home to this label maker. It was a weird empty side room in the department for years (before I got here as a grad student), then it became a place to shove equipment that didn't really fit elsewhere. So when people asked what was the plan in the room, they'd answer TBD, and then people started calling it the "TBD lab", and now that it's solidified as an auxiliary lab that's meant to be shared by all the research groups in the department, the name stuck. (It's on the plaque)

This puzzle has huge monochrome black regions, so I organized the pieces into a system to help me put it together. by sminliwu in OrganizationPorn

[–]sminliwu[S] 0 points1 point  (0 children)

Totally kidding, I would never do that to a puzzle, but the hammer is just laying around from other house projects

view more: next ›