Douglas's profiledeep into the seaPhotosBlogListsMore Tools Help

Douglas Moore

Occupation
Location
我从不是乐观主义者,因为我不能肯定事事都有美好的结局;
我也不是悲观主义者,因为我不能肯定事事都是不好的结局,
我只是心怀希望……

算算活了多少天

Loading...
朋友们

Windows Media Player

Photo 1 of 140

deep into the sea

changing never stopped

怪人二十面相传K-20: Kaijin niju menso den

1949年,架空都市——帝都。
这是一个延续了贵族制度的社会,贫富差距极大,帝都的富人中有九成是特权阶级。突然,帝都出现了一个以富人为目标、不断盗取艺术品和古董的怪盗。他有着魔法般的身手和变化莫测的二十张面孔,人们叫他“K-20”。
本片的主人公并非这个超级大盗,而是一个叫远藤平吉的普通男人。
平吉是马戏团里的杂技演员,他落入陷阱,背上了怪盗二十面相的黑锅。摆脱追捕后,平吉决定用自己的头脑和杂技技巧与二十面相对抗。和他联手的是二十面相的目标贵族千金羽柴叶子及其未婚夫神探明智小五郎。平吉化妆成二十面相,全力追索诬陷他的凶手……
最后,平吉能否获得清白?而这场混乱的激斗又会迎来怎样的结局?!
 
突然在迅雷看看上看到这片子,鉴于对于江户川乱步书籍的喜好,详细的看了一遍。。。流鼻血中
片子本身还不错,不过貌似和原著主线出入较大
没事看看,小朋友们就不要练习里面的小偷宝典了眨眼睛
 
P.S.:结尾居然是Oasis的the shock of the lightning目瞪口呆  FT

dbf 文件 数据排序

sort to d:\abcd.dbf on no. /A

excel筛选重复项

假设你的数据在A1:B10000,其中A列为出现重复项的列。 C1输入公式 =countif(a$1:a$10000,a1)> 1 回车,自动筛选C列TRUE值即可“列出”重复的项。

vlookup

在表格数组的首列查找指定的值,并由此返回表格数组当前行中其他列的值。

VLOOKUP 中的 V 参数表示垂直方向。当比较值位于需要查找的数据左边的一列时,可以使用 VLOOKUP 而不是 HLOOKUP。

语法

VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)

Lookup_value  为需要在表格数组 (数组:用于建立可生成多个结果或可对在行和列中排列的一组参数进行运算的单个公式。数组区域共用一个公式;数组常量是用作参数的一组常量。)第一列中查找的数值。Lookup_value 可以为数值或引用。若 lookup_value 小于 table_array 第一列中的最小值,VLOOKUP 返回错误值 #N/A。

Table_array  为两列或多列数据。使用对区域或区域名称的引用。table_array 第一列中的值是由 lookup_value 搜索的值。这些值可以是文本、数字或逻辑值。文本不区分大小写。

    Col_index_num  为 table_array 中待返回的匹配值的列序号。Col_index_num 为 1 时,返回 table_array 第一列中的数值;col_index_num 为 2,返回 table_array 第二列中的数值,以此类推。如果 col_index_num :

    • 小于 1,VLOOKUP 返回错误值 #VALUE!。
    • 大于 table_array 的列数,VLOOKUP 返回错误值 #REF!。

    Range_lookup  为逻辑值,指定希望 VLOOKUP 查找精确的匹配值还是近似匹配值:

    • 如果为 TRUE 或省略,则返回精确匹配值或近似匹配值。也就是说,如果找不到精确匹配值,则返回小于 lookup_value 的最大数值。

      table_array 第一列中的值必须以升序排序;否则 VLOOKUP 可能无法返回正确的值。有关详细信息,请参阅排序数据

    • 如果为 FALSE,VLOOKUP 将只寻找精确匹配值。在此情况下,table_array 第一列的值不需要排序。如果 table_array 第一列中有两个或多个值与 lookup_value 匹配,则使用第一个找到的值。如果找不到精确匹配值,则返回错误值 #N/A。

    注解

    • 在 table_array 第一列中搜索文本值时,请确保 table_array 第一列中的数据没有前导空格、尾部空格、直引号(' 或 ")与弯引号(‘或“)不一致或非打印字符。否则,VLOOKUP 可能返回不正确或意外的值。有关详细信息,请参阅 CLEANTRIM
    • 在搜索数字或日期值时,请确保 table_array 第一列中的数据未存储为文本值。否则,VLOOKUP 可能返回不正确或意外的值。有关详细信息,请参阅将保存为文本的数字转换为数字值
    • 如果 range_lookup 为 FALSE 且 lookup_value 为文本,则可以在 lookup_value 中使用通配符、问号 (?) 和星号 (*)。问号匹配任意单个字符;星号匹配任意字符序列。如果要查找实际的问号或星号,请在该字符前键入波形符 (~)。
    确实是个好工具
    注意:
    1、两个表要在一个文件里面
    2、vlookup(对比列首坐标,表名!原表格全部列,原表格填充列数,精度)
    3、原表格里面建议把与新表对比列相对应的列放到整个表格的第一列,填充列不能在对比列后面
    省不少事的好东东

    Oasis的The Masterplan

     

    leave out all the rest

    i dreamed i was missing
    you were so scared
    but no one would listen
    'cause no one else cares
    after my dreaming
    i woke with this fear
    what am i leaving
    when i'm done here
    so if you're asking me i want you to know

    when my time comes
    forget the one that i've done
    help me leave behind some reasons to be missed
    and don't resent me
    and when you're feeling empty
    keep me in your memory
    leave out all the rest
    leave out all the rest

    don't be afraid
    i've taken my beating
    i've shed when i'm near
    i'm strong to surface
    not all the way through
    i've never been perfect
    but neither have you
    so if you're asking me i want you to know

    when my time comes
    forget the one that i've done
    help me leave behind some reasons to be missed
    don't resent me
    and when you're feeling empty
    keep me in your memory
    leave out all the rest
    leave out all the rest

    forgetting all the hurt inside
    you've learned to hide so well
    pretending someone else can come and save me
    from myself
    i can't be who you are

    when my time comes
    forget the one that i've done
    help me leave behind some reasons to be missed
    don't resent me
    and when you're feeling empty
    keep me in your memory
    leave out all the rest
    leave out all the rest

    forgetting all the hurt inside
    you've learned to hide so well
    pretending someone else can come and save me
    from myself
    i can't be who you are
    i can't be who you are

    Fade into you

    I want to hold the hand inside you
    I want to take a breath that's true
    I look to you and I see nothing
    I look to you to see the truth
    You live your life, you go in shadows
    You'll come apart and you'll go black
    Some kind of night into your darkness
    Colors your eyes with what's not there.
    Fade into you,
    Strange you never knew
    Fade into you
    I think it's strange you never knew
    A stranger's light comes on slowly
    A stranger's heart without a home
    You put your hands into your head
    And then smiles cover your heart
    Fade into you
    Strange you never knew
    Fade into you
    I think it's strange you never knew
    Fade into you
    Strange you never knew
    Fade into you
    I think it's strange you never knew
    I think it's strange you never knew

    goodnight goodnight-maroon 5

    you left me hanging from a thread
    we once were from together
    i lick my wounds but i can
    never see them getting better
    something's gotta change
    things cannot stay the same

    her hair was pressed against her face
    her eyes were ran with anger
    enraged by things unsaid
    and empty beds and bad behaviour
    something's gotta change
    it must be rearranged, oh

    i'm sorry, i did not mean
    to hurt my little girl
    it's beyond me, i cannot carry
    the weight of a heavy world
    so goodnight, goodnight, goodnight, goodnight
    goodnight, goodnight, goodnight, goodnight
    goodnight, hope that things work out all right, yeah
    whoa, oh

    the room was silent as we
    all tried so hard to remember
    the way it feels to be alive
    the day that he first met her
    something's gotta change
    things cannot stay the same

    you make me think of someone wonderful
    but i can't place her
    i wake up every morning
    wishing one more time to face her
    something's gotta change
    it must be rearranged, oh

    i'm sorry, i did not mean
    to hurt my little girl
    it's beyond me, i cannot carry
    the weight of a heavy world
    so goodnight, goodnight, goodnight, goodnight
    goodnight, goodnight, goodnight, goodnight
    goodnight, hope that things work out all right
    so much to love
    so much to learn
    but i won't be there to teach you, oh
    i know i can be closed
    but i try my best to reach you
    i'm so sorry, i did not mean
    to hurt my little girl
    it's beyond me, i cannot carry
    the weight of a heavy world
    so goodnight, goodnight, goodnight, goodnight
    goodnight, goodnight, goodnight, goodnight
    goodnight, goodnight, goodnight, goodnight
    goodnight, hope that things work out all right, yeah
    whoa