วีดีโอ

=SEQUENCE(25,1,0.5,0.1) will get you a range going from 0.5 to 3.0 at 0.1 intervals instead of something normalised to 100%.

@@ChrisArmstrongChemistry Thank you so much.🙏

It can do stacked bar charts that are scaled to 100%. That's perfectly acceptable for most uses, especially if the number of responses is comparable between questions, and works "out of the box" with no modifications. But those can be a little harder to see exactly where the central tendency is. It'll come down to preference and what you want to show.

Oh never mind it was just loading for a really long time maybe should've listened to you and not used with such big numbers :)

This is a demo/test animation that has mysteriously inserted itself into search results. If you need to know reduced mass, I'd suggest either textbooks or HyperPhysics.

@@ChrisArmstrongChemistry sure that would be great

The reduced mass is essentially a mathematical trick used to account for the accelerations of two bodies exerting a force on each other (constituting an isolated system). If you play with newton's laws of motion (write out the acceleration of one object [call it 2] from the perspective of another [1]) you see that an equation mathematically analogous to (and in fact physically equal to, as can be seen from how it was derived) newton's 2nd law describes their relative interaction, as seen in the frame of [1]. In particular the mass of object [2] is changed to the reduced mass, while the relative force and relative accelerations are unchanged. The purpose of using the reduced mass is to simplify calculations and turn a two body problem into equivalent one body problems, many of which can be solved exactly.

minute 13....is so eye opening. Hat off!

I would try to keep it in ChemDraw or similar where possible if it's more complicated than just providing a figure caption.

I don't think I've seen N/A used with this style.

It has one C3 axis, but it's labelled in the character table as 2C3 as there are two symmetry operations. You can read that as 120 clockwise and 120 anticlockwise, or 120 degrees and 240 degrees.

@@ChrisArmstrongChemistry I see. Thanks!

No one should ever do this.

This is not cool. This is the opposite of cool.

I find that one of the best ways of learning something is to find the silliest possible use-case and do that. Usually you end up learning some advanced things just by accident.

OR() needs two or more statements that evaluate as true or false. You need the conditional formatting formula to read something like =OR(E1="apple", E1="pear"), as those statements should evaluate as TRUE or FALSE. You will need to check the use of $, too. Any other issues with AND() and OR() can usually be resolved by using * and + instead, which treats TRUE as 1 and FALSE as 0.

Thank you Chris. You might want to do a video on this, since i was unable to find anyone talking about my scenario. I can’t be the first to have encountered this. Using the OR function keeps my CF simplified and uncluttered…. Trying it out now.

You might find it useful to try: =NOT(ISERROR(MATCH($E$1,$F$1:$F$2,0))) Where F1:F2 contains your list, "apple", "pear". Here, it looks for it in a list, and if it isn't found, it returns an error. So the NOT() ISERROR() combination will return TRUE if it's found. That way, you can extend your choices to >2 entries more easily. Especially if you replace $F$1:$F$1 with a dynamic array that automatically counts and expands to the right number of entries, which can be done with OFFSET(). So if you add "banana" to F3, it would expand to include that. Obviously, stash that somewhere innocuous, but easy to access.

Good point. I hadn't noticed the difference. My main guess is that it's the order that the parts are rendered in, so swapping the order of the series and which is on which axis probably will change that.

@@ChrisArmstrongChemistry Ah I figured it out, instead of filling the unfilled segment part of the donuts with the same background colour, use No Fill.

Wait, when did this video get any attention?!?

I don't think anything touching something like this is stable during time warp.

I did a few more tests with this. It's fine to timewarp if it's not moving. If you leave it running on "autopilot", where you click away from it while still moving so that it continues to roll on its own, then even tapping once to 5x timewarp causes it to disappear instantly. I think that must be detecting it as having "crashed" into the surface. You can timewarp at the 2-3x one, where the collisions are still on (which is the only speed allowed if you're still holding one of buttons to move), just fine.

Interesting

I tend to throw stuff up randomly as it occurs to me, but if anything might be useful, I suppose I could do requests.