{"id":1322,"date":"2018-06-20T23:25:08","date_gmt":"2018-06-21T07:25:08","guid":{"rendered":"http:\/\/www.sirknightj.com\/blog\/?p=1322"},"modified":"2018-06-20T23:25:32","modified_gmt":"2018-06-21T07:25:32","slug":"how-monkey-villages-calculate-towerupgrade-costs-btd5","status":"publish","type":"post","link":"https:\/\/www.sirknightj.com\/blog\/2018\/06\/20\/how-monkey-villages-calculate-towerupgrade-costs-btd5\/","title":{"rendered":"How Monkey Villages Calculate Tower\/Upgrade Costs &#8211; BTD5"},"content":{"rendered":"<p>So, recently, when I was working on my BTD5 farm analysis, I wanted to include monkey village calculations. However, I noticed that the description of a monkey village was &#8220;Monkey Village does not attack bloons but instead lowers cost of all towers and upgrades in radius by 10%. Has many useful upgrades that help nearby towers.&#8221;<\/p>\n<p><!--more--><\/p>\n<p>However, I was playing on Hard difficulty, and I noticed that the Farm, which costs $1080 when placed in a monkey village costs me $970. Why is that? Shouldn&#8217;t it cost 90% of $1080, which is $972?<\/p>\n<p>So BTD5 villages work in a weird way. On easy mode, the tower costs are 85% of normal towers. On hard mode, the tower costs are 108% of normal towers&#8230;<\/p>\n<h6>My Realization<\/h6>\n<p>except they&#8217;re not exactly 85% or 108%&#8230; they&#8217;re rounded to the nearest $5.<\/p>\n<p>Villages when doing their calculations also round to the nearest 5. The village charges me $970 instead of $972 for a farm placed in hard mode. The 1-0 upgrade, which costs $325 should cost $292.5, but it&#8217;s also rounded down to $290. It seems that all costs are rounded <strong>down<\/strong> to the nearest 5.<\/p>\n<p>To achieve this in Google Sheets, which I used, I used the rounddown() function.<\/p>\n<p><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\"number\" dir=\"auto\">5<\/span><span class=\" default-formula-text-color\" dir=\"auto\">*<\/span><span class=\" default-formula-text-color\" dir=\"auto\">ROUNDDOWN<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(CELL<\/span><span class=\" default-formula-text-color\" dir=\"auto\">*<\/span><span class=\"number\" dir=\"auto\">0.9<\/span><span class=\" default-formula-text-color\" dir=\"auto\">\/<\/span><span class=\"number\" dir=\"auto\">5<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\"number\" dir=\"auto\">0<\/span><span class=\" default-formula-text-color\" dir=\"auto\">). I multiplied the cost of the tower by 90% to get the 10% discount.<\/span><\/p>\n<p><a href=\"https:\/\/docs.google.com\/spreadsheets\/d\/1OK_hNHGVnzWZaWizeIGBHMW2qMYCQ-pH2Zyt67LAeyA\/\">Here&#8217;s<\/a>\u00a0my BTD5 farm comparison guide.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>So, recently, when I was working on my BTD5 farm analysis, I wanted to include monkey village calculations. However, I noticed that the description of a monkey village was &#8220;Monkey Village does not attack bloons but instead lowers cost of all towers and upgrades in radius by 10%. Has many useful upgrades that help nearby &#8230; <a title=\"How Monkey Villages Calculate Tower\/Upgrade Costs &#8211; BTD5\" class=\"read-more\" href=\"https:\/\/www.sirknightj.com\/blog\/2018\/06\/20\/how-monkey-villages-calculate-towerupgrade-costs-btd5\/\" aria-label=\"More on How Monkey Villages Calculate Tower\/Upgrade Costs &#8211; BTD5\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[42],"tags":[],"acf":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.sirknightj.com\/blog\/wp-json\/wp\/v2\/posts\/1322"}],"collection":[{"href":"https:\/\/www.sirknightj.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sirknightj.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sirknightj.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sirknightj.com\/blog\/wp-json\/wp\/v2\/comments?post=1322"}],"version-history":[{"count":2,"href":"https:\/\/www.sirknightj.com\/blog\/wp-json\/wp\/v2\/posts\/1322\/revisions"}],"predecessor-version":[{"id":1324,"href":"https:\/\/www.sirknightj.com\/blog\/wp-json\/wp\/v2\/posts\/1322\/revisions\/1324"}],"wp:attachment":[{"href":"https:\/\/www.sirknightj.com\/blog\/wp-json\/wp\/v2\/media?parent=1322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sirknightj.com\/blog\/wp-json\/wp\/v2\/categories?post=1322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sirknightj.com\/blog\/wp-json\/wp\/v2\/tags?post=1322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}