I’m a little confused, because I was told American people are polite, but I don’t think they are polite enough to say hello to strangers in the which they passed by. I told my wife my confusion, she laughed, ” They looked at us because they were confused why we opened umbrella in the car!”

1、数据挖掘概述

-数据挖掘，顾名思义就是从大量的数据中挖掘出有用的信息。数据挖掘技术主要又分成“关联规则”、“时间序列”、“聚集”、“分类”、“估值”等几类
-数据挖掘大部分的价值在于利用数据挖掘技术改善预言模型

2、数据挖掘文化

-知识发现文化（KD）：输出的是规则；
-预言模型文化（PM）：输出的是预言模型；
共同点：
-两种文化输入的都是学习集；
-目的都是尽可能多地自动化数据挖掘过程；
-数据挖掘过程并不能完全自动化，只能半自动化；

3、数据挖掘过程

-计划/准备
-数据采集
-数据建模
-模型检验

4、数据挖掘系统

代      特征                   算法               集成                                   计算                                数据
1    独立应用     一个或多个算法     独立系统                                单个机器                        向量数据
2    数据仓库集成  多个算法    数据管理系统                            计算机群集       对象,文本,连续媒体数据
3    预言模型集成  多个算法    数据管理和语言模型系统        网络计算          半结构化数据和WEB数据
4    移动数据联合  多个算法   数据管理,语言模型和移动系统    移动和各种计算设备   普遍存在的计算模型

5、数据挖掘发展趋势

-集成
第二代、第三代、以及第四代数据挖掘和预言模型系统将与数据仓库合并，以提供一个集成的系统来管理日常的商业过程。
-嵌入
另一方面，二、三、四代数据挖掘技术将不断发展和成熟，能够和各种应用集成，成为一种嵌入式的技术。

二、基本算法

1、信息论方法

-ID3方法
利用信息论中信息增益寻找数据库中具有最大信息量的字段，建立决策树的一个节点，并根据字段的不同取值建立树的分枝，在每个分枝子集中重复建树的下曾层节点和分枝的过程，建成决策树。
-IBLE方法
利用信息论的信息容量寻找数据库中的信息量从大到小的多个字段的取值建立决策规则树。

2、集合论方法

-粗集方法
-概念树方法
-AQ系列方法：覆盖所有正例，排斥所有反例的思路寻找规则

3、人工神经网络方法

-前馈网络
-含感知机、反向传输模型、函数式网络
-反馈式网络
-用于联想记忆和优化计算
-自组织网络
-用于聚类
-用于非线性系统构建数学模型

4、遗传算法

-模拟生物进化过程的方法
-用于寻找全局最优策略，最优解的有效方法

5、统计分析方法

-数据特征分析
-假设检验方法
-相关分析
-回归分析
-差异分析
-因子分析
-聚类分析
-判别分析
-时间序列分析
-可靠性分析
…

6、可视化技术

-可视化数据分析技术拓宽了传统的图表功能，使用户对数据的剖析更清楚。例如可把数据库中的多维数据变成多种图形，对于揭示数据中的状况、内在本质以及规律性起到很大作用。

7、运筹学方法

-用定量化方法为管理决策提供科学依据的学科
-线性规划方法
-非线性规划方法
-网络规划方法
-动态规划方法
-决策和对策方法
-排队论
-库存理论
-统筹方法

8、其它方法

-小波分析方法——信号分析和处理的新方法，适用于对经济数据的分析；
-蒙特卡罗方法，也就是随机模拟方法，应用面极广，算法简单，非常有效，缺点是精度不高，通常与其它方法相结合使用；
-分形市场理论——经济数据分析的新方法；
-统计物理学方法——运用物理分析和物理实验方法分析市场风险。

三、常用工具

1、SAS

-SAS系统是一个组合软件系统，它由多个功能模块组合而成，其基本部分是BASESAS模块。在BASESAS的基础上，还可以增加如下不同的模块而增加不同的功能：SAS/STAT（统计分析模块）、SAS/GRAPH（绘图模块）、SAS/QC（质量控制模块）、SAS/ETS（经济计量学和时间序列分析模块）、SAS/OR（运筹学模块）、SAS/IML（交互式矩阵程序设计语言模块）、SAS/FSP（快速数据处理的交互式菜单系统模块）、SAS/AF（交互式全屏幕软件应用系统模块）等等。

2、SPSS

-SPSS一共由十个模块组成，其中SPSSBase为基本模块，其余九个模块为AdvacedModels、RegressioModels、Tables、Treds、Categories、Cojoit、ExactTests、MissigValueAalysis和Maps，分别用于完成某一方面的统计分析功能，他们均需要挂接在Base上运行。除此之外，SPSS完全版还包括SPSSSmartViewer和SPSSReportWriter两个软件，他们并未整合进来，但功能上完全是SPSS的辅助软件。

3、STATA

-高效快速统计软件，功能强大，使用方便

4、S-PLUS

-S-PLUS就是从AT&T的S语言（Statisticallaguage，即统计语言）发展而来的，其语法和使用方式充满着数理统计的特点（比如说，向量、矩阵、数组等就是其最基本的元素），非常适合有数理统计背景的研究人员使用。

5、MIITAB

-MiiTab也是国际上流行的一个统计软件包，其特点是简单易懂，因而普遍认为该软件适合学生使用。

6、Statistica

-Statistica也是一个国际上常用的统计分析软件，他在操作方式上和SPSS非常类似，但运算速度极快，几乎是全工具栏操作，鼠标右键菜单真正可以做到一键启动，操作灵活简单，易学易用。它具有数理管理软件、统计分析软件、绘图软件和矩阵计算软件的功能，又在许多方面别具一格。

7、MATLAB

-MATLAB语言是当今国际上科学界(尤其是自动控制领域)最具影响力、也是最有活力的软件。它起源于矩阵运算，并已经发展成一种高度集成的计算机语言。它提供了强大的科学运算、灵活的程序设计流程、高质量的图形可视化与界面设计、便捷的与其他程序和语言接口的功能。几乎全能的软件。
-拥有几十个工具箱，包括数理统计学、数字信号处理、最优化、模糊数学、神经网络、金融学、时间序列分析、衍生产品、小波变换、模型预测工具、数据库、系统辨识、仿真等。

把*************换为汽车的VIN.

我定了2月17日的飞机，希望一切顺利。

转帖《波士顿环球报》刊登一篇文章，“为了找到好工作现在要做的20件事”，给我以督促吧！

一、走出图书馆。大学是四年人生经验，不是高学分。在美国的大学，课外活动常常和功课一样重要。

二、在你的宿舍里开始做生意。雅虎、谷歌都会争先恐后地买你弄出来的网站。谷歌本身就可以归于大学宿舍里诞生的买卖。

三、别债务缠身。在普通的州立大学和名牌但昂贵的私立大学之间，最好选择前者。从个人前途上看，无债一身轻比花钱买个名牌要有利得多。

四、积极参加校园的活动。通过这种活动，可以学会怎么理解、帮助别人，满足别人的需要和别人沟通。这在美国文化中，是所谓“领袖素质”的基础。找工作时会被别人另眼相看。千万不要认为自己的生活只有校园而已。

五、不要读文科博士，除非你离了学术不能活。读博士对实际工作毫无帮助。

六、别上法学院。律师总是代表别人去争利，压力奇大。自杀是律师中第一号非正常死亡的原因。

七、参加体育运动。调查表明，大学从事体育的人，毕业后比那些不沾体育的同学明显收入高。美国人从事体育不仅是锻炼身体，而且是培养竞争的才能和领袖素质。一个大学运动队的队长到华尔街找工作，优势不可限量。

八、别按着父母的期待生活，要干自己喜欢的事情。前惠普女CEO说过：“千万别出卖你的灵魂！”

九、干一些你并不擅长的新事物。你对自己未必了解，这是苏格拉底给人类的教诲。所以，请给自己一个机会。

十、以自己为中心来定义成功，别以外在的东西(比如金钱)来定义成功。

十一、好工作要自己去找，不要等着天上掉馅饼。

十二、选修关于“幸福”的心理课程。在哈佛，这一课程是最热门的课之一。

十三、上表演课。美国社会整个就是个舞台。从教授、政治家、企业总裁，到律师、将军、记者，不会表演就很难出头。

十四、学会赞美别人。在生活中，既要当好演员，也要当好观众。很多时候我总是感觉和别人有距离，其实就是缺那简单的几句问候和一个拥抱。

十五、使用职业咨询服务机构。美国大学一个重要部门就是求职咨询机构。专业人员帮你分析自己的长短，以及就业市场，帮助你准备面试，修改申请信。

十六、被拒后应该坦然以对。要自己定义自己，不要用外在指标定义自己。

十七、要傲视名校，别觉得上了哈佛有多么了不起。

十八、不要过分追求完美，不要给自己不必要的压力。生活不止是工作，学习，它还有很多很多。

十九、要靠打工读完大学，积累工作经验。这很重要，大部分中国学生做不到，甚至认为打工没有必要，其实打过工的人才会真正珍惜生活。

二十、把你的目标列成表，因为你没有计划就不可能成功。不要整天没事干老胡思乱想，只有真正的行动才能拯救你！

不止员工，它们的客户也在获取最佳体验。它们的表现有目共睹：7天连锁，经济型酒店的后来者，仅用4年时间和老大“如家”一样火爆，无论市场冷暖，平均入住率都保持在90%以上（含新店），成为经济型酒店的“双引擎”之一；40度高温的北京夏天，挥汗如雨的人们不计较在室外排着长队，等着吃一顿更热更辣的海底捞火锅；潮宏基拿着黄金宝石等贵重物料的工人，可以不经任何检查自由进出厂区，松散的管理并未让偷盗成行，反而有着业内最低的物料损耗。

匪夷所思的是，这几家企业们的管理者却比同行清闲。海底捞的张勇每周只工作两三天，时不时跑到四川阿坝森林里“散心”；潮宏基的廖创宾只要不出差，总是悠闲地到食堂吃饭，然后悠闲地回到办公室喝功夫茶；7天的郑南雁忙一点，早晨6点就起床看书，不过他看的书和酒店管理丝毫没有关系，都是历史、政治等“闲书”，尤其爱读老庄。

和这几位管理者谈话有趣而惬意。他们不会描绘多么宏大的公司使命愿景，也不会拘泥于枯燥的财务数字和繁琐的细节流程。时而八卦趣闻，时而坐禅论道，海阔天空，和他们标新立异的管理一样，看似不着边际，却统一在一个更庞大的系统内，让人几天之后偶然想起，赞叹其精妙。

7天酒店CEO郑南雁最有代表性。见到郑南雁时，他还没从广东商会的北欧考察转过来频道：“见到了非常漂亮的北欧美女；还碰到一个老外，穿着像MIB（电影《黑衣人》），拉着我讨论老庄好几个小时。”让他觉得更好的是北欧宽容的社会环境，“发自内心的宽容，人人平等。并非儒家的‘水能载舟亦能覆舟’，那是强势群体对弱势群体的宽容，前提是水还是要在舟下面。”

“每个人都是平等的，有时候我们犯错是因为觉得自己太重要。”郑说。如同放羊，羊比牧羊人知道哪里水草丰美，偶尔微调羊群的方向，一个牧羊人能放1000只羊。

郑的“放羊理论”有些老庄“无为而治”的味道。店长有很大的自主权，不用凡事等待总部的命令，总部提供收益、销售、人事和服务的四线支持。员工都希望自己能快乐工作，只要员工和公司目标一致，总部只需要适当调整，管理成本就能大幅度降低。

2009年，7天的分店规模已近300家，放羊理论之下，总部参与运营管理的人数依然保持在350人左右，“和100家店需要的人数一样”。“论‘拧毛巾’的能力，我们可能没别人强。”郑说，作为服务行业的CEO，“我要思考背后应该有什么样的体系，让员工不去关注上级或是公司领导而是关注客人，让7天成为客人的朋友。”

如何让员工去跟客人交流无法靠量化、规定。即便作出“每次微笑露出6到8颗牙齿”这样的规定也无法监督实施。郑南雁和员工说得很直白，要想过得好就要自己努力，没有人是救世主，都是自己的事情。他试图让7天的一线员工明白，快乐的对待客人，客人就能给他快乐。

海底捞亦然。有时海底捞服务周到得让人瞠目结舌，散着头发的客人会得到皮筋，并被善意提醒，“小心头发溅油”；戴眼镜的客人会得到眼镜布；有的店面等候区甚至提供免费的美甲服务。

这些细致的主意显然不是粗枝大叶的创始人张勇能想出来的。他性格直爽，偶尔强势，在公司有绝对的权威。有人对海底捞的某项创新服务赞叹不已时，他会张大嘴“啊，我听你说才知道”。

他更关心员工的生活本身。员工宿舍离工作地点不会超过20分钟，全部为正式住宅小区，且都会配备空调；有专人负责保洁以及洗衣服；公寓甚至配备了上网电脑；如果员工是夫妻，则考虑给单独房间……仅是住宿一项，一个门店一年就为此花费50万元。

“只要让员工把注意力放在顾客身上，员工就比我们更懂得顾客要什么。”张勇说，“海底捞没有特别的激励机制——不过一位18岁的农民工，从门童做起，10年就在北京买了房子，难道这不是最好的激励吗？”张勇指的是袁华强，现年28岁任北京上海区域负责人。每一位基层员工都能看到，他们的上级是这样一步一步做出来的，环境相对公平，自然有好的服务。

比尔·盖茨懂得程序员的需要，程序员回报给他一个微软。北大光华管理学院客座教授黄铁鹰以此做类比，张勇懂得农民工需要的公正和公平，员工回报给他相对其它餐饮公司三倍的翻台率、两倍利润。

“7天有今天的发展是个传奇，放羊理论的成功实际上就是‘老庄的无为而为’的思想在现代企业管理实践中的成功。”人力资源管理专家、系统排列导师石明泉如是评价。

石明泉分析，无为不等于不为，克制不等于放弃。西方现象学主张：看待纷繁复杂的系统现象，需要不带任何主观思想，不带任何企图，保持克制，才能有机会看到事物演变过程中的真相和规律。这类似于中国佛家的禅和道家的无为。

这些创新公司的相同之处是，首先都建立了一个完善的平台，每个人都有相应的位置；其次，CEO都承认每个人的作用是不可替代的，不越俎代庖。公司放权于每个位置，可以自主发挥，不过放权和收权的尺度需要定下原则。

“郑南雁充分尊重每个人的位置，但其背后强大的IT系统平台和管控机制是无为而为的保证。”石明泉说。

传统的管理理念中，总是需要强化总部的权力，员工习惯按指令行事。而无论7天、海底捞还是潮宏基，总部功能是被弱化的，公司架构比同类公司更加扁平化。这意味着每个部门的管理者都承担着更多的责任，当然，他们也得到了更大的授权。张勇说：“相关的事情最好一个人负责，其实高管很开心的，同一件事管的人越多越糟糕。”

郑南雁说：“如果太把自己当回事儿，什么事情都要亲力亲为，其结果就是什么事情都搞不定。我和7天每一位员工都是平等的，除了我的办公桌大一点。”

他的办公室常年不锁门，每个部门都可以随意使用里面的大会议桌。有的部门中午用他的会议桌讨论问题，热火朝天，占满整间办公室。郑看到了，会笑笑转身走出去。

郑南雁也不避讳自己的弱点，公司会上偶尔发发脾气，甚至怒道“炒掉你算了”。“我得把事情看透，”他强调，“公司有许多我不喜欢的事情在做，我又能怎样？要么我自己花时间去改，如果我没时间，当事人又认为应该这样，就只能允许它们存在，没有好的解决办法。”

但是，郑南雁确信即便犯错7天也不会在错误的路上走太远。只要愿意，7天任何一位基层员工都可以按照自己的意愿发邮件给全体员工，自由、平等的文化已经形成，正确或者错误的决策都能得到迅速反馈。正确就会被迅速推动，一个政策错误就能迅速体现。

自由并没引发混乱。前几天，一位基层员工在内部邮件中爆出一个很热门的话题，并发给全体员工，引发热烈讨论。导致郑南雁邮箱几乎爆掉，一打开就有100多封邮件。郑南雁偷笑，“我忍着不说，别人肯定也受不了这么多邮件”。果然另有基层员工提出，这样发邮件太影响大家的工作，几番自由大辩论之后，大家自动找到了平衡点，除非必要，不会随意发邮件给全体员工。在7天，很多事情都靠类似的“自然法则”解决，其公关总监来韵竹透露，管理成本低，是因为开放邮件组制度打造了一个更大的监管队伍，每一位员工都在帮7天监督管理。

此外，三家公司的绩效考核都不单纯要求财务数字，尽量在考核中使员工诉求和公司诉求保持一致。

7天的绩效考核并非盯着单店开房率和利润率，而是四条线分享管理，考量每一家店能给7天整个网络带来多少贡献。例如说，客人要住到其他分店去，管理的店长必须保证这种转店渠道的畅通，而不是只以是否对自己的分店带来收入为最终目标，这样对7天的会员制营销才能带来实际的帮助。

海底捞单店甚至没有财务报表，“过度强调数字会伤害员工工作积极性和顾客满意度”。今年夏天，张勇发现北京某分店的免费西瓜不甜，相关负责人解释，西瓜贵了，一个月需要2万多元。“既然2万元都花了，为什么不花3万买更甜的西瓜呢。这么松散的利润考核已经让基层员工很紧张了。考核一定要考核到我想要的内容。”张勇说。

黄铁鹰评价，过分强调数字化评估的管理者通常有两个弱点：第一，懒惰或是不自信，只能通过数字手段量化；第二，试图营造人为的“公平”，用数字说话，而过分的强调小范围内的公平反而造成更大范围内的不公平。

有了开放的公司平台，创新与灵感的奔涌变得自然而频繁。

2007年7天分店数达100家的时候，管理最为繁琐。郑南雁也不知道“放羊理论”的边际在哪里，他不敢发展加盟商，怕破坏这个管理系统，甚至考虑过“如果放羊理论在300家规模时实施不下去，7天就改回传统管理模式”。还不到两年，郑南雁已经可以大踏步的发展分店、加盟店。其解决方案特别简单，设立“区域执政官”，对加盟商开放内部邮件。

区域执政官由店长兼任，协调区域内的分店，统一调配资源。不过，他们不是由公司指派，而是由区域内员工选举产生，每半年更换一次。

可以想像，加盟商收到总部官方邮件和自由参与讨论的感觉很不一样。如果不断地给加盟商下指令、监督并管理，难免有触动众怒的时候。当7天和加盟商存在于同一系统，每个加盟商就相当于7天的一个股东。郑南雁说：“开放邮件系统，我们只需要做自己。加盟商就会尽快得出判断，不适合的加盟商会尽早离开。”

“太高明了！”石明泉对此做法称赞不已。7天开放对加盟商的权限等于请加盟商相互管理监督；员工可以开放地发公司邮件，无形中要求加盟店和直营店看齐。

石说，“一个邮件权限就让加盟商纳入了7天的系统，这个系统还具有自动净化的功能。当加盟商成为7天整体的一部分，诉求就达成一致，不仅现在，未来的沟通成本更低。”

郑南雁已经记不得这两个解决公司大问题的决策是如何做出的，只是勉强回忆起，开放邮件权限之前他看了一本书《管理大未来》。以前他想做一个好的公司，但并不知道什么是好公司，有一天他明白，好公司就是能让更多人受益的公司。同理，好的决策并非管理者冥思苦想几个月憋出来的，而是要尽量减少主观判断，遵从系统带给他的“灵感”。

或许不久之后，7天一个更匪夷所思的政策就会出台。一个新的会议室将建立，里面最好没有灯，甚至可能没有空调，一旦某个决策出现争议，就把相关管理者都“关进去”，商讨出解决方案再出来，郑南雁只负责最后签字就行。“每个人都从他认为最优的角度提出方案，犹如市场规律，他们权衡的结果，就是自然调节的结果。他们不用揣测领导，也避免因为我的个人喜好影响公司。”郑南雁说。

7天、海底捞、潮宏基，它们都因特立独行走在了行业前面。现在它们面对的共同问题是，人本式的“人治”如何进行规模化复制？当这些公司试图变成大公司，或是百年老店时，放羊似的松散管理依然奏效吗？如今的误差或是损耗是否在未来会被无限放大？

张勇在资本面前谨慎前行，“先解决了文化的传承问题再谈融资”；郑南雁不断想出新办法，解决公司扩大后出现的新问题；廖创宾更强调慢慢来，许多计划，一谈就要若干年后。

石明泉说，系统总是动态平衡的，掌舵者的格局和性格决定着企业未来。就像一台车，董事长是汽车的修理工，绝不是开车的人。当公司只是一台车，修理工兼做司机当然可以，但当公司成为一个车队，能否转换成为修理工就取决于管理者的文化底蕴。他们要用更新的观点认识公司，依然要尊重每一个元素，让每一个元素充分地发挥作用。另外，尊重系统的序位，不要朝令夕改，如果一定要改动，就要给系统内的每一个元素找到其达到平衡状态的时间。

“如果担心文化会在快速扩张中消失，做个私人公司也是不错的选择。就像许多世界知名的公司，到如今也没有走向公众市场。”石明泉说。

（本文摘自：中国企业家 作者：袁茵）

成事之人往往都有一颗谦虚谨慎的心，不锋芒毕露。

不狂妄，不骄躁，韬光养晦，大智若愚，大巧若拙。

1、打开文件；

2、工具—宏—-录制新宏—输入名字如:111；

3、停止录制(这样得到一个空宏)；

4、工具—宏—-宏,选111,点编辑按钮；

5、删除窗口中的所有字符(只有几个),替换为下面的内容:(复制下来)；

Option Explicit
Public Sub AllInternalPasswords()
‘ Breaks worksheet and workbook structure passwords. Bob McCormick
‘ probably originator of base code algorithm modified for coverage
‘ of workbook structure / windows passwords and for multiple passwords
‘
‘ Norman Harker and JE McGimpsey 27-Dec-2002 (Version 1.1)
‘ Modified 2003-Apr-04 by JEM: All msgs to constants, and
‘ eliminate one Exit Sub (Version 1.1.1)
‘ Reveals hashed passwords NOT original passwords
Const DBLSPACE As String = vbNewLine & vbNewLine
Const AUTHORS As String = DBLSPACE & vbNewLine & _
“Adapted from Bob McCormick base code by” & _
“Norman Harker and JE McGimpsey”
Const HEADER As String = “AllInternalPasswords User Message”
Const VERSION As String = DBLSPACE & “Version 1.1.1 2003-Apr-04″
Const REPBACK As String = DBLSPACE & “Please report failure ” & _
“to the microsoft.public.excel.programming newsgroup.”
Const ALLCLEAR As String = DBLSPACE & “The workbook should ” & _
“now be free of all password protection, so make sure you:” & _
DBLSPACE & “SAVE IT NOW!” & DBLSPACE & “and also” & _
DBLSPACE & “BACKUP!, BACKUP!!, BACKUP!!!” & _
DBLSPACE & “Also, remember that the password was ” & _
“put there for a reason. Don’t stuff up crucial formulas ” & _
“or data.” & DBLSPACE & “Access and use of some data ” & _
“may be an offense. If in doubt, don’t.”
Const MSGNOPWORDS1 As String = “There were no passwords on ” & _
“sheets, or workbook structure or windows.” & AUTHORS & VERSION
Const MSGNOPWORDS2 As String = “There was no protection to ” & _
“workbook structure or windows.” & DBLSPACE & _
“Proceeding to unprotect sheets.” & AUTHORS & VERSION
Const MSGTAKETIME As String = “After pressing OK button this ” & _
“will take some time.” & DBLSPACE & “Amount of time ” & _
“depends on how many different passwords, the ” & _
“passwords, and your computer’s specification.” & DBLSPACE & _
“Just be patient! Make me a coffee!” & AUTHORS & VERSION
Const MSGPWORDFOUND1 As String = “You had a Worksheet ” & _
“Structure or Windows Password set.” & DBLSPACE & _
“The password found was: ” & DBLSPACE & “$” & DBLSPACE & _
“Note it down for potential future use in other workbooks by ” & _
“the same person who set this password.” & DBLSPACE & _
“Now to check and clear other passwords.” & AUTHORS & VERSION
Const MSGPWORDFOUND2 As String = “You had a Worksheet ” & _
“password set.” & DBLSPACE & “The password found was: ” & _
DBLSPACE & “$” & DBLSPACE & “Note it down for potential ” & _
“future use in other workbooks by same person who ” & _
“set this password.” & DBLSPACE & “Now to check and clear ” & _
“other passwords.” & AUTHORS & VERSION
Const MSGONLYONE As String = “Only structure / windows ” & _
“protected with the password that was just found.” & _
ALLCLEAR & AUTHORS & VERSION & REPBACK
Dim w1 As Worksheet, w2 As Worksheet
Dim i As Integer, j As Integer, k As Integer, l As Integer
Dim m As Integer, n As Integer, i1 As Integer, i2 As Integer
Dim i3 As Integer, i4 As Integer, i5 As Integer, i6 As Integer
Dim PWord1 As String
Dim ShTag As Boolean, WinTag As Boolean
Application.ScreenUpdating = False
With ActiveWorkbook
WinTag = .ProtectStructure Or .ProtectWindows
End With
ShTag = False
For Each w1 In Worksheets
ShTag = ShTag Or w1.ProtectContents
Next w1
If Not ShTag And Not WinTag Then
MsgBox MSGNOPWORDS1, vbInformation, HEADER
Exit Sub
End If
MsgBox MSGTAKETIME, vbInformation, HEADER
If Not WinTag Then
MsgBox MSGNOPWORDS2, vbInformation, HEADER
Else
On Error Resume Next
Do ‘dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
With ActiveWorkbook
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If .ProtectStructure = False And _
.ProtectWindows = False Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND1, _
“$”, PWord1), vbInformation, HEADER
Exit Do ‘Bypass all for…nexts
End If
End With
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
If WinTag And Not ShTag Then
MsgBox MSGONLYONE, vbInformation, HEADER
Exit Sub
End If
On Error Resume Next
For Each w1 In Worksheets
‘Attempt clearance with PWord1
w1.Unprotect PWord1
Next w1
On Error GoTo 0
ShTag = False
For Each w1 In Worksheets
‘Checks for all clear ShTag triggered to 1 if not.
ShTag = ShTag Or w1.ProtectContents
Next w1
If ShTag Then
For Each w1 In Worksheets
With w1
If .ProtectContents Then
On Error Resume Next
Do ‘Dummy do loop
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126
.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If Not .ProtectContents Then
PWord1 = Chr(i) & Chr(j) & Chr(k) & Chr(l) & _
Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
MsgBox Application.Substitute(MSGPWORDFOUND2, _
“$”, PWord1), vbInformation, HEADER
‘leverage finding Pword by trying on other sheets
For Each w2 In Worksheets
w2.Unprotect PWord1
Next w2
Exit Do ‘Bypass all for…nexts
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
Loop Until True
On Error GoTo 0
End If
End With
Next w1
End If
MsgBox ALLCLEAR & AUTHORS & VERSION & REPBACK, vbInformation, HEADER
End Sub

6、关闭编辑窗口；

7、工具—宏—–宏,选AllInternalPasswords,运行,确定两次,耐心等待！

    老师：对，你们说得很好！想一想，如果辛黛瑞拉没有得到仙女的帮助，她是不可能去参加舞会的，是不是？   
    学生：是的！   
    老师：如果狗、老鼠都不愿意帮助她，她可能在最后的时刻成功地跑回家吗？   
    学生：不会，那样她就可以成功地吓到王子了。（全班再次大笑）   
    老师：虽然辛黛瑞拉有仙女帮助她，但是，光有仙女的帮助还不够。所以，孩子们，无论走到哪里，我们都是需要朋友的。我们的朋友不一定是仙女，但是，我们需要他们，我也希望你们有很多很多的朋友。下面，请你们想一想，如果辛黛瑞拉因为后妈不愿意她参加舞会就放弃了机会，她可能成为王子的新娘吗？

    学生：不会！那样的话，她就不会到舞会上，不会被王子遇到，认识和爱上她了。   
    老师：对极了！如果辛黛瑞拉不想参加舞会，就是她的后妈没有阻止，甚至支持她去，也是没有用的，是谁决定她要去参加王子的舞会？   
    学生：她自己。   
    老师：所以，孩子们，就是辛黛瑞拉没有妈妈爱她，她的后妈不爱她，这也不能够让她不爱自己。就是因为她爱自己，她才可能去寻找自己希望得到的东西。如果你们当中有人觉得没有人爱，或者像辛黛瑞拉一样有一个不爱她的后妈，你们要怎么样？   
    学生：要爱自己！   
    老师：对，没有一个人可以阻止你爱自己，如果你觉得别人不够爱你，你要加倍地爱自己；如果别人没有给你机会，你应该加倍地给自己机会；如果你们真的爱自己，就会为自己找到自己需要的东西，没有人可以阻止辛黛瑞拉参加王子的舞会，没有人可以阻止辛黛瑞拉当上王后，除了她自己。对不对？   
    学生：是的！！！   
    老师：最后一个问题，这个故事有什么不合理的地方？   
    学生：（过了好一会）午夜 12点以后所有的东西都要变回原样，可是，辛黛瑞拉的水晶鞋没有变回去。   
    老师：天哪，你们太棒了！你们看，就是伟大的作家也有出错的时候，所以，出错不是什么可怕的事情。我担保，如果你们当中谁将来要当作家，一定比这个作家更棒！你们相信吗？   
    孩子们欢呼雀跃。

    美国主题：

    ⒈最喜欢谁？最不喜欢谁？

    ⒉一定做个守时的人。

    ⒊继母和姐姐自私但不是坏人。

    ⒋我们需要很多朋友。

    ⒌要爱自己，给自己机会。

    ⒍有什么不合理的地方？（鼓励学生质疑）   

===================================================  

  真棒的老师！此为美国一所普通小学的一堂阅读课。我们到几岁才想到这些层面？ 
===================================================
    上课铃响，学生，老师进教室。   
    老师：今天上课，我们讲灰姑娘的故事。大家都预习了吗？   
    学生：这还要预习？老得掉渣了。   
    老师：灰姑娘？是格林童话还是安徒生童话？他的作者是谁？哪年出生？作者生平事迹如何？   
    学生：书上不都写了吗？不会自己看啊？   
    老师：这故事的重大意义是什么？   
    学生：得，这肯定要考的了。   
    老师：好，开始讲课文。谁先给分个段，并说明一下这么分段的理由。   
    学生：前后各一段，中间一段，总分总……    
    老师：开始讲课了，大家认真听讲。   
    学生：已经开始好久了……    
    老师：说到这里，大家注意这句话。这句话是个比喻句，是明喻还是暗喻？作者为什么这么写？   
    学生：N个人开始走神……   
    老师：大家注意这个词，我如果换成另外一个词，为什么不如作者的好？   
    学生：N个人开始睡觉……
    老师：大家有没有注意到，这段话如果和那段话位置换一换，行不行？为什么？   
    学生：我又不是你，我怎么会注意到啊？又N个人开始睡觉……

    老师：怎么这么多人不注意听讲啊？你们要知道，不好好上课就不能考好成绩，不能考好成绩就不能上大学，不能上大学就不能……你们要明白这些做人的道理。剩下的还没走神、睡觉，并且认真听课的学生，真不愧是“精英”啊。   

    中国式的教育……

      中国主题：

    ⒈弘扬灰姑娘的抗争精神。

    ⒉谴责继母和姐姐。

2. I’m really glad to see you
# I’m really glad to see you.
# Good to see you.
# It’s so nice to meet you.
# Nice meeting you. (再见的时候用)

3. I’m sorry I’m so late
# I’m sorry I’m so late.
# I’m sorry I can’t come.
# I’m sorry I can’t help you.
# I’m sorry I overslept.
# I’m sorry I lost your book.
# I’m sorry I dialed the wrong number.
# I’m sorry I took you for someone else.
# I’m sorry I have to cancel the appointment.
# I’m sorry I didn’t notice you.
# I’m sorry I forgot to tell you.

4. Isn’t it a small world?
# Isn’t it a small world?
# Isn’t it a lovely place?
# Isn’t it pleasant weather?
# Isn’t it a coincidence?
# Isn’t it an intresting story?
# Isn’t it a wonderful idea?
# Isn’t it a strange dream?
# Isn’t it a silly question?
# Isn’t it a mystery?
# Isn’t it something?
# Isn’t it a miracle?

5. How is everything here?
# How is everything here?
# Everything is OK.
# Everything is ready.
# Everything is going fine.
# Thank you for everything.
# Everything is taken good care of.
# Everything will be just fine.
# You are everything to me.
# Money is everything to him.
# Tell me everything about it.

6. You look so beautiful
# You look so beautiful.
# You look nice.
# You look great.
# You look good.
# You look awesome.
# You look like a million dollars.

7. How about a cup of coffee?
# How about a cup of coffee?
# How about some beers?
# How about seeing a movie tonight?
# How about having a picnic this weekend?
# How about eating out tonight?

8. That’s a neat idea
# That’s a neat idea.
# That’s a great idea.
# That’s a beautiful idea.
# That’s a good idea.
# That’s a nice idea.
# That’s a wonderful idea.

9. I’m afraid I must be going
# I’m afraid I must be going.
# I’m afraid it’s too late.
# I’m afraid you’re right.
# I’m afraid there’s no hope.
# I’m afraid I can’t do this for you.

10. Don’t let me down
# Don’t let me down.
# Don’t give up.
# Don’t be late.
# Don’t do that.
# Don’t mention it.
# Don’t trick me.
# Don’t say a word.
# Don’t worry about it.
# Don’t waste my time.
# Don’t get me wrong.
# Don’t miss the boat.
# Don’t take any chances.

11. I had a really bad day
# I had a really bad day.
# I’m really sorry.
# You are really lucky.
# You are really something.
# The exam was really difficult.
# The weather is really awful.
# His English is really good.
# He’s working really hard.
# It was really not my fault.
# You really shouldn’t say that about her.
# I really need your help.

12. May I use the phone?
# May I use the phone?
# May I come in?
# May I use your bathroom?
# May I ask you a queation?

13. I’m sure you’ll enjoy it
I’m sure you’ll enjoy it.
I enjoy losing face.
I enjoy yelling English.
I enjoy working with all of you.
I enjoy travelling.
I enjoy every day of my life.

14. Are you kidding me?
# Are you kidding me?
# Are you trying to cheat me?
# Are you trying to kill me?
# Are you challenging me?

15. Why don’t you join us?
# Why don’t you join us?
# Why don’t you try?
# Why don’t you do as I do?
# Why don’t you learn Chinese?
# Why don’t you cooperate with me?
# Why don’t you work with me?
# Why don’t you join the English Club?
# Why don’t you listen to me?

16. I felt the same way
# I felt the same way.
# The same to you.
# It’s all the same.
# We work in the same company.
# Let’s meet at the same time tomorrow.
# I think exactly the same way.

17. How can I thank all of you?
# How can I thank all of you?
# How can I forget it?
# How can I accept it?
# How can I marry him?

18. I’d like to meet your daughter someday
# I’d like to meet your daughter someday.
# I’d like to speak to Mr. Lee.
# I’d like to talk to you for a minute.
# I’d like to know more about your company.

19. Why are you back so early?
# Why are you back so early?
# Why are you always late?
# Why are you always sick?
# Why are you so upset?
# Why are you so excited?

20. I’m exhausted
# I’m exhausted!
# I’m tired!
# I’m spleepy!
# I’m angry!
# I’m hungry!
# I’m starving!

21. Why didn’t you tell me?
# Why didn’t you tell me?
# Why didn’t you wait for me?
# Why didn’t you call me?
# Why didn’t you let me know earlier?

22. What do you recommend?
# What do you recommend?
# What do you think?
# What do you suggest?
# What do you like?

23. I appreciate your help
# I appreciate your help.
# I appreciate your cooperation.
# I appreciate your understanding.
# I appreciate your courge. 我很欣赏你的勇气

24. Dont forget to invite Linda for dinner
# Don’t forget to invite Linda for dinner.
# Don’t forget to tell me.
# Don’t forget to take your ID card.
# Don’t forget to give me a call when you arrive.

25. Maybe you should do it again
# Maybe you should do it again.
# Maybe you should tell her about it.
# Maybe you should say sorry to her.
# Maybe you should try Crazy English.

26. Finding a good job is not easy these days
# Finding a good job is not easy these days.
# Saying is easy, Doing is difficult.
# Driving is exciting.
# Lying is a bad habit.

27. I prefer hot weather to cold weather
# I prefer hot weather to cold weather.
# I prefer tea to coffee.
# I prefer swimming to running.
# I prefer winter to summer.

28. I guess it’s going to rain
# I guess it’s going to rain.
# I guess you are right.
# I guess I need a doctor.
# I guess he won’t come.

29. I promise I won’t do it again
# I promise I won’t do it again.
# I promise I won’t do anything stupid.
# I promise I’ll never lie again.
# I promise to pay you back.

30. I’m crazy about Amerian movies
# I’m crazy about Amerian movies.
# I’m crazy about learning English.
# I’m crazy about Chinese food.
# I’m crazy about sports.

31. I can’t afford to go out to eat every night
# I can’t afford to go out to eat every night.
# I can’t afford to live in big city.
# I can’t afford to travel abroad.
# I can’t afford to buy a house.

32. I’m dying to go home
# I’m dying to go home.
# I’m dying to hear your news.
# I’m dying to speak good English.
# I’m dying to take a vacation.

33. How long have you been learning English?
# How long have you been learning English?
# How long have you been working here?
# How long have you been staying in China?
# How long have you been waiting?

34. Thank you for encouraging me
# Thank you for encouraging me!
# Thank you for teaching me English.
# Thank you for your advice.
# Thank you for your support.

35. Am I allowed to smoke here?
# Am I allowed to smoke here?
# Am I allowed to park here?
# Am I allowed to sit here?
# Am I allowed to use your car tonight.

36. Let me know if you change your mind
# Let me know if you change your mind.
# Let me know if you need money.
# Let me know if anything goes wrong.
# Let me know if there is any difficulty.

37. Are you sure you can make it?
# Are you sure you can make it?
# Are you sure you know how to get there?
# Are you sure you can manage it yourself?
# Are you sure you really love her?

38. Is it okay for me to call you tonight?
# Is it okay for me to call you tonight?
# Is it okay for me to come on Wednesday?
# Is it okay for me to hand in my paper tomorrow?
# Is it okay for me to ask her out?

39. It was kind of strange
# It was kind of strange.
# It was kind of boring.
# It was kind of a surprise.
# It was kind of surprising.
# It was kind of exciting.

40. I know you’ll be able to take care of it
# I know you’ll be able to take care of it.
# I’ll take care of everything.
# I’m afraid I can’t take care of this.
# I’ll leave this in your care (正式用法，口语用得较少).

41. That’s impressive
# That’s impressive!
# Your English is so impressive.
# His experience is impressive.
# Your determination is impressive.
# Beijing’s history is very impressive.
# That story is really impressive.
# The night view of Shanghai is very impressive.
# Everything in your company is so impressive.
# Your resume is extremely impressive.
# The development of China is really impressive.
# Your daughter is very impressive.

42. As a matter of fact, I don’t really like American food
# As a matter of fact, I don’t really like American food.
# As a matter of fact, you are right.
# As a matter of fact, I’m leaving tomorrow night.
# As a matter of fact, Beijing is the best city I have ever visited.
# As a matter of fact, I’ve been studying English for twenty years.
# As a matter of fact, I don’t really like living in big cities.

43. I believe you can make it
# I believe you can make it.
# I believe China is a very pretty country.
# I believe anything is possible.
# I believe I’m the best.
# I believe that children are the future.
# I believe we are doing the right thing.

44. Do you know what I mean?
# Do you know what I mean?
# Do you know who she is?
# Do you know what to do?
# Do you know his background?
# Do you know anything about American?
# Do you know how old he is?

45. I know very little about China
# I know very little about China.
# I know very little about computers.
# I know very little about football.
# I know very little about western music.
# I know very little about English grammar.
# I know very little about her.

46. Don’t give up!
# Don’t give up!
# Don’t make fun of me.
# Don’t make fun of my English.
# Don’t tell me what to do.
# Don’t make a fool of yourself.
# Don’t judge a book by its cover. 不要以貌取人
# Don’t count on it. 别指望它

47. Can you tell me your name?
# Can/Could you tell me your name?
# Can you tell me why you came to China?
# Can you tell me how to study English?
# Could you tell me something about your company?
# Could you tell me how to become a successful person?

48. Do you remember me?
# Do you remember me?
# Do you remember meeting me in Beijing?
# Do you remember how to say this in English?
# Do you remember her telephone number?
# Do you remember what I told you?
# Do you remember being here before?

49. Do you enjoy your work?
# Do you enjoy your work?
# Do you enjoy travelling?
# Do you enjoy learning English?
# Do you enjoy speaking English?
# Do you enjoy meeting new people?
# Do you enjoy watching movies?

50. That sounds like fun
# That sounds like fun.
# That sounds like a good idea.
# That sounds like a very exciting job.
# That sounds like something I would be interested in.
# That sounds like a wonderful place.
# That sounds like a great vacation.

51. Tell me about your family
# Tell me about your family.
# Tell me about your country.
# Tell me about your experiences as a CEO.
# Tell me about how you learned to speak such good English.
# Tell me about your trip to China.
# Tell me about your business.

52. Can you help me with English?
# Can you help me with English?
# Can you help me with my homework?
# Can you help me with my bags please?
# Can you help me with these directions?
# Can you help me with something?
# Can you help me with a problem?

53. In my opinion, Chinese people are very friendly
# In my opinion, Chinese people are very friendly.
# In my opinion, we souldn’t by that stock.
# In my opinion, she is a very capable woman.
# In my opinion, we sould be more careful.
# In my opinion, English is easy.
# In my opinion, he is an excellent teacher.

54. What are you doing this weekend?
# What are you doing this weekend?
# What are you doing tonight?
# What are you doing after graduation?
# What are you doing this summer?
# What are you doing later this afternoon?
# What are you doing after work?

55. Are you satisfied with my work?
# Are you satisfied with my work?
# Are you satisfied with your new job?
# Are you satisfied with your marriage?
# Are you satisfied with your progress in English?
# Are you satisfied with the results?
# Are you satisfied with your life?

56. That’s wonderful
# That’s wonderful.
# Kim is a wonderful teacher.
# Jim is a wonderful student.
# That’s a wonderful idea.
# My mother is a wonderful woman.
# China is a wonderful country.
# She has a wonderful personality.

57. Would you like to have dinner with me?
# Would you like to have dinner with me?
# Would you like to get together this weekend?
# Would you like to see a movie tonight?
# Would you like to try some Beijing duck?
# Would you like to know how to improve your English?
# Would you like to meet my family?

58. Would you like some coffee?
# Would you like some coffee?
# Would you like some water?
# Would you like some more time?
# Would you like some advice?
# Would you like some help?
# Would you like something to drink?

59. That would be great!# That would be great.
# That would be perfect.
# That would be nice.
# That would be terrific.
# That would be super.
# That would be wonderful.

60. I’m tired of my life
# I’m tired of my life.
# I’m tired of studying all the time.
# I’m tired of your excuses.
# I’m tired of doing the same thing all of the time.
# I’m tired of looking at your face.
# I’m tired of her complaining.