New Posts  All Forums:Forum Nav:

The Misfits - Page 283

post #2821 of 6206
It's not fun resetting things for the next month... or quick.
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 #2822 of 6206
So when do I get the pretty thing under my avatar?
post #2823 of 6206
Thread Starter 
Quote:
Originally Posted by Mikezilla View Post
So when do I get the pretty thing under my avatar?
Ah yeah...I've to pm somebody...I'll do that tomorrow.
post #2824 of 6206
Z, I'm sure you could do a simple duplication at the end of each month (for posterity) and then just revert the [original] spreadie back to how it was at the start of the month...or download a copy when it is the start of the month, and (saving a copy/duplicating the spreadie for posterity) re-uploading the 'template' each month again...

I can't say for certain, but you should be able to use a wee formula with:
Code:
=if(="","",)
That should mean that the cells can automagically update when other cells are filled in, while being blank when the reference cell doesn't have anything in it.....

I'm WFH today, so I just have to keep an eye one the [~600] e-mails, so if you want to have a review with me....................





sstnt, have you had a look at the HFM stats on SRV01 yet, or did you miss the comment [again]..?

Dropped that WU for the 21:00 EOC update, and have another 690x WU to get on with...
WKS04
(16 items)
 
WORK_PC
(13 items)
 
LAP03
(13 items)
 
CPUMotherboardGraphicsRAM
i7 920 D0 (HT on) @3.6 GHz Asus P6T nVidia 250 6 GB OCZ Gold 
Hard DriveOptical DriveCoolingOS
250 GB SATA CD DVD RW RASA RS360 Ubuntu 10.04 (W7U x64 as alternate boot) 
MonitorMonitorKeyboardPower
LG 19" (L194WS) LCD HP 15" LCD QWERTY (Logitech) High Power Plus 850W modular 
CaseMouseMouse PadAudio
Jeantech Phong2 Trackball (Logitech) n/a Hitachi AX-M5 
CPUMotherboardGraphicsRAM
Q8400 Dell Optiplex 780 GT430 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB Yes W7 Pro (x86 - with Linux x64 VM) 2 x 24" Dell 
KeyboardPowerCaseMouse
Dell Yeah, got one of those... Dell Logitech Trackball 
Mouse Pad
N/A 
CPUMotherboardGraphicsRAM
T5670 (Core2Duo) HP on-board 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB CD DVD RW W7 Ultimate (x86) 17" 
KeyboardPowerCaseMouse
QWERTY on-board Laptop touchpad 
  hide details  
Reply
WKS04
(16 items)
 
WORK_PC
(13 items)
 
LAP03
(13 items)
 
CPUMotherboardGraphicsRAM
i7 920 D0 (HT on) @3.6 GHz Asus P6T nVidia 250 6 GB OCZ Gold 
Hard DriveOptical DriveCoolingOS
250 GB SATA CD DVD RW RASA RS360 Ubuntu 10.04 (W7U x64 as alternate boot) 
MonitorMonitorKeyboardPower
LG 19" (L194WS) LCD HP 15" LCD QWERTY (Logitech) High Power Plus 850W modular 
CaseMouseMouse PadAudio
Jeantech Phong2 Trackball (Logitech) n/a Hitachi AX-M5 
CPUMotherboardGraphicsRAM
Q8400 Dell Optiplex 780 GT430 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB Yes W7 Pro (x86 - with Linux x64 VM) 2 x 24" Dell 
KeyboardPowerCaseMouse
Dell Yeah, got one of those... Dell Logitech Trackball 
Mouse Pad
N/A 
CPUMotherboardGraphicsRAM
T5670 (Core2Duo) HP on-board 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB CD DVD RW W7 Ultimate (x86) 17" 
KeyboardPowerCaseMouse
QWERTY on-board Laptop touchpad 
  hide details  
Reply
post #2825 of 6206
Not quite... I have to put in fresh offsets each month, since everyone's stats will have increased.
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 #2826 of 6206
Can't you just get the cells in the 'live' version to use the last entry (can use '=max(cell_range_for_user)' on the previous "backup" or "posterity" version...then you could just have the 'Find and replace' function replace all the spreadie reference parts of the formulae to the new version from the previous one...?

Just saying..


Anyway, I've been "busy" [mainly, if I'm honest, checking out YT for schtuffs] but I can still take a look at things if you want to give it a try...and that includes the Folding Olympics other Folding event that has been talked about....
WKS04
(16 items)
 
WORK_PC
(13 items)
 
LAP03
(13 items)
 
CPUMotherboardGraphicsRAM
i7 920 D0 (HT on) @3.6 GHz Asus P6T nVidia 250 6 GB OCZ Gold 
Hard DriveOptical DriveCoolingOS
250 GB SATA CD DVD RW RASA RS360 Ubuntu 10.04 (W7U x64 as alternate boot) 
MonitorMonitorKeyboardPower
LG 19" (L194WS) LCD HP 15" LCD QWERTY (Logitech) High Power Plus 850W modular 
CaseMouseMouse PadAudio
Jeantech Phong2 Trackball (Logitech) n/a Hitachi AX-M5 
CPUMotherboardGraphicsRAM
Q8400 Dell Optiplex 780 GT430 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB Yes W7 Pro (x86 - with Linux x64 VM) 2 x 24" Dell 
KeyboardPowerCaseMouse
Dell Yeah, got one of those... Dell Logitech Trackball 
Mouse Pad
N/A 
CPUMotherboardGraphicsRAM
T5670 (Core2Duo) HP on-board 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB CD DVD RW W7 Ultimate (x86) 17" 
KeyboardPowerCaseMouse
QWERTY on-board Laptop touchpad 
  hide details  
Reply
WKS04
(16 items)
 
WORK_PC
(13 items)
 
LAP03
(13 items)
 
CPUMotherboardGraphicsRAM
i7 920 D0 (HT on) @3.6 GHz Asus P6T nVidia 250 6 GB OCZ Gold 
Hard DriveOptical DriveCoolingOS
250 GB SATA CD DVD RW RASA RS360 Ubuntu 10.04 (W7U x64 as alternate boot) 
MonitorMonitorKeyboardPower
LG 19" (L194WS) LCD HP 15" LCD QWERTY (Logitech) High Power Plus 850W modular 
CaseMouseMouse PadAudio
Jeantech Phong2 Trackball (Logitech) n/a Hitachi AX-M5 
CPUMotherboardGraphicsRAM
Q8400 Dell Optiplex 780 GT430 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB Yes W7 Pro (x86 - with Linux x64 VM) 2 x 24" Dell 
KeyboardPowerCaseMouse
Dell Yeah, got one of those... Dell Logitech Trackball 
Mouse Pad
N/A 
CPUMotherboardGraphicsRAM
T5670 (Core2Duo) HP on-board 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB CD DVD RW W7 Ultimate (x86) 17" 
KeyboardPowerCaseMouse
QWERTY on-board Laptop touchpad 
  hide details  
Reply
post #2827 of 6206
I've sorted the Folding Olympics out; as long as no-one signs up after I post the stats sheets, it should run pretty smooth.

And no to the first part. Let me give an example. For today's update, I will have this in one of the cells:

"=-123456+0"

To update, I doubleclick the cell and then paste in the new value (123809), and then the cell updates as "353". The value I want for the new offset at the start of the month is 123809, but I don't have that in its own cell anywhere, so it needs to be added manually, as "=-123809+0" for the first of the month, then extended down for the rest of the month.
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 #2828 of 6206
Quote:
Originally Posted by zodac View Post
I've sorted the Folding Olympics out; as long as no-one signs up after I post the stats sheets, it should run pretty smooth.

And no to the first part. Let me give an example. For today's update, I will have this in one of the cells:

"=-123456+0"

To update, I doubleclick the cell and then paste in the new value (123809), and then the cell updates as "353". The value I want for the new offset at the start of the month is 123809, but I don't have that in its own cell anywhere, so it needs to be added manually, as "=-123809+0" for the first of the month, then extended down for the rest of the month.
I'm amazed...who is it that managed to have exactly 123,456 points..??


Seriously though, can't you have a cell at the top (that you could hide if you wanted to) that shows what they had at the end of the last month (which could be a simple ' =importrange("abcd123abcd123", "sheet1!B31:AC31")' type formula) and then just use the result of that to copy down..
WKS04
(16 items)
 
WORK_PC
(13 items)
 
LAP03
(13 items)
 
CPUMotherboardGraphicsRAM
i7 920 D0 (HT on) @3.6 GHz Asus P6T nVidia 250 6 GB OCZ Gold 
Hard DriveOptical DriveCoolingOS
250 GB SATA CD DVD RW RASA RS360 Ubuntu 10.04 (W7U x64 as alternate boot) 
MonitorMonitorKeyboardPower
LG 19" (L194WS) LCD HP 15" LCD QWERTY (Logitech) High Power Plus 850W modular 
CaseMouseMouse PadAudio
Jeantech Phong2 Trackball (Logitech) n/a Hitachi AX-M5 
CPUMotherboardGraphicsRAM
Q8400 Dell Optiplex 780 GT430 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB Yes W7 Pro (x86 - with Linux x64 VM) 2 x 24" Dell 
KeyboardPowerCaseMouse
Dell Yeah, got one of those... Dell Logitech Trackball 
Mouse Pad
N/A 
CPUMotherboardGraphicsRAM
T5670 (Core2Duo) HP on-board 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB CD DVD RW W7 Ultimate (x86) 17" 
KeyboardPowerCaseMouse
QWERTY on-board Laptop touchpad 
  hide details  
Reply
WKS04
(16 items)
 
WORK_PC
(13 items)
 
LAP03
(13 items)
 
CPUMotherboardGraphicsRAM
i7 920 D0 (HT on) @3.6 GHz Asus P6T nVidia 250 6 GB OCZ Gold 
Hard DriveOptical DriveCoolingOS
250 GB SATA CD DVD RW RASA RS360 Ubuntu 10.04 (W7U x64 as alternate boot) 
MonitorMonitorKeyboardPower
LG 19" (L194WS) LCD HP 15" LCD QWERTY (Logitech) High Power Plus 850W modular 
CaseMouseMouse PadAudio
Jeantech Phong2 Trackball (Logitech) n/a Hitachi AX-M5 
CPUMotherboardGraphicsRAM
Q8400 Dell Optiplex 780 GT430 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB Yes W7 Pro (x86 - with Linux x64 VM) 2 x 24" Dell 
KeyboardPowerCaseMouse
Dell Yeah, got one of those... Dell Logitech Trackball 
Mouse Pad
N/A 
CPUMotherboardGraphicsRAM
T5670 (Core2Duo) HP on-board 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB CD DVD RW W7 Ultimate (x86) 17" 
KeyboardPowerCaseMouse
QWERTY on-board Laptop touchpad 
  hide details  
Reply
post #2829 of 6206
But that would require their last value in a separate cell. You can't reference a value in the middle of a cell, so the answer's no. ;p
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 #2830 of 6206
Quote:
Originally Posted by zodac View Post
But that would require their last value in a separate cell. You can't reference a value in the middle of a cell, so the answer's no. ;p
I'll see what can be done when I can access the spreadie (or dupe of) shortly...
WKS04
(16 items)
 
WORK_PC
(13 items)
 
LAP03
(13 items)
 
CPUMotherboardGraphicsRAM
i7 920 D0 (HT on) @3.6 GHz Asus P6T nVidia 250 6 GB OCZ Gold 
Hard DriveOptical DriveCoolingOS
250 GB SATA CD DVD RW RASA RS360 Ubuntu 10.04 (W7U x64 as alternate boot) 
MonitorMonitorKeyboardPower
LG 19" (L194WS) LCD HP 15" LCD QWERTY (Logitech) High Power Plus 850W modular 
CaseMouseMouse PadAudio
Jeantech Phong2 Trackball (Logitech) n/a Hitachi AX-M5 
CPUMotherboardGraphicsRAM
Q8400 Dell Optiplex 780 GT430 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB Yes W7 Pro (x86 - with Linux x64 VM) 2 x 24" Dell 
KeyboardPowerCaseMouse
Dell Yeah, got one of those... Dell Logitech Trackball 
Mouse Pad
N/A 
CPUMotherboardGraphicsRAM
T5670 (Core2Duo) HP on-board 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB CD DVD RW W7 Ultimate (x86) 17" 
KeyboardPowerCaseMouse
QWERTY on-board Laptop touchpad 
  hide details  
Reply
WKS04
(16 items)
 
WORK_PC
(13 items)
 
LAP03
(13 items)
 
CPUMotherboardGraphicsRAM
i7 920 D0 (HT on) @3.6 GHz Asus P6T nVidia 250 6 GB OCZ Gold 
Hard DriveOptical DriveCoolingOS
250 GB SATA CD DVD RW RASA RS360 Ubuntu 10.04 (W7U x64 as alternate boot) 
MonitorMonitorKeyboardPower
LG 19" (L194WS) LCD HP 15" LCD QWERTY (Logitech) High Power Plus 850W modular 
CaseMouseMouse PadAudio
Jeantech Phong2 Trackball (Logitech) n/a Hitachi AX-M5 
CPUMotherboardGraphicsRAM
Q8400 Dell Optiplex 780 GT430 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB Yes W7 Pro (x86 - with Linux x64 VM) 2 x 24" Dell 
KeyboardPowerCaseMouse
Dell Yeah, got one of those... Dell Logitech Trackball 
Mouse Pad
N/A 
CPUMotherboardGraphicsRAM
T5670 (Core2Duo) HP on-board 4 GB 
Hard DriveOptical DriveOSMonitor
250 GB CD DVD RW W7 Ultimate (x86) 17" 
KeyboardPowerCaseMouse
QWERTY on-board Laptop touchpad 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Team Competition