As the tea version said, when there was no clock, the ancients would use other timing methods. For example, a stick of incense, a cup of tea, a pack of cigarettes, a meal and so on. The ancients knew that an inch of time is an inch of gold. As modern people, how should we manage our time?
Establishing a scientific schedule and work plan is a scientific and effective way of time management. The following is how to use ET to realize the schedule (calendar).
Second, the demand analysis
First, analyze what functions are needed for a scientific and efficient work plan.
1. Since it is a plan, there must be an estimated completion time, a start time and an actual completion time;
2. Intuitively see how many plans have been completed in a certain year, month and week, and what plans have been completed;
3. Be able to visually see which tasks have been completed and which tasks have not been completed, and make corresponding prompts;
In view of the above requirements, the following work plans will be formulated with the following functions:
1. Automatically generate month, week, completion status and serial number (formula) according to the input work items and progress;
2. Automatically convert different background colors to indicate the completion of work items (conditional format):
Green: complete
White: incomplete
Orange: Due and overdue tasks
3. Protect the cell containing the formula from being changed (protect the worksheet).
Only the most basic formula, conditional format and the task of protecting the worksheet are used to realize the above functions, which is relatively easy to use.
Third, the production steps: