I'm leaving the internet for a year | The Verge

Inspiring and refreshing.

List of Essential Mac apps

My old-time roommate asked me to recommend Mac apps. So I made this list:

Tips on Excel Formula


  1. type = into the cell to display the result of a formula. use ctrl+shift+enter to enter an array or multi-select cells.

  2. Format: “example text string”. {1,0,1,0} is an horizontal array constant and {“Sun”;”Mon”;”Tue”} is a vertical array.

  3. To convert a formula to text, just remove the initial equal sign (=). When you’re ready to return to editing the formula, insert the initial equal sign to convert the cell contents back to a formula.

  4. <> means Logical comparison (not equal to)

  5. : (colon)Range. Produces one reference to all the cells between two references.

  6. , (comma)Union. Combines multiple cell or range references into one reference.

  7. (single space)Intersection. Produces one reference to cells common to two references.

  8. & joins (concatenates) the two literal text strings (each enclosed in quotes) to produce a new text string: Part-23A: =”Part-“&”23A”

  9. =OR(A1=100,A1=1000) =AND(A1<100,A2<100)

  10. A better approach is to insert the sales tax rate11. into a cell and use the cell reference in place of the literal value. This makes it easier to modify and maintain your worksheet.

  11. Sometimes, however, you may want to control when Excel calculates formulas. For example, if you create a worksheet with thousands of complex formulas, you may find that things can slow to a snail’s pace while Excel does its thing. In this case, you can set Excel’s calculation mode to Manual. Do this by choosing Formulas Calculation Calculation Options Manual.

  12. If the entire cell fills with hash marks (#########), this usually means that the column isn’t wide enough to display the value. You can either widen the column or change the number format of the cell. The cell will also fill with hash marks if it contains a formula that returns an invalid date or time.

  1. =SUM(DailySales)*CommissionRate. As you can see, using names instead of cell references makes the formula self-documenting and much easier to understand.

  2. to define name, click “insert-name-define”

  3. INDEX is used to take out a single cell from a multi-cell name. =INDEX(DataRange,2) is the value of the 2nd cell in DataRange

  4. referring to a cell using its name is like “=SUM(Sheet1!UnitsSold)” or “=SUM(UnitsSold)”

  5. Relative: The reference is fully relative. When the formula is copied, the cell reference adjusts to its new location. Example: A1

  6. Absolute: The reference is fully absolute. When the formula is copied, the cell reference does not change. Example: $A$1

  1. Function (such as SUM and PROPER)contains and simplifies your formulas. Note that name is function too.

  2. PROPER convert “JOHN F. CRANE” to “John F. Crane”

  3. LARGE(A1:A100,3) find the 3rd largest value in the range A1:A100

  4. To add a space between the two entries (to get Tucson Arizona), use a formula like this one: =A1&” “&A2

  1. counting and summing: Part II Chapter 7

  2. Lookup is lookup: Part II Chapter 8

  1. Normally, you press Enter to enter a formula. Because this is an array formula, however, you press Ctrl+Shift+Enter.

  2. Select an array for output - right click and select insert function - write =B16:B26*C16:C26 and hit Ctrl+Shift+Enter

  3. To display this array in a range requires five consecutive cells in a single row. To enter this array into a range, select a range of cells that consists of one row and five columns. Then enter ={1,2,3,4,5} and press Ctrl+Shift+Enter.

  4. When you enter an array formula into a cell or range, you must follow a special procedure so Excel knows that you want an array formula rather than a normal formula. You enter a normal formula into a cell by pressing Enter. You enter an array formula into one or more cells by pressing Ctrl+Shift+Enter. You can easily identify an array formula because the formula is enclosed in curly brackets in the formula bar. The following formula, for example, is an array formula: {=SUM(LEN(A1:A5))} Don’t enter the curly brackets when you create an array formula; Excel inserts them for you after you press Ctrl+Shift+Enter. If the result of an array formula consists of more than one value, you must select all of the cells in the results range before you enter the formula. If you fail to do this, only the first element of the result is returned.

Steve Jobs - A book review

  A miraculous oneness of 1960 American counterculture, Zen, art and tech.
  Special. Enlightened. Binary.
  Straightforward. Restrained. Passionate.
  The pirate against authority.
  The rebel against the status quo.
  The MythBuster.
  He is THE product guy.
  And his best product is not any Mac or iPhone,
  but Apple itself:
  Apple as a team or as a cult.
  The particularly interesting part is how he grew up, knowing he is adopted. Many brilliant guys touched his life. Following his intuition he did what he loved. His hand is alway busy, feet always swift. He has “a strong foundation when the wind of changes shift”. He is, Forever Young.
  It’s shocking to see him standing unprecedentedly in the intersection of liberal arts & tech, and also in the intersection of Zen Buddhism & capitalism entrepreneurship! He do have a beginner’s mind, ready to conceive of and receive anything. He likes to control the whole experience, making Apple ride on a vertically integrated business model. He appreciates techniques, simplicity and beauty that most people don’t even notice.
  And “One More Thing”: oh the man got great taste!

回头再想 Into the Wild,我不想否定他偏要逃离社会,他最终困死荒野也不是重点,我只是觉得他的生命完全有另外的可能。世外桃源平复不了内心漩涡,宁静幸福也未必在曲径通幽处。存在当下,禅即是禅。

"The trouble with capitalism is that…it destroys the human possibilities it creates. It fosters, indeed forces, self-development for everybody; but people can develop only in restricted and distorted ways. Those traits, impulses and talents that the market can use are rushed (often prematurely) into development and squeezed desperately till there is nothing left; everything else within us, everything nonmarketable gets draconically repressed, or withers away for lack of use, or never has a chance to come to life at all."

Marshall Berman “All that solid melts into air: the experience of modernity”