at a moment i am facing the unenviable task to design an Excel sheet as a template for an excel output feature for an online questionnaire tool.
I am looking for inspiration on displaying the results of single answer questions, multiple answers questions and matrices( is that the plural?) . Percentages and absolute numbers.
I know, i know, that's simple you might say, but you do not know my client.
Links or hints will be appreciated
That looks like a pretty standard speadsheet design, although I don't speak German, so I don't have the foggiest idea of what you're getting percentages on.
2 things to consider though - You have a lot of disparate ranges, I.E. ranges with 4 rows, one with 5 and so on. That can make summarization of multiple sheets difficult, especially if any of those ranges will ever be bigger/smaller. Second, depending on your PC, extending formatting all the way out to IV can impair spreadsheet performance and size. Keep your formatting in just the Used Range, then delete the unused rows & columns to clear the formatting and memory.
Now, i got this as an suggestion. (without the graphics they said)
So the spreadsheet is dead for now, i guess.
Those people seem to be determined to keep me busy.
I would still appreciate some suggestions according to what standards a good (perfect ) Excel table collection should meet.
Or if you ever wanted to vent your frustration about an especially stupid table design, this would be the time and the place