Generating a stacked array using JavaScript

Question

Generating a stacked array using JavaScript

I have an original two-dimensional array representing the full budget for each year, as shown below:

budget = [['2001-01-01', 100], ['2001-01-02', 110], ... , ['2001-12-31', 140]]

Now I want to create subarrays of the budget for specific projects. For example:

project1 = [['2001-01-01', 10], ['2001-01-02', 11]]

This indicates that the project spans 2 days and utilizes 10% of the available budget.

The following function is used to create project arrays:

project1 = [[]];
project1 = new_project(budget, 0, 1, 0.1);

function new_project(origin, start, end, factor) {
    var result = [[]];
    result = origin.slice(parseInt(start), parseInt(end)).map(function (item) {
        return [item[0], parseInt(item[1]) * factor]
    });
    return result;
}

Issue

How can I update my budget array by subtracting the values of the created projects? I need to adjust the budget dynamically using new_project in order to achieve:

budget = [['2001-01-01', 90], ['2001-01-02', 99],..., ['2001-12-31', 140]]

jsfiddle link

http://jsfiddle.net/gcollect/7DAsL/

javascript arrays multidimensional-array slice

Answer 1

Answer №1

If you want to update the values in a budget array based on another subset array (like project1), you can utilize the built-in array method forEach(). Here's a custom function called decreaseBudget() that does just that:

function decreaseBudget(original, subset) {
    // Iterate through each item in the subset.
    subset.forEach(function(item, index){
        // Retrieve the original amount from the corresponding item in the original array.
        var originalItemAmount = original[index][1];
        // Update the amount in the original array by subtracting the amount from the subset.
        original[index][1] = (originalItemAmount - item[1]); 
    });
};

To apply this function, pass in the budget and project1 arrays as arguments. This will modify the values within the budget array. You can check out the updated fiddle for reference: http://jsfiddle.net/7DAsL/4/

If you'd rather not alter the original array and prefer to work with a copy, you can use the .slice() method to create a shallow duplicate of the original array. Make changes to this copy inside the decreaseBudget() function and return it instead.

Answer 2

If you want to update the values in a budget array based on another subset array (like project1), you can utilize the built-in array method forEach(). Here's a custom function called decreaseBudget() that does just that:

function decreaseBudget(original, subset) {
    // Iterate through each item in the subset.
    subset.forEach(function(item, index){
        // Retrieve the original amount from the corresponding item in the original array.
        var originalItemAmount = original[index][1];
        // Update the amount in the original array by subtracting the amount from the subset.
        original[index][1] = (originalItemAmount - item[1]); 
    });
};

To apply this function, pass in the budget and project1 arrays as arguments. This will modify the values within the budget array. You can check out the updated fiddle for reference: http://jsfiddle.net/7DAsL/4/

If you'd rather not alter the original array and prefer to work with a copy, you can use the .slice() method to create a shallow duplicate of the original array. Make changes to this copy inside the decreaseBudget() function and return it instead.

Answer 3

Answer №2

Here is the solution I found: http://jsfiddle.net/gcollect/7DAsL/2/

Problem solved!

    function create_new_project(base, begin, finish, multiplier) {
        var finalResult = [
            []
        ];

        finalResult = base.map(function (element) {
            return [element[0], (element[1] * multiplier)]
        });
        for (var index = 0; index < finalResult.length; index++) {
            base[index][1] = parseInt(base[index][1]) - parseInt(finalResult[index][1]);
        }
        finalResult = base.slice(parseInt(begin), parseInt(finish));
        return finalResult;

    };

Answer 4

Here is the solution I found: http://jsfiddle.net/gcollect/7DAsL/2/

Problem solved!

    function create_new_project(base, begin, finish, multiplier) {
        var finalResult = [
            []
        ];

        finalResult = base.map(function (element) {
            return [element[0], (element[1] * multiplier)]
        });
        for (var index = 0; index < finalResult.length; index++) {
            base[index][1] = parseInt(base[index][1]) - parseInt(finalResult[index][1]);
        }
        finalResult = base.slice(parseInt(begin), parseInt(finish));
        return finalResult;

    };

Generating a stacked array using JavaScript

Issue

jsfiddle link

Answer №1

Answer №2

Problem solved!

Similar questions

Leveraging ES6 modules within JavaScript for exporting uncomplicated variables

Experiencing a Node.js application issue with the error message "ERR

"Enhance Your XYChart with a Striking Background Image Using Amchart

Press anywhere on the screen to conceal the AngularJS element

How to iterate over an array and assign values to distinct labels using AngularJS

The jQuery element selection feature is not functioning

I'm struggling to solve a straightforward jQuery sliding issue

Utilizing ng-model with invisible input field

What steps should be taken to activate eslint caching?

My page is experiencing delays due to setInterval

Are there any methods to alter the current preFilters within jQuery?

Tips for utilizing the Toggle Slider JS functionality

No duplication of Collada material present

Looking to update table content dynamically using jQuery ajax?

Using a local function within Node.js and referencing it with the <%%> tag in a document

Issue with Foundation 6 not triggering the change.zf.slider event

What is the best way to format a date input field so that when a user enters a year (yyyy), a hyphen (-

Receiving input from the user for a 2-D array in a specified format

Error: Uncaught TypeError - Unable to assign a value to the 'status' property

Interactive Google Maps using Autocomplete Search Bar