Posts

Showing posts from April, 2018

Increase LAN speed in Network

Image
How to increase LAN Speed with disabled LSO. Large Send Offload is a technique of improving network performance while at the same time reducing CPU overhead. Apparently it does not work very well, so it was suggested to disable it. If you would like to know about LSO, check this  MSDN  article from 2001. LSO is an option located in a Device Manager under your network adapter, so this solution requires Administrator Privileges. Follow these steps: Open Start Menu, right-click on  Computer  and select  Properties Under  Control Panel Home  located on the left side of the window click on  Device Manage r You will get a list of all devices on your machine. Expand  Network Adapters . Find your Network Card and double-click on it. Select  Advanced tab . You will get a list filled with different options. Select  Large Send Offload V2 (IPv4)  and set the value to  Disabled Do the same for  Large Send...

How to convert Number into word in Excel?

Image
How to convert Number into word in Excel? 1. Open MS Excel. 2. Press Alt+F11 it will open Visual Basic editor. 3. Click on Insert->Module 4. In module copy following code and paste it. ============================================ Function SpellNumber(amt As Variant) As Variant Dim FIGURE As Variant Dim LENFIG As Integer Dim i As Integer Dim WORDs(19) As String Dim tens(9) As String WORDs(1) = "One" WORDs(2) = "Two" WORDs(3) = "Three" WORDs(4) = "Four" WORDs(5) = "Five" WORDs(6) = "Six" WORDs(7) = "Seven" WORDs(8) = "Eight" WORDs(9) = "Nine" WORDs(10) = "Ten" WORDs(11) = "Eleven" WORDs(12) = "Twelve" WORDs(13) = "Thirteen" WORDs(14) = "Fourteen" WORDs(15) = "Fifteen" WORDs(16) = "Sixteen" WORDs(17) = "Seventeen" WORDs(18) = "Eighteen" WORDs(19) = "Nineteen" te...