## #354 Permit Excel, R or ... view of model equation.

Enhancement
closed-fixed
8
2013-04-30
2013-02-26
David Benn
No

The Model Info dialog should permit an Excel or equation view of a model. This may be more useful to someone than the current form, e.g.

f(t) = 3.87983149
+0.16036346 × cos(2π0.18656716t)-0.27285370 × sin(2π0.18656716t)
+0.11012972 × cos(2π0.37313433t)-0.01672236 × sin(2π0.37313433t)
+0.02119347 × cos(2π0.55970149t)+0.02377117 × sin(2π0.55970149t)

would look like this in Excel:

=sum(3.87983149, 0.16036346 * cos(2*PI()*0.18656716*A1)-0.27285370 * sin(2*PI()*0.18656716*A1), 0.11012972 * cos(2*PI()*0.37313433*A1)-0.01672236 * sin(2*PI()*0.37313433*A1), 0.02119347 * cos(2*PI()*0.55970149*A1), 0.02377117 * sin(2*PI()*0.55970149*A1))

where A1 replaces t, and assumes that JD values will be in A1..n. A fill-down operation in Excel would change this to Am, m > 1.

## Discussion

• David Benn - 2013-02-28
• summary: Permit Excel or equation view of model. --> Checkbox to permit Excel, R or ... view of model equation.

• David Benn - 2013-02-28

I suppose a plugin category coud be created for exporting models in VStar but that's probably overkill. Choosing common tools like Excel and R makes good sense.

There probably is a place for a general category of data exporter plugin though. That's the opposite of observation source plugin.

• David Benn - 2013-02-28

For R, '+' line continuation characters would be required at the start of each line if split over more than one line.

• David Benn - 2013-03-25
• priority: 7 --> 8

• David Benn - 2013-03-25
• Description has changed:

Diff:

```--- old
+++ new
@@ -7,12 +7,6 @@

would look like this in Excel:

-=sum\(3.87983149,
-0.16036346 \* cos\(2\*PI\(\)\*0.18656716\*A1\)-0.27285370 \* sin\(2\*PI\(\)\*0.18656716\*A1\),
-0.11012972 \* cos\(2\*PI\(\)\*0.37313433\*A1\)-0.01672236 \* sin\(2\*PI\(\)\*0.37313433\*A1\),
-0.02119347 \* cos\(2\*PI\(\)\*0.55970149\*A1\),
-0.02377117 \* sin\(2\*PI\(\)\*0.55970149\*A1\)\)
-
=sum\(3.87983149, 0.16036346 \* cos\(2\*PI\(\)\*0.18656716\*A1\)-0.27285370 \* sin\(2\*PI\(\)\*0.18656716\*A1\), 0.11012972 \* cos\(2\*PI\(\)\*0.37313433\*A1\)-0.01672236 \* sin\(2\*PI\(\)\*0.37313433\*A1\), 0.02119347 \* cos\(2\*PI\(\)\*0.55970149\*A1\), 0.02377117 \* sin\(2\*PI\(\)\*0.55970149\*A1\)\)

where A1 replaces t, and assumes that JD values will be in A1..n. A fill-down operation in Excel would change this to Am, m &gt; 1.
```

• David Benn - 2013-04-30
• summary: Checkbox to permit Excel, R or ... view of model equation. --> Permit Excel, R or ... view of model equation.
• status: open --> closed-fixed

• David Benn - 2013-04-30

Fixed in 2.15.1