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?
Thanks.
Kind regards,
Lingyi
[[alternative HTML version deleted]]
______________________________________________
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.
