EXCEL: SUM of only visible cells

EXCEL: SUM of only visible cells

From: http://stackoverflow.com/questions/759656/how-does-one-sum-only-those-rows-in-excel-not-filtered-out

If you are 'filtering' by hiding rows, the function number should be updated to 109.
=SUBTOTAL(109,B1:B20)

The function number 109 is for the SUM function as well, but hidden rows are ignored.

Network Load Balancing in vSphere

Network Load Balancing in vSphere: NLB in vSphere

VMware KB: Microsoft NLB not working properly in Unicast Mode

VMware KB: Microsoft NLB not working properly in Unicast Mode: Microsoft NLB not working properly in Unicast Mode

VMs Setup to Use Windows NLB in Unicast Mode Lose Network Connectivity When HP Virtual Connect Module is Replaced - VirtuallyHyper

VMs Setup to Use Windows NLB in Unicast Mode Lose Network Connectivity When HP Virtual Connect Module is Replaced - VirtuallyHyper: VMs Setup to Use Windows NLB in Unicast Mode Lose Network Connectivity When HP Virtual Connect Module is Replaced

VMware KB: Microsoft Network Load Balancing Multicast and Unicast operation modes

VMware KB: Microsoft Network Load Balancing Multicast and Unicast operation modes: Microsoft Network Load Balancing Multicast and Unicast operation modes

MICROSOFT Performing a Software True-up in Under 5 Minutes

Performing a Software True-up in Under 5 Minutes: Performing a Software True-up in Under 5 Minutes

Cisco Configuration Differences

See Cisco Configuration Differences

show archive config differences

Windows 2008 R2 multiprocessor HAL

Windows 2008 R2 - Switch to multiprocessor HAL

1. See the current HAL version: Open Device Manager and Expand COMPUTER Right-click the HAL and go to drivers tab and Update Driver to install a new one. 2. msconfig -> boot options -> advanced -> Confirm that the # processors is not defined there - uncheck the box. Also from here, there is option to "rescan for HAL"

CISCO IOS-don't pause output

I always forget this--to NOT pause output:
terminal length 0

Wireshark Troubleshooting

Wireshark Troubleshooting Videos

There is a lot of great stuff on YouTube. By the way I find it is even more excellent to watch YouTube with my Roku. But I digress. There are a lot of Laura Chappell videos about network troubleshooting with Wireshark. Much of it is in the Laura's Lab Kit distribution at: http://llk11-2014.s3.amazonaws.com/lauraslabkit11b.zip Here is one example of a great video that demonstrates Wireshark features for troubleshooting: https://www.youtube.com/watch?v=70dRbN4Y2no&feature=player_embedded&list=UUfdeux1c9erKgFAwSpTlICA Links to others and my notes from each are available in this document: Wireshark Notes

Cisco Daisy Chained Consoles

Cisco Daisy Chain Console

Daisy Chaining from one device to another can be a great backup method to access network devices without having to have a modem (or more than one.) So, if I want to be able to get to the console on a core switch at a site after having a local contact boot it up, I could enable this by connecting a cisco rollover cable from my router to the switch. This would allow me to connect to the router over the WAN side interface and then connect to the switch from the router.

Cable to buy

Need a “rollover cable.” This is the product:
Rollover Cable
http://www.cdw.com/shop/products/StarTech.com-Cisco-Console-Rollover-Cable-RJ45-Ethernet-network-cable/2437620.aspx

Setup

• connect rollover cable from router AUX port to Core Switch CONSOLE port
• Config on Router:
• line aux 0
• transport input telnet ssh

How to use

• Connect to router and logon
• telnet [ROUTER IP] 2001
• Logon
• To exit and return to router session, type CTRL+SHIFT+6 and then hit X

Catalyst Switches for Microsoft Network Load Balancing Configuration Example - Cisco Systems

Catalyst Switches for Microsoft Network Load Balancing Configuration Example - Cisco Systems: Catalyst Switches for Microsoft Network Load Balancing Configuration Example