Overclock.net › Forums › Software, Programming and Coding › Other Software › Requesting help organizing data in Excel
New Posts  All Forums:Forum Nav:

Requesting help organizing data in Excel

post #1 of 3
Thread Starter 
So I made me a fancy list in Excel consisting of 80+ fans from various manufacturers that target industry vs commercial sales (Adda, Delta, EBM Papst, Globe, Nidec Servo, Panaflo, Sanyo Denki). Data categories include fan manufacturer, model, size, speed in RPM, airflow in CFM, sound pressure in dBA, and static pressure in InH2O.

The problem: it's a fairly long list and I'd like to arrange it by rank based on what I'm looking for at the moment. If I want to look at quietest fans, I'd like to have the data displayed from the dBA category, lowest to highest. If I'm looking at highest static pressure, it would list fans according to listed static pressure, highest to lowest.

Is this possible with Excel? If so, how? If not, what program should I look at that would help with this?
    
CPUMotherboardGraphicsGraphics
i7 2600k Asus ROG Maximus V Gene Reference EVGA GTX 680 (1306 / 7204) Reference EVGA GTX 680 SC (1280 / 7160) 
RAMHard DriveCoolingOS
16GB Samsung 'Green' 1600 DDR3 (MV-3V4G3D/US) Samsung 830 256GB Noctua U12P SE2 w/ AP14s P-P Windows 7 Pro 
MonitorKeyboardPowerCase
Hannspree 23" SL231 LED Logitech G710+ Seasonic SS-860XP2 Platinum Cardboard box & motherboard tray 
MouseMouse PadAudioAudio
Dying Razer Death Adder Desktop Schiit Magni + Optical Modi Swan M50W 
AudioAudio
Sennheiser HD 600 Samson Meteor Mic w/ pop filter 
  hide details  
Reply
    
CPUMotherboardGraphicsGraphics
i7 2600k Asus ROG Maximus V Gene Reference EVGA GTX 680 (1306 / 7204) Reference EVGA GTX 680 SC (1280 / 7160) 
RAMHard DriveCoolingOS
16GB Samsung 'Green' 1600 DDR3 (MV-3V4G3D/US) Samsung 830 256GB Noctua U12P SE2 w/ AP14s P-P Windows 7 Pro 
MonitorKeyboardPowerCase
Hannspree 23" SL231 LED Logitech G710+ Seasonic SS-860XP2 Platinum Cardboard box & motherboard tray 
MouseMouse PadAudioAudio
Dying Razer Death Adder Desktop Schiit Magni + Optical Modi Swan M50W 
AudioAudio
Sennheiser HD 600 Samson Meteor Mic w/ pop filter 
  hide details  
Reply
post #2 of 3
Just apply a numerical sort per any given column.

IE: Lowest dBA column and sort lowest to highest and vice versa.

Sorting in Excel
ShoopDaWoop
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel i7 920 ASUS P6T6 WS Revolution eVGA GTX 280 Corsair Dominator 6x2GB DDR3 
Hard DriveOptical DriveOSMonitor
150GB Velociraptor LG 22x DVD +-R/RW SATA Windows 7 Ultimate x64 2x SAMSUNG 206BW 
KeyboardPowerCaseMouse
Logitech G15 Gaming Keyboard Corsair 1 kW Cosmos 1000 Logitech G5 
  hide details  
Reply
ShoopDaWoop
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel i7 920 ASUS P6T6 WS Revolution eVGA GTX 280 Corsair Dominator 6x2GB DDR3 
Hard DriveOptical DriveOSMonitor
150GB Velociraptor LG 22x DVD +-R/RW SATA Windows 7 Ultimate x64 2x SAMSUNG 206BW 
KeyboardPowerCaseMouse
Logitech G15 Gaming Keyboard Corsair 1 kW Cosmos 1000 Logitech G5 
  hide details  
Reply
post #3 of 3
You can sort in Excel fairly easily. The steps depend on which version you are using. I'm pretty sure Office 07 and 10 are about the same so I'll explain for that.

Highlight your data set, including the header row.
In the home tab, on the far right is sort&filter.
Click the little down arrow in the corner of sort&filter and choose custom sort
Make sure the box for My data has headers is checked
Pull down the "Sort by" box and select the column header name you want to sort by
Choose the order to sort by, like smallest to largest and say OK.
You can "Add level" to sort multiple ways: ie, by dBA first largest to smallest and then by CFM or any combination you want.

IIRC, the only difference between 07/10 and say Office 2003 is that the sort command is found within Data or some othe rmenu.

Hope that helps.
dennis
Alpha v.2
(13 items)
 
  
CPUMotherboardGraphicsRAM
Phenom II 740be @ 3.63 (16.5 x 220) ASUS M3A78-CM XFX HD4850 Crucial 2x2GM DDR2-800 6-6-6-18 
Hard DriveOptical DriveOSMonitor
WD Black 500GB OS/Programs, WD 1Tb + 800 GB data Sony DVD-RW Win 7x64 Professional Dell 22" 
PowerCase
Antec Earthwatts 650 Antec 300 w/5 fans 
  hide details  
Reply
Alpha v.2
(13 items)
 
  
CPUMotherboardGraphicsRAM
Phenom II 740be @ 3.63 (16.5 x 220) ASUS M3A78-CM XFX HD4850 Crucial 2x2GM DDR2-800 6-6-6-18 
Hard DriveOptical DriveOSMonitor
WD Black 500GB OS/Programs, WD 1Tb + 800 GB data Sony DVD-RW Win 7x64 Professional Dell 22" 
PowerCase
Antec Earthwatts 650 Antec 300 w/5 fans 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Other Software
Overclock.net › Forums › Software, Programming and Coding › Other Software › Requesting help organizing data in Excel