Thread Subject: how to add total quantity of a row using for loop?

'Game' 'January' 'February' 'March' 'April' 'May' 'June'
  'iKitty' 75] 254 1235 1820 2114 1600
'ShootEmUp' 3584] 4588 9421 10588 12788 16889

thanks to Tideman,
This code below takes the data from excel and makes them in rows and columns; so if new games want to be added it will create new rows and columns as well.

numbers, text, everything] = xlsread(fileName);

[ngames,nmonths]=size(numbers);
[ for igame=1:ngames
      Game.(text{igame+1,1})=numbers(igame,:);
end

my problem is i have to use for loop to find the sum of each game, for example, total quantity for iKitty is 7098. how can i do this? i need to figure it out so if new games are added to the data it will automatically add their rows as well.

rohan patel wrote:
> 'Game' 'January' 'February' 'March' 'April' 'May' 'June'
> 'iKitty' 75] 254 1235 1820 2114 1600
> 'ShootEmUp' 3584] 4588 9421 10588 12788 16889
>
> thanks to Tideman,
> This code below takes the data from excel and makes them in rows and
columns; so if new games want to be added it will create new rows and
columns as well.
>
> numbers, text, everything] = xlsread(fileName);
>
> [ngames,nmonths]=size(numbers);
> [ for igame=1:ngames
> Game.(text{igame+1,1})=numbers(igame,:);
> end
>
> my problem is i have to use for loop to find the sum of each game,
> for example, total quantity for iKitty is 7098. how can i do this? i
> need to figure it out so if new games are added to the data it will
> automatically add their rows as well.

Why do you need to use a for loop?

doc sum % look at optional 'dim' argument

--

dpb <none@non.net> wrote in message <hcun88$lh0$1@news.eternal-september.org>...
> rohan patel wrote:
> > 'Game' 'January' 'February' 'March' 'April' 'May' 'June'
> > 'iKitty' 75] 254 1235 1820 2114 1600
> > 'ShootEmUp' 3584] 4588 9421 10588 12788 16889
> >
> > thanks to Tideman,
> > This code below takes the data from excel and makes them in rows and
> columns; so if new games want to be added it will create new rows and
> columns as well.
> >
> > numbers, text, everything] = xlsread(fileName);
> >
> > [ngames,nmonths]=size(numbers);
> > [ for igame=1:ngames
> > Game.(text{igame+1,1})=numbers(igame,:);
> > end
> >
> > my problem is i have to use for loop to find the sum of each game,
> > for example, total quantity for iKitty is 7098. how can i do this? i
> > need to figure it out so if new games are added to the data it will
> > automatically add their rows as well.
>
> Why do you need to use a for loop?
>
> doc sum % look at optional 'dim' argument
>
because my teacher said i cant use built in functions

"rohan patel" <rpatel133@live.com> wrote in message
news:hcuum4$3ci$1@fred.mathworks.com...
> dpb <none@non.net> wrote in message
> <hcun88$lh0$1@news.eternal-september.org>...
>> rohan patel wrote:

*snip*

>> Why do you need to use a for loop?
>>
>> doc sum % look at optional 'dim' argument
>>
> because my teacher said i cant use built in functions

Then you cannot complete the assignment as specified. XLSREAD is an M-file,
but it uses built-in functions for some of its work. SIZE is also a
built-in function, as is PLUS (which you're using in its operator form to
compute igame+1 inside the FOR loop.) I think it unlikely you're going to
be able to solve this problem just using keywords. I suppose you could
solve it in MEX, but you'd have to ask your teacher if they considered the
mx* functions (which you would need to use) as built-in functions.

--
Steve Lord
slord@mathworks.com
comp.soft-sys.matlab (CSSM) FAQ: http://matlabwiki.mathworks.com/MATLAB_FAQ