{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Power Circuit Design","Compensator Circuit Design ","Device Pin Programming","Schematics","Data","Plant Transfer Function"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":112,"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":"Power Circuit Design","index":0,"n_rows":106,"n_cols":5,"rows_kept":106,"cut":false,"hidden":false,"merged":[[3,0,3,1],[78,0,78,4],[92,0,92,4],[28,0,28,4],[17,0,17,4],[36,0,36,4],[44,0,44,4],[65,0,65,4],[87,0,87,4],[5,0,8,4],[9,0,11,4],[15,0,15,4],[19,0,19,4],[59,4,61,4],[93,0,93,4],[79,0,79,4],[80,4,85,4],[86,0,86,4],[0,0,0,4],[35,0,35,4],[45,0,45,4],[18,0,18,4],[21,0,21,4],[29,0,29,4],[34,0,34,4],[37,0,37,4],[12,0,14,4],[4,0,4,4],[2,0,2,4],[1,0,1,4]]}
["UCG2882x DESIGN CALCULATOR TOOL"]
["TI Literature Number:                                                                                                                                                                                                                                                                                                               Version : Original"]
["UCG2882x  QR Flyback Controller"]
["Please enter design parameters into ",null,"shaded","cells"]
["Recommended Component Values are in GREEN"]
["Be sure to enable editing before attempting to use this design calculator\n\nThis spreadsheet guides the user through the design process of QR flyback DC/DC converter using UCG2882x. User interaction is required in order to get best possible results. Enter the desired specifications where prompted, the highlighted cells are for user inputs; calculations for the design are based upon the inputs."]
[]
[]
[]
["WHERE APLICABLE, A RECOMMENDED VALUE IS GIVEN THAT WILL BE THE BEST CHOICE TO MEET THE GIVEN SPECIFICATION. IT IS IN THE BEST INTEREST OF THE USER TO USE A VALUE AS CLOSE AS POSSIBLE TO THE SUGGESTED VALUE. FOR ACCURATE RESULTS, THE USER MUST ENTER THE ACTUAL VALUE USED IN THE DESIGN IN THE APPROPRIATE CELL."]
[]
[]
["DISCLAIMER\nThis product is designed as an aid for customers of Texas Instruments. No warranties, either expresses or implied, with respect to this software or its fitness for any particular purpose, are claimed by Texas Instruments or the author. The software is licensed solely on an \"as is\" basis. The entire risk to its quality and performance is with the customer."]
[]
[]
[]
["Device you are using",null,"UCG28826-1",null,"Refer datasheet for detailed information"]
[]
["DESIGN SPECIFICATIONS"]
[]
["Design Parameter","Symbol","Values","Unit","Comment"]
["OUTPUT PARAMETERS"]
["Minimum output voltage","Vout_min",5,"V","Enter the desired minimum output voltage of the converter"]
["Maximum output voltage","Vout_max",20,"V","Enter the desired maximum output voltage of the converter"]
["Output over voltage protection point","Vovp",25,"V","Enter required output OVP point"]
["Maximum output power ","Pout_max",65,"W","Enter required maximum output power of converter "]
["Target full load efficiency","η",0.92,null,"Enter target efficiency at low line and maximum output power"]
["Maximum output voltage ripple","Vout_ripple",200,"mV","Enter required maximum output voltage ripple"]
[]
["INPUT PARAMETERS"]
[{"$f":"INDEX(Data!K44:K50,MATCH(Device,Data!J44:J50),0)","v":"Minimum AC input voltage"},{"$f":"INDEX(Data!L44:L50,MATCH(Device,Data!J44:J50),0)","v":"Vin_min"},90,{"$f":"INDEX(Data!M44:M50,MATCH(Device,Data!J44:J50),0)","v":"Vac"},{"$f":"INDEX(Data!N44:N50,MATCH(Device,Data!J44:J50),0)","v":"Enter minimum ac input voltage "}]
[{"$f":"INDEX(Data!K51:K57,MATCH(Device,Data!J51:J57),0)","v":"Maximum AC input voltage"},{"$f":"INDEX(Data!L51:L57,MATCH(Device,Data!J51:J57),0)","v":"Vin_max"},264,{"$f":"INDEX(Data!M51:M57,MATCH(Device,Data!J51:J57),0)","v":"Vac"},{"$f":"INDEX(Data!N51:N57,MATCH(Device,Data!J51:J57),0)","v":"Enter maximum ac input voltage"}]
["Minimum line frequency","fline_min",47,"Hz","Enter minimum line frequency"]
["Maximum line frequency","fline_max",66,"Hz","Enter maximum line frequency"]
[]
["DESIGN CALCULATIONS"]
[]
["INPUT BULK CAPACITOR"]
["Desired minimum bulk voltage at full load","Vbulk_min_desired",75,"V","Enter minimum desired valley bulk voltage. Adjust this voltage to ensure the calculated bulk capacitance value matches with the selected one."]
["Recommended input bulk capacitance","Cbulk_recom",{"$f":"((2*(Pout_max/efficiency)*((1/(4*fline_min))+(1/(2*3.14*fline_min))*ASIN(Vbulk_min_desired/(SQRT(2)*Vin_min)))/((SQRT(2)*Vin_min)^2-Vbulk_min_desired^2))*10^6)","v":99.601853539078576},"μF"]
["Actual input bulk capacitance","Cbulk_actual",60,"μF"]
["Minimum peak voltage rating of bulk capacitor","Vcbulk_peak",{"$f":"SQRT(2)*Vin_max*1.15","v":429.35523753647163},"V","Including 15% margin"]
["Minimum RMS current rating of bulk capacitor","Icbulk_rms",{"$f":"Icbulk_rms","v":0.78820188277079273},"A"]
["Minimum peak current rating of bulk capacitor","Icbulk_peak",{"$f":"2*PI()*fline_min*Cbulk_recom*10^-6*SQRT(2)*Vin_min*COS(ASIN(Vbulk_min_desired/(SQRT(2)*Vin_min)))","v":1.8220872312430965},"A"]
[]
["FLYBACK STAGE"]
["Maximum primary/secondary turns ratio","Nps_max",{"$f":"IF( (560- (Vbulk_max))/(Vout_max)<0, 0,(560- (Vbulk_max))/(Vout_max) )","v":9.3323809766751449}]
["Recommended primary/secondary turns ratio","Nps_recom",{"$f":"IF( (520- (Vbulk_max))/(Vout_max)<0, 0,(520- (Vbulk_max))/(Vout_max) )","v":7.3323809766751449}]
["Recommended TR value","TR_recom",{"$f":"IFERROR(INDEX(Data!$G$5:$G$20, MATCH(TR_calc, Data!$G$5:$G$20, 0)), IFERROR(INDEX(Data!$G$5:$G$20, MATCH(TR_calc, Data!$G$5:$G$20, 1) + 1), IF(TR_calc>7.875, 7.875,6)))","v":7.375},null,{"$f":"IF(TR_calc>7.875, \"Clamping at the max TR value.\", IF(TR_calc<6, \"Clamping at the min TR value.\", \" \"))","v":" "}]
["Select TR value","TR_actual",6,null,"Adjust TR value to match Nps_calc with Nps_sel as close as possible"]
["Calculated primary/secondary turns ratio","Nps_calc",{"$f":"25*TR/(Vovp)","v":6},null,"Calculated based on TR and Vovp settings"]
["Selected primary/secondary turns ratio","Nps_sel",6,null,{"$f":"IF(Nps_sel>Nps_max, \"Nps_sel exceeds Nps_max, continuing calculations on user's request\", \"  \")","v":"  "}]
["Actual OVP point","Vovp_actual",{"$f":"IF(Device=\"UCG28826-4\", 16*TR/(Nps_sel),25*TR/(Nps_sel))","v":25},"V",{"$f":"IF( C53<Vout_max, \"Vovp is less than Vout_max\", \"It has 8% tolerance\")","v":"It has 8% tolerance"}]
["Maximum duty ratio","Dmax",{"$f":"(Nps_sel*Vout_max)/(Vbulk_min+(Nps_sel*Vout_max))","v":0.61538461538461542}]
["Primary side maximum peak current","Ipk_max",{"$f":"2*Pout_max/(Vbulk_min*Dmax*efficiency)","v":3.0615942028985508},"A"]
["Recommended peak current setting","Ipk_set_recom",{"$f":"Ipk_recom","v":3.1},"A"]
["Peak current setting of the device ","Ipk_set",3.1,"A",{"$f":"IF(Ipk_set<Ipk_max, \"Ipk_set cannot be less than Ipk_max\",  \"Select  Ipk_set higher than Ipk_max (refer datasheet to select appropriate value)\")","v":"Select  Ipk_set higher than Ipk_max (refer datasheet to select appropriate value)"}]
["Clamp switching frequency of the device","Fclamp",140,"kHz","Select maximum switching frequency"]
["Desired minimum switching frequency at low line and full load","Fsw_desired_LLFL",75,"kHz","Enter the desired nominal switching frequency "]
["Recommended magnetizing inductance","Lm_recom",{"$f":"_xlfn.IFS( Lm>Lm_max_datasheet, Lm_max_datasheet,       Lm <Lm_min_datasheet, Lm_min_datasheet,       Lm <Lm_max_datasheet, Lm)","v":201.0013654984069},"μH","Min. inductance is clamped at 190 µH for UCG28824 and 130 µH for UCG28826/8. \nMax. inductance is clamped at 550 µH for UCG28824 and 400 µH for UCG28826/8. "]
["Minimum magnetizing inductance","Lm_min",{"$f":"_xlfn.IFS( Lm*Fsw_desired_LLFL/(Fclamp)< Lm_min_datasheet,Lm_min_datasheet,        Lm*Fsw_desired_LLFL/(Fclamp)>Lm_max_datasheet, Lm_max_datasheet,        Lm*Fsw_desired_LLFL/(Fclamp)>Lm_min_datasheet, Lm*Fsw_desired_LLFL/(Fclamp))","v":130},"μH"]
["Maximum magnetizing inductance","Lm_max",{"$f":"_xlfn.IFS( Lm*Fsw_desired_LLFL/30>Lm_max_datasheet, Lm_max_datasheet,        Lm*Fsw_desired_LLFL/30 < Lm_min_datasheet, Lm_min_datasheet,        Lm*Fsw_desired_LLFL/30<Lm_max_datasheet,  Lm*Fsw_desired_LLFL/30)","v":400},"μH"]
["Actual magnetizing inductance","Lm_actual",200,"μH","Enter the actual value of the magnetizing inductance used"]
["Actual minimum switching frequency at low line and full load","Fsw_actual_LLFL",{"$f":"(Vbulk_min*Dmax/(Ipk_max*Lm_actual))*10^3","v":75.375512061902597},"kHz"]
[]
["FLYBACK TRANSFORMER"]
["Magnetizing inductance","Lm_actual",{"$f":"Lm_actual","v":200},"μH"]
["Primary side leakage inductance","Llk",3,"μH","Enter the expected leakage inducance (should be below 3% of Lm_actual)"]
["Select transformer core area","Acore",64,"mm2","Enter the effective cross-sectional area of the core"]
["Desired maximum operating core flux density","Bmax",0.32,"T","Enter a value lesser than the saturation flux density of the core"]
["Number of turns of the primary winding","Np",{"$f":"(Lm_actual*Ipk_set/(Bmax*Acore))","v":30.2734375}]
["Number of turns of the secondary winding","Ns",{"$f":"Np/Nps_sel","v":5.045572916666667}]
["Primary winding peak voltage stress","Vpri",{"$f":"MAX(Vbulk_max,Vout_max*Np/Ns)*1.15","v":429.35523753647163},"V","Including 15% margin"]
["Primary winding peak current stress","Ipri_pk",{"$f":"Ipk_max","v":3.0615942028985508},"A"]
["Primary winding RMS current stress","Ipri_rms",{"$f":"Ipri_pk*SQRT(Dmax/3)","v":1.3866291215249036},"A"]
["Secondary winding peak voltage stress","Vsec",{"$f":"MAX(Vout_max,Vbulk_max/Nps_sel)*1.15","v":71.559206256078596},"V","Including 15% margin"]
["Secondary winding peak current stress","Isec_pk",{"$f":"Ipk_max*Nps_sel","v":18.369565217391305},"A"]
["Secondary winding RMS current stress","Isec_rms",{"$f":"Isec_pk*SQRT((1-Dmax)/3)","v":6.5773594409056608},"A"]
[]
["SNUBBER CIRCUIT (RCD)"]
["Worst case overshoot voltage across primary side switch","Vos",275,"V"]
["Voltage across snubber capacitor","Vsn",{"$f":"(Vos+Nps_sel*Vout_max)","v":395},"V"]
["Worst case ripple in snubber capacitor","ΔVsn",3,"V"]
["Worst case power dissipation in the snubber circuit","Psn",{"$f":"0.5*Llk*10^-6*(Ipk_max)^2*Fsw_actual_LLFL*10^3*Vsn/(Vsn-(Nps_sel*Vout_max))*0.2","v":0.30444664031620572},"W"]
["Recommended snubber resistance","Rsn_recom",{"$f":"(Vsn^2/Psn)*10^-3","v":512.48717948717911},"kΩ "]
["Recommended snubber capacitance","Csn_recom",{"$f":"Psn/(Fsw_actual_LLFL*10^3*Vsn_ripple*Vsn)*10^9","v":3.4084942048080058},"nF"]
[]
["FLYBACK OUTPUT RECTIFIER DIODE/SYNCHRONOUS RECTIFIER"]
["Peak voltage stress of SR FET/diode","Vds_peak",{"$f":"((Vbulk_max)/Nps_sel+Vout_max)*1.15","v":94.559206256078596},"V","Including 15% margin"]
["Peak current stress of SR FET/diode","Id_peak",{"$f":"Isec_pk","v":18.369565217391305},"A"]
["RMS current stress of SR FET/diode","Id_rms",{"$f":"Isec_rms","v":6.5773594409056608},"A"]
["Average current stress of SR FET/diode","Id_avg",{"$f":"Pout_max/Vout_max","v":3.25},"A"]
[]
["OUTPUT CAPCITOR SELECTION"]
["Maximum output voltage ripple","Vout_ripple",{"$f":"Vout_ripple","v":200},"mV"]
["Transient overshoot and undershoot voltage ","Vovershoot",0.5,"V","Enter the desired overshoot and undershoot value of Vout due to dynamic change in load"]
["Recommended crossover frequency","fc_recom",{"$f":"((Fsw_actual_LLFL*10^3)/20)","v":3768.7756030951305},"Hz"]
["Used crossover frequency","fc_used",3000,"Hz","Enter the targeted value of crossover frequency. "]
["Approx response time to regulate output voltage","T_response",{"$f":"((0.33/(fc))+10^-3/Fsw_actual_LLFL)*10^6","v":123.26690821256038},"us"]
["Recommended output capacitor","Cout_recom",{"$f":"ROUND(MAX(Cout_tran,Cout_ripple),0)","v":761},"uF"]
["Used output capacitor","Cout_actual",820,"uF","Enter the actual value of output capacitors used"]
["Peak voltage stress of output capacitor","Vcout_peak",{"$f":"Vout_max*1.15","v":23},"V","Including 15% margin"]
["Peak current stress of output capacitor","Icout_peak",{"$f":"MAX(Pout_max/Vout_max, Ipk_max*Nps_sel-Pout_max/Vout_max)","v":15.119565217391305},"A","Use a combination of capacitors that will meet this Peak current stress"]
["RMS current stress of output capacitor","Icout_rms",{"$f":"SQRT(Isec_rms^2-(Pout_max/Vout_max)^2)","v":5.7183176909709053},"A","Use a combination of capacitors that will meet this ripple current stress"]
["Maximum ESR of output capacitor","Resr_max.",{"$f":"(Vout_ripple/(Ipk_max*Nps_sel))","v":10.887573964497042},"mΩ "]
["ESR used","Resr_actual",5,"mΩ ","Enter the actual value of ESR of output capacitor"]

{"sheet":"Compensator Circuit Design ","index":1,"n_rows":72,"n_cols":5,"rows_kept":72,"cut":false,"hidden":false,"merged":[[41,0,41,4],[65,0,65,4],[66,0,66,4],[67,4,71,4],[0,0,0,4],[1,0,1,4],[2,0,21,4],[22,0,22,4],[32,0,32,4],[33,0,33,4]]}
["OPTOCOUPLER FEEDBACK(Only for fixed Vout)"]
["Note: This is theoretical calculation based on ideal components. Fine tuning may be needed in the actual system "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Forward Voltage of an Optocoupler","Vf(opto)",1,"V","Enter the forward voltage drop of an optocoupler used"]
["Saturation Voltage of an Optocoupler","Vce(sat)",100,"mV","Enter the collector-emitter saturation voltage of an optocoupler used"]
["Pull-up Resistor Value","Rpullup",60,"kΩ ","Fixed inside the device"]
["Minimum Value of Current Transfer Ratio of an Optocoupler","CTR(min)",0.4,null,"Enter the minimum CTR value  based upon optocoupler characterisation done"]
["Select Shunt Voltage Regulator",null,"TLV431",null,"Select the desired shunt regulator"]
["Reference Voltage of Selected Shunt Regulator","Vref",{"$f":"IF(C28=\"TLV431\",1.25,2.5)","v":1.25},"V"]
["Maximum Value of LED Resistor(Refer Figure(1))","Rled(max)",{"$f":"((Vout_max-C24-C29)*C26*C27)/((3.6-(C25*10^-3))+(C31*10^-3*C26*10^3*C27))","v":27.483870967741936},"kΩ "]
["Minimum Required Bias Current for Shunt Regulator","Ibias",0.5,"mA","Enter the bias current of used shunt regulator (TLV431/TL431 or other)"]
["Bias Resistor Value to Provide Bias Current to Shunt Regulator","Rbias",{"$f":"C24/C31","v":2},"kΩ "]
[]
["Plant Transfer Function"]
["Pole Due to Load Resistor and Output Capacitor","Fp(plant)",{"$f":"1/(2*PI()*Vout_max*Vout_max/Pout_max*Cout_actual*10^-6)","v":31.539851527357314},"Hz"]
["Zero Due to Resr and Output Capacitor","Fz(plant)",{"$f":"(1/(2*PI()*Resr_actual*10^-3*Cout_actual*10^-6))*10^-3","v":38.818278802901297},"kHz"]
["Targeted Phase Margin","PM",70,"degree"]
["Gain at Desired Cross Over Frequency (in dB) of Plant Transfer Function","H(fc(used))",-5,null,"Enter measured controlled to output gain at desired crossover frequency of plant transfer function "]
["Phase at Desired Cross Over Frequency (in degree) of Plant Transfer Function","arg[H(fc(used))]",-87,"degree","Enter measured phase at desired crossover frequency of plant transfer function"]
["LED Resistor(Refer Figure (1))","Rled",5,"kΩ ","Enter actual value of Rled used; should be less than Rled(max)"]
[]
["Compensation Transfer function"]
["Mid-band Gain at Desired Cross Over Frequency (in dB) of Compensator Transfer Function","|G(fc(used))|",{"$f":"ABS(C38)","v":5}]
["Absolute Value of Mid-band Gain at Desired Cross Over Frequency of Compensator Transfer Function","|G(fc)|",{"$f":"10^(C43/20)","v":1.778279410038923}]
["Required Boost at fc(used)","Boost",{"$f":"C37-C39-90","v":67},"degree"]
["First Pole /Low-Frequency Pole of an Optocoupler ","fopto",3,"kHz","Enter the low frequency pole of an optocoupler based upon optocoupler characterisation done"]
["Optocoupler Capacitance","Copto",{"$f":"(1/(2*PI()*C26*10^3*C46*10^3))*10^12","v":884.19412828830764},"pF"]
["Feedback Node Capacitance","Cfb",330,"pF","Enter the FB node capacitor value (minimum 100pF capacitor is required to cancel noise coupling between FB node and GND)"]
["Total Capacitor at Feedback Node ","Cp",{"$f":"C47+C48","v":1214.1941282883076},"pF"]
["First Pole of Compensator Due to R3 and C3","fp1",14.745471093213609,"kHz"]
["First Zero of Compensator Due to R2 and C1","fz1",610.35689827109832,"Hz"]
["Second Pole of Compensator Due to Rpullup and Cp","fp2",{"$f":"(1/(2*PI()*C26*10^3*C49*10^-12))*10^-3","v":2.1846443851646375},"kHz"]
["Second Zero of Compensator Due to (R1+R3) and C3","fz2",{"$f":"C52","v":2.1846443851646375},"kHz"]
["Upper Resistor(R1) Value of Resistor Divider to Make Vref","R1",100,"kΩ ","Enter the desired value of upper resistor R1 of the resistor divider(refer figure(1))"]
["Recommended Lower Resistor(Rlower) Value of Resistor Divider to Make Vref","Rlower(recom)",{"$f":"C54*C29/(Vout_max-C29)","v":6.666666666666667},"kΩ "]
["Actual Lower Resistor(Rlower) Value of Resistor Divider to Make Vref","Rlower",14.3,"kΩ ","Enter the actual value of lower resistor(Rlower) used in resistor divider circuit(refer figure(1))"]
["Recommended Value of Resistor R2","R2(recom)",{"$f":"(C54*C30*C44)/(C27*C26)","v":203.64167437542505},"kΩ "]
["Actual Value of Resistor R2","R2",49.9,"kΩ ","Enter the actual value of resistor R2 used (refer figure (1)); select approx. same value as the recommended value"]
["Recommended Value of Capacitor C1","C1(recom)",{"$f":"(1/(2*PI()*C51*C58*10^3))*10^9","v":5.2255947733324426},"nF"]
["Actual Value of Capacitor C1","C1",22,"nF","Enter the actual value of capacitor C1 used (refer figure (1)); select higher value than the recommended value"]
["Pole at Origin Due to R1 and C1","fp0",{"$f":"(1/(2*PI()*C60*10^-9*C54*10^3))","v":72.343155950861529},"Hz"]
["Recommended Value of Resistor R3","R3(recom)",{"$f":"C54*(C53/(C50-C53))","v":17.392520699013534},"kΩ "]
["Actual Value of Resistor R3","R3",2,"kΩ ","Enter the actual value of resistor R3 used (refer figure (1)); select lower value than the recommended value"]
["Recommended Value of Capacitor C3","C3(recom)",{"$f":"(1/(2*PI()*C52*10^3*(C54+C63)*10^3))*10^12","v":714.2318401695926},"pF"]
["Actual Value of Capacitor C3","C3",1000,"pF","Enter the actual value of capacitor C3 used (refer figure (1))"]
[]
["Final values of poles and zero of Compensator"]
["Pole at Origin Due to R1 and C1","fp0",{"$f":"C61","v":72.343155950861529},"Hz","Warning! If cells become red, please readjust compensator values entered above to have optimised values."]
["First Zero of Compensator Due to R2 and C1","fz1",{"$f":"(1/(2*PI()*C58*10^3*C60*10^-9))","v":144.97626443058422},"Hz"]
["Second Zero of Compensator Due to (R1+R3) and C3","fz2",{"$f":"(1/(2*PI()*(C54+C63)*10^3*C65*10^-12))*10^-3","v":1.5603425793323076},"kHz"]
["Second Pole of compensator Due to Rpullup and Cp","fp2",{"$f":"C52","v":2.1846443851646375},"kHz"]
["First Pole of Compensator Due to R3 and C3","fp1",{"$f":"(1/(2*PI()*C63*10^3*C65*10^-12))*10^-3","v":79.577471545947674},"kHz"]

{"sheet":"Device Pin Programming","index":2,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[[3,0,3,4],[7,0,7,4],[13,0,13,4],[18,0,18,4],[0,0,0,4],[1,0,1,4]]}
["UCG2882x Device Pin Programming Sheet"]
[]
["Controller Pin Discription"]
[]
["TR pin programming resistor setting"]
["Selected TR value","TR",{"$f":"TR","v":6}]
["TR pin resistor value","Rtr",{"$f":"INDEX(Data!F5:F20,MATCH(C6,Data!G5:G20,0))","v":5.23},"kΩ "]
[]
["IPK pin programming resistor setting"]
["Peak current setting of the device ","Ipk_set",{"$f":"Ipk_set","v":3.1},"A"]
["Division ratio [Imax/Imin]","Imax/Imin",3,null,"Select desired Imax/Imin value; refer datasheet"]
["EMI dithering depth (%)","EMI",12.5,"%","Select desired EMI dethering settings; refer datasheet"]
["IPK pin resistor value","Ripk",{"$f":"INDEX(Data!I5:I16,MATCH(1,(Data!J5:J16=C10)*(Data!K5:K16=C11)*(Data!L5:L16=C12),0))","v":11.5},"kΩ "]
[]
["FCL pin programming resistor setting"]
["Frequency clamp","Fclamp",{"$f":"Fclamp","v":140},"kHz"]
["Fault response",null,"EXTOTP Fault and OVP Latched, rest auto retry",null,"Select desired fault setting; refer datasheet"]
["FCL pin resistor value","Rfcl",{"$f":"INDEX(Data!N5:N16,MATCH(1,(Data!O5:O16=C16)*(Data!P5:P16=C17),0))","v":28.7},"kΩ "]
[]
["CDX pin programming resistor setting"]
["Select CCM setting","CCM","Enabled",null,"Select desired CCM setting; refer datasheet"]
["Select SW node turn-on slew rate",null,7,"V/ns","Select desired SW Node Turn-On Slew Rate; refer datasheet"]
["Select X-cap discharge setting",null,"Enabled",null,"Select desired X-cap discharge setting; refer datasheet"]
["CDX pin resistor value","Rcdx",{"$f":"INDEX(Data!R5:R16,MATCH(1,(Data!S5:S16=C21)*(Data!T5:T16=C22)*(Data!U5:U16=C23),0))","v":22.6},"kΩ "]

{"sheet":"Schematics","index":3,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,0,29,19],[30,0,31,19]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Please go to \"Power Circuit Design\" and \"Controller Circuit Design\" sheets for calculations!"]
[]
[]
[null,"UCG28824?",{"$f":"IF(Device=\"UCG28824-1\",\"1\",\"0\")","v":"0"}]
[null,"Shape Visible?",{"$f":"IF(Device=\"UCG28828-1\", \"1\",IF(Device=\"UCG28828-2\",\"1\", \"0\"))","v":"0"}]
[null,"Rlower",{"$f":"'Compensator Circuit Design '!C56&\"kΩ\"","v":"14.3kΩ"}]
[null,"Cbulk/3",{"$f":"IF(Device=\"UCG28824-1\",Cbulk_recom/2&\"µF\",Cbulk_recom/3&\"µF\")","v":"20µF"}]
[null,"2Cbulk/3",{"$f":"IF(Device=\"UCG28824-1\",Cbulk_recom/2&\"µF\",2*Cbulk_recom/3&\"µF\")","v":"40µF"}]
[null,"Csn",{"$f":"ROUND(Csn_recom,2)& \"nF\"","v":"3.41nF"}]
[null,"Rsn",{"$f":"ROUND(Rsn_recom,2)& \"kΩ\"","v":"512.49kΩ"}]
[null,"Nps",{"$f":"Nps_sel&\":1\"","v":"6:1"}]
[null,"Cout",{"$f":"Cout_actual&\"µF\"","v":"820µF"}]
[null,"Rcdx",{"$f":"Rcdx&\"kΩ\"","v":"22.6kΩ"}]
[null,"Rfcl",{"$f":"Rfcl&\"kΩ\"","v":"28.7kΩ"}]
[null,"Ripk",{"$f":"Ripk&\"kΩ\"","v":"11.5kΩ"}]
[null,"Rtr",{"$f":"Rtr&\"kΩ\"","v":"5.23kΩ"}]
[null,"Cfb",{"$f":"'Compensator Circuit Design '!C48 &\"pF\"","v":"330pF"}]
[null,"Rled",{"$f":"ROUND('Compensator Circuit Design '!C40,2)&\"kΩ\"","v":"5kΩ"}]
[null,"Rbias",{"$f":"'Compensator Circuit Design '!C32&\"kΩ\"","v":"2kΩ"}]
[null,"C1",{"$f":"'Compensator Circuit Design '!C60&\"nF\"","v":"22nF"}]
[null,"R2",{"$f":"'Compensator Circuit Design '!C58&\"kΩ\"","v":"49.9kΩ"}]
[null,"R1",{"$f":"'Compensator Circuit Design '!C54&\"kΩ\"","v":"100kΩ"}]
[null,"R3",{"$f":"'Compensator Circuit Design '!C63&\"kΩ\"","v":"2kΩ"}]
[null,"C3",{"$f":"'Compensator Circuit Design '!C65&\"pF\"","v":"1000pF"}]

{"sheet":"Data","index":4,"n_rows":71,"n_cols":24,"rows_kept":71,"cut":false,"hidden":true,"merged":[[64,10,70,10],[57,10,63,10],[57,12,63,12],[64,12,70,12],[2,17,2,20],[23,17,23,23],[3,1,3,2],[2,8,2,11],[2,13,2,15],[2,5,2,6],[2,1,2,2],[23,5,23,7],[41,9,41,13],[10,1,10,2],[11,1,11,2],[41,5,41,7],[15,1,15,2],[16,1,16,2],[17,1,17,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[23,9,23,15]]}
[]
[]
[null,"Shunt regulators",null,null,null,"TR prog. resistor values",null,null,"IPK programming resistor values for UCG2882x ",null,null,null,null,"FCL pin programming resistor values",null,null,null,"CDX resistor programming setting"]
[null,"Voltage refrence",null,null,null,"TR pin resistor (kΩ)","Turns ratio",null,"IPK pin resistor (kΩ)","Maximum peak current (A)","Ipk_max/Ipk_min","EMI dithering depth(%)",null,"FCL pin resistor value (kΩ)","Frequency clamp","Fault response",null,"CDX pin resistor (kΩ)","CCM","SW node turn-on slew rate (V/ns)","X-cap discharge"]
[null,"TL431",2.5,null,null,5.23,6,null,5.23,{"$f":"INDEX(J26:P26,MATCH(Device,Data!J25:P25,0))","v":2.8},4,12.5,null,5.23,140,"Latched",null,5.23,"Disabled",10,"Enabled"]
[null,"TLV431",1.25,null,null,6.34,6.125,null,6.34,{"$f":"INDEX(J27:P27,MATCH(Device,Data!J25:P25,0))","v":3.1},4,12.5,null,6.34,100,"Latched",null,6.34,"Disabled",7,"Enabled"]
[null,null,null,null,null,7.68,6.25,null,7.68,{"$f":"INDEX(J28:P28,MATCH(Device,Data!J25:P25,0))","v":3.5},4,12.5,null,7.68,250,"Latched",null,7.68,"Disabled",5,"Enabled"]
[null,null,null,null,null,9.31,6.375,null,9.31,{"$f":"INDEX(J26:P26,MATCH(Device,Data!J25:P25,0))","v":2.8},3,12.5,null,9.31,500,"Latched",null,9.31,"Disabled",10,"Disabled"]
[null,null,null,null,null,11.3,6.5,null,11.5,{"$f":"INDEX(J27:P27,MATCH(Device,Data!J25:P25,0))","v":3.1},3,12.5,null,11.5,140,"All auto retry",null,11.5,"Disabled",7,"Disabled"]
[null,null,null,null,null,13.7,6.625,null,14.3,{"$f":"INDEX(J28:P28,MATCH(Device,Data!J25:P25,0))","v":3.5},3,12.5,null,28.7,140,"EXTOTP Fault and OVP Latched, rest auto retry",null,14.3,"Disabled",5,"Disabled"]
[null,"Device variants",null,null,null,16.899999999999999,6.75,null,17.8,{"$f":"INDEX(J26:P26,MATCH(Device,Data!J25:P25,0))","v":2.8},4,6.25,null,17.8,250,"All auto retry",null,17.8,"Enabled",10,"Enabled"]
[null,"UCG28824-1",null,null,null,20.5,6.875,null,22.6,{"$f":"INDEX(J27:P27,MATCH(Device,Data!J25:P25,0))","v":3.1},4,6.25,null,22.6,500,"All auto retry",null,22.6,"Enabled",7,"Enabled"]
[null,"UCG28826-1",null,null,null,25.5,7,null,28.7,{"$f":"INDEX(J28:P28,MATCH(Device,Data!J25:P25,0))","v":3.5},4,6.25,null,14.3,100,"All auto retry",null,28.7,"Enabled",5,"Enabled"]
[null,"UCG28826-3",null,null,null,31.6,7.125,null,36.5,{"$f":"INDEX(J26:P26,MATCH(Device,Data!J25:P25,0))","v":2.8},3,6.25,null,36.5,100,"EXTOTP Fault and OVP Latched, rest auto retry",null,36.5,"Enabled",10,"Disabled"]
[null,"UCG28826-4",null,null,null,39.200000000000003,7.25,null,51.1,{"$f":"INDEX(J27:P27,MATCH(Device,Data!J25:P25,0))","v":3.1},3,6.25,null,51.1,250,"EXTOTP Fault and OVP Latched, rest auto retry",null,51.1,"Enabled",7,"Disabled"]
[null,"UCG28826-5",null,null,null,51.1,7.375,null,75,{"$f":"INDEX(J28:P28,MATCH(Device,Data!J25:P25,0))","v":3.5},3,6.25,null,75,500,"EXTOTP Fault and OVP Latched, rest auto retry",null,75,"Enabled",5,"Disabled"]
[null,"UCG28828-1",null,null,null,66.5,7.5,null,"Note: Maximum peak current values changes with the device selected"]
[null,"UCG28828-2",null,null,null,84.5,7.625]
[null,null,null,null,null,113,7.75]
[null,null,null,null,null,174,7.875]
[]
[]
[]
[null,null,null,null,null,"Important design info",null,null,null,"UCG2882x peak current settings",null,null,null,null,null,null,null,"UCG2882x min and max inductor setting"]
[null,null,null,null,null,"Parameters","Values","Units",null,"UCG28824-1","UCG28826-1","UCG28826-3","UCG28826-4","UCG28826-5","UCG28828-1","UCG28828-2",null,"UCG28824-1","UCG28826-1","UCG28826-3","UCG28826-4","UCG28826-5","UCG28828-1","UCG28828-2"]
[null,null,null,null,null,"Tline_max",{"$f":"1000/fline_min","v":21.276595744680851},"ms",null,1.9,2.8,2.8,2.8,2.8,2.8,2.8,null,190,130,130,130,130,130,130]
[null,null,null,null,null,"Vbulk_min",{"$f":"INDEX(L58:L64,MATCH(Device,Data!J58:J64,0))","v":75},"V",null,2.1,3.1,3.1,3.1,3.1,3.1,3.1,null,550,400,400,400,400,400,400]
[null,null,null,null,null,"Vbulk_max",{"$f":"INDEX(L65:L71,MATCH(Device,Data!J65:J71,0))","v":373.3523804664971},"V",null,2.4,3.5,3.5,3.5,3.5,3.5,3.5]
[null,null,null,null,null,"Dmax",{"$f":"(Nps_sel*Vout_max)/(Vbulk_min+(Nps_sel*Vout_max))","v":0.61538461538461542}]
[null,null,null,null,null,"Fsw_actual_LLFL",{"$f":"(Vbulk_min*(Nps_sel*Vout_max)/(Vbulk_min+(Nps_sel*Vout_max))/(Ipk_max*Lm_actual*10^3))*10^6","v":75.375512061902612},"kHz"]
[null,null,null,null,null,"Cout_transient",{"$f":"((Pout_max/Vout_max*(((0.33/(fc))+10^-3/Fclamp)*10^6)*10^-6)/Over_Under_Shoot)*10^6","v":761.42857142857144},"uF"]
[null,null,null,null,null,"Cout_ripple",{"$f":"((Pout_max/Vout_max*Dmax)/(Vout_ripple*10^-3*Fsw_actual_LLFL*10^3))*10^6","v":132.66908212560381},"uF"]
[null,null,null,null,null,"Rload",{"$f":" Vout_max^2/Pout_max","v":6.1538461538461542},"Ohms"]
[null,null,null,null,null,"Lm",{"$f":"(Vbulk_min*Dmax/(Ipk_max*Fsw_desired_LLFL*10^3))*10^6","v":201.0013654984069},"µH"]
[null,null,null,null,null,"Lm_min_datasheet",{"$f":"IF( Device = R25, R26, V26)","v":130},"µH"]
[null,null,null,null,null,"Lm_max_datasheet",{"$f":"IF( Device =R25, R27, V27)","v":400},"µH"]
[null,null,null,null,null,"TR_calc",{"$f":"IF(Device=\"UCG28826-4\", Nps_recom*(Vovp)/16, Nps_recom*(Vovp)/25)","v":7.3323809766751449}]
[null,null,null,null,null,"Ipk_recom_calc",{"$f":"Ipk_max","v":3.0615942028985508},"A"]
[null,null,null,null,null,"Ipk_recom_calc1",{"$f":"_xlfn.XLOOKUP(G38, OFFSET(Data!$J$26:$J$28, 0, MATCH(Device, Data!$J$25:$P$25, 0)-1), OFFSET(Data!$J$26:$J$28, 0, MATCH(Device, Data!$J$25:$P$25, 0)-1), \"no\", 1)","v":3.1},"A"]
[null,null,null,null,null,"Ipk_recom",{"$f":"IF(Ipk_error=\"no\", 2.4, Ipk_error)","v":3.1},"A"]
[]
[null,null,null,null,null,"Cbulk parameter calculations",null,null,null,"Change in parameters for UCG2882x"]
[null,null,null,null,null,"Parameters","Values","Units",null,"Device","Parameters","Symbols/values","Units","Comments"]
[null,null,null,null,null,"Tdischarge",{"$f":"Tline/4+(Tline/(2*PI()))*ASIN((Vbulk_min_desired)/(SQRT(2)*Vin_min))","v":7.4529671816487104},"ms",null,"UCG28824-1","Minimum AC input voltage","Vin_min","Vac","Enter minimum ac input voltage "]
[null,null,null,null,null,"Tcharge",{"$f":"Tline/2-G44","v":3.1853306906917149},"ms",null,"UCG28826-1","Minimum AC input voltage","Vin_min","Vac","Enter minimum ac input voltage "]
[null,null,null,null,null,"Icbulk_pk",{"$f":"2*PI()*fline_min*Cbulk_recom*10^-6*SQRT(2)*Vin_min*COS(ASIN(Vbulk_min_desired/(SQRT(2)*Vin_min)))","v":1.8220872312430965},"A",null,"UCG28826-3","Minimum AC input voltage","Vin_min","Vac","Enter minimum ac input voltage "]
[null,null,null,null,null,"Iin_min",{"$f":"Pout_max/(efficiency*SQRT(2)*Vin_max)","v":0.18923723969501641},"A",null,"UCG28826-4","Minimum AC input voltage","Vin_min","Vac","Enter minimum ac input voltage "]
[null,null,null,null,null,"Iin_max",{"$f":"Pout_max/(efficiency*Vbulk_min_desired)","v":0.94202898550724634},"A",null,"UCG28826-5","Minimum AC input voltage","Vin_min","Vac","Enter minimum ac input voltage "]
[null,null,null,null,null,"Idbr_pk",{"$f":"G48+G46","v":2.7641162167503426},"A",null,"UCG28828-1","Minimum output voltage of the PFC","Vpfc_min","V","Enter the minimum output voltage of PFC"]
[null,null,null,null,null,"Sdiode",{"$f":"(Idbr_pk-Iin_min)/tcharge","v":0.80835530972646819},null,null,"UCG28828-2","Minimum output voltage of the PFC","Vpfc_min","V","Enter the minimum output voltage of PFC"]
[null,null,null,null,null,"Tdiode_conduction",{"$f":"(Idbr_pk/Sdiode)","v":3.4194322515004769},"ms",null,"UCG28824-1","Maximum AC input voltage","Vin_max","Vac","Enter maximum ac input voltage"]
[null,null,null,null,null,"Iin_avg",{"$f":"Idbr_pk*Tdiode_cond*10^-3*fline_min","v":0.4442302825072254},"A",null,"UCG28826-1","Maximum AC input voltage","Vin_max","Vac","Enter maximum ac input voltage"]
[null,null,null,null,null,"Icbulk_rms",{"$f":"Iin_avg*SQRT((2/(3*fline_min*Tdiode_cond*10^-3))-1)","v":0.78820188277079273},"A",null,"UCG28826-3","Maximum AC input voltage","Vin_max","Vac","Enter maximum ac input voltage"]
[null,null,null,null,null,"Cbulk/3",{"$f":"Cbulk_recom/3","v":20},"uF",null,"UCG2882-4","Maximum AC input voltage","Vin_max","Vac","Enter maximum ac input voltage"]
[null,null,null,null,null,"2*Cbulk/3",{"$f":"2*Cbulk_recom/3","v":40},"uF",null,"UCG2882-5","Maximum AC input voltage","Vin_max","Vac","Enter maximum ac input voltage"]
[null,null,null,null,null,"Note: Valid only for UCG28824/6",null,null,null,"UCG28828-1","Maximum output voltage of the PFC","Vpfc_max","V","Enter the maximum output voltage of PFC"]
[null,null,null,null,null,null,null,null,null,"UCG28828-2","Maximum output voltage of the PFC","Vpfc_max","V","Enter the maximum output voltage of PFC"]
[null,null,null,null,null,null,null,null,null,"UCG28824-1","Vbulk_min",{"$f":"Vbulk_min_desired","v":75},"V"]
[null,null,null,null,null,null,null,null,null,"UCG28826-1",null,{"$f":"Vbulk_min_desired","v":75}]
[null,null,null,null,null,null,null,null,null,"UCG28826-3",null,{"$f":"Vbulk_min_desired","v":75}]
[null,null,null,null,null,null,null,null,null,"UCG28826-4",null,{"$f":"Vbulk_min_desired","v":75}]
[null,null,null,null,null,null,null,null,null,"UCG28826-5",null,{"$f":"Vbulk_min_desired","v":75}]
[null,null,null,null,null,null,null,null,null,"UCG28828-1",null,{"$f":"Vin_min","v":90}]
[null,null,null,null,null,null,null,null,null,"UCG28828-2",null,{"$f":"Vin_min","v":90}]
[null,null,null,null,null,null,null,null,null,"UCG28824-1","Vbulk_max",{"$f":"SQRT(2)*Vin_max","v":373.3523804664971},"V"]
[null,null,null,null,null,null,null,null,null,"UCG28826-1",null,{"$f":"SQRT(2)*Vin_max","v":373.3523804664971}]
[null,null,null,null,null,null,null,null,null,"UCG28826-3",null,{"$f":"SQRT(2)*Vin_max","v":373.3523804664971}]
[null,null,null,null,null,null,null,null,null,"UCG28826-4",null,{"$f":"SQRT(2)*Vin_max","v":373.3523804664971}]
[null,null,null,null,null,null,null,null,null,"UCG28826-5",null,{"$f":"SQRT(2)*Vin_max","v":373.3523804664971}]
[null,null,null,null,null,null,null,null,null,"UCG28828-1",null,{"$f":"Vin_max","v":264}]
[null,null,null,null,null,null,null,null,null,"UCG28828-2",null,{"$f":"Vin_max","v":264}]

{"sheet":"Plant Transfer Function","index":5,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,1,1,4],[1,6,1,9],[6,12,6,13]]}
[]
[null,"Interpolation Data for UCG28824",null,null,null,null,"Interpolation Data for UCG28826/28"]
[null,"Fsw (Hz)","Log(Fsw)","Gain (dB)","Phase (degrees)",null,"Fsw (Hz)","Log(Fsw)","Gain (dB)","Phase (degrees)"]
[null,100,{"$f":"LOG10(B4)","v":2},32,110,null,100,{"$f":"LOG10(G4)","v":2},32,110]
[null,200,{"$f":"LOG10(B5)","v":2.3010299956639813},25,80,null,200,{"$f":"LOG10(G5)","v":2.3010299956639813},25,80]
[null,{"$f":"B5+100","v":300},2.4771212547196626,21,67,null,{"$f":"G5+100","v":300},2.4771212547196626,21,67]
[null,{"$f":"B6+100","v":400},2.6020599913279625,17,63,null,{"$f":"G6+100","v":400},2.6020599913279625,17,63,null,null,"Estimated Values"]
[null,500,2.6989700043360187,14,60,null,500,2.6989700043360187,14,60,null,null,"Fsw",550]
[null,600,2.7781512503836434,12,56,null,600,2.7781512503836434,12,56,null,null,"Gain ",{"$f":"-3.799*LOG10(N8)^2-8.0542*LOG10(N8)+63.643","v":13.042647268051368}]
[null,700,2.8450980400142569,10,53,null,700,2.8450980400142569,10,53,null,null,"Phase ",{"$f":" 28.622*LOG10(N8)^4 - 345.22*LOG10(N8)^3 + 1550.4*LOG10(N8)^2 - 3116.9*LOG10(N8) + 2446","v":57.254400195383823}]
[null,800,2.9030899869919438,8.5,51,null,800,2.9030899869919438,8.5,51]
[null,900,2.9542425094393248,7,48,null,900,2.9542425094393248,7,48]
[null,1000,3,5,46,null,1000,3,5,46]
[null,{"$f":"B13+1000","v":2000},3.3010299956639813,-5,30,null,{"$f":"G13+1000","v":2000},3.3010299956639813,-5,30]
[null,{"$f":"B14+1000","v":3000},3.4771212547196626,-11,25,null,{"$f":"G14+1000","v":3000},3.4771212547196626,-11,25]
[null,4000,3.6020599913279625,-14.5,20,null,4000,3.6020599913279625,-14.5,20]
[null,5000,3.6989700043360187,-17.5,15,null,5000,3.6989700043360187,-17.5,15]