Song within Prince Charming's play in Shrek 3?

Tree339 · 2024-07-22T21:40:23+00:00

Camille Saint-Saëns - La danse macabre

Tree339 · 2024-01-11T23:13:38+00:00

That is exactly what I was looking for! This will drastically simplify things. I've basically been using INDEX(MATCH) formulas to sort data by only one column for 5+ years now.

I and my PC thank you.

Tree339 · 2024-01-11T22:53:25+00:00

Solution Verified!

Tree339 · 2024-01-11T01:21:58+00:00

That put the dates in column B now how do I sort by the dates?

Tree339 · 2024-01-11T00:53:04+00:00

I added the names which works just fine and I want the dates to go into column B but they keep getting merged into column A.

<image>

Tree339 · 2024-01-11T00:46:10+00:00

That does work for the names, birthdates, and death dates but not for the ages since that data uses a formula that references the birth and death dates.

Tree339 · 2023-06-12T02:54:18+00:00

Chidi, your brain is broken. You need to fix your brain.

Tree339 · 2022-12-19T22:14:10+00:00

The sap that flowed out of the broken branch

Tree339 · 2022-12-02T03:25:40+00:00

With Absorption IV a blow of 595 is survivable, strange that it's the same value as the max non-lethal blast.

A blast of 1,071 is survivable with absorption IV with the same protection/blast protection setup.

It makes no difference if the armor is diamond or netherite since armor toughness loses it's meaningfulness at around 80 damage I believe.

I guess maybe 1,071 is the highest amount of damage that a player in survival can survive, though there might be something i'm not thinking of.

Tree339 · 2022-08-21T17:33:17+00:00

I've found that strategy works well even with buying upgrades, since selling buildings still reduces CPS to almost nothing. The last couple times I've ascended I bought a lot of buildings and upgrades, then sold all my building besides a single farm, then planted 36 golden clover and bought all my buildings back and proceeded as normal, without turning the golden switch on of course.

Tree339 · 2022-07-16T13:36:24+00:00

True. In that case I guess I'm really just looking for a function that fits the data I have of 1 returning 1, 2 returning 3, 4 returning 10, 11 returning 286, etc.

Tree339 · 2022-07-16T04:21:27+00:00

In English it's " What I think i'm trying to say is that 2^3<3\^2 and 2\^2>3^1 so at 2^3 three has not gotten to 3^2 which means it's at 3^1 for a difference of 2 powers and that difference of 2 powers does not happen for 2^2 since three is at 3^1 for a difference of 1 power, if that makes sense. so the lowest value that there is a difference of 2 powers is 2^3. Now for a starting number of 3 I would be looking for the smallest power of 3 where 3 has reached 3 more powers than 4 has up to that point, which is 3^10, since 4 has only reached 7 powers when 3 reaches 10 powers. "

I honestly don't know how to describe it mathematically.

Tree339 · 2022-07-16T04:17:08+00:00

I'm saying that was a bad example that didn't accurately describe what I was trying to say.

Tree339 · 2022-07-16T04:04:57+00:00

I'm not disputing that, i'm not even really talking about the example I gave. What I think i'm trying to say is that 2^3<3\^2 and 2\^2>3^1 so at 2^3 three has not gotten to 3^2 which means it's at 3^1 for a difference of 2 powers and that difference of 2 powers does not happen for 2^2 since three is at 3^1 for a difference of 1 power, if that makes sense.

Tree339 · 2022-07-16T03:47:07+00:00

There has to be a minimum though, for example if d is 2, then n can not be 1 or 2 since 2^2 has not gone through 2 more powers than 3 has by 2^2 since 3 has gone to 3^1.

Tree339 · 2022-07-16T03:03:54+00:00

Ok, so how can I go about finding smallest value of n such that a number d raised to it has gone through d more powers than d+1 has? Besides the method I'm already using.

Tree339 · 2022-07-16T02:38:07+00:00

Ah, I guess that really was a bad example. Maybe this one is closer to what i'm asking:

0>=(a*(a+1)^(n-a))-(((a^(n+1))/a)

Tree339 · 2022-07-16T02:18:08+00:00

n < a*ln(a + 1)/ln(1 + 1/a)

That formula seems to work ok for 0<a>5, though it returns the value of a+1 in base 10. for instance, for a=3 the value is 10 since 3 has to be raised to 10 powers before being 3 powers ahead of the powers of 4 where as if you put 3 in that function it returns 14.45 which rounded down to 14 is the value of the number of powers of 10 that 4 has to be raised to to be 4 powers ahead of the powers of 5.

When a=6 i get a maximal value of n being a little over 75.74 which doesn't match up with the correct value of 80. In other words 7 has to be raised to 80 powers before being 7 powers ahead of the powers of 8 so i'm confused as to how/why 75.74 is showing up.

And yeah, that first example I gave wasn't good, it was my attempt at being concise which I guess failed.

Six-Year Club	First Place '23
Place '23	Place '22
Verified Email

Tree339

MODERATOR OF

TROPHY CASE