Hey Gang... I just wanted to let you know that "I believe" all the BS that I was experiencing on my computer was becuz of a faulty Video/Graphics card.Upon replacing the card all the strange error windows and log-in issues evaporated... poof, gone!I haven't had an issue since installing the new cardRead more
Hey Gang… I just wanted to let you know that “I believe” all the BS that I was experiencing on my computer was becuz of a faulty Video/Graphics card.
Upon replacing the card all the strange error windows and log-in issues evaporated… poof, gone!
I haven’t had an issue since installing the new card.
OK, since the problem does seem to be associated with the blank cells (it happens to me too, so I'll trust you on that) all we need to do is put some formulas in F6:F17.I see 2 criteria:1 - Don't start calculating the average until there are 13 values to average (E18)2 - Always average the current vRead more
OK, since the problem does seem to be associated with the blank cells (it happens to me too, so I’ll trust you on that) all we need to do is put some formulas in F6:F17.
I see 2 criteria:
1 – Don’t start calculating the average until there are 13 values to average (E18) 2 – Always average the current value with the previous 12 values
Convert the Table back to a Range, put this in F6 and drag it down to F29, then convert D5:F29 back to a table.
You’ll get blanks until you reach F18. From there on the INDIRECT and ROW functions will create the proper cell references for the AVERAGE function.
When you enter a Date in D30, the Table Auto Fill feature should do it’s thing.
If you aren’t familiar with the Evaluate Formula feature on the Formulas tab, check it out. You can single step through the formula as it builds the range.
It's possible, but not likely--I've had a reversed polarity outlet on one terminal connected to a network blow terminals connected much further down the line. This was a reversed polarity (live/ground) on an outlet other than the one connected to the destroyed machine.You should not get shocked whenRead more
It’s possible, but not likely–I’ve had a reversed polarity outlet on one terminal connected to a network blow terminals connected much further down the line. This was a reversed polarity (live/ground) on an outlet other than the one connected to the destroyed machine.
You should not get shocked when you touch the mode power cable!
Check the outlets for all equipment which attaches to the LAN cable. (Get a cheap checker from the hardware store, looks like a plug w/o wires, yellow, has led’s that indicate the wiring, made by GB. Assuming you’re in US, not sure what they look like elsewhere. Get one, use it every time you plug something into a new outlet, it will save you grief.) This includes the wall outlets AND the outlets on any surge protector/distribution strips. Have any incorrect sockets rewired.
If you have (good to have) a multimeter, check to verify that the voltage going into the modem is correct (both voltage and polarity +/-.
If it’s easy to check the cables physically, do that first. If it appears worn replace it–if it’s a short cable replace it at least temporarily.
Does this happen: 1) When only the modem power cable is plugged in? (i.e. the modem isn’t connected to power.) If so, the problem is probably with the wiring inside the surge protector. Check to make sure the wiring is correct/replace if not.
2) When the modem power cable is plugged into the modem, but the LAN is disconnected? This indicates a fault inside the modem, unlikely since you’ve had several burn out. Cure is to replace the modem.
3) When the modem power cable is connected, the modem is powered and the LAN cable is connected ONLY at the modem? This indicates a problem with the LAN cable itself, and you should inspect/replace the cable..
4) When everything is connected, but the modem power supply is not plugged into the outlet? This indicates that the problem may be with the computer or other device attached to the LAN cable. The computer may have a grounding problem, to check it, you need to check for voltage between the chassis and the outlet ground-it should be zero.
Check the Lan cable wires individually for voltages by putting the ground (-) lead to the outlet ground. None of the wires should show anything over about 12-25 volts.
If you find voltages higher, then you need to inspect the cable to see if there are any breaks, if the cable were abraded and contacted a live 110/220 circuit, it would cause the problem.
In general, to troubleshot this kind of thing, start at the power and verify each piece of the system (outet, surge protector, modem power supply/cable, modem, LAN wire and other connected devices.)
If you've left the switch set to it's default with VLAN 1 being the only VLAN on it, you should be able to plug into any port on the switch, give your computer/laptop an IP in the same subnet as your switch and then be able to either telnet or http into the switch from your computer.Your switch doesRead more
If you’ve left the switch set to it’s default with VLAN 1 being the only VLAN on it, you should be able to plug into any port on the switch, give your computer/laptop an IP in the same subnet as your switch and then be able to either telnet or http into the switch from your computer.
Your switch does have an IP doesn’t it?
The only 3com I have left is a 4400. I suspect the interface (and commands) are the same so if you can’t http directly into the switch then let me know and I’ll dig it out and find a null modem cable to console in and then I’ll have a quick look at how to reenable your interface.
It matters not how straight the gate, How charged with punishments the scroll, I am the master of my fate; I am the captain of my soul.
When you delete files in Windows they go into the Recycle Bin, rather than being taken off the disk. Until you empty the Recycle Bin they will still appear as used space - hence the reduction in free space - but will automatically be deleted if the space is needed.
When you delete files in Windows they go into the Recycle Bin, rather than being taken off the disk. Until you empty the Recycle Bin they will still appear as used space – hence the reduction in free space – but will automatically be deleted if the space is needed.
Have you been here and read the how to do various things with it; including setting it up for the first time?http://www.logitech.com/en-gb/produ...Go to the setup guide tab - which takes to:http://www.logitech.com/en-gb/manua...
Have you been here and read the how to do various things with it; including setting it up for the first time?
Does it sometimes type Y or sometimes W?Seriously, if it's only typing vowels and it's doing that with more than one keyboard it sounds like malware.Can you get into cmos/bios setup and see if some of the keys work there? Try booting to safe mode and see if you can get in. Or boot up with a cd or flRead more
Does it sometimes type Y or sometimes W?
Seriously, if it’s only typing vowels and it’s doing that with more than one keyboard it sounds like malware.
Can you get into cmos/bios setup and see if some of the keys work there? Try booting to safe mode and see if you can get in. Or boot up with a cd or floppy disk and see if the keys work then.
I understand your frustration. That said, the difference in performance in practice is minimal. The specs of the SATA drive are probably just as important as running in AHCI mode vs. IDE. If you ever need to perform a fresh install that would be the time to change the setting.
I understand your frustration. That said, the difference in performance in practice is minimal. The specs of the SATA drive are probably just as important as running in AHCI mode vs. IDE.
If you ever need to perform a fresh install that would be the time to change the setting.
As mentioned, the partition (FAT16) limit for MS-DOS is 2.1GB. The "entire-drive" (Int13h Interface) limit is 8.4GB:http://www.pcguide.com/ref/hdd/bios...http://www.pcguide.com/ref/hdd/bios...Also have to agree with DAVE and Skip, what DOS program could you possibly be using to need that much space?Read more
As mentioned, the partition (FAT16) limit for MS-DOS is 2.1GB. The “entire-drive” (Int13h Interface) limit is 8.4GB:
Solved How To Access Safe Mode if F4, 5 Or 6 Doesn’t Work?
Hey Gang... I just wanted to let you know that "I believe" all the BS that I was experiencing on my computer was becuz of a faulty Video/Graphics card.Upon replacing the card all the strange error windows and log-in issues evaporated... poof, gone!I haven't had an issue since installing the new cardRead more
Upon replacing the card all the strange error windows and log-in issues evaporated… poof, gone!
I haven’t had an issue since installing the new card.
Go figure. LOL
Thanks again,
XTC
Solved Read Specific Content Of An XML File Through Batch File
@echo off & setlocalfor /f "tokens=1,2,3* delims==" %%a in (C:\\test.xml) do (if /i "%%a" equ "<definition name" call :zz %%bif /i "%%a" equ "<put name" call :zz "%%~c")goto :eof:zzecho %~1::=== not fully test, might need tweaked.
for /f “tokens=1,2,3* delims==” %%a in (C:\\test.xml) do (
if /i “%%a” equ “<definition name” call :zz %%b
if /i “%%a” equ “<put name” call :zz “%%~c”
)
goto :eof
:zz
echo %~1
::=== not fully test, might need tweaked.
Solved Help With Inconsistent Cell Formulas In Tables
OK, since the problem does seem to be associated with the blank cells (it happens to me too, so I'll trust you on that) all we need to do is put some formulas in F6:F17.I see 2 criteria:1 - Don't start calculating the average until there are 13 values to average (E18)2 - Always average the current vRead more
I see 2 criteria:
1 – Don’t start calculating the average until there are 13 values to average (E18)
2 – Always average the current value with the previous 12 values
Convert the Table back to a Range, put this in F6 and drag it down to F29, then convert D5:F29 back to a table.
=IF(ROW()<18,””,AVERAGE(INDIRECT(“E”&ROW;()-12 &”:E”&ROW;())))
You’ll get blanks until you reach F18. From there on the INDIRECT and ROW functions will create the proper cell references for the AVERAGE function.
When you enter a Date in D30, the Table Auto Fill feature should do it’s thing.
If you aren’t familiar with the Evaluate Formula feature on the Formulas tab, check it out. You can single step through the formula as it builds the range.
message edited by DerbyDad03
I Keep Burning Out Modems And I Got Shocked
It's possible, but not likely--I've had a reversed polarity outlet on one terminal connected to a network blow terminals connected much further down the line. This was a reversed polarity (live/ground) on an outlet other than the one connected to the destroyed machine.You should not get shocked whenRead more
You should not get shocked when you touch the mode power cable!
Check the outlets for all equipment which attaches to the LAN cable. (Get a cheap checker from the hardware store, looks like a plug w/o wires, yellow, has led’s that indicate the wiring, made by GB. Assuming you’re in US, not sure what they look like elsewhere. Get one, use it every time you plug something into a new outlet, it will save you grief.) This includes the wall outlets AND the outlets on any surge protector/distribution strips. Have any incorrect sockets rewired.
If you have (good to have) a multimeter, check to verify that the voltage going into the modem is correct (both voltage and polarity +/-.
If it’s easy to check the cables physically, do that first. If it appears worn replace it–if it’s a short cable replace it at least temporarily.
Does this happen:
1) When only the modem power cable is plugged in? (i.e. the modem isn’t connected to power.) If so, the problem is probably with the wiring inside the surge protector. Check to make sure the wiring is correct/replace if not.
2) When the modem power cable is plugged into the modem, but the LAN is disconnected? This indicates a fault inside the modem, unlikely since you’ve had several burn out. Cure is to replace the modem.
3) When the modem power cable is connected, the modem is powered and the LAN cable is connected ONLY at the modem? This indicates a problem with the LAN cable itself, and you should inspect/replace the cable..
4) When everything is connected, but the modem power supply is not plugged into the outlet? This indicates that the problem may be with the computer or other device attached to the LAN cable. The computer may have a grounding problem, to check it, you need to check for voltage between the chassis and the outlet ground-it should be zero.
Check the Lan cable wires individually for voltages by putting the ground (-) lead to the outlet ground. None of the wires should show anything over about 12-25 volts.
If you find voltages higher, then you need to inspect the cable to see if there are any breaks, if the cable were abraded and contacted a live 110/220 circuit, it would cause the problem.
In general, to troubleshot this kind of thing, start at the power and verify each piece of the system (outet, surge protector, modem power supply/cable, modem, LAN wire and other connected devices.)
Hope this helps.
Enable a Port On a 3Com Switch
If you've left the switch set to it's default with VLAN 1 being the only VLAN on it, you should be able to plug into any port on the switch, give your computer/laptop an IP in the same subnet as your switch and then be able to either telnet or http into the switch from your computer.Your switch doesRead more
Your switch does have an IP doesn’t it?
The only 3com I have left is a 4400. I suspect the interface (and commands) are the same so if you can’t http directly into the switch then let me know and I’ll dig it out and find a null modem cable to console in and then I’ll have a quick look at how to reenable your interface.
It matters not how straight the gate,
How charged with punishments the scroll,
I am the master of my fate;
I am the captain of my soul.
***William Henley***
Solved Two 500GB Drives…Same Data…Different Dree Space?
When you delete files in Windows they go into the Recycle Bin, rather than being taken off the disk. Until you empty the Recycle Bin they will still appear as used space - hence the reduction in free space - but will automatically be deleted if the space is needed.
Need Digital Pin Number For Bluetooth Multi-Device Keyboard
Have you been here and read the how to do various things with it; including setting it up for the first time?http://www.logitech.com/en-gb/produ...Go to the setup guide tab - which takes to:http://www.logitech.com/en-gb/manua...
http://www.logitech.com/en-gb/produ…
Go to the setup guide tab – which takes to:
http://www.logitech.com/en-gb/manua…
My Keyboard Is Only Typing A E I O U
Does it sometimes type Y or sometimes W?Seriously, if it's only typing vowels and it's doing that with more than one keyboard it sounds like malware.Can you get into cmos/bios setup and see if some of the keys work there? Try booting to safe mode and see if you can get in. Or boot up with a cd or flRead more
Seriously, if it’s only typing vowels and it’s doing that with more than one keyboard it sounds like malware.
Can you get into cmos/bios setup and see if some of the keys work there? Try booting to safe mode and see if you can get in. Or boot up with a cd or floppy disk and see if the keys work then.
Real men don’t use AntiVirus; they just reformat
Solved Enabling AHCI On Seagate SATA Hard Disk Drive
I understand your frustration. That said, the difference in performance in practice is minimal. The specs of the SATA drive are probably just as important as running in AHCI mode vs. IDE. If you ever need to perform a fresh install that would be the time to change the setting.
If you ever need to perform a fresh install that would be the time to change the setting.
Expend DOS 6.22 Drive Size Limit
As mentioned, the partition (FAT16) limit for MS-DOS is 2.1GB. The "entire-drive" (Int13h Interface) limit is 8.4GB:http://www.pcguide.com/ref/hdd/bios...http://www.pcguide.com/ref/hdd/bios...Also have to agree with DAVE and Skip, what DOS program could you possibly be using to need that much space?Read more
http://www.pcguide.com/ref/hdd/bios…
http://www.pcguide.com/ref/hdd/bios…
Also have to agree with DAVE and Skip, what DOS program could you possibly be using to need that much space?
“Channeling the spirit of jboy…”