If you are looking for software to use, go to Huajun Software Park! software release AI product list

Hello, if there is a need for software inclusion, please package the software and attach the software name, software introduction, software-related screenshots, software icon, soft copy, business license (if you do not have a business license, please provide the front and back of the corresponding developer ID card and a photo of yourself holding the ID card), and send it to email http://softwaredownload4.com/sbdm/user/login

Close >>

Send to email:news@onlinedown.net

Close >>

Location: Home pageTable sampleform templatePersonnel table Accommodation registration form
Accommodation registration form

Accommodation Registration Form Free Version

QR code
  • Software licensing: shareware
  • Software size: 0.01MB
  • Software rating:
  • Software type: Domestic software
  • Update time: 2024-10-31
  • Application platform: WinAll
  • Software language: Simplified Chinese
  • Edition: Free version

Download the service agreement at the bottom of the page

Software introduction Related topics FAQ Download address

Basic introduction
Logo at the beginning of the accommodation registration form
Accommodation registration formFor hotels, guest houses, restaurants, schools, institutions and other Chinese institutions, you need to present a valid passport or residence permit and fill out a temporary accommodation registration form. The free download of the accommodation registration form is provided by Huajun Software Park. The source file is in xlsx format. You can edit and modify the content style by downloading the source file. For more information about the free download of the accommodation registration form, please pay attention to Huajun Software Park.

Screenshot of accommodation registration form

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.

FAQ

Accommodation registration form

Accommodation Registration Form Free Version

close