Cheat sheet: What 4G LTE frequency bands does AT&T, Verizon, T-Mobile use in the US?

Carrier4G LTE band
АТ&T2, 4, 5, 12, 17, 29, 30, 66
Verizon2, 4, 5, 13, 66
T-Mobile2, 4, 5, 12, 66, 71
Viettel1, 3, 7
Mobifone3, 7
Vinaphone1, 3
Device4G LTE band
Moxee Mobile Hotspot2, 4, 5, 12, 13, 25, 26, 41, 66, 71
Franklin T9 Mobile Hotspot2, 4, 5, 12, 25, 26, 41, 66, 71
TMOHS1 Mobile Hotspot2, 4, 5, 12, 25, 26, 41, 66, 71
Coolpad Surf2, 4, 12, 66, 71
iPhone SE A16621, 2, 3, 4, 5, 8, 12, 13, 17, 18, 19, 20, 25, 26, 29

GL.Inet TTL Change

I use a GL-X750 for internet access while I travel, and while I have an unlimited dataplan is seems some carriers in the us play funny buggers and “de priortise” data from secondary devices. I have found this work around to function for me…. we are changing the TTL of all connected devices, so its harder for the carrier to work out what device is what.

  • Step 1: Login to your device
  • Step 2: More Settings -> Advanced
  • Step 3: Login again
  • Step 4: Network -> Firewall
  • Step 5: Custom Rules -> Add entry
  • Step 6: Restart

Step 1: Login to your device

Login

Step 2: More Settings -> Advanced

Advanced Settings

Step 3: Login again

Yes – the username will be root, the password will be your admin password. Your path will be https://x.x.x.x/cgi-bin/luci

Login 2

Step 4: Network -> Firewall

Firewall

Step 5: Custom Rules -> Add entry

You want to click on custom rules, then go right to the bottom. Here add this line:

#Change TTL
iptables -t mangle -I POSTROUTING 1 -j TTL --ttl-set 65
Firewall

Step 6: Restart

Once done, click on the restart firewall, and you should be set after a reboot. This worked for me, your milage may vary.

Source: https://jv.ag/blog/GLinet-TTL-Change/


Install OpenVPN on CentOS 8

In this tutorial i will guide you through the installation of OpenVPN on CentOS 8.
We are going to use a script that makes this installation very easy!

Start by running a CentOS update
yum update
Confirm the download with Y when it asks you to

Now we are able to install EPEL and Git
yum install epel-release git

Download the OpenVPN installer
git clone https://github.com/Nyr/openvpn-install.git

Run the installer
cd openvpn-install
chmod +x openvpn-install.sh
sudo ./openvpn-install.sh

The installer will ask you some questions, fill in the following answers:

Which protocol: 1
What port: 1194
Which DNS: 1 
Client name: your name

The installation is now finished, import the .ovpn file in /root to the device you want to use as client

https://www.vpsserver.com/community/tutorials/4035/install-openvpn-on-centos-8/


Cricket Wireless referral link

$25 for you and $25 for me. Here is my referral link:

https://www.cricketwireless.com/l/refer-a-friend.html?hash=yxdrpdcv&type=message

Step 1: Before purchasing your phone or plan, click on my referral link to generate the $25 referral coupon. Once a referral code is generated, it expires within 30 days – purchase and activate during this time period. (Check spam folder)

Step 2: IMMEDIATELY after activating your new phone, enter your unique referral code emailed to you in the  “Everything’s Better with Friends” section of the myCricket app or Cricket online website. After inputting referral code, you will see a 60 day countdown tracker in the  “Everything’s Better with Friends” section on when your $25 credit is credited.


$30 H2O Wireless referral code

Here is my referral link:

https://bit.ly/2VGTb7Y

Click the referral link to get your ‘one-time use’ coupon code.
Copy and Paste your ‘one-time use’ coupon code at checkout on h2owireless.

You will get:
✔ Free H2O Wireless SIM*
✔ Free Standard Shipping*
✔ $30 H2O Rewards Credit**

* When you purchase a plan or phone
** Credit is added on your rewards account at the time of activation/port in

P/S: Don’t buy H2O SIM card from Best Buy or another places, you only get the points if you get the free SIM card through the link.


How to create a bootable UEFI USB drive with Windows 10 Setup

Previously, I showed you how to install Windows 10 using a bootable USB stick. This method is suitable for devices which boot using the legacy BIOS mode. If you need a UEFI bootable USB stick, the earlier-mentioned method will not work. In this article, we will see how to create a bootable UEFI USB drive containing Windows 10 Setup.

It is a good idea to use the Rufus tool to prepare the bootable UEFI Windows 10 USB drive. Rufus is free and works without any issues. Also, it is a portable app so it does not require itself to be installed. Here are the step-by-step instructions:

  1. Download the latest version of Rufus from HERE.
  2. You need a USB drive with at least 4 GB available. All data on this drive will be erased, so it is a good idea to backup everything from this USB drive before proceeding.
  3. Run the Rufus utility and pick your USB drive under the Device section.
  4. Select the partition scheme for UEFI computers with MBR. If your PC has a GPT partition scheme (GUID Partition Table), then pick the appropriate option from the combobox.
  5. Click on the CD/DVD drive icon to browse to the Windows 10 ISO image file. Select the Windows 10 ISO image file – 32-bit or 64-bit – whichever you downloaded.
    If you do not have the ISO image, here’s how you can build your own: Get ISO image for Windows 10 build 9860 for a clean install.
Windows 10 UEFI USB

After you click the Start button in Rufus, it will create a bootable UEFI USB stick with Windows 10. That’s it. You are done.

Soure: https://winaero.com/blog/how-to-create-a-bootable-uefi-usb-drive-with-windows-10-setup/


How to Upgrade Laptop Hard Drive to SSD without Reinstalling Windows

Got a old Laptop? Want to make it faster? Don’t want to reinstall Windows? Well replacing the Hard Drive with a SSD Solid State Drive is a great way to give a new lease of life to a old Laptop. You will need a SATA to USB cable, Small screw drive, a SDD and Minitool Partition Wizard FREE Edition.

I will show you the step by step process to successfully migrating / clone you operating system from Hard Drive to SSD without reinstalling Windows. Samsung 850 EVO 250 GB 2.5 inch Solid State Drive – Black

MiniTool Partition Wizard Free Edition 10.0
CrystalDiskMark


Calculate payment for a loan by Excel

Excel formula: Calculate payment for a loan

Generic formula 

=PMT(rate,periods,-amount)

Explanation 

To calculate a loan payment amount, given an interest rate, the loan term, and the loan amount, you can use the PMT function. In the example shown, the formula in C10 is:

=PMT(C6/12,C7,-C5)

How this formula works

Loans have four primary components: the amount, the interest rate, the number of periodic payments (the loan term) and a payment amount per period. You can use the PMT function to get the payment when you have the other 3 components.

For this example, we want to find the payment for a $5000 loan with a 4.5% interest rate, and a term of 60 months. To do this, we configure the PMT function as follows:

rate – The interest rate per period. We divide the value in C6 by 12 since 4.5% represents annual interest, and we need the periodic interest.

nper – the number of periods comes from cell C7; 60 monthly periods for a 5 year loan.

pv – the loan amount comes from C5. We use the minus operator to make this value negative, since a loan represents money owed.

With these inputs, the PMT function returns 93.215, rounded to $92.22 in the example using the currency number format.


How to calculate how much a mortgage payment would cost you every month

You can calculate your monthly mortgage payment, not including taxes and insurance, using the following equation:

M = P [ i(1 + i)^n ] / [ (1 + i)^n – 1 ]

P = principal loan amount
i = monthly interest rate
n = number of months required to repay the loan

Once you calculate M (monthly mortgage payment), you can add in the monthly property tax and homeowners insurance premium, if you have them. These are fixed costs that aren’t determined by how much you borrow from the bank, so they can easily be added to the monthly cost.