0

Hi,
I am just trying to figure out how to access some data.
Currently it is stored in a spread sheet in the following form........

8/11/09      9/12/09  .... mm/dd/yy
name     score         score   ....  score
name2    score         score   ....  score

there will be many names (and more may be added at any time) also dates and scores will be added throughout the year for each name.
I will need to read the name with the date and score in order to do some calculations with the scores and print various reports and statistics. Because of the fluidity of data I was thinking Array List. But perhaps I can just use the spread sheet?
Basically each column is named by a date and each name row has scores in each date column or no score which represents null (not 0).
Any ideas?

2
Contributors
1
Reply
2
Views
8 Years
Discussion Span
Last Post by VernonDozier
0

Hi,
I am just trying to figure out how to access some data.
Currently it is stored in a spread sheet in the following form........

8/11/09      9/12/09  .... mm/dd/yy
name     score         score   ....  score
name2    score         score   ....  score

there will be many names (and more may be added at any time) also dates and scores will be added throughout the year for each name.
I will need to read the name with the date and score in order to do some calculations with the scores and print various reports and statistics. Because of the fluidity of data I was thinking Array List. But perhaps I can just use the spread sheet?
Basically each column is named by a date and each name row has scores in each date column or no score which represents null (not 0).
Any ideas?

But perhaps I can just use the spread sheet?

How would you do that? You have a text file, right? Or at least, you should, which means you want to export the spreadsheet as a plain old text files with values (drop any formulas, fonts, stuff like that). So you have a bunch of data in a text file and you need to read it in and do whatever with it. Presumably you want a class that has data members more or less corresponding to the spreadsheet columns.

You might choose to have a class like this:

class Test
{
    Date date;
    int score;
}

class Student
{
    String name;
    ArrayList <Test> tests;
}

One Student object per row of data. Have an ArrayList of type Student.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.