The spreadsheet gives the power for inputted group proportions (which should sum to 1), Type I error and a given total sample size. The expected proportions assume equal group sizes. Power may also be obtained using R.
The expected effect size, $$\omega$$, defined below is from Cohen (1977,1988, Chap 7).
$$\omega = \sqrt{ \sum_text{1}text{no. groups} \frac{\mbox{(observed proportion - expected proportion)}text{2}}{ \mbox{ expected proportion}}}$$
The thresholds 0.1, 0.3, 0.5 correspond to small, medium and large $$\omega$$ effect sizes.