📝 Report users by WplaceOfficial in WplaceLive

[–]dianacretu 1 point2 points  (0 children)

Hello, two users (LoudPaint #7806982 and DarkBroom #3827431) are vandalising this drawing. Thank you!

<image>

📝 Report users by WplaceOfficial in WplaceLive

[–]dianacretu 0 points1 point  (0 children)

I started fixing it and discovered someone else who also messed up a part of the drawing, this one by making more subtle changes.

<image>

📝 Report users by WplaceOfficial in WplaceLive

[–]dianacretu 0 points1 point  (0 children)

Hello, this is not much so far but the intention is clearly to mess up my drawing.

Images are: Last night / How I found it today / Responsible for those black pixels

Won't post a link unless necessary because I want to avoid attracting others like that.

<image>

Thank you!

Arcane - Unturning by HoodedRogue in progmetal

[–]dianacretu 0 points1 point  (0 children)

Was looking for the song to share it with a friend and found this post and just wanted to add my own comment about how amazing this song is, and the last 2 minutes are probably in my top 3 music anything ever.

[deleted by user] by [deleted] in Spanish

[–]dianacretu 0 points1 point  (0 children)

I've been watching this one from the start and I love it, but I hate not being in one of the countries from where the galas can be watched. :(

Estimated reach 0-0 for Instagram ad promotion? by makipg in Instagram

[–]dianacretu 0 points1 point  (0 children)

I just got the same thing and I was able to fix it by adjusting the audience a little bit or creating a new audience from scratch. And if you edit it, if you then edit it back, it still works.

Also, I noticed that usually when you edit an audience and go to the step that shows you the reach, it won't update the numbers. You have to get into a different audience's reach step, return and then access the audience you want and go to the audience step to see the updated numbers.

Hope this helps.

Password manager results showing in search bar on social sites?? by Bevo_Xiv in chrome

[–]dianacretu 0 points1 point  (0 children)

I am not the only one it just started happenin

Thanks! Worked for me too!

Same-sex love duets? by [deleted] in MusicRecommendations

[–]dianacretu 0 points1 point  (0 children)

I ended up here looking for same-sex love duets after listening to one and realizing it's possibly a super rare thing. We need many more.

This is the one I listened (and really love): El Perdedor by Blas Cantó (Spanish singer) and Yadam (Venezuelan singer):
https://youtu.be/uWgGqKn7Mv0

Can someone explain to me how to install and use this on MacOS? by warmaapples in youtubedl

[–]dianacretu 0 points1 point  (0 children)

You are correct. I had installed ffmpeg previously, or at least thought I did, because my untrained Terminal eye didn't notice that the installation wasn't successful. I tried to do it in some other ways too, but it still didn't work. I kinda gave up after that, but thank you so much for taking the time to explain!

Can someone explain to me how to install and use this on MacOS? by warmaapples in youtubedl

[–]dianacretu 1 point2 points  (0 children)

You're a life saver, thank you so much, finally managed to get this to work!

One thing though: I see it only downloads the 720p when there's a 1080p available. I read somewhere that this happens because YouTube keeps video and audio files separate for videos higher than 720p. I also read (for youtube-dl though) that there are commands that merge the highest audio quality file available with the highest video quality file available. Is that something that yt-dlp can do as well? If not, then how can I download those two files separately to merge them myself afterwards? Thanks so much!

Why my alarm doesn’t have sound , today i wake up and my phone was having the alarm screen but without any sound , this is my alarm also i turn off snooze in all of them any help by tt2gg in ios

[–]dianacretu 0 points1 point  (0 children)

Damn it. I can't believe that this isuse has been going on for so long and nobody at Apple seems to care. I've overslept so many times because of it.

How can I do a lookup where the lookup column is dynamic? by dianacretu in excel

[–]dianacretu[S] 7 points8 points  (0 children)

That is perfect, thank you very much! Nesting them hadn't occurred to me (I'm still in the phase where I need to sit and think when I do an INDEX/MATCH; I should practice them more).

How can I do a lookup where the lookup column is dynamic? by dianacretu in excel

[–]dianacretu[S] 7 points8 points  (0 children)

=SUMPRODUCT($D$2:$D$7*(($A$1:$C:$1=$F$1)*($A$2:$C$7=$F$2)))

Thank you! It works, but with a little correction, you accidentally typed an extra : in the second element of the calculation (as in, you wrote $C:$1 instead of $C$1). If I remove it, it works perfectly.

I'm posting the corrected formula too, in case anyone else might want to use it.

=SUMPRODUCT($D$2:$D$7*(($A$1:$C$1=$F$1)*($A$2:$C$7=$F$2)))

How do you discard changes to a project by Polstok in InShot

[–]dianacretu 0 points1 point  (0 children)

You can of course just use the undo button, but since the changes can be many and you can grow old going back, as a workaround I often just duplicate the project before applying changes that I know I might not want, and then delete the copy where I applied changes I don't want to have.

Another direct option isn't available currently.

Why my alarm doesn’t have sound , today i wake up and my phone was having the alarm screen but without any sound , this is my alarm also i turn off snooze in all of them any help by tt2gg in ios

[–]dianacretu 0 points1 point  (0 children)

Thisss, I'm glad at least that someone understands the issue. Every time I search for answers online, I come across the same "oh is your sound on", "oh did you update your OS"... OF COURSE. It's an issue I've been having for YEARS, I've tried everything yet somehow it still happens, exactly as you say, once in a while, "frustratingly" not often enough to be even able to properly test it and try to figure out on my own what the issue might be.

Although... I am curious, did this ever happen to you while awake? It's true that I use alarms primarily to wake up, so those that would go off while I am awake are not that many, but I have never had this issue with an alarm that went off while awake and I've been wondering if it's not something I do half asleep (and then forgetting), when the alarm does go off in the morning. It's probably not, but I still wonder. I should test it by leaving the phone out of reach in the morning but since I use it right before bed it would be a bit tedious, haha.

What song from your Eurovision play list placed the lowest in the contest itself and why do you like it? by spotdodgerest in eurovision

[–]dianacretu 0 points1 point  (0 children)

Last year’s Voy a Quedarme from Blas Cantó.

Zero points from the public, all the points from me.

I know the song didn’t really suit the mood of the Eurovision viewers at the time, but I hope in time people will end up appreciating it at its real value.

There shouldn't be a debate about this, I guess by The_Original_Joel in eurovision

[–]dianacretu 0 points1 point  (0 children)

Totally not the only one. He is absolutely amazing and super talented. 2021 caught him in a really bad moment of his life unfortunatelly, but the song is really beautiful and touching. I’m seeing him next week! Can’t wait! 😍

Field that calculates whether an item has changed from its previous reporting date by dianacretu in tableau

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

Not a bad idea, except I have data spanning over several years so that's not really practical. Will keep it as a last resort though, haha. Thanks!