Zuletzt bearbeitet vor 5 Monaten
von Claus Schönfelder

Vorlage:KPI Monthly: Unterschied zwischen den Versionen

Keine Kategorien vergebenBearbeiten
Claus Schönfelder (Diskussion | Beiträge)
K 1 Version importiert
Claus Schönfelder (Diskussion | Beiträge)
K 1 Version importiert
 
(Eine dazwischenliegende Version von einem anderen Benutzer wird nicht angezeigt)
Zeile 1: Zeile 1:
<noinclude>
<noinclude>
This is the template "KPI Monthly" (English Key Performance Indicator) Created on 16.04.25, Last edits 10.06.25 Vers 1.5 Instance EM.
This is the template "KPI Monthly" (English Key Performance Indicator) Created on 16.04.25, Last edits 19.11.25 Vers 1.9 Instance Insights.
Click on "Edit", to view the source code of the template.
Click on "Edit", to view the source code of the template.
This is a wrapper for the  templates. Use:
This is a wrapper for the  templates. Use:
Zeile 8: Zeile 8:


{|class="cuscosky" style="width: 80%;"
{|class="cuscosky" style="width: 80%;"
!style="text-align: center;" colspan="4"|[[IT:Anwendungen/Wiki/Semantik/Planung-KPI|KPI Monthly]] 1.5.1
!style="text-align: center;" colspan="4"|[[IT:Anwendungen/Wiki/Semantik/Planung-KPI|KPI Monthly 1.9]]
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Jahr|Jahr]]:  
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Jahr|Jahr]]:  
|style="text-align: center;" colspan="1"|[[KPI/Jahr::{{{Jahr|}}}]]
|style="text-align: center;" colspan="1"|[[KPI/Jahr::{{{Jahr|}}}]]
Zeile 14: Zeile 14:
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Status|Status]]:  
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Status|Status]]:  
|style="width: 10%; text-align: left;"|[[KPI/Status::{{{Status|}}}]]
|style="width: 10%; text-align: left;"|[[KPI/Status::{{{Status|}}}]]
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Type|Type]]:  
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Entity|Entity]]:  
|style="width: 10%; text-align: left;"|[[KPI/Type::{{{Type|}}}]]
|style="width: 10%; text-align: left;"|[[KPI/Entity::{{{Entity|}}}]]
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Sub-Type|Sub-Type]]:
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Sub-Entity|Sub-Entity]]:
|style="width: 10%; text-align: left;"|{{#if:{{{Customer-Sub|}}}|[[KPI/Customer-Sub::{{{Customer-Sub}}}]][[KPI/Sub-Type::{{{Customer-Sub|}}}|]]}}{{#if:{{{Human-Resources-Sub|}}}|[[KPI/Human-Resources-Sub::{{{Human-Resources-Sub}}}]][[KPI/Sub-Type::{{{Human-Resources-Sub|}}}|]]}}{{#if:{{{Financial-Sub|}}}|[[KPI/Financial-Sub::{{{Financial-Sub}}}]][[KPI/Sub-Type::{{{Financial-Sub|}}}|]]}}{{#if:{{{Sales-Sub|}}}|[[KPI/Sales-Sub::{{{Sales-Sub}}}]][[KPI/Sub-Type::{{{Sales-Sub|}}}|]]}}{{#if:{{{Operations-Sub|}}}|[[KPI/Operations-Sub::{{{Operations-Sub}}}]][[KPI/Sub-Type::{{{Operations-Sub|}}}|]]}}{{#if:{{{Environmental-Sub|}}}|[[KPI/Environmental-Sub::{{{Environmental-Sub}}}]][[KPI/Sub-Type::{{{Environmental-Sub|}}}|]]}}
|style="width: 10%; text-align: left;"|{{#if:{{{Umsatz-Sub|}}}|[[KPI/Umsatz-Sub::{{{Umsatz-Sub}}}]][[KPI/Sub-Entity::{{{Umsatz-Sub|}}}|]]}}{{#if:{{{Kosten-Sub|}}}|[[KPI/Kosten-Sub::{{{Kosten-Sub}}}]][[KPI/Sub-Entity::{{{Kosten-Sub|}}}|]]}}{{#if:{{{MA-Sub|}}}|[[KPI/MA-Sub::{{{MA-Sub}}}]][[KPI/Sub-Entity::{{{MA-Sub|}}}|]]}}{{#if:{{{Gehälter-Sub|}}}|[[KPI/Gehälter-Sub::{{{Gehälter-Sub}}}]][[KPI/Sub-Entity::{{{Gehälter-Sub|}}}|]]}}{{#if:{{{Steuern-Sub|}}}|[[KPI/Steuern-Sub::{{{Steuern-Sub}}}]][[KPI/Sub-Entity::{{{Steuern-Sub|}}}|]]}}{{#if:{{{Angebote-Sub|}}}|[[KPI/Angebote-Sub::{{{Angebote-Sub}}}]][[KPI/Sub-Entity::{{{Angebote-Sub|}}}|]]}}{{#if:{{{TVOs-Sub|}}}|[[KPI/TVOs-Sub::{{{TVOs-Sub}}}]][[KPI/Sub-Entity::{{{TVOs-Sub|}}}|]]}}{{#if:{{{WebConfs-Sub|}}}|[[KPI/WebConfs-Sub::{{{WebConfs-Sub}}}]][[KPI/Sub-Entity::{{{WebConfs-Sub|}}}|]]}}{{#if:{{{Steuerberater-Sub|}}}|[[KPI/Steuerberater-Sub::{{{Steuerberater-Sub}}}]][[KPI/Sub-Entity::{{{Steuerberater-Sub|}}}|]]}}{{#if:{{{MieteNK-Sub|}}}|[[KPI/MieteNK-Sub::{{{MieteNK-Sub}}}]][[KPI/Sub-Entity::{{{MieteNK-Sub|}}}|]]}}{{#if:{{{AZNW-Sub|}}}|[[KPI/AZNW-Sub::{{{AZNW-Sub}}}]][[KPI/Sub-Entity::{{{AZNW-Sub|}}}|]]}}{{#if:{{{AZNW-Faktura-Sub|}}}|[[KPI/AZNW-Faktura-Sub::{{{AZNW-Faktura-Sub}}}]][[KPI/Sub-Entity::{{{AZNW-Faktura-Sub|}}}|]]}}{{#if:{{{Service-Sub|}}}|[[KPI/Service-Sub::{{{Service-Sub}}}]][[KPI/Sub-Entity::{{{Service-Sub|}}}|]]}}{{#if:{{{Sonstiges-Sub|}}}|[[KPI/Sonstiges-Sub::{{{Sonstiges-Sub}}}]][[KPI/Sub-Entity::{{{Sonstiges-Sub|}}}|]]}}{{#if:{{{Kreditoren-Sub|}}}|[[KPI/Kreditoren-Sub::{{{Kreditoren-Sub}}}]][[KPI/Sub-Entity::{{{Kreditoren-Sub|}}}|]]}}{{#if:{{{Kundenzufriedenheit-Sub|}}}|[[KPI/Kundenzufriedenheit-Sub::{{{Kundenzufriedenheit-Sub}}}]][[KPI/Sub-Entity::{{{Kundenzufriedenheit-Sub|}}}|]]}}{{#if:{{{Customer-Sub|}}}|[[KPI/Customer-Sub::{{{Customer-Sub}}}]][[KPI/Sub-Entity::{{{Customer-Sub|}}}|]]}}{{#if:{{{Human-Resources-Sub|}}}|[[KPI/Human-Resources-Sub::{{{Human-Resources-Sub}}}]][[KPI/Sub-Entity::{{{Human-Resources-Sub|}}}|]]}}{{#if:{{{Financial-Sub|}}}|[[KPI/Financial-Sub::{{{Financial-Sub}}}]][[KPI/Sub-Entity::{{{Financial-Sub|}}}|]]}}{{#if:{{{Sales-Sub|}}}|[[KPI/Sales-Sub::{{{Sales-Sub}}}]][[KPI/Sub-Entity::{{{Sales-Sub|}}}|]]}}{{#if:{{{Operations-Sub|}}}|[[KPI/Operations-Sub::{{{Operations-Sub}}}]][[KPI/Sub-Entity::{{{Operations-Sub|}}}|]]}}{{#if:{{{Environmental-Sub|}}}|[[KPI/Environmental-Sub::{{{Environmental-Sub}}}]][[KPI/Sub-Entity::{{{Environmental-Sub|}}}|]]}}{{#if:{{{EM-Sub|}}}|[[KPI/EM-Sub::{{{EM-Sub}}}]][[KPI/Sub-Entity::{{{EM-Sub|}}}|]]}}{{#if:{{{Wiki-Sub|}}}|[[KPI/Wiki-Sub::{{{Wiki-Sub}}}]][[KPI/Sub-Entity::{{{Wiki-Sub|}}}|]]}}{{#if:{{{Akquise-Sub|}}}|[[KPI/Akquise-Sub::{{{Akquise-Sub}}}]][[KPI/Sub-Entity::{{{Akquise-Sub|}}}|]]}}{{#if:{{{Marketing-Sub|}}}|[[KPI/Marketing-Sub::{{{Marketing-Sub}}}]][[KPI/Sub-Entity::{{{Marketing-Sub|}}}|]]}}{{#if:{{{Insights-Sub|}}}|[[KPI/Insights-Sub::{{{Insights-Sub}}}]][[KPI/Sub-Entity::{{{Insights-Sub|}}}|]]}}{{#if:{{{Compliance-Sub|}}}|[[KPI/Compliance-Sub::{{{Compliance-Sub}}}]][[KPI/Sub-Entity::{{{Compliance-Sub|}}}|]]}}{{#if:{{{Semantik-Sub|}}}|[[KPI/Semantik-Sub::{{{Semantik-Sub}}}]][[KPI/Sub-Entity::{{{Semantik-Sub|}}}|]]}}
|-
|-
!style="width: 10%; text-align: left;"|Januar:
!style="width: 10%; text-align: left;"|Januar:
|style="text-align: left;"|[[KPI/1::{{{1|}}}]]
|style="width: 23%; text-align: left;"|[[KPI/1::{{{Januar|}}}]]
!style="width: 10%; text-align: left;"|Februar:
!style="width: 10%; text-align: left;"|Februar:
|style="text-align: left;"|[[KPI/2::{{{2|}}}]]
|style="width: 23%; text-align: left;"|[[KPI/2::{{{Februar|}}}]]
!style="width: 10%; text-align: left;"|März:
!style="width: 10%; text-align: left;"|März:
|style="text-align: left;"|[[KPI/3::{{{3|}}}]]
|style="width: 23%; text-align: left;"|[[KPI/3::{{{März|}}}]]
|-
|-
!style="width: 10%; text-align: left;"|April:
!style="width: 10%; text-align: left;"|April:
|style="text-align: left;"|[[KPI/4::{{{4|}}}]]
|style="text-align: left;"|[[KPI/4::{{{April|}}}]]
!style="width: 10%; text-align: left;"|Mai:
!style="width: 10%; text-align: left;"|Mai:
|style="text-align: left;"|[[KPI/5::{{{5|}}}]]
|style="text-align: left;"|[[KPI/5::{{{Mai|}}}]]
!style="width: 10%; text-align: left;"|Juni:
!style="width: 10%; text-align: left;"|Juni:
|style="text-align: left;"|[[KPI/6::{{{6|}}}]]
|style="text-align: left;"|[[KPI/6::{{{Juni|}}}]]
|-
|-
!style="width: 10%; text-align: left;"|Juli:  
!style="width: 10%; text-align: left;"|Juli:  
|style="text-align: left;"|[[KPI/7::{{{7|}}}]]
|style="text-align: left;"|[[KPI/7::{{{Juli|}}}]]
!style="width: 10%; text-align: left;"|August:
!style="width: 10%; text-align: left;"|August:
|style="text-align: left;"|[[KPI/8::{{{8|}}}]]
|style="text-align: left;"|[[KPI/8::{{{August|}}}]]
!style="width: 10%; text-align: left;"|September:
!style="width: 10%; text-align: left;"|September:
|style="text-align: left;"|[[KPI/9::{{{9|}}}]]
|style="text-align: left;"|[[KPI/9::{{{September|}}}]]
|-
|-
!style="width: 10%; text-align: left;"|Oktober:  
!style="width: 10%; text-align: left;"|Oktober:  
|style="text-align: left;"|[[KPI/10::{{{10|}}}]]
|style="text-align: left;"|[[KPI/10::{{{Oktober|}}}]]
!style="width: 10%; text-align: left;"|November:
!style="width: 10%; text-align: left;"|November:
|style="text-align: left;"|[[KPI/11::{{{11|}}}]]
|style="text-align: left;"|[[KPI/11::{{{November|}}}]]
!style="width: 10%; text-align: left;"|Dezember:
!style="width: 10%; text-align: left;"|Dezember:
|style="text-align: left;"|[[KPI/12::{{{12|}}}]]
|style="text-align: left;"|[[KPI/12::{{{Dezember|}}}]]
|-
|-
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Sum|Sum]]:
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Summe|Summe]]:
|style="text-align: left;"|[[KPI/Sum::{{#expr:
|style="text-align: left;"|[[KPI/Summe::{{#replace:{{#expr:
   {{#iferror:{{{1|0}}}|0}} + {{#iferror:{{{2|0}}}|0}} + {{#iferror:{{{3|0}}}|0}} +
   {{#if:{{{Januar|}}}|{{#replace:{{{Januar}}}|,|.}}|0}} +
   {{#iferror:{{{4|0}}}|0}} + {{#iferror:{{{5|0}}}|0}} + {{#iferror:{{{6|0}}}|0}} +
  {{#if:{{{Februar|}}}|{{#replace:{{{Februar}}}|,|.}}|0}} +
   {{#iferror:{{{7|0}}}|0}} + {{#iferror:{{{8|0}}}|0}} + {{#iferror:{{{9|0}}}|0}} +
  {{#if:{{{März|}}}|{{#replace:{{{März}}}|,|.}}|0}} +
   {{#iferror:{{{10|0}}}|0}} + {{#iferror:{{{11|0}}}|0}} + {{#iferror:{{{12|0}}}|0}}}}]]
  {{#if:{{{April|}}}|{{#replace:{{{April}}}|,|.}}|0}} +
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Average|Average]]:
  {{#if:{{{Mai|}}}|{{#replace:{{{Mai}}}|,|.}}|0}} +
|style="text-align: left;"|[[KPI/Average::{{#expr: (
  {{#if:{{{Juni|}}}|{{#replace:{{{Juni}}}|,|.}}|0}} +
  {{#iferror:{{{1|0}}}|0}} + {{#iferror:{{{2|0}}}|0}} + {{#iferror:{{{3|0}}}|0}} +
   {{#if:{{{Juli|}}}|{{#replace:{{{Juli}}}|,|.}}|0}} +
  {{#iferror:{{{4|0}}}|0}} + {{#iferror:{{{5|0}}}|0}} + {{#iferror:{{{6|0}}}|0}} +
  {{#if:{{{August|}}}|{{#replace:{{{August}}}|,|.}}|0}} +
  {{#iferror:{{{7|0}}}|0}} + {{#iferror:{{{8|0}}}|0}} + {{#iferror:{{{9|0}}}|0}} +
  {{#if:{{{September|}}}|{{#replace:{{{September}}}|,|.}}|0}} +
   {{#iferror:{{{10|0}}}|0}} + {{#iferror:{{{11|0}}}|0}} + {{#iferror:{{{12|0}}}|0}})  
  {{#if:{{{Oktober|}}}|{{#replace:{{{Oktober}}}|,|.}}|0}} +
  / ({{#expr:
  {{#if:{{{November|}}}|{{#replace:{{{November}}}|,|.}}|0}} +
    {{#if:{{{1|}}}|1|0}} + {{#if:{{{2|}}}|1|0}} + {{#if:{{{3|}}}|1|0}} +
  {{#if:{{{Dezember|}}}|{{#replace:{{{Dezember}}}|,|.}}|0}}
    {{#if:{{{4|}}}|1|0}} + {{#if:{{{5|}}}|1|0}} + {{#if:{{{6|}}}|1|0}} +
}}|.|,}}|{{formatnum:{{#expr:
    {{#if:{{{7|}}}|1|0}} + {{#if:{{{8|}}}|1|0}} + {{#if:{{{9|}}}|1|0}} +
  {{#if:{{{Januar|}}}|{{#replace:{{{Januar}}}|,|.}}|0}} +
    {{#if:{{{10|}}}|1|0}} + {{#if:{{{11|}}}|1|0}} + {{#if:{{{12|}}}|1|0}}}}
   {{#if:{{{Februar|}}}|{{#replace:{{{Februar}}}|,|.}}|0}} +
  ) round 2}}]]
  {{#if:{{{März|}}}|{{#replace:{{{März}}}|,|.}}|0}} +
  {{#if:{{{April|}}}|{{#replace:{{{April}}}|,|.}}|0}} +
  {{#if:{{{Mai|}}}|{{#replace:{{{Mai}}}|,|.}}|0}} +
  {{#if:{{{Juni|}}}|{{#replace:{{{Juni}}}|,|.}}|0}} +
  {{#if:{{{Juli|}}}|{{#replace:{{{Juli}}}|,|.}}|0}} +
   {{#if:{{{August|}}}|{{#replace:{{{August}}}|,|.}}|0}} +
  {{#if:{{{September|}}}|{{#replace:{{{September}}}|,|.}}|0}} +
  {{#if:{{{Oktober|}}}|{{#replace:{{{Oktober}}}|,|.}}|0}} +
  {{#if:{{{November|}}}|{{#replace:{{{November}}}|,|.}}|0}} +
  {{#if:{{{Dezember|}}}|{{#replace:{{{Dezember}}}|,|.}}|0}}
}}}}]]
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Durchschnitt|Durchschnitt]]:
|style="text-align: left;"|[[KPI/Durchschnitt::{{#replace:{{#ifexpr:
  {{#expr:
    {{#if:{{{Januar|}}}|1|0}} +
    {{#if:{{{Februar|}}}|1|0}} +
    {{#if:{{{März|}}}|1|0}} +
    {{#if:{{{April|}}}|1|0}} +
    {{#if:{{{Mai|}}}|1|0}} +
    {{#if:{{{Juni|}}}|1|0}} +
    {{#if:{{{Juli|}}}|1|0}} +
    {{#if:{{{August|}}}|1|0}} +
    {{#if:{{{September|}}}|1|0}} +
    {{#if:{{{Oktober|}}}|1|0}} +
    {{#if:{{{November|}}}|1|0}} +
    {{#if:{{{Dezember|}}}|1|0}}
  }} > 0
  | {{#expr: (
        {{#if:{{{Januar|}}}  | {{#replace:{{{Januar}}}  |,|.}} | 0}} +
        {{#if:{{{Februar|}}}  | {{#replace:{{{Februar}}}  |,|.}} | 0}} +
        {{#if:{{{März|}}}    | {{#replace:{{{März}}}    |,|.}} | 0}} +
        {{#if:{{{April|}}}    | {{#replace:{{{April}}}    |,|.}} | 0}} +
        {{#if:{{{Mai|}}}      | {{#replace:{{{Mai}}}      |,|.}} | 0}} +
        {{#if:{{{Juni|}}}    | {{#replace:{{{Juni}}}    |,|.}} | 0}} +
        {{#if:{{{Juli|}}}    | {{#replace:{{{Juli}}}    |,|.}} | 0}} +
        {{#if:{{{August|}}}   | {{#replace:{{{August}}}  |,|.}} | 0}} +
        {{#if:{{{September|}}}| {{#replace:{{{September}}}|,|.}} | 0}} +
        {{#if:{{{Oktober|}}}  | {{#replace:{{{Oktober}}}  |,|.}} | 0}} +
        {{#if:{{{November|}}} | {{#replace:{{{November}}} |,|.}} | 0}} +
        {{#if:{{{Dezember|}}} | {{#replace:{{{Dezember}}} |,|.}} | 0}}
      ) /
      ({{#expr:
        {{#if:{{{Januar|}}}|1|0}} +
        {{#if:{{{Februar|}}}|1|0}} +
        {{#if:{{{März|}}}|1|0}} +
        {{#if:{{{April|}}}|1|0}} +
        {{#if:{{{Mai|}}}|1|0}} +
        {{#if:{{{Juni|}}}|1|0}} +
        {{#if:{{{Juli|}}}|1|0}} +
        {{#if:{{{August|}}}|1|0}} +
        {{#if:{{{September|}}}|1|0}} +
        {{#if:{{{Oktober|}}}|1|0}} +
        {{#if:{{{November|}}}|1|0}} +
        {{#if:{{{Dezember|}}}|1|0}}
      }})
      round 2
    }}
  | 0
}}|.|,}}]]
|}
 
{|class="cuscosky" style="width: 80%;"
!style="width: 10%; text-align: left;" | [[Grundlagen:Semantik/WVL|WVL]]:
|style="width: 23%; text-align: left;" |[[KPI/WVL::{{#time:Y-m-d|{{{WVL|}}}}}]] 
!style="width: 10%; text-align: left;" |[[Grundlagen:KPI/Article|Wiki Artikel]]: 
|style="width: 23%; text-align: left;" |[[KPI/Article::{{{Article|}}}]]
!style="width: 10%; text-align: left;" |[[Grundlagen:KPI/Owner|Owner]]:
|style="width: 23%; text-align: left;"|[[KPI/Owner::{{PAGENAME:{{{Owner|}}}}}]]
|-
|-
![[Grundlagen:Semantik/WVL|WVL]]:  
!style="width: 10%; text-align: left;"|Created on:
|style="width: 15%; text-align: left;"colspan="1"|[[KPI/WVL::{{#time:Y/m/d|{{{WVL|}}}}}]] 
|style="width: 23%; text-align: left;"|{{#show: {{FULLPAGENAME}}|?Creation date#-F[Y-m-d]}}
!style="width: 10%; text-align: left;"|[[Grundlagen:Semantic/Form/Article|Wiki Artikel]]:
!style="width: 10%; text-align: left;"| Last Editor:
|style="text-align: left;"|[[KPI/Article::{{{Article|}}}]]
|style="text-align: left;"|{{REVISIONUSER}}
!style="width: 10%; text-align: left;"|Created by:
!style="width: 10%; text-align: left;" |[[Grundlagen:KPI/Delegated|Delegated]]:
|style="text-align: left;"|[[KPI/Created by::{{{Created by|}}}]]
|style="width: 23%; text-align: left;" |[[KPI/Delegated::{{{Delegated|}}}]]
|-
|-
!style="width: 10%; text-align: left;"|Created on:
|style="text-align: left;"|[[KPI/Created on::{{#time:Y/m/d|{{{Created on|}}}}}]] 
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Owner|Owner]]:
|style="text-align: left;"|[[KPI/Owner::{{{Owner|}}}]]
!style="width: 10%; text-align: left;"|[[Grundlagen:KPI/Delegated|Delegated]]:
|style="text-align: left;"|[[KPI/Delegated::{{{Delegated|}}}]]
|-
[[Category:KPIMonthly||KPI]]
|}
|}
 
[[Kategorie:KPIMonthly]][[Kategorie:KPI]]
{{#arraymap:{{{Categories|}}}|,|@@@|[[Category:@@@]]|}}
</includeonly>
{{DISPLAYTITLE:{{{Type|}}}}}
{{DISPLAYTITLE:{{{Entity|}}}}}
{{{Graphic|}}}
{{{Graphic|}}}
</includeonly>

Aktuelle Version vom 5. Dezember 2025, 09:23 Uhr

This is the template "KPI Monthly" (English Key Performance Indicator) Created on 16.04.25, Last edits 19.11.25 Vers 1.9 Instance Insights. Click on "Edit", to view the source code of the template. This is a wrapper for the templates. Use:

KPI Monthly