webnovel

How to make dynamic attendance table formula template

2026-11-22 03:44
2026-11-22 06:13

The following is a method to create a dynamic attendance table formula template: ** 1. Set up the basic framework ** 1. ** Setting the format ** - Choose all the sheets (you can press Control + A), set the font to MicrosoftElegant Black, and set the font size to 9. At the same time, set the vertical and horizontal centers. - Right-click the row number and set the row height to 20, and right-click the column number and set the column width to 4. 2. ** Dynamic Attendance Month Setting ** - Enter the attendance month in cell A2 and align it to the left. Enter the year in cell C2 (such as 2023), combine C2 and D2 cells in the middle, enter the year in cell F2, enter the month number in cell G2, and enter the month in cell I2. - He clicked on the development tool and inserted the value adjustment button. Draw the year value adjustment button in cell E2, right-click to set the control format, set the current value (such as 2023), the minimum value (such as 2000), the maximum value (such as 2099), the step size to 1, and select cell C2 from the cell link. Similarly, insert the month value adjustment button in cell H2, set the current value (10 for October), the minimum value as 1, the maximum value as 12, and the step size as 1. The cell link selected cell G2. 3. ** Dynamic Title Setting ** - The first row was selected, and the row height was set to 35. Enter A1: AL1 in the name box in the upper left corner, click to merge the cells and align them to the left. - Set the title with ""(the hypher), such as entering the company name in the cell, selecting the cell where the year is located (C2 cell),"Year", the cell where the month is located (G2 cell), and "Month Attendance Form". Then set the font size to 12, bold, and fill in the color. Note that when you enter the text content, wrap it in double quote marks in English so that the title can change when the year or month is adjusted. 4. ** Setting Slash Heading ** - Choose the area between A3 and B4, merge the cells, click insert, select the straight line in the shape, insert a straight line from the upper left corner down, and then insert a straight line from the upper left corner to the right. Choose two straight lines and set the color to black in the shape format. - He clicked on the insert horizontal text box, entered the date in the text box, right-clicked on the circle next to the text box, and chose to set the size and properties. He set the screenwriter to 0 cm, changed the shape fill to no fill, the shape outline to no outline, and set the font size to 9. He adjusted the text box to the appropriate position. Make a copy of the two date text boxes, change them to the week and name respectively, and adjust their positions. ** 2. Set the date and week ** 1. ** Date Setting ** - Enter the date function in cell C3, such as "= END (C2,G2,1)"(where C2 is the year cell, G2 is the month cell, and the third argument 1 means that the month starts on the 1st). Press F4 for C2 and G2 cells for absolute reference, and press Enter to get the first day of the month. 2. ** Setting of week ** - In cell C4, enter the formula "=IF(C3 = "", "", Date(Year(TODAY()),$AD$2,C$3)"(Assuming $AD$2 is the cell of the month), and then scroll to the left of the note. Check cells C4 to AG4 and set the cell format to the week format in the Date format. ** 3. Attendance status settings (such as attendance, rest, leave, absence, etc.)** According to the company's needs, set the relevant attendance status indicator. For example, you can directly enter "tick" or "×". Enter "tick" or "×" to select "Symbol" by clicking "insert" in the menu bar. In the "Symbol" window that popped up, select- -Wingdings2 after "font", and then find the corresponding symbol and click "insert". You can also use the condition format to mark data information such as absence. You can click on the condition format tab and use the "Highlighting Cell Rule" to mark absence data. Read more exciting novels for free

Latest Questions

The dance class principal sent a short and domineering sentence in English

Dance is an art that refines the body and soul. In this dance class, strive for excellence, for mediocrity has no place here. Or In the realm of dance, every step counts. In our dance class, be fearless, be passionate, and create your own legend. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-22 03:51

Impression of Xiangshan

"The impression of a mountain" might have different meanings. In Gangu, the sales manager of Xiangshan Impression introduced Gangu chili. Xiangshan Impression had a 1200-mu chili planting base, which was sold online and offline. There were also Gangu specialty shops and Gangu chili specialty stores. Gangu County Xiangshan Impression E-Commerce Co., Ltd. was established in Tianshui City, Gansu Province in 2020. It mainly engaged in Internet sales, production and sales of agricultural products and other related services. It adopted the service mode of "online digital supply chain platform + offline digital food distribution and transportation network" to help food ingredients from the production base to the common people's dining table. It has been filed with the Commerce Bureau of Gangu County through the "Gansu Prepaid Code" platform according to law, and can carry out card issuing business. Customers can recharge their cards on its platform, which brings new opportunities for the promotion of Gangu's specialty agricultural products. In addition, there was also a building called "Xiangshan Impression"(alias: Meitan Xiangshan Impression) for sale. It was an ordinary residential and commercial type, with a reference average price of 4780 yuan/square meter. While waiting for the TV series, he could also read the exciting content related to this site!

1 answer
2026-11-22 03:51

Is it normal for a 10-month-old baby to lose weight instead of gaining weight?

It was not normal for a 10-month-old baby to lose weight instead of gaining weight. Usually, a 10-month-old baby's weight increases by about 60 - 90 grams per week. A boy's weight this month is 8.6 - 10.6 kilograms, and a girl's weight also has a corresponding normal range. The baby's weight may not increase but decrease because of the problem of complementary food addition, because the principle of complementary food addition should ensure the amount of milk. Even if the baby is 6 - 12 months old, milk is still the main food. It is recommended to ensure 700ml of milk for 9 - 12 months. If the amount of milk is insufficient or the complementary food is not properly added, it may affect the baby's weight gain. Of course, there may also be other health factors. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-22 03:51

Super loser hero novel free to read without pop-up window

The following are some of the works involving super-loser heroes: In the story of Marvel, there was a super loser hero. He was from the X-Men, named Billy. His personal manga was called "The Worst X-Men in History." His superpower was self-destruction, which often caused him to suffer great danger or even lose his life in battle. There were also some characters in the works who had the characteristics of losers and then counterattacked. For example, the male protagonist Lu Zuo in the anime " The Past of the Golden Silkworm " was originally an ordinary worker. After his grandmother planted the King of Insects, the Golden Silkworm, his fate changed. He gradually grew from an unarmed loser to a leader who lived up to expectations. In addition, Ivan, a contemporary youth in Moscow in The Last Warrior, was originally engaged in an ancient business. He pretended to know magic to swindle money. He was a person with a poor side. After mistakenly entering the fairytale kingdom, he began a magical journey and became a warrior. There were similar characters in some time-traveling novels. For example, in a certain ancient novel, the main character Lin Jiuyou was at a disadvantage in the immortal cultivation world at the beginning after transmigrating. He was considered a good-for-nothing, different from other crazy transmigrators. At the beginning, his family was destroyed and he was even beaten and scolded by others. However, he also began to work hard to survive and develop in this world. Although these works were not all novels, they had similar character setting ideas and could be used as a reference for super-useless hero works. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-22 03:51

How to make a complete collection of novel cover paintings and pictures

Here are some ways to make a picture for the cover of a novel: 1. ** Self-created painting **: Just like Nilda Neves created the cover of her novel O Lavrador do Sertço, if you have the ability to draw, you can draw according to the content of the novel. The content of the painting could be scenes, characters, etc. related to the plot of the novel, and inspiration could be obtained from one's own memories or understanding of the novel. 2. ** Illustration Creation **: - He could refer to the style of the Chinese illustrator, Morncolour. When creating, a single piece of work can be unified with a color scheme. The color scheme should be mainly warm colors. Pay attention to the light and shadow to focus the line of sight. The characters occupy the lower half. - If he was working with a book company, he could create cover illustrations. After that, he could work with other designers to complete the binding design and typography. 3. ** Synthesis Production **: - Using tools (such as mobile or computer version editing, love editing, fast film, etc.) to synthesize. - Materials: A base map (any nice background), a picture-in-picture material (the background should be a solid color, and the contents of the map should be people, items, special effects, etc.), and a highlight map (such as the sun, stars, etc., with the back of the map being all black or all white). - Computer version of the steps: - He imported the material, set the size of the bottom map in the guide rail (usually 3:4), then put the picture-in-picture on the base map on the guide rail, and then cut out the picture-in-picture (you can choose to cut out the color map, smart cut out, etc.). The main content of the picture-in-picture was cut out and placed in the appropriate position of the background. - He started to process the words. He clicked on the text in the upper left corner and adjusted the position, color, bubbles, and flower words in the upper right corner. - For highlight processing, he chose to brighten the blend in the top right corner of the basic column, and chose 100% Opacity. Then, he placed the highlight image in a good position. The operation of the mobile version was similar to the computer version. - As for the text, if the VIP font was not trendy enough, one could search for the "Online Generation Art font" website to generate flower characters. The generated white background image was very easy to misprint. After removing the white part, one could change the color to use it. In addition, he could also create fake makeup for the cover of a novel, but this was more about presenting the image of the character on the cover of the novel from the aspect of character makeup, rather than directly creating a painting. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-22 03:50

The previous kings of the Sörenhohen family

There were many famous monarchs in the Hohensauron family: 1. Frederick I (1657 - 1713), the founding king of the Hohenthal dynasty in Germany (1701 - 1713). He was originally the Duke of Pronia of the Hapsberg dynasty in Holy Rome and the head of the Hohenthal family. Due to his outstanding performance in the war against France in Holy Rome, he was awarded the title of king by Holy Rome in 1701 and ascended the throne. He established the Kingdom of Pronia and established the Hohenthal dynasty. He died of illness in 1713. 2. Frederick William I (1688 - 1740), the second king of the Hohensolen dynasty of Germany (1713 - 1740), the second son of the founding king Frederick I and the second queen Sophie, inherited the throne after his father died in 1713. During his reign, he focused on developing military power, and most of the country's financial revenue was used for military purposes. Later generations considered him the founder of militarism, and he died of illness in 1740. 3. Frederick II (1712 - 1786), the third king of the Hohensolen dynasty in Germany (1740 - 1786), the third son of Frederick William I, was appointed crown prince due to the early death of his eldest and second brothers. During his reign, he was outstanding in both civil and military affairs, expanding the territory of the Kingdom of Pronia. He was also a musician and philosopher, with many works handed down from generation to generation. He was called Frederick the Great by later generations and died of illness in 1786. 4. William I was the king of Princes. He became the emperor of the German Empire in 1871. He played an important role in the Hohensoren family's rule over Germany. He laid the foundation for the great cause of the Hohensoren Dynasty and had a dominant influence on German affairs. 5. William II was the emperor of the German Empire. During the First World War, his rule faced many challenges, such as the pressure to reform the domestic constitution. He resisted the reform proposal, and finally, with the defeat of Germany in the First World War, the Hohensolhn family's rule over Germany ended in 1918. In addition, in terms of the rule of Romania, Karl, a descendant of the Hohensolen family, was elected as the archduke of Romania in 1866 and became king in 1881, known as Carol I. After his death in 1914, his nephew Ferdinand and his descendants ruled Romania until the establishment of the Romania people's Republic in 1947. Hurry up and click on the link below to return to the super classic "Lord of Mysteries"!

1 answer
2026-11-22 03:49

The position of the bond breaking in the substitution reaction of the substituted alcohol

In the substitution reaction of the substituted carbon dioxide, such as the decomposition reaction of the carbon dioxide, the bond between the carbon dioxide and the carbon dioxide was broken. In general, during the dehydration reaction of the halalocarbon, the carbon-halo bond (C-X) connected to the halo atom was broken. The hydrogen bond formed by the carbon atom and the hydrogen bond formed by the hydrogen bond in the water. At the same time, it was important to note that the substitution reaction or elimination reaction of the substituted alcohol under the basic conditions mainly depended on the reaction conditions. It could be remembered as "no alcohol becomes alcohol, alcohol becomes ene." <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-22 03:49

I'm looking for a few good ending fantasy novels.

The following are some completed fantasy novels: In this story, the invasion of the Abyss caused the entire Yuan Xing to enter an era of awakening. The Awakened could enter the Abyss to obtain power, but they also faced many dangers. There was also " Covering the Sky ". The plot revolved around the experiences of the main characters in a grand fantasy world. " Global Martial Arts " was also a completed fantasy novel. It included characters such as Wang Jinyang, and the story had a unique plot development. <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-22 03:49

His little warmth, the full text, free to read the full text

Bookstore organized and provided the complete version of " His Little Warmth " for free reading. 919 romance novels also provided the full text of " His Little Warmth " for free reading online. While waiting for the TV series, he could also read the exciting content related to this site!

1 answer
2026-11-22 03:49

What gives off the light of pale flame

What emits a pale white flame? <a href="/?from=ask_words" style="color:red" target="_blank">Read more exciting novels for free</a>

1 answer
2026-11-22 03:48
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