First, I am not a programmer or mathematician, so please keep this in mind. I am a noob.

The purpose of this is to see how miner's fee are adjusted in relation to the following three factors:

1. Current BTC Price (USD)

2. Average Number of Tx a Day

3. Current Block Award Amount

The Miner's argument seems to be that when the block award is gone (decreases) fees must go up.

But the question I have is: What is the equation or formula to determine a fair future fee?

With all the discussions/arguments/and stress testing, I have not seen anyone propose an equation or formula

that could potentially be used to automate miners fees for now and the future.

Nor has anyone (that I have seen) have provided graphs or explanations as to how these three factors determine future fees.

*If the 1MB Cap is raised, then the mempool and unconfirmed status can not be used as measurement to pay a certain miner fee*.

Below is a picture of my formula with descriptions.

**Here is the link to google spreadsheets:** https://docs.google.com/spreadsheets/d/1PKlZu8CuRUt-FItq_X3WzxxPsc8XzEUdSIejF1OwI_c/edit?usp=sharing**In google spreadsheets, you can edit the yellow boxes to change the three factors (inputs) to see different results.**Please discuss and or correct.

Edit: Is this even viable? But if it is not (since I'm not educated in these matters) hopefully this will inspire the experts with other ideas.