how to create knee flexion and extension graph from this raw data xyz

[siti89]

Hi. I would like to know how to create knee flexion and extension graph for right and left knee from this raw data xyz. its quite confused

[Andy Pope]

I put your values into my 3d scatter chart. You can use the vertical scroll bar to move through the frames of data.

The horizontal scroll bars allow you to rotate the perspective.

[shg]

	L	M	N	R	S	T	X	Y	Z	AA	AB	AC
4	R.ANKLE			R.KNEE			R.HIP
5	X4	Y4	Z4	X6	Y6	Z6	X8	Y8	Z8
6
7	-746.5	445.9	62.6	-807.7	468.8	400.0	-971.9	536.2	795.3		166.8	AB7: {=DEGREES(ACOS(SUMPRODUCT(X7:Z7 - R7:T7, L7:N7 - R7:T7)/SQRT(SUMSQ(X7:Z7-R7:T7)*SUMSQ(L7:N7-R7:T7))))}
8	-719.6	441.8	59.6	-790.0	467.6	396.1	-949.1	535.9	792.3		168.9
9	-704.6	434.5	52.8	-769.3	465.0	392.8	-925.4	535.2	789.5		168.5

The curly braces mean that this is an array formula. Paste the formula in the formula bar, press and hold the Ctrl and Shift keys, then press Enter. You'll know you did it correctly if those curly braces appear; you cannot type the braces manually.

[siti89]

Thank you so much for your help...it is really help me a lot.. thank you

[siti89]

I have done with the formula tips from you. Now the problem is I did not have the ERP data from this individual. Is it possible
for me to get ERP data from this walking gait cycle? How I should get it from which frame?

[shg]

ERP? I have no idea what you're talking about, sorry.

[siti89]

sorry, it is refer to neutral position or angles for the anatomical position of the hip, knee, and ankle. so, how i should create
the graph of knee flexion adn extension on the same graph? is it possible for me?

[shg]

See attached.

[siti89]

i got it..thank you very much. you help me a lot

[shg]

You're welcome.

[Miha21]

Andy, how do you connect certain dots together in the scatter plot? Letīs say I want to add right shoulder and I want to connect it with left ankle. There is a sequence rule I see but is there any other option to do it as my data contains upper body as well. Thanks, Miha

[Andy Pope]

The order of the dots is determined by the order of the range used for data points. There actual position is based on the value.
So the value of the first data point will be connected to the second data point. In order to break the line you need a data point with no value. In this instance that means a completely empty cell.
If the cell contains something it will be treated as a value, zero or no data point but the line will be interpolated between valid points.

[Miha21]

Very helpful, thanks! How can I set the number of time frames?

[AliGW]

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread. This is no longer simply a follow-up question.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

[Miha21]

Andy, just found your webpage, Iīll learn it from there, thanks. AliGW I see, no problem. Thanks, Miha