{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["InputSheet","DeviceCalculator","Sheet1","partData","Layout Checklist","Schematic Checklist","revisionNotes","Disclaimer","DeviceCalculator_old","Std. R and C Values","Extra"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":284,"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":"InputSheet","index":0,"n_rows":61,"n_cols":7,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Parameter","Units","Type","Default","*selected*","end"]
["Rail Name",null,"Req",null,"tes"]
["Part Number",null,"Req",null,"TPSM843B22"]
["Vin_min","V","Opt","Vin_nom*0.8",10]
["Vin_nom","V","Req",null,12,null,"Sheet Descriptions:"]
["Vin_max","V","Opt","Vin_nom*1.1",13.2,null,"InputSheet = sheet with simplified input for checking component values with the macros described below"]
["Vout","V","Req",null,1.2,null,"DeviceCalculator = sheet where all calculations are done. This sheet can be used by itself to select or check component values."]
["Iout","A","Opt","Io_max_IC",12]
["dVo_trans",null,"Opt","Vout*0.05",2.4E-2,null,"Macro Directions:"]
["dVo_dc",null,"Opt","Vout*0.01",1.2E-2,null,"Check/Calculate Selected Column"]
["Io_step","A","Opt","Iout*0.5",6,null,"Select any cell in the column of the design you would like to check."]
["R_fsel",null,"Opt","R_fsel_rec",11.8,null,"Click on the Check/Calculate to send the input values to the DeviceCalculator worksheet."]
["fsw_select",null,"Calc",null,1000,null,"The calculated results on the DeviceCalculator worksheet are then pulled back to this sheet to check the component values used."]
["Isat",null,"Opt",null,20]
["Inductor_Part_Number",null,"Opt",null,"TBD"]
["Ipeak_max","A","Calc",null,14.066115702479339,null,"To delete a design that is no longer needed, right click on the column letter then select delete."]
["N_Cout_cer",null,"Opt",1,6]
["Cout_single_cer","mΩ","Opt","Cout_min",100,null,"Pull Values from DeviceCalculator Sheet"]
["Cer_derating",null,"Opt",0.8,0.8,null,"The DeviceCalculator worksheet has more details to aid in the design."]
["Cer_Voltage_Rating",null,"Opt",null,6.3]
["Ceramic_RMS_current ",null,"Opt",null,3]
["ESR_single_cer","µF","Opt",1,3,null,"Updates to the design can be mode in the DeviceCalculator sheet."]
["N_Cout_bulk",null,"Opt",0,0,null,"After making updates, click on Pull Values to use the values on the DeviceCalculator sheet and check them."]
["Cout_single_bulk","µF","Opt",0.1,0.1]
["ESR_single_bulk","mΩ","Opt",1,1,null,"Check/Calculate All Columns"]
["Bulk_Voltage_Rating"]
["Cout","µF","Calc",null,481,null,"This will run Check/Calculate Selected Column on all designs"]
["Vo_trans","mV","Calc",null,19.853007462437731]
["Vo_overshoot","mV","Calc",null,10.291060291060294,null,"Insert New Design"]
["Vo_ripple","mV","Calc",null,2.4698239511651496,null,"Click on Insert New Design to add another column to check another design."]
["Vi_ripple_perc",null,"Opt",0.04,0.04]
["Cin","µF","Opt","Cin_min",25.080000000000002]
["Cin_derating",null,"Opt",0.5,0.5]
["Cin_RMS_currentrating",null,"Opt",null,"="]
["Cin_Voltage_Rating",null,"Opt",null,"="]
["Vi_ripple","mV","Calc",null,39.542884257977768]
["Rfb_b","kΩ","Opt","Rfb_b_rec",8]
["Rfb_t","kΩ","Opt","Rfb_t_std",11.2]
["Vout_calc","V","Calc",null,1.2]
["Cff","pF","Opt","Cff_rec_std",100]
["Rff","kΩ","Opt","Rff_rec_std",0]
["R_msel","kΩ","Opt","R_msel_rec",102]
["I_lim_sel",null,"Calc",null,"Low"]
["Ramp_sel","pF","Calc",null,2]
["SS_sel","ms","Calc",null,8]
["Ren_t","kΩ","Opt",0,0]
["Ren_b","kΩ","Opt",{"$f":"10^4","v":10000},10000]
["Vstart_typ","V","Calc",null,1.2]
["Vstop_typ","V","Calc",null,1.1000000000000001]
["Cbp","µF","Opt","Cbp_rec",2.2000000000000002]
["Cboot","µF","Opt","Cboot_rec",0.1]
["Rboot","Ω","Opt","Rboot_rec",0]
["Rpg","kΩ","Opt","Rpg_rec",100]
["Rfsel_check",null,"Check",null,"Pass"]
["Lout_check",null,"Check",null,"Pass"]
["Cout_check",null,"Check",null,"Pass"]
["Cin_check",null,"Check",null,"Pass"]
["FB_network_check",null,"Check",null,"Caution: If not already included, recommend adding a 0-Ohm placeholder for Rff. This can help improve load regulation in case of non-ideal AGND to PGND connection in the PCB layout. Based on input Rfb_t, suggested value is 0.56kOhm."]
["Rmsel_check",null,"Check",null,"Pass"]
["EN_divider_check",null,"Check",null,"Pass"]
["Cbp_Cboot_Rpg_check",null,"Check",null,"Warning: Change Cbp. Value is not within 1 µF to 4.7 µF recommended range.\r\n\r\nCaution: Suggest including a 0Ohm Rboot in the schematic for prototype designs. A 2.2Ohm resistor can reduce SW node voltage overshoot. This is optional."]

{"sheet":"DeviceCalculator","index":1,"n_rows":222,"n_cols":10,"rows_kept":222,"cut":false,"hidden":false,"merged":[[60,1,60,7],[194,1,194,7],[209,1,209,7],[73,1,73,7],[141,1,141,7],[148,1,148,7],[153,1,153,7],[154,1,154,7],[168,1,168,7],[72,1,72,7],[0,1,0,7],[1,1,6,1],[1,2,6,2],[1,3,6,3],[1,4,6,4],[1,5,6,5],[1,6,6,6],[1,7,6,7],[7,1,7,7],[26,1,26,7],[34,1,34,7],[43,1,43,7],[44,1,44,7]]}
[null,"Design Calculations",null,null,null,null,null,null,null,"Key"]
[null,"Parameter","Input","Recommended","Selected Value","Calculated with Selected Value","Units","Description",null,"User Entered Value"]
[null,null,null,null,null,null,null,null,null,"Fixed IC Parameter"]
[null,null,null,null,null,null,null,null,null,"Calculated Parameter"]
[null,null,null,null,null,null,null,null,null,"Recommended Component Value"]
[null,null,null,null,null,null,null,null,null,"Design Caution"]
[null,null,null,null,null,null,null,null,null,"Design Warning"]
[null,"Choose Device"]
[null,"Part number","TPSM843B22",null,null,null,null,"Select IC part number"]
[null,"Vin_min_IC",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,2,FALSE)","v":4},null,null,null,"V","IC rated minimum input voltage"]
[null,"Vin_max_IC",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,3,FALSE)","v":18},null,null,null,"V","IC rated maximum input voltage"]
[null,"Vref",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,9,FALSE)","v":0.5},null,null,null,"V","Internal voltage reference"]
[null,"Io_max_IC",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,4,FALSE)","v":20},null,null,null,"A","IC rated maximum output current"]
[null,"EN_rise",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,12,FALSE)","v":1.2},null,null,null,"V","EN rising voltage threshold"]
[null,"EN_rise_max",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,17,FALSE)","v":1.25},null,null,null,"V","EN rising voltage threshold (maximum spec)"]
[null,"EN_fall",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,13,FALSE)","v":1.1000000000000001},null,null,null,"V","EN falling voltage threshold"]
[null,"Ip ",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,14,FALSE)","v":1.5E-6},null,null,null,"A","EN pull up current "]
[null,"Ip2",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,15,FALSE)","v":1.1600000000000001E-5},null,null,null,"A","EN pul up + hystersis current"]
[null,"Ih",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,16,FALSE)","v":1.01E-5},null,null,null,"A","EN hystersis current"]
[null,"OC_high_min",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,5,FALSE)","v":26.1},null,null,null,"A","Minimum peak current limit for High current limits"]
[null,"OC_low_min",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,6,FALSE)","v":20.7},null,null,null,"A","Minimum peak current limit for Low current limits"]
[null,"ton_min_max",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,7,FALSE)","v":40},null,null,null,"ns","Worst case minimum on-time"]
[null,"toff_min_max",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,8,FALSE)","v":140},null,null,null,"ns","Worst case minimum off-time"]
[null,"Vout Maximum",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,20,FALSE)","v":7}]
[null,"Rdson_HS",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,10,FALSE)","v":6.5},null,null,null,"mΩ","High-side FET Rdson"]
[null,"Rdson_LS",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,11,FALSE)","v":2},null,null,null,"mΩ","Low-side FET Rdson"]
[null,"Input System Parameters"]
[null,"Vin_min",10,null,null,null,"V","Minimum input voltage"]
[null,"Vin_nom",12,null,null,null,"V","Nominal input voltage"]
[null,"Vin_nom",12,null,null,null,"V","Nominal input voltage"]
[null,"Vin_max",13.2,null,null,null,"V","Maximum input voltage"]
[null,"Vout",1.2,null,null,null,"V","Output voltage"]
[null,"Iout",12,null,null,null,"A","Maximum output current"]
[null,"E12 Resistor Values?","No",null,null,null,null,"If using E12 resistor values, tolerance still must be 1%"]
[null,"Select the Switching Frequency (FSEL pin)"]
[null,"fsw_typ_ton",null,{"$f":"IF((1/(ton_min_max*10^-9))*(Vout)/(Vin_max)*1/1>=2.2*10^6,2.2*10^6,(1/(ton_min_max*10^-9))*(Vout)/(Vin_max)*1/1)*10^-3","v":2200},null,null,"kHz","Maximum fsw limited by Vin_max and minimum on-time"]
[null,"fsw_max_ton",null,{"$f":"IF((1/(ton_min_max*10^-9))*(Vout)/(Vin_max)*1/1.1>=2.2*10^6,2.2*10^6,(1/(ton_min_max*10^-9))*(Vout)/(Vin_max)*1/1.1)*10^-3","v":2066.1157024793392},null,null,"kHz","Maximum fsw limited by Vin_max and minimum on-time"]
[null,"fsw_max_toff",null,{"$f":"IF((Vin_min-Vout-Iout*2*(DCR_Ohm+Rdson_HS_Ohm))/(toff_min_max_sec*(Vin_min-Iout*2*(Rdson_HS_Ohm-Rdson_LS_Ohm)))*10^-3>=2200,2200,(Vin_min-Vout-Iout*2*(DCR_Ohm+Rdson_HS_Ohm))/(toff_min_max_sec*(Vin_min-Iout*2*(Rdson_HS_Ohm-Rdson_LS_Ohm)))*10^-3)","v":2200},null,null,"kHz","Maximum fsw allowed limited by Vin_min and minimum off-time (Depends on inductor DCR and includes 2x multiplier on resistance for margin, if red check input voltage levels)"]
[null,"fsw_rec",null,{"$f":"MIN(1000,VLOOKUP(TRUE,partData!K22:L26,2,FALSE))","v":1000},null,null,"kHz","Recommended max fsw setting"]
[null,"fsw_input",1000,null,null,null,"kHz","Select the fsw option"]
[null,"R_fsel_rec",null,{"$f":"IF(C34=\"No\", VLOOKUP(C40,partData!E21:G26,2,0), VLOOKUP(C40,partData!E21:G26,3,0))","v":11.8},null,null,"kΩ","Recommended FSEL resistor for selected fsw"]
[null,"R_fsel",null,null,11.8,null,"kΩ","Selected FSEL resistor value"]
[null,"fsw_select",null,null,null,{"$f":"IF(OR(partData!J22:J26),VLOOKUP(TRUE,partData!J22:L26,3,FALSE),\"Invalid R_fsel\")","v":1000},"kHz","fsw with selected FSEL resistor (if red check input voltages)"]
[null,"Choose the Output Inductor (Lout)"]
[null,"The inductance is selected based on a p-p ripple current target. Smaller L reduces solution size while larger L reduces AC loss."]
[null,"Kind",0.3,null,null,null,null,"Target ripple/Iout ratio (typically between 0.2 to 0.4)"]
[null,"L_target",null,{"$f":"(1/(Kind*Iout*(fsw_select/1000))*(((Vin_max-Vout)*Vout)/Vin_max))","v":0.30303030303030304},null,null,"µH","Target inductor value"]
[null,"L_min",null,{"$f":"((Vin_max-Vout)*Vout)/(Io_max_IC*0.5*Vin_max*fsw_select)*1000","v":0.10909090909090909},null,null,"µH","Minimum recommended inductance (ripple = 50% Iout_max_IC)"]
[null,"L_max",null,{"$f":"((Vin_max-Vout)*Vout)/(Io_max_IC*0.05*Vin_max*fsw_select)*1000","v":1.0909090909090908},null,null,"µH","Maximum recommended inductance (ripple = 5% Iout_max_IC)"]
[null,"L_rec",null,{"$f":"MIN(MAX(D48,D47),D49)","v":0.30303030303030304},null,null,"µH","Recommended inductor value"]
[null,"Lout",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,21,FALSE)","v":0.33},{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,21,FALSE)","v":0.33},null,null,"µH","Selected inductance"]
[null,"DCR",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,22,FALSE)","v":3.2},{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,22,FALSE)","v":3.2},null,null,"mΩ","DC resistance of selected inductor"]
[null,"Tol_L",{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,23,FALSE)","v":0.2},{"$f":"VLOOKUP($C$9,partData!$A$3:$AAA$17,23,FALSE)","v":0.2},null,null,null,"Tolerance of inductance for selected inductor"]
[null,"Isat",null,null,20,null,null,"Inductor Saturation Current"]
[null,"Inductor_Part_Number",null,null,"TBD",null,null,"Inductor Part Number"]
[null,"Iripple_max",null,null,null,{"$f":"1000*((Vin_max-Vout)*Vout)/(Lout*(1-Tol_L)*Vin_max*fsw_select)","v":4.1322314049586772},"A","Inductor ripple current at Vin_max (includes Tol_L, used for DC ripple calculations) (Red if >50% of Iout rate)"]
[null,"Ipeak_max",null,null,null,{"$f":"Iout+(Iripple_max/2)","v":14.066115702479339},"A","Full load peak current at Vin_max"]
[null,"Irms",null,null,null,{"$f":"SQRT(Iout^2+Iripple_max^2)","v":12.691545862664908},"A","Inductor rms current at Vin_max"]
[null,"Iripple_min",null,null,null,{"$f":"1000*((Vin_min-Vout)*Vout)/(D51*(1+D53)*Vin_min*fsw_select)","v":2.6666666666666665},null,"Inductor ripple current at Vin_min (includes Tol_L)"]
[null,"Ivalley",null,null,null,{"$f":"Iout-(Iripple_min/2)","v":10.666666666666666},"A","Full load valley current at Vin_min (used for I_lim calculations)"]
[null,"Select the Soft Start Time, Current Limit and Ramp (MSEL pin)"]
[null,"I_lim_rec",null,{"$f":"IF(F57>OC_low_min, \"High\", \"Low\")","v":"Low"},null,null,null,"Recommended Ilim selection"]
[null,"I_lim_tgt","Low",null,null,null,null,"Target Ilim"]
[null,"fsw_div_fLC",null,{"$f":"IF(f_ESR_bulk>fsw_select/10,fsw_select/f_LC,fsw_select/(1/(2*PI()*SQRT(Lout_H*Cout_cer_eff_F))*10^-3))","v":79.160654534558091},null,null,null,"Used to set ramp recommendation"]
[null,"Ramp_tgt",2,null,null,null,"pF","Target ramp"]
[null,"Soft_start_time_tgt",8,null,null,null,"ms","Target soft start time"]
[null,"R_msel_rec",null,{"$f":"IF(C34=\"No\", VLOOKUP(CONCATENATE(C63, C65, C66),partData!N19:T44, 6, 0), VLOOKUP(CONCATENATE(C63, C65, C66),partData!N19:T44, 7, 0))","v":102},null,null,"kΩ","Recommended MSEL pin resistance value"]
[null,"Ramp_rec",null,{"$f":"partData!E37","v":2},null,null,"pF","Recommended ramp selection from Choose the Output Capacitor (Cout)section"]
[null,"R_msel",null,null,102,null,"kΩ","Selected MSEL pin resistance value"]
[null,"I_lim_sel",null,null,null,{"$f":"IF(partData!Z$44,VLOOKUP(TRUE,partData!Z19:AC43,2,FALSE),\"Invalid Rmsel\")","v":"Low"},null,"Selected Ilim"]
[null,"Ramp_sel",null,null,null,{"$f":"IF(partData!Z$44,VLOOKUP(TRUE,partData!Z19:AC43,3,FALSE),\"Invalid Rmsel\")","v":2},"pF","Selected ramp"]
[null,"SS_sel",null,null,null,{"$f":"IF(partData!Z$44,VLOOKUP(TRUE,partData!Z19:AC43,4,FALSE),\"Invalid Rmsel\")","v":8},"ms","Selected soft start time"]
[null,"Choose the Output Capacitor (Cout)"]
[null,"The output capacitance is deteremind based on the output ripple, transient and stability requirements. These calculations do not support mixed type output capacitors."]
[null,"Io_step",6,null,null,null,"A","Iout load transient step"]
[null,"dVo_perc  transient (%)",5,null,null,null,"%","dVo percent"]
[null,"dVo_trans",null,2.4E-2,null,null,"V","Target Vout overshoot/undershoot after load step"]
[]
[null,"Vo ripple (%)",1,null,null,null,null,"% Steady State Ripple"]
[null,"dVo_dc",null,1.2E-2,null,null,"V","Target steady state Vout voltage ripple"]
[]
[null,"Icorms",null,{"$f":"(1/(12)^0.5)*(12-1)/(12*Lout*10^-6*1000000)","v":0.80187537387448027},null,null,null,"Output Capacitor RMS Current "]
[null,"Cout Preferred",100,null,{"$f":"C83","v":100},null,"uF","Preferred Capacitor for Cout"]
[null,"Resr",1.425,{"$f":"1/(2*PI()*fco_desired*5*C83*10^-6*C86)","v":3.1830988618379071E-3},{"$f":"C84","v":1.425},null,"mOhm","ESR of single capacitor"]
[null,"Voltage Rating",6.3,null,{"$f":"C85","v":6.3},null,"V"]
[null,"Derating",0.8,null,{"$f":"C86","v":0.8},null,"%"]
[null,"Cramp (start)",2,null,null,null,"pF","Start with largest Cramp for highest bandwidth"]
[null,"tcramp()",null,null,null,{"$f":"C87*10^-12*10^6/(VLOOKUP(F43,partData!I50:L54,3,FALSE)-(VLOOKUP(fsw_select,partData!I50:L54,4,FALSE)*Vout/C30))*1","v":3.0321406913280775E-6}]
[null,"Vcramp  eq5",null,null,null,{"$f":"C30*((C32/C30)*(1/(F43*1000)+0.0000001)/F88)","v":0.43533599999999995},null,"keep ramp voltage less than 1.25V"]
[null,"Ramp_rec",null,{"$f":"partData!Q85","v":2},null,null,null,"Recommened Ramp value using Transient Method"]
[null,"Ramp_Selected",null,null,2]
[null,"tcramp()",null,null,null,{"$f":"E91*10^-12*10^6/(VLOOKUP(F43,partData!I50:L54,3,FALSE)-(VLOOKUP(fsw_select,partData!I50:L54,4,FALSE)*Vout/C30))*1","v":3.0321406913280775E-6}]
[null,"Vcramp  eq5",null,null,null,{"$f":"C30*((C32/C30)*(1/(F43*1000)+0.0000001)/F92)","v":0.43533599999999995},"V","keep ramp voltage less than 1.25V"]
[null,"Fco_desired","1/8",null,null,{"$f":"VLOOKUP(C94,partData!I59:J66,2,FALSE)*DeviceCalculator!fsw_Hz","v":125000},"Hz"," set to 1/8 to 1/4 of fsw"]
[null,"Fesrzero",null,{"$f":"1/(C83*C84*10^-3*C86*2*PI()*10^-6)","v":1396095.9920341696},null,{"$f":"1/(C83*C84*10^-3*C86*2*PI()*10^-6)","v":1396095.9920341696},"Hz","Fesr > 5*Fco desired (if red use lower esr capacitor)"]
[null,"Cout min ripple",null,{"$f":"VLOOKUP(D90,partData!B81:R83,6,FALSE)*10^6","v":171.38005358064825},null,{"$f":"VLOOKUP(E91,partData!B81:R83,6,FALSE)*10^6","v":171.38005358064825},"uF"]
[null,"Zout_Required",null,null,null,{"$f":"VLOOKUP(E91,partData!B81:R83,5,FALSE)*10^0","v":7.4293333333333338E-3},"Ohm","Required Output Impedance to meet the Transient Goal"]
[null,"Zout_Converter",null,{"$f":"VLOOKUP(D90,partData!B81:R83,5,FALSE)*10^0","v":7.4293333333333338E-3},null,null,"Ohm"]
[]
[null,"Cout_min eq11",null,{"$f":"VLOOKUP(D90,partData!B81:R83,6,FALSE)*10^6","v":171.38005358064825},null,{"$f":"VLOOKUP(E91,partData!B81:R83,6,FALSE)*10^6","v":171.38005358064825},"µF"]
[null,"Zcapacitor",null,{"$f":"C84*10^-3+1/(2*PI()*fco_desired*C86*C83*10^-6)","v":1.7340494309189537E-2},null,{"$f":"E84*10^-3+1/(2*PI()*fco_desired*E86*E83*10^-6)","v":1.7340494309189537E-2},"Ohm","Z for one capacitor"]
[null,"Ncap",null,{"$f":"ROUNDUP(D101/D98,0)","v":3},null,{"$f":"ROUNDUP(F101/F97,0)","v":3},"# of Cap"]
[null,"N_Cout_cer",null,6,5]
[null,"Cout_single_cer",null,100,100]
[null,"Cer_derating",null,0.8,0.8]
[null,"ESR_single_cer",null,3,3]
[null,"Ceramic_RMS_current ",null,3,3]
[null,"Cer_Voltage_Rating",null,6.3,6.3]
[null,"Cout_cer_eff trans design",null,null,null,{"$f":"E104*E103*E105","v":400}]
[null,"ESR_cer_eff trans design",null,null,null,{"$f":"E106/E103","v":0.6}]
[]
[]
[null,"Cout_ripple",null,{"$f":"Iripple_max/(8*(DeviceCalculator!Vout*C79/100)*fsw_Hz)*10^6","v":43.044077134986217},null,null,"µF","Min Cout for DC ripple requirement (ignores ESR)"]
[null,"Cout_trans",null,{"$f":"Io_step/(2*PI()*fsw_Hz/10*(DeviceCalculator!Vout*C76/100))*10^6","v":159.15494309189535},null,null,"µF","Min Cout for transient requirement assuming fco = fsw/10"]
[null,"Cout_overshoot",null,{"$f":"Lout*Io_step^2/(2*DeviceCalculator!Vout*(dVo_perc/100)*DeviceCalculator!Vout)","v":82.500000000000014},null,null,"µF","Min Cout for overshoot requirement based on inductor current slew rate"]
[null,"Cout_undershoot",null,{"$f":"(Lout_H*Io_step^2/(2*(Vin_min-Vout)*(D77)) + Io_step*(1-Vout/Vin_min)*1/fsw_Hz/(D77))*10^6","v":248.12500000000003},null,null,"µF","Min Cout for undershoot requirement based on inductor current slew rate"]
[null,"Cout_stability",null,{"$f":"(35/(2*PI()*fsw_Hz))^2*1/Lout_H*1000000","v":94.029128758987696},null,null,"µF","Min Cout for stability (f_LC < fsw/30)"]
[null,"Cout_min",{"$f":"(MAX(D113:D117,15))","v":248.12500000000003},{"$f":"(MAX(D113:D117,15))","v":248.12500000000003},null,null,"µF","Recommended min Cout (must include any derating due to DC/AC bias, temp and/or tolerance)"]
[null,"Cout_max",null,{"$f":"(150/(2*PI()*fsw_Hz))^2*1/Lout_H*1000000","v":1727.0656302671212},null,null,"µF","Max Cout for stability (f_LC > fsw/150) \n(Exceeding this is typically ok but validation of loop stability is highly recommended)"]
[null,"ESR_trans",null,{"$f":"D77/Io_step*1000","v":4},null,null,"mΩ","Max ESR to meet load step transient requirement"]
[null,"ESR_ripple",null,{"$f":"D80/Iripple_max*1000","v":2.9040000000000004},null,null,"mΩ","Max ESR to meet ripple requirement"]
[null,"ESR_max",null,{"$f":"MIN(D120:D121)","v":2.9040000000000004},null,null,"mΩ"]
[null,"N_Cout_cer",null,null,6,null,null,"Number of output capacitors"]
[null,"Cout_single_cer",null,null,100,null,"µF","Nominal value of single ceramic output capacitor"]
[null,"Cer_derating",null,null,0.8,null,null,"Remaining output capacitance after derating due to DC/AC bias, temp and/or tolerance"]
[null,"ESR_single_cer",null,null,3,null,"mΩ","ESR of output single ceramic output capacitor"]
[null,"Ceramic_RMS_current ",null,null,3,null,"A"]
[null,"Cer_Voltage_Rating",null,null,6.3,null,"V","Voltage Rating of Ceramic Capacitor "]
[null,"Cout_cer_eff",null,null,null,{"$f":"Cout_single_cer*N_Cout_cer*Cer_derating","v":480},"µF","Effective Cout (If red, not enough capacitance)"]
[null,"ESR_cer_eff",null,null,null,{"$f":"ESR_single_cer/N_Cout_cer","v":0.5},"mΩ","Effective ESR"]
[null,"N_Cout_bulk",null,null,0,null,null,"Number of Bulk Capacitors"]
[null,"Cout_single_bulk",null,null,0.1,null,"uF","Nominal value of a Single Bulk/Polymer/Electrolytic Output Capacitor"]
[null,"Bulk_derating",null,null,1,null,null,"Percentage of Nominal Bulk Capacitance remaining after tolerance, temperature, and/or lifetime"]
[null,"Bulk_Voltage_Rating",null,null,null,null,null,"Voltage Rating of Bulk Capacitor "]
[null,"ESR_single_bulk",null,null,1,null,"mΩ","Single Bulk Capacitor ESR"]
[null,"Cout_bulk_eff",null,null,null,1,"µF","Total Bulk Output Capacitance"]
[null,"ESR_bulk_eff",null,null,null,1,"mΩ","Effective Bulk Capacitance ESR"]
[null,"Cout",null,null,null,{"$f":"Cout_bulk_eff+Cout_cer_eff","v":481},"uF","Total Bulk + Ceramic Output Capacitance "]
[null,"f_LC",null,null,null,{"$f":"1/(2*PI()*SQRT(Lout_H*Cout_F))*0.001","v":12.632538296704501},"kHz","LC resonant frequency "]
[null,"fz_ESR_cer",null,null,null,{"$f":"IF(N_Cout_cer=0,10^6,1/(2*PI()*Cout_cer_eff_F*ESR_cer_eff_Ohm)*10^-3)","v":663.14559621623062},"kHz","Ceramic capacitor ESR zero frequency"]
[null,"fz_ESR_bulk",null,null,null,{"$f":"IF(N_Cout_bulk=0,10^6,1/(2*PI()*Cout_bulk_eff_F*ESR_bulk_eff_Ohm)*10^-3)","v":1000000},"kHz","Bulk capacitor ESR zero frequency \n(if yellow, ESR zero may limit loop bandwidth)"]
[null,"Transient response estimations with selected output caps"]
[null,"fco_est",null,{"$f":"fsw_select/10","v":100},null,null,"kHz","Loop bandwidth estimate of fsw_select/10"]
[null,"Zcer_fco",null,null,null,{"$f":"(1/(2*PI()*DeviceCalculator!fco_Hz*DeviceCalculator!Cout_cer_eff_F)*10^3)","v":3.3157279810811535},"mΩ","Estimated output cap impedance at fsw/10"]
[null,"Zbulk_fco",null,null,null,{"$f":"SQRT((1/(2*PI()*fco_Hz*Cout_bulk_eff_F))^2+ESR_bulk_eff_Ohm^2)*10^3","v":1591.5497450781882},"mΩ","Bulk capacitor impedance at fsw"]
[null,"Zcout_fco",null,null,null,{"$f":"Zcer_fco*Zbulk_fco/(Zcer_fco+Zbulk_fco)","v":3.3088345770729548},"mΩ","Combined output capacitor impedance at fsw"]
[null,"Vo_trans",null,null,null,{"$f":"Io_step*Zcout_fco","v":19.853007462437731},"mV","Estimated transient overshoot/undershoot based on loop bandwidth estimate"]
[null,"Vo_overshoot",null,null,null,{"$f":"(Lout_H*Io_step^2/(2*Vout*Cout_F))*1000","v":10.291060291060294},"mV","Estimated overshoot based on inductor current slew rate"]
[null,"DC output ripple estimations with selected output caps"]
[null,"Zcer_fsw",null,null,null,{"$f":"SQRT((1/(2*PI()*fsw_Hz*Cout_cer_eff_F))^2+ESR_cer_eff_Ohm^2)*10^3","v":0.59995043165685358},"mΩ","Ceramic capacitor impdance at fsw"]
[null,"Zbulk_fsw",null,null,null,{"$f":"SQRT((1/(2*PI()*fsw_Hz*Cout_bulk_eff_F))^2+ESR_bulk_eff_Ohm^2)*10^3","v":159.15808465354331},"mΩ","Bulk capacitor impedance at fsw"]
[null,"Zcout_fsw",null,null,null,{"$f":"Zcer_fsw*Zbulk_fsw/(Zcer_fsw+Zbulk_fsw)","v":0.59769739618196627},"mΩ","Combined output capacitor impedance at fsw"]
[null,"Vo_ripple",null,null,null,{"$f":"Iripple_max*Zcout_fsw","v":2.4698239511651496},"mV","Estimated capacitive + resistive DC ripple (ignores ESL)"]
[null,"Choose the Input Capacitor (Cin)"]
[null,"The input capacitance is deteremind based on the input ripple requirements. Additional bulk input capacitance may be needed for transients. 0.1µF high frequency bypass capacitors are also required."]
[null,"Vi_ripple_perc",0.04,null,null,null,null,"Target DC input voltage ripple percentage"]
[null,"Vi_ripple_rec",null,{"$f":"Vin_min*Vi_ripple_perc*1000","v":400},null,null,"mV","Recommended DC input voltage ripple (based on Vin_min)"]
[null,"Vi_ripple_target",{"$f":"D157","v":400},null,null,null,"mV","Target DC input voltage ripple"]
[null,"Cin_min",null,{"$f":"MAX(4.7,(Iout*0.25)/(Vi_ripple_target*fsw_select)*10^6)","v":7.5},null,null,"µF","Minimum input capacitance required (include derating)"]
[null,"N_Cin_Cer",2,{"$f":"ROUND(F168/C162,1)","v":1}]
[null,"Cin_Single_cer",33]
[null,"Cin_single_Irms",4,null,null,null,"A"]
[null,"Cin_cer_derating",0.38]
[null,"Cin",null,null,25.080000000000002,null,"µF","Effective input ceramic cap used (include derating)"]
[null,"Cin_RMS_currentrating",null,null,"="]
[null,"Cin_Voltage_Rating",null,null,"=",null,null,"Voltage Rating"]
[null,"Vi_ripple",null,null,null,{"$f":"(Iout*Vout/Vin_max*(1-Vout/Vin_max))/(Cin*fsw_select)*10^6","v":39.542884257977768},"mV","Input DC ripple"]
[null,"Iin_rms",null,null,null,{"$f":"Iout*SQRT(Vout/Vin_min*(Vin_min-Vout)/Vin_min)","v":3.8995384342252613},"A","Input RMS current"]
[null,"Determine feedback network values (FB resistor divider and Cff)"]
[null,"Rfb_b_rec",4.99,{"$f":"(IF((10^(LOG(C170)-INT(LOG(C170)))*100)-VLOOKUP((10^(LOG(C170)-INT(LOG(C170)))*100),E96_s:E96_f,1)<VLOOKUP((10^(LOG(C170)-INT(LOG(C170)))*100),E96_s:E96_f,2)-(10^(LOG(C170)-INT(LOG(C170)))*100),VLOOKUP((10^(LOG(C170)-INT(LOG(C170)))*100),E96_s:E96_f,1),VLOOKUP((10^(LOG(C170)-INT(LOG(C170)))*100),E96_s:E96_f,2)))*10^INT(LOG(C170))/100","v":4.99},null,null,"kΩ","Bottom feedback resistor (1k-20k recommended)"]
[null,"Rfb_b",null,null,8,null,"kΩ","Selected bottom feedback resistor"]
[null,"Rfb_t_target",null,{"$f":"Rfb_b*(Vout/Vref-1)","v":11.2},null,null,"kΩ","Calculated top resistor"]
[null,"Rfb_t_std",null,{"$f":"(IF((10^(LOG(D172)-INT(LOG(D172)))*100)-VLOOKUP((10^(LOG(D172)-INT(LOG(D172)))*100),E96_s:E96_f,1)<VLOOKUP((10^(LOG(D172)-INT(LOG(D172)))*100),E96_s:E96_f,2)-(10^(LOG(D172)-INT(LOG(D172)))*100),VLOOKUP((10^(LOG(D172)-INT(LOG(D172)))*100),E96_s:E96_f,1),VLOOKUP((10^(LOG(D172)-INT(LOG(D172)))*100),E96_s:E96_f,2)))*10^INT(LOG(D172))/100","v":11.3},null,null,"kΩ","Closest 1% standard resistor value"]
[null,"Rfb_t",null,null,11.2,null,"kΩ","Selected top resistor"]
[null,"Vout_calc",null,null,null,{"$f":"Vref*(1+Rfb_t/Rfb_b)","v":1.2},"V","Calculated Vout (yellow if not within 1% of target Vout)"]
[null,"Cff_rec",null,{"$f":"1/(2*PI()*(fsw_select/4)*Rfb_t)*1000000","v":56.841051104248344},null,null,"pF","Recommended feedforward cap value (fz_Cff = fsw/4)"]
[null,"Cff_rec_std",null,{"$f":"IF(Cff_rec<10000,VLOOKUP((10^(LOG(Cff_rec)-INT(LOG(Cff_rec)))),c_s1:C_f1,1),VLOOKUP((10^(LOG(Cff_rec)-INT(LOG(Cff_rec)))),C_s2:C_f2,1))*10^INT(LOG(Cff_rec))","v":56},null,null,"pF","Cpole recommended nearest standard value"]
[null,"Cff",null,null,100,null,"pF","Selected feedforward cap value"]
[null,"Rff_rec",null,{"$f":"Rfb_t/20","v":0.55999999999999994},null,null,"kΩ","Recommended feedforward resistor"]
[null,"Rff_rec_std",null,{"$f":"(IF((10^(LOG(D179)-INT(LOG(D179)))*100)-VLOOKUP((10^(LOG(D179)-INT(LOG(D179)))*100),E96_s:E96_f,1)<VLOOKUP((10^(LOG(D179)-INT(LOG(D179)))*100),E96_s:E96_f,2)-(10^(LOG(D179)-INT(LOG(D179)))*100),VLOOKUP((10^(LOG(D179)-INT(LOG(D179)))*100),E96_s:E96_f,1),VLOOKUP((10^(LOG(D179)-INT(LOG(D179)))*100),E96_s:E96_f,2)))*10^INT(LOG(D179))/100","v":0.56200000000000006},null,null,"kΩ","Selected feedforward resistor value"]
[null,"Rff",null,null,0,null,"kΩ","Selected feedforward resistor value"]
[null,"fz_cff",null,null,null,{"$f":"IF(Cff<>0,1/(2*PI()*Cff*0.000000001*(Rfb_t+Rff)*1000),\"N/A\")","v":142.10262776062083},"kHz","Frequency of zero added by the feedforward cap"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"EN pin resistor divider"]
[null,"Vstart",5,null,null,null,"V","UVLO startup voltage (Red if Vstart < 1.1*Vstop)"]
[null,"UVLO_stop_rec_max",null,{"$f":"Vstart/1.1","v":4.545454545454545},null,null,"V","Maximum recommended UVLO shutdown voltage. Limited by voltage hysteresis on EN pins."]
[null,"Vstop",4.5,null,null,null,"V","UVLO shutdown voltage (Red if Vstart < 1.1*Vstop)"]
[null,"Ren_t_rec",null,{"$f":"(DeviceCalculator!Vstart*(DeviceCalculator!EN_fall/DeviceCalculator!EN_rise)-DeviceCalculator!Vstop)/([0]!I_p1*(1-DeviceCalculator!EN_fall/DeviceCalculator!EN_rise)+[0]!I_h)/1000","v":8.149959250203807},null,null,"kΩ","Calculated top resistor"]
[null,"Ren_t_std",null,{"$f":"(IF((10^(LOG(D199)-INT(LOG(D199)))*100)-VLOOKUP((10^(LOG(D199)-INT(LOG(D199)))*100),E96_s:E96_f,1)<VLOOKUP((10^(LOG(D199)-INT(LOG(D199)))*100),E96_s:E96_f,2)-(10^(LOG(D199)-INT(LOG(D199)))*100),VLOOKUP((10^(LOG(D199)-INT(LOG(D199)))*100),E96_s:E96_f,1),VLOOKUP((10^(LOG(D199)-INT(LOG(D199)))*100),E96_s:E96_f,2)))*10^INT(LOG(D199))/100","v":8.06},null,null,"kΩ","Closest 1% standard resistor value"]
[null,"Ren_t",null,null,8.06,null,"kΩ","Selected bottom resistor"]
[null,"Ren_b_calc",null,{"$f":"(Ren_t*EN_fall)/((Vstop-EN_fall)+Ren_t*I_p2)/1000","v":2.5378589241264344},null,null,"kΩ","Calculated top resistor"]
[null,"Ren_b_std",null,{"$f":"(IF((10^(LOG(D202)-INT(LOG(D202)))*100)-VLOOKUP((10^(LOG(D202)-INT(LOG(D202)))*100),E96_s:E96_f,1)<VLOOKUP((10^(LOG(D202)-INT(LOG(D202)))*100),E96_s:E96_f,2)-(10^(LOG(D202)-INT(LOG(D202)))*100),VLOOKUP((10^(LOG(D202)-INT(LOG(D202)))*100),E96_s:E96_f,1),VLOOKUP((10^(LOG(D202)-INT(LOG(D202)))*100),E96_s:E96_f,2)))*10^INT(LOG(D202))/100","v":2.5499999999999998},null,null,"kΩ","Closest 1% standard resistor value"]
[null,"Ren_b",null,null,10000,null,"kΩ","Selected top resistor"]
[null,"Vstart_typ",null,null,null,{"$f":"EN_rise+Ren_t*(EN_rise-I_p1*Ren_b)/Ren_b","v":1.1888771999999999},"V","Estimated typical turn on voltage with selected resistors (Yellow if < Vin_min)"]
[null,"Vstart_max",null,null,null,{"$f":"EN_rise_max+Ren_t*(EN_rise_max-I_p1*Ren_b)/Ren_b","v":1.2389174999999999},"V","Estimated maximum turn on voltage with selected resistors (Yellow if < Vin_min)"]
[null,"Vstop_typ",null,null,null,{"$f":"EN_fall-(Ren_t*(I_p1*Ren_b-EN_fall+I_h*Ren_b))/Ren_b","v":1.0073906000000001},"V","Estimated typical turn off voltage with selected resistors"]
[null,"Vena max voltage",null,null,null,{"$f":"Vin_max*E204/(E201+E204)","v":13.18936936828916},"V","Max voltage with Ren_t and Ren_b and Vinmax"]
[null,"Pen_divider",null,null,null,{"$f":"Vin_max*Vin_max/(Ren_b+Ren_t)*1000","v":1.7409967566141688E-2},"mW","Power lost in EN divider at Vin_max"]
[null,"VCC bypass capacitor, BOOT bypass capacitor, PGOOD resistor"]
[null,"Cvdrv_rec",null,2.2000000000000002,null,null,"µF","At least 2.2 µF required from VDRV to PGND"]
[null,"Cvdrv",null,null,2.2000000000000002,null,"µF","Selected Cvdrv"]
[null,"Cvcc_rec",null,0.1,null,null,"µF","Use 0.1uF from VCC to AGND"]
[null,"Cvcc",null,null,0.1,null,"µF","Selected Cvcc"]
[null,"Rvcc_rec",null,10,null,null,"Ω","Use 10 Ohm from VDRV to VCC"]
[null,"Rvcc",null,null,10,null,"Ω","Selected Rvcc"]
[null,"Cboot_rec",null,0.1,null,null,"µF","At least 0.1µF required"]
[null,"Cboot",null,null,0.1,null,"µF","Selected Cboot"]
[null,"Rboot_rec",null,{"$f":"IF(AND(C9=\"TPS543820\",Vin_max>13.5),2.2,0)","v":0},null,null,"µF","Recommended series Rboot. Required for 8A device with Vin_max>13.5V"]
[null,"Rboot",null,null,0,null,"µF","Selected Rboot."]
[null,"Rpg_rec",null,100,null,null,"kΩ","10k-100k recommended"]
[null,"Rpg",null,null,100,null,"kΩ","Selected Rpg"]

{"sheet":"Sheet1","index":2,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"fsw","lookup1","lookup2"]
[null,null,null,null,null,null,null,null,null,null,500,0.372,0.29699999999999999]
[null,null,null,null,null,null,null,null,null,null,1000,0.71899999999999997,0.59399999999999997]
[]
[]
[null,null,null,null,"tcramp",{"$f":"F11*10^6/(F12-F13*F14/F15)","v":2.0125786163522009E-5}]
[null,null,null,null,"Cramp (F)",3.9999999999999999E-12]
[null,null,null,null,"lookup1",{"$f":"L6","v":0.372}]
[null,null,null,null,"lookup2",{"$f":"M6","v":0.29699999999999999}]
[null,null,null,null,"vout V",7]
[null,null,null,null,"vin V",12]
[]
[]
[null,null,null,null,"vcramp",{"$f":"F19*(F20+F21)/(F22)","v":0.75525000000000009}]
[null,null,null,null,{"$f":"E15","v":"vin V"},{"$f":"F15","v":12}]
[null,null,null,null,"ton s",{"$f":"(F14/F19)*(1/F24)","v":1.1666666666666668E-6}]
[null,null,null,null,"100ns as seconds",9.9999999999999995E-8]
[null,null,null,null,"tcramp",{"$f":"F10","v":2.0125786163522009E-5}]
[null,null,null,null,{"$f":"E11","v":"Cramp (F)"},{"$f":"F11","v":3.9999999999999999E-12}]
[null,null,null,null,"fsw Hz",500000]

{"sheet":"partData","index":3,"n_rows":103,"n_cols":33,"rows_kept":103,"cut":false,"hidden":true,"merged":[]}
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25]
["Part #","VIN_min","VIN_max","Io,rated","OC high min","OC low min","tonmin max","toffmin max","Vref","R_HS","R_LS","EN_rise","EN_fall","I_p1","I_p2","I_h","EN_rise_max","OC high valley","OC low_valley","VoutMax","Lout","DCR","Tol_L"]
["TPS543320",4,18,3,4,2.6,40,140,0.5,25,13.9,1.2,1.1000000000000001,1.5E-6,{"$f":"0.0000116","v":1.1600000000000001E-5},{"$f":"I_p2-I_p1","v":1.0100000000000002E-5},1.25,null,null,5.5]
["TPS543620",4,18,6,8.3699999999999992,4,40,140,0.5,25,6.5,1.2,1.1000000000000001,1.5E-6,{"$f":"0.0000116","v":1.1600000000000001E-5},{"$f":"I_p2-I_p1","v":1.0100000000000002E-5},1.25,null,null,5.5]
["TPS543820",4,18,8,11.25,8.3699999999999992,40,140,0.5,25,6.5,1.2,1.1000000000000001,1.5E-6,{"$f":"0.0000116","v":1.1600000000000001E-5},{"$f":"I_p2-I_p1","v":1.0100000000000002E-5},1.25,null,null,5.5]
["TPS543B25",4,18,25,32.4,26.1,40,140,0.5,6.5,2,1.2,1.1000000000000001,1.5E-6,1.1600000000000001E-5,1.01E-5,1.25,24.75,19.8,7]
["TPSM843B22",4,18,20,26.1,20.7,40,140,0.5,6.5,2,1.2,1.1000000000000001,1.5E-6,1.1600000000000001E-5,1.01E-5,1.25,21.15,16.739999999999998,7,0.33,3.2,0.2]
["TPSM843A26",4,18,16,20.7,16.2,40,140,0.5,6.5,2,1.2,1.1000000000000001,1.5E-6,1.1600000000000001E-5,1.01E-5,1.25,16.739999999999998,12.51,7,0.6,4.1100000000000003,0.2]
["TPSM843A22",4,18,12,15.75,10.35,40,140,0.5,6.5,2,1.2,1.1000000000000001,1.5E-6,1.1600000000000001E-5,1.01E-5,1.25,11.88,7.92,7,0.6,4.1100000000000003,0.2]
["TPS543B25T",4,18,25,32.4,26.1,40,140,0.5,6.5,2,1.2,1.1000000000000001,1.5E-6,1.1600000000000001E-5,1.01E-5,1.25,24.75,19.8,7]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"DeviceCalculator!R_msel","v":102}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TPS543820","Current Limit","Cramp","soft start"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Res to GND","E12 Series","Error","In range?","E12 Par","Error","In range?"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(O19, P19, Q19)","v":"High11"},{"$f":"AD$20","v":"High"},{"$f":"AE$20","v":1},{"$f":"AF$20","v":1},1,1.78,1.8,{"$f":"(T19-S19)/S19","v":1.1235955056179785E-2},{"$f":"IF(U19>0,AND($U$16>=S19,$U$16<=S19*(1+U19)),AND($U$16<=S19,$U$16>=S19*(1+U19)))","v":false},1.8,{"$f":"(W19-S19)/S19","v":1.1235955056179785E-2},{"$f":"IF(X19>0,AND($U$16>=S19,$U$16<=S19*(1+X19)),AND($U$16<=S19,$U$16>=S19*(1+X19)))","v":false},{"$f":"OR(V19,Y19)","v":false},{"$f":"O19","v":"High"},1,1,null,"ramp","ss",{"$f":"S19*(100+U19)","v":178.02}]
[null,null,null,null,"Frequency selection table",null,null,{"$f":"DeviceCalculator!R_fsel","v":11.8},null,null,null,null,null,"High12",{"$f":"AD$20","v":"High"},1,{"$f":"AF$21","v":2},2,2.21,2.2000000000000002,{"$f":"(T20-S20)/S20","v":-4.5248868778279576E-3},{"$f":"IF(U20>0,AND($U$16>=S20,$U$16<=S20*(1+U20)),AND($U$16<=S20,$U$16>=S20*(1+U20)))","v":false},2.2000000000000002,-4.5248868778279576E-3,false,{"$f":"OR(V20,Y20)","v":false},"High",1,2,"High",1,1]
[null,null,null,null,"Freq(kHz)","Res to GND","E12 Res to GND","Rfsel_min","Rfsel_max",null,{"$f":"MIN(DeviceCalculator!fsw_max_ton,DeviceCalculator!fsw_max_toff)","v":2066.1157024793392},null,null,"High14","High",1,{"$f":"AF$22","v":4},3,2.74,2.7,-1.4598540145985413E-2,false,2.7,-1.4598540145985413E-2,false,false,"High",1,4,"Low",2,2]
["Top Resistor: ","GND","\nConnect to GND",null,500,24.3,27,24,1000000,{"$f":"AND($H$20>=H22,$H$20<=I22)","v":false},{"$f":"K$21<L23","v":false},{"$f":"E22","v":500},null,"High18","High",1,{"$f":"AF$23","v":8},4,3.32,3.3,-6.0240963855421742E-3,false,3.3,-6.0240963855421742E-3,false,false,"High",1,8,null,4,4]
["\nBottom Resistor: ","PGOOD","\nConnect to PGOOD",null,750,17.399999999999999,18,17.399999999999999,18,{"$f":"AND($H$20>=H23,$H$20<=I23)","v":false},{"$f":"K$21<L24","v":false},{"$f":"E23","v":750},null,"High21","High",{"$f":"AE$21","v":2},{"$f":"AF$20","v":1},5,4.0199999999999996,4,-4.9751243781093468E-3,false,4,-4.9751243781093468E-3,false,false,"High",2,1,null,null,8]
[{"$f":"CONCATENATE(A22, DeviceCalculator!D130)","v":"Top Resistor: "},"VREG","\nConnect to VREG",null,1000,11.8,12,11.8,12.1,true,{"$f":"K$21<L25","v":false},1000,null,"High22","High",{"$f":"AE$21","v":2},{"$f":"AF$21","v":2},6,4.87,4.9000000000000004,6.1601642710472785E-3,false,{"$f":"8.2*12/(8.2+12)","v":4.8712871287128712},2.6429747697557826E-4,false,false,"High",2,2]
[{"$f":"CONCATENATE(A23, DeviceCalculator_old!D116)","v":"\nBottom Resistor: 4.99"},"Open","\nLeave Floating",null,1500,8.06,8.1999999999999993,8.06,8.25,false,{"$f":"K$21<L26","v":true},1500,null,"High24","High",{"$f":"AE$21","v":2},{"$f":"AF$22","v":4},7,5.9,5.9,0,false,{"$f":"T25","v":5.9},0,false,false,"High",2,4]
[null,null,null,null,2200,4.99,4.7,4.99,5.1100000000000003,false,{"$f":"K21=L26","v":false},2200,null,"High28","High",2,{"$f":"AF$23","v":8},8,7.32,7.2,-1.6393442622950834E-2,false,7.32,0,false,false,"High",2,8]
[null,null,null,null,null,null,null,null,null,{"$f":"AND(J22:J26)","v":false},null,null,null,"High41","High",{"$f":"AE$22","v":4},{"$f":"AF$20","v":1},9,9.09,9,-9.9009900990098855E-3,false,9.09,0,false,false,"High",4,1]
[null,null,null,null,null,null,"Recommended fsw",null,null,null,null,null,null,"High42","High",{"$f":"AE$22","v":4},{"$f":"AF$21","v":2},10,11.3,11.2,-8.8495575221240186E-3,false,11.25,-4.4247787610620093E-3,{"$f":"IF(X28>0,AND($U$16>=S28,$U$16<=S28*(1+X28)),AND($U$16<=S28,$U$16>=S28*(1+X28)))","v":false},false,"High",4,2]
[null,null,null,null,null,null,null,null,null,0.5,null,null,null,"High44","High",{"$f":"AE$22","v":4},{"$f":"AF$22","v":4},11,14.3,14.2,-6.9930069930070919E-3,false,14.23,-4.8951048951049146E-3,{"$f":"IF(X29>0,AND($U$16>=S29,$U$16<=S29*(1+X29)),AND($U$16<=S29,$U$16>=S29*(1+X29)))","v":false},false,"High",4,4]
[null,null,null,null,null,null,null,null,null,0.75,null,null,null,"High48","High",{"$f":"AE$22","v":4},{"$f":"AF$23","v":8},12,18.2,18,-1.098901098901095E-2,false,18,-1.098901098901095E-2,false,false,"High",4,8]
[null,null,null,null,null,null,null,null,null,1,null,null,null,"Low11",{"$f":"AD$21","v":"Low"},{"$f":"AE$20","v":1},{"$f":"AF$20","v":1},13,22.1,22.1,0,false,22.04,-2.7149321266969353E-3,false,false,"Low",1,1]
[null,null,null,null,null,null,null,null,null,1.5,null,null,null,"Low12","Low",{"$f":"AE$20","v":1},{"$f":"AF$21","v":2},14,26.7,27,1.1235955056179803E-2,false,27,1.1235955056179803E-2,false,false,"Low",1,2]
[null,null,null,"Original calculation","Calculation with added margin",null,null,null,null,2,null,null,null,"Low14","Low",{"$f":"AE$20","v":1},{"$f":"AF$22","v":4},15,33.200000000000003,33.18,-6.0240963855431103E-4,false,33.130000000000003,-2.1084337349397673E-3,false,false,"Low",1,4]
["Ramp4","y=-0.075x+6.4",null,{"$f":"-0.075*$B$40+6.4","v":0.46295090990814369},{"$f":"-0.075/1.2*$B$40+6.4","v":1.4524590915901197},null,null,null,null,2.5,null,null,null,"Low18","Low",{"$f":"AE$20","v":1},{"$f":"AF$23","v":8},16,40.200000000000003,40.200000000000003,0,false,40.200000000000003,0,false,false,"Low",1,8]
["Ramp2","y=-0.07x+4.6667",null,{"$f":"-0.07*$B$40+4.667","v":-0.87424581741906682},{"$f":"-0.07/1.1*$B$40+4.667","v":-0.37049619765369712},null,null,null,null,3,null,null,null,"Low21","Low",{"$f":"AE$21","v":2},{"$f":"AF$20","v":1},17,49.9,49.7,-4.0080160320640429E-3,false,50,2.0040080160320926E-3,false,false,"Low",2,1]
["Ramp1","y=-0.0591x+2.978",null,{"$f":"-0.0591*$B$40+2.978","v":-1.7003946829923833},{"$f":"-0.0591/1.05*$B$40+2.978","v":-1.4776139838022693},null,null,null,null,3.5,null,null,null,"Low22","Low",{"$f":"AE$21","v":2},{"$f":"AF$21","v":2},18,60.4,60.7,4.9668874172186135E-3,false,60.64,3.9735099337748674E-3,false,false,"Low",2,2]
[null,null,"ramp=",{"$f":"IF(Vout>=D34,AE22,IF(AND(Vout>=D35, Vout<D34), AE21, IF(AND(Vout>=D36,Vout<D35),AE20,\"Unstable\")))","v":4},{"$f":"IF(Vout>=E34,AE22,IF(AND(Vout>=E35, Vout<E34), AE21, IF(AND(Vout>=E36,Vout<E35),AE20,\"Unstable\")))","v":2},null,null,null,null,4,null,null,null,"Low24","Low",{"$f":"AE$21","v":2},{"$f":"AF$22","v":4},19,76.8,76.2,-7.8124999999999263E-3,false,76.739999999999995,-7.8125000000002964E-4,false,false,"Low",2,4]
[null,null,null,null,null,null,null,null,null,4.5,null,null,null,"Low28","Low",{"$f":"AE$21","v":2},{"$f":"AF$23","v":8},20,102,100,-1.9607843137254902E-2,true,100,-1.9607843137254902E-2,true,true,"Low",2,8]
["FLC",{"$f":"1/(2*PI()*SQRT(([0]!Lout*[0]!Cout*10^-12)))","v":12632.538296704501},null,null,null,null,null,null,null,5,null,null,null,"Low41","Low",{"$f":"AE$22","v":4},{"$f":"AF$20","v":1},21,137,{"$f":"82+56","v":138},7.2992700729927005E-3,false,136.36000000000001,-4.6715328467152291E-3,false,false,"Low",4,1]
["FSW/FLC",{"$f":"DeviceCalculator!fsw_div_fLC","v":79.160654534558091},null,null,null,null,null,null,null,5.5,null,null,null,"Low42","Low",{"$f":"AE$22","v":4},{"$f":"AF$21","v":2},22,174,{"$f":"180","v":180},3.4482758620689655E-2,false,180,3.4482758620689655E-2,false,false,"Low",4,2]
[null,null,null,null,null,null,null,null,null,6,null,null,null,"Low44","Low",{"$f":"AE$22","v":4},{"$f":"AF$22","v":4},23,243,270,0.1111111111111111,false,270,0.1111111111111111,false,false,"Low",4,4]
[null,null,null,null,null,null,null,null,null,6.5,null,null,null,"Low48","Low",{"$f":"AE$22","v":4},{"$f":"AF$23","v":8},24,412,390,-5.3398058252427182E-2,false,390,-5.3398058252427182E-2,false,false,"Low",4,8]
[null,null,null,null,null,null,null,null,null,7,null,null,null,"High22",{"$f":"AD$20","v":"High"},{"$f":"AE$21","v":2},{"$f":"AF$21","v":2},25,"n/a","n/a",null,null,null,null,null,{"$f":"S43=R_mode","v":false},"High",2,2]
[{"$f":"1/(2*PI()*SQRT(([0]!Lout*(1-Tol_L))*[0]!Cout*10^-12))","v":14123.607179900333},null,null,null,null,null,null,null,null,7.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OR(Z19:Z43)","v":true}]
[null,null,null,null,null,null,null,null,null,8]
[]
[null,null,null,null,"table 7-5",null,null,null,null,null,null,null,null,"TPS543B22","Current Limit","Cramp","soft start"]
[null,null,null,null,"Cramp (pF)",null,null,null,null,"Lookup table 7-4 in datasheet",null,null,null,null,null,null,null,null,"Res to GND"]
["Lookup Table for Fast Transient",null,"fsw ",1,2,4,null,null,"fsw ","version 1","version 2  Lookup1","Lookup2",null,{"$f":"CONCATENATE(O49, P49, Q49)","v":"High11"},{"$f":"AD$20","v":"High"},{"$f":"AE$20","v":1},1,1,1.78]
[null,null,500,109,217,434,null,null,500,2854000,0.372,0.29699999999999999,null,"High12",{"$f":"AD$20","v":"High"},1,2,2,2.21]
[null,null,750,72,145,289,null,null,750,1935000,0.54800000000000004,0.44500000000000001,null,"High14","High",1,4,3,2.74]
[null,null,1000,54,108,217,null,null,1000,1477000,0.71899999999999997,0.59399999999999997,null,"High18","High",1,8,4,3.32]
[null,null,1500,36,72,145,null,null,1500,1020000,1.04,0.89100000000000001,null,"High21","High",{"$f":"AE$21","v":2},1,5,4.0199999999999996]
[null,null,2200,25,49,99,null,null,2200,733000,1.46,1.31,null,"High22","High",{"$f":"AE$21","v":2},2,6,4.87]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High24","High",{"$f":"AE$21","v":2},4,7,5.9]
[null,null,"FSW+Cramp",null,null,null,null,null,null,null,null,null,null,"High28","High",2,8,8,7.32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High41","High",{"$f":"AE$22","v":4},1,9,9.09]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"High42","High",{"$f":"AE$22","v":4},2,10,11.3]
[null,null,"fsw","Cramp","Lookup",null,null,null,"1/10",{"$f":"1/10","v":0.1},null,null,null,"High44","High",{"$f":"AE$22","v":4},4,11,14.3]
[null,{"$f":"CONCATENATE(C60, D60)","v":"5001"},500,1,109,null,null,null,"1/9",{"$f":"1/9","v":0.1111111111111111},null,null,null,"High48","High",{"$f":"AE$22","v":4},8,12,18.2]
[null,{"$f":"CONCATENATE(C61, D61)","v":"5002"},500,2,217,null,null,null,"1/8",{"$f":"1/8","v":0.125},null,null,null,"Low11",{"$f":"AD$21","v":"Low"},{"$f":"AE$20","v":1},1,13,22.1]
[null,"5004",500,4,434,null,null,null,"1/6",{"$f":"1/7","v":0.14285714285714285},null,null,null,"Low12","Low",{"$f":"AE$20","v":1},2,14,26.7]
[null,"7501",750,1,72,null,null,null,"1/5",{"$f":"1/5","v":0.2},null,null,null,"Low14","Low",{"$f":"AE$20","v":1},4,15,33.200000000000003]
[null,"7502",750,2,145,null,null,null,"1/4",{"$f":"1/4","v":0.25},null,null,null,"Low18","Low",{"$f":"AE$20","v":1},8,16,40.200000000000003]
[null,"7504",750,4,289,null,null,null,"1/3",{"$f":"1/3","v":0.33333333333333331},null,null,null,"Low21","Low",{"$f":"AE$21","v":2},1,17,49.9]
[null,"10001",1000,1,54,null,null,null,"1/2",{"$f":"1/2","v":0.5},null,null,null,"Low22","Low",{"$f":"AE$21","v":2},2,18,60.4]
[null,"10002",1000,2,108,null,null,null,null,null,null,null,null,"Low24","Low",{"$f":"AE$21","v":2},4,19,76.8]
[null,"10004",1000,4,217,null,null,null,null,null,null,null,null,"Low28","Low",{"$f":"AE$21","v":2},8,20,102]
[null,"15001",1500,1,36,null,null,null,null,null,null,null,null,"Low41","Low",{"$f":"AE$22","v":4},1,21,137]
[null,"15002",1500,2,72,null,null,null,null,null,null,null,null,"Low42","Low",{"$f":"AE$22","v":4},2,22,174]
[null,"15004",1500,4,145,null,null,null,null,null,null,null,null,"Low44","Low",{"$f":"AE$22","v":4},4,23,243]
[null,"22001",2200,1,25,null,null,null,null,null,null,null,null,"Low48","Low",{"$f":"AE$22","v":4},8,24,412]
[null,"22002",2200,2,49]
[null,"22004",2200,4,99]
[]
[null,null,null,"Lo",{"$f":"DeviceCalculator!Lout","v":0.33},"Vinmax",{"$f":"DeviceCalculator!C31","v":13.2},"Cout",{"$f":"DeviceCalculator!C83*10^-6","v":9.9999999999999991E-5}]
[null,"fsw",{"$f":"DeviceCalculator!fsw_select","v":1000},"deltaV",{"$f":"DeviceCalculator!dVo_trans","v":2.4E-2},"Vout",{"$f":"DeviceCalculator!C32","v":1.2},"Resr",{"$f":"DeviceCalculator!C84*10^-3","v":1.4250000000000001E-3}]
[null,"Fco desired",{"$f":"[0]!fco_desired","v":125000},"deltaI",{"$f":"DeviceCalculator!Io_step","v":6},null,null,"Derating",{"$f":"DeviceCalculator!C86","v":0.8}]
[]
[null,"Cramp","Vcramp","Lookup","Zout_required","Zout_converter","Cout_min","Capacitor","Resr","Derating","Zcapacitor","Ncapacitor",null,"fesr zero","5xFco","is fesr > 5xfco","is Vcramp <1.25V","AND of Vcramp and Fesr"]
[null,1,{"$f":"$G$76*(($G$77/$G$76)*(1/($C$77*1000))+0.0000001)/(VLOOKUP( DeviceCalculator!fsw_select,partData!$I$50:$J$54,2,FALSE)*B81*10^-12)","v":1.7061611374407584},{"$f":"VLOOKUP(CONCATENATE(C77,B81),partData!$B$59:$E$74,4,FALSE)","v":54},{"$f":"$E$77/$E$78","v":4.0000000000000001E-3},{"$f":"(0.00004+($E$76*10^-6)/(D81*10^-6))*DeviceCalculator!Vout/DeviceCalculator!Vref","v":1.4762666666666667E-2},{"$f":"1/(2*PI()*$C$78*F81)","v":8.6247259623498199E-5},{"$f":"$I$76","v":9.9999999999999991E-5},{"$f":"$I$77","v":1.4250000000000001E-3},{"$f":"$I$78","v":0.8},{"$f":"I81+1/(2*PI()*J81*H81*$C$78)","v":1.7340494309189537E-2},{"$f":"K81/F81","v":1.1746180213052884},null,{"$f":"1/(I81*H81*J81*2*PI())","v":1396095.9920341698},{"$f":"$C$78*5","v":625000},{"$f":"IF(N81>O81,TRUE,FALSE)","v":true},{"$f":"IF(C81<1.25,TRUE,FALSE)","v":false},{"$f":"AND(P81,Q81)","v":false}]
[null,2,{"$f":"$G$76*(($G$77/$G$76)*(1/($C$77*1000))+0.0000001)/(VLOOKUP( DeviceCalculator!fsw_select,partData!$I$50:$J$54,2,FALSE)*B82*10^-12)","v":0.85308056872037918},{"$f":"VLOOKUP(CONCATENATE(C77,B82),partData!$B$59:$E$74,4,FALSE)","v":108},{"$f":"$E$77/$E$78","v":4.0000000000000001E-3},{"$f":"(0.00004+($E$76*10^-6)/(D82*10^-6))*DeviceCalculator!Vout/DeviceCalculator!Vref","v":7.4293333333333338E-3},{"$f":"1/(2*PI()*$C$78*F82)","v":1.7138005358064825E-4},{"$f":"$I$76","v":9.9999999999999991E-5},{"$f":"$I$77","v":1.4250000000000001E-3},{"$f":"$I$78","v":0.8},{"$f":"I82+1/(2*PI()*J82*H82*$C$78)","v":1.7340494309189537E-2},{"$f":"K82/F82","v":2.3340579202965097},null,{"$f":"1/(I82*H82*J82*2*PI())","v":1396095.9920341698},{"$f":"$C$78*5","v":625000},{"$f":"IF(N82>O82,TRUE,FALSE)","v":true},{"$f":"IF(C82<1.25,TRUE,FALSE)","v":true},{"$f":"AND(P82,Q82)","v":true}]
[null,4,{"$f":"$G$76*(($G$77/$G$76)*(1/($C$77*1000))+0.0000001)/(VLOOKUP( DeviceCalculator!fsw_select,partData!$I$50:$J$54,2,FALSE)*B83*10^-12)","v":0.42654028436018959},{"$f":"VLOOKUP(CONCATENATE(C77,B83),partData!$B$59:$E$74,4,FALSE)","v":217},4.0000000000000001E-3,{"$f":"(0.00004+($E$76*10^-6)/(D83*10^-6))*DeviceCalculator!Vout/DeviceCalculator!Vref","v":3.7457695852534567E-3},3.3991400585549076E-4,9.9999999999999991E-5,1.4250000000000001E-3,0.8,1.7340494309189537E-2,{"$f":"K83/F83","v":4.6293542393681957},null,1396095.9920341698,{"$f":"$C$78*5","v":625000},{"$f":"IF(N83>O83,TRUE,FALSE)","v":true},{"$f":"IF(C83<1.25,TRUE,FALSE)","v":true},{"$f":"AND(P83,Q83)","v":true}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Recommended Cramp",{"$f":"IF(R81=TRUE,1,IF(R82=TRUE,2,IF(R83=TRUE,4,\"NA\")))","v":2}]
[]
["Vout",{"$f":"DeviceCalculator!Vout","v":1.2},{"$f":"B87","v":1.2},{"$f":"C87","v":1.2}]
["Voltage Rating",{"$f":"DeviceCalculator!C85","v":6.3},{"$f":"DeviceCalculator!E85","v":6.3},{"$f":"DeviceCalculator!E128","v":6.3}]
["Ceramic ",null,null,null,6.3,null,100,47,22]
[100,{"$f":"(IF(0.9589-0.8654*(B87/B88)>1,1,0.9589-0.8654*(B87/B88)))","v":0.79406190476190475},{"$f":"(IF(0.9589-0.8654*(C87/C88)>1,1,0.9589-0.8654*(C87/C88)))","v":0.79406190476190475},{"$f":"(IF(0.9589-0.8654*(D87/D88)>1,1,0.9589-0.8654*(D87/D88)))","v":0.79406190476190475},0.5,{"$f":"E90/$E$89","v":7.9365079365079361E-2},{"$f":"0.9589-0.8654*F90","v":0.8902174603174603},{"$f":"1.0626-0.78661*F90","v":1.000170634920635},{"$f":"1.1002-0.6001*F90","v":1.052573015873016}]
[47,{"$f":"(IF(1.0626-0.78661*(B87/B88)>1,1,1.0626-0.78661*(B87/B88)))","v":0.91276952380952381},{"$f":"(IF(1.0626-0.78661*(C87/C88)>1,1,1.0626-0.78661*(C87/C88)))","v":0.91276952380952381},{"$f":"(IF(1.0626-0.78661*(D87/D88)>1,1,1.0626-0.78661*(D87/D88)))","v":0.91276952380952381},1,{"$f":"E91/$E$89","v":0.15873015873015872},{"$f":"0.9589-0.8654*F91","v":0.82153492063492062},{"$f":"1.0626-0.78661*F91","v":0.93774126984126982},{"$f":"1.1002-0.6001*F91","v":1.0049460317460319}]
[22,{"$f":"(IF(1.1002-0.6001*(B87/B88)>1,1,1.1002-0.6001*(B87/B88)))","v":0.98589523809523816},{"$f":"(IF(1.1002-0.6001*(C87/C88)>1,1,1.1002-0.6001*(C87/C88)))","v":0.98589523809523816},{"$f":"(IF(1.1002-0.6001*(D87/D88)>1,1,1.1002-0.6001*(D87/D88)))","v":0.98589523809523816},1.5,{"$f":"E92/$E$89","v":0.23809523809523811},0.75285238095238094,0.87531190476190468,0.95731904761904763]
[null,null,null,null,2,0.31746031746031744,0.68416984126984126,0.81288253968253965,0.90969206349206355]
[null,null,null,null,2.5,0.39682539682539686,0.61548730158730147,0.75045317460317462,0.86206507936507948]
[null,null,null,null,3,0.47619047619047622,0.5468047619047619,0.68802380952380948,0.81443809523809529]
[null,null,null,null,3.5,0.55555555555555558,0.47812222222222223,0.62559444444444434,0.76681111111111111]
[null,null,null,null,4,0.63492063492063489,0.40943968253968255,0.56316507936507931,0.71918412698412704]
[null,null,null,null,4.5,0.7142857142857143,0.34075714285714287,0.50073571428571428,0.67155714285714296]
[null,null,null,null,5,0.79365079365079372,0.27207460317460308,0.43830634920634914,0.62393015873015878]
[null,null,null,null,5.5,0.87301587301587302,0.20339206349206351,0.37587698412698411,0.57630317460317471]
["things to add to the macro",null,null,null,6,0.95238095238095244,0.13470952380952383,0.31344761904761897,0.52867619047619052]
[null,null,null,null,null,null,3.8,3.4,2.8,"Irms"]
["Check the Cramp voltage level",null,null,null,null,null,2.2000000000000002,2.8,4,"esr"]

{"sheet":"Layout Checklist","index":4,"n_rows":20,"n_cols":8,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,0,1,6],[6,0,6,6],[13,0,13,6]]}
["Pin","Name","Purpose","Placement or Routing?","Remarks","Reasoning","Status","Comments"]
["Control"]
[null,"FB","Output voltage feedback input.",null,"Place the feedback resistor near the device to minimize the FB trace distance. Avoid routing near noisy signals or power planes.",null,"Open"]
[null,"GOSNS","The return connection for a remote voltage sensing configuratio",null,"The return connection for a remote voltage sensing configuration.  Short to AGND for single-end sense configuration",null,"Open"]
[null,"AGND",null,null,"Return the FSEL and MODE resistors to a quiet AGND island.  Connect AGND to PGND at one point.",null,"Open"]
[]
["Configuration"]
[null,"MSEL",null,null,"Return the FSEL and MSEL resistors to a quiet AGND island",null,"Open"]
[null,"SYNC/FSEL",null,null,"Return the FSEL and MSEL resistors to a quiet AGND island"]
[null,"PGOOD","Open drain power good",null,null,null,"Open"]
[null,"EN","enable pin",null,"The recommended operating condition for EN pin is maximum 5.5-V. DO NOT connect EN pin to VIN pin directly.",null,"Open"]
[]
[]
["Power Stage"]
[7,"BOOT",null,null,"Place the boot circuit as close as possible to the pin. ",null,"Open"]
[6,"SW",null,null,"The PCB trace defined as SW switch node, which connects the SW pins and high-voltage side of the inductor, should be as short and wide as possible. ",null,"Open"]
["4, 9","VIN","Power Input to the Power Stage",null," Place a 1-μF/25-V/X6R or better dielectric ceramic capacitors from each VIN to PGND pins and place them as close as possible to the device on the same side of the PCB. Place the remaining ceramic input capacitance next to these high frequency bypass capacitors. The remaining input capacitance can be placed\non the other side of the board but use as many vias as possible to minimize impedance between the capacitors and the pins of the IC.                                 \n1-μF capacitor from each VIN to PGND close to the IC is required.",null,"Open"]
["16, 17, 8, 5","PGND","These ground pins are connected to the return of the internal low-side MOSFET.",null,"Have a large solid ground plane for GND.    Use vias to help with power dissipation",null,"Open"]
[3,"VDRV","Internal 5-V regulator output and internal connection to drivers. ",null,"Bypass these pins with a 2.2-μF  capacitor to PGND.   Ensure the VDRV capacitor loop is smallest",null,"Open"]
[2,"VCC","Supply for analog control circuitry",null,"Connect a 10-Ω resistor from VDRV to this pin and bypass\nwith a 0.1-μF capacitor to AGND",null,"Open"]

{"sheet":"Schematic Checklist","index":5,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":true,"merged":[[41,0,41,7],[19,0,19,7],[35,0,35,7],[1,0,1,7],[10,0,10,7]]}
["Pin","Name","Purpose","Connection For Functional Use","Reasoning","Recommended Component Values from Calculator","Component units","Status","Comments"]
["Control"]
[15,"FB","Output voltage feedback input.","Feedback pin and input to the differential remote sense amplifier for output voltage regulation. Place the bottom resistor in the FB divider as close as possible to the FB and GOSNS pins of the IC. Also\nkeep the upper feedback resistor and the feedforward capacitor near the IC. Connect the FB divider to the\noutput voltage at the desired point of regulation\nConnect FB pin to the midpoint of a resistor divider to set the output voltage. ","Placement near device reduces noise pickup                                                           Using Rfb_b between 1kOhm to 20kOhm",{"$f":" CONCATENATE(\"Rfb_t= \",DeviceCalculator!D173,\"                             Rfb_b=\", DeviceCalculator!Rfb_b)","v":"Rfb_t= 11.3                             Rfb_b=8"},{"$f":"DeviceCalculator!G171","v":"kΩ"},"Open"]
[15,"FB","Feedforward Capacitor ","Adding a Cff in parallel with the Rfb_t can be beneficial ","Adding a Cff may help improve transient response"]
[14,"GOSNS","Ground sense return and input to the differential remote sense amplifier","For differential remote sense, connect to remote ground near the load",null,null,null,"Open"]
[14,"GOSNS",null,"For single ended sense, connect GOSNS to AGND"]
[]
[1,"AGND","Reference point for the internal control circuits. ","Use a separate ground symbol for AGND. Use vias on the AGND islands on top layer to connect to AGND layer island on an internal layer. Connect the\ninternal AGND island to PGND at one point","AGND  is expected to be a  quiet ground",null,null,"Open"]
[]
[]
["Configuration"]
[10,"EN",null,"Floating EN pin before startup enables the converter. DO NOT connect EN pin to VIN pin directly. If an application requires digital control of the ENABLE function, an open-drain or open-collector output logic can be interfaced with the pin.                                                                          An external resistor divider can be added from VIN to the EN pin for adjustable UVLO","The recommended max voltage on the EN pin is 5.5V. Typical turn on threshold voltage is 1.2 V for the converter.   The VDRV  turns on at 0.7V enable threshold",{"$f":" CONCATENATE(\"Ren_t= \", DeviceCalculator!E201,\"                             Ren_b=\", DeviceCalculator!E204)","v":"Ren_t= 8.06                             Ren_b=10000"},{"$f":"DeviceCalculator!G204","v":"kΩ"},"Open"]
[12,"SYNC/FSEL",null,"Frequency select and external clock synchronization. A resistor to ground sets the switching frequency of the device. An external clock can also be applied to this pin to synchronize the switching frequency.     Return the FSEL and MSEL resistors to a quiet AGND island. Use a 1% tolerance resistor or better",null,{"$f":"CONCATENATE(\"Rfsel= \", DeviceCalculator!R_fsel)","v":"Rfsel= 11.8"},{"$f":"DeviceCalculator!G42","v":"kΩ"},"Open"]
[13,"MSEL",null,"A resistor to ground selects the current limit, soft-start rate, and PWM ramp amplitude. Return the FSEL and MSEL resistors to a quiet AGND island.   Use a 1% tolerance resistor or better",null,{"$f":"CONCATENATE(\"Rmsel= \", DeviceCalculator!R_msel)","v":"Rmsel= 102"},{"$f":"DeviceCalculator!G69","v":"kΩ"},"Open"]
[11,"PG",null,"Open-drain power-good (PG) indicator.  Use a pull up resistor to VDRV, VCC or an external supply. s. A pullup resistor between the values of 10 kΩ and 100 kΩ to a voltage source that is 5.5 V or less is recommended",null,null,null,"Open"]
[2,"VCC",null,"Supply for analog control circuitry. Connect a 10-Ω resistor from VDRV to this pin and bypass\nwith a 0.1-μF capacitor to AGND.    It is not intended to drive VCC with any source other than VDRV","The 10-Ω and 0.1-μF create a low pass filter to the  supply pin VCC",null,null,"Open"]
[null,null,null,null,null,null,null,"Open"]
[]
[]
["Power Stage"]
[7,"BOOT",null,"Place the BOOT-SW capacitor as close as possible to the BOOT and SW pins. Use a 0.1-μF/16-V/X6R or\nbetter dielectric ceramic capacitor for the BOOT capacitor","TI recommends using a 0.1-µF to 1-µF bootstrap capacitor with 10-V rating. It is good practice to use a 0-Ω resistor in series with BOOT capacitor.",null,null,"Open"]
[6,"SW",null,"Output switching terminal of the power converter. Connect this pin to the output\ninductor.  Place the inductor as close as possible to the device ","Placing closed to device minimizes the length of the SW node routing",null,null,"Open"]
["4, 9","VIN",null,"Place a 1-μF/25-V/X6R or better dielectric ceramic capacitors from each VIN to PGND pins and place\nthem as close as possible to the device on the same side of the PCB. Place the remaining ceramic input\ncapacitance next to these high frequency bypass capacitors. The remaining input capacitance can be placed on the other side of the board but use as many vias as possible to minimize impedance between the\ncapacitors and the pins of the IC.   VIN, PGND, and SW traces must be as wide as possible to reduce trace impedance and improve heat\ndissipation. Use vias and traces on others layers to reduce VIN and PGND trace impedance","Use vias near both VIN pins and provide a low impedance connection between VIN pins through an internal layer                      VIN decoupling capacitors are important for FET robustness.            ",null,null,"Open"]
[null,"VIN",null," This supply voltage must be well regulated. Proper bypassing of the input supply is critical for proper electrical performance, as is the PCB layout and the grounding scheme. A minimum of 10-μF (after derating) ceramic capacitance, type\nX5R or better, must be placed near the device. TI recommends splitting the ceramic input capacitance equally between the VIN and PGND pins on each side of the device resulting in at least 5 µF of ceramic capacitance on each side of the device"]
["5, 8, 16,17","PGND",null,"Use multiple vias near the PGND pins and use the layer directly below the device to connect them together","Multiple vias helps to minimize noise and can improve heat dissipation.",null,"nF\nΩ","Open"]
[3,"VDRV",null,"Internal 5-V regulator output and internal connection to drivers. Bypass these pins with a 2.2-μF/10V to 10-μF/10V with X6R or better dielectric capacitor to PGND.   It is  not intended to connect VDRV to any external source or external load. ",null,null,null,"Open"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Open"]
[null,null,null,null,null,null,null,"Open"]
[null,null,null,null,null,null,null,"Open"]
[]
[]
[]
[null,null,null,null,null,null,null,"Open"]

{"sheet":"revisionNotes","index":6,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Rev","Date","Change"]
["A","2023-12-06","Initial"]

{"sheet":"Disclaimer","index":7,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Important notice and disclaimer"]
["TI PROVIDES TECHNICAL AND RELIABILITY DATA (INCLUDING DATASHEETS), DESIGN RESOURCES (INCLUDING REFERENCE DESIGNS), APPLICATION OR OTHER DESIGN ADVICE, WEB TOOLS, SAFETY INFORMATION, AND OTHER RESOURCES “AS IS” AND WITH ALL FAULTS, AND DISCLAIMS ALL WARRANTIES, EXPRESS AND IMPLIED, INCLUDING WITHOUT LIMITATION ANY IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE OR NON-INFRINGEMENT OF THIRD PARTY INTELLECTUAL PROPERTY RIGHTS."]
["These resources are intended for skilled developers designing with TI products. You are solely responsible for (1) selecting the appropriate TI products for your application, (2) designing, validating and testing your application, and (3) ensuring your application meets applicable standards, and any other safety, security, or other requirements."]
["These resources are subject to change without notice. TI grants you permission to use these resources only for development of an application that uses the TI products described in the resource. Other reproduction and display of these resources is prohibited. No license is granted to any other TI intellectual property right or to any third party intellectual property right. TI disclaims responsibility for, and you will fully indemnify TI and its representatives against, any claims, damages, costs, losses, and liabilities arising out of your use of these resources."]
["TI’s products are provided subject to TI’s Terms of Sale or other applicable terms available either on ti.com or provided in conjunction with such TI products. TI’s provision of these resources does not expand or otherwise alter TI’s applicable warranties or warranty disclaimers for TI products."]
["All information in this document is provided “AS IS” and “with all faults”, and is subject to TI’s Important Notice \n(http://www.ti.com/corp/docs/legal/important-notice.shtml)"]

{"sheet":"DeviceCalculator_old","index":8,"n_rows":164,"n_cols":10,"rows_kept":164,"cut":false,"hidden":true,"merged":[[38,1,38,7],[39,1,39,7],[55,1,55,7],[56,1,56,7],[101,1,101,7],[89,1,89,7],[96,1,96,7],[128,1,128,7],[102,1,102,7],[114,1,114,7],[140,1,140,7],[155,1,155,7],[30,1,30,7],[0,1,0,7],[7,1,7,7],[22,1,22,7],[1,1,6,1],[1,2,6,2],[1,3,6,3],[1,4,6,4],[1,5,6,5],[1,6,6,6],[1,7,6,7]]}
[null,"Design Calculations",null,null,null,null,null,null,null,"Key"]
[null,"Parameter","Input","Recommended","Selected Value","Calculated with Selected Value","Units","Description",null,"User Entered Value"]
[null,null,null,null,null,null,null,null,null,"Fixed IC Parameter"]
[null,null,null,null,null,null,null,null,null,"Calculated Parameter"]
[null,null,null,null,null,null,null,null,null,"Recommended Component Value"]
[null,null,null,null,null,null,null,null,null,"Design Caution"]
[null,null,null,null,null,null,null,null,null,"Design Warning"]
[null,"Choose Device"]
[null,"Part number","TPS543B22",null,null,null,null,"Select IC part number"]
[null,"Vin_min_IC",{"$f":"VLOOKUP($C$9,#REF!,2,FALSE)","v":{"$error":"#REF!"}},null,null,null,"V","IC rated minimum input voltage"]
[null,"Vin_max_IC",{"$f":"VLOOKUP($C$9,#REF!,3,FALSE)","v":{"$error":"#REF!"}},null,null,null,"V","IC rated maximum input voltage"]
[null,"Vref",{"$f":"VLOOKUP($C$9,#REF!,9,FALSE)","v":{"$error":"#REF!"}},null,null,null,"V","Internal voltage reference"]
[null,"Io_max_IC",{"$f":"VLOOKUP($C$9,#REF!,4,FALSE)","v":{"$error":"#REF!"}},null,null,null,"A","IC rated maximum output current"]
[null,"EN_rise",{"$f":"VLOOKUP($C$9,#REF!,12,FALSE)","v":{"$error":"#REF!"}},null,null,null,"V","EN rising voltage threshold"]
[null,"EN_rise_max",{"$f":"VLOOKUP($C$9,#REF!,17,FALSE)","v":{"$error":"#REF!"}},null,null,null,"V","EN rising voltage threshold (maximum spec)"]
[null,"EN_fall",{"$f":"VLOOKUP($C$9,#REF!,13,FALSE)","v":{"$error":"#REF!"}},null,null,null,"V","EN falling voltage threshold"]
[null,"OC_high_min",{"$f":"VLOOKUP($C$9,#REF!,5,FALSE)","v":{"$error":"#REF!"}},null,null,null,"A","Minimum peak current limit for High current limits"]
[null,"OC_low_min",{"$f":"VLOOKUP($C$9,#REF!,6,FALSE)","v":{"$error":"#REF!"}},null,null,null,"A","Minimum peak current limit for Low current limits"]
[null,"ton_min_max",{"$f":"VLOOKUP($C$9,#REF!,7,FALSE)","v":{"$error":"#REF!"}},null,null,null,"ns","Worst case minimum on-time"]
[null,"toff_min_max",{"$f":"VLOOKUP($C$9,#REF!,8,FALSE)","v":{"$error":"#REF!"}},null,null,null,"ns","Worst case minimum off-time"]
[null,"Rdson_HS",{"$f":"VLOOKUP($C$9,#REF!,10,FALSE)","v":{"$error":"#REF!"}},null,null,null,"mΩ","High-side FET Rdson"]
[null,"Rdson_LS",{"$f":"VLOOKUP($C$9,#REF!,11,FALSE)","v":{"$error":"#REF!"}},null,null,null,"mΩ","Low-side FET Rdson"]
[null,"Input System Parameters"]
[null,"Vin_min",4.5,null,null,null,"V","Minimum input voltage"]
[null,"Vin_nom",12,null,null,null,"V","Nominal input voltage"]
[null,"Vin_nom",12,null,null,null,"V","Nominal input voltage"]
[null,"Vin_max",18,null,null,null,"V","Maximum input voltage"]
[null,"Vout",1,null,null,null,"V","Output voltage"]
[null,"Iout",20,null,null,null,"A","Maximum output current"]
[null,"E12 Resistor Values?","No",null,null,null,null,"If using E12 resistor values, tolerance still must be 1%"]
[null,"Select the Switching Frequency (FSEL pin)"]
[null,"fsw_max_ton",null,{"$f":"IF((1/(ton_min_max*10^-9))*(Vout)/(Vin_max)*1/1.1>=2.2*10^6,2.2*10^6,(1/(ton_min_max*10^-9))*(Vout)/(Vin_max)*1/1.1)*10^-3","v":{"$error":"#REF!"}},{"$f":"(Vout/Vin_max)*(1/(ton_min_max*10^-9))*(1/1.1)","v":{"$error":"#REF!"}},null,"kHz","Maximum fsw limited by Vin_max and minimum on-time"]
[null,"fsw_max_toff",null,{"$f":"IF((Vin_min-Vout-Iout*2*(DCR_Ohm+Rdson_HS_Ohm))/(toff_min_max_sec*(Vin_min-Iout*2*(Rdson_HS_Ohm-Rdson_LS_Ohm)))*10^-3>=2200,2200,(Vin_min-Vout-Iout*2*(DCR_Ohm+Rdson_HS_Ohm))/(toff_min_max_sec*(Vin_min-Iout*2*(Rdson_HS_Ohm-Rdson_LS_Ohm)))*10^-3)","v":{"$error":"#REF!"}},null,null,"kHz","Maximum fsw allowed limited by Vin_min and minimum off-time (Depends on inductor DCR and includes 2x multiplier on resistance for margin, if red check input voltage levels)"]
[null,"fsw_rec",null,{"$f":"MIN(1000,VLOOKUP(TRUE,#REF!,2,FALSE))","v":{"$error":"#REF!"}},null,null,"kHz","Recommended max fsw setting"]
[null,"fsw_input",1000,null,null,null,"kHz","Select the fsw option"]
[null,"R_fsel_rec",null,{"$f":"IF(C30=\"No\", VLOOKUP(C35,#REF!,2,0), VLOOKUP(C35,#REF!,3,0))","v":{"$error":"#REF!"}},null,null,"kΩ","Recommended FSEL resistor for selected fsw"]
[null,"R_fsel",null,null,11.8,null,"kΩ","Selected FSEL resistor value"]
[null,"fsw_select",null,null,null,{"$f":"IF(OR(#REF!),VLOOKUP(TRUE,#REF!,3,FALSE),\"Invalid R_fsel\")","v":{"$error":"#REF!"}},"kHz","fsw with selected FSEL resistor (if red check input voltages)"]
[null,"Choose the Output Inductor (Lout)"]
[null,"The inductance is selected based on a p-p ripple current target. Smaller L reduces solution size while larger L reduces AC loss."]
[null,"Kind",0.2,null,null,null,null,"Target ripple/Iout ratio (typically between 0.2 to 0.4)"]
[null,"L_target",null,{"$f":"(1/(Kind*Iout*(fsw_select/1000))*(((Vin_max-Vout)*Vout)/Vin_max))","v":{"$error":"#REF!"}},null,null,"µH","Target inductor value"]
[null,"L_min",null,{"$f":"((Vin_max-Vout)*Vout)/(Io_max_IC*0.5*Vin_max*fsw_select)*1000","v":{"$error":"#REF!"}},null,null,"µH","Minimum recommended inductance (ripple = 50% Iout_max_IC)"]
[null,"L_max",null,{"$f":"((Vin_max-Vout)*Vout)/(Io_max_IC*0.05*Vin_max*fsw_select)*1000","v":{"$error":"#REF!"}},null,null,"µH","Maximum recommended inductance (ripple = 5% Iout_max_IC)"]
[null,"L_rec",null,{"$f":"MIN(MAX(D43,D42),D44)","v":{"$error":"#REF!"}},null,null,"µH","Recommended inductor value"]
[null,"Lout",null,null,0.22,null,"µH","Selected inductance"]
[null,"DCR",null,null,0.3,null,"mΩ","DC resistance of selected inductor"]
[null,"Tol_L",null,null,0,null,null,"Tolerance of inductance for selected inductor"]
[null,"Isat",null,null,30,null,null,"Inductor Saturation Current"]
[null,"Inductor Part Number",null,null,744303022,null,null,"Inductor Part Number"]
[null,"Iripple_max",null,null,{"$f":"1000*((Vin_nom-Vout)*Vout)/(Lout*(1-0)*Vin_nom*fsw_select)","v":{"$error":"#REF!"}},{"$f":"1000*((Vin_max-Vout)*Vout)/(Lout*(1-Tol_L)*Vin_max*fsw_select)","v":{"$error":"#REF!"}},"A","Inductor ripple current at Vin_max (includes Tol_L, used for DC ripple calculations) (Red if >50% of Iout rate)"]
[null,"Ipeak_max",null,null,null,{"$f":"Iout+(Iripple_max/2)","v":{"$error":"#REF!"}},"A","Full load peak current at Vin_max"]
[null,"Irms",null,null,null,{"$f":"SQRT(Iout^2+Iripple_max^2)","v":{"$error":"#REF!"}},"A","Inductor rms current at Vin_max"]
[null,"Iripple_min",null,null,null,{"$f":"1000*((Vin_min-Vout)*Vout)/(Lout*(1+Tol_L)*Vin_min*fsw_select)","v":{"$error":"#REF!"}},null,"Inductor ripple current at Vin_min (includes Tol_L)"]
[null,"Ivalley",null,null,null,{"$f":"Iout-(Iripple_min/2)","v":{"$error":"#REF!"}},"A","Full load valley current at Vin_min (used for I_lim calculations)"]
[null,"Choose the Output Capacitor (Cout)"]
[null,"The output capacitance is deteremind based on the output ripple, transient and stability requirements. These calculations do not support mixed type output capacitors."]
[null,"Io_step",10,null,null,null,"A","Iout load transient step"]
[null,"dVo_perc",0.03,null,null,null,null,"dVo percent"]
[null,"dVo_trans",0.05,null,null,null,"V","Target Vout overshoot/undershoot after load step"]
[null,"dVo_dc",0.02,null,null,null,"V","Target steady state Vout voltage ripple"]
[null,"Cout_ripple",null,{"$f":"Iripple_max/(8*dVo_dc*fsw_Hz)*10^6","v":{"$error":"#REF!"}},null,null,"µF","Min Cout for DC ripple requirement (ignores ESR)"]
[null,"Cout_trans",null,{"$f":"Io_step/(2*PI()*fsw_Hz/10*dVo_trans)*10^6","v":{"$error":"#REF!"}},null,null,"µF","Min Cout for transient requirement assuming fco = fsw/10"]
[null,"Cout_overshoot",null,{"$f":"Lout*Io_step^2/(2*Vout*dVo_trans)","v":687.5},null,null,"µF","Min Cout for overshoot requirement based on inductor current slew rate"]
[null,"Cout_undershoot",null,{"$f":"(Lout_H*Io_step^2/(2*(Vin_min-Vout)*dVo_trans) + Io_step*(1-Vout/Vin_min)*1/fsw_Hz/(dVo_trans))*10^6","v":{"$error":"#REF!"}},null,null,"µF","Min Cout for undershoot requirement based on inductor current slew rate"]
[null,"Cout_stability",null,{"$f":"(30/(2*PI()*fsw_Hz))^2*1/Lout_H*1000000","v":{"$error":"#REF!"}},null,null,"µF","Min Cout for stability (f_LC < fsw/30)"]
[null,"Cout_min",null,330,null,null,"µF","Recommended min Cout (must include any derating due to DC/AC bias, temp and/or tolerance)"]
[null,"Cout_max",null,{"$f":"(150/(2*PI()*fsw_Hz))^2*1/Lout_H*1000000","v":{"$error":"#REF!"}},null,null,"µF","Max Cout for stability (f_LC > fsw/150) \n(Exceeding this is typically ok but validation of loop stability is highly recommended)"]
[null,"ESR_trans",null,{"$f":"dVo_trans/Io_step*1000","v":2.4000000000000004},null,null,"mΩ","Max ESR to meet load step transient requirement"]
[null,"ESR_ripple",null,{"$f":"dVo_dc/Iripple_max*1000","v":{"$error":"#REF!"}},null,null,"mΩ","Max ESR to meet ripple requirement"]
[null,"ESR_max",null,{"$f":"MIN(D69:D70)","v":{"$error":"#REF!"}},null,null,"mΩ"]
[null,"N_Cout_cer",null,null,6,null,null,"Number of output capacitors"]
[null,"Cout_single_cer",null,null,100,null,"µF","Nominal value of single ceramic output capacitor"]
[null,"Cer_derating",null,null,0.9,null,null,"Remaining output capacitance after derating due to DC/AC bias, temp and/or tolerance"]
[null,"ESR_single_cer",null,null,3,null,"mΩ","ESR of output single ceramic output capacitor"]
[null,"Cer Voltage Rating",null,null,6.3,null,"V","Voltage Rating of Ceramic Capacitor "]
[null,"Cout_cer_eff",null,null,null,{"$f":"Cout_single_cer*N_Cout_cer*Cer_derating","v":540},"µF","Effective Cout (If red, not enough capacitance)"]
[null,"ESR_cer_eff",null,null,null,{"$f":"ESR_single_cer/N_Cout_cer","v":0.5},"mΩ","Effective ESR"]
[null,"N_Cout_bulk",null,null,4,null,null,"Number of Bulk Capacitors"]
[null,"Cout_single_bulk",null,null,470,null,"uF","Nominal value of a Single Bulk/Polymer/Electrolytic Output Capacitor"]
[null,"Bulk_derating",null,null,1,null,null,"Percentage of Nominal Bulk Capacitance remaining after tolerance, temperature, and/or lifetime"]
[null,"Bulk Voltage Rating",null,null,6.3E-2,null,null,"Voltage Rating of Bulk Capacitor "]
[null,"ESR_single_bulk",null,null,1,null,"mΩ","Single Bulk Capacitor ESR"]
[null,"Cout_bulk_eff",null,null,null,{"$f":"IF(N_Cout_bulk=0,0.001,N_Cout_bulk*E80*Bulk_derating)","v":1880},"µF","Total Bulk Output Capacitance"]
[null,"ESR_bulk_eff",null,null,null,{"$f":"IF(N_Cout_bulk=0,10^9,E83/N_Cout_bulk)","v":0.25},"mΩ","Effective Bulk Capacitance ESR"]
[null,"Cout",null,null,null,{"$f":"Cout_bulk_eff+Cout_cer_eff","v":2420},"uF","Total Bulk + Ceramic Output Capacitance "]
[null,"f_LC",null,null,null,{"$f":"1/(2*PI()*SQRT(Lout_H*Cout_F))*0.001","v":12.632538296704501},"kHz","LC resonant frequency "]
[null,"fz_ESR_cer",null,null,null,{"$f":"IF(N_Cout_cer=0,10^6,1/(2*PI()*Cout_cer_eff_F*ESR_cer_eff_Ohm)*10^-3)","v":589.46275219220502},"kHz","Ceramic capacitor ESR zero frequency"]
[null,"fz_ESR_bulk",null,null,null,{"$f":"IF(N_Cout_bulk=0,10^6,1/(2*PI()*Cout_bulk_eff_F*ESR_bulk_eff_Ohm)*10^-3)","v":338.62753849339435},"kHz","Bulk capacitor ESR zero frequency \n(if yellow, ESR zero may limit loop bandwidth)"]
[null,"Transient response estimations with selected output caps"]
[null,"fco_est",null,{"$f":"fsw_select/10","v":{"$error":"#REF!"}},null,null,"kHz","Loop bandwidth estimate of fsw_select/10"]
[null,"Zcer_fco",null,null,null,{"$f":"(1/(2*PI()*fco_Hz*Cout_cer_eff_F)*10^3)","v":2.9473137609610252},"mΩ","Estimated output cap impedance at fsw/10"]
[null,"Zbulk_fco",null,null,null,{"$f":"SQRT((1/(2*PI()*fco_Hz*Cout_bulk_eff_F))^2+ESR_bulk_eff_Ohm^2)*10^3","v":0.88271105771543135},"mΩ","Bulk capacitor impedance at fsw"]
[null,"Zcout_fco",null,null,null,{"$f":"Zcer_fco*Zbulk_fco/(Zcer_fco+Zbulk_fco)","v":3.3088345770729548},"mΩ","Combined output capacitor impedance at fsw"]
[null,"Vo_trans",null,null,null,{"$f":"Io_step*Zcout_fco","v":33.088345770729546},"mV","Estimated transient overshoot/undershoot based on loop bandwidth estimate"]
[null,"Vo_overshoot",null,null,null,{"$f":"(Lout_H*Io_step^2/(2*Vout*Cout_F))*1000","v":34.303534303534306},"mV","Estimated overshoot based on inductor current slew rate"]
[null,"DC output ripple estimations with selected output caps"]
[null,"Zcer_fsw",null,null,null,{"$f":"SQRT((1/(2*PI()*fsw_Hz*Cout_cer_eff_F))^2+ESR_cer_eff_Ohm^2)*10^3","v":{"$error":"#REF!"}},"mΩ","Ceramic capacitor impdance at fsw"]
[null,"Zbulk_fsw",null,null,null,{"$f":"SQRT((1/(2*PI()*fsw_Hz*Cout_bulk_eff_F))^2+ESR_bulk_eff_Ohm^2)*10^3","v":{"$error":"#REF!"}},"mΩ","Bulk capacitor impedance at fsw"]
[null,"Zcout_fsw",null,null,null,{"$f":"Zcer_fsw*Zbulk_fsw/(Zcer_fsw+Zbulk_fsw)","v":0.59769739618196627},"mΩ","Combined output capacitor impedance at fsw"]
[null,"Vo_ripple",null,null,null,{"$f":"Iripple_max*Zcout_fsw","v":{"$error":"#REF!"}},"mV","Estimated capacitive + resistive DC ripple (ignores ESL)"]
[null,"Choose the Input Capacitor (Cin)"]
[null,"The input capacitance is deteremind based on the input ripple requirements. Additional bulk input capacitance may be needed for transients. 0.1µF high frequency bypass capacitors are also required."]
[null,"Vi_ripple_perc",0.04,null,null,null,null,"Target DC input voltage ripple percentage"]
[null,"Vi_ripple_rec",null,{"$f":"Vin_min*Vi_ripple_perc*1000","v":180},null,null,"mV","Recommended DC input voltage ripple (based on Vin_min)"]
[null,"Vi_ripple_target",{"$f":"D105","v":180},null,null,null,"mV","Target DC input voltage ripple"]
[null,"Cin_min",null,{"$f":"MAX(4.7,(Iout*0.25)/(Vi_ripple_target*fsw_select)*10^6)","v":{"$error":"#REF!"}},null,null,"µF","Minimum input capacitance required (include derating)"]
[null,"N_Cin_Cer",null,2]
[null,"Cin_Single_cer",null,{"$f":"22+100+10","v":132}]
[null,"Cin_cer_derating",null,0.5]
[null,"Cin",null,null,132,null,"µF","Effective input ceramic cap used (include derating)"]
[null,"Cin Voltage Rating",null,null,25,null,null,"Voltage Rating"]
[null,"Vi_ripple",null,null,null,{"$f":"(Iout*Vout/Vin_max*(1-Vout/Vin_max))/(Cin*fsw_select)*10^6","v":{"$error":"#REF!"}},"mV","Input DC ripple"]
[null,"Iin_rms",null,null,null,{"$f":"Iout*SQRT(Vout/Vin_min*(Vin_min-Vout)/Vin_min)","v":8.3147941928309805},"A","Input RMS current"]
[null,"Determine feedback network values (FB resistor divider and Cff)"]
[null,"Rfb_b_rec",null,4.99,null,null,"kΩ","Bottom feedback resistor (1k-20k recommended)"]
[null,"Rfb_b",null,null,7.1530249110320279,null,"kΩ","Selected bottom feedback resistor"]
[null,"Rfb_t_target",null,{"$f":"Rfb_b*(Vout/Vref-1)","v":{"$error":"#REF!"}},null,null,"kΩ","Calculated top resistor"]
[null,"Rfb_t_std",null,{"$f":"(IF((10^(LOG(D118)-INT(LOG(D118)))*100)-VLOOKUP((10^(LOG(D118)-INT(LOG(D118)))*100),E96_s:E96_f,1)<VLOOKUP((10^(LOG(D118)-INT(LOG(D118)))*100),E96_s:E96_f,2)-(10^(LOG(D118)-INT(LOG(D118)))*100),VLOOKUP((10^(LOG(D118)-INT(LOG(D118)))*100),E96_s:E96_f,1),VLOOKUP((10^(LOG(D118)-INT(LOG(D118)))*100),E96_s:E96_f,2)))*10^INT(LOG(D118))/100","v":{"$error":"#REF!"}},null,null,"kΩ","Closest 1% standard resistor value"]
[null,"Rfb_t",null,null,10,null,"kΩ","Selected top resistor"]
[null,"Vout_calc",null,null,null,{"$f":"Vref*(1+Rfb_t/Rfb_b)","v":{"$error":"#REF!"}},"V","Calculated Vout (yellow if not within 1% of target Vout)"]
[null,"Cff_rec",null,{"$f":"1/(2*PI()*(fsw_select/4)*Rfb_t)*1000000","v":{"$error":"#REF!"}},null,null,"pF","Recommended feedforward cap value (fz_Cff = fsw/4)"]
[null,"Cff_rec_std",null,{"$f":"IF(Cff_rec<10000,VLOOKUP((10^(LOG(Cff_rec)-INT(LOG(Cff_rec)))),c_s1:C_f1,1),VLOOKUP((10^(LOG(Cff_rec)-INT(LOG(Cff_rec)))),C_s2:C_f2,1))*10^INT(LOG(Cff_rec))","v":{"$error":"#REF!"}},null,null,"pF","Cpole recommended nearest standard value"]
[null,"Cff",null,null,120,null,"pF","Selected feedforward cap value"]
[null,"Rff_rec",null,{"$f":"Rfb_t/20","v":0.5},null,null,"kΩ","Recommended feedforward resistor"]
[null,"Rff_rec_std",null,{"$f":"(IF((10^(LOG(D125)-INT(LOG(D125)))*100)-VLOOKUP((10^(LOG(D125)-INT(LOG(D125)))*100),E96_s:E96_f,1)<VLOOKUP((10^(LOG(D125)-INT(LOG(D125)))*100),E96_s:E96_f,2)-(10^(LOG(D125)-INT(LOG(D125)))*100),VLOOKUP((10^(LOG(D125)-INT(LOG(D125)))*100),E96_s:E96_f,1),VLOOKUP((10^(LOG(D125)-INT(LOG(D125)))*100),E96_s:E96_f,2)))*10^INT(LOG(D125))/100","v":0.49900000000000005},null,null,"kΩ","Selected feedforward resistor value"]
[null,"Rff",null,null,0.5,null,"kΩ","Selected feedforward resistor value"]
[null,"fz_cff",null,null,null,{"$f":"IF(Cff<>0,1/(2*PI()*Cff*0.000000001*(Rfb_t+Rff)*1000),\"N/A\")","v":126.31344689832964},"kHz","Frequency of zero added by the feedforward cap"]
[null,"Select the Soft Start Time, Current Limit and Ramp (MODE pin)"]
[null,"I_lim_rec",null,{"$f":"IF(F52>OC_low_min, \"High\", \"Low\")","v":{"$error":"#REF!"}},null,null,null,"Recommended Ilim selection"]
[null,"I_lim_tgt","High",null,null,null,null,"Target Ilim"]
[null,"fsw_div_fLC",null,{"$f":"IF(f_ESR_bulk>fsw_select/10,fsw_select/f_LC,fsw_select/(1/(2*PI()*SQRT(Lout_H*Cout_cer_eff_F))*10^-3))","v":{"$error":"#REF!"}},null,null,null,"Used to set ramp recommendation"]
[null,"Ramp_rec",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,"pF","Recommended ramp selection"]
[null,"Ramp_tgt",4,null,null,null,"pF","Target ramp"]
[null,"Soft_start_time_tgt",1,null,null,null,"ms","Target soft start time"]
[null,"R_mode_rec",null,{"$f":"IF(C30=\"No\", VLOOKUP(CONCATENATE(C131, C134, C135),#REF!, 6, 0), VLOOKUP(CONCATENATE(C131, C134, C135),#REF!, 7, 0))","v":{"$error":"#REF!"}},null,null,"kΩ","Recommended MODE pin resistance value"]
[null,"R_mode",null,null,11.3,null,"kΩ","Selected MODE pin resistance value"]
[null,"I_lim_sel",null,null,null,{"$f":"IF(#REF!,VLOOKUP(TRUE,#REF!,2,FALSE),\"Invalid Rmode\")","v":{"$error":"#REF!"}},null,"Selected Ilim"]
[null,"Ramp_sel",null,null,null,{"$f":"IF(#REF!,VLOOKUP(TRUE,#REF!,3,FALSE),\"Invalid Rmode\")","v":{"$error":"#REF!"}},"pF","Selected ramp"]
[null,"SS_sel",null,null,null,{"$f":"IF(#REF!,VLOOKUP(TRUE,#REF!,4,FALSE),\"Invalid Rmode\")","v":{"$error":"#REF!"}},"ms","Selected soft start time"]
[null,"EN pin resistor divider"]
[null,"Vstart",4.53,null,null,null,"V","UVLO startup voltage (Red if Vstart < 1.1*Vstop)"]
[null,"UVLO_stop_rec_max",null,{"$f":"Vstart/1.1","v":4.1181818181818182},null,null,"V","Maximum recommended UVLO shutdown voltage. Limited by voltage hysteresis on EN pins."]
[null,"Vstop",4,null,null,null,"V","UVLO shutdown voltage (Red if Vstart < 1.1*Vstop)"]
[null,"Ren_t_rec",null,{"$f":"(Vstart*(EN_fall/EN_rise)-Vstop)/(I_p1*(1-EN_fall/EN_rise)+I_h)/1000","v":{"$error":"#REF!"}},null,null,"kΩ","Calculated top resistor"]
[null,"Ren_t_std",null,{"$f":"(IF((10^(LOG(D145)-INT(LOG(D145)))*100)-VLOOKUP((10^(LOG(D145)-INT(LOG(D145)))*100),E96_s:E96_f,1)<VLOOKUP((10^(LOG(D145)-INT(LOG(D145)))*100),E96_s:E96_f,2)-(10^(LOG(D145)-INT(LOG(D145)))*100),VLOOKUP((10^(LOG(D145)-INT(LOG(D145)))*100),E96_s:E96_f,1),VLOOKUP((10^(LOG(D145)-INT(LOG(D145)))*100),E96_s:E96_f,2)))*10^INT(LOG(D145))/100","v":{"$error":"#REF!"}},null,null,"kΩ","Closest 1% standard resistor value"]
[null,"Ren_t",null,null,16.899999999999999,null,"kΩ","Selected bottom resistor"]
[null,"Ren_b_calc",null,{"$f":"(Ren_t*EN_fall)/((Vstop-EN_fall)+Ren_t*I_p2)/1000","v":{"$error":"#REF!"}},null,null,"kΩ","Calculated top resistor"]
[null,"Ren_b_std",null,{"$f":"(IF((10^(LOG(D148)-INT(LOG(D148)))*100)-VLOOKUP((10^(LOG(D148)-INT(LOG(D148)))*100),E96_s:E96_f,1)<VLOOKUP((10^(LOG(D148)-INT(LOG(D148)))*100),E96_s:E96_f,2)-(10^(LOG(D148)-INT(LOG(D148)))*100),VLOOKUP((10^(LOG(D148)-INT(LOG(D148)))*100),E96_s:E96_f,1),VLOOKUP((10^(LOG(D148)-INT(LOG(D148)))*100),E96_s:E96_f,2)))*10^INT(LOG(D148))/100","v":{"$error":"#REF!"}},null,null,"kΩ","Closest 1% standard resistor value"]
[null,"Ren_b",null,null,6.04,null,"kΩ","Selected top resistor"]
[null,"Vstart_typ",null,null,null,{"$f":"EN_rise+Ren_t*(EN_rise-I_p1*Ren_b)/Ren_b","v":{"$error":"#REF!"}},"V","Estimated typical turn on voltage with selected resistors (Yellow if < Vin_min)"]
[null,"Vstart_max",null,null,null,{"$f":"EN_rise_max+Ren_t*(EN_rise_max-I_p1*Ren_b)/Ren_b","v":4.7221665562913904},"V","Estimated maximum turn on voltage with selected resistors (Yellow if < Vin_min)"]
[null,"Vstop_typ",null,null,null,{"$f":"EN_fall-(Ren_t*(I_p1*Ren_b-EN_fall+I_h*Ren_b))/Ren_b","v":{"$error":"#REF!"}},"V","Estimated typical turn off voltage with selected resistors"]
[null,"Vena max voltage",null,null,null,{"$f":"Vin_max*E150/(E147+E150)","v":4.7393199651264171},"V","Max voltage with Ren_t and Ren_b and Vinmax"]
[null,"Pen_divider",null,null,null,{"$f":"Vin_max*Vin_max/(Ren_b+Ren_t)*1000","v":14.123801220575414},"mW","Power lost in EN divider at Vin_max"]
[null,"VCC bypass capacitor, BOOT bypass capacitor, PGOOD resistor"]
[null,"Cbp_rec",null,2.2000000000000002,null,null,"µF","At least 1 µF required"]
[null,"Cbp",null,null,2.2000000000000002,null,"µF","Selected Cbp"]
[null,"Cboot_rec",null,0.1,null,null,"µF","At least 0.1µF required"]
[null,"Cboot",null,null,0.1,null,"µF","Selected Cboot"]
[null,"Rboot_rec",null,{"$f":"IF(AND(C9=\"TPS543820\",Vin_max>13.5),2.2,0)","v":0},null,null,"µF","Recommended series Rboot. Required for 8A device with Vin_max>13.5V"]
[null,"Rboot",null,null,0,null,"µF","Selected Rboot."]
[null,"Rpg_rec",null,100,null,null,"kΩ","10k-100k recommended"]
[null,"Rpg",null,null,100,null,"kΩ","Selected Rpg"]

{"sheet":"Std. R and C Values","index":9,"n_rows":99,"n_cols":17,"rows_kept":99,"cut":false,"hidden":true,"merged":[[2,4,2,5],[2,6,2,7],[9,4,9,5],[22,4,22,5],[47,4,47,5]]}
["Hide Sheet"]
[null,null,null,null,"Std. Resistors",null,null,null,null,"Capacitors"]
[null,"Enter resistor value",25,null,"E6",null,"E96",null,null,"Cap value",1500,"pF"]
[null,null,null,null,100,150,100,102,null,null,{"$f":"IF(K3*10^12<10000,IF((10^(LOG(K3*10^12)-INT(LOG(K3*10^12))))-VLOOKUP((10^(LOG(K3*10^12)-INT(LOG(K3*10^12)))),c_s1:C_f1,1)<VLOOKUP((10^(LOG(K3*10^12)-INT(LOG(K3*10^12)))),c_s1:C_f1,2)-(10^(LOG(K3*10^12)-INT(LOG(K3*10^12)))),VLOOKUP((10^(LOG(K3*10^12)-INT(LOG(K3*10^12)))),c_s1:C_f1,1),VLOOKUP((10^(LOG(K3*10^12)-INT(LOG(K3*10^12)))),c_s1:C_f1,2))*10^INT(LOG(K3*10^12)),IF((10^(LOG(K3*10^12)-INT(LOG(K3*10^12))))-VLOOKUP((10^(LOG(K3*10^12)-INT(LOG(K3*10^12)))),C_s2:C_f2,1)<VLOOKUP((10^(LOG(K3*10^12)-INT(LOG(K3*10^12)))),C_s2:C_f2,2)-(10^(LOG(K3*10^12)-INT(LOG(K3*10^12)))),VLOOKUP((10^(LOG(K3*10^12)-INT(LOG(K3*10^12)))),C_s2:C_f2,1),VLOOKUP((10^(LOG(K3*10^12)-INT(LOG(K3*10^12)))),C_s2:C_f2,2))*10^INT(LOG(K3*10^12)))*10^-12","v":1500},"pF"]
[null,"Closest E6 Value",{"$f":"(IF((10^(LOG(C3)-INT(LOG(C3)))*100)-VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E6_s:E6_f,1)<VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E6_s:E6_f,2)-(10^(LOG(C3)-INT(LOG(C3)))*100),VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E6_s:E6_f,1),VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E6_s:E6_f,2)))*10^INT(LOG(C3))/100","v":22},null,150,220,102,105]
[null,"Closest E12 Value",{"$f":"(IF((10^(LOG(C3)-INT(LOG(C3)))*100)-VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E12_s:E12_f,1)<VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E12_s:E12_f,2)-(10^(LOG(C3)-INT(LOG(C3)))*100),VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E12_s:E12_f,1),VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E12_s:E12_f,2)))*10^INT(LOG(C3))/100","v":27},null,220,330,105,107,null,"C values up to 10nF"]
[null,"Closest E24 Value",{"$f":"(IF((10^(LOG(C3)-INT(LOG(C3)))*100)-VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E24_s:E24_f,1)<VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E24_s:E24_f,2)-(10^(LOG(C3)-INT(LOG(C3)))*100),VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E24_s:E24_f,1),VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E24_s:E24_f,2)))*10^INT(LOG(C3))/100","v":24},null,330,470,107,110,null,1,1.2,{"$f":"IF((10^(LOG(K3)-INT(LOG(K3))))-VLOOKUP((10^(LOG(K3)-INT(LOG(K3)))),c_s1:C_f1,1)<VLOOKUP((10^(LOG(K3)-INT(LOG(K3)))),c_s1:C_f1,2)-(10^(LOG(K3)-INT(LOG(K3)))),VLOOKUP((10^(LOG(K3)-INT(LOG(K3)))),c_s1:C_f1,1),VLOOKUP((10^(LOG(K3)-INT(LOG(K3)))),c_s1:C_f1,2))","v":1.5}]
[null,"Closest E48 Value",{"$f":"(IF((10^(LOG(C3)-INT(LOG(C3)))*100)-VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E48_s:E48_f,1)<VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E48_s:E48_f,2)-(10^(LOG(C3)-INT(LOG(C3)))*100),VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E48_s:E48_f,1),VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E48_s:E48_f,2)))*10^INT(LOG(C3))/100","v":24.9},null,470,680,110,113,null,1.2,1.5]
[null,"Closest E96 Value",{"$f":"(IF((10^(LOG(C3)-INT(LOG(C3)))*100)-VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E96_s:E96_f,1)<VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E96_s:E96_f,2)-(10^(LOG(C3)-INT(LOG(C3)))*100),VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E96_s:E96_f,1),VLOOKUP((10^(LOG(C3)-INT(LOG(C3)))*100),E96_s:E96_f,2)))*10^INT(LOG(C3))/100","v":24.9},null,680,1000,113,115,null,1.5,1.8,null,null,null,null,"Notes:","If I use the value in column K it rounds up"]
[null,null,null,null,"E12",null,115,118,null,1.8,2.2000000000000002,null,null,null,null,null,"If I use the value in column J it rounds down"]
[null,null,null,null,100,120,118,121,null,2.2000000000000002,2.7]
[null,null,null,null,120,150,121,124,null,2.7,3.3]
[null,null,null,null,150,180,124,127,null,3.3,3.9]
[null,null,null,null,180,220,127,130,null,3.9,4.7]
[null,null,null,null,220,270,130,133,null,4.7,5.6]
[null,null,null,null,270,330,133,137,null,5.6,6.8]
[null,null,null,null,330,390,137,140,null,6.8,8.1999999999999993]
[null,null,null,null,390,470,140,143,null,8.1999999999999993,10]
[null,null,null,null,470,560,143,147,null,"C values greater than 10nF"]
[null,null,null,null,560,680,147,150,null,1,1.5,{"$f":"IF((10^(LOG(K3)-INT(LOG(K3))))-VLOOKUP((10^(LOG(K3)-INT(LOG(K3)))),C_s2:C_f2,1)<VLOOKUP((10^(LOG(K3)-INT(LOG(K3)))),C_s2:C_f2,2)-(10^(LOG(K3)-INT(LOG(K3)))),VLOOKUP((10^(LOG(K3)-INT(LOG(K3)))),C_s2:C_f2,1),VLOOKUP((10^(LOG(K3)-INT(LOG(K3)))),C_s2:C_f2,2))","v":1.5}]
[null,null,null,null,680,820,150,154,null,1.5,2.2000000000000002]
[null,null,null,null,820,1000,154,158,null,2.2000000000000002,3.3]
[null,null,null,null,"E24",null,158,162,null,3.3,4.7]
[null,null,null,null,100,110,162,165,null,4.7,6.8]
[null,null,null,null,110,120,165,169,null,6.8,10]
[null,null,null,null,120,130,169,174]
[null,null,null,null,130,150,174,178]
[null,null,null,null,150,160,178,182]
[null,null,null,null,160,180,182,187]
[null,null,null,null,180,200,187,191]
[null,null,null,null,200,220,191,196]
[null,null,null,null,220,240,196,200]
[null,null,null,null,240,270,200,205]
[null,null,null,null,270,300,205,210]
[null,null,null,null,300,330,210,215]
[null,null,null,null,330,360,215,221]
[null,null,null,null,360,390,221,226]
[null,null,null,null,390,430,226,232]
[null,null,null,null,430,470,232,237]
[null,null,null,null,470,510,237,243]
[null,null,null,null,510,560,243,249]
[null,null,null,null,560,620,249,255]
[null,null,null,null,620,680,255,261]
[null,null,null,null,680,750,261,267]
[null,null,null,null,750,820,267,274]
[null,null,null,null,820,910,274,280]
[null,null,null,null,910,1000,280,287]
[null,null,null,null,"E48",null,287,294]
[null,null,null,null,100,105,294,301]
[null,null,null,null,105,110,301,309]
[null,null,null,null,110,115,309,316]
[null,null,null,null,115,121,316,324]
[null,null,null,null,121,127,324,332]
[null,null,null,null,127,133,332,340]
[null,null,null,null,133,140,340,348]
[null,null,null,null,140,147,348,357]
[null,null,null,null,147,154,357,365]
[null,null,null,null,154,162,365,374]
[null,null,null,null,162,169,374,383]
[null,null,null,null,169,178,383,392]
[null,null,null,null,178,187,392,402]
[null,null,null,null,187,196,402,412]
[null,null,null,null,196,205,412,422]
[null,null,null,null,205,215,422,432]
[null,null,null,null,215,226,432,442]
[null,null,null,null,226,237,442,453]
[null,null,null,null,237,249,453,464]
[null,null,null,null,249,261,464,475]
[null,null,null,null,261,274,475,487]
[null,null,null,null,274,287,487,499]
[null,null,null,null,287,301,499,511]
[null,null,null,null,301,316,511,523]
[null,null,null,null,316,332,523,536]
[null,null,null,null,332,348,536,549]
[null,null,null,null,348,365,549,562]
[null,null,null,null,365,383,562,576]
[null,null,null,null,383,402,576,590]
[null,null,null,null,402,422,590,604]
[null,null,null,null,422,442,604,619]
[null,null,null,null,442,464,619,634]
[null,null,null,null,464,487,634,649]
[null,null,null,null,487,511,649,665]
[null,null,null,null,511,536,665,681]
[null,null,null,null,536,562,681,698]
[null,null,null,null,562,590,698,715]
[null,null,null,null,590,619,715,732]
[null,null,null,null,619,649,732,750]
[null,null,null,null,649,681,750,768]
[null,null,null,null,681,715,768,787]
[null,null,null,null,715,750,787,806]
[null,null,null,null,750,787,806,825]
[null,null,null,null,787,825,825,845]
[null,null,null,null,825,866,845,866]
[null,null,null,null,866,909,866,887]
[null,null,null,null,909,953,887,909]
[null,null,null,null,953,1000,909,931]
[null,null,null,null,null,null,931,953]
[null,null,null,null,null,null,953,976]
[null,null,null,null,null,null,976,1000]

{"sheet":"Extra","index":10,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Validation Options"]
[null,"Open"]
[null,"Complete"]
[null,"Not Applicable"]