{"id":215,"date":"2019-06-24T15:51:21","date_gmt":"2019-06-24T06:51:21","guid":{"rendered":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/?p=215"},"modified":"2019-07-01T15:51:48","modified_gmt":"2019-07-01T06:51:48","slug":"%e3%80%90%e9%80%9f%e5%a0%b1%e3%80%91libreoffice-calc%e3%81%ab%e3%83%95%e3%83%bc%e3%83%aa%e3%82%a8%e8%a7%a3%e6%9e%90%e3%81%8c%e5%ae%9f%e8%a3%85%e3%81%95%e3%82%8c%e3%81%9f","status":"publish","type":"post","link":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/215\/","title":{"rendered":"\u3010\u901f\u5831\u3011LibreOffice Calc\u306b\u30d5\u30fc\u30ea\u30a8\u89e3\u6790\u304c\u5b9f\u88c5\u3055\u308c\u305f"},"content":{"rendered":"<p><a href=\"https:\/\/www.libreoffice.org\/\" rel=\"noopener noreferrer\" target=\"_blank\">LibreOffice<\/a>\u306e6.3\u3067\u306f\uff0cLibreOffice Calc\u306b\u30d5\u30fc\u30ea\u30a8\u89e3\u6790\uff08\u96e2\u6563\u30d5\u30fc\u30ea\u30a8\u5909\u63db\uff09\u304c\u5b9f\u88c5\u3055\u308c\u307e\u3057\u305f\uff0e<\/p>\n<p><!--more--><\/p>\n<p>MSExcel\uff082013\u3092\u6307\u3059\uff1b\u4ee5\u4e0b\u540c\u3058\uff09\u306b\u306f\u4ee5\u524d\u304b\u3089\u30d5\u30fc\u30ea\u30a8\u89e3\u6790\u306e\u6a5f\u80fd\u304c\u3042\u308a\u307e\u3057\u305f\u304c\uff0cLibreOffice Calc\u306b\u306f\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f\uff0eLibreOffice\u6d3e\u306e\u79c1\u3068\u3057\u3066\u306f\u305d\u308c\u304c\u3061\u3087\u3063\u3068\u6b8b\u5ff5\u3067\u3057\u305f\uff0e\u3068\u3053\u308d\u304c\uff0cLibreOffice\u306e6.3\u3067\u3064\u3044\u306b\u30d5\u30fc\u30ea\u30a8\u89e3\u6790\u304c\u5b9f\u88c5\u3055\u308c\u308b\u3053\u3068\u306b\u306a\u3063\u305f\u306e\u3067\u3059\uff08<a href=\"https:\/\/wiki.documentfoundation.org\/ReleaseNotes\/6.3\/ja#FOURIER.28.29_.E9.96.A2.E6.95.B0\" rel=\"noopener noreferrer\" target=\"_blank\">\u30ea\u30ea\u30fc\u30b9\u30ce\u30fc\u30c8<\/a>\uff09\uff0e<\/p>\n<p>6\u670821\u65e5\u6642\u70b9\u3067\u306f\u307e\u3060\u30d9\u30fc\u30bf\u7248\u306e\u6bb5\u968e\u3067\u3059\u304c\uff0c\u3055\u3063\u305d\u304f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u307f\u307e\u3059\uff08\u30d9\u30fc\u30bf\u7248\u306f\u88fd\u54c1\u7248\u3068\u306f\u72ec\u7acb\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3067\u304d\u308b\u3088\u3046\u3067\u3059\uff09\uff0e<\/p>\n<p>LibreCalc\u306b\u304a\u3044\u3066\u306f\uff0c\u96e2\u6563\u30d5\u30fc\u30ea\u30a8\u5909\u63db\uff08<abbr title=\"Discrete Fourier Transform\">DFT<\/abbr>\uff09\u306f\u95a2\u6570\u3068\u3057\u3066\u5b9f\u88c5\u3055\u308c\u3066\u3044\u307e\u3059\uff0e\u3068\u306f\u8a00\u3063\u3066\u3082[\u30c7\u30fc\u30bf]-[\u7d71\u8a08]-[Fourier Analysis]\u3067\u30c0\u30a4\u30a2\u30ed\u30b0\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u306e\u3067\uff0c\u305d\u3061\u3089\u3092\u4f7f\u3046\u306e\u304c\u4fbf\u5229\u3067\u3057\u3087\u3046\uff08\u30e1\u30cb\u30e5\u30fc\u30a2\u30a4\u30c6\u30e0\u3084\u30c0\u30a4\u30a2\u30ed\u30b0\u306f\u305d\u306e\u3046\u3061\u65e5\u672c\u8a9e\u5316\u3055\u308c\u308b\u306f\u305a\u3067\u3059\uff09\uff0e<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-content\/uploads\/sites\/26\/fourier_dialog.png\" alt=\"\u30d5\u30fc\u30ea\u30a8\u89e3\u6790\u306e\u30c0\u30a4\u30a2\u30ed\u30b0\uff0e\u30c7\u30fc\u30bf\uff0c\u7cfb\u5217\uff0c\u30aa\u30d7\u30b7\u30e7\u30f3\uff0e\" width=\"431\" height=\"435\" class=\"alignnone size-full wp-image-218\" srcset=\"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-content\/uploads\/sites\/26\/fourier_dialog.png 431w, https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-content\/uploads\/sites\/26\/fourier_dialog-150x150.png 150w, https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-content\/uploads\/sites\/26\/fourier_dialog-297x300.png 297w\" sizes=\"auto, (max-width: 431px) 100vw, 431px\" \/><\/p>\n<p>\u3068\u308a\u3042\u3048\u305a\u4f55\u3082\u8003\u3048\u305a\u306b\uff0c\u5165\u529b\u30c7\u30fc\u30bf\u7bc4\u56f2\u3068\u51fa\u529b\u5148\u3060\u3051\u3092\u8a2d\u5b9a\u3057\u3066\u51fa\u529b\u3057\u3066\u307f\u307e\u3057\u3087\u3046\uff0e<\/p>\n<figure id=\"attachment_222\" aria-describedby=\"caption-attachment-222\" style=\"width: 548px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-content\/uploads\/sites\/26\/fourier_example_1.png\" alt=\"LibreOffice Calc\u306b\u3088\u308b\u30d5\u30fc\u30ea\u30a8\u5909\u63db\uff0eB\u5217\u306b16\u884c\u306e\u5165\u529b\u30c7\u30fc\u30bf\uff0eE\u5217F\u5217\u306b16\u884c\u306e\u51fa\u529b\u30c7\u30fc\u30bf\uff0e\u305d\u308c\u305e\u308c\u5b9f\u90e8\u3068\u865a\u90e8\uff0e\" width=\"548\" height=\"389\" class=\"size-full wp-image-222\" srcset=\"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-content\/uploads\/sites\/26\/fourier_example_1.png 548w, https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-content\/uploads\/sites\/26\/fourier_example_1-300x213.png 300w\" sizes=\"auto, (max-width: 548px) 100vw, 548px\" \/><figcaption id=\"caption-attachment-222\" class=\"wp-caption-text\">\u30d5\u30fc\u30ea\u30a8\u89e3\u6790\u306e\u4f8b(1)<\/figcaption><\/figure>\n<p>\u306f\u3044\uff0c\u51fa\u3066\u304d\u307e\u3057\u305f\uff0eMSExcel\u3068\u306f\u51fa\u529b\u5f62\u5f0f\u304c\u7570\u306a\u3063\u3066\u3044\u3066\uff0c\u8907\u7d20\u6570\u306e\u5b9f\u90e8\u3068\u865a\u90e8\u306b\u5bfe\u3059\u308b\u5b9f\u6570\u304c\u5225\u306e\u5217\u306b\u51fa\u529b\u3055\u308c\u3066\u3044\u307e\u3059\uff0e\u3053\u308c\u306f\u597d\u304d\u5acc\u3044\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\uff0e\u307e\u305fDFT\u306b\u306f\u4fc2\u6570\u306e\u6d41\u5100\u304c\u3044\u304f\u3064\u304b\u3042\u308a\u307e\u3059\u304c\uff0c\u3053\u3053\u3067\u306f\u5909\u63db\u6642\u306b\u306f\u4fc2\u6570\u304c1\u3067\uff0c\u9006\u5909\u63db\u6642\u306b1\/N\u3092\u4e57\u3058\u308b\u6d41\u5100\u304c\u63a1\u7528\u3055\u308c\u3066\u3044\u307e\u3059\uff0e\u3053\u306e\u70b9\u306fMSExcel\u3068\u540c\u3058\u3067\u3059\uff0e<\/p>\n<p>\u3055\u3089\u306b\uff0c\uff08MSExcel\u306b\u306f\u306a\u3044\uff09\u4ee5\u4e0b\u306e\u6a5f\u80fd\u3082\u5099\u3048\u3089\u308c\u3066\u3044\u307e\u3059\uff0e<\/p>\n<ul>\n<li>MSExcel\u3067\u306f\u30c7\u30fc\u30bf\u6570\u304c2\u306e\u3079\u304d\u4e57\uff08\u304b\u30644096\u4ee5\u4e0b\uff09\u3068\u3044\u3046\u5236\u9650\u304c\u3042\u308a\u307e\u3057\u305f\u304c\uff0cLibreCalc\u3067\u306f\uff082\u3064\u306e\u30a2\u30eb\u30b4\u30ea\u30ba\u30e0\u3092\u5b9f\u88c5\u3057\u3066\u3044\u308b\u306e\u3067\uff09\u305d\u306e\u3088\u3046\u306a\u5236\u9650\u306f\u306a\u3044\u3088\u3046\u3067\u3059\uff0e<\/li>\n<li>\u51fa\u529b\u3092\u6975\u5ea7\u6a19\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\uff0e\u30c0\u30a4\u30a2\u30ed\u30b0\u306e[Output in polar form]\u306b\u30c1\u30a7\u30c3\u30af\u3092\u5165\u308c\u308b\u304b\uff0cFOURIER\u95a2\u6570\u306e4\u756a\u76ee\u306e\u5f15\u6570\u306bTRUE\uff081\uff09\u3092\u8a2d\u5b9a\u3057\u307e\u3059\uff0e<\/li>\n<li>DFT\u306e\u8a08\u7b97\u306b\u304a\u3044\u3066\u306f\uff0c\u672c\u67650\u3067\u3042\u308b\u3079\u304d\u5024\u304c\uff08\u8a08\u7b97\u8aa4\u5dee\u306e\u7a4d\u307f\u91cd\u306d\u306b\u3088\u3063\u3066\uff09\u5c0f\u3055\u306a\u5024\u3092\u3082\u3064\u3053\u3068\u304c\u3042\u308a\u307e\u3059\uff0e\u6975\u5ea7\u6a19\u8868\u793a\u3092\u3055\u305b\u308b\u5834\u5408\u306f\uff0c[Minimum magnitude for polar form output (in dB)]\u306b\u5024\u3092\u8a2d\u5b9a\u3059\u308b\u3053\u3068\u306b\u3088\u3063\u3066\uff0c\u7d76\u5bfe\u5024\u304c\u305d\u308c\u306b\u6e80\u305f\u306a\u3044\u5024\u30920\u306b\u5207\u308a\u6368\u3066\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3059\uff0e\u3053\u3053\u3067\u306edB\u306f\u30d1\u30ef\u30fc\u30b9\u30da\u30af\u30c8\u30eb\uff08\u7d76\u5bfe\u5024\u306e2\u4e57\uff09\u306b\u5bfe\u3059\u308b\u3082\u306e\u3067\u306f\u306a\u304f\u7d76\u5bfe\u5024\u305d\u306e\u3082\u306e\u306b\u5bfe\u3059\u308b\u3082\u306e\u3067\u3059\u306e\u3067\uff0c10\u500d\u304c\uff0820dB\u3067\u306f\u306a\u304f\u3066\uff0910dB\u306b\u306a\u308a\u307e\u3059\uff0e\u305f\u3068\u3048\u3070\u7d76\u5bfe\u50240.001\u672a\u6e80\u3092\u5207\u308a\u6368\u3066\u308b\u306b\u306f\uff0c-30dB\u3068\u5165\u529b\u3057\u307e\u3059\uff0e<\/li>\n<\/ul>\n<p>\u3053\u308c\u3089\u3092\u99c6\u4f7f\u3057\u305f\u4f8b\u3082\u6319\u3052\u3066\u304a\u304d\u307e\u3057\u3087\u3046\uff0e<\/p>\n<figure id=\"attachment_224\" aria-describedby=\"caption-attachment-224\" style=\"width: 614px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-content\/uploads\/sites\/26\/fourier_example_2.png\" alt=\"LibreOffice Calc\u306e\u30d5\u30fc\u30ea\u30a8\u89e3\u6790\uff0eB\u5217\u306b12\u884c\u306e\u5165\u529b\uff0cE\u5217F\u5217\u306b12\u884c\u306e\u51fa\u529b\uff0e\u6975\u5ea7\u6a19\u5f62\u5f0f\uff0e\u6709\u610f\u306a1\u884c\u76ee\uff0c4\u884c\u76ee\uff0c7\u884c\u76ee\uff0c10\u884c\u76ee\u4ee5\u5916\u306e\u51fa\u529b\u306f0\u306b\u5207\u308a\u6368\u3066\u3089\u308c\u3066\u3044\u308b\uff0e\" width=\"614\" height=\"355\" class=\"size-full wp-image-224\" srcset=\"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-content\/uploads\/sites\/26\/fourier_example_2.png 614w, https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-content\/uploads\/sites\/26\/fourier_example_2-300x173.png 300w\" sizes=\"auto, (max-width: 614px) 100vw, 614px\" \/><figcaption id=\"caption-attachment-224\" class=\"wp-caption-text\">\u30d5\u30fc\u30ea\u30a8\u89e3\u6790\u306e\u4f8b(2)<\/figcaption><\/figure>\n<p>\u6700\u5f8c\u306b\u4f59\u8ac7\u3092\u4e00\u3064\uff0eFOURIER\u95a2\u6570\u306e\u51fa\u529b\u306f\uff0c\u884c\u5217\u5f0f\uff08\u6570\u5b66\u306e\u884c\u5217\u5f0f\u3067\u306f\u306a\u3044\uff09\u306b\u306a\u308a\u307e\u3059\uff0e\u305d\u306e\u6271\u3044\u65b9\u3092\u5fd8\u308c\u304c\u3061\u3067\u3059\u306e\u3067\u3064\u3044\u3067\u306b\u30e1\u30e2\u3057\u3066\u304a\u304d\u307e\u3059\uff0e<\/p>\n<ul>\n<li>\u884c\u5217\u5f0f\u5168\u4f53\u3092\u9078\u629e\u3059\u308b\u306b\u306f\uff0c\u7bc4\u56f2\u5185\u306e\u3069\u3053\u304b\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u5408\u308f\u305b\u3066 Ctrl+\/ \u3092\u62bc\u3059\uff0e<\/li>\n<li>\u7de8\u96c6\u5f8c\u306b\u306f\uff0cShift+Ctrl+Enter \u3067\u53cd\u6620\u3055\u305b\u308b\uff0e<\/li>\n<\/ul>\n<p>\u305d\u308c\u3067\u306f\u7d20\u6575\u306a\u30d5\u30fc\u30ea\u30a8\u751f\u6d3b\u3092\u304a\u9001\u308a\u4e0b\u3055\u3044\uff01<\/p>\n","protected":false},"excerpt":{"rendered":"<p>LibreOffice\u306e6.3\u3067\u306f\uff0cLibreOffice Calc\u306b\u30d5\u30fc\u30ea\u30a8\u89e3\u6790\uff08\u96e2\u6563\u30d5\u30fc\u30ea\u30a8\u5909\u63db\uff09\u304c\u5b9f\u88c5\u3055\u308c\u307e\u3057\u305f\uff0e<\/p>\n","protected":false},"author":38,"featured_media":218,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18],"tags":[20,19,21],"class_list":["post-215","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-libreoffice","tag-libreoffice","tag-libreoffice-calc","tag-21"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/posts\/215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/users\/38"}],"replies":[{"embeddable":true,"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/comments?post=215"}],"version-history":[{"count":7,"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/posts\/215\/revisions"}],"predecessor-version":[{"id":226,"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/posts\/215\/revisions\/226"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/media\/218"}],"wp:attachment":[{"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/media?parent=215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/categories?post=215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/home.hirosaki-u.ac.jp\/yaneura\/wp-json\/wp\/v2\/tags?post=215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}