Spreadsheet: 49986d1249402711-conditonal-formatting-a-cell-based-on-other-cells-offset-with-lookup
Sheet: Lowest Prices

73463.94 | Lowest Prices |  |  |  |  |  |  |  |  |  |  |  |  | Lowest Prices |  |  |  |  | Lowest Prices
 | Standard |  |  |  |  |  |  |  |  |  |  |  |  | Tape Backup Opt. |  |  | Battery BackUPS Opt. |  | Server Options
Type | Data Server | Citrix/RDC | Licensing |  |  |  | Software | Tape Backup | Rack | Battery BackUPS | Battery BackUPS | [NAME] | [NAME] | Tape Backup | Tape Backup | Tape Backup | Battery BackUPS | Battery BackUPS | Data Server | Citrix/RDC | Citrix/RDC | Citrix/RDC
Manufacturer | Dell | Dell | Microsoft |  |  | Citrix | Citrix | Quantum | Dell | APC | APC | Tripp Lite | Tripp Lite | Dell | Dell | Dell | APC | APC | Dell | Dell | Dell | Dell
Make | PowerEdge | PowerEdge | CALs |  |  |  |  | 0 | PowerEdge | Smart-UPS | 48V Rack Mountable | NetController | B042 Series | PowerVault | PowerVault | PowerVault | Smart-UPS XL | 48V Rack Mountable | PowerEdge | PowerEdge | PowerEdge | PowerEdge
Model | R710 | R610 | Windows 2008 OS Server | Windows 2008 CAL | Terminal Services CAL | XenServer | XenServer | LTO4 | 4220 42U Rack | 3000VA USB | 48V Battery Pack | 8 Ports + USB with 19" LCD | P780-006 | LTO-3-060 | 110T LTO3 | LTO-4-120 | 2200 VA | 48V Battery Pack | R710 | R710 | R610 | R410
Processors | Intel® [NAME] [NAME], 2.93Ghz 3U | Intel® [NAME] [NAME], 2.93Ghz, 1U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intel® [NAME] [NAME], 2.93Ghz 3U | Intel® [NAME] [NAME], 2.93Ghz 3U | Intel® [NAME] [NAME], 2.93Ghz 1U | Intel® [NAME] [NAME], 2.93Ghz 1U
# of Proc | 2 | 2 | Per Server | Per User | Per User | Per User | Citrix Software is included in licensing. | Drive Price | AR2144BLK | SUA3000R3XLNETPKG | SUA48RMXLBP3U | B040-008-19 | 6ft USB/PS2 (2-in-1) + VGA Cable | Drive Price | Drive Price | Drive Price | SUA2200R3XLNETPKG | SUA48RMXLBP3U | 2 | 2 | 2 | 2
Memory | 32GB | 32GB |  |  |  |  |  | 20 Tapes |  | A1671691 | A0664123 |  | #N/A | 20 Tapes | 20 Tapes | 20 Tapes |  |  | 32GB | 32GB | 16GB | 32GB
Memory Speed | 1333MHz | 1333MHz | # of License | # of License | # of License | # of License |  | Backup Exec |  |  |  |  | #N/A | Backup Exec | Backup Exec | Backup Exec |  |  | 1333MHz | 1333MHz | 1333MHz | 1066MHz
HD [NAME] | 450GB | 80GB | 4 | 120 | 75 | 75 |  | 3563.36 |  |  |  |  | #N/A | 2563 | 2922.2 | 4138 |  |  | 164GB | 160GB | 80GB | 160GB
Type of HD | SAS | SATA | Price / CAL | Price / CAL | Price / CAL | Price / Client |  |  |  |  |  |  | #N/A |  |  |  |  |  | SAS | SATA | SATA | SATA
# of HDs | 6 | 1 | 660.84 | 29.39 | 73.32 | 317.58 |  | Half Height Drive |  |  |  |  | #N/A | Half Height Drive | Full Height Drive | Full Height Drive |  |  | 6 | 1 | 1 | 1
Network Cards | 2x Intel PRO 1000VT Quad Port 1GbE NIC | 2x Intel PRO 1000PT 1GbE Dual Port NIC, PCIe-4 | Includes Software Assurance | Includes Software Assurance | Includes Software Assurance | Media Kit |  | #N/A | Includes Doors and Side Panels | Rack Mountable 110V 3U [NAME] | Rack Mountable 3U | Rackmount 1U | #N/A | #N/A | #N/A | #N/A | Rack Mountable 3U [NAME] 1850 Watts | Rack Mountable | 2x Intel PRO 1000PT 1GbE Dual Port NIC, PCIe-4 | 2x Intel PRO 1000PT 1GbE Dual Port NIC, PCIe-4 | 2x Intel PRO 1000PT 1GbE Dual Port NIC, PCIe-4 | Intel PRO 1000PT Quad Port 1GbE NIC, PCIe-4
OS Software | Included in with E/A | Included in with E/A | #N/A | #N/A | #N/A | 40 |  | 3Yr Next Day |  | Includes Temp |  |  | #N/A | 3Yr Next Day | 3Yr Next Day | 3Yr Next Day | Includes Temp |  | Included in with E/A | Included in with E/A | Included in with E/A | Included in with E/A
Warranty Support | 3 Yr - Pro Support - 2 Hour - Mission Critical | 3 Yr - Pro Support - 4 Hour - Mission Critical | #N/A | #N/A | #N/A |  |  | #N/A | 3yr Warranty NBD Parts | 2 Year Warranty | 2 Year Warranty | 1 Year Warranty | Limited Liftime Warranty | #N/A | #N/A | #N/A | 2 Year Warranty | 2 Year Warranty | 3 Yr - Pro Support - 4 Hour - Mission Critical | 3 Yr - Pro Support - 4 Hour - Mission Critical | 3 Yr - Pro Support - 4 Hour - Mission Critical | 3 Yr - Pro Support - 4 Hour - Mission Critical
Quantity | 1 | 3 | 4 | 120 | 75 | 75 | 0 | 1 | 1 | 2 | 2 | 1 | 4 | 1 | 1 | 1 | 2 | 2 | 1 | 3 | 3 | 3
Lowest Price | 10000 | 18000 | 2643.36 | 3526.8 | 5498.999999999999 | 23858.5 | 0 | 3563.36 | 1399 | 2751.98 | 1104.98 | 1069 | 47.96 | 2563 | 2922.2 | 4138 | 2554 | 1104.98 | 8200 | 19500 | 16500 | 15465
Row Assignment | 43 | 43 | 65 | 65 | 65 | 65 | 21 | 65 | 43 | 21 | 21 | 43 | 87 | 43 | 43 | 43 | 87 | 21 | 43 | 43 | 43 | 43
Column Label | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W
Lowest price Cell Reference | Quotes!B43 | Quotes!B43 | Quotes!B65 | Quotes!B65 | Quotes!B65 | Quotes!B65 | Quotes!B21 | Quotes!B65 | Quotes!B43 | Quotes!B21 | Quotes!B21 | Quotes!B43 | Quotes!B87 | Quotes!B43 | Quotes!B43 | Quotes!B43 | Quotes!B87 | Quotes!B21 | Quotes!B43 | Quotes!B43 | Quotes!B43 | Quotes!B43
Colum Cell Reference | Quotes!B43 | Quotes!C43 | Quotes!D65 | Quotes!E65 | Quotes!F65 | Quotes!G65 | Quotes!H21 | Quotes!I65 | Quotes!J43 | Quotes!K21 | Quotes!L21 | Quotes!M43 | Quotes!N87 | Quotes!O43 | Quotes!P43 | Quotes!Q43 | Quotes!R87 | Quotes!S21 | Quotes!T43 | Quotes!U43 | Quotes!V43 | Quotes!W43
Vendor | MicroAge | MicroAge | Insight | Insight | Insight | Insight | Dell | Insight | MicroAge | Dell | Dell | MicroAge | PC Mall | MicroAge | MicroAge | MicroAge | PC Mall | Dell | MicroAge | MicroAge | MicroAge | MicroAge