Sunday, October 4, 2020

COVID-19 lockdown and unlock in India

Coronavirus disease 2019 (COVID-19) pandemic in India

The first Covid-19 confirm case on 30 Jan 2020 in the state of Kerala.
Government step for lockdown.
1. 22 Mar 2020 Public Curfew.
2. First lockdown for 21 days between 25 Mar 2020 to 14 Apr  2020.
3. Second lockdown for 19 days between 15 Apr 2020 to 3 May 2020.
4. Third lockdown for 14 days between 4 May 2020 to 17 May 2020.
5. Fourth lockdown for 14 days between 18 May 2020 to 31 May 2020.

Government step for unlock.

1.Unlock 1.0 for 30 days between 1 Jun 2020 to 30 Jun 2020.
2. Unlock 2.0 for 31 days between 1 Jul 2020 to 31 Jul 2020.
3. Unlock 3.0 for 31 days between 1 Aug 2020 to 31 Aug 2020.
4. Unlock 4.0 for 30 days between 1 Sep 2020 to 30 Sep 2020.
5. Unlock 5.0 for 31 days between 1 Oct 2020 to 31 Oct 2020.
6. Unlock 6.0 for 30 days between 1 Nov 2020 to 30 Nov 2020.
7. Unlock 7.0 for 31 days between 1 Dec 2020 to 31 Dec 2020.
8. Unlock 8.0 for 31 days between 1 Jan 2021 to 31 Jan 2021.

COVID-19 vaccine is scheduled for roll-out in the country on 16th January 2021.

1st vaccine- Covishield (AstraZeneca and Oxford University) Serum Institute of India
2nd vaccine- Covaxin (Bharat Biotech, Indian Council of Medical Research)

These two vaccine allow for emergency use approved by the drugs controller general of India.

The COVID-19 Vaccine Intelligence Network (Co-WIN) system, a digital platform will be used to track the enlisted beneficiaries for vaccination and COVID-19 vaccines on a real-time basis in India.



 

Sunday, March 22, 2020

Janta Curfew on 22nd Mar 2020 from 7am to 9pm.

Prime Minister of India announce the one day Junta Curfew on 22nd Mar 2020 from 7am to 9pm.

On 22nd March at 5pm come out on their balconies and terraces and show their gratitude towards people who are delivering essential services for 5 minutes.

World Health Organisation Whatsapp contact and link

World Health Organisation Whatsapp contact and link
  • Open WhatsApp on your phone.
  • Tap on this link and send join to WHO WhatsApp group to received update regarding COVID-19.
  • Alternatively, you can add +41 79 893 18 92 number to your contact, and chat with WHO Coronavirous pandemic.

Thursday, January 9, 2020

Reverse or Backward Vlookup in Microsoft Excel

Reverse or Backward Vlookup in Microsoft Excel


Following is the data format we have.

  • We will use VLOOKUP and CHOOSE function.
  • In cell F2 formula
  • =VLOOKUP(E2,CHOOSE({1,2},C2:C5,A2:A5),2,FALSE)

Data format