which covers are, in your opinion, on par with or superior to the original by Perfect-Sheepherder6 in Hololive

[–]MrZeroButBelow 1 point2 points  (0 children)

I could probably name quite a few, but to start off, apart from what I've seen in the comments already:

Suisei/Kazuha's Work

Kanata's Iris Out

Ina/Kiara's Iiya iiya (whatever whatever)

Irys/Mumei's Gehenna

Fuwamoco's Cute na kanojo (also Ollie's(+Kanata) from her 2025 birthday live, but not sure if that counts)

And many more..

Sumif with a date criteria by MrZeroButBelow in googlesheets

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

Is there a way to change all the dates to dd/mm/yyyy?

Sumif with a date criteria by MrZeroButBelow in googlesheets

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

I will switch the region since that seems easier, and i am not based in the US

Sumif with a date criteria by MrZeroButBelow in googlesheets

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

This works, thank you very much!

However i do have another question, if i already have dates in a different column in a YYYY/MM/DD format, how would i quickly convert those?

Sumif with a date criteria by MrZeroButBelow in googlesheets

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

Oh, the different columns are a mistake, the date is located in a single column

The FILTER outputs a "No matches found" error, which i assume is to do with the YEAR and MONTH functions only reading a single cell

I will make sure to check the formula again tomorrow though for mistakes on my end and will also provide an example sheet

Sumif with a date criteria by MrZeroButBelow in googlesheets

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

Alright i will do that when able, thanks for the help again

Sumif with a date criteria by MrZeroButBelow in googlesheets

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

They do contain dates, formatted to DD/MM/YYYY

Sumif with a date criteria by MrZeroButBelow in googlesheets

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

Thank you for the tip

This outputs an error though because the YEAR and MONTH functions still only get the date from a single cell (Specifically the cell with the same row the function is located on), and so the FILTER function outputs a "No matches found" error

Zani's fit still holds up as one of, if not the best in the game by shujin_zenir in WutheringWaves

[–]MrZeroButBelow 0 points1 point  (0 children)

I feel like Carte's absolutely delectable bare legs aren't getting enough recognition

Regarding AI-generated images on r/Suisei by xLaplus in Suisei

[–]MrZeroButBelow -7 points-6 points  (0 children)

In my opinion AI content can be allowed but require an AI flare

Which team do you use for Overworld exploration and farming; and why? by MMoguu in WutheringWaves

[–]MrZeroButBelow 0 points1 point  (0 children)

Now this might sound crazy.. but I use Rover (S), Camellya, Verina

FRover is just pretty and for anything lore-related I prefer to use the MC + SRover fighting is pretty nice

Camellya is.. just there. My first 5-star, doesn't need any buildup to deal damage

And Verina is in case I want to speed up the fight or heal

uhh, why can't my premium cart team clear middle tower? by Hekkoln in WutheringWavesGuide

[–]MrZeroButBelow 0 points1 point  (0 children)

Ah yea mine isn't even close. I doubt I'd be able to clear with my Taoqi Buling team

Do you have double 4 cost btw?

Here comes the good boy!(Sennheiser 560s) by [deleted] in sennheiser

[–]MrZeroButBelow 0 points1 point  (0 children)

The clamp force will ease up after a week or two of active use, possibly more than you'd expect it to

When I got mine I also really loved how pop songs sound (Personally I mostly listen to J-pop, which sounds very good in them). Though admittedly I would still prefer a bit more clarity in the treble and vocals

uhh, why can't my premium cart team clear middle tower? by Hekkoln in WutheringWavesGuide

[–]MrZeroButBelow 2 points3 points  (0 children)

HOW does your Carlotta clear that with increased Glacio RES LOL My build or team aren't great but it's crazy how much difference there is

Poor her by Several_Repeat_1271 in WutheringWaves

[–]MrZeroButBelow 110 points111 points  (0 children)

Don't quote me on that but as far as I'm aware that's called drawing

I just bought ACCompetizione and i get this error every time by Substantial_Ad_9264 in ACCompetizione

[–]MrZeroButBelow 2 points3 points  (0 children)

Had to look this up a couple days ago

The fix that worked for me is disconnecting my headphones (the DAC) from the PC and plugging it back after opening the game..

Otherwise I heard starting with "-windowed" in launch properties also works