Customize An Excel Spreadsheet

It will give you the full list upon selection but there are few more additions to the metrics like unique visitors, etc. I need to do a nice excel spreadchat that calculates metrics for goals…1 year, 6 month,3 month, 1 month, weekly, and daily goals.

I should be able to enter the 1 year goals and then it trickles down and automatically fills in the rest of the chart. I will have a metrics list of site goals in terms of traffic, sales, conversions, etc.

I should be able to adjust the monthly growth rate to also manipulate the chart.

I will have data like this

http://tctechcrunch.files.wordpress.com/2010/05/grouponcategories.png
http://tctechcrunch.files.wordpress.com/2010/05/groupondeals.png
http://tctechcrunch.files.wordpress.com/2010/05/grupontable3.png
http://tctechcrunch.files.wordpress.com/2010/05/groupontable4.png

I essentially want to just customize a working forecasting model to help manage projections and forecasts for key metrics for my website.

Maybe we can customize something from this list

http://www.exinfm.com/free_spreadsheets.html

Leave a Reply

Your email address will not be published. Required fields are marked *