Standardised mortality rate and forest plot


in the past i have successfully created a forest plot for odds ratios. However I am struggling to do the same for Standardised Mortality Rates.

I have attached an excel example of some made up data that i would like to forest plot.


It wouldn't matter to me whether or not I needed to calculate the SMR, CIs and p values before import or have them calculated within r, as long as i can forest plot them!

Something along the lines of:

forest ex.png

forest ex2.png

Could anyone help or point me to an example of how it could be done?

Thank you.