Introduction to the accommodation registration form Accommodation registration formprocessBesides
1. Foreigners live in Chinese hotels, guest houses, restaurants, schools, institutions, and other Chinese institutions. They need to show valid passports or residence permits, and fill in the temporary accommodation registration form.
2. Foreigners live in the Chinese residents' homes in the town. Within 24 hours after arrival, the passports, certificates and hostels of the host or the lodgee must be declared in the local public security organs to fill in the temporary accommodation registration form.
3. Foreigners stay in Chinese foreign institutions or in the home of foreigners in China, and must be the local public security organ that must Apply and fill in the temporary accommodation registration form.
4. For temporary accommodation in the mobility accommodation tool, foreigners must declare to the local public security organs within 24 hours.
5. Foreigners who have rested in China for a long time leave their residence and temporarily stay in other places, and also apply for accommodation registration.
Accommodation registration form universal skills
1: Multi -conditioning summary
The total subsidy of the statistical department for production and position is mainly based on posts.
The formula is:
= Sumifs (D2: D9, B2: B9, F2, C2: C9, G2)
2: Condition count
Statistically count the number of business pens of specified stores. That is, how many designated shop names are there in column B.
= Countif (B2: B12, E3)
3: Multi -condition search
The query department is required to be produced and the name is the minister.
The formula is:
= Lookup (1,0/((b2: b9 = f2)*(C2: C9 = G2)), A2: A9)
The LOOKUP function multi -condition query writing is:
= LOOOKUP (1,0/(((Condition area 1 = condition 1)*(condition area 2 = condition 2), query area)
4: Calculating text calculation
To calculate the text format in the cell, first click the first cell to enter the formula to define the name:
Calculation = Evaluate (C2)
Then enter the formula in the cell:
= Calculate
Xiaobian recommended by Huajun Software Park
Accommodation registration formFor free Excel templates, download it if you need it! Huajun Software Park provides a boutique Excel template download.Construction enterprise supplementary indicator table,New production capacity major statistical indicator annual reportDownload you can get the source file for you to edit and modify and replace it. Download the accommodation registration form to the Huajun Software Park.
it works
it works
it works