diff options
author | h-hishida <h-hishida@quartetcom.co.jp> | 2015-04-28 09:45:00 +0900 |
---|---|---|
committer | h-hishida <h-hishida@quartetcom.co.jp> | 2015-04-28 09:45:00 +0900 |
commit | 373ae12ca5db9837f84fef44f3f7077e766aca08 (patch) | |
tree | c515f2cccceaa886282ac40f89785da072a3627e /tests | |
download | PHPExcelFixer.StyleFixer-373ae12ca5db9837f84fef44f3f7077e766aca08.zip PHPExcelFixer.StyleFixer-373ae12ca5db9837f84fef44f3f7077e766aca08.tar.gz PHPExcelFixer.StyleFixer-373ae12ca5db9837f84fef44f3f7077e766aca08.tar.bz2 |
initial commit
Diffstat (limited to 'tests')
22 files changed, 590 insertions, 0 deletions
diff --git a/tests/Plugin/BasePluginTest.php b/tests/Plugin/BasePluginTest.php new file mode 100644 index 0000000..0686eb4 --- /dev/null +++ b/tests/Plugin/BasePluginTest.php @@ -0,0 +1,49 @@ +<?php + + +namespace PHPExcel\StyleFixer\Plugin; + + +abstract class BasePluginTest extends \PHPUnit_Framework_TestCase +{ + private $basePath; + + public function setUp() + { + $this->basePath = __DIR__.'/../xml'; + } + + public function getOutputXml($path) + { + return file_get_contents($this->basePath.'/output/'.$path); + } + + public function getTemplateXml($path) + { + return file_get_contents($this->basePath.'/template/'.$path); + } + + /** + * @param int $count + * @param array $map + * @return \PHPUnit_Framework_MockObject_MockObject + */ + protected function createBookUtil($count, $map) + { + $bookUtil = $this->getMock('PHPExcel\StyleFixer\Util\Book'); + $bookUtil + ->expects($this->exactly($count)) + ->method('makeSheetMap') + ->with($this->isInstanceOf('\ZipArchive')) + ->will($this->returnValue($map)) + ; + + return $bookUtil; + } + + public function tearDown() + { + $this->output_stylesXml = ''; + $this->template_stylesXml = ''; + } +} diff --git a/tests/Plugin/CellStyleFixerTest.php b/tests/Plugin/CellStyleFixerTest.php new file mode 100644 index 0000000..a30478a --- /dev/null +++ b/tests/Plugin/CellStyleFixerTest.php @@ -0,0 +1,67 @@ +<?php + + +namespace PHPExcel\StyleFixer\Plugin; + +use PHPExcel\StyleFixer\Util\Sheet; + +class CellStyleFixerTest extends BasePluginTest +{ + public function test_execute() + { + $output = $this->getMock('\ZipArchive'); + $template = $this->getMock('\ZipArchive'); + $bookUtil = $this->createBookUtil(2, ['Sheet1' => 'xl/worksheets/sheet1.xml', 'Sheet2' => 'xl/worksheets/sheet2.xml']); + $bookUtil + ->expects($this->once()) + ->method('makePrintAreaMap') + ->with($this->isInstanceOf('\ZipArchive')) + ->will($this->returnValue(['Sheet1' => 'Sheet1!$A$18:$A$18', 'Sheet2' => 'Sheet2!$A$18:$A$18'])) + ; + $sheetUtil = new Sheet(); + + $output + ->expects($this->exactly(2)) + ->method('getFromName') + ->with($this->logicalOr('xl/worksheets/sheet1.xml', 'xl/worksheets/sheet2.xml')) + ->will($this->returnCallback([$this, 'getOutputXml'])) + ; + $template + ->expects($this->exactly(2)) + ->method('getFromName') + ->with($this->logicalOr('xl/worksheets/sheet1.xml', 'xl/worksheets/sheet2.xml')) + ->will($this->returnCallback([$this, 'getTemplateXml'])) + ; + $output + ->expects($this->exactly(2)) + ->method('addFromString') + ->with($this->logicalOr('xl/worksheets/sheet1.xml', 'xl/worksheets/sheet2.xml'), $this->callback([$this, 'assertXmlHasExpectedContent'])) + ; + + $fixer = new CellStyleFixer($bookUtil, $sheetUtil); + $fixer->execute($output, $template); + } + + public function assertXmlHasExpectedContent($xml) + { + // 行スタイルが修復されている + $this->assertContains('<row r="18" s="99">', $xml); + $this->assertNotContains('<row r="18" s="11">', $xml); + // セルスタイルが修復されている + $this->assertContains('<c r="A18" s="33"', $xml); + $this->assertNotContains('<c r="A18" s="11"', $xml); + if (strpos($xml, 'B18')) { + // 印刷範囲外でも値があるセルは修復する + $this->assertContains('<c r="B18" s="33"', $xml); + $this->assertNotContains('<c r="B18" s="11"', $xml); + } + if (strpos($xml, 'C18')) { + // 印刷範囲外で値もないセルは修復せずスタイル情報を破棄 + $this->assertContains('<c r="C18"/>', $xml); + $this->assertNotContains('<c r="C18" s="33"', $xml); + $this->assertNotContains('<c r="C18" s="11"', $xml); + } + + return true; + } +} diff --git a/tests/Plugin/ConditionalFormatFixerTest.php b/tests/Plugin/ConditionalFormatFixerTest.php new file mode 100644 index 0000000..e0d97ac --- /dev/null +++ b/tests/Plugin/ConditionalFormatFixerTest.php @@ -0,0 +1,44 @@ +<?php + + +namespace PHPExcel\StyleFixer\Plugin; + + +class ConditionalFormatFixerTest extends BasePluginTest +{ + public function test_execute() + { + $output = $this->getMock('\ZipArchive'); + $template = $this->getMock('\ZipArchive'); + $bookUtil = $this->createBookUtil(2, ['Sheet1' => 'xl/worksheets/sheet1.xml', 'Sheet2' => 'xl/worksheets/sheet2.xml']); + + $output + ->expects($this->exactly(2)) + ->method('getFromName') + ->with($this->logicalOr('xl/worksheets/sheet1.xml', 'xl/worksheets/sheet2.xml')) + ->will($this->returnCallback([$this, 'getOutputXml'])) + ; + $template + ->expects($this->once()) + ->method('getFromName') + ->with($this->equalTo('xl/worksheets/sheet2.xml')) + ->will($this->returnCallback([$this, 'getTemplateXml'])) + ; + $output + ->expects($this->once()) + ->method('addFromString') + ->with($this->equalTo('xl/worksheets/sheet2.xml'), $this->callback([$this, 'assertXmlHasExpectedContent'])) + ; + + $fixer = new ConditionalFormatFixer($bookUtil); + $fixer->execute($output, $template); + } + + public function assertXmlHasExpectedContent($xml) + { + $this->assertContains('<conditionalFormatting><font/></conditionalFormatting>', $xml); + $this->assertNotContains('<conditionalFormatting/>', $xml); + + return true; + } +} diff --git a/tests/StyleFixerTest.php b/tests/StyleFixerTest.php new file mode 100644 index 0000000..8351525 --- /dev/null +++ b/tests/StyleFixerTest.php @@ -0,0 +1,133 @@ +<?php + + +namespace PHPExcel\StyleFixer; + + +class StyleFixerTest extends \PHPUnit_Framework_TestCase +{ + private $basePath; + + public function setUp() + { + $this->basePath = __DIR__.'/xml'; + } + + public function getOutputXml($path) + { + return file_get_contents($this->basePath.'/output/'.$path); + } + + public function getTemplateXml($path) + { + return file_get_contents($this->basePath.'/template/'.$path); + } + + /** + * @test + */ + public function プラグインなし() + { + $output = $this->getMock('\ZipArchive'); + $template = $this->getMock('\ZipArchive'); + $outputPath = '/path/to/output.xlsx'; + $templatePath = '/path/to/template.xlsx'; + $zips = [ + $outputPath => $output, + $templatePath => $template, + ]; + + $fixer = $this->getMockBuilder('PHPExcel\StyleFixer\StyleFixer') + ->setMethods(['openFile']) + ->getMock() + ; + $fixer + ->expects($this->exactly(2)) + ->method('openFile') + ->with($this->logicalOr($outputPath, $templatePath)) + ->will($this->returnCallback(function($path) use ($zips){ + return $zips[$path]; + })) + ; + $template + ->expects($this->once()) + ->method('getFromName') + ->with('xl/styles.xml') + ->will($this->returnCallback([$this, 'getTemplateXml'])) + ; + $output + ->expects($this->once()) + ->method('addFromString') + ->with('xl/styles.xml', $this->callback(function($xml){ + + $this->assertEquals($this->getTemplateXml('xl/styles.xml'), $xml); + + return true; + })) + ; + $output + ->expects($this->once()) + ->method('close') + ; + + $fixer->execute($outputPath, $templatePath); + } + + /** + * @test + */ + public function プラグインあり() + { + $output = $this->getMock('\ZipArchive'); + $template = $this->getMock('\ZipArchive'); + $outputPath = '/path/to/output.xlsx'; + $templatePath = '/path/to/template.xlsx'; + $zips = [ + $outputPath => $output, + $templatePath => $template, + ]; + $plugin = $this->getMockForAbstractClass('PHPExcel\StyleFixer\Plugin\Plugin'); + + $fixer = $this->getMockBuilder('PHPExcel\StyleFixer\StyleFixer') + ->setMethods(['openFile']) + ->setConstructorArgs([[$plugin]]) + ->getMock() + ; + $fixer + ->expects($this->exactly(3)) + ->method('openFile') + ->with($this->logicalOr($outputPath, $templatePath)) + ->will($this->returnCallback(function($path) use ($zips){ + return $zips[$path]; + })) + ; + $plugin + ->expects($this->once()) + ->method('execute') + ->with($output, $template) + ; + $template + ->expects($this->once()) + ->method('getFromName') + ->with('xl/styles.xml') + ->will($this->returnCallback([$this, 'getTemplateXml'])) + ; + $output + ->expects($this->once()) + ->method('addFromString') + ->with('xl/styles.xml', $this->isType('string')) + ; + $output + ->expects($this->exactly(2)) + ->method('close') + ; + + $fixer->execute($outputPath, $templatePath); + } + + public function tearDown() + { + $this->output_stylesXml = ''; + $this->template_stylesXml = ''; + } +} diff --git a/tests/Util/BookTest.php b/tests/Util/BookTest.php new file mode 100644 index 0000000..2e0c26c --- /dev/null +++ b/tests/Util/BookTest.php @@ -0,0 +1,90 @@ +<?php + + +namespace PHPExcel\StyleFixer\Util; + +class BookTest extends \PHPUnit_Framework_TestCase +{ + public function test_makeSheetMap() + { + $zip = $this->makeZipMock(['xl/workbook.xml', 'xl/_rels/workbook.xml.rels']); + + $bookUtil = new Book(); + $map = $bookUtil->makeSheetMap($zip); + + $this->assertInternalType('array', $map); + $this->assertArrayHasKey('表紙', $map); + $this->assertArrayHasKey('日別_Y', $map); + $this->assertArrayHasKey('日別_YDN', $map); + $this->assertArrayNotHasKey('日別_G', $map); + $this->assertEquals('xl/worksheets/sheet1.xml', $map['表紙']); + } + + public function test_makePrintAreaMap() + { + $zip = $this->makeZipMock(['xl/workbook.xml']); + $bookUtil = new Book(); + $map = $bookUtil->makePrintAreaMap($zip); + + $this->assertInternalType('array', $map); + $this->assertArrayHasKey('表紙', $map); + $this->assertArrayHasKey('日別_Y', $map); + $this->assertArrayHasKey('日別_YDN', $map); + $this->assertArrayNotHasKey('日別_G', $map); + $this->assertEquals('\'日別_Y\'!$A$18:$A$18', $map['日別_Y']); + } + + public function test_makeSheetRelationMap() + { + $zip = $this->makeZipMock(['xl/workbook.xml', 'xl/_rels/workbook.xml.rels']); + + $bookUtil = new Book(); + $map = $bookUtil->makeSheetRelationMap($zip); + + $this->assertInternalType('array', $map); + $this->assertArrayHasKey('表紙', $map); + $this->assertArrayHasKey('日別_Y', $map); + $this->assertArrayHasKey('日別_YDN', $map); + $this->assertArrayNotHasKey('日別_G', $map); + $this->assertEquals('xl/worksheets/_rels/sheet1.xml.rels', $map['表紙']); + } + + public function test_makeDrawingMap() + { + $zip = $this->makeZipMock(['xl/workbook.xml', 'xl/_rels/workbook.xml.rels', 'xl/worksheets/_rels/sheet1.xml.rels', 'xl/worksheets/_rels/sheet2.xml.rels', 'xl/worksheets/_rels/sheet3.xml.rels']); + + $bookUtil = new Book(); + $map = $bookUtil->makeDrawingMap($zip); + + $this->assertInternalType('array', $map); + $this->assertArrayNotHasKey('表紙', $map); + $this->assertArrayHasKey('日別_Y', $map); + $this->assertArrayHasKey('日別_YDN', $map); + $this->assertEquals(['xl/drawings/drawing1.xml', 'xl/drawings/drawing2.xml'], $map['日別_Y']); + } + + /** + * @param string $fileNames + * @return \ZipArchive|\PHPUnit_Framework_MockObject_MockObject + */ + private function makeZipMock($fileNames) + { + $zip = $this->getMock('\ZipArchive'); + $zip + ->expects($this->exactly(count($fileNames))) + ->method('getFromName') + ->with($this->callback( + function($fileName) use ($fileNames){ + return in_array($fileName, $fileNames); + })) + ->will($this->returnCallback([$this, 'getXml'])) + ; + + return $zip; + } + + public function getXml($path) + { + return file_get_contents(__DIR__.'/../xml/template/'.$path); + } +} diff --git a/tests/Util/SheetTest.php b/tests/Util/SheetTest.php new file mode 100644 index 0000000..339e731 --- /dev/null +++ b/tests/Util/SheetTest.php @@ -0,0 +1,38 @@ +<?php + + +namespace PHPExcel\StyleFixer\Util; + + +class SheetTest extends \PHPUnit_Framework_TestCase +{ + /** + * @param string $cell + * @param string $range + * @param bool $expect + * @test + * @dataProvider provideInRangeTestData + */ + public function test_inRange($cell, $range, $expect) + { + $sheetUtil = new Sheet(); + $this->assertEquals($expect, $sheetUtil->inRange($cell, $range)); + } + + public function provideInRangeTestData() + { + return [ + ['A1', 'A2:A10', false], + ['A2', 'A2:A10', true], + ['A5', 'A2:A10', true], + ['A10', 'A2:A10', true], + ['A11', 'A2:A10', false], + ['A1', 'B1:Z1', false], + ['B1', 'B1:Z1', true], + ['C1', 'B1:Z1', true], + ['Z1', 'B1:Z1', true], + ['AA1', 'B1:Z1', false], + ['A1', 'AA1:AA2', false], + ]; + } +} diff --git a/tests/bootstrap.php b/tests/bootstrap.php new file mode 100644 index 0000000..dd79cfa --- /dev/null +++ b/tests/bootstrap.php @@ -0,0 +1,4 @@ +<?php + +/** @var $loader \Composer\Autoload\ClassLoader */ +$loader = require dirname(__DIR__) . '/vendor/autoload.php'; diff --git a/tests/xml/output/xl/_rels/workbook.xml.rels b/tests/xml/output/xl/_rels/workbook.xml.rels new file mode 100644 index 0000000..21fc1eb --- /dev/null +++ b/tests/xml/output/xl/_rels/workbook.xml.rels @@ -0,0 +1,5 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"> + <Relationship Id="rId4" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/> + <Relationship Id="rId5" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet2.xml"/> +</Relationships> diff --git a/tests/xml/output/xl/styles.xml b/tests/xml/output/xl/styles.xml new file mode 100644 index 0000000..3905982 --- /dev/null +++ b/tests/xml/output/xl/styles.xml @@ -0,0 +1,2 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<styleSheet xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><numFmts count="4"><numFmt numFmtId="164" formatCode="yyyy/mm/dd\ \(aaa\)"/><numFmt numFmtId="165" formatCode=""¥"#,##0"""/><numFmt numFmtId="166" formatCode=""¥"#,##0.00"/><numFmt numFmtId="167" formatCode="0.0"/></numFmts><fonts count="10"><font><b val="0"/><i val="0"/><strike val="0"/><u val="none"/><sz val="9"/><color rgb="FF000000"/><name val="MS Pゴシック"/></font><font><b val="1"/><i val="0"/><strike val="0"/><u val="none"/><sz val="9"/><color rgb="FF000000"/><name val="MS Pゴシック"/></font><font><b val="0"/><i val="0"/><strike val="0"/><u val="none"/><sz val="10"/><color rgb="FF000000"/><name val="MS Pゴシック"/></font><font><b val="1"/><i val="0"/><strike val="0"/><u val="none"/><sz val="10"/><color rgb="FFFFFFFF"/><name val="Arial"/></font><font><b val="1"/><i val="0"/><strike val="0"/><u val="none"/><sz val="10"/><color rgb="FF000000"/><name val="MS Pゴシック"/></font><font><b val="1"/><i val="0"/><strike val="0"/><u val="none"/><sz val="9"/><color rgb="FFFFFFFF"/><name val="MS Pゴシック"/></font><font><b val="0"/><i val="0"/><strike val="0"/><u val="none"/><sz val="11"/><color rgb="FF000000"/><name val="MS Pゴシック"/></font><font><b val="1"/><i val="0"/><strike val="0"/><u val="none"/><sz val="24"/><color rgb="FF009900"/><name val="MS Pゴシック"/></font><font><b val="1"/><i val="0"/><strike val="0"/><u val="none"/><sz val="20"/><color rgb="FF000000"/><name val="MS Pゴシック"/></font><font><b val="1"/><i val="0"/><strike val="0"/><u val="none"/><sz val="28"/><color rgb="FF009900"/><name val="MS Pゴシック"/></font></fonts><fills count="6"><fill><patternFill patternType="none"/></fill><fill><patternFill patternType="gray125"><fgColor rgb="FFFFFFFF"/><bgColor rgb="FF000000"/></patternFill></fill><fill><patternFill patternType="none"/></fill><fill><patternFill patternType="solid"><fgColor rgb="FF33CC33"/><bgColor rgb="FFFFFFFF"/></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="FF99FF99"/><bgColor rgb="FFFFFFFF"/></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="FFDDFFDD"/><bgColor rgb="FFFFFFFF"/></patternFill></fill></fills><borders count="13"><border/><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top><bottom style="thin"><color rgb="FF009900"/></bottom></border><border><bottom style="medium"><color rgb="FF009900"/></bottom></border><border><left style="thin"><color rgb="FF009900"/></left><top style="thin"><color rgb="FF009900"/></top><bottom style="thin"><color rgb="FF009900"/></bottom></border><border><left style="thin"><color rgb="FF009900"/></left><top style="thin"><color rgb="FF009900"/></top></border><border><top style="thin"><color rgb="FF009900"/></top></border><border><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top></border><border><left style="thin"><color rgb="FF009900"/></left><bottom style="thin"><color rgb="FF009900"/></bottom></border><border><bottom style="thin"><color rgb="FF009900"/></bottom></border><border><right style="thin"><color rgb="FF009900"/></right><bottom style="thin"><color rgb="FF009900"/></bottom></border><border><bottom style="double"><color rgb="FF009900"/></bottom></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><bottom style="thin"><color rgb="FF009900"/></bottom></border></borders><cellStyleXfs count="1"><xf numFmtId="0" fontId="0" fillId="0" borderId="0"/></cellStyleXfs><cellXfs count="82"><xf xfId="0" fontId="0" numFmtId="0" fillId="2" borderId="0" applyFont="0" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="1" numFmtId="0" fillId="2" borderId="1" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="2" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="2" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="2" borderId="2" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="1" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="2" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="1"><alignment horizontal="general" vertical="bottom" textRotation="0" wrapText="true" shrinkToFit="false"/></xf><xf xfId="0" fontId="3" numFmtId="0" fillId="3" borderId="1" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="3" quotePrefix="1" numFmtId="0" fillId="3" borderId="1" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="2" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="1"><alignment horizontal="general" vertical="top" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="4" borderId="1" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="9" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="164" fillId="2" borderId="3" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="4" numFmtId="0" fillId="2" borderId="3" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="165" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="10" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="10" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="9" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="165" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="3" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="3" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="166" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="166" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="10" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="166" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="9" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="165" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="167" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="167" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="167" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="165" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="10" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="3" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="165" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="3" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="10" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="167" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="166" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="166" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="167" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="165" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="3" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="165" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="3" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="10" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="166" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="167" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="3" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="10" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="166" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="167" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="165" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="3" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="10" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="166" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="167" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="165" fillId="5" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="5" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="0" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="2" numFmtId="165" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="3" fillId="2" borderId="1" applyFont="1" applyNumberFormat="1" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="2" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="2" borderId="2" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="2" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="1"><alignment horizontal="general" vertical="top" textRotation="0" wrapText="true" shrinkToFit="false"/></xf><xf xfId="0" fontId="0" numFmtId="0" fillId="2" borderId="1" applyFont="0" applyNumberFormat="0" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="true" shrinkToFit="false"/></xf><xf xfId="0" fontId="5" numFmtId="0" fillId="3" borderId="4" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="5" numFmtId="0" fillId="3" borderId="5" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="5" numFmtId="0" fillId="3" borderId="6" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="5" numFmtId="0" fillId="3" borderId="7" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="5" numFmtId="0" fillId="3" borderId="8" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="5" numFmtId="0" fillId="3" borderId="9" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="0" numFmtId="0" fillId="2" borderId="1" applyFont="0" applyNumberFormat="0" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="1" numFmtId="0" fillId="2" borderId="1" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="6" numFmtId="0" fillId="2" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="7" numFmtId="0" fillId="2" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="7" numFmtId="0" fillId="2" borderId="2" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="1" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="8" numFmtId="0" fillId="2" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="5" numFmtId="0" fillId="3" borderId="1" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="2" borderId="10" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="9" numFmtId="0" fillId="2" borderId="0" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="0" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="9" numFmtId="0" fillId="2" borderId="10" applyFont="1" applyNumberFormat="0" applyFill="0" applyBorder="1" applyAlignment="0"><alignment horizontal="general" vertical="center" textRotation="0" wrapText="false" shrinkToFit="false"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="3" borderId="1" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="3" borderId="11" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf><xf xfId="0" fontId="2" numFmtId="0" fillId="3" borderId="12" applyFont="1" applyNumberFormat="0" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" textRotation="0" wrapText="false" shrinkToFit="true"/></xf></cellXfs><cellStyles count="1"><cellStyle name="Normal" xfId="0" builtinId="0"/></cellStyles><dxfs count="4"><dxf><font><sz val="10"/><color rgb="FF0000FF"/><name val="Calibri"/></font><numFmt numFmtId="164" formatCode="General"/><alignment/><border/></dxf><dxf><font><sz val="10"/><color rgb="FFFF0000"/><name val="Calibri"/></font><numFmt numFmtId="164" formatCode="General"/><alignment/><border/></dxf><dxf><font><sz val="10"/><color rgb="FF0000FF"/><name val="Calibri"/></font><numFmt numFmtId="164" formatCode="General"/><alignment/><border/></dxf><dxf><font><sz val="10"/><color rgb="FFFF0000"/><name val="Calibri"/></font><numFmt numFmtId="164" formatCode="General"/><alignment/><border/></dxf></dxfs><tableStyles defaultTableStyle="TableStyleMedium9" defaultPivotStyle="PivotTableStyle1"/></styleSheet> diff --git a/tests/xml/output/xl/workbook.xml b/tests/xml/output/xl/workbook.xml new file mode 100644 index 0000000..dd4364c --- /dev/null +++ b/tests/xml/output/xl/workbook.xml @@ -0,0 +1,10 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<workbook xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><fileVersion appName="xl" lastEdited="4" lowestEdited="4" rupBuild="4505"/><workbookPr codeName="ThisWorkbook"/><bookViews><workbookView activeTab="0" autoFilterDateGrouping="1" firstSheet="0" minimized="0" showHorizontalScroll="1" showSheetTabs="1" showVerticalScroll="1" tabRatio="600" visibility="visible"/></bookViews><sheets> + <sheet name="表紙" sheetId="1" r:id="rId4"/><!-- 条件付き書式なしのシート --> + <sheet name="日別_Y" sheetId="2" r:id="rId5"/><!-- 条件付き書式ありのシート --> +</sheets><calcPr calcId="999999" calcMode="auto" calcCompleted="0" fullCalcOnLoad="1"/> +<definedNames> + <definedName name="_xlnm.Print_Area" localSheetId="0">'表紙'!$A$18:$A:$18</definedName> + <definedName name="_xlnm.Print_Area" localSheetId="1">'日別_Y'!$A$18:$A:$18</definedName> +</definedNames> +</workbook> diff --git a/tests/xml/output/xl/worksheets/sheet1.xml b/tests/xml/output/xl/worksheets/sheet1.xml new file mode 100644 index 0000000..3ec2727 --- /dev/null +++ b/tests/xml/output/xl/worksheets/sheet1.xml @@ -0,0 +1,8 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<worksheet xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"> + <sheetData> + <row r="18" s="11"> + <c r="A18" s="11"><v>41111</v></c> + </row> + </sheetData> +</worksheet> diff --git a/tests/xml/output/xl/worksheets/sheet2.xml b/tests/xml/output/xl/worksheets/sheet2.xml new file mode 100644 index 0000000..9846bae --- /dev/null +++ b/tests/xml/output/xl/worksheets/sheet2.xml @@ -0,0 +1,12 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<worksheet xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"> + <sheetData> + <row r="18" s="11"> + <c r="A18" s="11"><v>41111</v></c> + <c r="B18" s="11"><v>1234</v></c> + <c r="C18" s="11"/> + </row> + </sheetData> +<conditionalFormatting /> +<pageMargins /> +</worksheet> diff --git a/tests/xml/template/xl/_rels/workbook.xml.rels b/tests/xml/template/xl/_rels/workbook.xml.rels new file mode 100644 index 0000000..62b8d16 --- /dev/null +++ b/tests/xml/template/xl/_rels/workbook.xml.rels @@ -0,0 +1,6 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"> + <Relationship Id="rId4" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet1.xml"/> + <Relationship Id="rId5" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet2.xml"/> + <Relationship Id="rId6" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet" Target="worksheets/sheet3.xml"/> +</Relationships> diff --git a/tests/xml/template/xl/drawings/drawing1.xml b/tests/xml/template/xl/drawings/drawing1.xml new file mode 100644 index 0000000..5222e6f --- /dev/null +++ b/tests/xml/template/xl/drawings/drawing1.xml @@ -0,0 +1,68 @@ +<xdr:wsDr xmlns:xdr="http://schemas.openxmlformats.org/drawingml/2006/spreadsheetDrawing" + xmlns:a="http://schemas.openxmlformats.org/drawingml/2006/main"> + <xdr:twoCellAnchor> + <xdr:from> + <xdr:col>0</xdr:col> + <xdr:colOff>0</xdr:colOff> + <xdr:row>108</xdr:row> + <xdr:rowOff>0</xdr:rowOff> + </xdr:from> + <xdr:to> + <xdr:col>6</xdr:col> + <xdr:colOff>619124</xdr:colOff> + <xdr:row>125</xdr:row> + <xdr:rowOff>0</xdr:rowOff> + </xdr:to> + <xdr:graphicFrame macro=""> + <xdr:nvGraphicFramePr> + <xdr:cNvPr id="9" name="グラフ 8"/> + <xdr:cNvGraphicFramePr> + <a:graphicFrameLocks/> + </xdr:cNvGraphicFramePr> + </xdr:nvGraphicFramePr> + <xdr:xfrm> + <a:off x="0" y="0"/> + <a:ext cx="0" cy="0"/> + </xdr:xfrm> + <a:graphic> + <a:graphicData uri="http://schemas.openxmlformats.org/drawingml/2006/chart"> + <c:chart xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart" + xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" r:id="rId3"/> + </a:graphicData> + </a:graphic> + </xdr:graphicFrame> + <xdr:clientData/> + </xdr:twoCellAnchor> + <xdr:twoCellAnchor> + <xdr:from> + <xdr:col>7</xdr:col> + <xdr:colOff>285751</xdr:colOff> + <xdr:row>108</xdr:row> + <xdr:rowOff>0</xdr:rowOff> + </xdr:from> + <xdr:to> + <xdr:col>15</xdr:col> + <xdr:colOff>9525</xdr:colOff> + <xdr:row>125</xdr:row> + <xdr:rowOff>0</xdr:rowOff> + </xdr:to> + <xdr:graphicFrame macro=""> + <xdr:nvGraphicFramePr> + <xdr:cNvPr id="10" name="グラフ 9"/> + <xdr:cNvGraphicFramePr> + <a:graphicFrameLocks/> + </xdr:cNvGraphicFramePr> + </xdr:nvGraphicFramePr> + <xdr:xfrm> + <a:off x="0" y="0"/> + <a:ext cx="0" cy="0"/> + </xdr:xfrm> + <a:graphic> + <a:graphicData uri="http://schemas.openxmlformats.org/drawingml/2006/chart"> + <c:chart xmlns:c="http://schemas.openxmlformats.org/drawingml/2006/chart" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" r:id="rId4"/> + </a:graphicData> + </a:graphic> + </xdr:graphicFrame> + <xdr:clientData/> + </xdr:twoCellAnchor> +</xdr:wsDr> diff --git a/tests/xml/template/xl/sharedStrings.xml b/tests/xml/template/xl/sharedStrings.xml new file mode 100644 index 0000000..d96aa8b --- /dev/null +++ b/tests/xml/template/xl/sharedStrings.xml @@ -0,0 +1,5 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="2" uniqueCount="2"> + <si><t>test01</t></si> + <si><t>test02</t></si> +</sst> diff --git a/tests/xml/template/xl/styles.xml b/tests/xml/template/xl/styles.xml new file mode 100644 index 0000000..7dab59d --- /dev/null +++ b/tests/xml/template/xl/styles.xml @@ -0,0 +1,2 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<styleSheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac"><numFmts count="9"><numFmt numFmtId="7" formatCode=""¥"#,##0.00;"¥"\-#,##0.00"/><numFmt numFmtId="176" formatCode=""¥"#,##0"""/><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/><numFmt numFmtId="178" formatCode="yyyy/mm"/><numFmt numFmtId="179" formatCode="00":00""/><numFmt numFmtId="180" formatCode="\+0.00;\-0.00;0"/><numFmt numFmtId="181" formatCode="\+0.0;\-0.0;0"/><numFmt numFmtId="182" formatCode=""¥"#,##0.00"/><numFmt numFmtId="183" formatCode="0.0"/></numFmts><fonts count="17" x14ac:knownFonts="1"><font><sz val="9"/><color theme="1"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><sz val="6"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/></font><font><b/><sz val="9"/><color theme="0"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><b/><sz val="9"/><color theme="1"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><sz val="11"/><color theme="1"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><sz val="10"/><color theme="1"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><b/><sz val="10"/><color theme="1"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><b/><sz val="24"/><color rgb="FF009900"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><b/><sz val="20"/><color theme="1"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><b/><sz val="10"/><color theme="0"/><name val="Arial"/><family val="2"/></font><font><sz val="6"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><b/><sz val="10"/><color theme="0"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><b/><sz val="28"/><color rgb="FF009900"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><sz val="10"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><sz val="10"/><color theme="0" tint="-0.499984740745262"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><sz val="9"/><color rgb="FF0000FF"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font><font><sz val="9"/><color rgb="FF006600"/><name val="MS Pゴシック"/><family val="3"/><charset val="128"/><scheme val="minor"/></font></fonts><fills count="8"><fill><patternFill patternType="none"/></fill><fill><patternFill patternType="gray125"/></fill><fill><patternFill patternType="solid"><fgColor rgb="FF33CC33"/><bgColor indexed="64"/></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="FF99FF99"/><bgColor indexed="64"/></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="FFFFFFCC"/><bgColor indexed="64"/></patternFill></fill><fill><patternFill patternType="solid"><fgColor theme="3" tint="0.79998168889431442"/><bgColor indexed="64"/></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="FFFFCCFF"/><bgColor indexed="64"/></patternFill></fill><fill><patternFill patternType="solid"><fgColor rgb="FFDDFFDD"/><bgColor indexed="64"/></patternFill></fill></fills><borders count="33"><border><left/><right/><top/><bottom/><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left/><right/><top/><bottom style="double"><color rgb="FF009900"/></bottom><diagonal/></border><border><left/><right/><top/><bottom style="medium"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right/><top style="thin"><color rgb="FF009900"/></top><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right/><top style="thin"><color rgb="FF009900"/></top><bottom/><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right/><top/><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top><bottom style="hair"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top style="hair"><color rgb="FF009900"/></top><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top/><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top><bottom style="double"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right/><top style="thin"><color rgb="FF009900"/></top><bottom style="double"><color rgb="FF009900"/></bottom><diagonal/></border><border><left/><right/><top style="thin"><color rgb="FF009900"/></top><bottom style="double"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top><bottom/><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right/><top/><bottom/><diagonal/></border><border><left/><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top><bottom style="double"><color rgb="FF009900"/></bottom><diagonal/></border><border><left/><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left/><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top><bottom/><diagonal/></border><border><left/><right style="thin"><color rgb="FF009900"/></right><top/><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left/><right style="thin"><color rgb="FF009900"/></right><top/><bottom/><diagonal/></border><border><left/><right/><top style="thin"><color rgb="FF009900"/></top><bottom/><diagonal/></border><border><left/><right/><top/><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right/><top style="double"><color rgb="FF009900"/></top><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left/><right style="thin"><color rgb="FF009900"/></right><top style="double"><color rgb="FF009900"/></top><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right/><top style="double"><color rgb="FF009900"/></top><bottom/><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top style="double"><color rgb="FF009900"/></top><bottom style="thin"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top><bottom style="medium"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right style="thin"><color rgb="FF009900"/></right><top/><bottom style="double"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right/><top/><bottom style="medium"><color rgb="FF009900"/></bottom><diagonal/></border><border><left/><right style="thin"><color rgb="FF009900"/></right><top/><bottom style="medium"><color rgb="FF009900"/></bottom><diagonal/></border><border><left style="thin"><color rgb="FF009900"/></left><right/><top style="thin"><color rgb="FF009900"/></top><bottom style="medium"><color rgb="FF009900"/></bottom><diagonal/></border><border><left/><right style="thin"><color rgb="FF009900"/></right><top style="thin"><color rgb="FF009900"/></top><bottom style="medium"><color rgb="FF009900"/></bottom><diagonal/></border><border><left/><right style="thin"><color rgb="FF009900"/></right><top style="double"><color rgb="FF009900"/></top><bottom/><diagonal/></border></borders><cellStyleXfs count="1"><xf numFmtId="0" fontId="0" fillId="0" borderId="0"><alignment vertical="center"/></xf></cellStyleXfs><cellXfs count="311"><xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="3" fillId="0" borderId="1" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="0" xfId="0" applyFont="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="0" xfId="0" applyFont="1" applyBorder="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="3" xfId="0" applyFont="1" applyBorder="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="0" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment wrapText="1"/></xf><xf numFmtId="0" fontId="9" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="9" fillId="2" borderId="1" xfId="0" quotePrefix="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="0" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment vertical="top"/></xf><xf numFmtId="0" fontId="5" fillId="3" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="4" borderId="10" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="4" borderId="10" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="4" borderId="10" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="left" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="178" fontId="5" fillId="0" borderId="0" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="0" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="0" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="7" fontId="5" fillId="0" borderId="0" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="0" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="3" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="5" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="5" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="5" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="6" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="6" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="6" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="4" borderId="11" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="4" borderId="10" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="1" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="177" fontId="5" fillId="0" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="177" fontId="5" fillId="5" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="177" fontId="5" fillId="6" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="7" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="8" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="0" borderId="4" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="14" fillId="0" borderId="8" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="180" fontId="14" fillId="0" borderId="8" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="181" fontId="14" fillId="0" borderId="8" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="7" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="8" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="14" fillId="7" borderId="8" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="180" fontId="14" fillId="7" borderId="8" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="181" fontId="14" fillId="7" borderId="8" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="left" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="left" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="178" fontId="5" fillId="0" borderId="0" xfId="0" applyNumberFormat="1" applyFont="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="14" fillId="0" borderId="0" xfId="0" applyFont="1"><alignment vertical="center"/></xf><xf numFmtId="178" fontId="14" fillId="0" borderId="0" xfId="0" applyNumberFormat="1" applyFont="1"><alignment vertical="center"/></xf><xf numFmtId="10" fontId="14" fillId="0" borderId="0" xfId="0" applyNumberFormat="1" applyFont="1"><alignment vertical="center"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="14" fillId="0" borderId="0" xfId="0" applyNumberFormat="1" applyFont="1"><alignment vertical="center"/></xf><xf numFmtId="182" fontId="14" fillId="0" borderId="0" xfId="0" applyNumberFormat="1" applyFont="1"><alignment vertical="center"/></xf><xf numFmtId="3" fontId="5" fillId="4" borderId="10" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="4" borderId="10" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="5" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="6" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="5" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="6" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="4" borderId="10" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="5" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="6" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="4" borderId="27" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="4" borderId="27" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="4" borderId="27" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="4" borderId="27" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="4" borderId="27" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="4" borderId="27" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="0" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="7" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="7" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="7" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="7" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="9" fontId="5" fillId="7" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="7" borderId="26" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="178" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="4" borderId="11" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="4" borderId="10" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="0" xfId="0" applyFont="1" applyFill="1"><alignment vertical="center"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="177" fontId="5" fillId="7" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="4" fillId="0" borderId="0" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="7" fillId="0" borderId="0" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="7" fillId="0" borderId="3" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="1" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="8" fillId="0" borderId="0" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="3" fillId="0" borderId="1" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="1" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" wrapText="1"/></xf><xf numFmtId="0" fontId="2" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="0" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="3" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="0" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment vertical="top" wrapText="1"/></xf><xf numFmtId="0" fontId="2" fillId="2" borderId="5" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="2" fillId="2" borderId="20" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="2" fillId="2" borderId="17" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="2" fillId="2" borderId="6" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="2" fillId="2" borderId="21" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="2" fillId="2" borderId="18" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="178" fontId="5" fillId="0" borderId="13" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="178" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="178" fontId="5" fillId="7" borderId="13" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="178" fontId="5" fillId="7" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="2" borderId="1" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="2" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="12" fillId="0" borderId="0" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="12" fillId="0" borderId="2" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="5" fillId="2" borderId="13" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="2" borderId="9" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="0" borderId="1" xfId="0" applyFont="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="0" xfId="0" applyFont="1" applyAlignment="1"><alignment vertical="center"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="6" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="21" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="18" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="6" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="21" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="18" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="2" borderId="5" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="2" borderId="20" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="2" borderId="17" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="2" borderId="6" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="2" borderId="21" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="2" borderId="18" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="4" borderId="11" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="4" borderId="12" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="5" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="17" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="14" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="19" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="28" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="29" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="30" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="31" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="22" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="23" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="16" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="7" borderId="16" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="4" borderId="15" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="30" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="31" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="4" borderId="6" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="4" borderId="18" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="178" fontId="5" fillId="7" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="178" fontId="5" fillId="7" borderId="16" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="178" fontId="5" fillId="0" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="178" fontId="5" fillId="0" borderId="16" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="179" fontId="5" fillId="7" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="179" fontId="5" fillId="7" borderId="16" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="179" fontId="5" fillId="0" borderId="4" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="179" fontId="5" fillId="0" borderId="16" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="13" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="9" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="5" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="6" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="6" fillId="4" borderId="10" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="5" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" wrapText="1" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="16" fillId="7" borderId="14" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="16" fillId="7" borderId="19" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="0" fillId="7" borderId="6" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" wrapText="1"/></xf><xf numFmtId="0" fontId="0" fillId="7" borderId="18" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" wrapText="1"/></xf><xf numFmtId="0" fontId="15" fillId="7" borderId="5" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="15" fillId="7" borderId="17" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="13" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="7" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="15" fillId="0" borderId="5" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="15" fillId="0" borderId="17" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="13" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="1" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="16" fillId="0" borderId="14" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="16" fillId="0" borderId="19" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="6" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" wrapText="1"/></xf><xf numFmtId="0" fontId="0" fillId="0" borderId="18" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" wrapText="1"/></xf><xf numFmtId="0" fontId="15" fillId="0" borderId="14" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="15" fillId="0" borderId="19" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="13" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="9" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="5" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="17" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="6" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="18" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="15" fillId="0" borderId="24" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="15" fillId="0" borderId="32" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="177" fontId="6" fillId="4" borderId="11" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="177" fontId="6" fillId="4" borderId="12" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="177" fontId="6" fillId="4" borderId="15" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="13" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" wrapText="1"/></xf><xf numFmtId="0" fontId="11" fillId="2" borderId="9" xfId="0" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="center" vertical="center" wrapText="1"/></xf><xf numFmtId="176" fontId="5" fillId="0" borderId="25" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="10" fontId="5" fillId="0" borderId="25" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="3" fontId="5" fillId="0" borderId="25" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="0" fontId="13" fillId="0" borderId="25" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment vertical="center" shrinkToFit="1"/></xf><xf numFmtId="183" fontId="5" fillId="0" borderId="25" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf><xf numFmtId="182" fontId="5" fillId="0" borderId="25" xfId="0" applyNumberFormat="1" applyFont="1" applyFill="1" applyBorder="1" applyAlignment="1"><alignment horizontal="right" vertical="center" shrinkToFit="1"/></xf></cellXfs><cellStyles count="1"><cellStyle name="標準" xfId="0" builtinId="0"/></cellStyles><dxfs count="82"><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><b/><i val="0"/></font></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FF0000FF"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf><dxf><font><strike val="0"/><color rgb="FFFF0000"/></font><numFmt numFmtId="177" formatCode="yyyy/mm/dd\ \(aaa\)"/></dxf></dxfs><tableStyles count="0" defaultTableStyle="TableStyleMedium2" defaultPivotStyle="PivotStyleLight16"/><colors><mruColors><color rgb="FF0000FF"/><color rgb="FFFF0000"/><color rgb="FFDDFFDD"/><color rgb="FF009900"/><color rgb="FFFF99CC"/><color rgb="FFFFFF99"/><color rgb="FFFFFFCC"/><color rgb="FFFFCCFF"/><color rgb="FFD3FFD3"/><color rgb="FF006600"/></mruColors></colors><extLst><ext uri="{EB79DEF2-80B8-43e5-95BD-54CBDDF9020C}" xmlns:x14="http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"><x14:slicerStyles defaultSlicerStyle="SlicerStyleLight1"/></ext></extLst></styleSheet> diff --git a/tests/xml/template/xl/workbook.xml b/tests/xml/template/xl/workbook.xml new file mode 100644 index 0000000..51c6bb7 --- /dev/null +++ b/tests/xml/template/xl/workbook.xml @@ -0,0 +1,12 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<workbook xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"><fileVersion appName="xl" lastEdited="4" lowestEdited="4" rupBuild="4505"/><workbookPr codeName="ThisWorkbook"/><bookViews><workbookView activeTab="0" autoFilterDateGrouping="1" firstSheet="0" minimized="0" showHorizontalScroll="1" showSheetTabs="1" showVerticalScroll="1" tabRatio="600" visibility="visible"/></bookViews><sheets> + <sheet name="表紙" sheetId="4" r:id="rId4"/><!-- 条件付き書式なしのシート --> + <sheet name="日別_Y" sheetId="5" r:id="rId5"/><!-- 条件付き書式ありのシート --> + <sheet name="日別_YDN" sheetId="6" r:id="rId6"/><!-- 出力側に存在しないシート --> +</sheets><calcPr calcId="999999" calcMode="auto" calcCompleted="0" fullCalcOnLoad="1"/> +<definedNames> + <definedName name="_xlnm.Print_Area" localSheetId="0">'表紙'!$A$18:$A$18</definedName><!-- 表紙の印刷範囲設定 --> + <definedName name="_xlnm.Print_Area" localSheetId="1">'日別_Y'!$A$18:$A$18</definedName><!-- 日別Yの印刷範囲設定 --> + <definedName name="_xlnm.Print_Area" localSheetId="2">'日別_YDN'!$A$18:$A$18</definedName><!-- 日別YDNの印刷範囲設定 --> +</definedNames> +</workbook> diff --git a/tests/xml/template/xl/worksheets/_rels/sheet1.xml.rels b/tests/xml/template/xl/worksheets/_rels/sheet1.xml.rels new file mode 100644 index 0000000..4439079 --- /dev/null +++ b/tests/xml/template/xl/worksheets/_rels/sheet1.xml.rels @@ -0,0 +1,4 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"> + <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/printerSettings" Target="../printerSettings/printerSettings1.bin"/> +</Relationships> diff --git a/tests/xml/template/xl/worksheets/_rels/sheet2.xml.rels b/tests/xml/template/xl/worksheets/_rels/sheet2.xml.rels new file mode 100644 index 0000000..d11cff2 --- /dev/null +++ b/tests/xml/template/xl/worksheets/_rels/sheet2.xml.rels @@ -0,0 +1,6 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"> + <Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing" Target="../drawings/drawing1.xml"/> + <Relationship Id="rId3" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing" Target="../drawings/drawing2.xml"/> + <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/printerSettings" Target="../printerSettings/printerSettings2.bin"/> +</Relationships> diff --git a/tests/xml/template/xl/worksheets/_rels/sheet3.xml.rels b/tests/xml/template/xl/worksheets/_rels/sheet3.xml.rels new file mode 100644 index 0000000..ea29b7a --- /dev/null +++ b/tests/xml/template/xl/worksheets/_rels/sheet3.xml.rels @@ -0,0 +1,5 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<Relationships xmlns="http://schemas.openxmlformats.org/package/2006/relationships"> + <Relationship Id="rId2" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/drawing" Target="../drawings/drawing3.xml"/> + <Relationship Id="rId1" Type="http://schemas.openxmlformats.org/officeDocument/2006/relationships/printerSettings" Target="../printerSettings/printerSettings2.bin"/> +</Relationships> diff --git a/tests/xml/template/xl/worksheets/sheet1.xml b/tests/xml/template/xl/worksheets/sheet1.xml new file mode 100644 index 0000000..d1e903e --- /dev/null +++ b/tests/xml/template/xl/worksheets/sheet1.xml @@ -0,0 +1,8 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<worksheet xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"> + <sheetData> + <row r="18" s="99"> + <c r="A18" s="33"><v>41111</v></c> + </row> + </sheetData> +</worksheet> diff --git a/tests/xml/template/xl/worksheets/sheet2.xml b/tests/xml/template/xl/worksheets/sheet2.xml new file mode 100644 index 0000000..dd793db --- /dev/null +++ b/tests/xml/template/xl/worksheets/sheet2.xml @@ -0,0 +1,12 @@ +<?xml version="1.0" encoding="UTF-8" standalone="yes"?> +<worksheet xml:space="preserve" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships"> + <sheetData> + <row r="18" s="99"> + <c r="A18" s="33"><v>41111</v></c> + <c r="B18" s="33"/> + <c r="C18" s="33"/> + </row> + </sheetData> +<conditionalFormatting><font /></conditionalFormatting> +<pageMargins /> +</worksheet> |