Four ways to speed up Excel calculation time

Complex formulas and repeated references can bog Excel down in a hurry. These basic rules will help optimize your workbook operations.

---

How, when, and what Excel calculates is a huge subject. In general, cell references and calculation operations are the main performance vampires. Reasonable formulas and even lots of data don’t usually slow things down. Complex formulas and repetitive references are the real culprits. Here are a few basic guidelines that should help you avoid calculation bottlenecks:

• Avoid complex and array formulas. Use more rows and columns to store intermediate values and use fewer complex calculations.
• Reduce the number of references in each formula to the bare minimum. Copied formulas are notorious for repeating references and calculations. Move repeated calculations to a cell and reference that cell in the original formula.
• Always use the most efficient function possible: Sort data before performing lookups; minimize the number of cells in SUM and SUMIF; replace a slow array with a user-defined function, and so on.
• Avoid volatile functions if possible. Excel recalculates these functions with each recalculation, even if nothing has changed. Too many volatile functions (RAND(), NOW(), TODAY(), and so on) can slow things down.

---

Miss an Excel tip?

Check out the Microsoft Excel archive and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Use ‘shake to shuffle’ mode from mini-player

While playing around with my iPhone last night, I found that the ‘shake to shuffle’ feature will work from the mini-player that pops up on your screen after a double-tap of the home button. To enable the mini player (i.e. the iPod controls), go to Settings » General » Home Button, and select iPod controls.

The only issue I have had was that when I really shake the iPhone, it goes to landscape mode and freaks out.

FitHorse (healthcare & fitness)

FitHorse 1.0

Category: Healthcare & Fitness
Price: $0.99 (iTunes)

Description:

Horse’s bodyweight estimation by measuring the girth size



The fitness of your horse is closely related to its bodyweight. Each horse has an optimal bodyweight which contributes to exercise performance (for racing, endurance, jumping and dressage). In addition, the diet should be in accord with the body weight changes. This simple application will assist you to assess the bodyweight of your horse for a better training and diet management. By measuring the girth size with a tape (in centimeters), you will immedialtely obtain the bodyweight estimation with a quite good accuracy of 10%. This method is more accurate than any subjective evaluation which underestimate the bodyweight. If you have no access to a scale, this application will be useful for you to assess the fitness of your horse.



How to use it ?

Adjust the tape around the trunk at the level of the girth and measure the gith size as exactly as possible in meter and centimeters. Enter the value into the field ‘girth size’ and clic on ‘calculate button’ to read the bodyweight estimate in kilograms. For example: you enter 1.85 m and the calculated weight is 494 kg.



Caution:

Use this method only for saddle horses, throroughbreds and standardbreds (girth size between 1.50 and 2.15 meter).

Do not use this method for drug prescription without veterinary advice.



More information available at : www.equimetrix.com/Pages/Fithorse_en.html

One plastic tape is available to read directly the weight in pounds or kilograms.

FitHorse

Eye Center‐For Adult  (healthcare & fitness)

Eye Center‐For Adult  1.0

Category: Healthcare & Fitness
Price: $1.99 (iTunes)

Description:

How good is your vision? Test your eyesight here! This app provides you with great self-exams you can do at home. This app, Eye Center, allows you to recognize possible sight defects.



There are two versions of Eye Center, Eye Center-For Adult and Eye Center-For Child. Each test shows the purpose, step and result.



“VA Test” is to measure the clarity of vision or the ability of the visual system to resolve detail.



“R-G Test” lets you know that you have myopia or hyperopia. It also lets you know whether your spherical lens is full correction or not.



“Astigmatism Test” lets you know whether you have astigmatism or not. It also lets you know whether your lens is full correction or not.



“Color Test” is to screen for acquired or hereditary color vision defects.



“Stereopsis” is to measure your fine depth perception through your ability to fuse stereoscopic targets.



Eye Center-For Adult include “Amsler Grid”, “Visual Field” and “Stereography”.

Eye Center-For Child include “Worth 4 Dot”, “Eye-Hand Coordination” and “Fun Test”.

Eye Center‐For Adult 

Книги I. Ф.М.Достоевский. (books)

Книги I. Ф.М.Достоевский. 1.0

Category: Books
Price: $4.99 (iTunes)

Description:

[ RU ]

Книги I. Ф.М.Достоевский.

Полное собрание сочинений.

Книга третья из серии "Русская Классическая Литература".



ПРАВИЛА.



1) Выберите в меню "Содержание", интересующий Вас текст. Окно просмотра окроется в момент орыва кончика пальца от экрана iPhone.

2) Для просмотра текста, "листайте" его сдвигая кончиком пальца вверх или вниз.

3) Для вызова меню управления дотроньтесь до слова "Меню" в левом нижнем углу экрана.

4) Для отмены меню, дотроньтесь до текста.

5) Для быстрого возврата в начало текста, где находится Оглавление, дотроньтесь до часов.

6) Колтичество закладок ограничено (15шт.), но запоминается место, где вы остановились для каждого текста.





СОДЕРЖАНИЕ



БЕДНЫЕ ЛЮДИ (1845)

БЕЛЫЕ НОЧИ (1848)

БЕСЫ (1871-1872)

БОБОК (1873)

БРАТЬЯ КАРАМАЗОВЫ (1880)

ВЕЧНЫЙ МУЖ (1869)

ГОСПОДИН ПРОХАРЧИН (1846)

ДВА САМОУБИЙСТВА (1876)

ДВОЙНИК (1846)

ДОМОВОЙ (1880)

ДЯДЮШКИН СОН (1859)

ЁЛКА И СВАДЬБА (1848)

ЗАПИСКИ ИЗ МЁРТВОГО ДОМА…

ЗАПИСКИ ИЗ ПОДПОЛЬЯ (1864)

ЗИМНИЕ ЗАМЕТКИ О ЛЕТНИХ…

ИГРОК (1866)

ИДИОТ (1868)

КРОКОДИЛ (1865)

КРОТКАЯ (1876)

МАЛЕНЬКИЙ ГЕРОЙ (1862)

МАЛЬЧИК У ХРИСТА НА ЁЛКЕ…

НЕТОЧКА НЕЗВАНОВА (1848)

ПЕТЕРБУРГСКИЕ СНОВИДЕНИЯ

ПОДРОСТОК (1875)

ПОЛЗУНКОВ (1848)

ПРЕСТУПЛЕНИЕ И НАКАЗАНИЕ

РОМАН В ДЕВЯТИ ПИСЬМАХ…

СЕЛО СТЕПАНЧИКОВО И ЕГО…

СКВЕРНЫЙ АНЕКДОТ (1864)

СЛАБОЕ СЕРДЦЕ (1848)

СОН СМЕШНОГО ЧЕЛОВЕКА…

УНИЖЕННЫЕ И ОСКОРБЛЁН…

ХОЗЙЯКА (1847)

ЧЕСТНЫЙ ВОР (1860)

ЧУЖАЯ ЖЕНА И МУЖ ПОД…

*ДНЕВНИК ПИСАТЕЛЯ (1873)

*ДНЕВНИК ПИСАТЕЛЯ (1876)

*ДНЕВНИК ПИСАТЕЛЯ (1877)

*ДНЕВНИК ПИСАТЕЛЯ (1880)

*ДНЕВНИК ПИСАТЕЛЯ (1881)

*ПУШКИН (1880)









АННОНС.



В разработке находятся книги для iPhone этой серии:



1) М. Цветаева. Поэзия.

2) Пушкин А.С. Собрание сочинений.

3) А. Ахматова. Поэзия.

4) А. Блок. Поэзия.

5) Н. Гоголь. Собрание сочинений.

6) В. Маяковский. Поэзия.





Приятного Вам чтения!



[ JP ]

ロシア文学、ロシアンクラシックシリーズ

ドストエフスキー全集





[ EN ]

Russian Literature, Russian Classics Series

F.M. Dostoevsky. Complete works.
Книги I. Ф.М.Достоевский.

Ice vs fire 3D (games)

Ice vs fire 3D 1.0

Category: Games
Price: $0.99 (iTunes)

Description:

Sale until version 2.0!



You are ice king in the middle of volcano on floating ice being attacked from all sides by fireballs and monsters.

Survive as long as possible using 7 weapons.
Ice vs fire 3D

Aus History (education)

Aus History 1.0

Category: Education
Price: $0.99 (iTunes)

Description:

Need to brush up on your history before your exams? Want to compete with your friends about who knows the most history? Then this app is for you!



This app picks 10 random questions from more than 100, and challenges you to pick the right answer from 4 different options.



With topics ranging from the sacking of Gough Whitlam to how long Indigenous Australians have been in Australia, this app covers a lot of ground.



A must have for every history buff and school student out there.
Aus History

DeeGay (music)

DeeGay 1.0

Category: Music
Price: Free (iTunes)

Description:

Listen to the three channels of Radio DeeGay on your Iphone. Radio DeeGay is the first Italian webradio dedicated to the GLBT world. Hits music channel of the moment with information and items dedicated to the public and gay friendly. A channel of the great successes of the past with the most beloved gay icons national and international. House music channel innovative: 24 to 24 hours a compilation mixed live with the songs most played in clubs in trend around the world. 
Radio DeeGay: Born to be on line!
DeeGay

Mercutio (games)

Mercutio 1.0

Category: Games
Price: $1.99 (iTunes)

Description:

Remember the first time you fell in love with a game? Something seemingly simple but so habit forming you couldn't put it down. Try Mercutio!



Mercutio is an original new abstract puzzle game. Simple yet captivating!



Mercutio challenges your ability to evaluate alternatives and plan ahead. Perfect for those moments when you can't get involved in anything too complicated but want something engaging to fill the time. Spontaneous solo fun for all ages.



The rules are simple. Place one token at a time to create groups of four differently colored tokens. Overlap groups as much as possible to earn the highest score. Groups of four can be made either horizontally, vertically, diagonally or in a two by two square.



Features:

* 200 Levels with varying degrees of difficulty.

* Tracks overall high score, number of games played, number of levels played, high score on each level, and average game score.

* Quick start to play, fast to shut down.

* Auto Save: Game progress is quickly and fully saved for future play.

* Unlimited replay of levels to improve your high score.

* Play anytime. In a long line at the grocery store or whenever you are stuck waiting for a few minutes.

* Status bar and clock always visible so you don't loose track of time.

* Social gaming features and international high scores supported by OpenFeint.

* First in a trilogy of engaging puzzle games from Aaron Cohen Software.



Aaron Cohen Software was founded to create intelligent apps for discerning people. Our company was started by a husband and wife team who have complementary talents and enjoy working together. We are currently focusing on a series of puzzle games designed to exercise your mind in an intriguing and delightful manner.

Mercutio

myTactsFree (utilities)

myTactsFree 1.1

Category: Utilities
Price: Free (iTunes)

Description:

myTacts helps you cross-reference your contacts in a way convenient to your personal or business needs whether in Sales, Financial, Management, Legal, Travel or Event Planning.



▲ Categorize contacts in Family, Friends, Work, Prospects, Clients, Suppliers or Leisure (free version limits this to Family, Friends and Work).



▲ A contact can be assigned to multiple categories (e.g. Friends and Work).



▲ View a synopsis of Full Names, Title, Organization, Department and "Top Note" at all times. Never forget that person you just met.



▲ Filter by Organization and Department (or Team).



▲ New Contacts entered under an Organization inherit the currently selected Category along with Organization and Department.



▲ Family and Friends are sorted by First Name while All other Categories are sorted by Last Name.



▲ Dial, Email or Surf to the website of any contact by touching the relevant field in the contact detail.



▲ Restores Category, Organization, Department and/or Contact previously selected when restarted.



▲ myTacts gives speedy access – Ready when you need it.



▲ Inherit your contacts from any other Contacts application.



▲ Synchronize your contacts with Mac, Outlook, Yahoo, Google or Mobile Me.



▲ New upgrades will be provided – we want to hear your feedback. Be sure to upgrade to keep up-to-date with new features we have planned.



myTactsFree

« Previous Page — Next Page »