moderated Re: MS EXCEL formula

Hi there, Thank you for helping me. I use such applications/programs but am so very ignorant in doing so. I’ll give your tips a try and let you know how I come out.

Thank you again,

Rick

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Van Lant, Robin via Groups.Io
Sent: Monday, January 13, 2020 10:46 AM
To: main@jfw.groups.io
Subject: Re: 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 <main@jfw.groups.io> On Behalf Of Richard Turner
Sent: Sunday, January 12, 2020 10:55 PM
To: 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

﻿

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.

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.

moderated Re: Keys Seemingly Stuck Down

HH. Smith Jr.

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

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Chris Hill
Sent: Monday, January 13, 2020 12:36 PM
To: main@jfw.groups.io
Subject: Re: Keys Seemingly Stuck Down

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.

On 1/13/2020 09:14, Richard B. McDonald wrote:

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

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

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

moderated Re: Keys Seemingly Stuck Down

Chris Hill

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.

On 1/13/2020 09:14, Richard B. McDonald wrote:

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

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

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

moderated jaws 2020 speech issue with blueooth headphones

Jessica D

Hi,

I’m using jaws2020, and Aftershokz trekz titanium headphones.

I’ve noticed recently that my jaws speech stutters.

Is this normal?

How can I fix it?

Thanks,

Jessica

Loy

Another option is the subscription version is available in the US for\$99 per year You always have the latest version But if you don't renew the subscription, your current version converts to a demo..

----- Original Message -----
From: "Mario" <mrb620@hotmail.com>
To: <main@jfw.groups.io>
Sent: Monday, January 13, 2020 10:36 AM

a friend of my sister is looking to get back in to using JAWS with
Windows 10, but I'm not sure if she's several versions behind or never
used JAWS before. if I tell her if she can wait til the FS/VFO S&S
summer special, would she be able to save quite a bit on a first time
purchase if she never used JAWS before?

how would one know if there is going to be a special, and when will the
upcoming special begin?

-------- Original Message --------
From: Edward Green [mailto:ergreen1981@gmail.com]
To: main@jfw.groups.io
Date: Monday, January 13, 2020, 3:07 AM
Hi Alison,

If you can hang on, I'd wait for the Freedom Scientific/VFO/Sight and
Sound summer special, and buy a new JAWS licence outright. This is
likely to be significantly cheaper if previous years' pricing is
anything to go by.

Cheers,

Ed

On 12 Jan 2020, at 17:55, Vaughn Brown <jazzdressage@gmail.com> wrote:

﻿I second Richard on all accounts.
Did you try cleaning between the keys? I use a small amount of rubbing
alcohol as it evaporates after a short time and will not damage any
sticky areas.
I am using JAWS 2020 and enjoy it. I did the \$90/year subscription.
Again, your situation with JAWS is based on affordability.
Hope this helps.
Vaughn

On 1/12/20, Richard Turner <richardturner42@outlook.com> wrote:
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
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@gmail.com> 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

--
Kindly,
Vaughn Brown
Vaughn's Percussionship
Heal through Feel Equine Massage
360-904-8432
http://www.vaughnbrown.net
Serving Clark County

.

moderated Re: MS EXCEL formula

Mario

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=Key.com@groups.io]
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
Step 2: go down to Cell E15. This is the first place where you’ll 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
﻿
Hi all,

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

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.

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
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@key.com with 'No Promotional
E-mails' in the
SUBJECT line.

moderated Re: ISO someone who writes Jaws scripts

Sean Murphy

Doug lee from level access is first class   I have done work with him and he does know his stuff

My experience is the part

On 12 Jan 2020, at 11:58 pm, David Goldfield <david.goldfield@...> wrote:

﻿

I'm familiar with Jackie. She definitely knows her business but I had no idea she could write JAWS scripts. I'm not surprised, though.

```David Goldfield,
Blindness Assistive Technology Specialist
JAWS Certified, 2019

WWW.DavidGoldfield.org```
On 1/12/2020 7:52 AM, Rod wrote:
Jackie McBride on this list is also superb and talented. You can’t go wrong with her.

Rod Alcidonis, Esq.

From: David Goldfield
Sent: Sunday, January 12, 2020 3:01 AM
To: main@jfw.groups.io
Subject: Re: ISO someone who writes Jaws scripts

For customized JAWS script writing I highly recommend Brian Hartgen, who is just amazing.

You can also contact Level Access as well as the Paciello Group.

```David Goldfield,
Blindness Assistive Technology Specialist
JAWS Certified, 2019

WWW.DavidGoldfield.org```
On 1/10/2020 11:57 AM, Rayn Darren wrote:
HI Sieghard,

Will do, thank you so much!

Sarah

On 1/10/2020 8:56 AM, Sieghard Weitzel wrote:
You could contact Brian Hartgen from Hartgen Consultancy<https://nam12.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.hartgen.org%2F&amp;data=02%7C01%7C%7C613d1841d00b4e83e24008d795ee3dc6%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637142722772780854&amp;sdata=MHezIWISODf%2F9ePGHMoRdixkTMzpgzcbFJQJxCJR9rM%3D&amp;reserved=0>, he's probably as good as they get.

-----Original Message-----
From: main@jfw.groups.io mailto:main@jfw.groups.io On Behalf Of Rayn Darren
Sent: Thursday, January 9, 2020 2:05 PM
To: main@jfw.groups.io
Subject: ISO someone who writes Jaws scripts

Hi all,

I have a client who's looking for a particular script to be written for Jaws, he has 2020. This script needs to announce the numbers as they change in a stock ticker. These are updated in real time. If anyone could help with inof on this I'd really appreciate it.

Sarah

moderated Re: jaws announcing tables

Mich Verrier

Hi I to would like to know if this is possible as well. I am finding that jaws has been reading some e mails as tables and am wondering how to change this? I get a news letter from vidioeta and found that for the past little wile jaws is reading it as a table and it is annoying. No other e mails I get seem to do this. I am running jaws 2018 btw. From Mich.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard Turner
Sent: January 12, 2020 2:15 AM
To: main@jfw.groups.io
Subject: jaws announcing tables

Is there a way to turn off Jaws' announcements of tables when reading documents?
I'm helping an elderly friend who receives a lot of interesting articles that have been copied from a web site, then saved in Word.
When reading, Jaws announces the Table with so many rows and columns.
Is it possible to turn that off so it just reads the text?
Thanks,
Richard

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

moderated Re: Keys Seemingly Stuck Down

Richard B. McDonald

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

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

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

Gerald Levy

Forget about specials.  If your sister's friend  has never used JAWS before, or else is several versions behind, her best bet would be to  purchase a one year license for JAWS 2020 right now for \$90 and renew it every year.  This is the cheapest option because buying a copy of JAWS 2020 outright would cost over \$1000,and would still cost a few hundred dollars even if Vispero/FS were to offer special deals. If you purchase JAWS outright, you own it forever, and would still have to purchase an SMA every two years to keep it up to date.  But if you purchase a one-year license, you are purchasing the right to use JAWS for one year and do not own it.  If you don't renew the license before it expires, then JAWS will revert to 40 minute demo mode. But you would have the right to use JAWS for ten years with the license option for the same price as purchasing it outright, and you would not have to make such a large one-time financial commitment.

Gerald

On 1/13/2020 10:36 AM, Mario wrote:
a friend of my sister is looking to get back in to using JAWS with
Windows 10, but I'm not sure if she's several versions behind or never
used JAWS before. if I tell her if she can wait til the FS/VFO S&S
summer special, would she be able to save quite a bit on a first time
purchase if she never used JAWS before?

how would one know if there is going to be a special, and when will the
upcoming special begin?

-------- Original Message --------
From: Edward Green [mailto:ergreen1981@gmail.com]
To: main@jfw.groups.io
Date: Monday, January 13, 2020, 3:07 AM
Hi Alison,

If you can hang on, I'd wait for the Freedom Scientific/VFO/Sight and
Sound summer special, and buy a new JAWS licence outright. This is
likely to be significantly cheaper if previous years' pricing is
anything to go by.

Cheers,

Ed

On 12 Jan 2020, at 17:55, Vaughn Brown <jazzdressage@gmail.com> wrote:

﻿I second Richard on all accounts.
Did you try cleaning between the keys? I use a small amount of rubbing
alcohol as it evaporates after a short time and will not damage any
sticky areas.
I am using JAWS 2020 and enjoy it. I did the \$90/year subscription.
Again, your situation with JAWS is based on affordability.
Hope this helps.
Vaughn

On 1/12/20, Richard Turner <richardturner42@outlook.com> wrote:
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
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@gmail.com> 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

moderated Re: MS EXCEL formula

george b <gbmagoo@...>

Here you go

If you just wish to add the cells in a collum do the following;

Example =SUM(D1:D14)

You would put this formulia in d 15
So now the first cell in the formulia is the one you wish to start with and
the last cell in the formulia is the last cell you wish to add together and
that would be in celld15 where you put the formulia

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Rick Mladek
Sent: January 13, 2020 5:48
To: main@jfw.groups.io
Subject: Re: MS EXCEL formula

Hi Ann, maybe I need more coffee as well. I'm lost and I must admit... can
you give me the formulas and steps for columns D and E with the starting
line of information/numbers being row 14 with row 13 blank.

Thank you and I am sorry...

Rick

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Monday, January 13, 2020 7:33 AM
To: main@jfw.groups.io
Subject: Re: MS EXCEL formula

Hi, Rick,

Assuming the following formula in E14:
=e13+d14.
E13 should have your beginning balance, which would be 0 (Excel assumes a
blank is 0).
D14 should have the first number you want to add to the beginning balance,
e.g. 10.
So. the number in e14 (e13+d14) should be 10.
Copying/pasting the formula into f15, it should read =e14+D15.
So. E14 is 10, as calculated above; +d15 which is the next number you are
adding, say 32. E15 should equal 42.
And it carries on down, incrementing as you go.

Make sense? Only one cup of coffee so far, so if it doesn't I will drink
more and try to explain it better.

moderated Re: MS EXCEL formula

Van Lant, Robin

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 <main@jfw.groups.io> On Behalf Of Richard Turner
Sent: Sunday, January 12, 2020 10:55 PM
To: 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

﻿

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.

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.

Mario

a friend of my sister is looking to get back in to using JAWS with
Windows 10, but I'm not sure if she's several versions behind or never
used JAWS before. if I tell her if she can wait til the FS/VFO S&S
summer special, would she be able to save quite a bit on a first time
purchase if she never used JAWS before?

how would one know if there is going to be a special, and when will the
upcoming special begin?

-------- Original Message --------
From: Edward Green [mailto:ergreen1981@gmail.com]
To: main@jfw.groups.io
Date: Monday, January 13, 2020, 3:07 AM
Hi Alison,

If you can hang on, I'd wait for the Freedom Scientific/VFO/Sight and
Sound summer special, and buy a new JAWS licence outright. This is
likely to be significantly cheaper if previous years' pricing is
anything to go by.

Cheers,

Ed

On 12 Jan 2020, at 17:55, Vaughn Brown <jazzdressage@gmail.com> wrote:

﻿I second Richard on all accounts.
Did you try cleaning between the keys? I use a small amount of rubbing
alcohol as it evaporates after a short time and will not damage any
sticky areas.
I am using JAWS 2020 and enjoy it. I did the \$90/year subscription.
Again, your situation with JAWS is based on affordability.
Hope this helps.
Vaughn

On 1/12/20, Richard Turner <richardturner42@outlook.com> wrote:
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
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@gmail.com> 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

--
Kindly,
Vaughn Brown
Vaughn's Percussionship
Heal through Feel Equine Massage
360-904-8432
http://www.vaughnbrown.net
Serving Clark County

.

moderated Re: latest Jaws and emails reading as tables

Thanks, Tom. I’m afraid that turns out to be the displayed setting, so any solution for my email tables problem lies elsewhere.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of tom x
Sent: Monday, January 13, 2020 1:30 AM
To: main@jfw.groups.io
Subject: Re: latest Jaws and emails reading as tables

To locate the default section, do the following from the Desktop:

Press insert j and then arrow down to utilities and press enter

Press e for the settings centre

Check the top of the text to see if the settings relate to default.

Tab down to  web/html/pdfs and press the right arrow to open.

Arrow down to tables and press right arrow to open.

Make sure

Table presentation information for data tables only.

Is displayed and not for all tables. press spacebar to alter if necessary.

Tab down to the OK button to save.

Hope this helps.

Tom

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Adrian Spratt
Sent: Sunday, 12 January 2020 10:19 PM
To: main@jfw.groups.io
Subject: Re: latest Jaws and emails reading as tables

Tom, where is the “default settings section”? I’m still having the problem, and I’m hoping your solution will also be mine. Thanks.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of tom x
Sent: Sunday, January 12, 2020 2:44 AM
To: main@jfw.groups.io
Subject: Re: latest Jaws and emails reading as tables

Hi,

Thanks to all those who answered my query regarding jaws reading some  emails as tables.

The problem now seems to have been fixed after changing all tables to data tables in the default settings section.

Cheers

Tom

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Adrian Spratt
Sent: Friday, 10 January 2020 2:54 PM
To: main@jfw.groups.io
Subject: Re: latest Jaws and emails reading as tables

Tom,

You have to be very specific in how you search for this item, as follows:

Open an email message in Outlook and place focus in it. The “Layout table” item won’t appear otherwise.

Press JAWS key+v.

An edit field appears.

Type the six letters t a b l e s.

Now press enter.

Arrow down until JAWS verbalizes “Layout table, ignore.”

Once there, press the spacebar to cycle between checked or unchecked. You want the item checked.

I hope it makes a difference on your system. Sadly, it hasn’t on mine.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of tom x
Sent: Thursday, January 9, 2020 11:15 PM
To: main@jfw.groups.io
Subject: Re: latest Jaws and emails reading as tables

Unfortunately I was unable to locate anything using the term, “layout tables”in the Jaws quick settings.

Tom

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Cohn, Jonathan
Sent: Wednesday, 8 January 2020 6:17 AM
To: main@jfw.groups.io
Subject: Re: latest Jaws and emails reading as tables

First off verify that you have "layout" tables ignored  in your JAWS quick settings.  Also, there is aa Outlook function to "View in Browser", this used to be in the ribbon, but it seems to be hidden these days, and if activated warns you that the Browser is has a different security configuration from Outlook. You can add it into the Quick Access Bar if you think it would be useful.

Hopefully one of these will help,
Jonathan

moderated Re: MS EXCEL formula

Hi Ann, maybe I need more coffee as well. I'm lost and I must admit... can
you give me the formulas and steps for columns D and E with the starting
line of information/numbers being row 14 with row 13 blank.

Thank you and I am sorry...

Rick

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Monday, January 13, 2020 7:33 AM
To: main@jfw.groups.io
Subject: Re: MS EXCEL formula

Hi, Rick,

Assuming the following formula in E14:
=e13+d14.
E13 should have your beginning balance, which would be 0 (Excel assumes a
blank is 0).
D14 should have the first number you want to add to the beginning balance,
e.g. 10.
So. the number in e14 (e13+d14) should be 10.
Copying/pasting the formula into f15, it should read =e14+D15.
So. E14 is 10, as calculated above; +d15 which is the next number you are
adding, say 32. E15 should equal 42.
And it carries on down, incrementing as you go.

Make sense? Only one cup of coffee so far, so if it doesn't I will drink
more and try to explain it better.

moderated Re: MS EXCEL formula

Richard, what is added is not important. I am adding numbers from one row, down the column, purely basic/simple...

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard Turner
Sent: Monday, January 13, 2020 7:22 AM
To: main@jfw.groups.io
Subject: Re: MS EXCEL formula

Rick,

What are you adding together to get the running total?

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

﻿Good morning Ann,

Looking over your directions, now that I am alert, I have a question...

=d14+e13.  This should display the number in d14.

What do you mean by it should display the number in d14? The cost/amount is
in the D column beginning on row 14. The running sum/total needs displayed
down the E column. Is this how it will appear with the directions given?

Thank you,

Rick

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Sunday, January 12, 2020 10:55 PM
To: main@jfw.groups.io
Subject: Re: MS EXCEL formula

The first instance of the formula would be in e14, right?

then.  With e13 blank, this would be the formula:
=d14+e13.  This should display the number in d14.

To propagate the formula down the page:

So.  Copy the formula in e14.
Then Ctrl+g (go to).
Type in the cells you want to hold the formula (e15:e100) and enter.
The cells will be selected.
Paste the formula ctrl+v.
that should do it.

good luck!

moderated Re: MS EXCEL formula

Ann Byrne

Hi, Rick,

Assuming the following formula in E14:
=e13+d14.
E13 should have your beginning balance, which would be 0 (Excel assumes a blank is 0).
D14 should have the first number you want to add to the beginning balance, e.g. 10.
So. the number in e14 (e13+d14) should be 10.
Copying/pasting the formula into f15, it should read
=e14+D15.
So. E14 is 10, as calculated above; +d15 which is the next number you are adding, say 32. E15 should equal 42.
And it carries on down, incrementing as you go.

Make sense? Only one cup of coffee so far, so if it doesn't I will drink more and try to explain it better.

moderated Re: MS EXCEL formula

Richard Turner

Rick,
What are you adding together to get the running total?

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

﻿Good morning Ann,

Looking over your directions, now that I am alert, I have a question...

=d14+e13.  This should display the number in d14.

What do you mean by it should display the number in d14? The cost/amount is
in the D column beginning on row 14. The running sum/total needs displayed
down the E column. Is this how it will appear with the directions given?

Thank you,

Rick

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Sunday, January 12, 2020 10:55 PM
To: main@jfw.groups.io
Subject: Re: MS EXCEL formula

The first instance of the formula would be in e14, right?

then.  With e13 blank, this would be the formula:
=d14+e13.  This should display the number in d14.

To propagate the formula down the page:

So.  Copy the formula in e14.
Then Ctrl+g (go to).
Type in the cells you want to hold the formula (e15:e100) and enter.
The cells will be selected.
Paste the formula ctrl+v.
that should do it.

good luck!

moderated Re: MS EXCEL formula

Good morning Ann,

Looking over your directions, now that I am alert, I have a question...

=d14+e13. This should display the number in d14.

What do you mean by it should display the number in d14? The cost/amount is
in the D column beginning on row 14. The running sum/total needs displayed
down the E column. Is this how it will appear with the directions given?

Thank you,

Rick

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Ann Byrne
Sent: Sunday, January 12, 2020 10:55 PM
To: main@jfw.groups.io
Subject: Re: MS EXCEL formula

The first instance of the formula would be in e14, right?

then. With e13 blank, this would be the formula:
=d14+e13. This should display the number in d14.

To propagate the formula down the page:

So. Copy the formula in e14.
Then Ctrl+g (go to).
Type in the cells you want to hold the formula (e15:e100) and enter.
The cells will be selected.
Paste the formula ctrl+v.
that should do it.

good luck!

CJ &AA MAY

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

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

 11161 - 11180 of 85808
More