----- Original Message -----

From: CJ &AA MAY

To: main@jfw.groups.io

Sent: Monday, January 13, 2020 9:36 PM

Subject: Re: Keys Seemingly Stuck Down

Unfortunately, Richard, re-starting doesn’t seem to solve my problem but I suspect you are right that it is something to do with sticky-keys functionality; it definitely isn’t anything wrong with the keyboard itself.

But I se a suggestion about trying to jiggle the alternative alt key, so will try this the next time it happens.

Interestingly enough, it never happens when I am using the internet.

Alison

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard B. McDonald
Sent: 13 January 2020 15:15
To: main@jfw.groups.io
Subject: Re: Keys Seemingly Stuck Down

 

Hi Alison!

 

About your issue with keys seemingly being stuck down, I have seen this before as well.  Most often, it is either or both of the alt and windows keys.  I have never figured out how or why this happens.  For me, it is not a mechanical thing, like the keys physically being stuck down due to something like a crumb.  I think it has something to do with something like “sticky keys.”  I have a vague recollection that a certain combination of keystrokes in Windows causes keys to act like they are always pressed down.  I do not know what that combination is.  But, apparently one can trigger this without knowing or intending to do so.  For me, the problem goes away after a restart.

 

HTH,

Richard

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of CJ &AA MAY
Sent: Monday, January 13, 2020 1:37 AM
To: main@jfw.groups.io
Subject: Re: upgrading Jaws

 

The keys don’t actually get stuck down but behave as though they are. We have tried cleaning them.

I had a feeling that this was discussed before Christmas and I wasn’t alone with this issue where the computer behaves as though the alt key or windows key is still depressed.

I think I will take Ed’s advice and wait till the summer before upgrading Jaws and take advantage of Sight and Sound’s Summer Deal as it looks as if it will cost me around £350 to upgrade from Jaws 18 to the current version.

Alison

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard Turner
Sent: 12 January 2020 17:26
To: main@jfw.groups.io
Subject: Re: upgrading Jaws

 

First, the problem with the keys acting like they are jammed down may not be a Jaws issue, so no one should say one way or the other if that will solve your problem.

Maybe you could specify what you have tried already to resolve that issue.

The current version is Jaws 2020, so if you have just Jaws 18, you would need 2018, 2019 and 2020, but since you get a little better deal doing them in groups of two, you may want to do through 2021.

Or, you could go with the subscription model at $90 per year and jump right into the 2020 version.

You'll have to do the math to see which makes the most sense in your situation.

HTH,

 

 

 

Richard

"Reality is the leading cause of stress for those who are in touch with it." 

-- from The Search for Signs of Intelligent Life in the Universe, by Jane Wagner

 

 

On Jan 12, 2020, at 8:01 AM, CJ &AA MAY <chrisalismay@...> wrote:



I was given a free migration from Window-eyes to Jaws 18 but would now like to upgrade. I see the price varies dependent upon how many upgrades you want. How many would I need to have the current version? Would the current version get rid of this problem I am having with the alt and windows key appearing as jammed down?

Alison

Unfortunately, Richard, re-starting doesn’t seem to solve my problem
but I suspect you are right that it is something to do with sticky-keys
functionality; it definitely isn’t anything wrong with the keyboard
itself.
But I se a suggestion about trying to jiggle the alternative alt key,
so will try this the next time it happens.
Interestingly enough, it never happens when I am using the internet.
Alison


From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard B. McDonald
Sent: 13 January 2020 15:15
To: main@jfw.groups.io
Subject: Re: Keys Seemingly Stuck Down

Hi Alison!

About your issue with keys seemingly being stuck
down, I have seen this before as well. Most
often, it is either or both of the alt and
windows keys. I have never figured out how or
why this happens. For me, it is not a
mechanical thing, like the keys physically being
stuck down due to something like a crumb. I
think it has something to do with something like
“sticky keys.â€&#65533; I have a vague recollection
that a certain combination of keystrokes in
Windows causes keys to act like they are always
pressed down. I do not know what that
combination is. But, apparently one can trigger
this without knowing or intending to do so. For
me, the problem goes away after a restart.

HTH,
Richard

From:
<mailto:main@jfw.groups.io>main@jfw.groups.io
<<mailto:main@jfw.groups.io>main@jfw.groups.io> On Behalf Of CJ &AA MAY
Sent: Monday, January 13, 2020 1:37 AM
To: <mailto:main@jfw.groups.io>main@jfw.groups.io
Subject: Re: upgrading Jaws

The keys don’t actually get stuck down but
behave as though they are. We have tried cleaning them.
I had a feeling that this was discussed before
Christmas and I wasn’t alone with this issue
where the computer behaves as though the alt key
or windows key is still depressed.
I think I will take Ed’s advice and wait till
the summer before upgrading Jaws and take
advantage of Sight and Sound’s Summer Deal as
it looks as if it will cost me around £350 to
upgrade from Jaws 18 to the current version.
Alison


From:
<mailto:main@jfw.groups.io>main@jfw.groups.io
<<mailto:main@jfw.groups.io>main@jfw.groups.io> On Behalf Of Richard Turner
Sent: 12 January 2020 17:26
To: <mailto:main@jfw.groups.io>main@jfw.groups.io
Subject: Re: upgrading Jaws

First, the problem with the keys acting like
they are jammed down may not be a Jaws issue, so
no one should say one way or the other if that will solve your problem.
Maybe you could specify what you have tried already to resolve that issue.
The current version is Jaws 2020, so if you have
just Jaws 18, you would need 2018, 2019 and
2020, but since you get a little better deal
doing them in groups of two, you may want to do through 2021.
Or, you could go with the subscription model at
$90 per year and jump right into the 2020 version.
You'll have to do the math to see which makes
the most sense in your situation.
HTH,



Richard
"Reality is the leading cause of stress for those who are in touch with it."
-- from The Search for Signs of Intelligent Life
in the Universe, by Jane Wagner


On Jan 12, 2020, at 8:01 AM, CJ &AA MAY
<<mailto:chrisalismay@...>chrisalismay@...> wrote:


I was given a free migration from Window-eyes to
Jaws 18 but would now like to upgrade. I see the
price varies dependent upon how many upgrades
you want. How many would I need to have the
current version? Would the current version get
rid of this problem I am having with the alt and
windows key appearing as jammed down?
Alison

Unfortunately, Richard, re-starting doesn’t seem to solve my problem
but I suspect you are right that it is something to do with sticky-keys
functionality; it definitely isn’t anything wrong with the keyboard
itself.
But I se a suggestion about trying to jiggle the alternative alt key,
so will try this the next time it happens.
Interestingly enough, it never happens when I am using the internet.
Alison


From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard B. McDonald
Sent: 13 January 2020 15:15
To: main@jfw.groups.io
Subject: Re: Keys Seemingly Stuck Down

Hi Alison!

About your issue with keys seemingly being stuck
down, I have seen this before as well. Most
often, it is either or both of the alt and
windows keys. I have never figured out how or
why this happens. For me, it is not a
mechanical thing, like the keys physically being
stuck down due to something like a crumb. I
think it has something to do with something like
“sticky keys.â€&#65533; I have a vague recollection
that a certain combination of keystrokes in
Windows causes keys to act like they are always
pressed down. I do not know what that
combination is. But, apparently one can trigger
this without knowing or intending to do so. For
me, the problem goes away after a restart.

HTH,
Richard

From:
<mailto:main@jfw.groups.io>main@jfw.groups.io
<<mailto:main@jfw.groups.io>main@jfw.groups.io> On Behalf Of CJ &AA MAY
Sent: Monday, January 13, 2020 1:37 AM
To: <mailto:main@jfw.groups.io>main@jfw.groups.io
Subject: Re: upgrading Jaws

The keys don’t actually get stuck down but
behave as though they are. We have tried cleaning them.
I had a feeling that this was discussed before
Christmas and I wasn’t alone with this issue
where the computer behaves as though the alt key
or windows key is still depressed.
I think I will take Ed’s advice and wait till
the summer before upgrading Jaws and take
advantage of Sight and Sound’s Summer Deal as
it looks as if it will cost me around £350 to
upgrade from Jaws 18 to the current version.
Alison


From:
<mailto:main@jfw.groups.io>main@jfw.groups.io
<<mailto:main@jfw.groups.io>main@jfw.groups.io> On Behalf Of Richard Turner
Sent: 12 January 2020 17:26
To: <mailto:main@jfw.groups.io>main@jfw.groups.io
Subject: Re: upgrading Jaws

First, the problem with the keys acting like
they are jammed down may not be a Jaws issue, so
no one should say one way or the other if that will solve your problem.
Maybe you could specify what you have tried already to resolve that issue.
The current version is Jaws 2020, so if you have
just Jaws 18, you would need 2018, 2019 and
2020, but since you get a little better deal
doing them in groups of two, you may want to do through 2021.
Or, you could go with the subscription model at
$90 per year and jump right into the 2020 version.
You'll have to do the math to see which makes
the most sense in your situation.
HTH,



Richard
"Reality is the leading cause of stress for those who are in touch with it."
-- from The Search for Signs of Intelligent Life
in the Universe, by Jane Wagner


On Jan 12, 2020, at 8:01 AM, CJ &AA MAY
<<mailto:chrisalismay@...>chrisalismay@...> wrote:


I was given a free migration from Window-eyes to
Jaws 18 but would now like to upgrade. I see the
price varies dependent upon how many upgrades
you want. How many would I need to have the
current version? Would the current version get
rid of this problem I am having with the alt and
windows key appearing as jammed down?
Alison

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Christopher Zeigler
Sent: 14 January 2020 07:29
To: main@jfw.groups.io
Subject: Re: Keys Seemingly Stuck Down

hello have you tried using a can of compressed air to try to any dust or debris out of the keyboard? Sometimes when I have a key get stuck sent will 6 the prothom. Please let me know if you've tried that to fix the problem.
Chris

Thanks!

Will this resolve the edit box issue?

Hi all,

Someone reported on JFW list (hosted on Groups.IO) that the user cannot interact with certain web content displayed in Edge 79 beta, along with a thread on Win10 forum about inability to interact with web content shown in Edge with other screen readers. This issue can be traced to the fact that, in Edge 79 (upcoming stable version), UI Automation is enabled (several reports were sent to Microsoft about this issue). Unfortunately, as an NVDA core developer (not me) notes, UIA implementation in Chromium-based web browsers (including Edge) isn’t solid yet.

To work around this for now, you need to disable UIA support in Edge and other Chromium-based web browsers (if your browser exposes this option). To do so in Edge 79:

1. Start new Microsoft Edge (not the old one).
2. From address omnibox (Alt+D), type “edge://flags” (without quotes and as exactly as shown) and press Enter.
3. Type “UI Automation” into “search flags” and press Tab to move through resulting content (no, DO NOT PRESS ENTER AFTER TYPING FLAGS!).
4. Go to “Native UI Automation” combo box and select “disabled”.
5. Press Tab to go to “Restart” button and click it.

Screen reader specifics:

• Narrator: supports native UI Automation
• JAWS: works better with native UI Automation off
• NVDA: works better with UI Automation off and a fix is being developed
• Other screen readers: contact vendors

Cheers,

Joseph

Hi all,

Someone reported on JFW list (hosted on Groups.IO) that the user cannot interact with certain web content displayed in Edge 79 beta, along with a thread on Win10 forum about inability to interact with web content shown in Edge with other screen readers. This issue can be traced to the fact that, in Edge 79 (upcoming stable version), UI Automation is enabled (several reports were sent to Microsoft about this issue). Unfortunately, as an NVDA core developer (not me) notes, UIA implementation in Chromium-based web browsers (including Edge) isn’t solid yet.

To work around this for now, you need to disable UIA support in Edge and other Chromium-based web browsers (if your browser exposes this option). To do so in Edge 79:

1. Start new Microsoft Edge (not the old one).
2. From address omnibox (Alt+D), type “edge://flags” (without quotes and as exactly as shown) and press Enter.
3. Type “UI Automation” into “search flags” and press Tab to move through resulting content (no, DO NOT PRESS ENTER AFTER TYPING FLAGS!).
4. Go to “Native UI Automation” combo box and select “disabled”.
5. Press Tab to go to “Restart” button and click it.

Screen reader specifics:

• Narrator: supports native UI Automation
• JAWS: works better with native UI Automation off
• NVDA: works better with UI Automation off and a fix is being developed
• Other screen readers: contact vendors

Cheers,

Joseph

Hi Alison!

About your issue with keys seemingly being stuck down, I have seen this before as well.  Most often, it is either or both of the alt and windows keys.  I have never figured out how or why this happens.  For me, it is not a mechanical thing, like the keys physically being stuck down due to something like a crumb.  I think it has something to do with something like “sticky keys.”  I have a vague recollection that a certain combination of keystrokes in Windows causes keys to act like they are always pressed down.  I do not know what that combination is.  But, apparently one can trigger this without knowing or intending to do so.  For me, the problem goes away after a restart.

HTH,

Richard

The keys don’t actually get stuck down but behave as though they are. We have tried cleaning them.

I had a feeling that this was discussed before Christmas and I wasn’t alone with this issue where the computer behaves as though the alt key or windows key is still depressed.

I think I will take Ed’s advice and wait till the summer before upgrading Jaws and take advantage of Sight and Sound’s Summer Deal as it looks as if it will cost me around £350 to upgrade from Jaws 18 to the current version.

Alison

First, the problem with the keys acting like they are jammed down may not be a Jaws issue, so no one should say one way or the other if that will solve your problem.

I don't think it is windows, I've noticed  this off and on for years, it has something to do with the keyboard controller circuitry.  No need to restart, just pound on the offending keys, both left and right keys, if you have them a few times and it will fix itself.

Hi Alison!

 

About your issue with keys seemingly being stuck down, I have seen this before as well.  Most often, it is either or both of the alt and windows keys.  I have never figured out how or why this happens.  For me, it is not a mechanical thing, like the keys physically being stuck down due to something like a crumb.  I think it has something to do with something like “sticky keys.”  I have a vague recollection that a certain combination of keystrokes in Windows causes keys to act like they are always pressed down.  I do not know what that combination is.  But, apparently one can trigger this without knowing or intending to do so.  For me, the problem goes away after a restart.

 

HTH,

Richard

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of CJ &AA MAY
Sent: Monday, January 13, 2020 1:37 AM
To: main@jfw.groups.io
Subject: Re: upgrading Jaws

 

The keys don’t actually get stuck down but behave as though they are. We have tried cleaning them.

I had a feeling that this was discussed before Christmas and I wasn’t alone with this issue where the computer behaves as though the alt key or windows key is still depressed.

I think I will take Ed’s advice and wait till the summer before upgrading Jaws and take advantage of Sight and Sound’s Summer Deal as it looks as if it will cost me around £350 to upgrade from Jaws 18 to the current version.

Alison

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard Turner
Sent: 12 January 2020 17:26
To: main@jfw.groups.io
Subject: Re: upgrading Jaws

 

First, the problem with the keys acting like they are jammed down may not be a Jaws issue, so no one should say one way or the other if that will solve your problem.

Maybe you could specify what you have tried already to resolve that issue.

The current version is Jaws 2020, so if you have just Jaws 18, you would need 2018, 2019 and 2020, but since you get a little better deal doing them in groups of two, you may want to do through 2021.

Or, you could go with the subscription model at $90 per year and jump right into the 2020 version.

You'll have to do the math to see which makes the most sense in your situation.

HTH,

 

 

 

Richard

"Reality is the leading cause of stress for those who are in touch with it." 

-- from The Search for Signs of Intelligent Life in the Universe, by Jane Wagner

 

 

On Jan 12, 2020, at 8:01 AM, CJ &AA MAY <chrisalismay@...> wrote:



I was given a free migration from Window-eyes to Jaws 18 but would now like to upgrade. I see the price varies dependent upon how many upgrades you want. How many would I need to have the current version? Would the current version get rid of this problem I am having with the alt and windows key appearing as jammed down?

Alison

Hi,

For me, it is usually the control key or the Alt key. I usually hold down the offending key and tap escape a couple times and that usually does the trick. HTH

I don't think it is windows, I've noticed  this off and on for years, it has something to do with the keyboard controller circuitry.  No need to restart, just pound on the offending keys, both left and right keys, if you have them a few times and it will fix itself.

Hi Alison!

 

About your issue with keys seemingly being stuck down, I have seen this before as well.  Most often, it is either or both of the alt and windows keys.  I have never figured out how or why this happens.  For me, it is not a mechanical thing, like the keys physically being stuck down due to something like a crumb.  I think it has something to do with something like “sticky keys.”  I have a vague recollection that a certain combination of keystrokes in Windows causes keys to act like they are always pressed down.  I do not know what that combination is.  But, apparently one can trigger this without knowing or intending to do so.  For me, the problem goes away after a restart.

 

HTH,

Richard

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of CJ &AA MAY
Sent: Monday, January 13, 2020 1:37 AM
To: main@jfw.groups.io
Subject: Re: upgrading Jaws

 

The keys don’t actually get stuck down but behave as though they are. We have tried cleaning them.

I had a feeling that this was discussed before Christmas and I wasn’t alone with this issue where the computer behaves as though the alt key or windows key is still depressed.

I think I will take Ed’s advice and wait till the summer before upgrading Jaws and take advantage of Sight and Sound’s Summer Deal as it looks as if it will cost me around £350 to upgrade from Jaws 18 to the current version.

Alison

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard Turner
Sent: 12 January 2020 17:26
To: main@jfw.groups.io
Subject: Re: upgrading Jaws

 

First, the problem with the keys acting like they are jammed down may not be a Jaws issue, so no one should say one way or the other if that will solve your problem.

Maybe you could specify what you have tried already to resolve that issue.

The current version is Jaws 2020, so if you have just Jaws 18, you would need 2018, 2019 and 2020, but since you get a little better deal doing them in groups of two, you may want to do through 2021.

Or, you could go with the subscription model at $90 per year and jump right into the 2020 version.

You'll have to do the math to see which makes the most sense in your situation.

HTH,

 

 

 

Richard

"Reality is the leading cause of stress for those who are in touch with it." 

-- from The Search for Signs of Intelligent Life in the Universe, by Jane Wagner

 

 

On Jan 12, 2020, at 8:01 AM, CJ &AA MAY <chrisalismay@...> wrote:



I was given a free migration from Window-eyes to Jaws 18 but would now like to upgrade. I see the price varies dependent upon how many upgrades you want. How many would I need to have the current version? Would the current version get rid of this problem I am having with the alt and windows key appearing as jammed down?

Alison

I’ll give a crack at explaining this to build on what Anne was saying:

For simplicity in my mind, I’m going to approach this slightly different from Anne.

I am assuming that cell D14 has your first dollar amount to add to the running balance in Column E.

Step 1.  Go to cell E14 and type “=D14”.  This is just pulling in the value from column D into column E for this line item as the first item in your running balance.

Step 2: go down to Cell E15.  This is the first place where you’ll be adding a new line item to your running balance. Your formula should be “=E14+D15”.  This adds the value of the new line item to the balance listed in the cell above.

Step 3.  Go to cell E16 and press Control+D , which will copy the above formula into this cell, adjusting the cell references as needed.  You can do this same keystroke all the way down Column E to build that running balance. 

There are other methods, but you seem to be a novice Excel user, so I’m leaving this simple.

Richard,

Is there a formula where the running balance/total can be in column E for example? Example: row 14 column D has $22.50 and this should be seen in same row 14 but column E. The next row, 15, has in column D $220.59 and row 15, column E should have the running total or sum. This would go down all rows and columns. Is this possible or just the total somewhere at the bottom cell where the total would be seen?

Thank you,

Rick



Hi all,

 

I am on an EXCEL spreadsheet, putting together a list of deductions for upcoming tax season.

 

Can anyone please explain how I add a formula to add up costs of items as a running total.

 

The costs are in column D and I am wanting the running balance in column E. Where do I put this formula and pardon my extreme ignorance here, what formula would I put in? The sum of these costs as they go down the column.

 

The costs start on row 14 column D and I would like this to go down the entire column, lets say to row 100 to be safe. Can someone please tell me the formula to put in and where this is embedded?

 

Thank you,

 

I am using Windows 10, Jaws 2019.1912.1 and Office 2019.

 

Thanks for your help,

 

Rick

 

This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information.

127 Public Square, Cleveland, OH 44114

If you prefer not to receive future e-mail offers for products or services from Key
send an e-mail to mailto:DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.

On Jan 13, 2020, at 8:54 AM, Mario <mrb620@...> wrote:

the keystroke for step 3 should be control c as in copy.

-------- Original Message --------
From: Van Lant, Robin via Groups.Io
[mailto:Robin_Van_Lant@...]
To: main@jfw.groups.io <main@jfw.groups.io>
Date: Monday, January 13, 2020, 10:45 AM
Subject: MS EXCEL formula
I’ll give a crack at explaining this to build on what Anne was saying:
For simplicity in my mind, I’m going to approach this slightly different
from Anne.

I am assuming that cell D14 has your first dollar amount to add to the
running balance in Column E.
Step 1.  Go to cell E14 and type “=D14”.  This is just pulling in the
value from column D into column E for this line item as the first item
in your running balance.
Step 2: go down to Cell E15.  This is the first place where you’ll be
adding a new line item to your running balance. Your formula should be
“=E14+D15”.  This adds the value of the new line item to the balance
listed in the cell above.
Step 3.  Go to cell E16 and press Control+D , which will copy the above
formula into this cell, adjusting the cell references as needed.  You
can do this same keystroke all the way down Column E to build that
running balance.

There are other methods, but you seem to be a novice Excel user, so I’m
leaving this simple.



From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Rick Mladek
Sent: Sunday, January 12, 2020 9:04 PM
To: main@jfw.groups.io
Subject: Re: MS EXCEL formula

Richard,

Is there a formula where the running balance/total can be in column E
for example? Example: row 14 column D has $22.50 and this should be seen
in same row 14 but column E. The next row, 15, has in column D $220.59
and row 15, column E should have the running total or sum. This would go
down all rows and columns. Is this possible or just the total somewhere
at the bottom cell where the total would be seen?

Thank you,

Rick


From: main@jfw.groups.io<mailto:main@jfw.groups.io>
<main@jfw.groups.io<mailto:main@jfw.groups.io>> On Behalf Of Richard Turner
Sent: Sunday, January 12, 2020 10:55 PM
To: main@jfw.groups.io<mailto:main@jfw.groups.io>
Subject: Re: MS EXCEL formula

You can put the formula anywhere in column e that you want the total to be.
The formula should be =sum(d14:d100)
Equals sum tells excel that you want to add numbers together.
open parenthesis d14 colon d100 close parenthesis tells it to add d14
through d100.
HTH,




Richard
"Reality is the leading cause of stress for those who are in touch with it."
-- from The Search for Signs of Intelligent Life in the Universe, by
Jane Wagner


On Jan 12, 2020, at 7:39 PM, Rick Mladek
<hmladek@...<mailto:hmladek@...>> wrote:

Hi all,

I am on an EXCEL spreadsheet, putting together a list of deductions for
upcoming tax season.

Can anyone please explain how I add a formula to add up costs of items
as a running total.

The costs are in column D and I am wanting the running balance in column
E. Where do I put this formula and pardon my extreme ignorance here,
what formula would I put in? The sum of these costs as they go down the
column.

The costs start on row 14 column D and I would like this to go down the
entire column, lets say to row 100 to be safe. Can someone please tell
me the formula to put in and where this is embedded?

Thank you,

I am using Windows 10, Jaws 2019.1912.1 and Office 2019.

Thanks for your help,

Rick




This communication may contain privileged and/or confidential
information. It is intended solely for the use of the addressee. If you
are not the intended recipient, you are strictly prohibited from
disclosing, copying, distributing or using any of this information. If
you received this communication in error, please contact the sender
immediately and destroy the material in its entirety, whether electronic
or hard copy. This communication may contain nonpublic personal
information about consumers subject to the restrictions of the
Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or
redisclose such information for any purpose other than to provide the
services for which you are receiving the information.

127 Public Square, Cleveland, OH 44114
If you prefer not to receive future e-mail offers for products or
services from Key
send an e-mail to mailto:DNERequests@... with 'No Promotional
E-mails' in the
SUBJECT line.

I’ll give a crack at explaining this to build on what Anne was saying:

For simplicity in my mind, I’m going to approach this slightly different from Anne.

I am assuming that cell D14 has your first dollar amount to add to the running balance in Column E.

Step 1.  Go to cell E14 and type “=D14”.  This is just pulling in the value from column D into column E for this line item as the first item in your running balance.

Step 2: go down to Cell E15.  This is the first place where you’ll be adding a new line item to your running balance. Your formula should be “=E14+D15”.  This adds the value of the new line item to the balance listed in the cell above.

Step 3.  Go to cell E16 and press Control+D , which will copy the above formula into this cell, adjusting the cell references as needed.  You can do this same keystroke all the way down Column E to build that running balance. 

There are other methods, but you seem to be a novice Excel user, so I’m leaving this simple.

Richard,

Is there a formula where the running balance/total can be in column E for example? Example: row 14 column D has $22.50 and this should be seen in same row 14 but column E. The next row, 15, has in column D $220.59 and row 15, column E should have the running total or sum. This would go down all rows and columns. Is this possible or just the total somewhere at the bottom cell where the total would be seen?

Thank you,

Rick



Hi all,

 

I am on an EXCEL spreadsheet, putting together a list of deductions for upcoming tax season.

 

Can anyone please explain how I add a formula to add up costs of items as a running total.

 

The costs are in column D and I am wanting the running balance in column E. Where do I put this formula and pardon my extreme ignorance here, what formula would I put in? The sum of these costs as they go down the column.

 

The costs start on row 14 column D and I would like this to go down the entire column, lets say to row 100 to be safe. Can someone please tell me the formula to put in and where this is embedded?

 

Thank you,

 

I am using Windows 10, Jaws 2019.1912.1 and Office 2019.

 

Thanks for your help,

 

Rick

 

This communication may contain privileged and/or confidential information. It is intended solely for the use of the addressee. If you are not the intended recipient, you are strictly prohibited from disclosing, copying, distributing or using any of this information. If you received this communication in error, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. This communication may contain nonpublic personal information about consumers subject to the restrictions of the Gramm-Leach-Bliley Act. You may not directly or indirectly reuse or redisclose such information for any purpose other than to provide the services for which you are receiving the information.

127 Public Square, Cleveland, OH 44114

If you prefer not to receive future e-mail offers for products or services from Key
send an e-mail to mailto:DNERequests@... with 'No Promotional E-mails' in the SUBJECT line.

I don't think it is windows, I've noticed  this off and on for years, it has something to do with the keyboard controller circuitry.  No need to restart, just pound on the offending keys, both left and right keys, if you have them a few times and it will fix itself.

Hi Alison!

 

About your issue with keys seemingly being stuck down, I have seen this before as well.  Most often, it is either or both of the alt and windows keys.  I have never figured out how or why this happens.  For me, it is not a mechanical thing, like the keys physically being stuck down due to something like a crumb.  I think it has something to do with something like “sticky keys.”  I have a vague recollection that a certain combination of keystrokes in Windows causes keys to act like they are always pressed down.  I do not know what that combination is.  But, apparently one can trigger this without knowing or intending to do so.  For me, the problem goes away after a restart.

 

HTH,

Richard

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of CJ &AA MAY
Sent: Monday, January 13, 2020 1:37 AM
To: main@jfw.groups.io
Subject: Re: upgrading Jaws

 

The keys don’t actually get stuck down but behave as though they are. We have tried cleaning them.

I had a feeling that this was discussed before Christmas and I wasn’t alone with this issue where the computer behaves as though the alt key or windows key is still depressed.

I think I will take Ed’s advice and wait till the summer before upgrading Jaws and take advantage of Sight and Sound’s Summer Deal as it looks as if it will cost me around £350 to upgrade from Jaws 18 to the current version.

Alison

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard Turner
Sent: 12 January 2020 17:26
To: main@jfw.groups.io
Subject: Re: upgrading Jaws

 

First, the problem with the keys acting like they are jammed down may not be a Jaws issue, so no one should say one way or the other if that will solve your problem.

Maybe you could specify what you have tried already to resolve that issue.

The current version is Jaws 2020, so if you have just Jaws 18, you would need 2018, 2019 and 2020, but since you get a little better deal doing them in groups of two, you may want to do through 2021.

Or, you could go with the subscription model at $90 per year and jump right into the 2020 version.

You'll have to do the math to see which makes the most sense in your situation.

HTH,

 

 

 

Richard

"Reality is the leading cause of stress for those who are in touch with it." 

-- from The Search for Signs of Intelligent Life in the Universe, by Jane Wagner

 

 

On Jan 12, 2020, at 8:01 AM, CJ &AA MAY <chrisalismay@...> wrote:



I was given a free migration from Window-eyes to Jaws 18 but would now like to upgrade. I see the price varies dependent upon how many upgrades you want. How many would I need to have the current version? Would the current version get rid of this problem I am having with the alt and windows key appearing as jammed down?

Alison