Accommodation registration form introduction Accommodation registration formprocess:
1. Foreigners staying in Chinese hotels, guest houses, restaurants, schools, institutions and other Chinese institutions need to present a valid passport or residence permit and fill out a temporary accommodation registration form.
2. Foreigners who live in the homes of Chinese residents in urban areas must report to the local public security bureau within 24 hours after arrival by the host or themselves with the host’s passport, ID and the host’s household register, and fill out a temporary accommodation registration form.
3. When a foreigner stays in a foreign institution in China or in a foreigner's home in China, within 24 hours after the host arrives, the host institution, the host, or himself must report to the local public security agency with the host's passport or residence permit, and fill in a temporary accommodation registration form.
4. Foreigners who wish to stay temporarily in mobile accommodation must report to the local public security agency within 24 hours.
5. Foreigners who have stayed in China for a long time must also declare their accommodation registration when they leave their residence and temporarily stay in other places.
General tips for accommodation registration forms
1: Sum of multiple conditions
It is necessary to count the total amount of subsidies provided by the department for production and the position is for the main operator.
The formula is:
=SUMIFS(D2:D9,B2:B9,F2,C2:C9,G2)
2: Conditional counting
It is necessary to count the number of business transactions of the designated store. That is, count how many specified store names there are in column B.
=COUNTIF(B2:B12,E3)
3: Multi-condition search
It is required to check that the department is production and the position is the name of the director.
The formula is:
=LOOKUP(1,0/((B2:B9=F2)*(C2:C9=G2)),A2:A9)
The writing method of multi-condition query of LOOKUP function is:
=LOOKUP(1,0/((condition area 1=condition 1)*(condition area 2=condition 2)),query area)
4: Calculate text equations
To calculate the text formula in the cell, first click on the first cell where you want to enter the formula and define the name:
Calculation = EVALUATE(C2)
Then enter the formula in the cell:
= Calculate
Recommended by the editor of Huajun Software Park
Accommodation registration formIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Supplementary indicator table for construction enterprises,Annual report on main statistical indicators of new production capacityDownload to get the source file, which you can edit, modify and replace. Download the accommodation registration form and go to Huajun Software Park.




















Useful
Useful
Useful