=9-MAX(ABS(9-ROW()),ABS(9-COLUMN())),这个函数的意思吗?

英语翻译
求翻译:The idea was that as one end of the column rose,the base would roll across the ground on a trolley.

$('th',$table).each(function( column )｛｝这些参数的意思?
这是对表格进行排序的一个jquery,
如下：
{
var $sortOrder = 0; //排序类型 1表示升序,0表示降序
var $table = $('table#shop');
$('th',$table).each(function( column )
{
//处理三种有可能存在的排序字段,比较方法
var findSortKey;
if( $(this).is('.sort-title') || $(this).is('.sort-author') )
{
findSortKey = function( $cell )
{
return $cell.find('.sort-title').text().toUpperCase()+ '' +$cell.text().toUpperCase();
}
}
else if( $(this).is('.sort-date') )
{
findSortKey = function( $cell )
{
return Date.parse('1' + $cell.text());
}
}
else if( $(this).is('.sort-price') )
{
findSortKey = function( $cell )
{
var key = parseFloat($cell.text().replace(/^[^d.]*/,''))
return isNaN(key) 0 :key;
}
}
//排序
if( findSortKey )
{
$(this).addClass('clickable').hover(function()
{
$(this).addClass('hover');
var $title = $sortOrder == 0 '升序' :'降序';
$(this).attr('title','按'+ $(this).html() + $title +'排列');
},function()
{
$(this).removeClass('hover');
}).click(function()
{
$sortOrder = $sortOrder == 0 1 :0;
var rows = $table.find('tbody > tr').get();
$.each( rows,function( index,row )
{
row.sortKey = findSortKey($(row).children('td').eq(column));
});
//排序方法
rows.sort(function( a,b )
{
if( $sortOrder == 1 )
{
//升序
if(a.sortKey < b.sortKey) return -1;
if(a.sortKey > b.sortKey) return 1;
return 0;
}
else
{
//降序
if(a.sortKey < b.sortKey) return 1;
if(a.sortKey > b.sortKey) return -1;
return 0;
}
});
//排序后的对象添加给$table
$.each( rows,function( index,row )
{
$table.children('tbody').append(row);
row.sortKey = null;
});
$table.find('td').removeClass('sorted')
.filter(':nth-child('+ (column + 1) +')').addClass('sorted');
//重新赋予奇偶行的样式
$table.alterRowColors();
});
}
});
});

IF(ISNA(INDEX(INDIRECT("'"&$A5&"'!"&CHAR(COLUMN()+68)&":"&CHAR(COLUMN()+68)),MATCH($B$3,INDIRECT("'"&$A5&"'!$E:$E"),0))),0,INDEX(INDIRECT("'"&$A5&"'!"&CHAR(COLUMN()+68)&":"&CHAR(COLUMN()+68)),MATCH($B$3,INDIRECT("'"&$A5&"'!$E:$E"),0)))

英语翻译
The heart of the installation is the absorption column.The
design of the absorption column and the gas/slurry flow patterns
can vary from one installation to another [2].There are
four main designs:packed column (co-current flow),spray absorber
(countercurrent flow),jet bubbling reactor,and doubleloop
spray absorber (co-current and countercurrent flow).
To improve the degree of desulphurization,which is the
most important target of FGD plants,many lab-scale experiments
have been investigated [3–11].Although the degree of
desulphurization has been investigated for years,a further
more elaborate study is still needed.Previous researchers
usually employed a conventional one-factor-at-a-time experimental
design.Effects of the operating parameters,such as
slurry pH,liquid/gas ratio (L/G),flue gas temperature (T),fluegas velocity (v),etc.,were discussed individually and provided
with qualitative descriptions.That way,readers have no idea
which parameter is dominant or how significant it is.In truth,
it is a less appropriate strategy when conducting a multi-parameter
experiment.It should be noted that the dependency of
the objective function on a parameter could vary under different
conditions.However,the conventional strategy usually
jumps to a conclusion merely based on a given operating condition.
It is also impossible to find out potential interactions
between parameters,which often count.

请解释一下excle这些语句,
=INDIRECT("'"&INT(COLUMN()/4)&"'!"&CHAR(85+MOD(COLUMN(),4))&MATCH($B29,INDIRECT("'"&INT(COLUMN()/4)&"'!D1:D1000"),))
.

学校网站新开设了一个”英语写作”栏目(column),以便学生发表(post)英语作文,进行交流,提高写作能力.请你为该栏目写一个英文作文,内容应包括:开设目的;优秀作文的鼓励办法;邀请大家参与;作文投稿要求:内容贴近学生生活.开头已给出:Welcome to the column“English writing”!词数不少于80字

excel中用这个公式=vlookup(a3,$a$30:$ae$1029,column(),0) 时公出现某个值对于就个公式不可用?
------A-------B-------C-------D------
1、283 015
2、 #N/A问题是这样的：我用公式=RIGHT(LEFT(A1)+MID(A1,2,1))*100+RIGHT(MID(A1,2,1)+MID(A1,3,1))*10+RIGHT(LEFT(A1)+MID(A1,3,1))计算出A1中的三个数283的两数之和后.由于前面有0.在用公式=vlookup(a3,$a$30:$ae$1029,column(),0)自动填充数时出现：#N/A显示为：某个数值对于这个公式不可用.当前面的那个数百位为0时就出现这种情况.前面不是0时就没有错误.不知为什么.怎么办?谢谢!
015对应的数：2570893461在第45行.
用了方括号的公式后前面是0的数可以正确填充了.但其他的数又出现了前面的错误.

c.i.是什么意思?
The X designation in the 7th column of the simulation tables refers to the half-width of the 95% c.i.
求这句话的翻译?

=LEFT(RIGHT(" ￥"&SUM($E14)*100,39-COLUMN(AB9)))这个公式我想在然面加上一个IF函数,IF E14=0,则返回
这个公式我想在然面加上一个IF函数,IF E14=0,则返回空值,应当怎么样把IF用上去啊,求解答,

阅读理解翻译：
the teacher said : in the right-hand column we have units of one,the two in that coiumn counts for two ones ,the zero in the center counts for zero ten,the two in the left-hand column counts for hundreds.
这是一个关于算数学题的阅读理解,207减去179,这段具体怎么翻译呢,我看到有翻译答案知道里.但是不准确,所以有明白的帮下忙,不会的,粘贴的,在线翻译的该忙啥忙啥.

英语翻译
1.The intersection of a row and column in a spreadsheet.
2.A collection of two or more cells in a spreadsheet.
3.Instructions for calculations.
4.Spreadsheet feature in which changing one or more numbers results in the automatic recalculation of all related fields.
5.A widely used database structure,in which data is organized into related tables.

求助完成以下英语匹配
Match the word in Column A with the words or phrases in Column B.
Column A
1.improve
2.spread
3.demand
4.lead
5.share
6.offer
7.hold down
8.focus on
9.lift
10.cede
11.raise
12.accept
Column B
a.a note
b.the noise
c.a distant object
d.the right
e.seeds
f.the embargo
g.a question
h.the Allied forces
i.one’s help
j.the profit
k.working conditions
l.territory

一共四个,
五、Writing
1.学校网站新开设了一个“英语写作”栏目（column）,以便学生发表（post）英语作文,进行交流,提高写作能力.现请你为该栏目写一个英文介绍,内容包括：
x05开始目的
x05栏目优势：教师在线（online）指导等
x05作文要求：内容贴近学生生活
x05优秀作文的鼓励办法
x05邀请大家参与
注意：1)词数80左右
2)开头已为你写好（不计入总词数）
Welcome to the column “English Writing”!
2.假写你是李华,从小喜爱大熊猫（panda）,一直通过有关网站（website）关注三年前在美国圣迭哥动物园出生的大熊猫“苏琳”和她母亲“白云”.现在苏琳即将三岁.请根据以下要点给动物园工作人员写一封信：
1)自我介绍；
2)祝贺苏琳生日；
3)感谢工作人员；
4)索取苏琳三岁生日照.
注意：1)词数80左右；
2)可以适当增加细节,使行文连贯；
3)开头语已为你写好.
Dear Sir/Madam,
Greetings from China!
3.实现有效的沟通,建立良好的人际关系,不仅要善于言表,更要学会倾听.请你根据下表中所提供的信息,写一篇题为 “Being a Good Listener” 的英文演讲稿.
为何倾听x05表示尊重,增进理解,建立良好的人际关系
谁来倾听x05家长倾听孩子x05理解孩子,消除代沟,……
x05老师倾听学生x05了解学生,满足需求,……
x05同学相互倾听x05增进友谊,互帮互学,……
怎样倾听x05（请联系自己拟定内容,列举两至三点.）
注意：
1)对所给要点,逐一陈述,适当发挥,不要简单翻译.
2)词数100左右.开头和结尾已经写好,不计入总词数.
Good afternoon,everyone!
The topic of my speech today is “Being a Good Listener”.
4.假如你是卜曼宜,你购买了一部某外国公司生产的手机,因有质量问题,要求该公司更换.请根据下列要点,用英文写一封电子邮件.
　　要点：
手机不响铃,不能发短信；
　　该产品已售完,无法更换；
型号新,无配件,无法维修.
　　2)要求：公司应尽快予以更换
　　注意：1)词数为80左右
2)参考词汇：配件 ——spare part
3)电子邮件的开头和结尾已为你写好（不计入你所写词数）；
Dear Sir,
I am writing to you for the mobile phone of Dephone-S250 I bought on 20th Apr.2008 at Tele Mall in Wuhan,P.R.China
　　Thank you for your consideration.
　　Sincerely yours
Bu Manyi

用words.match.those.the.column.b.in.column.a.with
in.组成一个句子

EXCEL 公式：=INDIRECT("sheet2!"&ADDRESS(ROW(A1),(COLUMN(A1)-1)*3+1)) 的意思?
如题,请问在上述公式中的各个部分是什么意思?改动后有何结果,可以再加分,

关于公式=SUMPRODUCT((A1:A4=A1)*N(OFFSET($A$1,ROW(1:4)-1,COLUMN(A:C)*2-1))*I1:I4)中N函数的作用
高手请指教,
公式=SUMPRODUCT((A1:A4=A1)*N(OFFSET($A$1,ROW(1:4)-1,COLUMN(A:C)*2-1))*I1:I4)中N的作用应该是把非数值类的值转换为数值,但是当我选中OFFSET($A$1,ROW(1:4)-1,COLUMN(A:C)*2-1)),F9抹黑时,计算出来的是数值串,于是去掉N函数,结果就值错误了,所以想请教你N在这里面具体的作用,

关于and的用法
The column chart above clearly reflects the mobile-phone subscription from 2000 to 2008 and we can see a striking contrast between developing and developed countries.
请问中间的那个and用的对吗？这个句子不存在语法错误吧

=MOD(-LARGE(COUNTIF($B2:$D6,ROW($1:$9))*10-ROW($1:$9),COLUMN(A1)),10)
本来是想对1~9在进行出现次数由多到少的排列,但我想不通为什么会用MOD函数!
如果换成是1~22,我把“$9”改成“$22”,这样算下来的结果却不对了,这是为什么呢?
希望高手帮帮小弟!

write.each word above in the correct column below
什么意思

英语翻译
Match thr words in column A wit those in column B Which have a similar meaning

帮我改一篇雅思的小作文好吗
Given are two column graphs concerning the reasons for study and employer support in different age.
It is apparent from the information supplied that a host of people under 39 years old study because of career.In stark contrast,however,the rate of studying for interest climbs,to somewhere in the vicinity of 40 percent over forty years old,and is equal even outnumbers to career.
Employer support rate,meanwhile,saw a decline from approximately 60 percent to 30 percent under 30,was followed by a growth from virtually 30 percent to over 40 percent after 30 years old.
Also noteworthy is the fact that older human are,more focus on finding a job with his/her own interest.
从来没有人给我评过分,我也不知道自己的水平到底在哪,需要如何改进,希望各位能帮我改一下这篇文章,顺便大概评一下分,

=IF($Q17=0,0,INDIRECT(ADDRESS(ROW(),COLUMN()-2,"仕入_"&$Q17))) 求助解释前面这个公式.
如果Q17不等于0之后的那一串,特别是-2,这一部份.

我用您提供的公式=SUMPRODUCT((MOD(COLUMN(B5:BP5),2)=0)*B$5:BP$5*B6:BP6)计算时,如果B5至BP6单元格区域中间没有非数字的内容是可以计算的,也能复制.但我的公式中B5至BP6单元格区域中间有非数字的内容,改用您提供的=SUM(IF(MOD(COLUMN(B5:BP5),2)=0,B$5:BP$5*B6:BP6))这个公式任然会出现错误#VALUE!是怎么回事呢?

英语翻译
lack of strong column/weak beam design approach.A capacity design
approach was not followed in the design of the beam flexural reinforcement,as
the beams were generally designed for the code level forces.The effects of post-
yield behavior were not considered,thus increasing the chances for undesirable
shear failure in either the beams or columns.Shear failure is rather brittle and
sudden,and should be avoided in reinforced concrete structures located in
seismic zones.

英语翻译
The second column of Table 2 presents the OLS regression results and incorporate White-corrected
standard errors to correct for heteroscedasticity.The results show that the more capacity a firm
commits the less aggressively it bids in an auction.The effect of backlog on bids is small but consistent with the theory in Pitchik and Schotter (1988) that attributes less aggressive bidding to
budgetary restrictions.It is also consistent with the findings Jofre-Bonet and Pesendorfer (2000).
Looking at the afternoon bidding dummies,we find that firms that win in the morning bid more
aggressively in the afternoon.However,it is probably the case that our measure of backlog is not fully
controlling for differences in firm efficiencies and that the negative coefficient on this variable reflects
differences in overall efficiencies (winners vs.losers) as opposed to differences in the bidding
behavior in the morning and afternoon.To correct for this potential,we estimate the model withfirm-time period effects.As discussed above,these effects should control for differences in
unobserved heterogeneity across firms on a given auction day.In contrast to the OLS results which
exploit cross firm variation in bids,the fixed effects results allow for a comparison of bidding
behavior in the morning and afternoon for a given bidder.The results are presented in column 3.The
findings suggest that,on average,those firms that lost in morning sessions bid more aggressively,
relative to their morning bid,than those firms that won at least one project.The winners of early
auctions are typically the stronger bidders and conditional on the outcome of early auctions,the weak
bidders (i.e.the morning losers) adjust their strategies and bid more aggressively in afternoon
auctions.In addition,the fixed effects results suggest that the more competitive the set of rivals a firm
faces the more aggressively the firm bids.These results are consistent with the prediction in Maskin
and Riley,(2000,proposition 3.5) which suggests that if a weak bidder faces a strong bidder rather
2 than another weak bidder he will bid more aggressively and vice versa.

请问“栏目”这个词翻译成英文是什么?column?
不是指电视栏目，频道什么的
是指网站上各个不同的介绍页面

column和pillar的区别?
回答最好详尽生动一点

请问这个函数=INDIRECT(ADDRESS(4+COUNTIF($AF$5:$AF5,$AF5),COLUMN(),$AF5))里的$AF$5是什么意思?

=SUMPRODUCT((MOD(COLUMN(F9:AI9)-1,5)=MOD(COLUMN()-1,5))*F9:AI9)手忙,我不
我不知道MOD和COLUMN()是什么意思,还有后面的1和5是什么意思,不好意思我是刚刚入学不懂,

Match the words in column A with the explanations in column B.
Column A Column B
1. intimidate a.. easy to get to
2. online b. accept sth.as true
3. embarrassing c. give great pleasure to
4. aware d.connected to other computers through the internet
5. worth e. make sb feel embarrassed
6. believe f. create a feeling of fear
7. visual g.. become less tense; rest
8. convenient h.. good of useful enough to do or have
9. relax i. Having knowledge or understanding
10. delight j. relating to seeing
11. access k. Very unpleasant
12. reap l. a feeling of worry
13. benefit m. get sth.,esp.sth.good
14. disgusting n.. the right to have or use sth
15. concern o. be useful or helpful to
16. identity p. who or what a person or thing is
帮忙给个答案,谢谢了~

we have received so many letters for our friends' column,
and it may be some time ____ we can publish your letter.

A after B when C before

答案是C,为什么不是用when呢?before在这里做什么意思?

雅思 小作文 开头时态的问题
The two column graphs compare respectively why students of different age groups decide to study and how much support they receive in their employers.
decide要用decided么?还有receive 要用had received么?
一楼说的不理解啊……

英语翻译
You can normally identify a column(列) that violates this rule when it has non-key values that are the same in multiple rows.
google到处都是

in inner side of the right lower column installing right-angle求正确翻译

求大神翻译.一定要准确!拜托
Performance of fiber beam–column elements in the seismic analysis of a lightly reinforced shear wall

a column of ants triumphantly bearing home an enormous dead beetle.这里的an enormous dead beetle
做什么成分,bear是不是和go home一样的意思.

英语翻译
1.1 Reinforced Concrete Column
1.1.1 Types of columns
Columns are defined as members that carry loads chiefly in compression .Usually columns carry bending moment as well ,about one or both axes of the cross-section ,and the bending action may produce tensile force over a part of the cross-section .Even in such cases ,columns are generally referred to as compression members ,because the compression forces dominate their behavior .In addition to the common type of compression member ,i.e.,vertical elements in structures ,compression members include arch ribs ,inclined rigid frame members ,compression elements in trusses or shell .
Columns may be classified based on the following different categories:
(1) Base on loading ,columns maybe classified as follows:
a.Axially loaded columns ,where loads are assumed acting at the centroid of column section .
b.Eccentrically loaded columns ,where the loads are acting at a distance e from the centroid of column section .The distance e could be along the x or y axis ,causing moments either about the x axis or y axis .
c.Biaxially loaded columns ,where the loads are applied at any point on the column section ,causing moments about both the x axis and y axis simultaneously .
(2) Based on length ,columns can be classified as follows :
a.Short columns ,where the column's failure is due to the crushing of concrete or due to the yielding of the steel bars under the full load capacity of the columns .
b.Long columns (slender columns ) ,where the bucking effect and the slenderness ratio must be taken into consideration in the design ,thus reducing the load capacity of the column relative to that of a short column .
(3) Based on lateral reinforcement ,columns can be classified as follows (Figure 4.24) :
a.Columns reinforced with longitudinal bars and lateral ties .
b.Columns reinforced with longitudinal bars and continuous spirals .
c.Composite compression members reinforced longitudinally with structural steel shapes ,pipe ,or tubing ,with or without additional longitudinal bars ,and various types of lateral reinforcement .
The main reinforcement in columns is longitudinal ,parallel to the direction of the load ,and consists of bars arranged in a square ,rectangular ,or circular pattern .
Lateral reinforcement ,in the form of individual relatively widely spaced ties or a continuous closely spaced spirals ,serves several functions .For one ,such reinforcement is needed to hold the longitudinal bars in positions in the forms while the concrete is being placed .For this purpose ,longitudinal and transverse steel are wired together to forms cages ,which are then moved into the forms and properly positioned before placing concrete .For another ,transverse reinforcement is need to prevent the highly stressed ,slender longitudinal bars from bucking outward by bursting the thin concrete cover .

I am writing to your magazine's 'Teenagers Now' column to ask for some help with my 16-year-old son

英语翻译
Match the verbs in column A with the words in column B .Then use the phrases tocomplete the sentences.

帮我看看这篇雅思小作文,
剑5 Test2 Task 1
Illustrated are two column graphs,showing the two reasons for learning among students of five age groups (under 26-over 49) and the support situation by employers.
It shows a moderately decline of students which study for career with age.There are 80% students (under 26 yr olds) that learning for career which is approximately four times than the students over 49 yr olds.However,with the increase of age,the trends of students that study for interest describe a colossal rise,from a paltry 10% (under 26) to a tremendous 70% (over 49).Coincidently,in the age group 40-49,both of the two reasons are account for 40% of total.
When it refers to the proportion of employer support,it drops from the acme at hefty 62% in the group (under 26) to the rock bottom at a meagre 32% (30-39),which is ahead of a bounce.
Most important of all,if the two charts are considered as a total,readers may find that the high percentage of students (for career) in the age group (under 26) is entwined with strong employer support.
感谢看看能得几分啊

在excel中的B18公式是SUM(OFFSET($A18,1-COLUMN(C17))),C18是SUM(OFFSET($A18,1-COLUMN(D17))).
H19是=ABS(INDEX($C:$C,ROW(A17)-COLUMN(A7))),i19是=ABS(INDEX($C:$C,ROW(B17)-COLUMN(B7))),我希望A19如果是空的,在B19就自动填入H19单元格的公式值,不是空白就自动填入=SUM(OFFSET($A19,1-COLUMN(C18)))的公式值,我用=IF(A19="",ABS(INDEX($C:$C,ROW(A17)-COLUMN(A7))),SUM(OFFSET($A19,1-COLUMN(C18))))还是有问题,但是一行的也要往下拉