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 2

post #11 of 120
Thread Starter 
I'm not sure what I'm asking either; I hope to get some time tomorrow to start messing around with formula, and get the stupid stuff out of my system. I'll be back then with more concise info on what I want/need.
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 #12 of 120
Thread Starter 
Ok, so I got somewhere. I put a message in the spreadsheet in post #2 to explain where I am.

I'm gonna take a break before the TC stats come in, but I'll be back in ~30mins.
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 #13 of 120
from the info you've posted so far, I'm not sure you can do what you want with formulae alone. In Excel I'd do it with a combination of INDEX(MATCH()) to find the rows and a little macro to find a blank row - but I don't know if you can use macros under Google...
post #14 of 120
Thread Starter 
There's an option to add scrips; I imagine that would be enough?

Anyway, the issue now should be clear from looking at the two spreadsheets above. There are loads of entries on the Master sheet, but only 2 of which would go in the "AMD GPU" sheet. I need to have no gaps between them on that page.
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 #15 of 120
In your 2nd spreadsheet, how do you calculate 3,400 under 234pt?

Also, how do you plan to update different those sheet? Do you compile everything in your local PC via Excel and upload it to Google?

This is what I can work out with Excel: http://bit.ly/kKKutv

You can download the original XLS file here: http://bit.ly/kfpJet

I have merged some redundant columns because they are essentially the same (e.g. PPD, Drivers, Credit). IMO, the table is more efficient now. So whenever you need to update those 4 worksheet (AMD GPU, nVidia GPU, Intel CPU, and AMD CPU), you need to do the filtering trick in Excel. Use "Data > Filter > Advanced Filter". The information in master worksheet has got a range name called "Master". For example, you want to update the AMD CPU worksheet, so go to this worksheet and place your cursor on cell A5. Then access "Data > Filter > Advanced Filter". Select these options:
- Filter the list, in-place
- List range: Master
- Criteria Range: $A$1:$A$2

Hit OK and you will get the same result as I have in the worksheet.

Once it's done, you can upload it to Google Docs and show it on the forum.
Edited by amang - 6/16/11 at 8:18pm
Sephiroth II
(14 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i7-7700K Kaby Lake 5.1GHz ASUS ROG Strix Z270G Gaming Nvidia GTX Titan X Pascal Corsair Dominator Platinum 16GB 
Hard DriveCoolingOSMonitor
960 PRO NVMe M.2 SSD (512GB) NZXT Kraken X31 Windows 10 Enterprise Sony X800D 49" 
MonitorKeyboardPowerCase
Acer Predator X34 34" Corsair Vengeance K70 Corsair AX1200 Corsair Carbide Air 240 White 
MouseOther
Corsair Vengeance M65 AudioEngine A5+ Black Speakers 
  hide details  
Reply
Sephiroth II
(14 items)
 
  
CPUMotherboardGraphicsRAM
Intel Core i7-7700K Kaby Lake 5.1GHz ASUS ROG Strix Z270G Gaming Nvidia GTX Titan X Pascal Corsair Dominator Platinum 16GB 
Hard DriveCoolingOSMonitor
960 PRO NVMe M.2 SSD (512GB) NZXT Kraken X31 Windows 10 Enterprise Sony X800D 49" 
MonitorKeyboardPowerCase
Acer Predator X34 34" Corsair Vengeance K70 Corsair AX1200 Corsair Carbide Air 240 White 
MouseOther
Corsair Vengeance M65 AudioEngine A5+ Black Speakers 
  hide details  
Reply
post #16 of 120
Quote:
Originally Posted by amang View Post
In your 2nd spreadsheet, how do you calculate 3,400 under 234pt?

Also, how do you plan to update different those sheet? Do you compile everything in your local PC via Excel and upload it to Google?
I do not think Z calculated it. You would need the Time per frame to do that. Z what formula are you using to pull the info down from the main spread sheet. You can always hide the blank rows.
Toy
(13 items)
 
  
CPUMotherboardGraphicsRAM
I7 980X 4.4Ghz P6T SE ASUS ENGTX 460 Super Talent DDR3 2000 
Hard DriveOSPowerCase
2-64GB SSD-0 Raid 4-Seagate 500GB (2TB) 0-Raid Ubuntu 10.10 CoolMax 1200W Thermaltake Kandalf LCS 
  hide details  
Reply
Toy
(13 items)
 
  
CPUMotherboardGraphicsRAM
I7 980X 4.4Ghz P6T SE ASUS ENGTX 460 Super Talent DDR3 2000 
Hard DriveOSPowerCase
2-64GB SSD-0 Raid 4-Seagate 500GB (2TB) 0-Raid Ubuntu 10.10 CoolMax 1200W Thermaltake Kandalf LCS 
  hide details  
Reply
post #17 of 120
Thread Starter 
Quote:
Originally Posted by amang View Post
In your 2nd spreadsheet, how do you calculate 3,400 under 234pt?
No calculating; just random values for now.

Quote:
Originally Posted by amang View Post
Also, how do you plan to update different those sheet? Do you compile everything in your local PC via Excel and upload it to Google?
I'm not sure what you mean. However, there is nothing on my PC; everything is done on GDocs. The form is used by a member, and their info is put onto the master sheet. The formulas in the other 4 sheets should (ideally) pull the relevant info.

Quote:
Originally Posted by amang View Post
This is what I can work out with Excel: http://bit.ly/kKKutv

You can download the original XLS file here: http://bit.ly/kfpJet
I don't see any formulae in either; I assume that's because it's all sorted in Excel.

Thing is, I'm gonna be doing this all in GDocs; I'd like it as automated as possible. Aside from the fact that it's adding rows in sheets with no info, it's working exactly as I want it to. That's the only obstacle left.

Quote:
Originally Posted by amang View Post
I have merged some redundant columns because they are essentially the same (e.g. PPD, Drivers, Credit). IMO, the table is more efficient now
Well, the reason they are all separate is due to the way the form works; to get separate info (since there are slight differences between info for an AMD GPU compared to an nVidia GPU, for example), I need to have separate pages on the forms. Which then puts it into a different column. It's partly why I've colour-coded them.

If necessary, I could always make a combined PPD column, and pull the value from the only PPD cell with info (since in each row only one would ever have info), but I don't think that's a major issue. In addition, the Master Sheet won't really be viewed all that much, so I don't mind it being too inefficient.

Quote:
Originally Posted by amang View Post
So whenever you need to update those 4 worksheet (AMD GPU, nVidia GPU, Intel CPU, and AMD CPU), you need to do the filtering trick in Excel. Use "Data > Filter > Advanced Filter". The information in master worksheet has got a range name called "Master". For example, you want to update the AMD CPU worksheet, so go to this worksheet and place your cursor on cell A5.
Like I said, this will be done entirely on GDocs; I dunno if it has a similar feature to what Excel has.

Quote:
Originally Posted by Grandpa_01 View Post
You can always hide the blank rows.
What I'm hoping to do is be able to drag the formula down along, say, 20 rows. As the info is added, they would automatically update to the relevant sheet without my intervention.

Hiding rows would mean I'd need to be there to do that. While I haven't got a problem doing that necessarily, I'd like to try some more to automate it, if possible. I don't believe it's impossible, and won't until someone tells me it is.
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 #18 of 120
Thread Starter 
So, good news, bad news, and then news which is probably more bad then good, but wouldn't be so bad as to be fully classified as bad.

Good: I (and by I, I mean matroska) have managed to filter out the entries in the AMD GPU sheet, to only show the rows with info.

Bad: It doesn't look as though it publishes the filter though... will have to see if that's an additional option, or if we need to go back to the drawing board.

Unclassified: At the moment, the formula works with rows, rather than a range. Because of the way a the form works, when a new entry is added, all current formulae work around that row.

So let's say I have the formula running from row 1-15, and there are only 10 rows of info right now. If I add a new entry in row 11, the formulae will work from 1-10, then 12-16, so need to see if there's a way around that too...

But, making progress.
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 #19 of 120
Thread Starter 
Ignore the rubbish in the last post; I got it working!








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 #20 of 120
You did?
YAY!!
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
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. :)