Monday, 21 April 2014
Thursday, 10 April 2014
Sunday, 6 April 2014
Thursday, 3 April 2014
excel tutorial
drop-down list
http://office.microsoft.com/en-001/excel-help/create-a-drop-down-list-HA102809802.aspx
share workbook
http://www.excel-easy.com/examples/share-workbooks.html
protection
review->allow users to edit ranges -> protect sheet -> protect workbook -> share workbook
vlookup
VLOOKUP("cdsvf",A2:C10,3) vlookup("search",range,cell content x # to the right of the found)
networkdays
=NETWORKDAYS(A4,B4) networkday(start date(dd/mm/yy),end date, holiday) exempt holiday weekend
concatenate
=A7&B7&C7 x&y&z = xyz
rank
=RANK(A11,$A$11:$A$15) rank(selected value, fixed range)
filter
advanced filter->copy to another location->unique->filter out replica
subtotal
sort(expand section)->at each change in sorted column->use function->add subtotal to column displays subtotal
http://office.microsoft.com/en-001/excel-help/create-a-drop-down-list-HA102809802.aspx
share workbook
http://www.excel-easy.com/examples/share-workbooks.html
protection
review->allow users to edit ranges -> protect sheet -> protect workbook -> share workbook
vlookup
VLOOKUP("cdsvf",A2:C10,3) vlookup("search",range,cell content x # to the right of the found)
networkdays
=NETWORKDAYS(A4,B4) networkday(start date(dd/mm/yy),end date, holiday) exempt holiday weekend
concatenate
=A7&B7&C7 x&y&z = xyz
rank
=RANK(A11,$A$11:$A$15) rank(selected value, fixed range)
filter
advanced filter->copy to another location->unique->filter out replica
subtotal
sort(expand section)->at each change in sorted column->use function->add subtotal to column displays subtotal
Wednesday, 2 April 2014
加国最理想想就业城市 前四名都在阿省
卡城华人网】俗话说,就业乃民生之本,嗯,就业很重要。也有句话说得好,选择大于努力。无论是职场菜鸟,还是职场达人,努力都必不可少,但就业地点选择得当的话,会让自己的努力开出更妖娆的花。不妨参考下面的最理想市的就业城市排行榜,在找工作时做到“弃暗投明”,争取让自己的知识和技能创造出最大的价值。
1. Grande Prairie(阿省)
登载职位的平均工资:$56,265
每个岗位的求职人数:1.38
2.红鹿市(阿省)
登载职位的平均工资:$56,040
每个岗位的求职人数:1.77
3.埃德蒙顿
登载职位的平均工资:$56,494
每个岗位的求职人数:2.15
4.卡尔加里
登载职位的平均工资:$62,081
每个岗位的求职人数:2.31
5.莱斯布里奇(阿省)
登载职位的平均工资:$52,758
每个岗位的求职人数:2.91
6.哈利法克斯
登载职位的平均工资:$39,045
每个岗位的求职人数:3.18
7. 萨斯卡通
登载职位的平均工资:$52,719
每个岗位的求职人数:3.24
8. Regina
登载职位的平均工资:$47,700
每个岗位的求职人数:3.27
9. 温尼伯
登载职位的平均工资:$46,393
每个岗位的求职人数:3.61
10.多伦多
登载职位的平均工资:$56,066
每个岗位的求职人数:4.09
1. Grande Prairie(阿省)
登载职位的平均工资:$56,265
每个岗位的求职人数:1.38
2.红鹿市(阿省)
登载职位的平均工资:$56,040
每个岗位的求职人数:1.77
3.埃德蒙顿
登载职位的平均工资:$56,494
每个岗位的求职人数:2.15
4.卡尔加里
登载职位的平均工资:$62,081
每个岗位的求职人数:2.31
5.莱斯布里奇(阿省)
登载职位的平均工资:$52,758
每个岗位的求职人数:2.91
6.哈利法克斯
登载职位的平均工资:$39,045
每个岗位的求职人数:3.18
7. 萨斯卡通
登载职位的平均工资:$52,719
每个岗位的求职人数:3.24
8. Regina
登载职位的平均工资:$47,700
每个岗位的求职人数:3.27
9. 温尼伯
登载职位的平均工资:$46,393
每个岗位的求职人数:3.61
10.多伦多
登载职位的平均工资:$56,066
每个岗位的求职人数:4.09
e-tap tutorial
asc: the maximum electricity you can draw from the grid (kVa)
x/R: X/R fault = (Xutil + X txmr) / (Rutil + Rtxmr )
pf: ratio of the real power flowing to the load, to the apparent power
FLA: Full load amperes
generator mode of operation:
swing: output power change based on load demand
voltage, Mvar control: output power fixed
http://www.linkedin.com/groups/generator-modes-operation-3868394.S.231236684
TCC: In order to determine the proper setting for the Overcurrent protective devices they are plotted on
time-current curve graphs (TCCs). The time-current characteristics of properly coordinated devices will not overlap on a TCC graph.
http://www.graybar.com/documents/short-circuit-coord-arcflash-studies.pdftudies.pdf
sequence:
http://www.electrical4u.com/electrical-fault-calculation-positive-negative-zero-sequence-impedance/
https://www.eiseverywhere.com/file_uploads/a4f0ea9ba5ebe8baf31cba17ff378633_SymmetricalComponents_2013.pdf
transformer short circuit:
https://www.theseus.fi/bitstream/handle/10024/63334/Transformer%20Short%20Circuit%20Current%20Calculation%20and%20Solutions.pdf?sequence=1
thevenin equivalent:
Calculate the output voltage, VAB, when in open circuit condition (no load resistor—meaning infinite resistance). This is VTh.
Calculate the output current, IAB, when the output terminals are short circuited (load resistance is 0). RTh equals VTh divided by this IAB.
The equivalent circuit is a voltage source with voltage VTh in series with a resistance RTh.
electricity glossary:
http://www.nooutage.com/glossary.htm#F
http://www.scribd.com/doc/43403406/ETAP-Training-Manual
http://www.powerqualityworld.com/2011/05/etap-tutorials-load-flow-analysis.html
x/R: X/R fault = (Xutil + X txmr) / (Rutil + Rtxmr )
pf: ratio of the real power flowing to the load, to the apparent power
FLA: Full load amperes
generator mode of operation:
swing: output power change based on load demand
voltage, Mvar control: output power fixed
http://www.linkedin.com/groups/generator-modes-operation-3868394.S.231236684
TCC: In order to determine the proper setting for the Overcurrent protective devices they are plotted on
time-current curve graphs (TCCs). The time-current characteristics of properly coordinated devices will not overlap on a TCC graph.
http://www.graybar.com/documents/short-circuit-coord-arcflash-studies.pdftudies.pdf
sequence:
http://www.electrical4u.com/electrical-fault-calculation-positive-negative-zero-sequence-impedance/
https://www.eiseverywhere.com/file_uploads/a4f0ea9ba5ebe8baf31cba17ff378633_SymmetricalComponents_2013.pdf
transformer short circuit:
https://www.theseus.fi/bitstream/handle/10024/63334/Transformer%20Short%20Circuit%20Current%20Calculation%20and%20Solutions.pdf?sequence=1
thevenin equivalent:
Calculate the output voltage, VAB, when in open circuit condition (no load resistor—meaning infinite resistance). This is VTh.
Calculate the output current, IAB, when the output terminals are short circuited (load resistance is 0). RTh equals VTh divided by this IAB.
The equivalent circuit is a voltage source with voltage VTh in series with a resistance RTh.
electricity glossary:
http://www.nooutage.com/glossary.htm#F
http://www.scribd.com/doc/43403406/ETAP-Training-Manual
http://www.powerqualityworld.com/2011/05/etap-tutorials-load-flow-analysis.html
Subscribe to:
Posts (Atom)

