{"title":"S1\u5272\u308c\u3082\u5207\u308a\u8fd4\u3059\uff08\u30ec\u30fc\u30b6\u30fc\u30c6\u30c3\u30af\uff09","version":"1.0","author_name":"am_baltar","url":"https://mariomari.hatenablog.com/entry/2026/01/14/213314","blog_url":"https://mariomari.hatenablog.com/","image_url":null,"description":"\uff11\u6708\uff11\uff14\u65e5\uff08\u6c34\uff09\u306e\u30ec\u30fc\u30b6\u30fc\u30c6\u30c3\u30af\u7814\u7a76\u3067\u3059\u3002 MAX\u5024\u3082\uff11\uff12\u6708\uff19\u65e5\u4ee5\u6765\u306e\u66f4\u65b0\u3002OSC\u306f\uff16\uff12\uff0e\uff16\uff05\u3068\u9ad8\u3044\u6c34\u6e96\u3002\u5f53\u9762\u306e\u9ad8\u5024\u3092\u8d85\u3048\u3066\u6d6e\u904a\u4e2d\u3002 S1\u3068\u306f\u3001\u4e0b\u8a18\u306e\u6570\u5f0f\u3067\u8a08\u7b97\u3055\u308c\u305f\uff13\uff13\uff17\uff14\uff13\u5186\u3067\u3059\u3002 A4=PIVOT\uff08\uff13\uff14\uff15\uff11\uff17\u5186\uff09\u30fc \uff08B4=\u4eca\u65e5\u306e\u9ad8\u5024\uff08\uff13\uff15\uff12\uff19\uff10\u5186\uff09\uff09\u30fcA4=\uff17\uff17\uff13\u5186\u3002 \u3053\u306e\u5f0f\u3067\u4e2d\u5fc3\u3068\u306a\u308bA4\u306ePIVOT\u306f\u3001 \uff08\u4eca\u65e5\u306e\u9ad8\u5024\uff0b\u4eca\u65e5\u306e\u5b89\u5024\uff0b\u73fe\u5728\u5024\uff09\u00f7\uff13 \u3067\u523b\u4e00\u523b\u3068\u5909\u5316\u3057\u307e\u3059\u3002 \u305d\u3057\u3066\u3001\u4eca\u65e5\u306e\u30ec\u30fc\u30b6\u30fc\u30c6\u30c3\u30af\u306e\u5b89\u5024\u306f\u3001\u4e00\u6642S1\u5024\u306e\uff13\uff13\uff17\uff14\uff13\u5186\u3092\u4e0b\u56de\u308b\uff13\uff13\uff14\uff16\uff10\u5186\u3002\u3057\u304b\u3057\u3001\u305d\u308c\u3092\u30de\u30fc\u30af\u3057\u305f\u306e\u306f\uff19\u6642\uff12\u5206\u3067\u3057\u305f\u3002\u3053\u3053\u3067\u96fb\u5149\u77f3\u706b\u306e\u8cb7\u3044\u3092\u5165\u308c\u308b\u306b\u306f\u81f3\u96e3\u306e\u6280\u3002 \u3053\u308c\u3092\u4f55\u3068\u304bVBA\u306e\u30b3\u30fc\u30c9\u3067\u4e00\u77ac\u306e\u3046\u3061\u306b\u3001\uff13\uff13\u2026","published":"2026-01-14 21:33:14","categories":[],"html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Fmariomari.hatenablog.com%2Fentry%2F2026%2F01%2F14%2F213314\" title=\"S1\u5272\u308c\u3082\u5207\u308a\u8fd4\u3059\uff08\u30ec\u30fc\u30b6\u30fc\u30c6\u30c3\u30af\uff09 - \u682a\u306b\u51fa\u4f1a\u3046\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","type":"rich","author_url":"https://blog.hatena.ne.jp/am_baltar/","height":"190","blog_title":"\u682a\u306b\u51fa\u4f1a\u3046","provider_url":"https://hatena.blog","width":"100%","provider_name":"Hatena Blog"}