ExtJS ViewModels for spreadsheet formulas, interactive D3 visualisations and other cool stuff

Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

Rob Boerman CTO & Co-founder, 2Gears

Slide 3

Slide 3 text

2Gears

Slide 4

Slide 4 text

No content

Slide 5

Slide 5 text

ExtJS5 ViewModels

Slide 6

Slide 6 text

ViewModel DataBinding

Slide 7

Slide 7 text

ViewModel DataBinding

Slide 8

Slide 8 text

No content

Slide 9

Slide 9 text

No content

Slide 10

Slide 10 text

D3 Visualisations in ExtJS

Slide 11

Slide 11 text

No content

Slide 12

Slide 12 text

D3 Par''on D3 Pack D3 Tree D3 Sunburst D3 Hierarchy Ext.Component D3M0 D3 Class Structure

Slide 13

Slide 13 text

D3M0 Component Structure Main Tree Par''on D3 Pack D3 TreeD3 Sunburst D3 Dashboard Breadcrumb

Slide 14

Slide 14 text

D3M0 Component Structure Main Tree Par''on D3 Pack D3 TreeD3 Sunburst D3 Dashboard Breadcrumb MainModel

Slide 15

Slide 15 text

No content

Slide 16

Slide 16 text

No content

Slide 17

Slide 17 text

No content

Slide 18

Slide 18 text

D3M0 Binding

Slide 19

Slide 19 text

D3M0 Binding Main Tree Par''on D3 Pack D3 TreeD3 Sunburst D3 Dashboard Breadcrumb MainModel selec'on selec'on

Slide 20

Slide 20 text

D3 Visualisations in ExtJS

Slide 21

Slide 21 text

Businessplan in Excel

Slide 22

Slide 22 text

Businessplan in Excel Coach Entrepreneur Email, XLS comments, Track changes, … XLS, XLSX, OpenOﬃce, …

Slide 23

Slide 23 text

Main challenge Formulas

Slide 24

Slide 24 text

Excel formulas D1 A1 B1 C1 D5 D2 D3 D4

Slide 25

Slide 25 text

Excel formulas D1 A1 B1 C1 D5 D2 D3 D4 Ext.grid.Panel Ext.app.ViewModel

Slide 26

Slide 26 text

JenC Demo

Slide 27

Slide 27 text

App Structure BusinessPlan Tree BreadCrumb Content BusinessPlanModel EditorContainer Sec'on 1 Sec'on 2 … BPStores store: {BpNavStore} Store Chain

Slide 28

Slide 28 text

Formula in Form BusinessPlanModel {Bind}

Slide 29

Slide 29 text

Formula in Form BusinessPlanModel

Slide 30

Slide 30 text

Formula in Grid BusinessPlanModel {Bind}

Slide 31

Slide 31 text

Formula in Grid BusinessPlanModel BPStores

Slide 32

Slide 32 text

Formula in Grid BusinessPlanModel BPStores 12x

Slide 33

Slide 33 text

Formula in Grid BusinessPlanModel BPStores

Slide 34

Slide 34 text

Formula in Grid BusinessPlanModel BPStores

Slide 35

Slide 35 text

Managing formulas BusinessPlanModel BPStores

Slide 36

Slide 36 text

Binding formulas to records

Slide 37

Slide 37 text

ViewModel Formulas SUM * 12 A * 12 B Func'onNode OperatorNode ConstantNode SymbolNode

Slide 38

Slide 38 text

ViewModel Formulas Run when dependencies change Run MathJS with ViewModel data Update record ﬁeld with result Inject Formula ‘Stub’ in ViewModel Return result to store in ViewModel

Slide 1

Slide 1 text

Slide 2

Slide 2 text

Slide 3

Slide 3 text

Slide 4

Slide 4 text

Slide 5

Slide 5 text

Slide 6

Slide 6 text

Slide 7

Slide 7 text

Slide 8

Slide 8 text

Slide 9

Slide 9 text

Slide 10

Slide 10 text

Slide 11

Slide 11 text

Slide 12

Slide 12 text

Slide 13

Slide 13 text

Slide 14

Slide 14 text

Slide 15

Slide 15 text

Slide 16

Slide 16 text

Slide 17

Slide 17 text

Slide 18

Slide 18 text

Slide 19

Slide 19 text

Slide 20

Slide 20 text

Slide 21

Slide 21 text

Slide 22

Slide 22 text

Slide 23

Slide 23 text

Slide 24

Slide 24 text

Slide 25

Slide 25 text

Slide 26

Slide 26 text

Slide 27

Slide 27 text

Slide 28

Slide 28 text

Slide 29

Slide 29 text

Slide 30

Slide 30 text

Slide 31

Slide 31 text

Slide 32

Slide 32 text

Slide 33

Slide 33 text

Slide 34

Slide 34 text

Slide 35

Slide 35 text

Slide 36

Slide 36 text

Slide 37

Slide 37 text

Slide 38

Slide 38 text

Slide 39

Slide 39 text

Slide 40

Slide 40 text