コレクション広場

七草あんこ

ブログ内で使用しているコレクションのサンプルです。

ご自由にお使いください。

ClearCollect(_TimeSeriesCollection01,
    {Element:"A",Value1:29,Value2:2,Value3:22,Value4:92,Value5:65,Value6:24,Value7:93,Value8:9,Value9:5,Value10:65,Value11:26,Value12:64},
    {Element:"B",Value1:98,Value2:62,Value3:27,Value4:33,Value5:22,Value6:63,Value7:53,Value8:80,Value9:65,Value10:8,Value11:69,Value12:45},
    {Element:"C",Value1:74,Value2:95,Value3:94,Value4:69,Value5:93,Value6:99,Value7:17,Value8:45,Value9:42,Value10:94,Value11:71,Value12:84}
);
ClearCollect(_TimeSeriesCollection02,
    {Element:"A",Value:29},{Element:"A",Value:2},{Element:"A",Value:22},{Element:"A",Value:92},
    {Element:"A",Value:65},{Element:"A",Value:24},{Element:"A",Value:93},{Element:"A",Value:9},
    {Element:"A",Value:5},{Element:"A",Value:65},{Element:"A",Value:26},{Element:"A",Value:64},
    {Element:"B",Value:98},{Element:"B",Value:62},{Element:"B",Value:27},{Element:"B",Value:33},
    {Element:"B",Value:22},{Element:"B",Value:63},{Element:"B",Value:53},{Element:"B",Value:80},
    {Element:"B",Value:65},{Element:"B",Value:8},{Element:"B",Value:69},{Element:"B",Value:45},
    {Element:"C",Value:74},{Element:"C",Value:95},{Element:"C",Value:94},{Element:"C",Value:69},
    {Element:"C",Value:93},{Element:"C",Value:99},{Element:"C",Value:17},{Element:"C",Value:45},
    {Element:"C",Value:42},{Element:"C",Value:94},{Element:"C",Value:71},{Element:"C",Value:84}
)
ClearCollect(_SampleCollection,
    {商品コード:101,商品名:"ミニトマト",単価:662,個数:0},
    {商品コード:102,商品名:"丸トマト",単価:498,個数:0},
    {商品コード:103,商品名:"きゅうり",単価:290,個数:0},
    {商品コード:104,商品名:"たまねぎ",単価:355,個数:0},
    {商品コード:105,商品名:"キャベツ",単価:117,個数:0},
    {商品コード:106,商品名:"ばれいしょ",単価:441,個数:0},
    {商品コード:107,商品名:"レタス",単価:192,個数:0},
    {商品コード:108,商品名:"なす",単価:654,個数:0},
    {商品コード:109,商品名:"ブロッコリー",単価:575,個数:0},
    {商品コード:110,商品名:"にんじん",単価:149,個数:0},
    {商品コード:201,商品名:"いちご",単価:2917,個数:0},
    {商品コード:202,商品名:"りんご",単価:484,個数:0},
    {商品コード:203,商品名:"みかん",単価:446,個数:0},
    {商品コード:204,商品名:"ぶどう",単価:2332,個数:0},
    {商品コード:205,商品名:"中晩柑類",単価:458,個数:0},
    {商品コード:206,商品名:"すいか",単価:693,個数:0},
    {商品コード:207,商品名:"なし",単価:721,個数:0},
    {商品コード:208,商品名:"メロン",単価:1926,個数:0},
    {商品コード:209,商品名:"かき",単価:442,個数:0},
    {商品コード:210,商品名:"もも",単価:648,個数:0}
)
アイキャッチ
ClearCollect(_TestCollection,
    {Seq:1,Question:"一番おいしい銘菓といえば?",Anser:"博多通りもん",UAnser:"",Point:15},
    {Seq:2,Question:"もみじ饅頭といえば?",Anser:"にしき堂",UAnser:"",Point:15},
    {Seq:3,Question:"赤福はこしあんですか?",Anser:"もちろん",UAnser:"",Point:20},
    {Seq:4,Question:"新大阪に寄ったら買うものは?",Anser:"Rおじさんのチーズケーキ",UAnser:"",Point:20},
    {Seq:5,Question:"八つ橋は・・・",Anser:"生がおいしい",UAnser:"",Point:30}
)
アイキャッチ
ClearCollect(_GraphCollection01,
    {Age:"0-4",Men:39685,Lady:37569},
    {Age:"5-9",Men:42759,Lady:39733},
    {Age:"10-14",Men:45316,Lady:42828},
    {Age:"15-19",Men:48551,Lady:46927},
    {Age:"20-24",Men:44920,Lady:45791},
    {Age:"25-29",Men:46322,Lady:46890},
    {Age:"30-34",Men:51114,Lady:51729},
    {Age:"35-39",Men:58462,Lady:58113},
    {Age:"40-44",Men:69762,Lady:69499},
    {Age:"45-49",Men:56907,Lady:58609},
    {Age:"50-54",Men:53106,Lady:54973},
    {Age:"55-59",Men:54451,Lady:57189},
    {Age:"60-64",Men:61242,Lady:63583},
    {Age:"65-69",Men:72456,Lady:78248},
    {Age:"70-74",Men:56282,Lady:64673},
    {Age:"75-79",Men:42143,Lady:53732},
    {Age:"80-84",Men:33437,Lady:50490},
    {Age:"85-",Men:26307,Lady:63108}
);
アイキャッチ
ClearCollect(_AreaCollection,
    {Sql:1,Group:"北海道",Area:"北海道",Year2020:5224614,Year2019:5381733,Year2018:5506419},
    {Sql:2,Group:"東北",Area:"青森県",Year2020:1237984,Year2019:1308265,Year2018:1373339},
    {Sql:3,Group:"東北",Area:"岩手県",Year2020:1210534,Year2019:1279594,Year2018:1330147},
    {Sql:4,Group:"東北",Area:"宮城県",Year2020:2301996,Year2019:2333899,Year2018:2348165},
    {Sql:5,Group:"東北",Area:"秋田県",Year2020:959502,Year2019:1023119,Year2018:1085997},
    {Sql:6,Group:"東北",Area:"山形県",Year2020:1068027,Year2019:1123891,Year2018:1168924},
    {Sql:7,Group:"東北",Area:"福島県",Year2020:1833152,Year2019:1914039,Year2018:2029064},
    {Sql:8,Group:"関東",Area:"茨城県",Year2020:2867009,Year2019:2916976,Year2018:2969770},
    {Sql:9,Group:"関東",Area:"栃木県",Year2020:1933146,Year2019:1974255,Year2018:2007683},
    {Sql:10,Group:"関東",Area:"群馬県",Year2020:1939110,Year2019:1973115,Year2018:2008068},
    {Sql:11,Group:"関東",Area:"埼玉県",Year2020:7344765,Year2019:7266534,Year2018:7194556},
    {Sql:12,Group:"関東",Area:"千葉県",Year2020:6284480,Year2019:6222666,Year2018:6216289},
    {Sql:13,Group:"関東",Area:"東京都",Year2020:14047594,Year2019:13515271,Year2018:13159388},
    {Sql:14,Group:"関東",Area:"神奈川県",Year2020:9237337,Year2019:9126214,Year2018:9048331},
    {Sql:15,Group:"中部",Area:"新潟県",Year2020:2201272,Year2019:2304264,Year2018:2374450},
    {Sql:16,Group:"中部",Area:"富山県",Year2020:1034814,Year2019:1066328,Year2018:1093247},
    {Sql:17,Group:"中部",Area:"石川県",Year2020:1132526,Year2019:1154008,Year2018:1169788},
    {Sql:18,Group:"中部",Area:"福井県",Year2020:766863,Year2019:786740,Year2018:806314},
    {Sql:19,Group:"中部",Area:"山梨県",Year2020:809974,Year2019:834930,Year2018:863075},
    {Sql:20,Group:"中部",Area:"長野県",Year2020:2048011,Year2019:2098804,Year2018:2152449},
    {Sql:21,Group:"中部",Area:"岐阜県",Year2020:1978742,Year2019:2031903,Year2018:2080773},
    {Sql:22,Group:"中部",Area:"静岡県",Year2020:3633202,Year2019:3700305,Year2018:3765007},
    {Sql:23,Group:"中部",Area:"愛知県",Year2020:7542415,Year2019:7483128,Year2018:7410719},
    {Sql:24,Group:"近畿",Area:"三重県",Year2020:1770254,Year2019:1815865,Year2018:1854724},
    {Sql:25,Group:"近畿",Area:"滋賀県",Year2020:1413610,Year2019:1412916,Year2018:1410777},
    {Sql:26,Group:"近畿",Area:"京都府",Year2020:2578087,Year2019:2610353,Year2018:2636092},
    {Sql:27,Group:"近畿",Area:"大阪府",Year2020:8837685,Year2019:8839469,Year2018:8865245},
    {Sql:28,Group:"近畿",Area:"兵庫県",Year2020:5465002,Year2019:5534800,Year2018:5588133},
    {Sql:29,Group:"近畿",Area:"奈良県",Year2020:1324473,Year2019:1364316,Year2018:1400728},
    {Sql:30,Group:"近畿",Area:"和歌山県",Year2020:922584,Year2019:963579,Year2018:1002198},
    {Sql:31,Group:"中国",Area:"鳥取県",Year2020:553407,Year2019:573441,Year2018:588667},
    {Sql:32,Group:"中国",Area:"島根県",Year2020:671126,Year2019:694352,Year2018:717397},
    {Sql:33,Group:"中国",Area:"岡山県",Year2020:1888432,Year2019:1921525,Year2018:1945276},
    {Sql:34,Group:"中国",Area:"広島県",Year2020:2799702,Year2019:2843990,Year2018:2860750},
    {Sql:35,Group:"中国",Area:"山口県",Year2020:1342059,Year2019:1404729,Year2018:1451338},
    {Sql:36,Group:"四国",Area:"徳島県",Year2020:719559,Year2019:755733,Year2018:785491},
    {Sql:37,Group:"四国",Area:"香川県",Year2020:950244,Year2019:976263,Year2018:995842},
    {Sql:38,Group:"四国",Area:"愛媛県",Year2020:1334841,Year2019:1385262,Year2018:1431493},
    {Sql:39,Group:"四国",Area:"高知県",Year2020:691527,Year2019:728276,Year2018:764456},
    {Sql:40,Group:"九州",Area:"福岡県",Year2020:5135214,Year2019:5101556,Year2018:5071968},
    {Sql:41,Group:"九州",Area:"佐賀県",Year2020:811442,Year2019:832832,Year2018:849788},
    {Sql:42,Group:"九州",Area:"長崎県",Year2020:1312317,Year2019:1377187,Year2018:1426779},
    {Sql:43,Group:"九州",Area:"熊本県",Year2020:1738301,Year2019:1786170,Year2018:1817426},
    {Sql:44,Group:"九州",Area:"大分県",Year2020:1123852,Year2019:1166338,Year2018:1196529},
    {Sql:45,Group:"九州",Area:"宮崎県",Year2020:1069576,Year2019:1104069,Year2018:1135233},
    {Sql:46,Group:"九州",Area:"鹿児島県",Year2020:1588256,Year2019:1648177,Year2018:1706242},
    {Sql:47,Group:"九州",Area:"沖縄県",Year2020:1467480,Year2019:1433566,Year2018:1392818}
);