{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["InputSheet","remove_dupl","PlanningSheet","UtilizationReport","Holidays","Help"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":1,"defined_names":25,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"InputSheet","index":0,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,5,0,6]]}
["Team members","Capacity (hrs/week)",null,"Projects & tasks",null,"Assignments",null,null,"Other Inputs","Value","Comment"]
["Tonia Harkle",40,null,"Admin / meetings",null,"Team member","Projects & tasks",null,"Monday of week 1","2021-01-04","Must be a Monday in date format"]
["Ramon Magill",40,null,"ERP Implementation",null,"Adrian Neumeyer","Admin / meetings",null,"Number of weeks",52,"Min 1, Max 1000"]
["Peter Norton",20,null,"Windows upgrade",null,"Adrian Neumeyer","ERP Implementation",null,"Country","US","UK/US, other Countries don’t account for holidays"]
["Adrian Neumeyer",40,null,null,null,"Adrian Neumeyer","Windows upgrade",null,"FTE / month",172,"Full-Time Equivalent per month (average, in hours)"]
[null,null,null,null,null,"Peter Norton","ERP Implementation"]
[null,null,null,null,null,"Peter Norton","Windows upgrade"]
[null,null,null,null,null,"Ramon Magill","Admin / meetings"]
[null,null,null,null,null,"Tonia Harkle","Admin / meetings"]
[null,null,null,null,null,"Tonia Harkle","ERP Implementation"]
[null,null,null,null,null,"Tonia Harkle","Windows upgrade"]

{"sheet":"remove_dupl","index":1,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Adrian Neumeyer","Admin / meetings"]
["Adrian Neumeyer","ERP Implementation"]
["Adrian Neumeyer","Windows upgrade"]
["Peter Norton","ERP Implementation"]
["Peter Norton","Windows upgrade"]
["Ramon Magill","Admin / meetings"]
["Tonia Harkle","Admin / meetings"]
["Tonia Harkle","ERP Implementation"]
["Tonia Harkle","Windows upgrade"]

{"sheet":"PlanningSheet","index":2,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":true,"merged":[[6,3,7,3]]}
[null,"e"]
[null,"year","Team Planner",null,{"$f":"YEAR(E7)","v":2020}]
[null,"month",null,null,{"$f":"TEXT(E7,\"MMMM\")","v":"December"}]
[null,"month2",null,null,{"$f":"MONTH(E7)","v":12}]
[null,"week",null,"week",{"$f":"WEEKNUM(E7)","v":53}]
[null,"week2",null,-1,{"$f":"D6+1","v":0}]
[null,"date1",null,"dates",{"$f":"InputSheet!Monday1+7*(E6-1)","v":"2020-12-28"}]
[null,"date2",null,null,{"$f":"E7+6","v":"2021-01-03"}]
[null,"workdays",null,"# workdays",{"$f":"5-COUNTIFS(hol_country,country,hol_monday,PlanningSheet!E7,hol_weekday,TRUE)","v":4}]
[null,"availableFTE","Available FTE"]
[null,"e"]
[null,"name"]
[null,"data"]
[null,"total","temp"]

{"sheet":"UtilizationReport","index":3,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Team member","Capacity (hrs/week)","Week50"]
[null,"Tonia Harkle",{"$f":"VLOOKUP(B3,tblMemb,2,0)","v":40},{"$f":"INDEX(#REF!,MATCH(\"Total - \"&$B3,#REF!,0),0)/$C3","v":{"$error":"#REF!"}}]

{"sheet":"Holidays","index":4,"n_rows":248,"n_cols":5,"rows_kept":248,"cut":false,"hidden":false,"merged":[]}
["Date","Description","Country","Monday","Weekday"]
["2018-12-25","Christmas","UK",{"$f":"A2-WEEKDAY(A2,2)+1","v":"2018-12-24"},{"$f":"WEEKDAY(A2,2)<6","v":true}]
["2019-12-25","Christmas","UK",{"$f":"A3-WEEKDAY(A3,2)+1","v":"2019-12-23"},{"$f":"WEEKDAY(A3,2)<6","v":true}]
["2020-12-25","Christmas","UK","2020-12-21",true]
["2021-12-25","Christmas","UK","2021-12-20",false]
["2022-12-25","Christmas","UK","2022-12-19",false]
["2023-12-25","Christmas","UK","2023-12-25",true]
["2024-12-25","Christmas","UK","2024-12-23",true]
["2025-12-25","Christmas","UK","2025-12-22",true]
["2026-12-25","Christmas","UK","2026-12-21",true]
["2027-12-25","Christmas","UK","2027-12-20",false]
["2028-12-25","Christmas","UK","2028-12-25",true]
["2029-12-25","Christmas","UK","2029-12-24",true]
["2030-12-25","Christmas","UK","2030-12-23",true]
["2018-01-01","New Year's Day","UK","2018-01-01",true]
["2019-01-01","New Year's Day","UK","2018-12-31",true]
["2020-01-01","New Year's Day","UK","2019-12-30",true]
["2021-01-01","New Year's Day","UK","2020-12-28",true]
["2022-01-01","New Year's Day","UK","2021-12-27",false]
["2023-01-01","New Year's Day","UK","2022-12-26",false]
["2024-01-01","New Year's Day","UK","2024-01-01",true]
["2025-01-01","New Year's Day","UK","2024-12-30",true]
["2026-01-01","New Year's Day","UK","2025-12-29",true]
["2027-01-01","New Year's Day","UK","2026-12-28",true]
["2028-01-01","New Year's Day","UK","2027-12-27",false]
["2029-01-01","New Year's Day","UK","2029-01-01",true]
["2030-01-01","New Year's Day","UK","2029-12-31",true]
["2018-12-25","Christmas","US","2018-12-24",true]
["2019-12-25","Christmas","US","2019-12-23",true]
["2020-12-25","Christmas","US","2020-12-21",true]
["2021-12-25","Christmas","US","2021-12-20",false]
["2022-12-25","Christmas","US","2022-12-19",false]
["2023-12-25","Christmas","US","2023-12-25",true]
["2024-12-25","Christmas","US","2024-12-23",true]
["2025-12-25","Christmas","US","2025-12-22",true]
["2026-12-25","Christmas","US","2026-12-21",true]
["2027-12-25","Christmas","US","2027-12-20",false]
["2028-12-25","Christmas","US","2028-12-25",true]
["2029-12-25","Christmas","US","2029-12-24",true]
["2030-12-25","Christmas","US","2030-12-23",true]
["2018-01-01","New Year's Day","US","2018-01-01",true]
["2019-01-01","New Year's Day","US","2018-12-31",true]
["2020-01-01","New Year's Day","US","2019-12-30",true]
["2021-01-01","New Year's Day","US","2020-12-28",true]
["2022-01-01","New Year's Day","US","2021-12-27",false]
["2023-01-01","New Year's Day","US","2022-12-26",false]
["2024-01-01","New Year's Day","US","2024-01-01",true]
["2025-01-01","New Year's Day","US","2024-12-30",true]
["2026-01-01","New Year's Day","US","2025-12-29",true]
["2027-01-01","New Year's Day","US","2026-12-28",true]
["2028-01-01","New Year's Day","US","2027-12-27",false]
["2029-01-01","New Year's Day","US","2029-01-01",true]
["2030-01-01","New Year's Day","US","2029-12-31",true]
["2018-10-08","Columbus Day","US","2018-10-08",true]
[{"$f":"(DATE(YEAR(A54)+1,10,1)+(2-1)*7)+2-WEEKDAY(DATE(YEAR(A54)+1,10,1),1)+IF(2<WEEKDAY(DATE(YEAR(A54)+1,10,1),1),7,0)","v":"2019-10-14"},"Columbus Day","US","2019-10-14",true]
["2020-10-12","Columbus Day","US","2020-10-12",true]
["2021-10-11","Columbus Day","US","2021-10-11",true]
["2022-10-10","Columbus Day","US","2022-10-10",true]
["2023-10-09","Columbus Day","US","2023-10-09",true]
["2024-10-14","Columbus Day","US","2024-10-14",true]
["2025-10-13","Columbus Day","US","2025-10-13",true]
["2026-10-12","Columbus Day","US","2026-10-12",true]
["2027-10-11","Columbus Day","US","2027-10-11",true]
["2028-10-09","Columbus Day","US","2028-10-09",true]
["2029-10-08","Columbus Day","US","2029-10-08",true]
["2030-10-14","Columbus Day","US","2030-10-14",true]
["2018-07-04","Independence Day","US",{"$f":"A67-WEEKDAY(A67,2)+1","v":"2018-07-02"},{"$f":"WEEKDAY(A67,2)<6","v":true}]
["2019-07-04","Independence Day","US","2019-07-01",true]
["2020-07-04","Independence Day","US","2020-06-29",false]
["2021-07-04","Independence Day","US","2021-06-28",false]
["2022-07-04","Independence Day","US","2022-07-04",true]
["2023-07-04","Independence Day","US","2023-07-03",true]
["2024-07-04","Independence Day","US","2024-07-01",true]
["2025-07-04","Independence Day","US","2025-06-30",true]
["2026-07-04","Independence Day","US","2026-06-29",false]
["2027-07-04","Independence Day","US","2027-06-28",false]
["2028-07-04","Independence Day","US","2028-07-03",true]
["2029-07-04","Independence Day","US","2029-07-02",true]
["2030-07-04","Independence Day","US","2030-07-01",true]
["2018-09-03","Labor Day","US","2018-09-03",true]
[{"$f":"(DATE(YEAR(A80)+1,9,1)+(1-1)*7)+2-WEEKDAY(DATE(YEAR(A80)+1,9,1),1)+IF(2<WEEKDAY(DATE(YEAR(A80)+1,9,1),1),7,0)","v":"2019-09-02"},"Labor Day","US","2019-09-02",true]
["2020-09-07","Labor Day","US","2020-09-07",true]
["2021-09-06","Labor Day","US","2021-09-06",true]
["2022-09-05","Labor Day","US","2022-09-05",true]
["2023-09-04","Labor Day","US","2023-09-04",true]
["2024-09-02","Labor Day","US","2024-09-02",true]
["2025-09-01","Labor Day","US","2025-09-01",true]
["2026-09-07","Labor Day","US","2026-09-07",true]
["2027-09-06","Labor Day","US","2027-09-06",true]
["2028-09-04","Labor Day","US","2028-09-04",true]
["2029-09-03","Labor Day","US","2029-09-03",true]
["2030-09-02","Labor Day","US","2030-09-02",true]
["2018-01-15","M.L.King Jr. Day","US","2018-01-15",true]
[{"$f":"(DATE(YEAR(A93)+1,1,1)+(3-1)*7)+2-WEEKDAY(DATE(YEAR(A93)+1,1,1),1)+IF(2<WEEKDAY(DATE(YEAR(A93)+1,1,1),1),7,0)","v":"2019-01-21"},"M.L.King Jr. Day","US","2019-01-21",true]
["2020-01-20","M.L.King Jr. Day","US","2020-01-20",true]
["2021-01-18","M.L.King Jr. Day","US","2021-01-18",true]
["2022-01-17","M.L.King Jr. Day","US","2022-01-17",true]
["2023-01-16","M.L.King Jr. Day","US","2023-01-16",true]
["2024-01-15","M.L.King Jr. Day","US","2024-01-15",true]
["2025-01-20","M.L.King Jr. Day","US","2025-01-20",true]
["2026-01-19","M.L.King Jr. Day","US","2026-01-19",true]
["2027-01-18","M.L.King Jr. Day","US","2027-01-18",true]
["2028-01-17","M.L.King Jr. Day","US","2028-01-17",true]
["2029-01-15","M.L.King Jr. Day","US","2029-01-15",true]
["2030-01-21","M.L.King Jr. Day","US","2030-01-21",true]
["2018-05-28","Memorial Day","US","2018-05-28",true]
[{"$f":"(DATE(YEAR(A106)+1,6,1)+(0-1)*7)+2-WEEKDAY(DATE(YEAR(A106)+1,6,1),1)+IF(2<WEEKDAY(DATE(YEAR(A106)+1,6,1),1),7,0)","v":"2019-05-27"},"Memorial Day","US","2019-05-27",true]
["2020-05-25","Memorial Day","US","2020-05-25",true]
["2021-05-31","Memorial Day","US","2021-05-31",true]
["2022-05-30","Memorial Day","US","2022-05-30",true]
["2023-05-29","Memorial Day","US","2023-05-29",true]
["2024-05-27","Memorial Day","US","2024-05-27",true]
["2025-05-26","Memorial Day","US","2025-05-26",true]
["2026-05-25","Memorial Day","US","2026-05-25",true]
["2027-05-31","Memorial Day","US","2027-05-31",true]
["2028-05-29","Memorial Day","US","2028-05-29",true]
["2029-05-28","Memorial Day","US","2029-05-28",true]
["2030-05-27","Memorial Day","US","2030-05-27",true]
["2018-02-19","Presidents Day","US","2018-02-19",true]
[{"$f":"(DATE(YEAR(A119)+1,2,1)+(3-1)*7)+2-WEEKDAY(DATE(YEAR(A119)+1,2,1),1)+IF(2<WEEKDAY(DATE(YEAR(A119)+1,2,1),1),7,0)","v":"2019-02-18"},"Presidents Day","US","2019-02-18",true]
["2020-02-17","Presidents Day","US","2020-02-17",true]
["2021-02-15","Presidents Day","US","2021-02-15",true]
["2022-02-21","Presidents Day","US","2022-02-21",true]
["2023-02-20","Presidents Day","US","2023-02-20",true]
["2024-02-19","Presidents Day","US","2024-02-19",true]
["2025-02-17","Presidents Day","US","2025-02-17",true]
["2026-02-16","Presidents Day","US","2026-02-16",true]
["2027-02-15","Presidents Day","US","2027-02-15",true]
["2028-02-21","Presidents Day","US","2028-02-21",true]
["2029-02-19","Presidents Day","US","2029-02-19",true]
["2030-02-18","Presidents Day","US",{"$f":"A131-WEEKDAY(A131,2)+1","v":"2030-02-18"},{"$f":"WEEKDAY(A131,2)<6","v":true}]
["2018-11-22","Thanksgiving","US","2018-11-19",true]
[{"$f":"(DATE(YEAR(A132)+1,11,1)+(4-1)*7)+5-WEEKDAY(DATE(YEAR(A132)+1,11,1),1)+IF(5<WEEKDAY(DATE(YEAR(A132)+1,11,1),1),7,0)","v":"2019-11-28"},"Thanksgiving","US","2019-11-25",true]
["2020-11-26","Thanksgiving","US","2020-11-23",true]
["2021-11-25","Thanksgiving","US","2021-11-22",true]
["2022-11-24","Thanksgiving","US","2022-11-21",true]
["2023-11-23","Thanksgiving","US","2023-11-20",true]
["2024-11-28","Thanksgiving","US","2024-11-25",true]
["2025-11-27","Thanksgiving","US","2025-11-24",true]
["2026-11-26","Thanksgiving","US","2026-11-23",true]
["2027-11-25","Thanksgiving","US","2027-11-22",true]
["2028-11-23","Thanksgiving","US","2028-11-20",true]
["2029-11-22","Thanksgiving","US","2029-11-19",true]
["2030-11-28","Thanksgiving","US","2030-11-25",true]
["2018-11-11","Veterans Day","US","2018-11-05",false]
["2019-11-11","Veterans Day","US","2019-11-11",true]
["2020-11-11","Veterans Day","US","2020-11-09",true]
["2021-11-11","Veterans Day","US","2021-11-08",true]
["2022-11-11","Veterans Day","US","2022-11-07",true]
["2023-11-11","Veterans Day","US","2023-11-06",false]
["2024-11-11","Veterans Day","US","2024-11-11",true]
["2025-11-11","Veterans Day","US","2025-11-10",true]
["2026-11-11","Veterans Day","US","2026-11-09",true]
["2027-11-11","Veterans Day","US","2027-11-08",true]
["2028-11-11","Veterans Day","US","2028-11-06",false]
["2029-11-11","Veterans Day","US","2029-11-05",false]
["2030-11-11","Veterans Day","US","2030-11-11",true]
["2018-12-26","Boxing Day","UK","2018-12-24",true]
["2019-12-26","Boxing Day","UK","2019-12-23",true]
["2020-12-26","Boxing Day","UK","2020-12-21",false]
["2021-12-26","Boxing Day","UK","2021-12-20",false]
["2022-12-26","Boxing Day","UK","2022-12-26",true]
["2023-12-26","Boxing Day","UK","2023-12-25",true]
["2024-12-26","Boxing Day","UK","2024-12-23",true]
["2025-12-26","Boxing Day","UK","2025-12-22",true]
["2026-12-26","Boxing Day","UK","2026-12-21",false]
["2027-12-26","Boxing Day","UK","2027-12-20",false]
["2028-12-26","Boxing Day","UK","2028-12-25",true]
["2029-12-26","Boxing Day","UK","2029-12-24",true]
["2030-12-26","Boxing Day","UK","2030-12-23",true]
["2018-03-30","Good Friday","UK","2018-03-26",true]
[{"$f":"IF(AND(YEAR(A171)+1>1900,YEAR(A171)+1<2199),ROUND(DATE(YEAR(A171)+1,4,1)/7+MOD(19*MOD(YEAR(A171)+1,19)-7,30)*0.14,0)*7-6-2,\"\")","v":"2019-04-19"},"Good Friday","UK","2019-04-15",true]
["2020-04-10","Good Friday","UK","2020-04-06",true]
["2021-04-02","Good Friday","UK","2021-03-29",true]
["2022-04-15","Good Friday","UK","2022-04-11",true]
["2023-04-07","Good Friday","UK","2023-04-03",true]
["2024-03-29","Good Friday","UK","2024-03-25",true]
["2025-04-18","Good Friday","UK","2025-04-14",true]
["2026-04-03","Good Friday","UK","2026-03-30",true]
["2027-03-26","Good Friday","UK","2027-03-22",true]
["2028-04-14","Good Friday","UK","2028-04-10",true]
["2029-03-30","Good Friday","UK","2029-03-26",true]
["2030-04-19","Good Friday","UK","2030-04-15",true]
["2018-04-02","Easter Monday","UK","2018-04-02",true]
[{"$f":"IF(AND(YEAR(A184)+1>1900,YEAR(A184)+1<2199),ROUND(DATE(YEAR(A184)+1,4,1)/7+MOD(19*MOD(YEAR(A184)+1,19)-7,30)*0.14,0)*7-6+1,\"\")","v":"2019-04-22"},"Easter Monday","UK","2019-04-22",true]
["2020-04-13","Easter Monday","UK","2020-04-13",true]
["2021-04-05","Easter Monday","UK","2021-04-05",true]
["2022-04-18","Easter Monday","UK","2022-04-18",true]
["2023-04-10","Easter Monday","UK","2023-04-10",true]
["2024-04-01","Easter Monday","UK","2024-04-01",true]
["2025-04-21","Easter Monday","UK","2025-04-21",true]
["2026-04-06","Easter Monday","UK","2026-04-06",true]
["2027-03-29","Easter Monday","UK","2027-03-29",true]
["2028-04-17","Easter Monday","UK","2028-04-17",true]
["2029-04-02","Easter Monday","UK",{"$f":"A195-WEEKDAY(A195,2)+1","v":"2029-04-02"},{"$f":"WEEKDAY(A195,2)<6","v":true}]
["2030-04-22","Easter Monday","UK","2030-04-22",true]
["2018-05-07","Early May Bank Holiday","UK","2018-05-07",true]
["2019-05-06","Early May Bank Holiday","UK","2019-05-06",true]
["2020-05-04","Early May Bank Holiday","UK","2020-05-04",true]
["2021-05-03","Early May Bank Holiday","UK","2021-05-03",true]
["2022-05-02","Early May Bank Holiday","UK","2022-05-02",true]
["2023-05-01","Early May Bank Holiday","UK","2023-05-01",true]
["2024-05-06","Early May Bank Holiday","UK","2024-05-06",true]
["2025-05-05","Early May Bank Holiday","UK","2025-05-05",true]
["2026-05-04","Early May Bank Holiday","UK","2026-05-04",true]
["2027-05-03","Early May Bank Holiday","UK","2027-05-03",true]
["2028-05-01","Early May Bank Holiday","UK","2028-05-01",true]
["2029-05-07","Early May Bank Holiday","UK","2029-05-07",true]
["2030-05-06","Early May Bank Holiday","UK","2030-05-06",true]
["2018-05-28","Spring Bank Holiday","UK","2018-05-28",true]
["2019-05-27","Spring Bank Holiday","UK","2019-05-27",true]
["2020-05-25","Spring Bank Holiday","UK","2020-05-25",true]
["2021-05-31","Spring Bank Holiday","UK","2021-05-31",true]
["2022-05-30","Spring Bank Holiday","UK","2022-05-30",true]
["2023-05-29","Spring Bank Holiday","UK","2023-05-29",true]
["2024-05-27","Spring Bank Holiday","UK","2024-05-27",true]
["2025-05-26","Spring Bank Holiday","UK","2025-05-26",true]
["2026-05-25","Spring Bank Holiday","UK","2026-05-25",true]
["2027-05-31","Spring Bank Holiday","UK","2027-05-31",true]
["2028-05-29","Spring Bank Holiday","UK","2028-05-29",true]
["2029-05-28","Spring Bank Holiday","UK","2029-05-28",true]
["2030-05-27","Spring Bank Holiday","UK","2030-05-27",true]
["2018-08-06","Summer Bank Holiday","UK","2018-08-06",true]
["2019-08-05","Summer Bank Holiday","UK","2019-08-05",true]
["2020-08-03","Summer Bank Holiday","UK","2020-08-03",true]
["2021-08-02","Summer Bank Holiday","UK","2021-08-02",true]
["2022-08-01","Summer Bank Holiday","UK","2022-08-01",true]
["2023-08-07","Summer Bank Holiday","UK","2023-08-07",true]
["2024-08-05","Summer Bank Holiday","UK","2024-08-05",true]
["2025-08-04","Summer Bank Holiday","UK","2025-08-04",true]
["2026-08-03","Summer Bank Holiday","UK","2026-08-03",true]
["2027-08-02","Summer Bank Holiday","UK","2027-08-02",true]
["2028-08-07","Summer Bank Holiday","UK","2028-08-07",true]
["2029-08-06","Summer Bank Holiday","UK","2029-08-06",true]
["2030-08-05","Summer Bank Holiday","UK","2030-08-05",true]
["2018-08-27","Late Summer Bank Holiday","UK","2018-08-27",true]
["2019-08-26","Late Summer Bank Holiday","UK","2019-08-26",true]
["2020-08-31","Late Summer Bank Holiday","UK","2020-08-31",true]
["2021-08-30","Late Summer Bank Holiday","UK","2021-08-30",true]
["2022-08-29","Late Summer Bank Holiday","UK","2022-08-29",true]
["2023-08-28","Late Summer Bank Holiday","UK","2023-08-28",true]
["2024-08-26","Late Summer Bank Holiday","UK","2024-08-26",true]
["2025-08-25","Late Summer Bank Holiday","UK","2025-08-25",true]
["2026-08-31","Late Summer Bank Holiday","UK","2026-08-31",true]
["2027-08-30","Late Summer Bank Holiday","UK","2027-08-30",true]
["2028-08-28","Late Summer Bank Holiday","UK","2028-08-28",true]
["2029-08-27","Late Summer Bank Holiday","UK","2029-08-27",true]
["2030-08-26","Late Summer Bank Holiday","UK","2030-08-26",true]

{"sheet":"Help","index":5,"n_rows":200,"n_cols":1,"rows_kept":200,"cut":false,"hidden":false,"merged":[]}
[]
["How to Use The Team Planner for Excel"]
[]
["Note: The first version of the planner sheet is generated using the input parameters you provide in the steps below. This is why you don't see the planner sheet when opening this file for the first time. Just follow the steps described below."]
[]
["Step 1: Maintain your team members"]
[]
["In the InputSheet tab, enter your team members into column A. In the capacity column (B), enter their maximum capacity (hours per week):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 2: Enter projects and tasks"]
[]
["Enter all the projects and tasks your team members are working on (or may be working on in the future)."]
["You can add more projects or tasks later on."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 3: Assign team members to projects and tasks"]
[]
["In the Assignment box of the InputSheet, you need to maintain for each team member the projects or tasks they are working on."]
["The assignments can be changed later on."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 4: Enter start date for, number of weeks to show and country"]
[]
["Monday of week 1: The date field must be the Monday's date for the week that your planner should start with"]
["Number of weeks: number of weeks that should be shown in the planning sheet (you can add further weeks later on)"]
["Country: Enter either US/UK to account for the public holidays in the US/UK. For other countries, please maintain tab \"Holidays\" first"]
["FTE / month: What is the average hours for an FTE per month? The default is 172 hours. This value is used for the calculation of \"Available FTE\" in the Planning Sheet\""]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 5: Generate Planning Sheet"]
[]
["Once you have made all inputs, press the green button \"Generate Planning Sheet\". This will create the team planner overview based on your inputs."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Step 6: Open the Planning Sheet and start maintaining efforts"]
[]
["Open the tab \"Planning Sheet\" which should now be visible."]
[]
["Now you can maintain the estimated efforts (in hours) for each team member and project or task assigned:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The planner will calculate the \"Available FTE\" based on the number of team members you have entered and the total average FTE hours per month."]
[]
["The summarized hours appear in color coding: \nwhite = actual workload = # of workdays in week * 8\ngreen = actual hours < # of workdays in week * 8\nred =actual hours > # of workdays in week * 8\n\nThis designation is done with respect to the available working days in a given week."]
[]
[]
["Modifying the Planning Sheet"]
["Adding new team members, assigning new tasks to team members, deleting team members and adding new columns (weeks) on the timeline view must be done using the colored buttons."]
[]
[]
[]
[]
[]
["Adding a new task to a team member: "]
["To assign a new task to a team member, first select the \"Total\" cell of the employee to whom you want to assign a new task. An example of a total cell are shown below:"]
[]
[]
[]
[]
[]
[]
["In this case we would add a task for Lillian Nelson."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Add a new team member:"]
["If you click this button, the Excel will ask you for the team member's name and their maximum capacity (in hours per week)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["You'll be asked for the number of tasks to assign. This creates the required number of rows:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Enter the maximum capacity of the employee (hours per week, e.g. 40):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Add a new column (to the timeline):"]
[]
[]
["To extend the timeline of your team planner, press the \"Add new column\" button. This will add another week at the planning sheet (scroll to the right to see the result)"]
[]
[]
["Delete team member:"]
[]
["In case you want to remove a team member from the planner, select the total cell of the employee and press the button \"Delete member\"."]
[]
["  Select \"Total\" cell:"]
[]
[]
[]
[]
[]
[]
[]
["Press button \"Delete member\":"]
[]
[]
[]
[]
["The team member will be removed from all views, including the utilization report."]