Easy design of payroll with WPS form

Source: Internet
Author: User
Tags header

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))

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.