moderated Re: Excel Formula

Russell Solowoniuk

Hi Richard,

I see no difference in my steps and yours? :)

Thanks,

Russell

On Jun 26, 2019, at 10:02 AM, Richard Turner <richardturner42@...> wrote:

I’m not sure why Russell’s instructions didn’t work for me, but I did the following and it worked.
In b101: =COUNTIF(B2:B100,"Yes")
IN b102, =COUNTA(B2:B100)
In b103, =B101/B102

To test this, I put a Yes in b2 and No in b100.
I got 1 as the result of yes’s, 2 in the result for number of cells with data in b102, and .50 in b103 which then switching the number type to percent, got 50.00.  I did not bother changing the decimal places from the default.

HTH,
Richard

Check out my web site at: www.turner42.com
“The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying.  There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." --Douglas Adams, from Life, The Universe and Everything, p.59

From: main@jfw.groups.io<main@jfw.groups.io> On Behalf Of Russell Solowoniuk
Sent: Wednesday, June 26, 2019 7:53 AM
To: main@jfw.groups.io
Subject: Re: Excel Formula

Hi Steve,

Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula,
CountIf(B2:B100,”Yes”).
This will give you the number of cells with “Yes” in them.
Then, in B102, or whoever you wish, type the formula,
=CountA(B2:B100)
Note the letter “A” after “Count” in the above formula.
This will give you the total number of cells in column B that have data.
Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula,
=B101/B102
You are dividing the number of “Yes” by the total number of cells with data.
You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK.

Hope this helps.

Russell

On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@...> wrote:

Hi All,

Using Excel 2016, Windows 10 and the current version of JAWS.  I have an Excel sheet in column A I have the task a person must perform.  In Column B I will answer yes or no if they can perform the task.  Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions.  I would greatly appreciate your assistance!

Steve

moderated Re: Excel Formula

Richard Turner

I’m not sure why Russell’s instructions didn’t work for me, but I did the following and it worked.

In b101: =COUNTIF(B2:B100,"Yes")

IN b102, =COUNTA(B2:B100)

In b103, =B101/B102

To test this, I put a Yes in b2 and No in b100.

I got 1 as the result of yes’s, 2 in the result for number of cells with data in b102, and .50 in b103 which then switching the number type to percent, got 50.00.  I did not bother changing the decimal places from the default.

HTH,

Richard

Check out my web site at: www.turner42.com

“The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying.  There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." --Douglas Adams, from Life, The Universe and Everything, p.59

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk
Sent: Wednesday, June 26, 2019 7:53 AM
To: main@jfw.groups.io
Subject: Re: Excel Formula

Hi Steve,

Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula,

CountIf(B2:B100,”Yes”).

This will give you the number of cells with “Yes” in them.

Then, in B102, or whoever you wish, type the formula,

=CountA(B2:B100)

Note the letter “A” after “Count” in the above formula.

This will give you the total number of cells in column B that have data.

Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula,

=B101/B102

You are dividing the number of “Yes” by the total number of cells with data.

You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK.

Hope this helps.

Russell

On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@...> wrote:

Hi All,

Using Excel 2016, Windows 10 and the current version of JAWS.  I have an Excel sheet in column A I have the task a person must perform.  In Column B I will answer yes or no if they can perform the task.  Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions.  I would greatly appreciate your assistance!

Steve

moderated Re: Excel Formula

Van Lant, Robin

I agree with Russell’s approach.  That is exactly how I would do it.  Technically you can combine both of the formulas into one cell, but I tend to like to show the results of each count in a different cell.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Russell Solowoniuk
Sent: Wednesday, June 26, 2019 8:53 AM
To: main@jfw.groups.io
Subject: Re: Excel Formula

Hi Steve,

Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula,

CountIf(B2:B100,”Yes”).

This will give you the number of cells with “Yes” in them.

Then, in B102, or whoever you wish, type the formula,

=CountA(B2:B100)

Note the letter “A” after “Count” in the above formula.

This will give you the total number of cells in column B that have data.

Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula,

=B101/B102

You are dividing the number of “Yes” by the total number of cells with data.

You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK.

Hope this helps.

Russell

On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@...> wrote:

Hi All,

Using Excel 2016, Windows 10 and the current version of JAWS.  I have an Excel sheet in column A I have the task a person must perform.  In Column B I will answer yes or no if they can perform the task.  Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions.  I would greatly appreciate your assistance!

Steve

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 Using Skype

Justin Mcdevitt

Hello List-members,

I have scheduled a training session (via Skype) with a BrailleNote user for tomorrow to provide some training in using the Apex which I recently purchased, primarily as a Notetaker. I am reaching out to the list to request some assistance with using Skype, a program that I haven’t used in a number of years.

I have set up a Skype account and downloaded the Windows 10 desktop version of Skype and reviewed the JAWS/Skype keyboard commands.

What I would appreciate is the opportunity to review some of these commands and get some direction in adding a contact and setting up a Skype session to participate in this Apex training, again scheduled for tomorrow.

If anyone, who is familiar with Skype has some time today to provide some direction, I would appreciate it. Please contact me offlist: jhmcdev@....

Best, Justin .

moderated Re: Excel Formula

Russell Solowoniuk

Hi Steve,

Let’s say you have Yes or no in cells B2 to B100. In cell B101, or wherever you wish, type the formula,
CountIf(B2:B100,”Yes”).
This will give you the number of cells with “Yes” in them.
Then, in B102, or whoever you wish, type the formula,
=CountA(B2:B100)
Note the letter “A” after “Count” in the above formula.
This will give you the total number of cells in column B that have data.
Now, to calculate the percentage of cells with “Yes” in them, in cell B103, or wherever, type the formula,
=B101/B102
You are dividing the number of “Yes” by the total number of cells with data.
You will get a number like 0.67 or something like that. Press CTRL + 1 while in that cell and change the number formatting to Percentage, choose the number of decimal places you wish to show, and tab to OK.

Hope this helps.

Russell

On Jun 25, 2019, at 5:17 PM, Steve & Shannon Cook <cookcafe@...> wrote:

Hi All,

Using Excel 2016, Windows 10 and the current version of JAWS.  I have an Excel sheet in column A I have the task a person must perform.  In Column B I will answer yes or no if they can perform the task.  Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions.  I would greatly appreciate your assistance!

Steve

moderated Netflix keyboard navigation with JAWS.

Tim Ford

Can anyone provide a list of the video navigation commands I can use to operate a Netflix video?  I managed to figure out somehow to pause and play. But I find no links or buttons of any kind.  Any hints are much appreciated!

Tim Ford

moderated Re: Is there a group for accessibility issues regarding Wordpress?

Rayn Darren

Hi Richard,

I don't have the answer to your question directly Richard, however, i use WordPress daily for my clients and would be happy to answer questions you have.

Thanks,

Sarah

On 6/25/2019 10:23 AM, Richard B. McDonald wrote:

Hi!

At wordpress.com, there is an accessibility support group.  However, I have found it nonresponsive and inactive.  So, I am wondering if there is some other support group for accessibility issues such as using a screen reader with WordPress?

Thanks,

Richard

moderated Fire fox Tutorial

Kevin Stone <kevinstone65@...>

Does anyone know of a tutorial for fire fox?  Thanks in advance

Kevin Stone

moderated Re: Is there a group for accessibility issues regarding Wordpress?

Randy Barnett

It is still active but very low traffic.

On 6/25/2019 12:12 PM, The Iowa Gal wrote:

Not sure if this list is still active, but you can try

This is from a post I saved from another list, Word Press was mentioned as a topic which has been discussed there.

HTH

Norma

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of James Homuth
Sent: Tuesday, June 25, 2019 1:14 PM
To: main@jfw.groups.io
Subject: Re: Is there a group for accessibility issues regarding Wordpress?

As far as I’m aware there isn’t, but if it’s an issue particular to JAWS you can always bring it up on this list. Plenty of Wordpress users here.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard B. McDonald
Sent: June-25-19 1:24 PM
To: jfw@groups.io
Subject: Is there a group for accessibility issues regarding Wordpress?

Hi!

At wordpress.com, there is an accessibility support group.  However, I have found it nonresponsive and inactive.  So, I am wondering if there is some other support group for accessibility issues such as using a screen reader with WordPress?

Thanks,

Richard

moderated Re: Excel Formula

Tanguy LOHEAC

Hi Steve,

Sorry, i'm French, then I don't know exact function names in English. But i'll try to guide to the right path:

To get the number of "yes" from column B the formula is something like that

=nb.if(b2:b10;"yes") where b2:b10 is the range of rows you want to sum and "yes" is what you want to sum.

Then, to get the total number of tasks that are in column A this is:

=sub.total(3;a:a)-1 : here i'm not sure about the name but you may find it from the Math category.

Then fi you want a percentage this is first divided by second as follows:

=nb.if(b2:b10;"yes") / (sub.total(3;a:a)-1)

Hope that helps anyway

Tanguy

Le 26/06/2019 à 01:17, Steve & Shannon Cook a écrit :

Hi All,

Using Excel 2016, Windows 10 and the current version of JAWS.  I have an Excel sheet in column A I have the task a person must perform.  In Column B I will answer yes or no if they can perform the task.  Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions.  I would greatly appreciate your assistance!

Steve

--
 Didactiweb - les formations adaptées aux déficients visuels Tanguy Lohéac Cofondateur et Responsable technique 06 20 23 77 26 tanguy.loheac@...

 Garanti sans virus. www.avast.com

moderated Excel Formula

Steve & Shannon Cook <cookcafe@...>

Hi All,

Using Excel 2016, Windows 10 and the current version of JAWS.  I have an Excel sheet in column A I have the task a person must perform.  In Column B I will answer yes or no if they can perform the task.  Here is my issue, I want to create a formula at the bottom of column B to determine if they answered yes to 80% of the questions.  I would greatly appreciate your assistance!

Steve

moderated Re: dropbox and accessibility

Bill White

Hi, Jed. Make sure your Dropbox folder hasn't switched to Tiles View. Try left and right arrows and see if it gives you your file listing.

Bill White
billwhite92701@...

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Jed Barton
Sent: Tuesday, June 25, 2019 10:33 AM
To: main
Subject: dropbox and accessibility

Hey guys,

OK, so has dropbox gone to not being accessible? The app seems to
have changed completely. I can't seem ot arrow down through y files.
I'm using the latest jaws. Can someone help?

Cheers,

Jed

moderated Re: Is there a group for accessibility issues regarding Wordpress?

David & his pack of dogs

Contact Mystic access. They have a word press group that deals with issues.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of James Homuth
Sent: June 25, 2019 11:14 AM
To: main@jfw.groups.io
Subject: Re: Is there a group for accessibility issues regarding Wordpress?

As far as I’m aware there isn’t, but if it’s an issue particular to JAWS you can always bring it up on this list. Plenty of Wordpress users here.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard B. McDonald
Sent: June-25-19 1:24 PM
To: jfw@groups.io
Subject: Is there a group for accessibility issues regarding Wordpress?

Hi!

At wordpress.com, there is an accessibility support group.  However, I have found it nonresponsive and inactive.  So, I am wondering if there is some other support group for accessibility issues such as using a screen reader with WordPress?

Thanks,

Richard

moderated Re: dropbox and accessibility

CJ &AA MAY

Me too.
Alison

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Dean Martineau
Sent: 25 June 2019 18:44
To: main@jfw.groups.io
Subject: Re: dropbox and accessibility

I use File Explorer to access the Dropbox folder and it works fine still.

Dean

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Jed Barton
Sent: Tuesday, June 25, 2019 1:33 PM
To: main <main@jfw.groups.io>
Subject: dropbox and accessibility

Hey guys,

OK, so has dropbox gone to not being accessible? The app seems to have changed completely. I can't seem ot arrow down through y files.
I'm using the latest jaws. Can someone help?

Cheers,

Jed

Shirley Tracy

Thanks, Dan:

Yes, I have a Dell desktop. The notice finally went away when I rebooted.

Shirley Tracy

From: Dan Longmore
Sent: Tuesday, June 25, 2019 12:31 PM
To: main@jfw.groups.io

I have a Dell laptop, get the same issue, actually there is nothing on the screen and nothing to clear. We both always takes this away and it has something to do with Dell proprietary software.

From: main@jfw.groups.io on behalf of Shirley Tracy <shirleytracy16@...>
Sent: Tuesday, June 25, 2019 10:35 AM
To: main@jfw.groups.io

Thanks for any help.

Shirley Tracy

From: Richard Turner
Sent: Tuesday, June 25, 2019 9:44 AM
To: main@jfw.groups.io
Subject: Re: Marking text.

Are you talking just marking to then copy, or cut?

Those keystrokes also work on the web and you follow the insert+space m with the copy command, control+c, etc.

Richard

Check out my web site at: www.turner42.com

“The Hitch Hiker's Guide to the Galaxy has this to say on the subject of flying.  There is an art, it says, or rather, a knack to flying. The knack lies in learning how to throw yourself at the ground and miss." --Douglas Adams, from Life, The Universe and Everything, p.59

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

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Dean Martineau

Sent: Tuesday, June 25, 2019 4:26 AM

To: main@jfw.groups.io

Subject: Re: Marking text.

Yes, you can use JAWS commands to mark blocks of text. All screen readers have this capability now.

In the forthcoming book Windows Keyboard Power User Guide, which should actually finally appear in the next couple weeks, I show you how to create a better set of keystrokes to do this, but until then:

Go to the beginning of the block you want to set and press ctrl+windows+K.

Go to the end of the block and press Jawskey+space, M.

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

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of lists@...

Sent: Tuesday, June 25, 2019 6:46 AM

To: main@jfw.groups.io

Subject: Marking text.

Hi all.

Can anyone tell me, if the beginning and end of a block of text, can be marked using Jaws only? Using Microsoft word.

Many thanks.

Brian.

moderated Re: Is there a group for accessibility issues regarding Wordpress?

The Iowa Gal <iowagal728@...>

Not sure if this list is still active, but you can try

This is from a post I saved from another list, Word Press was mentioned as a topic which has been discussed there.

HTH

Norma

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of James Homuth
Sent: Tuesday, June 25, 2019 1:14 PM
To: main@jfw.groups.io
Subject: Re: Is there a group for accessibility issues regarding Wordpress?

As far as I’m aware there isn’t, but if it’s an issue particular to JAWS you can always bring it up on this list. Plenty of Wordpress users here.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard B. McDonald
Sent: June-25-19 1:24 PM
To: jfw@groups.io
Subject: Is there a group for accessibility issues regarding Wordpress?

Hi!

At wordpress.com, there is an accessibility support group.  However, I have found it nonresponsive and inactive.  So, I am wondering if there is some other support group for accessibility issues such as using a screen reader with WordPress?

Thanks,

Richard

moderated Re: Jaws Not Speaking in MS Word

Randy Meyer

I found an Intel video driver update was stuck in my windows 10 update.  Once I was able to install that video driver update, word and Jaws started behaving properly.

Thank you for the suggestion of doing a restore.

Randy Meyer

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of The Iowa Gal
Sent: Tuesday, June 25, 2019 12:14 AM
To: main@jfw.groups.io
Subject: Re: Jaws Not Speaking in MS Word

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Randy Meyer
Sent: Monday, June 24, 2019 8:47 PM
To: main@jfw.groups.io
Subject: Jaws Not Speaking in MS Word

Suddenly Jaws stopped working correctly in MS Word and now in Outlook as well.

It will not speak when moving by line, word, or character.  Insert down arrow does seem to read the document, but obviously I am not able to edit a document with it not speaking by line, word, or character.  I am running the latest version of Jaws and windows 10 pro.  I have had this happen occasionally in the past, but a restart of Jaws or the computer has always solved the issue until tonight.

Does anyone have any thoughts?

Randy Meyer

moderated Re: Is there a group for accessibility issues regarding Wordpress?

James Homuth

As far as I’m aware there isn’t, but if it’s an issue particular to JAWS you can always bring it up on this list. Plenty of Wordpress users here.

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Richard B. McDonald
Sent: June-25-19 1:24 PM
To: jfw@groups.io
Subject: Is there a group for accessibility issues regarding Wordpress?

Hi!

At wordpress.com, there is an accessibility support group.  However, I have found it nonresponsive and inactive.  So, I am wondering if there is some other support group for accessibility issues such as using a screen reader with WordPress?

Thanks,

Richard

moderated Re: Marking text.

Brian D

Thanks very much for that.

Brian.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Dean Martineau
Sent: Tuesday 25 June 2019 12:26
To: main@jfw.groups.io
Subject: Re: Marking text.

Yes, you can use JAWS commands to mark blocks of text. All screen readers have this capability now.

In the forthcoming book Windows Keyboard Power User Guide, which should actually finally appear in the next couple weeks, I show you how to create a better set of keystrokes to do this, but until then:

Go to the beginning of the block you want to set and press ctrl+windows+K.

Go to the end of the block and press Jawskey+space, M.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of lists@...
Sent: Tuesday, June 25, 2019 6:46 AM
To: main@jfw.groups.io
Subject: Marking text.

Hi all.

Can anyone tell me, if the beginning and end of a block of text, can be marked using Jaws only? Using Microsoft word.

Many thanks.

Brian.

moderated Re: dropbox and accessibility

Dean Martineau <topdot@...>

I use File Explorer to access the Dropbox folder and it works fine still.

Dean

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Jed Barton
Sent: Tuesday, June 25, 2019 1:33 PM
To: main <main@jfw.groups.io>
Subject: dropbox and accessibility

Hey guys,

OK, so has dropbox gone to not being accessible? The app seems to
have changed completely. I can't seem ot arrow down through y files.
I'm using the latest jaws. Can someone help?

Cheers,

Jed