{"id":232073,"date":"2023-01-19T12:33:00","date_gmt":"2023-01-19T09:33:00","guid":{"rendered":"https:\/\/wordpress.mediadoma.com\/?p=232073"},"modified":"2023-02-04T17:59:31","modified_gmt":"2023-02-04T14:59:31","slug":"den-enkla-bolaanekalkylatorn-implementerad-i-c-c-javascript-och-mysql","status":"publish","type":"post","link":"https:\/\/wordpress.mediadoma.com\/sv\/den-enkla-bolaanekalkylatorn-implementerad-i-c-c-javascript-och-mysql\/","title":{"rendered":"Den enkla bol\u00e5nekalkylatorn implementerad i C\/C++, Javascript och MySQL"},"content":{"rendered":"<p>\u00c4ven om det finns m\u00e5nga tillg\u00e4ngliga <a href=\"https:\/\/helloacm.com\/how-to-calculate-mortgage-monthly-payment-using-excel-with-formula\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">bol\u00e5nekalkylatorer<\/a> d\u00e4r ute, \u00e4r principen f\u00f6r en enkel bol\u00e5nekalkylator v\u00e4ldigt enkel, som \u00e4r baserad p\u00e5 f\u00f6ljande matematiska formel.<\/p>\n<p><a href=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d32c6ed.png\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d32c6ed.png\" alt=\"Den enkla bol\u00e5nekalkylatorn implementerad i C\/C++, Javascript och MySQL\"><\/a><\/p>\n<p>d\u00e4r c \u00e4r den m\u00e5natliga \u00e5terbetalningen, r \u00e4r de m\u00e5natliga r\u00e4ntorna (vilket \u00e4r en tolftedel av de \u00e5rliga r\u00e4ntorna). P \u00e4r de totala l\u00e5nade pengarna. N \u00e4r det totala antalet \u00e5terbetalningar (t.ex. antalet m\u00e5nader).<\/p>\n<h3>Enkel bol\u00e5nekalkylator implementerad i MySQL<\/h3>\n<p>Till exempel, jag l\u00e5nade 170K fr\u00e5n HSBC Bank, r\u00e4ntesatsen (\u00e5rligt) \u00e4r 2,49%, och jag m\u00e5ste betala tillbaka principen+r\u00e4ntor om 25 \u00e5r. \u00c5terbetalningsbeloppet varje m\u00e5nad (f\u00f6rutsatt att det \u00e4r fast r\u00e4nta) kan ber\u00e4knas via f\u00f6ljande kommando i <a href=\"https:\/\/helloacm.com\/php-script-to-execute-mysql-statements-in-a-text-file\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">MySQL-konsolen<\/a> :<\/p>\n<pre><code>mysql&gt; select 0.0249\/12*170000*power(1+0.0249\/12,25*12)\/(power(1+0.0249\/12,25*12)-1);\n+------------------------------------------------------------------------+\n| 0.0249\/12*170000*power(1+0.0249\/12,25*12)\/(power(1+0.0249\/12,25*12)-1) |\n+------------------------------------------------------------------------+\n| \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 761.792586559163 |\n+------------------------------------------------------------------------+\n1 row in set (0.00 sec)<\/code><\/pre>\n<h3>Enkel bol\u00e5nekalkylator implementerad i C\/C++<\/h3>\n<p>Med pow-funktionen fr\u00e5n math.h definieras betalningsfunktionen enligt f\u00f6ljande:<\/p>\n<pre><code>#include &lt;math.h&gt;\n\u00a0\n\/\/ r - monthly interest rate\n\/\/ p - principle\n\/\/ n - number of repayments\ndouble payment(r, p, n) {\n\u00a0 \u00a0 var x = pow(1 + r, n);\n\u00a0 \u00a0 return r * p * x \/ (x - 1);\n}<\/code><\/pre>\n<h3>Online enkel hypotekskalkylator implementerad i Javascript<\/h3>\n<p>P\u00e5 liknande s\u00e4tt definieras funktionen som definieras i <a href=\"https:\/\/wordpress.mediadoma.com\/sv\/hur-fyller-jag-i-kommentarsformulaer-automatiskt-med-javascript\/\" title=\"Javascript\">Javascript<\/a> som:<\/p>\n<pre><code>\/\/ r - monthly interest rate\n\/\/ p - principle\n\/\/ n - number of repayments\nfunction payment(r, p, n) {\n\u00a0 \u00a0 var x = Math.pow(1 + r, n);\n\u00a0 \u00a0 return r * p * x \/ (x - 1);\n}<\/code><\/pre>\n<p>Fyll i v\u00e4rdena f\u00f6r r, P och N och f\u00f6ljande <a href=\"https:\/\/helloacm.com\/the-simple-mortgage-calculator-implemented-in-cc-javascript-and-mysql\/\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">online-bol\u00e5nekalkylator (\u00f6ppnas i nytt f\u00f6nster)<\/a> kommer att ber\u00e4kna den m\u00e5natliga \u00e5terbetalningen och r\u00e4ntor (ej tillg\u00e4ngligt om du tittar p\u00e5 <a href=\"https:\/\/wordpress.mediadoma.com\/sv\/hur-aktiverar-jag-amp-med-wordpress-amp-optimeringstekniker-med-wordpress\/\" title=\"Accelerated Mobile Page-\">Accelerated Mobile Page-<\/a> versionen):<\/p>\n<p><a href=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d428cbc.jpg\" data-rel=\"lightbox\"><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/wordpress.mediadoma.com\/wp-content\/uploads\/2022\/01\/post-156659-61e5c2d428cbc.jpg\" alt=\"Den enkla bol\u00e5nekalkylatorn implementerad i C\/C++, Javascript och MySQL\"><\/a><\/p>\n<p>bol\u00e5nekalkylator med formel<\/p>\n<p>Den alternativa versionen av <a href=\"https:\/\/justyy.com\/archives\/3454\" target=\"_blank\" rel=\"noopener nofollow\" class=\"external external_icon\">denna bol\u00e5nekalkylator hittar du h\u00e4r<\/a>.<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">Inspelningsk\u00e4lla:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/helloacm.com\" class=\"external external_icon\">helloacm.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Den enkla bol\u00e5nekalkylatorn implementerad i C\/C++, Javascript och MySQL<\/p>\n","protected":false},"author":1,"featured_media":224427,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[901,922,724],"tags":[1173],"class_list":["post-232073","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-koda","category-oevrig","category-utvecklaren","tag-affiai-sv"],"_links":{"self":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/232073","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/comments?post=232073"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/posts\/232073\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/media\/224427"}],"wp:attachment":[{"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/media?parent=232073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/categories?post=232073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wordpress.mediadoma.com\/sv\/wp-json\/wp\/v2\/tags?post=232073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}