diff options
| author | Zdeněk Crhonek <zcrhonek@gmail.com> | 2016-09-18 13:59:34 +0200 |
|---|---|---|
| committer | Markus Mohrhard <markus.mohrhard@googlemail.com> | 2016-11-23 12:45:48 +0000 |
| commit | 382af8a6fa2d44d28539b3eb563f694114916733 (patch) | |
| tree | d89743dd083b618cc51237ec24314044334743f4 /sc/qa | |
| parent | 71862564df1422f84340e421bbef9060c4e41a71 (diff) | |
update DVB test case (add tests for bug tdf#101204)
Change-Id: I8095bda9e3074c889476759de549bcbb58db9577
Reviewed-on: https://gerrit.libreoffice.org/28991
Tested-by: Jenkins <ci@libreoffice.org>
Reviewed-by: Markus Mohrhard <markus.mohrhard@googlemail.com>
Diffstat (limited to 'sc/qa')
| -rw-r--r-- | sc/qa/unit/data/functions/fods/vdb.fods | 1396 |
1 files changed, 973 insertions, 423 deletions
diff --git a/sc/qa/unit/data/functions/fods/vdb.fods b/sc/qa/unit/data/functions/fods/vdb.fods index c8d1ef0e81f5..734c0e4c7db2 100644 --- a/sc/qa/unit/data/functions/fods/vdb.fods +++ b/sc/qa/unit/data/functions/fods/vdb.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-07-26T21:02:46.056141846</meta:creation-date><meta:editing-duration>P0D</meta:editing-duration><meta:editing-cycles>1</meta:editing-cycles><meta:generator>LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/f9f090d0d0f2b454d6c1dd14fe735e7e83fda9da</meta:generator><meta:document-statistic meta:table-count="2" meta:cell-count="173" meta:object-count="0"/></office:meta> + <office:meta><meta:creation-date>2016-07-26T21:02:46.056141846</meta:creation-date><meta:editing-duration>P0D</meta:editing-duration><meta:editing-cycles>1</meta:editing-cycles><meta:generator>LibreOfficeDev/5.3.0.0.alpha0$Linux_X86_64 LibreOffice_project/7b660e1423554928350e1de2cd4cb7eb577a27ec</meta:generator><meta:document-statistic meta:table-count="2" meta:cell-count="349" 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">49023</config:config-item> - <config:config-item config:name="VisibleAreaHeight" config:type="int">29437</config:config-item> + <config:config-item config:name="VisibleAreaWidth" config:type="int">49692</config:config-item> + <config:config-item config:name="VisibleAreaHeight" config:type="int">47767</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> @@ -31,8 +31,8 @@ <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">3</config:config-item> - <config:config-item config:name="CursorPositionY" config:type="int">9</config:config-item> + <config:config-item config:name="CursorPositionX" config:type="int">2</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">0</config:config-item> <config:config-item config:name="HorizontalSplitPosition" config:type="int">0</config:config-item> @@ -41,7 +41,7 @@ <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">0</config:config-item> + <config:config-item config:name="PositionBottom" config:type="int">46</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">75</config:config-item> <config:config-item config:name="PageViewZoomValue" config:type="int">60</config:config-item> @@ -125,7 +125,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">kQH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAtwAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkxldHRlcgAAEgBDT01QQVRfRFVQTEVYX01PREUKAERVUExFWF9PRkY=</config:config-item> + <config:config-item config:name="PrinterSetup" config:type="base64Binary">sgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMA0wAAAAAAAAAIAFZUAAAkbQAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhCkR1cGxleDpOb25lAElucHV0U2xvdDpUcmF5MQBQYWdlU2l6ZTpMZXR0ZXIAABIAQ09NUEFUX0RVUExFWF9NT0RFDwBEdXBsZXhNb2RlOjpPZmY=</config:config-item> <config:config-item config:name="ApplyUserData" config:type="boolean">false</config:config-item> <config:config-item config:name="CharacterCompressionType" config:type="short">0</config:config-item> </config:config-item-set> @@ -804,7 +804,7 @@ <number:text> </number:text> </number:number-style> <number:number-style style:name="N233P2" style:volatile="true"> - <number:text> -</number:text> + <number:text>-</number:text> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="0"/> <number:text> </number:text> </number:number-style> @@ -825,7 +825,7 @@ <number:text> € </number:text> </number:number-style> <number:number-style style:name="N237P2" style:volatile="true"> - <number:text> -</number:text> + <number:text>-</number:text> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="0"/> <number:text> € </number:text> </number:number-style> @@ -1214,7 +1214,7 @@ <number:text>)</number:text> </number:number-style> <number:number-style style:name="N295P2" style:volatile="true"> - <number:text> -</number:text> + <number:text>-</number:text> <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="0"/> <number:text> </number:text> </number:number-style> @@ -1490,6 +1490,19 @@ <number:number-style style:name="N343"> <number:number number:decimal-places="19" loext:min-decimal-places="19" number:min-integer-digits="1"/> </number:number-style> + <number:currency-style style:name="N345P0" style:volatile="true"> + <number:currency-symbol number:language="nl" number:country="NL">€</number:currency-symbol> + <number:text> </number:text> + <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> + </number:currency-style> + <number:currency-style style:name="N345"> + <style:text-properties fo:color="#ff0000"/> + <number:currency-symbol number:language="nl" number:country="NL">€</number:currency-symbol> + <number:text> </number:text> + <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> + <number:text>-</number:text> + <style:map style:condition="value()>=0" style:apply-style-name="N345P0"/> + </number:currency-style> <number:date-style style:name="N10121" number:language="en" number:country="US"> <number:month/> <number:text>/</number:text> @@ -1835,7 +1848,7 @@ <style:table-column-properties fo:break-before="auto" style:column-width="46.46pt"/> </style:style> <style:style style:name="co10" style:family="table-column"> - <style:table-column-properties fo:break-before="auto" style:column-width="57.29pt"/> + <style:table-column-properties fo:break-before="auto" style:column-width="76.25pt"/> </style:style> <style:style style:name="co11" style:family="table-column"> <style:table-column-properties fo:break-before="auto" style:column-width="78.29pt"/> @@ -1879,10 +1892,9 @@ <style:style style:name="ta1" style:family="table" style:master-page-name="Default"> <style:table-properties table:display="true" style:writing-mode="lr-tb"/> </style:style> - <number:percentage-style style:name="N10"> - <number:number number:decimal-places="0" loext:min-decimal-places="0" number:min-integer-digits="1"/> - <number:text>%</number:text> - </number:percentage-style> + <number:number-style style:name="N4"> + <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> + </number:number-style> <number:percentage-style style:name="N11"> <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1"/> <number:text>%</number:text> @@ -1908,30 +1920,29 @@ <number:number number:decimal-places="2" loext:min-decimal-places="2" number:min-integer-digits="1" number:grouping="true"/> <style:map style:condition="value()>=0" style:apply-style-name="N104P0"/> </number:currency-style> + <style:style style:name="ce1" style:family="table-cell" style:parent-style-name="Default"/> <style:style style:name="ce2" 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="start" fo:margin-left="0pt"/> - <style:text-properties style:text-position="" fo:font-size="20pt" fo:font-weight="bold" style:font-size-asian="20pt" style:font-weight-asian="bold" style:font-size-complex="20pt" style:font-weight-complex="bold"/> + <style:text-properties fo:font-size="20pt" fo:font-weight="bold" style:font-size-asian="20pt" style:font-weight-asian="bold" style:font-size-complex="20pt" style:font-weight-complex="bold"/> </style:style> <style:style style:name="ce3" 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="0pt"/> - <style:text-properties style:text-position="" fo:font-size="14pt" fo:font-weight="bold" style:font-size-asian="14pt" style:font-weight-asian="bold" style:font-size-complex="14pt" style:font-weight-complex="bold"/> + <style:text-properties fo:font-size="14pt" fo:font-weight="bold" style:font-size-asian="14pt" style:font-weight-asian="bold" style:font-size-complex="14pt" style:font-weight-complex="bold"/> </style:style> <style:style style:name="ce4" 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="0pt"/> - <style:text-properties style:text-position="" fo:font-size="12pt" fo:font-weight="bold" style:font-size-asian="12pt" style:font-weight-asian="bold" style:font-size-complex="12pt" style:font-weight-complex="bold"/> + <style:text-properties fo:font-size="12pt" fo:font-weight="bold" style:font-size-asian="12pt" style:font-weight-asian="bold" style:font-size-complex="12pt" style:font-weight-complex="bold"/> </style:style> <style:style style:name="ce5" 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="0pt"/> - <style:text-properties style:text-position=""/> </style:style> <style:style style:name="ce6" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> - <style:text-properties style:text-position=""/> <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="Untitled1" style:base-cell-address="Sheet1.B3"/> <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/> @@ -1939,7 +1950,6 @@ <style:style style:name="ce7" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> - <style:text-properties style:text-position=""/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/> <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/> <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/> @@ -1947,158 +1957,108 @@ <style:style style:name="ce8" 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="0pt"/> - <style:text-properties style:text-position=""/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/> <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/> <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/> </style:style> <style:style style:name="ce9" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:wrap-option="wrap"/> - <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="Liberation Serif" fo:font-size="10pt" fo:language="en" fo:country="US" 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-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" 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"/> - </style:style> - <style:style style:name="ce10" style:family="table-cell" style:parent-style-name="Default"/> - <style:style style:name="ce11" 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="start" fo:margin-left="0pt"/> - <style:text-properties fo:font-size="20pt" fo:font-weight="bold" style:font-size-asian="20pt" style:font-weight-asian="bold" style:font-size-complex="20pt" style:font-weight-complex="bold"/> - </style:style> - <style:style style:name="ce12" 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="0pt"/> - <style:text-properties fo:font-size="14pt" fo:font-weight="bold" style:font-size-asian="14pt" style:font-weight-asian="bold" style:font-size-complex="14pt" style:font-weight-complex="bold"/> - </style:style> - <style:style style:name="ce13" 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="0pt"/> - <style:text-properties fo:font-size="12pt" fo:font-weight="bold" style:font-size-asian="12pt" style:font-weight-asian="bold" style:font-size-complex="12pt" style:font-weight-complex="bold"/> - </style:style> - <style:style style:name="ce14" 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="0pt"/> - </style:style> - <style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> - <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> - <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> - <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="Untitled1" style:base-cell-address="Sheet1.B3"/> - <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B3"/> - </style:style> - <style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> - <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> - <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> - <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/> - <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/> - </style:style> - <style:style style:name="ce17" 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="0pt"/> - <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet1.B8"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet1.B8"/> - <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet1.B8"/> - </style:style> - <style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default"> - <style:table-cell-properties fo:wrap-option="wrap"/> <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="Liberation Serif" fo:font-size="10pt" fo:language="en" fo:country="US" 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-size-asian="10pt" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" 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"/> </style:style> - <style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce10" 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="0pt"/> <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/> </style:style> - <style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N104"/> - <style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N104"> + <style:style style:name="ce11" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N104"/> + <style:style style:name="ce12" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N104"> <style:table-cell-properties fo:wrap-option="wrap"/> <style:text-properties style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" fo:language="en" fo:country="US" 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:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" 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"/> </style:style> - <style:style style:name="ce22" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N342"> + <style:style style:name="ce13" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N342"> <style:table-cell-properties fo:background-color="transparent"/> </style:style> - <style:style style:name="ce23" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N342"> + <style:style style:name="ce14" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N342"> <style:table-cell-properties fo:background-color="transparent"/> <style:text-properties fo:color="#000000" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Calibri1" fo:font-size="11pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="normal" style:font-size-asian="11pt" style:font-style-asian="normal" style:font-weight-asian="normal" style:font-size-complex="11pt" 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:data-style-name="N164"/> - <style:style style:name="ce25" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N11"/> - <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:style style:name="ce15" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N164"/> + <style:style style:name="ce16" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N11"/> + <style:style style:name="ce17" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C2"/> <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C2"/> <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C2"/> </style:style> - <style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:style style:name="ce18" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C4"/> <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C4"/> <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C4"/> </style:style> - <style:style style:name="ce28" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:style style:name="ce19" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> + <style:text-properties style:font-name="Calibri" style:font-name-asian="Droid Sans Fallback" style:font-name-complex="Droid Sans Devanagari"/> + <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C33"/> + <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C33"/> + <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C33"/> + </style:style> + <style:style style:name="ce20" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C4"/> <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C4"/> <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C4"/> </style:style> - <style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Default"> - <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C37"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C37"/> - <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C37"/> - </style:style> - <style:style style:name="ce30" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"> - <style:table-cell-properties style:text-align-source="fix" style:repeat-content="false"/> - <style:paragraph-properties fo:text-align="center" fo:margin-left="0pt"/> - <style:map style:condition="cell-content()=""" style:apply-style-name="Default" style:base-cell-address="Sheet2.C37"/> - <style:map style:condition="cell-content()=0" style:apply-style-name="Untitled1" style:base-cell-address="Sheet2.C37"/> - <style:map style:condition="cell-content()=1" style:apply-style-name="Untitled2" style:base-cell-address="Sheet2.C37"/> - </style:style> - <style:style style:name="ce31" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce21" style:family="table-cell" style:parent-style-name="Default"> <style:text-properties style:font-name="Liberation Serif" style:font-name-asian="Microsoft YaHei" style:font-name-complex="Mangal"/> </style:style> - <style:style style:name="ce32" 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="fix" style:repeat-content="false"/> <style:paragraph-properties fo:text-align="end" fo:margin-left="0pt"/> </style:style> - <style:style style:name="ce33" 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 fo:wrap-option="wrap"/> <style:text-properties style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" fo:language="en" fo:country="US" 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:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" 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"/> </style:style> - <style:style style:name="ce34" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N10"/> - <style:style style:name="ce35" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N296"> + <style:style style:name="ce24" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N296"> <style:table-cell-properties fo:background-color="transparent"/> </style:style> - <style:style style:name="ce36" 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:padding="2.01pt"/> <style:text-properties fo:color="#000000" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Bitstream Vera Sans" 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="Bitstream Vera Sans" style:font-size-complex="10pt" style:font-style-complex="normal" style:font-weight-complex="normal"/> </style:style> - <style:style style:name="ce37" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N165"/> - <style:style style:name="ce38" style:family="table-cell" style:parent-style-name="Default"> - <style:table-cell-properties fo:border="none"/> - </style:style> - <style:style style:name="ce39" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce26" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N165"/> + <style:style style:name="ce27" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N4"/> + <style:style style:name="ce28" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N345"/> + <style:style style:name="ce29" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties fo:wrap-option="wrap"/> <style:text-properties style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" fo:language="en" fo:country="US" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="bold" style:text-underline-mode="continuous" style:text-overline-mode="continuous" style:text-line-through-mode="continuous" style:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" 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"/> </style:style> - <style:style style:name="ce40" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36"> + <style:style style:name="ce30" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N36"> <style:table-cell-properties fo:border="none"/> </style:style> - <style:style style:name="ce41" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce31" style:family="table-cell" style:parent-style-name="Default"> + <style:table-cell-properties fo:border="none"/> + </style:style> + <style:style style:name="ce32" style:family="table-cell" style:parent-style-name="Default"> <style:text-properties style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" fo:language="en" fo:country="US" 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:language-asian="zh" style:country-asian="CN" style:font-style-asian="normal" style:font-weight-asian="normal" 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"/> </style:style> - <style:style style:name="ce42" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N336"/> - <style:style style:name="ce43" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce33" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:glyph-orientation-vertical="0" style:text-align-source="value-type" style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr" fo:padding="2.01pt" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="middle" loext:vertical-justify="auto"/> <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0pt" style:writing-mode="page"/> <style:text-properties fo:color="#000000" style:text-outline="false" style:text-line-through-style="none" style:text-line-through-type="none" style:font-name="Calibri" fo:font-size="11pt" fo:font-style="normal" fo:text-shadow="none" style:text-underline-style="none" fo:font-weight="bold" style:font-size-asian="11pt" style:font-style-asian="normal" style:font-weight-asian="bold" style:font-size-complex="11pt" style:font-style-complex="normal" style:font-weight-complex="bold"/> </style:style> - <style:style style:name="ce44" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce34" style:family="table-cell" style:parent-style-name="Default"> <style:text-properties fo:font-weight="bold" style:font-weight-asian="bold" style:font-weight-complex="bold"/> </style:style> - <style:style style:name="ce45" style:family="table-cell" style:parent-style-name="Default"> + <style:style style:name="ce35" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N99"/> + <style:style style:name="ce36" style:family="table-cell" style:parent-style-name="Default"> <style:table-cell-properties style:glyph-orientation-vertical="0" style:text-align-source="value-type" style:repeat-content="false" fo:wrap-option="wrap" style:direction="ltr" fo:padding="2.01pt" style:rotation-angle="0" style:rotation-align="none" style:shrink-to-fit="false" style:vertical-align="middle" loext:vertical-justify="auto"/> <style:paragraph-properties css3t:text-justify="auto" fo:margin-left="0pt" style:writing-mode="page"/> </style:style> + <style:style style:name="ce37" style:family="table-cell" style:parent-style-name="Default" style:data-style-name="N336"/> <style:style style:name="ta_extref" style:family="table"> <style:table-properties table:display="false"/> </style:style> @@ -2160,7 +2120,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-07-26">00/00/0000</text:date>, <text:time style:data-style-name="N2" text:time-value="21:02:37.173584306">00:00:00</text:time></text:p> + <text:p><text:date style:data-style-name="N2" text:date-value="2016-09-18">00/00/0000</text:date>, <text:time style:data-style-name="N2" text:time-value="13:42:08.907362288">00:00:00</text:time></text:p> </style:region-right> </style:header> <style:header-left style:display="false"/> @@ -2188,10 +2148,10 @@ <table:table table:name="Sheet1" table:style-name="ta1"> <office:forms form:automatic-focus="false" form:apply-design-mode="false"/> <table:table-column table:style-name="co1" table:default-cell-style-name="Default"/> - <table:table-column table:style-name="co1" table:default-cell-style-name="ce14"/> + <table:table-column table:style-name="co1" table:default-cell-style-name="ce5"/> <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="ce11" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce2" office:value-type="string" calcext:value-type="string"> <text:p>VDB Function</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> @@ -2200,10 +2160,10 @@ <table:table-cell table:number-columns-repeated="3"/> </table:table-row> <table:table-row table:style-name="ro3"> - <table:table-cell table:style-name="ce12" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce3" office:value-type="string" calcext:value-type="string"> <text:p>Result</text:p> </table:table-cell> - <table:table-cell table:style-name="ce15" table:formula="of:=AND([.B8:.B95])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce6" table:formula="of:=AND([.B8:.B95])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> <table:table-cell/> @@ -2212,13 +2172,13 @@ <table:table-cell table:number-columns-repeated="3"/> </table:table-row> <table:table-row table:style-name="ro4"> - <table:table-cell table:style-name="ce13" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string"> <text:p>Sheet</text:p> </table:table-cell> - <table:table-cell table:style-name="ce13" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string"> <text:p>Result</text:p> </table:table-cell> - <table:table-cell table:style-name="ce13" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce4" office:value-type="string" calcext:value-type="string"> <text:p>Description</text:p> </table:table-cell> </table:table-row> @@ -2226,7 +2186,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="ce16" table:formula="of:=AND([Sheet2.C2:.C349])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce7" table:formula="of:=AND([Sheet2.C2:.C349])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> @@ -2235,37 +2195,37 @@ </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="3"> <table:table-cell/> - <table:table-cell table:style-name="ce17"/> + <table:table-cell table:style-name="ce8"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2"> <table:table-cell/> - <table:table-cell table:style-name="ce17"/> - <table:table-cell table:style-name="ce18"/> + <table:table-cell table:style-name="ce8"/> + <table:table-cell table:style-name="ce9"/> </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="4"> <table:table-cell/> - <table:table-cell table:style-name="ce17"/> + <table:table-cell table:style-name="ce8"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro6"> <table:table-cell/> - <table:table-cell table:style-name="ce17"/> + <table:table-cell table:style-name="ce8"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="4"> <table:table-cell/> - <table:table-cell table:style-name="ce17"/> + <table:table-cell table:style-name="ce8"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro6"> <table:table-cell/> - <table:table-cell table:style-name="ce17"/> + <table:table-cell table:style-name="ce8"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="16"> <table:table-cell/> - <table:table-cell table:style-name="ce17"/> + <table:table-cell table:style-name="ce8"/> <table:table-cell/> </table:table-row> <table:table-row table:style-name="ro2" table:number-rows-repeated="1048537"> @@ -2291,7 +2251,7 @@ <office:forms form:automatic-focus="false" form:apply-design-mode="false"/> <table:table-column table:style-name="co4" table:default-cell-style-name="Default"/> <table:table-column table:style-name="co5" table:default-cell-style-name="Default"/> - <table:table-column table:style-name="co6" table:default-cell-style-name="ce14"/> + <table:table-column table:style-name="co6" table:default-cell-style-name="ce5"/> <table:table-column table:style-name="co7" table:default-cell-style-name="Default"/> <table:table-column table:style-name="co4" table:default-cell-style-name="Default"/> <table:table-column table:style-name="co8" table:default-cell-style-name="Default"/> @@ -2302,842 +2262,1437 @@ <table:table-column table:style-name="co13" table:number-columns-repeated="2" table:default-cell-style-name="Default"/> <table:table-column table:style-name="co3" table:number-columns-repeated="8" table:default-cell-style-name="Default"/> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce19" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce10" office:value-type="string" calcext:value-type="string"> <text:p>Function</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="ce10" office:value-type="string" calcext:value-type="string"> <text:p>Expected</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="ce10" office:value-type="string" calcext:value-type="string"> <text:p>Correct</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="ce10" office:value-type="string" calcext:value-type="string"> <text:p>FunctionString</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="ce10" office:value-type="string" calcext:value-type="string"> <text:p>Comment</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce39" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce29" office:value-type="string" calcext:value-type="string"> <text:p>Data </text:p> </table:table-cell> - <table:table-cell table:style-name="ce39" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce29" office:value-type="string" calcext:value-type="string"> <text:p>Description </text:p> </table:table-cell> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce39" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce39" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce39" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce29" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;10;20;2)" office:value-type="currency" office:currency="USD" office:value="8603.80245372397" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;10;20;2)" office:value-type="currency" office:currency="USD" office:value="8603.80245372397" calcext:value-type="currency"> <text:p>$8,603.80</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="8603.80245372397" calcext:value-type="float"> <text:p>8603.80245372397</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ROUND([.A2];12)=ROUND([.B2];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ROUND([.A2];12)=ROUND([.B2];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A2])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,2)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A2])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,2)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,20,2)</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce36" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce25" table:number-columns-repeated="2"/> <table:table-cell/> - <table:table-cell table:style-name="ce33" office:value-type="float" office:value="2400" calcext:value-type="float"> + <table:table-cell table:style-name="ce23" office:value-type="float" office:value="2400" calcext:value-type="float"> <text:p>2400</text:p> </table:table-cell> - <table:table-cell table:style-name="ce33" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> <text:p>Initial cost</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(10000; 5000; 5*12; 6; 12; 2; 1)" office:value-type="currency" office:currency="USD" office:value="1501.7926317979" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(10000; 5000; 5*12; 6; 12; 2; 1)" office:value-type="currency" office:currency="USD" office:value="1501.7926317979" calcext:value-type="currency"> <text:p>$1,501.79</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="1501.7926317979" calcext:value-type="float"> <text:p>1501.7926317979</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ROUND([.A3];12)=ROUND([.B3];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ROUND([.A3];12)=ROUND([.B3];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A3])" office:value-type="string" office:string-value="=VDB(10000, 5000, 5*12, 6, 12, 2, 1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A3])" office:value-type="string" office:string-value="=VDB(10000, 5000, 5*12, 6, 12, 2, 1)" calcext:value-type="string"> <text:p>=VDB(10000, 5000, 5*12, 6, 12, 2, 1)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce33" office:value-type="float" office:value="300" calcext:value-type="float"> + <table:table-cell table:style-name="ce23" office:value-type="float" office:value="300" calcext:value-type="float"> <text:p>300</text:p> </table:table-cell> - <table:table-cell table:style-name="ce33" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> <text:p>Salvage value</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(10000; 5000; 5*12; 18; 24; 1; 1)" office:value-type="currency" office:currency="USD" office:value="708.833929085397" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(10000; 5000; 5*12; 18; 24; 1; 1)" office:value-type="currency" office:currency="USD" office:value="708.833929085397" calcext:value-type="currency"> <text:p>$708.83</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="708.833929085397" calcext:value-type="float"> <text:p>708.833929085397</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A4];12)=ROUND([.B4];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A4];12)=ROUND([.B4];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A4])" office:value-type="string" office:string-value="=VDB(10000, 5000, 5*12, 18, 24, 1, 1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A4])" office:value-type="string" office:string-value="=VDB(10000, 5000, 5*12, 18, 24, 1, 1)" calcext:value-type="string"> <text:p>=VDB(10000, 5000, 5*12, 18, 24, 1, 1)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce33" office:value-type="float" office:value="10" calcext:value-type="float"> + <table:table-cell table:style-name="ce23" 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="ce33" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> <text:p>Lifetime in years</text:p> </table:table-cell> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> <table:table-cell/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> </table:table-row> <table:table-row table:style-name="ro8"> - <table:table-cell table:style-name="ce21" table:formula="of:=VDB([.I2]; [.I3]; [.I4]*365; 0; 1)" office:value-type="currency" office:currency="USD" office:value="1.31506849315065" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" table:formula="of:=VDB([.I2]; [.I3]; [.I4]*365; 0; 1)" office:value-type="currency" office:currency="USD" office:value="1.31506849315065" calcext:value-type="currency"> <text:p>$1.32</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="1.31506849315065" calcext:value-type="float"> <text:p>1.31506849315065</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A5];12)=ROUND([.B5];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A5];12)=ROUND([.B5];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="=VDB(I2, I3, I4*365, 0, 1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A5])" office:value-type="string" office:string-value="=VDB(I2, I3, I4*365, 0, 1)" calcext:value-type="string"> <text:p>=VDB(I2, I3, I4*365, 0, 1)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce33" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> <text:p>First day's depreciation. Excel automatically assumes that factor is 2.</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce39" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce29" office:value-type="string" calcext:value-type="string"> <text:p>Formula </text:p> </table:table-cell> - <table:table-cell table:style-name="ce39" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce29" office:value-type="string" calcext:value-type="string"> <text:p>Description </text:p> </table:table-cell> - <table:table-cell table:style-name="ce39" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce29" office:value-type="string" calcext:value-type="string"> <text:p>R esult </text:p> </table:table-cell> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce21" table:formula="of:=VDB([.I2]; [.I3]; [.I4]*12; 0; 1)" office:value-type="currency" office:currency="USD" office:value="40" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" table:formula="of:=VDB([.I2]; [.I3]; [.I4]*12; 0; 1)" office:value-type="currency" office:currency="USD" office:value="40" calcext:value-type="currency"> <text:p>$40.00</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="40" calcext:value-type="float"> <text:p>40</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A6];12)=ROUND([.B6];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A6];12)=ROUND([.B6];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A6])" office:value-type="string" office:string-value="=VDB(I2, I3, I4*12, 0, 1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A6])" office:value-type="string" office:string-value="=VDB(I2, I3, I4*12, 0, 1)" calcext:value-type="string"> <text:p>=VDB(I2, I3, I4*12, 0, 1)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce33" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> <text:p>First month's depreciation.</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="5"/> - <table:table-cell table:style-name="ce21" office:value-type="currency" office:currency="USD" office:value="1.32" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" office:value-type="currency" office:currency="USD" office:value="1.32" calcext:value-type="currency"> <text:p>$1.32</text:p> </table:table-cell> - <table:table-cell table:style-name="ce39" table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce29" table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce32"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce21" table:formula="of:=VDB([.I2]; [.I3]; [.I4]; 0; 1)" office:value-type="currency" office:currency="USD" office:value="480" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" table:formula="of:=VDB([.I2]; [.I3]; [.I4]; 0; 1)" office:value-type="currency" office:currency="USD" office:value="480" calcext:value-type="currency"> <text:p>$480.00</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="480" calcext:value-type="float"> <text:p>480</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A7];12)=ROUND([.B7];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A7];12)=ROUND([.B7];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A7])" office:value-type="string" office:string-value="=VDB(I2, I3, I4, 0, 1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A7])" office:value-type="string" office:string-value="=VDB(I2, I3, I4, 0, 1)" calcext:value-type="string"> <text:p>=VDB(I2, I3, I4, 0, 1)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce33" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> <text:p>First year's depreciation.</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="5"/> - <table:table-cell table:style-name="ce21" office:value-type="currency" office:currency="USD" office:value="40" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" office:value-type="currency" office:currency="USD" office:value="40" calcext:value-type="currency"> <text:p>$40.00</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> <table:table-cell/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce39" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce29" table:number-columns-repeated="3"/> </table:table-row> <table:table-row table:style-name="ro8"> - <table:table-cell table:style-name="ce21" table:formula="of:=VDB([.I2]; [.A3];[.I4]*12; 6; 18)" office:value-type="currency" office:currency="USD" office:value="396.306053264752" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" table:formula="of:=VDB([.I2]; [.A3];[.I4]*12; 6; 18)" office:value-type="currency" office:currency="USD" office:value="396.306053264752" calcext:value-type="currency"> <text:p>$396.31</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="396.306053264752" calcext:value-type="float"> <text:p>396.306053264752</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A8];12)=ROUND([.B8];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A8];12)=ROUND([.B8];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="=VDB(I2, A3,I4*12, 6, 18)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A8])" office:value-type="string" office:string-value="=VDB(I2, A3,I4*12, 6, 18)" calcext:value-type="string"> <text:p>=VDB(I2, A3,I4*12, 6, 18)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce33" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> <text:p>Depreciation between the sixth month and the eighteenth month.</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="5"/> - <table:table-cell table:style-name="ce21" office:value-type="currency" office:currency="USD" office:value="480" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" office:value-type="currency" office:currency="USD" office:value="480" calcext:value-type="currency"> <text:p>$480.00</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce23" table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro9"> - <table:table-cell table:style-name="ce21" table:formula="of:=VDB([.I2]; [.A3]; [.I4]*12; 6; 18; 1.5)" office:value-type="currency" office:currency="USD" office:value="311.808936658233" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" table:formula="of:=VDB([.I2]; [.A3]; [.I4]*12; 6; 18; 1.5)" office:value-type="currency" office:currency="USD" office:value="311.808936658233" calcext:value-type="currency"> <text:p>$311.81</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="311.808936658233" calcext:value-type="float"> <text:p>311.808936658233</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A9];12)=ROUND([.B9];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A9];12)=ROUND([.B9];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A9])" office:value-type="string" office:string-value="=VDB(I2, A3, I4*12, 6, 18, 1.5)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A9])" office:value-type="string" office:string-value="=VDB(I2, A3, I4*12, 6, 18, 1.5)" calcext:value-type="string"> <text:p>=VDB(I2, A3, I4*12, 6, 18, 1.5)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce33" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> <text:p>Depreciation between the sixth month and the eighteenth month using a factor of 1.5 instead of the double-declining balance method.</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="5"/> - <table:table-cell table:style-name="ce21" office:value-type="currency" office:currency="USD" office:value="396.31" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" office:value-type="currency" office:currency="USD" office:value="396.31" calcext:value-type="currency"> <text:p>$396.31</text:p> </table:table-cell> - <table:table-cell table:style-name="ce43" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce33" table:number-columns-repeated="2"/> <table:table-cell table:number-columns-repeated="7"/> </table:table-row> <table:table-row table:style-name="ro10"> - <table:table-cell table:style-name="ce21" table:formula="of:=VDB([.I2]; [.I3]; [.I4]; 0; 0.875; 1.5)" office:value-type="currency" office:currency="USD" office:value="315" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" table:formula="of:=VDB([.I2]; [.I3]; [.I4]; 0; 0.875; 1.5)" office:value-type="currency" office:currency="USD" office:value="315" calcext:value-type="currency"> <text:p>$315.00</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="315" calcext:value-type="float"> <text:p>315</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A10];12)=ROUND([.B10];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A10];12)=ROUND([.B10];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=VDB(I2, I3, I4, 0, 0.875, 1.5)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A10])" office:value-type="string" office:string-value="=VDB(I2, I3, I4, 0, 0.875, 1.5)" calcext:value-type="string"> <text:p>=VDB(I2, I3, I4, 0, 0.875, 1.5)</text:p> </table:table-cell> - <table:table-cell table:style-name="ce33" office:value-type="string" calcext:value-type="string"> + <table:table-cell table:style-name="ce23" office:value-type="string" calcext:value-type="string"> <text:p>Depreciation for the first fiscal year that you own the asset, assuming that tax laws limit you to 150-percent depreciation of the declining balance. Asset is purchased in the middle of the first quarter of the fiscal year.</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="5"/> - <table:table-cell table:style-name="ce21" office:value-type="currency" office:currency="USD" office:value="311.81" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" office:value-type="currency" office:currency="USD" office:value="311.81" calcext:value-type="currency"> <text:p>$311.81</text:p> </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce45"/> - <table:table-cell table:style-name="ce44"/> + <table:table-cell table:style-name="ce36"/> + <table:table-cell table:style-name="ce34"/> <table:table-cell table:number-columns-repeated="6"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(100000;20000;10;7;8)" office:value-type="currency" office:currency="USD" office:value="971.519999999989" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(100000;20000;10;7;8)" office:value-type="currency" office:currency="USD" office:value="971.519999999989" calcext:value-type="currency"> <text:p>$971.52</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="971.519999999989" calcext:value-type="float"> <text:p>971.519999999989</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A11];12)=ROUND([.B11];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A11];12)=ROUND([.B11];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A11])" office:value-type="string" office:string-value="=VDB(100000,20000,10,7,8)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A11])" office:value-type="string" office:string-value="=VDB(100000,20000,10,7,8)" calcext:value-type="string"> <text:p>=VDB(100000,20000,10,7,8)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce21" office:value-type="currency" office:currency="USD" office:value="315" calcext:value-type="currency"> + <table:table-cell table:style-name="ce12" office:value-type="currency" office:currency="USD" office:value="315" calcext:value-type="currency"> <text:p>$315.00</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;10;20;2;1)" office:value-type="currency" office:currency="USD" office:value="8603.80245372398" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;10;20;2;1)" office:value-type="currency" office:currency="USD" office:value="8603.80245372398" calcext:value-type="currency"> <text:p>$8,603.80</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="8603.80245372398" calcext:value-type="float"> <text:p>8603.80245372398</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ROUND([.A12];12)=ROUND([.B12];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ROUND([.A12];12)=ROUND([.B12];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A12])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,20,2,1)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;10;20;2;0)" office:value-type="currency" office:currency="USD" office:value="8603.80245372397" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;10;20;2;0)" office:value-type="currency" office:currency="USD" office:value="8603.80245372397" calcext:value-type="currency"> <text:p>$8,603.80</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="8603.80245372397" calcext:value-type="float"> <text:p>8603.80245372397</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A13];12)=ROUND([.B13];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A13];12)=ROUND([.B13];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A13])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,2,0)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A13])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,2,0)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,20,2,0)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce44" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce34" table:number-columns-repeated="3"/> <table:table-cell table:number-columns-repeated="6"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;10;20;2;-1)" office:value-type="currency" office:currency="USD" office:value="8603.80245372398" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;10;20;2;-1)" office:value-type="currency" office:currency="USD" office:value="8603.80245372398" calcext:value-type="currency"> <text:p>$8,603.80</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="8603.80245372398" calcext:value-type="float"> <text:p>8603.80245372398</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A14];12)=ROUND([.B14];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A14];12)=ROUND([.B14];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,2,-1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A14])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,2,-1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,20,2,-1)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;10;20;2;)" office:value-type="currency" office:currency="USD" office:value="8603.80245372397" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;10;20;2;)" office:value-type="currency" office:currency="USD" office:value="8603.80245372397" calcext:value-type="currency"> <text:p>$8,603.80</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="8603.80245372397" calcext:value-type="float"> <text:p>8603.80245372397</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A15];12)=ROUND([.B15];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A15];12)=ROUND([.B15];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A15])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,2,)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A15])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,2,)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,20,2,)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;10;20;;)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;10;20;;)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ISERROR([.A16])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ISERROR([.A16])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A16])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,,)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A16])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,,)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,20,,)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce41"/> - <table:table-cell table:style-name="ce44" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce34" table:number-columns-repeated="3"/> <table:table-cell table:number-columns-repeated="6"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;10;20;)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;10;20;)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ISERROR([.A17])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ISERROR([.A17])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A17])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A17])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,20,)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;10;20)" office:value-type="currency" office:currency="USD" office:value="8603.80245372397" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;10;20)" office:value-type="currency" office:currency="USD" office:value="8603.80245372397" calcext:value-type="currency"> <text:p>$8,603.80</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="8603.80245372397" calcext:value-type="float"> <text:p>8603.80245372397</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A18];12)=ROUND([.B18];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A18];12)=ROUND([.B18];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A18])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A18])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,20)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;10;;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;10;;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ISERROR([.A19])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ISERROR([.A19])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A19])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A19])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,,2,1)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="16"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;;20;2;1)" office:value-type="currency" office:currency="USD" office:value="23841.7427463641" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;;20;2;1)" office:value-type="currency" office:currency="USD" office:value="23841.7427463641" calcext:value-type="currency"> <text:p>$23,841.74</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="23841.7427463641" calcext:value-type="float"> <text:p>23841.7427463641</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A20];12)=ROUND([.B20];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A20];12)=ROUND([.B20];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A20])" office:value-type="string" office:string-value="=VDB(35000,7500,36,,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A20])" office:value-type="string" office:string-value="=VDB(35000,7500,36,,20,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,,20,2,1)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="16"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;-10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;-10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ISERROR([.A21])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ISERROR([.A21])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A21])" office:value-type="string" office:string-value="=VDB(35000,7500,36,-10,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A21])" office:value-type="string" office:string-value="=VDB(35000,7500,36,-10,20,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,-10,20,2,1)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="16"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;;10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;;10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ISERROR([.A22])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ISERROR([.A22])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A22])" office:value-type="string" office:string-value="=VDB(35000,7500,,10,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A22])" office:value-type="string" office:string-value="=VDB(35000,7500,,10,20,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,,10,20,2,1)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce37" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce26" table:number-columns-repeated="3"/> <table:table-cell table:number-columns-repeated="7"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;;36;10;20;2;1)" office:value-type="currency" office:currency="USD" office:value="8603.80245372398" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;;36;10;20;2;1)" office:value-type="currency" office:currency="USD" office:value="8603.80245372398" calcext:value-type="currency"> <text:p>$8,603.80</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="8603.80245372398" calcext:value-type="float"> <text:p>8603.80245372398</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A23];12)=ROUND([.B23];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A23];12)=ROUND([.B23];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A23])" office:value-type="string" office:string-value="=VDB(35000,,36,10,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A23])" office:value-type="string" office:string-value="=VDB(35000,,36,10,20,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,,36,10,20,2,1)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="16"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(;7500;36;10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(;7500;36;10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:511</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ISERROR([.A24])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ISERROR([.A24])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A24])" office:value-type="string" office:string-value="=VDB(,7500,36,10,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A24])" office:value-type="string" office:string-value="=VDB(,7500,36,10,20,2,1)" calcext:value-type="string"> <text:p>=VDB(,7500,36,10,20,2,1)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce25" table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce16" table:number-columns-repeated="3"/> <table:table-cell table:number-columns-repeated="7"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(300;7500;36;10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(300;7500;36;10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ISERROR([.A25])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ISERROR([.A25])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A25])" office:value-type="string" office:string-value="=VDB(300,7500,36,10,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A25])" office:value-type="string" office:string-value="=VDB(300,7500,36,10,20,2,1)" calcext:value-type="string"> <text:p>=VDB(300,7500,36,10,20,2,1)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>salvage<cost</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="8"/> - <table:table-cell table:style-name="ce40" table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce30" table:number-columns-repeated="5"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;0;10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;0;10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ISERROR([.A26])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ISERROR([.A26])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A26])" office:value-type="string" office:string-value="=VDB(35000,7500,0,10,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A26])" office:value-type="string" office:string-value="=VDB(35000,7500,0,10,20,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,0,10,20,2,1)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Lifetime > 0</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce40" table:number-columns-repeated="9"/> + <table:table-cell table:style-name="ce30" table:number-columns-repeated="9"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;0;20;2;1)" office:value-type="currency" office:currency="USD" office:value="23841.7427463641" calcext:value-type="currency"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;0;20;2;1)" office:value-type="currency" office:currency="USD" office:value="23841.7427463641" calcext:value-type="currency"> <text:p>$23,841.74</text:p> </table:table-cell> <table:table-cell office:value-type="float" office:value="23841.7427463641" calcext:value-type="float"> <text:p>23841.7427463641</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ROUND([.A27];12)=ROUND([.B27];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ROUND([.A27];12)=ROUND([.B27];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A27])" office:value-type="string" office:string-value="=VDB(35000,7500,36,0,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A27])" office:value-type="string" office:string-value="=VDB(35000,7500,36,0,20,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,0,20,2,1)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>start period>=0</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="9"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="9"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;-10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;-10;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce27" table:formula="of:=ISERROR([.A28])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce18" table:formula="of:=ISERROR([.A28])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A28])" office:value-type="string" office:string-value="=VDB(35000,7500,36,-10,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A28])" office:value-type="string" office:string-value="=VDB(35000,7500,36,-10,20,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,-10,20,2,1)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>start period>=0</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="9"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="9"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;100;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;100;20;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ISERROR([.A29])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ISERROR([.A29])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A29])" office:value-type="string" office:string-value="=VDB(35000,7500,36,100,20,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A29])" office:value-type="string" office:string-value="=VDB(35000,7500,36,100,20,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,100,20,2,1)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>startperiod<lifeTime</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="9"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="9"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> - <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(35000;7500;36;10;2;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-row table:style-name="ro6"> + <table:table-cell table:style-name="ce11" table:formula="of:=VDB(35000;7500;36;10;2;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ISERROR([.A30])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ISERROR([.A30])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A30])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,2,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A30])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,2,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,2,2,1)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>start period<=endPeriod</text:p> </table:table-cell> - <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce25" table:number-columns-repeated="2"/> - <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="5"/> + <table:table-cell/> + <table:table-cell office:value-type="float" office:value="100000" calcext:value-type="float"> + <text:p>100000</text:p> + </table:table-cell> + <table:table-cell office:value-type="string" calcext:value-type="string"> + <text:p>cost</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="5"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> - <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce22" table:formula="of:=VDB(35000;7500;36;10;200;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-row table:style-name="ro6"> + <table:table-cell table:style-name="ce13" table:formula="of:=VDB(35000;7500;36;10;200;2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ISERROR([.A31])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ISERROR([.A31])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A31])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,200,2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A31])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,200,2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,200,2,1)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>enPeriod<=LifeTime</text:p> </table:table-cell> - <table:table-cell table:number-columns-repeated="8"/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="5"/> + <table:table-cell/> + <table:table-cell office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000</text:p> + </table:table-cell> + <table:table-cell office:value-type="string" calcext:value-type="string"> + <text:p>salvage value</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="5"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> - <table:table-row table:style-name="ro7"> - <table:table-cell table:style-name="ce23" table:formula="of:=VDB(35000;7500;36;10;20;-2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> + <table:table-row table:style-name="ro6"> + <table:table-cell table:style-name="ce14" table:formula="of:=VDB(35000;7500;36;10;20;-2;1)" office:value-type="string" office:string-value="" calcext:value-type="error"> <text:p>Err:502</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>Err:502</text:p> </table:table-cell> - <table:table-cell table:style-name="ce26" table:formula="of:=ISERROR([.A32])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <table:table-cell table:style-name="ce17" table:formula="of:=ISERROR([.A32])" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> <text:p>TRUE</text:p> </table:table-cell> - <table:table-cell table:style-name="ce31" table:formula="of:=FORMULA([.A32])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,-2,1)" calcext:value-type="string"> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A32])" office:value-type="string" office:string-value="=VDB(35000,7500,36,10,20,-2,1)" calcext:value-type="string"> <text:p>=VDB(35000,7500,36,10,20,-2,1)</text:p> </table:table-cell> <table:table-cell office:value-type="string" calcext:value-type="string"> <text:p>DepreciationFactor ≥ 0</text:p> </table:table-cell> - <table:table-cell table:number-columns-repeated="15"/> + <table:table-cell/> + <table:table-cell office:value-type="float" office:value="10" calcext:value-type="float"> + <text:p>10</text:p> + </table:table-cell> + <table:table-cell office:value-type="string" calcext:value-type="string"> + <text:p>periods</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="12"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce23"/> - <table:table-cell/> - <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> - <table:table-cell/> - <table:table-cell table:style-name="ce37"/> + <table:table-cell table:formula="of:=VDB(100000;20000;10;7.25;7.75)" office:value-type="float" office:value="485.759999999995" calcext:value-type="float"> + <text:p>485.759999999995</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="485.759999999995" calcext:value-type="float"> + <text:p>485.759999999995</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A33];12)=ROUND([.B33];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A33])" office:value-type="string" office:string-value="=VDB(100000,20000,10,7.25,7.75)" calcext:value-type="string"> + <text:p>=VDB(100000,20000,10,7.25,7.75)</text:p> + </table:table-cell> + <table:table-cell office:value-type="string" calcext:value-type="string"> + <text:p>AOO#91651, TDF#101204</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce26"/> <table:table-cell table:number-columns-repeated="14"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce23"/> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G34];[.$G35])" office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A34];12)=ROUND([.B34];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A34])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G34,$G35)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G34,$G35)</text:p> + </table:table-cell> + <table:table-cell office:value-type="string" calcext:value-type="string"> + <text:p>AOO#109420, TDF#101204</text:p> + </table:table-cell> <table:table-cell/> - <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> - <table:table-cell table:number-columns-repeated="16"/> + <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:number-columns-repeated="13"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce23"/> - <table:table-cell/> - <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> - <table:table-cell table:style-name="ce34"/> - <table:table-cell table:number-columns-repeated="4"/> - <table:table-cell table:style-name="ce25" table:number-columns-repeated="2"/> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G35];[.$G36])" office:value-type="float" office:value="16000" calcext:value-type="float"> + <text:p>16000</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="16000" calcext:value-type="float"> + <text:p>16000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A35];12)=ROUND([.B35];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A35])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G35,$G36)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G35,$G36)</text:p> + </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce40" table:number-columns-repeated="5"/> + <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:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce30" table:number-columns-repeated="5"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce24" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> - <table:table-cell table:style-name="ce35"/> - <table:table-cell table:style-name="ce32"/> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G36];[.$G37])" office:value-type="float" office:value="12800" calcext:value-type="float"> + <text:p>12800</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="12800" calcext:value-type="float"> + <text:p>12800.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A36];12)=ROUND([.B36];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A36])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G36,$G37)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G36,$G37)</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce24"/> <table:table-cell table:style-name="ce22"/> + <table:table-cell 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="6"/> - <table:table-cell table:style-name="ce40" table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce30" table:number-columns-repeated="5"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce20" table:formula="of:=VDB(100000;20000;10;7.25;7.75)" office:value-type="currency" office:currency="USD" office:value="3276.8" calcext:value-type="currency"> - <text:p>$3,276.80</text:p> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G37];[.$G38])" office:value-type="float" office:value="10240" calcext:value-type="float"> + <text:p>10240</text:p> </table:table-cell> - <table:table-cell table:formula="of:=971.52/2" office:value-type="float" office:value="485.76" calcext:value-type="float"> - <text:p>485.76</text:p> + <table:table-cell office:value-type="float" office:value="10240" calcext:value-type="float"> + <text:p>10240</text:p> </table:table-cell> - <table:table-cell table:style-name="ce29"/> - <table:table-cell/> - <table:table-cell office:value-type="string" calcext:value-type="string"> - <text:p>AOO#91651</text:p> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A37];12)=ROUND([.B37];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A37])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G37,$G38)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G37,$G38)</text:p> </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="11"/> + <table:table-cell 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="5"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G38];[.$G39])" office:value-type="float" office:value="8192" calcext:value-type="float"> + <text:p>8192</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="8192" calcext:value-type="float"> + <text:p>8192</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A38];12)=ROUND([.B38];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A38])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G38,$G39)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G38,$G39)</text:p> + </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce30"/> - <table:table-cell table:style-name="ce31"/> - <table:table-cell office:value-type="string" calcext:value-type="string"> - <text:p>AOO#109420</text:p> + <table:table-cell 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="5"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="11"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G39];[.$G40])" office:value-type="float" office:value="6553.6" calcext:value-type="float"> + <text:p>6553.6</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="6553.6" calcext:value-type="float"> + <text:p>6553.6</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A39];12)=ROUND([.B39];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A39])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G39,$G40)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G39,$G40)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + <table:table-cell 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="5"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce22"/> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G40];[.$G41])" office:value-type="float" office:value="5242.88" calcext:value-type="float"> + <text:p>5242.88</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="5242.88" calcext:value-type="float"> + <text:p>5242.88</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A40];12)=ROUND([.B40];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A40])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G40,$G41)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G40,$G41)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + <table:table-cell office:value-type="float" office:value="6" calcext:value-type="float"> + <text:p>6</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="5"/> + <table:table-cell table:style-name="ce37"/> <table:table-cell/> - <table:table-cell table:style-name="ce30"/> - <table:table-cell table:style-name="ce31"/> - <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="11"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="4"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce22"/> - <table:table-cell/> - <table:table-cell table:style-name="ce30"/> - <table:table-cell table:style-name="ce31"/> - <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce42" table:number-columns-repeated="3"/> - <table:table-cell/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="4"/> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G41];[.$G42])" office:value-type="float" office:value="971.519999999989" calcext:value-type="float"> + <text:p>971.519999999989</text:p> + </table:table-cell> + <table:table-cell office:value-type="float" office:value="971.519999999989" calcext:value-type="float"> + <text:p>971.519999999989</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A41];12)=ROUND([.B41];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A41])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G41,$G42)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G41,$G42)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float"> + <text:p>7</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="7"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="4"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce22"/> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G42];[.$G43])" 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="ce19" table:formula="of:=ROUND([.A42];12)=ROUND([.B42];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A42])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G42,$G43)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G42,$G43)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + <table:table-cell 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="13"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G43];[.$G44])" 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="ce15" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A43];12)=ROUND([.B43];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A43])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G43,$G44)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G43,$G44)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + <table:table-cell office:value-type="float" office:value="9" calcext:value-type="float"> + <text:p>9</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="13"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G34];[.$G35];2;1)" office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A44];12)=ROUND([.B44];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A44])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G34,$G35,2,1)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G34,$G35,2,1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + <table:table-cell 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="13"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G35];[.$G36];2;1)" office:value-type="float" office:value="16000" calcext:value-type="float"> + <text:p>16000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="16000" calcext:value-type="float"> + <text:p>16000.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A45];12)=ROUND([.B45];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A45])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G35,$G36,2,1)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G35,$G36,2,1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce28" table:number-columns-repeated="2"/> + <table:table-cell table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce16"/> <table:table-cell/> - <table:table-cell table:style-name="ce30"/> - <table:table-cell table:style-name="ce31"/> + <table:table-cell table:style-name="ce30" table:number-columns-repeated="4"/> + <table:table-cell table:number-columns-repeated="2"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G36];[.$G37];2;1)" office:value-type="float" office:value="12800" calcext:value-type="float"> + <text:p>12800</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="12800" calcext:value-type="float"> + <text:p>12800.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A46];12)=ROUND([.B46];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A46])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G36,$G37,2,1)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G36,$G37,2,1)</text:p> + </table:table-cell> <table:table-cell table:number-columns-repeated="10"/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="4"/> + <table:table-cell table:style-name="ce30" table:number-columns-repeated="4"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce22"/> - <table:table-cell/> - <table:table-cell table:style-name="ce30"/> - <table:table-cell table:style-name="ce31"/> - <table:table-cell table:number-columns-repeated="16"/> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G37];[.$G38];2;1)" office:value-type="float" office:value="10240" calcext:value-type="float"> + <text:p>10240</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="10240" calcext:value-type="float"> + <text:p>10240.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A47];12)=ROUND([.B47];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A47])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G37,$G38,2,1)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G37,$G38,2,1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce28" table:number-columns-repeated="2"/> + <table:table-cell table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="6"/> + <table:table-cell table:number-columns-repeated="2"/> </table:table-row> - <table:table-row table:style-name="ro6" table:number-rows-repeated="2"> - <table:table-cell table:style-name="ce24" table:number-columns-repeated="2"/> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G38];[.$G39];2;1)" office:value-type="float" office:value="8192" calcext:value-type="float"> + <text:p>8192</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="8192" calcext:value-type="float"> + <text:p>8192.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A48];12)=ROUND([.B48];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A48])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G38,$G39,2,1)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G38,$G39,2,1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="4"/> <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> - <table:table-cell table:number-columns-repeated="16"/> + <table:table-cell table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="6"/> + <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce24" table:number-columns-repeated="2"/> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G39];[.$G40];2;1)" office:value-type="float" office:value="6553.6" calcext:value-type="float"> + <text:p>6553.6</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="6553.6" calcext:value-type="float"> + <text:p>6553.600000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A49];12)=ROUND([.B49];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A49])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G39,$G40,2,1)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G39,$G40,2,1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + <table:table-cell office:value-type="float" office:value="7" calcext:value-type="float"> + <text:p>7</text:p> + </table:table-cell> + <table:table-cell/> <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce25" table:number-columns-repeated="6"/> - <table:table-cell/> - <table:table-cell table:style-name="ce40" table:number-columns-repeated="4"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce24" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G40];[.$G41];2;1)" office:value-type="float" office:value="5242.88" calcext:value-type="float"> + <text:p>5242.88</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="5242.88" calcext:value-type="float"> + <text:p>5242.880000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A50];12)=ROUND([.B50];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A50])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G40,$G41,2,1)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G40,$G41,2,1)</text:p> + </table:table-cell> <table:table-cell table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce22"/> - <table:table-cell table:number-columns-repeated="7"/> - <table:table-cell table:style-name="ce40" table:number-columns-repeated="4"/> + <table:table-cell office:value-type="float" office:value="7.25" calcext:value-type="float"> + <text:p>7.25</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="3"/> + <table:table-cell table:style-name="ce28"/> + <table:table-cell table:style-name="ce35"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> - <table:table-row table:style-name="ro6" table:number-rows-repeated="5"> - <table:table-cell table:style-name="ce24" table:number-columns-repeated="2"/> - <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G41];[.$G42];2;1)" office:value-type="float" office:value="971.520000000008" calcext:value-type="float"> + <text:p>971.520000000008</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="971.520000000008" calcext:value-type="float"> + <text:p>971.520000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A51];12)=ROUND([.B51];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A51])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G41,$G42,2,1)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G41,$G42,2,1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + <table:table-cell office:value-type="float" office:value="7.75" calcext:value-type="float"> + <text:p>7.75</text:p> + </table:table-cell> <table:table-cell table:number-columns-repeated="3"/> - <table:table-cell table:style-name="ce38" table:number-columns-repeated="11"/> + <table:table-cell table:style-name="ce28"/> + <table:table-cell table:style-name="ce35"/> + <table:table-cell table:style-name="ce31" table:number-columns-repeated="6"/> <table:table-cell table:number-columns-repeated="2"/> </table:table-row> - <table:table-row table:style-name="ro6" table:number-rows-repeated="15"> - <table:table-cell table:style-name="ce24" table:number-columns-repeated="2"/> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G42];[.$G43];2;1)" 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="ce15" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A52];12)=ROUND([.B52];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A52])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G42,$G43,2,1)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G42,$G43,2,1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="6"/> <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> + <table:table-cell table:style-name="ce35"/> + <table:table-cell table:number-columns-repeated="8"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.$G43];[.$G44];2;1)" 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="ce15" office:value-type="float" office:value="0" calcext:value-type="float"> + <text:p>0.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A53];12)=ROUND([.B53];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A53])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,$G43,$G44,2,1)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,$G43,$G44,2,1)</text:p> + </table:table-cell> <table:table-cell table:number-columns-repeated="16"/> </table:table-row> - <table:table-row table:style-name="ro6" table:number-rows-repeated="169"> - <table:table-cell table:style-name="ce24" table:number-columns-repeated="2"/> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB([.G30];[.G31];[.G32];[.$G$34];[.$G35])" office:value-type="float" office:value="80000" calcext:value-type="float"> + <text:p>80000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="80000" calcext:value-type="float"> + <text:p>80000.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A54];12)=ROUND([.B54];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A54])" office:value-type="string" office:string-value="=G30-VDB(G30,G31,G32,$G$34,$G35)" calcext:value-type="string"> + <text:p>=G30-VDB(G30,G31,G32,$G$34,$G35)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="6.2" calcext:value-type="float"> + <text:p>6.20</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce28"/> + <table:table-cell table:number-columns-repeated="12"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB([.G30];[.G31];[.G32];[.$G$34];[.$G36])" office:value-type="float" office:value="64000" calcext:value-type="float"> + <text:p>64000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="64000" calcext:value-type="float"> + <text:p>64000.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A55];12)=ROUND([.B55];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A55])" office:value-type="string" office:string-value="=G30-VDB(G30,G31,G32,$G$34,$G36)" calcext:value-type="string"> + <text:p>=G30-VDB(G30,G31,G32,$G$34,$G36)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce27" office:value-type="float" office:value="7.6" calcext:value-type="float"> + <text:p>7.60</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="3"/> <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> + <table:table-cell table:style-name="ce35"/> + <table:table-cell table:number-columns-repeated="8"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB([.G30];[.G31];[.G32];[.$G$34];[.$G37])" office:value-type="float" office:value="51200" calcext:value-type="float"> + <text:p>51200</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="51200" calcext:value-type="float"> + <text:p>51200.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A56];12)=ROUND([.B56];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A56])" office:value-type="string" office:string-value="=G30-VDB(G30,G31,G32,$G$34,$G37)" calcext:value-type="string"> + <text:p>=G30-VDB(G30,G31,G32,$G$34,$G37)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB([.G30];[.G31];[.G32];[.$G$34];[.$G38])" office:value-type="float" office:value="40960" calcext:value-type="float"> + <text:p>40960</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="40960" calcext:value-type="float"> + <text:p>40960.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A57];12)=ROUND([.B57];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A57])" office:value-type="string" office:string-value="=G30-VDB(G30,G31,G32,$G$34,$G38)" calcext:value-type="string"> + <text:p>=G30-VDB(G30,G31,G32,$G$34,$G38)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB([.G30];[.G31];[.G32];[.$G$34];[.$G39])" office:value-type="float" office:value="32768" calcext:value-type="float"> + <text:p>32768</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="32768" calcext:value-type="float"> + <text:p>32768.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A58];12)=ROUND([.B58];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A58])" office:value-type="string" office:string-value="=G30-VDB(G30,G31,G32,$G$34,$G39)" calcext:value-type="string"> + <text:p>=G30-VDB(G30,G31,G32,$G$34,$G39)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB([.G30];[.G31];[.G32];[.$G$34];[.$G40])" office:value-type="float" office:value="26214.4" calcext:value-type="float"> + <text:p>26214.4</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="26214.4" calcext:value-type="float"> + <text:p>26214.400000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A59];12)=ROUND([.B59];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A59])" office:value-type="string" office:string-value="=G30-VDB(G30,G31,G32,$G$34,$G40)" calcext:value-type="string"> + <text:p>=G30-VDB(G30,G31,G32,$G$34,$G40)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB([.G30];[.G31];[.G32];[.$G$34];[.$G41])" office:value-type="float" office:value="20971.52" calcext:value-type="float"> + <text:p>20971.52</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="20971.52" calcext:value-type="float"> + <text:p>20971.520000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A60];12)=ROUND([.B60];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A60])" office:value-type="string" office:string-value="=G30-VDB(G30,G31,G32,$G$34,$G41)" calcext:value-type="string"> + <text:p>=G30-VDB(G30,G31,G32,$G$34,$G41)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB([.G30];[.G31];[.G32];[.$G$34];[.$G42])" office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A61];12)=ROUND([.B61];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A61])" office:value-type="string" office:string-value="=G30-VDB(G30,G31,G32,$G$34,$G42)" calcext:value-type="string"> + <text:p>=G30-VDB(G30,G31,G32,$G$34,$G42)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB([.G30];[.G31];[.G32];[.$G$34];[.$G43])" office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A62];12)=ROUND([.B62];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A62])" office:value-type="string" office:string-value="=G30-VDB(G30,G31,G32,$G$34,$G43)" calcext:value-type="string"> + <text:p>=G30-VDB(G30,G31,G32,$G$34,$G43)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB([.G30];[.G31];[.G32];[.$G$34];[.$G44])" office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="20000" calcext:value-type="float"> + <text:p>20000.000000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A63];12)=ROUND([.B63];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A63])" office:value-type="string" office:string-value="=G30-VDB(G30,G31,G32,$G$34,$G44)" calcext:value-type="string"> + <text:p>=G30-VDB(G30,G31,G32,$G$34,$G44)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G49];[.G50])" office:value-type="float" office:value="242.879999999997" calcext:value-type="float"> + <text:p>242.879999999997</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="242.879999999997" calcext:value-type="float"> + <text:p>242.880000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A64];12)=ROUND([.B64];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A64])" office:value-type="string" office:string-value="=VDB(100000,20000,10,G49,G50)" calcext:value-type="string"> + <text:p>=VDB(100000,20000,10,G49,G50)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G50];[.G51])" office:value-type="float" office:value="485.759999999995" calcext:value-type="float"> + <text:p>485.759999999995</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="485.759999999995" calcext:value-type="float"> + <text:p>485.760000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A65];12)=ROUND([.B65];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A65])" office:value-type="string" office:string-value="=VDB(100000,20000,10,G50,G51)" calcext:value-type="string"> + <text:p>=VDB(100000,20000,10,G50,G51)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G49];[.G51])" office:value-type="float" office:value="728.639999999992" calcext:value-type="float"> + <text:p>728.639999999992</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="728.639999999992" calcext:value-type="float"> + <text:p>728.640000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A66];12)=ROUND([.B66];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A66])" office:value-type="string" office:string-value="=VDB(100000,20000,10,G49,G51)" calcext:value-type="string"> + <text:p>=VDB(100000,20000,10,G49,G51)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="16"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB([.G30];[.G31];[.G32];[.G54];[.G55])" office:value-type="float" office:value="4777.216" calcext:value-type="float"> + <text:p>4777.216</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="4777.216" calcext:value-type="float"> + <text:p>4777.216000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A67];12)=ROUND([.B67];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A67])" office:value-type="string" office:string-value="=VDB(G30,G31,G32,G54,G55)" calcext:value-type="string"> + <text:p>=VDB(G30,G31,G32,G54,G55)</text:p> + </table:table-cell> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> <table:table-row table:style-name="ro6"> - <table:table-cell table:style-name="ce25"/> + <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G49];[.G50];2;1)" office:value-type="float" office:value="242.880000000002" calcext:value-type="float"> + <text:p>242.880000000002</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="242.880000000002" calcext:value-type="float"> + <text:p>242.880000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A68];12)=ROUND([.B68];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A68])" office:value-type="string" office:string-value="=VDB(100000,20000,10,G49,G50,2,1)" calcext:value-type="string"> + <text:p>=VDB(100000,20000,10,G49,G50,2,1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:number-columns-repeated="9"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=VDB(100000;20000;10;[.G50];[.G51];2;1)" office:value-type="float" office:value="485.760000000004" calcext:value-type="float"> + <text:p>485.760000000004</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="485.760000000004" calcext:value-type="float"> + <text:p>485.760000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A69];12)=ROUND([.B69];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A69])" office:value-type="string" office:string-value="=VDB(100000,20000,10,G50,G51,2,1)" calcext:value-type="string"> + <text:p>=VDB(100000,20000,10,G50,G51,2,1)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:number-columns-repeated="9"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB(100000;20000;10;[.G$34];[.G50])" office:value-type="float" office:value="20728.64" calcext:value-type="float"> + <text:p>20728.64</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="20728.64" calcext:value-type="float"> + <text:p>20728.640000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A70];12)=ROUND([.B70];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A70])" office:value-type="string" office:string-value="=G30-VDB(100000,20000,10,G$34,G50)" calcext:value-type="string"> + <text:p>=G30-VDB(100000,20000,10,G$34,G50)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:number-columns-repeated="9"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:formula="of:=[.G30]-VDB(100000;20000;10;[.G$34];[.G51])" office:value-type="float" office:value="20242.88" calcext:value-type="float"> + <text:p>20242.88</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce15" office:value-type="float" office:value="20242.88" calcext:value-type="float"> + <text:p>20242.880000</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce19" table:formula="of:=ROUND([.A71];12)=ROUND([.B71];12)" office:value-type="boolean" office:boolean-value="true" calcext:value-type="boolean"> + <text:p>TRUE</text:p> + </table:table-cell> + <table:table-cell table:style-name="ce21" table:formula="of:=FORMULA([.A71])" office:value-type="string" office:string-value="=G30-VDB(100000,20000,10,G$34,G51)" calcext:value-type="string"> + <text:p>=G30-VDB(100000,20000,10,G$34,G51)</text:p> + </table:table-cell> + <table:table-cell table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:number-columns-repeated="9"/> + </table:table-row> + <table:table-row table:style-name="ro6" table:number-rows-repeated="164"> + <table:table-cell table:style-name="ce15" table:number-columns-repeated="2"/> + <table:table-cell table:style-name="ce20"/> + <table:table-cell table:style-name="ce21"/> + <table:table-cell table:number-columns-repeated="6"/> + <table:table-cell table:style-name="ce32"/> + <table:table-cell table:number-columns-repeated="9"/> + </table:table-row> + <table:table-row table:style-name="ro6"> + <table:table-cell table:style-name="ce16"/> <table:table-cell/> - <table:table-cell table:style-name="ce28"/> - <table:table-cell table:style-name="ce31"/> + <table:table-cell table:style-name="ce20"/> + <table:table-cell table:style-name="ce21"/> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> <table:table-row table:style-name="ro6" table:number-rows-repeated="14"> <table:table-cell table:number-columns-repeated="2"/> <table:table-cell table:style-name="Default"/> - <table:table-cell table:style-name="ce32"/> + <table:table-cell table:style-name="ce22"/> <table:table-cell table:number-columns-repeated="6"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> <table:table-row table:style-name="ro6" table:number-rows-repeated="8"> <table:table-cell table:number-columns-repeated="10"/> - <table:table-cell table:style-name="ce41"/> + <table:table-cell table:style-name="ce32"/> <table:table-cell table:number-columns-repeated="9"/> </table:table-row> <table:table-row table:style-name="ro6" table:number-rows-repeated="31"> @@ -3150,12 +3705,12 @@ <table:table-cell table:number-columns-repeated="20"/> </table:table-row> <calcext:conditional-formats> - <calcext:conditional-format calcext:target-range-address="Sheet2.C43:Sheet2.C236 Sheet2.C4:Sheet2.C11 Sheet2.C33:Sheet2.C36 Sheet2.C13:Sheet2.C16 Sheet2.C18:Sheet2.C21 Sheet2.C23:Sheet2.C24 Sheet2.C27:Sheet2.C28"> + <calcext:conditional-format calcext:target-range-address="Sheet2.C35:Sheet2.C236 Sheet2.C4:Sheet2.C11 Sheet2.C13:Sheet2.C16 Sheet2.C18:Sheet2.C21 Sheet2.C23:Sheet2.C24 Sheet2.C27:Sheet2.C28"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C4"/> <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C4"/> <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C4"/> </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C43:Sheet2.C236 Sheet2.C2:Sheet2.C36"> + <calcext:conditional-format calcext:target-range-address="Sheet2.C35:Sheet2.C236 Sheet2.C2:Sheet2.C32"> <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C2"/> <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/> <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/> @@ -3170,27 +3725,22 @@ <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C2"/> <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C2"/> </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C37:Sheet2.C42"> - <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C37"/> - <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C37"/> - <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C37"/> - </calcext:conditional-format> - <calcext:conditional-format calcext:target-range-address="Sheet2.C38:Sheet2.C42"> - <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C38"/> - <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C38"/> - <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C38"/> + <calcext:conditional-format calcext:target-range-address="Sheet2.C33:Sheet2.C71"> + <calcext:condition calcext:apply-style-name="Default" calcext:value="=""" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="Untitled1" calcext:value="=0" calcext:base-cell-address="Sheet2.C33"/> + <calcext:condition calcext:apply-style-name="Untitled2" calcext:value="=1" calcext:base-cell-address="Sheet2.C33"/> </calcext:conditional-format> </calcext:conditional-formats> </table:table> <table:table table:name="'file:///home/zdenek/Dokumenty/LO/sc-unit-test/Project%20Calc%20functions%20tests/fods/function_based_test_Example.fods/function_based_test_Example_reference.fods'#Sheet2" table:print="false" table:style-name="ta_extref"> - <table:table-source xlink:type="simple" xlink:href="../function_based_test_Example.fods/function_based_test_Example_reference.fods" table:table-name="Sheet2" table:mode="copy-results-only"/> + <table:table-source xlink:type="simple" xlink:href="function_based_test_Example.fods/function_based_test_Example_reference.fods" table:table-name="Sheet2" table:mode="copy-results-only"/> <table:table-column table:number-columns-repeated="8"/> <table:table-row table:number-rows-repeated="2"> <table:table-cell table:number-columns-repeated="8"/> </table:table-row> <table:table-row> <table:table-cell table:number-columns-repeated="7"/> - <table:table-cell table:style-name="ce10" office:value-type="float" office:value="4"> + <table:table-cell table:style-name="ce1" office:value-type="float" office:value="4"> <text:p>4</text:p> </table:table-cell> </table:table-row> |