Overclock.net › Forums › Software, Programming and Coding › Other Software › Can anyone lend a hand with a Google Spreadsheet?
New Posts  All Forums:Forum Nav:

Can anyone lend a hand with a Google Spreadsheet?

post #1 of 7
Thread Starter 
I have this spreadsheet that I'm in the progress of making, but I can't for the life of me figure out how to add sort-able headers. I want to allow people to click a column and have it sort from ascending/descending order, is this possible?

Here is an editable version

Thanks
Edited by gene-z - 12/10/12 at 8:44pm
    
CPUMotherboardGraphicsRAM
i5 2500k, 4.2ghz @ stock voltage asus gene-z evga 1060 sc gskill 2x4gb ddr3 1866mhz 
Hard DriveOSMonitorKeyboard
samsung ssd 830 256gb w10 pro x64 dell s2417dg g-sync @ 165hz pok3r mx silent 
MouseMouse PadAudioOther
zowie fk1 @ 400 dpi, 1000hz zowie ps-r, zowie camade fulla 2 dac, akg k7xx sony a5000, 20.1mp 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
i5 2500k, 4.2ghz @ stock voltage asus gene-z evga 1060 sc gskill 2x4gb ddr3 1866mhz 
Hard DriveOSMonitorKeyboard
samsung ssd 830 256gb w10 pro x64 dell s2417dg g-sync @ 165hz pok3r mx silent 
MouseMouse PadAudioOther
zowie fk1 @ 400 dpi, 1000hz zowie ps-r, zowie camade fulla 2 dac, akg k7xx sony a5000, 20.1mp 
  hide details  
Reply
post #2 of 7
select the cells (all of them that have content) and click the little wine glass looking think at the top right of the edit bar.

I did it on that editable version smile.gif.

After that, the little drop down arrow on the title of the colums will let you sort ascending or decending.
AMD Transplant
(11 items)
 
To be a NAS
(13 items)
 
Death Kühler
(14 items)
 
CPUMotherboardGraphicsRAM
965BE GA-78LMT-S2P MSI TFIII 7950 Corsair Vengence 
Hard DriveCoolingOSMonitor
Samsung 830 Noctua NH-D14 Win7 Pro FX2490HD 
PowerCaseMouse
Seasonic X660 Antec Three Hundred Saitek Rat 7 
CPUMotherboardGraphicsRAM
AMD Athlon 64 X2 4200+ Gateway GM5072 AMD HD5550 2.0 Gb 
Hard DriveMonitorKeyboardPower
Seagate Barracuda 500Gb Samsung FX2490 MS Keyboard 3000 300w generic 
Mouse
MS Intellipoint 3000 
CPUMotherboardGraphicsRAM
2500k GigaByte Z68M-D2H-B3 MSI 560 Ti TFIII Corsair Vengance 
Hard DriveCoolingOSMonitor
Samsung 830 Antec Khuler 920 Win7 HP Samsung FX2490 
KeyboardPowerCaseMouse
Microsoft Keyboard 3000 Seasonic X-660 Antec Three Hundred Microsoft Mouse 3000 
Mouse PadAudio
None - Blue Track baby Senn HD428 
  hide details  
Reply
AMD Transplant
(11 items)
 
To be a NAS
(13 items)
 
Death Kühler
(14 items)
 
CPUMotherboardGraphicsRAM
965BE GA-78LMT-S2P MSI TFIII 7950 Corsair Vengence 
Hard DriveCoolingOSMonitor
Samsung 830 Noctua NH-D14 Win7 Pro FX2490HD 
PowerCaseMouse
Seasonic X660 Antec Three Hundred Saitek Rat 7 
CPUMotherboardGraphicsRAM
AMD Athlon 64 X2 4200+ Gateway GM5072 AMD HD5550 2.0 Gb 
Hard DriveMonitorKeyboardPower
Seagate Barracuda 500Gb Samsung FX2490 MS Keyboard 3000 300w generic 
Mouse
MS Intellipoint 3000 
CPUMotherboardGraphicsRAM
2500k GigaByte Z68M-D2H-B3 MSI 560 Ti TFIII Corsair Vengance 
Hard DriveCoolingOSMonitor
Samsung 830 Antec Khuler 920 Win7 HP Samsung FX2490 
KeyboardPowerCaseMouse
Microsoft Keyboard 3000 Seasonic X-660 Antec Three Hundred Microsoft Mouse 3000 
Mouse PadAudio
None - Blue Track baby Senn HD428 
  hide details  
Reply
post #3 of 7
What game is this spreadsheet for? Just curious lol.
post #4 of 7
Quote:
Originally Posted by gene-z View Post

I have this spreadsheet that I'm in the progress of making, but I can't for the life of me figure out how to add sort-able headers. I want to allow people to click a column and have it sort from ascending/descending order, is this possible?
Here is an editable version
Thanks

Just wanting to let you know I'm taking the time to make things a bit neater and to adjust things.
Making it easier to read etc.

Just wanted to lend a helping hand.

ENJOY!

(still working on it)

Will edit when finished.
Oh So Frosty
(12 items)
 
  
CPUMotherboardGraphicsRAM
i5-2500k @ 5.07GHz Asus P8P67-Pro [1850] 2x Asus HD 6950 DCII 1012/1487 @1.168V Crossfire 4 x 4gb Corsair Vengeance 1600MHz 
Hard DriveHard DriveOSKeyboard
HDD: 7200rpm WD Black 1TB SSD Samsung 840 EVO 250 GB Windows 7 64bit Ultimate Razer Blackwidow Ultimate Chroma 
PowerCaseMouseMouse Pad
Corsair HX750 [Modular] CoolerMaster HAF-X |rx360 rad - vpp655/dualbay res Razer Deathadder Elite GLORIOUS XXL EXTENDED GAMING MOUSE MAT - 36X18" 
  hide details  
Reply
Oh So Frosty
(12 items)
 
  
CPUMotherboardGraphicsRAM
i5-2500k @ 5.07GHz Asus P8P67-Pro [1850] 2x Asus HD 6950 DCII 1012/1487 @1.168V Crossfire 4 x 4gb Corsair Vengeance 1600MHz 
Hard DriveHard DriveOSKeyboard
HDD: 7200rpm WD Black 1TB SSD Samsung 840 EVO 250 GB Windows 7 64bit Ultimate Razer Blackwidow Ultimate Chroma 
PowerCaseMouseMouse Pad
Corsair HX750 [Modular] CoolerMaster HAF-X |rx360 rad - vpp655/dualbay res Razer Deathadder Elite GLORIOUS XXL EXTENDED GAMING MOUSE MAT - 36X18" 
  hide details  
Reply
post #5 of 7
Quote:
Originally Posted by PlaguedSickness View Post

Just wanting to let you know I'm taking the time to make things a bit neater and to adjust things.
Making it easier to read etc.
Just wanted to lend a helping hand.
ENJOY!
(still working on it)
Will edit when finished.

Finished, Made it look pretty and easier to tell things apart, let me know if you need anything else done. I'll be glad to help.

I was the one who commented....

" Added a couple of things, some colors and such to identify certain aspects of the spreadsheet. (adding in for levels...As follows...*)

*Added

[( 1 - 5 )Light Shade of Grey]
[( x - 10 )Slightly Darker Than Previous Grey]
[( x - 15 ) " ]
[( x - 20 ) " ]

* The (") Means same as line above.

Adjusted some alignments so that they are centered in the box and so that the text is aligned according to that.

Added ghosting grid which is the dotted portion**, as well as matching the color background for the items to the side numbers on the spreadsheet, added Alternating Row Color to Location and Quick Note to make each row More distinctive from the other.

** Darkened the ghosting on the I Column to better show the shading differences

Feel free to reply to this comment or message me.

-Dave "

Though I now see an error with the comment so I'll just fix it now.
(Replaced 6, 11, and 16 with x)
Oh So Frosty
(12 items)
 
  
CPUMotherboardGraphicsRAM
i5-2500k @ 5.07GHz Asus P8P67-Pro [1850] 2x Asus HD 6950 DCII 1012/1487 @1.168V Crossfire 4 x 4gb Corsair Vengeance 1600MHz 
Hard DriveHard DriveOSKeyboard
HDD: 7200rpm WD Black 1TB SSD Samsung 840 EVO 250 GB Windows 7 64bit Ultimate Razer Blackwidow Ultimate Chroma 
PowerCaseMouseMouse Pad
Corsair HX750 [Modular] CoolerMaster HAF-X |rx360 rad - vpp655/dualbay res Razer Deathadder Elite GLORIOUS XXL EXTENDED GAMING MOUSE MAT - 36X18" 
  hide details  
Reply
Oh So Frosty
(12 items)
 
  
CPUMotherboardGraphicsRAM
i5-2500k @ 5.07GHz Asus P8P67-Pro [1850] 2x Asus HD 6950 DCII 1012/1487 @1.168V Crossfire 4 x 4gb Corsair Vengeance 1600MHz 
Hard DriveHard DriveOSKeyboard
HDD: 7200rpm WD Black 1TB SSD Samsung 840 EVO 250 GB Windows 7 64bit Ultimate Razer Blackwidow Ultimate Chroma 
PowerCaseMouseMouse Pad
Corsair HX750 [Modular] CoolerMaster HAF-X |rx360 rad - vpp655/dualbay res Razer Deathadder Elite GLORIOUS XXL EXTENDED GAMING MOUSE MAT - 36X18" 
  hide details  
Reply
post #6 of 7
Thread Starter 
Quote:
Originally Posted by FluffyGoober View Post

What game is this spreadsheet for? Just curious lol.

Castle Crashers
Quote:
Originally Posted by PlaguedSickness View Post

Finished, Made it look pretty and easier to tell things apart, let me know if you need anything else done. I'll be glad to help.
I was the one who commented....
" Added a couple of things, some colors and such to identify certain aspects of the spreadsheet. (adding in for levels...As follows...*)
*Added
[( 1 - 5 )Light Shade of Grey]
[( x - 10 )Slightly Darker Than Previous Grey]
[( x - 15 ) " ]
[( x - 20 ) " ]
* The (") Means same as line above.
Adjusted some alignments so that they are centered in the box and so that the text is aligned according to that.
Added ghosting grid which is the dotted portion**, as well as matching the color background for the items to the side numbers on the spreadsheet, added Alternating Row Color to Location and Quick Note to make each row More distinctive from the other.
** Darkened the ghosting on the I Column to better show the shading differences
Feel free to reply to this comment or message me.
-Dave "
Though I now see an error with the comment so I'll just fix it now.
(Replaced 6, 11, and 16 with x)

Wow, thanks so much! Looks very good.
    
CPUMotherboardGraphicsRAM
i5 2500k, 4.2ghz @ stock voltage asus gene-z evga 1060 sc gskill 2x4gb ddr3 1866mhz 
Hard DriveOSMonitorKeyboard
samsung ssd 830 256gb w10 pro x64 dell s2417dg g-sync @ 165hz pok3r mx silent 
MouseMouse PadAudioOther
zowie fk1 @ 400 dpi, 1000hz zowie ps-r, zowie camade fulla 2 dac, akg k7xx sony a5000, 20.1mp 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
i5 2500k, 4.2ghz @ stock voltage asus gene-z evga 1060 sc gskill 2x4gb ddr3 1866mhz 
Hard DriveOSMonitorKeyboard
samsung ssd 830 256gb w10 pro x64 dell s2417dg g-sync @ 165hz pok3r mx silent 
MouseMouse PadAudioOther
zowie fk1 @ 400 dpi, 1000hz zowie ps-r, zowie camade fulla 2 dac, akg k7xx sony a5000, 20.1mp 
  hide details  
Reply
post #7 of 7
Quote:
Originally Posted by gene-z View Post

Castle Crashers
Wow, thanks so much! Looks very good.

Anytime, I'm glad you like it! thumb.gif
Oh So Frosty
(12 items)
 
  
CPUMotherboardGraphicsRAM
i5-2500k @ 5.07GHz Asus P8P67-Pro [1850] 2x Asus HD 6950 DCII 1012/1487 @1.168V Crossfire 4 x 4gb Corsair Vengeance 1600MHz 
Hard DriveHard DriveOSKeyboard
HDD: 7200rpm WD Black 1TB SSD Samsung 840 EVO 250 GB Windows 7 64bit Ultimate Razer Blackwidow Ultimate Chroma 
PowerCaseMouseMouse Pad
Corsair HX750 [Modular] CoolerMaster HAF-X |rx360 rad - vpp655/dualbay res Razer Deathadder Elite GLORIOUS XXL EXTENDED GAMING MOUSE MAT - 36X18" 
  hide details  
Reply
Oh So Frosty
(12 items)
 
  
CPUMotherboardGraphicsRAM
i5-2500k @ 5.07GHz Asus P8P67-Pro [1850] 2x Asus HD 6950 DCII 1012/1487 @1.168V Crossfire 4 x 4gb Corsair Vengeance 1600MHz 
Hard DriveHard DriveOSKeyboard
HDD: 7200rpm WD Black 1TB SSD Samsung 840 EVO 250 GB Windows 7 64bit Ultimate Razer Blackwidow Ultimate Chroma 
PowerCaseMouseMouse Pad
Corsair HX750 [Modular] CoolerMaster HAF-X |rx360 rad - vpp655/dualbay res Razer Deathadder Elite GLORIOUS XXL EXTENDED GAMING MOUSE MAT - 36X18" 
  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 › Can anyone lend a hand with a Google Spreadsheet?