{"id":12642,"date":"2024-12-01T13:20:09","date_gmt":"2024-12-01T12:20:09","guid":{"rendered":"https:\/\/www.auditsi.eu\/?p=12642"},"modified":"2024-12-01T13:20:09","modified_gmt":"2024-12-01T12:20:09","slug":"projet-ixp-v1-2beta-quelques-nouvelles-de-mon-interpreteur-dexpressions","status":"publish","type":"post","link":"https:\/\/www.auditsi.eu\/?p=12642","title":{"rendered":"Projet IXP (v1.2beta) : quelques nouvelles de mon interpr\u00e9teur d&#8217;expressions"},"content":{"rendered":"<p style=\"text-align: justify;\">J&#8217;avance \u00e0 petits pas sur mon <strong>projet IXP<\/strong> (interpr\u00e9teur d&#8217;expressions). Ce programme effectue des <strong>calculs et du traitement de donn\u00e9es<\/strong>.<\/p>\n<p style=\"text-align: justify;\">Il est bas\u00e9 sur un<strong> langage d\u2019expression LIXP<\/strong> qui permet de cha\u00eener et <strong>automatiser des calculs pr\u00e9programm\u00e9s<\/strong>, des requ\u00eates SQL, des exports (fichiers texte)\u2026<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12643\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-1.png\" alt=\"EX IXP 1\" width=\"1340\" height=\"743\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-1.png 1340w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-1-300x166.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-1-1024x568.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-1-768x426.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-1-730x405.png 730w\" sizes=\"auto, (max-width: 1340px) 100vw, 1340px\" \/><\/p>\n<p style=\"text-align: justify;\">Voici quelques exemples de calculs sur des sujets vari\u00e9s qu&#8217;un r\u00e9viseur ou auditeur comptable retrouve dans son quotidien : reconstitution d&#8217;\u00e9ch\u00e9ancier d&#8217;emprunt, calcul de RSP (<strong>r\u00e9serve sp\u00e9ciale de participation<\/strong>) avec prise en compte du forfait social, <strong>pourcentage d&#8217;int\u00e9r\u00eat<\/strong> (y compris avec participation crois\u00e9e sur la consolidante) et <strong>analyse des comptes de soci\u00e9t\u00e9s \u00e0 partir du FEC<\/strong> (fusion de FEC, diff\u00e9rence de versions entre deux FEC, requ\u00eates SQL sur FEC, analyse de la TVA&#8230;).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12644\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-2.png\" alt=\"EX IXP 2\" width=\"1343\" height=\"754\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-2.png 1343w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-2-300x168.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-2-1024x575.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-2-768x431.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-2-730x410.png 730w\" sizes=\"auto, (max-width: 1343px) 100vw, 1343px\" \/><\/p>\n<p style=\"text-align: justify;\">LIXP est un langage d\u00e9di\u00e9 aux m\u00e9tiers de la comptabilit\u00e9 et de l&#8217;analyse de donn\u00e9es. A ce jour, ce langage est d\u00e9j\u00e0 dot\u00e9 de fonctionnalit\u00e9s de traitement de donn\u00e9es (FEC, requ\u00eates SQL&#8230;).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12645\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-3.png\" alt=\"EX IXP 3\" width=\"1341\" height=\"754\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-3.png 1341w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-3-300x169.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-3-1024x576.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-3-768x432.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-3-730x410.png 730w\" sizes=\"auto, (max-width: 1341px) 100vw, 1341px\" \/><\/p>\n<p style=\"text-align: justify;\">Un exemple de plus : calcul des pourcentages d&#8217;int\u00e9r\u00eat :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12646\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-4.png\" alt=\"EX IXP 4\" width=\"1342\" height=\"759\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-4.png 1342w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-4-300x170.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-4-1024x579.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-4-768x434.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-4-730x413.png 730w\" sizes=\"auto, (max-width: 1342px) 100vw, 1342px\" \/><\/p>\n<p style=\"text-align: justify;\">Autre exemple : audit de comptes \u00e0 partir du FEC :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12647\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-5.png\" alt=\"EX IXP 5\" width=\"1334\" height=\"754\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-5.png 1334w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-5-300x170.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-5-1024x579.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-5-768x434.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-5-730x413.png 730w\" sizes=\"auto, (max-width: 1334px) 100vw, 1334px\" \/><\/p>\n<p>Les scripts LIXP sont tr\u00e8s lisibles :<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-12648\" src=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-6.png\" alt=\"EX IXP 6\" width=\"1333\" height=\"757\" srcset=\"https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-6.png 1333w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-6-300x170.png 300w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-6-1024x582.png 1024w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-6-768x436.png 768w, https:\/\/www.auditsi.eu\/wp-content\/uploads\/2024\/12\/EX-IXP-6-730x415.png 730w\" sizes=\"auto, (max-width: 1333px) 100vw, 1333px\" \/><\/p>\n<p style=\"text-align: justify;\">A suivre&#8230;<\/p>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div id=\"sconnect-is-installed\" style=\"display: none;\">2.13.0.0<\/div>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Projet%20IXP%20%28v1.2beta%29%20%3A%20quelques%20nouvelles%20de%20mon%20interpr%C3%A9teur%20d%27expressions\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"<p>J&#8217;avance \u00e0 petits pas sur mon projet IXP (interpr\u00e9teur d&#8217;expressions). Ce programme effectue des calculs et du traitement de donn\u00e9es. Il est bas\u00e9 sur un langage d\u2019expression LIXP qui permet de cha\u00eener et automatiser des calculs pr\u00e9programm\u00e9s, des requ\u00eates SQL, des exports (fichiers texte)\u2026 Voici quelques exemples de calculs sur des sujets vari\u00e9s qu&#8217;un r\u00e9viseur &#8230;<\/p>\n<p><a href=\"https:\/\/www.auditsi.eu\/?p=12642\" class=\"more-link\">Continue reading &lsquo;Projet IXP (v1.2beta) : quelques nouvelles de mon interpr\u00e9teur d&#8217;expressions&rsquo; &raquo;<\/a><\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_counters\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/fr\/share-small.png\" style=\"border:0px; padding-top:2px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_c=new Array(\"twitter\",\"facebook_like\",\"facebook_send\",\"email\",\"print\",\"linkedin\");var hupso_counters_lang = \"fr_FR\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"BenoitRiviere14\";var hupso_url_c=\"\";var hupso_title_c=\"Projet%20IXP%20%28v1.2beta%29%20%3A%20quelques%20nouvelles%20de%20mon%20interpr%C3%A9teur%20d%27expressions\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/counters.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"ngg_post_thumbnail":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","_links_to":"","_links_to_target":""},"categories":[324,508,304,8,3292,3291,282],"tags":[166,1981,3296,1210,1838,3294,3295,664,617,3293,57,1798,1643],"class_list":["post-12642","post","type-post","status-publish","format-standard","hentry","category-comptes-consolides","category-cycle-personnel","category-cycle-tresorerie","category-extractions-de-donnees","category-ixp","category-lixp","category-sql","tag-analyse-de-donnees","tag-audit-de-la-tva","tag-expression","tag-fec","tag-interpreteur-de-fomules","tag-ixp","tag-lixp","tag-participations-croisees","tag-pourcentage-dinteret","tag-projet-ixp","tag-requete-sql","tag-rsp","tag-sql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":false,"_links":{"self":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12642"}],"version-history":[{"count":2,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12642\/revisions"}],"predecessor-version":[{"id":12650,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=\/wp\/v2\/posts\/12642\/revisions\/12650"}],"wp:attachment":[{"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.auditsi.eu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}