So -- long story, long -- I'm in the Army and I'm using Division Level data sources to try and create a totally "drag-and-drop data--and calculations are made" sort of Excel, for the less savvy users and I'm a little stumped. I'm new to Pivot tables and I've seen what they can do first hand, and have manipulated a file already existing, but it isn't user friendly. I'm decent with Excel and can follow tutorials for IF statements and VLOOKUPs and figuring out the meat and potatoes of what values I need to generate what I desire.
However this is so much data that when I try to manage this file, on this POS Gov PC, its little processors whirl and I'm surprised it doesn't start smoking and choking...
/////
Concept:
I'm trying to manage an enormous data file in Excel (currently 12 MB), to generate a Usage (mileage/hours) report, that will work from multiple data sources (can be tabbed, but may be slower) to generate specific number values.
I'm currently using:
but the file is so big, that the screen goes white and just contemplates life for 10+ minutes. I started something yesterday and just left work and when I came back, it was jacked up and not what I wanted.Please Login or Register to view this content.
Dilemma:
- [REQ. LIN List] - USARC has a list of Equipment that Requires Usage monthly. [Data Name: LIN] So I have a list of about 900 LINs that require Usage.
- [EQUIP SIT] - I pull a data list from SAP, that defines ALL equipment within a specific Command Level (Division). [Data Array: 109,440 lines] This list has LINs.
- I would like to bounce the REQ. LIN list off the EQUIP SIT, to produce a list of Equipment Numbers (found in the Equip Sit data) that are ON the REQ. LIN list.
- These chosen Equip Numbers will then be put into the Usage Report to generate the Usage for specifically required equipment, and export a report.
Bookmarks