Pay social security for 6 months, how to do the payroll?

Make the payroll for the first six months and submit it to the tax bureau for review.

Payroll format: 1. Create an Excel file and store the original data of payroll in sheet 1, assuming there are n columns. The first line is the salary item, and from the second line is everyone's salary.

2. In sheet2, let's set the payroll. According to the actual situation, the payslip consists of three lines, one corresponding to salary items, one corresponding to salary data of one person, and then a blank line, which is convenient for cutting. These three lines make up a payroll. When the line number is divided by 3, the salary item is on the line with the remainder 1; A blank line is on a line whose line number is divisible by 3. The above two lines are not difficult to set. The key is the salary data line, which involves the corresponding relationship between the data in sheet 1 and sheet2. After analysis, it is not difficult to see that "data line in sheet 1 = int ((data line 4 in sheet 2)/3)".