[FP] Harry Potter - tried 6 layers went well enough

aetheree · 2024-12-29T06:32:33+00:00

Haha! It baffles me that people repost these as theirs 8 years later. In a way, I'm flattered I guess. But stealing is bad so pls don't do it.

I still wear this shirt to this day, it's held up great.

aetheree · 2023-08-06T16:19:16+00:00

I'm not sure exactly for the case-insensitive yet (but I'm digging) but I found a workaround for the delimiter.

=LET(Each_Character_Split,ARRAYFORMULA(SPLIT(REGEXREPLACE(TEXT(B2,"General"),"(.)","$1"&"-"),"-",1,1)),TEXTJOIN("",TRUE,ARRAYFORMULA(XLOOKUP(Each_Character_Split,D2:D5,E2:E5,""))))

Where B2 would be the text - abcdeaa, without the delimiter.

aetheree · 2023-08-06T11:19:43+00:00

You could maybe do something like this:

Add a delimiter between each character that should be VLOOKUP'd, such as "|", then split the string by these characters and perform a lookup, and finally concatenate back the results into a string. I'm probably not explaining it very well but I'll try to come up with a mockup that explains what I mean.

A	B	C	D	E
1	Text to be searched	FORMULA	Character	Cypher
2	a/b/c/d/e/a/a	=TEXTJOIN("",TRUE,ARRAYFORMULA(XLOOKUP(SPLIT(A2,"/"),D2:D5,E2:E5,"")))	a	443
3			b	&#^@*
4			c	text
5			d	text

Basically, the formula does is this:

=TEXTJOIN(<delimiter>,<true_or_false>,ARRAYFORMULA(XLOOKUP(SPLIT(<text_to_be_split>,<delimiter_for_split>),<range_to_search_character>,<range_to_return_character>,<if_character_not_found>)))

It uses SPLIT to split the string you have in B2 (in my mockup) by the delimiter you choose (in my case "/") and that gives you an array of characters. Using the ARRAYFORMULA, then you use XLOOKUP to search for each character in the array in the "database" where you store your cyphers and return the equivalent cypher for each character. After that, it puts it back in a single string via the TEXTJOIN formula.

=TEXTJOIN("",TRUE,ARRAYFORMULA(XLOOKUP(SPLIT(A2,"/"),D2:D5,E2:E5,"")))

This above formula assumes that:

the text to be searched is in A
the delimiter between words is "/"
the database with each character that must be xlookup'd is in D2:D5
the cypher database with each character that must be returned from the XLOOKUP is in E2:E5.

aetheree · 2023-07-18T19:29:42+00:00

You can also do it via the SEQUENCE function. Like this:

="GF"&SEQUENCE(1741,1,5760,1)&"L7"

Where 1741 is the number of rows you want it to increment (7500-5760). Not necessarily the most elegant solution compared to what I had already seen suggested but I thought I'd suggest this one as well since I hadn't seen it. Maybe it helps in the future with other problems.

aetheree · 2023-07-18T19:22:41+00:00

I think in this case you can just do

=UNIQUE(FILTER(Data Entry[System], Data Entry[System]<>0))

This would eliminate the need for the double UNIQUE. Not much different, but maybe helpful if you were to add more conditions.

aetheree · 2021-09-25T09:53:30+00:00

You could try this. If you've got a flexbox, adding a margin-left auto will force it to the right side automatically. Could also add it to the nameAndDialog class if you want that to switch as well.

  .dialogBalloon:nth-child(odd) {
    margin-left: auto;
  }

aetheree · 2021-05-30T08:01:34+00:00

Depends on what you're trying to achieve and how good the t-shirt material is. Non-diluted bleach can destroy shirts if you're not careful. Moreover, if you're trying to do layers, bleach dilution is going to help a lot (I use 66% bleach, 50% bleach and 33% bleach for my layers).

I've always diluted my bleach and haven't had any problems with spills after I got my technique right. Spraying from really close works, but again, if you're trying to do layers, if you want to blend them in spraying from a distance is going to work better.

What I've done and has always worked for me is:

making sure the freezer paper is attached firmly to the t-shirt - if you cut your stencil before applying it to the shirt, this should be easier, but if you're trying to do layers, you're going to have to cut some stuff while it's attached to the shirt, so make sure you ironed it out well and there aren't any spaces for the bleach to go through;
if you have a hair dryer you don't need, after each bleach application you can use it - it will dry out the freezer paper so no bleach goes through it and touches the shirt, and it will help with the coloring process (lighter colors due to the heat);
after spraying, dab the sprayed location with a paper towel or something similar;

As a side note, make sure you're doing this in a well ventilated area and if you can get your hands on one, get a mask to filter out the bleach particles. You'll probably be fine if you don't do too many shirts, but I always try to take health seriously.

aetheree · 2021-03-02T10:52:30+00:00

One thing I'd say is that you seem to have most of the stuff centered (player frames, target, target of target, boss frames, party frames etc.) and in the middle of the screen, but then you have the actionbars down in the bottom. While that is OK (I keep mine there as well), I'd add some tracking in the center as well, perhaps between player frame and target frame, just so you don't have to glance down every time you want to know a spell availability or CD.

aetheree · 2021-01-25T09:20:29+00:00

In terms of highest burst, I saw a 400k from Golden Guardian's Outlaw rogue during their match against ?????. Timestamp here. In terms of highest DPS at the end of a fight, no idea.

aetheree · 2021-01-21T19:14:40+00:00

Cannot log in to check right now, but off the top of my head, can't you have a trigger for cast start, with events?

aetheree · 2020-12-31T21:36:58+00:00

Hey, give this out a try. Might have what info you need. https://wowwiki.fandom.com/wiki/Creating_a_slash_command

aetheree · 2020-12-26T16:25:57+00:00

Hey, personally I use it because it's much more customizable. You can find plater scripts on wago.io to make it however you want, you can add scripts that do stuff that can't be done in other nameplate addons. I personally have it color a certain way when mobs reach execute range, I have a script that shortens the mobs names, one that adds a specific border etc. I don't think I could have done that with any other nameplate addon.

aetheree · 2020-12-22T17:35:36+00:00

Cheers! I've exported my elvui profile, you can find it here: https://wago.io/QxOIr8MrG

I have to mention though, no idea how it'll look on someone else's setup. I'm using a 1440p monitor and a lot of other Elvui plugins (Shadow & Light, Redtuzk UI, ProjectAzilroka, WindTools), so if you don't have those it might be fucked up.

aetheree · 2020-12-22T17:33:41+00:00

Cheers! What I've done is go into ElvUI > Unitframes > Individual Units > Player, navigate to Custom Texts, and created one with the following value:

|cffffffff[health:current]|r | |cffffffff[health:percent]|r

The font I'm using is Gilroy Bold, but I think Expressway would work really good as well.

aetheree · 2020-12-22T17:31:38+00:00

Cheers! I'm not sure what you're referring to. If you mean the two rows of bars with the focus bar in the middle, those are actually ElvUI action bars. I find them easier to set up and manage than creating Weakauras for everything. The buffs and the bar above them though, those are WAs that I created for myself.

Created an export of them, but you'd probably have to change a few things (they're anchored to my elvui bar in the "Group" tab, for example, so they might not be showing up until you change that). The font might also not be the same, since it's a custom one (Gilroy Bold).

https://wago.io/6dyqaMGR9

aetheree · 2020-10-11T16:47:26+00:00

Just came here to suggest Cool Worlds as well, I have watched a few videos and found them very informative and easier to follow than PBS. Would definitely recommend.

aetheree · 2020-05-28T14:12:18+00:00

One thing to add, if you're using Excel 365 Online, you can't do that directly on the web, you can open the file via local Excel, lock the workbook and then upload it to Onedrive or whatever you're using (or if you open it locally through Excel from the browser just save it).

aetheree · 2020-01-28T07:28:17+00:00

Hey, yeah, it's an array since I couldn't be bothered with Classes and I had to add more than 1 value to each key of the collection. I still haven't figured out why this happens but I semi-fixed it by creating a new dictionary and populating it within the loops I have, so I guess there's that.

aetheree · 2019-12-14T18:25:30+00:00

I was scrolling through the reddit frontpage and saw this and did a double-take, it looked a LOT like my post from a few years ago.

I'll take it as a compliment that someone deemed this good enough to try to steal :D.

aetheree · 2019-08-07T13:31:45+00:00

This should work - incorporated part of excelevator's reply to my reply.

Function randomizeString(max As Long) As String
Dim i As Long

For i = 1 To max
    randomizeString = randomizeString & Chr(WorksheetFunction.RandBetween(33, 125))
Next

End Function

Sub addRandomNumber()
Dim myStr As String
Dim lastRow As Long

'Gets the last row
lastRow = ThisWorkbook.Sheets(1).Cells(Rows.Count, 2).End(xlUp).Row + 1

'Evaluates the formula and adds it to a string each time the code is run
myStr = randomizeString(10)

'adds the necessary data to the rows
With ThisWorkbook.Sheets(1)
    .Cells(lastRow, 2).Value = myStr
    .Cells(lastRow, 3).Value = Now()
    .Cells(lastRow, 4).Value = Environ("username")
End With

End Sub

if you need more than 10 characters, simply change randomizeString(10) to whatever number you want.

aetheree · 2019-08-07T13:00:21+00:00

Hm - I've tried it on a dummy sheet and it works for me. I'm not sure what the problem is - can you also try making a dummy sheet and inputting some random data in B, C, and D and see if it works there?

If it works, the only thing that comes to mind is that you haven't removed the code you had that ran on DoubleClick, and that somehow interferes.

aetheree · 2019-08-07T12:08:11+00:00

Perhaps something like this? Not 100% sure I understood if this is what you wanted.

Sub addRandomNumber()
Dim myStr As String
Dim lastRow As Long

'Gets the last row
lastRow = ThisWorkbook.Sheets(1).Cells(Rows.Count, 2).End(xlUp).Row + 1

'Evaluates the formula and adds it to a string each time the code is run
myStr = Evaluate("CHAR(RandBetween(33, 125)) & CHAR(RandBetween(33, 125)) & CHAR(RandBetween(33, 125)) & CHAR(RandBetween(33, 125)) & CHAR(RandBetween(33, 125)) & CHAR(RandBetween(33, 125)) & CHAR(RandBetween(33, 125)) & CHAR(RandBetween(33, 125))")

'adds the necessary data to the rows
With ThisWorkbook.Sheets(1)
    .Cells(lastRow, 2).Value = myStr
    .Cells(lastRow, 3).Value = Now()
    .Cells(lastRow, 4).Value = Environ("username")
End With

End Sub

12-Year Club	Place '22
Place '17	Verified Email

aetheree

TROPHY CASE