{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Vision, Benefits, Objectives","Objective 1","Objective 2","Objective 3","Objective 4","Objective 5","Other notes"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":10,"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":"Vision, Benefits, Objectives","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"The Everyday Project Manager Website Project"]
[]
[]
[null,"Vision:","Create a website for the Everyday Project Manager."]
[]
[null,"Benefits:","We will have:"]
[null,"A","The ability for people to book courses online."]
[null,"B","A marketing portal for the Everyday PM book."]
[null,"C","A marketing portal for the Everyday PM course."]
[]
[null,"Objectives:","We will:","Relates to benefit:"]
[null,1,"Create full website content and publish online.","B, C"]
[null,2,"Create a booking page to allow online booking and payments to be taken.","A"]
[null,3,"Create an orders page that allows people to order and pre-order the Everyday Project Manager book.","B, C"]
[null,4,"Ensure users can download templates and course materials.","C"]
[null,5,"N/A","N/A"]

{"sheet":"Objective 1","index":1,"n_rows":71,"n_cols":8,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Objective 1:",{"$f":"'Vision, Benefits, Objectives'!C14","v":"Create full website content and publish online."},null,null,"Outline scope"]
[]
[null,null,null,null,"Outline Scope & requirements",null,null,"Full requirements"]
[]
[null,"ü",null,"Reference","Description","MSCW",null,"Comments"]
[null,null," Scope Item:",1.1000000000000001,"Define which sections/pages the website should have.","-"]
[null,null,"Requirements:","1.1.1","At least one page should link to the Blue Key Projects consultancy site.","S",null,"http://bluekeyprojects.co.uk"]
[null,"X",null,"1.1.2","Should include a dedicated Templates page.","M",null,"See also Objective 4 tab."]
[null,"X",null,"1.1.3","Should include a dedicated Course Booking page.","M"]
[null,"X",null,"1.1.4","Should include a dedicated Book Ordering page.","M"]
[null,null,null,"1.1.5","Should include links to other online PM resources.","C"]
[null,null,null,"1.1.6","Should not include a blog page.","W",null,"I do not intend to blog about project management - at least initially."]
[null,"X",null,"1.1.7","Should include a dedicated Tools and Resources page.","M",null,"This is referenced in the book."]
[null,"X",null,"1.1.7.1","The Tools and Resources page should be at the URL everydaypm.co.uk/tools to align with the book.","M"]
[null,null,null,"1.1.8"]
[]
[null,null," Scope Item:",1.2,"Write the content for each page.","-"]
[null,null,"Requirements:","1.2.1","Should be written in a consistent style throughout.","M"]
[null,null,null,"1.2.2","The writing style should be informal (e.g. 'everyday') and avoid jargon.","S"]
[null,null,null,"1.2.3","Should include a Terms and Conditions section.","M",null,"Specifically in relation to course booking but possibly more generally."]
[null,null,null,"1.2.4","Should include a Privacy Policy.","C",null,"Do I need one of these?"]
[null,null,null,"1.2.5"]
[null,null,null,"1.2.6"]
[null,null,null,"1.2.7"]
[null,null,null,"1.2.8"]
[null,null,null,"1.2.9"]
[]
[null,null," Scope Item:",1.3,"Choose and buy any imagery needed.","-"]
[null,null,"Requirements:","1.3.1","Images should not be too 'corporate'.","S",null,"i.e. no stock photos of people smiling around a flipchart."]
[null,null,null,"1.3.2","Images should be consistent in style. (e.g. I don't want photos on one page, then a cartoon on the next, then a sketch drawing, etc.)","S"]
[null,null,null,"1.3.3","Images should all come from one vendor.","S",null,"For best value and to avoid having multiple accounts with different suppliers."]
[null,null,null,"1.3.4","Images should not be watermarked.","M"]
[null,null,null,"1.3.5"]
[null,null,null,"1.3.6"]
[null,null,null,"1.3.7"]
[null,null,null,"1.3.8"]
[null,null,null,"1.3.9"]
[]
[null,null," Scope Item:",1.4,"Agree style criteria and branding for the website overall.","-"]
[null,null,"Requirements:","1.4.1","Should include use of Pacifico and Abadi Extra Light fonts to ensure brand consistency.","M"]
[null,null,null,"1.4.2","The Everyday Project Manager logo should be used on the homepage.","M"]
[null,null,null,"1.4.3","The Everyday Project Manager logo should be used on other pages if it fits with the content.","C"]
[null,null,null,"1.4.4","Should be 'responsive' so can be viewed on laptops, tablets and mobile devices.","S"]
[null,null,null,"1.4.5"]
[null,null,null,"1.4.6"]
[null,null,null,"1.4.7"]
[null,null,null,"1.4.8"]
[null,null,null,"1.4.9"]
[]
[null,null," Scope Item:",1.5,"Select and activate analytics for the site.","-"]
[null,null,"Requirements:","1.5.1","Should include a way of measuring website visitor numbers.","S"]
[null,null,null,"1.5.2","Should include a way of measuring file downloads (from the templates section).","C"]
[null,null,null,"1.5.3"]
[null,null,null,"1.5.4"]
[null,null,null,"1.5.5"]
[null,null,null,"1.5.6"]
[null,null,null,"1.5.7"]
[null,null,null,"1.5.8"]
[null,null,null,"1.5.9"]
[]
[null,null," Scope Item:",1.6,"DECISION: Include links to social media?","-",null,"I need to decide this asap.  Speak to Marketing Consultant."]
[null,null,"Requirements:","1.6.1","Facebook"]
[null,null,null,"1.6.2","LinkedIn"]
[null,null,null,"1.6.3","Twitter"]
[null,null,null,"1.6.4"]
[null,null,null,"1.6.5"]
[null,null,null,"1.6.6"]
[null,null,null,"1.6.7"]
[null,null,null,"1.6.8"]
[null,null,null,"1.6.9"]

{"sheet":"Objective 2","index":2,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Objective 2:",{"$f":"'Vision, Benefits, Objectives'!C15","v":"Create a booking page to allow online booking and payments to be taken."},null,null,"Outline scope"]
[]
[null,null,null,null,"Outline Scope & requirements",null,null,"Full requirements"]
[]
[null,"ü",null,"Reference","Description","MSCW",null,"Comments"]
[null,null," Scope Item:",2.1,"Identify an out-of-the-box booking platform.","-",null,"Should be plug & play, minimal configuration."]
[null,null,"Requirements:","2.1.1","Should require minimal configuration.","S"]
[null,"x",null,"2.1.2","Should incorporate within the site and not re-direct to another, purpose-built site.","S"]
[null,null,null,"2.1.3","Should accept credit cards.","S"]
[null,"x",null,"2.1.4","Should accept Paypal.","C"]
[null,"x",null,"2.1.5","Should use the same engine as the book orders page.","C"]
[null,"x",null,"2.1.6","Should allow courses to be added easily.","S"]
[null,"x",null,"2.1.7","Should allow up to 20 course options to be booked.","S",null,"Need to confirm the right number here.  Is it 20?"]
[null,null,null,"2.1.8","Should include a simple-to-use refund facility.","M"]
[null,null,null,"2.1.9","Should allow payment directly to the company bank account.","M"]
[null,null,null,"2.1.10"]
[]
[null,null," Scope Item:",2.2000000000000002,"Configure the web-page and add any additional information/booking advice.","-"]
[null,null,"Requirements:","2.2.1","Should include different cost options for different booking types.","M"]
[null,null,null,"2.2.1.1","Should have an 'individual' option.","S"]
[null,null,null,"2.2.1.2","Should have a 'group/project team' option.","S"]
[null,null,null,"2.2.1.3","Should have a 'remote/on-site' option.","S"]
[null,null,null,"2.2.2","Should include terms and conditions (e.g. refund policy, returns policy). ","M",null,"Could be a separate page of a pop-up."]
[null,null,null,"2.2.3"]
[null,null,null,"2.2.4"]
[null,null,null,"2.2.5"]
[null,null,null,"2.2.6"]
[]
[null,null," Scope Item:",2.2999999999999998,"Undertake a test course purchase prior to going live.","-"]
[null,null,"Requirements:","2.3.1","Should allow e.g. a £1.00 transaction to be put through.","S"]
[null,null,null,"2.3.2"]
[null,null,null,"2.3.3"]
[null,null,null,"2.3.4"]
[null,null,null,"2.3.5"]
[null,null,null,"2.3.6"]
[null,null,null,"2.3.7"]
[null,null,null,"2.3.8"]
[null,null,null,"2.3.9"]
[]
[null,null," Scope Item:",2.4,null,"-"]
[null,null,"Requirements:","2.4.1"]
[null,null,null,"2.4.2"]
[null,null,null,"2.4.3"]
[null,null,null,"2.4.4"]
[null,null,null,"2.4.5"]
[null,null,null,"2.4.6"]
[null,null,null,"2.4.7"]
[null,null,null,"2.4.8"]
[null,null,null,"2.4.9"]
[]
[null,null," Scope Item:",2.5,null,"-"]
[null,null,"Requirements:","2.5.1"]
[null,null,null,"2.5.2"]
[null,null,null,"2.5.3"]
[null,null,null,"2.5.4"]
[null,null,null,"2.5.5"]
[null,null,null,"2.5.6"]
[null,null,null,"2.5.7"]
[null,null,null,"2.5.8"]
[null,null,null,"2.5.9"]

{"sheet":"Objective 3","index":3,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Objective 3:",{"$f":"'Vision, Benefits, Objectives'!C16","v":"Create an orders page that allows people to order and pre-order the Everyday Project Manager book."},null,null,"Outline scope"]
[]
[null,null,null,null,"Outline Scope & requirements",null,null,"Full requirements"]
[]
[null,"ü",null,"Reference","Description","MSCW",null,"Comments"]
[null,null," Scope Item:",3.1,"Create a page and populate with information about the book.","-"]
[null,null,"Requirements:","3.1.1","Should include RRP.","M"]
[null,null,null,"3.1.2","Should include direct-booking discount.","M",null,"10%?"]
[null,null,null,"3.1.3","Should offer option of a signed copy (with message).","C"]
[null,null,null,"3.1.4","Should include reviews of the book.","C",null,"Might be a later addition once reviews have appeared on Amazon."]
[null,null,null,"3.1.5"]
[null,null,null,"3.1.6"]
[null,null,null,"3.1.7"]
[null,null,null,"3.1.8"]
[null,null,null,"3.1.9"]
[]
[null,null," Scope Item:",3.2,"Identify an out-of-the-box platform for taking orders and payments.","-"]
[null,null,"Requirements:","3.2.1","Should use the same engine as the course booking page.","C"]
[null,null,null,"3.2.2","Should require minimal configuration.","S"]
[null,null,null,"3.2.3","Should incorporate within the site and not re-direct to another, purpose-built site.","S"]
[null,null,null,"3.2.4","Should accept credit cards.","S"]
[null,null,null,"3.2.5","Should accept Paypal.","C"]
[null,null,null,"3.2.6",null,"C"]
[null,null,null,"3.2.7"]
[null,null,null,"3.2.8"]
[null,null,null,"3.2.9"]
[]
[null,null," Scope Item:",3.3,"Undertake a test book purchase prior to going live.","-"]
[null,null,"Requirements:","3.3.1","Should allow e.g. a £1.00 transaction to be put through.","S"]
[null,null,null,"3.3.2"]
[null,null,null,"3.3.3"]
[null,null,null,"3.3.4"]
[null,null,null,"3.3.5"]
[null,null,null,"3.3.6"]
[null,null,null,"3.3.7"]
[null,null,null,"3.3.8"]
[null,null,null,"3.3.9"]
[]
[null,null," Scope Item:",3.4,null,"-"]
[null,null,"Requirements:","3.4.1"]
[null,null,null,"3.4.2"]
[null,null,null,"3.4.3"]
[null,null,null,"3.4.4"]
[null,null,null,"3.4.5"]
[null,null,null,"3.4.6"]
[null,null,null,"3.4.7"]
[null,null,null,"3.4.8"]
[null,null,null,"3.4.9"]
[]
[null,null," Scope Item:",3.5,null,"-"]
[null,null,"Requirements:","3.5.1"]
[null,null,null,"3.5.2"]
[null,null,null,"3.5.3"]
[null,null,null,"3.5.4"]
[null,null,null,"3.5.5"]
[null,null,null,"3.5.6"]
[null,null,null,"3.5.7"]
[null,null,null,"3.5.8"]
[null,null,null,"3.5.9"]

{"sheet":"Objective 4","index":4,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Objective 4:",{"$f":"'Vision, Benefits, Objectives'!C17","v":"Ensure users can download templates and course materials."},null,null,"Outline scope"]
[]
[null,null,null,null,"Outline Scope & requirements",null,null,"Full requirements"]
[]
[null,"ü",null,"Reference","Description","MSCW",null,"Comments"]
[null,null," Scope Item:",4.0999999999999996,"Create list of which templates will be included initially.","-"]
[null,null,"Requirements:","4.1.1","Should include any templates referenced in the book.","M"]
[null,null,null,"4.1.2","Should include a simple cost plan.","S"]
[null,null,null,"4.1.3"]
[null,null,null,"4.1.4"]
[null,null,null,"4.1.5"]
[null,null,null,"4.1.6"]
[null,null,null,"4.1.7"]
[null,null,null,"4.1.8"]
[null,null,null,"4.1.9"]
[]
[null,null," Scope Item:",4.2,"Create the templates.","-"]
[null,null,"Requirements:","4.2.1","Templates should be read-only, if appropriate.","S"]
[null,null,null,"4.2.2","Templates should be branded.","S"]
[null,null,null,"4.2.3","Templates should allow user to remove branding.","C"]
[null,null,null,"4.2.4","Templates should be in MS Office formats for maximum reach.","M"]
[null,null,null,"4.2.5","Templates should be in other formats (e.g. Apple, OpenOffice).","C",null,"Need to confirm which formats.  This might be an ongoing activity, rather than a project requirement."]
[null,null,null,"4.2.6"]
[null,null,null,"4.2.7"]
[null,null,null,"4.2.8"]
[null,null,null,"4.2.9"]
[]
[null,null," Scope Item:",4.3,"Ensure templates can be downloaded.","-"]
[null,null,"Requirements:","4.3.1","Should test download is possible from at least two computers.","S"]
[null,null,null,"4.3.2"]
[null,null,null,"4.3.3"]
[null,null,null,"4.3.4"]
[null,null,null,"4.3.5"]
[null,null,null,"4.3.6"]
[null,null,null,"4.3.7"]
[null,null,null,"4.3.8"]
[null,null,null,"4.3.9"]
[]
[null,null," Scope Item:",4.4000000000000004,null,"-"]
[null,null,"Requirements:","4.4.1"]
[null,null,null,"4.4.2"]
[null,null,null,"4.4.3"]
[null,null,null,"4.4.4"]
[null,null,null,"4.4.5"]
[null,null,null,"4.4.6"]
[null,null,null,"4.4.7"]
[null,null,null,"4.4.8"]
[null,null,null,"4.4.9"]
[]
[null,null," Scope Item:",4.5,null,"-"]
[null,null,"Requirements:","4.5.1"]
[null,null,null,"4.5.2"]
[null,null,null,"4.5.3"]
[null,null,null,"4.5.4"]
[null,null,null,"4.5.5"]
[null,null,null,"4.5.6"]
[null,null,null,"4.5.7"]
[null,null,null,"4.5.8"]
[null,null,null,"4.5.9"]

{"sheet":"Objective 5","index":5,"n_rows":60,"n_cols":8,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Objective 5:",{"$f":"'Vision, Benefits, Objectives'!C18","v":"N/A"},null,null,"Outline scope"]
[]
[null,null,null,null,"Outline Scope & requirements",null,null,"Full requirements"]
[]
[null,"ü",null,"Reference","Description","MSCW",null,"Comments"]
[null,null," Scope Item:",5.0999999999999996,null,"-"]
[null,null,"Requirements:","5.1.1"]
[null,null,null,"5.1.2"]
[null,null,null,"5.1.3"]
[null,null,null,"5.1.4"]
[null,null,null,"5.1.5"]
[null,null,null,"5.1.6"]
[null,null,null,"5.1.7"]
[null,null,null,"5.1.8"]
[null,null,null,"5.1.9"]
[]
[null,null," Scope Item:",5.2,null,"-"]
[null,null,"Requirements:","5.2.1"]
[null,null,null,"5.2.2"]
[null,null,null,"5.2.3"]
[null,null,null,"5.2.4"]
[null,null,null,"5.2.5"]
[null,null,null,"5.2.6"]
[null,null,null,"5.2.7"]
[null,null,null,"5.2.8"]
[null,null,null,"5.2.9"]
[]
[null,null," Scope Item:",5.3,null,"-"]
[null,null,"Requirements:","5.3.1"]
[null,null,null,"5.3.2"]
[null,null,null,"5.3.3"]
[null,null,null,"5.3.4"]
[null,null,null,"5.3.5"]
[null,null,null,"5.3.6"]
[null,null,null,"5.3.7"]
[null,null,null,"5.3.8"]
[null,null,null,"5.3.9"]
[]
[null,null," Scope Item:",5.4,null,"-"]
[null,null,"Requirements:","5.4.1"]
[null,null,null,"5.4.2"]
[null,null,null,"5.4.3"]
[null,null,null,"5.4.4"]
[null,null,null,"5.4.5"]
[null,null,null,"5.4.6"]
[null,null,null,"5.4.7"]
[null,null,null,"5.4.8"]
[null,null,null,"5.4.9"]
[]
[null,null," Scope Item:",5.5,null,"-"]
[null,null,"Requirements:","5.5.1"]
[null,null,null,"5.5.2"]
[null,null,null,"5.5.3"]
[null,null,null,"5.5.4"]
[null,null,null,"5.5.5"]
[null,null,null,"5.5.6"]
[null,null,null,"5.5.7"]
[null,null,null,"5.5.8"]
[null,null,null,"5.5.9"]

{"sheet":"Other notes","index":6,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"The following things occurred to me while I was populating the other tabs:","Action"]
[null,1,"GDPR policy.  Not part of the website objectives, but I will need to consider what data I am capturing when people book courses and any GDPR compliance concerns.","Speak to Marketing Consultant for advice on this."]
[null,2,"Social media - I need to consider what I am doing about this.  Which platforms do I want to have a presence on?  Do I need to be on more than one, or should I focus on just, say, Facebook?","Speak to Marketing Consultant for advice on this."]
[null,3,"Need to decide how much of this to outsource (if any - I could do it all myself, but I might not be best placed).","Decision needed: which elements to outsource."]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]