Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx

download Simdiary2011_Nguyen Thi Minh Yen_W11.Xlsx

of 46

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