Some Cool Calc Tricks for Indian Taxpayers
Open Source For You|August 2024
If you do not consider yourself a Calc or Excel expert but must do your taxes in a spreadsheet, then these cool tricks can help you a great deal.
V.Subhash
Some Cool Calc Tricks for Indian Taxpayers

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

この記事は Open Source For You の August 2024 版に掲載されています。

7 日間の Magzter GOLD 無料トライアルを開始して、何千もの厳選されたプレミアム ストーリー、9,000 以上の雑誌や新聞にアクセスしてください。

この記事は Open Source For You の August 2024 版に掲載されています。

7 日間の Magzter GOLD 無料トライアルを開始して、何千もの厳選されたプレミアム ストーリー、9,000 以上の雑誌や新聞にアクセスしてください。

OPEN SOURCE FOR YOUのその他の記事すべて表示
Helgrind: Detecting Synchronisation Issues in Multithreaded Programs
Open Source For You

Helgrind: Detecting Synchronisation Issues in Multithreaded Programs

Let's explore how Helgrind can be used to detect and debug multithreading issues with the help of a multithreaded C program.

time-read
3 分  |
November 2024
The Perfect Process of Booting a PC
Open Source For You

The Perfect Process of Booting a PC

Booting a PC seems as simple as eating a cake. But are you aware of all that goes on behind-the-scenes to bake a delicious cake or seamlessly boot a PC?

time-read
3 分  |
November 2024
Exploring eBPF and its Integration with Kubernetes
Open Source For You

Exploring eBPF and its Integration with Kubernetes

eBPF, a game-changing technology that extends the capabilities of the Linux kernel, offers significant advantages for Kubernetes networking. It also greatly improves Kubernetes observability by capturing detailed telemetry data directly from the kernel. Read on to find out how its integration with Kubernetes has immense benefits.

time-read
5 分  |
November 2024
Deploying Generative AI LLMs on Docker
Open Source For You

Deploying Generative AI LLMs on Docker

Built on massive datasets, large language models or LLMS are closely associated with generative Al. Integrating these models with Docker has quite a few advantages.

time-read
8 分  |
November 2024
Containerisation: The Cornerstone of Multi-Cloud and Hybrid Cloud Success
Open Source For You

Containerisation: The Cornerstone of Multi-Cloud and Hybrid Cloud Success

Open source containerisation software provides the flexibility, cost-effectiveness, and community support needed to build and manage complex multi-cloud and hybrid cloud environments. By leveraging this software, businesses can unlock the full potential of multicloud and hybrid cloud architectures while minimising vendor lock-in risks.

time-read
3 分  |
November 2024
From Virtual Machines to Docker Containers: The Evolution of Software Development
Open Source For You

From Virtual Machines to Docker Containers: The Evolution of Software Development

Containerisation and Kubernetes have eased software development, making it faster and better. Let's see where these are headed, looking at trends that are making life easier for developers.

time-read
10+ 分  |
November 2024
India's Leap in Supercomputing: Innovating for Tomorrow
Open Source For You

India's Leap in Supercomputing: Innovating for Tomorrow

As India strides towards self-sufficiency in supercomputing, embracing this evolution isn't just an option-it is pivotal for global competitiveness and technological leadership.

time-read
5 分  |
November 2024
SageMath: A Quick Introduction to Cybersecurity
Open Source For You

SageMath: A Quick Introduction to Cybersecurity

In the previous articles in this SageMath series, we delved into graph theory and explored its applications using SageMath. In this seventh article in the series, it is time to shift our focus to another crucial subfield of computer science: cybersecurity and cryptography.

time-read
10+ 分  |
November 2024
Efficient Prompt Engineering: Getting the Right Answers
Open Source For You

Efficient Prompt Engineering: Getting the Right Answers

OpenAl's GPT-3 and GPT-4 are powerful tools that can generate human-like text, answer questions, and provide insights. However, the quality of these outputs depends heavily on how you frame the input, or prompt. Efficient prompt engineering ensures you get the right answers by designing inputs that guide the AI towards relevant, clear, and useful responses. Let's find out how to craft effective prompts with examples.

time-read
4 分  |
November 2024
Analysing Linus Torvald's Critique of Docker
Open Source For You

Analysing Linus Torvald's Critique of Docker

This article looks at Docker's security flaws, particularly its shared-kernel model, and contrasts it with traditional VMs for better isolation. It discusses Linus Torvalds' concerns, explores mitigation techniques, and proposes a roadmap for building a more secure containerisation platform using hardware-assisted virtualisation, true isolation, and a robust orchestration layer.

time-read
8 分  |
November 2024