git static hosting for my code

← Back to main page

spreadsheet

typeScript/javascript spreadsheet parser, with formulas.

git clone https://git.vogt.world/spreadsheet.git

alt url: https://github.com/vogtb/spreadsheet

Log | Files | README.md

Date

Commit

Author

Files

-

-

2018-07-23 13:08:44

Merge pull request #1 from twobit/master TypeScript declaration files

Ben V

52

3440

42

2018-02-10 20:17:48

[ISSUE-013, ISSUE-009] Equality checking inside parentheses should return boolean values, checking type and value for EQ.

Ben Vogt

8

41

49

2018-02-10 04:43:30

[dist] building new dist

Ben Vogt

19

1568

1388

2018-02-10 04:43:09

[Tests, TODOS] adding tests for expression operator tests, marking TODOs with numbers

Ben Vogt

4

243

53

2018-02-10 03:48:03

[Errors] adding docs

Ben Vogt

1

24

0

2018-02-10 00:28:07

[ParserConstants] more renamed constants, giving some to their own files

Ben Vogt

8

1669

1485

2018-02-10 00:09:14

[Tests,ParserConstants] chipset change caused fpp errors, renaming constants

Ben Vogt

6

48

44

2018-02-09 23:48:19

[all] checking in progress

Ben Vogt

18

1687

1688

2017-12-22 02:47:04

[ParserConstants] organizing States by name and logical sequence

Ben Vogt

1

622

588

2017-12-22 01:41:17

[ParserConstants] naming constants

Ben Vogt

2

68

66

2017-12-21 02:52:14

[ParserConstants] refactoring reductioc actions

Ben Vogt

3

89

91

2017-12-20 04:25:22

[ParserConstants] even more state enumeration

Ben Vogt

5

324

319

2017-12-20 02:31:08

[ParserConstants] back to state enumeration

Ben Vogt

4

5

42

2017-12-20 02:21:45

[Sheet] adding documentation

Ben Vogt

4

105

314

2017-12-20 02:09:50

[SheetBasicTest] testing sheet, since testing parser directly doesn't make a lot of sense

Ben Vogt

4

260

262

2017-12-20 01:29:45

[Parser, Math] simplifying operations

Ben Vogt

2

26

124

2017-12-20 00:47:44

[Parser, Sheet, MoreUtils] refactoring static utility functions

Ben Vogt

4

281

209

2017-12-11 00:39:42

[everything] refactoring Parser, Sheet, DataStore/Matrix

Ben Vogt

12

1084

2024

2017-12-11 00:16:12

[ParserTests] fixing some tests, documenting TODOs

Ben Vogt

1

8

19

2017-12-11 00:05:43

[ParserTests] testing literal error input

Ben Vogt

1

6

23

2017-12-11 00:03:39

[Parser,ParserConstants] expanding comparison operator tests

Ben Vogt

3

56

14

2017-12-10 23:40:26

[Parser,ParserContants] fixing LTE evaluation

Ben Vogt

3

10

8

2017-12-10 23:24:00

[ParserConstants] and again, more state enumerations

Ben Vogt

2

9

5

2017-12-10 23:16:03

[Parser,ParserConstants] removing NOT related constants, we don't need it

Ben Vogt

2

49

127

2017-12-10 22:52:24

[ParserConstants] even more state enumerations

Ben Vogt

2

107

100

2017-12-10 05:04:03

[ParserConstants] more state enumerations

Ben Vogt

2

97

75

2017-12-10 04:47:20

[ParserConstants] State.ADD_TWO_NUMBERS, State.SUBTRACT_TWO_NUMBERS

Ben Vogt

2

19

5

2017-12-10 04:32:49

[Parser,ParserConstants] removing DATE, TIME rules

Ben Vogt

2

41

128

2017-12-10 04:22:49

[ParserConstants] starting to enumerate states

Ben Vogt

1

24

40

2017-12-10 04:03:39

[Parser,ParserConstants] refactoring constant names, rule-to-symbol mappings

Ben Vogt

2

163

117

2017-12-10 03:21:40

[ParseEngineTest] directly testing parser

Ben Vogt

2

199

3

2017-12-10 02:45:28

[ParserConstants] fixing bad refs

Ben Vogt

2

249

243

2017-12-10 02:18:34

[ParserEngine] do-over on ParserEngine

Ben Vogt

3

61

61

2017-12-10 01:39:41

[ParseEngine] renaming some things to make more sense, getting closer to having multiplication working

Ben Vogt

3

118

104

2017-12-10 00:33:34

[ParseEngine] removing a lot of stuff so I can focus on getting one thing working

Ben Vogt

1

97

439

2017-12-09 22:36:12

[ParseEngine] starting work on processing simple multiplication, eg: 5*5

Ben Vogt

2

36

20

2017-12-09 20:35:17

[ParseEngine] simple number version working

Ben Vogt

2

327

94

2017-12-09 19:29:28

[ParseEngine] adding tests, indexing rules

Ben Vogt

3

1021

240

2017-12-09 17:47:41

[ParseEngine] starting work on just getting a simple syntax working

Ben Vogt

1

52

153

2017-12-09 04:56:56

[ParseEngine] defining syntax tree, and reduction actions

Ben Vogt

1

139

136

2017-12-07 02:58:18

[ParseEngine] work-in-progress, creating new parser engine starting with actions, rules, rectioons, and symbols

Ben Vogt

3

740

18

2017-12-04 03:28:08

[ParsingTest] work-in-progress, filling out parser tests for upcoming parser changes

Ben Vogt

3

196

119

2017-12-02 02:34:47

[Parser, ParserConstants] work-in-progress on letting arrays passed in to formulas without errors

Ben Vogt

6

38

54

2017-12-03 15:07:36

[npm] bumping version to 1.0.1

Ben Vogt

2

2

2

2017-12-01 04:50:02

[Text.SUBSTITUTE] formula added and tested

Ben Vogt

8

114

6

2017-12-01 04:15:41

[Text.REPLACE] formula added and tested

Ben Vogt

9

101

9

2017-10-14 15:49:44

[Text.PROPER] formula added and tested

Ben Vogt

7

46

6

2017-10-10 00:48:49

[Text.MID] formula added and tested

Ben Vogt

8

96

6

2017-10-08 17:19:15

[Text.CLEAN] formula added and tested

Ben Vogt

8

64

6

2017-10-08 17:05:50

[Text.VALUE] formula added and tested

Ben Vogt

8

73

5

2017-10-08 16:47:27

[Text.REPT] formula added and tested

Ben Vogt

8

72

6

2017-10-08 16:38:57

[Text.SEARCH] formula added and tested

Ben Vogt

8

101

7

2017-10-08 16:12:10

[Text.RIGHT] formula added and tested

Ben Vogt

8

86

9

2017-10-08 16:05:54

[Text.LEFT] formula added and tested

Ben Vogt

8

90

11

2017-10-08 15:54:24

[Text.LEN] formula added and tested

Ben Vogt

8

59

6

2017-10-08 01:19:56

[Text.JOIN] formula added and tested

Ben Vogt

8

65

3

2017-10-08 00:06:58

[Text.FIND] formula added and tested

Ben Vogt

8

99

6

2017-10-07 16:56:49

[Statistical.ZTEST] formula added and tested

Ben Vogt

8

81

7

2017-10-07 16:24:45

[Statistical.HYPGEOMDIST] formula added and tested

Ben Vogt

7

116

6

2017-10-07 16:02:50

[Math.SUBTOTAL] formula added and tested

Ben Vogt

9

202

19

2017-10-06 00:35:02

[Financial.RATE] formula added and tested

Ben Vogt

8

195

7

2017-10-04 01:34:21

[Financial.PV] formula added and tested

Ben Vogt

8

105

8

2017-10-04 01:19:15

[Financial.FVSCHEDULE] formula added and tested

Ben Vogt

8

81

5

2017-09-24 17:30:42

[Text.TEXT] formula added and tested

Ben Vogt

18

1264

33

2017-09-29 23:31:04

[dist] clean dist

Ben Vogt

10

1591

3928

2017-09-29 23:29:42

[LICENSES] separating OpenOffice license

Ben Vogt

2

24

28

2017-09-24 16:56:15

[ROMAN] formula added and tested

Ben Vogt

5

85

3

2017-09-23 23:52:03

[Parser, ParserConstants, Info.IFERROR] error literals working, fixed IFERROR function

Ben Vogt

5

1019

924

2017-09-23 17:16:09

[Parser, tests] work-in-progress on allowing errors to be parsed as literals (e.g. =#N/A)

Ben Vogt

6

1668

1528

2017-09-18 01:32:20

[Parser] using Symbol enums in ACTION_TABLE

Ben Vogt

1

1469

1176

2017-09-17 22:09:43

[Parser] refactoring use of 'table' and 'productions' in parse()

Ben Vogt

1

18

21

2017-09-17 21:24:46

[Parser] replacing complex table objects with simple objects

Ben Vogt

3

1439

845

2017-09-17 20:49:35

[Parser] making rules table a constant to make refactoring easier

Ben Vogt

2

1272

1056

2017-09-09 23:37:57

[SERIESSUM] work-in-progress, requires changes to Parser.ts to allow array token to follow coma

Ben Vogt

6

62

7

2017-09-09 16:28:16

[DOCS] fixing regular expression for generating DOCS.md

Ben Vogt

3

29

35

2017-09-09 16:13:26

[ROWS] formula added and tested

Ben Vogt

7

112

5

2017-09-09 15:59:23

[COLUMNS] formula added and tested

Ben Vogt

8

185

8

2017-09-09 15:17:07

[ADDRESS] formula added and tested

Ben Vogt

7

232

5

2017-09-09 13:59:50

[IFERROR, ISFORMULA] formulas added and tested

Ben Vogt

12

459

216

2017-09-05 02:39:00

[IFERROR] work-in-progress on IFERROR

Ben Vogt

6

17

22

2017-09-04 23:12:05

[ISERR, ERROR.TYPE, ISERROR, ISNA] testing try-catch formulas

Ben Vogt

5

46

8

2017-09-04 20:21:59

[Sheet] making sure Error.Type is called properly with resulting errors

Ben Vogt

4

18

13

2017-09-04 20:10:23

[Parser, Sheet] checking for try-catch-formula inside performAction so we can assign result to this.$

Ben Vogt

3

271

122

2017-09-04 19:12:00

[Sheet] just letting the cell containing the error return...

Ben Vogt

2

11

4

2017-09-04 18:54:13

[Parser, Errors] work-in-progress on getting error-catching formulas working

Ben Vogt

7

71

37

2017-09-04 16:40:46

[Cell] setting and getting Cell fields, more thurough testing

Ben Vogt

8

201

41

2017-09-04 15:42:17

[documentation, ts cleanup] cleaning up some ts issues, adding documentation

Ben Vogt

33

1265

1188

2017-09-03 21:18:50

[Parser, CHOOSE] documenting parser, fixing tests for CHOOSE array issue

Ben Vogt

11

1891

84

2017-09-01 22:14:13

[Parser] removing rule index names because it actually doesn't make it easier to read.

Ben Vogt

2

785

810

2017-08-31 04:24:44

[Parser,TypeConverter] adjusting Parser and TypeConverter number regex to handle sci-notation number Also moving Rules into Parser

Ben Vogt

5

237

247

2017-08-26 19:11:50

[Parser] using ReductionPair in PRODUCTIONS for clarity

Ben Vogt

1

80

59

2017-08-26 18:49:05

[Parser] refactoring stack reduction variables

Ben Vogt

1

26

16

2017-08-20 17:52:38

[Parser] continuing to name production indicies, documenting performAction function

Ben Vogt

1

91

103

2017-08-20 17:30:39

[Parser] naming 'productions' indicies with ReduceActions enums

Ben Vogt

1

110

55

2017-08-20 16:35:49

[Parser] naming ReduceActions enums

Ben Vogt

1

138

128

2017-08-19 19:39:20

[Parser] using enums for ReduceActions to make actions mappings easier to read

Ben Vogt

1

180

136

2017-08-19 19:07:29

[Parser,Rules] naming indexes, adding documentation to parser

Ben Vogt

2

374

302

2017-08-19 16:03:41

[Parser] adding documentation and cleaning up functions

Ben Vogt

1

184

206

2017-08-19 00:51:54

[Parser] using Actions enum instead of 1,2,3 for action mapping

Ben Vogt

1

109

83

2017-08-19 00:32:12

[Parser,Rules] continuing process of renaming parser variables. no functional changes.

Ben Vogt

2

225

101

2017-08-15 00:02:47

[Rules,Parser] renaming INDEX_ to actual rule index for readability

Ben Vogt

2

665

611

2017-08-14 02:58:41

[Parser,Rules,ObjectFromPairs] continuing INDEX_ refactoring

Ben Vogt

1

577

454

2017-08-14 01:07:26

[Parser,Rules,ObjectFromPairs] Using INDEX_ naming scheme to make refactoring of rule-sets easier

Ben Vogt

2

147

129

2017-08-14 00:49:13

[Parser,Rules,ObjectFromPairs] work-in-progress on using index constants in parser so it's easier to read.

Ben Vogt

5

124

20

2017-08-13 22:27:39

[Parser/Rules] moving rules out of parser for readability

Ben Vogt

3

169

40

2017-08-13 21:55:40

[Parser] beginning process of reformatting, for readability

Ben Vogt

4

90

8

2017-08-12 20:39:11

[Convert] TO_DATE, TO_PERCENT, TO_DOLLAR, TO_TEXT placeholders and tests added

Ben Vogt

8

264

6

2017-08-12 19:57:21

[CHOOSE] fixing small error, enabling test

Ben Vogt

4

19

16

2017-08-06 15:08:57

[TDIST] formula added and tested

Ben Vogt

8

221

6

2017-07-30 13:04:18

[LOGNORMDIST] formula added and tested

Ben Vogt

8

96

6

2017-07-30 12:35:38

[RANK.EQ] formula added and tested

Ben Vogt

8

103

8

2017-07-30 12:20:25

[RANK.AVG] formula added and tested

Ben Vogt

8

132

8

2017-07-30 12:05:59

[RANK] formula added and tested

Ben Vogt

8

93

6

2017-07-30 11:48:02

[MODE] formula added and tested

Ben Vogt

8

103

6

2017-07-12 03:14:35

[PROB] formula added and tested

Ben Vogt

8

131

7

2017-07-12 02:50:15

[STEYX] formula added and tested

Ben Vogt

8

129

30

2017-07-12 02:33:54

[SKEW] formula added and tested

Ben Vogt

8

90

6

2017-07-12 02:22:47

[RSQ] formula added and tested

Ben Vogt

8

109

6

2017-07-12 02:09:15

[PERMUT] formula added and tested

Ben Vogt

8

103

6

2017-07-12 00:46:22

[VAR] formula added and tested

Ben Vogt

8

88

6

2017-07-12 00:40:10

[VARA] formula added and tested

Ben Vogt

8

113

7

2017-07-12 00:28:44

[VARP] formula added and tested

Ben Vogt

8

101

6

2017-07-12 00:20:18

[VARPA] formula added and tested

Ben Vogt

8

104

6

2017-07-12 00:05:02

[WEIBULL] formula added and tested

Ben Vogt

8

106

6

2017-07-11 03:17:19

[PPMT] formula added and tested

Ben Vogt

8

111

7

2017-07-11 00:19:33

[T] formula added and tested

Ben Vogt

8

61

5

2017-07-11 00:06:21

[ROW] formula added and tested

Ben Vogt

8

66

5

2017-07-10 23:54:25

[COLUMN] formula added and tested

Ben Vogt

10

73

23

2017-07-10 01:02:27

[TYPE] formula added and tested

Ben Vogt

8

117

6

2017-07-10 00:47:21

[ISNA] formula added and tested (IFERRORing correct calling from Parser/Sheet)

Ben Vogt

11

121

7

2017-07-09 21:15:49

[ISNA] formula added and tested (pending correct calling from Parser/Sheet)

Ben Vogt

8

94

5

2017-07-09 18:45:16

[ISERROR] formula added and tested (pending correct calling from Parser/Sheet)

Ben Vogt

8

100

6

2017-07-09 18:36:30

[ISERR] formula added and tested (pending correct calling from Parser/Sheet)

Ben Vogt

8

67

5

2017-07-09 18:26:48

[ISBLANK] formula added and tested

Ben Vogt

8

74

5

2017-07-09 17:09:10

[ERRORTYPE, ERROR.TYPE] formula added and tested (mostly, still needs to be hooked into Parser/Sheet)

Ben Vogt

10

268

21

2017-07-09 16:29:40

[ISREF] formula added and tested

Ben Vogt

4

43

4

2017-07-09 15:41:29

[TypeConverter] adding logic for converting Cells to primitives

Ben Vogt

7

144

4

2017-07-09 15:24:40

[Cell,Sheet,etc] work-in-progress on having all functions handle Cell objects

Ben Vogt

6

97

22

2017-07-09 14:58:04

[TODO.md] documenting strategy for building out meta-functions

Ben Vogt

1

16

7

2017-07-08 15:08:02

[Parser, TODO.md] documenting work to allow formulas to catch errors, references, etc, by handling Cell objects

Ben Vogt

3

108

58

2017-07-08 14:43:36

Converted parser.js to typescript

Ben Vogt

9

2991

1775

2017-07-08 14:25:27

[COVAR] formula added and tested

Ben Vogt

8

91

6

2017-07-08 14:13:27

[BINOMDIST] formula added and tested

Ben Vogt

7

173

8

2017-07-08 02:48:35

[MULTINOMIAL] formula added and tested

Ben Vogt

8

101

6

2017-07-08 02:34:26

[UNARY_PERCENT] formula added and tested

Ben Vogt

8

56

5

2017-07-07 03:49:24

[N] formula added and tested

Ben Vogt

8

56

7

2017-07-07 02:07:01

[CONFIDENCE] formula added and tested

Ben Vogt

8

206

5

2017-07-04 17:03:58

[HARMEAN] formula added and tested

Ben Vogt

8

85

5

2017-07-04 16:57:36

[GEOMEAN] formula added and tested

Ben Vogt

8

91

5

2017-07-03 23:19:36

[NEGBINOMDIST] formula added and tested

Ben Vogt

8

170

6

2017-07-03 21:14:16

[NORMINV] formula added and tested

Ben Vogt

8

201

6

2017-07-03 20:53:55

[NORMDIST] formula added and tested

Ben Vogt

8

105

10

2017-07-03 19:24:22

[NORMSDIST] formula added and tested

Ben Vogt

7

70

5

2017-07-03 19:12:43

[NORMSINV] formula added and tested

Ben Vogt

8

117

7

2017-07-03 16:00:38

[PERCENTRANK.EXC] formula added and tested

Ben Vogt

8

140

9

2017-07-03 15:47:25

[PERCENTRANK, PERCENTRANK.INC] formulas added and tested

Ben Vogt

10

169

11

2017-07-03 01:05:15

[POISSON] formula added and tested

Ben Vogt

8

133

9

2017-07-02 17:12:57

[LINEST] formula added and tested

Ben Vogt

8

151

4

2017-06-30 15:59:47

[ISURL] formula added and tested

Ben Vogt

8

131

9

2017-06-30 15:05:22

[ISEMAIL] formula added and tested

Ben Vogt

8

65

8

2017-06-30 14:26:12

[FV] formula added and tested

Ben Vogt

8

108

29

2017-06-30 14:06:29

[IPMT] formula added and tested

Ben Vogt

8

141

14

2017-06-30 13:02:07

[IRR] formula added and tested

Ben Vogt

8

122

5

2017-06-30 12:26:51

[MIRR] formula added and tested

Ben Vogt

7

113

12

2017-06-29 00:59:27

[NOMINAL] formula added and tested

Ben Vogt

8

75

6

2017-06-29 00:36:52

[NPER] formula added and tested

Ben Vogt

8

112

6

2017-06-27 02:46:30

[NPV] formula added and tested

Ben Vogt

7

93

6

2017-06-27 02:17:15

[SLN] formula added and tested

Ben Vogt

8

84

7

2017-06-27 02:09:47

[SYD] formula added and tested

Ben Vogt

8

106

4

2017-06-27 01:38:45

[TODO.md] marking functions that require parser.js changes

Ben Vogt

1

11

9

2017-06-27 01:17:50

[FORECAST] formula added and tested

Ben Vogt

8

144

7

2017-06-27 01:01:38

[INTERCEPT] formula added and tested

Ben Vogt

7

119

6

2017-06-25 17:25:23

[KURT] formula added and tested

Ben Vogt

7

88

5

2017-06-25 17:10:07

[LARGE] formula added and tested

Ben Vogt

8

98

4

2017-06-24 00:16:50

[SMALL] formula added and tested

Ben Vogt

8

77

5

2017-06-24 00:02:16

[STANDARDIZE] formula added and tested

Ben Vogt

8

77

5

2017-06-23 23:50:39

[UPPER] formula added and tested

Ben Vogt

8

58

7

2017-06-23 23:47:25

[LOWER] formula added and tested

Ben Vogt

8

63

8

2017-06-23 02:41:44

[SLOPE] formula added and tested

Ben Vogt

8

114

5

2017-06-22 02:20:18

[TRIMMEAN] formula added and tested

Ben Vogt

8

105

7

2017-06-19 02:42:30

[GROWTH] formula added and tested

Ben Vogt

8

213

7

2017-06-19 01:41:34

[FREQUENCY] formula added and tested

Ben Vogt

9

172

5

2017-06-16 01:06:33

[FACTDOUBLE] formula added and tested

Ben Vogt

8

98

5

2017-06-16 00:51:40

[MROUND] formula added and tested

Ben Vogt

8

82

8

2017-06-16 00:24:10

[ISNONTEXT] formula added and tested

Ben Vogt

8

56

6

2017-06-16 00:20:45

[ISNUMBER] formula added and tested

Ben Vogt

8

56

6

2017-06-16 00:17:11

[ISLOGICAL] formula added and tested

Ben Vogt

8

63

6

2017-06-16 00:11:25

[ISTEXT] formula added and tested

Ben Vogt

8

57

6

2017-06-15 01:51:05

[STDEVPA] formula added and tested

Ben Vogt

8

107

8

2017-06-15 01:33:20

[STDEVP] formula added and tested

Ben Vogt

8

102

12

2017-06-14 00:49:05

[STDEV, STDEVA] formulas added and tested

Ben Vogt

8

184

5

2017-06-13 02:57:57

[UMINUS] formula added and tested

Ben Vogt

8

62

3

2017-06-13 01:47:11

[UPLUS] formula added and tested

Ben Vogt

8

56

6

2017-06-13 01:22:20

[QUOTIENT] formula added and tested

Ben Vogt

10

80

11

2017-06-13 01:10:26

[PRODUCT] formula added and tested

Ben Vogt

10

88

8

2017-06-13 00:52:18

[TODO.md] some formulas require changes to the parser

Ben Vogt

1

5

5

2017-06-13 00:37:43

[PERCENTILE, QUARTILE] formulas added and tested

Ben Vogt

13

240

8

2017-06-10 04:11:59

[GAMMALN] formula added and tested

Ben Vogt

8

72

7

2017-06-10 03:57:44

[LCM] formula added and tested

Ben Vogt

8

88

6

2017-06-06 03:22:05

[TRIM] formula added and tested

Ben Vogt

8

67

5

2017-05-30 02:02:09

[GCD] formula added and tested

Ben Vogt

8

74

12

2017-05-30 00:15:40

[CHOOSE] formula added and tested, mostly, see TODO.md for more information

Ben Vogt

9

118

5

2017-05-29 18:07:23

[NA] formula added and tested

Ben Vogt

8

79

4

2017-05-26 23:30:26

[npm] preparing package for publishing

Ben Vogt

2

8

2

2017-05-26 18:55:53

[GT, GTE, LT, LTE, NE] formulas added and tested

Ben Vogt

8

345

8

2017-05-25 03:55:17

[EQ] formula added and tested

Ben Vogt

8

71

6

2017-05-25 03:41:13

[DIVIDE] formula added and tested

Ben Vogt

8

80

8

2017-05-25 03:29:51

[SIGN] formula added and tested

Ben Vogt

8

74

5

2017-05-25 03:23:27

[RANDBETWEEN] formula added and tested

Ben Vogt

7

86

3

2017-05-25 02:54:46

[MULTIPLY, MINUS, RAND] formulas tested and added

Ben Vogt

10

942

130

2017-05-24 03:53:03

[TODO] adding Cell.rawFormulaText issue to TODO.md

Ben Vogt

1

2

0

2017-05-24 02:51:15

[parser] reformatting parser so it's easier to read

Ben Vogt

1

758

118

2017-05-23 02:38:51

[TODO.md] Adding formulas to write to TODO.md

Ben Vogt

1

185

0

2017-05-23 02:10:54

Updating license to include contributions from OpenOffice

Ben Vogt

1

29

0

2017-05-20 15:10:21

[npm prep] getting package ready for publishing

Ben Vogt

28

7242

33

2017-05-19 03:13:28

[doc.sh] simple bash script to compile docs to markdown file

Ben Vogt

9

1405

91

2017-05-20 00:28:30

[MAXA] Now differs from MAX

Ben Vogt

4

31

14

2017-05-19 02:26:49

[TODO.md] seperating TODOs from README.md

Ben Vogt

2

64

15

2017-05-19 02:01:34

[TypeConverter, DateRegExBuilder] parsing hour, minute, second 9-digits long

Ben Vogt

4

22

7

2017-05-19 00:30:35

[MathHelpers] for heavy math functions used in Statistical

Ben Vogt

4

377

474

2017-05-19 00:00:06

[SheetFormulaTest] ensuring all formulas have parsing tests

Ben Vogt

2

103

13

2017-05-18 00:55:54

[TypeConverter] parsing many types of numbers

Ben Vogt

5

181

73

2017-05-17 03:43:21

Docs and cleaning up Sheet.ts

Ben Vogt

3

7

21

2017-05-17 02:35:50

[CriteriaFunctionFactory] adding tests

Ben Vogt

3

19

9

2017-05-13 22:18:26

[Formulas] reserving '...values' for special cases, convering all others to normal arguments

Ben Vogt

16

1062

1017

2017-05-13 21:46:44

[Logical, Sheet] TRUE and FALSE should throw errors on args length. Sheet should not pass them args.

Ben Vogt

3

10

3

2017-05-13 21:32:09

[Financial] adding PMT formula and tests

Ben Vogt

3

60

13

2017-05-13 21:02:25

[README.md] documenting number parsing requirements TODO

Ben Vogt

1

10

6

2017-05-13 20:31:52

[ArgsChecker] passing formula names into ArgsChecker functions to format NAErrors

Ben Vogt

10

198

146

2017-05-12 23:03:54

[TypeConverter] added tests, moving date parsing tests from DATEVALUE to TypeConverterTest

Ben Vogt

4

876

670

2017-05-12 22:48:04

[Serializer] adding tests

Ben Vogt

2

17

3

2017-05-11 03:04:57

[ArgsChecker, Filter] adding tests

Ben Vogt

17

112

20

2017-05-11 02:31:15

[Sheet, README.md] adding tests for mathMatch, adding TODOs

Ben Vogt

3

23

8

2017-05-11 02:07:34

[Sheet] Adding parsing formula tests for simple operators

Ben Vogt

2

17

2

2017-05-11 01:56:56

[Helpers] removing in favor of TypeConverter

Ben Vogt

3

6

51

2017-05-11 01:51:45

[Sheet, Errors] Standardizing use of errors

Ben Vogt

5

58

62

2017-05-10 04:44:39

[Cell, Sheet] cleaning up the internal Cell model

Ben Vogt

3

47

49

2017-05-10 03:46:37

[Cell, Sheet] First step in process of cleaning up Cell.value

Ben Vogt

2

22

7

2017-05-10 03:38:08

[Cell, Sheet] Starting process of refactoring cell internal value storage

Ben Vogt

2

18

7

2017-05-10 03:32:22

[README.md] Adding more TODOs

Ben Vogt

2

6

1

2017-05-06 01:13:22

[README.md] Adding TODO for percentage number parsing

Ben Vogt

1

5

0

2017-05-06 01:10:45

[TypeConverter] We're not really casting values, so much as converting them

Ben Vogt

9

306

291

2017-05-06 01:04:43

[Date, TypeCaster] Removing Excelime in favor of casters and primatives

Ben Vogt

4

17

58

2017-05-06 00:56:03

[All] Removing last references to ExcelDate. ExcelDate is dead! Long live numbers!

Ben Vogt

5

28

70

2017-05-06 00:51:34

[Date.ts] ExcelDate no longer used in TypeCaster.ts

Ben Vogt

4

47

67

2017-05-06 00:46:19

[Date.ts] ExcelDate no longer used in Date.ts

Ben Vogt

1

29

39

2017-05-06 00:35:07

[Date.ts, etc] Another step towards using TypeCaster to to moment<->number conversions

Ben Vogt

3

99

82

2017-05-05 00:50:50

[Date.ts] work-in-progress on eliminating need for ExcelDate

Ben Vogt

4

77

59

2017-05-05 00:25:26

[CONVERT] More tests

Ben Vogt

2

15

2

2017-05-05 00:06:51

[FINV] More tests

Ben Vogt

2

12

1

2017-05-05 00:00:31

[README.md] cleaning up TODOs

Ben Vogt

3

4

22

2017-05-04 03:47:33

[README.md] cleaning up TODOs and outlining type plan

Ben Vogt

2

33

31

2017-05-04 03:15:08

[EXACT, TypeCaster] making exact smarter, making TypeCaster have one less assumption

Ben Vogt

2

3

17

2017-05-02 23:13:55

[AVERAGEIF] formula now accepts nested ranges/arrays

Ben Vogt

3

4

4

2017-05-01 23:50:06

[FINV] Throws NUM error when parameter 1 is not within range

Ben Vogt

2

6

1

2017-05-01 23:45:29

[SUMIF] Formula now accepts ranges/arrays

Ben Vogt

2

14

7

2017-05-01 23:40:16

[COUNTIFS, README.md] Formula now accepts nested ranges/arrays, adding TODO to README.md

Ben Vogt

3

28

9

2017-05-01 23:19:51

[COUNTIF] Now accepts nested ranges/arrays

Ben Vogt

2

14

7

2017-05-01 23:01:25

[Logical] Cleaning up file

Ben Vogt

1

12

5

2017-05-01 23:00:08

[NETWORKDAYS] Improving testing for default week-days

Ben Vogt

2

7

3

2017-05-01 22:54:09

[README.md, WEEKNUM] Cleaning up TODOs and WEEKNUM formula

Ben Vogt

2

26

53

2017-04-30 18:05:25

[tests] labeling and logging sets of tests

Ben Vogt

15

4769

3573

2017-04-30 17:46:12

[Utilities] Breaking out Utils.ts into class files

Ben Vogt

16

1072

1009

2017-04-29 23:24:21

Adding 'clean' to npm scripts, moving tests around, ensuring all tests get run.

Ben Vogt

11

35

25

2017-04-29 23:10:26

[ALL] refactoring the way formulas are organized and named. tests still pass.

Ben Vogt

21

29

99

2017-04-29 22:59:57

[CONVERT, etc] formula added and tested. formulajs no longer needed

Ben Vogt

5

321

11

2017-04-29 22:29:24

[ALL] documenting functions loaded from jStat

Ben Vogt

4

100

11

2017-04-29 22:05:27

[Statistical,Text] Breaking out tests into seperate files

Ben Vogt

3

149

121

2017-04-29 21:58:59

[Math] Breaking out Math.ts tests into seperate file

Ben Vogt

2

1086

1063

2017-04-29 21:52:46

[Logical] Breaking out Logcial.ts tests into seperate file

Ben Vogt

2

161

148

2017-04-29 21:48:28

[Financial] Breaking out Financial.ts tests into seperate file

Ben Vogt

2

235

220

2017-04-29 21:43:56

[Engineering] Breaking out Engineering.ts tests into seperate file

Ben Vogt

2

220

205

2017-04-29 21:37:29

[ACCRINT] Filling out tests, adding documentation.

Ben Vogt

2

30

0

2017-04-29 21:27:08

[YEARFRAC, ACCRINT] Improving documentation.

Ben Vogt

2

19

25

2017-04-29 18:23:45

[ACCRINT] work-in-progress, ironing out small errors between gs + mse implementations

Ben Vogt

6

95

5

2017-04-29 16:41:08

[ArgsChecker] cleaning up types

Ben Vogt

3

6

4

2017-04-29 16:36:57

[WORKDAY.INTL] formula added and tested

Ben Vogt

4

174

10

2017-04-29 16:11:05

[WORKDAY] formula fully tested

Ben Vogt

2

27

10

2017-04-29 01:10:22

[WORKDAY] work-in-progress on formula and tests, adding TODO for NETWORKDAYS$INTL

Ben Vogt

4

69

19

2017-04-28 23:39:17

[TIME] formula added and tested

Ben Vogt

4

54

13

2017-04-27 03:06:30

[ExcelTime, TIME, README.md] Documenting how types are compared and displayed.

Ben Vogt

3

26

3

2017-04-27 02:30:55

[ExcelTime, TIME] It would be useful to have a class for time of day

Ben Vogt

3

58

5

2017-04-27 02:00:00

[TODAY] formula added and tested

Ben Vogt

3

34

5

2017-04-26 02:15:30

[NETWORKDAYS.INTL] adding type checks, tests

Ben Vogt

2

15

4

2017-04-26 02:09:28

[NOW] formula added and tested

Ben Vogt

6

79

25

2017-04-26 01:38:47

[ExcelDate] Using seconds as ExcelDate storage

Ben Vogt

5

31

29

2017-04-26 00:17:02

[NETWORKDAYS.INTL, README.md] formula added and tested, added TODOs

Ben Vogt

4

170

5

2017-04-23 19:28:35

[NETWORKDAYS] formula added and tested

Ben Vogt

3

136

6

2017-04-20 02:10:50

[SECOND] formula added and tested

Ben Vogt

3

58

5

2017-04-19 01:33:49

[MINUTE,README.md] formula added and tested, adding TODOs

Ben Vogt

4

77

13

2017-04-19 01:13:59

[HOUR, TIMEVALUE] formula added and test, updating parsing and tests for latter

Ben Vogt

4

149

53

2017-04-16 16:45:11

[TIMEVALUE] formula added and tested

Ben Vogt

4

203

109

2017-04-16 15:54:53

[YEARFRAC] formula added and tested

Ben Vogt

2

60

0

2017-04-15 19:54:28

[WIP:YEARFRAC] formula partially added and tested

Ben Vogt

3

113

10

2017-04-15 18:33:53

[DATEDIF] formula added and tested

Ben Vogt

3

157

24

2017-04-15 03:45:16

[WEEKNUM] formula added, tested and working

Ben Vogt

2

23

8

2017-04-15 03:19:13

[WIP:WEEKNUM] more tests for types 13 through 21

Ben Vogt

2

247

2

2017-04-15 01:27:50

[WIP:WEEKNUM] shifting using a better shift-system

Ben Vogt

2

179

16

2017-04-12 02:44:25

[WIP:WEEKNUM] shifting weekdays based on shift-system

Ben Vogt

2

203

4

2017-04-11 01:48:50

[WIP:WEEKNUM] formula added and *partially* tested

Ben Vogt

3

85

3

2017-04-08 00:55:28

[WEEKDAY] formula added and tested

Ben Vogt

3

137

3

2017-04-08 00:04:30

[YEAR] formula added and tested

Ben Vogt

3

50

4

2017-04-07 23:52:57

[MONTH] formula added and tested

Ben Vogt

3

45

6

2017-04-03 01:28:29

[DAYS360] formula added and tested

Ben Vogt

2

85

1

2017-04-03 01:04:41

[DAYS] formula added and tested

Ben Vogt

2

51

3

2017-04-02 23:43:17

[EDATE, DAY, EOMONTH] checking for boolean values and converting

Ben Vogt

4

95

12

2017-04-02 20:29:59

[errors] refactoring errors

Ben Vogt

12

208

166

2017-04-02 19:50:03

[licenses] adding licenses

Ben Vogt

4

61

2

2017-04-02 19:45:27

[ALL] Criteria evaluations accept dollar-to-number comparisons, eg '>=-0'

Ben Vogt

3

13

17

2017-04-02 19:32:38

[ALL] checking for DIV_ZERO errors

Ben Vogt

5

41

21

2017-04-02 18:56:53

[EOMONTH, README.md] formula written and tested, adding testing best-practices for readme

Ben Vogt

4

85

10

2017-04-02 18:41:37

Refactoring date string parsing to be a utility because it's required by other functions.

Ben Vogt

3

835

712

2017-04-02 17:09:14

EDATE formula tested and working

Ben Vogt

2

13

1

2017-04-02 01:39:25

work-in-progress on EDATE function

Ben Vogt

7

105

109

2017-04-01 22:10:47

riteria evaluations should accept '<>'

Ben Vogt

3

8

4

2017-04-01 22:06:20

Cleaning up README.md, documentation.

Ben Vogt

3

4

79

2017-04-01 22:00:31

Fixing up some of the delimiter issues.

Ben Vogt

3

147

93

2017-04-01 21:19:06

adding some more tests back in

Ben Vogt

3

90

92

2017-04-01 20:54:45

Timestamp regex functioning, still filling out tests

Ben Vogt

3

203

219

2017-04-01 20:33:18

work-in-progress on overloading the timestamps to shift datevalues up or down

Ben Vogt

3

88

12

2017-04-01 18:22:06

Adding timestamp capture group to last regex, documenting DateRegExBuilder

Ben Vogt

3

110

15

2017-04-01 18:01:08

Ading timestamp capture to a couple more date regular expressions

Ben Vogt

3

77

8

2017-04-01 17:29:25

Getting closer to having secondary parsers for the timestamp part of the date values

Ben Vogt

3

49

9

2017-04-01 16:43:46

Starting work on adding optional timestamp capture group to regular expressions

Ben Vogt

3

11

50

2017-04-01 15:04:51

Using DateRegExBuilder to capture MONTHNAME_YEAR, Month(fd)YYYY, 'Aug 1992'

Ben Vogt

2

42

1

2017-04-01 14:59:49

Using DateRegExBuilder to capture YEAR_MONTHNAME, YYYY(fd)Month, '1992/Aug'

Ben Vogt

2

40

0

2017-04-01 14:51:13

Using DateRegExBuilder to capture MONTHDIG_YEAR, MM(fd)YYYY, '06/1992'

Ben Vogt

2

49

0

2017-04-01 14:42:26

Using DateRegExBuilder to capture YEAR_MONTHDIG, YYYY(fd)MM, '1992/06'

Ben Vogt

2

37

1

2017-04-01 02:02:00

Cleaning up some of the testing functions.

Ben Vogt

3

49

18

2017-04-01 01:51:08

Using DateRegExBuilder to capture DAY_MONTHNAME_YEAR, DD(fd)Month(fd)YYYY, '24/July/1992'

Ben Vogt

2

77

16

2017-04-01 00:30:02

Using DateRegExBuilder to capture MONTHDIG_DAY_YEAR, MM(fd)DD(fd)YYYY, '06/24/1992'

Ben Vogt

3

86

122

2017-03-27 03:02:33

First use of one of the 'super capture groups' with YEAR_MONTHDIG_DAY

Ben Vogt

4

378

690

2017-03-27 02:21:11

Preparing to use the best of all worlds in the DateRegExBuilder

Ben Vogt

2

136

58

2017-03-27 01:39:38

Taking a step backwards to build up to the more complex regular expressions

Ben Vogt

2

2

42

2017-03-27 00:31:12

Using DateRegExBuilder for 'MONTHNAME_YEAR_COMMON_DELIMITERS, Month YYYY, June 2012'

Ben Vogt

3

19

2

2017-03-27 00:12:09

Using DateRegExBuilder for 'DAY_MONTHNAME_YEAR_COMMON_DELIMITERS, DD Month YYYY, 20 September 1992'

Ben Vogt

3

15

2

2017-03-27 00:02:11

Using DateRegExBuilder for 'MONTHNAME_DAY_YEAR_COMMON_DELIMITERS, Month DD YYYY, September 20 1992'

Ben Vogt

3

35

5

2017-03-26 23:30:17

Fixing some typos in the plan

Ben Vogt

2

9

5

2017-03-26 23:14:05

using DateRegExBuilder for 'YYYY/MM/DD HH:mm'

Ben Vogt

3

75

30

2017-03-26 23:05:21

Using DateRegExBuilder for 'YYYY/MM/DD HH(am|pm)'

Ben Vogt

2

31

5

2017-03-26 22:54:37

Using DateRegExBuilder for 'MM/DD/YYYY'

Ben Vogt

3

27

10

2017-03-26 22:50:23

Using DateRegExBuilder instead of hand-crafted regular expressions

Ben Vogt

2

101

0

2017-03-26 22:40:35

Adding some notes and reconsidering how I'm approaching regular expressions for dates

Ben Vogt

3

145

8

2017-03-26 20:28:03

Refactoring some of the previous regular expressions to make them more flexible.

Ben Vogt

2

58

69

2017-03-26 19:59:28

working on parsign 'DD Month (Year)' parsing for DATEVALUE

Ben Vogt

2

40

0

2017-03-25 17:34:32

parsing 'Month DD' values for DATEVALUE

Ben Vogt

4

430

363

2017-03-25 16:21:11

parsing 'Month YYYY' values for DATEVALUE

Ben Vogt

3

50

2

2017-03-20 00:34:02

parsing '(Dayname) DD Month YYYY' values for DATEVALUE

Ben Vogt

2

47

2

2017-03-18 22:29:27

parsing '(Dayname) Month DD YYYY' values for DATEVALUE

Ben Vogt

2

46

0

2017-03-14 01:47:59

parsing YYYY/MM/DD HH:mm:ss values for DATEVALUE

Ben Vogt

3

142

9

2017-03-12 19:35:24

Adding more tests for minute-overflow, because I am nervous about it.

Ben Vogt

4

22

11

2017-03-12 19:25:13

experimenting with using utc() instead of dst

Ben Vogt

3

21

27

2017-03-12 18:43:57

WIP on ap/pm and minute overflow for YYYY/MM/DD HH:mm(am|pm)

Ben Vogt

2

98

5

2017-03-10 04:52:18

YYYY/MM/DD HH:mm parsing for DATEVALUE

Ben Vogt

3

41

106

2017-03-10 04:20:05

YYYY/MM/DD HH(am|pm) parsing for DATEVALUE

Ben Vogt

2

94

0

2017-03-06 00:16:16

MM/DD/YYYY parsing for DATEVALUE

Ben Vogt

2

70

3

2017-03-05 18:47:47

YYYY/MM/DD parsing for DATEVALUE

Ben Vogt

2

105

33

2017-02-28 05:43:28

Fixing overflow params for DATE, adding docs, adding TODOs to README.md

Ben Vogt

5

28

33

2017-02-28 05:10:21

Documentation for DATEVALUE and adding TODO to README.md

Ben Vogt

2

6

2

2017-02-26 21:44:21

Checking for '1-23-2012' style date formats in DATEVAUE

Ben Vogt

3

53

14

2017-02-26 20:56:14

Checking for '2012-6-6' style date formats in DATEVAUE

Ben Vogt

3

30

2

2017-02-26 20:47:30

Testing DATEVALUE more thuroughly

Ben Vogt

1

16

0

2017-02-26 20:35:34

Working on regex for parsing '2012/1/23' date strings

Ben Vogt

3

51

7

2017-02-26 20:14:05

Working on regex for parsing '1/23/2012' date strings

Ben Vogt

2

14

8

2017-02-26 18:44:42

Starting work on DATEVALUE, adding TODOs to README.md

Ben Vogt

2

23

2

2017-02-26 18:38:42

Catching negative values for ExcelDate in DATE formula

Ben Vogt

3

72

54

2017-02-26 18:27:02

Commenting out some data-related tests until I get ExcelDate working

Ben Vogt

4

26

18

2017-02-26 17:53:20

Starting the very long and painful process of dealing with dates and time in javascript.

Ben Vogt

5

102

56

2017-02-24 04:32:48

Starting work on Date.ts.

Ben Vogt

4

109

27

2017-02-24 03:13:33

Added Formulas.CUMIPMT

Ben Vogt

3

126

32

2017-02-24 02:37:18

Added Formulas.CUMPRINC

Ben Vogt

4

110

2

2017-02-21 05:06:50

Categorized functions

Ben Vogt

5

725

716

2017-02-20 22:40:48

Engineering.ts refactoring done.

Ben Vogt

3

18

21

2017-02-20 22:38:52

Refactoring some functions to Text.ts and Engineering.ts

Ben Vogt

4

148

135

2017-02-20 22:33:20

Labeling exported functions for refactoring/categorizing

Ben Vogt

3

32

27

2017-02-20 22:22:32

Starting to move functions from Math.ts to Statistical.ts

Ben Vogt

3

263

243

2017-02-20 22:09:23

Refactoring functions into category files, creating Financial.ts

Ben Vogt

3

222

234

2017-02-20 22:04:42

Added Formulas.DOLLARFR

Ben Vogt

2

49

2

2017-02-20 21:59:18

Added Formulas.DOLLARDE

Ben Vogt

2

51

2

2017-02-20 19:40:20

Added Formulas.DOLLAR

Ben Vogt

5

55

6

2017-02-20 18:41:30

Added Formulas.EXPONDIST

Ben Vogt

3

52

1

2017-02-20 18:02:49

Added Formulas.COMBIN

Ben Vogt

3

78

2

2017-02-20 17:43:17

Added Formulas.PEARSON and Formulas.CORREL

Ben Vogt

3

121

8

2017-02-20 17:11:40

Removing COVARIANCEP and COVARIANCES because they're not in GS. Might bring them back later.

Ben Vogt

3

7

17

2017-02-19 21:29:30

Added Formulas.EFFECT

Ben Vogt

4

52

5

2017-02-19 21:07:56

Added Formulas.FINV

Ben Vogt

4

162

8

2017-02-19 20:44:22

Refactring some functions/formulas into Math.ts

Ben Vogt

2

361

456

2017-02-19 20:39:26

Added Formulas.FDIST$LEFTTAILED (aka F.DIST)

Ben Vogt

3

183

1

2017-02-19 18:28:36

Added Formulas.ERFC

Ben Vogt

2

65

38

2017-02-19 18:20:15

Added Formulas.ERF

Ben Vogt

2

81

2

2017-02-19 17:16:21

Added Formulas.DEVSQ

Ben Vogt

4

46

2

2017-02-19 17:03:34

Added Formulas.DDB

Ben Vogt

2

81

9

2017-02-18 22:54:59

Added Formulas.DB

Ben Vogt

3

81

5

2017-02-18 22:29:25

Added Formulas.SUMX2PY2

Ben Vogt

3

52

7

2017-02-18 22:13:27

Added Formulas.SUMX2MY2

Ben Vogt

2

46

2

2017-02-18 21:54:54

Added Formulas.COUNTUNIQUE

Ben Vogt

3

62

3

2017-02-18 21:16:09

Added Formulas.SUMPRODUCT

Ben Vogt

4

93

3

2017-02-18 18:39:51

Added Formula.FISHERINV

Ben Vogt

2

32

2

2017-02-18 18:34:40

Added Formula.FISHER

Ben Vogt

2

47

4

2017-02-18 18:26:42

Reorganizing formulas

Ben Vogt

3

344

396

2017-02-18 18:14:11

Removing unused formulas

Ben Vogt

4

4

27

2017-02-18 06:01:19

Added Formulas.SQRTPI

Ben Vogt

2

41

1

2017-02-18 05:52:16

Added Formulas.BIN2OCT

Ben Vogt

2

73

2

2017-02-18 05:37:44

Added Formulas.BIN2HEX

Ben Vogt

4

107

25

2017-02-18 05:07:13

Added Formulas.BIN2DEC

Ben Vogt

3

39

3

2017-02-18 01:18:06

Added Formulas.RADIANS

Ben Vogt

2

29

1

2017-02-18 01:08:14

Added Formulas.DEGREES

Ben Vogt

2

29

2

2017-02-18 01:03:29

Added Formulas.DEC2OCT

Ben Vogt

2

88

3

2017-02-17 22:58:24

Added Formulas.DEC2HEX

Ben Vogt

2

92

3

2017-02-16 05:00:35

Added Formulas.DEC2BIN

Ben Vogt

2

102

2

2017-02-16 03:10:00

Moving casting functions into TypeCaster, array functions into Filter

Ben Vogt

6

457

381

2017-02-16 03:00:40

Refactoring some more formulas into their correct files

Ben Vogt

3

149

108

2017-02-16 02:52:43

Added Formulas.SPLIT

Ben Vogt

3

72

2

2017-02-16 02:10:29

Added Formulas.SUMSQ

Ben Vogt

3

58

1

2017-02-16 01:52:34

Added Formulas.TRUNC

Ben Vogt

2

44

3

2017-02-16 01:42:28

Added Formulas.CONCATENATE

Ben Vogt

2

41

2

2017-02-16 01:29:57

Refactoring formulas into files

Ben Vogt

2

342

419

2017-02-16 01:26:56

Adding TODOs to README.md

Ben Vogt

1

5

1

2017-02-15 05:12:45

Starting process of refactoring some formulas into categories

Ben Vogt

2

35

31

2017-02-15 05:08:42

Added Formula.AVERAGEIF (with TODOs) and updated TODOs in README.md

Ben Vogt

3

71

2

2017-02-15 04:46:42

Added Formula.CEILING

Ben Vogt

2

46

4

2017-02-15 04:41:31

Added Formula.FLOOR

Ben Vogt

2

48

0

2017-02-15 03:37:13

Added Formula.IF

Ben Vogt

3

38

3

2017-02-15 02:58:27

Added Formula.COUNTIFS

Ben Vogt

3

69

2

2017-02-15 02:19:56

Removing formulas that we don't need.

Ben Vogt

4

7

152

2017-02-13 04:22:34

Added Formula.COUNTIF and simplified criteria evaluation

Ben Vogt

3

241

133

2017-02-10 02:11:41

Added Formula.SUMIF

Ben Vogt

4

125

3

2017-02-10 00:19:13

Adding Formula.ROUNDUP

Ben Vogt

2

34

0

2017-02-09 05:25:20

Adding Formula.ROUNDDOWN

Ben Vogt

2

35

1

2017-02-08 04:44:17

Adding Formula.ROUND

Ben Vogt

2

31

1

2017-02-07 04:07:24

Adding Formula.DELTA

Ben Vogt

3

55

0

2017-02-07 00:52:32

Adding Formula.COUNTA

Ben Vogt

2

40

0

2017-02-07 00:46:10

Formulas.COUNT written and tested.

Ben Vogt

4

60

0

2017-02-05 22:45:34

Formulas.FALSE written and tested.

Ben Vogt

2

11

1

2017-02-05 22:33:20

Formulas.LN written and tested.

Ben Vogt

3

37

4

2017-02-04 22:45:13

Formulas.XOR written and tested.

Ben Vogt

4

81

30

2017-02-04 22:29:23

Refactoring some of the functions

Ben Vogt

2

122

114

2017-02-04 22:26:25

Formulas.LOG10 written and tested.

Ben Vogt

2

38

0

2017-02-04 22:19:34

Formulas.LOG written and tested.

Ben Vogt

2

55

0

2017-02-04 22:04:42

Formulas.POWER written and tested.

Ben Vogt

2

33

0

2017-02-04 21:13:34

Formulas.OR written and tested.

Ben Vogt

3

72

1

2017-02-04 18:11:31

Formulas.TANH written and tested.

Ben Vogt

3

36

3

2017-02-04 18:07:23

Formulas.TAN written and tested.

Ben Vogt

2

30

1

2017-02-04 18:00:32

Refactoring finished formulas into appropriate categories

Ben Vogt

3

205

178

2017-02-04 17:54:35

Adding Formula.SQRT, fixing tests for others

Ben Vogt

3

68

14

2017-02-02 03:37:07

Formulas.ISODD written and tested.

Ben Vogt

2

32

0

2017-02-02 03:34:57

Formulas.ISEVEN written and tested.

Ben Vogt

2

32

2

2017-02-02 03:22:57

Formulas.INT written and tested.

Ben Vogt

2

31

0

2017-02-02 03:16:10

Formulas.COTH written and tested.

Ben Vogt

3

42

1

2017-02-02 03:09:39

Formulas.COT written and tested.

Ben Vogt

2

39

0

2017-02-02 00:11:56

Formulas.COSH written and tested.

Ben Vogt

2

32

2

2017-02-02 00:07:48

Formulas.COS written and tested.

Ben Vogt

2

31

1

2017-02-01 23:42:15

Formulas.CHAR written and tested.

Ben Vogt

2

34

0

2017-02-01 23:33:38

Formulas.CODE written and tested.

Ben Vogt

3

51

2

2017-01-31 14:19:57

Formulas.SINH written and tested.

Ben Vogt

3

33

2

2017-01-31 02:01:29

Formulas.SIN written and tested.

Ben Vogt

3

46

2

2017-01-22 20:25:11

Cleaning up files a bit

Ben Vogt

2

13

12

2017-01-22 19:38:22

Refactoring recently added formulas into correct files

Ben Vogt

3

108

95

2017-01-22 19:34:10

Formulas.AVERAGEA written and tested.

Ben Vogt

2

71

2

2017-01-22 19:06:49

Formulas.AVEDEV written and tested.

Ben Vogt

3

75

2

2017-01-22 17:51:34

Refactoring RawFormulas into several files

Ben Vogt

7

893

885

2017-01-22 17:34:04

Formulas.EXACT written and tested.

Ben Vogt

2

71

0

2017-01-22 17:14:47

Formulas.EVEN written and tested.

Ben Vogt

2

37

1

2017-01-22 17:04:12

Formulas.ODD written and tested.

Ben Vogt

2

38

1

2017-01-22 16:52:52

Formulas.NOT written and tested.

Ben Vogt

2

77

0

2017-01-22 16:24:28

Formulas.MOD written and tested.

Ben Vogt

2

45

0

2017-01-22 16:08:47

Formulas.MINA written and tested.

Ben Vogt

2

11

0

2017-01-22 16:06:48

Formulas.MAXA written and tested.

Ben Vogt

2

12

1

2017-01-22 00:51:41

Formulas.MEDIAN written and tested.

Ben Vogt

2

132

41

2017-01-21 23:59:56

Formulas.MIN written and tested.

Ben Vogt

2

55

1

2017-01-21 23:46:32

Formulas.MAX written and tested.

Ben Vogt

2

47

0

2017-01-21 23:27:53

Formulas.AVERAGE written and tested.

Ben Vogt

2

60

1

2017-01-19 00:23:36

Adding comment about injection attacks.

Ben Vogt

1

6

0

2017-01-19 00:21:08

Formulas.SUM written and tested.

Ben Vogt

2

36

0

2017-01-17 00:35:50

Formulas.ATANH written and tested.

Ben Vogt

3

33

1

2017-01-17 00:04:13

Formulas.ATAN2 written and tested.

Ben Vogt

2

57

0

2017-01-16 23:53:23

Formulas.ASIN written and tested.

Ben Vogt

2

24

3

2017-01-16 23:48:39

Formulas.ASIN written and tested.

Ben Vogt

2

30

0

2017-01-16 23:41:39

Formulas.ARABIC written and tested.

Ben Vogt

2

42

0

2017-01-16 22:14:44

Fixing Formulas.ADD to handle nested data structures

Ben Vogt

2

11

1

2017-01-16 22:08:31

Formulas.AND written and tested.

Ben Vogt

2

47

0

2017-01-16 21:54:55

Formulas.ACOTH written and tested.

Ben Vogt

2

30

1

2017-01-16 21:42:54

Added some documentation.

Ben Vogt

1

19

0

2017-01-16 21:39:16

Formulas.ACOSH written and tested.

Ben Vogt

2

25

2

2017-01-16 21:34:14

Formulas.ACOS written and tested.

Ben Vogt

2

27

2

2017-01-16 21:24:43

Working towards implementing custom formulas and custom errors.

Ben Vogt

3

100

1

2017-01-15 19:54:23

Removing formulas task from TODO in README.md

Ben Vogt

1

0

5

2017-01-15 18:10:11

Simplifying Formulas.ts

Ben Vogt

1

0

200

2017-01-15 17:06:18

More raw formula tests

Ben Vogt

3

417

1

2017-01-14 22:07:26

More formulas as RawFormulas

Ben Vogt

2

141

0

2017-01-14 21:57:27

starting to test RawFormulas without a spreadsheet

Ben Vogt

3

72

3

2017-01-14 21:45:03

WIP on bootstrapping formula functions in so I can rewrite them with greater ease

Ben Vogt

3

21

0

2017-01-14 21:29:34

Refactoring custom formulas and usage

Ben Vogt

2

29

18

2017-01-14 18:26:07

Adding more date tests

Ben Vogt

1

7

0

2017-01-11 01:19:15

Adding TODOs to README.md

Ben Vogt

1

9

2

2017-01-10 23:47:55

Adding tests for YEARFRAC

Ben Vogt

1

7

1

2017-01-10 23:30:02

Linking formulas that are incorrectly named.

Ben Vogt

3

17

9

2017-01-10 23:23:12

Allowing formulas with dot-notation to be parsed as regular formulas.

Ben Vogt

4

39

5

2017-01-08 22:20:45

Working on custom version of ACCRINT

Ben Vogt

2

171

2

2017-01-08 22:08:29

Adding and editing TODOs inside README.md

Ben Vogt

1

8

2

2017-01-08 21:34:38

Fixing one SUM_ test, adding another that should work.

Ben Vogt

1

7

4

2017-01-08 21:29:36

Fixing TAN formula to function properly for PI value

Ben Vogt

2

7

2

2017-01-08 21:25:31

Fixing SIN formula to function properly for PI value

Ben Vogt

2

9

2

2017-01-08 21:17:02

Adding tests for F.INV mapped to FINV

Ben Vogt

1

9

1

2017-01-08 20:22:19

Working on difference between F.DIST and FDIST.

Ben Vogt

3

12

2

2017-01-08 18:37:35

Adding formula and test EOMONTH

Ben Vogt

3

5

2

2017-01-08 18:22:45

Adding moment to project, implementing certain formulas

Ben Vogt

4

10

4

2017-01-08 00:33:14

Adding some more TODOs to README.md

Ben Vogt

1

10

2

2017-01-08 00:19:34

Implementing and testing some date-based formulas

Ben Vogt

2

11

7

2017-01-07 23:22:30

Getting started on parsing dates

Ben Vogt

2

13

3

2017-01-07 21:56:13

added more formula tests.

Ben Vogt

1

225

9

2017-01-07 18:34:08

Adding basic tests for supported formulas

Ben Vogt

1

206

4

2017-01-06 01:33:27

Adding tests for individual formulas

Ben Vogt

3

67

1

2017-01-05 23:48:00

Adding edge case tests for Sheet.ts

Ben Vogt

2

23

4

2017-01-05 23:43:33

Writing tests for parsing math functions

Ben Vogt

3

14

5

2017-01-02 20:52:24

Adding TODOs while I think of them

Ben Vogt

1

2

0

2017-01-02 20:47:01

Moving helper.number to Helpers.number, adding tests for parsing number-like strings

Ben Vogt

4

43

12

2017-01-01 23:30:21

Ben Vogt

1

3

0

2017-01-01 23:12:40

Correcting cell functions in SheetFormulaTest.ts

Ben Vogt

1

6

6

2017-01-01 21:31:42

Adding TODOs to README.md

Ben Vogt

1

9

0

2017-01-01 21:29:39

Added documentation for Sheet.ts

Ben Vogt

2

104

27

2017-01-01 21:05:42

Making Errors.get use object instead of filtering array

Ben Vogt

1

22

8

2017-01-01 20:56:51

Cell.error is no longer of type 'any'

Ben Vogt

2

7

10

2017-01-01 20:51:24

Documenting Cell.ts

Ben Vogt

2

84

5

2017-01-01 20:36:34

Making Cell instance variables private

Ben Vogt

4

102

73

2016-12-31 22:37:10

Removing A1CellKey because it's unnecessary abstraction

Ben Vogt

5

49

93

2016-12-31 22:25:24

Cosmetic refactoring

Ben Vogt

2

33

31

2016-12-31 22:21:31

Adding tests for specific formulas with SheetFormulaTest.ts

Ben Vogt

1

18

0

2016-12-31 22:14:50

Only parsing cell formulas/values beginning with '='

Ben Vogt

6

61

33

2016-12-31 21:43:49

Adding TODOs, more Sheet.ts tests.

Ben Vogt

2

12

1

2016-12-31 21:34:12

Adding more formula tests for Sheet.ts

Ben Vogt

3

35

1

2016-12-31 21:24:13

Adding src/SupportedFormulas.ts, givng npm a test command

Ben Vogt

3

26

22

2016-12-31 21:20:15

More tests for Sheet.ts, simplifying A1CellKey

Ben Vogt

4

76

26

2016-12-31 20:53:58

Adding TODOs and tests.

Ben Vogt

4

45

11

2016-12-30 23:03:03

Fixing up usages of instance where we don't need it

Ben Vogt

2

17

20

2016-12-30 22:36:34

Correcting dependencies issue.

Ben Vogt

2

5

5

2016-12-30 22:30:24

Refactoring how we load data into a Sheet

Ben Vogt

2

32

25

2016-12-30 21:42:12

Adding TODOs to README.md, using better storage for Matrix.data

Ben Vogt

2

24

16

2016-12-30 21:08:47

Refactoring the way we initialize a Sheet

Ben Vogt

2

6

11

2016-12-29 21:22:03

Adding a test.sh script to compile and run tests.

Ben Vogt

3

18

1

2016-12-29 21:01:30

Adding a few more Cell.ts tests.

Ben Vogt

11

77

2

2016-12-29 16:10:45

Refactoring unused functions in Sheet.ts

Ben Vogt

1

0

15

2016-12-29 16:08:00

Refactoring use of Errors

Ben Vogt

2

27

24

2016-12-27 18:56:06

Pulling out A1CellKey, Cell into class files

Ben Vogt

3

82

83

2016-12-27 18:53:29

Switching to npm instead of browser based developement (working!)

Ben Vogt

22

44

26450

2016-12-27 17:50:01

Ben Vogt

5

7

11

2016-12-27 04:18:39

Minor refactoring

Ben Vogt

2

10

16

2016-12-27 03:53:37

Using typed Matrix.

Ben Vogt

2

154

181

2016-12-27 03:35:28

Logging sheet to console for easier inspection

Ben Vogt

3

7

131

2016-12-27 03:24:21

I could be wrong, but I think I'm getting close!

Ben Vogt

2

145

139

2016-12-26 18:41:35

Making progress on converting everything to a type

Ben Vogt

2

54

65

2016-12-26 18:23:53

WIP on making everything a strict type

Ben Vogt

2

117

23

2016-12-26 18:07:21

Renaming html documents

Ben Vogt

3

3

3

2016-12-26 18:06:42

ts.html and ts/sheet.ts working

Ben Vogt

7

2348

15

2016-12-26 17:59:07

Fixing up naming conventions for mine.js, starting TS version

Ben Vogt

3

40

60

2016-12-26 17:38:00

Getting a very simple version working.

Ben Vogt

5

879

29

2016-12-24 20:23:58

Cleaning up unused functions

Ben Vogt

1

10

547

2016-12-24 20:17:56

Cleaning up view

Ben Vogt

1

0

41

2016-12-24 20:15:17

Ben Vogt

12

25623

0

2018-04-25 06:01:41

fix: point to declaration file

Stephen Murphy

1

2

1

2018-04-25 05:37:04

chore: emit ts declarations

Stephen Murphy

51

3438

41