{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Portfolio View","Timebars","MetaData","Tags","Baseline","Resources","AdminPanel","Documents","ResCalcs","Fields","Setup","AllStandardFlds","Audit Log","SetupOld","Log","tbForestry","tbWorkflow"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":9,"comments":1,"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":"Portfolio View","index":0,"n_rows":8,"n_cols":35,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,31,0,34]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Audit Rows"]
["UID","Parent","Name","Type","Portfolio","Owner","Start","Finish","Duration","AStart","AFinish","Remaining Duration","Work","AWork","Work Remaining","% Complete","Cost","Acost","Cost Remaining","Executive Summary","Gate","Delivery Manager","Business Advisor","Business Owner","Estimation Class","ROM Estimate","Investment Category","Investment Initiative","Investment Objective","Investment Strategy","Priority Strategic","Updated from PF Sheet When","Updated From Which PF Sheet","Updated from ERP/PPM When"," ERP or PPM?"]
[525,null,"Cloud Portfolio","Portfolio","Cloud Portfolio",0,44211,44249,27,null,null,null,0,0,null,null,0,null,null,"My Summary",null,null,null,null,null,null,null,null,null,null,null,"2021-02-06T15:57:59","Timebars","2021-02-06T16:16:18","Timebars"]
[526,525,"Cloud to Ground Connectivity Project","Project","Cloud Portfolio",0,44211,44249,27,null,null,null,0,0,null,null,0,null,null,"My Summary",null,null,null,null,null,null,null,null,null,null,null,"2021-02-06T15:57:59","Timebars","2021-02-06T16:16:19","Timebars"]
[527,526,"Choose vendor","Task","Cloud Portfolio",0,44219,44257,27,null,null,null,0,0,null,null,0,null,null,"My Summary",null,null,null,null,null,null,null,null,null,null,null,"2021-02-06T15:57:59","Timebars","2021-02-06T16:16:19","Timebars"]
[528,526,"Vendor Selected","Milestone","Cloud Portfolio",0,44228,44228,1,null,null,null,0,0,null,null,0,null,null,"My Summary",null,null,null,null,null,null,null,null,null,null,null,"2021-02-06T15:57:59","Timebars","2021-02-06T16:16:19","Timebars"]
[529,526,"Design vendor specific network architecture","Sub-Project","Cloud Portfolio",0,44211,44249,27,null,null,null,0,0,null,null,0,null,null,"My Summary",null,null,null,null,null,null,null,null,null,null,null,"2021-02-06T15:57:59","Timebars","2021-02-06T16:16:19","Timebars"]
[530,529,"Go/No Go Implement Network in Cloud","Gate","Cloud Portfolio",0,44211,44218,6,null,null,null,0,0,null,null,0,null,null,"My Summary",null,null,null,null,null,null,null,null,null,null,null,"2021-02-06T15:57:59","Timebars","2021-02-06T16:16:19","Timebars"]

{"sheet":"Timebars","index":1,"n_rows":9,"n_cols":50,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["tbID","tbSelfKey2","tbCoordTop","tbCoordLeft","tbHierarchyOrder","tbName","tbType","tbL1","tbL2","tbL3","tbL4","tbL5","tbOwner","tbStart","tbFinish","tbDuration","tbAStart","tbAFinish","tbRemainingDuration","tbResID","tbCalendar","tbPercentTimeOn","tbWork","tbAWork","tbWorkRemaining","tbPercentComplete","tbCost","tbAcost","tbCostRemaining","tbPayRate","tbCostType","tbCostID","tbConstraintType","tbConstraintDate","tbFloat","tbFreeFloat","tbExpHoursPerWeek","canvasNo","tbCustomerID","tbMetaDataID","tbBLID","tbPredecessor","tbAzureID","tbCoordRight","tbBarColor","tbTextColor","kbCoordLeft","kbCoordTop","focdItemCoordLeft","focdItemCoordTop"]
["Timebars Core Data"]
["UID","Parent","tbCoordTop","tbCoordLeft","tbHierarchyOrder","Name","Type","Portfolio","Project","Sub-Project","Task","Allocation","Owner","Start","Finish","Duration","AStart","AFinish","RemainingDuration","ResID","Calendar","PercentTimeOn","Work","AWork","WorkRemaining","PercentComplete","Cost","Acost","CostRemaining","PayRate","CostType","CostID","ConstraintType","ConstraintDate","Float","FreeFloat","ExpHoursPerWeek","canvasNo","CustomerID","MetaDataID","BLID","Predecessor","AzureID","CoordRight","BarColor","TextColor","kbCoordLeft","kbCoordTop","focdItemCoordLeft","focdItemCoordTop"]
[525,null,70,300,1,"Cloud Portfolio","Portfolio","Cloud Portfolio",null,null,null,null,0,"2021-01-15","2021-02-22",27,null,null,27,null,0,0,0,0,0,0,0,null,0,0,1,0,0,null,0,0,0,1,44,0,0,0,1,null,null,1,null,null,1,1]
[526,525,150,307,1,"Cloud to Ground Connectivity Project","Project","Cloud Portfolio","Cloud to Ground Connectivity Project",null,null,null,0,"2021-01-15","2021-02-22",27,null,null,27,null,0,0,0,0,0,0,0,null,0,0,0,0,0,null,0,0,0,1,44,0,0,0,0,null,null,1,null,null,1,1]
[527,526,340,459,1,"Choose vendor","Task","Cloud Portfolio","Cloud to Ground Connectivity Project",null,"Choose vendor",null,0,"2021-01-23","2021-03-02",27,null,null,27,null,0,0,0,0,0,0,0,null,0,0,0,0,"Pinned",null,0,0,0,1,44,0,0,0,0,null,null,1,null,null,1,1]
[528,526,230,551,1,"Vendor Selected","Milestone","Cloud Portfolio","Cloud to Ground Connectivity Project",null,"Vendor Selected",null,0,"2021-02-01","2021-02-01",1,null,null,1,null,0,0,0,0,0,0,0,null,0,0,0,0,"Pinned",null,0,0,0,1,44,0,0,0,0,null,null,1,null,null,1,1]
[529,526,420,379,1,"Design vendor specific network architecture","Sub-Project","Cloud Portfolio","Cloud to Ground Connectivity Project","Design vendor specific network architecture",null,null,0,"2021-01-15","2021-02-22",27,null,null,27,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,1,44,0,0,0,0,null,null,1,null,null,1,1]
[530,529,200,420,1,"Go/No Go Implement Network in Cloud","Gate","Cloud Portfolio","Cloud to Ground Connectivity Project","Design vendor specific network architecture","Go/No Go Implement Network in Cloud",null,0,"2021-01-15","2021-01-22",6,null,null,6,null,0,0,0,0,0,0,0,null,0,0,0,0,"Pinned",0,0,0,0,1,44,0,0,0,0,null,null,1,null,null,1,1]

{"sheet":"MetaData","index":2,"n_rows":9,"n_cols":100,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,0,1,6]]}
["tbMDID","tbMDName","tbMDProjectType","tbMDPortfolio","tbMDProgram","tbMDExecutiveSummary","tbMDGate","tbMDDeliveryManager","tbMDBusinessAdvisor","tbMDBusinessOwner","tbMDEstimationClass","tbMDROMEstimate","tbMDInvestmentCategory","tbMDInvestmentInitiative","tbMDInvestmentObjective","tbMDInvestmentStrategy","tbMDPriorityStrategic","tbMDCustomerID","tbMDAzureID","tbMDNameShort","tbMDProjectNumber","tbMDDescription","tbMDNotes","tbMDExtLink1","tbMDExtSystemID1","tbMDSortOrder","tbMDtbLastModified","tbMDPriority","tbMDStatus","tbMDState","tbMDSeverity","tbMDStage","tbMDPhase","tbMDCategory","tbMDHealth","tbMDResponsibility","tbMDDepartment","tbMDExSponsor","tbMDPM","tbMDShowIn","tbMDYesNoSelector","tbMDProduct","tbMDContact","tbMDWBS","tbMDWeighting","tbMDLocation","tbMDPrimarySkill","tbMDPrimaryRole","tbMDOther2","tbMDOther3","tbMDOther4","canvasNo","tbMDProgActivityAlignment","tbMDBackgroundInfo","tbMDConsequence","tbMDExpectedBenfits","tbMDProblemOpportunity","tbMDCapabilitiesNeeded","tbMDSeniorLevelCommittment","tbMDSprintName","tbMDStakeholderDescription","tbMDHealthCost","tbMDHealthHours","tbMDHealthIssues","tbMDHealthOverall","tbMDHealthRisk","tbMDHealthSchedule","tbMDHealthScope","tbMDBenefitCostRatio","tbMDConstraintsAssumptions","tbMDContractNumber","tbMDCostBenefitAnalysis","tbMDEcnomicValueAdded","tbMDInternalRateOfReturn","tbMDNetPresentValue","tbMDOpportunityCost","tbMDOrgManager","tbMDPaybackPeriod","tbMDRiskVsSizeAndComplexity","tbMDSize","tbMDStageApprover","tbMDSunkCosts","tbMDWrittenBy","tbMDPrimaryLineOfBusiness","tbMDNotesWorkflow","tbMDSyncNotes","tbMDSponsoringDepartment","tbMDPrimaryContact","tbMDContactNumber","tbMDResponsibleTeam","tbMDNotesProject","tbMDOther5","tbMDOther6","tbMDOther7","tbMDOther8","tbMDOther9","tbMDOther10","tbMDOther11","tbMDOther12","tbMDRefID"]
["Timebars Metadata"]
["UID","Name","Project Type","Portfolio","Program","Executive Summary","Gate","Delivery Manager","Business Advisor","Business Owner","Estimation Class","ROM Estimate","Investment Category","Investment Initiative","Investment Objective","Investment Strategy","Priority Strategic","CustomerID","AzureID","Name Short","Project No","Description","Notes","ExtLink1","ExtSystemID1","Sort Order","Last Modified","Priority","Status","State","Severity","Stage","Phase","Category","Health","Responsibility","Department","Sponsor","PM","ShowIn","YesNoSelector","Product","Contact","WBS","Weighting","Location","Primary Skill","Primary Role","Other2","Other3","Other4","canvasNo","Prog Activity Alignment","Background Info","Consequence","Expected Benfits","Problem Opportunity","Capabilities Needed","Senior Level Committment","Sprint Name","Stakeholder Description","Health Cost","Health Hours","Health Issues","Health Overall","Health Risk","Health Schedule","Health Scope","Benefit Cost Ratio","Constraints Assumptions","Contract No","Cost Benefit Analysis","Ecnomic Value Added","Internal Rate Of Return","Net Present Value","Opportunity Cost","Org Manager","Payback Period","Risk Vs Size And Complexity","Size","Stage Approver","Sunk Costs","Written By","Primary Line Of Business","Notes Workflow","Sync Notes","Sponsoring Department","Primary Contact","Contact Number","Responsible Team","Notes Project","Other5","Other6","Other7","Other8","Other9","Other10","Other11","Other12","RefID"]
[525,"auto-created for tbID cross ref: 525",0,0,0,"My Summary",0,0,0,0,0,0,0,0,0,0,0,44,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Joe Cloud",0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"a573"]
[526,"auto-created for tbID cross ref: 526",0,0,0,"My Summary",0,0,0,0,0,0,0,0,0,0,0,44,0,0,0,"We did most of the heavy lifting for you to provide a default stylings that incorporate our custom components. Additionally, we refined animations and transitions to provide a smoother experience for developers.","These are a bunch of notes regarding this project",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Joe Cloud",0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"a573"]
[527,"auto-created for tbID cross ref: 527",0,0,0,"My Summary",0,0,0,0,0,0,0,0,0,0,0,44,0,0,0,"We did most of the heavy lifting for you to provide a default stylings that incorporate our custom components. Additionally, we refined animations and transitions to provide a smoother experience for developers.","These are a bunch of notes regarding this project",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Joe Cloud",0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"a527"]
[528,"auto-created for tbID cross ref: 528",0,0,0,"My Summary",0,0,0,0,0,0,0,0,0,0,0,44,0,0,0,"We did most of the heavy lifting for you to provide a default stylings that incorporate our custom components. Additionally, we refined animations and transitions to provide a smoother experience for developers.","These are a bunch of notes regarding this project",0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Joe Cloud",0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"a573"]
[529,"auto-created for tbID cross ref: 529",0,0,0,"My Summary",0,0,0,0,0,0,0,0,0,0,0,44,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Joe Cloud",0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"a573"]
[530,"auto-created for tbID cross ref: 529",0,0,0,"My Summary",0,0,0,0,0,0,0,0,0,0,0,44,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Joe Cloud",0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"a573"]

{"sheet":"Tags","index":3,"n_rows":341,"n_cols":14,"rows_kept":341,"cut":false,"hidden":false,"merged":[]}
["tbTagID","tbTagGroup","tbTagName","tbTagEntity","tbTagPopular","tbTagNameShort","tbTagPurpose","tbTagDescription","tbTagOwner","tbTagSortOrder","tbTagCustomerID","tbTagAzureID","tbTagEntity","tbTagLastModified"]
["Timebars Tagging Data"]
["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","Entity2","Tag Last Modified"]
[2,"Business Advisors","Joe Ba","ProjList","ProjList","Joe Ba","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[3,"Business Advisors","Sally Ba","ProjList","ProjList","Sally Ba","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[4,"Business Owners","Joe Bo","ProjList","ProjList","Joe Bo","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[5,"Business Owners","Sam bo","ProjList","ProjList","Sam bo","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[6,"Business Owners","Julia bo","ProjList","ProjList","Julia bo","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[7,"Calendar",8,"General","General",8,"defining working calendar in hours per day on this Timebar ","NA","System",0,44,0,"General","2021-01-01"]
[8,"Calendar",7.5,"General","General",7.5,"defining working calendar in hours per day on this Timebar ","NA","System",0,44,0,"General","2021-01-01"]
[9,"Category","Risk-based","General","Sched","Risk-based","use for any means to categorize timebars for custom reporting","NA","PMO",0,44,0,"General","2021-01-01"]
[10,"Category","Operational","General","Sched","Operational","use for any means to categorize timebars for custom reporting","NA","PMO",0,44,0,"General","2021-01-01"]
[11,"Category","Corporate","General","Sched","Corporate","use for any means to categorize timebars for custom reporting","NA","PMO",0,44,0,"General","2021-01-01"]
[12,"Category","Core","General","Sched","Core","use for any means to categorize timebars for custom reporting","NA","PMO",0,44,0,"General","2021-01-01"]
[13,"Contact","Jim","General","Sched","Jim","Person name and address to contact for questions regarding Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[14,"Contact","George","General","Sched","George","Person name and address to contact for questions regarding Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[15,"Cost Code","A5645","ResList","ResList","A5645","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[16,"Delivery Managers","Jim Dm","ProjList","ProjList","Jim Dm","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[17,"Delivery Managers","Al dm","ProjList","ProjList","Al dm","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[18,"Department","Sales and Marketing","General","Sched","Marketing","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[19,"Department","Engineering","General","Sched","Engineering","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[20,"Department","Manufacturing","General","Sched","BTS","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[21,"Department","Procurement","General","Sched","Insurance","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[22,"Department","Business Development","General","Sched","BD","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[23,"Department","Research and Development","General","Sched","S&!","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[24,"Department","Enterprise Services","General","Sched","ERM","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[25,"Department","Finance","General","Sched","Finance","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[26,"Department","Human Resources","General","Sched","HR","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[27,"Department","Product Management","General","Sched","F&I","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[28,"Department","Information Technology","General","Sched","CA","Define what area of the business is responsible for Timebar","NA","PMO",0,44,0,"General","2021-01-01"]
[29,"Document Purpose","Project Charter","General","General","NA","for tagging documents","NA","PMO",0,44,0,"General","2021-01-01"]
[30,"Document Purpose","Business Case","General","General","NA","for tagging documents","NA","PMO",0,44,0,"General","2021-01-01"]
[31,"Document Purpose","Approval Document","General","General","NA","for tagging documents","NA","PMO",0,44,0,"General","2021-01-01"]
[32,"Document Purpose","Gate Help","General","General","NA","Key for the Help pages on Gating forms","NA","System",0,44,0,"General","2021-01-01"]
[33,"Document Purpose","Timebar Help","General","General","NA","Key for pages appearing on help accordions","NA","System",0,44,0,"General","2021-01-01"]
[34,"Document Purpose","Main Page","General","General","NA","To identify web pages in marketing site","NA","System",0,44,0,"General","2021-01-01"]
[35,"Document Purpose","Marketing Page","General","General","NA","To identify web pages in marketing site","NA","System",0,44,0,"General","2021-01-01"]
[36,"Document Purpose","Contact Us Page","General","General","NA","To identify web pages in marketing site","NA","System",0,44,0,"General","2021-01-01"]
[37,"Document Purpose","Kanban Help","General","General","NA","Key for pages appearing on help accordions","NA","PMO",0,44,0,"General","2021-01-01"]
[38,"Document Purpose","Common Help","General","General","NA","Key for pages appearing on help accordions","NA","PMO",0,44,0,"General","2021-01-01"]
[39,"Document Purpose","General Web Page","General","General","NA","To identify web pages","NA","PMO",0,44,0,"General","2021-01-01"]
[40,"Document Status","Approved","General","General","NA","for tagging documents","NA","PMO",0,44,0,"General","2021-01-01"]
[41,"Document Status","First Draft","General","General","NA","for tagging documents","NA","PMO",0,44,0,"General","2021-01-01"]
[42,"Document Status","In Progress","General","General","NA","for tagging documents","NA","PMO",0,44,0,"General","2021-01-01"]
[43,"Document Status","Canceled","General","General","NA","for tagging documents","NA","PMO",0,44,0,"General","2021-01-01"]
[44,"Document Type","HTML","General","General","NA","for tagging documents","NA","PMO",0,44,0,"General","2021-01-01"]
[45,"Document Type","MS Word","General","General","NA","for tagging documents","NA","PMO",0,44,0,"General","2021-01-01"]
[46,"Document Type","PDF","General","General","NA","for tagging documents","NA","PMO",0,44,0,"General","2021-01-01"]
[47,"Estimation Class","Class A","ProjList","ProjList","Class A","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[48,"Estimation Class","Class B","ProjList","ProjList","Class B","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[49,"Estimation Class","Class C","ProjList","ProjList","Class C","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[50,"ExpectedHoursPerWeek",5,"ResList","ResList",5,"Use for estimating work needs","NA","PMO",0,44,0,"ResList","2021-01-01"]
[51,"ExpectedHoursPerWeek",10,"ResList","ResList",10,"Use for estimating work needs","NA","PMO",0,44,0,"ResList","2021-01-01"]
[52,"ExSponsor","Ally","General","Sched","Ally","List out your Executive Sponsors","NA","PMO",0,44,0,"General","2021-01-01"]
[53,"ExSponsor","Mike","General","Sched","Mike","List out your Executive Sponsors","NA","PMO",0,44,0,"General","2021-01-01"]
[54,"ExtSystemResID","456M23","ResList","General","456M23","Use to tie into exsiting systems in the organization","NA","PMO",0,44,0,"ResList","2021-01-01"]
[55,"ExtSystemResID","456M24","ResList","General","456M24","Use to tie into exsiting systems in the organization","NA","PMO",0,44,0,"ResList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[68,"Gates Release","1 Approved to Design","ProjList","ProjList","1 Approved to Design","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[69,"Gates Release","2 Approved to Develop","ProjList","ProjList","2 Approved to Develop","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[70,"Gates Release","3 Approved to Implement","ProjList","ProjList","3 Approved to Implement","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[74,"Health","On schedule","General","Sched","On schedule","For Dashboard indicators","NA","PMO",0,44,0,"General","2021-01-01"]
[75,"Health","Early","General","Sched","Early","For Dashboard indicators","NA","PMO",0,44,0,"General","2021-01-01"]
[76,"Health","Slipping","General","Sched","Slipping","For Dashboard indicators","NA","PMO",0,44,0,"General","2021-01-01"]
[77,"Health","Late","General","Sched","Late","For Dashboard indicators","NA","PMO",0,44,0,"General","2021-01-01"]
[78,"Health","Blocked","General","Sched","Blocked","For Dashboard indicators","NA","PMO",0,44,0,"General","2021-01-01"]
[79,"Health","Completed","General","Sched","Completed","For Dashboard indicators","NA","PMO",0,44,0,"General","2021-01-01"]
[80,"Health","Attention","General","Sched","Attention","For Dashboard indicators","NA","PMO",0,44,0,"General","2021-01-01"]
[81,"Health Indicators","Green","ProjList","ProjList","Green","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[82,"Health Indicators","Yellow","ProjList","ProjList","Yellow","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[83,"Health Indicators","Red","ProjList","ProjList","Red","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[84,"HyperLinks","Link 1","ProjList","General","Link 1","for manually storing hyperlink to external info.","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[85,"HyperLinks","Link 2","ProjList","General","Link 2","for manually storing hyperlink to external info.","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[86,"Investment Category","IT Platform","ProjList","ProjList","IT Platform","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[87,"Investment Category","Office Environment","ProjList","ProjList","Office Environment","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[88,"Investment Category","Business Support","ProjList","ProjList","Business Support","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[89,"Investment Category","Engineering Tools","ProjList","ProjList","Engineering Tools","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[90,"Investment Category","Core Products","ProjList","ProjList","Core Products","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[91,"Investment Category","Innovation","ProjList","ProjList","Innovation","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[92,"Investment Initiative","Improve product reliability","ProjList","ProjList","Improve product reliability","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[93,"Investment Initiative","Cross-sell our Network Device products","ProjList","ProjList","Cross-sell our Network Device products","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[94,"Investment Initiative","Engineering Tool Innovation","ProjList","ProjList","Engineering Tool Innovation","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[95,"Investment Initiative","Faster response to new business opportunities","ProjList","ProjList","Faster response to new business opportunities","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[97,"Investment Initiative","Support moden digital workplace","ProjList","ProjList","Support moden digital workplace","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[98,"Investment Initiative","Improve Employee Skills","ProjList","ProjList","Improve Employee Skills","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[99,"Investment Initiative","Improve productivity with Agile Teams","ProjList","ProjList","Improve productivity with Agile Teams","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[100,"Investment Objective","Run the Business","ProjList","ProjList","Run the Business","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[101,"Investment Objective","Grow the Business","ProjList","ProjList","Grow the Business","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[102,"Investment Objective","Transform the Business","ProjList","ProjList","Transform the Business","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[103,"Investment Strategy","Server more customers","ProjList","ProjList","Server more customers","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[104,"Investment Strategy","Best in market core products","ProjList","ProjList","Best in market core products","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[105,"Investment Strategy","Increase revenue","ProjList","ProjList","Increase revenue","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[106,"Investment Strategy","Increase share of market","ProjList","ProjList","Increase share of market","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[107,"Investment Strategy","Ensure compliance","ProjList","ProjList","Ensure compliance","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[108,"Investment Strategy","Attract and retain the best people","ProjList","ProjList","Attract and retain the best people","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[109,"Investment Strategy","Improve and maintain workplace safety","ProjList","ProjList","Improve and maintain workplace safety","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[110,"Investment Strategy","Reduce waste","ProjList","ProjList","Reduce waste","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[111,"Investment Strategy","Improve customer service","ProjList","ProjList","Improve customer service","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[112,"L1","TopLevel","ProjList","General","TopLevel","Can use to make custom hierarchy","NA","System",0,44,0,"ProjList","2021-01-01"]
[113,"L2","Next Level Down","ProjList","General","Next Level Down","Can use to make custom hierarchy","NA","System",0,44,0,"ProjList","2021-01-01"]
[114,"L3","Third Level Down","ProjList","General","Third Level Down","Can use to make custom hierarchy","NA","System",0,44,0,"ProjList","2021-01-01"]
[115,"Labour Type","External","ResList","ResList","External","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[116,"Labour Type","Internal","ResList","ResList","Internal","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[117,"Labour Type","Contract","ResList","ResList","Contract","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[118,"Lifecycle Phase","1 Pre-execution (evaluation and selection)","ProjList","ProjList","1 Pre-execution (evaluation and selection)","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[119,"Lifecycle Phase","2 Execution (gating approvals)","ProjList","ProjList","2 Execution (gating approvals)","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[120,"Lifecycle Phase","3 Closing (outcome analysis)","ProjList","ProjList","3 Closing (outcome analysis)","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[121,"Location","Ottawa","General","ResList","Ottawa","Where is resource located","NA","PMO",0,44,0,"General","2021-01-01"]
[122,"Location","Gatineau","General","ResList","Gatineau","Where is resource located","NA","PMO",0,44,0,"General","2021-01-01"]
[123,"Non Project Tag","No","ProjList","ProjList","No","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[124,"Non Project Tag","Yes","ProjList","ProjList","Yes","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[125,"OOM Estimates","0 to 100K","ProjList","ProjList","0 to 100K","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[126,"OOM Estimates","1001K to 5000K","ProjList","ProjList","1001K to 5000K","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[127,"OOM Estimates","101K to 300K","ProjList","ProjList","101K to 300K","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[128,"OOM Estimates","301K to 1000K","ProjList","ProjList","301K to 1000K","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[129,"OOM Estimates","1000K Plus","ProjList","ProjList","1000K Plus","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[130,"Organizational Manager","Kent Om","ProjList","ProjList","Kent Om","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[131,"Organizational Manager","Perry Om","ProjList","ProjList","Perry Om","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[132,"Parttime Fulltime","Full Time","ResList","ResList","Full Time","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[133,"Parttime Fulltime","Part Time","ResList","ResList","Part Time","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[134,"PartTimeFullTime","FullTime","ResList","ResList","FullTime","Resource is a full time person or a part time person such as contractor","NA","HR",0,44,0,"ResList","2021-01-01"]
[135,"PartTimeFullTime","PartTime","ResList","ResList","PartTime","Resource is a full time person or a part time person such as contractor","NA","HR",0,44,0,"ResList","2021-01-01"]
[136,"PartTimeFullTime","Unknown","ResList","ResList","Unknown","Resource is a full time person or a part time person such as contractor","NA","HR",0,44,0,"ResList","2021-01-01"]
[137,"PercentTimeAllocated",10,"ResList","ResList",10,"Main tool to use to estimate timebar work","NA","PMO",0,44,0,"ResList","2021-01-01"]
[138,"PercentTimeAllocated",25,"ResList","ResList",25,"Main tool to use to estimate timebar work","NA","PMO",0,44,0,"ResList","2021-01-01"]
[139,"PercentTimeAllocated",50,"ResList","ResList",50,"Main tool to use to estimate timebar work","NA","PMO",0,44,0,"ResList","2021-01-01"]
[140,"PercentTimeAllocated",75,"ResList","ResList",75,"Main tool to use to estimate timebar work","NA","PMO",0,44,0,"ResList","2021-01-01"]
[141,"PercentTimeAllocated",100,"ResList","ResList",100,"Main tool to use to estimate timebar work","NA","PMO",0,44,0,"ResList","2021-01-01"]
[142,"PerecentAvailable",10,"ResList","ResList",10,"For taggin an allocation for resource management","NA","PMO",0,44,0,"ResList","2021-01-01"]
[143,"PerecentAvailable",25,"ResList","ResList",25,"For taggin an allocation for resource management","NA","PMO",0,44,0,"ResList","2021-01-01"]
[144,"PerecentAvailable",50,"ResList","ResList",50,"For taggin an allocation for resource management","NA","PMO",0,44,0,"ResList","2021-01-01"]
[145,"PerecentAvailable",75,"ResList","ResList",75,"For taggin an allocation for resource management","NA","PMO",0,44,0,"ResList","2021-01-01"]
[146,"PerecentAvailable",100,"ResList","ResList",100,"For taggin an allocation for resource management","NA","PMO",0,44,0,"ResList","2021-01-01"]
[147,"Phase","Initiating","General","Sched","Initiating","Highlevel Phase of Project or Program","NA","PMO",0,44,0,"General","2021-01-01"]
[148,"Phase","Executing","General","Sched","Executing","Highlevel Phase of Project or Program","NA","PMO",0,44,0,"General","2021-01-01"]
[149,"Phase","Closing","General","Sched","Closing","Highlevel Phase of Project or Program","NA","PMO",0,44,0,"General","2021-01-01"]
[150,"Phase","Planning","General","Sched","Planning","Highlevel Phase of Project or Program","NA","PMO",0,44,0,"General","2021-01-01"]
[151,"Portfolios","R&D New Technology","ProjList","ProjList","R&D New Technology","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[152,"Portfolios","Core Product Delivery","ProjList","ProjList","Core Product Delivery","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[153,"Portfolios","Business Support Systems","ProjList","ProjList","Business Support Systems","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[154,"Portfolios","IT Platform","ProjList","ProjList","IT Platform","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[155,"Portfolios","Building Services","ProjList","ProjList","Building Services","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[156,"Primary Contact","Ben Pc","ProjList","ProjList","Ben Pc","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[157,"Primary Contact","Sam Pc","ProjList","ProjList","Sam Pc","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[158,"Primary Contact","Dave Pc","ProjList","ProjList","Dave Pc","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[159,"Primary Line of Business","Finance","ProjList","ProjList","Finance","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[160,"Primary Line of Business","Research and Development","ProjList","ProjList","Research and Development","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[161,"Primary Line of Business","Business Development","ProjList","ProjList","Business Development","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[162,"Primary Line of Business","Corporate Affairs","ProjList","ProjList","Corporate Affairs","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[163,"Primary Line of Business","Business Technology Solutions","ProjList","ProjList","Business Technology Solutions","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[164,"Primary Line of Business","Engineering and Product Delivery","ProjList","ProjList","Engineering and Product Delivery","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[165,"Primary Line of Business","Human Resources","ProjList","ProjList","Human Resources","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[166,"Primary Skill","Inventing","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[167,"Primary Skill","HR Policies","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[168,"Primary Skill","Finance Policies","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[169,"Primary Skill","Procurement","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[170,"Primary Skill","Project Management","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[171,"Primary Skill","IT Architecture","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[172,"Primary Skill","Azure and AWS","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[173,"Primary Skill","Enterprise Architect","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[174,"Primary Skill","Coder","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[175,"Primary Skill","HTML 5 CSS Javascript","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[176,"Primary Skill","MS SQL and Oracle","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[177,"Primary Skill","SAP","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[178,"Primary Skill","Testing","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[179,"Primary Skill","Testing","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[180,"Primary Skill","Radio Design","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[181,"Primary Skill","Board Design","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[182,"Primary Skill","Antenna Design","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[183,"Primary Skill","Tower Design","ResList","ResList","NA","Tag resources for resource demand calculations","NA","PMO",0,44,0,"ResList","2021-01-01"]
[184,"Primary Strategic Priority","High","ProjList","ProjList","Improve intiitative visibility","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[185,"Primary Strategic Priority","Medium","ProjList","ProjList","Reduce complexity of process","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[186,"Primary Strategic Priority","Low","ProjList","ProjList","Fewer meetings","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[187,"Priority","High","General","Sched","High","Set timebar priority","NA","PMO",0,44,0,"General","2021-01-01"]
[188,"Priority","Medium","General","Sched","Med","Set timebar priority","NA","PMO",0,44,0,"General","2021-01-01"]
[189,"Priority","Low","General","Sched","Low","Set timebar priority","NA","PMO",0,44,0,"General","2021-01-01"]
[190,"Product","ModelA","General","Sched","ModelA","If this timebar is for creating a product, use this tag","NA","PMO",0,44,0,"General","2021-01-01"]
[191,"Product","ModelT","General","Sched","ModelT","If this timebar is for creating a product, use this tag","NA","PMO",0,44,0,"General","2021-01-01"]
[192,"Program Activity Alignment (PAA)","1 1 Program: Common One-Benefit service for all Canadians","ProjList","ProjList",null,"Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[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,0,"ProjList","2021-01-01"]
[196,"Programs","SAP System Upgrade","ProjList","ProjList","SAP System Upgrade","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[197,"Programs","Building and Office Modernization","ProjList","ProjList","Building and Office Modernization","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[198,"Programs","Centralized Billing and Receivables","ProjList","ProjList","Centralized Billing and Receivables","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[199,"Programs","Continuous Improvement Transformation","ProjList","ProjList","Continuous Improvement Transformation","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[200,"Programs","ERP Transformation","ProjList","ProjList","ERP Transformation","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[201,"Programs","Information Solutions Resiliency","ProjList","ProjList","Information Solutions Resiliency","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[202,"Programs","SharePoint 2016 Upgrade","ProjList","ProjList","SharePoint 2016 Upgrade","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[203,"Programs","Business Continuity Management Program","ProjList","ProjList","Business Continuity Management Program","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[204,"Programs","TBS Compliance","ProjList","ProjList","TBS Compliance","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[205,"Programs","Digital Workplace - Transformation","ProjList","ProjList","Digital Workplace - Transformation","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[206,"Programs","Ticketing System and Requirements Management","ProjList","ProjList","Ticketing System and Requirements Management","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[207,"Programs","Continuous Internal Delivery Enablement","ProjList","ProjList","Continuous Internal Delivery Enablement","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[208,"Programs","HR Service Delivery","ProjList","ProjList","HR Service Delivery","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[209,"Programs","Market Information Management","ProjList","ProjList","Market Information Management","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[210,"Programs","IM Policy and Guidelines","ProjList","ProjList","IM Policy and Guidelines","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[211,"Programs","Core Operations Program","ProjList","ProjList","Core Operations Program","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[212,"Programs","Integration API Development Program","ProjList","ProjList","Integration API Development Program","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[213,"Programs","NA","ProjList","ProjList","NA","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[214,"Programs","Standalone Project with No Program","ProjList","ProjList","Standalone Project with No Program","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[215,"Programs","Infrastructure as a Service (IaaS) Program","ProjList","ProjList","Infrastructure as a Service (IaaS) Program","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[216,"Project Managers","PM011","ProjList","ProjList","PM011","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[217,"Project Managers","Jim Pm","ProjList","ProjList","Jim Pm","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[218,"Project Managers","Al PM","ProjList","ProjList","Al PM","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[219,"Project Status","Active","ProjList","ProjList","Active","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[220,"Project Status","On-Hold","ProjList","ProjList","On-Hold","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[221,"Project Status","Canceled","ProjList","ProjList","Canceled","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[222,"ProjectManager","Sam","General","Sched","Sam","List out your PM's","NA","PMO",0,44,0,"General","2021-01-01"]
[223,"ProjectManager","Ralph","General","Sched","Ralph","List out your PM's","NA","PMO",0,44,0,"General","2021-01-01"]
[224,"ProjectNumber",15101,"General","Sched",0,"Custom numbering scheme specific to user","NA","PMO",0,44,0,"General","2021-01-01"]
[225,"ProjectNumber",15201,"General","Sched",0,"Custom numbering scheme specific to user","NA","PMO",0,44,0,"General","2021-01-01"]
[226,"Resource Class","Contractor","ResList","ResList","Contractor","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[227,"Resource Class","Perm","ResList","ResList","Perm","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[228,"Resource Class","Seasonal","ResList","ResList","Seasonal","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[229,"Resource Manager","Joe Rm","ResList","ResList","Joe Rm","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[230,"Resource Manager","Sally Rm","ResList","ResList","Sally Rm","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[231,"Resource Manager","Al Rm","ResList","ResList","Al Rm","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[232,"Resource Role","Product Owner/Sponsor","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[233,"Resource Role","SME HR","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[234,"Resource Role","SME Finance","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[235,"Resource Role","SME Purchasing","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[236,"Resource Role","SME PM","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[237,"Resource Role","SME IT Platforms and Datacenter","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[238,"Resource Role","SME Cloud Technologies","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[239,"Resource Role","SME Solution Architecture","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[240,"Resource Role","Developer General","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[241,"Resource Role","Developer Web","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[242,"Resource Role","Developer SQL","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[243,"Resource Role","Developer ERP System","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[244,"Resource Role","Tester New Software","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[245,"Resource Role","Tester Platforms and Datacenter","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[246,"Resource Role","Engineer RF","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[247,"Resource Role","Engineer Hardware","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[248,"Resource Role","Engineer Antennas","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[249,"Resource Role","Engineer Towers","ResList","ResList","NA","Tag resources for resource demand calculations","NA","system",0,44,0,"ResList","2021-01-01"]
[250,"Resource Supervisor","Sam Supr","ResList","ResList","Sam Supr","Resource or person tagging","NA","PMO",0,44,0,"ResList","2021-01-01"]
[251,"ResourceCalendar",8,"ResList","ResList",8,"For calculating wok on an Allocation","NA","PMO",0,44,0,"ResList","2021-01-01"]
[252,"ResourceCalendar",7.5,"ResList","ResList",7.5,"For calculating wok on an Allocation","NA","PMO",0,44,0,"ResList","2021-01-01"]
[253,"ResourceCalendar",24,"ResList","ResList",24,"For calculating wok on an Allocation","NA","PMO",0,44,0,"ResList","2021-01-01"]
[254,"Responsibility","Jim","General","Sched","Jim","Define who is responsible for Timebar when in trouble","NA","PMO",0,44,0,"General","2021-01-01"]
[255,"Responsibility","John","General","Sched","John","Define who is responsible for Timebar when in trouble","NA","PMO",0,44,0,"General","2021-01-01"]
[256,"Responsibility","Sally","General","Sched","Sally","Define who is responsible for Timebar when in trouble","NA","PMO",0,44,0,"General","2021-01-01"]
[257,"Responsible Teams","Accounting","ProjList","ProjList","Accounting","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[258,"Responsible Teams","Finance","ProjList","ProjList","Finance","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[259,"Responsible Teams","Procurement","ProjList","ProjList","Procurement","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[260,"Responsible Teams","Product Engineering","ProjList","ProjList","Product Engineering","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[261,"Responsible Teams","Information Technology","ProjList","ProjList","Information Technology","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[262,"Severity","Critical","General","Sched",1,"Indicates how severe a priority itme is, in terms of impact","NA","PMO",0,44,0,"General","2021-01-01"]
[263,"Severity","Important","General","Sched",2,"Indicates how severe a priority itme is, in terms of impact","NA","PMO",0,44,0,"General","2021-01-01"]
[264,"Severity","Normal","General","Sched",3,"Indicates how severe a priority itme is, in terms of impact","NA","PMO",0,44,0,"General","2021-01-01"]
[265,"Show In Reports","Executive Dashboard","ProjList","ProjList","Executive Dashboard","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[266,"Show In Reports","PM Dashboard","ProjList","ProjList","PM Dashboard","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[267,"Show In Reports","Project Sites","ProjList","ProjList","Project Sites","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[268,"ShowIn","Dashboard","ProjList","ProjList","Dashboard","A way to control visibility of Timebar for reporting and display","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[269,"ShowIn","MilesoneReport","ProjList","ProjList","MilesoneReport","A way to control visibility of Timebar for reporting and display","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[270,"ShowIn","NeverShow","ProjList","ProjList","NeverShow","A way to control visibility of Timebar for reporting and display","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[271,"Size","Small","ProjList","ProjList","Small","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[272,"Size","Medium","ProjList","ProjList","Medium","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[273,"Size","Large","ProjList","ProjList","Large","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[274,"Size","Release","ProjList","ProjList","Release","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[275,"Sponsoring Department","IT Department","ProjList","ProjList","IT Department","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[276,"Sponsoring Department","Customer Support Department","ProjList","ProjList","Customer Support Department","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[277,"Sponsoring Department","Presidents Office","ProjList","ProjList","Presidents Office","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[278,"Sponsors","Marsha Sp","ProjList","ProjList","Marsha Sp","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[279,"Sponsors","Sydney Sp","ProjList","ProjList","Sydney Sp","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[280,"Sponsors","Colin Sp","ProjList","ProjList","Colin Sp","Project Tagging","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[281,"Stage","1 Proposed","ProjList","ProjList","Proposed","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[282,"Stage","2 Triaged","ProjList","ProjList","Triaged","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[283,"Stage","3 Prioritized","ProjList","ProjList","Prioritized","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[284,"Stage","4 Selected","ProjList","ProjList","Selected","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[285,"Stage","5 Assigned","ProjList","ProjList","Assigned","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[286,"Stage","6 Delivering","ProjList","ProjList","Delivering","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[287,"Stage","7 Delivered","ProjList","ProjList","Delivered","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[288,"Stage","8 Closed","ProjList","ProjList","Closed","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[289,"Stage (Manual)","1 Proposed","ProjList","ProjList","Proposed","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[290,"Stage (Manual)","2 Triaged","ProjList","ProjList","Triaged","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[291,"Stage (Manual)","3 Prioritized","ProjList","ProjList","Prioritized","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[292,"Stage (Manual)","4 Selected","ProjList","ProjList","Selected","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[293,"Stage (Manual)","5 Assigned","ProjList","ProjList","Assigned","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[294,"Stage (Manual)","6 Delivering","ProjList","ProjList","Delivering","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[295,"Stage (Manual)","7 Delivered","ProjList","ProjList","Delivered","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[296,"Stage (Manual)","8 Closed","ProjList","ProjList","Closed","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[297,"State","Awaiting Approval","ProjList","ProjList","Awaiting Approval","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[298,"State","Awaiting Input","ProjList","ProjList","Awaiting Input","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[299,"State","Requested Approval","ProjList","ProjList","Requested Approval","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[300,"State","Approved","ProjList","ProjList","Approved","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[301,"State","Spawned","ProjList","ProjList","Spawned","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[302,"State","Awaiting Review","ProjList","ProjList","Awaiting Review","Controlling project lifecycle workflow","NA","PMO",0,44,0,"ProjList","2021-01-01"]
[303,"Status","Pending","General","Sched","Not Started","set Timebar Status","NA","PMO",0,44,0,"General","2021-01-01"]
[304,"Status","Active","General","Sched","In Progress","set Timebar Status","NA","PMO",0,44,0,"General","2021-01-01"]
[305,"Status","Deployed","General","Sched","Finished","set Timebar Status","NA","PMO",0,44,0,"General","2021-01-01"]
[306,"Status","Closed","General","Sched","Closed","set Timebar Status","NA","PMO",0,44,0,"General","2021-01-01"]
[307,"Status","Partially Deployed","General","Sched","Archived","set Timebar Status","NA","PMO",0,44,0,"General","2021-01-01"]
[308,"Status","On-Hold","General","Sched","Archived","set Timebar Status","NA","PMO",0,44,0,"General","2021-01-01"]
[309,"stdTasks","Project Start","StdTasks","StdTasks","Start","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,0,"StdTasks","2021-01-01"]
[310,"stdTasks","Design","StdTasks","StdTasks","Design","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,0,"StdTasks","2021-01-01"]
[311,"stdTasks","Develop","StdTasks","StdTasks","Dev","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,0,"StdTasks","2021-01-01"]
[312,"stdTasks","Test","StdTasks","StdTasks","Test","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,0,"StdTasks","2021-01-01"]
[313,"stdTasks","UAT","StdTasks","StdTasks","UAT","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,0,"StdTasks","2021-01-01"]
[314,"stdTasks","Project Finish","StdTasks","StdTasks","Finish","Drag and Drop on Project or Release to create a Standard Task","NA","PMO",0,44,0,"StdTasks","2021-01-01"]
[315,"tbType","Portfolio","NewBars","NewBars","Pf","Drag and Drop on Canvas to create new Portfolio","NA","system",0,44,0,"NewBars","2021-01-01"]
[316,"tbType","Program","NewBars","General","Prog","Drag and Drop on Portfilio to create new Program","NA","system",0,44,0,"NewBars","2021-01-01"]
[317,"tbType","Project","NewBars","NewBars","Proj","Drag and Drop on on Portfolio or Program to create new Project","NA","system",0,44,0,"NewBars","2021-01-01"]
[318,"tbType","Sub-Project","NewBars","NewBars","subProj","Drag and Drop on project to create sub project","NA","system",0,44,0,"NewBars","2021-01-01"]
[319,"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,0,"NewBars","2021-01-01"]
[320,"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,0,"NewBars","2021-01-01"]
[321,"tbType","Gate","NewBars","NewBars","Gate","Drop to create a gate object on canvas","NA","system",0,44,0,"NewBars","2021-01-01"]
[322,"tbType","Allocation","NewBars","General","Alloc","Not used, see Resource Allocator to assign a new Resource","NA","system",0,44,0,"NewBars","2021-01-01"]
[323,"tbType","Risk","NewBars","General","Risk","Future - drop anywhere to create a Risk","NA","system",0,44,0,"NewBars","2021-01-01"]
[324,"tbType","Issue","NewBars","General","Issue","Future - drop anywhere to create a Issue","NA","system",0,44,0,"NewBars","2021-01-01"]
[325,"tbType","ActionItem","NewBars","General","Actn","Future - drop anywhere to create an Action Item","NA","system",0,44,0,"NewBars","2021-01-01"]
[326,"tbType","Release","NewBars","NewBars","Rel","Drag and Drop on Canvas to create new release Timebar.","NA","system",0,44,0,"NewBars","2021-01-01"]
[327,"Team Leader","Ben tl","ResList","ResList","Ben tl","Resource or person tagging","NA","system",0,44,0,"ResList","2021-01-01"]
[328,"Team Leader","Erica tl","ResList","ResList","Erica tl","Resource or person tagging","NA","system",0,44,0,"ResList","2021-01-01"]
[329,"Team Leader","Julia tl","ResList","ResList","Julia tl","Resource or person tagging","NA","system",0,44,0,"ResList","2021-01-01"]
[330,"Type Of Initiative","Project","ProjList","ProjList","Project","Project Tagging","NA","system",0,44,0,"ProjList","2021-01-01"]
[331,"Type Of Initiative","Sprint","ProjList","ProjList","Sprint","Project Tagging","NA","system",0,44,0,"ProjList","2021-01-01"]
[332,"Type Of Initiative","Program","ProjList","ProjList","Program","Project Tagging","NA","system",0,44,0,"ProjList","2021-01-01"]
[333,"Type Of Initiative","Other","ProjList","ProjList","Other","Project Tagging","NA","system",0,44,0,"ProjList","2021-01-01"]
[334,"Type Of Initiative","Portfolio","ProjList","ProjList","Portfolio","Project Tagging","NA","system",0,44,0,"ProjList","2021-01-01"]
[335,"YesNo","Yes","General","General","Yes","for tagging a time bar for true or false on unknown","NA","system",0,44,0,"General","2021-01-01"]
[336,"YesNo","No","General","General","No","for tagging a time bar for true or false on unknown","NA","system",0,44,0,"General","2021-01-01"]
[337,"YesNo","NA","General","General","NA","for tagging a time bar for true or false on unknown","NA","system",6,44,0,"General","2021-01-01"]
[3381,"tbType","Tile","NewBars","NewBars","Tile","Drop to create a gate object on canvas","NA","system",0,44,0,"NewBars","2021-01-01"]
[3391,"tbType","Pin","General","General","Pin","Drop on Task, Milestone or Gate to pin","NA","system",0,44,0,"General","2021-01-01"]

{"sheet":"Baseline","index":4,"n_rows":9,"n_cols":50,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["tbID","tbSelfKey2","tbCoordTop","tbCoordLeft","tbHierarchyOrder","tbName","tbType","tbL1","tbL2","tbL3","tbL4","tbL5","tbOwner","tbStart","tbFinish","tbDuration","tbAStart","tbAFinish","tbRemainingDuration","tbResID","tbCalendar","tbPercentTimeOn","tbWork","tbAWork","tbWorkRemaining","tbPercentComplete","tbCost","tbAcost","tbCostRemaining","tbPayRate","tbCostType","tbCostID","tbConstraintType","tbConstraintDate","tbFloat","tbFreeFloat","tbExpHoursPerWeek","canvasNo","tbCustomerID","tbMetaDataID","tbBLID","tbPredecessor","tbAzureID","tbCoordRight","tbBarColor","tbTextColor","kbCoordLeft","kbCoordTop","focdItemCoordLeft","focdItemCoordTop"]
["Timebars Baseline Data"]
["Column1","tbSelfKey2","tbCoordTop","tbCoordLeft","tbHierarchyOrder","tbName","tbType","tbL1","tbL2","tbL3","tbL4","tbL5","tbOwner","tbStart","tbFinish","tbDuration","tbAStart","tbAFinish","tbRemainingDuration","tbResID","tbCalendar","tbPercentTimeOn","tbWork","tbAWork","tbWorkRemaining","tbPercentComplete","tbCost","tbAcost","tbCostRemaining","tbPayRate","tbCostType","tbCostID","tbConstraintType","tbConstraintDate","tbFloat","tbFreeFloat","tbExpHoursPerWeek","canvasNo","tbCustomerID","tbMetaDataID","tbBLID","tbPredecessor","tbAzureID","tbCoordRight","tbBarColor","tbTextColor","kbCoordLeft","kbCoordTop","focdItemCoordLeft","focdItemCoordTop"]
["BL01:525",0,70,210,1,"My New Portfolio","Portfolio","My Portfolio","My Project or Program","My SubProject or Project if program above it","My Task or my SubProject if program above","My Allocation or task if program above",0,"2021-01-06","2021-02-13",5,null,null,5,null,0,0,0,0,0,0,0,null,0,0,1,0,0,null,0,0,0,1,44,0,0,0,1,null,null,1,null,null,1,1]
["BL01:526","BL01:525",150,217,1,"My New Program/Project","Project","My Portfolio","My Project or Program","My SubProject or Project if program above it","My Task or my SubProject if program above","My Allocation or task if program above",0,"2021-01-06","2021-02-13",5,null,null,5,null,0,0,0,null,0,null,0,null,0,0,0,0,0,null,0,0,0,1,44,0,0,0,0,null,null,1,null,null,1,1]
["BL01:527","BL01:526",340,289,1,"My New Task","Task","My Portfolio","My Project or Program","My SubProject or Project if program above it","My Task or my SubProject if program above","My Allocation or task if program above",0,"2021-01-06","2021-02-13",5,null,null,5,null,0,0,0,null,0,null,0,null,0,0,0,0,null,null,0,0,0,1,44,0,0,0,0,null,null,1,null,null,1,1]
["BL01:528","BL01:526",230,461,1,"My New Milestone","Milestone","My Portfolio","My Project or Program","My SubProject or Project if program above it","My Task or my SubProject if program above","My Allocation or task if program above",0,"2021-01-23","2021-01-23",5,null,null,5,null,0,0,0,null,0,null,0,null,0,0,0,0,null,null,0,0,0,1,44,0,0,0,0,null,null,1,null,null,1,1]
["BL01:529","BL01:526",420,289,1,"My New Sub-Project","Sub-Project","My Portfolio","My Project or Program","My SubProject or Project if program above it","My Task or my SubProject if program above","My Allocation or task if program above",0,"2021-01-06","2021-02-13",5,null,null,5,null,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,1,44,0,0,0,0,null,null,1,null,null,1,1]
["BL01:530","BL01:526",200,330,1,"My New Gate","Gate","My Portfolio","My Project or Program","My SubProject or Project if program above it","My Task or my SubProject if program above","My Allocation or task if program above",0,"2021-01-06","2021-01-13",5,null,null,5,null,0,0,0,null,0,null,0,null,0,0,0,0,null,0,0,0,0,1,44,0,0,0,0,null,null,1,null,null,1,1]

{"sheet":"Resources","index":5,"n_rows":9,"n_cols":30,"rows_kept":9,"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"]
["Timebars Resource Pool"]
["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","ExtResID2","Coord Top","CoordLeft","LabourType","Email","PasswordHash","PIN","AzureID"]
[700,"Joe Invent","Joe Invent","Inventing","Product Owner/Sponsor","Office of CEO","Mario CEO",50,"Ateam","Ottawa","NA","NA","Full","Human","Internal",8,50,"A404",44,"t504",1,43285,"t504",10,6,"xrt","a1","a1","a1"]
[704,"Jack Project","Jack Project","Project Management","SME PM","Office of CEO","Mario CEO",100,"Bteam","Ottawa","NA","NA","Full","Human","Internal",4,50,"A408",44,"t508",5,43289,"t508",10,6,"xrt","a1","a1","a1"]
[708,"Sam Coder","Sam Coder","Coder","Developer General","IT Dept","Mr IT",75,"Bteam","Ottawa","NA","NA","Full","Human","Internal",7.5,25,"A411",44,"t511",8,43292,"t511",10,6,"xrt","a1","a1","a1"]
[709,"Jay Script","Jay Script","HTML 5 CSS Javascript","Developer Web","IT Dept","Mr IT",100,"Ateam","Ottawa","NA","NA","Full","Human","Internal",7.5,25,"A411",44,"t511",8,43292,"t511",10,6,"xrt","a1","a1","a1"]
[719,"Chris Java","Chris Java","HTML 5 CSS Javascript","Developer Web","IT Dept","Mr IT",50,"Ateam","Ottawa","NA","NA","PartTime","Human","Contract",7.5,25,"A411",44,"t511",8,43292,"t511",10,6,"xrt","a1","a1","a1"]
[800,"Product Owner","Product Owner/Sponsor","Inventing","Product Owner/Sponsor","Office of CEO","Mario CEO",75,"Bteam","Ottawa","NA","NA","Generic","Generic","NA",7.5,25,"A411",44,"t511",8,43292,"t511",10,6,"xrt","a1","a1","a1"]

{"sheet":"AdminPanel","index":6,"n_rows":6,"n_cols":22,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["ap_name","apID","apCustomerID","apFilteredFrom","apAzureID","apTS_WeeklyOrMonthly","apTS_WeeklyPxFactor","apTS_Start","apTS_Finish","apHelpCoordTop","apHelpCoordLeft","apTS_MonthlyPxFactor","apStatusDate","apFilteredFromTbID","ap_HolidayDate","ap_HolidayName","apSchMethod","apTbVisibleLevel","totalNumberOfPeople","numberOfPeoplePerLine","pxPerPerson","apHideCompletedBarsYN"]
["Timebars Settings Data"]
["ap_name","apID","apCustomerID","apFilteredFrom","apAzureID","apTS_WeeklyOrMonthly","apTS_WeeklyPxFactor","apTS_Start","apTS_Finish","apHelpCoordTop","apHelpCoordLeft","apTS_MonthlyPxFactor","apStatusDate","apFilteredFromTbID","ap_HolidayDate","ap_HolidayName","apSchMethod","apTbVisibleLevel","totalNumberOfPeople","numberOfPeoplePerLine","pxPerPerson","apHideCompletedBarsYN"]
["Standard Config Settings",1,44,"Canvas","a1","Weekly",10,"2020-12-15",null,50,400,2,"2021-01-06","nn",null,null,"Standard","L5",null,null,null,false]
["Bar Graph Settings",2,44,"Canvas",null,null,null,null,"",null,null,null,"",null,"",null,null,null,30,3,7]
["Standard Holidays",3,null,null,null,null,null,null,"",null,null,null,"",null,"25-Dec-2021","Christmas"]

{"sheet":"Documents","index":7,"n_rows":31,"n_cols":22,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["tbDocID","tbDocName","tbDocNameShort","tbDocStatus","tbDocPurpose","tbDocWrittenBy","tbDocBriefDescription","tbDocCustomerID","tbDocType","tbDocHTMLContent","tbDocGroup","tbDocOwner","tbDocPopular","tbDocSortOrder","tbDocLastModified","tbDocApprovedBy","tbDocL1","tbDocL2","tbDocL3","tbDocL4","tbDocL5","tbDocCardImage"]
["Timebars Document Data"]
["tbDocID","tbDocName","tbDocNameShort","tbDocStatus","tbDocPurpose","tbDocWrittenBy","tbDocBriefDescription","tbDocCustomerID","tbDocType","tbDocHTMLContent","tbDocGroup","tbDocOwner","tbDocPopular","tbDocSortOrder","tbDocLastModified","tbDocApprovedBy","tbDocL1","tbDocL2","tbDocL3","tbDocL4","tbDocL5","tbDocCardImage"]
[2018072436,"Common Help Page","Common help topics","First Draft","Common Help","Jim Cox","TBD",44,"HTML","<h1>Estimating Process</h1>\r\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>\r\n<h3><strong>Broad Cost Projection</strong></h3>\r\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>\r\n<h3><strong>Class&nbsp;'D' (Indicative) Estimate</strong></h3>\r\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>\r\n<h3><strong>Class&nbsp;'C' Estimate</strong></h3>\r\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>\r\n<h3><strong>Class&nbsp;'B' (Substantive) Estimate</strong></h3>\r\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>\r\n<h3><strong>Class&nbsp;'A' (Pre-Tender) Estimate</strong></h3>\r\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>\r\n<p>Note: from Public Services and Procurement Canada</p>","Help Articles","Jim Cox","Yes",28,"47 Aug 2021","TBD","Products","Software","Using Timebars","xxx","xxx","images/timebarslogogreen.png"]
[2018071656,"Demos","Demos","First Draft","Marketing Page","Jim Cox","TBD",44,"HTML","<h3>Demos</h3>\r\n<a href=\"http://res.cloudinary.com/dbdibjgrn/video/upload/v1532633134/Timebars%20Demos/Album_Medium.mp4\">Timebars Launch Demo</a> <br>\r\n<a href=\"http://res.cloudinary.com/dbdibjgrn/video/upload/v1525521858/tbvideo_custom.mp4\">See Timebars live on 80 inch screen</a>\r\n","Site Page","Jim Cox","Yes",20,"39 Aug 2021","TBD","Products","Software","Marketing","xxx","xxx","images/timebarslogogreen.png"]
[2018071657,"Feedback","Feedback","First Draft","Marketing Page","Jim Cox","TBD",44,"HTML","                    <h1>Feedback</h1>\r\n\r\n                    <p>\r\nPlease send us an email with any feedback to help us improve our product.\r\n                    </p>  ","Site Page","Jim Cox","Yes",21,"40 Aug 2021","TBD","Products","Software","Marketing","xxx","xxx","images/timebarslogogreen.png"]
[201807437,"Gate 1 Business Case","Gate 1 Business Case","First Draft","Gate Help","Jim Cox","TBD",44,"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>","PM Articles","Jim Cox","Yes",12,"2021-08-31","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[20180745,"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.",44,"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>","PM Articles","Jim Cox","Yes",8,"2021-08-27","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[27,"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?",44,"HTML","<h1>Purpose Gate 1 Strategic assessment and concept</h1>\r\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>\r\n<h1>Review issues</h1>\r\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>\r\n<h1>Why</h1>\r\n<p>To eliminate ideas that do not make sense or will prove to be impossible to execute</p>\r\n<h1>Core review items for this gate</h1>\r\n<ol>\r\n<li>Wisdom and appropriateness of proposed undertaking</li>\r\n<li>Articulation of the business problem and validity of the business imperative</li>\r\n<li>Definition and boundaries of scope</li>\r\n<li>Definition and measures of success</li>\r\n<li>Degree of common understanding about the proposal among parties involved</li>\r\n<li>Identification of stakeholders and extent of support and commitment for the initiative</li>\r\n<li>Confirmation that the project makes sense in the context of the departmental project portfolio and federal government priorities&nbsp;</li>\r\n</ol>\r\n<h1>Supporting item(s)</h1>\r\n<ol>\r\n<li>Plan and estimate (10%) for tasks and level of effort to next project gate</li>\r\n</ol>\r\n<h1>Typical input to the review</h1>\r\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>\r\n<p>The following areas need to be addressed:</p>\r\n<ol>\r\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>\r\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>\r\n<li>Review format Workshop review (conducting a few targeted interviews may be necessary)</li>\r\n</ol>\"","PM Articles","Jim Cox","Yes",6,"2021-08-25","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[201807430,"Gate 2 Business case and general readiness","Gate 2 Business case and general readiness","First Draft","Gate Help","Jim Cox","TBD",44,"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>","PM Articles","Jim Cox","Yes",7,"2021-08-26","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[201807417,"Gate 2 Pre-Construction","Gate 2 Pre-Construction","First Draft","Gate Help","Jim Cox","TBD",44,"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>","PM Articles","Jim Cox","Yes",13,"32 Aug 2021","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[3,"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?",44,"HTML","<h1>Purpose Gate 3 Business case and general readiness:</h1>\r\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>\r\n<h1>Review issues</h1>\r\n<p>Assurance that the business case is thorough, complete, and compelling</p>\r\n<p>Confirmation that the organization is ready to undertake the project</p>\r\n<h1>Why</h1>\r\n<p>To confirm that the business case is sufficiently compelling to justify, sustain, and guide the project</p>\r\n<p>To identify any shortcomings in readiness for action before approval and confirm that key identified risks can be managed</p>\r\n<h1>Core review items for this gate</h1>\r\n<ol>\r\n<li>Business case requirements:</li>\r\n</ol>\r\n<ul>\r\n<li>Clarity of business problem statement</li>\r\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>\r\n<li>Clear business justification for the project investment, including how goals can be quantified and measured, and their attainment confirmed</li>\r\n<li>Reconfirmation of the alignment of the project with organizations goals</li>\r\n<li>Thoroughness of options analysis, including reasonableness of costs and benefits for each option and reasonableness of selected option</li>\r\n<li>Indicative cost estimate and schedule</li>\r\n<li>Estimating methodology, basis for assumptions, and sensitivity analysis</li>\r\n</ul>\r\n<ol start=\"2\">\r\n<li>Organizational readiness to undertake the project:</li>\r\n</ol>\r\n<ul>\r\n<li>Arrangements decided upon Project Management Office (PMO), strategies for outcome management, performance management, and risk management</li>\r\n<li>Initial project planning under way and mechanisms in place</li>\r\n<li>Business requirements approach fully defined</li>\r\n<li>Preparation of environment in which to run project</li>\r\n<li>Assessment of organizational capacity relative to project difficulty (OPMCA)</li>\r\n<li>Evidence of intent and ability to create an environment for project success</li>\r\n<li>A Guide to Project Gating for IT-Enabled Projects 17</li>\r\n</ul>\r\n<h1>Supporting item(s)</h1>\r\n<ol>\r\n<li>Complete definition of the project:</li>\r\n</ol>\r\n<ul>\r\n<li>Project complexity and risk levels, scope, size, and packaging</li>\r\n<li>Risks, constraints, and dependencies (PCRA)</li>\r\n<li>Architecture and technological alignment (within federal government and department)</li>\r\n<li>Privacy issues (Privacy Impact Assessment, or PIA), security issues (Threat and Risk Assessment, or TRA), and other policy issues</li>\r\n</ul>\r\n<ol start=\"2\">\r\n<li>Updated plan and estimate (10%) for tasks, level of effort to next project gate</li>\r\n<li>PCRA and OPMCA</li>\r\n</ol>\r\n<h1>Typical input to the review</h1>\r\n<p>Business case standard, and detailed supporting analysis and documentation</p>\r\n<p>PCRA</p>\r\n<p>OPMCA</p>","PM Articles","Jim Cox","Yes",3,"2021-08-22","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[201807419,"Gate 3 Post-implementation review","Gate 3 Post-implementation review","First Draft","Gate Help","Jim Cox","TBD",44,"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>","PM Articles","Jim Cox","Yes",14,"33 Aug 2021","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[201807434,"Gate 3 Pre-Construction","Gate 3 Pre-Construction","In Progress","Gate Help","Jim Cox","TBD",44,"HTML",null,"PM Articles","Jim Cox","Yes",9,"2021-08-28","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[201807435,"Gate 4 Pre-Deployment","Gate 4 Pre-Deployment","First Draft","Gate Help","Jim Cox","TBD",44,"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>","PM Articles","Jim Cox","Yes",10,"2021-08-29","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[10,"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.",44,"HTML",{"$cut":{"chars":22112,"head":"<style type=\"text/css\"> @page { size: 21.59cm 27.94cm; margin: 2cm } p { margin-bottom: 0.25cm; background: transparent; font-family: \"apple-system\", \"BlinkMacSystemFont\", \"Segoe UI\", \"Roboto\", \"Oxygen-Sans\", \"Ubuntu\", \"Cantarell\", \"Helvetica Neue\", sans-serif; line-height: 115%; background: transparent } h1 { margin-bottom: 0.21cm; 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 Serif\", serif; font-size: 18pt; font-weight: bold } h2.cjk { font-family: \"Noto Serif CJK SC\"; font-size: 18pt; font-weight: bold } h2.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\">  <h2>Agile threads when working at MS</h2> <p>Thanks for your comment. I agree that Agile has branded itself as a software solution, as one can see from the Agile Manifesto. This was a deliberate decision for the founders like Jeff Sutherland, who was explicitly trying to defeat Conwayâ€™s Law, namely, that systems reflect the culture of the organizations that devises them. He was trying to insulate software developers from the vertical culture. Ironically, the origins of Agile lie not in software but in manufacturing, as one can see from the Nonaka/Takeuchi article that I cite.</p> <p>Agile is now spreading way beyond software, and, as you point out, it is hampered by its software branding. But the problem goes deeper than the brand. There is a whole difference in ideology. One is a vertical ideology of control. The other is a horizontal ideology of enablement. They have different goals, practices, values and metrics. They are like oil and water. They are not very compatible.</p> <p><br/>  </p> <p>Why donâ€™t Agile and management get along? In a poll last Wednesday of some 400 people working in many different firms where the practices known as Agile and Scrum are being implemented, 88% reported tension between the way Agile/Scrum teams are managed in their organization and the way the rest of the organization is managed. Only 8% reported â€œno tension.â€\u009d</p> <p>Two different worlds</p> <p>The reality is that â€œmanagementâ€\u009d and â€œAgileâ€\u009d are two different worlds.</p> <p><br/>  </p> <p>The world of â€œmanagementâ€\u009d is vertical. Its natural habitat comprises tall buildings in places like New York. Its mindset is also vertical. â€œStrategy gets set at the top,â€\u009d as Gary Hamel often explains. â€œPower trickles down. Big leaders appoint little leaders. Individuals compete for promotion. Compensation correlates with rank. Tasks are assigned. Managers assess performance. Rules tightly circumscribe discretion.â€\u009d The purpose of this vertical world is self-evident: to make money for the shareholders, including the top executives. Its communications are top-down. Its values are efficiency and predictability. The key to succeeding in this world is tight control. Its dynamic is conservative: to preserve the gains of the past. Its workforce is dispirited. It has a hard time with innovation. Its companies are being systemically disrupted. Its economyâ€”the Traditional Economyâ€”is in decline.</p> <p><br/>  </p> <p>The Agile world is horizontal. Its natural habitat is in low flat buildings in places like California, although it also spreading rapidly like a virus and has already established footholds in most of the tall vertical organizations. The Agile mindset is horizontal. Its purpose is to delight customers. Making money is the result, not the goal of its activities. Its focus is on continuous innovation. Its dynamic is enablement, rather than control. Its communications tend"}},"PM Articles","Jim Cox","Yes",0,"2021-08-20","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[22,"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.",44,"HTML","<h1>Purpose: Gate 5 Detailed project plan and functional specifications</h1>\r\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>\r\n<h1>Review issues</h1>\r\n<p>Assurance that the business case is thorough, complete, and compelling</p>\r\n<p>Confirmation that the organization is ready to undertake the project</p>\r\n<h1>Why</h1>\r\n<p>To confirm that the business case is sufficiently compelling to justify, sustain, and guide the project</p>\r\n<p>To identify any shortcomings in readiness for action before approval and confirm that key identified risks can be managed</p>\r\n<h1>Core review items for this gate</h1>\r\n<ol>\r\n<li>Business case requirements:</li>\r\n</ol>\r\n<ul>\r\n<li>Clarity of business problem statement</li>\r\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>\r\n<li>Clear business justification for the project investment, including how goals can be quantified and measured, and their attainment confirmed</li>\r\n<li>Reconfirmation of the alignment of the project with organization s goals</li>\r\n<li>Thoroughness of options analysis, including reasonableness of costs and benefits for each option and reasonableness of selected option</li>\r\n<li>Indicative cost estimate and schedule</li>\r\n<li>Estimating methodology, basis for assumptions, and sensitivity analysis</li>\r\n</ul>\r\n<ol start=\"2\">\r\n<li>Organizational readiness to undertake the project:</li>\r\n</ol>\r\n<p>Arrangements decided upon Project Management Office (PMO), strategies for outcome management, performance management, and risk management</p>\r\n<ul>\r\n<li>Initial project planning under way and mechanisms in place</li>\r\n<li>Business requirements approach fully defined</li>\r\n<li>Preparation of environment in which to run project</li>\r\n<li>Assessment of organizational capacity relative to project difficulty (OPMCA)</li>\r\n<li>Evidence of intent and ability to create an environment for project success</li>\r\n<li>A Guide to Project Gating for IT-Enabled Projects 17</li>\r\n</ul>\r\n<h1>Supporting item(s)</h1>\r\n<ol>\r\n<li>Complete definition of the project:</li>\r\n</ol>\r\n<ul>\r\n<li>Project complexity and risk levels, scope, size, and packaging</li>\r\n<li>Risks, constraints, and dependencies (PCRA)</li>\r\n<li>Architecture and technological alignment (within federal government and department)</li>\r\n<li>Privacy issues (Privacy Impact Assessment, or PIA), security issues (Threat and Risk Assessment, or TRA), and other policy issues</li>\r\n</ul>\r\n<ol start=\"2\">\r\n<li>Updated plan and estimate (10%) for tasks, level of effort to next project gate</li>\r\n<li>PCRA and OPMCA</li>\r\n</ol>\r\n<h1>Typical input to the review</h1>\r\n<p>Business case standard, and detailed supporting analysis and documentation</p>\r\n<p>PCRA</p>\r\n<p>OPMCA</p>\r\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>","PM Articles","Jim Cox","Yes",1,"2021-08-21","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[201807436,"Gate 5 Post Implementation","Gate 5 Post Implementation","First Draft","Gate Help","Jim Cox","TBD",44,"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>","PM Articles","Jim Cox","Yes",11,"2021-08-30","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[4,"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.",44,"HTML","<h1>Purpose: Gate 6 Construction complete and deployment readiness</h1>\r\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>\r\n<h1>Review issues</h1>\r\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>\r\n<h1>Why</h1>\r\n<p>To ensure the project is ready to proceed with deployment, and that system migration plans and ongoing support are in place</p>\r\n<p>Core review items for this gate</p>\r\n<ol>\r\n<li>Reconfirmation that the project is aligned with departmental goals, the business case is valid, and expected outcomes will occur</li>\r\n<li>Construction complete and deliverables, including all documentation, accepted</li>\r\n<li>System migrated to production, and user acceptance testing complete</li>\r\n<li>Business change management, deployment, training, data migration, and conversion plans complete</li>\r\n<li>System migration plan validated</li>\r\n<li>Ongoing support and service management plans in place</li>\r\n<li>Vulnerability assessment complete</li>\r\n<li>Overall business and project readiness</li>\r\n</ol>\r\n<h1>Supporting item(s)</h1>\r\n<ol>\r\n<li>Updated plan and estimate (10%) for tasks and level of effort to project close-out</li>\r\n</ol>\r\n<h1>Typical input to the review</h1>\r\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>\r\n<p>Support and service management plan&nbsp;</p>\r\n<p>Disaster recovery and business resumption plans</p>\r\n<h1>Review format</h1>\r\n<p>Quick or full review, depending on project size, risk, and complexity</p>\r\n<h1>Notes on Gate 6</h1>\r\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>\r\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>\r\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>\r\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>\r\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>\r\n<p>24</p>\r\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>","PM Articles","Jim Cox","Yes",4,"2021-08-23","TBD","Process","PM","Project Gating","xxx","xxx","images/timebarslogogreen.png"]
[5,"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.",44,"HTML","<h1>Purpose Gate 7 Post-implementation review</h1>\r\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>\r\n<h1>Review issues</h1>\r\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>\r\n<h1>Why</h1>\r\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>\r\n<h1>Core review items for this gate</h1>\r\n<ol>\r\n<li>Project delivery measured against original objectives</li>\r\n<li>Confirmation of the archiving of information and deliverables, as applicable</li>\r\n<li>Knowledge transfer and transition to successful service</li>\r\n<li>Completion of contractual obligations</li>\r\n<li>Validation of business outcomes</li>\r\n<li>Capture of lessons learned, including review process</li>\r\n<li>Project close-out report completed</li>\r\n</ol>\r\n<h1>Typical input to the review</h1>\r\n<ul>\r\n<li>Project close-out report</li>\r\n<li>Business outcomes measurement plan</li>\r\n<li>Contract acceptance reports</li>\r\n<li>Project lessons learned</li>\r\n</ul>\r\n<h1>Review format</h1>\r\n<p>Workshop to full review, depending on project</p>","PM Articles","Jim Cox","Yes",5,"2021-08-24","TBD","Process","PM","Project Gating",null,null,"images/timebarslogogreen.png"]
[2018072422,"Getting Started Help Page","Getting Started","First Draft","Timebar Help","Jim Cox","TBD",44,"HTML","<ol><li>To get started, click menu items Admin &gt; DB-Admin &gt; Go</li><li>Look for \"Success\" in red text top left, if successful, Click Go-Timebars!</li><li>You should see the timescale Canvas and demo timebars! Drag bars to make start and finish date changes.</li><li>Click \"Show Menu\" on top left of Canvas. Use this to filter timebars for specific projects in Portfolios.</li><li>Hover over the Menu items, click on a Portfolio, Project or Sub-Project to display filtered Timebars.</li><li>Close the Menu, Click on a Timebar title to see cost, schedule and metadata information in Side Panel.</li><li>To edit the Timebar Title, begin typing in the Side Panel</li><li>To change cost and schedule data, move, stretch or shrink bars to suit.</li><li>To change Timescale and scheduling settings, click \"Settings button\".</li></ol>","Help Articles","Jim Cox","Yes",25,"44 Aug 2021","TBD","Products","Software","Using Timebars","xxx","xxx","images/timebarslogogreen.png"]
[2018072440,"Getting Started Help Page 2","Back up and Restore","First Draft","Timebar Help","Jim Cox","TBD",44,"HTML","<h3>Make a Backup</h3>\r\n<p>Click the \"Data\" 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>\r\n<ol>\r\n<li>tbTimebars.txt (Timebars cost and schedule Data File)</li>\r\n<li>tbMetaData.txt (Timebars Metadata Data File)</li>\r\n<li>tbResources.txt (Resources Data File)</li>\r\n<li>tbTags.txt (Tagging Data File)</li>\r\n<li>tbResCalcs.txt (Resource Calculations Data File)</li>\r\n<li>tbConfigData.txt (Admin Panel Confi Data File)</li></ol><p><br></p><ol>\r\n</ol>\r\n<h3>How do I populate the system with my Project data?</h3>\r\n<div>\r\n<p>Your data must be within a text file in JSON format with matching field names. Use the downloaded files to determine format.</p>\r\nTo 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.\r\n<ol>\r\n<li>Timebars Data File</li>\r\n<li>Metadata Data File</li>\r\n<li>Resources Data File</li>\r\n<li>Tagging Data File</li>\r\n<li>Resource Calculations Data File</li>\r\n<li>Admin Panel Confi Data File</li>\r\n</ol></div>","Help Articles","Jim Cox","Yes",26,"45 Aug 2021","TBD","Products","Software","Using Timebars","xxx","xxx","images/timebarslogogreen.png"]
[2018071558,"How to Purchase","How to Purchase","First Draft","Marketing Page","Jim Cox","TBD",44,"HTML","                    <h1>How to Purchase</h1>\r\n\r\n                    <p>\r\n                        Use your credit card to get started <br>\r\n                        Coming soon...\r\n                    </p>  ","Site Page","Jim Cox","Yes",17,"36 Aug 2021","TBD","Products","Software","Marketing","xxx","xxx","images/timebarslogogreen.png"]
[2018071652,"How to return","How to return","First Draft","Marketing Page","Jim Cox","TBD",44,"HTML","                    <h1>How to Return</h1>\r\n\r\n                    <p>\r\n                        There would be nothing to return because there is nothing installed and nothing resides on our servers. <br>\r\n                        If you no longer wish to pay for Timebars, send us an email and we will stop billing your credit card.\r\n                    </p>  ","Site Page","Jim Cox","Yes",24,"43 Aug 2021","TBD","Products","Software","Using Timebars","xxx","xxx","images/timebarslogogreen.png"]
[2018072447,"Kanban help page 1","Getting Started","First Draft","Kanban Help","Jim Cox","TBD",44,"HTML","<ul>\r\n<li> To get started, click menu item DB-Admin &gt; Go. </li>\r\n<li> Click Go-TbKanban to load up Kanban board. </li>\r\n<li> The black round icons indicate sub-projects, click on a subproject \"Title\" to launch Kanban\r\nbars. </li>\r\n<li> To create a new Kanbar Bar, drag and drop the sub-project title onto the Canvas. </li>\r\n<li> The bar will be in edit mode, change data to suit. When done adding items, click refresh.</li>\r\n<li> Move bars around to suit, to edit click Edit Mode button on menu.</li>\r\n</ul>","Help Articles","Jim Cox","Yes",27,"46 Aug 2021","TBD","Products","Software","Using Timebars","xxx","xxx","images/timebarslogogreen.png"]
[201807151,"Licensing","Licensing","First Draft","Marketing Page","Jim Cox","TBD",44,"HTML","<h1>Licensing</h1>\r\n<p>We plan to charge monthly subscription fee.</p>\r\n<p>We have a free version but does not allow saving your data.</p>","Site Page","Jim Cox","Yes",19,"38 Aug 2021","TBD","Products","Software","Marketing","xxx","xxx","images/timebarslogogreen.png"]
[201807140,"Marketing Site Main Page","Marketing Site Main Page","First Draft","Marketing Page","Jim Cox","TBD",44,"HTML",null,"Site Page","Jim Cox","Yes",15,"34 Aug 2021","TBD","Products","Software","Marketing","xxx","xxx","images/timebarslogogreen.png"]
[2018071629,"New Users","New Users","First Draft","Marketing Page","Jim Cox","TBD",44,"HTML","\r\n        <!-- content-wrap starts here -->\r\n        <div id=\"content-wrap\">\r\n\r\n            <div id=\"main\">\r\n\r\n\r\n                <a id=\"NewUsers\"></a>\r\n                <h1>New Users</h1>\r\n\r\n                <p>\r\n                    It is easy to get started and use Timebars, it takes less than a minute and no software installation\r\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>\r\n                \r\n                <p><span style=\"color: inherit; font-family: inherit; font-size: 36px;\">What is Browser Cache?</span><br></p>\r\n                \r\n\r\n\r\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>\r\n                \r\n                                <p>\r\n                \r\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\">\r\n\r\n\r\n\r\n            </div>\r\n\r\n            <!-- content-wrap ends here -->\r\n        </div>","Site Page","Jim Cox","Yes",23,"42 Aug 2021","TBD","Products","Software","Using Timebars","xxx","xxx","images/timebarslogogreen.png"]
[2018071658,"Returning Users","Returning Users","First Draft","Marketing Page","Jim Cox","TBD",44,"HTML","                <a id=\"ReturningUsers\"></a>\r\n                <h1>Returning Users</h1>\r\n\r\n  <p>\r\n                <a href=\"/Canvas.html\">Launch Timebars! (July 2018 Release)</a>\r\n\r\n               \r\n\r\n                </p>","Site Page","Jim Cox","Yes",22,"41 Aug 2021","TBD","Products","Software","Using Timebars","xxx","xxx","images/timebarslogogreen.png"]
[201807150,"What Can I use it for web page","What Can I use it for web page","First Draft","Marketing Page","Jim Cox","TBD",44,"HTML","<p><br></p>","Site Page","Jim Cox","Yes",18,"37 Aug 2021","TBD","Products","Software","Marketing","xxx","xxx","images/timebarslogogreen.png"]
[2018071515,"Why use Timebars web page","Why use Timebars web page","First Draft","Marketing Page","Jim Cox","TBD",44,"HTML","<h3>Why choose to use Timebars?<br></h3>\r\n                \r\n<p>                    \r\n\r\nTo 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=\"images/timebarsbigscreen.png\" style=\"width: 668px;\"><br></p><p> </p>\r\n\r\n<p> \r\nThe 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>\r\n              \r\n\r\n                <a id=\"HotNewTools\"></a>\r\n                <p>Timebars is a \"no installation\", browser based dynamic web page for tracking who is working on what project and who is available for other work. </p><p>Using visual drag and drop gestures, you can move work allocations across the time scale and level over allocated resources.</p>\r\n\r\n                <p>\r\n\r\n                    \r\n                </p>\r\n\r\n                <p class=\"comments align-left\">\r\n                    You no longer have to depend on the IT Department, with Timebars you only need a\r\n                    web browser and an internet connection.\r\n                </p>\r\n\r\n\r\n\r\n            \r\n\r\n            <div id=\"sidebar\">\r\n\r\n                <h4>Wise Words</h4>\r\n                <p>\r\n                    \"Criticism is something you can avoid easily by saying nothing,\r\n                    doing nothing, and being nothing\"</p><h3>Modern Technology</h3><p>\r\n                </p>\r\n\r\n\r\n            </div>\r\n\r\n\r\n<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>\r\n<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>\r\n\r\n<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>","Site Page","Jim Cox","Yes",16,"35 Aug 2021","TBD","Products","Software","Marketing","xxx","xxx","images/timebarslogogreen.png"]

{"sheet":"ResCalcs","index":8,"n_rows":5,"n_cols":44,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["tbResCalcID","tbResCalcCustomerID","tbResCalcAzureID","tbResCalcName","tbResCalcTbID","tbResCalcWdays","tbResCalcStartWeekNo","tbResCalcTbWeekNo","tbResCalcTbResID","tbResCalcWeekSumHours","tbResCalcWeekSumCost","tbResCalcWeek","tbResCalcHours","tbResCalcLastModified","tbResCalcWeek1","tbResCalcWeek2","tbResCalcWeek3","tbResCalcWeek4","tbResCalcWeek5","tbResCalcWeek6","tbResCalcWeek7","tbResCalcWeek8","tbResCalcWeek9","tbResCalcWeek10","tbResCalcWeek11","tbResCalcWeek12","tbResCalcWeek13","tbResCalcWeek14","tbResCalcWeek15","tbResCalcWeek16","tbResCalcWeek17","tbResCalcWeek18","tbResCalcWeek19","tbResCalcWeek20","tbResCalcWeek21","tbResCalcWeek22","tbResCalcWeek23","tbResCalcWeek24","tbResCalcWeek25","tbResCalcWeek26","tbResCalcWeek27","tbResCalcWeek28","tbResCalcWeek29","tbResCalcWeek30"]
["Timebars Resource Caclulation Data"]
["tbResCalcID","tbResCalcCustomerID","tbResCalcAzureID","tbResCalcName","tbID","wdays","sWeekNo","tbWeekNo","tbResID","wkSumHours","wkSumCost","tbResCalcWeek","tbResCalcHours","tbResCalcLastModified","tbResCalcWeek1","tbResCalcWeek2","tbResCalcWeek3","tbResCalcWeek4","tbResCalcWeek5","tbResCalcWeek6","tbResCalcWeek7","tbResCalcWeek8","tbResCalcWeek9","tbResCalcWeek10","tbResCalcWeek11","tbResCalcWeek12","tbResCalcWeek13","tbResCalcWeek14","tbResCalcWeek15","tbResCalcWeek16","tbResCalcWeek17","tbResCalcWeek18","tbResCalcWeek19","tbResCalcWeek20","tbResCalcWeek21","tbResCalcWeek22","tbResCalcWeek23","tbResCalcWeek24","tbResCalcWeek25","tbResCalcWeek26","tbResCalcWeek27","tbResCalcWeek28","tbResCalcWeek29","tbResCalcWeek30"]
["a1","a44","a1","SummaryRow",525,0,5,30,700,0,0,null,0,43487,0,0,0,0,0,0,40,40,40,40,40,41.4,0,0,0,46.34,18.739999999999998,18.739999999999998,18.739999999999998,18.739999999999998,65.61,56.239999999999903,0,0,0,0,0,0,0,0]
[2,44,"a1","DetailRow",525,61,6,30,null,2.5,2.5,null,40,43487,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Fields","index":9,"n_rows":39,"n_cols":16,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["dfID","dfCoordTop","dfCoordLeft","dfWidth","dfName","dfType","dfTitle","dfFormName","dfLabel","dfPicklist","dfShowYN","dfOther1","dfOther2","dfOther3","dfOther4","dfOther5"]
["Timebars Dynamic Fields Data"]
["UID","Coord Top","Coord Left","Width ","Name","Type","Title","Form Name","Label","Picklist Name","Show In Form","Store Name","State","not used","not used2","not used3"]
[1,120,10,50,"tbMDID","NoPicklist","Item ID","PF1","UID",null,"Yes","tbMetaData","disabled"]
[2,75,1,500,"pfBand","Band","Portfolio Section","PF1","Portfolio Information",null,"Yes","tbMetaData"]
[3,120,85,380,"tbName","NoPicklist","Name of portfolio","PF1","Portfolio Name",null,"Yes","tbTimebars"]
[4,220,10,400,"tbMDExecutiveSummary","Editor","Please enter summary status of the initiative","PF1","Executive Summary",null,"Yes","tbMetaData"]
[5,320,10,200,"tbMDInvestmentCategory","WithPicklist","Investment Category","PF1","Investment Category","Investment Category","Yes","tbMetaData"]
[6,120,10,50,"tbID","NoPicklist","Item ID","PJ1","UID",null,"Yes","tbTimebars","disabled"]
[7,35,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","Editor","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,35,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,35,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","Editor","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,35,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"]
[32,120,10,50,"tbID","NoPicklist","Item ID","WF1","UID",null,"Yes","tbTimebars","disabled"]
[33,100,85,380,"tbName","NoPicklist","Name of Client","WF1","Name",null,"Yes","tbTimebars"]
[34,270,10,400,"tbMDNotesWorkflow","NoPicklist","Please enter just few lines not a thesis","WF1","Workflow Notes",null,"Yes","tbMetaData"]
[35,170,10,125,"tbMDProjectNumber","NoPicklist","Client number or ID","WF1","Client Number",null,"Yes","tbMetaData"]
[36,170,300,100,"tbMDStatus","WithPicklist","Workflow Status","WF1","Workflow Status","Project Status","Yes","tbMetaData"]

{"sheet":"Setup","index":10,"n_rows":128,"n_cols":16,"rows_kept":128,"cut":false,"hidden":false,"merged":[[13,1,13,4],[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],[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"]
["No","tbResources.js",null,null,null,null,null,null,"Tags","Yes","Yes"]
["No","tbTags.js",null,null,null,null,null,null,"Resources","Yes","Yes"]
["No","tbDocuments.js",null,null,null,null,null,null,"Baseline","Yes","Yes"]
["No","tbResCalcs",null,null,null,null,null,null,"Documents","Yes","Yes"]
["No","tbResCalcsDetailed",null,null,null,null,null,null,"AdminPanel","Yes","Yes"]
["No","tbAdminPanel",null,null,null,null,null,null,"ResCalcs","Yes","Yes"]
["No","tbBaseline"]
["No","AddTimebars.js"]
["No","tbMetaData3Pf.js"]
["No","tbTimebars3Pf.js"]
[null,"Source Path of JSON Files"]
[null,"F:\\Data_2020\\Timebars Technical\\Testing\\EDCGeorge"]
["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"]
[6,480,10,null,"tbMDExecutiveSummary","Editor","Please enter summary status of the initiative",null,"Executive Summary",null,null,"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","Editor","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","Editor","Please enter just few lines not a thesis",null,"Brief Description",null,"Yes","tbMetaData"]
[23,520,10,350,"tbMDNotes","Editor",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":"AllStandardFlds","index":11,"n_rows":101,"n_cols":21,"rows_kept":101,"cut":false,"hidden":false,"merged":[]}
["ID","MD Sheet","DataType","ID","TBCore Sht","DataType","ID","Tag sht","DataType","ID","Res Sheet","DataType","ID","doc Sht","DataType","ID","res calc sht","DataType","ID","admin panel sht","DataType"]
[0,"tbMDID","text",1,"tbID","text",0,"tbTagID","text",0,"tbResID","text",0,"tbDocID","text",0,"tbResCalcID","text",0,"ap_name","text"]
[1,"tbMDName","text",2,"tbSelfKey2","text",1,"tbTagGroup","text",1,"tbResName","text",1,"tbDocName","text",1,"tbResCalcCustomerID","text",1,"apID","text"]
[41,"tbMDProduct","text",2,"tbPredecessor","text",null,null,null,41,"tbResCountry","text",null,null,null,22,"tbResCalcWeek9","number"]
[74,"tbMDNetPresentValue","number",2,"tbTaskParent","text"]
[2,"tbMDProjectType","text",3,"tbCoordTop","number",2,"tbTagName","text",2,"tbResNameShort","text",2,"tbDocNameShort","text",2,"tbResCalcAzureID","text",2,"apCustomerID","text"]
[4,"tbMDProgram","text",4,"tbHierarchyOrder","number",4,"tbTagPopular","text",4,"tbResPrimaryRole","text",4,"tbDocPurpose","text",4,"tbResCalcTbID","text",4,"apAzureID","text"]
[5,"tbMDExecutiveSummary","text",5,"tbName","text",5,"tbTagNameShort","text",5,"tbResDepartment","text",5,"tbDocWrittenBy","text",5,"tbResCalcWdays","number",5,"apTS_WeeklyOrMonthly","text"]
[6,"tbMDGate","text",6,"tbType","text",6,"tbTagPurpose","text",6,"tbResManager","text",6,"tbDocBriefDescription","text",6,"tbResCalcStartWeekNo","number",6,"apTS_WeeklyPxFactor","number"]
[7,"tbMDDeliveryManager","text",7,"tbL1","text",7,"tbTagDescription","text",7,"tbResPayRate","number",7,"tbDocCustomerID","text",7,"tbResCalcTbWeekNo","number",7,"apTS_Start","date"]
[8,"tbMDBusinessAdvisor","text",8,"tbL2","text",8,"tbTagOwner","text",8,"tbResTeam","text",8,"tbDocType","text",8,"tbResCalcTbResID","text",8,"apTS_Finish","date"]
[9,"tbMDBusinessOwner","text",9,"tbL3","text",9,"tbTagSortOrder","number",9,"tbResLocation","text",9,"tbDocHTMLContent","text",9,"tbResCalcWeekSumHours","number",9,"apHelpCoordTop","number"]
[10,"tbMDEstimationClass","text",10,"tbL4","text",10,"tbTagCustomerID","text",10,"tbResTeamLeader","text",10,"tbDocGroup","text",10,"tbResCalcWeekSumCost","number",10,"apHelpCoordLeft","number"]
[11,"tbMDROMEstimate","text",11,"tbL5","text",11,"tbTagAzureID","text",11,"tbResSupervisor","text",11,"tbDocOwner","text",11,"tbResCalcWeek","date",11,"apTS_MonthlyPxFactor","number"]
[54,"tbMDConsequence","text",12,"tbStatus","text",null,null,null,54,"tbResCertNo","text",null,null,null,35,"tbResCalcWeek22","number"]
[57,"tbMDCapabilitiesNeeded","text",13,"tbState","text",null,null,null,57,"tbResStage","text",null,null,null,38,"tbResCalcWeek25","number"]
[55,"tbMDExpectedBenfits","text",14,"tbStep","text",null,null,null,55,"tbResStatus","text",null,null,null,36,"tbResCalcWeek23","number"]
[56,"tbMDProblemOpportunity","text",15,"tbStepStatus","text",null,null,null,56,"tbResState","text",null,null,null,37,"tbResCalcWeek24","number"]
[58,"tbMDSeniorLevelCommittment","text",16,"tbWfReasonNote","text",null,null,null,58,"tbResStep","text",null,null,null,39,"tbResCalcWeek26","number"]
[59,"tbMDSprintName","text",17,"tbStage","text",null,null,null,59,"tbResStepNotes","text",null,null,null,40,"tbResCalcWeek27","number"]
[53,"tbMDBackgroundInfo","text",18,"tbPriority","text",null,null,null,53,"tbResSignature","text",null,null,null,34,"tbResCalcWeek21","number"]
[60,"tbMDStakeholderDescription","text",18,"tbPhase","number",null,null,null,60,"tbResOffice","text",null,null,null,41,"tbResCalcWeek28","number"]
[12,"tbMDInvestmentCategory","text",20,"tbOwner","text",12,"tbTagEntity","text",12,"tbResPartTimeFullTime","text",12,"tbDocPopular","text",12,"tbResCalcHours","number",12,"apStatusDate","date"]
[13,"tbMDInvestmentInitiative","text",21,"tbStart","date",13,"tbTagLastModified","date",13,"tbResResourceType","text",13,"tbDocSortOrder","number",13,"tbResCalcLastModified","date",13,"apFilteredFromTbID","text"]
[14,"tbMDInvestmentObjective","text",22,"tbFinish","date",13,"tbTagMethod",null,14,"tbResResourceClass","text",14,"tbDocLastModified","date",44,"tbResCalcMonth","Date",14,"ap_HolidayDate","date"]
[15,"tbMDInvestmentStrategy","text",23,"tbDuration","number",21,"tbTagSite",null,15,"tbResResourceCalendar","number",15,"tbDocApprovedBy","text",45,"tbResCalcVolume","number",15,"ap_HolidayName","text"]
[16,"tbMDPriorityStrategic","text",24,"tbAStart","date",14,"tbTagL1",null,16,"tbResPercentGeneralAvailability","number",16,"tbDocL1","text",46,"tbResCalcWrkMonths","number",16,"apSchMethod","text"]
[17,"tbMDCustomerID","text",25,"tbAFinish","date",15,"tbTagL2",null,17,"tbResCostCode","text",17,"tbDocL2","text",47,"tbResCalcStatusDateStartMonthNo","number",17,"apTbVisibleLevel","text"]
[18,"tbMDAzureID","text",26,"tbRemainingDuration","number",18,"tbTagL3",null,18,"tbResCustomerID","text",18,"tbDocL3","text",48,"tbResCalcTbStartMonthNo","number",18,"totalNumberOfPeople","number"]
[22,"tbMDNotes","text",27,"tbWork","number",null,null,null,22,"tbResExtSystemResID","text",21,"tbDocSize","text",54,"tbResCalcMonthSumVolFir","number",22,"apT1","text"]
[68,"tbMDBenefitCostRatio","number",27,"tbVolume","number"]
[23,"tbMDExtLink1","text",28,"tbAWork","number",null,null,null,23,"tbResCoordTop","number",22,"tbDocLink","text",55,"tbResCalcMonthSumVolBalsam","number",23,"apT2","text"]
[24,"tbMDExtSystemID1","text",29,"tbWorkRemaining","number",null,null,null,24,"tbResCoordLeft","number",23,"tbDocVersion","text",56,"tbResCalcMonthSumVolSpruce","number",24,"apT3","text"]
[25,"tbMDSortOrder","number",30,"tbPercentComplete","number",null,null,null,25,"tbResLabourType","text",24,"tbDocMimeType","text",57,"tbResCalcGroup1","number",25,"apT4","text"]
[26,"tbMDtbLastModified","date",31,"tbCost","number",null,null,null,26,"tbResEmail","text",25,"tbDocReferences","text",58,"tbResCalcGroup2","number",26,"apT5","text"]
[27,"tbMDPriority","text",32,"tbAcost","number",null,null,null,27,"tbResPasswordHash","text",26,"tbDocHolds","text",59,"tbResCalcGroup3","text",27,"apT6","text"]
[28,"tbMDStatus","text",33,"tbCostRemaining","number",null,null,null,28,"tbResPIN","text",27,"tbDocCategory","text",60,"tbResCalcL1","text",28,"apT7","text"]
[61,"tbMDHealthCost","text",34,"tbPine","number",null,null,null,61,"tbResTransDate","text",null,null,null,42,"tbResCalcWeek29","number"]
[62,"tbMDHealthHours","text",35,"tbBalsam","number",null,null,null,62,"tbResStartDate","text",null,null,null,43,"tbResCalcWeek30","number"]
[63,"tbMDHealthIssues","text",36,"tbFir","number",null,null,null,63,"tbResTermDate","text",null,null,null,null,null,"number"]
[64,"tbMDHealthOverall","text",37,"tbSpruce","number",null,null,null,64,"tbResRemarks","text",null,null,null,null,null,"number"]
[65,"tbMDHealthRisk","text",38,"tbArea","number",null,null,null,65,"tbResMethod","text"]
[66,"tbMDHealthSchedule","text",39,"tbSize","number"]
[67,"tbMDHealthScope","text",40,"tbPercent2","number"]
[20,"tbMDProjectNumber","text",41,"tbCalendar","number",20,"tbTagL5",null,20,"tbResSortOrder","number",20,"tbDocL5","text",52,"tbResCalcMonthSumVolume","number",20,"pxPerPerson","number"]
[21,"tbMDDescription","text",42,"tbPercentTimeOn","number",null,null,null,21,"tbResLastModified","date",21,"tbDocCardImage","text",53,"tbResCalcMonthSumVolPine","number",21,"apHideCompletedBarsYN","text"]
[29,"tbMDState","text",42,"tbPayRate","number",null,null,null,29,"tbResAzureID","text",28,"tbDocNickName","text",61,"tbResCalcL2","text",29,"apT8","text"]
[36,"tbMDDepartment","text",42,"tbExpHoursPerWeek","number",null,null,null,36,"tbResStateProvince","text",null,null,null,17,"tbResCalcWeek4","number"]
[30,"tbMDSeverity","text",51,"tbCostType","text",null,null,null,30,"tbResEmail2","text",29,"tbDocT1","text",62,"tbResCalcL3","text",30,"apT9","text"]
[31,"tbMDStage","text",52,"tbCostID","text",null,null,null,31,"tbResFirstName","text",30,"tbDocT2","text",63,"tbResCalcL4","text",31,"apT10","text"]
[32,"tbMDPhase","text",53,"tbConstraintType","text",null,null,null,32,"tbResLastName","text",31,"tbDocT3","text",64,"tbResCalcL5","text"]
[33,"tbMDCategory","text",54,"tbConstraintDate","date",null,null,null,33,"tbResMiddleName","text",32,"tbDocT4","text",14,"tbResCalcWeek1","text"]
[34,"tbMDHealth","text",55,"tbFloat","number",null,null,null,34,"tbResStreet","text",33,"tbDocT5","text",15,"tbResCalcWeek2","text"]
[35,"tbMDResponsibility","text",56,"tbFreeFloat","number",null,null,null,35,"tbResCity","text",null,null,null,16,"tbResCalcWeek3","number"]
[19,"tbMDNameShort","text",58,"tbResID","text",19,"tbTagL4",null,19,"tbResExtSystemResID","text",19,"tbDocL4","text",49,"tbResCalcTbStartYearNo","number",19,"numberOfPeoplePerLine","number"]
[37,"tbMDExSponsor","text",58,"canvasNo","number",null,null,null,37,"tbResZipPostalCode","text",null,null,null,18,"tbResCalcWeek5","number"]
[38,"tbMDPM","text",59,"tbCustomerID","text",null,null,null,38,"tbResPhoneNo","text",null,null,null,19,"tbResCalcWeek6","number"]
[39,"tbMDShowIn","text",60,"tbMetaDataID","text",null,null,null,39,"tbResPhoneNo2","text",null,null,null,20,"tbResCalcWeek7","number"]
[40,"tbMDYesNoSelector","text",61,"tbBLID","text",null,null,null,40,"tbResCellPhoneNo","text",null,null,null,21,"tbResCalcWeek8","number"]
[42,"tbMDContact","text",63,"tbAzureID","text",null,null,null,42,"tbResCompany","text",null,null,null,23,"tbResCalcWeek10","number"]
[43,"tbMDWBS","text",64,"tbCoordRight","text",null,null,null,43,"tbResBirthday","text",null,null,null,24,"tbResCalcWeek11","number"]
[3,"tbMDPortfolio","text",65,"tbCoordLeft","number",3,"tbTagEntity","text",3,"tbResPrimarySkill","text",3,"tbDocStatus","text",3,"tbResCalcName","text",3,"apFilteredFrom","text"]
[44,"tbMDWeighting","number",65,"tbBarColor","text",null,null,null,44,"tbResLanguage","text",null,null,null,25,"tbResCalcWeek12","number"]
[45,"tbMDLocation","text",66,"tbTextColor","text",null,null,null,45,"tbResSocialLinks","text",null,null,null,26,"tbResCalcWeek13","number"]
[46,"tbMDPrimarySkill","text",67,"kbCoordLeft","number",null,null,null,46,"tbResCourse","text",null,null,null,27,"tbResCalcWeek14","number"]
[47,"tbMDPrimaryRole","text",68,"kbCoordTop","number",null,null,null,47,"tbResCourseFinishDate","text",null,null,null,28,"tbResCalcWeek15","number"]
[48,"tbMDOther2","text",69,"focdItemCoordLeft","number",null,null,null,48,"tbResPhoto","text",null,null,null,29,"tbResCalcWeek16","number"]
[49,"tbMDOther3","text",70,"focdItemCoordTop","number",null,null,null,49,"tbResPOBoxNo","text",null,null,null,30,"tbResCalcWeek17","number"]
[50,"tbMDOther4","text",71,"tbCountry","text",null,null,null,50,"tbResAptNo","text",null,null,null,31,"tbResCalcWeek18","number"]
[51,"canvasNo","number",72,"tbCompany","text",null,null,null,51,"tbResPostalStation","text",null,null,null,32,"tbResCalcWeek19","number"]
[52,"tbMDProgActivityAlignment","text",73,"tbLanguage","text",null,null,null,52,"tbResOccupation","text",null,null,null,33,"tbResCalcWeek20","number"]
[69,"tbMDConstraintsAssumptions","text",77,"tbT1","text"]
[70,"tbMDContractNumber","text",78,"tbT2","text"]
[71,"tbMDCostBenefitAnalysis","text",79,"tbT3","text"]
[72,"tbMDEcnomicValueAdded","number",80,"tbT4","text"]
[73,"tbMDInternalRateOfReturn","number",81,"tbT5","text"]
[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"]

{"sheet":"Audit Log","index":12,"n_rows":3,"n_cols":54,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Audit Log"]
[]
["UID","Parent","Coord Top","Coord Left","Hierarchy Order","Name","Type","Portfolio","L2","L3","L4","L5","Owner","Start","Finish","Duration","AStart","AFinish","Remaining Duration","ResID","Calendar","Percent Time On","Work","AWork","Work Remaining","PercentComplete","Cost","Acost","Cost Remaining","Pay Rate","CostType","CostID","ConstraintType","ConstraintDate","Float","FreeFloat","ExpHoursPerWeek","canvasNo","CustomerID","MetaDataID","BLID","Predecessor","AzureID","CoordRight","kbCoordTop","TextColor","kbCoordLeft","Column1","focdItemCoordLeft","focdItemCoordTop","Updated from PF Sheet When","Updated From Which PF Sheet","Updated from ERP/PPM When"," ERP or PPM"]

{"sheet":"SetupOld","index":13,"n_rows":60,"n_cols":28,"rows_kept":60,"cut":false,"hidden":false,"merged":[[34,1,34,6],[21,1,21,6],[23,1,23,6],[24,1,24,6],[25,1,25,6],[26,1,26,6],[27,1,27,6],[28,1,28,6],[20,3,20,6],[29,1,29,6],[30,1,30,6],[32,1,32,6],[33,1,33,6],[31,1,31,6]]}
[]
[]
[null,null,"Column Name","Theme"]
[null,"Level-1","tbL1","Test"]
[null,"Level-2","tbL2","Test",null,null,null,null,null,null,null,"todo List"]
[null,"Level-3","tbL3","Test",null,null,null,null,null,null,null,"Make sure all date and number fields are formatted correct"]
[null,"Level-4","tbL4","Test",null,null,null,null,null,null,null,"Maybe macro to set all at once."]
[null,"Level-5","tbL5","Test"]
[null,null,null,null,null,null,null,null,null,null,null,"Get rid of excel tables in name manager."]
[]
[]
[null,"ID","tbID"]
[null,"Parent","tbSelfKey2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wrong direction idiot"]
[null,"Name","tbName"]
[null,"Level","tbType"]
[null,"Null-Word"]
[]
[]
[]
[]
["Import Timebars Into Excel ",null,null,"External data must be in JSON format",null,null,null,null,"Validation and Formatting",null,null,null,"Column Data Types (default is text)"]
["Import Y/N","Source File Location and File Names",null,null,null,null,null,null,"Tab","Validate YN","ReFormat YN",null,"tbMetaData","DataType","tbcore","DataType","Tag","DataType","Res","DataType","Doc","DataType","ResCalc","DataType","AdminPanel","DataType","BL","DataType"]
["Source","C:\\Timebars\\DataFiles\\Timebars To Excel",null,null,null,null,null,null,"Timebars","Yes","Yes",null,"tbMDtbLastModified","date","tbCoordTop","number","tbTagSortOrder","number","tbResPayRate","number","tbDocSortOrder","number","tbResCalcWdays","number","apTS_WeeklyPxFactor","number","tbCoordTop","number"]
["Yes","tbTimebars.js",null,null,null,null,null,null,"MetaData","Yes","Yes",null,"tbMDWeighting","number","tbCoordLeft","number","tbTagLastModified","date","tbResResourceCalendar","number","tbDocLastModified","date","tbResCalcStartWeekNo","number","apTS_Start","date","tbCoordLeft","number"]
["Yes","tbMetaData.js",null,null,null,null,null,null,"Tags","Yes","Yes",null,"canvasNo","number","tbHierarchyOrder","number",null,null,"tbResPercentGeneralAvailability","number",null,null,"tbResCalcTbWeekNo","number","apTS_Finish","date","tbHierarchyOrder","number"]
["Yes","tbResources.js",null,null,null,null,null,null,"Resources","Yes","Yes",null,"tbMDBenefitCostRatio","number","tbStart","date",null,null,"tbResSortOrder","number",null,null,"tbResCalcWeekSumHours","number","apHelpCoordTop","number","tbStart","date"]
["Yes","tbTags.js",null,null,null,null,null,null,"Baseline","Yes","Yes",null,"tbMDEcnomicValueAdded","number","tbFinish","date",null,null,"tbResLastModified","date",null,null,"tbResCalcWeekSumCost","number","apHelpCoordLeft","number","tbFinish","date"]
["Yes","tbDocuments.js","Does not export right, needs escaping I think on html field",null,null,null,null,null,"Documents","Yes","Yes",null,"tbMDInternalRateOfReturn","number","tbDuration","number",null,null,"tbResCoordTop","number",null,null,"tbResCalcWeek","number","apTS_MonthlyPxFactor","number","tbDuration","number"]
["Yes","tbResCalcs",null,null,null,null,null,null,"AdminPanel","Yes","Yes",null,"tbMDNetPresentValue","number","tbAStart","date",null,null,"tbResCoordLeft","number",null,null,"tbResCalcHours","number","apStatusDate","date","tbAStart","date"]
["Yes","tbResCalcsDetailed",null,null,null,null,null,null,"ResCalcs","Yes","Yes",null,"tbMDOpportunityCost","number","tbAFinish","date",null,null,null,null,null,null,"tbResCalcLastModified","date","ap_HolidayDate","date","tbAFinish","date"]
["Yes","tbAdminPanel",null,null,null,null,null,null,null,null,null,null,"tbMDPaybackPeriod","number","tbRemainingDuration","number",null,null,null,null,null,null,"tbResCalcWeek1","number","totalNumberOfPeople","number","tbRemainingDuration","number"]
["Yes","tbBaseline",null,null,null,null,null,null,null,null,null,null,"tbMDSunkCosts","number","tbCalendar","number",null,null,null,null,null,null,"tbResCalcWeek2","number","numberOfPeoplePerLine","number","tbCalendar","number"]
["No","AddTimebars.js",null,null,null,null,null,null,null,null,null,null,null,null,"tbPercentTimeOn","number",null,null,null,null,null,null,"tbResCalcWeek3","number","pxPerPerson","number","tbPercentTimeOn","number"]
["No","tbMetaData3Pf.js",null,null,null,null,null,null,null,null,null,null,null,null,"tbWork","number",null,null,null,null,null,null,"tbResCalcWeek4","number",null,null,"tbWork","number"]
["No","tbTimebars3Pf.js",null,null,null,null,null,null,null,null,null,null,null,null,"tbAWork","number",null,null,null,null,null,null,"tbResCalcWeek5","number",null,null,"tbAWork","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbWorkRemaining","number",null,null,null,null,null,null,"tbResCalcWeek6","number",null,null,"tbWorkRemaining","number"]
[null,"See button on each page",null,null,null,null,null,null,null,null,null,null,null,null,"tbPercentComplete","number",null,null,null,null,null,null,"tbResCalcWeek7","number",null,null,"tbPercentComplete","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbCost","number",null,null,null,null,null,null,"tbResCalcWeek8","number",null,null,"tbCost","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbAcost","number",null,null,null,null,null,null,"tbResCalcWeek9","number",null,null,"tbAcost","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbCostRemaining","number",null,null,null,null,null,null,"tbResCalcWeek10","number",null,null,"tbCostRemaining","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbPayRate","number",null,null,null,null,null,null,"tbResCalcWeek11","number",null,null,"tbPayRate","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbConstraintDate","date",null,null,null,null,null,null,"tbResCalcWeek12","number",null,null,"tbConstraintDate","date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbFloat","number",null,null,null,null,null,null,"tbResCalcWeek13","number",null,null,"tbFloat","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbFreeFloat","number",null,null,null,null,null,null,"tbResCalcWeek14","number",null,null,"tbFreeFloat","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbExpHoursPerWeek","number",null,null,null,null,null,null,"tbResCalcWeek15","number",null,null,"tbExpHoursPerWeek","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"canvasNo","number",null,null,null,null,null,null,"tbResCalcWeek16","number",null,null,"canvasNo","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kbCoordLeft","number",null,null,null,null,null,null,"tbResCalcWeek17","number",null,null,"kbCoordLeft","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kbCoordTop","number",null,null,null,null,null,null,"tbResCalcWeek18","number",null,null,"kbCoordTop","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"focdItemCoordLeft","number",null,null,null,null,null,null,"tbResCalcWeek19","number",null,null,"focdItemCoordLeft","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"focdItemCoordTop","number",null,null,null,null,null,null,"tbResCalcWeek20","number",null,null,"focdItemCoordTop","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek21","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek22","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek23","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek24","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek25","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek26","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek27","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek28","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek29","number"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tbResCalcWeek30","number"]

{"sheet":"Log","index":14,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["tbID","tbSelfKey2","tbName","tbType","tbL1","tbL2","tbL3","tbL4","tbL5"]
[525,null,null,null,null,"Cloud Portfolio","tbL1","Cloud Portfolio"]
[526,525,null,null,null,"Cloud to Ground Connectivity Project","tbL2","Cloud Portfolio","Cloud to Ground Connectivity Project"]
[527,526,null,null,null,"Choose vendor","tbL4","Cloud Portfolio","Cloud to Ground Connectivity Project",null,"Choose vendor"]
[528,526,null,null,null,"Vendor Selected","tbL4","Cloud Portfolio","Cloud to Ground Connectivity Project",null,"Vendor Selected"]
[529,526,null,null,null,"Design vendor specific network architecture","tbL3","Cloud Portfolio","Cloud to Ground Connectivity Project","Design vendor specific network architecture"]
[530,529,null,null,null,"Go/No Go Implement Network in Cloud","tbL4","Cloud Portfolio","Cloud to Ground Connectivity Project","Design vendor specific network architecture","Go/No Go Implement Network in Cloud"]

{"sheet":"tbForestry","index":15,"n_rows":138,"n_cols":75,"rows_kept":138,"cut":false,"hidden":false,"merged":[]}
["tbID","tbSelfKey2","tbPredecessor","tbTaskParent","tbCoordTop","tbHierarchyOrder","tbName","tbType","tbL1","tbL2","tbL3","tbL4","tbL5","tbStatus","tbState","tbStep","tbStepStatus","tbWfReasonNote","tbStage","tbPriority","tbPhase","tbOwner","tbStart","tbFinish","tbDuration","tbAStart","tbAFinish","tbRemainingDuration","tbWork","tbVolume","tbAWork","tbWorkRemaining","tbPercentComplete","tbCost","tbAcost","tbCostRemaining","tbPine","tbBalsam","tbFir","tbSpruce","tbArea","tbSize","tbPercent2","tbCalendar","tbPercentTimeOn","tbPayRate","tbExpHoursPerWeek","tbCostType","tbCostID","tbConstraintType","tbConstraintDate","tbFloat","tbFreeFloat","tbResID","canvasNo","tbCustomerID","tbMetaDataID","tbBLID","tbAzureID","tbCoordRight","tbCoordLeft","tbBarColor","tbTextColor","kbCoordLeft","kbCoordTop","focdItemCoordLeft","focdItemCoordTop","tbCountry","tbCompany","tbLanguage","tbT1","tbT2","tbT3","tbT4","tbT5"]
[]
["tbID","tbSelfKey2","tbPredecessor","tbTaskParent","tbCoordTop","tbHierarchyOrder","tbName","tbType","tbL1","tbL2","tbL3","tbL4","tbL5","tbStatus","tbState","tbStep","tbStepStatus","tbWfReasonNote","tbStage","tbPriority","tbPhase","tbOwner","tbStart","tbFinish","tbDuration","tbAStart","tbAFinish","tbRemainingDuration","tbWork","tbVolume/HA","tbAWork","tbWorkRemaining","tbPercentComplete","tbCost","tbAcost","tbCostRemaining","tbPine","tbBalsam","tbFir","tbSpruce","tbArea","tbSize","tbPercent2","tbCalendar","tbPercentTimeOn","tbPayRate","tbExpHoursPerWeek","tbCostType","tbCostID","tbConstraintType","tbConstraintDate","tbFloat","tbFreeFloat","tbResID","canvasNo","tbCustomerID","tbMetaDataID","tbBLID","tbAzureID","tbCoordRight","tbCoordLeft","tbBarColor","tbTextColor","kbCoordLeft","kbCoordTop","focdItemCoordLeft","focdItemCoordTop","tbCountry","tbCompany","tbLanguage","tbT1","tbT2","tbT3","tbT4","tbT5"]
[1,null,null,null,10,null,"ADM Timber Appraisals(Dean)","Portfolio",null,null,null,null,"na",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[2,1,null,null,100,null,"A17","Project","ADM Timber Appraisals(Dean)","A17","Harold","Complete","Pl3Bl3Sx3Fd1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,2000,250,null,null,null,null,null,null,null,null,null,null,8,0.3,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[3,1,null,null,190,null,"A19","Project","ADM Timber Appraisals(Dean)","A19","Mill Cr","Layout & Cruise Complete/Requires PFR,SP","Fd10",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,{"$f":"W6*AA6","v":0},200,null,null,null,null,null,null,null,null,null,null,3,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[4,1,null,null,280,null,"A20","Project","ADM Timber Appraisals(Dean)","A20","Mill Cr","Layout & Cruise Complete/Requires PFR,SP","Fd10",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,24,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[5,1,null,null,370,null,"A21","Project","ADM Timber Appraisals(Dean)","A21","Mill Cr","Layout & Cruise Complete/Requires PFR,SP","Fd9Sx1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,1,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[6,1,null,null,460,null,"A22","Project","ADM Timber Appraisals(Dean)","A22","Mill Cr","Layout & Cruise Complete/Requires PFR,SP","Fd10",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,6,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[7,1,null,null,550,null,"A23","Project","ADM Timber Appraisals(Dean)","A23","Mill Cr","Layout & Cruise Complete/Requires PFR,SP","Fd7Sx3",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,9,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[8,1,null,null,640,null,"A24","Project","ADM Timber Appraisals(Dean)","A24","Mill Cr","Layout & Cruise Complete/Requires PFR,SP","Fd9Sx1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,12,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[9,1,null,null,730,null,"A25","Project","ADM Timber Appraisals(Dean)","A25","Mill Cr","Layout & Cruise Complete/Requires PFR,SP","Fd10",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,11,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[10,1,null,null,820,null,"A26","Project","ADM Timber Appraisals(Dean)","A26","Mill Cr","Layout & Cruise Complete/Requires PFR,SP","Fd10",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,2,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[11,1,null,null,910,null,"A27","Project","ADM Timber Appraisals(Dean)","A27","Frog","Layout & Cruise Complete/Requires PFR,SP","Fd10",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,470,143,null,null,null,null,null,null,null,null,null,null,3.3,0.39,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[12,1,null,null,1000,null,"A28","Project","ADM Timber Appraisals(Dean)","A28","Frog","Layout & Cruise Complete/Requires PFR,SP","Fd(Py,At)",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,8092,236,null,null,null,null,null,null,null,null,null,null,34.299999999999997,0.82,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[13,1,null,null,1090,null,"A29","Project","ADM Timber Appraisals(Dean)","A29","Frog","Layout & Cruise Complete/Requires PFR,SP","Fd(At)",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,1282,229,null,null,null,null,null,null,null,null,null,null,5.6,0.59,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[14,1,null,null,1180,null,"A30","Project","ADM Timber Appraisals(Dean)","A30","Frog","Layout & Cruise Complete/Requires PFR,SP","Fd(Pl)",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,578,263,null,null,null,null,null,null,null,null,null,null,2.2000000000000002,0.27,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[15,1,null,null,1270,null,"A31","Project","ADM Timber Appraisals(Dean)","A31","Frog","Layout & Cruise Complete/Requires PFR,SP","Fd9Pl1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,1586,154,null,null,null,null,null,null,null,null,null,null,10.3,0.28000000000000003,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[16,1,null,null,1360,null,"A32","Project","ADM Timber Appraisals(Dean)","A32","Frog","Layout & Cruise Complete/Requires PFR,SP","Fd10",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,1057,115,null,null,null,null,null,null,null,null,null,null,9.1999999999999993,0.28000000000000003,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[17,1,null,null,1450,null,"A33","Project","ADM Timber Appraisals(Dean)","A33","Frog","Layout & Cruise Complete/Requires PFR,SP","Fd10",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,80,100,null,null,null,null,null,null,null,null,null,null,0.6,0.4,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[18,1,null,null,1540,null,"A34","Project","ADM Timber Appraisals(Dean)","A34","Frog","Layout & Cruise Complete/Requires PFR,SP","Fd(Pl,Sx)",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,338,300,null,null,null,null,null,null,null,null,null,null,1.1000000000000001,0.42,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[19,1,null,null,1630,null,"A5","Project","ADM Timber Appraisals(Dean)","A5","Harold","Complete","Pl4Bl4Sx2",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,16800,300,null,null,null,null,null,null,null,null,null,null,56,0.3,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[20,1,null,null,1720,null,"C16","Project","ADM Timber Appraisals(Dean)","C16","Bob","Complete","Bl4Pl4Sx2",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,7000,200,null,null,null,null,null,null,null,null,null,null,35,0.3,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[21,1,null,null,1810,null,"C18","Project","ADM Timber Appraisals(Dean)","C18","Bob","Complete","Bl4Pl4Sx2",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,1000,200,null,null,null,null,null,null,null,null,null,null,5,0.3,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[22,1,null,null,1900,null,"C19","Project","ADM Timber Appraisals(Dean)","C19","Clark","Complete","Pl3SX3Bl3Fd1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,26250,250,null,null,null,null,null,null,null,null,null,null,105,0.3,25,null,null,null,null,null,null,null,null,null,null,null,1,44]
[23,1,null,null,1990,null,"C20","Project","ADM Timber Appraisals(Dean)","C20","Clark","Complete","Bl4Pl4Sx2",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,3250,250,null,null,null,null,null,null,null,null,null,null,15,0.25,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[24,1,null,null,2080,null,"C26","Project","ADM Timber Appraisals(Dean)","C26","Helmer","Complete","Pl8Sx1Fd1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,600,200,null,null,null,null,null,null,null,null,null,null,3,0.25,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[25,1,null,null,2170,null,"C27","Project","ADM Timber Appraisals(Dean)","C27","Helmer","Complete","Pl8Sx1Fd1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,800,200,null,null,null,null,null,null,null,null,null,null,4,0.25,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[26,1,null,null,2260,null,"C33","Project","ADM Timber Appraisals(Dean)","C33","Helmer","Complete","Pl5Sx4Bl1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,750,300,null,null,null,null,null,null,null,null,null,null,2.5,0.4,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[27,1,null,null,2350,null,"C51","Project","ADM Timber Appraisals(Dean)","C51","Clapperton/Lag","Layout Complete/Requires GPS,PFR,Cruise,SP","Pl9Sx1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,875,175,null,null,null,null,null,null,null,null,null,null,5,0.18,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[28,1,null,null,2440,null,"C52","Project","ADM Timber Appraisals(Dean)","C52","Clapperton/Lag","Layout Complete/Requires GPS,PFR,Cruise,SP","Pl9Sx1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,1225,175,null,null,null,null,null,null,null,null,null,null,7,0.18,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[29,1,null,null,2530,null,"E100","Project","ADM Timber Appraisals(Dean)","E100","Swakum","Layout Started","Fd8Sx2",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,{"$f":"W32*AA32","v":0},200,null,null,null,null,null,null,null,null,null,null,7,0.5,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[30,1,null,null,2620,null,"E43","Project","ADM Timber Appraisals(Dean)","E43","Revelle Lk","Complete","Sx4Fd4Pl2",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,600,250,null,null,null,null,null,null,null,null,null,null,3,0.4,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[31,1,null,null,2710,null,"E56","Project","ADM Timber Appraisals(Dean)","E56","Jesse Cr","Comlpete","Fd4Sx4Pl2",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,4000,250,null,null,null,null,null,null,null,null,null,null,16,0.4,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[32,1,null,null,2800,null,"E61","Project","ADM Timber Appraisals(Dean)","E61","Jesse Cr","Comlpete","Fd9Sx1",null,null,null,null,null,null,null,null,"Dean","2020-09-01","2021-09-01",null,null,null,null,6000,150,null,null,null,null,null,null,null,null,null,null,40,0.35,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[33,null,null,null,2890,null,"FLTC - Pending","Portfolio",null,null,null,null,"na",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[34,33,null,null,2980,null,"E75","Project","FLTC - Pending","E75","Pooley","Not Approved","Fd8Sx2(Pl)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,8342,352,null,null,null,null,null,null,null,null,null,null,23.7,0.81,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[35,33,null,null,3070,null,"E76","Project","FLTC - Pending","E76","Pooley","Not Approved","Fd(PlSx)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,1014,290,null,null,null,null,null,null,null,null,null,null,3.5,0.82,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[36,33,null,null,3160,null,"E77","Project","FLTC - Pending","E77","Pooley","Not Approved","Sx6Fd4(Pl)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,9288,409,null,null,null,null,null,null,null,null,null,null,22.7,0.82,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[37,33,null,null,3250,null,"E78","Project","FLTC - Pending","E78","Pooley","Not Approved","Sx5Fd3Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,1766,431,null,null,null,null,null,null,null,null,null,null,4.0999999999999996,0.42,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[38,33,null,null,3340,null,"E79","Project","FLTC - Pending","E79","Pooley","Not Approved","Sx6Fd2Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,1189,290,null,null,null,null,null,null,null,null,null,null,4.0999999999999996,0.56999999999999995,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[39,33,null,null,3430,null,"E80","Project","FLTC - Pending","E80","Pooley","Not Approved","Fd6Sx2Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,228,142,null,null,null,null,null,null,null,null,null,null,1.6,0.28000000000000003,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[40,33,null,null,3520,null,"E81","Project","FLTC - Pending","E81","Pooley","Not Approved","Fd7Sx2Pl1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,11032,319,null,null,null,null,null,null,null,null,null,null,34.6,0.86,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[41,33,null,null,3610,null,"E81","Project","FLTC - Pending","E81","Pooley","Not Approved","Fd7Sx3(Pl)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,3071,287,null,null,null,null,null,null,null,null,null,null,10.7,0.61,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[42,1,null,null,3700,null,"E83","Project","ADM Timber Appraisals(Dean)","E83","Swakum","Layout & Cruise Complete/Requires PFR,SP","Fd6Sx3Pl1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,{"$f":"W45*AA45","v":0},300,null,null,null,null,null,null,null,null,null,null,23,0.7,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[43,1,null,null,3790,null,"E84","Project","ADM Timber Appraisals(Dean)","E84","Swakum","Layout & Cruise Complete/Requires PFR,SP","Sx4Fd3Bl2Pl1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,325,null,null,null,null,null,null,null,null,null,null,76,0.9,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[44,1,null,null,3880,null,"E86","Project","ADM Timber Appraisals(Dean)","E86","Hector (8 Mile)","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd9Sx1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,250,null,null,null,null,null,null,null,null,null,null,5,0.4,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[45,1,null,null,3970,null,"E88","Project","ADM Timber Appraisals(Dean)","E88","Hector (8 Mile)","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd9Sx1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,250,null,null,null,null,null,null,null,null,null,null,4,0.4,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[46,1,null,null,4060,null,"E89","Project","ADM Timber Appraisals(Dean)","E89","Hector (8 Mile)","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd9Sx1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,250,null,null,null,null,null,null,null,null,null,null,20,0.4,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[47,1,null,null,4150,null,"E90","Project","ADM Timber Appraisals(Dean)","E90","Hector (8 Mile)","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd9Sx1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,250,null,null,null,null,null,null,null,null,null,null,18,0.4,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[48,1,null,null,4240,null,"E91","Project","ADM Timber Appraisals(Dean)","E91","Swakum","Layout & Cruise Complete/Requires PFR,SP","Fd5Sx5",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,9,0.8,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[49,1,null,null,4330,null,"E92","Project","ADM Timber Appraisals(Dean)","E92","Swakum","Layout & Cruise Complete/Requires PFR,SP","Fd9Sx1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,225,null,null,null,null,null,null,null,null,null,null,28,0.5,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[50,1,null,null,4420,null,"E96","Project","ADM Timber Appraisals(Dean)","E96","Danish","Layout & Cruise Complete/Requires PFR,SP","Fd10",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,3,0.4,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[51,1,null,null,4510,null,"E97","Project","ADM Timber Appraisals(Dean)","E97","Danish","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd10",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,1,0.4,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[52,1,null,null,4600,null,"E98","Project","ADM Timber Appraisals(Dean)","E98","Danish","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd10",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,6,0.4,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[53,1,null,null,4690,null,"E99","Project","ADM Timber Appraisals(Dean)","E99","Swakum","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd8Sx2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,35,0.5,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[54,null,null,null,4780,null,"McKinnon  Blocks","Portfolio",null,null,null,null,"na",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[55,54,null,null,4870,null,"J41","Project","McKinnon  Blocks","J41","jura","Layout, GPS, SP Data and cruising complete","Pl8sxbl2",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,6575,250,null,null,null,null,null,null,null,null,null,null,26.3,0.3,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[56,54,null,null,4960,null,"M100","Project","McKinnon  Blocks","M100","Gillis","Layout, GPS complete, requires SP collection and cruising","Pl9fd1",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,1020,150,null,null,null,null,null,null,null,null,null,null,6.8,0.22,3,null,null,null,null,null,null,null,null,null,null,null,1,44]
[57,54,null,null,5050,null,"M101","Project","McKinnon  Blocks","M101","Murray","Layout, GPS complete, requires SP collection and cruising","Pl9Bl1",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,1050,150,null,null,null,null,null,null,null,null,null,null,7,0.2,3,null,null,null,null,null,null,null,null,null,null,null,1,44]
[58,54,null,null,5140,null,"M102","Project","McKinnon  Blocks","M102","Murray","Layout, GPS complete, requires SP collection and cruising","Bl5Sx3Pl2",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,8000,200,null,null,null,null,null,null,null,null,null,null,40,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[59,54,null,null,5230,null,"M54","Project","McKinnon  Blocks","M54","19km Spius","complete","Bl6,Sx3,Pl1",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,{"$f":"W62*350","v":15426250},350,null,null,null,null,null,null,null,null,null,null,11,0.6,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[60,54,null,null,5320,null,"M81","Project","McKinnon  Blocks","M81","maka","Layout, GPS , Cruising complete, requires PFR and SP collection","Bl6Sx4",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,8825,250,null,null,null,null,null,null,null,null,null,null,35.299999999999997,0.3,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[61,54,null,null,5410,null,"M82","Project","McKinnon  Blocks","M82","Lake Spur","Layout, GPS, Cruising complete, requires SP collection ","Fd5Sx3Bl2(PL)",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,5700,250,null,null,null,null,null,null,null,null,null,null,22.8,0.4,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[62,54,null,null,5500,null,"M83","Project","McKinnon  Blocks","M83","maka","Layout, GPS complete, requires SP collection and cruising","Bl5Sx3Pl2",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,12000,300,null,null,null,null,null,null,null,null,null,null,40,0.4,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[63,54,null,null,5590,null,"M84","Project","McKinnon  Blocks","M84","maka","Layout, GPS complete, requires SP collection and cruising","Pl6BlSx4",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,24800,200,null,null,null,null,null,null,null,null,null,null,124,0.25,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[64,54,null,null,5680,null,"M85","Project","McKinnon  Blocks","M85","Murray","Layout, GPS, Cruising complete, requires SP collection ","Pl10(Fd)",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,405,75,null,null,null,null,null,null,null,null,null,null,5.4,0.11,3,null,null,null,null,null,null,null,null,null,null,null,1,44]
[65,54,null,null,5770,null,"M86","Project","McKinnon  Blocks","M86","Murray","Layout, GPS, Cruising complete, requires SP collection ","Pl10(Fd)",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,52,75,null,null,null,null,null,null,null,null,null,null,0.7,0.11,3,null,null,null,null,null,null,null,null,null,null,null,1,44]
[66,54,null,null,5860,null,"M87","Project","McKinnon  Blocks","M87","Murray","Layout, GPS, Cruising complete, requires SP collection ","Pl10(Fd)",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,292,75,null,null,null,null,null,null,null,null,null,null,3.9,0.11,3,null,null,null,null,null,null,null,null,null,null,null,1,44]
[67,54,null,null,5950,null,"M88","Project","McKinnon  Blocks","M88","Gillis","Layout, GPS complete, requires SP collection and cruising","Pl9fd1",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,1776,120,null,null,null,null,null,null,null,null,null,null,14.8,0.19,3,null,null,null,null,null,null,null,null,null,null,null,1,44]
[68,54,null,null,6040,null,"M89","Project","McKinnon  Blocks","M89","Gillis","Layout, GPS complete, requires SP collection and cruising","Pl9Fd1",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,2040,120,null,null,null,null,null,null,null,null,null,null,17,0.19,3,null,null,null,null,null,null,null,null,null,null,null,1,44]
[69,54,null,null,6130,null,"M92","Project","McKinnon  Blocks","M92","Patchet","Layout, GPS, Cruising complete, requires SP collection ","Fd8SxPl2",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,580,200,null,null,null,null,null,null,null,null,null,null,2.9,0.6,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[70,54,null,null,6220,null,"M93","Project","McKinnon  Blocks","M93","Patchet","Layout, GPS, Cruising complete, requires SP collection ","Fd8SxPl3",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,100,200,null,null,null,null,null,null,null,null,null,null,0.5,0.6,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[71,54,null,null,6310,null,"M94","Project","McKinnon  Blocks","M94","Patchet","Layout, GPS, Cruising complete, requires SP collection ","Fd8SxPl4",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,120,200,null,null,null,null,null,null,null,null,null,null,0.6,0.6,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[72,54,null,null,6400,null,"M95","Project","McKinnon  Blocks","M95","Patchet","Layout, GPS, Cruising complete, requires SP collection ","Fd8SxPl5",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,2780,200,null,null,null,null,null,null,null,null,null,null,13.9,0.6,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[73,54,null,null,6490,null,"M96","Project","McKinnon  Blocks","M96","Patchet","Layout, GPS, Cruising complete, requires SP collection ","Fd8SxPl6",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,660,200,null,null,null,null,null,null,null,null,null,null,3.3,0.6,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[74,54,null,null,6580,null,"M97","Project","McKinnon  Blocks","M97","Patchet","Layout, GPS, Cruising complete, requires SP collection ","Fd8SxPl7",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,360,200,null,null,null,null,null,null,null,null,null,null,1.8,0.6,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[75,54,null,null,6670,null,"M98","Project","McKinnon  Blocks","M98","Angelo","Layout, GPS, Cruising complete, requires SP collection ","Pl10",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,1510,100,null,null,null,null,null,null,null,null,null,null,15.1,0.11,3,null,null,null,null,null,null,null,null,null,null,null,1,44]
[76,54,null,null,6760,null,"N25","Project","McKinnon  Blocks","N25","Nicomen","Layout, GPS complete, requires SP collection and cruising","Bl9,Sx1",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,750,300,null,null,null,null,null,null,null,null,null,null,2.5,0.5,"<5",null,null,null,null,null,null,null,null,null,null,null,1,44]
[77,54,null,null,6850,null,"N26","Project","McKinnon  Blocks","N26","Nicomen","Layout, GPS complete, requires SP collection and cruising","Bl7,Sx3(Pl)",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,9600,240,null,null,null,null,null,null,null,null,null,null,40,0.2,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[78,54,null,null,6940,null,"N28","Project","McKinnon  Blocks","N28","Nicomen","Layout, GPS complete, requires SP collection and cruising","Bl8,Sx2",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,1250,250,null,null,null,null,null,null,null,null,null,null,5,0.35,"<5",null,null,null,null,null,null,null,null,null,null,null,1,44]
[79,54,null,null,7030,null,"N29","Project","McKinnon  Blocks","N29","Nicomen","Layout, GPS complete, requires SP collection and cruising","Bl8,Sx2",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,5000,250,null,null,null,null,null,null,null,null,null,null,20,0.3,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[80,54,null,null,7120,null,"N41","Project","McKinnon  Blocks","N41","Sackum","Layout, GPS complete, requires SP collection and cruising","Fd10",null,null,null,null,null,null,null,null,"McKinnon","2020-09-01","2021-09-01",null,null,null,null,300,100,null,null,null,null,null,null,null,null,null,null,3,0.6,"<5",null,null,null,null,null,null,null,null,null,null,null,1,44]
[81,null,null,null,7210,null,"ADM Timber Appraisals(Dean) 2","Portfolio",null,null,null,null,"na",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[82,81,null,null,7300,null,"N69","Project","ADM Timber Appraisals(Dean)","N69","Sackum ","Layout, PFR Complete/ Requires Cruise, SP","Fd8Py2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,9028,200,null,null,null,null,null,null,null,null,null,null,45.14,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[83,81,null,null,7390,null,"N78","Project","ADM Timber Appraisals(Dean)","N78","Nicomen","Layout, Cruise & PFR Complete/Requires SP collection","Fd8Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,5700,150,null,null,null,null,null,null,null,null,null,null,38,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[84,81,null,null,7480,null,"N82","Project","ADM Timber Appraisals(Dean)","N82","Nicomen","Layout, PFR Complete/ Requires Cruise, SP","Fd7Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,748,200,null,null,null,null,null,null,null,null,null,null,3.74,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[85,81,null,null,7570,null,"N87 ","Project","ADM Timber Appraisals(Dean)","N87 ","Nicomen","Layout, PFR Complete/ Requires Cruise, SP","Pl9Fd1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,120,200,null,null,null,null,null,null,null,null,null,null,0.6,0.3,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[86,81,null,null,7660,null,"Q51","Project","ADM Timber Appraisals(Dean)","Q51","Sabin","Layout & Cruise Complete/Requires PFR,SP","Fd8Sx2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,{"$f":"W89*AA89","v":0},250,null,null,null,null,null,null,null,null,null,null,12,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[87,81,null,null,7750,null,"Q52","Project","ADM Timber Appraisals(Dean)","Q52","Sabin","Layout & Cruise Complete/Requires PFR,SP","Fd8Sx2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,250,null,null,null,null,null,null,null,null,null,null,40,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[88,81,null,null,7840,null,"Q53","Project","ADM Timber Appraisals(Dean)","Q53","Sabin","Layout & Cruise Complete/Requires PFR,SP","Fd8Sx2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,250,null,null,null,null,null,null,null,null,null,null,12,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[89,81,null,null,7930,null,"Q54","Project","ADM Timber Appraisals(Dean)","Q54","Sabin","Layout & Cruise Complete/Requires PFR,SP","Fd8Sx2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,250,null,null,null,null,null,null,null,null,null,null,17,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[90,81,null,null,8020,null,"Q55","Project","ADM Timber Appraisals(Dean)","Q55","Sabin","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd8Sx2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,250,null,null,null,null,null,null,null,null,null,null,10,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[91,81,null,null,8110,null,"R11","Project","ADM Timber Appraisals(Dean)","R11","FW","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd9Sx1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,250,null,null,null,null,null,null,null,null,null,null,2,0.4,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[92,81,null,null,8200,null,"R15","Project","ADM Timber Appraisals(Dean)","R15","FW","Recce Only","Fd9Sx1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,100,null,null,null,null,null,null,null,null,null,null,40,0.25,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[93,81,null,null,8290,null,"R17","Project","ADM Timber Appraisals(Dean)","R17","FW","Recce Only","Fd5Sx3Pl1Bl1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,350,null,null,null,null,null,null,null,null,null,null,40,0.5,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[94,81,null,null,8380,null,"R19","Project","ADM Timber Appraisals(Dean)","R19","FW","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd9Sx1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,{"$f":"W97*AA97","v":0},300,null,null,null,null,null,null,null,null,null,null,10,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[95,81,null,null,8470,null,"R20","Project","ADM Timber Appraisals(Dean)","R20","FW","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd8Sx2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,300,null,null,null,null,null,null,null,null,null,null,18,0.4,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[96,81,null,null,8560,null,"R21","Project","ADM Timber Appraisals(Dean)","R21","FW","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd8Sx2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,150,null,null,null,null,null,null,null,null,null,null,3,0.5,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[97,81,null,null,8650,null,"R24","Project","ADM Timber Appraisals(Dean)","R24","FW","Layout Complete/Requires GPS,PFR,Cruise,SP","Fd10",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,300,null,null,null,null,null,null,null,null,null,null,3,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[98,81,null,null,8740,null,"S108","Project","ADM Timber Appraisals(Dean)","S108","Tyner ","Complete","Pl7Sx2Fd1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,21,0.22,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[99,81,null,null,8830,null,"S109","Project","ADM Timber Appraisals(Dean)","S109","Tyner ","Complete","Pl7Sx2Fd1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,15,0.22,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[100,81,null,null,8920,null,"S110","Project","ADM Timber Appraisals(Dean)","S110","Tyner ","Complete","Pl6Sx2Fd2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,0,200,null,null,null,null,null,null,null,null,null,null,45,0.2,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[101,81,null,null,9010,null,"S60","Project","McKinnon  Blocks","S60","Blue Earth","Layout, GPS complete, requires SP collection and cruising","Pl7Fd3",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,5000,250,null,null,null,null,null,null,null,null,null,null,20,0.3,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[102,81,null,null,9100,null,"S61","Project","McKinnon  Blocks","S61","Blue Earth","Layout, GPS complete, requires SP collection and cruising","Pl5, Bl3, Sx2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,6250,250,null,null,null,null,null,null,null,null,null,null,25,0.3,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[103,81,null,null,9190,null,"S62","Project","McKinnon  Blocks","S62","Blue Earth","Layout, GPS complete, requires SP collection and cruising","Fd10",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,1200,150,null,null,null,null,null,null,null,null,null,null,8,0.6,"<5",null,null,null,null,null,null,null,null,null,null,null,1,44]
[104,81,null,null,9280,null,"S63","Project","McKinnon  Blocks","S63","Blue Earth","Layout, GPS complete, requires SP collection and cruising","Fd6Sx4",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,450,300,null,null,null,null,null,null,null,null,null,null,1.5,0.5,"<5",null,null,null,null,null,null,null,null,null,null,null,1,44]
[105,81,null,null,9370,null,"S64","Project","McKinnon  Blocks","S64","Blue Earth","Layout, GPS complete, requires SP collection and cruising","Pl5Sx3Bl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,900,300,null,null,null,null,null,null,null,null,null,null,3,0.25,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[106,81,null,null,9460,null,"S65","Project","McKinnon  Blocks","S65","Blue Earth","Layout, GPS complete, requires SP collection and cruising","Bl6,Sx4",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,12000,300,null,null,null,null,null,null,null,null,null,null,40,0.6,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[107,81,null,null,9550,null,"S66","Project","McKinnon  Blocks","S66","Blue Earth","Layout, GPS complete, requires SP collection and cruising","Bl6,Sx5",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,12000,300,null,null,null,null,null,null,null,null,null,null,40,0.6,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[108,null,null,null,9640,null,"Other","Portfolio",null,null,null,null,"na",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[109,108,null,null,9730,null,"S75","Project","W 0359 CP EE","S75","Nooiatch","Approved STI","Fd4Pl3Sx3",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,6000,6000,null,null,null,null,null,null,null,null,null,null,23.5,275,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[110,108,null,null,9820,null,"S88","Project","ADM Timber Appraisals(Dean)","S88","Sackum","Layout, Cruise & PFR Complete/Requires SP collection","Fd10",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,3186,200,null,null,null,null,null,null,null,null,null,null,15.93,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[111,108,null,null,9910,null,"S89","Project","ADM Timber Appraisals(Dean)","S89","Sackum ","Layout, Cruise & PFR Complete/Requires SP collection","Fd10",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,984,200,null,null,null,null,null,null,null,null,null,null,4.92,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[112,108,null,null,10000,null,"S90","Project","ADM Timber Appraisals(Dean)","S90","Sackum ","Layout Complete/ Requires Cruise, PFR, SP","Fd10",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,538,200,null,null,null,null,null,null,null,null,null,null,2.69,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[113,108,null,null,10090,null,"S91","Project","ADM Timber Appraisals(Dean)","S91","Sackum","Layout Complete/ Requires Cruise, PFR, SP","Fd8Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,2218,200,null,null,null,null,null,null,null,null,null,null,11.09,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[114,108,null,null,10180,null,"S92","Project","ADM Timber Appraisals(Dean)","S92","Sackum ","Layout Complete/ Requires Cruise, PFR, SP","Fd8Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,1120,200,null,null,null,null,null,null,null,null,null,null,5.6,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[115,108,null,null,10270,null,"S96","Project","ADM Timber Appraisals(Dean)","S96","Tyner/Gordon","Complete","Pl7Sx2Fd1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,{"$f":"W118*AA118","v":0},200,null,null,null,null,null,null,null,null,null,null,20,0.18,30,null,null,null,null,null,null,null,null,null,null,null,1,44]
[116,108,null,null,10360,null,"U32","Project","McKinnon  Blocks","U32","Branch 22","Layout, GPS complete, requires SP collection and cruising","Bl6,Sx4(Pl)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,14000,350,null,null,null,null,null,null,null,null,null,null,40,0.5,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[117,108,null,null,10450,null,"U33","Project","McKinnon  Blocks","U33","Branch 22","Layout, GPS complete, requires SP collection and cruising","Bl7,Sx3(Pl)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,14000,350,null,null,null,null,null,null,null,null,null,null,40,0.4,15,null,null,null,null,null,null,null,null,null,null,null,1,44]
[118,108,null,null,10540,null,"U34","Project","McKinnon  Blocks","U34","Branch 22","Layout, GPS complete, requires SP collection and cruising","Pl5,Bl4,Sx1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,12000,300,null,null,null,null,null,null,null,null,null,null,40,0.3,20,null,null,null,null,null,null,null,null,null,null,null,1,44]
[119,108,null,null,10630,null,"U35","Project","McKinnon  Blocks","U35","Branch 22","Layout, GPS complete, requires SP collection and cruising","Bl6Sx4(Pl)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,12250,350,null,null,null,null,null,null,null,null,null,null,35,0.4,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[120,108,null,null,10720,null,"U37","Project","McKinnon  Blocks","U37","Branch 22","Layout, GPS complete, requires SP collection and cruising","Bl6,Sx4(Pl)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,14000,350,null,null,null,null,null,null,null,null,null,null,40,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[121,108,null,null,10810,null,"U37","Project","McKinnon  Blocks","U37","Branch 22","Layout, GPS complete, requires SP collection and cruising","Sx6,Bl4",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,8470,275,null,null,null,null,null,null,null,null,null,null,30.8,0.5,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[122,108,null,null,10900,null,"U51","Project","McKinnon  Blocks","U51",null,"Layout, GPS & Cruising complete, requires SP collection","na",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,44]
[123,108,null,null,10990,null,"U52","Project","McKinnon  Blocks","U52","Branch 22","Layout, GPS & Cruising complete, requires SP collection","Sx4Bl3Pl3",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,11370,300,null,null,null,null,null,null,null,null,null,null,37.9,0.4,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[124,108,null,null,11080,null,"U53","Project","McKinnon  Blocks","U53","Dewdney","Layout, GPS complete, requires SP collection and cruising","Fd8SxBl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,4095,350,null,null,null,null,null,null,null,null,null,null,11.7,0.6,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[125,108,null,null,11170,null,"U54","Project","McKinnon  Blocks","U54","Silver","Layout, GPS complete, requires SP collection and cruising","Bl5Sx4Pl1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,7620,200,null,null,null,null,null,null,null,null,null,null,38.1,0.3,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[126,108,null,null,11260,null,"U55","Project","McKinnon  Blocks","U55","Branch22","Layout, GPS complete, requires SP collection and cruising","Bl6,Sx4 (PL)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,8940,300,null,null,null,null,null,null,null,null,null,null,29.8,0.4,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[127,108,null,null,11350,null,"U80","Project","ADM Timber Appraisals(Dean)","U80","Sackum ","Layout, Cruise & PFR Complete/Requires SP collection","Fd5Sx3Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,320,200,null,null,null,null,null,null,null,null,null,null,1.6,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[128,108,null,null,11440,null,"U83","Project","ADM Timber Appraisals(Dean)","U83","Sackum","Layout, Cruise & PFR Complete/Requires SP collection","Fd5Sx3Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,475,250,null,null,null,null,null,null,null,null,null,null,1.9,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[129,108,null,null,11530,null,"U86","Project","ADM Timber Appraisals(Dean)","U86","Sackum","Layout, Cruise & PFR Complete/Requires SP collection","Fd5Sx3Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,2250,250,null,null,null,null,null,null,null,null,null,null,9,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[130,108,null,null,11620,null,"U94","Project","ADM Timber Appraisals(Dean)","U94","Sackum","Layout, Cruise & PFR Complete/Requires SP collection","Fd5Sx3Pl2",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,2975,250,null,null,null,null,null,null,null,null,null,null,11.9,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[131,108,null,null,11710,null,"U95","Project","ADM Timber Appraisals(Dean)","U95","Sackum ","Layout, Cruise & PFR Complete/Requires SP collection","Pl7Fd3",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,700,200,null,null,null,null,null,null,null,null,null,null,3.5,0.3,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[132,108,null,null,11800,null,"W23","Project","McKinnon  Blocks","W23","88road","Layout, GPS, SP Data and cruising complete","Pl8SXBL2(Fd)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,8844,220,null,null,null,null,null,null,null,null,null,null,40.200000000000003,0.25,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[133,108,null,null,11890,null,"W24","Project","McKinnon  Blocks","W24","shrimpton","Layout, GPS, SP Data and cruising complete","Fd6Sx3Pl1(Bl)",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,9855,250,null,null,null,null,null,null,null,null,null,null,30,0.4,5,null,null,null,null,null,null,null,null,null,null,null,1,44]
[134,108,null,null,11980,null,"W25","Project","McKinnon  Blocks","W25","88road","Layout, GPS, SP Data and cruising complete","Pl9SxB1",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,2520,180,null,null,null,null,null,null,null,null,null,null,14.2,0.25,10,null,null,null,null,null,null,null,null,null,null,null,1,44]
[135,108,null,null,12070,null,"NA","Project","SSS 94981","NA","Frank Ward","Approved STI","Fd",null,null,null,null,null,null,null,null,null,"2020-09-01","2021-09-01",null,null,null,null,1000,null,null,null,null,null,null,null,null,null,null,null,0.4,null,10,null,null,null,null,null,null,null,null,null,null,null,1,44]

{"sheet":"tbWorkflow","index":16,"n_rows":24,"n_cols":75,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["tbID","tbSelfKey2","tbPredecessor","tbTaskParent","tbCoordTop","tbHierarchyOrder","tbName","tbType","tbL1","tbL2","tbL3","tbL4","tbL5","tbStatus","tbState","tbStep","tbStepStatus","tbWfReasonNote","tbStage","tbPriority","tbPhase","tbOwner","tbStart","tbFinish","tbDuration","tbAStart","tbAFinish","tbRemainingDuration","tbWork","tbVolume","tbAWork","tbWorkRemaining","tbPercentComplete","tbCost","tbAcost","tbCostRemaining","tbPine","tbBalsam","tbFir","tbSpruce","tbArea","tbSize","tbPercent2","tbCalendar","tbPercentTimeOn","tbPayRate","tbExpHoursPerWeek","tbCostType","tbCostID","tbConstraintType","tbConstraintDate","tbFloat","tbFreeFloat","tbResID","canvasNo","tbCustomerID","tbMetaDataID","tbBLID","tbAzureID","tbCoordRight","tbCoordLeft","tbBarColor","tbTextColor","kbCoordLeft","kbCoordTop","focdItemCoordLeft","focdItemCoordTop","tbCountry","tbCompany","tbLanguage","tbT1","tbT2","tbT3","tbT4","tbT5"]
[]
["tbID","Parent","tbPredecessor","tbTaskParent","tbCoordTop","tbHierarchyOrder","tbName","tbType","tbL1","tbL2","tbL3","tbL4","tbL5","tbStatus","tbState","tbStep","tbStepStatus","tbWfReasonNote","tbStage","tbPriority","tbPhase","tbOwner","tbStart","tbFinish","tbDuration","tbAStart","tbAFinish","tbRemainingDuration","tbWork","tbVolume","tbAWork","tbWorkRemaining","tbPercentComplete","tbCost","tbAcost","tbCostRemaining","tbPine","tbBalsam","tbFir","tbSpruce","tbArea","tbSize","tbPercent2","tbCalendar","tbPercentTimeOn","tbPayRate","tbExpHoursPerWeek","tbCostType","tbCostID","tbConstraintType","tbConstraintDate","tbFloat","tbFreeFloat","tbResID","canvasNo","tbCustomerID","tbMetaDataID","tbBLID","tbAzureID","tbCoordRight","tbCoordLeft","tbBarColor","tbTextColor","kbCoordLeft","kbCoordTop","focdItemCoordLeft","focdItemCoordTop","tbCountry","tbCompany","tbLanguage","tbT1","tbT2","tbT3","tbT4","tbT5"]
[28,null,null,null,60,null,"No Print Status Recieved","Project",null,null,null,null,null,"Open","Approved","Print Status","No Print Status Recieved",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","621 999-2344"]
[29,28,null,null,120,null,"No Print Status Recieved","Task",null,null,null,null,null,"In Queue","Approved","bad","bad",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","622 999-2344"]
[20,null,null,null,180,null,"Printed Successfully","Project",null,null,null,null,null,"Open","Approved","Print Status","Print Status Recieved","<li>Passed QA at Print Center</li>",null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","613 999-2344"]
[21,20,null,null,240,null,"Printed Successfully","Task",null,null,null,null,null,"Printed","Approved","bad","bad",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","614 999-2344"]
[22,null,null,null,300,null,"Returned Not Printed","Project",null,null,null,null,null,"Open","Approved","Print Status","Print Status Recieved","<li>Returned per phone call on xyz date with Joe Biden</li>",null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","615 999-2344"]
[23,22,null,null,360,null,"Returned Not Printed","Task",null,null,null,null,null,"Returned Not Printed","Approved","bad","bad",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","616 999-2344"]
[24,null,null,null,420,null,"Printing Retry","Project",null,null,null,null,null,"Open","Approved","Print Status","Print Status Recieved","<li>Could not read properly, retrying!</li>",null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","617 999-2344"]
[25,24,null,null,480,null,"Printing Retry","Task",null,null,null,null,null,"Retry","Approved","bad","bad",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","618 999-2344"]
[26,null,null,null,540,null,"System Error","Project",null,null,null,null,null,"Open","Approved","Print Status","Print Status Recieved","<li>Rejected at validation at the external interface</li>",null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","619 999-2344"]
[27,26,null,null,600,null,"System Error","Task",null,null,null,null,null,"Error","Approved","bad","bad",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","620 999-2344"]
[30,null,null,null,660,null,"Failed SQC","Project",null,null,null,null,null,"Open","Approved","Print Status","Print Status Recieved","<li>Noticed smudge on surface, seems to be faulty stock</li>",null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","623 999-2344"]
[31,30,null,null,720,null,"Failed SQC","Task",null,null,null,null,null,"Failed SQC","Approved","bad","bad",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","624 999-2344"]
[32,null,null,null,780,null,"Formatting Not Generated","Project",null,null,null,null,null,"Open","Approved","Generate Formatting","Formatting Not Generated","<li>Attempting to format long names to ensure they fit</li>",null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","625 999-2344"]
[33,32,null,null,840,null,"Formatting Not Generated","Task",null,null,null,null,null,"Not Started","Approved","bad","bad",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","626 999-2344"]
[34,null,null,null,130,null,"Authorized for hand out","Project",null,null,null,null,null,"Open","Approved","Handout Completion","Handout Not Complete","<li>Quality perfect</li>",null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","625 999-2344"]
[35,34,null,null,160,null,"Authorized for hand out","Task",null,null,null,null,null,"Authorized","Approved","bad","bad",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","626 999-2344"]
[55,null,null,null,900,null,"Send Document","Project",null,null,null,null,null,"Open","Approved","Send Document","Print Record Not Sent","<li>Format is fine, sending to print</li>",null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","625 999-2344"]
[65,55,null,null,950,null,"Send Document","Task",null,null,null,null,null,"Generate","Approved","bad","bad",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","626 999-2344"]
[75,null,null,null,200,null,"Finalize Document","Project",null,null,null,null,null,"Open","Blank","Finalize Document","Document Not Finalized","<li>Client xxx promoted, Ready to finalize.</li>",null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","625 999-2344"]
[85,75,null,null,230,null,"Finalize Document","Task",null,null,null,null,null,"Not Started",null,"bad","bad",null,null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","626 999-2344"]
[90,null,null,null,30,null,"Create Document","Project",null,null,null,null,null,"Open","Blank","Create Document","Document Created","<li>Document was promoted but not moved to Finalize Step yet.</li>",null,null,null,"Jim Cox","2020-10-01","2022-04-21",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"jim@jim.com","Allyson Bryant","Joe Smuck","Workflow Development","625 999-2344"]