{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sheet8","Tags","Resources","Documents","Fields","FOCD Helper","Data Types","Log"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":14,"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":1,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet8","index":0,"n_rows":795,"n_cols":4,"rows_kept":795,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"ProjList",null,"ProjList"]
[null,"ProjList",null,"ProjList"]
[null,"ProjList",null,"General"]
[null,"ProjList",null,"Sched"]
[null,"ProjList",null,"ResList"]
[null,"ProjList",null,"StdTasks"]
[null,"General",null,"NewBars"]
[null,"General",null,"NA"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"ResList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ResList"]
[null,"ResList"]
[null,"Sched"]
[null,"Sched"]
[null,"General"]
[null,"General"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"General"]
[null,"General"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ResList"]
[null,"ResList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"Sched"]
[null,"StdTasks"]
[null,"StdTasks"]
[null,"StdTasks"]
[null,"StdTasks"]
[null,"StdTasks"]
[null,"StdTasks"]
[null,"NewBars"]
[null,"General"]
[null,"NewBars"]
[null,"NewBars"]
[null,"NewBars"]
[null,"NewBars"]
[null,"NewBars"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"NewBars"]
[null,"ResList"]
[null,"ResList"]
[null,"ResList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"General"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ProjList"]
[null,"ResList"]
[null,"ResList"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]
[null,"NA"]

{"sheet":"Tags","index":1,"n_rows":750,"n_cols":13,"rows_kept":750,"cut":false,"hidden":false,"merged":[]}
["tbTagID","tbTagGroup","tbTagName","tbTagEntity","tbTagPopular","tbTagNameShort","tbTagPurpose","tbTagDescription","tbTagOwner","tbTagSortOrder","tbTagCustomerID","tbTagAzureID","tbTagLastModified"]
["Complete list of tag values for Pick Lists (each group represents a Pick List)"]
["TagID","Tag Group","Tag Name","Entity","Popularity","Tag Name Short","Tag Purpose","Tag Description","Tag Owner","Tag Sort Order","Tag Cust ID","Tag Ext ID","Tag Last Modified"]
[1,"Business Advisors","Mike Ba","ProjList","ProjList","Mike Ba","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[2,"Business Advisors","Joe Ba","ProjList","ProjList","Joe Ba","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[3,"Business Advisors","Sally Ba","ProjList","ProjList","Sally Ba","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[4,"Business Owners","Joe Bo","ProjList","ProjList","Joe Bo","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[5,"Business Owners","Sam bo","ProjList","ProjList","Sam bo","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[6,"Business Owners","Julia bo","ProjList","ProjList","Julia bo","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[7,"Calendar",8,"General","General",8,"defining working calendar in hours per day on this Timebar ","NA","System",0,44,"a0","2020-01-31"]
[8,"Calendar",7.5,"General","General",7.5,"defining working calendar in hours per day on this Timebar ","NA","System",0,44,"a0","2020-01-31"]
[9,"Category","Risk-based","General","Sched","Risk-based","use for any means to categorize timebars for custom reporting","NA","PMO",0,44,"a0","2020-01-31"]
[10,"Category","Operational","General","Sched","Operational","use for any means to categorize timebars for custom reporting","NA","PMO",0,44,"a0","2020-01-31"]
[11,"Category","Corporate","General","Sched","Corporate","use for any means to categorize timebars for custom reporting","NA","PMO",0,44,"a0","2020-01-31"]
[12,"Category","Core","General","Sched","Core","use for any means to categorize timebars for custom reporting","NA","PMO",0,44,"a0","2020-01-31"]
[13,"Contact","Jim","General","Sched","Jim","Person name and address to contact for questions regarding Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[14,"Contact","George","General","Sched","George","Person name and address to contact for questions regarding Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[15,"Cost Code","A5645","ResList","ResList","A5645","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[16,"Delivery Managers","Jim Dm","ProjList","ProjList","Jim Dm","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[17,"Delivery Managers","Al dm","ProjList","ProjList","Al dm","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[18,"Department","Sales and Marketing","General","Sched","Marketing","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[19,"Department","Engineering","General","Sched","Engineering","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[20,"Department","Manufacturing","General","Sched","BTS","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[21,"Department","Procurement","General","Sched","Insurance","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[22,"Department","Business Development","General","Sched","BD","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[23,"Department","Research and Development","General","Sched","S&!","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[24,"Department","Enterprise Services","General","Sched","ERM","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[25,"Department","Finance","General","Sched","Finance","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[26,"Department","Human Resources","General","Sched","HR","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[27,"Department","Product Management","General","Sched","F&I","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[28,"Department","Information Technology","General","Sched","CA","Define what area of the business is responsible for Timebar","NA","PMO",0,44,"a0","2020-01-31"]
[29,"Document Purpose","Project Charter","General","General","NA","for tagging documents","NA","PMO",0,44,"a0","2020-01-31"]
[30,"Document Purpose","Business Case","General","General","NA","for tagging documents","NA","PMO",0,44,"a0","2020-01-31"]
[31,"Document Purpose","Approval Document","General","General","NA","for tagging documents","NA","PMO",0,44,"a0","2020-01-31"]
[32,"Document Purpose","Gate Help","General","General","NA","Key for the Help pages on Gating forms","NA","System",0,44,"a0","2020-01-31"]
[33,"Document Purpose","Timebar Help","General","General","NA","Key for pages appearing on help accordions","NA","System",0,44,"a0","2020-01-31"]
[34,"Document Purpose","Main Page","General","General","NA","To identify web pages in marketing site","NA","System",0,44,"a0","2020-01-31"]
[35,"Document Purpose","Marketing Page","General","General","NA","To identify web pages in marketing site","NA","System",0,44,"a0","2020-01-31"]
[36,"Document Purpose","Contact Us Page","General","General","NA","To identify web pages in marketing site","NA","System",0,44,"a0","2020-01-31"]
[37,"Document Purpose","Kanban Help","General","General","NA","Key for pages appearing on help accordions","NA","PMO",0,44,"a0","2020-01-31"]
[38,"Document Purpose","Common Help","General","General","NA","Key for pages appearing on help accordions","NA","PMO",0,44,"a0","2020-01-31"]
[39,"Document Purpose","General Web Page","General","General","NA","To identify web pages","NA","PMO",0,44,"a0","2020-01-31"]
[40,"Document Status","Approved","General","General","NA","for tagging documents","NA","PMO",0,44,"a0","2020-01-31"]
[41,"Document Status","First Draft","General","General","NA","for tagging documents","NA","PMO",0,44,"a0","2020-01-31"]
[42,"Document Status","In Progress","General","General","NA","for tagging documents","NA","PMO",0,44,"a0","2020-01-31"]
[43,"Document Status","Canceled","General","General","NA","for tagging documents","NA","PMO",0,44,"a0","2020-01-31"]
[44,"Document Type","HTML","General","General","NA","for tagging documents","NA","PMO",0,44,"a0","2020-01-31"]
[45,"Document Type","MS Word","General","General","NA","for tagging documents","NA","PMO",0,44,"a0","2020-01-31"]
[46,"Document Type","PDF","General","General","NA","for tagging documents","NA","PMO",0,44,"a0","2020-01-31"]
[47,"Estimation Class","Class A","ProjList","ProjList","Class A","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[48,"Estimation Class","Class B","ProjList","ProjList","Class B","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[49,"Estimation Class","Class C","ProjList","ProjList","Class C","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[50,"ExpectedHoursPerWeek",5,"ResList","ResList",5,"Use for estimating work needs","NA","PMO",0,44,"a0","2020-01-31"]
[51,"ExpectedHoursPerWeek",10,"ResList","ResList",10,"Use for estimating work needs","NA","PMO",0,44,"a0","2020-01-31"]
[52,"ExSponsor","Ally","General","Sched","Ally","List out your Executive Sponsors","NA","PMO",0,44,"a0","2020-01-31"]
[53,"ExSponsor","Mike","General","Sched","Mike","List out your Executive Sponsors","NA","PMO",0,44,"a0","2020-01-31"]
[54,"ExtSystemResID","456M23","ResList","General","456M23","Use to tie into exsiting systems in the organization","NA","PMO",0,44,"a0","2020-01-31"]
[55,"ExtSystemResID","456M24","ResList","General","456M24","Use to tie into exsiting systems in the organization","NA","PMO",0,44,"a0","2020-01-31"]
[56,"Gates Large","Gate 1 Strategic assessment and concept","ProjList","ProjList","Concept","To confirm the project's objectives, both what is to be done and why; and to identify key stakeholders.","NA","System",0,44,"a0","2020-01-31"]
[57,"Gates Large","Gate 2 Project approach","ProjList","ProjList","Approach","To confirm that the approach selected to address the business problem or opportunity is both feasible and appropriate.","NA","System",0,44,"a0","2020-01-31"]
[58,"Gates Large","Gate 3 Business case and general readiness","ProjList","ProjList","Business Case","To confirm that the business case is sufficiently compelling to justify, sustain and guide the project; to identify any shortcomings in readiness for action before approval; and to confirm that key identified risks can be managed.","NA","System",0,44,"a0","2020-01-31"]
[59,"Gates Large","Gate 4 Project charter and project management plan (PMP)","ProjList","ProjList","Project Charter","To ensure that the resources, support and governance necessary for successful execution are in place prior to construction and implementation.","NA","System",0,44,"a0","2020-01-31"]
[60,"Gates Large","Gate 5 Detailed project plan and functional specifications","ProjList","ProjList","Detail Plan","To confirm the completeness and feasibility of the detailed project plan; and to confirm the definition of requirements.","NA","System",0,44,"a0","2020-01-31"]
[61,"Gates Large","Gate 6 Construction complete and deployment readiness","ProjList","ProjList","Construction&Deployment","To confirm the project is fully prepared for successful deployment.","NA","System",0,44,"a0","2020-01-31"]
[62,"Gates Large","Gate 7 Post-implementation review","ProjList","ProjList","Post Implementation","To confirm completion, assess the extent to which the project has achieved its goals, and provide an assessment of value for money.","NA","System",0,44,"a0","2020-01-31"]
[63,"Gates Medium","Gate 1 Project approach","ProjList","ProjList","Approach","To confirm that the approach selected to address the business problem or opportunity is both feasible and appropriate.","NA","System",0,44,"a0","2020-01-31"]
[64,"Gates Medium","Gate 2 Business case and general readiness","ProjList","ProjList","Business Case","To confirm that the business case is sufficiently compelling to justify, sustain and guide the project; to identify any shortcomings in readiness for action before approval; and to confirm that key identified risks can be managed.","NA","System",0,44,"a0","2020-01-31"]
[65,"Gates Medium","Gate 3 Pre-Construction","ProjList","ProjList","Pre-Construction","To ensure that the resources, support and governance necessary for successful execution are in place prior to deployment","NA","System",0,44,"a0","2020-01-31"]
[66,"Gates Medium","Gate 4 Pre-Deployment","ProjList","ProjList","Pre-Deployment","To ensure that the resources, support and governance necessary for successful execution are in place prior to construction","NA","System",0,44,"a0","2020-01-31"]
[67,"Gates Medium","Gate 5 Post Implementation","ProjList","ProjList","Post Implementation","To confirm completion, assess the extent to which the project has achieved its goals, and provide an assessment of value for money.","NA","System",0,44,"a0","2020-01-31"]
[68,"Gates Release","1 Approved to Design","ProjList","ProjList","1 Approved to Design","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[69,"Gates Release","2 Approved to Develop","ProjList","ProjList","2 Approved to Develop","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[70,"Gates Release","3 Approved to Implement","ProjList","ProjList","3 Approved to Implement","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[71,"Gates Small","Gate 1 Business Case","ProjList","ProjList","Business Case","To confirm that the business case is sufficiently compelling to justify, sustain and guide the project; to identify any shortcomings in readiness for action before approval; and to confirm that key identified risks can be managed.","NA","System",0,44,"a0","2020-01-31"]
[72,"Gates Small","Gate 2 Pre-Construction","ProjList","ProjList","Pre-Construction","To ensure that the resources, support and governance necessary for successful execution are in place prior to deployment","NA","System",0,44,"a0","2020-01-31"]
[73,"Gates Small","Gate 3 Post-implementation review","ProjList","ProjList","Post Implementation","To confirm completion, assess the extent to which the project has achieved its goals, and provide an assessment of value for money.","NA","System",0,44,"a0","2020-01-31"]
[74,"Health","On schedule","General","Sched","On schedule","For Dashboard indicators","NA","PMO",0,44,"a0","2020-01-31"]
[75,"Health","Early","General","Sched","Early","For Dashboard indicators","NA","PMO",0,44,"a0","2020-01-31"]
[76,"Health","Slipping","General","Sched","Slipping","For Dashboard indicators","NA","PMO",0,44,"a0","2020-01-31"]
[77,"Health","Late","General","Sched","Late","For Dashboard indicators","NA","PMO",0,44,"a0","2020-01-31"]
[78,"Health","Blocked","General","Sched","Blocked","For Dashboard indicators","NA","PMO",0,44,"a0","2020-01-31"]
[79,"Health","Completed","General","Sched","Completed","For Dashboard indicators","NA","PMO",0,44,"a0","2020-01-31"]
[80,"Health","Attention","General","Sched","Attention","For Dashboard indicators","NA","PMO",0,44,"a0","2020-01-31"]
[81,"Health Indicators","Green","ProjList","ProjList","Green","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[82,"Health Indicators","Yellow","ProjList","ProjList","Yellow","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[83,"Health Indicators","Red","ProjList","ProjList","Red","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[84,"HyperLinks","Link 1","ProjList","General","Link 1","for manually storing hyperlink to external info.","NA","PMO",0,44,"a0","2020-01-31"]
[85,"HyperLinks","Link 2","ProjList","General","Link 2","for manually storing hyperlink to external info.","NA","PMO",0,44,"a0","2020-01-31"]
[86,"Investment Category","IT Platform","ProjList","ProjList","IT Platform","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[87,"Investment Category","Office Environment","ProjList","ProjList","Office Environment","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[88,"Investment Category","Business Support","ProjList","ProjList","Business Support","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[89,"Investment Category","Engineering Tools","ProjList","ProjList","Engineering Tools","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[90,"Investment Category","Core Products","ProjList","ProjList","Core Products","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[91,"Investment Category","Innovation","ProjList","ProjList","Innovation","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[92,"Investment Initiative","Improve product reliability","ProjList","ProjList","Improve product reliability","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[93,"Investment Initiative","Cross-sell our Network Device products","ProjList","ProjList","Cross-sell our Network Device products","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[94,"Investment Initiative","Engineering Tool Innovation","ProjList","ProjList","Engineering Tool Innovation","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[95,"Investment Initiative","Faster response to new business opportunities","ProjList","ProjList","Faster response to new business opportunities","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[96,"Investment Initiative","Source Cloud services for our Core products","ProjList","ProjList","Source Cloud services for our Core products","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[97,"Investment Initiative","Support moden digital workplace","ProjList","ProjList","Support moden digital workplace","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[98,"Investment Initiative","Improve Employee Skills","ProjList","ProjList","Improve Employee Skills","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[99,"Investment Initiative","Improve productivity with Agile Teams","ProjList","ProjList","Improve productivity with Agile Teams","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[100,"Investment Objective","Run the Business","ProjList","ProjList","Run the Business","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[101,"Investment Objective","Grow the Business","ProjList","ProjList","Grow the Business","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[102,"Investment Objective","Transform the Business","ProjList","ProjList","Transform the Business","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[103,"Investment Strategy","Server more customers","ProjList","ProjList","Server more customers","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[104,"Investment Strategy","Best in market core products","ProjList","ProjList","Best in market core products","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[105,"Investment Strategy","Increase revenue","ProjList","ProjList","Increase revenue","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[106,"Investment Strategy","Increase share of market","ProjList","ProjList","Increase share of market","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[107,"Investment Strategy","Ensure compliance","ProjList","ProjList","Ensure compliance","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[108,"Investment Strategy","Attract and retain the best people","ProjList","ProjList","Attract and retain the best people","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[109,"Investment Strategy","Improve and maintain workplace safety","ProjList","ProjList","Improve and maintain workplace safety","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[110,"Investment Strategy","Reduce waste","ProjList","ProjList","Reduce waste","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[111,"Investment Strategy","Improve customer service","ProjList","ProjList","Improve customer service","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[112,"L1","TopLevel","ProjList","General","TopLevel","Can use to make custom hierarchy","NA","System",0,44,"a0","2020-01-31"]
[113,"L2","Next Level Down","ProjList","General","Next Level Down","Can use to make custom hierarchy","NA","System",0,44,"a0","2020-01-31"]
[114,"L3","Third Level Down","ProjList","General","Third Level Down","Can use to make custom hierarchy","NA","System",0,44,"a0","2020-01-31"]
[115,"Labour Type","External","ResList","ResList","External","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[116,"Labour Type","Internal","ResList","ResList","Internal","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[117,"Labour Type","Contract","ResList","ResList","Contract","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[118,"Lifecycle Phase","1 Pre-execution (evaluation and selection)","ProjList","ProjList","1 Pre-execution (evaluation and selection)","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[119,"Lifecycle Phase","2 Execution (gating approvals)","ProjList","ProjList","2 Execution (gating approvals)","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[120,"Lifecycle Phase","3 Closing (outcome analysis)","ProjList","ProjList","3 Closing (outcome analysis)","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[121,"Location","Ottawa","General","ResList","Ottawa","Where is resource located","NA","PMO",0,44,"a0","2020-01-31"]
[122,"Location","Gatineau","General","ResList","Gatineau","Where is resource located","NA","PMO",0,44,"a0","2020-01-31"]
[123,"Non Project Tag","No","ProjList","ProjList","No","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[124,"Non Project Tag","Yes","ProjList","ProjList","Yes","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[125,"OOM Estimates","0 to 100K","ProjList","ProjList","0 to 100K","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[126,"OOM Estimates","1001K to 5000K","ProjList","ProjList","1001K to 5000K","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[127,"OOM Estimates","101K to 300K","ProjList","ProjList","101K to 300K","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[128,"OOM Estimates","301K to 1000K","ProjList","ProjList","301K to 1000K","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[129,"OOM Estimates","1000K Plus","ProjList","ProjList","1000K Plus","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[130,"Organizational Manager","Kent Om","ProjList","ProjList","Kent Om","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[131,"Organizational Manager","Perry Om","ProjList","ProjList","Perry Om","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[132,"Parttime Fulltime","Full Time","ResList","ResList","Full Time","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[133,"Parttime Fulltime","Part Time","ResList","ResList","Part Time","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[134,"PartTimeFullTime","FullTime","ResList","ResList","FullTime","Resource is a full time person or a part time person such as contractor","NA","HR",0,44,"a0","2020-01-31"]
[135,"PartTimeFullTime","PartTime","ResList","ResList","PartTime","Resource is a full time person or a part time person such as contractor","NA","HR",0,44,"a0","2020-01-31"]
[136,"PartTimeFullTime","Unknown","ResList","ResList","Unknown","Resource is a full time person or a part time person such as contractor","NA","HR",0,44,"a0","2020-01-31"]
[137,"PercentTimeAllocated",10,"ResList","ResList",10,"Main tool to use to estimate timebar work","NA","PMO",0,44,"a0","2020-01-31"]
[138,"PercentTimeAllocated",25,"ResList","ResList",25,"Main tool to use to estimate timebar work","NA","PMO",0,44,"a0","2020-01-31"]
[139,"PercentTimeAllocated",50,"ResList","ResList",50,"Main tool to use to estimate timebar work","NA","PMO",0,44,"a0","2020-01-31"]
[140,"PercentTimeAllocated",75,"ResList","ResList",75,"Main tool to use to estimate timebar work","NA","PMO",0,44,"a0","2020-01-31"]
[141,"PercentTimeAllocated",100,"ResList","ResList",100,"Main tool to use to estimate timebar work","NA","PMO",0,44,"a0","2020-01-31"]
[142,"Percent Available",10,"ResList","ResList",10,"For taggin an allocation for resource management","NA","PMO",0,44,"a0","2020-01-31"]
[143,"Percent Available",25,"ResList","ResList",25,"For taggin an allocation for resource management","NA","PMO",0,44,"a0","2020-01-31"]
[144,"Percent Available",50,"ResList","ResList",50,"For taggin an allocation for resource management","NA","PMO",0,44,"a0","2020-01-31"]
[145,"Percent Available",75,"ResList","ResList",75,"For taggin an allocation for resource management","NA","PMO",0,44,"a0","2020-01-31"]
[146,"Percent Available",100,"ResList","ResList",100,"For taggin an allocation for resource management","NA","PMO",0,44,"a0","2020-01-31"]
[147,"Phase","Opening","General","Sched",null,null,"NA","PMO",0,44,"a0","2020-01-31"]
[148,"Phase","Executing","General","Sched",null,null,"NA","PMO",0,44,"a0","2020-01-31"]
[149,"Phase","Closing","General","Sched",null,null,"NA","PMO",0,44,"a0","2020-01-31"]
[151,"Portfolios","R&D New Technology","ProjList","ProjList","R&D New Technology","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[152,"Portfolios","Core Product Delivery","ProjList","ProjList","Core Product Delivery","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[153,"Portfolios","Business Support Systems","ProjList","ProjList","Business Support Systems","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[154,"Portfolios","IT Platform","ProjList","ProjList","IT Platform","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[155,"Portfolios","Building Services","ProjList","ProjList","Building Services","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[156,"Primary Contact","Ben Pc","ProjList","ProjList","Ben Pc","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[157,"Primary Contact","Sam Pc","ProjList","ProjList","Sam Pc","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[158,"Primary Contact","Dave Pc","ProjList","ProjList","Dave Pc","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[159,"Primary LOB","Finance","ProjList","ProjList","Finance","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[160,"Primary LOB","Research and Development","ProjList","ProjList","Research and Development","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[161,"Primary LOB","Business Development","ProjList","ProjList","Business Development","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[162,"Primary LOB","Corporate Affairs","ProjList","ProjList","Corporate Affairs","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[163,"Primary LOB","Business Technology Solutions","ProjList","ProjList","Business Technology Solutions","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[164,"Primary LOB","Engineering and Product Delivery","ProjList","ProjList","Engineering and Product Delivery","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[165,"Primary LOB","Human Resources","ProjList","ProjList","Human Resources","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[166,"Primary Skill","Inventing","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[167,"Primary Skill","HR Policies","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[168,"Primary Skill","Finance Policies","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[169,"Primary Skill","Procurement","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[170,"Primary Skill","Project Management","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[171,"Primary Skill","IT Architecture","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[172,"Primary Skill","Azure and AWS","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[173,"Primary Skill","Enterprise Architect","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[174,"Primary Skill","Coder","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[175,"Primary Skill","HTML 5 CSS Javascript","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[176,"Primary Skill","MS SQL and Oracle","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[177,"Primary Skill","SAP","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[178,"Primary Skill","Testing","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[179,"Primary Skill","Testing","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[180,"Primary Skill","Radio Design","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[181,"Primary Skill","Board Design","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[182,"Primary Skill","Antenna Design","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[183,"Primary Skill","Tower Design","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,"a0","2020-01-31"]
[184,"Primary Strategic Priority","High","ProjList","ProjList","Improve intiitative visibility","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[185,"Primary Strategic Priority","Medium","ProjList","ProjList","Reduce complexity of process","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[186,"Primary Strategic Priority","Low","ProjList","ProjList","Fewer meetings","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[187,"Priority","High","General","Sched","High","Set timebar priority","NA","PMO",0,44,"a0","2020-01-31"]
[188,"Priority","Medium","General","Sched","Med","Set timebar priority","NA","PMO",0,44,"a0","2020-01-31"]
[189,"Priority","Low","General","Sched","Low","Set timebar priority","NA","PMO",0,44,"a0","2020-01-31"]
[190,"Product","ModelA","General","Sched","ModelA","If this timebar is for creating a product, use this tag","NA","PMO",0,44,"a0","2020-01-31"]
[191,"Product","ModelT","General","Sched","ModelT","If this timebar is for creating a product, use this tag","NA","PMO",0,44,"a0","2020-01-31"]
[192,"Program Activity Alignment (PAA)","1 1 Program: Common One-Benefit service for all Canadians","ProjList","ProjList",null,"Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[193,"Program Activity Alignment (PAA)","1 1 1 Sub-Program: One Canada wide monthly payment  to each Canadian","ProjList","ProjList",null,"Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[194,"Program Activity Alignment (PAA)","1 1 1 1 Sub-Sub-Program: Banks support of One-Benefit distribution","ProjList","ProjList",null,"Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[195,"Program Activity Alignment (PAA)","1 1 1 2 Sub-Sub-Program: Tax System changes to suit new One-Benefit.","ProjList","ProjList",null,"Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[196,"Programs","SAP System Upgrade","ProjList","ProjList","SAP System Upgrade","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[197,"Programs","Building and Office Modernization","ProjList","ProjList","Building and Office Modernization","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[198,"Programs","Centralized Billing and Receivables","ProjList","ProjList","Centralized Billing and Receivables","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[199,"Programs","Continuous Improvement Transformation","ProjList","ProjList","Continuous Improvement Transformation","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[200,"Programs","ERP Transformation","ProjList","ProjList","ERP Transformation","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[201,"Programs","Information Solutions Resiliency","ProjList","ProjList","Information Solutions Resiliency","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[202,"Programs","SharePoint 2016 Upgrade","ProjList","ProjList","SharePoint 2016 Upgrade","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[203,"Programs","Business Continuity Management Program","ProjList","ProjList","Business Continuity Management Program","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[204,"Programs","TBS Compliance","ProjList","ProjList","TBS Compliance","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[205,"Programs","Digital Workplace - Transformation","ProjList","ProjList","Digital Workplace - Transformation","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[206,"Programs","Ticketing System and Requirements Management","ProjList","ProjList","Ticketing System and Requirements Management","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[207,"Programs","Continuous Internal Delivery Enablement","ProjList","ProjList","Continuous Internal Delivery Enablement","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[208,"Programs","HR Service Delivery","ProjList","ProjList","HR Service Delivery","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[209,"Programs","Market Information Management","ProjList","ProjList","Market Information Management","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[210,"Programs","IM Policy and Guidelines","ProjList","ProjList","IM Policy and Guidelines","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[211,"Programs","Core Operations Program","ProjList","ProjList","Core Operations Program","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[212,"Programs","Integration API Development Program","ProjList","ProjList","Integration API Development Program","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[213,"Programs","NA","ProjList","ProjList","NA","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[214,"Programs","Standalone Project with No Program","ProjList","ProjList","Standalone Project with No Program","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[215,"Programs","Infrastructure as a Service (IaaS) Program","ProjList","ProjList","Infrastructure as a Service (IaaS) Program","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[216,"Project Managers","PM011","ProjList","ProjList","PM011","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[217,"Project Managers","Jim Pm","ProjList","ProjList","Jim Pm","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[218,"Project Managers","Al PM","ProjList","ProjList","Al PM","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[219,"Project Status","Active","ProjList","ProjList","Active","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[220,"Project Status","On-Hold","ProjList","ProjList","On-Hold","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[221,"Project Status","Canceled","ProjList","ProjList","Canceled","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[222,"ProjectManager","Sam","General","Sched","Sam","List out your PM's","NA","PMO",0,44,"a0","2020-01-31"]
[223,"ProjectManager","Ralph","General","Sched","Ralph","List out your PM's","NA","PMO",0,44,"a0","2020-01-31"]
[224,"ProjectNumber",15101,"General","Sched",0,"Custom numbering scheme specific to user","NA","PMO",0,44,"a0","2020-01-31"]
[225,"ProjectNumber",15201,"General","Sched",0,"Custom numbering scheme specific to user","NA","PMO",0,44,"a0","2020-01-31"]
[226,"Resource Class","Contractor","ResList","ResList","Contractor","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[227,"Resource Class","Perm","ResList","ResList","Perm","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[228,"Resource Class","Seasonal","ResList","ResList","Seasonal","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[229,"Resource Manager","Joe Rm","ResList","ResList","Joe Rm","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[230,"Resource Manager","Sally Rm","ResList","ResList","Sally Rm","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[231,"Resource Manager","Al Rm","ResList","ResList","Al Rm","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[232,"Resource Role","Product Owner/Sponsor","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[233,"Resource Role","SME HR","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[234,"Resource Role","SME Finance","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[235,"Resource Role","SME Purchasing","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[236,"Resource Role","SME PM","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[237,"Resource Role","SME IT Platforms and Datacenter","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[238,"Resource Role","SME Cloud Technologies","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[239,"Resource Role","SME Solution Architecture","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[240,"Resource Role","Developer General","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[241,"Resource Role","Developer Web","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[242,"Resource Role","Developer SQL","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[243,"Resource Role","Developer ERP System","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[244,"Resource Role","Tester New Software","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[245,"Resource Role","Tester Platforms and Datacenter","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[246,"Resource Role","Engineer RF","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[247,"Resource Role","Engineer Hardware","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[248,"Resource Role","Engineer Antennas","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[249,"Resource Role","Engineer Towers","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,"a0","2020-01-31"]
[250,"Resource Supervisor","Sam Supr","ResList","ResList","Sam Supr","Resource or person tagging","NA","PMO",0,44,"a0","2020-01-31"]
[251,"ResourceCalendar",8,"ResList","ResList",8,"For calculating wok on an Allocation","NA","PMO",0,44,"a0","2020-01-31"]
[252,"ResourceCalendar",7.5,"ResList","ResList",7.5,"For calculating wok on an Allocation","NA","PMO",0,44,"a0","2020-01-31"]
[253,"ResourceCalendar",24,"ResList","ResList",24,"For calculating wok on an Allocation","NA","PMO",0,44,"a0","2020-01-31"]
[254,"Responsibility","Jim","General","Sched","Jim","Define who is responsible for Timebar when in trouble","NA","PMO",0,44,"a0","2020-01-31"]
[255,"Responsibility","John","General","Sched","John","Define who is responsible for Timebar when in trouble","NA","PMO",0,44,"a0","2020-01-31"]
[256,"Responsibility","Sally","General","Sched","Sally","Define who is responsible for Timebar when in trouble","NA","PMO",0,44,"a0","2020-01-31"]
[257,"Responsible Teams","Accounting","ProjList","ProjList","Accounting","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[258,"Responsible Teams","Finance","ProjList","ProjList","Finance","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[259,"Responsible Teams","Procurement","ProjList","ProjList","Procurement","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[260,"Responsible Teams","Product Engineering","ProjList","ProjList","Product Engineering","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[261,"Responsible Teams","Information Technology","ProjList","ProjList","Information Technology","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[262,"Severity","Critical","General","Sched",1,"Indicates how severe a priority itme is, in terms of impact","NA","PMO",0,44,"a0","2020-01-31"]
[263,"Severity","Important","General","Sched",2,"Indicates how severe a priority itme is, in terms of impact","NA","PMO",0,44,"a0","2020-01-31"]
[264,"Severity","Normal","General","Sched",3,"Indicates how severe a priority itme is, in terms of impact","NA","PMO",0,44,"a0","2020-01-31"]
[265,"Show In Reports","Executive Dashboard","ProjList","ProjList","Executive Dashboard","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[266,"Show In Reports","PM Dashboard","ProjList","ProjList","PM Dashboard","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[267,"Show In Reports","Project Sites","ProjList","ProjList","Project Sites","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[268,"ShowIn","Dashboard","ProjList","ProjList","Dashboard","A way to control visibility of Timebar for reporting and display","NA","PMO",0,44,"a0","2020-01-31"]
[269,"ShowIn","MilesoneReport","ProjList","ProjList","MilesoneReport","A way to control visibility of Timebar for reporting and display","NA","PMO",0,44,"a0","2020-01-31"]
[270,"ShowIn","NeverShow","ProjList","ProjList","NeverShow","A way to control visibility of Timebar for reporting and display","NA","PMO",0,44,"a0","2020-01-31"]
[271,"Size","Small","ProjList","ProjList","Small","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[272,"Size","Medium","ProjList","ProjList","Medium","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[273,"Size","Large","ProjList","ProjList","Large","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[274,"Size","Release","ProjList","ProjList","Release","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[275,"Sponsoring Department","IT Department","ProjList","ProjList","IT Department","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[276,"Sponsoring Department","Customer Support Department","ProjList","ProjList","Customer Support Department","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[277,"Sponsoring Department","Presidents Office","ProjList","ProjList","Presidents Office","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[278,"Sponsors","Marsha Sp","ProjList","ProjList","Marsha Sp","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[279,"Sponsors","Sydney Sp","ProjList","ProjList","Sydney Sp","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[280,"Sponsors","Colin Sp","ProjList","ProjList","Colin Sp","Project Tagging","NA","PMO",0,44,"a0","2020-01-31"]
[281,"Stage","1 Proposed","ProjList","ProjList","Proposed","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[282,"Stage","2 Triaged","ProjList","ProjList","Triaged","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[283,"Stage","3 Prioritized","ProjList","ProjList","Prioritized","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[284,"Stage","4 Selected","ProjList","ProjList","Selected","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[285,"Stage","5 Assigned","ProjList","ProjList","Assigned","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[286,"Stage","6 Delivering","ProjList","ProjList","Delivering","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[287,"Stage","7 Delivered","ProjList","ProjList","Delivered","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[288,"Stage","8 Closed","ProjList","ProjList","Closed","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[289,"Stage (Manual)","1 Proposed","ProjList","ProjList","Proposed","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[290,"Stage (Manual)","2 Triaged","ProjList","ProjList","Triaged","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[291,"Stage (Manual)","3 Prioritized","ProjList","ProjList","Prioritized","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[292,"Stage (Manual)","4 Selected","ProjList","ProjList","Selected","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[293,"Stage (Manual)","5 Assigned","ProjList","ProjList","Assigned","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[294,"Stage (Manual)","6 Delivering","ProjList","ProjList","Delivering","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[295,"Stage (Manual)","7 Delivered","ProjList","ProjList","Delivered","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[296,"Stage (Manual)","8 Closed","ProjList","ProjList","Closed","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[297,"State","Awaiting Approval","ProjList","ProjList","Awaiting Approval","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[298,"State","Awaiting Input","ProjList","ProjList","Awaiting Input","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[299,"State","Requested Approval","ProjList","ProjList","Requested Approval","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[300,"State","Approved","ProjList","ProjList","Approved","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[301,"State","Spawned","ProjList","ProjList","Spawned","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[302,"State","Awaiting Review","ProjList","ProjList","Awaiting Review","Controlling project lifecycle workflow","NA","PMO",0,44,"a0","2020-01-31"]
[303,"Status","Pending","General","Sched","Not Started","set Timebar Status","NA","PMO",0,44,"a0","2020-01-31"]
[304,"Status","Active","General","Sched","In Progress","set Timebar Status","NA","PMO",0,44,"a0","2020-01-31"]
[305,"Status","Deployed","General","Sched","Finished","set Timebar Status","NA","PMO",0,44,"a0","2020-01-31"]
[306,"Status","Closed","General","Sched","Closed","set Timebar Status","NA","PMO",0,44,"a0","2020-01-31"]
[307,"Status","Partially Deployed","General","Sched","Archived","set Timebar Status","NA","PMO",0,44,"a0","2020-01-31"]
[308,"Status","On-Hold","General","Sched","Archived","set Timebar Status","NA","PMO",0,44,"a0","2020-01-31"]
[309,"stdTasks","Project Start","StdTasks","StdTasks","Start","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,"a0","2020-01-31"]
[310,"stdTasks","Design","StdTasks","StdTasks","Design","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,"a0","2020-01-31"]
[311,"stdTasks","Develop","StdTasks","StdTasks","Dev","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,"a0","2020-01-31"]
[312,"stdTasks","Test","StdTasks","StdTasks","Test","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,"a0","2020-01-31"]
[313,"stdTasks","UAT","StdTasks","StdTasks","UAT","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,"a0","2020-01-31"]
[314,"stdTasks","Project Finish","StdTasks","StdTasks","Finish","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,"a0","2020-01-31"]
[315,"tbType","Portfolio","NewBars","NewBars","Pf","Drag and Drop on Canvas to create new Portfolio","NA","system",0,44,"a0","2020-01-31"]
[316,"tbType","Program","NewBars","General","Prog","Drag and Drop on Portfilio to create new Program","NA","system",0,44,"a0","2020-01-31"]
[317,"tbType","Project","NewBars","NewBars","Proj","Drag and Drop on on Portfolio or Program to create new Project","NA","system",0,44,"a0","2020-01-31"]
[318,"tbType","Task","NewBars","NewBars","Task","Drag and Drop on,  another Task to clone it, a Project or Release to create new Task","NA","system",0,44,"a0","2020-01-31"]
[319,"tbType","Milestone","NewBars","NewBars","MS","Drag and Drop on,  another Milestone to clone it, a Project or Release to create new Milestone","NA","system",0,44,"a0","2020-01-31"]
[320,"tbType","Sub-Project","NewBars","NewBars","subProj","Drag and Drop on project to create sub project","NA","system",0,44,"a0","2020-01-31"]
[321,"tbType","Gate","NewBars","NewBars","Gate","Drop to create a gate object on canvas","NA","system",0,44,"a0","2020-01-31"]
[322,"tbType","Allocation","NewBars","General","Alloc","Not used, see Resource Allocator to assign a new Resource","NA","system",0,44,"a0","2020-01-31"]
[323,"tbType","Risk","NewBars","General","Risk","Future - drop anywhere to create a Risk","NA","system",0,44,"a0","2020-01-31"]
[324,"tbType","Issue","NewBars","General","Issue","Future - drop anywhere to create a Issue","NA","system",0,44,"a0","2020-01-31"]
[325,"tbType","ActionItem","NewBars","General","Actn","Future - drop anywhere to create an Action Item","NA","system",0,44,"a0","2020-01-31"]
[326,"tbType","Release","NewBars","NewBars","Rel","Drag and Drop on Canvas to create new Release","NA","system",0,44,"a0","2020-01-31"]
[327,"Team Leader","Ben tl","ResList","ResList","Ben tl","Resource or person tagging","NA","system",0,44,"a0","2020-01-31"]
[328,"Team Leader","Erica tl","ResList","ResList","Erica tl","Resource or person tagging","NA","system",0,44,"a0","2020-01-31"]
[329,"Team Leader","Julia tl","ResList","ResList","Julia tl","Resource or person tagging","NA","system",0,44,"a0","2020-01-31"]
[330,"Type Of Initiative","Project","ProjList","ProjList","Project","Project Tagging","NA","system",0,44,"a0","2020-01-31"]
[331,"Type Of Initiative","Sprint","ProjList","ProjList","Sprint","Project Tagging","NA","system",0,44,"a0","2020-01-31"]
[332,"Type Of Initiative","Program","ProjList","ProjList","Program","Project Tagging","NA","system",0,44,"a0","2020-01-31"]
[333,"Type Of Initiative","Other","ProjList","ProjList","Other","Project Tagging","NA","system",0,44,"a0","2020-01-31"]
[334,"Type Of Initiative","Portfolio","ProjList","ProjList","Portfolio","Project Tagging","NA","system",0,44,"a0","2020-01-31"]
[335,"YesNo","Yes","General","General","Yes","for tagging a time bar for true or false on unknown","NA","system",0,44,"a0","2020-01-31"]
[336,"YesNo","No","General","General","No","for tagging a time bar for true or false on unknown","NA","system",0,44,"a0","2020-01-31"]
[337,"YesNo","NA","General","General","NA","for tagging a time bar for true or false on unknown","NA","system",6,44,"a0","2020-01-31"]
[338,"Field Type","Editor","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[339,"Field Type","WithPicklist","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[340,"Field Type","NoPicklist","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[341,"Field Type","Band","General","General","NA","Setting up dynamic forms","NA","system",7]
[342,"Form Name","PF1","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[343,"Form Name","PF2","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[344,"Form Name","PJ1","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[345,"Form Name","PJ2","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[346,"Form Name","PJ3","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[347,"Form Name","SPJ1","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[348,"Form Name","Task1","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[349,"Form Name","Task2","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[350,"Form Name","ALLOC1","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[351,"Form Name","ALLOC2","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[352,"Form Name","DOC1","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[353,"Form Name","DOC2","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[354,"Form Name","other1","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[355,"Form Name","other2","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[356,"Tag Group","Business Advisors","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[357,"Tag Group","Business Owners","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[358,"Tag Group","Calendar","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[359,"Tag Group","Category","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[360,"Tag Group","Contact","General","General","NA","Setting up dynamic forms","NA","system",6,44,"a0","2020-01-31"]
[361,"Tag Group","Cost Code","General","General","NA","Setting up dynamic forms","NA","system",7]
[362,"Tag Group","Delivery Managers","General","General","NA","Setting up dynamic forms","NA","system",8]
[363,"Tag Group","Department","General","General","NA","Setting up dynamic forms","NA","system",9]
[364,"Tag Group","Document Purpose","General","General","NA","Setting up dynamic forms","NA","system",10]
[365,"Tag Group","Document Status","General","General","NA","Setting up dynamic forms","NA","system",11]
[366,"Tag Group","Document Type","General","General","NA","Setting up dynamic forms","NA","system",12]
[367,"Tag Group","Estimation Class","General","General","NA","Setting up dynamic forms","NA","system",13]
[368,"Tag Group","ExpectedHoursPerWeek","General","General","NA","Setting up dynamic forms","NA","system",14]
[369,"Tag Group","ExSponsor","General","General","NA","Setting up dynamic forms","NA","system",15]
[370,"Tag Group","ExtSystemResID","General","General","NA","Setting up dynamic forms","NA","system",16]
[371,"Tag Group","Gates Large","General","General","NA","Setting up dynamic forms","NA","system",17]
[372,"Tag Group","Gates Medium","General","General","NA","Setting up dynamic forms","NA","system",18]
[373,"Tag Group","Gates Release","General","General","NA","Setting up dynamic forms","NA","system",19]
[374,"Tag Group","Gates Small","General","General","NA","Setting up dynamic forms","NA","system",20]
[375,"Tag Group","Health","General","General","NA","Setting up dynamic forms","NA","system",21]
[376,"Tag Group","Health Indicators","General","General","NA","Setting up dynamic forms","NA","system",22]
[377,"Tag Group","HyperLinks","General","General","NA","Setting up dynamic forms","NA","system",23]
[378,"Tag Group","Investment Category","General","General","NA","Setting up dynamic forms","NA","system",24]
[379,"Tag Group","Investment Initiative","General","General","NA","Setting up dynamic forms","NA","system",25]
[380,"Tag Group","Investment Objective","General","General","NA","Setting up dynamic forms","NA","system",26]
[381,"Tag Group","Investment Strategy","General","General","NA","Setting up dynamic forms","NA","system",27]
[382,"Tag Group","L1","General","General","NA","Setting up dynamic forms","NA","system",28]
[383,"Tag Group","L2","General","General","NA","Setting up dynamic forms","NA","system",29]
[384,"Tag Group","L3","General","General","NA","Setting up dynamic forms","NA","system",30]
[385,"Tag Group","Labour Type","General","General","NA","Setting up dynamic forms","NA","system",31]
[386,"Tag Group","Lifecycle Phase","General","General","NA","Setting up dynamic forms","NA","system",32]
[387,"Tag Group","Location","General","General","NA","Setting up dynamic forms","NA","system",33]
[388,"Tag Group","Non Project Tag","General","General","NA","Setting up dynamic forms","NA","system",34]
[389,"Tag Group","OOM Estimates","General","General","NA","Setting up dynamic forms","NA","system",35]
[390,"Tag Group","Organizational Manager","General","General","NA","Setting up dynamic forms","NA","system",36]
[391,"Tag Group","Parttime Fulltime","General","General","NA","Setting up dynamic forms","NA","system",37]
[392,"Tag Group","PartTimeFullTime","General","General","NA","Setting up dynamic forms","NA","system",38]
[393,"Tag Group","PercentTimeAllocated","General","General","NA","Setting up dynamic forms","NA","system",39]
[394,"Tag Group","PerecentAvailable","General","General","NA","Setting up dynamic forms","NA","system",40]
[395,"Tag Group","Phase","General","General","NA","Setting up dynamic forms","NA","system",41]
[396,"Tag Group","Portfolios","General","General","NA","Setting up dynamic forms","NA","system",42]
[397,"Tag Group","Primary Contact","General","General","NA","Setting up dynamic forms","NA","system",43]
[398,"Tag Group","Primary Line of Business","General","General","NA","Setting up dynamic forms","NA","system",44]
[399,"Tag Group","Primary Skill","General","General","NA","Setting up dynamic forms","NA","system",45]
[400,"Tag Group","Primary Strategic Priority","General","General","NA","Setting up dynamic forms","NA","system",46]
[401,"Tag Group","Priority","General","General","NA","Setting up dynamic forms","NA","system",47]
[402,"Tag Group","Product","General","General","NA","Setting up dynamic forms","NA","system",48]
[403,"Tag Group","Program Activity Alignment (PAA)","General","General","NA","Setting up dynamic forms","NA","system",49]
[404,"Tag Group","Programs","General","General","NA","Setting up dynamic forms","NA","system",50]
[405,"Tag Group","Project Managers","General","General","NA","Setting up dynamic forms","NA","system",51]
[406,"Tag Group","Project Status","General","General","NA","Setting up dynamic forms","NA","system",52]
[407,"Tag Group","ProjectManager","General","General","NA","Setting up dynamic forms","NA","system",53]
[408,"Tag Group","ProjectNumber","General","General","NA","Setting up dynamic forms","NA","system",54]
[409,"Tag Group","Resource Class","General","General","NA","Setting up dynamic forms","NA","system",55]
[410,"Tag Group","Resource Manager","General","General","NA","Setting up dynamic forms","NA","system",56]
[411,"Tag Group","Resource Role","General","General","NA","Setting up dynamic forms","NA","system",57]
[412,"Tag Group","Resource Supervisor","General","General","NA","Setting up dynamic forms","NA","system",58]
[413,"Tag Group","ResourceCalendar","General","General","NA","Setting up dynamic forms","NA","system",59]
[414,"Tag Group","Responsibility","General","General","NA","Setting up dynamic forms","NA","system",60]
[415,"Tag Group","Responsible Teams","General","General","NA","Setting up dynamic forms","NA","system",61]
[416,"Tag Group","Severity","General","General","NA","Setting up dynamic forms","NA","system",62]
[417,"Tag Group","Show In Reports","General","General","NA","Setting up dynamic forms","NA","system",63]
[418,"Tag Group","ShowIn","General","General","NA","Setting up dynamic forms","NA","system",64]
[419,"Tag Group","Size","General","General","NA","Setting up dynamic forms","NA","system",65]
[420,"Tag Group","Sponsoring Department","General","General","NA","Setting up dynamic forms","NA","system",66]
[421,"Tag Group","Sponsors","General","General","NA","Setting up dynamic forms","NA","system",67]
[422,"Tag Group","Stage","General","General","NA","Setting up dynamic forms","NA","system",68]
[423,"Tag Group","Stage (Manual)","General","General","NA","Setting up dynamic forms","NA","system",69]
[424,"Tag Group","State","General","General","NA","Setting up dynamic forms","NA","system",70]
[425,"Tag Group","Status","General","General","NA","Setting up dynamic forms","NA","system",71]
[426,"Tag Group","stdTasks","General","General","NA","Setting up dynamic forms","NA","system",72]
[427,"Tag Group","tbType","General","General","NA","Setting up dynamic forms","NA","system",73]
[428,"Tag Group","Team Leader","General","General","NA","Setting up dynamic forms","NA","system",74]
[429,"Tag Group","Type Of Initiative","General","General","NA","Setting up dynamic forms","NA","system",75]
[430,"Tag Group","YesNo","General","General","NA","Setting up dynamic forms","NA","system",76]
[431,"Tag Group","Field Type","General","General","NA","Setting up dynamic forms","NA","system",77]
[432,"Tag Group","Form Name","General","General","NA","Setting up dynamic forms","NA","system",78]
[433,"Field Name","tbMDID","General","General","NA","Setting up dynamic forms","NA","system",79]
[434,"Field Name","tbMDName","General","General","NA","Setting up dynamic forms","NA","system",80]
[435,"Field Name","tbMDProjectType","General","General","NA","Setting up dynamic forms","NA","system",81]
[436,"Field Name","tbMDPortfolio","General","General","NA","Setting up dynamic forms","NA","system",82]
[437,"Field Name","tbMDProgram","General","General","NA","Setting up dynamic forms","NA","system",83]
[438,"Field Name","tbMDExecutiveSummary","General","General","NA","Setting up dynamic forms","NA","system",84]
[439,"Field Name","tbMDGate","General","General","NA","Setting up dynamic forms","NA","system",85]
[440,"Field Name","tbMDDeliveryManager","General","General","NA","Setting up dynamic forms","NA","system",86]
[441,"Field Name","tbMDBusinessAdvisor","General","General","NA","Setting up dynamic forms","NA","system",87]
[442,"Field Name","tbMDBusinessOwner","General","General","NA","Setting up dynamic forms","NA","system",88]
[443,"Field Name","tbMDEstimationClass","General","General","NA","Setting up dynamic forms","NA","system",89]
[444,"Field Name","tbMDROMEstimate","General","General","NA","Setting up dynamic forms","NA","system",90]
[445,"Field Name","tbMDInvestmentCategory","General","General","NA","Setting up dynamic forms","NA","system",91]
[446,"Field Name","tbMDInvestmentInitiative","General","General","NA","Setting up dynamic forms","NA","system",92]
[447,"Field Name","tbMDInvestmentObjective","General","General","NA","Setting up dynamic forms","NA","system",93]
[448,"Field Name","tbMDInvestmentStrategy","General","General","NA","Setting up dynamic forms","NA","system",94]
[449,"Field Name","tbMDPriorityStrategic","General","General","NA","Setting up dynamic forms","NA","system",95]
[450,"Field Name","tbMDCustomerID","General","General","NA","Setting up dynamic forms","NA","system",96]
[451,"Field Name","tbMDAzureID","General","General","NA","Setting up dynamic forms","NA","system",97]
[452,"Field Name","tbMDNameShort","General","General","NA","Setting up dynamic forms","NA","system",98]
[453,"Field Name","tbMDProjectNumber","General","General","NA","Setting up dynamic forms","NA","system",99]
[454,"Field Name","tbMDDescription","General","General","NA","Setting up dynamic forms","NA","system",100]
[455,"Field Name","tbMDNotes","General","General","NA","Setting up dynamic forms","NA","system",101]
[456,"Field Name","tbMDExtLink1","General","General","NA","Setting up dynamic forms","NA","system",102]
[457,"Field Name","tbMDExtSystemID1","General","General","NA","Setting up dynamic forms","NA","system",103]
[458,"Field Name","tbMDSortOrder","General","General","NA","Setting up dynamic forms","NA","system",104]
[459,"Field Name","tbMDtbLastModified","General","General","NA","Setting up dynamic forms","NA","system",105]
[460,"Field Name","tbMDPriority","General","General","NA","Setting up dynamic forms","NA","system",106]
[461,"Field Name","tbMDStatus","General","General","NA","Setting up dynamic forms","NA","system",107]
[462,"Field Name","tbMDState","General","General","NA","Setting up dynamic forms","NA","system",108]
[463,"Field Name","tbMDSeverity","General","General","NA","Setting up dynamic forms","NA","system",109]
[464,"Field Name","tbMDStage","General","General","NA","Setting up dynamic forms","NA","system",110]
[465,"Field Name","tbMDPhase","General","General","NA","Setting up dynamic forms","NA","system",111]
[466,"Field Name","tbMDCategory","General","General","NA","Setting up dynamic forms","NA","system",112]
[467,"Field Name","tbMDHealth","General","General","NA","Setting up dynamic forms","NA","system",113]
[468,"Field Name","tbMDResponsibility","General","General","NA","Setting up dynamic forms","NA","system",114]
[469,"Field Name","tbMDDepartment","General","General","NA","Setting up dynamic forms","NA","system",115]
[470,"Field Name","tbMDExSponsor","General","General","NA","Setting up dynamic forms","NA","system",116]
[471,"Field Name","tbMDPM","General","General","NA","Setting up dynamic forms","NA","system",117]
[472,"Field Name","tbMDShowIn","General","General","NA","Setting up dynamic forms","NA","system",118]
[473,"Field Name","tbMDYesNoSelector","General","General","NA","Setting up dynamic forms","NA","system",119]
[474,"Field Name","tbMDProduct","General","General","NA","Setting up dynamic forms","NA","system",120]
[475,"Field Name","tbMDContact","General","General","NA","Setting up dynamic forms","NA","system",121]
[476,"Field Name","tbMDWBS","General","General","NA","Setting up dynamic forms","NA","system",122]
[477,"Field Name","tbMDWeighting","General","General","NA","Setting up dynamic forms","NA","system",123]
[478,"Field Name","tbMDLocation","General","General","NA","Setting up dynamic forms","NA","system",124]
[479,"Field Name","tbMDPrimarySkill","General","General","NA","Setting up dynamic forms","NA","system",125]
[480,"Field Name","tbMDPrimaryRole","General","General","NA","Setting up dynamic forms","NA","system",126]
[481,"Field Name","tbMDOther2","General","General","NA","Setting up dynamic forms","NA","system",127]
[482,"Field Name","tbMDOther3","General","General","NA","Setting up dynamic forms","NA","system",128]
[483,"Field Name","tbMDOther4","General","General","NA","Setting up dynamic forms","NA","system",129]
[484,"Field Name","canvasNo","General","General","NA","Setting up dynamic forms","NA","system",130]
[485,"Field Name","tbMDProgActivityAlignment","General","General","NA","Setting up dynamic forms","NA","system",131]
[486,"Field Name","tbMDBackgroundInfo","General","General","NA","Setting up dynamic forms","NA","system",132]
[487,"Field Name","tbMDConsequence","General","General","NA","Setting up dynamic forms","NA","system",133]
[488,"Field Name","tbMDExpectedBenfits","General","General","NA","Setting up dynamic forms","NA","system",134]
[489,"Field Name","tbMDProblemOpportunity","General","General","NA","Setting up dynamic forms","NA","system",135]
[490,"Field Name","tbMDCapabilitiesNeeded","General","General","NA","Setting up dynamic forms","NA","system",136]
[491,"Field Name","tbMDSeniorLevelCommittment","General","General","NA","Setting up dynamic forms","NA","system",137]
[492,"Field Name","tbMDSprintName","General","General","NA","Setting up dynamic forms","NA","system",138]
[493,"Field Name","tbMDStakeholderDescription","General","General","NA","Setting up dynamic forms","NA","system",139]
[494,"Field Name","tbMDHealthCost","General","General","NA","Setting up dynamic forms","NA","system",140]
[495,"Field Name","tbMDHealthHours","General","General","NA","Setting up dynamic forms","NA","system",141]
[496,"Field Name","tbMDHealthIssues","General","General","NA","Setting up dynamic forms","NA","system",142]
[497,"Field Name","tbMDHealthOverall","General","General","NA","Setting up dynamic forms","NA","system",143]
[498,"Field Name","tbMDHealthRisk","General","General","NA","Setting up dynamic forms","NA","system",144]
[499,"Field Name","tbMDHealthSchedule","General","General","NA","Setting up dynamic forms","NA","system",145]
[500,"Field Name","tbMDHealthScope","General","General","NA","Setting up dynamic forms","NA","system",146]
[501,"Field Name","tbMDBenefitCostRatio","General","General","NA","Setting up dynamic forms","NA","system",147]
[502,"Field Name","tbMDConstraintsAssumptions","General","General","NA","Setting up dynamic forms","NA","system",148]
[503,"Field Name","tbMDContractNumber","General","General","NA","Setting up dynamic forms","NA","system",149]
[504,"Field Name","tbMDCostBenefitAnalysis","General","General","NA","Setting up dynamic forms","NA","system",150]
[505,"Field Name","tbMDEcnomicValueAdded","General","General","NA","Setting up dynamic forms","NA","system",151]
[506,"Field Name","tbMDInternalRateOfReturn","General","General","NA","Setting up dynamic forms","NA","system",152]
[507,"Field Name","tbMDNetPresentValue","General","General","NA","Setting up dynamic forms","NA","system",153]
[508,"Field Name","tbMDOpportunityCost","General","General","NA","Setting up dynamic forms","NA","system",154]
[509,"Field Name","tbMDOrgManager","General","General","NA","Setting up dynamic forms","NA","system",155]
[510,"Field Name","tbMDPaybackPeriod","General","General","NA","Setting up dynamic forms","NA","system",156]
[511,"Field Name","tbMDRiskVsSizeAndComplexity","General","General","NA","Setting up dynamic forms","NA","system",157]
[512,"Field Name","tbMDSize","General","General","NA","Setting up dynamic forms","NA","system",158]
[513,"Field Name","tbMDStageApprover","General","General","NA","Setting up dynamic forms","NA","system",159]
[514,"Field Name","tbMDSunkCosts","General","General","NA","Setting up dynamic forms","NA","system",160]
[515,"Field Name","tbMDWrittenBy","General","General","NA","Setting up dynamic forms","NA","system",161]
[516,"Field Name","tbMDPrimaryLineOfBusiness","General","General","NA","Setting up dynamic forms","NA","system",162]
[517,"Field Name","tbMDNotesWorkflow","General","General","NA","Setting up dynamic forms","NA","system",163]
[518,"Field Name","tbMDSyncNotes","General","General","NA","Setting up dynamic forms","NA","system",164]
[519,"Field Name","tbMDSponsoringDepartment","General","General","NA","Setting up dynamic forms","NA","system",165]
[520,"Field Name","tbMDPrimaryContact","General","General","NA","Setting up dynamic forms","NA","system",166]
[521,"Field Name","tbMDContactNumber","General","General","NA","Setting up dynamic forms","NA","system",167]
[522,"Field Name","tbMDResponsibleTeam","General","General","NA","Setting up dynamic forms","NA","system",168]
[523,"Field Name","tbMDNotesProject","General","General","NA","Setting up dynamic forms","NA","system",169]
[524,"Field Name","tbMDOther5","General","General","NA","Setting up dynamic forms","NA","system",170]
[525,"Field Name","tbMDOther6","General","General","NA","Setting up dynamic forms","NA","system",171]
[526,"Field Name","tbMDOther7","General","General","NA","Setting up dynamic forms","NA","system",172]
[527,"Field Name","tbMDOther8","General","General","NA","Setting up dynamic forms","NA","system",173]
[528,"Field Name","tbMDOther9","General","General","NA","Setting up dynamic forms","NA","system",174]
[529,"Field Name","tbMDOther10","General","General","NA","Setting up dynamic forms","NA","system",175]
[530,"Field Name","tbMDOther11","General","General","NA","Setting up dynamic forms","NA","system",176]
[531,"Field Name","tbMDOther12","General","General","NA","Setting up dynamic forms","NA","system",177]
[532,"Field Name","tbMDRefID","General","General","NA","Setting up dynamic forms","NA","system",178]
[533,"Field Name","tbID","General","General","NA","Setting up dynamic forms","NA","system",179]
[534,"Field Name","tbSelfKey2","General","General","NA","Setting up dynamic forms","NA","system",180]
[535,"Field Name","tbCoordTop","General","General","NA","Setting up dynamic forms","NA","system",181]
[536,"Field Name","tbCoordLeft","General","General","NA","Setting up dynamic forms","NA","system",182]
[537,"Field Name","tbHierarchyOrder","General","General","NA","Setting up dynamic forms","NA","system",183]
[538,"Field Name","tbName","General","General","NA","Setting up dynamic forms","NA","system",184]
[539,"Field Name","tbType","General","General","NA","Setting up dynamic forms","NA","system",185]
[540,"Field Name","tbL1","General","General","NA","Setting up dynamic forms","NA","system",186]
[541,"Field Name","tbL2","General","General","NA","Setting up dynamic forms","NA","system",187]
[542,"Field Name","tbL3","General","General","NA","Setting up dynamic forms","NA","system",188]
[543,"Field Name","tbL4","General","General","NA","Setting up dynamic forms","NA","system",189]
[544,"Field Name","tbL5","General","General","NA","Setting up dynamic forms","NA","system",190]
[545,"Field Name","tbOwner","General","General","NA","Setting up dynamic forms","NA","system",191]
[546,"Field Name","tbStart","General","General","NA","Setting up dynamic forms","NA","system",192]
[547,"Field Name","tbFinish","General","General","NA","Setting up dynamic forms","NA","system",193]
[548,"Field Name","tbDuration","General","General","NA","Setting up dynamic forms","NA","system",194]
[549,"Field Name","tbAStart","General","General","NA","Setting up dynamic forms","NA","system",195]
[550,"Field Name","tbAFinish","General","General","NA","Setting up dynamic forms","NA","system",196]
[551,"Field Name","tbRemainingDuration","General","General","NA","Setting up dynamic forms","NA","system",197]
[552,"Field Name","tbResID","General","General","NA","Setting up dynamic forms","NA","system",198]
[553,"Field Name","tbCalendar","General","General","NA","Setting up dynamic forms","NA","system",199]
[554,"Field Name","tbPercentTimeOn","General","General","NA","Setting up dynamic forms","NA","system",200]
[555,"Field Name","tbWork","General","General","NA","Setting up dynamic forms","NA","system",201]
[556,"Field Name","tbAWork","General","General","NA","Setting up dynamic forms","NA","system",202]
[557,"Field Name","tbWorkRemaining","General","General","NA","Setting up dynamic forms","NA","system",203]
[558,"Field Name","tbPercentComplete","General","General","NA","Setting up dynamic forms","NA","system",204]
[559,"Field Name","tbCost","General","General","NA","Setting up dynamic forms","NA","system",205]
[560,"Field Name","tbAcost","General","General","NA","Setting up dynamic forms","NA","system",206]
[561,"Field Name","tbCostRemaining","General","General","NA","Setting up dynamic forms","NA","system",207]
[562,"Field Name","tbPayRate","General","General","NA","Setting up dynamic forms","NA","system",208]
[563,"Field Name","tbCostType","General","General","NA","Setting up dynamic forms","NA","system",209]
[564,"Field Name","tbCostID","General","General","NA","Setting up dynamic forms","NA","system",210]
[565,"Field Name","tbConstraintType","General","General","NA","Setting up dynamic forms","NA","system",211]
[566,"Field Name","tbConstraintDate","General","General","NA","Setting up dynamic forms","NA","system",212]
[567,"Field Name","tbFloat","General","General","NA","Setting up dynamic forms","NA","system",213]
[568,"Field Name","tbFreeFloat","General","General","NA","Setting up dynamic forms","NA","system",214]
[569,"Field Name","tbExpHoursPerWeek","General","General","NA","Setting up dynamic forms","NA","system",215]
[570,"Field Name","canvasNo","General","General","NA","Setting up dynamic forms","NA","system",216]
[571,"Field Name","tbCustomerID","General","General","NA","Setting up dynamic forms","NA","system",217]
[572,"Field Name","tbMetaDataID","General","General","NA","Setting up dynamic forms","NA","system",218]
[573,"Field Name","tbBLID","General","General","NA","Setting up dynamic forms","NA","system",219]
[574,"Field Name","tbPredecessor","General","General","NA","Setting up dynamic forms","NA","system",220]
[575,"Field Name","tbAzureID","General","General","NA","Setting up dynamic forms","NA","system",221]
[576,"Field Name","tbCoordRight","General","General","NA","Setting up dynamic forms","NA","system",222]
[577,"Field Name","tbBarColor","General","General","NA","Setting up dynamic forms","NA","system",223]
[578,"Field Name","tbTextColor","General","General","NA","Setting up dynamic forms","NA","system",224]
[579,"Field Name","kbCoordLeft","General","General","NA","Setting up dynamic forms","NA","system",225]
[580,"Field Name","kbCoordTop","General","General","NA","Setting up dynamic forms","NA","system",226]
[581,"Field Name","focdItemCoordLeft","General","General","NA","Setting up dynamic forms","NA","system",227]
[582,"Field Name","focdItemCoordTop","General","General","NA","Setting up dynamic forms","NA","system",228]
[583,"Field Name","tbDocID","General","General","NA","Setting up dynamic forms","NA","system",229]
[584,"Field Name","tbDocName","General","General","NA","Setting up dynamic forms","NA","system",230]
[585,"Field Name","tbDocNameShort","General","General","NA","Setting up dynamic forms","NA","system",231]
[586,"Field Name","tbDocStatus","General","General","NA","Setting up dynamic forms","NA","system",232]
[587,"Field Name","tbDocPurpose","General","General","NA","Setting up dynamic forms","NA","system",233]
[588,"Field Name","tbDocWrittenBy","General","General","NA","Setting up dynamic forms","NA","system",234]
[589,"Field Name","tbDocBriefDescription","General","General","NA","Setting up dynamic forms","NA","system",235]
[590,"Field Name","tbDocCustomerID","General","General","NA","Setting up dynamic forms","NA","system",236]
[591,"Field Name","tbDocType","General","General","NA","Setting up dynamic forms","NA","system",237]
[592,"Field Name","tbDocHTMLContent","General","General","NA","Setting up dynamic forms","NA","system",238]
[593,"Field Name","tbDocGroup","General","General","NA","Setting up dynamic forms","NA","system",239]
[594,"Field Name","tbDocOwner","General","General","NA","Setting up dynamic forms","NA","system",240]
[595,"Field Name","tbDocPopular","General","General","NA","Setting up dynamic forms","NA","system",241]
[596,"Field Name","tbDocSortOrder","General","General","NA","Setting up dynamic forms","NA","system",242]
[597,"Field Name","tbDocLastModified","General","General","NA","Setting up dynamic forms","NA","system",243]
[598,"Field Name","tbDocApprovedBy","General","General","NA","Setting up dynamic forms","NA","system",244]
[599,"Field Name","tbDocL1","General","General","NA","Setting up dynamic forms","NA","system",245]
[600,"Field Name","tbDocL2","General","General","NA","Setting up dynamic forms","NA","system",246]
[601,"Field Name","tbDocL3","General","General","NA","Setting up dynamic forms","NA","system",247]
[602,"Field Name","tbDocL4","General","General","NA","Setting up dynamic forms","NA","system",248]
[603,"Field Name","tbDocL5","General","General","NA","Setting up dynamic forms","NA","system",249]
[604,"Field Name","tbDocCardImage","General","General","NA","Setting up dynamic forms","NA","system",250]
[605,"Field Name","tbResID","General","General","NA","Setting up dynamic forms","NA","system",251]
[606,"Field Name","tbResName","General","General","NA","Setting up dynamic forms","NA","system",252]
[607,"Field Name","tbResNameShort","General","General","NA","Setting up dynamic forms","NA","system",253]
[608,"Field Name","tbResPrimarySkill","General","General","NA","Setting up dynamic forms","NA","system",254]
[609,"Field Name","tbResPrimaryRole","General","General","NA","Setting up dynamic forms","NA","system",255]
[610,"Field Name","tbResDepartment","General","General","NA","Setting up dynamic forms","NA","system",256]
[611,"Field Name","tbResManager","General","General","NA","Setting up dynamic forms","NA","system",257]
[612,"Field Name","tbResPayRate","General","General","NA","Setting up dynamic forms","NA","system",258]
[613,"Field Name","tbResTeam","General","General","NA","Setting up dynamic forms","NA","system",259]
[614,"Field Name","tbResLocation","General","General","NA","Setting up dynamic forms","NA","system",260]
[615,"Field Name","tbResTeamLeader","General","General","NA","Setting up dynamic forms","NA","system",261]
[616,"Field Name","tbResSupervisor","General","General","NA","Setting up dynamic forms","NA","system",262]
[617,"Field Name","tbResPartTimeFullTime","General","General","NA","Setting up dynamic forms","NA","system",263]
[618,"Field Name","tbResResourceType","General","General","NA","Setting up dynamic forms","NA","system",264]
[619,"Field Name","tbResResourceClass","General","General","NA","Setting up dynamic forms","NA","system",265]
[620,"Field Name","tbResResourceCalendar","General","General","NA","Setting up dynamic forms","NA","system",266]
[621,"Field Name","tbResPercentGeneralAvailability","General","General","NA","Setting up dynamic forms","NA","system",267]
[622,"Field Name","tbResCostCode","General","General","NA","Setting up dynamic forms","NA","system",268]
[623,"Field Name","tbResCustomerID","General","General","NA","Setting up dynamic forms","NA","system",269]
[624,"Field Name","tbResExtSystemResID","General","General","NA","Setting up dynamic forms","NA","system",270]
[625,"Field Name","tbResSortOrder","General","General","NA","Setting up dynamic forms","NA","system",271]
[626,"Field Name","tbResLastModified","General","General","NA","Setting up dynamic forms","NA","system",272]
[627,"Field Name","tbResExtSystemResID","General","General","NA","Setting up dynamic forms","NA","system",273]
[628,"Field Name","tbResCoordTop","General","General","NA","Setting up dynamic forms","NA","system",274]
[629,"Field Name","tbResCoordLeft","General","General","NA","Setting up dynamic forms","NA","system",275]
[630,"Field Name","tbResLabourType","General","General","NA","Setting up dynamic forms","NA","system",276]
[631,"Field Name","tbResEmail","General","General","NA","Setting up dynamic forms","NA","system",277]
[632,"Field Name","tbResPasswordHash","General","General","NA","Setting up dynamic forms","NA","system",278]
[633,"Field Name","tbResPIN","General","General","NA","Setting up dynamic forms","NA","system",279]
[634,"Field Name","tbResAzureID","General","General","NA","Setting up dynamic forms","NA","system",280]
[635,"Field State","Disabled","General","General","NA","Setting up dynamic forms","NA","system",280]
[636,"Field State","Editable","General","General","NA","Setting up dynamic forms","NA","system",280]
[637,"Project Type","Maintainance","ProjList","ProjList","NA","Project Tagging","NA","PMO",0]
[638,"Project Type","New Product","ProjList","ProjList","NA","Project Tagging","NA","PMO",0]
[639,"WBS Dictionary","1.0 Proposal","ProjList","ProjList","NA","Project Tagging"]
[640,"WBS Dictionary","2.0 Engineering","ProjList","ProjList","NA","Project Tagging"]
[641,"WBS Dictionary","3.0 Procurement","ProjList","ProjList","NA","Project Tagging"]
[642,"WBS Dictionary","4.0 Project Management","ProjList","ProjList","NA","Project Tagging"]
[643,"WBS Dictionary","5.0 Business Overhead","ProjList","ProjList","NA","Project Tagging"]
[644,"Risk Vs Size","RSC-1","ProjList","ProjList","NA","Project Tagging"]
[645,"Risk Vs Size","RSC-2","ProjList","ProjList","NA","Project Tagging"]
[646,"Risk Vs Size","RSC-3","ProjList","ProjList","NA","Project Tagging"]
[647,"Risk Vs Size","RSC-4","ProjList","ProjList","NA","Project Tagging"]
[648,"Risk Vs Size","RSC-5","ProjList","ProjList","NA","Project Tagging"]
[649,"Step","Step 1","ProjList","ProjList","NA","Project Tagging"]
[650,"Step","Step 2","ProjList","ProjList","NA","Project Tagging"]
[651,"Step Status","Open","ProjList","ProjList","NA","Project Tagging"]
[652,"Step Status","Closed","ProjList","ProjList","NA","Project Tagging"]
[653,"Resource Type","Overhead","ResList","ResList","NA",null,"NA","PMO"]
[654,"Resource Type","Billable","ResList","ResList","NA",null,"NA","PMO"]
[655,"Tag Group","Business Advisors","NA","NA","NA","For defining picklists for Form Fields"]
[656,"Tag Group","Business Advisors","NA","NA","NA","For defining picklists for Form Fields"]
[657,"Tag Group","Business Owners","NA","NA","NA","For defining picklists for Form Fields"]
[658,"Tag Group","Calendar","NA","NA","NA","For defining picklists for Form Fields"]
[659,"Tag Group","Category","NA","NA","NA","For defining picklists for Form Fields"]
[660,"Tag Group","Contact","NA","NA","NA","For defining picklists for Form Fields"]
[661,"Tag Group","Cost Code","NA","NA","NA","For defining picklists for Form Fields"]
[662,"Tag Group","Delivery Managers","NA","NA","NA","For defining picklists for Form Fields"]
[663,"Tag Group","Department","NA","NA","NA","For defining picklists for Form Fields"]
[664,"Tag Group","Document Purpose","NA","NA","NA","For defining picklists for Form Fields"]
[665,"Tag Group","Document Status","NA","NA","NA","For defining picklists for Form Fields"]
[666,"Tag Group","Document Type","NA","NA","NA","For defining picklists for Form Fields"]
[667,"Tag Group","Estimation Class","NA","NA","NA","For defining picklists for Form Fields"]
[668,"Tag Group","ExpectedHoursPerWeek","NA","NA","NA","For defining picklists for Form Fields"]
[669,"Tag Group","ExSponsor","NA","NA","NA","For defining picklists for Form Fields"]
[670,"Tag Group","ExtSystemResID","NA","NA","NA","For defining picklists for Form Fields"]
[671,"Tag Group","Gates Large","NA","NA","NA","For defining picklists for Form Fields"]
[672,"Tag Group","Gates Medium","NA","NA","NA","For defining picklists for Form Fields"]
[673,"Tag Group","Gates Release","NA","NA","NA","For defining picklists for Form Fields"]
[674,"Tag Group","Gates Small","NA","NA","NA","For defining picklists for Form Fields"]
[675,"Tag Group","Health","NA","NA","NA","For defining picklists for Form Fields"]
[676,"Tag Group","Health Indicators","NA","NA","NA","For defining picklists for Form Fields"]
[677,"Tag Group","HyperLinks","NA","NA","NA","For defining picklists for Form Fields"]
[678,"Tag Group","Investment Category","NA","NA","NA","For defining picklists for Form Fields"]
[679,"Tag Group","Investment Initiative","NA","NA","NA","For defining picklists for Form Fields"]
[680,"Tag Group","Investment Objective","NA","NA","NA","For defining picklists for Form Fields"]
[681,"Tag Group","Investment Strategy","NA","NA","NA","For defining picklists for Form Fields"]
[682,"Tag Group","L1","NA","NA","NA","For defining picklists for Form Fields"]
[683,"Tag Group","L2","NA","NA","NA","For defining picklists for Form Fields"]
[684,"Tag Group","L3","NA","NA","NA","For defining picklists for Form Fields"]
[685,"Tag Group","Labour Type","NA","NA","NA","For defining picklists for Form Fields"]
[686,"Tag Group","Lifecycle Phase","NA","NA","NA","For defining picklists for Form Fields"]
[687,"Tag Group","Location","NA","NA","NA","For defining picklists for Form Fields"]
[688,"Tag Group","Non Project Tag","NA","NA","NA","For defining picklists for Form Fields"]
[689,"Tag Group","OOM Estimates","NA","NA","NA","For defining picklists for Form Fields"]
[690,"Tag Group","Organizational Manager","NA","NA","NA","For defining picklists for Form Fields"]
[691,"Tag Group","Parttime Fulltime","NA","NA","NA","For defining picklists for Form Fields"]
[692,"Tag Group","PartTimeFullTime","NA","NA","NA","For defining picklists for Form Fields"]
[693,"Tag Group","PercentTimeAllocated","NA","NA","NA","For defining picklists for Form Fields"]
[694,"Tag Group","Percent Available","NA","NA","NA","For defining picklists for Form Fields"]
[695,"Tag Group","Phase","NA","NA","NA","For defining picklists for Form Fields"]
[696,"Tag Group","Portfolios","NA","NA","NA","For defining picklists for Form Fields"]
[697,"Tag Group","Primary Contact","NA","NA","NA","For defining picklists for Form Fields"]
[698,"Tag Group","Primary LOB","NA","NA","NA","For defining picklists for Form Fields"]
[699,"Tag Group","Primary Skill","NA","NA","NA","For defining picklists for Form Fields"]
[700,"Tag Group","Primary Strategic Priority","NA","NA","NA","For defining picklists for Form Fields"]
[701,"Tag Group","Priority","NA","NA","NA","For defining picklists for Form Fields"]
[702,"Tag Group","Product","NA","NA","NA","For defining picklists for Form Fields"]
[703,"Tag Group","Program Activity Alignment (PAA)","NA","NA","NA","For defining picklists for Form Fields"]
[704,"Tag Group","Programs","NA","NA","NA","For defining picklists for Form Fields"]
[705,"Tag Group","Project Managers","NA","NA","NA","For defining picklists for Form Fields"]
[706,"Tag Group","Project Status","NA","NA","NA","For defining picklists for Form Fields"]
[707,"Tag Group","ProjectManager","NA","NA","NA","For defining picklists for Form Fields"]
[708,"Tag Group","ProjectNumber","NA","NA","NA","For defining picklists for Form Fields"]
[709,"Tag Group","Resource Class","NA","NA","NA","For defining picklists for Form Fields"]
[710,"Tag Group","Resource Manager","NA","NA","NA","For defining picklists for Form Fields"]
[711,"Tag Group","Resource Role","NA","NA","NA","For defining picklists for Form Fields"]
[712,"Tag Group","Resource Supervisor","NA","NA","NA","For defining picklists for Form Fields"]
[713,"Tag Group","ResourceCalendar","NA","NA","NA","For defining picklists for Form Fields"]
[714,"Tag Group","Responsibility","NA","NA","NA","For defining picklists for Form Fields"]
[715,"Tag Group","Responsible Teams","NA","NA","NA","For defining picklists for Form Fields"]
[716,"Tag Group","Severity","NA","NA","NA","For defining picklists for Form Fields"]
[717,"Tag Group","Show In Reports","NA","NA","NA","For defining picklists for Form Fields"]
[718,"Tag Group","ShowIn","NA","NA","NA","For defining picklists for Form Fields"]
[719,"Tag Group","Size","NA","NA","NA","For defining picklists for Form Fields"]
[720,"Tag Group","Sponsoring Department","NA","NA","NA","For defining picklists for Form Fields"]
[721,"Tag Group","Sponsors","NA","NA","NA","For defining picklists for Form Fields"]
[722,"Tag Group","Stage","NA","NA","NA","For defining picklists for Form Fields"]
[723,"Tag Group","Stage (Manual)","NA","NA","NA","For defining picklists for Form Fields"]
[724,"Tag Group","State","NA","NA","NA","For defining picklists for Form Fields"]
[725,"Tag Group","Status","NA","NA","NA","For defining picklists for Form Fields"]
[726,"Tag Group","stdTasks","NA","NA","NA","For defining picklists for Form Fields"]
[727,"Tag Group","tbType","NA","NA","NA","For defining picklists for Form Fields"]
[728,"Tag Group","Team Leader","NA","NA","NA","For defining picklists for Form Fields"]
[729,"Tag Group","Type Of Initiative","NA","NA","NA","For defining picklists for Form Fields"]
[730,"Tag Group","YesNo","NA","NA","NA","For defining picklists for Form Fields"]
[731,"Tag Group","Field Type","NA","NA","NA","For defining picklists for Form Fields"]
[732,"Tag Group","Form Name","NA","NA","NA","For defining picklists for Form Fields"]
[733,"Tag Group","Tag Group","NA","NA","NA","For defining picklists for Form Fields"]
[734,"Tag Group","Field Name","NA","NA","NA","For defining picklists for Form Fields"]
[735,"Tag Group","Field State","NA","NA","NA","For defining picklists for Form Fields"]
[736,"Tag Group","Project Type","NA","NA","NA","For defining picklists for Form Fields"]
[737,"Tag Group","WBS Dictionary","NA","NA","NA","For defining picklists for Form Fields"]
[738,"Tag Group","Risk Vs Size","NA","NA","NA","For defining picklists for Form Fields"]
[739,"Tag Group","Step","NA","NA","NA","For defining picklists for Form Fields"]
[740,"Tag Group","Step Status","NA","NA","NA","For defining picklists for Form Fields"]
[741,"Tag Group","Resource Type","NA","NA","NA","For defining picklists for Form Fields"]
[742,"Popular","ProjList","NA","NA","NA","Where tags show up. Not mandatory"]
[743,"Popular","General","NA","NA","NA","Where tags show up. Not mandatory"]
[744,"Popular","Sched","NA","NA","NA","Where tags show up. Not mandatory"]
[745,"Popular","ResList","NA","NA","NA","Where tags show up. Not mandatory"]
[746,"Popular","StdTasks","NA","NA","NA","Where tags show up. Not mandatory"]
[747,"Popular","NewBars","NA","NA","NA","Where tags show up. Not mandatory"]
[748,"Popular","NA","NA","NA","NA","Where tags show up. Not mandatory"]

{"sheet":"Resources","index":2,"n_rows":26,"n_cols":30,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["tbResID","tbResName","tbResNameShort","tbResPrimarySkill","tbResPrimaryRole","tbResDepartment","tbResManager","tbResPayRate","tbResTeam","tbResLocation","tbResTeamLeader","tbResSupervisor","tbResPartTimeFullTime","tbResResourceType","tbResResourceClass","tbResResourceCalendar","tbResPercentGeneralAvailability","tbResCostCode","tbResCustomerID","tbResExtSystemResID","tbResSortOrder","tbResLastModified","tbResExtSystemResID","tbResCoordTop","tbResCoordLeft","tbResLabourType","tbResEmail","tbResPasswordHash","tbResPIN","tbResAzureID"]
["Listing of Stakeholders and other values for the people pick lists"]
["ResID","Name","Name Short","Primary Skill","Primary Role","Department","Manager","Pay Rate","Team","Location","Team Leader","Supervisor","Part or Full Time","Type","Class","Calendar","Default Percent Available","Cost Code","CustID","ExtResID","Sort Order","Last Modified","ExtResID","Coord Top","Coord Left","Labour Type","Email","Password Hash","PIN","AzureID"]
[700,"Joe Invent","Joe Invent","Inventing","Product Owner/Sponsor","Office of CEO","Mario CEO",50,"Ateam","Ottawa",null,null,"Full","Human","Internal",8,50,"A404",44,null,1,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[701,"Ally HR","Ally HR","HR Policies","SME HR","HR Dept","Mario CEO",50,"Ateam","Ottawa",null,null,"Full","Human","Internal",8,50,"A405",44,null,2,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[702,"Julia Finance","Julia Finance","Finance Policies","SME Finance","Finance Dept","Mario CEO",50,"Ateam","Ottawa",null,null,"Full","Human","Internal",7.5,50,"A406",44,null,3,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[717,"Ryan Tower","Ryan Tower","Tower Design","Engineer Towers","Engineering Dept","Sal Eng",75,"Ateam","Ottawa",null,null,"Full","Human","Internal",7.5,25,"A411",44,null,18,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[719,"Chris Java","Chris Java","HTML 5 CSS Javascript","Developer Web","IT Dept","Mr IT",50,"Ateam","Ottawa",null,null,"PartTime","Human","Contract",7.5,25,"A411",44,null,20,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[800,"Product Owner/Sponsor","Prod Owner","Inventing","Product Owner/Sponsor","Office of CEO","Mario CEO",75,"Bteam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,21,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[801,"SME HR","SME HR","HR Policies","SME HR","HR Dept","Mario CEO",100,"Ateam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,22,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[802,"SME Finance","SME Finance","Finance Policies","SME Finance","Finance Dept","Mario CEO",50,"Bteam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,23,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[803,"SME Purchasing","SME Purchasing","Procurement","SME Purchasing","Office of CEO","Mario CEO",75,"Ateam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,24,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[804,"SME PM","SME PM","Project Management","SME PM","Office of CEO","Mario CEO",100,"Bteam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,25,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[805,"SME IT Platforms and Datacenter","SME IT PD","IT Architecture","SME IT Platforms and Datacenter","IT Dept","Mr IT",50,"Ateam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,26,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[806,"SME Cloud Technologies","SME Cloud","Azure and AWS","SME Cloud Technologies","IT Dept","Mr IT",75,"Bteam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,27,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[807,"SME Solution Architecture","SME SA","Enterprise Architect","SME Solution Architecture","IT Dept","Mr IT",100,"Ateam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,28,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[808,"Developer General","Developer General","Coder","Developer General","IT Dept","Mr IT",50,"Bteam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,29,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[809,"Developer Web","Dev Web","HTML 5 CSS Javascript","Developer Web","IT Dept","Mr IT",75,"Ateam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,30,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[810,"Developer SQL","Dev SQL","MS SQL and Oracle","Developer SQL","IT Dept","Mr IT",100,"Bteam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,31,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[811,"Developer ERP System","Dev ERP","SAP","Developer ERP System","Finance Dept","Mario CEO",50,"Ateam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,32,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[812,"Tester New Software","Tester New SW","Testing","Tester New Software","Engineering Dept","Sal Eng",75,"Bteam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,33,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[813,"Tester Platforms and Datacenter","Tester PD","Testing","Tester Platforms and Datacenter","Engineering Dept","Sal Eng",100,"Ateam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,34,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[814,"Engineer RF","Engineer RF","Radio Design","Engineer RF","Engineering Dept","Sal Eng",50,"Bteam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,35,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[815,"Engineer Hardware","Engineer HW","Board Design","Engineer Hardware","Engineering Dept","Sal Eng",75,"Ateam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,36,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[816,"Engineer Antennas","Engineer Ant","Antenna Design","Engineer Antennas","Engineering Dept","Sal Eng",100,"Bteam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,37,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]
[817,"Engineer Towers","Engineer Twr","Tower Design","Engineer Towers","Engineering Dept","Sal Eng",50,"Ateam","Ottawa",null,null,"Generic","Generic","NA",7.5,25,"A411",44,null,38,null,null,null,null,"External","jim@me.com",111111,111111,"a1"]

{"sheet":"Documents","index":3,"n_rows":44,"n_cols":22,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
["tbDocID","tbDocL1","tbDocL2","tbDocL3","tbDocL4","tbDocL5","tbDocName","tbDocNameShort","tbDocStatus","tbDocPurpose","tbDocWrittenBy","tbDocBriefDescription","tbDocType","tbDocHTMLContent","tbDocCardImage","tbDocGroup","tbDocOwner","tbDocPopular","tbDocSortOrder","tbDocLastModified","tbDocApprovedBy","tbDocCustomerID"]
["Timebars Documents"]
["Doc ID","L1","L2","L3","L4","L5","Doc Name","Name Short","Status","Purpose","Written By","Brief Description","Type","HTML Content","Card Image","Group","Owner","Popular","SortOrder","Last Modified","ApprovedBy","Customer ID"]
["1","Products","Agile Kanban Board","Agile Kanban Board",null,null,"Agile Kanban Board",null,null,null,null,null,"HTML","Agile Kanban Board",null,null,"Jim Cox","Yes","28",null,null,44]
["2","Products","Article Manager","Article Manager",null,null,"Article Manager",null,null,null,null,null,"HTML","Article Manager",null,null,"Jim Cox","Yes","19",null,null,44]
["3","Products","Cloud Publishing","Cloud Publishing",null,null,"Cloud Publishing",null,null,null,null,null,"HTML","Cloud Publishing",null,null,"Jim Cox","Yes","22",null,null,44]
["4","Products","Dashboards","Dashboards",null,null,"Dashboards",null,null,null,null,null,"HTML","Dashboards",null,null,"Jim Cox","Yes","24",null,null,44]
["5","Products","Data Grids","Data Grids",null,null,"Data Grids",null,null,null,null,null,"HTML","Data Grids",null,null,"Jim Cox","Yes","23",null,null,44]
["6","Marketing","Timebars Site","Demo","xxx","xxx","Demos","Demos","First Draft","Marketing Page","Jim Cox","TBD","HTML","<h3>Demos</h3>\n<a href=\"http://res.cloudinary.com/dbdibjgrn/video/upload/v1532633134/Timebars%20Demos/Album_Medium.mp4\">Timebars Launch Demo</a> <br>\n<a href=\"http://res.cloudinary.com/dbdibjgrn/video/upload/v1525521858/tbvideo_custom.mp4\">See Timebars live on 80 inch screen</a>\n","images/timebarslogogreen.png",null,"Jim Cox","Yes","20",null,null,44]
["7","Products","Dynamic Fields on FOCD Forms","Dynamic Fields on FOCD Forms",null,null,"Dynamic Fields on FOCD Forms",null,null,null,null,null,"HTML","Dynamic Fields on FOCD Forms",null,null,"Jim Cox","Yes","20",null,null,44]
["8","Marketing","Timebars Site","Feeback","xxx","xxx","Feedback","Feedback","First Draft","Marketing Page","Jim Cox","TBD","HTML","                    <h1>Feedback</h1>\n\n                    <p>\nPlease send us an email with any feedback to help us improve our product.\n                    </p>  ","images/timebarslogogreen.png",null,"Jim Cox","Yes","21",null,null,44]
["9","Products","FOCD Forms","FOCD Forms",null,null,"FOCD Forms",null,null,null,null,null,"HTML","FOCD Forms",null,null,"Jim Cox","Yes","21",null,null,44]
["10","Marketing","Timebars Site","Getting Started","xxx","xxx","Getting Started Help Page","Getting Started","First Draft","Timebar Help","Jim Cox","TBD","HTML"," <style type=\"text/css\">   @page { size: 21.59cm 27.94cm; margin-left: 2cm; margin-right: 1cm; margin-top: 1cm; margin-bottom: 1cm }   p { margin-bottom: 0.25cm; background: transparent; line-height: 115%; background: transparent }   h1 { margin-bottom: 0.21cm; background: transparent; background: transparent; page-break-after: avoid }   h1.western { font-family: \"Liberation Serif\", serif; font-size: 24pt; font-weight: bold }   h1.cjk { font-family: \"Noto Serif CJK SC\"; font-size: 24pt; font-weight: bold }   h1.ctl { font-family: \"Lohit Devanagari\"; font-size: 24pt; font-weight: bold }   h2 { margin-top: 0.35cm; margin-bottom: 0.21cm; background: transparent; page-break-after: avoid }   h2.western { font-family: \"Liberation Sans\", sans-serif; font-size: 16pt; font-weight: bold }   h2.cjk { font-family: \"WenQuanYi Micro Hei\"; font-size: 16pt; font-weight: bold }   h2.ctl { font-family: \"Lohit Devanagari\"; font-size: 16pt; font-weight: bold }   a:link { color: #000080; so-language: zxx; text-decoration: underline }   a:visited { color: #800000; so-language: zxx; text-decoration: underline }  </style> </head> <body lang=\"en-CA\" link=\"#000080\" vlink=\"#800000\" dir=\"ltr\"><p style=\"margin-bottom: 0cm; line-height: 100%\"> <br/>  </p> <h1 class=\"western\">Getting Started With Timebars</h1> <h2 class=\"western\">Initial Steps</h2> <ol>  <li><p style=\"margin-bottom: 0cm; line-height: 100%\">To get started,  click menu items Admin &gt; DB-Admin &gt; Go   </p>  <li><p style=\"margin-bottom: 0cm; line-height: 100%\">Look for  &quot;Success&quot; in red text top left, if successful, Click  Go-Timebars!   </p>  <li><p style=\"margin-bottom: 0cm; line-height: 100%\">You should see  the timescale Canvas and demo timebars! Drag bars to make start and  finish date changes.   </p>  <li><p style=\"margin-bottom: 0cm; line-height: 100%\">Click &quot;Show  Menu&quot; on top left of Canvas. Use this to filter timebars for  specific projects in Portfolios.   </p>  <li><p style=\"margin-bottom: 0cm; line-height: 100%\">Hover over the  Menu items, click on a Portfolio, Project or Sub-Project to display  filtered Timebars.   </p>  <li><p style=\"margin-bottom: 0cm; line-height: 100%\">Close the Menu,  Click on a Timebar title to see cost, schedule and metadata  information in Side Panel.   </p>  <li><p style=\"margin-bottom: 0cm; line-height: 100%\">To edit the  Timebar Title, begin typing in the Side Panel   </p>  <li><p style=\"margin-bottom: 0cm; line-height: 100%\">To change cost  and schedule data, move, stretch or shrink bars to suit.   </p>  <li><p style=\"margin-bottom: 0cm; line-height: 100%\">To change  Timescale and scheduling settings, click &quot;Settings button&quot;.   </p> </ol> <h2 class=\"western\">Make a Backup</h2> <p>Click the &quot;Data&quot; button on main menu, click Backup Now! This will save the data within text files to a destination of your choosing. The following files are saved</p> <ol>  <li><p style=\"margin-bottom: 0cm\">tbTimebars.txt (Timebars cost and  schedule Data File)   </p>  <li><p style=\"margin-bottom: 0cm\">tbMetaData.txt (Timebars Metadata  Data File)   </p>  <li><p style=\"margin-bottom: 0cm\">tbResources.txt (Resources Data  File)   </p>  <li><p style=\"margin-bottom: 0cm\">tbTags.txt (Tagging Data File)   </p>  <li><p style=\"margin-bottom: 0cm\">tbResCalcs.txt (Resource  Calculations Data File)   </p>  <li><p>tbConfigData.txt (Admin Panel Confi Data File)   </p> </ol> <h2 class=\"western\">How do I populate the system with my Project data?</h2> <p>Your data must be within a text file in JSON format with matching field names. Use the downloaded files to determine format.</p> <p>To upload your data, drag the text file onto the Canvas, Timebars will perform a backup then delete existing data and push the data from your text file into Timebars.  </p> <ol>  <li><p style=\"margin-bottom: 0cm\">Timebars Data File   </p>  <li><p style=\"margin-bottom: 0cm\">Metadata Data File   </p>  <li><p style=\"margin-bottom: 0cm\">Resources Data File   </p>  <li><p style=\"margin-bottom: 0cm\">Tagging Data File   </p>  <li><p style=\"margin-bottom: 0cm\">Resource Calculations Data File   </p>  <li><p>Admin Panel Confi Data File   </p> </ol>","images/timebarslogogreen.png",null,"Jim Cox","Yes","25",null,null,44]
["11","Marketing","Timebars Site","Home Page","xxx","xxx","Marketing Site Main Page","Marketing Site Main Page","First Draft","Marketing Page","Jim Cox","TBD","HTML",{"$cut":{"chars":20463,"head":"<div id=\"s9iPrd\" dir=\"ltr\" style=\"background: #000000\"><p><br/> <br/>  \t</p> </div> <div id=\"h.p_DAJ7LXC6sz7J\" dir=\"ltr\"><h1 class=\"western\" align=\"center\"> \tTimebars Products</h1> \t<p><a name=\"h.p_bed_r4fG9hyb\"></a>The following products are now \tavailable. They are advanced browser based planning &amp; scheduling \ttools with a rules engine designed to automate and simplify many \tmanagement scenarios. Our products fill the gaps left behind by ERP \t&amp; PPM enterprise systems and related Desktop Applications.</p> \t<div id=\"h.p_IQUeoQRiEtrO\" dir=\"ltr\"><p><br/> <br/>  \t\t</p> \t</div> \t<h3 class=\"western\"><a name=\"h.p_IQUeoQRiEtrO\"></a>Resource Planner \t&amp; Scheduler (RPS)</h3> \t<p><a name=\"h.p_nz4cqhm1WKUF\"></a><strong>This tool is for you if \tyou:</strong></p> \t<p><a name=\"h.p_JlpDzqsfX6uo\"></a>Use a Spreadsheet to track your \tpeople and wish it could figure out who is over allocated, who can \ttake on more work, and tell me if I need to hire.</p> \t<ol> \t\t<li><p><a name=\"h.p_e2CjSF6qE2pv\"></a>Are a manager of people, the \t\torganization's enterprise systems shows many demands for their \t\ttalent and its time consuming to weed through reports to make \t\tcommitments. You need to visualize this demand on a timescale in \t\tTimebars and perform what if scenarios.  \t\t</p> \t</ol> \t<div id=\"h.p_bk0P5_ZaYzJw\" dir=\"ltr\"><p><br/> <br/>  \t\t</p> \t</div> \t<h3 class=\"western\"><a name=\"h.p_bk0P5_ZaYzJw\"></a>Software Release \tScheduler (SRS)</h3> \t<p><a name=\"h.p_QENQsl9tY2gu\"></a><strong>This tool is for you if \tyou:</strong></p> \t<ul> \t\t<li><p><a name=\"h.p_4rgSfAwzY64Y\"></a>Live and breathe software \t\treleases in your organization, your people provide value such as BA \t\tInput, data seeding, testing, quality audits or other associated \t\twork. You utilize the corporate system to orchestrate the product \t\treleases but struggle with managing commitments so you use a \t\tspreadsheet tool to fill the gaps but this becomes time consuming \t\tto maintain. You need to visualize work on a timescale in Timebars \t\tand perform what if scenarios.  \t\t</p> \t</ul> \t<div id=\"h.p_LKk2J1vkE7WH\" dir=\"ltr\"><p><br/> <br/>  \t\t</p> \t</div> \t<h3 class=\"western\"><a name=\"h.p_LKk2J1vkE7WH\"></a>Sprint Planner &amp; \tScheduler (SPS)</h3> \t<p><a name=\"h.p_cIGsqC9BYpvx\"></a><strong>This tool is for you if \tyou:</strong></p> \t<ul> \t\t<li><p><a name=\"h.p_-nb1Xg_rYboL\"></a>Your organization invested \t\theavily in ERP, PPM and Support Desk ticketing systems and later \t\tdecided to go Agile and now the systems don't fit so a new Agile \t\tenterprise system is implemented. Your productivity is down, you \t\twish you could pull enterprise data from many sources, turn it into \t\tdecision making information and put the results back for others to \t\tleverage. You feel there must be a simple tool to pull in a \t\tbacklog, plan a sprint, track progress and produce burn-down \t\tcharts.  \t\t</p> \t</ul> \t<div id=\"h.p_pVChmd2BFHXM\" dir=\"ltr\"><p><br/> <br/>  \t\t</p> \t</div> \t<h3 class=\"western\"><a name=\"h.p_pVChmd2BFHXM\"></a>Initiative \tSpawner &amp; Scheduler (ISS)</h3> \t<p><a name=\"h.p_XIH9Iq38lUwu\"></a><strong>This tool is for you if \tyou:</strong></p> \t<ol> \t\t<li><p style=\"margin-bottom: 0cm\"><a name=\"h.p_mnVAcUB7lg_-\"></a>Work \t\tat a project delivery based organization, backed by complex \t\tenterprise system and its difficult to spawn and select initiatives \t\tfor the next planning period. You need flexible workflows that help \t\tdetermine and communicate investment value, dependencies and other \t\tmetadata, at the right level of detail that suits the initiative.  \t\t</p> \t\t<li><p style=\"margin-bottom: 0cm\"><a name=\"h.p_c5cIOTGAZlhr\"></a>Have \t\ta need for quickly spawning new initiatives with an adaptive \t\tworkflow that helps you evolve the business case, determine risk \t\tand policy driven phase gates with correct class of estimate. You \t\tworkflow is not a one size fits all, it changes constantly \t\tdepending on the product, the scope, the sponsor and many other \t\tfactors. Your initiative pipeline is fluid, projects are started, \t\tput on hold, cancelled resurrected or finished.  \t\t</p> \t\t<li><p><a name=\"h."}},"images/timebarslogogreen.png",null,"Jim Cox","Yes","15",null,null,44]
["12","Marketing","Timebars Site","How to Purchase","xxx","xxx","How to Purchase","How to Purchase","First Draft","Marketing Page","Jim Cox","TBD","HTML","\t<style type=\"text/css\">\n\t\t@page { size: 21.59cm 27.94cm; margin-left: 2cm; margin-right: 1cm; margin-top: 1cm; margin-bottom: 1cm }\n\t\tp { margin-bottom: 0.25cm; line-height: 115%; background: transparent }\n\t\th1 { margin-bottom: 0.21cm; background: transparent; page-break-after: avoid }\n\t\th1.western { font-family: \"Liberation Serif\", serif; font-size: 24pt; font-weight: bold }\n\t\th1.cjk { font-family: \"Noto Serif CJK SC\"; font-size: 24pt; font-weight: bold }\n\t\th1.ctl { font-family: \"Lohit Devanagari\"; font-size: 24pt; font-weight: bold }\n\t\ta:link { color: #000080; so-language: zxx; text-decoration: underline }\n\t\ta:visited { color: #800000; so-language: zxx; text-decoration: underline }\n\t</style>\n</head>\n<body lang=\"en-CA\" link=\"#000080\" vlink=\"#800000\" dir=\"ltr\"><h1 class=\"western\">\nHow to Purchase</h1>\n<p>Use your credit card to get started <br/>\nComing soon... \n</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","17",null,null,44]
["13","Marketing","Timebars Site","How to Return","xxx","xxx","How to return","How to return","First Draft","Marketing Page","Jim Cox","TBD","HTML","                    <h1>How to Return</h1>\n\n                    <p>\n                        There would be nothing to return because there is nothing installed and nothing resides on our servers. <br>\n                        If you no longer wish to pay for Timebars, send us an email and we will stop billing your credit card.\n                    </p>  ","images/timebarslogogreen.png",null,"Jim Cox","Yes","24",null,null,44]
["14","Marketing","Timebars Site","Kanban Help","xxx","xxx","Kanban help page 1","Getting Started","First Draft","Kanban Help","Jim Cox","TBD","HTML"," <style type=\"text/css\">   @page { size: 21.59cm 27.94cm; margin-left: 2cm; margin-right: 1cm; margin-top: 1cm; margin-bottom: 1cm }   p { margin-bottom: 0.25cm; background: transparent; line-height: 115%; background: transparent }   h1 { margin-bottom: 0.21cm; background: transparent; background: transparent; page-break-after: avoid }   h1.western { font-family: \"Liberation Serif\", serif; font-size: 24pt; font-weight: bold }   h1.cjk { font-family: \"Noto Serif CJK SC\"; font-size: 24pt; font-weight: bold }   h1.ctl { font-family: \"Lohit Devanagari\"; font-size: 24pt; font-weight: bold }   a:link { color: #000080; so-language: zxx; text-decoration: underline }   a:visited { color: #800000; so-language: zxx; text-decoration: underline }  </style> </head> <body lang=\"en-CA\" link=\"#000080\" vlink=\"#800000\" dir=\"ltr\"><p style=\"margin-bottom: 0cm; background: transparent; line-height: 100%\"> <br/>  </p> <p align=\"center\" style=\"margin-top: 0.42cm; margin-bottom: 0.21cm; background: transparent; line-height: 100%; page-break-after: avoid\"> <font face=\"Liberation Sans, sans-serif\"><font size=\"6\" style=\"font-size: 28pt\"><b>Get Started with Kanban Boards</b></font></font></p> <p style=\"margin-bottom: 0cm; background: transparent; line-height: 100%\"> <br/>  </p> <h1 class=\"western\">Why Use Kanban?</h1> <p style=\"margin-bottom: 0cm; background: transparent; line-height: 100%\"> <br/>  </p> <h1 class=\"western\">How to use the Timebars Kanban</h1> <ul>  <li><p style=\"margin-top: 0.1cm; margin-bottom: 0cm; background: transparent; line-height: 100%\">  To get started, click menu item DB-Admin &gt; Go.   </p>  <li><p style=\"margin-bottom: 0cm; background: transparent; line-height: 100%\">  Click Go-TbKanban to load up Kanban board.   </p>  <li><p style=\"margin-bottom: 0cm; background: transparent; line-height: 100%\">  The black round icons indicate sub-projects, click on a subproject  &quot;Title&quot; to launch Kanban bars.   </p>  <li><p style=\"margin-bottom: 0cm; background: transparent; line-height: 100%\">  To create a new Kanbar Bar, drag and drop the sub-project title onto  the Canvas.   </p>  <li><p style=\"margin-bottom: 0cm; background: transparent; line-height: 100%\">  The bar will be in edit mode, change data to suit. When done adding  items, click refresh.   </p>  <li><p style=\"margin-bottom: 0cm; background: transparent; line-height: 100%\">  Move bars around to suit, to edit click Edit Mode button on menu.   </p> </ul>","images/timebarslogogreen.png",null,"Jim Cox","Yes","27",null,null,44]
["15","Marketing","Timebars Site","Licencing","xxx","xxx","Licensing","Licensing","First Draft","Marketing Page","Jim Cox","TBD","HTML","<h1>Licensing</h1>\n<p>We plan to charge monthly subscription fee.</p>\n<p>We have a free version but does not allow saving your data.</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","19",null,null,44]
["16","Marketing","Timebars Site","Our Expertise",null,null,"Our Expertise",null,null,null,null,null,"HTML"," <style type=\"text/css\">   @page { size: 21.59cm 27.94cm; margin: 2cm }   p { margin-bottom: 0.25cm; line-height: 115%; background: transparent; page-break-before: auto }   p.western { font-family: \"Calibri\", sans-serif }   h1 { margin-bottom: 0.21cm; background: transparent; page-break-before: auto; page-break-after: avoid }   h1.western { font-family: \"Liberation Sans\", sans-serif; font-size: 18pt; font-weight: bold }   h1.cjk { font-family: \"WenQuanYi Micro Hei\"; font-size: 18pt; font-weight: bold }   h1.ctl { font-family: \"Lohit Devanagari\"; font-size: 18pt; font-weight: bold }  </style> </head> <body lang=\"en-CA\" link=\"#000080\" vlink=\"#800000\" dir=\"ltr\"><p align=\"center\" style=\"margin-top: 0.42cm; margin-bottom: 0.21cm; line-height: 100%; page-break-after: avoid\"> <font face=\"Liberation Sans, sans-serif\"><font size=\"6\" style=\"font-size: 28pt\"><b>Business Expertise</b></font></font></p> <h1 class=\"western\">Project Managent <font face=\"Calibri, sans-serif\">P</font>rocesses</h1> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><font face=\"Calibri, sans-serif\">I</font>nformation Technology Business <font face=\"Calibri, sans-serif\">S</font>ystems</p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\">Implementations, including Scope, Scheduling, Cost, Risk, Communications and Integration Management.</p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><br/>  </p> <h1 class=\"western\">Project Reporting and Dashboards</h1> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\">Systems design and implementation from all kinds of data sources including SAP, Oracle, Project Server, SharePoint and many others.</p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><br/>  </p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><font face=\"Liberation Sans, sans-serif\"><font size=\"5\" style=\"font-size: 18pt\"><b>Resource Management and organizational change</b></font></font></p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\">Reviews, recommendations and implementations based on Microsoft Project Pro and Project Sever including Timesheets.</p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><br/>  </p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><font face=\"Liberation Sans, sans-serif\"><font size=\"5\" style=\"font-size: 18pt\"><b>Project Portfolio Management</b></font></font></p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\">Rreviews, process recommendations and configuration of Microsoft Project Server Portfolio Management component including Project Intake Workflows, custom forms.</p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><br/>  </p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><font face=\"Liberation Sans, sans-serif\"><font size=\"5\" style=\"font-size: 18pt\"><b>Other Business productivity problem</b></font></font></p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\">Solving <font face=\"Calibri, sans-serif\">data</font> integration problems with technologies such as REST, HTML5, CSOM, InfoPath, SSRS, Excel, Outlook, Access and many others.</p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><br/>  </p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><font face=\"Liberation Sans, sans-serif\"><font size=\"5\" style=\"font-size: 18pt\"><b>Document and Records Management</b></font></font></p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\">Systems reviews, recommendations and implementations with Microsoft SharePoint Server and associated systems.</p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><br/>  </p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><font face=\"Liberation Sans, sans-serif\"><font size=\"5\" style=\"font-size: 18pt\"><b>Cost/Schedule Integration</b></font></font></p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\">With ERP Systems and <font face=\"Calibri, sans-serif\">Project Management Tools of all kinds.</font></p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><br/>  </p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\"><font face=\"Liberation Sans, sans-serif\"><font size=\"5\" style=\"font-size: 18pt\"><b>Earned Value Management</b></font></font></p> <p class=\"western\" style=\"margin-bottom: 0cm; line-height: 100%\">Systems review, design and custom implementations</p>",null,null,"Jim Cox","Yes","17",null,null,44]
["17","Process","Project Estimating","Project Estimating","xxx","xxx","Estimating Process","Common help topics","First Draft","Common Help","Jim Cox","TBD","HTML","<h1>Estimating Process</h1>\n<p>For complex or sizeable projects, five categories of estimates are prepared. The process begins with the development of an initial estimate that is further developed during the early phases of the project. It is recommended that Cost Planners be involved in preparing overall project.</p>\n<h3><strong>Broad Cost Projection</strong></h3>\n<p>Based on historical data from similar projects, indicates a budget for resources to develop a project as well whether or not total project costs are expected to exceed $1&nbsp;million. This is not a construction estimate.</p>\n<h3><strong>Class&nbsp;'D' (Indicative) Estimate</strong></h3>\n<p>To be in unit cost analysis format (such as cost per mÂ² or other measurement unit) based upon a comprehensive list of project requirements (i.e. scope) and assumptions; the Class D estimate is evolved throughout the phases of the Project Identification Stage, finally being incorporated into the cash flows in the Analysis Phase; for more complex projects such as laboratories, elemental cost analysis and the input of specific disciplines may be required;&nbsp;<em>the Class D Indicative estimates developed during the National Project Management System (NPMS) Feasibility Phase shall be revisited with cost planners in the Analysis Phase before finalizing.</em></p>\n<h3><strong>Class&nbsp;'C' Estimate</strong></h3>\n<p>To be in elemental cost analysis format latest edition issued by the Canadian Institute of Quantity Surveyors and based on a comprehensive list of requirements and assumptions, including a full description of the preferred schematic design option, construction/design experience, and market conditions;&nbsp;<em>Class C estimates are developed during the&nbsp;NPMS&nbsp;Design Phase</em></p>\n<h3><strong>Class&nbsp;'B' (Substantive) Estimate</strong></h3>\n<p>To be in elemental cost analysis format latest edition issued by the Canadian Institute of Quantity Surveyors and based on design development drawings and outline specifications, which include the design of all major systems and subsystems, as well as the results of all site/installation investigations;&nbsp;<em>Class B estimates are developed during the&nbsp;NPMS&nbsp;Design Phase;</em></p>\n<h3><strong>Class&nbsp;'A' (Pre-Tender) Estimate</strong></h3>\n<p>To be in both elemental cost analysis format as well as trade divisional format latest edition issued by the Canadian Institute of Quantity Surveyors and based on completed construction drawings and specifications prepared prior to calling competitive tenders. The Class 'A' Estimate is generally expected to be within 5% to 10% of the actual contract award price for new construction. Tendering risks should be included in the project risk plan and costed accordingly. The accuracy of Class 'A' estimates can be influenced by many factors, including complexity of project, volatile market, remote locations, tight schedules, and unclear contract documents;&nbsp;<em>Class 'A' estimates are prepared during the&nbsp;NPMS&nbsp;Implementation Phase and can be a more accurate Substantive Estimate, depending on the complexity of the project;</em></p>\n<p>Note: from Public Services and Procurement Canada</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","28",null,null,44]
["18","Process","Project Gating","Project Gating Large","xxx","xxx","Large Project – Gate 4 Project charter and project management plan (PMP)","Gate 4 Project charter and project management plan (PMP)","Approved","Gate Help","Jim Cox","To address business case unknowns. A complete project charter, high-level PMP, and definition of the business solution are prerequisites for this gate.","HTML","<style type=\"text/css\">        @page { size: 21.59cm 27.94cm; margin: 2.54cm }        p { margin-bottom: 0.25cm; direction: ltr; line-height: 115%; text-align: left; orphans: 2; widows: 2; background: transparent }        h1 { margin-bottom: 0cm; direction: ltr; color: #000000; text-align: left; page-break-inside: avoid; orphans: 2; widows: 2; background: transparent; page-break-after: avoid }        h1.western { font-family: \"Calibri Light\", serif; font-size: 16pt }        h1.cjk { font-family: \"Calibri\"; font-size: 16pt }        h1.ctl { font-family: \"Calibri\"; font-size: 16pt }    </style></head><body lang=\"en-CA\" link=\"#000080\" vlink=\"#800000\" dir=\"ltr\"><p align=\"center\" style=\"margin-top: 0.85cm; margin-bottom: 0.21cm; line-height: 100%; page-break-inside: avoid; page-break-after: avoid\"><font size=\"6\" style=\"font-size: 22pt\"><b>Gate 4 - Project Charter</b></font></p><h1 class=\"western\">Purpose </h1><p style=\"margin-bottom: 0.28cm; line-height: 108%\">To addressbusiness case unknowns. A complete project charter, high-level PMP,and definition of the business solution are prerequisites for thisgate. Any business case unknowns should be resolved here (or a planin place to resolve them). Project cost and schedule estimates forthe entire project should be ±25%. </p><h1 class=\"western\">Review issues </h1><ul>    <li><p align=\"left\" style=\"margin-bottom: 0cm; border: none; padding: 0cm; font-variant: normal; font-style: normal; font-weight: normal; line-height: 108%; page-break-inside: auto; orphans: 2; widows: 2; text-decoration: none; page-break-after: auto\">    <font color=\"#000000\"><font face=\"Calibri, serif\"><font size=\"2\" style=\"font-size: 11pt\">Validation    that the project charter has addressed all issues critical for a    successful project </font></font></font>    </p>    <li><p align=\"left\" style=\"margin-bottom: 0.28cm; border: none; padding: 0cm; font-variant: normal; font-style: normal; font-weight: normal; line-height: 108%; page-break-inside: auto; orphans: 2; widows: 2; text-decoration: none; page-break-after: auto\">    <font color=\"#000000\"><font face=\"Calibri, serif\"><font size=\"2\" style=\"font-size: 11pt\">Confirmation    that proper project governance, planning, and management are in    place </font></font></font>    </p></ul><h1 class=\"western\">Why</h1><ul>    <li><p align=\"left\" style=\"margin-bottom: 0cm; border: none; padding: 0cm; font-variant: normal; font-style: normal; font-weight: normal; line-height: 108%; page-break-inside: auto; orphans: 2; widows: 2; text-decoration: none; page-break-after: auto\">    <font color=\"#000000\"><font face=\"Calibri, serif\"><font size=\"2\" style=\"font-size: 11pt\">To    ensure that all necessary ingredients for successful execution are    in place prior to construction and implementation </font></font></font>    </p>    <li><p align=\"left\" style=\"margin-bottom: 0.28cm; border: none; padding: 0cm; font-variant: normal; font-style: normal; font-weight: normal; line-height: 108%; page-break-inside: auto; orphans: 2; widows: 2; text-decoration: none; page-break-after: auto\">    <font color=\"#000000\"><font face=\"Calibri, serif\"><font size=\"2\" style=\"font-size: 11pt\">To    reduce the risk of having to introduce quick fixes later </font></font></font>    </p></ul><h1 class=\"western\">Core review items for this gate </h1><p style=\"margin-bottom: 0.28cm; line-height: 108%\">1. Reconfirmationof business case, particularly feasibility of realizing outcomes,assumptions, constraints, and dependencies:</p><ul>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Refinement    of estimates and estimating assumptions     </p></ul><p style=\"margin-bottom: 0.28cm; line-height: 108%\">2. Reconfirmationof readiness to undertake the project </p><p style=\"margin-bottom: 0.28cm; line-height: 108%\">3. Completenessof the project charter:</p><ul>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Absolute    clarity of definition, and what is in and out of project scope</p>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Clarity of    roles, project sponsor, stakeholders, and governance     </p></ul><ul>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Documented    definition of success, business outcomes and how they will be    measured, and clarity of accountability for attaining the business    outcomes</p>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Summary of    approach, with a focus on roles, governance, and risks     </p>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Identification    of risks and assessment of whether risks are contained well enough    to proceed     </p></ul><p style=\"margin-bottom: 0.28cm; line-height: 108%\">4. Definition ofbusiness solution:</p><ul>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Business    architecture or model     </p>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Solution    description, including high-level program design and business model;    business transformation strategy and business process re-engineering    strategy, if applicable     </p>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">High-level    functional requirements, and technical and performance requirements         </p>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">High-level    data model and data considerations     </p>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">High-level    functional design and concept of operations Commercial off-the-shelf    options assessment, if applicable     </p></ul><p style=\"margin-bottom: 0.28cm; line-height: 108%\">5. High-levelPMP:</p><ul>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Elaboration    of the project plan (work breakdown structure) and link to estimated    costs and schedule \\Requirements-gathering workshop</p>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Procurement    plan—Is it achievable in project time?     </p>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Business    change management strategy and ability to be absorbed by    organization     </p>    <li><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Business    deployment strategy, including data issues     </p></ul><p style=\"margin-bottom: 0.28cm; line-height: 108%\">6. Skeleton PMOin place, suitable project manager identified, and key projectstaffing initiated</p><h1 class=\"western\"><font size=\"4\" style=\"font-size: 14pt\">Supportingitem(s)</font> </h1><p style=\"margin-bottom: 0.28cm; line-height: 108%\">1. Updated planand estimate (±10%) for tasks and level of effort to next projectgate </p><p style=\"margin-bottom: 0.28cm; line-height: 108%\"> A Guide toProject Gating for IT-Enabled Projects</p><h1 class=\"western\"><font size=\"4\" style=\"font-size: 14pt\">Typicalinput to the review </font></h1><p style=\"margin-bottom: 0.28cm; line-height: 108%\"><a name=\"_heading=h.gjdgxs\"></a>Updated business case, Project charter standard, Preliminary PMP,Solution description </p><h1 class=\"western\"><font size=\"4\" style=\"font-size: 14pt\">Reviewformat </font></h1><p style=\"margin-bottom: 0.28cm; line-height: 108%\">Full review forlarger projects or quick review as considered appropriate forsmaller, low-risk initiatives </p></body>","images/timebarslogogreen.png",null,"Jim Cox","Yes","0",null,null,44]
["19","Process","Project Gating","Project Gating Large","xxx","xxx","Large Project – Gate 5 Detailed project plan and functional specifications","Gate 5 Detailed project plan and functional specifications","Approved","Gate Help","Jim Cox","To confirm the completeness and feasibility of the detailed project plan and definition of requirements.","HTML","<h1>Purpose: Gate 5 Detailed project plan and functional specifications</h1>\n<p><strong>To answer the key questions, How?</strong>&nbsp;The most feasible project options are considered here and the preferred option recommended. The project approach is now fully articulated. A high-level project plan has been tabled, upon which preliminary costing is based. The business case should include an investment rationale and describe outcomes to be achieved, as well as their justification relative to the proposed cost. Project cost and schedule estimates for the entire project should be in the 40% range. (Ranges assume a typical development or integration project where there are many unknowns at the early stages. An infrastructure replacement project might have a much smaller estimating range.)</p>\n<h1>Review issues</h1>\n<p>Assurance that the business case is thorough, complete, and compelling</p>\n<p>Confirmation that the organization is ready to undertake the project</p>\n<h1>Why</h1>\n<p>To confirm that the business case is sufficiently compelling to justify, sustain, and guide the project</p>\n<p>To identify any shortcomings in readiness for action before approval and confirm that key identified risks can be managed</p>\n<h1>Core review items for this gate</h1>\n<ol>\n<li>Business case requirements:</li>\n</ol>\n<ul>\n<li>Clarity of business problem statement</li>\n<li>Clarity and precision of project goals must be sufficiently clear to provide focussed outcomes, and guide what is in and out of project scope</li>\n<li>Clear business justification for the project investment, including how goals can be quantified and measured, and their attainment confirmed</li>\n<li>Reconfirmation of the alignment of the project with organization s goals</li>\n<li>Thoroughness of options analysis, including reasonableness of costs and benefits for each option and reasonableness of selected option</li>\n<li>Indicative cost estimate and schedule</li>\n<li>Estimating methodology, basis for assumptions, and sensitivity analysis</li>\n</ul>\n<ol start=\"2\">\n<li>Organizational readiness to undertake the project:</li>\n</ol>\n<p>Arrangements decided upon Project Management Office (PMO), strategies for outcome management, performance management, and risk management</p>\n<ul>\n<li>Initial project planning under way and mechanisms in place</li>\n<li>Business requirements approach fully defined</li>\n<li>Preparation of environment in which to run project</li>\n<li>Assessment of organizational capacity relative to project difficulty (OPMCA)</li>\n<li>Evidence of intent and ability to create an environment for project success</li>\n<li>A Guide to Project Gating for IT-Enabled Projects 17</li>\n</ul>\n<h1>Supporting item(s)</h1>\n<ol>\n<li>Complete definition of the project:</li>\n</ol>\n<ul>\n<li>Project complexity and risk levels, scope, size, and packaging</li>\n<li>Risks, constraints, and dependencies (PCRA)</li>\n<li>Architecture and technological alignment (within federal government and department)</li>\n<li>Privacy issues (Privacy Impact Assessment, or PIA), security issues (Threat and Risk Assessment, or TRA), and other policy issues</li>\n</ul>\n<ol start=\"2\">\n<li>Updated plan and estimate (10%) for tasks, level of effort to next project gate</li>\n<li>PCRA and OPMCA</li>\n</ol>\n<h1>Typical input to the review</h1>\n<p>Business case standard, and detailed supporting analysis and documentation</p>\n<p>PCRA</p>\n<p>OPMCA</p>\n<p>The Rubik's Cube the most popular puzzle. Learn the <a href=\"https://ruwix.com/the-rubiks-cube/how-to-solve-the-rubiks-cube-beginners-method/\" target=\"_blank\">easiest solution here</a>.</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","1",null,null,44]
["20","Process","Project Gating","Project Gating Large","xxx","xxx","Large Project – Gate 6 Construction complete and deployment readiness","Gate 6 Construction complete and deployment readiness","Approved","Gate Help","Jim Cox","To verify that the system under development is ready for implementation and that the project is fully prepared for a successful deployment.","HTML","<h1>Purpose: Gate 6 Construction complete and deployment readiness</h1>\n<p>To verify that the system under development is ready for implementation and that the project is fully prepared for a successful deployment. This gate represents a major point of approval for business readiness. There may be only one or a number of sub-gates and sub-gate reviews related to construction and deployment. (Other gateway approaches reviewed tended to treat construction or construction and deployment as one gate. This is perhaps because the projects under consideration were small or because there is an assumption that construction and deployment are well understood and have relatively low risk.) Based on the given situation and the degree of risk, the department should decide on the number, timing, and focus area for intermediate Gate 6 reviews during construction and deployment. For example, depending on the project structure, a gate could be established at the completion of a major development release or at the completion of a major rollout and deployment to a specified set of users. (See Notes on Gate 6 )</p>\n<h1>Review issues</h1>\n<p>Verification that construction is complete with user acceptance testing and migration to production firmly based on meeting acceptance criteria that support proceeding with deployment ? Confirm that deployment teams have been established and are prepared to manage a smooth transition</p>\n<h1>Why</h1>\n<p>To ensure the project is ready to proceed with deployment, and that system migration plans and ongoing support are in place</p>\n<p>Core review items for this gate</p>\n<ol>\n<li>Reconfirmation that the project is aligned with departmental goals, the business case is valid, and expected outcomes will occur</li>\n<li>Construction complete and deliverables, including all documentation, accepted</li>\n<li>System migrated to production, and user acceptance testing complete</li>\n<li>Business change management, deployment, training, data migration, and conversion plans complete</li>\n<li>System migration plan validated</li>\n<li>Ongoing support and service management plans in place</li>\n<li>Vulnerability assessment complete</li>\n<li>Overall business and project readiness</li>\n</ol>\n<h1>Supporting item(s)</h1>\n<ol>\n<li>Updated plan and estimate (10%) for tasks and level of effort to project close-out</li>\n</ol>\n<h1>Typical input to the review</h1>\n<p>All sign-offs for user acceptance, production acceptance by operations, security certification and accreditation to go into production, maintenance team acceptance of documentation ? Deployment, training, data migration and system migration plans, and vulnerability assessment approved</p>\n<p>Support and service management plan&nbsp;</p>\n<p>Disaster recovery and business resumption plans</p>\n<h1>Review format</h1>\n<p>Quick or full review, depending on project size, risk, and complexity</p>\n<h1>Notes on Gate 6</h1>\n<p>Projects may adopt a variety of phasing approaches, and not all phasing approaches will be sequential. Some may be structured with parallel phases, making the choice of gates and the scope of gate reviews more subjective. In the case of large iterative development methodologies, gates and review points would ideally be established to ensure that development is moving toward closure that the iterations would not continue indefinitely or until the project runs out of time and money. The focus, then, is on the sign-offs against what has been delivered and on the clear agreement on what remains to be done. Examples of intermediate gates within the purview of Gate 6 include:</p>\n<p>Construction release completion In a project that is structured to have multiple major releases, it is recommended that a gate be established at the completion of one or more of these releases.</p>\n<p>Mid-phase health check A health check could be established in the middle of a project phase even if no major deliverables have been completed or decision points reached. The decision to do so might be based on some combination of dollars spent (e.g., $25 million), time elapsed (e.g., one year), and rate of expenditure (e.g., $2 million per month).</p>\n<p>Construction and deployment readiness In many projects, deployment activities and construction actually occur in parallel. In some cases, deployment occurs after the completion of construction. Depending on the nature and size of the project, a gate might be established to create a decision point about whether or not to deploy.&nbsp;</p>\n<p>Pilot deployment and full deployment readiness In some projects, a pilot deployment occurs immediately following the construction phase as a basis for deciding whether the system is ready for general deployment. This might be an appropriate point at which to establish a gate, depending on the size and nature of the project.</p>\n<p>24</p>\n<p>The Rubik's Cube seems to be an impossible puzzle but it's <a href=\"https://ruwix.com/the-rubiks-cube/how-to-solve-the-rubiks-cube-beginners-method/\" rel=\"nofollow noopener\">easy to solve</a> using just a few algorithms.</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","4",null,null,44]
["21","Process","Project Gating","Project Gating Large",null,null,"Large Project – Gate 7 Post-implementation review","Gate 7 Post-implementation review","Approved","Gate Help","Jim Cox","To confirm completion, assess the extent to which the project has achieved its goals, and provide an assessment of value for money.","HTML","<h1>Purpose Gate 7 Post-implementation review</h1>\n<p>To confirm completion, assess the extent to which the project has achieved its goals, and provide an assessment of value for money. This gate typically occurs approximately six months following project completion. A review at this point can also catalogue the lessons learned during the project those identified by the project group and those captured by independent reviewers.</p>\n<h1>Review issues</h1>\n<p>Verify that the project was completed as planned and that the expected business outcomes were actually realized ? Assess the degree of success for the transition to an ongoing service&nbsp;</p>\n<h1>Why</h1>\n<p>To confirm success from a project delivery and business perspective ? To determine what lessons might benefit the department and the broader community in future undertakings</p>\n<h1>Core review items for this gate</h1>\n<ol>\n<li>Project delivery measured against original objectives</li>\n<li>Confirmation of the archiving of information and deliverables, as applicable</li>\n<li>Knowledge transfer and transition to successful service</li>\n<li>Completion of contractual obligations</li>\n<li>Validation of business outcomes</li>\n<li>Capture of lessons learned, including review process</li>\n<li>Project close-out report completed</li>\n</ol>\n<h1>Typical input to the review</h1>\n<ul>\n<li>Project close-out report</li>\n<li>Business outcomes measurement plan</li>\n<li>Contract acceptance reports</li>\n<li>Project lessons learned</li>\n</ul>\n<h1>Review format</h1>\n<p>Workshop to full review, depending on project</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","5",null,null,44]
["22","Process","Project Gating","Project Gating Large","xxx","xxx","Large Project - Gate 1 Strategic assessment and concept","Gate 1 Strategic assessment and concept","Approved","Gate Help","Jim Cox","To answer the key questions What do we want to do? and Why?","HTML","<h1>Purpose Gate 1 Strategic assessment and concept</h1>\n<p>To answer the key questions What do we want to do? and Why? The objectives at this early stage are to test the wisdom and appropriateness of the proposed undertaking, and to ensure that key stakeholders are identified, and that everyone understands what is to be done and why. A half- to one-day workshop session is typical, preceded by reading of any available early project documents. The Gate 1 review seeks to arm the review sponsor with considerations that should be addressed before the next phase of the project and, in some cases, may actually dictate going back to the drawing board before proceeding further.</p>\n<h1>Review issues</h1>\n<ul><li>Validation of the rationale for the project</li><li> Confirmation that underlying fundamentals make sense&nbsp;</li><li> Assessment that the project is doable as proposed</li></ul>\n<h1>Why</h1>\n<p>To eliminate ideas that do not make sense or will prove to be impossible to execute</p>\n<h1>Core review items for this gate</h1>\n<ol>\n<li>Wisdom and appropriateness of proposed undertaking</li>\n<li>Articulation of the business problem and validity of the business imperative</li>\n<li>Definition and boundaries of scope</li>\n<li>Definition and measures of success</li>\n<li>Degree of common understanding about the proposal among parties involved</li>\n<li>Identification of stakeholders and extent of support and commitment for the initiative</li>\n<li>Confirmation that the project makes sense in the context of the departmental project portfolio and federal government priorities&nbsp;</li>\n</ol>\n<h1>Supporting item(s)</h1>\n<ol>\n<li>Plan and estimate (10%) for tasks and level of effort to next project gate</li>\n</ol>\n<h1>Typical input to the review</h1>\n<p>The project group provides reviewers with an understanding of why the project is being proposed, what it is intended to accomplish, and how it is defined. Supporting information to position the full context of the proposal might include reference to departmental reports and plans as well as an overview of the departments main business lines.</p>\n<p>The following areas need to be addressed:</p>\n<ol>\n<li>The concept and imperative of the project, including identification of the project sponsor, the business problem statement in the context of the overall business strategy, the broad scope of the project, expected general business outcomes and indicators of success, key stakeholders, general business risks, approximate sizing of the project, and critical success factors.</li>\n<li>The alignment of the project proposal with departmental Program Activity Architecture, program(s) delivery, departmental plans and priorities, broader federal government or cross-departmental goals, as appropriate, and positioning of the project in the context of the departmental information management and IT portfolio (including reference to departmental architectures). The positioning might also reference TBS-sponsored shared or common services and cluster initiatives, if relevant.</li>\n<li>Review format Workshop review (conducting a few targeted interviews may be necessary)</li>\n</ol>\"","images/timebarslogogreen.png",null,"Jim Cox","Yes","6",null,null,44]
["23","Process","Project Gating","Project Gating Large","xxx","xxx","Large Project - Gate 2 Approach","Gate 2 Approach","Approved","Gate Help","Jim Cox","To answer the key questions What do we want to do? and Why?","HTML","<p>Purpose&nbsp;Gate 2 Project approach</p><p>To confirm that the approach selected to address the business problem or opportunity is both feasible and appropriate.</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","6",null,null,44]
["24","Process","Project Gating","Project Gating Large","xxx","xxx","Large Project - Gate 3 Business case and general readiness","Gate 3 Business case and general readiness","Approved","Gate Help","Jim Cox","To answer the key question: How?","HTML","<h1>Purpose Gate 3 Business case and general readiness:</h1>\n<p><strong>To answer the key question How?</strong>&nbsp;The most feasible project options are considered here and the preferred option recommended. The project approach is now fully articulated. A high-level project plan has been tabled, upon which preliminary costing is based. The business case should include an investment rationale and describe outcomes to be achieved, as well as their justification relative to the proposed cost. Project cost and schedule estimates for the entire project should be in the 40% range. (Ranges assume a typical development or integration project where there are many unknowns at the early stages. An infrastructure replacement project might have a much smaller estimating range.)</p>\n<h1>Review issues</h1>\n<p>Assurance that the business case is thorough, complete, and compelling</p>\n<p>Confirmation that the organization is ready to undertake the project</p>\n<h1>Why</h1>\n<p>To confirm that the business case is sufficiently compelling to justify, sustain, and guide the project</p>\n<p>To identify any shortcomings in readiness for action before approval and confirm that key identified risks can be managed</p>\n<h1>Core review items for this gate</h1>\n<ol>\n<li>Business case requirements:</li>\n</ol>\n<ul>\n<li>Clarity of business problem statement</li>\n<li>Clarity and precision of project goals must be sufficiently clear to provide focussed outcomes, and guide what is in and out of project scope</li>\n<li>Clear business justification for the project investment, including how goals can be quantified and measured, and their attainment confirmed</li>\n<li>Reconfirmation of the alignment of the project with organizations goals</li>\n<li>Thoroughness of options analysis, including reasonableness of costs and benefits for each option and reasonableness of selected option</li>\n<li>Indicative cost estimate and schedule</li>\n<li>Estimating methodology, basis for assumptions, and sensitivity analysis</li>\n</ul>\n<ol start=\"2\">\n<li>Organizational readiness to undertake the project:</li>\n</ol>\n<ul>\n<li>Arrangements decided upon Project Management Office (PMO), strategies for outcome management, performance management, and risk management</li>\n<li>Initial project planning under way and mechanisms in place</li>\n<li>Business requirements approach fully defined</li>\n<li>Preparation of environment in which to run project</li>\n<li>Assessment of organizational capacity relative to project difficulty (OPMCA)</li>\n<li>Evidence of intent and ability to create an environment for project success</li>\n<li>A Guide to Project Gating for IT-Enabled Projects 17</li>\n</ul>\n<h1>Supporting item(s)</h1>\n<ol>\n<li>Complete definition of the project:</li>\n</ol>\n<ul>\n<li>Project complexity and risk levels, scope, size, and packaging</li>\n<li>Risks, constraints, and dependencies (PCRA)</li>\n<li>Architecture and technological alignment (within federal government and department)</li>\n<li>Privacy issues (Privacy Impact Assessment, or PIA), security issues (Threat and Risk Assessment, or TRA), and other policy issues</li>\n</ul>\n<ol start=\"2\">\n<li>Updated plan and estimate (10%) for tasks, level of effort to next project gate</li>\n<li>PCRA and OPMCA</li>\n</ol>\n<h1>Typical input to the review</h1>\n<p>Business case standard, and detailed supporting analysis and documentation</p>\n<p>PCRA</p>\n<p>OPMCA</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","3",null,null,44]
["25","Process","Project Gating","Project Gating Medium","xxx","xxx","Medium Project- Gate 4 Pre-Deployment","Gate 4 Pre-Deployment","First Draft","Gate Help","Jim Cox","TBD","HTML","<p>Purpose:&nbsp;&nbsp;Gate 4 Pre-Deployment</p><p>To ensure that the resources, support and governance necessary for successful execution are in place prior to construction</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","10",null,null,44]
["26","Process","Project Gating","Project Gating Medium","xxx","xxx","Medium Project - Gate 5 Post Implementation","Gate 5 Post Implementation","First Draft","Gate Help","Jim Cox","TBD","HTML","<p>Purpose:&nbsp;Gate 5 Post Implementation</p><p>To confirm completion, assess the extent to which the project has achieved its goals, and provide an assessment of value for money.</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","11",null,null,44]
["27","Process","Project Gating","Project Gating Medium","xxx","xxx","Medium Project - Gate 1 Project approach","Gate 1 Project approach","First Draft","Gate Help","Jim Cox","To confirm that the approach selected to address the business problem or opportunity is both feasible and appropriate.","HTML","<p>Purpose&nbsp;Gate 1 Project approach</p><p>To confirm that the approach selected to address the business problem or opportunity is both feasible and appropriate.</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","8",null,null,44]
["28","Process","Project Gating","Project Gating Medium","xxx","xxx","Medium Project - Gate 2 Business case and general readiness","Gate 2 Business case and general readiness","First Draft","Gate Help","Jim Cox","TBD","HTML","<p>Purpose&nbsp;Gate 2 Business case and general readiness</p><p>To confirm that the business case is sufficiently compelling to justify, sustain and guide the project; to identify any shortcomings in readiness for action before approval; and to confirm that key identified risks can be managed.</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","7",null,null,44]
["29","Process","Project Gating","Project Gating Medium","xxx","xxx","Medium Project - Gate 3 Pre-Construction","Gate 3 Business case and general readiness","Approved","Gate Help","Jim Cox","To answer the key question: How?","HTML","<h1>Purpose Gate 3 Business case and general readiness:</h1>\n<p><strong>To answer the key question How?</strong>&nbsp;The most feasible project options are considered here and the preferred option recommended. The project approach is now fully articulated. A high-level project plan has been tabled, upon which preliminary costing is based. The business case should include an investment rationale and describe outcomes to be achieved, as well as their justification relative to the proposed cost. Project cost and schedule estimates for the entire project should be in the 40% range. (Ranges assume a typical development or integration project where there are many unknowns at the early stages. An infrastructure replacement project might have a much smaller estimating range.)</p>\n<h1>Review issues</h1>\n<p>Assurance that the business case is thorough, complete, and compelling</p>\n<p>Confirmation that the organization is ready to undertake the project</p>\n<h1>Why</h1>\n<p>To confirm that the business case is sufficiently compelling to justify, sustain, and guide the project</p>\n<p>To identify any shortcomings in readiness for action before approval and confirm that key identified risks can be managed</p>\n<h1>Core review items for this gate</h1>\n<ol>\n<li>Business case requirements:</li>\n</ol>\n<ul>\n<li>Clarity of business problem statement</li>\n<li>Clarity and precision of project goals must be sufficiently clear to provide focussed outcomes, and guide what is in and out of project scope</li>\n<li>Clear business justification for the project investment, including how goals can be quantified and measured, and their attainment confirmed</li>\n<li>Reconfirmation of the alignment of the project with organizations goals</li>\n<li>Thoroughness of options analysis, including reasonableness of costs and benefits for each option and reasonableness of selected option</li>\n<li>Indicative cost estimate and schedule</li>\n<li>Estimating methodology, basis for assumptions, and sensitivity analysis</li>\n</ul>\n<ol start=\"2\">\n<li>Organizational readiness to undertake the project:</li>\n</ol>\n<ul>\n<li>Arrangements decided upon Project Management Office (PMO), strategies for outcome management, performance management, and risk management</li>\n<li>Initial project planning under way and mechanisms in place</li>\n<li>Business requirements approach fully defined</li>\n<li>Preparation of environment in which to run project</li>\n<li>Assessment of organizational capacity relative to project difficulty (OPMCA)</li>\n<li>Evidence of intent and ability to create an environment for project success</li>\n<li>A Guide to Project Gating for IT-Enabled Projects 17</li>\n</ul>\n<h1>Supporting item(s)</h1>\n<ol>\n<li>Complete definition of the project:</li>\n</ol>\n<ul>\n<li>Project complexity and risk levels, scope, size, and packaging</li>\n<li>Risks, constraints, and dependencies (PCRA)</li>\n<li>Architecture and technological alignment (within federal government and department)</li>\n<li>Privacy issues (Privacy Impact Assessment, or PIA), security issues (Threat and Risk Assessment, or TRA), and other policy issues</li>\n</ul>\n<ol start=\"2\">\n<li>Updated plan and estimate (10%) for tasks, level of effort to next project gate</li>\n<li>PCRA and OPMCA</li>\n</ol>\n<h1>Typical input to the review</h1>\n<p>Business case standard, and detailed supporting analysis and documentation</p>\n<p>PCRA</p>\n<p>OPMCA</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","3",null,null,44]
["30","Process","Project Gating","Project Gating Small","xxx","xxx","Small Project - Gate 1 Business Case","Gate 1 Business Case","First Draft","Gate Help","Jim Cox","TBD","HTML","<p>Purpose&nbsp;Gate 1 Business Case</p><p>To confirm that the business case is sufficiently compelling to justify, sustain and guide the project; to identify any shortcomings in readiness for action before approval; and to confirm that key identified risks can be managed.</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","12",null,null,44]
["31","Process","Project Gating","Project Gating Small","xxx","xxx","Small Project - Gate 2 Pre-Construction","Gate 2 Pre-Construction","First Draft","Gate Help","Jim Cox","TBD","HTML","<p>Purpose:&nbsp;Gate 2 Pre-Construction</p><p>To ensure that the resources, support and governance necessary for successful execution are in place prior to deployment</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","13",null,null,44]
["32","Process","Project Gating","Project Gating Small","xxx","xxx","Small Project - Gate 3 Post-implementation review","Gate 3 Post-implementation review","First Draft","Gate Help","Jim Cox","TBD","HTML","<p>Purpose:&nbsp;Gate 3 Post-implementation review</p><p>To confirm completion, assess the extent to which the project has achieved its goals, and provide an assessment of value for money.</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","14",null,null,44]
["33","Products","Project Investment Planner","Project Investment Planner",null,null,"Project Investment Planner",null,null,null,null,null,"HTML","Project Investment Planner",null,null,"Jim Cox","Yes","18",null,null,44]
["34","Products","Project Portfolio Scheduler","Project Portfolio Scheduler",null,null,"Project Portfolio Scheduler",null,null,null,null,null,"HTML","Project Portfolio Scheduler",null,null,"Jim Cox","Yes","27",null,null,44]
["35","Products","Resource Planner Estimator","Resource Planner Estimator",null,null,"Resource Planner Estimator",null,null,null,null,null,"HTML","Resource Planner Estimator",null,null,"Jim Cox","Yes","26",null,null,44]
["36","Products","Software Release Scheduler","Software Release Scheduler",null,null,"Software Release Scheduler",null,null,null,null,null,"HTML","Software Release Scheduler",null,null,"Jim Cox","Yes","29",null,null,44]
["37","Products","Sprint Planner with Burndown","Sprint Planner with Burndown",null,null,"Sprint Planner with Burndown",null,null,null,null,null,"HTML","Sprint Planner with Burndown",null,null,"Jim Cox","Yes","25",null,null,44]
["39","Marketing","Timebars Site","Using Timebars","xxx","xxx","New Users","New Users","First Draft","Marketing Page","Jim Cox","TBD","HTML","\n        <!-- content-wrap starts here -->\n        <div id=\"content-wrap\">\n\n            <div id=\"main\">\n\n\n                <a id=\"NewUsers\"></a>\n                <h1>New Users</h1>\n\n                <p>\n                    It is easy to get started and use Timebars, it takes less than a minute and no software installation\n                    is necessary because Timebars is simply a web page. You don't install web pages! We use browser cached only. </p><p>To get started, you navigate to <a href=\"http://www.timebars.com\" style=\"background-color: rgb(255, 255, 255);\">www.timebars.com</a>, click on Help button at the top and and follow instructions on the Help page to load demo data.</p>\n                \n                <p><span style=\"color: inherit; font-family: inherit; font-size: 36px;\">What is Browser Cache?</span><br></p>\n                \n\n\n                <p><a href=\"https://developer.mozilla.org/en-US/docs/Web/API/IndexedDB_API/Basic_Concepts_Behind_IndexedDB\">Mozilla</a> describes it as follows: Is a way for you to persistently store data inside a user's browser. Because it lets you create web applications with rich query abilities regardless of network availability, your applications can work both online and offline. The IndexedDB component is useful for browser based applications that store a large amount of data (for example, a list of tasks on a project), and applications that don't need persistent internet connectivity to operate.</p>\n                \n                                <p>\n                \n                Wikipedia describes it as follows: IndexedDB is a transnational database embedded in the browser. The database is organised around the concept of collections of JSON objects similarly to NoSQL databases MongoDB or CouchDB. Each object is identified with a key generated during insert. An indexation system allows to optimize access to objects. Optionally see&nbsp;<a href=\"https://www.w3.org/TR/IndexedDB/\" style=\"background-color: rgb(255, 255, 255);\">W3C HTML 5 IndexedDB</a>&nbsp;for details of the modern browser cache.</p></div><div id=\"sidebar\">\n\n\n\n            </div>\n\n            <!-- content-wrap ends here -->\n        </div>","images/timebarslogogreen.png",null,"Jim Cox","Yes","23",null,null,44]
["40","Marketing","Timebars Site","Using Timebars","xxx","xxx","Returning Users","Returning Users","First Draft","Marketing Page","Jim Cox","TBD","HTML","                <a id=\"ReturningUsers\"></a>\n                <h1>Returning Users</h1>\n\n  <p>\n                <a href=\"/Canvas.html\">Launch Timebars! (July 2018 Release)</a>\n\n               \n\n                </p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","22",null,null,44]
["41","Marketing","Timebars Site","Using Timebars","xxx","xxx","What Can I use it for web page","What Can I use it for web page","First Draft","Marketing Page","Jim Cox","TBD","HTML","<p><br></p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","18",null,null,44]
["42","Marketing","Timebars Site","Using Timebars","xxx","xxx","Why use Timebars web page","Why use Timebars web page","First Draft","Marketing Page","Jim Cox","TBD","HTML"," <style type=\"text/css\">   @page { size: 21.59cm 27.94cm; margin-left: 2cm; margin-right: 1cm; margin-top: 1cm; margin-bottom: 1cm }   p { margin-bottom: 0.25cm; line-height: 115%; background: transparent }   h4 { margin-top: 0.21cm; margin-bottom: 0.21cm; background: transparent; page-break-after: avoid }   h4.western { font-family: \"Liberation Serif\", serif; font-size: 12pt; font-weight: bold }   h4.cjk { font-family: \"Noto Serif CJK SC\"; font-size: 12pt; font-weight: bold }   h4.ctl { font-family: \"Lohit Devanagari\"; font-size: 12pt; font-weight: bold }   h1 { margin-bottom: 0.21cm; background: transparent; page-break-after: avoid }   h1.western { font-family: \"Liberation Sans\", sans-serif; font-size: 18pt; font-weight: bold }   h1.cjk { font-family: \"WenQuanYi Micro Hei\"; font-size: 18pt; font-weight: bold }   h1.ctl { font-family: \"Lohit Devanagari\"; font-size: 18pt; font-weight: bold }  </style> </head> <body lang=\"en-CA\" link=\"#000080\" vlink=\"#800000\" dir=\"ltr\"><h1 class=\"western\"> Why choose to use Timebars?</h1> <p>To transform and simplify how you manage work with a new approach on modern computer screens. To allow you to manage your people and their commitments your way and still respecting the Enterprise systems. We need better and faster scheduling tools to graphically visualize commitments on a time scale. We cannot afford to keep using Excel and maintaining duplicate data any longer. And we should be constrained to limited screen real estate of typical PC monitors of today.</p> <p><img src=\"Artile%20Template_html_363550749a304c66.png\" name=\"Image1\" align=\"left\" width=\"703\" height=\"306\" border=\"0\"/> <br/> <br/>  </p> <ol>  <li><p>The above graphic illustrates my people working on Projects,  Tasks and Software releases and I can schedule and track the work  with my finger on a touch screen or with a mouse.   </p>  <li><p><a name=\"HotNewTools\"></a>Timebars is a &quot;no  installation&quot;, browser based dynamic web page for tracking who  is working on what project and who is available for other work.   </p>  <li><p>Using visual drag and drop gestures, you can move work  allocations across the time scale and level over allocated  resources.</p>  <li><p>You no longer have to depend on the IT Department, with  Timebars you only need a web browser and an internet connection.   </p> </ol> <div id=\"sidebar\" dir=\"ltr\"><h4 class=\"western\">Wise Words</h4>  <p>&quot;Criticism is something you can avoid easily by saying  nothing, doing nothing, and being nothing&quot;</p> </div> <h1 class=\"western\">Based on Modern Technology</h1> <p>ECMAScript, often referred to as JavaScript, is a memory-safe programming language that all websites and web applications depend upon. JavaScript is what turns a static page into a dynamic one (i.e. allowing it to perform dynamic computations). It has been a fast-growing language ever since its inception, and is now the prefered language amongst developers. ECMAScript has been thrust forward by active 2 superset languages, pushing its evolution ahead of other programming languages.</p> <p>JavaScript Object Notation (JSON) is an open-standard file format using serialized objects. It has become the standard for browser and server communication. It is also used to translate data to other programming languages.  </p> <p>No Web Assembly required. Web Assemly is heralded as the next step for general public compute intensive web applications. By allowing performance-specific tasks to be hard-typed and compiled ahead of time, developers benefit from the convenience and performance of both high and low level languages, respectively.</p>","images/timebarslogogreen.png",null,"Jim Cox","Yes","16",null,null,44]

{"sheet":"Fields","index":4,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["dfID","dfCoordTop","dfCoordLeft","dfWidth","dfName","dfType","dfTitle","dfFormName","dfLabel","dfPicklist","dfShowYN","dfOther1","dfOther2","dfOther3","dfOther4","dfOther5"]
["List of Fields and other objects to render on Dynamic Focd Forms"]
["UID","Coord Top","Coord Left","Width ","Name","Type","Title","Form Name","Label","Picklist Name","Show In Form","Not Used","State","not used","not used","not used"]
[1,120,10,50,"tbMDID","NoPicklist","Item ID","PF1","UID",null,"Yes",null,"disabled"]
[2,70,1,500,"pfBand","Band","Portfolio Section","PF1","Portfolio Information",null,"Yes"]
[3,120,85,380,"tbName","NoPicklist","Name of portfolio","PF1","Portfolio Name",null,"Yes"]
[4,220,10,400,"tbMDExecutiveSummary","TextArea","Please enter summary status of the initiative","PF1","Executive Summary",null,"Yes"]
[5,320,10,200,"tbMDInvestmentCategory","WithPicklist","Investment Category","PF1","Investment Category","Investment Category","Yes"]
[6,120,10,50,"tbID","NoPicklist","Item ID","PJ1","UID",null,"Yes","tbTimebars","disabled"]
[7,70,1,500,"pfBand","Band","Project Key Metadata","PJ1","Project Key Metadata",null,"Yes","tbMetaData"]
[8,100,85,380,"tbName","NoPicklist","Name of Project","PJ1","Project Name",null,"Yes","tbTimebars"]
[9,270,10,400,"tbMDDescription","TextArea","Please enter just few lines not a thesis","PJ1","Brief Description",null,"Yes","tbMetaData"]
[10,170,10,125,"tbMDProjectNumber","NoPicklist",null,"PJ1","Project Number",null,"Yes","tbMetaData"]
[11,170,150,100,"tbMDPriority","WithPicklist",null,"FOCDPJ1","Priority","Priority","Yes","tbMetaData"]
[12,170,300,100,"tbMDStatus","WithPicklist",null,"PJ1","Status","Project Status","Yes","tbMetaData"]
[13,20,300,75,"tbID","NoPicklist","Item ID","TASK1","UID",null,"Yes","tbTimebars","disabled"]
[14,70,1,500,"pfBand","Band","Task Key Metadata","TASK1","Task Key Metadata",null,"Yes","tbMetaData"]
[15,100,8,450,"tbName","NoPicklist","Name of Task","TASK1","Task Name",null,"Yes","tbTimebars"]
[16,200,15,125,"tbStart","NoPicklist",null,"TASK1","Start",null,"Yes","tbTimebars","disabled"]
[17,200,200,125,"tbFinish","NoPicklist",null,"TASK1","Finish",null,"Yes","tbTimebars","disabled"]
[18,20,380,75,"tbSelfKey2","NoPicklist",null,"TASK1","Parent ID",null,"Yes","tbTimebars","disabled"]
[19,100,10,75,"tbID","NoPicklist","Item ID","SPJ1","UID",null,"Yes","tbTimebars","disabled"]
[20,70,1,500,"pfBand","Band","Sub-Project Key Metadata","SPJ1","Sub_Project Key Metadata",null,"Yes","tbMetaData"]
[21,100,85,380,"tbName","NoPicklist","Name of Sub Project","SPJ1","Sub_Project Name",null,"Yes","tbTimebars"]
[22,370,10,400,"tbMDDescription","TextArea","Please enter just few lines not a thesis","SPJ1","Brief Description",null,"Yes","tbMetaData"]
[23,270,10,125,"tbMDProjectNumber","NoPicklist",null,"SPJ1","Project Number",null,"Yes","tbMetaData"]
[24,270,150,100,"tbMDPriority","WithPicklist",null,"SPJ1","Priority","Priority","Yes","tbMetaData"]
[25,270,350,100,"tbMDStatus","WithPicklist",null,"SPJ1","Status","Project Status","Yes","tbMetaData"]
[26,20,300,75,"tbID","NoPicklist","Item ID","ALLOC1","UID",null,"Yes","tbTimebars","disabled"]
[27,70,1,500,"pfBand","Band","Allocation Metadata","ALLOC1","Allocation Key Metadata",null,"Yes","tbMetaData"]
[28,100,8,450,"tbName","NoPicklist",null,"ALLOC1","Allocation Name",null,"Yes","tbTimebars"]
[29,200,15,125,"tbStart","NoPicklist",null,"ALLOC1","Start",null,"Yes","tbTimebars","disabled"]
[30,200,200,125,"tbFinish","NoPicklist",null,"ALLOC1","Finish",null,"Yes","tbTimebars","disabled"]
[31,20,380,75,"tbSelfKey2","NoPicklist",null,"ALLOC1","Parent ID",null,"Yes","tbTimebars","disabled"]

{"sheet":"FOCD Helper","index":5,"n_rows":128,"n_cols":16,"rows_kept":128,"cut":false,"hidden":false,"merged":[[3,0,3,4],[3,8,3,10],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4]]}
[]
["Timebars Configuration and Setup Standards"]
[]
["Import Timebars Into Excel  External data must be in JSON format",null,null,null,null,null,null,null,"Validation and Formatting"]
["Import Y/N","Source File Names",null,null,null,null,null,null,"Tab","Validate YN","ReFormat YN"]
["Yes","tbTimebars.js",null,null,null,null,null,null,"Timebars","Yes","Yes"]
["Yes","tbMetaData.js",null,null,null,null,null,null,"MetaData","Yes","Yes"]
["Yes","tbResources.js",null,null,null,null,null,null,"Tags","Yes","Yes"]
["Yes","tbTags.js",null,null,null,null,null,null,"Resources","Yes","Yes"]
["Yes","tbDocuments.js",null,null,null,null,null,null,"Baseline","Yes","Yes"]
["Yes","tbResCalcs",null,null,null,null,null,null,"Documents","Yes","Yes"]
["Yes","tbResCalcsDetailed",null,null,null,null,null,null,"AdminPanel","Yes","Yes"]
["Yes","tbAdminPanel",null,null,null,null,null,null,"ResCalcs","Yes","Yes"]
["Yes","tbBaseline"]
["No","AddTimebars.js"]
["No","tbMetaData3Pf.js"]
["No","tbTimebars3Pf.js"]
[null,"Source Path of JSON Files"]
[null,"/home/jcox/Documents/TimebarsData/jsonfiles"]
["Possible Form Names : PF1, PF2, PJ1, PJ2, PJ3, SPJ1, Task1, Task2, ALLOC1, DOC1, DOC1, other1, other2"]
[]
["Preconfigured Fields – Copy and paste into Fields Sheet for use in FOCD Forms"]
["UID","Coord Top","Coord Left","Width ","Name","Type","Title","Form Name","Label","Picklist","Show In Form","Store Name","not used","not used","not used","not used"]
[1,130,10,350,"tbMDID","NoPicklist","Item ID",null,"UID",null,"Yes","tbMetaData"]
[2,200,10,null,"tbMDName","NoPicklist","Please enter name or title",null,"Portfolio Title",null,"Yes","tbMetaData"]
[3,270,10,null,"tbMDProjectType","WithPicklist","Is this a Program, Project or Sub-project?",null,"Project Type","Project Type","Yes","tbMetaData"]
[4,340,10,null,"tbMDPortfolio","WithPicklist","Please enter the name of the Portfolio this belongs to",null,"Investment Portfolio","Portfolios","Yes","tbMetaData"]
[5,410,10,null,"tbMDProgram","WithPicklist","Enter Program name if applicable",null,"Program","Programs","No","tbMetaData"]
[]
[7,130,10,350,"tbMDID","NoPicklist","Item ID",null,"UID2",null,"Yes","tbMetaData"]
[8,200,10,350,"tbMDName","NoPicklist","Please enter name or title",null,"Portfolio Title2",null,"Yes","tbMetaData"]
[9,270,10,350,"tbMDProjectType","WithPicklist","Is this a Program, Project or Sub-project?",null,"Project Type2","Project Type","Yes","tbMetaData"]
[10,340,10,350,"tbMDPortfolio","WithPicklist","Please enter the name of the Portfolio this belongs to",null,"Investment Portfolio2","Portfolios","Yes","tbMetaData"]
[11,410,10,350,"tbMDProgram","WithPicklist","Enter Program name if applicable",null,"Program2","Programs","No","tbTimebars"]
[12,480,10,350,"tbMDExecutiveSummary","TextArea","Please enter summary status of the initiative",null,"Executive Summary2",null,"Yes","tbMetaData"]
[13,970,10,350,"tbMDInvestmentCategory","WithPicklist",null,null,"Investment Category","Investment Category",null,"tbMetaData"]
[14,1040,10,350,"tbMDInvestmentInitiative","WithPicklist",null,null,"Investment Initiative","Investment Initiative",null,"tbMetaData"]
[15,1110,10,350,"tbMDInvestmentObjective","WithPicklist",null,null,"Investment Objective","Investment Objective",null,"tbMetaData"]
[16,850,10,350,"tbMDInvestmentStrategy","WithPicklist",null,null,"Investment Strategy","Investment Strategy",null,"tbMetaData"]
[17,900,10,350,"tbMDPriorityStrategic","WithPicklist",null,null,"Primary Strategic Priority"," Primary Strategic Priority",null,"tbMetaData"]
[18,950,10,350,"tbMDCustomerID","NoPicklist",null,null,null,null,null,"tbMetaData"]
[19,1000,10,350,"tbMDAzureID","NoPicklist",null,null,null,null,null,"tbMetaData"]
[20,1050,10,350,"tbMDNameShort","NoPicklist",null,null,null,null,null,"tbMetaData"]
[21,1100,10,350,"tbMDProjectNumber","NoPicklist",null,null,"Project Number",null,null,"tbMetaData"]
[22,440,10,350,"tbMDDescription","TextArea","Please enter just few lines not a thesis",null,"Brief Description",null,"Yes","tbMetaData"]
[23,520,10,350,"tbMDNotes","TextArea",null,null,"General Notes",null,"Yes","tbMetaData"]
[24,1250,10,350,"tbMDExtLink1","NoPicklist",null,null,null,null,null,"tbMetaData"]
[25,1300,10,350,"tbMDExtSystemID1","NoPicklist",null,null,null,null,null,"tbMetaData"]
[26,1350,10,350,"tbMDSortOrder","NoPicklist",null,null,null,null,null,"tbMetaData"]
[27,1050,10,350,"tbMDtbLastModified","NoPicklist",null,null,null,null,null,"tbMetaData"]
[28,1090,10,350,"tbMDPriority","WithPicklist",null,null,"Priority","Priority",null,"tbMetaData"]
[29,1130,10,350,"tbMDStatus","WithPicklist",null,null,"Status","Project Status",null,"tbMetaData"]
[30,1170,10,350,"tbMDState","WithPicklist",null,null,"State","State",null,"tbMetaData"]
[31,1210,10,350,"tbMDSeverity","NoPicklist",null,null,null,null,null,"tbMetaData"]
[32,1250,10,350,"tbMDStage","WithPicklist",null,null,"Stage","Stage",null,"tbMetaData"]
[33,1290,10,350,"tbMDPhase","WithPicklist",null,null,"Phase","Phase",null,"tbMetaData"]
[34,1330,10,350,"tbMDCategory","WithPicklist",null,null,"Category","Category",null,"tbMetaData"]
[35,1370,10,350,"tbMDHealth","WithPicklist",null,null,null,null,null,"tbMetaData"]
[36,1410,10,350,"tbMDResponsibility","WithPicklist",null,null,"Responsibility","Responsibility",null,"tbMetaData"]
[37,1450,10,350,"tbMDDepartment","WithPicklist",null,null,"Department","Deparment",null,"tbMetaData"]
[38,1490,10,350,"tbMDExSponsor","WithPicklist",null,null,"Exec Sponsor",null,null,"tbMetaData"]
[39,1530,10,350,"tbMDPM","WithPicklist",null,null,"PM",null,null,"tbMetaData"]
[40,1570,10,350,"tbMDShowIn","WithPicklist",null,null,null,null,null,"tbMetaData"]
[41,1610,10,350,"tbMDYesNoSelector","WithPicklist",null,null,null,null,null,"tbMetaData"]
[42,1650,10,350,"tbMDProduct","WithPicklist",null,null,"Product","Product",null,"tbMetaData"]
[43,1690,10,350,"tbMDContact","WithPicklist",null,null,"Product Contact",null,null,"tbMetaData"]
[44,1730,10,350,"tbMDWBS","WithPicklist",null,null,"WBS","WBS",null,"tbMetaData"]
[45,1770,10,350,"tbMDWeighting","WithPicklist",null,null,null,null,null,"tbMetaData"]
[46,1810,10,350,"tbMDLocation","WithPicklist",null,null,null,null,null,"tbMetaData"]
[47,1850,10,350,"tbMDPrimarySkill","WithPicklist",null,null,null,null,null,"tbMetaData"]
[48,1890,10,350,"tbMDPrimaryRole","WithPicklist",null,null,null,null,null,"tbMetaData"]
[49,1930,10,350,"tbMDOther2","NoPicklist",null,null,null,null,null,"tbMetaData"]
[50,1970,10,350,"tbMDOther3","NoPicklist",null,null,null,null,null,"tbMetaData"]
[51,2010,10,350,"tbMDOther4","NoPicklist",null,null,null,null,null,"tbMetaData"]
[52,2050,10,350,"canvasNo","NoPicklist",null,null,null,null,null,"tbMetaData"]
[53,2090,10,350,"tbMDProgActivityAlignment","WithPicklist",null,null,null,null,null,"tbMetaData"]
[54,2130,10,350,"tbMDBackgroundInfo","Editor",null,null,"Backround Info",null,null,"tbMetaData"]
[55,2170,10,350,"tbMDConsequence","Editor",null,null,"Consequences of Inaction",null,null,"tbMetaData"]
[56,2210,10,350,"tbMDExpectedBenefits","Editor",null,null,"Expected Benefits",null,null,"tbMetaData"]
[57,2250,10,350,"tbMDProblemOpportunity","Editor",null,null,"Problem Opportunity",null,null,"tbMetaData"]
[58,2290,10,350,"tbMDCapabilitiesNeeded","Editor",null,null,"Capabilities Needed",null,null,"tbMetaData"]
[59,2330,10,350,"tbMDSeniorLevelCommittment","Editor",null,null,null,null,null,"tbMetaData"]
[60,2370,10,350,"tbMDSprintName","NoPicklist",null,null,null,null,null,"tbMetaData"]
[61,2410,10,350,"tbMDStakeholderDescription","NoPicklist",null,null,"Stakeholder Description",null,null,"tbMetaData"]
[62,2450,10,350,"tbMDHealthCost","WithPicklist",null,null,"Health Cost","Health Indicators",null,"tbMetaData"]
[63,2490,10,350,"tbMDHealthHours","NoPicklist",null,null,null,null,null,"tbMetaData"]
[64,2530,10,350,"tbMDHealthIssues","WithPicklist",null,null,"Health Issues","Health Indicators",null,"tbMetaData"]
[65,2570,10,350,"tbMDHealthOverall","WithPicklist",null,null,"Health Overall","Health Indicators",null,"tbMetaData"]
[66,2610,10,350,"tbMDHealthRisk","WithPicklist",null,null,"Health Risk","Health Indicators",null,"tbMetaData"]
[67,2650,10,350,"tbMDHealthSchedule","WithPicklist",null,null,"Health Schedule","Health Indicators",null,"tbMetaData"]
[68,2690,10,350,"tbMDHealthScope","WithPicklist",null,null,"Health Scope","Health Indicators",null,"tbMetaData"]
[69,2730,10,350,"tbMDBenefitCostRatio","NoPicklist",null,null,"Benefit/Cost Ratio",null,null,"tbMetaData"]
[70,2770,10,350,"tbMDConstraintsAssumptions","Editor",null,null,"Constraints And Assumptions",null,null,"tbMetaData"]
[71,2810,10,350,"tbMDContractNumber","NoPicklist",null,null,"Contract Number",null,null,"tbMetaData"]
[72,2850,10,350,"tbMDCostBenefitAnalysis","Editor",null,null,null,null,null,"tbMetaData"]
[73,2890,10,350,"tbMDEcnomicValueAdded","NoPicklist",null,null,"Ecnomic Value Added",null,null,"tbMetaData"]
[74,2930,10,350,"tbMDInternalRateOfReturn","NoPicklist",null,null,"Internal Rate Of Return",null,null,"tbMetaData"]
[75,2970,10,350,"tbMDNetPresentValue","NoPicklist",null,null,"                                                        Return",null,null,"tbMetaData"]
[76,3010,10,350,"tbMDOpportunityCost","NoPicklist",null,null,"Opportunity Cost",null,null,"tbMetaData"]
[77,3050,10,350,"tbMDOrgManager","WithPicklist",null,null,"Org Manager",null,null,"tbMetaData"]
[78,3090,10,350,"tbMDPaybackPeriod","NoPicklist",null,null,"Payback Period",null,null,"tbMetaData"]
[79,3130,10,350,"tbMDRiskVsSizeAndComplexity","WithPicklist",null,null,"Risk Vs Size And Complexity","Risk Vs Size",null,"tbMetaData"]
[80,3170,10,350,"tbMDSize","WithPicklist",null,null,"Size","Size",null,"tbMetaData"]
[81,3210,10,350,"tbMDStageApprover","WithPicklist",null,null,"Stage Approver",null,null,"tbMetaData"]
[82,3250,10,350,"tbMDSunkCosts","NoPicklist",null,null,"Sunk Costs",null,null,"tbMetaData"]
[83,3290,10,350,"tbMDWrittenBy","NoPicklist",null,null,null,null,null,"tbMetaData"]
[84,3330,10,350,"tbMDPrimaryLineOfBusiness","WithPicklist",null,null,"Primary Line Of Business","Primary Line Of Business",null,"tbMetaData"]
[85,550,10,350,"tbMDNotesWorkflow","WithPicklist",null,null,"Workflow Notes",null,"No","tbMetaData"]
[86,3410,10,350,"tbMDSyncNotes","NoPicklist",null,null,null,null,null,"tbMetaData"]
[87,3450,10,350,"tbMDSponsoringDepartment","WithPicklist",null,null,"Sponsoring Department","Sponsoring Department",null,"tbMetaData"]
[88,3490,10,350,"tbMDPrimaryContact","WithPicklist",null,null,"Primary Contact",null,null,"tbMetaData"]
[89,3530,10,350,"tbMDContactNumber","NoPicklist","Enter numbers or text or both",null,"Contact Info",null,null,"tbMetaData"]
[90,3570,10,350,"tbMDResponsibleTeam","WithPicklist",null,null,"Responsible Team","Resonsible Teams",null,"tbMetaData"]
[91,3610,10,350,"tbMDNotesProject","NoPicklist",null,null,null,null,null,"tbMetaData"]
[92,3650,10,350,"tbMDOther5","NoPicklist",null,null,null,null,null,"tbMetaData"]
[93,3690,10,350,"tbMDOther6","NoPicklist",null,null,null,null,null,"tbMetaData"]
[94,3730,10,350,"tbMDOther7","NoPicklist",null,null,null,null,null,"tbMetaData"]
[95,3770,10,350,"tbMDOther8","NoPicklist",null,null,null,null,null,"tbMetaData"]
[96,3810,10,350,"tbMDOther9","NoPicklist",null,null,null,null,null,"tbMetaData"]
[97,3850,10,350,"tbMDOther10","NoPicklist",null,null,null,null,null,"tbMetaData"]
[98,3890,10,350,"tbMDOther11","NoPicklist",null,null,null,null,null,"tbMetaData"]
[99,3930,10,350,"tbMDOther12","NoPicklist",null,null,null,null,null,"tbMetaData"]
[100,3970,10,350,"tbMDRefID","NoPicklist",null,null,null,null,null,"tbMetaData"]
[101,100,10,350,null,"Band",null,null,"Business Case",null,"Yes","tbMetaData"]
[102,530,10,350,"tbName","NoPicklist","Name of Timebar",null,"Timebar Name",null,"Yes","tbTimebars"]
[103,570,10,350,"tbType","NoPicklist","Type of Timebar (Pf, Project Etc)",null,"Type",null,"Yes","tbTimebars"]
[104,620,10,350,"tbL1","WithPicklist","Level 1, Portfolio",null,"Portfolio Name","Portfolios","Yes","tbTimebars"]
[105,700,10,350,"tbL2","Editor","Level 2, Project or Program",null,"L2 Description",null,"Yes","tbTimebars"]

{"sheet":"Data Types","index":6,"n_rows":142,"n_cols":21,"rows_kept":142,"cut":false,"hidden":false,"merged":[]}
[null,"List of all possible fields in Timebars App",null,null,"Orange represents fields that can be used in FOCD Forms"]
["ID","MetData Fields","DataType","ID","Timebar Fields","DataType","ID","Document Fields","DataType","ID","Resource Fields","DataType","ID","ResCalcs Fields","DataType","ID","Admin Panel Fields","DataType","ID","Tag Fields","DataType"]
[0,"tbMDID","text",0,"tbID","text",0,"tbDocID","text",0,"tbResID","text",0,"tbResCalcID","text",0,"ap_name","text",0,"tbTagID","text"]
[1,"tbMDName","text",1,"tbSelfKey2","text",1,"tbDocName","text",1,"tbResName","text",1,"tbResCalcCustomerID","text",1,"apID","text",1,"tbTagGroup","text"]
[2,"tbMDProjectType","text",2,"tbCoordTop","number",2,"tbDocNameShort","text",2,"tbResNameShort","text",2,"tbResCalcAzureID","text",2,"apCustomerID","text",2,"tbTagName","text"]
[3,"tbMDPortfolio","text",3,"tbCoordLeft","number",3,"tbDocStatus","text",3,"tbResPrimarySkill","text",3,"tbResCalcName","text",3,"apFilteredFrom","text",3,"tbTagEntity","text"]
[4,"tbMDProgram","text",4,"tbHierarchyOrder","number",4,"tbDocPurpose","text",4,"tbResPrimaryRole","text",4,"tbResCalcTbID","text",4,"apAzureID","text",4,"tbTagPopular","text"]
[5,"tbMDExecutiveSummary","text",5,"tbName","text",5,"tbDocWrittenBy","text",5,"tbResDepartment","text",5,"tbResCalcWdays","number",5,"apTS_WeeklyOrMonthly","text",5,"tbTagNameShort","text"]
[6,"tbMDGate","text",6,"tbType","text",6,"tbDocBriefDescription","text",6,"tbResManager","text",6,"tbResCalcStartWeekNo","number",6,"apTS_WeeklyPxFactor","number",6,"tbTagPurpose","text"]
[7,"tbMDDeliveryManager","text",7,"tbL1","text",7,"tbDocCustomerID","text",7,"tbResPayRate","number",7,"tbResCalcTbWeekNo","number",7,"apTS_Start","date",7,"tbTagDescription","text"]
[8,"tbMDBusinessAdvisor","text",8,"tbL2","text",8,"tbDocType","text",8,"tbResTeam","text",8,"tbResCalcTbResID","text",8,"apTS_Finish","date",8,"tbTagOwner","text"]
[9,"tbMDBusinessOwner","text",9,"tbL3","text",9,"tbDocHTMLContent","text",9,"tbResLocation","text",9,"tbResCalcWeekSumHours","number",9,"apHelpCoordTop","number",9,"tbTagSortOrder","number"]
[10,"tbMDEstimationClass","text",10,"tbL4","text",10,"tbDocGroup","text",10,"tbResTeamLeader","text",10,"tbResCalcWeekSumCost","number",10,"apHelpCoordLeft","number",10,"tbTagCustomerID","text"]
[11,"tbMDROMEstimate","text",11,"tbL5","text",11,"tbDocOwner","text",11,"tbResSupervisor","text",11,"tbResCalcWeek","number",11,"apTS_MonthlyPxFactor","number",11,"tbTagAzureID","text"]
[12,"tbMDInvestmentCategory","text",12,"tbOwner","text",12,"tbDocPopular","text",12,"tbResPartTimeFullTime","text",12,"tbResCalcHours","number",12,"apStatusDate","date",12,"tbTagEntity","text"]
[13,"tbMDInvestmentInitiative","text",13,"tbStart","date",13,"tbDocSortOrder","number",13,"tbResResourceType","text",13,"tbResCalcLastModified","date",13,"apFilteredFromTbID","text",13,"tbTagLastModified","date"]
[14,"tbMDInvestmentObjective","text",14,"tbFinish","date",14,"tbDocLastModified","date",14,"tbResResourceClass","text",14,"tbResCalcWeek1","number",14,"ap_HolidayDate","date"]
[15,"tbMDInvestmentStrategy","text",15,"tbDuration","number",15,"tbDocApprovedBy","text",15,"tbResResourceCalendar","number",15,"tbResCalcWeek2","number",15,"ap_HolidayName","text"]
[16,"tbMDPriorityStrategic","text",16,"tbAStart","date",16,"tbDocL1","text",16,"tbResPercentGeneralAvailability","number",16,"tbResCalcWeek3","number",16,"apSchMethod","text"]
[17,"tbMDCustomerID","text",17,"tbAFinish","date",17,"tbDocL2","text",17,"tbResCostCode","text",17,"tbResCalcWeek4","number",17,"apTbVisibleLevel","text"]
[18,"tbMDAzureID","text",18,"tbRemainingDuration","number",18,"tbDocL3","text",18,"tbResCustomerID","text",18,"tbResCalcWeek5","number",18,"totalNumberOfPeople","number"]
[19,"tbMDNameShort","text",19,"tbResID","text",19,"tbDocL4","text",19,"tbResExtSystemResID","text",19,"tbResCalcWeek6","number",19,"numberOfPeoplePerLine","number"]
[20,"tbMDProjectNumber","text",20,"tbCalendar","number",20,"tbDocL5","text",20,"tbResSortOrder","number",20,"tbResCalcWeek7","number",20,"pxPerPerson","number"]
[21,"tbMDDescription","text",21,"tbPercentTimeOn","number",21,"tbDocCardImage","text",21,"tbResLastModified","date",21,"tbResCalcWeek8","number",21,"apHideCompletedBarsYN","text"]
[22,"tbMDNotes","text",22,"tbWork","number",null,null,null,22,"tbResExtSystemResID","text",22,"tbResCalcWeek9","number"]
[23,"tbMDExtLink1","text",23,"tbAWork","number",null,null,null,23,"tbResCoordTop","number",23,"tbResCalcWeek10","number"]
[24,"tbMDExtSystemID1","text",24,"tbWorkRemaining","number",null,null,null,24,"tbResCoordLeft","number",24,"tbResCalcWeek11","number"]
[25,"tbMDSortOrder","number",25,"tbPercentComplete","number",null,null,null,25,"tbResLabourType","text",25,"tbResCalcWeek12","number"]
[26,"tbMDtbLastModified","date",26,"tbCost","number",null,null,null,26,"tbResEmail","text",26,"tbResCalcWeek13","number"]
[27,"tbMDPriority","text",27,"tbAcost","number",null,null,null,27,"tbResPasswordHash","text",27,"tbResCalcWeek14","number"]
[28,"tbMDStatus","text",28,"tbCostRemaining","number",null,null,null,28,"tbResPIN","text",28,"tbResCalcWeek15","number"]
[29,"tbMDState","text",29,"tbPayRate","number",null,null,null,29,"tbResAzureID","text",29,"tbResCalcWeek16","number"]
[30,"tbMDSeverity","text",30,"tbCostType","text",null,null,null,null,null,null,30,"tbResCalcWeek17","number"]
[31,"tbMDStage","text",31,"tbCostID","text",null,null,null,null,null,null,31,"tbResCalcWeek18","number"]
[32,"tbMDPhase","text",32,"tbConstraintType","text",null,null,null,null,null,null,32,"tbResCalcWeek19","number"]
[33,"tbMDCategory","text",33,"tbConstraintDate","date",null,null,null,null,null,null,33,"tbResCalcWeek20","number"]
[34,"tbMDHealth","text",34,"tbFloat","number",null,null,null,null,null,null,34,"tbResCalcWeek21","number"]
[35,"tbMDResponsibility","text",35,"tbFreeFloat","number",null,null,null,null,null,null,35,"tbResCalcWeek22","number"]
[36,"tbMDDepartment","text",36,"tbExpHoursPerWeek","number",null,null,null,null,null,null,36,"tbResCalcWeek23","number"]
[37,"tbMDExSponsor","text",37,"canvasNo","number",null,null,null,null,null,null,37,"tbResCalcWeek24","number"]
[38,"tbMDPM","text",38,"tbCustomerID","text",null,null,null,null,null,null,38,"tbResCalcWeek25","number"]
[39,"tbMDShowIn","text",39,"tbMetaDataID","text",null,null,null,null,null,null,39,"tbResCalcWeek26","number"]
[40,"tbMDYesNoSelector","text",40,"tbBLID","text",null,null,null,null,null,null,40,"tbResCalcWeek27","number"]
[41,"tbMDProduct","text",41,"tbPredecessor","text",null,null,null,null,null,null,41,"tbResCalcWeek28","number"]
[42,"tbMDContact","text",42,"tbAzureID","text",null,null,null,null,null,null,42,"tbResCalcWeek29","number"]
[43,"tbMDWBS","text",43,"tbCoordRight","text",null,null,null,null,null,null,43,"tbResCalcWeek30","number"]
[44,"tbMDWeighting","number",44,"tbBarColor","text"]
[45,"tbMDLocation","text",45,"tbTextColor","text"]
[46,"tbMDPrimarySkill","text",46,"kbCoordLeft","number"]
[47,"tbMDPrimaryRole","text",47,"kbCoordTop","number"]
[48,"tbMDOther2","text",48,"focdItemCoordLeft","number"]
[49,"tbMDOther3","text",49,"focdItemCoordTop","number"]
[50,"tbMDOther4","text"]
[51,"canvasNo","number"]
[52,"tbMDProgActivityAlignment","text"]
[53,"tbMDBackgroundInfo","text"]
[54,"tbMDConsequence","text"]
[55,"tbMDExpectedBenfits","text"]
[56,"tbMDProblemOpportunity","text"]
[57,"tbMDCapabilitiesNeeded","text"]
[58,"tbMDSeniorLevelCommittment","text"]
[59,"tbMDSprintName","text"]
[60,"tbMDStakeholderDescription","text"]
[61,"tbMDHealthCost","text"]
[62,"tbMDHealthHours","text"]
[63,"tbMDHealthIssues","text"]
[64,"tbMDHealthOverall","text"]
[65,"tbMDHealthRisk","text"]
[66,"tbMDHealthSchedule","text"]
[67,"tbMDHealthScope","text"]
[68,"tbMDBenefitCostRatio","number"]
[69,"tbMDConstraintsAssumptions","text"]
[70,"tbMDContractNumber","text"]
[71,"tbMDCostBenefitAnalysis","text"]
[72,"tbMDEcnomicValueAdded","number"]
[73,"tbMDInternalRateOfReturn","number"]
[74,"tbMDNetPresentValue","number"]
[75,"tbMDOpportunityCost","number"]
[76,"tbMDOrgManager","text"]
[77,"tbMDPaybackPeriod","number"]
[78,"tbMDRiskVsSizeAndComplexity","text"]
[79,"tbMDSize","text"]
[80,"tbMDStageApprover","text"]
[81,"tbMDSunkCosts","number"]
[82,"tbMDWrittenBy","text"]
[83,"tbMDPrimaryLineOfBusiness","text"]
[84,"tbMDNotesWorkflow","text"]
[85,"tbMDSyncNotes","text"]
[86,"tbMDSponsoringDepartment","text"]
[87,"tbMDPrimaryContact","text"]
[88,"tbMDContactNumber","text"]
[89,"tbMDResponsibleTeam","text"]
[90,"tbMDNotesProject","text"]
[91,"tbMDOther5","text"]
[92,"tbMDOther6","text"]
[93,"tbMDOther7","text"]
[94,"tbMDOther8","text"]
[95,"tbMDOther9","text"]
[96,"tbMDOther10","text"]
[97,"tbMDOther11","text"]
[98,"tbMDOther12","text"]
[99,"tbMDRefID","text"]
["Column Data Types (default is text)"]
["tbMetaData","DataType","tbcore","DataType","Tag","DataType","AdminPanel","DataType","BL","DataType","ResCalc","DataType","DataType",null,null,null,null,null,"Res","DataType","Doc"]
["tbMDtbLastModified","date","tbCoordTop","number","tbTagSortOrder","number","apTS_WeeklyPxFactor","number","tbCoordTop","number","tbResCalcWdays","number","number",null,null,null,null,null,"tbResPayRate","number","tbDocSortOrder"]
["tbMDWeighting","number","tbCoordLeft","number","tbTagLastModified","date","apTS_Start","date","tbCoordLeft","date","tbResCalcStartWeekNo","number","number",null,null,null,null,null,"tbResResourceCalendar","number","tbDocLastModified"]
["canvasNo","number","tbHierarchyOrder","number",null,null,"apTS_Finish","date","tbHierarchyOrder",null,"tbResCalcTbWeekNo","number","number",null,null,null,null,null,"tbResPercentGeneralAvailability","number"]
["tbMDBenefitCostRatio","number","tbStart","date",null,null,"apHelpCoordTop","number","tbStart",null,"tbResCalcWeekSumHours","number","date",null,null,null,null,null,"tbResSortOrder","number"]
["tbMDEcnomicValueAdded","number","tbFinish","date",null,null,"apHelpCoordLeft","number","tbFinish",null,"tbResCalcWeekSumCost","number","date",null,null,null,null,null,"tbResLastModified","date"]
["tbMDInternalRateOfReturn","number","tbDuration","number",null,null,"apTS_MonthlyPxFactor","number","tbDuration",null,"tbResCalcWeek","number","number",null,null,null,null,null,"tbResCoordTop","number"]
["tbMDNetPresentValue","number","tbAStart","date",null,null,"apStatusDate","date","tbAStart",null,"tbResCalcHours","number","date",null,null,null,null,null,"tbResCoordLeft","number"]
["tbMDOpportunityCost","number","tbAFinish","date",null,null,"ap_HolidayDate","date","tbAFinish",null,"tbResCalcLastModified","date","date"]
["tbMDPaybackPeriod","number","tbRemainingDuration","number",null,null,"totalNumberOfPeople","number","tbRemainingDuration",null,"tbResCalcWeek1","number","number"]
["tbMDSunkCosts","number","tbCalendar","number",null,null,"numberOfPeoplePerLine","number","tbCalendar",null,"tbResCalcWeek2","number","number"]
[null,null,"tbPercentTimeOn","number",null,null,"pxPerPerson","number","tbPercentTimeOn",null,"tbResCalcWeek3","number","number"]
[null,null,"tbWork","number",null,null,null,null,"tbWork",null,"tbResCalcWeek4","number","number"]
[null,null,"tbAWork","number",null,null,null,null,"tbAWork",null,"tbResCalcWeek5","number","number"]
[null,null,"tbWorkRemaining","number",null,null,null,null,"tbWorkRemaining",null,"tbResCalcWeek6","number","number"]
[null,null,"tbPercentComplete","number",null,null,null,null,"tbPercentComplete",null,"tbResCalcWeek7","number","number"]
[null,null,"tbCost","number",null,null,null,null,"tbCost",null,"tbResCalcWeek8","number","number"]
[null,null,"tbAcost","number",null,null,null,null,"tbAcost",null,"tbResCalcWeek9","number","number"]
[null,null,"tbCostRemaining","number",null,null,null,null,"tbCostRemaining",null,"tbResCalcWeek10","number","number"]
[null,null,"tbPayRate","number",null,null,null,null,"tbPayRate",null,"tbResCalcWeek11","number","number"]
[null,null,"tbConstraintDate","date",null,null,null,null,"tbConstraintDate",null,"tbResCalcWeek12","number","date"]
[null,null,"tbFloat","number",null,null,null,null,"tbFloat",null,"tbResCalcWeek13","number","number"]
[null,null,"tbFreeFloat","number",null,null,null,null,"tbFreeFloat",null,"tbResCalcWeek14","number","number"]
[null,null,"tbExpHoursPerWeek","number",null,null,null,null,"tbExpHoursPerWeek",null,"tbResCalcWeek15","number","number"]
[null,null,"canvasNo","number",null,null,null,null,"canvasNo",null,"tbResCalcWeek16","number","number"]
[null,null,"kbCoordLeft","number",null,null,null,null,"kbCoordLeft",null,"tbResCalcWeek17","number","number"]
[null,null,"kbCoordTop","number",null,null,null,null,"kbCoordTop",null,"tbResCalcWeek18","number","number"]
[null,null,"focdItemCoordLeft","number",null,null,null,null,"focdItemCoordLeft",null,"tbResCalcWeek19","number","number"]
[null,null,"focdItemCoordTop","number",null,null,null,null,"focdItemCoordTop",null,"tbResCalcWeek20","number","number"]
[null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek21","number"]
[null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek22","number"]
[null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek23","number"]
[null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek24","number"]
[null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek25","number"]
[null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek26","number"]
[null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek27","number"]
[null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek28","number"]
[null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek29","number"]
[null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek30","number"]

{"sheet":"Log","index":7,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["tbID","tbSelfKey2","tbName","tbType","tbL1","tbL2","tbL3","tbL4","tbL5"]