Fileds to use: Hash rate, power, power cost, difficulty, block reward, pool rejects, pool fees, XMR/fiat, and hardware costs.
Ideally, I would then use this information to estimate mining profits in the future (6 months, 1 year, 2 years, 3 years, etc) using the reward curve and projecting a difficulty over time. It would also be cool to mess around with the price of Monero over time, for example assuming the price will increase 5% a month on average or something like that. I want to be able to manipulate the variables to compare profit possibilities.
Does anyone have any thoughts of how to do this? I can make an Excel document, but I do not know what calculations to put into Excel.