i am almost one of the first users of motime in china,however my blog still needs more attention.
buzzo
Cabbage
datelife
E-mail me
jjruci [Moi]
leylop
lorreta
mishazhang
moonflower
Over the Rainbow
quietning's fotos
Reed
The-Insight.com
yangzi
today
November 2005
October 2005
September 2005
August 2005
July 2005
June 2005
May 2005
April 2005
March 2005
February 2005
January 2005
December 2004
November 2004
October 2004
September 2004
August 2004
July 2004
June 2004
May 2004
April 2004
March 2004
February 2004
January 2004
December 2003
November 2003
October 2003
September 2003
visited *loading* times
The best gift I got before the national day
This pic is the best gift I got before the national day. My wife painted it with her computer. It is so nice. I was so happy and even wet my eyes.
I am so luck to have you as my wife, I want to say.
Click here to see how she painted it.
Incredible solution!
一次关于EXCEL的使用求助，记在这里，作者的答复实在令人叹服。
问题：求一串数字随机相加，所有产生的可能的和。例如给出1，2，3 三个数，显示：1+0，2+0，3+0，1+2，1+3，2+3，1+2+3的结果。
Solution by Harlan Grove：
I've always disliked parsing approaches that use dummy characters as
placeholders. I also dislike the B1&A1&B1 because it involves an
unnecessary concatenation.
If this formula would be used a lot, then there's cause to use a
defined name like seq referring to =ROW(INDIRECT("1:1024")). Then you
could use the array formula
=SUM(IF(MID(B1&A1,seq,1)=B1,--MID(A1,FIND(B1,B1&A1,seq),
FIND(B1,A1&B1,seq+1)-FIND(B1,B1&A1,seq))))
to sum the numbers in the string. Without the defined name, it becomes
=SUM(IF(MID(","&A1,ROW(INDIRECT("1:1024")),1)=",",--MID(A1,
FIND(",",","&A1,ROW(INDIRECT("1:1024"))),
FIND(",",A1&",",ROW(INDIRECT("2:1025")))
-FIND(",",","&A1,ROW(INDIRECT("1:1024"))))))
As for the OP's follow-up asking for a way to calculate the sums of all
subsequences of the sequence in A1, it can be done with formulas, but
it's MESSY & INEFFICIENT. But when have I ever let that stop me?
Step 1: parse the sequence in A1 into single numbers in separate cells
using Data > Text to Columns, and name the resulting range nums. For
the OP's example, this would be 6 numbers.
Step 2 Select a 63 (2^6-1) row by 1 column range and enter the array
formula
=MMULT(MOD(INT(ROW(INDIRECT("1:63"))/2^{5,4,3,2,1,0}),2),
TRANSPOSE(nums))
点击这里看求助过程。
昨夜
Middle-Autumn day
北京 阴 凉爽 舒适
虽然没有月亮，但是心情很不错，因为提前一天就看到了那又大又圆的，甚至有点不真实的月亮。我拍摄下来了，但效果不是很好，但总比8月15没有的好。
我和羊子礼拜回来，买了很多地蔬菜，开始做饭、吃饭、给家里打电话。记得大学的时候，到了中秋节，电话特别难打，路边所有的公用电话都要排好长的队伍，但是大家仍然有秩序地耐心的等待，为的是将一句祝福送回家。
明天再写。
好，先插一幅图。
当天晚上我还给我的好友们发了短信，愿我的祝福如明晚的月光流淌。现在想起来，岂不是因为阴天，我的祝福没有到？那就祝福云彩吧。
海涛给我发了一个短信，关于希望在月圆之夜掳嫦娥送我做二奶，杀玉兔给我补肾的美好祝愿，我也给老米转发了。
不过愿望总归是愿望，一点非分之想都没有。真地。
Rainbow 无处不在
早上办公室前面拍到的。
秋天来了
秋天来了，树叶黄了，一片片叶子从树上落下来。有的落在草地上，蚂蚁爬上去，当作运动场；有的落在小湖边，在水面上荡漾起层层波纹。
一行大雁往南飞，一会儿排成了人字，一会儿排成了一字。
高高的天上看不见一片白云，天气凉了。
啊哈哈，秋天真地来拉！！
Template by Splinder.com | header image credit: Markus Gann © www.begann.de