yogi_Create User Specified Reports By Month And Year And For This Week Last Week And Week Before Last Week

                                           Google Spreadsheet   Post  #836
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Oct 29, 2012
user mojo_247 said: (http://productforums.google.com/forum/?zx=g9a265uola4#!category-topic/docs/spreadsheets/Py3sTHEixXY)
need help with creating a report from table
Hi 

I'm using a large spreadsheet, off which I need to generate various report.

Following is a very small sample of the data and the reports I need to generate.

https://docs.google.com/spreadsheet/ccc?key=0AgQAZzfYzo1MdDdWaTBpSUdOc08xNzJkMDdiUkZYR3c

Could I please get some assistance with this.

TIA

------------------------------------------------------------------------------------

following is a solution to the problem