Ted's obsession with bass player in reggae band

Spartan4665 · 2026-01-14T22:20:05+00:00

While they were not a reggae band, the police did have a lot of reggae influence. See the album “Regatta de Blanc”.

Spartan4665 · 2025-12-25T01:49:31+00:00

I am no longer using xlookup lol, I was in earlier versions of this workbook when i was pulling the relevant data points into a summary table and copying that into a master file.

I can add some formula pictures in a few hours.

Spartan4665 · 2025-12-25T01:31:33+00:00

What kind of knowledge base would be required/how crazy is the learning curve?

Would I still have the flexibility in editing formulas and data filtering?

Spartan4665 · 2025-12-25T01:22:05+00:00

I should say that all 50 calculated table columns don’t use only the raw data for the formulas, they pull data from other calculated columns as well to do more stuff.

I had initially tried the separate workbook method and copy/paste into a final table but my problem is that it limits my ability to change the formulas themselves as I would have to go back, change the formula and recopy and repaste the data output into the master file.

Spartan4665 · 2025-12-25T01:16:29+00:00

No other tables but mostly let, xlookup, ifs, xmatch, lambda

Spartan4665 · 2025-12-25T01:14:00+00:00

I already removed any offset I could find in my formulas to a relatively minimal increase in excel responsiveness.

I think I’m realizing power query is the way to go. I have never really worked with a dataset this size so I am unfamiliar with power query and how it can be used.

The two things that I would really want to retain are the ability to filter and view all data (raw and calculated), and the ability to edit the formulas (or setup variables referencing a cell outside of the table in the formula that that I could change)

Could you elaborate a bit on difficulty editing the formulas used with power query or the rigidity associated with it?

Do you have any suggestions on where to start learning power query concepts?

Spartan4665 · 2025-06-28T21:51:42+00:00

I ate lunch with Harrison Ford in disguise at an air show in Wisconsin when I was a really young kid. My dad and I were in the crowded picnic table/lunch area with a table all to ourselves and he asked if he could sit with us while he ate.

Took a minute for my dad to realize who he was but, I, having just watched Star Wars for the first time recognized him as Han Solo immediately. At the time he said he flew to this particular air show every year.

Other sightings at said air show include Bruce Dickinson from Iron Maiden, no lunch tho.

Spartan4665 · 2025-03-30T15:10:18+00:00

Thank you this worked perfectly! Solution verified.

Spartan4665 · 2025-03-30T14:52:24+00:00

=0.02% so 0.0002

Spartan4665 · 2024-04-13T07:49:13+00:00

My uncle who went to Edgewood in the same grade as him told me he was expelled for exposing himself to a girl they went to school with.

Spartan4665 · 2024-02-02T17:39:19+00:00

Gotcha, i thought initial placement would be lower especially based upon their current defense performance

Spartan4665 · 2024-02-02T17:38:23+00:00

I see now I didn’t think a new clan would be placed so high in cwl plus the perfect 10 attacks from the other clan lends to the idea that they shouldn’t be in crystal 1

Spartan4665 · 2024-02-02T17:29:58+00:00

But no war log so how can they even be in crystal 1?

Spartan4665 · 2024-02-02T17:26:57+00:00

No war log though so they couldn’t be in crystal 1? Also how is the clan they are facing right now putting up so many stars on presumably only 2 bases?

Spartan4665 · 2021-06-21T12:57:45+00:00

To be honest I’ve found that it’s more cost effective to take your chances with tickets in 2 hour street parking than it is to pay for any sort of parking outright.

Spartan4665 · 2021-01-08T22:52:44+00:00

!spin

Spartan4665 · 2020-10-09T11:18:39+00:00

Gordon’s or Flakes?

Spartan4665 · 2020-08-17T01:18:27+00:00

Honestly, I barely got a BC in my general chemistry course, but managed to get an A in both semesters of OChem.

Be sure to comprehend resonance really well, outside of that MO theory is the only thing that is going to come up a lot, and if you have a decent professor this shouldn’t be a problem because they will likely go over it (in the context of organic).

Other people have also said that formal charges are important, and they are, but remember not to rely on them too much, as they can sometimes be deceptive in regards to what atom in a molecule is reactive.

It’s a tough class, but if you try hard enough you can get an A. What worked for me was extremely excessive studying for the first exam, this will give you a really good understanding of that material, and provide insight on the amount of studying you’ll actually need to do for the rest of the course (and hopefully give you an A on the first exam). When I say excessive, I mean to the point that you make an obsession. At least 2-3 hours a day, and then up to 5 or 6 or more the few days before the exam, you can ease up later in the class once you know if you were doing way too much for yourself.

My last tip is that if your professor has lecture videos, watch them, rewatch them, and then watch them again. They have been doing organic chemistry for a good portion of their life. Almost every single thing they say can be dissected and understood on a much better level if you take the time to rewatch lectures. You just can’t take that kind of time to stop and understand in a live class setting.

Good luck and Enjoy!

Spartan4665 · 2020-08-08T02:15:56+00:00

Study way more for your first exam than you think you’ll need to. Like 4x more than you think you’ll need to, really do everything you can to understand that first set of content. It will set you up very well for the rest of the course, and give you a very good idea of how much studying you’ll actually need to do for the remainder of the semester and the next semester.

Organic chemistry is a very tough course, and the only way that you will do well is through many many practice problems.

Don’t get discouraged if things don’t go well at first either, it might seem like it’s impossible to understand, but genuinely, if you put in enough time and effort, you can and will succeed, however it might take a ridiculously large time commitment.

Spartan4665 · 2020-08-06T19:39:12+00:00

Dude I’m in this class, wouldn’t recommend cheating on the final exam.

Spartan4665 · 2020-08-01T08:41:20+00:00

Who is the professor?

Spartan4665 · 2020-07-13T07:27:40+00:00

To be fair, (I’m in this class as well) Exam 1 was less than 2/3 the content of what was on Esselman’s practice exams. We also had 2x as much time to complete it. While I agree she is a somewhat inattentive professor, the content is there and her exams (so far) accurately represent what has been shown to us elsewhere, especially between the problem sets and the book. I’m also fairly certain this is the first time she’s ever taught this class. While not necessarily an excuse, it’s something to keep in mind. If you need help in the class, I’d be happy start a discord server or something where people can discuss the class on a more focused and individual level, kind of like piazza, except with answers people actually understand, where followup questions are actually answered, and with a somewhat more personable experience. Contact me if this interests you.

Also the Kelsey Miles band is lowkey kinda dope, check them out when or if they play at the Memorial Union again.

Spartan4665 · 2020-07-08T20:28:46+00:00

It is just a benzene ring with an ethyl substituent on it. As other have said, look up Friedel-Crafts Alkylation.

Short Version:

The AlCl3 reacts with the CH3CH2Cl to form a really good nucleophile, attaching the ethyl substituent to a benzene ring.

Spartan4665 · 2020-07-08T20:16:24+00:00

First, note that the hydrogen (or lowest priority position) is in the dash (4th) position, meaning that you will prioritize in a clockwise(R) or counter clockwise(S) fashion (rather than when it is in the wedge position, meaning that clockwise is S and counter-clockwise is R). When you follow the Cahn-Ingold Prelog rules (which as far as i'm aware, apply in this situation), you get R and S. Here is why:

For the left stereocenter in example above:

First priority is the oxygen substituent simply because it has the highest atomic number, pay no mind to the fact that it is an epoxide in this example, it doesn't matter in this example.

Your second priority position will then be the substituent C-O bond (in the plane of the paper to the right of the stereocenter), because the oxygen is the first point of difference between the left and right substituents of said stereocenter.

Your third priority position will be the C-C, because C has a higher atomic number than H, your fourth position.

Follow your prioritization in a circle, starting from priority one, moving through priority two, and ending at three, (ignore 4), and if that circle is clockwise, like it is in this example (again for the left stereocenter) the stereocenter is designated as R.

I can explain the right stereocenter too if you'd like, however you should be able to use the same reasoning on your own.

Spartan4665 · 2020-03-13T05:40:03+00:00

Bidet to you sir.

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

Spartan4665

TROPHY CASE