USCHO Fan Forum
This is a sample guest message. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
-
The USCHO Fan Forum has migrated to a new plaform, xenForo. Most of the function of the forum should work in familiar ways. Please note that you can switch between light and dark modes by clicking on the gear icon in the upper right of the main menu bar. We are hoping that this new platform will prove to be faster and more reliable. Please feel free to explore its features.
computer issues: part infinity
- Thread starter unofan
- Start date
Spartanforlife4
Generic Catchy Message
Re: computer issues: part infinity
I think I broke Excel...
Decided to go ahead and create an RPI formula, but ever since applying the adjusted winning percentage (.6 wins for home, 1.4 away like basketball, as they have similar stats for home/away) formulas only update when I save. Otherwise if I create a formula like vlookup or something of the like it will only repeat the first cell's answer.
I think I broke Excel...
Decided to go ahead and create an RPI formula, but ever since applying the adjusted winning percentage (.6 wins for home, 1.4 away like basketball, as they have similar stats for home/away) formulas only update when I save. Otherwise if I create a formula like vlookup or something of the like it will only repeat the first cell's answer.
Ralph Baer
Let's Go 'Tute!
Re: computer issues: part infinity
No doubt how to change this depends upon the version which you are using. In Excel-10, click on the File tab. Then Options on the left. Then Formulas. Set the Automatic option.
Simpler is to click on the Formulas tab and then bring down the Calculations menu toward the right and check Automatic.
No doubt how to change this depends upon the version which you are using. In Excel-10, click on the File tab. Then Options on the left. Then Formulas. Set the Automatic option.
Simpler is to click on the Formulas tab and then bring down the Calculations menu toward the right and check Automatic.
Last edited:
Re: computer issues: part infinity
We had a similar problem at work when using large database. We solved it with a two-step process:
-- first, the formulas were only stored in the top row, and every precedent variable was always to the left.
-- then, we would use a simple macro to calculate the whole sheet, column by column:
* copy the formula in the first column down to the bottom row.
* paste special values everything except the top row.
* move over one column and then repeat.
This procedure allows you to recalculate the entire workbook column by column instead of every formula updating in every cell any time one variable is changed.
We had a similar problem at work when using large database. We solved it with a two-step process:
-- first, the formulas were only stored in the top row, and every precedent variable was always to the left.
-- then, we would use a simple macro to calculate the whole sheet, column by column:
* copy the formula in the first column down to the bottom row.
* paste special values everything except the top row.
* move over one column and then repeat.
This procedure allows you to recalculate the entire workbook column by column instead of every formula updating in every cell any time one variable is changed.
Spartanforlife4
Generic Catchy Message
Re: computer issues: part infinity
Ah, ok, sounds like I clicked something by accident then.
I really need to brush up on VBA, it would make this whole process much faster.
Ah, ok, sounds like I clicked something by accident then.
I really need to brush up on VBA, it would make this whole process much faster.
Re: computer issues: part infinity
In case anyone missed it, any of us with Windows 7, 8 or 8.1 computers can upgrade to Windows 10 for free starting today. The free window will last for the next full year. I'm holding off a month to let the early adopters experience the download lags, iron out the first round of issues, and let my applications have a chance to rollout their own system updates for the new Windows compatability.
In case anyone missed it, any of us with Windows 7, 8 or 8.1 computers can upgrade to Windows 10 for free starting today. The free window will last for the next full year. I'm holding off a month to let the early adopters experience the download lags, iron out the first round of issues, and let my applications have a chance to rollout their own system updates for the new Windows compatability.
unofan
Well-known member
Re: computer issues: part infinity
So I've been the de facto IT guy for my parents for decades. It's gotten harder the last couple years since they've moved to Colorado and I can only do in person repairs on a semi-annual basis. There's obviously a limit to what I can do by phone.
My mom fell for one of the "your computer is infected, click here or call this number to clean your computer" type scams this morning. She got as far as giving the scammer her bank account info, but after the fact realized it was a scam and was able to stop payment at her bank and got her account numbers changed. She swears she only gave the guy her e-mail address and her bank account number, but I have no idea how much info he actually got in the interim. My dad says he used the computer later that day only to check e-mail, but again I have no idea if he actually went to other sites or not or entered any of his passwords to other sites.
After my initial blow-up (I'd warned them about this sort of thing many times, especially after this happened to my dad once before, but he got ahold of me before giving up any important info), I told them to unhook and not use the computer until they can take it to someone who can clean it or do a reformat if needed in case there were still Trojans/keyloggers/other viruses still on there. I also advised them to change their e-mail passwords from either their phones or another computer as soon as they got a chance. My question is do you think I need to tell them to do more? I'm thinking things along the line of:
a) get new e-mail addresses
b) change all of their passwords
c) sign up for credit monitoring (I initially advised them to wait until something else happened to do this on the presumption that my mom was fully truthful and only gave up her e-mail address and a no-longer good bank account number, but my wife thinks they should go ahead and do this and I'm starting to second guess myself and agree).
d) get an elderly-proof anti-virus software (and any recommendations for such).
e) something else I'm not thinking of.
I'll probably talk to them tomorrow to see what the tech guy says (they promised they'd take it in to a shop tomorrow), so any advice in the meantime would be appreciated.
So I've been the de facto IT guy for my parents for decades. It's gotten harder the last couple years since they've moved to Colorado and I can only do in person repairs on a semi-annual basis. There's obviously a limit to what I can do by phone.
My mom fell for one of the "your computer is infected, click here or call this number to clean your computer" type scams this morning. She got as far as giving the scammer her bank account info, but after the fact realized it was a scam and was able to stop payment at her bank and got her account numbers changed. She swears she only gave the guy her e-mail address and her bank account number, but I have no idea how much info he actually got in the interim. My dad says he used the computer later that day only to check e-mail, but again I have no idea if he actually went to other sites or not or entered any of his passwords to other sites.
After my initial blow-up (I'd warned them about this sort of thing many times, especially after this happened to my dad once before, but he got ahold of me before giving up any important info), I told them to unhook and not use the computer until they can take it to someone who can clean it or do a reformat if needed in case there were still Trojans/keyloggers/other viruses still on there. I also advised them to change their e-mail passwords from either their phones or another computer as soon as they got a chance. My question is do you think I need to tell them to do more? I'm thinking things along the line of:
a) get new e-mail addresses
b) change all of their passwords
c) sign up for credit monitoring (I initially advised them to wait until something else happened to do this on the presumption that my mom was fully truthful and only gave up her e-mail address and a no-longer good bank account number, but my wife thinks they should go ahead and do this and I'm starting to second guess myself and agree).
d) get an elderly-proof anti-virus software (and any recommendations for such).
e) something else I'm not thinking of.
I'll probably talk to them tomorrow to see what the tech guy says (they promised they'd take it in to a shop tomorrow), so any advice in the meantime would be appreciated.
Last edited:
Re: computer issues: part infinity
Basically change everything. Ask the bank if they can do a "double-password" to access their accounts. My bank, after an attempted hack, did this for me. If there is ANY suspicious activity, they call me and ask for my internet account password, then a verbal password that they have on file, separate from my actual account file. IF those two passwords don't match, they freeze everything and I have to go in for a physical ID (show up and prove I am who I say I am).
Basically change everything. Ask the bank if they can do a "double-password" to access their accounts. My bank, after an attempted hack, did this for me. If there is ANY suspicious activity, they call me and ask for my internet account password, then a verbal password that they have on file, separate from my actual account file. IF those two passwords don't match, they freeze everything and I have to go in for a physical ID (show up and prove I am who I say I am).
FlagDUDE08
Banned
Re: computer issues: part infinity
Most places will offer two-factor auth nowadays, where they'll call you on a telephone to verify it's you.
Most places will offer two-factor auth nowadays, where they'll call you on a telephone to verify it's you.
Re: computer issues: part infinity
I would be concerned if my bank was asking me for my internet password. They shouldn't even know your plain-text password. If they have your password stored in plain-text on their system, that's a problem. I suppose it's possible the rep is using a system that compares the hash of the password you give them to the hash that they have on file, but I doubt it.
I would be concerned if my bank was asking me for my internet password. They shouldn't even know your plain-text password. If they have your password stored in plain-text on their system, that's a problem. I suppose it's possible the rep is using a system that compares the hash of the password you give them to the hash that they have on file, but I doubt it.
Last edited:
FlagDUDE08
Banned
Re: computer issues: part infinity
Absolutely not. I would be looking for a new bank.
Absolutely not. I would be looking for a new bank.
FlagDUDE08
Banned
Re: computer issues: part infinity
New bank may not necessarily be needed, because those sorts of e-mails are sent by spoof phishers, not the actual bank itself. Just don't take the bait.
New bank may not necessarily be needed, because those sorts of e-mails are sent by spoof phishers, not the actual bank itself. Just don't take the bait.
Re: computer issues: part infinity
Exactly. No one at your bank should have access to your internet banking password, or ask you for it.
I can't believe you would give any private information to someone that calls you. Tell them you'll call them back, then call the number you have for that institution. Anyone can say they're from your bank. It's also not very wise to post about this process in a public forum. Anyone can see it, and can probably get your personal info somewhere. I think I know how you got hacked.
The double-password is a good idea in theory, but one of those passwords should NOT be the password used to access your account online.
Exactly. No one at your bank should have access to your internet banking password, or ask you for it.
I can't believe you would give any private information to someone that calls you. Tell them you'll call them back, then call the number you have for that institution. Anyone can say they're from your bank. It's also not very wise to post about this process in a public forum. Anyone can see it, and can probably get your personal info somewhere. I think I know how you got hacked.
The double-password is a good idea in theory, but one of those passwords should NOT be the password used to access your account online.
Last edited:
Re: computer issues: part infinity
Help.
Believe it or not, I had these annoying windows updates that kept locking down my computer for 5 minutes every week or so. So a friend turned them off. And guess what, the world did not end. As a matter of fact, its been awesome.
However now, MSFT found out some how. And literally every ten seconds or so, I have a purple bar (windows 8) that appears across my screen that says 'Windows Updates needs you help. Windows Updates haven't been able to check your computer for 30 days. Go to Windows Updates to resolve this issue.'
I have no intention of doing that as my computer works fine without the updates...and I consider this as bad as any virus.
Can you help?
Help.
Believe it or not, I had these annoying windows updates that kept locking down my computer for 5 minutes every week or so. So a friend turned them off. And guess what, the world did not end. As a matter of fact, its been awesome.
However now, MSFT found out some how. And literally every ten seconds or so, I have a purple bar (windows 8) that appears across my screen that says 'Windows Updates needs you help. Windows Updates haven't been able to check your computer for 30 days. Go to Windows Updates to resolve this issue.'
I have no intention of doing that as my computer works fine without the updates...and I consider this as bad as any virus.
Can you help?
FlagDUDE08
Banned
Re: computer issues: part infinity
And while not all Windows updates are necessary, there are options to choose which you get automatically and which you perform manually. Right now you've set up all of yours to manual, but should really have your security updates set to automatic. That advice stands so long as you're using a personal PC and not a work PC.
Update to Windows 10 now for free and get off Windows 8 ASAP. You'll likely need all of your Win8 updates in place in order to be permitted the update, but it's so very much worth it.
And while not all Windows updates are necessary, there are options to choose which you get automatically and which you perform manually. Right now you've set up all of yours to manual, but should really have your security updates set to automatic. That advice stands so long as you're using a personal PC and not a work PC.
Re: computer issues: part infinity
Personal PC...and Linux is too much of a change.
Whew. It stopped...maybe they're bored in toying with me. My PC functions just fine without the updates and I have never seen any functional change after their included. I'm not doing heavy CAD, I'm doing the internet and Office. A PC built in 2015 out of the box should be able to do that without 5 minute weekly updates.
I'm open to upgrading to Win10. But I'm in the middle of some important work issues and cannot risk it. If the messages come back, I guess I'll head to BBY to have the Geeks take a look at it.
Personal PC...and Linux is too much of a change.
Whew. It stopped...maybe they're bored in toying with me. My PC functions just fine without the updates and I have never seen any functional change after their included. I'm not doing heavy CAD, I'm doing the internet and Office. A PC built in 2015 out of the box should be able to do that without 5 minute weekly updates.
I'm open to upgrading to Win10. But I'm in the middle of some important work issues and cannot risk it. If the messages come back, I guess I'll head to BBY to have the Geeks take a look at it.