Tag - Spreadsheet
We used to think it was an Excel thing that other people would forget it was a spreadsheet and instead use it as a kind of rudimentary database where they listed text in the columns instead of numbers. Now we have to face the fact that it isn't other people who do this, it's us –– and we're doing it all over again in Apple's Numbers. We know we're wasting its strengths, we know, but it's handy and there is a way to both speed it up and to make us feel like we're fine not going off to create databases all the time. You can use popup forms in Numbers.
You've got a spreadsheet or a word processing document that you use to dump information into. Maybe research text you've copied from Wikipedia and pasted in with everything else you've found on the same topic. Maybe it's a spreadsheet with expenditure, notes, half-worked out sums. We all have messy documents like these, and they're fine -- until you have to send them to someone else. Or so you think. We want to argue that it isn't fine. That the fact you would clean it all up to help someone else understand your work is exactly the reason you should clean it up for yourself. We just also want you to clean it up with Microsoft's Format Painter.
Apple's Numbers spreadsheet is not Microsoft Excel. To be frank, it's not as good as Excel but that's not why we say it: Numbers is a first-class application, but people tend to think of it as an Excel clone -- and that misses the point a little. Instead, Numbers is a different approach to solving the same problems and giving the same tools as Excel. You'll get more from it if you don't think of how Excel would do something. You'll also get more from it by using the many little touches that Numbers has but, in typical Apple fashion, are not forced down your throat.
To the people who don't use or need data-mining, data-modelling or prediction software, it can seem pretty dull -- the province of scientists or IT experts. The truth, however, is that such software has significant real-world implications both theoretical and practical, as evidenced by KnowledgeMiner's self-titled software for data analysis in Microsoft's Excel spreadsheet application. In addition to announcing an update to v2.4 that splits the product into single-processor and multi-processor versions, the company has highlighted a case study where the use of KnowledgeMiner (yX)'s ability to reveal trends and patterns is actually saving the lives of thousands of animals formerly used for chemical testing in the European Union.
Mariner Software has released Mariner Calc, a spreadsheet application for the iPhone and iPod touch that enables users to view and edit Microsoft Excel files. The program provides a number of functions, with categories including math, finance, trigonometry, statistic, and lookup. The document dates, content or plus-logic information can also be edited, with support for splitting panes, freezing, border creation, font and color customization, or alignment. Users can view documents in either portrait or landscape mode.
Effigent on Thursday unveiled PowerEasy Distribution for Mac, offering users a suite of modules for tracking, managing, and replenishing inventory levels, as well as overseeing the distribution cycle from purchasing and stocking, to sales. Users are able to process sales and purchase orders, manage inventory, and create visual charts for company progress, which can be shared across networks, or interface with spreadsheet, analysis or presentation software.
ProVUE Development recently unveiled Panorama 5.5, a new version to its high performance RAM-based database program. The new version brings a bevy of new features, such as the Enhanced Live Clairvoyance search wizard, which allows users to search through bookmarks and formulas, in a style similar to that of Spotlight. Panorama can now interface directly with Microsoft Excel spreadsheets, as well as Quicken QIF, OFX, and QFX formats, enabling the application to directly exchange data with the databases. New users can purchase Panorama 5.5 for $300, directly from ProVUE's web site.
Now AAPL Stock: 153.99 ( + 0.93 )
Cirrus creates Lightning-headphone dev kit
Apple supplier Cirrus Logic has introduced a MFi-compliant new development kit for companies interested in using Cirrus' chips to create Lightning-based headphones, which -- regardless of whether rumors about Apple dropping the analog headphone jack in its iPhone this fall -- can offer advantages to music-loving iOS device users. The kit mentions some of the advantages of an all-digital headset or headphone connector, including higher-bitrate support, a more customizable experience, and support for power and data transfer into headphone hardware. Several companies already make Lightning headphones, and Apple has supported the concept since June 2014. http://bit.ly/29giiZj
Apple Store app offers Procreate Pocket
The Apple Store app for iPhone, which periodically rewards users with free app gifts, is now offering the iPhone "Pocket" version of drawing app Procreate for those who have the free Apple Store app until July 28. Users who have redeemed the offer by navigating to the "Stores" tab of the app and swiping past the "iPhone Upgrade Program" banner to the "Procreate" banner have noted that only the limited Pocket (iPhone) version of the app is available free, even if the Apple Store app is installed and the offer redeemed on an iPad. The Pocket version currently sells for $3 on the iOS App Store. [32.4MB]
Porsche adds CarPlay to 2017 Panamera
Porsche has added a fifth model of vehicle to its CarPlay-supported lineup, announcing that the 2017 Panamera -- which will arrive in the US in January -- will include Apple's infotainment technology, and be seen on a giant 12.3-inch touchscreen as part of an all-new Porsche Communication Management system. The luxury sedan starts at $99,900 for the 4S model, and scales up to the Panamera Turbo, which sells for $146,900. Other vehicles that currently support CarPlay include the 2016 911 and the 2017 models of Macan, 718 Boxster, and 718 Cayman. The company did not mention support for Google's corresponding Android Auto in its announcement. http://bit.ly/295ZQ94
Apple employees testing wheelchair features
New features included in the forthcoming watchOS 3 are being tested by Apple retail store employees, including a new activity-tracking feature that has been designed with wheelchair users in mind. The move is slightly unusual in that, while retail employees have previously been used to test pre-release versions of OS X and iOS, this marks the first time they've been included in the otherwise developer-only watchOS betas. The company is said to have gone to great lengths to modify the activity tracker for wheelchair users, including changing the "time to stand" notification to "time to roll" and including two wheelchair-centric workout apps. http://bit.ly/2955JDa
SanDisk reveals two 256GB microSDXC cards
SanDisk has introduced two 256GB microSDXC cards. Arriving in August for $150, the Ultra microSDXC UHS-I Premium Edition card offers transfer speeds of up to 95MB/s for reading data. The Extreme microSDXC UHS-I card can read at a fast 100MB/s and write at up to 90MB/s, and will be shipping sometime in the fourth quarter for $200. http://bit.ly/294Q1If
Apple's third-quarter results due July 26
Apple has advised it will be issuing its third-quarter results on July 26, with a conference call to answer investor and analyst queries about the earnings set to take place later that day. The stream of the call will go live at 2pm PT (5pm ET) via Apple's investor site, with the results themselves expected to be released roughly 30 minutes before the call commences. Apple's guidance for the quarter put revenue at between $41 billion and $43 billion. http://apple.co/1oi1Pbm
Twitter stickers slowly roll out to users
Twitter has introduced "stickers," allowing users to add extra graphical elements to their photos before uploading them to the micro-blogging service. A library of hundreds of accessories, props, and emoji will be available to use as stickers, which can be resized, rotated, and placed anywhere on the photograph. Images with stickers will also become searchable with viewers able to select a sticker to see how others use the same graphic in their own posts. Twitter advises stickers will be rolling out to users over the next few weeks, and will work on both the mobile apps and through the browser. http://bit.ly/29bbwUE