{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["rpt_template","dropdowns"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"rpt_template","index":0,"n_rows":186,"n_cols":11,"rows_kept":186,"cut":false,"hidden":false,"merged":[[181,0,182,0],[181,2,182,2],[181,4,182,4],[183,0,184,0],[183,2,184,2],[183,4,184,4],[144,5,144,7],[152,5,152,7],[179,0,180,0],[179,2,180,2],[179,4,180,4],[144,0,152,0],[155,2,156,2],[155,4,156,4],[145,5,145,7],[146,5,146,7],[147,5,147,7],[148,5,148,7],[149,5,149,7],[150,5,150,7],[151,5,151,7],[101,4,106,7],[101,2,106,2],[101,0,106,0],[23,4,28,7],[23,2,28,2],[118,2,123,2],[118,4,123,7],[137,2,142,2],[137,4,142,7],[161,2,162,2],[157,2,158,2],[159,2,160,2],[163,2,164,2],[165,2,166,2],[157,4,158,4],[159,4,160,4],[161,4,162,4],[163,4,164,4],[165,4,166,4],[175,5,176,5],[165,5,166,5],[177,2,178,2],[167,4,168,4],[169,4,170,4],[171,4,172,4],[173,4,174,4],[175,4,176,4],[177,4,178,4],[167,2,168,2],[169,2,170,2],[171,2,172,2],[173,2,174,2],[175,2,176,2],[163,5,164,5],[173,0,174,0],[175,0,176,0],[177,0,178,0],[185,0,190,0],[2,4,2,7],[185,2,190,2],[185,4,190,7],[23,0,28,0],[118,0,123,0],[137,0,142,0],[155,0,156,0],[157,0,158,0],[159,0,160,0],[161,0,162,0],[163,0,164,0],[165,0,166,0],[167,0,168,0],[169,0,170,0],[171,0,172,0],[167,5,168,5],[169,5,170,5],[171,5,172,5],[173,5,174,5],[179,6,180,7],[181,6,182,7],[183,6,184,7],[154,6,154,7],[177,5,178,5],[179,5,180,5],[181,5,182,5],[183,5,184,5],[155,6,156,7],[157,6,158,7],[159,6,160,7],[161,6,162,7],[163,6,164,7],[165,6,166,7],[167,6,168,7],[169,6,170,7],[171,6,172,7],[173,6,174,7],[175,6,176,7],[177,6,178,7],[155,5,156,5],[157,5,158,5],[159,5,160,5],[161,5,162,5]]}
[]
[]
["GUIDANCE/INSTRUCTIONS",null,"KEY ",null,"VALUE",null,null,null,null,null,"NOTE (optional)"]
[]
[null,null,"PROJECT ENTITY"]
[null,null,"Project/Programme Name ",null,"Two Step Shuffle"]
[]
[]
["Complete drop down",null,"Project or Programme",null,"Project"]
[]
[]
["Recognised Acronym. Short as possible ",null,"Acronym",null,"TSS"]
[]
[]
["PfM to provide",null,"ID"]
[]
[]
[null,null,"Directorate",null,"TICK"]
[]
["Agency, if relevant",null,"Agency "]
[null,null,"Directorate "]
[]
[]
["Summary of project and what it aims to achieve. Please set out in this section the project scope, which means what is being covered via this return. ",null,"Brief Description / Project Scope",null,"A type of dance which involved two steps then a shuffle and then some break dancing. "]
[]
[]
[]
[]
[]
[]
[null,null,"PEOPLE"]
["DfT Sponsor",null,"DfT Sponsor",null,"Paul Breadhead"]
["Senior Responsible Owner ",null,"SRO",null,"Liam Gallagher"]
[]
[]
[]
[null,null,"SRO email",null,"liamg@datamaps.co.uk"]
[]
[]
[]
[null,null,"SRO telephone no.",null,7815453816]
[]
[]
[]
["Project Director",null,"Project Director (PD)",null,"Liam Gallagher"]
[]
[]
[]
[null,null,"PD email",null,"liamg@datamaps.co.uk"]
[]
[]
[null,null,"PD telephone no. ",null,7815453816]
[]
[]
["Person to contact for reporting",null,"PfM point of contact (PoC)",null,"Liam Gallagher"]
[]
[]
[]
[null,null,"PoC email",null,"liamg@datamaps.co.uk"]
[null,null,"PoC telephone no.",null,7815453816]
[]
[]
[null,null,"STAGE / BASELINE"]
["BC stage drop down options",null,"Last Business Case (BC) achieved",null,"Full Business Case"]
[]
[]
["BC stage drop down options",null,"Next BC stage working towards",null,"Ongoing Board papers"]
[]
[]
["Yes / No drop down",null,"BC or other approval by CDG Board in quarter",null,"NO"]
["Yes / No drop down"]
["Yes / No drop down"]
["Yes / No drop down",null,"Costs re-baselined by CDG in quarter",null,"NO"]
["Yes / No drop down"]
["Yes / No drop down"]
["Yes / No drop down",null,"Schedule re-baselined by CDG in quarter",null,"NO"]
["Yes / No drop down"]
["Yes / No drop down"]
["Yes / No drop down"]
["Yes / No drop down",null,"Benefits re-baselined by CDG in quarter",null,"NO"]
[]
[]
[]
[null,null,"CONFIDENCE & NARRATIVE"]
["Five RAG rating drop down",null,"Overall Delivery Confidence ",null,"Amber/Green"]
["Five RAG rating drop down"]
["Five RAG rating drop down"]
["Five RAG rating drop down"]
["Five RAG rating drop down",null,"Costs Confidence",null,"Amber/Green"]
["Five RAG rating drop down"]
["Five RAG rating drop down"]
["Five RAG rating drop down"]
["Five RAG rating drop down",null,"Schedule Confidence",null,"Amber/Green"]
["Five RAG rating drop down"]
["Five RAG rating drop down"]
["Five RAG rating drop down"]
["Five RAG rating drop down",null,"Benefits Confidence",null,"Amber/Green"]
["Five RAG rating drop down"]
["Five RAG rating drop down"]
["Five RAG rating drop down"]
[]
["SRO commentary and reasoning for confidence ratings.  Word limit 500. ",null,"SRO Narrative",null,"Something something there is always something happening"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"COSTS/INCOME/RECEIPTS"]
["£Millions",null,"Total Costs Spent",null,90.90000000000001]
["£Millions",null,"Total Costs Remaining",null,12.5]
["Automatically calculated",null,"Total Costs",null,{"$f":"SUM(E111:E112)","v":null}]
["£Millions",null,"Total Income Achieved",null,0]
["£Millions",null,"Total Income Remaining",null,8.5]
["£Millions",null,"Total Income",null,{"$f":"SUM(E114:E115)","v":null}]
[]
[]
["Optional narrative on project cost data. For property projects this should include expected date of receipts and costs. 250 word limit. ",null,"Cost Narrative",null,"Beautiful is better than ugly. Explicit is better than implicit. Simple is better than complex. Complex is better than complicated. Flat is better than nested. Sparse is better than dense. Readability counts. Special cases aren't special enough to break the rules. Although practicality beats purity. Errors should never pass silently. Unless explicitly silenced. In the face of ambiguity, refuse the temptation to guess. There should be one-- and preferably only one --obvious way to do it. Although that way may not be obvious at first unless you're Dutch. Now is better than never. Although never is often better than *right* now. If the implementation is hard to explain, it's a bad idea. If the implementation is easy to explain, it may be a good idea. Namespaces are one honking great idea -- let's do more of those!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"BENEFITS"]
["£Millions",null,"Benefits delivered",null,0]
["£Millions",null,"Benefits to be delivered",null,8.5]
["Automatically calculated ",null,"Total Benefits",null,{"$f":"SUM(E130:E131)","v":null}]
[null,null,"BCR"]
[null,null,"VfM Category",null,"Low"]
[]
[]
[]
["Optional narrative on project benefits data. Should covered text on any non-monetised benefits. 250 word limit. ",null,"Benefit Narrative",null,"The benefit of benefits is that you can benefit from them and you can tell everyone around you the benefits you are having from a particular benefit and the calculations that you have made on how big the benefits will be and how many of those benefits there will be and that those calculations are not made up or incorrect at all…"]
[]
[]
[]
[]
[]
[]
["In this quarter, does the SRO have any concerns or emergent risks in the following areas which they wish to raise for discussion at the Tier 2 Board?",null,"RISKS",null,"DROP DOWN","SHORT NOTE IF DROP DOWN YES"]
[null,null,"Benefits ",null,"NO"]
[null,null,"Capability",null,"NO"]
[null,null,"Cost",null,"NO"]
[null,null,"Objectives ",null,"NO"]
[null,null,"Purpose",null,"NO"]
[null,null,"Schedule",null,"NO"]
[null,null,"Sponsorship",null,"NO"]
[null,null,"Stakeholders",null,"NO"]
[]
[null,null,"SCHEDULE",null,"DATE","STATUS","MILESTONE NOTES (Optional)"]
["Date when SOBC approved",null,"SOBC Approval",null,"2015-06-25"]
[]
["Date when OBC approved",null,"OBC Approval",null,"2016-04-18"]
[]
["Date when FBC approved",null,"FBC Approval",null,"2017-09-01"]
[]
["For construction/digital projects",null,"Start of construction/build",null,"2019-04-01"]
[]
["Date when project starts operational use",null,"Start of operations",null,"2022-06-30",null,"Keep on Tracking"]
[]
["Date when project is fully operational.",null,"Full operations",null,"2022-06-30",null,"Live and let die"]
[]
["Date when project team is closed down.",null,"End date",null,"2022-06-30",null,"Oasis and Blur. Who’s better?"]
[]
["For land disposal projects",null,"Pre-planning complete"]
[]
["For land disposal projects",null,"Marketing commence"]
[]
["For land disposal projects",null,"Contract for sale complete"]
[]
["For land disposal projects",null,"Completion of sale"]
[]
["optional additional key project milestone for CDG Board information",null,"Practical Completion of building works",null,"2022-04-29",null,"Lets send Putin into space"]
[]
["optional additional key project milestone for CDG Board information",null,"other milestone 2 ENTER KEY NAME"]
[]
["optional additional key project milestone for CDG Board information",null,"other milestone 3 ENTER KEY NAME"]
[]
["optional additional key project milestone for CDG Board information",null,"other milestone 4 ENTER KEY NAME"]
[]
["Optional narrative on project schedule. 250 word limit. ",null,"Schedule Narrative",null,"Handling static files in django is a bit of a nightmare. "]

{"sheet":"dropdowns","index":1,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["YES","COMMERCIAL DIRECTORATE",null,"pre-Strategic Outline Case",null,"Green",null,"Project",null,"Very Poor",null,null,null,"COMPLETED"]
["NO","COMMUNICATIONS",null,"Strategic Outline Case",null,"Amber/Green",null,"Programme",null,"Poor",null,null,null,"ON TRACK"]
[null,"CORPORATE FINANCE",null,"Outline Business Case",null,"Amber",null,null,null,"Low",null,null,null,"AT RISK"]
[null,"GROUP ASSURANCE",null,"Full Business Case",null,"Amber/Red",null,null,null,"Medium"]
[null,"GROUP FINANCE",null,"Ongoing Board papers",null,"Red",null,null,null,"High"]
[null,"GROUP INTERNAL AUDIT",null,null,null,null,null,null,null,"Very High"]
[null,"HUMAN RESOURCES",null,null,null,null,null,null,null,"Very High and Financially Positive"]
[null,"PPDD",null,null,null,null,null,null,null,"Economically Efficient Cost Saving"]
[null,"SHAREHOLDING AND CORPORATE SPONSORSHIP"]