Nsryjdtyk

I am working on matlab with a file composed of units requested in different days (orders of products). The file that can be found in the next link:File

It has 4 columns. The second and fourth show the day and number of units respectively. This file has 3000 rows and I would like to do this task for all the entire rows in the file. The main task of the code I will show consist of filling column 6 with 1 every time the value calculated in column 5 is below 300. The column 5 shows the reduction of volume of units that initially is 1000. I will show with the next code:

clear

%Data

File='File.csv';

dataf=csvread(File, 1);

unbl=0;

dataf=[dataf zeros(size(dataf,1),1) zeros(size(dataf,1),1)];

%Loop by pieces

for i=1:size(dataf,1)

    if i==1

        dataf(i,5)=1000-dataf(i,4);

    else

        dataf(i,5)=dataf(i-1,5)-dataf(i,4);

    end

    if dataf(i,5)<300 && dataf(i-1,5)>=300

        dataf(i,6)=1;

    end

end

In line 29, there is a value below 300 for column 5, therefore 1 in column 6. The number of day in column 2 is 3. Then I have to add 4 to this and find the row when this happens first. In this case the first 7. This code makes that and saves the value of column 5 in the previous row in unlb:

index =find(dataf(:,6)==1);

index2 = find(dataf(:,2)==dataf(index,2)+4,1);

unbl = unbl+dataf(index2-1,5);

In this row, I will have new stock then I have to add to the actual value of column 5 the quantity 1200:

dataf(index2,5) = 1200+dataf(index2,5);

I got this:

Therefore, from this point I have to repeat the same task. I use this long code:

for j=(index2+1):size(dataf,1)

    dataf(j,5)=dataf(j-1,5)-dataf(j,4);

    if dataf(j,5)<300 && dataf(j-1,5)>=300

        dataf(j,6)=1;

    end

end



index =find(dataf(:,6)==1,1,'last');

index2 = find(dataf(:,2)==dataf(index,2)+4,1);

unbl = unbl+dataf(index2-1,5);

dataf(index2,5) = 1200+dataf(index2,5);



for k=(index2+1):size(dataf,1)

    dataf(k,5)=dataf(k-1,5)-dataf(k,4);

    if dataf(k,5)<300 && dataf(k-1,5)>=300

        dataf(k,6)=1;

    end

end



index =find(dataf(:,6)==1,1,'last');

index2 = find(dataf(:,2)==dataf(index,2)+4,1);

unbl = unbl+dataf(index2-1,5);

dataf(index2,5) = 1200+dataf(index2,5);



for l=(index2+1):size(dataf,1)

    dataf(l,5)=dataf(l-1,5)-dataf(l,4);

    if dataf(l,5)<300 && dataf(l-1,5)>=300

        dataf(l,6)=1;

    end

end



index =find(dataf(:,6)==1,1,'last');

index2 = find(dataf(:,2)==dataf(index,2)+4,1);

unbl = unbl+dataf(index2-1,5);

dataf(index2,5) = 1200+dataf(index2,5);

This code does the task for some remaining rows but if I have to complete the entire dataset it will be too large. I tried a one loop solution but unfortunately it does not work:

%One loop (not working)

index=0;

index2=0;

unbl=0;

for i=1:size(dataf,1)

    if i==1

        dataf(i,5)=1000-dataf(i,4);

    else

        dataf(i,5)=dataf(i-1,5)-dataf(i,4);

    end

    if dataf(i,5)<300 && dataf(i-1,5)>=300

        dataf(i,6)=1;

        index =find(dataf(:,6)==1);

        index2 = find(dataf(:,2)==dataf(index,2)+4,1);

    end

    unbl = unbl+dataf(index2-1,5);

    dataf(index2,5) = 1200+dataf(index2,5);

    i=index2+1;

end

I do not know how to update the index of the loop to move across all rows and get the cumulative value saved in unbl. Please could you help to fix this pieces of code into one loop statement to move around all rows and reproduce the task previously mentioned. Many Thanks.

Here is a piece of code that I believe do what you need (explanations in the comments inside):

stock = 1000;

new_stock = 1200;

unbl = 0;

% culculate the comulative substraction from the initial stock:

temp = cumsum([stock; -dataf(:,4)]);

dataf(:,5) = temp(2:end); % no need for the first element (1000)

% find when to set a new order:

low_stock = find(dataf(:,5)<300,1);

% start the loop

last_low = 0;

while low_stock~=last_low % if you found a new date with low stock

    last_low = low_stock; % use the new date

    dataf(last_low,6) = 1; % place 1 in the date with low stock

    % find the first line 4 days ahead:

    refill = last_low+find(dataf(last_low:end,2)==dataf(last_low,2)+4,1)-1;

    % add the amount on column 5 in the row above ind_b to 'unbl'

    unbl = unbl+dataf(refill-1,5);

    % add new stock to all rows below after stock arival

    dataf(refill:end,5) = dataf(refill:end,5)+new_stock;

    % find the next time to set a new order:

    low_stock = refill+find(dataf(refill+1:end,5)<300,1);    

end