{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Info","Digital Twin Strategy Canvas","ROI Calculator","Results","Use-Cases","Mapping (v3)","Costs_Data","Benefits_Data","Dropdown"],"not_rendered":{"charts":2,"images":29,"macros":1,"external_links":0,"defined_names":32,"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":"Info","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,3,3,14],[7,4,8,18],[10,3,13,3],[10,4,25,10],[27,3,30,3],[27,4,30,10]]}
[]
[]
[null,null,null,"INFORMATION - HOW TO ENABLE TOOL FUNCTIONALITY"]
[]
[]
[]
[]
[null,null,null,"Background","When downloaded onto a computer, the Digital Twin Strategy Canvas and ROI Calculator may be automatically blocked by the computer's system as it is an external file downloaded from a potentially untrusted source. Blocked files will be unable to access or use the built in macro functions that enable this tool to work. To enable content, follow instructions below."]
[]
[]
[null,null,null,"How to enable the file:","The Digital Twin Strategy Canvas and ROI Calculator (\"Excel file\") should be first downloaded only from a trusted source from either within ADB, or trusted and authorized third parties. The excel file can have its contents enabled by the following 2 primary steps:\n\n1. Unblock the file on the computer system. On windows devices, this can be done through right-clicking on the file, navigating to the \"General\" or \"Security\" tab, and unchecking the box titled \"Unblock\".  An example visual of this process is shown to the right.\n\n2. When opening the excel file, enable macro contents to ensure that all buttons and links within the file work as intended.\n\nIf any issues persist, please contact the relevant departments within your organization for assistance. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Moving on:","After enabling content, move over to the first tab \"Digital Twin Strategy Canvas\" to begin the Digital Twin journey."]

{"sheet":"Digital Twin Strategy Canvas","index":1,"n_rows":319,"n_cols":19,"rows_kept":319,"cut":false,"hidden":false,"merged":[[318,2,320,9],[318,11,320,19],[2,3,3,14],[209,9,227,18],[53,11,62,15],[53,16,74,19],[279,2,279,4],[12,4,12,18],[183,5,185,7],[183,8,185,18],[195,5,197,7],[174,8,175,18],[177,8,178,18],[180,8,181,18],[192,5,194,7],[189,5,191,7],[189,8,191,18],[230,9,248,18],[250,9,268,18],[204,2,204,7],[204,8,204,19],[192,8,193,18],[195,8,196,18],[70,3,71,5],[58,6,60,10],[70,6,72,10],[73,3,75,5],[73,6,75,10],[58,3,59,5],[64,3,65,5],[67,3,68,5],[64,6,66,10],[67,6,69,10],[129,4,133,18],[123,3,126,3],[123,4,126,18],[148,3,152,3],[148,4,152,18],[9,3,10,3],[9,4,11,18],[118,3,121,3],[88,4,90,18],[92,3,96,3],[92,4,96,18],[118,4,121,18],[29,2,45,7],[29,8,45,13],[29,14,45,19],[27,2,27,7],[27,8,27,13],[55,3,57,5],[61,3,63,5],[61,6,63,10],[48,2,48,10],[27,14,27,19],[48,16,48,19],[48,11,48,15],[55,6,56,10],[160,3,164,3],[160,4,164,18],[52,6,53,10],[52,3,54,5],[154,3,157,3],[154,4,157,18],[99,3,103,3],[99,4,103,18],[84,4,86,18],[143,4,146,18],[129,3,133,3],[113,4,116,18],[186,5,188,7],[186,8,188,18],[174,5,176,7],[177,5,179,7],[180,5,182,7]]}
[]
[]
[null,null,null,"STEP 1: CONCEPTUALIZE - DIGITAL TWIN STRATEGY CANVAS"]
[]
[]
[]
[]
[null,null,null,"Objective:","To conceptualize the Digital Twin Lite using the Digital Twin Strategy Canvas."]
[]
[null,null,null,"How it works:","The Digital Twin Strategy Canvas (\"Canvas\") is a planning tool that Project Team Members can utilize in order to logically conceptualize the Digital Twin Lite. The Canvas is comprised of 6 sections and sections 1-4 should be filled in by Project Team Members in order, whereas sections 5-6 are automatically completed by this tool based on inputs from the previous sections. Furthermore, to facilitate the use of this Canvas, a Digital Twin initiative with ADB for Indonesia's new capital Nusantara is used as guidance."]
[]
[]
[null,null,null,"Instructions:","This Canvas should be completed by ADB Project Teams, with optional participation and inputs from DMC Counterparts."]
[]
[null,null,null,"Go to:","1.) Project Summary"]
[null,null,null,null,"2.) Project Vision & Strategy"]
[null,null,null,null,"3.) Project Outputs and Outcomes"]
[null,null,null,null,"4.) Desired Solution & Benefits"]
[null,null,null,null,"5.) Indicative Maturity Level"]
[null,null,null,null,"6.) Past Success Stories"]
[]
[]
[]
[null,null,"DIGITAL TWIN STRATEGY CANVAS"]
[]
[]
[]
[null,null,"1.) PROJECT SUMMARY",null,null,null,null,null,"2.) PROJECT VISION & STRATEGY",null,null,null,null,null,"3.) PROJECT OUTPUT AND OUTCOMES"]
[]
[null,null,{"$f":"IF(E100=0,\"[Complete Canvas inputs below]\",E100)","v":"[Complete Canvas inputs below]"},null,null,null,null,null,{"$f":"IF(E130=0,\"[Complete Canvas inputs below]\",E130)","v":"[Complete Canvas inputs below]"},null,null,null,null,null,{"$f":"IF(E161=0,\"[Complete Canvas inputs below]\",E161)","v":"[Complete Canvas inputs below]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"4.) DESIRED SOLUTION & INDICATIVE BENEFITS",null,null,null,null,null,null,null,null,"5.) INDICATIVE MATURITY LEVEL",null,null,null,null,"6.) PAST SUCCESS STORIES"]
[]
[null,null,null,"DESIRED SOLUTION(S)",null,null,"AND INDICATIVE BENEFITS",null,null,null,null,"Your desired twin is…",null,null,null,null,"Some examples of…"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(TEXT(I205,\"0\"),\"Complete Canvas inputs below\")","v":"-"},null,null,null,null,{"$f":"IFERROR(TEXT(I205,\"0\"),\"Complete Canvas inputs below\")","v":"-"}]
[null,null,{"$f":"IF(D175=0,\"-\",D175)","v":"-"},"Stress test the potential infrastructure against current built-environment",null,null,"Improved investment decision making; feasibility assessment "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(L52=\"Level 1: Descriptive Twin\",J210,IF(L52=\"Level 2: Informative Twin\",J231,IF(L52=\"Level 3: Predictive Twin\",J251,\"[Complete Canvas inputs below]\")))","v":"[Complete Canvas inputs below]"},null,null,null,null,{"$f":"IF(Q52=\"Level 1: Descriptive Twin\",_xlfn.ARRAYTOTEXT(J283:J288),IF(Q52=\"Level 2: Informative Twin\",_xlfn.ARRAYTOTEXT(J291:J296),IF(Q52=\"Level 3: Predictive Twin\",_xlfn.ARRAYTOTEXT(J299:J308),\"[Complete Canvas inputs below]\")))","v":"[Complete Canvas inputs below]"}]
[]
[null,null,{"$f":"IF(D178=0,\"-\",D178)","v":"-"},"Stress test the potential infra. against future conditions and environments (e.g. climate change, physical risks)",null,null,"Improved investment decision making; feasibility assessment; climate-resilient infrastructure"]
[]
[]
[null,null,{"$f":"IF(D181=0,\"-\",D181)","v":"-"},"Evaluate and optimize design\nto meet specific outcome(s)",null,null,"Alternative infrastructure designs; reduce resource consumption; improved sustainability; reduction in GHG emissions; improve service quality and satisfaction"]
[]
[]
[null,null,{"$f":"IF(D184=0,\"-\",D184)","v":"-"},"Urban planning tool to conceptualize different urban designs and analyze various scenarios",null,null,"Improved investment decision making; optimized land use and resource usage; improve service quality and satisfaction"]
[]
[]
[null,null,{"$f":"IF(D187=0,\"-\",D187)","v":"-"},"Collaborate and visualize virtually",null,null,"Improve design process; informed and early stakeholder feedback; reduce lead time; greater access to information"]
[]
[]
[null,null,{"$f":"IF(D190=0,\"-\",D190)","v":"-"},"Immerse and experience virtually",null,null,"Boost marketing potential for the Digital Twin; Enhance stakeholder adoption and buy-in"]
[]
[]
[null,null,{"$f":"IF(D193=0,\"-\",D193)","v":"-"},"Conduct immersive training",null,null,"Improve workforce capacity; improve workplace efficiency; reduce operational lead times; improve workplace safety"]
[]
[]
[null,null,{"$f":"IF(D196=0,\"-\",D196)","v":"-"},"Monitoring the construction and building of the infrastructure",null,null,"Remote monitoring; real-time or near real-time decision making; reduce operational lead times; prevent construction delays"]
[]
[]
[]
[]
[null,null,"1.) PROJECT SUMMARY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jump to Canvas"]
[]
[]
[]
[]
[]
[null,null,null,"What:","The Project Team Member should provide a short description of infrastructure project in consideration for the Digital Twin, including project particulars, key objectives, project lifecycle stage and other key details that may be useful to record for other users of the Canvas (e.g., procurement officers, technology vendors, officials from the implementing agency, etc.). Furthermore, the description of the project should avoid focusing on the Digital Twin at this stage. "]
[]
[]
[]
[null,null,null,"Guidance:","- Provide short description of the infrastructure project in consideration for the Digital Twin\n- Include project particulars, key objectives, project lifecycle stage, and other key details that may be useful\n- Avoid focusing on the Digital Twin"]
[]
[]
[]
[null,null,null,"Example:","ADB is supporting the Nusantara National Capital Authority (NNCA) in the development of Nusantara, the future capital city of Indonesia, as a carbon-neutral forest city, and become carbon-neutral by 2045. The city of Nusantara spans across 2,561 Sq. km of land area and is situated on the east coast of the island of Borneo. \nThis first involves developing a ‘compass’ in planning, developing, and managing the carbon neutrality journey in the form of a Net Zero Strategy. The Strategy will address five focus areas including Forestry and Other Land Uses (rehabilitation and protection), Energy (No fossil fuel), Industrials (Green building and materials), Waste Mgt. (Circular economy), and Agriculture (regenerative agri)."]
[]
[]
[]
[]
[]
[]
[null,null,null,"Input:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"2.) PROJECT VISION & STRATEGY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jump to Canvas"]
[]
[]
[]
[]
[]
[null,null,null,"What:","This section should identify and record any important details that convey the vision and strategic relevance of the infrastructure project. This could include details of a larger regional or national strategy or vision of the project sponsors under which the project is a part of, and how it aligns with ADB’s long term strategy (Strategy 2030) and operational priorities (OP). This section of the canvas is reserved to communicate the importance of the project to future users and key decision makers. Once again, the vision and strategy of the project should avoid focusing on the Digital Twin at this stage.  "]
[]
[]
[]
[]
[null,null,null,"Guidance:","- Provide the overarching vision and strategy for the infrastructure project\n- Include details of associated larger regional or national strategy or vision (Optional)\n- Include details fo how it aligns with ADB's long-term strategy (Strategy 2030) and operational priorities (Optional)\n- Avoid focusing on the Digital Twin"]
[]
[]
[]
[]
[null,null,null,"Example:","This Project is part of a wider technical assistance project aimed at supporting selected DMCs to plan and develop livable cities that are smart, inclusive, environmentally sustainable, resilient, and competitive. The Project greatly aligns with national strategy, as Indonesia designated Nusantara as the new capital. The project will further be supporting Indonesia’s efforts (Master Plan Presidential Regulation No. 63/2022) to boost climate resilience by mitigating carbon emissions and adapting to climate change which will pave the pathway to achieving net zero in 2045. The Project also supports 4 ADB operational priorities (OP) such as OP3: Making Cities More Liveable."]
[]
[]
[]
[]
[]
[null,null,null,"Input:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"3.) PROJECT OUTPUTS & OUTCOMES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jump to Canvas"]
[]
[]
[]
[]
[]
[null,null,null,"What:","In this section, the project team begins to brainstorm the underlying question of ‘why’ a solution is needed at this early stage of the infrastructure project. Using ADB’s published Design and Monitoring Framework (DMF) structure, readers should first identify the outputs and outcomes of their project, based on the OPs identified from the previous step (Project Vision and Strategy). The intended project outputs and outcomes are typically prepared by ADB project teams as part of documents such as the Project Data Sheet and Report and Recommendation of the President (RRP), and are in any case necessary as part of the project completion report."]
[]
[]
[]
[]
[null,null,null,"Guidance:","- Base outputs and outcomes on the ADB Operational Priorities\n- Use existing ADB documentation such as the Design and Monitoring Framework, Project Data Sheet, and the Report and Recommendation of the President (RRP) to assist\n- Consider consultations with other project stakeholders (List of technology vendors in the Framework's Annex)\n- Evaluate the list and reconsider whether non-technological interventions can already achieve project outputs/outcomes"]
[]
[]
[]
[]
[]
[null,null,null,"Example:","Outcome: Improve Nusantara’s capacity to plan/enforce urban planning systems, provide service, manage finance\nOutputs:\n- Improve urban planning systems and enforcement\n- Improve key infrastructure and municipal service delivery\n- Financial management systems in Nusantara improved to ensure limited financing is utilized in the most efficient manner to promote transparency and accountability\n\nNusantara’s (NNCA’s) target outputs:\n- Reduce carbon emissions by 1.1MtCO2\n- Protect and restore 59,000ha and 83,000ha of forests respectively to improve carbon stock\n- Construction of 50MW solar panels\n- 60% recovering/recycling of waste, 40% of waste converted into energy"]
[]
[]
[]
[]
[]
[null,null,null,"Input:"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"4.) DESIRED SOLUTION & BENEFITS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jump to Canvas"]
[]
[]
[]
[null,null,null,"FILL",null,"DESIRED SOLUTION(S)",null,null,"AND INDICATIVE BENEFITS"]
[]
[null,null,null,null,null,"Stress test the potential infrastructure against current built-environment",null,null,"Improved investment decision making; feasibility assessment "]
[]
[]
[null,null,null,null,null,"Stress test the potential infra. against future conditions and environments (e.g. climate change, physical risks)",null,null,"Improved investment decision making; feasibility assessment; climate-resilient infrastructure"]
[]
[]
[null,null,null,null,null,"Evaluate and optimize design\nto meet specific outcome(s)",null,null,"Alternative infrastructure designs; reduce resource consumption; improved sustainability; reduction in GHG emissions; improve service quality and satisfaction"]
[]
[]
[null,null,null,null,null,"Urban planning tool to conceptualize different urban designs and analyze various scenarios",null,null,"Improved investment decision making; optimized land use and resource usage; improve service quality and satisfaction"]
[]
[]
[null,null,null,null,null,"Collaborate and visualize virtually",null,null,"Improve design process; informed and early stakeholder feedback; reduce lead time; greater access to information"]
[]
[]
[null,null,null,null,null,"Immerse and experience virtually",null,null,"Boost marketing potential for the Digital Twin; Enhance stakeholder adoption and buy-in"]
[]
[]
[null,null,null,null,null,"Conduct immersive training",null,null,"Improve workforce capacity; improve workplace efficiency; reduce operational lead times; improve workplace safety"]
[]
[]
[null,null,null,null,null,"Monitoring the construction and building of the infrastructure",null,null,"Remote monitoring; real-time or near real-time decision making; reduce operational lead times; prevent construction delays"]
[]
[]
[]
[]
[]
[null,null,"5.) INDICATIVE MATURITY LEVEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jump to Canvas"]
[]
[]
[null,null,"Your desired Digital Twin Lite is a…",null,null,null,null,null,{"$f":"IFERROR('Mapping (v3)'!I19,\"-\")","v":"-"}]
[null,null,{"$f":"TEXT(I205,\"0\")","v":"-"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$error":"#VALUE!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"6.) PAST SUCCESS STORIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Jump to Canvas"]
[]
[]
[null,null,"Here are some examples of a"]
[null,null,{"$f":"TEXT(I205,\"0\")","v":"-"},null,null,null,null,null,null,"Digital Twin Past Success Stories"]
[]
[null,null,null,null,null,null,null,null,null,"Level 1"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of Trondheim, Norway"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of Jeonju City"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of a Precinct - Melbourne Quarter"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of a Port - Nauru"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of Rail Stations - Smart Stations"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of a Substation - Sidwawa"]
[]
[null,null,null,null,null,null,null,null,null,"Level 2"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of a Building - University of Melbourne"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of a Railway - Johor Bahru-Singapore"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of a Railway - Redfern"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of a Railway - ARTC"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of UK's National Grid"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of a Steel Plant - MCC Capital"]
[]
[null,null,null,null,null,null,null,null,null,"Level 3"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of Siemensstadt Square"]
[null,null,null,null,null,null,null,null,null,"Virtual Singapore"]
[null,null,null,null,null,null,null,null,null,"New South Wales (NSW) Spatial Digital Twin"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of Monaco"]
[null,null,null,null,null,null,null,null,null,"Digital Twin Victoria"]
[null,null,null,null,null,null,null,null,null,"Penang Smart Mobility"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of a Wastewater Treatment Plant - Echowater"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of a Hydraulic Pipe System in Ayodhya"]
[null,null,null,null,null,null,null,null,null,"Digital Twin for Road Design - Uzbekistan A380"]
[null,null,null,null,null,null,null,null,null,"Digital Twin of Rail Crossings - Parkdale"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"7.) SEE COMPLETED CANVAS OR MOVE FORWARD TO BUILD A BUSINESS CASE (ROI CALCULATOR)"]
[]
[]
[null,null,"JUMP TO CANVAS",null,null,null,null,null,null,null,null,"BUILD A BUSINESS CASE"]

{"sheet":"ROI Calculator","index":2,"n_rows":223,"n_cols":27,"rows_kept":223,"cut":false,"hidden":false,"merged":[[167,3,167,15],[167,17,167,18],[148,17,149,17],[159,19,159,20],[160,19,160,20],[161,19,161,20],[162,19,162,20],[163,19,163,20],[154,19,154,20],[155,19,155,20],[156,19,156,20],[157,19,157,20],[158,19,158,20],[222,7,224,14],[155,3,155,15],[170,3,170,15],[170,17,170,18],[163,17,163,18],[162,3,162,15],[163,3,163,15],[158,17,158,18],[159,17,159,18],[160,17,160,18],[161,17,161,18],[162,17,162,18],[214,3,214,12],[214,15,214,17],[178,3,178,18],[182,3,192,7],[2,3,3,19],[35,4,35,14],[36,4,36,14],[174,3,174,15],[37,4,40,14],[41,4,45,14],[156,3,156,15],[157,3,157,15],[158,3,158,15],[159,3,159,15],[151,3,151,15],[152,3,152,15],[153,3,153,15],[154,3,154,15],[160,3,160,15],[161,3,161,15],[8,4,8,5],[83,3,83,15],[83,17,83,18],[56,17,56,18],[57,3,57,15],[10,4,11,18],[26,4,31,18],[13,4,24,18],[37,3,39,3],[60,3,79,15],[54,17,54,18],[209,26,209,28],[199,3,199,6],[199,12,199,14],[199,8,199,10],[199,15,199,17],[209,15,209,17],[87,3,104,15],[111,3,111,15],[115,3,115,18],[136,3,136,5],[136,6,136,7],[136,11,136,12],[136,8,136,10],[136,13,136,14],[107,17,107,18],[131,3,131,5],[131,6,131,7],[119,3,129,7],[136,15,136,17],[142,19,142,20],[205,19,205,20],[194,3,194,5],[194,6,194,7],[151,17,151,18],[152,17,152,18],[153,17,153,18],[154,17,154,18],[155,17,155,18],[156,17,156,18],[157,17,157,18],[146,3,146,15],[146,17,146,18],[151,19,151,20],[152,19,152,20],[153,19,153,20]]}
[]
[]
[null,null,null,"STEP 2: BUSINESS CASE - ASSESS THE ROI POTENTIAL FOR THE DIGITAL TWIN LITE"]
[]
[]
[]
[]
[]
[null,null,null,"Date:","1st March, 2024"]
[]
[null,null,null,"Purpose:","Given the diverse purposes, project locations, and multitude of technologies inherent in digital twin creation, alongside the unquantifiable benefits they offer, it becomes challenging to accurately predict a return on investment (ROI). This model endeavors to provide indicative figures to assist in the initial decision-making process for the digital twin journey. "]
[]
[]
[null,null,null,"Disclaimer:","This model (\"ROI calculator\") prepared by AWR Lloyd Limited (\"AWR Lloyd\") is strictly confidential. Save as specifically agreed in writing by AWR Lloyd, the ROI calculator must not be copied, reproduced, distributed, or passed, in whole or in part, to any individual or entity. The ROI calculator should not be used for any other purpose without the prior written consent of AWR Lloyd.\n\nThis ROI calculator has been prepared partly on the basis of information from publicly available information and information attained from the client which is believed to be accurate and reliable. This information, which does not purport to be comprehensive, has not been independently verified by AWR Lloyd. The ROI calculator is based on various assumptions, data inputs, and methodologies. While AWR Lloyd has exercised due care and skill in developing the ROI calculator to maximize indicative accuracy, it is not immune to inherent uncertainties and limitations. It is not intended as definitive predictions to be used in isolation, but instead as tools for analysis. It is not intended to provide the primary basis of any investment decision, credit, legal, financial or other evaluation and should not be regarded as a recommendation or taken as a commitment to future outcomes.\n\nIn particular, but without prejudice to the generality of the foregoing, no representation or warranty is given as to the achievement or reasonableness of any future projections, estimates, prospects or returns contained in the ROI calculator. This ROI calculator and any presentation made in relations to this ROI calculator does not constitute an offer or invitation for the sale or purchase of securities, or any businesses or assets described in it, nor does it purport to give legal, tax, or financial advice. The findings, interpretations, conclusions, projections, and the underlying information of the ROI calculator does not necessarily reflect the views of AWR Lloyd and its partners."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Limitations:","With efforts to reduce complexity, consolidation of limited available data and metrics for end use in high-level ROI calculations are aggregated and prone to eventual subjectivity bias.\n\nCost data is inherently limited as case-studies and technology vendors do not often disclose total investment costs due to confidentiality. Categorization also includes maturity level differences, as it is based on the framework's definitions, raising potential for differences with other categorizations in the industry, resulting in indicative and high-level results. Cost data is also non-specific and inherently dependent on the use-case or technology involved, yielding varying ranges depending on the sector application and the type of asset being used (e.g., the number of sensors, type of solution, complexity of technologies, etc.). This simplificaion generalizes involved cost elements to produce a high-level and indicative result. Calculations also witness subjectivity bias as asset scale categorization is based on general size and scale, not set to a specific measurable range (e.g., 50 - 1000 sq.m.).\n\nThe benefits derived from available case-study data are aggregated and applied 'as-stated', lacking explicit clarification on lifecycle impact and whether metrics are approximates, incremental, or derived through alternate considerations. Data is also non-specific, as benefits are inherently case-specific or twin-specific outcomes that may not be applicable to all uses. In reducing complexity, calculations also consolidate all relevant metrics under common key benefit categories, and Digital Twin benefits for full-lifecycle twins are also uniformly applied throughout the entire lifecycle regardless of lifecycle phase of origin. This introduces bias for both categorization subjectivity and potential inflation of overall calculations as improvements in proportionally smaller cost components are generalized and applied to overall costs. Finally, several benefit categories are qualitative (e.g. informed decision making, visualization and monitoring) and the lack of quantification may further skew results."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Objective:","This ROI Calculator serves as a tool to determine the high-level ROI potential for the Digitl Twin Lite, and provides a starting point for the cost-benefit analysis (CBA) that should be undertaken by ADB Project Teams in accordance with ADB's Cost-Benefit Analysis for Development: A Practical Guide."]
[null,null,null,null,"Link to Cost-Benefit Analysis for Development: A Practical Guide"]
[null,null,null,"How it works:","The Digital Twin calculator is comprised of two parts: (1) Estimated cost, and (2) Estimated benefits. Project Team members will be required to complete each part in order to arrive at an ROI figure. \n\nRefer to the ADB Digital Twin Framework document to learn more on how this tool works."]
[]
[]
[]
[null,null,null,"Instructions:","1) This Canvas should be completed by ADB Project Teams, with optional participation and inputs from DMC Counterparts.\n2) Fill in all cells in yellow as best as possible, based on available information. This ROI calculator can be revisted any time necessary, in case there is new or additional information.\n3) Upon completion of all questions, an indicative return on investment will be provided in Row 210."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PART 1: ESTIMATING THE COST OF THE DIGITAL TWIN"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fill all cells in yellow"]
[]
[null,null,"The indicative Maturity Level of your Digital Twin implementation based on the assessment in Step 1: Digital Twin Strategy Canvas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!J19=\"Level 0\",\"-\",'Mapping (v3)'!J19)","v":"-"}]
[]
[null,null,null,null,null,null,null,"Figure 1: Digital Twin Maturity Levels (illustrative)"]
[]
[null,null,null,{"$error":"#VALUE!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Q1.) is auto-populated based on input provided in the Digital Twin Strategy Canvas in Step 1: Plan"]
[]
[null,null,"Q1.)","What is the scale of the infrastructure asset in which the Digital Twin will be based on?"]
[]
[null,null,null,null,null,null,null,"Figure 2: Scale of infrastructure assets (illustrative example)"]
[]
[null,null,null,{"$error":"#VALUE!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OPTIONAL: IF UNKNOWN, LEAVE BLANK"]
[null,null,"Q2.)","[OPTIONAL] What is the estimated or expected cost of the Digital Twin of your infrastructure asset? (Please input full number, in US$)"]
[]
[]
[]
[null,null,"Results:","Estimated cost of the Digital Twin implementation based on indicative Maturity Level and Scale of Asset"]
[]
[]
[]
[null,null,null,"Range* of Digital Twin cost based on selected Maturity Level and Scale of Asset"]
[]
[null,null,null,"Remarks about the range:",null,null,null,null,null,"Unit: US$M",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Minimum",{"$f":"IFERROR(AA137-(INDEX(Costs_Data!B74:E77,MATCH(G137,Costs_Data!B74:B77,0),MATCH(L137,Costs_Data!B74:E74,0))),\"-\")","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",{"$f":"IF(R108>0,\"-\",AA137)","v":"-"}]
[null,null,null,"Given that the default value for the indicative cost of the Digital Twin implementation will be the median cost, Project Team Members will also have the option to select the minimum and maximum cost for their respective Digital Twin configuration. The selected value will be used in the ROI calculation.\n\n*The minimum and maximum range is derived from the Standard Deviation of all cost for each Asset Scale under each Maturity Level.\n\nMin = Optimstic; Median = Conservative; Max = Pessimistic",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maximum",{"$f":"IFERROR(AA137+(INDEX(Costs_Data!B74:E77,MATCH(G137,Costs_Data!B74:B77,0),MATCH(L137,Costs_Data!B74:E74,0))),\"-\")","v":"-"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"[OPTIONAL] Selected cost:"]
[]
[]
[]
[]
[null,null,null,{"$f":"IF(ISBLANK(R108),Dropdown!B30,Dropdown!B35)","v":"The indicative cost of a"},null,null,{"$f":"IF(ISBLANK(R108),R57,\"-\")","v":"-"},null,{"$f":"IF(ISBLANK(R108),Dropdown!B31,Dropdown!B36)","v":"Digital Twin for a "},null,null,{"$f":"IF(ISBLANK(R108),IF(ISBLANK(R84), \"-\",R84),\"-\")","v":"-"},null,{"$f":"IF(ISBLANK(R108),Dropdown!B32,Dropdown!B37)","v":"scale asset is"},null,{"$f":"IF(ISBLANK(R108),IF(AND(ISBLANK(R108),ISBLANK(G132)), IFERROR(INDEX(Costs_Data!B9:E12,MATCH(R57,Costs_Data!B9:B12),MATCH(R84,Costs_Data!B9:E9,0))/1000,\"-\"),IFERROR(VLOOKUP(G132,Z118:AA120,2,FALSE),R108/10^6)),R108/10^6)","v":"-"},null,null,"US$ M",null,null,null,null,null,null,"Default",{"$f":"IF(ISBLANK(R108),IFERROR(INDEX(Costs_Data!B9:E12,MATCH(R57,Costs_Data!B9:B12),MATCH(R84,Costs_Data!B9:E9,0))/1000,\"-\"),\"-\")","v":"-"}]
[]
[]
[]
[]
[]
[null,null,"PART 2: ESTIMATING THE BENEFITS OF THE DIGITAL TWIN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to top"]
[]
[]
[]
[null,null,"Q3.)","What is the total estimated Capital Expenditure (CAPEX) of the infrastructure asset (in US$)?"]
[null,null,null,"Important: This is the CAPEX of the underlying infrastructure (e.g. road) not the DT Lite (e.g. Virtual Twin of the Road)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(R152:S164,\"Yes\")","v":0},"Benefits",null,"Median %"]
[null,null,"Based on your desired solution and benefits in the Canvas, your digital twin is likely to have the following benefits…",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"achieved",null,"achieved"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*for quantifiable benefits"]
[null,null,null,"Visualization and monitoring",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!F$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R152=\"Yes\",\"Qualitative\",\"-\")","v":"-"}]
[null,null,null,"Informed decision-making",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!G$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R153=\"Yes\",\"Qualitative\",\"-\")","v":"-"}]
[null,null,null,"Resource optimization and loss reduction",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!H$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R154=\"Yes\",Benefits_Data!D14,\"-\")","v":"-"}]
[null,null,null,"Productivity gains",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!I$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R155=\"Yes\",Benefits_Data!D15,\"-\")","v":"-"}]
[null,null,null,"Improve operations, inspection, maintenance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!J$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R156=\"Yes\",Benefits_Data!D16,\"-\")","v":"-"}]
[null,null,null,"Improve or optimize financial performance",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!K$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R157=\"Yes\",Benefits_Data!D17,\"-\")","v":"-"}]
[null,null,null,"Improve quality",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!L$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R158=\"Yes\",Benefits_Data!D18,\"-\")","v":"-"}]
[null,null,null,"Increase customer satisfaction",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!M$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R159=\"Yes\",Benefits_Data!D19,\"-\")","v":"-"}]
[null,null,null,"Improved knowledge and collaboration",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!N$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R160=\"Yes\",Benefits_Data!D20,\"-\")","v":"-"}]
[null,null,null,"Security and safety",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!O$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R161=\"Yes\",Benefits_Data!D21,\"-\")","v":"-"}]
[null,null,null,"Predictive intelligence",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!P$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R162=\"Yes\",\"Qualitative\",\"-\")","v":"-"}]
[null,null,null,"Risk Management and resilience",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!Q$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R163=\"Yes\",Benefits_Data!D23,\"-\")","v":"-"}]
[null,null,null,"Improved environmental sustainability",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Mapping (v3)'!R$22=FALSE,\"No\",\"Yes\")","v":"No"},null,{"$f":"IF(R164=\"Yes\",Benefits_Data!D35,\"-\")","v":"-"}]
[null,null,null," Benefits are auto-populated based on input provided in the Digital Twin Strategy Canvas in Step 1: Plan"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OPTIONAL: IF UNKNOWN, LEAVE BLANK"]
[null,null,"Q4.)","[OPTIONAL] What is the total dollar benefits estimated to be achieved by the digital twin?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"in US$"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OPTIONAL: IF UNKNOWN, LEAVE BLANK"]
[null,null,"Q5.)","[OPTIONAL] What is the total estimated carbon emissions produced over the entire project lifecycle?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tCO2e"]
[]
[]
[]
[null,null,"Results:","Estimated benefits of the Digital Twin implementation"]
[]
[]
[]
[null,null,null,"Range* of Digital Twin benefits based on selected Maturity Levels "]
[]
[null,null,null,"Remarks about the range:",null,null,null,null,null,"Unit: % cost-savings"]
[]
[null,null,null,"The default value for the indicative benefits of the Digital Twin implementation will be the median of all achieved benefits. Project Team Members also have the option to select the minimum and maximum benefit factor for their respective Digital Twin configuration. The selected value will be used in the ROI calculation. However, if the cost savings derived from the benefits are too large, the Calculator will limit achievable benefits to the a maximum reasonable value based on precedent Digital Twin implementations.\n\n*The minimum and maximum range is derived from the Standard Deviation of all percentage benefit factors for each Benefit category and each Maturity Level.\n\nMin = Optimstic; Median = Conservative; Max = Pessimistic"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"[OPTIONAL] Selected benefit:"]
[]
[]
[]
[]
[null,null,null,"The indicative cost savings for a ",null,null,null,"D&B","project with the",null,null,{"$f":"R149","v":0},"key benefit(s) is",null,null,{"$f":"IFERROR(IF(R168=FALSE,(MIN(Benefits_Data!C28,Benefits_Data!C29)/10^6),R168/10^6),\"-\")","v":"-"},null,null,"US$ M"]
[]
[]
[]
[]
[]
[null,null,"RESULTS: RETURN ON INVESTMENT POTENTIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Back to top"]
[]
[]
[]
[null,null,null,"The indicative return on investment (ROI) potential of the Digital Twin solution is…",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(P200=\"-\",\"-\",P200/P137),\"-\")","v":"-"},null,null,"x",null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(#REF!),IFERROR(INDEX(Costs_Data!B163:E166,MATCH(R155,Costs_Data!B163:B166),MATCH(#REF!,Costs_Data!B163:E163,0))/1000,\"-\"),\"-\")","v":"-"}]
[null,null,null,"Note: A DT Lite should be pursued if the ROI > 1.2x to 1.25x"]
[]
[]
[]
[null,null,null,"The indicative impact (in US$) from reductions in carbon emissions are…",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(R171>0,Benefits_Data!C42,\"-\"),\"\")","v":"-"}]
[]
[]
[]
[]
[null,null,"END: MOVE TO STEP 3 AND PRINT ALL RESULTS"]
[]
[]
[null,null,null,null,null,null,null,"PRINT ALL RESULTS"]

{"sheet":"Results","index":3,"n_rows":81,"n_cols":27,"rows_kept":81,"cut":false,"hidden":false,"merged":[[75,15,75,17],[80,3,80,12],[80,15,80,17],[71,3,71,6],[71,8,71,10],[71,15,71,17],[71,12,71,14],[67,15,67,17],[48,3,49,5],[54,3,55,5],[54,6,56,10],[57,3,59,5],[57,6,59,10],[67,3,67,5],[67,6,67,7],[67,8,67,10],[67,11,67,12],[67,13,67,14],[32,2,32,10],[32,11,32,15],[32,16,32,19],[36,3,38,5],[36,6,37,10],[37,11,46,15],[37,16,58,19],[39,3,41,5],[39,6,40,10],[42,3,43,5],[42,6,44,10],[45,3,47,5],[45,6,47,10],[48,6,50,10],[51,6,53,10],[51,3,53,5],[2,3,3,17],[11,2,11,7],[11,8,11,13],[11,14,11,19],[13,2,29,7],[13,8,29,13],[13,14,29,19]]}
[]
[]
[null,null,null,"RESULTS: SUMMARIZED OUTPUTS FROM STEP 1: CONCEPTUALIZE, AND STEP 2: BUSINESS CASE"]
[]
[]
[]
[]
[null,null,"STEP 1: CONCEPTUALIZE - DIGITAL TWIN STRATEGY CANVAS"]
[]
[]
[]
[null,null,"1.) PROJECT SUMMARY",null,null,null,null,null,"2.) PROJECT VISION & STRATEGY",null,null,null,null,null,"3.) PROJECT OUTPUT AND OUTCOMES"]
[]
[null,null,{"$f":"IF('Digital Twin Strategy Canvas'!E100=0,\"[Complete Canvas inputs below]\",'Digital Twin Strategy Canvas'!E100)","v":"[Complete Canvas inputs below]"},null,null,null,null,null,{"$f":"IF('Digital Twin Strategy Canvas'!E130=0,\"[Complete Canvas inputs below]\",'Digital Twin Strategy Canvas'!E130)","v":"[Complete Canvas inputs below]"},null,null,null,null,null,{"$f":"IF('Digital Twin Strategy Canvas'!E161=0,\"[Complete Canvas inputs below]\",'Digital Twin Strategy Canvas'!E161)","v":"[Complete Canvas inputs below]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"4.) DESIRED SOLUTION & INDICATIVE BENEFITS",null,null,null,null,null,null,null,null,"5.) INDICATIVE MATURITY LEVEL",null,null,null,null,"6.) PAST SUCCESS STORIES"]
[]
[null,null,null,"DESIRED SOLUTION(S)",null,null,"AND INDICATIVE BENEFITS",null,null,null,null,"Your desired twin is…",null,null,null,null,"Some examples of…"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(TEXT('Digital Twin Strategy Canvas'!I205,\"0\"),\"Complete Canvas inputs below\")","v":"-"},null,null,null,null,{"$f":"IFERROR(TEXT('Digital Twin Strategy Canvas'!I205,\"0\"),\"Complete Canvas inputs below\")","v":"-"}]
[null,null,{"$f":"IF('Digital Twin Strategy Canvas'!D175=0,\"-\",'Digital Twin Strategy Canvas'!D175)","v":"-"},"Stress test the potential infrastructure against current \nbuilt-environment",null,null,"Improved investment decision making; feasibility assessment "]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Digital Twin Strategy Canvas'!L52=\"Level 1: Descriptive Twin\",'Digital Twin Strategy Canvas'!J210,IF('Digital Twin Strategy Canvas'!L52=\"Level 2: Informative Twin\",'Digital Twin Strategy Canvas'!J231,IF('Digital Twin Strategy Canvas'!L52=\"Level 3: Predictive Twin\",'Digital Twin Strategy Canvas'!J251,\"[Complete Canvas inputs below]\")))","v":"[Complete Canvas inputs below]"},null,null,null,null,{"$f":"IF('Digital Twin Strategy Canvas'!Q52=\"Level 1: Descriptive Twin\",_xlfn.ARRAYTOTEXT('Digital Twin Strategy Canvas'!J283:J288),IF('Digital Twin Strategy Canvas'!Q52=\"Level 2: Informative Twin\",_xlfn.ARRAYTOTEXT('Digital Twin Strategy Canvas'!J291:J296),IF('Digital Twin Strategy Canvas'!Q52=\"Level 3: Predictive Twin\",_xlfn.ARRAYTOTEXT('Digital Twin Strategy Canvas'!J299:J308),\"[Complete Canvas inputs below]\")))","v":"[Complete Canvas inputs below]"}]
[]
[null,null,{"$f":"IF('Digital Twin Strategy Canvas'!D178=0,\"-\",'Digital Twin Strategy Canvas'!D178)","v":"-"},"Stress test the potential infra. against future conditions and environments (e.g. climate change, physical risks)",null,null,"Improved investment decision making; feasibility assessment; climate-resilient infrastructure"]
[]
[]
[null,null,{"$f":"IF('Digital Twin Strategy Canvas'!D181=0,\"-\",'Digital Twin Strategy Canvas'!D181)","v":"-"},"Evaluate and optimize design\nto meet specific outcome(s)",null,null,"Alternative infrastructure designs; reduce resource consumption; improved sustainability; reduction in GHG emissions; improve service quality and satisfaction"]
[]
[]
[null,null,{"$f":"IF('Digital Twin Strategy Canvas'!D184=0,\"-\",'Digital Twin Strategy Canvas'!D184)","v":"-"},"Urban planning tool to conceptualize different urban designs and analyze various scenarios",null,null,"Improved investment decision making; optimized land use and resource usage; improve service quality and satisfaction"]
[]
[]
[null,null,{"$f":"IF('Digital Twin Strategy Canvas'!D187=0,\"-\",'Digital Twin Strategy Canvas'!D187)","v":"-"},"Collaborate, visualize or experience virtually",null,null,"Improve design process; informed and early stakeholder feedback; reduce lead time; greater access to information"]
[]
[]
[null,null,{"$f":"IF('Digital Twin Strategy Canvas'!D190=0,\"-\",'Digital Twin Strategy Canvas'!D190)","v":"-"},"Immerse and experience visually",null,null,"Boost marketing potential for the Digital Twin; Enhance stakeholder adoption and buy-in"]
[]
[]
[null,null,{"$f":"IF('Digital Twin Strategy Canvas'!D193=0,\"-\",'Digital Twin Strategy Canvas'!D193)","v":"-"},"Conduct immersive training",null,null,"Improve workforce capacity; improve workplace efficiency; reduce operational lead times; improve workplace safety"]
[]
[]
[null,null,{"$f":"IF('Digital Twin Strategy Canvas'!D196=0,\"-\",'Digital Twin Strategy Canvas'!D196)","v":"-"},"Monitoring the construction and building of the infrastructure",null,null,"Remote monitoring; real-time or near real-time decision making; reduce operational lead times; prevent construction delays"]
[]
[]
[]
[]
[]
[null,null,"STEP 2: BUSINESS CASE - INDICATIVE ROI POTENTIAL"]
[]
[]
[]
[null,null,null,{"$f":"IF(ISBLANK('ROI Calculator'!R108),Dropdown!B30,Dropdown!B35)","v":"The indicative cost of a"},null,null,{"$f":"IF(ISBLANK('ROI Calculator'!R108),'ROI Calculator'!R57,\"-\")","v":"-"},null,{"$f":"IF(ISBLANK('ROI Calculator'!R108),Dropdown!B31,Dropdown!B36)","v":"Digital Twin for a "},null,null,{"$f":"IF(ISBLANK('ROI Calculator'!R108),IF(ISBLANK('ROI Calculator'!R84), \"-\",'ROI Calculator'!R84),\"-\")","v":"-"},null,{"$f":"IF(ISBLANK('ROI Calculator'!R108),Dropdown!B32,Dropdown!B37)","v":"scale asset is"},null,{"$f":"IF(ISBLANK('ROI Calculator'!R108),IF(AND(ISBLANK('ROI Calculator'!R108),ISBLANK('ROI Calculator'!G132)), IFERROR(INDEX(Costs_Data!B9:E12,MATCH('ROI Calculator'!R57,Costs_Data!B9:B12),MATCH('ROI Calculator'!R84,Costs_Data!B9:E9,0))/1000,\"-\"),IFERROR(VLOOKUP('ROI Calculator'!G132,'ROI Calculator'!Z118:AA120,2,FALSE),'ROI Calculator'!R108/10^6)),'ROI Calculator'!R108/10^6)","v":"-"},null,null,"US$ M",null,null,null,null,null,null,"Default",{"$f":"IF(ISBLANK(R35),IFERROR(INDEX(Costs_Data!#REF!,MATCH(#REF!,Costs_Data!#REF!),MATCH(R11,Costs_Data!#REF!,0))/1000,\"-\"),\"-\")","v":"-"}]
[]
[]
[]
[null,null,null,"The indicative cost savings for a ",null,null,null,"D&B","project with the",null,null,{"$f":"'ROI Calculator'!R149","v":0},"key benefit(s) is",null,null,{"$f":"IFERROR(MIN(Benefits_Data!C28,Benefits_Data!C29)/10^6,\"-\")","v":"-"},null,null,"US$ M"]
[]
[]
[]
[null,null,null,"The indicative return on investment (ROI) potential of the Digital Twin solution is…",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF('ROI Calculator'!P200=\"-\",\"-\",'ROI Calculator'!P200/'ROI Calculator'!P137),\"-\")","v":"-"},null,null,"x"]
[null,null,null,"Note: A DT Lite should be pursued if the ROI > 1.2x"]
[]
[]
[]
[null,null,null,"The indicative impact (in US$) from reductions in carbon emissions are…",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF('ROI Calculator'!R171>0,Benefits_Data!C42,\"-\"),\"\")","v":"-"}]

{"sheet":"Use-Cases","index":4,"n_rows":416,"n_cols":13,"rows_kept":416,"cut":false,"hidden":false,"merged":[[299,0,299,1],[386,0,386,1],[0,0,2,0],[4,0,4,1],[155,0,155,1]]}
["Return"]
[null,null,null,"Sectors:","Water & Urban Development",null,null,null,"Transport",null,"Energy",null,"Others"]
[]
[]
["Water & Urban Dev."]
[null,"Level 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Level 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Level 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Transport"]
[null,"Level 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Level 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Level 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Energy"]
[null,"Level 1"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Level 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Level 3"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Others"]
[null,"Level 2"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Level 3"]

{"sheet":"Mapping (v3)","index":5,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["BENEFIT AND MATURITY MAPPING PER SOLUTION"]
[]
["Status","No.","Desired Solution","Maturity","Maturity Check","Visualization and Monitoring","Informed Decision Making","Resource optimization and loss reduction","Productivity gains","Improve O&M","Improve or optimize financial performance","Improve quality","Increase customer satisfaction","Improved knowledge and collaboration","Security and safety","Predictive Intelligence","Risk management and resilience","Improved environmental sustainability"]
[{"$f":"'Digital Twin Strategy Canvas'!D175","v":0},1,"Stress test the potential infrastructure against current built environment",2,{"$f":"IF(A4=\"Yes\",D4,\"-\")","v":"-"},{"$f":"IF($A4=\"Yes\", TRUE, FALSE)","v":false},{"$f":"IF($A4=\"Yes\", TRUE, FALSE)","v":false},"-","-","-","-","-","-",{"$f":"IF($A4=\"Yes\", TRUE, FALSE)","v":false},"-","-","-","-",{"$f":"COUNTIF(F4:R4,TRUE)","v":0}]
[{"$f":"'Digital Twin Strategy Canvas'!D178","v":0},2,"Stress test against future conditions and environments (e.g. climate change)",3,{"$f":"IF(A5=\"Yes\",D5,\"-\")","v":"-"},"-",{"$f":"IF($A5=\"Yes\", TRUE, FALSE)","v":false},"-","-","-","-",null,"-","-",false,false,false,{"$f":"IF($A5=\"Yes\", TRUE, FALSE)","v":false},{"$f":"COUNTIF(F5:R5,TRUE)","v":0}]
[{"$f":"'Digital Twin Strategy Canvas'!D181","v":0},3,"Evaluate and optimize design to meet specific outcomes(s)",3,"-",{"$f":"IF($A6=\"Yes\", TRUE, FALSE)","v":false},"-",false,false,"-",false,false,"-","-","-","-","-",false,0]
[{"$f":"'Digital Twin Strategy Canvas'!D184","v":0},4,"Urban planning tool to conceptualize different urban designs and analyze various scenarios",2,"-",false,false,false,"-","-",false,false,"-","-","-","-","-",false,0]
[{"$f":"'Digital Twin Strategy Canvas'!D187","v":0},5,"Collaborate, visualize, or experience virtually",1,"-",false,"-","-",false,"-",false,"-",false,false,"-","-","-","-",0]
[{"$f":"'Digital Twin Strategy Canvas'!D190","v":0},6,"Immerse and experience virtually",1,"-",false,false,"-","-","-","-","-",false,false,"-","-","-","-",0]
[{"$f":"'Digital Twin Strategy Canvas'!D193","v":0},7,"Conduct immersive training",1,{"$f":"IF(A10=\"Yes\",D10,\"-\")","v":"-"},{"$f":"IF($A10=\"Yes\", TRUE, FALSE)","v":false},"-","-",false,"-","-","-","-",false,false,"-","-","-",0]
[{"$f":"'Digital Twin Strategy Canvas'!D196","v":0},8,"Monitor the construction and building of the infrastructure",1,"-",false,false,false,false,"-","-","-","-","-","-","-",false,"-",0]
[]
[null,null,"Maturity Choice",null,"Level","Name","Append 1","Append 2","Concatenate","for ROI"]
[null,null,null,null,1,"Descriptive Twin"]
[null,null,null,null,2,"Informative Twin"]
[null,null,null,null,3,"Predictive Twin"]
[null,null,null,null,4,"Prescriptive Twin"]
[null,null,null,null,5,"Autonomous Twin"]
[null,null,"FINAL MATURITY",null,{"$f":"MAX(E4:E11)","v":0},{"$f":"VLOOKUP(E19,E14:F18,2)","v":{"$error":"#N/A"}},"Level ",": ",{"$f":"_xlfn.CONCAT(G19,E19,H19,F19)","v":{"$error":"#N/A"}},{"$f":"_xlfn.CONCAT(G19,E19)","v":"Level 0"}]
[]
[null,null,"Benefit Logic Check",null,"Count","Visualization and Monitoring","Informed Decision Making","Resource optimization and loss reduction","Productivity gains","Improve O&M","Improve or optimize financial performance","Improve quality","Increase customer satisfaction","Improved knowledge and collaboration","Security and safety","Predictive Intelligence","Risk management and resilience","Improved environmental sustainability"]
[null,null,"FINAL BENEFITS",null,null,{"$f":"OR(F4:F11)","v":false},{"$f":"OR(G4:G11)","v":false},false,false,{"$f":"IFERROR(OR(J4:J11),FALSE)","v":false},false,false,false,false,false,false,false,false]

{"sheet":"Costs_Data","index":6,"n_rows":77,"n_cols":14,"rows_kept":77,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"MULTIPLIER BETWEEN ASSET SCALES",null,null,"Asset Size (Unit: '000)"]
[null,"Maturity Level / Project Name","Small","Medium","Large",null,"Highlighted Text","Used in the calculation of differential multiplier"]
[null,"Median cost across all Maturity Levels",{"$f":"MEDIAN(C18:C32,C53:C54)","v":1000},{"$f":"MEDIAN(D19:D31,D40:D45,D55:D64)","v":5984.5},{"$f":"MEDIAN(E28:E35,E57:E66)","v":13750},null,"Blue Text","Derived from multipliers to use as final number or for further calculations"]
[null,"DIFFERENTIAL MULTIPLIER (x)",{"$f":"C5/D5","v":0.16709833737154314},"-",{"$f":"E5/D5","v":2.2976021388587182},null,"Red Text","Not enough data to derive median cost / Outlier data"]
[null,null,null,null,null,null,"Black Text","Used in the calculation of the median cost"]
[null,"SUMMARY",null,null,"Asset Size (Unit: '000)"]
[null,"Maturity Level / Project Name","Small","Medium","Large"]
[null,"Level 1",{"$f":"C36","v":650},{"$f":"D36","v":1004},{"$f":"E36","v":2370}]
[null,"Level 2",{"$f":"C48","v":1052.7195254407218},{"$f":"D48","v":6300},{"$f":"E48","v":14474.893474809925}]
[null,"Level 3",{"$f":"C68","v":5638.5},{"$f":"D68","v":10000},{"$f":"E68","v":25000}]
[]
[null,"HIGH-LEVEL COST OF A DIGITAL TWIN BY MATURITY LEVEL AND ASSET SCALE",null,null,"Asset Size (Unit: '000)"]
[null,"Maturity Level / Project Name","Single","Multiple","City",null,null,null,null,null,null,null,{"$f":"160/2","v":80}]
[null,"Level 1"]
[null,"Gulf Power (Operating division of NextEra Energy) LiDAR scan",50]
[null,"Digital Twin of Sello Building Block",54.5]
[null,"Digital Twin of Sirnach Municipality",null,54.5]
[null,"Digital Twin of the municipality of Fällanden, Switzerland",null,54.5]
[null,"Yorkshire Geospatial Digital Twin",null,null,58]
[null,"Collins Engineers Uses Digital Inspection to Restore Iconic Pedestrian Bridge in Minneapolis",75]
[null,"Pointerra’s Utility Suite (comprising elements of the entire Pointerra3D Core, Analytics & Answers product stack) across selected PG&E business units",null,700]
[null,"Digital Twin of a Railway - Cross River Rail",300]
[null,"Building Development A (Anonymized project from Aurecon)",650]
[null,"Phase II - Digital Twin-based Diagnostics for Nuclear Auxiliary Systems project under the Department of Energy's Advanced Research Project Agency",1000]
[null,"Building Development B (Anonymized project from Aurecon)",1300]
[null,"Digital Twin of Bradford - Virtual Bradford",null,null,643]
[null,"Orlando Regional Digital Twin (ORD)",null,null,1000]
[null,"Infrastructure Mapping Application (IMA) - London's Public Infrastructure",null,1004]
[null,"Virtual Scan of LNG facilities",null,1300]
[null,"Digital Spacecraft Twins - U.S. Space Force",1500]
[null,"LiDAR scan of Entergy utility coverage service areas",null,null,2370]
[null,"Singapore Land Authority Nationwide Digital Twin of the Singapore Public Road System",null,null,3000,null,null,null,null,null,null,"Median","Min","Max"]
[null,"Digital Twin of Rennes Metropole City ",null,null,3300,null,null,null,null,null,null,{"$f":"MEDIAN($C$18:$C$32,$D$23:$D$31,$E$28:$E$35)","v":1000},{"$f":"MIN($C$18:$C$32,$D$23:$D$31,$E$28:$E$35)","v":54.5},{"$f":"MAX($C$18:$C$32,$D$23:$D$31,$E$28:$E$35)","v":3300}]
[null,"MEDIAN",{"$f":"MEDIAN(C18:C32)","v":650},{"$f":"MEDIAN(D23:D35)","v":1004},{"$f":"MEDIAN(E28:E35)","v":2370}]
[]
[null,"Level 2"]
[null,"EEC New City Thailand - Business Center and Liveable Smart City",null,1]
[null,"Redfern Station Signal Sighting",null,151,{"$f":"D40*$E$6","v":346.93792296766645}]
[null,"Digital Twin of floating offshore Wind Farm (WindFloatAtlantic Project)",null,3600,{"$f":"D41*$E$6","v":8271.3676998913852},null,null,null,null," "]
[null,"Digital Twin of a semiconductor manufacturing plant",7500]
[null,"Univeristy of Central Florida (UCF) Microelectric Design and Production Digital Twin",8800]
[null,"Digital Twin of 3D printed metal parts for the U.S. Navy",null,9000,{"$f":"D44*$E$6","v":20678.419249728464}]
[null,"Siemens Digital Twin for a wastewater treatment plant (Severn Trent)",null,12500,{"$f":"D45*$E$6","v":28720.026735733976}]
[null,"WSP Australia Pty Ltd. - Southern Program Alliance",null,null,37400,null,null,null,null,null,null,"Median","Min","Max"]
[null,"London's King's Cross Railway Station",null,null,317000,null,null,null,null,null,null,{"$f":"MEDIAN($D$41:$D$46)","v":9000},{"$f":"MIN($D$40:$D$46)","v":151},{"$f":"MAX($D$41:$D$46)","v":12500}]
[null,"MEDIAN",{"$f":"D48*$C$6","v":1052.7195254407218},{"$f":"MEDIAN(D40:D45)","v":6300},{"$f":"D48*$E$6","v":14474.893474809925}]
[]
[null,"Level 3"]
[null,"Cauayan City Digital Twin ",92]
[null,"Digital Twin of St. Pancras International Station",94]
[null,"Digital Twin of Wind Farm (5) - KEPCO E&C",4780]
[null,"Digital Twin Technology for Energy, Aerospace, and Industrial assets",6497]
[null,"Digital Twin of a Forest - Pulse of the Forest",null,8369]
[null,"Digital Twin-empowered Landslide Emergency Risk Management",null,9612.85]
[null,"Unified Complex Monitoring and Forecasting System (UCMFS)",null,null,9500]
[null,"Predictive Digital Twin of critical assets in the energy sector",null,10000]
[null,"Digital Twin of Electricity Network, United Kingdom",null,12500]
[null,"Digital Twin of the Ocean (DTO)",null,null,18000]
[null,"Digital Twin Victoria",null,null,24420]
[null,"New South Wales (NSW) Spatial Digital Twin",null,null,25000]
[null,"Digital Twin of the Space Environment",null,null,25200]
[null,"Digital Twin for complex enterprise networks",null,50000]
[null,"Virtual Singapore",null,null,73000]
[null,"Digital Twin of a City - Incheon Metropolitan City",null,null,100000,null,null,null,null,null,null,"Median","Min","Max"]
[null,"Digital Roads England",null,null,424557,null,null,null,null,null,null,{"$f":"MEDIAN($C$53:$C$54,$D$55:$D$64,$E$57:$E$66)","v":15250},{"$f":"MIN($C$53:$C$54,$D$55:$D$64,$E$57:$E$66)","v":4780},{"$f":"MAX($C$53:$C$54,$D$55:$D$64,$E$57:$E$66)","v":100000}]
[null,"MEDIAN",{"$f":"MEDIAN(C53:C54)","v":5638.5},{"$f":"MEDIAN(D55:D64)","v":10000},{"$f":"MEDIAN(E57:E66)","v":25000}]
[]
[null,null,"Small","Medium","Large"]
[null,"MIN",{"$f":"MIN(C17:C32,C53:C54)","v":50},{"$f":"MIN(D23:D31,D41:D46,D55:D64)","v":700},{"$f":"MIN(E28:E35,E57:E66)","v":643}]
[null,"MAX",{"$f":"MAX(C17:C32,C53:C54)","v":6497},{"$f":"MAX(D23:D31,D40:D46,D55:D64)","v":50000},{"$f":"MAX(E28:E35,E57:E66)","v":100000}]
[]
[null,"STDEV","Small","Medium","Large"]
[null,"Level 1",{"$f":"_xlfn.STDEV.P(C18:C32)/10^3","v":0.54244620724556836},{"$f":"_xlfn.STDEV.P(D19:D31)/10^3","v":0.5011591962640215},{"$f":"_xlfn.STDEV.P(E28:E35)/10^3","v":1.0628974738891801}]
[null,"Level 2",{"$f":"_xlfn.STDEV.P(C42:C43)/10^3","v":0.65},{"$f":"_xlfn.STDEV.P(D40:D45)/10^3","v":4.765226929276297},{"$f":"_xlfn.STDEV.S(E44:E46)/10^3","v":8.3628209914996567}]
[null,"Level 3",{"$f":"_xlfn.STDEV.P(C51:C54)/10^3","v":2.8384245960567633},{"$f":"_xlfn.STDEV.P(D55:D59)/10^3","v":1.5001667629696231},{"$f":"_xlfn.STDEV.P(E57:E63)/10^3","v":6.0815708497065133}]

{"sheet":"Benefits_Data","index":7,"n_rows":256,"n_cols":40,"rows_kept":256,"cut":false,"hidden":true,"merged":[[1,0,2,6]]}
["BENEFIT CALCULATION"]
["This tab provides an overview of primary benefits realized from Digital Twins in terms of cost savings. Benefits are broken down into two main categories of lifecycle phases (D&B, O&M) as well as additional benefits throughout the entire project (emissions savings, etc.).",null,null,null,null,null,null,null,null,"CALCULATION DATA"]
[]
[null,"Question","Input","Recommended Metric",null,null,null,null,null,"Legend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Processed Data (10%<x<60%)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Note: Paste metric data from use-case library (pivot table) as values, then delete all values above a 60%"]
[null,"Scenario",null,null,null,null,null,null,null,"Conservative","Min",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Maturity","Visual","Decision","Resource","Productivity","Maintenance","Financials","Quality","Customer","Knowledge","Security","Prediction","Risk","Environment","Others"]
[null,"Phase","D&B",null,null,null,null,null,null,"Moderate","Q1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Maturity Level",{"$f":"'Mapping (v3)'!J19","v":"Level 0"},null,null,null,null,null,null,"Optimistic","Median",null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Benefit Cap","Max Cleaned",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Design and Build (D&B)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"What is the total estimated capital expenditure (CAPEX) for the infrastructure project?",{"$f":"'ROI Calculator'!R147:S147","v":0},0,null,null,null,null,null,"Transformed Data",null,null,null,null,null,null,null,null,null,null,"Automation (tentative)",null,null,null,null,2]
[null,"Visualization and monitoring",{"$f":"IF('ROI Calculator'!R152=\"Yes\",D12)","v":false},{"$f":"INDEX($K$15:$M$27,MATCH($B12,$J$15:$J$27,0),MATCH($C$7,$K$14:$M$14,0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,"Informed decision-making",{"$f":"IF('ROI Calculator'!R153=\"Yes\",D13)","v":false},"-",null,null,null,null,null,"DATA SUMMARY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Resource optimization and loss reduction",{"$f":"IF('ROI Calculator'!R154=\"Yes\",D14)","v":false},{"$f":"INDEX($K$15:$M$27,MATCH($B14,$J$15:$J$27,0),MATCH($C$7,$K$14:$M$14,0))","v":{"$error":"#N/A"}},null,"Benefit Range",null,null,null,"Benefit","Level 1","Level 2","Level 3",null,null,"Benefits quantified in US$M","Level 1","Level 2","Level 3",null,"Formula to automate from pasted data set:",null,null,null,null,3]
[null,"Productivity gains",{"$f":"IF('ROI Calculator'!R155=\"Yes\",D15)","v":false},{"$f":"INDEX($K$15:$M$27,MATCH($B15,$J$15:$J$27,0),MATCH($C$7,$K$14:$M$14,0))","v":{"$error":"#N/A"}},null,"Minimum",{"$f":"IFERROR($G$16-(INDEX(Benefits_Data!$K$15:$M$28,MATCH(\"Standard deviation\",Benefits_Data!$J$15:$J$28,0),MATCH($C$7,Benefits_Data!$K$14:$M$14,0))),\"-\")","v":"-"},null,null,"Visualization and monitoring","-","-","-",null,null,1,3600000,2300000,3000000,null,"Need to manually delete outliers and apply multipliers",null,null,null,null,3]
[null,"Improve operations, inspection, maintenance",{"$f":"IF('ROI Calculator'!R156=\"Yes\",D16)","v":false},{"$f":"INDEX($K$15:$M$27,MATCH($B16,$J$15:$J$27,0),MATCH($C$7,$K$14:$M$14,0))","v":{"$error":"#N/A"}},null,"Median",{"$f":"MEDIAN(C12:C23)","v":{"$error":"#NUM!"}},null,null,"Informed decision-making",0.47,0.57254545454545447,0.8102356902356902,null,null,2,null,16000000,390000,null,null,null,null,null,null,2]
[null,"Improve or optimize financial performance",{"$f":"IF('ROI Calculator'!R157=\"Yes\",D17)","v":false},{"$f":"INDEX($K$15:$M$27,MATCH($B17,$J$15:$J$27,0),MATCH($C$7,$K$14:$M$14,0))","v":{"$error":"#N/A"}},null,"Maximum",{"$f":"IFERROR($G$16+(INDEX(Benefits_Data!$K$15:$M$28,MATCH(\"Standard deviation\",Benefits_Data!$J$15:$J$28,0),MATCH($C$7,Benefits_Data!$K$14:$M$14,0))),\"-\")","v":"-"},null,null,"Resource optimization and loss reduction",0.17238805970149257,0.21,0.32500000000000001,null,null,3,null,8400000,100000000,null,"Formula","Data","Check",null,null,3,null,null,null,0.5,null,0.33,null,0.4,null,0.37,null,null,0.5]
[null,"Improve quality",{"$f":"IF('ROI Calculator'!R158=\"Yes\",D18)","v":false},{"$f":"INDEX($K$15:$M$27,MATCH($B18,$J$15:$J$27,0),MATCH($C$7,$K$14:$M$14,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"Productivity gains",0.27500000000000002,0.33499999999999996,0.5,null,null,4,null,7600000,840000,null,{"$f":"MEDIAN(IF((Z6:Z1000=2)*(AD6:AD1000<>\"\"),AD6:AD1000))","v":0.33499999999999996},0.13,{"$f":"MEDIAN(V18:V31)","v":0.33499999999999996},null,null,1]
[null,"Increase customer satisfaction",{"$f":"IF('ROI Calculator'!R159=\"Yes\",D19)","v":false},{"$f":"INDEX($K$15:$M$27,MATCH($B19,$J$15:$J$27,0),MATCH($C$7,$K$14:$M$14,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"Improve operations, inspection, maintenance",0.22500000000000001,0.35,0.51786069651741296,null,null,5,null,1300000,99000000,null,null,0.5,null,null,null,2]
[null,"Improved knowledge and collaboration",{"$f":"IF('ROI Calculator'!R160=\"Yes\",D20)","v":false},{"$f":"INDEX($K$15:$M$27,MATCH($B20,$J$15:$J$27,0),MATCH($C$7,$K$14:$M$14,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"Improve or optimize financial performance",0.20250000000000001,0.22500000000000001,0.33,null,null,6,null,1200000,1114000000,null,null,0.37,null,null,null,2]
[null,"Security and safety",{"$f":"IF('ROI Calculator'!R161=\"Yes\",D21)","v":false},{"$f":"INDEX($K$15:$M$27,MATCH($B21,$J$15:$J$27,0),MATCH($C$7,$K$14:$M$14,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"Improve quality",0.12313432835820898,0.15,0.22194029850746269,null,null,7,null,400000,1000000,null,null,null,null,null,null,2]
[null,"Predictive intelligence",{"$f":"IF('ROI Calculator'!R162=\"Yes\",D22)","v":false},"-",null,null,null,null,null,"Increase customer satisfaction",0.15372070312500002,0.17911590909090908,0.26500000000000001,null,null,8,null,8300000,3800000,null,null,0.3,null,null,null,3]
[null,"Risk management and resilience",{"$f":"IF('ROI Calculator'!R163=\"Yes\",D23)","v":false},{"$f":"INDEX($K$15:$M$27,MATCH($B23,$J$15:$J$27,0),MATCH($C$7,$K$14:$M$14,0))","v":{"$error":"#N/A"}},null,null,null,null,null,"Improved knowledge and collaboration",0.32835820895522394,0.4,0.59184079601990047,null,null,9,null,100000,620000000,null,null,0.17499999999999999,null,null,null,1]
[null,null,null,null,null,"Other Options",null,null,null,"Security and safety",0.21462890625,0.25008636363636361,0.37,null,null,10,null,2000000,3200000,null,null,0.3,null,null,null,3]
[null,null,"Median",null,null,"Mean","Quartile 1","Min",null,"Predictive intelligence",0.39,0.47509090909090906,0.67232323232323232,null,null,11,null,2600000,null,null,null,0.375,null,null,null,3]
[null,"D&B Benefit Proportion",{"$f":"IF(ISBLANK('ROI Calculator'!G195:H195)=TRUE,G16,VLOOKUP('ROI Calculator'!G195:H195,F15:G17,2,FALSE))","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},null,{"$f":"AVERAGE(C12:C23)","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.QUARTILE.EXC(C12:C23,1)","v":{"$error":"#NUM!"}},{"$f":"MIN(C12:C23)","v":0},null,"Risk management and resilience",0.15,0.18272727272727271,0.25858585858585859,null,null,12,null,400000000,null,null,null,0.2,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Improved environmental sustainability",0.24626865671641796,0.3,0.4,null,null,13,null,2500000,null,null,null,0.375,null,null,null,3]
[null,"Total D&B Benefits Gained",{"$f":"IFERROR(C11*C26,0)","v":0},null,null,{"$f":"IFERROR(C11*F26,0)","v":0},{"$f":"IFERROR(C11*G26,0)","v":0},{"$f":"IFERROR(C11*H26,0)","v":0},null,"Standard deviation",{"$f":"_xlfn.STDEV.S(K16:K27)","v":0.10448985092653101},{"$f":"_xlfn.STDEV.S(L16:L27)","v":0.12992033680936504},{"$f":"_xlfn.STDEV.S(M16:M27)","v":0.18257075795880415},null,null,14,null,1500000,null,null,null,0.5,null,null,null,1]
[null,"Total D&B Benefits Maximum",{"$f":"INDEX($Q$15:$S$34,MATCH($C$8,$P$15:$P$34,0),MATCH($C$7,$Q$14:$S$14,0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,15,null,50000,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median",{"$f":"MEDIAN(Q15:Q29)","v":3600000},{"$f":"MEDIAN(R15:R29)","v":2300000},{"$f":"MEDIAN(S15:S29)","v":3500000},null,null,0.25,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mean",{"$f":"AVERAGE(Q15:Q29)","v":3600000},{"$f":"AVERAGE(R15:R29)","v":30283333.333333332},194523000,null,null,0.4,null,null,null,2]
[null,"Environmental Sustainability (Emissions)",null,null,null,null,null,null,null,null,null,null,null,null,null,"Median Cleaned",{"$f":"MEDIAN(Q15:Q29)","v":3600000},{"$f":"MEDIAN(R22,R16:R18)","v":8350000},{"$f":"MEDIAN(S19,S17)","v":99500000},null,null,null,null,null,null,2]
[null,"What is the total estimated carbon emissions produced over the entire project lifecycle?",{"$f":"'ROI Calculator'!R171:S171","v":0},0,"in tCO2e",null,null,null,null,null,null,null,null,null,null,"Mean Cleaned",{"$f":"AVERAGE(Q16:Q30)","v":3600000},{"$f":"AVERAGE(R22,R16:R18)","v":10075000},{"$f":"AVERAGE(S19,S17)","v":99500000},null,null,null,null,null,null,3]
[null,"Social cost of carbon",40,null,"per tCO2e",null,null,null,null,null,null,null,null,null,null,"Max Cleaned",{"$f":"MAX(Q15:Q29)","v":3600000},{"$f":"MAX(R16:R18,R22)","v":16000000},{"$f":"MAX(S17,S19)","v":100000000},null,null,null,null,null,null,2]
[null,"Improved environmental sustainability",{"$f":"IF('ROI Calculator'!R164=\"Yes\",D35)","v":false},{"$f":"INDEX(K15:M27,MATCH(B35,J15:J27,0),MATCH(C7,K14:M14,0))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,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]
[null,null,null,null,null,null,null,null,null,"Manual Benefit Calculations (Multipliers and Outliers)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"MULTIPLIER BETWEEN MATURITY LEVELS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,"Emissions saved",{"$f":"C33*C35","v":0},"in tCO2e",null,null,null,null,null,"Maturity Level / Project Name","Small > Medium","Small < Medium","Medium > Large","Medium < Large","Small > Large",null,"Highlighted Text","Calculated through multipliers",null,null,null,null,null,null,null,2]
[null,"Initial total cost of carbon",{"$f":"C33*C34","v":0},null,null,null,null,null,null,"Median benefit across all Maturity Levels",{"$f":"MEDIAN(K108,K113,K121,K144,K148)","v":0.22500000000000001},{"$f":"MEDIAN(L91,L108,L113,L121,L125,L134,L157)","v":0.3},{"$f":"MEDIAN(N91,N108,N121,N130,N140,N157)","v":{"$error":"#NUM!"}},{"$f":"MEDIAN(M91,M108,M121,M130,M140,M157)","v":0.35},null,null,"Red Text","Not enough data to derive median cost / Outlier data",null,null,null,null,null,null,null,3,null,null,null,null,null,0.35]
[null,null,null,null,null,null,null,null,null,"DIFFERENTIAL MULTIPLIER (ALL LEVELS)","-",{"$f":"L40/K40","v":1.3333333333333333},{"$f":"M40/N40","v":{"$error":"#NUM!"}},{"$f":"N40/L40","v":1.1666666666666667},null,null,"Black Text","Used in the calculation of the median cost",null,null,null,null,null,null,null,3]
[null,"Emissions cost reduced",{"$f":"C39*C34","v":0},null,null,null,null,null,null,"Visualization and monitoring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Informed decision-making",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,0.15]
[null,null,null,null,null,null,null,null,null,"Resource optimization and loss reduction",null,null,{"$f":"M91/L91","v":1.5476190476190477},{"$f":"L91/M91","v":0.64615384615384608},null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Productivity gains",{"$f":"L108/K108","v":1.218181818181818},{"$f":"K108/L108","v":0.82089552238805985},{"$f":"M108/L108","v":1.4925373134328359},{"$f":"L108/M108","v":0.66999999999999993},{"$f":"M108/K108","v":1.8181818181818181},null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Improve operations, inspection, maintenance",{"$f":"L113/K113","v":1.5555555555555554},{"$f":"K113/L113","v":0.6428571428571429},null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Improve or optimize financial performance",{"$f":"L121/K121","v":1.1111111111111112},{"$f":"K121/L121","v":0.9},{"$f":"M121/L121","v":1.4666666666666668},{"$f":"L121/M121","v":0.68181818181818177},{"$f":"M121/K121","v":1.6296296296296295},null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"Improve quality",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Increase customer satisfaction",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,0.3,null,null,null,null,null,0.6]
[null,null,null,null,null,null,null,null,null,"Improved knowledge and collaboration",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"Security and safety",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"Predictive intelligence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,0.16999999999999998,null,null,null,null,null,null,null,null,null,0.17]
[null,null,null,null,null,null,null,null,null,"Risk management and resilience",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Improved environmental sustainability",null,null,{"$f":"M157/L157","v":1.3333333333333335},{"$f":"L157/M157","v":0.74999999999999989},null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"MEDIAN(K42:K54)","v":1.218181818181818},{"$f":"MEDIAN(L42:L54)","v":0.82089552238805985},{"$f":"MEDIAN(M42:M54)","v":1.4796019900497512},{"$f":"MEDIAN(N42:N54)","v":0.67590909090909079},{"$f":"MEDIAN(O42:O54)","v":1.7239057239057238},null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"DATA SUMMARY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Benefit","Level 1","Level 2","Level 3",null,"Threshold?","All","L1","L2","L3",null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Visualization and monitoring",{"$f":"K77","v":"-"},{"$f":"L77","v":"-"},{"$f":"M77","v":"-"},null,"Average All",{"$f":"AVERAGE($K$80,$L$84:$M$90,$K$94:$M$107,$K$111:$M$112,$K$116:$M$120,$K$124:$L$124,$L$128:$M$129,$L$133,$M$137:$M$139,$K$143,$K$147,$L$151:$M$156)","v":0.29931506849315065},{"$f":"AVERAGE(K76,K80,K84:K90,K94:K107,K111:K112,K116:K120,K124,K128:K129,K133,K137:K139,K143,K147,K151:K156)","v":0.31954545454545458},{"$f":"AVERAGE(L84:L90,L94:L107,L111:L112,L116:L120,L128:L129,L137:L139,L151:L156,L124,L133)","v":0.35089285714285712},{"$f":"AVERAGE(M84:M90,M94:M107,M111:M112,M116:M120,M128:M129,M137:M139,M151:M156)","v":0.25029411764705883},null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Informed decision-making",{"$f":"K81","v":0.47},{"$f":"L81","v":0.57254545454545447},{"$f":"M81","v":0.8102356902356902},null,"Stdev. All",{"$f":"STDEV($K$80,$L$84:$M$90,$K$94:$M$107,$K$111:$M$112,$K$116:$M$120,$K$124:$L$124,$L$128:$M$129,$L$133,$M$137:$M$139,$K$143,$K$147,$L$151:$M$156)","v":0.19553046627574211},{"$f":"_xlfn.STDEV.S(K76,K80,K84:K90,K94:K107,K111:K112,K116:K120,K124,K128:K129,K133,K137:K139,K143,K147,K151:K156)","v":0.16050630120737547},{"$f":"_xlfn.STDEV.S(L84:L90,L94:L107,L111:L112,L116:L120,L128:L129,L137:L139,L151:L156,L124,L133)","v":0.2209661176114455},{"$f":"_xlfn.STDEV.S(M84:M90,M94:M107,M111:M112,M116:M120,M128:M129,M137:M139,M151:M156)","v":0.17547313174486118},null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Resource optimization and loss reduction",{"$f":"K91","v":0.17238805970149257},{"$f":"L91","v":0.21},{"$f":"M91","v":0.32500000000000001},null,"Min Thresh",{"$f":"P59-P60","v":0.10378460221740854},{"$f":"Q59-Q60","v":0.15903915333807911},{"$f":"R59-R60","v":0.12992673953141162},{"$f":"S59-S60","v":7.4820985902197656E-2},null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Productivity gains",{"$f":"K108","v":0.27500000000000002},{"$f":"L108","v":0.33499999999999996},{"$f":"M108","v":0.5},null,"Max Thresh",{"$f":"P59+P60","v":0.49484553476889276},{"$f":"Q59+Q60","v":0.48005175575283004},{"$f":"R59+R60","v":0.57185897475430258},{"$f":"S59+S60","v":0.42576724939192001},null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Improve operations, inspection, maintenance",{"$f":"K113","v":0.22500000000000001},{"$f":"L113","v":0.35},{"$f":"M113","v":0.51786069651741296},null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Improve or optimize financial performance",{"$f":"K121","v":0.20250000000000001},{"$f":"L121","v":0.22500000000000001},{"$f":"M121","v":0.33},null,"average L3",{"$f":"AVERAGE($M$84:$M$90,$M$94:$M$107,$M$111:$M$112,$M$116:$M$120,$M$128:$M$129,$M$137:$M$139,$M$151:$M$156)","v":0.25029411764705883},null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Improve quality",{"$f":"K125","v":0.12313432835820898},{"$f":"L125","v":0.15},{"$f":"M125","v":0.22194029850746269},null,"stdev",{"$f":"_xlfn.STDEV.S($M$84:$M$90,$M$94:$M$107,$M$111:$M$112,$M$116:$M$120,$M$128:$M$129,$M$137:$M$139,$M$151:$M$156)","v":0.17547313174486118},null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Increase customer satisfaction",{"$f":"K130","v":0.15372070312500002},{"$f":"L130","v":0.17911590909090908},{"$f":"M130","v":0.26500000000000001},null,null,{"$f":"P64-P65","v":7.4820985902197656E-2},null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Improved knowledge and collaboration",{"$f":"K134","v":0.32835820895522394},{"$f":"L134","v":0.4},{"$f":"M134","v":0.59184079601990047},null,null,{"$f":"P64+P65","v":0.42576724939192001},null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Security and safety",{"$f":"K140","v":0.21462890625},{"$f":"L140","v":0.25008636363636361},{"$f":"M140","v":0.37},null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Predictive intelligence",{"$f":"K144","v":0.39},{"$f":"L144","v":0.47509090909090906},{"$f":"M144","v":0.67232323232323232},null,"avg l2",{"$f":"AVERAGE($L$84:$L$90,$L$94:$L$107,$L$111:$L$112,$L$116:$L$117,$L$124,$L$128,$L$133,$L$151)","v":0.35089285714285712},null,null,null,null,null,null,null,null,null,3,null,null,0.4,0.15]
[null,null,null,null,null,null,null,null,null,"Risk management and resilience",{"$f":"K148","v":0.15},{"$f":"L148","v":0.18272727272727271},{"$f":"M148","v":0.25858585858585859},null,"stdev",{"$f":"_xlfn.STDEV.S($L$84:$L$90,$L$94:$L$107,$L$111:$L$112,$L$116:$L$117,$L$124,$L$128,$L$133,$L$151)","v":0.2209661176114455},null,null,null,null,null,null,null,null,null,2,null,null,null,0.13,null,0.22499999999999998]
[null,null,null,null,null,null,null,null,null,"Improved environmental sustainability",{"$f":"K157","v":0.24626865671641796},{"$f":"L157","v":0.3},{"$f":"M157","v":0.4},null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"HIGH LEVEL BENEFITS OF A DIGITAL TWIN BY BENEFIT AND MATURITY LEVEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"MEDIAN",null,null,null,null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,1,null,null,null,null,0.2,0.13500000000000001,null,null,null,null,null,0.15]
[null,null,null,null,null,null,null,null,null,"Visualization and Monitoring","Level 1","Level 2","Level 3",null,"Visualization and Monitoring","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,"N/A","N/A","N/A",null,null,"N/A","N/A","N/A",null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"MEDIAN","-","-","-",null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,null,null,null,"Informed Decision-making","Level 1","Level 2","Level 3",null,"Informed Decision-making","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,0.47,"NA","NA",null,null,0.47,"NA","NA",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"K80","v":0.47},{"$f":"K81*K55","v":0.57254545454545447},{"$f":"K81*O55","v":0.8102356902356902},null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,2]
[null,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]
[null,null,null,null,null,null,null,null,null,"Resource optimization and loss reduction","Level 1","Level 2","Level 3",null,"Resource optimization and loss reduction","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,"NA",0.4,0.4,null,null,"NA",0.4,0.4,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,0.35,0.25,null,null,null,0.35,0.25,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,0.7,0.02,{"$f":"_xlfn.QUARTILE.INC(L84:L89,1)","v":0.14000000000000001},null,null,0.7,0.02,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,7.0000000000000007E-2,0.1,{"$f":"_xlfn.QUARTILE.INC(L84:L89,3)","v":0.39750000000000002},null,null,7.0000000000000007E-2,0.1,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,0.39,0.11,{"$f":"MEDIAN(L88,L85,L84)","v":0.39},null,null,0.39,0.11,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,0.01,0.15,null,null,null,0.01,0.15,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.17,null,null,null,null,0.17,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"L91*L55","v":0.17238805970149257},{"$f":"MEDIAN(L87,L85)","v":0.21},{"$f":"MEDIAN(M84:M85)","v":0.32500000000000001},null,"AVERAGE",null,{"$f":"AVERAGE(Q87:Q88,Q84:Q85)","v":0.30249999999999999},{"$f":"AVERAGE(R84:R85)","v":0.32500000000000001},null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Productivity Gains","Level 1","Level 2","Level 3",null,"Productivity Gains","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,0.35,0.38,0.6,null,null,0.35,0.38,0.6,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,0.66,0.37,0.05,null,null,0.66,0.37,0.05,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,0.2,0.3,0.2,null,null,0.2,0.3,0.2,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,0.4]
[null,null,null,null,null,null,null,null,null,null,null,0.13,0.15,null,null,null,0.13,0.15,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,0.25,0.2,null,null,null,0.25,0.2,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,0.7,0.5,null,null,null,0.7,0.5,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,0.3,0.25,null,null,null,0.3,0.25,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,0.18,0.65,null,null,null,0.18,0.65,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,0.38,0.3,null,null,null,0.38,0.3,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,0.5,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,0.2,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,0.5,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,0.4,null,null,null,null,0.4,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,0.75,null,null,null,null,0.75,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"MEDIAN(K96,K94)","v":0.27500000000000002},{"$f":"MEDIAN(L100:L106,L94:L98)","v":0.33499999999999996},{"$f":"MEDIAN(M99:M102,M94)","v":0.5},null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Improve operations, inspection, maintenance","Level 1","Level 2","Level 3",null,"Improve operations, inspection, maintenance","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,0.25,0.35,0.15,null,null,0.25,0.35,0.15,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,0.2,0.1,0.1,null,null,0.2,0.1,0.1,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"MEDIAN(K111:K112)","v":0.22500000000000001},{"$f":"MEDIAN(L111)","v":0.35},{"$f":"L113*M55","v":0.51786069651741296},{"$f":"K113*O55","v":0.38787878787878788},"AVERAGE",null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Improve or optimize financial performance","Level 1","Level 2","Level 3",null,"Improve or optimize financial performance","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,0.27,0.22500000000000001,0.12,null,null,0.27,0.22500000000000001,0.12,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,0.13500000000000001,0.09,0.35,null,null,0.13500000000000001,0.09,0.35,null,null,null,null,null,null,null,2,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,0.33,null,null,null,null,0.33,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.33,null,null,null,null,0.33,null,null,null,null,null,null,null,2,null,null,null,0.37]
[null,null,null,null,null,null,null,null,null,null,null,null,0.1,null,null,null,null,0.1,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"MEDIAN(K116:K117)","v":0.20250000000000001},{"$f":"MEDIAN(L116)","v":0.22500000000000001},{"$f":"MEDIAN(M117:M119)","v":0.33},null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"Improve Quality","Level 1","Level 2","Level 3",null,"Improve Quality","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,0.44,0.15,"NA",null,null,0.44,0.15,"NA",null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"L125*L55","v":0.12313432835820898},{"$f":"MEDIAN(L124)","v":0.15},{"$f":"L125*M55","v":0.22194029850746269},null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,0.12]
[null,null,null,null,null,null,null,null,null,"Increase customer satisfaction","Level 1","Level 2","Level 3",null,"Increase customer satisfaction","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,"NA",0.95,0.13,null,null,"NA",0.95,0.13,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,0.4,null,null,null,null,0.4,null,null,null,null,null,null,null,3,null,null,0.10500000000000001,null,null,0.32999999999999996]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"M130/O55","v":0.15372070312500002},{"$f":"M130*N55","v":0.17911590909090908},{"$f":"MEDIAN(M128:M129)","v":0.26500000000000001},null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,2,null,null,null,0.3]
[null,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]
[null,null,null,null,null,null,null,null,null,"Improve knowledge and collaboration","Level 1","Level 2","Level 3",null,"Improve knowledge and collaboration","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,"NA",0.4,"NA",null,null,"NA",0.4,"NA",null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"L134*L55","v":0.32835820895522394},{"$f":"MEDIAN(L133)","v":0.4},{"$f":"L134*M55","v":0.59184079601990047},null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Security and safety","Level 1","Level 2","Level 3",null,"Security and safety","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,"NA","NA",0.08,null,null,"NA","NA",0.08,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0.37,null,null,null,null,0.37,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,0.6,null,null,null,null,0.6,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"M140/O55","v":0.21462890625},{"$f":"M140*N55","v":0.25008636363636361},{"$f":"MEDIAN(M137:M139)","v":0.37},null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,1,null,0.47,null,0.35,null,0.26500000000000001,0.4425,null,null,null,0.39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Predictive intelligence","Level 1","Level 2","Level 3",null,"Predictive intelligence","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,0.39,"NA","NA",null,null,0.39,"NA","NA",null,null,null,null,null,null,null,1,null,null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"MEDIAN(K143)","v":0.39},{"$f":"K144*K55","v":0.47509090909090906},{"$f":"K144*O55","v":0.67232323232323232},null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,"Risk mangement and resilience","Level 1","Level 2","Level 3",null,"Risk mangement and resilience","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,0.15,"NA","NA",null,null,0.15,"NA","NA",null,null,null,null,null,null,null,3,null,null,null,0.6]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"MEDIAN(K147)","v":0.15},{"$f":"K148*K55","v":0.18272727272727271},{"$f":"K148*O55","v":0.25858585858585859},null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,null,null,0.125]
[null,null,null,null,null,null,null,null,null,"Improved environmental sustainability","Level 1","Level 2","Level 3",null,"Improved environmental sustainability","Level 1","Level 2","Level 3",null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,"NA",0.3,0.03,null,null,"NA",0.3,0.03,null,null,null,null,null,null,null,2,null,null,null,0.17499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,0.05,null,null,null,null,0.05,null,null,null,null,null,null,null,2,null,null,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,0.2,null,null,null,null,0.2,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5,null,null,null,null,0.5,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,0.4,null,null,null,null,0.4,null,null,null,null,null,null,null,2,null,null,null,0.375]
[null,null,null,null,null,null,null,null,null,null,null,null,0.17,null,null,null,null,0.17,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,"MEDIAN",{"$f":"L157*L55","v":0.24626865671641796},{"$f":"MEDIAN(L151:L156)","v":0.3},{"$f":"MEDIAN(M153:M155)","v":0.4},null,"AVERAGE",null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,0.2,null,null,0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,0.375,null,null,null,null,null,null,null,null,0.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,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]
[null,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,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,0.35,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,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]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,null,0.35,null,null,null,null,null,null,null,0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,0.25,0.2,null,null,null,null,null,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,0.39,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,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]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,null,0.15]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,0.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,null,null,null,0.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,null,null,null,null,0.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,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]
[null,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]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,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]
[null,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]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]

{"sheet":"Dropdown","index":8,"n_rows":46,"n_cols":2,"rows_kept":46,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Yes/No"]
[null,"Yes"]
[null,"No"]
[]
[null,"Phase"]
[null,"Select Input"]
[null,"D&B"]
[null,"O&M"]
[null,"Entire"]
[]
[null,"MATURITY LEVEL"]
[null,"-"]
[null,"Level 1: Descriptive Twin"]
[null,"Level 2: Informative Twin"]
[null,"Level 3: Predictive Twin"]
[]
[null,"ASSET SCALE"]
[null,"-"]
[null,"Small"]
[null,"Medium"]
[null,"Large"]
[]
[null,"SCENARIO"]
[null,"Conservative"]
[null,"Moderate"]
[null,"Optimistic"]
[]
[null,"RESULT IF COST IS INDICATIVE"]
[null,"The indicative cost of a"]
[null,"Digital Twin for a "]
[null,"scale asset is"]
[]
[null,"RESULT IF COST IS KNOWN"]
[null,"The total cost of my"]
[null,"Digital Twin"]
[null,"is"]
[]
[null,"COST OPTION"]
[null,"Median"]
[null,"Minimum"]
[null,"Maximum"]
[]
[null,"Yes/No"]
[null,"Yes"]
[null,"No"]