Good morning! EDIT: MY 3rd TOCOL is the problem.

So, i have a grid that has slots that may or may not be filled with names.

I'm performing TOCOL on this list to put them all in a column (list) with no gaps, which it is.

However, in another spot on the sheet I turned all of those names into values based on where they are. so in that copy. each cell looks something like =if(D5<>"", "2", "")

So when I run a TOCOL on the copy. it doesnt remove the "blanks" because there is a formula in those cells.

Okay, no big deal. I figure. if I run a 3rd TOCOL on the 2nd TOCOL that didnt remove the "blanks". It would remove the actual blanks present in the 2nd TOCOL. but to my surprise it isnt.

For reference.

1st TOCOL, which works is =TOCOL(C1:E28, 1), gives me all the names in a list
2nd TOCOL, which doesnt "work" is =TOCOL(C50:E77, 1), it gives me all the cells because each cell contains that value formula.
the 3rd TOCOL looks like =TOCOL(P2:P84, 1), which is just supposed to perform TOCOL on the 2nd TOCOL.

I have some homework for statistics.

The professor gives us a list of data that we are supposed to turn into a histogram. and match that data to other histogram models.

At the moment I have to tweak the bin sizes until it shows me 10 bins.

Is there a setting where it just divides my data into 10 bins instead of me having to adjust the sizes until it shows me 10 bins?

Hey all!

My 2015 Ford Cmax hybrid is experiencing some clicks and stuff when turning the wheels and the shop said my CV axle needs replacing. It's a 1000 for them to do 1 of them, but I figured for 400 bucks (for both) and a trip to my dad's we could replace them ourselves.

Are these the 2 parts I need to order?

Part No.NCV717291

Part No.NCV717281

Thanks, I'm sure they are but I really don't wanna order the wrong parts haha.

Have thought about this for a while.

Simple boy, normal life. Was never the center of attention ya-da ya-da.

Anyway he becomes extremely fascinated by wands and their origin.

Short story, he learns how to "merge" with his wand. He embeds it into his body. Allows him to use spells without needing to "hold" a wand because he has one apart of his body. This gives him an edge in combat. He starts dueling and taking wands, and figures out how to imbue multiple wands into his being.

Each wand he collects and adds to himself grants him even more power, and transfigures his body. He quickly obtains levels of power that rivals that of dumbledore / voldemort.

bla bla goes out of control, goes crazy same old bla bla maybe another teenager has to take him down? lol? who knows.

It's nice to fantasize about quirks that obviously make your character easily the strongest with no weaknesses. But what kind of quirks have you thought of that are great, but have exploitable flaws.

My idea was a quirk that allowed the user to change the physical distance between themselves and an object at a max rate of.. say... 50m/s (at their height of hero work).

So, say He is standing X distance from someone or something. As long as they maintain eye contact. they can change the physical space between them. NEITHER the object or user will experience "movement", Their position simply changes. The user can push or pull things away from them, including living things.

Draw backs are the user needs to be maintaining eye contact, be physically strong to take advantage of the quirk, it also requires a lot of practice.

The user would be weak against.

-wide range attacks
-faster quirks
-instant quirks (think shinso)
-probably alot of other things too lol.

It is probably the MOST annoying thing about this game, and what makes me want to give it up the most.

I can spend so much time farming a specific key or whatever. Get into my dungeon... then BAM... DCd.

And that's it... key is gone. all that time/effort wasted. Why? Why is there no system set up to at the very least... PUT ME BACK in the dungeon I was in?

Just like the title asks.

I love this game but every time it crashes I just go "ugh" and do something else. I'd like to not do that lol.

For context, I am a teacher for a VERY large county. 3 times a year we have the students take this extensive test. and we can get a lot of grades out of it. now, I have my own spreadsheet that already converts the data into grades. But It may not be the most user friendly thing to copy and use. (it isn't difficult but you know people).

I was wondering If it was possible to have a simple google site that.

Step 1. let's me upload a spreadsheet (this spreadsheet is formatted the same across all grade levels i'm pretty sure).

step 2. based on certain parameters, such as "if # in cell A23 > 78 then grade = 3". It grades every student's scores. there would also need to be a button that selects grade level, which would then select a different set of parameters. like the words per minute read will be different for 1st grade than 6th grade lol.

step 3. shows all the grades on a new sheet.

No one is asking me to make this but I just want to help other teachers save time. Because it can be quite time consuming to do this. For me it takes a few minutes because of the automated sheet and I wanted to others to make use of it as well.

I see all the top builds putting 7.5% crit on their 2H weapons. to get crit cap. I understand wanting all your hits to crit.

But. 200% crit bonus dmg literally doubles your crit damage, at least how it looks. When I take off my 200% crit weapon. my crit bonus dmg on my screen drops almost in half.

So. if I thinking of crit bonus damage correctly.
Say I have 100% crit bonus dmg. then when I do 100 normal dmg. a crit would be 200? Okay great.

So let's say I swing 100 times. I have 50% crit chance, and 50% base crit bonus.

That means 50 swings would do 150, and 50 swings would do 100. giving me 12,500 dmg.

So. let's say I get that extra 7.5% crit. now 58 (rounding up) do 150 dmg. giving me a total of 12,900

But, if I decide to go for doubling my crit dmg instead. so that 50 of my attacks now do 200 dmg. that gives me 15,000 dmg.

I can only assume my understanding of how crit works is wrong.