You are here

news aggregator

Couldn’t have said it better: Rumors don’t doom Apple

Mac World - Thu, 2018-11-29 07:00

You can’t swing a 30-pin dock connector cable these days without hitting a pundit wailing about the Apple doom that the current swath rumors of iPhone production cuts must mean.

Not that The Macalope is suggesting you should do that.

If anyone is watching.

Anyway, while the furry one maintains that you can’t trust these thinly-sourced supply chain rumors, there are seemingly a lot more thinly-sourced supply chain rumors this year than in previous years. Is it smoke or are analysts just smelling burnt toast again? When you add in a particularly bad turn in the market overall and the threat of tariffs on products made in China and, yeah, #AAPL is down quite a bit.

To read this article in full, please click here

How to create Excel macros and automate your spreadsheets

PC World - Thu, 2018-11-29 06:35

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. For example, it takes Excel less than one-tenth of a second to calculate an entire, massive spreadsheet. It’s the manual operations that slow you down. That’s why you need macros to combine all of these chores into a single one-second transaction.

Excel macros: Tips for getting started

We’re going to show you how to write your first macro. Once you see how easy it is to automate tasks using macros, you’ll never go back. 

First, some tips on how to prepare your data for macros:

  • Always begin your macro at the Home position (use the key combination Ctrl+ Home to get there quickly).
  • Use the directional keys to navigate: Up, Down, Right, Left, End, Home, etc., and shortcut keys to expedite movement.
  • Keep your macros small and focused on specific tasks. This is best for testing and editing (if needed). You can always combine these mini-macros into one BIG macro later once they’re perfected.
  • Macros require “relative” cell addresses, which means you “point” to the cells rather than hard-code the actual (or “absolute”) cell address (such as A1, B19, C20, etc.) in the macro. Spreadsheets are dynamic, which means they constantly change, which means the cell addresses change.
  • Fixed values and static information such as names, addresses, ID numbers, etc. are generally entered in advance and not really part of your macro. Because this data rarely changes (and if it does, it’s just to add or remove a new record), it’s almost impossible to include this function in a macro.
  • Manage your data first: Add, edit, or delete records, then enter the updated values. Then you can execute your macro.
Why starting with mini-macros is easier

For this example, we have a store owner who has expanded her territory from a single store to a dozen in 12 different major cities. Now the CEO, she’s been managing her own books for years, which wasn’t an easy task for a single store, and now she has 12. She has to collect data from each store and merge it to monitor the health of her entire company.

To read this article in full, please click here

Kangaroo Motion Sensor review: This home security system only goes halfway

Mac World - Thu, 2018-11-29 06:00
This home security system sure sounds inexpensive, but it's no bargain.

Amazon's eye for sports could shatter TV as we know it

Mac World - Thu, 2018-11-29 06:00
Amazon buying regional Fox Sports networks could fulfill our a la carte sports dreams, but at a cost.

How an Apple TV stick could make Apple’s video streaming service an instant hit

Mac World - Thu, 2018-11-29 06:00

You might have missed it between all the turkey brining and Black Friday sales, but last week The Information reported that Apple considered making a tiny AppleTV “stick” similar to those made by competitors like Amazon and Roku.

Up to now, Apple has been steadfast in holding the line on Apple TV pricing. When the company introduced the Apple TV 4K, it didn’t even drop the price on the fourth-generation model—they’re still both for sale, at starting prices of $149 and $179 respectively.

Compare that to the competition: You can buy a Fire TV Stick for $40 and a 4K version for $50, and comparable devices from Roku cost $30 and $40, respectively. Yes, these sticks are underpowered compared to Apple’s box—Roku’s Apple TV equivalent box is $100—but no matter how you measure it, Apple’s not competitive in the TV box market when it comes to price.

To read this article in full, please click here

Kangaroo Motion Sensor review: This home security system only goes halfway

PC World - Thu, 2018-11-29 06:00
This home security system sure sounds inexpensive, but it's no bargain.

Amazon's eye for sports could shatter TV as we know it

PC World - Thu, 2018-11-29 06:00
Amazon buying regional Fox Sports networks could fulfill our a la carte sports dreams, but at a cost.

What's behind the weird RAM amounts on some PCs: The confusing blend with Optane Memory

PC World - Thu, 2018-11-29 06:00

When does a PC have “24GB of Memory?” When its Intel Optane Memory is being counted on top of the 4GB, 8GB, or 16GB of RAM we’re used to seeing on mainstream PCs.

Traditional RAM and Optane Memory do different things, however, so the fact that some PCs are showing this blended spec is bound to confuse shoppers looking for new PCs over the holidays. We’ve taken a closer look at what’s being advertised and how to understand what the PC you’re shopping for really has. 

Sam’s Club

Is it OK to market laptops with total “memory” by counting the Optane drive too?

To read this article in full, please click here

Pages

Subscribe to Computer Science aggregator