#Full AWWM Documentation Project
1 messages · Page 5 of 1
Oooopps
I was just commenting that I finally reached this nonsense
Here's two actual unknowns
5/24/2024 15:40:07 Ʊ U+01B1 capital letter upsilon, should be fairly easy AeroGelo```
i think the upsilon was found by rubiks
Oh fuck my laundry
in the old unicode sheet the recipe for 01b1 was added by rubiks
14th of june
try finding a date in your local grocery store
hmm this sentence can work with 2 meanings lmao
I need some consensus on how to mark the omega then
maybe 3 if its possible to buy a calendar in a grocery store?
wdym how to mark it
then maybe check if it was first deleted, or first found by rubiks
Do you think I haven't tried
maybe literally pick a random option
maybe the recipe was posted by someone else and he just filled it in the sheet
whos gonna care anyway
how about: you choose which option an even number represents, and which option an odd number represents, and then ill tell u my current phone battery percentage
but wait
dont tell me
which means what
just tell me when u decided which means what
Obby if you can't tell I'm being relatively serious right now
isnt this a reply to me saying pick a random option
It's a reply to King Taco
oh
I'll leave it as an unknown for now then, and I'll put it in my big post of unknowns at the end of May
-# (my battery is 67% btw)
I think May will end today
I think May may end today
I had an idea to check whether Aero removed it, but if it doesn't pan out then Nata gets it
Yep, Aero never asked for it to be removed
?
@hybrid relic you might want to check your records
Current unknowns, posting because Nata is here now
5/23/2024 5:43:24 ェ uh strenatos
5/23/2024 5:43:44 ォ strenatos
5/24/2024 21:57:44 A A Scorpiathepro
5/24/2024 21:59:25 Edit: mOm iM fAMoUs try to make the letters weird, if not its fine @aliteralfridge
5/25/2024 20:28:02 Beeting mewi3977, I will ping you in a different thread for making it.
5/26/2024 21:35:37 " A Alive (Double streight Qutation Mark + Space + Capital A) Scorpiathepro```
hmm
oh god i remember beeting
Wrong beeting though
it is?
You have your own Beeting that I found, with the annotation
whats the diff
But Beeting by itself doesn't show up, only Beetomp
Thanks
yeah it's in this file i sent in june #1206592567622373446 message, which got imported to sheet later
In the absence of Sapporo remembering whether he deleted it, I'll mark it as a Nata find
queer
What the fuck did you just... oh
im probably only person that uses the old verison of it
Oh my god no one pung Mewi for it
I'll list Kivinik as completer because it's the simpler of the two
However, had he not discovered it first, "the Mr. Beeting" and Remove The Mr. would not have combined into Beeting
for A A i'm very very sure it was a a that got found and it was alive so the order was checked off
Sure but I still need a link
A a a a a a a a a a a a
I can't do that whenever
How did I know this was from Nata, just by looking at the lineage (not the qef part)
It's minimal-space and also has the matte colours
also twemoji
i mean may 28th
i read everything in awwm from 25th to 28th though and i couldn't find it
Feck, another Unicode I can't look for
I'm gonna call it at the two Orangy Proofs Geometric Construction
nvm found it
#1215495041049436170 message
i simply skimmed too fast
also it's in the A " lineage why did no one see that
Why did Scorpia request so many variants of the letter A
he felt like it
A, A A, " A
Oh right it was revenge for A "
Alright, I'm ending it there for now while I sort out my laundry
Current unknowns
5/23/2024 5:43:24 ェ uh strenatos
5/23/2024 5:43:44 ォ strenatos
5/27/2024 9:25:06 Aprã¨s Ski revival niko you know who i am
5/27/2024 19:57:49 Έ Greek Capital Letter Epsilon With Tonos (U+0388) Έ johnyq2503
5/28/2024 2:54:01 Chromatic Crimson uh nah strenatos
5/28/2024 22:41:28 Appelle-moi Si Tu Te Perds This is french for Call Me If You Get Lost, so I'm sure that's of use. Really wanted FD on this, but I cannot deal with the autocorrect lmao Bokaj90 (🐐)```
chromatic crimson i removed almost immediatley because i was stupid and didn't use "string.building"
Noted
That's a tough one, is that self-completed or deleted
I'll call it deleted since you didn't say anything
Average time is now below one week
Over 1000 orders checked
I'll post statistics once I get them loaded
--- 109
N/A 102
thunderhq0 80
ntsq 67
aerogelo 56
ballzybro. 55
rofer66 49
radu230 45
laurasiagondwanaland 37
brentbe 32
shintosai 22
twoofcubs 22
asd_ic 17
bokaj90 17
kivinik 15
audeus 14
riation 14
justpapas 13
strenatos 13
unknown_hard_error 13
bergoros 11
niko.1s 11
scorpiathepro 9
stargazinghomies 9
bcz_idk 7
captain_comet 7
nessy6 7
awireplays 6
bartleby19 5
judeka7 5
tominichou 5
mrtyper283 4
shiemi224 4
superiphone21 4
texi_0 4
.picube 3
alex_11111123180239 3
Kit 3
leonking6788 3
mrebast 3
muril2k10_brazil 3
nautu 3
sammyboi724 3
sawssice 3
tennisball0151 3
almundmilk 2
clabbers_x01 2
greencrystalk0 2
k.a.l.i 2
kingtaco4 2
m6xw 2
savio038 2
umbflare 2
vancord_ 2
18901098 1
_.pls. 1
arcanev4 1
azulamazigh 1
blindiak 1
brainrotenojyer_43405 1
cereal_killers. 1
ciee 1
cookienya_ 1
dug9315 1
dynamic0_o 1
emharha 1
felipeplayzyt 1
fura.11 1
glowy0245 1
hacheeto 1
Infinite Craft Helper 1
jameshy 1
jenpai 1
johnyq2503 1
lexluxray 1
mrsivvy 1
nchotherfurdthelovablemonster 1
obbybigfast 1
pegfingers 1
potatojuiceultra 1
raynekitty 1
selepriol 1
serdaise 1
shadowinthorns 1
steinstenberg 1
thequieteststorm 1
trainer_yoshi 1
whoremaxxing 1
y_889 1
zettaminx 1
zx._.l 1```
Current stats
Alright, now to cook my laundry
@zealous solstice how will you add the new requests?
Currently I use Rofer
I'd like it to be automatically synced but I think that would lag the sheet out
How would it lag? Works on AWWM sheet without lag?
The data on the main sheet is housed on the sheet itself, since it's directly linked to the form. I don't have such luxuries so I'd have to import the sheet data directly
Although I see what you mean
Oh goddammit I lost another sock
Couldnt jenpai theoretically add it so it also sends to this sheet
Sure, but I worry about the formatting. I'd need to test it first
Do it
With?
Not even an ICBM
Also syncing ticks and the like will be a pain if archiving exists so I think the best I can do is sync the form inputs
Goddammit I lost another sock
Screw it, I'll finish May while I make pizza
Hell yeah Daily ChatGPT Challenge
Chrono;Gate That capitalization is desired. TRUE Daily ChatGPT Challenge
GUYS IM THERE
???
Did I contribute in any way?
Currently not on the list
If you have any you know of I can add them out of order
Do you just want edit access
yea sure
Send a request in then
Aha
I love forwards
5/2/2024 10
5/3/2024 9
5/4/2024 17
5/5/2024 25
5/6/2024 14
5/7/2024 13
5/8/2024 10
5/9/2024 11
5/10/2024 15
5/11/2024 8
5/12/2024 10
5/13/2024 18
5/14/2024 6
5/15/2024 14
5/16/2024 13
5/17/2024 19
5/18/2024 14
5/19/2024 16
5/20/2024 14
5/21/2024 14
5/22/2024 18
5/23/2024 22
5/24/2024 5 <- Left is that way happens
5/25/2024 15
5/26/2024 14
5/27/2024 8
5/28/2024 5
5/29/2024 9
5/30/2024 3
5/31/2024 4```
May stats
AWWM was cooking good on the 23rd
I like how you can also see the impact of Left is that way ->
@vocal turtle sorry for the ping, but do you know if it's possible to send the form responses to a separate sheet for full archival purposes?
Basically just adding the newest entries to the bottom of the pinned sheet (one pin below the poll)
just here to tell you that i've seen ur message but i'm SUPER tired, give me some time and i'll get back to this tmrw!
Sure thing
Have a good sleep
anonymous 34
automated 3
deleted 57
disemvowelment 7
exact caps 107
family 10
full alphabet 10
substitution 1
impossible 15
metagame 12
over 30 160
partial 59
process request 14
punctuation 200
revival 47
rulebreak 8
self-completed 49
special characters 83
strings 76
tech creation 28
techless 35
translation 3
unknown 7
unposted 55```
Tags at the end of May
I'll look into the unknowns in a bit
Oh yeah I should post those here too
These records are unknown - help in figuring out what happened in each case is appreciated
5/23/2024 5:43:24 ェ uh strenatos
5/23/2024 5:43:44 ォ strenatos
5/27/2024 19:57:49 Έ Greek Capital Letter Epsilon With Tonos (U+0388) Έ johnyq2503
5/28/2024 22:41:28 Appelle-moi Si Tu Te Perds This is french for Call Me If You Get Lost, so I'm sure that's of use. Really wanted FD on this, but I cannot deal with the autocorrect lmao Bokaj90 (🐐)
5/30/2024 5:23:40 A8g$#k2L@5&d*H4 Any capitalization is alright! ChatGPT```
I suspect the last ~~two were~~ one was deleted and that Bokaj's was removed by him (as he was an editor at the time). The first four have the problem of whether they were deleted or not, since they all were found
Thanks to Radu we know when Έ was removed, at least
Pretty sure the last one was never made
I looked at the French one for a while, couldn't find it 😔 So I made it to be sure
I'll have to look more I guess
Is there any way to check at which time they got ticked ? Or in what order ?
missclick
I see
bruh
And there we go
I'm an idiot I was looking at after 27th june
Thanks both of you
Not May somehow
I'll do June for like 30 minutes while I'm here anyway
if you have edit access to the actual awwm sheet, go into the edit history and look for when it got checked
I don't, do you mind if I request it ?
dm me your email it’ll be faster than waiting for jenpai
Okay I can't actually find the exact message saying ASD's strings were deleted but like... they were, right?
m*ew8f#04j and 17-?l.vl+s were definitely not done right?
Jenpai migh have deleted this one since it was made anonymously (user ChatGPT joined in August)
It was a period where people were asking GPT for strings of random characters to make
Yeah I remember, I was there
I'll mark as deleted then since it wasn't gotten
Oops, first clerical error of the night
⛪ clerical?
I made a mistake
There were two orders for Left is that way ->-esque elements and I marked oh you were making a joke
Έ is in there too
Leaving the japanese ones for Tuna
Preshoting the unknown section
Maybe I should stop forwarding and just put links that would make the bounty more digest
Ah I glossed over it because the ping wasn't attached to the image
Thanks
So all that's left of the unknowns is the Japanese and ASD mewing
And 17
peak "Egypt"
those old days
when "alphabet" was the peak
locely
lobely
lobely
bro I think I'm a beetroot
Could someone else log 50 more orders please thanks
Anyway - current Unknowns
5/23/2024 5:43:24 ェ uh strenatos
5/23/2024 5:43:44 ォ strenatos
6/3/2024 14:55:33 m*ew8f#04j any caps is fine (apologies for the gibberish, I rly had trouble with that) asd_ic
6/3/2024 14:56:41 17-?l.vl+s any caps (again sorry for the gibberish :/) asd_ic
6/8/2024 8:06:03 #a-#z A#-Z# "a#"-"z#" "#a"-"#z" replace the # with the unicode character U+202E. if i put that there it wouldve been hard to read. exact capitalization and go for alternative ones if you wish immord
6/8/2024 9:55:36 (ad) a revival request (i got it using ad + put this in parentheses) strenatos```
I'm almost certain (ad) is actually in the a - z thread but I can't confirm
#a-#z wouldve just been removed, no?
Yoruzo did the 202E alphabet if I recall correctly
it is requesting 104 elements, after all...
Yeah I mean what kind of monster would request an alphabet ?
Exactly
Anyway my pillow is calling me
Well pick up the phone then
Also #a-#z wasn't removed for a while, I just want confirmation of when before I mark it
Also if Judeka had waited one more day, there would be a three way tie for 8th-longest-lasting bounty
wait
Wait
🛗🎶
I am the one thing in life I can control
fsdjqskjfsn,n v I knew it
place your bets on how many times laurasia will say "s" today*
Well that was because it wasn't meant to be subtle
It must be.
Honestly I'm not even sure how much Hamilton I've dropped, I found this one earlier today
I swear to God this game is bringing back all my anger issues
Say no to this, Now be sensible, from what I hear you've made yourself indispensable, and I swear I referenced Why do you write like you're running out of time at some point but I can't find it
I think now be sensible, blablabla is the only one i actually can recall you saying
ah i remember that now
When i told you to always put a bird after "ou"
well, it's not like you(🦜) wou(🦜)ldve gotten far with it anyway, it is a very common substring
Fair enou(🦜)gh
nooooo... larua is dde?
Laurasia is DDR
I dont see anything wrong
Greetings comrade
its always been spelled revvovlution
tight night light might freight sight right
Freight
and i disagree with you about it not being night!
-# timewhat?
Ey, twinsies
look at my time tho, its like clear day right now
I agree with you disagreeing
I generally disagree
I sergeantly disagree
Anything you think I think the opposite!
I think mods are great
Huh, why do I believe in world peace now
you are lovely today ❤️
why da hell did chat die.
Wait no this is just expanding the love quadrangle again
this is bullying
i was already in it tho!!!
You've always been in it
Oh of course you want me in it
how big can a love polygon get?
Okay real talk I was in like a love heptagon at one point
Quintuple sided PiGon with 4 faces
how the fuck do you land in that
High school relationship dynamics can get insane if everyone just gives up on commitment
4 faces? Creepy
We got a facist here
pigon!?!?
3.1415926 corners?
and it has 4 faces?!
Plus literally everyone was bi
even the janitor?
What
@autumn plover *
I don't even remember my situation...
what
Janitor
yea
Holy hell
google janitor
No
s'tI
You can’t even count to 727
???
!si ti esruoc fo
.seY
i need a new gimmick when i get mirror dimensioned
going lowercase is funny but idk i need something better
stnof egnahc ot deen uoy ylsuoivbo
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727
wtf
you missed a number
When You Count To It
There is none.
I was talking to you, not you
did you just fucking Twitter fake logo me
maybe
without the fucking part tho
Wow, the Muskox logo was so terrible it forced Niko out of the mirror dimension
with the fucking part
Did you really read the entire thing
no i had chatgpt check it for me
You couldve just done a word counter to see it indeed has 727 words in it
very trustworthy lmao
but i guess it works
I copy-pasted into an old split function I had lying around in a spreadsheet
that doesnt verify they are in order
well here is how i made them js let message = ""; for (let i = 0; i < 727; i++) message += i+1 + " " console.log(message)
catstone isn't smart enough to make that the mistake in it
You don't need anything after the word "smart" in that sentence
you are right, i am in fact not smart
i am actually mUcH MoREE!!!!
-# is what my mom always told me
You don’t need anything at all
My entire playlist is Olivia Rodrigo tonight for some reason
you're a sozi.
Your playlist should be elevatoe music tomorrow
toe
when? where?
elevatoe
ᵒᵉ
El Evatoe
Elevated oe
elevator (australian or something ?)
Elevator? I barely know 'er
this didn't load for a second so i just saw a blank image
Your tricks never work on bad wifi
Your tricks never work on former bad wifi
not entirely sure I do understand, you want the form responses sent to another sheet (a sheet that isn't "AWWM Full Documentation" )
and from that sheet you want to grab newest entries and also put them in AWWM Full Documentation? or?
oh wait, it's basically the issue that I was thinking about back then but couldn't solve?
What?? thanK you aIMee was completed??? i should have been pinged for that smh
well sortof
we got thanK you AIMee
It was ThanK you AIMee no?
i mean that
thanK you aIMee has not been found
For that reason I'd say that it still isn't completed, but I'm probably the only one who thinks this way
i personally think its completed, but only because of ThanK You AIMee instead of ThanK you AIMee
Sure ThanK you AIMee is kinda closer to the intended goal but ThanK You AIMee is what was listed as an accepted variant by sandu not ThanK you AIMee
..unless i misremember
Yeah those were the only two that were listed as acceptable
yall still documenting??
i did not say this. also woah remove the mr. [symbol] that must be insane to make those 😮
ThanK You AIMee was also found tho
That was badly phrased, I did in fact mean sending the form responses to my sheet in addition to the main sheet, in the same way that the main sheet receives them so that there is minimal lag from trying to copy offsheet data
I haven't heard of the issue from back then, I might've missed it because I wasn't there in April
I don't think it's possible to send form responses simultaneously to two sheets
but you can look into using IMPORTRANGE
Ah well
I could but I want to avoid that. Don't like dependency chains for data
Looks like manual it is for now then until I come up with a solution
Why is the Individual here
that's what i said mate
People refer to uhe's ThanK you AIMee for the completion, but i prefer ThanK You AIMee being whats referred to
i mean you could put all the "accepted" variants
?
Huh i just noticed glowy left after saying this
erm OLD NEWS 😂
SLUR HERE 🖕🖕
derogatory reply 😡
The problem is that "ThanK You AIMee" is what people were going for, but "ThanK you AIMee" was what was accepted
So I'm not sure how to mark it
Compliment about your race ☺️
What
damn
cant be nice in 2025 😭
I do currently put multiple rows for orders that were completed by multiple people on separate occasions but that's usually for orders with more than one thing ordered
ill have a look
are we bringing niceness into 2025? 🤔
Also for the record I missed with that "morning babe", I think I should have been more clear who I was directing it to
you could always use the feature discord gives you
lame Edit
I made a typo
BremiTK, GDSouthernWest and Menology (I think)
The original order was all three at once but it has been split into components because they were posted separately
a full word and an emoji ?
yeah, typographic error
Is this from the TwitterBox
you were filming?
what is twitterbox
Xbox after Elon Musk buys it
Incredible
I wonder if the Bible would be better with emoji
😬
Yeah exactly, just like that
it is the same way i have this wonderful screenshot
and God said: let there be light 🗣‼️
i wish my mouse wasnt there but sometimes art is not perfect
i probably can enable that sort of replay feature somewhere
Damn that's sexy
🇰🇮
but nice that you can get the crop easily and all - my lightweight editor can only trim to keyframes and cannot crop or anything
this one ?
Why is the first thing in my autocomplete after I type abuse "banana"
i mean
What the fuck
banana trafficking rings are at an all-time high
ive observed this numerous times
do you know anything about them, polaris?
About what
Banana trafficking rings.
Oh yeah
I get stuck in them a lot
Thanks for the detail, we were looking for anyone's involvements
Abuse of banana and ....
Apparently the full sentence is "abuse banana him 😔"
this is true
but also recently autocorrect changed and it now "learns" way too fast - like you only need to make a typo twice in a short enough time and it will forever think that its intended
and "correct" to the typo from then on
will this break if theres a tie?
Yes
im gonna make a copy and "fix" it
Thanks
(i hope)
The leaderboard didn't change too much after a while so I didn't bother but it would be nice
why would it change? i guess documenting
anyway, what did you look up for that one? or did you use prior knowledge
For Large?
Because when people complete orders they usually are old now
The orders, not the people
That's not accurate
Both
What I meant to say was that there are still orders that could be the new longest when people complete them in the present
Future
do you need sleep
For fuck's sake
couldnt this have been done with one arrayformula instead of 20 larges
That is also true
But I didn't want to think about it for too long because at the time I think it was like 1 AM
not strictly the large part, more the "matching" bit
Oh that one I knew offhand
That was just the easiest solution to the problem I had and I saw no reason to look for a better one
^ this philosophy is not a good idea I fell in a hole because of it once
well the first thing i thought of was trying ROW() but that only works on cells
LARGE() probably returns the value not the cell
Good morning PiChael
I just realised it's been a while since I haven't been Hatsune Miku and cosmo is still not solved
I guess Laurasia name strats only work once
Our best strat for exact caps failed, what should we try now
New idea
Laurasia Taylor Swift Name Strat
But now I don't know what to say when you say Hatsune Miku
If I reply "Taylor Swift" then I need to reply "Hatsune Miku" to myself
Infinite loop
?
Valid response
I hope to get to the end of June today since I'm gonna be out travelling tomorrow
Thankfully the number of orders per day seems inverse to the time since April so it shouldn't be too bad
Hatsune Miku
Taylor Swift
No but it does feel like it sometimes
the name counting looks like it was done with apps script?
That one I just copied from the FEPW sheet and then Bowser made a better version
Fair enough
By the way we need to make cosMo@bsp to play infinite craft
Also I think cosMo@bousouP should be acceptable because cosMo himself sometimes uses that capitalization
It's Aero's bounty
Ask him that yourself I think
I think I should try that capitalization first and ask him about that
Well anyway
I'll go break bad and then get back to documenting after
oh
Alright, so at least sometime between 8th and 10th
"see forwards" didnt click
Ah
i thought you meant like, nuh uh only looking back
Me when I only have eyes in the back of my head
ye thats what i was thinking
There we go
ah 2 letter brackets, interesting, wonder what the tech is for that
Different alphabet + PTIP usually
true, im used to not using that because dead
it kills everything (unless its already in the form where it wouldnt die)
Huh
I'd rather everything be in one place
The Laurasia-Only sheet will be removed once I'm done anyway, since it's mainly for my personal use
So there's time to workshop a better solution
Also I just realised Jenpai switched back to old pfp
i tried i cant
idk
i forgot how array formula work
Theoretically you'd just need to sort by days and only copy first n entries
My problem was that the N/As and 0s fucked with me
example? id like to see what you meant
my problem was not the n/as but rather as soon as i combined the day and the username into one it stopped sorting from greatest to least and started sorting by reverse alphabetical order
how did you get the array formula to do anything here though - my understanding of array formula is incompatible
i dont see how that would work
So clearly with our powers combined-
basically you bash your head into a wall for about an hour and something good comes out of it ~20% of the time
you could probably give it to chatgpt and it might be able to just solve that for you
Nah, tbh I'd rather learn how to do it right first
i tried to see if it could do the whole thing but chatgpt failed miserably
I find other people's solutions and then figure out which parts mean what and then haphazardly jam my own stuff in there like I'm packing for holiday
that sounds pretty accurate yeah
ya but like, the only examples of array formula ive really seen is like arrayformula(a1:c1+a2:c2)
arrayformula(something that returns multiple cells)
yeah but half the time i use it i get an error that it returned with nothing in it cause idrk what im doing
i mean you seem to very much know what youre doing - i didnt think what you are doing there is even possible with sql like syntax
i asked a doingologist and they said killerbowser does not know what hes doing
That reminds me, I was fixing something yesterday and decided to check Google's documentation for their query syntax and they have this wonderful table
i went to mcdonalds and everyone knew you
(I refer to the bottom entry)
Funnily there's not a single maccas near me
not america moment
Oh look who's here...
i'll start to say that now instead of "this feature is deprecated"
interestingly the closest mcdonalds is 10 minutes away
This must be a record of some sort
In Cincinnati?
The from clause has henceforth been exterminated from this language.
Jesus
im in the greater area currently but yes
"Greater"
Depends what the criteria is
a farmer living in the mountains will be far from any maccas so id suppose WRs have to do with greater populated areas
I like the term Greater {x} because it implies the original is Lesser {x}
The Lesser New York Metropolitan Area
Yeah I know what it means I'm just shitposting
SOURCE: “Forbidden by Jewish law are proposed sacrifices for storm victims declared Rabbi Lesser.” Cincinnati Enquirer, 15 Jul 1915.
proof Lesser Cincinnati is real
what is today but yesterdays tomorrow
Vance wants ice cream gone, other parties have made no statement on it...
Hell yeah I am now 100% pro Vance no more ice cream
the chili ice cream is apparently actually good
i will have to find out for myself i guess
yeah so how do you get anything out of an arrayformula here - did you try query again?
well i started with just getting the order in one column, the days in the next, and the person who completed it in the next one which went well
but any attempt to combine the number and person fucked it up
Ohhh
Yeah and it unsorts
yep
I see
I think I can work with that
Could you copy what you did? I'll try later
left one
=ARRAYFORMULA(SORT(FILTER({Log!B2:B, Log!H2:H, Log!F2:F}, ISNUMBER(Log!H2:H)), 2, FALSE))
right one
=ARRAYFORMULA(SORT(FILTER({Log!B2:B, Log!H2:H & " days, by " & Log!F2:F}, ISNUMBER(Log!H2:H)), 2, FALSE))
not even a query?
also it doesnt limit to ten entries so...
That is true
so youve sorted all the rows where there is a number and sorted by the number of days
although idk what the curlies do
well i think you may be able to sort them, then concatenate
instead of the other way round
Who was that
?
Someone ℹ️'d my message and removed it
Was me
Oh ok
accident
Also if you want Rubiks I can document all my attempts to make the leaderboard work
sure
Incredible, first my Bounty Board Bounty Board and now my Documentation Documentation
now we just need some implementations implementations
Some Representatives Representatives
alright i got it (this is cringe it runs the search 3 times but whatever): =ARRAYFORMULA({INDEX(SORT(FILTER({Log!B2:B, Log!H2:H, Log!F2:F}, ISNUMBER(Log!H2:H)), 2, FALSE), , 1), INDEX(SORT(FILTER({Log!B2:B, Log!H2:H, Log!F2:F}, ISNUMBER(Log!H2:H)), 2, FALSE), , 2) & " days, by " & INDEX(SORT(FILTER({Log!B2:B, Log!H2:H, Log!F2:F}, ISNUMBER(Log!H2:H)), 2, FALSE), , 3)})
the trick is you apply formatting after the sort
Oh wow
in the end its more efficient to just do a helper column, unless we can get query to come in clutch somehow
=ARRAYFORMULA(IF(G2:G="", "", IF(G2:G="N/A", "N/A", IF(INT(A2:A) > G2:G, 0, G2:G - INT(A2:A)))))
can be put in H2 so there aren't 2409 formulas for column h lol
just has to be limited to the top ten entries and then its good
oh ok just
=ARRAYFORMULA(ARRAY_CONSTRAIN({INDEX(SORT(FILTER({Log!B2:B, Log!H2:H, Log!F2:F}, ISNUMBER(Log!H2:H)), 2, FALSE), , 1), INDEX(SORT(FILTER({Log!B2:B, Log!H2:H, Log!F2:F}, ISNUMBER(Log!H2:H)), 2, FALSE), , 2) & " days, by " & INDEX(SORT(FILTER({Log!B2:B, Log!H2:H, Log!F2:F}, ISNUMBER(Log!H2:H)), 2, FALSE), , 3)}, 10, 3))
- chatgpt
Array constrain
Oh yeah
What was it that Radu called ChatGPT one time?
During the Daily ChatGPT challenge arc
what arc???
now anyway this is more concise and almost works
=ARRAYFORMULA(SORT(FILTER({Log!B2:B, Log!H2:H & " days, by " & Log!F2:F, Log!H2:H}, ISNUMBER(Log!H2:H)), 3, FALSE))
we just got a helper at the end we cant really ditch easily
unless there is a way
got it
array constrain
clutch
The Daily ChatGPT Bounty Program, where I had to talk to it like a wizard and Radu nearly fought Skynet
=ARRAYFORMULA(ARRAY_CONSTRAIN(SORT(FILTER({Log!B2:B, Log!H2:H & " days, by " & Log!F2:F, Log!H2:H}, ISNUMBER(Log!H2:H)), 3, FALSE), ROWS(Log!B2:B), 2))
works, only runs once
Hell yeah
and then ofc change it to 10\
wdym only runs once
=ARRAYFORMULA(ARRAY_CONSTRAIN(SORT(FILTER({Log!B2:B, Log!H2:H & " days, by " & Log!F2:F, Log!H2:H}, ISNUMBER(Log!H2:H)), 3, FALSE),10, 2))
search only runs one time
oh i see
in previous formula it ran 3 separate times
blackgpt
Oh right
oh left
Anyway booting up the laptop now
Also Brent you never answered my question in OOC
which way is left again?
check my bio to learn more 👍
Reposting because it's funny
shouldve written Left is that way happens -> 5/24/2024 \n 5 instead
OK thanks
id be fine with \t
Chamomile? Black? Green?
there you go
carriage return
i mean if you want i can feed that line but im sure it can feed itself
Leaderboard is now correct
can this be done too
Hm
can 'this' be 'done'
The empty rows are giving me mixed feelings but I suppose with time they will grow on me
empty?
With this version the unfilled dates show up as empty instead of N/A
This isn't really a problem, this might actually be better, but I have weird particularities with this stuff
I'll leave it be
Fuck my internet died
it wasnt empty before? hmm ok
it is a simple change regardless - just change output of the condition to N/A
im trying to work out if the formula affects col G at all
isnt it only a col H formula
Yeah I'm just weighing it up now since I've been given this alternative
New insight and all that
I think I'll keep it then
so how is the formula in column H affecting column G
it isnt
?
i mean clearly it must be, if changing the formula in column H made column G change
it didnt
i watched it change from empty to N/A
the change was that if column G had a blank, it would have N/A in H
now it has a blank in H if G is blank
oh wait i see
you edited your message to reflect that change, i see
thats why i see no diff
sure
what does "unknown" mean
I have not been able to find the record after searching
i do not know what that means precisely
So I'm adding in information by searching for, usually, the text of the order or mentions of the person ordering (or in some cases scrolling through AWWM)
If I cannot find any record of the order being completed or deleted by request, I mark it as unknown
That way people who might remember can easily see what I couldn't personally find
What the hell
We were at one week last night, what happened
Qeej
more things with 100+ days getting added inflated that a lot
we are so back
Goddamn
-it
Thanks babe
probably due to UHE's find with latin math capital letters + TYA
No, it was 7 days with that added already
I think it was Judeka getting Ted Ebert actually
Speaking of TYA I feel like a decision needs to be made sooner or later
what specifically ?
The Clabbers issue and the issue of whether someone getting thanK you aIMee should be counted
the hell is the clabbers issue
Should Clabbers be listed for this: #1215495041049436170 message
Oh clabbers is qadi
Yeah sorry I've begun remembering people by username because of this project
I now think of Sapporo as Strenatos
you're welcome
i mean ive mentioned my stance on tya completion already so someone else can comment on that
im known as strenatos everywhere else actually
even in real life?
what does the n stand for
Nothing
StreNAtos ?
There is no need to discuss the TYA situation until we get a lineage for the correct caps variant
new request ?
This was my response when it was brought up two days ago
There is no need to discuss {thing} until we get an {event related to thing}
no
Stre Nothing Atos‽
I say do a poll
killerbowser is Not a group!!
i am The Group
I'll do a Pole
I'm not Polish though
i say no imo
Not yet that is
what if i change my name
you can't
or what
nothing you just can't
what if i want to resign from being a janitor
You can't.
Did brent just change to Other
Okay if you're saying other you have to say something
nuh-uh
i don’t see why they would be added if the order was accepted 4 hours before
Hell yeah the entirety of Six just started playing on my playlist
Sorry qadi but the element is just too close both in time and characters with the original tree
Whatever you guys pick, I'm fine with it
@lethal ginkgo change your opinion
septuple
This does not mean I disagree with who did it first
It is now septuple
hi
you really clowned yourself, JUST to prove me wrong
amazoning
Yeah Brent doesn't deserve to be right
he deserves to be.. left?
Right is
<
whgat the freak
🔄
did you just wish leftness upon me?!
MOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOODS
29 more
are there any Belgians here
No
This said AWW MAN before
ruan?
Ruan Jussian
@fossil wedge
@ belgianbloke
ffs
what if belgianguy isnt belgian
Stop kidnapping people into this bounty I'm already doing that enough
@tribal cradle
@zealous solstice get a load of this rando
@swift hedge
Who even is that
his alt
idk i just typed li
yo phone
yo phone linging
@west saddle
Why is the Individual here
@vapid laurel (you cant prove you were already in here)
On today's episode of the Random Bullshit show
@slim merlin
hey
hi chicken dinner
who are you
aight leaving
i really hope you're not belgian
What do you want
OH NO YOU DONT
i want to hear your opinion on the food known as Chicken, and if you have ever eaten it for Dinner
can't you see it's alb
i do a lot
Most famous ICer
Who even knows uhe anyway
someone named a lot?
why the actual fuck did I need to do a full-on captcha while trying to send a friend request to @quasi trellis
who will take one for the team and kidnap neal into the bounty
something something 100 prisoners with numbers who need to find their number in 100 boxes in under 50 tries without communication
the horses name was friday
@ horse
@warm trail
@winner.v muted
Reason: Pinging Neal for no reason.
Duration: 59 minutes and 55 seconds
events
are yall seeing this‽ since when did neal follow this bounty
yeah wtf
He must be a fan of laurasia
wow that’s crazy
also, is it weird that I've never seen winner.v and laurasia in the same room?
true...
Mute evasion be like…
guys this isnt a logical conclusion
their name is not niko
how could i be them if they're not me?
Sigh
didnt kali say she would mute or ban people for ban/mute evading
yes?
oh thank god
credit RandomRants
Sr. YouTube
its like if someone links to an element thats on browser, u wont credit the person who linked to browser
I only answer to Sr. Administrator
Okay I need people to go to RandomRants Youtube channel
Wow it’s almost like he was pinged
and do what?
Just look around
idk what u mean by look around, but i saw hes just a hypixel skyblock YouTuber
Okay now subscribe
that IC video was his only video about IC, the rest is hypixel skyblock
I genuinely don't know how to credit this one
Actual capitals are reserved for nonhumans
i would credit the YouTuber
if u credit aero then u also have to credit people who link to an element thats already in infinibrowser
How do I credit the Youtuber though
You’re the boss here just make something up and we’ll roll with it
Soon
I'm a big believer in democracy
Or at least not acting unilaterally
I want to make this consistent in case anyone else tries linking Youtube videos in the future
Dang all this promotion talk must be happening in the mods chat monka soon I will have to answer to Brent
uhh isnt the way u credit someone just putting their name
isnt that how everyone has been credited
What is their name
oh handle is @SalmonLord
maybe SalmonLord becauss you use peoples discord username and not nickname, and SalmonLord is kinda the username and RandomRants the nickname
I mean they are just special
You can just make it lowercase
I could
i disagree with that
But if @salmonlord shows up then we have problems
their username is not salmonlord, their username is SalmonLord
Precisely
I'm gonna do something special then
let’s not make the same mistake as Neal
i think its ok to just let him stay as SalmonLord, even if it sticks out
This is my solution
the only reason others are lowercase is because discord does it like that, but youtube doesnt do it like that
both don’t do spaces though
Yes, so this cannot possibly create a many to one issue
Anyone credited offsite will now get something like this. I'll try to figure out something better later
could have added another column but this is probably better
I'd rather not
hmm what if someone had a long enough username that it would be longer than the column
token limit
No
Just for reference the current longest names are nchotherfurdthelovablemonster, brainrotenojyer_43405, laurasiagondwanaland and alex_11111123180239
does nchother go out of the column
Yes
does it cause world war 3
No
Is this with a LARGE again or does that only do numbers
No I just sorted by length
Hat-soon A me coo
What
hat is not pronounced like the hat in Hatsune
Honest idk
Well depends on your accent I suppose
I just guess
ha tsu neh taylour swift miku
Everyone is now saying Hatsune Miku to themselves
ha tsu neh mi ku
am i pronouncing hatsune incorrectly? if yes, i will stick to my pronunciation because it sounds better
but yeah if it’s like ha tsu ne in Kana then it would make sense
same
yea
To be fair I don't pronounce the T in hat anyway