Make Payroll on Linux

Under Linux desktop, the spreadsheet module, which uses Office suites, makes it easy to make a variety of commonly used tables and to compute or insert charts. The following is an example of a payroll table that explains how to use a RedOffice spreadsheet to make a table under Linux. The payroll process covers the basic functions and applications of spreadsheets, such as data entry (which can be automatically populated using spreadsheet data); The settings for cell operations (INSERT, delete, and merge cells) and formatting (font, size, color, background, border, and so on), insert, copy, delete, hide, and display rows and columns, Table Formatting (border lines, backgrounds, etc.), calculations by using a spreadsheet's function or formula, inserting a chart, and so on. By making payroll, you can quickly familiarize yourself with the application of spreadsheets in Linux. The following is divided into three steps to make a payroll statement.

Set up a payroll table

1. New RedOffice Spreadsheet file

Create a new RedOffice spreadsheet file, and then enter tabular data. The details of the table are as follows.

(1) Merging cells

Select the area a1:o1, then select the menu format → merge cells → definition, and in the merged cell, enter the title salary scale (unit: yuan).

(2) In the second row area, enter the payroll item in turn

In the second row of the (A2:o2) area, enter the payroll item in turn: Month/year, serial number, name, basic salary, overtime pay, total salary, leave deduction, Housing Provident Fund, unemployment Insurance, endowment insurance, medical treatment, deduction total, tax pay, personal income tax, real wages.

(3) Input raw data

Enter all raw data that is not calculated: month/year, serial number, name, base salary, overtime pay, leave deduction. Enter a month/year, you can enter 10/2002 in cell A3, and then select cell A3, point to the lower-right corner of the black border of the A3 cell, and when the cursor changes to black "╋", hold down the CTRL key and drag the mouse down to copy the contents of the A3 cell. When you enter an ordinal, you can also automatically populate the implementation by dragging the mouse.

2. Calculation of other wage items

Use a RedOffice spreadsheet formula or function to calculate other payroll items.

(1) Total wages

The total wage project formula is:

Total Salary = base salary + overtime pay

Select F3 Cell, enter the "=" number, or click the Function button in the object bar, the table calculation bar appears above the window, enter the calculation formula "D3+e3", or enter a formula sum (D3:E3) with a function to calculate. Select the F3 cell to drag the mouse down to complete the calculation of the data for this project for other employees.

(2) Housing Provident Fund, unemployment Insurance, endowment insurance, medical calculation

"Housing Provident Fund", "Unemployment Insurance", "Endowment Insurance", "medical" project is based on "basic wage" calculation. Assuming that 4 kinds of payment ratio are 8%, 0.5%, 7%, 1.5%, housing provident Fund = Basic Salary *8%, unemployment insurance = basic salary *0.5%, endowment insurance = Basic salary *7%, medical treatment = base salary *1.5%. Select H3, I3, J3, K3 cells, enter =d3*8%, =d3*0.5%, =d3*7%, =d3*1.5%, respectively, and calculate the H3, I3, J3, K3 values. The following data is completed using the downward padding feature.

(3) Total deduction

The calculation formula for this project is:

Total Deduction = Leave deduction + Housing Provident Fund + unemployment Insurance + Endowment Insurance + medical care.

Select L3 cell, enter Formula =G3+H3+I3+J3+K3, calculate the first employee's deduction sum. The following data is completed using the downward padding feature.

(4) Tax pay

The calculation formula for this project is:

Tax pay = Total Wage-deduction total

Select the M3 cell and enter the formula =F3-L3 to calculate the tax pay for the first employee. The following is done with the downward padding feature.

(5) Calculation of personal income tax

"Personal income tax" is calculated on the basis of "tax pay".

Preliminary analysis shows that, in addition to the serial number of 20 employees, all employees tax deduction of 800 yuan after the 500 Yuan and 2000 yuan in the bounds of the interval, the first employee's "personal income tax" can be calculated as follows: IF ((m3-800) <2000; (m3-800) * 0.1-25 (m3-800) *0.15-125).

In the same way, the automatic computing function of the downward filling is used to calculate the personal income tax of the employees behind. The last employee can be calculated using the following formula:

(m22-800) *0.05

(6) Real wages

The calculation formula for this project is:

Real wages = Tax pay-personal income tax.

Select O3 Cell, enter formula = M3-n3, calculate the tax pay of the first employee. The following is done using the automatic calculation function of the downward padding.

(7) Total

For the "Total" item, you can use the formula =sum (D3:D22) to calculate. The total of the other items can be done using the automatic calculation of the right padding, that is, select the D23 cell, point to the lower right corner of the black border, and, when the cursor changes to black "╋", drag the left mouse button to the right to complete the "total" calculation of the other items.

(8) Set the worksheet format

Finally, set the worksheet style, including setting the alignment settings font, font size, font, background color, number format, and border properties, and so on, to complete the payroll as shown in Figure 1.

Figure 1 List of work