Advanced Search

Question: Thank you , that really worked. My next question

Question:Thank you , that really worked. My next question

sund0002 34
vector excel
July 06 2010
0

@epostma Thank you , that really worked. My next question is, if the raw data is in a text file, other than data pasted into excel, how can i import the the two columns of data and do the similar calculation?

The text file is attached.

[0, 0, 0]
Voltage_1 (1) Current_1 (1)
+2.084844E-03 -1.539501E-11
+1.008272E+00 +7.418045E-11
+2.011296E+00 +1.585834E-10
+3.014516E+00 +1.257579E-10
+4.020737E+00 +2.020622E-10
+5.023648E+00 -3.412362E-10
+6.029697E+00 +2.513342E-10
+7.032315E+00 +3.255611E-10
+8.035268E+00 +3.394107E-10
+9.041428E+00 +3.818043E-10
+1.004472E+01 +4.562043E-10
+1.105100E+01 +4.380012E-10
+1.205396E+01 +5.275512E-10
+1.305708E+01 +5.432970E-10
+1.406483E+01 +5.276273E-10
+1.506946E+01 +6.537230E-10
+1.607708E+01 +6.253311E-10
+1.708189E+01 +6.786694E-10
+1.808636E+01 +7.734090E-10
+1.909399E+01 +7.188969E-10
+2.009796E+01 +8.154436E-10
+2.110552E+01 +8.443801E-10
+2.210992E+01 +8.323715E-10
+2.311463E+01 +9.201229E-10
+2.412242E+01 +9.434690E-10
+2.512681E+01 +9.467329E-10
+2.613430E+01 +1.026297E-09
+2.713788E+01 +1.027425E-09
+2.814094E+01 +1.081861E-09
+2.914716E+01 +1.104920E-09
+3.015059E+01 +1.149720E-09
+3.115689E+01 +1.187300E-09
+3.215979E+01 +1.194762E-09
+3.316206E+01 +1.281394E-09
+3.416844E+01 +1.272261E-09
+3.517138E+01 +1.313611E-09
+3.617774E+01 +1.350934E-09
+3.718106E+01 +1.376551E-09
+3.818390E+01 +1.418130E-09
+3.919014E+01 +1.438968E-09
+4.019356E+01 +1.490174E-09
+4.120135E+01 +1.501460E-09
+4.220589E+01 +1.542701E-09
+4.321032E+01 +1.631221E-09
+4.421856E+01 +1.586070E-09
+4.522297E+01 +1.658848E-09
+4.623064E+01 +1.680928E-09
+4.723482E+01 +1.709814E-09
+4.823924E+01 +1.743627E-09
+4.924712E+01 +1.771964E-09
+5.025191E+01 +1.835478E-09
+5.125978E+01 +1.828984E-09
+5.226424E+01 +1.882634E-09
+5.326856E+01 +1.903358E-09
+5.427532E+01 +1.940393E-09
+5.527833E+01 +2.000310E-09
+5.628459E+01 +1.992549E-09
+5.728799E+01 +2.045119E-09
+5.829089E+01 +2.074110E-09
+5.929705E+01 +2.098845E-09
+6.029957E+01 +2.164577E-09
+6.130585E+01 +2.147180E-09
+6.230881E+01 +2.221673E-09
+6.331161E+01 +2.239644E-09
+6.431828E+01 +2.267571E-09
+6.532126E+01 +2.320259E-09
+6.632753E+01 +2.334645E-09
+6.733103E+01 +2.393130E-09
+6.833547E+01 +2.417708E-09
+6.934323E+01 +2.450630E-09
+7.034802E+01 +2.513887E-09
+7.135586E+01 +2.511066E-09
+7.236015E+01 +2.575965E-09
+7.336453E+01 +2.586032E-09
+7.437182E+01 +2.625925E-09
+7.537621E+01 +2.670396E-09
+7.638396E+01 +2.678521E-09
+7.738876E+01 +2.742605E-09
+7.839320E+01 +2.758925E-09
+7.940083E+01 +2.798763E-09
+8.040511E+01 +2.830322E-09
+8.141190E+01 +2.852047E-09
+8.241486E+01 +2.917546E-09
+8.341785E+01 +2.912237E-09
+8.442462E+01 +2.983217E-09
+8.542754E+01 +2.997299E-09
+8.643378E+01 +3.022519E-09
+8.743640E+01 +3.087845E-09
+8.843938E+01 +3.069886E-09
+8.944573E+01 +3.141736E-09
+9.044861E+01 +3.160345E-09
+9.145533E+01 +3.209532E-09
+9.245837E+01 +3.236400E-09
+9.346133E+01 +3.260430E-09
+9.446838E+01 +3.298672E-09
+9.547298E+01 +3.321157E-09
+9.648089E+01 +3.375022E-09
+9.748582E+01 +3.391351E-09
+9.849041E+01 +3.431033E-09
+9.949830E+01 +3.466451E-09
+1.005094E+02 +3.488209E-09
+1.015135E+02 +3.550148E-09
+1.025213E+02 +3.551365E-09
+1.035258E+02 +3.610483E-09
+1.045307E+02 +3.638411E-09
+1.055386E+02 +3.654279E-09
+1.065431E+02 +3.726503E-09
+1.075509E+02 +3.760037E-09
+1.085540E+02 +3.789975E-09
+1.095571E+02 +3.828623E-09
+1.105633E+02 +3.867659E-09
+1.115666E+02 +3.896050E-09
+1.125729E+02 +3.932743E-09
+1.135759E+02 +3.954641E-09
+1.145784E+02 +4.000641E-09
+1.155848E+02 +4.024017E-09
+1.165877E+02 +4.064768E-09
+1.175939E+02 +4.091123E-09
+1.185974E+02 +4.127495E-09
+1.196004E+02 +4.160992E-09
+1.206066E+02 +4.204411E-09
+1.216104E+02 +4.235071E-09
+1.226180E+02 +4.267085E-09
+1.236225E+02 +4.309237E-09
+1.246272E+02 +4.349013E-09
+1.256350E+02 +4.362656E-09
+1.266394E+02 +4.393559E-09
+1.276471E+02 +4.445208E-09
+1.286510E+02 +4.456242E-09
+1.296553E+02 +4.497115E-09
+1.306629E+02 +4.522762E-09
+1.316676E+02 +4.560603E-09
+1.326753E+02 +4.601392E-09
+1.336796E+02 +4.629670E-09
+1.346840E+02 +4.664936E-09
+1.356903E+02 +4.689888E-09
+1.366933E+02 +4.735350E-09
+1.376994E+02 +4.737821E-09
+1.387028E+02 +4.804353E-09
+1.397056E+02 +4.812088E-09
+1.407118E+02 +4.882349E-09
+1.417142E+02 +4.894210E-09
+1.427205E+02 +4.963868E-09
+1.437234E+02 +4.959156E-09
+1.447267E+02 +5.026900E-09
+1.457328E+02 +5.064036E-09
+1.467359E+02 +5.118719E-09
+1.477421E+02 +5.129789E-09
+1.487458E+02 +5.191246E-09
+1.497500E+02 +5.209259E-09
+1.507576E+02 +5.276312E-09
+1.517622E+02 +5.279829E-09
+1.527697E+02 +5.356369E-09
+1.537740E+02 +5.384279E-09
+1.547781E+02 +5.438773E-09
+1.557852E+02 +5.460422E-09
+1.567894E+02 +5.488222E-09
+1.577969E+02 +5.520811E-09
+1.588014E+02 +5.570371E-09
+1.598057E+02 +5.575345E-09
+1.608132E+02 +5.651877E-09
+1.618172E+02 +5.663252E-09
+1.628235E+02 +5.732052E-09
+1.638265E+02 +5.776316E-09
+1.648294E+02 +5.752269E-09
+1.658361E+02 +5.834192E-09
+1.668389E+02 +5.814748E-09
+1.678452E+02 +5.885950E-09
+1.688477E+02 +5.909764E-09
+1.698506E+02 +5.983261E-09
+1.708569E+02 +6.006442E-09
+1.718603E+02 +6.047213E-09
+1.728665E+02 +6.078885E-09
+1.738695E+02 +6.126250E-09
+1.748725E+02 +6.152331E-09
+1.758798E+02 +6.178037E-09
+1.768842E+02 +6.230961E-09
+1.778917E+02 +6.249762E-09
+1.788967E+02 +6.297768E-09
+1.799009E+02 +6.315666E-09
+1.809086E+02 +6.385553E-09
+1.819125E+02 +6.397836E-09
+1.829201E+02 +6.417491E-09
+1.839245E+02 +6.451984E-09
+1.849288E+02 +6.506398E-09
+1.859369E+02 +6.551122E-09
+1.869411E+02 +6.598350E-09
+1.879488E+02 +6.630926E-09
+1.889529E+02 +6.699431E-09
+1.899559E+02 +6.729825E-09
+1.909622E+02 +6.771036E-09
+1.919652E+02 +6.801712E-09
+1.929721E+02 +6.839246E-09
+1.939751E+02 +6.881621E-09
+1.949782E+02 +6.878314E-09
+1.959839E+02 +6.941617E-09
+1.969870E+02 +6.947759E-09
+1.979935E+02 +7.026036E-09
+1.989969E+02 +7.056673E-09
+2.000001E+02 +7.109488E-09

Download 200-1.1.txt
Please Wait...