[R] Excel User interface for R

[David Winsemius]

On Mar 4, 2013, at 5:39 AM, Tammy Ma wrote:

> 
> HI, 
> 
> Assume I have the data frame generated from R as the following:
> 
> Product     Price     market_share
>  A             100        10%
>  B             110        9%
> C              120        20%
> D              90          61%
> 
> What I want to do is to have this kind of excel user interface by changing price of certain products, to get the impact of market share generated from R:
> if I change A price from 100 to 90, and change B price from 110 to 100, based on the calculation in R, I want to get the result from excel, for example,
> 
> 
> Product     Price     market_share
>  A             90        20%
>  B             100       12%
> C              120       10%
> D              90         58%
> 
> 
> I want to have the excel interface which make me be able to change the value in excel cell, then based on the calculation in R, then exported market share impact in excel.
> 
> DO you have recommendation for such user interface or sth which make me achieve this task?

When this request has appeared before, the advice given was to look at RExcel. That is only an option in the Windows environment.

-- 

David Winsemius
Alameda, CA, USA