I received to create a reporting tool either with Excel or on Sharepoint. Every week a fix number of departments have to report on a couple of fixed topics with fix answers Yes/No or a number 10%, 20%... Each month this data will be assessed for progress and built some charts, bar or wathever. For one week this is a 2 dimension sheet. I call this Table weekly_report_#week:
How would you do this? Cool would be the follwoing idea but I don't know how to do this. Every week an empty list is provided. Short before preparing the new empty list for the next week, people can update the current list. On due date the following happens: The current weeks list gets a date stamp and is attached to the list of the week before. This gives me a chain of blocks
Every month then like in a pivot chart, four weeks are analyzed and shown in charts to show progres.
Is this possible automatically of course :-)