In fact, the job of the captain is mainly to produce their own data; for other normal people in the same position, it cannot be said to be that easy, at least it definitely does not support updating three times a day after work.
The reason why I can do it now is mainly because I have taught myself various formulas in Excel, array formulas and VBA at work, and gradually improved it, reaching a relatively high level of automation.
Under the most ideal mode, I can finish the work in a few minutes that takes two to three hours for other people in similar positions.
But Xiaowei is not a programmer after all, and is often a collection of various native methods. For example, in VBA, there are simple writing methods that he has mastered, writing methods for various situations from Baidu, and splicing of recorded macros, etc.
Yesterday, a situation suddenly occurred, and it was discovered that a data type that had not been published before was needed. First, the database needed to be expanded, and then the formulas that were very difficult to write (such as the fifth and sixth situations in the four-layer nested if) also needed to be written.
Adjustment.
In fact, based on yesterday's evaluation, it seems that the workload is not too big and can be completed in two or three hours every day. It can be completed this morning.
But today I was playing around and found that after the cells are cut and rearranged, although the formula will not change, the range.value referenced in VBA is a fixed cell position and must be modified one by one. There is no pattern and the amount is very large.
Big. And many of them were simply recorded.
The captain was a little more advanced when it came to this, so he tentatively scheduled two updates in the afternoon and one update in the evening. However, it was only a quick update in the afternoon, and he couldn't let go of the unfinished data. He has been working on it until now, and finally it's done.
My brain is so hot that I can't even take a shower to cool it down.
I won’t update it today. If I have nothing to do tomorrow, I will try to write 4 shots and 4 at once.