Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@NikolaiRuhe
Created April 23, 2015 17:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save NikolaiRuhe/e77839f47508f8933df8 to your computer and use it in GitHub Desktop.
Save NikolaiRuhe/e77839f47508f8933df8 to your computer and use it in GitHub Desktop.
<sheet id="main_sheet" meta:month_id="201504" meta:refname="main_sheet">
<section visibility="hidden" meta:timesec.expression="self">
<datefield meta:time="0">1983-11-22T23:00:00Z</datefield>
<datefield meta:time="0.25">1983-11-22T23:15:00Z</datefield>
<datefield meta:time="0.5">1983-11-22T23:30:00Z</datefield>
<datefield meta:time="0.75">1983-11-22T23:45:00Z</datefield>
<datefield meta:time="1">1983-11-23T00:00:00Z</datefield>
<datefield meta:time="1.25">1983-11-23T00:15:00Z</datefield>
<datefield meta:time="1.5">1983-11-23T00:30:00Z</datefield>
<datefield meta:time="1.75">1983-11-23T00:45:00Z</datefield>
<datefield meta:time="2">1983-11-23T01:00:00Z</datefield>
<datefield meta:time="2.25">1983-11-23T01:15:00Z</datefield>
<datefield meta:time="2.5">1983-11-23T01:30:00Z</datefield>
<datefield meta:time="2.75">1983-11-23T01:45:00Z</datefield>
<datefield meta:time="3">1983-11-23T02:00:00Z</datefield>
<datefield meta:time="3.25">1983-11-23T02:15:00Z</datefield>
<datefield meta:time="3.5">1983-11-23T02:30:00Z</datefield>
<datefield meta:time="3.75">1983-11-23T02:45:00Z</datefield>
<datefield meta:time="4">1983-11-23T03:00:00Z</datefield>
<datefield meta:time="4.25">1983-11-23T03:15:00Z</datefield>
<datefield meta:time="4.5">1983-11-23T03:30:00Z</datefield>
<datefield meta:time="4.75">1983-11-23T03:45:00Z</datefield>
<datefield meta:time="5">1983-11-23T04:00:00Z</datefield>
<datefield meta:time="5.25">1983-11-23T04:15:00Z</datefield>
<datefield meta:time="5.5">1983-11-23T04:30:00Z</datefield>
<datefield meta:time="5.75">1983-11-23T04:45:00Z</datefield>
<datefield meta:time="6">1983-11-23T05:00:00Z</datefield>
<datefield meta:time="6.25">1983-11-23T05:15:00Z</datefield>
<datefield meta:time="6.5">1983-11-23T05:30:00Z</datefield>
<datefield meta:time="6.75">1983-11-23T05:45:00Z</datefield>
<datefield meta:time="7">1983-11-23T06:00:00Z</datefield>
<datefield meta:time="7.25">1983-11-23T06:15:00Z</datefield>
<datefield meta:time="7.5">1983-11-23T06:30:00Z</datefield>
<datefield meta:time="7.75">1983-11-23T06:45:00Z</datefield>
<datefield meta:time="8">1983-11-23T07:00:00Z</datefield>
<datefield meta:time="8.25">1983-11-23T07:15:00Z</datefield>
<datefield meta:time="8.5">1983-11-23T07:30:00Z</datefield>
<datefield meta:time="8.75">1983-11-23T07:45:00Z</datefield>
<datefield meta:time="9">1983-11-23T08:00:00Z</datefield>
<datefield meta:time="9.25">1983-11-23T08:15:00Z</datefield>
<datefield meta:time="9.5">1983-11-23T08:30:00Z</datefield>
<datefield meta:time="9.75">1983-11-23T08:45:00Z</datefield>
<datefield meta:time="10">1983-11-23T09:00:00Z</datefield>
<datefield meta:time="10.25">1983-11-23T09:15:00Z</datefield>
<datefield meta:time="10.5">1983-11-23T09:30:00Z</datefield>
<datefield meta:time="10.75">1983-11-23T09:45:00Z</datefield>
<datefield meta:time="11">1983-11-23T10:00:00Z</datefield>
<datefield meta:time="11.25">1983-11-23T10:15:00Z</datefield>
<datefield meta:time="11.5">1983-11-23T10:30:00Z</datefield>
<datefield meta:time="11.75">1983-11-23T10:45:00Z</datefield>
<datefield meta:time="12">1983-11-23T11:00:00Z</datefield>
<datefield meta:time="12.25">1983-11-23T11:15:00Z</datefield>
<datefield meta:time="12.5">1983-11-23T11:30:00Z</datefield>
<datefield meta:time="12.75">1983-11-23T11:45:00Z</datefield>
<datefield meta:time="13">1983-11-23T12:00:00Z</datefield>
<datefield meta:time="13.25">1983-11-23T12:15:00Z</datefield>
<datefield meta:time="13.5">1983-11-23T12:30:00Z</datefield>
<datefield meta:time="13.75">1983-11-23T12:45:00Z</datefield>
<datefield meta:time="14">1983-11-23T13:00:00Z</datefield>
<datefield meta:time="14.25">1983-11-23T13:15:00Z</datefield>
<datefield meta:time="14.5">1983-11-23T13:30:00Z</datefield>
<datefield meta:time="14.75">1983-11-23T13:45:00Z</datefield>
<datefield meta:time="15">1983-11-23T14:00:00Z</datefield>
<datefield meta:time="15.25">1983-11-23T14:15:00Z</datefield>
<datefield meta:time="15.5">1983-11-23T14:30:00Z</datefield>
<datefield meta:time="15.75">1983-11-23T14:45:00Z</datefield>
<datefield meta:time="16">1983-11-23T15:00:00Z</datefield>
<datefield meta:time="16.25">1983-11-23T15:15:00Z</datefield>
<datefield meta:time="16.5">1983-11-23T15:30:00Z</datefield>
<datefield meta:time="16.75">1983-11-23T15:45:00Z</datefield>
<datefield meta:time="17">1983-11-23T16:00:00Z</datefield>
<datefield meta:time="17.25">1983-11-23T16:15:00Z</datefield>
<datefield meta:time="17.5">1983-11-23T16:30:00Z</datefield>
<datefield meta:time="17.75">1983-11-23T16:45:00Z</datefield>
<datefield meta:time="18">1983-11-23T17:00:00Z</datefield>
<datefield meta:time="18.25">1983-11-23T17:15:00Z</datefield>
<datefield meta:time="18.5">1983-11-23T17:30:00Z</datefield>
<datefield meta:time="18.75">1983-11-23T17:45:00Z</datefield>
<datefield meta:time="19">1983-11-23T18:00:00Z</datefield>
<datefield meta:time="19.25">1983-11-23T18:15:00Z</datefield>
<datefield meta:time="19.5">1983-11-23T18:30:00Z</datefield>
<datefield meta:time="19.75">1983-11-23T18:45:00Z</datefield>
<datefield meta:time="20">1983-11-23T19:00:00Z</datefield>
<datefield meta:time="20.25">1983-11-23T19:15:00Z</datefield>
<datefield meta:time="20.5">1983-11-23T19:30:00Z</datefield>
<datefield meta:time="20.75">1983-11-23T19:45:00Z</datefield>
<datefield meta:time="21">1983-11-23T20:00:00Z</datefield>
<datefield meta:time="21.25">1983-11-23T20:15:00Z</datefield>
<datefield meta:time="21.5">1983-11-23T20:30:00Z</datefield>
<datefield meta:time="21.75">1983-11-23T20:45:00Z</datefield>
<datefield meta:time="22">1983-11-23T21:00:00Z</datefield>
<datefield meta:time="22.25">1983-11-23T21:15:00Z</datefield>
<datefield meta:time="22.5">1983-11-23T21:30:00Z</datefield>
<datefield meta:time="22.75">1983-11-23T21:45:00Z</datefield>
<datefield meta:time="23">1983-11-23T22:00:00Z</datefield>
<datefield meta:time="23.25">1983-11-23T22:15:00Z</datefield>
<datefield meta:time="23.5">1983-11-23T22:30:00Z</datefield>
<datefield meta:time="23.75">1983-11-23T22:45:00Z</datefield>
</section>
<section title="April 2015">
<textfield editable="false" span="1">Mo</textfield>
<textfield editable="false" span="1">Di</textfield>
<textfield editable="false" span="1">Mi</textfield>
<textfield editable="false" span="1">Do</textfield>
<textfield editable="false" span="1">Fr</textfield>
<textfield editable="false" span="1">Sa</textfield>
<textfield editable="false" span="1">So</textfield>
<textfield visibility="hidden"/>
<textfield editable="false" id="" span="1">30</textfield>
<textfield editable="false" id="" span="1">31</textfield>
<sheet id="sheet_d_2015-04-01" meta:date="2015-04-01" meta:refname="sheet" span="1" title="1">
<section title="01. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z" valid.expression="!self.empty and !(self.parent.siblings[0].fields[1] &gt; NUMBER(10))" tooltip.expression="self.valid ? '' : 'Feldinhalt darf nicht leer sein und erfasste Arbeitszeit darf nicht länger als 10 Stunden sein.'">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z" valid.expression="!self.empty and !(self.parent.siblings[0].fields[1] &gt; NUMBER(10))" tooltip.expression="self.valid ? '' : 'Feldinhalt darf nicht leer sein und erfasste Arbeitszeit darf nicht länger als 10 Stunden sein.'">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z" valid.expression="!self.empty and !self.parent.siblings[1].fields[0].empty ? self&gt;=self.parent.siblings[1].fields[0] : !self.empty" tooltip.expression="self.valid ? '' : 'Feldinhalt darf nicht leer sein und eingetragener Wert darf nicht vor dem erfassten Arbeitsbeginn liegen.'">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z" valid.expression="!self.empty and !self.parent.siblings[1].fields[1].empty and !(self.parent.siblings[1].fields[1]=self.parent.parent.parent.parent.firstChild.meta.timesec.children[0]) ? self&lt;=self.parent.siblings[1].fields[1] : !self.empty" tooltip.expression="self.valid ? '' : 'Feldinhalt darf nicht leer sein und eingetragener Wert darf nicht nach dem erfassten Arbeitsende liegen.'">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-02" meta:date="2015-04-02" meta:refname="sheet" span="1" title="2">
<section title="02. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-03" meta:date="2015-04-03" meta:refname="sheet" span="1" title="3">
<section title="03. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-04" meta:date="2015-04-04" meta:refname="sheet" span="1" title="4">
<section title="04. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-05" meta:date="2015-04-05" meta:refname="sheet" span="1" title="5">
<section title="05. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<textfield visibility="hidden"/>
<sheet id="sheet_d_2015-04-06" meta:date="2015-04-06" meta:refname="sheet" span="1" title="6">
<section title="06. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-07" meta:date="2015-04-07" meta:refname="sheet" span="1" title="7">
<section title="07. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-08" meta:date="2015-04-08" meta:refname="sheet" span="1" title="8">
<section title="08. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-09" meta:date="2015-04-09" meta:refname="sheet" span="1" title="9">
<section title="09. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-10" meta:date="2015-04-10" meta:refname="sheet" span="1" title="10">
<section title="10. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-11" meta:date="2015-04-11" meta:refname="sheet" span="1" title="11">
<section title="11. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-12" meta:date="2015-04-12" meta:refname="sheet" span="1" title="12">
<section title="12. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<textfield visibility="hidden"/>
<sheet id="sheet_d_2015-04-13" meta:date="2015-04-13" meta:refname="sheet" span="1" title="13">
<section title="13. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-14" meta:date="2015-04-14" meta:refname="sheet" span="1" title="14">
<section title="14. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-15" meta:date="2015-04-15" meta:refname="sheet" span="1" title="15">
<section title="15. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-16" meta:date="2015-04-16" meta:refname="sheet" span="1" title="16">
<section title="16. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-17" meta:date="2015-04-17" meta:refname="sheet" span="1" title="17">
<section title="17. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-18" meta:date="2015-04-18" meta:refname="sheet" span="1" title="18">
<section title="18. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-19" meta:date="2015-04-19" meta:refname="sheet" span="1" title="19">
<section title="19. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<textfield visibility="hidden"/>
<sheet id="sheet_d_2015-04-20" meta:date="2015-04-20" meta:refname="sheet" span="1" title="20">
<section title="20. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-21" meta:date="2015-04-21" meta:refname="sheet" span="1" title="21">
<section title="21. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-22" meta:date="2015-04-22" meta:refname="sheet" span="1" title="22">
<section title="22. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-23" meta:date="2015-04-23" meta:refname="sheet" span="1" title="23">
<section title="23. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-24" meta:date="2015-04-24" meta:refname="sheet" span="1" title="24">
<section title="24. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-25" meta:date="2015-04-25" meta:refname="sheet" span="1" title="25">
<section title="25. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-26" meta:date="2015-04-26" meta:refname="sheet" span="1" title="26">
<section title="26. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<textfield visibility="hidden"/>
<sheet id="sheet_d_2015-04-27" meta:date="2015-04-27" meta:refname="sheet" span="1" title="27">
<section title="27. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-28" meta:date="2015-04-28" meta:refname="sheet" span="1" title="28">
<section title="28. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-29" meta:date="2015-04-29" meta:refname="sheet" span="1" title="29">
<section title="29. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<sheet id="sheet_d_2015-04-30" meta:date="2015-04-30" meta:refname="sheet" span="1" title="30">
<section title="30. April 2015 - Überblick">
<numberfield decimaldigits="2" editable="false" meta:refname="h_SOLL" span="4" title="h SOLL" defaultValue="8">8</numberfield>
<numberfield decimaldigits="2" editable="false" meta:refname="h_IST" span="4" title="h IST" number.expression="(self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3] : 0) except NUMBER(0)" tooltip.expression="self.parent.parent.children[1].children[2] &gt;= 0 and self.parent.parent.children[1].children[3] &gt;= 0 and (self.parent.parent.children[1].children[2] - self.parent.parent.children[1].children[3]) &gt;=0 ? '' : 'Berechnung aufgrund negativer Zeitwerte nicht möglich. Bitte überprüfen Sie die erfasste Arbeitszeit und Pausen.'"/>
<numberfield decimaldigits="2" editable="false" meta:refname="h_SALDO" span="4" title="h Saldo" number.expression="self.previous - self.parent.children[1]"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"></numberfield>
<numberfield editable="false" span="4" title="km Anhänger"></numberfield>
<numberfield editable="false" span="4" title="km Beifahrer"></numberfield>
</section>
<section id="sec_work" title="Arbeitszeiterfassung">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" meta:refname="tim_begin" span="6" title="Arbeitsbeginn" defaultValue="1983-11-23T07:00:00Z">1983-11-23T07:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" meta:refname="tim_end" span="6" title="Arbeitsende" defaultValue="1983-11-23T16:00:00Z">1983-11-23T16:00:00Z</datefield>
<numberfield title="WORKTIME" visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children[0] ? NUMBER(24) : NUMBER(0)"/>
<numberfield title="SUMBREAKS" visibility="hidden" number.expression="(self.siblings[4].checked ? 0 : (self.parent.siblings[2].children[2].meta.sumbreak)) except NUMBER(0)"/>
<checkboxfield id="no_break" meta:refname="no_break" title="Keine Pause"/>
</section>
<section copyable="true" id="sec_break" visibility.expression="self.parent.children[1].fields[4].empty">
<datefield contenttype="time" id="tim_begin" minuteResolution="15" span="6" title="Pausenbeginn" defaultValue="1983-11-23T11:00:00Z">1983-11-23T11:00:00Z</datefield>
<datefield contenttype="time" id="tim_end" minuteResolution="15" span="6" title="Pausenende" defaultValue="1983-11-23T12:00:00Z">1983-11-23T12:00:00Z</datefield>
<numberfield visibility="hidden" number.expression="(self.parent.children[0].empty or self.parent.children[1].empty ? 0 : (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[1].date)[0].meta.time) + self.meta.midnight) - (NUMBER((self.parent.parent.parent.parent.firstChild.meta.timesec.children where child : child.date == self.parent.children[0].date)[0].meta.time))) except NUMBER(0)" meta:sumbreak.expression="(self.parent.next.id='sec_break') ? NUMBER((self) + (self.parent.next.children[2].meta.sumbreak)) : NUMBER(self)" meta:midnight.expression="self.parent.children[1].date == self.parent.parent.parent.parent.firstChild.meta.timesec.children ? NUMBER(24) : NUMBER(0)"/>
</section>
<section copyable="true" id="sec_lart" title="Erfassen von Tätigkeiten">
<choicefield id="ch_obj" multipleChoice="true" meta:refname="tt" title="WE">
<choice id="IW00100000004201501011" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="EHOEDKE - 21012"/>
<choice id="IW00100000004201501012" meta:intreno="IW00100000004" subtitle="Ü Oberndorf, Erlenstr.29" title="DSCHUCK - 21012"/>
<choice id="IW00100000005201501011" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="EHOEDKE - 21494"/>
<choice id="IW00100000005201501012" meta:intreno="IW00100000005" subtitle="Ü Schramberg,Sulgauer Str. 31, 33, 35" title="DSCHUCK - 21494"/>
<choice id="IW00100000006201501011" meta:intreno="IW00100000006" subtitle="Ü Albstadt,Leipziger Str. 15, 17, 19, 21, 23" title="EHOEDKE - 21535"/>
</choicefield>
<choicefield id="ch_lart" multipleChoice="true" meta:refname="ct" title="Tätigkeit">
<choice id="H0301" title="Aussenanlage säubern"/>
<choice id="H0302" title="Unkraut Zuwege entf."/>
<choice id="H0303" title="Zuwege/Stp. kehren"/>
<choice id="H0304" title="Reinigung Fußroste"/>
<choice id="H0305" title="Wassereinläufe rein."/>
<choice id="H0307" title="Laub entfernen"/>
</choicefield>
<textfield id="ktext" title="Kurztext"/>
</section>
<section id="sec_trips" title="Dienstreisen">
<button title="Neue Dienstreisen erfassen" url="oppc://action?id=mnttrip2015-04-01"/>
</section>
<section title="Erfassung beenden">
<checkboxfield editable.expression="!self.parent.children[1].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_ill" span="4" title="Krankheit"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[2].checked" meta:refname="end_za" span="4" title="Zeitausgleich"/>
<checkboxfield editable.expression="!self.parent.children[0].checked &amp;&amp;!self.parent.children[1].checked" meta:refname="end_holiday" span="4" title="Urlaub"/>
</section>
<section>
<checkboxfield autolock="true" id="vollst" meta:refname="vollst" title="Stundenerfassung vollständig" valid.expression="( (self.parent.parent.children[0].children[2] &gt; self.parent.parent.children[0].children[1] || self.parent.parent.children[0].children[2]=self.parent.parent.children[0].children[1]) &amp;&amp; self.parent.parent.filledOut) || !self.parent.parent.filledOut || self.checked"/>
</section>
</sheet>
<textfield editable="false" id="" span="1">1</textfield>
<textfield editable="false" id="" span="1">2</textfield>
<textfield editable="false" id="" span="1">3</textfield>
<textfield visibility="hidden"/>
</section>
<section title="Monatsüberblick">
<numberfield decimaldigits="2" editable="false" span="4" title="h SOLL"/>
<numberfield decimaldigits="2" editable="false" span="4" title="h IST"/>
<numberfield decimaldigits="2" editable="false" span="4" title="h Saldo"/>
<textfield visibility="hidden"/>
<numberfield editable="false" span="4" title="km PKW"/>
<numberfield editable="false" span="4" title="km Anhänger"/>
<numberfield editable="false" span="4" title="km Beifahrer"/>
</section>
<section title="!TODO Jahresüberblick">
<numberfield decimaldigits="2" editable="false" span="4" title="h Saldo Gesamt"/>
<numberfield decimaldigits="2" editable="false" span="8" title="h Saldo aus Vorjahr"/>
<numberfield decimaldigits="2" editable="false" span="4" title="h Urlaub"/>
<numberfield decimaldigits="2" editable="false" span="4" title="h Zeitausgleich"/>
<numberfield decimaldigits="2" editable="false" span="4" title="h Krankheit"/>
</section>
</sheet>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment