{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Fourier Series","Waveform Coeff"],"not_rendered":{"charts":1,"images":0,"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":"Fourier Series","index":0,"n_rows":128,"n_cols":13,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
[null,"Fourier Series - Creating Waveforms"]
[null,"Electronic Design with Excel"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Entered values"]
[null,null,null,null,null,null,null,null,null,null,"Calculated values"]
[]
[]
["dT",1E-4,"Sampling period"]
[]
["fo",100,"fundamental freq"]
["ntot",10,"Use ntot terms in the waveform calculation."]
[]
["Terms","an","bn"]
[0,0,"na",null,"DC Term (a0)"]
[1,0,1,null,"1st fundamental freq"]
[2,0,0,null,"2nd harmonic"]
[3,0,0,null,"3rd"]
[4,0,0,null,",,,"]
[5,0,0]
[6,0,0]
[7,0,0]
[8,0,0]
[9,0,0]
[10,0,0,null,null,"Fourier Series"]
[null,null,null,null,null,"Vo = a0 + sum( an*cos(2*pi*fo*n*t) ) + sum( bn*sin(2*pi*fo*n*t) )",null,null,null,null,null,null,"sum for n=1 to ntot"]
[]
["t","Vo"]
[0,{"$f":"FourSeries(A29,$B$12,$B$15:$C$25,$B$11)","v":0}]
[{"$f":"A29+$B$9","v":1E-4},{"$f":"FourSeries(A30,$B$12,$B$15:$C$25,$B$11)","v":6.2788670114023615E-2}]
[2.0000000000000001E-4,0.12532955664390097]
[{"$f":"A31+$B$9","v":3.0000000000000003E-4},0.18737585383642991]
[4.0000000000000002E-4,0.24868270774147178]
[5.0000000000000001E-4,0.30900818248165041]
[6.0000000000000006E-4,0.36811421500642982]
[7.000000000000001E-4,0.42576755456281484]
[8.0000000000000015E-4,0.48174068317523239]
[9.0000000000000019E-4,0.53581271350209203]
[1.0000000000000002E-3,0.58777026052580861]
[1.1000000000000003E-3,0.63740828363632274]
[1.2000000000000003E-3,0.68453089578500093]
[1.3000000000000004E-3,0.72895213651573987]
[1.4000000000000004E-3,0.77049670582265462]
[1.5000000000000005E-3,0.80900065593832193]
[1.6000000000000005E-3,0.84431203832256518]
[1.7000000000000006E-3,0.87629150329856487]
[1.8000000000000006E-3,0.90481284996994182]
[1.9000000000000006E-3,0.92976352424867237]
[2.0000000000000005E-3,0.95104506302846004]
[2.1000000000000003E-3,0.96857348275071975]
[2.2000000000000001E-3,0.98227961082977144]
[2.3E-3,0.9921093586293368]
[2.3999999999999998E-3,0.99802393491308905]
[2.4999999999999996E-3,0.99999999892691405]
[2.5999999999999994E-3,0.99802975250877135]
[2.6999999999999993E-3,0.99212097086266282]
[2.7999999999999991E-3,0.98229697187526377]
[2.8999999999999989E-3,0.96859652409630337]
[2.9999999999999988E-3,0.95107369374583228]
[3.0999999999999986E-3,0.92979763135213456]
[3.1999999999999984E-3,0.90485229886227569]
[{"$f":"A61+$B$9","v":3.2999999999999982E-3},0.87633613830219481]
[3.3999999999999981E-3,0.84436168329391059]
[3.4999999999999979E-3,0.80905511496291427]
[3.5999999999999977E-3,0.77055576398827685]
[3.6999999999999976E-3,0.72901556076053664]
[3.7999999999999974E-3,0.68459843581721314]
[3.8999999999999972E-3,0.63747967292201635]
[3.9999999999999975E-3,0.5878452173407005]
[4.0999999999999977E-3,0.53589094204332111]
[4.199999999999998E-3,0.48182187472869004]
[4.2999999999999983E-3,0.42585138872142619]
[4.3999999999999985E-3,0.36820036093458014]
[4.4999999999999988E-3,0.30909630022076395]
[4.5999999999999991E-3,0.2487724495515955]
[4.6999999999999993E-3,0.18746686556852149]
[4.7999999999999996E-3,0.12542147913741269]
[4.8999999999999998E-3,6.2881140614259562E-2]
[5.0000000000000001E-3,9.2653589660046155E-5]
[5.1000000000000004E-3,-6.2696199074766853E-2]
[5.2000000000000006E-3,-0.12523763307447522]
[5.3000000000000009E-3,-0.18728484049577604]
[5.4000000000000012E-3,-0.24859296379648632]
[5.5000000000000014E-3,-0.30892006208979961]
[5.6000000000000017E-3,-0.36802806591813603]
[5.7000000000000019E-3,-0.42568371674912392]
[5.8000000000000022E-3,-0.4816594874861837]
[5.9000000000000025E-3,-0.5357344803610804]
[6.0000000000000027E-3,-0.58769529866509518]
[6.100000000000003E-3,-0.63733688887868034]
[6.2000000000000033E-3,-0.68446334987630719]
[6.3000000000000035E-3,-0.72888870601311873]
[6.4000000000000038E-3,-0.77043764104256063]
[{"$f":"A93+$B$9","v":6.500000000000004E-3},{"$f":"FourSeries(A94,$B$12,$B$15:$C$25,$B$11)","v":-0.8089461899687137}]
[6.6000000000000043E-3,-0.84426238610306648]
[6.7000000000000046E-3,-0.87624686077224756]
[6.8000000000000048E-3,-0.90477339331007356]
[6.9000000000000051E-3,-0.92972940916348212]
[7.0000000000000053E-3,-0.9510164241466641]
[7.1000000000000056E-3,-0.96855043309023625]
[7.2000000000000059E-3,-0.98226224135171614]
[7.3000000000000061E-3,-0.99209773787906219]
[7.4000000000000064E-3,-0.99801810874968322]
[7.5000000000000067E-3,-0.99999999034222631]
[7.6000000000000069E-3,-0.99803556153667972]
[7.7000000000000072E-3,-0.99213257457893955]
[7.8000000000000074E-3,-0.98231432448804235]
[7.9000000000000077E-3,-0.96861955712678682]
[8.0000000000000071E-3,-0.95110231629853204]
[8.1000000000000065E-3,-0.92983173047357226]
[8.2000000000000059E-3,-0.90489173998673278]
[8.3000000000000053E-3,-0.87638076578274993]
[8.4000000000000047E-3,-0.84441132101667216]
[8.5000000000000041E-3,-0.80910956704201831]
[8.6000000000000035E-3,-0.77061481553891542]
[8.7000000000000029E-3,-0.7290789787469597]
[8.8000000000000023E-3,-0.68466596997235851]
[8.9000000000000017E-3,-0.63755105673514278]
[9.0000000000000011E-3,-0.58792016910912193]
[9.1000000000000004E-3,-0.53596916598409128]
[9.1999999999999998E-3,-0.48190306214585493]
[9.2999999999999992E-3,-0.42593521922423527]
[9.3999999999999986E-3,-0.36828650370184407]
[9.499999999999998E-3,-0.3091844153063818]
[9.5999999999999974E-3,-0.24886218922608569]
[9.6999999999999968E-3,-0.18755787569126967]
[9.7999999999999962E-3,-0.12551340055422119]
[9.8999999999999956E-3,-6.2973610574683273E-2]

{"sheet":"Waveform Coeff","index":1,"n_rows":36,"n_cols":14,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Waveform Coefficients for various waveforms"]
[]
[]
[]
[null,null,null,"Sine Wave",null,null,"Cosine",null,null,"Inverted Sine",null,null,"Cosine w/ -45 deg shift    "]
[]
["Terms",null,null,"an","bn",null,"an","bn",null,"an","bn",null,"an","bn"]
[0,"DC Term",null,0,"na",null,0,"na",null,0,"na",null,0,"na"]
[1,"1st fundamental freq",null,0,1,null,1,0,null,0,-1,null,0.70699999999999996,0.70699999999999996]
[2,"2nd harmonic",null,0,0,null,0,0,null,0,0,null,0,0]
[3,"3rd harmonic",null,0,0,null,0,0,null,0,0,null,0,0]
[4,"…",null,0,0,null,0,0,null,0,0,null,0,0]
[5,null,null,0,0,null,0,0,null,0,0,null,0,0]
[6,null,null,0,0,null,0,0,null,0,0,null,0,0]
[7,null,null,0,0,null,0,0,null,0,0,null,0,0]
[8,null,null,0,0,null,0,0,null,0,0,null,0,0]
[9,null,null,0,0,null,0,0,null,0,0,null,0,0]
[10,null,null,0,0,null,0,0,null,0,0,null,0,0]
[]
[]
[]
[]
[null,null,null,"Square Wave",null,null,"Sawtooth Wave 1",null,null,"Sawtooth Wave 2"]
[]
["Terms",null,null,"an","bn",null,"an","bn",null,"an","bn"]
[0,"DC Term",null,0,"na",null,0,"na",null,0,"na"]
[1,"1st fundamental freq",null,0,1.273277096928219,null,0,1,null,0,0.63661977236758138]
[2,"2nd harmonic",null,0,0,null,0,0.5,null,0,-0.31830988618379069]
[3,"3rd harmonic",null,0,0.42442569897607302,null,0,0.33333333333333331,null,0,0.21220659078919379]
[4,"…",null,0,0,null,0,0.25,null,0,-0.15915494309189535]
[5,null,null,0,0.25465541938564379,null,0,0.2,null,0,0.12732395447351627]
[6,null,null,0,0,null,0,0.16666666666666666,null,0,-0.1061032953945969]
[7,null,null,0,0.18189672813260271,null,0,0.14285714285714285,null,0,9.0945681766797334E-2]
[8,null,null,0,0,null,0,0.125,null,0,-7.9577471545947673E-2]
[9,null,null,0,0.14147523299202433,null,0,0.1111111111111111,null,0,7.0735530263064603E-2]
[10,"10th harmonic",null,0,0,null,0,0.1,null,0,-6.3661977236758135E-2]