{"id":6064,"date":"2015-04-21T07:24:26","date_gmt":"2015-04-20T22:24:26","guid":{"rendered":"http:\/\/handa.jpn.ph\/?p=6064"},"modified":"2015-04-22T20:02:54","modified_gmt":"2015-04-22T11:02:54","slug":"%e3%83%a9%e3%83%b3%e3%83%89%e3%83%8d%e3%81%8d%e3%81%9f%e3%81%8b%e3%82%93%e5%8c%97%e9%96%a2%e6%9d%b1400km%e3%81%ae%e3%83%ab%e3%83%bc%e3%83%88%e3%83%a9%e3%83%9c%e3%81%ae%e8%bb%8c%e8%b7%a1%e3%82%92","status":"publish","type":"post","link":"https:\/\/sigeyuki.xyz\/?p=6064","title":{"rendered":"\u30e9\u30f3\u30c9\u30cd\u304d\u305f\u304b\u3093\u5317\u95a2\u6771400km\u306e\u30eb\u30fc\u30c8\u30e9\u30dc\u306e\u8ecc\u8de1\u3092\u30cf\u30f3\u30c7\u30a3GPS\u306b\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u306e\u5730\u70b9\u3060\u3051\u91cd\u8981\u8996\u3057\u3066\u9593\u5f15\u304f\u3002"},"content":{"rendered":"

\u6765\u6708\u884c\u308f\u308c\u308b\u30d6\u30eb\u30d9\u8d70\u884c\u4f1a\u30e9\u30f3\u30c9\u30cd\u304d\u305f\u304b\u3093\u5317\u95a2\u6771400km\u306e\u30b3\u30fc\u30b9\u306f\u30eb\u30fc\u30c8\u30e9\u30dc\u306e\u8ecc\u8de1\u3068\u3057\u3066\u516c\u958b\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n

http:\/\/yahoo.jp\/09M7LV<\/a>
\nhttp:\/\/yahoo.jp\/IQGr3E<\/a><\/p>\n

\u3053\u306e\u8ecc\u8de1\u30c7\u30fc\u30bf\u3092\u30ab\u30b7\u30df\u30fc\u30eb\u7d4c\u7531\u3067\u30cf\u30f3\u30c7\u30a3GPS\u306b\u8ee2\u9001\u3059\u308b\u5834\u5408\u3092\u8003\u3048\u3066\u307f\u307e\u3057\u305f\u3002
\n\u6c17\u306b\u306a\u308b\u306e\u306f\u30dd\u30a4\u30f3\u30c8\u6570\u306e\u591a\u3055\u3067\u3059\u3002\u306a\u306b\u3057\u308d\u79c1\u306eGPS\u306f\u65e7\u6a5f\u7a2e\u306eeTrex LEGEND HCx\u3002<\/p>\n

\u524d\u534a\u30673759\u30dd\u30a4\u30f3\u30c8
\n\u5f8c\u534a\u30675820\u30dd\u30a4\u30f3\u30c8<\/p>\n

\u3053\u308c\u3067\u306f\u8377\u304c\u91cd\u3044\u3067\u3059\u3002\u3067\u304d\u308c\u30701000\u30dd\u30a4\u30f3\u30c8\u524d\u5f8c\u307e\u3067\u9593\u5f15\u304d\u305f\u3044\u3067\u3059\u3002<\/p>\n

\u3057\u304b\u3057\u30ab\u30b7\u30df\u30fc\u30eb\u306e\u9593\u5f15\u304d\u6a5f\u80fd\u3092\u4f7f\u3046\u3068\u30b3\u30fc\u30b9\u4e0a\u306e\u66f2\u304c\u308a\u89d2\u306a\u3093\u304b\u8003\u616e\u3057\u3066\u306a\u3044\u3082\u3093\u3067\u3059\u304b\u3089\u5b9f\u969b\u8d70\u3063\u3066\u308b\u3068\u30ad\u30e5\u30fc\u30dd\u30a4\u30f3\u30c8\u3092\u898b\u5931\u3044\u304c\u3061\u306a\u3044\u3084\u3089\u3057\u3044\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u306a\u3069\u304c\u5927\u91cf\u751f\u7523\u3055\u308c\u3066\u3057\u307e\u3044\u307e\u3059\u3002\u3082\u3046\u5c11\u3057\u8ce2\u3044\u9593\u5f15\u304d\u306f\u306a\u3044\u3082\u3093\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n

\u5e78\u3044\u3001\u30e9\u30f3\u30c9\u30cd\u304d\u305f\u304b\u3093\u5317\u95a2\u6771400km\u306f\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u306e\u30a8\u30af\u30bb\u30eb\u30c7\u30fc\u30bf\u3082\u516c\u958b\u3057\u3066\u3044\u307e\u3059<\/a>\u3002
\n\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u306b\u306f\u7dcf\u8ddd\u96e2\uff08ADD\uff09\u306e\u60c5\u5831\u304c\u3042\u308b\u306e\u3067\u3053\u308c\u3092\u4f7f\u3044\u307e\u3057\u3087\u3046\u3002<\/p>\n

\u307e\u305a\u3001\u30eb\u30fc\u30c8\u30e9\u30dc\u306e\u8ecc\u8de1\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3002\u30d5\u30a1\u30a4\u30eb\u5f62\u5f0f\u306fKML\u304c\u5206\u304b\u308a\u3084\u3059\u304f\u3066\u304a\u3059\u3059\u3081\u3067\u3059\u3002\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u3089\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bfATOM\u3067\u958b\u304d\u307e\u3059\u3002\u306a\u3093\u3060\u304b\u3088\u304f\u77e5\u308a\u307e\u305b\u3093\u304c\u6700\u8fd1\u306fxml\u307f\u305f\u3044\u306a\u6539\u884c\u304cwindows\u306e\u30e1\u30e2\u5e33\u3060\u3068\u3050\u3061\u3083\u3050\u3061\u3083\u306b\u306a\u308b\u30d5\u30a1\u30a4\u30eb\u3092\u958b\u304f\u306a\u3089atom\u3092\u4f7f\u3046\u306e\u304c\u30b7\u30e3\u30ec\u30aa\u30c4PC\u30e6\u30fc\u30b6\u30fc\u3068\u3044\u3046\u3053\u3068\u306b\u306a\u3063\u3066\u3044\u308b\u307f\u305f\u3044\u3067\u3059\u3002<\/p>\n

\"kmlwoatomdehiraku\"<\/p>\n

\u3046\u30fc\u3093\u3002\u3053\u308c\u306f\u5206\u304b\u308a\u3084\u3059\u3044\u3002
\n\u65e9\u901f\u30b3\u30d4\u30da\u3057\u3066\u30a8\u30af\u30bb\u30eb\u306b\u8cbc\u308a\u4ed8\u3051\u307e\u3057\u3087\u3046\u3002<\/p>\n

\"cuesheetwoxlsnicopy\"<\/p>\n

\u307e\u3042\u3053\u3093\u306a\u611f\u3058\u306b\u3002<\/p>\n

\u5730\u70b9\uff11\u306e\u7d4c\u5ea6\u3001\u7def\u5ea6\u306f\u30bb\u30ebA1,B1
\n\u5730\u70b9\uff12\u306e\u7d4c\u5ea6\u3001\u7def\u5ea6\u306f\u30bb\u30ebA2,B2<\/p>\n

\u3068\u3059\u308b\u3068\u305d\u306e\u4e8c\u70b9\u9593\u306e\u8ddd\u96e2\u306f<\/p>\n

=IFERROR(6378.137*ACOS(SIN(RADIANS(B1))*SIN(RADIANS(B2))+COS(RADIANS(B1))*COS(RADIANS(B2))*COS(RADIANS(A2-A1))),0)<\/strong><\/p>\n

\u3060\u305d\u3046\u3067\u3059\u3002IFERROR\u306f\u5730\u70b9\uff11\u3068\u5730\u70b9\uff12\u304c\u540c\u3058\u3068\u304d\u3068\u304b\u306a\u305c\u304bNUM\u30a8\u30e9\u30fc\u306b\u306a\u3063\u3061\u3083\u3046\u306e\u3067\u3064\u3051\u3066\u307e\u3059\u304c\u30a8\u30af\u30bb\u30eb2003\u4ee5\u524d\u3060\u3068\u4f7f\u3048\u306a\u3044\u3089\u3057\u3044\u306e\u3067=IF(ISERR(\u3068\u304b\u306b\u5909\u3048\u306a\u3044\u3068\u3044\u3051\u306a\u3044\u307f\u305f\u3044\u3067\u3059\u3002<\/p>\n

\u3053\u3053\u3067\u30ab\u30e9\u30e0\u67f1A\u306f\u7d4c\u5ea6\u3001B\u306f\u7def\u5ea6\u3001C\u306f\u306a\u3093\u3060\u304b\u52dd\u624b\u306b\u5165\u3063\u305f\u3088\u304f\u5206\u304b\u3089\u306a\u3044\u6570\u5b57\u3001D\u306b\u4e8c\u70b9\u9593\u306e\u8ddd\u96e2\u3092\u305a\u3089\u30fc\u3063\u3068\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3057\u3061\u3083\u3046\u308f\u3051\u3067\u3059\u3002<\/p>\n

\u4e8c\u70b9\u9593\u306e\u8ddd\u96e2\u304c\u3067\u305f\u3089\u7d2f\u8a08\u3057\u3061\u3083\u3048\u3070\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u306eADD\u3068\u6bd4\u8f03\u3067\u304d\u307e\u3059\u3002\u8ddd\u96e2\u306e\u7d2f\u8a08\u3092\u30ab\u30e9\u30e0\u67f1E\u306b\u3064\u304f\u3063\u3066\u3001\u5bfe\u8c61\u3068\u306a\u308b\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u306e\u540d\u524d\u3092\u30e9\u30f3\u30c9\u30cd\u304d\u305f\u304b\u3093\u897f\u56de\u308a\u30ad\u30e5\u30fcv5.xlsx<\/strong>\u306e\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u516c\u958b\u7528<\/strong>\u3068\u3044\u3046\u30b7\u30fc\u30c8\u306eE5:E159\u306e\u7bc4\u56f2\u3060\u3068\u3059\u308b\u3068\u3001vlookup\u95a2\u6570\u3067\u6bd4\u8f03\u3057\u305f\u3082\u306e\u3092\u30ab\u30e9\u30e0\u67f1F\u3068G\u306b\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3057\u307e\u3059\u3002<\/p>\n

=INDEX([\u30e9\u30f3\u30c9\u30cd\u304d\u305f\u304b\u3093\u897f\u56de\u308a\u30ad\u30e5\u30fcv5.xlsx]\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u516c\u958b\u7528!$E$5:$E$159,MATCH(E2,[\u30e9\u30f3\u30c9\u30cd\u304d\u305f\u304b\u3093\u897f\u56de\u308a\u30ad\u30e5\u30fcv5.xlsx]\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u516c\u958b\u7528!$E$5:$E$159))<\/strong><\/p>\n

\u3057\u304b\u3057\u3053\u3053\u3067\u306f\u300c\u5bfe\u8c61\u306e\u30bb\u30eb\u3068\u3001\u305d\u306e\u4e00\u3064\u4e0b\u306e\u30bb\u30eb\u3092\u898b\u308b\u300d\u51e6\u7406\u3092\u3059\u308b\u305f\u3081\u306bvlookup\u95a2\u6570\u3092index\uff0bmatch\u306b\u5206\u89e3\u3057\u305f\u3082\u306e\u3092\u4f7f\u3044\u307e\u3059\u3002<\/p>\n

=INDEX([\u30e9\u30f3\u30c9\u30cd\u304d\u305f\u304b\u3093\u897f\u56de\u308a\u30ad\u30e5\u30fcv5.xlsx]\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u516c\u958b\u7528!$E$5:$E$159,MATCH(E2,[\u30e9\u30f3\u30c9\u30cd\u304d\u305f\u304b\u3093\u897f\u56de\u308a\u30ad\u30e5\u30fcv5.xlsx]\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u516c\u958b\u7528!$E$5:$E$159)+1)<\/strong><\/p>\n

\u3053\u308c\u3089\u4e8c\u3064\u306e\u30ad\u30e5\u30fc\u30dd\u30a4\u30f3\u30c8\u306e\u8ddd\u96e2\u304c\u8fd1\u3044\u65b9\u3092\u9078\u3073\u3001\u305d\u306e\u5dee\u3092H\u306b\u30aa\u30fc\u30c8\u30d5\u30a3\u30eb\u3057\u307e\u3059\u3002\u591a\u5206\u300c\u4e8c\u3064\u306e\u5730\u70b9\u3068\u306e\u5dee\u306e\u8fd1\u3044\u65b9\u3092\u9078\u3076\u300d\u306a\u3093\u3066\u30a8\u30af\u30bb\u30eb\u306e\u9054\u4eba\u306a\u3093\u304b\u4f5c\u696d\u30bb\u30eb\u7f6e\u304b\u306a\u3044\u3067\u4e00\u767a\u3067\u3084\u3063\u3061\u3083\u3046\u3093\u3060\u308d\u3046\u3051\u3069\u305d\u3093\u306a\u9ad8\u7b49\u6280\u8853\u306f\u77e5\u308a\u307e\u305b\u3093\u3002<\/p>\n

=(ABS(E2-F2) <ABS(E2-G2))*1*F2 + (ABS(E2-F2) > ABS(E2-G2))*1*G2<\/strong><\/p>\n

\u6700\u5f8c\u306b\u30ab\u30e9\u30e0\u67f1H\u306e\u5024\u304c500m\u4ee5\u4e0b\uff08\u30bb\u30ebK1\u306b0.5\u3092\u7f6e\u3051\u3070500m\u3067\u3059\u3002\u3053\u306e\u5024\u306f\u304a\u597d\u307f\u3067\u5909\u3048\u308b\u3068\u826f\u3044\u3068\u601d\u3044\u307e\u3059\uff09\u306e\u3082\u306e\u306b\u3064\u3044\u3066\u7def\u5ea6\u3001\u7d4c\u5ea6\u3092\u629c\u304d\u51fa\u305b\u3070\u3042\u308b\u7a0b\u5ea6\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u3092\u53cd\u6620\u3057\u305f\u305d\u3053\u305d\u3053\u8ce2\u3044\u9593\u5f15\u304d\u304c\u5b8c\u6210\u3067\u3059\u3002<\/p>\n

\"cuesheetnonitennosa\"<\/p>\n

=IF((ABS(E2-H2)<$K$1)+ (MOD(ROW(),30)=0),A1,””)<\/strong><\/p>\n

\u306eMOD\uff08ROW(),30)\u306f30\u30dd\u30a4\u30f3\u30c8\u3054\u3068\u306b\u8ecc\u8de1\u3092\u7f6e\u3044\u3066\u3044\u307e\u3059\u3002\u3053\u308c\u306f\u30ad\u30e5\u30fc\u30dd\u30a4\u30f3\u30c8\u304c\u306a\u3044\u533a\u9593\u304c\u9577\u3044\u5834\u5408\u5bfe\u7b56\u3067\u3059\u3002
\n\u3042\u3068\u306f\u30ab\u30e9\u30e0\u67f1I\u3068J\u3092\u30b3\u30d4\u30fc\u3057\u3066atom\u3067\u958b\u3044\u305f\u9069\u5f53\u306aKML\u30d5\u30a1\u30a4\u30eb\u306e<coordinates>\uff5e<\/coordinates>\u306b\u30b3\u30d4\u30da\u3059\u308c\u3070\u30ab\u30b7\u30df\u30fc\u30eb\u3067\u8aad\u3081\u307e\u3059\u3002<\/p>\n

\"iikanjinimabiitayo\"<\/p>\n

\u524d\u534a\u30001491\u30dd\u30a4\u30f3\u30c8
\n\u5f8c\u534a\u30001691\u30dd\u30a4\u30f3\u30c8<\/p>\n

\u3044\u3044\u611f\u3058\u306b\u9593\u5f15\u3051\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u6765\u6708\u884c\u308f\u308c\u308b\u30d6\u30eb\u30d9\u8d70\u884c\u4f1a\u30e9\u30f3\u30c9\u30cd\u304d\u305f\u304b\u3093\u5317\u95a2\u6771400km\u306e\u30b3\u30fc\u30b9\u306f\u30eb\u30fc\u30c8\u30e9\u30dc\u306e\u8ecc\u8de1\u3068\u3057\u3066\u516c\u958b\u3055\u308c\u3066\u3044\u307e\u3059\u3002 http:\/\/yahoo.jp\/09M7LV http:\/\/yahoo.jp\/IQGr3E \u3053\u306e\u8ecc\u8de1\u30c7\u30fc\u30bf\u3092\u30ab\u30b7 … <\/p>\n

“\u30e9\u30f3\u30c9\u30cd\u304d\u305f\u304b\u3093\u5317\u95a2\u6771400km\u306e\u30eb\u30fc\u30c8\u30e9\u30dc\u306e\u8ecc\u8de1\u3092\u30cf\u30f3\u30c7\u30a3GPS\u306b\u30ad\u30e5\u30fc\u30b7\u30fc\u30c8\u306e\u5730\u70b9\u3060\u3051\u91cd\u8981\u8996\u3057\u3066\u9593\u5f15\u304f\u3002” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6064","post","type-post","status-publish","format-standard","hentry","category-bike"],"_links":{"self":[{"href":"https:\/\/sigeyuki.xyz\/index.php?rest_route=\/wp\/v2\/posts\/6064","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sigeyuki.xyz\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sigeyuki.xyz\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sigeyuki.xyz\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sigeyuki.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6064"}],"version-history":[{"count":0,"href":"https:\/\/sigeyuki.xyz\/index.php?rest_route=\/wp\/v2\/posts\/6064\/revisions"}],"wp:attachment":[{"href":"https:\/\/sigeyuki.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6064"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sigeyuki.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6064"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sigeyuki.xyz\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6064"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}