Recent content by Square1

Yes mark and pasmith. I mean the best solution is just to rearrange the data. I appreciate the function that have been suggested to me! But I will want to keep it a bit simpler than that. Its weird though because when I first started making the sheet, I was copying out data from another sheet...

It works if you only use A1 as array 1, and B1 as array 2 (=sumproduct(A1,B1)). But if I try to include the cells to the right of those two, it doesn't catch the pattern and start to multiply the two, and add the product to a1*b1 (answer is way off) ex: =sumproduct(a1,b1,c1,d1). I keep trying...

I don't have trouble with using it when my data is in vertical form like in the example you gave A1:A10, multiplied by B1:B10. My data is horizontal. I need to multiply A1*B1 add it to C1*D1 add it to E1*F1...etc.

Ughhh...sometimes I am amazed how limited excel is some of its utility. No it's not a big deal but come on Microsoft...Thanks for the advice!

Is there really no other way to use the sumproduct function? Does having my data in horizontal form have something to do with it?

Hi. I am having issues using the sumproduct function in excel. I two values in cells A1 and B1 that I want to multiply. I have two values in cells C1 and D1 that I want to multiply, and so on and so forth. I want to add these products afterwards. I think I have a problem with the syntax I use...

I recognize your username from years ago when I first started using this website and you've helped many at least here I am sure. Interesting though the point that self studiers will want to rush through more so than the regular student. In fact I would say that that is a consequence of the...

Edit. Ah ok I forgot the tail is presenting a large flat surface here..so that will add a bit more understanding. I don't see how the distribution of the weight is a factor here though since even if the gust is on the tail, it would still need to be strong enough to move whatever is loaded in...

I found this clip on youtube of a plane getting pushed on ice due to strong winds. Have a look. I guess I just want to hear some comments about what is reallly going on here. How we can estimate the force of the wind pushing, what chance the ramp agent has of holding the place himself if say...

Right, ok. I get hung up on this because sometimes reading some text, it will make it sound like there is one single magnitude of force that is able to move object of mass x, by y amount of velocity change..ex: "a force moves an object at rest to a velocity of..." Seeing how that can't be the...

Ugh I am kinda confused maybe by what you mean by single force, varying thrust/force. What I am saying, correct me if I'm wrong, is that in the vacuum environment used in school examples, if an object wanted to go from say 0m/s to 10m/s, it could "choose" from a selection of magnitudes of force...

Maybe I wrote it unclearly, but I don't think I had a problem understanding how many forces are needed to change object's velocity. I meant that to change an object's velocity from say 0m/s to 10m/s, varying strengths of forces can be used, each with their own required duration though. Right...

Hmm not sure what you mean. *Edit - because I understand that the rocket in space would accelerate only for as long as the engine is providing propulsive force. Once the engine stops, the rocket remains at its last speed.

Ok I think that helps a lot. Now that I've seen that though, do you even require the concept of momentum though? If you rearrange the formula F=ma into F=m(V1 - V0)/t, it shows itself that for a given object mass and change in velocity, time is another variable that dictates the magnitude of...

*How to perceive the duration of a force I am wondering how should I perceive the occurence of a force, at least while reading an introductory university physics textbook. When I try to think about basic vacuum environment examples of an object receiving a push, I always arrive at the dilema of...