Easy design of payroll with WPS form

In the financial management of any enterprise, there must be salary calculation and design pay. The aesthetic and operating speed of the payroll head is a key point of the design. If you can master the technology can be less, otherwise will be limited by a large number of manual exercise, inefficient, and accuracy can not be guaranteed.

First of all, let us see what the characteristics of the pay bar, in order to prescribe the right remedy.

One: The wages of the head may be a line, but also may be two lines, according to the needs of different enterprise payroll. But the same thing is that each item (or the wage information of a worker) has a single head with a specified number of repetitions;

Two: There is a blank line in the middle of each entry to facilitate cropping.

According to the above characteristics, we can initially draw up a payroll Head Production program:

First: Set up a "payroll statement" to store employee payroll information, but also for normal editing and summary.

Second: The establishment of "wage-table", used to refer to wage information, while generating payroll form of wages.

The functions that need to be used can be different from one person to another, and many formulas can achieve the goal, but the final choice is the most efficient and easy to understand.

Now, through two examples to you to explain the process of wage-head design, analysis of the skills. Hope you can benefit from it, extrapolate, design a formula suitable for their respective needs.

The design of one-way payroll head

First look at the following data, this is a simple single line header payroll information excerpt (data randomly generated, not real wages, you can download the file to facilitate your study), see Figure 1.

Figure 1

Using this table data, you can use the function formula to refer to the data to generate the required wage bar form.

The steps and formulas are as follows:

1. Enter the "one-Line table header Payroll" worksheet.

2. Select cell B1.

3. Enter the following formula:

=choose (MOD (ROW (), 3) +1, "", Single-row table header Payroll Detail! A$1,offset (single sheet head salary detail!) A$1,row () ()/3+1))