{"id":4025,"date":"2019-01-09T17:08:10","date_gmt":"2019-01-09T16:08:10","guid":{"rendered":"https:\/\/www.signl4.com\/de\/?p=4025"},"modified":"2024-05-24T09:56:17","modified_gmt":"2024-05-24T09:56:17","slug":"alarm-schicht-reports-excel","status":"publish","type":"post","link":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/","title":{"rendered":"Alarm- und Schicht-Reports mit Microsoft Excel"},"content":{"rendered":"<p>SIGNL4 stellt Reporting-Daten f\u00fcr Bereitschaftszeiten und Alarme zur Verf\u00fcgung. Dies ist zum Beispiel n\u00fctzlich, um die Arbeitsauslastung Ihrer Teammitglieder, die H\u00e4ufigkeit bestimmter Alarmarten, die Verg\u00fctung der Bereitschaftsmitarbeiter usw. zu sehen. Auf die Reporting-Daten k\u00f6nnen Sie in Ihrem SIGNL4-Portal unter Audit Trail zugreifen. Von hier aus k\u00f6nnen Sie Schicht- \/ Rufbereitschafts- sowie Alarmdaten als .csv-Dateien herunterladen.<\/p>\n<p>Hier zwei Beispiele:<\/p>\n<p><strong>AlertAuditReport.csv<\/strong><\/p>\n<p>Timestamp;LogId;EventType;AlertId;EventId;UserId;UserMail;Content;Price;Duration in seconds<br \/>\n2022-05-01T02:34:33.9293685Z;4f7ebe1a-7583-4012-b51b-75e0c3428427;Alert_New;2517509283260706314_c6afef71-a0b6-498f-805b-ada00f015e04;2517509283261971850_86b3d931-4570-478d-b2b0-a4d383cecccc;;;&#8220;Heartbeat Missing | Heartbeat missing for 2 hours, 19 seconds.&#8220;;0.00;0<br \/>\n2022-05-01T02:48:05.6914856Z;a888e8e7-01c8-419a-aa94-cab52eccd947;Alert_New;2517509275143085143_98296b8b-1d47-4b2f-a848-e4b8c7055874;2517509275144092918_09bbe7e6-097c-4d45-83bb-706f84c2badc;;;[FIRING:1] (Data Alert Value1 g1njkfLMk A) | **Firing** Value: [no value] Labels: &#8211; alertname = Data Alert &#8211; Key1 = Value1 &#8211; datasource_uid = g1njkfLMk &#8211; ref_id = A Annotations: Source: https:\/\/ronlab.grafana.net\/alerting\/grafana\/OzBXIKbnz\/view Silence: https:\/\/ronlab.grafana.net\/alerting\/silence\/new?alertmanager=grafana&amp;matcher=Key1%3DValue1&amp;matcher=alertname%3DData+Alert&amp;matcher=datasource_uid%3Dg1njkfLMk&amp;matcher=ref_id%3DA Dashbo&#8230;;0.00;0<br \/>\n2022-05-01T03:05:22.4059209Z;a3b924c5-fedf-4bd5-a8e4-a578a7d0c45f;Alert_Closed;2517509283260706314_c6afef71-a0b6-498f-805b-ada00f015e04;2517509283261971850_86b3d931-4570-478d-b2b0-a4d383cecccc;00000000-0000-0000-0000-000000000000;system@signl4.com;;0.00;0<br \/>\n2022-05-01T06:00:58.8668607Z;d85f4729-92a2-4f01-8116-77200fa8fc8b;Alert_New;2517509159411331392_05e834eb-d0e3-458b-85df-a06f35b94746;2517509159413040997_dea243e0-4c8b-484f-bd01-37d118d1fbc2;;;Daily Weather;0.00;0<\/p>\n<p><strong>Achtung<\/strong>: Die Alarm-CSV-Date einh\u00e4lt ein Alarm-Ereignis (nicht einen Alarm) pro Zeile. Ein Alarm kann also aus mehreren Zeilen bestehen, zum Beispiel, Alarm ausgel\u00f6st, Alarm best\u00e4tigt, usw.<\/p>\n<p><strong>ShiftReport.csv<\/strong><\/p>\n<p>Name;Email;Start;End;Hours<br \/>\nAnna;anna@derdack.com;2018-09-14T15:21:02.0743200Z;2018-09-14T17:31:44.4990010Z;2:10<br \/>\nJohn;john@derdack.com;2018-09-19T07:51:45.4039920Z;2018-09-19T07:52:29.5466015Z;0:0<br \/>\nJohn;john@derdack.com;2018-09-19T07:52:58.9672917Z;2018-09-19T08:51:01.8244028Z;0:58<\/p>\n<p>Diese Dateien k\u00f6nnen Sie nun aus Ihren Reporting-Tools heraus bearbeiten, zum Beispiel f\u00fcr die Buchhaltung. Das folgende Beispiel zeigt, wie Sie aussagekr\u00e4ftige Berichte in Microsoft Excel generieren k\u00f6nnen. So k\u00f6nnte es aussehen:<\/p>\n<p><strong>AlertAuditReport<\/strong><\/p>\n<p><a href=\"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/Alerts-Report-SIGNL4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-20700 size-medium\" src=\"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/Alerts-Report-SIGNL4-202x300.png\" alt=\"Alerts Report in SIGNL4\" width=\"202\" height=\"300\" srcset=\"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/Alerts-Report-SIGNL4-202x300.png 202w, https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/Alerts-Report-SIGNL4.png 466w\" sizes=\"(max-width: 202px) 100vw, 202px\" \/><\/a><\/p>\n<p><strong>ShiftReport<\/strong><\/p>\n<p><a href=\"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/Shifts-Report-SIGNL4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-20702 size-medium\" src=\"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/Shifts-Report-SIGNL4-300x190.png\" alt=\"Shift Report in SIGNL4\n\" width=\"300\" height=\"190\" srcset=\"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/Shifts-Report-SIGNL4-300x190.png 300w, https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/Shifts-Report-SIGNL4.png 470w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>Um diese oder \u00e4hnliche Reports zu erstellen, sind folgende Schritte n\u00f6tig:<\/p>\n<p>1. Laden Sie die .csv-Dateien von Ihrem SIGNL4-Portal unter Audit Trail herunter.<\/p>\n<p>2. Importieren Sie die .csv-Dateien in Excel. Bitte importieren und nicht mit Doppel-Klick \u00f6ffnen. Der Import erkennt die Formate (Datum \/ Zeit) besser.<\/p>\n<p>3. Nun k\u00f6nnen Sie in Excel die n\u00f6tigen Berechnungen durchf\u00fchren und die entsprechenden Diagramme erstellen.<\/p>\n<p>4. Ausdrucken oder als PDF exportieren, senden und fertig.<\/p>\n<p>Das ist nat\u00fcrlich stark vereinfacht und in der Praxis kann das durchaus kompliziert sein. Daf\u00fcr haben wir Ihnen ein Beispiel mit den obigen Diagrammen unter GitHub (<a href=\"https:\/\/github.com\/signl4\/signl4-reporting\">https:\/\/github.com\/signl4\/signl4-reporting<\/a>) in der Datei SIGNL4-Reporting.xls zur Verf\u00fcgung gestellt. Dies k\u00f6nnen Sie auf Ihre Bed\u00fcrfnisse anpassen.<\/p>\n<p>Diese Excel-Datei bietet die folgenden Reporting-Informationen:<\/p>\n<p>Alarme<\/p>\n<ul>\n<li>Anzahl der Alarme<\/li>\n<li>Anzahl der Alarme au\u00dferhalb der Arbeitszeit<\/li>\n<li>Anzahl der Alarme pro Nutzer<\/li>\n<li>Anzahl der Alarme pro Tag<\/li>\n<li>Durchschnittliche Antwort-Zeiten pro Nutzer<\/li>\n<\/ul>\n<p>Schichten<\/p>\n<ul>\n<li>Anzahl der Alarme<\/li>\n<li>Anzahl der Alarme au\u00dferhalb der Arbeitszeit<\/li>\n<li>Bereitschaftszeiten pro Nutzer in Stunden<\/li>\n<\/ul>\n<p>Mit dieser Excel-Datei k\u00f6nnen Sie Ihre CSV-Dateien wie folgt hinzuf\u00fcgen:<\/p>\n<p>1. \u00d6ffnen Sie die Datei SIGNL4-Reporting.xls und f\u00fcgen Sie dort Ihre CSV-Dateien hinzu. Gehen Sie dazu auf Daten -&gt; Queries &amp; Connections und doppelklicken Sie dann auf AlertAuditReport auf der rechten Seite. Der Power Query Editor wird ge\u00f6ffnet. Klicken Sie nun Home -&gt; Advanced Editor. Im Textfeld sehen Sie den Pfad zur der entsprechenden CSV-Datei. Passen Sie diese an den Pfad zu Ihrer AlertAuditReport-CSV-Datei an. Klicken Sie dann auf Done und Save &amp; Load, um den Power Query Editor zu schlie\u00dfen. Dasselbe tun Sie dann f\u00fcr SiftReport.<\/p>\n<p>2. Zur\u00fcck im Excel-Hauptfenster klicken Sie auf Data -&gt; Refresh All. Dadurch wird der Report entsprechend aktualisiert.<\/p>\n<p>3. M\u00f6glicherweise m\u00f6chten Sie die Reports noch entsprechend den von Ihnen ben\u00f6tigten Informationen anpassen. Wenn Sie gro\u00dfe Datens\u00e4tze haben, k\u00f6nnen Sie auch zus\u00e4tzliche Zeilen durch Kopieren und Einf\u00fcgen in den Sheets AlertHelper und ShiftHelper hinzuf\u00fcgen.<\/p>\n<p>4. Das ist alles und Ihre Reports sind in den Sheets Alerts und Shifts verf\u00fcgbar. Sie k\u00f6nnen sie ausdrucken oder als PDF exportieren.<\/p>\n<p><a href=\"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/Excel-Import-Small.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-9080 size-medium\" src=\"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/Excel-Import-Small-300x246.gif\" alt=\"\" width=\"300\" height=\"246\" \/><\/a><\/p>\n<p>(Bitte anklicken um Animated GIF zu \u00f6ffnen.)<\/p>\n<p>Ein \u00e4hnlicher Ansatz ist auch mit Google Sheets m\u00f6glich.<\/p>\n<p>Wenn Sie Fragen haben, lassen Sie es mich bitte unter\u00a0<a href=\"mailto:ron@signl4.com\">ron@signl4.com<\/a>\u00a0wissen.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SIGNL4 stellt Reporting-Daten f\u00fcr Bereitschaftszeiten und Alarme zur Verf\u00fcgung. Mit Microsoft Excel k\u00f6nnen Sie die Daten importieren und eigene Reports erstellen.<\/p>\n","protected":false},"author":1,"featured_media":17404,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[187],"tags":[],"class_list":["post-4025","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-allgemein"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.7 (Yoast SEO v27.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Alarm- und Schicht-Reports mit Microsoft Excel<\/title>\n<meta name=\"description\" content=\"SIGNL4 stellt Reporting-Daten f\u00fcr Bereitschaftszeiten und Alarme zur Verf\u00fcgung. In diesem Blogpost erfahrt ihr alles dar\u00fcber.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Alarm- und Schicht-Reports mit Microsoft Excel\" \/>\n<meta property=\"og:description\" content=\"SIGNL4 stellt Reporting-Daten f\u00fcr Bereitschaftszeiten und Alarme zur Verf\u00fcgung. In diesem Blogpost erfahrt ihr alles dar\u00fcber.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"DERDACK SIGNL4\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-09T16:08:10+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-05-24T09:56:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/reports.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"derdacksignl4\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"derdacksignl4\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"4\u00a0Minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/\"},\"author\":{\"name\":\"derdacksignl4\",\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/#\\\/schema\\\/person\\\/0a1a343b12e5afad11dbbf81fd864c13\"},\"headline\":\"Alarm- und Schicht-Reports mit Microsoft Excel\",\"datePublished\":\"2019-01-09T16:08:10+00:00\",\"dateModified\":\"2024-05-24T09:56:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/\"},\"wordCount\":810,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.signl4.com\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/reports.jpg\",\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/\",\"url\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/\",\"name\":\"Alarm- und Schicht-Reports mit Microsoft Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.signl4.com\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/reports.jpg\",\"datePublished\":\"2019-01-09T16:08:10+00:00\",\"dateModified\":\"2024-05-24T09:56:17+00:00\",\"description\":\"SIGNL4 stellt Reporting-Daten f\u00fcr Bereitschaftszeiten und Alarme zur Verf\u00fcgung. In diesem Blogpost erfahrt ihr alles dar\u00fcber.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.signl4.com\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/reports.jpg\",\"contentUrl\":\"https:\\\/\\\/www.signl4.com\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/reports.jpg\",\"width\":1200,\"height\":600,\"caption\":\"Reports\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/alarm-schicht-reports-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Alarm- und Schicht-Reports mit Microsoft Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/#website\",\"url\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/\",\"name\":\"DERDACK SIGNL4 - Mobile Alerting and Anywhere Incident Management\",\"description\":\"Mobile Alerting and Anywhere Incident Management\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/#organization\"},\"alternateName\":\"DERDACK SIGNL4\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/#organization\",\"name\":\"Derdack GmbH\",\"alternateName\":\"Derdack Corp\",\"url\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.signl4.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/SIGNL4_Logo_rounded_neu.png\",\"contentUrl\":\"https:\\\/\\\/www.signl4.com\\\/wp-content\\\/uploads\\\/2022\\\/05\\\/SIGNL4_Logo_rounded_neu.png\",\"width\":1000,\"height\":500,\"caption\":\"Derdack GmbH\"},\"image\":{\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"description\":\"Derdack is a bootstrapped innovator in alert management, communication automation and incident management. SIGNL4 is our SaaS product, empowering operations teams with mobile alerting and anywhere incident management.\",\"email\":\"hello@signl4.com\",\"legalName\":\"Derdack GmbH\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/#\\\/schema\\\/person\\\/0a1a343b12e5afad11dbbf81fd864c13\",\"name\":\"derdacksignl4\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ae6fcaa0f7053a04ca9d3c41e69b1654f10a02fe2d5835e2ddadd44198248642?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ae6fcaa0f7053a04ca9d3c41e69b1654f10a02fe2d5835e2ddadd44198248642?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ae6fcaa0f7053a04ca9d3c41e69b1654f10a02fe2d5835e2ddadd44198248642?s=96&d=mm&r=g\",\"caption\":\"derdacksignl4\"},\"sameAs\":[\"https:\\\/\\\/www.signl4.com\"],\"url\":\"https:\\\/\\\/www.signl4.com\\\/de\\\/blog\\\/author\\\/derdacksignl4\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Alarm- und Schicht-Reports mit Microsoft Excel","description":"SIGNL4 stellt Reporting-Daten f\u00fcr Bereitschaftszeiten und Alarme zur Verf\u00fcgung. In diesem Blogpost erfahrt ihr alles dar\u00fcber.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/","og_locale":"de_DE","og_type":"article","og_title":"Alarm- und Schicht-Reports mit Microsoft Excel","og_description":"SIGNL4 stellt Reporting-Daten f\u00fcr Bereitschaftszeiten und Alarme zur Verf\u00fcgung. In diesem Blogpost erfahrt ihr alles dar\u00fcber.","og_url":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/","og_site_name":"DERDACK SIGNL4","article_published_time":"2019-01-09T16:08:10+00:00","article_modified_time":"2024-05-24T09:56:17+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/reports.jpg","type":"image\/jpeg"}],"author":"derdacksignl4","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"derdacksignl4","Gesch\u00e4tzte Lesezeit":"4\u00a0Minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/#article","isPartOf":{"@id":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/"},"author":{"name":"derdacksignl4","@id":"https:\/\/www.signl4.com\/de\/#\/schema\/person\/0a1a343b12e5afad11dbbf81fd864c13"},"headline":"Alarm- und Schicht-Reports mit Microsoft Excel","datePublished":"2019-01-09T16:08:10+00:00","dateModified":"2024-05-24T09:56:17+00:00","mainEntityOfPage":{"@id":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/"},"wordCount":810,"commentCount":0,"publisher":{"@id":"https:\/\/www.signl4.com\/de\/#organization"},"image":{"@id":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/reports.jpg","inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/","url":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/","name":"Alarm- und Schicht-Reports mit Microsoft Excel","isPartOf":{"@id":"https:\/\/www.signl4.com\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/reports.jpg","datePublished":"2019-01-09T16:08:10+00:00","dateModified":"2024-05-24T09:56:17+00:00","description":"SIGNL4 stellt Reporting-Daten f\u00fcr Bereitschaftszeiten und Alarme zur Verf\u00fcgung. In diesem Blogpost erfahrt ihr alles dar\u00fcber.","breadcrumb":{"@id":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/#primaryimage","url":"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/reports.jpg","contentUrl":"https:\/\/www.signl4.com\/wp-content\/uploads\/2019\/01\/reports.jpg","width":1200,"height":600,"caption":"Reports"},{"@type":"BreadcrumbList","@id":"https:\/\/www.signl4.com\/de\/blog\/alarm-schicht-reports-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.signl4.com\/de\/"},{"@type":"ListItem","position":2,"name":"Alarm- und Schicht-Reports mit Microsoft Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.signl4.com\/de\/#website","url":"https:\/\/www.signl4.com\/de\/","name":"DERDACK SIGNL4 - Mobile Alerting and Anywhere Incident Management","description":"Mobile Alerting and Anywhere Incident Management","publisher":{"@id":"https:\/\/www.signl4.com\/de\/#organization"},"alternateName":"DERDACK SIGNL4","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.signl4.com\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/www.signl4.com\/de\/#organization","name":"Derdack GmbH","alternateName":"Derdack Corp","url":"https:\/\/www.signl4.com\/de\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.signl4.com\/de\/#\/schema\/logo\/image\/","url":"https:\/\/www.signl4.com\/wp-content\/uploads\/2022\/05\/SIGNL4_Logo_rounded_neu.png","contentUrl":"https:\/\/www.signl4.com\/wp-content\/uploads\/2022\/05\/SIGNL4_Logo_rounded_neu.png","width":1000,"height":500,"caption":"Derdack GmbH"},"image":{"@id":"https:\/\/www.signl4.com\/de\/#\/schema\/logo\/image\/"},"description":"Derdack is a bootstrapped innovator in alert management, communication automation and incident management. SIGNL4 is our SaaS product, empowering operations teams with mobile alerting and anywhere incident management.","email":"hello@signl4.com","legalName":"Derdack GmbH"},{"@type":"Person","@id":"https:\/\/www.signl4.com\/de\/#\/schema\/person\/0a1a343b12e5afad11dbbf81fd864c13","name":"derdacksignl4","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/ae6fcaa0f7053a04ca9d3c41e69b1654f10a02fe2d5835e2ddadd44198248642?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ae6fcaa0f7053a04ca9d3c41e69b1654f10a02fe2d5835e2ddadd44198248642?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ae6fcaa0f7053a04ca9d3c41e69b1654f10a02fe2d5835e2ddadd44198248642?s=96&d=mm&r=g","caption":"derdacksignl4"},"sameAs":["https:\/\/www.signl4.com"],"url":"https:\/\/www.signl4.com\/de\/blog\/author\/derdacksignl4\/"}]}},"_links":{"self":[{"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/posts\/4025","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/comments?post=4025"}],"version-history":[{"count":3,"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/posts\/4025\/revisions"}],"predecessor-version":[{"id":20707,"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/posts\/4025\/revisions\/20707"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/media\/17404"}],"wp:attachment":[{"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/media?parent=4025"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/categories?post=4025"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.signl4.com\/de\/wp-json\/wp\/v2\/tags?post=4025"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}