Team Report Team Distribution and Organization for ...

entomologistsamoanSoftware and s/w Development

Aug 15, 2012 (4 years and 10 months ago)

278 views

Team Report

Team Distribution and Organization for upcoming phase

Lab Team 503



Front End

o


o

Graphing Team



Use open source library (JFreeChart located at
http://www.jfree.org/jfreechart/
)



Five types of graphs including pie, line, scatter, bar, and column



Display final graph in new worksheet



Allow user to type desired cells to graph or highlight a selection to graph

o

Format Menu Team (Larry, Bobby)



Create floating format menu



Create class to store formatting



Display new formatting



Allow formatting to be save
d via a string of values for each cell




Back End

o

Sorting (Chad, Justin)

o

Integration (David, Justin)



Begin integrating back end code with front end

o

Importing/exporting(Kyle)

o

Insert/Delete/Swap(Kyle
, Brandon
)

o

Range parsing (Brandon)

o

Functions (Brandon,
Chad, Justin)


Feature List



Minimum

o

GUI Interface



Spreadsheet appearance


Front end
? %



Multiple sheets



0%

Front end



100% Back end

o

Open / Save



Front end


50%

(done by back end team)



Back end
-

100%

o

10 Formulas



Back end


100%

o

Graphs



5 types of graphs:

pie, line, scatter, bar, and column graphs (Completed)



Able to change title, axis title, and legend for each graph type (Completed)



Display a sample graph in a sample window (Completed)



Display the final graph in a new worksheet



Allow user to type in
cell selection or use selected cells for graph (In Progress)

o

Formatting



A floating format box allows for easy, intuitive cell formatting changes [DONE]



Types of formatting allowed in cells: font style, font size, bold, italics, underline,
font color, cell
background color and justification. [90%]



Formatting can be saved and recovered next time the file is opened [50%]



Changes to formatting are reflected in the cell [0%]

o

Back end



Completed: Dependencies, Inserting new rows/cols, Deleting rows/cols,
Swapping
rows (part of sort), updating cell references when cells move, unit

tests for almost all functions, cell location/range parsing, equation parsing.



In progress: Sort.


Milestone

List what features will be implemented for all upcoming evaluations. (Eval 3, F
inal)



Front end

o


o

Graphing Team Evaluation 3



We want to be able to enter data in cells and pull the data to graphing
methods to allow the user to create graphs based on user data



The user input will be passed through pattern matching and verification to
all
ow only valid data



Valid inputs can then be allowed to pull the data from the specified sheet
for graphing



Display the created graph in a new worksheet when the user is finished

o

Graphing Team Final



Allow the user to select cells in a worksheet and have
that selection
automatically fill in the data



Allow the user to select columns to graph that are not in linear order (ex.
select column A and column D)



Enhance user interface



Test components to fix all bugs

o

Formatting Team Evaluation 3



Allow user to bring
format window up from main window



Create the font style class



Add an instance of the font style class to the cell class



Update the font style class when the user presses apply

o

Formatting Team Final



Be able to see the format changes applied in the cell.




Ba
ck end

o

Eval 3
-

Sort completed / tests

o

Eval 3


begin integration with front end

o

Inserting/Deleting/Swapping of rows or columns

o

Final


finish integration with front end


Environment and tools summary

List all tools and libraries you have used for this
project and give all relevant information



IDE


Netbeans



Graphic Library


JCommon and JFreeChart (
http://www.jfree.org/jfreechart/
)



Eval
-

A Simple Expression Evaluator for Java

o

https://eval.dev.java.net/


Indiv
idual Report



Evaluation 2

Name: David Hoover

Group: Back end

Sub Group: Integration

Core Responsibility of Subgroup: Get our back end code working with what the front end has done up
to this point.


Task:

List all tasks you expect to working on for the next upcoming evaluation. Using bulleted list to separate
your task and define each task as necessary.



Will assist sorting team in the implementation of their function.



Will begin to integrate the back end
code with the front end code.


Individual Report


Evaluation 2










Name: Kyle Baxter











Group: Front End











Sub Group: Graphing Team










Core Responsibility of Sub Group: develop graphing tools to use with spreads
heet

Tasks:



Setup pattern matching for user input in the data range (ex. “=sheet1!$A$1:$B$2”)



Have error checking for user input to match specific pattern



Create methods to get the data from the specified sheet for each specific graph



Develop a way to have

selected cells in the sheet correspond to the data entry for each graph
(like in Excel where you can select the cells to include in the graph)



Display the graph in a separate worksheet when the user is finished and selects “create”


















Indivi
dual Report



Evaluation 2

Name: Kyle Minton

Group: Backend

Sub Group: Open/Save, Insert, Delete

Core Responsibility of Subgroup: Open/Save


Task:



Continue to monitor and update the open and save capabilities. Make Sure they operate
sufficiently and
properly. Correlate my functions with the needs of the frontend.



Work on the insertion, deletion, or swapping of rows and columns.



Assist the frontend and get them caught up with the backend.



Create tests for others for their functions or features.



Make

additional add
-
ons and continue to make our program better.

Individual Report



Evaluation 2

Name: Justin Falck

Group: Back end

Sub Group: Integration, Functions, Sorting

Core Responsibility of Subgroup: Get our back end code working with what the fr
ont end has done up
to this point, Write code that performs math functions such as standard deviation, sum, and average,
and also code the functions that handle sorting rows much like Microsoft Excel.


Task:

List all tasks you expect to working on for the
next upcoming evaluation. Using bulleted list to separate
your task and define each task as necessary.



Finish coding sorting functionality



Will begin to integrate the all back end code with the front end code.

Individual Report


Evaluation 2










Name: Robert Harkreader










Group: Front End











Sub Group: Formatting Team










Core Responsibility of Sub Group: develop formatting menu and ability to change format of cell

Tasks:



Create font style class



Implement underline



Implement cancel button



Update font style class of cell when user presses apply button



Update cell when user presses apply button



Create a way for the user to access the format menu



















Individual Report



Evaluation 2

Name: Brandon Nance

Group: Backend

Sub Group: Parsing, Equations, Insert, Delete

Core Responsibility of Subgroup: Parsing


Task:



I have been coding functions, correlating with the other two function team members



Work on the insertion, deletion, or swapping of rows and colu
mns

(with Kyle)
.



Assist the frontend and get them caught up with the backend.



Continue testing aspects of the backend using test functions.



Make additional add
-
ons and continue to make our program better.