diff options
| author | Winfried Donkers <winfrieddonkers@libreoffice.org> | 2016-07-29 09:16:34 +0200 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2016-07-29 16:43:40 +0000 |
| commit | 3ee2cae3a36e5d052e02c3f7b226dc3b79bd2ebc (patch) | |
| tree | 978240c86f36e968eea44675f07b34850ed972cc | |
| parent | e0eb85785b68867f1476553723dbfc6dc407106b (diff) | |
tdf#97831 follow up : remove unused arguments from stack
Intention:
Make e.g. [1+SWITCH(1;1;1;6)] work. Without this fix, the result is
7 but should be 2.
Change-Id: I2a72e458e5458c02c3ce2f4214b86ba13f7b1d11
Reviewed-on: https://gerrit.libreoffice.org/27664
Tested-by: Jenkins <ci@libreoffice.org>
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>
| -rw-r--r-- | sc/qa/unit/data/functions/fods/Functions_Excel_2016.fods | 1174 | ||||
| -rw-r--r-- | sc/source/core/tool/interpr8.cxx | 16 |
2 files changed, 632 insertions, 558 deletions
diff --git a/sc/qa/unit/data/functions/fods/Functions_Excel_2016.fods b/sc/qa/unit/data/functions/fods/Functions_Excel_2016.fods index bb526b285d65..eb5171562a79 100644 --- a/sc/qa/unit/data/functions/fods/Functions_Excel_2016.fods +++ b/sc/qa/unit/data/functions/fods/Functions_Excel_2016.fods @@ -1,13 +1,13 @@ <?xml version="1.0" encoding="UTF-8"?> <office:document xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:style="urn:oasis:names:tc:opendocument:xmlns:style:1.0" xmlns:text="urn:oasis:names:tc:opendocument:xmlns:text:1.0" xmlns:table="urn:oasis:names:tc:opendocument:xmlns:table:1.0" xmlns:draw="urn:oasis:names:tc:opendocument:xmlns:drawing:1.0" xmlns:fo="urn:oasis:names:tc:opendocument:xmlns:xsl-fo-compatible:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:number="urn:oasis:names:tc:opendocument:xmlns:datastyle:1.0" xmlns:presentation="urn:oasis:names:tc:opendocument:xmlns:presentation:1.0" xmlns:svg="urn:oasis:names:tc:opendocument:xmlns:svg-compatible:1.0" xmlns:chart="urn:oasis:names:tc:opendocument:xmlns:chart:1.0" xmlns:dr3d="urn:oasis:names:tc:opendocument:xmlns:dr3d:1.0" xmlns:math="http://www.w3.org/1998/Math/MathML" xmlns:form="urn:oasis:names:tc:opendocument:xmlns:form:1.0" xmlns:script="urn:oasis:names:tc:opendocument:xmlns:script:1.0" xmlns:config="urn:oasis:names:tc:opendocument:xmlns:config:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:ooow="http://openoffice.org/2004/writer" xmlns:oooc="http://openoffice.org/2004/calc" xmlns:dom="http://www.w3.org/2001/xml-events" xmlns:xforms="http://www.w3.org/2002/xforms" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:rpt="http://openoffice.org/2005/report" xmlns:of="urn:oasis:names:tc:opendocument:xmlns:of:1.2" xmlns:xhtml="http://www.w3.org/1999/xhtml" xmlns:grddl="http://www.w3.org/2003/g/data-view#" xmlns:tableooo="http://openoffice.org/2009/table" xmlns:drawooo="http://openoffice.org/2010/draw" xmlns:calcext="urn:org:documentfoundation:names:experimental:calc:xmlns:calcext:1.0" xmlns:loext="urn:org:documentfoundation:names:experimental:office:xmlns:loext:1.0" xmlns:field="urn:openoffice:names:experimental:ooo-ms-interop:xmlns:field:1.0" xmlns:formx="urn:openoffice:names:experimental:ooxml-odf-interop:xmlns:form:1.0" xmlns:css3t="http://www.w3.org/TR/css3-text/" office:version="1.2" office:mimetype="application/vnd.oasis.opendocument.spreadsheet"> - <office:meta><meta:creation-date>2016-05-02T17:35:29</meta:creation-date><dc:language>nl-NL</dc:language><dc:date>2016-06-15T11:45:50.280414044</dc:date><meta:editing-cycles>33</meta:editing-cycles><meta:editing-duration>PT2H34M2S</meta:editing-duration><meta:generator>LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/0f258538b842e3a8639efc8c2c7afc16a1b0819e</meta:generator><meta:document-statistic meta:table-count="3" meta:cell-count="478" meta:object-count="0"/></office:meta> + <office:meta><meta:creation-date>2016-05-02T17:35:29</meta:creation-date><dc:language>nl-NL</dc:language><dc:date>2016-07-29T12:52:54.353604796</dc:date><meta:editing-cycles>34</meta:editing-cycles><meta:editing-duration>PT2H36M54S</meta:editing-duration><meta:generator>LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/eccf9a9095093a1771c5a2a5c4d235a36e64257c</meta:generator><meta:document-statistic meta:table-count="3" meta:cell-count="486" meta:object-count="0"/></office:meta> <office:settings> <config:config-item-set config:name="ooo:view-settings"> <config:config-item config:name="VisibleAreaTop" config:type="int">0</config:config-item> <config:config-item config:name="VisibleAreaLeft" config:type="int">0</config:config-item> <config:config-item config:name="VisibleAreaWidth" config:type="int">26597</config:config-item> - <config:config-item config:name="VisibleAreaHeight" config:type="int">26190</config:config-item> + <config:config-item config:name="VisibleAreaHeight" config:type="int">27093</config:config-item> <config:config-item-map-indexed config:name="Views"> <config:config-item-map-entry> <config:config-item config:name="ViewId" config:type="string">view1</config:config-item> @@ -28,10 +28,11 @@ <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item> <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item> <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item> + <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item> </config:config-item-map-entry> <config:config-item-map-entry config:name="Sheet2"> - <config:config-item config:name="CursorPositionX" config:type="int">7</config:config-item> - <config:config-item config:name="CursorPositionY" config:type="int">55</config:config-item> + <config:config-item config:name="CursorPositionX" config:type="int">3</config:config-item> + <config:config-item config:name="CursorPositionY" config:type="int">32</config:config-item> <config:config-item config:name="HorizontalSplitMode" config:type="short">0</config:config-item> <config:config-item config:name="VerticalSplitMode" config:type="short">2</config:config-item> <config:config-item config:name="HorizontalSplitPosition" config:type="int">0</config:config-item> @@ -40,11 +41,12 @@ <config:config-item config:name="PositionLeft" config:type="int">0</config:config-item> <config:config-item config:name="PositionRight" config:type="int">0</config:config-item> <config:config-item config:name="PositionTop" config:type="int">0</config:config-item> - <config:config-item config:name="PositionBottom" config:type="int">32</config:config-item> + <config:config-item config:name="PositionBottom" config:type="int">17</config:config-item> <config:config-item config:name="ZoomType" config:type="short">0</config:config-item> <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item> <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item> <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item> + <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item> </config:config-item-map-entry> <config:config-item-map-entry config:name="data"> <config:config-item config:name="CursorPositionX" config:type="int">0</config:config-item> @@ -62,10 +64,11 @@ <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item> <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item> <config:config-item config:name="ShowGrid" config:type="boolean">true</config:config-item> + <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item> </config:config-item-map-entry> </config:config-item-map-named> <config:config-item config:name="ActiveTable" config:type="string">Sheet2</config:config-item> - <config:config-item config:name="HorizontalScrollbarWidth" config:type="int">926</config:config-item> + <config:config-item config:name="HorizontalScrollbarWidth" config:type="int">1210</config:config-item> <config:config-item config:name="ZoomType" config:type="short">0</config:config-item> <config:config-item config:name="ZoomValue" config:type="int">100</config:config-item> <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item> @@ -86,6 +89,7 @@ <config:config-item config:name="RasterSubdivisionX" config:type="int">1</config:config-item> <config:config-item config:name="RasterSubdivisionY" config:type="int">1</config:config-item> <config:config-item config:name="IsRasterAxisSynchronized" config:type="boolean">true</config:config-item> + <config:config-item config:name="AnchoredTextOverflowLegacy" config:type="boolean">false</config:config-item> </config:config-item-map-entry> </config:config-item-map-indexed> </config:config-item-set> @@ -132,7 +136,7 @@ <config:config-item config:name="HasColumnRowHeaders" config:type="boolean">true</config:config-item> <config:config-item config:name="RasterSubdivisionY" config:type="int">1</config:config-item> <config:config-item config:name="AutoCalculate" config:type="boolean">true</config:config-item> - <config:config-item config:name="PrinterSetup" config:type="base64Binary">iwH+/3Bybl9BbGdlbWVlbgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpwcm5fQWxnZW1lZW4AAAAAAAAAAAAAAAAAAAAWAAMAsQAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9cHJuX0FsZ2VtZWVuCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCmNvbGxhdGU9ZmFsc2UKbWFyZ2luZGFqdXN0bWVudD0wLDAsMCwwCmNvbG9yZGVwdGg9MjQKcHNsZXZlbD0wCnBkZmRldmljZT0xCmNvbG9yZGV2aWNlPTAKUFBEQ29udGV4RGF0YQpQYWdlU2l6ZTpBNAAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY=</config:config-item> + <config:config-item config:name="PrinterSetup" config:type="base64Binary">qAH+/3Bybl9BbGdlbWVlbgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpwcm5fQWxnZW1lZW4AAAAAAAAAAAAAAAAAAAAWAAMAzgAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9cHJuX0FsZ2VtZWVuCm9yaWVudGF0aW9uPVBvcnRyYWl0CmNvcGllcz0xCmNvbGxhdGU9ZmFsc2UKbWFyZ2luZGFqdXN0bWVudD0wLDAsMCwwCmNvbG9yZGVwdGg9MjQKcHNsZXZlbD0wCnBkZmRldmljZT0xCmNvbG9yZGV2aWNlPTAKUFBEQ29udGV4RGF0YQpJbnB1dFNsb3Q6UEY3MDBBAER1cGxleDpOb25lAFBhZ2VTaXplOkE0AAASAENPTVBBVF9EVVBMRVhfTU9ERQoARFVQTEVYX09GRg==</config:config-item> <config:config-item config:name="ApplyUserData" config:type="boolean">true</config:config-item> <config:config-item config:name="CharacterCompressionType" config:type="short">0</config:config-item> </config:config-item-set> @@ -501,51 +505,51 @@ <number:boolean-style style:name="N99"> <number:boolean/> </number:boolean-style> - <style:style style:name="ce37" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:rotation-align="none"/> + <style:text-properties style:text-position=""/> + </style:style> + <style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:rotation-align="none"/> + <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> + </style:style> + <style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties style:text-align-source="value-type" style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="bottom" loext:vertical-justify="auto"/> + <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0mm" style:writing-mode="page"/> + <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Times New Roman" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Times New Roman" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> + </style:style> + <style:style style:name="ce70" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="0.06pt solid #000000" fo:border-right="none" style:rotation-align="none" fo:border-top="0.06pt solid #000000"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce38" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce71" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="0.06pt solid #000000" fo:border-right="none" style:rotation-align="none" fo:border-top="none"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce39" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce72" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="0.06pt solid #000000" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="0.06pt solid #000000" fo:border-right="none" style:rotation-align="none" fo:border-top="none"/> <style:text-properties style:text-position=""/> </style:style> - <style:style style:name="ce40" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce73" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="none" fo:border-right="none" style:rotation-align="none" fo:border-top="0.06pt solid #000000"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce41" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce74" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="0.06pt solid #000000" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="none" fo:border-right="none" style:rotation-align="none" fo:border-top="none"/> <style:text-properties style:text-position=""/> </style:style> - <style:style style:name="ce42" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce75" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="none" fo:border-right="0.06pt solid #000000" style:rotation-align="none" fo:border-top="0.06pt solid #000000"/> <style:text-properties style:text-position=""/> </style:style> - <style:style style:name="ce43" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce76" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="none" fo:border-right="0.06pt solid #000000" style:rotation-align="none" fo:border-top="none"/> <style:text-properties style:text-position=""/> </style:style> - <style:style style:name="ce44" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce77" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="0.06pt solid #000000" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="none" fo:border-right="0.06pt solid #000000" style:rotation-align="none" fo:border-top="none"/> <style:text-properties style:text-position=""/> </style:style> - <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default"> - <style:table-cell-properties style:rotation-align="none"/> - <style:text-properties style:text-position=""/> - </style:style> - <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default"> - <style:table-cell-properties style:rotation-align="none"/> - <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> - </style:style> - <style:style style:name="ce8" style:family="table-cell" style:parent-style-name="Default"> - <style:table-cell-properties style:text-align-source="value-type" style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="bottom" loext:vertical-justify="auto"/> - <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0mm" style:writing-mode="page"/> - <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:text-position="" style:font-name="Times New Roman" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Times New Roman" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> - </style:style> <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet1.B3"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet1.B3"/> @@ -567,41 +571,41 @@ <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0mm" style:writing-mode="page"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Courier New" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Courier New" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:rotation-align="none"/> </style:style> - <style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:rotation-align="none"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="value-type" style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="bottom" loext:vertical-justify="auto"/> <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0mm" style:writing-mode="page"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Times New Roman" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Times New Roman" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="value-type" style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="bottom" loext:vertical-justify="auto"/> <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0mm" style:writing-mode="page"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" fo:background-color="transparent"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/> <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/> </style:style> - <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:background-color="transparent" style:rotation-align="none"/> </style:style> - <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:background-color="transparent" style:rotation-align="none"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="value-type" style:repeat-content="false" fo:background-color="transparent" fo:wrap-option="wrap" style:direction="ltr" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="bottom" loext:vertical-justify="auto"/> <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0mm" style:writing-mode="page"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Times New Roman" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Times New Roman" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce28" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0mm"/> <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/> @@ -609,216 +613,228 @@ <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C1"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C1"/> </style:style> - <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C1"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C1"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C1"/> </style:style> - <style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce30" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C6"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C6"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C6"/> </style:style> - <style:style style:name="ce28" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce31" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C12"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C12"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C12"/> </style:style> - <style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce32" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C29"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C29"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C29"/> </style:style> - <style:style style:name="ce30" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce33" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C31"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C31"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C31"/> </style:style> - <style:style style:name="ce31" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce34" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C32"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C32"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C32"/> </style:style> - <style:style style:name="ce32" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce35" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C33"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C33"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C33"/> </style:style> - <style:style style:name="ce33" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce36" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C34"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C34"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C34"/> </style:style> - <style:style style:name="ce34" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce37" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C35"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C35"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C35"/> </style:style> - <style:style style:name="ce35" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce38" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C36"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C36"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C36"/> </style:style> - <style:style style:name="ce36" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce39" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C37"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C37"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C37"/> </style:style> - <style:style style:name="ce45" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce40" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> - <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C46"/> - <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C46"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C46"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C38"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C38"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C38"/> </style:style> - <style:style style:name="ce46" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce41" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> - <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C47"/> - <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C47"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C47"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C39"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C39"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C39"/> </style:style> - <style:style style:name="ce47" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce42" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:table-cell-properties style:rotation-align="none"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C48"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C48"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C48"/> + </style:style> + <style:style style:name="ce43" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C49"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C49"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C49"/> </style:style> - <style:style style:name="ce48" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> - <style:table-cell-properties style:rotation-align="none"/> - <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C50"/> - <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C50"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C50"/> - </style:style> - <style:style style:name="ce49" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce44" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C51"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C51"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C51"/> </style:style> - <style:style style:name="ce50" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce45" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C52"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C52"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C52"/> </style:style> - <style:style style:name="ce51" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce46" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C53"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C53"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C53"/> </style:style> - <style:style style:name="ce52" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce47" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C54"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C54"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C54"/> </style:style> - <style:style style:name="ce53" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce48" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C55"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C55"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C55"/> </style:style> - <style:style style:name="ce54" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce49" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C56"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C56"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C56"/> </style:style> - <style:style style:name="ce55" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce50" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C57"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C57"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C57"/> </style:style> - <style:style style:name="ce56" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:style style:name="ce51" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> <style:table-cell-properties style:rotation-align="none"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C58"/> <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C58"/> <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C58"/> </style:style> - <style:style style:name="ce57" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:style style:name="ce52" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:table-cell-properties style:rotation-align="none"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C59"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C59"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C59"/> + </style:style> + <style:style style:name="ce53" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N114"> + <style:table-cell-properties style:rotation-align="none"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C60"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="OK" style:base-cell-address="Sheet2.C60"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="NOK" style:base-cell-address="Sheet2.C60"/> + </style:style> + <style:style style:name="ce54" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:table-cell-properties style:rotation-align="none"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce58" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce55" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="value-type" style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="bottom" loext:vertical-justify="auto"/> <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0mm" style:writing-mode="page"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Times New Roman" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="bold" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="bold" style:font-name-complex="Times New Roman" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="bold"/> </style:style> - <style:style style:name="ce59" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce56" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:rotation-align="none"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Times New Roman" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Times New Roman" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce60" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce57" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" fo:border-left="0.06pt solid #000000" fo:border-right="none" style:rotation-align="none" fo:border-top="0.06pt solid #000000"/> </style:style> - <style:style style:name="ce61" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce58" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" fo:border-left="0.06pt solid #000000" fo:border-right="none" style:rotation-align="none" fo:border-top="none"/> </style:style> - <style:style style:name="ce62" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce59" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="0.06pt solid #000000" fo:border-left="0.06pt solid #000000" fo:border-right="none" style:rotation-align="none" fo:border-top="none"/> </style:style> - <style:style style:name="ce63" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce60" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" fo:border-left="none" fo:border-right="none" style:rotation-align="none" fo:border-top="0.06pt solid #000000"/> </style:style> - <style:style style:name="ce64" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce61" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="0.06pt solid #000000" fo:border-left="none" fo:border-right="none" style:rotation-align="none" fo:border-top="none"/> </style:style> - <style:style style:name="ce65" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce62" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" fo:border-left="none" fo:border-right="0.06pt solid #000000" style:rotation-align="none" fo:border-top="0.06pt solid #000000"/> </style:style> - <style:style style:name="ce66" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce63" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" fo:border-left="none" fo:border-right="0.06pt solid #000000" style:rotation-align="none" fo:border-top="none"/> </style:style> - <style:style style:name="ce67" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce64" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="0.06pt solid #000000" fo:border-left="none" fo:border-right="0.06pt solid #000000" style:rotation-align="none" fo:border-top="none"/> </style:style> - <style:style style:name="ce68" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce65" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" fo:wrap-option="wrap" fo:border="none" style:direction="ltr" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="middle" loext:vertical-justify="auto"/> <style:paragraph-properties fo:text-align="start" css3t:text-justify="auto" fo:margin-left="0mm" style:writing-mode="page"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce69" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce66" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="middle" loext:vertical-justify="auto"/> <style:paragraph-properties fo:text-align="start" css3t:text-justify="auto" fo:margin-left="0mm" style:writing-mode="page"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce70" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce67" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="0.06pt solid #000000" fo:border-right="none" style:rotation-align="none" fo:border-top="0.06pt solid #000000"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce71" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce68" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="0.06pt solid #000000" fo:border-right="none" style:rotation-align="none" fo:border-top="none"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce72" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce69" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="0.06pt solid #000000" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="0.06pt solid #000000" fo:border-right="none" style:rotation-align="none" fo:border-top="none"/> </style:style> - <style:style style:name="ce73" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce78" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="none" fo:border-right="none" style:rotation-align="none" fo:border-top="0.06pt solid #000000"/> <style:text-properties style:use-window-font-color="true" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Arial" fo:font-size="10pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="10pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce74" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce79" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="0.06pt solid #000000" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="none" fo:border-right="none" style:rotation-align="none" fo:border-top="none"/> </style:style> - <style:style style:name="ce75" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce80" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="none" fo:border-right="0.06pt solid #000000" style:rotation-align="none" fo:border-top="0.06pt solid #000000"/> </style:style> - <style:style style:name="ce76" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce81" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="none" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="none" fo:border-right="0.06pt solid #000000" style:rotation-align="none" fo:border-top="none"/> </style:style> - <style:style style:name="ce77" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce82" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:border-bottom="0.06pt solid #000000" style:diagonal-bl-tr="none" style:diagonal-tl-br="none" fo:border-left="none" fo:border-right="0.06pt solid #000000" style:rotation-align="none" fo:border-top="none"/> </style:style> <style:style style:name="gr1" style:family="graphic"> @@ -866,7 +882,7 @@ </style:page-layout> <style:style style:name="P1" style:family="paragraph"> <style:paragraph-properties style:text-autospace="none" style:line-break="normal" style:writing-mode="page"/> - <style:text-properties style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Arial" fo:font-size="10pt" fo:language="nl" fo:country="NL" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:font-name-asian="Droid Sans Fallback" style:font-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-name-complex="Arial" style:font-size-complex="10pt" style:language-complex="hi" style:country-complex="IN" style:font-style-complex="normal" style:font-weight-complex="normal" style:text-emphasize="none" style:font-relief="none" style:text-overline-style="none" style:text-overline-color="font-color" fo:hyphenate="false"/> + <style:text-properties fo:hyphenate="false"/> </style:style> <style:style style:name="P2" style:family="paragraph"> <loext:graphic-properties draw:fill="solid" draw:fill-color="#ffffc0"/> @@ -897,7 +913,7 @@ <text:p><text:sheet-name>???</text:sheet-name> (<text:title>???</text:title>)</text:p> </style:region-left> <style:region-right> - <text:p><text:date style:data-style-name="N2" text:date-value="2016-06-15">00-00-0000</text:date>, <text:time style:data-style-name="N2" text:time-value="11:44:32.252752173">00:00:00</text:time></text:p> + <text:p><text:date style:data-style-name="N2" text:date-value="2016-07-29">00-00-0000</text:date>, <text:time style:data-style-name="N2" text:time-value="12:50:04.512010114">00:00:00</text:time></text:p> </style:region-right> </style:header> <style:header-left style:display="false"/> @@ -1007,7 +1023,7 @@ <table:table-cell office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce12" table:formula="of:=AND([Sheet2.C33:.C58])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce12" table:formula="of:=AND([Sheet2.C34:.C60])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1061,19 +1077,19 @@ </table:table> <table:table table:name="Sheet2" table:style-name="ta4"> <office:forms form:automatic-focus="false" form:apply-design-mode="false"/> - <table:table-column table:style-name="co2" table:number-columns-repeated="3" table:default-cell-style-name="ce17"/> - <table:table-column table:style-name="co4" table:default-cell-style-name="ce17"/> - <table:table-column table:style-name="co5" table:default-cell-style-name="ce17"/> - <table:table-column table:style-name="co2" table:number-columns-repeated="1018" table:default-cell-style-name="ce17"/> + <table:table-column table:style-name="co2" table:number-columns-repeated="3" table:default-cell-style-name="ce20"/> + <table:table-column table:style-name="co4" table:default-cell-style-name="ce20"/> + <table:table-column table:style-name="co5" table:default-cell-style-name="ce20"/> + <table:table-column table:style-name="co2" table:number-columns-repeated="1018" table:default-cell-style-name="ce20"/> <table:table-column table:style-name="co2" table:default-cell-style-name="Default"/> <table:table-row table:style-name="ro1"> <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string"> <text:p>Function</text:p> </table:table-cell> - <table:table-cell table:style-name="ce21" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> <text:p>Expected</text:p> </table:table-cell> - <table:table-cell table:style-name="ce25" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce28" office:value-type="string" calcext:value-type="string"> <text:p>Correct</text:p> </table:table-cell> <table:table-cell table:style-name="ce15" office:value-type="string" calcext:value-type="string"> @@ -1088,10 +1104,10 @@ <table:table-cell table:style-name="ce16" table:formula="of:=COM.MICROSOFT.MINIFS([$data.A1:.A6];[$data.B1:.B6];1)" office:value-type="float" office:value="88" calcext:value-type="float"> <text:p>88</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="float" office:value="88" calcext:value-type="float"> + <table:table-cell table:style-name="ce25" office:value-type="float" office:value="88" calcext:value-type="float"> <text:p>88</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A2]=[$Sheet2.B2])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A2]=[$Sheet2.B2])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1103,10 +1119,10 @@ <table:table-cell table:formula="of:=COM.MICROSOFT.MINIFS([$data.A8:.A12];[$data.B9:.B13];"a")" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce25" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A3]=[$Sheet2.B3])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A3]=[$Sheet2.B3])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1118,10 +1134,10 @@ <table:table-cell table:formula="of:=COM.MICROSOFT.MINIFS([$data.A15:.A20];[$data.B15:.B20];"b";[$data.D15:.D20];">100")" office:value-type="float" office:value="13" calcext:value-type="float"> <text:p>13</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="float" office:value="13" calcext:value-type="float"> + <table:table-cell table:style-name="ce25" office:value-type="float" office:value="13" calcext:value-type="float"> <text:p>13</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A4]=[$Sheet2.B4])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A4]=[$Sheet2.B4])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1133,10 +1149,10 @@ <table:table-cell table:formula="of:=COM.MICROSOFT.MINIFS([$data.A22:.A27];[$data.B22:.B27];"b";[$data.D22:.D27];[$data.A28])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce25" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=IFERROR([$Sheet2.A5];1)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=IFERROR([$Sheet2.A5];1)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1146,12 +1162,12 @@ </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:formula="of:=COM.MICROSOFT.MINIFS([$data.A29:.A33];[$data.B29:.C34];"a")" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>Fout:502</text:p> + <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce25" office:value-type="string" calcext:value-type="string"> <text:p>#VALUE!</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=IF(ISERROR([$Sheet2.A6]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce30" table:formula="of:=IF(ISERROR([$Sheet2.A6]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1163,10 +1179,10 @@ <table:table-cell table:formula="of:=COM.MICROSOFT.MINIFS([$data.A36:.A40];[$data.B36:.B40];"a";[$data.D36:.D40];">200")" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce25" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A7]=[$Sheet2.B7])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A7]=[$Sheet2.B7])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1178,10 +1194,10 @@ <table:table-cell table:formula="of:=COM.MICROSOFT.MAXIFS([$data.A1:.A6];[$data.B1:.B6];1)" office:value-type="float" office:value="91" calcext:value-type="float"> <text:p>91</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="float" office:value="91" calcext:value-type="float"> + <table:table-cell table:style-name="ce25" office:value-type="float" office:value="91" calcext:value-type="float"> <text:p>91</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A8]=[$Sheet2.B8])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A8]=[$Sheet2.B8])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1193,10 +1209,10 @@ <table:table-cell table:formula="of:=COM.MICROSOFT.MAXIFS([$data.C8:.C12];[$data.B9:.B13];"a")" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce25" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A9]=[$Sheet2.B9])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A9]=[$Sheet2.B9])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1208,10 +1224,10 @@ <table:table-cell table:formula="of:=COM.MICROSOFT.MAXIFS([$data.A43:.A48];[$data.B43:.B48];"b";[$data.D43:.D48];">100")" office:value-type="float" office:value="50" calcext:value-type="float"> <text:p>50</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="float" office:value="50" calcext:value-type="float"> + <table:table-cell table:style-name="ce25" office:value-type="float" office:value="50" calcext:value-type="float"> <text:p>50</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A10]=[$Sheet2.B10])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A10]=[$Sheet2.B10])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1223,10 +1239,10 @@ <table:table-cell table:formula="of:=COM.MICROSOFT.MAXIFS([$data.A50:.A55];[$data.B50:.B55];"b";[$data.D50:.D55];[$data.A28])" office:value-type="float" office:value="12" calcext:value-type="float"> <text:p>12</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="float" office:value="12" calcext:value-type="float"> + <table:table-cell table:style-name="ce25" office:value-type="float" office:value="12" calcext:value-type="float"> <text:p>12</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A11]=[$Sheet2.B11])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A11]=[$Sheet2.B11])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1236,12 +1252,12 @@ </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:formula="of:=COM.MICROSOFT.MAXIFS([$data.A29:.A33];[$data.B29:.C34];"a")" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>Fout:502</text:p> + <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce25" office:value-type="string" calcext:value-type="string"> <text:p>#VALUE!</text:p> </table:table-cell> - <table:table-cell table:style-name="ce28" table:formula="of:=IF(ISERROR([$Sheet2.A12]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce31" table:formula="of:=IF(ISERROR([$Sheet2.A12]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1253,10 +1269,10 @@ <table:table-cell table:formula="of:=COM.MICROSOFT.MAXIFS([$data.A36:.A40];[$data.B36:.B40];"a";[$data.D36:.D40];">200")" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce25" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A13]=[$Sheet2.B13])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A13]=[$Sheet2.B13])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1265,390 +1281,422 @@ <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.CONCAT([$data.H11:.I13])" office:value-type="string" office:string-value="a1bc3" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.CONCAT([$data.H11:.I13])" office:value-type="string" office:string-value="a1bc3" calcext:value-type="string"> <text:p>a1bc3</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce26" office:value-type="string" calcext:value-type="string"> <text:p>a1bc3</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A14]=[$Sheet2.B14])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A14]=[$Sheet2.B14])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=CONCAT($data.H11:I13)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.CONCAT([$data.H$1:.H$1048576])" office:value-type="string" office:string-value="abcdelast_row_but_onelast_row" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.CONCAT([$data.H$1:.H$1048576])" office:value-type="string" office:string-value="abcdelast_row_but_onelast_row" calcext:value-type="string"> <text:p>abcdelast_row_but_onelast_row</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce26" office:value-type="string" calcext:value-type="string"> <text:p>abcdelast_row_but_onelast_row</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A15]=[$Sheet2.B15])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A15]=[$Sheet2.B15])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=CONCAT($data.H:H)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.CONCAT([$data.I$1:.I$1048576])" office:value-type="string" office:string-value="1345" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.CONCAT([$data.I$1:.I$1048576])" office:value-type="string" office:string-value="1345" calcext:value-type="string"> <text:p>1345</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce26" office:value-type="string" calcext:value-type="string"> <text:p>1345</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A16]=[$Sheet2.B16])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A16]=[$Sheet2.B16])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=CONCAT($data.I:I)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.CONCAT([$data.H$1:.I$1048576])" office:value-type="string" office:string-value="a1bc3d4e5last_row_but_onelast_row" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.CONCAT([$data.H$1:.I$1048576])" office:value-type="string" office:string-value="a1bc3d4e5last_row_but_onelast_row" calcext:value-type="string"> <text:p>a1bc3d4e5last_row_but_onelast_row</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce26" office:value-type="string" calcext:value-type="string"> <text:p>a1bc3d4e5last_row_but_onelast_row</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A17]=[$Sheet2.B17])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A17]=[$Sheet2.B17])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=CONCAT($data.H:I)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.TEXTJOIN("-";1;[$data.H11:.I13])" office:value-type="string" office:string-value="a-1-b-c-3" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.TEXTJOIN("-";1;[$data.H11:.I13])" office:value-type="string" office:string-value="a-1-b-c-3" calcext:value-type="string"> <text:p>a-1-b-c-3</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce26" office:value-type="string" calcext:value-type="string"> <text:p>a-1-b-c-3</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A18]=[$Sheet2.B18])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A18]=[$Sheet2.B18])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=TEXTJOIN("-";1;$data.H11:I13)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.TEXTJOIN("-";0;[$data.H11:.I13])" office:value-type="string" office:string-value="a-1-b--c-3" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.TEXTJOIN("-";0;[$data.H11:.I13])" office:value-type="string" office:string-value="a-1-b--c-3" calcext:value-type="string"> <text:p>a-1-b--c-3</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce26" office:value-type="string" calcext:value-type="string"> <text:p>a-1-b--c-3</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A19]=[$Sheet2.B19])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A19]=[$Sheet2.B19])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=TEXTJOIN("-";0;$data.H11:I13)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.TEXTJOIN(".";1;[$data.H$1:.H$1048576])" office:value-type="string" office:string-value="a.b.c.d.e.last_row_but_one.last_row" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.TEXTJOIN(".";1;[$data.H$1:.H$1048576])" office:value-type="string" office:string-value="a.b.c.d.e.last_row_but_one.last_row" calcext:value-type="string"> <text:p>a.b.c.d.e.last_row_but_one.last_row</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce26" office:value-type="string" calcext:value-type="string"> <text:p>a.b.c.d.e.last_row_but_one.last_row</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A20]=[$Sheet2.B20])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A20]=[$Sheet2.B20])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=TEXTJOIN(".";1;$data.H:H)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.TEXTJOIN([$data.F11:.G12];1;[$data.H11:.I15])" office:value-type="string" office:string-value="a-1:b;c,3-d:4;e,5" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.TEXTJOIN([$data.F11:.G12];1;[$data.H11:.I15])" office:value-type="string" office:string-value="a-1:b;c,3-d:4;e,5" calcext:value-type="string"> <text:p>a-1:b;c,3-d:4;e,5</text:p> </table:table-cell> - <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce26" office:value-type="string" calcext:value-type="string"> <text:p>a-1:b;c,3-d:4;e,5</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A21]=[$Sheet2.B21])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A21]=[$Sheet2.B21])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=TEXTJOIN($data.F11:G12;1;$data.H11:I15)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.IFS([$data.F17]>89;"A";[$data.F17]>79;"B";[$data.F17]>69;"C";[$data.F17]>59;"D";1;"F")" office:value-type="string" office:string-value="B" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.IFS([$data.F17]>89;"A";[$data.F17]>79;"B";[$data.F17]>69;"C";[$data.F17]>59;"D";1;"F")" office:value-type="string" office:string-value="B" calcext:value-type="string"> <text:p>B</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>B</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A22]=[$Sheet2.B22])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A22]=[$Sheet2.B22])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS($data.F17>89;"A";$data.F17>79;"B";$data.F17>69;"C";$data.F17>59;"D";1;"F")</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.IFS([$data.F18]>89;"A";[$data.F18]>79;"B";[$data.F18]>69;"C";[$data.F18]>59;"D";1;"F")" office:value-type="string" office:string-value="A" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.IFS([$data.F18]>89;"A";[$data.F18]>79;"B";[$data.F18]>69;"C";[$data.F18]>59;"D";1;"F")" office:value-type="string" office:string-value="A" calcext:value-type="string"> <text:p>A</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>A</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A23]=[$Sheet2.B23])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A23]=[$Sheet2.B23])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS($data.F18>89;"A";$data.F18>79;"B";$data.F18>69;"C";$data.F18>59;"D";1;"F")</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.IFS([$data.F19]>89;"A";[$data.F19]>79;"B";[$data.F19]>69;"C";[$data.F19]>59;"D";1;"F")" office:value-type="string" office:string-value="D" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.IFS([$data.F19]>89;"A";[$data.F19]>79;"B";[$data.F19]>69;"C";[$data.F19]>59;"D";1;"F")" office:value-type="string" office:string-value="D" calcext:value-type="string"> <text:p>D</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>D</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A24]=[$Sheet2.B24])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A24]=[$Sheet2.B24])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS($data.F19>89;"A";$data.F19>79;"B";$data.F19>69;"C";$data.F19>59;"D";1;"F")</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.IFS([$data.F20]>89;"A";[$data.F20]>79;"B";[$data.F20]>69;"C";[$data.F20]>59;"D";1;"F")" office:value-type="string" office:string-value="C" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.IFS([$data.F20]>89;"A";[$data.F20]>79;"B";[$data.F20]>69;"C";[$data.F20]>59;"D";1;"F")" office:value-type="string" office:string-value="C" calcext:value-type="string"> <text:p>C</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>C</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A25]=[$Sheet2.B25])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A25]=[$Sheet2.B25])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS($data.F20>89;"A";$data.F20>79;"B";$data.F20>69;"C";$data.F20>59;"D";1;"F")</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.IFS([$data.F21]>89;"A";[$data.F21]>79;"B";[$data.F21]>69;"C";[$data.F21]>59;"D";1=1;"F")" office:value-type="string" office:string-value="F" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.IFS([$data.F21]>89;"A";[$data.F21]>79;"B";[$data.F21]>69;"C";[$data.F21]>59;"D";1=1;"F")" office:value-type="string" office:string-value="F" calcext:value-type="string"> <text:p>F</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>F</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A26]=[$Sheet2.B26])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A26]=[$Sheet2.B26])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS($data.F21>89;"A";$data.F21>79;"B";$data.F21>69;"C";$data.F21>59;"D";1=1;"F")</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.IFS([$data.F22]>89;"A";[$data.F22]>79;"B";[$data.F22]>69;"C";[$data.F22]>59;"D";1;"F")" office:value-type="string" office:string-value="F" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.IFS([$data.F22]>89;"A";[$data.F22]>79;"B";[$data.F22]>69;"C";[$data.F22]>59;"D";1;"F")" office:value-type="string" office:string-value="F" calcext:value-type="string"> <text:p>F</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>F</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A27]=[$Sheet2.B27])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A27]=[$Sheet2.B27])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS($data.F22>89;"A";$data.F22>79;"B";$data.F22>69;"C";$data.F22>59;"D";1;"F")</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.IFS([$data.G30]=1;[$data.F29];[$data.G30]=2;[$data.F30];[$data.G30]=3;[$data.F31];[$data.G30]=4;[$data.F32];[$data.G30]=5;[$data.F33];[$data.G30]=6;[$data.F34];[$data.G30]=7;[$data.F35])" office:value-type="string" office:string-value="Sunday" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.IFS([$data.G30]=1;[$data.F29];[$data.G30]=2;[$data.F30];[$data.G30]=3;[$data.F31];[$data.G30]=4;[$data.F32];[$data.G30]=5;[$data.F33];[$data.G30]=6;[$data.F34];[$data.G30]=7;[$data.F35])" office:value-type="string" office:string-value="Sunday" calcext:value-type="string"> <text:p>Sunday</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>Sunday</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A28]=[$Sheet2.B28])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A28]=[$Sheet2.B28])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS($data.G30=1;$data.F29;$data.G30=2;$data.F30;$data.G30=3;$data.F31;$data.G30=4;$data.F32;$data.G30=5;$data.F33;$data.G30=6;$data.F34;$data.G30=7;$data.F35)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.IFS([$data.F24]>4;"Ok";[$data.F25]>4;"Ok";[$data.F26]>4;"Ok")" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#N/B</text:p> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.IFS([$data.F24]>4;"Ok";[$data.F25]>4;"Ok";[$data.F26]>4;"Ok")" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#N/A</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#N/B</text:p> + <table:table-cell table:style-name="ce27" table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#N/A</text:p> </table:table-cell> - <table:table-cell table:style-name="ce29" table:formula="of:=IF(ISNA([$Sheet2.A29]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce32" table:formula="of:=IF(ISNA([$Sheet2.A29]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS($data.F24>4;"Ok";$data.F25>4;"Ok";$data.F26>4;"Ok")</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:style-name="ce16" table:formula="of:=COM.MICROSOFT.IFS(0;1/0;10;2)" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A30]=[$Sheet2.B30])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A30]=[$Sheet2.B30])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS(0;1/0;10;2)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce57"/> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce54"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="5"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.IFS(1/0;1/0;1;2)" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.IFS(1/0;1/0;1;2)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#DIV/0!</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <table:table-cell table:style-name="ce27" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#DIV/0!</text:p> </table:table-cell> - <table:table-cell table:style-name="ce30" table:formula="of:=IF(ISERROR([$Sheet2.A31]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce33" table:formula="of:=IF(ISERROR([$Sheet2.A31]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS(1/0;1/0;1;2)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:style-name="ce16" table:formula="of:=COM.MICROSOFT.IFS(0;1/0;1/0;2)" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <text:p>#DIV/0!</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <table:table-cell table:style-name="ce27" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#DIV/0!</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=IF(ISERROR([$Sheet2.A32]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce34" table:formula="of:=IF(ISERROR([$Sheet2.A32]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=IFS(0;1/0;1/0;2)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.SWITCH(0;1/0;2;0;4)" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <table:table-cell table:style-name="ce16" table:formula="of:=1+COM.MICROSOFT.IFS(0;3;1;11;1/0;40;TRUE();99)" office:value-type="float" office:value="12" calcext:value-type="float"> + <text:p>12</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="12" calcext:value-type="float"> + <text:p>12</text:p> </table:table-cell> - <table:table-cell table:style-name="ce32" table:formula="of:=IF(ISERROR([$Sheet2.A33]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce35" table:formula="of:=([$Sheet2.A33]=[$Sheet2.B33])" office:value-type="float" office:value="1" calcext:value-type="float"> + <text:p>WAAR</text:p> + </table:table-cell> + <table:table-cell office:value-type="string" calcext:value-type="string"> + <text:p>=1+IFS(0;3;1;11;1/0;40;TRUE();99)</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> + <table:table-cell table:number-columns-repeated="1014"/> + </table:table-row> + <table:table-row table:style-name="ro1"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.SWITCH(0;1/0;2;0;4)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#DIV/0!</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce27" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#DIV/0!</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce36" table:formula="of:=IF(ISERROR([$Sheet2.A34]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH(0;1/0;2;0;4)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:style-name="ce16" table:formula="of:=COM.MICROSOFT.SWITCH(0;1/0;20;1/0;4)" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <text:p>#DIV/0!</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <table:table-cell table:style-name="ce27" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#DIV/0!</text:p> </table:table-cell> - <table:table-cell table:style-name="ce33" table:formula="of:=IF(ISERROR([$Sheet2.A34]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce37" table:formula="of:=IF(ISERROR([$Sheet2.A35]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH(0;1/0;20;1/0;4)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:style-name="ce16" table:formula="of:=COM.MICROSOFT.SWITCH(0;1/0;20;1/0;40;5)" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <text:p>#DIV/0!</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <table:table-cell table:style-name="ce27" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#DIV/0!</text:p> </table:table-cell> - <table:table-cell table:style-name="ce34" table:formula="of:=IF(ISERROR([$Sheet2.A35]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce38" table:formula="of:=IF(ISERROR([$Sheet2.A36]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH(0;1/0;20;1/0;40;5)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:style-name="ce16" table:formula="of:=COM.MICROSOFT.SWITCH(1;1;11;1/0;22)" office:value-type="float" office:value="11" calcext:value-type="float"> <text:p>11</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="float" office:value="11" calcext:value-type="float"> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="11" calcext:value-type="float"> <text:p>11</text:p> </table:table-cell> - <table:table-cell table:style-name="ce35" table:formula="of:=([$Sheet2.A36]=[$Sheet2.B36])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce39" table:formula="of:=([$Sheet2.A37]=[$Sheet2.B37])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH(1;1;11;1/0;22)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="1014"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F43];1;"Sunday";2;"Monday";3;"Tuesday";4;"Wednesday")" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#N/B</text:p> + <table:table-cell table:style-name="ce16" table:formula="of:=1+COM.MICROSOFT.SWITCH(2;1;11;2;22;3;33;44)" office:value-type="float" office:value="23" calcext:value-type="float"> + <text:p>23</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#DEL/0!</text:p> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="23" calcext:value-type="float"> + <text:p>23</text:p> </table:table-cell> - <table:table-cell table:style-name="ce36" table:formula="of:=IF(ISERROR([$Sheet2.A37]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce40" table:formula="of:=([$Sheet2.A38]=[$Sheet2.B38])" office:value-type="float" office:value="1" calcext:value-type="float"> + <text:p>WAAR</text:p> + </table:table-cell> + <table:table-cell office:value-type="string" calcext:value-type="string"> + <text:p>=1+SWITCH(2;1;11;2;22;3;33;44)</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="6"/> + <table:table-cell table:number-columns-repeated="1014"/> + </table:table-row> + <table:table-row table:style-name="ro1"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F43];1;"Sunday";2;"Monday";3;"Tuesday";4;"Wednesday")" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#N/A</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce27" table:formula="of:=#DIV/0!" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#DIV/0!</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce41" table:formula="of:=IF(ISERROR([$Sheet2.A39]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1657,45 +1705,45 @@ <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F44];1;"Sunday";2;"Monday";3;"Tuesday";4;"Wednesday";"No match")" office:value-type="string" office:string-value="No match" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F44];1;"Sunday";2;"Monday";3;"Tuesday";4;"Wednesday";"No match")" office:value-type="string" office:string-value="No match" calcext:value-type="string"> <text:p>No match</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>No match</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A38]=[$Sheet2.B38])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A40]=[$Sheet2.B40])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH($data.F44;1;"Sunday";2;"Monday";3;"Tuesday";4;"Wednesday";"No match")</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" table:number-columns-repeated="4"/> + <table:table-cell table:style-name="ce21" table:number-columns-repeated="4"/> <table:table-cell table:number-columns-repeated="1016"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F45];1;"Sunday";7;"Saturday";"weekday")" office:value-type="string" office:string-value="weekday" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F45];1;"Sunday";7;"Saturday";"weekday")" office:value-type="string" office:string-value="weekday" calcext:value-type="string"> <text:p>weekday</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>weekday</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A39]=[$Sheet2.B39])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A41]=[$Sheet2.B41])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH($data.F45;1;"Sunday";7;"Saturday";"weekday")</text:p> </table:table-cell> - <table:table-cell table:style-name="ce58"/> + <table:table-cell table:style-name="ce55"/> <table:table-cell table:number-columns-repeated="1019"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F46];1;"Sunday";2;"Monday";3;"Tuesday";4;"Wednesday";"No match")" office:value-type="string" office:string-value="Tuesday" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F46];1;"Sunday";2;"Monday";3;"Tuesday";4;"Wednesday";"No match")" office:value-type="string" office:string-value="Tuesday" calcext:value-type="string"> <text:p>Tuesday</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>Tuesday</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A40]=[$Sheet2.B40])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A42]=[$Sheet2.B42])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1704,13 +1752,13 @@ <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce20" table:formula="of:=COM.MICROSOFT.SWITCH("x";1;"x1";"other")" office:value-type="string" office:string-value="other" calcext:value-type="string"> + <table:table-cell table:style-name="ce23" table:formula="of:=COM.MICROSOFT.SWITCH("x";1;"x1";"other")" office:value-type="string" office:string-value="other" calcext:value-type="string"> <text:p>other</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>other</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A41]=[$Sheet2.B41])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A43]=[$Sheet2.B43])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1719,13 +1767,13 @@ <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.SWITCH("B";"A";"hit0";"B";"hit2";"not found")" office:value-type="string" office:string-value="hit2" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.SWITCH("B";"A";"hit0";"B";"hit2";"not found")" office:value-type="string" office:string-value="hit2" calcext:value-type="string"> <text:p>hit2</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>hit2</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A42]=[$Sheet2.B42])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A44]=[$Sheet2.B44])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1734,67 +1782,67 @@ <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F40];[$data.F37];"one";[$data.F38];"two";[$data.F39];"three";"no luck")" office:value-type="string" office:string-value="two" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F40];[$data.F37];"one";[$data.F38];"two";[$data.F39];"three";"no luck")" office:value-type="string" office:string-value="two" calcext:value-type="string"> <text:p>two</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce27" office:value-type="string" calcext:value-type="string"> <text:p>two</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A43]=[$Sheet2.B43])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A45]=[$Sheet2.B45])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH($data.F40;$data.F37;"one";$data.F38;"two";$data.F39;"three";"no luck")</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="1019"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F38];[$data.F37];1;[$data.F40];2;[$data.F39];3;"not found")" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.SWITCH([$data.F38];[$data.F37];1;[$data.F40];2;[$data.F39];3;"not found")" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A44]=[$Sheet2.B44])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A46]=[$Sheet2.B46])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH($data.F38;$data.F37;1;$data.F40;2;$data.F39;3;"not found")</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce59"/> + <table:table-cell table:style-name="ce56"/> <table:table-cell/> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="1016"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce18" table:formula="of:=COM.MICROSOFT.SWITCH(2;[$data.F37];"one";[$data.F38];2;[$data.F38];-SQRT(16);FALSE())" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce21" table:formula="of:=COM.MICROSOFT.SWITCH(2;[$data.F37];"one";[$data.F38];2;[$data.F38];-SQRT(16);FALSE())" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A45]=[$Sheet2.B45])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A47]=[$Sheet2.B47])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH(2;$data.F37;"one";$data.F38;2;$data.F38;-SQRT(16);FALSE())</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce59"/> + <table:table-cell table:style-name="ce56"/> <table:table-cell/> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="1016"/> </table:table-row> <table:table-row table:style-name="ro2"> - <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.G53];[$Sheet2.G46:.G52];[$Sheet2.H46:.H52])" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#N/B</text:p> + <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.G55];[$Sheet2.G48:.G54];[$Sheet2.H48:.H54])" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#N/A</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#N/B</text:p> + <table:table-cell table:style-name="ce27" table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#N/A</text:p> </table:table-cell> - <table:table-cell table:style-name="ce45" table:formula="of:=IF(ISNA([$Sheet2.A46]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce42" table:formula="of:=IF(ISNA([$Sheet2.A48]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1807,19 +1855,19 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>sun</text:p> </table:table-cell> - <table:table-cell table:style-name="ce68" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="8"> + <table:table-cell table:style-name="ce65" office:value-type="string" calcext:value-type="string" table:number-columns-spanned="1" table:number-rows-spanned="8"> <text:p>These rows must be kept together because of intersection tests</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.G53];[$Sheet2.G46:.G52];[$Sheet2.H46:.H52])" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#N/B</text:p> + <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.G55];[$Sheet2.G48:.G54];[$Sheet2.H48:.H54])" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#N/A</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#N/B</text:p> + <table:table-cell table:style-name="ce27" table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#N/A</text:p> </table:table-cell> - <table:table-cell table:style-name="ce46" table:formula="of:=IF(ISNA([$Sheet2.A47]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce43" table:formula="of:=IF(ISNA([$Sheet2.A49]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1832,17 +1880,17 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>mon</text:p> </table:table-cell> - <table:covered-table-cell table:style-name="ce69"/> + <table:covered-table-cell table:style-name="ce66"/> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.G53];[$Sheet2.G46:.G52];[$Sheet2.H46:.H52])" office:value-type="string" office:string-value="tue" calcext:value-type="string"> + <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.G55];[$Sheet2.G48:.G54];[$Sheet2.H48:.H54])" office:value-type="string" office:string-value="tue" calcext:value-type="string"> <text:p>tue</text:p> </table:table-cell> - <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce25" office:value-type="string" calcext:value-type="string"> <text:p>tue</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=([$Sheet2.A48]=[$Sheet2.B48])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce29" table:formula="of:=([$Sheet2.A50]=[$Sheet2.B50])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1855,17 +1903,17 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>tue</text:p> </table:table-cell> - <table:covered-table-cell table:style-name="ce69"/> + <table:covered-table-cell table:style-name="ce66"/> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.E54];[$Sheet2.G47:.G53];[$Sheet2.H47:.H53])" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#N/B</text:p> + <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.E56];[$Sheet2.G49:.G55];[$Sheet2.H49:.H55])" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#N/A</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error"> - <text:p>#N/B</text:p> + <table:table-cell table:style-name="ce27" table:formula="of:=#N/A" office:value-type="string" office:string-value="" calcext:value-type="error"> + <text:p>#N/A</text:p> </table:table-cell> - <table:table-cell table:style-name="ce47" table:formula="of:=IF(ISNA([$Sheet2.A49]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce44" table:formula="of:=IF(ISNA([$Sheet2.A51]);1;0)" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1878,17 +1926,17 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>wed</text:p> </table:table-cell> - <table:covered-table-cell table:style-name="ce69"/> + <table:covered-table-cell table:style-name="ce66"/> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.E55];[$Sheet2.E48:.E54];[$Sheet2.F48:.F54])" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.E57];[$Sheet2.E50:.E56];[$Sheet2.F50:.F56])" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce48" table:formula="of:=([$Sheet2.A50]=[$Sheet2.B50])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce45" table:formula="of:=([$Sheet2.A52]=[$Sheet2.B52])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1901,17 +1949,17 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>thu</text:p> </table:table-cell> - <table:covered-table-cell table:style-name="ce69"/> + <table:covered-table-cell table:style-name="ce66"/> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.E56];[$Sheet2.E49:.E55];[$Sheet2.F49:.F55])" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.E58];[$Sheet2.E51:.E57];[$Sheet2.F51:.F57])" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce49" table:formula="of:=([$Sheet2.A51]=[$Sheet2.B51])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce46" table:formula="of:=([$Sheet2.A53]=[$Sheet2.B53])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1924,17 +1972,17 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>fri</text:p> </table:table-cell> - <table:covered-table-cell table:style-name="ce69"/> + <table:covered-table-cell table:style-name="ce66"/> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.E57];[$Sheet2.E50:.E56];[$Sheet2.F50:.F56])" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([$Sheet2.E59];[$Sheet2.E52:.E58];[$Sheet2.F52:.F58])" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce24" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce50" table:formula="of:=([$Sheet2.A52]=[$Sheet2.B52])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce47" table:formula="of:=([$Sheet2.A54]=[$Sheet2.B54])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1947,7 +1995,7 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>sat</text:p> </table:table-cell> - <table:covered-table-cell table:style-name="ce69"/> + <table:covered-table-cell table:style-name="ce66"/> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> @@ -1957,7 +2005,7 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>OK</text:p> </table:table-cell> - <table:table-cell table:style-name="ce51" table:formula="of:=([$Sheet2.A53]=[$Sheet2.B53])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce48" table:formula="of:=([$Sheet2.A55]=[$Sheet2.B55])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1968,17 +2016,17 @@ <text:p>3</text:p> </table:table-cell> <table:table-cell/> - <table:covered-table-cell table:style-name="ce69"/> + <table:covered-table-cell table:style-name="ce66"/> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([.G54];"a";"OK";"NOK")" office:value-type="string" office:string-value="OK" calcext:value-type="string"> + <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([.G56];"a";"OK";"NOK")" office:value-type="string" office:string-value="OK" calcext:value-type="string"> <text:p>OK</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>OK</text:p> </table:table-cell> - <table:table-cell table:style-name="ce52" table:formula="of:=([$Sheet2.A54]=[$Sheet2.B54])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce49" table:formula="of:=([$Sheet2.A56]=[$Sheet2.B56])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -1991,13 +2039,13 @@ <table:table-cell table:number-columns-repeated="1017"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH("A";[.G55];"OK";"NOK")" office:value-type="string" office:string-value="OK" calcext:value-type="string"> + <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH("A";[.G57];"OK";"NOK")" office:value-type="string" office:string-value="OK" calcext:value-type="string"> <text:p>OK</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>OK</text:p> </table:table-cell> - <table:table-cell table:style-name="ce53" table:formula="of:=([$Sheet2.A55]=[$Sheet2.B55])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce50" table:formula="of:=([$Sheet2.A57]=[$Sheet2.B57])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -2016,17 +2064,17 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>OK</text:p> </table:table-cell> - <table:table-cell table:style-name="ce54" table:formula="of:=([$Sheet2.A56]=[$Sheet2.B56])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce51" table:formula="of:=([$Sheet2.A58]=[$Sheet2.B58])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH(IF(2>4;1;2);1;"NOK";2;"OK")</text:p> </table:table-cell> <table:table-cell/> + <table:table-cell table:style-name="ce57"/> <table:table-cell table:style-name="ce60"/> - <table:table-cell table:style-name="ce63"/> - <table:table-cell table:style-name="ce65"> - <office:annotation office:display="true" draw:style-name="gr1" draw:text-style-name="P2" svg:width="28.99mm" svg:height="13.86mm" svg:x="227.52mm" svg:y="233.35mm" draw:caption-point-x="-6.1mm" draw:caption-point-y="15.1mm"> + <table:table-cell table:style-name="ce62"> + <office:annotation office:display="true" draw:style-name="gr1" draw:text-style-name="P2" svg:width="28.99mm" svg:height="13.86mm" svg:x="227.52mm" svg:y="242.38mm" draw:caption-point-x="-6.1mm" draw:caption-point-y="15.1mm"> <dc:date>2016-06-14T00:00:00</dc:date> <text:p text:style-name="P1"><text:span text:style-name="T1">Must be empty for function in A58</text:span></text:p> </office:annotation> @@ -2040,45 +2088,45 @@ <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>OK</text:p> </table:table-cell> - <table:table-cell table:style-name="ce55" table:formula="of:=([$Sheet2.A57]=[$Sheet2.B57])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce52" table:formula="of:=([$Sheet2.A59]=[$Sheet2.B59])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH(1;IF(2>4;1;2);"NOK";1;"OK";"other")</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce61"/> + <table:table-cell table:style-name="ce58"/> <table:table-cell/> - <table:table-cell table:style-name="ce66"/> + <table:table-cell table:style-name="ce63"/> <table:table-cell table:number-columns-repeated="1016"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([.F58];[.H56:.H58];[.I56:.I58])" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:formula="of:=COM.MICROSOFT.SWITCH([.F60];[.H58:.H60];[.I58:.I60])" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> - <table:table-cell table:style-name="ce56" table:formula="of:=([$Sheet2.A58]=[$Sheet2.B58])" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce53" table:formula="of:=([$Sheet2.A60]=[$Sheet2.B60])" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>WAAR</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>=SWITCH(F58;H56:H58;I56:I58)</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce62"/> + <table:table-cell table:style-name="ce59"/> + <table:table-cell table:style-name="ce61"/> <table:table-cell table:style-name="ce64"/> - <table:table-cell table:style-name="ce67"/> <table:table-cell table:number-columns-repeated="1016"/> </table:table-row> - <table:table-row table:style-name="ro1" table:number-rows-repeated="1048517"> + <table:table-row table:style-name="ro1" table:number-rows-repeated="1048515"> <table:table-cell table:number-columns-repeated="1024"/> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:number-columns-repeated="1024"/> </table:table-row> <calcext:conditional-formats> - <calcext:conditional-format calcext:target-range-address="Sheet2.C48:Sheet2.C48 Sheet2.C13:Sheet2.C28 Sheet2.C30:Sheet2.C30 Sheet2.C7:Sheet2.C11 Sheet2.C1:Sheet2.C5 Sheet2.C38:Sheet2.C45"> + <calcext:conditional-format calcext:target-range-address="Sheet2.C50:Sheet2.C50 Sheet2.C13:Sheet2.C28 Sheet2.C30:Sheet2.C30 Sheet2.C7:Sheet2.C11 Sheet2.C1:Sheet2.C5 Sheet2.C40:Sheet2.C47"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C1"/> <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C1"/> <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C1"/> @@ -2093,11 +2141,6 @@ <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C32"/> <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C32"/> </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C33:Sheet2.C33"> - <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C33"/> - <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C33"/> - <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C33"/> - </calcext:conditional-format> <calcext:conditional-format calcext:target-range-address="Sheet2.C34:Sheet2.C34"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C34"/> <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C34"/> @@ -2108,15 +2151,20 @@ <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C35"/> <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C35"/> </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C36:Sheet2.C36"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C36"/> + <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C36"/> + <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C36"/> + </calcext:conditional-format> <calcext:conditional-format calcext:target-range-address="Sheet2.C29:Sheet2.C29"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C29"/> <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C29"/> <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C29"/> </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C37:Sheet2.C37"> - <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C37"/> - <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C37"/> - <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C37"/> + <calcext:conditional-format calcext:target-range-address="Sheet2.C39:Sheet2.C39"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C39"/> + <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C39"/> + <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C39"/> </calcext:conditional-format> <calcext:conditional-format calcext:target-range-address="Sheet2.C12:Sheet2.C12"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C12"/> @@ -2128,36 +2176,26 @@ <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C6"/> <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C6"/> </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C46:Sheet2.C46"> - <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C46"/> - <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C46"/> - <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C46"/> - </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C47:Sheet2.C47"> - <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C47"/> - <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C47"/> - <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C47"/> + <calcext:conditional-format calcext:target-range-address="Sheet2.C48:Sheet2.C48"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C48"/> + <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C48"/> + <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C48"/> </calcext:conditional-format> <calcext:conditional-format calcext:target-range-address="Sheet2.C49:Sheet2.C49"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C49"/> <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C49"/> <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C49"/> </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C36:Sheet2.C36"> - <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C36"/> - <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C36"/> - <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C36"/> - </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C50:Sheet2.C50"> - <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C50"/> - <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C50"/> - <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C50"/> - </calcext:conditional-format> <calcext:conditional-format calcext:target-range-address="Sheet2.C51:Sheet2.C51"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C51"/> <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C51"/> <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C51"/> </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C37:Sheet2.C37"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C37"/> + <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C37"/> + <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C37"/> + </calcext:conditional-format> <calcext:conditional-format calcext:target-range-address="Sheet2.C52:Sheet2.C52"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C52"/> <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C52"/> @@ -2193,60 +2231,80 @@ <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C58"/> <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C58"/> </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C59:Sheet2.C59"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C59"/> + <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C59"/> + <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C59"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C60:Sheet2.C60"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C60"/> + <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C60"/> + <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C60"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C38:Sheet2.C38"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C38"/> + <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C38"/> + <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C38"/> + </calcext:conditional-format> + <calcext:conditional-format calcext:target-range-address="Sheet2.C33:Sheet2.C33"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="OK" calcext:value="=1" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="NOK" calcext:value="=0" calcext:base-cell-address="Sheet2.C33"/> + </calcext:conditional-format> </calcext:conditional-formats> </table:table> <table:table table:name="data" table:style-name="ta3"> - <table:table-column table:style-name="co2" table:number-columns-repeated="1024" table:default-cell-style-name="ce17"/> + <table:table-column table:style-name="co2" table:number-columns-repeated="1024" table:default-cell-style-name="ce20"/> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="89" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="89" calcext:value-type="float"> <text:p>89</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1022"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="93" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="93" calcext:value-type="float"> <text:p>93</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1022"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="96" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="96" calcext:value-type="float"> <text:p>96</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1022"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="85" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="85" calcext:value-type="float"> <text:p>85</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="3" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="3" calcext:value-type="float"> <text:p>3</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1022"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="91" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="91" calcext:value-type="float"> <text:p>91</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1022"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="88" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="88" calcext:value-type="float"> <text:p>88</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1022"/> @@ -2255,346 +2313,346 @@ <table:table-cell table:number-columns-repeated="1024"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1021"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="11" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="11" calcext:value-type="float"> <text:p>11</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1021"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1021"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="111" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="111" calcext:value-type="float"> <text:p>111</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce70" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce67" office:value-type="string" calcext:value-type="string"> <text:p>-</text:p> </table:table-cell> - <table:table-cell table:style-name="ce73" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce78" office:value-type="string" calcext:value-type="string"> <text:p>:</text:p> </table:table-cell> - <table:table-cell table:style-name="ce73" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce78" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce75" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce80" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce71" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce68" office:value-type="string" calcext:value-type="string"> <text:p>;</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" office:value-type="string" calcext:value-type="string"> <text:p>,</text:p> </table:table-cell> - <table:table-cell table:style-name="ce18" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce76"/> + <table:table-cell table:style-name="ce81"/> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce71"/> - <table:table-cell table:style-name="ce18"/> - <table:table-cell table:style-name="ce18" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce68"/> + <table:table-cell table:style-name="ce21"/> + <table:table-cell table:style-name="ce21" office:value-type="string" calcext:value-type="string"> <text:p>c</text:p> </table:table-cell> - <table:table-cell table:style-name="ce76" office:value-type="float" office:value="3" calcext:value-type="float"> + <table:table-cell table:style-name="ce81" office:value-type="float" office:value="3" calcext:value-type="float"> <text:p>3</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:number-columns-repeated="5"/> - <table:table-cell table:style-name="ce71"/> - <table:table-cell table:style-name="ce18"/> - <table:table-cell table:style-name="ce18" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce68"/> + <table:table-cell table:style-name="ce21"/> + <table:table-cell table:style-name="ce21" office:value-type="string" calcext:value-type="string"> <text:p>d</text:p> </table:table-cell> - <table:table-cell table:style-name="ce76" office:value-type="float" office:value="4" calcext:value-type="float"> + <table:table-cell table:style-name="ce81" office:value-type="float" office:value="4" calcext:value-type="float"> <text:p>4</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce72"/> - <table:table-cell table:style-name="ce74"/> - <table:table-cell table:style-name="ce74" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce69"/> + <table:table-cell table:style-name="ce79"/> + <table:table-cell table:style-name="ce79" office:value-type="string" calcext:value-type="string"> <text:p>e</text:p> </table:table-cell> - <table:table-cell table:style-name="ce77" office:value-type="float" office:value="5" calcext:value-type="float"> + <table:table-cell table:style-name="ce82" office:value-type="float" office:value="5" calcext:value-type="float"> <text:p>5</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1015"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="11" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="11" calcext:value-type="float"> <text:p>11</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="12" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="12" calcext:value-type="float"> <text:p>12</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="200" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="200" calcext:value-type="float"> <text:p>200</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="89" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="89" calcext:value-type="float"> <text:p>89</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="13" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="13" calcext:value-type="float"> <text:p>13</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="300" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="300" calcext:value-type="float"> <text:p>300</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="93" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="93" calcext:value-type="float"> <text:p>93</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="14" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="14" calcext:value-type="float"> <text:p>14</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="300" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="300" calcext:value-type="float"> <text:p>300</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="60" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="60" calcext:value-type="float"> <text:p>60</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="15" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="15" calcext:value-type="float"> <text:p>15</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="400" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="400" calcext:value-type="float"> <text:p>400</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="71" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="71" calcext:value-type="float"> <text:p>71</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:number-columns-repeated="5"/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="58" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="58" calcext:value-type="float"> <text:p>58</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="58" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="58" calcext:value-type="float"> <text:p>58</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="11" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="11" calcext:value-type="float"> <text:p>11</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="3" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="3" calcext:value-type="float"> <text:p>3</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> @@ -2603,399 +2661,399 @@ <table:table-cell table:number-columns-repeated="1024"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Sunday</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Monday</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1017"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Tuesday</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Wednesday</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Thursday</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Friday</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> <table:table-cell table:number-columns-repeated="5"/> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Saturday</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce18" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce21" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="200" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="200" calcext:value-type="float"> <text:p>200</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce18" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce21" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="300" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="300" calcext:value-type="float"> <text:p>300</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce18" office:value-type="float" office:value="3" calcext:value-type="float"> + <table:table-cell table:style-name="ce21" office:value-type="float" office:value="3" calcext:value-type="float"> <text:p>3</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce18" table:formula="of:=SQRT(4)" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce21" table:formula="of:=SQRT(4)" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="400" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="400" calcext:value-type="float"> <text:p>400</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:number-columns-repeated="4"/> + <table:table-cell table:style-name="ce22" table:number-columns-repeated="4"/> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="99" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="99" calcext:value-type="float"> <text:p>99</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="99" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="99" calcext:value-type="float"> <text:p>99</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="200" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="200" calcext:value-type="float"> <text:p>200</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="2" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="2" calcext:value-type="float"> <text:p>2</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="300" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="300" calcext:value-type="float"> <text:p>300</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="3" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="3" calcext:value-type="float"> <text:p>3</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1018"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="50" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="50" calcext:value-type="float"> <text:p>50</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="400" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="400" calcext:value-type="float"> <text:p>400</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" table:number-columns-repeated="4"/> + <table:table-cell table:style-name="ce22" table:number-columns-repeated="4"/> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="10" calcext:value-type="float"> <text:p>10</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="100" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="100" calcext:value-type="float"> <text:p>100</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="11" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="11" calcext:value-type="float"> <text:p>11</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="1" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="1" calcext:value-type="float"> <text:p>1</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>a</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Technical</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="8" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="8" calcext:value-type="float"> <text:p>8</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> </table:table-row> <table:table-row table:style-name="ro1"> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="12" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="12" calcext:value-type="float"> <text:p>12</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>b</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce22" office:value-type="string" calcext:value-type="string"> <text:p>Business</text:p> </table:table-cell> - <table:table-cell table:style-name="ce19" office:value-type="float" office:value="0" calcext:value-type="float"> + <table:table-cell table:style-name="ce22" office:value-type="float" office:value="0" calcext:value-type="float"> <text:p>0</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="1020"/> diff --git a/sc/source/core/tool/interpr8.cxx b/sc/source/core/tool/interpr8.cxx index b62fb59cde30..972b125267c0 100644 --- a/sc/source/core/tool/interpr8.cxx +++ b/sc/source/core/tool/interpr8.cxx @@ -1897,7 +1897,15 @@ void ScInterpreter::ScIfs_MS() //push result : FormulaTokenRef xToken( PopToken() ); if ( xToken ) + { + // Remove unused arguments of IFS from the stack before pushing the result. + while ( nParamCount > 1 ) + { + Pop(); + nParamCount--; + } PushTempToken( xToken.get() ); + } else PushError( errUnknownStackVariable ); } @@ -2000,7 +2008,15 @@ void ScInterpreter::ScSwitch_MS() // push result FormulaTokenRef xToken( PopToken() ); if ( xToken ) + { + // Remove unused arguments of SWITCH from the stack before pushing the result. + while ( nParamCount > 1 ) + { + Pop(); + nParamCount--; + } PushTempToken( xToken.get() ); + } else PushError( errUnknownStackVariable ); } |