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

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, and 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 your ID card) and send it to your email address http://softwaredownload4.com/sbdm/user/login

Close >>

Send to email:news@onlinedown.net

Close >>

Location: front pageTable sampleform templateTeaching form company roster
company roster

Company Roster 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
  • Version: Free version

Software introduction Related topics FAQ Other versions Download address

Basic introduction
Company roster section first LOGO
company rosterIt is a written material produced by the employer to record the basic situation of the employees of the unit and the operation of labor relations. This is a set of company roster forms for download that have been carefully screened by Huajun Software Park. The template format is XLSX. After downloading the company roster Excel for free through Huajun Software Park, you can change the content and style of the template by yourself!

Screenshot of company roster

Tips for using company roster

​​​company rosterPreparation of:

​​​​First, the basic information of the worker, including the worker’s name, gender, citizen ID number, household registration address and current address;
The second is the form of employment, including full-time employment, part-time employment, labor dispatch, etc.;
The third is the starting time of labor, that is, the time when workers actually provide labor.
The fourth is the term of the labor contract, including fixed term, no fixed term or a term based on the completion of certain work tasks.

General Tips for Company Rosters

​ ​ 1: How to sum text
In some relatively non-standard tables, there will be a problem of mixing text and numbers, which makes summation difficult.
​​ Enter the formula in cell C12: =SUM(--SUBSTITUTE(C2:C11,"元",""))
              Press the key combination to complete.
​ ​ 2: Sum of multiple worksheets
For example, some tables have performance statistics for several months, and Zhang Cheng’s position in each worksheet is the same. Find Zhang Cheng’s commission statistics from a certain month to a certain month.
​ ​ Enter the formula in cell F5: =SUM('January:April'!C2), and press Enter to complete the filling.
Note: The above reference is supported in Excel, but it seems not supported in WPS. And please note that the structure or fixed position of the numbers in each table is the same before you can use this formula.
​ ​ 3: Multi-region joint calculation
In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.
For example, there is a table that calculates the totals from January to February, March and May to June.
​​Enter the formula in cell H2, press the Enter key to complete and fill downwards.
=SUM(B2:C2,E2,G2)

Recommended by the editor of Huajun Software Park

The company roster is a very practical form, and most of the forms are for general purposes. If you happen to need to download the company roster Excel form, download it quickly.Retirement Approval Form,Training statistics tableIt is also a good form. Welcome to click to download and experience it!

FAQ

Associated version

company roster

Company Roster Free Edition

closure