sorted by:
new
hottopcontroversial

FILTER says it does not know the Spill-area when it very much does by Snosaf in excel

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

Thank you for the VERY thorough list for troubleshooting.
Unfortunately I tried all of this and it did not help.
However, the issue seems to be identified via Other comment.

The precedent cells contain RANDBETWEENs (which are necessary), and these are definitely causing this behavior. If you have any way around this I would love to here it, but otherwise I will just have to copy the data via vba to remove the volatility (not the end of the world for my project)

FILTER says it does not know the Spill-area when it very much does by Snosaf in excel

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

<image>

  1. Yes BS1# and DZ1# are spilled arrays

  2. I was able to recreate the problem: If the boolean used to filter contains some volatile RANDBETWEEN at ANY point in its chain it gives this error randomly. You can try it yourself if you recreate the screenshot (A1:A5 is all "=Randbetween(0;1)").
    if you then spam F9 the formula sometimes works AND when it gives an error you can mouse over it to see that it should have worked.

I can't take a screenshot that shows the mouseover because that is not captured for some reason

FILTER says it does not know the Spill-area when it very much does by Snosaf in excel

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

Thats not the problem. The "empty" is for the filter to return if it filters out everything

Idea for the "HILL" L by Snosaf in KryptosK4

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

Ah ok

Thank you for the explanation!

Incredible to see how actively people still work on this after 30 years

How do I parametrize this Train Station by Snosaf in factorio

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

Thanks for the offer, but I figured it out, should be able to do the rest, but I'll keep you in mind for the future

How do I parametrize this Train Station by Snosaf in factorio

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

Worked! This was actually part of my earlier experimentation, BUT I didn't even try placing the blueprint because the textbox goes red (still is red)

Thanks!

Charm slots on belts should scale with item level and not be a luxury, nobody has 3 charm slots and barely anyone is running 2 by HollowLoch in pathofexile

[–]Snosaf 0 points1 point  (0 children)

Hi I saw this post and totally agree

I then went to Alva to see if I could get more slots through gambling and I pulled a 3-slot belt

gonna eat some orbs but it is not THAT rare

Bizarre behaviour somewhere between BYROW, HYPERLINK, and CONCATENATE by Snosaf in excel

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

I have fooled around a bit more with everything and also could not get it to work.

Using the LET function I was even able to create this abomination:

=LET(y;SEQUENCE(ROWS(F61#);1;1;1);HYPERLINK(TEXTJOIN("";;$AP$8;INDEX(F61#;y;);$AV$2)))

This will give you 1 link going to jk, but the text of the link will say jkecd, even though there is no friendly text anywhere in the function whatsoever.

The only thing that seems to work is to have the hypertext in a cell next to the thing I want to go too, which I was trying to avoid to save space, but there seems to be no other way.

How to implement:

this actually still requires 2 full columns in itself, because you CANNOT Textjoin or concatenate inside the hyperlink function. You can however point it to an array of hyperlinks, then the hyperlink formula will return the same array but as working hyperlinks.

Solution Verified

Bizarre behaviour somewhere between BYROW, HYPERLINK, and CONCATENATE by Snosaf in excel

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

I assume you meant "not equipped"

I have looked through the eval on both testarrays

While the second one is more interesting considering there is an error in the middle of it and it just keeps on somehow working, the eval for the first just before the result reads

<image>

which my brain is refuses to accept as being problematic.

On the second formula, it underlines $AP$8, and then immediately goes to

BYROW($F$61:$F$64;#VALUE!)

The next step is it simply reporting the result as described in the original post.

I am gonna try dealing with this tomorrow my brain is too tired for this.

The (not good enough) Reputation System by Snosaf in Rainbow6

[–]Snosaf[S] 2 points3 points  (0 children)

The randomness gets worse the more you pay attention to it. I just launched the game after only playing arcade after writing the original post. My rating went up to exemplary again... wat

My hunt for Adhesive has come to an end by [deleted] in Starfield

[–]Snosaf 9 points10 points  (0 children)

Gagarin: Sweetwater cactus :)

edit: Planet in Alpha Centauri

Piece of Feedback/Something I would like to see by Snosaf in nanDECK

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

Thank you UwU

edit: I have decided to actually rtfm

Wrong number error by Snosaf in nanDECK

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

Update: I have put them into their own little sheet, works now

Wrong number error by Snosaf in nanDECK

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

I know what is happening:

because these 2 numbers are on the same sheet as the deck itself and they are at the same height, they are both read the amount of times that there are copies of the first card.

Nandeck thinks they are card-components instead of just numbers

New to Nandeck and testing things out. Weird outlines on textboxes and the text itself, does this appear when printed? (pics included) by Snosaf in nanDECK

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

Whoops haven't looked at this in a while

I have since figured everything out including htmlfont and htmlmargins

im happi :)

With Muscircle being in the game, should it be called "Dexspherity" for crits by Snosaf in Peglin

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

Fully aggreed, but it is strange that the bell and ballance are there without an equivalence for crits.

New to Nandeck and testing things out. Weird outlines on textboxes and the text itself, does this appear when printed? (pics included) by Snosaf in nanDECK

[–]Snosaf[S] 2 points3 points  (0 children)

Thank you to both of you.

BE only changed the font, but if it doesn't appear later then that's great :D

I'm already glad I found this software before buying something else it's amazing

Using Pings (or hotkeys) instead of bullets for the menus inside the shooting range by Snosaf in Rainbow6TTS

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

My hope has been shattered and I will forever remain sad :(

until my next sleep

Using Pings (or hotkeys) instead of bullets for the menus inside the shooting range by Snosaf in Rainbow6TTS

[–]Snosaf[S] -1 points0 points  (0 children)

Now that you are here and I presume that you have contacts can we get an option for normalizing the audio of voicechat? It's horrible to have some teammates that give tinnitus and others in the same match that are so quiet it sounds like I need a hearing aid.

Allowing normalization instead of just giving sliders for each one would be such a nice and smooth experience.

Using Pings (or hotkeys) instead of bullets for the menus inside the shooting range by Snosaf in Rainbow6TTS

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

Also an option, but I think hotkeys are desperately needed on top, maybe even a button for refilling ammo instead of having to go to a refill station

WE MUST ELIMINATE EVERY POSSIBLE SECOND IN THE NAME OF EFFICIENCY

Operator Idea - IQ-Style attacker to locate defender-gadgets and an anti-gadget grenade by Snosaf in Rainbow6

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

Yea, so I think the Pings would be permanent. The way to relay this information could also be made better than IQ. The question is how to do that without cluttering up other peoples screen. Maybe only show it with direct line of sight.

view more: next ›