@Victor_G 's answers are really good.
On question 2, I would add that you can't calculate power based only on alpha = 0.5 and RMSE = 1. As I said in an earlier reply, you also need an estimate of the signal size that you need to detect.
I would also add that calculating the power in Excel is not going to be easy. I would not recommend trying this.
If you really want to understand power, I would recommend running some simulations instead.
1. Create your experimental design
2. Determine a model to calculate your response for each run with parameters for each "active" factor effect (In JMP these are the "anticipated coefficients")
3. Add random noise to your each response value (e.g. with standard deviation of 1, mean of 0)
4. Analyse the simulated data to determine if the active effects are significant at your determined level of alpha (0.05 is most often used, 0.5 would be a strange choice!)
5. Repeat steps 3 and 4 many times with new random noise.
6. Count the number of times that each active effect is declared significant
You should find that the proportion of times that the active effects are declared significant matches the power calculated by JMP.
This kind of simulation is very easy to do in JMP Pro. In fact, it is used in situations where a priori power estimation is not possible. For example, where the response is binary. I once used this to help a marketing company determine the power of an experiment to understand factors affecting response ( respond / don't respond) to their promotions!
It would be more effort and would require some scripting to do this kind of simulation in JMP. But I still think that would be a better use of time than trying to calculate power in Excel.