Spreadsheet: 675608d1588366047-index-only-visible-cells-index-visible-cells-only
Sheet: Data (old)

last update | Progress | Column2 | R A G | Designator Region.Action | Column1 | Designator | SDC Name | SDC long name | Theme | SubTheme | Crisis related | short name | Activity | Region or Division assisting | Your  contact point for Region/Division | Output expected / deliverables | Time | Timeframe (date completion) | External funding | Reason for external spend?\ |  | dummy
2020-04-24 00:00:00 | 0.75 |  | r | C.1.01 |  | 1.01_C | [NAME] | [NAME] | Client Work | Revenue generating | Yes | AMGEN CoVid 19 support Project | Supporting AMGEN CoViD19 Project | SDC/DEKRA Industrial Safety BV | N/A | •Ongoing Executive client relationship management •Overall project oversight (with [NAME]) | .5 day | Ongoing (June) | None | N/A |  | 1
2020-04-24 00:00:00 | 0.75 |  | g | S.1.01 |  | 1.02_S | [NAME] | [NAME] | Solution Development | Building a Crisis Management Solution | Yes | Customer facing content collection/ communication | Collect and develop customer facing content and communication about crisis management and the actual crisis, coordinate between supporting Corporate functions (Srategic Marketing, Marketing Services, Corporate Communications etc.) | Germany + others | [NAME] | •Dedicated website in German and English (more to follow) + Press Release to promote it •Support regional customer communication (Social Media, Newsletter, Adwords Campaign) •Online Self-Assessment | 20-25 days | 2020-04-01 00:00:00 | 20000 | No internal resource able to produce this material in short time |  | 1
2020-04-01 00:00:00 | 0.75 |  | g | S.1.02 |  | 1.03_S | [NAME] | [NAME] | Solution Development | Building a Crisis Management Solution | Yes | Task Force Crisis Management | Task Force „Crisis Management Solutions“ à Creating an „Inform > Advise > Support“ approach incl.0 Website* for clients  (and the regions) | Mainly Region Germany, DEKRA Group Marketing and Strategic Sales | All Regions | Concept and Approach for Crisis Management activities, both actual crisis response as well as general crisis management system.0 Focus on SME.0 | Whole team assumption: 35 days | Ongoing | Only internal compensation for Consultant‘s support (approx. 7 days) |  |  | 1
2020-04-01 00:00:00 | 0.5 |  | ? | S.1.03 |  | 1.04_S | [NAME] | [NAME] | Solution Development | POV on Crisis Management | Yes | Market Insights and future services for municipalities | Creating Market insights and future consultancy services related to Crisis Management for cities and municipalities and conjoined public utility organizations | Corporate strategic Marketing and Sales | [NAME] | Market insights Cities, Municipalities, Public Utility Services | 2 days | End of May | Not known yet | tbd |  | 1
2020-04-24 00:00:00 | 0 |  | ? | [NAME] |  | 1.05_R | [NAME] | [NAME] Trujillo | Regional Support |  | Yes | Sharepoint Site for remote Process Hazard Analysis | Set up a SharePoint site to assist regions in delivering remote Process Hazard Analysis and other consulting services | CEEME (Italy), ESA (China, India), DE (Germany), NA (US), NEW (UK),  SWE (France, Spain) | [NAME], [NAME], [NAME], [NAME], J. Wincek, [NAME], J-M. François, M. Cabrelles | •Collection of material to assist colleagues in delivering remote PHAs. •Identify and promote existing communications tools to facilitate remote consulting (e.g. i2i). •List of reference cases. | 2 days | 2020-03-01 00:00:00 | - | N/A |  | 1
2020-04-24 00:00:00 | 0 |  | ? | S.1.04 |  | 1.06_S | [NAME] | [NAME] Trujillo | Solution Development | Adding crisis dimension to an existing service | yes | Incident Investigations | Incident Investigation | CEEME (Italy), ESA (China, India), DE (Germany), NA (US), NWE (UK),  SWE (France, Spain) | [NAME], [NAME], [NAME], [NAME], J. Wincek, [NAME], J-M. François, M. Cabrelles | Establishment of a software solution | 3 days | Ongoing | 8.000 EUR/a | Necessity to have global coverage |  | 1
2020-04-24 00:00:00 | 0 |  | ? | C.1.05 |  | 1.07_C | [NAME] /  C.Correia | [NAME] /  CristinaCorreia | Client Work | Sales Supporting | Yes | Workshops to define3 Top Solutiosn for business restart | Deliver workshops to key markets for defining Top solution to take a new start after the crisis | DAS DE, DAS PT, DAS IT, DAL (UK) | tbd | •Development roadmap for quick win services to be proposed upon business re-start | 14 days | 2020-05-01 00:00:00 |  |  |  | 1
2020-04-24 00:00:00 | 1 |  | G | R.1.05 |  | 1.08_R | [NAME] | [NAME] Trujillo | Regional Support |  | Yes | Facilitate PS community information exchange across regions | Set up a Teams group to facilitate exchange of resources across regions and SDC | CEEME (Italy), ESA (China, India), DE (Germany), NA (US), NEW (UK),  SWE (France, Spain) | [NAME], [NAME], [NAME], [NAME], J. Wincek, [NAME], J-M. François, M. Cabrelles | Teams group including: •Consulting resources marketplace across regions. •Information relevant to conduct remote consulting. •Information relevant to deliver online training. •Information relevant to transform face t face training programs into online training. •Other items to be included on a pro re nata basis. | 2 days | Ongoing (to be active until the end of the crisis) | - | N/A |  | 1
2020-04-01 00:00:00 | 0.5 |  | g | S.1.05 |  | 1.09_S | [NAME] | [NAME] | Solution Development | Adding crisis dimension to an existing service | yes | SafeD expansion | SafeD:Set up immediate and direct actions for reaching the next level | Germany (DASS, Team Stuttgart) | S. Gläser/ K.-P. Junk | •Programming of external backoffice function •Translation of SafeD into English •Start Marketing campaign “SafeD from home” and sell SafeD very cheap in order to gain fast clients | 1-2 days (FS) | 2020-04-01 00:00:00 | Not applicable - Only intercompany cost occur |  |  | 1
2020-04-24 00:00:00 | 0.25 |  | g | R.1.06 |  | 1.10_R | [NAME] | [NAME] | Regional Support |  | YES | Support communication to BizCon customers during crisis | Support to keep communication flow towards the global customers alive during confinement / crisi | Global Services Sales; SD C Marketing | Tbd, [NAME] | * White papers and case studies in relation with crisis, respectively digital coaching & training programs | 6 days | 2020-05-01 00:00:00 | 1,000 EUR (tbd) | Design & creation of material |  | 1
2020-04-24 00:00:00 | 1 |  | g | S.1.06 |  | 1.11_S | [NAME] | [NAME] | Solution Development | Adding crisis dimension to an existing service | Yes | Data Protection & IT Sec durin CoVid19 [Part 1] | Part 1: Data Protection & IT Security in times of Corona (Actions DONE) | Germany (DASS, Team Berlin) | [NAME] | Topic: 1.Providing of interesting links around this topic for crisis management website  2.Writing a guide for SMEs and employees how to deal with this topic in home office (DE+EN versions) and make available on website and as pdf 3.iT Sec & DP question catalog for overall crisis assessment (only DE currently) 4.Support in organizing biweekly webinars | FS time for topic: 1. Ongoing daily 2. ~3 days 3. ~1 day 4. 2 hours | 2020-03-01 00:00:00 | Not applicable |  |  | 1
2020-04-24 00:00:00 | 0 |  | g | S.1.07 |  | 1.12_S | [NAME] | [NAME] | Solution Development | Adding crisis dimension to an existing service | Yes | Data Protection & IT Sec durin CoVid19 [Part 2] | Part 2: Data Protection & IT Security in times of Corona (PLANNED Actions to come) | Germany (DASS, Team Berlin) | [NAME] | Topic: 1.Providing of interesting links around this topic for crisis management website  2.iT Sec & DP question catalog for overall crisis assessment in EN and maybe further adaptions 3.Writing articles at LinkedIn 4.Idea: Creating a Cyber package (combination of free quick security scan, evtl. RadarServices, “SafeD from home”) | Estimated FS time for topic: 1. Ongoing daily 2. ~3 days 3. Ongoing weekly 4. ~3 days | 2020-04-01 00:00:00 | Not applicable |  |  | 1
2020-04-24 00:00:00 | 0 |  |  | S.1.08 |  | 1.13_S | [NAME] | [NAME] | Solution Development | Adding crisis dimension to an existing service | Yes | Dealer Finance Solvency quick check | Development of a dealer finance solvency quick check with DAS DE and DAS IT | DAS DE; DAS IT | [NAME], [NAME] | •Car retailer finance solvency quick check to be proposed to OEM / National Sales Companies; Captives, banks and dealer associations | 6 days | 2020-05-01 00:00:00 | 0 |  |  | 1
2020-04-24 00:00:00 | 0 |  |  | S.1.09 |  | 1.14_S | [NAME] /  C.Correia | [NAME] /  CristinaCorreia | Solution Development | Adding crisis dimension to an existing service | Yes | Adaptation of "special days event" to end of crisis requirements | Adaptation of existing sales promotion solutions “special days event” to end of crisis requirements | DAS PT, DAS IT, DAS ES | Tbd | •Top solution to take a new start after the crisis and make up lost business: Modernized “special days event” program to propose to dealer groups, OEM/NSC and captives | 7 days | 2020-05-01 00:00:00 |  |  |  | 1
2020-04-24 00:00:00 | 0 |  |  | S.1.10 |  | 1.15_S | [NAME] /  C.Correia | [NAME] /  CristinaCorreia | Solution Development | Building our technical Capability (Digitalisation) | Yes | Transformation of physical trainings to online | Transformation of physical training parts into online training nuggets | D NA | [NAME], M-L Lin | •Support the creation of ready to use online training nuggets based on DNA physical programs | -tbd | 2020-04-01 00:00:00 |  |  |  | 1
2020-04-24 00:00:00 | 0.25 |  |  | S.1.11 |  | 1.16_S | [NAME] | [NAME] | Solution Development | Building our technical Capability (Digitalisation) | Yes | Development of Digital Expert solutions | Development of Digital Expert solution incl. GTM | DAS DE; DAS PT | [NAME] J. Barroso | Top solution to be better positioned after the crisis: digital expert training & coaching program | tbd | 2020-05-01 00:00:00 |  |  |  | 1
2020-04-24 00:00:00 | 0.5 |  |  | S.1.12 |  | 1.17_S | [NAME] | [NAME] | Solution Development | Adding crisis dimension to an existing service | Yes | Short term support of BizCon units | Evaluation/conceptualization of options for short-term support of Business Consulting units | Multi-region | BC Country Manager | Activities to increase dealer business ramp-up (in discussion, needs further alignment) | In conside-ration |  | No |  |  | 1
2020-04-01 00:00:00 | 0.25 |  |  | S.1.13 |  | 1.18_S | [NAME] | Loh/Serini | Solution Development | Adding crisis dimension to an existing service | Yes | Integration of Start-Up Serinus in Crisis Mgt. | Integration of Start-Up Serinus in Crisis Mgt. Microsite with Discount for DEKRA customer | Germany | Corporate Dept./DEKRA Digital | Link from SE Microsite to Serinus; potential discount of 20% for DEKRA customers, provision for DEKRA entity | 4 Persondays | Before Easter | No |  |  | 1
2020-04-01 00:00:00 | 0.25 |  | g | C.1.14 |  | 1.19_C | [NAME] | [NAME] | Client Work | Revenue generating | Yes | AMGEN CoVid 19 support Project [substream] | Immediate Crisis Support service project for Amgen Pharmaceuticals corporation in Netherlands, Ireland and Switzerland. [NAME] as executive sponsor and content provider for the consulting team of 3 consultants from NL, IRL, DE | Germany, NWE | [NAME] | Successful Client Project | 5 days since February | Assumption:Middle of May | The client is paying approx. 100,000$ | Income, not spending |  | 1
2020-04-01 00:00:00 | 0.25 |  | g | C.3.01 |  | 3.01_C | [NAME] | [NAME] | Client Work | Revenue generating | YES | Construction Site Safety Consulting Services training China | Supporting and training of DEKRA China Consultants to deliver Construction Site Safety consultancy services. Why Crisis Management: since on-site support by an expert from DEKRA NWE is not possible, the SD is instead training remotely through web sessions. |  | [NAME] | Successful client project | 20 days (since January) | Middle of April | Client project value approx. 300,000 EUR | Income, not spending |  | 1
2020-04-01 00:00:00 | 0.5 |  | g | F.5.01 |  | 5.01_F | [NAME] | [NAME] | Facilitated Support | Process rigor & efficiency gains | Yes | Creation and facilitation of DNA’s Business Continuity Team | Creation and facilitation of DNA’s Business Continuity Team as sanctioned by [NAME] – MJS and MLL involved. | DNA Service Operations | [NAME] | •Protect DEKRA North America revenues during the CoVid19 pandemic by ensuring the continuity of operations across Service Operations, driving efficient use of resources, minimizing disruption and distraction for day to day operations.​ •Determine pragmatic support needs from the client facing organizations. Oversee the coordination, management and impact of the business continuity actions/strategies.​ •Identify, investigate and test ‘practical’ alternate methods of revenue generation that meet client [NAME] and guide the best use of available resources (SD, Corporate functions, Regions etc.)​ •Be the governance/oversight for both Short-term and Medium-term ideas from DNA Think-Tank Team. | 1-2 days? | End of crisis TBA less than 3 months | None | N/A |  | 1
2020-04-24 00:00:00 | 0.5 |  | a | R.5.01 |  | 5.02_R | [NAME] | [NAME] | Regional Support |  | Yes | Program Manage development and execution of Virtual SIA event | Program Manage development and execution of Virtual SIA event | DNA Consulting Organization | [NAME] | •Revenue retention •Business [NAME] and value proposition •50 high quality on line sessions for SIA attendees | 4-5 days | 2020-06-01 00:00:00 | TBA? | No internal resource able to produce this material |  | 1
2020-04-01 00:00:00 | 0 |  | g | C.5.02 |  | 5.03_C | [NAME] | [NAME] | Client Work | Sales Supporting | NO | Support SMS in demo’s for Adaptive ™ Software demos | Potential request  - Support SMS in demo’s for Adaptive ™ Software demos during [NAME] maternity leave | DNA Consulting Organization | [NAME] | •Sales support and tech demo’s | TBA | June-August | None | N/A |  | 1
2020-04-01 00:00:00 | 0.5 |  | g | F.5.02 |  | 5.04_F | ML. [NAME] | [NAME] | Facilitated Support | Process rigor & efficiency gains | Yes | Support of DNA Business Continuity Taskforce and ThinkTank | Joined DNA Business Continuity Taskforce.  Assisted DNA in selecting a remote training tool and a remote auditing tool. Joined DNA Think Tank | DNA | [NAME] | •Select the right tool for remote service (training and auditing) delivery  •Support rapid application to minimize revenue disruption  •Identify transformative solutions and business models to ensure long-term success. | 1.5 days | 2020-06-01 00:00:00 | None |  |  | 1
2020-04-24 00:00:00 | 0 |  | a | R.5.02 |  | 5.05_R | [NAME] | [NAME] | Regional Support |  | NO | Support DNA Consulting with PS operation improvements | Support Rune Haug (DNA Consulting Operations) in facilitating improvement activities related to PS operation improvements, | DNA Consulting Organization | Rune Haug | •Still being defined •Process improvements through project lifecycle •AR / Dunning improvements | 1-2 days ?? | less than 3 months | None | N/A |  | 1
2020-04-01 00:00:00 | cancelled |  | g | R.5.03 |  | 5.06_R | [NAME] | [NAME] | Regional Support |  | NO | Support RCI/SMS on the move to VISION software | Potential request – to be reviewed Support RCI/SMS on the move to VISION software | DNA Consulting Organization | Rune Haug | •Transition to VISION with associated training/and process improvement | ? | ? Less than 3 months | None | N/A |  | 1
2020-04-24 00:00:00 | 0.25 |  | g | R.6.08 |  | 6.01_R | A.Larraze /  [NAME] | AmandaLarraze /  Farid Kandil | Regional Support |  | NO | Globalize I-Coach booking portal for use | Support transition to online trainings - Globalize I-Coach booking portal for use within SD C and SD Training | DAL (UK) and [NAME] | [NAME] (UK), [NAME] (SD T) | •* Simple to implement and use booking portal for DEKRA online trainings | 6 days | Aril 2020 | tbd | Potentially additional licenses of the tool are required |  | 1
2020-04-24 00:00:00 | 0.25 |  | g | [NAME] |  | 9.01_R | [NAME], [NAME] | [NAME], [NAME] Kandil | Regional Support |  | NO | Study globalization of Easy Market application | Study globalization of Easy Market application of DAS FR | DAS FR (?) | tbd | •Feasibility study on globalization of Easy Market application •Roll out & market concept, costing model | tbd | 2020-05-01 00:00:00 |  |  |  | 1
2020-04-24 00:00:00 | 0.25 |  | g | R.9.09 |  | 9.02_R | [NAME] | [NAME] | Regional Support |  | NO | Translation to French from presentation “well prepared for online meeting” | Translation to French from presentation “well prepared for online meeting” | SWE | Tbd | Integration of guideline to French dekra.fr website | 1 day | Completed | No |  |  | 1
2020-04-24 00:00:00 | 0.25 |  | g | [NAME] |  | 9.03_R | [NAME] | [NAME] | Regional Support |  | Yes | Support for localization of “Crisis Management” website for France | Support for localization of “Crisis Management” website for France | SWE | [NAME]. France | Explanaition of German content and needs to adapt to French capabilities | < 1 day yet |  | No |  |  | 1