Sorry for delay, really busy lately.
Cooked little dirty python script to collect data from ManateeMafia's EZGPIB script CSV-format and calculate RMS values automatically.
import csv
import sys
import math
import glob
from math import exp, expm1
from datetime import datetime
#with open('Keithley2002_DCVOLT1000_NPLC1.csv','r') as i:
with open('output.txt','wb') as o:
for filename in glob.glob('*.csv'):
i = open(filename, 'r')
reader = csv.DictReader(i)
#o.write ("date,Keithley2002\r\n")
sum = 0
sqsum = 0
cnt = 0
for row in reader:
#d = datetime.strptime(row['date'], '%d-%m-%Y %H:%M:%S')
#date = d.strftime('%Y-%m-%d %H:%M:%S')
sum = sum + float(row['Keithley2002'])
sqsum = sqsum + pow(float(row['Keithley2002']),2)
cnt = cnt + 1
avg = sum / cnt
rms = math.sqrt(sqsum / cnt)
#print ("Counts %d, RAW:%s SUM:%.8f AVG: %.8f" % (cnt,row['Keithley2002'],sum,avg))
print ("%s ; Counts %d ; RAW:%s ; SQSUM:%.12f ; AVG: %E ; RMS: %E ;" % (filename,cnt,row['Keithley2002'],sqsum,avg,rms))
i.close()
o.write ("%s ; Counts %d ; RAW:%s ; SQSUM:%.12f ; AVG: %E ; RMS: %E ;\n" % (filename,cnt,row['Keithley2002'],sqsum,avg,rms))
It works but need some manual inputs and finetuning.
Then will need to bring other's data format to this one (which should be pretty easy) and import results into nice excel spreadsheet with graphs.
Here's example output from my Keithley 2002 EZGPIB data:
Keithley2002_DCVOLT.1_NPLC.01.csv ; Counts 25173 ; RAW:+0.001932E-03 ; SQSUM:0.000000108820 ; AVG: 1.866774E-06 ; RMS: 2.079154E-06 ;
Keithley2002_DCVOLT.1_NPLC.1.csv ; Counts 3087 ; RAW:+0.006889E-03 ; SQSUM:0.000000172460 ; AVG: 7.467759E-06 ; RMS: 7.474385E-06 ;
Keithley2002_DCVOLT.1_NPLC1.csv ; Counts 29111 ; RAW:+0.002913E-03 ; SQSUM:0.000000296672 ; AVG: 3.187090E-06 ; RMS: 3.192345E-06 ;
Keithley2002_DCVOLT.1_NPLC10.csv ; Counts 3171 ; RAW:+0.003173E-03 ; SQSUM:0.000000030584 ; AVG: 3.101818E-06 ; RMS: 3.105641E-06 ;
Keithley2002_DCVOLT1000_NPLC.01.csv ; Counts 36037 ; RAW:+0.00042E+00 ; SQSUM:0.423976726800 ; AVG: 7.061392E-04 ; RMS: 3.430020E-03 ;
Keithley2002_DCVOLT1000_NPLC.1.csv ; Counts 27187 ; RAW:-0.00007E+00 ; SQSUM:0.004349389700 ; AVG: 2.049807E-04 ; RMS: 3.999756E-04 ;
Keithley2002_DCVOLT1000_NPLC1.csv ; Counts 3085 ; RAW:+0.00017E+00 ; SQSUM:0.000122373500 ; AVG: 1.851572E-04 ; RMS: 1.991664E-04 ;
Keithley2002_DCVOLT1000_NPLC10.csv ; Counts 3146 ; RAW:+0.00018E+00 ; SQSUM:0.000123968200 ; AVG: 1.930960E-04 ; RMS: 1.985070E-04 ;
Keithley2002_DCVOLT100_NPLC.01.csv ; Counts 37259 ; RAW:+0.008344E+00 ; SQSUM:1.047291303500 ; AVG: -1.429550E-04 ; RMS: 5.301737E-03 ;
Keithley2002_DCVOLT100_NPLC.1.csv ; Counts 27343 ; RAW:+0.000114E+00 ; SQSUM:0.000865851267 ; AVG: 1.351317E-04 ; RMS: 1.779502E-04 ;
Keithley2002_DCVOLT100_NPLC1.csv ; Counts 24049 ; RAW:+0.000233E+00 ; SQSUM:0.001122555603 ; AVG: 2.130842E-04 ; RMS: 2.160506E-04 ;
Keithley2002_DCVOLT100_NPLC10.csv ; Counts 3155 ; RAW:+0.000228E+00 ; SQSUM:0.000136496793 ; AVG: 2.070285E-04 ; RMS: 2.079991E-04 ;
Keithley2002_DCVOLT10_NPLC.01.csv ; Counts 37220 ; RAW:+0.0000020E+00 ; SQSUM:0.005388871941 ; AVG: 1.830596E-04 ; RMS: 3.805053E-04 ;
Keithley2002_DCVOLT10_NPLC.1.csv ; Counts 6671 ; RAW:+0.0000119E+00 ; SQSUM:0.000001456198 ; AVG: 1.244638E-05 ; RMS: 1.477457E-05 ;
Keithley2002_DCVOLT10_NPLC1.csv ; Counts 32311 ; RAW:+0.0000139E+00 ; SQSUM:0.000003083435 ; AVG: 9.409851E-06 ; RMS: 9.768822E-06 ;
Keithley2002_DCVOLT10_NPLC10.csv ; Counts 3080 ; RAW:+0.0000012E+00 ; SQSUM:0.000000008606 ; AVG: 1.401396E-06 ; RMS: 1.671587E-06 ;
Keithley2002_DCVOLT1_NPLC.01.csv ; Counts 29560 ; RAW:+0.00000191E+00 ; SQSUM:0.000022246224 ; AVG: 5.251152E-06 ; RMS: 2.743317E-05 ;
Keithley2002_DCVOLT1_NPLC.1.csv ; Counts 3086 ; RAW:+0.00000786E+00 ; SQSUM:0.000000169236 ; AVG: 7.365016E-06 ; RMS: 7.405402E-06 ;
Keithley2002_DCVOLT1_NPLC1.csv ; Counts 6726 ; RAW:+0.00000300E+00 ; SQSUM:0.000000052482 ; AVG: 2.784019E-06 ; RMS: 2.793349E-06 ;
Keithley2002_DCVOLT1_NPLC10.csv ; Counts 3080 ; RAW:+0.00000317E+00 ; SQSUM:0.000000026442 ; AVG: 2.924023E-06 ; RMS: 2.930037E-06 ;
MM's K2002:
Keithley2002_DCVOLT.2_NPLC.01.csv ; Counts 28500 ; RAW:+0.012987E-03 ; SQSUM:0.000001055413 ; AVG: 3.677938E-06 ; RMS: 6.085394E-06 ;
Keithley2002_DCVOLT.2_NPLC.1.csv ; Counts 28500 ; RAW:-0.000484E-03 ; SQSUM:0.000000002879 ; AVG: 8.280295E-08 ; RMS: 3.178376E-07 ;
Keithley2002_DCVOLT.2_NPLC1.csv ; Counts 28500 ; RAW:+0.001461E-03 ; SQSUM:0.000000050083 ; AVG: 1.319546E-06 ; RMS: 1.325635E-06 ;
Keithley2002_DCVOLT.2_NPLC10.csv ; Counts 1190 ; RAW:+0.001523E-03 ; SQSUM:0.000000001753 ; AVG: 1.209540E-06 ; RMS: 1.213718E-06 ;
Keithley2002_DCVOLT1000_NPLC.01.csv ; Counts 28750 ; RAW:+0.00110E+00 ; SQSUM:0.060372603700 ; AVG: 1.076401E-03 ; RMS: 1.449109E-03 ;
Keithley2002_DCVOLT1000_NPLC.1.csv ; Counts 28500 ; RAW:-0.00038E+00 ; SQSUM:0.004084380200 ; AVG: 1.501102E-04 ; RMS: 3.785652E-04 ;
Keithley2002_DCVOLT1000_NPLC1.csv ; Counts 28500 ; RAW:+0.00016E+00 ; SQSUM:0.000835754000 ; AVG: 1.568912E-04 ; RMS: 1.712446E-04 ;
Keithley2002_DCVOLT1000_NPLC10.csv ; Counts 1190 ; RAW:+0.00020E+00 ; SQSUM:0.000025156800 ; AVG: 1.392437E-04 ; RMS: 1.453966E-04 ;
Keithley2002_DCVOLT200_NPLC.01.csv ; Counts 28500 ; RAW:+0.001165E+00 ; SQSUM:0.522674665140 ; AVG: 3.491382E-05 ; RMS: 4.282460E-03 ;
Keithley2002_DCVOLT200_NPLC.1.csv ; Counts 28500 ; RAW:+0.000166E+00 ; SQSUM:0.000580846443 ; AVG: 3.007274E-05 ; RMS: 1.427606E-04 ;
Keithley2002_DCVOLT200_NPLC1.csv ; Counts 28500 ; RAW:+0.000166E+00 ; SQSUM:0.000487367848 ; AVG: 1.260648E-04 ; RMS: 1.307694E-04 ;
Keithley2002_DCVOLT200_NPLC10.csv ; Counts 1190 ; RAW:+0.000117E+00 ; SQSUM:0.000014781988 ; AVG: 1.099160E-04 ; RMS: 1.114533E-04 ;
Keithley2002_DCVOLT20_NPLC.01.csv ; Counts 28250 ; RAW:+0.0000094E+00 ; SQSUM:0.000002496170 ; AVG: 9.400000E-06 ; RMS: 9.400000E-06 ;
Keithley2002_DCVOLT20_NPLC.1.csv ; Counts 28250 ; RAW:+0.0000094E+00 ; SQSUM:0.000001865081 ; AVG: 5.507855E-06 ; RMS: 8.125305E-06 ;
Keithley2002_DCVOLT20_NPLC1.csv ; Counts 28250 ; RAW:+0.0000014E+00 ; SQSUM:0.000000234585 ; AVG: 2.560676E-06 ; RMS: 2.881647E-06 ;
Keithley2002_DCVOLT20_NPLC10.csv ; Counts 1190 ; RAW:+0.0000021E+00 ; SQSUM:0.000000005694 ; AVG: 2.013445E-06 ; RMS: 2.187497E-06 ;
Keithley2002_DCVOLT2_NPLC.01.csv ; Counts 28000 ; RAW:+0.00000480E+00 ; SQSUM:0.000080723282 ; AVG: 8.961264E-07 ; RMS: 5.369334E-05 ;
Keithley2002_DCVOLT2_NPLC.1.csv ; Counts 28000 ; RAW:-0.00000018E+00 ; SQSUM:0.000000021068 ; AVG: 1.519464E-07 ; RMS: 8.674316E-07 ;
Keithley2002_DCVOLT2_NPLC1.csv ; Counts 28250 ; RAW:+0.00000111E+00 ; SQSUM:0.000000040999 ; AVG: 1.182998E-06 ; RMS: 1.204699E-06 ;
Keithley2002_DCVOLT2_NPLC10.csv ; Counts 1190 ; RAW:+0.00000106E+00 ; SQSUM:0.000000001203 ; AVG: 9.911765E-07 ; RMS: 1.005444E-06 ;
Here MM's 3458A_ID111 data:
HP3458A__ID111_DCV.1_NPLC.01.csv ; Counts 43366 ; RAW:1.934592131E-06 ; SQSUM:0.000000075188 ; AVG: -1.572004E-07 ; RMS: 1.316741E-06 ;
HP3458A__ID111_DCV.1_NPLC.1.csv ; Counts 37203 ; RAW:5.277066847E-07 ; SQSUM:0.000000007471 ; AVG: 1.015909E-07 ; RMS: 4.481187E-07 ;
HP3458A__ID111_DCV.1_NPLC1.csv ; Counts 26937 ; RAW:-1.160974125E-07 ; SQSUM:0.000000001669 ; AVG: -1.766057E-07 ; RMS: 2.489070E-07 ;
HP3458A__ID111_DCV.1_NPLC10.csv ; Counts 4909 ; RAW:1.409000080E-07 ; SQSUM:0.000000000104 ; AVG: -1.177160E-07 ; RMS: 1.453049E-07 ;
HP3458A__ID111_DCV.1_NPLC100.csv ; Counts 444 ; RAW:-9.322971815E-08 ; SQSUM:0.000000000006 ; AVG: -1.081460E-07 ; RMS: 1.118537E-07 ;
HP3458A__ID111_DCV.1_NPLC1000.csv ; Counts 54 ; RAW:-1.465289721E-07 ; SQSUM:0.000000000004 ; AVG: -2.635645E-07 ; RMS: 2.857508E-07 ;
HP3458A__ID111_DCV.1_NPLC50.csv ; Counts 1050 ; RAW:-1.359746644E-07 ; SQSUM:0.000000000017 ; AVG: -1.218833E-07 ; RMS: 1.284038E-07 ;
HP3458A__ID111_DCV1000_NPLC.01.csv ; Counts 35418 ; RAW:-1.760964367E-03 ; SQSUM:0.247285785299 ; AVG: 1.443854E-04 ; RMS: 2.642333E-03 ;
HP3458A__ID111_DCV1000_NPLC.1.csv ; Counts 31322 ; RAW:1.761266916E-04 ; SQSUM:0.003887161804 ; AVG: 1.327557E-04 ; RMS: 3.522829E-04 ;
HP3458A__ID111_DCV1000_NPLC1.csv ; Counts 21212 ; RAW:1.585166738E-04 ; SQSUM:0.000154840219 ; AVG: 4.540910E-05 ; RMS: 8.543800E-05 ;
HP3458A__ID111_DCV1000_NPLC10.csv ; Counts 4696 ; RAW:-1.109616452E-04 ; SQSUM:0.000026941396 ; AVG: -6.692175E-05 ; RMS: 7.574361E-05 ;
HP3458A__ID111_DCV1000_NPLC100.csv ; Counts 517 ; RAW:-7.045183825E-05 ; SQSUM:0.000001151042 ; AVG: -4.487046E-05 ; RMS: 4.718461E-05 ;
HP3458A__ID111_DCV1000_NPLC1000.csv ; Counts 53 ; RAW:-4.579369486E-05 ; SQSUM:0.000000095233 ; AVG: -4.064273E-05 ; RMS: 4.238933E-05 ;
HP3458A__ID111_DCV1000_NPLC50.csv ; Counts 1019 ; RAW:-7.221313421E-05 ; SQSUM:0.000002797342 ; AVG: -4.867849E-05 ; RMS: 5.239450E-05 ;
HP3458A__ID111_DCV100_NPLC.01.csv ; Counts 31954 ; RAW:-1.759903619E-04 ; SQSUM:0.012203052480 ; AVG: 2.890893E-04 ; RMS: 6.179760E-04 ;
HP3458A__ID111_DCV100_NPLC.1.csv ; Counts 31054 ; RAW:1.408164788E-04 ; SQSUM:0.003746873958 ; AVG: 3.253337E-04 ; RMS: 3.473568E-04 ;
HP3458A__ID111_DCV100_NPLC1.csv ; Counts 21556 ; RAW:3.696494398E-05 ; SQSUM:0.000056098800 ; AVG: 3.553526E-05 ; RMS: 5.101439E-05 ;
HP3458A__ID111_DCV100_NPLC10.csv ; Counts 4696 ; RAW:-8.625151540E-06 ; SQSUM:0.000001555449 ; AVG: -1.120778E-05 ; RMS: 1.819969E-05 ;
HP3458A__ID111_DCV100_NPLC100.csv ; Counts 517 ; RAW:6.512869530E-06 ; SQSUM:0.000000010226 ; AVG: 1.896423E-07 ; RMS: 4.447513E-06 ;
HP3458A__ID111_DCV100_NPLC1000.csv ; Counts 53 ; RAW:5.280705025E-07 ; SQSUM:0.000000000970 ; AVG: 3.742990E-06 ; RMS: 4.277578E-06 ;
HP3458A__ID111_DCV100_NPLC50.csv ; Counts 1019 ; RAW:-1.179357455E-05 ; SQSUM:0.000000048509 ; AVG: -2.418380E-06 ; RMS: 6.899579E-06 ;
HP3458A__ID111_DCV10_NPLC.01.csv ; Counts 44629 ; RAW:5.282965900E-05 ; SQSUM:0.000033473378 ; AVG: 2.829167E-07 ; RMS: 2.738679E-05 ;
HP3458A__ID111_DCV10_NPLC.1.csv ; Counts 40296 ; RAW:-3.522582372E-06 ; SQSUM:0.000001245022 ; AVG: -4.628066E-06 ; RMS: 5.558499E-06 ;
HP3458A__ID111_DCV10_NPLC1.csv ; Counts 21586 ; RAW:1.409056517E-06 ; SQSUM:0.000000034038 ; AVG: 1.080365E-06 ; RMS: 1.255721E-06 ;
HP3458A__ID111_DCV10_NPLC10.csv ; Counts 4910 ; RAW:-2.113584272E-07 ; SQSUM:0.000000000902 ; AVG: 1.639140E-07 ; RMS: 4.285837E-07 ;
HP3458A__ID111_DCV10_NPLC100.csv ; Counts 367 ; RAW:-5.283960681E-08 ; SQSUM:0.000000000004 ; AVG: -1.665335E-08 ; RMS: 1.080092E-07 ;
HP3458A__ID111_DCV10_NPLC1000.csv ; Counts 54 ; RAW:-5.283960681E-08 ; SQSUM:0.000000000000 ; AVG: -5.707982E-08 ; RMS: 7.202534E-08 ;
HP3458A__ID111_DCV10_NPLC50.csv ; Counts 1059 ; RAW:1.409056182E-07 ; SQSUM:0.000000000033 ; AVG: -1.184525E-07 ; RMS: 1.768822E-07 ;
HP3458A__ID111_DCV1_NPLC.01.csv ; Counts 39630 ; RAW:-3.519855741E-06 ; SQSUM:0.000000382711 ; AVG: 2.404746E-07 ; RMS: 3.107589E-06 ;
HP3458A__ID111_DCV1_NPLC.1.csv ; Counts 26059 ; RAW:3.520460482E-07 ; SQSUM:0.000000007892 ; AVG: 5.182273E-08 ; RMS: 5.503157E-07 ;
HP3458A__ID111_DCV1_NPLC1.csv ; Counts 26998 ; RAW:2.640389526E-07 ; SQSUM:0.000000000876 ; AVG: 6.759768E-08 ; RMS: 1.801146E-07 ;
HP3458A__ID111_DCV1_NPLC10.csv ; Counts 4909 ; RAW:-2.763607045E-07 ; SQSUM:0.000000000155 ; AVG: -1.511198E-07 ; RMS: 1.779424E-07 ;
HP3458A__ID111_DCV1_NPLC100.csv ; Counts 365 ; RAW:-5.984881499E-08 ; SQSUM:0.000000000005 ; AVG: -1.088564E-07 ; RMS: 1.139828E-07 ;
HP3458A__ID111_DCV1_NPLC1000.csv ; Counts 54 ; RAW:-4.224622234E-08 ; SQSUM:0.000000000000 ; AVG: -7.455024E-08 ; RMS: 7.752065E-08 ;
HP3458A__ID111_DCV1_NPLC50.csv ; Counts 1059 ; RAW:2.640388897E-08 ; SQSUM:0.000000000010 ; AVG: -8.820412E-08 ; RMS: 9.886552E-08 ;