Search This Blog

Search Engine

Custom Search

20191030

Names of 8 Vasus

Reference - Srimadbhagvat Puran 6.6.10

Sons of Vasu were 8 Vasu

Their names are as below 

1) Drone

2) Praan

3) Dhruva

4) Arka

5) Agni

6) Dosh

7) Vasu

8) Vibhavasu

20191028

AQI range

AQI - Air Quality Index

0-50 AQI
Good

51-100 AQI
Satisfactory

101-200 AQI
Medium level

201-300 AQI
Bad

301-400 AQI
Risky to Health

20191025

10 wives of Dharma

Reference - Srimadbhagvat Puran 6.6.3


1) Bhaanu

2) Lamba

3) Kakubh

4) Jaami

5) Vishwa

6) Saadhya

7) Marutwati

8) Vasu

9) Muhurta

10) Sankalpa

20191021

Hindu Mythology Links

List of Sanskrit Phrases

20191016

10 tips to make excel file speedier

1) Avoid NOW () formula and TODAY() formula as far as possible
2) Avoid Random formula called RAND
3) AVOID array formulas and adopt Helper columns
4) Avoid Conditional formatting as far as possible as this feature is volatile.
5) Used Named ranges ie instead of A:A use A1:A10

6) Prefer static values in place of unused formulas
7) Use manual calculation mode by going through Formula Tab - Calculation options - Manual (press F9 key to recalculate) Don't let excel recalculate automatically and waste your time.
8) Use Iferror instead of if and iserror
9) Use Max formula where possible in place of If formula
10) Use Index/Match combination in place of Vlookup


20191011

7 Visible Color wavelengths to humans in range 380nm to 750nm





Colours of the visible light spectrum.png
By Meganbeckett27 - Own workCC BY-SA 3.0Link


7 Color Wavelengths

  1. Violet - 380–450 nm
  2. Blue - 450–475 nm
  3. Cyan - 476–495 nm
  4. Green - 495–570 nm
  5. Yellow - 570-590 nm
  6. Orange - 590-620 nm
  7. Red - 620-750 nm


20191008

Is Samsung an American company or a Chinese company?

Samsung is a Korean company.

It's mobiles are widely used in India, France and lots and lots of countries.

Xiaomi has reached 1st level in India followed by Samsung otherwise Samsung is at top rank in almost all other countries.

This is a South Korean company. (Not North Korean ie not in Kim Jongs country)

It's headquarters are at Seoul city in South Korea.

It's employee strength is 3 Lacs + as in 2019.

It serves worldwide.

Weblink of the company is - samsung.com

It's Net income is 37 billion dollars as in 2017
This means

Rs. 26,28,29,50,00,000 = 2.62 lac crores which is approximately 3 lac crores!!

And defence budget of India is 3.59 lac crores as in 2017.

So net income (not revenue, just income) of Samsung is as good as defense budget of India!!)

And defence budget of USA is 686 billion dollars =
Rs. 4,87,45,44,50,00,000 = 48 lac crores = 12 times higher than India or Samsung net income!!

Source
1) Wikipedia - Samsung
2) Wikipedia - Military budget

20191007

Why are Array formulas used?

Array formulas cannot be typed

The shortcut key to apply array formula to a selected cell or column of selected cell is

SHIFT + CTRL + ENTER

After pressing this key, braces followed by = sign appears, which is not possible on typing.

Array formula is used when you want sum of product of 2 columns in a single cell

Eg {=B2:B51*C2:C51}

However this formula makes sheet slower.

So not recommendable.

Instead add 1 more column for product and simply do B2*C2, B3*C3 etc

If needed, you can hide this column and get final value in one cell by using = formula or simply 'copy paste values'

20191003

The 3 Rins (debts) and methods to remove those rins

Source - Srimadbhagvat 6.5.36

A person has 3 debts or Rins

1) Rishi Rin
     Debt to Rishis or Divine saints
     Paid by - Celibacy or Brahmcharya

2) Dev Rin
     Debt to heavenly gods
     Paid by - Doing sacrifices or Yagyas
    

3) Pitru Rin
     Debt to forefathers (those in Pitru Lok)
     Paid by - Producing Children

A person in order to neutralise or pay all 3 debts needs to practice Celibacy, needs to do Yagyas and needs to marry and get children

20191002

Are data scientists in demand?

SHOULD I APPLY FOR DATA SCIENTISTS JOB?

Fueled by big data and AI, 

demand for data science skills is growing exponentially, according to job sites.

The supply of skilled applicants, however, is growing at a slower pace.

It's a great time to be a data scientist entering the job market. ...

"More employers than ever are looking to hire data scientists."Jan 31, 2019

Reference

Link

https://www.google.com/url?sa=t&source=web&rct=j&url=https://searchbusinessanalytics.techtarget.com/feature/Demand-for-data-scientists-is-booming-and-will-increase&ved=2ahUKEwiM8a-0xP3kAhUv6nMBHURMCEwQFjADegQIARAW&usg=AOvVaw3jlXnTHuKytDaxs_a2gTzH