Manual Iterations On Mac
Iteration is the repeated recalculation of a worksheet until a specific numeric condition is met. Excel cannot automatically calculate a formula that refers to the cell — either directly or indirectly — that contains the formula. You can control when calculation occurs by changing the calculation process to manual calculation. Aug 09, 2018 Iteration - the number of times a formula is recalculated until a specific numeric condition is met. Precision - the degree of accuracy for a calculation. In this tutorial, we will have a close look at how each of the above settings works and how to change them. Excel automatic calculation vs. Manual calculation; Excel iterative calculation.
Part of a series on |
macOS |
---|
|
The history of macOS, Apple's current Macoperating system originally named Mac OS X until 2012 and then OS X until 2016, began with the company's project to replace its 'classic' Mac OS. That system, up to and including its final release Mac OS 9, was a direct descendant of the operating system Apple had used in its Macintosh computers since their introduction in 1984. However, the current macOS is a Unix operating system built on technology that had been developed at NeXT from the 1980s until Apple purchased the company in early 1997.
Although it was originally marketed as simply 'version 10' of the Mac OS (indicated by the Roman numeral 'X'), it has a completely different codebase from Mac OS 9, as well as substantial changes to its user interface. The transition was a technologically and strategically significant one. To ease the transition, versions through 10.4 were able to run Mac OS 9 and its applications in a compatibility layer.
It was first released in 1999 as Mac OS X Server 1.0, with a widely released desktop version—Mac OS X 10.0—following in March 2001. Since then, several more distinct desktop and server editions of macOS have been released. Starting with Mac OS X 10.7 Lion, macOS Server is no longer offered as a separate operating system; instead, server management tools are available for purchase as an add-on. Starting with the Intel build of Mac OS X 10.5 Leopard, most releases have been certified as Unix systems conforming to the Single Unix Specification.[1][2][3][4][5]
macOS has retained the major version number 10 throughout its development history to date; releases of macOS have also been named after big cats (versions 10.0–10.8) or locations in California (10.9–present).
- 1Development
- 2Releases
Development[edit]
Development outside Apple[edit]
After Apple removed Steve Jobs from management in 1985, he left the company and attempted to create the 'next big thing', with funding from Ross Perot[6] and himself. The result was the NeXT Computer. As the first workstation to include a digital signal processor (DSP) and a high-capacity optical disc drive, NeXT hardware was advanced for its time, but was expensive relative to the rapidly commoditizing workstation market and marred by design problems. The hardware was phased out in 1993; however, the company's object-oriented operating systemNeXTSTEP had a more lasting legacy.
NeXTSTEP was based on the Mach kernel developed at CMU (Carnegie Mellon University)[7] and BSD, an implementation of Unix dating back to the 1970s. It featured an object-oriented programming framework based on the Objective-C language. This environment is known today in the Mac world as Cocoa. It also supported the innovative Enterprise Objects Framework database access layer and WebObjects application server development environment, among other notable features.
All but abandoning the idea of an operating system, NeXT managed to maintain a business selling WebObjects and consulting services, but was never a commercial success. NeXTSTEP underwent an evolution into OPENSTEP which separated the object layers from the operating system below, allowing it to run with less modification on other platforms. OPENSTEP was, for a short time, adopted by Sun Microsystems. However, by this point, a number of other companies — notably Apple, IBM, Microsoft, and even Sun itself — were claiming they would soon be releasing similar object-oriented operating systems and development tools of their own. (Some of these efforts, such as Taligent, did not fully come to fruition; others, like Java, gained widespread adoption.)
On February 4, 1997, Apple Computer acquired NeXT for $427 million, and used OPENSTEP as the basis for Mac OS X, as it was called at the time.[8] Traces of the NeXT software heritage can still be seen in macOS. For example, in the Cocoa development environment, the Objective-C library classes have 'NS' prefixes, and the HISTORY section of the manual page for the defaults
command in macOS straightforwardly states that the command 'First appeared in NeXTStep.'
Internal development[edit]
Meanwhile, Apple was facing commercial difficulties of its own. The decade-old Macintosh System Software had reached the limits of its single-user, co-operative multitasking architecture, and its once-innovative user interface was looking increasingly outdated. A massive development effort to replace it, known as Copland, was started in 1994, but was generally perceived outside Apple to be a hopeless case due to political infighting and conflicting goals. By 1996, Copland was nowhere near ready for release, and the project was eventually cancelled. Some elements of Copland were incorporated into Mac OS 8, released on July 26, 1997.
After considering the purchase of BeOS — a multimedia-enabled, multi-tasking OS designed for hardware similar to Apple's, the company decided instead to acquire NeXT and use OPENSTEP as the basis for their new OS. Avie Tevanian took over OS development, and Steve Jobs was brought on as a consultant. At first, the plan was to develop a new operating system based almost entirely on an updated version of OPENSTEP, with the addition of a virtual machine subsystem — known as the Blue Box — for running 'classic' Macintosh applications. The result was known by the code name Rhapsody, slated for release in late 1998.
Apple expected that developers would port their software to the considerably more powerful OPENSTEP libraries once they learned of its power and flexibility. Instead, several major developers such as Adobe told Apple that this would never occur, and that they would rather leave the platform entirely. This 'rejection' of Apple's plan was largely the result of a string of previous broken promises from Apple; after watching one 'next OS' after another disappear and Apple's market share dwindle, developers were not interested in doing much work on the platform at all, let alone a re-write.
Changed direction under Jobs[edit]
Apple's financial losses continued and the board of directors lost confidence in CEO Gil Amelio, asking him to resign. The board asked Steve Jobs to lead the company on an interim basis, essentially giving him carte blanche to make changes to return the company to profitability. When Jobs announced at the World Wide Developer's Conference that what developers really wanted was a modern version of the Mac OS, and Apple was going to deliver it[citation needed], he was met with thunderous applause. Over the next two years, major effort was applied to porting the original Macintosh APIs to Unix libraries known as Carbon. Mac OS applications could be ported to Carbon without the need for a complete re-write, making them operate as native applications on the new operating system. Meanwhile, applications written using the older toolkits would be supported using the 'Classic' Mac OS 9 environment. Support for C, C++, Objective-C, Java, and Python were added, furthering developer comfort with the new platform.
During this time, the lower layers of the operating system (the Mach kernel and the BSD layers on top of it[9]) were re-packaged and released under the Apple Public Source License. They became known as Darwin. The Darwin kernel provides a stable and flexible operating system, which takes advantage of the contributions of programmers and independent open-source projects outside Apple; however, it sees little use outside the Macintosh community[citation needed]. During this period, the Java programming language had increased in popularity, and an effort was started to improve Mac Java support. This consisted of porting a high-speed Java virtual machine to the platform, and exposing macOS-specific 'Cocoa' APIs to the Java language.
The first release of the new OS — Mac OS X Server 1.0 — used a modified version of the Mac OS GUI, but all client versions starting with Mac OS X Developer Preview 3 used a new theme known as Aqua. Aqua was a substantial departure from the Mac OS 9 interface, which had evolved with little change from that of the original Macintosh operating system: it incorporated full color scalable graphics, anti-aliasing of text and graphics, simulated shading and highlights, transparency and shadows, and animation. A key new feature was the Dock, an application launcher which took advantage of these capabilities. Despite this, OS X maintained a substantial degree of consistency with the traditional Mac OS interface and Apple's own Apple Human Interface Guidelines, with its pull-down menu at the top of the screen, familiar keyboard shortcuts, and support for a single-button mouse. The development of Aqua was delayed somewhat by the switch from OpenStep's Display PostScript engine to one developed in-house that was free of any license restrictions, known as Quartz.
Releases[edit]
With the exception of Mac OS X Server 1.0 and the original public beta, the first several macOS versions were named after big cats. Prior to its release, version 10.0 was code named 'Cheetah' internally at Apple, and version 10.1 was code named internally as 'Puma'. After the code name 'Jaguar' for version 10.2 received publicity in the media, Apple began openly using the names to promote the operating system: 10.3 was marketed as 'Panther', 10.4 as 'Tiger', 10.5 as 'Leopard', 10.6 as 'Snow Leopard', 10.7 as 'Lion', and 10.8 as 'Mountain Lion'. 'Panther', 'Tiger', and 'Leopard' were registered as trademarks, and Apple registered 'Lynx' and 'Cougar', but these were allowed to lapse,[10] with Apple instead using the name of iconic locations in California for subsequent releases: 10.9 Mavericks is named after Mavericks, a popular surfing destination; 10.10 Yosemite is named after Yosemite National Park; 10.11 El Capitan is named for El Capitan; 10.12 Sierra is named for the Sierra Nevada mountain range; and 10.13 High Sierra is named for the area around the High Sierra Camps.
Public Beta: 'Kodiak'[edit]
On September 13, 2000 Apple released a $29.95[11] 'preview' version of Mac OS X (internally codenamed Kodiak) in order to gain feedback from users.[12] It marked the first public availability of the Aqua interface, and Apple made many changes to the UI based on customer feedback. Mac OS X Public Beta expired and ceased to function in spring 2001.[13]
Version 10.0: 'Cheetah'[edit]
Manual Iterations On Mac Pro
On March 24, 2001, Apple released Mac OS X 10.0 (internally codenamed Cheetah).[14]The initial version was slow, incomplete, and had very few applications available at the time of its launch, mostly from independent developers. While many critics suggested that the operating system was not ready for mainstream adoption, they recognized the importance of its initial launch as a base on which to improve. Simply releasing Mac OS X was received by the Macintosh community as a great accomplishment, for attempts to completely overhaul the Mac OS had been underway since 1996, and delayed by countless setbacks. Following some bug fixes, kernel panics became much less frequent.
Version 10.1: 'Puma'[edit]
Mac OS X 10.1 (internally codenamed Puma) was released on September 25, 2001.[15]It has better performance and provided missing features, such as DVD playback. Apple released 10.1 as a free upgrade CD for 10.0 users. Apple released a US$129 upgrade CD for Mac OS 9.
On January 7, 2002, Apple announced that Mac OS X was to be the default operating system for all Macintosh products by the end of that month.[16]
Version 10.2: 'Jaguar'[edit]
On August 23, 2002,[17]Apple followed up with Mac OS X 10.2Jaguar, the first release to use its code name as part of the branding.[18]It brought great raw performance improvements, a sleeker look, and many powerful user-interface enhancements (over 150, according to Apple[19]), including Quartz Extreme for compositing graphics directly on an ATIRadeon or NvidiaGeForce2 MX AGP-based video card with at least 16 MB of VRAM, a system-wide repository for contact information in the new Address Book, and an instant messaging client named iChat.[20]The Happy Mac which had appeared during the Mac OS startup sequence for almost 18 years was replaced with a large grey Apple logo with the introduction of Mac OS X 10.2.
Version 10.3: 'Panther'[edit]
Mac OS X Panther was released on October 24, 2003. In addition to providing much improved performance, it also incorporated the most extensive update yet to the user interface. Panther included as many or more new features as Jaguar had the year before, including an updated Finder, incorporating a brushed-metal interface, Fast user switching, Exposé (Window manager), FileVault, Safari, iChat AV (which added videoconferencing features to iChat), improved Portable Document Format (PDF) rendering and much greater Microsoft Windows interoperability.[21]Support for some early G3 computers such as the Power Macintosh and PowerBook was discontinued.
Version 10.4: 'Tiger'[edit]
Mac OS X Tiger was released on April 29, 2005. Apple stated that Tiger contained more than 200 new features.[22]As with Panther, certain older machines were no longer supported; Tiger requires a Mac with a built-in FireWire port.Among the new features, Tiger introduced Spotlight, Dashboard, Smart Folders, updated Mail program with Smart Mailboxes, QuickTime 7, Safari 2, Automator, VoiceOver, Core Image and Core Video. The initial release of the Apple TV used a modified version of Tiger with a different graphical interface and fewer applications and services. On January 10, 2006, Apple released the first Intel-based Macs along with the 10.4.4 update to Tiger. This operating system functioned identically on the PowerPC-based Macs and the new Intel-based machines, with the exception of the Intel release dropping support for the Classic environment.[23]Only PowerPC Macs can be booted from retail copies of the Tiger client DVD, but there is a Universal DVD of Tiger Server 10.4.7 (8K1079) that can boot both PowerPC and Intel Macs.
Version 10.5: 'Leopard'[edit]
Mac OS X Leopard was released on October 26, 2007. It was called by Apple 'the largest update of Mac OS X'. Leopard supports both PowerPC- and Intel x86-based Macintosh computers; support for the G3 processor was dropped and the G4 processor required a minimum clock rate of 867 MHz, and at least 512 MB of RAM to be installed. The single DVD works for all supported Macs (including 64-bit machines). New features include a new look, an updated Finder, Time Machine, Spaces, Boot Camp pre-installed,[24] full support for 64-bit applications (including graphical applications), new features in Mail and iChat, and a number of new security features. Leopard is an Open Brand UNIX 03 registered product on the Intel platform. It was also the first BSD-based OS to receive UNIX 03 certification.[1][25] Leopard dropped support for the Classic Environment and all Classic applications,[26] and was the final version of Mac OS X to support the PowerPC architecture.
Version 10.6: 'Snow Leopard'[edit]
Mac OS X Snow Leopard was released on August 28, 2009, the last version to be available on disc. Rather than delivering big changes to the appearance and end user functionality like the previous releases of Mac OS X, the development of Snow Leopard was deliberately focused on 'under the hood' changes, increasing the performance, efficiency, and stability of the operating system. For most users, the most noticeable changes are these: the disk space that the operating system frees up after a clean installation compared to Mac OS X 10.5 Leopard, a more responsive Finder rewritten in Cocoa, faster Time Machine backups, more reliable and user friendly disk ejects, a more powerful version of the Preview application, as well as a faster Safari web browser. An update introduced support for the Mac App Store, Apple's digital distribution platform for macOS applications and subsequent macOS upgrades.[27] Snow Leopard only supports machines with Intel CPUs, requires at least 1 GB of RAM, and drops default support for applications built for the PowerPC architecture (Rosetta can be installed as an additional component to retain support for PowerPC-only applications).[28]
Version 10.7: 'Lion'[edit]
Mac OS X Lion was released on July 20, 2011. It brought developments made in Apple's iOS, such as an easily navigable display of installed applications (Launchpad) and (a greater use of) multi-touch gestures, to the Mac. This release removed Rosetta, making it incapable of running PowerPC applications. It dropped support for 32-bit Intel processors and requires 2GB of memory. Changes made to the GUI (Graphical User Interface) include the Launchpad (similar to the home screen of iOS devices), auto-hiding scrollbars that only appear when they are being used, and Mission Control, which unifies Exposé, Spaces, Dashboard, and full-screen applications within a single interface.[29]Apple also made changes to applications: they resume in the same state as they were before they were closed (similar to iOS). Documents auto-save by default.
Version 10.8: 'Mountain Lion'[edit]
OS X Mountain Lion was released on July 25, 2012. It incorporates some features seen in iOS 5, which include Game Center, support for iMessage in the new Messages messaging application, and Reminders as a to-do list app separate from iCal (which is renamed as Calendar, like the iOS app). It also includes support for storing iWork documents in iCloud. 2GB of memory is required.[30] Notification Center, which makes its debut in Mountain Lion, is a desktop version similar to the one in iOS 5.0 and higher. Application pop-ups are now concentrated on the corner of the screen, and the Center itself is pulled from the right side of the screen. Mountain Lion also includes more Chinese features, including support for Baidu as an option for Safari search engine.[31]Notification Center is added, providing an overview of alerts from applications. Notes is added, as an application separate from Mail, synching with its iOS counterpart[32][33] through the iCloud service. Messages, an instant messagingsoftware application,[34] replaces iChat.[35]
Version 10.9: 'Mavericks'[edit]
OS X Mavericks was released on October 22, 2013, as a free update through the Mac App Store worldwide.[36]It placed emphasis on battery life, Finder enhancements, other enhancements for power users, and continued iCloud integration, as well as bringing more of Apple's iOS apps to the OS X platform. iBooks and Apple Maps applications were added. Mavericks requires 2GB of memory to operate. It is the first version named under Apple's then-new theme of places in California, dubbed Mavericks after the surfing location.[37][38] Unlike previous versions of OS X, which had progressively decreasing prices since 10.6, 10.9 was available at no charge to all users of compatible systems running Snow Leopard (10.6) or later,[39] beginning Apple's policy of free upgrades for life on its operating system and business software.[40]
Version 10.10: 'Yosemite'[edit]
OS X Yosemite was released to the general public on October 16, 2014, as a free update through the Mac App Store worldwide. It featured a major overhaul of user interface, replaced skeuomorphism with flat graphic design and blurred translucency effects, following the aesthetic introduced with iOS 7. It introduced features called Continuity and Handoff, which allow for tighter integration between paired OS X and iOS devices: the user can handle phone calls or text messages on either their Mac or their iPhone, and edit the same Pages document on either their Mac or their iPad. A later update of the OS included Photos as a replacement for iPhoto and Aperture.
Version 10.11: 'El Capitan'[edit]
OS X El Capitan was revealed on June 8, 2015, during the WWDC keynote speech.[41] It was made available as a public beta in July and was made available publicly on September 30, 2015. Apple described this release as containing 'Refinements to the Mac Experience' and 'Improvements to System Performance' rather than new features. Refinements include public transport built into the Maps application, GUI improvements to the Notes application, as well as adopting San Francisco as the system font. Metal API, an application enhancing software, had debuted in this operating system, being available to 'all Macs since 2012'.[42]
Manual Iterations On Mac Pdf
Version 10.12: 'Sierra'[edit]
macOS Sierra was announced on June 13, 2016, during the WWDC keynote speech. The update brought Siri to macOS, featuring several Mac-specific features, like searching for files. It also allowed websites to support Apple Pay as a method of transferring payment, using either a nearby iOS device or Touch ID to authenticate. iCloud also received several improvements, such as the a ability to store a user’s Desktop and Documents folders on iCloud so they could be synced with other Macs on the same Apple ID. It was released publicly on September 20, 2016.[43]
Version 10.13: 'High Sierra'[edit]
macOS High Sierra was announced on June 5, 2017, during the WWDC keynote speech. It was released on September 25, 2017. The release includes many under-the-hood improvements, including a switch to Apple File System (APFS), the introduction of Metal 2, support for HEVC video, and improvements to VR support. In addition, numerous changes were made to standard applications including Photos, Safari, Notes, and Spotlight.[44]
Manual Iterations On Mac Computer
Version 10.14: 'Mojave'[edit]
macOS Mojave was announced on June 4, 2018, during the WWDC keynote speech. It was released on September 24, 2018. Some of the key new features were the Dark mode, Desktop stacks and Dynamic Desktop, which changes the desktop background image to correspond to the user's current time of day.[45]
Version 10.15: 'Catalina'[edit]
macOS Catalina was announced on June 3, 2019, during the WWDC keynote speech. It primarily focuses on updates to built-in apps, such as replacing iTunes with separate Music, Podcasts, and TV apps, redesigned Reminders and Books apps, and a new Find My app. It also features Sidecar, which allows the user to use an iPad as a second screen for their computer, or even simulate a graphics tablet with an Apple Pencil. It is the first version of macOS not to support 32-bit applications.[46]
Timeline[edit]
See also[edit]
References[edit]
- ^ abThe Open Group. 'Mac OS X version 10.5 Leopard on Intel-based Macintosh computers certification'. Archived from the original on 2008-05-11. Retrieved 2007-06-12.
- ^The Open Group. 'Mac OS X version 10.6 Leopard on Intel-based Macintosh computers certification'. Archived from the original on 2014-11-16. Retrieved 2013-07-11.
- ^The Open Group. 'Mac OS X version 10.8 Mountain Lion on Intel-based Macintosh computers certification'. Archived from the original on 2014-11-16. Retrieved 2013-07-11.
- ^The Open Group. 'Mac OS X version 10.9 Mavericks on Intel-based Macintosh computers certification'. Archived from the original on 2013-11-04. Retrieved 2013-09-18.
- ^The Open Group. 'OS X version 10.10 Yosemite on Intel-based Macintosh computers certification'. Archived from the original on 2014-11-10. Retrieved 2014-11-13.
- ^Isaacson, Walter (2011). Steve Jobs. Simon & Schuster. p. 227. ISBN978-1-4087-0374-8.
- ^A Practical Guide to Linux Commands, Editors, and Shell Programming, 3rd edition, by Mark G. Sobell, page 2
- ^Linzmayer, Owen W. (1999). Apple Confidential: The Real Story of Apple Computer, Inc.
- ^A Practical Guide to Llinux Commands, Editors, and Shell Programming, 3rd edition by Mark G. Sobell, page 2
- ^Trademark #78257226 for Panther, #78269988 for Tiger, #78270003 for Leopard, #78271630 for Cougar and #78271639 for Lynx, all registered in 2004 by Apple Computer, Inc.'United States Patent and Trademark Office'. Archived from the original on December 20, 2006. Retrieved December 20, 2006.
- ^John Siracusa. 'Mac OS X Beta – Page 1 – (10/2000)'. Ars Technica. Condé Nast Digital. Archived from the original on October 30, 2009. Retrieved March 11, 2010.
- ^'Makefile'. Apple. June 2005. Archived from the original on 2009-01-14. Retrieved December 15, 2008.
RC Release is Kodiak (Public Beta)
- ^'Mac OS X Public Beta Expires Today | News'. The Mac Observer. Archived from the original on June 8, 2011. Retrieved March 11, 2010.
- ^Although the version is now called Cheetah by users, rare evidences can be found to prove that it was called so internally. For instance, a Q&A was created in 2005 which mentions it'Technical Q&A'. Apple. October 4, 2005. Archived from the original on May 18, 2008. Retrieved December 20, 2006.
- ^'Cross-Development'. Apple. November 11, 2006. Archived from the original on 2007-05-20. Retrieved December 20, 2006.
- ^'Apple Makes Mac OS X the Default Operating System on All Macs' (Press release). Apple. January 7, 2002. Retrieved December 3, 2006.
- ^'Jaguar 'Unleashed' at 10:20 p.m. Tonight' (Press release). Apple. August 23, 2002. Retrieved January 10, 2018.
- ^The headline of the press release mention 'Jaguar', while the codename was not mentioned for earlier versions. See Apple.com, 'Jaguar' press release, compared to Mac OS X 10.0 press release and Mac OS X 10.1 press release
- ^'Apple - Mac OS X'. Apple. August 29, 2002. Archived from the original on August 29, 2002. Retrieved June 12, 2008.
- ^'Apple Previews 'Jaguar,' the Next Major Release of Mac OS X' (Press release). Apple. May 6, 2002. Retrieved January 10, 2018.
- ^'Apple Announces Mac OS X 'Panther'' (Press release). Apple. October 8, 2003. Retrieved January 10, 2018.
- ^'Apple Unleashes 'Tiger Friday at 6:00 p.m.' (Press release). Apple. April 28, 2005. Retrieved January 10, 2018.
- ^'Apple unveils Intel iMacs'. AppleInsider. January 2006. Retrieved January 10, 2018.
- ^'Apple – BootCamp'. Apple. 2006. Archived from the original on June 2, 2006. Retrieved June 5, 2006.
- ^'Mac OS X Leopard – Technology – UNIX'. Leopard Technology Overview. Apple. Archived from the original on June 9, 2011. Retrieved October 26, 2007.
Leopard is now an Open Brand UNIX 03 Registered Product, conforming to the SUSv3 and POSIX 1003.1 specifications for the C API, Shell Utilities, and Threads.
- ^'Do Classic applications work with Mac OS X 10.5 or Intel-based Macs?'. Knowledge Base. Apple. January 13, 2006. Archived from the original on October 25, 2007. Retrieved October 25, 2007.
- ^Reisinger, Don (January 6, 2011). 'Mac App Store launches on Snow Leopard'. CNET. CBS Interactive. Archived from the original on August 10, 2012.
- ^Lynch, Steven (June 12, 2008). 'Mac OS X Snow Leopard Drops PowerPC Support'. HardOCP. Archived from the original on September 27, 2011. Retrieved October 20, 2010.
- ^'Apple – OS X Lion - The world's most advanced desktop operating system'. Apple. October 20, 2010. Archived from the original on October 22, 2010. Retrieved October 20, 2010.
- ^'Apple – OS X Mountain Lion - The world's most advanced desktop operating system'. Apple. February 16, 2012. Archived from the original on February 16, 2012. Retrieved February 16, 2012.
- ^Panzarino, Matthew (February 16, 2012). 'Apple courts China with Sina Weibo, Baidu, Youku and more integrated in Mountain Lion'. The Next Web. Archived from the original on March 21, 2012. Retrieved March 15, 2012.
- ^'OS X Mountain Lion - See everything the new OS X can do'. Apple. Section 'Notes'. Archived from the original on August 15, 2012. Retrieved February 22, 2012.
- ^Titlow, John Paul. 'Apple's Convergence of Desktop and Mobile Continues With Mountain Lion'. ReadWriteWeb. SAY Media. Archived from the original on 21 April 2012. Retrieved 24 April 2012.
- ^'OS X Mountain Lion - Inspired by iPad. Made for the Mac'. Apple. Archived from the original on 2012-03-22. Retrieved 2012-03-23.
- ^Cheng, Jacqui. 'OS X Mountain Lion now available via Mac App Store'. Ars Technica. Archived from the original on August 27, 2012. Retrieved September 1, 2012.
- ^'Apple Releases Developer Preview of OS X Mavericks With More Than 200 New Features' (Press release). Apple Inc. June 10, 2013. Archived from the original on June 13, 2013.
- ^WWDC 2013 Keynote. Apple Inc. June 10, 2013. Archived from the original on February 18, 2014.
- ^Ha, Anthony (Jun 10, 2013). 'Apple Has A New, California-Based Naming Scheme For OS X, Starting With OS X Mavericks'. TechCrunch. Archived from the original on 2017-07-09.
- ^Souppouris, Aaron (October 22, 2013). 'OS X Mavericks now available as a free download'. The Verge. Archived from the original on October 22, 2013.
- ^Gupta, Poornima; Chan, Edwin (October 22, 2013). 'Apple unveils iPad Air, new Macs for holidays'. Reuters. Archived from the original on April 24, 2016.
- ^'Apple Announces OS X El Capitan with Refined Experience & Improved Performance'. www.apple.com (Press release). Retrieved January 10, 2018.
- ^Dhiraj, Rav (June 2015). 'What's New in Metal, Part 1'(pdf). Apple Developer. Apple. p. 84. Archived(PDF) from the original on June 17, 2015. Retrieved October 21, 2017.
- ^July 19, MacRumors Staff on; 2017. 'macOS Sierra: Siri, Apple Pay for the Web, and More, Available Now'. www.macrumors.com. Retrieved 2019-07-01.
- ^'macOS High Sierra'. Apple. Retrieved September 26, 2017.
- ^'macOS - Mojave Preview'. Apple. Retrieved June 5, 2018.
- ^June 27, MacRumors Staff on; 2019. 'macOS Catalina: Just Announced, Coming This Fall'. www.macrumors.com. Retrieved 2019-07-01.
External links[edit]
In general what you are talking about is 'optimizing' your spreadsheet. You need to find 'bottlenecks' causing the slow performance in your sheet.
Although large volumes of data are a very common cause of slow performance, poorly designed formulas and functions can slow down even relatively 'small' worksheets.
Here are some articles that highlight some common 'mistakes' that you may be able to correct to speed up your sheet (I have more links if you want them):
@Speed up Excel in 15 Easy Steps http://professor-excel.com/15-ways-to-speed-up-excel/
Excel is a great tool for performing complex calculations. Unfortunately, the larger an Excel spreadsheet gets, the slower the calculations will be. Depending on the formulas, size of the workbook and the computer, the calculations may take up to 30 minutes. In this article, we take a look at 15 methods to save time and speed up Excel. ET MR Macros.docx
Calculation Options in Excel: Decide When and What to Calculate http://professor-excel.com/calculation-options-in-excel-decide-when-and-what-to-calculate/
Does this sound familiar to you: Excel takes too much time calculating. Instead of instantly showing the results, you have to wait for several seconds or even minutes for Excel to finish up the calculation. The problem: The larger your Excel model gets, the more you get frustrated by the lack of performance. ET MR Macros.docx
@util- RefTreeAnalyser Utility http://www.jkp-ads.com/RefTreeAnalyser01.asp
allows for easy Auditing of formula dependents and precedents, helps you trace errors, and will let you time your workbook calculation for each worksheet to find bottlenecks as well as check columns for formula inconsistencies. Jan Karel has a free demo version with limited functionality, if you’d like to take it for a spin.
@util- What is FastExcel Version 3 and why do you need it? http://www.decisionmodels.com/fastexcel.htm
There are 3 major products in the FastExcel V3 family which are targeted at different types of useage, so that you can buy only the tools that you need.The Profiler gives you a comprehensive set of tools focussed on finding and prioritising calculation bottlenecks. If your spreadsheet takes more than a few seconds to calculate you need FastExcel profiler to find out and prioritize the reasons for the slow calculation. FastExcel Manager contains tools to help you build, debug and maintain Excel workbooks. SpeedTools provides you with a state-of-the-art tool-kit to help you speed up your Excel Calculations
see https://www.youtube.com/watch?v=EWUeZt02pho
10 Tips to Optimize & Speed up Excel Formulas http://chandoo.org/wp/2012/03/20/optimize-speedup-excel-formulas/
Excel formulas acting slow? As part of our Speedy Spreadsheet Week, today lets talk about optimizing & speeding up Excel formulas. Use these tips & ideas to super-charge your sluggish workbook. Use the best practices & formula guidelines described in this post to optimize your complex worksheet models & make them faster. ET MR Macros.docx
10 ways to improve Excel performance
http://www.techrepublic.com/blog/10things/10-ways-to-improve-excel-performance/2842?tag=nl.e072
Takeaway: You don’t have to live with sluggish workbooks. Try these tricks for a noticeable boost in performance. Most Excel files are small enough not to affect performance, but size isn’t the only thing that can slow things down. Fortunately, you don’t have to know all about multithreads and dual processors to eliminate bad performance. The following tips are easy to implement, so even the most casual users can improve performance when a workbook slows down. Better yet, apply this advice when designing sheets to help avoid sluggish performance altogether. ET MR Macros.docx
7 Reasons why you should get cozy with Index()http://chandoo.org/wp/2013/09/18/index-formula-usage-and-tips/
Of all the hundreds of formulas & thousands of features in Excel, INDEX() would rank somewhere in the top 5 for me. It is a versatile, powerful, simple & smart formula. Although it looks plain, it can make huge changes to the way you analyze data, calculate numbers and present them. It is so important that, whenever I teach (live or online), I usually dedicate 25% of teaching time to INDEX().ET MR LOOKUPs.docx
75 Excel Speeding up Tips Shared by YOU! [Speedy Spreadsheet Week]
http://chandoo.org/wp/2012/03/27/75-excel-speeding-up-tips/
As part of our Speedy Spreadsheet Week, I have asked you to share your favorite tips & techniques for speeding up Excel. And what-a-mind-blowing response you gave. 75 of you responded with lots of valuable tips & ideas to speed-up Excel formulas, VBA & Everything else. ET MR Macros.docx
Big trouble in little spreadsheet http://chandoo.org/wp/2014/01/17/big-trouble-in-little-spreadsheet/
I pointed out that if you ever find yourself having to switch calculation to Manual, there’s probably something wrong with your spreadsheet.
This prompted one of the participants to come to me for advise regarding restructuring a spreadsheet with that very problem. This analyst had a file with only 6000 rows of data in it, but the file size was something like 35MB, and after each and every change she had to wait at least a minute for the file to recalculate before she could do something else.
It turns out there were two problems with her files that were easy to resolve. ET MR Macros.docx
Circular References: Calculation, Detection, Control and Removalhttps://fastexcel.wordpress.com/2015/09/14/excel-circular-references-calculation-detection-control-and-removal/
Excel circular references occur either when a formula refers to itself or when a chain of formulas links back to it’s starting point.
Most of the time circular references are created by mistake (unintended circular references) and should be corrected. They can also be used to solve iterative or goal-seeking problems in Finance and Engineering.
Handle Volatile Functions like they are dynamite http://chandoo.org/wp/2014/03/03/handle-volatile-functions-like-they-are-dynamite/
If you’re building large models, then you may want to use volatile functions – including OFFSET(), INDIRECT(), and TODAY() – with caution, because unless you know what you are doing, they *might* slow Excel down to the point that data entry is sluggish, if not downright tedious.
In fact, you *might* want to consider getting out of the habit of using these functions at all if there are alternatives, and you might want to replace volatile functions in your existing models with non-volatile alternatives…I have reduced recalculation time in large models from minutes to milliseconds by doing just that! ET MR Macros.docx