「付加行」機能 実装（いちおう）完了。

[nucalgen] / nucalgen / group-sum.xml

diff --git a/nucalgen/group-sum.xml b/nucalgen/group-sum.xml
new file mode 100644 (file)
index 0000000..87db1cc
--- /dev/null
+++ b/nucalgen/group-sum.xml
@@ -0,0 +1,34 @@
+<?xml version="1.0" encoding="UTF-8" ?>
+<addition>
+       <row>
+               <cell />
+               <cell><value>食品群別摂取量</value></cell>
+       </row>
+       <row>
+               <cell />
+               <cell><value>食品群</value></cell>
+               <cell><value></value></cell>
+               <cell><value>摂取量(g)</value></cell>
+       </row>
+
+       <row><cell /><cell><value>1</value></cell><cell><value>穀類</value></cell><cell><formula>SUMIF(AREA_GROUP, 1, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>2</value></cell><cell><value>いも及びでん粉類</value></cell><cell><formula>SUMIF(AREA_GROUP, 2, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>3</value></cell><cell><value>砂糖及び甘味類</value></cell><cell><formula>SUMIF(AREA_GROUP, 3, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>4</value></cell><cell><value>豆類</value></cell><cell><formula>SUMIF(AREA_GROUP, 4, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>5</value></cell><cell><value>種実類</value></cell><cell><formula>SUMIF(AREA_GROUP, 5, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>6</value></cell><cell><value>野菜類</value></cell><cell><formula>SUMIF(AREA_GROUP, 6, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value></value></cell><cell><value>うち　緑黄色野菜</value></cell><cell><formula>SUMIF(AREA_BRIGHT_COLORED_VEGETABLE, 1, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>7</value></cell><cell><value>果実類</value></cell><cell><formula>SUMIF(AREA_GROUP, 7, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>8</value></cell><cell><value>きのこ類</value></cell><cell><formula>SUMIF(AREA_GROUP, 8, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>9</value></cell><cell><value>藻類</value></cell><cell><formula>SUMIF(AREA_GROUP, 9, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>10</value></cell><cell><value>魚介類</value></cell><cell><formula>SUMIF(AREA_GROUP, 10, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>11</value></cell><cell><value>肉類</value></cell><cell><formula>SUMIF(AREA_GROUP, 11, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>12</value></cell><cell><value>卵類</value></cell><cell><formula>SUMIF(AREA_GROUP, 12, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>13</value></cell><cell><value>乳類</value></cell><cell><formula>SUMIF(AREA_GROUP, 13, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>14</value></cell><cell><value>油脂類</value></cell><cell><formula>SUMIF(AREA_GROUP, 14, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>15</value></cell><cell><value>菓子類</value></cell><cell><formula>SUMIF(AREA_GROUP, 15, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>16</value></cell><cell><value>し好飲料類</value></cell><cell><formula>SUMIF(AREA_GROUP, 16, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>17</value></cell><cell><value>調味料及び香辛料類</value></cell><cell><formula>SUMIF(AREA_GROUP, 17, AREA_INTAKE)</formula></cell></row>
+       <row><cell /><cell><value>18</value></cell><cell><value>調理加工食品類</value></cell><cell><formula>SUMIF(AREA_GROUP, 18, AREA_INTAKE)</formula></cell></row>
+
+</addition>