If you are willing to assume/WAG values for variables such as;
- Appropriate BCF or drainage radius per Well required for field development,
- mmscf/day capacity per well,
- manually enter a drill schedule that takes into account logistical realities as well as production decline
- EUR & Abandonment rate/THP
- CGR

then you can surely get something along the lines of what you outline

I think where our lines are getting crossed is the notion that a generic sheet would calculate all of these for you - this will not be the case.