Router/Wifi/BT Tips

How to enforce channel on a router that auto selects WiFi channel.

https://broadbandforum.co/t/205631/

https://setuprouter.com/router/beetel/777vr1/wifi.htm

Indian Railways Train Booking

IRCTC (Official)
Better Way To Search Trains
Indian Rail UTS Booking (Official)
Coach Position
Seat Map
Indian Rail Enquiry (Official)

Mirror your android phone to Windows, Use computer mouse to control android screen

Vysor - https://www.vysor.io/ DeskDock - https://www.malavida.com/en/soft/deskdock-server/

Comparison of various Masala (Spice Blend)

Garam Masala	Kitchen King	Tandoori Masala
Ingredients	Ingredients	Ingredients
dalchini	dalchini	-
nutmeg	nutmeg	nutmeg
javetri	javetri	-
tejpatta	tejpatta	-
stars	stars	-
cardomom	cardomom	-
black pepper	black pepper	black pepper
-	coriander powder	coriander powder
-	chilli powder	-
-	haldi	-
-	-	cumin
-	-	garlic powder
-	-	ginger
-	-	cloves
-	-	mace
-	-	fenugreek
-	-	cinnamon
-	-	cardamom
When it is added	When it is added	When it is added
After the vegetable is cooked.	Generally mixed during tadka. It does not have a strong flavour like garam masala.	Basically used to marinate food stuff for barbecue. never used when you are preparing any gravy.
-	It does not have a strong flavour like garam masala.	Never used when you are preparing any gravy.

Creating Pandas Dataframe from Google Drive Sheet

1. Create Service Account Key from Google Developers Console

2. Generate JSON auth key

3. Share the google sheet with the client-email id mentioned in json file.

4. Enable Google Drive API

https://console.developers.google.com/apis/api/drive.googleapis.com/overview?project=888700935625

4. Enable Google Sheets API

https://console.developers.google.com/apis/api/sheets.googleapis.com/overview?project=888700935625

GSpread Library Documentation

https://gspread.readthedocs.io/en/latest/index.html

5. Using files stored in Google Drive in Google Collab

Enable the Google Drive File Stream API

https://accounts.google.com/o/oauth2/auth?client_id=947318989803-6bn6qk8qdgf4n4g3pfee6491hc0brc4i.apps.googleusercontent.com&redirect_uri=urn%3aietf%3awg%3aoauth%3a2.0%3aoob&scope=email%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdocs.test%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive.photos.readonly%20https%3a%2f%2fwww.googleapis.com%2fauth%2fpeopleapi.readonly&response_type=code

Reference: 

https://medium.com/@vince.shields913/reading-google-sheets-into-a-pandas-dataframe-with-gspread-and-oauth2-375b932be7bf

https://towardsdatascience.com/how-to-import-google-sheets-data-into-a-pandas-dataframe-using-googles-api-v4-2020-f50e84ea4530

Send Mail from SMTP Java Client using GMAIL

MAIL SETTINGS
hostname=smtp.gmail.com
username=emailid@gmail.com
password=pass@word
smtp.port=587
#smtp.port=465
smtp.auth=true
smtp.starttls.enable=true

2 Additional Settings to be done in Google Account Settings

1. Allow less secure app access via link.
2. Turn off via link.
• Use your phone to sign in
• 2-Step Verification

SIM / IMSI / ICCID / MCC / MNC

Links

SIM Card/ICCID Validation

MCC/MNC/ISD Worldwide List

Glossary

Subscriber Identification Module (SIM)

Mobile country code (MCC)

Mobile network code (MNC)

Mobile subscription identification number (MSIN)

Integrated Circuit Card Identifier (ICCID) - 20 digits

Identifier for the physical SIM card which is printed on the card.

Format: 19 digits + 1 check digit

Convention: 89 (Fixed for Telecommunications) + Country/ISD Code (2/3 digits) + MNC (2/3 digits) + Remaining Random Digits + Checksum (1 digit)

Sample ICCID of Dhiraagu, Maldives: 89-960-01-304113000001-9

Sample ICCID of Bharti, India: 89-91-10-200531661351-0

Sample ICCID of Bharti, India: 89-91-10-210547493854-1

Online ICCID Decoder

International Mobile Subscriber Identity (IMSI) - 15 digits

1 SIM can have multiple IMSI. ESIM also has a virtual IMSI.

Format: 15 digits

Convention: MCC (3 digits) + MNC (2/3 digits) + MSIN (Remaining Random Digits)
Sample IMSI of Dhiraagu, Maldives: 47201-0013000001

Standard phones have a IMEI and S/N.

Standard phones supporting dual SIM have a IMEI1, IMEI2 and S/N.

Phones supporting eSIM have a IMEI, S/N and a ICCID.

General Windows Tips

Enable Active Scripting
Error while refreshing the Excel data from external source

Enable Desktop Sharing in Win10 to Chromecast

Enable below 2 flags