Overclock.net › Forums › Overclockers Care › Overclock.net Folding@Home Team › Spreadsheet help needed - Testers needed. :)
New Posts  All Forums:Forum Nav:

Spreadsheet help needed - Testers needed. :) - Page 7

post #61 of 120
Not sure what to suggest I'm afraid.

=INDEX(E3:H3,MATCH(A1,A33,0)) works in Excel (just tried it), but it doesn't work in GoogleDocs.

Maybe tomorrow I'll have a look at it again if you don't figure it out. I have to be up to go to work in 4 1/2 hrs...

edit: dammit stupid forum put a smilie in my formula! I like it though - I'm gonna leave it (it's a colon and a capital D in case anyone can't work it out)
post #62 of 120
Thread Starter 
Damn you GDocs! You win this round!
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
post #63 of 120
No! the_beast wins this round!

=INDEX(E3:H3,,MATCH(A1,A33,0))

Looks like you need the extra comma in GDocs that Excel is smart enough to realise is pointless.

Boom! Knockout!


(can you tell that I've had 4hrs of sleep and worked 38 out of the last 48 hours, and have a full day ahead of me still?)
post #64 of 120
Thread Starter 
On days like that, you've gotta take your victories where you can get them. I'll go try this out.
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
post #65 of 120
Thread Starter 
Ok, so I'm starting this up again (at last)... 100 days after my last edit. I do need some help though, as always. Here's where I am, and what I'm trying to do:

Issue:
It is possible that one Folder might enter data for just 2 WUs, while another will enter data for 10. I need a way for all 10 possible WUs to be listed in 10 cells.

What I've done:
I've made 10 entries into the spreadsheet; 1 with 1 WU, 1 with 2 WUs, all the way up to 1 with 10 WUs. The WUs are names 1.1, 2.1, 2.2, 3.1, 3.2, 3.3, 4.1, etc. (You can see this in the second half of the "Intel CPUs" sheet.)

What I'd like to do:
I'd like to simplify those 55 cells down into just 10; WU 1-10. (You can see this just after the "Username" column of the "Intel CPUs" sheet.)

My problem:
A working formula would show 1.1 for "WU 1" for the first entry, and blank for "WU 2-10". Then 2.1 for "WU 1" and 2.2 for "WU 2" for the second entry, etc.

I can't get that working; my =IF loops are messed up, and I'm too confused to fix them up. If someone is willing to take a look at it and try it out, let me know, and I can make a copy available.

Please and thank you.
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
post #66 of 120
i will have a hell of a day at work today, but if i manage to have some time i'll look into it
I need upgrades
(21 items)
 
  
CPUMotherboardGraphicsRAM
Phenom II X6 1090T Foxconn A79A-S PNY GTS450 XLR8 KVR800D2N6/2G 
Hard DriveHard DriveHard DriveHard Drive
WD2500AAKS WD3200AAKS WD10EARS WD3200JB 
Optical DriveOptical DriveCoolingOS
Asus DRW-1608P2 Asus DRW-1608P2 Corsair H70 Ubuntu Server 10.10 x64 
OSMonitorKeyboardPower
Windows 7 Professional x64 SP1 ASUS VW193S Logitech EX100 LC-Power 650W 
CaseMouseAudioAudio
Coolermaster Stacker 830 SE Logitech EX100 Creative Audigy 2 ZS Creative i-Trigue L3450 
  hide details  
Reply
I need upgrades
(21 items)
 
  
CPUMotherboardGraphicsRAM
Phenom II X6 1090T Foxconn A79A-S PNY GTS450 XLR8 KVR800D2N6/2G 
Hard DriveHard DriveHard DriveHard Drive
WD2500AAKS WD3200AAKS WD10EARS WD3200JB 
Optical DriveOptical DriveCoolingOS
Asus DRW-1608P2 Asus DRW-1608P2 Corsair H70 Ubuntu Server 10.10 x64 
OSMonitorKeyboardPower
Windows 7 Professional x64 SP1 ASUS VW193S Logitech EX100 LC-Power 650W 
CaseMouseAudioAudio
Coolermaster Stacker 830 SE Logitech EX100 Creative Audigy 2 ZS Creative i-Trigue L3450 
  hide details  
Reply
post #67 of 120
Thread Starter 
Cheers.
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
post #68 of 120
GDocs is blocked at work =( but if help is still needed when I get home late tonight I'll see what I can do.
Red Death
(17 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom II X4 970 790FX-GD70 HIS IceQ Turbo Radeon HD 6970 Crucial Ballistix Tracer Red LEDs 
RAMHard DriveHard DriveOptical Drive
Crucial Ballistix Tracer Red LEDs OCZ Vertex 2 Samsung HDD 7200 ASUS DVD RW 
CoolingCoolingOSMonitor
Zalman Flex Rosewill 120 mm Red LED Fans 2000 rpm Windows 7 Home Premium 64-bit HP 25" 1920 x 1080 
KeyboardPowerCaseMouse
Microsoft Sidewinder X4 Antec CP-850 Antec DF-85 Logitech MX518 
  hide details  
Reply
Red Death
(17 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom II X4 970 790FX-GD70 HIS IceQ Turbo Radeon HD 6970 Crucial Ballistix Tracer Red LEDs 
RAMHard DriveHard DriveOptical Drive
Crucial Ballistix Tracer Red LEDs OCZ Vertex 2 Samsung HDD 7200 ASUS DVD RW 
CoolingCoolingOSMonitor
Zalman Flex Rosewill 120 mm Red LED Fans 2000 rpm Windows 7 Home Premium 64-bit HP 25" 1920 x 1080 
KeyboardPowerCaseMouse
Microsoft Sidewinder X4 Antec CP-850 Antec DF-85 Logitech MX518 
  hide details  
Reply
post #69 of 120
If you make a copy available to me I have some time to futz with it.
Red Death
(17 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom II X4 970 790FX-GD70 HIS IceQ Turbo Radeon HD 6970 Crucial Ballistix Tracer Red LEDs 
RAMHard DriveHard DriveOptical Drive
Crucial Ballistix Tracer Red LEDs OCZ Vertex 2 Samsung HDD 7200 ASUS DVD RW 
CoolingCoolingOSMonitor
Zalman Flex Rosewill 120 mm Red LED Fans 2000 rpm Windows 7 Home Premium 64-bit HP 25" 1920 x 1080 
KeyboardPowerCaseMouse
Microsoft Sidewinder X4 Antec CP-850 Antec DF-85 Logitech MX518 
  hide details  
Reply
Red Death
(17 items)
 
  
CPUMotherboardGraphicsRAM
AMD Phenom II X4 970 790FX-GD70 HIS IceQ Turbo Radeon HD 6970 Crucial Ballistix Tracer Red LEDs 
RAMHard DriveHard DriveOptical Drive
Crucial Ballistix Tracer Red LEDs OCZ Vertex 2 Samsung HDD 7200 ASUS DVD RW 
CoolingCoolingOSMonitor
Zalman Flex Rosewill 120 mm Red LED Fans 2000 rpm Windows 7 Home Premium 64-bit HP 25" 1920 x 1080 
KeyboardPowerCaseMouse
Microsoft Sidewinder X4 Antec CP-850 Antec DF-85 Logitech MX518 
  hide details  
Reply
post #70 of 120
Thread Starter 
Gimme a PM, and I'll send you a link.
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
Megadoomer
(14 items)
 
Family Computer
(13 items)
 
 
CPUMotherboardGraphicsRAM
Phenom II X6 1090T @ 4.0Ghz ASUS M4A89GTD PRO Sparkle GTS 450 2x4GB G-Skill Sniper 
Hard DriveCoolingOSMonitor
Samsung F1 1TB CM Hyper 212+ Windows 7 Professional x64 Samsung T220 
KeyboardPowerCaseMouse
Logitech MX3000 Laser CM 1000M HAF 922 Logitech VX Revolution 
CPUMotherboardGraphicsRAM
Q6600 Asus PN5-D 750i Evga GTS 250 2x2GB Crucial Ballistix 
Hard DriveOptical DriveOSMonitor
750GB Hitachi Samsung Super Writemaster Windows 7 Professional x64 19" Dell 
PowerCase
Corsair 450VX Antec 900 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Overclock.net Folding@Home Team
Overclock.net › Forums › Overclockers Care › Overclock.net Folding@Home Team › Spreadsheet help needed - Testers needed. :)