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 ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.