M. Mukesh Kumar

[mmkumr]

Linking a value from one Google Sheet (Excel) to another

1. Copy the source spreadsheet URL

2. Go to the destination spreadsheet

3. Type the IMPORTRANGE formula:

=IMPORTRANGE("<Source Speedsheet URL>", "<Sheet Name>!<Cell Name>") Source Speedsheet URL: Copy Google sheet URL from the URL bar. Example: "https://docs.google.com/spreadsheets/d/........../edit" Sheet Name: Name of the sheet from another Google sheet. Example: 'March Sales' Cell Name: Name of the cell from another Google sheet. Example: 'E12'

[mmkumr]

Adb connect automation

Code for fetching the IP and port address of ADB paired devices:

ip=avahi-browse --terminate --resolve _adb-tls-connect._tcp | grep "address " | tail -1 | grep -o -E '[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}' port=avahi-browse --terminate --resolve _adb-tls-connect._tcp | grep "port " | head -1 | tr -d -c 0-9 adb connect $ip:$port

[mmkumr]

Hacks for life

1. Check the colors of the other person's eyeballs for maintaining eye contact.

2. Send scheduled email to self. It may be a task, future predictions and other interesting things. 3. Don't try to remember important things. Note them somewhere. 4. Predict the future at certain intervals note it. Check them again while updating the new one. 5. Address people by their names instead of hey or hello. 6. Always ask "by when did you need this"(deadline). When someone assigns a task. 7. Put a timer limit on the apps which you tend to waste time. 8. Create a personal Whatsapp group. 9. Don't watch the news only read it. 10. Separate bank account, for investment. 11. If having any loan. Just keep the money to pay the next two loans in advance + 15% of the loan value. 12. 30-day rule: Some things may feel important to buy but you are confused. Then wait for 30 days and if still need then it is important. 13. Pay through credit cards and save money, in the bank. So, you will get interest on the amount kept in the bank and receive credit points on payment. But pay the bills on time. 14. Help strangers whenever they want help. 15. Smile at the mirror. 16. Follow positive thoughts and people. 17. Teach people. The more you teach more you learn.

Credits: Ankur Warikoo

[mmkumr]

Telescope Neovim plugin

Today was facing problem while using grep_string and other grep related functions through telescope after tweaking for so many minutes. I discovered that this plugin depends on 'ripgrep'(system package) package.

[mmkumr]

Metal weight calculator

Recently I found a website by which we can measure the weight of the metal by selecting the material type, material density, shape of the object, etc.

The link to the website is: https://www.gigacalculator.com/calculators/metal-weight-calculator.php

[mmkumr]

Arduino based micro-controller simulator

Recently I discover a website that can be used for simulating the working of Arduino nano, Arduino UNO, Arduino mega, ESP32, Raspberry Pi Pico. We can also connect some basic electrical components for the simulation of the circuit. We can also provide serial input but before that, once we have to print the serial output.

The link for the website is: https://wokwi.com

[mmkumr]

Permission problem Arduino or other serial programmable board.

While burning the program to Arduino or other serial programmable board normally shows permission error. To fix the error, we can follow the below steps:

Step 1:

# For original Arduino boards

ls -l /dev/ttyACM* # for checking the group name(4 line)

# For ESP boards/ Arduino clone boards

ls -l /dev/ttyUSB* # for checking the group name(4 line)

Step 2:

sudo usermod -a -G <group-name> <current-user-name> # For adding the current user to the displaced group.

Step 3: Reboot

[mmkumr]

Flutter: For loop inside widget

Today I have learnt how to use for loops inside widget which supports children parameter.

syntax for that is:-

for(loop parameters)

   widget,

Example:

Row(        children: [          for (int i = 0; i < widget.bnIcons.length; i++)            Expanded(              child: Column(                children: [                  IconButton(                    icon: Icon(                      widget.bnIcons[i],                      size: 40,                      color: Colors.white,                    ),                    onPressed: widget.bnfunc[i],                  ),                  Text(                    widget.bnTitle[i],                    textAlign: TextAlign.center,                    style: TextStyle(                      color: Colors.white,                    ),                  ),                ],              ),            ),        ],      ),

widget.bnTitle, widget.bnfunc and widgets.bnIcons are the variable which are list which is previously declared.

[mmkumr]

Enabling label text in Trello

In Trello’s web version it only shows label color on the card. But if you have multi label then it may cause confusion. So, press ‘;’  for enabling “show text on label“.

[mmkumr]

Executing i3lock after suspend

Normally in i3wm tiling manager it doesn’t automatically lock the screen after suspend mode. For automating this process we can add the below line to our i3 config file:-

exec --no-startup-id xss-lock --transfer-sleep-lock -- lock --nofork

The word after --transfer-sleep-lock -- is name of the command which you want to run before system suspend (i.e. the word “lock”). I am using arch Linux. So, I have installed a package named as ‘i3lock-color’ from aur. I have also written one script for i3lock-color and stored it as executable.

i3lock-color script:-

#!/bin/sh

B='#00000000'  # blank

C='#ffffff22'  # clear ish

D='#ffffffcc'  # default

T='#ee00eeee'  # text

W='#880000bb'  # wrong

V='#bb00bbbb'  # verifying

i3lock \

--insidevercolor=$C   \

--ringvercolor=$V     \

\

--insidewrongcolor=$C \

--ringwrongcolor=$W   \

\

--radius=150          \

--insidecolor=$B      \

--ringcolor=$D        \

--linecolor=$B        \

--separatorcolor=$D   \

\

--verifcolor=$T        \

--wrongcolor=$T        \

--timecolor=$T        \

--datecolor=$T        \

--layoutcolor=$T      \

--keyhlcolor=$W       \

--bshlcolor=$W        \

\

--ignore-empty-password \

--blur 8              \

--clock               \

--indicator           \

--timestr="%l:%M:%S %p"  \

--datestr="%A, %m %Y" \

--screen 1            \

You can get more information by checking the man page of i3lock. After installing i3lock-color package.

[mmkumr]

Bluetooth adapter problem in Arch Linux

After fresh installation of Arch Linux I was facing problem to enable Bluetooth. I was facing this problem because of drivers mismatch in Linux-firmware package of arch(Common problem in latest version of Linux-firmware ). We can easily fix this problem by running the below commands.

pacaur -S bcm20702a1-firmware sudo modprobe -R btusb sudo modprobe btusb systemctl start bluetooth.service systemctl enable bluetooth.service

Still if Bluetooth doesn’t work then restart you computer then check your Bluetooth adapter.

[mmkumr]

System time problem in arch

Today I was facing problem for setting up system time. I was trying to set my system time because I was getting ‘invalid grant‘ error in Firebase realtime database plugin of PHP. So I have used the below command to fix the system time.

timedatectl set-ntp true

[mmkumr]

Stock Market lecture 3

Today I have completed my second stock market lecture, which is titled 'The 2 Ways Investors Make Money in Stocks'.

The things which I have learned from this lecture are:-

The ways by which investors make money in stocks are:

Capital Appreciation: Investors will make money by buying a stock at a lower price and selling a stock at a higher price. problems with this type of stock trading are some times stock may go very low and may never recover.

Dividends: Stock value may or may not rise but an investor will get passive income quarterly. It is risky because some times the company may reduce the dividends or eliminate the dividend completely in some conditions.

You can combine both techniques i.,e Capital Appreciation with Dividends.

[mmkumr]

Fingerprint validation in laptop.

I am using Arch Linux on my laptop. Today I have learned how to use fingerprint validation for lock-screen, ‘su’ and ‘sudo’. I am using ‘fprint’ drivers for fingerprint validation.

For enabling the fingerprint validation for lock-screen add the below line to your ‘/etc/pam.d/system-local-login‘ at the top of the file.

auth            sufficient      pam_fprintd.so

For enabling the fingerprint validation for su command add the below line to your ‘/etc/pam.d/su‘ at the top of the file.

auth            sufficient      pam_fprintd.so

For enabling the fingerprint validation for lock-screen add the below line to your ‘/etc/pam.d/system-local-login‘ at the top of the file.

auth            sufficient      pam_fprintd.so

[mmkumr]

Stock Market lecture 2

Today I have completed my second stock market lecture, which is titled 'Are Stocks Risky What's The Worst Case Scenario'.

The things which I have learned from this lecture are:-

In some cases, stocks may be risky because stock values may decline in some critical conditions and at that time we can't even sell the stocks.

A rate of return is the net gain or loss on an investment over a specified time period.

Compound annual growth rate is a 'rate of return' calculation in which we have to assume that interests of growth will remain the same for every year and profits were reinvested at the end of each year of the investment’s lifespan. This technique is relevant for calculating returns of a very short time period because over a long period interest of growth will not remain the same.

We can calculate CAGR at http://www.moneychimp.com/features/market_cagr.htm

[mmkumr]

Stock market course lecture 1

Today I have completed my first stock market lecture, which is titled 'Can You Make Money In Stocks?'.

The things which I have learned from this lecture are:-

1. We can make more money using stocks, over a long period. Trying to make money from stocks may be risky, over a short period because stocks may go up and down on a short period. For example, you can check out the below graph. 

2. The Dow Jones Industrial Average (DJIA), is a stock market index that measures the stock performance of 30 large companies listed on stock exchanges in the United States.

3. By observing the DJIA graph we can analyze the risks/returns of the stocks over 90 years of time period. By check the below table you can understand the analysis.

[mmkumr]

Planning for 21 days lockdown.

Inda has been lockdown for 21 days(25/03/20202 to 15/04/20202). So I have planned to complete some tasks within the remaining 20 days. The tasks which I have to complete are:-

Since I haven't posted anything for many days. I will post an article about my day to day changes every day, on my blog. For getting habituated with personal blogging.

I will complete my online course on stock marketing.

I will complete my project, 'Quadcopter Delivery'.

Practicing for 100 pushups per day.