I didn't save my spreadsheet and it was a hot mess! Maybe a tech savvy DISer could come up with one.....
Anyway.
One area was for park tickets. We have our plane tickets already so this was a set number. You could have a selection of days, with or without hopping, waterparks option.
One area for the dining plan. Again, our number of days is already known so this was a fixed amount. You could have a selection of days, quick service plan, deluxe plan.
One area was what I thought we would actually purchase on the dining plan. I looked at our ADRs, and came up with good averages for snacks and quick service meals. That was really eye opening. I knew with a lot of character breakfast buffets scheduled we wouldn't maximize the plan, but I didn't realize we'd come up $600 short.
The last area was for hotel costs. Plugged in the cost for several resorts we are interested in and then had columns of what the rooms would cost with various percentages off.
I was just trying to figure out whether
free dining or a room discount would be better but for planning purposes you could include a transportation and souvenir area too.
I wish I was tech savvy enough to make a website where people could just plug in their numbers and it would spit out several options.