Spreadsheet: 677438d1589360606-vlookup-to-automate-discharge-slips-vlookup-on-sheet-2
Sheet: MASTER DATA

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DDMO I/C
Sl. No. | Date of Arrival | Name of Person | Phone Number | Age | Gender | Occupation | ID CARD |  | Name of Father/Guardian | COMING FROM |  | GOING TO |  | Domicile District | Place Visited in Last Three Weeks With Date |  | Medical |  |  |  |  |  |  |  |  | Based on the recommendation of the Screening Team, IC hereby direct them to |  | NAME OF THE INCIDENT COMMANDER | PTC - ADMISSION DETAILS |  | SHIFTING DETAILS |  |  | NO. OF DAYS QUARANTINED AT PTC BANDERDEWA | DATE OF ADMISSION AT PAID QUARANTINE | DATE OF DISCHARGE FROM PAID QUARANTINE | NO. OF DAYS QUARANTINED AT PAID QUARANTINE | TOTAL NO. OF FACILITY QUARANTINE DAYS | RECOMMENDED DATE OF DISCHARGE FROM FQ/HQ AS PER SOP | Remarks if any;
 |  |  |  |  |  | (Student/Employee/Business/Farmer/self-Employed/Others | TYPE -   (ADHAAR/PAN/DL/STUDENT ID/EPIC/OTHERS | NO. |  | DISTRICT | STATE | DISTRICT | VILL/TOWN (Address) |  | PLACE | DATE | Temp | Unit   (°C or °F) | Cough    Yes/No (if Yes, Since how many Days | [NAME]    Yes/No (if Yes, Since how many Days | Dificulty in Breathing    Yes/No (if Yes, Since how many Days | Symptomatic/Asymptomatic | Doctor's Recommendation at Gate  1 - Shifted to CCC 2 - Shifted to DCHC 3 - Continue FQ | SWAB COLLECTION DATE | RT-PCR TEST RESULTS (POSITIVE/NEGATIVE/PENDING) | DISTRICT | PLACE/AREA |  | BLOCK ADMITTED (M-I,II,III/F-I,II,III/FR/D-COY/CCC) | BED NO. | SHIFT DATE  Date of Release FROM PTC FQ | PAID QUARANTINE/HOME QUARANTINE/DCCC/DCHC (PQ/HQ/DCCC/TRIHMS) | PAID QUARANTINE LOCATION DETAIL
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41
1 | 2020-04-25 00:00:00 | RITIKA SARK |  | 22 | F | EMPLOYEE | AADHAR |  | ITEN SARK | Dibrugarh | Assam | PAPUM PARE | NERIST, NIRJULI |  |  |  | 97 | °F | NO |  | NO | ASYMPTOMATIC | 3 |  |  | PAPUM PARE |  | BITTU KRI |  |  | 2020-04-30 00:00:00 |  |  |  | 2020-04-30 00:00:00 | 2020-05-15 00:00:00
2 | 2020-04-25 00:00:00 | ADAR YAKA |  | 20 | F | STUDENT | AADHAR |  | ADAR NAN | East Khasi Hills | Meghalaya | PAPUM PARE | NAHARLAGUN, A-SECTOR |  |  |  | 96.7 |  | NO |  | NO | ASYMPTOMATIC | 3 |  |  | PAPUM PARE |  | BITTU KRI
3 | 2020-04-25 00:00:00 | DARA AMA |  | 19 | M | STUDENT | AADHAR |  | DARA TAP | Ri Bhoi | Meghalaya | KURUNG KUMEY | VILLAGE, LANGTH LOTH |  |  |  | 97.6 |  | NO |  | NO | ASYMPTOMATIC | 3 |  |  | KURUNG KUMEY |  | BITTU KRI |  |  | 2020-05-20 00:00:00 |  |  |  | 2020-05-20 00:00:00 | 2020-05-23 00:00:00
4 | 2020-04-26 00:00:00 | [NAME] |  | 40 | F | EMPLOYEE | AADHAR |  | LT. [NAME] | Lakhimpur | Assam | LOWER SUBANSIRI | HAPOLI |  |  |  | 37.6 |  | NO |  | NO | ASYMPTOMATIC | 3 |  |  | LOWER SUBANSIRI |  | NEELAM TEJI
5 | 2020-04-26 00:00:00 | RAJA SITA |  | 20 | F | STUDENT | AADHAR |  | ABC TEN | Lakhimpur | Assam | LOWER SUBANSIRI | HAPOLI |  |  |  | 38.9 |  | NO |  | NO | ASYMPTOMATIC | 3 |  |  | LOWER SUBANSIRI |  | NEELAM TEJI |  |  | 2020-04-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | °C
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | °C