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




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

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