Google Sheet: Bayesian AB Test MDE Calculator

Hi, I need a google sheet calculator created that will quickly calculate the required MDE for a test when the following information is entered: Weekly visitors: X Conversion Rate: Y Test duration: Z weeks Probability Level: 75% Traffic % included: 100% Number of variations (including control): 2 Output: MDE (minimum detectable effect): X% Adjusting input data will of course change the required MDE%. Note: See a working example of this on the following page: [login to view URL] You will see how it calculates the number of days a test should run for when the daily visitors, conversion rate and MDE are supplied. In contrast to this of course, I need to know what the MDE based my supplied data. Use case for this calculator: This will give me a understanding of the minimum MDE I need to achieve in a test in order to determine a result. Note: I need this information in Google Sheets, weather that is a formula or a result pulled in from another source. Open to ideas there. Thanks, Kev