|
Spreadsheet Toolkit | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--corpus.analyser.Analyser
This class is responsible for reading in a bunch of spreadsheets using Extractor to get the data out. If possible the data will be read from a serialized version of the WorkBook. The abstract method process(WorkSheet ws, String[] sheetnames, int sheetnum); is called to do the rest of the work.
process(WorkSheet,String[],int)
Field Summary | |
protected java.util.Vector |
averageMathVector
This stores the average formula cell referencing vector for each worksheet processed. |
static int |
CLUSTER
Similar to occupancy, except performs clustering using ClusterGraph. |
static int |
COMPRESSION
Reports on zip compresison levels for saved workbooks. |
protected int |
diagram
What style of analysis that is being done. |
static int |
FORMULA_COM
Draws the formlua complexity |
static int |
FORMULACOMPONENT
Similar to metrics, except counts number of each type of formula component used. |
static int |
HEATMAP
Similar to occupancy, except data is displayed using a heatmap. |
static int |
METRICS
Dump an assortment of Metrics for each workbook into a file |
static int |
OCCUPANCY
Counts how many times each cell is occupied. |
protected java.lang.String |
path
Where to look for Excel files by default. |
static int |
POWERLAW
Perform powerlaw analysis for cell references. |
static int |
TREEDEPTH
Draws the depth of the complexity |
protected Grid |
values
The grid values is used to store the occupency levels for each cell |
static int |
VECTOR
Draws the average vector for each cell |
static int |
VECTOR_MAG
Draws the average magnitude vector for each worksheet |
protected Grid |
vectorGrid
This Grid contains a vector for each cell. |
protected int |
workbooks
A quick count of how many workbooks have been processed. |
protected int |
worksheets
A quick count of how many worksheets have been processed. |
static int |
WS_OCCUPANCY
Same as OCCUPANCY except seperated at worksheet level. |
Constructor Summary | |
Analyser(java.lang.String path,
int diagram)
|
Method Summary | |
abstract void |
display()
Takes all the results from computation and passes them off to Doodler. |
static int |
distinctFamilyTrees(Cell[] cells)
Count the number of distinct family trees that can be found for a given set of cells. |
protected WorkBook |
load(java.lang.String path,
boolean alreadySaved)
Load in a Workbook using extractor if needed. |
void |
loadSheets()
Given a path, this method will load all the excel spreadsheets in the folder. |
static void |
main(java.lang.String[] args)
Get the party started :) |
protected static java.lang.String |
mode(int mode)
Mode of operation |
static java.lang.String |
mode(int mode,
java.lang.String path,
WorkBook wb,
int sheet,
java.lang.String options,
boolean infoReq)
|
protected abstract void |
process(WorkSheet ws,
java.lang.String[] sheetnames,
int sheetnum)
Takes a worksheet from a workbook and computes something on it. |
abstract void |
saveResults(java.lang.String path)
|
Methods inherited from class java.lang.Object |
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
protected Grid values
protected Grid vectorGrid
protected java.util.Vector averageMathVector
protected int workbooks
protected int worksheets
protected java.lang.String path
protected int diagram
public static final int OCCUPANCY
public static final int WS_OCCUPANCY
public static final int VECTOR
public static final int VECTOR_MAG
public static final int FORMULA_COM
public static final int TREEDEPTH
public static final int METRICS
public static final int CLUSTER
public static final int HEATMAP
public static final int FORMULACOMPONENT
public static final int POWERLAW
public static final int COMPRESSION
Constructor Detail |
public Analyser(java.lang.String path, int diagram)
Method Detail |
protected static final java.lang.String mode(int mode)
public void loadSheets()
protected WorkBook load(java.lang.String path, boolean alreadySaved)
path
- The path to the Spreadsheet filealreadySaved
- Is there already a serialized version of disk?
protected abstract void process(WorkSheet ws, java.lang.String[] sheetnames, int sheetnum)
public abstract void display()
public abstract void saveResults(java.lang.String path)
public static java.lang.String mode(int mode, java.lang.String path, WorkBook wb, int sheet, java.lang.String options, boolean infoReq)
public static int distinctFamilyTrees(Cell[] cells)
cells
- the cells to start the familytree searches from.public static void main(java.lang.String[] args)
|
Spreadsheet Toolkit | |||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |