Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
-
Upload
nguyen-quang-huy -
Category
Documents
-
view
221 -
download
0
Transcript of Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
1/46
Important note: When you do next week's Diary, save and re-nameCtrl+j to clear To-Do List contents and press Ctrl+i
1.1 color codes:
Boxes with this colour means you should enter the rele
Boxes with this colour means data-entry is not required
1.2 Task No.:
(a) Each task should be allocated a Task Number for easy identification
(b) Below is the convention of numbering the Task Number:
(c) Task No. in To-Do List should be unique
Important note: Please do not insert or delete any rows or columns
1.3 Task Description
(a) Generally, the duration to complete a task should be about 1-3 hours.
(b) Big task should be broken down into smaller tasks with each not more than 2 hours to complete.(c) Task description should be as brief as possible.
2.1 Each week, you are to fill up next week's (W + 1) Week No. in F3 of the "to_do_ list" Worksheet. Eg if
week ( W+1) is Week No. 43, then type 43 in F3
2.2 The "From" & "To" dates in G4 & H4 (covering Monday to Sunday of the week) will be filled automatic
2.3 Enter the no. of days of work for the week as per contract and the relevant days deductibles in K5 to
holidays and others) and also the no. of contract working hours per day in K2 and the Net Contract Ho
2.4 Enter the tasks to be done in the box designated for W+1 and W+2 respectively
2.5 Data to be entered are:
(a) Task No.(b) Task Description
1. Data entry rules
2. To-Do-List
Week No. Task No.
XX YY
03 08
Example: WK No.3, Task No.8
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
2/46
(a) VA = Task that adds value to your scope of work
(b) NVA = Task that does not added value to the socpe of work as per your JD
NVAM = Non valude added meetingNVAT = Non valude added task
NVAP = Personal activity
NVAO = Other non valude added activity
Important note: If not sure which NVA to select, select NVAT
2.6 Priority code (according to urgency of task completion) of each task to be entered:
(a) H = High priority
(b) M = Medium priority
(c) L = Low priority
3.1 The Diary consists of 6 separate boxes. Each box represent one day from Monday to Saturday. Once
have entered the Week No.in F3 of "to_do_list" worksheet, the respective dates and week days will b
3.2 Schedule the tasks from the To-Do List to the respective time and days in the Diary.
3.3 Each week, you should schedule tasks as stated in Week W+1 of the To-Do List only.
3.4 After each task is done, you should enter the actual duration and date involved.
Other relevant data in the Diary will be populated automatically.
4.1 Save the file to a new file name
4.2 You can manually delete all the completed/scheduled tasks in the To-Do List o
4.3 Alternatively, you may press Ctrl+j to clear all contents in To-Do List and press Ctrl+i to clear all conte
4.4 Copy the planned tasks in last week's W+2 and paste to the empty space in W+1 To-Do List
4.5 Add any other new tasks in W+1 To-Do List and also update the Contract Hours section
4.6 Sort the new To-Do List in W+1 by due date (Column G)
4.7 List new planned tasks in W+2 To-Do List and also the Contract Hours section
4.8 Schedule the tasks in 4.6 above to the Diary
5.1 Status of Tasks Planned:
3. Diary
5. KPI's (These will be updated automatically)
4. Weekly maintenance
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
3/46
5.2 Task Completion Rate = No. of tasks completed/No. of tasks planned * 100 (Measuring the % task co
5.3 Plan Loading Rate = Total planning hours/Total contract hours * 100 (Measuring the % of planned hou
Note: The rule of thumb optimum % is around 60 - 70%, balance of your time could be spent to suppo
5.4 Actual Loading Rate = Total actual hours/Total contract hours * 100 (Measuring the % of actual hours
Note: If the Actual Loading Rate is higher than 100%, this reflects that you're working longer hours tha
5.5 %VA Workload = Total VA hours/Total VA and NVA hours * 100 (Measuring the %VA workload perfor
5.6 Unplanned Tasks
(a) % of unplanned tasks to contract hours = No. of unplanned tasks/Total contract hours * 100
(b) % unplanned - VA = No. of "Value-Added" unplanned tasks/Total unplanned tasks * 100
(c) % unplanned - NVA = No. of "Non-Value-Added" unplanned tasks/Total unplanned tasks * 100
5.7 Total VA/NVA hours and % incurred for the week
5.8 Summary of time consumed in NVA activities for the week
5.9 HR will extract the Plan Loading Rate (5.3), Total VA/NVA (5.7) and Summary of NVA activities (5.8) f
7.1 This Reminder section gives the following reminder alerts:
(a) If due date past today, alert is "Overdue!"(b) If due date is today, alert is "Due today!"
(c) If due date is within n days of due date, alert is "Do now!"
(d) If due date is more than n (no. of pre-alert days)
days from due date - no alert (blank)
n=no of days (from 3 to 7 days) in advance to give the alert. User to click cell O64 & choose option
Note: This Reminder has no linkage to the To-Do-List or Diary
6. Reminder in To-Do-List (Optional)
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
4/46
he file to next week's filename, then only press o clear Diary contents
ant data inside there
, data will be filled automatically
next
lly.
5 (leave, travel, public
urs in J4 will be computed automatically
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
5/46
you've
filled automatically.
ts in the Diary
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
6/46
pletion at end of each week; target is to achieve 100%)
rs as compared to contract hours available for the week)
rt functional/cross functional unplanned tasks
spent as compared to contract hours available for the week)
n you've planned to complete your tasks.
med in a week; the higher the % the better time utilized in your work)
r further VA/NVA and Workload Analyses
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
7/46
Owner: Today is:
Task
No.Task Description VA/NVA?
Priority
(H/M/L)
Duration
(Hr)110 1101 Stock count Vtec VA M 1.00
110 1102 Make DO Vtec VA H 1.50
110 1103 Update Q_Chart daily-Mon VA M 0.50
110 1104 Update New production VA M 2.00110 1105 5S for file SO sheets NVAM M 1.00
110 1106 Make Do SenZ by Air VA M 1.00
110 1107 Stock count CAPL VA H 1.50
110 1108 Update New production-Tue VA M 2.00
110 1109 OTD meeting VA M 1.00
111 1110 Make MOM_OTD_W10-Tue VA M 1.00
111 1111 Make MOM_SIM_W10-Tue VA M 1.00
111 1112 Update Q_chart daily-Tue VA M 0.50
111 1113 C2-Wed VA M 0.50111 1114 Stock count Sela VA H 1.50
111 1115 Update new production-Wed VA M 2.00
111 1116 Make MOM_SIM_W10-Wed VA M 1.00
111 1117 Update Q_chart daily-Wed VA M 0.50
111 1118 Wip=0-Wed NVAM M 2.00
111 1119 C2-Thu VA M 0.50
112 1120 Make DO daily-Thu VA H 2.00
112 1121 Update new production-Thu VA M 2.00
112 1122 Make MOM_SIM_W10-Thu VA M 1.00
112 1123 Update Q_chart daily-Thu VA M 0.50
112 1124 Make DO Senz VA M 1.00
112 1125 C2_Fri VA M 0.50
112 1126 Make planing & Issue to production VA M 1.50
112 1127 Join BSC Presentation VA M 1.00
112 1128 Join traning Excel VA L 2.00
112 1129 Make Do daily_Fri VA M 1.00
113 1130 Update DO Into OTD VA L 1.00113 1131
113 1132
113 1133
113 1134
113 1135
113 1136
113 1137
113 1138
113 1139114 1140
Nguyen Thi Minh Yen
To-Do List for (W + 1) Week No. 11
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
8/46
114 1145
114 1146
114 1147
114 1148
114 1149
115 1150
Total: 35.50
Task
No.Task Description VA/NVA?
Prioirty
(H/M/L)
Duration
(Hours)1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
12131214
1215
1216
1217
1218
1219
1220
1221
12221223
1224
1225
1226
1227
1228
1229
1230
1231
To-Do List for (W + 2) Week No. 12
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
9/46
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
12481249
1250
Total: 0.00
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
10/46
Contract Hrs/Day 8.5
To Contract Hrs/Wk Gross Leave Travel P/Holidays20/Mar/11 42.50 42.50 0.00 0.00 0.00
No. of days 5 0 0 0
Due Date Time Completed?
14/Mar/11 9:30 Open #
14/Mar/11 10:30 Open #
14/Mar/11 12:00 Open #
14/Mar/11 13:00 Open #14/Mar/11 15:00 Open #
8/Mar/11 8:30 #N/A #
8/Mar/11 9:30 #N/A #
8/Mar/11 11:00 #N/A #
8/Mar/11 14:00 #N/A #
8/Mar/11 15:00 #N/A #
8/Mar/11 16:00 #N/A #
8/Mar/11 17:00 #N/A #
9/Mar/11 8:30 #N/A #9/Mar/11 9:30 #N/A #
9/Mar/11 11:00 #N/A #
9/Mar/11 14:00 #N/A #
9/Mar/11 15:00 #N/A #
9/Mar/11 15:30 #N/A #
10/Mar/11 8:30 #N/A #
10/Mar/11 9:30 #N/A #
10/Mar/11 13:30 #N/A #
10/Mar/11 14:30 #N/A #
10/Mar/11 15:30 #N/A #
10/Mar/11 16:00 #N/A #
11/Mar/11 8:30 #N/A #
11/Mar/11 9:30 #N/A #
11/Mar/11 11:00 #N/A #
11/Mar/11 14:00 #N/A #
11/Mar/11 13:00 #N/A #
11/Mar/11 16:00 #N/A ##N/A #
#N/A #
#N/A #
#N/A #
#N/A #
#N/A #
#N/A #
#N/A #
#N/A ##N/A #
6/Mar/14Excluding lunch and tea brea
From14/Mar/11
JanJan 2011
Sun Mon Tue Wed Thu Fri
26 27 28 29 30 31
2 3 4 5 6 7
9 10 11 12 13 14
16 17 18 19 20 21
23 24 25 26 27 28
30 31 1 2 3 4
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
11/46
#N/A #
#N/A #
#N/A #
#N/A #
#N/A #
#N/A #
0
Contract Hrs/Day 8.5
To Contract Hrs/Wk Gross Leave Travel P/Holidays
42.50 42.50 0.00 0.00 0.00
No. of days 5 0 0 0
Due Date Time Status Due DateReminder
27/Mar/11
Excluding lunch and tea
From
21/Mar/11
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
12/46
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
13/46
Others0.00
0
s
2011
Sat
1
8
15
22
29
5
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
14/46
Others
0.00
0
Alert 5
breaks
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
15/46
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
16/46
Owner: Today is:
Time Plan VA/NVA? Actual
8:00
8:30
9:00
9:30 1101 Stock count Vtec Sto 1.00
10:00
10:30 1102 Make DO Vtec Ma 1.50
11:00
11:30
12:00 1103 Update Q_Chart daily-Mon Up 0.50
12:30
13:00 1104 Update New production Up 2.00
13:30
14:00
14:30
15:00 1105 5S for file SO sheets 5S 1.00
15:30
16:00
16:30
17:00
17:30
18:0018:30
19:00
19:30
20:00
20:30
21:00
6.00 0.00 0.00
6/Mar/14
Task No. & Description
SI
Monday, March 14, 2011
Nguyen Thi Minh Yen
Unplanned Tasks
Total:
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
17/46
0.00
Time Plan VA/NVA? Actual
8:008:30
9:00
9:30
10:00
10:30
11:0011:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:000.00 0.00 0.00
Wednesday, March 16, 2011
Task No. & Description
Total:
Total:
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
18/46
0.00
Time Plan VA/NVA? Actual
8:00
8:30
9:00
9:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:3014:00
14:30
15:00
15:30
16:00
16:30
17:00
17:3018:00
18:30
19:00
19:30
20:00
20:30
21:00 0 00 0 00 0 00Total:
Friday, March 18, 2011
Task No. & Description
Total:
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
19/46
0.00Total:
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
20/46
Comp Date Time Plan VA/NVA? Actual
8:00
8:30
9:00
9:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:3015:00
15:30
16:00
16:30
17:00
17:30
18:0018:30
19:00
19:30
20:00
20:30
21:00
0.00 0.00 0.00
M Diary for W11
Total:
Tuesday, March 15, 2011
Task No. & Description
Unplanned Tasks
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
21/46
0.00 0.00
Comp Date Time Plan VA/NVA? Actual
8:008:30
9:00
9:30
10:00
10:30
11:0011:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
0.00 0.00 0.00
Thursday, March 17, 2011
Total:
Task No. & Description
Total:
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
22/46
0.00 0.00
Comp Date Time Plan VA/NVA? Actual
8:00
8:30
9:00
9:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:3014:00
14:30
15:00
15:30
16:00
16:30
17:00
17:3018:00
18:30
19:00
19:30
20:00
20:30
21:00
0 00 0 00 0 00
Task No. & Description
Saturday, March 19, 2011
Total:
Total:
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
23/46
0.00 0.00Total:
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
24/46
Comp Date
Jan 2011Jan 2011
Mon Tue Wed Thu Fri Sat Sun
27 28 29 30 31 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
25/46
0.00
Comp Date
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
26/46
0.00
Comp Date
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
27/46
0.00
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
28/46
Task No. Task Description A/NVA rity(H/M/ uration(Hr) Due Date Time
1101 Stock count Vtec VA M 1.00 14/Mar/11 9:30 AM
1102 Make DO Vtec VA H 1.50 14/Mar/11 10:30 AM
1103 Update Q_Chart daily-Mo VA M 0.50 14/Mar/11 12:00 PM
1104 Update New production VA M 2.00 14/Mar/11 1:00 PM
1105 5S for file SO sheets NVAM M 1.00 14/Mar/11 3:00 PM
1106 Make Do SenZ by Air VA M 1.00 8/Mar/11 8:30 AM
1107 Stock count CAPL VA H 1.50 8/Mar/11 9:30 AM1108 Update New production-Tue VA M 2.00 8/Mar/11 11:00 AM
1109 OTD meeting VA M 1.00 8/Mar/11 2:00 PM
1110 Make MOM_OTD_W10-Tu VA M 1.00 8/Mar/11 3:00 PM
1111 Make MOM_SIM_W10-Tue VA M 1.00 8/Mar/11 4:00 PM
1112 Update Q_chart daily-Tue VA M 0.50 8/Mar/11 5:00 PM
1113 C2-Wed VA M 0.50 9/Mar/11 8:30 AM
1114 Stock count Sela VA H 1.50 9/Mar/11 9:30 AM
1115 Update new production-We VA M 2.00 9/Mar/11 11:00 AM
1116 Make MOM_SIM_W10-We VA M 1.00 9/Mar/11 2:00 PM1117 Update Q_chart daily-Wed VA M 0.50 9/Mar/11 3:00 PM
1118 Wip=0-Wed NVAM M 2.00 9/Mar/11 3:30 PM
1119 C2-Thu VA M 0.50 10/Mar/11 8:30 AM
1120 Make DO daily-Thu VA H 2.00 10/Mar/11 9:30 AM
1121 Update new production-Thu VA M 2.00 10/Mar/11 1:30 PM
1122 Make MOM_SIM_W10-Thu VA M 1.00 10/Mar/11 2:30 PM
1123 Update Q_chart daily-Thu VA M 0.50 10/Mar/11 3:30 PM
1124 Make DO Senz VA M 1.00 10/Mar/11 4:00 PM
1125 C2_Fri VA M 0.50 11/Mar/11 8:30 AM1126 Make planing & Issue to pro VA M 1.50 11/Mar/11 9:30 AM
1127 Join BSC Presentation VA M 1.00 11/Mar/11 11:00 AM
1128 Join traning Excel VA L 2.00 11/Mar/11 2:00 PM
1129 Make Do daily_Fri VA M 1.00 11/Mar/11 1:00 PM
1130 Update DO Into OTD VA L 1.00 11/Mar/11 4:00 PM
1131 0.00 12:00 AM
1132 0.00 12:00 AM
1133 0.00 12:00 AM
1134 0.00 12:00 AM
1135 0.00 12:00 AM
1136 0.00 12:00 AM
1137 0.00 12:00 AM
1138 0.00 12:00 AM
1139 0.00 12:00 AM
1140 0.00 12:00 AM
1141 0.00 12:00 AM
1142 0.00 12:00 AM
KPI for We
Status of Tasks Planned
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
29/46
1148 0.00 12:00 AM
1149 0.00 12:00 AM
1150 0.00 12:00 AM
Total: 35.5
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
30/46
Completed? Week No. 11 12
Open No. of Planned Tasks 30 0
Open Completed Tasks 0 0
Open Task Completion Rate 0.0% 0.0%
Open Total Planning Hours 35.50 0.00
Open Weekly Contract Hours 42.50 42.50
#N/A Plan Loading Rate 83.5% 0.0%
#N/A Actual Loading Rate 0.0%#N/A
#N/A % VA Hrs/Ttl Planned & Unplanned Hrs 0.0%
#N/A
#N/A
#N/A Week No. 11
#N/A No. of Unplanned Tasks 0
#N/A Unplanned Hours Used 0.00
#N/A % to Contract Hours 0.0%
#N/A VA Unplanned Tasks 0#N/A NVA Unplanned Tasks 0
#N/A % Unplanned - VA 0.0%
#N/A %Unplanned - NVA 0.0%
#N/A Total VA Hours 0.00 #DIV/0!
#N/A Total NVA Hours 0.00 #DIV/0!
#N/A Total VA + NVA Hours 0.00 #DIV/0!
#N/A NVA Meeting 0.00 #DIV/0!
#N/A NVA Task 0.00 #DIV/0!
#N/A NVA Personal 0.00 #DIV/0!#N/A NVA Others 0.00 #DIV/0!
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A/
k No. 11
Task Planning & Completion Efficiency
5
1
2
3
4
5
6
No. of tasks
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
31/46
#N/A
#N/A
#N/A
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
32/46
11
0.0%
35.5
42.5
0.0
0.0
Note: Do not "copy" then
"paste" directly into SIM
Diary Tracking file. Pls
choose "Paste special"
then "Paste value"
Last SIM diary updated
This week SIM diary update
Total Planning Hours
Weekly contract hours
Total VA Hours
Task Completion Rate
Total NVA Hours
Copy to SIM Diary Tracking
Week No.
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
33/46
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
34/46
From To From To
Monday Sunday Monday Sunday1 3/Jan/11 9/Jan/11
2 10/Jan/11 16/Jan/11
3 17/Jan/11 23/Jan/11
4 24/Jan/11 30/Jan/11
5 31/Jan/11 6/Feb/11
6 7/Feb/11 13/Feb/11
7 14/Feb/11 20/Feb/11
8 21/Feb/11 27/Feb/11
9 28/Feb/11 6/Mar/1153 27/Dec/10 2/Jan/11 10 7/Mar/11 13/Mar/11
11 14/Mar/11 20/Mar/11
12 21/Mar/11 27/Mar/11
13 28/Mar/11 3/Apr/11
14 4/Apr/11 10/Apr/11
15 11/Apr/11 17/Apr/11
16 18/Apr/11 24/Apr/11
17 25/Apr/11 1/May/11
18 2/May/11 8/May/11
19 9/May/11 15/May/11
20 16/May/11 22/May/11
21 23/May/11 29/May/11
22 30/May/11 5/Jun/11
23 6/Jun/11 12/Jun/11
24 13/Jun/11 19/Jun/11
25 20/Jun/11 26/Jun/11
26 27/Jun/11 3/Jul/1127 4/Jul/11 10/Jul/11
28 11/Jul/11 17/Jul/11
29 18/Jul/11 24/Jul/11
30 25/Jul/11 31/Jul/11
31 1/Aug/11 7/Aug/11
32 8/Aug/11 14/Aug/11
33 15/Aug/11 21/Aug/11
34 22/Aug/11 28/Aug/11
35 29/Aug/11 4/Sep/1136 5/Sep/11 11/Sep/11
37 12/Sep/11 18/Sep/11
38 19/Sep/11 25/Sep/11
39 26/Sep/11 2/Oct/11
40 3/Oct/11 9/Oct/11
41 10/Oct/11 16/Oct/11
42 17/Oct/11 23/Oct/11
43 24/Oct/11 30/Oct/11
44 31/Oct/11 6/Nov/11
2010 2011
Wk No. Wk No.
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
35/46
49 5/Dec/11 11/Dec/11
50 12/Dec/11 18/Dec/11
51 19/Dec/11 25/Dec/11
52 26/Dec/11 1/Jan/12
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
36/46
Items Elementary Task
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
37/46
Last update:
1/Jan/11Day
Date
Day
Date
Day
Date
Mon Mon Mon
Tue Tue 1 Tue 1
Wed Wed 2 Public Holiday Tet Holiday Wed 2
Thu Thu 3 Public Holiday Tet Holiday Thu 3
Fri Fri 4 Public Holiday Tet Holiday Fri 4
Sat 1 Public Holiday Tet Holiday Sat 5 Public Holiday Tet Holiday Sat 5
Sun 2 Sun 6 Public Holiday Tet Holiday Sun 6
Mon 3 Mon 7 Public Holiday Tet Holiday Mon 7
Tue 4 Tue 8 Tue 8
Wed 5 Wed 9 Wed 9
Thu 6 Thu 10 Thu 10
Fri 7 Fri 11 Fri 11
Sat 8 Sat 12 Sat 12
Sun 9 Sun 13 Sun 13
Mon 10 Mon 14 Mon 14
Tue 11 Tue 15 Tue 15
Wed 12 Wed 16 Wed 16
Thu 13 Thu 17 Thu 17
Fri 14 Fri 18 Fri 18
Sat 15 Sat 19 Sat 19
Sun 16 Sun 20 Sun 20
Mon 17 Mon 21 Mon 21
Tue 18 Tue 22 Tue 22
Wed 19 Wed 23 Wed 23
Thu 20 Thu 24 Thu 24
Fri 21 Fri 25 Fri 25
Sat 22 Sat 26 Sat 26
Sun 23 Sun 27 Sun 27
Mon 24 Mon 28 Mon 28
Tue 25 Tue Tue 29
Wed 26 Wed Wed 30Thu 27 Thu Thu 31
January February
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
38/46
Fri 28 Fri Fri
Sat 29 Sat Sat
Sun 30 Sun SunMon 31 Mon Mon
Tue
Business Travel
SPS Review
SPS Mock Audit
SPS Audit
Mnthly meetin
Send/Sbmt rprt
Attend training
Give training
Public Holiday
On leave
Other
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
39/46
Day
Date
Day
Date
Day
Date
Mon Mon Mon
Tue Tue Tue
Wed Wed Wed 1
Thu Thu Thu 2
Fri 1 Fri Fri 3
Sat 2 Sat Sat 4
Sun 3 Sun 1 Public Holiday National Labor day Sun 5
Mon 4 Mon 2 Mon 6
Tue 5 Tue 3 Tue 7
Wed 6 Wed 4 Wed 8
Thu 7 Thu 5 Thu 9
Fri 8 Fri 6 Fri 10
Sat 9 Sat 7 Sat 11
Sun 10 Sun 8 Sun 12
Mon 11 Mon 9 Mon 13
Tue 12 Public Holiday King's day Tue 10 Tue 14
Wed 13 Wed 11 Wed 15
Thu 14 Thu 12 Thu 16
Fri 15 Fri 13 Fri 17
Sat 16 Sat 14 Sat 18
Sun 17 Sun 15 Sun 19
Mon 18 Mon 16 Mon 20
Tue 19 Tue 17 Tue 21
Wed 20 Wed 18 Wed 22
Thu 21 Thu 19 Thu 23
Fri 22 Fri 20 Fri 24
Sat 23 Sat 21 Sat 25
Sun 24 Sun 22 Sun 26
Mon 25 Mon 23 Mon 27
Tue 26 Tue 24 Tue 28
Wed 27 Wed 25 Wed 29Thu 28 Thu 26 Thu 30
March April May
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
40/46
Fri 29 Fri 27 Fri
Sat 30 Sat 28 Sat
Sun Sun 29 SunMon Mon 30 Mon
Tue 31
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
41/46
Day
Date
Day
Date
Day
Date
Mon Mon 1 Mon
Tue Tue 2 Tue
Wed Wed 3 Wed
Thu Thu 4 Thu 1
Fri 1 Fri 5 Fri 2
Sat 2 Sat 6 Sat 3
Sun 3 Sun 7 Sun 4
Mon 4 Mon 8 Mon 5Tue 5 Tue 9 Tue 6
Wed 6 Wed 10 Wed 7
Thu 7 Thu 11 Thu 8
Fri 8 Fri 12 Fri 9
Sat 9 Sat 13 Sat 10
Sun 10 Sun 14 Sun 11
Mon 11 Mon 15 Mon 12
Tue 12 Tue 16 Tue 13
Wed 13 Wed 17 Wed 14
Thu 14 Thu 18 Thu 15
Fri 15 Fri 19 Fri 16
Sat 16 Sat 20 Sat 17
Sun 17 Sun 21 Sun 18
Mon 18 Mon 22 Mon 19
Tue 19 Tue 23 Tue 20
Wed 20 Wed 24 Wed 21
Thu 21 Thu 25 Thu 22
Fri 22 Fri 26 Fri 23
Sat 23 Sat 27 Sat 24
Sun 24 Sun 28 Sun 25
Mon 25 Mon 29 Mon 26
Tue 26 Tue 30 Tue 27
Wed 27 Wed 31 Wed 28
Thu 28 Thu Thu 29
June July August
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
42/46
Fri 29 Fri Fri 30
Sat 30 Sat Sat
Sun 31 Sun SunMon Mon Mon
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
43/46
Day
Date
Day
Date
Day
Date
Mon Mon Mon
Tue Tue 1 Tue
Wed Wed 2 Wed
Thu Thu 3 Thu 1
Public Holiday Victory Day Fri Fri 4 Fri 2
Sat 1 Sat 5 Sat 3
Sun 2 Sun 6 Sun 4
Mon 3 Mon 7 Mon 5Tue 4 Tue 8 Tue 6
Wed 5 Wed 9 Wed 7
Thu 6 Thu 10 Thu 8
Fri 7 Fri 11 Fri 9
Sat 8 Sat 12 Sat 10
Sun 9 Sun 13 Sun 11
Mon 10 Mon 14 Mon 12
Tue 11 Tue 15 Tue 13
Wed 12 Wed 16 Wed 14
Thu 13 Thu 17 Thu 15
Fri 14 Fri 18 Fri 16
Sat 15 Sat 19 Sat 17
Sun 16 Sun 20 Sun 18
Mon 17 Mon 21 Mon 19
Tue 18 Tue 22 Tue 20
Wed 19 Wed 23 Wed 21
Thu 20 Thu 24 Thu 22
Fri 21 Fri 25 Fri 23
Sat 22 Sat 26 Sat 24
Sun 23 Sun 27 Sun 25
Mon 24 Mon 28 Mon 26
Tue 25 Tue 29 Tue 27
Wed 26 Wed 30 Wed 28
Thu 27 Thu Thu 29
NovemberSeptember October
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
44/46
Fri 28 Fri Fri 30
Sat 29 Sat Sat 31
Sun 30 Sun SunMon 31 Mon Mon
Tue
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
45/46
Day
Mon
Tue
Wed
Thu
Fri
Sat
Sun
MonTue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue
Wed
Thu
December
-
8/12/2019 Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx
46/46
Fri
Sat
SunMon