{"id":671,"date":"2014-09-20T15:01:36","date_gmt":"2014-09-20T12:01:36","guid":{"rendered":"http:\/\/top-analyst.com\/he\/?p=671"},"modified":"2014-09-20T16:21:57","modified_gmt":"2014-09-20T13:21:57","slug":"%d7%a0%d7%95%d7%a1%d7%97%d7%90%d7%95%d7%aa-%d7%93%d7%99%d7%a0%d7%9e%d7%99%d7%95%d7%aa-%d7%95%d7%90%d7%99%d7%a0%d7%98%d7%a8%d7%90%d7%a7%d7%98%d7%99%d7%91%d7%99%d7%95%d7%aa-%d7%91%d7%90%d7%a7%d7%a1","status":"publish","type":"post","link":"http:\/\/top-analyst.com\/he\/?p=671","title":{"rendered":"\u05e0\u05d5\u05e1\u05d7\u05d0\u05d5\u05ea \u05d3\u05d9\u05e0\u05de\u05d9\u05d5\u05ea \u05d5\u05d0\u05d9\u05e0\u05d8\u05e8\u05d0\u05e7\u05d8\u05d9\u05d1\u05d9\u05d5\u05ea \u05d1\u05d0\u05e7\u05e1\u05dc"},"content":{"rendered":"\n<!-- Quick Adsense WordPress Plugin: http:\/\/quicksense.net\/ -->\n<div style=\"float:none;margin:30px 0 30px 0;text-align:center;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- TA_top -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-2454583441719238\"\r\n     data-ad-slot=\"8982999695\"\r\n     data-ad-format=\"auto\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><!-- TA_HE_After_Post -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:inline-block;width:468px;height:60px\"\r\n     data-ad-client=\"ca-pub-2454583441719238\"\r\n     data-ad-slot=\"7215114859\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-672\" src=\"http:\/\/top-analyst.com\/he\/wp-content\/uploads\/2014\/09\/Copy_Modified.jpg\" alt=\"\" width=\"410\" height=\"410\" srcset=\"http:\/\/top-analyst.com\/he\/wp-content\/uploads\/2014\/09\/Copy_Modified.jpg 410w, http:\/\/top-analyst.com\/he\/wp-content\/uploads\/2014\/09\/Copy_Modified-150x150.jpg 150w, http:\/\/top-analyst.com\/he\/wp-content\/uploads\/2014\/09\/Copy_Modified-300x300.jpg 300w\" sizes=\"(max-width: 410px) 100vw, 410px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>\u05dc\u05e8\u05d5\u05d1, \u05e0\u05d5\u05e1\u05d7\u05d0\u05d5\u05ea \u05d4\u05d0\u05e7\u05e1\u05dc \u05de\u05d1\u05e6\u05e2\u05d5\u05ea \u05e4\u05e2\u05d5\u05dc\u05d4 \u05d0\u05d7\u05ea \u05de\u05d5\u05d2\u05d3\u05e8\u05ea \u05de\u05e8\u05d0\u05e9: \u05d1\u05d3&quot;\u05db\u00a0\u05e4\u05e2\u05d5\u05dc\u05d4 \u05de\u05ea\u05de\u05d8\u05d9\u05ea \u05db\u05dc\u05e9\u05d4\u05d9 &#8211; \u05e1\u05db\u05d5\u05dd, \u05de\u05de\u05d5\u05e6\u05e2 \u05d5\u05db\u05d5' \u05d0\u05d5 \u05d0\u05d9\u05ea\u05d5\u05e8 \u05e2\u05e8\u05db\u05d9\u05dd, \u05dc\u05de\u05e9\u05dc vlookup.<\/p>\n<p>\u05e2\u05dd \u05d6\u05d0\u05ea, \u05db\u05d0\u05e9\u05e8 \u05d1\u05d5\u05e0\u05d9\u05dd \u05d0\u05e7\u05e1\u05dc\u05d9\u05dd \u05d0\u05d9\u05e0\u05d8\u05e8\u05d0\u05e7\u05d8\u05d9\u05d1\u05d9\u05d9\u05dd \u05d4\u05db\u05d5\u05dc\u05dc\u05d9\u05dd \u05e7\u05dc\u05d8 \u05de\u05d4\u05d4\u05de\u05e9\u05ea\u05de\u05e9, \u05d9\u05e9 \u05e6\u05d5\u05e8\u05da \u05d1\u05d9\u05db\u05dc\u05ea \u05d3\u05d9\u05e0\u05d0\u05de\u05d9\u05ea \u05d9\u05d5\u05ea\u05e8. \u05dc\u05e8\u05d5\u05d1, \u05de\u05d3\u05d5\u05d1\u05e8 \u05d1\u05de\u05e1\u05e4\u05e8 \u05d0\u05e4\u05e9\u05e8\u05d5\u05d9\u05d5\u05ea \u05d1\u05d5\u05d3\u05d3\u05d5\u05ea, \u05d5\u05dc\u05db\u05df \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1-IF \u05d5\/\u05d0\u05d5 \u05d1\u05e4\u05e8\u05de\u05d8\u05e8\u05d9\u05dd \u05d1\u05ea\u05d5\u05da \u05d4\u05e0\u05d5\u05e1\u05d7\u05d4 \u05e2\u05d5\u05e0\u05d4 \u05e2\u05dc \u05d4\u05e6\u05e8\u05db\u05d9\u05dd. \u05e2\u05dd \u05d6\u05d0\u05ea, \u05dc\u05e2\u05ea\u05d9\u05dd \u05d6\u05d4 \u05dc\u05d0 \u05de\u05e1\u05e4\u05d9\u05e7.<\/p>\n<p>\u05d1\u05e4\u05d5\u05e1\u05d8 \u05d6\u05d4 \u05d0\u05e6\u05d9\u05d2 \u05db\u05d9\u05e6\u05d3 \u05e0\u05d9\u05ea\u05df \u05dc\u05d2\u05e8\u05d5\u05dd \u05dc\u05d0\u05e7\u05e1\u05dc \u05dc\u05d7\u05e9\u05d1 \u05e0\u05d5\u05e1\u05d7\u05d4 \u05de\u05e7\u05d5\u05e1\u05d8\u05de\u05ea \u05dc\u05d7\u05dc\u05d5\u05d8\u05d9\u05df, \u05d0\u05e9\u05e8 \u05e0\u05d1\u05e0\u05d9\u05ea \u05e2\u05dc \u05d9\u05d3\u05d9 \u05d4\u05de\u05e9\u05ea\u05de\u05e9 \u05ea\u05d5\u05da \u05db\u05d3\u05d9 \u05d4\u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05d9\u05d9\u05e9\u05d5\u05dd, \u05d5\u05dc\u05d0 \u05de\u05e8\u05d0\u05e9.<\/p>\n<p>&nbsp;<\/p>\n<p><!--more--><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u05db\u05d3\u05d9 \u05dc\u05d2\u05e8\u05d5\u05dd \u05dc\u05d0\u05e7\u05e1\u05dc \u05dc\u05d4\u05ea\u05d9\u05d9\u05d7\u05e1 \u05dc\u05d8\u05e7\u05e1\u05d8 \u05db\u05d0\u05dc \u05e0\u05d5\u05e1\u05d7\u05d4, \u05de\u05d9\u05e7\u05e8\u05d5\u05e1\u05e4\u05d8 \u05e9\u05ea\u05dc\u05d5 \u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d4 \u05d9\u05d9\u05e2\u05d5\u05d3\u05d9\u05ea \u05d1\u05e9\u05dd Evaluate:<\/p>\n<p>&nbsp;<\/p>\n<div style=\"border: 1px solid black; padding: 1px;\">\n<p dir=\"ltr\" style=\"text-align: left;\">Evaluate(text)<\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p>\u05d9\u05e9 \u05d0\u05de\u05e0\u05dd \u05de\u05d2\u05d1\u05dc\u05d4 \u05d0\u05d7\u05ea: \u05d4\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d4 \u05de\u05d9\u05d5\u05e2\u05d3\u05ea \u05dc\u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05e7\u05d5\u05d3 VBA \u05d1\u05dc\u05d1\u05d3. \u05db\u05dc\u05d5\u05de\u05e8, <strong>\u05d0\u05d9 \u05d0\u05e4\u05e9\u05e8 \u05dc\u05e7\u05e8\u05d5\u05d0 \u05dc\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d4 \u05d4\u05e0&quot;\u05dc \u05d9\u05e9\u05d9\u05e8\u05d5\u05ea \u05de\u05d2\u05d9\u05dc\u05d9\u05d5\u05df \u05d4\u05d0\u05e7\u05e1\u05dc<\/strong>.<\/p>\n<p>\u05d0\u05d1\u05dc \u05d0\u05dc \u05d3\u05d0\u05d2\u05d4.\u00a0\u05db\u05dc \u05de\u05d4 \u05e9\u05e0\u05d3\u05e8\u05e9 \u05db\u05d3\u05d9 \u05dc\u05d4\u05ea\u05d2\u05d1\u05e8 \u05e2\u05dc \u05d4\u05de\u05db\u05e9\u05d5\u05dc \u05d4\u05d5\u05d0 \u05dc\u05db\u05ea\u05d5\u05d1 \u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d9\u05ea \u05de\u05e2\u05d8\u05e4\u05ea \u05e7\u05e6\u05e8\u05e6\u05e8\u05d4 \u05d5\u05dc\u05de\u05e7\u05de\u05d4 \u05d1\u05de\u05d5\u05d3\u05d5\u05dc VBA:<\/p>\n<p>1. \u05dc\u05d7\u05d9\u05e6\u05d4 \u05e2\u05dc ALT+F11<\/p>\n<p>2. \u05d4\u05d5\u05e1\u05e4\u05ea \u05de\u05d5\u05d3\u05d5\u05dc: Insert &#8211; &gt; Module<\/p>\n<p>3. \u05e7\u05d5\u05e4\u05d9-\u05e4\u05d9\u05d9\u05e1\u05d8 \u05dc\u05e7\u05d5\u05d3 \u05d4\u05d1\u05d0:<\/p>\n<p>&nbsp;<\/p>\n<div style=\"border: 1px solid black; padding: 1px;\">\n<p dir=\"ltr\" style=\"text-align: left;\">Function Evl(text As String) As String<\/p>\n<p dir=\"ltr\" style=\"text-align: left;\">\u00a0 \u00a0 Evl\u00a0= Evaluate(text)<\/p>\n<p dir=\"ltr\" style=\"text-align: left;\">End Function<\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<p>4. \u05d1\u05d2\u05d9\u05dc\u05d9\u05d5\u05df \u05d4\u05d0\u05e7\u05e1\u05dc, \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1\u05e4\u05d5\u05e0\u05e7\u05e6\u05d9\u05d9\u05ea \u05d4\u05de\u05e2\u05d8\u05e4\u05ea \u05e2\u05dc \u05d4\u05ea\u05d0 \u05e2\u05dd \u05d4\u05d8\u05e7\u05e1\u05d8 \u05d0\u05e9\u05e8 \u05de\u05db\u05d9\u05dc \u05d0\u05ea \u05d4\u05e0\u05d5\u05e1\u05d7\u05d4 \u05d1\u05de\u05e7\u05d5\u05e1\u05d8\u05de\u05ea:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-673\" src=\"http:\/\/top-analyst.com\/he\/wp-content\/uploads\/2014\/09\/examp1.jpg\" alt=\"\" width=\"478\" height=\"256\" srcset=\"http:\/\/top-analyst.com\/he\/wp-content\/uploads\/2014\/09\/examp1.jpg 478w, http:\/\/top-analyst.com\/he\/wp-content\/uploads\/2014\/09\/examp1-300x160.jpg 300w\" sizes=\"(max-width: 478px) 100vw, 478px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>\u05d1\u05d4\u05e6\u05dc\u05d7\u05d4!<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n\n<!-- Quick Adsense WordPress Plugin: http:\/\/quicksense.net\/ -->\n<div style=\"float:none;margin:30px 0 30px 0;text-align:center;\">\n<script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\r\n<!-- TA_Bottom -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block\"\r\n     data-ad-client=\"ca-pub-2454583441719238\"\r\n     data-ad-slot=\"1704464845\"\r\n     data-ad-format=\"auto\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script><!-- TA_HE_After_Post -->\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:inline-block;width:468px;height:60px\"\r\n     data-ad-client=\"ca-pub-2454583441719238\"\r\n     data-ad-slot=\"7215114859\"><\/ins>\r\n<script>\r\n(adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n\n<div style=\"font-size:0px;height:0px;line-height:0px;margin:0;padding:0;clear:both\"><\/div>","protected":false},"excerpt":{"rendered":"<p>&nbsp; \u05dc\u05e8\u05d5\u05d1, \u05e0\u05d5\u05e1\u05d7\u05d0\u05d5\u05ea \u05d4\u05d0\u05e7\u05e1\u05dc \u05de\u05d1\u05e6\u05e2\u05d5\u05ea \u05e4\u05e2\u05d5\u05dc\u05d4 \u05d0\u05d7\u05ea \u05de\u05d5\u05d2\u05d3\u05e8\u05ea \u05de\u05e8\u05d0\u05e9: \u05d1\u05d3&quot;\u05db\u00a0\u05e4\u05e2\u05d5\u05dc\u05d4 \u05de\u05ea\u05de\u05d8\u05d9\u05ea \u05db\u05dc\u05e9\u05d4\u05d9 &#8211; \u05e1\u05db\u05d5\u05dd, \u05de\u05de\u05d5\u05e6\u05e2 \u05d5\u05db\u05d5' \u05d0\u05d5 \u05d0\u05d9\u05ea\u05d5\u05e8 \u05e2\u05e8\u05db\u05d9\u05dd, \u05dc\u05de\u05e9\u05dc vlookup. \u05e2\u05dd \u05d6\u05d0\u05ea, \u05db\u05d0\u05e9\u05e8 \u05d1\u05d5\u05e0\u05d9\u05dd \u05d0\u05e7\u05e1\u05dc\u05d9\u05dd \u05d0\u05d9\u05e0\u05d8\u05e8\u05d0\u05e7\u05d8\u05d9\u05d1\u05d9\u05d9\u05dd \u05d4\u05db\u05d5\u05dc\u05dc\u05d9\u05dd \u05e7\u05dc\u05d8 \u05de\u05d4\u05d4\u05de\u05e9\u05ea\u05de\u05e9, \u05d9\u05e9 \u05e6\u05d5\u05e8\u05da \u05d1\u05d9\u05db\u05dc\u05ea \u05d3\u05d9\u05e0\u05d0\u05de\u05d9\u05ea \u05d9\u05d5\u05ea\u05e8. \u05dc\u05e8\u05d5\u05d1, \u05de\u05d3\u05d5\u05d1\u05e8 \u05d1\u05de\u05e1\u05e4\u05e8 \u05d0\u05e4\u05e9\u05e8\u05d5\u05d9\u05d5\u05ea \u05d1\u05d5\u05d3\u05d3\u05d5\u05ea, \u05d5\u05dc\u05db\u05df \u05e9\u05d9\u05de\u05d5\u05e9 \u05d1-IF \u05d5\/\u05d0\u05d5 \u05d1\u05e4\u05e8\u05de\u05d8\u05e8\u05d9\u05dd \u05d1\u05ea\u05d5\u05da \u05d4\u05e0\u05d5\u05e1\u05d7\u05d4 \u05e2\u05d5\u05e0\u05d4 \u05e2\u05dc \u05d4\u05e6\u05e8\u05db\u05d9\u05dd. \u05e2\u05dd \u05d6\u05d0\u05ea, \u05dc\u05e2\u05ea\u05d9\u05dd \u05d6\u05d4 \u05dc\u05d0 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,8],"tags":[11,20,27,281,55,311,301,75,76,183,97],"_links":{"self":[{"href":"http:\/\/top-analyst.com\/he\/index.php?rest_route=\/wp\/v2\/posts\/671"}],"collection":[{"href":"http:\/\/top-analyst.com\/he\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/top-analyst.com\/he\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/top-analyst.com\/he\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/top-analyst.com\/he\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=671"}],"version-history":[{"count":3,"href":"http:\/\/top-analyst.com\/he\/index.php?rest_route=\/wp\/v2\/posts\/671\/revisions"}],"predecessor-version":[{"id":676,"href":"http:\/\/top-analyst.com\/he\/index.php?rest_route=\/wp\/v2\/posts\/671\/revisions\/676"}],"wp:attachment":[{"href":"http:\/\/top-analyst.com\/he\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=671"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/top-analyst.com\/he\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=671"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/top-analyst.com\/he\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=671"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}