{"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":8,"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,5.03]
[" Enter design requirements in the shaded cells",null,"Vin(min) (V)",null,3.5,null,"Normal 12V system range is 9V to 16V, with cold crank at battery terminal is 6.5Vmin."]
[null,null,"Vin(max) (V)",null,70,null,"Normal 24V system range is 18V to 32V."]
[null,null,"Maximum Average Load Current Iout (A)",null,2.9,null,"Choose switching freq at 300KHz for EMC limit purpose, check conducted emssions (voltage) limit, 300KHz to 500KHz has higher limits."]
[null,null,"Ripple Current as % of Maximum Load Current (%)",null,0.4,null,"Choose inductor favoring buck mode because it will be in buck mode unless it is under cold cranking (which will be about 10s)"]
[null,null,"Effciency of Converter (%)",null,0.8]
[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":6.6899000000000006}]
[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":500}]
[{"$f":"IF(E21>=E20,\"Violation of Minimum On-Time or Max Frequency\",\"\")","v":""},null,"Switching Frequency (kHz)",null,304]
[{"$f":"IF(E21>=E20,\"Reduce Switching Frequency\",\"\")","v":""},null,"Timing Resistor, Rt (kW)",null,{"$f":"6.4*10^3/Fsw-3.02","v":18.03263157894737}]
[{"$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":13.238879796473944}]
[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":5.8526887062422999}]
[null,null,"Actual Chosen Inductor Value, L (µH)",null,6.8]
[null,null,"Inductor Tolerance (%)",null,0.3]
[]
["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":2.2583971417514377}]
[null,null,"Buck-Boost Ripple Current at Vin(min), ΔI (A)",null,{"$f":"(Vout*Vinmin)/(Fsw*L*(Vout+Vinmin))*1000","v":0.9983998381236866}]
[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.2166215170278636}]
[null,null,"Buck mode Ripple Current at Vin(max), Including inductor tolerance, ΔI (A)",null,{"$f":"IrippleBuck/(1-L_tol)","v":3.2262816310734825}]
[null,null,"Buck-Boost Ripple Current at Vin(min), Including inductor tolerance, ΔI (A)",null,{"$f":"IrippleBB/(1-L_tol)","v":1.4262854830338381}]
[null,null,"Buck Average Inductor Current at Vin(max), Including Effciency (A)",null,{"$f":"Iout/Eff","v":3.6249999999999996}]
[null,null,"Buck-Boost Average Inductor Current at Vin(min), Including Effciency (A)",null,{"$f":"((Vout+Vinmin)/Vinmin)*(Iout/Eff)","v":8.8346428571428568}]
[null,null,"Buck-Mode Peak Inductor Current, Ip(b) (A)",null,{"$f":"IF(Vinmax>E14,ILavgBuck+E34/2,\"NA\")","v":5.2381408155367408}]
[null,null,"Buck-Boost Mode Peak Inductor Current, Ip(b-b) (A)",null,{"$f":"IF(BuckBoostMode=\"YES\",ILavgBB+E35/2,\"NA\")","v":9.5477855986597753}," "]
[]
["Step 5 - Sense Resistor"]
[null,null,"Current Limit Margin (% beyond Max Load) (%)",null,0.01]
[null,null,"Buck Mode K Factor (K)",null,{"$f":"1+(10/(Vinmax-Vout))","v":1.1539171925504079}]
[null,null,"Selected Buck Mode K Factor (K)",null,1.18]
[null,null,"Buck-Boost Mode K Factor (K)",null,{"$f":"1+(10/Vinmin)","v":3.8571428571428572}]
[null,null,"Selected Buck-Boost Mode K Factor (K)",null,3.86]
[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":22.998536035985261}," "]
[null,null,"Closest Standard Value, Rs (mW)",null,22]
[]
["Step 6 - Ramp Capacitor"]
[null,null,"Cramp (pF)",null,{"$f":"(L*5*10^-6)/(10*Rs)*10^9","v":154.54545454545453}]
[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":"NA"}]
[]
["Step 7 - Current Limits"]
[null,null,"Buck Mode Peak Inductor Current Limit (A)",null,{"$f":"IF(ILPeakLimitBuck<IpeakBuck,\"Error\",ILPeakLimitBuck)","v":5.5190274239317301}]
[null,null,"Buck-Boost Mode Peak Inductor Current Limit (A)",null,{"$f":"IF(ILPeakLimitBB<IpeakBB,\"Error\",ILPeakLimitBB)","v":10.027721586139105}]
[]
["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.58968347010550992}]
[null,null,"Buck-Boost RMS Ripple Current in Output Cap (A)",null,{"$f":"SQRT(-(DBB*Iout^2)/(DBB-1))","v":3.4765459048560579}]
[null,null,"Minimum COUT output Capacitor Value (µF)",null,{"$f":"Iout*Vout/(Vinmin+Vout)/(Fsw*DeltaVout)*1000000","v":112.50539890170911}]
[null,null,"Required COUT ESR (mW)",null,{"$f":"DeltaVout/(Iout/(1-E61)+IrippleBB/2)","v":6.6077133487836708}]
[null,null,"Chosen COUT output capacitor value (µF)",null,100]
[null,null,"Actual COUT ESR (mW)",null,1.5]
[null,null,"Buck Mode Output Ripple Voltage (mV)",null,{"$f":"IF(Vinmax<BuckMode,\"NA\",Coutesr*((Iout/(1-E61)+(IrippleBB/2))))","v":11.350371307164192}]
[]
["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":3.4765459048560579}]
[null,null,"Buck-Boost Mode Peak to Peak Current Ripple in Input Cap (A)",null,{"$f":"IpeakBB","v":9.5477855986597753}]
[null,null,"Buck Mode RMS input Ripple Current (A)",null,{"$f":"IF(Vinmax<BuckMode,\"NA\",Iout*0.5)","v":1.45}]
[null,null,"Buck Mode Peak to Peak Current Ripple in Input Cap (A)",null,{"$f":"IpeakBuck","v":5.2381408155367408}]
[null,null,"Initial Input Capacitor Value(μF)",null,{"$f":"E39/2/Fsw*1000","v":15.70359473463779},null,"Cout=22uF 25V 1210"]
[null,null,"Chosen CIN Input Capacitor Value (µF)",null,30,null,"Cin=4.7uF 100V 1210"]
[]
["Step 11 - Feedback Resistors",null,null,null,null,null,null,4300]
[null,null,"Rfb2 (W)",null,5100]
[null,null,"Rfb1 (W)",null,{"$f":"_Rfb2/((Vout/1.23)-1)","v":1650.7894736842104}]
[]
["Step 12 - Chb & Cvcc Capacitor"]
[null,null,"High-side MOSFET Qg at VGS=10V (nC)",null,18]
[null,null,"Minimum Bootstrap Capacitor Chb (µF)",null,{"$f":"E82*10^-3/(0.05*7)","v":5.1428571428571428E-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":11.590449486692467}]
[null,null,"Capacitor ESR Zero Frequency (kHz)",null,{"$f":"1/(Cout*Coutesr*2*PI()*10^-6)","v":1061.032953945969}]
[null,null,"Capacitor Pole Frequency (kHz)",null,{"$f":"(1+DBB)/(2*PI()*Cout*Rout*10^-3)","v":1.458682601261293}]
[null,null,"Bandwidth (kHz)",null,{"$f":"fmodRzero/4","v":2.8976123716731168}]
[null,null,"Selected Bandwith (kHz)",null,2.9]
[null,null,"Target Compensation Zero (kHz)",null,{"$f":"fcutoff/10","v":0.28999999999999998}]
[null,null,"Target Compensation Pole (kHz)",null,{"$f":"fmodRzero","v":11.590449486692467}]
[null,null,"Cpole (nF)",null,{"$f":"fcompZero/(fcompPole*_Rfb2*CompGain)*10^9","v":2.475566673389102}]
[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":96.46557290887192},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":5692.0670920289231}]
[null,null,"Select nearest Standard Rcomp Value (W)",null,5600]
[]
["Step 14 - Soft Start capacitor"]
[null,null,"Choose soft-start time (ms)",null,1.85]
[null,null,"Soft Start Capacitor Value (nF)",null,{"$f":"(E103*10^(-5))/1.23*10^6","v":15.040650406504067}]
[]
["Step 15 - UVLO Threshold and Hiccup Mode Restart"]
[null,null,"Minimum Value of Resistor Ruv1  (kW)",null,{"$f":"Vinmax","v":70}]
[null,null,"Chosen Value of  Ruv1 (kW)",null,999999]
[null,null,"Desired Undervoltage Threshold (V)",null,0]
[null,null,"Ruv2 Value (kW)",null,{"$f":"1.23*E108/(E109+5*E108*10^(-3)-1.23)","v":246.06053095114493}]
[null,null,"Choose off-time of hiccup duty cycle (µs)",null,246]
[null,null,"Vin voltage for desired hiccup mode off-time  (V)  ",null,0]
[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":{"$error":"#DIV/0!"}}]

{"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":6.8},{"$f":"ILPeakLimitBB","v":10.027721586139105}]
[null,"Cin ","Input capacitor",{"$f":"Cin","v":30},{"$f":"Vinmax","v":70}]
[null,"Cramp","Ramp capacitor",{"$f":"Cramp","v":330},16]
[null,"Css","Soft start capacitor",{"$f":"Css","v":15.040650406504067},6]
[null,"Cout","Output capacitor",{"$f":"Cout","v":100},{"$f":"Vout","v":5.03}]
[null,"Cr","UVLO filter capacitor",{"$f":"Cr","v":{"$error":"#DIV/0!"}},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":1650.7894736842104},"1/16 W"]
[null,"Rfb2","Feedback resistor",{"$f":"_Rfb2","v":5100},"1/16 W"]
[null,"Ruv1","UVLO divider resistor",{"$f":"_Ruv1","v":999999},{"$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":246.06053095114493},"1/16 W"]
[null,"Rs","Sense resistor",{"$f":"Rs","v":22},{"$f":"IF(PRS_BB>PRS_B,PRS_BB,PRS_B)","v":1.7171201170918367}]
[null,"Rt","Oscillator timing resistor",{"$f":"Rt","v":18.03263157894737},"1/16 W"]
[null,"Rramp","Optional ramp resistor",{"$f":"Rramp","v":"NA"},{"$f":"IF(D20=\"NA\",\"-\",\"1/16 W\")","v":"-"}]
[null,"Rcomp","Compensation resistor",{"$f":"Rcomp/1000","v":5.6},"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":6.1711132029922915},{"$f":"IMARGUMENT(IMDIV(IMPRODUCT(COMPLEX(1,-C3/wrBB),COMPLEX(1,C3/wzBB)),COMPLEX(1,C3/wpBB)))*(180/PI())","v":-4.4168488494999297E-3},{"$f":"20*LOG(Afb*IMABS(IMDIV(IMDIV(COMPLEX(1,C3/wzea),COMPLEX(1,C3/wpea)),COMPLEX(0,C3))))","v":69.695981732331191},{"$f":"IMARGUMENT(IMDIV(IMDIV(COMPLEX(-1,-C3/wzea),COMPLEX(1,C3/wpea)),COMPLEX(0,C3)))*(180/PI())","v":90.019726026565294},{"$f":"D3+F3","v":75.867094935323479},{"$f":"E3+G3","v":90.015309177715793},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":17.934946075115022},{"$f":"IMARGUMENT(IMDIV(COMPLEX(1,O3/wzb),COMPLEX(1,O3/wpb)))*(180/PI())","v":-6.2387379063143155E-3},{"$f":"20*LOG(Afb*IMABS(IMDIV(IMDIV(COMPLEX(1,O3/wzea),COMPLEX(1,O3/wpea)),COMPLEX(0,O3))))","v":69.695981732331191},{"$f":"IMARGUMENT(IMDIV(IMDIV(COMPLEX(-1,-O3/wzea),COMPLEX(1,O3/wpea)),COMPLEX(0,O3)))*(180/PI())","v":90.019726026565294},{"$f":"P3+R3","v":87.630927807446213},{"$f":"Q3+S3","v":90.013487288658979},null,"Modulator - Buck"]
[null,0.2,{"$f":"2*PI()*B4","v":1.2566370614359172},6.1711131427294932,-8.8336976620055022E-3,63.675383431329621,90.039452048138855,69.846496574059117,90.030618350476857,null,"rad/sec","Hz",null,0.2,{"$f":"2*PI()*N4","v":1.2566370614359172},17.934945920374187,-1.2477475664307885E-2,63.675383431329621,90.039452048138855,{"$f":"P4+R4","v":81.610329351703811},{"$f":"Q4+S4","v":90.026974572474543},null,"rad/sec","Hz"]
[null,0.5,{"$f":"2*PI()*B5","v":3.1415926535897931},6.1711127208898748,-2.2084243507613274E-2,55.716594543818154,90.098630032991906,61.887707264708027,90.0765457894843,"wp",{"$f":"(1+DBB)/(Cout*10^-6*Rout)","v":9165.1730880834566},{"$f":"K5/(2*PI())","v":1458.6826012612933},null,0.5,{"$f":"2*PI()*N5","v":3.1415926535897931},17.934944837188489,-3.1193686565155341E-2,55.716594543818154,90.098630032991906,73.651539381006643,90.067436346426746,"wz",{"$f":"1/(Cout*10^-6*Coutesr*10^-3)","v":6666666.666666667},{"$f":"W5/(2*PI())","v":1061032.953945969}]
[null,1,{"$f":"2*PI()*B6","v":6.2831853071795862},6.1711112143200015,-4.4168482390938124E-2,49.696034937189069,90.197259442022073,55.867146151509068,90.153090959631129,"wr",{"$f":"(Rout*(1-DBB)^2)/(L*10^-6*DBB)","v":72824.941918393306},{"$f":"K6/(2*PI())","v":11590.449486692471},null,1,{"$f":"2*PI()*N6","v":6.2831853071795862},17.934940968670332,-6.2387354590221031E-2,49.696034937189069,90.197259442022073,67.630975905859401,90.134872087431859,"wp",{"$f":"1/(Cout*10^-6*Rout)","v":5765.4075546719678},{"$f":"W6/(2*PI())","v":917.59311126540047}]
[null,2,{"$f":"2*PI()*B7","v":12.566370614359172},6.1711051880461421,-8.833692778760753E-2,43.675596246767547,90.394513892489243,49.846701434813689,90.306176964701635,"wz",{"$f":"1/(Cout*10^-6*Coutesr*10^-3)","v":6666666.666666667},{"$f":"K7/(2*PI())","v":1061032.953945969},null,2,{"$f":"2*PI()*N7","v":12.566370614359172},17.934925494632207,-0.12477456086012516,43.675596246767547,90.394513892489243,61.610521741399751,90.269739331629111,null,"Gain","dB"]
[null,5,31.415926535897931,6.1710630043705503,-0.22084167207369629,35.717924465627625,90.986197394581964,41.888987469998177,90.765355722508275,null,"Gain","dB",null,5,31.415926535897931,17.934817177909025,-0.31193380658914482,35.717924465627625,90.986197394581964,53.65274164353665,90.674263587992826,"Am",{"$f":"Rout/Ri","v":7.8840125391849538},{"$f":"20*LOG(Amb)","v":17.934946126695301}]
[null,10,62.831853071795862,6.1709123518384672,-0.4416787200200159,29.701352131005283,91.971771400469791,35.872264482843747,91.530092680449769,"Am",{"$f":"(Rout/Ri)*((1-DBB)/(1+DBB))","v":2.0349589887276802},{"$f":"20*LOG(K9)","v":6.1711132230799262},null,10,62.831853071795862,17.934430354520771,-0.62384907472385509,29.701352131005283,91.971771400469791,47.63578248552605,91.347922325745941]
[null,20,125.66370614359172,6.1703097956469719,-0.88332045092463962,23.69682525030365,93.938569532208632,29.867135045950622,93.055249081283989,null,null,null,null,20,125.66370614359172,17.932883405417403,-1.247549881430104,23.69682525030365,93.938569532208632,41.629708655721053,92.691019650778529]
[null,50,314.15926535897933,6.1660943167916837,-2.2076542546356044,15.848899397428939,99.76090868153446,22.014993714220623,97.55325442689886,null,"Error Amp",null,null,50,314.15926535897933,17.922070162866984,-3.1162844411728674,15.848899397428939,99.76090868153446,33.770969560295924,96.644624240361594,null,"Error Amp"]
[null,100,628.31853071795865,6.151073421180576,-4.4107004300700723,10.202639013482258,108.95088406285623,16.353712434662835,104.54018363278615,null,"rad/sec","Hz",null,100,628.31853071795865,17.883669747309575,-6.2141924670730004,10.202639013482258,108.95088406285623,28.086308760791834,102.73669159578323,null,"rad/sec","Hz"]
[null,200,1256.6370614359173,6.0915205481917187,-8.78491988244682,5.4214278365313238,124.26681433113134,11.512948384723042,115.48189444868453,"wpea",{"$f":"(Czero*10^-9+Cpole*10^-9)/(Cpole*10^-9*Czero*10^-9*Rcomp)","v":82954.545454545456},{"$f":"wpea/(2*PI())","v":13202.625961032227},null,200,1256.6370614359173,17.733375991990254,-12.285167301608965,5.4214278365313238,124.26681433113134,23.15480382852158,111.98164702952238,"wpea",{"$f":"(Czero*10^-9+Cpole*10^-9)/(Cpole*10^-9*Czero*10^-9*Rcomp)","v":82954.545454545456},{"$f":"wpea/(2*PI())","v":13202.625961032227}]
[null,500,3141.5926535897929,5.6967339147165497,-21.363584554957917,1.8330103160225875,148.21681830663849,7.5297442307391371,126.85323375168056,"wzea",{"$f":"1/(Czero*10^-9*Rcomp)","v":1785.7142857142856},{"$f":"wzea/(2*PI())","v":284.20525552124167},null,500,3141.5926535897929,16.805814601698486,-28.559135569410973,1.8330103160225875,148.21681830663849,18.638824917721074,119.65768273722752,"wzea",{"$f":"1/(Czero*10^-9*Rcomp)","v":1785.7142857142856},{"$f":"wzea/(2*PI())","v":284.20525552124167}]
[null,1000,6283.1853071795858,4.5302145985315132,-39.309740086356456,0.93583850648245248,159.8031160421595,5.466053105013966,120.49337595580305,null,"Gain","dB",null,1000,6283.1853071795858,14.535110565829486,-47.40672203146044,0.93583850648245248,159.8031160421595,15.470949072311939,112.39639401069905,null,"Gain","dB"]
[null,2000,12566.370614359172,1.704756487355229,-63.577495957266919,0.61162881853796802,163.29830776738379,2.3163853058931969,99.720811810116871,"Afb",{"$f":"1/(_Rfb2*(Czero*10^-9+Cpole*10^-9))","v":1918.575649437857},{"$f":"20*LOG(K16)","v":65.659578562067395},null,2000,12566.370614359172,10.337737119830892,-65.246506000638803,0.61162881853796802,163.29830776738379,10.94936593836886,98.051801766744987,"Afb",{"$f":"1/(_Rfb2*(Czero*10^-9+Cpole*10^-9))","v":1918.575649437857},{"$f":"20*LOG(W16)","v":65.659578562067395}]
[null,5000,31415.926535897932,-4.1425106140974171,-96.800976408970499,5.5278176609613025E-2,156.00444313177178,-4.0872324374878044,59.203466722801281,null,null,null,null,5000,31415.926535897932,3.0647880814643274,-79.330873469121414,5.5278176609613025E-2,156.00444313177178,3.1200662580739404,76.673569662650365]
[null,10000,62831.853071795864,-8.2242915750396524,-121.94785672735175,-1.3423538405997271,141.23086096501484,-9.5666454156393801,19.283004237663093,null,null,null,null,10000,62831.853071795864,-2.8480787515001484,-84.217276060318653,-1.3423538405997271,141.23086096501484,-4.1904325920998753,57.013584904696188]
[null,20000,125663.70614359173,-10.595609157754009,-144.65544022998495,-4.5540363507145161,122.61591777543269,-15.149645508468524,-22.039522454552255,null,null,null,null,20000,125663.70614359173,-8.8402401402086728,-86.29325935606856,-4.5540363507145161,122.61591777543269,-13.39427649092319,36.322658419364132]
[null,50000,314159.26535897929,-11.598421757445935,-162.57977724050363,-11.235430589876454,104.46581892187855,-22.833852347322392,-58.11395831862508,null,null,null,null,50000,314159.26535897929,-16.783279972430208,-86.250629704047256,-11.235430589876454,104.46581892187855,-28.018710562306662,18.215189217831295]
[null,100000,628318.53071795858,-11.736239686753525,-167.16886133268821,-17.038468801282168,97.358211940270465,-28.774708488035692,-69.810649392417744,null,null,null,null,100000,628318.53071795858,-22.774010125917346,-84.090176711431184,-17.038468801282168,97.358211940270465,-39.812478927199514,13.268035228839281]
[null,200000,1256637.0614359172,-11.665716854580502,-165.59066671808787,-23.002929927857902,93.695375250459819,-34.668646782438401,-71.895291467628056,null,null,null,null,200000,1256637.0614359172,-28.681113045229829,-79.062381369107499,-23.002929927857902,93.695375250459819,-51.684042973087728,14.63299388135232]
[null,500000,3141592.653589793,-10.958433215449048,-153.27328070554614,-30.945880197218489,91.479990500340591,-41.904313412667534,-61.793290205205551,null,null,null,null,500000,3141592.653589793,-35.920518730633177,-64.66321449200376,-30.945880197218489,91.479990500340591,-66.866398927851662,26.816776008336831]
[null,1000000,6283185.307179586,-9.0704741021052886,-135.94856229210714,-36.964211104615778,90.740127037060944,-46.034685206721065,-45.208435255046197,null,null,null,null,1000000,6283185.307179586,-40.051426595903791,-46.643618494998989,-36.964211104615778,90.740127037060944,-77.015637700519562,44.096508542061954]

{"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":3.5},{"$f":"Vinmax","v":70},{"$f":"1.15*Vout","v":5.7844999999999995},{"$f":"Vout/0.75","v":6.706666666666667},{"$f":"Vinmin","v":3.5},{"$f":"E7","v":5.7844999999999995},{"$f":"Vout/0.75","v":6.706666666666667},{"$f":"Vinmax","v":70},null,{"$f":"Vout","v":5.03},{"$f":"Vin_nominal","v":{"$error":"#NAME?"}}]
[null,null,"Buck-Boost",null,null,null,5,{"$f":"IF(Vinmax<H7,Vinmax,H7)","v":5.7844999999999995}]
[null,null,"Graph-Trans",null,null,{"$f":"IF(Vinmax>F7,F7,IF(Vinmax>E7,Vinmax,0))","v":6.706666666666667}]
[null,null,"Offset-Trans",null,null,{"$f":"F9-H8","v":0.92216666666666747}]
[]
[null,"NEW ","Buck",null,null,null,null,{"$f":"IF(Vinmax>F7,Vinmax,0)","v":70}]
[null,"Offset","Offset-Buck",null,null,null,null,{"$f":"H12-F7","v":63.293333333333337}]