Posts

Showing posts from July, 2018

VMware error with networking

Image
If you are facing networking issues when opening or running a vmware Virtual Machine it could be due to Network Adapter settings. The Virtual Machine opens up fine however there is no network connectivity between this VM (the guest OS) and Host machine. The networking for the Host machine is fine and it can connect to the local LAN or internet. Now if this is the case, then one needs to investigate the guest Virtual Machine's Network Adapter. aa Above figure shows the current Network Adapter settings for guest VM. This shows that the guest VM is connected to the Host machine via Bridged Network Adapter. What this means is that the guest Virtual Machine is now accessing the Local network directly - of course it can only do that by sharing the Host machine's network adapter. Hence, it can obtain its own independent IP address from the Local network if the Local network has DHCP enabled. So the guest VM will appear as another machine on the subnet as shown in below fig

How to Merge data from Two Spreadsheets based on a common attribute

Image
This post is about generating a combined report off two different Spreadsheets. The use case is as follows  -   you have data from two different Excel spreadsheets and need to merge or combine the two spreadsheets into a single Spreadsheet based on a common attribute. For example, say you have two Spreadsheets about Employees in one spreadsheet as below with their First Name, Last Name, Department and email. First Name Last Name Department email Alice King Database king.alice@abc.com Bob Martin Networking martin.bob@abc.com Frank Jones Operations jones.frank@abc.com Alex Miller Engineering miller.alex@abc.com Simmons Young Database young.simmons@abc.com Greg Baker Software Dev baker.greg@abc.com Harry Walker ESD walker.harry@abc.com Edward Johnson Config Management johnson.edward@abc.com Phil Evans Operations evans.phil@abc.com Adam Morgan Infrastructure morgan.adam@abc.com And a second spreadsheet which has data about the employees Telephone and Office Locatio