Zilberter Excel

A substantial expansion on a Java, console-based text/data manager project that was given to me for my compSci final. Includes a fully interactive GUI, sorting data, multiple data type managment, and mathematical operations.

Functions

• Multiple cell selection.
• Sorting cells in ascending/descending order, including sorting multiple data types (text, integers, etc).
• Copy & Paste for one or multiple selected cells.
• Selecting rows, columns, or even the whole grid.
• Highlighting of selected cells + labels for selected cells for easy data management/reading.
• Formulas for cells, including error managment to prevent circular references (i.e. A1 = (A2 + A3), A2 = (A3 + A1), A3 = (A1 + A2)
• Graphing Calculator Includes:
  • A line of best fit for the data provided
  • Labels on each axis
  • Labeling of a point based on the location of the mouse on the graph.
  • Graphing of the line of best fit
  • Automatic scaling of the axes to easily show relationship between data

Usage

• Type "launch" into console to start program
• Press on a cell to highlight it, allowing for inputting of data:
  • Use quotations for text
  • Enter formulas by first naming the cell, then following with an equals sign: A1 =
  • Enter integers/doubles normally
  • Enter percentages by typing the decimal, followed by a percent sign.
  • To select multiple cells, either press the gray rows/column labels or select the small green square at the edge of a highlighted cell and drag it along the grid.
  • To sort, select multiple cells and press the sort buttons.
  • To copy, select multiple cells and press the copy button.
  • To paste, select multiple cells (can be larger/smaller than copied cells) and press the paste button.
  • To graph, first create labels for both columns. Then, input data in each column, making sure not to leave any white space in highlighted cells. Then, press the graph button.