{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["BTS Overview","BTS XS to L","BTS NVR MWIE","Data","PriceList","iLO Info","Working notes-updated needed"],"not_rendered":{"charts":0,"images":10,"macros":1,"external_links":0,"defined_names":77,"comments":2,"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":"BTS Overview","index":0,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,0,1,8],[0,0,0,8],[2,0,2,8],[7,0,7,8],[4,0,4,8],[5,0,5,8],[6,3,6,4],[6,5,6,7]]}
["Kaiser Permanente Information Technology\nTrace3 BTS - Build To Stock\nMaster Order List (MOL) "]
[{"$f":"_xlfn.CONCAT(\"Version \",Version,\" \",MONTH(Version_Date),\"/\",DAY(Version_Date),\"/\",YEAR(Version_Date))","v":"Version V1.071 9/23/2021"}]
["For Windows Server Consultation, please submit Service Request to IMG SI Wintel Engineering \nhttp://xmws.kp.org/pages/services/consulting.htm\nOr contact Sudipta Dutta-Roy at (925) 239 5702 M, Sudipta.Dutta-Roy@kp.org"]
[]
["For Linux Server Consultation, please submit Service Request to IMG SDI Midrange Linux\n or contact Scott J Kurtz at (925) 924-5182,  Scott.J.Kurtz@kp.org \nLink to Linux FFU page: https://sites.sp.kp.org/teams/sdi/ccs/cmdp/SitePages/Home.aspx"]
["Trace3 contacts"]
["Andrea Wolf\n+1 408-718-5510\nawolf@trace3.com","James Franklin\n+1-424-237-5205\njames@trace3.com","ISR Team at Trace3\nDL-OTOV-ISR@trace3.com\n","Andrea McKnight\n+713-300-3503\nAndrea.McKnight@trace3.com",null,"Steve Stierwalt\n+1-408-513-4460\nsteven.stierwalt@trace3.com"]
["BTS configurations"]
["BTS Size - click to configure this model","Chassis","Processor (Dual Processor)","Total Memory","Part#","Boot Drives","Default FlexLOM","Power Supplies","Rail Kit"]
[{"$f":"BTS_Size_Def[]","v":"BTS xSmall MWIE-NVR"},"DL380 Gen10 12LFF 16 Core","Xeon-Silver 4215R (3.2GHz/8-core/130W)","128GB","Memory - 1R-128GB","2x480GB RI SSD","366FLR","2x800W","HPE 2U Large Form Factor Ball Bearing Rail Kit"]
["BTS xSmall","DL380 Gen10 8SFF 8 Core","Xeon-Gold 5222 (3.8GHz/4-core/105W) ","128GB","Memory- 2R -128GB","2x480GB RI SSD","366FLR","2x800W","HPE 2U Small Form Factor Ball Bearing Rail Kit"]
["BTS Small","DL380 Gen10 8SFF 16 Core","Xeon-Gold 6234 (3.3GHz/8-core/130W)","256GB","Memory-256GB","2x480GB RI SSD","366FLR","2x800W","HPE 2U Small Form Factor Ball Bearing Rail Kit"]
["BTS Medium","DL380 Gen10 8SFF 32 Core","Xeon-Gold 6226R (2.9GHz/16-core/150W)","384GB","Memory-384GB","2x480GB RI SSD","366FLR","2x800W","HPE 2U Small Form Factor Ball Bearing Rail Kit"]
["BTS Large","DL380 Gen10 8SFF 48 Core","Xeon-Gold 6248R (3.0GHz/24-core/205W)","768GB","Memory-768GB","2x480GB RI SSD","366FLR","2x800W","HPE 2U Small Form Factor Ball Bearing Rail Kit"]

{"sheet":"BTS XS to L","index":1,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,1,0,7],[38,4,38,5],[44,4,44,5],[9,2,9,3],[43,1,43,2],[43,3,43,4],[7,2,7,7],[8,2,8,7],[3,2,3,4],[4,2,4,4],[5,2,5,4],[6,2,6,4]]}
[{"$f":"\"Version and Version Date \" & CHAR(10) &\n _xlfn.CONCAT(Version,\"  \",MONTH(Version_Date),\"-\",DAY(Version_Date),\" \",YEAR(Version_Date))","v":"Version and Version Date \nV1.071  9-23 2021"},"Kaiser Build to Stock Master Order List (MOL) XS to Large"]
[]
[null,"Fill in Light Blue selection boxes","Pricing updated -->",{"$f":"Pricing_Date","v":"2021-09-23"}]
[null,"Project Name","Always verify pricing via BTS Portal or a Quote"]
[null,"Project Contact","Green is 30 day or less for pricing update"]
[null,"Project Contact Email","Yellow is 31 to 60 days since pricing update"]
["Location",null,"Red is greater than 60 days since update"]
["Select Location",{"$f":"VLOOKUP(Location_Sel,Location_Data,2,FALSE)","v":"Select shipping location"},"Unknown"]
["Installation"]
["No",{"$f":"VLOOKUP(A10,Installation[],2,FALSE)","v":"No Installation Services"},"Installation priced shown below"]
["iLO Configuration"]
["No",{"$f":"VLOOKUP(A12,Config_iLO[],2,)","v":"No configuration of iLO"},"Included"]
[]
["Server Quantity","Decription","Part Number","Qty per server","Price Each","Qty on order","Per Server Cost","Line Summary Cost"]
[1,"<-- Enter the quantity of servers on this order"]
["Select Server"]
["BTS Large",{"$f":"VLOOKUP(Server_Select,BTS_Size_Def[],2,)","v":"DL380 Gen10 8SFF 48 Core"},{"$f":"+Server_Select","v":"BTS Large"},1,{"$f":"VLOOKUP(Server_Select,Part_and_Price,2,FALSE)","v":9737.9400000000023},{"$f":"+D17*Server_Qty","v":1},{"$f":"+D17*E17","v":9737.9400000000023},{"$f":"+F17*E17","v":9737.9400000000023}]
[null,{"$f":"_xlfn.CONCAT(\"Processors 2x \",VLOOKUP(Server_Select,BTS_Size_Def[],3,FALSE),\", Boot Drives \",VLOOKUP(Server_Select,BTS_Size_Def[],6,FALSE),\", FlexLOM \",VLOOKUP(Server_Select,BTS_Size_Def[],7,FALSE),\", Power Supplies \",VLOOKUP(Server_Select,BTS_Size_Def[],8,FALSE),\", Rail Kit \",VLOOKUP(Server_Select,BTS_Size_Def[],9,FALSE),\", HPE OneView\")","v":"Processors 2x Xeon-Gold 6248R (3.0GHz/24-core/205W), Boot Drives 2x480GB RI SSD, FlexLOM 366FLR, Power Supplies 2x800W, Rail Kit HPE 2U Small Form Factor Ball Bearing Rail Kit, HPE OneView"},"Included"]
[{"$f":"IF(Mem_Change=Default_mem,\"Default Memory\",\"Non-Default Memory\")","v":"Non-Default Memory"}]
[{"$f":"VLOOKUP(Server_Select,BTS_Size_Def[],5,FALSE)","v":"Memory-768GB"},{"$f":"VLOOKUP(Mem_Change,Optional_Mem[],1,FALSE)","v":"Memory-384GB"},"Total Memory"]
["Change Default Memory",{"$f":"VLOOKUP(Mem_Change,Optional_Mem[],2,FALSE)","v":12},"DIMM Count",{"$f":"+B21","v":12},"Bundle Price",{"$f":"+D21*Server_Qty","v":12}]
["Memory-384GB",{"$f":"VLOOKUP(Mem_Change,Optional_Mem[],3,FALSE)","v":"HPE 32GB (1x32GB) Dual Rank x4 DDR4-2933"},"DIMM Size",1,{"$f":"VLOOKUP(Mem_Change,Part_and_Price,2,FALSE)","v":6754.08},{"$f":"+D22*Server_Qty","v":1},{"$f":"+D22*E22","v":6754.08},{"$f":"+F22*E22","v":6754.08}]
["Network",null,"Part Number",null,"Bundle Price"]
["None",{"$f":"VLOOKUP(Nic_Sel,Nic_Sel_Data,3,FALSE)","v":0},{"$f":"VLOOKUP(Nic_Sel,Nic_Sel_Data,2,FALSE)","v":0},{"$f":"VLOOKUP(Nic_Sel,Nic_Sel_Data,4,FALSE)","v":0},{"$f":"IF(D24=0,0,VLOOKUP(Nic_Sel,Part_and_Price,2,FALSE))","v":0},{"$f":"+D24*Server_Qty/2","v":0},{"$f":"+E24*D24/2","v":0},{"$f":"+F24*E24","v":0}]
[null,{"$f":"VLOOKUP(Nic_Sel,NIC_Addon_Data,2,FALSE)","v":0},{"$f":"VLOOKUP(Nic_Sel,NIC_Addon_Data,3,FALSE)","v":0},{"$f":"VLOOKUP(Nic_Sel,NIC_Addon_Data,4,FALSE)","v":0}]
["HBA"]
["None",{"$f":"VLOOKUP(HBA_Sel,HBA_Data,3,FALSE)","v":0},{"$f":"VLOOKUP(HBA_Sel,HBA_Data,2,FALSE)","v":0},{"$f":"VLOOKUP(HBA_Sel,HBA_Data,4,FALSE)","v":0},{"$f":"IF(D27=0,0,VLOOKUP(HBA_Sel,Part_and_Price,2,FALSE))","v":0},{"$f":"+D27*Server_Qty/2","v":0},{"$f":"+D27*E27/2","v":0},{"$f":"+F27*E27","v":0}]
[]
["Extra Drive Bay Option",null,null,null,"Price Each"]
["None",{"$f":"VLOOKUP(Sel_Drive_Total,Data_Drive_Bays[],2,FALSE)","v":"8 Data Drive Capacity"},{"$f":"VLOOKUP(Sel_Drive_Total,Data_Drive_Bays[],5,FALSE)","v":"-"},{"$f":"VLOOKUP(Sel_Drive_Total,Data_Drive_Bays[],4,FALSE)","v":0},{"$f":"IF(D30=0,0,VLOOKUP(C30,Part_and_Price,2,FALSE))","v":0},{"$f":"+D30*Server_Qty","v":0},{"$f":"+D30*E30","v":0},{"$f":"+F30*E30","v":0}]
[null,{"$f":"VLOOKUP(Sel_Drive_Total,Data_Drive_Bays[],3,FALSE)","v":8}]
["Data Drives","Descriptions",{"$f":"VLOOKUP(Sel_Drive_Total,Data_Drive_Bays[],3,FALSE)","v":8},null,"Price Each"]
[0,"Select Drive Size",{"$f":"VLOOKUP(B33,Drive_Size_Data,2,FALSE)","v":"-"},{"$f":"+Drive_Count_1","v":0},{"$f":"IF(D33=0,0,VLOOKUP(Drive_1,Part_and_Price,2,FALSE))","v":0},{"$f":"+D33*Server_Qty","v":0},{"$f":"+D33*E33","v":0},{"$f":"+F33*E33","v":0}]
[0,"Select Drive Size",{"$f":"VLOOKUP(Drive_2,Drive_Size_Data,2,FALSE)","v":"-"},{"$f":"+Drive_Count_2","v":0},{"$f":"IF(D34=0,0,VLOOKUP(Drive_2,Part_and_Price,2,FALSE))","v":0},{"$f":"+D34*Server_Qty","v":0},{"$f":"+D34*E34","v":0},{"$f":"+F34*E34","v":0}]
[0,"Select Drive Size",{"$f":"VLOOKUP(Drive_3,Drive_Size_Data,2,FALSE)","v":"-"},{"$f":"+Drive_Count_3","v":0},{"$f":"IF(D35=0,0,VLOOKUP(Drive_3,Part_and_Price,2,FALSE))","v":0},{"$f":"+D35*Server_Qty","v":0},{"$f":"+D35*E35","v":0},{"$f":"+F35*E35","v":0}]
[0,"Select Drive Size",{"$f":"VLOOKUP(Drive_4,Drive_Size_Data,2,FALSE)","v":"-"},{"$f":"+Drive_Count_4","v":0},{"$f":"IF(D36=0,0,VLOOKUP(Drive_4,Part_and_Price,2,FALSE))","v":0},{"$f":"+D36*Server_Qty","v":0},{"$f":"+D36*E36","v":0},{"$f":"+F36*E36","v":0}]
[{"$f":"SUM(Data_Drive_Count)","v":0},{"$f":"IF(A37>B31,\"Warning, Reduce Drive Selection or add extra drive bay\",\"Total Data Drives Selected\")","v":"Total Data Drives Selected"}]
[null,null,null,null,null,null,"Per Server Cost","Order Summary"]
[null,null,null,null,"Server subtotal -->",null,{"$f":"SUM(G17:G37)","v":16492.020000000004},{"$f":"SUM(H17:H37)","v":16492.020000000004}]
[null,null,"Shipping",1,120,{"$f":"+D40*Server_Qty","v":1},{"$f":"+D40*E40","v":120},{"$f":"+F40*E40","v":120}]
[null,null,"Installation",{"$f":"IF(Inst_Sel=\"Yes\",1,0)","v":0},500,{"$f":"+D41*Server_Qty","v":0},{"$f":"+D41*E41","v":0},{"$f":"+F41*E41","v":0}]
["115V Power Cord Option",null,"Part Number"]
["No","115 Volt Power Cord","P007-010",{"$f":"IF(A43=\"Yes\",2,0)","v":0},{"$f":"IF(D43=0,0,VLOOKUP(C43,Part_and_Price,2,FALSE))","v":0},{"$f":"+D43*Server_Qty","v":0},{"$f":"+D43*E43","v":0},{"$f":"+F43*E43","v":0}]
["Trace3 order Description\n and part number",{"$f":"IF(Default_Mem_Status=\"Default Memory\",B59,B60)","v":"LG HPE DL380 Gen10 8SFF Svr Bundle custom"},null,{"$f":"IF(Default_Mem_Status=\"Default Memory\",A59,A60)","v":"HPE-LG-DL-V1-C5"}]
[null,null,null,null,"Server Total -->",null,{"$f":"SUM(G39:G43)","v":16612.020000000004},{"$f":"SUM(H39:H43)","v":16612.020000000004}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"_xlfn._xlws.FILTER(Table3[],(Table3[Server]=Server_Select) * (Table3[10/25GB]=Nic_Sel)*(Table3[HBA]=HBA_Sel),\"No Results\")","v":"HPE-LG-DL-V1-C2"},"LG-8SFF-0-0 HPE DL380 Gen10 8SFF Svr Bundle w/o NIC, NIC Transceivers, and HBA","BTS Large","None","None","Default Memory",0]
[{"$f":"_xlfn._xlws.FILTER(Table3[],(Table3[Std Memory]=Default_Mem_Status)*(Table3[Server]=Server_Select),\"No results\")","v":"HPE-LG-DL-V1-C5"},"LG HPE DL380 Gen10 8SFF Svr Bundle custom","BTS Large","x","x","Non-Default Memory",0]

{"sheet":"BTS NVR MWIE","index":2,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[40,4,40,5],[0,1,0,7],[9,2,9,3],[34,4,34,5],[39,1,39,2],[39,3,39,4],[7,2,7,7],[8,2,8,7],[3,2,3,4],[6,2,6,4],[5,2,5,4],[4,2,4,4]]}
[{"$f":"_xlfn.CONCAT(\"Version \",Version,\" Version Date \",MONTH(Version_Date),\"-\",DAY(Version_Date),\" \",YEAR(Version_Date))","v":"Version V1.071 Version Date 9-23 2021"},"Kaiser Build to Stock Master Order List (MOL) NVR/MWIE"]
[]
[null,"Fill in Light Blue selection boxes","Pricing updated -->",{"$f":"Pricing_Date","v":"2021-09-23"}]
[null,"Project Name","Always verify pricing via BTS Portal or a Quote"]
[null,"Project Contact","Green is 30 day or less for pricing update"]
[null,"Project Contact Email","Yellow is 31 to 60 days since pricing update"]
["Location",null,"Red is greater than 60 days since update"]
["Select Location",{"$f":"VLOOKUP(Location_Sel,Location_Data,2,FALSE)","v":"Select shipping location"}]
["Installation"]
["No",{"$f":"VLOOKUP(A10,Installation[],2,FALSE)","v":"No Installation Services"},"Installation priced shown below"]
["iLO Configuration"]
["No",{"$f":"VLOOKUP(A12,Config_iLO[],2,)","v":"No configuration of iLO"},"Included"]
[]
["Server Quantity","Decription","Part Number","Qty per server","Price Each","Qty on order","Per Server Cost","Line Summary Cost"]
[5,"<-- Enter the quantity of servers on this order"]
["Select Server"]
["BTS xSmall MWIE-NVR",{"$f":"VLOOKUP(Server_Select,BTS_Size_Def[],2,)","v":"DL380 Gen10 12LFF 16 Core"},{"$f":"+Server_Select","v":"BTS xSmall MWIE-NVR"},1,{"$f":"VLOOKUP(Server_Select,Part_and_Price,2,FALSE)","v":8267.7800000000007},{"$f":"+D17*Server_Qty","v":5},{"$f":"+D17*E17","v":8267.7800000000007},{"$f":"+F17*E17","v":41338.9}]
[null,{"$f":"_xlfn.CONCAT(\"Processors 2x \",VLOOKUP(Server_Select,BTS_Size_Def[],3,FALSE),\", Boot Drives \",VLOOKUP(Server_Select,BTS_Size_Def[],6,FALSE),\", FlexLOM \",VLOOKUP(Server_Select,BTS_Size_Def[],7,FALSE),\", Power Supplies \",VLOOKUP(Server_Select,BTS_Size_Def[],8,FALSE),\", Rail Kit \",VLOOKUP(Server_Select,BTS_Size_Def[],9,FALSE),\", HPE OneView\")","v":"Processors 2x Xeon-Silver 4215R (3.2GHz/8-core/130W), Boot Drives 2x480GB RI SSD, FlexLOM 366FLR, Power Supplies 2x800W, Rail Kit HPE 2U Large Form Factor Ball Bearing Rail Kit, HPE OneView"},"Included"]
[{"$f":"IF(Mem_Change=Default_mem,\"Default Memory\",\"Non-Default Memory\")","v":"Default Memory"}]
[{"$f":"VLOOKUP(Server_Select,BTS_Size_Def[],5,FALSE)","v":"Memory - 1R-128GB"},{"$f":"VLOOKUP(Mem_Change,Optional_Mem[],1,FALSE)","v":"Memory - 1R-128GB"},"Total Memory"]
["Change Default Memory",{"$f":"VLOOKUP(Mem_Change,Optional_Mem[],2,FALSE)","v":8},"DIMM Count",{"$f":"+B21","v":8},"Bundle Price",{"$f":"+D21*Server_Qty","v":40}]
["Memory - 1R-128GB",{"$f":"VLOOKUP(Mem_Change,Optional_Mem[],3,FALSE)","v":"HPE 16GB (1x16GB) Single Rank x4 DDR4-2933 "},"DIMM Size",1,{"$f":"VLOOKUP(Mem_Change,Part_and_Price,2,FALSE)","v":1976},{"$f":"+D22*Server_Qty","v":5},{"$f":"+D22*E22","v":1976},{"$f":"+F22*E22","v":9880}]
["Network",null,"Part Number",null,"Bundle Price"]
["None",{"$f":"VLOOKUP(Nic_Sel,Nic_Sel_Data,3,FALSE)","v":0},{"$f":"VLOOKUP(Nic_Sel,Nic_Sel_Data,2,FALSE)","v":0},{"$f":"VLOOKUP(Nic_Sel,Nic_Sel_Data,4,FALSE)","v":0},{"$f":"IF(D24=0,0,VLOOKUP(Nic_Sel,Part_and_Price,2,FALSE))","v":0},{"$f":"+D24*Server_Qty/2","v":0},{"$f":"+E24+F24","v":0},{"$f":"+F24*E24","v":0}]
[null,{"$f":"VLOOKUP(Nic_Sel,NIC_Addon_Data,2,FALSE)","v":0},{"$f":"VLOOKUP(Nic_Sel,NIC_Addon_Data,3,FALSE)","v":0},{"$f":"VLOOKUP(Nic_Sel,NIC_Addon_Data,4,FALSE)","v":0}]
["HBA"]
["None",{"$f":"VLOOKUP(HBA_Sel,HBA_Data,3,FALSE)","v":0},{"$f":"VLOOKUP(HBA_Sel,HBA_Data,2,FALSE)","v":0},{"$f":"VLOOKUP(HBA_Sel,HBA_Data,4,FALSE)","v":0},{"$f":"IF(D27=0,0,VLOOKUP(HBA_Sel,Part_and_Price,2,FALSE))","v":0},{"$f":"+D27*Server_Qty","v":0},{"$f":"+D27*E27","v":0},{"$f":"+F27*E27","v":0}]
[]
["Data Drives Bundles","Descriptions"]
["Small Storage - 4 - 10TB",{"$f":"VLOOKUP(Drive_Sel,Drive_Option_12LFF[],3,FALSE)","v":"HPE 10TB SAS 12G Midline 7.2K LFF Helium 512e DS"},{"$f":"+Drive_Sel","v":"Small Storage - 4 - 10TB"},1,{"$f":"IF(D30=0,0,VLOOKUP(Drive_Sel,Part_and_Price,2,FALSE))","v":0},{"$f":"+D30*Server_Qty","v":5},{"$f":"+D30*E30","v":0},{"$f":"+F30*E30","v":0}]
["GPU"]
["N",{"$f":"VLOOKUP(GPU,GPU_Data[],3,FALSE)","v":"No GPU"},{"$f":"VLOOKUP(GPU,GPU_Data[],2,FALSE)","v":"-"},{"$f":"VLOOKUP(GPU,GPU_Data[],4,FALSE)","v":0},{"$f":"IF(D32=0,0,VLOOKUP(C32,Part_and_Price,2,FALSE))","v":0},{"$f":"+D32*Server_Qty","v":0},{"$f":"+D32*E32","v":0},{"$f":"+F32*E32","v":0}]
[]
[null,null,null,null,null,null,"Per Server Cost","Order Summary"]
[null,null,null,null,"Server subtotal -->",null,{"$f":"SUM(G17:G33)","v":10243.780000000001},{"$f":"SUM(H17:H33)","v":51218.9}]
[null,null,"Shipping",1,120,{"$f":"+D36*Server_Qty","v":5},{"$f":"+D36*E36","v":120},{"$f":"+F36*E36","v":600}]
[null,null,"Installation",{"$f":"IF(Inst_Sel=\"Yes\",1,0)","v":0},500,{"$f":"+D37*Server_Qty","v":0},{"$f":"+D37*E37","v":0},{"$f":"+F37*E37","v":0}]
["115V Power Cord Option",null,"Part Number"]
["No","115 Volt Power Cord","P007-010",{"$f":"IF(A39=\"Yes\",2,0)","v":0},{"$f":"IF(D39=0,0,VLOOKUP(C39,Part_and_Price,2,FALSE))","v":0},{"$f":"+D39*Server_Qty","v":0},{"$f":"+D39*E39","v":0},{"$f":"+F39*E39","v":0}]
["Trace3 order Description\n and part number",{"$f":"IF(Default_Mem_Status=\"Default Memory\",B55,B57)","v":"LenMWIe 12LFF HPE DL380 Gen10 Svr Bundle"},null,{"$f":"IF(Default_Mem_Status=\"Default Memory\",A55,A57)","v":"HPE-XS-LenMWIE-DL-V1-C1"}]
[null,null,null,null,"Server Total -->",null,{"$f":"SUM(G35:G39)","v":10363.780000000001},{"$f":"SUM(H35:H39)","v":51818.9}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"_xlfn._xlws.FILTER(Table3[],(Table3[Server]=Server_Select)*(Table3[GPU]=GPU),\"No Results\")","v":"HPE-XS-LenMWIE-DL-V1-C1"},"LenMWIe 12LFF HPE DL380 Gen10 Svr Bundle","BTS xSmall MWIE-NVR","None","None","Default Memory","N"]
["HPE-XS-LenMWIE-DL-V1-C5","LenMWIe 12LFF HPE DL380 Gen10 Svr Bundle non-standard memory","BTS xSmall MWIE-NVR","None","None","Non-Default Memory","N"]
[{"$f":"_xlfn._xlws.FILTER(Table3[],(Table3[Std Memory]=Default_Mem_Status)*(Table3[Server]=Server_Select),\"No results\")","v":"HPE-XS-LenMWIE-DL-V1-C1"},"LenMWIe 12LFF HPE DL380 Gen10 Svr Bundle","BTS xSmall MWIE-NVR","None","None","Default Memory","N"]
["HPE-XS-LenMWIE-DL-V1-C2","LenMWIe 12LFF HPE DL380 Gen10 Svr Bundle with GPU","BTS xSmall MWIE-NVR","None","None","Default Memory","Y"]

{"sheet":"Data","index":3,"n_rows":86,"n_cols":9,"rows_kept":86,"cut":false,"hidden":true,"merged":[[9,5,9,7]]}
["Version","V1.071"]
["Version Date",{"$f":"+C2","v":"2021-09-23T09:25:07.770"},{"$f":"NOW()","v":"2021-09-23T09:25:07.770"}]
["BTS Size","Chassis","Processor (Dual Processor)","Total Memory","Part#","Boot Drives","Default FlexLOM","Power Supplies","Rail Kit"]
["BTS xSmall MWIE-NVR","DL380 Gen10 12LFF 16 Core","Xeon-Silver 4215R (3.2GHz/8-core/130W)","128GB","Memory - 1R-128GB","2x480GB RI SSD","366FLR","2x800W","HPE 2U Large Form Factor Ball Bearing Rail Kit"]
["BTS xSmall","DL380 Gen10 8SFF 8 Core","Xeon-Gold 5222 (3.8GHz/4-core/105W) ","128GB","Memory- 2R -128GB","2x480GB RI SSD","366FLR","2x800W","HPE 2U Small Form Factor Ball Bearing Rail Kit"]
["BTS Small","DL380 Gen10 8SFF 16 Core","Xeon-Gold 6234 (3.3GHz/8-core/130W)","256GB","Memory-256GB","2x480GB RI SSD","366FLR","2x800W","HPE 2U Small Form Factor Ball Bearing Rail Kit"]
["BTS Medium","DL380 Gen10 8SFF 32 Core","Xeon-Gold 6226R (2.9GHz/16-core/150W)","384GB","Memory-384GB","2x480GB RI SSD","366FLR","2x800W","HPE 2U Small Form Factor Ball Bearing Rail Kit"]
["BTS Large","DL380 Gen10 8SFF 48 Core","Xeon-Gold 6248R (3.0GHz/24-core/205W)","768GB","Memory-768GB","2x480GB RI SSD","366FLR","2x800W","HPE 2U Small Form Factor Ball Bearing Rail Kit"]
[]
[null,null,null,null,null,"Manditory addition"]
["PCI Card Options","Card part number","Description","Qty",null,"Description","Part#","Qty"]
["None",null,null,null,"None"]
[" Dual 10Gbe NIC Option","817753-B21","HPE Ethernet 10/25Gb 2-port 640SFP28 Adapter",2," Dual 10Gbe NIC Option","HPE BladeSystem c-Class 10Gb SFP+ SR Transceiver","455883-B21",4]
["None"]
["Dual 32G HBA Option","Q0L12A","HPE SN1600E 32Gb Dual Port Fibre Channel HBA",2]
[]
["OneView Software"]
[]
[]
["Data Drives Options","Drive part number",null,null,"Location","Name",null,"Location","Name"]
["Select Drive Size","-","Number of Drive Models to choose from DL380 gen10 SFF",{"$f":"ROWS(Data_Drive_Sel)","v":13},"Select Location","Select shipping location",null,"Select Location","Select shipping location"]
["480 GB MU SSD","P05976-B21",null,null,"BDC","Boulder Data Center",null,"Regional","Regional MOB, Hospital or Office: Enter address here -->"]
["960 GB MU SSD","P05980-B21",null,null,"NDC","Napa Data Center",null,"BDC","Boulder Data Center"]
["1.92 TB MU SSD","P05986-B21",null,null,"SSDC","Silver Spring Data Center",null,"NDC","Napa Data Center"]
["3.84 TB MU SSD","P05994-B21",null,null,"CDC","Corona Data Center",null,"SSDC","Silver Spring Data Center"]
["300 GB 15K","870753-B21",null,null,"PDC","Pleasanton Data Center",null,"CDC","Corona Data Center"]
["600 GB 15K","870757-B21",null,null,"Regional","Regional MOB, Hospital or Office: Enter address here -->"]
["900 GB 15K","870759-B21",null,null,"Installation","Description"]
["300 GB 10K","872475-B21",null,null,"No","No Installation Services"]
["600 GB 10K","872477-B21",null,null,"Yes","Local Installation Services"]
["1.2 TB 10K","872479-B21"]
["1.8 TB 10K","872481-B21"]
["2.4 TB 10K","881457-B21"]
[]
[null,"Part Number","Description","Server","10/25GB","HBA","Std Memory","GPU"]
[null,"HPE-XS-DL-V1-C1","XS-8SFF-10G-32G HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers, and HBA","BTS xSmall"," Dual 10Gbe NIC Option","Dual 32G HBA Option","Default Memory"]
[null,"HPE-XS-DL-V1-C2","XS-8SFF-0-0 HPE DL380 Gen10 8SFF Svr Bundle w/o NIC, NIC Transceivers, and HBA","BTS xSmall","None","None","Default Memory"]
[null,"HPE-XS-DL-V1-C3","XS-8SFF-10G-0 HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers; w/o HBA","BTS xSmall"," Dual 10Gbe NIC Option","None","Default Memory"]
[null,"HPE-XS-DL-V1-C4","XS-8SFF-0-32G HPE DL380 Gen10 8SFF Svr Bundle w/o NIC and NIC Transceivers; w/ HBA ","BTS xSmall","None","Dual 32G HBA Option","Default Memory"]
[null,"HPE-XS-DL-V1-C5","XS HPE DL380 Gen10 8SFF Svr Bundle custom","BTS xSmall","x","x","Non-Default Memory"]
[null,"HPE-SM-DL-V1-C1","SM-8SFF-10G-32G HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers, and HBA","BTS Small"," Dual 10Gbe NIC Option","Dual 32G HBA Option","Default Memory"]
[null,"HPE-SM-DL-V1-C2","SM-8SFF-0-0 HPE DL380 Gen10 8SFF Svr Bundle w/o NIC, NIC Transceivers, and HBA","BTS Small","None","None","Default Memory"]
[null,"HPE-SM-DL-V1-C3","SM-8SFF-10G-0 HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers; w/o HBA","BTS Small"," Dual 10Gbe NIC Option","None","Default Memory"]
[null,"HPE-SM-DL-V1-C4","SM-8SFF-0-32G HPE DL380 Gen10 8SFF Svr Bundle w/o NIC and NIC Transceivers; w/ HBA,","BTS Small",0,"Dual 32G HBA Option","Default Memory"]
[null,"HPE-SM-DL-V1-C5","SM HPE DL380 Gen10 8SFF Svr Bundle custom","BTS Small","x","x","Non-Default Memory"]
[null,"HPE-MD-DL-V1-C1","MD-8SFF-10G-32G HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers, and HBA","BTS Medium"," Dual 10Gbe NIC Option","Dual 32G HBA Option","Default Memory"]
[null,"HPE-MD-DL-V1-C2","MD-8SFF-0-0 HPE DL380 Gen10 8SFF Svr Bundle w/o NIC, NIC Transceivers, and HBA","BTS Medium","None","None","Default Memory"]
[null,"HPE-MD-DL-V1-C3","MD-8SFF-10G-0 HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers; w/o HBA","BTS Medium"," Dual 10Gbe NIC Option","None","Default Memory"]
[null,"HPE-MD-DL-V1-C4","MD-8SFF-0-32G HPE DL380 Gen10 8SFF Svr Bundle w/o NIC and NIC Transceivers; w/ HBA","BTS Medium","None","Dual 32G HBA Option","Default Memory"]
[null,"HPE-MD-DL-V1-C5","MD HPE DL380 Gen10 8SFF Svr Bundle custom","BTS Medium","x","x","Non-Default Memory"]
[null,"HPE-LG-DL-V1-C1","LG-8SFF-10G-32G HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers, and HBA","BTS Large"," Dual 10Gbe NIC Option","Dual 32G HBA Option","Default Memory"]
[null,"HPE-LG-DL-V1-C2","LG-8SFF-0-0 HPE DL380 Gen10 8SFF Svr Bundle w/o NIC, NIC Transceivers, and HBA","BTS Large","None","None","Default Memory"]
[null,"HPE-LG-DL-V1-C3","LG-8SFF-10G-0 HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers; w/o HBA","BTS Large"," Dual 10Gbe NIC Option","None","Default Memory"]
[null,"HPE-LG-DL-V1-C4","LG-8SFF-0-32G HPE DL380 Gen10 8SFF Svr Bundle w/o NIC and NIC Transceivers; w/ HBA ","BTS Large","None","Dual 32G HBA Option","Default Memory"]
[null,"HPE-LG-DL-V1-C5","LG HPE DL380 Gen10 8SFF Svr Bundle custom","BTS Large","x","x","Non-Default Memory"]
[null,"HPE-XS-LenMWIE-DL-V1-C1","LenMWIe 12LFF HPE DL380 Gen10 Svr Bundle","BTS xSmall MWIE-NVR","None","None","Default Memory","N"]
[null,"HPE-XS-LenMWIE-DL-V1-C2","LenMWIe 12LFF HPE DL380 Gen10 Svr Bundle with GPU","BTS xSmall MWIE-NVR","None","None","Default Memory","Y"]
[null,"HPE-XS-LenMWIE-DL-V1-C5","LenMWIe 12LFF HPE DL380 Gen10 Svr Bundle non-standard memory","BTS xSmall MWIE-NVR","None","None","Non-Default Memory","N"]
[]
["Optional Memory","DIMM Count","DIMM Size",null,"Optional Memory LFF"]
["Default",null,null,null,"Memory - 1R-128GB"]
["Memory - 1R-128GB",8,"HPE 16GB (1x16GB) Single Rank x4 DDR4-2933 ",null,"Memory-256GB"]
["Memory- 2R -128GB",8,"HPE 16GB (1x16GB) Dual Rank x8 DDR4-2933",null,"Memory-384GB"]
["Memory-256GB",16,"HPE 16GB (1x16GB) Dual Rank x8 DDR4-2933",null,"Memory-512GB "]
["Memory-384GB",12,"HPE 32GB (1x32GB) Dual Rank x4 DDR4-2933",null,"Memory-768GB"]
["Memory-512GB ",8,"HPE 64GB (1x64GB) Dual Rank x4 DDR4-2933 "]
["Memory-768GB",12,"HPE 64GB (1x64GB) Dual Rank x4 DDR4-2933 "]
[]
["Extra Drive Bay Option","Drive count","Drive bays available","Drive Bay Added","Part Number"]
["None","8 Data Drive Capacity",8,0,"-"]
["Extra Drive Bay Added","12 Data Drive Capacity",12,1,"826691-B21"]
[]
[]
["Configure iLO","Description"]
["No","No configuration of iLO"]
["Yes","Configuration of iLO needed"]
[]
["12 LFF Drive option","Drive count","Drive description"]
["Small Storage - 4 - 10TB",4,"HPE 10TB SAS 12G Midline 7.2K LFF Helium 512e DS"]
["Medium Storage 8 - 10TB",8,"HPE 10TB SAS 12G Midline 7.2K LFF Helium 512e DS"]
["Large Storage 12 - 10TB",12,"HPE 10TB SAS 12G Midline 7.2K LFF Helium 512e DS"]
[]
[]
["GPU Select","Part#","Desciption","qty"]
["N","-","No GPU",0]
["Y","R1F95A","NVIDIA Quadro RTX 4000 includes power cable",1]

{"sheet":"PriceList","index":4,"n_rows":60,"n_cols":13,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["Pricing Date -->","2021-09-23"]
["Description","Part#","Price","Base mem price","Server price with memory"]
["xSmall Server for Lenel & MWiE – HPE DL380 G10 - 12 Bay LFF","BTS xSmall MWIE-NVR",{"$f":"+E3-D3","v":8267.7800000000007},1976,10243.780000000001]
["xSmall Server – HPE DL380 G10 - 8 Bay SFF","BTS xSmall",{"$f":"+E4-D4","v":6216.18},2304.7199999999998,8520.9]
["Small Server – HPE DL380 G10 - 8 Bay SFF","BTS Small",{"$f":"+E5-D5","v":7810.5900000000011},4609.4399999999996,12420.03]
["Medium Server – HPE DL380 G10 - 8 Bay SFF","BTS Medium",{"$f":"+E6-D6","v":7642.35},6754.08,14396.43]
["Large Server – HPE DL380 G10 - 8 Bay SFF","BTS Large",{"$f":"+E7-D7","v":9737.9400000000023},12259.8,21997.74]
[" Dual 10Gbe NIC Option"," Dual 10Gbe NIC Option",2174.5500000000002]
["Dual 32G HBA Option","Dual 32G HBA Option",3006.55]
[]
[]
[null,"Column1","Column2"]
["XS-8SFF-10G-32G HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers, and HBA","HPE-XS-DL-V1-C1",14125.25]
["XS-8SFF-0-0 HPE DL380 Gen10 8SFF Svr Bundle w/o NIC, NIC Transceivers, and HBA","HPE-XS-DL-V1-C2",8784.2199999999993]
["XS-8SFF-10G-0 HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers; w/o HBA","HPE-XS-DL-V1-C3",11026.02]
["XS-8SFF-0-32G HPE DL380 Gen10 8SFF Svr Bundle w/o NIC and NIC Transceivers; w/ HBA ","HPE-XS-DL-V1-C4",11883.45]
["XS HPE DL380 Gen10 8SFF Svr Bundle custom","HPE-XS-DL-V1-C5","Call Trace3 "]
["SM-8SFF-10G-32G HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers, and HBA","HPE-SM-DL-V1-C1",18145]
["SM-8SFF-0-0 HPE DL380 Gen10 8SFF Svr Bundle w/o NIC, NIC Transceivers, and HBA","HPE-SM-DL-V1-C2",12803.97]
["SM-8SFF-10G-0 HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers; w/o HBA","HPE-SM-DL-V1-C3",15045.77]
["SM-8SFF-0-32G HPE DL380 Gen10 8SFF Svr Bundle w/o NIC and NIC Transceivers; w/ HBA,","HPE-SM-DL-V1-C4",15903.2]
["SM HPE DL380 Gen10 8SFF Svr Bundle custom","HPE-SM-DL-V1-C5","Call Trace3 "]
["MD-8SFF-10G-32G HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers, and HBA","HPE-MD-DL-V1-C1",20183]
["MD-8SFF-0-0 HPE DL380 Gen10 8SFF Svr Bundle w/o NIC, NIC Transceivers, and HBA","HPE-MD-DL-V1-C2",14841.97]
["MD-8SFF-10G-0 HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers; w/o HBA","HPE-MD-DL-V1-C3",17083.77]
["MD-8SFF-0-32G HPE DL380 Gen10 8SFF Svr Bundle w/o NIC and NIC Transceivers; w/ HBA","HPE-MD-DL-V1-C4",17941.2]
["MD HPE DL380 Gen10 8SFF Svr Bundle custom","HPE-MD-DL-V1-C5","Call Trace3 "]
["LG-8SFF-10G-32G HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers, and HBA","HPE-LG-DL-V1-C1",28019]
["LG-8SFF-0-0 HPE DL380 Gen10 8SFF Svr Bundle w/o NIC, NIC Transceivers, and HBA","HPE-LG-DL-V1-C2",22677.97]
["LG-8SFF-10G-0 HPE DL380 Gen10 8SFF Svr Bundle w/ NIC, NIC Transceivers; w/o HBA","HPE-LG-DL-V1-C3",24919.77]
["LG-8SFF-0-32G HPE DL380 Gen10 8SFF Svr Bundle w/o NIC and NIC Transceivers; w/ HBA ","HPE-LG-DL-V1-C4",25777.200000000001]
["LG HPE DL380 Gen10 8SFF Svr Bundle custom","HPE-LG-DL-V1-C5","Call Trace3 "]
["LenMWIe 12LFF HPE DL380 Gen10 Svr Bundle","HPE-XS-LenMWIE-DL-V1-C1",7024]
["LenMWIe 12LFF HPE DL380 Gen10 Svr Bundle with GPU","HPE-XS-LenMWIE-DL-V1-C2",8001]
["Trace3 Advanced Implementation Services - Onsite deployment at KP installation location","QS-PS-Advanced Services",500]
["Tripp Lite Heavy-Duty Computer Power Cord - 14AWG 15A (NEMA 5-15P to IEC-320-C13) 10-ft.","P007-010",10.34,null,null,null,null,null,null,"Total Memory","DIMM Count","DIMM Size","Memory $"]
["128GB Memory Bundle","Memory - 1R-128GB",1976,null,null,null,null,null,null,"128GB",8,"HPE 16GB (1x16GB) Single Rank x4 DDR4-2933 "," $   1,976.00 "]
["128GB Memory Bundle","Memory- 2R -128GB",2304.7199999999998,null,null,null,null,null,null,"128GB",8,"HPE 16GB (1x16GB) Dual Rank x8 DDR4-2933","$   2,376.00 "]
["256GB Memory Bundle","Memory-256GB",4609.4399999999996,null,null,null,null,null,null,"256GB",16,"HPE 16GB (1x16GB) Dual Rank x8 DDR4-2933","$   4,752.00 "]
["384GB Memory Bundle","Memory-384GB",6754.08,null,null,null,null,null,null,"384GB",12,"HPE 32GB (1x32GB) Dual Rank x4 DDR4-2933","$   6,963.00 "]
["512GB Memory Bundle","Memory-512GB ",8173.2,null,null,null,null,null,null,"768GB",12,"HPE 64GB (1x64GB) Dual Rank x4 DDR4-2933 "," $ 12,639.00 "]
["768GB Memory Bundle","Memory-768GB",12259.8]
["480 GB MU SSD","480 GB MU SSD",363]
["960 GB MU SSD","960 GB MU SSD",695]
["1.92 TB MU SSD","1.92 TB MU SSD",1388]
["3.84 TB MU SSD","3.84 TB MU SSD",2775]
["300 GB 15K","300 GB 15K",275]
["600 GB 15K","600 GB 15K",513]
["900 GB 15K","900 GB 15K",575]
["300 GB 10K","300 GB 10K",150]
["600 GB 10K","600 GB 10K",250]
["1.2 TB 10K","1.2 TB 10K",370]
["1.8 TB 10K","1.8 TB 10K",573]
["2.4 TB 10K","2.4 TB 10K",594]
["HPE DL38X Gen10 SFF Box1/2 Cage/Backplane Kit","826691-B21",187]
["OneView software","E5Y35AAE"]
[null,"Small Storage - 4 - 10TB",0]
[null,"Medium Storage 8 - 10TB",3219.76]
[null,"Large Storage 12 - 10TB",6439.52]
["NVIDIA Quadro RTX 4000 includes power cable","R1F95A",977]

{"sheet":"iLO Info","index":5,"n_rows":2,"n_cols":16,"rows_kept":2,"cut":false,"hidden":true,"merged":[[0,1,0,7],[0,8,0,15]]}
[null,"Trace3 ",null,null,null,null,null,null,"To be filled out by KP"]
["Line","KP Project Name","Serial Number","Asset tag","KP PO","SO","FedEx Tracking","Config Description","Ship  To Address","Location","iLO Hostname","Domain Name","IP","Subnet Mask","Default Gateway","Time Zone"]

{"sheet":"Working notes-updated needed","index":6,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[null,null,"Complete hit Ship+P"]
["2021-04-02","Reviewed MOL with team and need to make the following changes"]
[null,"-- Remove Sales Tax row at bottom","P"]
[null,"-- When saving the form remove the Yellow box that mentions input","P"]
[null,"-- Change the color of Project input fields to make it easier to read","P"]
["2021-04-02","Todo's for project from Self"]
[null,"-- Add programing to force 10Gbe nics when going to DC","P"]
[null,"-- Add code to change disk drive dropdown QTY based on available drives"]
[null,"-- Add MWIE/Lenel/NVR sheet","P"]
[null,"-- Add summary page in front, show all BTS sized and options","P"]
[null,"-- Add programming to hide all sheets not needing to be shown for end users","P"]
["2021-04-09","Update prices as follows","P"]
[null,null,null,"DL380 sizes","Old","New"]
[null,null,"P","XS base config",8784.43,8520.9]
[null,null,"P","SM base config",12804.15,12420.03]
[null,null,"P","MD base config",14841.68,14396.43]
[null,null,"P","LG base config",22678.080000000002,21997.74]
[null,null,"P","HBA (update for XS, SM, MD, LG)",3099.54,3006.55]
[null,null,"P","NIC w/transceivers (update for XS, SM, MD, LG)",2241.8000000000002,2174.5500000000002]
["2021-04-19","Add startup code to reset values","P"]
[null,"-Select Location to default","P"]
[null,"-No installation","P"]
[null,"-No iLO config","P"]
[null,"-No extra drive bay","P"]
[null,"-No 115V power cord","P"]
[null,"-No Disk drives","P"]
[null,"-Make sure sheet is locked on startup","P"]
[null,"-Clear project name, contact and email from the form","P"]
[]
["2021-04-19","Add code to remove drive type when zero'ing out drive selection"]
[]
["2021-04-20","Note: put most code in modules 2 so don't have to keep cleaning up for each sheet","P"]
["2021-05-04","Add code to pick Trace3 Part number and descripition on bottom of sheet","P","Fixed on version 1.01"]
["2021-05-28","Fix math on HBA's - price is for 2 so don't double it per server","P","Fixed on version 1.02"]
["2021-05-28","Create BTS overview sheet to show models and Trace3 contacts","P"]
["2021-05-28","NVR make Regional first on location list and 115V power cord yes by default","P"]
["2021-06-15","incorporate Andrea McKnights changes"]
[null,"-Change order by putting project and installation info up top","P"]
[null,"-remove the light orangish color ","P"]
[null,"-Group server config more contiguous","P"]
[null,"-Fix macro to select top field versus server select","P"]