Blogs

Extending USB and VGA

You probably already ordered these by now, you'll want a quantity of 5 more of these on hand for the second port on the island tables. These are the same as the ones you already order and we've tested.

You'll want a quantity of 5 more of these 25' cables to give the second monitor (patient) the ability to display the pc screen. These do not have the audio cable so they have less chance catching on anything when we pull them through.

Extending Monitor & USB Capabilities Over 15 Feet

The price for a 15' VGA Cable is the same cost as 25'

Also need an option if the furniture has a "B" style USB plug on the back to already accommodate an existing cable for adapter, you can always return it;

Xerox M20/M20i Printer Network Card Cost Analysis TCO vs Replacement

The Xerox M20/M20i printer, copier, scanner has a purchase value of $299, since this is a discontinued model, a used one with the network card already in it can be purchased for this amount in full.

The network card kit for the Xerox M20/M20i costs $269 to add this feature to an existing Xerox M20/M20i printer, making a Xerox M20/M20i printer without that feature effectively worth only about $30.

The recommended path is to replace the printer, copier, scanner with a newer recommended Xerox network printer model specifically for the features you're looking for and in fact becomes less expensive from a total cost of ownership standpoint, as the base price is $229.

Stylish HP Laptops And Bag

Pavilion g6-1c71ca Notebook PC (A1Z88UA) - Refurbished

Pavilion g6-1c71ca Notebook PC (A1Z88UA) - Refurbished

HP Pavilion g6-1c71ca: Intel Core i3-2330QM Processor(2.2) 6G 750G SuperMulti DVD burner High-Definition LED HP BrightView Display (1366x768) 15.6" Webcam Win7






$449

Pavilion g6-1c54wm Intel Pentium B950 2.10GHz Notebook PC - 4GB RAM  500GB HDD  15.6 HD LED  SuperMulti DVD  Fast Ethernet  802.11b/g/n  Webcam  6-cell Li-Ion

Pavilion g6-1c54wm Intel Pentium B950 2.10GHz Notebook PC - 4GB RAM 500GB HDD 15.6 HD LED SuperMulti DVD Fast Ethernet 802.11b/g/n Webcam 6-cell Li-Ion

Intel Pentium B950 2.10GHz 4GB DDR3 SDRAM 500GB 5400rpm HDD 15.6" HD LED Display SuperMulti DVD Intel HD Graphics Webcam Fast Ethernet 802.11b/g/n Microsoft Windows 7






$384



Cisco 24-Port Gigabit POE 200 Series Smart Switch

Cisco SG200-26P Gigabit Ethernet Smart Switch, 24 10/100/1000 Ports, PoE and 2 Combo Mini-GBIC Ports (SLM2024PT)

Get the high availability and performance you need to support vital business applications while reducing downtime.
Advanced Features: Control network traffic with advanced features such as quality of service (QoS), Layer 3 static routing and IPv6 support.
Intuitive browser-based tools, mass deployment capabilities, and consistent features across all models simplify setup and configuration.
Switches optimize power usage for energy efficiency without compromising performance.

HP Printer Picks

HP Officejet 4500 All-in-One Multifunction Color Inkjet Printer

HP Officejet 4500 All-in-One Multifunction Color Inkjet Printer

This affordable flatbed all-in-one prints professional-quality color is designed for a low cost per page. Productive and reliable this all-in-one can help you stay on task at






$99.99

Photosmart Premium e-All-in-One Printer - C310a with support for Apple's AirPrint - Refurbished

Photosmart Premium e-All-in-One Printer - C310a with support for Apple's AirPrint - Refurbished

3-in-1: print copy scan Prints 11 ppm black 8 ppm color (ISO-based) 4.3" CGD (color graphics) Touchscreen Built-in wireless 802.11b/g/n 125-sheet input tray 20-sheet p






$79.99

Officejet 4500 Wireless All-in-One Printer (Open Box Product  Limited Availability  No Back Orders)

Officejet 4500 Wireless All-in-One Printer (Open Box Product Limited Availability No Back Orders)

Enjoy the convenience of wireless connectivity with the HP Officejet 4500 Wireless All-in-One Printer. You'll be able to print copy scan and fax all from one device plus p






$90.95

Laptop and Ultrabook Picks

Series 5 Ultrabook 530U3BI Intel Core i5 2467M 1.6GHz Notebook - 4GB RAM  500GB HDD  13.3 Widescreen LED backlight display  Intel HD Graphics 3000  Gigabit Ethe

Series 5 Ultrabook 530U3BI Intel Core i5 2467M 1.6GHz Notebook - 4GB RAM 500GB HDD 13.3 Widescreen LED backlight display Intel HD Graphics 3000 Gigabit Ethe

Intel Core i5 2467M 1.6GHz 4GB DDR3 SDRAM 500GB Serial ATA HDD 13.3" Widescreen LED backlight display Intel HD Graphics 3000 Gigabit Ethernet 802.11 a/b/g/n Microsoft W






$899.99

Smart Buy ENVY Pro Intel Core i5-3317U 1.70GHz Ultrabook 4 - 4GB RAM  32GB SSM + 320GB HDD  14.0 LED-backlit HD  802.11a/b/g/n  Bluetooth  Webcam  4-cell Li-Ion

Smart Buy ENVY Pro Intel Core i5-3317U 1.70GHz Ultrabook 4 - 4GB RAM 32GB SSM + 320GB HDD 14.0 LED-backlit HD 802.11a/b/g/n Bluetooth Webcam 4-cell Li-Ion

Intel Core i5-3317U 1.70GHz 4GB 1600MHz DDR3 SDRAM 32GB SSM + 320GB 7200rpm SATA 14.0" LED-backlit HD Display Intel HD Graphics 4000 Webcam 802.11a/b/g/n Bluetooth Mic






$835.99

Aspire ONE 722-0022 AMD C-60 1GHz Netbook - 4GB RAM  500GB HDD  11.6 Widescreen LED backlight CineCrystal  AMD Radeon HD 6250  10/100 Ethernet  802.11b/g/n  6-c

Aspire ONE 722-0022 AMD C-60 1GHz Netbook - 4GB RAM 500GB HDD 11.6 Widescreen LED backlight CineCrystal AMD Radeon HD 6250 10/100 Ethernet 802.11b/g/n 6-c

AMD C-60 1GHz 4GB DDR3 1066MHz SDRAM 500GB Serial ATA HDD 11.6" Widescreen LED backlight CineCrystal AMD Radeon HD 6250 10/100 Ethernet 802.11b/g/n Microsoft Windows 7






$374.99

11.6 MacBook Air dual-core Intel Core i5 1.6GHz  2GB RAM  64GB Flash Storage  Intel HD Graphics 3000  Mac OS X Lion

11.6 MacBook Air dual-core Intel Core i5 1.6GHz 2GB RAM 64GB Flash Storage Intel HD Graphics 3000 Mac OS X Lion

1.6GHz dual-core Intel Core i5 2GB DDR3 SDRAM 64GB Flash Storage Intel HD Graphics 3000 11.6" LED-backlit glossy widescreen display Bluetooth 4.0 FaceTime camera built-






$899.99

Laptop and Desktop Deals

ThinkCentre M71z 1761 - C G530 2.4 GHz - 20 TFT

ThinkCentre M71z 1761 - C G530 2.4 GHz - 20 TFT

Lenovo ThinkCentre M71z 1761 - All-in-one - 1 x C G530 / 2.4 GHz - RAM 2 GB - HDD 1 x 320 GB - DVD-Writer - HD Graphics - Gigabit Ethernet - Windows 7 Professional 64-bit - Mo






ThinkPad Edge E530 3259 - 15.6 - Core i5 2450M - Windows 7 Professional 64-bit - 4 GB RAM - 500 GB HDD

ThinkPad Edge E530 3259 - 15.6 - Core i5 2450M - Windows 7 Professional 64-bit - 4 GB RAM - 500 GB HDD

Lenovo ThinkPad Edge E530 3259 - Core i5 2450M / 2.5 GHz - Windows 7 Professional 64-bit - 4 GB RAM - 500 GB HDD - DVD-Writer - 15.6" wide 1366 x 768 / HD - Intel HD Graphics






Pittsburg Title LLC Lenovo All-In-One Project

Becky, this is the price spread on the all-in-one Lenovo models I am recommending to you. If purchased through this site, they'll be drop shipped directly from MacMall/PCMall to your business. Click on the "buy" link here, then immediately on the "add to cart" link on the next page that comes up and you'll be able to complete the transaction, it may also say "click here to see the lowest price" on the next page, to receive the price shown below. These are the only three models right now I would recommend to you. In these situations, you'll be doubling the specifications on what you have right now, which is a good rule of thumb. Also, on the purchasing page, you do not need to select a service plan, Option 1 is a really sleek look I must say.

Option 1

ThinkCentre Edge 91z 7075 - P G850 2.9 GHz - 21.5 TFT

ThinkCentre Edge 91z 7075 - P G850 2.9 GHz - 21.5 TFT

Lenovo ThinkCentre Edge 91z 7075 - All-in-one - 1 x P G850 / 2.9 GHz - RAM 4 GB - HDD 1 x 320 GB - DVD-Writer - HD Graphics - Gigabit Ethernet - WLAN : 802.11b/g/n - Windows 7






$803.99


ThinkCentre Edge 91z 7075 - P G850 2.9 GHz - 21.5 TFT

Option 2

TopSeller ThinkCentre M90z Intel Pentium Dual Core G6960 2.93GHz All-In-One - 2GB DDR3 RAM  320GB SATA HDD  23.0 Full HD 1080p Display  DVD±RW  Gigabit Ethernet

TopSeller ThinkCentre M90z Intel Pentium Dual Core G6960 2.93GHz All-In-One - 2GB DDR3 RAM 320GB SATA HDD 23.0 Full HD 1080p Display DVD±RW Gigabit Ethernet

Intel Pentium Dual Core G6960 2.93GHz 2GB DDR3 RAM 320GB SATA HDD 23.0" Full HD 1080p Display DVD±RW Gigabit Ethernet 802.11b/g/n wireless 2.0MP Camera 150 Watts Power






$799.00


TopSeller ThinkCentre M90z Intel Pentium Dual Core G6960 2.93GHz All-In-One - 2GB DDR3 RAM 320GB SATA HDD 23.0 Full HD 1080p Display DVD±RW Gigabit Ethernet

Option 3

ThinkCentre M71z 1761 - C G530 2.4 GHz - 20 TFT

ThinkCentre M71z 1761 - C G530 2.4 GHz - 20 TFT

Lenovo ThinkCentre M71z 1761 - All-in-one - 1 x C G530 / 2.4 GHz - RAM 2 GB - HDD 1 x 250 GB - DVD-Writer - HD Graphics - Gigabit Ethernet - Windows 7 Professional 64-bit - Mo






$635.99


ThinkCentre M71z 1761 - C G530 2.4 GHz - 20 TFT

Using vlookup Fuction in Microsoft Excel to Merge Data From Two Different Sets

vloopkup is a function of Excel that can be used to merge the data from one set to another. For instance, if I have a spreadsheet with two columns, one is an ID number, the other is the persons car they drive. We'd like the ID number to instead read as, the persons name. However, the reference for this is in another spreadsheet.

The first step is to insert the reference spreadsheet into the first spreadsheet as another workbook. So that they're in the same file. Identify the column in this first workbook you want the new data to be in (along side the car for example), select the vlookup function, Highlight the entire column of the first worksheet with the ID number, this tells the function where to see the ID number from.

Select the first blank of the first column and the last row of the second column as the table_array variable of this vlookup function.

It helps if the reference is in some logical order, perhaps numerically from 10001 to 50001 as in this example.

The last blank identifies if the match will be exact, enter FALSE or the number 0 works here.

This use of this function comes in very handy when modifying SQL or other Database records that have been exported to CSV. Often relational databases only use reference numbers in one table, but store users and other data in a completely separate table. When doing reports and other management functions, you may encounter the need for such a tool.

Syndicate content