Last week was a short working week and I spent most of the time on the traffic report, so nothing new to be mentioned.

As I am responsible for the xxx's one, its ctc raw data is more complicated. I spent much time on that. Suzanne double checked the data with me and for a half day we couldn't get the same figure for some data. Though the report is finally finished, I feel that this task is quite repetitive and time-consuming, so that manual checking quite likely leads to inaccuracy. So I asked Irene if I could try to pick up excel vba to automate this task. She was supportive on this. I also asked Joyce for how to segment the ctc data. Finally I made two vba for both xxx and gartel ctc data, so we just need to generate the data we need by a click. I put the .xlsm and the guide into xxxi and xrxxl's traffic report folder respectively. I will double check the logic with the team next week.

With a week of fighting with excel vba, I guess I hv learnt its general functions already. In case there are more excel data that we need to handle regularly, please let me know if I could help out to automate the task. :)