cancel
Showing results for
Did you mean:
cancel
Showing results for
Did you mean:

Community Tip - Help us improve the PTC Community by taking this short Community Survey! X

6-Contributor

## Reading Excel Table Vs Range variable usage

@LucMeekes ....With your help from my previous post , I was able create a n excel table based on the timing matrix (both attached, plot the  waveform and then calculated average Power dissipation in a cycle...

Can i do the same plot and find average  using range variable(from time vs power matrix), there by i can skip the excel part of it?

Can you show me an example?

Thank you

Jacob

1 ACCEPTED SOLUTION

Accepted Solutions
20-Turquoise
(To:Jacob_S)

Programming lesson of data set.

From csv Data, programming makes Power Table data Ans as shown below.

But this is only for this data set and if the data has noises it becomes more difficult.

Therefore, this is only the first step to make table data.

Tokoro.

7 REPLIES 7
20-Turquoise
(To:Jacob_S)

From csv data, you can use mean function.

6-Contributor
(To:Jacob_S)

@ttokoro .....Thanks for trying help me...

I generated the excel file from the  attached  time vs power matrix

Here my question is with out generating the excel file, Is it possible to find the average power , from the attached matrix , using  Range variable?

@ttokoro ...In   your attached file  with programming  the power extends in to negative region(quadrant 4). We cannot do that. That will give us error. I in the attached excel file you can see that i multiplied. I corrected the Matrix to  look like the excel table. New matrix  attached

20-Turquoise
(To:Jacob_S)

Only change the table data what you want.

If you want to

The table data should be below, that is readable from your csv data.

6-Contributor
(To:ttokoro)

@ttokoro ...your detailed explanation in  resolving it thru programming is highly appreciated. I am still looking to see someone can help me resolve this thru range variables

23-Emerald III
(To:Jacob_S)

I guess this is sort of what you are looking for:

Attached is a Prime 4 file.

Success!
Luc

6-Contributor
(To:Jacob_S)

This is great job...

I was expecting a little bit more simpler solution where range variable s splitting different sections in the plot as per matrix and then combining these sections in the plot , after that find the average from plot...Once again thanks a lot for helping. Corrected matrix included

20-Turquoise
(To:Jacob_S)

Programming lesson of data set.

From csv Data, programming makes Power Table data Ans as shown below.

But this is only for this data set and if the data has noises it becomes more difficult.

Therefore, this is only the first step to make table data.

Tokoro.

Announcements
Top Tags