{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Data Model","RBMData","Publications Form","UXForm"],"not_rendered":{"charts":0,"images":174,"macros":1,"external_links":3,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data Model","index":0,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
["PMR Milestone","Publication Name","Target Publication Date","Segment","Milestone Description","Estimated Duration (Days)","Planned Start date","Planned End date","Actual Start date","Actual End date","Comments"]
["Unknown","Unknown","2020-01-01","Planning","Propose publication to Director",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Planning","Consult other Divisions on possible intersections with their work",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Planning","Complete Knowledge Mobilisation (KM) Planning Template",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Planning","Add deliverables and milestones to PMR",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Planning","Director approves publication deliverables and milestones in PMR",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Planning","Engage stakeholders and governance bodies; gain collaboration, concurrence and approvals as appropriate",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","Develop CSR (Part 1) As soon as PMR aproved",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","MGR approval of Communications Services Request Form (Part 1)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","Send CSR (Part 1) for StratComms Approval",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","StratComms Review and Approval of CSR (Part 1) ",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","DIRECTOR approval of CSR (Part 1)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","Approved CSR (Part 1) to StratComms, hc.webcommunications.sc@canada.ca, hc.creative.services-creatifs.sc@canada.ca",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","CSR (Part 2) sent by Comms with estimated timelines for proposed products (2-week service standard) *NOTE: Include estimates of number of tables/figures, as well as # of pages of text/ total # of pages. Include all possible products, even if internal resources may be used.  Better to request and drop than not include.",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","Negotiate timelines  for Web, Graphic Design with Comms ",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","Comms Approval",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","Update this document with estimated timelines from CSR (Part 2)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","DG Approval of CSR (Part 2)- digital signature",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for Pre-Development of Report","Approved; back to program to be sent to CS/Comms",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Planning of document structure (tables, graphics, format, audience)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Consultations/Data acquisition/Analysis (Where the information is coming from)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Development of document - English only",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","QA of all tables",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Editing of document ($$)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","QA of Original draft",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Update Knowledge Mobilisation (KM) Planning Template with key messages",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Review Knowledge Mobilisation (KM) Planning Template and action",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Initiate development of linked KTE, if applicable",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Manager approval of Final Draft",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Manager approval of Final KM template",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Book Oral Briefing with DG (for shortly after deadline) to prevent delays once Reviewed Draft is ready (3-4 week lead time)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Director approval of Final Draft",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Writing","Create Long Descriptions of all figures/charts",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Infographic (Pre-layout)","Identify content of interest/(Possibly) Sketch or mock up of proposed infographic",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Infographic (Pre-layout)","Develop an Infographic Plan (Word document)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Infographic (Pre-layout)","Manager approval of Infographic Plan (Word document)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Infographic (Pre-layout)","(If standalone infographic) Book Oral Briefing with DG 3-4 weeks before deadline for all feedback to be added",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Infographic (Pre-layout)","Director approval of Infographic Plan",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Infographic (Pre-layout)","(If outsourcing) Get quote from contractor ALWAYS REQUEST SOURCE FILES!",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Infographic (Pre-layout)","(if outsourcing <5 k) Get CCM approval only - Credit card purchase - no call up needed",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Infographic (Pre-layout)","(if outsourcing >5 k) Call up/Standing offer/SFC/LFC",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for translation ","Send documents/long descriptions for translation (in tandem with stakeholder feedback if FR not required) ($$)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for translation ","Translation",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Checklist for translation ","QA translation (in-house or sourced out)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Stakeholder Feedback","Telecons with stakeholders if required",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Stakeholder Feedback","Send documents in English and French to stakeholders",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Stakeholder Feedback","Prepare Notification Email for feedback or information",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Stakeholder Feedback","Translation of Notification Email",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Stakeholder Feedback","Send Email Memo to stakeholders",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Stakeholder Feedback","Make any applicable edits to the document in both translations",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Stakeholder Feedback","Resend for translation of specific pieces if required",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Stakeholder Feedback","Along the way, address all concerns",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","FYI to DG","DG briefing on Reviewed Draft/Infographic Plan  (Book Oral Briefing 3-4 weeks ahead)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Confirm final document(s) in both English and French (address any edits and translation needs)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Send Creative Services/Contractor reviewed drafts in EN/FR to do design and layout",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","CS/Contractor to do design/layout (Timelines as per CSR-2)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Create Long Descriptions of any new figures/infographics",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Request ISBN/ISSN Number (form to CS) (if appropriate)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Request Catalogue Number (CS)  (if appropriate)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Side by Side QA of French document (tables as well)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Side by Side QA of English document (tables as well)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Send Eng and French documents (and tables, figures, infographics) in Word and PDF to Web Publishing (email above)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Make sure all linked documents are identified (especially if linked to another publication process such as CCDR)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Provide all necessary clarification re: URL, new or replacing, and anticipated date of release",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","If HIV/HEP, send embargoed PDF to CATIE to start coding (include final PDFs and short text paragraph to describe report) dmclay@catie.ca  ",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Provide all necessary clarification re: URL, new or replacing, and anticipated date of release to CATIE",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","QA all HTML English (including web links)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","QA all HTML French (including web links)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Web HTML (full report, exec summary, short reports, etc.)","Director informs DG of release, to add to her VP-DG Bilat ( FYI only)",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Dissimination","Notification to E-Comms to go Live",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Dissimination","If Applicable, send live Canada.ca URLS to CATIE; inform them they can go live",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Dissimination","Prepare Notification Email(s) to all stakeholders",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Dissimination","Translation of Notification Email",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]
["Unknown","Unknown","2020-01-01","Dissimination","E-mail stakeholders",200,"2020-01-01","2020-01-01","2020-01-01","2020-01-01"]

{"sheet":"RBMData","index":1,"n_rows":1,"n_cols":14,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Bill ","Analyst",500,20210709,20210709,20210709,20210709,"Watching too much TV",600,20210709,20210709,20210709,20210709,"Want to goto the mall"]

{"sheet":"Publications Form","index":2,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,4,0,11]]}
["Fred",null,null,null,"Publications Planning System"]

{"sheet":"UXForm","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}