How to Shut Down Mac with no mouse

How can you safely shut down your Mac if your mouse stops working?

If needed, press ⌘tab to visit each open application, and use ⌘S to save your work. Press ⌘tab until the Finder is the front application.

If there is a Finder window open, fine. If not, press ⌘N to get one.

Press Control-Tab to get the text cursor into the spotlight window in the upper right.

Type

terminal

    • Use the arrow up/down keys to select the Terminal application from the search results.

Press ⌘O to open the Terminal

In the terminal window type:

sudo shutdown -h now

    • Press return.

Enter your password. Your Mac will shut down.

Can you think of an easier way?
This tip was created and tested on MacOS 10.6.5. It should work on any version of MacOS X since spotlight was introduced.

June 2018 WWDC Notes

At this month’s meeting we are reviewing the announcements from Apple’s World Wide Developer’s Conference Keynote. As usual, MacMAD is providing links so that you don’t need to take notes in the meeting.

The announcements fell into three subject areas:

The Apple TV and Apple Watch (PDF)

iOS 12 – New system for the iPhone and iPad (Pages document) or (view as PDF)

MacOS Mojave – New system for the Macintosh (RTF Text Edit document)

 

 

Meeting Topic: iTunes 12.7 September 2017

Our MacMAD meeting topic this month is iTunes. There are some interesting changes in the latest version. In particular, Apple has removed the purchase and management of iOS Apps from iTunes. This is a good step in the right direction to make iTunes less complicated and more focused.

Here is tonight’s Keynote presentation.

 

Stellar Phoenix Mac Data Recovery

This is a guest post from Dennis Crowley

I have been given the opportunity to review Stellar Phoenix Mac Data Recovery Software. The Stellar Data Recovery Home page claims the software will perform safe and accurate recovery of lost documents, photos, music files, or videos that have been accidentally or intentionally deleted from Mac computer. While I did not review all the claims made by Stellar Data Recovery I did test the ability to recover deleted files.

I deleted some photo, Word, music and PDF files from my iMac and three days later tried to recover them. I was skeptical, so prior to deleting the files I copied them to a flash drive to insure they would not be lost. I ran the software, selected the appropriate drive and to my surprise all the deleted files were recovered and retained the original names.

The software comes with an online User Manual. Although the software is slightly expensive the cost is offset by the ability to recover priceless photos or documents.

Stellar Phoenix Mac Data Recovery Software is a good product and does what it claims.

Meeting Topic: Apple’s Numbers Spreadsheet App

March 21, 2017 Meeting Topic Overview: Numbers

by Jamie Cox

The current version of Numbers as of March 2017 is 4.0.5.

There are three ways to run Numbers:

  • On the Macintosh
  • On iOS (iPhone or iPad)
  • From a Web Browser on iCloud

How to GetNumbers

Numbersprobably came with your Mac or iOS device, or getNumbersvia the Mac App Store($19.99),or getNumbersvia the iTunes App Store($9.99).

Competition / Alternatives to Numbers

Controversy Since iWork ’09

When the new version of Numbersfor the Mac came out some features were dropped. Most of them have not been added back in. Reviews of the apps have been definitely mixed. Numbers only gets a 3-star rating on the App store (both versions).

3 stars
Ratings for Numbers on the Mac App Store

Two-and-a-half to three starsis a pretty terrible rating, especially for an Apple app. As you can see, the ratings are very mixed with most reviewers giving either one star orfive-star ratings. The ratings for the iOS version are very similar.

Guide to Star Ratings

The one-star reviews are mostly from people upsetabout advanced features removed from the previous version. The five-star reviews tend to befrom people who have come to the application fresh, with no special expectations.

Numbers includes hundreds of distinct features. The chart below highlights just a fewof myfavorite features as compared with Microsoft Excel.

Comparison of Features Between Numbers and Microsoft Excel

Documents, Sheets and Tables

Numbers documents can have multiple sheets. Each sheet can have multiple tables. When you create a new Numbers document, it has one sheet with one table on that sheet.

If you have used Excel, having multiple sheets should be familiar. The main difference is that the sheets appear at the top of the window instead of at the bottom.

The concept of having multiple tables on a single sheet may be new to users of older spreadsheet programs. It is a very nice feature, which allows you to separate groups of data or formulas which are of different types instead of lumping them all into the same grid of rows and columns. You can arrange the tables on the page however you like.

This document has two sheets. Sheet 1 has two tables.

 

Formatting Controls

Table Style Controls

Numbers uses a consistent set of formatting controls very similar to those in the Pages word processor we discussed last month. These are presented in a pane on the right hand side of the window. These controls look simple, but all together, they have a lot of power. In addition to the pre-defined Table and Text styles, you can create and save your own preferred styles.

Formula Editing

Type an equals sign to enter formula editing mode for a cell. Color coding appears showing the source cells used in your formula. This makes it easier to understand if your formula is correct or to see the source of errors.

When you copy or fill a formula into additional cells, Numbers automatically adjusts cell references relative to the current cell. If you want to override that to select an absolute row, absolute column, or absolute cell, you can use the Preserve Row/Preserve Column options.

The Numbers Formula Editor

Importing Files From Excel

A common task in Numbers would be to open an Excel document createdby someone else. This can work fairly well, but is not completely painless.

Original Excel Template on left, Numbers Import on right

This imported okay, and the amortization calculations agreed, but the date formulas were not imported correctly and would have to be re-done in numbers.

Large Files

One of our members asked how Numbers was at handling large files imported from Excel. To test this I created a large spreadsheet in Excel with 40,000 rows and about 14 columns. The file size in Excel was 3.7 Megabytes. Numbers opened it without complaint, but it took about 30 seconds. When saved as a native Numbers document, its size increased to 6.3 Mbytes, but the native document opened in Numbers in about five seconds.

Although I didn’t get any warnings in Numbers, I did get one “Not enough memory” message in Excel while cutting, pasting and filling to create the document. Excel handled it gracefully without crashing.

iOS Numbers App

The Numbers app on iOS is deliberately very similar to the version for Macintosh.

Numbers App on iPhone

FYI, Excel also has an iOS app which is free in the App store. It looks like this:

Excel on the iPhone

The Excel app is apparently read-only until you register for and log in to a Microsoft Office 365account.

Conclusion

If you want a spreadsheet program to perform the usual tasks of calculation, sorting and organizing, and you don’t have much prior experience with spreadsheets, you will find Numbers a very useful application. It’s especially easy to learn because ofconsistent controls across Mac and iOS versions and consistency with Pages and Keynote.

If you know what a pivot table is, or have a lot of spreadsheets already in Excel format, you may be dissatisfied with the limitations of Numbers.

 

Meeting Topic: Apple’s Pages Word Processor

Feb 21, 2017 Meeting Topic Overview: Pages

by Jamie Cox

“Expect a lot from software and you’ll usually get it.” – Eric Newman, MacMAD President emeritus

In Feb 2017, the current version of Pages for Mac is 6.0.5. For iOS it is version 3.0.5.

There are three ways to run Pages:

  • On the Macintosh
  • On an iPhone or iPad
  • From a Web Browser on iCloud

Pages Running on the Mac

Pages Running on the iPhone

Pages Running in a Browser from iCloud.com


How to Get Pages

Pages probably came with your Mac or iOS device, or getPages via the Mac App Store($19.99),or getPages via the iTunes App Store($9.99).

Competition / Alternatives to Pages

  • TextEdit – came with your Mac; Open Source; For simple tasks,it does more than you think
  • Microsoft Word (Office) – For giant documents and giant companies (Now with iOS version)
  • Open Office – Free and Open Source Office suite
  • NeoOffice -Commercialized version of Open Office customized for the Mac
  • GoogleDocs – Cloud-based, free

 

What Pages Does

Although Pages has a deceptively clean and simple design, it does a lot of things you might have expectedto need separate applicationsfor. Pages includes these functions:

  • Word Processing (obviously)
  • Page Layout
  • Spreadsheet
  • Charting
  • Photo Editing
  • Publishing
  • Collaboration Software

Integration with iCloud

Work on your document from all your devices.

Pages Has Two Document Types

All Pages documents are either:

  • Word Processing Documents, or
  • Page Layout Documents (have no body)

Word Processing documents have body text which is a continuous flow of text within the document. It may flow around images, tables, etc.

Page Layout documents have no body. All text in a page layout document exists as part of something else: a text box, a shape, or a table.

Consistent Text Operations

Text can exist in:

  • The document body,
  • Text boxes
  • Shapes,
  • Tables,
  • The header and footer

All are treated consistentlyas far as styles and formatting.

Shapes and Images

  • Wrap
  • Align
  • Resize
  • Rotate
  • Shapes can have text with the usual attributes
  • Images can not have text
  • Shapes have adjustable opacity
  • Images have opacity and Instant Alpha
  • Opacity is the opposite of transparency
  • Alpha isjustselective transparency – pixel-by-pixel

Import and Export

Import Microsoft Word Format

Export Your Document As:

  • PDF
  • ePub – for eBook readers like Kindle and iBook
  • Microsoft Word
  • Pages ’09 – For users of older versions of Pages

Learn More

http://www.apple.com/pages/

Pages 101 Tutorial Video with David A Cox(YouTube) (no relation)

 

 

VPN – Virtual Private Network Meeting Topic

MacMAD’s October, 2016 Meeting topic is VPNs (Virtual Private Networks). Here are some accompanying links and information.

People generally use a VPN for these reasons:

  • Security and privacy when using a public network, such as at a coffee shop or hotel.
  • To allow access to online content which is subject to geographical restrictions.
  • To allow remote access to a private local network such as your home network or your employer’s network
  • Provide privacy at home (prevent your ISP from knowing what you are up to)

VPN Features to Look For

  • Automatic connection and reconnection – prevents accidental leakage of unencrypted data
  • Choice of VPN endpoint – What country would you like to be in today?
  • Self Installation/Configuration – Avoids lots of technical settings

Client and Server

VPNs follow a client-server model. The client app usually runs on your computer or portable device. The server can be either a commercial VPN service or you can run your own VPN server at home on your router (some models) or on another computer. There are many (hundreds) commercial VPN providers. The following list is not at all complete.

Commercial VPN Providers

VPN Software

VPN Protocols

Your choice of protocol will probably be determined by what your server or provider supports.

  • PPTP – (Point-to-Point Tunneling Protocol) Old, do not use. No longer supported in macOS Sierra. or iOS 10.
  • L2TP – (Layer 2 Tunneling Protocol) needs IPSec or similar to be secured.
  • IPSec – (Internet Protocol Security) A modern protocol. Can work in conjunction with L2TP.
  • IKEv2 – (Internet Key Exchange version 2) A modern protocol.

Here’s the MacOS VPN Dialog in System Preferences

vpn-dialog
MacOS Network Preferences — adding a VPN interface

 

openvpn-1
The iOS app OpenVPN