Overclock.net › Forums › Components › Keyboards › [Official] Mechanical Keyboard Club - Because saving money is boring.
New Posts  All Forums:Forum Nav:

[Official] Mechanical Keyboard Club - Because saving money is boring. - Page 254

post #2531 of 36843
Just wondering if it would be ok to add "stats" to the sheet? Or maybe someone more official can add it?

I copied and added an example <Stats>:
This is not the official sheet updated clearer version

Used formulas:
- 1x "=sort(unique('Members List'!B2:B))" in A-column. Lists unique hits from the list and sorts it in default(alphabetic) order.
- "=if(A2="",,countif('Members List'!B$2:B,A2))" in B-column -> + drag it to bottom. Counts how many times this keyboard name is written. If the cell is empty, it does nothing.
- Choose the whole B-column and right click -> Conditional formatting, and put different background colors with "greater than x number", higher numbers first.

It would give a nice clue on how many people are using specific keyboards. It also shows all the typos(extra space bar, big/small letters) and some problems with multiple keyboards for single person. Maybe could add more lines for the person with multiple keyboards to fix this.

Fully automatic, unless it adds more rows(more unique keyboard names) to the sheet, then you just need to +drag the formulas on B-column to the bottom again. Have extra 50-100 empty rows to counter this. If there's "--"(just eye annoyance) stuff, ctrl+R gets rid of them.
Edited by fasti - 5/13/11 at 7:55am
Durable
(18 items)
 
  
CPUMotherboardGraphicsRAM
i7-4930k 4.4Ghz Asus Rampage IV Formula ASUS DCII 680 GTX 16GB 
Hard DriveHard DriveHard DriveCooling
2x Intel 320 SSD 120GB Western Digital 1TB Caviar Blue 2x Western Digital 2TB Red in Raid0 Noctua NH-U14 
MonitorMonitorMonitorKeyboard
Benq XL2420T Dell U2412M LG Flatron wide L226W Steelseries 6Gv2 
PowerCaseMouseMouse Pad
Antec Truepower New 750W Cooling Master Test Bench Steelseries Kinzu V2 pro SteelSeries S&S 
AudioAudio
Koss PortaPro ModMic 
  hide details  
Reply
Durable
(18 items)
 
  
CPUMotherboardGraphicsRAM
i7-4930k 4.4Ghz Asus Rampage IV Formula ASUS DCII 680 GTX 16GB 
Hard DriveHard DriveHard DriveCooling
2x Intel 320 SSD 120GB Western Digital 1TB Caviar Blue 2x Western Digital 2TB Red in Raid0 Noctua NH-U14 
MonitorMonitorMonitorKeyboard
Benq XL2420T Dell U2412M LG Flatron wide L226W Steelseries 6Gv2 
PowerCaseMouseMouse Pad
Antec Truepower New 750W Cooling Master Test Bench Steelseries Kinzu V2 pro SteelSeries S&S 
AudioAudio
Koss PortaPro ModMic 
  hide details  
Reply
post #2532 of 36843
Ok, fixed version would look something like this:
This is not the official sheet

Think there's still some errors on naming, but clearer picture now. Added manufacturer count too.
Edited by fasti - 5/13/11 at 7:58am
Durable
(18 items)
 
  
CPUMotherboardGraphicsRAM
i7-4930k 4.4Ghz Asus Rampage IV Formula ASUS DCII 680 GTX 16GB 
Hard DriveHard DriveHard DriveCooling
2x Intel 320 SSD 120GB Western Digital 1TB Caviar Blue 2x Western Digital 2TB Red in Raid0 Noctua NH-U14 
MonitorMonitorMonitorKeyboard
Benq XL2420T Dell U2412M LG Flatron wide L226W Steelseries 6Gv2 
PowerCaseMouseMouse Pad
Antec Truepower New 750W Cooling Master Test Bench Steelseries Kinzu V2 pro SteelSeries S&S 
AudioAudio
Koss PortaPro ModMic 
  hide details  
Reply
Durable
(18 items)
 
  
CPUMotherboardGraphicsRAM
i7-4930k 4.4Ghz Asus Rampage IV Formula ASUS DCII 680 GTX 16GB 
Hard DriveHard DriveHard DriveCooling
2x Intel 320 SSD 120GB Western Digital 1TB Caviar Blue 2x Western Digital 2TB Red in Raid0 Noctua NH-U14 
MonitorMonitorMonitorKeyboard
Benq XL2420T Dell U2412M LG Flatron wide L226W Steelseries 6Gv2 
PowerCaseMouseMouse Pad
Antec Truepower New 750W Cooling Master Test Bench Steelseries Kinzu V2 pro SteelSeries S&S 
AudioAudio
Koss PortaPro ModMic 
  hide details  
Reply
post #2533 of 36843
^ You're missing a division between majestouch and majestouch 2
Herp
(1 item)
 
  
Other
Dolla Billz Yall! 
  hide details  
Reply
Herp
(1 item)
 
  
Other
Dolla Billz Yall! 
  hide details  
Reply
post #2534 of 36843

It's here and oh so beautiful.

Filco Majestouch 2 Tenkeyless Tactile
Herp
(1 item)
 
  
Other
Dolla Billz Yall! 
  hide details  
Reply
Herp
(1 item)
 
  
Other
Dolla Billz Yall! 
  hide details  
Reply
post #2535 of 36843
Hello again. 'Tis my birthday tomorrow. Any good recommendations for the ~$100 budget? Blank keycaps are a must for this one. Tenkey is not.
post #2536 of 36843
For $100
http://elitekeyboards.com/products.p...pid=fc200rtabn
109+shipping
and a good brand at that
Edited by Scrappy - 5/13/11 at 4:46pm
Herp
(1 item)
 
  
Other
Dolla Billz Yall! 
  hide details  
Reply
Herp
(1 item)
 
  
Other
Dolla Billz Yall! 
  hide details  
Reply
post #2537 of 36843
Sexy. Any more recommendations?
post #2538 of 36843
Quote:
Originally Posted by Scrappy View Post
It's here and oh so beautiful.
Filco Majestouch 2 Tenkeyless Tactile
Added.

Quote:
Originally Posted by Bassdoken View Post
Sexy. Any more recommendations?
For that price you can't really beat Leopold Scrappy posted plus it already comes with blank key caps ("Otaku" version). I mean I could recommend a few more but either it's more than your budget and/or doesn't come with blank key caps which means you'd have to pay extra (now way over your budget).
reaper's Scythe
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i7 3770k Intel DZ77GA-70K 2 x EVGA GTX 570 SLI Corsair Vengeance 16GB DDR3 
Hard DriveOptical DriveOSMonitor
Intel X25-M G2 160GB, WD 3TB Samsung SH-S223Q Windows 8 Professional Asus VH236HL-P 23" 
KeyboardPowerCaseMouse
KMAC 2 Corsair HX1000W Corsair Obsidian 800D CM Spawn 
Mouse Pad
XTRAC Pads Logic 
  hide details  
Reply
reaper's Scythe
(13 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i7 3770k Intel DZ77GA-70K 2 x EVGA GTX 570 SLI Corsair Vengeance 16GB DDR3 
Hard DriveOptical DriveOSMonitor
Intel X25-M G2 160GB, WD 3TB Samsung SH-S223Q Windows 8 Professional Asus VH236HL-P 23" 
KeyboardPowerCaseMouse
KMAC 2 Corsair HX1000W Corsair Obsidian 800D CM Spawn 
Mouse Pad
XTRAC Pads Logic 
  hide details  
Reply
post #2539 of 36843
Also no one warned me that autohotkey was a programming language. I was really hoping for a nice simple UI
Herp
(1 item)
 
  
Other
Dolla Billz Yall! 
  hide details  
Reply
Herp
(1 item)
 
  
Other
Dolla Billz Yall! 
  hide details  
Reply
post #2540 of 36843
Das keyboards can get down around that price if you can get the student discount, which I believe is 25 percent off, unless they moved it down to 20.
SUPERPWN
(12 items)
 
  
CPUMotherboardGraphicsRAM
Core i5 4670K Asus z87-Pro MSI GTX 1080 Aero 32GB DDR3 Gskill Ripjaws 
Hard DriveOSMonitorMonitor
4TB Seagate Windows 8 x64 Overlord x270 OC HP ZR27 
MonitorKeyboardPowerAudio
Asus PG279Q G-Tune Topre Realforce 800w Yulong D100 DAC with Denon D7000 headphones 
  hide details  
Reply
SUPERPWN
(12 items)
 
  
CPUMotherboardGraphicsRAM
Core i5 4670K Asus z87-Pro MSI GTX 1080 Aero 32GB DDR3 Gskill Ripjaws 
Hard DriveOSMonitorMonitor
4TB Seagate Windows 8 x64 Overlord x270 OC HP ZR27 
MonitorKeyboardPowerAudio
Asus PG279Q G-Tune Topre Realforce 800w Yulong D100 DAC with Denon D7000 headphones 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Keyboards
Overclock.net › Forums › Components › Keyboards › [Official] Mechanical Keyboard Club - Because saving money is boring.