Tag Archives: Numbers

Five Tip Friday ~ Pages, Keynote, Numbers collaboration and more on macOS and iOS

Yes it’s Good Friday already in New Zealand, and yes I’m up, and yes I am going to work, as the museum I work at only closes on Christmas Day. Luckily I have time to add some tips for you.
By default, people that you invite can edit your document, but the initial sharer can change share options and limit who can access it (from Apple World Today).

1/ Apple’s Pages, Numbers and Keynote apps for macOS and iOS allow you to collaborate — You can invite others to your documents and work on them together in real time. Here’s how to use iWork collaboration on a Mac with macOS Sierra and Pages 6.0, Numbers 4.0, or Keynote 7.0 or later;
An iPhone, iPad, or iPod touch with iOS 10 and Pages 3.0, Numbers 3.0, or Keynote 3.0 or later;
A Mac with Safari 6.0.3 or later, or Google Chrome 27.0.1 or later;
and even on a Windows PC with Internet Explorer 11 or later, or Google Chrome 27.0.1 or later.
To invite others to collaborate you must be signed in to iCloud on your device and have iCloud Drive turned on. If you’re using a web browser, sign in to iCloud.com and open the iWork app you want to use.
If you have an iPhone, iPad, or iPod touch with earlier versions of iOS or iWork apps, or if you have an Android device, you can view documents but can’t edit them.
When you invite people to collaborate on a document, spreadsheet, or presentation, the app creates an iCloud.com link for you to send to them. If you limit access so that only people you invite can collaborate on your document, they must sign in to iCloud or iCloud.com with their Apple ID. The name of the document is included in the URL. If the title or content of the document is confidential, make sure to ask participants not to forward the link to anyone else.
Here’s how to invite other people from your Mac. From Pages, Numbers, or Keynote, open the document you want to share. In the toolbar, click the share icon — a head with a checkmark by it.
Tap Add People to add people. Tap your preferred method for sending the link. If you choose to email your invitation, type an email address or phone number for each person you want to invite. Add any other information, then send or post the message.
The share icon — a head with a checkmark by it —  indicates that a document is shared. The checkmark changes to show how many people have the document open (not including you).


2/ Collaborating in iOS — Here’s how to invite other folks from your iPhone, iPad or iPod touch: if your document is already open in Pages, Numbers, or Keynote, tap the three dot icon, then tap Collaborate With Others. If you’re in the Document Manager, tap the share icon,  then tap Collaborate With Others. Tap the document you want to share. If the document you select hasn’t downloaded to your device, it downloads now.

3/ Protect with a password — If you set Who Can Access to ‘Anyone with the link, and you want to add a password, tap Add Password. Type your password and hint. You and other participants need this password to open the document.

4/ Invite other people from iCloud.com — If your document is already open in Pages, Numbers, or Keynote for iCloud, click the share icon in the toolbar. If you’re in the Document Manager, select a document, then click the icon that looks like a gear. Now choose Collaborate With Others.

5/ Password protect iWork documents anyway — Here’s how to password-protect Pages, Numbers, Keynote docs in macOS Sierra: From Pages, Keynote or Numbers, open the document that you want to secure with a password.
Go to the File menu and choose Select Set Password.
Enter a password and a hint.
That’s it! As you set a password, a small lock icon will appear on that particular document indicating that it’s secured with a password. The next time you need to access the doc on any Apple device or via iCloud, you’ll be asked for a password.

iWork collaboration, new Mac games, 25 dongles

(Image from Engadget)

Apple introduces real time, cross-platform iWork collaboration — Apple has just announced a new iWork feature that allows both Mac and iOS users to collaborate on a variety of Pages, Numbers and Keynote documents in real time. The iWork collaboration feature is available for iPhones, iPads and Macs. Users running Windows can also work with colleagues via a web interface.

Hot Mac games released this summer — Ric Molina is onto it again.

Apple currently sells 25 dongles/adapters — Dr Andrew Leavitt gathered up all 25 dongles/adapters Apple currently sells. With folks thinking about the headphone jack going the way of the floppy, it’s an interesting list to consider. Apple still sells 30-Pin adapters, for instance, ad even an External USB to Modem adapter? Check out Dr Leavitt’s list. (Via Mac Observer.)

Five Tip Friday ~ your Mac’s Display, Numbers and even make an animated GIF in Photoshop


1/ Adjust your Mac display’s resolution settings — Macs ship with the display set at a certain resolution, and Apple defines this in the technical specifications for each model. But with Retina displays, these numbers can get confusing: there is the display’s resolution and the “looks like” resolution used on the Mac. Resolutions on Retina Macs look like half the actual number of pixels measured vertically and horizontally because of pixel doubling.

RezTo change resolution (ie, make things look bigger, or smaller and more detailed, on your screen), you must first check Scaled in the Displays pane (circled, above). Then see five options. These range from larger text to more space, with the Default setting in the middle.
If you have aging eyes or just want to see less on your display, try one of the settings to the left of the Default option. If you want to see more on the display — with smaller fonts, menus, etc — then try one of the settings to the right. When you hover over one of these options, the Displays pane shows a text saying that “Using a scaled resolution may affect performance.” This is because your graphics card might not be able to keep up with a higher resolution (ie when things look smaller), or that some of your apps may not display correctly.

2/ Do quick sums in Numbers — With just a couple of clicks, you can add a formula that totals up a series of cells, whether your numbers are down a column or across a row. To do this, click on the cell where you’d like to put the sum, and select the Formula button in the toolbar.
Choose “Sum” from that list, and Numbers’ll automagically do just that.
As you can tell, though, you can also use this handy toolbar button to do averages, products, and more, quick as a wink. And if you need advanced options, pick “Create Formula” from under that button, and you’ll see all of the functions you can use (there are a lot!).

3/ In Numbers, use Conditional Formatting — This feature works a lot like rules in Mail: ‘if this thing is true, then do this, but if this other thing is true instead, do a different thing.’ For example, you can set up some conditions on a range of cells to say “If the number within you is greater than 1000, colour the cell green; if it’s less than 500, color it blue.”
Select the cells you want to apply the formatting to, then click “Format” in the toolbar to slide your options out if they aren’t already visible.
Under those tabs on the right, choose the “Cell” one, and there you’ll see “Conditional Highlighting.”
Set your parameters for what rules you want your cells to follow there. Try “greater than, less than”. Use text conditions to find cells that start with or end with certain words.
Make conditions by date, even, and be sure to keep adding on those rules until you’re satisfied with the formatting options you’ve set. Then you’ll be able to visually screen your data faster, and your budget will thank you. [MacObserver has more info and pictures explaining this.]

4/ Use keyboard shortcuts to add rows and columns — Option plus any of the arrow keys will add things in for you. Here are the choices:
Option–Up Arrow: Adds a row above the one you’re on
Option–Down Arrow: Adds a row below the one you’re on
Option–Right Arrow: Adds a column to the right of the one you’re on
Option–Left Arrow: Adds a column to the left of the one you’re on.

5/ OK, for the real power users, how to create an animated GIF in Photoshop— Fire up Photoshop (CS6 Extended or any version of CC) and choose File > New. In the resulting dialog box, enter the animation width and height (say, 300×250 pixels). Enter 72 for resolution, set the Color Mode menu to RGB, and choose sRGB from the Color Profile menu.
Next, create the content using layers. To add images to the document, choose File>Place Embedded (File>Place in earlier versions of Photoshop). Photoshop surrounds the image with resizing handles; Shift-drag any corner handle to resize the image and then press Return. Repeat for each image. Be sure to include a layer for branding (say, your logo) and a “call to action” layer (say, “click here to get 50% off your first sitting”). The latter gives your audience an action to do, and lets you gauge the ad’s success rate. Once your content is complete, turn off the layer visibility icons (circled) for everything except what you want visible on the first frame.
This Layers panel shows all the animation content. As you can see, only the layers for the first frame are visible.
Now choose Window > Timeline. In the resulting panel, click the down-pointing icon to the right of the Create Video Timeline button and choose Create Frame Animation. Click the Create Frame Animation button that appears and Photoshop creates one frame representing what’s currently visible in the Layers panel. Each frame serves as a placeholder for the content you want to show onscreen, which you control using layer visibility.
To add a new frame, click the “Duplicate selected frames” button (circled). Since frame content is determined by layer visibility, the new frame is identical to the first one. In the Layers panel, use the visibility icons to display only the layer(s) containing the content for the second frame in your animation. Keep adding frames and adjusting layer visibility until you’ve completed the animation. Here the call to action frame appears after the final costume photo, followed by a “blank” frame containing only the background.
After clicking the duplicate button (circled), use layer visibility to display the content you want to appear in the second frame (top). Adding a blank frame between two text frames (the first and last) helps keep text readable once the animation loops during playback (bottom).
You can also add a fade transition between frames, which is called tweening. To do it, activate the frame you want to fade into the next one (say, the “call to action” frame) and click the Tween button (it looks like a diagonal row of squares and it’s at left of the duplicate button). In the resulting dialog box, tell Photoshop which frame to tween the active one with (Next Frame was used here) and enter how many frames of fading you want in the Frames to Add field. Click OK and Photoshop adds the new frames.
Use the frame delay menu beneath each frame to control how long it’s visible. Keep your branding and call to action frames onscreen long enough to be read (say, two seconds) and speed up tweened frames (0.5 seconds). Next, click the looping options menu (circled) and choose 3, so the animation repeats itself three times. Click the Play button (also circled) to preview your handiwork.
You can set the delay for each frame individually or en masse by Shift- or Command-clicking to activate frames and then changing the duration of one of them.
When you’re finished, choose Optimize Animation from the Timeline panel’s fly-out menu (circled). In the resulting dialog box, leave both options turned on: Bounding Box closely crops each frame to its content and Redundant Pixel Removal makes unchanged pixels transparent in subsequent frames). Choose File > Save As and pick Photoshop from the Format menu to preserve your layers so you can edit them later.
Choose File > Save for Web in Photoshop CS6 Extended or File > Export > Save for Web in CC and choose GIF from the format menu at upper right (circled). If you’ve included photographs with gradients in the animation, set the Dither menu to Diffusion and experiment with the amount setting to its right (also circled). If your animation doesn’t include full-color photos, try lowering the Colors field to reduce file size. Use the Animation section at lower right (circled) to preview your piece before saving it.
The resulting GIF will play in any web browser: use the browser’s File > Open command or drag and drop the GIF onto a browser window. You can also preview it using QuickLook: simply click the file name and press your keyboard’s spacebar.
(From Lesa Snider at Macworld).

iWorks updates, and using Up Next


Apple has released updates to all of the iWork apps — The updates (also for iOS) primarily do two things: provide bug fixes for compatibility with Microsoft Office documents and make the apps more stable. The Mac update fixed an issue in Keynote when exporting presentations as images, and another with master slides that included links. Pages on the Mac (NZ$24.99 or free on all Macs released in the last 18 months) can now open some Microsoft Word documents that were previously impossible to open, plus it resolves an issue that prevented the use of Look Up for words in lists. Numbers can now open more Microsoft Excel spreadsheets.

How to use Up Next on iTunes — iTunes and the iOS Music app both offer Up Next, a way to queue up music you want to listen to. They work in very similar ways, allowing you to add music to the Up Next queue, change the order of tracks in the queue, and remove specific songs from Up Next. Let’s take a look at how to use Up Next in iTunes and the iOS Music app.

Intel reveals Broadwell, Pages and Numbers mail-merge, Corel Painter Essentials

Intel has finally unveiled 14 different Broadwell-series chips (picture from Engadget)
Intel has finally unveiled 14 different Broadwell-series chips (picture from Engadget)

Intel officially unveils full Broadwell-based Intel Core CPU lineup — Chip giant Intel on Monday took the covers off if its oft-delayed fifth-generation Intel Core processor family, a revamp that includes significant efficiency improvements and is expected to sit at the heart of Apple’s rumoured all-new MacBook Air.
Based on the 14-nanometer Broadwell microarchitecture, Intel says that the new chips are “purpose-built for the next generation of compute devices.” Manufacturers will have 10 new low-power, 15-watt models and 4 new 28-watt variants to choose from.

Pages and Numbers mail-merge — It’s not a feature directly built into either app but it’spossible through the power of AppleScript. On the Mac OS X Automation site is an AppleScript and Pages page that provides instructions for using the free Pages Data Merge utility (the page also includes a link to that utility). As its name suggests it lets you incorporate data found in a Numbers spreadsheet into a Pages documents. Christopher Breen has more.

Review: Painter Essentials 5 offers fun photo painting with 31 new brushes — Corel Painter Essentials has hit the streets. Targeted toward hobbyists, art enthusiasts and emerging photo painters, Painter Essentials 5 was redesigned to be smoking fast and far easier to use. It includes a whopping 31 new and useful brushes, including some of Painter 2015’s hot new Particle Brushes, plus two new tools for creating mirror and kaleidoscope paintings, a vastly improved photo painting engine, a powerful brush-tracking utility, real-time effect previews, and more.