webnovel

How to make the seniority salary form

2026-01-13 13:16
2026-01-13 15:47

1. Confirm the components of the salary schedule: - Payroll (the main table that presents the final salary data). - The employee information sheet contained basic information such as seniority, basic salary, social security level, and so on. This was the basis for calculating seniority salary and other data. - Table of five insurances and one fund base and ratio (If the base of contribution is not the salary that should be paid, it needs to be provided separately). - The monthly attendance summary table contains the attendance data such as the number of working days and the number of days of leave. It is used to calculate the attendance salary. - Performance commission table (providing employee performance data and commission ratio data). - Reward table (including the employee's monthly bonus and other data). 2. Calculating seniority: - You can use the Datedif function to calculate the difference between two dates (the start date and the current date). For example, in Excel, if cell B14 was the time of employment and cell C14 was the data of the length of service, the calculation formula of the length of service would be "=Datedif(B14, TODY (),"Y")". If you want to add the unit "year", you can modify the formula to "=Datedif(B14, TODY (),"Y")&" year ". However, it may not be convenient to participate in the salary calculation after adding the unit. After calculating the first length of service, he dragged the lower right corner of the cell down to fill in the other length of service data. It could also be calculated according to the company's special requirements for the calculation of the length of service, such as being accurate to 2 decimals (first calculate the difference in months, then divide by 12, and round it by embedding the Round function). 3. Confirm the calculation rules of seniority salary: - Different companies had different calculation rules. For example, if the number of years of employment was less than 2 years, the seniority allowance would be 100 yuan; if the number of years of employment was 2 - 5 years (including 5 years), the seniority allowance = the number of years of employment *100; if the number of years of employment was more than 5 years, the seniority allowance would be capped at 500 yuan. According to this rule, you can use a function to calculate. For example, in Excel, enter the formula "= IFDOWN (Datedif(D2,$G$2,"Y"),0)" in cell E2 to calculate the number of years of employment. Then enter the formula "=IFS(E2 <= 1,100,AND(1 < E2,E2 <= 5),E2*100,E2>5,500)" in cell F to calculate the seniority salary. Then, pull down to complete the calculation. - There was also a calculation method of seniority salary = initial salary +(seniority multiplied by seniority salary increment). For example, in Excel, if cell D14 was the initial salary, cell C14 was the seniority, and 100 was the seniority salary increment, the seniority salary calculation formula was "=D14+(C14*100)". After calculating the first data, drag down the point in the lower right corner of the current salary data cell to fill in other data. 4. To quote seniority salary data in the salary table: - If both the salary sheet and the seniority salary sheet were entered (or pasted) according to the attendance summary sheet, and the names and numbers were the same and the order was the same, the data could be directly referred to with an equal sign. For example, in the "Payroll" sheet, the input formula for cell C5 = seniority salary! C2, D5 cells input formula = seniority salary! F2, select C5:D5 to fill in the basic salary and seniority salary reference. If the "Seniority Wage Table" is not created based on the attendance table summary, and the number of people and the sorting of names are different from the attendance summary table, you need to use functions such as VLOOkUP to reference the data. The novel "Ten Years of Death" is equally exciting. Everyone is welcome to click and read it!

Latest Questions

A novel about the crown prince consort and the servant girl fighting

I recommend 'Top-grade Crown Princess,' an ancient romance novel written by Yuan Bupo. The female lead, a mountain bandit, was the crown prince's consort. In the palace, she didn't spoil those who were looking for trouble. She could fight whenever she wanted. It was extremely domineering. " No House, No Fight " was not bad either. The author would fight if he had a house. The female protagonist became a concubine after a nap and started fighting in the palace and even the world. She played everything with her workplace experience. " Di Fei " was written by the dancing clothes and singing fans. Murong Rong turned from a peasant girl into a Di daughter, step by step, she became the emperor's favorite concubine, and in the depths of the palace, she became a cloud with a flip of her hand. In " The Concubine is Mighty ", the modern female bodyguard Nan Yi returned to the side room of Qing Cheng and became friends with the princes. She was unwilling to be trapped in the back house and wanted to wander the Jianghu. There was also 'The Fourth Master's Palace Battles', a Qingchuan Palace Battles', written by Blue Lotus Gentleman. The female protagonist was reborn in the thirty-first year of Kangxi and fought with all kinds of reborn women in the backyard of Lord Fourth. The setting was novel, but the author had many problems with theft and updates. However, it was an interesting novel. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-06-17 05:25

What happens when Caine visits Grace's ex's territory?

In Chapter 199, Caine arrives at the ex's territory and is met with disrespect—the ex doesn't come to the door. Caine turns to Reggie, his dark mood worsening. This visit settles old scores regarding Grace's treatment.

1 answer
2026-06-17 05:25

Immortal Cultivation: Jiang Hua

In The Story of Immortal Cultivation, Jiang Hua finally achieved his goal. In the process of cultivating, he had experienced many hardships and trials, but he had always persisted in cultivating, constantly improving his cultivation and cultivation realm, and overcoming the evil thoughts in his heart. His cultivation journey conveyed a positive message that success could be achieved as long as he persevered. This had certain enlightenment significance for people in real life to pursue their ideals. The novel " Sitting and Watching Immortals " is equally exciting. Everyone is welcome to click and read it!

1 answer
2026-06-17 05:25

What are the good names of the novels with the female protagonist called Chu Lian?

" Young Master Flirts His Special Ability Wife ", a novel written by Xianyi. The female protagonist, Chu Yaoyao, dressed up as an ancient lady after the apocalypse. She wanted to eat and wait for death, but at the age of fifteen, she had to marry a " traitor " who was rumored to be disabled. The male protagonist, Leng Tianyu, was only injured in his leg and was not a traitor. This was a super sweet love story. The female protagonist was powerful, and the male protagonist was super spoiled. There was no abuse or misunderstanding. Silver Phoenix was a fantasy romance novel created by Dream of Rain. The female protagonist, Yue Yan, was black-bellied, domineering and cold. The story had the grievances of aristocratic families and the struggle between Di and Shu. After the female protagonist was reborn, she was wise and dark, playing with the enemy in the palm of her hand. The male supporting character Yang Taiyi was scheming, the female supporting character Wu Ningsu was gentle, and there was also the sinister Yue Xiao. The writing style is superb, the picture is strong, and the woman is often a masterpiece. 'A Heavenly Match' was an ancient romance novel. The female protagonist, Yan Ning, was reborn. She was used and killed in her previous life. In this life, she was no longer muddle-headed and stopped Chu Zhaoye from becoming the emperor. The male supporting character Chu Zhaoye portrayed the rise of the prince in depth. He was vicious and unscrupulous, yet complex and attractive. Empress Chu was an ancient novel written by Xixing. The story began at the courier station. The female lead, Chu Zhao, had many supporting roles. Xixing's writing was good, and the plot had a reversal. Although the female lead was weak, she worked hard to improve herself. The background was huge. Although it was similar to the author's previous style, it was still exciting. " Beauties " was an ancient novel written by Ye Huimei. The female protagonist was originally a tough woman who was spoiled into a delicate girl. She originally wanted to fight at home, but she didn't have the chance. When choosing a son-in-law, the fiancé's conditions were very good. There was a very deceptive female supporting character. The role of the father was very special. It was a sweet pet novel. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-06-17 05:25

If I only want one chapter that proves why Yan Fangxu matters, should I jump to Chapter 41?

Chapter 41, ", Encircle the Point to Reinforce?", is the clearest early answer because it turns Yan Fangxu's situation into a concrete plot event. The chapter turns that into something concrete by moving from The appearance of the Pus Spewer posed a rather tricky problem for... to He didn't just stop firing himself, he also ordered his men to cease.... What makes it stick is that the chapter closes with "Don't worry, I have a plan.

1 answer
2026-06-17 05:24

Where does the story give Gu Hang a scene that actually changes momentum instead of just adding flavor?

Chapter 26, ", Long-term Planning", is the clearest early answer because it turns Gu Hang's situation into a concrete plot event. Early on, Nothing out of the ordinary happened on the way back to camp.. By the end, these were Gu Hang's sources for population intake..

1 answer
2026-06-17 05:24

One year is very short, but longing is very long.

Based on the phrase "one year is short, but missing is long", there was no specific explanation or related content in the reference materials. From a broader perspective, it could be used to express the long-lasting and profound feelings of longing within a limited period of time (one year). For example, the feelings of missing someone mentioned in Material 6 would deepen as time passed. Even if time was as limited as a year, the longing would never end. However, this was only a conjectural understanding based on the reference materials about missing emotions. The novel "Ten Years of Death" is equally exciting. Everyone is welcome to click and read it!

1 answer
2026-06-17 05:24

The author of the original novel, Yong Fengqing

The author of Yong Fengqing's original novel,"The Alluring City Is Still Pleasant"(aka "Who Dare to Touch the King's Woman") was Picking Flowers to Make Laughter. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-06-17 05:24

Excerpt from a complete collection of novel writing methods

Here are some ways to write a novel: * * 1. Writing Techniques ** 1. * * First Person Writing ** - Strengths: The narrative is realistic, easy to grasp the theme, easy to get the reader's sympathy, because it can only write about personal experiences, etc. - Disadvantages: If the description is inappropriate or excessive, it will make the reader disgusted. It is easy to regard yourself as a character and lose the objective description. You can only indirectly guess the inner activities of the character. 2. * * Omniscient perspective ** - [Strengths: The author can inform the reader of all the necessary information to facilitate the reader's understanding of the character. The author can describe the character's inner emotions and motives, and can pay attention to the development of multiple sets of events.] - Disadvantages: The readers may have different interests in some parts of the novel, and the novel is easy to appear sloppy and complicated. It is limited by the author's cognitive limitations and lacks persuasiveness. 3. * * The improvement of omniscient writing method ** - [Strengths: The author is still omniscient and omnipotent, but he focuses on one person. He tells the story through what this person sees and hears to show the character of others. The structure is compact and realistic.] - Weakness: Revealing the truth bit by bit may allow the reader to guess the ending in advance. * * 2. Writing using AI (if AI is used)** 1. The prompt had to be specific, including the character's actions, thoughts, reactions, and other details. 2. Clearly inform the AI of the writing style it wants, such as long conversations or psychological descriptions. 3. Understand the AI's work thinking, use accurate words, and different words will have different effects. 4. Choose different AI tools according to your needs, such as the solution card text and plot details generation class, and the expansion inspiration option continuation class. * * 3. Story construction ** 1. Be honest with yourself and express your true thoughts. 2. Ask more "and then" to push the story forward. 3. He kept writing down what he knew. Handwriting helped him think. 4. Courage to write a complete story and find the connection to give meaning. 5. Face the conflict head-on and write about the unexpected consequences. 6. It was to clarify the demands and goals of the characters to promote the development of the story. The characters often only got what they needed and not what they wanted. The story was formed by the collision of the needs of the characters. 7. He used concise language to describe the story. 8. He would first practice writing short stories and hone his storytelling skills. 9. Writing had to have a lead that foreshadowed major events and had layers. 10. Reading helps writing. Read more. 11. Create a real, three-dimensional character and figure out how the character speaks. The dialogue should show the character, the plot, and promote the development of the story. You can write the dialogue by compressing and refining, showing the character, listening to the character's thoughts, and so on. 12. There were two ways to introduce a character: static and dynamic. 13. The common types of stories were the poor becoming rich, boys chasing girls, and a person's growth. 14. To construct a world, one had to first have a world before stuffing people in, allowing the character to discover the rules. 15. When describing, add details with memory points. You can use sensory descriptions to stimulate emotions. 16. He could be humorous in his writing, change the order of words to surprise the readers, and change the old-fashioned story. * * 4. Writing planning ** 1. He summarized the content of the novel and the protagonist's mission in one sentence. 2. It summarized the three-act structure of the novel, the reversal and ending, and the moral premise. 3. Make a one-page introduction for the main characters. 4. He expanded the five sentences into a one-page outline. 5. Writing background stories for characters to form character outlines. 6. He expanded the one-page outline into a four-page outline to add details. 7. He expanded the character outline and studied the characters in depth to form a character book. 8. He used a spread sheet to list the novel's scenes to form a scene list. * * 5. Other Techniques ** 1. Just show, don't explain. 2. Using drama techniques. 3. Write plot notes and talk to your heart before writing. 4. When the story drags on, add characters or create surprises, such as letting unexpected characters enter the scene, receiving unexpected messages, etc. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-06-17 05:23

The Old Couple's Sad Life in Their Later Years

" Husband and Wife Reborn 1977 Before Marriage " was a modern romance novel written by Baby Xuan Mo. An old couple in the countryside was reborn. The old grandma wanted to reform her husband, and the old grandpa wanted to dote on his wife and children. " Muye: Becoming a God from the Oil Girl ", a light novel created by a rotten fan. The protagonist transmigrated into the Oil Girl race and relied on the Primordial Gu to counterattack. Every Ninja Village had powerful things. " The Happy Life in the 80s " was a modern romance novel written by Snail. Qin Mutong traveled to the 80s. She had no parents but her grandmother. She also had an unacknowledged fiancé who wanted her to take him home. "The Bewitching Wife" was an ancient romance novel written by Dusk and Cold. Dong Xiyun was reborn as a housewife. She wanted to take revenge and take care of her son so that her ex-husband would regret it. " Your sanity value has dropped to zero." It was a suspense novel written by Fang Yufei. The male protagonist, Du Wei, traveled through another world. There were many interesting characters, and the style of writing was funny and imaginative. It was worth reading. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-06-17 05:23
a
b
c
d
e
f
g
h
i
j
k
l
m
n
o
p
q
r
s
t
u
v
w
x
y
z