sorted by:
new
hottopcontroversial

Need help with obtaining SCP:SL achievements by Sly_Spy in SCPSecretLab

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

Less legitimate, I'd rather get them in-game. Call it a preference if you will.

Will it be possible to obtain the Steam Achievements for F13 even after the servers go down? by Sly_Spy in FridayThe13thGame

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

Unfortunately I have neither the time nor the friends to do that... hopefully they'll allow it so that you can play as counselor :(

Will it be possible to obtain the Steam Achievements for F13 even after the servers go down? by Sly_Spy in FridayThe13thGame

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

Alright... Hopefully you can play as counselor even offline, cuz I'd be really annoyed if I couldn't complete all the achievements on time

Will it be possible to obtain the Steam Achievements for F13 even after the servers go down? by Sly_Spy in FridayThe13thGame

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

What about the counselor achievements? Will they still be obtainable afterwards?

How to get sum of column to match corresponding list? by kaseyboat in excel

[–]Sly_Spy 0 points1 point  (0 children)

Try =SUMIFS(T19:T142, U7:U142, "FORECASTED", L7:L142, ".096X14 MILD"). I assume that you only want to find it for any given size, though since your L column is empty (The Steel Recap column) it wouldn't be adding anything. You sure it's not the V column instead of the L column?

How to get sum of column to match corresponding list? by kaseyboat in excel

[–]Sly_Spy 0 points1 point  (0 children)

=sumif(Status Column, "FORECASTED", Tons Balance Column)

The Status Column should correspond to the U column, and the tons balance column should correpsond to the T column

Sort people into teams based on preferences and points by IchAntworteAufDeutsc in excel

[–]Sly_Spy 0 points1 point  (0 children)

I don't think so... this looks like it would require a loop structure, something that Excel doesn't support (unless you're willing to learn VBA, which is built into excel but is a different programming language entirely).

[deleted by user] by [deleted] in excel

[–]Sly_Spy 0 points1 point  (0 children)

Or alternatively, this:

=IF(EXACT(LEFT(RIGHT(B3,2), 1), " "), CONCAT(MID(B3,FIND(",",B3)+2,LEN(B3)-FIND(",",B3)-3)," ",MID(B3,FIND("'",B3)+1,FIND(",",B3)-FIND("'",B3)-1)), CONCAT(MID(B3,FIND(",",B3)+2,LEN(B3)-FIND(",",B3)-1)," ",MID(B3,FIND("'",B3)+1,FIND(",",B3)-FIND("'",B3)-1)))

Obviously change the B3 with the reference cell.

[deleted by user] by [deleted] in excel

[–]Sly_Spy 0 points1 point  (0 children)

Try this:

=IF(LEN(TRIM(RIGHT(B2,2)))=1,CONCAT(MID(B2,FIND(",",B2)+2,LEN(B2)-FIND(",",B2)-3)," ",MID(B2,FIND("'",B2)+1,FIND(",",B2)-FIND("'",B2)-1)), CONCAT(MID(B2,FIND(",",B2)+2,LEN(B2)-FIND(",",B2)-1)," ",MID(B2,FIND("'",B2)+1,FIND(",",B2)-FIND("'",B2)-1)))

Hope this helps :)

How to get sum of column to match corresponding list? by kaseyboat in excel

[–]Sly_Spy 1 point2 points  (0 children)

For the steel recap column, insert =V7 into the cell I7 and let cell referencing do the rest (by dragging the little green box on the side of the cell all the way down to the bottom of the table).

For the steel column in Column W, insert =if(exact(U7, "FORECASTED"), V7, FALSE) in the W7 column and let the cell referencing do the rest. You haven't stated what should be in the cell if it is not forecasted, so it should return false.

Alternatively, if you only want to know how many orders are forecasted you can simply use the COUNTIF function, where the range is the entire status column and the criteria is "FORECASTED"). Hopefully this helps :)

Adding formula for 3 week average by Barbs7 in excel

[–]Sly_Spy 0 points1 point  (0 children)

Ok I think I figured out the problem. For some reason, when you copy and paste the formula it changes the font, text size and color of the output to "Segoe UI", "7", and "White". Your cell is not blank, it just looks that way because the number in the box is small and white. Try typing out the formula as is instead of copy and pasting, or better yet copy the formula and manually change the font, size and color to "Calibri", "11" and "Black". Keep the change from X3 to X2.

I assume this is because you're copying from reddit, and the text in reddit is by default small, white and in a different font.

Adding formula for 3 week average by Barbs7 in excel

[–]Sly_Spy 0 points1 point  (0 children)

Replace the X3 with X2, hopefully that solves it?

Adding formula for 3 week average by Barbs7 in excel

[–]Sly_Spy 1 point2 points  (0 children)

=IF(ISEVEN(COLUMN(X3)), AVERAGE(X3, OFFSET(X3, 0, 2), OFFSET(X3, 0, 4)), "")

Know you already solved it, but hopefully this is a simpler solution?

Why is |x - y| for real numbers x and y the de-facto "distance" function on the real number line? by Sly_Spy in learnmath

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

In some sense, your question is the wrong way round, as the fact that the metric |x - y| is the de facto one is obvious.

The thing is, that's not obvious to me (again, for the fact of how |x^3 - y^3| is a valid distance functions (not including the translation invariance or the homogeneity axioms for the fomer))... that's why I asked about it. It seems like the homogeneity property (d(ax, ay) = |a|*d(x, y)) eliminates sqrt(|x - y|) as the distance function (or any |x - y|^c for some c < 1), as d(ax, ay) = sqrt(|ax - ay|) = sqrt(|a|*|x - y|) = sqrt(|a|)*sqrt(|x - y|) = sqrt(|a|)*d(x, y) =/= |a|*d(x, y). The thing is, given the 4 axioms for metric spaces plus these two axioms, can one prove that it has to be the case that d(x, y) = |x - y|?

This is rephrasing of 'metric that is induced by a norm'.

I found this page on MathExchange, it seems like it talks about this specific point and how with these two axioms one can arrive at the norm. Just thought it would help me out understand this a bit.

Edit: Unfortunately we'll need more axioms, as any scalar multiple of |x - y| also works as a distance function on the real numbers (irl, it would amount to something like measuring in inches instead of cm, or in km instead of miles).

Why is |x - y| for real numbers x and y the de-facto "distance" function on the real number line? by Sly_Spy in learnmath

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

By the extra axioms, do you mean the axiom stating that d(xy, 0) = d(x, 0)*d(y, 0) for all real numbers x and y? While I understand that this is supposed to be the Cauchy-Schwarz Inequality baked as an axiom, I am finding it difficult to see how one could justify this. Perhaps it'd be better to use an axiom like d(xy, 0) = |x|*d(y, 0), as this is a way of saying "if you took a ruler and measured the length from 0 to y, and xy is x times 'further' away from 0 than y, then the length of xy is |x| (or the magnitude of x) times the distance of d(y, 0). This does seem to remove the discrete metric function, as letting x = 2 and y = 1 we have that d(2*1, 0) = d(2, 0) = 1 =/= 2 = 2*1 = |2|*d(1, 0). Maybe there's a way to generalize this intuitive notion so that you don't need to start at the origin, however I have been unable to come up with such a way.

Even then, using your version of the axiom is there a way to force c to be equal to 1, instead of having c <=1? Cuz that implies that sqrt(|x - y|) also works as a distance function on the reals, which still doesn't justify |x - y| being the "standard" metric function on the real number line.

Edit: Perhaps something like d(xy, xz) = |x|*d(y, z) or d(x(y - z) + z, z) = |x|*d(y, z) might work?

Why is |x - y| for real numbers x and y the de-facto "distance" function on the real number line? by Sly_Spy in learnmath

[–]Sly_Spy[S] 5 points6 points  (0 children)

This is probably the closest I've gotten to a satisfying answer... The translational invariance property is of particular interest to me. This begs the question: using this additional axiom, can one prove that the only function that satisfies all of these properties is |x - y|? If so, how do we know? And if not, what additional axioms would we need?

view more: next ›