{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Disclaimer","Instructions","Summary","Intel Chassis","Serverboard Config","Serverboard","Chassis","Processors","Memory","PCI","HSBP","HardDrive","Peripherals","Macro1","Revisions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":69,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions","index":1,"n_rows":40,"n_cols":1,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["        Power Budget Instructions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Press the Start button to begin using the Power Budget Tool"]

{"sheet":"Summary","index":2,"n_rows":23,"n_cols":13,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,10,17,10],[0,1,0,6],[1,0,1,1],[2,0,2,1],[3,12,3,16],[4,10,8,10]]}
["Power Budget",{"$f":"CONCATENATE(INDEX(Chassis!$I$3:$I$7,'Intel Chassis'!$C3),\" / \",INDEX(Serverboard!A$2:A$6,'Serverboard Config'!$B3) )","v":"(Select Chassis) / (Select Serverboard)"}]
["Chassis/ Power Supply / Cooling:",null,{"$f":"INDEX(Chassis!A$3:A$10,'Intel Chassis'!$C3)","v":"Select a Chassis and PSU"},null,null,null,null,null,null,null,"Config limitation table on HDD and add-in card for 550W PSU"]
["Serverboard:",null,{"$f":"INDEX(Serverboard!A$2:A$6,'Serverboard Config'!$B3)","v":"(Select Serverboard)"}]
["System Totals","+3.3V (amps)","+5V (amps)"," +12V\n(amps)"," -12V (amps)","5VSB (amps)","Total System Watts ",null,null,null,null,null,"550W PSU"]
["Processors ",{"$f":"SUM('Serverboard Config'!D4)","v":0},{"$f":"SUM('Serverboard Config'!E4)","v":0},{"$f":"SUM('Serverboard Config'!F4)","v":0},{"$f":"SUM('Serverboard Config'!G4)","v":0},{"$f":"SUM('Serverboard Config'!H4)","v":0},{"$f":"SUM('Serverboard Config'!I4)","v":0},null,null,null,"PCI/GPU","6x15W PCI/1x75w PCI"]
["PCIe Cards ",{"$f":"SUM('Serverboard Config'!D8:D14)","v":0},{"$f":"SUM('Serverboard Config'!E8:E14)","v":0},{"$f":"SUM('Serverboard Config'!F8:F14)","v":0},{"$f":"SUM('Serverboard Config'!G8:G14)","v":0},{"$f":"SUM('Serverboard Config'!H8:H14)","v":0},{"$f":"SUM('Serverboard Config'!I8:I14)","v":0},null,null,null,null,"4x15W PCI"]
["Hard Drives ",{"$f":"SUM('Intel Chassis'!E5:E5)","v":0},{"$f":"SUM('Intel Chassis'!F5:F5)","v":0},{"$f":"SUM('Intel Chassis'!G5:G5)","v":0},{"$f":"SUM('Intel Chassis'!H5:H5)","v":0},0,{"$f":"SUM('Intel Chassis'!J5:J5)","v":0},null,null,null,null,"3x15W PCI"]
["Serverboard & Memory:",{"$f":"SUM('Serverboard Config'!D6:D7)","v":0},{"$f":"SUM('Serverboard Config'!E6:E7)","v":0},{"$f":"SUM('Serverboard Config'!F6:F7)","v":0},{"$f":"SUM('Serverboard Config'!G6:G7)","v":0},{"$f":"SUM('Serverboard Config'!H6:H7)","v":0},{"$f":"SUM('Serverboard Config'!I6:I7)","v":0},null,null,null,null,"2x15W PCI"]
["Chassis & Peripherals:",{"$f":"SUM('Intel Chassis'!E3:E11)-SUM('Intel Chassis'!E5:E5)","v":0},{"$f":"SUM('Intel Chassis'!F3:F11)-SUM('Intel Chassis'!F5:F5)","v":0},{"$f":"SUM('Intel Chassis'!G3:G8)-SUM('Intel Chassis'!G5:G5)","v":0},{"$f":"SUM('Intel Chassis'!H3:H11)-SUM('Intel Chassis'!H5:H5)","v":0},{"$f":"SUM('Intel Chassis'!I3:I11)-SUM('Intel Chassis'!I5:I5)","v":0},{"$f":"'Intel Chassis'!J14-'Intel Chassis'!J5","v":0},null,null,null,null,"1x15W PCI"]
["System Totals:",{"$f":"SUM(B5:B9)","v":0},0,0,0,0,0,null,null,null,"HDD","24x2.5\" HDD/12x3.5\" HDD"]
["Power Supply Limits:",{"$f":"INDEX(Chassis!B$3:B$7,'Intel Chassis'!$C3)","v":0},{"$f":"INDEX(Chassis!C$3:C$7,'Intel Chassis'!$C3)","v":0},{"$f":"INDEX(Chassis!D$3:D$7,'Intel Chassis'!$C3)","v":0},{"$f":"INDEX(Chassis!E$3:E$7,'Intel Chassis'!$C3)","v":0},{"$f":"INDEX(Chassis!F$3:F$7,'Intel Chassis'!$C3)","v":0},{"$f":"INDEX(Chassis!G$3:G$7,'Intel Chassis'!$C3)","v":0},null,null,null,null,"16x2.5\" HDD/8x3.5\" HDD"]
["Margins to Limit:",{"$f":"B11-B10","v":0},0,0,0,0,0,{"$f":"IF(OR(OR(OR(B12<0,C12<0),OR(D12<0,E12<0)),G12<0),\"<-- Limits Exceeded!\",\"\")","v":""},null,null,null,"14x2.5\" HDD/7x3.5\" HDD"]
["Other Power Supply",{"$f":"PS2_3.3-SB3.3-Sys3.3","v":{"$error":"#REF!"}},{"$f":"PS2_5-_sb5-_Sys5","v":{"$error":"#REF!"}},{"$f":"PS2_12-_sb12-_Sys12","v":{"$error":"#REF!"}},{"$f":"PS2_12neg-sb12Neg-Sys12Neg","v":{"$error":"#REF!"}},null,{"$f":"PS2CombLim - Sys3.3*3.3 - _Sys5*5 - SB3.3*3.3 - _sb5*5 - _Sys12*12 - _sb12*12","v":{"$error":"#REF!"}},null,null,null,null,"12x2.5\" HDD/6x3.5\" HDD"]
["Negative margins show configuration exceeds a specified limit.",null,null,null,null,null,null,null,null,null,null,"10x2.5\" HDD/5x3.5\" HDD"]
[null,null,null,null,null,null,null,null,null,null,null,"8x2.5\" HDD/4x3.5\" HDD"]
[null,null,null,null,null,null,null,null,null,null,null,"6x2.5\" HDD/3x3.5\" HDD"]
[null,null,null,null,null,"110V","220V",null,null,null,null,"4x2.5\" HDD/2x3.5\" HDD"]
[null,null,null,null,"Estimated Worst Case Inlet Power:",{"$f":"PowerTotal/ (INDEX(Chassis!$J$3:$J$7,'Intel Chassis'!$C3)+0.001)","v":0},{"$f":"PowerTotal / (INDEX(Chassis!$K$3:$K$7,'Intel Chassis'!$C3)+0.001)","v":0}," (Watts)",null,null,null,"2x2.5\" HDD/1x3.5\" HDD"]
[null,null,null,null,"Estimated Worst Case Inlet Current:",{"$f":"F18/110","v":0},{"$f":"G18/220","v":0}," (Amps)"]
[null,null,null,null,"Estimated Worst Case Thermal Dissipation:",{"$f":"F18*3.41","v":0},{"$f":"G18*3.41","v":0}," (BTU/Hr)",null,null,"Note:","This config limitation table is suitable for all MBs which support 550w PSU."]
[null,null,null,null,null,null,null,null,null,null,null,"The table figure out recommended config base on conservative data, which concerned almost of HDDs types and different status."]
[null,null,null,null,null,null,null,null,null,null,null,"System have risk to support 8x3.5\" HDD + 30w add-in card, risk core: 4 (Medium to Low)"]
[{"$f":"Revisions!A1","v":"Version 1.0 - 12/22/2017"},null,null,null,null,null,null,null,null,null,null,"System have risk to support 8x3.5\" HDD + 45w add-in card, risk code: 2 (Medium to High)"]

{"sheet":"Intel Chassis","index":3,"n_rows":18,"n_cols":12,"rows_kept":18,"cut":false,"hidden":false,"merged":[[4,10,6,10]]}
["Power Budget",null,{"$f":"CONCATENATE(INDEX(Chassis!$I$3:$I$7,C3), \" System Configuration\")","v":"(Select Chassis) System Configuration"}]
["System Feature",null,"Description","Qty","+3.3V (amps)","+5V (amps)"," +12V(amps)","-12V\n(amps)"," 5V stby (amps)","Power\n(watts)"]
["Chassis&PSU:",null,1,null,null,null,{"$f":"INDEX(Chassis!$H$3:$H$10,C3)","v":0},null,null,{"$f":"E3*3.3+F3*5+(G3+H3)*12+I3*5","v":0},"Includes System Fans"]
["HSBP (Backplane):",null,1,0,{"$f":"INDEX(HSBP!B2:B9,$C4) *$D4","v":0},{"$f":"INDEX(HSBP!C2:C9,$C4) *$D4","v":0},{"$f":"INDEX(HSBP!D2:D9,$C4) *$D4","v":0},{"$f":"INDEX(HSBP!E2:E9,$C4) *$D4","v":0},{"$f":"INDEX(HSBP!F2:F9,$C4) *$D4","v":0},{"$f":"E4*3.3+F4*5+(G4+H4)*12+I4*5","v":0},{"$f":"INDEX(L8:L11,$C4)","v":"Max 8 SATA HDD/SSD support"}]
["1st HDD/SSD Type:",null,1,0,{"$f":"INDEX(HardDrive!B2:B12,$C5) *$D5","v":0},{"$f":"INDEX(HardDrive!C2:C12,$C5) *$D5","v":0},{"$f":"INDEX(HardDrive!D2:D12,$C5) *$D5","v":0},null,null,{"$f":"E5*3.3+F5*5+(G5+H5)*12+I5*5","v":0},"Attention Not to Exceed Maximum drive support qty"]
["2nd HDD/SSD Type:",null,1,0,{"$f":"INDEX(HardDrive!B2:B12,$C6) *$D6","v":0},{"$f":"INDEX(HardDrive!C2:C12,$C6) *$D6","v":0},{"$f":"INDEX(HardDrive!D2:D12,$C6) *$D6","v":0},null,null,{"$f":"E6*3.3+F6*5+(G6+H6)*12+I6*5","v":0}]
["3rd HDD/SSD Type",null,1,0,{"$f":"INDEX(HardDrive!B2:B12,$C7) *$D7","v":0},{"$f":"INDEX(HardDrive!C2:C12,$C7) *$D7","v":0},{"$f":"INDEX(HardDrive!D2:D12,$C7) *$D7","v":0},null,null,{"$f":"E7*3.3+F7*5+(G7+H7)*12+I7*5","v":0}]
["USB: ",null,1,0,{"$f":"INDEX(HardDrive!B17:B21,$C8) *$D8","v":0},{"$f":"INDEX(HardDrive!C17:C21,$C8) *$D8","v":0},null,null,null,{"$f":"E8*3.3+F8*5+(G8+H8)*12+I8*5","v":0},null,"Max 8 SATA HDD/SSD support"]
["External Bay 1:",null,1,0,{"$f":"INDEX(Peripherals!B$3:B$7,$C9) *$D9","v":0},{"$f":"INDEX(Peripherals!C$3:C$7,$C9) *$D9","v":0},{"$f":"INDEX(Peripherals!D$3:D$7,$C9) *$D9","v":0},null,{"$f":"INDEX(Peripherals!E$3:E$7,$C9) *$D9","v":0},0,null,"Max 2pcs HSBP support,  Max 4pcs 2.5\" SAS/SATA HDD/SSD support per one HSBP"]
["External Bay 2:",null,1,0,{"$f":"INDEX(Peripherals!B$3:B$7,$C10) *$D10","v":0},{"$f":"INDEX(Peripherals!C$3:C$7,$C10) *$D10","v":0},{"$f":"INDEX(Peripherals!D$3:D$7,$C10) *$D10","v":0},null,{"$f":"INDEX(Peripherals!E$3:E$7,$C10) *$D10","v":0},0,null,"Max 4pcs PCIe SSD + 4pcs 2.5\" SAS/SATA HDD/SSD support"]
["Other device 1:",null,1,0,{"$f":"INDEX(Peripherals!B$3:B$7,$C11) *$D11","v":0},{"$f":"INDEX(Peripherals!C$3:C$7,$C11) *$D11","v":0},{"$f":"INDEX(Peripherals!D$3:D$7,$C11) *$D11","v":0},null,{"$f":"INDEX(Peripherals!E$3:E$7,$C11) *$D11","v":0},0,"Max 1 RAID Expander Module","Max 2pcs HSBP support,  Max 4pcs 2.5/3.5\" SAS/SATA HDD/SSD support per one HSBP"]
["Other device 2:",null,1,0,{"$f":"INDEX(Peripherals!B$3:B$7,$C12) *$D12","v":0},{"$f":"INDEX(Peripherals!C$3:C$7,$C12) *$D12","v":0},{"$f":"INDEX(Peripherals!D$3:D$7,$C12) *$D12","v":0},null,{"$f":"INDEX(Peripherals!E$3:E$7,$C12) *$D12","v":0},{"$f":"E12*3.3+F12*5+(G12+H12)*12+I12*5","v":0},"Max 2 M.2 drives"]
[]
[null,null,"Subtotal System (A):",null,{"$f":"SUM(E3:E11)","v":0},0,0,0,0,0]
[null,null,"Total System usage (A):",null,{"$f":"Summary!B10","v":0},{"$f":"Summary!C10","v":0},{"$f":"Summary!D10","v":0},{"$f":"Summary!E10","v":0},{"$f":"Summary!F10","v":0},{"$f":"Summary!G10","v":0}]
[null,null,"Power Supply Limits (A):",null,{"$f":"Summary!B11","v":0},{"$f":"Summary!C11","v":0},{"$f":"Summary!D11","v":0},{"$f":"Summary!E11","v":0},{"$f":"Summary!F11","v":0},{"$f":"Summary!G11","v":0}]
[null,null,"Margins compared to Limits:",null,{"$f":"Summary!B12","v":0},{"$f":"Summary!C12","v":0},{"$f":"Summary!D12","v":0},{"$f":"Summary!E12","v":0},{"$f":"Summary!F12","v":0},{"$f":"Summary!G12","v":0},{"$f":"IF(OR(OR(M102<0,F17<0),OR(G17<0,J17<0)),\"<-- Limits Exceeded!\",\"<--System Margins\")","v":"<--System Margins"}]
["System Margins so far:",null,null,null,"3.3V","5V","12V","12V","12V","W"]

{"sheet":"Serverboard Config","index":4,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,8]]}
["Power Budget",{"$f":"CONCATENATE(INDEX(Serverboard!A$2:A$6,$B3),\" Serverboard Configuration\")","v":"(Select Serverboard) Serverboard Configuration"},null,null,null,null,null,null,null,null,"VRM Efficiency"]
["Serverboard Feature","Description",null,"+3.3V (amps)","+5V (amps)"," +12V (amps)"," -12V (amps)","5V \nstby (amps)","Power (watts)",null,0.84]
["Serverboard:",1,null,{"$f":"INDEX(Serverboard!B$2:B$6,$B3)","v":0},{"$f":"INDEX(Serverboard!C$2:C$6,$B3)","v":0},{"$f":"INDEX(Serverboard!D$2:D$6,$B3)","v":0},{"$f":"INDEX(Serverboard!E$2:E$6,$B3)","v":0},{"$f":"INDEX(Serverboard!F$2:F$6,$B3)","v":0},{"$f":"INDEX(Serverboard!G$2:G$6,$B3)","v":0}]
["Processors:",1,1,null,null,{"$f":"IF(C5=1,INDEX(Processors!B$2:B$56,$B4)/12/VRMefficiency,(C4-1)*INDEX(Processors!B$2:B$56,$B4)*0.85/12/VRMefficiency)","v":0},null,null,{"$f":"F4*12+E4*5","v":0},"*This line includes correction factors."]
[]
[]
["Memory:",1,1,null,null,{"$f":"INDEX(Memory!D$2:D$16,$B7)*INDEX(Memory!A$29:A$45,$C7)*0.9*0.78","v":0},null,null,{"$f":"D7*3.3+E7*5+F7*12+G7*12+H7*5","v":0},"*This line includes correction factors (utilization & VR eff)."]
[]
["PCI Slot 1",1,null,{"$f":"INDEX(PCI!B$2:B$15,$B9)","v":0},{"$f":"INDEX(PCI!C$2:C$15,$B9)","v":0},{"$f":"INDEX(PCI!D$2:D$15,$B9)","v":0},{"$f":"INDEX(PCI!E$2:E$15,$B9)","v":0},{"$f":"INDEX(PCI!F$2:F$15,$B9)","v":0},{"$f":"D9*3.3+E9*5+F9*12+G9*12+H9*5","v":0}]
["PCI Slot 2",1,null,{"$f":"INDEX(PCI!B$2:B$15,$B10)","v":0},{"$f":"INDEX(PCI!C$2:C$15,$B10)","v":0},{"$f":"INDEX(PCI!D$2:D$15,$B10)","v":0},{"$f":"INDEX(PCI!E$2:E$15,$B10)","v":0},{"$f":"INDEX(PCI!F$2:F$15,$B10)","v":0},0]
["PCI Slot 3",1,null,{"$f":"INDEX(PCI!B$2:B$15,$B11)","v":0},{"$f":"INDEX(PCI!C$2:C$15,$B11)","v":0},{"$f":"INDEX(PCI!D$2:D$15,$B11)","v":0},{"$f":"INDEX(PCI!E$2:E$15,$B11)","v":0},{"$f":"INDEX(PCI!F$2:F$15,$B11)","v":0},0]
["PCI Slot 4",1,null,{"$f":"INDEX(PCI!B$2:B$15,$B12)","v":0},{"$f":"INDEX(PCI!C$2:C$15,$B12)","v":0},{"$f":"INDEX(PCI!D$2:D$15,$B12)","v":0},{"$f":"INDEX(PCI!E$2:E$15,$B12)","v":0},{"$f":"INDEX(PCI!F$2:F$15,$B12)","v":0},0]
["PCI Slot 5",1,null,{"$f":"INDEX(PCI!B$2:B$15,$B13)","v":0},{"$f":"INDEX(PCI!C$2:C$15,$B13)","v":0},{"$f":"INDEX(PCI!D$2:D$15,$B13)","v":0},{"$f":"INDEX(PCI!E$2:E$15,$B13)","v":0},{"$f":"INDEX(PCI!F$2:F$15,$B13)","v":0},0]
["PCI Slot 6",1,null,{"$f":"INDEX(PCI!B$2:B$15,$B14)","v":0},{"$f":"INDEX(PCI!C$2:C$15,$B14)","v":0},{"$f":"INDEX(PCI!D$2:D$15,$B14)","v":0},{"$f":"INDEX(PCI!E$2:E$15,$B14)","v":0},{"$f":"INDEX(PCI!F$2:F$15,$B14)","v":0},0]
[null,"SubTotals (A):",null,{"$f":"SUM(D4:D14)","v":0},{"$f":"SUM(E4:E14)","v":0},{"$f":"SUM(F4:F14)","v":0},{"$f":"SUM(G4:G14)","v":0},{"$f":"SUM(H4:H14)","v":0}]
[null,"SubTotal Serverboard Power (W):",null,{"$f":"(D15)*3.3","v":0},{"$f":"(E15)*5","v":0},{"$f":"(F15)*12","v":0},{"$f":"(G15)*12","v":0},{"$f":"(H15)*5","v":0},{"$f":"SUM(D16:H16)","v":0}]
[null,"Total System usage (A):",null,{"$f":"Summary!B10","v":0},{"$f":"Summary!C10","v":0},{"$f":"Summary!D10","v":0},{"$f":"Summary!E10","v":0},{"$f":"Summary!F10","v":0},{"$f":"Summary!G10","v":0}]
[null,"Power Supply Limits (A):",null,{"$f":"Summary!B11","v":0},{"$f":"Summary!C11","v":0},{"$f":"Summary!D11","v":0},{"$f":"Summary!E11","v":0},{"$f":"Summary!F11","v":0},{"$f":"Summary!G11","v":0}]
[null,null,"Margin compared to Limits:",{"$f":"Summary!B12","v":0},{"$f":"Summary!C12","v":0},{"$f":"Summary!D12","v":0},{"$f":"Summary!E12","v":0},{"$f":"Summary!F12","v":0},{"$f":"Summary!G12","v":0},{"$f":"IF(OR(OR(OR(D19<0,E19<0),OR(F19<0,G19<0)),A19<0),\"<-- Limits Exceeded!\",\"<--System Margins\")","v":"<--System Margins"}]

{"sheet":"Serverboard","index":5,"n_rows":6,"n_cols":8,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Serverboard","3.3V","5V","12V","-12V","5VSB","W"]
["(Select Serverboard)",null,null,null,null,null,{"$f":"B2*3.3+C2*5+D2*12+E2*12 + F2*5","v":0}]
["Intel® Server Board S2600STB",2.8,1.6,4.8,0,0,74.839999999999989]
["Intel® Server Board S2600STQ",2.8,1.6,5.3,0,0,{"$f":"B4*3.3+C4*5+D4*12+E4*12 + F4*5","v":80.839999999999989}]
["User Definable",null,null,null,null,null,0,"<-- Define Custom Numbers Here"]
["User Definable",null,null,null,null,null,0,"<-- Define Custom Numbers Here"]

{"sheet":"Chassis","index":6,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,6]]}
["Chassis","Power supply limits",null,null,null,null,null,"Fans","Product Name","PS Efficiency","PS Efficiency"]
["Selection","3V","5V","12V"," -12V","5VSB","Watts",null,null,"110V","220V"]
["Select a Chassis and PSU",null,null,null,null,null,null,null,"(Select Chassis)"]
["P4304XXMUXX with 750W PSU",25,25,{"$f":"750/12","v":62.5},0.5,4.28,750,8.65,"P4304XXMUXX with 750W PSU",0.8,0.8]
["P4304XXMUXX with 1600W PSU",25,25,133.33000000000001,0.5,4.28,1600,8.65,"P4304XXMUXX with 1600W PSU",0.8,0.8]
["P4304XXMFEN2 with 550W PSU",18,15,66,0.5,3,550,4.9000000000000004,"P4304XXMFEN2 with 550W PSU",0.88,0.88]
[null,null,null,null,null,null,null,null,null,null,null,"<-- Define Custom Numbers Here"]
[null,null,null,null,null,null,null,null,null,null,null,"<-- Define Custom Numbers Here"]
[null,null,null,null,null,null,null,null,null,null,null,"<-- Define Custom Numbers Here"]
[null,null,null,null,null,null,null,null,null,null,null,"<-- Define Custom Numbers Here"]

{"sheet":"Processors","index":7,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Processor Types","TDP (W)","Source",null,"VRM#1","VRM#2"]
["(Select a Processor)",null,null,null,"5V VRM","12V VRM"]
["Intel® Xeon® Platinum 8168 Processor (205W)",205,null,null,"12V VRM","None"]
["Intel® Xeon® Platinum 8180 Processor (205W)",205,null,null,"None"]
["Intel® Xeon® Gold 6154 Processor (200W)",200]
["Intel® Xeon® Platinum 8170 Processor (165W)",165]
["Intel® Xeon® Platinum 8176 Processor (165W)",165]
["Intel® Xeon® Gold 6146 Processor (165W)",165]
["Intel® Xeon® Gold 6150 Processor (165W)",165]
["Intel® Xeon® Platinum 8158 Processor (150W)",150]
["Intel® Xeon® Platinum 8160 Processor (150W)",150]
["Intel® Xeon® Platinum 8160T Processor (150W)",150]
["Intel® Xeon® Platinum 8164 Processor (150W)",150]
["Intel® Xeon® Gold 6136 Processor (150W)",150]
["Intel® Xeon® Gold 6142 Processor (150W)",150]
["Intel® Xeon® Gold 6144 Processor (150W)",150]
["Intel® Xeon® Gold 6148 Processor (150W)",150]
["Intel® Xeon® Gold 6132 Processor (140W)",140]
["Intel® Xeon® Gold 6140 Processor (140W)",140]
["Intel® Xeon® Gold 6152 Processor (140W)",140]
["Intel® Xeon® Gold 6134 Processor (130W)",130]
["Intel® Xeon® Platinum 8153 Processor (125W)",125]
["Intel® Xeon® Gold 6126 Processor (125W)",125]
["Intel® Xeon® Gold 6126T Processor (125W)",125]
["Intel® Xeon® Gold 6130 Processor (125W)",125]
["Intel® Xeon® Gold 6130T Processor (125W)",125]
["Intel® Xeon® Gold 6138 Processor (125W)",125]
["Intel® Xeon® Gold 6138T Processor (125W)",125]
["Intel® Xeon® Gold 6128 Processor (115W)",115]
["Intel® Xeon® Platinum 8156 Processor (105W)",105]
["Intel® Xeon® Gold 5118 Processor (105W)",105]
["Intel® Xeon® Gold 5120 Processor (105W)",105]
["Intel® Xeon® Gold 5120T Processor (105W)",105]
["Intel® Xeon® Gold 5122 Processor (105W)",105]
["Intel® Xeon® Gold 5115 Processor (85W)",85]
["Intel® Xeon® Gold 5119T Processor (85W)",85]
["Intel® Xeon® Silver 4108 Processor (85W)",85]
["Intel® Xeon® Silver 4110 Processor (85W)",85]
["Intel® Xeon® Silver 4112 Processor (85W)",85]
["Intel® Xeon® Silver 4114 Processor (85W)",85]
["Intel® Xeon® Silver 4114T Processor (85W)",85]
["Intel® Xeon® Silver 4116 Processor (85W)",85]
["Intel® Xeon® Silver 4116T Processor (85W)",85]
["Intel® Xeon® Bronze 3104 Processor (85W)",85]
["Intel® Xeon® Bronze 3106 Processor (85W)",85]
["Intel® Xeon® Silver 4109 Processor (70W)",70]
["User Definable",null,null,"<-- Define Custom Numbers Here"]
["User Definable",null,null,"<-- Define Custom Numbers Here"]
["User Definable",null,null,"<-- Define Custom Numbers Here"]
["User Definable",null,null,"<-- Define Custom Numbers Here"]
["User Definable",null,null,"<-- Define Custom Numbers Here"]
["User Definable",null,null,"<-- Define Custom Numbers Here"]
["User Definable",null,null,"<-- Define Custom Numbers Here"]
["User Definable",null,null,"<-- Define Custom Numbers Here"]
["User Definable",null,null,"<-- Define Custom Numbers Here"]
[null,null,null,"<-- Define Custom Numbers Here"]
[]
[]
["Processor Quantities (used for tool operation)"]
[0,0]
[1,1]
[2,2]

{"sheet":"Memory","index":8,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Memory","+3.3V","+5V","+12V","-12V","Watts"]
["(Select Memory)",null,null,0,null,{"$f":"B2*3.3+C2*5+D2*12","v":0}]
["4GB DDR4 RDIMM (4Gb, SRx8)",null,null,0.25,null,{"$f":"12*D3","v":3}]
["8GB DDR4 RDIMM (4Gb, SRx4)",null,null,0.4,null,{"$f":"12*D4","v":4.8000000000000007}]
["8GB DDR4 RDIMM (8Gb, SRx8)",null,null,0.25,null,3]
["8GB DDR4 RDIMM (4Gb, DRx8)",null,null,0.3,null,3.5999999999999996]
["16GB DDR4 RDIMM (8Gb, SRx4)",null,null,0.33333333333333331,null,4]
["16GB DDR4 RDIMM (4Gb, DRx4)",null,null,0.52500000000000002,null,6.3000000000000007]
["16GB DDR4 RDIMM (8Gb, DRx8)",null,null,0.3,null,3.5999999999999996]
["32GB DDR4 RDIMM (8Gb, DRx4)",null,null,0.52500000000000002,null,6.3000000000000007]
["32GB DDR4 LRDIMM (4Gb, QRx4)",null,null,0.8833333333333333,null,10.6]
["64GB DDR4 LRDIMM (8Gb, QRx4)",null,null,0.91666666666666663,null,11]
["User Definable",null,null,null,null,0,"<-- Define Custom Numbers Here"]
["User Definable",null,null,null,null,0,"<-- Define Custom Numbers Here"]
["User Definable",null,null,null,null,0,"<-- Define Custom Numbers Here"]
["User Definable",null,null,null,null,0,"<-- Define Custom Numbers Here"]
[]
[]
[]
["Note:"]
["DIMM power will vary depending on the # of DIMMs & the actual strees/bandwidth used."]
[]
[]
[]
[]
[]
[]
["Memory  Quantities (used for tool operation)"]
[0]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]

{"sheet":"PCI","index":9,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["PCI Add in Cards","+3.3V (A)","+5V (A)","+12V3 (A)","-12V (A)"," 5vsb (A)","W"]
["Slot Empty",0,0,0,0,0,{"$f":"E2*(-12)+D2*12+C2*5+B2*3.3","v":0}]
["PCI (5V) Typical",null,2,null,null,null,{"$f":"F3*5+E3*(12)+D3*12+C3*5+B3*3.3","v":10}]
["PCI (3V) Typical",3,null,null,null,null,9.8999999999999986]
["PCIe (3.3V / 12V) Typical",2,null,0.25,null,null,9.6]
["PCIe (3.3V / 12V) Medium",2,null,0.65,null,null,14.4]
["PCIe (3.3V / 12V) High",null,null,1.7,null,null,20.399999999999999]
["PCIe GPGPU 300W",3,null,24.18,null,null,{"$f":"F8*5+E8*(12)+D8*12+C8*5+B8*3.3","v":300.05999999999995}]
["PCIe GPGPU 225W",3,null,17.95,null,null,225.29999999999998]
["PCIe GPU 150W",3,null,11.68,null,null,150.06]
["General GPU 75W",3,null,5.43,null,null,75.06]
["PCI User Definable ",null,null,null,null,null,0,"<-- Define Custom Card Here"]
["PCI User Definable ",null,null,null,null,null,0,"<-- Define Custom Card Here"]
["PCI User Definable ",null,null,null,null,null,{"$f":"F14*5+E14*(12)+D14*12+C14*5+B14*3.3","v":0},"<-- Define Custom Card Here"]
["PCI User Definable ",null,null,null,null,null,{"$f":"F15*5+E15*(12)+D15*12+C15*5+B15*3.3","v":0},"<-- Define Custom Card Here"]

{"sheet":"HSBP","index":10,"n_rows":57,"n_cols":9,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["Backplane","+3.3V (A)","+5V (A)","+12 (A)","-12V (A)"," 5vsb (A)","W"]
["Select Backplane",0,0,0,0,0,{"$f":"E2*(-12)+D2*12+C2*5+B2*3.3","v":0}]
["8x2.5\" HSBP AUP8X25S3DPDK",0,0,0.12,0,0,{"$f":"F3*5+E3*(12)+D3*12+C3*5+B3*3.3","v":1.44}]
["8x2.5\" HSBP Combo FXX8X25S3PHBP",0,0,0.14000000000000001,0,0,1.6800000000000002]
["4x3.5\" HSBP FUP4X35S3HSBP",0,0.34,0.1,0,0,2.9000000000000004]
["User Definable",null,null,null,null,null,0,"<-- Define Custom Card Here"]
["User Definable",null,null,null,null,null,0,"<-- Define Custom Card Here"]
["User Definable",null,null,null,null,null,0,"<-- Define Custom Card Here"]
["User Definable",null,null,null,null,null,0,"<-- Define Custom Card Here"]
[]
[]
[]
[]
["4U 8x3.5 HSBP"]
["Function","Sch Page","P3V3, Max","5V, Max","12V, Max","Comments:",null,"5V, Max","12V, Max"]
["3.5\" SATA/SAS HDD",null,null,null,null,"No derating, doesn't include spinup power",null,6.4,8.8000000000000007]
["3.3V LR (from 5V)",null,null,0.24299999999999999,null,"MIC69153, up to 0.8A load current, 66% efficiency"]
["Reset Timer",null,0.02,null,null,"ADM809"]
["FRU EEPROM",null,5.0000000000000001E-3,null,null,"AT24C64"]
["Temp Sensor",null,0.01,null,null,"TMP75"]
["SPI Flash",null,0.03,null,null,"SST25LF080A"]
["HSBP Microcontroller",null,5.5E-2,null,null,"PSoC"]
["LED drivers (Act/Fault)",null,0.1,null,null,"74LVC07, Assumes 10mA per LED"]
["Misc Pullups",null,3.7999999999999999E-2]
["Total Current, A",null,{"$f":"SUM(C16:C24)","v":0.25800000000000001},{"$f":"SUM(D16:D24)","v":0.24299999999999999},{"$f":"SUM(E16:E24)","v":0}]
["Total Power, W",null,{"$f":"C25*3.3","v":0.85139999999999993},{"$f":"D25*5","v":1.2149999999999999},{"$f":"E25*12","v":0},{"$f":"(C26/0.85+D26/0.85+E26)/12","v":0.20258823529411762}]
[]
[]
["4U 8x2.5 HSBP"]
["Function","Sch Page","P3V3, Max","5V, Max","12V, Max","Comments:",null,"5V, Max","12V, Max"]
["2.5\" SATA/SAS HDD",null,null,null,null,"No derating, doesn't include spinup power",null,6.4,3.2]
["5V Switcher (from 12V)",null,null,null,null,"SC417, ~90% estimated efficiency",null,null,3.0760000000000001]
["3.3V LR (from 5V)",null,null,0.24299999999999999,null,"MIC69135, up to 0.8A load current, 66% efficiency"]
["Reset Timer",null,0.02,null,null,"ADM809"]
["FRU EEPROM",null,5.0000000000000001E-3,null,null,"AT24C64"]
["Temp Sensor",null,0.01,null,null,"TMP75"]
["SPI Flash",null,0.03,null,null,"SST25LF080A"]
["HSBP Microcontroller",null,5.5E-2,null,null,"PSoC"]
["LED drivers (Act/Fault)",null,0.1,null,null,"74LVC07, Assumes 10mA per LED"]
["Misc Pullups",null,3.7999999999999999E-2]
["Total Current, A",null,{"$f":"SUM(C31:C40)","v":0.25800000000000001},{"$f":"SUM(D31:D40)","v":0.24299999999999999},{"$f":"SUM(E31:E40)","v":0}]
["Total Power, W",null,{"$f":"C41*3.3","v":0.85139999999999993},{"$f":"D41*5","v":1.2149999999999999},{"$f":"E41*12","v":0},{"$f":"(C42/0.85+D42/0.85+E42)/12","v":0.20258823529411762}]
[]
[]
["4U 4x3.5 HSBP"]
["Function","Sch Page","P3V3, Max","5V, Max","12V, Max","Comments:",null,"5V, Max","12V, Max"]
["3.5\" SATA/SAS HDD",null,null,null,null,"No derating, doesn't include spinup power",null,3.2,4.4000000000000004]
["3.3V LR (from 5V)",null,null,0.24299999999999999,null,"MIC69153, up to 0.8A load current, 66% efficiency"]
["Reset Timer",null,0.02,null,null,"ADM809"]
["FRU EEPROM",null,5.0000000000000001E-3,null,null,"AT24C64"]
["Temp Sensor",null,0.01,null,null,"TMP75"]
["SPI Flash",null,0.03,null,null,"SST25LF080A"]
["HSBP Microcontroller",null,5.5E-2,null,null,"PSoC"]
["LED drivers (Act/Fault)",null,0.1,null,null,"74LVC07, Assumes 10mA per LED"]
["Misc Pullups",null,3.7999999999999999E-2]
["Total Current, A",null,{"$f":"SUM(C47:C55)","v":0.25800000000000001},{"$f":"SUM(D47:D55)","v":0.24299999999999999},{"$f":"SUM(E47:E55)","v":0}]
["Total Power, W",null,{"$f":"C56*3.3","v":0.85139999999999993},{"$f":"D56*5","v":1.2149999999999999},{"$f":"E56*12","v":0},{"$f":"(C57/0.85+D57/0.85+E57)/12","v":0.20258823529411762}]

{"sheet":"HardDrive","index":11,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Hard Drive & SSD","Amps of +3.3V","Amps of +5V","Amps of +12V3","W"]
["Select Drives, Only SATA HDD/SSD supported if no HSBP",null,null,null,{"$f":"C2*5+D2*12","v":0}]
["3.5\" SAS Typical Power (15W)",null,0.8,0.92,15.040000000000001]
["2.5\" SAS Typical Power (9W)",null,0.81,0.41,8.9700000000000006]
["3.5\" SATA Typical Power (12W)",null,0.5,0.8,12.100000000000001]
["2.5\" SATA Typical Power (5W)",null,1,0,5]
["2.5\" PCIe SSD U.2 (25 W)",null,null,2.08,{"$f":"C7*5+D7*12","v":24.96}]
["2.5\" SATA SSD (8W)",null,0.96,0.25,{"$f":"C8*5+D8*12","v":7.8}]
["2.5\" SATA SSD (12W)",null,0.94,0.67500000000000004,{"$f":"C9*5+D9*12","v":12.8}]
["User Definable",null,null,null,{"$f":"C10*5+D10*12","v":0},"<-- Define Custom Device Here"]
["User Definable",null,null,null,0,"<-- Define Custom Device Here"]
["User Definable",null,null,null,0,"<-- Define Custom Device Here"]
[]
[]
[]
["USB Device","Amps of +3.3V","Amps of +5V","Amps of +12V3","W"]
["Select USB drives",null,null,null,{"$f":"C17*5+D17*12","v":0}]
["USB3.0 typical drive 2W",null,0.33800000000000002,0,1.6900000000000002]
["USB2.0 Typical drive",null,0.2,0,1]
["User Definable",null,null,null,0,"<-- Define Custom Device Here"]
["User Definable",null,null,null,0,"<-- Define Custom Device Here"]

{"sheet":"Peripherals","index":12,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Misc Peripherals","Amps of +3.3V","Amps of +5V","Amps of +12V","Amps of 5vsb","Watts"]
["ODD Bay Devices:"]
["Empty"]
["CDROM",null,0.4,0.7,null,{"$f":"B4*3.3+C4*5+D4*12+E4*5","v":10.399999999999999}]
["Tape Drive",null,0.77,0.4,null,{"$f":"B5*3.3+C5*5+D5*12+E5*5","v":8.65}]
["User Definable",null,null,null,null,{"$f":"B6*3.3+C6*5+D6*12+E6*5","v":0},"<-- Define Custom Peripherals Here"]
["User Definable",null,null,null,null,{"$f":"B7*3.3+C7*5+D7*12+E7*5","v":0},"<-- Define Custom Peripherals Here"]
[]
[]
[]
[]
[]
["Misc Peripherals","Amps of +3.3V","Amps of +5V","Amps of +12V","Amps of 5vsb","Watts"]
["Empty"]
["M.2",1.5,null,null,null,{"$f":"B15*3.3+C15*5+D15*12+E15*5","v":4.9499999999999993}]
["RAID Expander Module",null,null,1.34,null,{"$f":"B16*3.3+C16*5+D16*12+E16*5","v":16.080000000000002}]
["User Definable",null,null,null,null,{"$f":"B17*3.3+C17*5+D17*12+E17*5","v":0},"<-- Define Custom Peripherals Here"]
["User Definable",null,null,null,null,{"$f":"B18*3.3+C18*5+D18*12+E18*5","v":0},"<-- Define Custom Peripherals Here"]

{"sheet":"Macro1","index":13,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Revisions","index":14,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Version 1.0 - 12/22/2017","<=== Linked to Summary Tab."]
[]
["Date","Rev","Notes","Init"]
["2014-08-15",1,"Initial Release","LJ"]
["2016-01-28",1,"Add CWP 2S and TS SKU","LJ"]
["2016-06-03",1.1000000000000001,"Add BDW CPUs, etc","Jessica"]
["2017-12-22",1,"Initial release: STP adjustment, CPU, memory, HSBP update, SAS and RAID controllers added, MB specs","eperezag"]