Excel User interface for R
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