Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Spreadsheet Organization
Can anyone give me some advice on a neater way to organize my spreadsheet
data? Here is the scenario. I print out several different data reports. Each report contains 2 to 7 columns. The reports are printed on a monthly basis and give statistical information. I would like to show the trends over a period of time by month. For example, I have one report called "Enhanced System" and within that report are 2 columns columns called Queue Length and Processes. Then I have another report called "Performance" and that report has 3 columns called Memory, Disk, and CPU. Each report has only 2 records of data, one record for each server monitored. I was going to create one column on the left with each row for a column from the report then go horizontally with headers as months however the problem is that I also need to know which report each row goes with. In the example I only gave 2 reports but in truth there are 21 reports with number of statistical columns varying. Sept Oct Nov Dec report1 column1 report1 column2 report2 column1 report2 column2 report2 column3 If any suggestions come to mind PLEASE let me know. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to handle multiple currencies with one spreadsheet | Excel Discussion (Misc queries) | |||
Using Excel spreadsheet as input to Access | Excel Discussion (Misc queries) | |||
Spreadsheet merging problems | Excel Worksheet Functions | |||
Linkage data between two spreadsheet | Excel Worksheet Functions | |||
Linking formula to external spreadsheet | Excel Discussion (Misc queries) |