<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Luis Coelho on Medium]]></title>
        <description><![CDATA[Stories by Luis Coelho on Medium]]></description>
        <link>https://medium.com/@data.ramus?source=rss-92a98e320380------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/1*Iy0E9gcTnhKDGSIiDQUEBg.jpeg</url>
            <title>Stories by Luis Coelho on Medium</title>
            <link>https://medium.com/@data.ramus?source=rss-92a98e320380------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 05:54:42 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@data.ramus/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[Rio Grande do Sul Emerges as a Global Tech Hub]]></title>
            <link>https://medium.com/@data.ramus/rio-grande-do-sul-emerges-as-a-global-tech-hub-148ee98d1777?source=rss-92a98e320380------2</link>
            <guid isPermaLink="false">https://medium.com/p/148ee98d1777</guid>
            <category><![CDATA[brazil]]></category>
            <category><![CDATA[ai]]></category>
            <category><![CDATA[economic-growth]]></category>
            <category><![CDATA[economy]]></category>
            <category><![CDATA[investment]]></category>
            <dc:creator><![CDATA[Luis Coelho]]></dc:creator>
            <pubDate>Mon, 16 Sep 2024 23:13:37 GMT</pubDate>
            <atom:updated>2024-09-16T23:13:37.024Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*mueCjOD7MXfYvRjszH-TqA.jpeg" /></figure><p>In a bold move set to transform the digital landscape of Latin America, Scala Data Centers has announced an initial investment of $ 500millions in Rio Grande do Sul (RS), Brazil. This initiative marks the launch of the “Scala AI City,” a state-of-the-art data center campus in Eldorado do Sul, just outside Porto Alegre. With a strong focus on artificial intelligence (AI) and cloud computing, this development highlights RS’s growing importance in the tech world and its strategic vision for the future.</p><h3>A Game-Changing Investment</h3><p>The Scala AI City project will be one of the largest digital infrastructure undertakings in the Southern Hemisphere. The first phase of development will provide a capacity of 54 megawatts (MW), which is seven times greater than the current capacity of data centers in the Porto Alegre area. With room to expand to an astounding 4,750 MW, this project positions RS as a leader not just in Brazil but across Latin America. According to Governor Eduardo Leite, the potential of this investment could eventually reach $ 90 billion, solidifying the state’s position in the global tech ecosystem​.(<a href="https://www.estado.rs.gov.br/com-investimento-inicial-de-r-3-bilhoes-governo-do-rs-e-scala-data-centers-assinam-acordo-para-o-maior-projeto-de-infraestrutu">Portal do Estado do Rio Grande do Sul</a>)​</p><p>This announcement comes as RS recovers from recent natural disasters, making the investment even more significant. Scala’s choice of Eldorado do Sul is strategic, given its low risk of natural disasters and its proximity to Porto Alegre’s existing digital infrastructure. Scala’s new AI-focused data center will be interconnected with its operational data center in Porto Alegre, further enhancing the region’s digital capacity​.(<a href="https://www.infomoney.com.br/business/scala-data-centers-assina-acordo-para-investir-r-3-bilhoes-no-rs/">InfoMoney</a>)</p><h3>Why Rio Grande do Sul?</h3><p>Rio Grande do Sul has long been recognized for its innovative spirit and strong industrial base. With a location that offers unique geographical advantages — connecting Brazil to neighboring countries in the Southern Cone — the state is an ideal hub for technological investments. Its temperate climate also plays a crucial role in supporting energy-efficient data center operations. Scala AI City will use cutting-edge liquid cooling technology, further boosting energy efficiency with a Power Usage Effectiveness (PUE) below 1.2, one of the lowest in Latin America​.(<a href="https://www.datacenterdynamics.com/br/not%C3%ADcias/cidade-de-data-centers-e-anunciada-no-rs-para-responder-a-demanda-de-ia/">Data Center Dynamics</a>)</p><p>Moreover, the state is well-positioned to capitalize on new energy opportunities. Brazil’s abundant supply of renewable energy, including hydro, wind, and solar power, ensures that the Scala AI City will operate sustainably, contributing to global efforts in reducing the carbon footprint of digital operations. Governor Leite emphasized that the project will not only enhance RS’s economy but also help Brazil become a global leader in the AI and cloud sectors​.(<a href="https://www.estado.rs.gov.br/com-investimento-inicial-de-r-3-bilhoes-governo-do-rs-e-scala-data-centers-assinam-acordo-para-o-maior-projeto-de-infraestrutu">Portal do Estado do Rio Grande do Sul</a>)</p><h3>A Catalyst for Economic Growth</h3><p>The Scala AI City is expected to generate more than 3,000 direct and indirect jobs during its first phase, with thousands more as the project expands. This will invigorate the local economy, driving demand across sectors such as construction, energy, and telecommunications. Furthermore, the project will attract other companies and suppliers to the region, creating a robust tech ecosystem.​(<a href="https://oglobo.globo.com/blogs/capital/post/2024/09/depois-da-tragedia-a-inteligencia-artificial-scala-tera-cidade-de-data-centers-no-rs-com-investimento-inicial-de-r-3-bilhoes.ghtml">Globo</a>)</p><p>In addition to economic growth, Scala AI City will place RS at the forefront of innovation in AI. By meeting the growing global demand for data processing and storage, this development will help bridge the gap between Brazil and other leading tech nations.(<a href="https://www.estado.rs.gov.br/com-investimento-inicial-de-r-3-bilhoes-governo-do-rs-e-scala-data-centers-assinam-acordo-para-o-maior-projeto-de-infraestrutu">Portal do Estado do Rio Grande do Sul</a>)</p><h3>A Bright Future for Rio Grande do Sul</h3><p>The Scala AI City marks a monumental step for Rio Grande do Sul and Brazil as a whole. This massive investment underscores the state’s growing importance in the global tech landscape, leveraging its natural resources, skilled workforce, and strategic location to attract cutting-edge technology. As the world moves toward AI-driven economies, Rio Grande do Sul is positioning itself as a key player, leading not only Brazil but all of Latin America into a new digital era.</p><p>The state’s ambitious vision, supported by favorable regulatory environments and an emphasis on sustainability, ensures that Rio Grande do Sul will continue to attract major investments in the tech sector. With Scala Data Centers’ commitment to the region, RS is poised to become a global hub for AI, cloud computing, and digital innovation.</p><p>By embracing the future, Rio Grande do Sul is laying the foundation for long-term prosperity and technological leadership.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=148ee98d1777" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[How to use IF function with in Excel]]></title>
            <link>https://medium.com/@data.ramus/how-to-use-if-function-with-in-excel-eb138905b5e6?source=rss-92a98e320380------2</link>
            <guid isPermaLink="false">https://medium.com/p/eb138905b5e6</guid>
            <category><![CDATA[if-condition]]></category>
            <category><![CDATA[data-analysis]]></category>
            <category><![CDATA[excel]]></category>
            <category><![CDATA[business-analysis]]></category>
            <category><![CDATA[business-intelligence]]></category>
            <dc:creator><![CDATA[Luis Coelho]]></dc:creator>
            <pubDate>Mon, 03 Apr 2023 11:31:44 GMT</pubDate>
            <atom:updated>2023-04-03T11:31:44.386Z</atom:updated>
            <content:encoded><![CDATA[<h3>How to use IF function in Excel</h3><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*Fn1fOrsUnBsz88lf8MIxAQ.png" /></figure><p>I was making a Bike Sales Dashboard for my portfolio and I saw this problem. The Age column had so many ages in the sheet. It is 25 all the way down to 89 and if we are using that type of visualization, it could just get messy. So, I created kind of brackets around these using the <strong>if function</strong> to be make a easier to understand. Now I want to share you how the logic behind it works.</p><p>The IF function is one of the most popular and useful functions in Excel. It allows you to make logical comparisons between a value and what you expect, and return different values depending on whether the comparison is true or false. In this blog post, we will show you how to use the IF function in Excel with some simple examples.</p><p>The basic syntax of the IF function is:</p><p><em>=IF (logical_test, value_if_true, value_if_false)</em></p><h4>Where:</h4><p>- <em>logical_test</em> is the condition you want to test, such as <em>C2&gt;=60</em> or <em>A1=”Yes”</em>.<br>- <em>value_if_true</em> is the value that you want to return if the <em>logical_test</em> is <strong>true</strong>, such as “<strong>Pass</strong>” or <strong>1</strong>.<br>- <em>value_if_false</em> is the value that you want to return if the <em>logical_test</em> is <strong>false</strong>, such as “<strong>Fail</strong>” or <strong>0</strong>.</p><p>For example, if you have a score sheet and you want to display “Pass” if the score is 60 or higher, and “Fail” if the score is lower than 60, you can use the following formula in cell D2:</p><p><em>=IF (C2&gt;=60,”Pass”,”Fail”)</em></p><p>Then you can copy the formula down to apply it to all the scores. You will get something like this:</p><blockquote><em>| Name | Score | Result |<br>| — — — | — — — -| — — — — |<br>| Alice | 75 | Pass |<br>| Bob | 55 | Fail |<br>| Charlie | 82 | Pass |<br>| David | 64 | Pass |<br>| Eve | 59 | Fail |</em></blockquote><p>You can also use other values besides text, such as numbers, formulas, cell references, or even other functions. For example, if you want to calculate the bonus for each employee based on their sales performance, you can use the following formula in cell E2:</p><p><em>=IF (D2&gt;=1000,D2*0.1,0)</em></p><p>This formula says: if the sales amount in D2 is greater than or equal to 1000, then return 10% of that amount as bonus, otherwise return zero. Then you can copy the formula down to get the bonus for each employee. You will get something like this:</p><blockquote>| Name | Sales | Bonus |<br>| — — — | — — — -| — — — -|<br>| Alice | 1200 | 120 |<br>| Bob | 800 | 0 |<br>| Charlie | 1500 | 150 |<br>| David | 900 | 0 |<br>| Eve | 1100 | 110 |</blockquote><p>You can also use nested IF functions to test more than one condition and return different values accordingly. A nested IF function is an IF function inside another IF function.</p><p>The syntax is:</p><p><em>=IF (logical_test1, value_if_true1, IF (logical_test2, value_if_true2, value_if_false2))</em></p><h4><strong>Where:</strong></h4><p>- <em>logical_test1</em> is the first condition you want to test.<br>- <em>value_if_true1</em> is the value that you want to return if <em>logical_test1</em> is <strong>true</strong>.<br>- <em>logical_test2</em> is the second condition you want to test if <em>logical_test1</em> is <strong>false</strong>.<br>- <em>value_if_true2</em> is the value that you want to return if <em>logical_test2</em> is <strong>true</strong>.<br>- <em>value_if_false2</em> is the value that you want to return if <em>logical_test2</em> is <strong>false</strong>.</p><p>For example, if you have a score sheet and you want to assign grades based on the scores, you can use the following nested IF formula in cell D2:</p><p><em>=IF (C2&gt;=90,”A”,IF (C2&gt;=80,”B”,IF (C2&gt;=70,”C”,IF (C2&gt;=60,”D”,”F”))))</em></p><p>This formula says:</p><p><strong>if</strong> the score in <em>C2</em> is <strong>greater than</strong> or <strong>equal to 90</strong>, then <strong>return</strong> “<strong>A</strong>”, otherwise <strong>if</strong> the score in <em>C2</em> is <strong>greater than</strong> or <strong>equal to 80</strong>, then return “<strong>B</strong>”, otherwise <strong>if</strong> the score in <em>C2</em> is <strong>greater than</strong> or <strong>equal to 70</strong>, then return “<strong>C</strong>”, otherwise <strong>if</strong> the score in <em>C2</em> is <strong>greater than</strong> or <strong>equal to 60</strong>, then return “<strong>D</strong>”, otherwise return “<strong>F</strong>”.</p><p>Then you can copy the formula down to get the grades for each student. You will get something like this:</p><blockquote>| Name | Score | Grade |<br> | — — — | — — — -| — — — -|<br> | Alice | 75 | C |<br> | Bob | 55 | F |<br> | Charlie | 82 | B |<br> | David | 64 | D |<br> | Eve | 59 | F |</blockquote><p>As you can see, using the IF function in Excel can help you perform various tasks based on logical conditions. You can also combine it with other functions such as AND, OR, NOT, COUNTIF, etc.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=eb138905b5e6" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>