{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["gauss3 21","BimodalG 21","Voff datasheet","voff sim"],"not_rendered":{"charts":10,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"gauss3 21","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["PDF and CDF - gauss3, 21 pts",null,null,null,null,"Hit ALT-F11 to see VBA Code"]
[null,null,null,null,null,null,null,null,null,null,"Enter"]
["Enter Gaussian Parameters",null,null,null,null,null,null,null,null,null,"Calc"]
["divisor",3,"Enter N-sigma process"]
["sigma",{"$f":"(B9-B8)/2/B4","v":0.33333333333333331},"((UL-LL)/2)/divisor"]
["mean",0]
[null,null,null,null,null,null,null,null,"Get Table"]
["LL",-1,"Lower Limit",null,null,null,null,"Copy this cell ->",{"$f":"getTable($E$16:$E$37, $F$16:$F$37)","v":"Table(input , 0,-1, 0.001,-0.905, 0.004,-0.81, 0.01,-0.714, 0.022,-0.619, 0.042,-0.524, 0.075,-0.429, 0.125,-0.333, 0.194,-0.238, 0.283,-0.143, 0.387,-0.048, 0.5,0.048, 0.613,0.143, 0.717,0.238, 0.806,0.333, 0.875,0.429, 0.925,0.524, 0.958,0.619, 0.978,0.714, 0.99,0.81, 0.996,0.905, 0.999,1)"}]
["UL",1,"Upper Limit",null,null,null,null,"Paste \"values\" here ->","Table(input , 0,-1, 0.001,-0.905, 0.004,-0.81, 0.01,-0.714, 0.022,-0.619, 0.042,-0.524, 0.075,-0.429, 0.125,-0.333, 0.194,-0.238, 0.283,-0.143, 0.387,-0.048, 0.5,0.048, 0.613,0.143, 0.717,0.238, 0.806,0.333, 0.875,0.429, 0.925,0.524, 0.958,0.619, 0.978,0.714, 0.99,0.81, 0.996,0.905, 0.999,1)"]
[null,null,null,null,null,null,null,"Use Table() for SPICE lookup. "]
["K scaling",{"$f":"1/(B5*SQRT(2*PI()))","v":1.1968268412042982},"1/(sigma*sqrt(2*pi)"]
["Nmax",{"$f":"MAX(C16:C116)","v":21}]
[]
["Create Data",null,null,null,"  ICDF look-up table"]
[null,null,"Index","PDF","CDF","x"]
[null,null,0,{"$f":"$B$11*EXP(-0.5*((F16-$B$6)/$B$5)^2)","v":1.3295545235814022E-2},0,{"$f":"$B$8+($B$9-$B$8)/$B$12*C16","v":-1}]
[null,null,{"$f":"C16+1","v":1},{"$f":"$B$11*EXP(-0.5*((F17-$B$6)/$B$5)^2)","v":3.0076843750165373E-2},{"$f":"E16+D16/$D$39","v":1.2682881163314631E-3},{"$f":"$B$8+($B$9-$B$8)/$B$12*C17","v":-0.90476190476190477}]
[null,null,{"$f":"C17+1","v":2},6.2705517527370511E-2,{"$f":"E17+D17/$D$39","v":4.1373771855288182E-3},-0.80952380952380953]
[null,null,3,{"$f":"$B$11*EXP(-0.5*((F19-$B$6)/$B$5)^2)","v":0.12048324132270927},1.0118979391217461E-2,-0.7142857142857143]
[null,null,4,0.2133511155872804,2.1612111901125573E-2,-0.61904761904761907]
[null,null,5,0.34818542101817013,4.1964092937339256E-2,-0.52380952380952384]
[null,null,6,0.52368922284420039,7.5178182613607841E-2,-0.4285714285714286]
[null,null,7,0.72591217355742998,0.12513392389415667,-0.33333333333333337]
[null,null,8,0.92734623245719927,0.19438010875487577,-0.23809523809523814]
[null,null,9,1.0918101651464507,0.28284148325962816,-0.1428571428571429]
[null,null,10,1.1846764197907831,0.3869913946160356,-4.7619047619047672E-2]
[null,null,11,1.1846764197907831,0.49999999999999994,4.761904761904745E-2]
[null,null,12,1.0918101651464511,0.61300860538396429,0.14285714285714279]
[null,null,13,0.92734623245719927,0.71715851674037179,0.23809523809523814]
[null,null,14,0.72591217355743021,0.80561989124512412,0.33333333333333326]
[null,null,15,0.52368922284420083,0.87486607610584322,0.42857142857142838]
[null,null,16,0.34818542101817035,0.92482181738639202,0.52380952380952372]
[null,null,17,0.2133511155872804,0.95803590706266062,0.61904761904761907]
[null,null,18,0.12048324132270938,0.97838788809887434,0.71428571428571419]
[null,null,19,6.2705517527370636E-2,0.98988102060878247,0.80952380952380931]
[null,null,20,3.0076843750165415E-2,0.99586262281447113,0.90476190476190466]
[null,null,21,1.3295545235814022E-2,0.99873171188366849,1]
[]
[null,null,"Sum",{"$f":"SUM(D16:D37)","v":10.483063796475149},"sum used for CDF normalizing"]

{"sheet":"BimodalG 21","index":1,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["PDF and CDF - Gaussian Bimodal"]
[null,null,null,null,null,null,null,null,"Enter"]
["Enter Gaussian Parameters",null,null,null,"Remove Center Values",null,null,null,"Calc"]
["divisor",3,"Enter N-sigma process",null,"removal factor %",50]
["std",{"$f":"(B9-B8)/2/B4","v":0.33333333333333331},"((UL-LL)/2)/divisor"]
["mean",0,null,null,"Ntot",{"$f":"MAX(B16:B36)","v":20}]
[null,null,null,null,"center",{"$f":"F6/2","v":10},null,null,null,"Get Table"]
["LL",-1,"Lower Limit",null,null,null,null,null,"Copy this cell ->",{"$f":"getTable($E$16:$E$36, $F$16:$F$36)","v":"Table(input , 0,-1, 0.011,-0.905, 0.026,-0.81, 0.047,-0.714, 0.076,-0.619, 0.112,-0.524, 0.158,-0.429, 0.212,-0.333, 0.276,-0.238, 0.346,-0.143, 0.422,-0.048, 0.5,0.048, 0.578,0.143, 0.654,0.238, 0.724,0.333, 0.788,0.429, 0.842,0.524, 0.888,0.619, 0.924,0.714, 0.953,0.81, 0.974,0.905)"}]
["UL",1,"Upper Limit",null,"width",{"$f":"F6*F4/100","v":10},null,null,"Paste \"values\" here ->","Table(input , 0,-1, 0.008,-0.9, 0.026,-0.8, 0.064,-0.7, 0.14,-0.6, 0.276,-0.5, 0.5,-0.4, 0.5,-0.3, 0.5,-0.2, 0.5,-0.1, 0.5,0, 0.5,0.1, 0.5,0.2, 0.5,0.3, 0.5,0.4, 0.5,0.5, 0.724,0.6, 0.86,0.7, 0.936,0.8, 0.974,0.9, 0.992,1)"]
[null,null,null,null,"half_width",{"$f":"F9/2","v":5},null,null,"Use Table() for SPICE lookup. "]
["K1",1,"PDF scaling"]
[]
[]
["Create Data"]
[null,"Index","select","Gauss-Bimodal","CDF","x"]
[null,0,{"$f":"IF(AND(B16>($F$7-$F$10),B16<($F$7+$F$10)),0,1)","v":1},{"$f":"IF(C16>0,$B$11*EXP(-0.5*((F16-$B$6)/$B$5)^2), 0)","v":1.1108996538242306E-2},0,{"$f":"$B$8+($B$9-$B$8)/$F$6*B16","v":-1}]
[null,{"$f":"B16+1","v":1},1,{"$f":"IF(C17>0,$B$11*EXP(-0.5*((F17-$B$6)/$B$5)^2), 0)","v":2.6121409853918223E-2},{"$f":"E16+D16/$D$38","v":7.6490660310229138E-3},{"$f":"$B$8+($B$9-$B$8)/$F$6*B17","v":-0.9}]
[null,{"$f":"B17+1","v":2},1,{"$f":"IF(C18>0,$B$11*EXP(-0.5*((F18-$B$6)/$B$5)^2), 0)","v":5.6134762834133677E-2},{"$f":"E17+D17/$D$38","v":2.5634883931695933E-2},-0.8]
[null,3,1,0.11025052530448522,6.4286305423815401E-2,-0.7]
[null,4,1,0.19789869908361465,0.14019897180244778,-0.6]
[null,5,1,0.32465246735834974,0.27646152364798199,-0.5]
[null,6,0,0,0.5,-0.39999999999999991]
[null,7,0,0,0.5,-0.29999999999999993]
[null,8,0,0,0.5,-0.19999999999999996]
[null,9,0,0,0.5,-9.9999999999999978E-2]
[null,10,0,0,0.5,0]
[null,11,0,0,0.5,0.10000000000000009]
[null,12,0,0,0.5,0.20000000000000018]
[null,13,0,0,0.5,0.30000000000000004]
[null,14,0,0,0.5,0.40000000000000013]
[null,15,1,0.32465246735834974,0.5,0.5]
[null,16,1,0.19789869908361457,0.72353847635201807,0.60000000000000009]
[null,17,1,0.11025052530448512,0.85980102819755222,0.70000000000000018]
[null,18,1,5.6134762834133677E-2,0.93571369457618447,0.8]
[null,19,1,2.6121409853918188E-2,0.97436511606830389,0.90000000000000013]
[null,20,1,1.1108996538242306E-2,0.99235093396897689,1]
[]
[null,null,null,{"$f":"SUM(D16:D36)","v":1.4523337219454875},"sum for CDF normalizing"]

{"sheet":"Voff datasheet","index":2,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["PDF and CDF - enter voff from datasheet"]
[null,null,null,null,null,null,null,null,null,null,"Enter"]
[null,null,null,null,null,null,null,null,null,null,"Calc"]
[]
[]
[]
["Enter Data",null,null,null,null,null,null,null,"Get Table"]
["LL",-0.3,null,null,null,null,null,"Copy this cell ->",{"$f":"getTable($E$16:$E$28, $F$16:$F$28)","v":"Table(input , 0,-1, 0.011,-0.905, 0.026,-0.81, 0.047,-0.714, 0.076,-0.619, 0.112,-0.524, 0.158,-0.429, 0.212,-0.333, 0.276,-0.238, 0.346,-0.143, 0.422,-0.048, 0.5,0.048, 0.578,0.143)"}]
["UL",0.3,null,null,null,null,null,"Paste \"values\" here ->","Table(x , 0,-0.3, 0.53,-0.25, 0.66,-0.2, 0.72,-0.15, 0.79,-0.1, 0.85,-0.05, 0.89,0, 0.93,0.05, 0.94,0.1, 0.95,0.15, 0.97,0.2, 0.98,0.25, 0.99,0.3)"]
[null,null,null,null,null,null,null,"Use Table() for SPICE lookup. "]
[]
["Nmax",{"$f":"MAX(C16:C107)","v":12}]
[]
["Create Data"]
[null,null,"Index","Enter %","CDF","x"]
[null,null,0,58,0,{"$f":"$B$8+($B$9-$B$8)/$B$12*C16","v":-0.3}]
[null,null,{"$f":"C16+1","v":1},14,{"$f":"E16+D16/$D$30","v":0.5321100917431193},{"$f":"$B$8+($B$9-$B$8)/$B$12*C17","v":-0.25}]
[null,null,{"$f":"C17+1","v":2},7,{"$f":"E17+D17/$D$30","v":0.66055045871559637},-0.2]
[null,null,3,7,0.72477064220183496,-0.15]
[null,null,4,7,0.78899082568807355,-0.1]
[null,null,5,4,0.85321100917431214,-5.0000000000000017E-2]
[null,null,6,4,0.88990825688073416,0]
[null,null,7,2,0.92660550458715618,4.9999999999999989E-2]
[null,null,8,1,0.94495412844036719,9.9999999999999978E-2]
[null,null,9,2,0.95412844036697275,0.14999999999999997]
[null,null,10,1,0.97247706422018376,0.19999999999999996]
[null,null,11,1,0.98165137614678932,0.24999999999999994]
[null,null,12,1,0.99082568807339477,0.3]
[]
[null,null,"Sum",{"$f":"SUM(D16:D28)","v":109},"sum used for CDF normalizing"]

{"sheet":"voff sim","index":3,"n_rows":106,"n_cols":14,"rows_kept":106,"cut":false,"hidden":false,"merged":[]}
["LTSPICE Simulation - use .meas to get vo for 101 runs"]
[]
[]
["copy data from LTSPICE *.log file"]
["  step","v(vo)","at"]
[1,-2.9987899999999998E-7,1E-4]
[2,-2.3708E-7,1E-4,null,null,null,null,null,null,"Bin","Frequency",null,"Histogram Bins"]
[3,-2.8176099999999998E-7,1E-4,null,null,null,null,null,null,{"$f":"N8","v":-2.9999999999999999E-7},{"$f":"FREQUENCY($B$6:$B$106,$J$8:$J$20)","v":0},null,"LL",{"$f":"-0.0000003","v":-2.9999999999999999E-7}]
[4,-8.43821E-8,1E-4,null,null,null,null,null,null,{"$f":"J8+$N$11","v":-2.4999999999999999E-7},54,null,"UL",{"$f":"-N8","v":2.9999999999999999E-7}]
[5,-2.2884E-7,1E-4,null,null,null,null,null,null,{"$f":"J9+$N$11","v":-1.9999999999999999E-7},14,null,"Bins",12]
[6,-2.54726E-7,1E-4,null,null,null,null,null,null,-1.4999999999999999E-7,5,null,"Bin incr",{"$f":"(N9-N8)/(N10)","v":4.9999999999999998E-8}]
[7,-2.6695100000000002E-7,1E-4,null,null,null,null,null,null,-9.9999999999999995E-8,9]
[8,7.4529299999999998E-9,1E-4,null,null,null,null,null,null,-4.9999999999999998E-8,7]
[9,-7.2632600000000004E-8,1E-4,null,null,null,null,null,null,0,3]
[10,-1.3099499999999999E-7,1E-4,null,null,null,null,null,null,4.9999999999999998E-8,3]
[11,-2.8357199999999999E-7,1E-4,null,null,null,null,null,null,9.9999999999999995E-8,0]
[12,-3.8820300000000003E-8,1E-4,null,null,null,null,null,null,1.4999999999999999E-7,1]
[13,-1.5791399999999999E-7,1E-4,null,null,null,null,null,null,1.9999999999999999E-7,1]
[14,-2.5155099999999997E-7,1E-4,null,null,null,null,null,null,2.4999999999999999E-7,0]
[15,-2.71319E-7,1E-4,null,null,null,null,null,null,{"$f":"J19+$N$11","v":2.9999999999999999E-7},4]
[16,-2.9858299999999999E-7,1E-4,null,null,null,null,null,null,null,{"$f":"FREQUENCY($B$6:$B$106,$J$8:$J$20)","v":0}]
[17,-2.91374E-7,1E-4]
[18,-2.6561499999999999E-7,1E-4]
[19,-2.861E-7,1E-4]
[20,-2.8434600000000002E-7,1E-4]
[21,2.9262199999999998E-7,1E-4]
[22,-2.5795099999999998E-7,1E-4]
[23,-2.8876299999999998E-7,1E-4]
[24,-2.9955600000000001E-7,1E-4]
[25,-2.9915599999999998E-7,1E-4]
[26,-2.6434800000000001E-7,1E-4]
[27,-2.49358E-7,1E-4]
[28,-2.34157E-7,1E-4]
[29,-2.22396E-7,1E-4]
[30,-2.20319E-7,1E-4]
[31,-2.8431500000000002E-7,1E-4]
[32,-1.9746E-7,1E-4]
[33,-2.5746999999999999E-7,1E-4]
[34,-2.6677800000000001E-7,1E-4]
[35,-2.9461600000000002E-7,1E-4]
[36,-2.2011899999999999E-7,1E-4]
[37,-1.0477100000000001E-7,1E-4]
[38,-8.9493900000000002E-8,1E-4]
[39,-2.5095200000000001E-7,1E-4]
[40,-2.71511E-7,1E-4]
[41,-1.7533900000000001E-8,1E-4]
[42,-1.4523000000000001E-7,1E-4]
[43,1.6474999999999999E-7,1E-4]
[44,4.4647000000000003E-8,1E-4]
[45,-2.4639999999999998E-7,1E-4]
[46,-2.8656899999999998E-7,1E-4]
[47,-2.5640500000000003E-7,1E-4]
[48,-2.7779600000000001E-7,1E-4]
[49,-3.4700300000000003E-8,1E-4]
[50,-2.8022400000000001E-7,1E-4]
[51,-1.0738699999999999E-7,1E-4]
[52,-5.5288099999999997E-8,1E-4]
[53,2.9999700000000001E-7,1E-4]
[54,2.9999700000000001E-7,1E-4]
[55,-2.1865199999999999E-7,1E-4]
[56,-2.6297500000000001E-7,1E-4]
[57,-2.7488300000000001E-7,1E-4]
[58,-2.71952E-7,1E-4]
[59,-5.8212699999999997E-8,1E-4]
[60,-2.9775700000000001E-7,1E-4]
[61,-2.6453800000000001E-7,1E-4]
[62,-2.91259E-7,1E-4]
[63,-1.8566000000000001E-7,1E-4]
[64,-2.94694E-7,1E-4]
[65,-2.99168E-7,1E-4]
[66,3.5987399999999998E-8,1E-4]
[67,-2.7397000000000001E-7,1E-4]
[68,-2.7425200000000001E-7,1E-4]
[69,-2.2772500000000001E-7,1E-4]
[70,-1.7401200000000001E-7,1E-4]
[71,-6.0323599999999996E-8,1E-4]
[72,-1.45361E-7,1E-4]
[73,-2.5424799999999999E-7,1E-4]
[74,-2.8062399999999999E-7,1E-4]
[75,-1.3304400000000001E-7,1E-4]
[76,-2.5580299999999998E-7,1E-4]
[77,-2.5679400000000002E-7,1E-4]
[78,1.45779E-7,1E-4]
[79,-1.32543E-7,1E-4]
[80,-2.8978199999999999E-7,1E-4]
[81,-2.23441E-7,1E-4]
[82,-2.6365400000000001E-7,1E-4]
[83,-1.3927900000000001E-7,1E-4]
[84,-2.1962600000000001E-7,1E-4]
[85,-2.3368799999999999E-7,1E-4]
[86,-2.65909E-7,1E-4]
[87,-2.8570000000000002E-7,1E-4]
[88,-2.7876100000000002E-7,1E-4]
[89,-2.5988900000000001E-7,1E-4]
[90,-8.9264999999999999E-8,1E-4]
[91,-2.5121399999999999E-7,1E-4]
[92,2.9994700000000001E-7,1E-4]
[93,-1.2746400000000001E-7,1E-4]
[94,-2.67397E-7,1E-4]
[95,-2.8405600000000001E-7,1E-4]
[96,-2.01034E-7,1E-4]
[97,-2.5359199999999999E-7,1E-4]
[98,-2.9400299999999999E-7,1E-4]
[99,-1.6686600000000001E-7,1E-4]
[100,-2.5237399999999998E-7,1E-4]
[101,-2.8608199999999998E-7,1E-4]