The financial year ended in March and everyone with taxable income must file IT returns by July this year. I opened a new bank account last year and it came with a new demat (share-trading) account. Rather than just shovel numerous lists of transactions from my bank and demat accounts to my tax consultant, I decided to put all that data in one spreadsheet before sending it to him.
My experience with spreadsheets ended with Lotus 1-2-3 in the 90s so working with Calc threw several challenges. Here is how I addressed them.
IF function — for conditional formulae
Some fixed deposits make interest payments at a regular interval (monthly, quarterly, half-yearly or yearly) while others pay cumulative interest only at maturity. How do I make a column for monthly interest payments for a list that contains both types of deposits? If the amount paid back by a fixed deposit at maturity is the same as the amount invested at the beginning, then it would have paid interest at regular intervals. If the amount paid back at maturity is much greater than the amount invested at the beginning, then obviously, it must be a cumulative fixed deposit.
In Figure 1, the F column contains formulae with the IF function. The monthly payout is calculated only if the pay-in and payout are the same.
In Figure 2, the E column shows the source of the gold ornament and the B column gives its weight. Using the SUMIF function, I can add the weights in the B column if the corresponding values in the E column equal a particular type of source. This can be done using the search criterion as either “=Own” or “=Parents”.
VLOOKUP function — for values from a lookup table
Diese Geschichte stammt aus der August 2024-Ausgabe von Open Source For You.
Starten Sie Ihre 7-tägige kostenlose Testversion von Magzter GOLD, um auf Tausende kuratierte Premium-Storys sowie über 8.000 Zeitschriften und Zeitungen zuzugreifen.
Bereits Abonnent ? Anmelden
Diese Geschichte stammt aus der August 2024-Ausgabe von Open Source For You.
Starten Sie Ihre 7-tägige kostenlose Testversion von Magzter GOLD, um auf Tausende kuratierte Premium-Storys sowie über 8.000 Zeitschriften und Zeitungen zuzugreifen.
Bereits Abonnent? Anmelden
Not Investing in a Cloud Security Program can be Expensive
A well-planned cloud security program serves as the primary barrier against security breaches, protecting both the company's assets and its reputation. It's a crucial component that supports an organisation's overall health and in a world with more advanced cyber threats, it helps meet the basic compliance standards that stakeholders expect.
Cutting Costs, Not Corners: Building Large Scale Applications with Open Source Software
Here are some strategies and best practices for leveraging open source to create enterprise-grade web and mobile applications without sacrificing quality or functionality.
FIDO2 and WebAuthn: Ensuring Secure User Authentication
In today's digital landscape, securing online identities is more crucial than ever. Traditional passwords are no longer sufficient to protect sensitive information, which is where advanced passwordless authentication mechanisms like FIDO2 and WebAuthn come into play. These technologies offer a powerful solution for secure user authentication in a browser-based environment.
Aspiring to be a DevOps Engineer? Here are a Few Tips
Organisations are embracing DevOps in software development to ensure quality products are delivered faster. This fast-growing domain offers a range of career opportunities for those willing to learn. You can enrol for one of the many industry-recognised certifications and then gain experience through internships and entry-level positions.
GitHub Actions: Accelerating DevOps Adoption
The integration of DevOps practices has become crucial for achieving rapid, reliable, and high-quality software delivery. GitHub Actions, an automation tool provided by GitHub, significantly contributes to this process by streamlining and automating various stages of the software development lifecycle. Let's find out how it can accelerate DevOps adoption.
DevOps in a Nutshell
This overview takes you down the path of DevOps development, its benefits and drawbacks as well as the resources you may need to become an expert in this field. It explains the roles of a DevOps professional and why they are in demand.
The DevOps Guide: Trends, Tools, Skills, and Career Opportunities
In today's fast-paced digital world, DevOps is crucial for software development and IT operations. By fostering collaboration and automating processes, it aims to deliver high-quality software quickly and reliably. Let's explore the latest trends in DevOps, essential tools, required skills, career opportunities, and the future of this transformative practice.
AlOps: Integrating AI with DevOps
By integrating AI with DevOps, we can harness the power of both technologies to quicken the development of quality software. Open source DevOps tools now come with AI integrated in them to automate the software development lifecycle and enhance security features.
Getting Started on Contributing to Free Software
Interested in contributing to free and open source software but wondering where and how to begin? Dive in to find out...it's quite simple.
AI Services in Microsoft Azure: Designed to Help
Microsoft's Azure AI services enable optimised operations in industries as varied as retail, healthcare, manufacturing, finance, education, and media.