{"id":10199,"date":"2020-03-26T06:00:00","date_gmt":"2020-03-25T21:00:00","guid":{"rendered":"https:\/\/www.muscle-hypertrophy.com\/?p=10199"},"modified":"2020-01-23T16:48:12","modified_gmt":"2020-01-23T07:48:12","slug":"%e5%9b%bd%e5%8b%a2%e8%aa%bf%e6%9f%bb%e3%81%8b%e3%82%89%ef%bc%95%e6%ad%b3%e9%9a%8e%e7%b4%9a%e3%81%ae%e9%83%bd%e9%81%93%e5%ba%9c%e7%9c%8c%e5%88%a5%e4%ba%ba%e5%8f%a3%e6%8e%a8%e7%a7%bb%e3%82%92%e8%aa%bf","status":"publish","type":"post","link":"https:\/\/www.muscle-hypertrophy.com\/?p=10199","title":{"rendered":"\u56fd\u52e2\u8abf\u67fb\u304b\u3089\uff15\u6b73\u968e\u7d1a\u306e\u4eba\u53e3\u63a8\u79fb\u3092\u8abf\u3079\u308b"},"content":{"rendered":"\n<p>\u3000\u4eba\u53e3\u7d71\u8a08\u306f\u6700\u3082\u91cd\u8981\u306a\u57fa\u5e79\u7d71\u8a08\u306e\u4e00\u3064\u3067\u3042\u308b\uff0e\u7dcf\u52d9\u7701\u306e e-Stat \u306f\u78ba\u304b\u306b\u6709\u7528\u3067\u3042\u308b\u304c\uff0c\u304b\u3086\u3044\u3068\u3053\u308d\u306b\u624b\u304c\u5c4a\u304b\u306a\u3044\uff0e\u4f8b\u3048\u3070\u300c\u5e02\u533a\u753a\u6751\u3054\u3068\uff0c\u5e74\u9f62\uff15\u6b73\u968e\u7d1a\u3054\u3068\u306e\u4eba\u53e3\u69cb\u6210\u306e\u56fd\u52e2\u8abf\u67fb\u3054\u3068\u306e\u63a8\u79fb\u3092\u77e5\u308a\u305f\u3044\u300d\u3068\u3044\u3046\u8981\u6c42\u306b\u306f\u5168\u304f\u7121\u529b\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u4e3b\u3068\u3057\u3066\u6280\u8853\u7684\u306a\u7406\u7531\u306b\u3088\u308b\u3082\u306e\u3068\uff0c\u7d71\u8a08\u8abf\u67fb\u306e\u7c92\u5ea6\u306e\u7d30\u304b\u3055\u306b\u3088\u308b\uff0e\u6280\u8853\u7684\u306a\u7406\u7531\u3068\u3057\u3066\u306f\uff0c\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u753b\u9762\u8868\u793a\u30bb\u30eb\u6570\u306e\u4e0a\u9650\u3092\u5bb9\u6613\u306b\u8d85\u3048\u3066\u3057\u307e\u3046\u30c7\u30fc\u30bf\u91cf\u306b\u306a\u3063\u3066\u3057\u307e\u3046\u3053\u3068\u3067\u3042\u308b\uff0e\u3057\u304b\u3057\uff0c\u6839\u672c\u7684\u306a\u7406\u7531\u306f\u8abf\u67fb\u306e\u7c92\u5ea6\u306e\u7d30\u304b\u3055\u3067\u3042\u308b\uff0e<\/p>\n<p>\u30002005 \u5e74\u4ee5\u524d\u3068 2010 \u5e74\u4ee5\u964d\u3068\u3067\u306f\u8abf\u67fb\u306e\u7cbe\u5ea6\u304c\u9055\u3046\uff0e\u4eca\u5f8c\u306f\u9ad8\u7cbe\u5ea6\u306a\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb\u304c e-Stat \u306b\u63b2\u8f09\u3055\u308c\u3066\u3044\u304f\u3082\u306e\u3068\u601d\u308f\u308c\u308b\u304c\uff0c2005 \u5e74\u4ee5\u524d\u306b\u95a2\u3057\u3066\u306f\u90fd\u9053\u5e9c\u770c\u3088\u308a\u7d30\u304b\u3044\u7c92\u5ea6\u306f\u5b58\u5728\u3057\u306a\u3044\uff0e\u305d\u3053\u3092\u6c42\u3081\u308b\u3068\u624b\u4f5c\u696d\u306b\u306a\u3063\u3066\u3057\u307e\u3044\uff0c\u73fe\u5b9f\u7684\u3067\u306f\u306a\u3044\uff0e<a href=\"http:\/\/www.ipss.go.jp\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u56fd\u7acb\u793e\u4f1a\u4fdd\u969c\u30fb\u4eba\u53e3\u554f\u984c\u7814\u7a76\u6240<\/a>\u306a\u3089\u30c7\u30fc\u30bf\u3092\u6301\u3063\u3066\u3044\u308b\u304b\u3082\u3057\u308c\u306a\u3044\uff0e<\/p>\n<p>\u30002020 \u5e74\u306f\u56fd\u52e2\u8abf\u67fb\u306e\u5e74\u306b\u3042\u305f\u308b\uff0e\u7dcf\u52d9\u7701\u306b\u306f\u3067\u304d\u308b\u3060\u3051\u7d30\u304b\u3044\u7c92\u5ea6\u3067\u306e\u30c7\u30fc\u30bf\u63b2\u8f09\u3092\u671b\u3080\u3082\u306e\u3067\u3042\u308b\uff0e<\/p>\n<p><!--more--><\/p>\n<h2>\u56fd\u52e2\u8abf\u67fb\u306e\u30c7\u30fc\u30bf\u30d5\u30a1\u30a4\u30eb<\/h2>\n<h3>\u5927\u6b63 9 \u5e74\uff081920 \u5e74\uff09\u304b\u3089\u5e73\u6210 17 \u5e74\uff082005 \u5e74\uff09\u307e\u3067<\/h3>\n<p>\u3000\u90fd\u9053\u5e9c\u770c\u5225\u306e\u7d71\u8a08\u306f\u306a\u3044\uff0e\u5168\u56fd\u306e\u307f\u3067\u3042\u308b\uff0e\u7537\u5973\u5225\u306e\u7d71\u8a08\u304c\u3042\u308b\uff0e\u4e0b\u56f3\u306e 17 \u756a\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3059\u308b\uff0e\u30d5\u30a1\u30a4\u30eb\u540d\u306f 05017 \u3067\u3042\u308b\uff0e\u30ef\u30fc\u30af\u30b7\u30fc\u30c8 2 \u679a\u304b\u3089\u306a\u308b\uff0eJH17017-01 \u3068\u3044\u3046\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u304c\u76ee\u7684\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u4eca\u56de\u306f\u3053\u306e\u30c7\u30fc\u30bf\u3092\u4f7f\u3046\uff0e<\/p>\n<figure id=\"attachment_10223\" aria-describedby=\"caption-attachment-10223\" style=\"width: 745px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/10.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10223\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/10.png\" alt=\"\u5e73\u621017\u5e74\u56fd\u52e2\u8abf\u67fb\u300c17\u3000\u5e74\u9f62\uff08\uff15\u6b73\u968e\u7d1a\uff09\uff0c\u7537\u5973\u5225\u4eba\u53e3\u53ca\u3073\u4eba\u53e3\u6027\u6bd4-\u5168\u56fd\uff08\u5927\u6b639\u5e74\uff5e\u5e73\u621017\u5e74\uff09\u300d\" width=\"745\" height=\"396\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/10.png 745w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/10-300x159.png 300w\" sizes=\"auto, (max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><figcaption id=\"caption-attachment-10223\" class=\"wp-caption-text\">\u5e73\u621017\u5e74\u56fd\u52e2\u8abf\u67fb\u300c17\u3000\u5e74\u9f62\uff08\uff15\u6b73\u968e\u7d1a\uff09\uff0c\u7537\u5973\u5225\u4eba\u53e3\u53ca\u3073\u4eba\u53e3\u6027\u6bd4-\u5168\u56fd\uff08\u5927\u6b639\u5e74\uff5e\u5e73\u621017\u5e74\uff09\u300d<\/figcaption><\/figure>\n<h3>\u5e73\u6210 7 \u5e74\uff081995 \u5e74\uff09\u304b\u3089\u5e73\u6210 17 \u5e74\uff082005 \u5e74\uff09\u307e\u3067<\/h3>\n<p>\u3000\u90fd\u9053\u5e9c\u770c\u5225\u306e\u7d71\u8a08\u306e\u307f\u3067\uff0c\u5e02\u533a\u753a\u6751\u306e\u7c92\u5ea6\u306f\u306a\u3044\uff0e\u7537\u5973\u5225\u306e\u7d71\u8a08\u304c\u3042\u308b\uff0e<\/p>\n<h3>\u5e73\u6210 22 \u5e74\uff082010 \u5e74\uff09\u4ee5\u964d<\/h3>\n<p>\u3000\u5e02\u533a\u753a\u6751\u306e\u7c92\u5ea6\u3067\u5404\u5e74\u9f62\uff0c\u7537\u5973\u5225\u306e\u30c7\u30fc\u30bf\u304c\u5b58\u5728\u3059\u308b\uff0e\u672c\u6765\uff0c\u3053\u306e\u30ec\u30d9\u30eb\u3067\u8abf\u67fb\u30fb\u516c\u958b\u3057\u3066\u3082\u3089\u3044\u305f\u3044\uff0e<\/p>\n<h2>\u30c7\u30fc\u30bf\u30af\u30ec\u30f3\u30b8\u30f3\u30b0<\/h2>\n<p>\u3000\u3088\u304f\u898b\u308b\u7a4d\u307f\u4e0a\u3052\u68d2\u30b0\u30e9\u30d5\u3067\u306f\uff15\u6b73\u3054\u3068\u306e\u5e74\u9f62\u968e\u7d1a\uff08\uff15\u6b73\u968e\u7d1a\uff09\u3067\u30c7\u30fc\u30bf\u7cfb\u5217\u3092\u5206\u985e\u3057\u3066\u3044\u308b\uff0e\u3057\u304b\u3057\uff0c\u3053\u306e\u8868\u8a18\u3060\u3068\u30b0\u30e9\u30d5\u4f5c\u6210\u306f\u3057\u3084\u3059\u3044\u304c\u89e3\u91c8\u304c\u96e3\u3057\u304f\u306a\u308b\uff0e\u5c11\u5b50\u9ad8\u9f62\u5316\u306e\u6b63\u4f53\u304c\u898b\u3048\u3065\u3089\u3044\u306e\u306f\uff0c\u3053\u308c\u304c\u539f\u56e0\u3067\u306f\u306a\u3044\u304b\uff0e<\/p>\n<p>\u3000\u672c\u6765\uff0c\u5e74\u9f62\u306f\u751f\u307e\u308c\u305f\u5e74\u3068\u73fe\u5728\u3068\u306e\u5dee\u3067\u8a08\u7b97\u3055\u308c\u308b\u76f8\u5bfe\u7684\u306a\u5024\u306b\u904e\u304e\u306a\u3044\uff0e\u3060\u304b\u3089\uff0c\u751f\u307e\u308c\u305f\u5e74\u3092\uff15\u5e74\u6bce\u306e\u968e\u7d1a\uff08\u751f\u5e74\u968e\u7d1a\u3068\u3067\u3082\u8a00\u304a\u3046\u304b\uff09\u306b\u533a\u5207\u3063\u3066\u30c7\u30fc\u30bf\u7cfb\u5217\u306b\u3057\u3066\u307f\u305f\u3089\u3069\u3046\u3060\u308d\u3046\uff0e<\/p>\n<h3>\uff15\u6b73\u968e\u7d1a\u3092\u751f\u5e74\u306b\u5909\u63db<\/h3>\n<p>\u3000\u5e74\u5ea6\u304b\u3089\u5e74\u9f62\u968e\u7d1a\u3092\u5f15\u304d\u7b97\u3059\u308b\u3060\u3051\u3067\u3042\u308b\uff0e\u4f8b\u3048\u3070\uff0c2015 \u5e74\u5ea6\u306e 0-4 \u6b73\u968e\u7d1a\u306f 2015 \u3068\u306a\u308b\uff0eDATEDIFF \u95a2\u6570\u306e\u9006\u306e\u4f7f\u3044\u65b9\u3092\u3084\u308b\u308f\u3051\u3060\uff0e\u3067\u304d\u305f\u5217\u306e\u30bf\u30a4\u30c8\u30eb\u3092 BirthYear \u3068\u3057\u3066\u304a\u3053\u3046\uff0e<\/p>\n<h3>\u5e74\u5ea6\u306f\u6a2a\u8ef8\u3068\u306a\u308b<\/h3>\n<p>\u3000\u3053\u308c\u306f\u901a\u5e38\u306e\u30b0\u30e9\u30d5\u3068\u5909\u308f\u3089\u306a\u3044\uff0e<\/p>\n<h3>\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u8981\u7d20\u6570\u306f\u540c\u3058\u3067\u306a\u304f\u3066\u306f\u306a\u3089\u306a\u3044<\/h3>\n<p>\u30001920 \u5e74\u304b\u3089\u59cb\u307e\u3063\u305f\u56fd\u52e2\u8abf\u67fb\u306f 2005 \u5e74\u3067 18 \u56de\u76ee\u3067\u3042\u308b\uff0e\u3060\u304b\u3089\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u8981\u7d20\u6570\u3082 18 \u3067\u306a\u304f\u3066\u306f\u306a\u3089\u306a\u3044\uff0e<\/p>\n<p>\u3000\u4f55\u3092\u5f53\u305f\u308a\u524d\u306e\u3053\u3068\u3092\uff0c\u3068\u601d\u3046\u304b\u3082\u77e5\u308c\u306a\u3044\uff0e\u3057\u304b\u3057\uff0c\u610f\u5916\u3068\u76f2\u70b9\u3067\u3042\u308b\uff0e\u3055\u3082\u306a\u3044\u3068\u30b0\u30e9\u30d5\u306e\u8868\u8a18\u304c\u72c2\u3046\uff0e\u6a2a\u8ef8\u306e\u4f4d\u7f6e\u304c\u5b9a\u307e\u3089\u306a\u3044\u306e\u3067\u3042\u308b\uff0e\u30b0\u30e9\u30d5\u306b\u304a\u3044\u3066\u3053\u308c\u306f\u81f4\u547d\u7684\u3060\uff0e<\/p>\n<p>\u3000\u305d\u306e\u76ee\u3067\u3082\u3046\u4e00\u5ea6\u30c6\u30fc\u30d6\u30eb\u3092\u898b\u76f4\u3059\u3068\uff0c\u4e0d\u8db3\u3057\u3066\u3044\u308b\u30c7\u30fc\u30bf\u304c\u3042\u308b\u3053\u3068\u306b\u6c17\u304c\u3064\u304f\uff0e\u751f\u5e74\u3067\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u304b\u3051\u305f\u969b\u306b\u62bd\u51fa\u3055\u308c\u3066\u304f\u308b\u30ec\u30b3\u30fc\u30c9\u306f 18 \u4ef6\u3042\u308b\u3060\u308d\u3046\u304b\uff1f\u3082\u3057\u4e0d\u8db3\u3057\u3066\u3044\u308b\u306a\u3089\u8ffd\u52a0\u3059\u308b\u5fc5\u8981\u304c\u3042\u308b\uff0e<\/p>\n<h3>\u76f4\u7a4d\u3092\u4f5c\u308b\u306b\u306f SQL \u304c\u5411\u3044\u3066\u3044\u308b<\/h3>\n<p>\u3000\u30c6\u30fc\u30d6\u30eb\u306b\u65b0\u305f\u306a\u884c\u3092\u8ffd\u52a0\u3059\u308b\u306b\u306f EXCEL \u306a\u3089\u30eb\u30fc\u30d7\u306e\u4e2d\u3067 ListRows.Add \u30e1\u30bd\u30c3\u30c9\u3092\u4f7f\u3046\u3060\u308d\u3046\uff0e\u3060\u304c\uff0cEXCEL \u3067\u306f\u3053\u3046\u3044\u3046\u4f5c\u696d\u306f\u307e\u3060\u82e6\u624b\u3060\uff0e\u5206\u304b\u3063\u3066\u3044\u308b\u4eba\u306f\u3059\u3050\u306b\u30d4\u30f3\u3068\u304f\u308b\u3068\u601d\u3046\u304c\uff0c\u3053\u308c\u306f\u76f4\u7a4d\u3092\u4f5c\u308b\u3053\u3068\u306b\u4ed6\u306a\u3089\u306a\u3044\uff0e\u3053\u3046\u3044\u3046\u4f5c\u696d\u306f SQL \u306b\u3084\u3089\u305b\u305f\u65b9\u304c\u3046\u307e\u304f\u884c\u304f\uff0e<\/p>\n<p>\u3000\u305d\u3053\u3067\u4e00\u65e6\u30c6\u30fc\u30d6\u30eb\u3092 txt \u30d5\u30a1\u30a4\u30eb\u306b\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066 SQL Server \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\uff0e<\/p>\n<h4>\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u3067\u30de\u30b9\u30bf\u30fc\u3092\u4f5c\u6210<\/h4>\n<p>\u3000\u4f7f\u3044\u6368\u3066\u306e\u30de\u30b9\u30bf\u30fc\u30c6\u30fc\u30d6\u30eb\u306a\u306e\u3067\uff0c\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306b\u751f\u5e74\u3068\u5e74\u5ea6\u3092\u66f8\u304d\u8fbc\u3080\uff0e\u3053\u306e\u4e00\u6642\u30c6\u30fc\u30d6\u30eb\u306b\u306f35 \u4ef6\uff081835 \u5e74\u304b\u3089 2005 \u5e74\u307e\u3067 5 \u5e74\u3054\u3068\uff09\u00d7 18 \u4ef6\uff081920 \u5e74\u304b\u3089 2005 \u5e74\u307e\u3067 5 \u5e74\u3054\u3068\uff09\u3067 630 \u4ef6\u306e\u30c7\u30fc\u30bf\u304c\u5165\u308b\uff0e\u3053\u306e\u30de\u30b9\u30bf\u30fc\u306b\u5bfe\u3057\u3066\u5de6\u5916\u90e8\u7d50\u5408\u3092\u884c\u3046\uff0e<\/p>\n<p>\u3000\u4e0b\u8a18\u30af\u30a8\u30ea\u306f\u751f\u5e74\u3068\u5e74\u5ea6\u306e\u76f4\u7a4d\u3092\u4f5c\u6210\u3059\u308b\u3082\u306e\u3067\u3042\u308b\uff0e<\/p>\n<pre>DROP\tTABLE IF EXISTS #SERIES;\nCREATE\tTABLE #SERIES(BIRTHYEAR INT NOT NULL);\nINSERT\tINTO #SERIES VALUES (1835),\n(1840),\n(1845),\n(1850),\n(1855),\n(1860),\n(1865),\n(1870),\n(1875),\n(1880),\n(1885),\n(1890),\n(1895),\n(1900),\n(1905),\n(1910),\n(1915),\n(1920),\n(1925),\n(1930),\n(1935),\n(1940),\n(1945),\n(1950),\n(1955),\n(1960),\n(1965),\n(1970),\n(1975),\n(1980),\n(1985),\n(1990),\n(1995),\n(2000),\n(2005);\n\nDROP\tTABLE IF EXISTS #FISCALYEAR;\nCREATE\tTABLE #FISCALYEAR(FISCALYEAR INT NOT NULL);\nINSERT\tINTO #FISCALYEAR VALUES(1920),\n(1925),\n(1930),\n(1935),\n(1940),\n(1945),\n(1950),\n(1955),\n(1960),\n(1965),\n(1970),\n(1975),\n(1980),\n(1985),\n(1990),\n(1995),\n(2000),\n(2005);\n\nWITH CTE(BirhtYear, FiscalYear)\nAS(SELECT\t* \nFROM\t#SERIES\nCROSS\tJOIN #FISCALYEAR)\n\nSELECT\t*\nFROM\tCTE\nORDER\tBY BirhtYear, FiscalYear;<\/pre>\n<pre>(35 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n\n(18 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n\n(630 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<h3>\u30de\u30b9\u30bf\u30fc\u306b\u4eba\u53e3\u30c6\u30fc\u30d6\u30eb\u3092\u5168\u7d50\u5408<\/h3>\n<p>\u3000\u6b21\u306f\u751f\u5e74\u3068\u5e74\u5ea6\u306e\u76f4\u7a4d\u306b\u4eba\u53e3\u30c6\u30fc\u30d6\u30eb\u3092\u5168\u7d50\u5408\u3059\u308b\u30af\u30a8\u30ea\u3067\u3042\u308b\uff0e\u5de6\u5916\u90e8\u7d50\u5408\u3067\u306f\u306a\u304f\u5168\u7d50\u5408\u3059\u308b\u306e\u306f 1945 \u5e74\u306e\u56fd\u52e2\u8abf\u67fb\u306e\u307f\uff0c\u5e74\u9f62\u968e\u7d1a\u306e\u96c6\u8a08\u533a\u5206\u304c\u7570\u306a\u308b\u305f\u3081\u3067\u3042\u308b\uff0e<\/p>\n<pre class=\"\">SELECT\t* \nFROM\tCTE\nFULL\tJOIN\tdbo.[T_Population(1920-2005)]\nON\t\tCTE.BirhtYear = dbo.[T_Population(1920-2005)].BirthYear\nAND\t\tCTE.FiscalYear = dbo.[T_Population(1920-2005)].FiscalYear\nORDER\tBY CTE.BirhtYear, CTE.FiscalYear;<\/pre>\n<pre>(648 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<p>\u3000\u3053\u306e 1945 \u5e74\u306e\u30c7\u30fc\u30bf\u3092\u3069\u3046\u6271\u3046\u3079\u304d\u3060\u308d\u3046\u304b\uff1f\u3053\u3053\u3067\u4e00\u65e6\uff0c\u5143\u306e\u30c7\u30fc\u30bf\u306b\u623b\u308d\u3046\uff0e<\/p>\n<p>\u30001945 \u5e74\u306f\u7d42\u6226\u306e\u5e74\u3067\u3042\u308b\uff0e\u306a\u305c\u3053\u306e\u6642\u306e\u56fd\u52e2\u8abf\u67fb\u306e\u307f, 1 \u6b73\u304b\u3089 5 \u6b73\u3068\u3044\u3046\u5e74\u9f62\u968e\u7d1a\u3067\u96c6\u8a08\u3055\u308c\u305f\u306e\u304b\u306f\uff0c\u5b9a\u304b\u3067\u306a\u3044\uff0e\u4ed6\u306e\u5e74\u306f\u3059\u3079\u3066 0 \u6b73\u304b\u3089 4 \u6b73\u3068\u3044\u3046\u5e74\u9f62\u968e\u7d1a\u3067\u96c6\u8a08\u3055\u308c\u3066\u3044\u308b\u306e\u306b\u3067\u3042\u308b\uff0e\u63a8\u6e2c\u3060\u304c\uff0c\u65e5\u672c\u4eba\u306e\u5e74\u9f62\u306e\u6570\u3048\u65b9\u306b\u300c<a href=\"https:\/\/ja.wikipedia.org\/wiki\/%E6%95%B0%E3%81%88%E5%B9%B4\" target=\"_blank\" rel=\"noopener noreferrer\">\u6570\u3048\u5e74<\/a>\u300d\u304c\u3042\u308b\u305f\u3081\u3067\u306f\u306a\u3044\u3060\u308d\u3046\u304b\uff0e<\/p>\n<p>\u3000\u5883\u754c\u306e\u5e74\u9f62\u306b\u3042\u308b\u4eba\u53e3\u306e\u5206\u3060\u3051\u96c6\u8a08\u5024\u304c\u305a\u308c\u308b\u304c\uff0c\u30b0\u30e9\u30d5\u306e\u898b\u3084\u3059\u3055\u3092\u512a\u5148\u3059\u308b\uff0e\u57fa\u306e\u30c7\u30fc\u30bf\u304c\u5b58\u5728\u3057\u306a\u3044\u4ee5\u4e0a\uff0c\u3084\u3080\u3092\u5f97\u306a\u3044\uff0e<\/p>\n<p>\u3000\u6226\u5f8c 10 \u5e74\u9593\u306e\u5e74\u9f62\u306e\u96c6\u8a08\u306b\u306f\u6ce8\u91c8\u304c\u591a\u3044\uff0e\u300c\u6570\u3048\u5e74\u300d\uff0c\u300c\u6c96\u7e04\u300d\u306a\u3069\u6226\u5f8c\u306e\u6df7\u4e71\u304c\u7d9a\u3044\u3066\u3044\u308b\u3053\u3068\u3092\u4f3a\u308f\u305b\u308b\uff0e<\/p>\n<p>\u3000\u4e00\u65e6\u4eba\u53e3\u30c6\u30fc\u30d6\u30eb\u3092\u524a\u9664\u3057\u3088\u3046\uff0e<\/p>\n<pre>DROP TABLE dbo.[T_Population(1920-2005)];<\/pre>\n<pre>\u30b3\u30de\u30f3\u30c9\u306f\u6b63\u5e38\u306b\u5b8c\u4e86\u3057\u307e\u3057\u305f\u3002<\/pre>\n<p>\u3000\u5143\u306e EXCEL \u30d5\u30a1\u30a4\u30eb\u306e 1945 \u5e74\u306e\u5e74\u9f62\u968e\u7d1a\u3092 1 \u6b73\u305a\u3064\u6e1b\u3089\u3057\u3066\u4fee\u6b63\u3059\u308b\uff0e\u305d\u306e\u5f8c\u5e74\u5ea6\u304b\u3089\u5e74\u9f62\u968e\u7d1a\u3092\u5f15\u304d\u7b97\u3057\u3066\u751f\u5e74\u3092\u7b97\u51fa\u3059\u308b\uff0e<\/p>\n<p>\u3000\u30c6\u30ad\u30b9\u30c8\u30d5\u30a1\u30a4\u30eb\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3057\u3066 SQL Server \u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\uff0e\u30d5\u30a1\u30a4\u30eb\u672b\u5c3e\u306b\u4f59\u8a08\u306a\u7a7a\u884c\u304c\u3042\u308b\u305f\u3081\u30e1\u30e2\u5e33\u3067\u524a\u9664\u3057\u3066\u304a\u304f\uff0e<\/p>\n<figure id=\"attachment_10279\" aria-describedby=\"caption-attachment-10279\" style=\"width: 634px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/130.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10279\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/130.png\" alt=\"\u30a4\u30f3\u30dd\u30fc\u30c8\u306b\u6210\u529f\u3057\u305f\" width=\"634\" height=\"556\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/130.png 634w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/130-300x263.png 300w\" sizes=\"auto, (max-width: 634px) 100vw, 634px\" \/><\/a><figcaption id=\"caption-attachment-10279\" class=\"wp-caption-text\">\u30a4\u30f3\u30dd\u30fc\u30c8\u306b\u6210\u529f\u3057\u305f<\/figcaption><\/figure>\n<p>\u3000\u4ee5\u4e0b\u306e\u30af\u30a8\u30ea\u3092\u5b9f\u884c\u3057\u3066\u7d50\u679c\u3092\u78ba\u8a8d\u3059\u308b\uff0e<\/p>\n<pre>DROP\tTABLE IF EXISTS #SERIES;\nCREATE\tTABLE #SERIES(BIRTHYEAR INT NOT NULL);\nINSERT\tINTO #SERIES VALUES (1835),\n(1840),\n(1845),\n(1850),\n(1855),\n(1860),\n(1865),\n(1870),\n(1875),\n(1880),\n(1885),\n(1890),\n(1895),\n(1900),\n(1905),\n(1910),\n(1915),\n(1920),\n(1925),\n(1930),\n(1935),\n(1940),\n(1945),\n(1950),\n(1955),\n(1960),\n(1965),\n(1970),\n(1975),\n(1980),\n(1985),\n(1990),\n(1995),\n(2000),\n(2005);\n\nDROP\tTABLE IF EXISTS #FISCALYEAR;\nCREATE\tTABLE #FISCALYEAR(FISCALYEAR INT NOT NULL);\nINSERT\tINTO #FISCALYEAR VALUES(1920),\n(1925),\n(1930),\n(1935),\n(1940),\n(1945),\n(1950),\n(1955),\n(1960),\n(1965),\n(1970),\n(1975),\n(1980),\n(1985),\n(1990),\n(1995),\n(2000),\n(2005);\n\nWITH CTE(BirhtYear, FiscalYear)\nAS(SELECT\t* \nFROM\t#SERIES\nCROSS\tJOIN #FISCALYEAR)\n\nSELECT\t* \nFROM\tCTE\nFULL\tJOIN\tdbo.T_Population_1920_2005\nON\t\tCTE.BirhtYear = dbo.T_Population_1920_2005.BirthYear\nAND\t\tCTE.FiscalYear = dbo.T_Population_1920_2005.FiscalYear\nORDER\tBY CTE.BirhtYear, CTE.FiscalYear;\n\nDROP\tTABLE IF EXISTS #SERIES;\nDROP\tTABLE IF EXISTS #FISCALYEAR;<\/pre>\n<pre>(35 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n\n(18 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)\n\n(630 \u884c\u51e6\u7406\u3055\u308c\u307e\u3057\u305f)<\/pre>\n<p>\u3000\u7d50\u679c\u3092\u300c\u30d8\u30c3\u30c0\u30fc\u4ed8\u304d\u3067\u30b3\u30d4\u30fc\u300d\u3057\u3066 EXCEL \u306b\u8cbc\u308a\u4ed8\u3051\uff0c\u30c6\u30fc\u30d6\u30eb\u306b\u5909\u63db\u3059\u308b\uff0e\u5927\u91cf\u306e NULL \u304c\u898b\u3048\u308b\u304c\uff0c\u300c\u691c\u7d22\u3068\u7f6e\u63db\u300d\u3067 0 \u306b\u4e00\u62ec\u7f6e\u63db\u3057\u3066\u304a\u3053\u3046\uff0e<\/p>\n<figure id=\"attachment_10291\" aria-describedby=\"caption-attachment-10291\" style=\"width: 202px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/131.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10291\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/131.png\" alt=\"NULL\u30920\u306b\u7f6e\u63db\" width=\"202\" height=\"124\"><\/a><figcaption id=\"caption-attachment-10291\" class=\"wp-caption-text\">NULL\u30920\u306b\u7f6e\u63db<\/figcaption><\/figure>\n<p>\u3000\u4e0b\u56f3\u306b\u3042\u308b\u3088\u3046\u306b\uff0c\u3088\u304f\u898b\u308b\u3068 C \u5217\uff0cD \u5217\uff0cE \u5217\u306f\u4e0d\u8981\u3060\uff0e\u524a\u9664\u3059\u308b\uff0e<\/p>\n<figure id=\"attachment_10290\" aria-describedby=\"caption-attachment-10290\" style=\"width: 756px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/132.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10290\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/132.png\" alt=\"\u4e0d\u8981\u306aC, D, E \u5217\u3092\u524a\u9664\u3059\u308b\" width=\"756\" height=\"203\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/132.png 756w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/132-300x81.png 300w\" sizes=\"auto, (max-width: 706px) 89vw, (max-width: 767px) 82vw, 740px\" \/><\/a><figcaption id=\"caption-attachment-10290\" class=\"wp-caption-text\">\u4e0d\u8981\u306aC, D, E \u5217\u3092\u524a\u9664\u3059\u308b<\/figcaption><\/figure>\n<h4>\u307e\u305a\u5e74\u5ea6\u3092\u6607\u9806\u30bd\u30fc\u30c8\uff0c\u3064\u3044\u3067\u751f\u5e74\u3092\u964d\u9806\u30bd\u30fc\u30c8<\/h4>\n<p>\u3000\u30b0\u30e9\u30d5\u3092\u4f5c\u6210\u3059\u308b\u524d\u306b\u30c6\u30fc\u30d6\u30eb\u3092\u30bd\u30fc\u30c8\u3059\u308b\u306e\u3060\u304c\uff0c\u9806\u756a\u304c\u3042\u308b\uff0e\u307e\u305a\u300c\u5e74\u5ea6\u300d\u3092\u6607\u9806\u30bd\u30fc\u30c8\uff0c\u3064\u3044\u3067\u300c\u751f\u5e74\u300d\u3092\u964d\u9806\u30bd\u30fc\u30c8\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u5e74\u5ea6\u306f\u6a2a\u8ef8\u306e\u4e26\u3076\u9806\u5e8f\u3092\u6c7a\u3081\u308b\u3082\u306e\u3067\u3042\u308a\uff0c\u751f\u5e74\u306f\u30c7\u30fc\u30bf\u7cfb\u5217\u306e PlotOrder \u3092\u6c7a\u3081\u308b\u3082\u306e\u3067\u3042\u308b\uff0eEXCEL \u306e\u4ed5\u69d8\u306b\u5408\u308f\u305b\u3066\u3044\u308b\uff0e<\/p>\n<figure id=\"attachment_10297\" aria-describedby=\"caption-attachment-10297\" style=\"width: 217px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/133.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10297\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/133.png\" alt=\"\u307e\u305a\u300c\u5e74\u5ea6\u300d\u3067\u6607\u9806\u30bd\u30fc\u30c8\" width=\"217\" height=\"137\"><\/a><figcaption id=\"caption-attachment-10297\" class=\"wp-caption-text\">\u307e\u305a\u300c\u5e74\u5ea6\u300d\u3067\u6607\u9806\u30bd\u30fc\u30c8<\/figcaption><\/figure>\n<figure id=\"attachment_10298\" aria-describedby=\"caption-attachment-10298\" style=\"width: 220px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/134.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10298\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/01\/134.png\" alt=\"\u6b21\u306b\u300c\u751f\u5e74\u300d\u3067\u964d\u9806\u30bd\u30fc\u30c8\" width=\"220\" height=\"109\"><\/a><figcaption id=\"caption-attachment-10298\" class=\"wp-caption-text\">\u6b21\u306b\u300c\u751f\u5e74\u300d\u3067\u964d\u9806\u30bd\u30fc\u30c8<\/figcaption><\/figure>\n<p>\u3000\u5f8c\u306e\u884c\u7a0b\u3067\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u304b\u3051\u305f\u969b\u306b\u51e6\u7406\u304c\u697d\u306b\u306a\u308b\uff0e\u5fc5\u305a\u3084\u3063\u3066\u304a\u3053\u3046\uff0e\u3053\u308c\u3067\u30b0\u30e9\u30d5\u4f5c\u6210\u306e\u6e96\u5099\u304c\u5b8c\u4e86\u3057\u305f\uff0e<\/p>\n<h2>EXCEL \u306b\u3088\u308b\u30b0\u30e9\u30d5\u4f5c\u6210<\/h2>\n<p>\u3000\u30c7\u30fc\u30bf\u7cfb\u5217\u304c\u591a\u3044\u305f\u3081 VBA \u3067\u30b0\u30e9\u30d5\u3092\u4f5c\u6210\u3059\u308b\uff0e\u305d\u306e\u969b\u306e\u57fa\u672c\u65b9\u91dd\u3092\u8ff0\u3079\u3066\u304a\u304f\uff0e<\/p>\n<h3>\u57fa\u672c\u65b9\u91dd<\/h3>\n<h4>\u30b0\u30e9\u30d5\u30bf\u30a4\u30d7\u306f\u7a4d\u307f\u4e0a\u3052\u68d2\u30b0\u30e9\u30d5<\/h4>\n<p>\u3000\u65e5\u672c\u306e\u4eba\u53e3\u3092\uff15\u6b73\u306e\u751f\u5e74\u3054\u3068\u306b\u5857\u308a\u5206\u3051\u305f\u3044\uff0e\u5b9f\u6570\u3092\u8868\u73fe\u3059\u308b\u306e\u3067\u3042\u308b\u304b\u3089\u7a4d\u307f\u4e0a\u3052\u68d2\u30b0\u30e9\u30d5\u304c\u6700\u9069\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u7dcf\u6570\u306a\u3089\u7a4d\u307f\u4e0a\u3052\u7e26\u68d2\u30b0\u30e9\u30d5\uff0c\u7537\u5973\u5225\u306a\u3089\u7a4d\u307f\u4e0a\u3052\u6a2a\u68d2\u30b0\u30e9\u30d5\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u5f8c\u3067\u8abf\u3079\u3066\u5206\u304b\u3063\u305f\u306e\u3060\u304c\uff0cEXCEL \u3067\u306f\u7a4d\u307f\u4e0a\u3052\u30b0\u30e9\u30d5\u3068\u96c6\u5408\u30b0\u30e9\u30d5\u306e\u7d44\u307f\u5408\u308f\u305b\u306f\u76f8\u6027\u304c\u975e\u5e38\u306b\u60aa\u304f\uff0c\u4e21\u8005\u306e\u7d44\u307f\u5408\u308f\u305b\u3092\u4e00\u3064\u306e\u30b0\u30e9\u30d5\u3067\u8868\u73fe\u3059\u308b\u306b\u306f\u30c6\u30fc\u30d6\u30eb\u306e\u69cb\u9020\u3092\u5b8c\u5168\u306b\u7834\u58ca\u3057\u306a\u3051\u308c\u3070\u306a\u3089\u305a\uff0c\u30c7\u30fc\u30bf\u306e\u53ef\u9006\u6027\u304c\u5931\u308f\u308c\u308b\uff0eEXCEL \u306e\u9650\u754c\u3067\u3042\u308b\uff0e<\/p>\n<h4>\u30c7\u30fc\u30bf\u7cfb\u5217\u306e\u8ffd\u52a0<\/h4>\n<p>\u3000\u3053\u308c\u307e\u3067\u3082\u8ff0\u3079\u3066\u304d\u305f\u3088\u3046\u306b\uff0c\u30c6\u30fc\u30d6\u30eb\u306b\u751f\u5e74\u3067\u30d5\u30a3\u30eb\u30bf\u30fc\u3092\u304b\u3051\uff0c\u62bd\u51fa\u3055\u308c\u305f\u884c\u3092\u4e00\u3064\u306e\u30c7\u30fc\u30bf\u7cfb\u5217\u3068\u3057\u3066\u8ffd\u52a0\u3059\u308b\uff0e\u305d\u308c\u3092\u30eb\u30fc\u30d7\u3059\u308b\uff0e<\/p>\n<p>\u3000\u30eb\u30fc\u30d7\u30ab\u30a6\u30f3\u30bf\u30fc\u306f 2005 \u304b\u3089\u958b\u59cb\u3057\uff0c1935 \u3067\u7d42\u308f\u308a\uff0c5 \u305a\u3064\u6e1b\u7b97\u3059\u308b\uff0e<\/p>\n<h3>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30c6\u30fc\u30de\u30ab\u30e9\u30fc\u306e\u6307\u5b9a<\/h3>\n<h4>\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30c6\u30fc\u30de\u30ab\u30e9\u30fc\u306f 60 \u8272<\/h4>\n<p>\u3000EXCEL \u306e<a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=8955\" target=\"_blank\" rel=\"noopener noreferrer\">\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u30c6\u30fc\u30de\u30ab\u30e9\u30fc<\/a>\u306f\u5168\u90e8\u3067 60 \u8272\u3042\u308b\uff0e\u4eca\u56de\u6271\u3046\u30c7\u30fc\u30bf\u7cfb\u5217\u6570\u306f 35 \u3067\u3042\u308b\uff0e\u5168\u90e8\u306e\u8272\u3092\u4f7f\u3044\u5207\u308b\u3053\u3068\u306f\u306a\u3044\u306f\u305a\u3060\u304c\uff0c\u65e2\u306b\u6b7b\u4ea1\u3057\u3066\u3044\u306a\u304f\u306a\u3063\u305f\u904e\u53bb\u4e16\u4ee3\u306e\u968e\u7d1a\u306f\u30b0\u30ec\u30fc\u306e\u30b0\u30e9\u30c7\u30fc\u30b7\u30e7\u30f3\u3068\u3057\u305f\u3044\uff0e<\/p>\n<p>\u30002005 \u5e74\u6642\u70b9\u3067\u3044\u306a\u304f\u306a\u3063\u305f\u968e\u7d1a\u306f 1915 \u5e74\u751f\u307e\u308c\u4ee5\u524d\u3067\u3042\u308b\uff0e\u3068\u3044\u3046\u304b\uff0c1920 \u5e74\u304b\u3089\u8abf\u67fb\u304c\u59cb\u307e\u3063\u305f\u306e\u3060\u304b\u3089\u5f53\u7136\u3068\u3044\u3048\u3070\u5f53\u7136\u3060\uff0e<\/p>\n<p>\u3000\u3069\u3053\u307e\u3067\u30b0\u30ec\u30fc\u3068\u3057\uff0c\u3069\u3053\u304b\u3089\u30ab\u30e9\u30fc\u306b\u3059\u308b\u304b\u306f\u30b0\u30e9\u30d5\u3092\u4f5c\u308a\u306a\u304c\u3089\u8003\u3048\u3088\u3046\uff0e\u307e\u305a\u306f\u624b\u3092\u52d5\u304b\u3059\u3053\u3068\u3060\uff0e<\/p>\n<figure id=\"attachment_8958\" aria-describedby=\"caption-attachment-8958\" style=\"width: 173px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/00-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-8958\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2019\/11\/00-1.png\" alt=\"EXCEL\u306e\u30c6\u30fc\u30de\u30ab\u30e9\u30fc\" width=\"173\" height=\"273\"><\/a><figcaption id=\"caption-attachment-8958\" class=\"wp-caption-text\">EXCEL\u306e\u30c6\u30fc\u30de\u30ab\u30e9\u30fc<\/figcaption><\/figure>\n<p>\u3000\u4e0a\u56f3\u3092\u898b\u308b\u3068\uff0c\u30b0\u30ec\u30fc\u306e\u7cfb\u7d71\u306f 4 \u3064\uff0c\u9752\u306e\u7cfb\u7d71\u306f 3 \u3064\u3042\u308b\uff0e\u91cd\u8907\u3068\u3057\u3066\u8003\u3048\u308b\u3068\u5b9f\u969b\u306b\u4f7f\u7528\u3067\u304d\u308b\u8272\u306f 5 \u7cfb\u7d71 25 \u8272\u3067\u3042\u308b\uff0e\u610f\u5916\u306b\u5c11\u306a\u3044\uff0e<\/p>\n<h4>25 \u5e74\u5468\u671f\u3068\u3059\u308b\u306e\u304c\u5408\u7406\u7684<\/h4>\n<p>\u3000\u96a3\u63a5\u3059\u308b\u5e74\u9f62\u968e\u7d1a\u306f\u540c\u7cfb\u7d71\u306e\u30b0\u30e9\u30c7\u30fc\u30b7\u30e7\u30f3\u3068\u3057\u305f\u3044\uff0e4 \u8272\u3067 20 \u5e74\uff0c5 \u8272\u3067 25 \u5e74\u3060\u304b\u3089\uff0c\u8a08\u7b97\u4e0a\u306f 1 \u7cfb\u7d71 4 \u8272\u3067\u3082\u9593\u306b\u5408\u3046\uff0e\u3057\u304b\u3057\uff0c\u30c7\u30fc\u30bf\u306e\u7279\u5fb4\u3092\u3088\u304f\u898b\u308b\u3068\uff0c1 \u7cfb\u7d71 5 \u8272 25 \u5e74\u5468\u671f\u3068\u3059\u308b\u306e\u304c\u5408\u7406\u7684\u3068\u601d\u308f\u308c\u308b\uff0e<\/p>\n<ul>\n<li>2000 \u5e74\u751f\u307e\u308c\u4ee5\u964d\u3092\u9752\u306e\u7cfb\u7d71 2 \u8272<\/li>\n<li>1975 \u5e74\u751f\u307e\u308c\u4ee5\u964d\u3092\u7dd1\u306e\u7cfb\u7d71 5 \u8272<\/li>\n<li>1950 \u5e74\u751f\u307e\u308c\u4ee5\u964d\u3092\u30b4\u30fc\u30eb\u30c9\u306e\u7cfb\u7d71 5 \u8272<\/li>\n<li>1925 \u5e74\u751f\u307e\u308c\u4ee5\u964d\u3092\u30aa\u30ec\u30f3\u30b8\u306e\u7cfb\u7d71 5 \u8272<\/li>\n<li>\u305d\u308c\u4ee5\u524d\u306f\u767d\u306e\u7cfb\u7d71 5 \u8272\u306e\u5faa\u74b0<\/li>\n<\/ul>\n<p>\u3000\u7406\u7531\u306f\u4e0d\u660e\u3060\u304c\uff0cEXCEL \u306b\u3088\u308b\u8272\u6307\u5b9a\u3068 html \u3067\u306e\u8272\u6307\u5b9a\u304c\u4e00\u81f4\u3057\u306a\u3044\uff0e\u3053\u306e\u539f\u56e0\u306b\u3064\u3044\u3066\u8ffd\u6c42\u3059\u308b\u306e\u306f\u307e\u305f\u5225\u306e\u6a5f\u4f1a\u306b\u3057\u3088\u3046\uff0e<\/p>\n<h3>\u30b3\u30fc\u30c9\u306e\u5b9f\u969b<\/h3>\n<pre class=\"\">Option Explicit\n\nSub PopulationChart()\n\nDim mySht1      As Worksheet\nDim mySht2      As Worksheet\nDim myLstObj    As ListObject\nDim myCht       As Chart\n\nSet mySht1 = Worksheets(\"Sheet3\")\nSet myLstObj = mySht1.ListObjects(1)\nSet mySht2 = Worksheets.Add(after:=mySht1)\nSet myCht = mySht2.Shapes.AddChart2(Style:=-1, _\n                              XlChartType:=xlColumnStacked, _\n                                     Left:=0, _\n                                      Top:=0, _\n                                    Width:=400, _\n                                   Height:=400).Chart\n\nDim i           As Long\nDim j           As Long\nDim myRng1      As Range\n\nDim FiscalYear()    As Long\nDim Population()    As Long\n\nDim mySeries    As Series\n\nFor i = 2005 To 1835 Step -5\n    With myLstObj\n        .Range.AutoFilter field:=1, Criteria1:=i\n        Set myRng1 = Intersect(.DataBodyRange, _\n                               .Range.SpecialCells(Type:=xlCellTypeVisible))\n        If myRng1 Is Nothing Then\n        Else\n            For j = 0 To myRng1.Rows.Count - 1\n                ReDim Preserve FiscalYear(j)\n                ReDim Preserve Population(j)\n                FiscalYear(j) = myRng1.Cells(j + 1, 2)\n                Population(j) = myRng1.Cells(j + 1, 3)\n            Next j\n            Set mySeries = myCht.SeriesCollection.NewSeries\n            With mySeries\n                .Name = i\n                .XValues = FiscalYear\n                .Values = Population\n            End With\n        End If\n        .Range.AutoFilter field:=1\n    End With\nNext i\n\nDim myAxis      As Axis\nDim myChtGrp    As ChartGroup\n\nWith myCht\n    With .ChartTitle\n        .Caption = \"\u65e5\u672c\u4eba\u53e3\u306e\u5e74\u9f62\u968e\u7d1a\u63a8\u79fb\"\n        .Left = 0\n    End With\n    Set myAxis = .Axes(xlCategory)\n    With myAxis\n        .Format.Line.Visible = msoFalse\n        .MajorGridlines.Format.Line.Visible = msoFalse\n    End With\n    Set myAxis = .Axes(xlValue)\n    With myAxis\n        .DisplayUnit = xlTenThousands\n        .Format.Line.Visible = msoFalse\n        .MaximumScale = 125000000\n        .MajorUnit = .MaximumScale \/ 5\n        .MajorGridlines.Format.Line.Visible = msoFalse\n        With .DisplayUnitLabel\n            .Orientation = xlHorizontal\n        End With\n    End With\n    With .PlotArea\n        .Format.Fill.Visible = msoFalse\n        .Format.Line.Visible = msoFalse\n        .Left = -8\n        .Width = 400\n    End With\n    With .ChartArea\n        .Format.Fill.ForeColor.ObjectThemeColor = msoThemeColorBackground1\n        .Format.TextFrame2.TextRange.Font.Name = \"TimesNewRoman\"\n    End With\n    Set myChtGrp = .ChartGroups(1)\n    With myChtGrp\n        .GapWidth = 0\n    End With\n    For Each mySeries In .SeriesCollection\n        With mySeries\n            Debug.Print .Format.Fill.ForeColor.RGB\n            Select Case .Name\n            Case \"2005\"\n                .Format.Fill.ForeColor.RGB = RGB(47, 85, 151)\n            Case \"2000\"\n                .Format.Fill.ForeColor.RGB = RGB(32, 56, 100)\n            Case \"1995\"\n                .Format.Fill.ForeColor.RGB = RGB(226, 240, 217)\n            Case \"1990\"\n                .Format.Fill.ForeColor.RGB = RGB(197, 224, 180)\n            Case \"1985\"\n                .Format.Fill.ForeColor.RGB = RGB(169, 209, 142)\n            Case \"1980\"\n                .Format.Fill.ForeColor.RGB = RGB(84, 130, 53)\n            Case \"1975\"\n                .Format.Fill.ForeColor.RGB = RGB(56, 87, 35)\n            Case \"1970\"\n                .Format.Fill.ForeColor.RGB = RGB(255, 242, 204)\n            Case \"1965\"\n                .Format.Fill.ForeColor.RGB = RGB(255, 230, 153)\n            Case \"1960\"\n                .Format.Fill.ForeColor.RGB = RGB(255, 217, 102)\n            Case \"1955\"\n                .Format.Fill.ForeColor.RGB = RGB(191, 144, 0)\n            Case \"1950\"\n                .Format.Fill.ForeColor.RGB = RGB(127, 96, 0)\n            Case \"1945\"\n                .Format.Fill.ForeColor.RGB = RGB(251, 229, 214)\n            Case \"1940\"\n                .Format.Fill.ForeColor.RGB = RGB(248, 203, 173)\n            Case \"1935\"\n                .Format.Fill.ForeColor.RGB = RGB(244, 177, 131)\n            Case \"1930\"\n                .Format.Fill.ForeColor.RGB = RGB(197, 90, 17)\n            Case \"1925\"\n                .Format.Fill.ForeColor.RGB = RGB(132, 60, 12)\n            Case \"1920\"\n                .Format.Fill.ForeColor.RGB = RGB(242, 242, 242)\n            Case \"1915\"\n                .Format.Fill.ForeColor.RGB = RGB(217, 217, 217)\n            Case \"1910\"\n                .Format.Fill.ForeColor.RGB = RGB(191, 191, 191)\n            Case \"1905\"\n                .Format.Fill.ForeColor.RGB = RGB(166, 166, 166)\n            Case \"1900\"\n                .Format.Fill.ForeColor.RGB = RGB(127, 127, 127)\n            Case \"1895\"\n                .Format.Fill.ForeColor.RGB = RGB(242, 242, 242)\n            Case \"1890\"\n                .Format.Fill.ForeColor.RGB = RGB(217, 217, 217)\n            Case \"1885\"\n                .Format.Fill.ForeColor.RGB = RGB(191, 191, 191)\n            Case \"1880\"\n                .Format.Fill.ForeColor.RGB = RGB(166, 166, 166)\n            Case \"1875\"\n                .Format.Fill.ForeColor.RGB = RGB(127, 127, 127)\n            Case \"1870\"\n                .Format.Fill.ForeColor.RGB = RGB(242, 242, 242)\n            Case \"1865\"\n                .Format.Fill.ForeColor.RGB = RGB(217, 217, 217)\n            Case \"1860\"\n                .Format.Fill.ForeColor.RGB = RGB(191, 191, 191)\n            Case \"1855\"\n                .Format.Fill.ForeColor.RGB = RGB(166, 166, 166)\n            Case \"1850\"\n                .Format.Fill.ForeColor.RGB = RGB(127, 127, 127)\n            Case \"1845\"\n                .Format.Fill.ForeColor.RGB = RGB(242, 242, 242)\n            Case \"1840\"\n                .Format.Fill.ForeColor.RGB = RGB(217, 217, 217)\n            Case \"1835\"\n                .Format.Fill.ForeColor.RGB = RGB(191, 191, 191)\n            End Select\n        End With\n    Next mySeries\nEnd With\nEnd Sub<\/pre>\n<h2>\u7d50\u679c<\/h2>\n<figure id=\"attachment_10410\" aria-describedby=\"caption-attachment-10410\" style=\"width: 534px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/03\/304.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-10410\" src=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/03\/304.png\" alt=\"\u65e5\u672c\u4eba\u53e3\u306e\u5e74\u9f62\u968e\u7d1a\u63a8\u79fb\uff08\u56fd\u52e2\u8abf\u67fb\u3088\u308a\u7b46\u8005\u4f5c\u6210\uff09\" width=\"534\" height=\"534\" srcset=\"https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/03\/304.png 534w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/03\/304-300x300.png 300w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/03\/304-150x150.png 150w, https:\/\/www.muscle-hypertrophy.com\/wp-content\/uploads\/2020\/03\/304-100x100.png 100w\" sizes=\"auto, (max-width: 534px) 100vw, 534px\" \/><\/a><figcaption id=\"caption-attachment-10410\" class=\"wp-caption-text\">\u65e5\u672c\u4eba\u53e3\u306e\u5e74\u9f62\u968e\u7d1a\u63a8\u79fb\uff08\u56fd\u52e2\u8abf\u67fb\u3088\u308a\u7b46\u8005\u4f5c\u6210\uff09<\/figcaption><\/figure>\n<p>\u30001925 \u5e74\u751f\u307e\u308c\u304c 1945 \u5e74\u8abf\u67fb\u3067\u6025\u6e1b\u3057\u3066\u3044\u308b\uff0e\u3082\u3061\u308d\u3093\u7b2c\uff12\u6b21\u4e16\u754c\u5927\u6226\u304c\u5f71\u97ff\u3057\u3066\u3044\u308b\uff0e<\/p>\n<p>\u3000\u7d9a\u3044\u3066 1950 \u5e74\u751f\u307e\u308c\u304c\u6025\u5897\u3057\u3066\u3044\u308b\uff0e\u3053\u308c\u304c\u56e3\u584a\u4e16\u4ee3\u3067\u3042\u308b\uff0e25 \u5e74\u5f8c\u306e 1975 \u5e74\u751f\u307e\u308c\uff0c\u3053\u308c\u304c\u56e3\u584a\u30b8\u30e5\u30cb\u30a2\u4e16\u4ee3\u3067\u3042\u308b\uff0e<\/p>\n<p>\u3000\u3053\u306e\u30b5\u30a4\u30af\u30eb\u3067\u884c\u3051\u3070 2000 \u5e74\u9803\u306b\u7b2c\uff13\u6b21\u30d9\u30d3\u30fc\u30d6\u30fc\u30e0\u304c\u6765\u308b\u306f\u305a\u3060\u3063\u305f\uff0e\u3057\u304b\u3057\u5b9f\u969b\u306b\u306f\u5c11\u5b50\u5316\u304c\u9032\u884c\u3057\u3066\u304a\u308a\uff0c\u3053\u306e\u6642\u70b9\u3067\u65e5\u672c\u306e\u5c06\u6765\u306f\u307b\u307c\u6c7a\u307e\u3063\u305f\uff0e<\/p>\n<p>\u3000\u8981\u56e0\u306f\u69d8\u3005\u306a\u3053\u3068\u304c\u8a00\u308f\u308c\u3066\u3044\u308b\uff0e\u5c11\u5b50\u5316\u5bfe\u7b56\u306f\u3082\u3061\u308d\u3093\u5fc5\u8981\u3060\uff0e\u3060\u304c\uff0c\u305d\u308d\u305d\u308d\u300c\u4e0d\u90fd\u5408\u306a\u771f\u5b9f\u300d\u304b\u3089\u76ee\u3092\u80cc\u3051\u308b\u306e\u3067\u306f\u306a\u304f\uff0c\u6b63\u9762\u304b\u3089\u5411\u304d\u5408\u3046\u65b9\u5411\u306b\u8235\u3092\u5207\u308b\u3079\u304d\u3060\uff0e<\/p>\n<a href=\"https:\/\/www.amazon.co.jp\/gp\/product\/4062884364\/ref=as_li_ss_il?ie=UTF8&amp;psc=1&amp;linkCode=li3&amp;tag=gwho-22&amp;linkId=c2d637af1dfe26a95b12162ec0c2e676&amp;language=ja_JP\" target=\"_blank\" rel=\"noopener noreferrer\"><img decoding=\"async\" border=\"0\" src=\"\/\/ws-fe.amazon-adsystem.com\/widgets\/q?_encoding=UTF8&amp;ASIN=4062884364&amp;Format=_SL250_&amp;ID=AsinImage&amp;MarketPlace=JP&amp;ServiceVersion=20070822&amp;WS=1&amp;tag=gwho-22&amp;language=ja_JP\"><\/a><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/ir-jp.amazon-adsystem.com\/e\/ir?t=gwho-22&amp;language=ja_JP&amp;l=li3&amp;o=9&amp;a=4062884364\" width=\"1\" height=\"1\" border=\"0\" alt=\"\" style=\"border:none !important; margin:0px !important;\">\n","protected":false},"excerpt":{"rendered":"<p>\u3000\u4eba\u53e3\u7d71\u8a08\u306f\u6700\u3082\u91cd\u8981\u306a\u57fa\u5e79\u7d71\u8a08\u306e\u4e00\u3064\u3067\u3042\u308b\uff0e\u7dcf\u52d9\u7701\u306e e-Stat \u306f\u78ba\u304b\u306b\u6709\u7528\u3067\u3042\u308b\u304c\uff0c\u304b\u3086\u3044\u3068\u3053\u308d\u306b\u624b\u304c\u5c4a\u304b\u306a\u3044\uff0e\u4f8b\u3048\u3070\u300c\u5e02\u533a\u753a\u6751\u3054\u3068\uff0c\u5e74\u9f62\uff15\u6b73\u968e\u7d1a\u3054\u3068\u306e\u4eba\u53e3\u69cb\u6210\u306e\u56fd\u52e2\u8abf\u67fb\u3054\u3068\u306e\u63a8\u79fb\u3092\u77e5\u308a\u305f\u3044\u300d\u3068\u3044\u3046\u8981\u6c42\u306b\u306f\u5168\u304f\u7121\u529b &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.muscle-hypertrophy.com\/?p=10199\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;\u56fd\u52e2\u8abf\u67fb\u304b\u3089\uff15\u6b73\u968e\u7d1a\u306e\u4eba\u53e3\u63a8\u79fb\u3092\u8abf\u3079\u308b&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":10410,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[5649,4580,5645,4592,5602,4566,5641,4567,4601,6748,5436,4542,4998,6735,5475,4525,5004,6769,5488,4738,5463,6749,4689,6734,4997,6766,6770,6741,4521,265,6742,5462,6747,4991,4892,4883,4673,6750,6772,5428,1407,3333,6745,6743,5120,6746,5413,4884,5435,6737,6738,2474,5017,5487,5018,5631,4905,4906,4908,4910,4901,4900,4528,6744,5468,467,4899,4634,4674,4652,4541,4530,5484,5543,5470,4672,4561,4585,4600,5121,259,2740,5424,5292,4989,4990,5656,5415,6768,459,5427,4658,4523,6767,4543,5464,5425,6456,6771,5646,4544,2861,6739,5542,6761,6755,6760,6730,2684,462,2867,32,4516,2911,1669,5362,4593,5447,5202,663,6740,6776,5176,6728,4442,6833,6309,4443,6731,6727,6732,1214,6775,4440,5163,865,6602,1794,6751,6753,362,2781,5063,6764,6752,6759,6765,6733,1312,5590,6736,6831,1040,6757,6758,6773,6774,4025,6729,821,6756,6763,5457,4439,828,6754,963,6832,6762,6725],"class_list":["post-10199","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","tag-caption","tag-count","tag-displayunit","tag-newseries","tag-plotorder","tag-values","tag-visible","tag-xvalues","tag-addchart2","tag-as","tag-autofilter","tag-axes","tag-axis","tag-birthyear","tag-cells","tag-chart","tag-chartarea","tag-chartgroup","tag-charttitle","tag-create","tag-criteria1","tag-cross-join","tag-databodyrange","tag-datediff","tag-debug-print","tag-dim","tag-displayunitlabel","tag-drop","tag-e-stat","tag-excel","tag-exists","tag-field","tag-fiscalyear","tag-font","tag-forecolor","tag-format","tag-from","tag-full-join","tag-gapwidth","tag-height","tag-html","tag-if","tag-insert","tag-int","tag-intersect","tag-into","tag-left","tag-line","tag-listobject","tag-listrows","tag-listrows-add","tag-long","tag-majorgridlines","tag-majorunit","tag-maximumscale","tag-msofalse","tag-msothemecoloraccent1","tag-msothemecoloraccent2","tag-msothemecoloraccent4","tag-msothemecoloraccent6","tag-msothemecolorbackground1","tag-msothemecolorindex","tag-name","tag-not-null","tag-nothing","tag-null","tag-objectthemecolor","tag-option-explicit","tag-order-by","tag-orientation","tag-plotarea","tag-range","tag-redim-preserve","tag-rgb","tag-rows","tag-select","tag-series","tag-seriescollection","tag-shapes","tag-specialcells","tag-sql","tag-sql-server","tag-style","tag-table","tag-textframe2","tag-textrange","tag-timesnewroman","tag-top","tag-type","tag-vba","tag-width","tag-with","tag-worksheet","tag-worksheets-add","tag-xlcategory","tag-xlcelltypevisible","tag-xlcharttype","tag-xlcolumnstacked","tag-xlhorizontal","tag-xltenthousands","tag-xlvalue","tag-2861","tag-6739","tag-5542","tag-6761","tag-6755","tag-6760","tag-6730","tag-2684","tag-462","tag-2867","tag-32","tag-4516","tag-2911","tag-1669","tag-5362","tag-4593","tag-5447","tag-5202","tag-663","tag-6740","tag-6776","tag-5176","tag-6728","tag-4442","tag-6833","tag-6309","tag-4443","tag-6731","tag-6727","tag-6732","tag-1214","tag-6775","tag-4440","tag-5163","tag-865","tag-6602","tag-1794","tag-6751","tag-6753","tag-362","tag-2781","tag-5063","tag-6764","tag-6752","tag-6759","tag-6765","tag-6733","tag-1312","tag-5590","tag-6736","tag-6831","tag-1040","tag-6757","tag-6758","tag-6773","tag-6774","tag-4025","tag-6729","tag-821","tag-6756","tag-6763","tag-5457","tag-4439","tag-828","tag-6754","tag-963","tag-6832","tag-6762","tag-6725"],"_links":{"self":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/10199","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10199"}],"version-history":[{"count":167,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/10199\/revisions"}],"predecessor-version":[{"id":10458,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/posts\/10199\/revisions\/10458"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=\/wp\/v2\/media\/10410"}],"wp:attachment":[{"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10199"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10199"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.muscle-hypertrophy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10199"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}