Skip to main content
J
Jacob_S1-Visitor
1-Visitor
July 9, 2021
Solved

Reading Excel Table Vs Range variable usage

  • July 9, 2021
  • 6 replies
  • 5578 views

@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

Best answer by ttokoro

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.

 

 

 

image.pngimage.pngimage.png

6 replies

ttokoro
ttokoro21-Topaz I
21-Topaz I
July 10, 2021

From csv data, you can use mean function. 

image.pngimage.pngimage.pngimage.png

t.t.
    J
    Jacob_S1-VisitorAuthor
    1-Visitor
    July 15, 2021

    @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

    @LucMeekes ...Please help if possible

    ttokoro
    ttokoro21-Topaz I
    21-Topaz I
    July 16, 2021

    Only change the table data what you want. 

    If you want to 

    ttokoro_0-1626399985716.png

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

    ttokoro_1-1626400032905.png

     

    t.t.
      J
      Jacob_S1-VisitorAuthor
      1-Visitor
      July 16, 2021

      @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

      L
      LucMeekes23-Emerald IV
      23-Emerald IV
      July 16, 2021

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

      LucMeekes_0-1626458904720.png

      Attached is a Prime 4 file.

       

      Success!
      Luc

        J
        Jacob_S1-VisitorAuthor
        1-Visitor
        July 16, 2021

        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

        ttokoro
        ttokoro21-Topaz IAnswer
        21-Topaz I
        July 17, 2021

        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.

         

         

         

        image.pngimage.pngimage.png

        t.t.
          Terms & ConditionsAccessibility statement