productivity

ONTO THE OTHER

ONTO THE OTHER

Hey everyone, I got super busy with a lot of stuff, but I am back! So, where were we? Ah yes, check out the progress I made in the past two hours. I wanted to update you all as soon as possible (image1). (image1) Yes, I know it looks like a Mario tube right now, and you're probably thinking, "What in the world is this?" Basically, I want to attach the actual head of the turret onto this thing. Remember how I wanted to make this a rail gun and showed a picture of how I wanted it to look?…
Read More
In Excel, Parse Hexadecimal Numbers And Make Queries

In Excel, Parse Hexadecimal Numbers And Make Queries

Problem description & analysis: In the following table, value of cell A1 is made up of names of several people and their attendances in four days. For example, c is 1100 expressed in hexadecimal notation, meaning the corresponding person has attendance in the 1st day and the 2nd day and is absent in the 3rd day and the 4th day. We need to find the number of people who has the attendance in the day input in A2. For example, three people are present in the 1st day and two people are present in the 3rd day. Solution: Use SPL…
Read More
The Body Shop of Security: Biometrics

The Body Shop of Security: Biometrics

Introduction Biometrics is a physical security technique that makes use of a person's physical characteristics which are unique to that person.This technique is used to authenticate the user's identity and grant access to the certain things. It is a kind of personal touch for authentication which can only be done by the genuine user. Types of Biometrics _Physiological : _ Physiological Biometrics is based on a person's body's unique features like fingerprints, facial recognition, iris scan, etc. This system of authentication is difficult to forge as compared to passwords. This type of security will remain constant throughout the person's life…
Read More
Understanding Microservices: A Technical Overview

Understanding Microservices: A Technical Overview

Since the end of 2017, the term "microservices" has become increasingly common. But what exactly are microservices? "Microservices are small, autonomous services working together to meet a specific demand." or "Independent services that together compose a single system." To clarify, microservices represent a software architecture, not merely a web service. As many systems and applications grow, it becomes increasingly challenging to implement changes. A simple change can necessitate a massive deployment. With luck, a deployment pipeline can ensure everything functions correctly before going live. We are moving towards a scenario where we use physical servers for deployment. Now imagine deploying…
Read More
Case Study – TDD in Node.js Inspector Server and Other Projects

Case Study – TDD in Node.js Inspector Server and Other Projects

Overview Test Driven Development (TDD) is a software development methodology where tests are written before the actual code. The progress of implementation is then guided by the status of these tests. There is often confusion between the terms "automated testing," "unit testing," and "TDD." To clarify: Automated Testing refers to any testing performed by specialized software without requiring manual intervention. This includes various types of testing, depending on the scope (unit/integration) or the metrics being evaluated (correctness, security, load, benchmarking). Unit Testing is a subset of automated testing that focuses on the smallest, independent logical units of code. These tests…
Read More
In Excel, Identify Data Layers Correctly and Convert Them to a Standardized Table

In Excel, Identify Data Layers Correctly and Convert Them to a Standardized Table

Problem description & analysis: Data in the column below has three layers: the 1st layer is a string, the 2nd layer is a date, and the 3rd layer contains multiple time values: A 1 NAME1 2 2024-06-03 3 04:06:12 4 04:09:23 5 08:09:23 6 12:09:23 7 17:02:23 8 2024-06-02 9 04:06:12 10 04:09:23 11 08:09:23 12 NAME2 13 2024-06-03 14 04:06:12 15 04:09:23 16 2024-06-02 17 12:09:23 18 17:02:23 Enter fullscreen mode Exit fullscreen mode We need to identify the three layers of data correctly and convert them to a standardized table: D E F 1 NAME1 2024-06-03 04:06:12 2…
Read More
In Excel, Insert Group Headers to Detail Data Rows in Each Group

In Excel, Insert Group Headers to Detail Data Rows in Each Group

Problem description & analysis The Excel worksheet below contains multiple vertical subtable groups, which are separated by a blank row. In each group, the 2nd cells of both row 1 and row 2 contain subtable group headers and row 3 contains column headers; there isn’t detailed data in either the 1st column or the 6th column: A B C D E F 1 ATLANTIC SPIRIT 2 Looe 3 Vessel Species Size Kg Date Location 4 POLLACK 2 2.5 23/04/2024 5 POLLACK 3 18.8 23/04/2024 6 POLLACK 41 5.4 23/04/2024 7 LING 3 1.9 23/04/2024 8 WHITING 2 0.4 23/04/2024 9…
Read More
No widgets found. Go to Widget page and add the widget in Offcanvas Sidebar Widget Area.