Small data calculator and visualization project in Google Sheets

Job ID: 37943844

Budget: $10 – $30 USD

I need someone to make a calculator (in Google Sheets) and some really nice charts to easily visualize the data as well.

Token A = Variable market price from 0 to 10 USD max (or infinite)
Token B = Always 1 USD

Token A generates Token B automatically by staking it in a web3 contract.

---

Calculator:
Input 1: Amount of Token A
Input 2: Token A Price
Input 3. APY

Output 1: Amount of Token B Generated
Output 2: APY (Annual Percentage Yield)

---

Chart 1:
Line chart modeling Token B Generation based on Token A Price and APY

Chart 2:
Line chart modeling APY based on Token A Price

Chart 3:
Anything else that could be modeled

---

+Any other fancy charts you can come up with.

The above might not be accurate, but you should be able to figure out what I need.

I will let the bidding run for 24 hours.
Related categories: Data Processing Charts Google Sheets