Spreadsheet Toolkit
A B C D E F G H I J L M N O P R S T U V W X Y Z

P

P_DATABASE - Static variable in class corpus.excel.parser.FunctionParser
 
P_DATEANDTIME - Static variable in class corpus.excel.parser.FunctionParser
 
P_ENGINEERING - Static variable in class corpus.excel.parser.FunctionParser
 
P_FINANCIAL - Static variable in class corpus.excel.parser.FunctionParser
 
P_INFORMATION - Static variable in class corpus.excel.parser.FunctionParser
 
P_LOGICAL - Static variable in class corpus.excel.parser.FunctionParser
 
P_LOOKUPANDREFERENCE - Static variable in class corpus.excel.parser.FunctionParser
Pattern is used for matching in regular expressions
P_MATHANDTRIG - Static variable in class corpus.excel.parser.FunctionParser
 
P_STATISTICAL - Static variable in class corpus.excel.parser.FunctionParser
 
P_TEXT - Static variable in class corpus.excel.parser.FunctionParser
 
P() - Method in class corpus.fileIO.Semaphore
P for Wait() because P is the first letter of the Dutch word "passeren," which means "to pass,"
paint(Graphics) - Method in class corpus.doodle.Animation
Paint the previous frame (if any).
paint(Graphics, int, int) - Method in class corpus.doodle.Animation2
 
paint(Graphics, int, int) - Method in class corpus.doodle.Animation
 
paintComponent(Graphics) - Method in class corpus.doodle.RadarDotWidget
 
paintComponent(Graphics) - Method in class corpus.doodle.RadarWidget
 
paintComponent(Graphics) - Method in class corpus.doodle.EquivalenceWidget
 
paintComponent(Graphics) - Method in class corpus.doodle.AbstractVisualisationPane
Draw Grid and Vectors
paintFrame(Graphics) - Method in class corpus.doodle.Animation
Paint a frame of animation into an off screen Image.
ParameterEntry - class corpus.fileIO.ParameterEntry.
Provides basic command line parameter parsing and a GUI to read any missed parameters.
ParameterEntry() - Constructor for class corpus.fileIO.ParameterEntry
Constructor
parse() - Method in class corpus.excel.parser.FormulaParser
 
parse(String) - Method in class corpus.excel.parser.IntersectionParser
 
parseArgs(String[], String) - Static method in class corpus.fileIO.FileIO
 
parseCompile(String) - Static method in class corpus.doodle.Graph
 
parseFormula() - Method in class corpus.excel.Formula
Turn the formula string into a sequence of excel elements using a recursive descent parser.
parseOne(String) - Method in class corpus.excel.parser.FormulaParser
Given an input String this method will return the FormulaComponent that is at the start of the input.
parseOne(String, Formula) - Method in class corpus.excel.parser.VectorParser
Given a string containing a Excel formula, break it down into components.
parseOne(String, Formula) - Method in class corpus.excel.parser.UnionParser
Given a string containing a Excel formula, break it down into components.
parseOne(String, Formula) - Method in class corpus.excel.parser.RangeParser
Given a string containing a Excel formula, break it down into components.
parseOne(String, Formula) - Method in class corpus.excel.parser.IntersectionParser
Given a string containing a Excel formula, break it down into components.
parseOne(String, Formula) - Method in class corpus.excel.parser.WorkSheetReferenceParser
Given a string containing a Excel formula, break it down into components.
parseOne(String, Formula) - Method in class corpus.excel.parser.WorkBookReferenceParser
Given a string containing a Excel formula, break it down into components.
parseOne(String, Formula) - Method in class corpus.excel.parser.OperatorParser
Given a string containing a Excel formula, break it down into components.
parseOne(String, Formula) - Method in class corpus.excel.parser.FunctionParser
Given a string containing a Excel formula, break it down into components.
parseOne(String, Formula) - Method in class corpus.excel.parser.CellReferenceParser
Given a string containing a Excel formula, break it down into components.
parseOne(String, Formula) - Method in class corpus.excel.parser.FormulaComponentParser
Given a string containing a Excel formula, break it down into components.
parseTree() - Method in class corpus.excel.RowRange
Creates a parseTree for this FormulaComponent and any of its sub components.
parseTree() - Method in class corpus.excel.FormulaComponent
Creates a parseTree for this FormulaComponent and any of its sub components.
parseTree() - Method in class corpus.excel.ColumnRange
Creates a parseTree for this FormulaComponent and any of its sub components.
parseTree() - Method in class corpus.excel.Range
Creates a parseTree for this FormulaComponent and any of its sub components.
parseTree() - Method in class corpus.excel.Function
Creates a parseTree for this FormulaComponent and any of its sub components.
parseTree() - Method in class corpus.excel.Formula
Creates a JTree to represent the parsed strucutre of the formula.
parseTree(Vector) - Static method in class corpus.excel.Formula
Returns the parseTree for the given elements.
parseTreeString() - Method in class corpus.excel.Formula
First attempt at showing the parsetree strucutre of a formula as a multiline text String.
path - Variable in class corpus.analyser.Analyser
Where to look for Excel files by default.
PATTERN - Static variable in class corpus.excel.parser.VectorParser
 
PATTERN - Static variable in class corpus.excel.parser.UnionParser
 
PATTERN - Static variable in class corpus.excel.parser.RangeParser
 
PATTERN - Static variable in class corpus.excel.parser.IntersectionParser
 
PATTERN - Static variable in class corpus.excel.parser.OperatorParser
Pattern is used for matching in regular expressions
PATTERN - Static variable in class corpus.excel.parser.FunctionParser
 
PATTERN - Static variable in class corpus.excel.parser.CellReferenceParser
The complete pattern for recognising a cell reference in a formula.
performSearch(int) - Method in class corpus.gobbler.SearchMethod
Starts interaction with Google.
performSearch(String, int, int, String) - Method in class corpus.gobbler.Gobbler
Starts interaction with Google.
PLUS - Static variable in class corpus.excel.Operator
 
possible(String) - Static method in class corpus.fetcher.Fetcher
Given a path to look in, this method will return all the search files.
POWERLAW - Static variable in class corpus.analyser.Analyser
Perform powerlaw analysis for cell references.
PowerLawAnalyser - class corpus.analyser.PowerLawAnalyser.
This class is responsible for reading in a bunch of spreadsheets, using the extractor to get the data out, doing some processing on them, and then passing the information onto Doodler.
PowerLawAnalyser(String, int) - Constructor for class corpus.analyser.PowerLawAnalyser
 
Primitive - class corpus.excel.Primitive.
Used to store the internal representation of a primitive formula component.
Primitive(String) - Constructor for class corpus.excel.Primitive
 
Primitive(String, Boolean) - Constructor for class corpus.excel.Primitive
 
Primitive(String, Double, int) - Constructor for class corpus.excel.Primitive
 
Primitive(String, Integer, int) - Constructor for class corpus.excel.Primitive
 
Primitive(String, String) - Constructor for class corpus.excel.Primitive
 
print() - Method in class corpus.excel.WorkSheet
Like toString except dumps to console.
print() - Method in class corpus.excel.WorkBook
Print all info.
print() - Method in class corpus.fileIO.ZipInfo
 
printParseTree(DefaultMutableTreeNode, String) - Static method in class corpus.excel.Formula
Dumps the current state of the parse tree to the console.
process() - Method in class corpus.excel.WorkSheet
Process the worksheet This method is called after reading has been completed.
process() - Method in class corpus.excel.WorkBook
Called after basic loading is complete, perfrom data structure init
process() - Method in class corpus.excel.Formula
Use the information given for this formula to parse out the formula components.
process(Grid, Vector) - Method in class corpus.doodle.AbstractVisualisationPane
Process incomming data grid and add the required elements to the toDraw vector.
process(String[]) - Method in class corpus.excel.Cell
Given the sheetnames for this cell, create the Formula object.
process(WorkSheet, String[], int) - Method in class corpus.analyser.PowerLawAnalyser
Takes a worksheet from a workbook and computes something on it.
process(WorkSheet, String[], int) - Method in class corpus.analyser.FormulaComponentAnalyser
Takes a worksheet from a workbook and computes something on it.
process(WorkSheet, String[], int) - Method in class corpus.analyser.TreeDepthAnalyser
Takes a worksheet from a workbook and computes something on it.
process(WorkSheet, String[], int) - Method in class corpus.analyser.ClusterAnalyser
Takes a worksheet from a workbook and computes something on it.
process(WorkSheet, String[], int) - Method in class corpus.analyser.MetricsAnalyser
Takes a worksheet from a workbook and computes something on it.
process(WorkSheet, String[], int) - Method in class corpus.analyser.OccupancyAnalyser
Takes a worksheet from a workbook and computes something on it.
process(WorkSheet, String[], int) - Method in class corpus.analyser.HeatmapAnalyser
Takes a worksheet from a workbook and computes something on it.
process(WorkSheet, String[], int) - Method in class corpus.analyser.CompressionAnalyser
Takes a worksheet from a workbook and computes something on it.
process(WorkSheet, String[], int) - Method in class corpus.analyser.FormulaAnalyser
Takes a worksheet from a workbook and computes something on it.
process(WorkSheet, String[], int) - Method in class corpus.analyser.Analyser
Takes a worksheet from a workbook and computes something on it.
processed - Variable in class corpus.excel.Formula
Has this cell been processed.

Spreadsheet Toolkit
A B C D E F G H I J L M N O P R S T U V W X Y Z
Project Home Page