H********g
发帖数: 43926 | 1 http://thinketg.com/say-goodbye-to-vlookup-and-hello-to-index-m
另一个办法是用上面链接里的的index-match的办法
d5=index(sheet1!e1:e10,match(a5,sheet1!a1:a10),1)
其中match里这个1是说找sheet1 A列里刚好超过a5的那个数字。
=INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_
type))
Return_value_range - The range that holds the return values
Lookup_value – The value you want to find in the lookup value array
Lookup_value_range – The range containing lookup values
Match_type – Exact (0), Nearest Greater Than (-1), or N... 阅读全帖 |
|
z***i
发帖数: 8285 | 2 这算第二个有效方案。。
http://thinketg.com/say-goodbye-to-vlookup-and-hello-to-index-m
另一个办法是用上面链接里的的index-match的办法
d5=index(sheet1!e1:e10,match(a5,sheet1!a1:a10),1)
其中match里这个1是说找sheet1 A列里刚好超过a5的那个数字。
=INDEX(Return_value_range, MATCH(Lookup_value, Lookup_value_range, Match_
type))
Return_value_range - The range that holds the return values
Lookup_value – The value you want to find in the lookup value array
Lookup_value_range – The range containing lookup values
Match_type – Exact (0), Nearest Greater Th... 阅读全帖 |
|
i****a
发帖数: 36252 | 3 there are issue for lookup if you use varchar as ID
performance will be bad for large dataset, and you may run into lookup
errors |
|
y****3
发帖数: 131 | 4 多谢指点。
如果把每一个folder都加为一个row，那么insert和lookup时，是否都要把file path都
parse开，每个folder都要在folder table 里做一个lookup？
FOLDER |
|
s*****g
发帖数: 1055 | 5 It is true BGP routes will be installed in FIB, but that has nothing to do
with LFIB space. Say one BGP router (say its BGP router id 1.1.1.1)
advertises 100K BGP route to a peer, for any one of those prefixes, the peer
will do IP lookup, and find out the next hop is 1.1.1.1, the peer will
further do recursive lookup for 1.1.1.1, and better you you have a label
switch path to 1.1.1.1 on this peer, so the look up will return something with a label. (RSVP or LDP), this peer just slap what ever lab |
|
s*****g
发帖数: 1055 | 6 Hmm, never tried this configuration before, so let's try to think in router's mind:
In GRE/IPsec case, when a packet comes in, router does ip lookup, next hop is GRE tunnel, so router encap's original packet with IP-GRE header, which subsequently triggers IPsec before the packet is placed on wire, the sequence makes perfect sense to me.
Now with IPsec/GRE case, when a packet comes in, it does route lookup, next hop has to be a tunnel interface in order to solve LZ's original problem, but then ro... 阅读全帖 |
|
v****n
发帖数: 7841 | 7 买了本书看了几遍还是没入门。。mail-list发了也没人回。。我之前freeswitch用的
还比较熟吧，拿到opensips完全不知道咋上手。。
下面直接quote我在mail-list上发的，英文应该更清晰一些。。
请不吝赐教。。
What is the simplest way to bridge a call based on username and domain?
I was trying to make a simple experiment I used to do in Freeswitch,
==========================
Have 1000,1001,1002 registered,
When 1000 calls 9999, the calls will be bridged to 1001 or 1002 based on
different time period.
==========================
While in Freeswitch, it would be as simple as "bridge xxxx... 阅读全帖 |
|
s******v
发帖数: 4495 | 8 router在lookup EID找到LOCATOR,这个可行吗？岂不是把routing table放到一个
centralized地方，通过udp/tcp在lookup？ |
|
s******v
发帖数: 4495 | 9 router在lookup EID找到LOCATOR,这个可行吗？岂不是把routing table放到一个
centralized地方，通过udp/tcp在lookup？ |
|
r*****l
发帖数: 2859 | 10 JVM definitely does not do 'lookup'. At least it can calculate
the hash of String literal and store the literal according to
the hash value. That's constant time operation. And that may
be just the JVM has to do anyway.
"If s2 ends up having exactly "Hello World", would that be the same entry in
the pool? To achieve that, the JVM would have to do a lookup after _every_
concatenation, which is probably more inefficient than allocating a new
buffer." |
|
r*****l
发帖数: 2859 | 11 You can use lookup method and put your switch there. If you queryer is not a
singleton, then this is not the expected use of lookup method though. |
|
c******n
发帖数: 4965 | 12 yes, I only care about my tests on the local box.
the script is used in the context of JMX, please see my previous JMX post.
what I don't understand is basically how kernel is able to properly route
the response packet. it's probably easier to use a plain NAT example.
let's say my box is in a private network ,
my_box 192.168.1.2
||
||
\ /
\/
gateway_box 192.168.1.1 , public_ip : 111.222.333.888
||
||
\ /
\/
yahoo.com 111.222.333.444
on a regular NAT case, my_box sends to yahoo.com, the packe... 阅读全帖 |
|
N********n
发帖数: 8363 | 13 if 32-bit, then build a lookup table of 256 elements. Lookup 4
times you get the answer. |
|
b***y
发帖数: 2799 | 14 ☆─────────────────────────────────────☆
OverCloud (天马行空) 于 (Tue Mar 27 16:55:30 2007) 提到:
用的os没有itoa. 只好自己写了一个.
char * itoa(unsigned i, char *str, int redex)
{
static const char *LOOKUP = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
char holder;
char *p1, *p2;
if(redex > 0 && redex < sizeof(LOOKUP)/sizeof(char))
{
if (i == 0)
{
str[0] = '0';
str[1] = '\0';
}
else
{
p1 = str;
|
|
b***y
发帖数: 2799 | 15 ☆─────────────────────────────────────☆
crystalike (Vader) 于 (Mon Sep 26 16:46:54 2005) 提到:
I sort of remember that there is a occation that you have to use
this pointer to access the member func in a template class.
this->foo () ...
just can not remember exactly how and why?
anyone got the idea?
☆─────────────────────────────────────☆
pptwo (pp) 于 (Mon Sep 26 17:50:42 2005) 提到:
http://gcc.gnu.org/onlinedocs/gcc-4.0.1/gcc/Name-lookup.html#Name-lookup
☆───────────────────────────────── |
|
t****t
发帖数: 6806 | 16 compile有很多步骤的
新一点的的编译器会先检查语法, 做name lookup, dependent name会在name lookup时
忽略 |
|
t****t
发帖数: 6806 | 17 name lookup和overload resolution是分开的两步. 如果name lookup找到的不全是同
一个子类来的member, 那就是ambigious.
不一 |
|
c***d
发帖数: 996 | 18 先看个video:
http://www.youtube.com/watch?v=hEqQMLSXQlY
他主持的一个系统，replication策略我觉得和hdfs有重复， 我就问为什么不直接架在
hdfs上作。这位大哥大概是这么解释的：
hdfs的metadata management其实是single point of failure，确实可以用backup
namenode来改善，但这不是问题的根本。问题的根本是distributed storage的
replication information不应该用lookup 来解决，而应该用比较robust的hash
function。那会不会不elastic呢？ 确实有这个问题，这个问题的关键在于，系统本身
要有一个作elastic logic的controller, 随时得到整个系统的信息。 当有node增加进
来或者fail掉，elastic logic controller会根据这个当前情况计算出理想的
distribution, 并开始移动block。移动block是copy and delete, 系统在近opti... 阅读全帖 |
|
w****o
发帖数: 2260 | 19 【 以下文字转载自 JobHunting 讨论区 】
发信人: winhao (勇敢的人), 信区: JobHunting
标 题: 弱弱的问问hash, hashtable?
发信站: BBS 未名空间站 (Wed Mar 7 22:13:29 2012, 美东)
大概知道hash, hashtable的概念，主要是为了快速的lookup。
可是如果面试的时候被问到hash, hashtable,通常他们要考核的是什么？是要实现一个
好的hash fuction呢？还是要实现一个hashtable的class?
平时自己写代码的时候如果要用到一个hashtable,是不是可以用C++ STL tr1/
hashtable来当做一个hashtable?
看了下面的链接，说是C++新的标准定义了四类hashtable,分别叫 unordered_set,
unordered_map, unordered_multiset, unordered_multimap.这些是通常意义上的
hashtale吗？
http://en.wikipedia.org/wiki/C%2B%2B0x
这个... 阅读全帖 |
|
t****t
发帖数: 6806 | 20 well, if you say "argument dependent lookup", it's easier to remember and
communicate. "Koenig lookup" is more like question of 回字有几种写法. |
|
t****t
发帖数: 6806 | 21 well, if you say "argument dependent lookup", it's easier to remember and
communicate. "Koenig lookup" is more like question of 回字有几种写法. |
|
|
|
g*****g
发帖数: 34805 | 24 What kind of lookup do you expect? Person->location lookup, reverse, or both? |
|
w**z
发帖数: 8232 | 25 你可以有一个global lookup table，纪录哪个user 去哪个shard， 但是user 多了，
你这个lookup table 的db scale 会有问题。或者在generate user id 的时候把shard
number 放进去。查询的时候，自己解析一下。
查content 的话需要Full text search engine 了， 有很多choice， 自己研究一下吧。
and |
|
|
|
F****n
发帖数: 3271 | 28 就是给lookup table型的索引用的
类似trick一维也有, lookup table不支持range query (e.g., b-tree)
但可以把数据转成整数然后encode成trie, 然后index所有prefixes
Lucene的range query基本上就是这么实现的 |
|
d******c
发帖数: 2407 | 29 R的设计一开始就是vector，单个元素也是长度为1的vector，许多函数可以接受vector
输入，产生vector输出，这样你根本不需要filter
v > 1 就能产生一个logical vector，然后用它去index就行了
v[v>1]
named vector可以用来做lookup table，也是直接按name index，就能做到lookup转换。
R设计上聪明的东西是很多的，还有method dispatch等等。
R的package尤其是做的很好，用惯了之后再比较python的库，安装，依赖，自己做
package方面都强很多。 |
|
l**********y
发帖数: 503 | 30 现在看到很多公司都要求什么：a great knowledge of excel (e.g. v-lookups)is a
must.
我都不知道什么是v-lookup.请哪位前辈能否上传一本好的excel的书
还有有的公司说要掌握intermediate excel. 这是什么啊？
非常感谢！ |
|
L***4
发帖数: 13 | 31 It depends on many factors - the size of base table/lookup table(s), your
CPU/IO/Memory capability, and the programming needs. Typically if the size
of larger dataset is below 1G, whatever methods are fine - I choose the
method easy to write and read. Otherwise, I will try to avoid sorting the
large data (if you have to sort, split sort or hash sort will use less
resource), for example, if base table is huge and there are several small
lookup tables, I like SET KEY. if you have two huge data and |
|
G*****u
发帖数: 1222 | 32 你可以尝试用vba写一个lookup function
大概的思路就是用vba找出数据的最后一列用在lookup function里
大概就是modifyvlookup(lookup_value, start_cell, end_column, search_column)
一般的vlookup是vlookup(lookup_value, range, search_column, false)
你这里就用end_column找处在这个column的最后一个cell 也就是end_cell 用start_
cell:end_cell替代range
这个code可以找出在end_column最后一个cell的row:
Cells(65536, column_number).End(xlUp).Row |
|
r****t
发帖数: 10904 | 33 These are in my sip.conf
srvlookup=yes ; Enable DNS SRV lookups on outbound calls
; Note: Asterisk only uses the first host
; in SRV records
; Disabling DNS SRV lookups disables the
; ability to place SIP calls based on domain
; names to some other SIP users on the
Internet
; Specifying a |
|
m****m
发帖数: 2452 | 34 LOG在下面，有没有人帮看一下？看上去好像是DIALPLAN的问题？
Connected to Asterisk 1.6.2.6 currently running on JackPBX (pid = 1946)
Verbosity was 0 and is now 5
== Using SIP RTP TOS bits 184
== Using SIP RTP CoS mark 5
-- Executing [0019100000002@from-internal:1] ResetCDR("SIP/101-00000000"
, "") in new stack
-- Executing [0019100000002@from-internal:2] NoCDR("SIP/101-00000000", "
") in new stack
-- Executing [0019100000002@from-internal:3] Progress("SIP/101-00000000"
, "") in new stack
-- Executing ... 阅读全帖 |
|
r****t
发帖数: 10904 | 35 externip 里面用 hostname 只在 reload sip.conf 的时候 lookup 一次。hostname
变了就没辙了。一定要用 hostname 需要用
externhost=foo.dyndns.net （这个每次都 lookup ip)
sip.conf 里面的 comments 你读了么？ |
|
v****n
发帖数: 7841 | 36 买了本书看了几遍还是没入门。。mail-list发了也没人回。。我之间freeswitch用的
还比较熟吧，拿到opensips完全不知道咋上手。。
下面直接quote我在mail-list上发的，英文应该更清晰一些。。
请不吝赐教。。
What is the simplest way to bridge a call based on username and domain?
I was trying to make a simple experiment I used to do in Freeswitch,
==========================
Have 1000,1001,1002 registered,
When 1000 calls 9999, the calls will be bridged to 1001 or 1002 based on
different time period.
==========================
While in Freeswitch, it would be as simple as "bridge xxxx... 阅读全帖 |
|
|
C********g
发帖数: 9656 | 38 切莫被假象欺骗--为什么要警惕方舟子
作者：北冥鱼 文章发于：乌有之乡
2010年，是方舟子声名鹊起的一年。经过方舟子遇袭事件的炒作，在央视等主流媒体的
舆论轰炸下，方舟子成为家喻户晓的偶像型的“打假斗士”。
2010年8月29日，方舟子遇袭事件报案之后，包括中央电视台和人民日报在内的主流媒
体特别是各大网络媒体掀起了铺天盖地的舆论大潮，对方舟子遇袭事件进行报道，声援
方舟子。方舟子遇袭案告破之前，各大媒体即采信了方舟子的说法，代替警方宣称方舟
子因打假被报复；案件告破之后，犯罪嫌疑人肖传国被抓获，主流媒体基本采用一边倒
地报道方肖矛盾，刻意把方舟子打造成一个打假英雄，把肖传国塑造成学术造假的败类
，对方肖十年之争中有利于肖传国而不利于方舟子的内容基本不予报道。
一方面中国主流媒体毫无客观和理性地支持方舟子，另一方面，方舟子背后很可能有美
国资本集团特别是生物资本集团的强大支持（见附件1 方舟子身份之谜）。所以人们不
得不怀疑，极有可能是美国资本集团特别是生物资本集团在调动媒体资源支持方舟子。
因为方舟子是美国生物资本在中国消灭中医、推广转基因主粮的首席打手。
回顾一下方舟子十年... 阅读全帖 |
|
|
|
o*****D
发帖数: 1563 | 41 每一笔交易，都是要经过若干步
根本不是一个lookup table就行
你这种动不动就搞personal的
觉得很low-class |
|
M********d
发帖数: 5274 | 42 lookup this ip 66.55.156.87 |
|
p****s
发帖数: 3184 | 43 “中央集权制大一统政体”有个屁“科学性”和“合理性”。
中央集权制，归根到底是基于tree数据结构的算法，中央就是root，蚁民是leafs，中
间的等级官僚是各层intermediates。
tree这种建模是万能的吗？哪个家伙万事都用tree来建模解决问题这人肯定就是个大傻。
network才是比tree更本质的对世界上事物的建模。
人体是细胞网络network of cells，人脑是神经元网络network of neutron cells。
互联网是路由器构成的网络network of routers，社会是人构成的网络network of
persons。
树也是网络的一种。
网络里情况较复杂，树只是其中很小的一类，根本没什么代表性。就和hypercube这种
网络一样，是比较极端的特例，可能在某些情况下其个别性能最佳（比如hypercube各
项指标都是均衡的O(lgn))，但总体性能未必好、甚至是坏成狗屁都很有可能。
举个例子，robustness和performance最好的name lookup server的结构是hypercube(
如CAN, Chord等其实... 阅读全帖 |
|
t********5
发帖数: 205 | 44 老板算第五大牛人么？吹嘘5大牛人有劲吗？
前面不说了吗，医生就是一个giant lookup table，死记硬背而已，基本没有什么创造
性。医生的性价比也差。象你这种国内的医学学士，来美国冒充MD，当千老时不务正业
去参加医学考试，现在都快四十岁了才好不容易要当intern了的loser，也只有吹嘘一
下5大牛人掩盖一下自己失败的人生了。 |
|
n*****t
发帖数: 22014 | 45 能显示全部 ip，但是我也可以屏蔽图片，不打开，或者打开图片链接前 reverse
lookup |
|
p*******m
发帖数: 20761 | 46 Delta to cancel order for 18 Boeing 787 Dreamliner aircraft
Reuters ReutersDecember 27, 201698 Comments
Delta planes line up at their gates while on the tarmac of Salt Lake City
International Airport in Utah September 28, 2013. REUTERS/Lucas Jackson/File
Photo
1 / 3
Delta planes line up at their gates while on the tarmac of Salt Lake City
International Airport in Utah
Delta planes line up at their gates while on the tarmac of Salt Lake City
International Airport in Utah September 28, 2013. RE... 阅读全帖 |
|
r*******5
发帖数: 3413 | 47 Lookups for volunteer are up 1900%.
怀疑人生的人真不少。 |
|
x****6
发帖数: 4339 | 48 纳什平衡就是一个系统的最优解，evolutionarily stable。但是把规则变复杂以后，
比如pay off不是简单的Lookup table, 而是一组概率分布，这个时候就不一定有
evolutionarily stable的解了。这是我从朋友那里大概理解来的，我自己并不做这个。 |
|
