productivity - CybAI news

15 Aug

#45 — Copy Each Row N Times (N Is The Cell Value of The Specified column)

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis:In the Excel table below, each row is a product, and the 3rd column is the quantity of the product. Task: Copy each row N times (N is the cell value of the 3rd column) and display values in the original 3rd column as empty. The expected result is as follows: Solution:Use SPL XLL to do this: =spl("=?.conj(~3 * [~]).run(~3=null)",A2:F9) Enter fullscreen mode Exit fullscreen mode As shown in the picture below: Explanation:conj()function concatenates members of a sequence. run() function modifies a sequence. “Integer N* a sequence” means copying members of a sequence N times. Source link…

13 Aug

#44 — Group Rows And Combine Non-Null Values in Each of The Non-Grouping Columns

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis: In the Excel table below, the 1st column is the category; columns from the 2nd to the 42nd are parallel columns of data items (below only shows some of the columns), where there are two types of values – X and null. Occasionally, there are duplicate values in a column under the same category. Task: Group rows and combine values in each column in each group; only display one of the duplicate values if there are any. Solution: Use SPL XLL to do this: =spl("=?.group(~1).(g=~,(r1=~1).(g.(~(r1.#)).ifn()))",A2:E11) Enter fullscreen mode Exit fullscreen mode As shown in the picture…

12 Aug

Creating Envless Angular-application

stp2y0 CommentsNewsangular, cicd, coding, community, development, devops, engineering, inclusive, productivity, software

Ways to move from hard-coded code for each environment to a universal build that can be used anywhere Introduction As you all know, Angular has its own tools for building an application for different environments Configuring application environments This is accomplished by creating and using the environment.<env>.ts file for the appropriate environment in the build. These allow you to switch between settings for: Development (environment.ts) Testing (environment.test.ts) Production (environment.prod.ts) The main tasks of environment.ts files are: API settings. Each file can contain different URLs for API servers depending on the environment. Optimization. The production file disables debugging features and enables…

11 Aug

I Changed My Mind – NixOS is NOT the Best Linux

stp2y0 CommentsNewsarchlinux, coding, community, development, engineering, inclusive, Linux, nixos, productivity, software

Well I didn't expect to be writing this post, ever. Most of my posts on here have just been NixOS and praising its glory to all but recently I have been greatly disliking NixOS more and more. But what does this mean for you? It could mean nothing, or it could mean everything... NixOS Pros I can't say NixOS isn't great, it has so many amazingly useful features that just make using Linux so much easier. All packages are version locked. (Easy to roll back versions) All package dependencies are per package so version conflicts are prevented. Thousands of services…

09 Aug

Benefits of Training & Development for Employees

stp2y0 CommentsNewscoding, community, development, efficiency, engineering, inclusive, productivity, software, training

In today's fast-paced business world, the success of a company depends heavily on the skills and knowledge of its employees. Training and development programs are essential tools that companies use to enhance these skills and ensure their workforce is equipped to handle the challenges of their roles effectively. Let's explore why training and development are crucial for both employees and organizations. Improved Skills and KnowledgeTraining programs are designed to teach employees new skills and update their knowledge. This includes technical skills related to their job tasks, like using software or machinery, as well as soft skills such as communication, teamwork,…

04 Aug

Function Decorators in Python

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, python, software, womenintech

Writing dry code is important. DRY is a handy acronym meaning Don't Repeat Yourself. Dry code is more legible and easily understood by others, making you a better developer! Dry code avoids boilerplate code, which is code that is written again and again without much change. Decorators are a powerful resource for developers wanting to write dry code in Python. A decorator is a way to package code into a reusable function. They can be used before functions, classes, or methods. In this post, we'll be covering function decorators. A decorator is a function that takes another function as an…

04 Aug

Is Web development oversaturated

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, learning, productivity, programming, software, webdev

I signed up for various freelance websites and what I realized is web development is extremely over-saturated, some jobs would get posted and literally 1 minute later 35 Indian proposals with the minimum price from people who barely speak English and didn't even read the job description I couldn't even get a job because by the time I finished reading the job requirements which takes like 3 minutes the number of proposals is over 50. I read a few comments on reddit about how a ton of people are getting into CS, mass immigration from countries where everyone is into…

01 Aug

#37 — Replace Duplicate Items with The Specified Text

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis: In the Excel table below, the 1st column contains sequence numbers and the 2nd column has duplicate values. Task: Record the value appearing for the first time in the 2nd column and replace its duplicates with the string "cont.". Solution: Use SPL XLL to enter the following formula: =spl("=((d=E(?))d.group@1(Date)).(Date=$[cont.]),d",A1:B8) Enter fullscreen mode Exit fullscreen mode As shown in the picture below: Explanation: E() function converts the data range to a two-dimensional table. group@1 groups rows and retrieves the 1st row of each group. The operator finds the difference of two sets. Source link lol

31 Jul

No Matter How You Do It, Build Things

stp2y0 CommentsNewscoding, community, development, engineering, inclusive, productivity, software

Lets hit on an interesting point about the "demystification" of expertise. The trues is that, a lot of people who are good at something are reluctant to share their knowledge, especially if it means making their skills seem less special. The Paradox of Expertise: Reluctance to Share: It's a common phenomenon. People who've spent years honing their skills might feel threatened by the idea of making those skills accessible to others. It's like giving away a secret weapon. The Illusion of Complexity: Sometimes, the "magic" of a skill is in the perception of its complexity. When you break it down,…

30 Jul

#36 — Match The First Part of The Cell Value

stp2y0 CommentsNewsbeginners, coding, community, development, engineering, inclusive, productivity, programming, software, tutorial

Problem description & analysis:An Excel worksheet has multiple columns of source data that contains empty cells, as the following range C3:D19 shows. It also contains data items, which are separated into two parts by “-”, used for comparisons, as range F3:F7 shows. Task: Compare each column of the source data with the first part of the data item, and after each column of data, list all matching data items, as shown below: Solution:Use SPL XLL to do this: =spl("=d=transpose@n(?1),transpose@n(d.(E@1(?2).select(d.~.pos(substr@l(~,$[-])))))",C3:D19,F3:F7) Enter fullscreen mode Exit fullscreen mode As shown in the picture below: Explanation:transpose@n function transposes a sequence. E@1 convers a multilayer…