{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["LM(2)5118 Calculator","Bill of Materials","Bode Plots","Worksheet","Graph"],"not_rendered":{"charts":12,"images":1,"macros":0,"external_links":0,"defined_names":95,"comments":1,"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":"LM(2)5118 Calculator","index":0,"n_rows":113,"n_cols":7,"rows_kept":113,"cut":false,"hidden":false,"merged":[]}
["LM(2)5118 Quick Start Component Calculator",null,null,null,"Version 2.01"]
["Revision date:  April 2014"]
[]
[]
[]
[" Step 1 - Application Requirements"]
[null,null,"Vout (V)",null,28]
[" Enter design requirements in the shaded cells",null,"Vin(min) (V)",null,9]
[null,null,"Vin(max) (V)",null,40]
[null,null,"Maximum Average Load Current Iout (A)",null,1.5]
[null,null,"Ripple Current as % of Maximum Load Current (%)",null,0.4]
[null,null,"Effciency of Converter (%)",null,0.85]
[null,null,"VCCX Voltage (V)",null,0]
[null,null,"Vin at start of  Transition to Buck-Boost Mode (V)",null,{"$f":"1.33*Vout","v":37.24}]
[null,null,"Buck-Boost Mode Operation",null,{"$f":"IF(Vinmin<1.4*Vout,\"YES\",\"NO\")","v":"YES"}]
[]
[null,null,"Recommended Controller IC",null,{"$f":"IF(E15 = \"NO\", \"LM5116\", \"LM5118\")","v":"LM5118"}]
[]
["Step 2 - Switching Frequency"]
[null,null,"Maximum Possible Switching Frequency (kHz)",null,{"$f":"IF(Fmax<610,Fmax,500)","v":608.10810810810801}]
[{"$f":"IF(E21>=E20,\"Violation of Minimum On-Time or Max Frequency\",\"\")","v":""},null,"Switching Frequency (kHz)",null,420]
[{"$f":"IF(E21>=E20,\"Reduce Switching Frequency\",\"\")","v":""},null,"Timing Resistor, Rt (kW)",null,{"$f":"6.4*10^3/Fsw-3.02","v":12.218095238095238}]
[{"$f":"IF(Dviolate<DMaximumAll,\"Check Switching Frequency or Decrease Vin\",\"\")","v":""}]
["Step 3 - Inductor Value"]
[null,null,"Calculated Buck Mode Inductor Value, Lb (µH)",null,{"$f":"IF(Vinmax>E14,((Vout*(Vinmax-Vout))/(Vinmax*Fsw*(Ripple*Iout)))*1000,\"NA\")","v":33.333333333333329}]
[null,null,"Calculated Buck-Boost Mode Inductor Value, Lb-b (µH)",null,{"$f":"IF(BuckBoostMode=\"YES\",(((Vinmin)*Vout)/((Vinmin+Vout)*Fsw*Ripple*Iout))*1000,\"NA\")","v":27.027027027027028}]
[null,null,"Actual Chosen Inductor Value, L (µH)",null,33]
[null,null,"Inductor Tolerance (%)",null,0.1]
[]
["Step 4 - Calculate Output and Inductor Currents Based on Chosen Inductor"]
[null,null,"Buck mode Ripple Current at Vin(max), ΔI (A)",null,{"$f":"IF(Vinmax>E14,((Vout*(Vinmax-Vout))/(Vinmax*L*Fsw))*1000,\"NA\")","v":0.60606060606060608}]
[null,null,"Buck-Boost Ripple Current at Vin(min), ΔI (A)",null,{"$f":"(Vout*Vinmin)/(Fsw*L*(Vout+Vinmin))*1000","v":0.49140049140049141}]
[null,null,"Buck-Boost Ripple Current at Vin=Vout, ΔI (A) ",null,{"$f":"IF(Vinmax>=Vout,(Vout*Vout)/((Vout+Vout)*Fsw*L)*1000,\"NA\")","v":1.0101010101010102}]
[null,null,"Buck mode Ripple Current at Vin(max), Including inductor tolerance, ΔI (A)",null,{"$f":"IrippleBuck/(1-L_tol)","v":0.67340067340067344}]
[null,null,"Buck-Boost Ripple Current at Vin(min), Including inductor tolerance, ΔI (A)",null,{"$f":"IrippleBB/(1-L_tol)","v":0.54600054600054604}]
[null,null,"Buck Average Inductor Current at Vin(max), Including Effciency (A)",null,{"$f":"Iout/Eff","v":1.7647058823529411}]
[null,null,"Buck-Boost Average Inductor Current at Vin(min), Including Effciency (A)",null,{"$f":"((Vout+Vinmin)/Vinmin)*(Iout/Eff)","v":7.2549019607843128}]
[null,null,"Buck-Mode Peak Inductor Current, Ip(b) (A)",null,{"$f":"IF(Vinmax>E14,ILavgBuck+E34/2,\"NA\")","v":2.1014062190532776}]
[null,null,"Buck-Boost Mode Peak Inductor Current, Ip(b-b) (A)",null,{"$f":"IF(BuckBoostMode=\"YES\",ILavgBB+E35/2,\"NA\")","v":7.5279022337845856}," "]
[]
["Step 5 - Sense Resistor"]
[null,null,"Current Limit Margin (% beyond Max Load) (%)",null,0.1]
[null,null,"Buck Mode K Factor (K)",null,{"$f":"1+(10/(Vinmax-Vout))","v":1.8333333333333335}]
[null,null,"Selected Buck Mode K Factor (K)",null,2]
[null,null,"Buck-Boost Mode K Factor (K)",null,{"$f":"1+(10/Vinmin)","v":2.1111111111111112}]
[null,null,"Selected Buck-Boost Mode K Factor (K)",null,2.2000000000000002]
[null,null,"Current Sense Resistor, Rs (mW)",null,{"$f":"IF((2.5*(1-E42))/(10*(ILavgBB+(IrippleBB*KBB)/2))*1000<(1.25*(1-E42))/(10*(ILavgBuck+(IrippleBuck*KBuck)/2))*1000,(2.5*(1-E42))/(10*(ILavgBB+(IrippleBB*KBB)/2))*1000,(1.25*(1-E42))/(10*(ILavgBuck+(IrippleBuck*KBuck)/2))*1000)","v":28.863018354860642}," "]
[null,null,"Closest Standard Value, Rs (mW)",null,10]
[]
["Step 6 - Ramp Capacitor"]
[null,null,"Cramp (pF)",null,{"$f":"(L*5*10^-6)/(10*Rs)*10^9","v":1650}]
[null,null,"Closest Smaller Standard Value, Cramp (pF)",null,330]
[null,null,"Rramp (kW)",null,{"$f":"IF(Vout>20,7/(Vout*5*10^-6-50*10^-6)*10^-3,\"NA\")","v":77.777777777777786}]
[]
["Step 7 - Current Limits"]
[null,null,"Buck Mode Peak Inductor Current Limit (A)",null,{"$f":"IF(ILPeakLimitBuck<IpeakBuck,\"Error\",ILPeakLimitBuck)","v":9.974747474747474}]
[null,null,"Buck-Boost Mode Peak Inductor Current Limit (A)",null,{"$f":"IF(ILPeakLimitBB<IpeakBB,\"Error\",ILPeakLimitBB)","v":22.269997269997273}]
[]
["Step 9 - Output Capacitors (Based on Worst Case Conditions for Each Mode)"]
[null,null,"Target output ripple (mV)",null,50]
[null,null,"Buck-Boost Duty cycle at Vin(min) (%)",null,{"$f":"Vout/(Vinmin+Vout)","v":0.7567567567567568}]
[null,null,"Buck-Boost RMS Ripple Current in Output Cap (A)",null,{"$f":"SQRT(-(DBB*Iout^2)/(DBB-1))","v":2.6457513110645907}]
[null,null,"Minimum COUT output Capacitor Value (µF)",null,{"$f":"Iout*Vout/(Vinmin+Vout)/(Fsw*DeltaVout)*1000000","v":54.054054054054056}]
[null,null,"Required COUT ESR (mW)",null,{"$f":"DeltaVout/(Iout/(1-E61)+IrippleBB/2)","v":7.7974327862571036}]
[null,null,"Chosen COUT output capacitor value (µF)",null,112]
[null,null,"Actual COUT ESR (mW)",null,10]
[null,null,"Buck Mode Output Ripple Voltage (mV)",null,{"$f":"IF(Vinmax<BuckMode,\"NA\",Coutesr*((Iout/(1-E61)+(IrippleBB/2))))","v":64.123669123669131}]
[]
["Step 10 - Input Capacitors (Based on Worst Case Conditions for Each Mode)"]
[null,null,"Buck-Boost RMS Input Ripple Current (A)",null,{"$f":"(Iout/(1-DBB))*SQRT(DBB*(1-DBB))","v":2.6457513110645907}]
[null,null,"Buck-Boost Mode Peak to Peak Current Ripple in Input Cap (A)",null,{"$f":"IpeakBB","v":7.5279022337845856}]
[null,null,"Buck Mode RMS input Ripple Current (A)",null,{"$f":"IF(Vinmax<BuckMode,\"NA\",Iout*0.5)","v":0.75}]
[null,null,"Buck Mode Peak to Peak Current Ripple in Input Cap (A)",null,{"$f":"IpeakBuck","v":2.1014062190532776}]
[null,null,"Initial Input Capacitor Value(μF)",null,{"$f":"E39/2/Fsw*1000","v":8.9617883735530768}]
[null,null,"Chosen CIN Input Capacitor Value (µF)",null,100]
[]
["Step 11 - Feedback Resistors"]
[null,null,"Rfb2 (W)",null,26100]
[null,null,"Rfb1 (W)",null,{"$f":"_Rfb2/((Vout/1.23)-1)","v":1199.2155397833394}]
[]
["Step 12 - Chb & Cvcc Capacitor"]
[null,null,"High-side MOSFET Qg at VGS=10V (nC)",null,30]
[null,null,"Minimum Bootstrap Capacitor Chb (µF)",null,{"$f":"E82*10^-3/(0.05*7)","v":8.5714285714285701E-2}]
[null,null,"Chosen Value for Chb (µF)",null,0.1]
[null,null,"Minimum VCC Bypass Capacitor Cvcc (µF)",null,{"$f":"10*E84","v":1}]
[]
["Step 13 - Error Amplifier Compensation"]
[null,null,"Right Half Plane Zero Frequency (kHz)",null,{"$f":"((Rout*(1-DBB)^2)/(2*PI()*L*DBB*10^-6))/1000","v":7.0387935519757132}]
[null,null,"Capacitor ESR Zero Frequency (kHz)",null,{"$f":"1/(Cout*Coutesr*2*PI()*10^-6)","v":142.10262776062083}]
[null,null,"Capacitor Pole Frequency (kHz)",null,{"$f":"(1+DBB)/(2*PI()*Cout*Rout*10^-3)","v":0.1337355811453719}]
[null,null,"Bandwidth (kHz)",null,{"$f":"fmodRzero/4","v":1.7596983879939283}]
[null,null,"Selected Bandwith (kHz)",null,1.95]
[null,null,"Target Compensation Zero (kHz)",null,{"$f":"fcutoff/10","v":0.19500000000000001}]
[null,null,"Target Compensation Pole (kHz)",null,{"$f":"fmodRzero","v":7.0387935519757132}]
[null,null,"Cpole (nF)",null,{"$f":"fcompZero/(fcompPole*_Rfb2*CompGain)*10^9","v":1.5406092876330786}]
[null,null,"Select Nearest Standard Cpole Value (nF)",null,2.2000000000000002]
[null,null,"Czero (nF)",null,{"$f":"((1/(CompGain*_Rfb2))-E95*10^-9)*10^9","v":54.069804660600823},null," "]
[null,null,"Select Nearest Standard Czero Value (nF)",null,100]
[null,null,"Rcomp (W)",null,{"$f":"1/(fcompZero*2*3.14*E97*10^-9)","v":15102.573024017229}]
[null,null,"Select nearest Standard Rcomp Value (W)",null,10000]
[]
["Step 14 - Soft Start capacitor"]
[null,null,"Choose soft-start time (ms)",null,123]
[null,null,"Soft Start Capacitor Value (nF)",null,{"$f":"(E103*10^(-5))/1.23*10^6","v":1000.0000000000002}]
[]
["Step 15 - UVLO Threshold and Hiccup Mode Restart"]
[null,null,"Minimum Value of Resistor Ruv1  (kW)",null,{"$f":"Vinmax","v":40}]
[null,null,"Chosen Value of  Ruv1 (kW)",null,48.7]
[null,null,"Desired Undervoltage Threshold (V)",null,9]
[null,null,"Ruv2 Value (kW)",null,{"$f":"1.23*E108/(E109+5*E108*10^(-3)-1.23)","v":7.4750109190740641}]
[null,null,"Choose off-time of hiccup duty cycle (µs)",null,2400]
[null,null,"Vin voltage for desired hiccup mode off-time  (V)  ",null,12]
[null,null,"Hiccup Mode Off-time Capacitor Value Cr (nF)",null,{"$f":"-(E111*(E110+E108))/(E110*E108*LN(1-((0.98*(E110+E108))/(E110*E112))))","v":389.34556659320918}]

{"sheet":"Bill of Materials","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[null,"LM5118 List of Components"]
[]
[null,"Component","Description","Value","Minimum Rating"]
[null,"L","Inductor",{"$f":"L","v":33},{"$f":"ILPeakLimitBB","v":22.269997269997273}]
[null,"Cin ","Input capacitor",{"$f":"Cin","v":100},{"$f":"Vinmax","v":40}]
[null,"Cramp","Ramp capacitor",{"$f":"Cramp","v":330},16]
[null,"Css","Soft start capacitor",{"$f":"Css","v":1000.0000000000002},6]
[null,"Cout","Output capacitor",{"$f":"Cout","v":112},{"$f":"Vout","v":28}]
[null,"Cr","UVLO filter capacitor",{"$f":"Cr","v":389.34556659320918},16]
[null,"Cpole","Compensation capacitor",{"$f":"Cpole","v":2.2000000000000002},6]
[null,"Czero","Compensation capacitor",{"$f":"Czero","v":100},6]
[null,"Cvcc","VCC bypass capacitor",{"$f":"Cvcc","v":1},12]
[null,"Chb","HB-SW bypass capacitor",{"$f":"Chb","v":0.1},{"$f":"MAX(Vccx,VCC)","v":7}]
[null,"Rfb1","Feedback resistor",{"$f":"_Rfb1","v":1199.2155397833394},"1/16 W"]
[null,"Rfb2","Feedback resistor",{"$f":"_Rfb2","v":26100},"1/16 W"]
[null,"Ruv1","UVLO divider resistor",{"$f":"_Ruv1","v":48.7},{"$f":"IF(AND(Vinmax^2/(_Ruv2*1000)<0.05,Vinmax<=50),\"1/16W\",\"1/8W\")","v":"1/8W"}]
[null,"Ruv2","UVLO divider resistor",{"$f":"_Ruv2","v":7.4750109190740641},"1/16 W"]
[null,"Rs","Sense resistor",{"$f":"Rs","v":10},{"$f":"IF(PRS_BB>PRS_B,PRS_BB,PRS_B)","v":0.52633602460592066}]
[null,"Rt","Oscillator timing resistor",{"$f":"Rt","v":12.218095238095238},"1/16 W"]
[null,"Rramp","Optional ramp resistor",{"$f":"Rramp","v":77.777777777777786},{"$f":"IF(D20=\"NA\",\"-\",\"1/16 W\")","v":"1/16 W"}]
[null,"Rcomp","Compensation resistor",{"$f":"Rcomp/1000","v":10},"1/16 W"]

{"sheet":"Bode Plots","index":2,"n_rows":24,"n_cols":24,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Buck-Boost Mode",null,null,null,null,null,null,null,null,null,null,null,"Buck Mode "]
[null,"Frequency (Hz)","Frequency (rad/sec)","Modulator\nGain\n(dB)","Modulator\nPhase\n(deg)","Error Amplifier Gain\n(dB)","Error Amplifier Phase (deg)","Overall Loop\nGain\n(dB)","Loop\nPhase\n(deg)",null,null,null,null,"Frequency (Hz)","Frequency (rad/sec)","Modulator\nGain\n(dB)","Modulator\nPhase\n(deg)","Error Amplifier Gain\n(dB)","Error Amplifier Phase (deg)","Overall Loop\nGain\n(dB)","Loop\nPhase\n(deg)"]
[null,0.1,{"$f":"2*PI()*B3","v":0.62831853071795862},{"$f":"20*LOG(AmBB*IMABS(IMDIV(IMPRODUCT(COMPLEX(1,-C3/wrBB),COMPLEX(1,C3/wzBB)),COMPLEX(1,C3/wpBB))))","v":28.247916074306477},{"$f":"IMARGUMENT(IMDIV(IMPRODUCT(COMPLEX(1,-C3/wrBB),COMPLEX(1,C3/wzBB)),COMPLEX(1,C3/wpBB)))*(180/PI())","v":-4.3616256630598177E-2},{"$f":"20*LOG(Afb*IMABS(IMDIV(IMDIV(COMPLEX(1,C3/wzea),COMPLEX(1,C3/wpea)),COMPLEX(0,C3))))","v":55.514576283829228},{"$f":"IMARGUMENT(IMDIV(IMDIV(COMPLEX(-1,-C3/wzea),COMPLEX(1,C3/wpea)),COMPLEX(0,C3)))*(180/PI())","v":90.035225044186305},{"$f":"D3+F3","v":83.762492358135702},{"$f":"E3+G3","v":89.991608787555705},null,"Modulator - Buck-Boost",null,null,0.1,{"$f":"2*PI()*N3","v":0.62831853071795862},{"$f":"20*LOG(Amb*IMABS(IMDIV(COMPLEX(1,O3/wzb),COMPLEX(1,O3/wpb))))","v":45.42132795174026},{"$f":"IMARGUMENT(IMDIV(COMPLEX(1,O3/wzb),COMPLEX(1,O3/wpb)))*(180/PI())","v":-7.5223636709268765E-2},{"$f":"20*LOG(Afb*IMABS(IMDIV(IMDIV(COMPLEX(1,O3/wzea),COMPLEX(1,O3/wpea)),COMPLEX(0,O3))))","v":55.514576283829228},{"$f":"IMARGUMENT(IMDIV(IMDIV(COMPLEX(-1,-O3/wzea),COMPLEX(1,O3/wpea)),COMPLEX(0,O3)))*(180/PI())","v":90.035225044186305},{"$f":"P3+R3","v":100.9359042355695},{"$f":"Q3+S3","v":89.960001407477037},null,"Modulator - Buck"]
[null,0.2,{"$f":"2*PI()*B4","v":1.2566370614359172},28.24790879225354,-8.7232465352542338E-2,49.493981511738781,90.070450059948485,77.741890303992321,89.983217594595942,null,"rad/sec","Hz",null,0.2,{"$f":"2*PI()*N4","v":1.2566370614359172},45.421305469846317,-0.15044701367522878,49.493981511738781,90.070450059948485,{"$f":"P4+R4","v":94.915286981585098},{"$f":"Q4+S4","v":89.920003046273251},null,"rad/sec","Hz"]
[null,0.5,{"$f":"2*PI()*B5","v":3.1415926535897931},28.247857818225263,-0.21808032498665955,41.53521732645136,90.176124652451534,69.783075144676616,89.958044327464876,"wp",{"$f":"(1+DBB)/(Cout*10^-6*Rout)","v":840.28543849972414},{"$f":"K5/(2*PI())","v":133.73558114537192},null,0.5,{"$f":"2*PI()*N5","v":3.1415926535897931},45.421148099847379,-0.3761129887930989,41.53521732645136,90.176124652451534,86.956365426298731,89.800011663658438,"wz",{"$f":"1/(Cout*10^-6*Coutesr*10^-3)","v":892857.14285714296},{"$f":"W5/(2*PI())","v":142102.62776062085}]
[null,1,{"$f":"2*PI()*B6","v":6.2831853071795862},28.247675773011743,-0.43615466163262878,35.514745939854265,90.352245751986132,63.762421712866008,89.916091090353504,"wr",{"$f":"(Rout*(1-DBB)^2)/(L*10^-6*DBB)","v":44226.044226044221},{"$f":"K6/(2*PI())","v":7038.7935519757148},null,1,{"$f":"2*PI()*N6","v":6.2831853071795862},45.420586110682713,-0.75219351370580745,35.514745939854265,90.352245751986132,80.935332050536971,89.600052238280327,"wp",{"$f":"1/(Cout*10^-6*Rout)","v":478.31632653061217},{"$f":"W6/(2*PI())","v":76.126407728904013}]
[null,2,{"$f":"2*PI()*B7","v":12.566370614359172},28.246947668511982,-0.87226142256545236,29.494660095236224,90.704463083161201,57.741607763748206,89.832201660595743,"wz",{"$f":"1/(Cout*10^-6*Coutesr*10^-3)","v":892857.14285714296},{"$f":"K7/(2*PI())","v":142102.62776062085},null,2,{"$f":"2*PI()*N7","v":12.566370614359172},45.418338880971937,-1.5041274171492081,29.494660095236224,90.704463083161201,74.912998976208158,89.200335666011995,null,"Gain","dB"]
[null,5,31.415926535897931,28.241854354536969,-2.1798159683818605,21.539456698066214,91.760660626252573,49.781311052603186,89.580844657870713,null,"Gain","dB",null,5,31.415926535897931,45.402640747842327,-3.7557866164072289,21.539456698066214,91.760660626252573,66.942097445908544,88.004874009845338,"Am",{"$f":"Rout/Ri","v":186.66666666666666},{"$f":"20*LOG(Amb)","v":45.421335445730762}]
[null,10,62.831853071795862,28.223712589864508,-4.3536683525619519,15.531678129564977,93.517778719491972,43.755390719429485,89.164110366930018,"Am",{"$f":"(Rout/Ri)*((1-DBB)/(1+DBB))","v":25.84615384615384},{"$f":"20*LOG(K9)","v":28.247918501660145},null,10,62.831853071795862,45.347034699202673,-7.4795199773499981,15.531678129564977,93.517778719491972,60.878712828767647,86.038258742141977]
[null,20,125.66370614359172,28.151894541039233,-8.6602183227569025,9.5619880528690651,97.007465969507493,37.713882593908295,88.347247646750589,null,null,null,null,20,125.66370614359172,45.131467954511216,-14.712081154231834,9.5619880528690651,97.007465969507493,54.693456007380277,82.295384815275654]
[null,50,314.15926535897933,27.679926588523081,-20.886199832966646,1.9437514736768915,107.05312485918087,29.623678062199971,86.166925026214216,null,"Error Amp",null,null,50,314.15926535897933,43.86375842020604,-33.276841267777002,1.9437514736768915,107.05312485918087,45.80750989388293,73.776283591403867,null,"Error Amp"]
[null,100,628.31853071795865,26.31999800235025,-37.560713272381911,-3.0411497295394474,121.3670038097673,23.278848272810801,83.806290537385394,null,"rad/sec","Hz",null,100,628.31853071795865,41.066784800816393,-52.678964813026788,-3.0411497295394474,121.3670038097673,38.025635071276945,68.688038996740516,null,"rad/sec","Hz"]
[null,200,1256.6370614359173,23.150695558505866,-57.777150224113853,-6.3944585147584316,139.93858847495662,16.756237043747433,82.161438250842764,"wpea",{"$f":"(Czero*10^-9+Cpole*10^-9)/(Cpole*10^-9*Czero*10^-9*Rcomp)","v":46454.545454545456},{"$f":"wpea/(2*PI())","v":7393.4705381780477},null,200,1256.6370614359173,36.443848341202703,-69.080931899063458,-6.3944585147584316,139.93858847495662,30.049389826444269,70.857656575893159,"wpea",{"$f":"(Czero*10^-9+Cpole*10^-9)/(Cpole*10^-9*Czero*10^-9*Rcomp)","v":46454.545454545456},{"$f":"wpea/(2*PI())","v":7393.4705381780477}]
[null,500,3141.5926535897929,16.51528356576593,-78.887133241255654,-8.1225050655050435,158.47434830213771,8.3927785002608868,79.587215060882059,"wzea",{"$f":"1/(Czero*10^-9*Rcomp)","v":1000},{"$f":"wzea/(2*PI())","v":159.15494309189535},null,500,3141.5926535897929,28.97317153129358,-81.141440635147902,-8.1225050655050435,158.47434830213771,20.850666465788535,77.332907666989811,"wzea",{"$f":"1/(Czero*10^-9*Rcomp)","v":1000},{"$f":"wzea/(2*PI())","v":159.15494309189535}]
[null,1000,6283.1853071795858,10.782869279202586,-90.065408306332529,-8.4919210479423928,163.25417207942564,2.2909482312601934,73.188763773093115,null,"Gain","dB",null,1000,6283.1853071795858,23.027161528024209,-85.243481333561093,-8.4919210479423928,163.25417207942564,14.535240480081816,78.010690745864551,null,"Gain","dB"]
[null,2000,12566.370614359172,5.0709362626966232,-101.23005378966202,-8.8011186140997015,160.31338339070555,-3.7301823514030783,59.08332960104353,"Afb",{"$f":"1/(_Rfb2*(Czero*10^-9+Cpole*10^-9))","v":374.89409241889166},{"$f":"20*LOG(K16)","v":51.478171937260498},null,2000,12566.370614359172,17.026014924113056,-87.013844604541632,-8.8011186140997015,160.31338339070555,8.2248963100133547,73.299538786163922,"Afb",{"$f":"1/(_Rfb2*(Czero*10^-9+Cpole*10^-9))","v":374.89409241889166},{"$f":"20*LOG(W16)","v":51.478171937260498}]
[null,5000,31415.926535897932,-1.4300764487189843,-121.84074411572409,-10.153051774473539,144.10743043845861,-11.583128223192524,22.266686322734515,null,null,null,null,5000,31415.926535897932,9.0770089024401983,-87.112554369526507,-10.153051774473539,144.10743043845861,-1.0760428720333408,56.994876068932101]
[null,10000,62831.853071795864,-4.4087216236128048,-140.06750981614465,-13.037636905592453,125.56544630452487,-17.446358529205259,-14.502063511619781,null,null,null,null,10000,62831.853071795864,3.0732444378181567,-85.538472251832786,-13.037636905592453,125.56544630452487,-9.9643924677742959,40.026974052692083]
[null,20000,125663.70614359173,-5.5849856776381488,-152.21650997137124,-17.721486134838813,109.83208315894417,-23.306471812476961,-42.384426812427066,null,null,null,null,20000,125663.70614359173,-2.8834335672195701,-81.770536701517997,-17.721486134838813,109.83208315894417,-20.604919702058382,28.061546457426175]
[null,50000,314159.26535897929,-5.5850046956784061,-152.44869698532966,-25.218153998738899,98.228963390126466,-30.803158694417306,-54.219733595203195,null,null,null,null,50000,314159.26535897929,-10.420461011594407,-70.52791726297481,-25.218153998738899,98.228963390126466,-35.638615010333304,27.701046127151656]
[null,100000,628318.53071795858,-4.4086075582965849,-140.76239101905702,-31.168525495411593,94.137264067071627,-35.577133053708181,-46.625126951985393,null,null,null,null,100000,628318.53071795858,-15.200917290446608,-54.821689635134597,-31.168525495411593,94.137264067071627,-46.369442785858197,39.31557443193703]
[null,200000,1256637.0614359172,-1.4283036713017438,-123.34034783001977,-37.171389245759272,92.071514713785476,-38.599692917061013,-31.268833116234291,null,null,null,null,200000,1256637.0614359172,-18.225129338510794,-35.372485531136867,-37.171389245759272,92.071514713785476,-55.396518584270069,56.699029182648609]
[null,500000,3141592.653589793,5.0884548936533704,-105.04357035990874,-45.125210273892343,90.828929761323266,-40.036755380238972,-14.214640598585476,null,null,null,null,500000,3141592.653589793,-19.662656732927459,-15.85670493504742,-45.125210273892343,90.828929761323266,-64.787867006819795,74.972224826275848]
[null,1000000,6283185.307179586,10.857890304304309,-97.676782978627784,-51.145098414034173,90.414488032854166,-40.28720810972986,-7.2622949457736183,null,null,null,null,1000000,6283185.307179586,-19.913175964434181,-8.0833702443437883,-51.145098414034173,90.414488032854166,-71.058274378468354,82.331117788510383]

{"sheet":"Worksheet","index":3,"n_rows":89,"n_cols":6,"rows_kept":89,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,"10 is buck","10 is buck-boost"]
[]
[null,{"$f":"IF(Vout>0.7*Vin_nominal,\"Buck-Boost Mode\",\"Buck Mode\")","v":{"$error":"#NAME?"}},null,"Vin","Vout"]
[null,null,null,null,12]
[null,null,null,20,{"$f":"IF(E5<0.7*D6,10,0)","v":10},{"$f":"IF(E5>0.7*D6,10,0)","v":0}]
[null,null,null,19,{"$f":"IF(E5<0.7*D7,10,0)","v":10},{"$f":"IF(E5>0.7*D7,10,0)","v":0}]
[null,null,null,18,{"$f":"IF(E5<0.7*D8,10,0)","v":10},{"$f":"IF(E5>0.7*D8,10,0)","v":0}]
[null,null,null,17,{"$f":"IF(E5<0.7*D9,10,0)","v":0},{"$f":"IF(E5>0.7*D9,10,0)","v":10}]
[null,null,null,16,{"$f":"IF(E5<0.7*D10,10,0)","v":0},{"$f":"IF(E5>0.7*D10,10,0)","v":10}]
[null,null,null,14,{"$f":"IF(E7<0.7*D11,10,0)","v":0},{"$f":"IF(E5>0.7*D11,10,0)","v":10}]
[null,null,null,13,{"$f":"IF(E8<0.7*D12,10,0)","v":0},{"$f":"IF(E5>0.7*D12,10,0)","v":10}]
[null,null,null,12,{"$f":"IF(E5<0.7*D13,10,0)","v":0},{"$f":"IF(E5>0.7*D13,10,0)","v":10}]
[null,null,null,11,{"$f":"IF(E5<0.7*D14,10,0)","v":0},{"$f":"IF(E5>0.7*D14,10,0)","v":10}]
[null,null,null,10,{"$f":"IF(E5<0.7*D15,10,0)","v":0},{"$f":"IF(E5>0.7*D15,10,0)","v":10}]
[]
[null,null,null,null,12]
[null,null,13,75,{"$f":"E17/0.7","v":17.142857142857142},{"$f":"E18","v":17.142857142857142}]
[null,null,13,74,{"$f":"E17/0.7","v":17.142857142857142}]
[null,null,13,73,{"$f":"E17/0.7","v":17.142857142857142}]
[null,null,13,72,{"$f":"E17/0.7","v":17.142857142857142}]
[null,null,13,71,{"$f":"E17/0.7","v":17.142857142857142}]
[null,null,13,70,{"$f":"E17/0.7","v":17.142857142857142}]
[null,null,13,{"$f":"D23-1","v":69},{"$f":"E17/0.7","v":17.142857142857142}]
[null,null,13,68,{"$f":"E17/0.7","v":17.142857142857142}]
[null,null,13,67,{"$f":"E17/0.7","v":17.142857142857142}]
[null,null,13,66,{"$f":"E17/0.7","v":17.142857142857142}]
[null,null,13,65,{"$f":"E17/0.7","v":17.142857142857142}]
[null,null,13,64,17.142857142857142]
[null,null,13,63,17.142857142857142]
[null,null,13,62,17.142857142857142]
[null,null,13,61,17.142857142857142]
[null,null,13,60,17.142857142857142]
[null,null,13,{"$f":"D33-1","v":59},17.142857142857142]
[null,null,13,58,17.142857142857142]
[null,null,13,57,17.142857142857142]
[null,null,13,56,17.142857142857142]
[null,null,13,55,17.142857142857142]
[null,null,13,54,17.142857142857142]
[null,null,13,53,17.142857142857142]
[null,null,13,52,17.142857142857142]
[null,null,13,51,17.142857142857142]
[null,null,13,50,17.142857142857142]
[null,null,13,49,17.142857142857142]
[null,null,13,48,17.142857142857142]
[null,null,13,47,17.142857142857142]
[null,null,13,46,17.142857142857142]
[null,null,13,45,17.142857142857142]
[null,null,13,44,17.142857142857142]
[null,null,13,43,17.142857142857142]
[null,null,13,42,17.142857142857142]
[null,null,13,41,17.142857142857142]
[null,null,13,40,17.142857142857142]
[null,null,13,39,17.142857142857142]
[null,null,13,38,17.142857142857142]
[null,null,13,37,17.142857142857142]
[null,null,13,36,17.142857142857142]
[null,null,13,35,17.142857142857142]
[null,null,13,34,17.142857142857142]
[null,null,13,33,17.142857142857142]
[null,null,13,32,17.142857142857142]
[null,null,13,31,17.142857142857142]
[null,null,13,30,17.142857142857142]
[null,null,13,29,17.142857142857142]
[null,null,13,28,17.142857142857142]
[null,null,13,27,17.142857142857142]
[null,null,13,26,17.142857142857142]
[null,null,13,25,17.142857142857142]
[null,null,13,24,17.142857142857142]
[null,null,13,23,17.142857142857142]
[null,null,13,22,17.142857142857142]
[null,null,13,21,17.142857142857142]
[null,null,13,20,17.142857142857142]
[null,null,13,19,17.142857142857142]
[null,null,13,18,17.142857142857142]
[null,null,13,17,17.142857142857142]
[null,null,13,16,17.142857142857142]
[null,null,13,15,17.142857142857142]
[null,null,13,14,17.142857142857142]
[null,null,13,13,17.142857142857142]
[null,null,13,12,17.142857142857142]
[null,null,13,11,17.142857142857142]
[null,null,13,10,17.142857142857142]
[null,null,13,9,17.142857142857142]
[null,null,13,8,17.142857142857142]
[null,null,13,7,17.142857142857142]
[null,null,13,6,17.142857142857142]
[null,null,13,5,17.142857142857142]
[null,null,13,4,17.142857142857142]

{"sheet":"Graph","index":4,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,null,"Vinmin","Vinmax","Lower ts limit","Upper ts limit","Lo B-B Voltage","Hi B-B voltage","Lower Buck","Upper Buck"]
[]
[]
[null,null,{"$f":"Vinmin","v":9},{"$f":"Vinmax","v":40},{"$f":"1.15*Vout","v":32.199999999999996},{"$f":"Vout/0.75","v":37.333333333333336},{"$f":"Vinmin","v":9},{"$f":"E7","v":32.199999999999996},{"$f":"Vout/0.75","v":37.333333333333336},{"$f":"Vinmax","v":40},null,{"$f":"Vout","v":28},{"$f":"Vin_nominal","v":{"$error":"#NAME?"}}]
[null,null,"Buck-Boost",null,null,null,5,{"$f":"IF(Vinmax<H7,Vinmax,H7)","v":32.199999999999996}]
[null,null,"Graph-Trans",null,null,{"$f":"IF(Vinmax>F7,F7,IF(Vinmax>E7,Vinmax,0))","v":37.333333333333336}]
[null,null,"Offset-Trans",null,null,{"$f":"F9-H8","v":5.13333333333334}]
[]
[null,"NEW ","Buck",null,null,null,null,{"$f":"IF(Vinmax>F7,Vinmax,0)","v":40}]
[null,"Offset","Offset-Buck",null,null,null,null,{"$f":"H12-F7","v":2.6666666666666643}]