Date   

moderated Re: File find in windows 10 with jaws 2018, looking for content not the names of files

 

On Tue, May 15, 2018 at 07:01 am, mike mcglashon wrote:

What if I wanted to search an entire folder with mixed filetypes in it,

Would I type:

“*.*:mike” to find “mike” in any file located within the current folder that is open?

Assuming the folder is indexed (and see the message from David Bailes in regard to that) the answer to your question is, "No."  All you need to do is to type mike (no quotes needed) in the search box of File Explorer.  

The following is taken directly from one of my standard Cheat Sheets that I use when tutoring JAWS and Windows:

Using Windows Search

          Windows can search for files or folders with a certain name or it can search for files and folders not only with that certain name, but that contain that name (or word).

1.     Hit the Windows Key.

2.     If you only want to find files or folders with a given name, then type file: immediately followed by the name, or part of that name, that you’re searching for.

3.     If you want to find files or folders that contain a word or phrase

a.     If it’s a phrase, enclose the phrase in quotation marks

b.     If it’s a single word you don’t need the quotation marks

4.     Hit the Down Arrow twice to begin reviewing the search results.

 
--

Brian - Windows 10 Home, 64-Bit, Version 1803, Build 17134  

     Travel is fatal to prejudice, bigotry, and narrow-mindedness, and many of our people need it sorely on these accounts. Broad, wholesome, charitable views of men and things cannot be acquired by vegetating in one little corner of the earth all one's lifetime.

         ~ Mark Twain


moderated Re: A free secure file eraser

Steve Matzura
 

I haven't tried all of these, but since they're all free, maybe someone else will.

https://www.lifewire.com/free-file-shredder-software-programs-2619149

ERASER has always been my fave, but WIPEFILE is good, too.


On 5/16/2018 7:37 AM, Nino Dagostino wrote:

Good morning

Does anybody know of a free program that will erase files securely that works good with Jaws?

 

Thank you.

 

 



moderated Re: File find in windows 10 with jaws 2018, looking for content not the names of files

David Bailes
 

Hi Mike,
I'm assuming that because you said that you want to search an entire folder, that you're using File Explorer (or Windows Explorer on Windows 7) to search, rather than using the start menu.

If the contents of the folder are indexed, then to find the word mike in one of the usual types of file that contains text, you should be able to just type the word mike.
By default, all the folders in your personal folder are indexed.
If the folder isn't in your folder, and hence not indexed, and you want to search for contents, then your options include:
1. In Indexing Options in the control panel, set the folder to be indexed.
2. Instead of typing mike, type content:mike. This may be quite slow, as it has to seach contents which are not indexed.

David.


On Tue, May 15, 2018 at 07:01 am, mike mcglashon wrote:

What if I wanted to search an entire folder with mixed filetypes in it,

Would I type:

“*.*:mike” to find “mike” in any file located within the current folder that is open?

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Steve Nutt
Sent: Monday, May 14, 2018 5:10 PM
To: main@jfw.groups.io
Subject: Re: File find in windows 10 with jaws 2018, looking for content not the names of files

 

Hi David,

 

Or you could type Doc: before your search term  So if you were looking for “David”, and typed “doc:David”, it would only search in documents.  No tabbing, just remembering three characters.

 

If you want to do the reverse and look for files by name, rather than content, then file: is your friend.

 

All the best


Steve

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of David Bailes
Sent: 09 May 2018 09:39
To: main@jfw.groups.io
Subject: Re: File find in windows 10 with jaws 2018, looking for content not the names of files

 

Hi John,
assuming that the files are somewhere in your personal folder, you can do this from the search box in the start menu. Normally when you search for files using the start menu, it only searches the names of files. However, if you filter the search results for documents, then the contents are searched as well. To do this:
1. In the search box, type in a word or phrase as normal.
2. Tab twice to move to the filters list, which is laid out as a row of items.
3. Press right arrow to move to find results in documents, and press enter. The focus returns to the search box, and Jaws reads out the first item in the filtered list of results.

David.

On Tue, May 8, 2018 at 03:40 am, John J. Fioravanti, Jr. wrote:

How can I find files in windows 10 by their content and not just their names.  

Thank you.

 


moderated A free secure file eraser

Nino Dagostino
 

Good morning

Does anybody know of a free program that will erase files securely that works good with Jaws?

 

Thank you.

 

 


moderated Email inbox

Nino Dagostino
 

Thank you so mutch, you have come up with some wonderful ideas.

 

I truly thank you “smile”

 

I have saved all of your ideas.

 

 


moderated Re: Trouble changing my email on the list subscription

Bill White <billwhite92701@...>
 

What email address are you trying to unsubscribe at? It should be:

 

jfw+unsubscribe@groups.io

 

Then resubscribe from the new address at:

 

jfw+subscribe@groups.io

 

Bill White

billwhite92701@...

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Gudrun Brunot
Sent: Tuesday, May 15, 2018 6:06 PM
To: main@jfw.groups.io
Subject: Trouble changing my email on the list subscription

 

Hi: I’ve tried sending a request to unsubscribe me from the list under

gbrunot@...

and subscribe instead under

brunotgudrun@...

 

but I get a message saying that message is undeliverable.

 

Please advise.

 

Gudrun


moderated Trouble changing my email on the list subscription

Gudrun Brunot
 

Hi: I’ve tried sending a request to unsubscribe me from the list under

gbrunot@...

and subscribe instead under

brunotgudrun@...

 

but I get a message saying that message is undeliverable.

 

Please advise.

 

Gudrun


moderated Re: Email inbox

Van Lant, Robin
 

Oh, and one more idea I have used.  If you have an email or task that you want to work on at a particular date or time, you can add it to your calendar.  There are two good keyboard ways to do this.

 

From the message or task list, open the context menu and select the “Quick Step” option, which opens a submenu.  The second option down is to create an appointment with the text of the email.  Selecting this will do exactly what it says, placing focus in the subject line of the appointment, where you can then set the date, time and location of your calendar entry.    The only downside to this method is that it populates the body of the email, not the email header, so you may want to note the person the email was from and the date of the message in your subject or at the top of the body of the appointment. 

 

Another trick I learned is that you can create an appointment with what is on your clipboard. So, if you have a message open and want to add it to your calendar, used Control A to select the text of the message, then control c to put it on the clipboard.  Go to your calendar using Control number row 2 and then hit Control V to paste.  This will open an appointment with the clipboard contents in the body of the appointment and your focus will be at the subject line where you can title the appointment, then tab to add date, time and location.  This trick works with anything else you have on your office clipboard, such as a paragraph you copied from a Word document. 

 

Office really has some neat tricks.  When I first got Office 2010 at work, I listen to a number of short training videos that offered really cool tricks for dragging and dropping items across calendars and inboxes.  While it was all visually based, it’s been nice to learn how to make use of some of these features with the keyboard. 

 

 

 

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Dan Longmore
Sent: Tuesday, May 15, 2018 3:37 PM
To: main@jfw.groups.io
Subject: Re: Email inbox

 

I never used follow up in this way, great tip for us all.

Dan

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Van Lant, Robin via Groups.Io
Sent: Tuesday, May 15, 2018 1:28 PM
To: main@jfw.groups.io
Subject: Re: Email inbox

 

Just another option, if you are using Outlook.  If I  have an email I want to follow-up on later, I do the following:

Within the Outlook inbox, I highlight the message. I then use the context key to open the menu and select the follow-up option, which opens a sub-menu of choices.  The choices range from tomorrow, to next week, to a custom option where  you can type in the date.  Flagged messages are then noted by subject line on the Task List, which you get to with Control number row 4.  Since I already use the Task List for other reminders, it’s all in one place.  I also use this method if I have sent someone an email and I want to be sure I get a reply by a certain date.  I believe you can do the same thing in Contacts if you want to remember to follow-up with a person at some point.

 

 

 

 

 

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino
Sent: Tuesday, May 15, 2018 1:07 AM
To: main@jfw.groups.io
Subject: Re: Email inbox

 

Thank you for everyones help.

 

The (f12) key works perfectly.

 

Thanks again

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Bill White
Sent: Monday, May 14, 2018 11:30 AM
To: main@jfw.groups.io
Subject: Re: Email inbox

 

Hi, Nino. If I have an email which I know I will want to act on in the future, and know it may be difficult to find, here’s what I do. I use F12 to save the email as a file. Once it saves, the name resembles the subject line, and it is usually saved as a file in Documents with an .msg extension. If you click on the file, it opens outlook, and you are in the body of the email you saved. You can do all the things you can normally do with an email, including, reply, forward, etc.

 

Bill White

billwhite92701@...

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino
Sent: Monday, May 14, 2018 4:24 AM
To: main@jfw.groups.io
Subject: Email inbox

 

Hi:

 

I was wondering if anybody new how to move the posission of an email that is quite far down on the lists of emails in the inbox.

 

Is there a way to move that message further up in the list of emails?

 

I hope I explained it properly.

 

 



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: Email inbox

Dan Longmore
 

I never used follow up in this way, great tip for us all.

Dan

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Van Lant, Robin via Groups.Io
Sent: Tuesday, May 15, 2018 1:28 PM
To: main@jfw.groups.io
Subject: Re: Email inbox

 

Just another option, if you are using Outlook.  If I  have an email I want to follow-up on later, I do the following:

Within the Outlook inbox, I highlight the message. I then use the context key to open the menu and select the follow-up option, which opens a sub-menu of choices.  The choices range from tomorrow, to next week, to a custom option where  you can type in the date.  Flagged messages are then noted by subject line on the Task List, which you get to with Control number row 4.  Since I already use the Task List for other reminders, it’s all in one place.  I also use this method if I have sent someone an email and I want to be sure I get a reply by a certain date.  I believe you can do the same thing in Contacts if you want to remember to follow-up with a person at some point.

 

 

 

 

 

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino
Sent: Tuesday, May 15, 2018 1:07 AM
To: main@jfw.groups.io
Subject: Re: Email inbox

 

Thank you for everyones help.

 

The (f12) key works perfectly.

 

Thanks again

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Bill White
Sent: Monday, May 14, 2018 11:30 AM
To: main@jfw.groups.io
Subject: Re: Email inbox

 

Hi, Nino. If I have an email which I know I will want to act on in the future, and know it may be difficult to find, here’s what I do. I use F12 to save the email as a file. Once it saves, the name resembles the subject line, and it is usually saved as a file in Documents with an .msg extension. If you click on the file, it opens outlook, and you are in the body of the email you saved. You can do all the things you can normally do with an email, including, reply, forward, etc.

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino
Sent: Monday, May 14, 2018 4:24 AM
To: main@jfw.groups.io
Subject: Email inbox

 

Hi:

 

I was wondering if anybody new how to move the posission of an email that is quite far down on the lists of emails in the inbox.

 

Is there a way to move that message further up in the list of emails?

 

I hope I explained it properly.

 

 



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: Email inbox

Van Lant, Robin
 

Just another option, if you are using Outlook.  If I  have an email I want to follow-up on later, I do the following:

Within the Outlook inbox, I highlight the message. I then use the context key to open the menu and select the follow-up option, which opens a sub-menu of choices.  The choices range from tomorrow, to next week, to a custom option where  you can type in the date.  Flagged messages are then noted by subject line on the Task List, which you get to with Control number row 4.  Since I already use the Task List for other reminders, it’s all in one place.  I also use this method if I have sent someone an email and I want to be sure I get a reply by a certain date.  I believe you can do the same thing in Contacts if you want to remember to follow-up with a person at some point.

 

 

 

 

 

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino
Sent: Tuesday, May 15, 2018 1:07 AM
To: main@jfw.groups.io
Subject: Re: Email inbox

 

Thank you for everyones help.

 

The (f12) key works perfectly.

 

Thanks again

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Bill White
Sent: Monday, May 14, 2018 11:30 AM
To: main@jfw.groups.io
Subject: Re: Email inbox

 

Hi, Nino. If I have an email which I know I will want to act on in the future, and know it may be difficult to find, here’s what I do. I use F12 to save the email as a file. Once it saves, the name resembles the subject line, and it is usually saved as a file in Documents with an .msg extension. If you click on the file, it opens outlook, and you are in the body of the email you saved. You can do all the things you can normally do with an email, including, reply, forward, etc.

 

Bill White

billwhite92701@...

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino
Sent: Monday, May 14, 2018 4:24 AM
To: main@jfw.groups.io
Subject: Email inbox

 

Hi:

 

I was wondering if anybody new how to move the posission of an email that is quite far down on the lists of emails in the inbox.

 

Is there a way to move that message further up in the list of emails?

 

I hope I explained it properly.

 

 



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 JAWS Disrupted when exiting Word Attachments in Outlook

Yates, Danney
 

Happy Tuesday everyone,Using JAWS  2018.1804.26 with Win 7 and outlook 13.  When I attempt to  exit from a Word email attachment, JAWS simi crashes.  It will read the name of application, like “Outlook” or “Desktop” but nothing within.  I can only address this by unloading JAWS with insert F4, then bringing it back up.

This began when this version of JAWS was loaded lastweek.

 

 

 

 

Roosevelt Warm Springs

Danney Yates, M.Ed., CRC

Assistant Director

Campus Life

Office: (706) 655-5129  Fax: (706) 655-5118  Georgia Relay: 711

6135 Roosevelt Highway│P.O. Box 1000 │Warm Springs, GA 31830

www.gvs.ga.gov                                       

 

 

*Emails may now be sent to: Danney.Yates@...*

 


moderated Re: File find in windows 10 with jaws 2018, looking for content not the names of files

mike mcglashon
 

What if I wanted to search an entire folder with mixed filetypes in it,

Would I type:

“*.*:mike” to find “mike” in any file located within the current folder that is open?

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Steve Nutt
Sent: Monday, May 14, 2018 5:10 PM
To: main@jfw.groups.io
Subject: Re: File find in windows 10 with jaws 2018, looking for content not the names of files

 

Hi David,

 

Or you could type Doc: before your search term  So if you were looking for “David”, and typed “doc:David”, it would only search in documents.  No tabbing, just remembering three characters.

 

If you want to do the reverse and look for files by name, rather than content, then file: is your friend.

 

All the best


Steve

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of David Bailes
Sent: 09 May 2018 09:39
To: main@jfw.groups.io
Subject: Re: File find in windows 10 with jaws 2018, looking for content not the names of files

 

Hi John,
assuming that the files are somewhere in your personal folder, you can do this from the search box in the start menu. Normally when you search for files using the start menu, it only searches the names of files. However, if you filter the search results for documents, then the contents are searched as well. To do this:
1. In the search box, type in a word or phrase as normal.
2. Tab twice to move to the filters list, which is laid out as a row of items.
3. Press right arrow to move to find results in documents, and press enter. The focus returns to the search box, and Jaws reads out the first item in the filtered list of results.

David.

On Tue, May 8, 2018 at 03:40 am, John J. Fioravanti, Jr. wrote:

How can I find files in windows 10 by their content and not just their names.  

Thank you.


moderated Re: Email inbox

Nino Dagostino
 

Thank you for everyones help.

 

The (f12) key works perfectly.

 

Thanks again

 

 

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Bill White
Sent: Monday, May 14, 2018 11:30 AM
To: main@jfw.groups.io
Subject: Re: Email inbox

 

Hi, Nino. If I have an email which I know I will want to act on in the future, and know it may be difficult to find, here’s what I do. I use F12 to save the email as a file. Once it saves, the name resembles the subject line, and it is usually saved as a file in Documents with an .msg extension. If you click on the file, it opens outlook, and you are in the body of the email you saved. You can do all the things you can normally do with an email, including, reply, forward, etc.

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino Dagostino
Sent: Monday, May 14, 2018 4:24 AM
To: main@jfw.groups.io
Subject: Email inbox

 

Hi:

 

I was wondering if anybody new how to move the posission of an email that is quite far down on the lists of emails in the inbox.

 

Is there a way to move that message further up in the list of emails?

 

I hope I explained it properly.

 

 


moderated Re: Wire shark

Nino Dagostino
 

Good morning:

Thank you fore your help.

I cant find a download for tshark, If you would be so kind could you point
me to the tshark download page?

I don't mean to bother you I just cant find the download, I see wireshark to
download but not tshark.

Thank you very mutch.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of
charleseblack@att.net
Sent: Monday, May 14, 2018 7:13 PM
To: main@jfw.groups.io
Subject: Re: Wire shark

There is something called tShark. This will give you information in textual
format. Thanks.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Bissett, Tom
Sent: Monday, May 14, 2018 10:08 AM
To: main@jfw.groups.io
Subject: Re: Wire shark

Hi Nino, I haven't used wire shark for quite a few years. What I did find
is that the information was displayed in two windows. You would locate an
information line with the pc cursor and then you would have to use the jaws
cursor to read the bottom pain that held all the related information. Not
very practical. I found by exporting the information it was very readable
only there was so much information it again was not very practical.

Its colour scheme was all grey and you had to do custom colours for
everything including menus. It can be used in a pinch but really not very
useful on an ongoing basis.

I don't know whether it has changed much since I had to use it. I don't
know of any other tools like that.

Regards

Tom Bisset



From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino
Dagostino
Sent: Sunday, May 13, 2018 9:08 AM
To: main@jfw.groups.io
Subject: Wire shark



Good morming"



Happy mothers day to all those moms.



I was wondering if anybody new if Jaws works with wireshark, if not what
could be used in its place.



Thank you.


moderated Re: Using JAWS to Resume a Download from BARD

HH. Smith Jr.
 

Dan

Also, if you use a download manager such as IDM.

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Dan Longmore
Sent: Monday, May 14, 2018 10:26 AM
To: main@jfw.groups.io
Subject: Re: Using JAWS to Resume a Download from BARD

 

I don’t believe that BARD, except perhaps BARD express, will allow you to pause and resume.  You need to re start the download.

Dan

 

From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Rick Miller
Sent: Monday, May 14, 2018 12:00 AM
To: jfw@groups.io
Subject: Using JAWS to Resume a Download from BARD

 

Dear Listers:

 

When a download I am trying to make from the BARD web site is interrupted, I try to get it to resume by finding the Resume button and using a left mouse click.  But instead of picking up where the download left off, it starts it all over again.  Is there a way using JAWS that you can resume an interrupted download where the download will resume from where it left off?

 

 

 

Rick Miller

 


moderated Re: Where can I learn about formulas for Excel?

inamuddin khan
 

Because there are 36524 days in a hundred years and if you divide it into 7, you will get the answer of 5217 weeks and 5 days extra.

With regards from Inamuddin with the Skype ID:

Charlsdarwin1

 

 

Sent from Mail for Windows 10

 

From: Mario
Sent: Tuesday, May 15, 2018 4:47 AM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?

 

why "Take 5 days from each century that’s 5 from 17, 5 from 18 and 5

from 19" when the date is 11/11/1991?

 

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

From: inamuddin khan [mailto:inamuddin09@...]

Sent: Monday, May 14, 2018 6:56 PM EST

To: main@jfw.groups.io

Subject: Where can I learn about formulas for Excel?

 

1.

Take 5 days from each century that’s 5 from 17, 5 from 18 and 5 from 19.

2.

Take 90 days from year 1901 to year 1990.

3.

Take 22 days as leap years because from year 19901 to year 1990, there

are 22 leap years.

4.

Take 3 days each from January, March, May, July,  August and October.

5.

Take 2 days each from April, June and September.

6.

Take 11 days from November.

7.

The final calculation will be:

5+5+5+90+22+3+3+2+3+2+3+3+2+3+11=162 Divide into 7=23 remainder 1.

8.

Now count it as Sunday 0 Monday 1.

November 11 1991 was Monday.

Hope that make sense!

With regards from Inamuddin with the Skype ID:

Charlsdarwin1

 

 

Sent from Mail for Windows 10

 

From: Mario

Sent: Monday, May 14, 2018 11:08 PM

To: main@jfw.groups.io

Subject: Re: Where can I learn about formulas for Excel?

 

ok, how would a date like 11/11/1991 be handled?

 

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

From: inamuddin khan [mailto:inamuddin09@...]

Sent: Sunday, May 13, 2018 9:45 PM EST

To: main@jfw.groups.io

Subject: Where can I learn about formulas for Excel?

 

Yes dear, you misunderstood the calculation.

1.

Take 19 days from year 2001 to year 2019.

2.

Take 4 days because from year 2001 to year 2019, there are 4 leap years.

3.

Take 3 days each  from January, March, May that will be 9 days.

4.

Take 2 days each from April and June that will be 4.

5.

Take 1 from February because the year 2020 will be leap year.

6.

Take 8 days from July.

7.

The total will be 45 not 36.

The final calculation will be:

19+4+3+1+3+2+3+2+8=45 divide into 7 iquals 6 remainder 3.

So counting will Sunday 0, Monday 1, Tuesday 2, and Wednessday 3.

So July 8th 2020 will be Wednessday!

With regards from Inamuddin with the Skype ID:

Charlsdarwin1

 

 

Sent from Mail for Windows 10

 

From: Mario

Sent: Monday, May 14, 2018 5:46 AM

To: main@jfw.groups.io

Subject: Re: Where can I learn about formulas for Excel?

 

date is 7/8/2020

2020 - 1 = 2019. so start with 19.

4 leap years within those 19 years. so add a 4.

starting from January 2020:

January, March and May have 31 days. so add a 3.

April and June have 30 days. so add a 2.

add the 8 days of July.

total is 36 divided by 7 (days in a week?) = 5.142 = 5.1.

so 7/8/2020 is a Monday. but it's not. where did I go wrong, or is

something missing?

 

 

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

From: Chris Chaffin [mailto:chaffin102468@...]

Sent: Sunday, May 13, 2018 8:00 PM EST

To: main@jfw.groups.io

Subject: Where can I learn about formulas for Excel?

 

Hello Mario,

 

As far as step 1 and why you use 17, You just use one number less than

the last 2 digits of the year.  So since that was 18, you would use the

number 17.  So if you were looking at a date with the year 2020, then

you would use 19.  Again, one less than the last 2 digits of the year.

 

Now, as far as step 3, you basically add 3 for each month that has 31

days, 2 for each month that has 30 days, and 1 for February if it has 29

days.

Now you only count the months up to the month with the date you are

looking for.  For example, if your date is in May, then you would do

this for January through April.  If your date is in October, then you

would do this for January through September.

And finally, you would add the days in the month up to the date you are

looking for.  For example, if your date is the 13th of the month, then

you would add 13, if your date is the 25th, then you would add 25.

 

Now step 4 is just the result from adding the numbers from step 3.  Step

3 was the instructions, and step 4 is the calculation of step 3.

 

Step 5 is just doing the final calculation.  The important part of the

calculation is the remainder.  In the example given, the remainder was

2, so that is what determined the day of the week.

For all calculations, if your remainder is 0 then your day is Sunday, 1

then Monday, 2 then Tuesday, and so on.

 

Hope this has been helpful.

 

Chris

 

 

On May 13, 2018, at 7:24 PM, Mario <mrb620@...> wrote:

 

I always wondered how some individuals can do this. but can someone

clearly explain it to me step by step because I don't follow how it's

done. yes, it is written, but I just don't understand like in step 1,

why do you arrive at using 17 and not 18? is it because 2018 is not an

odd year? and for step 3 and 4, I am lost.

 

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

From: Dave... [mailto:dgcarlson@...]

Sent: Saturday, May 12, 2018 7:33 PM EST

To: main@jfw.groups.io

Subject: Where can I learn about formulas for Excel?

 

Clever and ingenious.

 

Dave

Oregonian, woodworker, Engineer, Musician, and Pioneer

 

 

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

From: inamuddin khan

To: main@jfw.groups.io

Sent: Saturday, May 12, 2018 16:26

Subject: Re: Where can I learn about formulas for Excel?

 

 

Suppose, you don’t have anything computer, cell phone or any kind of

calendar, are you not able to tell the day of the week of any date?

 

Let me tell you how you can do it!

 

Suppose your date is 12/25/2018.

 

1.

 

Take 17 that is 17 years of 21st century.

 

2.

 

Take 4 meaning that from year 1 to year 17, there  are 4 leap years.

 

3.

 

Take 3 from the months which have 31 days, 2 from the months which have

30 days and take 1 from the month which have 29 days.

 

4.

 

      From that calculations, there are 6 months having 31 days meaning 18

days, 4 months having 30 days meaning 8 days and take 25 days from December.

 

5.

 

Now final calculation is:

 

17+4+18+8+25=72 divided by 7=10 remaining 2.

 

6.

 

Now you can count them as, Sunday 0 Monday 1 and Tuesday 2.

 

So December 25 2018 will be Tuesday!

 

With regards from Inamuddin with the Skype ID:

 

Charlsdarwin1

 

 

 

 

 

Sent from Mail for Windows 10

 

 

 

From: Sieghard Weitzel

Sent: Saturday, May 12, 2018 9:49 AM

To: main@jfw.groups.io

Subject: Re: Where can I learn about formulas for Excel?

 

 

 

Actually, if you want to know what day a particular date is, just type

the date in a cell, e.g. in A1 type 12/24/2018, then press Control+1 to

format the cell and select the date format, then from the available

options select the one that has the weekday included (for me it’s the

second from the top).

 

If, for example, I enter 12/25/2018 into A1 and then apply that format,

it will read “Tuesday, December 25, 2018” so I now know that Christmas

day this year is on a Tuesday.

 

Now, if I want to know how many days it is until Christmas from today

(May 11), I type 5/11/2018 into cell A2, then in cell A3 I subtract the

larger date (Christmas) from the smaller date (today), so I put =A1-A2

and the result in this case will be 228 which is the correct number of

days from May 11 until December 25.

 

 

 

the day

 

 

 

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

Sent: Friday, May 11, 2018 6:18 PM

To: main@jfw.groups.io

Subject: Re: Where can I learn about formulas for Excel?

 

 

 

Hi,

 

Following is a formula to calculate the day of the week  from an input date.

 

In the first cell, in this case A4, type in 3/12/1988 and the cell with

the formula will display the week day.

 

 

 

=TEXT(A4,"dddd")

 

 

 

Depending on where you live and the date format, you may need to change

the formula a little.  This formula  works on 3 December 1988 and not

December 12 format.  But then it may not need to be altered at all.

You’ll just need to experiment.

 

 

 

HTH

 

Tom

 

 

 

 

 

 

 

 

 

 

 

From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin

Minor

Sent: Saturday, 12 May 2018 9:31 AM

To: main@jfw.groups.io

Subject: Where can I learn about formulas for Excel?

 

 

 

Hi.

 

 

 

I’m looking for a source to learn about the different formulas for

Excel.  I purchased the book that CathyAnne Murtha wrote, but it doesn’t

contain all the formulas that I’m looking for.  Essentially, I’d like a

kind of Excel for Dummies where all the formulas are listed and how they

work.  As an example, I’d like to know how to have Excel tell me the day

of the week a date will be.  Also, I’d like to know how many days are

between dates.  I looked through the book I got from Ms. Murtha, but it

doesn’t list all the formulas.

 

 

 

Thanks for any help.  Dates aren’t the only thing I’m looking for.  I

know Excel is a very powerful program, and I’d like to learn how to use

it to its fullest potential.

 

 

 

Thanks for any info.

 

 

 

Have a blessed day and don’t work too hard.

 

Kevin Minor and the amazing Jilly, Lexington, KY

 

 

 

 

 

 

 

 

 

 

 

 

.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


moderated Re: Where can I learn about formulas for Excel?

Cristóbal
 

I used to know this parlor trick quite well as a kid, but totally los the skill after the novelty wore off. But yeah, so how many messages ago did this actually stop being anything remotely about Jaws?

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Mario
Sent: Monday, May 14, 2018 4:47 PM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?

why "Take 5 days from each century that’s 5 from 17, 5 from 18 and 5 from 19" when the date is 11/11/1991?

-------- Original Message --------
From: inamuddin khan [mailto:inamuddin09@gmail.com]
Sent: Monday, May 14, 2018 6:56 PM EST
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

1.
Take 5 days from each century that’s 5 from 17, 5 from 18 and 5 from 19.
2.
Take 90 days from year 1901 to year 1990.
3.
Take 22 days as leap years because from year 19901 to year 1990, there are 22 leap years.
4.
Take 3 days each from January, March, May, July, August and October.
5.
Take 2 days each from April, June and September.
6.
Take 11 days from November.
7.
The final calculation will be:
5+5+5+90+22+3+3+2+3+2+3+3+2+3+11=162 Divide into 7=23 remainder 1.
8.
Now count it as Sunday 0 Monday 1.
November 11 1991 was Monday.
Hope that make sense!
With regards from Inamuddin with the Skype ID:
Charlsdarwin1


Sent from Mail for Windows 10

From: Mario
Sent: Monday, May 14, 2018 11:08 PM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?

ok, how would a date like 11/11/1991 be handled?

-------- Original Message --------
From: inamuddin khan [mailto:inamuddin09@gmail.com]
Sent: Sunday, May 13, 2018 9:45 PM EST
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

Yes dear, you misunderstood the calculation.
1.
Take 19 days from year 2001 to year 2019.
2.
Take 4 days because from year 2001 to year 2019, there are 4 leap years.
3.
Take 3 days each from January, March, May that will be 9 days.
4.
Take 2 days each from April and June that will be 4.
5.
Take 1 from February because the year 2020 will be leap year.
6.
Take 8 days from July.
7.
The total will be 45 not 36.
The final calculation will be:
19+4+3+1+3+2+3+2+8=45 divide into 7 iquals 6 remainder 3.
So counting will Sunday 0, Monday 1, Tuesday 2, and Wednessday 3.
So July 8th 2020 will be Wednessday!
With regards from Inamuddin with the Skype ID:
Charlsdarwin1


Sent from Mail for Windows 10

From: Mario
Sent: Monday, May 14, 2018 5:46 AM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?

date is 7/8/2020
2020 - 1 = 2019. so start with 19.
4 leap years within those 19 years. so add a 4.
starting from January 2020:
January, March and May have 31 days. so add a 3.
April and June have 30 days. so add a 2.
add the 8 days of July.
total is 36 divided by 7 (days in a week?) = 5.142 = 5.1.
so 7/8/2020 is a Monday. but it's not. where did I go wrong, or is something missing?


-------- Original Message --------
From: Chris Chaffin [mailto:chaffin102468@gmail.com]
Sent: Sunday, May 13, 2018 8:00 PM EST
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

Hello Mario,

As far as step 1 and why you use 17, You just use one number less than the last 2 digits of the year. So since that was 18, you would use the number 17. So if you were looking at a date with the year 2020, then you would use 19. Again, one less than the last 2 digits of the year.

Now, as far as step 3, you basically add 3 for each month that has 31 days, 2 for each month that has 30 days, and 1 for February if it has 29 days.
Now you only count the months up to the month with the date you are looking for. For example, if your date is in May, then you would do this for January through April. If your date is in October, then you would do this for January through September.
And finally, you would add the days in the month up to the date you are looking for. For example, if your date is the 13th of the month, then you would add 13, if your date is the 25th, then you would add 25.

Now step 4 is just the result from adding the numbers from step 3. Step
3 was the instructions, and step 4 is the calculation of step 3.

Step 5 is just doing the final calculation. The important part of the calculation is the remainder. In the example given, the remainder was 2, so that is what determined the day of the week.
For all calculations, if your remainder is 0 then your day is Sunday, 1 then Monday, 2 then Tuesday, and so on.

Hope this has been helpful.

Chris


On May 13, 2018, at 7:24 PM, Mario <mrb620@hotmail.com> wrote:

I always wondered how some individuals can do this. but can someone clearly explain it to me step by step because I don't follow how it's done. yes, it is written, but I just don't understand like in step 1, why do you arrive at using 17 and not 18? is it because 2018 is not an odd year? and for step 3 and 4, I am lost.

-------- Original Message --------
From: Dave... [mailto:dgcarlson@sbcglobal.net]
Sent: Saturday, May 12, 2018 7:33 PM EST
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

Clever and ingenious.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: inamuddin khan
To: main@jfw.groups.io
Sent: Saturday, May 12, 2018 16:26
Subject: Re: Where can I learn about formulas for Excel?


Suppose, you don’t have anything computer, cell phone or any kind of calendar, are you not able to tell the day of the week of any date?

Let me tell you how you can do it!

Suppose your date is 12/25/2018.

1.

Take 17 that is 17 years of 21st century.

2.

Take 4 meaning that from year 1 to year 17, there are 4 leap years.

3.

Take 3 from the months which have 31 days, 2 from the months which have
30 days and take 1 from the month which have 29 days.

4.

From that calculations, there are 6 months having 31 days meaning 18 days, 4 months having 30 days meaning 8 days and take 25 days from December.

5.

Now final calculation is:

17+4+18+8+25=72 divided by 7=10 remaining 2.

6.

Now you can count them as, Sunday 0 Monday 1 and Tuesday 2.

So December 25 2018 will be Tuesday!

With regards from Inamuddin with the Skype ID:

Charlsdarwin1





Sent from Mail for Windows 10



From: Sieghard Weitzel
Sent: Saturday, May 12, 2018 9:49 AM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?



Actually, if you want to know what day a particular date is, just type the date in a cell, e.g. in A1 type 12/24/2018, then press Control+1 to format the cell and select the date format, then from the available options select the one that has the weekday included (for me it’s the second from the top).

If, for example, I enter 12/25/2018 into A1 and then apply that format, it will read “Tuesday, December 25, 2018” so I now know that Christmas day this year is on a Tuesday.

Now, if I want to know how many days it is until Christmas from today (May 11), I type 5/11/2018 into cell A2, then in cell A3 I subtract the larger date (Christmas) from the smaller date (today), so I put =A1-A2 and the result in this case will be 228 which is the correct number of days from May 11 until December 25.



the day



From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Tom
Sent: Friday, May 11, 2018 6:18 PM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?



Hi,

Following is a formula to calculate the day of the week from an input date.

In the first cell, in this case A4, type in 3/12/1988 and the cell with the formula will display the week day.



=TEXT(A4,"dddd")



Depending on where you live and the date format, you may need to change the formula a little. This formula works on 3 December 1988 and not December 12 format. But then it may not need to be altered at all.
You’ll just need to experiment.



HTH

Tom











From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin Minor
Sent: Saturday, 12 May 2018 9:31 AM
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?



Hi.



I’m looking for a source to learn about the different formulas for Excel. I purchased the book that CathyAnne Murtha wrote, but it doesn’t contain all the formulas that I’m looking for. Essentially, I’d like a kind of Excel for Dummies where all the formulas are listed and how they work. As an example, I’d like to know how to have Excel tell me the day of the week a date will be. Also, I’d like to know how many days are between dates. I looked through the book I got from Ms. Murtha, but it doesn’t list all the formulas.



Thanks for any help. Dates aren’t the only thing I’m looking for. I know Excel is a very powerful program, and I’d like to learn how to use it to its fullest potential.



Thanks for any info.



Have a blessed day and don’t work too hard.

Kevin Minor and the amazing Jilly, Lexington, KY












.


moderated Re: Where can I learn about formulas for Excel?

Mario
 

why "Take 5 days from each century that’s 5 from 17, 5 from 18 and 5
from 19" when the date is 11/11/1991?

-------- Original Message --------
From: inamuddin khan [mailto:inamuddin09@gmail.com]
Sent: Monday, May 14, 2018 6:56 PM EST
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

1.
Take 5 days from each century that’s 5 from 17, 5 from 18 and 5 from 19.
2.
Take 90 days from year 1901 to year 1990.
3.
Take 22 days as leap years because from year 19901 to year 1990, there
are 22 leap years.
4.
Take 3 days each from January, March, May, July, August and October.
5.
Take 2 days each from April, June and September.
6.
Take 11 days from November.
7.
The final calculation will be:
5+5+5+90+22+3+3+2+3+2+3+3+2+3+11=162 Divide into 7=23 remainder 1.
8.
Now count it as Sunday 0 Monday 1.
November 11 1991 was Monday.
Hope that make sense!
With regards from Inamuddin with the Skype ID:
Charlsdarwin1


Sent from Mail for Windows 10

From: Mario
Sent: Monday, May 14, 2018 11:08 PM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?

ok, how would a date like 11/11/1991 be handled?

-------- Original Message --------
From: inamuddin khan [mailto:inamuddin09@gmail.com]
Sent: Sunday, May 13, 2018 9:45 PM EST
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

Yes dear, you misunderstood the calculation.
1.
Take 19 days from year 2001 to year 2019.
2.
Take 4 days because from year 2001 to year 2019, there are 4 leap years.
3.
Take 3 days each from January, March, May that will be 9 days.
4.
Take 2 days each from April and June that will be 4.
5.
Take 1 from February because the year 2020 will be leap year.
6.
Take 8 days from July.
7.
The total will be 45 not 36.
The final calculation will be:
19+4+3+1+3+2+3+2+8=45 divide into 7 iquals 6 remainder 3.
So counting will Sunday 0, Monday 1, Tuesday 2, and Wednessday 3.
So July 8th 2020 will be Wednessday!
With regards from Inamuddin with the Skype ID:
Charlsdarwin1


Sent from Mail for Windows 10

From: Mario
Sent: Monday, May 14, 2018 5:46 AM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?

date is 7/8/2020
2020 - 1 = 2019. so start with 19.
4 leap years within those 19 years. so add a 4.
starting from January 2020:
January, March and May have 31 days. so add a 3.
April and June have 30 days. so add a 2.
add the 8 days of July.
total is 36 divided by 7 (days in a week?) = 5.142 = 5.1.
so 7/8/2020 is a Monday. but it's not. where did I go wrong, or is
something missing?


-------- Original Message --------
From: Chris Chaffin [mailto:chaffin102468@gmail.com]
Sent: Sunday, May 13, 2018 8:00 PM EST
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

Hello Mario,

As far as step 1 and why you use 17, You just use one number less than
the last 2 digits of the year. So since that was 18, you would use the
number 17. So if you were looking at a date with the year 2020, then
you would use 19. Again, one less than the last 2 digits of the year.

Now, as far as step 3, you basically add 3 for each month that has 31
days, 2 for each month that has 30 days, and 1 for February if it has 29
days.
Now you only count the months up to the month with the date you are
looking for. For example, if your date is in May, then you would do
this for January through April. If your date is in October, then you
would do this for January through September.
And finally, you would add the days in the month up to the date you are
looking for. For example, if your date is the 13th of the month, then
you would add 13, if your date is the 25th, then you would add 25.

Now step 4 is just the result from adding the numbers from step 3. Step
3 was the instructions, and step 4 is the calculation of step 3.

Step 5 is just doing the final calculation. The important part of the
calculation is the remainder. In the example given, the remainder was
2, so that is what determined the day of the week.
For all calculations, if your remainder is 0 then your day is Sunday, 1
then Monday, 2 then Tuesday, and so on.

Hope this has been helpful.

Chris


On May 13, 2018, at 7:24 PM, Mario <mrb620@hotmail.com> wrote:

I always wondered how some individuals can do this. but can someone
clearly explain it to me step by step because I don't follow how it's
done. yes, it is written, but I just don't understand like in step 1,
why do you arrive at using 17 and not 18? is it because 2018 is not an
odd year? and for step 3 and 4, I am lost.

-------- Original Message --------
From: Dave... [mailto:dgcarlson@sbcglobal.net]
Sent: Saturday, May 12, 2018 7:33 PM EST
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

Clever and ingenious.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: inamuddin khan
To: main@jfw.groups.io
Sent: Saturday, May 12, 2018 16:26
Subject: Re: Where can I learn about formulas for Excel?


Suppose, you don’t have anything computer, cell phone or any kind of
calendar, are you not able to tell the day of the week of any date?

Let me tell you how you can do it!

Suppose your date is 12/25/2018.

1.

Take 17 that is 17 years of 21st century.

2.

Take 4 meaning that from year 1 to year 17, there are 4 leap years.

3.

Take 3 from the months which have 31 days, 2 from the months which have
30 days and take 1 from the month which have 29 days.

4.

From that calculations, there are 6 months having 31 days meaning 18
days, 4 months having 30 days meaning 8 days and take 25 days from December.

5.

Now final calculation is:

17+4+18+8+25=72 divided by 7=10 remaining 2.

6.

Now you can count them as, Sunday 0 Monday 1 and Tuesday 2.

So December 25 2018 will be Tuesday!

With regards from Inamuddin with the Skype ID:

Charlsdarwin1





Sent from Mail for Windows 10



From: Sieghard Weitzel
Sent: Saturday, May 12, 2018 9:49 AM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?



Actually, if you want to know what day a particular date is, just type
the date in a cell, e.g. in A1 type 12/24/2018, then press Control+1 to
format the cell and select the date format, then from the available
options select the one that has the weekday included (for me it’s the
second from the top).

If, for example, I enter 12/25/2018 into A1 and then apply that format,
it will read “Tuesday, December 25, 2018” so I now know that Christmas
day this year is on a Tuesday.

Now, if I want to know how many days it is until Christmas from today
(May 11), I type 5/11/2018 into cell A2, then in cell A3 I subtract the
larger date (Christmas) from the smaller date (today), so I put =A1-A2
and the result in this case will be 228 which is the correct number of
days from May 11 until December 25.



the day



From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Tom
Sent: Friday, May 11, 2018 6:18 PM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?



Hi,

Following is a formula to calculate the day of the week from an input date.

In the first cell, in this case A4, type in 3/12/1988 and the cell with
the formula will display the week day.



=TEXT(A4,"dddd")



Depending on where you live and the date format, you may need to change
the formula a little. This formula works on 3 December 1988 and not
December 12 format. But then it may not need to be altered at all.
You’ll just need to experiment.



HTH

Tom











From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin
Minor
Sent: Saturday, 12 May 2018 9:31 AM
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?



Hi.



I’m looking for a source to learn about the different formulas for
Excel. I purchased the book that CathyAnne Murtha wrote, but it doesn’t
contain all the formulas that I’m looking for. Essentially, I’d like a
kind of Excel for Dummies where all the formulas are listed and how they
work. As an example, I’d like to know how to have Excel tell me the day
of the week a date will be. Also, I’d like to know how many days are
between dates. I looked through the book I got from Ms. Murtha, but it
doesn’t list all the formulas.



Thanks for any help. Dates aren’t the only thing I’m looking for. I
know Excel is a very powerful program, and I’d like to learn how to use
it to its fullest potential.



Thanks for any info.



Have a blessed day and don’t work too hard.

Kevin Minor and the amazing Jilly, Lexington, KY












.


moderated Re: Wire shark

charleseblack@...
 

There is something called tShark. This will give you information in textual
format. Thanks.

-----Original Message-----
From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Bissett, Tom
Sent: Monday, May 14, 2018 10:08 AM
To: main@jfw.groups.io
Subject: Re: Wire shark

Hi Nino, I haven't used wire shark for quite a few years. What I did find
is that the information was displayed in two windows. You would locate an
information line with the pc cursor and then you would have to use the jaws
cursor to read the bottom pain that held all the related information. Not
very practical. I found by exporting the information it was very readable
only there was so much information it again was not very practical.

Its colour scheme was all grey and you had to do custom colours for
everything including menus. It can be used in a pinch but really not very
useful on an ongoing basis.

I don't know whether it has changed much since I had to use it. I don't
know of any other tools like that.

Regards

Tom Bisset



From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Nino
Dagostino
Sent: Sunday, May 13, 2018 9:08 AM
To: main@jfw.groups.io
Subject: Wire shark



Good morming"



Happy mothers day to all those moms.



I was wondering if anybody new if Jaws works with wireshark, if not what
could be used in its place.



Thank you.


moderated Re: Where can I learn about formulas for Excel?

Dale Alton <blinkydale@...>
 

Thank you Dave. Once I went with remainder and not decimal, bingo bango

Denver Dale

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Dave...
Sent: Sunday, May 13, 2018 9:00 PM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?

remainder, not decimal, Dale. Use even division and note the remainder.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: "Dale Alton" <blinkydale@comcast.net>
To: <main@jfw.groups.io>
Sent: Sunday, May 13, 2018 19:33
Subject: Re: Where can I learn about formulas for Excel?


I must be some thing wrong. Take November 23, 2018.
The formula I come up with is: 17+4+6+23=68, 68/7=9.7. If Sunday is 0 and
Monday is 1 where is 7?

Denver Dale

-----Original Message-----
From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Chris
Chaffin
Sent: Sunday, May 13, 2018 6:00 PM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?

Hello Mario,

As far as step 1 and why you use 17, You just use one number less than the
last 2 digits of the year. So since that was 18, you would use the number
17. So if you were looking at a date with the year 2020, then you would use
19. Again, one less than the last 2 digits of the year.

Now, as far as step 3, you basically add 3 for each month that has 31 days,
2 for each month that has 30 days, and 1 for February if it has 29 days.
Now you only count the months up to the month with the date you are looking
for. For example, if your date is in May, then you would do this for
January through April. If your date is in October, then you would do this
for January through September.
And finally, you would add the days in the month up to the date you are
looking for. For example, if your date is the 13th of the month, then you
would add 13, if your date is the 25th, then you would add 25.

Now step 4 is just the result from adding the numbers from step 3. Step 3
was the instructions, and step 4 is the calculation of step 3.

Step 5 is just doing the final calculation. The important part of the
calculation is the remainder. In the example given, the remainder was 2, so
that is what determined the day of the week.
For all calculations, if your remainder is 0 then your day is Sunday, 1 then
Monday, 2 then Tuesday, and so on.

Hope this has been helpful.

Chris


On May 13, 2018, at 7:24 PM, Mario <mrb620@hotmail.com> wrote:

I always wondered how some individuals can do this. but can someone
clearly explain it to me step by step because I don't follow how it's
done. yes, it is written, but I just don't understand like in step 1,
why do you arrive at using 17 and not 18? is it because 2018 is not an
odd year? and for step 3 and 4, I am lost.

-------- Original Message --------
From: Dave... [mailto:dgcarlson@sbcglobal.net]
Sent: Saturday, May 12, 2018 7:33 PM EST
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?

Clever and ingenious.

Dave
Oregonian, woodworker, Engineer, Musician, and Pioneer


----- Original Message -----
From: inamuddin khan
To: main@jfw.groups.io
Sent: Saturday, May 12, 2018 16:26
Subject: Re: Where can I learn about formulas for Excel?


Suppose, you don’t have anything computer, cell phone or any kind of
calendar, are you not able to tell the day of the week of any date?

Let me tell you how you can do it!

Suppose your date is 12/25/2018.

1.

Take 17 that is 17 years of 21st century.

2.

Take 4 meaning that from year 1 to year 17, there are 4 leap years.

3.

Take 3 from the months which have 31 days, 2 from the months which have
30 days and take 1 from the month which have 29 days.

4.

From that calculations, there are 6 months having 31 days meaning 18
days, 4 months having 30 days meaning 8 days and take 25 days from
December.

5.

Now final calculation is:

17+4+18+8+25=72 divided by 7=10 remaining 2.

6.

Now you can count them as, Sunday 0 Monday 1 and Tuesday 2.

So December 25 2018 will be Tuesday!

With regards from Inamuddin with the Skype ID:

Charlsdarwin1





Sent from Mail for Windows 10



From: Sieghard Weitzel
Sent: Saturday, May 12, 2018 9:49 AM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?



Actually, if you want to know what day a particular date is, just type
the date in a cell, e.g. in A1 type 12/24/2018, then press Control+1 to
format the cell and select the date format, then from the available
options select the one that has the weekday included (for me it’s the
second from the top).

If, for example, I enter 12/25/2018 into A1 and then apply that format,
it will read “Tuesday, December 25, 2018” so I now know that Christmas
day this year is on a Tuesday.

Now, if I want to know how many days it is until Christmas from today
(May 11), I type 5/11/2018 into cell A2, then in cell A3 I subtract the
larger date (Christmas) from the smaller date (today), so I put =A1-A2
and the result in this case will be 228 which is the correct number of
days from May 11 until December 25.



the day



From: main@jfw.groups.io <main@jfw.groups.io> On Behalf Of Tom
Sent: Friday, May 11, 2018 6:18 PM
To: main@jfw.groups.io
Subject: Re: Where can I learn about formulas for Excel?



Hi,

Following is a formula to calculate the day of the week from an input
date.

In the first cell, in this case A4, type in 3/12/1988 and the cell with
the formula will display the week day.



=TEXT(A4,"dddd")



Depending on where you live and the date format, you may need to change
the formula a little. This formula works on 3 December 1988 and not
December 12 format. But then it may not need to be altered at all.
You’ll just need to experiment.



HTH

Tom











From: main@jfw.groups.io [mailto:main@jfw.groups.io] On Behalf Of Kevin
Minor
Sent: Saturday, 12 May 2018 9:31 AM
To: main@jfw.groups.io
Subject: Where can I learn about formulas for Excel?



Hi.



I’m looking for a source to learn about the different formulas for
Excel. I purchased the book that CathyAnne Murtha wrote, but it doesn’t
contain all the formulas that I’m looking for. Essentially, I’d like a
kind of Excel for Dummies where all the formulas are listed and how they
work. As an example, I’d like to know how to have Excel tell me the day
of the week a date will be. Also, I’d like to know how many days are
between dates. I looked through the book I got from Ms. Murtha, but it
doesn’t list all the formulas.



Thanks for any help. Dates aren’t the only thing I’m looking for. I
know Excel is a very powerful program, and I’d like to learn how to use
it to its fullest potential.



Thanks for any info.



Have a blessed day and don’t work too hard.

Kevin Minor and the amazing Jilly, Lexington, KY