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 以上の雑誌や新聞にアクセスしてください。
すでに購読者です? サインイン
Amazon Bedrock: A Boon for the Financial Services Industry
Amazon Bedrock is a fully managed service that provides access to foundation models from top AI providers, enabling organisations to build and scale generative AI applications. It is specifically designed to bring AI solutions to the financial sector. Let's explore all that it can do...
Quantum-Safe VPNs: The Future of Secure Communication
As quantum computing continues to advance, it poses a significant threat to traditional cryptographic algorithms that secure our digital communications. Virtual private networks (VPNs), which rely heavily on encryption, are particularly vulnerable. Quantum-safe VPNs utilise post-quantum cryptographic algorithms to protect against quantum attacks.
Popular Open Source Toolkits for Quantum Machine Learning
Quantum machine learning is becoming increasingly popular due to its ability to solve the complex problems of the AI age. Here are a few open source libraries and frameworks that help with quantum computations.
Quantum Computing: Harnessing Open Source for Innovation and Accessibility
We explore how open source initiatives are shaping the future of quantum computing, making it more accessible and driving innovation through collaboration.
How Quantum Computing Differs from Classical Computing
Despite being in its infancy, quantum computing has numerous potential applications in modelling, cybersecurity, AI/ML, and other fields. But how do quantum and classical computing compare with each other? Let's find out...
From Bits to Qubits: The Growth Story of Quantum Computing
Quantum computing may still be in the early stages of evolution, but its potential impact on everyday life is significant. We delve into the key concepts behind it, the reasons for its rapid growth, and how global advancements are shaping its future.
Pytket: A Comprehensive Guide to Quantum Circuit Design
Pytket stands out as a powerful toolkit in the realm of quantum computing, offering a suite of features that cater to both researchers and industry practitioners. Its key strengths include optimisation, platform-agnostic support, flexible quantum circuit design and hybrid algorithm support. These features make Pytket a versatile tool for various quantum computing applications, from machine learning and cryptography to optimisation problems in industrial settings.
Cirq: The Open Source Framework for Programming Quantum Computers
Explore the key features, capabilities, and impact of Cirq, an open source quantum computing framework developed by Google, on the quantum programming landscape.
The Role of Open Source in Accelerating Quantum AI
Here's an overview of how open source frameworks are being utilised to build quantum machine learning models, including quantum neural networks and quantum kernel methods. The challenges and future directions in the quantum AI landscape are also discussed.
Quantum Machine Learning: An Overview
Quantum machine learning (QML) is a burgeoning field at the intersection of quantum computing and artificial intelligence. In recent years, the integration of quantum mechanics with machine learning algorithms has sparked substantial interest among researchers and technologists alike. Here's a quick look at the essentials of creating quantum algorithms for AI models, their practical use cases on open source platforms, and best practices for implementing these advanced algorithms.