Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Huge data structure in Excel
Hi,
I wonder if Excel is the right app for this. I'll try and be brief. I have some aircraft data: latitude, logitude, height, time/date and a crucial number called vertical acceleration in m/s (call it VA). I have this data for 40 aircraft spanning 10 years and so the number of these records is several million. Now, I would like to set up a multidimensional structure where I can view histograms of VA for any height band (say 9000 to 10000 feet) for any month/year for any aircraft for a particular latitude/longitude square (say 2 x 2 degrees). I was thinking in terms of multiple workbooks (one for each aircraft) and multiple sheets in each workbook, a sheet one for each month where each sheet would contain lat/lon height columns and rows would contain numbers of VA occurances from which the VA histograms could be built. How fast would such a structure be if I wanted to sum over several years for a particular number of aircraft for a given height band, month and location and come up with a histogram? Put simply is this feasible in Excel? Any suggestions welcome, Milo. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Excel PivotTable for a huge DataBase from External Data | Excel Discussion (Misc queries) | |||
Excel File Huge with no data | Excel Discussion (Misc queries) | |||
How to Reduce the Excel File Size? & Make it work with huge data | Excel Discussion (Misc queries) | |||
huge huge excel file... why? | Excel Discussion (Misc queries) | |||
Huge Memory Leaks using ODBC Drivers from Excel to retrieve data | Excel Programming |