invest | InVEST : models that map and value the goods and services | Map library

I have 4 arrays of data where I need a some product but with few conditions.

I'm unable to solve that and I'm not good at creating VBA functions as well.

Can anyone please help?

Apologies for the lack of clarity.

I'll try to give more details here. Please refer the below workbook.

https://drive.google.com/file/d/1XVEe4Sjw6ZeAh-7jyeLDs7Tp5RRQD20i/view?usp=sharing

Investment value is Row 2 * Row 3. This value is carried across all the months after amortization given in row 4. 5th row is converting the yearly value into monthly value (1/12).

So, in the first month 50 is invested and the value at the beginning of the month after amort of 100%, So 50 is available for month 1. This is further converted into monthly values with the help of row 5. So, the result for month 1 will be 100 * 50% * 100% * 8.33% = 4.1667 [Cell I9]

For the month 2, the value available is,

Value carried from month 1 after amort (100 * 50% * 99%) + New amount in month 2 (102 * 50% * 100%)

The above value is converted into the monthly value again with the help of row 5.

Result for month 2 => Cell I10 = (100 * 50% * 99% * 8.33%) + (102 * 50% * 100% * 8.33%) = 8.375

Similarly, for month 3 the value will be,

Month 1's investment (100*50%*98%*8.33%) + Month 2's investment (102*50%*99%*8.33%) + Month 3's investment (104*50%*100%*8.33%)

I need the above calculation to happen in single cell for all the months. I tried sumproduct with offset. But I couldn't.

find the code attached below, so the ReadCBOE function reads information from investing.com and saves it to string str, Update news function then analyzes the information obtained from ReadCBOE and stores it into relevant arrays, the code is running without any errors just cant figure out why information is not being stored correctly into the arrays. ps the same code works perfectly on mt4

I am working on a project in R. I created a data frame for the table of all projects implemented by an Institutions. The data frame table includes a Country column with a name of the country in which the project is implemented

looks something like this with more than 20,000 rows

I'm running several machine learning models to find the one which the highest accuracy score, however, all the accuracy scores are the exact same. I performed NLP on social media text and I'm training my models to tag sentiment based on sentiment determined from NLTK.

I'm using the same training and test sets, but I've done this method before in the past and received different scores on different models. Why are all of mine the same? Am I overfitting perhaps?

Here is my code where I'm splitting and training:

Currently doing a project for a course in C++, where I need to make a table of a deposited amount, interest earned on the amount, and total interest earned increased by each year.

I'm not getting the output I'm looking for. It just gives me the same output for each year. I am sure my problem lies in my for loop statements, but I need a fresh set of unbiased eyes as I am new to this. first is .cpp

I am getting the error

1. I am seeking to understand why my code doesn't work, please explain the logic behind my algorithm being flawed.

2. why on the solution code the nested-if statement knows to continue adding from the loss on day 7 on without specifing to add the investment amount.

You put 1000 dollars into a new cryptocurrency. Good luck!
Over ten years, the value of the investment increases by 5% each year.
In the seventh year, the investment loses 75% instead of increasing. Eeek!
Use a for loop to log how many years it has been and how much the investment is worth for each year.

let investment = 1000;

/// MY SOLUTION ///

I'm trying to map trough my context in React but it won't render anything. (No error messages either). My app is wrapped with the context provider.

My context

I am deploying an API made using Go and MySQl for the database to Heroku. I am following this guide on it and set up everything but now I am trying to execute a MySQL script to set up the tables with some dummy data. But I am constantly getting errors saying that the script is wrong even though I have used it locally with no issues. I have already connected the MySQL database to the Heroku environment and starting the database throws no errors.

Here are the logs showing the error when deploying it to Heroku: