Dynamic-array | Implementation of dynamic arrays in C | Game Engine library

(* this question is one step further to this question. *)

I have the following table on the left with several rows and columns as input.

I would like to obtain a table on the right by formulas.

Ideally, I'm looking for one or more dynamic array formulas in J3, K3 and L3, which take D3:G3, C4:C6, and D4:G6 (or C3:G6) as arguments.

A solution with LAMBDA function would be second best (though you could still propose one), because not everyone is using beta channel.

Could anyone help?

The company I work for has recently moved from Office 2016 to M365. Some of our macro-enabled spreadsheets use bracketed expressions as a shortcut to the Application.Evaluate method. For example:

This challenge from hackerRank that I was working on successfully compiles with the test run and gives out correct answers with all sorts of input. But when I submit and the code is run with enormous amount of digits like so, I get a segmentation fault.

My best guess is that I am making some sort of mistake while allocating memory to the dynamic 2D array.

Since all my test runs have successfully compiled and given out a correct result I have no idea why it would not work.

I am solving this problem on dynamic array in which input first line contains two space-separated integers,n, the size of arr to create, and q, the number of queries, respectively. Each of the q subsequent lines contains a query string,queries[i]. it expects to return int[]: the results of each type 2 query in the order they are presented.

i tried to attempt as below and my code seems fine to me but it gives segmentation fault error. please help me where I am getting conceptually wrong. thanks.

problem: Declare a 2-dimensional array,arr , of n empty arrays. All arrays are zero indexed. Declare an integer,last answer , and initialize it to zero.

There are 2 types of queries, given as an array of strings for you to parse:

Query: 1 x y

Let idx=((queries[i][1]^last_answer)%n);. Append the integer y to arr[idx].

Query: 2 x y

Let idx=((queries[i][1]^last_answer)%n);. Assign last_answer=arr[idx][queries[i][2]%(arr[idx].size())] . Store the new value of last_answer to an answers array.

input: 2 5

1 0 5

1 1 7

1 0 3

2 1 0

2 1 1

output:

7

3

Is implementing an array class using ctypes more efficient than using lists? Implementation

I just stumbled upon the fact that we can dynamically create arrays without 'new' (Dynamic array without new (C++)). For example, this is possible:

I'm using named ranges extensively in my workbook, but now find that they are not a simple substitute for regular ranges in the case of the AND function. In that case the formula is no longer "spilled" over to subsequent rows and only 1 value is calculated. How can I fix that behavior?

This is my dummy data:

I want to check if both colu1 and colu2 are not equal to zero. Checking this for a single column works as expected.

Formula's (the formula "spills" over by itself, I don't have to drag it down) on the left and result on the right:

Checking both columns at the same time in an AND formula fails:

Formula's (in this case the formula does not "spill" anymore) on the left, result on the right:

I've been retooling some older spreadsheet tools for filtering and formatting dynamic data outputs using Excel's newer Dynamic Array Formulas functionality. This has been helping remove some of the need for pre-allocating cells and lower amounts of helper columns (which has allowed for reduced file sizes and snappier performance).

One function type I am struggling to replace is pulling out dynamic, running duplicate counts.

For instance, say I have a column B of 20 names that can vary in length from a handful to say 200 names. There is also related data in columns C, D, etc that similarly varies in size. For use of filtering the Data in the later columns, we currently use a helper column in A consisting of the running count of the duplicates in A with a formula using semi-anchored ranges(ie. Beginning the range with an anchored cell that expands as the formula is copied down the helper column akin to the solution here with CountIf() and a semi-anchored range). The drawback here vs the new dynamic array formulas is that the helper column needs to be pre-allocated for the data.

Despite attempts with Index(), Aggregate(), Filter(), and a few more involved notations like Sumproduct(--(...)), the most straightforward method I can find to make helper column A seems to be by creating the running count via semi-anchored ranges, which unfortunately does not seem to translate well to the new dynamic array Formulas.

Has anyone had any luck adapting the use of semi-anchored ranges and formulas for use in dynamic array formulas?

I have a DynamicArray class shown below. (I have only included relevant methods. The rest can be viewed from https://www.geeksforgeeks.org/implementation-of-dynamic-array-in-python/)