#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

    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

    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

    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

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

    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 > 1.
    
     
  • David Benn

    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

    David Benn - 2013-04-30

    Fixed in 2.15.1

     

Log in to post a comment.